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_MULTIGAAP_ENGINE_PVT dependencies on FND_LOG

Line 156: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

152: WHERE ID = p_khr_id;
153:
154: BEGIN
155: IF (G_DEBUG_ENABLED = 'Y') THEN
156: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
157: END IF;
158:
159: --get batch id for conc requests from seq
160: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled begin....');

Line 160: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled begin....');

156: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
157: END IF;
158:
159: --get batch id for conc requests from seq
160: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled begin....');
161:
162: OPEN is_mg_enabled;
163: FETCH is_mg_enabled INTO l_is_mg_enabled;
164: CLOSE is_mg_enabled;

Line 166: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_is_mg_enabled'|| NVL(l_is_mg_enabled,'X'));

162: OPEN is_mg_enabled;
163: FETCH is_mg_enabled INTO l_is_mg_enabled;
164: CLOSE is_mg_enabled;
165:
166: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_is_mg_enabled'|| NVL(l_is_mg_enabled,'X'));
167: IF(l_is_mg_enabled = 'Y') THEN
168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'inside if condition');
169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');
170: RETURN true;

Line 168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'inside if condition');

164: CLOSE is_mg_enabled;
165:
166: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_is_mg_enabled'|| NVL(l_is_mg_enabled,'X'));
167: IF(l_is_mg_enabled = 'Y') THEN
168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'inside if condition');
169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');
170: RETURN true;
171: END IF;
172:

Line 169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');

165:
166: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_is_mg_enabled'|| NVL(l_is_mg_enabled,'X'));
167: IF(l_is_mg_enabled = 'Y') THEN
168: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'inside if condition');
169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');
170: RETURN true;
171: END IF;
172:
173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');

Line 173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');

169: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');
170: RETURN true;
171: END IF;
172:
173: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled end');
174:
175: RETURN false;
176:
177: EXCEPTION

Line 179: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled Exception block');

175: RETURN false;
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'is_mg_enabled Exception block');
180: RETURN false;
181: END is_mg_enabled;
182:
183: ---------------------------------------------------------------------------

Line 574: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

570:
571: BEGIN
572:
573: IF (G_DEBUG_ENABLED = 'Y') THEN
574: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
575: END IF;
576:
577: x_return_status := OKL_API.START_ACTIVITY(
578: p_api_name => l_api_name,

Line 595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_srm_automated');

591: End If;
592:
593:
594: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_srm_automated');
596: END IF;
597:
598: IF NOT (is_srm_automated()) THEN
599: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Secondary representation method is not automated, returning...');

Line 599: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Secondary representation method is not automated, returning...');

595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_srm_automated');
596: END IF;
597:
598: IF NOT (is_srm_automated()) THEN
599: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Secondary representation method is not automated, returning...');
600: RETURN;
601: END IF;
602:
603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_srm_automated');

600: RETURN;
601: END IF;
602:
603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_srm_automated');
605: END IF;
606:
607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_mg_enabled:'||to_char(l_pri_trx_tcnv_rec.khr_id));

Line 608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_mg_enabled:'||to_char(l_pri_trx_tcnv_rec.khr_id));

604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_srm_automated');
605: END IF;
606:
607: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_mg_enabled:'||to_char(l_pri_trx_tcnv_rec.khr_id));
609: END IF;
610:
611: IF NOT (is_mg_enabled(l_pri_trx_tcnv_rec.khr_id)) THEN
612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Multi gaap is not enabled, returning...');

Line 612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Multi gaap is not enabled, returning...');

608: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_mg_enabled:'||to_char(l_pri_trx_tcnv_rec.khr_id));
609: END IF;
610:
611: IF NOT (is_mg_enabled(l_pri_trx_tcnv_rec.khr_id)) THEN
612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Multi gaap is not enabled, returning...');
613: RETURN;
614: END IF;
615:
616: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_mg_enabled');

613: RETURN;
614: END IF;
615:
616: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_mg_enabled');
618: END IF;
619:
620:
621: -- null out the primary trx attributes which are not applicable to secondary trx

Line 626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to set_secondary_trx_attribs');

622: l_pri_trx_tcnv_rec := null_out_primary_trx_defaults (l_pri_trx_tcnv_rec);
623:
624:
625: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to set_secondary_trx_attribs');
627: END IF;
628:
629:
630: -- set secondary transaction attributes

Line 640: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to set_secondary_trx_attribs, the return status is :'||x_return_status);

636: p_tcnv_rec => l_pri_trx_tcnv_rec,
637: x_tcnv_tbl => l_sec_trx_tcnv_tbl);
638:
639: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
640: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to set_secondary_trx_attribs, the return status is :'||x_return_status);
641: END IF;
642:
643: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 652: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts');

