eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on FND_LOG

Line 493: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

489: PRAGMA EXCEPTION_INIT (x_multiple_line_error, -24381 ); -- ORA-24381: error(s) in array DML
490: BEGIN
491: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
492:
493: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Begin(+)');
496: END IF;
497: END IF;

Line 495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Begin(+)');

491: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
492:
493: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Begin(+)');
496: END IF;
497: END IF;
498:
499: ------------------------------------------------------------

Line 583: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'* Start Validation *');

579: -- -------------------------------
580: -- Process each cursor record
581: -- -------------------------------
582: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
583: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*** Start Validation ***');
584: END IF;
585:
586: g_batch_num := 0;
587:

Line 592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validating batch number: '||g_batch_num);

588: OPEN c_bill_chrgs;
589: LOOP
590: g_batch_num := g_batch_num + 1;
591: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validating batch number: '||g_batch_num);
593: END IF;
594:
595: l_rowid_tbl.delete;
596: l_contract_tbl.delete;

Line 616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> number of records: '||l_rowid_tbl.count);

612: l_strm_purpose_tbl
613: LIMIT L_FETCH_SIZE;
614:
615: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> number of records: '||l_rowid_tbl.count);
617: END IF;
618:
619: -- update global total rec count
620: g_total_rec_count := g_total_rec_count + l_rowid_tbl.count;

Line 627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate std who columns.');

623: -- update std who parameters in okl_ext_billing_interface
624: -- -------------------------------------------------------
625: if l_rowid_tbl.count > 0 then
626: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate std who columns.');
628: END IF;
629: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
630: update okl_ext_billing_interface
631: set CREATED_BY = l_last_updated_by,

Line 643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate std who columns.');

639: PROGRAM_UPDATE_DATE = sysdate
640: where rowid = l_rowid_tbl(indx);
641: COMMIT;
642: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate std who columns.');
644: END IF;
645: END IF;
646:
647: IF l_strm_purpose_tbl.count > 0 THEN

Line 652: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate stream type purpose.');

648: -- ---------------------------------
649: -- Validate Stream Type Purpose
650: -- ---------------------------------
651: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
652: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate stream type purpose.');
653: END IF;
654: forall indx in l_strm_purpose_tbl.first..l_strm_purpose_tbl.last
655: update okl_ext_billing_interface
656: set trx_status_code =

Line 674: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate stream type purpose.');

670: )
671: where rowid = l_rowid_tbl(indx);
672: COMMIT;
673: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
674: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate stream type purpose.');
675: END IF;
676: END IF; -- stream type purpose validation
677:
678: -- ---------------------------------

Line 683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate amount.');

679: -- Validate Amount
680: -- ---------------------------------
681: if l_amt_tbl.count > 0 then
682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate amount.');
684: END IF;
685: forall indx in l_amt_tbl.first..l_amt_tbl.last
686: update okl_ext_billing_interface
687: set trx_status_code = decode(l_amt_tbl(indx),NULL, 'ERROR',trx_status_code),

Line 695: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate amount.');

691: error_message)
692: where rowid = l_rowid_tbl(indx);
693: COMMIT;
694: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
695: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate amount.');
696: END IF;
697: END IF; -- Update rows to passed status
698:
699: -- ---------------------------------

Line 704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate contract number.');

700: -- Validate Contract
701: -- ---------------------------------
702: if l_contract_tbl.count > 0 then
703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate contract number.');
705: END IF;
706: FORALL indx in l_contract_tbl.first..l_contract_tbl.last
707: update okl_ext_billing_interface a
708: set contract_id = (select id

Line 714: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate contract number.');

710: where b.contract_number = a.contract_number)
711: where rowid = l_rowid_tbl(indx);
712: COMMIT;
713: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
714: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate contract number.');
715: END IF;
716: END IF;
717:
718: -- ---------------------------------

Line 731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate asset number.');

727: -- CASE 3 - When ASSET_NUMBER present and ASSET_ID is NULL, code checks if there are multiple
728: -- contract lines with same line name and errors accordingly
729: IF l_asset_num.count > 0 THEN
730: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate asset number.');
732: END IF;
733: BEGIN
734: FORALL indx IN l_asset_num.FIRST..l_asset_num.LAST SAVE EXCEPTIONS
735: UPDATE okl_ext_billing_interface a

