37: --+
38: --+ launchNotificationsWorkflow
39: --+
40: function launchNotificationsWorkflow ( p_subscriptionGuid in raw
41: , p_event in out nocopy WF_EVENT_T ) return varchar2 is
42: l_eventData varchar2(32767);
43: l_assignmentId number;
44: l_vacancyId number;
45: l_candidateId number;
254: when others then
255: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);
256: hr_utility.set_location('Error Message: ' || sqlerrm, 210);
257: WF_CORE.CONTEXT('IRC_NOTIFICATIONS_WORKFLOW_PKG','launchNotificationsWorkflow',p_event.getEventName( ), p_subscriptionGuid);
258: WF_EVENT.setErrorInfo(p_event, 'ERROR');
259: return 'ERROR';
260: end launchNotificationsWorkflow;
261: --+
262: --+ parseAndReplaceFNDMessage