API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 86.58 KB | None | 0 0
raw download clone embed print report
  1. //RECREATED ISSUE - LOGS
  2. 2018-12-11 17:52:35.848 INFO 23032 --- [nio-8000-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/] : Initializing Spring FrameworkServlet 'dispatcherServlet'
  3. 2018-12-11 17:52:35.848 INFO 23032 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : FrameworkServlet 'dispatcherServlet': initialization started
  4. 2018-12-11 17:52:35.865 INFO 23032 --- [nio-8000-exec-1] o.s.web.servlet.DispatcherServlet : FrameworkServlet 'dispatcherServlet': initialization completed in 17 ms
  5. 2018-12-11 17:52:35.939 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: createNewBatch
  6. 2018-12-11 17:52:35.939 DEBUG 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : Collateral Batch: class CollateralBatch {
  7. batchReferenceNum: null
  8. bank: class Bank {
  9. bankId: 1
  10. bankCode: BPI
  11. bankEntity: null
  12. deleteFlag: false
  13. bankName: Bank of the Philippine Islands
  14. bankStatus: Operating
  15. dateJoined: 1999-05-21
  16. bankAddress: Gapan Nueva Ecija
  17. dateClosed: null
  18. refBalanceId: 1
  19. refBankTypeId: 2
  20. cwtFlag: true
  21. deleteFlag: false
  22. bankResolutionNo: null
  23. }
  24. approvalStatus: null
  25. creditFacility: class CreditFacility {
  26. creditFacilityId: 23
  27. creditFacility: null
  28. }
  29. documentaryRequirements: null
  30. dateCreated: null
  31. userName: Mark.Nipes
  32. lastUpdateUser: null
  33. lastUpdateTimestamp: null
  34.  
  35. 2018-12-11 17:52:35.941 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.v.CollateralBatchChecker : MCI: checkForCreation
  36. 2018-12-11 17:52:35.941 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.v.CollateralBatchChecker : MCO: checkForCreation
  37. 2018-12-11 17:52:35.942 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.session.MyBatisHelper : MCI: executeTransaction
  38. 2018-12-11 17:52:35.943 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  39. 2018-12-11 17:52:35.943 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  40. 2018-12-11 17:52:36.221 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  41. 2018-12-11 17:52:36.221 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  42. 2018-12-11 17:52:36.221 INFO 23032 --- [nio-8000-exec-1] gov.bsp.lcmis.collaterals.dao.BatchDao : MCI: createNewBatchOnSession
  43. 2018-12-11 17:52:36.602 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.BatchMapper.createNewBatch : ==> Preparing: SELECT batch.batch_reference_number, batch.ref_bank_id as bank_id, batch.ref_approval_status_id, batch.credit_facility_id as cf_facility_id, batch.date_created as DATE_CREATED, batch.user_id as USER_ID, batch.lst_update_usr as LST_UPDATE_USR, batch.lst_update_tms as LST_UPDATE_TMS FROM FINAL TABLE ( INSERT INTO collateral_batch (batch_reference_number, ref_bank_id, ref_approval_status_id, credit_facility_id, date_created, user_id, lst_update_usr, lst_update_tms) SELECT CONCAT('_.', CONCAT(YEAR(SYSDATE),LPAD(COLLATERAL_BATCH_REFERENCE_NUMBER_SEQ.NEXTVAL, 6, '0'))), ?, 1, ?, CURRENT TIMESTAMP, users.user_id, users.user_id, CURRENT TIMESTAMP FROM user_tbl users WHERE users.user_name = ? ) AS batch
  44. 2018-12-11 17:52:36.628 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.BatchMapper.createNewBatch : ==> Parameters: 1(Integer), 23(Integer), Mark.Nipes(String)
  45. 2018-12-11 17:52:36.671 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.BatchMapper.createNewBatch : <== Total: 1
  46. 2018-12-11 17:52:36.672 DEBUG 23032 --- [nio-8000-exec-1] gov.bsp.lcmis.collaterals.dao.BatchDao : Create new batch: class CollateralBatch {
  47. batchReferenceNum: _.2018000103
  48. bank: class Bank {
  49. bankId: 1
  50. bankCode: null
  51. bankEntity: null
  52. deleteFlag: null
  53. bankName: null
  54. bankStatus: null
  55. dateJoined: null
  56. bankAddress: null
  57. dateClosed: null
  58. refBalanceId: null
  59. refBankTypeId: null
  60. cwtFlag: null
  61. deleteFlag: null
  62. bankResolutionNo: null
  63. }
  64. approvalStatus: null
  65. creditFacility: class CreditFacility {
  66. creditFacilityId: 23
  67. creditFacility: null
  68. }
  69. documentaryRequirements: []
  70. dateCreated: 2018-12-11 09:52:03.743455
  71. userName: null
  72. lastUpdateUser: 13
  73. lastUpdateTimestamp: 2018-12-11 09:52:03.743455
  74.  
  75. 2018-12-11 17:52:36.672 INFO 23032 --- [nio-8000-exec-1] gov.bsp.lcmis.collaterals.dao.BatchDao : MCO: createNewBatchOnSession
  76. 2018-12-11 17:52:36.680 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.session.MyBatisHelper : MCO: executeTransaction
  77. 2018-12-11 17:52:36.680 DEBUG 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : Result :class CollateralBatch {
  78. batchReferenceNum: _.2018000103
  79. bank: class Bank {
  80. bankId: 1
  81. bankCode: null
  82. bankEntity: null
  83. deleteFlag: null
  84. bankName: null
  85. bankStatus: null
  86. dateJoined: null
  87. bankAddress: null
  88. dateClosed: null
  89. refBalanceId: null
  90. refBankTypeId: null
  91. cwtFlag: null
  92. deleteFlag: null
  93. bankResolutionNo: null
  94. }
  95. approvalStatus: null
  96. creditFacility: class CreditFacility {
  97. creditFacilityId: 23
  98. creditFacility: null
  99. }
  100. documentaryRequirements: []
  101. dateCreated: 2018-12-11 09:52:03.743455
  102. userName: null
  103. lastUpdateUser: 13
  104. lastUpdateTimestamp: 2018-12-11 09:52:03.743455
  105.  
  106. 2018-12-11 17:52:36.680 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: createNewBatch
  107. 2018-12-11 17:52:36.681 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : MCI: saveRemDetails
  108. 2018-12-11 17:52:36.682 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : Collateral: class Collateral {
  109. collateralId: null
  110. collateralNum: 405
  111. collateralTypeId: 4
  112. bankId: class Bank {
  113. bankId: 1
  114. bankCode: BPI
  115. bankEntity: null
  116. deleteFlag: false
  117. bankName: Bank of the Philippine Islands
  118. bankStatus: Operating
  119. dateJoined: 1999-05-21
  120. bankAddress: Gapan Nueva Ecija
  121. dateClosed: null
  122. refBalanceId: 1
  123. refBankTypeId: 2
  124. cwtFlag: true
  125. deleteFlag: false
  126. bankResolutionNo: null
  127. }
  128. collateralStatusId: null
  129. creditFacilityText: class CreditFacility {
  130. creditFacilityId: 23
  131. creditFacility: null
  132. }
  133. collateralValueNum: null
  134. availableValueNum: null
  135. creationDate: null
  136. lastUpdateDate: null
  137. updaterName: null
  138. batchReferenceNum: null
  139. remDetails: class RemDetails {
  140. remId: null
  141. remAmountNum: 100000.00
  142. eubRemDetails: class PromisoryNoteDetails {
  143. deedOfAssignment: null
  144. borrowers: null
  145. promisoryNotes: [class PromisoryNote {
  146. promisoryNoteId: null
  147. promisoryNoteNum: 888
  148. bankBranchText: null
  149. grantDate: 2018-12-11
  150. dueDate: 2018-12-11
  151. projectLocationText: Makati
  152. loanTypeText: null
  153. bankRatePct: 1.000000
  154. bankPenaltyRatePct: 1.000000
  155. faceAmountNum: 1.00
  156. outstandingBalanceNum: 5000000.00
  157. listOfTitleDetails: [class TitleDetails {
  158. titleDetailsId: 10110
  159. tctTypeText: Condominium Certificate of Title (CCT)
  160. titleNum: 400
  161. owner: class Owner {
  162. registeredOwnerName: Jervin
  163. ownerBirthdate: 2000-01-01
  164. ownerTaxIdentificationNumber: 325
  165. }
  166. locationText: Pasay City
  167. areaText: 943
  168. unitOfMeasurementText: Square Meter
  169. loanValueNum: 2000000.00
  170. loanValueRatePct: null
  171. landTaxDeclarationDetails: class TaxDeclarationDetails {
  172. taxDeclarationDetailsId: null
  173. taxDeclarationNum: 494
  174. totalAssessedValueNum: 530000.00
  175. retrNum: 433
  176. receiptDate: 2018-12-10
  177. paymentAmountNum: 5000000.00
  178. beginningCoverageDate: 2001-01-01
  179. endingCoverageDate: 2001-12-31
  180. insuranceDetails: null
  181. taxDeclarationType: LAND
  182. referenceTitleId: null
  183. yearNum: 2001
  184. appraisalReport: class AppraisalReport {
  185. appraisalReportId: 67
  186. appraisedAmountValue: 5000000.00
  187. appraiserName: Philippine Appraisal Co., Inc.
  188. deleteFlag: 0
  189. referenceAppraiserId: null
  190. referenceTaxDeclarationId: null
  191. reportDate: 2018-12-11
  192. reportType:
  193. }
  194. paymentType: class PaymentType {
  195. paymentTypeId: 2
  196. paymentTypeText: null
  197. }
  198. propertyClassification: class PropertyClassification {
  199. propertyClassificationId: 15
  200. propertyClassificationText: null
  201. }
  202. }
  203. improvementTaxDeclarationDetails: null
  204. areaValue: 943
  205. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  206. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  207. loanValueRateFlag: 0
  208. collateralOwnership: class CollateralOwnership {
  209. collateralOwnershipId: 1
  210. collateralOwnershipText: null
  211.  
  212. propertyCategory: class PropertyCategory {
  213. propertyCategoryId: 2
  214. propertyCategoryText: Agro Industrial
  215. }
  216. registryOfDeeds: class RegistryOfDeeds {
  217. registryOfDeedsId: 16
  218. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  219. }
  220. refRemId: null
  221. }]
  222. initialLoanValueRatePct: 1
  223. finalLoanValueRatePct: 1
  224. loanValueRateFlag: 0
  225. bankBranch: null
  226. loanType: null
  227. }]
  228. }
  229. bankRemDetails: null
  230. }
  231. gsDetails: null
  232. deficiencies: null
  233. }. Collateral Batch: class CollateralBatch {
  234. batchReferenceNum: _.2018000103
  235. bank: class Bank {
  236. bankId: 1
  237. bankCode: null
  238. bankEntity: null
  239. deleteFlag: null
  240. bankName: null
  241. bankStatus: null
  242. dateJoined: null
  243. bankAddress: null
  244. dateClosed: null
  245. refBalanceId: null
  246. refBankTypeId: null
  247. cwtFlag: null
  248. deleteFlag: null
  249. bankResolutionNo: null
  250. }
  251. approvalStatus: null
  252. creditFacility: class CreditFacility {
  253. creditFacilityId: 23
  254. creditFacility: null
  255. }
  256. documentaryRequirements: []
  257. dateCreated: 2018-12-11 09:52:03.743455
  258. userName: null
  259. lastUpdateUser: 13
  260. lastUpdateTimestamp: 2018-12-11 09:52:03.743455
  261.  
  262. 2018-12-11 17:52:36.682 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : ....
  263. Collateral Type: EubRem
  264. ...
  265. 2018-12-11 17:52:36.682 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : MCI: validatePromisoryNote
  266. 2018-12-11 17:52:36.682 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.s.PromisoryNoteServiceImpl : MCI >> checkForUpsert
  267. 2018-12-11 17:52:36.683 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.PromisoryNoteChecker : MCI: checkForEncoding
  268. 2018-12-11 17:52:36.684 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.TitleDetailsChecker : MCI: checkForEncode
  269. 2018-12-11 17:52:36.685 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.OwnerChecker : MCI: checkForEncode
  270. 2018-12-11 17:52:36.685 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.OwnerChecker : MCO: checkForEncode
  271. 2018-12-11 17:52:36.685 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.v.TaxDeclarationChecker : MCI: checkForEncode
  272. ...1...
  273. ...2...
  274. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.v.AppraisalReportChecker : MCI: checkForEncode
  275. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.v.AppraisalReportChecker : MCO: checkForEncode
  276. ...3...
  277. ...5...
  278. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.v.TaxDeclarationChecker : MCO: checkForEncode
  279. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.TitleDetailsChecker : MCO: checkForEncode
  280. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.PromisoryNoteChecker : MCO: checkForEncoding
  281. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.s.PromisoryNoteServiceImpl : MCO >> checkForUpsert
  282. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : MCO: validatePromisoryNote
  283. 2018-12-11 17:52:36.687 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: encode
  284. 2018-12-11 17:52:36.688 DEBUG 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : Collateral: class Collateral {
  285. collateralId: null
  286. collateralNum: 405
  287. collateralTypeId: 4
  288. bankId: class Bank {
  289. bankId: 1
  290. bankCode: BPI
  291. bankEntity: null
  292. deleteFlag: false
  293. bankName: Bank of the Philippine Islands
  294. bankStatus: Operating
  295. dateJoined: 1999-05-21
  296. bankAddress: Gapan Nueva Ecija
  297. dateClosed: null
  298. refBalanceId: 1
  299. refBankTypeId: 2
  300. cwtFlag: true
  301. deleteFlag: false
  302. bankResolutionNo: null
  303. }
  304. collateralStatusId: null
  305. creditFacilityText: class CreditFacility {
  306. creditFacilityId: 23
  307. creditFacility: null
  308. }
  309. collateralValueNum: null
  310. availableValueNum: null
  311. creationDate: null
  312. lastUpdateDate: null
  313. updaterName: null
  314. batchReferenceNum: null
  315. remDetails: class RemDetails {
  316. remId: null
  317. remAmountNum: 100000.00
  318. eubRemDetails: class PromisoryNoteDetails {
  319. deedOfAssignment: null
  320. borrowers: null
  321. promisoryNotes: [class PromisoryNote {
  322. promisoryNoteId: null
  323. promisoryNoteNum: 888
  324. bankBranchText: null
  325. grantDate: 2018-12-11
  326. dueDate: 2018-12-11
  327. projectLocationText: Makati
  328. loanTypeText: null
  329. bankRatePct: 1.000000
  330. bankPenaltyRatePct: 1.000000
  331. faceAmountNum: 1.00
  332. outstandingBalanceNum: 5000000.00
  333. listOfTitleDetails: [class TitleDetails {
  334. titleDetailsId: 10110
  335. tctTypeText: Condominium Certificate of Title (CCT)
  336. titleNum: 400
  337. owner: class Owner {
  338. registeredOwnerName: Jervin
  339. ownerBirthdate: 2000-01-01
  340. ownerTaxIdentificationNumber: 325
  341. }
  342. locationText: Pasay City
  343. areaText: 943
  344. unitOfMeasurementText: Square Meter
  345. loanValueNum: 2000000.00
  346. loanValueRatePct: null
  347. landTaxDeclarationDetails: class TaxDeclarationDetails {
  348. taxDeclarationDetailsId: null
  349. taxDeclarationNum: 494
  350. totalAssessedValueNum: 530000.00
  351. retrNum: 433
  352. receiptDate: 2018-12-10
  353. paymentAmountNum: 5000000.00
  354. beginningCoverageDate: 2001-01-01
  355. endingCoverageDate: 2001-12-31
  356. insuranceDetails: null
  357. taxDeclarationType: LAND
  358. referenceTitleId: null
  359. yearNum: 2001
  360. appraisalReport: class AppraisalReport {
  361. appraisalReportId: 67
  362. appraisedAmountValue: 5000000.00
  363. appraiserName: Philippine Appraisal Co., Inc.
  364. deleteFlag: 0
  365. referenceAppraiserId: null
  366. referenceTaxDeclarationId: null
  367. reportDate: 2018-12-11
  368. reportType:
  369. }
  370. paymentType: class PaymentType {
  371. paymentTypeId: 2
  372. paymentTypeText: null
  373. }
  374. propertyClassification: class PropertyClassification {
  375. propertyClassificationId: 15
  376. propertyClassificationText: null
  377. }
  378. }
  379. improvementTaxDeclarationDetails: null
  380. areaValue: 943
  381. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  382. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  383. loanValueRateFlag: 0
  384. collateralOwnership: class CollateralOwnership {
  385. collateralOwnershipId: 1
  386. collateralOwnershipText: null
  387.  
  388. propertyCategory: class PropertyCategory {
  389. propertyCategoryId: 2
  390. propertyCategoryText: Agro Industrial
  391. }
  392. registryOfDeeds: class RegistryOfDeeds {
  393. registryOfDeedsId: 16
  394. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  395. }
  396. refRemId: null
  397. }]
  398. initialLoanValueRatePct: 1
  399. finalLoanValueRatePct: 1
  400. loanValueRateFlag: 0
  401. bankBranch: null
  402. loanType: null
  403. }]
  404. }
  405. bankRemDetails: null
  406. }
  407. gsDetails: null
  408. deficiencies: null
  409. }. Collateral Batch: class CollateralBatch {
  410. batchReferenceNum: _.2018000103
  411. bank: class Bank {
  412. bankId: 1
  413. bankCode: null
  414. bankEntity: null
  415. deleteFlag: null
  416. bankName: null
  417. bankStatus: null
  418. dateJoined: null
  419. bankAddress: null
  420. dateClosed: null
  421. refBalanceId: null
  422. refBankTypeId: null
  423. cwtFlag: null
  424. deleteFlag: null
  425. bankResolutionNo: null
  426. }
  427. approvalStatus: null
  428. creditFacility: class CreditFacility {
  429. creditFacilityId: 23
  430. creditFacility: null
  431. }
  432. documentaryRequirements: []
  433. dateCreated: 2018-12-11 09:52:03.743455
  434. userName: null
  435. lastUpdateUser: 13
  436. lastUpdateTimestamp: 2018-12-11 09:52:03.743455
  437.  
  438. 2018-12-11 17:52:36.689 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.CollateralChecker : MCI: checkForEncodeRem
  439. 2018-12-11 17:52:36.689 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.CollateralChecker : MCI: checkForEncode
  440. 2018-12-11 17:52:36.689 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.CollateralChecker : MCO: checkForEncode
  441. 2018-12-11 17:52:36.689 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.CollateralChecker : MCO: checkForEncodeRem
  442. 2018-12-11 17:52:36.689 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: checkTitlesValidity
  443. 2018-12-11 17:52:36.689 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: checkTitleDetailsValidity
  444. 2018-12-11 17:52:36.690 DEBUG 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : Titles: [class TitleDetails {
  445. titleDetailsId: 10110
  446. tctTypeText: Condominium Certificate of Title (CCT)
  447. titleNum: 400
  448. owner: class Owner {
  449. registeredOwnerName: Jervin
  450. ownerBirthdate: 2000-01-01
  451. ownerTaxIdentificationNumber: 325
  452. }
  453. locationText: Pasay City
  454. areaText: 943
  455. unitOfMeasurementText: Square Meter
  456. loanValueNum: 2000000.00
  457. loanValueRatePct: null
  458. landTaxDeclarationDetails: class TaxDeclarationDetails {
  459. taxDeclarationDetailsId: null
  460. taxDeclarationNum: 494
  461. totalAssessedValueNum: 530000.00
  462. retrNum: 433
  463. receiptDate: 2018-12-10
  464. paymentAmountNum: 5000000.00
  465. beginningCoverageDate: 2001-01-01
  466. endingCoverageDate: 2001-12-31
  467. insuranceDetails: null
  468. taxDeclarationType: LAND
  469. referenceTitleId: null
  470. yearNum: 2001
  471. appraisalReport: class AppraisalReport {
  472. appraisalReportId: 67
  473. appraisedAmountValue: 5000000.00
  474. appraiserName: Philippine Appraisal Co., Inc.
  475. deleteFlag: 0
  476. referenceAppraiserId: null
  477. referenceTaxDeclarationId: null
  478. reportDate: 2018-12-11
  479. reportType:
  480. }
  481. paymentType: class PaymentType {
  482. paymentTypeId: 2
  483. paymentTypeText: null
  484. }
  485. propertyClassification: class PropertyClassification {
  486. propertyClassificationId: 15
  487. propertyClassificationText: null
  488. }
  489. }
  490. improvementTaxDeclarationDetails: null
  491. areaValue: 943
  492. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  493. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  494. loanValueRateFlag: 0
  495. collateralOwnership: class CollateralOwnership {
  496. collateralOwnershipId: 1
  497. collateralOwnershipText: null
  498.  
  499. propertyCategory: class PropertyCategory {
  500. propertyCategoryId: 2
  501. propertyCategoryText: Agro Industrial
  502. }
  503. registryOfDeeds: class RegistryOfDeeds {
  504. registryOfDeedsId: 16
  505. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  506. }
  507. refRemId: null
  508. }]
  509. 2018-12-11 17:52:36.690 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.s.CollateralRetrieveServiceImpl : MCI: getRemCollateral
  510. 2018-12-11 17:52:36.690 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.s.CollateralRetrieveServiceImpl : Title Number: 400. Collateral Approval Status: null
  511. 2018-12-11 17:52:36.690 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCI: getRemCollaterals
  512. 2018-12-11 17:52:36.690 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  513. 2018-12-11 17:52:36.690 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  514. 2018-12-11 17:52:36.792 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  515. 2018-12-11 17:52:36.792 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  516. 2018-12-11 17:52:36.962 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.getRemCollaterals : ==> Preparing: SELECT * FROM ( SELECT batch.batch_reference_number, CASE WHEN coll.collateral_number = pn.pn_number AND fch.ref_ghost_pn_id IS NULL AND cps.ref_ghost_pn_id IS NULL AND bgs.ref_ghost_pn_id IS NULL THEN 2 WHEN coll.collateral_number != pn.pn_number AND fch.ref_ghost_pn_id IS NULL AND cps.ref_ghost_pn_id IS NULL AND bgs.ref_ghost_pn_id IS NULL THEN 4 END as collateral_type_id, pn_history.latest_pn_id as collateral_id, pn.pn_number as collateral_number, pn.pn_status as collateral_status, cf.credit_facility_id as cf_facility_id, cf.credit_facility as cf_facility, pn.amount_granted as collateral_value, batch.date_created as collateral_created_date, vo.description as def_description, pn.validation_actions_taken as def_actions, pn.validation_deficiencies as def_remarks, vo.validations_value as def_code , pn.ref_validations_override_id as def_ref_id, rem.rem_id, rem.rem_amount, rem.deed_of_rem, rem.deed_of_assignment, batch.ref_approval_status_id as batch_ref_approval_id, bremtl.collateral_id as bremtl_id, bremtl.collateral_number as bremtl_number, bremtl.collateral_type as bremtl_type, bremtl.ref_property_cat_id as bremtl_property_code, bremtl.collateral_location as bremtl_location, bremtl.area as bremtl_area, bremtl.unit_measurement as bremtl_unit_measurement, bremrd.registry_of_deeds as bremtl_deeds_registry, bremtl.loan_value as bremtl_loan_value, bremtl.loan_value_rate as bremtl_loan_value_rate, bremtl.registered_owner as bremtl_regd_owner, bremtl.birthdate as bremtl_birthdate, bremtl.tax_identification_number as bremtl_tax_id_num, bremown.description as bremown_text, eubtl.collateral_id as eubtl_id, eubtl.collateral_number as eubtl_number, eubtl.collateral_type as eubtl_type, eubtl.ref_property_cat_id as eubtl_property_code, eubtl.collateral_location as eubtl_location, eubtl.area as eubtl_area, eubtl.unit_measurement as eubtl_unit_measurement, bremrd.registry_of_deeds as eubtl_deeds_registry, eubtl.loan_value as eubtl_loan_value, eubtl.loan_value_rate as eubtl_loan_value_rate, eubtl.registered_owner as eubtl_regd_owner, eubtl.birthdate as eubtl_birthdate, eubtl.tax_identification_number as eubtl_tax_id_num, eubown.description as eubown_text, pnote.pn_id as pn_id, pnotebank.bank_address as pnbank_branch, pnote.date_granted as pn_date_granted, pnote.maturity_date as pn_maturity_date, pnoteloan.loan_type as pnloan_type, pnote.pn_interest_rate as pn_interest_rate, pnote.penalty_rate as pn_penalty_rate, pnote.face_amount as pn_face_amount, pnote.rem_amount as pn_rem_amount, brw.borrower_id as brw_id, brw.full_name as brw_full_name, brw.tin as brw_tin, brw.address as brw_address, brw.first_name as brw_first_name, brw.middle_name as brw_middle_name, concat(brw.city_town_barangay, brw.province) as brw_location, brw.entity_name as brw_entity_name, brw.ref_industry_classification_id as industry_id, ind.classification as industry, bank.bank_id, bank.bank_code, bank.bank_entity, bank.bank_name, bank.bank_status, bank.date_joined as bank_date_joined, bank.bank_address, bank.date_close as bank_date_close, bank.ref_balance_id as bank_ref_balance_id, bank.ref_bank_type_id as bank_ref_bank_type_id, bank.cwt_flag as bank_cwt_flag, bank.delete_flag as bank_delete_flag, bank.bank_resolution_no FROM pn_tbl pn join (SELECT MAX(pn_id) as latest_pn_id, pn_number FROM pn_tbl GROUP BY pn_number) pn_history ON pn.pn_number = pn_history.pn_number left join collateral_batch batch on pn.parent_collateral_batch = batch.batch_reference_number left join credit_facility cf on batch.credit_facility_id = cf.credit_facility_id left join validations_override vo on vo.validations_override_id = pn.ref_validations_override_id left join bank_gs bgs on pn.pn_id = bgs.ref_ghost_pn_id left join pn_tbl gspnote on bgs.ref_ghost_pn_id = gspnote.pn_id left join bank_tbl gspnotebank on gspnote.ref_bank_id = gspnotebank.bank_id left join loan_tbl gspnoteloan on gspnote.ref_loan_id = gspnoteloan.loan_id left join issuer iss on bgs.ref_issuer_id = iss.issuer_id left join bank_gs_type bgst on bgst.bank_gs_type_id = bgs.ref_bank_gs_type_id left join collateral_ownership own on bgs.ref_ownership_id = own.collateral_ownership_id left join denomination bgsdenom on bgs.ref_denomination_id = bgsdenom.denomination_id left join com_papers cps on pn.pn_id = cps.ref_ghost_pn_id left join pn_tbl cppnote on cps.ref_ghost_pn_id = cppnote.pn_id left join bank_tbl cppnotebank on cppnote.ref_bank_id = cppnotebank.bank_id left join loan_tbl cppnoteloan on cppnote.ref_loan_id = cppnoteloan.loan_id left join collateral_location cpsloc on cps.ref_collateral_location_id = cpsloc.collateral_location_id left join collateral_status cps_stat on cps.ref_collateral_status_id = cps_stat.collateral_status_id left join com_papers_type cpstype on cps.ref_com_papers_type_id = cpstype.com_papers_type_id left join collateral_ownership cpsown on cps.ref_ownership_id = cpsown.collateral_ownership_id left join fc_holdout fch on pn.pn_id = fch.ref_ghost_pn_id left join pn_tbl fcpnote on fch.ref_ghost_pn_id = fcpnote.pn_id left join bank_tbl fcpnotebank on fcpnote.ref_bank_id = fcpnotebank.bank_id left join loan_tbl fcpnoteloan on fcpnote.ref_loan_id = fcpnoteloan.loan_id left join collateral_location fchloc on fch.ref_collateral_location = fchloc.collateral_location_id left join collateral_status fchstat on fch.ref_collateral_status = fchstat.collateral_status_id left join denomination fchdenom on fch.ref_denomination_id = fchdenom.denomination_id left join collateral_ownership fchown on fch.ref_ownership_id = fchown.collateral_ownership_id left join pn_rem_tbl pn_rem on pn_rem.ref_pn_id = pn.pn_id left join rem_tbl rem on pn_rem.ref_rem_id = rem.rem_id left join collateral_tbl coll on rem.rem_id = coll.ref_rem_id left join collateral_tbl bremtl on rem.rem_id = bremtl.ref_rem_id and pn.pn_number = bremtl.collateral_number and pn.pn_id = pn_rem.ref_pn_id and pn_rem.ref_rem_id = rem.rem_id left join registry_of_deeds_tbl bremrd on bremrd.rd_id = bremtl.ref_rd_id left join collateral_ownership bremown on bremown.collateral_ownership_id = bremtl.ref_ownership_id left join pn_tbl brpnote on pn.pn_id = brpnote.pn_id and pn.pn_number = bremtl.collateral_number left join bank_tbl brpnotebank on brpnote.ref_bank_id = brpnotebank.bank_id left join loan_tbl brpnoteloan on brpnote.ref_loan_id = brpnoteloan.loan_id left join collateral_tbl eubtl on rem.rem_id = eubtl.ref_rem_id and pn.pn_number != eubtl.collateral_number and pn.pn_id = pn_rem.ref_pn_id and pn_rem.ref_rem_id = rem.rem_id left join registry_of_deeds_tbl eubrd on eubrd.rd_id = eubtl.ref_rd_id left join pn_tbl pnote on eubtl.collateral_number != pnote.pn_number AND fch.ref_ghost_pn_id IS NULL AND cps.ref_ghost_pn_id IS NULL AND bgs.ref_ghost_pn_id IS NULL left join bank_tbl pnotebank on pnotebank.bank_id = pnote.ref_bank_id left join collateral_ownership eubown on eubown.collateral_ownership_id = eubtl.ref_ownership_id left join end_user_borrower_tbl brw on pnote.ref_borrower_id = brw.borrower_id AND fch.ref_ghost_pn_id IS NULL AND cps.ref_ghost_pn_id IS NULL AND bgs.ref_ghost_pn_id IS NULL LEFT join INDUSTRY_CLASSIFICATION IND ON BRW.REF_INDUSTRY_CLASSIFICATION_ID = IND.INDUSTRY_CLASSIFICATION_ID left join loan_tbl pnoteloan on pn.ref_loan_id = pnoteloan.loan_id AND fch.ref_ghost_pn_id IS NULL AND cps.ref_ghost_pn_id IS NULL AND bgs.ref_ghost_pn_id IS NULL left join bank_tbl bank on bank.bank_id = pn.ref_bank_id ) WHERE collateral_type_id IS NOT NULL AND (eubtl_number = ? OR bremtl_number = ?)
  517. 2018-12-11 17:52:36.963 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.getRemCollaterals : ==> Parameters: 400(String), 400(String)
  518. 2018-12-11 17:52:37.026 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.getRemCollaterals : <== Total: 0
  519. 2018-12-11 17:52:37.029 DEBUG 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : Get REM collateral: null
  520. 2018-12-11 17:52:37.037 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCO: getRemCollaterals
  521. 2018-12-11 17:52:37.037 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.s.CollateralRetrieveServiceImpl : Result :null
  522. 2018-12-11 17:52:37.037 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.s.CollateralRetrieveServiceImpl : MCO: getRemCollateral
  523. 2018-12-11 17:52:37.037 DEBUG 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : Result :true
  524. 2018-12-11 17:52:37.037 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: checkTitleDetailsValidity
  525. 2018-12-11 17:52:37.038 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.TitleValidityChecker : MCI: checkValidForBank
  526. 2018-12-11 17:52:37.040 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.TitleValidityChecker : ...
  527. ...
  528. BANK: class Bank {
  529. bankId: 1
  530. bankCode: null
  531. bankEntity: null
  532. deleteFlag: null
  533. bankName: null
  534. bankStatus: null
  535. dateJoined: null
  536. bankAddress: null
  537. dateClosed: null
  538. refBalanceId: null
  539. refBankTypeId: null
  540. cwtFlag: null
  541. deleteFlag: null
  542. bankResolutionNo: null
  543. }
  544. 2018-12-11 17:52:37.041 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.session.MyBatisHelper : MCI: executeQuery
  545. 2018-12-11 17:52:37.041 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  546. 2018-12-11 17:52:37.041 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  547. 2018-12-11 17:52:37.146 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  548. 2018-12-11 17:52:37.146 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  549. 2018-12-11 17:52:37.146 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : MCI: getTitlesFromBankUnapprovedCollateral
  550. 2018-12-11 17:52:37.289 DEBUG 23032 --- [nio-8000-exec-1] m.T.getTitleFromBankUnapprovedCollateral : ==> Preparing: SELECT * FROM( SELECT title.collateral_id as col_collateral_id, title.collateral_number as col_collateral_number FROM collateral_batch batch JOIN pn_tbl pn ON pn.parent_collateral_batch = batch.batch_reference_number JOIN (SELECT max(pn_id) as pn_id FROM pn_tbl pn GROUP BY pn_number) as latest_pn ON latest_pn.pn_id = pn.pn_id JOIN pn_rem_tbl pnrem ON pn.pn_id = pnrem.ref_pn_id JOIN rem_tbl rem ON rem.rem_id = pnrem.ref_rem_id JOIN collateral_tbl title ON rem.rem_id = title.ref_rem_id JOIN bank_tbl bank ON bank.bank_id = batch.ref_bank_id WHERE batch.ref_approval_status_id != 5 AND bank.bank_code IN (SELECT bank.bank_code FROM bank_tbl bank WHERE bank.bank_id = ?) AND title.collateral_number || '|' || title.collateral_location || '|' || title.area || '|' || title.unit_measurement || '|' || title.ref_rd_id IN ( ? ) )
  551. 2018-12-11 17:52:37.290 DEBUG 23032 --- [nio-8000-exec-1] m.T.getTitleFromBankUnapprovedCollateral : ==> Parameters: 1(Integer), 400|Pasay City|943|Square Meter|16(String)
  552. 2018-12-11 17:52:37.301 DEBUG 23032 --- [nio-8000-exec-1] m.T.getTitleFromBankUnapprovedCollateral : <== Total: 0
  553. 2018-12-11 17:52:37.302 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : MCO: getTitlesFromBankUnapprovedCollateral
  554. 2018-12-11 17:52:37.303 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : result={}
  555. 2018-12-11 17:52:37.311 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.session.MyBatisHelper : MCO: executeQuery
  556. 2018-12-11 17:52:37.311 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.validation.TitleValidityChecker : MCO: checkValidForBank
  557. 2018-12-11 17:52:37.311 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: checkTitlesValidity
  558. 2018-12-11 17:52:37.312 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.session.MyBatisHelper : MCI: executeTransaction
  559. 2018-12-11 17:52:37.312 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  560. 2018-12-11 17:52:37.312 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  561. 2018-12-11 17:52:37.470 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  562. 2018-12-11 17:52:37.470 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  563. 2018-12-11 17:52:37.893 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.updateCollateral : ==> Preparing: SELECT pn_id as collateral_id, pn_number as collateral_number, pn_status as collateral_status, parent_collateral_batch as batch_ref_num FROM FINAL TABLE( UPDATE PN_TBL SET pn_number = ?, pn_status = ?, parent_collateral_batch = ? WHERE pn_id = ? )
  564. 2018-12-11 17:52:37.905 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.updateCollateral : ==> Parameters: 405(String), null, _.2018000103(String), null
  565. 2018-12-11 17:52:37.914 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.updateCollateral : <== Total: 0
  566. 2018-12-11 17:52:37.914 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCI: upsertCollateralOnSession
  567. 2018-12-11 17:52:37.914 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.insertCollateral : ==> Preparing: SELECT pn_id as collateral_id, pn_number as collateral_number, pn_status as collateral_status, parent_collateral_batch as batch_ref_num FROM FINAL TABLE( INSERT INTO PN_TBL (PN_NUMBER, REF_COLLATERAL_TYPE_ID, PN_STATUS, PARENT_COLLATERAL_BATCH) VALUES (?, ?, ?, ?) )
  568. 2018-12-11 17:52:37.924 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.insertCollateral : ==> Parameters: 405(String), null, null, _.2018000103(String)
  569. 2018-12-11 17:52:37.935 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.C.insertCollateral : <== Total: 1
  570. 2018-12-11 17:52:37.935 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCI: upsertDetailsOnSession
  571. 2018-12-11 17:52:37.937 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : Collateral: class Collateral {
  572. collateralId: null
  573. collateralNum: 405
  574. collateralTypeId: 4
  575. bankId: class Bank {
  576. bankId: 1
  577. bankCode: BPI
  578. bankEntity: null
  579. deleteFlag: false
  580. bankName: Bank of the Philippine Islands
  581. bankStatus: Operating
  582. dateJoined: 1999-05-21
  583. bankAddress: Gapan Nueva Ecija
  584. dateClosed: null
  585. refBalanceId: 1
  586. refBankTypeId: 2
  587. cwtFlag: true
  588. deleteFlag: false
  589. bankResolutionNo: null
  590. }
  591. collateralStatusId: null
  592. creditFacilityText: class CreditFacility {
  593. creditFacilityId: 23
  594. creditFacility: null
  595. }
  596. collateralValueNum: null
  597. availableValueNum: null
  598. creationDate: null
  599. lastUpdateDate: null
  600. updaterName: null
  601. batchReferenceNum: _.2018000103
  602. remDetails: class RemDetails {
  603. remId: null
  604. remAmountNum: 100000.00
  605. eubRemDetails: class PromisoryNoteDetails {
  606. deedOfAssignment: null
  607. borrowers: null
  608. promisoryNotes: [class PromisoryNote {
  609. promisoryNoteId: null
  610. promisoryNoteNum: 888
  611. bankBranchText: null
  612. grantDate: 2018-12-11
  613. dueDate: 2018-12-11
  614. projectLocationText: Makati
  615. loanTypeText: null
  616. bankRatePct: 1.000000
  617. bankPenaltyRatePct: 1.000000
  618. faceAmountNum: 1.00
  619. outstandingBalanceNum: 5000000.00
  620. listOfTitleDetails: [class TitleDetails {
  621. titleDetailsId: 10110
  622. tctTypeText: Condominium Certificate of Title (CCT)
  623. titleNum: 400
  624. owner: class Owner {
  625. registeredOwnerName: Jervin
  626. ownerBirthdate: 2000-01-01
  627. ownerTaxIdentificationNumber: 325
  628. }
  629. locationText: Pasay City
  630. areaText: 943
  631. unitOfMeasurementText: Square Meter
  632. loanValueNum: 2000000.00
  633. loanValueRatePct: null
  634. landTaxDeclarationDetails: class TaxDeclarationDetails {
  635. taxDeclarationDetailsId: null
  636. taxDeclarationNum: 494
  637. totalAssessedValueNum: 530000.00
  638. retrNum: 433
  639. receiptDate: 2018-12-10
  640. paymentAmountNum: 5000000.00
  641. beginningCoverageDate: 2001-01-01
  642. endingCoverageDate: 2001-12-31
  643. insuranceDetails: null
  644. taxDeclarationType: LAND
  645. referenceTitleId: null
  646. yearNum: 2001
  647. appraisalReport: class AppraisalReport {
  648. appraisalReportId: 67
  649. appraisedAmountValue: 5000000.00
  650. appraiserName: Philippine Appraisal Co., Inc.
  651. deleteFlag: 0
  652. referenceAppraiserId: null
  653. referenceTaxDeclarationId: null
  654. reportDate: 2018-12-11
  655. reportType:
  656. }
  657. paymentType: class PaymentType {
  658. paymentTypeId: 2
  659. paymentTypeText: null
  660. }
  661. propertyClassification: class PropertyClassification {
  662. propertyClassificationId: 15
  663. propertyClassificationText: null
  664. }
  665. }
  666. improvementTaxDeclarationDetails: null
  667. areaValue: 943
  668. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  669. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  670. loanValueRateFlag: 0
  671. collateralOwnership: class CollateralOwnership {
  672. collateralOwnershipId: 1
  673. collateralOwnershipText: null
  674.  
  675. propertyCategory: class PropertyCategory {
  676. propertyCategoryId: 2
  677. propertyCategoryText: Agro Industrial
  678. }
  679. registryOfDeeds: class RegistryOfDeeds {
  680. registryOfDeedsId: 16
  681. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  682. }
  683. refRemId: null
  684. }]
  685. initialLoanValueRatePct: 1
  686. finalLoanValueRatePct: 1
  687. loanValueRateFlag: 0
  688. bankBranch: null
  689. loanType: null
  690. }]
  691. }
  692. bankRemDetails: null
  693. }
  694. gsDetails: null
  695. deficiencies: null
  696. }
  697. 2018-12-11 17:52:37.937 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCI: upsertRemDetailsOnSession
  698. 2018-12-11 17:52:37.969 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.RemDetailsDao : MCI: upsertEubRemOnSession
  699. 2018-12-11 17:52:37.971 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.updateRemDetails : ==> Preparing: SELECT rem_id, rem_amount, deed_of_assignment FROM FINAL TABLE ( UPDATE rem_tbl SET rem_amount = ?, deed_of_assignment = ? WHERE rem_id = ? ) AS REM
  700. 2018-12-11 17:52:37.983 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.updateRemDetails : ==> Parameters: 100000.00(BigDecimal), null, null
  701. 2018-12-11 17:52:37.992 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.updateRemDetails : <== Total: 0
  702. 2018-12-11 17:52:37.992 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.RemDetailsDao : No EUB REM to update. Inserting a new EUB REM
  703. 2018-12-11 17:52:37.992 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.incrementMaxRemId : ==> Preparing: SELECT MAX(rem_id) from rem_tbl
  704. 2018-12-11 17:52:37.993 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.incrementMaxRemId : ==> Parameters:
  705. 2018-12-11 17:52:38.004 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.incrementMaxRemId : <== Total: 1
  706. 2018-12-11 17:52:38.005 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.insertRemDetails : ==> Preparing: SELECT rem_id, rem_amount, deed_of_assignment FROM FINAL TABLE ( INSERT INTO rem_tbl (rem_id, rem_amount, deed_of_assignment) VALUES (?, ?, ?) ) AS REM
  707. 2018-12-11 17:52:38.047 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.insertRemDetails : ==> Parameters: 59(Integer), 100000.00(BigDecimal), null
  708. 2018-12-11 17:52:38.077 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.R.insertRemDetails : <== Total: 1
  709. 2018-12-11 17:52:38.077 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.PromisoryNoteDao : MCI: upsertPromisoryNoteDetails (List)
  710. 2018-12-11 17:52:38.081 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.updatePromisoryNote : ==> Preparing: SELECT promisory.PN_ID, promisory.pn_number, promisory.DATE_GRANTED as pn_date_granted, promisory.MATURITY_DATE as pn_maturity_date, promisory.PN_INTEREST_RATE as pn_interest_rate, promisory.PENALTY_RATE as pn_penalty_rate, promisory.FACE_AMOUNT as pn_face_amount, promisory.REM_AMOUNT as pn_rem_amount FROM FINAL TABLE ( UPDATE PN_TBL as pn SET pn.PN_NUMBER = '888', pn.DATE_GRANTED = TO_DATE(?, 'yyyy-mm-dd'), pn.MATURITY_DATE = TO_DATE(?, 'yyyy-mm-dd'), pn.PN_INTEREST_RATE = ?, pn.PENALTY_RATE = ?, pn.FACE_AMOUNT = ?, pn.REM_AMOUNT = ?, pn.REF_LOAN_ID = ?, pn.REF_BANK_ID = ?, pn.PROJECT_LOCATION = ? WHERE pn.PN_ID in (SELECT MAX(pnote.PN_ID) FROM PN_TBL AS pnote JOIN PN_REM_TBL AS pn_rem ON pnote.PN_ID = pn_rem.REF_PN_ID JOIN REM_TBL AS rem ON pn_rem.REF_REM_ID = rem.REM_ID JOIN BANK_TBL AS bank ON bank.BANK_ID = pnote.REF_BANK_ID WHERE rem.rem_id = ? AND bank.bank_name = ? GROUP BY PNOTE.PN_NUMBER) ) AS promisory
  711. 2018-12-11 17:52:38.121 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.updatePromisoryNote : ==> Parameters: 2018-12-11(String), 2018-12-11(String), 1.000000(BigDecimal), 1.000000(BigDecimal), 1.00(BigDecimal), 5000000.00(BigDecimal), null, null, Makati(String), null, null
  712. 2018-12-11 17:52:38.130 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.updatePromisoryNote : <== Total: 0
  713. 2018-12-11 17:52:38.131 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.insertPromisoryNoteDetails : ==> Preparing: SELECT promisory.PN_ID, promisory.pn_number, promisory.DATE_GRANTED as pn_date_granted, promisory.MATURITY_DATE as pn_maturity_date, promisory.PN_INTEREST_RATE as pn_interest_rate, promisory.PENALTY_RATE as pn_penalty_rate, promisory.FACE_AMOUNT as pn_face_amount, promisory.REM_AMOUNT as pn_rem_amount FROM FINAL TABLE ( INSERT INTO PN_TBL( PN_NUMBER, PN_INTEREST_RATE, PENALTY_RATE, DATE_GRANTED, MATURITY_DATE, REM_AMOUNT, FACE_AMOUNT, REF_LOAN_ID, REF_BANK_ID, PROJECT_LOCATION ) VALUES ( '888', ?, ?, TO_DATE(?, 'yyyy-mm-dd'), TO_DATE(?, 'yyyy-mm-dd'), ?, ?, ?, ?, ?) ) AS promisory
  714. 2018-12-11 17:52:38.152 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.insertPromisoryNoteDetails : ==> Parameters: 1.000000(BigDecimal), 1.000000(BigDecimal), 2018-12-11(String), 2018-12-11(String), 5000000.00(BigDecimal), 1.00(BigDecimal), null, null, Makati(String)
  715. 2018-12-11 17:52:38.164 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.insertPromisoryNoteDetails : <== Total: 1
  716. 2018-12-11 17:52:38.164 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.insertToPnRem : ==> Preparing: INSERT INTO PN_REM_TBL (REF_REM_ID, REF_PN_ID) SELECT ?, ? FROM SYSIBM.SYSDUMMY1 WHERE NOT EXISTS (SELECT * FROM PN_REM_TBL WHERE REF_REM_ID = ? AND REF_PN_ID = ?)
  717. 2018-12-11 17:52:38.179 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.insertToPnRem : ==> Parameters: null, 210(Integer), null, 210(Integer)
  718. 2018-12-11 17:52:38.187 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.P.insertToPnRem : <== Updates: 1
  719. 2018-12-11 17:52:38.187 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : MCI: upsertToPromisoryNoteOnSession (List)
  720. 2018-12-11 17:52:38.189 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.updateOnPromisoryNote : ==> Preparing: SELECT col.collateral_id as col_collateral_id, col.ref_rem_id as col_rem_id, col.collateral_type as col_collateral_type, col.ref_ownership_id as col_ownership_id, col.collateral_number as col_collateral_number, col.ref_property_cat_id as col_ref_property_cat_id, col.registered_owner as col_registered_owner, col.tax_identification_number as col_tax_identification_number, col.birthdate as col_birthdate, col.collateral_location as col_collateral_location, col.area as col_area, col.unit_measurement as col_unit_measurement, col.ref_rd_id as col_registry_of_deeds_id, col.loan_value as col_loan_value, col.loan_value_rate as col_loan_value_rate, col.parent_id as col_parent_id FROM FINAL TABLE ( UPDATE collateral_tbl SET collateral_type = ?, ref_ownership_id = ?, registered_owner = ?, tax_identification_number = ?, birthdate = TO_DATE(?, 'yyyy-mm-dd'), collateral_location = ?, area = ?, unit_measurement = ?, ref_rd_id = ?, loan_value = ?, loan_value_rate = ? WHERE collateral_number = ? AND collateral_location = ? AND area = ? AND unit_measurement = ? AND ref_rd_id = ? AND EXISTS (SELECT pn_id FROM pn_tbl WHERE pn_id = ?) ) AS COL
  721. 2018-12-11 17:52:38.229 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.updateOnPromisoryNote : ==> Parameters: Condominium Certificate of Title (CCT)(String), 1(Integer), Jervin(String), 325(String), 2000-01-01(String), Pasay City(String), 943(BigDecimal), Square Meter(String), 16(Integer), 2000000.00(BigDecimal), null, 400(String), Pasay City(String), 943(BigDecimal), Square Meter(String), 16(Integer), 210(Integer)
  722. 2018-12-11 17:52:38.238 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.updateOnPromisoryNote : <== Total: 0
  723. 2018-12-11 17:52:38.238 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : No Title to Promisory Note to update. Inserting a new Title to Promisory Note
  724. 2018-12-11 17:52:38.239 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToPromisoryNote : ==> Preparing: SELECT col.collateral_id as col_collateral_id, col.ref_rem_id as col_rem_id, col.collateral_type as col_collateral_type, col.ref_ownership_id as col_ownership_id, col.collateral_number as col_collateral_number, col.ref_property_cat_id as col_ref_property_cat_id, col.registered_owner as col_registered_owner, col.tax_identification_number as col_tax_identification_number, col.birthdate as col_birthdate, col.collateral_location as col_collateral_location, col.area as col_area, col.unit_measurement as col_unit_measurement, col.ref_rd_id as col_registry_of_deeds_id, col.loan_value as col_loan_value, col.loan_value_rate as col_loan_value_rate, col.parent_id as col_parent_id FROM FINAL TABLE ( INSERT INTO collateral_tbl (ref_rem_id, collateral_type, ref_ownership_id, collateral_number, registered_owner, tax_identification_number, birthdate, collateral_location, area, unit_measurement, ref_rd_id, loan_value, loan_value_rate) VALUES (?, ?, ?, ?, ?, ?, TO_DATE(?, 'yyyy-mm-dd'), ?, ?, ?, ?, ?, ?) ) AS COL
  725. 2018-12-11 17:52:38.257 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToPromisoryNote : ==> Parameters: null, Condominium Certificate of Title (CCT)(String), 1(Integer), 400(String), Jervin(String), 325(String), 2000-01-01(String), Pasay City(String), 943(BigDecimal), Square Meter(String), 16(Integer), 2000000.00(BigDecimal), null
  726. 2018-12-11 17:52:38.279 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToPromisoryNote : <== Total: 1
  727. 2018-12-11 17:52:38.280 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToPnCollateral : ==> Preparing: SELECT PNCOL.PN_COLLATERAL_ID FROM FINAL TABLE( INSERT INTO PN_COLLATERAL (REF_COLLATERAL_ID) VALUES(89)) AS PNCOL
  728. 2018-12-11 17:52:38.280 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToPnCollateral : ==> Parameters:
  729. 2018-12-11 17:52:38.319 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : MCI: upsertTaxDeclarationsOnSession
  730. 2018-12-11 17:52:38.347 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TaxDeclarationDao : MCI: upsertToTitleOnSession
  731. 2018-12-11 17:52:38.348 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.A.updateOnTaxDeclaration : ==> Preparing: SELECT apprpt.appraisal_report_id as apprpt_id, apprpt.appraised_amount as apprpt_amount, apprpt.appraiser_name as apprpt_appraiser, apprpt.delete_flag as apprpt_delete, apprpt.ref_appraiser_id as apprpt_ref_appraiser_id, apprpt.ref_collateral_id as apprpt_ref_tax_id, apprpt.report_date as apprpt_date, apprpt.report_type as apprpt_type FROM FINAL TABLE ( UPDATE APPRAISAL_REPORT APPRPT SET APPRAISED_AMOUNT = ?, APPRAISER_NAME = ?, DELETE_FLAG = ?, REF_APPRAISER_ID = ?, REPORT_DATE = ?, REPORT_TYPE = ? WHERE APPRAISAL_REPORT_ID = ? AND DELETE_FLAG != 1 ) AS APPRPT
  732. 2018-12-11 17:52:38.362 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.A.updateOnTaxDeclaration : ==> Parameters: 5000000.00(BigDecimal), Philippine Appraisal Co., Inc.(String), 0(Integer), null, 2018-12-11(String), (String), 67(Integer)
  733. 2018-12-11 17:52:38.380 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.A.updateOnTaxDeclaration : <== Total: 1
  734. 2018-12-11 17:52:38.381 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.AppraisalReportDao : MCI: upsertOnSession
  735. 2018-12-11 17:52:38.381 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.dao.AppraisalReportDao : Upserted appraisal report: class AppraisalReport {
  736. appraisalReportId: 67
  737. appraisedAmountValue: 5000000.00
  738. appraiserName: Philippine Appraisal Co., Inc.
  739. deleteFlag: 0
  740. referenceAppraiserId: null
  741. referenceTaxDeclarationId: null
  742. reportDate: 2018-12-11
  743. reportType:
  744. }
  745. 2018-12-11 17:52:38.381 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.AppraisalReportDao : MCO: upsertOnSession
  746. 2018-12-11 17:52:38.381 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.updateOnTitle : ==> Preparing: SELECT tax.tax_declaration_id as tax_id, tax.tax_declaration_number as tax_number, tax.total_assessed_value as tax_total_assessed_value, tax.tax_declaration_type as tax_type, tax.year as tax_year, tax.receipt_date as tax_receipt_date, tax.tax_receipt as tax_receipt, tax.payment_amount as tax_payment_amount, tax.beginning_coverage as tax_beginning_coverage, tax.ending_coverage as tax_ending_coverage, tax.ref_collateral_id as tax_ref_title_id, tax.ref_appraisal_id as taxapprpt_id, tax.ref_payment_type as taxpay_id, tax.ref_property_classification_id as taxpropclass_id FROM FINAL TABLE ( UPDATE tax_declaration_tbl tax SET tax.total_assessed_value = ?, tax.tax_declaration_number = ?, tax.tax_declaration_type = ?, tax.year = ?, tax.receipt_date = TO_DATE(?, 'yyyy-mm-dd'), tax.payment_amount = ?, tax.beginning_coverage = TO_DATE(?, 'yyyy-mm-dd'), tax.ending_coverage = TO_DATE(?, 'yyyy-mm-dd'), tax.ref_collateral_id = ?, tax.ref_appraisal_id = ?, tax.tax_receipt = ?, tax.ref_payment_type = ?, tax.ref_property_classification_id = ? WHERE tax.tax_declaration_number = ? AND tax.tax_declaration_id = ? AND TAX.TAX_DECLARATION_NUMBER IN ( SELECT TAX.TAX_DECLARATION_NUMBER FROM COLLATERAL_TBL TITLE1 JOIN COLLATERAL_TBL TITLE2 ON TITLE2.ADDRESS = TITLE1.ADDRESS JOIN TAX_DECLARATION_TBL TAX ON TITLE2.COLLATERAL_ID = TAX.REF_COLLATERAL_ID WHERE TAX.TAX_DECLARATION_NUMBER = ? AND TITLE2.ADDRESS = TITLE1.ADDRESS AND TITLE1.COLLATERAL_ID = ? ) ) AS TAX
  747. 2018-12-11 17:52:38.404 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.updateOnTitle : ==> Parameters: 530000.00(BigDecimal), 494(String), LAND(String), 2001(Integer), 2018-12-10(String), 5000000.00(BigDecimal), 2001-01-01(String), 2001-12-31(String), null, 67(Integer), 433(String), 2(Integer), 15(Integer), 494(String), null, 494(String), null
  748. 2018-12-11 17:52:38.413 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.updateOnTitle : <== Total: 0
  749. 2018-12-11 17:52:38.414 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TaxDeclarationDao : No tax declaration to update. Inserting a new tax declaration
  750. 2018-12-11 17:52:38.414 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToTitle : ==> Preparing: SELECT tax.tax_declaration_id as tax_id, tax.tax_declaration_number as tax_number, tax.total_assessed_value as tax_total_assessed_value, tax.tax_declaration_type as tax_type, tax.year as tax_year, tax.receipt_date as tax_receipt_date, tax.tax_receipt as tax_receipt, tax.payment_amount as tax_payment_amount, tax.beginning_coverage as tax_beginning_coverage, tax.ending_coverage as tax_ending_coverage, tax.ref_collateral_id as tax_ref_title_id, tax.ref_appraisal_id as taxapprpt_id, tax.ref_payment_type as taxpay_id, tax.ref_property_classification_id as taxpropclass_id FROM FINAL TABLE ( INSERT INTO TAX_DECLARATION_TBL (tax_declaration_number, total_assessed_value, tax_declaration_type, year, receipt_date, tax_receipt, payment_amount, beginning_coverage, ending_coverage, ref_collateral_id, ref_appraisal_id, ref_payment_type, ref_property_classification_id) VALUES (?, ?, ?, ?, TO_DATE(?, 'yyyy-mm-dd'), ?, ?, TO_DATE(?, 'yyyy-mm-dd'), TO_DATE(?, 'yyyy-mm-dd'), ?, ?, ?, ?) ) AS TAX
  751. 2018-12-11 17:52:38.430 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToTitle : ==> Parameters: 494(String), 530000.00(BigDecimal), LAND(String), 2001(Integer), 2018-12-10(String), 433(String), 5000000.00(BigDecimal), 2001-01-01(String), 2001-12-31(String), null, 67(Integer), 2(Integer), 15(Integer)
  752. 2018-12-11 17:52:38.452 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.d.m.T.insertToTitle : <== Total: 1
  753. 2018-12-11 17:52:38.453 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TaxDeclarationDao : Upserted tax declaration: class TaxDeclarationDetails {
  754. taxDeclarationDetailsId: 97
  755. taxDeclarationNum: 494
  756. totalAssessedValueNum: 530000.00
  757. retrNum: 433
  758. receiptDate: 2018-12-10
  759. paymentAmountNum: 5000000.00
  760. beginningCoverageDate: 2001-01-01
  761. endingCoverageDate: 2001-12-31
  762. insuranceDetails: null
  763. taxDeclarationType: LAND
  764. referenceTitleId: null
  765. yearNum: 2001
  766. appraisalReport: class AppraisalReport {
  767. appraisalReportId: 67
  768. appraisedAmountValue: 5000000.00
  769. appraiserName: Philippine Appraisal Co., Inc.
  770. deleteFlag: 0
  771. referenceAppraiserId: null
  772. referenceTaxDeclarationId: null
  773. reportDate: 2018-12-11
  774. reportType:
  775. }
  776. paymentType: class PaymentType {
  777. paymentTypeId: 2
  778. paymentTypeText: null
  779. }
  780. propertyClassification: class PropertyClassification {
  781. propertyClassificationId: 15
  782. propertyClassificationText: null
  783. }
  784. }
  785. 2018-12-11 17:52:38.453 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TaxDeclarationDao : MCO: upsertToTitleOnSession
  786. 2018-12-11 17:52:38.453 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : MCO: upsertTaxDeclarationsOnSession
  787. 2018-12-11 17:52:38.453 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : Upsert to Promisory Note (List): [class TitleDetails {
  788. titleDetailsId: 89
  789. tctTypeText: Condominium Certificate of Title (CCT)
  790. titleNum: 400
  791. owner: class Owner {
  792. registeredOwnerName: Jervin
  793. ownerBirthdate: 2000-01-01
  794. ownerTaxIdentificationNumber: 325
  795. }
  796. locationText: Pasay City
  797. areaText: 943
  798. unitOfMeasurementText: Square Meter
  799. loanValueNum: 2000000.00
  800. loanValueRatePct: null
  801. landTaxDeclarationDetails: class TaxDeclarationDetails {
  802. taxDeclarationDetailsId: 97
  803. taxDeclarationNum: 494
  804. totalAssessedValueNum: 530000.00
  805. retrNum: 433
  806. receiptDate: 2018-12-10
  807. paymentAmountNum: 5000000.00
  808. beginningCoverageDate: 2001-01-01
  809. endingCoverageDate: 2001-12-31
  810. insuranceDetails: null
  811. taxDeclarationType: LAND
  812. referenceTitleId: null
  813. yearNum: 2001
  814. appraisalReport: class AppraisalReport {
  815. appraisalReportId: 67
  816. appraisedAmountValue: 5000000.00
  817. appraiserName: Philippine Appraisal Co., Inc.
  818. deleteFlag: 0
  819. referenceAppraiserId: null
  820. referenceTaxDeclarationId: null
  821. reportDate: 2018-12-11
  822. reportType:
  823. }
  824. paymentType: class PaymentType {
  825. paymentTypeId: 2
  826. paymentTypeText: null
  827. }
  828. propertyClassification: class PropertyClassification {
  829. propertyClassificationId: 15
  830. propertyClassificationText: null
  831. }
  832. }
  833. improvementTaxDeclarationDetails: null
  834. areaValue: 943
  835. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  836. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  837. loanValueRateFlag: 0
  838. collateralOwnership: class CollateralOwnership {
  839. collateralOwnershipId: 1
  840. collateralOwnershipText: null
  841.  
  842. propertyCategory: null
  843. registryOfDeeds: class RegistryOfDeeds {
  844. registryOfDeedsId: 16
  845. registryOfDeedsText: null
  846. }
  847. refRemId: null
  848. }]
  849. 2018-12-11 17:52:38.453 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.TitleDetailsDao : MCO: upsertToPromisoryNoteOnSession (List)
  850. 2018-12-11 17:52:38.453 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.PromisoryNoteDao : Upsert Promisory Note details: [class PromisoryNote {
  851. promisoryNoteId: 210
  852. promisoryNoteNum: 888
  853. bankBranchText: null
  854. grantDate: 2018-12-11
  855. dueDate: 2018-12-11
  856. projectLocationText: null
  857. loanTypeText: null
  858. bankRatePct: 1.000000
  859. bankPenaltyRatePct: 1.000000
  860. faceAmountNum: 1.00
  861. outstandingBalanceNum: 5000000.00
  862. listOfTitleDetails: [class TitleDetails {
  863. titleDetailsId: 89
  864. tctTypeText: Condominium Certificate of Title (CCT)
  865. titleNum: 400
  866. owner: class Owner {
  867. registeredOwnerName: Jervin
  868. ownerBirthdate: 2000-01-01
  869. ownerTaxIdentificationNumber: 325
  870. }
  871. locationText: Pasay City
  872. areaText: 943
  873. unitOfMeasurementText: Square Meter
  874. loanValueNum: 2000000.00
  875. loanValueRatePct: null
  876. landTaxDeclarationDetails: class TaxDeclarationDetails {
  877. taxDeclarationDetailsId: 97
  878. taxDeclarationNum: 494
  879. totalAssessedValueNum: 530000.00
  880. retrNum: 433
  881. receiptDate: 2018-12-10
  882. paymentAmountNum: 5000000.00
  883. beginningCoverageDate: 2001-01-01
  884. endingCoverageDate: 2001-12-31
  885. insuranceDetails: null
  886. taxDeclarationType: LAND
  887. referenceTitleId: null
  888. yearNum: 2001
  889. appraisalReport: class AppraisalReport {
  890. appraisalReportId: 67
  891. appraisedAmountValue: 5000000.00
  892. appraiserName: Philippine Appraisal Co., Inc.
  893. deleteFlag: 0
  894. referenceAppraiserId: null
  895. referenceTaxDeclarationId: null
  896. reportDate: 2018-12-11
  897. reportType:
  898. }
  899. paymentType: class PaymentType {
  900. paymentTypeId: 2
  901. paymentTypeText: null
  902. }
  903. propertyClassification: class PropertyClassification {
  904. propertyClassificationId: 15
  905. propertyClassificationText: null
  906. }
  907. }
  908. improvementTaxDeclarationDetails: null
  909. areaValue: 943
  910. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  911. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  912. loanValueRateFlag: 0
  913. collateralOwnership: class CollateralOwnership {
  914. collateralOwnershipId: 1
  915. collateralOwnershipText: null
  916.  
  917. propertyCategory: null
  918. registryOfDeeds: class RegistryOfDeeds {
  919. registryOfDeedsId: 16
  920. registryOfDeedsText: null
  921. }
  922. refRemId: null
  923. }]
  924. initialLoanValueRatePct: 1
  925. finalLoanValueRatePct: 1
  926. loanValueRateFlag: 0
  927. bankBranch: null
  928. loanType: null
  929. }]
  930. 2018-12-11 17:52:38.453 INFO 23032 --- [nio-8000-exec-1] g.b.l.collaterals.dao.PromisoryNoteDao : MCO: upsertPromisoryNoteDetails (List)
  931. 2018-12-11 17:52:38.454 DEBUG 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.RemDetailsDao : Upsert EUB Rem: class RemDetails {
  932. remId: 59
  933. remAmountNum: 100000.00
  934. eubRemDetails: class PromisoryNoteDetails {
  935. deedOfAssignment: null
  936. borrowers: null
  937. promisoryNotes: [class PromisoryNote {
  938. promisoryNoteId: 210
  939. promisoryNoteNum: 888
  940. bankBranchText: null
  941. grantDate: 2018-12-11
  942. dueDate: 2018-12-11
  943. projectLocationText: null
  944. loanTypeText: null
  945. bankRatePct: 1.000000
  946. bankPenaltyRatePct: 1.000000
  947. faceAmountNum: 1.00
  948. outstandingBalanceNum: 5000000.00
  949. listOfTitleDetails: [class TitleDetails {
  950. titleDetailsId: 89
  951. tctTypeText: Condominium Certificate of Title (CCT)
  952. titleNum: 400
  953. owner: class Owner {
  954. registeredOwnerName: Jervin
  955. ownerBirthdate: 2000-01-01
  956. ownerTaxIdentificationNumber: 325
  957. }
  958. locationText: Pasay City
  959. areaText: 943
  960. unitOfMeasurementText: Square Meter
  961. loanValueNum: 2000000.00
  962. loanValueRatePct: null
  963. landTaxDeclarationDetails: class TaxDeclarationDetails {
  964. taxDeclarationDetailsId: 97
  965. taxDeclarationNum: 494
  966. totalAssessedValueNum: 530000.00
  967. retrNum: 433
  968. receiptDate: 2018-12-10
  969. paymentAmountNum: 5000000.00
  970. beginningCoverageDate: 2001-01-01
  971. endingCoverageDate: 2001-12-31
  972. insuranceDetails: null
  973. taxDeclarationType: LAND
  974. referenceTitleId: null
  975. yearNum: 2001
  976. appraisalReport: class AppraisalReport {
  977. appraisalReportId: 67
  978. appraisedAmountValue: 5000000.00
  979. appraiserName: Philippine Appraisal Co., Inc.
  980. deleteFlag: 0
  981. referenceAppraiserId: null
  982. referenceTaxDeclarationId: null
  983. reportDate: 2018-12-11
  984. reportType:
  985. }
  986. paymentType: class PaymentType {
  987. paymentTypeId: 2
  988. paymentTypeText: null
  989. }
  990. propertyClassification: class PropertyClassification {
  991. propertyClassificationId: 15
  992. propertyClassificationText: null
  993. }
  994. }
  995. improvementTaxDeclarationDetails: null
  996. areaValue: 943
  997. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  998. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  999. loanValueRateFlag: 0
  1000. collateralOwnership: class CollateralOwnership {
  1001. collateralOwnershipId: 1
  1002. collateralOwnershipText: null
  1003.  
  1004. propertyCategory: null
  1005. registryOfDeeds: class RegistryOfDeeds {
  1006. registryOfDeedsId: 16
  1007. registryOfDeedsText: null
  1008. }
  1009. refRemId: null
  1010. }]
  1011. initialLoanValueRatePct: 1
  1012. finalLoanValueRatePct: 1
  1013. loanValueRateFlag: 0
  1014. bankBranch: null
  1015. loanType: null
  1016. }]
  1017. }
  1018. bankRemDetails: null
  1019. }
  1020. 2018-12-11 17:52:38.454 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.RemDetailsDao : MCO: upsertEubRemOnSession
  1021. 2018-12-11 17:52:38.454 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCO: upsertRemDetailsOnSession
  1022. 2018-12-11 17:52:38.454 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCO: upsertDetailsOnSession
  1023. 2018-12-11 17:52:38.454 DEBUG 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : Upsert collateral: class Collateral {
  1024. collateralId: 209
  1025. collateralNum: 405
  1026. collateralTypeId: 4
  1027. bankId: null
  1028. collateralStatusId: null
  1029. creditFacilityText: null
  1030. collateralValueNum: null
  1031. availableValueNum: null
  1032. creationDate: null
  1033. lastUpdateDate: null
  1034. updaterName: null
  1035. batchReferenceNum: _.2018000103
  1036. remDetails: class RemDetails {
  1037. remId: 59
  1038. remAmountNum: 100000.00
  1039. eubRemDetails: class PromisoryNoteDetails {
  1040. deedOfAssignment: null
  1041. borrowers: null
  1042. promisoryNotes: [class PromisoryNote {
  1043. promisoryNoteId: 210
  1044. promisoryNoteNum: 888
  1045. bankBranchText: null
  1046. grantDate: 2018-12-11
  1047. dueDate: 2018-12-11
  1048. projectLocationText: null
  1049. loanTypeText: null
  1050. bankRatePct: 1.000000
  1051. bankPenaltyRatePct: 1.000000
  1052. faceAmountNum: 1.00
  1053. outstandingBalanceNum: 5000000.00
  1054. listOfTitleDetails: [class TitleDetails {
  1055. titleDetailsId: 89
  1056. tctTypeText: Condominium Certificate of Title (CCT)
  1057. titleNum: 400
  1058. owner: class Owner {
  1059. registeredOwnerName: Jervin
  1060. ownerBirthdate: 2000-01-01
  1061. ownerTaxIdentificationNumber: 325
  1062. }
  1063. locationText: Pasay City
  1064. areaText: 943
  1065. unitOfMeasurementText: Square Meter
  1066. loanValueNum: 2000000.00
  1067. loanValueRatePct: null
  1068. landTaxDeclarationDetails: class TaxDeclarationDetails {
  1069. taxDeclarationDetailsId: 97
  1070. taxDeclarationNum: 494
  1071. totalAssessedValueNum: 530000.00
  1072. retrNum: 433
  1073. receiptDate: 2018-12-10
  1074. paymentAmountNum: 5000000.00
  1075. beginningCoverageDate: 2001-01-01
  1076. endingCoverageDate: 2001-12-31
  1077. insuranceDetails: null
  1078. taxDeclarationType: LAND
  1079. referenceTitleId: null
  1080. yearNum: 2001
  1081. appraisalReport: class AppraisalReport {
  1082. appraisalReportId: 67
  1083. appraisedAmountValue: 5000000.00
  1084. appraiserName: Philippine Appraisal Co., Inc.
  1085. deleteFlag: 0
  1086. referenceAppraiserId: null
  1087. referenceTaxDeclarationId: null
  1088. reportDate: 2018-12-11
  1089. reportType:
  1090. }
  1091. paymentType: class PaymentType {
  1092. paymentTypeId: 2
  1093. paymentTypeText: null
  1094. }
  1095. propertyClassification: class PropertyClassification {
  1096. propertyClassificationId: 15
  1097. propertyClassificationText: null
  1098. }
  1099. }
  1100. improvementTaxDeclarationDetails: null
  1101. areaValue: 943
  1102. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  1103. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  1104. loanValueRateFlag: 0
  1105. collateralOwnership: class CollateralOwnership {
  1106. collateralOwnershipId: 1
  1107. collateralOwnershipText: null
  1108.  
  1109. propertyCategory: null
  1110. registryOfDeeds: class RegistryOfDeeds {
  1111. registryOfDeedsId: 16
  1112. registryOfDeedsText: null
  1113. }
  1114. refRemId: null
  1115. }]
  1116. initialLoanValueRatePct: 1
  1117. finalLoanValueRatePct: 1
  1118. loanValueRateFlag: 0
  1119. bankBranch: null
  1120. loanType: null
  1121. }]
  1122. }
  1123. bankRemDetails: null
  1124. }
  1125. gsDetails: null
  1126. deficiencies: null
  1127. }
  1128. 2018-12-11 17:52:38.454 INFO 23032 --- [nio-8000-exec-1] g.b.lcmis.collaterals.dao.CollateralDao : MCO: upsertCollateralOnSession
  1129. 2018-12-11 17:52:38.462 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.dao.session.MyBatisHelper : MCO: executeTransaction
  1130. 2018-12-11 17:52:38.484 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.util.CollateralLoanValueHelper : MCI: computeLoanValueAndRate
  1131. 2018-12-11 17:52:38.485 WARN 23032 --- [nio-8000-exec-1] g.b.l.c.util.CollateralLoanValueHelper : Unknown collateral type: class Collateral {
  1132. collateralId: 209
  1133. collateralNum: 405
  1134. collateralTypeId: 4
  1135. bankId: null
  1136. collateralStatusId: null
  1137. creditFacilityText: null
  1138. collateralValueNum: null
  1139. availableValueNum: null
  1140. creationDate: null
  1141. lastUpdateDate: null
  1142. updaterName: null
  1143. batchReferenceNum: _.2018000103
  1144. remDetails: class RemDetails {
  1145. remId: 59
  1146. remAmountNum: 100000.00
  1147. eubRemDetails: class PromisoryNoteDetails {
  1148. deedOfAssignment: null
  1149. borrowers: null
  1150. promisoryNotes: [class PromisoryNote {
  1151. promisoryNoteId: 210
  1152. promisoryNoteNum: 888
  1153. bankBranchText: null
  1154. grantDate: 2018-12-11
  1155. dueDate: 2018-12-11
  1156. projectLocationText: null
  1157. loanTypeText: null
  1158. bankRatePct: 1.000000
  1159. bankPenaltyRatePct: 1.000000
  1160. faceAmountNum: 1.00
  1161. outstandingBalanceNum: 5000000.00
  1162. listOfTitleDetails: [class TitleDetails {
  1163. titleDetailsId: 89
  1164. tctTypeText: Condominium Certificate of Title (CCT)
  1165. titleNum: 400
  1166. owner: class Owner {
  1167. registeredOwnerName: Jervin
  1168. ownerBirthdate: 2000-01-01
  1169. ownerTaxIdentificationNumber: 325
  1170. }
  1171. locationText: Pasay City
  1172. areaText: 943
  1173. unitOfMeasurementText: Square Meter
  1174. loanValueNum: 2000000.00
  1175. loanValueRatePct: null
  1176. landTaxDeclarationDetails: class TaxDeclarationDetails {
  1177. taxDeclarationDetailsId: 97
  1178. taxDeclarationNum: 494
  1179. totalAssessedValueNum: 530000.00
  1180. retrNum: 433
  1181. receiptDate: 2018-12-10
  1182. paymentAmountNum: 5000000.00
  1183. beginningCoverageDate: 2001-01-01
  1184. endingCoverageDate: 2001-12-31
  1185. insuranceDetails: null
  1186. taxDeclarationType: LAND
  1187. referenceTitleId: null
  1188. yearNum: 2001
  1189. appraisalReport: class AppraisalReport {
  1190. appraisalReportId: 67
  1191. appraisedAmountValue: 5000000.00
  1192. appraiserName: Philippine Appraisal Co., Inc.
  1193. deleteFlag: 0
  1194. referenceAppraiserId: null
  1195. referenceTaxDeclarationId: null
  1196. reportDate: 2018-12-11
  1197. reportType:
  1198. }
  1199. paymentType: class PaymentType {
  1200. paymentTypeId: 2
  1201. paymentTypeText: null
  1202. }
  1203. propertyClassification: class PropertyClassification {
  1204. propertyClassificationId: 15
  1205. propertyClassificationText: null
  1206. }
  1207. }
  1208. improvementTaxDeclarationDetails: null
  1209. areaValue: 943
  1210. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  1211. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  1212. loanValueRateFlag: 0
  1213. collateralOwnership: class CollateralOwnership {
  1214. collateralOwnershipId: 1
  1215. collateralOwnershipText: null
  1216.  
  1217. propertyCategory: null
  1218. registryOfDeeds: class RegistryOfDeeds {
  1219. registryOfDeedsId: 16
  1220. registryOfDeedsText: null
  1221. }
  1222. refRemId: null
  1223. }]
  1224. initialLoanValueRatePct: 1
  1225. finalLoanValueRatePct: 1
  1226. loanValueRateFlag: 0
  1227. bankBranch: null
  1228. loanType: null
  1229. }]
  1230. }
  1231. bankRemDetails: null
  1232. }
  1233. gsDetails: null
  1234. deficiencies: null
  1235. }
  1236. 2018-12-11 17:52:38.486 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.util.CollateralLoanValueHelper : MCO: computeLoanValueAndRate
  1237. 2018-12-11 17:52:38.487 DEBUG 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : Result :class Collateral {
  1238. collateralId: 209
  1239. collateralNum: 405
  1240. collateralTypeId: 4
  1241. bankId: null
  1242. collateralStatusId: null
  1243. creditFacilityText: null
  1244. collateralValueNum: null
  1245. availableValueNum: null
  1246. creationDate: null
  1247. lastUpdateDate: null
  1248. updaterName: null
  1249. batchReferenceNum: _.2018000103
  1250. remDetails: class RemDetails {
  1251. remId: 59
  1252. remAmountNum: 100000.00
  1253. eubRemDetails: class PromisoryNoteDetails {
  1254. deedOfAssignment: null
  1255. borrowers: null
  1256. promisoryNotes: [class PromisoryNote {
  1257. promisoryNoteId: 210
  1258. promisoryNoteNum: 888
  1259. bankBranchText: null
  1260. grantDate: 2018-12-11
  1261. dueDate: 2018-12-11
  1262. projectLocationText: null
  1263. loanTypeText: null
  1264. bankRatePct: 1.000000
  1265. bankPenaltyRatePct: 1.000000
  1266. faceAmountNum: 1.00
  1267. outstandingBalanceNum: 5000000.00
  1268. listOfTitleDetails: [class TitleDetails {
  1269. titleDetailsId: 89
  1270. tctTypeText: Condominium Certificate of Title (CCT)
  1271. titleNum: 400
  1272. owner: class Owner {
  1273. registeredOwnerName: Jervin
  1274. ownerBirthdate: 2000-01-01
  1275. ownerTaxIdentificationNumber: 325
  1276. }
  1277. locationText: Pasay City
  1278. areaText: 943
  1279. unitOfMeasurementText: Square Meter
  1280. loanValueNum: 2000000.00
  1281. loanValueRatePct: null
  1282. landTaxDeclarationDetails: class TaxDeclarationDetails {
  1283. taxDeclarationDetailsId: 97
  1284. taxDeclarationNum: 494
  1285. totalAssessedValueNum: 530000.00
  1286. retrNum: 433
  1287. receiptDate: 2018-12-10
  1288. paymentAmountNum: 5000000.00
  1289. beginningCoverageDate: 2001-01-01
  1290. endingCoverageDate: 2001-12-31
  1291. insuranceDetails: null
  1292. taxDeclarationType: LAND
  1293. referenceTitleId: null
  1294. yearNum: 2001
  1295. appraisalReport: class AppraisalReport {
  1296. appraisalReportId: 67
  1297. appraisedAmountValue: 5000000.00
  1298. appraiserName: Philippine Appraisal Co., Inc.
  1299. deleteFlag: 0
  1300. referenceAppraiserId: null
  1301. referenceTaxDeclarationId: null
  1302. reportDate: 2018-12-11
  1303. reportType:
  1304. }
  1305. paymentType: class PaymentType {
  1306. paymentTypeId: 2
  1307. paymentTypeText: null
  1308. }
  1309. propertyClassification: class PropertyClassification {
  1310. propertyClassificationId: 15
  1311. propertyClassificationText: null
  1312. }
  1313. }
  1314. improvementTaxDeclarationDetails: null
  1315. areaValue: 943
  1316. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  1317. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  1318. loanValueRateFlag: 0
  1319. collateralOwnership: class CollateralOwnership {
  1320. collateralOwnershipId: 1
  1321. collateralOwnershipText: null
  1322.  
  1323. propertyCategory: null
  1324. registryOfDeeds: class RegistryOfDeeds {
  1325. registryOfDeedsId: 16
  1326. registryOfDeedsText: null
  1327. }
  1328. refRemId: null
  1329. }]
  1330. initialLoanValueRatePct: 1
  1331. finalLoanValueRatePct: 1
  1332. loanValueRateFlag: 0
  1333. bankBranch: null
  1334. loanType: null
  1335. }]
  1336. }
  1337. bankRemDetails: null
  1338. }
  1339. gsDetails: null
  1340. deficiencies: null
  1341. }
  1342. 2018-12-11 17:52:38.487 INFO 23032 --- [nio-8000-exec-1] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: encode
  1343. 2018-12-11 17:52:38.487 DEBUG 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : Result :class Collateral {
  1344. collateralId: 209
  1345. collateralNum: 405
  1346. collateralTypeId: 4
  1347. bankId: null
  1348. collateralStatusId: null
  1349. creditFacilityText: null
  1350. collateralValueNum: null
  1351. availableValueNum: null
  1352. creationDate: null
  1353. lastUpdateDate: null
  1354. updaterName: null
  1355. batchReferenceNum: _.2018000103
  1356. remDetails: class RemDetails {
  1357. remId: 59
  1358. remAmountNum: 100000.00
  1359. eubRemDetails: class PromisoryNoteDetails {
  1360. deedOfAssignment: null
  1361. borrowers: null
  1362. promisoryNotes: [class PromisoryNote {
  1363. promisoryNoteId: 210
  1364. promisoryNoteNum: 888
  1365. bankBranchText: null
  1366. grantDate: 2018-12-11
  1367. dueDate: 2018-12-11
  1368. projectLocationText: null
  1369. loanTypeText: null
  1370. bankRatePct: 1.000000
  1371. bankPenaltyRatePct: 1.000000
  1372. faceAmountNum: 1.00
  1373. outstandingBalanceNum: 5000000.00
  1374. listOfTitleDetails: [class TitleDetails {
  1375. titleDetailsId: 89
  1376. tctTypeText: Condominium Certificate of Title (CCT)
  1377. titleNum: 400
  1378. owner: class Owner {
  1379. registeredOwnerName: Jervin
  1380. ownerBirthdate: 2000-01-01
  1381. ownerTaxIdentificationNumber: 325
  1382. }
  1383. locationText: Pasay City
  1384. areaText: 943
  1385. unitOfMeasurementText: Square Meter
  1386. loanValueNum: 2000000.00
  1387. loanValueRatePct: null
  1388. landTaxDeclarationDetails: class TaxDeclarationDetails {
  1389. taxDeclarationDetailsId: 97
  1390. taxDeclarationNum: 494
  1391. totalAssessedValueNum: 530000.00
  1392. retrNum: 433
  1393. receiptDate: 2018-12-10
  1394. paymentAmountNum: 5000000.00
  1395. beginningCoverageDate: 2001-01-01
  1396. endingCoverageDate: 2001-12-31
  1397. insuranceDetails: null
  1398. taxDeclarationType: LAND
  1399. referenceTitleId: null
  1400. yearNum: 2001
  1401. appraisalReport: class AppraisalReport {
  1402. appraisalReportId: 67
  1403. appraisedAmountValue: 5000000.00
  1404. appraiserName: Philippine Appraisal Co., Inc.
  1405. deleteFlag: 0
  1406. referenceAppraiserId: null
  1407. referenceTaxDeclarationId: null
  1408. reportDate: 2018-12-11
  1409. reportType:
  1410. }
  1411. paymentType: class PaymentType {
  1412. paymentTypeId: 2
  1413. paymentTypeText: null
  1414. }
  1415. propertyClassification: class PropertyClassification {
  1416. propertyClassificationId: 15
  1417. propertyClassificationText: null
  1418. }
  1419. }
  1420. improvementTaxDeclarationDetails: null
  1421. areaValue: 943
  1422. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  1423. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  1424. loanValueRateFlag: 0
  1425. collateralOwnership: class CollateralOwnership {
  1426. collateralOwnershipId: 1
  1427. collateralOwnershipText: null
  1428.  
  1429. propertyCategory: null
  1430. registryOfDeeds: class RegistryOfDeeds {
  1431. registryOfDeedsId: 16
  1432. registryOfDeedsText: null
  1433. }
  1434. refRemId: null
  1435. }]
  1436. initialLoanValueRatePct: 1
  1437. finalLoanValueRatePct: 1
  1438. loanValueRateFlag: 0
  1439. bankBranch: null
  1440. loanType: null
  1441. }]
  1442. }
  1443. bankRemDetails: null
  1444. }
  1445. gsDetails: null
  1446. deficiencies: null
  1447. }
  1448. 2018-12-11 17:52:38.488 INFO 23032 --- [nio-8000-exec-1] g.b.l.c.service.RemDetailsServiceImpl : MCO: saveRemDetails
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!