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

Line 196: hr_utility.set_location('Entering:'|| l_proc, 10);

192: l_entry_package VARCHAR2(60);
193: l_proc varchar2(100) := g_package||'.get_element_details ';
194: BEGIN
195: --
196: hr_utility.set_location('Entering:'|| l_proc, 10);
197: --
198: -- Get absence information.
199: --
200: OPEN csr_absence_details(p_absence_attendance_id);

Line 211: hr_utility.set_location('l_element_type_id '|| l_element_type_id, 15);

207:
208: l_element_type_id := get_element_for_category(p_absence_attendance_id);
209: l_entry_package := get_package_for_category(p_absence_attendance_id);
210:
211: hr_utility.set_location('l_element_type_id '|| l_element_type_id, 15);
212:
213: --
214: l_date_start := l_abs_rec.date_start;
215:

Line 294: hr_utility.set_location(' b4 execute imm of function ', 25);

290: l_plsql_block := 'BEGIN :l_return := (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13,
291: :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25,
292: :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36); END;';
293:
294: hr_utility.set_location(' b4 execute imm of function ', 25);
295:
296: SELECT REPLACE(l_plsql_block, '', l_entry_package) INTO l_plsql_block FROM dual;
297: --
298: EXECUTE IMMEDIATE l_plsql_block

Line 337: hr_utility.set_location('After execute imm of function ', 25);

333: ,OUT l_iv14_value
334: ,OUT l_iv15_name
335: ,OUT l_iv15_value;
336:
337: hr_utility.set_location('After execute imm of function ', 25);
338:
339: END IF;
340:
341: END IF; -- Newly added - Category Checking - End

Line 343: hr_utility.set_location('After execute imm', 30);

339: END IF;
340:
341: END IF; -- Newly added - Category Checking - End
342: --
343: hr_utility.set_location('After execute imm', 30);
344: --
345: -- Translate input value name / value pairs returned from external procedure into format to be used to create element entry.
346: --
347: p_create_entry := nvl(l_return,'Y');

Line 359: hr_utility.set_location(' p_entry_value1: ' || l_entry_values_rec.entry_value, 35);

355:
356: p_input_value_id1 := l_entry_values_rec.input_value;
357: p_entry_value1 := l_entry_values_rec.entry_value;
358:
359: hr_utility.set_location(' p_entry_value1: ' || l_entry_values_rec.entry_value, 35);
360:
361: IF l_iv2_name IS NOT NULL THEN
362: OPEN csr_entry_values(l_element_type_id, l_iv2_name, l_iv2_value, l_date_start);
363: FETCH csr_entry_values INTO l_entry_values_rec;

Line 370: hr_utility.set_location(' p_entry_value2: ' || l_entry_values_rec.entry_value, 35);

366:
367: p_input_value_id2 := l_entry_values_rec.input_value;
368: p_entry_value2 := l_entry_values_rec.entry_value;
369:
370: hr_utility.set_location(' p_entry_value2: ' || l_entry_values_rec.entry_value, 35);
371:
372: IF l_iv3_name IS NOT NULL THEN
373: OPEN csr_entry_values(l_element_type_id, l_iv3_name, l_iv3_value, l_date_start);
374: FETCH csr_entry_values INTO l_entry_values_rec;

Line 381: hr_utility.set_location(' p_entry_value3: ' || l_entry_values_rec.entry_value, 35);

377:
378: p_input_value_id3 := l_entry_values_rec.input_value;
379: p_entry_value3 := l_entry_values_rec.entry_value;
380:
381: hr_utility.set_location(' p_entry_value3: ' || l_entry_values_rec.entry_value, 35);
382:
383:
384: IF l_iv4_name IS NOT NULL THEN
385: OPEN csr_entry_values(l_element_type_id, l_iv4_name, l_iv4_value, l_date_start);

Line 393: hr_utility.set_location(' p_entry_value4: ' || l_entry_values_rec.entry_value, 35);

389:
390: p_input_value_id4 := l_entry_values_rec.input_value;
391: p_entry_value4 := l_entry_values_rec.entry_value;
392:
393: hr_utility.set_location(' p_entry_value4: ' || l_entry_values_rec.entry_value, 35);
394:
395: IF l_iv5_name IS NOT NULL THEN
396: OPEN csr_entry_values(l_element_type_id, l_iv5_name, l_iv5_value, l_date_start);
397: FETCH csr_entry_values INTO l_entry_values_rec;

Line 579: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR

575: BEGIN
576: --
577: -- Added for GSI Bug 5472781
578: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
579: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

Line 580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR

576: --
577: -- Added for GSI Bug 5472781
578: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
579: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
584: --hr_utility.trace_on(null,'GOV_ABS');

Line 581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR

577: -- Added for GSI Bug 5472781
578: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
579: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
584: --hr_utility.trace_on(null,'GOV_ABS');
585: -- Bug no 5020916. Initialize local variable l_old_assignment as 0

Line 582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR

578: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
579: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
584: --hr_utility.trace_on(null,'GOV_ABS');
585: -- Bug no 5020916. Initialize local variable l_old_assignment as 0
586: l_old_assignment := 0;

Line 583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

579: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
584: --hr_utility.trace_on(null,'GOV_ABS');
585: -- Bug no 5020916. Initialize local variable l_old_assignment as 0
586: l_old_assignment := 0;
587: --

Line 584: --hr_utility.trace_on(null,'GOV_ABS');

