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 2006/09/08 08:59:11 rchennur noship $ */
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 217: hr_utility.set_location('Processing '||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

417: set approval_status = hxc_timecard.c_approved_status
418: where timecard_id = p_tc_bb_id;
419:
420: if g_debug then
421: hr_utility.set_location('Processing '||l_proc, 130);
422: end if;
423:
424: end light_approve_timecards;
425:

Line 489: g_debug := hr_utility.debug_enabled;

485: l_timecard_info timecard_info;
486:
487: Begin
488:
489: g_debug := hr_utility.debug_enabled;
490:
491: if g_debug then
492: l_proc := g_package||'begin_approval';
493: hr_utility.set_location('Processing '||l_proc, 10);

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

489: g_debug := hr_utility.debug_enabled;
490:
491: if g_debug then
492: l_proc := g_package||'begin_approval';
493: hr_utility.set_location('Processing '||l_proc, 10);
494: end if;
495:
496: get_timecard_information
497: (p_blocks => p_blocks,

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

501: p_timecard_info => l_timecard_info
502: );
503:
504: if g_debug then
505: hr_utility.set_location('Processing '||l_proc, 20);
506: end if;
507:
508: IF g_light_approval_style_id = -99 then
509: if g_debug then

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

506: end if;
507:
508: IF g_light_approval_style_id = -99 then
509: if g_debug then
510: hr_utility.set_location('Processing '||l_proc, 30);
511: end if;
512:
513: open c_get_appr_style;
514: fetch c_get_appr_style into g_light_approval_style_id;

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

523: AND
524: (l_active_asg)) then
525:
526: if g_debug then
527: hr_utility.set_location('Processing '||l_proc, 40);
528: end if;
529:
530: l_item_key := get_item_key;
531: hxc_approval_wf_pkg.start_approval_wf_process

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

539: );
540:
541: else
542: if g_debug then
543: hr_utility.set_location('Processing '||l_proc, 50);
544: end if;
545: light_approve_timecards
546: (p_tc_bb_id => l_timecard_id,
547: p_tc_ovn => l_timecard_ovn,

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

569: );
570: end if;
571:
572: if g_debug then
573: hr_utility.set_location('Processing '||l_proc, 60);
574: end if;
575:
576: return to_char(l_item_key);
577: