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 560: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

556:
557: BEGIN
558:
559: IF (G_DEBUG_ENABLED = 'Y') THEN
560: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
561: END IF;
562:
563: x_return_status := OKL_API.START_ACTIVITY(
564: p_api_name => l_api_name,

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

577: End If;
578:
579:
580: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
581: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_srm_automated');
582: END IF;
583:
584: IF NOT (is_srm_automated()) THEN
585: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Secondary representation method is not automated, returning...');

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

581: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_srm_automated');
582: END IF;
583:
584: IF NOT (is_srm_automated()) THEN
585: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Secondary representation method is not automated, returning...');
586: RETURN;
587: END IF;
588:
589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

586: RETURN;
587: END IF;
588:
589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_srm_automated');
591: END IF;
592:
593: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
594: 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 594: 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));

590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_srm_automated');
591: END IF;
592:
593: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
594: 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));
595: END IF;
596:
597: IF NOT (is_mg_enabled(l_pri_trx_tcnv_rec.khr_id)) THEN
598: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Multi gaap is not enabled, returning...');

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

594: 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));
595: END IF;
596:
597: IF NOT (is_mg_enabled(l_pri_trx_tcnv_rec.khr_id)) THEN
598: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Multi gaap is not enabled, returning...');
599: RETURN;
600: END IF;
601:
602: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

599: RETURN;
600: END IF;
601:
602: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
603: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_mg_enabled');
604: END IF;
605:
606:
607: -- null out the primary trx attributes which are not applicable to secondary trx

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

608: l_pri_trx_tcnv_rec := null_out_primary_trx_defaults (l_pri_trx_tcnv_rec);
609:
610:
611: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to set_secondary_trx_attribs');
613: END IF;
614:
615:
616: -- set secondary transaction attributes

Line 626: 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);

622: p_tcnv_rec => l_pri_trx_tcnv_rec,
623: x_tcnv_tbl => l_sec_trx_tcnv_tbl);
624:
625: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
626: 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);
627: END IF;
628:
629: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
630: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

634:
635:
636: -- create the secondary transaction header
637: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
638: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
639: END IF;
640:
641:
642: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => l_api_version,

Line 651: 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);

647: p_tcnv_rec => l_sec_trx_tcnv_tbl(1),
648: x_tcnv_rec => x_sec_trx_tcnv_tbl(1));
649:
650: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
651: 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);
652: END IF;
653:
654: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

657: RAISE OKL_API.G_EXCEPTION_ERROR;
658: END IF;
659:
660: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
661: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to okl_accounting_util.get_valid_gl_date');
662: END IF;
663:
664: -- SGIYER.12/08/08.Get valid GL date for template info and AE
665: l_valid_gl_date := okl_accounting_util.get_valid_gl_date

Line 676: 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));

672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;
674:
675: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
676: 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));
677: END IF;
678:
679: -- FOR m IN 1.. x_sec_trx_tcnv_tbl.COUNT -- this for loop is to handle multiple secondary trxs
680: -- LOOP

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

679: -- FOR m IN 1.. x_sec_trx_tcnv_tbl.COUNT -- this for loop is to handle multiple secondary trxs
680: -- LOOP
681: -- is_formula_based
682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_formula_based');
684: END IF;
685:
686: l_formula_yn := is_formula_based (l_pri_trx_id);
687:

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

685:
686: l_formula_yn := is_formula_based (l_pri_trx_id);
687:
688: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
689: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based');
690: END IF;
691:
692: IF(l_formula_yn) THEN -- get the amount from acc engine and update the secondary trx hdr and lines
693:

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

691:
692: IF(l_formula_yn) THEN -- get the amount from acc engine and update the secondary trx hdr and lines
693:
694: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
695: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based TRUE');
696: END IF;
697:
698: l_tmpl_identify_rec.product_id := x_sec_trx_tcnv_tbl(1).pdt_id;
699: l_tmpl_identify_rec.transaction_type_id := x_sec_trx_tcnv_tbl(1).try_id;

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

700: l_tmpl_identify_rec.memo_yn := 'N';
701: l_tmpl_identify_rec.prior_year_yn := 'N';
702:
703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO');
705: END IF;
706:
707: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
708: p_init_msg_list => p_init_msg_list,

Line 717: 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);

713: x_template_tbl => l_template_tbl,
714: p_validity_date => l_valid_gl_date); -- SGIYER-12/08/08.
715:
716: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
717: 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);
718: END IF;
719: -- Raise an error if template is not found.
720:
721: IF (l_template_tbl.COUNT = 0) THEN

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

730: END IF;
731:
732: -- chekc if the transaction line or contract based
733: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
734: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_line_based');
735: END IF;
736: l_is_line_based := is_line_based(l_pri_trx_id);
737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based');

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

734: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to is_line_based');
735: END IF;
736: l_is_line_based := is_line_based(l_pri_trx_id);
737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based');
739: END IF;
740:
741: IF( l_is_line_based ) THEN -- that is trans type termination, split, evergreen
742:

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

740:
741: IF( l_is_line_based ) THEN -- that is trans type termination, split, evergreen
742:
743: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_line_based TRUE');
745: END IF;
746: -- read all the distinct kle ids of primary trx lines and create kle ids * acc tmpl
747: FOR get_kle_ids_rec IN get_kle_ids_csr( l_pri_trx_id ) LOOP
748:

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

810:
811: END IF;
812:
813: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
814: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');
815: END IF;
816:
817: -- create the secondary transaction lines for each acc tmpl
818: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

Line 834: 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);

830: RAISE OKL_API.G_EXCEPTION_ERROR;
831: END IF;
832:
833: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
834: 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);
835: END IF;
836:
837: -- accounting distributiions
838:

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

873:
874: END LOOP;
875:
876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
878: END IF;
879:
880: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
881: p_api_version => l_api_version,

Line 895: 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);

891: x_amount_tbl => x_amount_out_tbl,
892: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
893:
894: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
895: 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);
896: END IF;
897:
898: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

923: END LOOP; -- For i in
924: End If; -- If l_tclv_tbl.COUNT
925:
926: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
927: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines');
928: END IF;
929: --Update the lines with the amount
930: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
931: (p_api_version => l_api_version,

Line 940: 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);

936: p_tclv_tbl => x_sec_trx_tclv_tbl,
937: x_tclv_tbl => l_sec_trx_tclv_tbl);
938:
939: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
940: 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);
941: END IF;
942:
943: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

950: x_sec_trx_tcnv_tbl(1).tsu_code := 'PROCESSED';
951: x_sec_trx_tcnv_tbl(1).amount := x_sec_trx_tcnv_tbl(1).amount;
952:
953: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
954: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
955: END IF;
956:
957: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
958: p_init_msg_list => p_init_msg_list,

Line 967: 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);

963: x_tcnv_rec => x_sec_trx_tcnv_tbl(1));
964:
965:
966: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
967: 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);
968: END IF;
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1019:
1020: END LOOP;
1021:
1022: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1023: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');
1024: END IF;
1025:
1026: -- create the secondary transaction lines for each acc tmpl
1027: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

Line 1037: 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);

1033: p_tclv_tbl => l_sec_trx_tclv_tbl,
1034: x_tclv_tbl => x_sec_trx_tclv_tbl);
1035:
1036: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1037: 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);
1038: END IF;
1039:
1040: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1091:
1092: END LOOP;
1093:
1094: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1095: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST');
1096: END IF;
1097:
1098: OKL_ACCOUNT_DIST_PVT.CREATE_ACCOUNTING_DIST(
1099: p_api_version => l_api_version,

Line 1113: 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);

1109: x_amount_tbl => x_amount_out_tbl,
1110: p_trx_header_id => x_sec_trx_tcnv_tbl(1).id);
1111:
1112: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1113: 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);
1114: END IF;
1115:
1116: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1117: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: END IF;
1121:
1122: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1123: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
1124: END IF;
1125:
1126: --Update the header with the amount
1127: x_sec_trx_tcnv_tbl(1).tsu_code := 'PROCESSED';

Line 1138: 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);

1134: x_tcnv_rec => x_sec_trx_tcnv_tbl(1));
1135:
1136:
1137: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1138: 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);
1139: END IF;
1140:
1141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1231:
1232: BEGIN
1233:
1234: IF (G_DEBUG_ENABLED = 'Y') THEN
1235: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1236: END IF;
1237:
1238:
1239: l_return_status := OKL_API.START_ACTIVITY(l_api_name

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

1283: l_COUNT := l_COUNT+1;
1284: END LOOP;
1285:
1286: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1287: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Reversal_Pub.REVERSE_ENTRIES');
1288: END IF;
1289:
1290: -- reverse accounting entries
1291: Okl_Reversal_Pub.REVERSE_ENTRIES(

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

1298: p_acct_date => l_tcnv_tbl(i).canceled_date, -- l_reversal_date,
1299: p_source_id_tbl => l_source_id_tbl);
1300:
1301: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1302: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||l_return_status);
1303: 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);
1304: END IF;
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1303: 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);

1299: p_source_id_tbl => l_source_id_tbl);
1300:
1301: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1302: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to Okl_Reversal_Pub.REVERSE_ENTRIES :'||l_return_status);
1303: 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);
1304: END IF;
1305:
1306: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1311:
1312: END LOOP; -- new logic for reversing by tcn_id.
1313:
1314: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1315: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
1316: END IF;
1317: --Call the transaction public api to update tsu_code
1318: Okl_Trx_Contracts_Pub.update_trx_contracts
1319: (p_api_version => p_api_version,

Line 1328: 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);

1324: p_tcnv_tbl => l_tcnv_tbl,
1325: x_tcnv_tbl => x_tcnv_tbl);
1326:
1327: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1328: 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);
1329: END IF;
1330:
1331: -- store the highest degree of error
1332: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN