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 203: g_debug := hr_utility.debug_enabled;

199: IS
200: c_proc constant varchar2(30) := 'getAbsenceHoursDuration';
201: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;
202: begin
203: g_debug := hr_utility.debug_enabled;
204: if g_debug then
205: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
206: end if;
207: if(p_transaction_id is not null) then

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

201: lv_AbsenceHoursDuration hr_api_transaction_steps.Information7%type;
202: begin
203: g_debug := hr_utility.debug_enabled;
204: if g_debug then
205: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
206: end if;
207: if(p_transaction_id is not null) then
208: begin
209: select Information7

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

217: end if;
218: return fnd_number.number_to_canonical(nvl(lv_AbsenceHoursDuration,0));
219:
220: if g_debug then
221: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
222: end if;
223:
224: exception
225: when others then

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

222: end if;
223:
224: exception
225: when others then
226: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
227: Wf_Core.Context(g_package, c_proc, p_transaction_id);
228: raise;
229: end getAbsenceHoursDuration;
230:

Line 239: g_debug := hr_utility.debug_enabled;

235: IS
236: c_proc constant varchar2(30) := 'getAbsenceDaysDuration';
237: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;
238: begin
239: g_debug := hr_utility.debug_enabled;
240: if g_debug then
241: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
242: end if;
243: if(p_transaction_id is not null) then

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

237: lv_AbsenceDaysDuration hr_api_transaction_steps.Information8%type;
238: begin
239: g_debug := hr_utility.debug_enabled;
240: if g_debug then
241: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
242: end if;
243: if(p_transaction_id is not null) then
244: begin
245: select Information8

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

253: end if;
254: return lv_AbsenceDaysDuration;
255:
256: if g_debug then
257: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
258: end if;
259:
260: exception
261: when others then

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

258: end if;
259:
260: exception
261: when others then
262: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
263: Wf_Core.Context(g_package, c_proc, p_transaction_id);
264: raise;
265: end getAbsenceDaysDuration;
266:

Line 276: g_debug := hr_utility.debug_enabled;

272: IS
273: c_proc constant varchar2(30) := 'getApprovalStatus';
274: lv_approvalStatus fnd_lookup_values.meaning%type;
275: begin
276: g_debug := hr_utility.debug_enabled;
277: if g_debug then
278: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
279: end if;
280: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

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

274: lv_approvalStatus fnd_lookup_values.meaning%type;
275: begin
276: g_debug := hr_utility.debug_enabled;
277: if g_debug then
278: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
279: end if;
280: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
281: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
282: hrl.meaning)*/

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

299: end if;
300: return lv_approvalStatus;
301:
302: if g_debug then
303: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
304: end if;
305:
306: exception
307: when others then

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

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

Line 321: g_debug := hr_utility.debug_enabled;

317: IS
318: c_proc constant varchar2(30) := 'getApprovalStatusCode';
319: lv_approvalStatusCode varchar2(30);
320: begin
321: g_debug := hr_utility.debug_enabled;
322: if g_debug then
323: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
324: end if;
325: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),

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

319: lv_approvalStatusCode varchar2(30);
320: begin
321: g_debug := hr_utility.debug_enabled;
322: if g_debug then
323: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
324: end if;
325: /*decode(hat.status,'RI',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
326: 'RO',hr_general.decode_lookup('PQH_SS_TRANSACTION_STATUS','C'),
327: hrl.meaning)*/

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

344: end if;
345: return lv_approvalStatusCode;
346:
347: if g_debug then
348: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
349: end if;
350:
351: exception
352: when others then

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

349: end if;
350:
351: exception
352: when others then
353: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
354: Wf_Core.Context(g_package, c_proc, p_transaction_id);
355: raise;
356: end getApprovalStatusCode;
357:

Line 366: g_debug := hr_utility.debug_enabled;

362: IS
363: c_proc constant varchar2(30) := 'getAbsenceStatus';
364: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
365: begin
366: g_debug := hr_utility.debug_enabled;
367: if g_debug then
368: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
369: end if;
370: if(p_transaction_id is not null) then

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

