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 452: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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