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_RCO_WF_PVT dependencies on POR_AME_RCO_WF_PVT

Line 1: PACKAGE BODY POR_AME_RCO_WF_PVT AS

1: PACKAGE BODY POR_AME_RCO_WF_PVT AS
2: /* $Header: POXAMERB.pls 120.9.12000000.2 2007/02/13 00:57:49 dkfchan 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 182: wf_core.context('POR_AME_RCO_WF_PVT','Get_Next_Approvers-Unexpected Exception:',l_progress,sqlerrm);

178: EXCEPTION
179: WHEN OTHERS THEN
180: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
181: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
182: wf_core.context('POR_AME_RCO_WF_PVT','Get_Next_Approvers-Unexpected Exception:',l_progress,sqlerrm);
183:
184: IF (g_po_wf_debug = 'Y') THEN
185: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
186: END IF;

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

184: IF (g_po_wf_debug = 'Y') THEN
185: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
186: END IF;
187:
188: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.GET_NEXT_APPROVERS');
189: resultout:='COMPLETE:'||'INVALID_APPROVER';
190: return;
191: END Get_Next_Approvers;
192:

Line 525: wf_core.context('POR_AME_RCO_WF_PVT','Launch_Parallel_Approval',l_progress,sqlerrm);

521: when NO_DATA_FOUND then
522: l_progress:= '50: start_wf_line_process: NO_DATA_FOUND -- EXCEPTION';
523: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
524: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
525: wf_core.context('POR_AME_RCO_WF_PVT','Launch_Parallel_Approval',l_progress,sqlerrm);
526:
527: IF (g_po_wf_debug = 'Y') THEN
528: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
529: END IF;

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

526:
527: IF (g_po_wf_debug = 'Y') THEN
528: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
529: END IF;
530: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.GET_NEXT_APPROVER');
531: raise;
532: when others then
533: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
534: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 536: wf_core.context('POR_AME_RCO_WF_PVT','Launch_Parallel_Approval',l_progress,sqlerrm);

532: when others then
533: l_progress:= '50: start_wf_line_process: IN EXCEPTION';
534: l_doc_string := l_progress || PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
535: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
536: wf_core.context('POR_AME_RCO_WF_PVT','Launch_Parallel_Approval',l_progress,sqlerrm);
537:
538: IF (g_po_wf_debug = 'Y') THEN
539: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
540: END IF;

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

538: IF (g_po_wf_debug = 'Y') THEN
539: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
540: END IF;
541:
542: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.GET_NEXT_APPROVER');
543: raise;
544:
545: end Launch_Parallel_Approval;
546:

Line 1039: wf_core.context('POR_AME_RCO_WF_PVT','Insert_Action_History',l_progress,sqlerrm);

1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1038: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1039: wf_core.context('POR_AME_RCO_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
1040: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.INSERT_ACTION_HISTORY');
1041: RAISE;
1042: END Insert_Action_History;
1043:

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

1036: WHEN OTHERS THEN
1037: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1038: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1039: wf_core.context('POR_AME_RCO_WF_PVT','Insert_Action_History',l_progress,sqlerrm);
1040: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.INSERT_ACTION_HISTORY');
1041: RAISE;
1042: END Insert_Action_History;
1043:
1044:

Line 1156: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);

1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1155: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1156: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
1157: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
1158: RAISE;
1159:
1160: END Update_Action_History_Approve;

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

1153: WHEN OTHERS THEN
1154: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1155: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1156: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
1157: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE');
1158: RAISE;
1159:
1160: END Update_Action_History_Approve;
1161:

Line 1275: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);

1271: EXCEPTION
1272: WHEN OTHERS THEN
1273: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1274: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1275: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
1276: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Update_Action_History_Reject');
1277: RAISE;
1278:
1279: END Update_Action_History_Reject;

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

1272: WHEN OTHERS THEN
1273: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1274: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1275: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
1276: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Update_Action_History_Reject');
1277: RAISE;
1278:
1279: END Update_Action_History_Reject;
1280:

Line 1432: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 01';

1428: l_preparer_user_name varchar2(100);
1429:
1430: BEGIN
1431:
1432: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 01';
1433:
1434: if (funcmode <> wf_engine.eng_run) then
1435: resultout := wf_engine.eng_null;
1436: return;

Line 1447: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 02 - l_doc_header_id ' || l_doc_header_id || ' -- l_doc_type :' || l_doc_type ;

1443: l_doc_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1444: itemkey => itemkey,
1445: aname => 'DOCUMENT_TYPE');
1446:
1447: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 02 - l_doc_header_id ' || l_doc_header_id || ' -- l_doc_type :' || l_doc_type ;
1448: IF (g_po_wf_debug = 'Y') THEN
1449: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1450: END IF;
1451:

Line 1464: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 03';

1460: avalue => 'APPROVED');
1461:
1462: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1463:
1464: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved: 03';
1465: IF (g_po_wf_debug = 'Y') THEN
1466: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1467: END IF;
1468:

Line 1473: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Approved',x_progress);

1469: EXCEPTION
1470: WHEN OTHERS THEN
1471: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1472: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1473: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Approved',x_progress);
1474: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved');
1475: raise;
1476: END Set_Rco_Stat_Approved;
1477:

Line 1474: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved');

1470: WHEN OTHERS THEN
1471: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1472: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1473: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Approved',x_progress);
1474: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Approved');
1475: raise;
1476: END Set_Rco_Stat_Approved;
1477:
1478:

Line 1519: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 01';

1515: l_preparer_user_name varchar2(100);
1516:
1517: BEGIN
1518:
1519: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 01';
1520:
1521: if (funcmode <> wf_engine.eng_run) then
1522: resultout := wf_engine.eng_null;
1523: return;

Line 1530: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 02 - l_doc_header_id ' || l_doc_header_id;

1526: l_doc_header_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1527: itemkey => itemkey,
1528: aname => 'DOCUMENT_ID');
1529:
1530: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 02 - l_doc_header_id ' || l_doc_header_id;
1531: IF (g_po_wf_debug = 'Y') THEN
1532: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1533: END IF;
1534:

Line 1547: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 03';

1543: avalue => 'REJECTED');
1544:
1545: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1546:
1547: x_progress := 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected: 03';
1548: IF (g_po_wf_debug = 'Y') THEN
1549: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1550: END IF;
1551:

Line 1556: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Rejected',x_progress);

1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1555: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1556: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Rejected',x_progress);
1557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected');
1558: raise;
1559: END Set_Rco_Stat_Rejected;
1560:

Line 1557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected');

1553: WHEN OTHERS THEN
1554: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1555: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1556: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Rejected',x_progress);
1557: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_RCO_WF_PVT.Set_Rco_Stat_Rejected');
1558: raise;
1559: END Set_Rco_Stat_Rejected;
1560:
1561: --------------------------------------------------------------------------------

Line 1819: END POR_AME_RCO_WF_PVT;

1815: return 'Y';
1816: END is_last_approver_record;
1817:
1818:
1819: END POR_AME_RCO_WF_PVT;