Line 764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate asset number.');

760: END LOOP;
761: END; -- end of ASSET_ID updation
762: COMMIT;
763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate asset number.');
765: END IF;
766: END IF;
767: -- PAGARG - Bug# 6884934 - Modified End
768:

Line 774: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate stream type assignment to a stream generation template.');

770: -- Validate Stream Type Name
771: -- ---------------------------------
772: IF l_sty_tbl.count > 0 THEN
773: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
774: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate stream type assignment to a stream generation template.');
775: END IF;
776: forall indx in l_sty_tbl.first..l_sty_tbl.last
777: update okl_ext_billing_interface a
778: set sty_id = (SELECT GTLV.PRIMARY_STY_ID STY_ID

Line 838: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate stream type assignment to a stream generation template.');

834: sty.stream_type_purpose = a.STREAM_TYPE_PURPOSE)
835: WHERE rowid = l_rowid_tbl(indx);
836: COMMIT;
837: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
838: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate stream type assignment to a stream generation template.');
839: END IF;
840: END IF;
841:
842: -- ---------------------------------

Line 847: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid contracts.');

843: -- Validate khr_id
844: -- ---------------------------------
845: if l_rowid_tbl.count > 0 then
846: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
847: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid contracts.');
848: END IF;
849: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
850: update okl_ext_billing_interface
851: set trx_status_code = decode(contract_id,NULL,'ERROR',trx_status_code),

Line 856: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid contracts.');

852: error_message = decode(contract_id,NULL,error_message||'Invalid Contract. ',error_message)
853: where rowid = l_rowid_tbl(indx);
854: commit;
855: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
856: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid contracts.');
857: END IF;
858: END IF;
859:
860: -- PAGARG - Bug# 6884934 - Modified Start

Line 870: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid lines.');

866: -- Line Name is not correct for the contract
867: -- ---------------------------------
868: IF l_rowid_tbl.count > 0 THEN
869: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
870: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid lines.');
871: END IF;
872: FORALL indx in l_rowid_tbl.first..l_rowid_tbl.last
873: UPDATE OKL_EXT_BILLING_INTERFACE a
874: SET TRX_STATUS_CODE = 'ERROR',

Line 887: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid lines.');

883: AND ( LNS.NAME IS NULL OR LNS.NAME = NVL(a.ASSET_NUMBER, LNS.NAME))
884: AND LNS.DNZ_CHR_ID = a.CONTRACT_ID);
885: COMMIT;
886: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
887: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid lines.');
888: END IF;
889: END IF;
890: -- PAGARG - Bug# 6884934 - Modified End
891:

Line 897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid stream types.');

893: -- Validate sty_id
894: -- ---------------------------------
895: if l_rowid_tbl.count > 0 then
896: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
897: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid stream types.');
898: END IF;
899: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
900: update okl_ext_billing_interface
901: set trx_status_code = decode(sty_id,NULL,'ERROR',trx_status_code),

Line 908: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid stream types.');

904: error_message)
905: where rowid = l_rowid_tbl(indx);
906: commit;
907: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
908: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid stream types.');
909: END IF;
910: end if;
911:
912: -- ---------------------------------

Line 917: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate invoice date.');

913: -- Validate invoice_date
914: -- ---------------------------------
915: if l_rowid_tbl.count > 0 then
916: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
917: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate invoice date.');
918: END IF;
919: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
920: update okl_ext_billing_interface
921: set trx_status_code = decode(invoice_date,NULL,'ERROR',trx_status_code),

Line 926: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate invoice date.');

922: error_message = decode(invoice_date,NULL,error_message||'Invoice Date is Null. ',error_message)
923: where rowid = l_rowid_tbl(indx);
924: commit;
925: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
926: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate invoice date.');
927: END IF;
928: end if;
929:
930: -- ---------------------------------

Line 935: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate vendor id.');

931: -- update vendor_id
932: -- ---------------------------------
933: if l_rowid_tbl.count > 0 then
934: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
935: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate vendor id.');
936: END IF;
937: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
938: update okl_ext_billing_interface a
939: set TAX_VENDOR_ID = (SELECT VENDOR_ID

Line 947: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate vendor id.');

943: where rowid = l_rowid_tbl(indx)
944: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
945: commit;
946: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
947: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate vendor id.');
948: END IF;
949: end if;
950:
951: -- ---------------------------------

Line 956: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate vendor site id.');

952: -- update vendor_site_id
953: -- ---------------------------------
954: if l_rowid_tbl.count > 0 then
955: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
956: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate vendor site id.');
957: END IF;
958: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
959: update okl_ext_billing_interface a
960: set TAX_VENDOR_SITE_ID = (SELECT VENDOR_SITE_ID

Line 969: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate vendor site id.');

965: where rowid = l_rowid_tbl(indx)
966: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
967: commit;
968: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
969: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate vendor site id.');
970: END IF;
971: end if;
972:
973: -- --------------------------------------

Line 979: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid tax vendor id.');

975: -- for actual property tax
976: -- --------------------------------------
977: if l_rowid_tbl.count > 0 then
978: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
979: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid tax vendor id.');
980: END IF;
981: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
982: update okl_ext_billing_interface a
983: set trx_status_code = decode( TAX_VENDOR_ID,NULL,'ERROR', trx_status_code),

Line 989: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid tax vendor id.');

985: where rowid = l_rowid_tbl(indx)
986: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
987: commit;
988: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
989: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid tax vendor id.');
990: END IF;
991: end if;
992:
993: if l_rowid_tbl.count > 0 then

Line 995: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid tax vendor site id.');

991: end if;
992:
993: if l_rowid_tbl.count > 0 then
994: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
995: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - flag invalid tax vendor site id.');
996: END IF;
997: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
998: update okl_ext_billing_interface a
999: set trx_status_code = decode( TAX_VENDOR_SITE_ID,NULL,'ERROR', trx_status_code),

Line 1006: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid tax vendor site id.');

1002: where rowid = l_rowid_tbl(indx)
1003: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
1004: commit;
1005: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1006: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - flag invalid tax vendor site id.');
1007: END IF;
1008: end if;
1009:
1010: -- --------------------------------------------

Line 1015: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - asset id check for actual property tax.');

1011: -- kle_id is mandatory for Actual Property Tax
1012: -- --------------------------------------------
1013: if l_rowid_tbl.count > 0 then
1014: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1015: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - asset id check for actual property tax.');
1016: END IF;
1017: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
1018: update okl_ext_billing_interface a
1019: set trx_status_code = decode( ASSET_ID,NULL,'ERROR', trx_status_code),

Line 1026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - asset id check for actual property tax.');

1022: where rowid = l_rowid_tbl(indx)
1023: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
1024: commit;
1025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - asset id check for actual property tax.');
1027: END IF;
1028: end if;
1029:
1030: -- --------------------------------------------

Line 1036: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate property tax applicable flag.');

1032: -- for actual property tax
1033: -- --------------------------------------------
1034: if l_rowid_tbl.count > 0 then
1035: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1036: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate property tax applicable flag.');
1037: END IF;
1038: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
1039: update okl_ext_billing_interface a
1040: set prop_tax_applicable_yn = (

Line 1054: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate property tax applicable flag.');

1050: where rowid = l_rowid_tbl(indx)
1051: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
1052: commit;
1053: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1054: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate property tax applicable flag.');
1055: END IF;
1056: end if;
1057:
1058: -- --------------------------------------------

Line 1063: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate property tax applicable flag.');

1059: -- validate prop_tax_applicable_yn
1060: -- --------------------------------------------
1061: if l_rowid_tbl.count > 0 then
1062: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1063: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - validate property tax applicable flag.');
1064: END IF;
1065: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
1066: update okl_ext_billing_interface a
1067: set trx_status_code = decode( prop_tax_applicable_yn,NULL,'ERROR','N','ERROR', trx_status_code),

Line 1077: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate property tax applicable flag.');

1073: where rowid = l_rowid_tbl(indx)
1074: and stream_type_purpose = 'ACTUAL_PROPERTY_TAX';
1075: commit;
1076: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1077: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validate property tax applicable flag.');
1078: END IF;
1079: end if;
1080:
1081: -- -----------------------------------------

Line 1086: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - update successfully validated rows to status of PASSED.');

1082: -- Update non-error rows to PASSED status
1083: -- -----------------------------------------
1084: if l_rowid_tbl.count > 0 then
1085: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1086: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - update successfully validated rows to status of PASSED.');
1087: END IF;
1088: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
1089: update okl_ext_billing_interface
1090: set trx_status_code = decode(trx_status_code,'SUBMITTED', 'PASSED',trx_status_code)

Line 1094: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - update successfully validated rows to status of PASSED.');

1090: set trx_status_code = decode(trx_status_code,'SUBMITTED', 'PASSED',trx_status_code)
1091: where rowid = l_rowid_tbl(indx);
1092: commit;
1093: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1094: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - update successfully validated rows to status of PASSED.');
1095: END IF;
1096: end if; -- Update rows to passed status
1097:
1098: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1099: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validating batch number: '||g_batch_num);

1095: END IF;
1096: end if; -- Update rows to passed status
1097:
1098: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1099: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - validating batch number: '||g_batch_num);
1100: END IF;
1101: EXIT WHEN c_bill_chrgs%NOTFOUND;
1102: END LOOP;
1103: CLOSE c_bill_chrgs;

Line 1112: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - processing billing transactions batch number: '||g_batch_num);

1108: -- -------------------------------------
1109: OPEN bill_txn_csr( l_request_id );
1110: LOOP
1111: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1112: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - processing billing transactions batch number: '||g_batch_num);
1113: END IF;
1114: ext_bill_tbl.delete;
1115: tai_tbl.delete;
1116: til_tbl.delete;

Line 1126: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> number of records: '||ext_bill_tbl.count);

1122: INTO ext_bill_tbl
1123: LIMIT L_FETCH_SIZE;
1124:
1125: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1126: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> number of records: '||ext_bill_tbl.count);
1127: END IF;
1128:
1129: -- -------------------------------------
1130: -- process billing transaction records

Line 1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populating transaction header and line record.');

1130: -- process billing transaction records
1131: -- -------------------------------------
1132: if ext_bill_tbl.count > 0 then
1133: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1134: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populating transaction header and line record.');
1135: END IF;
1136: for indx in ext_bill_tbl.first..ext_bill_tbl.last loop
1137: -- save rowid for later update
1138: upd_rowid_tbl(indx) := ext_bill_tbl(indx).ext_rowid;

Line 1298: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - call to billing centralized API.');

1294: ---------------------------------------------------------------------
1295: l_tilv_tbl(0) := l_tilv_rec;
1296:
1297: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1298: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - call to billing centralized API.');
1299: END IF;
1300:
1301: OKL_INTERNAL_BILLING_PVT.CREATE_BILLING_TRX(
1302: p_api_version

Line 1316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');

1312: ,x_tldv_tbl);
1313:
1314: IF x_return_status <> 'S' THEN
1315: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- ERROR: Creating Billing Transactions using Billing Engine');
1317: END IF;
1318: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

Line 1325: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - call to billing centralized API.');

1321: RAISE Okl_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: END IF;
1324: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1325: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - call to billing centralized API.');
1326: END IF;
1327:
1328: l_tilv_tbl.delete;
1329: l_tldv_tbl.delete;

Line 1333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populating transaction header and line record.');

1329: l_tldv_tbl.delete;
1330: END LOOP; -- process records in ext_bill_tbl
1331:
1332: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populating transaction header and line record.');
1334: END IF;
1335: END IF; -- check if ext_bill_tbl has records
1336: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1337: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - processing billing transactions batch number: '||g_batch_num);

Line 1337: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - processing billing transactions batch number: '||g_batch_num);

1333: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populating transaction header and line record.');
1334: END IF;
1335: END IF; -- check if ext_bill_tbl has records
1336: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1337: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - processing billing transactions batch number: '||g_batch_num);
1338: END IF;
1339: EXIT WHEN bill_txn_csr%NOTFOUND;
1340: END LOOP; -- process transaction records
1341:

Line 1366: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - processing actual property tax records batch number: '||g_batch_num);

1362: g_batch_num := 0;
1363: OPEN act_prop_tax_csr( l_request_id );
1364: LOOP
1365: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1366: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - processing actual property tax records batch number: '||g_batch_num);
1367: END IF;
1368:
1369: ext_bill_tbl.delete;
1370: ptc_tbl.delete;

Line 1380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> number of records: '||ext_bill_tbl.count);

1376: FETCH act_prop_tax_csr BULK COLLECT
1377: INTO ext_bill_tbl
1378: LIMIT L_FETCH_SIZE;
1379: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1380: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'*=> number of records: '||ext_bill_tbl.count);
1381: END IF;
1382: -- -------------------------------------
1383: -- process billing transaction records
1384: -- -------------------------------------

Line 1390: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate property tax parameters record, stm rec and sel rec.');

1386: -- -------------------------------------------
1387: -- loop thru ext_bill_tbl and process records
1388: -- -------------------------------------------
1389: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1390: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'++ begin - populate property tax parameters record, stm rec and sel rec.');
1391: END IF;
1392: FOR indx in ext_bill_tbl.first..ext_bill_tbl.last
1393: LOOP
1394: -- save rowid for later update

Line 1451: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ACTUAL PROPERTY TAX stream.');

1447: IF l_actual_tax_count > 0 THEN -- check for actual property tax stream
1448: NULL;
1449: ELSE -- check for actual property tax stream
1450: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1451: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ACTUAL PROPERTY TAX stream.');
1452: END IF;
1453: -- -------------------------
1454: -- Null out records
1455: -- -------------------------

Line 1496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ACTUAL PROPERTY TAX stream.');

1492: commit;
1493: stm_tbl.delete;
1494: end if;
1495: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1496: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ACTUAL PROPERTY TAX stream.');
1497: END IF;
1498: END IF; -- end check for actual property tax stream
1499:
1500: -- Create stream element actual property tax stream element

Line 1557: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate property tax parameters record, stm rec and sel rec.');

1553: -- end creation of actual property tax stream element
1554: END LOOP; -- end processing ext table records
1555:
1556: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1557: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - populate property tax parameters record, stm rec and sel rec.');
1558: END IF;
1559:
1560: -- insert records into okl_property_tax_b
1561: if ptc_tbl.count > 0 then

Line 1563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_b rec.');

1559:
1560: -- insert records into okl_property_tax_b
1561: if ptc_tbl.count > 0 then
1562: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1563: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_b rec.');
1564: END IF;
1565: forall i in ptc_tbl.first..ptc_tbl.last
1566: insert into okl_property_tax_b
1567: values ptc_tbl(i);

Line 1570: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ptc_b rec.');

1566: insert into okl_property_tax_b
1567: values ptc_tbl(i);
1568: COMMIT;
1569: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1570: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ptc_b rec.');
1571: END IF;
1572: END IF;
1573:
1574: -- insert records into okl_property_tax_tl

Line 1577: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_tl rec.');

1573:
1574: -- insert records into okl_property_tax_tl
1575: if ptctl_tbl.count > 0 then
1576: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1577: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create ptc_tl rec.');
1578: END IF;
1579: FORALL i in ptctl_tbl.first..ptctl_tbl.last
1580: INSERT INTO okl_property_tax_tl
1581: VALUES ptctl_tbl(i);

Line 1584: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ptc_tl rec.');

1580: INSERT INTO okl_property_tax_tl
1581: VALUES ptctl_tbl(i);
1582: COMMIT;
1583: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1584: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create ptc_tl rec.');
1585: END IF;
1586: END IF;
1587:
1588: -- update okl_ext_billing_interface with sel_id

Line 1591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - update ext billing interface with sel_id.');

1587:
1588: -- update okl_ext_billing_interface with sel_id
1589: IF upd_rowid_tbl.count > 0 then
1590: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - update ext billing interface with sel_id.');
1592: END IF;
1593: FORALL i in upd_rowid_tbl.first..upd_rowid_tbl.last
1594: UPDATE okl_ext_billing_interface
1595: SET sel_id = upd_sel_tbl(i)

Line 1599: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - update ext billing interface with sel_id.');

1595: SET sel_id = upd_sel_tbl(i)
1596: WHERE rowid = upd_rowid_tbl(i);
1597: COMMIT;
1598: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1599: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - update ext billing interface with sel_id.');
1600: END IF;
1601: END IF;
1602:
1603: -- insert sel records

Line 1606: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create actual property tax stream elements.');

1602:
1603: -- insert sel records
1604: IF sel_tbl.count > 0 THEN
1605: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1606: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create actual property tax stream elements.');
1607: END IF;
1608: forall i in sel_tbl.first..sel_tbl.last
1609: insert into okl_strm_elements
1610: values sel_tbl(i);

Line 1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create actual property tax stream elements.');

1609: insert into okl_strm_elements
1610: values sel_tbl(i);
1611: COMMIT;
1612: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create actual property tax stream elements.');
1614: END IF;
1615: END IF;
1616:
1617: -- create payable invoices

Line 1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create payable invoice.');

1616:
1617: -- create payable invoices
1618: IF ( l_p_tax_applicable = 'YES' ) THEN
1619: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - create payable invoice.');
1621: END IF;
1622: l_acc_cmt_cnt := 0;
1623: FOR indx in ext_bill_tbl.first..ext_bill_tbl.last
1624: LOOP

Line 1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Creating Payable Invoice to Tax Authority');

1624: LOOP
1625: l_acc_cmt_cnt := l_acc_cmt_cnt + 1;
1626:
1627: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Creating Payable Invoice to Tax Authority');
1629: END IF;
1630: p_man_inv_rec.ipvs_id := ext_bill_tbl(indx).TAX_VENDOR_SITE_ID;
1631: p_man_inv_rec.khr_id := ext_bill_tbl(indx).contract_id;
1632: p_man_inv_rec.vendor_id := ext_bill_tbl(indx).TAX_VENDOR_ID;

Line 1658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- ERROR: Creating Payable Invoice');

1654: -- Create a payable Invoice
1655: -- ---------------------------------------
1656: IF x_return_status <> 'S' THEN
1657: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- ERROR: Creating Payable Invoice');
1659: END IF;
1660: UPDATE OKL_EXT_BILLING_INTERFACE
1661: SET trx_status_code = 'ERROR',
1662: ERROR_MESSAGE = ERROR_MESSAGE||'Error Creating Payable Invoice. '

Line 1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');

1668: delete from OKL_PROPERTY_TAX_tl where id = ptc_tbl(indx).id;
1669: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;
1670: delete from okl_strm_elements where id = upd_sel_tbl(indx);
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');
1673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');
1674: END IF;
1675: END IF;
1676:

Line 1673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');

1669: delete from OKL_PROPERTY_TAX_b where id = ptc_tbl(indx).id;
1670: delete from okl_strm_elements where id = upd_sel_tbl(indx);
1671: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1672: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting records from OKL_PROPERTY_TAX_tl and OKL_PROPERTY_TAX_b.');
1673: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- Deleting record from OKL_STRM_ELEMENTS.');
1674: END IF;
1675: END IF;
1676:
1677: IF l_acc_cmt_cnt > 500 THEN

Line 1684: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create payable invoice.');

1680: END IF;
1681: END LOOP;
1682: COMMIT;
1683: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1684: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - create payable invoice.');
1685: END IF;
1686: END IF;
1687: -- end creation of payable invoices
1688:

Line 1692: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - update status on okl_ext_billing_interface for successful records .');

1688:
1689: -- Update records in the interface to PROCESSED status
1690: if upd_rowid_tbl.count > 0 then
1691: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1692: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' ++ begin - update status on okl_ext_billing_interface for successful records .');
1693: END IF;
1694: forall j in upd_rowid_tbl.first..upd_rowid_tbl.last
1695: update okl_ext_billing_interface
1696: set trx_status_code = decode(trx_status_code,'PASSED','PROCESSED',trx_status_code)

