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.POS_SUPP_APPR dependencies on FND_LOG

Line 108: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

104: avalue => 'NORESPONSE');
105:
106: l_progress := 'SET_STATUS_REJECTED 002 Setting WF attributes AME_PROCESS_STATUS and APPROVER_RESPONSE';
107: if g_fnd_debug = 'Y' then
108: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
109: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
110: END IF;
111: end if;
112:

Line 109: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

105:
106: l_progress := 'SET_STATUS_REJECTED 002 Setting WF attributes AME_PROCESS_STATUS and APPROVER_RESPONSE';
107: if g_fnd_debug = 'Y' then
108: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
109: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
110: END IF;
111: end if;
112:
113: -- no result needed

Line 144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

140: -- in the case of an exception.
141: wf_core.context('POS_SUPP_APPR', 'INITIALIZE_WF',
142: itemtype, itemkey, to_char(actid), funcmode);
143: if g_fnd_debug = 'Y' then
144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
146: l_progress ||' sqlerrm - '||sqlerrm);
147: END IF;
148: end if;

Line 145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

141: wf_core.context('POS_SUPP_APPR', 'INITIALIZE_WF',
142: itemtype, itemkey, to_char(actid), funcmode);
143: if g_fnd_debug = 'Y' then
144: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
145: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
146: l_progress ||' sqlerrm - '||sqlerrm);
147: END IF;
148: end if;
149: raise;

Line 197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

193: avalue => 'REJECTED');
194:
195: l_progress := 'SET_STATUS_REJECTED 002 WF attribute AME_PROCESS_STATUS set to REJECETED';
196: if g_fnd_debug = 'Y' then
197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
198: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
199: END IF;
200: end if;
201:

Line 198: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

194:
195: l_progress := 'SET_STATUS_REJECTED 002 WF attribute AME_PROCESS_STATUS set to REJECETED';
196: if g_fnd_debug = 'Y' then
197: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
198: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
199: END IF;
200: end if;
201:
202: end if;

Line 219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

215: -- in the case of an exception.
216: wf_core.context('POS_SUPP_APPR', 'SET_STATUS_REJECTED',
217: itemtype, itemkey, to_char(actid), funcmode);
218: if g_fnd_debug = 'Y' then
219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
220: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
221: l_progress ||' sqlerrm - '||sqlerrm);
222: END IF;
223: end if;

Line 220: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

216: wf_core.context('POS_SUPP_APPR', 'SET_STATUS_REJECTED',
217: itemtype, itemkey, to_char(actid), funcmode);
218: if g_fnd_debug = 'Y' then
219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
220: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
221: l_progress ||' sqlerrm - '||sqlerrm);
222: END IF;
223: end if;
224: raise;

Line 269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

265: result => l_profile_value );
266:
267: l_progress := 'IS_AME_ENABLED 002 CHECK_IF_AME_ENABLED returned - '||l_profile_value;
268: if g_fnd_debug = 'Y' then
269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
270: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
271: END IF;
272: end if;
273:

Line 270: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

266:
267: l_progress := 'IS_AME_ENABLED 002 CHECK_IF_AME_ENABLED returned - '||l_profile_value;
268: if g_fnd_debug = 'Y' then
269: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
270: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
271: END IF;
272: end if;
273:
274: resultout := wf_engine.eng_completed||':'||l_profile_value;

Line 292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

288: end if;
289:
290: l_progress := 'IS_AME_ENABLED 003 - WF attributes set';
291: if g_fnd_debug = 'Y' then
292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
293: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
294: END IF;
295: end if;
296:

Line 293: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

289:
290: l_progress := 'IS_AME_ENABLED 003 - WF attributes set';
291: if g_fnd_debug = 'Y' then
292: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
293: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
294: END IF;
295: end if;
296:
297: return;

Line 309: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

305: when others then
306: wf_core.context('POSSPAPP', 'POSSPAPP_PROCESS',
307: itemtype, itemkey, to_char(actid), funcmode);
308: if g_fnd_debug = 'Y' then
309: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
311: l_progress ||' sqlerrm - '||sqlerrm);
312: END IF;
313: end if;

Line 310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