580: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
581: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
582: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
583: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
584: --hr_utility.trace_on(null,'GOV_ABS');
585: -- Bug no 5020916. Initialize local variable l_old_assignment as 0
586: l_old_assignment := 0;
587: --
588: --

Line 591: hr_utility.set_location('Entering:'|| l_proc, 10);

587: --
588: --
589: -- Loop through all assignments for the person.
590: --
591: hr_utility.set_location('Entering:'|| l_proc, 10);
592: FOR l_asg_rec IN csr_assignments(p_absence_attendance_id, p_date_start) LOOP
593: -- Bug no 5020916. Restricting the for loop to process one time for each assignment.
594: IF l_old_assignment <> l_asg_rec.assignment_id THEN
595: l_old_assignment := l_asg_rec.assignment_id;

Line 598: hr_utility.set_location('in for loop' , 20);

594: IF l_old_assignment <> l_asg_rec.assignment_id THEN
595: l_old_assignment := l_asg_rec.assignment_id;
596: --
597: --
598: hr_utility.set_location('in for loop' , 20);
599: hr_utility.set_location('asg details : '||l_asg_rec.assignment_id||l_asg_rec.effective_start_date||l_asg_rec.effective_end_date , 20);
600: get_element_details(p_absence_attendance_id, l_asg_rec.assignment_id, l_element_type_id , l_create_entry
601: ,l_original_entry_id --pgopal
602: ,l_input_value_id, l_input_value

Line 599: hr_utility.set_location('asg details : '||l_asg_rec.assignment_id||l_asg_rec.effective_start_date||l_asg_rec.effective_end_date , 20);

595: l_old_assignment := l_asg_rec.assignment_id;
596: --
597: --
598: hr_utility.set_location('in for loop' , 20);
599: hr_utility.set_location('asg details : '||l_asg_rec.assignment_id||l_asg_rec.effective_start_date||l_asg_rec.effective_end_date , 20);
600: get_element_details(p_absence_attendance_id, l_asg_rec.assignment_id, l_element_type_id , l_create_entry
601: ,l_original_entry_id --pgopal
602: ,l_input_value_id, l_input_value
603: ,l_iv2_id, l_iv2_value

Line 618: hr_utility.set_location('after get_element_details' , 20);

614: ,l_iv13_id, l_iv13_value
615: ,l_iv14_id, l_iv14_value
616: ,l_iv15_id, l_iv15_value );
617:
618: hr_utility.set_location('after get_element_details' , 20);
619: --
620: --
621: hr_utility.set_location('l_asg_rec.assignment_id: ' || l_asg_rec.assignment_id , 25);
622: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 25);

Line 621: hr_utility.set_location('l_asg_rec.assignment_id: ' || l_asg_rec.assignment_id , 25);

617:
618: hr_utility.set_location('after get_element_details' , 20);
619: --
620: --
621: hr_utility.set_location('l_asg_rec.assignment_id: ' || l_asg_rec.assignment_id , 25);
622: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 25);
623: hr_utility.set_location('p_date_start: ' || p_date_start , 25);
624:
625: -- Bug no 5020916. Commenting assignment date check while attaching absences to assignments.

Line 622: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 25);

618: hr_utility.set_location('after get_element_details' , 20);
619: --
620: --
621: hr_utility.set_location('l_asg_rec.assignment_id: ' || l_asg_rec.assignment_id , 25);
622: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 25);
623: hr_utility.set_location('p_date_start: ' || p_date_start , 25);
624:
625: -- Bug no 5020916. Commenting assignment date check while attaching absences to assignments.
626: -- IF p_date_start > l_asg_rec.effective_start_date THEN

Line 623: hr_utility.set_location('p_date_start: ' || p_date_start , 25);

619: --
620: --
621: hr_utility.set_location('l_asg_rec.assignment_id: ' || l_asg_rec.assignment_id , 25);
622: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 25);
623: hr_utility.set_location('p_date_start: ' || p_date_start , 25);
624:
625: -- Bug no 5020916. Commenting assignment date check while attaching absences to assignments.
626: -- IF p_date_start > l_asg_rec.effective_start_date THEN
627: l_date_start := p_date_start;

Line 640: hr_utility.set_location('l_element_link_id: ' || l_element_link_id , 25);

636: -- END IF;
637:
638: l_element_link_id := hr_entry_api.get_link(l_asg_rec.assignment_id, l_element_type_id, l_date_start);
639:
640: hr_utility.set_location('l_element_link_id: ' || l_element_link_id , 25);
641:
642: -- Create the element entry.
643: --
644: if l_element_link_id is not null then

Line 651: hr_utility.set_location('l_input_value_id ' || l_input_value_id , 25);

647: OPEN csr_processing_type (l_element_type_id);
648: FETCH csr_processing_type into l_processing_type;
649: CLOSE csr_processing_type;
650:
651: hr_utility.set_location('l_input_value_id ' || l_input_value_id , 25);
652: hr_utility.set_location('l_input_value: ' || l_input_value , 25);
653: hr_utility.set_location('l_iv2_id: ' || l_iv2_id , 25);
654: hr_utility.set_location('l_iv2_value: ' || l_iv2_value , 25);
655:

Line 652: hr_utility.set_location('l_input_value: ' || l_input_value , 25);

