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_REQAPPROVAL_FINDAPPRV1 dependencies on PO_REQAPPROVAL_FINDAPPRV1

Line 1: PACKAGE BODY PO_REQAPPROVAL_FINDAPPRV1 AS

1: PACKAGE BODY PO_REQAPPROVAL_FINDAPPRV1 AS
2: /* $Header: POXWPA3B.pls 120.5.12010000.2 2008/08/04 08:35:58 rramasam ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

Line 13: | PL/SQL body for package: PO_REQAPPROVAL_FINDAPPRV1

Line 68: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 01';

64: l_preparer_user_name varchar2(100);
65:
66: BEGIN
67:
68: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 01';
69: IF (g_po_wf_debug = 'Y') THEN
70: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
71: END IF;
72:

Line 104: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 02';

100: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
101:
102: resultout := 'COMPLETE' ;
103:
104: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 02';
105: IF (g_po_wf_debug = 'Y') THEN
106: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
107: END IF;
108:

Line 115: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);

111:
112: WHEN OTHERS THEN
113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
115: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');
117: raise;
118:
119: END Set_Forward_To_From_App_fwd;

Line 116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');

112: WHEN OTHERS THEN
113: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
115: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
116: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FORWARD_TO_FROM_APP_FWD');
117: raise;
118:
119: END Set_Forward_To_From_App_fwd;
120: --

Line 139: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 01';

135: l_preparer_user_name varchar2(100);
136:
137: BEGIN
138:
139: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 01';
140: IF (g_po_wf_debug = 'Y') THEN
141: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
142: END IF;
143:

Line 278: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 02';

274: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
275:
276: resultout := 'COMPLETE' ;
277:
278: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 02';
279: IF (g_po_wf_debug = 'Y') THEN
280: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
281: END IF;
282:

Line 288: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);

284:
285: WHEN OTHERS THEN
286: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
287: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
288: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');
290: raise;
291:
292: END Set_Fwd_To_From_App_timeout;

Line 289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');

285: WHEN OTHERS THEN
286: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
287: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
288: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
289: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.SET_FWD_TO_FROM_APP_TIMEOUT');
290: raise;
291:
292: END Set_Fwd_To_From_App_timeout;
293: --

Line 332: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 01';

328: l_orgid number;
329:
330: BEGIN
331:
332: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 01';
333: IF (g_po_wf_debug = 'Y') THEN
334: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
335: END IF;
336:

Line 390: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 010 '||

386: END IF;
387:
388: IF CheckForwardTo(l_forward_to_username_response, x_user_id) = 'Y' THEN
389:
390: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 010 '||
391: 'x_user_id: ' ||x_user_id;
392: IF (g_po_wf_debug = 'Y') THEN
393: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
394: END IF;

Line 449: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 015';

445: ** Desc: If the forward to person is the preparer and the
446: ** owner can approve flag is set to N then return the Notification
447: ** to the responder with Invalid Forward to Message
448: */
449: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 015';
450: IF (g_po_wf_debug = 'Y') THEN
451: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
452: END IF;
453:

Line 459: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,

455: itemkey => itemkey,
456: aname => 'PREPARER_ID');
457:
458: if (x_user_id = l_preparer_id) then
459: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,
460: x_CanOwnerApproveFlag);
461:
462: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||
463: 'x_CanOwnerApproveFlag: '||x_CanOwnerApproveFlag;

Line 462: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||

458: if (x_user_id = l_preparer_id) then
459: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,
460: x_CanOwnerApproveFlag);
461:
462: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||
463: 'x_CanOwnerApproveFlag: '||x_CanOwnerApproveFlag;
464: IF (g_po_wf_debug = 'Y') THEN
465: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
466: END IF;

Line 470: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 025';

466: END IF;
467:
468: if x_CanOwnerApproveFlag = 'N' then
469:
470: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 025';
471: IF (g_po_wf_debug = 'Y') THEN
472: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
473: END IF;
474:

Line 490: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 050';

486: avalue => l_error_msg);
487:
488: resultout := wf_engine.eng_completed || ':' || 'N';
489:
490: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 050';
491: IF (g_po_wf_debug = 'Y') THEN
492: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
493: END IF;
494:

Line 501: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 060';

497: end if;
498:
499: /* end fix Bug# 1496490 */
500:
501: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 060';
502: IF (g_po_wf_debug = 'Y') THEN
503: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
504: END IF;
505:

Line 645: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 01';

641: l_preparer_user_name varchar2(100);
642:
643: BEGIN
644:
645: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 01';
646: IF (g_po_wf_debug = 'Y') THEN
647: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
648: END IF;
649:

Line 682: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 03';

678:
679: END IF;
680:
681:
682: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 03';
683: IF (g_po_wf_debug = 'Y') THEN
684: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
685: END IF;
686:

Line 692: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);

688:
689: WHEN OTHERS THEN
690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
692: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
694: raise;
695:
696: END Is_forward_to_provided;

Line 693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');

689: WHEN OTHERS THEN
690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
692: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
693: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
694: raise;
695:
696: END Is_forward_to_provided;
697:

Line 723: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 01';

719: l_preparer_user_name varchar2(100);
720:
721: BEGIN
722:
723: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 01';
724: IF (g_po_wf_debug = 'Y') THEN
725: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
726: END IF;
727:

Line 776: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 02';

772: resultout := wf_engine.eng_completed || ':' || 'N';
773:
774: END IF;
775:
776: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 02';
777: IF (g_po_wf_debug = 'Y') THEN
778: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
779: END IF;
780:

Line 786: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);

782:
783: WHEN OTHERS THEN
784: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
785: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
786: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');
788: raise;
789:
790: END Is_Forward_To_User_Name_Valid;

Line 787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');

783: WHEN OTHERS THEN
784: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
785: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
786: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
787: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_USER_NAME_VALID');
788: raise;
789:
790: END Is_Forward_To_User_Name_Valid;
791:

Line 815: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 01';

811: l_preparer_user_name varchar2(100);
812:
813: BEGIN
814:
815: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 01';
816: IF (g_po_wf_debug = 'Y') THEN
817: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
818: END IF;
819:

Line 850: PO_REQAPPROVAL_FINDAPPRV1.GetApprovalPathId(itemtype,itemkey);

846:
847: END IF;
848:
849:
850: PO_REQAPPROVAL_FINDAPPRV1.GetApprovalPathId(itemtype,itemkey);
851:
852:
853: --
854: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

Line 856: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 02';

852:
853: --
854: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
855: --
856: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 02';
857: IF (g_po_wf_debug = 'Y') THEN
858: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
859: END IF;
860:

Line 867: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);

863:
864: WHEN OTHERS THEN
865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
867: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
869: raise;
870:
871: END Get_approval_path_id;

Line 868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');

864: WHEN OTHERS THEN
865: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
866: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
867: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
868: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
869: raise;
870:
871: END Get_approval_path_id;
872:

Line 893: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 01';

889: l_preparer_user_name varchar2(100);
890:
891: BEGIN
892:
893: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 01';
894: IF (g_po_wf_debug = 'Y') THEN
895: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
896: END IF;
897:

Line 929: l_forward_mode := PO_REQAPPROVAL_FINDAPPRV1.GetForwardMode(itemtype, itemkey);

925:
926: END IF;
927:
928:
929: l_forward_mode := PO_REQAPPROVAL_FINDAPPRV1.GetForwardMode(itemtype, itemkey);
930:
931: IF l_forward_mode = 'DIRECT' THEN
932:
933: resultout := wf_engine.eng_completed || ':' || 'DIRECT';

Line 941: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 02';

937: resultout := wf_engine.eng_completed || ':' || 'HIERARCHY';
938:
939: END IF;
940:
941: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 02';
942: IF (g_po_wf_debug = 'Y') THEN
943: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
944: END IF;
945:

Line 952: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);

948:
949: WHEN OTHERS THEN
950: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
951: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
952: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
954: raise;
955:
956:

Line 953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');

949: WHEN OTHERS THEN
950: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
951: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
952: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
953: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
954: raise;
955:
956:
957: END Get_Forward_mode;

Line 977: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 01';

973: l_preparer_user_name varchar2(100);
974:
975: BEGIN
976:
977: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 01';
978: IF (g_po_wf_debug = 'Y') THEN
979: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
980: END IF;
981:

Line 1012: l_use_positions_flag := PO_REQAPPROVAL_FINDAPPRV1.UsePositionFlag;

1008:
1009: END IF;
1010:
1011:
1012: l_use_positions_flag := PO_REQAPPROVAL_FINDAPPRV1.UsePositionFlag;
1013:
1014: IF l_use_positions_flag = 'Y' THEN
1015:
1016: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 1024: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 02';

1020: resultout := wf_engine.eng_completed || ':' || 'N';
1021:
1022: END IF;
1023:
1024: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 02';
1025: IF (g_po_wf_debug = 'Y') THEN
1026: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1027: END IF;
1028:

Line 1034: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);

1030:
1031: WHEN OTHERS THEN
1032: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1033: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1034: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1036: raise;
1037:
1038:

Line 1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');

1031: WHEN OTHERS THEN
1032: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1033: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1034: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1035: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1036: raise;
1037:
1038:
1039: END Use_Position_flag;

Line 1062: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: 01';

1058: l_preparer_user_name varchar2(100);
1059:
1060: BEGIN
1061:
1062: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: 01';
1063: IF (g_po_wf_debug = 'Y') THEN
1064: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1065: END IF;
1066:

Line 1099: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier(itemtype, itemkey);

1095: END IF;
1096:
1097:
1098:
1099: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier(itemtype, itemkey);
1100:
1101: IF l_found_manager = 'Y' THEN
1102:
1103: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 1104: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=Y';

1100:
1101: IF l_found_manager = 'Y' THEN
1102:
1103: resultout := wf_engine.eng_completed || ':' || 'Y';
1104: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=Y';
1105:
1106: ELSIF l_found_manager = 'N' THEN
1107:
1108: resultout := wf_engine.eng_completed || ':' || 'N';

