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

Line 41: g_debug boolean := hr_utility.debug_enabled;

37: is expired, send backout transaction to PayMIX.
38:
39: Step 5. Set rows on timecard to pay_status='C' if pay_status='R'.
40: */
41: g_debug boolean := hr_utility.debug_enabled;
42:
43: -- Bug 12919783
44: -- New type and new variable
45: TYPE NUMTABLE IS TABLE OF NUMBER INDEX BY VARCHAR2(20);

Line 309: hr_utility.set_location ('insert_pay_batch_lines', 10);

305: lv_pbl_flag VARCHAR2 (1) := 'N';
306: BEGIN
307:
308: if g_debug then
309: hr_utility.set_location ('insert_pay_batch_lines', 10);
310: end if;
311:
312: -- Initialize tables
313: FOR i IN 1 .. 15

Line 389: hr_utility.set_location ('insert_pay_batch_lines', 20);

385: hxt_value(14).otl_sequence,
386: hxt_value(15).otl_sequence
387: );
388: if g_debug then
389: hr_utility.set_location ('insert_pay_batch_lines', 20);
390: end if;
391: -- Place OTM data into BEE values per input values
392: hxt_util.DEBUG ('Putting OTM data into BEE values per input values'); --HXT115
393:

Line 423: hr_utility.set_location ('insert_pay_batch_lines', 30);

419: -- the further logic on the screen value for the input values.
420: --
421: lv_pbl_flag := 'N';
422: if g_debug then
423: hr_utility.set_location ('insert_pay_batch_lines', 30);
424:
425: hr_utility.TRACE (
426: 'hxt_value_name_'
427: || TO_CHAR (i)

Line 425: hr_utility.TRACE (

421: lv_pbl_flag := 'N';
422: if g_debug then
423: hr_utility.set_location ('insert_pay_batch_lines', 30);
424:
425: hr_utility.TRACE (
426: 'hxt_value_name_'
427: || TO_CHAR (i)
428: || ' :'
429: || hxt_value (i).NAME

Line 431: hr_utility.TRACE ( 'p_date_worked:'

427: || TO_CHAR (i)
428: || ' :'
429: || hxt_value (i).NAME
430: );
431: hr_utility.TRACE ( 'p_date_worked:'
432: || p_date_worked);
433: end if;
434: l_value_meaning :=
435: get_lookup_code (hxt_value (i).NAME, p_date_worked);

Line 437: hr_utility.TRACE ( 'l_value_meaning :'

433: end if;
434: l_value_meaning :=
435: get_lookup_code (hxt_value (i).NAME, p_date_worked);
436: if g_debug then
437: hr_utility.TRACE ( 'l_value_meaning :'
438: || l_value_meaning);
439: end if;
440: --if hxt_value(i).name = 'Hours' then
441: IF l_value_meaning = 'HOURS'

Line 444: hr_utility.set_location ('insert_pay_batch_lines', 40);

440: --if hxt_value(i).name = 'Hours' then
441: IF l_value_meaning = 'HOURS'
442: THEN
443: if g_debug then
444: hr_utility.set_location ('insert_pay_batch_lines', 40);
445: end if;
446: pbl_value (i) :=
447: convert_lookup (p_hours, hxt_value (i).lookup, p_date_worked);
448: if g_debug then

Line 449: hr_utility.TRACE (

445: end if;
446: pbl_value (i) :=
447: convert_lookup (p_hours, hxt_value (i).lookup, p_date_worked);
448: if g_debug then
449: hr_utility.TRACE (
450: 'pbl_value_'
451: || TO_CHAR (i)
452: || ' :'
453: || pbl_value (i)

Line 460: hr_utility.set_location ('insert_pay_batch_lines', 50);

456: --elsif hxt_value(i).name = 'Pay Value' then
457: ELSIF l_value_meaning = 'AMOUNT'
458: THEN
459: if g_debug then
460: hr_utility.set_location ('insert_pay_batch_lines', 50);
461: end if;
462: pbl_value (i) :=
463: convert_lookup (p_amount, hxt_value (i).lookup, p_date_worked);
464: if g_debug then

Line 465: hr_utility.TRACE (

461: end if;
462: pbl_value (i) :=
463: convert_lookup (p_amount, hxt_value (i).lookup, p_date_worked);
464: if g_debug then
465: hr_utility.TRACE (
466: 'pbl_value_'
467: || TO_CHAR (i)
468: || ' :'
469: || pbl_value (i)

Line 476: hr_utility.set_location ('insert_pay_batch_lines', 60);

472: --elsif hxt_value(i).name = 'Multiple' then
473: ELSIF l_value_meaning = 'RATE_MULTIPLE'
474: THEN
475: if g_debug then
476: hr_utility.set_location ('insert_pay_batch_lines', 60);
477: end if;
478: pbl_value (i) := convert_lookup (
479: p_rate_multiple,
480: hxt_value (i).lookup,

Line 485: hr_utility.TRACE (

481: p_date_worked
482: );
483:
484: if g_debug then
485: hr_utility.TRACE (
486: 'pbl_value_'
487: || TO_CHAR (i)
488: || ' :'
489: || pbl_value (i)

Line 496: hr_utility.set_location ('insert_pay_batch_lines', 70);

492:
493: ELSIF l_value_meaning = 'HOURLY_RATE'
494: THEN
495: if g_debug then
496: hr_utility.set_location ('insert_pay_batch_lines', 70);
497: end if;
498: pbl_value (i) := convert_lookup (
499: p_hourly_rate,
500: hxt_value (i).lookup,

Line 505: hr_utility.TRACE (

501: p_date_worked
502: );
503: if g_debug then
504:
505: hr_utility.TRACE (
506: 'pbl_value_'
507: || TO_CHAR (i)
508: || ' :'
509: || pbl_value (i)

Line 518: hr_utility.set_location ('insert_pay_batch_lines', 70);

514: --elsif hxt_value(i).name = 'Rate' then
515: ELSIF l_value_meaning = 'RATE'
516: THEN
517: if g_debug then
518: hr_utility.set_location ('insert_pay_batch_lines', 70);
519: end if;
520: pbl_value (i) := convert_lookup (
521: p_hourly_rate,
522: hxt_value (i).lookup,

Line 527: hr_utility.TRACE (

523: p_date_worked
524: );
525: if g_debug then
526:
527: hr_utility.TRACE (
528: 'pbl_value_'
529: || TO_CHAR (i)
530: || ' :'
531: || pbl_value (i)

Line 538: hr_utility.set_location ('insert_pay_batch_lines', 80);

534: --elsif hxt_value(i).name = 'Rate Code' then
535: ELSIF l_value_meaning = 'RATE_CODE'
536: THEN
537: if g_debug then
538: hr_utility.set_location ('insert_pay_batch_lines', 80);
539: end if;
540: pbl_value (i) := convert_lookup (
541: p_rate_code,
542: hxt_value (i).lookup,

Line 546: hr_utility.TRACE (

542: hxt_value (i).lookup,
543: p_date_worked
544: );
545: if g_debug then
546: hr_utility.TRACE (
547: 'pbl_value_'
548: || TO_CHAR (i)
549: || ' :'
550: || pbl_value (i)

Line 558: hr_utility.set_location ('insert_pay_batch_lines', 90);

554: -- BEGIN US localization
555: ELSIF hxt_value (i).NAME = 'Jurisdiction'
556: THEN
557: if g_debug then
558: hr_utility.set_location ('insert_pay_batch_lines', 90);
559: end if;
560:
561: if(p_state_name is not null or
562: p_county_name is not null or

Line 579: hr_utility.TRACE (

575: p_date_worked
576: );
577: end if;
578: if g_debug then
579: hr_utility.TRACE (
580: 'pbl_value_'
581: || TO_CHAR (i)
582: || ' :'
583: || pbl_value (i)

Line 589: hr_utility.set_location ('insert_pay_batch_lines', 100);

585: end if;
586: ELSIF hxt_value (i).NAME = 'Deduction Processing'
587: THEN
588: if g_debug then
589: hr_utility.set_location ('insert_pay_batch_lines', 100);
590: end if;
591: pbl_value (i) := convert_lookup (
592: p_tax_separately_flag,
593: hxt_value (i).lookup,

Line 597: hr_utility.TRACE (

593: hxt_value (i).lookup,
594: p_date_worked
595: );
596: if g_debug then
597: hr_utility.TRACE (
598: 'pbl_value_'
599: || TO_CHAR (i)
600: || ' :'
601: || pbl_value (i)

Line 607: hr_utility.set_location ('insert_pay_batch_lines', 110);

603: end if;
604: ELSIF hxt_value (i).NAME = 'Separate Check'
605: THEN
606: if g_debug then
607: hr_utility.set_location ('insert_pay_batch_lines', 110);
608: end if;
609: pbl_value (i) := convert_lookup (
610: p_separate_check_flag,
611: hxt_value (i).lookup,

Line 615: hr_utility.TRACE (

611: hxt_value (i).lookup,
612: p_date_worked
613: );
614: if g_debug then
615: hr_utility.TRACE (
616: 'pbl_value_'
617: || TO_CHAR (i)
618: || ' :'
619: || pbl_value (i)

Line 628: hr_utility.set_location ('insert_pay_batch_lines', 120);

624:
625: ELSIF hxt_value (i).NAME IS NOT NULL
626: THEN -- pbl_value(i) := NULL;
627: if g_debug then
628: hr_utility.set_location ('insert_pay_batch_lines', 120);
629: hr_utility.TRACE ( 'p_element_type_id :'
630: || p_element_type_id);
631: hr_utility.TRACE ( 'p_assignment_id :'
632: || p_assignment_id);

Line 629: hr_utility.TRACE ( 'p_element_type_id :'

625: ELSIF hxt_value (i).NAME IS NOT NULL
626: THEN -- pbl_value(i) := NULL;
627: if g_debug then
628: hr_utility.set_location ('insert_pay_batch_lines', 120);
629: hr_utility.TRACE ( 'p_element_type_id :'
630: || p_element_type_id);
631: hr_utility.TRACE ( 'p_assignment_id :'
632: || p_assignment_id);
633: hr_utility.TRACE ( 'p_date_worked :'

Line 631: hr_utility.TRACE ( 'p_assignment_id :'

627: if g_debug then
628: hr_utility.set_location ('insert_pay_batch_lines', 120);
629: hr_utility.TRACE ( 'p_element_type_id :'
630: || p_element_type_id);
631: hr_utility.TRACE ( 'p_assignment_id :'
632: || p_assignment_id);
633: hr_utility.TRACE ( 'p_date_worked :'
634: || p_date_worked);
635: end if;

Line 633: hr_utility.TRACE ( 'p_date_worked :'

629: hr_utility.TRACE ( 'p_element_type_id :'
630: || p_element_type_id);
631: hr_utility.TRACE ( 'p_assignment_id :'
632: || p_assignment_id);
633: hr_utility.TRACE ( 'p_date_worked :'
634: || p_date_worked);
635: end if;
636: OPEN c_date_input_value (
637: p_element_type_id,

Line 644: hr_utility.set_location ('insert_pay_batch_lines', 130);

640: );
641:
642: LOOP
643: if g_debug then
644: hr_utility.set_location ('insert_pay_batch_lines', 130);
645: end if;
646: FETCH c_date_input_value INTO l_piv_name;
647: EXIT WHEN c_date_input_value%NOTFOUND;
648: if g_debug then

Line 649: hr_utility.TRACE ( 'l_piv_name :'

645: end if;
646: FETCH c_date_input_value INTO l_piv_name;
647: EXIT WHEN c_date_input_value%NOTFOUND;
648: if g_debug then
649: hr_utility.TRACE ( 'l_piv_name :'
650: || l_piv_name);
651: hr_utility.TRACE ( 'lv_pbl_flag :'
652: || lv_pbl_flag);
653: end if;

Line 651: hr_utility.TRACE ( 'lv_pbl_flag :'

647: EXIT WHEN c_date_input_value%NOTFOUND;
648: if g_debug then
649: hr_utility.TRACE ( 'l_piv_name :'
650: || l_piv_name);
651: hr_utility.TRACE ( 'lv_pbl_flag :'
652: || lv_pbl_flag);
653: end if;
654:
655: IF l_piv_name = hxt_value (i).NAME

Line 658: hr_utility.set_location ('insert_pay_batch_lines', 140);

654:
655: IF l_piv_name = hxt_value (i).NAME
656: THEN
657: if g_debug then
658: hr_utility.set_location ('insert_pay_batch_lines', 140);
659: end if;
660: --pbl_value(i) := to_char(p_date_worked,'DD-MON-YYYY');
661: pbl_value (i) := fnd_date.date_to_canonical (p_date_worked);
662: lv_pbl_flag := 'Y';

Line 664: hr_utility.TRACE (

660: --pbl_value(i) := to_char(p_date_worked,'DD-MON-YYYY');
661: pbl_value (i) := fnd_date.date_to_canonical (p_date_worked);
662: lv_pbl_flag := 'Y';
663: if g_debug then
664: hr_utility.TRACE (
665: 'pbl_value_'
666: || TO_CHAR (i)
667: || ' :'
668: || pbl_value (i)

Line 693: hr_utility.trace('Coming into new code as if profile is turned OFF');

689: -- Added code here
690: AND NVL(FND_PROFILE.VALUE('HXT_ALLOW_SUM_CUSTOM_ATTRIBUTE'),'N') = 'N'
691: THEN
692:
693: hr_utility.trace('Coming into new code as if profile is turned OFF');
694:
695: IF g_debug
696: AND g_xiv_table.EXISTS(TO_CHAR(p_parent_id))
697: THEN

Line 698: hr_utility.trace('IV : It came out here ');

694:
695: IF g_debug
696: AND g_xiv_table.EXISTS(TO_CHAR(p_parent_id))
697: THEN
698: hr_utility.trace('IV : It came out here ');
699: hr_utility.trace('IV : i = '||i);
700: hr_utility.trace('IV : '||g_xiv_table(TO_CHAR(p_parent_id)).attribute1);
701: END IF;
702:

Line 699: hr_utility.trace('IV : i = '||i);

695: IF g_debug
696: AND g_xiv_table.EXISTS(TO_CHAR(p_parent_id))
697: THEN
698: hr_utility.trace('IV : It came out here ');
699: hr_utility.trace('IV : i = '||i);
700: hr_utility.trace('IV : '||g_xiv_table(TO_CHAR(p_parent_id)).attribute1);
701: END IF;
702:
703: IF g_xiv_table.EXISTS(TO_CHAR(p_parent_id))

Line 700: hr_utility.trace('IV : '||g_xiv_table(TO_CHAR(p_parent_id)).attribute1);

696: AND g_xiv_table.EXISTS(TO_CHAR(p_parent_id))
697: THEN
698: hr_utility.trace('IV : It came out here ');
699: hr_utility.trace('IV : i = '||i);
700: hr_utility.trace('IV : '||g_xiv_table(TO_CHAR(p_parent_id)).attribute1);
701: END IF;
702:
703: IF g_xiv_table.EXISTS(TO_CHAR(p_parent_id))
704: THEN

Line 806: hr_utility.set_location ('insert_pay_batch_lines', 150);

802:
803: IF lv_pbl_flag = 'N'
804: THEN
805: if g_debug then
806: hr_utility.set_location ('insert_pay_batch_lines', 150);
807: end if;
808: pbl_value (i) := NULL;
809: if g_debug then
810: hr_utility.TRACE (

Line 810: hr_utility.TRACE (

806: hr_utility.set_location ('insert_pay_batch_lines', 150);
807: end if;
808: pbl_value (i) := NULL;
809: if g_debug then
810: hr_utility.TRACE (
811: 'pbl_value_'
812: || TO_CHAR (i)
813: || ' :'
814: || pbl_value (i)

Line 820: hr_utility.TRACE ( 'lv_pbl_flag :'

816: end if;
817: END IF;
818:
819: if g_debug then
820: hr_utility.TRACE ( 'lv_pbl_flag :'
821: || lv_pbl_flag);
822: end if;
823: ELSE
824: if g_debug then

Line 825: hr_utility.set_location ('insert_pay_batch_lines', 160);

821: || lv_pbl_flag);
822: end if;
823: ELSE
824: if g_debug then
825: hr_utility.set_location ('insert_pay_batch_lines', 160);
826: end if;
827: pbl_value (i) := NULL;
828: if g_debug then
829: hr_utility.TRACE (

Line 829: hr_utility.TRACE (

825: hr_utility.set_location ('insert_pay_batch_lines', 160);
826: end if;
827: pbl_value (i) := NULL;
828: if g_debug then
829: hr_utility.TRACE (
830: 'pbl_value_'
831: || TO_CHAR (i)
832: || ' :'
833: || pbl_value (i)

Line 839: hr_utility.set_location ('insert_pay_batch_lines', 170);

835: end if;
836: END IF;
837:
838: if g_debug then
839: hr_utility.set_location ('insert_pay_batch_lines', 170);
840: end if;
841: hxt_util.DEBUG ( 'value_'
842: || TO_CHAR (i)
843: || ' = '

Line 1611: hr_utility.trace('parent = '||l_hours_rec.parent_id);

1607: CLOSE get_input_values;
1608: IF g_xiv_table.EXISTS(TO_CHAR(l_hours_rec.parent_id))
1609: AND g_debug
1610: THEN
1611: hr_utility.trace('parent = '||l_hours_rec.parent_id);
1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );
1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );

Line 1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );

1608: IF g_xiv_table.EXISTS(TO_CHAR(l_hours_rec.parent_id))
1609: AND g_debug
1610: THEN
1611: hr_utility.trace('parent = '||l_hours_rec.parent_id);
1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );
1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );

Line 1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );

1609: AND g_debug
1610: THEN
1611: hr_utility.trace('parent = '||l_hours_rec.parent_id);
1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );
1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );

Line 1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );

1610: THEN
1611: hr_utility.trace('parent = '||l_hours_rec.parent_id);
1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );
1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );

Line 1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );

1611: hr_utility.trace('parent = '||l_hours_rec.parent_id);
1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );
1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );

Line 1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );

1612: hr_utility.trace('attribute 1 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute1 );
1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );

Line 1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );

1613: hr_utility.trace('attribute 2 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute2 );
1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );

Line 1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );

1614: hr_utility.trace('attribute 3 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute3 );
1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );

Line 1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );

1615: hr_utility.trace('attribute 4 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute4 );
1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );

Line 1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );

1616: hr_utility.trace('attribute 5 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute5 );
1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );

Line 1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );

1617: hr_utility.trace('attribute 6 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute6 );
1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );
1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );

Line 1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );

1618: hr_utility.trace('attribute 7 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute7 );
1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );
1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );
1626: hr_utility.trace('attribute 15 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute15 );

Line 1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );

1619: hr_utility.trace('attribute 8 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute8 );
1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );
1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );
1626: hr_utility.trace('attribute 15 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute15 );
1627: END IF;

Line 1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );

1620: hr_utility.trace('attribute 9 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute9 );
1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );
1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );
1626: hr_utility.trace('attribute 15 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute15 );
1627: END IF;
1628:

Line 1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );

1621: hr_utility.trace('attribute 10 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute10 );
1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );
1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );
1626: hr_utility.trace('attribute 15 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute15 );
1627: END IF;
1628:
1629:

Line 1626: hr_utility.trace('attribute 15 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute15 );

1622: hr_utility.trace('attribute 11 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute11 );
1623: hr_utility.trace('attribute 12 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute12 );
1624: hr_utility.trace('attribute 13 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute13 );
1625: hr_utility.trace('attribute 14 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute14 );
1626: hr_utility.trace('attribute 15 ='||g_xiv_table(TO_CHAR(l_hours_rec.parent_id)).attribute15 );
1627: END IF;
1628:
1629:
1630:

Line 4095: hr_utility.trace('Started here ');

4091:
4092: BEGIN
4093:
4094:
4095: hr_utility.trace('Started here ');
4096: IF g_debug
4097: THEN
4098: hr_utility.trace('Starting to Rollback batch '||p_batch_id);
4099: hr_utility.trace('Tim_id '||p_tim_id);

Line 4098: hr_utility.trace('Starting to Rollback batch '||p_batch_id);

4094:
4095: hr_utility.trace('Started here ');
4096: IF g_debug
4097: THEN
4098: hr_utility.trace('Starting to Rollback batch '||p_batch_id);
4099: hr_utility.trace('Tim_id '||p_tim_id);
4100: END IF;
4101:
4102:

Line 4099: hr_utility.trace('Tim_id '||p_tim_id);

4095: hr_utility.trace('Started here ');
4096: IF g_debug
4097: THEN
4098: hr_utility.trace('Starting to Rollback batch '||p_batch_id);
4099: hr_utility.trace('Tim_id '||p_tim_id);
4100: END IF;
4101:
4102:
4103: -- First Pick up any backout that happened now, but not been touched when

Line 4125: hr_utility.trace('First kind of backouts exist ');

4121: THEN
4122:
4123: IF g_debug
4124: THEN
4125: hr_utility.trace('First kind of backouts exist ');
4126: hr_utility.trace('Count := '||l_rowidtab.COUNT);
4127: END IF;
4128:
4129: FORALL i IN l_rowidtab.FIRST..l_line_tab.LAST

Line 4126: hr_utility.trace('Count := '||l_rowidtab.COUNT);

4122:
4123: IF g_debug
4124: THEN
4125: hr_utility.trace('First kind of backouts exist ');
4126: hr_utility.trace('Count := '||l_rowidtab.COUNT);
4127: END IF;
4128:
4129: FORALL i IN l_rowidtab.FIRST..l_line_tab.LAST
4130: UPDATE hxc_ret_pay_latest_details

Line 4147: hr_utility.trace('Reached here2 ');

4143: batch_id = NULL
4144: WHERE ROWID = CHARTOROWID(l_rowidtab(i));
4145: END IF;
4146:
4147: hr_utility.trace('Reached here2 ');
4148:
4149:
4150: IF g_debug
4151: THEN

Line 4152: hr_utility.trace('Marked first backouts ');

4148:
4149:
4150: IF g_debug
4151: THEN
4152: hr_utility.trace('Marked first backouts ');
4153: END IF;
4154:
4155:
4156: -- Next, pickup any backouts due to changes that happened in the latest explosion.

Line 4173: hr_utility.trace('Second type of backouts exist');

4169: IF l_rowidtab.COUNT > 0
4170: THEN
4171: IF g_debug
4172: THEN
4173: hr_utility.trace('Second type of backouts exist');
4174: hr_utility.trace('Count '||l_rowidtab.COUNT);
4175: END IF;
4176:
4177: FORALL i IN l_rowidtab.FIRST..l_line_tab.LAST

Line 4174: hr_utility.trace('Count '||l_rowidtab.COUNT);

4170: THEN
4171: IF g_debug
4172: THEN
4173: hr_utility.trace('Second type of backouts exist');
4174: hr_utility.trace('Count '||l_rowidtab.COUNT);
4175: END IF;
4176:
4177: FORALL i IN l_rowidtab.FIRST..l_line_tab.LAST
4178: UPDATE hxc_ret_pay_latest_details

Line 4196: hr_utility.trace('Reached here 3 ');

4192: attribute3 = NULL
4193: WHERE ROWID = CHARTOROWID(l_rowidtab(i));
4194: END IF;
4195:
4196: hr_utility.trace('Reached here 3 ');
4197:
4198: IF g_debug
4199: THEN
4200: hr_utility.trace('Marked Second backouts ');

Line 4200: hr_utility.trace('Marked Second backouts ');

4196: hr_utility.trace('Reached here 3 ');
4197:
4198: IF g_debug
4199: THEN
4200: hr_utility.trace('Marked Second backouts ');
4201: END IF;
4202:
4203:
4204: -- Next, get changed hours.

Line 4237: hr_utility.trace('Changed hours exist');

4233: THEN
4234:
4235: IF g_debug
4236: THEN
4237: hr_utility.trace('Changed hours exist');
4238: hr_utility.trace('Count '||l_rowidtab.COUNT);
4239: END IF;
4240:
4241: FORALL i IN l_rowidtab.FIRST..l_rowidtab.LAST

Line 4238: hr_utility.trace('Count '||l_rowidtab.COUNT);

4234:
4235: IF g_debug
4236: THEN
4237: hr_utility.trace('Changed hours exist');
4238: hr_utility.trace('Count '||l_rowidtab.COUNT);
4239: END IF;
4240:
4241: FORALL i IN l_rowidtab.FIRST..l_rowidtab.LAST
4242: UPDATE hxc_ret_pay_latest_details

Line 4262: hr_utility.trace('Reached here 4 ');

4258: WHERE ROWID = CHARTOROWID(l_rowidtab(i));
4259:
4260: END IF;
4261:
4262: hr_utility.trace('Reached here 4 ');
4263:
4264: IF g_debug
4265: THEN
4266: hr_utility.trace('Marked Changed hours ');

Line 4266: hr_utility.trace('Marked Changed hours ');

4262: hr_utility.trace('Reached here 4 ');
4263:
4264: IF g_debug
4265: THEN
4266: hr_utility.trace('Marked Changed hours ');
4267: END IF;
4268:
4269:
4270: -- Here, get the new details entered.

Line 4315: hr_utility.trace('New Details Exist');

4311: THEN
4312:
4313: IF g_debug
4314: THEN
4315: hr_utility.trace('New Details Exist');
4316: hr_utility.trace('Count '||resource_id_tab.COUNT);
4317: END IF;
4318:
4319:

Line 4316: hr_utility.trace('Count '||resource_id_tab.COUNT);

4312:
4313: IF g_debug
4314: THEN
4315: hr_utility.trace('New Details Exist');
4316: hr_utility.trace('Count '||resource_id_tab.COUNT);
4317: END IF;
4318:
4319:
4320: FORALL i IN resource_id_tab.FIRST..resource_id_tab.LAST

Line 4428: hr_utility.trace('About to update all the orig details into the new records. ');

4424:
4425:
4426: IF g_debug
4427: THEN
4428: hr_utility.trace('About to update all the orig details into the new records. ');
4429: hr_utility.trace('Count '||time_building_block_id_tab.COUNT);
4430: END IF;
4431:
4432:

Line 4429: hr_utility.trace('Count '||time_building_block_id_tab.COUNT);

4425:
4426: IF g_debug
4427: THEN
4428: hr_utility.trace('About to update all the orig details into the new records. ');
4429: hr_utility.trace('Count '||time_building_block_id_tab.COUNT);
4430: END IF;
4431:
4432:
4433: -- Update this back on to the RDB table. These actual values would be used by