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 PO_WF_DEBUG_PKG

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

73: IF (funcmode = 'RUN') THEN
74:
75: l_progress := 'Get_Next_Approver: 001';
76: IF (g_po_wf_debug = 'Y') THEN
77: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
78: END IF;
79:
80: /* Check if there is any AME exception.
81: If yes, then return 'invalid approver' */

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

105:
106: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'|| l_document_type||'-'||l_document_subtype;
107:
108: IF (g_po_wf_debug = 'Y') THEN
109: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
110: END IF;
111:
112: -- Get the next approver from AME.
113: LOOP

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

130: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
131: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
132:
133: IF (g_po_wf_debug = 'Y') THEN
134: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
135: END IF;
136:
137: 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);
138:

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

141: END;
142:
143: l_progress := 'Get_Next_Approver: 003- getNextApprovers4(). Approvers :' || g_next_approvers.count || ' -- Approval Process Completed :' || l_completeYNO ;
144: IF (g_po_wf_debug = 'Y') THEN
145: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
146: END IF;
147:
148: if ( g_next_approvers.count > 0 ) then
149:

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

150: l_position_has_valid_approvers := position_has_valid_approvers(l_document_id, l_transaction_type) ;
151:
152: l_progress := 'Get_Next_Approver: 004 - l_position_has_valid_approvers :' || l_position_has_valid_approvers;
153: IF (g_po_wf_debug = 'Y') THEN
154: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
155: END IF;
156:
157: l_progress := 'Get_Next_Approver: 005- Approvers after the validation process :' || g_next_approvers.count;
158: IF (g_po_wf_debug = 'Y') THEN

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

155: END IF;
156:
157: l_progress := 'Get_Next_Approver: 005- Approvers after the validation process :' || g_next_approvers.count;
158: IF (g_po_wf_debug = 'Y') THEN
159: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
160: END IF;
161:
162: if( g_next_approvers.count = 0 AND 'NO_USERS' = l_position_has_valid_approvers ) then
163: l_need_to_get_next_approver := TRUE;

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

198: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
199: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);
200:
201: IF (g_po_wf_debug = 'Y') THEN
202: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
203: END IF;
204:
205: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');
206: resultout:='COMPLETE:'||'INVALID_APPROVER';

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

274: IF (funcmode='RUN') THEN
275:
276: l_progress := 'Launch_Parallel_Approval: 001';
277: IF (g_po_wf_debug = 'Y') THEN
278: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
279: END IF;
280:
281: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
282: itemkey => itemkey,

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

293: while ( l_approver_index is not null ) loop
294:
295: l_progress := 'Launch_Parallel_Approval: 002 -- Next Approver :' || g_next_approvers(l_approver_index).name;
296: IF (g_po_wf_debug = 'Y') THEN
297: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
298: END IF;
299:
300: SELECT
301: to_char(l_document_id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)

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

417: aname => 'AME_TRANSACTION_TYPE');
418:
419: l_progress := 'Launch_Parallel_Approval: 003 -- Record Type :' || g_next_approvers(l_approver_index).orig_system;
420: IF (g_po_wf_debug = 'Y') THEN
421: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
422: END IF;
423:
424: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
425: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then

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

482: WF_DIRECTORY.GetUserName(ame_util.perOrigSystem, l_next_approver_id, l_next_approver_user_name, l_next_approver_disp_name);
483:
484: l_progress := 'Launch_Parallel_Approval: 004 -- Next Approver User Name -- display Name:' || l_next_approver_user_name || ' -- ' || l_next_approver_disp_name;
485: IF (g_po_wf_debug = 'Y') THEN
486: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
487: END IF;
488: --bug6843383 start
489: IF (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then
490: t_varname(23) := 'APPROVER_USER_NAME';

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

503: END IF;
504: /* Kick off the process */
505: l_progress:= '30: start_wf_line_process: Kicking off StartProcess';
506: IF (g_po_wf_debug = 'Y') THEN
507: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);
508: END IF;
509:
510: t_varname(25) := 'AME_IS_FYI_APPROVER';
511: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then

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

579:
580:
581: l_progress := 'Launch_Parallel_Approval: 005 -- Launch Parallel Approval';
582: IF (g_po_wf_debug = 'Y') THEN
583: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
584: END IF;
585:
586:
587: wf_engine.StartProcess( itemtype => itemtype,

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

608: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
609: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);
610:
611: IF (g_po_wf_debug = 'Y') THEN
612: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
613: END IF;
614: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
615: raise;
616: when others then

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

619: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
620: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);
621:
622: IF (g_po_wf_debug = 'Y') THEN
623: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
624: END IF;
625:
626: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
627: raise;

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

666: begin
667:
668: l_progress := 'Process_Response_Internal: 001';
669: IF (g_po_wf_debug = 'Y') THEN
670: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
671: END IF;
672:
673: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
674: itemkey => itemkey,

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

683: aname => 'AME_APPROVER_TYPE');
684:
685: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;
686: IF (g_po_wf_debug = 'Y') THEN
687: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
688: END IF;
689:
690: if (l_approver_type = ame_util.posOrigSystem) then
691: l_current_approver.orig_system := ame_util.posOrigSystem;

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