Line 1109: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=N';

1105:
1106: ELSIF l_found_manager = 'N' THEN
1107:
1108: resultout := wf_engine.eng_completed || ':' || 'N';
1109: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=N';
1110:
1111: END IF;
1112:
1113: IF (g_po_wf_debug = 'Y') THEN

Line 1122: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);

1118:
1119: WHEN OTHERS THEN
1120: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1121: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1122: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1124: raise;
1125:
1126: END GetMgr_hr_hier;

Line 1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');

1119: WHEN OTHERS THEN
1120: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1121: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1122: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1123: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1124: raise;
1125:
1126: END GetMgr_hr_hier;
1127:

Line 1151: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: 01';

1147: l_preparer_user_name varchar2(100);
1148:
1149: BEGIN
1150:
1151: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: 01';
1152: IF (g_po_wf_debug = 'Y') THEN
1153: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1154: END IF;
1155:

Line 1186: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier(itemtype, itemkey);

1182:
1183: END IF;
1184:
1185:
1186: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier(itemtype, itemkey);
1187:
1188: IF l_found_manager = 'Y' THEN
1189:
1190: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 1191: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=Y';

1187:
1188: IF l_found_manager = 'Y' THEN
1189:
1190: resultout := wf_engine.eng_completed || ':' || 'Y';
1191: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=Y';
1192:
1193: ELSIF l_found_manager = 'N' THEN
1194:
1195: resultout := wf_engine.eng_completed || ':' || 'N';

Line 1196: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=N';

1192:
1193: ELSIF l_found_manager = 'N' THEN
1194:
1195: resultout := wf_engine.eng_completed || ':' || 'N';
1196: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=N';
1197:
1198: END IF;
1199:
1200: IF (g_po_wf_debug = 'Y') THEN

Line 1209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);

1205:
1206: WHEN OTHERS THEN
1207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1211: raise;
1212:
1213:

Line 1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');

1206: WHEN OTHERS THEN
1207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1210: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1211: raise;
1212:
1213:
1214: END GetMgr_po_hier;

Line 1354: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','IsForwardToProvided',x_progress);

1350:
1351: EXCEPTION
1352:
1353: WHEN OTHERS THEN
1354: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','IsForwardToProvided',x_progress);
1355: raise;
1356:
1357: END IsForwardToProvided;
1358:

Line 1433: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','CheckForwardTo',x_progress);

1429:
1430: EXCEPTION
1431:
1432: WHEN OTHERS THEN
1433: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','CheckForwardTo',x_progress);
1434: raise;
1435:
1436: END CheckForwardTo;
1437:

Line 1487: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetApprovalPathId',x_progress);

1483:
1484: EXCEPTION
1485:
1486: WHEN OTHERS THEN
1487: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetApprovalPathId',x_progress);
1488: raise;
1489:
1490:
1491: END GetApprovalPathId;

Line 1524: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetForwardMode',x_progress);

1520: x_progress := '002';
1521: EXCEPTION
1522:
1523: WHEN OTHERS THEN
1524: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetForwardMode',x_progress);
1525: raise;
1526:
1527: END GetForwardMode;
1528:

Line 1547: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','UsePositionFlag',x_progress);

1543: x_progress := '002';
1544: EXCEPTION
1545:
1546: WHEN OTHERS THEN
1547: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','UsePositionFlag',x_progress);
1548: raise;
1549:
1550: END UsePositionFlag;
1551:

Line 1668: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier Business_group_id= ' ||

1664: SELECT business_group_id
1665: INTO l_business_group_id
1666: FROM FINANCIALS_SYSTEM_PARAMETERS;
1667:
1668: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier Business_group_id= ' ||
1669: to_char(l_business_group_id);
1670:
1671: if x_hr_profile = 'Y' then
1672: OPEN C2(l_empid);

Line 1840: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgrHRHier',x_progress);

1836:
1837: EXCEPTION
1838:
1839: WHEN OTHERS THEN
1840: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgrHRHier',x_progress);
1841: raise;
1842:
1843: END GetMgrHRHier;
1844:

Line 1903: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier: approval_path_id= ' ||

1899:
1900: open C1(l_empid, l_approval_path_id);
1901: fetch C1 into l_superior_id, l_superior_level, l_full_name;
1902:
1903: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier: approval_path_id= ' ||
1904: to_char(l_approval_path_id) || ' employee_id=' ||
1905: to_char(l_empid) || ' supervisor_id=' || to_char(l_superior_id);
1906: IF (g_po_wf_debug = 'Y') THEN
1907: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 2050: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgrPOHier',x_progress);

2046:
2047: EXCEPTION
2048:
2049: WHEN OTHERS THEN
2050: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgrPOHier',x_progress);
2051: raise;
2052:
2053: END GetMgrPOHier;
2054:

Line 2096: end PO_REQAPPROVAL_FINDAPPRV1;

2092: END CheckOwnerCanApprove;
2093:
2094: --
2095:
2096: end PO_REQAPPROVAL_FINDAPPRV1;