API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
76
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 39.50 KB | None | 0 0
raw download clone embed print report
  1. 2018-12-11 15:41:33.998 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: createNewBatch
  2. 2018-12-11 15:41:33.998 DEBUG 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : Collateral Batch: class CollateralBatch {
  3. batchReferenceNum: null
  4. bank: class Bank {
  5. bankId: 1
  6. bankCode: BPI
  7. bankEntity: null
  8. deleteFlag: false
  9. bankName: Bank of the Philippine Islands
  10. bankStatus: Operating
  11. dateJoined: 1999-05-21
  12. bankAddress: Gapan Nueva Ecija
  13. dateClosed: null
  14. refBalanceId: 1
  15. refBankTypeId: 2
  16. cwtFlag: true
  17. deleteFlag: false
  18. bankResolutionNo: null
  19. }
  20. approvalStatus: null
  21. creditFacility: class CreditFacility {
  22. creditFacilityId: 23
  23. creditFacility: null
  24. }
  25. documentaryRequirements: null
  26. dateCreated: null
  27. userName: Mark.Nipes
  28. lastUpdateUser: null
  29. lastUpdateTimestamp: null
  30.  
  31. 2018-12-11 15:41:33.998 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.v.CollateralBatchChecker : MCI: checkForCreation
  32. 2018-12-11 15:41:33.998 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.v.CollateralBatchChecker : MCO: checkForCreation
  33. 2018-12-11 15:41:34.033 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.dao.session.MyBatisHelper : MCI: executeTransaction
  34. 2018-12-11 15:41:34.033 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  35. 2018-12-11 15:41:34.033 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  36. 2018-12-11 15:41:34.288 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  37. 2018-12-11 15:41:34.288 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  38. 2018-12-11 15:41:34.288 INFO 1648 --- [nio-8000-exec-2] gov.bsp.lcmis.collaterals.dao.BatchDao : MCI: createNewBatchOnSession
  39. 2018-12-11 15:41:34.768 DEBUG 1648 --- [nio-8000-exec-2] 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
  40. 2018-12-11 15:41:34.792 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.BatchMapper.createNewBatch : ==> Parameters: 1(Integer), 23(Integer), Mark.Nipes(String)
  41. 2018-12-11 15:41:34.935 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.BatchMapper.createNewBatch : <== Total: 1
  42. 2018-12-11 15:41:34.935 DEBUG 1648 --- [nio-8000-exec-2] gov.bsp.lcmis.collaterals.dao.BatchDao : Create new batch: class CollateralBatch {
  43. batchReferenceNum: _.2018000098
  44. bank: class Bank {
  45. bankId: 1
  46. bankCode: null
  47. bankEntity: null
  48. deleteFlag: null
  49. bankName: null
  50. bankStatus: null
  51. dateJoined: null
  52. bankAddress: null
  53. dateClosed: null
  54. refBalanceId: null
  55. refBankTypeId: null
  56. cwtFlag: null
  57. deleteFlag: null
  58. bankResolutionNo: null
  59. }
  60. approvalStatus: null
  61. creditFacility: class CreditFacility {
  62. creditFacilityId: 23
  63. creditFacility: null
  64. }
  65. documentaryRequirements: []
  66. dateCreated: 2018-12-11 07:41:01.881382
  67. userName: null
  68. lastUpdateUser: 13
  69. lastUpdateTimestamp: 2018-12-11 07:41:01.881382
  70.  
  71. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] gov.bsp.lcmis.collaterals.dao.BatchDao : MCO: createNewBatchOnSession
  72. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.dao.session.MyBatisHelper : MCO: executeTransaction
  73. 2018-12-11 15:41:34.935 DEBUG 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : Result :class CollateralBatch {
  74. batchReferenceNum: _.2018000098
  75. bank: class Bank {
  76. bankId: 1
  77. bankCode: null
  78. bankEntity: null
  79. deleteFlag: null
  80. bankName: null
  81. bankStatus: null
  82. dateJoined: null
  83. bankAddress: null
  84. dateClosed: null
  85. refBalanceId: null
  86. refBankTypeId: null
  87. cwtFlag: null
  88. deleteFlag: null
  89. bankResolutionNo: null
  90. }
  91. approvalStatus: null
  92. creditFacility: class CreditFacility {
  93. creditFacilityId: 23
  94. creditFacility: null
  95. }
  96. documentaryRequirements: []
  97. dateCreated: 2018-12-11 07:41:01.881382
  98. userName: null
  99. lastUpdateUser: 13
  100. lastUpdateTimestamp: 2018-12-11 07:41:01.881382
  101.  
  102. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: createNewBatch
  103. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.service.RemDetailsServiceImpl : MCI: saveRemDetails
  104. 2018-12-11 15:41:34.935 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.service.RemDetailsServiceImpl : Collateral: class Collateral {
  105. collateralId: 10110
  106. collateralNum: 400
  107. collateralTypeId: 4
  108. bankId: class Bank {
  109. bankId: 1
  110. bankCode: BPI
  111. bankEntity: null
  112. deleteFlag: false
  113. bankName: Bank of the Philippine Islands
  114. bankStatus: Operating
  115. dateJoined: 1999-05-21
  116. bankAddress: Gapan Nueva Ecija
  117. dateClosed: null
  118. refBalanceId: 1
  119. refBankTypeId: 2
  120. cwtFlag: true
  121. deleteFlag: false
  122. bankResolutionNo: null
  123. }
  124. collateralStatusId: null
  125. creditFacilityText: class CreditFacility {
  126. creditFacilityId: 23
  127. creditFacility: null
  128. }
  129. collateralValueNum: null
  130. availableValueNum: null
  131. creationDate: null
  132. lastUpdateDate: null
  133. updaterName: null
  134. batchReferenceNum: _.2018000095
  135. remDetails: class RemDetails {
  136. remId: 58
  137. remAmountNum: 600000.00
  138. eubRemDetails: class PromisoryNoteDetails {
  139. deedOfAssignment: null
  140. borrowers: null
  141. promisoryNotes: [class PromisoryNote {
  142. promisoryNoteId: null
  143. promisoryNoteNum: 345
  144. bankBranchText: null
  145. grantDate: 2018-12-10
  146. dueDate: 2018-12-10
  147. projectLocationText: Marikina
  148. loanTypeText: null
  149. bankRatePct: 1.000000
  150. bankPenaltyRatePct: 1.000000
  151. faceAmountNum: 1.00
  152. outstandingBalanceNum: 5000000.00
  153. listOfTitleDetails: [class TitleDetails {
  154. titleDetailsId: 10110
  155. tctTypeText: Condominium Certificate of Title (CCT)
  156. titleNum: 400
  157. owner: class Owner {
  158. registeredOwnerName: Jervin
  159. ownerBirthdate: 2018-12-10
  160. ownerTaxIdentificationNumber: 325
  161. }
  162. locationText: Quezon City
  163. areaText: 943
  164. unitOfMeasurementText: Square Meter
  165. loanValueNum: 2000000.00
  166. loanValueRatePct: null
  167. landTaxDeclarationDetails: class TaxDeclarationDetails {
  168. taxDeclarationDetailsId: null
  169. taxDeclarationNum: 494
  170. totalAssessedValueNum: 530000.00
  171. retrNum: 433
  172. receiptDate: 2018-12-10
  173. paymentAmountNum: 5000000.00
  174. beginningCoverageDate: 2001-01-01
  175. endingCoverageDate: 2001-12-31
  176. insuranceDetails: null
  177. taxDeclarationType: LAND
  178. referenceTitleId: null
  179. yearNum: 2001
  180. appraisalReport: class AppraisalReport {
  181. appraisalReportId: 67
  182. appraisedAmountValue: 5000000.00
  183. appraiserName: Philippine Appraisal Co., Inc.
  184. deleteFlag: 0
  185. referenceAppraiserId: null
  186. referenceTaxDeclarationId: null
  187. reportDate: 2018-12-10
  188. reportType:
  189. }
  190. paymentType: class PaymentType {
  191. paymentTypeId: 2
  192. paymentTypeText: null
  193. }
  194. propertyClassification: class PropertyClassification {
  195. propertyClassificationId: 15
  196. propertyClassificationText: null
  197. }
  198. }
  199. improvementTaxDeclarationDetails: null
  200. areaValue: 943
  201. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  202. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  203. loanValueRateFlag: 0
  204. collateralOwnership: class CollateralOwnership {
  205. collateralOwnershipId: 1
  206. collateralOwnershipText: null
  207.  
  208. propertyCategory: class PropertyCategory {
  209. propertyCategoryId: 2
  210. propertyCategoryText: Agro Industrial
  211. }
  212. registryOfDeeds: class RegistryOfDeeds {
  213. registryOfDeedsId: 16
  214. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  215. }
  216. refRemId: null
  217. }]
  218. initialLoanValueRatePct: 1
  219. finalLoanValueRatePct: 1
  220. loanValueRateFlag: 0
  221. bankBranch: null
  222. loanType: null
  223. }]
  224. }
  225. bankRemDetails: null
  226. }
  227. gsDetails: null
  228. deficiencies: null
  229. }. Collateral Batch: class CollateralBatch {
  230. batchReferenceNum: _.2018000098
  231. bank: class Bank {
  232. bankId: 1
  233. bankCode: null
  234. bankEntity: null
  235. deleteFlag: null
  236. bankName: null
  237. bankStatus: null
  238. dateJoined: null
  239. bankAddress: null
  240. dateClosed: null
  241. refBalanceId: null
  242. refBankTypeId: null
  243. cwtFlag: null
  244. deleteFlag: null
  245. bankResolutionNo: null
  246. }
  247. approvalStatus: null
  248. creditFacility: class CreditFacility {
  249. creditFacilityId: 23
  250. creditFacility: null
  251. }
  252. documentaryRequirements: []
  253. dateCreated: 2018-12-11 07:41:01.881382
  254. userName: null
  255. lastUpdateUser: 13
  256. lastUpdateTimestamp: 2018-12-11 07:41:01.881382
  257.  
  258. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.service.RemDetailsServiceImpl : MCI: validatePromisoryNote
  259. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.s.PromisoryNoteServiceImpl : MCI >> checkForUpsert
  260. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.PromisoryNoteChecker : MCI: checkForEncoding
  261. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.TitleDetailsChecker : MCI: checkForEncode
  262. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.OwnerChecker : MCI: checkForEncode
  263. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.OwnerChecker : MCO: checkForEncode
  264. 2018-12-11 15:41:34.935 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.v.TaxDeclarationChecker : MCI: checkForEncode
  265. ...1...
  266. ...2...
  267. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.v.AppraisalReportChecker : MCI: checkForEncode
  268. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.v.AppraisalReportChecker : MCO: checkForEncode
  269. ...3...
  270. ...5...
  271. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.v.TaxDeclarationChecker : MCO: checkForEncode
  272. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.TitleDetailsChecker : MCO: checkForEncode
  273. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.PromisoryNoteChecker : MCO: checkForEncoding
  274. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.s.PromisoryNoteServiceImpl : MCO >> checkForUpsert
  275. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.service.RemDetailsServiceImpl : MCO: validatePromisoryNote
  276. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: encode
  277. 2018-12-11 15:41:34.950 DEBUG 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : Collateral: class Collateral {
  278. collateralId: 10110
  279. collateralNum: 400
  280. collateralTypeId: 4
  281. bankId: class Bank {
  282. bankId: 1
  283. bankCode: BPI
  284. bankEntity: null
  285. deleteFlag: false
  286. bankName: Bank of the Philippine Islands
  287. bankStatus: Operating
  288. dateJoined: 1999-05-21
  289. bankAddress: Gapan Nueva Ecija
  290. dateClosed: null
  291. refBalanceId: 1
  292. refBankTypeId: 2
  293. cwtFlag: true
  294. deleteFlag: false
  295. bankResolutionNo: null
  296. }
  297. collateralStatusId: null
  298. creditFacilityText: class CreditFacility {
  299. creditFacilityId: 23
  300. creditFacility: null
  301. }
  302. collateralValueNum: null
  303. availableValueNum: null
  304. creationDate: null
  305. lastUpdateDate: null
  306. updaterName: null
  307. batchReferenceNum: _.2018000095
  308. remDetails: class RemDetails {
  309. remId: 58
  310. remAmountNum: 600000.00
  311. eubRemDetails: class PromisoryNoteDetails {
  312. deedOfAssignment: null
  313. borrowers: null
  314. promisoryNotes: [class PromisoryNote {
  315. promisoryNoteId: null
  316. promisoryNoteNum: 345
  317. bankBranchText: null
  318. grantDate: 2018-12-10
  319. dueDate: 2018-12-10
  320. projectLocationText: Marikina
  321. loanTypeText: null
  322. bankRatePct: 1.000000
  323. bankPenaltyRatePct: 1.000000
  324. faceAmountNum: 1.00
  325. outstandingBalanceNum: 5000000.00
  326. listOfTitleDetails: [class TitleDetails {
  327. titleDetailsId: 10110
  328. tctTypeText: Condominium Certificate of Title (CCT)
  329. titleNum: 400
  330. owner: class Owner {
  331. registeredOwnerName: Jervin
  332. ownerBirthdate: 2018-12-10
  333. ownerTaxIdentificationNumber: 325
  334. }
  335. locationText: Quezon City
  336. areaText: 943
  337. unitOfMeasurementText: Square Meter
  338. loanValueNum: 2000000.00
  339. loanValueRatePct: null
  340. landTaxDeclarationDetails: class TaxDeclarationDetails {
  341. taxDeclarationDetailsId: null
  342. taxDeclarationNum: 494
  343. totalAssessedValueNum: 530000.00
  344. retrNum: 433
  345. receiptDate: 2018-12-10
  346. paymentAmountNum: 5000000.00
  347. beginningCoverageDate: 2001-01-01
  348. endingCoverageDate: 2001-12-31
  349. insuranceDetails: null
  350. taxDeclarationType: LAND
  351. referenceTitleId: null
  352. yearNum: 2001
  353. appraisalReport: class AppraisalReport {
  354. appraisalReportId: 67
  355. appraisedAmountValue: 5000000.00
  356. appraiserName: Philippine Appraisal Co., Inc.
  357. deleteFlag: 0
  358. referenceAppraiserId: null
  359. referenceTaxDeclarationId: null
  360. reportDate: 2018-12-10
  361. reportType:
  362. }
  363. paymentType: class PaymentType {
  364. paymentTypeId: 2
  365. paymentTypeText: null
  366. }
  367. propertyClassification: class PropertyClassification {
  368. propertyClassificationId: 15
  369. propertyClassificationText: null
  370. }
  371. }
  372. improvementTaxDeclarationDetails: null
  373. areaValue: 943
  374. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  375. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  376. loanValueRateFlag: 0
  377. collateralOwnership: class CollateralOwnership {
  378. collateralOwnershipId: 1
  379. collateralOwnershipText: null
  380.  
  381. propertyCategory: class PropertyCategory {
  382. propertyCategoryId: 2
  383. propertyCategoryText: Agro Industrial
  384. }
  385. registryOfDeeds: class RegistryOfDeeds {
  386. registryOfDeedsId: 16
  387. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  388. }
  389. refRemId: null
  390. }]
  391. initialLoanValueRatePct: 1
  392. finalLoanValueRatePct: 1
  393. loanValueRateFlag: 0
  394. bankBranch: null
  395. loanType: null
  396. }]
  397. }
  398. bankRemDetails: null
  399. }
  400. gsDetails: null
  401. deficiencies: null
  402. }. Collateral Batch: class CollateralBatch {
  403. batchReferenceNum: _.2018000098
  404. bank: class Bank {
  405. bankId: 1
  406. bankCode: null
  407. bankEntity: null
  408. deleteFlag: null
  409. bankName: null
  410. bankStatus: null
  411. dateJoined: null
  412. bankAddress: null
  413. dateClosed: null
  414. refBalanceId: null
  415. refBankTypeId: null
  416. cwtFlag: null
  417. deleteFlag: null
  418. bankResolutionNo: null
  419. }
  420. approvalStatus: null
  421. creditFacility: class CreditFacility {
  422. creditFacilityId: 23
  423. creditFacility: null
  424. }
  425. documentaryRequirements: []
  426. dateCreated: 2018-12-11 07:41:01.881382
  427. userName: null
  428. lastUpdateUser: 13
  429. lastUpdateTimestamp: 2018-12-11 07:41:01.881382
  430.  
  431. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.CollateralChecker : MCI: checkForEncodeRem
  432. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.CollateralChecker : MCI: checkForEncode
  433. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.CollateralChecker : MCO: checkForEncode
  434. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.CollateralChecker : MCO: checkForEncodeRem
  435. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: checkTitlesValidity
  436. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCI: checkTitleDetailsValidity
  437. 2018-12-11 15:41:34.950 DEBUG 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : Titles: [class TitleDetails {
  438. titleDetailsId: 10110
  439. tctTypeText: Condominium Certificate of Title (CCT)
  440. titleNum: 400
  441. owner: class Owner {
  442. registeredOwnerName: Jervin
  443. ownerBirthdate: 2018-12-10
  444. ownerTaxIdentificationNumber: 325
  445. }
  446. locationText: Quezon City
  447. areaText: 943
  448. unitOfMeasurementText: Square Meter
  449. loanValueNum: 2000000.00
  450. loanValueRatePct: null
  451. landTaxDeclarationDetails: class TaxDeclarationDetails {
  452. taxDeclarationDetailsId: null
  453. taxDeclarationNum: 494
  454. totalAssessedValueNum: 530000.00
  455. retrNum: 433
  456. receiptDate: 2018-12-10
  457. paymentAmountNum: 5000000.00
  458. beginningCoverageDate: 2001-01-01
  459. endingCoverageDate: 2001-12-31
  460. insuranceDetails: null
  461. taxDeclarationType: LAND
  462. referenceTitleId: null
  463. yearNum: 2001
  464. appraisalReport: class AppraisalReport {
  465. appraisalReportId: 67
  466. appraisedAmountValue: 5000000.00
  467. appraiserName: Philippine Appraisal Co., Inc.
  468. deleteFlag: 0
  469. referenceAppraiserId: null
  470. referenceTaxDeclarationId: null
  471. reportDate: 2018-12-10
  472. reportType:
  473. }
  474. paymentType: class PaymentType {
  475. paymentTypeId: 2
  476. paymentTypeText: null
  477. }
  478. propertyClassification: class PropertyClassification {
  479. propertyClassificationId: 15
  480. propertyClassificationText: null
  481. }
  482. }
  483. improvementTaxDeclarationDetails: null
  484. areaValue: 943
  485. initialLoanValueRatePct: 0.40000000000000002220446049250313080847263336181640625
  486. finalLoanValueRatePct: 0.65000000000000002220446049250313080847263336181640625
  487. loanValueRateFlag: 0
  488. collateralOwnership: class CollateralOwnership {
  489. collateralOwnershipId: 1
  490. collateralOwnershipText: null
  491.  
  492. propertyCategory: class PropertyCategory {
  493. propertyCategoryId: 2
  494. propertyCategoryText: Agro Industrial
  495. }
  496. registryOfDeeds: class RegistryOfDeeds {
  497. registryOfDeedsId: 16
  498. registryOfDeedsText: RD - Province Of Rizal (Binangonan)
  499. }
  500. refRemId: null
  501. }]
  502. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.s.CollateralRetrieveServiceImpl : MCI: getRemCollateral
  503. 2018-12-11 15:41:34.950 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.s.CollateralRetrieveServiceImpl : Title Number: 400. Collateral Approval Status: null
  504. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : MCI: getRemCollaterals
  505. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  506. 2018-12-11 15:41:34.950 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  507. 2018-12-11 15:41:35.063 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  508. 2018-12-11 15:41:35.063 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  509. 2018-12-11 15:41:35.274 DEBUG 1648 --- [nio-8000-exec-2] 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 = ?)
  510. 2018-12-11 15:41:35.274 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.C.getRemCollaterals : ==> Parameters: 400(String), 400(String)
  511. 2018-12-11 15:41:35.336 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.C.getRemCollaterals : <== Total: 0
  512. 2018-12-11 15:41:35.336 DEBUG 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : Get REM collateral: null
  513. 2018-12-11 15:41:35.352 INFO 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : MCO: getRemCollaterals
  514. 2018-12-11 15:41:35.352 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.s.CollateralRetrieveServiceImpl : Result :null
  515. 2018-12-11 15:41:35.352 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.s.CollateralRetrieveServiceImpl : MCO: getRemCollateral
  516. 2018-12-11 15:41:35.352 DEBUG 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : Result :true
  517. 2018-12-11 15:41:35.352 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: checkTitleDetailsValidity
  518. 2018-12-11 15:41:35.352 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.TitleValidityChecker : MCI: checkValidForBank
  519. 2018-12-11 15:41:35.352 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.TitleValidityChecker : ...
  520. ...
  521. BANK: class Bank {
  522. bankId: 1
  523. bankCode: null
  524. bankEntity: null
  525. deleteFlag: null
  526. bankName: null
  527. bankStatus: null
  528. dateJoined: null
  529. bankAddress: null
  530. dateClosed: null
  531. refBalanceId: null
  532. refBankTypeId: null
  533. cwtFlag: null
  534. deleteFlag: null
  535. bankResolutionNo: null
  536. }
  537. 2018-12-11 15:41:35.367 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.dao.session.MyBatisHelper : MCI: executeQuery
  538. 2018-12-11 15:41:35.367 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  539. 2018-12-11 15:41:35.367 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  540. 2018-12-11 15:41:35.547 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  541. 2018-12-11 15:41:35.547 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  542. 2018-12-11 15:41:35.547 INFO 1648 --- [nio-8000-exec-2] g.b.l.collaterals.dao.TitleDetailsDao : MCI: getTitlesFromBankUnapprovedCollateral
  543. 2018-12-11 15:41:35.737 DEBUG 1648 --- [nio-8000-exec-2] 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 ( ? ) )
  544. 2018-12-11 15:41:35.737 DEBUG 1648 --- [nio-8000-exec-2] m.T.getTitleFromBankUnapprovedCollateral : ==> Parameters: 1(Integer), 400|Quezon City|943|Square Meter|16(String)
  545. 2018-12-11 15:41:35.758 DEBUG 1648 --- [nio-8000-exec-2] m.T.getTitleFromBankUnapprovedCollateral : <== Total: 0
  546. 2018-12-11 15:41:35.758 INFO 1648 --- [nio-8000-exec-2] g.b.l.collaterals.dao.TitleDetailsDao : MCO: getTitlesFromBankUnapprovedCollateral
  547. 2018-12-11 15:41:35.758 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.collaterals.dao.TitleDetailsDao : result={}
  548. 2018-12-11 15:41:35.774 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.dao.session.MyBatisHelper : MCO: executeQuery
  549. 2018-12-11 15:41:35.774 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.validation.TitleValidityChecker : MCO: checkValidForBank
  550. 2018-12-11 15:41:35.774 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: checkTitlesValidity
  551. 2018-12-11 15:41:35.836 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.dao.session.MyBatisHelper : MCI: executeTransaction
  552. 2018-12-11 15:41:35.836 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession(DataSource)
  553. 2018-12-11 15:41:35.836 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCI: createSqlSession
  554. 2018-12-11 15:41:35.914 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession
  555. 2018-12-11 15:41:35.914 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.d.session.MyBatisSessionFactory : MCO: createSqlSession(DataSource)
  556. 2018-12-11 15:41:36.124 DEBUG 1648 --- [nio-8000-exec-2] 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 = ? )
  557. 2018-12-11 15:41:36.140 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.C.updateCollateral : ==> Parameters: 400(String), null, _.2018000098(String), 10110(Integer)
  558. 2018-12-11 15:41:36.140 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.C.updateCollateral : <== Total: 0
  559. 2018-12-11 15:41:36.140 INFO 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : MCI: upsertCollateralOnSession
  560. 2018-12-11 15:41:36.140 DEBUG 1648 --- [nio-8000-exec-2] 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 (?, ?, ?, ?) )
  561. 2018-12-11 15:41:36.172 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.C.insertCollateral : ==> Parameters: 400(String), null, null, _.2018000098(String)
  562. 2018-12-11 15:41:36.172 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.d.m.C.insertCollateral : <== Total: 1
  563. 2018-12-11 15:41:36.172 INFO 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : MCI: upsertDetailsOnSession
  564. 2018-12-11 15:41:36.172 INFO 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : MCO: upsertDetailsOnSession
  565. 2018-12-11 15:41:36.172 DEBUG 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : Upsert collateral: class Collateral {
  566. collateralId: 204
  567. collateralNum: 400
  568. collateralTypeId: 4
  569. bankId: null
  570. collateralStatusId: null
  571. creditFacilityText: null
  572. collateralValueNum: null
  573. availableValueNum: null
  574. creationDate: null
  575. lastUpdateDate: null
  576. updaterName: null
  577. batchReferenceNum: _.2018000098
  578. remDetails: null
  579. gsDetails: null
  580. deficiencies: null
  581. }
  582. 2018-12-11 15:41:36.172 INFO 1648 --- [nio-8000-exec-2] g.b.lcmis.collaterals.dao.CollateralDao : MCO: upsertCollateralOnSession
  583. 2018-12-11 15:41:36.196 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.dao.session.MyBatisHelper : MCO: executeTransaction
  584. 2018-12-11 15:41:36.229 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.util.CollateralLoanValueHelper : MCI: computeLoanValueAndRate
  585. 2018-12-11 15:41:36.229 WARN 1648 --- [nio-8000-exec-2] g.b.l.c.util.CollateralLoanValueHelper : Unknown collateral type: class Collateral {
  586. collateralId: 204
  587. collateralNum: 400
  588. collateralTypeId: 4
  589. bankId: null
  590. collateralStatusId: null
  591. creditFacilityText: null
  592. collateralValueNum: null
  593. availableValueNum: null
  594. creationDate: null
  595. lastUpdateDate: null
  596. updaterName: null
  597. batchReferenceNum: _.2018000098
  598. remDetails: null
  599. gsDetails: null
  600. deficiencies: null
  601. }
  602. 2018-12-11 15:41:36.229 INFO 1648 --- [nio-8000-exec-2] g.b.l.c.util.CollateralLoanValueHelper : MCO: computeLoanValueAndRate
  603. 2018-12-11 15:41:36.229 DEBUG 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : Result :class Collateral {
  604. collateralId: 204
  605. collateralNum: 400
  606. collateralTypeId: 4
  607. bankId: null
  608. collateralStatusId: null
  609. creditFacilityText: null
  610. collateralValueNum: null
  611. availableValueNum: null
  612. creationDate: null
  613. lastUpdateDate: null
  614. updaterName: null
  615. batchReferenceNum: _.2018000098
  616. remDetails: null
  617. gsDetails: null
  618. deficiencies: null
  619. }
  620. 2018-12-11 15:41:36.229 INFO 1648 --- [nio-8000-exec-2] b.l.c.s.RemCollateralEncodingServiceImpl : MCO: encode
  621. 2018-12-11 15:41:36.229 DEBUG 1648 --- [nio-8000-exec-2] g.b.l.c.service.RemDetailsServiceImpl : Result :class Collateral {
  622. collateralId: 204
  623. collateralNum: 400
  624. collateralTypeId: 4
  625. bankId: null
  626. collateralStatusId: null
  627. creditFacilityText: null
  628. collateralValueNum: null
  629. availableValueNum: null
  630. creationDate: null
  631. lastUpdateDate: null
  632. updaterName: null
  633. batchReferenceNum: _.2018000098
  634. remDetails: null
  635. gsDetails: null
  636. deficiencies: null
  637. }
  638. 2018-12-11 15:41:36.229 INFO 1648 --- [nio-8000-exec-2] 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!