648:
649:
650: -- create the secondary transaction header
651: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
652: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
653: END IF;
654:
655:
656: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => l_api_version,

Line 665: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts, the return status is :'||x_return_status);

661: p_tcnv_rec => l_sec_trx_tcnv_tbl(1),
662: x_tcnv_rec => x_sec_trx_tcnv_tbl(1));
663:
664: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
665: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts, the return status is :'||x_return_status);
666: END IF;
667:
668: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
669: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to okl_accounting_util.get_valid_gl_date');

671: RAISE OKL_API.G_EXCEPTION_ERROR;
672: END IF;
673:
674: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to okl_accounting_util.get_valid_gl_date');
676: END IF;
677:
678: -- SGIYER.12/08/08.Get valid GL date for template info and AE
679: l_valid_gl_date := okl_accounting_util.get_valid_gl_date

Line 690: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts'||to_char(l_valid_gl_date));

686: RAISE OKL_API.G_EXCEPTION_ERROR;
687: END IF;
688:
689: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
690: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts'||to_char(l_valid_gl_date));
691: END IF;
692:
693: -- FOR m IN 1.. x_sec_trx_tcnv_tbl.COUNT -- this for loop is to handle multiple secondary trxs
694: -- LOOP

Line 697: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_formula_based');

693: -- FOR m IN 1.. x_sec_trx_tcnv_tbl.COUNT -- this for loop is to handle multiple secondary trxs
694: -- LOOP
695: -- is_formula_based
696: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
697: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_formula_based');
698: END IF;
699:
700: l_formula_yn := is_formula_based (l_pri_trx_id);
701:

Line 703: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based');

699:
700: l_formula_yn := is_formula_based (l_pri_trx_id);
701:
702: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
703: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based');
704: END IF;
705:
706: IF(l_formula_yn) THEN -- get the amount from acc engine and update the secondary trx hdr and lines
707:

Line 709: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based TRUE');

705:
706: IF(l_formula_yn) THEN -- get the amount from acc engine and update the secondary trx hdr and lines
707:
708: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
709: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based TRUE');
710: END IF;
711:
712: l_tmpl_identify_rec.product_id := x_sec_trx_tcnv_tbl(1).pdt_id;
713: l_tmpl_identify_rec.transaction_type_id := x_sec_trx_tcnv_tbl(1).try_id;

Line 718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');

714: l_tmpl_identify_rec.memo_yn := 'N';
715: l_tmpl_identify_rec.prior_year_yn := 'N';
716:
717: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
718: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');
719: END IF;
720:
721: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
722: p_init_msg_list => p_init_msg_list,

Line 731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO, the return status is :'||l_return_status);

727: x_template_tbl => l_template_tbl,
728: p_validity_date => l_valid_gl_date); -- SGIYER-12/08/08.
729:
730: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
731: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO, the return status is :'||l_return_status);
732: END IF;
733: -- Raise an error if template is not found.
734:
735: IF (l_template_tbl.COUNT = 0) THEN

Line 748: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_line_based');

744: END IF;
745:
746: -- chekc if the transaction line or contract based
747: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
748: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_line_based');
749: END IF;
750: l_is_line_based := is_line_based(l_pri_trx_id);
751: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based');

Line 752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based');

748: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_line_based');
749: END IF;
750: l_is_line_based := is_line_based(l_pri_trx_id);
751: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based');
753: END IF;
754:
755: IF( l_is_line_based ) THEN -- that is trans type termination, split, evergreen
756:

Line 758: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based TRUE');

754:
755: IF( l_is_line_based ) THEN -- that is trans type termination, split, evergreen
756:
757: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
758: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based TRUE');
759: END IF;
760: -- read all the distinct kle ids of primary trx lines and create kle ids * acc tmpl
761: FOR get_kle_ids_rec IN get_kle_ids_csr( l_pri_trx_id ) LOOP
762:

Line 828: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');

824:
825: END IF;
826:
827: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
828: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');
829: END IF;
830:
831: -- create the secondary transaction lines for each acc tmpl
832: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

Line 848: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'||l_return_status);

