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.POR_AME_REQ_WF_PVT dependencies on POR_AME_REQ_WF_PVT

Line 1: PACKAGE BODY POR_AME_REQ_WF_PVT AS

1: PACKAGE BODY POR_AME_REQ_WF_PVT AS
2: /* $Header: POXAMEPB.pls 120.77.12020000.5 2013/03/22 10:40:04 inagdeo 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 179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);

175: WHEN OTHERS THEN
176:
177: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
178: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
180:
181: IF (g_po_wf_debug = 'Y') THEN
182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);

Line 182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);

178: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
180:
181: IF (g_po_wf_debug = 'Y') THEN
182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
184: END IF;
185:
186: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS',l_document_id);

Line 186: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS',l_document_id);

182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
184: END IF;
185:
186: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS',l_document_id);
187:
188: resultout:='COMPLETE:'||'INVALID_APPROVER';
189: return;
190: END;

Line 248: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);

244: WHEN OTHERS THEN
245:
246: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
247: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
248: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);
249:
250: IF (g_po_wf_debug = 'Y') THEN
251: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
252: END IF;

Line 254: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');

250: IF (g_po_wf_debug = 'Y') THEN
251: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
252: END IF;
253:
254: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');
255: resultout:='COMPLETE:'||'INVALID_APPROVER';
256: return;
257: END Get_Next_Approvers;
258:

Line 945: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);

941: when NO_DATA_FOUND then
942: l_progress:= '50: start_wf_line_process: NO_DATA_FOUND -- EXCEPTION';
943: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
945: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);
946:
947: IF (g_po_wf_debug = 'Y') THEN
948: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
949: END IF;

Line 950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');

946:
947: IF (g_po_wf_debug = 'Y') THEN
948: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
949: END IF;
950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
951: raise;
952: when others then
953: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
954: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 956: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);

952: when others then
953: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
954: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
955: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
956: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);
957:
958: IF (g_po_wf_debug = 'Y') THEN
959: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
960: END IF;

Line 962: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');

958: IF (g_po_wf_debug = 'Y') THEN
959: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
960: END IF;
961:
962: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
963: raise;
964:
965: end Launch_Parallel_Approval;
966:

Line 1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);

1583: exception
1584: when others then
1585: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1586: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);
1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');
1589: RAISE;
1590:
1591: end Process_Beat_By_First;

Line 1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');

1584: when others then
1585: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1586: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1587: wf_core.context('POR_AME_REQ_WF_PVT','Process_Beat_By_First',l_progress,sqlerrm);
1588: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Process_Beat_By_First');
1589: RAISE;
1590:
1591: end Process_Beat_By_First;
1592:

Line 2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);

2381: EXCEPTION
2382: WHEN OTHERS THEN
2383: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2384: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
2386: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.INSERT_ACTION_HISTORY');
2387: RAISE;
2388: END Insert_Action_History;
2389:

Line 2386: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.INSERT_ACTION_HISTORY');

2382: WHEN OTHERS THEN
2383: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2384: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2385: wf_core.context('POR_AME_REQ_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
2386: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.INSERT_ACTION_HISTORY');
2387: RAISE;
2388: END Insert_Action_History;
2389:
2390:

Line 2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);

2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2534: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
2536: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
2537: RAISE;
2538:
2539: END Update_Action_History_Approve;

Line 2536: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');

2532: WHEN OTHERS THEN
2533: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2534: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2535: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
2536: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
2537: RAISE;
2538:
2539: END Update_Action_History_Approve;
2540:

Line 2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);

2681: EXCEPTION
2682: WHEN OTHERS THEN
2683: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2684: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');
2687: RAISE;
2688:
2689: END Update_Action_History_Reject;

Line 2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');

2682: WHEN OTHERS THEN
2683: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2684: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2685: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
2686: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Reject');
2687: RAISE;
2688:
2689: END Update_Action_History_Reject;
2690:

Line 2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);

2825: EXCEPTION
2826: WHEN OTHERS THEN
2827: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2828: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);
2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');
2831: RAISE;
2832:
2833: END Update_Action_History_Timeout;

Line 2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');

2826: WHEN OTHERS THEN
2827: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2828: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2829: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Timeout',l_progress,sqlerrm);
2830: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_Timeout');
2831: RAISE;
2832:
2833: END Update_Action_History_Timeout;
2834:

Line 2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);

2969: EXCEPTION
2970: WHEN OTHERS THEN
2971: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2972: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);
2974: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_FORWARD');
2975: RAISE;
2976:
2977: END Update_Action_History_Forward;

Line 2974: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_FORWARD');

2970: WHEN OTHERS THEN
2971: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2972: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2973: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_Forward',l_progress,sqlerrm);
2974: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_FORWARD');
2975: RAISE;
2976:
2977: END Update_Action_History_Forward;
2978:

Line 3017: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 01';

3013: l_preparer_user_name varchar2(100);
3014:
3015: BEGIN
3016:
3017: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 01';
3018:
3019: if (funcmode <> wf_engine.eng_run) then
3020: resultout := wf_engine.eng_null;
3021: return;

Line 3052: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 02 - l_doc_header_id ' || l_doc_header_id || ' -- l_doc_type :' || l_doc_type ;

3048: l_note := NULL;
3049: END;
3050:
3051:
3052: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 02 - l_doc_header_id ' || l_doc_header_id || ' -- l_doc_type :' || l_doc_type ;
3053:
3054: IF (g_po_wf_debug = 'Y') THEN
3055: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3056: END IF;

Line 3068: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 03';

3064: END IF;
3065:
3066: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3067:
3068: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 03';
3069: IF (g_po_wf_debug = 'Y') THEN
3070: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3071: END IF;
3072:

Line 3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);

3073: EXCEPTION
3074: WHEN OTHERS THEN
3075: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3076: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);
3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');
3079: raise;
3080: END Update_Action_History_No_Act;
3081:

Line 3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');

3074: WHEN OTHERS THEN
3075: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3076: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3077: wf_core.context('POR_AME_REQ_WF_PVT','Update_Action_History_No_Act',x_progress);
3078: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act');
3079: raise;
3080: END Update_Action_History_No_Act;
3081:
3082: --------------------------------------------------------------------------------

Line 3193: wf_core.context('POR_AME_REQ_WF_PVT','IS_AME_EXCEPTION: Unexpected Exception:',l_progress,sqlerrm);

3189: END IF;
3190: EXCEPTION
3191: when others then
3192: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3193: wf_core.context('POR_AME_REQ_WF_PVT','IS_AME_EXCEPTION: Unexpected Exception:',l_progress,sqlerrm);
3194: IF (g_po_wf_debug = 'Y') THEN
3195: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
3196: END IF;
3197: raise;

Line 3758: END POR_AME_REQ_WF_PVT;

3754: RETURN;
3755: end Process_Response_Exception;
3756:
3757:
3758: END POR_AME_REQ_WF_PVT;