648: FETCH csr_processing_type into l_processing_type;
649: CLOSE csr_processing_type;
650:
651: hr_utility.set_location('l_input_value_id ' || l_input_value_id , 25);
652: hr_utility.set_location('l_input_value: ' || l_input_value , 25);
653: hr_utility.set_location('l_iv2_id: ' || l_iv2_id , 25);
654: hr_utility.set_location('l_iv2_value: ' || l_iv2_value , 25);
655:
656:

Line 653: hr_utility.set_location('l_iv2_id: ' || l_iv2_id , 25);

649: CLOSE csr_processing_type;
650:
651: hr_utility.set_location('l_input_value_id ' || l_input_value_id , 25);
652: hr_utility.set_location('l_input_value: ' || l_input_value , 25);
653: hr_utility.set_location('l_iv2_id: ' || l_iv2_id , 25);
654: hr_utility.set_location('l_iv2_value: ' || l_iv2_value , 25);
655:
656:
657: if (l_processing_type = 'N'

Line 654: hr_utility.set_location('l_iv2_value: ' || l_iv2_value , 25);

650:
651: hr_utility.set_location('l_input_value_id ' || l_input_value_id , 25);
652: hr_utility.set_location('l_input_value: ' || l_input_value , 25);
653: hr_utility.set_location('l_iv2_id: ' || l_iv2_id , 25);
654: hr_utility.set_location('l_iv2_value: ' || l_iv2_value , 25);
655:
656:
657: if (l_processing_type = 'N'
658: and l_date_start is not null

Line 707: hr_utility.set_location('after element_entry creation ' ||l_element_entry_id , 80);

703: ,p_entry_value14 => l_iv14_value
704: ,p_input_value_id15 => l_iv15_id
705: ,p_entry_value15 => l_iv15_value);
706: --
707: hr_utility.set_location('after element_entry creation ' ||l_element_entry_id , 80);
708: END IF;
709: END IF;
710: --
711: -- End date the element entry in line with the absence.

Line 771: hr_utility.set_location('Entering:'|| l_proc, 10);

767: l_dummy_effective_date DATE;
768:
769: begin
770:
771: hr_utility.set_location('Entering:'|| l_proc, 10);
772: -- Get absence information.
773: --
774: OPEN csr_absence_details(p_absence_attendance_id);
775: FETCH csr_absence_details INTO l_abs_rec;

Line 798: hr_utility.set_location('l_element_name: '|| l_element_name, 10);

794: l_element_name := hruserdt.GET_TABLE_VALUE (l_abs_rec.business_group_id, l_legislation_code ||'_ABSENCE_TYPE_AND_DETAILS',
795: 'ELEMENT',
796: l_abs_rec.name);
797:
798: hr_utility.set_location('l_element_name: '|| l_element_name, 10);
799: EXCEPTION
800: WHEN NO_DATA_FOUND THEN
801: NULL;
802: END;

Line 856: hr_utility.set_location('Entering:'|| l_proc, 10);

852:
853:
854: begin
855:
856: hr_utility.set_location('Entering:'|| l_proc, 10);
857: -- Get absence information.
858: --
859: OPEN csr_absence_details(p_absence_attendance_id);
860: FETCH csr_absence_details INTO l_abs_rec;

Line 961: hr_utility.set_location('Entering:'|| l_proc, 10);

957: l_element_type_id NUMBER(15);
958:
959: begin
960:
961: hr_utility.set_location('Entering:'|| l_proc, 10);
962:
963: l_element_type_id := get_element_for_category (p_absence_attendance_id);
964:
965: hr_utility.set_location('l_element_type_id:'|| l_element_type_id, 10);

Line 965: hr_utility.set_location('l_element_type_id:'|| l_element_type_id, 10);

961: hr_utility.set_location('Entering:'|| l_proc, 10);
962:
963: l_element_type_id := get_element_for_category (p_absence_attendance_id);
964:
965: hr_utility.set_location('l_element_type_id:'|| l_element_type_id, 10);
966:
967: open c_get_absence_element(l_element_type_id);
968: fetch c_get_absence_element into p_element_entry_id,
969: p_processing_type,

Line 975: hr_utility.set_location('Leaving:'|| l_proc, 20);

971: p_effective_end_date;
972: close c_get_absence_element;
973:
974:
975: hr_utility.set_location('Leaving:'|| l_proc, 20);
976: exception
977: when others then
978: p_element_entry_id := null;
979: p_effective_start_date := null;

Line 998: hr_utility.set_location('Entering:'|| l_proc, 10);

994:
995: begin
996:
997:
998: hr_utility.set_location('Entering:'|| l_proc, 10);
999:
1000: hr_utility.set_location('p_session_date :'|| to_char(p_session_date), 20);
1001: hr_utility.set_location('p_element_entry_id :'|| p_element_entry_id, 30);
1002: hr_utility.set_location('p_dt_delete_mode :'|| p_dt_delete_mode, 30);

Line 1000: hr_utility.set_location('p_session_date :'|| to_char(p_session_date), 20);

996:
997:
998: hr_utility.set_location('Entering:'|| l_proc, 10);
999:
1000: hr_utility.set_location('p_session_date :'|| to_char(p_session_date), 20);
1001: hr_utility.set_location('p_element_entry_id :'|| p_element_entry_id, 30);
1002: hr_utility.set_location('p_dt_delete_mode :'|| p_dt_delete_mode, 30);
1003:
1004: hr_entry_api.delete_element_entry

Line 1001: hr_utility.set_location('p_element_entry_id :'|| p_element_entry_id, 30);

997:
998: hr_utility.set_location('Entering:'|| l_proc, 10);
999:
1000: hr_utility.set_location('p_session_date :'|| to_char(p_session_date), 20);
1001: hr_utility.set_location('p_element_entry_id :'|| p_element_entry_id, 30);
1002: hr_utility.set_location('p_dt_delete_mode :'|| p_dt_delete_mode, 30);
1003:
1004: hr_entry_api.delete_element_entry
1005: (p_dt_delete_mode => p_dt_delete_mode

Line 1002: hr_utility.set_location('p_dt_delete_mode :'|| p_dt_delete_mode, 30);

998: hr_utility.set_location('Entering:'|| l_proc, 10);
999:
1000: hr_utility.set_location('p_session_date :'|| to_char(p_session_date), 20);
1001: hr_utility.set_location('p_element_entry_id :'|| p_element_entry_id, 30);
1002: hr_utility.set_location('p_dt_delete_mode :'|| p_dt_delete_mode, 30);
1003:
1004: hr_entry_api.delete_element_entry
1005: (p_dt_delete_mode => p_dt_delete_mode
1006: ,p_session_date => p_session_date

Line 1010: hr_utility.set_location('Leaving:'|| l_proc, 20);

1006: ,p_session_date => p_session_date
1007: ,p_element_entry_id => p_element_entry_id);
1008:
1009:
1010: hr_utility.set_location('Leaving:'|| l_proc, 20);
1011:
1012: end delete_absence_element;
1013:
1014: procedure update_absence_element

Line 1058: --hr_utility.trace_on(null,'GOV_ABS');

1054: l_iv15_value VARCHAR2(30);
1055: l_create_entry VARCHAR2(20);
1056: l_original_entry_id NUMBER ; --pgopal
1057: begin
1058: --hr_utility.trace_on(null,'GOV_ABS');
1059:
1060: hr_utility.set_location('Entering:'|| l_proc, 10);
1061:
1062: get_element_details(p_absence_attendance_id, p_assignment_id,

Line 1060: hr_utility.set_location('Entering:'|| l_proc, 10);

1056: l_original_entry_id NUMBER ; --pgopal
1057: begin
1058: --hr_utility.trace_on(null,'GOV_ABS');
1059:
1060: hr_utility.set_location('Entering:'|| l_proc, 10);
1061:
1062: get_element_details(p_absence_attendance_id, p_assignment_id,
1063: l_element_type_id , l_create_entry
1064: ,l_original_entry_id --pgopal

Line 1082: hr_utility.set_location('Updating element', 20);

1078: ,l_iv14_id, l_iv14_value
1079: ,l_iv15_id, l_iv15_value );
1080:
1081:
1082: hr_utility.set_location('Updating element', 20);
1083: hr_utility.set_location('Updating element create entry : '||l_create_entry, 20);
1084:
1085: -- We know the assignment is eligible for this element because
1086: -- we have the element_link_id. The entries API will handle

Line 1083: hr_utility.set_location('Updating element create entry : '||l_create_entry, 20);

1079: ,l_iv15_id, l_iv15_value );
1080:
1081:
1082: hr_utility.set_location('Updating element', 20);
1083: hr_utility.set_location('Updating element create entry : '||l_create_entry, 20);
1084:
1085: -- We know the assignment is eligible for this element because
1086: -- we have the element_link_id. The entries API will handle
1087: -- all other validation (e.g., non-recurring entries must

Line 1092: hr_utility.set_location('Input value id 1 : '||l_input_value_id, 20);

1088: -- have a valid payroll).
1089:
1090: IF l_create_entry = 'Y' THEN
1091:
1092: hr_utility.set_location('Input value id 1 : '||l_input_value_id, 20);
1093: hr_utility.set_location('Input value 1 : '||l_entry_value, 20);
1094:
1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);
1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);