844: RAISE OKL_API.G_EXCEPTION_ERROR;
845: END IF;
846:
847: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
848: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines :'||l_return_status);
849: END IF;
850:
851: -- accounting distributiions
852:

Line 891: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');

887:
888: END LOOP;
889:
890: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
891: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
892: END IF;
893:
894: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
895: p_api_version => l_api_version,

Line 909: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);

905: x_amount_tbl => x_amount_out_tbl,
906: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
907:
908: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
909: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
910: END IF;
911:
912: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
913: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines');

937: END LOOP; -- For i in
938: End If; -- If l_tclv_tbl.COUNT
939:
940: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines');
942: END IF;
943: --Update the lines with the amount
944: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
945: (p_api_version => l_api_version,

Line 954: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);

950: p_tclv_tbl => x_sec_trx_tclv_tbl,
951: x_tclv_tbl => l_sec_trx_tclv_tbl);
952:
953: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
954: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);
955: END IF;
956:
957: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 968: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

964: x_sec_trx_tcnv_tbl(1).tsu_code := 'PROCESSED';
965: x_sec_trx_tcnv_tbl(1).amount := x_sec_trx_tcnv_tbl(1).amount;
966:
967: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
968: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
969: END IF;
970:
971: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
972: p_init_msg_list => p_init_msg_list,

Line 981: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);

977: x_tcnv_rec => x_sec_trx_tcnv_tbl(1));
978:
979:
980: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
981: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);
982: END IF;
983:
984: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
985: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');

1041:
1042: END LOOP;
1043:
1044: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');
1046: END IF;
1047:
1048: -- create the secondary transaction lines for each acc tmpl
1049: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

Line 1059: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);

1055: p_tclv_tbl => l_sec_trx_tclv_tbl,
1056: x_tclv_tbl => x_sec_trx_tclv_tbl);
1057:
1058: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1059: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);
1060: END IF;
1061:
1062: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1063: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');

1113:
1114: END LOOP;
1115:
1116: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
1118: END IF;
1119:
1120: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
1121: p_api_version => l_api_version,

Line 1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);

1131: x_amount_tbl => x_amount_out_tbl,
1132: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
1133:
1134: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1135: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST :'||l_return_status);
1136: END IF;
1137:
1138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

1141: RAISE OKL_API.G_EXCEPTION_ERROR;
1142: END IF;
1143:
1144: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1145: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
1146: END IF;
1147:
1148: --Update the header with the amount
1149: x_sec_trx_tcnv_tbl(1).tsu_code := 'PROCESSED';

Line 1160: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);

1156: x_tcnv_rec => x_sec_trx_tcnv_tbl(1));
1157:
1158:
1159: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1160: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);
1161: END IF;
1162:
1163: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1164: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1261: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1257:
1258: BEGIN
1259:
1260: IF (G_DEBUG_ENABLED = 'Y') THEN
1261: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1262: END IF;
1263:
1264:
1265: l_return_status := OKL_API.START_ACTIVITY(l_api_name

Line 1313: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');

1309: l_COUNT := l_COUNT+1;
1310: END LOOP;
1311:
1312: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1313: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
1314: END IF;
1315:
1316: /* bug 14381856: call the reversal api conditionally */
1317: if l_source_id_tbl.count > 0 then

Line 1331: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||l_return_status);

1327: p_source_id_tbl => l_source_id_tbl);
1328: end if;
1329:
1330: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1331: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||l_return_status);
1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES, l_source_table :'||l_source_table);
1333: END IF;
1334:
1335: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES, l_source_table :'||l_source_table);

1328: end if;
1329:
1330: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1331: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||l_return_status);
1332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES, l_source_table :'||l_source_table);
1333: END IF;
1334:
1335: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1336: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1344: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');

1340:
1341: END LOOP; -- new logic for reversing by tcn_id.
1342:
1343: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1344: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
1345: END IF;
1346: --Call the transaction public api to update tsu_code
1347: Okl_Trx_Contracts_Pub.update_trx_contracts
1348: (p_api_version => p_api_version,

Line 1357: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||l_return_status);

1353: p_tcnv_tbl => l_tcnv_tbl,
1354: x_tcnv_tbl => x_tcnv_tbl);
1355:
1356: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1357: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Trx_Contracts_Pub.update_trx_contracts :'||l_return_status);
1358: END IF;
1359:
1360: -- store the highest degree of error
1361: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN