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_GENERIC_RETRIEVAL_UTILS dependencies on HR_UTILITY

Line 6: g_debug boolean := hr_utility.debug_enabled;

2: /* $Header: hxcretutl.pkb 120.16.12020000.2 2013/02/11 11:21:29 jnerella ship $ */
3:
4: -- global package data type and variables
5:
6: g_debug boolean := hr_utility.debug_enabled;
7:
8: l_message_table HXC_MESSAGE_TABLE_TYPE;
9: l_rowid ROWID;
10: l_boolean boolean;

Line 251: g_debug := hr_utility.debug_enabled;

247:
248: l_overall_outcome_exists varchar2(1) ;
249:
250: BEGIN
251: g_debug := hr_utility.debug_enabled;
252:
253: IF ( g_debug ) THEN
254: l_proc := g_package||'populate_rtr_outcomes';
255: hr_utility.set_location('Processing '||l_proc, 10);

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

251: g_debug := hr_utility.debug_enabled;
252:
253: IF ( g_debug ) THEN
254: l_proc := g_package||'populate_rtr_outcomes';
255: hr_utility.set_location('Processing '||l_proc, 10);
256: END IF;
257:
258: l_cnt := p_ret_rules_start;
259:

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

261: LOOP
262: l_overall_outcome_exists := 'N';
263:
264: IF ( g_debug ) THEN
265: hr_utility.set_location('Processing '||l_proc, 20);
266: END IF;
267:
268: l_iter := p_ret_ranges.first;
269:

Line 278: hr_utility.trace('Params for Get Valid Periods are ...');

274:
275: -- convert to character to pass to the dyn SQL
276:
277: IF ( g_debug ) THEN
278: hr_utility.trace('Params for Get Valid Periods are ...');
279: hr_utility.trace('Start Time is '||to_char(p_ret_ranges(l_iter).start_date,'dd-mon-yy'));
280: hr_utility.trace('Stop Time is '||to_char(p_ret_ranges(l_iter).stop_date,'dd-mon-yy'));
281: hr_utility.trace('App Status is '||p_ret_rules_tab(l_cnt).status);
282: hr_utility.trace('Time Recip is '||p_ret_rules_tab(l_cnt).time_recipient_id);

Line 279: hr_utility.trace('Start Time is '||to_char(p_ret_ranges(l_iter).start_date,'dd-mon-yy'));

275: -- convert to character to pass to the dyn SQL
276:
277: IF ( g_debug ) THEN
278: hr_utility.trace('Params for Get Valid Periods are ...');
279: hr_utility.trace('Start Time is '||to_char(p_ret_ranges(l_iter).start_date,'dd-mon-yy'));
280: hr_utility.trace('Stop Time is '||to_char(p_ret_ranges(l_iter).stop_date,'dd-mon-yy'));
281: hr_utility.trace('App Status is '||p_ret_rules_tab(l_cnt).status);
282: hr_utility.trace('Time Recip is '||p_ret_rules_tab(l_cnt).time_recipient_id);
283: END IF;

Line 280: hr_utility.trace('Stop Time is '||to_char(p_ret_ranges(l_iter).stop_date,'dd-mon-yy'));

276:
277: IF ( g_debug ) THEN
278: hr_utility.trace('Params for Get Valid Periods are ...');
279: hr_utility.trace('Start Time is '||to_char(p_ret_ranges(l_iter).start_date,'dd-mon-yy'));
280: hr_utility.trace('Stop Time is '||to_char(p_ret_ranges(l_iter).stop_date,'dd-mon-yy'));
281: hr_utility.trace('App Status is '||p_ret_rules_tab(l_cnt).status);
282: hr_utility.trace('Time Recip is '||p_ret_rules_tab(l_cnt).time_recipient_id);
283: END IF;
284:

Line 281: hr_utility.trace('App Status is '||p_ret_rules_tab(l_cnt).status);

277: IF ( g_debug ) THEN
278: hr_utility.trace('Params for Get Valid Periods are ...');
279: hr_utility.trace('Start Time is '||to_char(p_ret_ranges(l_iter).start_date,'dd-mon-yy'));
280: hr_utility.trace('Stop Time is '||to_char(p_ret_ranges(l_iter).stop_date,'dd-mon-yy'));
281: hr_utility.trace('App Status is '||p_ret_rules_tab(l_cnt).status);
282: hr_utility.trace('Time Recip is '||p_ret_rules_tab(l_cnt).time_recipient_id);
283: END IF;
284:
285:

Line 282: hr_utility.trace('Time Recip is '||p_ret_rules_tab(l_cnt).time_recipient_id);

278: hr_utility.trace('Params for Get Valid Periods are ...');
279: hr_utility.trace('Start Time is '||to_char(p_ret_ranges(l_iter).start_date,'dd-mon-yy'));
280: hr_utility.trace('Stop Time is '||to_char(p_ret_ranges(l_iter).stop_date,'dd-mon-yy'));
281: hr_utility.trace('App Status is '||p_ret_rules_tab(l_cnt).status);
282: hr_utility.trace('Time Recip is '||p_ret_rules_tab(l_cnt).time_recipient_id);
283: END IF;
284:
285:
286: -- get valid periods

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

303:
304: IF ( l_overall_outcome_exists = 'N' )
305: THEN
306: IF ( g_debug ) THEN
307: hr_utility.set_location('Processing '||l_proc, 30);
308: END IF;
309:
310: p_ret_rules_tab(l_cnt).outcome_exists := 'Y';
311: p_ret_rules_tab(l_cnt).outcome_start := l_outcome_index;

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

319: WHILE l_ind IS NOT NULL
320: LOOP
321:
322: IF ( g_debug ) THEN
323: hr_utility.set_location('Processing '||l_proc, 50);
324: END IF;
325:
326: p_rtr_outcomes_tab(l_outcome_index).rtr_grp_id := p_ret_rules_tab(l_cnt).rtr_grp_id;
327: p_rtr_outcomes_tab(l_outcome_index).time_recipient_id := p_ret_rules_tab(l_cnt).time_recipient_id;

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

334:
335: END LOOP;
336:
337: IF ( g_debug ) THEN
338: hr_utility.set_location('Processing '||l_proc, 60);
339: END IF;
340:
341: l_period_tab.DELETE;
342:

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

359:
360: END LOOP;
361:
362: IF ( g_debug ) THEN
363: hr_utility.set_location('Processing '||l_proc, 70);
364: END IF;
365:
366: END populate_rtr_outcomes;
367:

Line 483: g_debug := hr_utility.debug_enabled;

479:
480:
481: BEGIN -- parse_resources
482:
483: g_debug := hr_utility.debug_enabled;
484:
485: IF ( g_debug ) THEN
486: l_proc := g_package||'parse_resources';
487: hr_utility.set_location('Processing '||l_proc, 10);

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

483: g_debug := hr_utility.debug_enabled;
484:
485: IF ( g_debug ) THEN
486: l_proc := g_package||'parse_resources';
487: hr_utility.set_location('Processing '||l_proc, 10);
488:
489: hr_utility.trace('');
490: hr_utility.trace('************** Params are: *****************');
491: hr_utility.trace('is p_process_id '||to_char(p_process_id));

Line 489: hr_utility.trace('');

485: IF ( g_debug ) THEN
486: l_proc := g_package||'parse_resources';
487: hr_utility.set_location('Processing '||l_proc, 10);
488:
489: hr_utility.trace('');
490: hr_utility.trace('************** Params are: *****************');
491: hr_utility.trace('is p_process_id '||to_char(p_process_id));
492: hr_utility.trace('is p_ret_tr_id '||to_char(p_ret_tr_id));
493: hr_utility.trace('');

Line 490: hr_utility.trace(' Params are: ***');

486: l_proc := g_package||'parse_resources';
487: hr_utility.set_location('Processing '||l_proc, 10);
488:
489: hr_utility.trace('');
490: hr_utility.trace('************** Params are: *****************');
491: hr_utility.trace('is p_process_id '||to_char(p_process_id));
492: hr_utility.trace('is p_ret_tr_id '||to_char(p_ret_tr_id));
493: hr_utility.trace('');
494:

Line 491: hr_utility.trace('is p_process_id '||to_char(p_process_id));

487: hr_utility.set_location('Processing '||l_proc, 10);
488:
489: hr_utility.trace('');
490: hr_utility.trace('************** Params are: *****************');
491: hr_utility.trace('is p_process_id '||to_char(p_process_id));
492: hr_utility.trace('is p_ret_tr_id '||to_char(p_ret_tr_id));
493: hr_utility.trace('');
494:
495: END IF;

Line 492: hr_utility.trace('is p_ret_tr_id '||to_char(p_ret_tr_id));

488:
489: hr_utility.trace('');
490: hr_utility.trace('************** Params are: *****************');
491: hr_utility.trace('is p_process_id '||to_char(p_process_id));
492: hr_utility.trace('is p_ret_tr_id '||to_char(p_ret_tr_id));
493: hr_utility.trace('');
494:
495: END IF;
496:

Line 493: hr_utility.trace('');

489: hr_utility.trace('');
490: hr_utility.trace('************** Params are: *****************');
491: hr_utility.trace('is p_process_id '||to_char(p_process_id));
492: hr_utility.trace('is p_ret_tr_id '||to_char(p_ret_tr_id));
493: hr_utility.trace('');
494:
495: END IF;
496:
497: l_process_id := p_process_id;

Line 537: hr_utility.set_location('Processing '||l_proc, 15);

533:
534: WHILE l_resource_index IS NOT NULL
535: LOOP
536: IF ( g_debug ) THEN
537: hr_utility.set_location('Processing '||l_proc, 15);
538: END IF;
539:
540: --delete the ret ranges table. This is because we maintain ret ranges table for each resource
541: l_ret_ranges.delete;

Line 553: hr_utility.trace('* NEW RESOURCE ********');

549: -- GPM v115.27
550:
551: IF ( g_debug ) THEN
552:
553: hr_utility.trace('************* NEW RESOURCE ********************');
554: hr_utility.trace('resource id is '||to_char(l_resource_index));
555: hr_utility.trace('resource start date is '||to_char(l_resource_start_time, 'dd-mon-yyyy hh24:mi:ss'));
556: hr_utility.trace('resource stop date is '||to_char(l_resource_stop_time, 'dd-mon-yyyy hh24:mi:ss'));
557: hr_utility.trace('************* NEW RESOURCE ********************');

Line 554: hr_utility.trace('resource id is '||to_char(l_resource_index));

550:
551: IF ( g_debug ) THEN
552:
553: hr_utility.trace('************* NEW RESOURCE ********************');
554: hr_utility.trace('resource id is '||to_char(l_resource_index));
555: hr_utility.trace('resource start date is '||to_char(l_resource_start_time, 'dd-mon-yyyy hh24:mi:ss'));
556: hr_utility.trace('resource stop date is '||to_char(l_resource_stop_time, 'dd-mon-yyyy hh24:mi:ss'));
557: hr_utility.trace('************* NEW RESOURCE ********************');
558:

Line 555: hr_utility.trace('resource start date is '||to_char(l_resource_start_time, 'dd-mon-yyyy hh24:mi:ss'));

551: IF ( g_debug ) THEN
552:
553: hr_utility.trace('************* NEW RESOURCE ********************');
554: hr_utility.trace('resource id is '||to_char(l_resource_index));
555: hr_utility.trace('resource start date is '||to_char(l_resource_start_time, 'dd-mon-yyyy hh24:mi:ss'));
556: hr_utility.trace('resource stop date is '||to_char(l_resource_stop_time, 'dd-mon-yyyy hh24:mi:ss'));
557: hr_utility.trace('************* NEW RESOURCE ********************');
558:
559: END IF;

Line 556: hr_utility.trace('resource stop date is '||to_char(l_resource_stop_time, 'dd-mon-yyyy hh24:mi:ss'));

552:
553: hr_utility.trace('************* NEW RESOURCE ********************');
554: hr_utility.trace('resource id is '||to_char(l_resource_index));
555: hr_utility.trace('resource start date is '||to_char(l_resource_start_time, 'dd-mon-yyyy hh24:mi:ss'));
556: hr_utility.trace('resource stop date is '||to_char(l_resource_stop_time, 'dd-mon-yyyy hh24:mi:ss'));
557: hr_utility.trace('************* NEW RESOURCE ********************');
558:
559: END IF;
560:

Line 557: hr_utility.trace('* NEW RESOURCE ********');

553: hr_utility.trace('************* NEW RESOURCE ********************');
554: hr_utility.trace('resource id is '||to_char(l_resource_index));
555: hr_utility.trace('resource start date is '||to_char(l_resource_start_time, 'dd-mon-yyyy hh24:mi:ss'));
556: hr_utility.trace('resource stop date is '||to_char(l_resource_stop_time, 'dd-mon-yyyy hh24:mi:ss'));
557: hr_utility.trace('************* NEW RESOURCE ********************');
558:
559: END IF;
560:
561:

Line 594: hr_utility.trace('Error 1 : '||substr(sqlerrm,1,100));

590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: IF ( g_debug ) THEN
594: hr_utility.trace('Error 1 : '||substr(sqlerrm,1,100));
595: END IF;
596: hr_utility.set_message(809, SUBSTR('HXC_NO_RESRC_DATES-'||to_char(l_resource_index),1,28));
597: p_errors(l_resource_index).exception_description := SUBSTR('HXC_NO_RESRC_DATES-'||to_char(l_resource_index),1,2000);
598: p_prefs(l_resource_index).prefs_ok := 'X';

Line 596: hr_utility.set_message(809, SUBSTR('HXC_NO_RESRC_DATES-'||to_char(l_resource_index),1,28));

592: WHEN OTHERS THEN
593: IF ( g_debug ) THEN
594: hr_utility.trace('Error 1 : '||substr(sqlerrm,1,100));
595: END IF;
596: hr_utility.set_message(809, SUBSTR('HXC_NO_RESRC_DATES-'||to_char(l_resource_index),1,28));
597: p_errors(l_resource_index).exception_description := SUBSTR('HXC_NO_RESRC_DATES-'||to_char(l_resource_index),1,2000);
598: p_prefs(l_resource_index).prefs_ok := 'X';
599: END;
600:

Line 613: hr_utility.trace('Error 2 : '||substr(sqlerrm,1,100));

609: THEN
610: IF ( l_tmp_otm_tab.COUNT = 0 OR l_tmp_rtr_tab.COUNT = 0 )
611: THEN
612: IF ( g_debug ) THEN
613: hr_utility.trace('Error 2 : '||substr(sqlerrm,1,100));
614: END IF;
615: p_errors(l_resource_index).exception_description := 'HXC_NO_HIER_FOR_DATE';
616: p_prefs(l_resource_index).prefs_ok := 'X';
617: END IF;

Line 622: hr_utility.trace('Error 3 : '||substr(sqlerrm,1,100));

618: ELSE
619: IF ( l_tmp_rtr_tab.COUNT = 0 )
620: THEN
621: IF ( g_debug ) THEN
622: hr_utility.trace('Error 3 : '||substr(sqlerrm,1,100));
623: END IF;
624: p_errors(l_resource_index).exception_description := 'HXC_NO_HIER_FOR_DATE';
625: p_prefs(l_resource_index).prefs_ok := 'X';
626: END IF;

Line 657: hr_utility.trace('OTM prefs tab is');

653:
654: IF ( g_debug ) AND l_process_id IN (-1, l_bee_ret_id)
655: THEN
656:
657: hr_utility.trace('OTM prefs tab is');
658: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
659: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
660:
661: FOR l_filter_ind IN 1 .. l_tmp_otm_tab.LAST

Line 658: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');

654: IF ( g_debug ) AND l_process_id IN (-1, l_bee_ret_id)
655: THEN
656:
657: hr_utility.trace('OTM prefs tab is');
658: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
659: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
660:
661: FOR l_filter_ind IN 1 .. l_tmp_otm_tab.LAST
662: LOOP

Line 659: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');

655: THEN
656:
657: hr_utility.trace('OTM prefs tab is');
658: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
659: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
660:
661: FOR l_filter_ind IN 1 .. l_tmp_otm_tab.LAST
662: LOOP
663:

Line 664: hr_utility.trace(l_tmp_otm_tab(l_filter_ind).preference_code||' '||

660:
661: FOR l_filter_ind IN 1 .. l_tmp_otm_tab.LAST
662: LOOP
663:
664: hr_utility.trace(l_tmp_otm_tab(l_filter_ind).preference_code||' '||
665: l_tmp_otm_tab(l_filter_ind).attribute1||' '||
666: l_tmp_otm_tab(l_filter_ind).attribute2||' '||
667: to_char(l_tmp_otm_tab(l_filter_ind).start_date,'DD-MON-YYYY HH24:MI:SS')||' '||
668: to_char(l_tmp_otm_tab(l_filter_ind).end_date,'DD-MON-YYYY HH24:MI:SS'));

Line 672: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');

668: to_char(l_tmp_otm_tab(l_filter_ind).end_date,'DD-MON-YYYY HH24:MI:SS'));
669:
670: END LOOP;
671:
672: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
673:
674: hr_utility.trace('RTR prefs tab is');
675: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
676: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');

Line 674: hr_utility.trace('RTR prefs tab is');

670: END LOOP;
671:
672: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
673:
674: hr_utility.trace('RTR prefs tab is');
675: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
676: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
677:
678: FOR l_filter_ind IN 1 .. l_tmp_rtr_tab.LAST

Line 675: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');

671:
672: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
673:
674: hr_utility.trace('RTR prefs tab is');
675: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
676: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
677:
678: FOR l_filter_ind IN 1 .. l_tmp_rtr_tab.LAST
679: LOOP

Line 676: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');

672: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
673:
674: hr_utility.trace('RTR prefs tab is');
675: hr_utility.trace('Preference Code ATT1 ATT2 Start Date End Date');
676: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
677:
678: FOR l_filter_ind IN 1 .. l_tmp_rtr_tab.LAST
679: LOOP
680:

Line 681: hr_utility.trace(l_tmp_rtr_tab(l_filter_ind).preference_code||' '||

677:
678: FOR l_filter_ind IN 1 .. l_tmp_rtr_tab.LAST
679: LOOP
680:
681: hr_utility.trace(l_tmp_rtr_tab(l_filter_ind).preference_code||' '||
682: l_tmp_rtr_tab(l_filter_ind).attribute1||' '||
683: l_tmp_rtr_tab(l_filter_ind).attribute2||' '||
684: to_char(l_tmp_rtr_tab(l_filter_ind).start_date,'DD-MON-YYYY HH24:MI:SS')||' '||
685: to_char(l_tmp_rtr_tab(l_filter_ind).end_date,'DD-MON-YYYY HH24:MI:SS'));

Line 689: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');

685: to_char(l_tmp_rtr_tab(l_filter_ind).end_date,'DD-MON-YYYY HH24:MI:SS'));
686:
687: END LOOP;
688:
689: hr_utility.trace('--------------------- ------ ----- -------------------- ---------------------');
690:
691: END IF; -- l debug
692:
693: --We have filtered the main pref table and populated the temporary tables we created.

Line 704: hr_utility.trace('Merge logic starts');

700: --otherwise the l_tmp_rtr_tab table will be copied to ret_ranges table.
701: --Note : We dont need the merge logic in case the Application Process is not BEE or Apply Schedule Rules
702:
703: IF ( g_debug ) THEN
704: hr_utility.trace('Merge logic starts');
705: END IF;
706:
707: if (l_process_id = -1 or l_process_id = l_bee_ret_id) then
708: --merge logic

Line 710: hr_utility.trace('merge logic');

706:
707: if (l_process_id = -1 or l_process_id = l_bee_ret_id) then
708: --merge logic
709: IF ( g_debug ) THEN
710: hr_utility.trace('merge logic');
711: END IF;
712:
713: l_ret_range_iter :=1;
714: l_tmp_rtr_iter := l_tmp_rtr_tab.first;

Line 750: hr_utility.trace('merge logic over');

746: l_tmp_rtr_iter := l_tmp_rtr_tab.next(l_tmp_rtr_iter);
747: END LOOP;
748:
749: IF ( g_debug ) THEN
750: hr_utility.trace('merge logic over');
751: END IF;
752:
753: --merge logic over
754: else

Line 760: hr_utility.trace('not BEE or Apply thus copy RTR');

756: --process is neither Apply Schedule rules nor BEE. Hence we just copy
757: --l_tmp_rtr_tab to l_ret_ranges
758:
759: IF ( g_debug ) THEN
760: hr_utility.trace('not BEE or Apply thus copy RTR');
761: END IF;
762:
763: l_iter := 1;
764: l_tmp_rtr_iter := l_tmp_rtr_tab.first;

Line 779: hr_utility.trace('Merge logic ends');

775:
776:
777: end if;
778: IF ( g_debug ) THEN
779: hr_utility.trace('Merge logic ends');
780: END IF;
781:
782: --we can delete the pref table and temporary tables to save space
783: l_tmp_otm_tab.DELETE;

Line 797: hr_utility.trace('Sorting the unsorted ret ranges table');

793: --we shall have a temporary table that we can use to store the distinct
794: --rtr grp ids. It will be indexed on rtr grp id.
795:
796: IF ( g_debug ) THEN
797: hr_utility.trace('Sorting the unsorted ret ranges table');
798: END IF;
799: l_iter:= l_ret_ranges.first;
800:
801: WHILE l_iter is not null

Line 840: hr_utility.trace('Sorting the unsorted ret ranges table over');

836: l_ret_ranges1.delete;
837: l_ret_ranges_tmp_tab.delete;
838:
839: IF ( g_debug ) THEN
840: hr_utility.trace('Sorting the unsorted ret ranges table over');
841: END IF;
842:
843:
844: --Now we have the final ret ranges table in l_ret_ranges. We will use the ret ranges table to populate

Line 854: hr_utility.trace('Ret Ranges Table');

850:
851:
852: IF ( g_debug ) THEN
853:
854: hr_utility.trace('Ret Ranges Table');
855: hr_utility.trace('Index RTR GRP ID Start Date End Date');
856: hr_utility.trace('------ ----------- -------------------- ---------------------');
857:
858: FOR l_filter_ind IN 1 .. l_ret_ranges.LAST

Line 855: hr_utility.trace('Index RTR GRP ID Start Date End Date');

851:
852: IF ( g_debug ) THEN
853:
854: hr_utility.trace('Ret Ranges Table');
855: hr_utility.trace('Index RTR GRP ID Start Date End Date');
856: hr_utility.trace('------ ----------- -------------------- ---------------------');
857:
858: FOR l_filter_ind IN 1 .. l_ret_ranges.LAST
859: LOOP

Line 856: hr_utility.trace('------ ----------- -------------------- ---------------------');

852: IF ( g_debug ) THEN
853:
854: hr_utility.trace('Ret Ranges Table');
855: hr_utility.trace('Index RTR GRP ID Start Date End Date');
856: hr_utility.trace('------ ----------- -------------------- ---------------------');
857:
858: FOR l_filter_ind IN 1 .. l_ret_ranges.LAST
859: LOOP
860:

Line 861: hr_utility.trace(to_char(l_filter_ind)||' '||

857:
858: FOR l_filter_ind IN 1 .. l_ret_ranges.LAST
859: LOOP
860:
861: hr_utility.trace(to_char(l_filter_ind)||' '||
862: to_char(l_ret_Ranges(l_filter_ind).rtr_grp_id)||' '||
863: to_char(l_ret_ranges(l_filter_ind).start_date,'DD-MON-YYYY HH24:MI:SS')||' '||
864: to_char(l_ret_ranges(l_filter_ind).stop_date,'DD-MON-YYYY HH24:MI:SS'));
865:

Line 868: hr_utility.trace('----------- -------------------- ---------------------');

864: to_char(l_ret_ranges(l_filter_ind).stop_date,'DD-MON-YYYY HH24:MI:SS'));
865:
866: END LOOP;
867:
868: hr_utility.trace('----------- -------------------- ---------------------');
869:
870: END IF;
871:
872: l_resource_rtr.DELETE;

Line 902: hr_utility.set_location('Processing '||l_proc, 55);

898:
899: l_resource_rtr(l_ret_ranges(ret_range_iter).rtr_grp_id).dummy := 'Y';
900:
901: IF ( g_debug ) THEN
902: hr_utility.set_location('Processing '||l_proc, 55);
903: END IF;
904:
905: -- check to see that we haven't got these rules before
906:

Line 910: hr_utility.trace('hitting PL/SQL table for rtr');

906:
907: IF ( l_rtr_exists.EXISTS(l_rtr_grp_id) )
908: THEN
909: IF ( g_debug ) THEN
910: hr_utility.trace('hitting PL/SQL table for rtr');
911: END IF;
912:
913: l_rr_index := NVL(p_ret_rules.LAST, 0) + 1;
914:

Line 943: hr_utility.trace('hitting db for rtr');

939:
940: -- get the retrieval rules for the given resource ids retrieval group
941:
942: IF ( g_debug ) THEN
943: hr_utility.trace('hitting db for rtr');
944: END IF;
945:
946: -- l_process_id is passed to the cursor csr_get_retrieval_rules. However
947: --for the 'Apply Schedule Rules' Process the process id is 1 and the

Line 974: hr_utility.set_message(809, 'HXC_NO_RET_RULE_FOR_RET');

970: OPEN csr_get_emp ( l_resource_index);
971: FETCH csr_get_emp INTO l_emp;
972: CLOSE csr_get_emp;
973:
974: hr_utility.set_message(809, 'HXC_NO_RET_RULE_FOR_RET');
975: hr_utility.set_message_token('EMP', l_emp);
976:
977: p_errors(l_resource_index).exception_description := SUBSTR('HXC_NO_RET_RULE_FOR_RET: '||l_emp,1,2000);
978: p_prefs(l_resource_index).prefs_ok := 'X';

Line 975: hr_utility.set_message_token('EMP', l_emp);

971: FETCH csr_get_emp INTO l_emp;
972: CLOSE csr_get_emp;
973:
974: hr_utility.set_message(809, 'HXC_NO_RET_RULE_FOR_RET');
975: hr_utility.set_message_token('EMP', l_emp);
976:
977: p_errors(l_resource_index).exception_description := SUBSTR('HXC_NO_RET_RULE_FOR_RET: '||l_emp,1,2000);
978: p_prefs(l_resource_index).prefs_ok := 'X';
979:

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

998:
999: END IF;
1000:
1001: IF ( g_debug ) THEN
1002: hr_utility.set_location('Processing '||l_proc, 60);
1003: END IF;
1004:
1005: WHILE csr_get_retrieval_rules%FOUND
1006: LOOP

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

1004:
1005: WHILE csr_get_retrieval_rules%FOUND
1006: LOOP
1007: IF ( g_debug ) THEN
1008: hr_utility.set_location('Processing '||l_proc, 70);
1009: END IF;
1010:
1011: -- maintain table of retrieval rules
1012:

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

1028: l_rtr_exists(l_rtr_grp_id).rtr_stop := l_rr_index - 1;
1029: p_prefs(l_resource_index).rtr_end := l_rr_index - 1;
1030:
1031: IF ( g_debug ) THEN
1032: hr_utility.set_location('Processing '||l_proc, 80);
1033: END IF;
1034:
1035: END IF; -- csr_get_retrieval_rules%NOTFOUND
1036:

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

1038:
1039: -- now get the application period dates for these
1040:
1041: IF ( g_debug ) THEN
1042: hr_utility.set_location('Processing '||l_proc, 90);
1043: END IF;
1044:
1045: END IF; -- if not
1046: --(l_resource_rtr.exists(p_ret_range(ret_range).rtr_grp_id) then

Line 1055: hr_utility.set_location('Processing '||l_proc, 95);

1051:
1052: IF NOT p_errors.EXISTS(l_resource_index)
1053: THEN
1054: IF ( g_debug ) THEN
1055: hr_utility.set_location('Processing '||l_proc, 95);
1056: END IF;
1057:
1058: populate_rtr_outcomes (
1059: p_resource_id => l_resource_index

Line 1069: hr_utility.set_location('Processing '||l_proc, 97);

1065:
1066: END IF; --IF NOT p_errors.EXISTS(l_resource_index)
1067:
1068: IF ( g_debug ) THEN
1069: hr_utility.set_location('Processing '||l_proc, 97);
1070: END IF;
1071:
1072: ELSE
1073:

Line 1082: hr_utility.set_location('Processing '||l_proc, 98);

1078:
1079: END IF; --IF (l_ret_ranges.COUNT > 0)
1080:
1081: IF ( g_debug ) THEN
1082: hr_utility.set_location('Processing '||l_proc, 98);
1083: END IF;
1084:
1085: END IF; -- NOT p_errors.EXISTS(l_resource_index) - hxc_no_hier_for_date check
1086:

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

1090:
1091: END LOOP; -- g_resources loop
1092:
1093: IF ( g_debug ) THEN
1094: hr_utility.set_location('Processing '||l_proc, 110);
1095: END IF;
1096:
1097: EXCEPTION WHEN OTHERS
1098: THEN

Line 1102: hr_utility.trace('in parse resources unhandled exception');

1098: THEN
1099: -- unhandled excpetion whilst processing resource table
1100:
1101: IF ( g_debug ) THEN
1102: hr_utility.trace('in parse resources unhandled exception');
1103: hr_utility.trace('resource is '||to_char(l_resource_index));
1104: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,150));
1105: END IF;
1106:

Line 1103: hr_utility.trace('resource is '||to_char(l_resource_index));

1099: -- unhandled excpetion whilst processing resource table
1100:
1101: IF ( g_debug ) THEN
1102: hr_utility.trace('in parse resources unhandled exception');
1103: hr_utility.trace('resource is '||to_char(l_resource_index));
1104: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,150));
1105: END IF;
1106:
1107: p_errors(l_resource_index).exception_description := SUBSTR(l_proc||':'||SQLERRM,1,2000);

Line 1104: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,150));

1100:
1101: IF ( g_debug ) THEN
1102: hr_utility.trace('in parse resources unhandled exception');
1103: hr_utility.trace('resource is '||to_char(l_resource_index));
1104: hr_utility.trace('error is '||SUBSTR(SQLERRM,1,150));
1105: END IF;
1106:
1107: p_errors(l_resource_index).exception_description := SUBSTR(l_proc||':'||SQLERRM,1,2000);
1108: p_prefs(l_resource_index).prefs_ok := 'X';

Line 1112: hr_utility.set_location('Processing '||l_proc, 150);

1108: p_prefs(l_resource_index).prefs_ok := 'X';
1109: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1110:
1111: IF ( g_debug ) THEN
1112: hr_utility.set_location('Processing '||l_proc, 150);
1113: END IF;
1114:
1115: END;
1116:

Line 1121: hr_utility.trace(' Resources **');

1117: END LOOP; -- master g_resources loop
1118:
1119: IF ( g_debug ) THEN
1120:
1121: hr_utility.trace('****** Resources ********');
1122:
1123: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;
1124:
1125: WHILE l_resource_index IS NOT NULL

Line 1127: hr_utility.trace('');

1123: l_resource_index := hxc_generic_retrieval_utils.g_resources.FIRST;
1124:
1125: WHILE l_resource_index IS NOT NULL
1126: LOOP
1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');

Line 1128: hr_utility.trace('index is '||to_char(l_resource_index));

1124:
1125: WHILE l_resource_index IS NOT NULL
1126: LOOP
1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:

Line 1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));

1125: WHILE l_resource_index IS NOT NULL
1126: LOOP
1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:
1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);

Line 1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));

1126: LOOP
1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:
1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1134:

Line 1131: hr_utility.trace('');

1127: hr_utility.trace('');
1128: hr_utility.trace('index is '||to_char(l_resource_index));
1129: hr_utility.trace('start time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).start_time,'dd-mon-yyyy'));
1130: hr_utility.trace('stop time is '||to_char(hxc_generic_retrieval_utils.g_resources(l_resource_index).stop_time,'dd-mon-yyyy'));
1131: hr_utility.trace('');
1132:
1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1134:
1135: END LOOP;

Line 1137: hr_utility.trace(' Prefs **');

1133: l_resource_index := hxc_generic_retrieval_utils.g_resources.NEXT(l_resource_index);
1134:
1135: END LOOP;
1136:
1137: hr_utility.trace('****** Prefs ********');
1138:
1139: l_resource_index := p_prefs.FIRST;
1140:
1141: WHILE l_resource_index IS NOT NULL

Line 1143: hr_utility.trace('');

1139: l_resource_index := p_prefs.FIRST;
1140:
1141: WHILE l_resource_index IS NOT NULL
1142: LOOP
1143: hr_utility.trace('');
1144: hr_utility.trace('index is '||to_char(l_resource_index));
1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);
1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));
1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));

Line 1144: hr_utility.trace('index is '||to_char(l_resource_index));

1140:
1141: WHILE l_resource_index IS NOT NULL
1142: LOOP
1143: hr_utility.trace('');
1144: hr_utility.trace('index is '||to_char(l_resource_index));
1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);
1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));
1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));
1148: hr_utility.trace('');

Line 1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);

1141: WHILE l_resource_index IS NOT NULL
1142: LOOP
1143: hr_utility.trace('');
1144: hr_utility.trace('index is '||to_char(l_resource_index));
1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);
1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));
1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));
1148: hr_utility.trace('');
1149:

Line 1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));

1142: LOOP
1143: hr_utility.trace('');
1144: hr_utility.trace('index is '||to_char(l_resource_index));
1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);
1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));
1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));
1148: hr_utility.trace('');
1149:
1150: l_resource_index := p_prefs.NEXT(l_resource_index);

Line 1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));

1143: hr_utility.trace('');
1144: hr_utility.trace('index is '||to_char(l_resource_index));
1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);
1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));
1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));
1148: hr_utility.trace('');
1149:
1150: l_resource_index := p_prefs.NEXT(l_resource_index);
1151:

Line 1148: hr_utility.trace('');

1144: hr_utility.trace('index is '||to_char(l_resource_index));
1145: hr_utility.trace('prefs_ok flag is '||p_prefs(l_resource_index).prefs_ok);
1146: hr_utility.trace('rtr grp start is '||to_char(p_prefs(l_resource_index).rtr_start));
1147: hr_utility.trace('rtr grp end is '||to_char(p_prefs(l_resource_index).rtr_end));
1148: hr_utility.trace('');
1149:
1150: l_resource_index := p_prefs.NEXT(l_resource_index);
1151:
1152: END LOOP;

Line 1154: hr_utility.trace(' RTR Rules **');

1150: l_resource_index := p_prefs.NEXT(l_resource_index);
1151:
1152: END LOOP;
1153:
1154: hr_utility.trace('****** RTR Rules ********');
1155:
1156: l_resource_index := p_ret_rules.FIRST;
1157:
1158: WHILE l_resource_index IS NOT NULL

Line 1160: hr_utility.trace('');

1156: l_resource_index := p_ret_rules.FIRST;
1157:
1158: WHILE l_resource_index IS NOT NULL
1159: LOOP
1160: hr_utility.trace('');
1161: hr_utility.trace('index is '||to_char(l_resource_index));
1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');

Line 1161: hr_utility.trace('index is '||to_char(l_resource_index));

1157:
1158: WHILE l_resource_index IS NOT NULL
1159: LOOP
1160: hr_utility.trace('');
1161: hr_utility.trace('index is '||to_char(l_resource_index));
1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);

Line 1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));

1158: WHILE l_resource_index IS NOT NULL
1159: LOOP
1160: hr_utility.trace('');
1161: hr_utility.trace('index is '||to_char(l_resource_index));
1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));

Line 1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));

1159: LOOP
1160: hr_utility.trace('');
1161: hr_utility.trace('index is '||to_char(l_resource_index));
1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));
1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));

Line 1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');

1160: hr_utility.trace('');
1161: hr_utility.trace('index is '||to_char(l_resource_index));
1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));
1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));
1168: hr_utility.trace('');

Line 1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);

1161: hr_utility.trace('index is '||to_char(l_resource_index));
1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));
1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));
1168: hr_utility.trace('');
1169:

Line 1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));

1162: hr_utility.trace('rtr grp id is '||to_char(p_ret_rules(l_resource_index).rtr_grp_id));
1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));
1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));
1168: hr_utility.trace('');
1169:
1170: l_resource_index := p_ret_rules.NEXT(l_resource_index);

Line 1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));

1163: hr_utility.trace('time recipient id is '||to_char(p_ret_rules(l_resource_index).time_recipient_id));
1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));
1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));
1168: hr_utility.trace('');
1169:
1170: l_resource_index := p_ret_rules.NEXT(l_resource_index);
1171:

Line 1168: hr_utility.trace('');

1164: hr_utility.trace('status is :'||p_ret_rules(l_resource_index).status||':');
1165: hr_utility.trace('outcome exists is '||p_ret_rules(l_resource_index).outcome_exists);
1166: hr_utility.trace('outcome start is '||to_char(p_ret_rules(l_resource_index).outcome_start));
1167: hr_utility.trace('outcome stop is '||to_char(p_ret_rules(l_resource_index).outcome_stop));
1168: hr_utility.trace('');
1169:
1170: l_resource_index := p_ret_rules.NEXT(l_resource_index);
1171:
1172: END LOOP;

Line 1174: hr_utility.trace(' RTR Outcome **');

1170: l_resource_index := p_ret_rules.NEXT(l_resource_index);
1171:
1172: END LOOP;
1173:
1174: hr_utility.trace('****** RTR Outcome ********');
1175:
1176: l_resource_index := p_rtr_outcomes.FIRST;
1177:
1178: WHILE l_resource_index IS NOT NULL

Line 1180: hr_utility.trace('');

1176: l_resource_index := p_rtr_outcomes.FIRST;
1177:
1178: WHILE l_resource_index IS NOT NULL
1179: LOOP
1180: hr_utility.trace('');
1181: hr_utility.trace('index is '||to_char(l_resource_index));
1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));

Line 1181: hr_utility.trace('index is '||to_char(l_resource_index));

1177:
1178: WHILE l_resource_index IS NOT NULL
1179: LOOP
1180: hr_utility.trace('');
1181: hr_utility.trace('index is '||to_char(l_resource_index));
1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));
1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));

Line 1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));

1178: WHILE l_resource_index IS NOT NULL
1179: LOOP
1180: hr_utility.trace('');
1181: hr_utility.trace('index is '||to_char(l_resource_index));
1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));
1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));
1186: hr_utility.trace('');

Line 1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));

1179: LOOP
1180: hr_utility.trace('');
1181: hr_utility.trace('index is '||to_char(l_resource_index));
1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));
1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));
1186: hr_utility.trace('');
1187:

Line 1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));

1180: hr_utility.trace('');
1181: hr_utility.trace('index is '||to_char(l_resource_index));
1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));
1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));
1186: hr_utility.trace('');
1187:
1188: l_resource_index := p_rtr_outcomes.NEXT(l_resource_index);

Line 1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));

1181: hr_utility.trace('index is '||to_char(l_resource_index));
1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));
1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));
1186: hr_utility.trace('');
1187:
1188: l_resource_index := p_rtr_outcomes.NEXT(l_resource_index);
1189:

Line 1186: hr_utility.trace('');

1182: hr_utility.trace('rtr grp id is '||to_char(p_rtr_outcomes(l_resource_index).rtr_grp_id));
1183: hr_utility.trace('time recipient id is '||to_char(p_rtr_outcomes(l_resource_index).time_recipient_id));
1184: hr_utility.trace('start time is '||to_char(p_rtr_outcomes(l_resource_index).start_time,'dd-mon-yyyy'));
1185: hr_utility.trace('stop time is '||to_char(p_rtr_outcomes(l_resource_index).stop_time,'dd-mon-yyyy'));
1186: hr_utility.trace('');
1187:
1188: l_resource_index := p_rtr_outcomes.NEXT(l_resource_index);
1189:
1190: END LOOP;

Line 1192: hr_utility.trace(' Errors **');

1188: l_resource_index := p_rtr_outcomes.NEXT(l_resource_index);
1189:
1190: END LOOP;
1191:
1192: hr_utility.trace('****** Errors ********');
1193:
1194: l_resource_index := p_errors.FIRST;
1195:
1196: WHILE l_resource_index IS NOT NULL

Line 1198: hr_utility.trace('');

1194: l_resource_index := p_errors.FIRST;
1195:
1196: WHILE l_resource_index IS NOT NULL
1197: LOOP
1198: hr_utility.trace('');
1199: hr_utility.trace('index is '||to_char(l_resource_index));
1200: hr_utility.trace('exception is '||SUBSTR(p_errors(l_resource_index).exception_description,1,60));
1201: hr_utility.trace('');
1202:

Line 1199: hr_utility.trace('index is '||to_char(l_resource_index));

1195:
1196: WHILE l_resource_index IS NOT NULL
1197: LOOP
1198: hr_utility.trace('');
1199: hr_utility.trace('index is '||to_char(l_resource_index));
1200: hr_utility.trace('exception is '||SUBSTR(p_errors(l_resource_index).exception_description,1,60));
1201: hr_utility.trace('');
1202:
1203: l_resource_index := p_errors.NEXT(l_resource_index);

