APPS.PAY_ETP_SHD_ND dependencies on HR_API

Line 530: hr_api.mandatory_arg_error(p_api_name => l_proc

526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- Ensure that all the mandatory arguments are not null
529: --
530: hr_api.mandatory_arg_error(p_api_name => l_proc
531: ,p_argument => 'effective_date'
532: ,p_argument_value => p_effective_date
533: );
534: --

Line 535: hr_api.mandatory_arg_error(p_api_name => l_proc

531: ,p_argument => 'effective_date'
532: ,p_argument_value => p_effective_date
533: );
534: --
535: hr_api.mandatory_arg_error(p_api_name => l_proc
536: ,p_argument => 'datetrack_mode'
537: ,p_argument_value => p_datetrack_mode
538: );
539: --

Line 540: hr_api.mandatory_arg_error(p_api_name => l_proc

536: ,p_argument => 'datetrack_mode'
537: ,p_argument_value => p_datetrack_mode
538: );
539: --
540: hr_api.mandatory_arg_error(p_api_name => l_proc
541: ,p_argument => 'element_type_id'
542: ,p_argument_value => p_element_type_id
543: );
544: --

Line 545: hr_api.mandatory_arg_error(p_api_name => l_proc

541: ,p_argument => 'element_type_id'
542: ,p_argument_value => p_element_type_id
543: );
544: --
545: hr_api.mandatory_arg_error(p_api_name => l_proc
546: ,p_argument => 'object_version_number'
547: ,p_argument_value => p_object_version_number
548: );
549: --

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

548: );
549: --
550: -- Check to ensure the datetrack mode is not INSERT.
551: --
552: If (p_datetrack_mode <> hr_api.g_insert) then
553: --
554: -- We must select and lock the current row.
555: --
556: Open C_Sel1;

Line 577: (p_datetrack_mode = hr_api.g_update or

573: -- Providing we are doing an update and a comment_id exists then
574: -- we select the comment text.
575: --
576: If ((pay_etp_shd_nd.g_old_rec.comment_id is not null) and
577: (p_datetrack_mode = hr_api.g_update or
578: p_datetrack_mode = hr_api.g_correction or
579: p_datetrack_mode = hr_api.g_update_override or
580: p_datetrack_mode = hr_api.g_update_change_insert)) then
581: Open C_Sel3;

Line 578: p_datetrack_mode = hr_api.g_correction or

574: -- we select the comment text.
575: --
576: If ((pay_etp_shd_nd.g_old_rec.comment_id is not null) and
577: (p_datetrack_mode = hr_api.g_update or
578: p_datetrack_mode = hr_api.g_correction or
579: p_datetrack_mode = hr_api.g_update_override or
580: p_datetrack_mode = hr_api.g_update_change_insert)) then
581: Open C_Sel3;
582: Fetch C_Sel3 Into pay_etp_shd_nd.g_old_rec.comments;

Line 579: p_datetrack_mode = hr_api.g_update_override or

575: --
576: If ((pay_etp_shd_nd.g_old_rec.comment_id is not null) and
577: (p_datetrack_mode = hr_api.g_update or
578: p_datetrack_mode = hr_api.g_correction or
579: p_datetrack_mode = hr_api.g_update_override or
580: p_datetrack_mode = hr_api.g_update_change_insert)) then
581: Open C_Sel3;
582: Fetch C_Sel3 Into pay_etp_shd_nd.g_old_rec.comments;
583: If C_Sel3%notfound then

Line 580: p_datetrack_mode = hr_api.g_update_change_insert)) then

576: If ((pay_etp_shd_nd.g_old_rec.comment_id is not null) and
577: (p_datetrack_mode = hr_api.g_update or
578: p_datetrack_mode = hr_api.g_correction or
579: p_datetrack_mode = hr_api.g_update_override or
580: p_datetrack_mode = hr_api.g_update_change_insert)) then
581: Open C_Sel3;
582: Fetch C_Sel3 Into pay_etp_shd_nd.g_old_rec.comments;
583: If C_Sel3%notfound then
584: --

Line 642: When HR_Api.Object_Locked then

638: --
639: -- We need to trap the ORA LOCK exception
640: --
641: Exception
642: When HR_Api.Object_Locked then
643: --
644: -- The object is locked therefore we need to supply a meaningful
645: -- error message.
646: --