DBA Data[Home] [Help]

APPS.PAY_OPM_SHD dependencies on HR_API

Line 410: hr_api.mandatory_arg_error(p_api_name => l_proc

406: hr_utility.set_location('Entering:'||l_proc, 5);
407: --
408: -- Ensure that all the mandatory arguments are not null
409: --
410: hr_api.mandatory_arg_error(p_api_name => l_proc
411: ,p_argument => 'effective_date'
412: ,p_argument_value => p_effective_date
413: );
414: --

Line 415: hr_api.mandatory_arg_error(p_api_name => l_proc

411: ,p_argument => 'effective_date'
412: ,p_argument_value => p_effective_date
413: );
414: --
415: hr_api.mandatory_arg_error(p_api_name => l_proc
416: ,p_argument => 'datetrack_mode'
417: ,p_argument_value => p_datetrack_mode
418: );
419: --

Line 420: hr_api.mandatory_arg_error(p_api_name => l_proc

416: ,p_argument => 'datetrack_mode'
417: ,p_argument_value => p_datetrack_mode
418: );
419: --
420: hr_api.mandatory_arg_error(p_api_name => l_proc
421: ,p_argument => 'org_payment_method_id'
422: ,p_argument_value => p_org_payment_method_id
423: );
424: --

Line 425: hr_api.mandatory_arg_error(p_api_name => l_proc

421: ,p_argument => 'org_payment_method_id'
422: ,p_argument_value => p_org_payment_method_id
423: );
424: --
425: hr_api.mandatory_arg_error(p_api_name => l_proc
426: ,p_argument => 'object_version_number'
427: ,p_argument_value => p_object_version_number
428: );
429: --

Line 432: If (p_datetrack_mode <> hr_api.g_insert) then

428: );
429: --
430: -- Check to ensure the datetrack mode is not INSERT.
431: --
432: If (p_datetrack_mode <> hr_api.g_insert) then
433: --
434: -- We must select and lock the current row.
435: --
436: Open C_Sel1;

Line 457: (p_datetrack_mode = hr_api.g_update or

453: -- Providing we are doing an update and a comment_id exists then
454: -- we select the comment text.
455: --
456: If ((pay_opm_shd.g_old_rec.comment_id is not null) and
457: (p_datetrack_mode = hr_api.g_update or
458: p_datetrack_mode = hr_api.g_correction or
459: p_datetrack_mode = hr_api.g_update_override or
460: p_datetrack_mode = hr_api.g_update_change_insert)) then
461: Open C_Sel3;

Line 458: p_datetrack_mode = hr_api.g_correction or

454: -- we select the comment text.
455: --
456: If ((pay_opm_shd.g_old_rec.comment_id is not null) and
457: (p_datetrack_mode = hr_api.g_update or
458: p_datetrack_mode = hr_api.g_correction or
459: p_datetrack_mode = hr_api.g_update_override or
460: p_datetrack_mode = hr_api.g_update_change_insert)) then
461: Open C_Sel3;
462: Fetch C_Sel3 Into pay_opm_shd.g_old_rec.comments;

Line 459: p_datetrack_mode = hr_api.g_update_override or

455: --
456: If ((pay_opm_shd.g_old_rec.comment_id is not null) and
457: (p_datetrack_mode = hr_api.g_update or
458: p_datetrack_mode = hr_api.g_correction or
459: p_datetrack_mode = hr_api.g_update_override or
460: p_datetrack_mode = hr_api.g_update_change_insert)) then
461: Open C_Sel3;
462: Fetch C_Sel3 Into pay_opm_shd.g_old_rec.comments;
463: If C_Sel3%notfound then

Line 460: p_datetrack_mode = hr_api.g_update_change_insert)) then

456: If ((pay_opm_shd.g_old_rec.comment_id is not null) and
457: (p_datetrack_mode = hr_api.g_update or
458: p_datetrack_mode = hr_api.g_correction or
459: p_datetrack_mode = hr_api.g_update_override or
460: p_datetrack_mode = hr_api.g_update_change_insert)) then
461: Open C_Sel3;
462: Fetch C_Sel3 Into pay_opm_shd.g_old_rec.comments;
463: If C_Sel3%notfound then
464: --

Line 518: When HR_Api.Object_Locked then

514: --
515: -- We need to trap the ORA LOCK exception
516: --
517: Exception
518: When HR_Api.Object_Locked then
519: --
520: -- The object is locked therefore we need to supply a meaningful
521: -- error message.
522: --