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.IRC_NOTIFICATION_WORKFLOW_PKG dependencies on HR_UTILITY

Line 14: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

10: l_key varchar2(200);
11: l_value varchar2(2000);
12: l_proc constant varchar2(50) := 'loadWorkflowAttributes';
13: begin
14: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
15: l_temp := p_eventData;
16: while ( length(l_temp) <> 0) loop
17: l_key := substr(l_temp, 1, instr(l_temp, ':') - 1);
18: l_temp := substr(l_temp, instr(l_temp, ':') + 1);

Line 28: hr_utility.set_location('Error Message : ' ||sqlerrm,50);

24: , aname => l_key
25: , avalue => l_value);
26: exception
27: when others then
28: hr_utility.set_location('Error Message : ' ||sqlerrm,50);
29: end;
30: end loop;
31: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);
32: exception

Line 31: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);

27: when others then
28: hr_utility.set_location('Error Message : ' ||sqlerrm,50);
29: end;
30: end loop;
31: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);
32: exception
33: when others then
34: hr_utility.set_location('Error - Exiting:' || g_package||'.'||l_proc, 110);
35: hr_utility.set_location('Error Message : ' || sqlerrm,130);

Line 34: hr_utility.set_location('Error - Exiting:' || g_package||'.'||l_proc, 110);

30: end loop;
31: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);
32: exception
33: when others then
34: hr_utility.set_location('Error - Exiting:' || g_package||'.'||l_proc, 110);
35: hr_utility.set_location('Error Message : ' || sqlerrm,130);
36: end loadWorkflowAttributes;
37: --+
38: --+ launchNotificationsWorkflow

Line 35: hr_utility.set_location('Error Message : ' || sqlerrm,130);

31: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);
32: exception
33: when others then
34: hr_utility.set_location('Error - Exiting:' || g_package||'.'||l_proc, 110);
35: hr_utility.set_location('Error Message : ' || sqlerrm,130);
36: end loadWorkflowAttributes;
37: --+
38: --+ launchNotificationsWorkflow
39: --+

Line 64: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

60: l_itemType varchar2(50);
61: l_itemKey varchar2(50);
62: l_proc constant varchar2(50) := 'launchNotificationsWorkflow';
63: begin
64: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
65: l_eventData := p_event.event_data;
66: l_assignmentId := IRC_NOTIFICATION_DATA_PKG.getParamValue
67: ( p_param => 'IRC_ASSIGNMENT_ID'
68: , p_eventData => l_eventData);

Line 69: hr_utility.set_location('Assignment Id : ' || l_assignmentId, 20);

65: l_eventData := p_event.event_data;
66: l_assignmentId := IRC_NOTIFICATION_DATA_PKG.getParamValue
67: ( p_param => 'IRC_ASSIGNMENT_ID'
68: , p_eventData => l_eventData);
69: hr_utility.set_location('Assignment Id : ' || l_assignmentId, 20);
70: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue
71: ( p_param => 'IRC_EVENT_NAME'
72: , p_eventData => l_eventData);
73: hr_utility.set_location('Event Name : ' || l_eventName, 30);

Line 73: hr_utility.set_location('Event Name : ' || l_eventName, 30);

69: hr_utility.set_location('Assignment Id : ' || l_assignmentId, 20);
70: l_eventName := IRC_NOTIFICATION_DATA_PKG.getParamValue
71: ( p_param => 'IRC_EVENT_NAME'
72: , p_eventData => l_eventData);
73: hr_utility.set_location('Event Name : ' || l_eventName, 30);
74: l_effectiveDate := to_date( IRC_NOTIFICATION_DATA_PKG.getParamValue
75: ( p_param => 'IRC_EFFECTIVE_DATE'
76: , p_eventData => l_eventData)
77: , 'DD-MM-RRRR');

Line 81: hr_utility.set_location('Effective Date : ' || l_effectiveDate, 40);

77: , 'DD-MM-RRRR');
78: if l_effectiveDate is null then
79: l_effectiveDate := sysdate;
80: end if;
81: hr_utility.set_location('Effective Date : ' || l_effectiveDate, 40);
82: l_vacancyId := IRC_NOTIFICATION_DATA_PKG.getParamValue
83: ( p_param => 'IRC_VACANCY_ID'
84: , p_eventData => l_eventData);
85: if l_vacancyId is null then

Line 94: hr_utility.set_location('Vacancy Id : ' || l_vacancyId, 50);

90: || 'IRC_VACANCY_ID:'
91: || l_vacancyId
92: ||';';
93: end if;
94: hr_utility.set_location('Vacancy Id : ' || l_vacancyId, 50);
95: if l_vacancyId is not null then
96: l_eventData := l_eventData
97: || IRC_NOTIFICATION_DATA_PKG.getVacancyDetails
98: ( p_vacancyId => l_vacancyId

Line 113: hr_utility.set_location('Candidate Id : ' || l_candidateId, 60);

109: l_candidateId := irc_utilities_pkg.GET_RECRUITMENT_PERSON_ID
110: ( p_person_id => l_candidateId
111: , p_effective_date => l_effectiveDate);
112: end if;
113: hr_utility.set_location('Candidate Id : ' || l_candidateId, 60);
114: if l_candidateId is not null then
115: l_eventData := l_eventData
116: || 'IRC_CAND_PER_ID:'
117: || l_candidateId

Line 132: hr_utility.set_location('Manager Id : ' || l_managerId, 70);

128: end if;
129: l_managerId := IRC_NOTIFICATION_DATA_PKG.getManagerPersonId
130: ( p_vacancyId => l_vacancyId
131: , p_effectiveDate => l_effectiveDate);
132: hr_utility.set_location('Manager Id : ' || l_managerId, 70);
133: if l_managerId IS NOT null then
134: l_eventData := l_eventData
135: || 'IRC_MGR_PER_ID:'
136: || l_managerId

Line 147: hr_utility.set_location('Recruiter Id : ' || l_recruiterId, 80);

143: end if;
144: l_recruiterId := IRC_NOTIFICATION_DATA_PKG.getRecruiterPersonId
145: ( p_assignmentId => l_assignmentId
146: , p_effectiveDate => l_effectiveDate);
147: hr_utility.set_location('Recruiter Id : ' || l_recruiterId, 80);
148: if l_recruiterId IS NOT null then
149: l_eventData := l_eventData
150: || 'IRC_REC_PER_ID:'
151: || l_recruiterId

Line 162: hr_utility.set_location('Referrer Id : ' || l_referrerId, 90);

158: end if;
159: l_referrerId := IRC_NOTIFICATION_DATA_PKG.getParamValue
160: ( p_param => 'IRC_REFR_PER_ID'
161: , p_eventData => l_eventData);
162: hr_utility.set_location('Referrer Id : ' || l_referrerId, 90);
163: if l_referrerId IS NOT null then
164: l_eventData := l_eventData
165: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
166: ( p_personId => l_referrerId

Line 173: hr_utility.set_location('Action Performer Id : ' || l_actionPerformerId, 100);

169: end if;
170: l_actionPerformerId := IRC_NOTIFICATION_DATA_PKG.getParamValue
171: ( p_param => 'IRC_ACT_PERF_PER_ID'
172: , p_eventData => l_eventData);
173: hr_utility.set_location('Action Performer Id : ' || l_actionPerformerId, 100);
174: if l_actionPerformerId is not null then
175: l_eventData := l_eventData
176: || IRC_NOTIFICATION_DATA_PKG.getPersonDetails
177: ( p_personId => l_actionPerformerId

Line 251: hr_utility.set_location('Populated all data:Create Workflow', 110);

247: || IRC_NOTIFICATION_DATA_PKG.getinterviersnameshtml
248: ( p_interviewid => l_interviewId
249: , p_effectivedate => l_effectiveDate);
250: end if;
251: hr_utility.set_location('Populated all data:Create Workflow', 110);
252: hr_utility.set_location('Event Data : '||l_eventData, 120);
253: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
254: hr_utility.set_location('Item Type : '||l_itemType, 130);
255: if l_itemType is not NULL then

Line 252: hr_utility.set_location('Event Data : '||l_eventData, 120);

248: ( p_interviewid => l_interviewId
249: , p_effectivedate => l_effectiveDate);
250: end if;
251: hr_utility.set_location('Populated all data:Create Workflow', 110);
252: hr_utility.set_location('Event Data : '||l_eventData, 120);
253: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
254: hr_utility.set_location('Item Type : '||l_itemType, 130);
255: if l_itemType is not NULL then
256: l_itemKey := p_event.event_key;

Line 254: hr_utility.set_location('Item Type : '||l_itemType, 130);

250: end if;
251: hr_utility.set_location('Populated all data:Create Workflow', 110);
252: hr_utility.set_location('Event Data : '||l_eventData, 120);
253: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
254: hr_utility.set_location('Item Type : '||l_itemType, 130);
255: if l_itemType is not NULL then
256: l_itemKey := p_event.event_key;
257: wf_engine.CreateProcess(l_itemType
258: ,l_itemKey

Line 266: hr_utility.set_location('Workflow Item Type not set', 160);

262: , p_itemKey => l_itemKey );
263: wf_engine.startprocess( l_itemType
264: , l_itemKey);
265: else
266: hr_utility.set_location('Workflow Item Type not set', 160);
267: end if;
268: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 180);
269: return 'SUCCESS';
270: exception

Line 268: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 180);

264: , l_itemKey);
265: else
266: hr_utility.set_location('Workflow Item Type not set', 160);
267: end if;
268: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 180);
269: return 'SUCCESS';
270: exception
271: when others then
272: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);

Line 272: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);

268: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 180);
269: return 'SUCCESS';
270: exception
271: when others then
272: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);
273: hr_utility.set_location('Error Message: ' || sqlerrm, 210);
274: WF_CORE.CONTEXT('IRC_NOTIFICATIONS_WORKFLOW_PKG','launchNotificationsWorkflow',p_event.getEventName( ), p_subscriptionGuid);
275: WF_EVENT.setErrorInfo(p_event, 'ERROR');
276: return 'ERROR';

Line 273: hr_utility.set_location('Error Message: ' || sqlerrm, 210);

269: return 'SUCCESS';
270: exception
271: when others then
272: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);
273: hr_utility.set_location('Error Message: ' || sqlerrm, 210);
274: WF_CORE.CONTEXT('IRC_NOTIFICATIONS_WORKFLOW_PKG','launchNotificationsWorkflow',p_event.getEventName( ), p_subscriptionGuid);
275: WF_EVENT.setErrorInfo(p_event, 'ERROR');
276: return 'ERROR';
277: end launchNotificationsWorkflow;

Line 303: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

299: cursor c_func(p_function_name varchar2) is
300: select function_id from fnd_form_functions
301: where function_name = p_function_name;
302: begin
303: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
304: l_eventName := wf_engine.getItemAttrText ( itemtype => p_itemType
305: , itemkey => p_itemKey
306: , aname => 'IRC_EVENT_NAME');
307: hr_utility.set_location('Event name : '||l_eventName,20);

Line 307: hr_utility.set_location('Event name : '||l_eventName,20);

303: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
304: l_eventName := wf_engine.getItemAttrText ( itemtype => p_itemType
305: , itemkey => p_itemKey
306: , aname => 'IRC_EVENT_NAME');
307: hr_utility.set_location('Event name : '||l_eventName,20);
308: l_isInternalPerson := irc_utilities_pkg.is_internal_person
309: (p_person_id=> p_recipientPersonId,
310: p_eff_date => trunc(sysdate)
311: );

Line 330: hr_utility.set_location('Assignment Id : '||l_assignmentId,30);

326: l_candidatePersonId := wf_engine.getItemAttrText ( itemtype => p_itemType
327: , itemkey => p_itemKey
328: , aname => 'IRC_CAND_PER_ID');
329:
330: hr_utility.set_location('Assignment Id : '||l_assignmentId,30);
331: hr_utility.set_location('Candidate Person Id : '||l_candidatePersonId,40);
332:
333: if p_personType = 'CAND' then
334: if l_isInternalPerson = 'TRUE' then

Line 331: hr_utility.set_location('Candidate Person Id : '||l_candidatePersonId,40);

327: , itemkey => p_itemKey
328: , aname => 'IRC_CAND_PER_ID');
329:
330: hr_utility.set_location('Assignment Id : '||l_assignmentId,30);
331: hr_utility.set_location('Candidate Person Id : '||l_candidatePersonId,40);
332:
333: if p_personType = 'CAND' then
334: if l_isInternalPerson = 'TRUE' then
335: l_func := 'IRC_EMP_VIS_APPLY_LOGIN_PAGE';

Line 381: hr_utility.set_location('l_params:'||l_params,50);

377: end if;
378: end if;
379: end if;
380:
381: hr_utility.set_location('l_params:'||l_params,50);
382: open c_func(l_func);
383: fetch c_func into l_funcId;
384: close c_func;
385:

Line 394: hr_utility.set_location('Generated URL : '||l_url,60);

390: p_override_agent=>l_apps_fwk_agent,
391: p_parameters =>l_params,
392: p_encryptParameters =>true ) ;
393:
394: hr_utility.set_location('Generated URL : '||l_url,60);
395: wf_engine.setItemAttrText( itemtype => p_itemType
396: , itemkey => p_itemKey
397: , aname => p_urlAttribute
398: , avalue => l_url);

Line 399: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 70);

395: wf_engine.setItemAttrText( itemtype => p_itemType
396: , itemkey => p_itemKey
397: , aname => p_urlAttribute
398: , avalue => l_url);
399: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 70);
400: exception
401: when others then
402: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);
403: hr_utility.set_location('Error Message : ' || sqlerrm, 210);

Line 402: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);

398: , avalue => l_url);
399: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 70);
400: exception
401: when others then
402: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);
403: hr_utility.set_location('Error Message : ' || sqlerrm, 210);
404: end constructURL;
405: --+
406: --+ parseAndReplaceFNDMessage

Line 403: hr_utility.set_location('Error Message : ' || sqlerrm, 210);

399: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 70);
400: exception
401: when others then
402: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 200);
403: hr_utility.set_location('Error Message : ' || sqlerrm, 210);
404: end constructURL;
405: --+
406: --+ parseAndReplaceFNDMessage
407: --+

Line 420: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

416: l_token varchar2(1000);
417: l_value varchar2(10000):= null;
418: l_proc constant varchar2(50) := 'parseAndReplaceFNDMessage';
419: begin
420: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
421: while (l_leftIndex <> 0) loop
422: l_value := null;
423: l_leftIndex := instr(l_returnMessage, '&' || 'IRC');
424: if (l_leftIndex = 0) then

Line 462: hr_utility.set_location('Token for hyperlink',20);

