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.FV_WF_BE_APPROVAL dependencies on FV_WF_BE_APPROVAL

Line 1: PACKAGE BODY Fv_Wf_Be_Approval AS

1: PACKAGE BODY Fv_Wf_Be_Approval AS
2: /* $Header: FVBEWFPB.pls 120.16 2011/03/02 07:29:20 yanasing ship $ */
3:
4: -- ======================================================================
5: -- Variable Naming Conventions

Line 16: g_module_name VARCHAR2(100) := 'fv.plsql.Fv_Wf_Be_Approval.';

12: -- ======================================================================
13: -- Global Variable Declarations
14: -- ======================================================================
15:
16: g_module_name VARCHAR2(100) := 'fv.plsql.Fv_Wf_Be_Approval.';
17: vg_errbuf VARCHAR2(1000) ;
18: vg_retcode NUMBER := 0 ;
19:
20: vg_itemtype wf_items.item_type%TYPE;

Line 308: avalue => 'PLSQL:FV_WF_BE_APPROVAL.GET_TRX_DOC_DETAILS/'|| vg_itemtype ||':'||vg_itemkey );

304:
305: Wf_Engine.SetItemAttrText(itemtype => vg_itemtype,
306: itemkey => vg_itemkey,
307: aname => 'TRANSACTION_DETAILS',
308: avalue => 'PLSQL:FV_WF_BE_APPROVAL.GET_TRX_DOC_DETAILS/'|| vg_itemtype ||':'||vg_itemkey );
309:
310: -- Populate #HDR_1(revision total amount), only if header attributes
311: -- are supported.
312: IF (Wf_Core.Translate('WF_HEADER_ATTR') = 'Y') then

Line 375: Wf_Core.Context('FV_WF_BE_APPROVAL','Main',vg_itemtype,vg_itemkey,vg_errbuf,vg_retcode);

371: COMMIT;
372:
373: EXCEPTION
374: WHEN e_invalid THEN
375: Wf_Core.Context('FV_WF_BE_APPROVAL','Main',vg_itemtype,vg_itemkey,vg_errbuf,vg_retcode);
376:
377: errbuf := vg_errbuf;
378: retcode := vg_retcode;
379:

Line 385: Wf_Core.Context('FV_WF_BE_APPROVAL','Main',vg_itemtype,vg_itemkey,SQLERRM,SQLCODE);

381: Raise;
382:
383: RETURN;
384: WHEN OTHERS THEN
385: Wf_Core.Context('FV_WF_BE_APPROVAL','Main',vg_itemtype,vg_itemkey,SQLERRM,SQLCODE);
386:
387: errbuf := SQLERRM ||' -- Error in Main procedure';
388: retcode := SQLCODE;
389:

Line 458: Wf_Core.Context('FV_WF_BE_APPROVAL','VerifyStatus',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);

454:
455: EXCEPTION
456: WHEN OTHERS THEN
457: l_errbuf := SQLERRM;
458: Wf_Core.Context('FV_WF_BE_APPROVAL','VerifyStatus',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);
459: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
460: Raise;
461: END VerifyStatus;
462:

Line 494: Wf_Core.Context('FV_WF_BE_APPROVAL','CheckRPRDocId',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);

490:
491: EXCEPTION
492: WHEN OTHERS THEN
493: l_errbuf := SQLERRM;
494: Wf_Core.Context('FV_WF_BE_APPROVAL','CheckRPRDocId',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);
495: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
496: Raise;
497: END CheckRPRDocId;
498:

Line 521: avalue => 'PLSQL:FV_WF_BE_APPROVAL.GET_RPR_DOC_DETAILS/'||itemtype||':'||itemkey );

517: -- Set the attribute RPR_Trx_Details
518: Wf_Engine.SetItemAttrText(itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'RPR_TRX_DETAILS',
521: avalue => 'PLSQL:FV_WF_BE_APPROVAL.GET_RPR_DOC_DETAILS/'||itemtype||':'||itemkey );
522:
523:
524: resultout := 'COMPLETE';
525:

Line 534: Wf_Core.Context('FV_WF_BE_APPROVAL','GetRPRDetails',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);

530:
531: EXCEPTION
532: WHEN OTHERS THEN
533: l_errbuf := SQLERRM;
534: Wf_Core.Context('FV_WF_BE_APPROVAL','GetRPRDetails',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);
535: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
536: Raise;
537: END GetRPRDetails;
538:

Line 623: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproverPostNtf',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);

619: END IF;
620:
621: EXCEPTION
622: WHEN e_invalid THEN
623: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproverPostNtf',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);
624: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
625: Raise;
626:
627: WHEN OTHERS THEN

Line 629: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproverPostNtf',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);

625: Raise;
626:
627: WHEN OTHERS THEN
628: l_errbuf := SQLERRM;
629: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproverPostNtf',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);
630: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
631: Raise;
632: END ApproverPostNtf;
633:

Line 824: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproveDoc',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);

820:
821: EXCEPTION
822: WHEN OTHERS THEN
823: l_errbuf := vg_errbuf||SQLERRM;
824: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproveDoc',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);
825: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
826: Raise;
827: END ApproveDoc;
828:

Line 897: Wf_Core.Context('FV_WF_BE_APPROVAL','TimeoutPostNtf',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);

893: END IF;
894:
895: EXCEPTION
896: WHEN e_invalid THEN
897: Wf_Core.Context('FV_WF_BE_APPROVAL','TimeoutPostNtf',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);
898: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproveDoc',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);
899: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
900: Raise;
901:

Line 898: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproveDoc',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);

894:
895: EXCEPTION
896: WHEN e_invalid THEN
897: Wf_Core.Context('FV_WF_BE_APPROVAL','TimeoutPostNtf',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);
898: Wf_Core.Context('FV_WF_BE_APPROVAL','ApproveDoc',itemtype,itemkey,to_char(actid),vg_errbuf,vg_retcode);
899: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
900: Raise;
901:
902: WHEN OTHERS THEN

Line 904: Wf_Core.Context('FV_WF_BE_APPROVAL','TimeoutPostNtf',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);

900: Raise;
901:
902: WHEN OTHERS THEN
903: l_errbuf := SQLERRM;
904: Wf_Core.Context('FV_WF_BE_APPROVAL','TimeoutPostNtf',itemtype,itemkey,to_char(actid),l_errbuf,SQLCODE);
905: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
906: Raise;
907: END TimeoutPostNtf;
908:

Line 1030: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_Trx_Doc_Details',vg_itemtype,vg_itemkey,vg_errbuf,vg_retcode);

1026: document := vl_document;
1027:
1028: EXCEPTION
1029: WHEN e_invalid THEN
1030: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_Trx_Doc_Details',vg_itemtype,vg_itemkey,vg_errbuf,vg_retcode);
1031: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
1032: Raise;
1033: WHEN OTHERS THEN
1034: l_errbuf := SQLERRM;

Line 1035: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_Trx_Doc_Details',vg_itemtype,vg_itemkey,l_errbuf,SQLCODE);

1031: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
1032: Raise;
1033: WHEN OTHERS THEN
1034: l_errbuf := SQLERRM;
1035: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_Trx_Doc_Details',vg_itemtype,vg_itemkey,l_errbuf,SQLCODE);
1036: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
1037: Raise;
1038: END Get_Trx_Doc_Details;
1039:

Line 1076: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_RPR_Doc_Details',vg_itemtype,vg_itemkey,vg_errbuf,vg_retcode);

1072: document := vl_document;
1073:
1074: EXCEPTION
1075: WHEN e_invalid THEN
1076: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_RPR_Doc_Details',vg_itemtype,vg_itemkey,vg_errbuf,vg_retcode);
1077: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
1078: Raise;
1079: WHEN OTHERS THEN
1080: l_errbuf := SQLERRM;

Line 1081: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_RPR_Doc_Details',vg_itemtype,vg_itemkey,l_errbuf,SQLCODE);

1077: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.e_invalid',vg_errbuf);
1078: Raise;
1079: WHEN OTHERS THEN
1080: l_errbuf := SQLERRM;
1081: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_RPR_Doc_Details',vg_itemtype,vg_itemkey,l_errbuf,SQLCODE);
1082: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
1083: Raise;
1084: END Get_RPR_Doc_Details;
1085:

Line 1221: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_RPR_Doc_Details',vg_itemtype,vg_itemkey,l_errbuf,SQLCODE);

1217:
1218: EXCEPTION
1219: WHEN OTHERS THEN
1220: l_errbuf := SQLERRM;
1221: Wf_Core.Context('FV_WF_BE_APPROVAL','Get_RPR_Doc_Details',vg_itemtype,vg_itemkey,l_errbuf,SQLCODE);
1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
1223: Raise;
1224: END Build_Document;
1225:

Line 1226: END Fv_Wf_Be_Approval;

1222: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',l_errbuf);
1223: Raise;
1224: END Build_Document;
1225:
1226: END Fv_Wf_Be_Approval;