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

91:
92: BEGIN
93: l_progress := 'In Get_Next_Approver';
94: IF (g_po_wf_debug = 'Y') THEN
95: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
96: END IF;
97: IF (funcmode = 'RUN') THEN
98:
99: l_progress := 'Get_Next_Approver: 001';

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

97: IF (funcmode = 'RUN') THEN
98:
99: l_progress := 'Get_Next_Approver: 001';
100: IF (g_po_wf_debug = 'Y') THEN
101: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
102: END IF;
103:
104: /* Check if there is any AME exception.
105: If yes, then return 'invalid approver' */

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

140:
141: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'|| l_document_type||'-'||l_document_subtype;
142:
143: IF (g_po_wf_debug = 'Y') THEN
144: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
145: END IF;
146:
147: -- Get the next approver from AME.
148: LOOP

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

158: 'Transaction Type: '||
159: l_transaction_type;
160:
161: IF (g_po_wf_debug = 'Y') THEN
162: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
163: END IF;
164:
165:
166: ame_util2.detailedApprovalStatusFlagYN := ame_util.booleanTrue;

Line 182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);

178: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
180:
181: IF (g_po_wf_debug = 'Y') THEN
182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
184: END IF;
185:
186: 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);

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

179: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers: Unable to get the next approvers from AME.',l_progress,sqlerrm);
180:
181: IF (g_po_wf_debug = 'Y') THEN
182: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,'POR_AME_REQ_WF_PVT Get_Next_Approvers: Unable to get the next approvers from AME.'||l_progress||sqlerrm);
183: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
184: END IF;
185:
186: 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);
187:

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

190: END;
191:
192: l_progress := 'Get_Next_Approver: 003- getNextApprovers4(). Approvers :' || g_next_approvers.count || ' -- Approval Process Completed :' || l_completeYNO ;
193: IF (g_po_wf_debug = 'Y') THEN
194: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
195: END IF;
196:
197: if ( g_next_approvers.count > 0 ) then
198:

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

199: l_position_has_valid_approvers := position_has_valid_approvers(l_document_id, l_transaction_type) ;
200:
201: l_progress := 'Get_Next_Approver: 004 - l_position_has_valid_approvers :' || l_position_has_valid_approvers;
202: IF (g_po_wf_debug = 'Y') THEN
203: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
204: END IF;
205:
206: l_progress := 'Get_Next_Approver: 005- Approvers after the validation process :' || g_next_approvers.count;
207: IF (g_po_wf_debug = 'Y') THEN

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

204: END IF;
205:
206: l_progress := 'Get_Next_Approver: 005- Approvers after the validation process :' || g_next_approvers.count;
207: IF (g_po_wf_debug = 'Y') THEN
208: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
209: END IF;
210:
211: if( g_next_approvers.count = 0 AND 'NO_USERS' = l_position_has_valid_approvers ) then
212: l_need_to_get_next_approver := TRUE;

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

247: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
248: wf_core.context('POR_AME_REQ_WF_PVT','Get_Next_Approvers - Unexpected Exception: ',l_progress,sqlerrm);
249:
250: IF (g_po_wf_debug = 'Y') THEN
251: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string);
252: END IF;
253:
254: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVERS');
255: resultout:='COMPLETE:'||'INVALID_APPROVER';

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

328: IF (funcmode='RUN') THEN
329:
330: l_progress := 'Launch_Parallel_Approval: 001';
331: IF (g_po_wf_debug = 'Y') THEN
332: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
333: END IF;
334:
335: /*Bug 11727653: BYPASSING MULTIPLE SUBMISSION CHECKS IN WORKFLOW
336: - setting the bypass flag to N if document is getting forwarded.*/

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

368: while ( l_approver_index is not null ) loop
369:
370: l_progress := 'Launch_Parallel_Approval: 002 -- Next Approver :' || g_next_approvers(l_approver_index).name;
371: IF (g_po_wf_debug = 'Y') THEN
372: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
373: END IF;
374:
375: SELECT
376: to_char(l_document_id) || '-' || to_char(PO_WF_ITEMKEY_S.nextval)

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

580:
581:
582: l_progress := 'Launch_Parallel_Approval: 003 -- Record Type :' || g_next_approvers(l_approver_index).orig_system;
583: IF (g_po_wf_debug = 'Y') THEN
584: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
585: END IF;
586:
587: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.
588: if (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then

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

654: WF_DIRECTORY.GetUserName(ame_util.perOrigSystem, l_next_approver_id, l_next_approver_user_name, l_next_approver_disp_name);
655:
656: l_progress := 'Launch_Parallel_Approval: 004 -- Next Approver User Name -- display Name:' || l_next_approver_user_name || ' -- ' || l_next_approver_disp_name;
657: IF (g_po_wf_debug = 'Y') THEN
658: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
659: END IF;
660: --bug6843383 start
661: IF (g_next_approvers(l_approver_index).orig_system = ame_util.perOrigSystem) then
662: t_req_varname(27) := 'APPROVER_USER_NAME';

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

687: END IF;
688: /* Kick off the process */
689: l_progress:= '30: start_wf_line_process: Kicking off StartProcess';
690: IF (g_po_wf_debug = 'Y') THEN
691: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);
692: END IF;
693: t_req_varname(29) := 'AME_IS_FYI_APPROVER';
694: t_po_varname(21) := 'IS_FYI_APPROVER';
695: if (g_next_approvers(l_approver_index).approver_category = ame_util.fyiApproverCategory) then

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

836: end if;
837:
838: l_progress:= 'after setting text array';
839: IF (g_po_wf_debug = 'Y') THEN
840: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);
841: END IF;
842:
843: n_varname(1) := 'DOCUMENT_ID';
844: n_varval(1) := l_document_id;

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

857:
858:
859: l_progress:= 'g_next_approvers(l_approver_index).api_insertion: '||g_next_approvers(l_approver_index).api_insertion;
860: IF (g_po_wf_debug = 'Y') THEN
861: po_wf_debug_pkg.insert_debug(itemtype,itemkey,l_progress);
862: END IF;
863: if (g_next_approvers(l_approver_index).api_insertion = 'Y') then
864: n_varval(5) := 1;
865: else

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

876: itemkey => itemkey,
877: aname => 'APPLICATION_ID');
878: l_progress := 'Launch_Parallel_Approval - setting responsibility_id:'||n_varval(6)||' and application_id:'||n_varval(7);
879: IF (g_po_wf_debug = 'Y') THEN
880: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
881: END IF;
882:
883: if l_document_type <> 'REQUISITION' then
884: n_varname(8) := 'AME_TRANSACTION_ID';

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

915:
916:
917: l_progress := 'Launch_Parallel_Approval: 005 -- Launch Parallel Approval';
918: IF (g_po_wf_debug = 'Y') THEN
919: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
920: END IF;
921:
922:
923: wf_engine.StartProcess( itemtype => itemtype,

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

944: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
945: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-NO_DATA_FOUND Exception:',l_progress,sqlerrm);
946:
947: IF (g_po_wf_debug = 'Y') THEN
948: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
949: END IF;
950: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
951: raise;
952: when others then

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

955: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
956: wf_core.context('POR_AME_REQ_WF_PVT','Launch_Parallel_Approval-Unexpected Exception:',l_progress,sqlerrm);
957:
958: IF (g_po_wf_debug = 'Y') THEN
959: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
960: END IF;
961:
962: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQ_WF_PVT.GET_NEXT_APPROVER');
963: raise;

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

1005: begin
1006:
1007: l_progress := 'Process_Response_Internal: 001';
1008: IF (g_po_wf_debug = 'Y') THEN
1009: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1010: END IF;
1011:
1012: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1013: itemkey => itemkey,

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

1037:
1038: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type||
1039: ', l_ame_transaction_id: '||l_ame_transaction_id||',l_transaction_type: '||l_transaction_type ;
1040: IF (g_po_wf_debug = 'Y') THEN
1041: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1042: END IF;
1043:
1044: if (l_approver_type = ame_util.posOrigSystem) then
1045: l_current_approver.orig_system := ame_util.posOrigSystem;

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

1068:
1069: l_progress := 'Process_Response_Internal: 003 -- l_current_approver.orig_system_id :' ||
1070: l_current_approver.orig_system_id||', l_current_approver.name: '||l_current_approver.name ;
1071: IF (g_po_wf_debug = 'Y') THEN
1072: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1073: END IF;
1074:
1075: if( p_response = 'APPROVE') then
1076: l_current_approver.approval_status := ame_util.approvedStatus;

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

1082: l_current_approver.approval_status := ame_util.forwardStatus;
1083: l_progress := 'Process_Response_Internal: 004 -- l_forwardee.orig_system_id :' ||
1084: l_forwardee.orig_system_id||', l_forwardee.name: '||l_forwardee.name ;
1085: IF (g_po_wf_debug = 'Y') THEN
1086: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1087: END IF;
1088: elsif( p_response = 'APPROVE AND FORWARD') then -- CLM Apprvl
1089: l_current_approver.approval_status := ame_util.approveAndForwardStatus;
1090: --CLM bug11736458 - exception response must be sent back to AME in case of error during PDF generation in Parallel approval process.

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

1093: end if;
1094:
1095: l_progress := 'Process_Response_Internal: 005 -- p_response :' || p_response ;
1096: IF (g_po_wf_debug = 'Y') THEN
1097: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1098: END IF;
1099:
1100: -- Get the name value for the approverRecord2.
1101: -- This is a mandatory field. If we do not pass this value to AME, we will get invalid parameter exception.

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

1243: begin
1244:
1245: l_progress := 'Process_Beat_By_First: 001';
1246: IF (g_po_wf_debug = 'Y') THEN
1247: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1248: END IF;
1249:
1250: SELECT parent_item_type, parent_item_key
1251: into l_parent_item_type, l_parent_item_key

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

1269: END IF;
1270:
1271: l_progress := 'Process_Beat_By_First: 002';
1272: IF (g_po_wf_debug = 'Y') THEN
1273: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1274: END IF;
1275:
1276: --Bug 12944203
1277: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1324:
1325:
1326: l_progress := 'Process_Beat_By_First: 003';
1327: IF (g_po_wf_debug = 'Y') THEN
1328: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1329: END IF;
1330:
1331: if l_approver_response = 'APPROVED' then
1332:

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

1335: pAmeTransactionType => ameTransactionType);
1336:
1337: l_progress := 'Process_Beat_By_First: 004, ameTransactionType: '||ameTransactionType;
1338: IF (g_po_wf_debug = 'Y') THEN
1339: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1340: END IF;
1341:
1342: -- Note for Approve
1343: l_note := fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_APPROVED');

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

1351: else
1352: l_progress := 'Process_Beat_By_First: 004, l_ame_transaction_id: '||l_ame_transaction_id||
1353: ', l_ame_transaction_type: '||l_transaction_type;
1354: IF (g_po_wf_debug = 'Y') THEN
1355: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1356: END IF;
1357:
1358: --Bug 12944203
1359:

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

1375:
1376:
1377: l_progress := 'Process_Beat_By_First: 005';
1378: IF (g_po_wf_debug = 'Y') THEN
1379: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1380: END IF;
1381:
1382: -- Once we get the approvers list from AME, we iterate through the approvers list,
1383: -- to find out the current first authority approver.

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

1383: -- to find out the current first authority approver.
1384: for i in 1 .. approverList.count loop
1385:
1386: IF (g_po_wf_debug = 'Y') THEN
1387: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1388:
1389: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
1390: approverList(i).orig_system_id);
1391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);

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

1385:
1386: IF (g_po_wf_debug = 'Y') THEN
1387: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1388:
1389: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
1390: approverList(i).orig_system_id);
1391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
1392: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
1393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);

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

1387: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1388:
1389: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
1390: approverList(i).orig_system_id);
1391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
1392: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
1393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
1394: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
1395:

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

1388:
1389: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
1390: approverList(i).orig_system_id);
1391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
1392: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
1393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
1394: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
1395:
1396: END IF;

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

1389: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, approverList(i).orig_system || to_char(i) || ' ' ||
1390: approverList(i).orig_system_id);
1391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
1392: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
1393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
1394: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
1395:
1396: END IF;
1397:

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

1390: approverList(i).orig_system_id);
1391: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'authority' || ' ' || approverList(i).authority);
1392: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'approval_status'|| ' ' || approverList(i).approval_status);
1393: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'api_insertion'|| ' ' || approverList(i).api_insertion);
1394: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'group_or_chain_id' || ' ' || approverList(i).group_or_chain_id);
1395:
1396: END IF;
1397:
1398: if( approverList(i).approval_status = ame_util.beatByFirstResponderStatus

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

1501: aname => 'APPROVER_EMPID');
1502:
1503: l_progress := 'Process_Beat_By_First: 0051';
1504: IF (g_po_wf_debug = 'Y') THEN
1505: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1506: END IF;
1507:
1508: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
1509:

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

