DBA Data[Home] [Help]

APPS.PAY_PAY_INS dependencies on HR_API

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

159: --
160: -- If the datetrack_mode is not INSERT then we must populate the WHO
161: -- columns with the 'old' creation values and 'new' updated values.
162: --
163: If (p_datetrack_mode <> hr_api.g_insert) then
164: --
165: hr_utility.set_location(l_proc, 10);
166: --
167: -- Get the object version number for the insert

Line 405: When hr_api.check_integrity_violated Then

401: --
402: hr_utility.set_location(' Leaving:'||l_proc, 25);
403: --
404: Exception
405: When hr_api.check_integrity_violated Then
406: -- A check constraint has been violated
407: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
408: pay_pay_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

405: When hr_api.check_integrity_violated Then
406: -- A check constraint has been violated
407: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
408: pay_pay_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated
412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
413: pay_pay_shd.constraint_error

Line 410: When hr_api.unique_integrity_violated Then

406: -- A check constraint has been violated
407: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
408: pay_pay_shd.constraint_error
409: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated
412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
413: pay_pay_shd.constraint_error
414: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

410: When hr_api.unique_integrity_violated Then
411: -- Unique integrity has been violated
412: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
413: pay_pay_shd.constraint_error
414: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
415: When Others Then
416: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
417: Raise;
418: End dt_insert_dml;

Line 794: when hr_api.cannot_find_prog_unit then

790: );
791: --
792: exception
793: --
794: when hr_api.cannot_find_prog_unit then
795: --
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'PAY_ALL_PAYROLLS_F'
798: ,p_hook_type => 'AI');

Line 796: hr_api.cannot_find_prog_unit_error

792: exception
793: --
794: when hr_api.cannot_find_prog_unit then
795: --
796: hr_api.cannot_find_prog_unit_error
797: (p_module_name => 'PAY_ALL_PAYROLLS_F'
798: ,p_hook_type => 'AI');
799: --
800: end;

Line 829: -- another user. This will raise the HR_Api.Object_Locked exception.

825: --
826: -- Post Failure:
827: -- The Lck process can fail for:
828: -- 1) When attempting to lock the row the row could already be locked by
829: -- another user. This will raise the HR_Api.Object_Locked exception.
830: -- 2) When attempting to the lock the parent which doesn't exist.
831: -- For the entity to be locked the parent must exist!
832: --
833: -- Developer Implementation Notes:

Line 863: hr_api.mandatory_arg_error

859:
860: l_effective_date := trunc(p_effective_date);
861: l_first_period_end_date := trunc(p_rec.first_period_end_date);
862:
863: hr_api.mandatory_arg_error
864: (p_api_name => l_proc
865: ,p_argument => 'effective_date'
866: ,p_argument_value => l_effective_date
867: );

Line 870: hr_api.mandatory_arg_error

866: ,p_argument_value => l_effective_date
867: );
868:
869: hr_utility.set_location(l_proc, 20);
870: hr_api.mandatory_arg_error
871: (p_api_name => l_proc
872: ,p_argument => 'payroll_name'
873: ,p_argument_value => p_rec.payroll_name
874: );

Line 877: hr_api.mandatory_arg_error

873: ,p_argument_value => p_rec.payroll_name
874: );
875:
876: hr_utility.set_location(l_proc, 30);
877: hr_api.mandatory_arg_error
878: (p_api_name => l_proc
879: ,p_argument => 'period_type'
880: ,p_argument_value => p_rec.period_type
881: );

Line 884: hr_api.mandatory_arg_error

880: ,p_argument_value => p_rec.period_type
881: );
882:
883: hr_utility.set_location(l_proc, 40);
884: hr_api.mandatory_arg_error
885: (p_api_name => l_proc
886: ,p_argument => 'first_period_end_date'
887: ,p_argument_value => l_first_period_end_date
888: );

Line 890: hr_api.mandatory_arg_error

886: ,p_argument => 'first_period_end_date'
887: ,p_argument_value => l_first_period_end_date
888: );
889:
890: hr_api.mandatory_arg_error
891: (p_api_name => l_proc
892: ,p_argument => 'number_of_years'
893: ,p_argument_value => p_rec.number_of_years
894: );

Line 896: hr_api.mandatory_arg_error

892: ,p_argument => 'number_of_years'
893: ,p_argument_value => p_rec.number_of_years
894: );
895:
896: hr_api.mandatory_arg_error
897: (p_api_name => l_proc
898: ,p_argument => 'consolidation_set_id'
899: ,p_argument_value => p_rec.consolidation_set_id
900: );

Line 952: l_datetrack_mode varchar2(30) := hr_api.g_insert;

948: ,p_rec in out nocopy pay_pay_shd.g_rec_type
949: ) is
950: --
951: l_proc varchar2(72) := g_package||'ins';
952: l_datetrack_mode varchar2(30) := hr_api.g_insert;
953: l_validation_start_date date;
954: l_validation_end_date date;
955: l_business_group_id number(15);
956: --