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 PO_WF_DEBUG_PKG

Line 72: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

68: IF (funcmode = 'RUN') THEN
69:
70: l_progress := 'Get_Next_Approver: 001';
71: IF (g_po_wf_debug = 'Y') THEN
72: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
73: END IF;
74:
75: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
76: itemkey => itemkey,

Line 94: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

90:
91: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'|| l_document_type||'-'||l_document_subtype;
92:
93: IF (g_po_wf_debug = 'Y') THEN
94: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
95: END IF;
96:
97: -- Get the next approver from AME.
98: LOOP

Line 118: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);

114: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
115: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
116:
117: IF (g_po_wf_debug = 'Y') THEN
118: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
119: END IF;
120:
121: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');
122:

Line 129: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

125: END;
126:
127: l_progress := 'Get_Next_Approver: 003- getNextApprovers4(). Approvers :' || g_next_approvers.count || ' -- Approval Process Completed :' || l_completeYNO ;
128: IF (g_po_wf_debug = 'Y') THEN
129: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
130: END IF;
131:
132: if ( g_next_approvers.count > 0 ) then
133:

Line 138: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

134: l_position_has_valid_approvers := position_has_valid_approvers(l_document_id, l_transaction_type) ;
135:
136: l_progress := 'Get_Next_Approver: 004 - l_position_has_valid_approvers :' || l_position_has_valid_approvers;
137: IF (g_po_wf_debug = 'Y') THEN
138: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
139: END IF;
140:
141: l_progress := 'Get_Next_Approver: 005- Approvers after the validation process :' || g_next_approvers.count;
142: IF (g_po_wf_debug = 'Y') THEN

Line 143: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

139: END IF;
140:
141: l_progress := 'Get_Next_Approver: 005- Approvers after the validation process :' || g_next_approvers.count;
142: IF (g_po_wf_debug = 'Y') THEN
143: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
144: END IF;
145:
146: if( g_next_approvers.count = 0 AND 'NO_USERS' = l_position_has_valid_approvers ) then
147: l_need_to_get_next_approver := TRUE;

Line 185: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);

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;
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';

Line 261: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

257: IF (funcmode='RUN') THEN
258:
259: l_progress := 'Launch_Parallel_Approval: 001';
260: IF (g_po_wf_debug = 'Y') THEN
261: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
262: END IF;
263:
264: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
265: itemkey => itemkey,

Line 283: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

279: while ( l_approver_index is not null ) loop
280:
281: l_progress := 'Launch_Parallel_Approval: 002 -- Next Approver :' || g_next_approvers(l_approver_index).name;
282: IF (g_po_wf_debug = 'Y') THEN
283: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
284: END IF;
285:
286: SELECT
287: to_char(l_document_id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)

Line 391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

387: aname => 'AME_TRANSACTION_TYPE');
388:
389: l_progress := 'Launch_Parallel_Approval: 003 -- Record Type :' || g_next_approvers(l_approver_index).orig_system;
390: IF (g_po_wf_debug = 'Y') THEN
391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
392: END IF;
393:
394: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
395: if (g_next_approvers(l_approver_index).orig_system = 'PER') then

Line 453: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

449: WF_DIRECTORY.GetUserName('PER', l_next_approver_id, l_next_approver_user_name, l_next_approver_disp_name);
450:
451: l_progress := 'Launch_Parallel_Approval: 004 -- Next Approver User Name -- display Name:' || l_next_approver_user_name || ' -- ' || l_next_approver_disp_name;
452: IF (g_po_wf_debug = 'Y') THEN
453: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
454: END IF;
455:
456: t_varname(20) := 'APPROVER_USER_NAME';
457: t_varval(20) := l_next_approver_user_name;

Line 465: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);

461:
462: /* Kick off the process */
463: l_progress:= '30: start_wf_line_process: Kicking off StartProcess';
464: IF (g_po_wf_debug = 'Y') THEN
465: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);
466: END IF;
467:
468: t_varname(22) := 'RCO_AME_IS_FYI_APPROVER';
469: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then

