APPS.PAY_PEL_SHD dependencies on HR_API

Line 477: hr_api.mandatory_arg_error(p_api_name => l_proc

473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Ensure that all the mandatory arguments are not null
476: --
477: hr_api.mandatory_arg_error(p_api_name => l_proc
478: ,p_argument => 'effective_date'
479: ,p_argument_value => p_effective_date
480: );
481: --

Line 482: hr_api.mandatory_arg_error(p_api_name => l_proc

478: ,p_argument => 'effective_date'
479: ,p_argument_value => p_effective_date
480: );
481: --
482: hr_api.mandatory_arg_error(p_api_name => l_proc
483: ,p_argument => 'datetrack_mode'
484: ,p_argument_value => p_datetrack_mode
485: );
486: --

Line 487: hr_api.mandatory_arg_error(p_api_name => l_proc

483: ,p_argument => 'datetrack_mode'
484: ,p_argument_value => p_datetrack_mode
485: );
486: --
487: hr_api.mandatory_arg_error(p_api_name => l_proc
488: ,p_argument => 'element_link_id'
489: ,p_argument_value => p_element_link_id
490: );
491: --

Line 492: hr_api.mandatory_arg_error(p_api_name => l_proc

488: ,p_argument => 'element_link_id'
489: ,p_argument_value => p_element_link_id
490: );
491: --
492: hr_api.mandatory_arg_error(p_api_name => l_proc
493: ,p_argument => 'object_version_number'
494: ,p_argument_value => p_object_version_number
495: );
496: --

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

495: );
496: --
497: -- Check to ensure the datetrack mode is not INSERT.
498: --
499: If (p_datetrack_mode <> hr_api.g_insert) then
500: --
501: -- We must select and lock the current row.
502: --
503: Open C_Sel1;

Line 524: (p_datetrack_mode = hr_api.g_update or

520: -- Providing we are doing an update and a comment_id exists then
521: -- we select the comment text.
522: --
523: If ((pay_pel_shd.g_old_rec.comment_id is not null) and
524: (p_datetrack_mode = hr_api.g_update or
525: p_datetrack_mode = hr_api.g_correction or
526: p_datetrack_mode = hr_api.g_update_override or
527: p_datetrack_mode = hr_api.g_update_change_insert)) then
528: Open C_Sel3;

Line 525: p_datetrack_mode = hr_api.g_correction or

521: -- we select the comment text.
522: --
523: If ((pay_pel_shd.g_old_rec.comment_id is not null) and
524: (p_datetrack_mode = hr_api.g_update or
525: p_datetrack_mode = hr_api.g_correction or
526: p_datetrack_mode = hr_api.g_update_override or
527: p_datetrack_mode = hr_api.g_update_change_insert)) then
528: Open C_Sel3;
529: Fetch C_Sel3 Into pay_pel_shd.g_old_rec.comments;

Line 526: p_datetrack_mode = hr_api.g_update_override or

522: --
523: If ((pay_pel_shd.g_old_rec.comment_id is not null) and
524: (p_datetrack_mode = hr_api.g_update or
525: p_datetrack_mode = hr_api.g_correction or
526: p_datetrack_mode = hr_api.g_update_override or
527: p_datetrack_mode = hr_api.g_update_change_insert)) then
528: Open C_Sel3;
529: Fetch C_Sel3 Into pay_pel_shd.g_old_rec.comments;
530: If C_Sel3%notfound then

Line 527: p_datetrack_mode = hr_api.g_update_change_insert)) then

523: If ((pay_pel_shd.g_old_rec.comment_id is not null) and
524: (p_datetrack_mode = hr_api.g_update or
525: p_datetrack_mode = hr_api.g_correction or
526: p_datetrack_mode = hr_api.g_update_override or
527: p_datetrack_mode = hr_api.g_update_change_insert)) then
528: Open C_Sel3;
529: Fetch C_Sel3 Into pay_pel_shd.g_old_rec.comments;
530: If C_Sel3%notfound then
531: --

Line 589: When HR_Api.Object_Locked then

585: --
586: -- We need to trap the ORA LOCK exception
587: --
588: Exception
589: When HR_Api.Object_Locked then
590: --
591: -- The object is locked therefore we need to supply a meaningful
592: -- error message.
593: --