Line 1700: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - update status on okl_ext_billing_interface for successful records .');

1696: set trx_status_code = decode(trx_status_code,'PASSED','PROCESSED',trx_status_code)
1697: where rowid = upd_rowid_tbl(j);
1698: COMMIT;
1699: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1700: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,' -- end - update status on okl_ext_billing_interface for successful records .');
1701: END IF;
1702: END IF;
1703:
1704: -- Start Bug 4520466

Line 1712: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - processing actual property tax records batch number: '||g_batch_num);

1708: -- End Bug 4520466
1709: END IF; -- check if ext_bill_tbl has records
1710:
1711: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1712: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'-- end - processing actual property tax records batch number: '||g_batch_num);
1713: END IF;
1714: EXIT WHEN act_prop_tax_csr%NOTFOUND;
1715: END LOOP; -- process transaction records
1716:

Line 1827: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1823:
1824: ------------------------------------------------------------
1825: -- End processing
1826: ------------------------------------------------------------
1827: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1828: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1829: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End (-)');
1830: END IF;
1831: END IF;

Line 1829: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End (-)');

1825: -- End processing
1826: ------------------------------------------------------------
1827: IF (L_DEBUG_ENABLED='Y' and FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1828: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1829: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'End (-)');
1830: END IF;
1831: END IF;
1832:
1833: Okl_Api.END_ACTIVITY (