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.CSI_T_TXN_DETAILS_GRP dependencies on CSI_T_GEN_UTILITY_PVT

Line 44: csi_t_gen_utility_pvt.set_debug_off;

40: dbms_session.set_sql_trace(false);
41: END IF;
42: ****/
43:
44: csi_t_gen_utility_pvt.set_debug_off;
45: return l_found;
46:
47: EXCEPTION
48: WHEN FND_API.G_EXC_ERROR THEN

Line 50: csi_t_gen_utility_pvt.set_debug_off;

46:
47: EXCEPTION
48: WHEN FND_API.G_EXC_ERROR THEN
49:
50: csi_t_gen_utility_pvt.set_debug_off;
51: RETURN false;
52:
53: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
54:

Line 55: csi_t_gen_utility_pvt.set_debug_off;

51: RETURN false;
52:
53: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
54:
55: csi_t_gen_utility_pvt.set_debug_off;
56: RETURN false;
57:
58: WHEN OTHERS THEN
59:

Line 60: csi_t_gen_utility_pvt.set_debug_off;

56: RETURN false;
57:
58: WHEN OTHERS THEN
59:
60: csi_t_gen_utility_pvt.set_debug_off;
61: RETURN false;
62:
63: END check_txn_details_exist;
64:

Line 138: csi_t_gen_utility_pvt.add('API Being Executed : Get Transaction Details');

134:
135: -- Standard Start of API savepoint
136: SAVEPOINT get_transaction_dtls;
137:
138: csi_t_gen_utility_pvt.add('API Being Executed : Get Transaction Details');
139: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 139: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

135: -- Standard Start of API savepoint
136: SAVEPOINT get_transaction_dtls;
137:
138: csi_t_gen_utility_pvt.add('API Being Executed : Get Transaction Details');
139: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
140:
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list ) THEN
143: FND_MSG_PUB.initialize;

Line 182: csi_t_gen_utility_pvt.add ('getting txn line id for session keys');

178: l_txn_line_query_rec := p_txn_line_query_rec ;
179: IF NVL(l_txn_line_query_rec.config_session_hdr_id , fnd_api.g_miss_num)
180: <> fnd_api.g_miss_num
181: THEN
182: csi_t_gen_utility_pvt.add ('getting txn line id for session keys');
183: ---Get the line id associated with the given Config attribs.
184: csi_t_vldn_routines_pvt.get_cz_txn_line_id(
185: p_config_session_hdr_id => p_txn_line_query_rec.config_session_hdr_id,
186: p_config_session_rev_num => p_txn_line_query_rec.config_session_rev_num,

Line 440: csi_t_gen_utility_pvt.add('API Executed : Get Transaction Details');

436: p_count => x_msg_count,
437: p_data => x_msg_data);
438: END IF ; --p_txn_line_query_rec.source_txn_header_id is NOT NULL
439:
440: csi_t_gen_utility_pvt.add('API Executed : Get Transaction Details');
441: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN

Line 441: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

437: p_data => x_msg_data);
438: END IF ; --p_txn_line_query_rec.source_txn_header_id is NOT NULL
439:
440: csi_t_gen_utility_pvt.add('API Executed : Get Transaction Details');
441: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
442:
443: EXCEPTION
444: WHEN FND_API.G_EXC_ERROR THEN
445:

Line 524: csi_t_gen_utility_pvt.add('API Being Executed : Create Transaction Details');

520:
521: -- Standard Start of API savepoint
522: SAVEPOINT create_transaction_dtls;
523:
524: csi_t_gen_utility_pvt.add('API Being Executed : Create Transaction Details');
525: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.To_Boolean( p_init_msg_list ) THEN

Line 525: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

521: -- Standard Start of API savepoint
522: SAVEPOINT create_transaction_dtls;
523:
524: csi_t_gen_utility_pvt.add('API Being Executed : Create Transaction Details');
525: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
526:
527: -- Initialize message list if p_init_msg_list is set to TRUE.
528: IF FND_API.To_Boolean( p_init_msg_list ) THEN
529: FND_MSG_PUB.Initialize;

Line 644: csi_t_gen_utility_pvt.add('API Executed : Create Transaction Details');

640: FND_MSG_PUB.Count_And_Get(
641: p_count => x_msg_count,
642: p_data => x_msg_data);
643:
644: csi_t_gen_utility_pvt.add('API Executed : Create Transaction Details');
645: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
646:
647: csi_t_gen_utility_pvt.set_debug_off;
648:

Line 645: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

641: p_count => x_msg_count,
642: p_data => x_msg_data);
643:
644: csi_t_gen_utility_pvt.add('API Executed : Create Transaction Details');
645: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
646:
647: csi_t_gen_utility_pvt.set_debug_off;
648:
649: EXCEPTION

Line 647: csi_t_gen_utility_pvt.set_debug_off;

643:
644: csi_t_gen_utility_pvt.add('API Executed : Create Transaction Details');
645: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
646:
647: csi_t_gen_utility_pvt.set_debug_off;
648:
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651:

Line 658: csi_t_gen_utility_pvt.dump_error_stack;

654: FND_MSG_PUB.Count_And_Get (
655: p_count => x_msg_count,
656: p_data => x_msg_data);
657:
658: csi_t_gen_utility_pvt.dump_error_stack;
659: csi_t_gen_utility_pvt.set_debug_off;
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662:

Line 659: csi_t_gen_utility_pvt.set_debug_off;

655: p_count => x_msg_count,
656: p_data => x_msg_data);
657:
658: csi_t_gen_utility_pvt.dump_error_stack;
659: csi_t_gen_utility_pvt.set_debug_off;
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662:
663: ROLLBACK TO create_transaction_dtls;

Line 670: csi_t_gen_utility_pvt.dump_error_stack;

666: FND_MSG_PUB.Count_And_Get(
667: p_count => x_msg_count,
668: p_data => x_msg_data);
669:
670: csi_t_gen_utility_pvt.dump_error_stack;
671: csi_t_gen_utility_pvt.set_debug_off;
672:
673: WHEN OTHERS THEN
674:

Line 671: csi_t_gen_utility_pvt.set_debug_off;

667: p_count => x_msg_count,
668: p_data => x_msg_data);
669:
670: csi_t_gen_utility_pvt.dump_error_stack;
671: csi_t_gen_utility_pvt.set_debug_off;
672:
673: WHEN OTHERS THEN
674:
675: ROLLBACK TO create_transaction_dtls;

Line 691: csi_t_gen_utility_pvt.dump_error_stack;

687: FND_MSG_PUB.Count_And_Get(
688: p_count => x_msg_count,
689: p_data => x_msg_data);
690:
691: csi_t_gen_utility_pvt.dump_error_stack;
692: csi_t_gen_utility_pvt.set_debug_off;
693:
694: END create_transaction_dtls;
695:

Line 692: csi_t_gen_utility_pvt.set_debug_off;

