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.8.12010000.2 2008/08/04 08:38:37 rramasam 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 621: IF (PO_LOG.d_proc) THEN

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

Line 622: PO_LOG.proc_end (d_module);

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

Line 662: IF (PO_LOG.d_proc) THEN

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

Line 663: PO_LOG.proc_begin(d_module);

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

Line 680: IF (PO_LOG.d_proc) THEN

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

Line 681: PO_LOG.proc_end (d_module);

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

Line 757: IF (PO_LOG.d_proc) THEN

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

Line 758: PO_LOG.proc_begin(d_module);

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

Line 774: IF (PO_LOG.d_stmt) THEN

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

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

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

Line 844: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

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

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

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

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

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

Line 875: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 919: IF (PO_LOG.d_proc) THEN

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

Line 920: PO_LOG.proc_end (d_module);

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

Line 992: IF (PO_LOG.d_proc) THEN

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

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

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

Line 1004: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

Line 1218: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1338: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

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

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

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

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

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

Line 1365: IF (PO_LOG.d_proc) THEN

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

Line 1366: PO_LOG.proc_end (d_module);

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

Line 1424: IF (PO_LOG.d_proc) THEN

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

Line 1425: PO_LOG.proc_begin(d_module);

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

Line 1449: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

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

Line 1464: IF (PO_LOG.d_stmt) THEN

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

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

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

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

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

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

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

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

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

Line 1514: IF (PO_LOG.d_stmt) THEN

1510: x_msg_count => l_msg_count,
1511: x_msg_data => l_msg_data
1512: );
1513:
1514: IF (PO_LOG.d_stmt) THEN
1515: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1516: l_return_status);
1517: END IF;
1518:

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

1511: x_msg_data => l_msg_data
1512: );
1513:
1514: IF (PO_LOG.d_stmt) THEN
1515: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1516: l_return_status);
1517: END IF;
1518:
1519: d_position := 50;

Line 1527: IF (PO_LOG.d_stmt) THEN

1523: Error_Handler.GET_MESSAGE_LIST
1524: (
1525: x_message_list => l_message_list
1526: );
1527: IF (PO_LOG.d_stmt) THEN
1528: PO_LOG.stmt(d_module, d_position, 'count of error message',
1529: l_message_list.COUNT);
1530: END IF;
1531:

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

1524: (
1525: x_message_list => l_message_list
1526: );
1527: IF (PO_LOG.d_stmt) THEN
1528: PO_LOG.stmt(d_module, d_position, 'count of error message',
1529: l_message_list.COUNT);
1530: END IF;
1531:
1532: d_position := 60;

Line 1535: IF (PO_LOG.d_stmt) THEN

1531:
1532: d_position := 60;
1533: FOR i IN 1..l_message_list.COUNT
1534: LOOP
1535: IF (PO_LOG.d_stmt) THEN
1536: PO_LOG.stmt(d_module, d_position, 'index', i);
1537: PO_LOG.stmt(d_module, d_position, 'intf header id',
1538: x_items.intf_header_id_tbl(l_index));
1539: PO_LOG.stmt(d_module, d_position, 'intf line id',

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

1532: d_position := 60;
1533: FOR i IN 1..l_message_list.COUNT
1534: LOOP
1535: IF (PO_LOG.d_stmt) THEN
1536: PO_LOG.stmt(d_module, d_position, 'index', i);
1537: PO_LOG.stmt(d_module, d_position, 'intf header id',
1538: x_items.intf_header_id_tbl(l_index));
1539: PO_LOG.stmt(d_module, d_position, 'intf line id',
1540: x_items.intf_line_id_tbl(l_index));

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

1533: FOR i IN 1..l_message_list.COUNT
1534: LOOP
1535: IF (PO_LOG.d_stmt) THEN
1536: PO_LOG.stmt(d_module, d_position, 'index', i);
1537: PO_LOG.stmt(d_module, d_position, 'intf header id',
1538: x_items.intf_header_id_tbl(l_index));
1539: PO_LOG.stmt(d_module, d_position, 'intf line id',
1540: x_items.intf_line_id_tbl(l_index));
1541: PO_LOG.stmt(d_module, d_position, 'message text',

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

1535: IF (PO_LOG.d_stmt) THEN
1536: PO_LOG.stmt(d_module, d_position, 'index', i);
1537: PO_LOG.stmt(d_module, d_position, 'intf header id',
1538: x_items.intf_header_id_tbl(l_index));
1539: PO_LOG.stmt(d_module, d_position, 'intf line id',
1540: x_items.intf_line_id_tbl(l_index));
1541: PO_LOG.stmt(d_module, d_position, 'message text',
1542: l_message_list(i).message_text);
1543: PO_LOG.stmt(d_module, d_position, 'table name',

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

1537: PO_LOG.stmt(d_module, d_position, 'intf header id',
1538: x_items.intf_header_id_tbl(l_index));
1539: PO_LOG.stmt(d_module, d_position, 'intf line id',
1540: x_items.intf_line_id_tbl(l_index));
1541: PO_LOG.stmt(d_module, d_position, 'message text',
1542: l_message_list(i).message_text);
1543: PO_LOG.stmt(d_module, d_position, 'table name',
1544: l_message_list(i).table_name);
1545: END IF;

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

1539: PO_LOG.stmt(d_module, d_position, 'intf line id',
1540: x_items.intf_line_id_tbl(l_index));
1541: PO_LOG.stmt(d_module, d_position, 'message text',
1542: l_message_list(i).message_text);
1543: PO_LOG.stmt(d_module, d_position, 'table name',
1544: l_message_list(i).table_name);
1545: END IF;
1546:
1547: PO_PDOI_ERR_UTL.add_fatal_error

Line 1565: IF (PO_LOG.d_proc) THEN

1561:
1562: l_index := l_update_index_tbl.NEXT(l_index);
1563: END LOOP;
1564:
1565: IF (PO_LOG.d_proc) THEN
1566: PO_LOG.proc_end (d_module);
1567: END IF;
1568:
1569: EXCEPTION

Line 1566: PO_LOG.proc_end (d_module);

1562: l_index := l_update_index_tbl.NEXT(l_index);
1563: END LOOP;
1564:
1565: IF (PO_LOG.d_proc) THEN
1566: PO_LOG.proc_end (d_module);
1567: END IF;
1568:
1569: EXCEPTION
1570: WHEN OTHERS THEN