[Home] [Help]
1: PACKAGE BODY OKL_ACCOUNT_DIST_PVT AS
2: /* $Header: OKLRTDTB.pls 120.37.12020000.2 2012/12/03 09:46:41 racheruv ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: -- Start of wraper code generated automatically by Debug code generator
8: L_MODULE VARCHAR2(40) := 'LEASE.ACCOUNTING.ENGINE';
9: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
6: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
7: -- Start of wraper code generated automatically by Debug code generator
8: L_MODULE VARCHAR2(40) := 'LEASE.ACCOUNTING.ENGINE';
9: L_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
10: L_LEVEL_PROCEDURE NUMBER;
11: IS_DEBUG_PROCEDURE_ON BOOLEAN;
12: -- End of wraper code generated automatically by Debug code generator
13:
368: WHERE ID = v_prod_id;
369:
370: BEGIN
371: IF (G_DEBUG_ENABLED = 'Y') THEN
372: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
373: END IF;
374:
375: x_return_status := OKL_API.G_RET_STS_SUCCESS;
376:
544:
545: -- Execute the complete select statement
546: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn || l_where_flag_code ;
547: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
550: END IF;
551:
552: execute_tmpl_query(p_stmt => l_stmt_exe,
545: -- Execute the complete select statement
546: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn || l_where_flag_code ;
547: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
548: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
549: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
550: END IF;
551:
552: execute_tmpl_query(p_stmt => l_stmt_exe,
553: x_return_status => l_return_status,
570:
571: IF x_template_tbl.COUNT = 0 THEN
572: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_flag ;
573: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
574: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
575: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
576: END IF;
577:
578: execute_tmpl_query(p_stmt => l_stmt_exe,
571: IF x_template_tbl.COUNT = 0 THEN
572: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_flag ;
573: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
574: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
575: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
576: END IF;
577:
578: execute_tmpl_query(p_stmt => l_stmt_exe,
579: x_return_status => l_return_status,
592: IF x_template_tbl.COUNT = 0 THEN
593: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_no_flag;
594:
595: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
596: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
597: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
598: END IF;
599:
600: execute_tmpl_query(p_stmt => l_stmt_exe,
593: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_no_flag;
594:
595: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
596: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
597: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
598: END IF;
599:
600: execute_tmpl_query(p_stmt => l_stmt_exe,
601: x_return_status => l_return_status,
626:
627: -- Execute the complete select statement
628: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn || l_where_flag_code ;
629: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
631: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
632: END IF;
633:
634: execute_tmpl_query(p_stmt => l_stmt_exe,
627: -- Execute the complete select statement
628: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn || l_where_flag_code ;
629: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
631: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
632: END IF;
633:
634: execute_tmpl_query(p_stmt => l_stmt_exe,
635: x_return_status => l_return_status,
643:
644: IF x_template_tbl.COUNT = 0 THEN
645: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_flag ;
646: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
648: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
649: END IF;
650:
651: execute_tmpl_query(p_stmt => l_stmt_exe,
644: IF x_template_tbl.COUNT = 0 THEN
645: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_flag ;
646: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
647: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
648: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
649: END IF;
650:
651: execute_tmpl_query(p_stmt => l_stmt_exe,
652: x_return_status => l_return_status,
661:
662: IF x_template_tbl.COUNT = 0 THEN
663: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_no_flag;
664: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
665: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
666: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
667: END IF;
668:
669: execute_tmpl_query(p_stmt => l_stmt_exe,
662: IF x_template_tbl.COUNT = 0 THEN
663: l_stmt_exe := l_stmt || l_where ||l_where_memo_yn|| l_where_no_flag;
664: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
665: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The statement executed for fetching the Template Information is :');
666: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_stmt_exe);
667: END IF;
668:
669: execute_tmpl_query(p_stmt => l_stmt_exe,
670: x_return_status => l_return_status,
735:
736: -- Start of wraper code generated automatically by Debug code generator for Okl_Execute_Formula_Pub.EXECUTE
737: IF(L_DEBUG_ENABLED='Y') THEN
738: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
739: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
740: END IF;
741: IF(IS_DEBUG_PROCEDURE_ON) THEN
742: BEGIN
743: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Execute_Formula_Pub.EXECUTE ');
739: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
740: END IF;
741: IF(IS_DEBUG_PROCEDURE_ON) THEN
742: BEGIN
743: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Execute_Formula_Pub.EXECUTE ');
744: END;
745: END IF;
746:
747: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0
756: ,x_value => x_amount);
757:
758: IF(IS_DEBUG_PROCEDURE_ON) THEN
759: BEGIN
760: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Execute_Formula_Pub.EXECUTE ');
761: END;
762: END IF;
763: -- End of wraper code generated automatically by Debug code generator for Okl_Execute_Formula_Pub.EXECUTE
764:
976: l_acc_gen_wf_sources_rec acc_gen_wf_sources_rec;
977:
978: BEGIN
979: IF (G_DEBUG_ENABLED = 'Y') THEN
980: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
981: END IF;
982:
983: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
984: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside the procedure CREATE_DIST_RECS');
980: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
981: END IF;
982:
983: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
984: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside the procedure CREATE_DIST_RECS');
985: END IF;
986:
987: -- get the below details based on the representation .. MG uptake
988: IF nvl(g_representation_type, 'PRIMARY') = 'PRIMARY' THEN
998: l_cc_apply_rounding_diff,
999: l_ael_apply_rounding_diff;
1000: CLOSE sao_csr;
1001: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1002: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1003: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1005: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1006: END IF;
999: l_ael_apply_rounding_diff;
1000: CLOSE sao_csr;
1001: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1002: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1003: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1005: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1006: END IF;
1007:
1000: CLOSE sao_csr;
1001: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1002: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1003: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1005: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1006: END IF;
1007:
1008: -- The following three lines of code to be removed once we start populating rounding CCID in
1001: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1002: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1003: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1004: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1005: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1006: END IF;
1007:
1008: -- The following three lines of code to be removed once we start populating rounding CCID in
1009: -- OKL_SYS_ACCT_OPTS table. Starts Here ****
1146: p_ae_tmpt_line_id => atl_rec.id);
1147:
1148: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1149: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1150: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Error encountered while fetching the CCID using the Account Generator Rules');
1151: END IF;
1152: x_return_status := l_return_status;
1153: RAISE OKL_API.G_EXCEPTION_ERROR;
1154: END IF;
1386:
1387: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1388: IF(IS_DEBUG_PROCEDURE_ON) THEN
1389: BEGIN
1390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1391: END;
1392: END IF;
1393: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
1390: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1391: END;
1392: END IF;
1393: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
1395: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=======================================================================');
1396: END IF;
1397: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1398: LOOP
1391: END;
1392: END IF;
1393: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
1395: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=======================================================================');
1396: END IF;
1397: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1398: LOOP
1399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1396: END IF;
1397: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1398: LOOP
1399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1397: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1398: LOOP
1399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1398: LOOP
1399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1399: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1400: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1401: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1402: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1403: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1404: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1405: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1406: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1410: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1411: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1412: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1420: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SET_OF_BOOKS_ID :'||l_tabv_tbl(i).SET_OF_BOOKS_ID);
1413: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1420: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SET_OF_BOOKS_ID :'||l_tabv_tbl(i).SET_OF_BOOKS_ID);
1421: END IF;
1414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1420: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SET_OF_BOOKS_ID :'||l_tabv_tbl(i).SET_OF_BOOKS_ID);
1421: END IF;
1422: END LOOP;
1415: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1420: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SET_OF_BOOKS_ID :'||l_tabv_tbl(i).SET_OF_BOOKS_ID);
1421: END IF;
1422: END LOOP;
1423:
1416: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1417: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1418: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1420: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SET_OF_BOOKS_ID :'||l_tabv_tbl(i).SET_OF_BOOKS_ID);
1421: END IF;
1422: END LOOP;
1423:
1424: Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(p_api_version => l_api_version
1428: ,x_msg_data => l_msg_data
1429: ,p_tabv_tbl => l_tabv_tbl
1430: ,x_tabv_tbl => l_tabv_tbl_out);
1431: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1433: END IF;
1434: IF(IS_DEBUG_PROCEDURE_ON) THEN
1435: BEGIN
1436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1433: END IF;
1434: IF(IS_DEBUG_PROCEDURE_ON) THEN
1435: BEGIN
1436: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1437: END;
1438: END IF;
1439: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1440:
1511:
1512:
1513: BEGIN
1514: IF (G_DEBUG_ENABLED = 'Y') THEN
1515: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1516: END IF;
1517:
1518: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1519: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside the procedure CREATE_DIST_RECS');
1515: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1516: END IF;
1517:
1518: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1519: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside the procedure CREATE_DIST_RECS');
1520: END IF;
1521:
1522: -- get the details below based on the representation..MG uptake
1523: IF nvl(g_representation_type, 'PRIMARY') = 'PRIMARY' THEN
1533: l_cc_apply_rounding_diff,
1534: l_ael_apply_rounding_diff;
1535: CLOSE sao_csr;
1536: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1537: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1541: END IF;
1534: l_ael_apply_rounding_diff;
1535: CLOSE sao_csr;
1536: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1537: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1541: END IF;
1542:
1535: CLOSE sao_csr;
1536: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1537: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1541: END IF;
1542:
1543: -- The following three lines of code to be removed once we start populating rounding CCID in
1536: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1537: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The values returned by sao_csr are: ');
1538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_rounding_ccid :'||l_rounding_ccid);
1539: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_cc_apply_rounding_diff :'||l_cc_apply_rounding_diff);
1540: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_ael_apply_rounding_diff :'||l_ael_apply_rounding_diff);
1541: END IF;
1542:
1543: -- The following three lines of code to be removed once we start populating rounding CCID in
1544: -- OKL_SYS_ACCT_OPTS table. Starts Here ****
1596:
1597: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1598: IF(IS_DEBUG_PROCEDURE_ON) THEN
1599: BEGIN
1600: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1601: END;
1602: END IF;
1603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
1600: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1601: END;
1602: END IF;
1603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
1605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=======================================================================');
1606: END IF;
1607: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1608: LOOP
1601: END;
1602: END IF;
1603: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1604: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
1605: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'=======================================================================');
1606: END IF;
1607: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1608: LOOP
1609: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1606: END IF;
1607: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1608: LOOP
1609: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1610: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1611: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1607: FOR i in l_tabv_tbl.FIRST..l_tabv_tbl.LAST
1608: LOOP
1609: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1610: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1611: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1608: LOOP
1609: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1610: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1611: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1609: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1610: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1611: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1610: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CR_DR_FLAG :'||l_tabv_tbl(i).CR_DR_FLAG);
1611: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1611: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CODE_COMBINATION_ID :'||l_tabv_tbl(i).CODE_COMBINATION_ID);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1612: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CODE :'||l_tabv_tbl(i).CURRENCY_CODE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1613: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_LINE_TYPE :'||l_tabv_tbl(i).AE_LINE_TYPE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1614: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).TEMPLATE_ID :'||l_tabv_tbl(i).TEMPLATE_ID);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1615: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_ID :'||l_tabv_tbl(i).SOURCE_ID);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1616: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).SOURCE_TABLE :'||l_tabv_tbl(i).SOURCE_TABLE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1617: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_REVERSAL_FLAG :'||l_tabv_tbl(i).GL_REVERSAL_FLAG);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1618: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AMOUNT :'||l_tabv_tbl(i).AMOUNT);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1619: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ACCOUNTED_AMOUNT :'||l_tabv_tbl(i).ACCOUNTED_AMOUNT);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1620: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).GL_DATE :'||l_tabv_tbl(i).GL_DATE);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1621: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).PERCENTAGE :'||l_tabv_tbl(i).PERCENTAGE);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1622: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POSTED_YN :'||l_tabv_tbl(i).POSTED_YN);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).set_of_books_id :'||l_tabv_tbl(i).set_of_books_id);
1623: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_DATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_DATE);
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).set_of_books_id :'||l_tabv_tbl(i).set_of_books_id);
1631: END IF;
1624: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_RATE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_RATE);
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).set_of_books_id :'||l_tabv_tbl(i).set_of_books_id);
1631: END IF;
1632: END LOOP;
1625: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE :'||l_tabv_tbl(i).CURRENCY_CONVERSION_TYPE);
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).set_of_books_id :'||l_tabv_tbl(i).set_of_books_id);
1631: END IF;
1632: END LOOP;
1633:
1626: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).AE_CREATION_ERROR :'||l_tabv_tbl(i).AE_CREATION_ERROR);
1627: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).POST_TO_GL :'||l_tabv_tbl(i).POST_TO_GL);
1628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).ORIGINAL_DIST_ID :'||l_tabv_tbl(i).ORIGINAL_DIST_ID);
1629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).REVERSE_EVENT_FLAG :'||l_tabv_tbl(i).REVERSE_EVENT_FLAG);
1630: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_tabv_tbl(i).set_of_books_id :'||l_tabv_tbl(i).set_of_books_id);
1631: END IF;
1632: END LOOP;
1633:
1634: Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(p_api_version => l_api_version
1638: ,x_msg_data => l_msg_data
1639: ,p_tabv_tbl => l_tabv_tbl
1640: ,x_tabv_tbl => l_tabv_tbl_out);
1641: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1643: END IF;
1644: IF(IS_DEBUG_PROCEDURE_ON) THEN
1645: BEGIN
1646: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1642: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
1643: END IF;
1644: IF(IS_DEBUG_PROCEDURE_ON) THEN
1645: BEGIN
1646: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
1647: END;
1648: END IF;
1649: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS
1650:
1712:
1713: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs
1714: IF(L_DEBUG_ENABLED='Y') THEN
1715: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1716: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1717: END IF;
1718: IF(IS_DEBUG_PROCEDURE_ON) THEN
1719: BEGIN
1720: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1716: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1717: END IF;
1718: IF(IS_DEBUG_PROCEDURE_ON) THEN
1719: BEGIN
1720: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1721: END;
1722: END IF;
1723: Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_api_version,
1724: p_init_msg_list => p_init_msg_list,
1728: p_tabv_tbl => l_tabv_tbl_in,
1729: x_tabv_tbl => l_tabv_tbl_out);
1730: IF(IS_DEBUG_PROCEDURE_ON) THEN
1731: BEGIN
1732: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
1733: END;
1734: END IF;
1735: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs
1736: ELSE
1805:
1806: -- Start of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
1807: IF(L_DEBUG_ENABLED='Y') THEN
1808: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
1809: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1810: END IF;
1811: IF(IS_DEBUG_PROCEDURE_ON) THEN
1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1809: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1810: END IF;
1811: IF(IS_DEBUG_PROCEDURE_ON) THEN
1812: BEGIN
1813: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1814: END;
1815: END IF;
1816: Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
1817: ,p_init_msg_list => l_init_msg_list
1820: ,x_msg_data => l_msg_data
1821: ,p_tabv_tbl => l_dist_tbl);
1822: IF(IS_DEBUG_PROCEDURE_ON) THEN
1823: BEGIN
1824: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
1825: END;
1826: END IF;
1827: -- End of wraper code generated automatically by Debug code generator for Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs
1828:
4004: --Bug 5707866 - End of Changes
4005:
4006: BEGIN
4007: IF (G_DEBUG_ENABLED = 'Y') THEN
4008: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4009: END IF;
4010: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4011:
4012: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
4055:
4056: -- Validate the Parameters
4057:
4058: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4059: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to VALIDATE_PARAMS');
4060: END IF;
4061: VALIDATE_PARAMS(p_dist_info_tbl => l_dist_info_tbl,
4062: p_functional_curr => l_functional_curr,
4063: x_return_status => l_return_status);
4061: VALIDATE_PARAMS(p_dist_info_tbl => l_dist_info_tbl,
4062: p_functional_curr => l_functional_curr,
4063: x_return_status => l_return_status);
4064: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4065: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to VALIDATE_PARAMS, the return status is :'||l_return_status);
4066: END IF;
4067:
4068:
4069:
4075:
4076: --- Change the G_GL_DATE to p_dist_info_rec.accounting_date if we want to pass passed-date as GL Date
4077:
4078: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4079: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Get_Template_Info');
4080: END IF;
4081:
4082: --Bug 5707866 - Start of Changes
4083: OPEN get_acct_derivation_csr;
4119: --Setting l_first_rec to FALSE, so that GET_TEMPLATE_INFO need not be called every time in the loop
4120: l_first_rec := FALSE;
4121:
4122: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4123: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the Get_Template_Info call is :'||l_return_status);
4124: END IF;
4125:
4126: -- Raise an error if template is not found.
4127: IF (l_tmpl_tbl.COUNT = 0) THEN
4270: END IF;
4271: */
4272:
4273: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4274: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to COPY_TEMPLATE_TBL');
4275: END IF;
4276:
4277: COPY_TEMPLATE_TBL(p_temp_rec => tmpl_rec,
4278: x_template_rec => x_template_tbl(j),
4285: RAISE OKL_API.G_EXCEPTION_ERROR;
4286: END IF;
4287:
4288: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4289: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to COPY_TEMPLATE_TBL, the return status is '||l_return_status);
4290: END IF;
4291:
4292: --Building a reference between the dist_info rec and x_template_tbl
4293: x_template_tbl(l_tmp_amt_tbl_count).parent_index_number := i;
4622: --Bug 5707866 - End of Changes
4623:
4624: BEGIN
4625: IF (G_DEBUG_ENABLED = 'Y') THEN
4626: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4627: END IF;
4628: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4629:
4630: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
4654:
4655: -- Validate the Parameters
4656:
4657: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4658: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to VALIDATE_PARAMS');
4659: END IF;
4660: VALIDATE_PARAMS(p_dist_info_tbl => l_dist_info_tbl,
4661: p_functional_curr => l_functional_curr,
4662: x_return_status => l_return_status);
4665: RAISE OKL_API.G_EXCEPTION_ERROR;
4666: END IF;
4667:
4668: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4669: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to VALIDATE_PARAMS, the return status is :'||l_return_status);
4670: END IF;
4671:
4672: -- Get the Templates from the given parameters
4673:
4673:
4674: --- Change the G_GL_DATE to p_dist_info_rec.accounting_date if we want to pass passed-date as GL Date
4675:
4676: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4677: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Get_Template_Info');
4678: END IF;
4679:
4680: --Bug 5707866 - Start of Changes
4681: OPEN get_acct_derivation_csr;
4717: --Setting l_first_rec to FALSE, so that GET_TEMPLATE_INFO need not be called every time in the loop
4718: l_first_rec := FALSE;
4719:
4720: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4721: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the Get_Template_Info call is :'||l_return_status);
4722: END IF;
4723:
4724: -- Raise an error if template is not found.
4725: IF (l_tmpl_tbl.COUNT = 0) THEN
5982:
5983: -- Start of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PUB.REVERSE_ENTRIES
5984: IF(L_DEBUG_ENABLED='Y') THEN
5985: L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
5986: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
5987: END IF;
5988: IF(IS_DEBUG_PROCEDURE_ON) THEN
5989: BEGIN
5990: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call OKL_REVERSAL_PUB.REVERSE_ENTRIES ');
5986: IS_DEBUG_PROCEDURE_ON := OKL_DEBUG_PUB.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
5987: END IF;
5988: IF(IS_DEBUG_PROCEDURE_ON) THEN
5989: BEGIN
5990: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call OKL_REVERSAL_PUB.REVERSE_ENTRIES ');
5991: END;
5992: END IF;
5993: OKL_REVERSAL_PUB.REVERSE_ENTRIES(p_api_version => p_api_version,
5994: p_init_msg_list => p_init_msg_list,
5999: p_source_table => p_source_table,
6000: p_acct_date => p_acct_date);
6001: IF(IS_DEBUG_PROCEDURE_ON) THEN
6002: BEGIN
6003: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call OKL_REVERSAL_PUB.REVERSE_ENTRIES ');
6004: END;
6005: END IF;
6006: -- End of wraper code generated automatically by Debug code generator for OKL_REVERSAL_PUB.REVERSE_ENTRIES
6007: