DBA Data[Home] [Help]

APPS.GHR_COMPLAINT_BASES_API dependencies on HR_API

Line 55: when hr_api.cannot_find_prog_unit then

51: ,p_agency_finding => p_agency_finding
52: ,p_aj_finding => p_aj_finding
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_compl_basis'
58: ,p_hook_type => 'BP'
59: );

Line 56: hr_api.cannot_find_prog_unit_error

52: ,p_aj_finding => p_aj_finding
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_compl_basis'
58: ,p_hook_type => 'BP'
59: );
60: end;

Line 97: when hr_api.cannot_find_prog_unit then

93: ,p_compl_basis_id => l_compl_basis_id
94: ,p_object_version_number => l_object_version_number
95: );
96: exception
97: when hr_api.cannot_find_prog_unit then
98: hr_api.cannot_find_prog_unit_error
99: (p_module_name => 'create_compl_basis'
100: ,p_hook_type => 'AP'
101: );

Line 98: hr_api.cannot_find_prog_unit_error

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

Line 107: raise hr_api.validate_enabled;

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

Line 117: when hr_api.validate_enabled then

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

Line 151: ,p_compl_claim_id in number default hr_api.g_number

147: procedure update_compl_basis
148: (p_validate in boolean default false
149: ,p_effective_date in date
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2

Line 152: ,p_basis in varchar2 default hr_api.g_varchar2

148: (p_validate in boolean default false
149: ,p_effective_date in date
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2

Line 153: ,p_value in varchar2 default hr_api.g_varchar2

149: ,p_effective_date in date
150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number

Line 154: ,p_statute in varchar2 default hr_api.g_varchar2

150: ,p_compl_basis_id in number
151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: )

Line 155: ,p_agency_finding in varchar2 default hr_api.g_varchar2

151: ,p_compl_claim_id in number default hr_api.g_number
152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: )
159:

Line 156: ,p_aj_finding in varchar2 default hr_api.g_varchar2

152: ,p_basis in varchar2 default hr_api.g_varchar2
153: ,p_value in varchar2 default hr_api.g_varchar2
154: ,p_statute in varchar2 default hr_api.g_varchar2
155: ,p_agency_finding in varchar2 default hr_api.g_varchar2
156: ,p_aj_finding in varchar2 default hr_api.g_varchar2
157: ,p_object_version_number in out nocopy number
158: )
159:
160: is

Line 188: when hr_api.cannot_find_prog_unit then

184: ,p_compl_basis_id => p_compl_basis_id
185: ,p_object_version_number => p_object_version_number
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_compl_basis'
191: ,p_hook_type => 'BP'
192: );

Line 189: hr_api.cannot_find_prog_unit_error

185: ,p_object_version_number => p_object_version_number
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_compl_basis'
191: ,p_hook_type => 'BP'
192: );
193: end;

Line 229: when hr_api.cannot_find_prog_unit then

225: ,p_compl_basis_id => p_compl_basis_id
226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'update_compl_basis'
232: ,p_hook_type => 'AP'
233: );

Line 230: hr_api.cannot_find_prog_unit_error

226: ,p_object_version_number => l_object_version_number
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'update_compl_basis'
232: ,p_hook_type => 'AP'
233: );
234: end;

Line 239: raise hr_api.validate_enabled;

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

Line 248: when hr_api.validate_enabled then

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

Line 307: when hr_api.cannot_find_prog_unit then

303: (p_compl_basis_id => p_compl_basis_id
304: ,p_object_version_number => p_object_version_number
305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'delete_compl_basis'
310: ,p_hook_type => 'BP'
311: );

Line 308: hr_api.cannot_find_prog_unit_error

304: ,p_object_version_number => p_object_version_number
305: );
306: exception
307: when hr_api.cannot_find_prog_unit then
308: hr_api.cannot_find_prog_unit_error
309: (p_module_name => 'delete_compl_basis'
310: ,p_hook_type => 'BP'
311: );
312: end;

Line 331: when hr_api.cannot_find_prog_unit then

327: (p_compl_basis_id => p_compl_basis_id
328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_compl_basis'
334: ,p_hook_type => 'AP'
335: );

Line 332: hr_api.cannot_find_prog_unit_error

328: ,p_object_version_number => p_object_version_number
329: );
330: exception
331: when hr_api.cannot_find_prog_unit then
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'delete_compl_basis'
334: ,p_hook_type => 'AP'
335: );
336: end;

Line 341: raise hr_api.validate_enabled;

337: --
338: -- When in validation only mode raise the Validate_Enabled exception
339: --
340: if p_validate then
341: raise hr_api.validate_enabled;
342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 11);
345: exception

Line 346: when hr_api.validate_enabled then

342: end if;
343: --
344: hr_utility.set_location(' Leaving:'||l_proc, 11);
345: exception
346: when hr_api.validate_enabled then
347: -- we must rollback to the savepoint
348: --
349: ROLLBACK TO delete_compl_basis;
350: --