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

Line 19: g_debug := hr_utility.debug_enabled;

15: IS
16: c_proc constant varchar2(30) := 'getStartDate';
17: lv_startDate hr_api_transaction_steps.Information1%type;
18: begin
19: g_debug := hr_utility.debug_enabled;
20: if g_debug then
21: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
22: end if;
23:

Line 21: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

17: lv_startDate hr_api_transaction_steps.Information1%type;
18: begin
19: g_debug := hr_utility.debug_enabled;
20: if g_debug then
21: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
22: end if;
23:
24: if(p_transaction_id is not null) then
25: begin

Line 43: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

39: else
40: return null;
41: end if;
42: if g_debug then
43: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
44: end if;
45:
46: exception
47: when others then

Line 48: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

44: end if;
45:
46: exception
47: when others then
48: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
49: Wf_Core.Context(g_package, c_proc, p_transaction_id);
50: -- raise;
51: return null;
52: end getStartDate;

Line 61: g_debug := hr_utility.debug_enabled;

57: IS
58: c_proc constant varchar2(30) := 'getEndDate';
59: lv_EndDate hr_api_transaction_steps.Information1%type;
60: begin
61: g_debug := hr_utility.debug_enabled;
62: if g_debug then
63: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
64: end if;
65: if(p_transaction_id is not null) then

Line 63: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

59: lv_EndDate hr_api_transaction_steps.Information1%type;
60: begin
61: g_debug := hr_utility.debug_enabled;
62: if g_debug then
63: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
64: end if;
65: if(p_transaction_id is not null) then
66: begin
67: select nvl(Information2,Information4)

Line 85: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

81: return null;
82: end if;
83:
84: if g_debug then
85: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
86: end if;
87:
88: exception
89: when others then

Line 90: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

86: end if;
87:
88: exception
89: when others then
90: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
91: Wf_Core.Context(g_package, c_proc, p_transaction_id);
92: -- raise;
93: return null;
94: end getEndDate;

Line 104: g_debug := hr_utility.debug_enabled;

100: c_proc constant varchar2(30) := 'getAbsenceType';
101: lv_AbsenceTypeId PER_ABSENCE_ATTENDANCE_TYPES.absence_attendance_type_id%type;
102: lv_AbsenceType PER_ABSENCE_ATTENDANCE_TYPES.name%type;
103: begin
104: g_debug := hr_utility.debug_enabled;
105: if g_debug then
106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
107: end if;
108: -- hr_general.decode_lookup('ABSENCE_CATEGORY',hats.Information4)

Line 106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

102: lv_AbsenceType PER_ABSENCE_ATTENDANCE_TYPES.name%type;
103: begin
104: g_debug := hr_utility.debug_enabled;
105: if g_debug then
106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
107: end if;
108: -- hr_general.decode_lookup('ABSENCE_CATEGORY',hats.Information4)
109: if(p_transaction_id is not null) then
110: begin

Line 138: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

134:
135: return lv_AbsenceType;
136:
137: if g_debug then
138: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
139: end if;
140:
141: exception
142: when others then

Line 143: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

139: end if;
140:
141: exception
142: when others then
143: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
144: Wf_Core.Context(g_package, c_proc, p_transaction_id);
145: raise;
146: end getAbsenceType;
147:

Line 157: g_debug := hr_utility.debug_enabled;

153: IS
154: c_proc constant varchar2(30) := 'getAbsenceCategory';
155: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;
156: begin
157: g_debug := hr_utility.debug_enabled;
158: if g_debug then
159: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
160: end if;
161:

Line 159: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

155: lv_AbsenceCategory hr_api_transaction_steps.Information6%type;
156: begin
157: g_debug := hr_utility.debug_enabled;
158: if g_debug then
159: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
160: end if;
161:
162: /*and paat.absence_attendance_type_id =FND_NUMBER.canonical_to_number(nvl(hats.Information3,'0'))
163: and fcl.lookup_type(+) = 'ABSENCE_CATEGORY'

Line 186: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

182: end;
183: end if;
184: return lv_AbsenceCategory;
185: if g_debug then
186: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
187: end if;
188:
189: exception
190: when others then

Line 191: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

187: end if;
188:
189: exception
190: when others then
191: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
192: Wf_Core.Context(g_package, c_proc, p_transaction_id);
193: raise;
194: end getAbsenceCategory;
195:

Line 209: g_debug := hr_utility.debug_enabled;

205:
206: Cursor c_lookup_code(AbsenceCat varchar2) is select LOOKUP_CODE from fnd_lookup_values flv
207: where flv.MEANING = AbsenceCat and flv.lookup_type = 'ABSENCE_CATEGORY';
208: begin
209: g_debug := hr_utility.debug_enabled;
210: if g_debug then
211: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
212: end if;
213:

Line 211: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

207: where flv.MEANING = AbsenceCat and flv.lookup_type = 'ABSENCE_CATEGORY';
208: begin
209: g_debug := hr_utility.debug_enabled;
210: if g_debug then
211: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
212: end if;
213:
214: if(p_transaction_id is not null) then
215: begin

Line 231: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

227: fetch c_lookup_code into l_lookup_code_val;
228: close c_lookup_code;
229:
230: if g_debug then
231: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
232: end if;
233: return l_lookup_code_val;
234: exception
235: when others then

Line 236: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

232: end if;
233: return l_lookup_code_val;
234: exception
235: when others then
236: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
237: Wf_Core.Context(g_package, c_proc, p_transaction_id);
238: raise;
239: end getAbsenceCategoryCode;
240:

Line 249: g_debug := hr_utility.debug_enabled;

245: IS
246: c_proc constant varchar2(30) := 'getAbsenceHoursDuration';
247: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;
248: begin
249: g_debug := hr_utility.debug_enabled;
250: if g_debug then
251: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
252: end if;
253: if(p_transaction_id is not null) then

Line 251: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

247: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;
248: begin
249: g_debug := hr_utility.debug_enabled;
250: if g_debug then
251: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
252: end if;
253: if(p_transaction_id is not null) then
254: begin
255: select Information7

Line 268: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

264: -- Fix for bug 7712861
265: return fnd_number.canonical_to_number(lv_AbsenceHoursDuration);
266:
267: if g_debug then
268: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
269: end if;
270:
271: exception
272: when others then

Line 273: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

269: end if;
270:
271: exception
272: when others then
273: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
274: Wf_Core.Context(g_package, c_proc, p_transaction_id);
275: raise;
276: end getAbsenceHoursDuration;
277:

Line 286: g_debug := hr_utility.debug_enabled;

282: IS
283: c_proc constant varchar2(30) := 'getAbsenceDaysDuration';
284: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;
285: begin
286: g_debug := hr_utility.debug_enabled;
287: if g_debug then
288: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
289: end if;
290: if(p_transaction_id is not null) then

Line 288: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

284: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;
285: begin
286: g_debug := hr_utility.debug_enabled;
287: if g_debug then
288: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
289: end if;
290: if(p_transaction_id is not null) then
291: begin
292: select Information8

Line 306: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

302: return fnd_number.canonical_to_number(lv_AbsenceDaysDuration);
303:
304:
305: if g_debug then
306: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
307: end if;
308:
309: exception
310: when others then

Line 311: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

307: end if;
308:
309: exception
310: when others then
311: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
312: Wf_Core.Context(g_package, c_proc, p_transaction_id);
313: raise;
314: end getAbsenceDaysDuration;
315:

Line 325: g_debug := hr_utility.debug_enabled;

321: IS
322: c_proc constant varchar2(30) := 'getApprovalStatus';
323: lv_approvalStatus fnd_lookup_values.meaning%type;
324: begin
325: g_debug := hr_utility.debug_enabled;
326: if g_debug then
327: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
328: end if;
329: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

Line 327: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

323: lv_approvalStatus fnd_lookup_values.meaning%type;
324: begin
325: g_debug := hr_utility.debug_enabled;
326: if g_debug then
327: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
328: end if;
329: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
330: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
331: hrl.meaning)*/

Line 352: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

348: end if;
349: return lv_approvalStatus;
350:
351: if g_debug then
352: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
353: end if;
354:
355: exception
356: when others then

Line 357: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

353: end if;
354:
355: exception
356: when others then
357: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
358: Wf_Core.Context(g_package, c_proc, p_transaction_id);
359: raise;
360: end getApprovalStatus;
361:

Line 370: g_debug := hr_utility.debug_enabled;

366: IS
367: c_proc constant varchar2(30) := 'getApprovalStatusCode';
368: lv_approvalStatusCode varchar2(30);
369: begin
370: g_debug := hr_utility.debug_enabled;
371: if g_debug then
372: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
373: end if;
374: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

Line 372: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

368: lv_approvalStatusCode varchar2(30);
369: begin
370: g_debug := hr_utility.debug_enabled;
371: if g_debug then
372: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
373: end if;
374: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
375: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
376: hrl.meaning)*/

Line 397: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

393: end if;
394: return lv_approvalStatusCode;
395:
396: if g_debug then
397: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
398: end if;
399:
400: exception
401: when others then

Line 402: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

398: end if;
399:
400: exception
401: when others then
402: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
403: Wf_Core.Context(g_package, c_proc, p_transaction_id);
404: raise;
405: end getApprovalStatusCode;
406:

Line 415: g_debug := hr_utility.debug_enabled;

411: IS
412: c_proc constant varchar2(30) := 'getAbsenceStatus';
413: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
414: begin
415: g_debug := hr_utility.debug_enabled;
416: if g_debug then
417: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
418: end if;
419: if(p_transaction_id is not null) then

Line 417: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

413: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
414: begin
415: g_debug := hr_utility.debug_enabled;
416: if g_debug then
417: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
418: end if;
419: if(p_transaction_id is not null) then
420: begin
421: select (SELECT meaning

Line 438: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

434: end if;
435: return lv_AbsenceStatus;
436:
437: if g_debug then
438: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
439: end if;
440:
441: exception
442: when others then

Line 443: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

439: end if;
440:
441: exception
442: when others then
443: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
444: Wf_Core.Context(g_package, c_proc, p_transaction_id);
445: raise;
446: end getAbsenceStatus;
447:

Line 456: g_debug := hr_utility.debug_enabled;

452: IS
453: c_proc constant varchar2(30) := 'isUpdateAllowed';
454: lv_UpdateAllowed varchar2(30);
455: begin
456: g_debug := hr_utility.debug_enabled;
457: if g_debug then
458: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
459: end if;
460: /*

Line 458: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

454: lv_UpdateAllowed varchar2(30);
455: begin
456: g_debug := hr_utility.debug_enabled;
457: if g_debug then
458: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
459: end if;
460: /*
461: decode (hat.status,'W', 'HrUpdateEnabled',
462: 'S','HrUpdateEnabled',

Line 483: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

479:
480: return lv_UpdateAllowed;
481:
482: if g_debug then
483: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
484: end if;
485:
486: exception
487: when others then

Line 488: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

484: end if;
485:
486: exception
487: when others then
488: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
489: Wf_Core.Context(g_package, c_proc, p_transaction_id);
490: raise;
491: end isUpdateAllowed;
492:

Line 501: g_debug := hr_utility.debug_enabled;

497: c_proc constant varchar2(30) := 'isConfirmAllowed';
498: lv_item_type wf_item_activity_statuses.item_type%type;
499: lv_item_key wf_item_activity_statuses.item_key%type;
500: begin
501: g_debug := hr_utility.debug_enabled;
502: if g_debug then
503: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
504: end if;
505:

Line 503: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

499: lv_item_key wf_item_activity_statuses.item_key%type;
500: begin
501: g_debug := hr_utility.debug_enabled;
502: if g_debug then
503: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
504: end if;
505:
506: return 'HrConfirmDisabled';
507:

Line 509: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

505:
506: return 'HrConfirmDisabled';
507:
508: if g_debug then
509: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
510: end if;
511:
512: exception
513: when others then

Line 514: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

510: end if;
511:
512: exception
513: when others then
514: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
515: Wf_Core.Context(g_package, c_proc, p_transaction_id);
516: raise;
517: end isConfirmAllowed;
518:

Line 528: g_debug := hr_utility.debug_enabled;

524: IS
525: c_proc constant varchar2(30) := 'isCancelAllowed';
526: lv_CancelAllowed varchar2(30);
527: begin
528: g_debug := hr_utility.debug_enabled;
529: if g_debug then
530: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
531: end if;
532: /*decode(hat.status,'W','HrCancelEnabled',

Line 530: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

526: lv_CancelAllowed varchar2(30);
527: begin
528: g_debug := hr_utility.debug_enabled;
529: if g_debug then
530: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
531: end if;
532: /*decode(hat.status,'W','HrCancelEnabled',
533: 'S','HrCancelEnabled',
534: 'RI','HrCancelEnabled',

Line 548: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

544:
545: return lv_CancelAllowed;
546:
547: if g_debug then
548: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
549: end if;
550:
551: exception
552: when others then

Line 553: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

549: end if;
550:
551: exception
552: when others then
553: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
554: Wf_Core.Context(g_package, c_proc, p_transaction_id);
555: raise;
556: end isCancelAllowed;
557:

Line 570: g_debug := hr_utility.debug_enabled;

566: lv_pkey1 fnd_attached_documents.pk1_value%type;
567: l_exists VARCHAR2(1);
568:
569: begin
570: g_debug := hr_utility.debug_enabled;
571: if g_debug then
572: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
573: end if;
574:

Line 572: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

568:
569: begin
570: g_debug := hr_utility.debug_enabled;
571: if g_debug then
572: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
573: end if;
574:
575: if(p_transaction_id is not null) then
576: lv_pkey1 :=p_absence_attendance_id||'_'||p_transaction_id;

Line 600: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

596: return('Y');
597: END IF;
598:
599: if g_debug then
600: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
601: end if;
602:
603: exception
604: when others then

Line 605: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

601: end if;
602:
603: exception
604: when others then
605: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
606: Wf_Core.Context(g_package, c_proc, p_transaction_id);
607: raise;
608: end hasSupportingDocuments;
609:

Line 622: g_debug := hr_utility.debug_enabled;

618: lv_item_key wf_item_activity_statuses.item_key%type;
619: lv_status hr_api_transactions.status%type;
620: ln_notification_id wf_notifications.notification_id%type;
621: begin
622: g_debug := hr_utility.debug_enabled;
623: if g_debug then
624: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
625: end if;
626:

Line 624: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

620: ln_notification_id wf_notifications.notification_id%type;
621: begin
622: g_debug := hr_utility.debug_enabled;
623: if g_debug then
624: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
625: end if;
626:
627: begin
628: select status,item_type,item_key

Line 673: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

669: p_notification_subject:= wf_notification.getsubject(ln_notification_id);
670: end if;
671:
672: if g_debug then
673: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
674: end if;
675:
676: exception
677: when others then

Line 678: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

674: end if;
675:
676: exception
677: when others then
678: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
679: Wf_Core.Context(g_package, c_proc, p_transaction_id);
680: raise;
681: end getAbsenceNotificationDetails;
682:

Line 705: g_debug := hr_utility.debug_enabled;

701:
702:
703: begin
704:
705: g_debug := hr_utility.debug_enabled;
706: if g_debug then
707: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
708: end if;
709:

Line 707: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

703: begin
704:
705: g_debug := hr_utility.debug_enabled;
706: if g_debug then
707: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
708: end if;
709:
710: hr_loa_ss.calculate_absence_duration
711: (p_absence_attendance_type_id

Line 757: g_debug := hr_utility.debug_enabled;

753: p_warning_or_error varchar2(1);
754: p_page_error_msg fnd_new_messages.message_text%TYPE;
755:
756: Begin
757: g_debug := hr_utility.debug_enabled;
758: if g_debug then
759: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
760: end if;
761:

Line 759: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

755:
756: Begin
757: g_debug := hr_utility.debug_enabled;
758: if g_debug then
759: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
760: end if;
761:
762: hr_loa_ss.calculate_absence_duration
763: (p_absence_attendance_type_id

Line 794: g_debug := hr_utility.debug_enabled;

790: IS
791: c_proc constant varchar2(30) := 'getAbsenceStatusValue';
792: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
793: begin
794: g_debug := hr_utility.debug_enabled;
795: if g_debug then
796: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
797: end if;
798: if(p_transaction_id is not null) then

Line 796: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

792: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
793: begin
794: g_debug := hr_utility.debug_enabled;
795: if g_debug then
796: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
797: end if;
798: if(p_transaction_id is not null) then
799: begin
800: select (SELECT meaning

Line 817: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);

813: end if;
814: return lv_AbsenceStatus;
815:
816: if g_debug then
817: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
818: end if;
819:
820: exception
821: when others then

Line 822: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);

818: end if;
819:
820: exception
821: when others then
822: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
823: Wf_Core.Context(g_package, c_proc, p_transaction_id);
824: raise;
825: end getAbsenceStatusValue;
826: