APPS.PQH_DE_INS_END_REASONS_API dependencies on HR_API

Line 59: when hr_api.cannot_find_prog_unit then

55: );
56:
57:
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_PENSION_END_REASONS'
62: ,p_hook_type => 'BP'
63: );

Line 60: hr_api.cannot_find_prog_unit_error

56:
57:
58: exception
59: when hr_api.cannot_find_prog_unit then
60: hr_api.cannot_find_prog_unit_error
61: (p_module_name => 'CREATE_PENSION_END_REASONS'
62: ,p_hook_type => 'BP'
63: );
64: end;

Line 99: when hr_api.cannot_find_prog_unit then

95: ,p_object_version_number => p_object_version_number
96: );
97:
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'INSERT_PENSION_END_REASONS'
102: ,p_hook_type => 'AP'
103: );

Line 100: hr_api.cannot_find_prog_unit_error

96: );
97:
98: exception
99: when hr_api.cannot_find_prog_unit then
100: hr_api.cannot_find_prog_unit_error
101: (p_module_name => 'INSERT_PENSION_END_REASONS'
102: ,p_hook_type => 'AP'
103: );
104: end;

Line 109: raise hr_api.validate_enabled;

105: --
106: -- When in validation only mode raise the Validate_Enabled exception
107: --
108: if p_validate then
109: raise hr_api.validate_enabled;
110: end if;
111: --
112: -- Set all output arguments
113: --

Line 120: when hr_api.validate_enabled then

116:
117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 70);
119: exception
120: when hr_api.validate_enabled then
121: --
122: -- As the Validate_Enabled exception has been raised
123: -- we must rollback to the savepoint
124: --

Line 156: ,p_business_group_id in number default hr_api.g_number

152: ( p_validate in boolean default false
153: ,p_effective_date in date
154: ,p_InS_end_reason_id in number
155: ,p_object_version_number in out nocopy number
156: ,p_business_group_id in number default hr_api.g_number
157: ,p_provider_organization_id in number default hr_api.g_number
158: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
159: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2

Line 157: ,p_provider_organization_id in number default hr_api.g_number

153: ,p_effective_date in date
154: ,p_InS_end_reason_id in number
155: ,p_object_version_number in out nocopy number
156: ,p_business_group_id in number default hr_api.g_number
157: ,p_provider_organization_id in number default hr_api.g_number
158: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
159: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
161: ) Is

Line 158: ,p_end_reason_number in varchar2 default hr_api.g_varchar2

154: ,p_InS_end_reason_id in number
155: ,p_object_version_number in out nocopy number
156: ,p_business_group_id in number default hr_api.g_number
157: ,p_provider_organization_id in number default hr_api.g_number
158: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
159: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
161: ) Is
162:

Line 159: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2

155: ,p_object_version_number in out nocopy number
156: ,p_business_group_id in number default hr_api.g_number
157: ,p_provider_organization_id in number default hr_api.g_number
158: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
159: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
161: ) Is
162:
163: l_proc varchar2(72) := g_package||'Update_PENSION_END_REASONS';

Line 160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2

156: ,p_business_group_id in number default hr_api.g_number
157: ,p_provider_organization_id in number default hr_api.g_number
158: ,p_end_reason_number in varchar2 default hr_api.g_varchar2
159: ,p_end_reason_short_name in varchar2 default hr_api.g_varchar2
160: ,p_end_reason_description in varchar2 default hr_api.g_varchar2
161: ) Is
162:
163: l_proc varchar2(72) := g_package||'Update_PENSION_END_REASONS';
164: l_object_Version_Number PQH_DE_INS_END_REASONS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;

Line 196: when hr_api.cannot_find_prog_unit then

192: );
193:
194:
195: exception
196: when hr_api.cannot_find_prog_unit then
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'UPDATE_PENSION_END_REASONS'
199: ,p_hook_type => 'BP'
200: );

Line 197: hr_api.cannot_find_prog_unit_error

193:
194:
195: exception
196: when hr_api.cannot_find_prog_unit then
197: hr_api.cannot_find_prog_unit_error
198: (p_module_name => 'UPDATE_PENSION_END_REASONS'
199: ,p_hook_type => 'BP'
200: );
201: end;

Line 234: when hr_api.cannot_find_prog_unit then

230: );
231:
232:
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_PENSION_END_REASONS'
237: ,p_hook_type => 'AP'
238: );

Line 235: hr_api.cannot_find_prog_unit_error

231:
232:
233: exception
234: when hr_api.cannot_find_prog_unit then
235: hr_api.cannot_find_prog_unit_error
236: (p_module_name => 'UPDATE_PENSION_END_REASONS'
237: ,p_hook_type => 'AP'
238: );
239: end;

Line 244: raise hr_api.validate_enabled;

240: --
241: -- When in validation only mode raise the Validate_Enabled exception
242: --
243: if p_validate then
244: raise hr_api.validate_enabled;
245: end if;
246: --
247: -- Set all output arguments
248: --

Line 255: when hr_api.validate_enabled then

251:
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 70);
254: exception
255: when hr_api.validate_enabled then
256: --
257: -- As the Validate_Enabled exception has been raised
258: -- we must rollback to the savepoint
259: --

Line 305: when hr_api.cannot_find_prog_unit then

301: PQH_DE_ins_END_REASONS_BK3.Delete_PENSION_END_REASONS_b
302: (p_InS_end_reason_id => p_INS_END_REASON_Id
303: ,p_object_version_number => p_object_version_number);
304: exception
305: when hr_api.cannot_find_prog_unit then
306: hr_api.cannot_find_prog_unit_error
307: (p_module_name => 'DELETE_PENSION_END_REASONS'
308: ,p_hook_type => 'BP');
309: end;

Line 306: hr_api.cannot_find_prog_unit_error

302: (p_InS_end_reason_id => p_INS_END_REASON_Id
303: ,p_object_version_number => p_object_version_number);
304: exception
305: when hr_api.cannot_find_prog_unit then
306: hr_api.cannot_find_prog_unit_error
307: (p_module_name => 'DELETE_PENSION_END_REASONS'
308: ,p_hook_type => 'BP');
309: end;
310: --

Line 327: when hr_api.cannot_find_prog_unit then

323: (p_InS_end_reason_id => p_iNs_END_REASON_Id
324: ,p_object_version_number => p_object_version_number);
325:
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'DELETE_PENSION_END_REASONS'
330: ,p_hook_type => 'AP');
331: end;

Line 328: hr_api.cannot_find_prog_unit_error

324: ,p_object_version_number => p_object_version_number);
325:
326: exception
327: when hr_api.cannot_find_prog_unit then
328: hr_api.cannot_find_prog_unit_error
329: (p_module_name => 'DELETE_PENSION_END_REASONS'
330: ,p_hook_type => 'AP');
331: end;
332: --

Line 336: raise hr_api.validate_enabled;

332: --
333: -- When in validation only mode raise the Validate_Enabled exception
334: --
335: if p_validate then
336: raise hr_api.validate_enabled;
337: end if;
338: --
339: -- Set all output arguments
340: --

Line 343: when hr_api.validate_enabled then

339: -- Set all output arguments
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 70);
342: exception
343: when hr_api.validate_enabled then
344: --
345: -- As the Validate_Enabled exception has been raised
346: -- we must rollback to the savepoint
347: --