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

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

1: PACKAGE BODY PO_PDOI_MAINPROC_PVT AS
2: /* $Header: PO_PDOI_MAINPROC_PVT.plb 120.21.12010000.2 2008/08/04 08:39:03 rramasam ship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_MAINPROC_PVT');
6:
7: g_snap_shot_too_old EXCEPTION;
8: PRAGMA EXCEPTION_INIT(g_snap_shot_too_old, -1555);
9:

Line 83: IF (PO_LOG.d_proc) THEN

79:
80: BEGIN
81: d_position := 0;
82:
83: IF (PO_LOG.d_proc) THEN
84: PO_LOG.proc_begin(d_module, 'start main process for header group',
85: PO_PDOI_PARAMS.g_current_round_num);
86: END IF;
87:

Line 84: PO_LOG.proc_begin(d_module, 'start main process for header group',

80: BEGIN
81: d_position := 0;
82:
83: IF (PO_LOG.d_proc) THEN
84: PO_LOG.proc_begin(d_module, 'start main process for header group',
85: PO_PDOI_PARAMS.g_current_round_num);
86: END IF;
87:
88: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);

Line 132: IF (PO_LOG.d_stmt) THEN

128: IF (PO_PDOI_PARAMS.g_request.calling_module =
129: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
134: PO_PDOI_PARAMS.g_request.interface_header_id);
135: END IF;
136:

Line 133: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',

129: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
130: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
131: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
132: IF (PO_LOG.d_stmt) THEN
133: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
134: PO_PDOI_PARAMS.g_request.interface_header_id);
135: END IF;
136:
137: PO_PDOI_UTL.reject_unprocessed_intf

Line 145: IF (PO_LOG.d_proc) THEN

141: END IF;
142:
143: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);
144:
145: IF (PO_LOG.d_proc) THEN
146: PO_LOG.proc_end(d_module);
147: END IF;
148:
149: EXCEPTION

Line 146: PO_LOG.proc_end(d_module);

142:
143: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);
144:
145: IF (PO_LOG.d_proc) THEN
146: PO_LOG.proc_end(d_module);
147: END IF;
148:
149: EXCEPTION
150: WHEN OTHERS THEN

Line 205: IF (PO_LOG.d_proc) THEN

201:
202: BEGIN
203: d_position := 0;
204:
205: IF (PO_LOG.d_proc) THEN
206: PO_LOG.proc_begin(d_module);
207: END IF;
208:
209: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);

Line 206: PO_LOG.proc_begin(d_module);

202: BEGIN
203: d_position := 0;
204:
205: IF (PO_LOG.d_proc) THEN
206: PO_LOG.proc_begin(d_module);
207: END IF;
208:
209: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);
210:

Line 235: IF (PO_LOG.d_stmt) THEN

231:
232: -- number of records read in current batch
233: l_headers.rec_count := l_headers.intf_header_id_tbl.COUNT;
234:
235: IF (PO_LOG.d_stmt) THEN
236: PO_LOG.stmt(d_module, d_position, 'header count within batch',
237: l_headers.rec_count);
238: END IF;
239:

Line 236: PO_LOG.stmt(d_module, d_position, 'header count within batch',

232: -- number of records read in current batch
233: l_headers.rec_count := l_headers.intf_header_id_tbl.COUNT;
234:
235: IF (PO_LOG.d_stmt) THEN
236: PO_LOG.stmt(d_module, d_position, 'header count within batch',
237: l_headers.rec_count);
238: END IF;
239:
240: EXIT WHEN l_headers.rec_count = 0;

Line 287: IF (PO_LOG.d_stmt) THEN

283: l_rej_intf_header_id_tbl.EXTEND(l_headers.rec_count);
284: FOR i IN 1..l_headers.rec_count
285: LOOP
286: IF (l_headers.error_flag_tbl(i) = FND_API.g_TRUE) THEN
287: IF (PO_LOG.d_stmt) THEN
288: PO_LOG.stmt(d_module, d_position, 'rejected intf header id',
289: l_headers.intf_header_id_tbl(i));
290: END IF;
291:

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

284: FOR i IN 1..l_headers.rec_count
285: LOOP
286: IF (l_headers.error_flag_tbl(i) = FND_API.g_TRUE) THEN
287: IF (PO_LOG.d_stmt) THEN
288: PO_LOG.stmt(d_module, d_position, 'rejected intf header id',
289: l_headers.intf_header_id_tbl(i));
290: END IF;
291:
292: l_count := l_count + 1;

Line 349: IF (PO_LOG.d_proc) THEN

345: END IF;
346:
347: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);
348:
349: IF (PO_LOG.d_proc) THEN
350: PO_LOG.proc_end(d_module);
351: END IF;
352:
353: EXCEPTION

Line 350: PO_LOG.proc_end(d_module);

346:
347: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);
348:
349: IF (PO_LOG.d_proc) THEN
350: PO_LOG.proc_end(d_module);
351: END IF;
352:
353: EXCEPTION
354: WHEN OTHERS THEN

Line 407: IF (PO_LOG.d_proc) THEN

403:
404: BEGIN
405: d_position := 0;
406:
407: IF (PO_LOG.d_proc) THEN
408: PO_LOG.proc_begin(d_module);
409: END IF;
410:
411: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);

Line 408: PO_LOG.proc_begin(d_module);

404: BEGIN
405: d_position := 0;
406:
407: IF (PO_LOG.d_proc) THEN
408: PO_LOG.proc_begin(d_module);
409: END IF;
410:
411: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
412:

Line 471: IF (PO_LOG.d_proc) THEN

467: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
468:
469: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
470:
471: IF (PO_LOG.d_proc) THEN
472: PO_LOG.proc_end(d_module);
473: END IF;
474:
475: EXCEPTION

Line 472: PO_LOG.proc_end(d_module);

468:
469: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
470:
471: IF (PO_LOG.d_proc) THEN
472: PO_LOG.proc_end(d_module);
473: END IF;
474:
475: EXCEPTION
476: WHEN OTHERS THEN

Line 531: IF (PO_LOG.d_proc) THEN

527:
528: BEGIN
529: d_position := 0;
530:
531: IF (PO_LOG.d_proc) THEN
532: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
533: END IF;
534:
535: /*

Line 532: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);

528: BEGIN
529: d_position := 0;
530:
531: IF (PO_LOG.d_proc) THEN
532: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
533: END IF;
534:
535: /*
536: -- code added for debugging purpose

Line 550: IF (PO_LOG.d_stmt) THEN

546: IF (PO_PDOI_PARAMS.g_request.calling_module =
547: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
548: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
550: IF (PO_LOG.d_stmt) THEN
551: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
552: ' error threshold is hit for header ',
553: PO_PDOI_PARAMS.g_request.interface_header_id);
554: END IF;

Line 551: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||

547: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
548: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
549: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
550: IF (PO_LOG.d_stmt) THEN
551: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
552: ' error threshold is hit for header ',
553: PO_PDOI_PARAMS.g_request.interface_header_id);
554: END IF;
555:

Line 580: IF (PO_LOG.d_stmt) THEN

576: IF (PO_PDOI_PARAMS.g_request.calling_module =
577: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
582: PO_PDOI_PARAMS.g_request.interface_header_id);
583: END IF;
584:

Line 581: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

577: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
578: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
579: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
580: IF (PO_LOG.d_stmt) THEN
581: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
582: PO_PDOI_PARAMS.g_request.interface_header_id);
583: END IF;
584:
585: -- no need to process remaining lines if error threshold is reached

Line 602: IF (PO_LOG.d_stmt) THEN

598:
599: -- number of records read in current batch
600: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
601:
602: IF (PO_LOG.d_stmt) THEN
603: PO_LOG.stmt(d_module, d_position, 'line count in batch',
604: l_lines.rec_count);
605: END IF;
606:

Line 603: PO_LOG.stmt(d_module, d_position, 'line count in batch',

599: -- number of records read in current batch
600: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
601:
602: IF (PO_LOG.d_stmt) THEN
603: PO_LOG.stmt(d_module, d_position, 'line count in batch',
604: l_lines.rec_count);
605: END IF;
606:
607: EXIT WHEN l_lines.rec_count = 0;

Line 668: IF (PO_LOG.d_stmt) THEN

664: d_position := 70;
665:
666: -- create items if necessary
667: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
668: IF (PO_LOG.d_stmt) THEN
669: PO_LOG.stmt(d_module, d_position, 'create items for lines');
670: END IF;
671:
672: PO_PDOI_ITEM_PROCESS_PVT.create_items

Line 669: PO_LOG.stmt(d_module, d_position, 'create items for lines');

665:
666: -- create items if necessary
667: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
668: IF (PO_LOG.d_stmt) THEN
669: PO_LOG.stmt(d_module, d_position, 'create items for lines');
670: END IF;
671:
672: PO_PDOI_ITEM_PROCESS_PVT.create_items
673: (

Line 701: IF (PO_LOG.d_stmt) THEN

697: FOR i IN 1..l_lines.rec_count
698: LOOP
699: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
700: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
701: IF (PO_LOG.d_stmt) THEN
702: PO_LOG.stmt(d_module, d_position, 'error flag',
703: l_lines.error_flag_tbl(i));
704: PO_LOG.stmt(d_module, d_position, 'reject flag',
705: l_lines.need_to_reject_flag_tbl(i));

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

698: LOOP
699: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
700: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
701: IF (PO_LOG.d_stmt) THEN
702: PO_LOG.stmt(d_module, d_position, 'error flag',
703: l_lines.error_flag_tbl(i));
704: PO_LOG.stmt(d_module, d_position, 'reject flag',
705: l_lines.need_to_reject_flag_tbl(i));
706: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

Line 704: PO_LOG.stmt(d_module, d_position, 'reject flag',

700: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
701: IF (PO_LOG.d_stmt) THEN
702: PO_LOG.stmt(d_module, d_position, 'error flag',
703: l_lines.error_flag_tbl(i));
704: PO_LOG.stmt(d_module, d_position, 'reject flag',
705: l_lines.need_to_reject_flag_tbl(i));
706: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
707: l_lines.intf_line_id_tbl(i));
708: END IF;

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

702: PO_LOG.stmt(d_module, d_position, 'error flag',
703: l_lines.error_flag_tbl(i));
704: PO_LOG.stmt(d_module, d_position, 'reject flag',
705: l_lines.need_to_reject_flag_tbl(i));
706: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
707: l_lines.intf_line_id_tbl(i));
708: END IF;
709:
710: l_rej_intf_line_id_tbl.EXTEND;

Line 806: IF (PO_LOG.d_proc) THEN

802: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
803: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
804: AND NVL(intf_line2.price_break_flag, 'N') = 'N');
805:
806: IF (PO_LOG.d_proc) THEN
807: PO_LOG.proc_end(d_module);
808: END IF;
809:
810: EXCEPTION

Line 807: PO_LOG.proc_end(d_module);

803: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
804: AND NVL(intf_line2.price_break_flag, 'N') = 'N');
805:
806: IF (PO_LOG.d_proc) THEN
807: PO_LOG.proc_end(d_module);
808: END IF;
809:
810: EXCEPTION
811: WHEN OTHERS THEN

Line 887: IF (PO_LOG.d_proc) THEN

883:
884: BEGIN
885: d_position := 0;
886:
887: IF (PO_LOG.d_proc) THEN
888: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
889: END IF;
890:
891: -- Bug 5215781:

Line 888: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);

884: BEGIN
885: d_position := 0;
886:
887: IF (PO_LOG.d_proc) THEN
888: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
889: END IF;
890:
891: -- Bug 5215781:
892: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 897: IF (PO_LOG.d_stmt) THEN

893: IF (PO_PDOI_PARAMS.g_request.calling_module =
894: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
895: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
897: IF (PO_LOG.d_stmt) THEN
898: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
899: ' error threshold is hit for header ',
900: PO_PDOI_PARAMS.g_request.interface_header_id);
901: END IF;

Line 898: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||

894: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
895: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
896: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
897: IF (PO_LOG.d_stmt) THEN
898: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
899: ' error threshold is hit for header ',
900: PO_PDOI_PARAMS.g_request.interface_header_id);
901: END IF;
902:

Line 929: IF (PO_LOG.d_stmt) THEN

925: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
926: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
927: d_position := 20;
928:
929: IF (PO_LOG.d_stmt) THEN
930: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
931: PO_PDOI_PARAMS.g_request.interface_header_id);
932: END IF;
933:

Line 930: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

926: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
927: d_position := 20;
928:
929: IF (PO_LOG.d_stmt) THEN
930: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
931: PO_PDOI_PARAMS.g_request.interface_header_id);
932: END IF;
933:
934: EXIT;

Line 950: IF (PO_LOG.d_stmt) THEN

946:
947: -- number of records read in current batch
948: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
949:
950: IF (PO_LOG.d_stmt) THEN
951: PO_LOG.stmt(d_module, d_position, 'line count in batch',
952: l_lines.rec_count);
953: END IF;
954:

Line 951: PO_LOG.stmt(d_module, d_position, 'line count in batch',

947: -- number of records read in current batch
948: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
949:
950: IF (PO_LOG.d_stmt) THEN
951: PO_LOG.stmt(d_module, d_position, 'line count in batch',
952: l_lines.rec_count);
953: END IF;
954:
955: EXIT WHEN l_lines.rec_count = 0;

Line 1008: IF (PO_LOG.d_stmt) THEN

1004: -- exit when all rows are processed
1005: IF (l_processing_row_tbl.COUNT = 0) THEN
1006: d_position := 60;
1007:
1008: IF (PO_LOG.d_stmt) THEN
1009: PO_LOG.stmt(d_module, d_position, 'exit after all lines are processed');
1010: END IF;
1011:
1012: EXIT;

Line 1009: PO_LOG.stmt(d_module, d_position, 'exit after all lines are processed');

1005: IF (l_processing_row_tbl.COUNT = 0) THEN
1006: d_position := 60;
1007:
1008: IF (PO_LOG.d_stmt) THEN
1009: PO_LOG.stmt(d_module, d_position, 'exit after all lines are processed');
1010: END IF;
1011:
1012: EXIT;
1013: END IF;

Line 1018: IF (PO_LOG.d_stmt) THEN

1014:
1015: -- increment group number
1016: l_group_num := l_group_num + 1;
1017:
1018: IF (PO_LOG.d_stmt) THEN
1019: PO_LOG.stmt(d_module, d_position, 'group_num', l_group_num);
1020: END IF;
1021:
1022: -- perform uniqueness check on all the records and

Line 1019: PO_LOG.stmt(d_module, d_position, 'group_num', l_group_num);

1015: -- increment group number
1016: l_group_num := l_group_num + 1;
1017:
1018: IF (PO_LOG.d_stmt) THEN
1019: PO_LOG.stmt(d_module, d_position, 'group_num', l_group_num);
1020: END IF;
1021:
1022: -- perform uniqueness check on all the records and
1023: -- mark the group number on the records that can be processed

Line 1170: IF (PO_LOG.d_proc) THEN

1166: WHERE interface_line_id = l_notified_intf_line_id_tbl(i);
1167:
1168: d_position := 160;
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_end(d_module);
1172: END IF;
1173:
1174: EXCEPTION

Line 1171: PO_LOG.proc_end(d_module);

1167:
1168: d_position := 160;
1169:
1170: IF (PO_LOG.d_proc) THEN
1171: PO_LOG.proc_end(d_module);
1172: END IF;
1173:
1174: EXCEPTION
1175: WHEN OTHERS THEN

Line 1224: IF (PO_LOG.d_proc) THEN

1220:
1221: BEGIN
1222: d_position := 0;
1223:
1224: IF (PO_LOG.d_proc) THEN
1225: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1226: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1227: END IF;
1228:

Line 1225: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);

1221: BEGIN
1222: d_position := 0;
1223:
1224: IF (PO_LOG.d_proc) THEN
1225: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1226: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1227: END IF;
1228:
1229: -- return if there is no line to be processed

Line 1226: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);

1222: d_position := 0;
1223:
1224: IF (PO_LOG.d_proc) THEN
1225: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1226: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1227: END IF;
1228:
1229: -- return if there is no line to be processed
1230: IF (x_lines.rec_count = 0) THEN

Line 1231: IF (PO_LOG.d_proc) THEN

1227: END IF;
1228:
1229: -- return if there is no line to be processed
1230: IF (x_lines.rec_count = 0) THEN
1231: IF (PO_LOG.d_proc) THEN
1232: PO_LOG.proc_end(d_module);
1233: END IF;
1234:
1235: RETURN;

Line 1232: PO_LOG.proc_end(d_module);

1228:
1229: -- return if there is no line to be processed
1230: IF (x_lines.rec_count = 0) THEN
1231: IF (PO_LOG.d_proc) THEN
1232: PO_LOG.proc_end(d_module);
1233: END IF;
1234:
1235: RETURN;
1236: END IF;

Line 1272: IF (PO_LOG.d_stmt) THEN

1268: d_position := 40;
1269:
1270: -- create items if necessary
1271: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
1272: IF (PO_LOG.d_stmt) THEN
1273: PO_LOG.stmt(d_module, d_position, 'create items from line info');
1274: END IF;
1275:
1276: PO_PDOI_ITEM_PROCESS_PVT.create_items

Line 1273: PO_LOG.stmt(d_module, d_position, 'create items from line info');

1269:
1270: -- create items if necessary
1271: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
1272: IF (PO_LOG.d_stmt) THEN
1273: PO_LOG.stmt(d_module, d_position, 'create items from line info');
1274: END IF;
1275:
1276: PO_PDOI_ITEM_PROCESS_PVT.create_items
1277: (

Line 1306: IF (PO_LOG.d_stmt) THEN

1302: FOR i IN 1..x_lines.rec_count
1303: LOOP
1304: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1305: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1306: IF (PO_LOG.d_stmt) THEN
1307: PO_LOG.stmt(d_module, d_position, 'error flag',
1308: x_lines.error_flag_tbl(i));
1309: PO_LOG.stmt(d_module, d_position, 'reject flag',
1310: x_lines.need_to_reject_flag_tbl(i));

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

1303: LOOP
1304: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1305: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1306: IF (PO_LOG.d_stmt) THEN
1307: PO_LOG.stmt(d_module, d_position, 'error flag',
1308: x_lines.error_flag_tbl(i));
1309: PO_LOG.stmt(d_module, d_position, 'reject flag',
1310: x_lines.need_to_reject_flag_tbl(i));
1311: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

Line 1309: PO_LOG.stmt(d_module, d_position, 'reject flag',

1305: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1306: IF (PO_LOG.d_stmt) THEN
1307: PO_LOG.stmt(d_module, d_position, 'error flag',
1308: x_lines.error_flag_tbl(i));
1309: PO_LOG.stmt(d_module, d_position, 'reject flag',
1310: x_lines.need_to_reject_flag_tbl(i));
1311: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1312: x_lines.intf_line_id_tbl(i));
1313: END IF;

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

1307: PO_LOG.stmt(d_module, d_position, 'error flag',
1308: x_lines.error_flag_tbl(i));
1309: PO_LOG.stmt(d_module, d_position, 'reject flag',
1310: x_lines.need_to_reject_flag_tbl(i));
1311: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1312: x_lines.intf_line_id_tbl(i));
1313: END IF;
1314:
1315: l_count := l_count + 1;

Line 1336: IF (PO_LOG.d_proc) THEN

1332: UPDATE po_lines_all
1333: SET expiration_date = TRUNC(sysdate - 1)
1334: WHERE po_line_id = p_expire_line_id_tbl(i);
1335:
1336: IF (PO_LOG.d_proc) THEN
1337: PO_LOG.proc_end(d_module);
1338: END IF;
1339:
1340: EXCEPTION

Line 1337: PO_LOG.proc_end(d_module);

1333: SET expiration_date = TRUNC(sysdate - 1)
1334: WHERE po_line_id = p_expire_line_id_tbl(i);
1335:
1336: IF (PO_LOG.d_proc) THEN
1337: PO_LOG.proc_end(d_module);
1338: END IF;
1339:
1340: EXCEPTION
1341: WHEN OTHERS THEN

Line 1386: IF (PO_LOG.d_proc) THEN

1382:
1383: BEGIN
1384: d_position := 0;
1385:
1386: IF (PO_LOG.d_proc) THEN
1387: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1388: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1389: END IF;
1390:

Line 1387: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);

1383: BEGIN
1384: d_position := 0;
1385:
1386: IF (PO_LOG.d_proc) THEN
1387: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1388: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1389: END IF;
1390:
1391: -- return if there is no line to be processed

Line 1388: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);

1384: d_position := 0;
1385:
1386: IF (PO_LOG.d_proc) THEN
1387: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1388: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1389: END IF;
1390:
1391: -- return if there is no line to be processed
1392: IF (x_lines.rec_count = 0) THEN

Line 1393: IF (PO_LOG.d_proc) THEN

1389: END IF;
1390:
1391: -- return if there is no line to be processed
1392: IF (x_lines.rec_count = 0) THEN
1393: IF (PO_LOG.d_proc) THEN
1394: PO_LOG.proc_end(d_module);
1395: END IF;
1396:
1397: RETURN;

Line 1394: PO_LOG.proc_end(d_module);

1390:
1391: -- return if there is no line to be processed
1392: IF (x_lines.rec_count = 0) THEN
1393: IF (PO_LOG.d_proc) THEN
1394: PO_LOG.proc_end(d_module);
1395: END IF;
1396:
1397: RETURN;
1398: END IF;

Line 1451: IF (PO_LOG.d_stmt) THEN

1447: FOR i IN 1..x_lines.rec_count
1448: LOOP
1449: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1450: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1451: IF (PO_LOG.d_stmt) THEN
1452: PO_LOG.stmt(d_module, d_position, 'error flag',
1453: x_lines.error_flag_tbl(i));
1454: PO_LOG.stmt(d_module, d_position, 'reject flag',
1455: x_lines.need_to_reject_flag_tbl(i));

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

1448: LOOP
1449: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1450: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1451: IF (PO_LOG.d_stmt) THEN
1452: PO_LOG.stmt(d_module, d_position, 'error flag',
1453: x_lines.error_flag_tbl(i));
1454: PO_LOG.stmt(d_module, d_position, 'reject flag',
1455: x_lines.need_to_reject_flag_tbl(i));
1456: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

Line 1454: PO_LOG.stmt(d_module, d_position, 'reject flag',

1450: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1451: IF (PO_LOG.d_stmt) THEN
1452: PO_LOG.stmt(d_module, d_position, 'error flag',
1453: x_lines.error_flag_tbl(i));
1454: PO_LOG.stmt(d_module, d_position, 'reject flag',
1455: x_lines.need_to_reject_flag_tbl(i));
1456: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1457: x_lines.intf_line_id_tbl(i));
1458: END IF;

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

1452: PO_LOG.stmt(d_module, d_position, 'error flag',
1453: x_lines.error_flag_tbl(i));
1454: PO_LOG.stmt(d_module, d_position, 'reject flag',
1455: x_lines.need_to_reject_flag_tbl(i));
1456: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1457: x_lines.intf_line_id_tbl(i));
1458: END IF;
1459:
1460: l_count := l_count + 1;

Line 1472: IF (PO_LOG.d_proc) THEN

1468: p_cascade => FND_API.g_TRUE
1469: );
1470: l_rej_intf_line_id_tbl.DELETE;
1471:
1472: IF (PO_LOG.d_proc) THEN
1473: PO_LOG.proc_end(d_module);
1474: END IF;
1475:
1476: EXCEPTION

Line 1473: PO_LOG.proc_end(d_module);

1469: );
1470: l_rej_intf_line_id_tbl.DELETE;
1471:
1472: IF (PO_LOG.d_proc) THEN
1473: PO_LOG.proc_end(d_module);
1474: END IF;
1475:
1476: EXCEPTION
1477: WHEN OTHERS THEN

Line 1534: IF (PO_LOG.d_proc) THEN

1530: l_count NUMBER;
1531: BEGIN
1532: d_position := 0;
1533:
1534: IF (PO_LOG.d_proc) THEN
1535: PO_LOG.proc_begin(d_module);
1536: END IF;
1537:
1538: -- Bug 5215781:

Line 1535: PO_LOG.proc_begin(d_module);

1531: BEGIN
1532: d_position := 0;
1533:
1534: IF (PO_LOG.d_proc) THEN
1535: PO_LOG.proc_begin(d_module);
1536: END IF;
1537:
1538: -- Bug 5215781:
1539: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 1544: IF (PO_LOG.d_stmt) THEN

1540: IF (PO_PDOI_PARAMS.g_request.calling_module =
1541: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1542: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1546: ' error threshold is hit for header ',
1547: PO_PDOI_PARAMS.g_request.interface_header_id);
1548: END IF;

Line 1545: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||

1541: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1542: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1543: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1544: IF (PO_LOG.d_stmt) THEN
1545: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1546: ' error threshold is hit for header ',
1547: PO_PDOI_PARAMS.g_request.interface_header_id);
1548: END IF;
1549:

Line 1577: IF (PO_LOG.d_stmt) THEN

1573: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1574: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1575: d_position := 20;
1576:
1577: IF (PO_LOG.d_stmt) THEN
1578: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1579: PO_PDOI_PARAMS.g_request.interface_header_id);
1580: END IF;
1581:

Line 1578: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

1574: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1575: d_position := 20;
1576:
1577: IF (PO_LOG.d_stmt) THEN
1578: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1579: PO_PDOI_PARAMS.g_request.interface_header_id);
1580: END IF;
1581:
1582: EXIT;

Line 1598: IF (PO_LOG.d_stmt) THEN

1594:
1595: -- number of records read in current batch
1596: l_line_locs.rec_count := l_line_locs.intf_line_loc_id_tbl.COUNT;
1597:
1598: IF (PO_LOG.d_stmt) THEN
1599: PO_LOG.stmt(d_module, d_position, 'loc count in batch',
1600: l_line_locs.rec_count);
1601: END IF;
1602:

Line 1599: PO_LOG.stmt(d_module, d_position, 'loc count in batch',

1595: -- number of records read in current batch
1596: l_line_locs.rec_count := l_line_locs.intf_line_loc_id_tbl.COUNT;
1597:
1598: IF (PO_LOG.d_stmt) THEN
1599: PO_LOG.stmt(d_module, d_position, 'loc count in batch',
1600: l_line_locs.rec_count);
1601: END IF;
1602:
1603: EXIT WHEN l_line_locs.rec_count = 0;

Line 1705: IF (PO_LOG.d_stmt) THEN

1701: */
1702: END IF;
1703: END LOOP;
1704:
1705: IF (PO_LOG.d_stmt) THEN
1706: PO_LOG.stmt(d_module, d_position, 'to-be-rejected locs',
1707: l_rej_intf_line_loc_id_tbl);
1708: END IF;
1709:

