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.22.12020000.5 2013/05/09 10:00:31 vlalwani 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 98: IF (PO_LOG.d_proc) THEN

94:
95: BEGIN
96: d_position := 0;
97:
98: IF (PO_LOG.d_proc) THEN
99: PO_LOG.proc_begin(d_module, 'start main process for header group',
100: PO_PDOI_PARAMS.g_current_round_num);
101: END IF;
102:

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

95: BEGIN
96: d_position := 0;
97:
98: IF (PO_LOG.d_proc) THEN
99: PO_LOG.proc_begin(d_module, 'start main process for header group',
100: PO_PDOI_PARAMS.g_current_round_num);
101: END IF;
102:
103: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);

Line 147: IF (PO_LOG.d_stmt) THEN

143: IF (PO_PDOI_PARAMS.g_request.calling_module =
144: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
145: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
146: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
147: IF (PO_LOG.d_stmt) THEN
148: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
149: PO_PDOI_PARAMS.g_request.interface_header_id);
150: END IF;
151:

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

144: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
145: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
146: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
147: IF (PO_LOG.d_stmt) THEN
148: PO_LOG.stmt(d_module, d_position, 'Unprocessed records will be removed for header ',
149: PO_PDOI_PARAMS.g_request.interface_header_id);
150: END IF;
151:
152: PO_PDOI_UTL.reject_unprocessed_intf

Line 160: IF (PO_LOG.d_proc) THEN

156: END IF;
157:
158: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);
159:
160: IF (PO_LOG.d_proc) THEN
161: PO_LOG.proc_end(d_module);
162: END IF;
163:
164: EXCEPTION

Line 161: PO_LOG.proc_end(d_module);

157:
158: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_MAIN_PROCESSING);
159:
160: IF (PO_LOG.d_proc) THEN
161: PO_LOG.proc_end(d_module);
162: END IF;
163:
164: EXCEPTION
165: WHEN OTHERS THEN

Line 225: IF (PO_LOG.d_proc) THEN

221:
222: BEGIN
223: d_position := 0;
224:
225: IF (PO_LOG.d_proc) THEN
226: PO_LOG.proc_begin(d_module);
227: END IF;
228:
229: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);

Line 226: PO_LOG.proc_begin(d_module);

222: BEGIN
223: d_position := 0;
224:
225: IF (PO_LOG.d_proc) THEN
226: PO_LOG.proc_begin(d_module);
227: END IF;
228:
229: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);
230:

Line 255: IF (PO_LOG.d_stmt) THEN

251:
252: -- number of records read in current batch
253: l_headers.rec_count := l_headers.intf_header_id_tbl.COUNT;
254:
255: IF (PO_LOG.d_stmt) THEN
256: PO_LOG.stmt(d_module, d_position, 'header count within batch',
257: l_headers.rec_count);
258: END IF;
259:

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

252: -- number of records read in current batch
253: l_headers.rec_count := l_headers.intf_header_id_tbl.COUNT;
254:
255: IF (PO_LOG.d_stmt) THEN
256: PO_LOG.stmt(d_module, d_position, 'header count within batch',
257: l_headers.rec_count);
258: END IF;
259:
260: EXIT WHEN l_headers.rec_count = 0;

Line 307: IF (PO_LOG.d_stmt) THEN

303: l_rej_intf_header_id_tbl.EXTEND(l_headers.rec_count);
304: FOR i IN 1..l_headers.rec_count
305: LOOP
306: IF (l_headers.error_flag_tbl(i) = FND_API.g_TRUE) THEN
307: IF (PO_LOG.d_stmt) THEN
308: PO_LOG.stmt(d_module, d_position, 'rejected intf header id',
309: l_headers.intf_header_id_tbl(i));
310: END IF;
311:

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

304: FOR i IN 1..l_headers.rec_count
305: LOOP
306: IF (l_headers.error_flag_tbl(i) = FND_API.g_TRUE) THEN
307: IF (PO_LOG.d_stmt) THEN
308: PO_LOG.stmt(d_module, d_position, 'rejected intf header id',
309: l_headers.intf_header_id_tbl(i));
310: END IF;
311:
312: l_count := l_count + 1;

Line 417: IF (PO_LOG.d_stmt) THEN

413: AND interface_header_id > l_max_intf_header_id
414: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
415: ORDER by interface_header_id;
416:
417: IF (PO_LOG.d_stmt) THEN
418: PO_LOG.stmt(d_module, d_position, 'l_headers.draft_id_tbl.count',
419: l_headers.draft_id_tbl.count);
420: END IF;
421:

Line 418: PO_LOG.stmt(d_module, d_position, 'l_headers.draft_id_tbl.count',

414: AND action = PO_PDOI_CONSTANTS.g_ACTION_UPDATE
415: ORDER by interface_header_id;
416:
417: IF (PO_LOG.d_stmt) THEN
418: PO_LOG.stmt(d_module, d_position, 'l_headers.draft_id_tbl.count',
419: l_headers.draft_id_tbl.count);
420: END IF;
421:
422:

Line 427: IF (PO_LOG.d_stmt) THEN

423: EXCEPTION WHEN No_Data_Found THEN
424:
425: d_position := 120;
426:
427: IF (PO_LOG.d_stmt) THEN
428: PO_LOG.stmt(d_module, d_position, 'Setting l_cat_upload_head_exists in Exception');
429: END IF;
430:
431: l_cat_upload_head_exists :=FALSE;

Line 428: PO_LOG.stmt(d_module, d_position, 'Setting l_cat_upload_head_exists in Exception');

424:
425: d_position := 120;
426:
427: IF (PO_LOG.d_stmt) THEN
428: PO_LOG.stmt(d_module, d_position, 'Setting l_cat_upload_head_exists in Exception');
429: END IF;
430:
431: l_cat_upload_head_exists :=FALSE;
432: END;

Line 434: IF (PO_LOG.d_stmt) THEN

430:
431: l_cat_upload_head_exists :=FALSE;
432: END;
433:
434: IF (PO_LOG.d_stmt) THEN
435: PO_LOG.stmt(d_module, d_position, 'l_cat_upload_head_exists',
436: l_cat_upload_head_exists);
437: END IF;
438:

Line 435: PO_LOG.stmt(d_module, d_position, 'l_cat_upload_head_exists',

431: l_cat_upload_head_exists :=FALSE;
432: END;
433:
434: IF (PO_LOG.d_stmt) THEN
435: PO_LOG.stmt(d_module, d_position, 'l_cat_upload_head_exists',
436: l_cat_upload_head_exists);
437: END IF;
438:
439:

Line 444: IF (PO_LOG.d_stmt) THEN

440: d_position :=110;
441:
442: IF l_cat_upload_head_exists THEN
443:
444: IF (PO_LOG.d_stmt) THEN
445: PO_LOG.stmt(d_module, d_position, 'Before Inserting into Po_Headers_Draft_All');
446: END IF;
447:
448:

Line 445: PO_LOG.stmt(d_module, d_position, 'Before Inserting into Po_Headers_Draft_All');

441:
442: IF l_cat_upload_head_exists THEN
443:
444: IF (PO_LOG.d_stmt) THEN
445: PO_LOG.stmt(d_module, d_position, 'Before Inserting into Po_Headers_Draft_All');
446: END IF;
447:
448:
449: PO_HEADERS_DRAFT_PKG.sync_draft_from_txn(

Line 456: IF (PO_LOG.d_stmt) THEN

452: p_delete_flag_tbl => l_delete_tbl,
453: x_record_already_exist_tbl => l_record_already_exist_tbl
454: );
455:
456: IF (PO_LOG.d_stmt) THEN
457: PO_LOG.stmt(d_module, d_position, 'After Inserting into Po_Headers_Draft_All');
458: END IF;
459:
460:

Line 457: PO_LOG.stmt(d_module, d_position, 'After Inserting into Po_Headers_Draft_All');

453: x_record_already_exist_tbl => l_record_already_exist_tbl
454: );
455:
456: IF (PO_LOG.d_stmt) THEN
457: PO_LOG.stmt(d_module, d_position, 'After Inserting into Po_Headers_Draft_All');
458: END IF;
459:
460:
461: END IF;

Line 469: IF (PO_LOG.d_proc) THEN

465: -- Bug:16730873 End
466:
467: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_HEADER_PROCESS);
468:
469: IF (PO_LOG.d_proc) THEN
470: PO_LOG.proc_end(d_module);
471: END IF;
472:
473: EXCEPTION

Line 470: PO_LOG.proc_end(d_module);

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

Line 527: IF (PO_LOG.d_proc) THEN

523:
524: BEGIN
525: d_position := 0;
526:
527: IF (PO_LOG.d_proc) THEN
528: PO_LOG.proc_begin(d_module);
529: END IF;
530:
531: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);

Line 528: PO_LOG.proc_begin(d_module);

524: BEGIN
525: d_position := 0;
526:
527: IF (PO_LOG.d_proc) THEN
528: PO_LOG.proc_begin(d_module);
529: END IF;
530:
531: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
532:

Line 604: IF (PO_LOG.d_proc) THEN

600: AND processing_id = PO_PDOI_PARAMS.g_processing_id;
601:
602: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
603:
604: IF (PO_LOG.d_proc) THEN
605: PO_LOG.proc_end(d_module);
606: END IF;
607:
608: EXCEPTION

Line 605: PO_LOG.proc_end(d_module);

601:
602: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_PROCESS);
603:
604: IF (PO_LOG.d_proc) THEN
605: PO_LOG.proc_end(d_module);
606: END IF;
607:
608: EXCEPTION
609: WHEN OTHERS THEN

Line 668: IF (PO_LOG.d_proc) THEN

664:
665: BEGIN
666: d_position := 0;
667:
668: IF (PO_LOG.d_proc) THEN
669: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
670: END IF;
671:
672: /*

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

665: BEGIN
666: d_position := 0;
667:
668: IF (PO_LOG.d_proc) THEN
669: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
670: END IF;
671:
672: /*
673: -- code added for debugging purpose

Line 687: IF (PO_LOG.d_stmt) THEN

683: IF (PO_PDOI_PARAMS.g_request.calling_module =
684: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
685: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
686: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
687: IF (PO_LOG.d_stmt) THEN
688: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
689: ' error threshold is hit for header ',
690: PO_PDOI_PARAMS.g_request.interface_header_id);
691: END IF;

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

684: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
685: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
686: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
687: IF (PO_LOG.d_stmt) THEN
688: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_add since' ||
689: ' error threshold is hit for header ',
690: PO_PDOI_PARAMS.g_request.interface_header_id);
691: END IF;
692:

Line 717: IF (PO_LOG.d_stmt) THEN

713: IF (PO_PDOI_PARAMS.g_request.calling_module =
714: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
715: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
716: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
717: IF (PO_LOG.d_stmt) THEN
718: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
719: PO_PDOI_PARAMS.g_request.interface_header_id);
720: END IF;
721:

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

714: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
715: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
716: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
717: IF (PO_LOG.d_stmt) THEN
718: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
719: PO_PDOI_PARAMS.g_request.interface_header_id);
720: END IF;
721:
722: -- no need to process remaining lines if error threshold is reached

Line 745: IF (PO_LOG.d_stmt) THEN

741: -- this iteration
742: --
743: l_lines_count := l_lines.intf_line_id_tbl.COUNT;
744:
745: IF (PO_LOG.d_stmt) THEN
746: PO_LOG.stmt(d_module, d_position, 'line count in batch',
747: l_lines.rec_count);
748: END IF;
749:

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

742: --
743: l_lines_count := l_lines.intf_line_id_tbl.COUNT;
744:
745: IF (PO_LOG.d_stmt) THEN
746: PO_LOG.stmt(d_module, d_position, 'line count in batch',
747: l_lines.rec_count);
748: END IF;
749:
750: EXIT WHEN l_lines.rec_count = 0;

Line 814: IF (PO_LOG.d_stmt) THEN

810: d_position := 70;
811:
812: -- create items if necessary
813: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
814: IF (PO_LOG.d_stmt) THEN
815: PO_LOG.stmt(d_module, d_position, 'create items for lines');
816: END IF;
817:
818: PO_PDOI_ITEM_PROCESS_PVT.create_items

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

811:
812: -- create items if necessary
813: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
814: IF (PO_LOG.d_stmt) THEN
815: PO_LOG.stmt(d_module, d_position, 'create items for lines');
816: END IF;
817:
818: PO_PDOI_ITEM_PROCESS_PVT.create_items
819: (

Line 853: IF (PO_LOG.d_stmt) THEN

849: FOR i IN 1..l_lines.rec_count
850: LOOP
851: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
852: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
853: IF (PO_LOG.d_stmt) THEN
854: PO_LOG.stmt(d_module, d_position, 'error flag',
855: l_lines.error_flag_tbl(i));
856: PO_LOG.stmt(d_module, d_position, 'reject flag',
857: l_lines.need_to_reject_flag_tbl(i));

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

850: LOOP
851: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
852: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
853: IF (PO_LOG.d_stmt) THEN
854: PO_LOG.stmt(d_module, d_position, 'error flag',
855: l_lines.error_flag_tbl(i));
856: PO_LOG.stmt(d_module, d_position, 'reject flag',
857: l_lines.need_to_reject_flag_tbl(i));
858: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

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

852: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
853: IF (PO_LOG.d_stmt) THEN
854: PO_LOG.stmt(d_module, d_position, 'error flag',
855: l_lines.error_flag_tbl(i));
856: PO_LOG.stmt(d_module, d_position, 'reject flag',
857: l_lines.need_to_reject_flag_tbl(i));
858: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
859: l_lines.intf_line_id_tbl(i));
860: END IF;

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

854: PO_LOG.stmt(d_module, d_position, 'error flag',
855: l_lines.error_flag_tbl(i));
856: PO_LOG.stmt(d_module, d_position, 'reject flag',
857: l_lines.need_to_reject_flag_tbl(i));
858: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
859: l_lines.intf_line_id_tbl(i));
860: END IF;
861:
862: l_rej_intf_line_id_tbl.EXTEND;

Line 969: IF (PO_LOG.d_proc) THEN

965: AND NVL(intf_line2.process_code, PO_PDOI_CONSTANTS.g_PROCESS_CODE_PENDING)
966: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
967: AND NVL(intf_line2.price_break_flag, 'N') = 'N');
968:
969: IF (PO_LOG.d_proc) THEN
970: PO_LOG.proc_end(d_module);
971: END IF;
972:
973: EXCEPTION

Line 970: PO_LOG.proc_end(d_module);

966: = PO_PDOI_CONSTANTS.g_PROCESS_CODE_NOTIFIED
967: AND NVL(intf_line2.price_break_flag, 'N') = 'N');
968:
969: IF (PO_LOG.d_proc) THEN
970: PO_LOG.proc_end(d_module);
971: END IF;
972:
973: EXCEPTION
974: WHEN OTHERS THEN

Line 1050: IF (PO_LOG.d_proc) THEN

1046:
1047: BEGIN
1048: d_position := 0;
1049:
1050: IF (PO_LOG.d_proc) THEN
1051: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
1052: END IF;
1053:
1054: -- Bug 5215781:

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

1047: BEGIN
1048: d_position := 0;
1049:
1050: IF (PO_LOG.d_proc) THEN
1051: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
1052: END IF;
1053:
1054: -- Bug 5215781:
1055: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 1060: IF (PO_LOG.d_stmt) THEN

1056: IF (PO_PDOI_PARAMS.g_request.calling_module =
1057: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1058: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1059: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1060: IF (PO_LOG.d_stmt) THEN
1061: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
1062: ' error threshold is hit for header ',
1063: PO_PDOI_PARAMS.g_request.interface_header_id);
1064: END IF;

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

1057: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1058: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1059: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1060: IF (PO_LOG.d_stmt) THEN
1061: PO_LOG.stmt(d_module, d_position, 'Exit from process_lines_sync since' ||
1062: ' error threshold is hit for header ',
1063: PO_PDOI_PARAMS.g_request.interface_header_id);
1064: END IF;
1065:

Line 1092: IF (PO_LOG.d_stmt) THEN

1088: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1089: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1090: d_position := 20;
1091:
1092: IF (PO_LOG.d_stmt) THEN
1093: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1094: PO_PDOI_PARAMS.g_request.interface_header_id);
1095: END IF;
1096:

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

1089: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1090: d_position := 20;
1091:
1092: IF (PO_LOG.d_stmt) THEN
1093: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1094: PO_PDOI_PARAMS.g_request.interface_header_id);
1095: END IF;
1096:
1097: EXIT;

Line 1113: IF (PO_LOG.d_stmt) THEN

1109:
1110: -- number of records read in current batch
1111: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
1112:
1113: IF (PO_LOG.d_stmt) THEN
1114: PO_LOG.stmt(d_module, d_position, 'line count in batch',
1115: l_lines.rec_count);
1116: END IF;
1117:

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

1110: -- number of records read in current batch
1111: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
1112:
1113: IF (PO_LOG.d_stmt) THEN
1114: PO_LOG.stmt(d_module, d_position, 'line count in batch',
1115: l_lines.rec_count);
1116: END IF;
1117:
1118: EXIT WHEN l_lines.rec_count = 0;

Line 1171: IF (PO_LOG.d_stmt) THEN

1167: -- exit when all rows are processed
1168: IF (l_processing_row_tbl.COUNT = 0) THEN
1169: d_position := 60;
1170:
1171: IF (PO_LOG.d_stmt) THEN
1172: PO_LOG.stmt(d_module, d_position, 'exit after all lines are processed');
1173: END IF;
1174:
1175: EXIT;

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

1168: IF (l_processing_row_tbl.COUNT = 0) THEN
1169: d_position := 60;
1170:
1171: IF (PO_LOG.d_stmt) THEN
1172: PO_LOG.stmt(d_module, d_position, 'exit after all lines are processed');
1173: END IF;
1174:
1175: EXIT;
1176: END IF;

Line 1181: IF (PO_LOG.d_stmt) THEN

1177:
1178: -- increment group number
1179: l_group_num := l_group_num + 1;
1180:
1181: IF (PO_LOG.d_stmt) THEN
1182: PO_LOG.stmt(d_module, d_position, 'group_num', l_group_num);
1183: END IF;
1184:
1185: -- perform uniqueness check on all the records and

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

1178: -- increment group number
1179: l_group_num := l_group_num + 1;
1180:
1181: IF (PO_LOG.d_stmt) THEN
1182: PO_LOG.stmt(d_module, d_position, 'group_num', l_group_num);
1183: END IF;
1184:
1185: -- perform uniqueness check on all the records and
1186: -- mark the group number on the records that can be processed

Line 1333: IF (PO_LOG.d_proc) THEN

1329: WHERE interface_line_id = l_notified_intf_line_id_tbl(i);
1330:
1331: d_position := 160;
1332:
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_end(d_module);
1335: END IF;
1336:
1337: EXCEPTION

Line 1334: PO_LOG.proc_end(d_module);

1330:
1331: d_position := 160;
1332:
1333: IF (PO_LOG.d_proc) THEN
1334: PO_LOG.proc_end(d_module);
1335: END IF;
1336:
1337: EXCEPTION
1338: WHEN OTHERS THEN

Line 1387: IF (PO_LOG.d_proc) THEN

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

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

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

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

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

Line 1394: IF (PO_LOG.d_proc) THEN

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

Line 1395: PO_LOG.proc_end(d_module);

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

Line 1435: IF (PO_LOG.d_stmt) THEN

1431: d_position := 40;
1432:
1433: -- create items if necessary
1434: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
1435: IF (PO_LOG.d_stmt) THEN
1436: PO_LOG.stmt(d_module, d_position, 'create items from line info');
1437: END IF;
1438:
1439: PO_PDOI_ITEM_PROCESS_PVT.create_items

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

1432:
1433: -- create items if necessary
1434: IF (PO_PDOI_PARAMS.g_request.create_items = 'Y') THEN
1435: IF (PO_LOG.d_stmt) THEN
1436: PO_LOG.stmt(d_module, d_position, 'create items from line info');
1437: END IF;
1438:
1439: PO_PDOI_ITEM_PROCESS_PVT.create_items
1440: (

Line 1469: IF (PO_LOG.d_stmt) THEN

1465: FOR i IN 1..x_lines.rec_count
1466: LOOP
1467: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1468: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1469: IF (PO_LOG.d_stmt) THEN
1470: PO_LOG.stmt(d_module, d_position, 'error flag',
1471: x_lines.error_flag_tbl(i));
1472: PO_LOG.stmt(d_module, d_position, 'reject flag',
1473: x_lines.need_to_reject_flag_tbl(i));

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

1466: LOOP
1467: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1468: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1469: IF (PO_LOG.d_stmt) THEN
1470: PO_LOG.stmt(d_module, d_position, 'error flag',
1471: x_lines.error_flag_tbl(i));
1472: PO_LOG.stmt(d_module, d_position, 'reject flag',
1473: x_lines.need_to_reject_flag_tbl(i));
1474: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

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

1468: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1469: IF (PO_LOG.d_stmt) THEN
1470: PO_LOG.stmt(d_module, d_position, 'error flag',
1471: x_lines.error_flag_tbl(i));
1472: PO_LOG.stmt(d_module, d_position, 'reject flag',
1473: x_lines.need_to_reject_flag_tbl(i));
1474: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1475: x_lines.intf_line_id_tbl(i));
1476: END IF;

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

1470: PO_LOG.stmt(d_module, d_position, 'error flag',
1471: x_lines.error_flag_tbl(i));
1472: PO_LOG.stmt(d_module, d_position, 'reject flag',
1473: x_lines.need_to_reject_flag_tbl(i));
1474: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1475: x_lines.intf_line_id_tbl(i));
1476: END IF;
1477:
1478: l_count := l_count + 1;

Line 1499: IF (PO_LOG.d_proc) THEN

1495: UPDATE po_lines_all
1496: SET expiration_date = TRUNC(sysdate - 1)
1497: WHERE po_line_id = p_expire_line_id_tbl(i);
1498:
1499: IF (PO_LOG.d_proc) THEN
1500: PO_LOG.proc_end(d_module);
1501: END IF;
1502:
1503: EXCEPTION

Line 1500: PO_LOG.proc_end(d_module);

1496: SET expiration_date = TRUNC(sysdate - 1)
1497: WHERE po_line_id = p_expire_line_id_tbl(i);
1498:
1499: IF (PO_LOG.d_proc) THEN
1500: PO_LOG.proc_end(d_module);
1501: END IF;
1502:
1503: EXCEPTION
1504: WHEN OTHERS THEN

Line 1549: IF (PO_LOG.d_proc) THEN

1545:
1546: BEGIN
1547: d_position := 0;
1548:
1549: IF (PO_LOG.d_proc) THEN
1550: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1551: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1552: END IF;
1553:

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

1546: BEGIN
1547: d_position := 0;
1548:
1549: IF (PO_LOG.d_proc) THEN
1550: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1551: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1552: END IF;
1553:
1554: -- return if there is no line to be processed

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

1547: d_position := 0;
1548:
1549: IF (PO_LOG.d_proc) THEN
1550: PO_LOG.proc_begin(d_module, 'p_group_num', p_group_num);
1551: PO_LOG.proc_begin(d_module, 'count of lines', x_lines.rec_count);
1552: END IF;
1553:
1554: -- return if there is no line to be processed
1555: IF (x_lines.rec_count = 0) THEN

Line 1556: IF (PO_LOG.d_proc) THEN

1552: END IF;
1553:
1554: -- return if there is no line to be processed
1555: IF (x_lines.rec_count = 0) THEN
1556: IF (PO_LOG.d_proc) THEN
1557: PO_LOG.proc_end(d_module);
1558: END IF;
1559:
1560: RETURN;

Line 1557: PO_LOG.proc_end(d_module);

1553:
1554: -- return if there is no line to be processed
1555: IF (x_lines.rec_count = 0) THEN
1556: IF (PO_LOG.d_proc) THEN
1557: PO_LOG.proc_end(d_module);
1558: END IF;
1559:
1560: RETURN;
1561: END IF;

Line 1614: IF (PO_LOG.d_stmt) THEN

1610: FOR i IN 1..x_lines.rec_count
1611: LOOP
1612: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1613: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1614: IF (PO_LOG.d_stmt) THEN
1615: PO_LOG.stmt(d_module, d_position, 'error flag',
1616: x_lines.error_flag_tbl(i));
1617: PO_LOG.stmt(d_module, d_position, 'reject flag',
1618: x_lines.need_to_reject_flag_tbl(i));

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

1611: LOOP
1612: IF (x_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
1613: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1614: IF (PO_LOG.d_stmt) THEN
1615: PO_LOG.stmt(d_module, d_position, 'error flag',
1616: x_lines.error_flag_tbl(i));
1617: PO_LOG.stmt(d_module, d_position, 'reject flag',
1618: x_lines.need_to_reject_flag_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

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

1613: x_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
1614: IF (PO_LOG.d_stmt) THEN
1615: PO_LOG.stmt(d_module, d_position, 'error flag',
1616: x_lines.error_flag_tbl(i));
1617: PO_LOG.stmt(d_module, d_position, 'reject flag',
1618: x_lines.need_to_reject_flag_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1620: x_lines.intf_line_id_tbl(i));
1621: END IF;

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

1615: PO_LOG.stmt(d_module, d_position, 'error flag',
1616: x_lines.error_flag_tbl(i));
1617: PO_LOG.stmt(d_module, d_position, 'reject flag',
1618: x_lines.need_to_reject_flag_tbl(i));
1619: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
1620: x_lines.intf_line_id_tbl(i));
1621: END IF;
1622:
1623: l_count := l_count + 1;

Line 1635: IF (PO_LOG.d_proc) THEN

1631: p_cascade => FND_API.g_TRUE
1632: );
1633: l_rej_intf_line_id_tbl.DELETE;
1634:
1635: IF (PO_LOG.d_proc) THEN
1636: PO_LOG.proc_end(d_module);
1637: END IF;
1638:
1639: EXCEPTION

Line 1636: PO_LOG.proc_end(d_module);

1632: );
1633: l_rej_intf_line_id_tbl.DELETE;
1634:
1635: IF (PO_LOG.d_proc) THEN
1636: PO_LOG.proc_end(d_module);
1637: END IF;
1638:
1639: EXCEPTION
1640: WHEN OTHERS THEN

Line 1697: IF (PO_LOG.d_proc) THEN

1693: l_count NUMBER;
1694: BEGIN
1695: d_position := 0;
1696:
1697: IF (PO_LOG.d_proc) THEN
1698: PO_LOG.proc_begin(d_module);
1699: END IF;
1700:
1701: -- Bug 5215781:

Line 1698: PO_LOG.proc_begin(d_module);

1694: BEGIN
1695: d_position := 0;
1696:
1697: IF (PO_LOG.d_proc) THEN
1698: PO_LOG.proc_begin(d_module);
1699: END IF;
1700:
1701: -- Bug 5215781:
1702: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 1707: IF (PO_LOG.d_stmt) THEN

1703: IF (PO_PDOI_PARAMS.g_request.calling_module =
1704: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1705: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1706: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1707: IF (PO_LOG.d_stmt) THEN
1708: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1709: ' error threshold is hit for header ',
1710: PO_PDOI_PARAMS.g_request.interface_header_id);
1711: END IF;

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

1704: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
1705: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1706: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1707: IF (PO_LOG.d_stmt) THEN
1708: PO_LOG.stmt(d_module, d_position, 'Exit from process_line_locations since' ||
1709: ' error threshold is hit for header ',
1710: PO_PDOI_PARAMS.g_request.interface_header_id);
1711: END IF;
1712:

Line 1740: IF (PO_LOG.d_stmt) THEN

1736: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
1737: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1738: d_position := 20;
1739:
1740: IF (PO_LOG.d_stmt) THEN
1741: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1742: PO_PDOI_PARAMS.g_request.interface_header_id);
1743: END IF;
1744:

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

1737: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
1738: d_position := 20;
1739:
1740: IF (PO_LOG.d_stmt) THEN
1741: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
1742: PO_PDOI_PARAMS.g_request.interface_header_id);
1743: END IF;
1744:
1745: EXIT;

Line 1761: IF (PO_LOG.d_stmt) THEN

1757:
1758: -- number of records read in current batch
1759: l_line_locs.rec_count := l_line_locs.intf_line_loc_id_tbl.COUNT;
1760:
1761: IF (PO_LOG.d_stmt) THEN
1762: PO_LOG.stmt(d_module, d_position, 'loc count in batch',
1763: l_line_locs.rec_count);
1764: END IF;
1765:

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

1758: -- number of records read in current batch
1759: l_line_locs.rec_count := l_line_locs.intf_line_loc_id_tbl.COUNT;
1760:
1761: IF (PO_LOG.d_stmt) THEN
1762: PO_LOG.stmt(d_module, d_position, 'loc count in batch',
1763: l_line_locs.rec_count);
1764: END IF;
1765:
1766: EXIT WHEN l_line_locs.rec_count = 0;

Line 1868: IF (PO_LOG.d_stmt) THEN

1864: */
1865: END IF;
1866: END LOOP;
1867:
1868: IF (PO_LOG.d_stmt) THEN
1869: PO_LOG.stmt(d_module, d_position, 'to-be-rejected locs',
1870: l_rej_intf_line_loc_id_tbl);
1871: END IF;
1872:

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

