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.9.12020000.2 2013/02/10 19:28:13 vegajula 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 74: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 01';

70: l_error_msg varchar2(500);
71:
72: BEGIN
73:
74: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 01';
75: IF (g_po_wf_debug = 'Y') THEN
76: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
77: END IF;
78:

Line 94: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: l_error_msg: ';

90: IF itemtype in ('POAPPRV') THEN
91: l_error_msg := wf_engine.GetItemAttrText (itemtype => itemtype,
92: itemkey => itemkey,
93: aname => 'WRONG_FORWARD_TO_MSG');
94: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: l_error_msg: ';
95: IF (g_po_wf_debug = 'Y') THEN
96: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress || l_error_msg);
97: END IF;
98:

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

194: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
195:
196: resultout := 'COMPLETE' ;
197:
198: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Forward_To_From_App_fwd: 02';
199: IF (g_po_wf_debug = 'Y') THEN
200: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
201: END IF;
202:

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

205:
206: WHEN OTHERS THEN
207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
210: 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');
211: raise;
212:
213: END Set_Forward_To_From_App_fwd;

Line 210: 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');

206: WHEN OTHERS THEN
207: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
208: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
209: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Forward_To_From_App_fwd',x_progress);
210: 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');
211: raise;
212:
213: END Set_Forward_To_From_App_fwd;
214: --

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

234: /*Bug 9593873 */
235:
236: BEGIN
237:
238: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 01';
239: IF (g_po_wf_debug = 'Y') THEN
240: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
241: END IF;
242:

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

392: -- resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
393:
394: resultout := 'COMPLETE' ;
395:
396: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Set_Fwd_To_From_App_timeout: 02';
397: IF (g_po_wf_debug = 'Y') THEN
398: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
399: END IF;
400:

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

402:
403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
407: 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');
408: raise;
409:
410: END Set_Fwd_To_From_App_timeout;

Line 407: 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');

403: WHEN OTHERS THEN
404: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
405: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
406: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Set_Fwd_To_From_App_timeout',x_progress);
407: 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');
408: raise;
409:
410: END Set_Fwd_To_From_App_timeout;
411: --

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

451: /*Bug 9593873 */
452:
453: BEGIN
454:
455: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 01';
456: IF (g_po_wf_debug = 'Y') THEN
457: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
458: END IF;
459:

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

509: END IF;
510:
511: IF CheckForwardTo(l_forward_to_username_response, x_user_id) = 'Y' THEN
512:
513: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 010 '||
514: 'x_user_id: ' ||x_user_id;
515: IF (g_po_wf_debug = 'Y') THEN
516: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
517: END IF;

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

568: ** Desc: If the forward to person is the preparer and the
569: ** owner can approve flag is set to N then return the Notification
570: ** to the responder with Invalid Forward to Message
571: */
572: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 015';
573: IF (g_po_wf_debug = 'Y') THEN
574: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
575: END IF;
576:

Line 582: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,

578: itemkey => itemkey,
579: aname => 'PREPARER_ID');
580:
581: if (x_user_id = l_preparer_id) then
582: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,
583: x_CanOwnerApproveFlag);
584:
585: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||
586: 'x_CanOwnerApproveFlag: '||x_CanOwnerApproveFlag;

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

581: if (x_user_id = l_preparer_id) then
582: PO_REQAPPROVAL_FINDAPPRV1.CheckOwnerCanApprove(itemtype, itemkey,
583: x_CanOwnerApproveFlag);
584:
585: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 020 ' ||
586: 'x_CanOwnerApproveFlag: '||x_CanOwnerApproveFlag;
587: IF (g_po_wf_debug = 'Y') THEN
588: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
589: END IF;

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

589: END IF;
590:
591: if x_CanOwnerApproveFlag = 'N' then
592:
593: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 025';
594: IF (g_po_wf_debug = 'Y') THEN
595: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
596: END IF;
597:

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

609: avalue => l_error_msg);
610:
611: resultout := wf_engine.eng_completed || ':' || 'N';
612:
613: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 050';
614: IF (g_po_wf_debug = 'Y') THEN
615: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
616: END IF;
617:

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

620: end if;
621:
622: /* end fix Bug# 1496490 */
623:
624: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_Forward_To_Valid: 060';
625: IF (g_po_wf_debug = 'Y') THEN
626: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
627: END IF;
628:

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

783: l_preparer_user_name varchar2(100);
784:
785: BEGIN
786:
787: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 01';
788: IF (g_po_wf_debug = 'Y') THEN
789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
790: END IF;
791:

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

820:
821: END IF;
822:
823:
824: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_provided: 03';
825: IF (g_po_wf_debug = 'Y') THEN
826: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
827: END IF;
828:

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

830:
831: WHEN OTHERS THEN
832: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
833: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
834: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
835: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
836: raise;
837:
838: END Is_forward_to_provided;

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

831: WHEN OTHERS THEN
832: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
833: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
834: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_provided',x_progress);
835: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.IS_FORWARD_TO_PROVIDED');
836: raise;
837:
838: END Is_forward_to_provided;
839:

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

861: l_preparer_user_name varchar2(100);
862:
863: BEGIN
864:
865: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 01';
866: IF (g_po_wf_debug = 'Y') THEN
867: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
868: END IF;
869:

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

914: resultout := wf_engine.eng_completed || ':' || 'N';
915:
916: END IF;
917:
918: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Is_forward_to_user_name_valid: 02';
919: IF (g_po_wf_debug = 'Y') THEN
920: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
921: END IF;
922:

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

924:
925: WHEN OTHERS THEN
926: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
927: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
928: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
929: 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');
930: raise;
931:
932: END Is_Forward_To_User_Name_Valid;

Line 929: 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');

925: WHEN OTHERS THEN
926: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
927: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
928: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Is_forward_to_user_name_valid',x_progress);
929: 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');
930: raise;
931:
932: END Is_Forward_To_User_Name_Valid;
933:

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

953: l_preparer_user_name varchar2(100);
954:
955: BEGIN
956:
957: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 01';
958: IF (g_po_wf_debug = 'Y') THEN
959: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
960: END IF;
961:

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

988:
989: END IF;
990:
991:
992: PO_REQAPPROVAL_FINDAPPRV1.GetApprovalPathId(itemtype,itemkey);
993:
994:
995: --
996: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

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

994:
995: --
996: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
997: --
998: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_approval_path_id: 02';
999: IF (g_po_wf_debug = 'Y') THEN
1000: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1001: END IF;
1002:

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

1005:
1006: WHEN OTHERS THEN
1007: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1008: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1009: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
1010: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
1011: raise;
1012:
1013: END Get_approval_path_id;

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

1006: WHEN OTHERS THEN
1007: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1008: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1009: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_approval_path_id',x_progress);
1010: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_APPROVAL_PATH_ID');
1011: raise;
1012:
1013: END Get_approval_path_id;
1014:

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

1031: l_preparer_user_name varchar2(100);
1032:
1033: BEGIN
1034:
1035: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 01';
1036: IF (g_po_wf_debug = 'Y') THEN
1037: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1038: END IF;
1039:

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

1067:
1068: END IF;
1069:
1070:
1071: l_forward_mode := PO_REQAPPROVAL_FINDAPPRV1.GetForwardMode(itemtype, itemkey);
1072:
1073: IF l_forward_mode = 'DIRECT' THEN
1074:
1075: resultout := wf_engine.eng_completed || ':' || 'DIRECT';

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

1079: resultout := wf_engine.eng_completed || ':' || 'HIERARCHY';
1080:
1081: END IF;
1082:
1083: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Get_Forward_mode: 02';
1084: IF (g_po_wf_debug = 'Y') THEN
1085: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1086: END IF;
1087:

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

1090:
1091: WHEN OTHERS THEN
1092: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1093: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1094: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
1095: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
1096: raise;
1097:
1098:

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

1091: WHEN OTHERS THEN
1092: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1093: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1094: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Get_Forward_mode',x_progress);
1095: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GET_FORWARD_MODE');
1096: raise;
1097:
1098:
1099: END Get_Forward_mode;

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

1115: l_preparer_user_name varchar2(100);
1116:
1117: BEGIN
1118:
1119: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 01';
1120: IF (g_po_wf_debug = 'Y') THEN
1121: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1122: END IF;
1123:

Line 1154: l_use_positions_flag := PO_REQAPPROVAL_FINDAPPRV1.UsePositionFlag;

1150:
1151: END IF;
1152:
1153:
1154: l_use_positions_flag := PO_REQAPPROVAL_FINDAPPRV1.UsePositionFlag;
1155:
1156: IF l_use_positions_flag = 'Y' THEN
1157:
1158: resultout := wf_engine.eng_completed || ':' || 'Y';

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

1162: resultout := wf_engine.eng_completed || ':' || 'N';
1163:
1164: END IF;
1165:
1166: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.Use_Position_flag: 02';
1167: IF (g_po_wf_debug = 'Y') THEN
1168: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1169: END IF;
1170:

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

1172:
1173: WHEN OTHERS THEN
1174: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1175: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1176: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1177: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1178: raise;
1179:
1180:

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

1173: WHEN OTHERS THEN
1174: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1175: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1176: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','Use_Position_flag',x_progress);
1177: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.USE_POSITION_FLAG');
1178: raise;
1179:
1180:
1181: END Use_Position_flag;

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

1200: l_preparer_user_name varchar2(100);
1201:
1202: BEGIN
1203:
1204: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: 01';
1205: IF (g_po_wf_debug = 'Y') THEN
1206: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1207: END IF;
1208:

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

1237: END IF;
1238:
1239:
1240:
1241: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier(itemtype, itemkey);
1242:
1243: IF l_found_manager = 'Y' THEN
1244:
1245: resultout := wf_engine.eng_completed || ':' || 'Y';

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

1242:
1243: IF l_found_manager = 'Y' THEN
1244:
1245: resultout := wf_engine.eng_completed || ':' || 'Y';
1246: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=Y';
1247:
1248: ELSIF l_found_manager = 'N' THEN
1249:
1250: resultout := wf_engine.eng_completed || ':' || 'N';

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