364: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
365: begin
366: g_debug := hr_utility.debug_enabled;
367: if g_debug then
368: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
369: end if;
370: if(p_transaction_id is not null) then
371: begin
372: select (SELECT meaning

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

385: end if;
386: return lv_AbsenceStatus;
387:
388: if g_debug then
389: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
390: end if;
391:
392: exception
393: when others then

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

390: end if;
391:
392: exception
393: when others then
394: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
395: Wf_Core.Context(g_package, c_proc, p_transaction_id);
396: raise;
397: end getAbsenceStatus;
398:

Line 407: g_debug := hr_utility.debug_enabled;

403: IS
404: c_proc constant varchar2(30) := 'isUpdateAllowed';
405: lv_UpdateAllowed varchar2(30);
406: begin
407: g_debug := hr_utility.debug_enabled;
408: if g_debug then
409: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
410: end if;
411: /*

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

405: lv_UpdateAllowed varchar2(30);
406: begin
407: g_debug := hr_utility.debug_enabled;
408: if g_debug then
409: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
410: end if;
411: /*
412: decode (hat.status,'W', 'HrUpdateEnabled',
413: 'S','HrUpdateEnabled',

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

430:
431: return lv_UpdateAllowed;
432:
433: if g_debug then
434: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
435: end if;
436:
437: exception
438: when others then

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

435: end if;
436:
437: exception
438: when others then
439: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
440: Wf_Core.Context(g_package, c_proc, p_transaction_id);
441: raise;
442: end isUpdateAllowed;
443:

Line 452: g_debug := hr_utility.debug_enabled;

448: c_proc constant varchar2(30) := 'isConfirmAllowed';
449: lv_item_type wf_item_activity_statuses.item_type%type;
450: lv_item_key wf_item_activity_statuses.item_key%type;
451: begin
452: g_debug := hr_utility.debug_enabled;
453: if g_debug then
454: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
455: end if;
456:

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

450: lv_item_key wf_item_activity_statuses.item_key%type;
451: begin
452: g_debug := hr_utility.debug_enabled;
453: if g_debug then
454: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
455: end if;
456:
457: return 'HrConfirmDisabled';
458:

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

456:
457: return 'HrConfirmDisabled';
458:
459: if g_debug then
460: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
461: end if;
462:
463: exception
464: when others then

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

461: end if;
462:
463: exception
464: when others then
465: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
466: Wf_Core.Context(g_package, c_proc, p_transaction_id);
467: raise;
468: end isConfirmAllowed;
469:

Line 479: g_debug := hr_utility.debug_enabled;

475: IS
476: c_proc constant varchar2(30) := 'isCancelAllowed';
477: lv_CancelAllowed varchar2(30);
478: begin
479: g_debug := hr_utility.debug_enabled;
480: if g_debug then
481: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
482: end if;
483: /*decode(hat.status,'W','HrCancelEnabled',

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

477: lv_CancelAllowed varchar2(30);
478: begin
479: g_debug := hr_utility.debug_enabled;
480: if g_debug then
481: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
482: end if;
483: /*decode(hat.status,'W','HrCancelEnabled',
484: 'S','HrCancelEnabled',
485: 'RI','HrCancelEnabled',

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

495:
496: return lv_CancelAllowed;
497:
498: if g_debug then
499: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
500: end if;
501:
502: exception
503: when others then

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

500: end if;
501:
502: exception
503: when others then
504: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
505: Wf_Core.Context(g_package, c_proc, p_transaction_id);
506: raise;
507: end isCancelAllowed;
508:

Line 521: g_debug := hr_utility.debug_enabled;

517: lv_pkey1 fnd_attached_documents.pk1_value%type;
518: l_exists VARCHAR2(1);
519:
520: begin
521: g_debug := hr_utility.debug_enabled;
522: if g_debug then
523: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
524: end if;
525:

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

519:
520: begin
521: g_debug := hr_utility.debug_enabled;
522: if g_debug then
523: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
524: end if;
525:
526: if(p_transaction_id is not null) then
527: lv_pkey1 :=p_absence_attendance_id||'_'||p_transaction_id;

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

547: return('Y');
548: END IF;
549:
550: if g_debug then
551: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
552: end if;
553:
554: exception
555: when others then

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

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

Line 573: g_debug := hr_utility.debug_enabled;

569: lv_item_key wf_item_activity_statuses.item_key%type;
570: lv_status hr_api_transactions.status%type;
571: ln_notification_id wf_notifications.notification_id%type;
572: begin
573: g_debug := hr_utility.debug_enabled;
574: if g_debug then
575: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
576: end if;
577:

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

571: ln_notification_id wf_notifications.notification_id%type;
572: begin
573: g_debug := hr_utility.debug_enabled;
574: if g_debug then
575: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
576: end if;
577:
578: begin
579: select status,item_type,item_key

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

620: p_notification_subject:= wf_notification.getsubject(ln_notification_id);
621: end if;
622:
623: if g_debug then
624: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
625: end if;
626:
627: exception
628: when others then

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

625: end if;
626:
627: exception
628: when others then
629: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
630: Wf_Core.Context(g_package, c_proc, p_transaction_id);
631: raise;
632: end getAbsenceNotificationDetails;
633:

Line 656: g_debug := hr_utility.debug_enabled;

652:
653:
654: begin
655:
656: g_debug := hr_utility.debug_enabled;
657: if g_debug then
658: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
659: end if;
660:

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

654: begin
655:
656: g_debug := hr_utility.debug_enabled;
657: if g_debug then
658: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
659: end if;
660:
661: hr_loa_ss.calculate_absence_duration
662: (p_absence_attendance_type_id

Line 708: g_debug := hr_utility.debug_enabled;

704: p_warning_or_error varchar2(1);
705: p_page_error_msg fnd_new_messages.message_text%TYPE;
706:
707: Begin
708: g_debug := hr_utility.debug_enabled;
709: if g_debug then
710: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
711: end if;
712:

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

706:
707: Begin
708: g_debug := hr_utility.debug_enabled;
709: if g_debug then
710: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
711: end if;
712:
713: hr_loa_ss.calculate_absence_duration
714: (p_absence_attendance_type_id

Line 745: g_debug := hr_utility.debug_enabled;

741: IS
742: c_proc constant varchar2(30) := 'getAbsenceStatusValue';
743: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
744: begin
745: g_debug := hr_utility.debug_enabled;
746: if g_debug then
747: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
748: end if;
749: if(p_transaction_id is not null) then

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

743: lv_AbsenceStatus hr_api_transaction_steps.Information9%type;
744: begin
745: g_debug := hr_utility.debug_enabled;
746: if g_debug then
747: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
748: end if;
749: if(p_transaction_id is not null) then
750: begin
751: select (SELECT meaning

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

764: end if;
765: return lv_AbsenceStatus;
766:
767: if g_debug then
768: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 30);
769: end if;
770:
771: exception
772: when others then

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

769: end if;
770:
771: exception
772: when others then
773: hr_utility.set_location(g_package||c_proc|| 'errored : '||SQLERRM ||' '||to_char(SQLCODE), 30);
774: Wf_Core.Context(g_package, c_proc, p_transaction_id);
775: raise;
776: end getAbsenceStatusValue;
777: