APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_LOG

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

1: PACKAGE BODY PO_DIFF_SUMMARY_PKG AS
2: -- $Header: PO_DIFF_SUMMARY_PKG.plb 120.10.12000000.2 2007/07/11 08:28:58 puppulur ship $
3:
4: d_pkg_name CONSTANT varchar2(50) :=
5: PO_LOG.get_package_base('PO_DIFF_SUMMARY_PKG');
6:
7: g_ITEMTYPE CONSTANT VARCHAR2(20) := 'PODSNOTF';
8: g_ITEMKEY_PREFIX CONSTANT VARCHAR2(50) := 'PO_DS_ACCEPT_NOTIF';
9:

Line 72: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

68: ( p_po_header_id IN NUMBER
69: ) IS
70:
71: d_api_name CONSTANT VARCHAR2(30) := 'send_acceptance_notification';
72: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
73: d_position NUMBER;
74:
75: l_ItemKey VARCHAR2(240);
76: l_agreement_num PO_HEADERS_ALL.segment1%TYPE;

Line 90: IF (PO_LOG.d_proc) THEN

86:
87: BEGIN
88: d_position := 0;
89:
90: IF (PO_LOG.d_proc) THEN
91: PO_LOG.proc_begin (d_module);
92: END IF;
93:
94: -- Get the agreement number and revision number

Line 91: PO_LOG.proc_begin (d_module);

87: BEGIN
88: d_position := 0;
89:
90: IF (PO_LOG.d_proc) THEN
91: PO_LOG.proc_begin (d_module);
92: END IF;
93:
94: -- Get the agreement number and revision number
95: SELECT NVL(revision_num, 0), segment1, org_id, agent_id

Line 228: IF (PO_LOG.d_proc) THEN

224: ( ItemType => g_ITEMTYPE,
225: ItemKey => l_ItemKey
226: );
227:
228: IF (PO_LOG.d_proc) THEN
229: PO_LOG.proc_end (d_module);
230: END IF;
231:
232: EXCEPTION

Line 229: PO_LOG.proc_end (d_module);

225: ItemKey => l_ItemKey
226: );
227:
228: IF (PO_LOG.d_proc) THEN
229: PO_LOG.proc_end (d_module);
230: END IF;
231:
232: EXCEPTION
233: WHEN NO_DATA_FOUND THEN

Line 250: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

246: resultout IN OUT NOCOPY VARCHAR2
247: ) IS
248:
249: d_api_name CONSTANT VARCHAR2(30) := 'selector';
250: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
251: d_position NUMBER;
252:
253: l_cur_org_id PO_HEADERS_ALL.org_id%TYPE;
254: l_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 257: IF (PO_LOG.d_proc) THEN

253: l_cur_org_id PO_HEADERS_ALL.org_id%TYPE;
254: l_org_id PO_HEADERS_ALL.org_id%TYPE;
255: BEGIN
256: d_position := 0;
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin (d_module, 'item_type', item_type);
259: PO_LOG.proc_begin (d_module, 'item_key', item_key);
260: PO_LOG.proc_begin (d_module, 'activity_id', activity_id);
261: PO_LOG.proc_begin (d_module, 'command', command);

Line 258: PO_LOG.proc_begin (d_module, 'item_type', item_type);

254: l_org_id PO_HEADERS_ALL.org_id%TYPE;
255: BEGIN
256: d_position := 0;
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin (d_module, 'item_type', item_type);
259: PO_LOG.proc_begin (d_module, 'item_key', item_key);
260: PO_LOG.proc_begin (d_module, 'activity_id', activity_id);
261: PO_LOG.proc_begin (d_module, 'command', command);
262: END IF;

Line 259: PO_LOG.proc_begin (d_module, 'item_key', item_key);

255: BEGIN
256: d_position := 0;
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin (d_module, 'item_type', item_type);
259: PO_LOG.proc_begin (d_module, 'item_key', item_key);
260: PO_LOG.proc_begin (d_module, 'activity_id', activity_id);
261: PO_LOG.proc_begin (d_module, 'command', command);
262: END IF;
263:

Line 260: PO_LOG.proc_begin (d_module, 'activity_id', activity_id);

256: d_position := 0;
257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin (d_module, 'item_type', item_type);
259: PO_LOG.proc_begin (d_module, 'item_key', item_key);
260: PO_LOG.proc_begin (d_module, 'activity_id', activity_id);
261: PO_LOG.proc_begin (d_module, 'command', command);
262: END IF;
263:
264: IF (command = 'RUN') THEN

Line 261: PO_LOG.proc_begin (d_module, 'command', command);

257: IF (PO_LOG.d_proc) THEN
258: PO_LOG.proc_begin (d_module, 'item_type', item_type);
259: PO_LOG.proc_begin (d_module, 'item_key', item_key);
260: PO_LOG.proc_begin (d_module, 'activity_id', activity_id);
261: PO_LOG.proc_begin (d_module, 'command', command);
262: END IF;
263:
264: IF (command = 'RUN') THEN
265: d_position := 10;

Line 300: IF (PO_LOG.d_proc) THEN

296: END IF;
297:
298: END IF;
299:
300: IF (PO_LOG.d_proc) THEN
301: PO_LOG.proc_end (d_module);
302: END IF;
303:
304: EXCEPTION

Line 301: PO_LOG.proc_end (d_module);

297:
298: END IF;
299:
300: IF (PO_LOG.d_proc) THEN
301: PO_LOG.proc_end (d_module);
302: END IF;
303:
304: EXCEPTION
305: WHEN OTHERS THEN

Line 322: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

318: resultout OUT NOCOPY VARCHAR2
319: ) IS
320:
321: d_api_name CONSTANT VARCHAR2(30) := 'mark_autoaccept_lines';
322: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
323: d_position NUMBER;
324:
325: l_contains_changes VARCHAR2(1);
326: l_acceptance_required VARCHAR2(1);

Line 334: IF (PO_LOG.d_proc) THEN

330: l_acceptance_level PO_SYSTEM_PARAMETERS_ALL.cat_admin_authoring_acceptance%TYPE;
331: BEGIN
332: d_position := 0;
333:
334: IF (PO_LOG.d_proc) THEN
335: PO_LOG.proc_begin (d_module);
336: END IF;
337:
338: l_acceptance_required := FND_API.G_TRUE;

Line 335: PO_LOG.proc_begin (d_module);

331: BEGIN
332: d_position := 0;
333:
334: IF (PO_LOG.d_proc) THEN
335: PO_LOG.proc_begin (d_module);
336: END IF;
337:
338: l_acceptance_required := FND_API.G_TRUE;
339:

Line 425: IF (PO_LOG.d_proc) THEN

421: aname => 'BUYER_ACCEPTANCE_REQUIRED',
422: avalue => l_acceptance_required
423: );
424:
425: IF (PO_LOG.d_proc) THEN
426: PO_LOG.proc_end (d_module);
427: END IF;
428:
429: EXCEPTION

Line 426: PO_LOG.proc_end (d_module);

422: avalue => l_acceptance_required
423: );
424:
425: IF (PO_LOG.d_proc) THEN
426: PO_LOG.proc_end (d_module);
427: END IF;
428:
429: EXCEPTION
430: WHEN OTHERS THEN

Line 445: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

441: resultout OUT NOCOPY VARCHAR2
442: ) IS
443:
444: d_api_name CONSTANT VARCHAR2(30) := 'buyer_acceptance_required';
445: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
446: d_position NUMBER;
447:
448: l_accept_required VARCHAR2(1);
449: BEGIN

Line 452: IF (PO_LOG.d_proc) THEN

448: l_accept_required VARCHAR2(1);
449: BEGIN
450: d_position := 0;
451:
452: IF (PO_LOG.d_proc) THEN
453: PO_LOG.proc_begin (d_module);
454: END IF;
455:
456: l_accept_required := PO_WF_UTIL_PKG.GetItemAttrText

Line 453: PO_LOG.proc_begin (d_module);

449: BEGIN
450: d_position := 0;
451:
452: IF (PO_LOG.d_proc) THEN
453: PO_LOG.proc_begin (d_module);
454: END IF;
455:
456: l_accept_required := PO_WF_UTIL_PKG.GetItemAttrText
457: ( itemtype => itemtype,

Line 468: IF (PO_LOG.d_proc) THEN

464: ELSE
465: resultout := WF_ENGINE.eng_completed || ':N';
466: END IF;
467:
468: IF (PO_LOG.d_proc) THEN
469: PO_LOG.proc_end (d_module);
470: END IF;
471:
472: EXCEPTION

Line 469: PO_LOG.proc_end (d_module);

465: resultout := WF_ENGINE.eng_completed || ':N';
466: END IF;
467:
468: IF (PO_LOG.d_proc) THEN
469: PO_LOG.proc_end (d_module);
470: END IF;
471:
472: EXCEPTION
473: WHEN OTHERS THEN

Line 487: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

483: resultout OUT NOCOPY VARCHAR2
484: ) IS
485:
486: d_api_name CONSTANT VARCHAR2(30) := 'transfer_if_all_autoaccepted';
487: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
488: d_position NUMBER;
489:
490: l_transfer_flag VARCHAR2(1);
491:

Line 495: IF (PO_LOG.d_proc) THEN

491:
492: BEGIN
493: d_position := 0;
494:
495: IF (PO_LOG.d_proc) THEN
496: PO_LOG.proc_begin (d_module);
497: END IF;
498:
499: l_transfer_flag := PO_WF_UTIL_PKG.GetItemAttrText

Line 496: PO_LOG.proc_begin (d_module);

492: BEGIN
493: d_position := 0;
494:
495: IF (PO_LOG.d_proc) THEN
496: PO_LOG.proc_begin (d_module);
497: END IF;
498:
499: l_transfer_flag := PO_WF_UTIL_PKG.GetItemAttrText
500: ( itemtype => itemtype,

Line 511: IF (PO_LOG.d_proc) THEN

507: ELSE
508: resultout := WF_ENGINE.eng_completed || ':N';
509: END IF;
510:
511: IF (PO_LOG.d_proc) THEN
512: PO_LOG.proc_end (d_module);
513: END IF;
514:
515: EXCEPTION

Line 512: PO_LOG.proc_end (d_module);

508: resultout := WF_ENGINE.eng_completed || ':N';
509: END IF;
510:
511: IF (PO_LOG.d_proc) THEN
512: PO_LOG.proc_end (d_module);
513: END IF;
514:
515: EXCEPTION
516: WHEN OTHERS THEN

Line 531: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

527: resultout OUT NOCOPY VARCHAR2
528: ) IS
529:
530: d_api_name CONSTANT VARCHAR2(30) := 'start_buyer_acceptance_process';
531: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
532: d_position NUMBER;
533:
534: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
535: l_draft_id PO_DRAFTS.draft_id%TYPE;

Line 548: IF (PO_LOG.d_proc) THEN

544:
545: BEGIN
546: d_position := 0;
547:
548: IF (PO_LOG.d_proc) THEN
549: PO_LOG.proc_begin (d_module);
550: END IF;
551:
552: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber

Line 549: PO_LOG.proc_begin (d_module);

545: BEGIN
546: d_position := 0;
547:
548: IF (PO_LOG.d_proc) THEN
549: PO_LOG.proc_begin (d_module);
550: END IF;
551:
552: l_po_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber
553: ( itemtype => itemtype,

Line 619: IF (PO_LOG.d_proc) THEN

615: aname => 'DRAFT_OWNER_NAME_DSP',
616: avalue => l_lock_owner_wf_role_dsp
617: );
618:
619: IF (PO_LOG.d_proc) THEN
620: PO_LOG.proc_end (d_module);
621: END IF;
622:
623: EXCEPTION

Line 620: PO_LOG.proc_end (d_module);

616: avalue => l_lock_owner_wf_role_dsp
617: );
618:
619: IF (PO_LOG.d_proc) THEN
620: PO_LOG.proc_end (d_module);
621: END IF;
622:
623: EXCEPTION
624: WHEN OTHERS THEN

Line 639: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

635: resultout OUT NOCOPY VARCHAR2
636: ) IS
637:
638: d_api_name CONSTANT VARCHAR2(30) := 'get_buyers_manager';
639: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
640: d_position NUMBER;
641:
642: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
643: l_manager_id NUMBER;

Line 705: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

701: resultout OUT NOCOPY VARCHAR2
702: ) IS
703:
704: d_api_name CONSTANT VARCHAR2(30) := 'buyer_accept_changes';
705: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
706: d_position NUMBER;
707:
708: BEGIN
709: d_position := 0;

Line 711: IF (PO_LOG.d_proc) THEN

707:
708: BEGIN
709: d_position := 0;
710:
711: IF (PO_LOG.d_proc) THEN
712: PO_LOG.proc_begin (d_module);
713: END IF;
714:
715: PO_WF_UTIL_PKG.SetItemAttrText

Line 712: PO_LOG.proc_begin (d_module);

708: BEGIN
709: d_position := 0;
710:
711: IF (PO_LOG.d_proc) THEN
712: PO_LOG.proc_begin (d_module);
713: END IF;
714:
715: PO_WF_UTIL_PKG.SetItemAttrText
716: ( itemtype => itemType,

Line 722: IF (PO_LOG.d_proc) THEN

718: aname => 'ACCEPTANCE_RESULT',
719: avalue => PO_DRAFTS_PVT.g_ACCEPT_ALL
720: );
721:
722: IF (PO_LOG.d_proc) THEN
723: PO_LOG.proc_end (d_module);
724: END IF;
725:
726: EXCEPTION

Line 723: PO_LOG.proc_end (d_module);

719: avalue => PO_DRAFTS_PVT.g_ACCEPT_ALL
720: );
721:
722: IF (PO_LOG.d_proc) THEN
723: PO_LOG.proc_end (d_module);
724: END IF;
725:
726: EXCEPTION
727: WHEN OTHERS THEN

Line 742: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

738: resultout OUT NOCOPY VARCHAR2
739: ) IS
740:
741: d_api_name CONSTANT VARCHAR2(30) := 'buyer_reject_changes';
742: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
743: d_position NUMBER;
744:
745: l_draft_id PO_DRAFTS.draft_id%TYPE;
746: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

Line 755: IF (PO_LOG.d_proc) THEN

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

Line 756: PO_LOG.proc_begin (d_module);

752: BEGIN
753: d_position := 0;
754:
755: IF (PO_LOG.d_proc) THEN
756: PO_LOG.proc_begin (d_module);
757: END IF;
758:
759: l_draft_id :=
760: PO_WF_UTIL_PKG.GetItemAttrNumber

Line 854: IF (PO_LOG.d_proc) THEN

850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: END IF;
852:
853:
854: IF (PO_LOG.d_proc) THEN
855: PO_LOG.proc_end (d_module);
856: END IF;
857:
858: EXCEPTION

Line 855: PO_LOG.proc_end (d_module);

851: END IF;
852:
853:
854: IF (PO_LOG.d_proc) THEN
855: PO_LOG.proc_end (d_module);
856: END IF;
857:
858: EXCEPTION
859: WHEN OTHERS THEN

Line 874: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

870: resultout OUT NOCOPY VARCHAR2
871: ) IS
872:
873: d_api_name CONSTANT VARCHAR2(30) := 'any_lines_get_rejected';
874: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
875: d_position NUMBER;
876:
877: l_draft_id PO_DRAFTS.draft_id%TYPE;
878: l_any_lines_get_rejected VARCHAR2(10);

Line 882: IF (PO_LOG.d_proc) THEN

878: l_any_lines_get_rejected VARCHAR2(10);
879: BEGIN
880: d_position := 0;
881:
882: IF (PO_LOG.d_proc) THEN
883: PO_LOG.proc_begin (d_module);
884: END IF;
885:
886: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

Line 883: PO_LOG.proc_begin (d_module);

879: BEGIN
880: d_position := 0;
881:
882: IF (PO_LOG.d_proc) THEN
883: PO_LOG.proc_begin (d_module);
884: END IF;
885:
886: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
887: ( itemtype => itemtype,

Line 925: IF (PO_LOG.d_stmt) THEN

921: END;
922:
923: d_position := 20;
924:
925: IF (PO_LOG.d_stmt) THEN
926: PO_LOG.stmt (d_module, d_position, 'l_any_lines_get_rejected', l_any_lines_get_rejected);
927: END IF;
928:
929: IF (l_any_lines_get_rejected = 'Y') THEN

Line 926: PO_LOG.stmt (d_module, d_position, 'l_any_lines_get_rejected', l_any_lines_get_rejected);

922:
923: d_position := 20;
924:
925: IF (PO_LOG.d_stmt) THEN
926: PO_LOG.stmt (d_module, d_position, 'l_any_lines_get_rejected', l_any_lines_get_rejected);
927: END IF;
928:
929: IF (l_any_lines_get_rejected = 'Y') THEN
930: resultout := WF_ENGINE.eng_completed || ':Y';

Line 935: IF (PO_LOG.d_proc) THEN

931: ELSE
932: resultout := WF_ENGINE.eng_completed || ':N';
933: END IF;
934:
935: IF (PO_LOG.d_proc) THEN
936: PO_LOG.proc_end (d_module);
937: END IF;
938:
939: EXCEPTION

Line 936: PO_LOG.proc_end (d_module);

932: resultout := WF_ENGINE.eng_completed || ':N';
933: END IF;
934:
935: IF (PO_LOG.d_proc) THEN
936: PO_LOG.proc_end (d_module);
937: END IF;
938:
939: EXCEPTION
940: WHEN OTHERS THEN

Line 956: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

952: resultout OUT NOCOPY VARCHAR2
953: ) IS
954:
955: d_api_name CONSTANT VARCHAR2(30) := 'transfer_draft_to_txn';
956: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
957: d_position NUMBER;
958:
959: l_draft_id PO_DRAFTS.draft_id%TYPE;
960: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

Line 968: IF (PO_LOG.d_proc) THEN

964:
965: BEGIN
966: d_position := 0;
967:
968: IF (PO_LOG.d_proc) THEN
969: PO_LOG.proc_begin (d_module);
970: END IF;
971:
972: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber

Line 969: PO_LOG.proc_begin (d_module);

965: BEGIN
966: d_position := 0;
967:
968: IF (PO_LOG.d_proc) THEN
969: PO_LOG.proc_begin (d_module);
970: END IF;
971:
972: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber
973: ( itemtype => itemtype,

Line 1007: IF (PO_LOG.d_proc) THEN

1003:
1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006:
1007: IF (PO_LOG.d_proc) THEN
1008: PO_LOG.proc_end (d_module);
1009: END IF;
1010:
1011: EXCEPTION

Line 1008: PO_LOG.proc_end (d_module);

1004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1005: END IF;
1006:
1007: IF (PO_LOG.d_proc) THEN
1008: PO_LOG.proc_end (d_module);
1009: END IF;
1010:
1011: EXCEPTION
1012: WHEN OTHERS THEN

Line 1027: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1023: resultout OUT NOCOPY VARCHAR2
1024: ) IS
1025:
1026: d_api_name CONSTANT VARCHAR2(30) := 'launch_po_approval_wf';
1027: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1028: d_position NUMBER;
1029:
1030: l_document_type VARCHAR2(10) := 'PA';
1031: l_document_subtype VARCHAR2(10) := 'BLANKET';

Line 1048: IF (PO_LOG.d_proc) THEN

1044:
1045: BEGIN
1046: d_position := 0;
1047:
1048: IF (PO_LOG.d_proc) THEN
1049: PO_LOG.proc_begin (d_module);
1050: END IF;
1051:
1052:

Line 1049: PO_LOG.proc_begin (d_module);

1045: BEGIN
1046: d_position := 0;
1047:
1048: IF (PO_LOG.d_proc) THEN
1049: PO_LOG.proc_begin (d_module);
1050: END IF;
1051:
1052:
1053: -- Launch Approval WF

Line 1129: IF (PO_LOG.d_proc) THEN

1125: );
1126:
1127: d_position := 40;
1128:
1129: IF (PO_LOG.d_proc) THEN
1130: PO_LOG.proc_end (d_module);
1131: END IF;
1132:
1133: EXCEPTION

Line 1130: PO_LOG.proc_end (d_module);

1126:
1127: d_position := 40;
1128:
1129: IF (PO_LOG.d_proc) THEN
1130: PO_LOG.proc_end (d_module);
1131: END IF;
1132:
1133: EXCEPTION
1134: WHEN OTHERS THEN

Line 1202: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1198: ) RETURN VARCHAR2
1199: IS
1200:
1201: d_api_name CONSTANT VARCHAR2(30) := 'find_itemkey';
1202: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1203: d_position NUMBER;
1204:
1205: l_itemkey_like WF_ITEMS.item_key%TYPE;
1206: l_itemkey WF_ITEMS.item_key%TYPE;

Line 1211: IF (PO_LOG.d_proc) THEN

1207:
1208: BEGIN
1209: d_position := 0;
1210:
1211: IF (PO_LOG.d_proc) THEN
1212: PO_LOG.proc_begin (d_module);
1213: END IF;
1214:
1215: l_itemkey_like := g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#%';

Line 1212: PO_LOG.proc_begin (d_module);

1208: BEGIN
1209: d_position := 0;
1210:
1211: IF (PO_LOG.d_proc) THEN
1212: PO_LOG.proc_begin (d_module);
1213: END IF;
1214:
1215: l_itemkey_like := g_ITEMKEY_PREFIX || '#' || TO_CHAR(p_draft_id) || '#%';
1216:

Line 1224: IF (PO_LOG.d_proc) THEN

1220: WHERE item_type = g_ITEMTYPE
1221: AND item_key LIKE l_itemkey_like
1222: AND end_date IS NULL;
1223:
1224: IF (PO_LOG.d_proc) THEN
1225: PO_LOG.proc_end (d_module, 'l_itemkey', l_itemkey);
1226: END IF;
1227:
1228: RETURN l_itemkey;

Line 1225: PO_LOG.proc_end (d_module, 'l_itemkey', l_itemkey);

1221: AND item_key LIKE l_itemkey_like
1222: AND end_date IS NULL;
1223:
1224: IF (PO_LOG.d_proc) THEN
1225: PO_LOG.proc_end (d_module, 'l_itemkey', l_itemkey);
1226: END IF;
1227:
1228: RETURN l_itemkey;
1229:

Line 1273: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1269: x_return_status OUT NOCOPY VARCHAR2
1270: ) IS
1271:
1272: d_api_name CONSTANT VARCHAR2(30) := 'record_disposition';
1273: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1274: d_position NUMBER;
1275:
1276: l_return_status VARCHAR2(1);
1277: BEGIN

Line 1280: IF (PO_LOG.d_proc) THEN

1276: l_return_status VARCHAR2(1);
1277: BEGIN
1278: d_position := 0;
1279:
1280: IF (PO_LOG.d_proc) THEN
1281: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1282: PO_LOG.proc_begin (d_module, 'p_reject_line_id_list.COUNT', p_reject_line_id_list.COUNT);
1283: END IF;
1284:

Line 1281: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);

1277: BEGIN
1278: d_position := 0;
1279:
1280: IF (PO_LOG.d_proc) THEN
1281: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1282: PO_LOG.proc_begin (d_module, 'p_reject_line_id_list.COUNT', p_reject_line_id_list.COUNT);
1283: END IF;
1284:
1285: x_return_status := FND_API.g_RET_STS_SUCCESS;

Line 1282: PO_LOG.proc_begin (d_module, 'p_reject_line_id_list.COUNT', p_reject_line_id_list.COUNT);

1278: d_position := 0;
1279:
1280: IF (PO_LOG.d_proc) THEN
1281: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1282: PO_LOG.proc_begin (d_module, 'p_reject_line_id_list.COUNT', p_reject_line_id_list.COUNT);
1283: END IF;
1284:
1285: x_return_status := FND_API.g_RET_STS_SUCCESS;
1286:

Line 1299: IF (PO_LOG.d_stmt) THEN

1295: x_invalid_line_num_list => x_invalid_line_num_list,
1296: x_return_status => l_return_status
1297: );
1298:
1299: IF (PO_LOG.d_stmt) THEN
1300: PO_LOG.stmt (d_module, d_position, 'l_return_status', l_return_status);
1301: END IF;
1302:
1303: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1300: PO_LOG.stmt (d_module, d_position, 'l_return_status', l_return_status);

1296: x_return_status => l_return_status
1297: );
1298:
1299: IF (PO_LOG.d_stmt) THEN
1300: PO_LOG.stmt (d_module, d_position, 'l_return_status', l_return_status);
1301: END IF;
1302:
1303: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1304: x_return_status := l_return_status;

Line 1328: IF (PO_LOG.d_proc) THEN

1324: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327:
1328: IF (PO_LOG.d_proc) THEN
1329: PO_LOG.proc_end (d_module);
1330: END IF;
1331:
1332: EXCEPTION

Line 1329: PO_LOG.proc_end (d_module);

1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: END IF;
1327:
1328: IF (PO_LOG.d_proc) THEN
1329: PO_LOG.proc_end (d_module);
1330: END IF;
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN

Line 1373: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1369: x_return_status OUT NOCOPY VARCHAR2
1370: ) IS
1371:
1372: d_api_name CONSTANT VARCHAR2(30) := 'complete_resp_to_changes';
1373: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1374: d_position NUMBER;
1375:
1376: l_itemKey WF_ITEMS.item_key%TYPE;
1377: l_activity VARCHAR2(200);

Line 1385: IF (PO_LOG.d_proc) THEN

1381: d_position := 0;
1382:
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384:
1385: IF (PO_LOG.d_proc) THEN
1386: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1387: END IF;
1388:
1389: l_itemKey := find_ItemKey

Line 1386: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);

1382:
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384:
1385: IF (PO_LOG.d_proc) THEN
1386: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1387: END IF;
1388:
1389: l_itemKey := find_ItemKey
1390: ( p_draft_id => p_draft_id

Line 1428: IF (PO_LOG.d_proc) THEN

1424: );
1425:
1426: END IF;
1427:
1428: IF (PO_LOG.d_proc) THEN
1429: PO_LOG.proc_end (d_module);
1430: END IF;
1431:
1432: EXCEPTION

Line 1429: PO_LOG.proc_end (d_module);

1425:
1426: END IF;
1427:
1428: IF (PO_LOG.d_proc) THEN
1429: PO_LOG.proc_end (d_module);
1430: END IF;
1431:
1432: EXCEPTION
1433: WHEN OTHERS THEN

Line 1470: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1466: ) RETURN VARCHAR2
1467: IS
1468:
1469: d_api_name CONSTANT VARCHAR2(30) := 'accept_lines_within_tolerance';
1470: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1471: d_position NUMBER;
1472:
1473: l_index NUMBER;
1474:

Line 1498: IF (PO_LOG.d_proc) THEN

1494:
1495: BEGIN
1496: d_position := 0;
1497:
1498: IF (PO_LOG.d_proc) THEN
1499: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1500: END IF;
1501:
1502: -- bug5035979

Line 1499: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);

1495: BEGIN
1496: d_position := 0;
1497:
1498: IF (PO_LOG.d_proc) THEN
1499: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
1500: END IF;
1501:
1502: -- bug5035979
1503: -- mark the records that do not have line level changes as

Line 1614: IF (PO_LOG.d_proc) THEN

1610: END IF;
1611:
1612: END IF;
1613:
1614: IF (PO_LOG.d_proc) THEN
1615: PO_LOG.proc_end (d_module);
1616: END IF;
1617:
1618: RETURN l_manual_accept_required;

Line 1615: PO_LOG.proc_end (d_module);

1611:
1612: END IF;
1613:
1614: IF (PO_LOG.d_proc) THEN
1615: PO_LOG.proc_end (d_module);
1616: END IF;
1617:
1618: RETURN l_manual_accept_required;
1619:

Line 1640: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1636: ( p_draft_id IN NUMBER
1637: ) IS
1638:
1639: d_api_name CONSTANT VARCHAR2(30) := 'accept_translations';
1640: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1641: d_position NUMBER;
1642:
1643: l_created_language PO_HEADERS_ALL.created_language%TYPE;
1644:

Line 1649: IF (PO_LOG.d_proc) THEN

1645: BEGIN
1646:
1647: d_position := 0;
1648:
1649: IF (PO_LOG.d_proc) THEN
1650: PO_LOG.proc_begin (d_module);
1651: END IF;
1652:
1653: SELECT PH.created_language

Line 1650: PO_LOG.proc_begin (d_module);

1646:
1647: d_position := 0;
1648:
1649: IF (PO_LOG.d_proc) THEN
1650: PO_LOG.proc_begin (d_module);
1651: END IF;
1652:
1653: SELECT PH.created_language
1654: INTO l_created_language

Line 1667: IF (PO_LOG.d_proc) THEN

1663: AND PAVTD.draft_id = p_draft_id
1664: AND PAVTD.language <> l_created_language;
1665:
1666:
1667: IF (PO_LOG.d_proc) THEN
1668: PO_LOG.proc_end (d_module, '# of records updated: ', SQL%ROWCOUNT);
1669: END IF;
1670:
1671: EXCEPTION

Line 1668: PO_LOG.proc_end (d_module, '# of records updated: ', SQL%ROWCOUNT);

1664: AND PAVTD.language <> l_created_language;
1665:
1666:
1667: IF (PO_LOG.d_proc) THEN
1668: PO_LOG.proc_end (d_module, '# of records updated: ', SQL%ROWCOUNT);
1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN OTHERS THEN

Line 1705: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1701: ( p_draft_id IN NUMBER
1702: ) IS
1703:
1704: d_api_name CONSTANT VARCHAR2(30) := 'autoaccept_deleted_records';
1705: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1706: d_position NUMBER;
1707:
1708: l_has_record_to_accept VARCHAR2(1) := FND_API.G_TRUE;
1709:

Line 1714: IF (PO_LOG.d_proc) THEN

1710: BEGIN
1711:
1712: d_position := 0;
1713:
1714: IF (PO_LOG.d_proc) THEN
1715: PO_LOG.proc_begin (d_module);
1716: END IF;
1717:
1718: -- Line Level

Line 1715: PO_LOG.proc_begin (d_module);

1711:
1712: d_position := 0;
1713:
1714: IF (PO_LOG.d_proc) THEN
1715: PO_LOG.proc_begin (d_module);
1716: END IF;
1717:
1718: -- Line Level
1719: UPDATE po_lines_draft_all PLD

Line 1781: IF (PO_LOG.d_proc) THEN

1777: ( SELECT 1
1778: FROM po_attribute_values_tlp PAVT
1779: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id);
1780:
1781: IF (PO_LOG.d_proc) THEN
1782: PO_LOG.proc_end (d_module);
1783: END IF;
1784:
1785: EXCEPTION

Line 1782: PO_LOG.proc_end (d_module);

1778: FROM po_attribute_values_tlp PAVT
1779: WHERE PAVTD.attribute_values_tlp_id = PAVT.attribute_values_tlp_id);
1780:
1781: IF (PO_LOG.d_proc) THEN
1782: PO_LOG.proc_end (d_module);
1783: END IF;
1784:
1785: EXCEPTION
1786: WHEN OTHERS THEN

Line 1824: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

1820: ) RETURN VARCHAR2
1821: IS
1822:
1823: d_api_name CONSTANT VARCHAR2(30) := 'autoaccept_unchanged_records';
1824: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
1825: d_position NUMBER;
1826:
1827: l_has_record_to_accept VARCHAR2(1) := FND_API.G_TRUE;
1828:

Line 1833: IF (PO_LOG.d_proc) THEN

1829: BEGIN
1830:
1831: d_position := 0;
1832:
1833: IF (PO_LOG.d_proc) THEN
1834: PO_LOG.proc_begin (d_module);
1835: END IF;
1836:
1837: -- Line Level Attributes

Line 1834: PO_LOG.proc_begin (d_module);

1830:
1831: d_position := 0;
1832:
1833: IF (PO_LOG.d_proc) THEN
1834: PO_LOG.proc_begin (d_module);
1835: END IF;
1836:
1837: -- Line Level Attributes
1838: UPDATE po_lines_draft_all PLD

Line 1904: IF (PO_LOG.d_stmt) THEN

1900: PL.hazard_class_id, 'Y', 'N') = 'Y'
1901: AND DECODE (PLD.note_to_vendor,
1902: PL.note_to_vendor, 'Y', 'N') = 'Y');
1903:
1904: IF (PO_LOG.d_stmt) THEN
1905: PO_LOG.stmt (d_module, d_position, '# of lines autoaccepted', SQL%ROWCOUNT);
1906: END IF;
1907:
1908: d_position := 10;

Line 1905: PO_LOG.stmt (d_module, d_position, '# of lines autoaccepted', SQL%ROWCOUNT);

1901: AND DECODE (PLD.note_to_vendor,
1902: PL.note_to_vendor, 'Y', 'N') = 'Y');
1903:
1904: IF (PO_LOG.d_stmt) THEN
1905: PO_LOG.stmt (d_module, d_position, '# of lines autoaccepted', SQL%ROWCOUNT);
1906: END IF;
1907:
1908: d_position := 10;
1909:

Line 1935: IF (PO_LOG.d_stmt) THEN

1931: PLL.start_date, 'Y', 'N') = 'Y'
1932: AND DECODE (PLLD.end_date,
1933: PLL.end_date, 'Y', 'N') = 'Y');
1934:
1935: IF (PO_LOG.d_stmt) THEN
1936: PO_LOG.stmt (d_module, d_position, '# of price breaks autoaccepted', SQL%ROWCOUNT);
1937: END IF;
1938:
1939: d_position := 20;

Line 1936: PO_LOG.stmt (d_module, d_position, '# of price breaks autoaccepted', SQL%ROWCOUNT);

1932: AND DECODE (PLLD.end_date,
1933: PLL.end_date, 'Y', 'N') = 'Y');
1934:
1935: IF (PO_LOG.d_stmt) THEN
1936: PO_LOG.stmt (d_module, d_position, '# of price breaks autoaccepted', SQL%ROWCOUNT);
1937: END IF;
1938:
1939: d_position := 20;
1940:

Line 1960: IF (PO_LOG.d_stmt) THEN

1956: PPD.min_multiplier, 'Y', 'N') = 'Y'
1957: AND DECODE (PPDD.max_multiplier,
1958: PPD.max_multiplier, 'Y', 'N') = 'Y');
1959:
1960: IF (PO_LOG.d_stmt) THEN
1961: PO_LOG.stmt (d_module, d_position, '# of price diff autoaccepted', SQL%ROWCOUNT);
1962: END IF;
1963:
1964: d_position := 30;

Line 1961: PO_LOG.stmt (d_module, d_position, '# of price diff autoaccepted', SQL%ROWCOUNT);

1957: AND DECODE (PPDD.max_multiplier,
1958: PPD.max_multiplier, 'Y', 'N') = 'Y');
1959:
1960: IF (PO_LOG.d_stmt) THEN
1961: PO_LOG.stmt (d_module, d_position, '# of price diff autoaccepted', SQL%ROWCOUNT);
1962: END IF;
1963:
1964: d_position := 30;
1965:

Line 2596: IF (PO_LOG.d_stmt) THEN

2592: AND DECODE (PAVD.num_cat_attribute50,
2593: PAV.num_cat_attribute50, 'Y', 'N') = 'Y');
2594:
2595:
2596: IF (PO_LOG.d_stmt) THEN
2597: PO_LOG.stmt (d_module, d_position, '# of attr values autoaccepted', SQL%ROWCOUNT);
2598: END IF;
2599:
2600: d_position := 40;

Line 2597: PO_LOG.stmt (d_module, d_position, '# of attr values autoaccepted', SQL%ROWCOUNT);

2593: PAV.num_cat_attribute50, 'Y', 'N') = 'Y');
2594:
2595:
2596: IF (PO_LOG.d_stmt) THEN
2597: PO_LOG.stmt (d_module, d_position, '# of attr values autoaccepted', SQL%ROWCOUNT);
2598: END IF;
2599:
2600: d_position := 40;
2601:

Line 2923: IF (PO_LOG.d_stmt) THEN

2919: PAVT.tl_text_cat_attribute49, 'Y', 'N') = 'Y'
2920: AND DECODE (PAVTD.tl_text_cat_attribute50,
2921: PAVT.tl_text_cat_attribute50, 'Y', 'N') = 'Y');
2922:
2923: IF (PO_LOG.d_stmt) THEN
2924: PO_LOG.stmt (d_module, d_position, '# of attr values tlp autoaccepted', SQL%ROWCOUNT);
2925: END IF;
2926:
2927: d_position := 50;

Line 2924: PO_LOG.stmt (d_module, d_position, '# of attr values tlp autoaccepted', SQL%ROWCOUNT);

2920: AND DECODE (PAVTD.tl_text_cat_attribute50,
2921: PAVT.tl_text_cat_attribute50, 'Y', 'N') = 'Y');
2922:
2923: IF (PO_LOG.d_stmt) THEN
2924: PO_LOG.stmt (d_module, d_position, '# of attr values tlp autoaccepted', SQL%ROWCOUNT);
2925: END IF;
2926:
2927: d_position := 50;
2928:

Line 2934: IF (PO_LOG.d_proc) THEN

2930: ( p_draft_id => p_draft_id
2931: );
2932:
2933:
2934: IF (PO_LOG.d_proc) THEN
2935: PO_LOG.proc_end (d_module, 'l_has_record_to_accept', l_has_record_to_accept);
2936: END IF;
2937:
2938: RETURN l_has_record_to_accept;

Line 2935: PO_LOG.proc_end (d_module, 'l_has_record_to_accept', l_has_record_to_accept);

2931: );
2932:
2933:
2934: IF (PO_LOG.d_proc) THEN
2935: PO_LOG.proc_end (d_module, 'l_has_record_to_accept', l_has_record_to_accept);
2936: END IF;
2937:
2938: RETURN l_has_record_to_accept;
2939:

Line 2976: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

2972: ) RETURN VARCHAR2
2973: IS
2974:
2975: d_api_name CONSTANT VARCHAR2(30) := 'has_record_to_accept';
2976: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
2977: d_position NUMBER;
2978:
2979: l_has_record_to_accept VARCHAR2(1) := FND_API.G_TRUE;
2980:

Line 2985: IF (PO_LOG.d_proc) THEN

2981: BEGIN
2982:
2983: d_position := 0;
2984:
2985: IF (PO_LOG.d_proc) THEN
2986: PO_LOG.proc_begin (d_module);
2987: END IF;
2988:
2989: SELECT NVL(MAX(FND_API.G_TRUE), FND_API.G_FALSE)

Line 2986: PO_LOG.proc_begin (d_module);

2982:
2983: d_position := 0;
2984:
2985: IF (PO_LOG.d_proc) THEN
2986: PO_LOG.proc_begin (d_module);
2987: END IF;
2988:
2989: SELECT NVL(MAX(FND_API.G_TRUE), FND_API.G_FALSE)
2990: INTO l_has_record_to_accept

Line 3019: IF (PO_LOG.d_proc) THEN

3015: WHERE draft_id = p_draft_id
3016: AND change_accepted_flag IS NULL);
3017:
3018:
3019: IF (PO_LOG.d_proc) THEN
3020: PO_LOG.proc_end (d_module, 'l_has_record_to_accept', l_has_record_to_accept);
3021: END IF;
3022:
3023: RETURN l_has_record_to_accept;

Line 3020: PO_LOG.proc_end (d_module, 'l_has_record_to_accept', l_has_record_to_accept);

3016: AND change_accepted_flag IS NULL);
3017:
3018:
3019: IF (PO_LOG.d_proc) THEN
3020: PO_LOG.proc_end (d_module, 'l_has_record_to_accept', l_has_record_to_accept);
3021: END IF;
3022:
3023: RETURN l_has_record_to_accept;
3024:

Line 3066: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

3062: ( p_draft_id IN NUMBER
3063: ) IS
3064:
3065: d_api_name CONSTANT VARCHAR2(30) := 'accept_if_no_line_changes';
3066: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
3067: d_position NUMBER;
3068:
3069: BEGIN
3070:

Line 3073: IF (PO_LOG.d_proc) THEN

3069: BEGIN
3070:
3071: d_position := 0;
3072:
3073: IF (PO_LOG.d_proc) THEN
3074: PO_LOG.proc_begin (d_module);
3075: END IF;
3076:
3077: UPDATE po_line_locations_draft_all PLLDA

Line 3074: PO_LOG.proc_begin (d_module);

3070:
3071: d_position := 0;
3072:
3073: IF (PO_LOG.d_proc) THEN
3074: PO_LOG.proc_begin (d_module);
3075: END IF;
3076:
3077: UPDATE po_line_locations_draft_all PLLDA
3078: SET PLLDA.change_accepted_flag = 'Y'

Line 3143: IF (PO_LOG.d_proc) THEN

3139: WHERE PLLA.line_location_id = PPDD.entity_id
3140: AND PLDA.po_line_id = PLLA.po_line_id
3141: AND PLDA.draft_id = PPDD.draft_id)));
3142:
3143: IF (PO_LOG.d_proc) THEN
3144: PO_LOG.proc_end (d_module);
3145: END IF;
3146:
3147: EXCEPTION

Line 3144: PO_LOG.proc_end (d_module);

3140: AND PLDA.po_line_id = PLLA.po_line_id
3141: AND PLDA.draft_id = PPDD.draft_id)));
3142:
3143: IF (PO_LOG.d_proc) THEN
3144: PO_LOG.proc_end (d_module);
3145: END IF;
3146:
3147: EXCEPTION
3148: WHEN OTHERS THEN

Line 3188: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

3184: x_return_status OUT NOCOPY VARCHAR2
3185: ) IS
3186:
3187: d_api_name CONSTANT VARCHAR2(30) := 'cascade_change_acceptance';
3188: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
3189: d_position NUMBER;
3190:
3191: BEGIN
3192: d_position := 0;

Line 3194: IF (PO_LOG.d_proc) THEN

3190:
3191: BEGIN
3192: d_position := 0;
3193:
3194: IF (PO_LOG.d_proc) THEN
3195: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3196: PO_LOG.proc_begin (d_module, 'p_line_id_list.COUNT', p_line_id_list.COUNT);
3197: END IF;
3198:

Line 3195: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);

3191: BEGIN
3192: d_position := 0;
3193:
3194: IF (PO_LOG.d_proc) THEN
3195: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3196: PO_LOG.proc_begin (d_module, 'p_line_id_list.COUNT', p_line_id_list.COUNT);
3197: END IF;
3198:
3199: x_return_status := FND_API.g_RET_STS_SUCCESS;

Line 3196: PO_LOG.proc_begin (d_module, 'p_line_id_list.COUNT', p_line_id_list.COUNT);

3192: d_position := 0;
3193:
3194: IF (PO_LOG.d_proc) THEN
3195: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3196: PO_LOG.proc_begin (d_module, 'p_line_id_list.COUNT', p_line_id_list.COUNT);
3197: END IF;
3198:
3199: x_return_status := FND_API.g_RET_STS_SUCCESS;
3200:

Line 3266: IF (PO_LOG.d_proc) THEN

3262: FROM po_line_locations_all PLLD
3263: WHERE PLLD.po_line_id = p_line_id_list(i)
3264: AND PLLD.line_location_id = PPDD.entity_id);
3265:
3266: IF (PO_LOG.d_proc) THEN
3267: PO_LOG.proc_end (d_module);
3268: END IF;
3269:
3270: EXCEPTION

Line 3267: PO_LOG.proc_end (d_module);

3263: WHERE PLLD.po_line_id = p_line_id_list(i)
3264: AND PLLD.line_location_id = PPDD.entity_id);
3265:
3266: IF (PO_LOG.d_proc) THEN
3267: PO_LOG.proc_end (d_module);
3268: END IF;
3269:
3270: EXCEPTION
3271: WHEN OTHERS THEN

Line 3314: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);

3310: x_return_status OUT NOCOPY VARCHAR2
3311: ) IS
3312:
3313: d_api_name CONSTANT VARCHAR2(30) := 'validate_disposition';
3314: d_module CONSTANT VARCHAR2(255) := PO_LOG.get_subprogram_base(d_pkg_name, d_api_name);
3315: d_position NUMBER;
3316:
3317: l_key PO_SESSION_GT.key%TYPE;
3318:

Line 3325: IF (PO_LOG.d_proc) THEN

3321: d_position := 0;
3322:
3323: x_return_status := FND_API.G_RET_STS_SUCCESS;
3324:
3325: IF (PO_LOG.d_proc) THEN
3326: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3327: END IF;
3328:
3329: x_invalid_line_id_list := PO_TBL_NUMBER();

Line 3326: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);

3322:
3323: x_return_status := FND_API.G_RET_STS_SUCCESS;
3324:
3325: IF (PO_LOG.d_proc) THEN
3326: PO_LOG.proc_begin (d_module, 'p_draft_id', p_draft_id);
3327: END IF;
3328:
3329: x_invalid_line_id_list := PO_TBL_NUMBER();
3330:

Line 3392: IF (PO_LOG.d_proc) THEN

3388: IF (x_invalid_line_id_list.COUNT > 0) THEN
3389: x_return_status := FND_API.G_RET_STS_ERROR;
3390: END IF;
3391:
3392: IF (PO_LOG.d_proc) THEN
3393: PO_LOG.proc_end (d_module);
3394: END IF;
3395:
3396: EXCEPTION

Line 3393: PO_LOG.proc_end (d_module);

3389: x_return_status := FND_API.G_RET_STS_ERROR;
3390: END IF;
3391:
3392: IF (PO_LOG.d_proc) THEN
3393: PO_LOG.proc_end (d_module);
3394: END IF;
3395:
3396: EXCEPTION
3397: WHEN OTHERS THEN