APPS.PAY_ETP_SHD dependencies on HR_API

Line 534: hr_api.mandatory_arg_error(p_api_name => l_proc

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

Line 539: hr_api.mandatory_arg_error(p_api_name => l_proc

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

Line 544: hr_api.mandatory_arg_error(p_api_name => l_proc

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

Line 549: hr_api.mandatory_arg_error(p_api_name => l_proc

545: ,p_argument => 'element_type_id'
546: ,p_argument_value => p_element_type_id
547: );
548: --
549: hr_api.mandatory_arg_error(p_api_name => l_proc
550: ,p_argument => 'object_version_number'
551: ,p_argument_value => p_object_version_number
552: );
553: --

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

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

Line 581: (p_datetrack_mode = hr_api.g_update or

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

Line 582: p_datetrack_mode = hr_api.g_correction or

578: -- we select the comment text.
579: --
580: If ((pay_etp_shd.g_old_rec.comment_id is not null) and
581: (p_datetrack_mode = hr_api.g_update or
582: p_datetrack_mode = hr_api.g_correction or
583: p_datetrack_mode = hr_api.g_update_override or
584: p_datetrack_mode = hr_api.g_update_change_insert)) then
585: Open C_Sel3;
586: Fetch C_Sel3 Into pay_etp_shd.g_old_rec.comments;

Line 583: p_datetrack_mode = hr_api.g_update_override or

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

Line 584: p_datetrack_mode = hr_api.g_update_change_insert)) then

580: If ((pay_etp_shd.g_old_rec.comment_id is not null) and
581: (p_datetrack_mode = hr_api.g_update or
582: p_datetrack_mode = hr_api.g_correction or
583: p_datetrack_mode = hr_api.g_update_override or
584: p_datetrack_mode = hr_api.g_update_change_insert)) then
585: Open C_Sel3;
586: Fetch C_Sel3 Into pay_etp_shd.g_old_rec.comments;
587: If C_Sel3%notfound then
588: --

Line 646: When HR_Api.Object_Locked then

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