688: p_count => x_msg_count,
689: p_data => x_msg_data);
690:
691: csi_t_gen_utility_pvt.dump_error_stack;
692: csi_t_gen_utility_pvt.set_debug_off;
693:
694: END create_transaction_dtls;
695:
696: /*

Line 731: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');

727:
728: -- Standard Start of API savepoint
729: SAVEPOINT update_txn_line_dtls;
730:
731: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
732: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 732: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

728: -- Standard Start of API savepoint
729: SAVEPOINT update_txn_line_dtls;
730:
731: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
732: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean( p_init_msg_list ) THEN
736: FND_MSG_PUB.initialize;

Line 820: csi_t_gen_utility_pvt.dump_error_stack;

816: FND_MSG_PUB.Count_And_Get(
817: p_count => x_msg_count,
818: p_data => x_msg_data);
819:
820: csi_t_gen_utility_pvt.dump_error_stack;
821:
822: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
823: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
824:

Line 822: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');

818: p_data => x_msg_data);
819:
820: csi_t_gen_utility_pvt.dump_error_stack;
821:
822: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
823: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
824:
825: csi_t_gen_utility_pvt.set_debug_off;
826:

Line 823: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

819:
820: csi_t_gen_utility_pvt.dump_error_stack;
821:
822: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
823: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
824:
825: csi_t_gen_utility_pvt.set_debug_off;
826:
827: EXCEPTION

Line 825: csi_t_gen_utility_pvt.set_debug_off;

821:
822: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
823: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
824:
825: csi_t_gen_utility_pvt.set_debug_off;
826:
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829:

Line 836: csi_t_gen_utility_pvt.dump_error_stack;

832: FND_MSG_PUB.Count_And_Get (
833: p_count => x_msg_count,
834: p_data => x_msg_data);
835:
836: csi_t_gen_utility_pvt.dump_error_stack;
837: csi_t_gen_utility_pvt.set_debug_off;
838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840:

Line 837: csi_t_gen_utility_pvt.set_debug_off;

833: p_count => x_msg_count,
834: p_data => x_msg_data);
835:
836: csi_t_gen_utility_pvt.dump_error_stack;
837: csi_t_gen_utility_pvt.set_debug_off;
838:
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840:
841: ROLLBACK TO Update_Txn_Line_Dtls;

Line 848: csi_t_gen_utility_pvt.dump_error_stack;

844: FND_MSG_PUB.Count_And_Get(
845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: csi_t_gen_utility_pvt.dump_error_stack;
849: csi_t_gen_utility_pvt.set_debug_off;
850:
851: WHEN OTHERS THEN
852:

Line 849: csi_t_gen_utility_pvt.set_debug_off;

845: p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: csi_t_gen_utility_pvt.dump_error_stack;
849: csi_t_gen_utility_pvt.set_debug_off;
850:
851: WHEN OTHERS THEN
852:
853: ROLLBACK TO Update_Txn_Line_Dtls;

Line 869: csi_t_gen_utility_pvt.dump_error_stack;

865: FND_MSG_PUB.Count_And_Get(
866: p_count => x_msg_count,
867: p_data => x_msg_data);
868:
869: csi_t_gen_utility_pvt.dump_error_stack;
870: csi_t_gen_utility_pvt.set_debug_off;
871:
872: END update_txn_line_dtls;
873:

Line 870: csi_t_gen_utility_pvt.set_debug_off;

866: p_count => x_msg_count,
867: p_data => x_msg_data);
868:
869: csi_t_gen_utility_pvt.dump_error_stack;
870: csi_t_gen_utility_pvt.set_debug_off;
871:
872: END update_txn_line_dtls;
873:
874: /*

Line 912: csi_t_gen_utility_pvt.add('API Being Executed : Delete Transaction Details');

908: -- Standard Start of API savepoint
909: SAVEPOINT Delete_Transaction_Dtls;
910:
911:
912: csi_t_gen_utility_pvt.add('API Being Executed : Delete Transaction Details');
913: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
914:
915: -- Initialize message list if p_init_msg_list is set to TRUE.
916: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 913: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

909: SAVEPOINT Delete_Transaction_Dtls;
910:
911:
912: csi_t_gen_utility_pvt.add('API Being Executed : Delete Transaction Details');
913: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
914:
915: -- Initialize message list if p_init_msg_list is set to TRUE.
916: IF FND_API.to_Boolean( p_init_msg_list ) THEN
917: FND_MSG_PUB.initialize;

Line 1006: csi_t_gen_utility_pvt.add('API Executed : Delete Transaction Details');

1002: p_count => x_msg_count,
1003: p_data => x_msg_data);
1004:
1005:
1006: csi_t_gen_utility_pvt.add('API Executed : Delete Transaction Details');
1007: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1008:
1009: csi_t_gen_utility_pvt.set_debug_off;
1010:

Line 1007: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1003: p_data => x_msg_data);
1004:
1005:
1006: csi_t_gen_utility_pvt.add('API Executed : Delete Transaction Details');
1007: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1008:
1009: csi_t_gen_utility_pvt.set_debug_off;
1010:
1011: EXCEPTION

Line 1009: csi_t_gen_utility_pvt.set_debug_off;

1005:
1006: csi_t_gen_utility_pvt.add('API Executed : Delete Transaction Details');
1007: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1008:
1009: csi_t_gen_utility_pvt.set_debug_off;
1010:
1011: EXCEPTION
1012: WHEN FND_API.G_EXC_ERROR THEN
1013:

Line 1020: csi_t_gen_utility_pvt.set_debug_off;

1016: FND_MSG_PUB.Count_And_Get (
1017: p_count => x_msg_count,
1018: p_data => x_msg_data);
1019:
1020: csi_t_gen_utility_pvt.set_debug_off;
1021:
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023:
1024: ROLLBACK TO Delete_Transaction_Dtls;

Line 1031: csi_t_gen_utility_pvt.set_debug_off;

1027: FND_MSG_PUB.Count_And_Get(
1028: p_count => x_msg_count,
1029: p_data => x_msg_data);
1030:
1031: csi_t_gen_utility_pvt.set_debug_off;
1032:
1033: WHEN OTHERS THEN
1034:
1035: ROLLBACK TO Delete_Transaction_Dtls;

Line 1051: csi_t_gen_utility_pvt.set_debug_off;

1047: FND_MSG_PUB.Count_And_Get(
1048: p_count => x_msg_count,
1049: p_data => x_msg_data);
1050:
1051: csi_t_gen_utility_pvt.set_debug_off;
1052:
1053: END delete_transaction_dtls;
1054:
1055:

Line 1087: csi_t_gen_utility_pvt.add('API Being Executed : Copy Transaction Details');

1083:
1084: -- Standard Start of API savepoint
1085: SAVEPOINT copy_transaction_dtls;
1086:
1087: csi_t_gen_utility_pvt.add('API Being Executed : Copy Transaction Details');
1088: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1089:
1090: -- Initialize message list if p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1088: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1084: -- Standard Start of API savepoint
1085: SAVEPOINT copy_transaction_dtls;
1086:
1087: csi_t_gen_utility_pvt.add('API Being Executed : Copy Transaction Details');
1088: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1089:
1090: -- Initialize message list if p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1092: FND_MSG_PUB.initialize;

Line 1166: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');

1162: p_count => x_msg_count,
1163: p_data => x_msg_data);
1164:
1165:
1166: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');
1167: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1168:
1169: csi_t_gen_utility_pvt.set_debug_off;
1170:

Line 1167: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1163: p_data => x_msg_data);
1164:
1165:
1166: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');
1167: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1168:
1169: csi_t_gen_utility_pvt.set_debug_off;
1170:
1171: EXCEPTION

Line 1169: csi_t_gen_utility_pvt.set_debug_off;

1165:
1166: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');
1167: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1168:
1169: csi_t_gen_utility_pvt.set_debug_off;
1170:
1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173:

Line 1180: csi_t_gen_utility_pvt.set_debug_off;

1176: FND_MSG_PUB.Count_And_Get (
1177: p_count => x_msg_count,
1178: p_data => x_msg_data);
1179:
1180: csi_t_gen_utility_pvt.set_debug_off;
1181:
1182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1183:
1184: ROLLBACK TO copy_Transaction_Dtls;

Line 1191: csi_t_gen_utility_pvt.set_debug_off;

1187: FND_MSG_PUB.Count_And_Get(
1188: p_count => x_msg_count,
1189: p_data => x_msg_data);
1190:
1191: csi_t_gen_utility_pvt.set_debug_off;
1192:
1193: WHEN OTHERS THEN
1194:
1195: ROLLBACK TO copy_Transaction_Dtls;

Line 1211: csi_t_gen_utility_pvt.set_debug_off;

1207: FND_MSG_PUB.Count_And_Get(
1208: p_count => x_msg_count,
1209: p_data => x_msg_data);
1210:
1211: csi_t_gen_utility_pvt.set_debug_off;
1212:
1213: END copy_transaction_dtls;
1214:
1215:

Line 1250: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');

1246:
1247: -- Standard Start of API savepoint
1248: SAVEPOINT update_transaction_dtls;
1249:
1250: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
1251: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1252:
1253: -- Initialize message list if p_init_msg_list is set to TRUE.
1254: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1251: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1247: -- Standard Start of API savepoint
1248: SAVEPOINT update_transaction_dtls;
1249:
1250: csi_t_gen_utility_pvt.add('API Being Executed : Update Transaction Details');
1251: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1252:
1253: -- Initialize message list if p_init_msg_list is set to TRUE.
1254: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1255: FND_MSG_PUB.initialize;

Line 1274: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;

1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271:
1272: END IF;
1273:
1274: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1275:
1276: csi_t_gen_utility_pvt.dump_api_info(
1277: p_pkg_name => g_pkg_name,
1278: p_api_name => l_api_name);

Line 1276: csi_t_gen_utility_pvt.dump_api_info(

1272: END IF;
1273:
1274: l_debug_level := csi_t_gen_utility_pvt.g_debug_level;
1275:
1276: csi_t_gen_utility_pvt.dump_api_info(
1277: p_pkg_name => g_pkg_name,
1278: p_api_name => l_api_name);
1279:
1280: IF l_debug_level > 1 THEN

Line 1281: csi_t_gen_utility_pvt.dump_txn_line_rec(

1277: p_pkg_name => g_pkg_name,
1278: p_api_name => l_api_name);
1279:
1280: IF l_debug_level > 1 THEN
1281: csi_t_gen_utility_pvt.dump_txn_line_rec(
1282: p_txn_line_rec => p_txn_line_rec);
1283: END IF;
1284:
1285: -- Main API code

Line 1331: csi_t_gen_utility_pvt.dump_error_stack;

1327: FND_MSG_PUB.Count_And_Get(
1328: p_count => x_msg_count,
1329: p_data => x_msg_data);
1330:
1331: csi_t_gen_utility_pvt.dump_error_stack;
1332:
1333: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
1334: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1335:

Line 1333: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');

1329: p_data => x_msg_data);
1330:
1331: csi_t_gen_utility_pvt.dump_error_stack;
1332:
1333: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
1334: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1335:
1336: csi_t_gen_utility_pvt.set_debug_off;
1337:

Line 1334: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1330:
1331: csi_t_gen_utility_pvt.dump_error_stack;
1332:
1333: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
1334: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1335:
1336: csi_t_gen_utility_pvt.set_debug_off;
1337:
1338: EXCEPTION

Line 1336: csi_t_gen_utility_pvt.set_debug_off;

1332:
1333: csi_t_gen_utility_pvt.add('API Executed : Update Transaction Details');
1334: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1335:
1336: csi_t_gen_utility_pvt.set_debug_off;
1337:
1338: EXCEPTION
1339: WHEN FND_API.G_EXC_ERROR THEN
1340:

Line 1347: csi_t_gen_utility_pvt.dump_error_stack;

1343: FND_MSG_PUB.Count_And_Get (
1344: p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:
1347: csi_t_gen_utility_pvt.dump_error_stack;
1348: csi_t_gen_utility_pvt.set_debug_off;
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:

Line 1348: csi_t_gen_utility_pvt.set_debug_off;

1344: p_count => x_msg_count,
1345: p_data => x_msg_data);
1346:
1347: csi_t_gen_utility_pvt.dump_error_stack;
1348: csi_t_gen_utility_pvt.set_debug_off;
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: ROLLBACK TO update_transaction_dtls;

Line 1359: csi_t_gen_utility_pvt.dump_error_stack;

1355: FND_MSG_PUB.Count_And_Get(
1356: p_count => x_msg_count,
1357: p_data => x_msg_data);
1358:
1359: csi_t_gen_utility_pvt.dump_error_stack;
1360: csi_t_gen_utility_pvt.set_debug_off;
1361:
1362: WHEN OTHERS THEN
1363:

Line 1360: csi_t_gen_utility_pvt.set_debug_off;

1356: p_count => x_msg_count,
1357: p_data => x_msg_data);
1358:
1359: csi_t_gen_utility_pvt.dump_error_stack;
1360: csi_t_gen_utility_pvt.set_debug_off;
1361:
1362: WHEN OTHERS THEN
1363:
1364: ROLLBACK TO update_transaction_dtls;

Line 1380: csi_t_gen_utility_pvt.dump_error_stack;

1376: FND_MSG_PUB.Count_And_Get(
1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: csi_t_gen_utility_pvt.dump_error_stack;
1381: csi_t_gen_utility_pvt.set_debug_off;
1382:
1383: END update_transaction_dtls;
1384:

Line 1381: csi_t_gen_utility_pvt.set_debug_off;

1377: p_count => x_msg_count,
1378: p_data => x_msg_data);
1379:
1380: csi_t_gen_utility_pvt.dump_error_stack;
1381: csi_t_gen_utility_pvt.set_debug_off;
1382:
1383: END update_transaction_dtls;
1384:
1385: PROCEDURE split_transaction_details(

Line 1409: csi_t_gen_utility_pvt.add('API Being Executed : Split Transaction Details');

1405: BEGIN
1406: -- Standard Start of API savepoint
1407: SAVEPOINT split_transaction_details;
1408:
1409: csi_t_gen_utility_pvt.add('API Being Executed : Split Transaction Details');
1410: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1411:
1412: -- Initialize message list if p_init_msg_list is set to TRUE.
1413: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1410: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1406: -- Standard Start of API savepoint
1407: SAVEPOINT split_transaction_details;
1408:
1409: csi_t_gen_utility_pvt.add('API Being Executed : Split Transaction Details');
1410: csi_t_gen_utility_pvt.add('Transaction Start Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1411:
1412: -- Initialize message list if p_init_msg_list is set to TRUE.
1413: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1414: FND_MSG_PUB.initialize;

Line 1482: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');

1478: FND_MSG_PUB.Count_And_Get(
1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481:
1482: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');
1483: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1484:
1485: csi_t_gen_utility_pvt.set_debug_off;
1486:

Line 1483: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));

1479: p_count => x_msg_count,
1480: p_data => x_msg_data);
1481:
1482: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');
1483: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1484:
1485: csi_t_gen_utility_pvt.set_debug_off;
1486:
1487: EXCEPTION

Line 1485: csi_t_gen_utility_pvt.set_debug_off;

1481:
1482: csi_t_gen_utility_pvt.add('API Executed : Copy Transaction Details');
1483: csi_t_gen_utility_pvt.add('Transaction End Time :'||to_char(sysdate, 'MM/DD/YY HH24:MI:SS'));
1484:
1485: csi_t_gen_utility_pvt.set_debug_off;
1486:
1487: EXCEPTION
1488: WHEN FND_API.G_EXC_ERROR THEN
1489:

Line 1496: csi_t_gen_utility_pvt.set_debug_off;

1492: FND_MSG_PUB.Count_And_Get (
1493: p_count => x_msg_count,
1494: p_data => x_msg_data);
1495:
1496: csi_t_gen_utility_pvt.set_debug_off;
1497:
1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1499:
1500: ROLLBACK TO split_transaction_details;

Line 1507: csi_t_gen_utility_pvt.set_debug_off;

1503: FND_MSG_PUB.Count_And_Get (
1504: p_count => x_msg_count,
1505: p_data => x_msg_data);
1506:
1507: csi_t_gen_utility_pvt.set_debug_off;
1508:
1509: WHEN OTHERS THEN
1510:
1511: ROLLBACK TO split_transaction_details;

Line 1518: csi_t_gen_utility_pvt.set_debug_off;

1514: FND_MSG_PUB.Count_And_Get (
1515: p_count => x_msg_count,
1516: p_data => x_msg_data);
1517:
1518: csi_t_gen_utility_pvt.set_debug_off;
1519:
1520: END split_transaction_details;
1521:
1522: END csi_t_txn_details_grp;