703: aname => 'AME_APPROVER_ID');
704:
705: l_progress := 'Process_Response_Internal: 003 -- l_current_approver.orig_system_id :' || l_current_approver.orig_system_id ;
706: IF (g_po_wf_debug = 'Y') THEN
707: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
708: END IF;
709:
710: if( p_response = 'APPROVE') then
711: l_current_approver.approval_status := ame_util.approvedStatus;

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

716: end if;
717:
718: l_progress := 'Process_Response_Internal: 004 -- p_response :' || p_response ;
719: IF (g_po_wf_debug = 'Y') THEN
720: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
721: END IF;
722:
723: -- Get the name value for the approverRecord2.
724: -- This is a mandatory field. If we do not pass this value to AME, we will get invalid parameter exception.

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

833: begin
834:
835: l_progress := 'Process_Beat_By_First: 001';
836: IF (g_po_wf_debug = 'Y') THEN
837: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
838: END IF;
839:
840: SELECT parent_item_type, parent_item_key
841: into l_parent_item_type, l_parent_item_key

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

859: END IF;
860:
861: l_progress := 'Process_Beat_By_First: 002';
862: IF (g_po_wf_debug = 'Y') THEN
863: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
864: END IF;
865:
866: l_approver_group_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
867: itemkey => itemkey,

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

881: where l_req_header_id = requisition_header_id;
882:
883: l_progress := 'Process_Beat_By_First: 003';
884: IF (g_po_wf_debug = 'Y') THEN
885: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
886: END IF;
887:
888: if l_approver_response = 'APPROVED' then
889: por_ame_approval_list.getAmeTransactionType(pReqHeaderId => l_req_header_id,

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

890: pAmeTransactionType => ameTransactionType);
891:
892: l_progress := 'Process_Beat_By_First: 004';
893: IF (g_po_wf_debug = 'Y') THEN
894: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
895: END IF;
896:
897: -- Note for Approve
898: l_note := fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_APPROVED');

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

905: );
906:
907: l_progress := 'Process_Beat_By_First: 005';
908: IF (g_po_wf_debug = 'Y') THEN
909: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
910: END IF;
911:
912: -- Once we get the approvers list from AME, we iterate through the approvers list,
913: -- to find out the current first authority approver.

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

913: -- to find out the current first authority approver.
914: for i in 1 .. approverList.count loop
915:
916: IF (g_po_wf_debug = 'Y') THEN
917: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
918:
919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
920: approverList(i).orig_system_id);
921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);

Line 919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||

915:
916: IF (g_po_wf_debug = 'Y') THEN
917: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
918:
919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
920: approverList(i).orig_system_id);
921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
923: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);

Line 921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);

917: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
918:
919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
920: approverList(i).orig_system_id);
921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
923: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
924: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
925:

Line 922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);

918:
919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
920: approverList(i).orig_system_id);
921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
923: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
924: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
925:
926: END IF;

Line 923: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);

919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
920: approverList(i).orig_system_id);
921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
923: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
924: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
925:
926: END IF;
927:

Line 924: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);

920: approverList(i).orig_system_id);
921: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
923: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
924: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
925:
926: END IF;
927:
928: if( approverList(i).approval_status = ame_util.beatByFirstResponderStatus

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

1022: aname => 'APPROVER_EMPID');
1023:
1024: l_progress := 'Process_Beat_By_First: 006';
1025: IF (g_po_wf_debug = 'Y') THEN
1026: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1027: END IF;
1028:
1029: -- Note for rejection
1030: l_note := fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_REJECTED');

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

1036: l_note, l_person_id);
1037:
1038: l_progress := 'Process_Beat_By_First: 007';
1039: IF (g_po_wf_debug = 'Y') THEN
1040: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1041: END IF;
1042:
1043: END LOOP;
1044:

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

1047: end if;
1048:
1049: l_progress := 'Process_Beat_By_First: 008';
1050: IF (g_po_wf_debug = 'Y') THEN
1051: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1052: END IF;
1053:
1054: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
1055: itemkey => l_parent_item_key,

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

1108: begin
1109:
1110: l_progress := 'Process_Response_Approve: 001';
1111: IF (g_po_wf_debug = 'Y') THEN
1112: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1113: END IF;
1114:
1115: SELECT parent_item_type, parent_item_key
1116: into l_parent_item_type, l_parent_item_key

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

1169: avalue => l_child_approver_display_name );
1170:
1171: l_progress := 'Process_Response_Approve: 002 -- Completing the BLOCK activity for the APPROVED notification.';
1172: IF (g_po_wf_debug = 'Y') THEN
1173: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1174: END IF;
1175:
1176: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1177: RETURN;

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

1215: begin
1216:
1217: l_progress := 'Process_Response_Reject: 001';
1218: IF (g_po_wf_debug = 'Y') THEN
1219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1220: END IF;
1221:
1222: Process_Response_Internal(itemtype, itemkey, 'REJECT');
1223:

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

1281:
1282:
1283: l_progress := 'Process_Response_Reject: 002 -- Completing the BLOCK activity for the REJECTED notification.';
1284: IF (g_po_wf_debug = 'Y') THEN
1285: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1286: END IF;
1287:
1288: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1289: RETURN;

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

1330: begin
1331:
1332: l_progress := 'Process_Response_Timeout: 001';
1333: IF (g_po_wf_debug = 'Y') THEN
1334: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1335: END IF;
1336:
1337: Process_Response_Internal(itemtype, itemkey, 'TIMEOUT');
1338:

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

1401: result => null);
1402:
1403: l_progress := 'Process_Response_Timeout: 002 -- Completing the BLOCK activity for the REJECTED notification.';
1404: IF (g_po_wf_debug = 'Y') THEN
1405: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1406: END IF;
1407:
1408: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1409: RETURN;

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

1537: BEGIN
1538:
1539: l_progress := 'Insert_Action_History: 001';
1540: IF (g_po_wf_debug = 'Y') THEN
1541: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1542: END IF;
1543:
1544: IF (funcmode='RUN') THEN
1545:

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

1570: insertActionHistory(l_req_header_id, l_next_approver_id, l_approval_group_id);
1571:
1572: l_progress := 'Insert_Action_History: 005 - Done with insertActionHistory.';
1573: IF (g_po_wf_debug = 'Y') THEN
1574: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1575: END IF;
1576:
1577: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
1578: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

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

1592: END IF; -- run mode
1593:
1594: l_progress := 'Insert_Action_History: 999';
1595: IF (g_po_wf_debug = 'Y') THEN
1596: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1597: END IF;
1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN

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

1651: BEGIN
1652:
1653: l_progress := 'Update_Action_History_Approve: 001';
1654: IF (g_po_wf_debug = 'Y') THEN
1655: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1656: END IF;
1657:
1658: IF (funcmode='RUN') THEN
1659:

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

1688:
1689: l_progress := 'Update_Action_History_Approve: 002-'|| to_char(l_document_id)||'-'||
1690: l_document_type||'-'||l_document_subtype;
1691: IF (g_po_wf_debug = 'Y') THEN
1692: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1693: END IF;
1694:
1695: UpdateActionHistory(l_document_id, l_action,
1696: l_note, l_current_approver);

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

1705: END IF; -- run mode
1706:
1707: l_progress := 'Update_Action_History_Approve: 003';
1708: IF (g_po_wf_debug = 'Y') THEN
1709: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1710: END IF;
1711:
1712:
1713: EXCEPTION

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

1767: BEGIN
1768:
1769: l_progress := 'Update_Action_History_Reject: 001';
1770: IF (g_po_wf_debug = 'Y') THEN
1771: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1772: END IF;
1773:
1774: IF (funcmode='RUN') THEN
1775:

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

1804:
1805: l_progress := 'Update_Action_History_Reject: 002-'|| to_char(l_document_id)||'-'||
1806: l_document_type||'-'||l_document_subtype;
1807: IF (g_po_wf_debug = 'Y') THEN
1808: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1809: END IF;
1810:
1811: UpdateActionHistory(l_document_id, l_action,
1812: l_note, l_current_approver);

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

1821: END IF; -- run mode
1822:
1823: l_progress := 'Update_Action_History_Reject: 003';
1824: IF (g_po_wf_debug = 'Y') THEN
1825: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1826: END IF;
1827:
1828: EXCEPTION
1829: WHEN OTHERS THEN

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

1882: BEGIN
1883:
1884: l_progress := 'Update_Action_History_Timeout: 001';
1885: IF (g_po_wf_debug = 'Y') THEN
1886: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1887: END IF;
1888:
1889: IF (funcmode='RUN') THEN
1890:

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

1918: l_progress := 'Update_Action_History_Timeout: 002-'|| to_char(l_document_id)||'-'||
1919: l_document_type||'-'||l_document_subtype;
1920:
1921: IF (g_po_wf_debug = 'Y') THEN
1922: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1923: END IF;
1924:
1925: UpdateActionHistory(l_document_id, l_action,
1926: l_note, l_current_approver);

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

1930: END IF; -- run mode
1931:
1932: l_progress := 'Update_Action_History_Timeout: 003';
1933: IF (g_po_wf_debug = 'Y') THEN
1934: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1935: END IF;
1936:
1937: EXCEPTION
1938: WHEN OTHERS THEN

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

2018:
2019: 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 ;
2020:
2021: IF (g_po_wf_debug = 'Y') THEN
2022: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2023: END IF;
2024:
2025: -- If the setup is first responder wins, then once the first approver responds, the others will not be able to take decisions.
2026:

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

2033: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
2034:
2035: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 03';
2036: IF (g_po_wf_debug = 'Y') THEN
2037: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
2038: END IF;
2039:
2040: EXCEPTION
2041: WHEN OTHERS THEN

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

2158: when others then
2159: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2160: wf_core.context('POR_AME_REQ_WF_PVT','IS_AME_EXCEPTION: Unexpected Exception:',l_progress,sqlerrm);
2161: IF (g_po_wf_debug = 'Y') THEN
2162: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
2163: END IF;
2164: raise;
2165: End IS_AME_EXCEPTION;
2166: