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_MOVE_TO_DRAFT_TABS_PVT dependencies on PO_LOG

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

1: PACKAGE BODY po_pdoi_move_to_draft_tabs_pvt AS
2: /* $Header: PO_PDOI_MOVE_TO_DRAFT_TABS_PVT.plb 120.52.12020000.3 2013/02/10 18:32:40 vegajula ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_MOVE_TO_DRAFT_TABS_PVT');
6:
7: --------------------------------------------------------------------------
8: ---------------------- PRIVATE PROCEDURES PROTOTYPE ----------------------
9: --------------------------------------------------------------------------

Line 95: IF (PO_LOG.d_proc) THEN

91:
92: BEGIN
93: d_position := 0;
94:
95: IF (PO_LOG.d_proc) THEN
96: PO_LOG.proc_begin(d_module);
97: END IF;
98:
99: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);

Line 96: PO_LOG.proc_begin(d_module);

92: BEGIN
93: d_position := 0;
94:
95: IF (PO_LOG.d_proc) THEN
96: PO_LOG.proc_begin(d_module);
97: END IF;
98:
99: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
100:

Line 126: IF (PO_LOG.d_proc) THEN

122: );
123:
124: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_end (d_module);
128: END IF;
129:
130: EXCEPTION

Line 127: PO_LOG.proc_end (d_module);

123:
124: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_INSERT);
125:
126: IF (PO_LOG.d_proc) THEN
127: PO_LOG.proc_end (d_module);
128: END IF;
129:
130: EXCEPTION
131: WHEN OTHERS THEN

Line 168: IF (PO_LOG.d_proc) THEN

164:
165: BEGIN
166: d_position := 0;
167:
168: IF (PO_LOG.d_proc) THEN
169: PO_LOG.proc_begin(d_module);
170: END IF;
171:
172: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);

Line 169: PO_LOG.proc_begin(d_module);

165: BEGIN
166: d_position := 0;
167:
168: IF (PO_LOG.d_proc) THEN
169: PO_LOG.proc_begin(d_module);
170: END IF;
171:
172: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);
173:

Line 196: IF (PO_LOG.d_stmt) THEN

192: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED)
193: ) THEN
194: d_position := 20;
195:
196: IF (PO_LOG.d_stmt) THEN
197: PO_LOG.stmt(d_module, d_position, 'set lines to be notified');
198: END IF;
199:
200: -- update interface table with new status set to NOTIFIED

Line 197: PO_LOG.stmt(d_module, d_position, 'set lines to be notified');

193: ) THEN
194: d_position := 20;
195:
196: IF (PO_LOG.d_stmt) THEN
197: PO_LOG.stmt(d_module, d_position, 'set lines to be notified');
198: END IF;
199:
200: -- update interface table with new status set to NOTIFIED
201: -- bug 6743283 added a condition to check the action, so that only for update

Line 236: IF (PO_LOG.d_stmt) THEN

232: -- Insert all lines to draft lines regardless of whether the lines are in
233: -- status 'NOTIFIED' or not... those lines will be removed from the draft
234: -- table during post processing.
235:
236: IF (PO_LOG.d_stmt) THEN
237: PO_LOG.stmt(d_module, d_position, 'insert lines into draft table');
238: END IF;
239:
240: -- insert lines into po_lines_draft_all

Line 237: PO_LOG.stmt(d_module, d_position, 'insert lines into draft table');

233: -- status 'NOTIFIED' or not... those lines will be removed from the draft
234: -- table during post processing.
235:
236: IF (PO_LOG.d_stmt) THEN
237: PO_LOG.stmt(d_module, d_position, 'insert lines into draft table');
238: END IF;
239:
240: -- insert lines into po_lines_draft_all
241: insert_po_lines_draft_all

Line 248: IF (PO_LOG.d_proc) THEN

244: );
245:
246: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);
247:
248: IF (PO_LOG.d_proc) THEN
249: PO_LOG.proc_end (d_module);
250: END IF;
251:
252: EXCEPTION

Line 249: PO_LOG.proc_end (d_module);

245:
246: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_INSERT);
247:
248: IF (PO_LOG.d_proc) THEN
249: PO_LOG.proc_end (d_module);
250: END IF;
251:
252: EXCEPTION
253: WHEN OTHERS THEN

Line 382: IF (PO_LOG.d_proc) THEN

378: l_message_list Error_Handler.Error_Tbl_Type;
379: BEGIN
380: d_position := 0;
381:
382: IF (PO_LOG.d_proc) THEN
383: PO_LOG.proc_begin(d_module);
384: END IF;
385:
386: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);

Line 383: PO_LOG.proc_begin(d_module);

379: BEGIN
380: d_position := 0;
381:
382: IF (PO_LOG.d_proc) THEN
383: PO_LOG.proc_begin(d_module);
384: END IF;
385:
386: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
387:

Line 412: IF (PO_LOG.d_stmt) THEN

408: l_num_tbl(i) := i;
409: END IF;
410: END LOOP;
411:
412: IF (PO_LOG.d_stmt) THEN
413: PO_LOG.stmt(d_module, d_position, 'count of to-be-processed lines',
414: l_num_tbl.COUNT);
415: END IF;
416:

Line 413: PO_LOG.stmt(d_module, d_position, 'count of to-be-processed lines',

409: END IF;
410: END LOOP;
411:
412: IF (PO_LOG.d_stmt) THEN
413: PO_LOG.stmt(d_module, d_position, 'count of to-be-processed lines',
414: l_num_tbl.COUNT);
415: END IF;
416:
417: IF (l_num_tbl.COUNT = 0) THEN

Line 420: IF (PO_LOG.d_proc) THEN

416:
417: IF (l_num_tbl.COUNT = 0) THEN
418: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
419:
420: IF (PO_LOG.d_proc) THEN
421: PO_LOG.proc_end (d_module);
422: END IF;
423:
424: RETURN;

Line 421: PO_LOG.proc_end (d_module);

417: IF (l_num_tbl.COUNT = 0) THEN
418: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
419:
420: IF (PO_LOG.d_proc) THEN
421: PO_LOG.proc_end (d_module);
422: END IF;
423:
424: RETURN;
425: END IF;

Line 427: IF (PO_LOG.d_stmt) THEN

423:
424: RETURN;
425: END IF;
426:
427: IF (PO_LOG.d_stmt) THEN
428: PO_LOG.stmt(d_module, d_position, 'po line ids', l_po_line_id_tbl);
429: PO_LOG.stmt(d_module, d_position, 'draft ids', l_draft_id_tbl);
430: END IF;
431:

Line 428: PO_LOG.stmt(d_module, d_position, 'po line ids', l_po_line_id_tbl);

424: RETURN;
425: END IF;
426:
427: IF (PO_LOG.d_stmt) THEN
428: PO_LOG.stmt(d_module, d_position, 'po line ids', l_po_line_id_tbl);
429: PO_LOG.stmt(d_module, d_position, 'draft ids', l_draft_id_tbl);
430: END IF;
431:
432: d_position := 10;

Line 429: PO_LOG.stmt(d_module, d_position, 'draft ids', l_draft_id_tbl);

425: END IF;
426:
427: IF (PO_LOG.d_stmt) THEN
428: PO_LOG.stmt(d_module, d_position, 'po line ids', l_po_line_id_tbl);
429: PO_LOG.stmt(d_module, d_position, 'draft ids', l_draft_id_tbl);
430: END IF;
431:
432: d_position := 10;
433:

Line 535: IF (PO_LOG.d_stmt) THEN

531: l_hazard_class_id_tbl;
532: -- Bug 13506679
533:
534:
535: IF (PO_LOG.d_stmt) THEN
536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);
537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);
538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);

Line 536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);

532: -- Bug 13506679
533:
534:
535: IF (PO_LOG.d_stmt) THEN
536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);
537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);
538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);
540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',

Line 537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);

533:
534:
535: IF (PO_LOG.d_stmt) THEN
536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);
537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);
538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);
540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',
541: l_expiration_date_tbl);

Line 538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);

534:
535: IF (PO_LOG.d_stmt) THEN
536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);
537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);
538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);
540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',
541: l_expiration_date_tbl);
542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',

Line 539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);

535: IF (PO_LOG.d_stmt) THEN
536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);
537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);
538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);
540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',
541: l_expiration_date_tbl);
542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',
543: l_retroactive_date_tbl);

Line 540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',

536: PO_LOG.stmt(d_module, d_position, 'orig po line ids', l_po_line_id_tbl);
537: PO_LOG.stmt(d_module, d_position, 'orig uom', l_unit_of_measure_tbl);
538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);
540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',
541: l_expiration_date_tbl);
542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',
543: l_retroactive_date_tbl);
544: PO_LOG.stmt(d_module, d_position, 'orig price break lookup code',

Line 542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',

538: PO_LOG.stmt(d_module, d_position, 'orig unit price', l_unit_price_tbl);
539: PO_LOG.stmt(d_module, d_position, 'orig item desc', l_item_desc_tbl);
540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',
541: l_expiration_date_tbl);
542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',
543: l_retroactive_date_tbl);
544: PO_LOG.stmt(d_module, d_position, 'orig price break lookup code',
545: l_price_break_lookup_code_tbl);
546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',

Line 544: PO_LOG.stmt(d_module, d_position, 'orig price break lookup code',

540: PO_LOG.stmt(d_module, d_position, 'orig expiration date',
541: l_expiration_date_tbl);
542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',
543: l_retroactive_date_tbl);
544: PO_LOG.stmt(d_module, d_position, 'orig price break lookup code',
545: l_price_break_lookup_code_tbl);
546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',
547: l_base_unit_price_tbl);
548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);

Line 546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',

542: PO_LOG.stmt(d_module, d_position, 'orig retroactive date',
543: l_retroactive_date_tbl);
544: PO_LOG.stmt(d_module, d_position, 'orig price break lookup code',
545: l_price_break_lookup_code_tbl);
546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',
547: l_base_unit_price_tbl);
548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);
549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);

Line 548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);

544: PO_LOG.stmt(d_module, d_position, 'orig price break lookup code',
545: l_price_break_lookup_code_tbl);
546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',
547: l_base_unit_price_tbl);
548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);
549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);

Line 549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);

545: l_price_break_lookup_code_tbl);
546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',
547: l_base_unit_price_tbl);
548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);
549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);

Line 550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);

546: PO_LOG.stmt(d_module, d_position, 'orig base unit price',
547: l_base_unit_price_tbl);
548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);
549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);

Line 551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);

547: l_base_unit_price_tbl);
548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);
549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927

Line 552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);

548: PO_LOG.stmt(d_module, d_position, 'orig attribute_14', l_attribute14_tbl);
549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927
556: -- Bug 13506679

Line 553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);

549: PO_LOG.stmt(d_module, d_position, 'orig amount', l_amount_tbl);
550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927
556: -- Bug 13506679
557: PO_LOG.stmt(d_module, d_position, 'un number tbl', l_un_number_id_tbl);

Line 554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);

550: PO_LOG.stmt(d_module, d_position, 'orig price limit', l_price_limit_tbl);
551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927
556: -- Bug 13506679
557: PO_LOG.stmt(d_module, d_position, 'un number tbl', l_un_number_id_tbl);
558: PO_LOG.stmt(d_module, d_position, 'hazard class id tbl', l_hazard_class_id_tbl);

Line 555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927

551: PO_LOG.stmt(d_module, d_position, 'orig negotiated flag', l_negotiated_flag_tbl);
552: PO_LOG.stmt(d_module, d_position, 'orig category_id', l_category_id_tbl);
553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927
556: -- Bug 13506679
557: PO_LOG.stmt(d_module, d_position, 'un number tbl', l_un_number_id_tbl);
558: PO_LOG.stmt(d_module, d_position, 'hazard class id tbl', l_hazard_class_id_tbl);
559: -- Bug 13506679

Line 557: PO_LOG.stmt(d_module, d_position, 'un number tbl', l_un_number_id_tbl);

553: PO_LOG.stmt(d_module, d_position, 'orig ip category id', l_ip_category_id_tbl);
554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927
556: -- Bug 13506679
557: PO_LOG.stmt(d_module, d_position, 'un number tbl', l_un_number_id_tbl);
558: PO_LOG.stmt(d_module, d_position, 'hazard class id tbl', l_hazard_class_id_tbl);
559: -- Bug 13506679
560: END IF;
561:

Line 558: PO_LOG.stmt(d_module, d_position, 'hazard class id tbl', l_hazard_class_id_tbl);

554: PO_LOG.stmt(d_module, d_position, 'allow desc update', l_allow_desc_update_tbl);
555: PO_LOG.stmt(d_module, d_position, 'draft id tbl', l_draft_id_tbl);-- Bug 11927927
556: -- Bug 13506679
557: PO_LOG.stmt(d_module, d_position, 'un number tbl', l_un_number_id_tbl);
558: PO_LOG.stmt(d_module, d_position, 'hazard class id tbl', l_hazard_class_id_tbl);
559: -- Bug 13506679
560: END IF;
561:
562: -- set up hashtable to refer to existing values

Line 580: IF (PO_LOG.d_stmt) THEN

576: -- rejected.
577: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
578: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
579:
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));
582: PO_LOG.stmt(d_module, d_position, 'reference',
583: l_line_ref_tbl(x_lines.po_line_id_tbl(i)));
584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));

Line 581: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));

577: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
578: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
579:
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));
582: PO_LOG.stmt(d_module, d_position, 'reference',
583: l_line_ref_tbl(x_lines.po_line_id_tbl(i)));
584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));
585: PO_LOG.stmt(d_module, d_position, 'new category_id',

Line 582: PO_LOG.stmt(d_module, d_position, 'reference',

578: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
579:
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));
582: PO_LOG.stmt(d_module, d_position, 'reference',
583: l_line_ref_tbl(x_lines.po_line_id_tbl(i)));
584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));
585: PO_LOG.stmt(d_module, d_position, 'new category_id',
586: l_category_id_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));

Line 584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));

580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));
582: PO_LOG.stmt(d_module, d_position, 'reference',
583: l_line_ref_tbl(x_lines.po_line_id_tbl(i)));
584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));
585: PO_LOG.stmt(d_module, d_position, 'new category_id',
586: l_category_id_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));
587: PO_LOG.stmt(d_module, d_position, 'allow_desc_update_flag',
588: l_allow_desc_update_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));

Line 585: PO_LOG.stmt(d_module, d_position, 'new category_id',

581: PO_LOG.stmt(d_module, d_position, 'po_line_id', x_lines.po_line_id_tbl(i));
582: PO_LOG.stmt(d_module, d_position, 'reference',
583: l_line_ref_tbl(x_lines.po_line_id_tbl(i)));
584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));
585: PO_LOG.stmt(d_module, d_position, 'new category_id',
586: l_category_id_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));
587: PO_LOG.stmt(d_module, d_position, 'allow_desc_update_flag',
588: l_allow_desc_update_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));
589: END IF;

Line 587: PO_LOG.stmt(d_module, d_position, 'allow_desc_update_flag',

583: l_line_ref_tbl(x_lines.po_line_id_tbl(i)));
584: PO_LOG.stmt(d_module, d_position, 'orig category_id', x_lines.category_id_tbl(i));
585: PO_LOG.stmt(d_module, d_position, 'new category_id',
586: l_category_id_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));
587: PO_LOG.stmt(d_module, d_position, 'allow_desc_update_flag',
588: l_allow_desc_update_tbl(l_line_ref_tbl(x_lines.po_line_id_tbl(i))));
589: END IF;
590:
591:

Line 619: IF (PO_LOG.d_stmt) THEN

615: p_vendor_id_tbl => x_lines.hd_vendor_id_tbl,
616: x_price_update_tolerance_tbl => x_lines.price_update_tolerance_tbl
617: );
618:
619: IF (PO_LOG.d_stmt) THEN
620: PO_LOG.stmt(d_module, d_position, 'price tolerance',
621: x_lines.price_update_tolerance_tbl);
622: END IF;
623:

Line 620: PO_LOG.stmt(d_module, d_position, 'price tolerance',

616: x_price_update_tolerance_tbl => x_lines.price_update_tolerance_tbl
617: );
618:
619: IF (PO_LOG.d_stmt) THEN
620: PO_LOG.stmt(d_module, d_position, 'price tolerance',
621: x_lines.price_update_tolerance_tbl);
622: END IF;
623:
624: d_position := 50;

Line 644: IF (PO_LOG.d_stmt) THEN

640:
641:
642: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
643: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
644: IF (PO_LOG.d_stmt) THEN
645: PO_LOG.stmt(d_module, d_position, 'update line on index', i);
646: END IF;
647:
648: -- reset variables

Line 645: PO_LOG.stmt(d_module, d_position, 'update line on index', i);

641:
642: IF (x_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
643: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
644: IF (PO_LOG.d_stmt) THEN
645: PO_LOG.stmt(d_module, d_position, 'update line on index', i);
646: END IF;
647:
648: -- reset variables
649: l_uom_different := FND_API.g_FALSE;

Line 655: IF (PO_LOG.d_stmt) THEN

651:
652: -- get index reference in existing value tables
653: l_index := l_line_ref_tbl(x_lines.po_line_id_tbl(i));
654:
655: IF (PO_LOG.d_stmt) THEN
656: PO_LOG.stmt(d_module, d_position, 'reference in original values',
657: l_index);
658: END IF;
659:

Line 656: PO_LOG.stmt(d_module, d_position, 'reference in original values',

652: -- get index reference in existing value tables
653: l_index := l_line_ref_tbl(x_lines.po_line_id_tbl(i));
654:
655: IF (PO_LOG.d_stmt) THEN
656: PO_LOG.stmt(d_module, d_position, 'reference in original values',
657: l_index);
658: END IF;
659:
660: d_position := 70;

Line 668: IF (PO_LOG.d_stmt) THEN

664: x_lines.order_type_lookup_code_tbl(i) <> 'FIXED PRICE' AND
665: x_lines.unit_of_measure_tbl(i) <> l_unit_of_measure_tbl(l_index)) THEN
666: l_uom_different := FND_API.g_TRUE;
667:
668: IF (PO_LOG.d_stmt) THEN
669: PO_LOG.stmt(d_module, d_position, 'uom_different',
670: l_uom_different);
671: END IF;
672:

Line 669: PO_LOG.stmt(d_module, d_position, 'uom_different',

665: x_lines.unit_of_measure_tbl(i) <> l_unit_of_measure_tbl(l_index)) THEN
666: l_uom_different := FND_API.g_TRUE;
667:
668: IF (PO_LOG.d_stmt) THEN
669: PO_LOG.stmt(d_module, d_position, 'uom_different',
670: l_uom_different);
671: END IF;
672:
673: END IF;

Line 680: IF (PO_LOG.d_stmt) THEN

676:
677: -- update description
678: IF (NVL(x_lines.allow_desc_update_flag_tbl(i), 'Y') = 'Y' AND
679: x_lines.item_desc_tbl(i) IS NOT NULL) THEN
680: IF (PO_LOG.d_stmt) THEN
681: PO_LOG.stmt(d_module, d_position, 'item id', x_lines.item_id_tbl(i));
682: PO_LOG.stmt(d_module, d_position, 'item desc', x_lines.item_desc_tbl(i));
683: END IF;
684:

Line 681: PO_LOG.stmt(d_module, d_position, 'item id', x_lines.item_id_tbl(i));

677: -- update description
678: IF (NVL(x_lines.allow_desc_update_flag_tbl(i), 'Y') = 'Y' AND
679: x_lines.item_desc_tbl(i) IS NOT NULL) THEN
680: IF (PO_LOG.d_stmt) THEN
681: PO_LOG.stmt(d_module, d_position, 'item id', x_lines.item_id_tbl(i));
682: PO_LOG.stmt(d_module, d_position, 'item desc', x_lines.item_desc_tbl(i));
683: END IF;
684:
685: -- update description in item master

Line 682: PO_LOG.stmt(d_module, d_position, 'item desc', x_lines.item_desc_tbl(i));

678: IF (NVL(x_lines.allow_desc_update_flag_tbl(i), 'Y') = 'Y' AND
679: x_lines.item_desc_tbl(i) IS NOT NULL) THEN
680: IF (PO_LOG.d_stmt) THEN
681: PO_LOG.stmt(d_module, d_position, 'item id', x_lines.item_id_tbl(i));
682: PO_LOG.stmt(d_module, d_position, 'item desc', x_lines.item_desc_tbl(i));
683: END IF;
684:
685: -- update description in item master
686: IF (NVL(PO_PDOI_PARAMS.g_request.create_items, 'N') = 'Y' AND

Line 705: IF (PO_LOG.d_stmt) THEN

701: END IF;
702:
703: d_position := 100;
704:
705: IF (PO_LOG.d_stmt) THEN
706: PO_LOG.stmt(d_module, d_position, 'create_line_loc',
707: x_lines.create_line_loc_tbl(i));
708: PO_LOG.stmt(d_module, d_position, 'unit_price',
709: x_lines.unit_price_tbl(i));

Line 706: PO_LOG.stmt(d_module, d_position, 'create_line_loc',

702:
703: d_position := 100;
704:
705: IF (PO_LOG.d_stmt) THEN
706: PO_LOG.stmt(d_module, d_position, 'create_line_loc',
707: x_lines.create_line_loc_tbl(i));
708: PO_LOG.stmt(d_module, d_position, 'unit_price',
709: x_lines.unit_price_tbl(i));
710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',

Line 708: PO_LOG.stmt(d_module, d_position, 'unit_price',

704:
705: IF (PO_LOG.d_stmt) THEN
706: PO_LOG.stmt(d_module, d_position, 'create_line_loc',
707: x_lines.create_line_loc_tbl(i));
708: PO_LOG.stmt(d_module, d_position, 'unit_price',
709: x_lines.unit_price_tbl(i));
710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',
711: l_unit_price_tbl(l_index));
712: PO_LOG.stmt(d_module, d_position, 'process_code in request',

Line 710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',

706: PO_LOG.stmt(d_module, d_position, 'create_line_loc',
707: x_lines.create_line_loc_tbl(i));
708: PO_LOG.stmt(d_module, d_position, 'unit_price',
709: x_lines.unit_price_tbl(i));
710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',
711: l_unit_price_tbl(l_index));
712: PO_LOG.stmt(d_module, d_position, 'process_code in request',
713: PO_PDOI_PARAMS.g_request.process_code);
714: PO_LOG.stmt(d_module, d_position, 'role in request',

Line 712: PO_LOG.stmt(d_module, d_position, 'process_code in request',

708: PO_LOG.stmt(d_module, d_position, 'unit_price',
709: x_lines.unit_price_tbl(i));
710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',
711: l_unit_price_tbl(l_index));
712: PO_LOG.stmt(d_module, d_position, 'process_code in request',
713: PO_PDOI_PARAMS.g_request.process_code);
714: PO_LOG.stmt(d_module, d_position, 'role in request',
715: PO_PDOI_PARAMS.g_request.role);
716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',

Line 714: PO_LOG.stmt(d_module, d_position, 'role in request',

710: PO_LOG.stmt(d_module, d_position, 'orig unit_price',
711: l_unit_price_tbl(l_index));
712: PO_LOG.stmt(d_module, d_position, 'process_code in request',
713: PO_PDOI_PARAMS.g_request.process_code);
714: PO_LOG.stmt(d_module, d_position, 'role in request',
715: PO_PDOI_PARAMS.g_request.role);
716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
717: x_lines.hd_global_agreement_flag_tbl(i));
718: PO_LOG.stmt(d_module, d_position, 'uom_different',

Line 716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',

712: PO_LOG.stmt(d_module, d_position, 'process_code in request',
713: PO_PDOI_PARAMS.g_request.process_code);
714: PO_LOG.stmt(d_module, d_position, 'role in request',
715: PO_PDOI_PARAMS.g_request.role);
716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
717: x_lines.hd_global_agreement_flag_tbl(i));
718: PO_LOG.stmt(d_module, d_position, 'uom_different',
719: l_uom_different);
720: PO_LOG.stmt(d_module, d_position, 'orig intf line id',

Line 718: PO_LOG.stmt(d_module, d_position, 'uom_different',

714: PO_LOG.stmt(d_module, d_position, 'role in request',
715: PO_PDOI_PARAMS.g_request.role);
716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
717: x_lines.hd_global_agreement_flag_tbl(i));
718: PO_LOG.stmt(d_module, d_position, 'uom_different',
719: l_uom_different);
720: PO_LOG.stmt(d_module, d_position, 'orig intf line id',
721: l_orig_intf_line_id_tbl(l_index));
722: END IF;

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

716: PO_LOG.stmt(d_module, d_position, 'global agreement flag',
717: x_lines.hd_global_agreement_flag_tbl(i));
718: PO_LOG.stmt(d_module, d_position, 'uom_different',
719: l_uom_different);
720: PO_LOG.stmt(d_module, d_position, 'orig intf line id',
721: l_orig_intf_line_id_tbl(l_index));
722: END IF;
723:
724: -- bug5149827

Line 731: IF (PO_LOG.d_stmt) THEN

727: IF (PO_PDOI_PARAMS.g_request.process_code <>
728: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
729: AND
730: l_orig_intf_line_id_tbl(l_index) IS NOT NULL) THEN
731: IF (PO_LOG.d_stmt) THEN
732: PO_LOG.stmt(d_module, d_position, 'orig_intf_line_id exists');
733: END IF;
734:
735: l_exceed_tolerance := FND_API.G_TRUE;

Line 732: PO_LOG.stmt(d_module, d_position, 'orig_intf_line_id exists');

728: PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
729: AND
730: l_orig_intf_line_id_tbl(l_index) IS NOT NULL) THEN
731: IF (PO_LOG.d_stmt) THEN
732: PO_LOG.stmt(d_module, d_position, 'orig_intf_line_id exists');
733: END IF;
734:
735: l_exceed_tolerance := FND_API.G_TRUE;
736: x_lines.parent_interface_line_id_tbl(i) := l_orig_intf_line_id_tbl(l_index);

Line 783: IF (PO_LOG.d_stmt) THEN

779: ELSE
780: x_lines.unit_price_tbl(i) := NULL;
781: END IF; -- if unit price = NULLIFY_NUM
782:
783: IF (PO_LOG.d_stmt) THEN
784: PO_LOG.stmt(d_module, d_position, 'l_exceed_tolerance', l_exceed_tolerance);
785: END IF;
786:
787: d_position := 120;

Line 784: PO_LOG.stmt(d_module, d_position, 'l_exceed_tolerance', l_exceed_tolerance);

780: x_lines.unit_price_tbl(i) := NULL;
781: END IF; -- if unit price = NULLIFY_NUM
782:
783: IF (PO_LOG.d_stmt) THEN
784: PO_LOG.stmt(d_module, d_position, 'l_exceed_tolerance', l_exceed_tolerance);
785: END IF;
786:
787: d_position := 120;
788:

Line 827: IF (PO_LOG.d_stmt) THEN

823: -- bug5149827
824: -- Move the handling of exceed tolerance = T to here
825: IF (l_exceed_tolerance = FND_API.g_TRUE) THEN
826:
827: IF (PO_LOG.d_stmt) THEN
828: PO_LOG.stmt(d_module, d_position, 'set line to be notified', i);
829: PO_LOG.stmt(d_module, d_position, 'notified intf header id',
830: x_lines.intf_header_id_tbl(i));
831: END IF;

Line 828: PO_LOG.stmt(d_module, d_position, 'set line to be notified', i);

824: -- Move the handling of exceed tolerance = T to here
825: IF (l_exceed_tolerance = FND_API.g_TRUE) THEN
826:
827: IF (PO_LOG.d_stmt) THEN
828: PO_LOG.stmt(d_module, d_position, 'set line to be notified', i);
829: PO_LOG.stmt(d_module, d_position, 'notified intf header id',
830: x_lines.intf_header_id_tbl(i));
831: END IF;
832:

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

825: IF (l_exceed_tolerance = FND_API.g_TRUE) THEN
826:
827: IF (PO_LOG.d_stmt) THEN
828: PO_LOG.stmt(d_module, d_position, 'set line to be notified', i);
829: PO_LOG.stmt(d_module, d_position, 'notified intf header id',
830: x_lines.intf_header_id_tbl(i));
831: END IF;
832:
833: -- set process_code to be 'NOTIFIED' for this line;

Line 884: IF (PO_LOG.d_stmt) THEN

880: p_currency_code => x_lines.hd_currency_code_tbl(i),
881: x_precision_tbl => l_precision_tbl
882: );
883:
884: IF (PO_LOG.d_stmt) THEN
885: PO_LOG.stmt(d_module, d_position, 'l_precision', l_precision);
886: END IF;
887:
888: -- retroactive_date reset to sysdate since price is changed

Line 885: PO_LOG.stmt(d_module, d_position, 'l_precision', l_precision);

881: x_precision_tbl => l_precision_tbl
882: );
883:
884: IF (PO_LOG.d_stmt) THEN
885: PO_LOG.stmt(d_module, d_position, 'l_precision', l_precision);
886: END IF;
887:
888: -- retroactive_date reset to sysdate since price is changed
889: IF (PO_PDOI_PARAMS.g_request.document_type = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET AND

Line 899: IF (PO_LOG.d_stmt) THEN

895:
896: l_unit_price_tbl(l_index) :=
897: round((l_unit_price_tbl(l_index)/l_uom_rate),l_precision);
898:
899: IF (PO_LOG.d_stmt) THEN
900: PO_LOG.stmt(d_module, d_position, 'new price', l_unit_price_tbl(l_index));
901: END IF;
902:
903: IF (x_lines.base_unit_price_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM) THEN

Line 900: PO_LOG.stmt(d_module, d_position, 'new price', l_unit_price_tbl(l_index));

896: l_unit_price_tbl(l_index) :=
897: round((l_unit_price_tbl(l_index)/l_uom_rate),l_precision);
898:
899: IF (PO_LOG.d_stmt) THEN
900: PO_LOG.stmt(d_module, d_position, 'new price', l_unit_price_tbl(l_index));
901: END IF;
902:
903: IF (x_lines.base_unit_price_tbl(i) = PO_PDOI_CONSTANTS.g_NULLIFY_NUM) THEN
904: l_base_unit_price_tbl(l_index) := NULL;

Line 1052: IF (PO_LOG.d_stmt) THEN

1048: -- set has_lines_updated flag in g_docs_info
1049: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
1050: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
1051:
1052: IF (PO_LOG.d_stmt) THEN
1053: PO_LOG.stmt(d_module, d_position, 'line updated for document',
1054: x_lines.intf_header_id_tbl(i));
1055: END IF;
1056: END IF;

Line 1053: PO_LOG.stmt(d_module, d_position, 'line updated for document',

1049: IF (l_exceed_tolerance = FND_API.g_FALSE) THEN
1050: PO_PDOI_PARAMS.g_docs_info(x_lines.intf_header_id_tbl(i)).has_lines_updated := 'Y';
1051:
1052: IF (PO_LOG.d_stmt) THEN
1053: PO_LOG.stmt(d_module, d_position, 'line updated for document',
1054: x_lines.intf_header_id_tbl(i));
1055: END IF;
1056: END IF;
1057:

Line 1096: IF (PO_LOG.d_stmt) THEN

1092: );
1093:
1094: d_position := 270;
1095:
1096: IF (PO_LOG.d_stmt) THEN
1097: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1098: l_return_status);
1099: END IF;
1100:

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

1093:
1094: d_position := 270;
1095:
1096: IF (PO_LOG.d_stmt) THEN
1097: PO_LOG.stmt(d_module, d_position, 'return status for item update',
1098: l_return_status);
1099: END IF;
1100:
1101: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 1108: IF (PO_LOG.d_stmt) THEN

1104: (
1105: x_message_list => l_message_list
1106: );
1107:
1108: IF (PO_LOG.d_stmt) THEN
1109: PO_LOG.stmt(d_module, d_position, 'count of error message',
1110: l_message_list.COUNT);
1111: END IF;
1112:

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

1105: x_message_list => l_message_list
1106: );
1107:
1108: IF (PO_LOG.d_stmt) THEN
1109: PO_LOG.stmt(d_module, d_position, 'count of error message',
1110: l_message_list.COUNT);
1111: END IF;
1112:
1113: FOR i IN 1..l_message_list.COUNT

Line 1115: IF (PO_LOG.d_stmt) THEN

1111: END IF;
1112:
1113: FOR i IN 1..l_message_list.COUNT
1114: LOOP
1115: IF (PO_LOG.d_stmt) THEN
1116: PO_LOG.stmt(d_module, d_position, 'index', i);
1117: PO_LOG.stmt(d_module, d_position, 'intf header id',
1118: x_lines.intf_header_id_tbl(l_index));
1119: PO_LOG.stmt(d_module, d_position, 'intf line id',

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

1112:
1113: FOR i IN 1..l_message_list.COUNT
1114: LOOP
1115: IF (PO_LOG.d_stmt) THEN
1116: PO_LOG.stmt(d_module, d_position, 'index', i);
1117: PO_LOG.stmt(d_module, d_position, 'intf header id',
1118: x_lines.intf_header_id_tbl(l_index));
1119: PO_LOG.stmt(d_module, d_position, 'intf line id',
1120: x_lines.intf_line_id_tbl(l_index));

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

1113: FOR i IN 1..l_message_list.COUNT
1114: LOOP
1115: IF (PO_LOG.d_stmt) THEN
1116: PO_LOG.stmt(d_module, d_position, 'index', i);
1117: PO_LOG.stmt(d_module, d_position, 'intf header id',
1118: x_lines.intf_header_id_tbl(l_index));
1119: PO_LOG.stmt(d_module, d_position, 'intf line id',
1120: x_lines.intf_line_id_tbl(l_index));
1121: PO_LOG.stmt(d_module, d_position, 'message text',

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

1115: IF (PO_LOG.d_stmt) THEN
1116: PO_LOG.stmt(d_module, d_position, 'index', i);
1117: PO_LOG.stmt(d_module, d_position, 'intf header id',
1118: x_lines.intf_header_id_tbl(l_index));
1119: PO_LOG.stmt(d_module, d_position, 'intf line id',
1120: x_lines.intf_line_id_tbl(l_index));
1121: PO_LOG.stmt(d_module, d_position, 'message text',
1122: l_message_list(i).message_text);
1123: PO_LOG.stmt(d_module, d_position, 'table name',

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

1117: PO_LOG.stmt(d_module, d_position, 'intf header id',
1118: x_lines.intf_header_id_tbl(l_index));
1119: PO_LOG.stmt(d_module, d_position, 'intf line id',
1120: x_lines.intf_line_id_tbl(l_index));
1121: PO_LOG.stmt(d_module, d_position, 'message text',
1122: l_message_list(i).message_text);
1123: PO_LOG.stmt(d_module, d_position, 'table name',
1124: l_message_list(i).table_name);
1125: END IF;

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

1119: PO_LOG.stmt(d_module, d_position, 'intf line id',
1120: x_lines.intf_line_id_tbl(l_index));
1121: PO_LOG.stmt(d_module, d_position, 'message text',
1122: l_message_list(i).message_text);
1123: PO_LOG.stmt(d_module, d_position, 'table name',
1124: l_message_list(i).table_name);
1125: END IF;
1126:
1127: PO_PDOI_ERR_UTL.add_fatal_error

Line 1143: IF (PO_LOG.d_proc) THEN

1139: x_lines.error_flag_tbl(l_index) := FND_API.g_TRUE;
1140:
1141: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end (d_module);
1145: END IF;
1146:
1147: RETURN;

Line 1144: PO_LOG.proc_end (d_module);

1140:
1141: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1142:
1143: IF (PO_LOG.d_proc) THEN
1144: PO_LOG.proc_end (d_module);
1145: END IF;
1146:
1147: RETURN;
1148: END IF;

Line 1465: IF (PO_LOG.d_proc) THEN

1461: );
1462:
1463: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1464:
1465: IF (PO_LOG.d_proc) THEN
1466: PO_LOG.proc_end (d_module);
1467: END IF;
1468:
1469: EXCEPTION

Line 1466: PO_LOG.proc_end (d_module);

1462:
1463: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_UPDATE);
1464:
1465: IF (PO_LOG.d_proc) THEN
1466: PO_LOG.proc_end (d_module);
1467: END IF;
1468:
1469: EXCEPTION
1470: WHEN OTHERS THEN

Line 1513: IF (PO_LOG.d_proc) THEN

1509: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1510: BEGIN
1511: d_position := 0;
1512:
1513: IF (PO_LOG.d_proc) THEN
1514: PO_LOG.proc_begin(d_module);
1515: END IF;
1516:
1517: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);

Line 1514: PO_LOG.proc_begin(d_module);

1510: BEGIN
1511: d_position := 0;
1512:
1513: IF (PO_LOG.d_proc) THEN
1514: PO_LOG.proc_begin(d_module);
1515: END IF;
1516:
1517: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1518:

Line 1566: IF (PO_LOG.d_proc) THEN

1562: );
1563:
1564: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1565:
1566: IF (PO_LOG.d_proc) THEN
1567: PO_LOG.proc_end (d_module);
1568: END IF;
1569:
1570: EXCEPTION

Line 1567: PO_LOG.proc_end (d_module);

1563:
1564: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_INSERT);
1565:
1566: IF (PO_LOG.d_proc) THEN
1567: PO_LOG.proc_end (d_module);
1568: END IF;
1569:
1570: EXCEPTION
1571: WHEN OTHERS THEN

Line 1608: IF (PO_LOG.d_proc) THEN

1604:
1605: BEGIN
1606: d_position := 0;
1607:
1608: IF (PO_LOG.d_proc) THEN
1609: PO_LOG.proc_begin(d_module);
1610: END IF;
1611:
1612: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);

Line 1609: PO_LOG.proc_begin(d_module);

1605: BEGIN
1606: d_position := 0;
1607:
1608: IF (PO_LOG.d_proc) THEN
1609: PO_LOG.proc_begin(d_module);
1610: END IF;
1611:
1612: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1613:

Line 1622: IF (PO_LOG.d_proc) THEN

1618: );
1619:
1620: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1621:
1622: IF (PO_LOG.d_proc) THEN
1623: PO_LOG.proc_end (d_module);
1624: END IF;
1625:
1626: EXCEPTION

Line 1623: PO_LOG.proc_end (d_module);

1619:
1620: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_INSERT);
1621:
1622: IF (PO_LOG.d_proc) THEN
1623: PO_LOG.proc_end (d_module);
1624: END IF;
1625:
1626: EXCEPTION
1627: WHEN OTHERS THEN

Line 1664: IF (PO_LOG.d_proc) THEN

1660:
1661: BEGIN
1662: d_position := 0;
1663:
1664: IF (PO_LOG.d_proc) THEN
1665: PO_LOG.proc_begin(d_module);
1666: END IF;
1667:
1668: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);

Line 1665: PO_LOG.proc_begin(d_module);

1661: BEGIN
1662: d_position := 0;
1663:
1664: IF (PO_LOG.d_proc) THEN
1665: PO_LOG.proc_begin(d_module);
1666: END IF;
1667:
1668: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1669:

Line 1678: IF (PO_LOG.d_proc) THEN

1674: );
1675:
1676: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1677:
1678: IF (PO_LOG.d_proc) THEN
1679: PO_LOG.proc_end (d_module);
1680: END IF;
1681:
1682: EXCEPTION

Line 1679: PO_LOG.proc_end (d_module);

1675:
1676: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_INSERT);
1677:
1678: IF (PO_LOG.d_proc) THEN
1679: PO_LOG.proc_end (d_module);
1680: END IF;
1681:
1682: EXCEPTION
1683: WHEN OTHERS THEN

Line 1737: IF (PO_LOG.d_proc) THEN

1733: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1734: BEGIN
1735: d_position := 0;
1736:
1737: IF (PO_LOG.d_proc) THEN
1738: PO_LOG.proc_begin(d_module, 'p_sync_attr_id_tbl', p_sync_attr_id_tbl);
1739: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1740: END IF;
1741:

Line 1738: PO_LOG.proc_begin(d_module, 'p_sync_attr_id_tbl', p_sync_attr_id_tbl);

1734: BEGIN
1735: d_position := 0;
1736:
1737: IF (PO_LOG.d_proc) THEN
1738: PO_LOG.proc_begin(d_module, 'p_sync_attr_id_tbl', p_sync_attr_id_tbl);
1739: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1740: END IF;
1741:
1742: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);

Line 1739: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);

1735: d_position := 0;
1736:
1737: IF (PO_LOG.d_proc) THEN
1738: PO_LOG.proc_begin(d_module, 'p_sync_attr_id_tbl', p_sync_attr_id_tbl);
1739: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1740: END IF;
1741:
1742: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1743:

Line 1796: IF (PO_LOG.d_proc) THEN

1792: );
1793:
1794: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1795:
1796: IF (PO_LOG.d_proc) THEN
1797: PO_LOG.proc_end (d_module);
1798: END IF;
1799:
1800: EXCEPTION

Line 1797: PO_LOG.proc_end (d_module);

1793:
1794: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_INSERT);
1795:
1796: IF (PO_LOG.d_proc) THEN
1797: PO_LOG.proc_end (d_module);
1798: END IF;
1799:
1800: EXCEPTION
1801: WHEN OTHERS THEN

Line 1855: IF (PO_LOG.d_proc) THEN

1851: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
1852: BEGIN
1853: d_position := 0;
1854:
1855: IF (PO_LOG.d_proc) THEN
1856: PO_LOG.proc_begin(d_module, 'p_sync_attr_tlp_id_tbl', p_sync_attr_tlp_id_tbl);
1857: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1858: END IF;
1859:

Line 1856: PO_LOG.proc_begin(d_module, 'p_sync_attr_tlp_id_tbl', p_sync_attr_tlp_id_tbl);

1852: BEGIN
1853: d_position := 0;
1854:
1855: IF (PO_LOG.d_proc) THEN
1856: PO_LOG.proc_begin(d_module, 'p_sync_attr_tlp_id_tbl', p_sync_attr_tlp_id_tbl);
1857: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1858: END IF;
1859:
1860: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);

Line 1857: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);

1853: d_position := 0;
1854:
1855: IF (PO_LOG.d_proc) THEN
1856: PO_LOG.proc_begin(d_module, 'p_sync_attr_tlp_id_tbl', p_sync_attr_tlp_id_tbl);
1857: PO_LOG.proc_begin(d_module, 'p_sync_draft_id_tbl', p_sync_draft_id_tbl);
1858: END IF;
1859:
1860: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1861:

Line 1918: IF (PO_LOG.d_proc) THEN

1914: );
1915:
1916: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1917:
1918: IF (PO_LOG.d_proc) THEN
1919: PO_LOG.proc_end (d_module);
1920: END IF;
1921:
1922: EXCEPTION

Line 1919: PO_LOG.proc_end (d_module);

1915:
1916: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_VALUES_TLP_INSERT);
1917:
1918: IF (PO_LOG.d_proc) THEN
1919: PO_LOG.proc_end (d_module);
1920: END IF;
1921:
1922: EXCEPTION
1923: WHEN OTHERS THEN

Line 1966: IF (PO_LOG.d_proc) THEN

1962: l_count NUMBER;
1963: BEGIN
1964: d_position := 0;
1965:
1966: IF (PO_LOG.d_proc) THEN
1967: PO_LOG.proc_begin(d_module);
1968: END IF;
1969:
1970: IF (PO_LOG.d_stmt) THEN

Line 1967: PO_LOG.proc_begin(d_module);

1963: BEGIN
1964: d_position := 0;
1965:
1966: IF (PO_LOG.d_proc) THEN
1967: PO_LOG.proc_begin(d_module);
1968: END IF;
1969:
1970: IF (PO_LOG.d_stmt) THEN
1971: FOR i IN 1..p_headers.rec_count

Line 1970: IF (PO_LOG.d_stmt) THEN

1966: IF (PO_LOG.d_proc) THEN
1967: PO_LOG.proc_begin(d_module);
1968: END IF;
1969:
1970: IF (PO_LOG.d_stmt) THEN
1971: FOR i IN 1..p_headers.rec_count
1972: LOOP
1973: IF (p_headers.error_flag_tbl(i) = FND_API.G_FALSE) THEN
1974: l_valid_intf_header_id_tbl.EXTEND(1);

Line 1981: PO_LOG.stmt(d_module, d_position, 'intf header to be inserted',

1977: p_headers.intf_header_id_tbl(i);
1978: END IF;
1979: END LOOP;
1980:
1981: PO_LOG.stmt(d_module, d_position, 'intf header to be inserted',
1982: l_valid_intf_header_id_tbl);
1983: END IF;
1984:
1985: FORALL i IN 1..p_headers.rec_count

Line 2246: IF (PO_LOG.d_proc) THEN

2242: FROM po_headers_interface
2243: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2244: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE;
2245:
2246: IF (PO_LOG.d_proc) THEN
2247: PO_LOG.proc_end (d_module);
2248: END IF;
2249:
2250: EXCEPTION

Line 2247: PO_LOG.proc_end (d_module);

2243: WHERE interface_header_id = p_headers.intf_header_id_tbl(i)
2244: AND p_headers.error_flag_tbl(i) = FND_API.g_FALSE;
2245:
2246: IF (PO_LOG.d_proc) THEN
2247: PO_LOG.proc_end (d_module);
2248: END IF;
2249:
2250: EXCEPTION
2251: WHEN OTHERS THEN

Line 2289: IF (PO_LOG.d_proc) THEN

2285:
2286: BEGIN
2287: d_position := 0;
2288:
2289: IF (PO_LOG.d_proc) THEN
2290: PO_LOG.proc_begin(d_module);
2291: END IF;
2292:
2293: IF (PO_PDOI_PARAMS.g_request.document_type =

Line 2290: PO_LOG.proc_begin(d_module);

2286: BEGIN
2287: d_position := 0;
2288:
2289: IF (PO_LOG.d_proc) THEN
2290: PO_LOG.proc_begin(d_module);
2291: END IF;
2292:
2293: IF (PO_PDOI_PARAMS.g_request.document_type =
2294: PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET) THEN

Line 2335: IF (PO_LOG.d_proc) THEN

2331: AND p_headers.doc_type_tbl(i) = PO_PDOI_CONSTANTS.g_DOC_TYPE_BLANKET
2332: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_end (d_module);
2337: END IF;
2338:
2339: EXCEPTION

Line 2336: PO_LOG.proc_end (d_module);

2332: AND COALESCE(global_agreement_flag, PO_PDOI_PARAMS.g_request.ga_flag, 'N') = 'Y';
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_end (d_module);
2337: END IF;
2338:
2339: EXCEPTION
2340: WHEN OTHERS THEN

Line 2386: IF (PO_LOG.d_proc) THEN

2382:
2383: BEGIN
2384: d_position := 0;
2385:
2386: IF (PO_LOG.d_proc) THEN
2387: PO_LOG.proc_begin(d_module);
2388: END IF;
2389:
2390: -- add distribution row from po_headers_interface table

Line 2387: PO_LOG.proc_begin(d_module);

2383: BEGIN
2384: d_position := 0;
2385:
2386: IF (PO_LOG.d_proc) THEN
2387: PO_LOG.proc_begin(d_module);
2388: END IF;
2389:
2390: -- add distribution row from po_headers_interface table
2391: IF (PO_PDOI_PARAMS.g_request.document_type =

Line 2457: IF (PO_LOG.d_proc) THEN

2453: WHERE p_headers.error_flag_tbl(i) = FND_API.g_FALSE
2454: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';
2455: END IF;
2456:
2457: IF (PO_LOG.d_proc) THEN
2458: PO_LOG.proc_end (d_module);
2459: END IF;
2460:
2461: EXCEPTION

Line 2458: PO_LOG.proc_end (d_module);

2454: AND p_headers.encumbrance_required_flag_tbl(i) = 'Y';
2455: END IF;
2456:
2457: IF (PO_LOG.d_proc) THEN
2458: PO_LOG.proc_end (d_module);
2459: END IF;
2460:
2461: EXCEPTION
2462: WHEN OTHERS THEN

Line 2511: IF (PO_LOG.d_proc) THEN

2507: l_count NUMBER := 0;
2508: BEGIN
2509: d_position := 0;
2510:
2511: IF (PO_LOG.d_proc) THEN
2512: PO_LOG.proc_begin(d_module);
2513: END IF;
2514:
2515: IF (PO_LOG.d_stmt) THEN

Line 2512: PO_LOG.proc_begin(d_module);

2508: BEGIN
2509: d_position := 0;
2510:
2511: IF (PO_LOG.d_proc) THEN
2512: PO_LOG.proc_begin(d_module);
2513: END IF;
2514:
2515: IF (PO_LOG.d_stmt) THEN
2516: FOR i IN 1..p_dists.rec_count

Line 2515: IF (PO_LOG.d_stmt) THEN

2511: IF (PO_LOG.d_proc) THEN
2512: PO_LOG.proc_begin(d_module);
2513: END IF;
2514:
2515: IF (PO_LOG.d_stmt) THEN
2516: FOR i IN 1..p_dists.rec_count
2517: LOOP
2518: IF (p_dists.error_flag_tbl(i) = FND_API.g_FALSE) THEN
2519: l_valid_intf_dist_id_tbl.EXTEND(1);

Line 2526: PO_LOG.stmt(d_module, d_position, 'intf dist to be inserted',

2522: p_dists.intf_dist_id_tbl(i);
2523: END IF;
2524: END LOOP;
2525:
2526: PO_LOG.stmt(d_module, d_position, 'intf dist to be inserted',
2527: l_valid_intf_dist_id_tbl);
2528: END IF;
2529:
2530: -- add distribution row from po_distributions_inteface table

Line 2742: IF (PO_LOG.d_proc) THEN

2738: FROM po_distributions_interface
2739: WHERE interface_distribution_id = p_dists.intf_dist_id_tbl(i)
2740: AND p_dists.error_flag_tbl(i) = FND_API.g_FALSE;
2741:
2742: IF (PO_LOG.d_proc) THEN
2743: PO_LOG.proc_end (d_module);
2744: END IF;
2745:
2746: EXCEPTION

Line 2743: PO_LOG.proc_end (d_module);

2739: WHERE interface_distribution_id = p_dists.intf_dist_id_tbl(i)
2740: AND p_dists.error_flag_tbl(i) = FND_API.g_FALSE;
2741:
2742: IF (PO_LOG.d_proc) THEN
2743: PO_LOG.proc_end (d_module);
2744: END IF;
2745:
2746: EXCEPTION
2747: WHEN OTHERS THEN

Line 2787: IF (PO_LOG.d_proc) THEN

2783: l_count NUMBER := 0;
2784: BEGIN
2785: d_position := 0;
2786:
2787: IF (PO_LOG.d_proc) THEN
2788: PO_LOG.proc_begin(d_module);
2789: END IF;
2790:
2791:

Line 2788: PO_LOG.proc_begin(d_module);

2784: BEGIN
2785: d_position := 0;
2786:
2787: IF (PO_LOG.d_proc) THEN
2788: PO_LOG.proc_begin(d_module);
2789: END IF;
2790:
2791:
2792: IF (PO_LOG.d_stmt) THEN

Line 2792: IF (PO_LOG.d_stmt) THEN

2788: PO_LOG.proc_begin(d_module);
2789: END IF;
2790:
2791:
2792: IF (PO_LOG.d_stmt) THEN
2793:
2794: FOR i IN 1..p_lines.rec_count
2795: LOOP
2796: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND

Line 2798: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));

2794: FOR i IN 1..p_lines.rec_count
2795: LOOP
2796: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
2797: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
2798: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2799: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2800: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));
2801: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));
2802: PO_LOG.stmt(d_module, d_position, 'supplier_part_auxid',

Line 2799: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));

2795: LOOP
2796: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
2797: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
2798: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2799: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2800: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));
2801: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));
2802: PO_LOG.stmt(d_module, d_position, 'supplier_part_auxid',
2803: p_lines.supplier_part_auxid_tbl(i));

Line 2800: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));

2796: IF (p_lines.error_flag_tbl(i) = FND_API.g_FALSE AND
2797: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
2798: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2799: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2800: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));
2801: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));
2802: PO_LOG.stmt(d_module, d_position, 'supplier_part_auxid',
2803: p_lines.supplier_part_auxid_tbl(i));
2804: END IF;

Line 2801: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));

2797: p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE) THEN
2798: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2799: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2800: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));
2801: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));
2802: PO_LOG.stmt(d_module, d_position, 'supplier_part_auxid',
2803: p_lines.supplier_part_auxid_tbl(i));
2804: END IF;
2805: END LOOP;

Line 2802: PO_LOG.stmt(d_module, d_position, 'supplier_part_auxid',

2798: PO_LOG.stmt(d_module, d_position, 'interface line id', p_lines.intf_line_id_tbl(i));
2799: PO_LOG.stmt(d_module, d_position, 'po_header_id', p_lines.po_header_id_tbl(i));
2800: PO_LOG.stmt(d_module, d_position, 'line_num', p_lines.line_num_tbl(i));
2801: PO_LOG.stmt(d_module, d_position, 'draft_id', p_lines.draft_id_tbl(i));
2802: PO_LOG.stmt(d_module, d_position, 'supplier_part_auxid',
2803: p_lines.supplier_part_auxid_tbl(i));
2804: END IF;
2805: END LOOP;
2806: END IF;

Line 3089: IF (PO_LOG.d_proc) THEN

3085: WHERE interface_line_id = p_lines.intf_line_id_tbl(i)
3086: AND p_lines.error_flag_tbl(i) = FND_API.g_FALSE
3087: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;
3088:
3089: IF (PO_LOG.d_proc) THEN
3090: PO_LOG.proc_end (d_module);
3091: END IF;
3092:
3093: EXCEPTION

Line 3090: PO_LOG.proc_end (d_module);

3086: AND p_lines.error_flag_tbl(i) = FND_API.g_FALSE
3087: AND p_lines.need_to_reject_flag_tbl(i) = FND_API.g_FALSE;
3088:
3089: IF (PO_LOG.d_proc) THEN
3090: PO_LOG.proc_end (d_module);
3091: END IF;
3092:
3093: EXCEPTION
3094: WHEN OTHERS THEN

Line 3135: IF (PO_LOG.d_proc) THEN

3131: l_count NUMBER := 0;
3132: BEGIN
3133: d_position := 0;
3134:
3135: IF (PO_LOG.d_proc) THEN
3136: PO_LOG.proc_begin(d_module);
3137: END IF;
3138:
3139: IF (PO_LOG.d_stmt) THEN

Line 3136: PO_LOG.proc_begin(d_module);

3132: BEGIN
3133: d_position := 0;
3134:
3135: IF (PO_LOG.d_proc) THEN
3136: PO_LOG.proc_begin(d_module);
3137: END IF;
3138:
3139: IF (PO_LOG.d_stmt) THEN
3140: FOR i IN 1..p_line_locs.rec_count

Line 3139: IF (PO_LOG.d_stmt) THEN

3135: IF (PO_LOG.d_proc) THEN
3136: PO_LOG.proc_begin(d_module);
3137: END IF;
3138:
3139: IF (PO_LOG.d_stmt) THEN
3140: FOR i IN 1..p_line_locs.rec_count
3141: LOOP
3142: IF (p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE) THEN
3143: l_valid_intf_loc_id_tbl.EXTEND(1);

Line 3150: PO_LOG.stmt(d_module, d_position, 'intf line loc to be inserted',

3146: p_line_locs.intf_line_loc_id_tbl(i);
3147: END IF;
3148: END LOOP;
3149:
3150: PO_LOG.stmt(d_module, d_position, 'intf line loc to be inserted',
3151: l_valid_intf_loc_id_tbl);
3152: END IF;
3153:
3154: --Bug 8565385. If unit_meas_lookup_code is null for line_locations,

Line 3383: IF (PO_LOG.d_proc) THEN

3379: FROM po_line_locations_interface
3380: WHERE interface_line_location_id = p_line_locs.intf_line_loc_id_tbl(i)
3381: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
3382:
3383: IF (PO_LOG.d_proc) THEN
3384: PO_LOG.proc_end (d_module);
3385: END IF;
3386:
3387: EXCEPTION

Line 3384: PO_LOG.proc_end (d_module);

3380: WHERE interface_line_location_id = p_line_locs.intf_line_loc_id_tbl(i)
3381: AND p_line_locs.error_flag_tbl(i) = FND_API.g_FALSE;
3382:
3383: IF (PO_LOG.d_proc) THEN
3384: PO_LOG.proc_end (d_module);
3385: END IF;
3386:
3387: EXCEPTION
3388: WHEN OTHERS THEN

Line 3429: IF (PO_LOG.d_proc) THEN

3425: l_count NUMBER := 0;
3426: BEGIN
3427: d_position := 0;
3428:
3429: IF (PO_LOG.d_proc) THEN
3430: PO_LOG.proc_begin(d_module);
3431: END IF;
3432:
3433: IF (PO_LOG.d_stmt) THEN

Line 3430: PO_LOG.proc_begin(d_module);

3426: BEGIN
3427: d_position := 0;
3428:
3429: IF (PO_LOG.d_proc) THEN
3430: PO_LOG.proc_begin(d_module);
3431: END IF;
3432:
3433: IF (PO_LOG.d_stmt) THEN
3434: FOR i IN 1..p_price_diffs.rec_count

Line 3433: IF (PO_LOG.d_stmt) THEN

3429: IF (PO_LOG.d_proc) THEN
3430: PO_LOG.proc_begin(d_module);
3431: END IF;
3432:
3433: IF (PO_LOG.d_stmt) THEN
3434: FOR i IN 1..p_price_diffs.rec_count
3435: LOOP
3436: IF (p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE) THEN
3437: l_valid_intf_diff_id_tbl.EXTEND(1);

Line 3444: PO_LOG.stmt(d_module, d_position, 'intf price diff to be inserted',

3440: p_price_diffs.intf_price_diff_id_tbl(i);
3441: END IF;
3442: END LOOP;
3443:
3444: PO_LOG.stmt(d_module, d_position, 'intf price diff to be inserted',
3445: l_valid_intf_diff_id_tbl);
3446: END IF;
3447:
3448: FORALL i IN 1..p_price_diffs.rec_count

Line 3491: IF (PO_LOG.d_proc) THEN

3487: FROM po_price_diff_interface
3488: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)
3489: AND p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
3490:
3491: IF (PO_LOG.d_proc) THEN
3492: PO_LOG.proc_end (d_module);
3493: END IF;
3494:
3495: EXCEPTION

Line 3492: PO_LOG.proc_end (d_module);

3488: WHERE price_diff_interface_id = p_price_diffs.intf_price_diff_id_tbl(i)
3489: AND p_price_diffs.error_flag_tbl(i) = FND_API.g_FALSE;
3490:
3491: IF (PO_LOG.d_proc) THEN
3492: PO_LOG.proc_end (d_module);
3493: END IF;
3494:
3495: EXCEPTION
3496: WHEN OTHERS THEN

Line 3537: IF (PO_LOG.d_proc) THEN

3533:
3534: BEGIN
3535: d_position := 0;
3536:
3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: END IF;
3540:
3541: MERGE INTO po_attribute_values_draft PAVD

Line 3538: PO_LOG.proc_begin(d_module);

3534: BEGIN
3535: d_position := 0;
3536:
3537: IF (PO_LOG.d_proc) THEN
3538: PO_LOG.proc_begin(d_module);
3539: END IF;
3540:
3541: MERGE INTO po_attribute_values_draft PAVD
3542: USING (

Line 4864: IF (PO_LOG.d_proc) THEN

4860: NVL(PAVI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
4861: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4862: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));
4863:
4864: IF (PO_LOG.d_proc) THEN
4865: PO_LOG.proc_end (d_module);
4866: END IF;
4867:
4868: EXCEPTION

Line 4865: PO_LOG.proc_end (d_module);

4861: NVL(PAVI.PROGRAM_UPDATE_DATE, sysdate),
4862: DECODE(PAVI.PICTURE, PO_PDOI_CONSTANTS.g_NULLIFY_VARCHAR, NULL, PAVI.PICTURE));
4863:
4864: IF (PO_LOG.d_proc) THEN
4865: PO_LOG.proc_end (d_module);
4866: END IF;
4867:
4868: EXCEPTION
4869: WHEN OTHERS THEN

Line 4910: IF (PO_LOG.d_proc) THEN

4906:
4907: BEGIN
4908: d_position := 0;
4909:
4910: IF (PO_LOG.d_proc) THEN
4911: PO_LOG.proc_begin(d_module);
4912: END IF;
4913:
4914: MERGE INTO po_attribute_values_tlp_draft PAVTD

Line 4911: PO_LOG.proc_begin(d_module);

4907: BEGIN
4908: d_position := 0;
4909:
4910: IF (PO_LOG.d_proc) THEN
4911: PO_LOG.proc_begin(d_module);
4912: END IF;
4913:
4914: MERGE INTO po_attribute_values_tlp_draft PAVTD
4915: USING (

Line 5625: IF (PO_LOG.d_proc) THEN

5621: NVL(PAVTI.PROGRAM_APPLICATION_ID, FND_GLOBAL.prog_appl_id),
5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5623: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5624:
5625: IF (PO_LOG.d_proc) THEN
5626: PO_LOG.proc_end (d_module);
5627: END IF;
5628:
5629: EXCEPTION

Line 5626: PO_LOG.proc_end (d_module);

5622: NVL(PAVTI.PROGRAM_ID, FND_GLOBAL.conc_program_id),
5623: NVL(PAVTI.PROGRAM_UPDATE_DATE, sysdate));
5624:
5625: IF (PO_LOG.d_proc) THEN
5626: PO_LOG.proc_end (d_module);
5627: END IF;
5628:
5629: EXCEPTION
5630: WHEN OTHERS THEN

Line 5679: IF (PO_LOG.d_proc) THEN

5675: l_record_already_exist_tbl PO_TBL_VARCHAR1 := PO_TBL_VARCHAR1();
5676: BEGIN
5677: d_position := 0;
5678:
5679: IF (PO_LOG.d_proc) THEN
5680: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
5681: PO_LOG.proc_begin(d_module, 'p_draft_id_tbl', p_draft_id_tbl);
5682: END IF;
5683:

Line 5680: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);

5676: BEGIN
5677: d_position := 0;
5678:
5679: IF (PO_LOG.d_proc) THEN
5680: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
5681: PO_LOG.proc_begin(d_module, 'p_draft_id_tbl', p_draft_id_tbl);
5682: END IF;
5683:
5684: l_key := PO_CORE_S.get_session_gt_nextval;

Line 5681: PO_LOG.proc_begin(d_module, 'p_draft_id_tbl', p_draft_id_tbl);

5677: d_position := 0;
5678:
5679: IF (PO_LOG.d_proc) THEN
5680: PO_LOG.proc_begin(d_module, 'p_po_line_id_tbl', p_po_line_id_tbl);
5681: PO_LOG.proc_begin(d_module, 'p_draft_id_tbl', p_draft_id_tbl);
5682: END IF;
5683:
5684: l_key := PO_CORE_S.get_session_gt_nextval;
5685:

Line 5940: IF (PO_LOG.d_proc) THEN

5936: PROGRAM_UPDATE_DATE = sysdate
5937: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)
5938: AND draft_id = l_draft_id_tbl(i);
5939:
5940: IF (PO_LOG.d_proc) THEN
5941: PO_LOG.proc_end (d_module);
5942: END IF;
5943:
5944: EXCEPTION

Line 5941: PO_LOG.proc_end (d_module);

5937: WHERE attribute_values_tlp_id = l_sync_attr_values_tlp_id_tbl(i)
5938: AND draft_id = l_draft_id_tbl(i);
5939:
5940: IF (PO_LOG.d_proc) THEN
5941: PO_LOG.proc_end (d_module);
5942: END IF;
5943:
5944: EXCEPTION
5945: WHEN OTHERS THEN