DBA Data[Home] [Help]

APPS.HR_RATING_SCALES_API dependencies on HR_API

Line 19: (p_language_code in varchar2 default hr_api.userenv_lang,

15: -- be passed through.
16: --
17:
18: procedure create_rating_scale
19: (p_language_code in varchar2 default hr_api.userenv_lang,
20: p_validate in boolean default false,
21: p_effective_date in date,
22: p_name in varchar2,
23: p_type in varchar2,

Line 67: hr_api.validate_language_code(p_language_code => l_language_code);

63: --
64: savepoint create_rating_scale;
65: hr_utility.set_location(l_proc, 6);
66: l_language_code := p_language_code;
67: hr_api.validate_language_code(p_language_code => l_language_code);
68: --
69: -- ngundura global rating scales cannot be created if Cross business
70: -- group profile is set to N
71: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP')='N' and p_business_group_id is null then

Line 110: when hr_api.cannot_find_prog_unit then

106: p_attribute19 => p_attribute19,
107: p_attribute20 => p_attribute20
108: );
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'create_rating_scale',
113: p_hook_type => 'BP'
114: );

Line 111: hr_api.cannot_find_prog_unit_error

107: p_attribute20 => p_attribute20
108: );
109: exception
110: when hr_api.cannot_find_prog_unit then
111: hr_api.cannot_find_prog_unit_error
112: (p_module_name => 'create_rating_scale',
113: p_hook_type => 'BP'
114: );
115: end;

Line 205: when hr_api.cannot_find_prog_unit then

201: p_attribute19 => p_attribute19,
202: p_attribute20 => p_attribute20
203: );
204: exception
205: when hr_api.cannot_find_prog_unit then
206: hr_api.cannot_find_prog_unit_error
207: (p_module_name => 'create_rating_scale',
208: p_hook_type => 'AP'
209: );

Line 206: hr_api.cannot_find_prog_unit_error

202: p_attribute20 => p_attribute20
203: );
204: exception
205: when hr_api.cannot_find_prog_unit then
206: hr_api.cannot_find_prog_unit_error
207: (p_module_name => 'create_rating_scale',
208: p_hook_type => 'AP'
209: );
210: end;

Line 217: raise hr_api.validate_enabled;

213: --
214: -- When in validation only mode raise the Validate_Enabled exception
215: --
216: if p_validate then
217: raise hr_api.validate_enabled;
218: end if;
219: --
220: -- Set all output arguments
221: --

Line 227: when hr_api.validate_enabled then

223: p_object_version_number := l_object_version_number;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 11);
226: exception
227: when hr_api.validate_enabled then
228: --
229: -- As the Validate_Enabled exception has been raised
230: -- we must rollback to the savepoint
231: --

Line 267: (p_language_code in varchar2 default hr_api.userenv_lang,

263: -- instead of p_language_code from now on, to allow an IN OUT parameter to
264: -- be passed through.
265: --
266: procedure update_rating_scale
267: (p_language_code in varchar2 default hr_api.userenv_lang,
268: p_validate in boolean default false,
269: p_effective_date in date,
270: p_rating_scale_id in number,
271: p_object_version_number in out NOCOPY number,

Line 272: p_name in varchar2 default hr_api.g_varchar2,

268: p_validate in boolean default false,
269: p_effective_date in date,
270: p_rating_scale_id in number,
271: p_object_version_number in out NOCOPY number,
272: p_name in varchar2 default hr_api.g_varchar2,
273: p_description in varchar2 default hr_api.g_varchar2,
274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 273: p_description in varchar2 default hr_api.g_varchar2,

269: p_effective_date in date,
270: p_rating_scale_id in number,
271: p_object_version_number in out NOCOPY number,
272: p_name in varchar2 default hr_api.g_varchar2,
273: p_description in varchar2 default hr_api.g_varchar2,
274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 274: p_default_flag in varchar2 default hr_api.g_varchar2,

270: p_rating_scale_id in number,
271: p_object_version_number in out NOCOPY number,
272: p_name in varchar2 default hr_api.g_varchar2,
273: p_description in varchar2 default hr_api.g_varchar2,
274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 275: p_attribute_category in varchar2 default hr_api.g_varchar2,

271: p_object_version_number in out NOCOPY number,
272: p_name in varchar2 default hr_api.g_varchar2,
273: p_description in varchar2 default hr_api.g_varchar2,
274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 276: p_attribute1 in varchar2 default hr_api.g_varchar2,

272: p_name in varchar2 default hr_api.g_varchar2,
273: p_description in varchar2 default hr_api.g_varchar2,
274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 277: p_attribute2 in varchar2 default hr_api.g_varchar2,

273: p_description in varchar2 default hr_api.g_varchar2,
274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 278: p_attribute3 in varchar2 default hr_api.g_varchar2,

274: p_default_flag in varchar2 default hr_api.g_varchar2,
275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 279: p_attribute4 in varchar2 default hr_api.g_varchar2,

275: p_attribute_category in varchar2 default hr_api.g_varchar2,
276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 280: p_attribute5 in varchar2 default hr_api.g_varchar2,

276: p_attribute1 in varchar2 default hr_api.g_varchar2,
277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 281: p_attribute6 in varchar2 default hr_api.g_varchar2,

277: p_attribute2 in varchar2 default hr_api.g_varchar2,
278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 282: p_attribute7 in varchar2 default hr_api.g_varchar2,

278: p_attribute3 in varchar2 default hr_api.g_varchar2,
279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 283: p_attribute8 in varchar2 default hr_api.g_varchar2,

279: p_attribute4 in varchar2 default hr_api.g_varchar2,
280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 284: p_attribute9 in varchar2 default hr_api.g_varchar2,

280: p_attribute5 in varchar2 default hr_api.g_varchar2,
281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 285: p_attribute10 in varchar2 default hr_api.g_varchar2,

281: p_attribute6 in varchar2 default hr_api.g_varchar2,
282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 286: p_attribute11 in varchar2 default hr_api.g_varchar2,

282: p_attribute7 in varchar2 default hr_api.g_varchar2,
283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 287: p_attribute12 in varchar2 default hr_api.g_varchar2,

283: p_attribute8 in varchar2 default hr_api.g_varchar2,
284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 288: p_attribute13 in varchar2 default hr_api.g_varchar2,

284: p_attribute9 in varchar2 default hr_api.g_varchar2,
285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 289: p_attribute14 in varchar2 default hr_api.g_varchar2,

285: p_attribute10 in varchar2 default hr_api.g_varchar2,
286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 290: p_attribute15 in varchar2 default hr_api.g_varchar2,

286: p_attribute11 in varchar2 default hr_api.g_varchar2,
287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,
294: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 291: p_attribute16 in varchar2 default hr_api.g_varchar2,

287: p_attribute12 in varchar2 default hr_api.g_varchar2,
288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,
294: p_attribute19 in varchar2 default hr_api.g_varchar2,
295: p_attribute20 in varchar2 default hr_api.g_varchar2

Line 292: p_attribute17 in varchar2 default hr_api.g_varchar2,

288: p_attribute13 in varchar2 default hr_api.g_varchar2,
289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,
294: p_attribute19 in varchar2 default hr_api.g_varchar2,
295: p_attribute20 in varchar2 default hr_api.g_varchar2
296: ) is

Line 293: p_attribute18 in varchar2 default hr_api.g_varchar2,

289: p_attribute14 in varchar2 default hr_api.g_varchar2,
290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,
294: p_attribute19 in varchar2 default hr_api.g_varchar2,
295: p_attribute20 in varchar2 default hr_api.g_varchar2
296: ) is
297: --

Line 294: p_attribute19 in varchar2 default hr_api.g_varchar2,

290: p_attribute15 in varchar2 default hr_api.g_varchar2,
291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,
294: p_attribute19 in varchar2 default hr_api.g_varchar2,
295: p_attribute20 in varchar2 default hr_api.g_varchar2
296: ) is
297: --
298: -- Declare cursors and local variables

Line 295: p_attribute20 in varchar2 default hr_api.g_varchar2

291: p_attribute16 in varchar2 default hr_api.g_varchar2,
292: p_attribute17 in varchar2 default hr_api.g_varchar2,
293: p_attribute18 in varchar2 default hr_api.g_varchar2,
294: p_attribute19 in varchar2 default hr_api.g_varchar2,
295: p_attribute20 in varchar2 default hr_api.g_varchar2
296: ) is
297: --
298: -- Declare cursors and local variables
299: --

Line 312: hr_api.validate_language_code(p_language_code => l_language_code);

308: -- Issue a savepoint.
309: --
310: savepoint update_rating_scale;
311: l_language_code := p_language_code;
312: hr_api.validate_language_code(p_language_code => l_language_code);
313: hr_utility.set_location(l_proc, 6);
314: --
315: -- Call Before Process User Hook
316: --

Line 349: when hr_api.cannot_find_prog_unit then

345: p_attribute19 => p_attribute19,
346: p_attribute20 => p_attribute20
347: );
348: exception
349: when hr_api.cannot_find_prog_unit then
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'update_rating_scale',
352: p_hook_type => 'BP'
353: );

Line 350: hr_api.cannot_find_prog_unit_error

346: p_attribute20 => p_attribute20
347: );
348: exception
349: when hr_api.cannot_find_prog_unit then
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'update_rating_scale',
352: p_hook_type => 'BP'
353: );
354: end;

Line 441: when hr_api.cannot_find_prog_unit then

437: p_attribute19 => p_attribute19,
438: p_attribute20 => p_attribute20
439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'update_rating_scale',
444: p_hook_type => 'AP'
445: );

Line 442: hr_api.cannot_find_prog_unit_error

438: p_attribute20 => p_attribute20
439: );
440: exception
441: when hr_api.cannot_find_prog_unit then
442: hr_api.cannot_find_prog_unit_error
443: (p_module_name => 'update_rating_scale',
444: p_hook_type => 'AP'
445: );
446: end;

Line 453: raise hr_api.validate_enabled;