458: if(instr(l_token,':') <> 0) then
459: l_token := substr(l_token,0, instr(l_token,':')-1);
460: end if;
461: if l_token like 'IRC%HYPERLINK%' then
462: hr_utility.set_location('Token for hyperlink',20);
463: constructURL ( p_itemType => p_itemType
464: , p_itemKey => p_itemKey
465: , p_urlAttribute => l_token
466: , p_recipientPersonId =>p_personId

Line 475: hr_utility.set_location('Error in getting Workflow attribute : ' || sqlerrm, 50);

471: , itemkey => p_itemKey
472: , aname => l_token);
473: exception
474: when others then
475: hr_utility.set_location('Error in getting Workflow attribute : ' || sqlerrm, 50);
476: end;
477: l_rightIndex := l_leftIndex + lengthb(l_token)+1;
478: l_returnMessage := substr(l_returnMessage, 1, l_leftIndex -1 )
479: || l_value

Line 482: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);

478: l_returnMessage := substr(l_returnMessage, 1, l_leftIndex -1 )
479: || l_value
480: || substr(l_returnMessage, l_rightIndex);
481: end loop;
482: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);
483: return l_returnMessage;
484: exception
485: when others then
486: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 120);

Line 486: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 120);

482: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 100);
483: return l_returnMessage;
484: exception
485: when others then
486: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 120);
487: hr_utility.set_location('Error Message : ' || sqlerrm, 130);
488: end parseAndReplaceFNDMessage;
489: --+
490: --+ attatchDoc

Line 487: hr_utility.set_location('Error Message : ' || sqlerrm, 130);

483: return l_returnMessage;
484: exception
485: when others then
486: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 120);
487: hr_utility.set_location('Error Message : ' || sqlerrm, 130);
488: end parseAndReplaceFNDMessage;
489: --+
490: --+ attatchDoc
491: --+

Line 566: hr_utility.set_location('Entering attatchDocument:'|| g_package||'.'||l_proc, 10);

562: l_doc_type := 'RESUME';
563: else
564: l_doc_type := 'AUTO_RESUME';
565: end if;
566: hr_utility.set_location('Entering attatchDocument:'|| g_package||'.'||l_proc, 10);
567: hr_utility.set_location('attatchDocument:p_personIdIn:'||p_personIdIn, 30);
568: hr_utility.set_location('attatchDocument:p_eventName:'||p_eventName, 40);
569: if p_personIdIn is not null then
570: l_person_id := to_number(p_personIdIn);

Line 567: hr_utility.set_location('attatchDocument:p_personIdIn:'||p_personIdIn, 30);

563: else
564: l_doc_type := 'AUTO_RESUME';
565: end if;
566: hr_utility.set_location('Entering attatchDocument:'|| g_package||'.'||l_proc, 10);
567: hr_utility.set_location('attatchDocument:p_personIdIn:'||p_personIdIn, 30);
568: hr_utility.set_location('attatchDocument:p_eventName:'||p_eventName, 40);
569: if p_personIdIn is not null then
570: l_person_id := to_number(p_personIdIn);
571: else

Line 568: hr_utility.set_location('attatchDocument:p_eventName:'||p_eventName, 40);

564: l_doc_type := 'AUTO_RESUME';
565: end if;
566: hr_utility.set_location('Entering attatchDocument:'|| g_package||'.'||l_proc, 10);
567: hr_utility.set_location('attatchDocument:p_personIdIn:'||p_personIdIn, 30);
568: hr_utility.set_location('attatchDocument:p_eventName:'||p_eventName, 40);
569: if p_personIdIn is not null then
570: l_person_id := to_number(p_personIdIn);
571: else
572: return;

Line 588: hr_utility.set_location('error:'||sqlerrm, 30);

584: return;
585: end if;
586: exception
587: when others then
588: hr_utility.set_location('error:'||sqlerrm, 30);
589: end;
590: if l_intw_status is not null and l_intw_status in ('CONFIRMED','RESCHEDULED') then
591: wf_notification.setAttrText(p_notificationIdIn,
592: 'IRC_CAL_ATTACHMENT',

Line 607: hr_utility.set_location('Exiting attatchDocument:'|| g_package||'.'||l_proc, 60);

603: 'plsqlblob:irc_notification_workflow_pkg.attatchDoc/'||l_doc_ids(i));
604: end loop;
605: end if;
606: end if;
607: hr_utility.set_location('Exiting attatchDocument:'|| g_package||'.'||l_proc, 60);
608: exception
609: when others then
610: hr_utility.set_location('Error occurred in :'|| g_package||'.'||l_proc, 70);
611: hr_utility.set_location('Error Message:'|| SQLERRM, 80);

Line 610: hr_utility.set_location('Error occurred in :'|| g_package||'.'||l_proc, 70);

606: end if;
607: hr_utility.set_location('Exiting attatchDocument:'|| g_package||'.'||l_proc, 60);
608: exception
609: when others then
610: hr_utility.set_location('Error occurred in :'|| g_package||'.'||l_proc, 70);
611: hr_utility.set_location('Error Message:'|| SQLERRM, 80);
612: end attachDocument;
613: --+
614: --+ getNextRecipient

Line 611: hr_utility.set_location('Error Message:'|| SQLERRM, 80);

607: hr_utility.set_location('Exiting attatchDocument:'|| g_package||'.'||l_proc, 60);
608: exception
609: when others then
610: hr_utility.set_location('Error occurred in :'|| g_package||'.'||l_proc, 70);
611: hr_utility.set_location('Error Message:'|| SQLERRM, 80);
612: end attachDocument;
613: --+
614: --+ getNextRecipient
615: --+

Line 672: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

668: and language_code = ( select language_code
669: from fnd_languages_vl
670: where nls_language = c_language );
671: BEGIN
672: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
673: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
674: l_oldExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_JOB_APPL_OLD_STATUS');
675: l_newExtStatus := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => p_itemKey,aname => 'IRC_APPL_NEW_EXTERNAL_STATUS');
676:

Line 680: hr_utility.set_location('AME Transaction Type : ' || l_ameTransactionType, 20);

676:
677: l_ameTransactionType := fnd_profile.value('IRC_NTF_AME_TX_TYPE');
678: l_person_type := null;
679: if l_ameTransactionType is not NULL then
680: hr_utility.set_location('AME Transaction Type : ' || l_ameTransactionType, 20);
681: begin
682: ame_api2.getNextApprovers2(applicationIdIn => 800
683: , transactionTypeIn => l_ameTransactionType
684: , transactionIdIn => p_itemKey

Line 698: hr_utility.set_location('AME Transaction Complete : ' || l_approvalprocesscompleteynout,30);

694: exception
695: when others then
696: raise e_ameException;
697: end;
698: hr_utility.set_location('AME Transaction Complete : ' || l_approvalprocesscompleteynout,30);
699: if l_approvalProcessCompleteYNOut = 'N' then
700: hr_utility.set_location('Recipient : ' || l_nextApprovers(1).name,60);
701:
702: wf_engine.setItemAttrText ( itemtype => p_itemType

Line 700: hr_utility.set_location('Recipient : ' || l_nextApprovers(1).name,60);

696: raise e_ameException;
697: end;
698: hr_utility.set_location('AME Transaction Complete : ' || l_approvalprocesscompleteynout,30);
699: if l_approvalProcessCompleteYNOut = 'N' then
700: hr_utility.set_location('Recipient : ' || l_nextApprovers(1).name,60);
701:
702: wf_engine.setItemAttrText ( itemtype => p_itemType
703: , itemkey => p_itemKey
704: , aname => 'IRC_APPROVER'

Line 724: hr_utility.set_location('FND Message Name for Subject : ' || l_messageSubjectName,80);

720: end if;
721: end if;
722: end loop;
723:
724: hr_utility.set_location('FND Message Name for Subject : ' || l_messageSubjectName,80);
725: hr_utility.set_location('FND Message Name for Body : ' || l_htmlMessageName,90);
726: if l_messageSubjectName is null or l_htmlMessageName is null then
727: raise e_messageNameIsNull;
728: else

Line 725: hr_utility.set_location('FND Message Name for Body : ' || l_htmlMessageName,90);

721: end if;
722: end loop;
723:
724: hr_utility.set_location('FND Message Name for Subject : ' || l_messageSubjectName,80);
725: hr_utility.set_location('FND Message Name for Body : ' || l_htmlMessageName,90);
726: if l_messageSubjectName is null or l_htmlMessageName is null then
727: raise e_messageNameIsNull;
728: else
729: open get_nls_lang(userenv('LANG'));

Line 747: hr_utility.set_location('l_textMessageName: '||l_textMessageName,100);

743: close get_message_name;
744: if l_returned_messageName is null then
745: l_textMessageName := l_htmlMessageName;
746: end if;
747: hr_utility.set_location('l_textMessageName: '||l_textMessageName,100);
748:
749: fnd_message.set_name('PER',l_messageSubjectName);
750: l_messageSubject := parseAndReplaceFNDMessage( p_itemType => p_itemType
751: , p_itemKey => p_itemKey

Line 753: hr_utility.set_location('Message Subject sent to Recipient: '||l_messageSubject,120);

749: fnd_message.set_name('PER',l_messageSubjectName);
750: l_messageSubject := parseAndReplaceFNDMessage( p_itemType => p_itemType
751: , p_itemKey => p_itemKey
752: , p_message => fnd_message.get);
753: hr_utility.set_location('Message Subject sent to Recipient: '||l_messageSubject,120);
754: wf_engine.setItemAttrText ( itemtype => p_itemType
755: , itemkey => p_itemKey
756: , aname => 'IRC_MESSAGE_SUBJECT'
757: , avalue => l_messageSubject);

Line 775: hr_utility.set_location('Message Text Body sent to Recipient: '|| l_textMessageBody, 130);

771: l_textMessageBody := replace(l_textMessageBody,'','
772: ');
773: end if;
774:
775: hr_utility.set_location('Message Text Body sent to Recipient: '|| l_textMessageBody, 130);
776:
777: fnd_message.set_name('PER', l_htmlMessageName);
778: l_htmlMessageBody := parseAndReplaceFNDMessage( p_itemType => p_itemType
779: , p_itemKey => p_itemKey

Line 783: hr_utility.set_location('Message HTML Body sent to recipient: '|| l_htmlMessageBody, 150);

779: , p_itemKey => p_itemKey
780: , p_message => fnd_message.get
781: , p_personId => l_nextApprovers(1).orig_system_id
782: , p_personType => l_person_type);
783: hr_utility.set_location('Message HTML Body sent to recipient: '|| l_htmlMessageBody, 150);
784: wf_engine.setitemattrtext( itemtype => p_itemType
785: , itemkey => p_itemKey
786: , aname => 'IRC_MESSAGE_BODY'
787: , avalue => l_htmlMessageBody);

Line 807: hr_utility.set_location('Notification ID : ' || l_notificationId,180);

803: );
804: end if;
805:
806:
807: hr_utility.set_location('Notification ID : ' || l_notificationId,180);
808: wf_notification.setAttrText (l_notificationId, '#FROM_ROLE', 'SYSADMIN');
809: wf_notification.setAttrText(l_notificationId, 'SUBJECT', l_messageSubject);
810: wf_notification.setAttrText(l_notificationId, 'TEXT_BODY', l_textMessageBody);
811: wf_notification.setAttrText(l_notificationId, 'HTML_BODY', l_htmlMessageBody);

Line 823: hr_utility.set_location('Recipients Exist - Exiting:'|| g_package||'.'||l_proc, 200);

819: if l_dft_lang <> l_user_lang then
820: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
821: end if;
822: result := 'COMPLETE:IRC_E';
823: hr_utility.set_location('Recipients Exist - Exiting:'|| g_package||'.'||l_proc, 200);
824: end if;
825: else
826: hr_utility.set_location('No more Recipients - Exiting:'|| g_package||'.'||l_proc, 220);
827: result := 'COMPLETE:IRC_NE';

Line 826: hr_utility.set_location('No more Recipients - Exiting:'|| g_package||'.'||l_proc, 220);

822: result := 'COMPLETE:IRC_E';
823: hr_utility.set_location('Recipients Exist - Exiting:'|| g_package||'.'||l_proc, 200);
824: end if;
825: else
826: hr_utility.set_location('No more Recipients - Exiting:'|| g_package||'.'||l_proc, 220);
827: result := 'COMPLETE:IRC_NE';
828: end if;
829: else
830: hr_utility.set_location('Profile value for AME Transaction Type not set - Exiting :'|| g_package||'.'||l_proc, 240);

Line 830: hr_utility.set_location('Profile value for AME Transaction Type not set - Exiting :'|| g_package||'.'||l_proc, 240);

826: hr_utility.set_location('No more Recipients - Exiting:'|| g_package||'.'||l_proc, 220);
827: result := 'COMPLETE:IRC_NE';
828: end if;
829: else
830: hr_utility.set_location('Profile value for AME Transaction Type not set - Exiting :'|| g_package||'.'||l_proc, 240);
831: result := 'COMPLETE:IRC_NE';
832: end if;
833: exception
834: when e_ameException then

Line 835: hr_utility.set_location('AME Error - Exiting:'|| g_package||'.'||l_proc, 260);

831: result := 'COMPLETE:IRC_NE';
832: end if;
833: exception
834: when e_ameException then
835: hr_utility.set_location('AME Error - Exiting:'|| g_package||'.'||l_proc, 260);
836: hr_utility.set_location('Error Message:'|| SQLERRM, 270);
837: result := 'COMPLETE:IRC_NE';
838: when e_messageNameIsNull then
839: hr_utility.set_location('Error - Skipping'|| g_package||'.'||l_proc, 300);

Line 836: hr_utility.set_location('Error Message:'|| SQLERRM, 270);

832: end if;
833: exception
834: when e_ameException then
835: hr_utility.set_location('AME Error - Exiting:'|| g_package||'.'||l_proc, 260);
836: hr_utility.set_location('Error Message:'|| SQLERRM, 270);
837: result := 'COMPLETE:IRC_NE';
838: when e_messageNameIsNull then
839: hr_utility.set_location('Error - Skipping'|| g_package||'.'||l_proc, 300);
840: hr_utility.set_location('Error Message:'|| 'FND message not defined for this recipient', 310);

Line 839: hr_utility.set_location('Error - Skipping'|| g_package||'.'||l_proc, 300);

835: hr_utility.set_location('AME Error - Exiting:'|| g_package||'.'||l_proc, 260);
836: hr_utility.set_location('Error Message:'|| SQLERRM, 270);
837: result := 'COMPLETE:IRC_NE';
838: when e_messageNameIsNull then
839: hr_utility.set_location('Error - Skipping'|| g_package||'.'||l_proc, 300);
840: hr_utility.set_location('Error Message:'|| 'FND message not defined for this recipient', 310);
841: result := 'COMPLETE:IRC_E';
842: when others then
843: hr_utility.set_location('Error - Skipping:'|| g_package||'.'||l_proc, 350);

Line 840: hr_utility.set_location('Error Message:'|| 'FND message not defined for this recipient', 310);

836: hr_utility.set_location('Error Message:'|| SQLERRM, 270);
837: result := 'COMPLETE:IRC_NE';
838: when e_messageNameIsNull then
839: hr_utility.set_location('Error - Skipping'|| g_package||'.'||l_proc, 300);
840: hr_utility.set_location('Error Message:'|| 'FND message not defined for this recipient', 310);
841: result := 'COMPLETE:IRC_E';
842: when others then
843: hr_utility.set_location('Error - Skipping:'|| g_package||'.'||l_proc, 350);
844: hr_utility.set_location('Error Message:'|| SQLERRM, 360);

Line 843: hr_utility.set_location('Error - Skipping:'|| g_package||'.'||l_proc, 350);

839: hr_utility.set_location('Error - Skipping'|| g_package||'.'||l_proc, 300);
840: hr_utility.set_location('Error Message:'|| 'FND message not defined for this recipient', 310);
841: result := 'COMPLETE:IRC_E';
842: when others then
843: hr_utility.set_location('Error - Skipping:'|| g_package||'.'||l_proc, 350);
844: hr_utility.set_location('Error Message:'|| SQLERRM, 360);
845: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
846: result := 'COMPLETE:IRC_E';
847: end getNextRecipient;

Line 844: hr_utility.set_location('Error Message:'|| SQLERRM, 360);

840: hr_utility.set_location('Error Message:'|| 'FND message not defined for this recipient', 310);
841: result := 'COMPLETE:IRC_E';
842: when others then
843: hr_utility.set_location('Error - Skipping:'|| g_package||'.'||l_proc, 350);
844: hr_utility.set_location('Error Message:'|| SQLERRM, 360);
845: DBMS_SESSION.SET_NLS('NLS_LANGUAGE',l_dft_lang);
846: result := 'COMPLETE:IRC_E';
847: end getNextRecipient;
848: --+

Line 856: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

852: , p_WFAttr in varchar2 ) return varchar2 is
853: l_value varchar2(1000);
854: l_proc constant varchar2(50) := 'getWFAttrValue';
855: begin
856: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
857: g_WFItemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
858: hr_utility.set_location('Workflow Attribute : '|| p_WFAttr, 20);
859: l_value := wf_engine.getitemattrtext( itemtype => g_WFItemType
860: , itemkey => p_itemKey

Line 858: hr_utility.set_location('Workflow Attribute : '|| p_WFAttr, 20);

854: l_proc constant varchar2(50) := 'getWFAttrValue';
855: begin
856: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
857: g_WFItemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
858: hr_utility.set_location('Workflow Attribute : '|| p_WFAttr, 20);
859: l_value := wf_engine.getitemattrtext( itemtype => g_WFItemType
860: , itemkey => p_itemKey
861: , aname => p_WFAttr);
862: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 60);

Line 862: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 60);

858: hr_utility.set_location('Workflow Attribute : '|| p_WFAttr, 20);
859: l_value := wf_engine.getitemattrtext( itemtype => g_WFItemType
860: , itemkey => p_itemKey
861: , aname => p_WFAttr);
862: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 60);
863: return l_value;
864: exception
865: when others then
866: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);

Line 866: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);

862: hr_utility.set_location('Success - Exiting:'|| g_package||'.'||l_proc, 60);
863: return l_value;
864: exception
865: when others then
866: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);
867: hr_utility.set_location('Error Message : ' || sqlerrm, 110);
868: return null;
869: end getWFAttrValue;
870: --+

Line 867: hr_utility.set_location('Error Message : ' || sqlerrm, 110);

863: return l_value;
864: exception
865: when others then
866: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 100);
867: hr_utility.set_location('Error Message : ' || sqlerrm, 110);
868: return null;
869: end getWFAttrValue;
870: --+
871: --+ isValidRecipient

Line 887: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

883: l_orig_system_id number;
884: l_pos number;
885: l_proc constant varchar2(50) := 'isValidRecipient';
886: begin
887: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
888: l_pos:=instr(p_recipient,':');
889: l_orig_system:=substr(p_recipient,1,l_pos-1);
890: l_orig_system_id:=substr(p_recipient,l_pos+1,length(p_recipient));
891: open csrRoleExists(l_orig_system,l_orig_system_id);

Line 901: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 50);

897: return 'false';
898: end if;
899: exception
900: when others then
901: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 50);
902: hr_utility.set_location('Error Message : ' || sqlerrm, 60);
903: end isValidRecipient;
904:
905: function checkIfIntvwCandidateIncluded ( p_modifiedItemsString varchar2

Line 902: hr_utility.set_location('Error Message : ' || sqlerrm, 60);

898: end if;
899: exception
900: when others then
901: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 50);
902: hr_utility.set_location('Error Message : ' || sqlerrm, 60);
903: end isValidRecipient;
904:
905: function checkIfIntvwCandidateIncluded ( p_modifiedItemsString varchar2
906: , p_eventName varchar2)

Line 925: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

921: OR instr(c_modifiedItemsString,',STATUS,')>0;
922: l_includeCandidate varchar2(10);
923: l_proc constant varchar2(50) := 'checkIfIntvwCandidateIncluded';
924: begin
925: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
926: if p_eventName = 'INTVCRE' then
927: l_includeCandidate := 'true';
928: else
929: open csrCheckModifiedItems(',' || p_modifiedItemsString || ',');

Line 939: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 50);

935: end if;
936: return l_includeCandidate;
937: exception
938: when others then
939: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 50);
940: hr_utility.set_location('Error Message : ' || sqlerrm, 60);
941: end checkIfIntvwCandidateIncluded;
942:
943: procedure getDocument (p_documentId in varchar2

Line 940: hr_utility.set_location('Error Message : ' || sqlerrm, 60);

936: return l_includeCandidate;
937: exception
938: when others then
939: hr_utility.set_location('Error - Exiting:'|| g_package||'.'||l_proc, 50);
940: hr_utility.set_location('Error Message : ' || sqlerrm, 60);
941: end checkIfIntvwCandidateIncluded;
942:
943: procedure getDocument (p_documentId in varchar2
944: ,p_displayType in varchar2

Line 977: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);

973: from fnd_timezones_vl
974: where name = c_timezoneNameIn
975: and rownum < 2;
976: begin
977: hr_utility.set_location('Entering:'|| g_package||'.'||l_proc, 10);
978: l_itemType := fnd_profile.value('IRC_NTF_WF_ITEM_TYPE');
979: l_position := instrb(document_id,':',1,1);
980: -- heredocumentid represent the item key and notification_id, which is used to get the required values
981: if l_position is null then

Line 987: hr_utility.set_location('getting the interview details', 20);

983: else
984: l_item_key := substr(document_id,1,l_position-1);
985: l_notification_id := to_number(substr(document_id,l_position+1,length(document_id)));
986: end if;
987: hr_utility.set_location('getting the interview details', 20);
988: l_start_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_START');
989: l_end_date := wf_engine.GetItemAttrDate ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_DATE_END');
990: l_start_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_START',ignore_notfound=>true);
991: l_end_time := wf_engine.getItemAttrText ( itemtype => l_itemType, itemkey => l_item_key,aname => 'IRC_INTVW_TIME_END',ignore_notfound=>true);

Line 1006: hr_utility.set_location('Contructing the ics file', 20);

1002: end if;
1003: end if;
1004: l_subject := wf_notification.GetAttrText (nid => l_notification_id, aname => 'SUBJECT',ignore_notfound => true);
1005: --l_description := wf_notification.GetAttrText (nid => l_notification_id, aname => 'TEXT_BODY',ignore_notfound => true);
1006: hr_utility.set_location('Contructing the ics file', 20);
1007: per_calendar_util.calendar_generate_ical
1008: (DTSTARTDATE => l_start_date
1009: ,DTENDDATE => l_end_date
1010: ,DTSTARTTIME => l_start_time

Line 1021: hr_utility.set_location('completed:'|| g_package||'.'||l_proc, 30);

1017: ,ICAL => l_data
1018: );
1019: document := to_blob(UTL_RAW.CAST_TO_RAW(l_data));
1020: document_type := 'text/calendar' || ';name=event.ics';
1021: hr_utility.set_location('completed:'|| g_package||'.'||l_proc, 30);
1022: exception
1023: when others then
1024: hr_utility.set_location('Error:'|| g_package||'.'||l_proc, 50);
1025: hr_utility.set_location('Error:'|| sqlerrm, 50);

Line 1024: hr_utility.set_location('Error:'|| g_package||'.'||l_proc, 50);

1020: document_type := 'text/calendar' || ';name=event.ics';
1021: hr_utility.set_location('completed:'|| g_package||'.'||l_proc, 30);
1022: exception
1023: when others then
1024: hr_utility.set_location('Error:'|| g_package||'.'||l_proc, 50);
1025: hr_utility.set_location('Error:'|| sqlerrm, 50);
1026: end attatchICDoc;
1027: --+
1028: end IRC_NOTIFICATION_WORKFLOW_PKG;

Line 1025: hr_utility.set_location('Error:'|| sqlerrm, 50);

1021: hr_utility.set_location('completed:'|| g_package||'.'||l_proc, 30);
1022: exception
1023: when others then
1024: hr_utility.set_location('Error:'|| g_package||'.'||l_proc, 50);
1025: hr_utility.set_location('Error:'|| sqlerrm, 50);
1026: end attatchICDoc;
1027: --+
1028: end IRC_NOTIFICATION_WORKFLOW_PKG;