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

Line 1: PACKAGE BODY EDR_PSIG_PAGE_FLOW AS

1: PACKAGE BODY EDR_PSIG_PAGE_FLOW AS
2: /* $Header: EDRESGPB.pls 120.13.12020000.3 2013/02/21 02:55:19 qzeng ship $ */
3:
4: --global variables
5: G_YES CONSTANT varchar2(15) := 'COMPLETE:Y';

Line 139: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := p_result;

135: -- Bug 3903471 : End
136:
137: -- Bug #3368868 : Ends
138:
139: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := p_result;
140: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := p_result;
141: -- Bug #3368868 : Starts
142: -- If transaction status is ERROR do not call post_op_api
143: IF l_trans_status <> 'ERROR' THEN

Line 162: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;

158: END IF;
159:
160: -- Bug 3411859 : Start
161: -- Signature status should be set to null in all cases .
162: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;
163: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := null;
164: -- Bug 3411859 : End
165:
166: EXCEPTION

Line 168: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;

164: -- Bug 3411859 : End
165:
166: EXCEPTION
167: WHEN OTHERS THEN
168: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;
169: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := null;
170: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW','Post Operation Proc Excution',p_itemtype,p_itemkey,l_SQL);
171: raise;
172: END;

Line 170: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW','Post Operation Proc Excution',p_itemtype,p_itemkey,l_SQL);

166: EXCEPTION
167: WHEN OTHERS THEN
168: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;
169: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := null;
170: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW','Post Operation Proc Excution',p_itemtype,p_itemkey,l_SQL);
171: raise;
172: END;
173:
174:

Line 192: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','Get_event_disp_name',p_event_id);

188: from wf_events_vl
189: where name = l_event_name;
190: return(L_event_disp_name);
191: EXCEPTION WHEN OTHERS THEN
192: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','Get_event_disp_name',p_event_id);
193: raise;
194: END;
195:
196:

Line 332: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','AUTHENTICATE_RESPONSE',p_itemtype,p_itemkey,'Notified');

328: p_resultout := 'COMPLETE:';
329: END IF;
330: EXCEPTION
331: WHEN OTHERS THEN
332: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','AUTHENTICATE_RESPONSE',p_itemtype,p_itemkey,'Notified');
333: raise;
334: END;
335: /*******************************************************************************************
336: ***** Update record status to cancel assuming EVENT_ID and Workflow ITEM_KEY is Same ***

Line 414: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','CANCEL_RESPONSE',p_itemtype,p_itemkey,

410: p_resultout := 'COMPLETE:';
411: END IF;
412: EXCEPTION
413: WHEN EDR_PSIG_DOC_ERR THEN
414: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','CANCEL_RESPONSE',p_itemtype,p_itemkey,
415: l_error_num,L_ERROR_MESG);
416: raise;
417: WHEN OTHERS THEN
418: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','CANCEL_RESPONSE',p_itemtype,p_itemkey,'OK');

Line 418: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','CANCEL_RESPONSE',p_itemtype,p_itemkey,'OK');

414: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','CANCEL_RESPONSE',p_itemtype,p_itemkey,
415: l_error_num,L_ERROR_MESG);
416: raise;
417: WHEN OTHERS THEN
418: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','CANCEL_RESPONSE',p_itemtype,p_itemkey,'OK');
419: raise;
420: END;
421: /******************************************************************************************
422: *** This is the main procedure which controls total offline flow and response to done ***

Line 668: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','PROCESS_RESPONSE',p_itemtype,p_itemkey,

664: END IF; -- end if Run Mode
665:
666: EXCEPTION
667: WHEN EDR_PSIG_DOC_ERR THEN
668: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','PROCESS_RESPONSE',p_itemtype,p_itemkey,
669: l_error_num,l_error_msg||L_ERROR_MESG);
670: raise;
671: WHEN OTHERS THEN
672: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','PROCESS_RESPONSE',p_itemtype,p_itemkey,L_ERROR_MSG);

Line 672: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','PROCESS_RESPONSE',p_itemtype,p_itemkey,L_ERROR_MSG);

668: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','PROCESS_RESPONSE',p_itemtype,p_itemkey,
669: l_error_num,l_error_msg||L_ERROR_MESG);
670: raise;
671: WHEN OTHERS THEN
672: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','PROCESS_RESPONSE',p_itemtype,p_itemkey,L_ERROR_MSG);
673: raise;
674: END;
675:
676: /****************************************************************

Line 884: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',

880: -- if they are differnt then only call find wf ntf recipients API.
881:
882: IF( l_user_name = WF_ENGINE.CONTEXT_USER) THEN
883:
884: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',
885: p_itemtype,p_itemkey,
886: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_REASSIGN_ERR'));
887: raise_application_error(-20003,FND_MESSAGE.GET_STRING('EDR','EDR_EREC_REASSIGN_ERR'));
888: END IF;

Line 898: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

894:
895: l_SIGNER_TYPE := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'WF_SIGNER_TYPE');
896: l_signer_reason := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid,'REASON_CODE');
897: IF l_signer_reason IS null OR l_SIGNER_TYPE IS NULL THEN
898: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
899: 'Signer Comment and Signing Reason code can not be null.');
900: raise EDR_PSIG_NOT_NULL;
901: END IF;
902:

Line 914: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW', 'UPDATE_NOTIF_RESPONSE',p_itemtype, p_itemkey,

910: -- attribute is not found for previous notificaitons backward compitability.
911: L_RESPONSE_READ := GET_NOTIF_ITEM_ATTR_TEXT(wf_engine.context_nid, 'READ_RESPONSE');
912: -- End Bug 3847779
913: IF (L_RESPONSE_READ = 'N') THEN
914: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW', 'UPDATE_NOTIF_RESPONSE',p_itemtype, p_itemkey,
915: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));
916: raise_application_error(-20002,FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));
917: END IF;
918: END IF;

Line 965: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,l_error_num,L_ERROR_MESG);

961: EXCEPTION WHEN NO_DATA_FOUND THEN
962: -- If there are No notifications to be cancelled, then nothing is to be cancelled. Hence No action needed.
963: null;
964: WHEN OTHERS THEN
965: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,l_error_num,L_ERROR_MESG);
966: raise;
967: END;
968:
969: if lp_notification_id is not null and lp_notification_id > 0 then

Line 1237: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

1233: L_NTF_RESPOND_ROLE);
1234: END IF;
1235:
1236: EXCEPTION WHEN EDR_PSIG_NOT_NULL THEN
1237: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1238: 'Signer Comment and Signing Reason code can not be null.');
1239: raise;
1240: WHEN EDR_PSIG_DOC_ERR THEN
1241: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

Line 1241: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

1237: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1238: 'Signer Comment and Signing Reason code can not be null.');
1239: raise;
1240: WHEN EDR_PSIG_DOC_ERR THEN
1241: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1242: l_error_num,L_ERROR_MESG);
1243: raise;
1244: WHEN EDR_PSIG_NOT_READ THEN
1245: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

Line 1245: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

1241: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1242: l_error_num,L_ERROR_MESG);
1243: raise;
1244: WHEN EDR_PSIG_NOT_READ THEN
1245: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1246: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));
1247: raise;
1248: WHEN OTHERS THEN
1249: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

Line 1249: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,

1245: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1246: FND_MESSAGE.GET_STRING('EDR','EDR_EREC_NOT_REVIEWED_ERR'));
1247: raise;
1248: WHEN OTHERS THEN
1249: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','UPDATE_NOTIF_RESPONSE',p_itemtype,p_itemkey,
1250: l_error_num,L_ERROR_MESG);
1251: raise;
1252: END UPDATE_NOTIF_RESPONSE;
1253:

Line 1676: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','SPWAN_OFFLINE_PROCESS',l_itemtype,l_item_key,'Initial' );

1672: CLOSE CURR_LIST_SIGNERS;
1673: end if;
1674: EXCEPTION
1675: WHEN OTHERS THEN
1676: WF_CORE.CONTEXT ('EDR_PSIG_PAGE_FLOW','SPWAN_OFFLINE_PROCESS',l_itemtype,l_item_key,'Initial' );
1677: CLOSE CURR_LIST_SIGNERS;
1678: raise;
1679: END SPWAN_OFFLINE_PROCESS;
1680:

Line 2165: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_PAGE_FLOW');

2161: ROLLBACK;
2162: --Diagnostics Start
2163: FND_MESSAGE.SET_NAME('FND','FND_AS_UNEXPECTED_ERROR');
2164: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
2165: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_PAGE_FLOW');
2166: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','MOVE_WF_ACTIVITY');
2167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
2169: 'edr.plsql.EDR_PSIG_PAGE_FLOW.MOVE_WF_ACTIVITY',

Line 2169: 'edr.plsql.EDR_PSIG_PAGE_FLOW.MOVE_WF_ACTIVITY',

2165: FND_MESSAGE.SET_TOKEN('PKG_NAME','EDR_PSIG_PAGE_FLOW');
2166: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME','MOVE_WF_ACTIVITY');
2167: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2168: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,
2169: 'edr.plsql.EDR_PSIG_PAGE_FLOW.MOVE_WF_ACTIVITY',
2170: FALSE
2171: );
2172: end if;
2173: --Diagnostics End

Line 2177: END EDR_PSIG_PAGE_FLOW;

2173: --Diagnostics End
2174: APP_EXCEPTION.RAISE_EXCEPTION;
2175: END MOVE_WF_ACTIVITY;
2176: -- Bug 5166723 : End
2177: END EDR_PSIG_PAGE_FLOW;