DBA Data[Home] [Help]

APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_TRX_CONTRACTS_PUB

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

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

Line 656: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => l_api_version,

652: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_contracts');
653: END IF;
654:
655:
656: OKL_TRX_CONTRACTS_PUB.create_trx_contracts(p_api_version => l_api_version,
657: p_init_msg_list => p_init_msg_list,
658: x_return_status => x_return_status,
659: x_msg_count => x_msg_count,
660: x_msg_data => x_msg_data,

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

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

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

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

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

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

Line 832: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

828: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');
829: END IF;
830:
831: -- create the secondary transaction lines for each acc tmpl
832: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines
833: (p_api_version => l_api_version,
834: p_init_msg_list => p_init_msg_list,
835: x_return_status => l_return_status,
836: x_msg_count => x_msg_count,

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

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

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

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

Line 944: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines

940: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
941: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines');
942: END IF;
943: --Update the lines with the amount
944: OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
945: (p_api_version => l_api_version,
946: p_init_msg_list => p_init_msg_list,
947: x_return_status => x_return_status,
948: x_msg_count => x_msg_count,

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

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

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

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

Line 971: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

967: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
968: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');
969: END IF;
970:
971: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
972: p_init_msg_list => p_init_msg_list,
973: x_return_status => x_return_status,
974: x_msg_count => x_msg_count,
975: x_msg_data => x_msg_data,

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

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

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

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

Line 1049: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines

1045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines');
1046: END IF;
1047:
1048: -- create the secondary transaction lines for each acc tmpl
1049: OKL_TRX_CONTRACTS_PUB.create_trx_cntrct_lines
1050: (p_api_version => l_api_version,
1051: p_init_msg_list => p_init_msg_list,
1052: x_return_status => x_return_status,
1053: x_msg_count => x_msg_count,

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

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

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

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

Line 1150: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,

1146: END IF;
1147:
1148: --Update the header with the amount
1149: x_sec_trx_tcnv_tbl(1).tsu_code := 'PROCESSED';
1150: OKL_TRX_CONTRACTS_PUB.update_trx_contracts(p_api_version => l_api_version,
1151: p_init_msg_list => p_init_msg_list,
1152: x_return_status => x_return_status,
1153: x_msg_count => x_msg_count,
1154: x_msg_data => x_msg_data,

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

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

Line 1226: l_pri_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type := P_TCNV_REC;

1222: l_sysdate DATE := SYSDATE;
1223: l_reversal_date DATE;
1224: l_COUNT NUMBER :=0;
1225: /* record and table structure variables */
1226: l_pri_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type := P_TCNV_REC;
1227: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1228: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1229: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1230: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

Line 1227: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;

1223: l_reversal_date DATE;
1224: l_COUNT NUMBER :=0;
1225: /* record and table structure variables */
1226: l_pri_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type := P_TCNV_REC;
1227: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1228: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1229: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1230: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1231: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;

Line 1228: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;

1224: l_COUNT NUMBER :=0;
1225: /* record and table structure variables */
1226: l_pri_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type := P_TCNV_REC;
1227: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1228: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1229: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1230: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1231: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;
1232: --

Line 1229: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

1225: /* record and table structure variables */
1226: l_pri_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type := P_TCNV_REC;
1227: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1228: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1229: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1230: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1231: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;
1232: --
1233: TYPE t_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;

Line 1230: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;

1226: l_pri_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type := P_TCNV_REC;
1227: l_tcnv_rec OKL_TRX_CONTRACTS_PUB.tcnv_rec_type;
1228: x_tclv_tbl OKL_TRX_CONTRACTS_PUB.tclv_tbl_type;
1229: l_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1230: x_tcnv_tbl OKL_TRX_CONTRACTS_PUB.tcnv_tbl_type;
1231: l_source_id_tbl OKL_REVERSAL_PUB.source_id_tbl_type;
1232: --
1233: TYPE t_date IS TABLE OF DATE INDEX BY BINARY_INTEGER;
1234: l_trx_date_tbl t_date;

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

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

Line 1347: Okl_Trx_Contracts_Pub.update_trx_contracts

1343: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1344: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');
1345: END IF;
1346: --Call the transaction public api to update tsu_code
1347: Okl_Trx_Contracts_Pub.update_trx_contracts
1348: (p_api_version => p_api_version,
1349: p_init_msg_list => p_init_msg_list,
1350: x_return_status => l_return_status,
1351: x_msg_count => x_msg_count,

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

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