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.PO_PDOI_ITEM_PROCESS_PVT dependencies on PO_LOG

Line 5: PO_LOG.get_package_base('PO_PDOI_ITEM_PROCESS_PVT');

1: PACKAGE BODY PO_PDOI_ITEM_PROCESS_PVT AS
2: /* $Header: PO_PDOI_ITEM_PROCESS_PVT.plb 120.13 2011/03/04 11:33:28 sbontala ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_ITEM_PROCESS_PVT');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------

Line 87: IF (PO_LOG.d_proc) THEN

83: l_proc_row_in_round_tbl DBMS_SQL.NUMBER_TABLE;
84: BEGIN
85: d_position := 0;
86:
87: IF (PO_LOG.d_proc) THEN
88: PO_LOG.proc_begin(d_module);
89: END IF;
90:
91: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ITEM_CREATION);

Line 88: PO_LOG.proc_begin(d_module);

84: BEGIN
85: d_position := 0;
86:
87: IF (PO_LOG.d_proc) THEN
88: PO_LOG.proc_begin(d_module);
89: END IF;
90:
91: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ITEM_CREATION);
92:

Line 124: IF (PO_LOG.d_stmt) THEN

120: LOOP
121: IF (l_items.error_flag_tbl(i) = FND_API.g_TRUE) THEN
122: l_unprocessed_row_tbl.DELETE(i);
123:
124: IF (PO_LOG.d_stmt) THEN
125: PO_LOG.stmt(d_module, d_position, 'record removed due to ' ||
126: 'location derivation error', i);
127: PO_LOG.stmt(d_module, d_position, 'set line record error ' ||
128: 'flag to Y', l_items.line_ref_index_tbl(i));

Line 125: PO_LOG.stmt(d_module, d_position, 'record removed due to ' ||

121: IF (l_items.error_flag_tbl(i) = FND_API.g_TRUE) THEN
122: l_unprocessed_row_tbl.DELETE(i);
123:
124: IF (PO_LOG.d_stmt) THEN
125: PO_LOG.stmt(d_module, d_position, 'record removed due to ' ||
126: 'location derivation error', i);
127: PO_LOG.stmt(d_module, d_position, 'set line record error ' ||
128: 'flag to Y', l_items.line_ref_index_tbl(i));
129: END IF;

Line 127: PO_LOG.stmt(d_module, d_position, 'set line record error ' ||

123:
124: IF (PO_LOG.d_stmt) THEN
125: PO_LOG.stmt(d_module, d_position, 'record removed due to ' ||
126: 'location derivation error', i);
127: PO_LOG.stmt(d_module, d_position, 'set line record error ' ||
128: 'flag to Y', l_items.line_ref_index_tbl(i));
129: END IF;
130:
131: -- set corresponding po_line's error_flag to 'Y'

Line 143: IF (PO_LOG.d_stmt) THEN

139: -- item with same item number will be processed in different
140: -- loop round;
141: LOOP
142: IF (l_unprocessed_row_tbl.COUNT = 0) THEN
143: IF (PO_LOG.d_stmt) THEN
144: PO_LOG.stmt(d_module, d_position, 'all rows processed');
145: END IF;
146:
147: EXIT;

Line 144: PO_LOG.stmt(d_module, d_position, 'all rows processed');

140: -- loop round;
141: LOOP
142: IF (l_unprocessed_row_tbl.COUNT = 0) THEN
143: IF (PO_LOG.d_stmt) THEN
144: PO_LOG.stmt(d_module, d_position, 'all rows processed');
145: END IF;
146:
147: EXIT;
148: END IF;

Line 162: IF (PO_LOG.d_stmt) THEN

158: x_create_in_ship_to_index_tbl => l_create_in_ship_to_index_tbl,
159: x_update_index_tbl => l_update_index_tbl
160: );
161:
162: IF (PO_LOG.d_stmt) THEN
163: l_index := l_create_in_inv_index_tbl.FIRST;
164: WHILE (l_index IS NOT NULL)
165: LOOP
166: PO_LOG.stmt(d_module, d_position, 'l_create_in_inv_index_tbl('||l_index||')',

Line 166: PO_LOG.stmt(d_module, d_position, 'l_create_in_inv_index_tbl('||l_index||')',

162: IF (PO_LOG.d_stmt) THEN
163: l_index := l_create_in_inv_index_tbl.FIRST;
164: WHILE (l_index IS NOT NULL)
165: LOOP
166: PO_LOG.stmt(d_module, d_position, 'l_create_in_inv_index_tbl('||l_index||')',
167: l_create_in_inv_index_tbl(l_index));
168: l_index := l_create_in_inv_index_tbl.NEXT(l_index);
169: END LOOP;
170:

Line 174: PO_LOG.stmt(d_module, d_position, 'l_create_in_master_index_tbl('||l_index||')',

170:
171: l_index := l_create_in_master_index_tbl.FIRST;
172: WHILE (l_index IS NOT NULL)
173: LOOP
174: PO_LOG.stmt(d_module, d_position, 'l_create_in_master_index_tbl('||l_index||')',
175: l_create_in_master_index_tbl(l_index));
176: l_index := l_create_in_master_index_tbl.NEXT(l_index);
177: END LOOP;
178:

Line 182: PO_LOG.stmt(d_module, d_position, 'l_create_in_ship_to_index_tbl('||l_index||')',

178:
179: l_index := l_create_in_ship_to_index_tbl.FIRST;
180: WHILE (l_index IS NOT NULL)
181: LOOP
182: PO_LOG.stmt(d_module, d_position, 'l_create_in_ship_to_index_tbl('||l_index||')',
183: l_create_in_ship_to_index_tbl(l_index));
184: l_index := l_create_in_ship_to_index_tbl.NEXT(l_index);
185: END LOOP;
186:

Line 190: PO_LOG.stmt(d_module, d_position, 'l_update_index_tbl('||l_index||')',

186:
187: l_index := l_update_index_tbl.FIRST;
188: WHILE (l_index IS NOT NULL)
189: LOOP
190: PO_LOG.stmt(d_module, d_position, 'l_update_index_tbl('||l_index||')',
191: l_update_index_tbl(l_index));
192: l_index := l_update_index_tbl.NEXT(l_index);
193: END LOOP;
194: END IF;

Line 250: IF (PO_LOG.d_stmt) THEN

246: -- set item_id and error_flag back to x_lines
247: l_index := l_proc_row_in_round_tbl.FIRST;
248: WHILE (l_index IS NOT NULL)
249: LOOP
250: IF (PO_LOG.d_stmt) THEN
251: PO_LOG.stmt(d_module, d_position, 'from item index',
252: l_index);
253: PO_LOG.stmt(d_module, d_position, 'to line index',
254: l_items.line_ref_index_tbl(l_index));

Line 251: PO_LOG.stmt(d_module, d_position, 'from item index',

247: l_index := l_proc_row_in_round_tbl.FIRST;
248: WHILE (l_index IS NOT NULL)
249: LOOP
250: IF (PO_LOG.d_stmt) THEN
251: PO_LOG.stmt(d_module, d_position, 'from item index',
252: l_index);
253: PO_LOG.stmt(d_module, d_position, 'to line index',
254: l_items.line_ref_index_tbl(l_index));
255: PO_LOG.stmt(d_module, d_position, 'new item id',

Line 253: PO_LOG.stmt(d_module, d_position, 'to line index',

249: LOOP
250: IF (PO_LOG.d_stmt) THEN
251: PO_LOG.stmt(d_module, d_position, 'from item index',
252: l_index);
253: PO_LOG.stmt(d_module, d_position, 'to line index',
254: l_items.line_ref_index_tbl(l_index));
255: PO_LOG.stmt(d_module, d_position, 'new item id',
256: l_items.ln_item_id_tbl(l_index));
257: PO_LOG.stmt(d_module, d_position, 'new error flag',

Line 255: PO_LOG.stmt(d_module, d_position, 'new item id',

251: PO_LOG.stmt(d_module, d_position, 'from item index',
252: l_index);
253: PO_LOG.stmt(d_module, d_position, 'to line index',
254: l_items.line_ref_index_tbl(l_index));
255: PO_LOG.stmt(d_module, d_position, 'new item id',
256: l_items.ln_item_id_tbl(l_index));
257: PO_LOG.stmt(d_module, d_position, 'new error flag',
258: l_items.error_flag_tbl(l_index));
259: END IF;

Line 257: PO_LOG.stmt(d_module, d_position, 'new error flag',

253: PO_LOG.stmt(d_module, d_position, 'to line index',
254: l_items.line_ref_index_tbl(l_index));
255: PO_LOG.stmt(d_module, d_position, 'new item id',
256: l_items.ln_item_id_tbl(l_index));
257: PO_LOG.stmt(d_module, d_position, 'new error flag',
258: l_items.error_flag_tbl(l_index));
259: END IF;
260:
261: x_lines.item_id_tbl(l_items.line_ref_index_tbl(l_index)) :=

Line 279: IF (PO_LOG.d_stmt) THEN

275: WHILE (l_index IS NOT NULL)
276: LOOP
277: IF (x_lines.error_flag_tbl(l_items.line_ref_index_tbl(l_index)) =
278: FND_API.g_TRUE) THEN
279: IF (PO_LOG.d_stmt) THEN
280: PO_LOG.stmt(d_module, d_position, 'reject item on index',
281: l_index);
282: END IF;
283:

Line 280: PO_LOG.stmt(d_module, d_position, 'reject item on index',

276: LOOP
277: IF (x_lines.error_flag_tbl(l_items.line_ref_index_tbl(l_index)) =
278: FND_API.g_TRUE) THEN
279: IF (PO_LOG.d_stmt) THEN
280: PO_LOG.stmt(d_module, d_position, 'reject item on index',
281: l_index);
282: END IF;
283:
284: -- no need to do further processing since line has error

Line 294: IF (PO_LOG.d_proc) THEN

290: END LOOP;
291:
292: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ITEM_CREATION);
293:
294: IF (PO_LOG.d_proc) THEN
295: PO_LOG.proc_end (d_module);
296: END IF;
297:
298: EXCEPTION

Line 295: PO_LOG.proc_end (d_module);

291:
292: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ITEM_CREATION);
293:
294: IF (PO_LOG.d_proc) THEN
295: PO_LOG.proc_end (d_module);
296: END IF;
297:
298: EXCEPTION
299: WHEN OTHERS THEN

Line 346: IF (PO_LOG.d_proc) THEN

342: l_line_index NUMBER;
343: BEGIN
344: d_position := 0;
345:
346: IF (PO_LOG.d_proc) THEN
347: PO_LOG.proc_begin(d_module);
348: END IF;
349:
350: l_key := PO_CORE_S.get_session_gt_nextval;

Line 347: PO_LOG.proc_begin(d_module);

343: BEGIN
344: d_position := 0;
345:
346: IF (PO_LOG.d_proc) THEN
347: PO_LOG.proc_begin(d_module);
348: END IF;
349:
350: l_key := PO_CORE_S.get_session_gt_nextval;
351:

Line 358: IF (PO_LOG.d_stmt) THEN

354: p_size => p_lines.rec_count,
355: x_num_list => l_index_tbl
356: );
357:
358: IF (PO_LOG.d_stmt) THEN
359: PO_LOG.stmt(d_module, d_position, 'error flag', p_lines.error_flag_tbl);
360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',
361: p_lines.need_to_reject_flag_tbl);
362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);

Line 359: PO_LOG.stmt(d_module, d_position, 'error flag', p_lines.error_flag_tbl);

355: x_num_list => l_index_tbl
356: );
357:
358: IF (PO_LOG.d_stmt) THEN
359: PO_LOG.stmt(d_module, d_position, 'error flag', p_lines.error_flag_tbl);
360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',
361: p_lines.need_to_reject_flag_tbl);
362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);
363: PO_LOG.stmt(d_module, d_position, 'item', p_lines.item_tbl);

Line 360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',

356: );
357:
358: IF (PO_LOG.d_stmt) THEN
359: PO_LOG.stmt(d_module, d_position, 'error flag', p_lines.error_flag_tbl);
360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',
361: p_lines.need_to_reject_flag_tbl);
362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);
363: PO_LOG.stmt(d_module, d_position, 'item', p_lines.item_tbl);
364: PO_LOG.stmt(d_module, d_position, 'item id', p_lines.item_id_tbl);

Line 362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);

358: IF (PO_LOG.d_stmt) THEN
359: PO_LOG.stmt(d_module, d_position, 'error flag', p_lines.error_flag_tbl);
360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',
361: p_lines.need_to_reject_flag_tbl);
362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);
363: PO_LOG.stmt(d_module, d_position, 'item', p_lines.item_tbl);
364: PO_LOG.stmt(d_module, d_position, 'item id', p_lines.item_id_tbl);
365: END IF;
366:

Line 363: PO_LOG.stmt(d_module, d_position, 'item', p_lines.item_tbl);

359: PO_LOG.stmt(d_module, d_position, 'error flag', p_lines.error_flag_tbl);
360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',
361: p_lines.need_to_reject_flag_tbl);
362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);
363: PO_LOG.stmt(d_module, d_position, 'item', p_lines.item_tbl);
364: PO_LOG.stmt(d_module, d_position, 'item id', p_lines.item_id_tbl);
365: END IF;
366:
367: -- insert interface_line_ids within the batch in po_session_gt table;

Line 364: PO_LOG.stmt(d_module, d_position, 'item id', p_lines.item_id_tbl);

360: PO_LOG.stmt(d_module, d_position, 'need to reject flag',
361: p_lines.need_to_reject_flag_tbl);
362: PO_LOG.stmt(d_module, d_position, 'purchase basis', p_lines.purchase_basis_tbl);
363: PO_LOG.stmt(d_module, d_position, 'item', p_lines.item_tbl);
364: PO_LOG.stmt(d_module, d_position, 'item id', p_lines.item_id_tbl);
365: END IF;
366:
367: -- insert interface_line_ids within the batch in po_session_gt table;
368: -- Thus it can be used to bulk select location rows

Line 581: IF (PO_LOG.d_stmt) THEN

577: AND gt.num3 = txn_headers.po_header_id(+)
578: AND gt.key = l_key
579: ORDER BY gt.num1, intf_locs.interface_line_location_id;
580:
581: IF (PO_LOG.d_stmt) THEN
582: PO_LOG.stmt(d_module, d_position, 'item count',
583: x_items.rec_count);
584: END IF;
585:

Line 582: PO_LOG.stmt(d_module, d_position, 'item count',

578: AND gt.key = l_key
579: ORDER BY gt.num1, intf_locs.interface_line_location_id;
580:
581: IF (PO_LOG.d_stmt) THEN
582: PO_LOG.stmt(d_module, d_position, 'item count',
583: x_items.rec_count);
584: END IF;
585:
586: d_position := 20;

Line 622: IF (PO_LOG.d_proc) THEN

618: x_items.ln_unit_price_tbl(i) := p_lines.unit_price_tbl(l_line_index);
619: x_items.hd_currency_code_tbl(i) := p_lines.hd_currency_code_tbl(l_line_index);
620: END LOOP;
621:
622: IF (PO_LOG.d_proc) THEN
623: PO_LOG.proc_end (d_module);
624: END IF;
625:
626: EXCEPTION

Line 623: PO_LOG.proc_end (d_module);

619: x_items.hd_currency_code_tbl(i) := p_lines.hd_currency_code_tbl(l_line_index);
620: END LOOP;
621:
622: IF (PO_LOG.d_proc) THEN
623: PO_LOG.proc_end (d_module);
624: END IF;
625:
626: EXCEPTION
627: WHEN OTHERS THEN

Line 663: IF (PO_LOG.d_proc) THEN

659:
660: BEGIN
661: d_position := 0;
662:
663: IF (PO_LOG.d_proc) THEN
664: PO_LOG.proc_begin(d_module);
665: END IF;
666:
667: -- derive attributes from location interface table

Line 664: PO_LOG.proc_begin(d_module);

660: BEGIN
661: d_position := 0;
662:
663: IF (PO_LOG.d_proc) THEN
664: PO_LOG.proc_begin(d_module);
665: END IF;
666:
667: -- derive attributes from location interface table
668: PO_PDOI_LINE_LOC_PROCESS_PVT.derive_line_locs

Line 681: IF (PO_LOG.d_proc) THEN

677: (
678: x_line_locs => x_items
679: );
680:
681: IF (PO_LOG.d_proc) THEN
682: PO_LOG.proc_end (d_module);
683: END IF;
684:
685: EXCEPTION

Line 682: PO_LOG.proc_end (d_module);

678: x_line_locs => x_items
679: );
680:
681: IF (PO_LOG.d_proc) THEN
682: PO_LOG.proc_end (d_module);
683: END IF;
684:
685: EXCEPTION
686: WHEN OTHERS THEN

Line 758: IF (PO_LOG.d_proc) THEN

754:
755: BEGIN
756: d_position := 0;
757:
758: IF (PO_LOG.d_proc) THEN
759: PO_LOG.proc_begin(d_module);
760: END IF;
761:
762: -- allocate memory for nested table

Line 759: PO_LOG.proc_begin(d_module);

755: BEGIN
756: d_position := 0;
757:
758: IF (PO_LOG.d_proc) THEN
759: PO_LOG.proc_begin(d_module);
760: END IF;
761:
762: -- allocate memory for nested table
763: l_exist_in_inv_org_tbl.EXTEND(x_items.rec_count);

Line 775: IF (PO_LOG.d_stmt) THEN

771: l_index := x_unprocessed_row_tbl.FIRST;
772: WHILE (l_index IS NOT NULL)
773: LOOP
774: IF (NOT l_item_ref_tbl.EXISTS(x_items.ln_item_tbl(l_index))) THEN
775: IF (PO_LOG.d_stmt) THEN
776: PO_LOG.stmt(d_module, d_position, 'process row index in current round',
777: l_index);
778: END IF;
779:

Line 776: PO_LOG.stmt(d_module, d_position, 'process row index in current round',

772: WHILE (l_index IS NOT NULL)
773: LOOP
774: IF (NOT l_item_ref_tbl.EXISTS(x_items.ln_item_tbl(l_index))) THEN
775: IF (PO_LOG.d_stmt) THEN
776: PO_LOG.stmt(d_module, d_position, 'process row index in current round',
777: l_index);
778: END IF;
779:
780: -- can be processed in this time of procedure call

Line 845: IF (PO_LOG.d_stmt) THEN

841: FOR i IN 1..l_index_tbl.COUNT
842: LOOP
843: l_index := l_index_tbl(i);
844:
845: IF (PO_LOG.d_stmt) THEN
846: PO_LOG.stmt(d_module, d_position, 'i', i);
847: PO_LOG.stmt(d_module, d_position, 'index', l_index);
848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));
849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));

Line 846: PO_LOG.stmt(d_module, d_position, 'i', i);

842: LOOP
843: l_index := l_index_tbl(i);
844:
845: IF (PO_LOG.d_stmt) THEN
846: PO_LOG.stmt(d_module, d_position, 'i', i);
847: PO_LOG.stmt(d_module, d_position, 'index', l_index);
848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));
849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));
850: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',

Line 847: PO_LOG.stmt(d_module, d_position, 'index', l_index);

843: l_index := l_index_tbl(i);
844:
845: IF (PO_LOG.d_stmt) THEN
846: PO_LOG.stmt(d_module, d_position, 'i', i);
847: PO_LOG.stmt(d_module, d_position, 'index', l_index);
848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));
849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));
850: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',
851: x_items.ship_to_org_id_tbl(l_index));

Line 848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));

844:
845: IF (PO_LOG.d_stmt) THEN
846: PO_LOG.stmt(d_module, d_position, 'i', i);
847: PO_LOG.stmt(d_module, d_position, 'index', l_index);
848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));
849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));
850: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',
851: x_items.ship_to_org_id_tbl(l_index));
852: END IF;

Line 849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));

845: IF (PO_LOG.d_stmt) THEN
846: PO_LOG.stmt(d_module, d_position, 'i', i);
847: PO_LOG.stmt(d_module, d_position, 'index', l_index);
848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));
849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));
850: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',
851: x_items.ship_to_org_id_tbl(l_index));
852: END IF;
853:

Line 850: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',

846: PO_LOG.stmt(d_module, d_position, 'i', i);
847: PO_LOG.stmt(d_module, d_position, 'index', l_index);
848: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl(i)', l_org_id_tbl(i));
849: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl(i)', l_item_id_tbl(i));
850: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id_tbl(l_index)',
851: x_items.ship_to_org_id_tbl(l_index));
852: END IF;
853:
854: IF (l_org_id_tbl(i) = PO_PDOI_PARAMS.g_sys.def_inv_org_id) THEN

Line 876: IF (PO_LOG.d_stmt) THEN

872: -- depend on whether item exists in item master, assign actions
873: l_index := x_proc_row_in_round_tbl.FIRST;
874: WHILE (l_index IS NOT NULL)
875: LOOP
876: IF (PO_LOG.d_stmt) THEN
877: PO_LOG.stmt(d_module, d_position, 'index', l_index);
878: PO_LOG.stmt(d_module, d_position, 'exist_in_inv_org',
879: l_exist_in_inv_org_tbl(l_index));
880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',

Line 877: PO_LOG.stmt(d_module, d_position, 'index', l_index);

873: l_index := x_proc_row_in_round_tbl.FIRST;
874: WHILE (l_index IS NOT NULL)
875: LOOP
876: IF (PO_LOG.d_stmt) THEN
877: PO_LOG.stmt(d_module, d_position, 'index', l_index);
878: PO_LOG.stmt(d_module, d_position, 'exist_in_inv_org',
879: l_exist_in_inv_org_tbl(l_index));
880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',
881: l_exist_in_ship_to_org_tbl(l_index));

Line 878: PO_LOG.stmt(d_module, d_position, 'exist_in_inv_org',

874: WHILE (l_index IS NOT NULL)
875: LOOP
876: IF (PO_LOG.d_stmt) THEN
877: PO_LOG.stmt(d_module, d_position, 'index', l_index);
878: PO_LOG.stmt(d_module, d_position, 'exist_in_inv_org',
879: l_exist_in_inv_org_tbl(l_index));
880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',
881: l_exist_in_ship_to_org_tbl(l_index));
882: PO_LOG.stmt(d_module, d_position, 'exist_in_master_org',

Line 880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',

876: IF (PO_LOG.d_stmt) THEN
877: PO_LOG.stmt(d_module, d_position, 'index', l_index);
878: PO_LOG.stmt(d_module, d_position, 'exist_in_inv_org',
879: l_exist_in_inv_org_tbl(l_index));
880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',
881: l_exist_in_ship_to_org_tbl(l_index));
882: PO_LOG.stmt(d_module, d_position, 'exist_in_master_org',
883: l_exist_in_master_org_tbl(l_index));
884: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id',

Line 882: PO_LOG.stmt(d_module, d_position, 'exist_in_master_org',

878: PO_LOG.stmt(d_module, d_position, 'exist_in_inv_org',
879: l_exist_in_inv_org_tbl(l_index));
880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',
881: l_exist_in_ship_to_org_tbl(l_index));
882: PO_LOG.stmt(d_module, d_position, 'exist_in_master_org',
883: l_exist_in_master_org_tbl(l_index));
884: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id',
885: x_items.ship_to_org_id_tbl(l_index));
886: PO_LOG.stmt(d_module, d_position, 'item_id',

Line 884: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id',

880: PO_LOG.stmt(d_module, d_position, 'exist_in_ship_to_org',
881: l_exist_in_ship_to_org_tbl(l_index));
882: PO_LOG.stmt(d_module, d_position, 'exist_in_master_org',
883: l_exist_in_master_org_tbl(l_index));
884: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id',
885: x_items.ship_to_org_id_tbl(l_index));
886: PO_LOG.stmt(d_module, d_position, 'item_id',
887: x_items.ln_item_id_tbl(l_index));
888: END IF;

Line 886: PO_LOG.stmt(d_module, d_position, 'item_id',

882: PO_LOG.stmt(d_module, d_position, 'exist_in_master_org',
883: l_exist_in_master_org_tbl(l_index));
884: PO_LOG.stmt(d_module, d_position, 'ship_to_org_id',
885: x_items.ship_to_org_id_tbl(l_index));
886: PO_LOG.stmt(d_module, d_position, 'item_id',
887: x_items.ln_item_id_tbl(l_index));
888: END IF;
889:
890: IF (l_exist_in_inv_org_tbl(l_index) = FND_API.g_FALSE OR

Line 920: IF (PO_LOG.d_proc) THEN

916:
917: l_index := x_proc_row_in_round_tbl.NEXT(l_index);
918: END LOOP;
919:
920: IF (PO_LOG.d_proc) THEN
921: PO_LOG.proc_end (d_module);
922: END IF;
923:
924: EXCEPTION

Line 921: PO_LOG.proc_end (d_module);

917: l_index := x_proc_row_in_round_tbl.NEXT(l_index);
918: END LOOP;
919:
920: IF (PO_LOG.d_proc) THEN
921: PO_LOG.proc_end (d_module);
922: END IF;
923:
924: EXCEPTION
925: WHEN OTHERS THEN

Line 993: IF (PO_LOG.d_proc) THEN

989: l_column_name_tbl PO_TBL_VARCHAR100;
990: BEGIN
991: d_position := 0;
992:
993: IF (PO_LOG.d_proc) THEN
994: PO_LOG.proc_begin(d_module, 'p_org_type', p_org_type);
995: END IF;
996:
997: -- insert data in item interface table

Line 994: PO_LOG.proc_begin(d_module, 'p_org_type', p_org_type);

990: BEGIN
991: d_position := 0;
992:
993: IF (PO_LOG.d_proc) THEN
994: PO_LOG.proc_begin(d_module, 'p_org_type', p_org_type);
995: END IF;
996:
997: -- insert data in item interface table
998: l_set_process_id_tbl.EXTEND(x_items.rec_count);

Line 1005: IF (PO_LOG.d_stmt) THEN

1001: LOOP
1002: l_set_process_id_tbl(l_index) :=
1003: PO_PDOI_MAINPROC_UTL_PVT.get_next_set_process_id;
1004:
1005: IF (PO_LOG.d_stmt) THEN
1006: PO_LOG.stmt(d_module, d_position, 'index', l_index);
1007: PO_LOG.stmt(d_module, d_position, 'set process id',
1008: l_set_process_id_tbl(l_index));
1009: END IF;

Line 1006: PO_LOG.stmt(d_module, d_position, 'index', l_index);

1002: l_set_process_id_tbl(l_index) :=
1003: PO_PDOI_MAINPROC_UTL_PVT.get_next_set_process_id;
1004:
1005: IF (PO_LOG.d_stmt) THEN
1006: PO_LOG.stmt(d_module, d_position, 'index', l_index);
1007: PO_LOG.stmt(d_module, d_position, 'set process id',
1008: l_set_process_id_tbl(l_index));
1009: END IF;
1010:

Line 1007: PO_LOG.stmt(d_module, d_position, 'set process id',

1003: PO_PDOI_MAINPROC_UTL_PVT.get_next_set_process_id;
1004:
1005: IF (PO_LOG.d_stmt) THEN
1006: PO_LOG.stmt(d_module, d_position, 'index', l_index);
1007: PO_LOG.stmt(d_module, d_position, 'set process id',
1008: l_set_process_id_tbl(l_index));
1009: END IF;
1010:
1011: l_index := p_index_tbl.NEXT(l_index);

Line 1219: IF (PO_LOG.d_stmt) THEN

1215: l_item_id_tbl,
1216: l_org_id_tbl,
1217: l_revision_tbl;
1218:
1219: IF (PO_LOG.d_stmt) THEN
1220: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1221: l_index_tbl);
1222: PO_LOG.stmt(d_module, d_position, 'l_set_process_id_tbl',
1223: l_set_process_id_tbl);

Line 1220: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',

1216: l_org_id_tbl,
1217: l_revision_tbl;
1218:
1219: IF (PO_LOG.d_stmt) THEN
1220: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1221: l_index_tbl);
1222: PO_LOG.stmt(d_module, d_position, 'l_set_process_id_tbl',
1223: l_set_process_id_tbl);
1224: PO_LOG.stmt(d_module, d_position, 'l_process_flag_tbl',

Line 1222: PO_LOG.stmt(d_module, d_position, 'l_set_process_id_tbl',

1218:
1219: IF (PO_LOG.d_stmt) THEN
1220: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1221: l_index_tbl);
1222: PO_LOG.stmt(d_module, d_position, 'l_set_process_id_tbl',
1223: l_set_process_id_tbl);
1224: PO_LOG.stmt(d_module, d_position, 'l_process_flag_tbl',
1225: l_process_flag_tbl);
1226: PO_LOG.stmt(d_module, d_position, 'l_transaction_id_tbl',

Line 1224: PO_LOG.stmt(d_module, d_position, 'l_process_flag_tbl',

1220: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1221: l_index_tbl);
1222: PO_LOG.stmt(d_module, d_position, 'l_set_process_id_tbl',
1223: l_set_process_id_tbl);
1224: PO_LOG.stmt(d_module, d_position, 'l_process_flag_tbl',
1225: l_process_flag_tbl);
1226: PO_LOG.stmt(d_module, d_position, 'l_transaction_id_tbl',
1227: l_transaction_id_tbl);
1228: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl',

Line 1226: PO_LOG.stmt(d_module, d_position, 'l_transaction_id_tbl',

1222: PO_LOG.stmt(d_module, d_position, 'l_set_process_id_tbl',
1223: l_set_process_id_tbl);
1224: PO_LOG.stmt(d_module, d_position, 'l_process_flag_tbl',
1225: l_process_flag_tbl);
1226: PO_LOG.stmt(d_module, d_position, 'l_transaction_id_tbl',
1227: l_transaction_id_tbl);
1228: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl',
1229: l_item_id_tbl);
1230: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl',

Line 1228: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl',

1224: PO_LOG.stmt(d_module, d_position, 'l_process_flag_tbl',
1225: l_process_flag_tbl);
1226: PO_LOG.stmt(d_module, d_position, 'l_transaction_id_tbl',
1227: l_transaction_id_tbl);
1228: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl',
1229: l_item_id_tbl);
1230: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl',
1231: l_org_id_tbl);
1232: PO_LOG.stmt(d_module, d_position, 'l_revision_tbl',

Line 1230: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl',

1226: PO_LOG.stmt(d_module, d_position, 'l_transaction_id_tbl',
1227: l_transaction_id_tbl);
1228: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl',
1229: l_item_id_tbl);
1230: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl',
1231: l_org_id_tbl);
1232: PO_LOG.stmt(d_module, d_position, 'l_revision_tbl',
1233: l_revision_tbl);
1234: END IF;

Line 1232: PO_LOG.stmt(d_module, d_position, 'l_revision_tbl',

1228: PO_LOG.stmt(d_module, d_position, 'l_item_id_tbl',
1229: l_item_id_tbl);
1230: PO_LOG.stmt(d_module, d_position, 'l_org_id_tbl',
1231: l_org_id_tbl);
1232: PO_LOG.stmt(d_module, d_position, 'l_revision_tbl',
1233: l_revision_tbl);
1234: END IF;
1235:
1236: FOR i IN 1..l_index_tbl.COUNT

Line 1339: IF (PO_LOG.d_stmt) THEN

1335: LOOP
1336: -- get index in x_items
1337: l_index := l_error_index_tbl(i);
1338:
1339: IF (PO_LOG.d_stmt) THEN
1340: PO_LOG.stmt(d_module, d_position, 'add error on index',
1341: l_index);
1342: PO_LOG.stmt(d_module, d_position, 'intf line id',
1343: x_items.intf_line_id_tbl(l_index));

Line 1340: PO_LOG.stmt(d_module, d_position, 'add error on index',

1336: -- get index in x_items
1337: l_index := l_error_index_tbl(i);
1338:
1339: IF (PO_LOG.d_stmt) THEN
1340: PO_LOG.stmt(d_module, d_position, 'add error on index',
1341: l_index);
1342: PO_LOG.stmt(d_module, d_position, 'intf line id',
1343: x_items.intf_line_id_tbl(l_index));
1344: PO_LOG.stmt(d_module, d_position, 'error message',

Line 1342: PO_LOG.stmt(d_module, d_position, 'intf line id',

1338:
1339: IF (PO_LOG.d_stmt) THEN
1340: PO_LOG.stmt(d_module, d_position, 'add error on index',
1341: l_index);
1342: PO_LOG.stmt(d_module, d_position, 'intf line id',
1343: x_items.intf_line_id_tbl(l_index));
1344: PO_LOG.stmt(d_module, d_position, 'error message',
1345: l_message_name_tbl(i));
1346: PO_LOG.stmt(d_module, d_position, 'table name',

Line 1344: PO_LOG.stmt(d_module, d_position, 'error message',

1340: PO_LOG.stmt(d_module, d_position, 'add error on index',
1341: l_index);
1342: PO_LOG.stmt(d_module, d_position, 'intf line id',
1343: x_items.intf_line_id_tbl(l_index));
1344: PO_LOG.stmt(d_module, d_position, 'error message',
1345: l_message_name_tbl(i));
1346: PO_LOG.stmt(d_module, d_position, 'table name',
1347: l_table_name_tbl(i));
1348: PO_LOG.stmt(d_module, d_position, 'column name',

Line 1346: PO_LOG.stmt(d_module, d_position, 'table name',

1342: PO_LOG.stmt(d_module, d_position, 'intf line id',
1343: x_items.intf_line_id_tbl(l_index));
1344: PO_LOG.stmt(d_module, d_position, 'error message',
1345: l_message_name_tbl(i));
1346: PO_LOG.stmt(d_module, d_position, 'table name',
1347: l_table_name_tbl(i));
1348: PO_LOG.stmt(d_module, d_position, 'column name',
1349: l_column_name_tbl(i));
1350: END IF;

Line 1348: PO_LOG.stmt(d_module, d_position, 'column name',

1344: PO_LOG.stmt(d_module, d_position, 'error message',
1345: l_message_name_tbl(i));
1346: PO_LOG.stmt(d_module, d_position, 'table name',
1347: l_table_name_tbl(i));
1348: PO_LOG.stmt(d_module, d_position, 'column name',
1349: l_column_name_tbl(i));
1350: END IF;
1351:
1352: PO_PDOI_ERR_UTL.add_fatal_error

Line 1366: IF (PO_LOG.d_proc) THEN

1362:
1363: x_items.error_flag_tbl(l_index) := FND_API.g_TRUE;
1364: END LOOP;
1365:
1366: IF (PO_LOG.d_proc) THEN
1367: PO_LOG.proc_end (d_module);
1368: END IF;
1369:
1370: EXCEPTION

Line 1367: PO_LOG.proc_end (d_module);

1363: x_items.error_flag_tbl(l_index) := FND_API.g_TRUE;
1364: END LOOP;
1365:
1366: IF (PO_LOG.d_proc) THEN
1367: PO_LOG.proc_end (d_module);
1368: END IF;
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN

Line 1425: IF (PO_LOG.d_proc) THEN

1421: l_message_list Error_Handler.Error_Tbl_Type;
1422: BEGIN
1423: d_position := 0;
1424:
1425: IF (PO_LOG.d_proc) THEN
1426: PO_LOG.proc_begin(d_module);
1427: END IF;
1428:
1429: -- get original description and list price for comparison

Line 1426: PO_LOG.proc_begin(d_module);

1422: BEGIN
1423: d_position := 0;
1424:
1425: IF (PO_LOG.d_proc) THEN
1426: PO_LOG.proc_begin(d_module);
1427: END IF;
1428:
1429: -- get original description and list price for comparison
1430: l_key := PO_CORE_S.get_session_gt_nextval;

Line 1450: IF (PO_LOG.d_stmt) THEN

1446: WHERE key = l_key
1447: RETURNING num1, char1, num2 BULK COLLECT INTO
1448: l_index_tbl, l_orig_desc_tbl, l_orig_list_price_tbl;
1449:
1450: IF (PO_LOG.d_stmt) THEN
1451: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1452: l_index_tbl);
1453: PO_LOG.stmt(d_module, d_position, 'l_orig_desc_tbl',
1454: l_orig_desc_tbl);

Line 1451: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',

1447: RETURNING num1, char1, num2 BULK COLLECT INTO
1448: l_index_tbl, l_orig_desc_tbl, l_orig_list_price_tbl;
1449:
1450: IF (PO_LOG.d_stmt) THEN
1451: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1452: l_index_tbl);
1453: PO_LOG.stmt(d_module, d_position, 'l_orig_desc_tbl',
1454: l_orig_desc_tbl);
1455: PO_LOG.stmt(d_module, d_position, 'l_orig_list_price_tbl',

Line 1453: PO_LOG.stmt(d_module, d_position, 'l_orig_desc_tbl',

1449:
1450: IF (PO_LOG.d_stmt) THEN
1451: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1452: l_index_tbl);
1453: PO_LOG.stmt(d_module, d_position, 'l_orig_desc_tbl',
1454: l_orig_desc_tbl);
1455: PO_LOG.stmt(d_module, d_position, 'l_orig_list_price_tbl',
1456: l_orig_list_price_tbl);
1457: END IF;

Line 1455: PO_LOG.stmt(d_module, d_position, 'l_orig_list_price_tbl',

1451: PO_LOG.stmt(d_module, d_position, 'l_index_tbl',
1452: l_index_tbl);
1453: PO_LOG.stmt(d_module, d_position, 'l_orig_desc_tbl',
1454: l_orig_desc_tbl);
1455: PO_LOG.stmt(d_module, d_position, 'l_orig_list_price_tbl',
1456: l_orig_list_price_tbl);
1457: END IF;
1458:
1459: d_position := 20;

Line 1465: IF (PO_LOG.d_stmt) THEN

1461: FOR i IN 1..l_index_tbl.COUNT
1462: LOOP
1463: l_index := l_index_tbl(i);
1464:
1465: IF (PO_LOG.d_stmt) THEN
1466: PO_LOG.stmt(d_module, d_position, 'i',
1467: i);
1468: PO_LOG.stmt(d_module, d_position, 'l_index',
1469: l_index);

Line 1466: PO_LOG.stmt(d_module, d_position, 'i',

1462: LOOP
1463: l_index := l_index_tbl(i);
1464:
1465: IF (PO_LOG.d_stmt) THEN
1466: PO_LOG.stmt(d_module, d_position, 'i',
1467: i);
1468: PO_LOG.stmt(d_module, d_position, 'l_index',
1469: l_index);
1470: PO_LOG.stmt(d_module, d_position, 'x_items.ln_item_desc_tbl(l_index)',

Line 1468: PO_LOG.stmt(d_module, d_position, 'l_index',

1464:
1465: IF (PO_LOG.d_stmt) THEN
1466: PO_LOG.stmt(d_module, d_position, 'i',
1467: i);
1468: PO_LOG.stmt(d_module, d_position, 'l_index',
1469: l_index);
1470: PO_LOG.stmt(d_module, d_position, 'x_items.ln_item_desc_tbl(l_index)',
1471: x_items.ln_item_desc_tbl(l_index));
1472: PO_LOG.stmt(d_module, d_position, 'x_items.ln_list_price_per_unit_tbl(l_index)',

Line 1470: PO_LOG.stmt(d_module, d_position, 'x_items.ln_item_desc_tbl(l_index)',

1466: PO_LOG.stmt(d_module, d_position, 'i',
1467: i);
1468: PO_LOG.stmt(d_module, d_position, 'l_index',
1469: l_index);
1470: PO_LOG.stmt(d_module, d_position, 'x_items.ln_item_desc_tbl(l_index)',
1471: x_items.ln_item_desc_tbl(l_index));
1472: PO_LOG.stmt(d_module, d_position, 'x_items.ln_list_price_per_unit_tbl(l_index)',
1473: x_items.ln_list_price_per_unit_tbl(l_index));
1474: END IF;

Line 1472: PO_LOG.stmt(d_module, d_position, 'x_items.ln_list_price_per_unit_tbl(l_index)',

1468: PO_LOG.stmt(d_module, d_position, 'l_index',
1469: l_index);
1470: PO_LOG.stmt(d_module, d_position, 'x_items.ln_item_desc_tbl(l_index)',
1471: x_items.ln_item_desc_tbl(l_index));
1472: PO_LOG.stmt(d_module, d_position, 'x_items.ln_list_price_per_unit_tbl(l_index)',
1473: x_items.ln_list_price_per_unit_tbl(l_index));
1474: END IF;
1475:
1476: d_position := 30;

Line 1520: IF (PO_LOG.d_stmt) THEN

1516: x_msg_count => l_msg_count,
1517: x_msg_data => l_msg_data
1518: );
1519:
1520: IF (PO_LOG.d_stmt) THEN
1521: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1522: l_return_status);
1523: END IF;
1524:

Line 1521: PO_LOG.stmt(d_module, d_position, 'return status for item update',

1517: x_msg_data => l_msg_data
1518: );
1519:
1520: IF (PO_LOG.d_stmt) THEN
1521: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1522: l_return_status);
1523: END IF;
1524:
1525: d_position := 50;

Line 1533: IF (PO_LOG.d_stmt) THEN

1529: Error_Handler.GET_MESSAGE_LIST
1530: (
1531: x_message_list => l_message_list
1532: );
1533: IF (PO_LOG.d_stmt) THEN
1534: PO_LOG.stmt(d_module, d_position, 'count of error message',
1535: l_message_list.COUNT);
1536: END IF;
1537:

Line 1534: PO_LOG.stmt(d_module, d_position, 'count of error message',

1530: (
1531: x_message_list => l_message_list
1532: );
1533: IF (PO_LOG.d_stmt) THEN
1534: PO_LOG.stmt(d_module, d_position, 'count of error message',
1535: l_message_list.COUNT);
1536: END IF;
1537:
1538: d_position := 60;

Line 1541: IF (PO_LOG.d_stmt) THEN

1537:
1538: d_position := 60;
1539: FOR i IN 1..l_message_list.COUNT
1540: LOOP
1541: IF (PO_LOG.d_stmt) THEN
1542: PO_LOG.stmt(d_module, d_position, 'index', i);
1543: PO_LOG.stmt(d_module, d_position, 'intf header id',
1544: x_items.intf_header_id_tbl(l_index));
1545: PO_LOG.stmt(d_module, d_position, 'intf line id',

Line 1542: PO_LOG.stmt(d_module, d_position, 'index', i);

1538: d_position := 60;
1539: FOR i IN 1..l_message_list.COUNT
1540: LOOP
1541: IF (PO_LOG.d_stmt) THEN
1542: PO_LOG.stmt(d_module, d_position, 'index', i);
1543: PO_LOG.stmt(d_module, d_position, 'intf header id',
1544: x_items.intf_header_id_tbl(l_index));
1545: PO_LOG.stmt(d_module, d_position, 'intf line id',
1546: x_items.intf_line_id_tbl(l_index));

Line 1543: PO_LOG.stmt(d_module, d_position, 'intf header id',

1539: FOR i IN 1..l_message_list.COUNT
1540: LOOP
1541: IF (PO_LOG.d_stmt) THEN
1542: PO_LOG.stmt(d_module, d_position, 'index', i);
1543: PO_LOG.stmt(d_module, d_position, 'intf header id',
1544: x_items.intf_header_id_tbl(l_index));
1545: PO_LOG.stmt(d_module, d_position, 'intf line id',
1546: x_items.intf_line_id_tbl(l_index));
1547: PO_LOG.stmt(d_module, d_position, 'message text',

Line 1545: PO_LOG.stmt(d_module, d_position, 'intf line id',

1541: IF (PO_LOG.d_stmt) THEN
1542: PO_LOG.stmt(d_module, d_position, 'index', i);
1543: PO_LOG.stmt(d_module, d_position, 'intf header id',
1544: x_items.intf_header_id_tbl(l_index));
1545: PO_LOG.stmt(d_module, d_position, 'intf line id',
1546: x_items.intf_line_id_tbl(l_index));
1547: PO_LOG.stmt(d_module, d_position, 'message text',
1548: l_message_list(i).message_text);
1549: PO_LOG.stmt(d_module, d_position, 'table name',

Line 1547: PO_LOG.stmt(d_module, d_position, 'message text',

1543: PO_LOG.stmt(d_module, d_position, 'intf header id',
1544: x_items.intf_header_id_tbl(l_index));
1545: PO_LOG.stmt(d_module, d_position, 'intf line id',
1546: x_items.intf_line_id_tbl(l_index));
1547: PO_LOG.stmt(d_module, d_position, 'message text',
1548: l_message_list(i).message_text);
1549: PO_LOG.stmt(d_module, d_position, 'table name',
1550: l_message_list(i).table_name);
1551: END IF;

Line 1549: PO_LOG.stmt(d_module, d_position, 'table name',

1545: PO_LOG.stmt(d_module, d_position, 'intf line id',
1546: x_items.intf_line_id_tbl(l_index));
1547: PO_LOG.stmt(d_module, d_position, 'message text',
1548: l_message_list(i).message_text);
1549: PO_LOG.stmt(d_module, d_position, 'table name',
1550: l_message_list(i).table_name);
1551: END IF;
1552:
1553: PO_PDOI_ERR_UTL.add_fatal_error

Line 1571: IF (PO_LOG.d_proc) THEN

1567:
1568: l_index := l_update_index_tbl.NEXT(l_index);
1569: END LOOP;
1570:
1571: IF (PO_LOG.d_proc) THEN
1572: PO_LOG.proc_end (d_module);
1573: END IF;
1574:
1575: EXCEPTION

Line 1572: PO_LOG.proc_end (d_module);

1568: l_index := l_update_index_tbl.NEXT(l_index);
1569: END LOOP;
1570:
1571: IF (PO_LOG.d_proc) THEN
1572: PO_LOG.proc_end (d_module);
1573: END IF;
1574:
1575: EXCEPTION
1576: WHEN OTHERS THEN