DBA Data[Home] [Help]

APPS.PQH_REF_TEMPLATES_API dependencies on HR_API

Line 52: when hr_api.cannot_find_prog_unit then

48: ,p_reference_type_cd => p_reference_type_cd
49: ,p_effective_date => trunc(p_effective_date)
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (
55: p_module_name => 'CREATE_REF_TEMPLATE'
56: ,p_hook_type => 'BP'

Line 53: hr_api.cannot_find_prog_unit_error

49: ,p_effective_date => trunc(p_effective_date)
50: );
51: exception
52: when hr_api.cannot_find_prog_unit then
53: hr_api.cannot_find_prog_unit_error
54: (
55: p_module_name => 'CREATE_REF_TEMPLATE'
56: ,p_hook_type => 'BP'
57: );

Line 87: when hr_api.cannot_find_prog_unit then

83: ,p_object_version_number => l_object_version_number
84: ,p_effective_date => trunc(p_effective_date)
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_REF_TEMPLATE'
90: ,p_hook_type => 'AP'
91: );

Line 88: hr_api.cannot_find_prog_unit_error

84: ,p_effective_date => trunc(p_effective_date)
85: );
86: exception
87: when hr_api.cannot_find_prog_unit then
88: hr_api.cannot_find_prog_unit_error
89: (p_module_name => 'CREATE_REF_TEMPLATE'
90: ,p_hook_type => 'AP'
91: );
92: --

Line 102: raise hr_api.validate_enabled;

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

Line 114: when hr_api.validate_enabled then

110: hr_utility.set_location(' Leaving:'||l_proc, 70);
111: --
112: exception
113: --
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 146: ,p_base_template_id in number default hr_api.g_number

142: --
143: procedure update_REF_TEMPLATE
144: (p_validate in boolean default false
145: ,p_ref_template_id in number
146: ,p_base_template_id in number default hr_api.g_number
147: ,p_parent_template_id in number default hr_api.g_number
148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date

Line 147: ,p_parent_template_id in number default hr_api.g_number

143: procedure update_REF_TEMPLATE
144: (p_validate in boolean default false
145: ,p_ref_template_id in number
146: ,p_base_template_id in number default hr_api.g_number
147: ,p_parent_template_id in number default hr_api.g_number
148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
151: ) is

Line 148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2

144: (p_validate in boolean default false
145: ,p_ref_template_id in number
146: ,p_base_template_id in number default hr_api.g_number
147: ,p_parent_template_id in number default hr_api.g_number
148: ,p_reference_type_cd in varchar2 default hr_api.g_varchar2
149: ,p_object_version_number in out nocopy number
150: ,p_effective_date in date
151: ) is
152: --

Line 187: when hr_api.cannot_find_prog_unit then

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

Line 188: hr_api.cannot_find_prog_unit_error

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

Line 223: when hr_api.cannot_find_prog_unit then

219: ,p_effective_date => trunc(p_effective_date)
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_REF_TEMPLATE'
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_REF_TEMPLATE'
226: ,p_hook_type => 'AP'
227: );
228: --

Line 238: raise hr_api.validate_enabled;

234: --
235: -- When in validation only mode raise the Validate_Enabled exception
236: --
237: if p_validate then
238: raise hr_api.validate_enabled;
239: end if;
240: --
241: -- Set all output arguments
242: --

Line 249: when hr_api.validate_enabled then

245: hr_utility.set_location(' Leaving:'||l_proc, 70);
246: --
247: exception
248: --
249: when hr_api.validate_enabled then
250: --
251: -- As the Validate_Enabled exception has been raised
252: -- we must rollback to the savepoint
253: --

Line 314: when hr_api.cannot_find_prog_unit then

310: ,p_effective_date => trunc(p_effective_date)
311:
312: );
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'DELETE_REF_TEMPLATE'
317: ,p_hook_type => 'BP'
318: );

Line 315: hr_api.cannot_find_prog_unit_error

311:
312: );
313: exception
314: when hr_api.cannot_find_prog_unit then
315: hr_api.cannot_find_prog_unit_error
316: (p_module_name => 'DELETE_REF_TEMPLATE'
317: ,p_hook_type => 'BP'
318: );
319: --

Line 344: when hr_api.cannot_find_prog_unit then

340: ,p_effective_date => trunc(p_effective_date)
341:
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'DELETE_REF_TEMPLATE'
347: ,p_hook_type => 'AP'
348: );

Line 345: hr_api.cannot_find_prog_unit_error

341:
342: );
343: exception
344: when hr_api.cannot_find_prog_unit then
345: hr_api.cannot_find_prog_unit_error
346: (p_module_name => 'DELETE_REF_TEMPLATE'
347: ,p_hook_type => 'AP'
348: );
349: --

Line 359: raise hr_api.validate_enabled;

355: --
356: -- When in validation only mode raise the Validate_Enabled exception
357: --
358: if p_validate then
359: raise hr_api.validate_enabled;
360: end if;
361: --
362: hr_utility.set_location(' Leaving:'||l_proc, 70);
363: --

Line 366: when hr_api.validate_enabled then

362: hr_utility.set_location(' Leaving:'||l_proc, 70);
363: --
364: exception
365: --
366: when hr_api.validate_enabled then
367: --
368: -- As the Validate_Enabled exception has been raised
369: -- we must rollback to the savepoint
370: --