eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CPT_BUS dependencies on HR_API

Line 58: hr_api.mandatory_arg_error

54: hr_utility.set_message(800, 'HR_74024_BUSINESS_GROUP_ID_NULL');
55: hr_utility.raise_error;
56: end if;
57: --
58: hr_api.mandatory_arg_error
59: (p_api_name => l_proc
60: ,p_argument => 'effective_date'
61: ,p_argument_value => p_effective_date
62: );

Line 168: and nvl(p_emp_province_tax_inf_id,hr_api.g_number)

164: p_emp_province_tax_inf_id => p_emp_province_tax_inf_id,
165: p_object_version_number => p_object_version_number);
166: --
167: if (l_api_updating
168: and nvl(p_emp_province_tax_inf_id,hr_api.g_number)
169: <> pay_cpt_shd.g_old_rec.emp_province_tax_inf_id) then
170: --
171: -- raise error as PK has changed
172: --

Line 238: <> nvl(pay_cpt_shd.g_old_rec.wc_exempt_flag,hr_api.g_varchar2)

234: p_object_version_number => p_object_version_number);
235: --
236: if (l_api_updating
237: and p_wc_exempt_flag
238: <> nvl(pay_cpt_shd.g_old_rec.wc_exempt_flag,hr_api.g_varchar2)
239: or not l_api_updating)
240: and p_wc_exempt_flag is not null then
241: --
242: -- check if value of lookup falls within lookup type.

Line 244: if hr_api.not_exists_in_hr_lookups

240: and p_wc_exempt_flag is not null then
241: --
242: -- check if value of lookup falls within lookup type.
243: --
244: if hr_api.not_exists_in_hr_lookups
245: (p_lookup_type => 'YES_NO',
246: p_lookup_code => p_wc_exempt_flag,
247: p_effective_date => p_effective_date) then
248: --

Line 307: <> nvl(pay_cpt_shd.g_old_rec.pmed_exempt_flag,hr_api.g_varchar2)

303: p_object_version_number => p_object_version_number);
304: --
305: if (l_api_updating
306: and p_pmed_exempt_flag
307: <> nvl(pay_cpt_shd.g_old_rec.pmed_exempt_flag,hr_api.g_varchar2)
308: or not l_api_updating)
309: and p_pmed_exempt_flag is not null then
310: --
311: -- check if value of lookup falls within lookup type.

Line 313: if hr_api.not_exists_in_hr_lookups

309: and p_pmed_exempt_flag is not null then
310: --
311: -- check if value of lookup falls within lookup type.
312: --
313: if hr_api.not_exists_in_hr_lookups
314: (p_lookup_type => 'YES_NO',
315: p_lookup_code => p_pmed_exempt_flag,
316: p_effective_date => p_effective_date) then
317: --

Line 376: <> nvl(pay_cpt_shd.g_old_rec.prov_exempt_flag,hr_api.g_varchar2)

372: p_object_version_number => p_object_version_number);
373: --
374: if (l_api_updating
375: and p_prov_exempt_flag
376: <> nvl(pay_cpt_shd.g_old_rec.prov_exempt_flag,hr_api.g_varchar2)
377: or not l_api_updating)
378: and p_prov_exempt_flag is not null then
379: --
380: -- check if value of lookup falls within lookup type.

Line 382: if hr_api.not_exists_in_hr_lookups

378: and p_prov_exempt_flag is not null then
379: --
380: -- check if value of lookup falls within lookup type.
381: --
382: if hr_api.not_exists_in_hr_lookups
383: (p_lookup_type => 'YES_NO',
384: p_lookup_code => p_prov_exempt_flag,
385: p_effective_date => p_effective_date) then
386: --

Line 447: <> nvl(pay_cpt_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)

443: p_object_version_number => p_object_version_number);
444: --
445: if (l_api_updating
446: and p_basic_exemption_flag
447: <> nvl(pay_cpt_shd.g_old_rec.basic_exemption_flag,hr_api.g_varchar2)
448: or not l_api_updating)
449: and p_basic_exemption_flag is not null then
450: --
451: -- check if value of lookup falls within lookup type.

Line 453: if hr_api.not_exists_in_hr_lookups

449: and p_basic_exemption_flag is not null then
450: --
451: -- check if value of lookup falls within lookup type.
452: --
453: if hr_api.not_exists_in_hr_lookups
454: (p_lookup_type => 'YES_NO',
455: p_lookup_code => p_basic_exemption_flag,
456: p_effective_date => p_effective_date) then
457: --

Line 532: <> nvl(pay_cpt_shd.g_old_rec.marriage_status,hr_api.g_varchar2)

528: p_object_version_number => p_object_version_number);
529: --
530: if (l_api_updating
531: and p_marriage_status
532: <> nvl(pay_cpt_shd.g_old_rec.marriage_status,hr_api.g_varchar2)
533: or not l_api_updating)
534: and p_marriage_status is not null then
535: --
536: -- check if value of lookup falls within lookup type.

Line 538: if hr_api.not_exists_in_hr_lookups

534: and p_marriage_status is not null then
535: --
536: -- check if value of lookup falls within lookup type.
537: --
538: if hr_api.not_exists_in_hr_lookups
539: (p_lookup_type => 'YES_NO',
540: p_lookup_code => p_marriage_status,
541: p_effective_date => p_effective_date) then
542: --

Line 600: <> nvl(pay_cpt_shd.g_old_rec.disability_status,hr_api.g_varchar2)

596: p_object_version_number => p_object_version_number);
597: --
598: if (l_api_updating
599: and p_disability_status
600: <> nvl(pay_cpt_shd.g_old_rec.disability_status,hr_api.g_varchar2)
601: or not l_api_updating)
602: and p_disability_status is not null then
603: --
604: -- check if value of lookup falls within lookup type.

Line 606: if hr_api.not_exists_in_hr_lookups

602: and p_disability_status is not null then
603: --
604: -- check if value of lookup falls within lookup type.
605: --
606: if hr_api.not_exists_in_hr_lookups
607: (p_lookup_type => 'YES_NO',
608: p_lookup_code => p_disability_status,
609: p_effective_date => p_effective_date) then
610: --

Line 668: <> nvl(pay_cpt_shd.g_old_rec.non_resident_status,hr_api.g_varchar2)

664: p_object_version_number => p_object_version_number);
665: --
666: if (l_api_updating
667: and p_non_resident_status
668: <> nvl(pay_cpt_shd.g_old_rec.non_resident_status,hr_api.g_varchar2)
669: or not l_api_updating)
670: and p_non_resident_status is not null then
671: --
672: -- check if value of lookup falls within lookup type.

Line 674: if hr_api.not_exists_in_hr_lookups

670: and p_non_resident_status is not null then
671: --
672: -- check if value of lookup falls within lookup type.
673: --
674: if hr_api.not_exists_in_hr_lookups
675: (p_lookup_type => 'YES_NO',
676: p_lookup_code => p_non_resident_status,
677: p_effective_date => p_effective_date) then
678: --

Line 736: <> nvl(pay_cpt_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)

732: p_object_version_number => p_object_version_number);
733: --
734: if (l_api_updating
735: and p_tax_calc_method
736: <> nvl(pay_cpt_shd.g_old_rec.tax_calc_method,hr_api.g_varchar2)
737: or not l_api_updating)
738: and p_tax_calc_method is not null then
739: --
740: -- check if value of lookup falls within lookup type.

Line 742: if hr_api.not_exists_in_hr_lookups

738: and p_tax_calc_method is not null then
739: --
740: -- check if value of lookup falls within lookup type.
741: --
742: if hr_api.not_exists_in_hr_lookups
743: (p_lookup_type => 'QC_TAX_CALC_METHOD',
744: p_lookup_code => p_tax_calc_method,
745: p_effective_date => p_effective_date) then
746: --

Line 804: nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2) then

800: p_object_version_number => p_object_version_number);
801: --
802: if (l_api_updating ) then
803: if p_province_code <>
804: nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2) then
805: hr_utility.set_message(800, 'HR_74030_PROVINCE_CODE_CHANGED');
806: hr_utility.raise_error;
807: end if;
808: end if;

Line 812: <> nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2)

808: end if;
809:
810: if (l_api_updating
811: and p_province_code
812: <> nvl(pay_cpt_shd.g_old_rec.province_code,hr_api.g_varchar2)
813: or not l_api_updating)
814: and p_province_code is not null then
815: --
816: -- check if value of lookup falls within lookup type.

Line 818: if hr_api.not_exists_in_hr_lookups

814: and p_province_code is not null then
815: --
816: -- check if value of lookup falls within lookup type.
817: --
818: if hr_api.not_exists_in_hr_lookups
819: (p_lookup_type => 'CA_PROVINCE',
820: p_lookup_code => p_province_code,
821: p_effective_date => p_effective_date) then
822: --

Line 880: <> nvl(pay_cpt_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

876: p_object_version_number => p_object_version_number);
877: --
878: if l_api_updating
879: and p_legislation_code
880: <> nvl(pay_cpt_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
881: or not l_api_updating then
882: ---
883: if p_legislation_code is null then
884: -- raise error as legislation_code is NULL

Line 936: (p_assignment_id in number default hr_api.g_number,

932: --
933: -- {End Of Comments}
934: -- ----------------------------------------------------------------------------
935: Procedure dt_update_validate
936: (p_assignment_id in number default hr_api.g_number,
937: p_datetrack_mode in varchar2,
938: p_validation_start_date in date,
939: p_validation_end_date in date) Is
940: --

Line 950: hr_api.mandatory_arg_error

946: hr_utility.set_location('Entering:'||l_proc, 5);
947: --
948: -- Ensure that the p_datetrack_mode argument is not null
949: --
950: hr_api.mandatory_arg_error
951: (p_api_name => l_proc,
952: p_argument => 'datetrack_mode',
953: p_argument_value => p_datetrack_mode);
954: --

Line 962: hr_api.mandatory_arg_error

958: --
959: --
960: -- Ensure the arguments are not null
961: --
962: hr_api.mandatory_arg_error
963: (p_api_name => l_proc,
964: p_argument => 'validation_start_date',
965: p_argument_value => p_validation_start_date);
966: --

Line 967: hr_api.mandatory_arg_error

963: (p_api_name => l_proc,
964: p_argument => 'validation_start_date',
965: p_argument_value => p_validation_start_date);
966: --
967: hr_api.mandatory_arg_error
968: (p_api_name => l_proc,
969: p_argument => 'validation_end_date',
970: p_argument_value => p_validation_end_date);
971: --

Line 972: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and

968: (p_api_name => l_proc,
969: p_argument => 'validation_end_date',
970: p_argument_value => p_validation_end_date);
971: --
972: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
973: NOT (dt_api.check_min_max_dates
974: (p_base_table_name => 'per_all_assignments_f',
975: p_base_key_column => 'assignment_id',
976: p_base_key_value => p_assignment_id,

Line 1056: hr_api.mandatory_arg_error

1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: -- Ensure that the p_datetrack_mode argument is not null
1055: --
1056: hr_api.mandatory_arg_error
1057: (p_api_name => l_proc,
1058: p_argument => 'datetrack_mode',
1059: p_argument_value => p_datetrack_mode);
1060: --

Line 1070: hr_api.mandatory_arg_error

1066: --
1067: --
1068: -- Ensure the arguments are not null
1069: --
1070: hr_api.mandatory_arg_error
1071: (p_api_name => l_proc,
1072: p_argument => 'validation_start_date',
1073: p_argument_value => p_validation_start_date);
1074: --

Line 1075: hr_api.mandatory_arg_error

1071: (p_api_name => l_proc,
1072: p_argument => 'validation_start_date',
1073: p_argument_value => p_validation_start_date);
1074: --
1075: hr_api.mandatory_arg_error
1076: (p_api_name => l_proc,
1077: p_argument => 'validation_end_date',
1078: p_argument_value => p_validation_end_date);
1079: --

Line 1080: hr_api.mandatory_arg_error

1076: (p_api_name => l_proc,
1077: p_argument => 'validation_end_date',
1078: p_argument_value => p_validation_end_date);
1079: --
1080: hr_api.mandatory_arg_error
1081: (p_api_name => l_proc,
1082: p_argument => 'emp_province_tax_inf_id',
1083: p_argument_value => p_emp_province_tax_inf_id);
1084: --

Line 1202: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1198: p_tax_calc_method => p_rec.tax_calc_method,
1199: p_effective_date => p_effective_date,
1200: p_object_version_number => p_rec.object_version_number);
1201: --
1202: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1203: --
1204: hr_utility.set_location(' Leaving:'||l_proc, 10);
1205: End insert_validate;
1206: --

Line 1299: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

1295: p_tax_calc_method => p_rec.tax_calc_method,
1296: p_effective_date => p_effective_date,
1297: p_object_version_number => p_rec.object_version_number);
1298: --
1299: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1300: --
1301: -- Call the datetrack update integrity operation
1302: --
1303: dt_update_validate

Line 1432: hr_api.mandatory_arg_error(p_api_name => l_proc,

1428: hr_utility.set_location('Entering:'|| l_proc, 10);
1429: --
1430: -- Ensure that all the mandatory parameter are not null
1431: --
1432: hr_api.mandatory_arg_error(p_api_name => l_proc,
1433: p_argument => 'emp_province_tax_inf_id',
1434: p_argument_value => p_emp_province_tax_inf_id);
1435: --
1436: open csr_leg_code;