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

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: package body hxc_timecard_approval as
2: /* $Header: hxctimeapprove.pkb 120.8.12010000.5 2009/10/05 12:09:47 amakrish ship $ */
3:
4: g_package varchar2(30) := 'hxc_timecard_approval.';
5: g_debug boolean := hr_utility.debug_enabled;
6:
7: TYPE application_period_table IS TABLE OF hxc_app_period_summary.APPLICATION_PERIOD_ID%TYPE;
8: TYPE tc_ap_links IS RECORD
9: (TIMECARD_ID hxc_tc_ap_links.TIMECARD_ID%TYPE,

Line 218: hr_utility.set_location('Processing '||l_proc, 10);

214:
215: Begin
216: if g_debug then
217: l_proc := g_package||'light_approve_timecards';
218: hr_utility.set_location('Processing '||l_proc, 10);
219: end if;
220:
221: l_timecard_type := p_timecard_info.TYPE;
222: l_timecard_start_time := p_timecard_info.START_TIME;

Line 237: hr_utility.set_location('Processing '||l_proc, 20);

233: * generated, if any should be CANCELLED. */
234:
235:
236: if g_debug then
237: hr_utility.set_location('Processing '||l_proc, 20);
238: end if;
239:
240: hxc_find_notify_aprs_pkg.cancel_previous_notifications
241: (p_timecard_id => p_tc_bb_id);

Line 257: hr_utility.set_location('Processing '||l_proc, 30);

253: if l_appl_recipients.count > 0 then
254: /* Loop through all the recipient applications */
255: for l_index IN l_appl_recipients.first .. l_appl_recipients.last LOOP
256: if g_debug then
257: hr_utility.set_location('Processing '||l_proc, 30);
258: end if;
259: l_period_start_date := l_timecard_start_time;
260: l_period_end_date := l_timecard_stop_time;
261: /* Get any existing Application period for the same resource_id, recipient_id, start and stop time */

Line 274: hr_utility.set_location('Processing '||l_proc, 40);

270: close c_app_period;
271:
272: if l_app_period_info.count > 0 then
273: if g_debug then
274: hr_utility.set_location('Processing '||l_proc, 40);
275: end if;
276:
277: for l_dup_index IN l_app_period_info.first .. l_app_period_info.last loop
278: if g_debug then

Line 279: hr_utility.set_location('Processing '||l_proc, 50);

275: end if;
276:
277: for l_dup_index IN l_app_period_info.first .. l_app_period_info.last loop
278: if g_debug then
279: hr_utility.set_location('Processing '||l_proc, 50);
280: end if;
281: /* Remove the existing record from hxc_ap_detail_links table */
282: hxc_ap_detail_links_pkg.delete_ap_detail_links(p_application_period_id => l_app_period_info(l_dup_index));
283: /* Remove the record from hxc_app_period_summary table */

Line 291: hr_utility.set_location('Processing '||l_proc, 60);

287: end loop;
288:
289: else
290: if g_debug then
291: hr_utility.set_location('Processing '||l_proc, 60);
292: end if;
293: fnd_message.set_name('HXC', 'HXC_APR_NO_APPL_SET_PREF');
294: fnd_message.raise_error;
295: end if;

Line 313: hr_utility.set_location('Processing '||l_proc, 70);

309: l_index_2 := 1;
310: loop
311: EXIT WHEN NOT l_detail_blocks.exists(l_index_1);
312: if g_debug then
313: hr_utility.set_location('Processing '||l_proc, 70);
314: end if;
315: l_detail_array.TIME_BUILDING_BLOCK_ID(l_index_2) := p_blocks(l_detail_blocks(l_index_1)).time_building_block_id ;
316: l_detail_array.TIME_BUILDING_BLOCK_OVN(l_index_2) := p_blocks(l_detail_blocks(l_index_1)).object_version_number ;
317: l_index_2 := l_index_2 + 1;

Line 321: hr_utility.set_location('Processing '||l_proc, 80);

317: l_index_2 := l_index_2 + 1;
318: l_index_1 := l_detail_blocks.next(l_index_1);
319: end loop;
320: if g_debug then
321: hr_utility.set_location('Processing '||l_proc, 80);
322: end if;
323:
324: for l_index IN l_appl_recipients.first .. l_appl_recipients.last LOOP
325: /* Call to create an Application period in hxc_time_building blocks table */

Line 330: hr_utility.set_location('Processing '||l_proc, 90);

326: l_time_building_block_id := null;
327: l_object_version_number := null;
328:
329: if g_debug then
330: hr_utility.set_location('Processing '||l_proc, 90);
331: end if;
332:
333: hxc_building_block_api.create_building_block
334: (p_effective_date => trunc(SYSDATE),

Line 360: hr_utility.set_location('Processing '||l_proc, 100);

356: open c_creation_date(l_time_building_block_id , l_object_version_number );
357: fetch c_creation_date into l_creation_date;
358: close c_creation_date;
359: if g_debug then
360: hr_utility.set_location('Processing '||l_proc, 100);
361: end if;
362:
363: /* Call to create the Application period in hxc_app_period_summary table */
364: hxc_app_period_summary_pkg.insert_summary_row

Line 400: hr_utility.set_location('Processing '||l_proc, 110);

396: l_detail_array.application_period_id(l_index_app) := l_time_building_block_id ;
397: End loop;
398: end if;
399: if g_debug then
400: hr_utility.set_location('Processing '||l_proc, 110);
401: end if;
402: /* Bulk insert the nested array into the hxc_ap_detail_links table */
403: --Fix the bug 4506258. Added the if condition to take care of empty PL/SQL table when empty TC is submitted
404: if(l_detail_array.application_period_id.count>0) then

Line 414: hr_utility.set_location('Processing '||l_proc, 120);

410: );
411: end if;
412: end loop;
413: if g_debug then
414: hr_utility.set_location('Processing '||l_proc, 120);
415: end if;
416:
417: update hxc_timecard_summary
418: set approval_status = hxc_timecard.c_approved_status

Line 422: hr_utility.set_location('Processing '||l_proc, 130);

418: set approval_status = hxc_timecard.c_approved_status
419: where timecard_id = p_tc_bb_id;
420:
421: if g_debug then
422: hr_utility.set_location('Processing '||l_proc, 130);
423: end if;
424:
425: -- OTL-Absences Integration (Bug 8779478)
426: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN

Line 428: hr_utility.trace('Initiated Online Retrieval from HXC_TIMECARD_APPROVAL.LIGHT_APPROVE_TIMECARDS');

424:
425: -- OTL-Absences Integration (Bug 8779478)
426: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
427: IF g_debug THEN
428: hr_utility.trace('Initiated Online Retrieval from HXC_TIMECARD_APPROVAL.LIGHT_APPROVE_TIMECARDS');
429: END IF;
430:
431: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,
432: l_timecard_start_time,

Line 506: g_debug := hr_utility.debug_enabled;

502: l_timecard_info timecard_info;
503:
504: Begin
505:
506: g_debug := hr_utility.debug_enabled;
507:
508: if g_debug then
509: l_proc := g_package||'begin_approval';
510: hr_utility.set_location('Processing '||l_proc, 10);

Line 510: hr_utility.set_location('Processing '||l_proc, 10);

506: g_debug := hr_utility.debug_enabled;
507:
508: if g_debug then
509: l_proc := g_package||'begin_approval';
510: hr_utility.set_location('Processing '||l_proc, 10);
511: end if;
512:
513: get_timecard_information
514: (p_blocks => p_blocks,

Line 522: hr_utility.set_location('Processing '||l_proc, 20);

518: p_timecard_info => l_timecard_info
519: );
520:
521: if g_debug then
522: hr_utility.set_location('Processing '||l_proc, 20);
523: end if;
524:
525: IF g_light_approval_style_id = -99 then
526: if g_debug then

Line 527: hr_utility.set_location('Processing '||l_proc, 30);

523: end if;
524:
525: IF g_light_approval_style_id = -99 then
526: if g_debug then
527: hr_utility.set_location('Processing '||l_proc, 30);
528: end if;
529:
530: open c_get_appr_style;
531: fetch c_get_appr_style into g_light_approval_style_id;

Line 544: hr_utility.set_location('Processing '||l_proc, 40);

540: AND
541: (l_active_asg)) then
542:
543: if g_debug then
544: hr_utility.set_location('Processing '||l_proc, 40);
545: end if;
546:
547: l_item_key := get_item_key;
548: hxc_approval_wf_pkg.start_approval_wf_process

Line 560: hr_utility.set_location('Processing '||l_proc, 50);

556: );
557:
558: else
559: if g_debug then
560: hr_utility.set_location('Processing '||l_proc, 50);
561: end if;
562: light_approve_timecards
563: (p_tc_bb_id => l_timecard_id,
564: p_tc_ovn => l_timecard_ovn,

Line 591: hr_utility.set_location('Processing '||l_proc, 60);

587: );
588: end if;
589:
590: if g_debug then
591: hr_utility.set_location('Processing '||l_proc, 60);
592: end if;
593:
594: return to_char(l_item_key);
595: