DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_NUMBERS_API dependencies on HR_API

Line 49: when hr_api.cannot_find_prog_unit then

45: ,P_DESCRIPTION => P_DESCRIPTION);
46:
47:
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'CREATE_LEVEL_NUMBERS'
52: ,p_hook_type => 'BP'
53: );

Line 50: hr_api.cannot_find_prog_unit_error

46:
47:
48: exception
49: when hr_api.cannot_find_prog_unit then
50: hr_api.cannot_find_prog_unit_error
51: (p_module_name => 'CREATE_LEVEL_NUMBERS'
52: ,p_hook_type => 'BP'
53: );
54: end;

Line 82: when hr_api.cannot_find_prog_unit then

78: ,P_LEVEL_NUMBER_ID => l_LEVEL_NUMBER_ID
79: ,p_object_version_number => l_object_version_number);
80:
81: exception
82: when hr_api.cannot_find_prog_unit then
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'CREATE_LEVEL_NUMBERS'
85: ,p_hook_type => 'AP'
86: );

Line 83: hr_api.cannot_find_prog_unit_error

79: ,p_object_version_number => l_object_version_number);
80:
81: exception
82: when hr_api.cannot_find_prog_unit then
83: hr_api.cannot_find_prog_unit_error
84: (p_module_name => 'CREATE_LEVEL_NUMBERS'
85: ,p_hook_type => 'AP'
86: );
87: end;

Line 92: raise hr_api.validate_enabled;

88: --
89: -- When in validation only mode raise the Validate_Enabled exception
90: --
91: if p_validate then
92: raise hr_api.validate_enabled;
93: end if;
94: --
95: -- Set all output arguments
96: --

Line 103: when hr_api.validate_enabled then

99:
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 70);
102: exception
103: when hr_api.validate_enabled then
104: --
105: -- As the Validate_Enabled exception has been raised
106: -- we must rollback to the savepoint
107: --

Line 137: ,p_LEVEL_NUMBER In Varchar2 Default hr_api.g_Varchar2

133:
134: procedure Update_LEVEL_NUMBERS
135: (p_validate in boolean default false
136: ,p_effective_date in date
137: ,p_LEVEL_NUMBER In Varchar2 Default hr_api.g_Varchar2
138: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
139: ,P_LEVEL_NUMBER_ID In Number
140: ,p_object_version_number IN out nocopy number) Is
141:

Line 138: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2

134: procedure Update_LEVEL_NUMBERS
135: (p_validate in boolean default false
136: ,p_effective_date in date
137: ,p_LEVEL_NUMBER In Varchar2 Default hr_api.g_Varchar2
138: ,P_DESCRIPTION In Varchar2 Default hr_api.g_Varchar2
139: ,P_LEVEL_NUMBER_ID In Number
140: ,p_object_version_number IN out nocopy number) Is
141:
142: l_proc varchar2(72) := g_package||'Update_LEVEL_NUMBERS';

Line 171: when hr_api.cannot_find_prog_unit then

167: ,p_object_version_number => l_object_version_number);
168:
169:
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
174: ,p_hook_type => 'BP'
175: );

Line 172: hr_api.cannot_find_prog_unit_error

168:
169:
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
174: ,p_hook_type => 'BP'
175: );
176: end;

Line 200: when hr_api.cannot_find_prog_unit then

196: ,P_LEVEL_NUMBER_ID => p_LEVEL_NUMBER_ID
197: ,p_object_version_number => l_object_version_number);
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
203: ,p_hook_type => 'AP'
204: );

Line 201: hr_api.cannot_find_prog_unit_error

197: ,p_object_version_number => l_object_version_number);
198:
199: exception
200: when hr_api.cannot_find_prog_unit then
201: hr_api.cannot_find_prog_unit_error
202: (p_module_name => 'UPDATE_LEVEL_NUMBERS'
203: ,p_hook_type => 'AP'
204: );
205: end;

Line 210: raise hr_api.validate_enabled;

206: --
207: -- When in validation only mode raise the Validate_Enabled exception
208: --
209: if p_validate then
210: raise hr_api.validate_enabled;
211: end if;
212: --
213: -- Set all output arguments
214: --

Line 221: when hr_api.validate_enabled then

217:
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised
224: -- we must rollback to the savepoint
225: --

Line 276: when hr_api.cannot_find_prog_unit then

272: PQH_DE_LEVEL_NUMBERS_BK3.Delete_LEVEL_NUMBERS_b
273: (p_LEVEL_NUMBER_Id => p_LEVEL_NUMBER_Id
274: ,p_object_version_number => p_object_version_number);
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'delete_LEVEL_NUMBERS'
279: ,p_hook_type => 'BP');
280: end;

Line 277: hr_api.cannot_find_prog_unit_error

273: (p_LEVEL_NUMBER_Id => p_LEVEL_NUMBER_Id
274: ,p_object_version_number => p_object_version_number);
275: exception
276: when hr_api.cannot_find_prog_unit then
277: hr_api.cannot_find_prog_unit_error
278: (p_module_name => 'delete_LEVEL_NUMBERS'
279: ,p_hook_type => 'BP');
280: end;
281: --

Line 298: when hr_api.cannot_find_prog_unit then

294: (p_LEVEL_NUMBER_Id => p_LEVEL_NUMBER_Id
295: ,p_object_version_number => p_object_version_number);
296:
297: exception
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'DELETE_LEVEL_NUMBERS'
301: ,p_hook_type => 'AP');
302: end;

Line 299: hr_api.cannot_find_prog_unit_error

295: ,p_object_version_number => p_object_version_number);
296:
297: exception
298: when hr_api.cannot_find_prog_unit then
299: hr_api.cannot_find_prog_unit_error
300: (p_module_name => 'DELETE_LEVEL_NUMBERS'
301: ,p_hook_type => 'AP');
302: end;
303: --

Line 307: raise hr_api.validate_enabled;

303: --
304: -- When in validation only mode raise the Validate_Enabled exception
305: --
306: if p_validate then
307: raise hr_api.validate_enabled;
308: end if;
309: --
310: -- Set all output arguments
311: --

Line 314: when hr_api.validate_enabled then

310: -- Set all output arguments
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 70);
313: exception
314: when hr_api.validate_enabled then
315: --
316: -- As the Validate_Enabled exception has been raised
317: -- we must rollback to the savepoint
318: --