449: --
450: -- When in validation only mode raise the Validate_Enabled exception
451: --
452: if p_validate then
453: raise hr_api.validate_enabled;
454: end if;
455: --
456: -- Set all output arguments. l_object_version_number now has the new
457: -- object version number as the update was successful

Line 464: when hr_api.validate_enabled then

460: p_object_version_number := l_object_version_number;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 11);
463: exception
464: when hr_api.validate_enabled then
465: --
466: -- As the Validate_Enabled exception has been raised
467: -- we must rollback to the savepoint
468: --

Line 533: when hr_api.cannot_find_prog_unit then

529: p_rating_scale_id => p_rating_scale_id,
530: p_object_version_number => p_object_version_number
531: );
532: exception
533: when hr_api.cannot_find_prog_unit then
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'delete_rating_scale',
536: p_hook_type => 'BP'
537: );

Line 534: hr_api.cannot_find_prog_unit_error

530: p_object_version_number => p_object_version_number
531: );
532: exception
533: when hr_api.cannot_find_prog_unit then
534: hr_api.cannot_find_prog_unit_error
535: (p_module_name => 'delete_rating_scale',
536: p_hook_type => 'BP'
537: );
538: end;

Line 582: when hr_api.cannot_find_prog_unit then

578: p_rating_scale_id => p_rating_scale_id,
579: p_object_version_number => p_object_version_number
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'delete_rating_scale',
585: p_hook_type => 'AP'
586: );

Line 583: hr_api.cannot_find_prog_unit_error

579: p_object_version_number => p_object_version_number
580: );
581: exception
582: when hr_api.cannot_find_prog_unit then
583: hr_api.cannot_find_prog_unit_error
584: (p_module_name => 'delete_rating_scale',
585: p_hook_type => 'AP'
586: );
587: end;

Line 594: raise hr_api.validate_enabled;

590: --
591: -- When in validation only mode raise the Validate_Enabled exception
592: --
593: if p_validate then
594: raise hr_api.validate_enabled;
595: end if;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 11);
598: exception

Line 599: when hr_api.validate_enabled then

595: end if;
596: --
597: hr_utility.set_location(' Leaving:'||l_proc, 11);
598: exception
599: when hr_api.validate_enabled then
600: --
601: -- As the Validate_Enabled exception has been raised
602: -- we must rollback to the savepoint
603: --

Line 625: (p_language_code in varchar2 default hr_api.userenv_lang

621: -- ----------------------------------------------------------------------------
622: -- |-------------------< >---------------------|
623: -- ----------------------------------------------------------------------------
624: procedure create_or_update_rating_scale
625: (p_language_code in varchar2 default hr_api.userenv_lang
626: ,p_validate in boolean default false
627: ,p_effective_date in date default trunc(sysdate)
628: ,p_name in varchar2 default null
629: ,p_type in varchar2 default null

Line 700: l_language_code := hr_api.userenv_lang;

696:
697: hr_rating_scales_api.g_ignore_df := 'Y';
698:
699: if (p_language_code is NULL) then
700: l_language_code := hr_api.userenv_lang;
701: else
702: l_language_code := p_language_code;
703: -- BUG3668368
704: hr_api.validate_language_code(p_language_code => l_language_code);

Line 704: hr_api.validate_language_code(p_language_code => l_language_code);

700: l_language_code := hr_api.userenv_lang;
701: else
702: l_language_code := p_language_code;
703: -- BUG3668368
704: hr_api.validate_language_code(p_language_code => l_language_code);
705: end if;
706:
707: if (p_effective_date is NULL) then
708: l_effective_date := trunc(sysdate);

Line 801: hr_api.validate_language_code(p_language_code => l_translated_language);

797: hr_utility.trace('l_source_reating_scale_id : ' || l_source_rating_scale_id);
798: hr_utility.trace('l_source_ovn : ' || l_source_ovn);
799:
800: l_translated_language := p_translated_language;
801: hr_api.validate_language_code(p_language_code => l_translated_language);
802:
803: --
804: -- MLS update
805: --

Line 849: when hr_api.cannot_find_prog_unit then

845: p_attribute19 => NULL,
846: p_attribute20 => NULL
847: );
848: exception
849: when hr_api.cannot_find_prog_unit then
850: hr_rating_scales_api.g_ignore_df := 'N';
851: hr_api.cannot_find_prog_unit_error
852: (p_module_name => 'update_rating_scale',
853: p_hook_type => 'AP'

Line 851: hr_api.cannot_find_prog_unit_error

847: );
848: exception
849: when hr_api.cannot_find_prog_unit then
850: hr_rating_scales_api.g_ignore_df := 'N';
851: hr_api.cannot_find_prog_unit_error
852: (p_module_name => 'update_rating_scale',
853: p_hook_type => 'AP'
854: );
855: end;

Line 865: when hr_api.validate_enabled then

861:
862: hr_rating_scales_api.g_ignore_df := 'N';
863: hr_utility.set_location('Leaving ... ' || l_proc,110);
864: exception
865: when hr_api.validate_enabled then
866: --
867: -- As the Validate_Enabled exception has been raised
868: -- we must rollback to the savepoint
869: --