DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_CODES_API dependencies on HR_API

Line 55: when hr_api.cannot_find_prog_unit then

51: ,p_gradual_value_number => p_gradual_value_number
52: );
53:
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'CREATE_LEVEL_CODES'
58: ,p_hook_type => 'BP'
59: );

Line 56: hr_api.cannot_find_prog_unit_error

52: );
53:
54: exception
55: when hr_api.cannot_find_prog_unit then
56: hr_api.cannot_find_prog_unit_error
57: (p_module_name => 'CREATE_LEVEL_CODES'
58: ,p_hook_type => 'BP'
59: );
60: end;

Line 93: when hr_api.cannot_find_prog_unit then

89: );
90:
91:
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'INSERT_LEVEL_CODES'
96: ,p_hook_type => 'AP'
97: );

Line 94: hr_api.cannot_find_prog_unit_error

90:
91:
92: exception
93: when hr_api.cannot_find_prog_unit then
94: hr_api.cannot_find_prog_unit_error
95: (p_module_name => 'INSERT_LEVEL_CODES'
96: ,p_hook_type => 'AP'
97: );
98: end;

Line 103: raise hr_api.validate_enabled;

99: --
100: -- When in validation only mode raise the Validate_Enabled exception
101: --
102: if p_validate then
103: raise hr_api.validate_enabled;
104: end if;
105: --
106: -- Set all output arguments
107: --

Line 114: when hr_api.validate_enabled then

110:
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 70);
113: exception
114: when hr_api.validate_enabled then
115: --
116: -- As the Validate_Enabled exception has been raised
117: -- we must rollback to the savepoint
118: --

Line 150: ,p_level_number_id in number default hr_api.g_number

146: (p_validate in boolean default false
147: ,p_effective_date in date
148: ,p_level_code_id in number
149: ,p_object_version_number in out nocopy number
150: ,p_level_number_id in number default hr_api.g_number
151: ,p_level_code in varchar2 default hr_api.g_varchar2
152: ,p_description in varchar2 default hr_api.g_varchar2
153: ,p_gradual_value_number in number default hr_api.g_number
154: ) Is

Line 151: ,p_level_code in varchar2 default hr_api.g_varchar2

147: ,p_effective_date in date
148: ,p_level_code_id in number
149: ,p_object_version_number in out nocopy number
150: ,p_level_number_id in number default hr_api.g_number
151: ,p_level_code in varchar2 default hr_api.g_varchar2
152: ,p_description in varchar2 default hr_api.g_varchar2
153: ,p_gradual_value_number in number default hr_api.g_number
154: ) Is
155:

Line 152: ,p_description in varchar2 default hr_api.g_varchar2

148: ,p_level_code_id in number
149: ,p_object_version_number in out nocopy number
150: ,p_level_number_id in number default hr_api.g_number
151: ,p_level_code in varchar2 default hr_api.g_varchar2
152: ,p_description in varchar2 default hr_api.g_varchar2
153: ,p_gradual_value_number in number default hr_api.g_number
154: ) Is
155:
156: l_proc varchar2(72) := g_package||'Update_LEVEL_CODES';

Line 153: ,p_gradual_value_number in number default hr_api.g_number

149: ,p_object_version_number in out nocopy number
150: ,p_level_number_id in number default hr_api.g_number
151: ,p_level_code in varchar2 default hr_api.g_varchar2
152: ,p_description in varchar2 default hr_api.g_varchar2
153: ,p_gradual_value_number in number default hr_api.g_number
154: ) Is
155:
156: l_proc varchar2(72) := g_package||'Update_LEVEL_CODES';
157: l_object_Version_Number PQH_DE_LEVEL_CODES.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

Line 188: when hr_api.cannot_find_prog_unit then

184: );
185:
186:
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'UPDATE_LEVEL_CODES'
191: ,p_hook_type => 'BP'
192: );

Line 189: hr_api.cannot_find_prog_unit_error

185:
186:
187: exception
188: when hr_api.cannot_find_prog_unit then
189: hr_api.cannot_find_prog_unit_error
190: (p_module_name => 'UPDATE_LEVEL_CODES'
191: ,p_hook_type => 'BP'
192: );
193: end;

Line 223: when hr_api.cannot_find_prog_unit then

219: ,p_object_version_number => p_object_version_number
220: );
221:
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'UPDATE_LEVEL_CODES'
226: ,p_hook_type => 'AP'
227: );

Line 224: hr_api.cannot_find_prog_unit_error

220: );
221:
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'UPDATE_LEVEL_CODES'
226: ,p_hook_type => 'AP'
227: );
228: end;

Line 233: raise hr_api.validate_enabled;

229: --
230: -- When in validation only mode raise the Validate_Enabled exception
231: --
232: if p_validate then
233: raise hr_api.validate_enabled;
234: end if;
235: --
236: -- Set all output arguments
237: --

Line 244: when hr_api.validate_enabled then

240:
241: --
242: hr_utility.set_location(' Leaving:'||l_proc, 70);
243: exception
244: when hr_api.validate_enabled then
245: --
246: -- As the Validate_Enabled exception has been raised
247: -- we must rollback to the savepoint
248: --

Line 294: when hr_api.cannot_find_prog_unit then

290: PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_b
291: (p_LEVEL_CODE_Id => p_LEVEL_CODE_Id
292: ,p_object_version_number => p_object_version_number);
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'DELETE_LEVEL_CODES'
297: ,p_hook_type => 'BP');
298: end;

Line 295: hr_api.cannot_find_prog_unit_error

291: (p_LEVEL_CODE_Id => p_LEVEL_CODE_Id
292: ,p_object_version_number => p_object_version_number);
293: exception
294: when hr_api.cannot_find_prog_unit then
295: hr_api.cannot_find_prog_unit_error
296: (p_module_name => 'DELETE_LEVEL_CODES'
297: ,p_hook_type => 'BP');
298: end;
299: --

Line 316: when hr_api.cannot_find_prog_unit then

312: (p_LEVEL_CODE_Id => p_LEVEL_CODE_Id
313: ,p_object_version_number => p_object_version_number);
314:
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'DELETE_LEVEL_CODES'
319: ,p_hook_type => 'AP');
320: end;

Line 317: hr_api.cannot_find_prog_unit_error

313: ,p_object_version_number => p_object_version_number);
314:
315: exception
316: when hr_api.cannot_find_prog_unit then
317: hr_api.cannot_find_prog_unit_error
318: (p_module_name => 'DELETE_LEVEL_CODES'
319: ,p_hook_type => 'AP');
320: end;
321: --

Line 325: raise hr_api.validate_enabled;

321: --
322: -- When in validation only mode raise the Validate_Enabled exception
323: --
324: if p_validate then
325: raise hr_api.validate_enabled;
326: end if;
327: --
328: -- Set all output arguments
329: --

Line 332: when hr_api.validate_enabled then

328: -- Set all output arguments
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: exception
332: when hr_api.validate_enabled then
333: --
334: -- As the Validate_Enabled exception has been raised
335: -- we must rollback to the savepoint
336: --