1247:
1248: ELSIF l_found_manager = 'N' THEN
1249:
1250: resultout := wf_engine.eng_completed || ':' || 'N';
1251: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_hr_hier: RESULT=N';
1252:
1253: END IF;
1254:
1255: IF (g_po_wf_debug = 'Y') THEN

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

1260:
1261: WHEN OTHERS THEN
1262: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1263: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1264: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1265: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1266: raise;
1267:
1268: END GetMgr_hr_hier;

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

1261: WHEN OTHERS THEN
1262: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1263: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1264: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_hr_hier',x_progress);
1265: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_HR_HIER');
1266: raise;
1267:
1268: END GetMgr_hr_hier;
1269:

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

1289: l_preparer_user_name varchar2(100);
1290:
1291: BEGIN
1292:
1293: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: 01';
1294: IF (g_po_wf_debug = 'Y') THEN
1295: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1296: END IF;
1297:

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

1324:
1325: END IF;
1326:
1327:
1328: l_found_manager := PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier(itemtype, itemkey);
1329:
1330: IF l_found_manager = 'Y' THEN
1331:
1332: resultout := wf_engine.eng_completed || ':' || 'Y';

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

1329:
1330: IF l_found_manager = 'Y' THEN
1331:
1332: resultout := wf_engine.eng_completed || ':' || 'Y';
1333: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=Y';
1334:
1335: ELSIF l_found_manager = 'N' THEN
1336:
1337: resultout := wf_engine.eng_completed || ':' || 'N';

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

1334:
1335: ELSIF l_found_manager = 'N' THEN
1336:
1337: resultout := wf_engine.eng_completed || ':' || 'N';
1338: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgr_po_hier: RESULT=N';
1339:
1340: END IF;
1341:
1342: IF (g_po_wf_debug = 'Y') THEN

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

1347:
1348: WHEN OTHERS THEN
1349: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1350: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1351: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1352: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1353: raise;
1354:
1355:

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

1348: WHEN OTHERS THEN
1349: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1350: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1351: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgr_po_hier',x_progress);
1352: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_FINDAPPRV1.GETMGR_PO_HIER');
1353: raise;
1354:
1355:
1356: END GetMgr_po_hier;

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

1492:
1493: EXCEPTION
1494:
1495: WHEN OTHERS THEN
1496: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','IsForwardToProvided',x_progress);
1497: raise;
1498:
1499: END IsForwardToProvided;
1500:

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

1571:
1572: EXCEPTION
1573:
1574: WHEN OTHERS THEN
1575: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','CheckForwardTo',x_progress);
1576: raise;
1577:
1578: END CheckForwardTo;
1579:

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

1625:
1626: EXCEPTION
1627:
1628: WHEN OTHERS THEN
1629: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetApprovalPathId',x_progress);
1630: raise;
1631:
1632:
1633: END GetApprovalPathId;

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

1662: x_progress := '002';
1663: EXCEPTION
1664:
1665: WHEN OTHERS THEN
1666: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetForwardMode',x_progress);
1667: raise;
1668:
1669: END GetForwardMode;
1670:

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

1685: x_progress := '002';
1686: EXCEPTION
1687:
1688: WHEN OTHERS THEN
1689: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','UsePositionFlag',x_progress);
1690: raise;
1691:
1692: END UsePositionFlag;
1693:

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

1816: SELECT business_group_id
1817: INTO l_business_group_id
1818: FROM FINANCIALS_SYSTEM_PARAMETERS;
1819:
1820: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrHRHier Business_group_id= ' ||
1821: to_char(l_business_group_id);
1822:
1823: if x_hr_profile = 'Y' then
1824: OPEN C2(l_empid);

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

1988:
1989: EXCEPTION
1990:
1991: WHEN OTHERS THEN
1992: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgrHRHier',x_progress);
1993: raise;
1994:
1995: END GetMgrHRHier;
1996:

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

2085:
2086: open C1(l_empid, l_approval_path_id);
2087: fetch C1 into l_superior_id, l_superior_level, l_full_name;
2088:
2089: x_progress := 'PO_REQAPPROVAL_FINDAPPRV1.GetMgrPOHier: approval_path_id= ' ||
2090: to_char(l_approval_path_id) || ' employee_id=' ||
2091: to_char(l_empid) || ' supervisor_id=' || to_char(l_superior_id);
2092: IF (g_po_wf_debug = 'Y') THEN
2093: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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

2232:
2233: EXCEPTION
2234:
2235: WHEN OTHERS THEN
2236: wf_core.context('PO_REQAPPROVAL_FINDAPPRV1','GetMgrPOHier',x_progress);
2237: raise;
2238:
2239: END GetMgrPOHier;
2240:

Line 2282: end PO_REQAPPROVAL_FINDAPPRV1;

2278: END CheckOwnerCanApprove;
2279:
2280: --
2281:
2282: end PO_REQAPPROVAL_FINDAPPRV1;