Line 1093: hr_utility.set_location('Input value 1 : '||l_entry_value, 20);

1089:
1090: IF l_create_entry = 'Y' THEN
1091:
1092: hr_utility.set_location('Input value id 1 : '||l_input_value_id, 20);
1093: hr_utility.set_location('Input value 1 : '||l_entry_value, 20);
1094:
1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);
1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);
1097:

Line 1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);

1091:
1092: hr_utility.set_location('Input value id 1 : '||l_input_value_id, 20);
1093: hr_utility.set_location('Input value 1 : '||l_entry_value, 20);
1094:
1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);
1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);
1097:
1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);
1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);

Line 1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);

1092: hr_utility.set_location('Input value id 1 : '||l_input_value_id, 20);
1093: hr_utility.set_location('Input value 1 : '||l_entry_value, 20);
1094:
1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);
1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);
1097:
1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);
1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);
1100:

Line 1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);

1094:
1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);
1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);
1097:
1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);
1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);
1100:
1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);
1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);

Line 1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);

1095: hr_utility.set_location('Input value id 2 : '||l_iv2_id, 20);
1096: hr_utility.set_location('Input value 2 : '||l_iv2_value, 20);
1097:
1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);
1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);
1100:
1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);
1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);
1103:

Line 1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);

1097:
1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);
1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);
1100:
1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);
1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);
1103:
1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);
1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);

Line 1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);

1098: hr_utility.set_location('Input value id 3 : '||l_iv3_id, 20);
1099: hr_utility.set_location('Input value 3 : '||l_iv3_value, 20);
1100:
1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);
1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);
1103:
1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);
1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);
1106:

Line 1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);

1100:
1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);
1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);
1103:
1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);
1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);
1106:
1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);
1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);

Line 1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);

1101: hr_utility.set_location('Input value id 4 : '||l_iv4_id, 20);
1102: hr_utility.set_location('Input value 4 : '||l_iv4_value, 20);
1103:
1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);
1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);
1106:
1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);
1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);
1109:

Line 1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);

1103:
1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);
1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);
1106:
1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);
1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);
1109:
1110: hr_utility.set_location('Dt update mode : '||p_dt_update_mode, 20);
1111: hr_utility.set_location('p_session_date : '||p_session_date, 20);

Line 1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);

1104: hr_utility.set_location('Input value id 5 : '||l_iv5_id, 20);
1105: hr_utility.set_location('Input value 5 : '||l_iv5_value, 20);
1106:
1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);
1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);
1109:
1110: hr_utility.set_location('Dt update mode : '||p_dt_update_mode, 20);
1111: hr_utility.set_location('p_session_date : '||p_session_date, 20);
1112:

Line 1110: hr_utility.set_location('Dt update mode : '||p_dt_update_mode, 20);

1106:
1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);
1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);
1109:
1110: hr_utility.set_location('Dt update mode : '||p_dt_update_mode, 20);
1111: hr_utility.set_location('p_session_date : '||p_session_date, 20);
1112:
1113: hr_entry_api.update_element_entry
1114: (p_dt_update_mode => p_dt_update_mode

Line 1111: hr_utility.set_location('p_session_date : '||p_session_date, 20);

1107: hr_utility.set_location('Input value id 8 : '||l_iv8_id, 20);
1108: hr_utility.set_location('Input value 8 : '||l_iv8_value, 20);
1109:
1110: hr_utility.set_location('Dt update mode : '||p_dt_update_mode, 20);
1111: hr_utility.set_location('p_session_date : '||p_session_date, 20);
1112:
1113: hr_entry_api.update_element_entry
1114: (p_dt_update_mode => p_dt_update_mode
1115: ,p_session_date => p_session_date

Line 1152: hr_utility.set_location('Leaving:'|| l_proc, 30);

1148: ,p_input_value_id15 => l_iv15_id
1149: ,p_entry_value15 => l_iv15_value);
1150: END IF;
1151:
1152: hr_utility.set_location('Leaving:'|| l_proc, 30);
1153:
1154: end update_absence_element;
1155:
1156: procedure insert_absence_element

Line 1204: hr_utility.set_location('Entering:'|| l_proc, 10);

1200: l_original_entry_id NUMBER ; --pgopal
1201: begin
1202:
1203:
1204: hr_utility.set_location('Entering:'|| l_proc, 10);
1205:
1206: get_element_details(p_absence_attendance_id, p_assignment_id,
1207: l_element_type_id , l_create_entry
1208: ,l_original_entry_id --pgopal

Line 1226: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 30);

1222: ,l_iv14_id, l_iv14_value
1223: ,l_iv15_id, l_iv15_value );
1224:
1225:
1226: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 30);
1227: hr_utility.set_location('Checking element link', 20);
1228:
1229: IF l_create_entry = 'Y' THEN
1230: l_element_link_id := hr_entry_api.get_link

Line 1227: hr_utility.set_location('Checking element link', 20);

1223: ,l_iv15_id, l_iv15_value );
1224:
1225:
1226: hr_utility.set_location('l_element_type_id: '||l_element_type_id, 30);
1227: hr_utility.set_location('Checking element link', 20);
1228:
1229: IF l_create_entry = 'Y' THEN
1230: l_element_link_id := hr_entry_api.get_link
1231: (p_assignment_id => p_assignment_id

Line 1239: hr_utility.raise_error;

1235: If l_element_link_id is null then
1236: -- Assignment is not eligible for the element type
1237: -- associated with this absence.
1238: fnd_message.set_name ('PAY','HR_7448_ELE_PER_NOT_ELIGIBLE');
1239: hr_utility.raise_error;
1240: end if;
1241:
1242:
1243: hr_utility.set_location('Inserting element', 30);

Line 1243: hr_utility.set_location('Inserting element', 30);

1239: hr_utility.raise_error;
1240: end if;
1241:
1242:
1243: hr_utility.set_location('Inserting element', 30);
1244:
1245: -- We know the assignment is eligible for this element because
1246: -- we have the element_link_id. The entries API will handle
1247: -- all other validation (e.g., non-recurring entries must

Line 1293: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);

1289: ,p_input_value_id15 => l_iv15_id
1290: ,p_entry_value15 => l_iv15_value);
1291: END IF;
1292:
1293: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);
1294: hr_utility.set_location('Leaving:'|| l_proc, 50);
1295:
1296: exception
1297: when others then

Line 1294: hr_utility.set_location('Leaving:'|| l_proc, 50);

1290: ,p_entry_value15 => l_iv15_value);
1291: END IF;
1292:
1293: hr_utility.set_location('EE ID: '|| to_char(p_element_entry_id), 40);
1294: hr_utility.set_location('Leaving:'|| l_proc, 50);
1295:
1296: exception
1297: when others then
1298: p_element_entry_id := null ;

Line 1391: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR

1387: BEGIN
1388: --
1389: -- Added for GSI Bug 5472781
1390: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1391: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1392: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1393: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1394: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1395: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

Line 1392: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR

1388: --
1389: -- Added for GSI Bug 5472781
1390: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1391: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1392: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1393: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1394: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1395: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1396: --

Line 1393: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR

1389: -- Added for GSI Bug 5472781
1390: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1391: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1392: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1393: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1394: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1395: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1396: --
1397: -- Bug no 5020916. Initialize local variable l_old_assignment as 0

Line 1394: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR

1390: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1391: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1392: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1393: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1394: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1395: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1396: --
1397: -- Bug no 5020916. Initialize local variable l_old_assignment as 0
1398: l_old_assignment := 0;

Line 1395: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

1391: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1392: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1393: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1394: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1395: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1396: --
1397: -- Bug no 5020916. Initialize local variable l_old_assignment as 0
1398: l_old_assignment := 0;
1399:

Line 1405: hr_utility.set_location('Entering:'|| l_proc, 10);

1401: --
1402: -- Update or insert the absence element element. First we
1403: -- check if the absence type is linked to an element type.
1404: --
1405: hr_utility.set_location('Entering:'|| l_proc, 10);
1406:
1407: /* Level 1 */
1408: -- commented till we decide where we are going to store element type and category link.
1409: /* if linked_to_element

Line 1423: hr_utility.set_location('After c_get_absence_details ', 20);

1419: fetch c_get_absence_details into l_person_id,
1420: l_absence_attendance_type_id;
1421: close c_get_absence_details;
1422:
1423: hr_utility.set_location('After c_get_absence_details ', 20);
1424: --
1425: -- We determine if an entry already exists.
1426: --*/
1427: for l_assignment_id in csr_assignments(l_person_id, p_effective_date) loop

Line 1452: hr_utility.set_location('l_person_id: ' || l_person_id , 20);

1448: ,p_element_entry_id => l_element_entry_id
1449: ,p_effective_start_date => l_effective_start_date
1450: ,p_effective_end_date => l_effective_end_date);
1451:
1452: hr_utility.set_location('l_person_id: ' || l_person_id , 20);
1453: hr_utility.set_location('p_effective_date: ' || p_effective_date , 20);
1454: hr_utility.set_location('l_element_entry_id: ' || l_element_entry_id , 100);
1455:
1456:

Line 1453: hr_utility.set_location('p_effective_date: ' || p_effective_date , 20);

1449: ,p_effective_start_date => l_effective_start_date
1450: ,p_effective_end_date => l_effective_end_date);
1451:
1452: hr_utility.set_location('l_person_id: ' || l_person_id , 20);
1453: hr_utility.set_location('p_effective_date: ' || p_effective_date , 20);
1454: hr_utility.set_location('l_element_entry_id: ' || l_element_entry_id , 100);
1455:
1456:
1457: /* Level 2 */

Line 1454: hr_utility.set_location('l_element_entry_id: ' || l_element_entry_id , 100);

1450: ,p_effective_end_date => l_effective_end_date);
1451:
1452: hr_utility.set_location('l_person_id: ' || l_person_id , 20);
1453: hr_utility.set_location('p_effective_date: ' || p_effective_date , 20);
1454: hr_utility.set_location('l_element_entry_id: ' || l_element_entry_id , 100);
1455:
1456:
1457: /* Level 2 */
1458: if l_element_entry_id is null then

Line 1464: hr_utility.set_location('Scenario 1', 45);

1460: -- Scenario 1.
1461: -- An entry does not already exist. Insert if we have
1462: -- the appropriate dates.
1463: --
1464: hr_utility.set_location('Scenario 1', 45);
1465:
1466: l_element_type_id := get_element_for_category(p_absence_attendance_id);
1467:
1468: OPEN csr_processing_type (l_element_type_id );

Line 1474: hr_utility.set_location('l_processing_type: ' || l_processing_type , 20);

1470: CLOSE csr_processing_type;
1471:
1472:
1473:
1474: hr_utility.set_location('l_processing_type: ' || l_processing_type , 20);
1475: hr_utility.set_location('l_date_start: ' || l_date_start , 20);
1476: hr_utility.set_location('l_assignment_id.assignment_id: ' || l_assignment_id.assignment_id , 100);
1477: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 100);
1478:

Line 1475: hr_utility.set_location('l_date_start: ' || l_date_start , 20);

1471:
1472:
1473:
1474: hr_utility.set_location('l_processing_type: ' || l_processing_type , 20);
1475: hr_utility.set_location('l_date_start: ' || l_date_start , 20);
1476: hr_utility.set_location('l_assignment_id.assignment_id: ' || l_assignment_id.assignment_id , 100);
1477: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 100);
1478:
1479: if (l_processing_type = 'N'

Line 1476: hr_utility.set_location('l_assignment_id.assignment_id: ' || l_assignment_id.assignment_id , 100);

1472:
1473:
1474: hr_utility.set_location('l_processing_type: ' || l_processing_type , 20);
1475: hr_utility.set_location('l_date_start: ' || l_date_start , 20);
1476: hr_utility.set_location('l_assignment_id.assignment_id: ' || l_assignment_id.assignment_id , 100);
1477: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 100);
1478:
1479: if (l_processing_type = 'N'
1480: and l_date_start is not null

Line 1477: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 100);

1473:
1474: hr_utility.set_location('l_processing_type: ' || l_processing_type , 20);
1475: hr_utility.set_location('l_date_start: ' || l_date_start , 20);
1476: hr_utility.set_location('l_assignment_id.assignment_id: ' || l_assignment_id.assignment_id , 100);
1477: hr_utility.set_location('l_element_type_id: ' || l_element_type_id , 100);
1478:
1479: if (l_processing_type = 'N'
1480: and l_date_start is not null
1481: and l_date_end is not null)

Line 1502: hr_utility.set_location('Scenario 2', 50);

1498: -- absence end date, we date effectively delete the
1499: -- element immediately, otherwise it remains open until
1500: -- the end of time.
1501: --
1502: hr_utility.set_location('Scenario 2', 50);
1503:
1504: delete_absence_element
1505: (p_dt_delete_mode => 'DELETE'
1506: ,p_session_date => l_date_end

Line 1517: hr_utility.set_location('element_entry id is not null ', 30);

1513: --
1514: -- An entry already exists. Update it as appropriate.
1515: --
1516: /* Level 3 */
1517: hr_utility.set_location('element_entry id is not null ', 30);
1518:
1519: if (l_processing_type = 'R' and l_date_start is null)
1520: or (l_processing_type = 'N' and (l_date_start is null
1521: or l_date_end is null)) then

Line 1527: hr_utility.set_location('Scenario 3', 55);

1523: -- Scenario 3.
1524: -- The element entry should be purged because the
1525: -- actual dates have been removed.
1526: --
1527: hr_utility.set_location('Scenario 3', 55);
1528:
1529: --
1530: -- Warn the user before deleting.
1531: --

Line 1534: hr_utility.set_location('before delete absence element ', 40);

1530: -- Warn the user before deleting.
1531: --
1532: l_del_element_entry_warning := TRUE;
1533:
1534: hr_utility.set_location('before delete absence element ', 40);
1535: delete_absence_element
1536: (p_dt_delete_mode => 'ZAP'
1537: ,p_session_date => l_effective_start_date
1538: ,p_element_entry_id => l_element_entry_id);

Line 1547: hr_utility.set_location('Scenario 4', 60);

1543: -- Scenario 4.
1544: -- The start date cannot be moved outside the entry's
1545: -- current period for non-recurring entries.
1546: --
1547: hr_utility.set_location('Scenario 4', 60);
1548:
1549: fnd_message.set_name ('PAY', 'HR_6744_ABS_DET_ENTRY_PERIOD');
1550: /* Commented and added as a part of Bug#10239011 Starts
1551: fnd_message.set_token ('PERIOD_FROM',

Line 1569: hr_utility.set_location('Scenario 5', 65);

1565: -- Update the existing entry with the new input values.
1566: -- For simplicity, we make the update even if the value
1567: -- has not changed.
1568: --
1569: hr_utility.set_location('Scenario 5', 65);
1570:
1571: update_absence_element
1572: (p_dt_update_mode => 'CORRECTION'
1573: ,p_assignment_id => l_assignment_id.assignment_id

Line 1586: hr_utility.set_location('Scenario 6', 70);

1582: -- Scenario 6.
1583: -- The start date has been moved. As this is part of the
1584: -- primary key we must delete the entry and re-insert it.
1585: --
1586: hr_utility.set_location('Scenario 6', 70);
1587:
1588: delete_absence_element
1589: (p_dt_delete_mode => 'ZAP'
1590: ,p_session_date => l_effective_start_date

Line 1623: hr_utility.set_location('Scenario 7', 75);

1619: -- . been removed
1620: -- . entered for the first time
1621: -- . still not been entered.
1622: --
1623: hr_utility.set_location('Scenario 7', 75);
1624: hr_utility.set_location('l_date_end: '|| l_date_end, 75);
1625: hr_utility.set_location('l_effective_end_date: '|| l_effective_end_date, 75);
1626: hr_utility.set_location('l_element_entry_id: '|| l_element_entry_id, 75);
1627:

Line 1624: hr_utility.set_location('l_date_end: '|| l_date_end, 75);

1620: -- . entered for the first time
1621: -- . still not been entered.
1622: --
1623: hr_utility.set_location('Scenario 7', 75);
1624: hr_utility.set_location('l_date_end: '|| l_date_end, 75);
1625: hr_utility.set_location('l_effective_end_date: '|| l_effective_end_date, 75);
1626: hr_utility.set_location('l_element_entry_id: '|| l_element_entry_id, 75);
1627:
1628: update_absence_element

Line 1625: hr_utility.set_location('l_effective_end_date: '|| l_effective_end_date, 75);

1621: -- . still not been entered.
1622: --
1623: hr_utility.set_location('Scenario 7', 75);
1624: hr_utility.set_location('l_date_end: '|| l_date_end, 75);
1625: hr_utility.set_location('l_effective_end_date: '|| l_effective_end_date, 75);
1626: hr_utility.set_location('l_element_entry_id: '|| l_element_entry_id, 75);
1627:
1628: update_absence_element
1629: (p_dt_update_mode => 'CORRECTION'

Line 1626: hr_utility.set_location('l_element_entry_id: '|| l_element_entry_id, 75);

1622: --
1623: hr_utility.set_location('Scenario 7', 75);
1624: hr_utility.set_location('l_date_end: '|| l_date_end, 75);
1625: hr_utility.set_location('l_effective_end_date: '|| l_effective_end_date, 75);
1626: hr_utility.set_location('l_element_entry_id: '|| l_element_entry_id, 75);
1627:
1628: update_absence_element
1629: (p_dt_update_mode => 'CORRECTION'
1630: ,p_assignment_id => l_assignment_id.assignment_id

Line 1641: hr_utility.set_location(l_proc, 76);

1637: -- End date has been changed or removed so we
1638: -- remove the end date so it continues through
1639: -- until the end of time.
1640: --
1641: hr_utility.set_location(l_proc, 76);
1642: if l_effective_end_date <> l_assignment_id.effective_end_date then
1643: delete_absence_element
1644: (p_dt_delete_mode => 'DELETE_NEXT_CHANGE'
1645: ,p_session_date => l_effective_end_date

Line 1656: hr_utility.set_location(l_proc, 78);

1652: -- End date has been changed or entered for
1653: -- the first time. We end the element entry
1654: -- at the end date.
1655: --
1656: hr_utility.set_location(l_proc, 78);
1657:
1658: delete_absence_element
1659: (p_dt_delete_mode => 'DELETE'
1660: ,p_session_date => l_date_end

Line 1673: hr_utility.set_location('Scenario 8', 65);

1669: -- Update the existing entry with the new input values.
1670: -- For simplicity, we make the update even if the value
1671: -- has not changed.
1672: --
1673: hr_utility.set_location('Scenario 8', 65);
1674:
1675: update_absence_element
1676: (p_dt_update_mode => 'CORRECTION'
1677: ,p_assignment_id => l_assignment_id.assignment_id

Line 1791: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR

1787: BEGIN
1788: --
1789: -- Added for GSI Bug 5472781
1790: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1791: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1792: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

Line 1792: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR

1788: --
1789: -- Added for GSI Bug 5472781
1790: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1791: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1792: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1796: --

Line 1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR

1789: -- Added for GSI Bug 5472781
1790: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1791: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1792: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1796: --
1797: hr_utility.set_location('Start of absence element deletion section', 30);

Line 1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR

1790: ---pgopal -Included 'NO','SE','PL' in the legislation installation check.
1791: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1792: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1796: --
1797: hr_utility.set_location('Start of absence element deletion section', 30);
1798: --

Line 1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN

1791: IF hr_utility.chk_product_install('Oracle Human Resources', 'DK') OR
1792: hr_utility.chk_product_install('Oracle Human Resources', 'NO') OR
1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1796: --
1797: hr_utility.set_location('Start of absence element deletion section', 30);
1798: --
1799: FOR rec_assignments in csr_assignments LOOP

Line 1797: hr_utility.set_location('Start of absence element deletion section', 30);

1793: hr_utility.chk_product_install('Oracle Human Resources', 'SE') OR
1794: hr_utility.chk_product_install('Oracle Human Resources', 'PL') OR
1795: hr_utility.chk_product_install('Oracle Human Resources', 'FI') THEN
1796: --
1797: hr_utility.set_location('Start of absence element deletion section', 30);
1798: --
1799: FOR rec_assignments in csr_assignments LOOP
1800: --
1801: hr_utility.set_location(' in for loop ', 35);

Line 1801: hr_utility.set_location(' in for loop ', 35);

1797: hr_utility.set_location('Start of absence element deletion section', 30);
1798: --
1799: FOR rec_assignments in csr_assignments LOOP
1800: --
1801: hr_utility.set_location(' in for loop ', 35);
1802: --
1803: l_element_type_id := get_element_for_category (p_absence_attendance_id );
1804: --
1805: hr_utility.set_location('l_element_type_id '|| l_element_type_id, 35);

Line 1805: hr_utility.set_location('l_element_type_id '|| l_element_type_id, 35);

1801: hr_utility.set_location(' in for loop ', 35);
1802: --
1803: l_element_type_id := get_element_for_category (p_absence_attendance_id );
1804: --
1805: hr_utility.set_location('l_element_type_id '|| l_element_type_id, 35);
1806: --
1807: l_flag := 'N';
1808: --
1809: open csr_get_absence_element(rec_assignments.assignment_id,l_element_type_id );

Line 1816: hr_utility.set_location('rec_assignments.assignment_id '|| rec_assignments.assignment_id, 35);

1812: l_flag := 'Y';
1813: end if;
1814: close csr_get_absence_element;
1815: --
1816: hr_utility.set_location('rec_assignments.assignment_id '|| rec_assignments.assignment_id, 35);
1817: hr_utility.set_location('rec_absence_element.element_entry_id '|| rec_absence_element.element_entry_id, 35);
1818: if l_flag <> 'Y' then
1819: if rec_absence_element.element_entry_id is not null then
1820: delete_absence_element

Line 1817: hr_utility.set_location('rec_absence_element.element_entry_id '|| rec_absence_element.element_entry_id, 35);

1813: end if;
1814: close csr_get_absence_element;
1815: --
1816: hr_utility.set_location('rec_assignments.assignment_id '|| rec_assignments.assignment_id, 35);
1817: hr_utility.set_location('rec_absence_element.element_entry_id '|| rec_absence_element.element_entry_id, 35);
1818: if l_flag <> 'Y' then
1819: if rec_absence_element.element_entry_id is not null then
1820: delete_absence_element
1821: (p_dt_delete_mode => 'ZAP'

Line 1827: hr_utility.set_location('End of absence element deletion section', 40);

1823: ,p_element_entry_id => rec_absence_element.element_entry_id);
1824: end if;
1825: end if;
1826: --
1827: hr_utility.set_location('End of absence element deletion section', 40);
1828: --
1829: END LOOP;
1830: END IF;
1831: END delete_absence;