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

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: Package Body hxc_setup_validation_pkg as
2: /* $Header: hxcotcvld.pkb 120.22.12020000.2 2012/07/20 06:59:58 pnshukla ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: --
7: --
8: -- ----------------------------------------------------------------------------

Line 236: g_debug := hr_utility.debug_enabled;

232: END test_aps_vs_rtr;
233:
234: BEGIN -- execute_otc_Validation
235:
236: g_debug := hr_utility.debug_enabled;
237:
238: if g_debug then
239: l_proc := g_package||'execute_otc_validation';
240: hr_utility.set_location('Processing '||l_proc, 10);

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

236: g_debug := hr_utility.debug_enabled;
237:
238: if g_debug then
239: l_proc := g_package||'execute_otc_validation';
240: hr_utility.set_location('Processing '||l_proc, 10);
241: end if;
242:
243: l_timecard_info_rec.resource_id := p_resource_id;
244: l_timecard_info_rec.timecard_bb_id := p_timecard_bb_id;

Line 261: hr_utility.trace('OTL Setup - app set id is '||to_char(l_app_set_id));

257: p_master_pref_table => p_master_pref_table );
258:
259: l_app_set_id := TO_NUMBER(l_pref_table(1).attribute1);
260: if g_debug then
261: hr_utility.trace('OTL Setup - app set id is '||to_char(l_app_set_id));
262: end if;
263:
264: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
265: p_preference_code => 'TS_PER_RETRIEVAL_RULES',

Line 273: hr_utility.trace('OTL Setup - rtr grp id is '||to_char(l_rtr_grp_id));

269: p_master_pref_table => p_master_pref_table );
270:
271: l_rtr_grp_id := TO_NUMBER(l_pref_table(1).attribute1);
272: if g_debug then
273: hr_utility.trace('OTL Setup - rtr grp id is '||to_char(l_rtr_grp_id));
274: end if;
275:
276: -- OTL - ABS Integration
277:

Line 289: hr_utility.trace('ABS: OTL Setup - Abs Integration is '||l_absences_integration);

285: p_master_pref_table => p_master_pref_table );
286:
287: l_absences_integration := l_pref_table(1).attribute1;
288: if g_debug then
289: hr_utility.trace('ABS: OTL Setup - Abs Integration is '||l_absences_integration);
290: end if;
291: -- Bug 8855103
292: -- Mid period pref changes should be disabled.
293: IF l_pref_table.COUNT > 0

Line 311: hr_utility.trace('PA-PAY> l_timecard_info_rec.resource_i ::'||l_timecard_info_rec.resource_id);

307:
308: --- Added for Bug 10326049
309: --- OTL - Projects Payroll Integration
310: IF g_debug THEN
311: hr_utility.trace('PA-PAY> l_timecard_info_rec.resource_i ::'||l_timecard_info_rec.resource_id);
312: hr_utility.trace('PA-PAY> l_timecard_info_rec.start_date ::'||l_timecard_info_rec.start_date);
313: hr_utility.trace('PA-PAY> l_timecard_info_rec.end_date ::'||l_timecard_info_rec.end_date);
314: END IF;
315:

Line 312: hr_utility.trace('PA-PAY> l_timecard_info_rec.start_date ::'||l_timecard_info_rec.start_date);

308: --- Added for Bug 10326049
309: --- OTL - Projects Payroll Integration
310: IF g_debug THEN
311: hr_utility.trace('PA-PAY> l_timecard_info_rec.resource_i ::'||l_timecard_info_rec.resource_id);
312: hr_utility.trace('PA-PAY> l_timecard_info_rec.start_date ::'||l_timecard_info_rec.start_date);
313: hr_utility.trace('PA-PAY> l_timecard_info_rec.end_date ::'||l_timecard_info_rec.end_date);
314: END IF;
315:
316: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

Line 313: hr_utility.trace('PA-PAY> l_timecard_info_rec.end_date ::'||l_timecard_info_rec.end_date);

309: --- OTL - Projects Payroll Integration
310: IF g_debug THEN
311: hr_utility.trace('PA-PAY> l_timecard_info_rec.resource_i ::'||l_timecard_info_rec.resource_id);
312: hr_utility.trace('PA-PAY> l_timecard_info_rec.start_date ::'||l_timecard_info_rec.start_date);
313: hr_utility.trace('PA-PAY> l_timecard_info_rec.end_date ::'||l_timecard_info_rec.end_date);
314: END IF;
315:
316: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
317: p_preference_code => 'TS_PA_PAY_INTG',

Line 325: hr_utility.trace('PA-PAY> OTL Setup - Projects Payroll Integration is '||l_proj_pay_integration);

321: p_master_pref_table => p_master_pref_table );
322:
323: l_proj_pay_integration := l_pref_table(1).attribute1;
324: if g_debug then
325: hr_utility.trace('PA-PAY> OTL Setup - Projects Payroll Integration is '||l_proj_pay_integration);
326: hr_utility.trace('PA-PAY> l_pref_table.COUNT ::'||l_pref_table.COUNT);
327: end if;
328:
329: IF l_pref_table.COUNT > 0

Line 326: hr_utility.trace('PA-PAY> l_pref_table.COUNT ::'||l_pref_table.COUNT);

322:
323: l_proj_pay_integration := l_pref_table(1).attribute1;
324: if g_debug then
325: hr_utility.trace('PA-PAY> OTL Setup - Projects Payroll Integration is '||l_proj_pay_integration);
326: hr_utility.trace('PA-PAY> l_pref_table.COUNT ::'||l_pref_table.COUNT);
327: end if;
328:
329: IF l_pref_table.COUNT > 0
330: THEN

Line 344: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is true');

340: END LOOP;
341: END IF;
342:
343: if l_mismatch_proj_pay then
344: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is true');
345: else
346: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is false');
347: end if;
348:

Line 346: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is false');

342:
343: if l_mismatch_proj_pay then
344: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is true');
345: else
346: hr_utility.trace('PA-PAY> l_mismatch_proj_pay is false');
347: end if;
348:
349:
350: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

Line 360: hr_utility.trace('OTL Setup - otm explosion is '||l_otm_explosion);

356:
357: l_otm_explosion := l_pref_table(1).attribute1;
358: l_otm_rtr_id := TO_NUMBER(l_pref_table(1).attribute2);
359: if g_debug then
360: hr_utility.trace('OTL Setup - otm explosion is '||l_otm_explosion);
361: end if;
362:
363: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
364: p_preference_code => 'TS_PER_APPROVAL_PERIODS',

Line 372: hr_utility.trace('OTL Setup - approval period set id is '||to_char(l_approval_period_set_id));

368: p_master_pref_table => p_master_pref_table );
369:
370: l_approval_period_set_id := TO_NUMBER(l_pref_table(1).attribute1);
371: if g_debug then
372: hr_utility.trace('OTL Setup - approval period set id is '||to_char(l_approval_period_set_id));
373: end if;
374:
375: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
376: p_preference_code => 'TS_PER_APPROVAL_STYLE',

Line 385: hr_utility.trace('OTL Setup - approval style id is '||to_char(l_approval_style_id));

381:
382: l_approval_style_id := TO_NUMBER(l_pref_table(1).attribute1);
383: l_override_approval_style_id := TO_NUMBER(l_pref_table(1).attribute2);
384: if g_debug then
385: hr_utility.trace('OTL Setup - approval style id is '||to_char(l_approval_style_id));
386: hr_utility.trace('OTL Setup - override approval style id is '||to_char(l_override_approval_style_id));
387: end if;
388:
389: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,

Line 386: hr_utility.trace('OTL Setup - override approval style id is '||to_char(l_override_approval_style_id));

382: l_approval_style_id := TO_NUMBER(l_pref_table(1).attribute1);
383: l_override_approval_style_id := TO_NUMBER(l_pref_table(1).attribute2);
384: if g_debug then
385: hr_utility.trace('OTL Setup - approval style id is '||to_char(l_approval_style_id));
386: hr_utility.trace('OTL Setup - override approval style id is '||to_char(l_override_approval_style_id));
387: end if;
388:
389: hxc_preference_evaluation.resource_preferences(p_resource_id => l_timecard_info_rec.resource_id,
390: p_preference_code => 'TC_W_TCRD_ST_ALW_EDITS',

Line 400: hr_utility.trace('OTL Setup - status allowing edits is '||l_status_allowing_edits);

396: l_status_allowing_edits := l_pref_table(1).attribute1;
397: l_past_limit_date := l_pref_table(1).attribute6;
398: l_futur_limit_date := l_pref_table(1).attribute11;
399: if g_debug then
400: hr_utility.trace('OTL Setup - status allowing edits is '||l_status_allowing_edits);
401: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);
402: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);
403: end if;
404:

Line 401: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);

397: l_past_limit_date := l_pref_table(1).attribute6;
398: l_futur_limit_date := l_pref_table(1).attribute11;
399: if g_debug then
400: hr_utility.trace('OTL Setup - status allowing edits is '||l_status_allowing_edits);
401: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);
402: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);
403: end if;
404:
405: --ELP Validation

Line 402: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);

398: l_futur_limit_date := l_pref_table(1).attribute11;
399: if g_debug then
400: hr_utility.trace('OTL Setup - status allowing edits is '||l_status_allowing_edits);
401: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);
402: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);
403: end if;
404:
405: --ELP Validation
406:

Line 416: hr_utility.trace('OTL Setup- ELP TERG is ' || to_char(l_elp_terg_id));

412: p_master_pref_table => p_master_pref_table );
413:
414: l_elp_terg_id := TO_NUMBER(l_pref_table(1).attribute1);
415: if g_debug then
416: hr_utility.trace('OTL Setup- ELP TERG is ' || to_char(l_elp_terg_id));
417: end if;
418:
419: -- Override Approval Validation
420:

Line 455: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);

451: l_futur_limit_date := to_char((sysdate + to_number(l_futur_limit_date)),'YYYY/MM/DD');
452: END IF;
453:
454: if g_debug then
455: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);
456: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);
457: end if;
458:
459: if g_debug then

Line 456: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);

452: END IF;
453:
454: if g_debug then
455: hr_utility.trace('OTL Setup - past limit date is '||l_past_limit_date);
456: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);
457: end if;
458:
459: if g_debug then
460: hr_utility.set_location('Processing '||l_proc, 20);

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

456: hr_utility.trace('OTL Setup - futur limit date is '||l_futur_limit_date);
457: end if;
458:
459: if g_debug then
460: hr_utility.set_location('Processing '||l_proc, 20);
461: end if;
462:
463: -- Bug 12310566
464: -- OTL - Projects Payroll Integration

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

546:
547: WHILE csr_get_retrieval_rules%FOUND
548: LOOP
549: if g_debug then
550: hr_utility.set_location('Processing '||l_proc, 25);
551: end if;
552:
553: t_rtr_tr(l_rtr_tr_id).dummy := 'N';
554:

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

558:
559: CLOSE csr_get_retrieval_rules;
560:
561: if g_debug then
562: hr_utility.set_location('Processing '||l_proc, 30);
563: end if;
564:
565: OPEN csr_get_app_sets ( l_app_set_id );
566: FETCH csr_get_app_sets INTO l_aps_tr_id;

Line 571: hr_utility.set_location('Processing '||l_proc, 35);

567:
568: WHILE csr_get_app_sets%FOUND
569: LOOP
570: if g_debug then
571: hr_utility.set_location('Processing '||l_proc, 35);
572: end if;
573:
574: t_aps_tr(l_aps_tr_id).dummy := 'N';
575:

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

579:
580: CLOSE csr_get_app_sets;
581:
582: if g_debug then
583: hr_utility.set_location('Processing '||l_proc, 40);
584: end if;
585:
586: -- now test to see if the retrieval rule group time recipients
587: -- is at least a subset of the application set time recipients

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

604:
605: END IF;
606:
607: if g_debug then
608: hr_utility.set_location('Processing '||l_proc, 50);
609: end if;
610:
611: -- now get the time recipients associated with the
612: -- OTM Evaluation rtr if the person has their

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

614:
615: IF ( l_otm_explosion = 'Y' )
616: THEN
617: if g_debug then
618: hr_utility.set_location('Processing '||l_proc, 55);
619: end if;
620:
621: IF ( l_otm_rtr_id IS NULL )
622: THEN

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

620:
621: IF ( l_otm_rtr_id IS NULL )
622: THEN
623: if g_debug then
624: hr_utility.set_location('Processing '||l_proc, 60);
625: end if;
626:
627: raise e_no_rtr_id;
628:

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

628:
629: END IF;
630:
631: if g_debug then
632: hr_utility.set_location('Processing '||l_proc, 70);
633: end if;
634:
635: t_rtr_tr.DELETE;
636:

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

639:
640: WHILE csr_get_rtr%FOUND
641: LOOP
642: if g_debug then
643: hr_utility.set_location('Processing '||l_proc, 80);
644: end if;
645:
646: t_rtr_tr(l_rtr_tr_id).dummy := 'N';
647:

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

651:
652: CLOSE csr_get_rtr;
653:
654: if g_debug then
655: hr_utility.set_location('Processing '||l_proc, 90);
656: end if;
657:
658: -- now test to see if the retrieval rule group time recipients
659: -- is at least a subset of the application set time recipients

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

677: END IF;
678:
679:
680: if g_debug then
681: hr_utility.set_location('Processing '||l_proc, 100);
682: end if;
683:
684: END IF; -- IF ( l_otm_explosion = 'Y' ) GPM v115.19
685:

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

683:
684: END IF; -- IF ( l_otm_explosion = 'Y' ) GPM v115.19
685:
686: if g_debug then
687: hr_utility.set_location('Processing '||l_proc, 130);
688: end if;
689:
690: -- test that the applications in the application set have a corresponding
691: -- period in the Approval Periods Group

Line 699: hr_utility.trace('Here is the time recipient '||to_char(l_index));

695: WHILE ( l_index IS NOT NULL )
696: LOOP
697:
698: if g_debug then
699: hr_utility.trace('Here is the time recipient '||to_char(l_index));
700:
701: hr_utility.set_location('Processing '||l_proc, 140);
702: end if;
703:

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

697:
698: if g_debug then
699: hr_utility.trace('Here is the time recipient '||to_char(l_index));
700:
701: hr_utility.set_location('Processing '||l_proc, 140);
702: end if;
703:
704: OPEN csr_get_app_rec_period(l_index, l_approval_period_set_id);
705: FETCH csr_get_app_rec_period into l_dummy;

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

706:
707: IF csr_get_app_rec_period%NOTFOUND
708: THEN
709: if g_debug then
710: hr_utility.set_location('Processing '||l_proc, 150);
711: end if;
712:
713: hxc_timecard_message_helper.adderrortocollection (
714: p_messages => p_messages

Line 734: hr_utility.set_location('Processing '||l_proc, 160);

730:
731: CLOSE csr_get_app_rec_period;
732:
733: if g_debug then
734: hr_utility.set_location('Processing '||l_proc, 160);
735: end if;
736:
737: l_index := t_aps_tr.NEXT(l_index);
738:

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

738:
739: END LOOP; -- t_aps_tr
740:
741: if g_debug then
742: hr_utility.set_location('Processing '||l_proc, 170);
743: end if;
744:
745:
746: -- tests that the time recipients in the application set have

Line 755: hr_utility.set_location('Processing '||l_proc, 180);

751: WHILE ( l_index IS NOT NULL )
752: LOOP
753:
754: if g_debug then
755: hr_utility.set_location('Processing '||l_proc, 180);
756: end if;
757:
758: OPEN csr_get_approval_style_comps(l_index, l_approval_style_id);
759: FETCH csr_get_approval_style_comps into l_dummy;

Line 764: hr_utility.set_location('Processing '||l_proc, 190);

760:
761: IF csr_get_approval_style_comps%NOTFOUND
762: THEN
763: if g_debug then
764: hr_utility.set_location('Processing '||l_proc, 190);
765: end if;
766:
767: hxc_timecard_message_helper.adderrortocollection (
768: p_messages => p_messages

Line 788: hr_utility.set_location('Processing '||l_proc, 200);

784:
785: CLOSE csr_get_approval_style_comps;
786:
787: if g_debug then
788: hr_utility.set_location('Processing '||l_proc, 200);
789: end if;
790:
791: l_index := t_aps_tr.NEXT(l_index);
792:

Line 804: hr_utility.set_location('Processing '||l_proc, 201);

800: l_index := t_aps_tr.FIRST;
801: WHILE ( l_index IS NOT NULL ) LOOP
802:
803: if g_debug then
804: hr_utility.set_location('Processing '||l_proc, 201);
805: end if;
806: OPEN csr_get_approval_style_comps(l_index, l_override_approval_style_id);
807: FETCH csr_get_approval_style_comps into l_dummy;
808:

Line 811: hr_utility.set_location('Processing '||l_proc, 202);

807: FETCH csr_get_approval_style_comps into l_dummy;
808:
809: IF csr_get_approval_style_comps%NOTFOUND THEN
810: if g_debug then
811: hr_utility.set_location('Processing '||l_proc, 202);
812: end if;
813:
814: hxc_timecard_message_helper.adderrortocollection
815: (p_messages => p_messages,

Line 836: hr_utility.set_location('Processing '||l_proc, 203);

832:
833: CLOSE csr_get_approval_style_comps;
834:
835: if g_debug then
836: hr_utility.set_location('Processing '||l_proc, 203);
837: end if;
838:
839: l_index := t_aps_tr.NEXT(l_index);
840:

Line 845: hr_utility.set_location('Processing '||l_proc, 210);

841: END LOOP; -- t_aps_tr
842: end if; -- Is the Override Style set?
843:
844: if g_debug then
845: hr_utility.set_location('Processing '||l_proc, 210);
846: end if;
847:
848: --ELP Validation
849: -- tests that the time recipients in the application set have

Line 859: hr_utility.set_location('Processing '||l_proc, 211);

855: WHILE ( l_index IS NOT NULL )
856: LOOP
857:
858: if g_debug then
859: hr_utility.set_location('Processing '||l_proc, 211);
860: end if;
861:
862: OPEN csr_get_elp_terg_comps(l_elp_terg_id,l_index);
863: FETCH csr_get_elp_terg_comps into l_dummy;

Line 868: hr_utility.set_location('Processing '||l_proc, 212);

864:
865: IF csr_get_elp_terg_comps%NOTFOUND
866: THEN
867: if g_debug then
868: hr_utility.set_location('Processing '||l_proc, 212);
869: end if;
870:
871: hxc_timecard_message_helper.adderrortocollection (
872: p_messages => p_messages

Line 892: hr_utility.set_location('Processing '||l_proc, 213);

888:
889: CLOSE csr_get_elp_terg_comps;
890:
891: if g_debug then
892: hr_utility.set_location('Processing '||l_proc, 213);
893: end if;
894:
895: l_index := t_aps_tr.NEXT(l_index);
896:

Line 901: hr_utility.set_location('Processing '||l_proc, 214);

897: END LOOP; -- t_aps_tr
898:
899: END IF;
900: if g_debug then
901: hr_utility.set_location('Processing '||l_proc, 214);
902: end if;
903:
904: -- Now let's check to see if the user is still allowed to update the timecard
905: -- WWB 2290884