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

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

1: PACKAGE BODY PO_PDOI_PREPROC_PVT AS
2: /* $Header: PO_PDOI_PREPROC_PVT.plb 120.24 2006/09/12 00:37:11 bao noship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_PDOI_PREPROC_PVT');
6:
7: -------------------------------------------------------
8: ----------- PRIVATE PROCEDURES PROTOTYPE --------------
9: -------------------------------------------------------

Line 67: IF (PO_LOG.d_proc) THEN

63: BEGIN
64:
65: d_position := 0;
66:
67: IF (PO_LOG.d_proc) THEN
68: PO_LOG.proc_begin (d_module);
69: END IF;
70:
71: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);

Line 68: PO_LOG.proc_begin (d_module);

64:
65: d_position := 0;
66:
67: IF (PO_LOG.d_proc) THEN
68: PO_LOG.proc_begin (d_module);
69: END IF;
70:
71: PO_TIMING_UTL.start_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
72:

Line 122: IF (PO_LOG.d_proc) THEN

118: PO_PDOI_UTL.commit_work;
119:
120: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
121:
122: IF (PO_LOG.d_proc) THEN
123: PO_LOG.proc_end (d_module);
124: END IF;
125:
126: EXCEPTION

Line 123: PO_LOG.proc_end (d_module);

119:
120: PO_TIMING_UTL.stop_time (PO_PDOI_CONSTANTS.g_T_PREPROCESSING);
121:
122: IF (PO_LOG.d_proc) THEN
123: PO_LOG.proc_end (d_module);
124: END IF;
125:
126: EXCEPTION
127: WHEN OTHERS THEN

Line 175: IF (PO_LOG.d_proc) THEN

171:
172: BEGIN
173: d_position := 0;
174:
175: IF (PO_LOG.d_proc) THEN
176: PO_LOG.proc_begin (d_module);
177: END IF;
178:
179: IF (PO_PDOI_PARAMS.g_request.interface_header_id IS NOT NULL) THEN

Line 176: PO_LOG.proc_begin (d_module);

172: BEGIN
173: d_position := 0;
174:
175: IF (PO_LOG.d_proc) THEN
176: PO_LOG.proc_begin (d_module);
177: END IF;
178:
179: IF (PO_PDOI_PARAMS.g_request.interface_header_id IS NOT NULL) THEN
180:

Line 197: IF (PO_LOG.d_stmt) THEN

193: AND NVL(process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
194: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
195: ORDER BY po_line_id, interface_line_id;
196:
197: IF (PO_LOG.d_stmt) THEN
198: PO_LOG.stmt(d_module, d_position, 'number of lines with notified status ',
199: l_intf_line_id_tbl.COUNT);
200: END IF;
201:

Line 198: PO_LOG.stmt(d_module, d_position, 'number of lines with notified status ',

194: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
195: ORDER BY po_line_id, interface_line_id;
196:
197: IF (PO_LOG.d_stmt) THEN
198: PO_LOG.stmt(d_module, d_position, 'number of lines with notified status ',
199: l_intf_line_id_tbl.COUNT);
200: END IF;
201:
202: d_position := 10;

Line 205: IF (PO_LOG.d_stmt) THEN

201:
202: d_position := 10;
203:
204: FOR i IN 1..l_intf_line_id_tbl.COUNT LOOP
205: IF (PO_LOG.d_stmt) THEN
206: PO_LOG.stmt(d_module, d_position, 'i = ' || i || ', intf_line_id = ' ||
207: l_intf_line_id_tbl(i) || ' change accept flag = ' ||
208: l_price_chg_accept_flag_tbl(i));
209: END IF;

Line 206: PO_LOG.stmt(d_module, d_position, 'i = ' || i || ', intf_line_id = ' ||

202: d_position := 10;
203:
204: FOR i IN 1..l_intf_line_id_tbl.COUNT LOOP
205: IF (PO_LOG.d_stmt) THEN
206: PO_LOG.stmt(d_module, d_position, 'i = ' || i || ', intf_line_id = ' ||
207: l_intf_line_id_tbl(i) || ' change accept flag = ' ||
208: l_price_chg_accept_flag_tbl(i));
209: END IF;
210:

Line 251: IF (PO_LOG.d_stmt) THEN

247: AND NVL(lines.process_code, PO_PDOI_CONSTANTS.g_process_code_PENDING) =
248: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
249: AND lines.parent_interface_line_id IS NOT NULL;
250:
251: IF (PO_LOG.d_stmt) THEN
252: PO_LOG.stmt(d_module, d_position, '# of lines updated based on parent_intf_line_id',
253: SQL%ROWCOUNT);
254: END IF;
255:

Line 252: PO_LOG.stmt(d_module, d_position, '# of lines updated based on parent_intf_line_id',

248: PO_PDOI_CONSTANTS.g_process_code_NOTIFIED
249: AND lines.parent_interface_line_id IS NOT NULL;
250:
251: IF (PO_LOG.d_stmt) THEN
252: PO_LOG.stmt(d_module, d_position, '# of lines updated based on parent_intf_line_id',
253: SQL%ROWCOUNT);
254: END IF;
255:
256: d_position := 40;

Line 268: IF (PO_LOG.d_proc) THEN

264:
265: d_position := 30;
266: END IF;
267:
268: IF (PO_LOG.d_proc) THEN
269: PO_LOG.proc_end (d_module);
270: END IF;
271:
272: EXCEPTION

Line 269: PO_LOG.proc_end (d_module);

265: d_position := 30;
266: END IF;
267:
268: IF (PO_LOG.d_proc) THEN
269: PO_LOG.proc_end (d_module);
270: END IF;
271:
272: EXCEPTION
273: WHEN OTHERS THEN

Line 356: IF (PO_LOG.d_proc) THEN

352: l_intf_line_id_tbl PO_TBL_NUMBER := PO_TBL_NUMBER();
353: BEGIN
354: d_position := 0;
355:
356: IF (PO_LOG.d_proc) THEN
357: PO_LOG.proc_begin (d_module);
358: END IF;
359:
360: --

Line 357: PO_LOG.proc_begin (d_module);

353: BEGIN
354: d_position := 0;
355:
356: IF (PO_LOG.d_proc) THEN
357: PO_LOG.proc_begin (d_module);
358: END IF;
359:
360: --
361: -- ECO 4420269

Line 371: IF (PO_LOG.d_stmt) THEN

367: SET PHI.org_id = PO_PDOI_PARAMS.g_request.org_id
368: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
369: AND PHI.org_id IS NULL;
370:
371: IF (PO_LOG.d_stmt) THEN
372: PO_LOG.stmt(d_module, d_position, 'updatec org id for ' ||
373: SQL%ROWCOUNT || ' records.');
374: END IF;
375: END IF;

Line 372: PO_LOG.stmt(d_module, d_position, 'updatec org id for ' ||

368: WHERE PHI.batch_id = PO_PDOI_PARAMS.g_request.batch_id
369: AND PHI.org_id IS NULL;
370:
371: IF (PO_LOG.d_stmt) THEN
372: PO_LOG.stmt(d_module, d_position, 'updatec org id for ' ||
373: SQL%ROWCOUNT || ' records.');
374: END IF;
375: END IF;
376:

Line 411: IF (PO_LOG.d_stmt) THEN

407: approval_status = NVL(approval_status,
408: PO_PDOI_PARAMS.g_request.approved_status)
409: WHERE interface_header_id = l_intf_header_id_tbl(i);
410:
411: IF (PO_LOG.d_stmt) THEN
412: PO_LOG.stmt(d_module, d_position, 'after header assignment. Updated ' ||
413: SQL%ROWCOUNT || ' records');
414: END IF;
415:

Line 412: PO_LOG.stmt(d_module, d_position, 'after header assignment. Updated ' ||

408: PO_PDOI_PARAMS.g_request.approved_status)
409: WHERE interface_header_id = l_intf_header_id_tbl(i);
410:
411: IF (PO_LOG.d_stmt) THEN
412: PO_LOG.stmt(d_module, d_position, 'after header assignment. Updated ' ||
413: SQL%ROWCOUNT || ' records');
414: END IF;
415:
416: d_position := 40;

Line 447: IF (PO_LOG.d_stmt) THEN

443: RETURNING interface_line_id
444: BULK COLLECT INTO l_intf_line_id_tbl;
445:
446:
447: IF (PO_LOG.d_stmt) THEN
448: PO_LOG.stmt(d_module, d_position, 'after line assignment. Updated ' ||
449: SQL%ROWCOUNT || ' records');
450: END IF;
451:

Line 448: PO_LOG.stmt(d_module, d_position, 'after line assignment. Updated ' ||

444: BULK COLLECT INTO l_intf_line_id_tbl;
445:
446:
447: IF (PO_LOG.d_stmt) THEN
448: PO_LOG.stmt(d_module, d_position, 'after line assignment. Updated ' ||
449: SQL%ROWCOUNT || ' records');
450: END IF;
451:
452: d_position := 50;

Line 458: IF (PO_LOG.d_stmt) THEN

454: UPDATE po_line_locations_interface
455: SET processing_id = PO_PDOI_PARAMS.g_processing_id
456: WHERE interface_line_id = l_intf_line_id_tbl(i);
457:
458: IF (PO_LOG.d_stmt) THEN
459: PO_LOG.stmt(d_module, d_position, 'after line location assignment. ' ||
460: ' Updated ' || SQL%ROWCOUNT || ' records');
461: END IF;
462:

Line 459: PO_LOG.stmt(d_module, d_position, 'after line location assignment. ' ||

455: SET processing_id = PO_PDOI_PARAMS.g_processing_id
456: WHERE interface_line_id = l_intf_line_id_tbl(i);
457:
458: IF (PO_LOG.d_stmt) THEN
459: PO_LOG.stmt(d_module, d_position, 'after line location assignment. ' ||
460: ' Updated ' || SQL%ROWCOUNT || ' records');
461: END IF;
462:
463: d_position := 60;

Line 469: IF (PO_LOG.d_stmt) THEN

465: UPDATE po_price_diff_interface
466: SET processing_id = PO_PDOI_PARAMS.g_processing_id
467: WHERE interface_line_id = l_intf_line_id_tbl(i);
468:
469: IF (PO_LOG.d_stmt) THEN
470: PO_LOG.stmt(d_module, d_position, 'after price diff assignment. ' ||
471: 'Updated ' || SQL%ROWCOUNT || ' records');
472: END IF;
473:

Line 470: PO_LOG.stmt(d_module, d_position, 'after price diff assignment. ' ||

466: SET processing_id = PO_PDOI_PARAMS.g_processing_id
467: WHERE interface_line_id = l_intf_line_id_tbl(i);
468:
469: IF (PO_LOG.d_stmt) THEN
470: PO_LOG.stmt(d_module, d_position, 'after price diff assignment. ' ||
471: 'Updated ' || SQL%ROWCOUNT || ' records');
472: END IF;
473:
474: d_position := 70;

Line 482: IF (PO_LOG.d_stmt) THEN

478: UPDATE po_distributions_interface
479: SET processing_id = PO_PDOI_PARAMS.g_processing_id
480: WHERE interface_line_id = l_intf_line_id_tbl(i);
481:
482: IF (PO_LOG.d_stmt) THEN
483: PO_LOG.stmt(d_module, d_position, 'after distirbution assignment. ' ||
484: 'Updated ' || SQL%ROWCOUNT || ' records');
485: END IF;
486: END IF;

Line 483: PO_LOG.stmt(d_module, d_position, 'after distirbution assignment. ' ||

479: SET processing_id = PO_PDOI_PARAMS.g_processing_id
480: WHERE interface_line_id = l_intf_line_id_tbl(i);
481:
482: IF (PO_LOG.d_stmt) THEN
483: PO_LOG.stmt(d_module, d_position, 'after distirbution assignment. ' ||
484: 'Updated ' || SQL%ROWCOUNT || ' records');
485: END IF;
486: END IF;
487:

Line 498: IF (PO_LOG.d_stmt) THEN

494: UPDATE po_attr_values_interface
495: SET processing_id = PO_PDOI_PARAMS.g_processing_id
496: WHERE interface_line_id = l_intf_line_id_tbl(i);
497:
498: IF (PO_LOG.d_stmt) THEN
499: PO_LOG.stmt(d_module, d_position, 'after attr value assignment. ' ||
500: 'Updated ' || SQL%ROWCOUNT || ' records');
501: END IF;
502:

Line 499: PO_LOG.stmt(d_module, d_position, 'after attr value assignment. ' ||

495: SET processing_id = PO_PDOI_PARAMS.g_processing_id
496: WHERE interface_line_id = l_intf_line_id_tbl(i);
497:
498: IF (PO_LOG.d_stmt) THEN
499: PO_LOG.stmt(d_module, d_position, 'after attr value assignment. ' ||
500: 'Updated ' || SQL%ROWCOUNT || ' records');
501: END IF;
502:
503: d_position := 100;

Line 509: IF (PO_LOG.d_stmt) THEN

505: UPDATE po_attr_values_tlp_interface
506: SET processing_id = PO_PDOI_PARAMS.g_processing_id
507: WHERE interface_line_id = l_intf_line_id_tbl(i);
508:
509: IF (PO_LOG.d_stmt) THEN
510: PO_LOG.stmt(d_module, d_position, 'after attr values tlp assignment.' ||
511: ' Updated ' || SQL%ROWCOUNT || ' records');
512: END IF;
513: END IF;

Line 510: PO_LOG.stmt(d_module, d_position, 'after attr values tlp assignment.' ||

506: SET processing_id = PO_PDOI_PARAMS.g_processing_id
507: WHERE interface_line_id = l_intf_line_id_tbl(i);
508:
509: IF (PO_LOG.d_stmt) THEN
510: PO_LOG.stmt(d_module, d_position, 'after attr values tlp assignment.' ||
511: ' Updated ' || SQL%ROWCOUNT || ' records');
512: END IF;
513: END IF;
514:

Line 521: IF (PO_LOG.d_proc) THEN

517: END LOOP;
518:
519: CLOSE c_interface_headers;
520:
521: IF (PO_LOG.d_proc) THEN
522: PO_LOG.proc_end (d_module);
523: END IF;
524:
525: EXCEPTION

Line 522: PO_LOG.proc_end (d_module);

518:
519: CLOSE c_interface_headers;
520:
521: IF (PO_LOG.d_proc) THEN
522: PO_LOG.proc_end (d_module);
523: END IF;
524:
525: EXCEPTION
526: WHEN OTHERS THEN

Line 574: IF (PO_LOG.d_proc) THEN

570:
571: BEGIN
572: d_position := 0;
573:
574: IF (PO_LOG.d_proc) THEN
575: PO_LOG.proc_begin (d_module, '# of records to eval', x_intf_header_id_tbl.COUNT);
576: END IF;
577:
578: FOR i IN 1..x_intf_header_id_tbl.COUNT LOOP

Line 575: PO_LOG.proc_begin (d_module, '# of records to eval', x_intf_header_id_tbl.COUNT);

571: BEGIN
572: d_position := 0;
573:
574: IF (PO_LOG.d_proc) THEN
575: PO_LOG.proc_begin (d_module, '# of records to eval', x_intf_header_id_tbl.COUNT);
576: END IF;
577:
578: FOR i IN 1..x_intf_header_id_tbl.COUNT LOOP
579: d_position := 10;

Line 605: IF (PO_LOG.d_proc) THEN

601:
602: -- return the list with records that are still being processed filtered.
603: x_intf_header_id_tbl := l_tmp_intf_tbl;
604:
605: IF (PO_LOG.d_proc) THEN
606: PO_LOG.proc_end (d_module, '# of processable rec', x_intf_header_id_tbl.COUNT);
607: END IF;
608:
609: EXCEPTION

Line 606: PO_LOG.proc_end (d_module, '# of processable rec', x_intf_header_id_tbl.COUNT);

602: -- return the list with records that are still being processed filtered.
603: x_intf_header_id_tbl := l_tmp_intf_tbl;
604:
605: IF (PO_LOG.d_proc) THEN
606: PO_LOG.proc_end (d_module, '# of processable rec', x_intf_header_id_tbl.COUNT);
607: END IF;
608:
609: EXCEPTION
610: WHEN OTHERS THEN

Line 646: IF (PO_LOG.d_proc) THEN

642: BEGIN
643:
644: d_position := 0;
645:
646: IF (PO_LOG.d_proc) THEN
647: PO_LOG.proc_begin (d_module);
648: END IF;
649:
650: -- Check action code

Line 647: PO_LOG.proc_begin (d_module);

643:
644: d_position := 0;
645:
646: IF (PO_LOG.d_proc) THEN
647: PO_LOG.proc_begin (d_module);
648: END IF;
649:
650: -- Check action code
651: SELECT interface_header_id, action

Line 673: IF (PO_LOG.d_stmt) THEN

669: PO_PDOI_CONSTANTS.g_ACTION_UPDATE)));
670:
671: d_position := 10;
672:
673: IF (PO_LOG.d_stmt) THEN
674: PO_LOG.stmt(d_module, d_position, '# of records to reject:',
675: l_reject_tbl.COUNT);
676: END IF;
677:

Line 674: PO_LOG.stmt(d_module, d_position, '# of records to reject:',

670:
671: d_position := 10;
672:
673: IF (PO_LOG.d_stmt) THEN
674: PO_LOG.stmt(d_module, d_position, '# of records to reject:',
675: l_reject_tbl.COUNT);
676: END IF;
677:
678: FOR i IN 1..l_reject_tbl.COUNT LOOP

Line 705: IF (PO_LOG.d_proc) THEN

701: ( p_id_param_type => PO_PDOI_CONSTANTS.g_INTERFACE_HEADER_ID,
702: p_id_tbl => l_reject_tbl,
703: p_cascade => FND_API.G_TRUE);
704:
705: IF (PO_LOG.d_proc) THEN
706: PO_LOG.proc_end (d_module);
707: END IF;
708:
709: EXCEPTION

Line 706: PO_LOG.proc_end (d_module);

702: p_id_tbl => l_reject_tbl,
703: p_cascade => FND_API.G_TRUE);
704:
705: IF (PO_LOG.d_proc) THEN
706: PO_LOG.proc_end (d_module);
707: END IF;
708:
709: EXCEPTION
710: WHEN OTHERS THEN

Line 753: IF (PO_LOG.d_proc) THEN

749:
750: BEGIN
751: d_position := 0;
752:
753: IF (PO_LOG.d_proc) THEN
754: PO_LOG.proc_begin (d_module);
755: END IF;
756:
757: l_key := PO_CORE_S.get_session_gt_nextval;

Line 754: PO_LOG.proc_begin (d_module);

750: BEGIN
751: d_position := 0;
752:
753: IF (PO_LOG.d_proc) THEN
754: PO_LOG.proc_begin (d_module);
755: END IF;
756:
757: l_key := PO_CORE_S.get_session_gt_nextval;
758:

Line 835: IF (PO_LOG.d_proc) THEN

831: p_id_tbl => l_reject_list,
832: p_cascade => FND_API.G_TRUE
833: );
834:
835: IF (PO_LOG.d_proc) THEN
836: PO_LOG.proc_end (d_module);
837: END IF;
838:
839: EXCEPTION

Line 836: PO_LOG.proc_end (d_module);

832: p_cascade => FND_API.G_TRUE
833: );
834:
835: IF (PO_LOG.d_proc) THEN
836: PO_LOG.proc_end (d_module);
837: END IF;
838:
839: EXCEPTION
840: WHEN OTHERS THEN

Line 893: IF (PO_LOG.d_proc) THEN

889: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
890: BEGIN
891: d_position := 0;
892:
893: IF (PO_LOG.d_proc) THEN
894: PO_LOG.proc_begin (d_module);
895: END IF;
896:
897: -- For update and replace action, make sure that the document exists

Line 894: PO_LOG.proc_begin (d_module);

890: BEGIN
891: d_position := 0;
892:
893: IF (PO_LOG.d_proc) THEN
894: PO_LOG.proc_begin (d_module);
895: END IF;
896:
897: -- For update and replace action, make sure that the document exists
898:

Line 919: IF (PO_LOG.d_stmt) THEN

915: d_position := 20;
916: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
917: l_valid := FND_API.G_TRUE;
918:
919: IF (PO_LOG.d_stmt) THEN
920: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
921: l_interface_header_id_tbl(i));
922: END IF;
923:

Line 920: PO_LOG.stmt(d_module, d_position, 'checking for ' ||

916: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
917: l_valid := FND_API.G_TRUE;
918:
919: IF (PO_LOG.d_stmt) THEN
920: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
921: l_interface_header_id_tbl(i));
922: END IF;
923:
924: -- start date has to be provided for replace

Line 1057: IF (PO_LOG.d_stmt) THEN

1053:
1054: IF (l_index_for_replacement IS NOT NULL) THEN
1055: d_position := 110;
1056:
1057: IF (PO_LOG.d_stmt) THEN
1058: PO_LOG.stmt(d_module, d_position, 'Found doc for replacement: ' ||
1059: l_orig_po_header_id_tbl(l_index_for_replacement));
1060: END IF;
1061:

Line 1058: PO_LOG.stmt(d_module, d_position, 'Found doc for replacement: ' ||

1054: IF (l_index_for_replacement IS NOT NULL) THEN
1055: d_position := 110;
1056:
1057: IF (PO_LOG.d_stmt) THEN
1058: PO_LOG.stmt(d_module, d_position, 'Found doc for replacement: ' ||
1059: l_orig_po_header_id_tbl(l_index_for_replacement));
1060: END IF;
1061:
1062: -- For blanket, make sure that all releases should not have release

Line 1083: IF (PO_LOG.d_stmt) THEN

1079:
1080: IF (l_valid = FND_API.G_TRUE) THEN
1081: d_position := 130;
1082:
1083: IF (PO_LOG.d_stmt) THEN
1084: PO_LOG.stmt(d_module, d_position, 'Release date check passed');
1085: END IF;
1086:
1087: l_final_intf_header_id_tbl.extend;

Line 1084: PO_LOG.stmt(d_module, d_position, 'Release date check passed');

1080: IF (l_valid = FND_API.G_TRUE) THEN
1081: d_position := 130;
1082:
1083: IF (PO_LOG.d_stmt) THEN
1084: PO_LOG.stmt(d_module, d_position, 'Release date check passed');
1085: END IF;
1086:
1087: l_final_intf_header_id_tbl.extend;
1088: l_final_intf_header_id_tbl(l_final_intf_header_id_tbl.COUNT) :=

Line 1117: IF (PO_LOG.d_proc) THEN

1113: p_id_tbl => l_reject_list,
1114: p_cascade => FND_API.G_TRUE
1115: );
1116:
1117: IF (PO_LOG.d_proc) THEN
1118: PO_LOG.proc_end (d_module);
1119: END IF;
1120:
1121: EXCEPTION

Line 1118: PO_LOG.proc_end (d_module);

1114: p_cascade => FND_API.G_TRUE
1115: );
1116:
1117: IF (PO_LOG.d_proc) THEN
1118: PO_LOG.proc_end (d_module);
1119: END IF;
1120:
1121: EXCEPTION
1122: WHEN OTHERS THEN

Line 1172: IF (PO_LOG.d_proc) THEN

1168:
1169: BEGIN
1170: d_position := 0;
1171:
1172: IF (PO_LOG.d_proc) THEN
1173: PO_LOG.proc_begin (d_module);
1174: END IF;
1175:
1176: -- if we are expiring a blanket, make sure that none of the releases falls

Line 1173: PO_LOG.proc_begin (d_module);

1169: BEGIN
1170: d_position := 0;
1171:
1172: IF (PO_LOG.d_proc) THEN
1173: PO_LOG.proc_begin (d_module);
1174: END IF;
1175:
1176: -- if we are expiring a blanket, make sure that none of the releases falls
1177: -- outside of the effective dates of the blanket being expired

Line 1227: IF (PO_LOG.d_proc) THEN

1223: x_valid := FND_API.G_FALSE;
1224: END IF;
1225: END IF;
1226:
1227: IF (PO_LOG.d_proc) THEN
1228: PO_LOG.proc_end (d_module);
1229: END IF;
1230:
1231: EXCEPTION

Line 1228: PO_LOG.proc_end (d_module);

1224: END IF;
1225: END IF;
1226:
1227: IF (PO_LOG.d_proc) THEN
1228: PO_LOG.proc_end (d_module);
1229: END IF;
1230:
1231: EXCEPTION
1232: WHEN OTHERS THEN

Line 1299: IF (PO_LOG.d_proc) THEN

1295: l_reject_list PO_TBL_NUMBER := PO_TBL_NUMBER();
1296: BEGIN
1297: d_position := 0;
1298:
1299: IF (PO_LOG.d_proc) THEN
1300: PO_LOG.proc_begin (d_module);
1301: END IF;
1302:
1303: SELECT interface_header_id,

Line 1300: PO_LOG.proc_begin (d_module);

1296: BEGIN
1297: d_position := 0;
1298:
1299: IF (PO_LOG.d_proc) THEN
1300: PO_LOG.proc_begin (d_module);
1301: END IF;
1302:
1303: SELECT interface_header_id,
1304: vendor_id,

Line 1337: IF (PO_LOG.d_stmt) THEN

1333:
1334: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
1335: l_valid := FND_API.g_TRUE;
1336:
1337: IF (PO_LOG.d_stmt) THEN
1338: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
1339: l_interface_header_id_tbl(i));
1340: END IF;
1341:

Line 1338: PO_LOG.stmt(d_module, d_position, 'checking for ' ||

1334: FOR i IN 1..l_interface_header_id_tbl.COUNT LOOP
1335: l_valid := FND_API.g_TRUE;
1336:
1337: IF (PO_LOG.d_stmt) THEN
1338: PO_LOG.stmt(d_module, d_position, 'checking for ' ||
1339: l_interface_header_id_tbl(i));
1340: END IF;
1341:
1342: IF (l_po_header_id_tbl(i) IS NOT NULL) THEN

Line 1345: IF (PO_LOG.d_stmt) THEN

1341:
1342: IF (l_po_header_id_tbl(i) IS NOT NULL) THEN
1343: d_position := 20;
1344:
1345: IF (PO_LOG.d_stmt) THEN
1346: PO_LOG.stmt(d_module, d_position, 'po_header_id ' ||
1347: l_po_header_id_tbl(i) || 'is provided');
1348: END IF;
1349:

Line 1346: PO_LOG.stmt(d_module, d_position, 'po_header_id ' ||

1342: IF (l_po_header_id_tbl(i) IS NOT NULL) THEN
1343: d_position := 20;
1344:
1345: IF (PO_LOG.d_stmt) THEN
1346: PO_LOG.stmt(d_module, d_position, 'po_header_id ' ||
1347: l_po_header_id_tbl(i) || 'is provided');
1348: END IF;
1349:
1350: -- Make sure that the po_header_id is still valid

Line 1362: IF (PO_LOG.d_stmt) THEN

1358: AND POH.type_lookup_code = PO_PDOI_PARAMS.g_request.document_type;
1359:
1360: IF (l_existing_header = 'N' OR l_consigned_consumption_flag = 'Y') THEN
1361:
1362: IF (PO_LOG.d_stmt) THEN
1363: PO_LOG.stmt(d_module, d_position, 'po header id does not exist or' ||
1364: ' document type does not match');
1365: END IF;
1366:

Line 1363: PO_LOG.stmt(d_module, d_position, 'po header id does not exist or' ||

1359:
1360: IF (l_existing_header = 'N' OR l_consigned_consumption_flag = 'Y') THEN
1361:
1362: IF (PO_LOG.d_stmt) THEN
1363: PO_LOG.stmt(d_module, d_position, 'po header id does not exist or' ||
1364: ' document type does not match');
1365: END IF;
1366:
1367: l_valid := FND_API.g_FALSE;

Line 1445: IF (PO_LOG.d_stmt) THEN

1441:
1442: ELSE -- po_header_id is not provided
1443: d_position := 80;
1444:
1445: IF (PO_LOG.d_stmt) THEN
1446: PO_LOG.stmt(d_module, d_position, 'po_header_id is not provided. ' ||
1447: 'vendor doc num = ' || l_vendor_doc_num_tbl(i) ||
1448: ', document_num = ' || l_document_num_tbl(i));
1449: END IF;

Line 1446: PO_LOG.stmt(d_module, d_position, 'po_header_id is not provided. ' ||

1442: ELSE -- po_header_id is not provided
1443: d_position := 80;
1444:
1445: IF (PO_LOG.d_stmt) THEN
1446: PO_LOG.stmt(d_module, d_position, 'po_header_id is not provided. ' ||
1447: 'vendor doc num = ' || l_vendor_doc_num_tbl(i) ||
1448: ', document_num = ' || l_document_num_tbl(i));
1449: END IF;
1450:

Line 1693: IF (PO_LOG.d_proc) THEN

1689: p_id_tbl => l_reject_list,
1690: p_cascade => FND_API.G_TRUE
1691: );
1692:
1693: IF (PO_LOG.d_proc) THEN
1694: PO_LOG.proc_end (d_module);
1695: END IF;
1696:
1697: EXCEPTION

Line 1694: PO_LOG.proc_end (d_module);

1690: p_cascade => FND_API.G_TRUE
1691: );
1692:
1693: IF (PO_LOG.d_proc) THEN
1694: PO_LOG.proc_end (d_module);
1695: END IF;
1696:
1697: EXCEPTION
1698: WHEN OTHERS THEN

Line 1733: IF (PO_LOG.d_proc) THEN

1729: l_vendor_doc_num_tbl PO_TBL_VARCHAR25 := PO_TBL_VARCHAR25();
1730: BEGIN
1731: d_position := 0;
1732:
1733: IF (PO_LOG.d_proc) THEN
1734: PO_LOG.proc_begin (d_module);
1735: END IF;
1736:
1737: IF (PO_PDOI_PARAMS.g_request.document_type =

Line 1734: PO_LOG.proc_begin (d_module);

1730: BEGIN
1731: d_position := 0;
1732:
1733: IF (PO_LOG.d_proc) THEN
1734: PO_LOG.proc_begin (d_module);
1735: END IF;
1736:
1737: IF (PO_PDOI_PARAMS.g_request.document_type =
1738: PO_PDOI_CONSTANTS.g_DOC_TYPE_QUOTATION) THEN

Line 1811: IF (PO_LOG.d_proc) THEN

1807: p_id_tbl => l_reject_list,
1808: p_cascade => FND_API.G_TRUE
1809: );
1810:
1811: IF (PO_LOG.d_proc) THEN
1812: PO_LOG.proc_end (d_module);
1813: END IF;
1814: EXCEPTION
1815: WHEN OTHERS THEN

Line 1812: PO_LOG.proc_end (d_module);

1808: p_cascade => FND_API.G_TRUE
1809: );
1810:
1811: IF (PO_LOG.d_proc) THEN
1812: PO_LOG.proc_end (d_module);
1813: END IF;
1814: EXCEPTION
1815: WHEN OTHERS THEN
1816: PO_MESSAGE_S.add_exc_msg

Line 1847: IF (PO_LOG.d_proc) THEN

1843: BEGIN
1844:
1845: d_position := 0;
1846:
1847: IF (PO_LOG.d_proc) THEN
1848: PO_LOG.proc_begin (d_module);
1849: END IF;
1850:
1851: -- For ORIGINAL, ADD or REPLACE action, new document will be created

Line 1848: PO_LOG.proc_begin (d_module);

1844:
1845: d_position := 0;
1846:
1847: IF (PO_LOG.d_proc) THEN
1848: PO_LOG.proc_begin (d_module);
1849: END IF;
1850:
1851: -- For ORIGINAL, ADD or REPLACE action, new document will be created
1852: -- Need to assign a new po_header_id

Line 1861: IF (PO_LOG.d_proc) THEN

1857: AND action IN (PO_PDOI_CONSTANTS.g_ACTION_ORIGINAL,
1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1859: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1860:
1861: IF (PO_LOG.d_proc) THEN
1862: PO_LOG.proc_end (d_module);
1863: END IF;
1864:
1865: EXCEPTION

Line 1862: PO_LOG.proc_end (d_module);

1858: PO_PDOI_CONSTANTS.g_ACTION_ADD,
1859: PO_PDOI_CONSTANTS.g_ACTION_REPLACE);
1860:
1861: IF (PO_LOG.d_proc) THEN
1862: PO_LOG.proc_end (d_module);
1863: END IF;
1864:
1865: EXCEPTION
1866: WHEN OTHERS THEN

Line 1925: IF (PO_LOG.d_proc) THEN

1921: l_intf_line_loc_tbl PO_TBL_NUMBER;
1922: BEGIN
1923: d_position := 0;
1924:
1925: IF (PO_LOG.d_proc) THEN
1926: PO_LOG.proc_begin (d_module);
1927: END IF;
1928:
1929: OPEN c_line_intf;

Line 1926: PO_LOG.proc_begin (d_module);

1922: BEGIN
1923: d_position := 0;
1924:
1925: IF (PO_LOG.d_proc) THEN
1926: PO_LOG.proc_begin (d_module);
1927: END IF;
1928:
1929: OPEN c_line_intf;
1930:

Line 1941: IF (PO_LOG.d_stmt) THEN

1937: d_position := 10;
1938:
1939: EXIT WHEN l_rowid_tbl.COUNT = 0;
1940:
1941: IF (PO_LOG.d_stmt) THEN
1942: PO_LOG.stmt(d_module, d_position, 'number of lines fetched: ' ||
1943: l_rowid_tbl.COUNT);
1944: END IF;
1945:

Line 1942: PO_LOG.stmt(d_module, d_position, 'number of lines fetched: ' ||

1938:
1939: EXIT WHEN l_rowid_tbl.COUNT = 0;
1940:
1941: IF (PO_LOG.d_stmt) THEN
1942: PO_LOG.stmt(d_module, d_position, 'number of lines fetched: ' ||
1943: l_rowid_tbl.COUNT);
1944: END IF;
1945:
1946: FORALL i IN 1..l_rowid_tbl.COUNT

Line 2152: IF (PO_LOG.d_proc) THEN

2148: SET line_loc_populated_flag = 'S'
2149: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
2150: AND NVL(line_loc_populated_flag, 'N') = 'N';
2151:
2152: IF (PO_LOG.d_proc) THEN
2153: PO_LOG.proc_end (d_module);
2154: END IF;
2155:
2156: EXCEPTION

Line 2153: PO_LOG.proc_end (d_module);

2149: WHERE processing_id = PO_PDOI_PARAMS.g_processing_id
2150: AND NVL(line_loc_populated_flag, 'N') = 'N';
2151:
2152: IF (PO_LOG.d_proc) THEN
2153: PO_LOG.proc_end (d_module);
2154: END IF;
2155:
2156: EXCEPTION
2157: WHEN OTHERS THEN