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.11 2011/01/19 09:34:12 vsdesai 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 526: wf_core.context('POR_AME_RCO_WF_PVT','Launch_Parallel_Approval',l_progress,sqlerrm);

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

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

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

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

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

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

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

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

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

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

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

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

1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1156: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1157: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
1158: 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');
1159: RAISE;
1160:
1161: END Update_Action_History_Approve;

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

1154: WHEN OTHERS THEN
1155: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1156: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1157: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Approve',l_progress,sqlerrm);
1158: 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');
1159: RAISE;
1160:
1161: END Update_Action_History_Approve;
1162:

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

1272: EXCEPTION
1273: WHEN OTHERS THEN
1274: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1275: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1276: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
1277: 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');
1278: RAISE;
1279:
1280: END Update_Action_History_Reject;

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

1273: WHEN OTHERS THEN
1274: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1275: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1276: wf_core.context('POR_AME_RCO_WF_PVT','Update_Action_History_Reject',l_progress,sqlerrm);
1277: 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');
1278: RAISE;
1279:
1280: END Update_Action_History_Reject;
1281:

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

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

Line 1448: 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 ;

1444: l_doc_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1445: itemkey => itemkey,
1446: aname => 'DOCUMENT_TYPE');
1447:
1448: 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 ;
1449: IF (g_po_wf_debug = 'Y') THEN
1450: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1451: END IF;
1452:

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

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

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

1470: EXCEPTION
1471: WHEN OTHERS THEN
1472: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1473: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1474: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Approved',x_progress);
1475: 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');
1476: raise;
1477: END Set_Rco_Stat_Approved;
1478:

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

1471: WHEN OTHERS THEN
1472: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1473: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1474: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Approved',x_progress);
1475: 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');
1476: raise;
1477: END Set_Rco_Stat_Approved;
1478:
1479:

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

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

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

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

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

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

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

1553: EXCEPTION
1554: WHEN OTHERS THEN
1555: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1556: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1557: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Rejected',x_progress);
1558: 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');
1559: raise;
1560: END Set_Rco_Stat_Rejected;
1561:

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

1554: WHEN OTHERS THEN
1555: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1556: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1557: wf_core.context('POR_AME_RCO_WF_PVT','Set_Rco_Stat_Rejected',x_progress);
1558: 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');
1559: raise;
1560: END Set_Rco_Stat_Rejected;
1561:
1562: --------------------------------------------------------------------------------

Line 1821: END POR_AME_RCO_WF_PVT;

1817: return 'Y';
1818: END is_last_approver_record;
1819:
1820:
1821: END POR_AME_RCO_WF_PVT;