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

Line 84: IF (PO_LOG.d_proc) THEN

80: l_return_value BOOLEAN;
81:
82: BEGIN
83:
84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin(d_module);
86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

Line 85: PO_LOG.proc_begin(d_module);

81:
82: BEGIN
83:
84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin(d_module);
86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);

Line 86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

82: BEGIN
83:
84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin(d_module);
86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);

Line 87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);

83:
84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin(d_module);
86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);

Line 88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

84: IF (PO_LOG.d_proc) THEN
85: PO_LOG.proc_begin(d_module);
86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);

Line 89: PO_LOG.proc_begin(d_module, 'p_action', p_action);

85: PO_LOG.proc_begin(d_module);
86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);

Line 90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);

86: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);
94: PO_LOG.proc_begin(d_module, 'p_ordered_uom', p_ordered_uom);

Line 91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);

87: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);
94: PO_LOG.proc_begin(d_module, 'p_ordered_uom', p_ordered_uom);
95: END IF;

Line 92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);

88: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);
94: PO_LOG.proc_begin(d_module, 'p_ordered_uom', p_ordered_uom);
95: END IF;
96:

Line 93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);

89: PO_LOG.proc_begin(d_module, 'p_action', p_action);
90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);
94: PO_LOG.proc_begin(d_module, 'p_ordered_uom', p_ordered_uom);
95: END IF;
96:
97: d_progress := 10;

Line 94: PO_LOG.proc_begin(d_module, 'p_ordered_uom', p_ordered_uom);

90: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
91: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
92: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
93: PO_LOG.proc_begin(d_module, 'p_reservation_action', p_reservation_action);
94: PO_LOG.proc_begin(d_module, 'p_ordered_uom', p_ordered_uom);
95: END IF;
96:
97: d_progress := 10;
98:

Line 326: IF (PO_LOG.d_stmt) THEN

322: END IF; -- Switchboard
323:
324: IF (NOT l_return_value) THEN
325:
326: IF (PO_LOG.d_stmt) THEN
327: PO_LOG.stmt(d_module, d_progress, 'Supply action failed.');
328: END IF;
329:
330: RAISE PO_CORE_S.g_early_return_exc;

Line 327: PO_LOG.stmt(d_module, d_progress, 'Supply action failed.');

323:
324: IF (NOT l_return_value) THEN
325:
326: IF (PO_LOG.d_stmt) THEN
327: PO_LOG.stmt(d_module, d_progress, 'Supply action failed.');
328: END IF;
329:
330: RAISE PO_CORE_S.g_early_return_exc;
331:

Line 341: IF (PO_LOG.d_stmt) THEN

337: l_return_value := maintain_mtl_supply;
338:
339: IF (NOT l_return_value) THEN
340:
341: IF (PO_LOG.d_stmt) THEN
342: PO_LOG.stmt(d_module, d_progress, 'maintain_mtl_supply not successful.');
343: END IF;
344:
345: RAISE PO_CORE_S.g_early_return_exc;

Line 342: PO_LOG.stmt(d_module, d_progress, 'maintain_mtl_supply not successful.');

338:
339: IF (NOT l_return_value) THEN
340:
341: IF (PO_LOG.d_stmt) THEN
342: PO_LOG.stmt(d_module, d_progress, 'maintain_mtl_supply not successful.');
343: END IF;
344:
345: RAISE PO_CORE_S.g_early_return_exc;
346:

Line 361: IF (PO_LOG.d_stmt) THEN

357: IF (UPPER(p_reservation_action) = 'UPDATE_SO_QUANTITY') THEN
358:
359: d_progress := 710;
360:
361: IF (PO_LOG.d_stmt) THEN
362: PO_LOG.stmt(d_module, d_progress, 'p_reservation_action', p_reservation_action);
363: END IF;
364:
365: PO_RESERVATION_MAINTAIN_SV.MAINTAIN_RESERVATION(

Line 362: PO_LOG.stmt(d_module, d_progress, 'p_reservation_action', p_reservation_action);

358:
359: d_progress := 710;
360:
361: IF (PO_LOG.d_stmt) THEN
362: PO_LOG.stmt(d_module, d_progress, 'p_reservation_action', p_reservation_action);
363: END IF;
364:
365: PO_RESERVATION_MAINTAIN_SV.MAINTAIN_RESERVATION(
366: p_header_id => p_docid

Line 380: IF (PO_LOG.d_stmt) THEN

376: --Bug5060175 START
377: ELSIF p_action = 'Explode_Req' THEN
378:
379: d_progress := 720;
380: IF (PO_LOG.d_stmt) THEN
381: PO_LOG.stmt(d_module, d_progress, 'Calling PO Maintain Reservations for Req split');
382: END IF;
383:
384: select requisition_header_id

Line 381: PO_LOG.stmt(d_module, d_progress, 'Calling PO Maintain Reservations for Req split');

377: ELSIF p_action = 'Explode_Req' THEN
378:
379: d_progress := 720;
380: IF (PO_LOG.d_stmt) THEN
381: PO_LOG.stmt(d_module, d_progress, 'Calling PO Maintain Reservations for Req split');
382: END IF;
383:
384: select requisition_header_id
385: into l_doc_id

Line 422: IF (PO_LOG.d_stmt) THEN

418: -- it would better to filter out these actions at this point, to facilate better
419: -- maintenance
420:
421: d_progress := 730;
422: IF (PO_LOG.d_stmt) THEN
423: PO_LOG.stmt(d_module, d_progress, 'Calling PO Maintain Reservations');
424: END IF;
425:
426: PO_RESERVATION_MAINTAIN_SV.MAINTAIN_RESERVATION(

Line 423: PO_LOG.stmt(d_module, d_progress, 'Calling PO Maintain Reservations');

419: -- maintenance
420:
421: d_progress := 730;
422: IF (PO_LOG.d_stmt) THEN
423: PO_LOG.stmt(d_module, d_progress, 'Calling PO Maintain Reservations');
424: END IF;
425:
426: PO_RESERVATION_MAINTAIN_SV.MAINTAIN_RESERVATION(
427: p_header_id => p_docid

Line 440: IF (PO_LOG.d_stmt) THEN

436:
437: d_progress := 800;
438:
439: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
440: IF (PO_LOG.d_stmt) THEN
441: PO_LOG.stmt(d_module, d_progress, 'Reservation api failed.');
442: END IF;
443:
444: l_return_value := FALSE;

Line 441: PO_LOG.stmt(d_module, d_progress, 'Reservation api failed.');

437: d_progress := 800;
438:
439: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
440: IF (PO_LOG.d_stmt) THEN
441: PO_LOG.stmt(d_module, d_progress, 'Reservation api failed.');
442: END IF;
443:
444: l_return_value := FALSE;
445: RAISE PO_CORE_S.g_early_return_exc;

Line 459: IF (PO_LOG.d_proc) THEN

455: WHEN PO_CORE_S.g_early_return_exc THEN
456: NULL;
457: END;
458:
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_return(d_module, l_return_value);
461: PO_LOG.proc_end(d_module);
462: END IF;
463:

Line 460: PO_LOG.proc_return(d_module, l_return_value);

456: NULL;
457: END;
458:
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_return(d_module, l_return_value);
461: PO_LOG.proc_end(d_module);
462: END IF;
463:
464: return(l_return_value);

Line 461: PO_LOG.proc_end(d_module);

457: END;
458:
459: IF (PO_LOG.d_proc) THEN
460: PO_LOG.proc_return(d_module, l_return_value);
461: PO_LOG.proc_end(d_module);
462: END IF;
463:
464: return(l_return_value);
465:

Line 470: IF (PO_LOG.d_exc) THEN

466:
467: EXCEPTION
468:
469: WHEN others THEN
470: IF (PO_LOG.d_exc) THEN
471: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
472: END IF;
473:
474: return(FALSE);

Line 471: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

467: EXCEPTION
468:
469: WHEN others THEN
470: IF (PO_LOG.d_exc) THEN
471: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
472: END IF;
473:
474: return(FALSE);
475:

Line 508: IF (PO_LOG.d_proc) THEN

504: l_return_value BOOLEAN := FALSE;
505:
506: BEGIN
507:
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_begin(d_module);
510: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
511: END IF;
512:

Line 509: PO_LOG.proc_begin(d_module);

505:
506: BEGIN
507:
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_begin(d_module);
510: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
511: END IF;
512:
513: d_progress := 10;

Line 510: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

506: BEGIN
507:
508: IF (PO_LOG.d_proc) THEN
509: PO_LOG.proc_begin(d_module);
510: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
511: END IF;
512:
513: d_progress := 10;
514:

Line 536: IF (PO_LOG.d_stmt) THEN

532: );
533:
534: IF (NOT l_return_value) THEN
535:
536: IF (PO_LOG.d_stmt) THEN
537: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
538: END IF;
539:
540: RAISE PO_CORE_S.g_early_return_exc;

Line 537: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

533:
534: IF (NOT l_return_value) THEN
535:
536: IF (PO_LOG.d_stmt) THEN
537: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
538: END IF;
539:
540: RAISE PO_CORE_S.g_early_return_exc;
541: END IF;

Line 564: IF (PO_LOG.d_stmt) THEN

560: );
561:
562: d_progress := 50;
563:
564: IF (PO_LOG.d_stmt) THEN
565: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows.');
566: END IF;
567:
568: END IF; -- if (l_auth_status = 'APPROVED')...

Line 565: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows.');

561:
562: d_progress := 50;
563:
564: IF (PO_LOG.d_stmt) THEN
565: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows.');
566: END IF;
567:
568: END IF; -- if (l_auth_status = 'APPROVED')...
569:

Line 577: IF (PO_LOG.d_proc) THEN

573: WHEN PO_CORE_S.g_early_return_exc THEN
574: NULL;
575: END;
576:
577: IF (PO_LOG.d_proc) THEN
578: PO_LOG.proc_return(d_module, l_return_value);
579: PO_LOG.proc_end(d_module);
580: END IF;
581:

Line 578: PO_LOG.proc_return(d_module, l_return_value);

574: NULL;
575: END;
576:
577: IF (PO_LOG.d_proc) THEN
578: PO_LOG.proc_return(d_module, l_return_value);
579: PO_LOG.proc_end(d_module);
580: END IF;
581:
582: return (l_return_value);

Line 579: PO_LOG.proc_end(d_module);

575: END;
576:
577: IF (PO_LOG.d_proc) THEN
578: PO_LOG.proc_return(d_module, l_return_value);
579: PO_LOG.proc_end(d_module);
580: END IF;
581:
582: return (l_return_value);
583:

Line 591: IF (PO_LOG.d_exc) THEN

587: IF auth_status%ISOPEN THEN
588: close auth_status;
589: END IF;
590:
591: IF (PO_LOG.d_exc) THEN
592: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
593: END IF;
594:
595: return(FALSE);

Line 592: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

588: close auth_status;
589: END IF;
590:
591: IF (PO_LOG.d_exc) THEN
592: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
593: END IF;
594:
595: return(FALSE);
596:

Line 628: IF (PO_LOG.d_proc) THEN

624: l_return_value BOOLEAN := FALSE;
625:
626: BEGIN
627:
628: IF (PO_LOG.d_proc) THEN
629: PO_LOG.proc_begin(d_module);
630: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
631: END IF;
632:

Line 629: PO_LOG.proc_begin(d_module);

625:
626: BEGIN
627:
628: IF (PO_LOG.d_proc) THEN
629: PO_LOG.proc_begin(d_module);
630: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
631: END IF;
632:
633: d_progress := 10;

Line 630: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

626: BEGIN
627:
628: IF (PO_LOG.d_proc) THEN
629: PO_LOG.proc_begin(d_module);
630: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
631: END IF;
632:
633: d_progress := 10;
634:

Line 656: IF (PO_LOG.d_stmt) THEN

652: );
653:
654: IF (NOT l_return_value) THEN
655:
656: IF (PO_LOG.d_stmt) THEN
657: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
658: END IF;
659:
660: RAISE PO_CORE_S.g_early_return_exc;

Line 657: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

653:
654: IF (NOT l_return_value) THEN
655:
656: IF (PO_LOG.d_stmt) THEN
657: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
658: END IF;
659:
660: RAISE PO_CORE_S.g_early_return_exc;
661: END IF;

Line 684: IF (PO_LOG.d_stmt) THEN

680: );
681:
682: d_progress := 50;
683:
684: IF (PO_LOG.d_stmt) THEN
685: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows.');
686: END IF;
687:
688: END IF; -- if (l_auth_status = 'APPROVED')...

Line 685: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows.');

681:
682: d_progress := 50;
683:
684: IF (PO_LOG.d_stmt) THEN
685: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows.');
686: END IF;
687:
688: END IF; -- if (l_auth_status = 'APPROVED')...
689:

Line 697: IF (PO_LOG.d_proc) THEN

693: WHEN PO_CORE_S.g_early_return_exc THEN
694: NULL;
695: END;
696:
697: IF (PO_LOG.d_proc) THEN
698: PO_LOG.proc_return(d_module, l_return_value);
699: PO_LOG.proc_end(d_module);
700: END IF;
701:

Line 698: PO_LOG.proc_return(d_module, l_return_value);

694: NULL;
695: END;
696:
697: IF (PO_LOG.d_proc) THEN
698: PO_LOG.proc_return(d_module, l_return_value);
699: PO_LOG.proc_end(d_module);
700: END IF;
701:
702: return (l_return_value);

Line 699: PO_LOG.proc_end(d_module);

695: END;
696:
697: IF (PO_LOG.d_proc) THEN
698: PO_LOG.proc_return(d_module, l_return_value);
699: PO_LOG.proc_end(d_module);
700: END IF;
701:
702: return (l_return_value);
703:

Line 711: IF (PO_LOG.d_exc) THEN

707: IF auth_status%ISOPEN THEN
708: close auth_status;
709: END IF;
710:
711: IF (PO_LOG.d_exc) THEN
712: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
713: END IF;
714:
715: return(FALSE);

Line 712: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

708: close auth_status;
709: END IF;
710:
711: IF (PO_LOG.d_exc) THEN
712: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
713: END IF;
714:
715: return(FALSE);
716:

Line 748: IF (PO_LOG.d_proc) THEN

744: l_return_value BOOLEAN := FALSE;
745:
746: BEGIN
747:
748: IF (PO_LOG.d_proc) THEN
749: PO_LOG.proc_begin(d_module);
750: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
751: END IF;
752:

Line 749: PO_LOG.proc_begin(d_module);

745:
746: BEGIN
747:
748: IF (PO_LOG.d_proc) THEN
749: PO_LOG.proc_begin(d_module);
750: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
751: END IF;
752:
753: d_progress := 10;

Line 750: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

746: BEGIN
747:
748: IF (PO_LOG.d_proc) THEN
749: PO_LOG.proc_begin(d_module);
750: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
751: END IF;
752:
753: d_progress := 10;
754:

Line 777: IF (PO_LOG.d_stmt) THEN

773: );
774:
775: IF (NOT l_return_value) THEN
776:
777: IF (PO_LOG.d_stmt) THEN
778: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
779: END IF;
780:
781: RAISE PO_CORE_S.g_early_return_exc;

Line 778: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

774:
775: IF (NOT l_return_value) THEN
776:
777: IF (PO_LOG.d_stmt) THEN
778: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
779: END IF;
780:
781: RAISE PO_CORE_S.g_early_return_exc;
782: END IF;

Line 802: IF (PO_LOG.d_stmt) THEN

798: );
799:
800: IF (NOT l_return_value) THEN
801:
802: IF (PO_LOG.d_stmt) THEN
803: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
804: END IF;
805:
806: RAISE PO_CORE_S.g_early_return_exc;

Line 803: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');

799:
800: IF (NOT l_return_value) THEN
801:
802: IF (PO_LOG.d_stmt) THEN
803: PO_LOG.stmt(d_module, d_progress, 'create_po_supply not successful');
804: END IF;
805:
806: RAISE PO_CORE_S.g_early_return_exc;
807: END IF;

Line 820: IF (PO_LOG.d_proc) THEN

816: WHEN PO_CORE_S.g_early_return_exc THEN
817: NULL;
818: END;
819:
820: IF (PO_LOG.d_proc) THEN
821: PO_LOG.proc_return(d_module, l_return_value);
822: PO_LOG.proc_end(d_module);
823: END IF;
824:

Line 821: PO_LOG.proc_return(d_module, l_return_value);

817: NULL;
818: END;
819:
820: IF (PO_LOG.d_proc) THEN
821: PO_LOG.proc_return(d_module, l_return_value);
822: PO_LOG.proc_end(d_module);
823: END IF;
824:
825: return (l_return_value);

Line 822: PO_LOG.proc_end(d_module);

818: END;
819:
820: IF (PO_LOG.d_proc) THEN
821: PO_LOG.proc_return(d_module, l_return_value);
822: PO_LOG.proc_end(d_module);
823: END IF;
824:
825: return (l_return_value);
826:

Line 834: IF (PO_LOG.d_exc) THEN

830: IF auth_status%ISOPEN THEN
831: close auth_status;
832: END IF;
833:
834: IF (PO_LOG.d_exc) THEN
835: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
836: END IF;
837:
838: return(FALSE);

Line 835: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

831: close auth_status;
832: END IF;
833:
834: IF (PO_LOG.d_exc) THEN
835: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
836: END IF;
837:
838: return(FALSE);
839:

Line 949: IF (PO_LOG.d_proc) THEN

945: --
946:
947: BEGIN
948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_begin(d_module);
951: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
952: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
953: END IF;

Line 950: PO_LOG.proc_begin(d_module);

946:
947: BEGIN
948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_begin(d_module);
951: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
952: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
953: END IF;
954:

Line 951: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

947: BEGIN
948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_begin(d_module);
951: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
952: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
953: END IF;
954:
955: d_progress := 10;

Line 952: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

948:
949: IF (PO_LOG.d_proc) THEN
950: PO_LOG.proc_begin(d_module);
951: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
952: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
953: END IF;
954:
955: d_progress := 10;
956:

Line 966: IF (PO_LOG.d_stmt) THEN

962: );
963:
964: IF (NOT l_return_value) THEN
965:
966: IF (PO_LOG.d_stmt) THEN
967: PO_LOG.stmt(d_module, d_progress, 'delete_supply not successful');
968: END IF;
969:
970: RAISE PO_CORE_S.g_early_return_exc;

Line 967: PO_LOG.stmt(d_module, d_progress, 'delete_supply not successful');

963:
964: IF (NOT l_return_value) THEN
965:
966: IF (PO_LOG.d_stmt) THEN
967: PO_LOG.stmt(d_module, d_progress, 'delete_supply not successful');
968: END IF;
969:
970: RAISE PO_CORE_S.g_early_return_exc;
971:

Line 1036: IF (PO_LOG.d_stmt) THEN

1032:
1033: -- : Add order-by clause as in Pro*C
1034: sql_dist := sql_dist || 'ORDER BY pd.line_location_id';
1035:
1036: IF (PO_LOG.d_stmt) THEN
1037: PO_LOG.stmt(d_module, d_progress, 'sql_dist', sql_dist);
1038: END IF;
1039:
1040: d_progress := 70;

Line 1037: PO_LOG.stmt(d_module, d_progress, 'sql_dist', sql_dist);

1033: -- : Add order-by clause as in Pro*C
1034: sql_dist := sql_dist || 'ORDER BY pd.line_location_id';
1035:
1036: IF (PO_LOG.d_stmt) THEN
1037: PO_LOG.stmt(d_module, d_progress, 'sql_dist', sql_dist);
1038: END IF;
1039:
1040: d_progress := 70;
1041:

Line 1067: IF (PO_LOG.d_stmt) THEN

1063: dbms_sql.column_value(cur_dist, 3, l_uom);
1064: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1065:
1066:
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);
1069: PO_LOG.stmt(d_module, d_progress, 'l_qty', l_qty);
1070: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
1071: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);

Line 1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);

1064: dbms_sql.column_value(cur_dist, 4, l_line_loc_id);
1065:
1066:
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);
1069: PO_LOG.stmt(d_module, d_progress, 'l_qty', l_qty);
1070: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
1071: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1072: END IF;

Line 1069: PO_LOG.stmt(d_module, d_progress, 'l_qty', l_qty);

1065:
1066:
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);
1069: PO_LOG.stmt(d_module, d_progress, 'l_qty', l_qty);
1070: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
1071: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1072: END IF;
1073:

Line 1070: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);

1066:
1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);
1069: PO_LOG.stmt(d_module, d_progress, 'l_qty', l_qty);
1070: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
1071: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1072: END IF;
1073:
1074: -- : From Pro*C

Line 1071: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);

1067: IF (PO_LOG.d_stmt) THEN
1068: PO_LOG.stmt(d_module, d_progress, 'l_distid', l_distid);
1069: PO_LOG.stmt(d_module, d_progress, 'l_qty', l_qty);
1070: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
1071: PO_LOG.stmt(d_module, d_progress, 'l_line_loc_id', l_line_loc_id);
1072: END IF;
1073:
1074: -- : From Pro*C
1075: -- For PO distribution, get the sum of quantity already

Line 1099: IF (PO_LOG.d_stmt) THEN

1095: l_released_qty := 0;
1096:
1097: END IF; -- p_entity IN ...
1098:
1099: IF (PO_LOG.d_stmt) THEN
1100: PO_LOG.stmt(d_module, d_progress, 'l_released_qty', l_released_qty);
1101: END IF;
1102:
1103: --

Line 1100: PO_LOG.stmt(d_module, d_progress, 'l_released_qty', l_released_qty);

1096:
1097: END IF; -- p_entity IN ...
1098:
1099: IF (PO_LOG.d_stmt) THEN
1100: PO_LOG.stmt(d_module, d_progress, 'l_released_qty', l_released_qty);
1101: END IF;
1102:
1103: --
1104:

Line 1173: IF (PO_LOG.d_stmt) THEN

1169:
1170: FETCH supply_lloc INTO l_supply_qty, l_supply_uom, l_supply_itemid;
1171: EXIT WHEN supply_lloc%NOTFOUND;
1172:
1173: IF (PO_LOG.d_stmt) THEN
1174: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty', l_supply_qty);
1175: PO_LOG.stmt(d_module, d_progress, 'l_supply_uom', l_supply_uom);
1176: PO_LOG.stmt(d_module, d_progress, 'l_supply_itemid', l_supply_itemid);
1177: END IF;

Line 1174: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty', l_supply_qty);

1170: FETCH supply_lloc INTO l_supply_qty, l_supply_uom, l_supply_itemid;
1171: EXIT WHEN supply_lloc%NOTFOUND;
1172:
1173: IF (PO_LOG.d_stmt) THEN
1174: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty', l_supply_qty);
1175: PO_LOG.stmt(d_module, d_progress, 'l_supply_uom', l_supply_uom);
1176: PO_LOG.stmt(d_module, d_progress, 'l_supply_itemid', l_supply_itemid);
1177: END IF;
1178:

Line 1175: PO_LOG.stmt(d_module, d_progress, 'l_supply_uom', l_supply_uom);

1171: EXIT WHEN supply_lloc%NOTFOUND;
1172:
1173: IF (PO_LOG.d_stmt) THEN
1174: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty', l_supply_qty);
1175: PO_LOG.stmt(d_module, d_progress, 'l_supply_uom', l_supply_uom);
1176: PO_LOG.stmt(d_module, d_progress, 'l_supply_itemid', l_supply_itemid);
1177: END IF;
1178:
1179: d_progress := 120;

Line 1176: PO_LOG.stmt(d_module, d_progress, 'l_supply_itemid', l_supply_itemid);

1172:
1173: IF (PO_LOG.d_stmt) THEN
1174: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty', l_supply_qty);
1175: PO_LOG.stmt(d_module, d_progress, 'l_supply_uom', l_supply_uom);
1176: PO_LOG.stmt(d_module, d_progress, 'l_supply_itemid', l_supply_itemid);
1177: END IF;
1178:
1179: d_progress := 120;
1180:

Line 1204: IF (PO_LOG.d_stmt) THEN

1200: END IF;
1201:
1202: d_progress := 130;
1203:
1204: IF (PO_LOG.d_stmt) THEN
1205: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);
1206: END IF;
1207:
1208: END IF; --

Line 1205: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);

1201:
1202: d_progress := 130;
1203:
1204: IF (PO_LOG.d_stmt) THEN
1205: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);
1206: END IF;
1207:
1208: END IF; --
1209:

Line 1264: IF (PO_LOG.d_stmt) THEN

1260: END IF;
1261:
1262: d_progress := 140;
1263:
1264: IF (PO_LOG.d_stmt) THEN
1265: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);
1266: PO_LOG.stmt(d_module, d_progress, 'l_out_poqty', l_out_poqty);
1267: END IF;
1268:

Line 1265: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);

1261:
1262: d_progress := 140;
1263:
1264: IF (PO_LOG.d_stmt) THEN
1265: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);
1266: PO_LOG.stmt(d_module, d_progress, 'l_out_poqty', l_out_poqty);
1267: END IF;
1268:
1269: -- Create PO Supply

Line 1266: PO_LOG.stmt(d_module, d_progress, 'l_out_poqty', l_out_poqty);

1262: d_progress := 140;
1263:
1264: IF (PO_LOG.d_stmt) THEN
1265: PO_LOG.stmt(d_module, d_progress, 'l_supply_qty_in_pouom', l_supply_qty_in_pouom);
1266: PO_LOG.stmt(d_module, d_progress, 'l_out_poqty', l_out_poqty);
1267: END IF;
1268:
1269: -- Create PO Supply
1270: /*Bug 4537860:Hit the _all tables instead of the striped views.*/

Line 1365: IF (PO_LOG.d_proc) THEN

1361: IF (dbms_sql.is_open(cur_dist)) THEN
1362: dbms_sql.close_cursor(cur_dist);
1363: END IF;
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_return(d_module, l_return_value);
1367: PO_LOG.proc_end(d_module);
1368: END IF;
1369:

Line 1366: PO_LOG.proc_return(d_module, l_return_value);

1362: dbms_sql.close_cursor(cur_dist);
1363: END IF;
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_return(d_module, l_return_value);
1367: PO_LOG.proc_end(d_module);
1368: END IF;
1369:
1370: return (l_return_value);

Line 1367: PO_LOG.proc_end(d_module);

1363: END IF;
1364:
1365: IF (PO_LOG.d_proc) THEN
1366: PO_LOG.proc_return(d_module, l_return_value);
1367: PO_LOG.proc_end(d_module);
1368: END IF;
1369:
1370: return (l_return_value);
1371:

Line 1384: IF (PO_LOG.d_exc) THEN

1380: IF (dbms_sql.is_open(cur_dist)) THEN
1381: dbms_sql.close_cursor(cur_dist);
1382: END IF;
1383:
1384: IF (PO_LOG.d_exc) THEN
1385: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1386: END IF;
1387:
1388: return(FALSE);

Line 1385: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1381: dbms_sql.close_cursor(cur_dist);
1382: END IF;
1383:
1384: IF (PO_LOG.d_exc) THEN
1385: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1386: END IF;
1387:
1388: return(FALSE);
1389:

Line 1425: IF (PO_LOG.d_proc) THEN

1421: d_progress NUMBER;
1422:
1423: BEGIN
1424:
1425: IF (PO_LOG.d_proc) THEN
1426: PO_LOG.proc_begin(d_module);
1427: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1428: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1429: END IF;

Line 1426: PO_LOG.proc_begin(d_module);

1422:
1423: BEGIN
1424:
1425: IF (PO_LOG.d_proc) THEN
1426: PO_LOG.proc_begin(d_module);
1427: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1428: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1429: END IF;
1430:

Line 1427: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

1423: BEGIN
1424:
1425: IF (PO_LOG.d_proc) THEN
1426: PO_LOG.proc_begin(d_module);
1427: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1428: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1429: END IF;
1430:
1431: d_progress := 10;

Line 1428: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

1424:
1425: IF (PO_LOG.d_proc) THEN
1426: PO_LOG.proc_begin(d_module);
1427: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1428: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1429: END IF;
1430:
1431: d_progress := 10;
1432:

Line 1463: IF (PO_LOG.d_stmt) THEN

1459: END IF;
1460:
1461: d_progress := 30;
1462:
1463: IF (PO_LOG.d_stmt) THEN
1464: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' records');
1465: END IF;
1466:
1467: IF (PO_LOG.d_proc) THEN

Line 1464: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' records');

1460:
1461: d_progress := 30;
1462:
1463: IF (PO_LOG.d_stmt) THEN
1464: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' records');
1465: END IF;
1466:
1467: IF (PO_LOG.d_proc) THEN
1468: PO_LOG.proc_return(d_module, TRUE);

Line 1467: IF (PO_LOG.d_proc) THEN

1463: IF (PO_LOG.d_stmt) THEN
1464: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' records');
1465: END IF;
1466:
1467: IF (PO_LOG.d_proc) THEN
1468: PO_LOG.proc_return(d_module, TRUE);
1469: PO_LOG.proc_end(d_module);
1470: END IF;
1471:

Line 1468: PO_LOG.proc_return(d_module, TRUE);

1464: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' records');
1465: END IF;
1466:
1467: IF (PO_LOG.d_proc) THEN
1468: PO_LOG.proc_return(d_module, TRUE);
1469: PO_LOG.proc_end(d_module);
1470: END IF;
1471:
1472: return(TRUE);

Line 1469: PO_LOG.proc_end(d_module);

1465: END IF;
1466:
1467: IF (PO_LOG.d_proc) THEN
1468: PO_LOG.proc_return(d_module, TRUE);
1469: PO_LOG.proc_end(d_module);
1470: END IF;
1471:
1472: return(TRUE);
1473:

Line 1477: IF (PO_LOG.d_exc) THEN

1473:
1474: EXCEPTION
1475:
1476: WHEN others THEN
1477: IF (PO_LOG.d_exc) THEN
1478: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1479: END IF;
1480:
1481: return(FALSE);

Line 1478: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1474: EXCEPTION
1475:
1476: WHEN others THEN
1477: IF (PO_LOG.d_exc) THEN
1478: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1479: END IF;
1480:
1481: return(FALSE);
1482:

Line 1519: IF (PO_LOG.d_proc) THEN

1515: d_progress NUMBER;
1516:
1517: BEGIN
1518:
1519: IF (PO_LOG.d_proc) THEN
1520: PO_LOG.proc_begin(d_module);
1521: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1522: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1523: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

Line 1520: PO_LOG.proc_begin(d_module);

1516:
1517: BEGIN
1518:
1519: IF (PO_LOG.d_proc) THEN
1520: PO_LOG.proc_begin(d_module);
1521: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1522: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1523: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1524: END IF;

Line 1521: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

1517: BEGIN
1518:
1519: IF (PO_LOG.d_proc) THEN
1520: PO_LOG.proc_begin(d_module);
1521: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1522: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1523: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1524: END IF;
1525:

Line 1522: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

1518:
1519: IF (PO_LOG.d_proc) THEN
1520: PO_LOG.proc_begin(d_module);
1521: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1522: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1523: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1524: END IF;
1525:
1526: d_progress := 10;

Line 1523: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

1519: IF (PO_LOG.d_proc) THEN
1520: PO_LOG.proc_begin(d_module);
1521: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1522: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1523: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1524: END IF;
1525:
1526: d_progress := 10;
1527:

Line 1558: IF (PO_LOG.d_stmt) THEN

1554: END IF;
1555:
1556: d_progress := 30;
1557:
1558: IF (PO_LOG.d_stmt) THEN
1559: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' records');
1560: END IF;
1561:
1562: IF (PO_LOG.d_proc) THEN

Line 1559: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' records');

1555:
1556: d_progress := 30;
1557:
1558: IF (PO_LOG.d_stmt) THEN
1559: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' records');
1560: END IF;
1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_return(d_module, TRUE);

Line 1562: IF (PO_LOG.d_proc) THEN

1558: IF (PO_LOG.d_stmt) THEN
1559: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' records');
1560: END IF;
1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_return(d_module, TRUE);
1564: PO_LOG.proc_end(d_module);
1565: END IF;
1566:

Line 1563: PO_LOG.proc_return(d_module, TRUE);

1559: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' records');
1560: END IF;
1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_return(d_module, TRUE);
1564: PO_LOG.proc_end(d_module);
1565: END IF;
1566:
1567: return(TRUE);

Line 1564: PO_LOG.proc_end(d_module);

1560: END IF;
1561:
1562: IF (PO_LOG.d_proc) THEN
1563: PO_LOG.proc_return(d_module, TRUE);
1564: PO_LOG.proc_end(d_module);
1565: END IF;
1566:
1567: return(TRUE);
1568:

Line 1572: IF (PO_LOG.d_exc) THEN

1568:
1569: EXCEPTION
1570:
1571: WHEN others THEN
1572: IF (PO_LOG.d_exc) THEN
1573: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1574: END IF;
1575:
1576: return(FALSE);

Line 1573: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1569: EXCEPTION
1570:
1571: WHEN others THEN
1572: IF (PO_LOG.d_exc) THEN
1573: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1574: END IF;
1575:
1576: return(FALSE);
1577:

Line 1616: IF (PO_LOG.d_proc) THEN

1612: l_return_value BOOLEAN := FALSE;
1613:
1614: BEGIN
1615:
1616: IF (PO_LOG.d_proc) THEN
1617: PO_LOG.proc_begin(d_module);
1618: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1619: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1620: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

Line 1617: PO_LOG.proc_begin(d_module);

1613:
1614: BEGIN
1615:
1616: IF (PO_LOG.d_proc) THEN
1617: PO_LOG.proc_begin(d_module);
1618: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1619: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1620: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1621: END IF;

Line 1618: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

1614: BEGIN
1615:
1616: IF (PO_LOG.d_proc) THEN
1617: PO_LOG.proc_begin(d_module);
1618: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1619: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1620: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1621: END IF;
1622:

Line 1619: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

1615:
1616: IF (PO_LOG.d_proc) THEN
1617: PO_LOG.proc_begin(d_module);
1618: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1619: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1620: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1621: END IF;
1622:
1623: d_progress := 10;

Line 1620: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

1616: IF (PO_LOG.d_proc) THEN
1617: PO_LOG.proc_begin(d_module);
1618: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1619: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1620: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1621: END IF;
1622:
1623: d_progress := 10;
1624:

Line 1666: IF (PO_LOG.d_proc) THEN

1662: );
1663:
1664: END IF;
1665:
1666: IF (PO_LOG.d_proc) THEN
1667: PO_LOG.proc_return(d_module, l_return_value);
1668: PO_LOG.proc_end(d_module);
1669: END IF;
1670:

Line 1667: PO_LOG.proc_return(d_module, l_return_value);

1663:
1664: END IF;
1665:
1666: IF (PO_LOG.d_proc) THEN
1667: PO_LOG.proc_return(d_module, l_return_value);
1668: PO_LOG.proc_end(d_module);
1669: END IF;
1670:
1671: return (l_return_value);

Line 1668: PO_LOG.proc_end(d_module);

1664: END IF;
1665:
1666: IF (PO_LOG.d_proc) THEN
1667: PO_LOG.proc_return(d_module, l_return_value);
1668: PO_LOG.proc_end(d_module);
1669: END IF;
1670:
1671: return (l_return_value);
1672:

Line 1676: IF (PO_LOG.d_exc) THEN

1672:
1673: EXCEPTION
1674:
1675: WHEN others THEN
1676: IF (PO_LOG.d_exc) THEN
1677: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1678: END IF;
1679:
1680: return(FALSE);

Line 1677: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1673: EXCEPTION
1674:
1675: WHEN others THEN
1676: IF (PO_LOG.d_exc) THEN
1677: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1678: END IF;
1679:
1680: return(FALSE);
1681:

Line 1732: IF (PO_LOG.d_proc) THEN

1728: l_return_value BOOLEAN := FALSE;
1729:
1730: BEGIN
1731:
1732: IF (PO_LOG.d_proc) THEN
1733: PO_LOG.proc_begin(d_module);
1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

Line 1733: PO_LOG.proc_begin(d_module);

1729:
1730: BEGIN
1731:
1732: IF (PO_LOG.d_proc) THEN
1733: PO_LOG.proc_begin(d_module);
1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1737: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);

Line 1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

1730: BEGIN
1731:
1732: IF (PO_LOG.d_proc) THEN
1733: PO_LOG.proc_begin(d_module);
1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1737: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
1738: END IF;

Line 1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

1731:
1732: IF (PO_LOG.d_proc) THEN
1733: PO_LOG.proc_begin(d_module);
1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1737: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
1738: END IF;
1739:

Line 1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

1732: IF (PO_LOG.d_proc) THEN
1733: PO_LOG.proc_begin(d_module);
1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1737: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
1738: END IF;
1739:
1740: d_progress := 10;

Line 1737: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);

1733: PO_LOG.proc_begin(d_module);
1734: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
1735: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
1736: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
1737: PO_LOG.proc_begin(d_module, 'p_recreate_flag', p_recreate_flag);
1738: END IF;
1739:
1740: d_progress := 10;
1741:

Line 1756: IF (PO_LOG.d_stmt) THEN

1752: , p_entity_type => 'RELEASE'
1753: );
1754:
1755: IF (NOT l_return_value) THEN
1756: IF (PO_LOG.d_stmt) THEN
1757: PO_LOG.stmt(d_module, d_progress, 'delete_supply not successful');
1758: END IF;
1759:
1760: RAISE PO_CORE_S.g_early_return_exc;

Line 1757: PO_LOG.stmt(d_module, d_progress, 'delete_supply not successful');

1753: );
1754:
1755: IF (NOT l_return_value) THEN
1756: IF (PO_LOG.d_stmt) THEN
1757: PO_LOG.stmt(d_module, d_progress, 'delete_supply not successful');
1758: END IF;
1759:
1760: RAISE PO_CORE_S.g_early_return_exc;
1761: END IF;

Line 1777: IF (PO_LOG.d_stmt) THEN

1773: , p_supply_flag => l_supply_flag
1774: );
1775:
1776: IF (NOT l_return_value) THEN
1777: IF (PO_LOG.d_stmt) THEN
1778: PO_LOG.stmt(d_module, d_progress, 'update_planned_po not successful');
1779: END IF;
1780:
1781: RAISE PO_CORE_S.g_early_return_exc;

Line 1778: PO_LOG.stmt(d_module, d_progress, 'update_planned_po not successful');

1774: );
1775:
1776: IF (NOT l_return_value) THEN
1777: IF (PO_LOG.d_stmt) THEN
1778: PO_LOG.stmt(d_module, d_progress, 'update_planned_po not successful');
1779: END IF;
1780:
1781: RAISE PO_CORE_S.g_early_return_exc;
1782: END IF;

Line 1797: IF (PO_LOG.d_stmt) THEN

1793: d_progress := 50;
1794:
1795: IF (rel%NOTFOUND) THEN
1796:
1797: IF (PO_LOG.d_stmt) THEN
1798: PO_LOG.stmt(d_module, d_progress, 'no rows in release cursor');
1799: END IF;
1800:
1801: l_return_value := TRUE;

Line 1798: PO_LOG.stmt(d_module, d_progress, 'no rows in release cursor');

1794:
1795: IF (rel%NOTFOUND) THEN
1796:
1797: IF (PO_LOG.d_stmt) THEN
1798: PO_LOG.stmt(d_module, d_progress, 'no rows in release cursor');
1799: END IF;
1800:
1801: l_return_value := TRUE;
1802: RAISE PO_CORE_S.g_early_return_exc;

Line 1829: IF (PO_LOG.d_stmt) THEN

1825: , p_shipid => p_shipid
1826: );
1827:
1828: IF (NOT l_return_value) THEN
1829: IF (PO_LOG.d_stmt) THEN
1830: PO_LOG.stmt(d_module, d_progress, 'update_supply not successful');
1831: END IF;
1832:
1833: RAISE PO_CORE_S.g_early_return_exc;

Line 1830: PO_LOG.stmt(d_module, d_progress, 'update_supply not successful');

1826: );
1827:
1828: IF (NOT l_return_value) THEN
1829: IF (PO_LOG.d_stmt) THEN
1830: PO_LOG.stmt(d_module, d_progress, 'update_supply not successful');
1831: END IF;
1832:
1833: RAISE PO_CORE_S.g_early_return_exc;
1834: END IF;

Line 1851: IF (PO_LOG.d_stmt) THEN

1847: , p_supply_flag => l_supply_flag
1848: );
1849:
1850: IF (NOT l_return_value) THEN
1851: IF (PO_LOG.d_stmt) THEN
1852: PO_LOG.stmt(d_module, d_progress, 'update_planned_po not successful');
1853: END IF;
1854:
1855: RAISE PO_CORE_S.g_early_return_exc;

Line 1852: PO_LOG.stmt(d_module, d_progress, 'update_planned_po not successful');

1848: );
1849:
1850: IF (NOT l_return_value) THEN
1851: IF (PO_LOG.d_stmt) THEN
1852: PO_LOG.stmt(d_module, d_progress, 'update_planned_po not successful');
1853: END IF;
1854:
1855: RAISE PO_CORE_S.g_early_return_exc;
1856: END IF;

Line 1885: IF (PO_LOG.d_proc) THEN

1881: IF (rel%ISOPEN) THEN
1882: CLOSE rel;
1883: END IF;
1884:
1885: IF (PO_LOG.d_proc) THEN
1886: PO_LOG.proc_return(d_module, l_return_value);
1887: PO_LOG.proc_end(d_module);
1888: END IF;
1889:

Line 1886: PO_LOG.proc_return(d_module, l_return_value);

1882: CLOSE rel;
1883: END IF;
1884:
1885: IF (PO_LOG.d_proc) THEN
1886: PO_LOG.proc_return(d_module, l_return_value);
1887: PO_LOG.proc_end(d_module);
1888: END IF;
1889:
1890: return (l_return_value);

Line 1887: PO_LOG.proc_end(d_module);

1883: END IF;
1884:
1885: IF (PO_LOG.d_proc) THEN
1886: PO_LOG.proc_return(d_module, l_return_value);
1887: PO_LOG.proc_end(d_module);
1888: END IF;
1889:
1890: return (l_return_value);
1891:

Line 1894: IF (PO_LOG.d_exc) THEN

1890: return (l_return_value);
1891:
1892: EXCEPTION
1893: WHEN others THEN
1894: IF (PO_LOG.d_exc) THEN
1895: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1896: END IF;
1897:
1898: IF (rel%ISOPEN) THEN

Line 1895: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1891:
1892: EXCEPTION
1893: WHEN others THEN
1894: IF (PO_LOG.d_exc) THEN
1895: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1896: END IF;
1897:
1898: IF (rel%ISOPEN) THEN
1899: CLOSE rel;

Line 1988: IF (PO_LOG.d_proc) THEN

1984: d_progress NUMBER;
1985:
1986: BEGIN
1987:
1988: IF (PO_LOG.d_proc) THEN
1989: PO_LOG.proc_begin(d_module);
1990: END IF;
1991:
1992: d_progress := 10;

Line 1989: PO_LOG.proc_begin(d_module);

1985:
1986: BEGIN
1987:
1988: IF (PO_LOG.d_proc) THEN
1989: PO_LOG.proc_begin(d_module);
1990: END IF;
1991:
1992: d_progress := 10;
1993:

Line 2005: IF (PO_LOG.d_stmt) THEN

2001: DELETE FROM mtl_supply
2002: WHERE rowid = c_sup2.rowid;
2003:
2004: d_progress := 25;
2005: IF (PO_LOG.d_stmt) THEN
2006: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' rows');
2007: END IF;
2008:
2009: ELSE

Line 2006: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' rows');

2002: WHERE rowid = c_sup2.rowid;
2003:
2004: d_progress := 25;
2005: IF (PO_LOG.d_stmt) THEN
2006: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' rows');
2007: END IF;
2008:
2009: ELSE
2010:

Line 2033: IF (PO_LOG.d_stmt) THEN

2029: END IF; -- if (c_sup2.item_id = -1)
2030:
2031: d_progress := 50;
2032:
2033: IF (PO_LOG.d_stmt) THEN
2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);
2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);
2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);

Line 2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);

2030:
2031: d_progress := 50;
2032:
2033: IF (PO_LOG.d_stmt) THEN
2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);
2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);
2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);
2038: PO_LOG.stmt(d_module, d_progress, 'c_sup2.unit_of_measure', c_sup2.unit_of_measure);

Line 2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);

2031: d_progress := 50;
2032:
2033: IF (PO_LOG.d_stmt) THEN
2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);
2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);
2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);
2038: PO_LOG.stmt(d_module, d_progress, 'c_sup2.unit_of_measure', c_sup2.unit_of_measure);
2039: END IF;

Line 2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);

2032:
2033: IF (PO_LOG.d_stmt) THEN
2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);
2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);
2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);
2038: PO_LOG.stmt(d_module, d_progress, 'c_sup2.unit_of_measure', c_sup2.unit_of_measure);
2039: END IF;
2040:

Line 2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);

2033: IF (PO_LOG.d_stmt) THEN
2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);
2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);
2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);
2038: PO_LOG.stmt(d_module, d_progress, 'c_sup2.unit_of_measure', c_sup2.unit_of_measure);
2039: END IF;
2040:
2041: l_pri_qty := INV_CONVERT.INV_UM_CONVERT(

Line 2038: PO_LOG.stmt(d_module, d_progress, 'c_sup2.unit_of_measure', c_sup2.unit_of_measure);

2034: PO_LOG.stmt(d_module, d_progress, 'l_uom', l_uom);
2035: PO_LOG.stmt(d_module, d_progress, 'l_lead_time', l_lead_time);
2036: PO_LOG.stmt(d_module, d_progress, 'c_sup2.item_id', c_sup2.item_id);
2037: PO_LOG.stmt(d_module, d_progress, 'c_sup2.quantity', c_sup2.quantity);
2038: PO_LOG.stmt(d_module, d_progress, 'c_sup2.unit_of_measure', c_sup2.unit_of_measure);
2039: END IF;
2040:
2041: l_pri_qty := INV_CONVERT.INV_UM_CONVERT(
2042: item_id => c_sup2.item_id

Line 2053: IF (PO_LOG.d_stmt) THEN

2049: );
2050:
2051: d_progress := 60;
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_progress, 'l_pri_qty', l_pri_qty);
2055: END IF;
2056:
2057: --

Line 2054: PO_LOG.stmt(d_module, d_progress, 'l_pri_qty', l_pri_qty);

2050:
2051: d_progress := 60;
2052:
2053: IF (PO_LOG.d_stmt) THEN
2054: PO_LOG.stmt(d_module, d_progress, 'l_pri_qty', l_pri_qty);
2055: END IF;
2056:
2057: --
2058: DECLARE

Line 2066: IF (PO_LOG.d_stmt) THEN

2062: --#1:If its already marked as Excluded From Planning Do not Change it
2063: IF l_exclude_from_planning IS NULL
2064: OR l_exclude_from_planning <> 'Y' THEN
2065: d_progress := 62;
2066: IF (PO_LOG.d_stmt) THEN
2067: PO_LOG.stmt(d_module, d_progress, 'Check: Excluded From Planning');
2068: END IF;
2069: --#2:Should perform this Check only when CLM is installed
2070: IF PO_CLM_INTG_GRP.IS_CLM_INSTALLED = 'Y' THEN

Line 2067: PO_LOG.stmt(d_module, d_progress, 'Check: Excluded From Planning');

2063: IF l_exclude_from_planning IS NULL
2064: OR l_exclude_from_planning <> 'Y' THEN
2065: d_progress := 62;
2066: IF (PO_LOG.d_stmt) THEN
2067: PO_LOG.stmt(d_module, d_progress, 'Check: Excluded From Planning');
2068: END IF;
2069: --#2:Should perform this Check only when CLM is installed
2070: IF PO_CLM_INTG_GRP.IS_CLM_INSTALLED = 'Y' THEN
2071: d_progress := 64;

Line 2072: IF (PO_LOG.d_stmt) THEN

2068: END IF;
2069: --#2:Should perform this Check only when CLM is installed
2070: IF PO_CLM_INTG_GRP.IS_CLM_INSTALLED = 'Y' THEN
2071: d_progress := 64;
2072: IF (PO_LOG.d_stmt) THEN
2073: PO_LOG.stmt(d_module, d_progress, 'CLM is installed.');
2074: END IF;
2075: IF c_sup2.po_header_id IS NOT NULL THEN
2076: l_is_clm_document := PO_CLM_INTG_GRP.IS_CLM_DOCUMENT(p_doc_type => 'PO',p_document_id => c_sup2.po_header_id);

Line 2073: PO_LOG.stmt(d_module, d_progress, 'CLM is installed.');

2069: --#2:Should perform this Check only when CLM is installed
2070: IF PO_CLM_INTG_GRP.IS_CLM_INSTALLED = 'Y' THEN
2071: d_progress := 64;
2072: IF (PO_LOG.d_stmt) THEN
2073: PO_LOG.stmt(d_module, d_progress, 'CLM is installed.');
2074: END IF;
2075: IF c_sup2.po_header_id IS NOT NULL THEN
2076: l_is_clm_document := PO_CLM_INTG_GRP.IS_CLM_DOCUMENT(p_doc_type => 'PO',p_document_id => c_sup2.po_header_id);
2077: ELSE

Line 2084: IF (PO_LOG.d_stmt) THEN

2080: END IF;
2081: --#3: When Both REQ Header Id and PO Header Id or Null, Need not modify anything
2082: END IF;
2083: d_progress := 66;
2084: IF (PO_LOG.d_stmt) THEN
2085: PO_LOG.stmt(d_module, d_progress, ' IS CLM document : '
2086: ||l_is_clm_document );
2087: END IF;
2088: --#4: If its a CLM Document, then Exclude it From Planning, else mark it as N

Line 2085: PO_LOG.stmt(d_module, d_progress, ' IS CLM document : '

2081: --#3: When Both REQ Header Id and PO Header Id or Null, Need not modify anything
2082: END IF;
2083: d_progress := 66;
2084: IF (PO_LOG.d_stmt) THEN
2085: PO_LOG.stmt(d_module, d_progress, ' IS CLM document : '
2086: ||l_is_clm_document );
2087: END IF;
2088: --#4: If its a CLM Document, then Exclude it From Planning, else mark it as N
2089: IF l_is_clm_document IS NOT NULL THEN

Line 2112: IF (PO_LOG.d_stmt) THEN

2108: exclude_from_planning = DECODE(l_exclude_From_Planning,'Y','Y','N',NULL,NULL) --
2109: WHERE rowid = c_sup2.rowid;
2110:
2111: d_progress := 70;
2112: IF (PO_LOG.d_stmt) THEN
2113: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2114: END IF;
2115:
2116: END IF; -- if (c_sup2.quantity = 0)

Line 2113: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');

2109: WHERE rowid = c_sup2.rowid;
2110:
2111: d_progress := 70;
2112: IF (PO_LOG.d_stmt) THEN
2113: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2114: END IF;
2115:
2116: END IF; -- if (c_sup2.quantity = 0)
2117:

Line 2120: IF (PO_LOG.d_proc) THEN

2116: END IF; -- if (c_sup2.quantity = 0)
2117:
2118: END LOOP;
2119:
2120: IF (PO_LOG.d_proc) THEN
2121: PO_LOG.proc_return(d_module, TRUE);
2122: PO_LOG.proc_end(d_module);
2123: END IF;
2124:

Line 2121: PO_LOG.proc_return(d_module, TRUE);

2117:
2118: END LOOP;
2119:
2120: IF (PO_LOG.d_proc) THEN
2121: PO_LOG.proc_return(d_module, TRUE);
2122: PO_LOG.proc_end(d_module);
2123: END IF;
2124:
2125: return(TRUE);

Line 2122: PO_LOG.proc_end(d_module);

2118: END LOOP;
2119:
2120: IF (PO_LOG.d_proc) THEN
2121: PO_LOG.proc_return(d_module, TRUE);
2122: PO_LOG.proc_end(d_module);
2123: END IF;
2124:
2125: return(TRUE);
2126:

Line 2131: IF (PO_LOG.d_exc) THEN

2127: EXCEPTION
2128:
2129: WHEN others THEN
2130:
2131: IF (PO_LOG.d_exc) THEN
2132: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2133: END IF;
2134:
2135: IF uom%ISOPEN THEN

Line 2132: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2128:
2129: WHEN others THEN
2130:
2131: IF (PO_LOG.d_exc) THEN
2132: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2133: END IF;
2134:
2135: IF uom%ISOPEN THEN
2136: close uom;

Line 2176: IF (PO_LOG.d_proc) THEN

2172: l_return_value BOOLEAN := FALSE;
2173:
2174: BEGIN
2175:
2176: IF (PO_LOG.d_proc) THEN
2177: PO_LOG.proc_begin(d_module);
2178: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2179: END IF;
2180:

Line 2177: PO_LOG.proc_begin(d_module);

2173:
2174: BEGIN
2175:
2176: IF (PO_LOG.d_proc) THEN
2177: PO_LOG.proc_begin(d_module);
2178: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2179: END IF;
2180:
2181: d_progress := 10;

Line 2178: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

2174: BEGIN
2175:
2176: IF (PO_LOG.d_proc) THEN
2177: PO_LOG.proc_begin(d_module);
2178: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2179: END IF;
2180:
2181: d_progress := 10;
2182:

Line 2201: IF (PO_LOG.d_proc) THEN

2197: l_return_value := TRUE;
2198:
2199: END IF;
2200:
2201: IF (PO_LOG.d_proc) THEN
2202: PO_LOG.proc_return(d_module, l_return_value);
2203: PO_LOG.proc_end(d_module);
2204: END IF;
2205:

Line 2202: PO_LOG.proc_return(d_module, l_return_value);

2198:
2199: END IF;
2200:
2201: IF (PO_LOG.d_proc) THEN
2202: PO_LOG.proc_return(d_module, l_return_value);
2203: PO_LOG.proc_end(d_module);
2204: END IF;
2205:
2206: return(l_return_value);

Line 2203: PO_LOG.proc_end(d_module);

2199: END IF;
2200:
2201: IF (PO_LOG.d_proc) THEN
2202: PO_LOG.proc_return(d_module, l_return_value);
2203: PO_LOG.proc_end(d_module);
2204: END IF;
2205:
2206: return(l_return_value);
2207:

Line 2212: IF (PO_LOG.d_exc) THEN

2208: EXCEPTION
2209:
2210: WHEN others THEN
2211:
2212: IF (PO_LOG.d_exc) THEN
2213: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2214: END IF;
2215:
2216: IF (auth_status%ISOPEN) THEN

Line 2213: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2209:
2210: WHEN others THEN
2211:
2212: IF (PO_LOG.d_exc) THEN
2213: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2214: END IF;
2215:
2216: IF (auth_status%ISOPEN) THEN
2217: close auth_status;

Line 2241: IF (PO_LOG.d_proc) THEN

2237: d_progress NUMBER;
2238:
2239: BEGIN
2240:
2241: IF (PO_LOG.d_proc) THEN
2242: PO_LOG.proc_begin(d_module);
2243: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2244: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2245: END IF;

Line 2242: PO_LOG.proc_begin(d_module);

2238:
2239: BEGIN
2240:
2241: IF (PO_LOG.d_proc) THEN
2242: PO_LOG.proc_begin(d_module);
2243: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2244: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2245: END IF;
2246:

Line 2243: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

2239: BEGIN
2240:
2241: IF (PO_LOG.d_proc) THEN
2242: PO_LOG.proc_begin(d_module);
2243: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2244: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2245: END IF;
2246:
2247: d_progress := 10;

Line 2244: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

2240:
2241: IF (PO_LOG.d_proc) THEN
2242: PO_LOG.proc_begin(d_module);
2243: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2244: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2245: END IF;
2246:
2247: d_progress := 10;
2248:

Line 2271: IF (PO_LOG.d_stmt) THEN

2267: AND req_line_id = p_entity_id;
2268:
2269: END IF; -- if (p_entity_type = ...)
2270:
2271: IF (PO_LOG.d_stmt) THEN
2272: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2273: END IF;
2274:
2275: IF (PO_LOG.d_proc) THEN

Line 2272: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');

2268:
2269: END IF; -- if (p_entity_type = ...)
2270:
2271: IF (PO_LOG.d_stmt) THEN
2272: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2273: END IF;
2274:
2275: IF (PO_LOG.d_proc) THEN
2276: PO_LOG.proc_return(d_module, TRUE);

Line 2275: IF (PO_LOG.d_proc) THEN

2271: IF (PO_LOG.d_stmt) THEN
2272: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2273: END IF;
2274:
2275: IF (PO_LOG.d_proc) THEN
2276: PO_LOG.proc_return(d_module, TRUE);
2277: PO_LOG.proc_end(d_module);
2278: END IF;
2279:

Line 2276: PO_LOG.proc_return(d_module, TRUE);

2272: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2273: END IF;
2274:
2275: IF (PO_LOG.d_proc) THEN
2276: PO_LOG.proc_return(d_module, TRUE);
2277: PO_LOG.proc_end(d_module);
2278: END IF;
2279:
2280: return(TRUE);

Line 2277: PO_LOG.proc_end(d_module);

2273: END IF;
2274:
2275: IF (PO_LOG.d_proc) THEN
2276: PO_LOG.proc_return(d_module, TRUE);
2277: PO_LOG.proc_end(d_module);
2278: END IF;
2279:
2280: return(TRUE);
2281:

Line 2286: IF (PO_LOG.d_exc) THEN

2282:
2283: EXCEPTION
2284:
2285: WHEN others THEN
2286: IF (PO_LOG.d_exc) THEN
2287: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2288: END IF;
2289:
2290: return(FALSE);

Line 2287: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2283: EXCEPTION
2284:
2285: WHEN others THEN
2286: IF (PO_LOG.d_exc) THEN
2287: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2288: END IF;
2289:
2290: return(FALSE);
2291:

Line 2308: IF (PO_LOG.d_proc) THEN

2304: d_progress NUMBER;
2305:
2306: BEGIN
2307:
2308: IF (PO_LOG.d_proc) THEN
2309: PO_LOG.proc_begin(d_module);
2310: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2311: END IF;
2312:

Line 2309: PO_LOG.proc_begin(d_module);

2305:
2306: BEGIN
2307:
2308: IF (PO_LOG.d_proc) THEN
2309: PO_LOG.proc_begin(d_module);
2310: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2311: END IF;
2312:
2313: d_progress := 10;

Line 2310: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

2306: BEGIN
2307:
2308: IF (PO_LOG.d_proc) THEN
2309: PO_LOG.proc_begin(d_module);
2310: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2311: END IF;
2312:
2313: d_progress := 10;
2314:

Line 2331: IF (PO_LOG.d_stmt) THEN

2327: AND porl.requisition_line_id = ms.req_line_id
2328: AND porl.line_location_id is null--Bug 13518969
2329: );
2330:
2331: IF (PO_LOG.d_stmt) THEN
2332: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN

Line 2332: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');

2328: AND porl.line_location_id is null--Bug 13518969
2329: );
2330:
2331: IF (PO_LOG.d_stmt) THEN
2332: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_return(d_module, TRUE);