306: wf_core.context('POSSPAPP', 'POSSPAPP_PROCESS',
307: itemtype, itemkey, to_char(actid), funcmode);
308: if g_fnd_debug = 'Y' then
309: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
311: l_progress ||' sqlerrm - '||sqlerrm);
312: END IF;
313: end if;
314: raise;

Line 405: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

401:
402: l_progress := 'GET_NEXT_APPROVER: 002 for AME transactionId - '||itemkey||
403: ' getNextApprovers4 returns completeYNO - '|| l_completeYNO;
404: if g_fnd_debug = 'Y' then
405: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
406: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
407: END IF;
408: end if;
409:

Line 406: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

402: l_progress := 'GET_NEXT_APPROVER: 002 for AME transactionId - '||itemkey||
403: ' getNextApprovers4 returns completeYNO - '|| l_completeYNO;
404: if g_fnd_debug = 'Y' then
405: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
406: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
407: END IF;
408: end if;
409:
410: if (l_completeYNO = 'Y') then

Line 422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

418:
419: l_progress := 'GET_NEXT_APPROVER: 003 for AME transactionId - '||itemkey||
420: ' setting AME_PROCESS_STATUS to APPROVED';
421: if g_fnd_debug = 'Y' then
422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
423: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
424: END IF;
425: end if;
426:

Line 423: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

419: l_progress := 'GET_NEXT_APPROVER: 003 for AME transactionId - '||itemkey||
420: ' setting AME_PROCESS_STATUS to APPROVED';
421: if g_fnd_debug = 'Y' then
422: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
423: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
424: END IF;
425: end if;
426:
427: return;

Line 440: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

436:
437: l_progress := 'GET_NEXT_APPROVER: 004 for next approver orig_System is '||
438: g_next_approvers(l_approver_index).orig_system;
439: if g_fnd_debug = 'Y' then
440: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
441: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
442: END IF;
443: end if;
444:

Line 441: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

437: l_progress := 'GET_NEXT_APPROVER: 004 for next approver orig_System is '||
438: g_next_approvers(l_approver_index).orig_system;
439: if g_fnd_debug = 'Y' then
440: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
441: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
442: END IF;
443: end if;
444:
445: -- Check whether Position Hierarchy or Employee-Sup Hierarchy setup or FND users.

Line 483: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

479: end if;
480:
481: l_progress := 'GET_NEXT_APPROVER: 005 for next approver approver_id is '||l_next_approver_id;
482: if g_fnd_debug = 'Y' then
483: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
484: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
485: END IF;
486: end if;
487:

Line 484: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

480:
481: l_progress := 'GET_NEXT_APPROVER: 005 for next approver approver_id is '||l_next_approver_id;
482: if g_fnd_debug = 'Y' then
483: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
484: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
485: END IF;
486: end if;
487:
488:

Line 493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

489: WF_DIRECTORY.GetUserName('PER', l_next_approver_id, l_next_approver_user_name, l_next_approver_disp_name);
490:
491: l_progress := 'GET_NEXT_APPROVER: 006 for next approver l_next_approver_user_name is '||l_next_approver_user_name;
492: if g_fnd_debug = 'Y' then
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
494: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
495: END IF;
496: end if;
497:

Line 494: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

490:
491: l_progress := 'GET_NEXT_APPROVER: 006 for next approver l_next_approver_user_name is '||l_next_approver_user_name;
492: if g_fnd_debug = 'Y' then
493: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
494: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
495: END IF;
496: end if;
497:
498:

Line 533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

529:
530:
531: l_progress := 'GET_NEXT_APPROVER: 007 set WF attributes for AME next approver';
532: if g_fnd_debug = 'Y' then
533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
534: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
535: END IF;
536: end if;
537:

Line 534: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

530:
531: l_progress := 'GET_NEXT_APPROVER: 007 set WF attributes for AME next approver';
532: if g_fnd_debug = 'Y' then
533: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
534: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
535: END IF;
536: end if;
537:
538: end if;

Line 572: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

568: -- in the case of an exception.
569: wf_core.context('POS_SUPP_APPR', 'GET_NEXT_APPROVER',
570: itemtype, itemkey, to_char(actid), funcmode);
571: if g_fnd_debug = 'Y' then
572: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
573: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
574: l_progress ||' sqlerrm - '||sqlerrm);
575: END IF;
576: end if;

Line 573: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

569: wf_core.context('POS_SUPP_APPR', 'GET_NEXT_APPROVER',
570: itemtype, itemkey, to_char(actid), funcmode);
571: if g_fnd_debug = 'Y' then
572: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
573: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
574: l_progress ||' sqlerrm - '||sqlerrm);
575: END IF;
576: end if;
577: raise;

Line 635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

631:
632: l_progress := 'GET_APPROVER_IN_WF: 002 WF attribute APPROVER_USER_NAME - '||wf_approver ||
633: ' username - '||wf_approver||'WF attribute APPROVER_RESPONSE - '||wf_approver_response;
634: if g_fnd_debug = 'Y' then
635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
636: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
637: END IF;
638: end if;
639:

Line 636: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

632: l_progress := 'GET_APPROVER_IN_WF: 002 WF attribute APPROVER_USER_NAME - '||wf_approver ||
633: ' username - '||wf_approver||'WF attribute APPROVER_RESPONSE - '||wf_approver_response;
634: if g_fnd_debug = 'Y' then
635: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
636: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
637: END IF;
638: end if;
639:
640: if wf_approver_response = 'NORESPONSE'

Line 659: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

655: end if;
656:
657: l_progress := 'GET_APPROVER_IN_WF: 003 values retreived for user_id, description, user_name are - '||user_id||', '||user_name||', '||user_firstname||','||user_lastname;
658: if g_fnd_debug = 'Y' then
659: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
660: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
661: END IF;
662: end if;
663:

Line 660: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

656:
657: l_progress := 'GET_APPROVER_IN_WF: 003 values retreived for user_id, description, user_name are - '||user_id||', '||user_name||', '||user_firstname||','||user_lastname;
658: if g_fnd_debug = 'Y' then
659: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
660: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
661: END IF;
662: end if;
663:
664: exception

Line 667: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

663:
664: exception
665: when others then
666: if g_fnd_debug = 'Y' then
667: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
669: l_progress ||' sqlerrm - '||sqlerrm);
670: END IF;
671: end if;

Line 668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

664: exception
665: when others then
666: if g_fnd_debug = 'Y' then
667: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
668: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
669: l_progress ||' sqlerrm - '||sqlerrm);
670: END IF;
671: end if;
672: status := 'E';

Line 708: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

704: CHECK_IF_AME_ENABLED(result => isAmeEnabled);
705:
706: l_progress := 'CHECK_IF_APPROVER: 002 CHECK_IF_AME_ENABLED returns '||isAmeEnabled;
707: if g_fnd_debug = 'Y' then
708: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
709: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
710: END IF;
711: end if;
712:

Line 709: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

705:
706: l_progress := 'CHECK_IF_APPROVER: 002 CHECK_IF_AME_ENABLED returns '||isAmeEnabled;
707: if g_fnd_debug = 'Y' then
708: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
709: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
710: END IF;
711: end if;
712:
713: if (isAmeEnabled = wf_no) then

Line 741: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

737:
738: l_progress := 'CHECK_IF_APPROVER: 003 WF attribute APPROVER_USER_NAME - '||wf_approver ||
739: ' username - '||wf_approver||'WF attribute APPROVER_RESPONSE - '||wf_approver_response;
740: if g_fnd_debug = 'Y' then
741: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
742: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
743: END IF;
744: end if;
745:

Line 742: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

738: l_progress := 'CHECK_IF_APPROVER: 003 WF attribute APPROVER_USER_NAME - '||wf_approver ||
739: ' username - '||wf_approver||'WF attribute APPROVER_RESPONSE - '||wf_approver_response;
740: if g_fnd_debug = 'Y' then
741: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
742: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
743: END IF;
744: end if;
745:
746: if wf_approver = approver AND wf_approver_response = 'NORESPONSE'

Line 758: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

754:
755: exception
756: when others then
757: if g_fnd_debug = 'Y' then
758: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
759: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
760: l_progress ||' sqlerrm - '||sqlerrm);
761: END IF;
762: end if;

Line 759: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

755: exception
756: when others then
757: if g_fnd_debug = 'Y' then
758: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
759: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
760: l_progress ||' sqlerrm - '||sqlerrm);
761: END IF;
762: end if;
763: result := wf_no;

Line 797: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

793:
794: l_progress := 'GET_AME_PROCESS_STATUS: 002 suppid - '||suppid||' WF attribute AME_PROCESS_STATUS'||result;
795:
796: if g_fnd_debug = 'Y' then
797: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
798: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
799: END IF;
800: end if;
801:

Line 798: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

794: l_progress := 'GET_AME_PROCESS_STATUS: 002 suppid - '||suppid||' WF attribute AME_PROCESS_STATUS'||result;
795:
796: if g_fnd_debug = 'Y' then
797: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
798: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
799: END IF;
800: end if;
801:
802: exception

Line 805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

801:
802: exception
803: when others then
804: if g_fnd_debug = 'Y' then
805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
806: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
807: l_progress ||' sqlerrm - '||sqlerrm);
808: END IF;
809: end if;

Line 806: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

802: exception
803: when others then
804: if g_fnd_debug = 'Y' then
805: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
806: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
807: l_progress ||' sqlerrm - '||sqlerrm);
808: END IF;
809: end if;
810: raise;

Line 849: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

845:
846: l_progress := 'PROCESS_APPROVE: 002 username - '||approver||' approver in WF - '||wf_approver;
847:
848: if g_fnd_debug = 'Y' then
849: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
850: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
851: END IF;
852: end if;
853:

Line 850: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

846: l_progress := 'PROCESS_APPROVE: 002 username - '||approver||' approver in WF - '||wf_approver;
847:
848: if g_fnd_debug = 'Y' then
849: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
850: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
851: END IF;
852: end if;
853:
854: if wf_approver = approver

Line 864: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

860:
861: l_progress := 'PROCESS_APPROVE: 003 WF attribute APPROVER_RESPONSE set to APPROVE for itemkey - '||suppid;
862:
863: if g_fnd_debug = 'Y' then
864: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
865: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
866: END IF;
867: end if;
868:

Line 865: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

861: l_progress := 'PROCESS_APPROVE: 003 WF attribute APPROVER_RESPONSE set to APPROVE for itemkey - '||suppid;
862:
863: if g_fnd_debug = 'Y' then
864: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
865: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
866: END IF;
867: end if;
868:
869: Process_Response_Internal( suppid,'APPROVE');

Line 874: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

870:
871: l_progress := 'PROCESS_APPROVE: 004 Invoked Process_Response_Internal with attributes - '||suppid||' and APPROVE';
872:
873: if g_fnd_debug = 'Y' then
874: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
875: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
876: END IF;
877: end if;
878:

Line 875: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

871: l_progress := 'PROCESS_APPROVE: 004 Invoked Process_Response_Internal with attributes - '||suppid||' and APPROVE';
872:
873: if g_fnd_debug = 'Y' then
874: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
875: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
876: END IF;
877: end if;
878:
879: wf_engine.CompleteActivity( itemtype => wfItemType,

Line 890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

886: -- commit;
887: result := 'SUCCESS';
888:
889: if g_fnd_debug = 'Y' then
890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
891: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
892: END IF;
893: end if;
894:

Line 891: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

887: result := 'SUCCESS';
888:
889: if g_fnd_debug = 'Y' then
890: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
891: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
892: END IF;
893: end if;
894:
895: else

Line 898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

894:
895: else
896:
897: if g_fnd_debug = 'Y' then
898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
899: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
900: ' This should never happenwf_approver != approver l_progress - '||l_progress );
901: END IF;
902: end if;

Line 899: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,

895: else
896:
897: if g_fnd_debug = 'Y' then
898: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
899: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
900: ' This should never happenwf_approver != approver l_progress - '||l_progress );
901: END IF;
902: end if;
903:

Line 912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

908: result =>processresult);
909:
910: l_progress := 'PROCESS_APPROVE: 006 GET_AME_PROCESS_STATUS returns - '||processresult;
911: if g_fnd_debug = 'Y' then
912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
913: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
914: END IF;
915: end if;
916:

Line 913: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

909:
910: l_progress := 'PROCESS_APPROVE: 006 GET_AME_PROCESS_STATUS returns - '||processresult;
911: if g_fnd_debug = 'Y' then
912: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
913: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
914: END IF;
915: end if;
916:
917:

Line 921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

917:
918: exception
919: when others then
920: if g_fnd_debug = 'Y' then
921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
922: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
923: l_progress ||' sqlerrm - '||sqlerrm);
924: END IF;
925: end if;

Line 922: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

918: exception
919: when others then
920: if g_fnd_debug = 'Y' then
921: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
922: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
923: l_progress ||' sqlerrm - '||sqlerrm);
924: END IF;
925: end if;
926: raise;

Line 968: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

964:
965: l_progress := 'PROCESS_REJECT: 002 username - '||approver||' approver in WF - '||wf_approver;
966:
967: if g_fnd_debug = 'Y' then
968: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
969: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
970: END IF;
971: end if;
972:

Line 969: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

965: l_progress := 'PROCESS_REJECT: 002 username - '||approver||' approver in WF - '||wf_approver;
966:
967: if g_fnd_debug = 'Y' then
968: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
969: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
970: END IF;
971: end if;
972:
973: if wf_approver = approver

Line 984: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

980:
981: l_progress := 'PROCESS_REJECT: 003 WF attribute APPROVER_RESPONSE set to REJECT for itemkey - '||suppid;
982:
983: if g_fnd_debug = 'Y' then
984: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
985: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
986: END IF;
987: end if;
988:

Line 985: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

981: l_progress := 'PROCESS_REJECT: 003 WF attribute APPROVER_RESPONSE set to REJECT for itemkey - '||suppid;
982:
983: if g_fnd_debug = 'Y' then
984: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
985: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
986: END IF;
987: end if;
988:
989:

Line 995: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

991:
992: l_progress := 'PROCESS_REJECT: 004 Invoked Process_Response_Internal with attributes - '||suppid||' and REJECT';
993:
994: if g_fnd_debug = 'Y' then
995: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
996: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
997: END IF;
998: end if;
999:

Line 996: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

992: l_progress := 'PROCESS_REJECT: 004 Invoked Process_Response_Internal with attributes - '||suppid||' and REJECT';
993:
994: if g_fnd_debug = 'Y' then
995: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
996: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
997: END IF;
998: end if;
999:
1000: wf_engine.CompleteActivity( itemtype => wfItemType,

Line 1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1007: -- commit;
1008: result := 'SUCCESS';
1009:
1010: if g_fnd_debug = 'Y' then
1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1012: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1013: END IF;
1014: end if;
1015:

Line 1012: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1008: result := 'SUCCESS';
1009:
1010: if g_fnd_debug = 'Y' then
1011: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1012: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1013: END IF;
1014: end if;
1015:
1016: else

Line 1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1015:
1016: else
1017:
1018: if g_fnd_debug = 'Y' then
1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1020: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
1021: ' This should never happenwf_approver != approver l_progress - '||l_progress );
1022: END IF;
1023: end if;

Line 1020: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,

1016: else
1017:
1018: if g_fnd_debug = 'Y' then
1019: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1020: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
1021: ' This should never happenwf_approver != approver l_progress - '||l_progress );
1022: END IF;
1023: end if;
1024:

Line 1034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1030: result =>processresult);
1031:
1032: l_progress := 'PROCESS_REJECT: 006 GET_AME_PROCESS_STATUS returns - '||processresult;
1033: if g_fnd_debug = 'Y' then
1034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1035: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1036: END IF;
1037: end if;
1038:

Line 1035: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1031:
1032: l_progress := 'PROCESS_REJECT: 006 GET_AME_PROCESS_STATUS returns - '||processresult;
1033: if g_fnd_debug = 'Y' then
1034: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1035: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1036: END IF;
1037: end if;
1038:
1039: exception

Line 1042: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1038:
1039: exception
1040: when others then
1041: if g_fnd_debug = 'Y' then
1042: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
1044: l_progress ||' sqlerrm - '||sqlerrm);
1045: END IF;
1046: end if;

Line 1043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||

1039: exception
1040: when others then
1041: if g_fnd_debug = 'Y' then
1042: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1043: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name, ' Unexpected Error l_progress - '||
1044: l_progress ||' sqlerrm - '||sqlerrm);
1045: END IF;
1046: end if;
1047: raise;

Line 1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1070:
1071: l_progress := 'CHECK_IF_AME_ENABLED: 002 -- result :' || result ;
1072:
1073: if g_fnd_debug = 'Y' then
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1075: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1076: END IF;
1077: end if;
1078:

Line 1075: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1071: l_progress := 'CHECK_IF_AME_ENABLED: 002 -- result :' || result ;
1072:
1073: if g_fnd_debug = 'Y' then
1074: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1075: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1076: END IF;
1077: end if;
1078:
1079: exception

Line 1082: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1078:
1079: exception
1080: when others then
1081: if g_fnd_debug = 'Y' then
1082: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1083: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
1084: ' Unexpected Error l_progress - '||l_progress );
1085: END IF;
1086: end if;

Line 1083: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,

1079: exception
1080: when others then
1081: if g_fnd_debug = 'Y' then
1082: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1083: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
1084: ' Unexpected Error l_progress - '||l_progress );
1085: END IF;
1086: end if;
1087: raise;

Line 1132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1128:
1129: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;
1130:
1131: if g_fnd_debug = 'Y' then
1132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1133: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1134: END IF;
1135: end if;
1136:

Line 1133: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1129: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;
1130:
1131: if g_fnd_debug = 'Y' then
1132: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1133: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1134: END IF;
1135: end if;
1136:
1137: -- bug 5486926

Line 1186: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1182: l_progress := 'Process_Response_Internal: 003 -- l_current_approver.orig_system_id :' ||
1183: l_current_approver.orig_system_id ;
1184:
1185: if g_fnd_debug = 'Y' then
1186: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1187: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1188: END IF;
1189: end if;
1190:

Line 1187: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1183: l_current_approver.orig_system_id ;
1184:
1185: if g_fnd_debug = 'Y' then
1186: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1187: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1188: END IF;
1189: end if;
1190:
1191: if( p_response = 'APPROVE') then

Line 1202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1198:
1199: l_progress := 'Process_Response_Internal: 004 -- p_response :' || p_response ;
1200:
1201: if g_fnd_debug = 'Y' then
1202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1203: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1204: END IF;
1205: end if;
1206:

Line 1203: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1199: l_progress := 'Process_Response_Internal: 004 -- p_response :' || p_response ;
1200:
1201: if g_fnd_debug = 'Y' then
1202: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1203: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1204: END IF;
1205: end if;
1206:
1207:

Line 1218: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1214: l_progress := 'Process_Response_Internal: 005 -- Updated AME for transactiontype -'||ameTransactionType||
1215: ' and transactionId - '||suppid;
1216:
1217: if g_fnd_debug = 'Y' then
1218: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1219: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1220: END IF;
1221: end if;
1222:

Line 1219: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );

1215: ' and transactionId - '||suppid;
1216:
1217: if g_fnd_debug = 'Y' then
1218: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1219: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, l_progress );
1220: END IF;
1221: end if;
1222:
1223: exception

Line 1226: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1222:
1223: exception
1224: when others then
1225: if g_fnd_debug = 'Y' then
1226: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
1228: ' Unexpected Error l_progress - '||l_progress );
1229: END IF;
1230: end if;

Line 1227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,

1223: exception
1224: when others then
1225: if g_fnd_debug = 'Y' then
1226: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1227: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED, g_module_prefix || l_api_name,
1228: ' Unexpected Error l_progress - '||l_progress );
1229: END IF;
1230: end if;
1231: raise;

Line 1296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1292:
1293: l_progress := 4;
1294:
1295: if g_fnd_debug = 'Y' then
1296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1297: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name,
1298: 'Started workflow itemtype - '|| wfItemType ||' itemkey - '||suppid);
1299: END IF;
1300: end if;

Line 1297: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name,

1293: l_progress := 4;
1294:
1295: if g_fnd_debug = 'Y' then
1296: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1297: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name,
1298: 'Started workflow itemtype - '|| wfItemType ||' itemkey - '||suppid);
1299: END IF;
1300: end if;
1301:

Line 1314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1310:
1311: result := 'FAILURE';
1312:
1313: IF (g_fnd_debug = 'Y') THEN
1314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1315: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,g_module_prefix ||l_api_name,
1316: 'Error in starting workflow l_progress - ' || l_progress ||' sqlerrm - '||sqlerrm);
1317: END IF;
1318: END IF;

Line 1315: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,g_module_prefix ||l_api_name,

1311: result := 'FAILURE';
1312:
1313: IF (g_fnd_debug = 'Y') THEN
1314: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1315: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,g_module_prefix ||l_api_name,
1316: 'Error in starting workflow l_progress - ' || l_progress ||' sqlerrm - '||sqlerrm);
1317: END IF;
1318: END IF;
1319:

Line 1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1361:
1362: BEGIN
1363:
1364: if g_fnd_debug = 'Y' then
1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1366: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Entering get_ame_approval_list...');
1367: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Input param - pProspSupplierId :' ||
1368: pProspSupplierId );
1369: END IF;

Line 1366: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Entering get_ame_approval_list...');

1362: BEGIN
1363:
1364: if g_fnd_debug = 'Y' then
1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1366: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Entering get_ame_approval_list...');
1367: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Input param - pProspSupplierId :' ||
1368: pProspSupplierId );
1369: END IF;
1370: end if;

Line 1367: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Input param - pProspSupplierId :' ||

1363:
1364: if g_fnd_debug = 'Y' then
1365: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1366: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Entering get_ame_approval_list...');
1367: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Input param - pProspSupplierId :' ||
1368: pProspSupplierId );
1369: END IF;
1370: end if;
1371:

Line 1390: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1386: for i in 1 .. approverList.count loop
1387:
1388: l_valid_approver := 'Y';
1389: if g_fnd_debug = 'Y' then
1390: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1391: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' Processing the approver :' || i );
1392: END IF;
1393: end if;
1394:

Line 1391: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' Processing the approver :' || i );

1387:
1388: l_valid_approver := 'Y';
1389: if g_fnd_debug = 'Y' then
1390: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1391: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' Processing the approver :' || i );
1392: END IF;
1393: end if;
1394:
1395: -- do not consider the deleted approver.

Line 1412: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1408: if ( l_orig_system = 'PER') then
1409:
1410: -- Employee Supervisor Record.
1411: if g_fnd_debug = 'Y' then
1412: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1413: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Emp - Sup Record ...');
1414: END IF;
1415: end if;
1416:

Line 1413: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Emp - Sup Record ...');

1409:
1410: -- Employee Supervisor Record.
1411: if g_fnd_debug = 'Y' then
1412: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1413: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Emp - Sup Record ...');
1414: END IF;
1415: end if;
1416:
1417: l_full_name := approverList(i).display_name;

Line 1425: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1421: elsif ( l_orig_system = 'POS') then
1422:
1423: -- Position Hierarchy Record. The logic is mentioned in the comments section.
1424: if g_fnd_debug = 'Y' then
1425: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1426: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Position Hierarchy Record ...');
1427: END IF;
1428: end if;
1429:

Line 1426: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Position Hierarchy Record ...');

1422:
1423: -- Position Hierarchy Record. The logic is mentioned in the comments section.
1424: if g_fnd_debug = 'Y' then
1425: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1426: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Position Hierarchy Record ...');
1427: END IF;
1428: end if;
1429:
1430: begin

Line 1453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1449: elsif (l_orig_system = 'FND' OR l_orig_system = 'FND_USR' ) then
1450:
1451: -- FND User Record.
1452: if g_fnd_debug = 'Y' then
1453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1454: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
1455: END IF;
1456: end if;
1457:

Line 1454: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');

1450:
1451: -- FND User Record.
1452: if g_fnd_debug = 'Y' then
1453: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1454: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'FND User Record ...');
1455: END IF;
1456: end if;
1457:
1458: SELECT employee_id into l_person_id

Line 1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1464:
1465: end if;
1466:
1467: if g_fnd_debug = 'Y' then
1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1469: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_full_name :' || l_full_name );
1470: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_person_id :' || l_person_id );
1471: END IF;
1472: end if;

Line 1469: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_full_name :' || l_full_name );

1465: end if;
1466:
1467: if g_fnd_debug = 'Y' then
1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1469: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_full_name :' || l_full_name );
1470: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_person_id :' || l_person_id );
1471: END IF;
1472: end if;
1473:

Line 1470: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_person_id :' || l_person_id );

1466:
1467: if g_fnd_debug = 'Y' then
1468: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1469: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_full_name :' || l_full_name );
1470: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_person_id :' || l_person_id );
1471: END IF;
1472: end if;
1473:
1474: -- Find position | job name

Line 1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1502: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
1503: end if;
1504:
1505: if g_fnd_debug = 'Y' then
1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1507: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_job_or_position :' || l_job_or_position );
1508: END IF;
1509: end if;
1510:

Line 1507: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_job_or_position :' || l_job_or_position );

1503: end if;
1504:
1505: if g_fnd_debug = 'Y' then
1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1507: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, ' l_job_or_position :' || l_job_or_position );
1508: END IF;
1509: end if;
1510:
1511: end if;

Line 1549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

1545:
1546: pApprovalListStr := approvalListStr;
1547:
1548: if g_fnd_debug = 'Y' then
1549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1550: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Leaving get_ame_approval_list...');
1551: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListStr :' || pApprovalListStr);
1552: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListCount :' || pApprovalListCount);
1553: END IF;

Line 1550: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Leaving get_ame_approval_list...');

1546: pApprovalListStr := approvalListStr;
1547:
1548: if g_fnd_debug = 'Y' then
1549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1550: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Leaving get_ame_approval_list...');
1551: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListStr :' || pApprovalListStr);
1552: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListCount :' || pApprovalListCount);
1553: END IF;
1554: end if;

Line 1551: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListStr :' || pApprovalListStr);

1547:
1548: if g_fnd_debug = 'Y' then
1549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1550: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Leaving get_ame_approval_list...');
1551: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListStr :' || pApprovalListStr);
1552: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListCount :' || pApprovalListCount);
1553: END IF;
1554: end if;
1555:

Line 1552: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListCount :' || pApprovalListCount);

1548: if g_fnd_debug = 'Y' then
1549: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN
1550: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Leaving get_ame_approval_list...');
1551: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListStr :' || pApprovalListStr);
1552: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Output param -- pApprovalListCount :' || pApprovalListCount);
1553: END IF;
1554: end if;
1555:
1556: exception

Line 1561: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1557: when NO_DATA_FOUND then
1558: pApprovalListCount := 0;
1559: pApprovalListStr := 'NO_DATA_FOUND';
1560: if g_fnd_debug = 'Y' then
1561: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1562: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1563: l_api_name || '.NO_DATA_FOUND', 'NO_DATA_FOUND');
1564: END IF;
1565: end if;

Line 1562: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1558: pApprovalListCount := 0;
1559: pApprovalListStr := 'NO_DATA_FOUND';
1560: if g_fnd_debug = 'Y' then
1561: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1562: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1563: l_api_name || '.NO_DATA_FOUND', 'NO_DATA_FOUND');
1564: END IF;
1565: end if;
1566:

Line 1571: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

1567: when others then
1568: pApprovalListCount := 0;
1569: pApprovalListStr := 'EXCEPTION';
1570: if g_fnd_debug = 'Y' then
1571: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1572: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1573: l_api_name || '.others_exception', sqlerrm);
1574: END IF;
1575:

Line 1572: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||

1568: pApprovalListCount := 0;
1569: pApprovalListStr := 'EXCEPTION';
1570: if g_fnd_debug = 'Y' then
1571: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN
1572: FND_LOG.string(FND_LOG.level_unexpected, g_module_prefix ||
1573: l_api_name || '.others_exception', sqlerrm);
1574: END IF;
1575:
1576: end if;