DBA Data[Home] [Help]

APPS.GHR_SS_ASG_EIT dependencies on HR_UTILITY

Line 57: hr_utility.set_location('Entering'||l_proc,100);

53: from PER_ASSIGNMENT_EXTRA_INFO
54: where assignment_extra_info_id = p_assignment_extra_info_id;
55:
56: BEGIN
57: hr_utility.set_location('Entering'||l_proc,100);
58:
59: v_is_ghr_setup_avl := 'FALSE';
60: OPEN c_fed_setup_avl;
61: FETCH c_fed_setup_avl into r_setup_cnt;

Line 84: hr_utility.set_location(l_proc, 15);

80: close get_row_id;
81:
82: l_row_touched := ghr_history_api.row_already_touched(l_row_id);
83: IF l_row_touched then
84: hr_utility.set_location(l_proc, 15);
85: null;
86: else
87: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',
88: p_table_pk_id => p_assignment_extra_info_id,

Line 153: hr_utility.set_location('Entering'||l_proc,100);

149: from PER_ASSIGNMENT_EXTRA_INFO
150: where assignment_extra_info_id = p_assignment_extra_info_id;
151:
152: BEGIN
153: hr_utility.set_location('Entering'||l_proc,100);
154:
155: v_is_ghr_setup_avl := 'FALSE';
156: OPEN c_fed_setup_avl;
157: FETCH c_fed_setup_avl into r_setup_cnt;

Line 181: hr_utility.set_location(l_proc, 15);

177:
178: l_row_touched := ghr_history_api.row_already_touched(l_row_id);
179:
180: IF l_row_touched then
181: hr_utility.set_location(l_proc, 15);
182: null;
183: else
184: indx := ghr_history_api.add_row_operation_info_rg(p_table_name => 'PER_ASSIGNMENT_EXTRA_INFO',
185: p_table_pk_id => p_assignment_extra_info_id,

Line 217: hr_utility.set_message(8301, 'GHR_37613_ALL_PROCEDURE_FAIL');

213: FOR get_tel_info in c_tel_asg_info
214: LOOP
215: IF get_tel_info.aei_information9 IS NOT NULL AND get_tel_info.aei_information5 IS NOT NULL AND
216: fnd_date.canonical_to_date(get_tel_info.aei_information9) >= fnd_date.canonical_to_date(get_tel_info.aei_information5) THEN
217: hr_utility.set_message(8301, 'GHR_37613_ALL_PROCEDURE_FAIL');
218: hr_utility.raise_error;
219: END IF;
220:
221: IF get_tel_info.aei_information1 ='4' AND get_tel_info.aei_information2 IS NULL AND get_tel_info.aei_information3 IS NULL THEN

Line 218: hr_utility.raise_error;

214: LOOP
215: IF get_tel_info.aei_information9 IS NOT NULL AND get_tel_info.aei_information5 IS NOT NULL AND
216: fnd_date.canonical_to_date(get_tel_info.aei_information9) >= fnd_date.canonical_to_date(get_tel_info.aei_information5) THEN
217: hr_utility.set_message(8301, 'GHR_37613_ALL_PROCEDURE_FAIL');
218: hr_utility.raise_error;
219: END IF;
220:
221: IF get_tel_info.aei_information1 ='4' AND get_tel_info.aei_information2 IS NULL AND get_tel_info.aei_information3 IS NULL THEN
222: hr_utility.set_message(8301,'GHR_37614_ALL_PROCEDURE_FAIL');

Line 222: hr_utility.set_message(8301,'GHR_37614_ALL_PROCEDURE_FAIL');

218: hr_utility.raise_error;
219: END IF;
220:
221: IF get_tel_info.aei_information1 ='4' AND get_tel_info.aei_information2 IS NULL AND get_tel_info.aei_information3 IS NULL THEN
222: hr_utility.set_message(8301,'GHR_37614_ALL_PROCEDURE_FAIL');
223: hr_utility.raise_error;
224: END IF;
225:
226: IF get_tel_info.aei_information6 IS NOT NULL AND

Line 223: hr_utility.raise_error;

219: END IF;
220:
221: IF get_tel_info.aei_information1 ='4' AND get_tel_info.aei_information2 IS NULL AND get_tel_info.aei_information3 IS NULL THEN
222: hr_utility.set_message(8301,'GHR_37614_ALL_PROCEDURE_FAIL');
223: hr_utility.raise_error;
224: END IF;
225:
226: IF get_tel_info.aei_information6 IS NOT NULL AND
227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))

Line 229: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');

225:
226: IF get_tel_info.aei_information6 IS NOT NULL AND
227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))
228: >= fnd_date.canonical_to_date(get_tel_info.aei_information6) THEN
229: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('ITEM','Telework Agreement');
231: hr_utility.raise_error;
232: END IF;
233: END LOOP;

Line 230: hr_utility.set_message_token('ITEM','Telework Agreement');

226: IF get_tel_info.aei_information6 IS NOT NULL AND
227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))
228: >= fnd_date.canonical_to_date(get_tel_info.aei_information6) THEN
229: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('ITEM','Telework Agreement');
231: hr_utility.raise_error;
232: END IF;
233: END LOOP;
234:

Line 231: hr_utility.raise_error;

227: fnd_date.canonical_to_date(NVL(get_tel_info.aei_information5,get_tel_info.aei_information6))
228: >= fnd_date.canonical_to_date(get_tel_info.aei_information6) THEN
229: hr_utility.set_message(8301, 'GHR_37699_ALL_PROCEDURE_FAIL');
230: hr_utility.set_message_token('ITEM','Telework Agreement');
231: hr_utility.raise_error;
232: END IF;
233: END LOOP;
234:
235: END VALIDATE_TELEWORK_DET;