APPS.GHR_CDT_UPD dependencies on HR_API

Line 94: When hr_api.check_integrity_violated Then

90: --
91: hr_utility.set_location(' Leaving:'||l_proc, 10);
92: --
93: Exception
94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: --
97: ghr_cdt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

94: When hr_api.check_integrity_violated Then
95: -- A check constraint has been violated
96: --
97: ghr_cdt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: ghr_cdt_shd.constraint_error

Line 99: When hr_api.parent_integrity_violated Then

95: -- A check constraint has been violated
96: --
97: ghr_cdt_shd.constraint_error
98: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: ghr_cdt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

99: When hr_api.parent_integrity_violated Then
100: -- Parent integrity has been violated
101: --
102: ghr_cdt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: ghr_cdt_shd.constraint_error

Line 104: When hr_api.unique_integrity_violated Then

100: -- Parent integrity has been violated
101: --
102: ghr_cdt_shd.constraint_error
103: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: ghr_cdt_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

104: When hr_api.unique_integrity_violated Then
105: -- Unique integrity has been violated
106: --
107: ghr_cdt_shd.constraint_error
108: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When Others Then
110: --
111: Raise;
112: End update_dml;

Line 236: when hr_api.cannot_find_prog_unit then

232: );
233: --
234: exception
235: --
236: when hr_api.cannot_find_prog_unit then
237: --
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'GHR_COMPL_CA_DETAILS'
240: ,p_hook_type => 'AU');

Line 238: hr_api.cannot_find_prog_unit_error

234: exception
235: --
236: when hr_api.cannot_find_prog_unit then
237: --
238: hr_api.cannot_find_prog_unit_error
239: (p_module_name => 'GHR_COMPL_CA_DETAILS'
240: ,p_hook_type => 'AU');
241: --
242: end;

Line 301: If (p_rec.compl_ca_header_id = hr_api.g_number) then

297: -- p_rec plsql record structure
298: -- to see if a system default is being used. If a system default
299: -- is being used then we must set to the 'current' argument value.
300: --
301: If (p_rec.compl_ca_header_id = hr_api.g_number) then
302: p_rec.compl_ca_header_id :=
303: ghr_cdt_shd.g_old_rec.compl_ca_header_id;
304: End If;
305: /*

Line 306: If (p_rec.action = hr_api.g_varchar2) then

302: p_rec.compl_ca_header_id :=
303: ghr_cdt_shd.g_old_rec.compl_ca_header_id;
304: End If;
305: /*
306: If (p_rec.action = hr_api.g_varchar2) then
307: p_rec.action :=
308: ghr_cdt_shd.g_old_rec.action;
309: End If;
310: */

Line 311: If (p_rec.amount = hr_api.g_number) then

307: p_rec.action :=
308: ghr_cdt_shd.g_old_rec.action;
309: End If;
310: */
311: If (p_rec.amount = hr_api.g_number) then
312: p_rec.amount :=
313: ghr_cdt_shd.g_old_rec.amount;
314: End If;
315: If (p_rec.order_date = hr_api.g_date) then

Line 315: If (p_rec.order_date = hr_api.g_date) then

311: If (p_rec.amount = hr_api.g_number) then
312: p_rec.amount :=
313: ghr_cdt_shd.g_old_rec.amount;
314: End If;
315: If (p_rec.order_date = hr_api.g_date) then
316: p_rec.order_date :=
317: ghr_cdt_shd.g_old_rec.order_date;
318: End If;
319: If (p_rec.due_date = hr_api.g_date) then

Line 319: If (p_rec.due_date = hr_api.g_date) then

315: If (p_rec.order_date = hr_api.g_date) then
316: p_rec.order_date :=
317: ghr_cdt_shd.g_old_rec.order_date;
318: End If;
319: If (p_rec.due_date = hr_api.g_date) then
320: p_rec.due_date :=
321: ghr_cdt_shd.g_old_rec.due_date;
322: End If;
323: If (p_rec.request_date = hr_api.g_date) then

Line 323: If (p_rec.request_date = hr_api.g_date) then

319: If (p_rec.due_date = hr_api.g_date) then
320: p_rec.due_date :=
321: ghr_cdt_shd.g_old_rec.due_date;
322: End If;
323: If (p_rec.request_date = hr_api.g_date) then
324: p_rec.request_date :=
325: ghr_cdt_shd.g_old_rec.request_date;
326: End If;
327: If (p_rec.complete_date = hr_api.g_date) then

Line 327: If (p_rec.complete_date = hr_api.g_date) then

323: If (p_rec.request_date = hr_api.g_date) then
324: p_rec.request_date :=
325: ghr_cdt_shd.g_old_rec.request_date;
326: End If;
327: If (p_rec.complete_date = hr_api.g_date) then
328: p_rec.complete_date :=
329: ghr_cdt_shd.g_old_rec.complete_date;
330: End If;
331: If (p_rec.category = hr_api.g_varchar2) then

Line 331: If (p_rec.category = hr_api.g_varchar2) then

327: If (p_rec.complete_date = hr_api.g_date) then
328: p_rec.complete_date :=
329: ghr_cdt_shd.g_old_rec.complete_date;
330: End If;
331: If (p_rec.category = hr_api.g_varchar2) then
332: p_rec.category :=
333: ghr_cdt_shd.g_old_rec.category;
334: End If;
335: /*

Line 336: If (p_rec.type = hr_api.g_varchar2) then

332: p_rec.category :=
333: ghr_cdt_shd.g_old_rec.category;
334: End If;
335: /*
336: If (p_rec.type = hr_api.g_varchar2) then
337: p_rec.type :=
338: ghr_cdt_shd.g_old_rec.type;
339: End If;
340: */

Line 341: If (p_rec.phase = hr_api.g_varchar2) then

337: p_rec.type :=
338: ghr_cdt_shd.g_old_rec.type;
339: End If;
340: */
341: If (p_rec.phase = hr_api.g_varchar2) then
342: p_rec.phase :=
343: ghr_cdt_shd.g_old_rec.phase;
344: End If;
345: If (p_rec.action_type = hr_api.g_varchar2) then

Line 345: If (p_rec.action_type = hr_api.g_varchar2) then

341: If (p_rec.phase = hr_api.g_varchar2) then
342: p_rec.phase :=
343: ghr_cdt_shd.g_old_rec.phase;
344: End If;
345: If (p_rec.action_type = hr_api.g_varchar2) then
346: p_rec.action_type :=
347: ghr_cdt_shd.g_old_rec.action_type;
348: End If;
349: If (p_rec.payment_type = hr_api.g_varchar2) then

Line 349: If (p_rec.payment_type = hr_api.g_varchar2) then

345: If (p_rec.action_type = hr_api.g_varchar2) then
346: p_rec.action_type :=
347: ghr_cdt_shd.g_old_rec.action_type;
348: End If;
349: If (p_rec.payment_type = hr_api.g_varchar2) then
350: p_rec.payment_type :=
351: ghr_cdt_shd.g_old_rec.payment_type;
352: End If;
353: If (p_rec.description = hr_api.g_varchar2) then

Line 353: If (p_rec.description = hr_api.g_varchar2) then

349: If (p_rec.payment_type = hr_api.g_varchar2) then
350: p_rec.payment_type :=
351: ghr_cdt_shd.g_old_rec.payment_type;
352: End If;
353: If (p_rec.description = hr_api.g_varchar2) then
354: p_rec.description :=
355: ghr_cdt_shd.g_old_rec.description;
356: End If;
357: --