1512: l_note, l_person_id);
1513:
1514: l_progress := 'Process_Beat_By_First: 0052';
1515: IF (g_po_wf_debug = 'Y') THEN
1516: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1517: END IF;
1518:
1519: END LOOP;
1520: CLOSE l_child_wf;

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

1532: aname => 'APPROVER_EMPID');
1533:
1534: l_progress := 'Process_Beat_By_First: 006';
1535: IF (g_po_wf_debug = 'Y') THEN
1536: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1537: END IF;
1538:
1539: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
1540:

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

1557: END IF;
1558:
1559: l_progress := 'Process_Beat_By_First: 007';
1560: IF (g_po_wf_debug = 'Y') THEN
1561: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1562: END IF;
1563:
1564: END LOOP;
1565:

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

1568: end if;
1569:
1570: l_progress := 'Process_Beat_By_First: 008';
1571: IF (g_po_wf_debug = 'Y') THEN
1572: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1573: END IF;
1574:
1575: wf_engine.CompleteActivity( itemtype => l_parent_item_type,
1576: itemkey => l_parent_item_key,

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

1629: begin
1630:
1631: l_progress := 'Process_Response_Approve: 001';
1632: IF (g_po_wf_debug = 'Y') THEN
1633: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1634: END IF;
1635:
1636: SELECT parent_item_type, parent_item_key
1637: into l_parent_item_type, l_parent_item_key

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

1690: avalue => l_child_approver_display_name );
1691:
1692: l_progress := 'Process_Response_Approve: 002 -- Completing the BLOCK activity for the APPROVED notification.';
1693: IF (g_po_wf_debug = 'Y') THEN
1694: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1695: END IF;
1696:
1697: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1698: RETURN;

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

1736: begin
1737:
1738: l_progress := 'Process_Response_Reject: 001';
1739: IF (g_po_wf_debug = 'Y') THEN
1740: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1741: END IF;
1742:
1743: Process_Response_Internal(itemtype, itemkey, 'REJECT');
1744:

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

1802:
1803:
1804: l_progress := 'Process_Response_Reject: 002 -- Completing the BLOCK activity for the REJECTED notification.';
1805: IF (g_po_wf_debug = 'Y') THEN
1806: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1807: END IF;
1808:
1809: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1810: RETURN;

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

1851: begin
1852:
1853: l_progress := 'Process_Response_Timeout: 001';
1854: IF (g_po_wf_debug = 'Y') THEN
1855: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1856: END IF;
1857:
1858: Process_Response_Internal(itemtype, itemkey, 'TIMEOUT');
1859:

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

1922: result => null);
1923:
1924: l_progress := 'Process_Response_Timeout: 002 -- Completing the BLOCK activity for the REJECTED notification.';
1925: IF (g_po_wf_debug = 'Y') THEN
1926: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1927: END IF;
1928:
1929: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
1930: RETURN;

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

1970: begin
1971:
1972: l_progress := 'Process_Response_Forward: 001';
1973: IF (g_po_wf_debug = 'Y') THEN
1974: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1975: END IF;
1976:
1977: SELECT parent_item_type, parent_item_key
1978: into l_parent_item_type, l_parent_item_key

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

2031: avalue => l_child_approver_display_name );
2032:
2033: l_progress := 'Process_Response_Forward: 002 -- Completing the BLOCK activity for the Forwarded notification.';
2034: IF (g_po_wf_debug = 'Y') THEN
2035: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
2036: END IF;
2037:
2038: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
2039: RETURN;

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

2078: begin
2079:
2080: l_progress := 'Process_Response_Approve_Forward: 001';
2081: IF (g_po_wf_debug = 'Y') THEN
2082: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
2083: END IF;
2084:
2085: SELECT parent_item_type, parent_item_key
2086: into l_parent_item_type, l_parent_item_key

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

2139: avalue => l_child_approver_display_name );
2140:
2141: l_progress := 'Process_Response_Approve_Forward: 002 -- Completing the BLOCK activity for the Forwarded notification.';
2142: IF (g_po_wf_debug = 'Y') THEN
2143: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
2144: END IF;
2145:
2146: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
2147: RETURN;

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

2279: BEGIN
2280:
2281: l_progress := 'Insert_Action_History: 001';
2282: IF (g_po_wf_debug = 'Y') THEN
2283: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2284: END IF;
2285:
2286: IF (funcmode='RUN') THEN
2287:

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

2319: itemkey => itemkey,
2320: aname => 'DOCUMENT_ID');
2321: l_progress := 'Insert_Action_History: 004 - Calling insertActionHistory.';
2322: IF (g_po_wf_debug = 'Y') THEN
2323: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2324: END IF;
2325: insertActionHistory(l_req_header_id, l_next_approver_id, l_approval_group_id);
2326:
2327: l_progress := 'Insert_Action_History: 005 - Done with insertActionHistory.';

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

2325: insertActionHistory(l_req_header_id, l_next_approver_id, l_approval_group_id);
2326:
2327: l_progress := 'Insert_Action_History: 005 - Done with insertActionHistory.';
2328: IF (g_po_wf_debug = 'Y') THEN
2329: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2330: END IF;
2331:
2332: else
2333: /* l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

2340: itemkey => itemkey,
2341: aname => 'DRAFT_ID');
2342: l_progress := 'Insert_Action_History: 006 - Calling insertActionHistory.';
2343: IF (g_po_wf_debug = 'Y') THEN
2344: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2345: END IF;
2346:
2347: insertActionHistoryPo(l_document_id, l_draft_id,
2348: l_document_type,

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

2351: l_next_approver_id, l_approval_group_id);
2352:
2353: l_progress := 'Insert_Action_History: 007 - Done with insertActionHistory.';
2354: IF (g_po_wf_debug = 'Y') THEN
2355: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2356: END IF;
2357: end if;
2358:
2359: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */

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

2374: END IF; -- run mode
2375:
2376: l_progress := 'Insert_Action_History: 999';
2377: IF (g_po_wf_debug = 'Y') THEN
2378: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2379: END IF;
2380:
2381: EXCEPTION
2382: WHEN OTHERS THEN

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

2436: BEGIN
2437:
2438: l_progress := 'Update_Action_History_Approve: 001';
2439: IF (g_po_wf_debug = 'Y') THEN
2440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2441: END IF;
2442:
2443: IF (funcmode='RUN') THEN
2444:

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

2481:
2482: l_progress := 'Update_Action_History_Approve: 002-'|| to_char(l_document_id)||'-'||
2483: l_document_type||'-'||l_document_subtype;
2484: IF (g_po_wf_debug = 'Y') THEN
2485: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2486: END IF;
2487:
2488: /* UpdateActionHistory(l_document_id, l_action,
2489: l_note, l_current_approver);bug 10100356*/

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

2502: l_progress := 'Update_Action_History_Approve: 003-'|| to_char(l_document_id)||
2503: '-'||to_char(l_draft_id)||'-'||
2504: l_document_type||'-'||l_document_subtype;
2505: IF (g_po_wf_debug = 'Y') THEN
2506: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2507: END IF;
2508:
2509: --Bug 13444730 Passing document_type and document_subtype
2510: UpdateActionHistoryPo(l_transaction_type,l_document_id, l_draft_id,

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

2523: END IF; -- run mode
2524:
2525: l_progress := 'Update_Action_History_Approve: 004';
2526: IF (g_po_wf_debug = 'Y') THEN
2527: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2528: END IF;
2529:
2530:
2531: EXCEPTION

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

2588: BEGIN
2589:
2590: l_progress := 'Update_Action_History_Reject: 001';
2591: IF (g_po_wf_debug = 'Y') THEN
2592: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2593: END IF;
2594:
2595: IF (funcmode='RUN') THEN
2596:

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

2634:
2635: l_progress := 'Update_Action_History_Reject: 002-'|| to_char(l_document_id)||'-'||
2636: l_document_type||'-'||l_document_subtype;
2637: IF (g_po_wf_debug = 'Y') THEN
2638: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2639: END IF;
2640:
2641: /*UpdateActionHistory(l_document_id, l_action,
2642: l_note, l_current_approver);bug 10100356*/

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

2653: aname => 'DRAFT_ID');
2654: l_progress := 'Update_Action_History_Reject: 003-'|| to_char(l_document_id)||'-'||to_char(l_draft_id)||'-'||
2655: l_document_type||'-'||l_document_subtype;
2656: IF (g_po_wf_debug = 'Y') THEN
2657: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2658: END IF;
2659:
2660: --Bug 13444730 Passing document_type and document_subtype
2661: UpdateActionHistoryPo(l_transaction_type,l_document_id, l_draft_id,

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

2674: END IF; -- run mode
2675:
2676: l_progress := 'Update_Action_History_Reject: 004';
2677: IF (g_po_wf_debug = 'Y') THEN
2678: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2679: END IF;
2680:
2681: EXCEPTION
2682: WHEN OTHERS THEN

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

2738: BEGIN
2739:
2740: l_progress := 'Update_Action_History_Timeout: 001';
2741: IF (g_po_wf_debug = 'Y') THEN
2742: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2743: END IF;
2744:
2745: IF (funcmode='RUN') THEN
2746:

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

2782:
2783: l_progress := 'Update_Action_History_Timeout: 002-'|| to_char(l_document_id)||'-'||
2784: l_document_type||'-'||l_document_subtype;
2785: IF (g_po_wf_debug = 'Y') THEN
2786: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2787: END IF;
2788:
2789: /*UpdateActionHistory(l_document_id, l_action,
2790: l_note, l_current_approver);bug 10100356*/

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

2802:
2803: l_progress := 'Update_Action_History_Timeout: 003-'|| to_char(l_document_id)||'-'||to_char(l_draft_id)||'-'||
2804: l_document_type||'-'||l_document_subtype;
2805: IF (g_po_wf_debug = 'Y') THEN
2806: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2807: END IF;
2808:
2809: --Bug 13444730 Passing document_type and document_subtype
2810: UpdateActionHistoryPo(l_transaction_type,l_document_id, l_draft_id,

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

2818: END IF; -- run mode
2819:
2820: l_progress := 'Update_Action_History_Timeout: 003';
2821: IF (g_po_wf_debug = 'Y') THEN
2822: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2823: END IF;
2824:
2825: EXCEPTION
2826: WHEN OTHERS THEN

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

2880: BEGIN
2881:
2882: l_progress := 'Update_Action_History_Forward: 001';
2883: IF (g_po_wf_debug = 'Y') THEN
2884: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2885: END IF;
2886:
2887: IF (funcmode='RUN') THEN
2888:

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

2925:
2926: l_progress := 'Update_Action_History_Forward: 002-'|| to_char(l_document_id)||'-'||
2927: l_document_type||'-'||l_document_subtype;
2928: IF (g_po_wf_debug = 'Y') THEN
2929: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2930: END IF;
2931:
2932: UpdateActionHistory(l_document_id, l_action,
2933: l_note, l_current_approver);

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

2940:
2941: l_progress := 'Update_Action_History_Forward: 003-'|| to_char(l_document_id)||'-'||to_char(l_draft_id)||'-'||
2942: l_document_type||'-'||l_document_subtype;
2943: IF (g_po_wf_debug = 'Y') THEN
2944: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2945: END IF;
2946:
2947: --Bug 13444730 Passing document_type and document_subtype
2948: UpdateActionHistoryPo(l_transaction_type,l_document_id, l_draft_id,

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

2961: END IF; -- run mode
2962:
2963: l_progress := 'Update_Action_History_Forward: 004';
2964: IF (g_po_wf_debug = 'Y') THEN
2965: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2966: END IF;
2967:
2968:
2969: EXCEPTION

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

3051:
3052: 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 ;
3053:
3054: IF (g_po_wf_debug = 'Y') THEN
3055: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3056: END IF;
3057:
3058: -- If the setup is first responder wins, then once the first approver responds, the others will not be able to take decisions.
3059:

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

3066: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3067:
3068: x_progress := 'POR_AME_REQ_WF_PVT.Update_Action_History_No_Act: 03';
3069: IF (g_po_wf_debug = 'Y') THEN
3070: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
3071: END IF;
3072:
3073: EXCEPTION
3074: WHEN OTHERS THEN

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

3191: when others then
3192: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3193: wf_core.context('POR_AME_REQ_WF_PVT','IS_AME_EXCEPTION: Unexpected Exception:',l_progress,sqlerrm);
3194: IF (g_po_wf_debug = 'Y') THEN
3195: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_doc_string );
3196: END IF;
3197: raise;
3198: End IS_AME_EXCEPTION;
3199:

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

3728: begin
3729:
3730: l_progress := 'Process_Response_Exception: 001';
3731: IF (g_po_wf_debug = 'Y') THEN
3732: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
3733: END IF;
3734:
3735: SELECT parent_item_type, parent_item_key
3736: into l_parent_item_type, l_parent_item_key

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

3746:
3747:
3748: l_progress := 'Process_Response_Exception: 002 -- Completing the BLOCK activity for the exception.';
3749: IF (g_po_wf_debug = 'Y') THEN
3750: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
3751: END IF;
3752:
3753: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
3754: RETURN;