Line 2335: IF (PO_LOG.d_proc) THEN

2331: IF (PO_LOG.d_stmt) THEN
2332: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_return(d_module, TRUE);
2337: PO_LOG.proc_end(d_module);
2338: END IF;
2339:

Line 2336: PO_LOG.proc_return(d_module, TRUE);

2332: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_return(d_module, TRUE);
2337: PO_LOG.proc_end(d_module);
2338: END IF;
2339:
2340: return(TRUE);

Line 2337: PO_LOG.proc_end(d_module);

2333: END IF;
2334:
2335: IF (PO_LOG.d_proc) THEN
2336: PO_LOG.proc_return(d_module, TRUE);
2337: PO_LOG.proc_end(d_module);
2338: END IF;
2339:
2340: return(TRUE);
2341:

Line 2345: IF (PO_LOG.d_exc) THEN

2341:
2342: EXCEPTION
2343:
2344: WHEN others THEN
2345: IF (PO_LOG.d_exc) THEN
2346: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2347: END IF;
2348:
2349: return(FALSE);

Line 2346: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2342: EXCEPTION
2343:
2344: WHEN others THEN
2345: IF (PO_LOG.d_exc) THEN
2346: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2347: END IF;
2348:
2349: return(FALSE);
2350:

Line 2376: IF (PO_LOG.d_proc) THEN

2372: l_return_value BOOLEAN := FALSE;
2373:
2374: BEGIN
2375:
2376: IF (PO_LOG.d_proc) THEN
2377: PO_LOG.proc_begin(d_module);
2378: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2379: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2380: END IF;

Line 2377: PO_LOG.proc_begin(d_module);

2373:
2374: BEGIN
2375:
2376: IF (PO_LOG.d_proc) THEN
2377: PO_LOG.proc_begin(d_module);
2378: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2379: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2380: END IF;
2381:

Line 2378: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);

2374: BEGIN
2375:
2376: IF (PO_LOG.d_proc) THEN
2377: PO_LOG.proc_begin(d_module);
2378: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2379: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2380: END IF;
2381:
2382: d_progress := 10;

Line 2379: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

2375:
2376: IF (PO_LOG.d_proc) THEN
2377: PO_LOG.proc_begin(d_module);
2378: PO_LOG.proc_begin(d_module, 'p_entity_id', p_entity_id);
2379: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2380: END IF;
2381:
2382: d_progress := 10;
2383:

Line 2415: IF (PO_LOG.d_stmt) THEN

2411: AND pl.line_location_id IS NULL
2412: )
2413: AND ms1.supply_type_code = 'REQ';
2414:
2415: IF (PO_LOG.d_stmt) THEN
2416: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' rows');
2417: END IF;
2418:
2419: --

Line 2416: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' rows');

2412: )
2413: AND ms1.supply_type_code = 'REQ';
2414:
2415: IF (PO_LOG.d_stmt) THEN
2416: PO_LOG.stmt(d_module, d_progress, 'Deleted ' || SQL%ROWCOUNT || ' rows');
2417: END IF;
2418:
2419: --
2420:

Line 2572: IF (PO_LOG.d_stmt) THEN

2568: END IF; -- if p_entity_type = ...
2569:
2570: d_progress := 100;
2571:
2572: IF (PO_LOG.d_stmt) THEN
2573: PO_LOG.stmt(d_module, d_progress, 'Inserted ' || SQL%ROWCOUNT || ' rows');
2574: END IF;
2575:
2576: -- : After analysis, no rows is OK, not error.

Line 2573: PO_LOG.stmt(d_module, d_progress, 'Inserted ' || SQL%ROWCOUNT || ' rows');

2569:
2570: d_progress := 100;
2571:
2572: IF (PO_LOG.d_stmt) THEN
2573: PO_LOG.stmt(d_module, d_progress, 'Inserted ' || SQL%ROWCOUNT || ' rows');
2574: END IF;
2575:
2576: -- : After analysis, no rows is OK, not error.
2577: -- This is to handle services lines.

Line 2581: IF (PO_LOG.d_proc) THEN

2577: -- This is to handle services lines.
2578:
2579: l_return_value := TRUE;
2580:
2581: IF (PO_LOG.d_proc) THEN
2582: PO_LOG.proc_return(d_module, l_return_value);
2583: PO_LOG.proc_end(d_module);
2584: END IF;
2585:

Line 2582: PO_LOG.proc_return(d_module, l_return_value);

2578:
2579: l_return_value := TRUE;
2580:
2581: IF (PO_LOG.d_proc) THEN
2582: PO_LOG.proc_return(d_module, l_return_value);
2583: PO_LOG.proc_end(d_module);
2584: END IF;
2585:
2586: return(l_return_value);

Line 2583: PO_LOG.proc_end(d_module);

2579: l_return_value := TRUE;
2580:
2581: IF (PO_LOG.d_proc) THEN
2582: PO_LOG.proc_return(d_module, l_return_value);
2583: PO_LOG.proc_end(d_module);
2584: END IF;
2585:
2586: return(l_return_value);
2587:

Line 2592: IF (PO_LOG.d_exc) THEN

2588: EXCEPTION
2589:
2590: WHEN others THEN
2591:
2592: IF (PO_LOG.d_exc) THEN
2593: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2594: END IF;
2595:
2596: return(FALSE);

Line 2593: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2589:
2590: WHEN others THEN
2591:
2592: IF (PO_LOG.d_exc) THEN
2593: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2594: END IF;
2595:
2596: return(FALSE);
2597:

Line 2617: IF (PO_LOG.d_proc) THEN

2613: l_return_value BOOLEAN := FALSE;
2614:
2615: BEGIN
2616:
2617: IF (PO_LOG.d_proc) THEN
2618: PO_LOG.proc_begin(d_module);
2619: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2620: END IF;
2621:

Line 2618: PO_LOG.proc_begin(d_module);

2614:
2615: BEGIN
2616:
2617: IF (PO_LOG.d_proc) THEN
2618: PO_LOG.proc_begin(d_module);
2619: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2620: END IF;
2621:
2622: d_progress := 10;

Line 2619: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);

2615: BEGIN
2616:
2617: IF (PO_LOG.d_proc) THEN
2618: PO_LOG.proc_begin(d_module);
2619: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2620: END IF;
2621:
2622: d_progress := 10;
2623:

Line 2634: IF (PO_LOG.d_stmt) THEN

2630: , p_entity_type => 'REQ LINE'
2631: );
2632:
2633: IF (NOT l_return_value) THEN
2634: IF (PO_LOG.d_stmt) THEN
2635: PO_LOG.stmt(d_module, d_progress, 'remove_req not successful');
2636: END IF;
2637:
2638: RAISE PO_CORE_S.g_early_return_exc;

Line 2635: PO_LOG.stmt(d_module, d_progress, 'remove_req not successful');

2631: );
2632:
2633: IF (NOT l_return_value) THEN
2634: IF (PO_LOG.d_stmt) THEN
2635: PO_LOG.stmt(d_module, d_progress, 'remove_req not successful');
2636: END IF;
2637:
2638: RAISE PO_CORE_S.g_early_return_exc;
2639: END IF;

Line 2713: IF (PO_LOG.d_stmt) THEN

2709: where supply_type_code = 'REQ'
2710: and supply_source_id = prl.requisition_line_id);
2711:
2712:
2713: IF (PO_LOG.d_stmt) THEN
2714: PO_LOG.stmt(d_module, d_progress, 'Exploded ' || SQL%ROWCOUNT || ' rows');
2715: END IF;
2716:
2717: l_return_value := TRUE;

Line 2714: PO_LOG.stmt(d_module, d_progress, 'Exploded ' || SQL%ROWCOUNT || ' rows');

2710: and supply_source_id = prl.requisition_line_id);
2711:
2712:
2713: IF (PO_LOG.d_stmt) THEN
2714: PO_LOG.stmt(d_module, d_progress, 'Exploded ' || SQL%ROWCOUNT || ' rows');
2715: END IF;
2716:
2717: l_return_value := TRUE;
2718:

Line 2724: IF (PO_LOG.d_proc) THEN

2720: WHEN PO_CORE_S.g_early_return_exc THEN
2721: NULL;
2722: END;
2723:
2724: IF (PO_LOG.d_proc) THEN
2725: PO_LOG.proc_return(d_module, l_return_value);
2726: PO_LOG.proc_end(d_module);
2727: END IF;
2728:

Line 2725: PO_LOG.proc_return(d_module, l_return_value);

2721: NULL;
2722: END;
2723:
2724: IF (PO_LOG.d_proc) THEN
2725: PO_LOG.proc_return(d_module, l_return_value);
2726: PO_LOG.proc_end(d_module);
2727: END IF;
2728:
2729: return(l_return_value);

Line 2726: PO_LOG.proc_end(d_module);

2722: END;
2723:
2724: IF (PO_LOG.d_proc) THEN
2725: PO_LOG.proc_return(d_module, l_return_value);
2726: PO_LOG.proc_end(d_module);
2727: END IF;
2728:
2729: return(l_return_value);
2730:

Line 2735: IF (PO_LOG.d_exc) THEN

2731: EXCEPTION
2732:
2733: WHEN others THEN
2734:
2735: IF (PO_LOG.d_exc) THEN
2736: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2737: END IF;
2738:
2739: return(FALSE);

Line 2736: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2732:
2733: WHEN others THEN
2734:
2735: IF (PO_LOG.d_exc) THEN
2736: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2737: END IF;
2738:
2739: return(FALSE);
2740:

Line 2761: IF (PO_LOG.d_proc) THEN

2757: d_progress NUMBER;
2758:
2759: BEGIN
2760:
2761: IF (PO_LOG.d_proc) THEN
2762: PO_LOG.proc_begin(d_module);
2763: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2764: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
2765: END IF;

Line 2762: PO_LOG.proc_begin(d_module);

2758:
2759: BEGIN
2760:
2761: IF (PO_LOG.d_proc) THEN
2762: PO_LOG.proc_begin(d_module);
2763: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2764: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
2765: END IF;
2766:

Line 2763: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);

2759: BEGIN
2760:
2761: IF (PO_LOG.d_proc) THEN
2762: PO_LOG.proc_begin(d_module);
2763: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2764: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
2765: END IF;
2766:
2767: d_progress := 10;

Line 2764: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);

2760:
2761: IF (PO_LOG.d_proc) THEN
2762: PO_LOG.proc_begin(d_module);
2763: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2764: PO_LOG.proc_begin(d_module, 'p_qty', p_qty);
2765: END IF;
2766:
2767: d_progress := 10;
2768:

Line 2775: IF (PO_LOG.d_stmt) THEN

2771: , change_flag = 'Y'
2772: WHERE supply_type_code = 'REQ'
2773: AND req_line_id = p_lineid;
2774:
2775: IF (PO_LOG.d_stmt) THEN
2776: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2777: END IF;
2778:
2779:

Line 2776: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');

2772: WHERE supply_type_code = 'REQ'
2773: AND req_line_id = p_lineid;
2774:
2775: IF (PO_LOG.d_stmt) THEN
2776: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2777: END IF;
2778:
2779:
2780: IF (PO_LOG.d_proc) THEN

Line 2780: IF (PO_LOG.d_proc) THEN

2776: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2777: END IF;
2778:
2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_return(d_module, TRUE);
2782: PO_LOG.proc_end(d_module);
2783: END IF;
2784:

Line 2781: PO_LOG.proc_return(d_module, TRUE);

2777: END IF;
2778:
2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_return(d_module, TRUE);
2782: PO_LOG.proc_end(d_module);
2783: END IF;
2784:
2785: return(TRUE);

Line 2782: PO_LOG.proc_end(d_module);

2778:
2779:
2780: IF (PO_LOG.d_proc) THEN
2781: PO_LOG.proc_return(d_module, TRUE);
2782: PO_LOG.proc_end(d_module);
2783: END IF;
2784:
2785: return(TRUE);
2786:

Line 2791: IF (PO_LOG.d_exc) THEN

2787: EXCEPTION
2788:
2789: WHEN others THEN
2790:
2791: IF (PO_LOG.d_exc) THEN
2792: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2793: END IF;
2794:
2795: return(FALSE);

Line 2792: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2788:
2789: WHEN others THEN
2790:
2791: IF (PO_LOG.d_exc) THEN
2792: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2793: END IF;
2794:
2795: return(FALSE);
2796:

Line 2816: IF (PO_LOG.d_proc) THEN

2812: d_progress NUMBER;
2813:
2814: BEGIN
2815:
2816: IF (PO_LOG.d_proc) THEN
2817: PO_LOG.proc_begin(d_module);
2818: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2819: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
2820: END IF;

Line 2817: PO_LOG.proc_begin(d_module);

2813:
2814: BEGIN
2815:
2816: IF (PO_LOG.d_proc) THEN
2817: PO_LOG.proc_begin(d_module);
2818: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2819: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
2820: END IF;
2821:

Line 2818: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);

2814: BEGIN
2815:
2816: IF (PO_LOG.d_proc) THEN
2817: PO_LOG.proc_begin(d_module);
2818: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2819: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
2820: END IF;
2821:
2822: d_progress := 10;

Line 2819: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);

2815:
2816: IF (PO_LOG.d_proc) THEN
2817: PO_LOG.proc_begin(d_module);
2818: PO_LOG.proc_begin(d_module, 'p_lineid', p_lineid);
2819: PO_LOG.proc_begin(d_module, 'p_receipt_date', p_receipt_date);
2820: END IF;
2821:
2822: d_progress := 10;
2823:

Line 2831: IF (PO_LOG.d_stmt) THEN

2827: , change_flag = 'Y'
2828: WHERE supply_type_code = 'REQ'
2829: AND req_line_id = p_lineid;
2830:
2831: IF (PO_LOG.d_stmt) THEN
2832: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2833: END IF;
2834:
2835:

Line 2832: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');

2828: WHERE supply_type_code = 'REQ'
2829: AND req_line_id = p_lineid;
2830:
2831: IF (PO_LOG.d_stmt) THEN
2832: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2833: END IF;
2834:
2835:
2836: IF (PO_LOG.d_proc) THEN

Line 2836: IF (PO_LOG.d_proc) THEN

2832: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2833: END IF;
2834:
2835:
2836: IF (PO_LOG.d_proc) THEN
2837: PO_LOG.proc_return(d_module, TRUE);
2838: PO_LOG.proc_end(d_module);
2839: END IF;
2840:

Line 2837: PO_LOG.proc_return(d_module, TRUE);

2833: END IF;
2834:
2835:
2836: IF (PO_LOG.d_proc) THEN
2837: PO_LOG.proc_return(d_module, TRUE);
2838: PO_LOG.proc_end(d_module);
2839: END IF;
2840:
2841: return(TRUE);

Line 2838: PO_LOG.proc_end(d_module);

2834:
2835:
2836: IF (PO_LOG.d_proc) THEN
2837: PO_LOG.proc_return(d_module, TRUE);
2838: PO_LOG.proc_end(d_module);
2839: END IF;
2840:
2841: return(TRUE);
2842:

Line 2847: IF (PO_LOG.d_exc) THEN

2843: EXCEPTION
2844:
2845: WHEN others THEN
2846:
2847: IF (PO_LOG.d_exc) THEN
2848: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2849: END IF;
2850:
2851: return(FALSE);

Line 2848: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2844:
2845: WHEN others THEN
2846:
2847: IF (PO_LOG.d_exc) THEN
2848: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2849: END IF;
2850:
2851: return(FALSE);
2852:

Line 2891: IF (PO_LOG.d_proc) THEN

2887:
2888:
2889: BEGIN
2890:
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_module);
2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

Line 2892: PO_LOG.proc_begin(d_module);

2888:
2889: BEGIN
2890:
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_module);
2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2896: PO_LOG.proc_begin(d_module, 'p_supply_flag', p_supply_flag);

Line 2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);

2889: BEGIN
2890:
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_module);
2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2896: PO_LOG.proc_begin(d_module, 'p_supply_flag', p_supply_flag);
2897: END IF;

Line 2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);

2890:
2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_module);
2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2896: PO_LOG.proc_begin(d_module, 'p_supply_flag', p_supply_flag);
2897: END IF;
2898:

Line 2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);

2891: IF (PO_LOG.d_proc) THEN
2892: PO_LOG.proc_begin(d_module);
2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2896: PO_LOG.proc_begin(d_module, 'p_supply_flag', p_supply_flag);
2897: END IF;
2898:
2899: d_progress := 10;

Line 2896: PO_LOG.proc_begin(d_module, 'p_supply_flag', p_supply_flag);

2892: PO_LOG.proc_begin(d_module);
2893: PO_LOG.proc_begin(d_module, 'p_docid', p_docid);
2894: PO_LOG.proc_begin(d_module, 'p_shipid', p_shipid);
2895: PO_LOG.proc_begin(d_module, 'p_entity_type', p_entity_type);
2896: PO_LOG.proc_begin(d_module, 'p_supply_flag', p_supply_flag);
2897: END IF;
2898:
2899: d_progress := 10;
2900:

Line 2974: IF (PO_LOG.d_stmt) THEN

2970: END IF;
2971:
2972: END IF;
2973:
2974: IF (PO_LOG.d_stmt) THEN
2975: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2976: END IF;
2977:
2978: IF (PO_LOG.d_proc) THEN

Line 2975: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');

2971:
2972: END IF;
2973:
2974: IF (PO_LOG.d_stmt) THEN
2975: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2976: END IF;
2977:
2978: IF (PO_LOG.d_proc) THEN
2979: PO_LOG.proc_return(d_module, TRUE);

Line 2978: IF (PO_LOG.d_proc) THEN

2974: IF (PO_LOG.d_stmt) THEN
2975: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2976: END IF;
2977:
2978: IF (PO_LOG.d_proc) THEN
2979: PO_LOG.proc_return(d_module, TRUE);
2980: PO_LOG.proc_end(d_module, 'p_supply_flag', p_supply_flag);
2981: PO_LOG.proc_end(d_module);
2982: END IF;

Line 2979: PO_LOG.proc_return(d_module, TRUE);

2975: PO_LOG.stmt(d_module, d_progress, 'Updated ' || SQL%ROWCOUNT || ' rows');
2976: END IF;
2977:
2978: IF (PO_LOG.d_proc) THEN
2979: PO_LOG.proc_return(d_module, TRUE);
2980: PO_LOG.proc_end(d_module, 'p_supply_flag', p_supply_flag);
2981: PO_LOG.proc_end(d_module);
2982: END IF;
2983:

Line 2980: PO_LOG.proc_end(d_module, 'p_supply_flag', p_supply_flag);

2976: END IF;
2977:
2978: IF (PO_LOG.d_proc) THEN
2979: PO_LOG.proc_return(d_module, TRUE);
2980: PO_LOG.proc_end(d_module, 'p_supply_flag', p_supply_flag);
2981: PO_LOG.proc_end(d_module);
2982: END IF;
2983:
2984: return(TRUE);

Line 2981: PO_LOG.proc_end(d_module);

2977:
2978: IF (PO_LOG.d_proc) THEN
2979: PO_LOG.proc_return(d_module, TRUE);
2980: PO_LOG.proc_end(d_module, 'p_supply_flag', p_supply_flag);
2981: PO_LOG.proc_end(d_module);
2982: END IF;
2983:
2984: return(TRUE);
2985:

Line 2990: IF (PO_LOG.d_exc) THEN

2986: EXCEPTION
2987:
2988: WHEN others THEN
2989:
2990: IF (PO_LOG.d_exc) THEN
2991: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2992: END IF;
2993:
2994: return(FALSE);

Line 2991: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

2987:
2988: WHEN others THEN
2989:
2990: IF (PO_LOG.d_exc) THEN
2991: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
2992: END IF;
2993:
2994: return(FALSE);
2995: