DBA Data[Home] [Help]

APPS.PER_ABSENCE_ATTENDANCES_PKG3 dependencies on HR_UTILITY

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

388: and hl.meaning = p_meaning;
389: --
390: begin
391: --
392: hr_utility.set_location('Entering:'|| l_proc, 10);
393: --
394: -- Insert the absence element element. First we check if the
395: -- absence type is linked to an element type.
396: if hr_person_absence_api.linked_to_element(

Line 399: hr_utility.set_location(l_proc, 20);

395: -- absence type is linked to an element type.
396: if hr_person_absence_api.linked_to_element(
397: p_absence_attendance_id => p_absence_attendance_id) then
398: --
399: hr_utility.set_location(l_proc, 20);
400: -- Getting the processing type of the absence element
401: l_processing_type := hr_person_absence_api.get_processing_type(
402: p_absence_attendance_type_id => p_absence_att_type_id);
403: --

Line 408: hr_utility.set_location(l_proc, 30);

404: if (l_processing_type = 'N' and p_date_start is not null
405: and p_date_end is not null) or
406: (l_processing_type = 'R' and p_date_start is not null) then
407: --
408: hr_utility.set_location(l_proc, 30);
409: -- Getting the element details
410: hr_person_absence_api.get_element_details(
411: p_absence_attendance_id => p_absence_attendance_id,
412: p_element_type_id => l_element_type_id,

Line 416: hr_utility.set_location(l_proc, 40);

412: p_element_type_id => l_element_type_id,
413: p_input_value_id => l_input_value_id,
414: p_entry_value => l_entry_value);
415: -- Checking element link
416: hr_utility.set_location(l_proc, 40);
417: --
418: l_element_link_id := hr_entry_api.get_link(
419: p_assignment_id => p_line_record.assignment_id,
420: p_element_type_id => l_element_type_id,

Line 426: hr_utility.set_message(801,'HR_7448_ELE_PER_NOT_ELIGIBLE');

422: --
423: if l_element_link_id is null then
424: -- Assignment is not eligible for the element type
425: -- associated with this absence.
426: hr_utility.set_message(801,'HR_7448_ELE_PER_NOT_ELIGIBLE');
427: hr_utility.raise_error;
428: --
429: end if;
430: -- We know the assignment is eligible for this element because

Line 427: hr_utility.raise_error;

423: if l_element_link_id is null then
424: -- Assignment is not eligible for the element type
425: -- associated with this absence.
426: hr_utility.set_message(801,'HR_7448_ELE_PER_NOT_ELIGIBLE');
427: hr_utility.raise_error;
428: --
429: end if;
430: -- We know the assignment is eligible for this element because
431: -- we have the element_link_id. The entries API will handle

Line 455: hr_utility.set_location(l_proc, 50);

451: end if;
452: --
453: end loop;
454: --
455: hr_utility.set_location(l_proc, 50);
456: --
457: l_count := l_passed_val_tbl.count;
458: --
459: -- Calling the API to create EE

Line 530: hr_utility.set_location(l_proc, 60);

526: p_num_entry_values => l_count,
527: p_input_value_id_tbl => l_passed_inp_tbl,
528: p_entry_value_tbl => l_passed_val_tbl);
529: --
530: hr_utility.set_location(l_proc, 60);
531: -- Set the origin of the entry as the batch and its assignment action.
532: update pay_element_entries_f
533: set source_id = p_asg_act_id
534: where element_entry_id = l_element_entry_id;

Line 540: hr_utility.set_location(l_proc, 70);

536: -- absence end date through batch line.
537: if l_processing_type = 'R' and p_date_end is not null
538: and l_element_entry_id is not null then
539: --
540: hr_utility.set_location(l_proc, 70);
541: --
542: hr_entry_api.delete_element_entry(
543: p_dt_delete_mode => 'DELETE',
544: p_session_date => p_date_end,

Line 551: hr_utility.set_location(' Leaving:'||l_proc, 99);

547: end if;
548: end if; -- End of procesing type and date check
549: end if; -- End of absence type and element type link check
550: --
551: hr_utility.set_location(' Leaving:'||l_proc, 99);
552: --
553: end insert_absence_element;
554: --
555: procedure check_absence_overlap(p_date_start In DATE,

Line 937: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

933: l_payroll_id;
934: --
935: IF (C1%NOTFOUND) THEN
936: CLOSE C1;
937: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
938: hr_utility.set_message_token('PROCEDURE','insert_abs_for_paymix');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: END IF;

Line 938: hr_utility.set_message_token('PROCEDURE','insert_abs_for_paymix');

934: --
935: IF (C1%NOTFOUND) THEN
936: CLOSE C1;
937: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
938: hr_utility.set_message_token('PROCEDURE','insert_abs_for_paymix');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: END IF;
942: CLOSE C1;

Line 939: hr_utility.set_message_token('STEP','1');

935: IF (C1%NOTFOUND) THEN
936: CLOSE C1;
937: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
938: hr_utility.set_message_token('PROCEDURE','insert_abs_for_paymix');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: END IF;
942: CLOSE C1;
943: --

Line 940: hr_utility.raise_error;

936: CLOSE C1;
937: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
938: hr_utility.set_message_token('PROCEDURE','insert_abs_for_paymix');
939: hr_utility.set_message_token('STEP','1');
940: hr_utility.raise_error;
941: END IF;
942: CLOSE C1;
943: --
944: l_assignment_id := p_assignment_id;

Line 952: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

948: -- If either the payroll_id or the p_date_start is null then dont want
949: -- to continue.
950: --
951: IF l_payroll_id IS NULL OR p_date_start IS NULL THEN
952: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
953: hr_utility.raise_error;
954: END IF;
955: --
956: /*

Line 953: hr_utility.raise_error;

949: -- to continue.
950: --
951: IF l_payroll_id IS NULL OR p_date_start IS NULL THEN
952: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
953: hr_utility.raise_error;
954: END IF;
955: --
956: /*
957: -- Get Element type and input value id.

Line 993: hr_utility.set_message('PAY','HR_7448_ELE_PER_NOT_ELIGIBLE');

989: --
990: -- If element link does not exist then discontinue.
991: --
992: IF l_element_link_id IS NULL THEN
993: hr_utility.set_message('PAY','HR_7448_ELE_PER_NOT_ELIGIBLE');
994: hr_utility.raise_error;
995: END IF;
996: --
997: END IF;

Line 994: hr_utility.raise_error;

990: -- If element link does not exist then discontinue.
991: --
992: IF l_element_link_id IS NULL THEN
993: hr_utility.set_message('PAY','HR_7448_ELE_PER_NOT_ELIGIBLE');
994: hr_utility.raise_error;
995: END IF;
996: --
997: END IF;
998: --

Line 1234: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1230: l_payroll_id;
1231: --
1232: IF (C1%NOTFOUND) THEN
1233: CLOSE C1;
1234: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1235: hr_utility.set_message_token('PROCEDURE','insert_abs_for_bee');
1236: hr_utility.set_message_token('STEP','1');
1237: hr_utility.raise_error;
1238: END IF;

Line 1235: hr_utility.set_message_token('PROCEDURE','insert_abs_for_bee');

1231: --
1232: IF (C1%NOTFOUND) THEN
1233: CLOSE C1;
1234: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1235: hr_utility.set_message_token('PROCEDURE','insert_abs_for_bee');
1236: hr_utility.set_message_token('STEP','1');
1237: hr_utility.raise_error;
1238: END IF;
1239: CLOSE C1;

Line 1236: hr_utility.set_message_token('STEP','1');

1232: IF (C1%NOTFOUND) THEN
1233: CLOSE C1;
1234: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1235: hr_utility.set_message_token('PROCEDURE','insert_abs_for_bee');
1236: hr_utility.set_message_token('STEP','1');
1237: hr_utility.raise_error;
1238: END IF;
1239: CLOSE C1;
1240:

Line 1237: hr_utility.raise_error;

1233: CLOSE C1;
1234: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1235: hr_utility.set_message_token('PROCEDURE','insert_abs_for_bee');
1236: hr_utility.set_message_token('STEP','1');
1237: hr_utility.raise_error;
1238: END IF;
1239: CLOSE C1;
1240:
1241: --

Line 1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1242: -- If either the payroll_id or the p_date_start is null then dont want
1243: -- to continue.
1244: --
1245: IF l_payroll_id IS NULL OR p_date_start IS NULL THEN
1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1247: hr_utility.raise_error;
1248: END IF;
1249:
1250: --

Line 1247: hr_utility.raise_error;

1243: -- to continue.
1244: --
1245: IF l_payroll_id IS NULL OR p_date_start IS NULL THEN
1246: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1247: hr_utility.raise_error;
1248: END IF;
1249:
1250: --
1251: -- Fetch the default start and end times for an

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

1444: end chk_absence_input;
1445: --
1446: begin
1447: --
1448: hr_utility.set_location('Entering:'||l_proc, 10);
1449: --
1450: chk_absence_input(p_value => p_value,
1451: p_format => p_format,
1452: p_output => l_value,

Line 1455: hr_utility.set_location(l_proc, 10);

1451: p_format => p_format,
1452: p_output => l_value,
1453: p_result => l_result);
1454: --
1455: hr_utility.set_location(l_proc, 10);
1456: --
1457: if l_result = true then
1458: if p_hours_or_days = 'D' then
1459: l_absence_days := l_value;

Line 1466: hr_utility.set_location(l_proc, 20);

1462: l_absence_days := null;
1463: l_absence_hours := l_value;
1464: end if;
1465: --
1466: hr_utility.set_location(l_proc, 20);
1467: -- Calling the absence API after validation
1468: per_absence_attendances_pkg3.insert_abs_for_bee(
1469: p_session_date => p_line_record.effective_date,
1470: p_absence_att_type_id => p_absence_att_type_id,

Line 1481: hr_utility.set_location(l_proc, 30);

1477: p_date_end => p_date_end,
1478: p_warning_table => p_warning_table,
1479: p_error_table => p_error_table);
1480: --
1481: hr_utility.set_location(l_proc, 30);
1482: -- Creating absence element entry.
1483: insert_absence_element(
1484: p_line_record => p_line_record,
1485: p_asg_act_id => p_asg_act_id,

Line 1501: hr_utility.set_location(l_proc, 40);

1497: l_error := 'HR_51153_INVAL_NUM_FORMAT';
1498: l_error_table(l_error_count) := l_error;
1499: p_error_table := l_error_table;
1500: --
1501: hr_utility.set_location(l_proc, 40);
1502: --
1503: end if;
1504: --
1505: hr_utility.set_location(' Leaving:'||l_proc, 99);

Line 1505: hr_utility.set_location(' Leaving:'||l_proc, 99);

1501: hr_utility.set_location(l_proc, 40);
1502: --
1503: end if;
1504: --
1505: hr_utility.set_location(' Leaving:'||l_proc, 99);
1506: --
1507: end insert_abs_for_bee;
1508: --
1509: END PER_ABSENCE_ATTENDANCES_PKG3;