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.IGI_DOS_FUNDS dependencies on GL_BC_PACKETS

Line 15: TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;

11: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED ;
12:
13: /* =================== DEBUG_LOG_UNEXP_ERROR =================== */
14: --bug 9128478
15: TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;
16: PROCEDURE Packet_Error(p_packet_count IN NUMBER,
17: p_packet_data_tab IN packet_data_type);
18: Procedure Debug_log_unexp_error (P_module IN VARCHAR2,
19: P_error_type IN VARCHAR2)

Line 78: l_session_id gl_bc_packets.session_id%type;

74: PRAGMA AUTONOMOUS_TRANSACTION;
75:
76: --l_trx_id NUMBER;
77:
78: l_session_id gl_bc_packets.session_id%type;
79: l_serial_id gl_bc_packets.serial_id%type;
80: l_application_id gl_bc_packets.application_id%type;
81:
82:

Line 79: l_serial_id gl_bc_packets.serial_id%type;

75:
76: --l_trx_id NUMBER;
77:
78: l_session_id gl_bc_packets.session_id%type;
79: l_serial_id gl_bc_packets.serial_id%type;
80: l_application_id gl_bc_packets.application_id%type;
81:
82:
83: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

Line 80: l_application_id gl_bc_packets.application_id%type;

76: --l_trx_id NUMBER;
77:
78: l_session_id gl_bc_packets.session_id%type;
79: l_serial_id gl_bc_packets.serial_id%type;
80: l_application_id gl_bc_packets.application_id%type;
81:
82:
83: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)
84: IS

Line 107: INSERT INTO gl_bc_packets (status_code,

103:
104:
105: -- Bug 3627318
106: -- reversing the encumbrance for source.
107: INSERT INTO gl_bc_packets (status_code,
108: packet_id,
109: ledger_id, je_source_name,
110: je_category_name,
111: code_combination_id,

Line 159: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

155: l_session_id,l_serial_id,101);
156:
157: -- =============== START DEBUG LOG ================
158: Debug_log_string (l_proc_level, 'Approve.Msg27',
159: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
160: -- =============== END DEBUG LOG ==================
161:
162: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
163: INSERT INTO gl_bc_packets

Line 163: INSERT INTO gl_bc_packets

159: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
160: -- =============== END DEBUG LOG ==================
161:
162: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
163: INSERT INTO gl_bc_packets
164: (status_code,
165: packet_id,
166: -- Set_of_books_id, /* Commented for bug 6126275 */
167: ledger_id, /* Added for bug 6126275 */

Line 218: ' INSERTING INTO gl_bc_packets for budget');

214: -- =============== START DEBUG LOG ================
215: Debug_log_string (l_proc_level, 'Approve.Msg30',
216: ' INSERTED --> ' || SQL%ROWCOUNT);
217: Debug_log_string (l_proc_level, 'Approve.Msg31',
218: ' INSERTING INTO gl_bc_packets for budget');
219: Debug_log_string (l_proc_level, 'Approve.Msg32',
220: ' CREDIT SOURCE AMOUNT --> ' || P_source_amount);
221: -- =============== END DEBUG LOG ==================
222:

Line 232: ' INSERTING INTO gl_bc_packets for budget');

228: -- =============== START DEBUG LOG ================
229: Debug_log_string (l_proc_level, 'Approve.Msg34',
230: ' In to dest_rec loop ');
231: Debug_log_string (l_proc_level, 'Approve.Msg35',
232: ' INSERTING INTO gl_bc_packets for budget');
233: Debug_log_string (l_proc_level, 'Approve.Msg36',
234: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
235: -- =============== END DEBUG LOG ==================
236:

Line 237: INSERT INTO gl_bc_packets

233: Debug_log_string (l_proc_level, 'Approve.Msg36',
234: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
235: -- =============== END DEBUG LOG ==================
236:
237: INSERT INTO gl_bc_packets
238: (status_code,
239: packet_id,
240: ledger_id, /* Added for bug 6126275 */
241: je_source_name,

Line 319: l_session_id gl_bc_packets.session_id%type;

315: P_source_trx_id number ) AS
316:
317: PRAGMA AUTONOMOUS_TRANSACTION;
318:
319: l_session_id gl_bc_packets.session_id%type;
320: l_serial_id gl_bc_packets.serial_id%type;
321: l_application_id gl_bc_packets.application_id%type;
322:
323:

Line 320: l_serial_id gl_bc_packets.serial_id%type;

316:
317: PRAGMA AUTONOMOUS_TRANSACTION;
318:
319: l_session_id gl_bc_packets.session_id%type;
320: l_serial_id gl_bc_packets.serial_id%type;
321: l_application_id gl_bc_packets.application_id%type;
322:
323:
324: BEGIN

Line 321: l_application_id gl_bc_packets.application_id%type;

317: PRAGMA AUTONOMOUS_TRANSACTION;
318:
319: l_session_id gl_bc_packets.session_id%type;
320: l_serial_id gl_bc_packets.serial_id%type;
321: l_application_id gl_bc_packets.application_id%type;
322:
323:
324: BEGIN
325:

Line 339: INSERT INTO gl_bc_packets (status_code,

335:
336:
337: -- Bug 3627318
338: -- reversing the encumbrance for source.
339: INSERT INTO gl_bc_packets (status_code,
340: packet_id,
341: ledger_id,
342: je_source_name,
343: je_category_name,

Line 389: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

385: l_session_id,l_serial_id,101);
386:
387: -- =============== START DEBUG LOG ================
388: Debug_log_string (l_proc_level, 'Reject.Msg31',
389: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
390: -- =============== END DEBUG LOG ==================
391:
392: COMMIT;
393:

Line 433: -- TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;

429: temp VARCHAR2(30);
430: l_sob_id VARCHAR2(30);
431: -- Bug 9128478 : Added
432: l_packet_count NUMBER;
433: -- TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;
434: l_packet_data_tab packet_data_type;
435:
436:
437: CURSOR get_trx_id

Line 610: SELECT gl_bc_packets_s.nextval

606: Debug_log_string (l_proc_level, 'Approve.Msg25',
607: ' l_packet_id --> ' || l_packet_id);
608: -- =============== END DEBUG LOG ==================
609:
610: SELECT gl_bc_packets_s.nextval
611: INTO v_packet_id
612: FROM dual;
613:
614: -- Bug 9128478 : Storing the generated packet details

Line 633: ' INSERTING INTO gl_bc_packets for source enc ');

629: WHERE dest.source_trx_id = packet_rec.source_trx_id;
630:
631: -- =============== START DEBUG LOG ================
632: Debug_log_string (l_proc_level, 'Approve.Msg35',
633: ' INSERTING INTO gl_bc_packets for source enc ');
634: Debug_log_string (l_proc_level, 'Approve.Msg36',
635: ' CREDIT SOURCE AMOUNT --> ' || v_source_amount );
636: -- =============== END DEBUG LOG ==================
637: /* Commented for bug 6126275 */

Line 640: /* INSERT INTO gl_bc_packets (status_code,

636: -- =============== END DEBUG LOG ==================
637: /* Commented for bug 6126275 */
638: -- Bug 3627318
639: -- reversing the encumbrance for source.
640: /* INSERT INTO gl_bc_packets (status_code,
641: packet_id,
642: -- Set_of_books_id, -- Commented for bug 6126275
643: ledger_id, -- Added for bug 6126275
644: je_source_name,

Line 692: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

688: v_encumbrance_type_id);
689:
690: -- =============== START DEBUG LOG ================
691: Debug_log_string (l_proc_level, 'Approve.Msg27',
692: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
693: -- =============== END DEBUG LOG ==================
694:
695: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
696: INSERT INTO gl_bc_packets

Line 696: INSERT INTO gl_bc_packets

692: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
693: -- =============== END DEBUG LOG ==================
694:
695: -- Bug 1635678 sekhar kappaga budget jounral for the source key ---
696: INSERT INTO gl_bc_packets
697: (status_code,
698: packet_id,
699: -- Set_of_books_id, -- Commented for bug 6126275
700: ledger_id, -- Added for bug 6126275

Line 749: ' INSERTING INTO gl_bc_packets for budget');

745: -- =============== START DEBUG LOG ================
746: Debug_log_string (l_proc_level, 'Approve.Msg30',
747: ' INSERTED --> ' || SQL%ROWCOUNT);
748: Debug_log_string (l_proc_level, 'Approve.Msg31',
749: ' INSERTING INTO gl_bc_packets for budget');
750: Debug_log_string (l_proc_level, 'Approve.Msg32',
751: ' CREDIT SOURCE AMOUNT --> ' || v_source_amount);
752: -- =============== END DEBUG LOG ==================
753:

Line 763: ' INSERTING INTO gl_bc_packets for budget');

759: -- =============== START DEBUG LOG ================
760: Debug_log_string (l_proc_level, 'Approve.Msg34',
761: ' In to dest_rec loop ');
762: Debug_log_string (l_proc_level, 'Approve.Msg35',
763: ' INSERTING INTO gl_bc_packets for budget');
764: Debug_log_string (l_proc_level, 'Approve.Msg36',
765: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
766: -- =============== END DEBUG LOG ==================
767:

Line 768: INSERT INTO gl_bc_packets

764: Debug_log_string (l_proc_level, 'Approve.Msg36',
765: ' DEBIT DEST AMOUNT --> ' || dest_rec.budget_amount);
766: -- =============== END DEBUG LOG ==================
767:
768: INSERT INTO gl_bc_packets
769: (status_code,
770: packet_id,
771: -- Set_of_books_id, -- Commented for bug 6126275
772: ledger_id, -- Added for bug 6126275

Line 983: -- TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;

979: v_encumbrance_type_id NUMBER;
980: l_currency_code VARCHAR2(15);
981: -- Bug 9128478 : Added
982: l_packet_count NUMBER;
983: -- TYPE packet_data_type IS TABLE OF GL_BC_PACKETS.PACKET_ID%TYPE;
984: l_packet_data_tab packet_data_type;
985:
986: -- Bug 1635678 sekhar kappaga
987: CURSOR get_dest (p_source_trx_id igi_dos_trx_dest.source_trx_id%TYPE)

Line 1148: SELECT gl_bc_packets_s.nextval

1144: Debug_log_string (l_proc_level, 'Reject.Msg26',
1145: ' l_packet_id --> '|| l_packet_id);
1146: -- =============== END DEBUG LOG ==================
1147:
1148: SELECT gl_bc_packets_s.nextval
1149: INTO v_packet_id
1150: FROM dual;
1151:
1152: -- =============== START DEBUG LOG ================

Line 1172: ' INSERTING INTO gl_bc_packets ');

1168: -- =============== START DEBUG LOG ================
1169: Debug_log_string (l_proc_level, 'Reject.Msg28',
1170: ' v_source_amount --> ' || v_source_amount);
1171: Debug_log_string (l_proc_level, 'Reject.Msg29',
1172: ' INSERTING INTO gl_bc_packets ');
1173: Debug_log_string (l_proc_level, 'Reject.Msg30',
1174: ' CREDIT SOURCE AMOUNT --> ' || v_source_amount);
1175: -- =============== END DEBUG LOG ==================
1176: /* Commented for bug 6126275 */

Line 1180: INSERT INTO gl_bc_packets (status_code,

1176: /* Commented for bug 6126275 */
1177: /*
1178: -- Bug 3627318
1179: -- reversing the encumbrance for source.
1180: INSERT INTO gl_bc_packets (status_code,
1181: packet_id,
1182: -- Set_of_books_id, -- Commented for bug 6126275
1183: ledger_id, --Added for bug 6126275
1184: je_source_name,

Line 1232: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);

1228: v_encumbrance_type_id);
1229:
1230: -- =============== START DEBUG LOG ================
1231: Debug_log_string (l_proc_level, 'Reject.Msg31',
1232: ' INSERT INTO gl_bc_packets --> ' || SQL%ROWCOUNT);
1233: -- =============== END DEBUG LOG ================== */
1234:
1235: /* bug 6126275 start */
1236: reject_insert_row ( v_packet_id,

Line 1364: UPDATE gl_bc_packets

1360: Debug_log_string (l_proc_level, 'Packet.Msg1',
1361: 'Entering the Packet_Error procedure');
1362: -- =============== END DEBUG LOG ==================
1363: FOR cnt IN 1..p_packet_count-1 LOOP
1364: UPDATE gl_bc_packets
1365: SET status_code = 'T'
1366: WHERE packet_id = p_packet_data_tab(cnt);
1367: UPDATE gl_bc_packet_arrival_order ao
1368: SET ao.affect_funds_flag = 'N'

Line 1371: UPDATE gl_bc_packets

1367: UPDATE gl_bc_packet_arrival_order ao
1368: SET ao.affect_funds_flag = 'N'
1369: WHERE ao.packet_id = p_packet_data_tab(cnt);
1370: END LOOP;
1371: UPDATE gl_bc_packets
1372: SET status_code = 'T'
1373: WHERE packet_id = p_packet_data_tab(p_packet_count)
1374: AND status_code IN('P','A');
1375: UPDATE gl_bc_packet_arrival_order ao