DBA Data[Home] [Help]

APPS.HR_IN_PERSON_EXTRA_INFO_API dependencies on HR_UTILITY

Line 27: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

23: FETCH check_legislation into l_legislation_code;
24:
25: IF check_legislation%notfound THEN
26: CLOSE check_legislation;
27: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
28: hr_utility.raise_error;
29: END IF;
30:
31: CLOSE check_legislation;

Line 28: hr_utility.raise_error;

24:
25: IF check_legislation%notfound THEN
26: CLOSE check_legislation;
27: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
28: hr_utility.raise_error;
29: END IF;
30:
31: CLOSE check_legislation;
32:

Line 34: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');

30:
31: CLOSE check_legislation;
32:
33: IF hr_general2.IS_BG(l_legislation_code ,p_legislation_code) = false THEN
34: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
35: hr_utility.raise_error;
36: END IF;
37:
38: END check_person;

Line 35: hr_utility.raise_error;

31: CLOSE check_legislation;
32:
33: IF hr_general2.IS_BG(l_legislation_code ,p_legislation_code) = false THEN
34: hr_utility.set_message(800, 'HR_7208_API_BUS_GRP_INVALID');
35: hr_utility.raise_error;
36: END IF;
37:
38: END check_person;
39:

Line 84: g_trace := hr_utility.debug_enabled ;

80: --
81: BEGIN
82:
83: l_proc := g_package||'create_in_person_extra_info';
84: g_trace := hr_utility.debug_enabled ;
85: IF g_trace THEN
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: END IF;
88:

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

82:
83: l_proc := g_package||'create_in_person_extra_info';
84: g_trace := hr_utility.debug_enabled ;
85: IF g_trace THEN
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: END IF;
88:
89: check_person (p_person_id, 'IN');
90:

Line 92: hr_utility.set_location('Entering:'|| l_proc, 20);

88:
89: check_person (p_person_id, 'IN');
90:
91: IF g_trace THEN
92: hr_utility.set_location('Entering:'|| l_proc, 20);
93: END IF;
94:
95: hr_person_extra_info_api.create_person_extra_info
96: (p_person_id => p_person_id,

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

126: p_validate => p_validate,
127: p_person_extra_info_id => p_person_extra_info_id);
128:
129: IF g_trace THEN
130: hr_utility.set_location('Leaving:'|| l_proc, 30);
131: END IF;
132:
133: END create_in_person_extra_info;
134:

Line 178: g_trace := hr_utility.debug_enabled ;

174:
175: begin
176:
177: l_proc := g_package||'update_person_extra_info';
178: g_trace := hr_utility.debug_enabled ;
179:
180: IF g_trace THEN
181: hr_utility.set_location('Entering:'|| l_proc, 10);
182: END IF;

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

177: l_proc := g_package||'update_person_extra_info';
178: g_trace := hr_utility.debug_enabled ;
179:
180: IF g_trace THEN
181: hr_utility.set_location('Entering:'|| l_proc, 10);
182: END IF;
183:
184: hr_person_extra_info_api.update_person_extra_info
185: (p_validate => p_validate,

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

214: p_object_version_number => p_object_version_number
215: );
216:
217: IF g_trace THEN
218: hr_utility.set_location('Leaving:'|| l_proc, 20);
219: END IF;
220:
221: END update_in_person_extra_info;
222:

Line 268: g_trace := hr_utility.debug_enabled ;

264: --
265: BEGIN
266:
267: l_proc := g_package||'create_in_passport_details';
268: g_trace := hr_utility.debug_enabled ;
269: IF g_trace THEN
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271: END IF;
272:

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

266:
267: l_proc := g_package||'create_in_passport_details';
268: g_trace := hr_utility.debug_enabled ;
269: IF g_trace THEN
270: hr_utility.set_location('Entering:'|| l_proc, 10);
271: END IF;
272:
273: check_person (p_person_id, 'IN');
274:

Line 276: hr_utility.set_location('Entering:'|| l_proc, 20);

272:
273: check_person (p_person_id, 'IN');
274:
275: IF g_trace THEN
276: hr_utility.set_location('Entering:'|| l_proc, 20);
277: END IF;
278:
279: hr_person_extra_info_api.create_person_extra_info
280: (p_person_id => p_person_id,

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

312: p_validate => p_validate,
313: p_person_extra_info_id => p_person_extra_info_id);
314:
315: IF g_trace THEN
316: hr_utility.set_location('Leaving:'|| l_proc, 30);
317: END IF;
318: END create_in_passport_details;
319:
320: -- ----------------------------------------------------------------------------

Line 365: g_trace := hr_utility.debug_enabled ;

361:
362: begin
363:
364: l_proc := g_package||'update_passport_details';
365: g_trace := hr_utility.debug_enabled ;
366:
367: IF g_trace THEN
368: hr_utility.set_location('Entering:'|| l_proc, 10);
369: END IF;

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

364: l_proc := g_package||'update_passport_details';
365: g_trace := hr_utility.debug_enabled ;
366:
367: IF g_trace THEN
368: hr_utility.set_location('Entering:'|| l_proc, 10);
369: END IF;
370:
371: hr_person_extra_info_api.update_person_extra_info
372: (p_validate => p_validate,

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

403: p_object_version_number => p_object_version_number
404: );
405:
406: IF g_trace THEN
407: hr_utility.set_location('Leaving:'|| l_proc, 20);
408: END IF;
409: END update_in_passport_details;
410: END hr_in_person_extra_info_api;