1865: END IF;
1866: END LOOP;
1867:
1868: IF (PO_LOG.d_stmt) THEN
1869: PO_LOG.stmt(d_module, d_position, 'to-be-rejected locs',
1870: l_rej_intf_line_loc_id_tbl);
1871: END IF;
1872:
1873: PO_PDOI_UTL.reject_line_locations_intf

Line 1968: IF (PO_LOG.d_proc) THEN

1964: END IF;
1965:
1966: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_PROCESS);
1967:
1968: IF (PO_LOG.d_proc) THEN
1969: PO_LOG.proc_end(d_module);
1970: END IF;
1971:
1972: EXCEPTION

Line 1969: PO_LOG.proc_end(d_module);

1965:
1966: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_LINE_LOC_PROCESS);
1967:
1968: IF (PO_LOG.d_proc) THEN
1969: PO_LOG.proc_end(d_module);
1970: END IF;
1971:
1972: EXCEPTION
1973: WHEN OTHERS THEN

Line 2023: IF (PO_LOG.d_proc) THEN

2019:
2020: BEGIN
2021: d_position := 0;
2022:
2023: IF (PO_LOG.d_proc) THEN
2024: PO_LOG.proc_begin(d_module);
2025: END IF;
2026:
2027: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);

Line 2024: PO_LOG.proc_begin(d_module);

2020: BEGIN
2021: d_position := 0;
2022:
2023: IF (PO_LOG.d_proc) THEN
2024: PO_LOG.proc_begin(d_module);
2025: END IF;
2026:
2027: PO_TIMING_UTL.start_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);
2028:

Line 2053: IF (PO_LOG.d_stmt) THEN

2049:
2050: -- number of records read in current batch
2051: l_dists.rec_count := l_dists.intf_dist_id_tbl.COUNT;
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_position, 'dist count in batch',
2055: l_dists.rec_count);
2056: END IF;
2057:

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

2050: -- number of records read in current batch
2051: l_dists.rec_count := l_dists.intf_dist_id_tbl.COUNT;
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_position, 'dist count in batch',
2055: l_dists.rec_count);
2056: END IF;
2057:
2058: EXIT WHEN l_dists.rec_count = 0;

Line 2124: IF (PO_LOG.d_stmt) THEN

2120: l_rej_intf_dist_id_tbl(l_rej_intf_dist_id_tbl.COUNT) := l_dists.intf_dist_id_tbl(i);
2121: END IF;
2122: END LOOP;
2123:
2124: IF (PO_LOG.d_stmt) THEN
2125: PO_LOG.stmt(d_module, d_position, 'to-be-rejected dists',
2126: l_rej_intf_dist_id_tbl);
2127: END IF;
2128:

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

2121: END IF;
2122: END LOOP;
2123:
2124: IF (PO_LOG.d_stmt) THEN
2125: PO_LOG.stmt(d_module, d_position, 'to-be-rejected dists',
2126: l_rej_intf_dist_id_tbl);
2127: END IF;
2128:
2129: d_position := 90;

Line 2190: IF (PO_LOG.d_proc) THEN

2186: END IF;
2187:
2188: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);
2189:
2190: IF (PO_LOG.d_proc) THEN
2191: PO_LOG.proc_end(d_module);
2192: END IF;
2193:
2194: EXCEPTION

Line 2191: PO_LOG.proc_end(d_module);

2187:
2188: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_DIST_PROCESS);
2189:
2190: IF (PO_LOG.d_proc) THEN
2191: PO_LOG.proc_end(d_module);
2192: END IF;
2193:
2194: EXCEPTION
2195: WHEN OTHERS THEN

Line 2245: IF (PO_LOG.d_proc) THEN

2241:
2242: BEGIN
2243: d_position := 0;
2244:
2245: IF (PO_LOG.d_proc) THEN
2246: PO_LOG.proc_begin(d_module);
2247: END IF;
2248:
2249: -- Bug 5215781:

Line 2246: PO_LOG.proc_begin(d_module);

2242: BEGIN
2243: d_position := 0;
2244:
2245: IF (PO_LOG.d_proc) THEN
2246: PO_LOG.proc_begin(d_module);
2247: END IF;
2248:
2249: -- Bug 5215781:
2250: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 2255: IF (PO_LOG.d_stmt) THEN

2251: IF (PO_PDOI_PARAMS.g_request.calling_module =
2252: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2253: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2254: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2255: IF (PO_LOG.d_stmt) THEN
2256: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2257: ' error threshold is hit for header ',
2258: PO_PDOI_PARAMS.g_request.interface_header_id);
2259: END IF;

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

2252: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2253: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2254: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2255: IF (PO_LOG.d_stmt) THEN
2256: PO_LOG.stmt(d_module, d_position, 'Exit from process_price_diffs since' ||
2257: ' error threshold is hit for header ',
2258: PO_PDOI_PARAMS.g_request.interface_header_id);
2259: END IF;
2260:

Line 2288: IF (PO_LOG.d_stmt) THEN

2284: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2285: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2286: d_position := 20;
2287:
2288: IF (PO_LOG.d_stmt) THEN
2289: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2290: PO_PDOI_PARAMS.g_request.interface_header_id);
2291: END IF;
2292:

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

2285: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2286: d_position := 20;
2287:
2288: IF (PO_LOG.d_stmt) THEN
2289: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2290: PO_PDOI_PARAMS.g_request.interface_header_id);
2291: END IF;
2292:
2293: EXIT;

Line 2309: IF (PO_LOG.d_stmt) THEN

2305:
2306: -- number of records read in current batch
2307: l_price_diffs.rec_count := l_price_diffs.intf_price_diff_id_tbl.COUNT;
2308:
2309: IF (PO_LOG.d_stmt) THEN
2310: PO_LOG.stmt(d_module, d_position, 'price diffs in batch',
2311: l_price_diffs.rec_count);
2312: END IF;
2313:

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

2306: -- number of records read in current batch
2307: l_price_diffs.rec_count := l_price_diffs.intf_price_diff_id_tbl.COUNT;
2308:
2309: IF (PO_LOG.d_stmt) THEN
2310: PO_LOG.stmt(d_module, d_position, 'price diffs in batch',
2311: l_price_diffs.rec_count);
2312: END IF;
2313:
2314: EXIT WHEN l_price_diffs.rec_count = 0;

Line 2348: IF (PO_LOG.d_stmt) THEN

2344: l_rej_intf_price_diff_id_tbl(l_rej_intf_price_diff_id_tbl.COUNT) := l_price_diffs.intf_price_diff_id_tbl(i);
2345: END IF;
2346: END LOOP;
2347:
2348: IF (PO_LOG.d_stmt) THEN
2349: PO_LOG.stmt(d_module, d_position, 'to-be-rejected price diffs',
2350: l_rej_intf_price_diff_id_tbl);
2351: END IF;
2352:

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

2345: END IF;
2346: END LOOP;
2347:
2348: IF (PO_LOG.d_stmt) THEN
2349: PO_LOG.stmt(d_module, d_position, 'to-be-rejected price diffs',
2350: l_rej_intf_price_diff_id_tbl);
2351: END IF;
2352:
2353: PO_PDOI_UTL.reject_price_diff_intf

Line 2410: IF (PO_LOG.d_proc) THEN

2406: END IF;
2407:
2408: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_PROCESS);
2409:
2410: IF (PO_LOG.d_proc) THEN
2411: PO_LOG.proc_end(d_module);
2412: END IF;
2413:
2414: EXCEPTION

Line 2411: PO_LOG.proc_end(d_module);

2407:
2408: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_PRICE_DIFF_PROCESS);
2409:
2410: IF (PO_LOG.d_proc) THEN
2411: PO_LOG.proc_end(d_module);
2412: END IF;
2413:
2414: EXCEPTION
2415: WHEN OTHERS THEN

Line 2453: IF (PO_LOG.d_proc) THEN

2449:
2450: BEGIN
2451: d_position := 0;
2452:
2453: IF (PO_LOG.d_proc) THEN
2454: PO_LOG.proc_begin(d_module);
2455: END IF;
2456:
2457: -- Bug 5215781:

Line 2454: PO_LOG.proc_begin(d_module);

2450: BEGIN
2451: d_position := 0;
2452:
2453: IF (PO_LOG.d_proc) THEN
2454: PO_LOG.proc_begin(d_module);
2455: END IF;
2456:
2457: -- Bug 5215781:
2458: -- exit immediately if error threshold is hit for CATALOG UPLOAD

Line 2463: IF (PO_LOG.d_stmt) THEN

2459: IF (PO_PDOI_PARAMS.g_request.calling_module =
2460: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2461: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2462: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2465: ' error threshold is hit for header ',
2466: PO_PDOI_PARAMS.g_request.interface_header_id);
2467: END IF;

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

2460: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2461: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2462: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2463: IF (PO_LOG.d_stmt) THEN
2464: PO_LOG.stmt(d_module, d_position, 'Exit from process_attributes since' ||
2465: ' error threshold is hit for header ',
2466: PO_PDOI_PARAMS.g_request.interface_header_id);
2467: END IF;
2468:

Line 2493: IF (PO_LOG.d_proc) THEN

2489: d_position := 40;
2490:
2491: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_PROCESS);
2492:
2493: IF (PO_LOG.d_proc) THEN
2494: PO_LOG.proc_end(d_module);
2495: END IF;
2496:
2497: EXCEPTION

Line 2494: PO_LOG.proc_end(d_module);

2490:
2491: PO_TIMING_UTL.stop_time(PO_PDOI_CONSTANTS.g_T_ATTR_PROCESS);
2492:
2493: IF (PO_LOG.d_proc) THEN
2494: PO_LOG.proc_end(d_module);
2495: END IF;
2496:
2497: EXCEPTION
2498: WHEN OTHERS THEN

Line 2558: IF (PO_LOG.d_proc) THEN

2554:
2555: BEGIN
2556: d_position := 0;
2557:
2558: IF (PO_LOG.d_proc) THEN
2559: PO_LOG.proc_begin(d_module);
2560: END IF;
2561:
2562: -- open cursor for query to retrieve attr value records

Line 2559: PO_LOG.proc_begin(d_module);

2555: BEGIN
2556: d_position := 0;
2557:
2558: IF (PO_LOG.d_proc) THEN
2559: PO_LOG.proc_begin(d_module);
2560: END IF;
2561:
2562: -- open cursor for query to retrieve attr value records
2563: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values

Line 2586: IF (PO_LOG.d_stmt) THEN

2582:
2583: -- number of records read in current batch
2584: l_attr_values.rec_count := l_attr_values.intf_attr_values_id_tbl.COUNT;
2585:
2586: IF (PO_LOG.d_stmt) THEN
2587: PO_LOG.stmt(d_module, d_position, 'attr values in batch',
2588: l_attr_values.rec_count);
2589: END IF;
2590:

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

2583: -- number of records read in current batch
2584: l_attr_values.rec_count := l_attr_values.intf_attr_values_id_tbl.COUNT;
2585:
2586: IF (PO_LOG.d_stmt) THEN
2587: PO_LOG.stmt(d_module, d_position, 'attr values in batch',
2588: l_attr_values.rec_count);
2589: END IF;
2590:
2591: EXIT WHEN l_attr_values.rec_count = 0;

Line 2611: IF (PO_LOG.d_stmt) THEN

2607: d_position := 30;
2608:
2609: -- exit when all rows are processed
2610: IF (l_processing_row_tbl.COUNT = 0) THEN
2611: IF (PO_LOG.d_stmt) THEN
2612: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2613: END IF;
2614:
2615: EXIT;

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

2608:
2609: -- exit when all rows are processed
2610: IF (l_processing_row_tbl.COUNT = 0) THEN
2611: IF (PO_LOG.d_stmt) THEN
2612: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2613: END IF;
2614:
2615: EXIT;
2616: END IF;

Line 2694: IF (PO_LOG.d_proc) THEN

2690: IF (l_attr_values_csr%ISOPEN) THEN
2691: CLOSE l_attr_values_csr;
2692: END IF;
2693:
2694: IF (PO_LOG.d_proc) THEN
2695: PO_LOG.proc_end(d_module);
2696: END IF;
2697:
2698: EXCEPTION

Line 2695: PO_LOG.proc_end(d_module);

2691: CLOSE l_attr_values_csr;
2692: END IF;
2693:
2694: IF (PO_LOG.d_proc) THEN
2695: PO_LOG.proc_end(d_module);
2696: END IF;
2697:
2698: EXCEPTION
2699: WHEN OTHERS THEN

Line 2755: IF (PO_LOG.d_proc) THEN

2751:
2752: BEGIN
2753: d_position := 0;
2754:
2755: IF (PO_LOG.d_proc) THEN
2756: PO_LOG.proc_begin(d_module);
2757: END IF;
2758:
2759: -- open cursor for query to retrieve attr value records

Line 2756: PO_LOG.proc_begin(d_module);

2752: BEGIN
2753: d_position := 0;
2754:
2755: IF (PO_LOG.d_proc) THEN
2756: PO_LOG.proc_begin(d_module);
2757: END IF;
2758:
2759: -- open cursor for query to retrieve attr value records
2760: PO_PDOI_ATTR_PROCESS_PVT.open_attr_values_tlp

Line 2783: IF (PO_LOG.d_stmt) THEN

2779:
2780: -- number of records read in current batch
2781: l_attr_values_tlp.rec_count := l_attr_values_tlp.intf_attr_values_tlp_id_tbl.COUNT;
2782:
2783: IF (PO_LOG.d_stmt) THEN
2784: PO_LOG.stmt(d_module, d_position, 'attr values tlp in batch',
2785: l_attr_values_tlp.rec_count);
2786: END IF;
2787:

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

2780: -- number of records read in current batch
2781: l_attr_values_tlp.rec_count := l_attr_values_tlp.intf_attr_values_tlp_id_tbl.COUNT;
2782:
2783: IF (PO_LOG.d_stmt) THEN
2784: PO_LOG.stmt(d_module, d_position, 'attr values tlp in batch',
2785: l_attr_values_tlp.rec_count);
2786: END IF;
2787:
2788: EXIT WHEN l_attr_values_tlp.rec_count = 0;

Line 2808: IF (PO_LOG.d_stmt) THEN

2804: d_position := 20;
2805:
2806: -- exit when all rows are processed
2807: IF (l_processing_row_tbl.COUNT = 0) THEN
2808: IF (PO_LOG.d_stmt) THEN
2809: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2810: END IF;
2811:
2812: EXIT;

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

2805:
2806: -- exit when all rows are processed
2807: IF (l_processing_row_tbl.COUNT = 0) THEN
2808: IF (PO_LOG.d_stmt) THEN
2809: PO_LOG.stmt(d_module, d_position, 'exit after all rows are processed');
2810: END IF;
2811:
2812: EXIT;
2813: END IF;

Line 2892: IF (PO_LOG.d_proc) THEN

2888: IF (l_attr_values_tlp_csr%ISOPEN) THEN
2889: CLOSE l_attr_values_tlp_csr;
2890: END IF;
2891:
2892: IF (PO_LOG.d_proc) THEN
2893: PO_LOG.proc_end(d_module);
2894: END IF;
2895:
2896: EXCEPTION

Line 2893: PO_LOG.proc_end(d_module);

2889: CLOSE l_attr_values_tlp_csr;
2890: END IF;
2891:
2892: IF (PO_LOG.d_proc) THEN
2893: PO_LOG.proc_end(d_module);
2894: END IF;
2895:
2896: EXCEPTION
2897: WHEN OTHERS THEN

Line 2935: IF (PO_LOG.d_proc) THEN

2931: l_po_line_id NUMBER := 0;
2932: BEGIN
2933: d_position := 0;
2934:
2935: IF (PO_LOG.d_proc) THEN
2936: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
2937: END IF;
2938:
2939: -- open cursor for the correct query

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

2932: BEGIN
2933: d_position := 0;
2934:
2935: IF (PO_LOG.d_proc) THEN
2936: PO_LOG.proc_begin(d_module, 'p_data_set_type', p_data_set_type);
2937: END IF;
2938:
2939: -- open cursor for the correct query
2940: PO_PDOI_LINE_PROCESS_PVT.open_lines

Line 2957: IF (PO_LOG.d_stmt) THEN

2953: IF (PO_PDOI_PARAMS.g_request.calling_module =
2954: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2955: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2956: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2957: IF (PO_LOG.d_stmt) THEN
2958: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2959: PO_PDOI_PARAMS.g_request.interface_header_id);
2960: END IF;
2961:

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

2954: PO_PDOI_CONSTANTS.g_CALL_MOD_CATALOG_UPLOAD AND
2955: PO_PDOI_PARAMS.g_docs_info(PO_PDOI_PARAMS.g_request.interface_header_id)
2956: .err_tolerance_exceeded = FND_API.g_TRUE) THEN
2957: IF (PO_LOG.d_stmt) THEN
2958: PO_LOG.stmt(d_module, d_position, 'error tolerance exceeded for',
2959: PO_PDOI_PARAMS.g_request.interface_header_id);
2960: END IF;
2961:
2962: -- no need to process remaining lines if error threshold is reached

Line 2980: IF (PO_LOG.d_stmt) THEN

2976:
2977: -- number of records read in current batch
2978: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
2979:
2980: IF (PO_LOG.d_stmt) THEN
2981: PO_LOG.stmt(d_module, d_position, 'line count in batch',
2982: l_lines.rec_count);
2983: END IF;
2984:

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

2977: -- number of records read in current batch
2978: l_lines.rec_count := l_lines.intf_line_id_tbl.COUNT;
2979:
2980: IF (PO_LOG.d_stmt) THEN
2981: PO_LOG.stmt(d_module, d_position, 'line count in batch',
2982: l_lines.rec_count);
2983: END IF;
2984:
2985: EXIT WHEN l_lines.rec_count = 0;

Line 3021: IF (PO_LOG.d_proc) THEN

3017: --Info line basic validations
3018: IF(l_lines.line_num_tbl(i) IS NULL) THEN
3019: l_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3020: d_position := 10;
3021: IF (PO_LOG.d_proc) THEN
3022: PO_LOG.stmt(d_module, d_position, 'line_num cannot be null for info line : ', l_lines.intf_line_id_tbl(i));
3023: END IF;
3024: d_position := 20;
3025: IF (PO_LOG.d_proc) THEN

Line 3022: PO_LOG.stmt(d_module, d_position, 'line_num cannot be null for info line : ', l_lines.intf_line_id_tbl(i));

3018: IF(l_lines.line_num_tbl(i) IS NULL) THEN
3019: l_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3020: d_position := 10;
3021: IF (PO_LOG.d_proc) THEN
3022: PO_LOG.stmt(d_module, d_position, 'line_num cannot be null for info line : ', l_lines.intf_line_id_tbl(i));
3023: END IF;
3024: d_position := 20;
3025: IF (PO_LOG.d_proc) THEN
3026: PO_LOG.stmt(d_module, d_position, 'item_desc cannot be null for info line : ', l_lines.intf_line_id_tbl(i));

Line 3025: IF (PO_LOG.d_proc) THEN

3021: IF (PO_LOG.d_proc) THEN
3022: PO_LOG.stmt(d_module, d_position, 'line_num cannot be null for info line : ', l_lines.intf_line_id_tbl(i));
3023: END IF;
3024: d_position := 20;
3025: IF (PO_LOG.d_proc) THEN
3026: PO_LOG.stmt(d_module, d_position, 'item_desc cannot be null for info line : ', l_lines.intf_line_id_tbl(i));
3027: END IF;
3028:
3029: ELSIF(Nvl(l_lines.clm_info_flag_tbl(i),'N') = 'N') THEN

Line 3026: PO_LOG.stmt(d_module, d_position, 'item_desc cannot be null for info line : ', l_lines.intf_line_id_tbl(i));

3022: PO_LOG.stmt(d_module, d_position, 'line_num cannot be null for info line : ', l_lines.intf_line_id_tbl(i));
3023: END IF;
3024: d_position := 20;
3025: IF (PO_LOG.d_proc) THEN
3026: PO_LOG.stmt(d_module, d_position, 'item_desc cannot be null for info line : ', l_lines.intf_line_id_tbl(i));
3027: END IF;
3028:
3029: ELSIF(Nvl(l_lines.clm_info_flag_tbl(i),'N') = 'N') THEN
3030: l_lines.error_flag_tbl(i) := FND_API.g_TRUE;

Line 3032: IF (PO_LOG.d_proc) THEN

3028:
3029: ELSIF(Nvl(l_lines.clm_info_flag_tbl(i),'N') = 'N') THEN
3030: l_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3031: d_position := 30;
3032: IF (PO_LOG.d_proc) THEN
3033: PO_LOG.stmt(d_module, d_position, 'Incorrect info flag : ', l_lines.intf_line_id_tbl(i));
3034: END IF;
3035:
3036: END IF;

Line 3033: PO_LOG.stmt(d_module, d_position, 'Incorrect info flag : ', l_lines.intf_line_id_tbl(i));

3029: ELSIF(Nvl(l_lines.clm_info_flag_tbl(i),'N') = 'N') THEN
3030: l_lines.error_flag_tbl(i) := FND_API.g_TRUE;
3031: d_position := 30;
3032: IF (PO_LOG.d_proc) THEN
3033: PO_LOG.stmt(d_module, d_position, 'Incorrect info flag : ', l_lines.intf_line_id_tbl(i));
3034: END IF;
3035:
3036: END IF;
3037:

Line 3044: IF (PO_LOG.d_proc) THEN

3040: SELECT po_lines_s.nextval INTO l_po_line_id FROM sys.dual;
3041: --Stamping po_line_id & po_header_id
3042: l_lines.po_line_id_tbl(i) := l_po_line_id;
3043: l_lines.po_header_id_tbl(i) := l_lines.hd_po_header_id_tbl(i);
3044: IF (PO_LOG.d_proc) THEN
3045: PO_LOG.stmt(d_module, d_position, 'Stamped po_line_id : ', l_po_line_id);
3046: PO_LOG.stmt(d_module, d_position, 'Stamped po_header_id : ', l_lines.hd_po_header_id_tbl(i));
3047: END IF;
3048: END IF;

Line 3045: PO_LOG.stmt(d_module, d_position, 'Stamped po_line_id : ', l_po_line_id);

3041: --Stamping po_line_id & po_header_id
3042: l_lines.po_line_id_tbl(i) := l_po_line_id;
3043: l_lines.po_header_id_tbl(i) := l_lines.hd_po_header_id_tbl(i);
3044: IF (PO_LOG.d_proc) THEN
3045: PO_LOG.stmt(d_module, d_position, 'Stamped po_line_id : ', l_po_line_id);
3046: PO_LOG.stmt(d_module, d_position, 'Stamped po_header_id : ', l_lines.hd_po_header_id_tbl(i));
3047: END IF;
3048: END IF;
3049:

Line 3046: PO_LOG.stmt(d_module, d_position, 'Stamped po_header_id : ', l_lines.hd_po_header_id_tbl(i));

3042: l_lines.po_line_id_tbl(i) := l_po_line_id;
3043: l_lines.po_header_id_tbl(i) := l_lines.hd_po_header_id_tbl(i);
3044: IF (PO_LOG.d_proc) THEN
3045: PO_LOG.stmt(d_module, d_position, 'Stamped po_line_id : ', l_po_line_id);
3046: PO_LOG.stmt(d_module, d_position, 'Stamped po_header_id : ', l_lines.hd_po_header_id_tbl(i));
3047: END IF;
3048: END IF;
3049:
3050: END LOOP;

Line 3080: IF (PO_LOG.d_stmt) THEN

3076: FOR i IN 1..l_lines.rec_count
3077: LOOP
3078: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
3079: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
3080: IF (PO_LOG.d_stmt) THEN
3081: PO_LOG.stmt(d_module, d_position, 'error flag',
3082: l_lines.error_flag_tbl(i));
3083: PO_LOG.stmt(d_module, d_position, 'reject flag',
3084: l_lines.need_to_reject_flag_tbl(i));

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

3077: LOOP
3078: IF (l_lines.error_flag_tbl(i) = FND_API.g_TRUE OR
3079: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
3080: IF (PO_LOG.d_stmt) THEN
3081: PO_LOG.stmt(d_module, d_position, 'error flag',
3082: l_lines.error_flag_tbl(i));
3083: PO_LOG.stmt(d_module, d_position, 'reject flag',
3084: l_lines.need_to_reject_flag_tbl(i));
3085: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',

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

3079: l_lines.need_to_reject_flag_tbl(i) = FND_API.g_TRUE) THEN
3080: IF (PO_LOG.d_stmt) THEN
3081: PO_LOG.stmt(d_module, d_position, 'error flag',
3082: l_lines.error_flag_tbl(i));
3083: PO_LOG.stmt(d_module, d_position, 'reject flag',
3084: l_lines.need_to_reject_flag_tbl(i));
3085: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
3086: l_lines.intf_line_id_tbl(i));
3087: END IF;

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

3081: PO_LOG.stmt(d_module, d_position, 'error flag',
3082: l_lines.error_flag_tbl(i));
3083: PO_LOG.stmt(d_module, d_position, 'reject flag',
3084: l_lines.need_to_reject_flag_tbl(i));
3085: PO_LOG.stmt(d_module, d_position, 'rejected intf line id',
3086: l_lines.intf_line_id_tbl(i));
3087: END IF;
3088:
3089: l_rej_intf_line_id_tbl.EXTEND;

Line 3136: IF (PO_LOG.d_proc) THEN

3132: -- close the cursor
3133: IF (l_lines_csr%ISOPEN) THEN
3134: CLOSE l_lines_csr;
3135: END IF;
3136: IF (PO_LOG.d_proc) THEN
3137: PO_LOG.proc_end(d_module);
3138: END IF;
3139:
3140: EXCEPTION

Line 3137: PO_LOG.proc_end(d_module);

3133: IF (l_lines_csr%ISOPEN) THEN
3134: CLOSE l_lines_csr;
3135: END IF;
3136: IF (PO_LOG.d_proc) THEN
3137: PO_LOG.proc_end(d_module);
3138: END IF;
3139:
3140: EXCEPTION
3141: WHEN OTHERS THEN

Line 3187: IF (PO_LOG.d_proc) THEN

3183: AND intf_headers.processing_id = PO_PDOI_PARAMS.g_processing_id
3184: AND draft_lines.draft_id = intf_headers.draft_id;
3185: BEGIN
3186:
3187: IF (PO_LOG.d_proc) THEN
3188: PO_LOG.proc_begin(d_module);
3189: END IF;
3190: --loop through all slins
3191: FOR l_rec IN c_slins

Line 3188: PO_LOG.proc_begin(d_module);

3184: AND draft_lines.draft_id = intf_headers.draft_id;
3185: BEGIN
3186:
3187: IF (PO_LOG.d_proc) THEN
3188: PO_LOG.proc_begin(d_module);
3189: END IF;
3190: --loop through all slins
3191: FOR l_rec IN c_slins
3192: LOOP

Line 3206: IF (PO_LOG.d_proc) THEN

3202: AND Nvl(pld.draft_id,l_rec.draft_id) = l_rec.draft_id)
3203: WHERE po_line_id = l_rec.po_line_id
3204: AND Nvl(draft_id,l_rec.draft_id) = l_rec.draft_id;
3205: END LOOP;
3206: IF (PO_LOG.d_proc) THEN
3207: PO_LOG.proc_end(d_module);
3208: END IF;
3209: EXCEPTION
3210: WHEN OTHERS

Line 3207: PO_LOG.proc_end(d_module);

3203: WHERE po_line_id = l_rec.po_line_id
3204: AND Nvl(draft_id,l_rec.draft_id) = l_rec.draft_id;
3205: END LOOP;
3206: IF (PO_LOG.d_proc) THEN
3207: PO_LOG.proc_end(d_module);
3208: END IF;
3209: EXCEPTION
3210: WHEN OTHERS
3211: THEN

Line 3234: IF (PO_LOG.d_proc) THEN

3230: l_po_line_id_tbl PO_TBL_NUMBER;
3231:
3232: BEGIN
3233:
3234: IF (PO_LOG.d_proc) THEN
3235: PO_LOG.proc_begin(d_module);
3236: END IF;
3237: --collect po_line_id and corressponding clm_base_line_num for all base lines
3238: SELECT clm_base_line_num,

Line 3235: PO_LOG.proc_begin(d_module);

3231:
3232: BEGIN
3233:
3234: IF (PO_LOG.d_proc) THEN
3235: PO_LOG.proc_begin(d_module);
3236: END IF;
3237: --collect po_line_id and corressponding clm_base_line_num for all base lines
3238: SELECT clm_base_line_num,
3239: po_line_id

Line 3246: IF (PO_LOG.d_proc) THEN

3242: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
3243: AND Nvl(clm_option_indicator,'*') = 'O';
3244:
3245: d_position := 10;
3246: IF (PO_LOG.d_proc) THEN
3247: PO_LOG.stmt(d_module, d_position, 'clm base line num : ', l_po_line_id_tbl);
3248: END IF;
3249:
3250: FORALL i IN 1..l_clm_base_line_num_tbl.Count

Line 3247: PO_LOG.stmt(d_module, d_position, 'clm base line num : ', l_po_line_id_tbl);

3243: AND Nvl(clm_option_indicator,'*') = 'O';
3244:
3245: d_position := 10;
3246: IF (PO_LOG.d_proc) THEN
3247: PO_LOG.stmt(d_module, d_position, 'clm base line num : ', l_po_line_id_tbl);
3248: END IF;
3249:
3250: FORALL i IN 1..l_clm_base_line_num_tbl.Count
3251: UPDATE po_lines_draft_all

Line 3258: IF (PO_LOG.d_proc) THEN

3254: )
3255: WHERE l_clm_base_line_num_tbl(i) IS NOT NULL
3256: AND po_line_id = l_po_line_id_tbl(i);
3257:
3258: IF (PO_LOG.d_proc) THEN
3259: PO_LOG.proc_end(d_module);
3260: END IF;
3261:
3262: EXCEPTION

Line 3259: PO_LOG.proc_end(d_module);

3255: WHERE l_clm_base_line_num_tbl(i) IS NOT NULL
3256: AND po_line_id = l_po_line_id_tbl(i);
3257:
3258: IF (PO_LOG.d_proc) THEN
3259: PO_LOG.proc_end(d_module);
3260: END IF;
3261:
3262: EXCEPTION
3263: WHEN OTHERS