Line 1706: PO_LOG.stmt(d_module, d_position, 'to-be-rejected locs',

1702: END IF;
1703: END LOOP;
1704:
1705: IF (PO_LOG.d_stmt) THEN
1706: PO_LOG.stmt(d_module, d_position, 'to-be-rejected locs',
1707: l_rej_intf_line_loc_id_tbl);
1708: END IF;
1709:
1710: PO_PDOI_UTL.reject_line_locations_intf

Line 1805: IF (PO_LOG.d_proc) THEN

1801: END IF;
1802:
1803: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_PROCESS);
1804:
1805: IF (PO_LOG.d_proc) THEN
1806: PO_LOG.proc_end(d_module);
1807: END IF;
1808:
1809: EXCEPTION

Line 1806: PO_LOG.proc_end(d_module);

1802:
1803: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_PROCESS);
1804:
1805: IF (PO_LOG.d_proc) THEN
1806: PO_LOG.proc_end(d_module);
1807: END IF;
1808:
1809: EXCEPTION
1810: WHEN OTHERS THEN

Line 1860: IF (PO_LOG.d_proc) THEN

1856:
1857: BEGIN
1858: d_position := 0;
1859:
1860: IF (PO_LOG.d_proc) THEN
1861: PO_LOG.proc_begin(d_module);
1862: END IF;
1863:
1864: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);

Line 1861: PO_LOG.proc_begin(d_module);

1857: BEGIN
1858: d_position := 0;
1859:
1860: IF (PO_LOG.d_proc) THEN
1861: PO_LOG.proc_begin(d_module);
1862: END IF;
1863:
1864: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);
1865:

Line 1890: IF (PO_LOG.d_stmt) THEN

1886:
1887: -- number of records read in current batch
1888: l_dists.rec_count := l_dists.intf_dist_id_tbl.COUNT;
1889:
1890: IF (PO_LOG.d_stmt) THEN
1891: PO_LOG.stmt(d_module, d_position, 'dist count in batch',
1892: l_dists.rec_count);
1893: END IF;
1894:

Line 1891: PO_LOG.stmt(d_module, d_position, 'dist count in batch',

1887: -- number of records read in current batch
1888: l_dists.rec_count := l_dists.intf_dist_id_tbl.COUNT;
1889:
1890: IF (PO_LOG.d_stmt) THEN
1891: PO_LOG.stmt(d_module, d_position, 'dist count in batch',
1892: l_dists.rec_count);
1893: END IF;
1894:
1895: EXIT WHEN l_dists.rec_count = 0;

Line 1961: IF (PO_LOG.d_stmt) THEN

1957: l_rej_intf_dist_id_tbl(l_rej_intf_dist_id_tbl.COUNT) := l_dists.intf_dist_id_tbl(i);
1958: END IF;
1959: END LOOP;
1960:
1961: IF (PO_LOG.d_stmt) THEN
1962: PO_LOG.stmt(d_module, d_position, 'to-be-rejected dists',
1963: l_rej_intf_dist_id_tbl);
1964: END IF;
1965:

Line 1962: PO_LOG.stmt(d_module, d_position, 'to-be-rejected dists',

1958: END IF;
1959: END LOOP;
1960:
1961: IF (PO_LOG.d_stmt) THEN
1962: PO_LOG.stmt(d_module, d_position, 'to-be-rejected dists',
1963: l_rej_intf_dist_id_tbl);
1964: END IF;
1965:
1966: d_position := 90;

Line 2027: IF (PO_LOG.d_proc) THEN

2023: END IF;
2024:
2025: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);
2026:
2027: IF (PO_LOG.d_proc) THEN
2028: PO_LOG.proc_end(d_module);
2029: END IF;
2030:
2031: EXCEPTION

Line 2028: PO_LOG.proc_end(d_module);

2024:
2025: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);
2026:
2027: IF (PO_LOG.d_proc) THEN
2028: PO_LOG.proc_end(d_module);
2029: END IF;
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN

Line 2082: IF (PO_LOG.d_proc) THEN

2078:
2079: BEGIN
2080: d_position := 0;
2081:
2082: IF (PO_LOG.d_proc) THEN
2083: PO_LOG.proc_begin(d_module);
2084: END IF;
2085:
2086: -- Bug 5215781:

Line 2083: PO_LOG.proc_begin(d_module);

2079: BEGIN
2080: d_position := 0;
2081:
2082: IF (PO_LOG.d_proc) THEN
2083: PO_LOG.proc_begin(d_module);
2084: END IF;
2085:
2086: -- Bug 5215781:
2087: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 2092: IF (PO_LOG.d_stmt) THEN

2088: IF (PO_PDOI_PARAMS.g_request.calling_module =
2089: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2090: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2092: IF (PO_LOG.d_stmt) THEN
2093: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2094: ' error threshold is hit for header ',
2095: PO_PDOI_PARAMS.g_request.interface_header_id);
2096: END IF;

Line 2093: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||

2089: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2090: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2091: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2092: IF (PO_LOG.d_stmt) THEN
2093: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2094: ' error threshold is hit for header ',
2095: PO_PDOI_PARAMS.g_request.interface_header_id);
2096: END IF;
2097:

Line 2125: IF (PO_LOG.d_stmt) THEN

2121: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2122: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2123: d_position := 20;
2124:
2125: IF (PO_LOG.d_stmt) THEN
2126: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2127: PO_PDOI_PARAMS.g_request.interface_header_id);
2128: END IF;
2129:

Line 2126: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',

2122: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2123: d_position := 20;
2124:
2125: IF (PO_LOG.d_stmt) THEN
2126: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2127: PO_PDOI_PARAMS.g_request.interface_header_id);
2128: END IF;
2129:
2130: EXIT;

Line 2146: IF (PO_LOG.d_stmt) THEN

2142:
2143: -- number of records read in current batch
2144: l_price_diffs.rec_count := l_price_diffs.intf_price_diff_id_tbl.COUNT;
2145:
2146: IF (PO_LOG.d_stmt) THEN
2147: PO_LOG.stmt(d_module, d_position, 'price diffs in batch',
2148: l_price_diffs.rec_count);
2149: END IF;
2150:

Line 2147: PO_LOG.stmt(d_module, d_position, 'price diffs in batch',

2143: -- number of records read in current batch
2144: l_price_diffs.rec_count := l_price_diffs.intf_price_diff_id_tbl.COUNT;
2145:
2146: IF (PO_LOG.d_stmt) THEN
2147: PO_LOG.stmt(d_module, d_position, 'price diffs in batch',
2148: l_price_diffs.rec_count);
2149: END IF;
2150:
2151: EXIT WHEN l_price_diffs.rec_count = 0;

Line 2185: IF (PO_LOG.d_stmt) THEN

2181: l_rej_intf_price_diff_id_tbl(l_rej_intf_price_diff_id_tbl.COUNT) := l_price_diffs.intf_price_diff_id_tbl(i);
2182: END IF;
2183: END LOOP;
2184:
2185: IF (PO_LOG.d_stmt) THEN
2186: PO_LOG.stmt(d_module, d_position, 'to-be-rejected price diffs',
2187: l_rej_intf_price_diff_id_tbl);
2188: END IF;
2189:

Line 2186: PO_LOG.stmt(d_module, d_position, 'to-be-rejected price diffs',

2182: END IF;
2183: END LOOP;
2184:
2185: IF (PO_LOG.d_stmt) THEN
2186: PO_LOG.stmt(d_module, d_position, 'to-be-rejected price diffs',
2187: l_rej_intf_price_diff_id_tbl);
2188: END IF;
2189:
2190: PO_PDOI_UTL.reject_price_diff_intf

Line 2247: IF (PO_LOG.d_proc) THEN

2243: END IF;
2244:
2245: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_PROCESS);
2246:
2247: IF (PO_LOG.d_proc) THEN
2248: PO_LOG.proc_end(d_module);
2249: END IF;
2250:
2251: EXCEPTION

Line 2248: PO_LOG.proc_end(d_module);

2244:
2245: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_PROCESS);
2246:
2247: IF (PO_LOG.d_proc) THEN
2248: PO_LOG.proc_end(d_module);
2249: END IF;
2250:
2251: EXCEPTION
2252: WHEN OTHERS THEN

Line 2290: IF (PO_LOG.d_proc) THEN

2286:
2287: BEGIN
2288: d_position := 0;
2289:
2290: IF (PO_LOG.d_proc) THEN
2291: PO_LOG.proc_begin(d_module);
2292: END IF;
2293:
2294: -- Bug 5215781:

Line 2291: PO_LOG.proc_begin(d_module);

2287: BEGIN
2288: d_position := 0;
2289:
2290: IF (PO_LOG.d_proc) THEN
2291: PO_LOG.proc_begin(d_module);
2292: END IF;
2293:
2294: -- Bug 5215781:
2295: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 2300: IF (PO_LOG.d_stmt) THEN

2296: IF (PO_PDOI_PARAMS.g_request.calling_module =
2297: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2298: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2300: IF (PO_LOG.d_stmt) THEN
2301: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2302: ' error threshold is hit for header ',
2303: PO_PDOI_PARAMS.g_request.interface_header_id);
2304: END IF;

Line 2301: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||

2297: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2298: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2299: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2300: IF (PO_LOG.d_stmt) THEN
2301: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2302: ' error threshold is hit for header ',
2303: PO_PDOI_PARAMS.g_request.interface_header_id);
2304: END IF;
2305:

Line 2330: IF (PO_LOG.d_proc) THEN

2326: d_position := 40;
2327:
2328: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_PROCESS);
2329:
2330: IF (PO_LOG.d_proc) THEN
2331: PO_LOG.proc_end(d_module);
2332: END IF;
2333:
2334: EXCEPTION

Line 2331: PO_LOG.proc_end(d_module);

2327:
2328: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_PROCESS);
2329:
2330: IF (PO_LOG.d_proc) THEN
2331: PO_LOG.proc_end(d_module);
2332: END IF;
2333:
2334: EXCEPTION
2335: WHEN OTHERS THEN

Line 2395: IF (PO_LOG.d_proc) THEN

2391:
2392: BEGIN
2393: d_position := 0;
2394:
2395: IF (PO_LOG.d_proc) THEN
2396: PO_LOG.proc_begin(d_module);
2397: END IF;
2398:
2399: -- open cursor for query to retrieve attr value records

Line 2396: PO_LOG.proc_begin(d_module);

2392: BEGIN
2393: d_position := 0;
2394:
2395: IF (PO_LOG.d_proc) THEN
2396: PO_LOG.proc_begin(d_module);
2397: END IF;
2398:
2399: -- open cursor for query to retrieve attr value records
2400: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values

Line 2423: IF (PO_LOG.d_stmt) THEN

2419:
2420: -- number of records read in current batch
2421: l_attr_values.rec_count := l_attr_values.intf_attr_values_id_tbl.COUNT;
2422:
2423: IF (PO_LOG.d_stmt) THEN
2424: PO_LOG.stmt(d_module, d_position, 'attr values in batch',
2425: l_attr_values.rec_count);
2426: END IF;
2427:

Line 2424: PO_LOG.stmt(d_module, d_position, 'attr values in batch',

2420: -- number of records read in current batch
2421: l_attr_values.rec_count := l_attr_values.intf_attr_values_id_tbl.COUNT;
2422:
2423: IF (PO_LOG.d_stmt) THEN
2424: PO_LOG.stmt(d_module, d_position, 'attr values in batch',
2425: l_attr_values.rec_count);
2426: END IF;
2427:
2428: EXIT WHEN l_attr_values.rec_count = 0;

Line 2448: IF (PO_LOG.d_stmt) THEN

2444: d_position := 30;
2445:
2446: -- exit when all rows are processed
2447: IF (l_processing_row_tbl.COUNT = 0) THEN
2448: IF (PO_LOG.d_stmt) THEN
2449: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2450: END IF;
2451:
2452: EXIT;

Line 2449: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');

2445:
2446: -- exit when all rows are processed
2447: IF (l_processing_row_tbl.COUNT = 0) THEN
2448: IF (PO_LOG.d_stmt) THEN
2449: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2450: END IF;
2451:
2452: EXIT;
2453: END IF;

Line 2525: IF (PO_LOG.d_proc) THEN

2521: IF (l_attr_values_csr%ISOPEN) THEN
2522: CLOSE l_attr_values_csr;
2523: END IF;
2524:
2525: IF (PO_LOG.d_proc) THEN
2526: PO_LOG.proc_end(d_module);
2527: END IF;
2528:
2529: EXCEPTION

Line 2526: PO_LOG.proc_end(d_module);

2522: CLOSE l_attr_values_csr;
2523: END IF;
2524:
2525: IF (PO_LOG.d_proc) THEN
2526: PO_LOG.proc_end(d_module);
2527: END IF;
2528:
2529: EXCEPTION
2530: WHEN OTHERS THEN

Line 2586: IF (PO_LOG.d_proc) THEN

2582:
2583: BEGIN
2584: d_position := 0;
2585:
2586: IF (PO_LOG.d_proc) THEN
2587: PO_LOG.proc_begin(d_module);
2588: END IF;
2589:
2590: -- open cursor for query to retrieve attr value records

Line 2587: PO_LOG.proc_begin(d_module);

2583: BEGIN
2584: d_position := 0;
2585:
2586: IF (PO_LOG.d_proc) THEN
2587: PO_LOG.proc_begin(d_module);
2588: END IF;
2589:
2590: -- open cursor for query to retrieve attr value records
2591: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp

Line 2614: IF (PO_LOG.d_stmt) THEN

2610:
2611: -- number of records read in current batch
2612: l_attr_values_tlp.rec_count := l_attr_values_tlp.intf_attr_values_tlp_id_tbl.COUNT;
2613:
2614: IF (PO_LOG.d_stmt) THEN
2615: PO_LOG.stmt(d_module, d_position, 'attr values tlp in batch',
2616: l_attr_values_tlp.rec_count);
2617: END IF;
2618:

Line 2615: PO_LOG.stmt(d_module, d_position, 'attr values tlp in batch',

2611: -- number of records read in current batch
2612: l_attr_values_tlp.rec_count := l_attr_values_tlp.intf_attr_values_tlp_id_tbl.COUNT;
2613:
2614: IF (PO_LOG.d_stmt) THEN
2615: PO_LOG.stmt(d_module, d_position, 'attr values tlp in batch',
2616: l_attr_values_tlp.rec_count);
2617: END IF;
2618:
2619: EXIT WHEN l_attr_values_tlp.rec_count = 0;

Line 2639: IF (PO_LOG.d_stmt) THEN

2635: d_position := 20;
2636:
2637: -- exit when all rows are processed
2638: IF (l_processing_row_tbl.COUNT = 0) THEN
2639: IF (PO_LOG.d_stmt) THEN
2640: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2641: END IF;
2642:
2643: EXIT;

Line 2640: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');

2636:
2637: -- exit when all rows are processed
2638: IF (l_processing_row_tbl.COUNT = 0) THEN
2639: IF (PO_LOG.d_stmt) THEN
2640: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2641: END IF;
2642:
2643: EXIT;
2644: END IF;

Line 2716: IF (PO_LOG.d_proc) THEN

2712: IF (l_attr_values_tlp_csr%ISOPEN) THEN
2713: CLOSE l_attr_values_tlp_csr;
2714: END IF;
2715:
2716: IF (PO_LOG.d_proc) THEN
2717: PO_LOG.proc_end(d_module);
2718: END IF;
2719:
2720: EXCEPTION

Line 2717: PO_LOG.proc_end(d_module);

2713: CLOSE l_attr_values_tlp_csr;
2714: END IF;
2715:
2716: IF (PO_LOG.d_proc) THEN
2717: PO_LOG.proc_end(d_module);
2718: END IF;
2719:
2720: EXCEPTION
2721: WHEN OTHERS THEN