Line 501: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

497: Wf_Engine.SetItemAttrNumberArray(itemtype, l_item_key,n_varname,n_varval);
498:
499: l_progress := 'Launch_Parallel_Approval: 005 -- Launch Parallel Approval';
500: IF (g_po_wf_debug = 'Y') THEN
501: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
502: END IF;
503: wf_engine.StartProcess( itemtype => itemtype,
504: itemkey => l_item_key );
505:

Line 529: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );

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;
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

Line 540: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );

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;
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;

Line 584: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

580: begin
581:
582: l_progress := 'Process_Response_Internal: 001';
583: IF (g_po_wf_debug = 'Y') THEN
584: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
585: END IF;
586:
587: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
588: itemkey => itemkey,

Line 601: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

597: aname => 'AME_APPROVER_TYPE');
598:
599: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;
600: IF (g_po_wf_debug = 'Y') THEN
601: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
602: END IF;
603:
604: if (l_approver_type = 'POS') then
605: l_current_approver.orig_system := 'POS';

Line 621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

617: aname => 'AME_APPROVER_ID');
618:
619: l_progress := 'Process_Response_Internal: 003 -- l_current_approver.orig_system_id :' || l_current_approver.orig_system_id ;
620: IF (g_po_wf_debug = 'Y') THEN
621: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
622: END IF;
623:
624: if( p_response = 'APPROVE') then
625: l_current_approver.approval_status := ame_util.approvedStatus;

Line 634: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

630: end if;
631:
632: l_progress := 'Process_Response_Internal: 004 -- p_response :' || p_response ;
633: IF (g_po_wf_debug = 'Y') THEN
634: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
635: END IF;
636:
637: -- Get the name value for the approverRecord2.
638: -- This is a mandatory field. If we do not pass this value to AME, we will get invalid parameter exception.

Line 701: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

697: begin
698:
699: l_progress := 'Process_Response_Approve: 001';
700: IF (g_po_wf_debug = 'Y') THEN
701: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
702: END IF;
703:
704: SELECT parent_item_type, parent_item_key
705: into l_parent_item_type, l_parent_item_key

Line 718: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

714: avalue => 'APPROVE');
715:
716: l_progress := 'Process_Response_Approve: 002 -- Completing the BLOCK activity for the APPROVED notification.';
717: IF (g_po_wf_debug = 'Y') THEN
718: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
719: END IF;
720:
721: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
722: RETURN;

Line 760: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

756: begin
757:
758: l_progress := 'Process_Response_Reject: 001';
759: IF (g_po_wf_debug = 'Y') THEN
760: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
761: END IF;
762:
763: Process_Response_Internal(itemtype, itemkey, 'REJECT');
764:

Line 777: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

773: avalue => 'REJECT');
774:
775: l_progress := 'Process_Response_Reject: 002 -- Completing the BLOCK activity for the REJECTED notification.';
776: IF (g_po_wf_debug = 'Y') THEN
777: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
778: END IF;
779:
780: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
781: RETURN;

Line 820: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

816: begin
817:
818: l_progress := 'Process_Response_Timeout: 001';
819: IF (g_po_wf_debug = 'Y') THEN
820: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
821: END IF;
822:
823: Process_Response_Internal(itemtype, itemkey, 'TIMEOUT');
824:

Line 842: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

838: result => null);
839:
840: l_progress := 'Process_Response_Timeout: 002 -- Completing the BLOCK activity for the REJECTED notification.';
841: IF (g_po_wf_debug = 'Y') THEN
842: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
843: END IF;
844:
845: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
846: RETURN;

Line 978: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

974: BEGIN
975:
976: l_progress := 'Insert_Action_History: 001';
977: IF (g_po_wf_debug = 'Y') THEN
978: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
979: END IF;
980:
981: IF (funcmode='RUN') THEN
982:

Line 1011: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1007: insertActionHistory(l_req_header_id, l_next_approver_id, l_approval_group_id);
1008:
1009: l_progress := 'Insert_Action_History: 005 - Forward_Action_History';
1010: IF (g_po_wf_debug = 'Y') THEN
1011: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1012: END IF;
1013:
1014: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
1015: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

Line 1033: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1029: END IF; -- run mode
1030:
1031: l_progress := 'Insert_Action_History: 999';
1032: IF (g_po_wf_debug = 'Y') THEN
1033: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1034: END IF;
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1092: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1088: BEGIN
1089:
1090: l_progress := 'Update_Action_History_Approve: 001';
1091: IF (g_po_wf_debug = 'Y') THEN
1092: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1093: END IF;
1094:
1095: IF (funcmode='RUN') THEN
1096:

Line 1129: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1125:
1126: l_progress := 'Update_Action_History_Approve: 002-'|| to_char(l_document_id)||'-'||
1127: l_document_type||'-'||l_document_subtype;
1128: IF (g_po_wf_debug = 'Y') THEN
1129: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1130: END IF;
1131:
1132: UpdateActionHistory(l_document_id, l_action,
1133: l_note, l_current_approver);

Line 1150: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1146: END IF; -- run mode
1147:
1148: l_progress := 'Update_Action_History_Approve: 003';
1149: IF (g_po_wf_debug = 'Y') THEN
1150: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1151: END IF;
1152:
1153: EXCEPTION
1154: WHEN OTHERS THEN

Line 1211: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1207: BEGIN
1208:
1209: l_progress := 'Update_Action_History_Reject: 001';
1210: IF (g_po_wf_debug = 'Y') THEN
1211: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1212: END IF;
1213:
1214: IF (funcmode='RUN') THEN
1215:

Line 1248: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1244:
1245: l_progress := 'Update_Action_History_Reject: 002-'|| to_char(l_document_id)||'-'||
1246: l_document_type||'-'||l_document_subtype;
1247: IF (g_po_wf_debug = 'Y') THEN
1248: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1249: END IF;
1250:
1251: UpdateActionHistory(l_document_id, l_action,
1252: l_note, l_current_approver);

Line 1269: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1265: END IF; -- run mode
1266:
1267: l_progress := 'Update_Action_History_Reject: 003';
1268: IF (g_po_wf_debug = 'Y') THEN
1269: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1270: END IF;
1271:
1272: EXCEPTION
1273: WHEN OTHERS THEN

Line 1329: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1325: BEGIN
1326:
1327: l_progress := 'Update_Action_History_Timeout: 001';
1328: IF (g_po_wf_debug = 'Y') THEN
1329: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1330: END IF;
1331:
1332: IF (funcmode='RUN') THEN
1333:

Line 1366: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1362:
1363: l_progress := 'Update_Action_History_Timeout: 002-'|| to_char(l_document_id)||'-'||
1364: l_document_type||'-'||l_document_subtype;
1365: IF (g_po_wf_debug = 'Y') THEN
1366: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1367: END IF;
1368:
1369: UpdateActionHistory(l_document_id, l_action,
1370: l_note, l_current_approver);

Line 1380: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

1376: END IF; -- run mode
1377:
1378: l_progress := 'Update_Action_History_Timeout: 003';
1379: IF (g_po_wf_debug = 'Y') THEN
1380: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1381: END IF;
1382:
1383: EXCEPTION
1384: WHEN OTHERS THEN

Line 1450: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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:
1453: -- If the setup is first responder wins, then once the first approver responds, the others will not be able to take decisions.
1454:

Line 1467: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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:
1470: EXCEPTION
1471: WHEN OTHERS THEN

Line 1533: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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:
1536: -- If the setup is first responder wins, then once the first approver responds, the others will not be able to take decisions.
1537:

Line 1550: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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:
1553: EXCEPTION
1554: WHEN OTHERS THEN