Line 1200: hr_utility.trace('exception is '||SUBSTR(p_errors(l_resource_index).exception_description,1,60));

1196: WHILE l_resource_index IS NOT NULL
1197: LOOP
1198: hr_utility.trace('');
1199: hr_utility.trace('index is '||to_char(l_resource_index));
1200: hr_utility.trace('exception is '||SUBSTR(p_errors(l_resource_index).exception_description,1,60));
1201: hr_utility.trace('');
1202:
1203: l_resource_index := p_errors.NEXT(l_resource_index);
1204:

Line 1201: hr_utility.trace('');

1197: LOOP
1198: hr_utility.trace('');
1199: hr_utility.trace('index is '||to_char(l_resource_index));
1200: hr_utility.trace('exception is '||SUBSTR(p_errors(l_resource_index).exception_description,1,60));
1201: hr_utility.trace('');
1202:
1203: l_resource_index := p_errors.NEXT(l_resource_index);
1204:
1205: END LOOP;

Line 1276: g_debug := hr_utility.debug_enabled;

1272:
1273:
1274: BEGIN
1275:
1276: g_debug := hr_utility.debug_enabled;
1277:
1278: -- Absences code starts
1279: -- OTL-Absences Integration (Bug 8779478)
1280:

Line 1283: hr_utility.trace('ABS:Entered chk_retrieve');

1279: -- OTL-Absences Integration (Bug 8779478)
1280:
1281:
1282: IF g_debug THEN
1283: hr_utility.trace('ABS:Entered chk_retrieve');
1284: hr_utility.trace('ABS:p_attribute_category = '|| p_attribute_category);
1285: END IF;
1286:
1287: IF (p_attribute_category like 'ELEMENT%'

Line 1284: hr_utility.trace('ABS:p_attribute_category = '|| p_attribute_category);

1280:
1281:
1282: IF g_debug THEN
1283: hr_utility.trace('ABS:Entered chk_retrieve');
1284: hr_utility.trace('ABS:p_attribute_category = '|| p_attribute_category);
1285: END IF;
1286:
1287: IF (p_attribute_category like 'ELEMENT%'
1288: AND p_process IN ( 'BEE Retrieval Process',

Line 1292: hr_utility.trace('ABS:p_bb_id = '||p_bb_id);

1288: AND p_process IN ( 'BEE Retrieval Process',
1289: 'Apply Schedule Rules') ) THEN -- Bug 16203299
1290:
1291: IF g_debug THEN
1292: hr_utility.trace('ABS:p_bb_id = '||p_bb_id);
1293: hr_utility.trace('ABS:p_bb_ovn = '||p_bb_ovn);
1294: END IF;
1295:
1296: IF (absence_link_exists(to_number(substr(p_attribute_category, 10)))) THEN

Line 1293: hr_utility.trace('ABS:p_bb_ovn = '||p_bb_ovn);

1289: 'Apply Schedule Rules') ) THEN -- Bug 16203299
1290:
1291: IF g_debug THEN
1292: hr_utility.trace('ABS:p_bb_id = '||p_bb_id);
1293: hr_utility.trace('ABS:p_bb_ovn = '||p_bb_ovn);
1294: END IF;
1295:
1296: IF (absence_link_exists(to_number(substr(p_attribute_category, 10)))) THEN
1297:

Line 1299: hr_utility.trace('ABS:* Skip this Absence record *'|| p_bb_id);

1295:
1296: IF (absence_link_exists(to_number(substr(p_attribute_category, 10)))) THEN
1297:
1298: IF g_debug THEN
1299: hr_utility.trace('ABS:***** Skip this Absence record *****'|| p_bb_id);
1300: END IF;
1301:
1302: p_timecard_retrieve := FALSE;
1303: p_day_retrieve := FALSE;

Line 1467: hr_utility.trace('not locked');

1463: IF ( NOT p_tc_locked )
1464: THEN
1465: IF ( g_debug ) THEN
1466: l_proc := g_package||'chk_retrieve';
1467: hr_utility.trace('not locked');
1468: hr_utility.trace('message is '||l_message_table(1).message_name);
1469: END IF;
1470:
1471: p_day_retrieve := FALSE;

Line 1468: hr_utility.trace('message is '||l_message_table(1).message_name);

1464: THEN
1465: IF ( g_debug ) THEN
1466: l_proc := g_package||'chk_retrieve';
1467: hr_utility.trace('not locked');
1468: hr_utility.trace('message is '||l_message_table(1).message_name);
1469: END IF;
1470:
1471: p_day_retrieve := FALSE;
1472: p_timecard_retrieve := FALSE;

Line 1493: hr_utility.trace('');

1489: /*
1490: IF ( p_day_retrieve )
1491: THEN
1492: IF ( g_debug ) THEN
1493: hr_utility.trace('');
1494: hr_utility.trace('day retrieve is TRUE for resource '||to_char(p_resource_id));
1495: hr_utility.trace('day is '||to_char(p_bb_start_time, 'dd-mon-yyyy hh:mi:ss'));
1496: hr_utility.trace('');
1497: END IF;

Line 1494: hr_utility.trace('day retrieve is TRUE for resource '||to_char(p_resource_id));

1490: IF ( p_day_retrieve )
1491: THEN
1492: IF ( g_debug ) THEN
1493: hr_utility.trace('');
1494: hr_utility.trace('day retrieve is TRUE for resource '||to_char(p_resource_id));
1495: hr_utility.trace('day is '||to_char(p_bb_start_time, 'dd-mon-yyyy hh:mi:ss'));
1496: hr_utility.trace('');
1497: END IF;
1498: ELSE

Line 1495: hr_utility.trace('day is '||to_char(p_bb_start_time, 'dd-mon-yyyy hh:mi:ss'));

1491: THEN
1492: IF ( g_debug ) THEN
1493: hr_utility.trace('');
1494: hr_utility.trace('day retrieve is TRUE for resource '||to_char(p_resource_id));
1495: hr_utility.trace('day is '||to_char(p_bb_start_time, 'dd-mon-yyyy hh:mi:ss'));
1496: hr_utility.trace('');
1497: END IF;
1498: ELSE
1499: IF ( g_debug ) THEN

Line 1496: hr_utility.trace('');

1492: IF ( g_debug ) THEN
1493: hr_utility.trace('');
1494: hr_utility.trace('day retrieve is TRUE for resource '||to_char(p_resource_id));
1495: hr_utility.trace('day is '||to_char(p_bb_start_time, 'dd-mon-yyyy hh:mi:ss'));
1496: hr_utility.trace('');
1497: END IF;
1498: ELSE
1499: IF ( g_debug ) THEN
1500: hr_utility.trace('');

Line 1500: hr_utility.trace('');

1496: hr_utility.trace('');
1497: END IF;
1498: ELSE
1499: IF ( g_debug ) THEN
1500: hr_utility.trace('');
1501: hr_utility.trace('day retrieve is FALSE for resource '||to_char(p_resource_id));
1502: hr_utility.trace('');
1503: END IF;
1504: END IF;

Line 1501: hr_utility.trace('day retrieve is FALSE for resource '||to_char(p_resource_id));

1497: END IF;
1498: ELSE
1499: IF ( g_debug ) THEN
1500: hr_utility.trace('');
1501: hr_utility.trace('day retrieve is FALSE for resource '||to_char(p_resource_id));
1502: hr_utility.trace('');
1503: END IF;
1504: END IF;
1505:

Line 1502: hr_utility.trace('');

1498: ELSE
1499: IF ( g_debug ) THEN
1500: hr_utility.trace('');
1501: hr_utility.trace('day retrieve is FALSE for resource '||to_char(p_resource_id));
1502: hr_utility.trace('');
1503: END IF;
1504: END IF;
1505:
1506: IF ( p_timecard_retrieve )

Line 1509: hr_utility.trace('');

1505:
1506: IF ( p_timecard_retrieve )
1507: THEN
1508: IF ( g_debug ) THEN
1509: hr_utility.trace('');
1510: hr_utility.trace('time retrieve is TRUE for resource '||to_char(p_resource_id));
1511: hr_utility.trace('');
1512: END IF;
1513: ELSE

Line 1510: hr_utility.trace('time retrieve is TRUE for resource '||to_char(p_resource_id));

1506: IF ( p_timecard_retrieve )
1507: THEN
1508: IF ( g_debug ) THEN
1509: hr_utility.trace('');
1510: hr_utility.trace('time retrieve is TRUE for resource '||to_char(p_resource_id));
1511: hr_utility.trace('');
1512: END IF;
1513: ELSE
1514: IF ( g_debug ) THEN

Line 1511: hr_utility.trace('');

1507: THEN
1508: IF ( g_debug ) THEN
1509: hr_utility.trace('');
1510: hr_utility.trace('time retrieve is TRUE for resource '||to_char(p_resource_id));
1511: hr_utility.trace('');
1512: END IF;
1513: ELSE
1514: IF ( g_debug ) THEN
1515: hr_utility.trace('');

Line 1515: hr_utility.trace('');

1511: hr_utility.trace('');
1512: END IF;
1513: ELSE
1514: IF ( g_debug ) THEN
1515: hr_utility.trace('');
1516: hr_utility.trace('time retrieve is FALSE for resource '||to_char(p_resource_id));
1517: hr_utility.trace('');
1518: END IF;
1519: END IF;

Line 1516: hr_utility.trace('time retrieve is FALSE for resource '||to_char(p_resource_id));

1512: END IF;
1513: ELSE
1514: IF ( g_debug ) THEN
1515: hr_utility.trace('');
1516: hr_utility.trace('time retrieve is FALSE for resource '||to_char(p_resource_id));
1517: hr_utility.trace('');
1518: END IF;
1519: END IF;
1520: */

Line 1517: hr_utility.trace('');

1513: ELSE
1514: IF ( g_debug ) THEN
1515: hr_utility.trace('');
1516: hr_utility.trace('time retrieve is FALSE for resource '||to_char(p_resource_id));
1517: hr_utility.trace('');
1518: END IF;
1519: END IF;
1520: */
1521:

Line 1544: hr_utility.trace('Resource '||p_resource_id||

1540: THEN
1541: -- If you need adjustments, log it down.
1542: IF(g_debug)
1543: THEN
1544: hr_utility.trace('Resource '||p_resource_id||
1545: ' had a different Rules evaluation preference earlier and needs adjustment this time');
1546: END IF;
1547: END IF;
1548: END IF;

Line 1576: g_debug := hr_utility.debug_enabled;

1572:
1573: l_overall_status hxc_transaction_details.status%TYPE;
1574:
1575: BEGIN
1576: g_debug := hr_utility.debug_enabled;
1577:
1578: IF ( g_debug ) THEN
1579: l_proc := g_package||'set_parent_statuses';
1580: hr_utility.set_location('Processing '||l_proc, 10);

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

1576: g_debug := hr_utility.debug_enabled;
1577:
1578: IF ( g_debug ) THEN
1579: l_proc := g_package||'set_parent_statuses';
1580: hr_utility.set_location('Processing '||l_proc, 10);
1581: END IF;
1582:
1583: IF ( ( hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1584: AND ( hxc_generic_retrieval_pkg.t_tx_time_bb_id.COUNT <> 0 )

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

1585: AND ( hxc_generic_retrieval_pkg.t_tx_day_bb_id.COUNT <> 0 ) )
1586: THEN
1587:
1588: IF ( g_debug ) THEN
1589: hr_utility.set_location('Processing '||l_proc, 20);
1590: END IF;
1591:
1592: -- loop through timecard statuses
1593:

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

1594: FOR time IN hxc_generic_retrieval_pkg.t_tx_time_bb_id.FIRST ..
1595: hxc_generic_retrieval_pkg.t_tx_time_bb_id.LAST
1596: LOOP
1597: IF ( g_debug ) THEN
1598: hr_utility.set_location('Processing '||l_proc, 30);
1599: END IF;
1600:
1601: l_day_parent := hxc_generic_retrieval_pkg.t_tx_time_bb_id(time);
1602: l_day_changed := TRUE;

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

1607:
1608: WHILE ( l_day_changed )
1609: LOOP
1610: IF ( g_debug ) THEN
1611: hr_utility.set_location('Processing '||l_proc, 40);
1612: END IF;
1613:
1614: -- store day index in day table indexed by day bb id
1615:

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

1619:
1620: IF ( l_day_index IS NOT NULL )
1621: THEN
1622: IF ( g_debug ) THEN
1623: hr_utility.set_location('Processing '||l_proc, 50);
1624: END IF;
1625:
1626: IF ( hxc_generic_retrieval_pkg.t_tx_day_parent_id(l_day_index) <> l_day_parent )
1627: THEN

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

1625:
1626: IF ( hxc_generic_retrieval_pkg.t_tx_day_parent_id(l_day_index) <> l_day_parent )
1627: THEN
1628: IF ( g_debug ) THEN
1629: hr_utility.set_location('Processing '||l_proc, 60);
1630: END IF;
1631:
1632: l_day_changed := FALSE;
1633: l_last_day_index := l_day_index;

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

1633: l_last_day_index := l_day_index;
1634: END IF;
1635: ELSE
1636: IF ( g_debug ) THEN
1637: hr_utility.set_location('Processing '||l_proc, 70);
1638: END IF;
1639:
1640: l_day_changed := FALSE;
1641: END IF;

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

1640: l_day_changed := FALSE;
1641: END IF;
1642:
1643: IF ( g_debug ) THEN
1644: hr_utility.set_location('Processing '||l_proc, 80);
1645: END IF;
1646:
1647: IF NOT ( l_day_changed )
1648: THEN

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

1646:
1647: IF NOT ( l_day_changed )
1648: THEN
1649: IF ( g_debug ) THEN
1650: hr_utility.set_location('Processing '||l_proc, 90);
1651: END IF;
1652:
1653: IF ( l_day_table.COUNT <> 0 )
1654: THEN

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

1652:
1653: IF ( l_day_table.COUNT <> 0 )
1654: THEN
1655: IF ( g_debug ) THEN
1656: hr_utility.set_location('Processing '||l_proc, 100);
1657: END IF;
1658:
1659: -- get detail statuses
1660:

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

1665:
1666: WHILE ( l_same_timecard )
1667: LOOP
1668: IF ( g_debug ) THEN
1669: hr_utility.set_location('Processing '||l_proc, 110);
1670: END IF;
1671:
1672: IF ( hxc_generic_retrieval_pkg.t_tx_detail_status(l_detail_index) = 'ERRORS' )
1673: THEN

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

1679: l_overall_status := 'SUCCESS';
1680: END IF;
1681:
1682: IF ( g_debug ) THEN
1683: hr_utility.set_location('Processing '||l_proc, 120);
1684: END IF;
1685:
1686: IF NOT ( l_day_table.EXISTS( hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index) ) )
1687: THEN

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

1685:
1686: IF NOT ( l_day_table.EXISTS( hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index) ) )
1687: THEN
1688: IF ( g_debug ) THEN
1689: hr_utility.set_location('Processing '||l_proc, 130);
1690: END IF;
1691:
1692: l_same_timecard := FALSE;
1693: l_last_detail_index := l_detail_index;

Line 1698: hr_utility.set_location('Processing '||l_proc, 140);

1694: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;
1695: l_day_table.DELETE;
1696: ELSE
1697: IF ( g_debug ) THEN
1698: hr_utility.set_location('Processing '||l_proc, 140);
1699: END IF;
1700:
1701:
1702: hxc_generic_retrieval_pkg.t_tx_day_status(l_day_table(hxc_generic_retrieval_pkg.t_tx_detail_parent_id(l_detail_index)).ind)

Line 1712: hr_utility.set_location('Processing '||l_proc, 150);

1708:
1709: IF ( l_detail_index IS NULL )
1710: THEN
1711: IF ( g_debug ) THEN
1712: hr_utility.set_location('Processing '||l_proc, 150);
1713: END IF;
1714:
1715: hxc_generic_retrieval_pkg.t_tx_time_status(time) := l_overall_status;
1716: l_same_timecard := FALSE;

Line 1733: hr_utility.set_location('Processing '||l_proc, 170);

1729:
1730: END IF; -- hxc_generic_retrieval_pkg.t_tx_detail_bb_id.COUNT <> 0 )
1731:
1732: IF ( g_debug ) THEN
1733: hr_utility.set_location('Processing '||l_proc, 170);
1734: END IF;
1735:
1736: END set_parent_statuses;
1737:

Line 1793: g_debug := hr_utility.debug_enabled;

1789: l_appl_id fnd_application.application_id%TYPE;
1790:
1791: BEGIN
1792:
1793: g_debug := hr_utility.debug_enabled;
1794:
1795: IF ( g_debug ) THEN
1796: l_proc := g_package||'recovery';
1797: hr_utility.set_location('Processing '||l_proc, 10);

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

1793: g_debug := hr_utility.debug_enabled;
1794:
1795: IF ( g_debug ) THEN
1796: l_proc := g_package||'recovery';
1797: hr_utility.set_location('Processing '||l_proc, 10);
1798:
1799: hr_utility.trace('process id is '||to_char(p_process_id));
1800: hr_utility.trace('process is '||p_process);
1801: END IF;

Line 1799: hr_utility.trace('process id is '||to_char(p_process_id));

1795: IF ( g_debug ) THEN
1796: l_proc := g_package||'recovery';
1797: hr_utility.set_location('Processing '||l_proc, 10);
1798:
1799: hr_utility.trace('process id is '||to_char(p_process_id));
1800: hr_utility.trace('process is '||p_process);
1801: END IF;
1802:
1803: WHILE NOT l_cleaned_up

Line 1800: hr_utility.trace('process is '||p_process);

1796: l_proc := g_package||'recovery';
1797: hr_utility.set_location('Processing '||l_proc, 10);
1798:
1799: hr_utility.trace('process id is '||to_char(p_process_id));
1800: hr_utility.trace('process is '||p_process);
1801: END IF;
1802:
1803: WHILE NOT l_cleaned_up
1804: LOOP

Line 1822: hr_utility.trace('Minimum Conc Date for PA is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));

1818: FETCH csr_chk_conc_request INTO l_req_date;
1819: CLOSE csr_chk_conc_request;
1820:
1821: IF ( g_debug ) THEN
1822: hr_utility.trace('Minimum Conc Date for PA is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));
1823: END IF;
1824:
1825: ELSIF ( p_process in ( 'BEE Retrieval Process', 'Apply Schedule Rules') )
1826: THEN

Line 1837: hr_utility.trace('Minimum Conc Date for BEE is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));

1833: FETCH csr_chk_conc_request INTO l_req_date;
1834: CLOSE csr_chk_conc_request;
1835:
1836: IF ( g_debug ) THEN
1837: hr_utility.trace('Minimum Conc Date for BEE is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));
1838: END IF;
1839:
1840: ELSIF ( p_process = 'Purchasing Retrieval Process' )
1841: THEN

Line 1852: hr_utility.trace('Minimum Conc Date for PO is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));

1848: FETCH csr_chk_conc_request INTO l_req_date;
1849: CLOSE csr_chk_conc_request;
1850:
1851: IF ( g_debug ) THEN
1852: hr_utility.trace('Minimum Conc Date for PO is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));
1853: END IF;
1854:
1855: ELSIF ( p_process = 'Maintenance Retrieval Process' )
1856: THEN

Line 1867: hr_utility.trace('Minimum Conc Date for EAM is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));

1863: FETCH csr_chk_conc_request INTO l_req_date;
1864: CLOSE csr_chk_conc_request;
1865:
1866: IF ( g_debug ) THEN
1867: hr_utility.trace('Minimum Conc Date for EAM is '||to_char(l_req_date,'DD-MON-YYYY HH24:MI:SS'));
1868: END IF;
1869:
1870: END IF;
1871:

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

1869:
1870: END IF;
1871:
1872: IF ( g_debug ) THEN
1873: hr_utility.set_location('Processing '||l_proc, 20);
1874: END IF;
1875:
1876: -- chk to see if there are any IN PROGRESS transactions for this retrieval process
1877: -- which were created before the minimum process date - these MUST be rogue

Line 1884: hr_utility.set_location('Processing '||l_proc, 25);

1880: OPEN csr_chk_for_in_progress ( l_req_date );
1881: FETCH csr_chk_for_in_progress INTO l_tx_rec;
1882:
1883: IF ( g_debug ) THEN
1884: hr_utility.set_location('Processing '||l_proc, 25);
1885: END IF;
1886:
1887: IF ( csr_chk_for_in_progress%FOUND )
1888: THEN

Line 1893: hr_utility.trace('Locking table');

1889: -- if we know there are outstanding transactions then lock the retrieval
1890: -- range table now to ensure no other processes are accessing it
1891:
1892: IF ( g_debug ) THEN
1893: hr_utility.trace('Locking table');
1894: END IF;
1895:
1896: l_locking_retrieval_ranges := TRUE;
1897:

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

1899:
1900: END IF;
1901:
1902: IF ( g_debug ) THEN
1903: hr_utility.set_location('Processing '||l_proc, 30);
1904: END IF;
1905:
1906: WHILE csr_chk_for_in_progress%FOUND
1907: LOOP

Line 1910: hr_utility.trace('tx id is '||to_char(l_tx_rec.transaction_id));

1906: WHILE csr_chk_for_in_progress%FOUND
1907: LOOP
1908:
1909: IF ( g_debug ) THEN
1910: hr_utility.trace('tx id is '||to_char(l_tx_rec.transaction_id));
1911: hr_utility.trace('tx date is '||to_char(l_tx_rec.transaction_date,'DD-MON-YYYY HH24:MI:SS'));
1912: END IF;
1913:
1914: l_tx_tab(l_tx_rec.transaction_id).run_date := l_tx_rec.transaction_date;

Line 1911: hr_utility.trace('tx date is '||to_char(l_tx_rec.transaction_date,'DD-MON-YYYY HH24:MI:SS'));

1907: LOOP
1908:
1909: IF ( g_debug ) THEN
1910: hr_utility.trace('tx id is '||to_char(l_tx_rec.transaction_id));
1911: hr_utility.trace('tx date is '||to_char(l_tx_rec.transaction_date,'DD-MON-YYYY HH24:MI:SS'));
1912: END IF;
1913:
1914: l_tx_tab(l_tx_rec.transaction_id).run_date := l_tx_rec.transaction_date;
1915:

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

1917:
1918: END LOOP;
1919:
1920: IF ( g_debug ) THEN
1921: hr_utility.set_location('Processing '||l_proc, 40);
1922: END IF;
1923:
1924: IF l_tx_tab.COUNT > 0
1925: THEN

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

1924: IF l_tx_tab.COUNT > 0
1925: THEN
1926:
1927: IF ( g_debug ) THEN
1928: hr_utility.set_location('Processing '||l_proc, 50);
1929: END IF;
1930:
1931: -- we have some rogue transactions - let's update them
1932:

Line 1939: hr_utility.trace('Updating tx id '||to_char(l_index));

1935: WHILE l_index IS NOT NULL
1936: LOOP
1937:
1938: IF ( g_debug ) THEN
1939: hr_utility.trace('Updating tx id '||to_char(l_index));
1940: END IF;
1941:
1942: UPDATE hxc_transactions tx
1943: SET tx.status = 'RECOVERED'

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

1957:
1958: -- COMMIT;
1959:
1960: IF ( g_debug ) THEN
1961: hr_utility.set_location('Processing '||l_proc, 60);
1962: END IF;
1963:
1964:
1965: END IF; -- l_tx_tab.COUNT > 0

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

1989:
1990: IF ( SQLCODE = '-54' )
1991: THEN
1992: IF ( g_debug ) THEN
1993: hr_utility.set_location('Processing '||l_proc, 70);
1994: END IF;
1995:
1996: IF ( l_locking_retrieval_ranges )
1997: THEN

Line 2009: hr_utility.trace('SQLERRM is '||SQLERRM);

2005: l_cnt := l_cnt + 1;
2006: ELSE
2007:
2008: IF ( g_debug ) THEN
2009: hr_utility.trace('SQLERRM is '||SQLERRM);
2010: END IF;
2011:
2012: raise;
2013: END IF;

Line 2134: hr_utility.trace('Absence Element - False');

2130: AND rownum < 2;
2131:
2132: IF (l_exists = 0) THEN
2133: IF g_debug THEN
2134: hr_utility.trace('Absence Element - False');
2135: END IF;
2136:
2137: RETURN FALSE;
2138: ELSE

Line 2140: hr_utility.trace('Absence Element - True');

2136:
2137: RETURN FALSE;
2138: ELSE
2139: IF g_debug THEN
2140: hr_utility.trace('Absence Element - True');
2141: END IF;
2142:
2143: RETURN TRUE;
2144: END IF;