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_PSD_BUS dependencies on HR_API

Line 47: hr_api.mandatory_arg_error

43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error
48: (p_api_name => l_proc
49: ,p_argument => 'sii_details_id'
50: ,p_argument_value => p_sii_details_id
51: );

Line 74: hr_api.set_security_group_id

70: close csr_sec_grp;
71: --
72: -- Set the security_group_id in CLIENT_INFO
73: --
74: hr_api.set_security_group_id
75: (p_security_group_id => l_security_group_id
76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA

Line 80: hr_api.set_legislation_context(l_legislation_code);

76: );
77: --
78: -- Set the sessions legislation context in HR_SESSION_DATA
79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --

Line 116: hr_api.mandatory_arg_error

112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error
117: (p_api_name => l_proc
118: ,p_argument => 'sii_details_id'
119: ,p_argument_value => p_sii_details_id
120: );

Line 122: if ( nvl(pay_psd_bus.g_sii_details_id, hr_api.g_number)

118: ,p_argument => 'sii_details_id'
119: ,p_argument_value => p_sii_details_id
120: );
121: --
122: if ( nvl(pay_psd_bus.g_sii_details_id, hr_api.g_number)
123: = p_sii_details_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global

Line 210: hr_api.mandatory_arg_error

206:
207: --
208: -- Check mandatory parameters have been set
209: --
210: hr_api.mandatory_arg_error
211: (p_api_name => l_proc
212: ,p_argument => 'effective date'
213: ,p_argument_value => p_effective_date
214: );

Line 216: hr_api.mandatory_arg_error

212: ,p_argument => 'effective date'
213: ,p_argument_value => p_effective_date
214: );
215:
216: hr_api.mandatory_arg_error
217: (p_api_name => l_proc
218: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','CONTRACT_CATEGORY')
219: ,p_argument_value => p_contract_category
220: );

Line 227: if hr_api.not_exists_in_dt_hr_lookups

223: -- Check if the Contract Category value exists in hr_lookups
224: -- where the lookup_type is 'PL_CONTRACT_CATEGORY'
225: --
226: if p_contract_category is not null then
227: if hr_api.not_exists_in_dt_hr_lookups
228: (p_effective_date => p_effective_date
229: ,p_validation_start_date => p_validation_start_date
230: ,p_validation_end_date => p_validation_end_date
231: ,p_lookup_type => 'PL_CONTRACT_CATEGORY'

Line 303: hr_api.mandatory_arg_error

299:
300: --
301: -- Check mandatory parameters have been set
302: --
303: hr_api.mandatory_arg_error
304: (p_api_name => l_proc
305: ,p_argument => 'effective date'
306: ,p_argument_value => p_effective_date
307: );

Line 309: hr_api.mandatory_arg_error

305: ,p_argument => 'effective date'
306: ,p_argument_value => p_effective_date
307: );
308:
309: hr_api.mandatory_arg_error
310: (p_api_name => l_proc
311: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BUSINESS_GROUP')
312: ,p_argument_value => p_business_group_id
313: );

Line 315: hr_api.validate_bus_grp_id

311: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','BUSINESS_GROUP')
312: ,p_argument_value => p_business_group_id
313: );
314:
315: hr_api.validate_bus_grp_id
316: (p_business_group_id => p_business_group_id
317: ,p_associated_column1 => pay_psd_shd.g_tab_nam||'.BUSINESS_GROUP_ID');
318:
319: hr_multi_message.end_validation_set;

Line 434: hr_api.mandatory_arg_error

430:
431: --
432: -- Check mandatory parameters have been set
433: --
434: hr_api.mandatory_arg_error
435: (p_api_name => l_proc
436: ,p_argument => 'effective date'
437: ,p_argument_value => p_effective_date
438: );

Line 440: hr_api.mandatory_arg_error

436: ,p_argument => 'effective date'
437: ,p_argument_value => p_effective_date
438: );
439:
440: hr_api.mandatory_arg_error
441: (p_api_name => l_proc
442: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PER_ASG_ID')
443: ,p_argument_value => p_per_or_asg_id
444: );

Line 568: hr_api.mandatory_arg_error

564:
565: --
566: -- Check mandatory parameters have been set
567: --
568: hr_api.mandatory_arg_error
569: (p_api_name => l_proc
570: ,p_argument => 'effective date'
571: ,p_argument_value => p_effective_date
572: );

Line 574: hr_api.mandatory_arg_error

570: ,p_argument => 'effective date'
571: ,p_argument_value => p_effective_date
572: );
573:
574: hr_api.mandatory_arg_error
575: (p_api_name => l_proc
576: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','EMP_SOCIAL_SECURITY_INFO')
577: ,p_argument_value => p_emp_social_security_info
578: );

Line 592: hr_api.g_varchar2)

588: ,p_effective_date => p_effective_date
589: ,p_object_version_number => p_object_version_number);
590:
591: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.emp_social_security_info,
592: hr_api.g_varchar2)
593: <> nvl(p_emp_social_security_info,hr_api.g_varchar2)) or
594: (NOT l_api_updating)) then
595:
596: --

Line 593: <> nvl(p_emp_social_security_info,hr_api.g_varchar2)) or

589: ,p_object_version_number => p_object_version_number);
590:
591: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.emp_social_security_info,
592: hr_api.g_varchar2)
593: <> nvl(p_emp_social_security_info,hr_api.g_varchar2)) or
594: (NOT l_api_updating)) then
595:
596: --
597: -- If Employee Social Security Information is not null then

Line 677: hr_api.mandatory_arg_error

673:
674: --
675: -- Check mandatory parameters have been set
676: --
677: hr_api.mandatory_arg_error
678: (p_api_name => l_proc
679: ,p_argument => 'effective date'
680: ,p_argument_value => p_effective_date
681: );

Line 683: hr_api.mandatory_arg_error

679: ,p_argument => 'effective date'
680: ,p_argument_value => p_effective_date
681: );
682:
683: hr_api.mandatory_arg_error
684: (p_api_name => l_proc
685: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','OLD_AGE_CONTRIBUTION')
686: ,p_argument_value => p_old_age_contribution
687: );

Line 701: hr_api.g_varchar2)

697: ,p_effective_date => p_effective_date
698: ,p_object_version_number => p_object_version_number);
699:
700: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.old_age_contribution,
701: hr_api.g_varchar2)
702: <> nvl(p_old_age_contribution,hr_api.g_varchar2)) or
703: (NOT l_api_updating)) then
704:
705: --

Line 702: <> nvl(p_old_age_contribution,hr_api.g_varchar2)) or

698: ,p_object_version_number => p_object_version_number);
699:
700: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.old_age_contribution,
701: hr_api.g_varchar2)
702: <> nvl(p_old_age_contribution,hr_api.g_varchar2)) or
703: (NOT l_api_updating)) then
704:
705: --
706: -- If Old Age Contribution is not null then

Line 711: if hr_api.not_exists_in_dt_hr_lookups

707: -- Check if the Old Age Contribution value exists in hr_lookups
708: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
709: --
710: if p_old_age_contribution is not null then
711: if hr_api.not_exists_in_dt_hr_lookups
712: (p_effective_date => p_effective_date
713: ,p_validation_start_date => p_validation_start_date
714: ,p_validation_end_date => p_validation_end_date
715: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 800: hr_api.mandatory_arg_error

796:
797: --
798: -- Check mandatory parameters have been set
799: --
800: hr_api.mandatory_arg_error
801: (p_api_name => l_proc
802: ,p_argument => 'effective date'
803: ,p_argument_value => p_effective_date
804: );

Line 806: hr_api.mandatory_arg_error

802: ,p_argument => 'effective date'
803: ,p_argument_value => p_effective_date
804: );
805:
806: hr_api.mandatory_arg_error
807: (p_api_name => l_proc
808: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PENSION_CONTRIBUTION')
809: ,p_argument_value => p_pension_contribution
810: );

Line 824: hr_api.g_varchar2)

820: ,p_effective_date => p_effective_date
821: ,p_object_version_number => p_object_version_number);
822:
823: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.pension_contribution,
824: hr_api.g_varchar2)
825: <> nvl(p_pension_contribution,hr_api.g_varchar2)) or
826: (NOT l_api_updating)) then
827:
828: --

Line 825: <> nvl(p_pension_contribution,hr_api.g_varchar2)) or

821: ,p_object_version_number => p_object_version_number);
822:
823: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.pension_contribution,
824: hr_api.g_varchar2)
825: <> nvl(p_pension_contribution,hr_api.g_varchar2)) or
826: (NOT l_api_updating)) then
827:
828: --
829: -- If Pension Contribution is not null then

Line 834: if hr_api.not_exists_in_dt_hr_lookups

830: -- Check if the Pension Contribution value exists in hr_lookups
831: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
832: --
833: if p_pension_contribution is not null then
834: if hr_api.not_exists_in_dt_hr_lookups
835: (p_effective_date => p_effective_date
836: ,p_validation_start_date => p_validation_start_date
837: ,p_validation_end_date => p_validation_end_date
838: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 924: hr_api.mandatory_arg_error

920:
921: --
922: -- Check mandatory parameters have been set
923: --
924: hr_api.mandatory_arg_error
925: (p_api_name => l_proc
926: ,p_argument => 'effective date'
927: ,p_argument_value => p_effective_date
928: );

Line 930: hr_api.mandatory_arg_error

926: ,p_argument => 'effective date'
927: ,p_argument_value => p_effective_date
928: );
929:
930: hr_api.mandatory_arg_error
931: (p_api_name => l_proc
932: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','SICKNESS_CONTRIBUTION')
933: ,p_argument_value => p_sickness_contribution
934: );

Line 948: hr_api.g_varchar2)

944: ,p_effective_date => p_effective_date
945: ,p_object_version_number => p_object_version_number);
946:
947: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.sickness_contribution,
948: hr_api.g_varchar2)
949: <> nvl(p_sickness_contribution,hr_api.g_varchar2)) or
950: (NOT l_api_updating)) then
951:
952: --

Line 949: <> nvl(p_sickness_contribution,hr_api.g_varchar2)) or

945: ,p_object_version_number => p_object_version_number);
946:
947: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.sickness_contribution,
948: hr_api.g_varchar2)
949: <> nvl(p_sickness_contribution,hr_api.g_varchar2)) or
950: (NOT l_api_updating)) then
951:
952: --
953: -- If Sickness Contribution is not null then

Line 958: if hr_api.not_exists_in_dt_hr_lookups

954: -- Check if the Sickness Contribution value exists in hr_lookups
955: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
956: --
957: if p_sickness_contribution is not null then
958: if hr_api.not_exists_in_dt_hr_lookups
959: (p_effective_date => p_effective_date
960: ,p_validation_start_date => p_validation_start_date
961: ,p_validation_end_date => p_validation_end_date
962: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 1048: hr_api.mandatory_arg_error

1044:
1045: --
1046: -- Check mandatory parameters have been set
1047: --
1048: hr_api.mandatory_arg_error
1049: (p_api_name => l_proc
1050: ,p_argument => 'effective date'
1051: ,p_argument_value => p_effective_date
1052: );

Line 1054: hr_api.mandatory_arg_error

1050: ,p_argument => 'effective date'
1051: ,p_argument_value => p_effective_date
1052: );
1053:
1054: hr_api.mandatory_arg_error
1055: (p_api_name => l_proc
1056: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','WORK_INJURY_CONTRIBUTION')
1057: ,p_argument_value => p_work_injury_contribution
1058: );

Line 1072: hr_api.g_varchar2)

1068: ,p_effective_date => p_effective_date
1069: ,p_object_version_number => p_object_version_number);
1070:
1071: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.work_injury_contribution,
1072: hr_api.g_varchar2)
1073: <> nvl(p_work_injury_contribution,hr_api.g_varchar2)) or
1074: (NOT l_api_updating)) then
1075:
1076: --

Line 1073: <> nvl(p_work_injury_contribution,hr_api.g_varchar2)) or

1069: ,p_object_version_number => p_object_version_number);
1070:
1071: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.work_injury_contribution,
1072: hr_api.g_varchar2)
1073: <> nvl(p_work_injury_contribution,hr_api.g_varchar2)) or
1074: (NOT l_api_updating)) then
1075:
1076: --
1077: -- If Work Injury Contribution is not null then

Line 1082: if hr_api.not_exists_in_dt_hr_lookups

1078: -- Check if the Work Injury Contribution value exists in hr_lookups
1079: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
1080: --
1081: if p_work_injury_contribution is not null then
1082: if hr_api.not_exists_in_dt_hr_lookups
1083: (p_effective_date => p_effective_date
1084: ,p_validation_start_date => p_validation_start_date
1085: ,p_validation_end_date => p_validation_end_date
1086: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 1172: hr_api.mandatory_arg_error

1168:
1169: --
1170: -- Check mandatory parameters have been set
1171: --
1172: hr_api.mandatory_arg_error
1173: (p_api_name => l_proc
1174: ,p_argument => 'effective date'
1175: ,p_argument_value => p_effective_date
1176: );

Line 1178: hr_api.mandatory_arg_error

1174: ,p_argument => 'effective date'
1175: ,p_argument_value => p_effective_date
1176: );
1177:
1178: hr_api.mandatory_arg_error
1179: (p_api_name => l_proc
1180: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','LABOR_CONTRIBUTION')
1181: ,p_argument_value => p_labor_contribution
1182: );

Line 1196: hr_api.g_varchar2)

1192: ,p_effective_date => p_effective_date
1193: ,p_object_version_number => p_object_version_number);
1194:
1195: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.labor_contribution,
1196: hr_api.g_varchar2)
1197: <> nvl(p_labor_contribution,hr_api.g_varchar2)) or
1198: (NOT l_api_updating)) then
1199:
1200: --

Line 1197: <> nvl(p_labor_contribution,hr_api.g_varchar2)) or

1193: ,p_object_version_number => p_object_version_number);
1194:
1195: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.labor_contribution,
1196: hr_api.g_varchar2)
1197: <> nvl(p_labor_contribution,hr_api.g_varchar2)) or
1198: (NOT l_api_updating)) then
1199:
1200: --
1201: -- If Labor Contribution is not null then

Line 1206: if hr_api.not_exists_in_dt_hr_lookups

1202: -- Check if the Labor Contribution value exists in hr_lookups
1203: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
1204: --
1205: if p_labor_contribution is not null then
1206: if hr_api.not_exists_in_dt_hr_lookups
1207: (p_effective_date => p_effective_date
1208: ,p_validation_start_date => p_validation_start_date
1209: ,p_validation_end_date => p_validation_end_date
1210: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 1295: hr_api.mandatory_arg_error

1291:
1292: --
1293: -- Check mandatory parameters have been set
1294: --
1295: hr_api.mandatory_arg_error
1296: (p_api_name => l_proc
1297: ,p_argument => 'effective date'
1298: ,p_argument_value => p_effective_date
1299: );

Line 1301: hr_api.mandatory_arg_error

1297: ,p_argument => 'effective date'
1298: ,p_argument_value => p_effective_date
1299: );
1300:
1301: hr_api.mandatory_arg_error
1302: (p_api_name => l_proc
1303: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','HEALTH_CONTRIBUTION')
1304: ,p_argument_value => p_health_contribution
1305: );

Line 1319: hr_api.g_varchar2)

1315: ,p_effective_date => p_effective_date
1316: ,p_object_version_number => p_object_version_number);
1317:
1318: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.health_contribution,
1319: hr_api.g_varchar2)
1320: <> nvl(p_health_contribution,hr_api.g_varchar2)) or
1321: (NOT l_api_updating)) then
1322:
1323: --

Line 1320: <> nvl(p_health_contribution,hr_api.g_varchar2)) or

1316: ,p_object_version_number => p_object_version_number);
1317:
1318: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.health_contribution,
1319: hr_api.g_varchar2)
1320: <> nvl(p_health_contribution,hr_api.g_varchar2)) or
1321: (NOT l_api_updating)) then
1322:
1323: --
1324: -- If Health Contribution is not null then

Line 1329: if hr_api.not_exists_in_dt_hr_lookups

1325: -- Check if the Health Contribution value exists in hr_lookups
1326: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
1327: --
1328: if p_health_contribution is not null then
1329: if hr_api.not_exists_in_dt_hr_lookups
1330: (p_effective_date => p_effective_date
1331: ,p_validation_start_date => p_validation_start_date
1332: ,p_validation_end_date => p_validation_end_date
1333: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 1420: hr_api.mandatory_arg_error

1416:
1417: --
1418: -- Check mandatory parameters have been set
1419: --
1420: hr_api.mandatory_arg_error
1421: (p_api_name => l_proc
1422: ,p_argument => 'effective date'
1423: ,p_argument_value => p_effective_date
1424: );

Line 1426: hr_api.mandatory_arg_error

1422: ,p_argument => 'effective date'
1423: ,p_argument_value => p_effective_date
1424: );
1425:
1426: hr_api.mandatory_arg_error
1427: (p_api_name => l_proc
1428: ,p_argument => hr_general.decode_lookup('PL_FORM_LABELS','UNEMPLOYMENT_CONTRIBUTION')
1429: ,p_argument_value => p_unemployment_contribution
1430: );

Line 1444: hr_api.g_varchar2)

1440: ,p_effective_date => p_effective_date
1441: ,p_object_version_number => p_object_version_number);
1442:
1443: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.unemployment_contribution,
1444: hr_api.g_varchar2)
1445: <> nvl(p_unemployment_contribution,hr_api.g_varchar2)) or
1446: (NOT l_api_updating)) then
1447:
1448: --

Line 1445: <> nvl(p_unemployment_contribution,hr_api.g_varchar2)) or

1441: ,p_object_version_number => p_object_version_number);
1442:
1443: if ((l_api_updating and nvl(pay_psd_shd.g_old_rec.unemployment_contribution,
1444: hr_api.g_varchar2)
1445: <> nvl(p_unemployment_contribution,hr_api.g_varchar2)) or
1446: (NOT l_api_updating)) then
1447:
1448: --
1449: -- If Unemployment Contribution is not null then

Line 1454: if hr_api.not_exists_in_dt_hr_lookups

1450: -- Check if the Unemployment Contribution value exists in hr_lookups
1451: -- where the lookup_type is 'PL_CONTRIBUTION_TYPE'
1452: --
1453: if p_unemployment_contribution is not null then
1454: if hr_api.not_exists_in_dt_hr_lookups
1455: (p_effective_date => p_effective_date
1456: ,p_validation_start_date => p_validation_start_date
1457: ,p_validation_end_date => p_validation_end_date
1458: ,p_lookup_type => 'PL_CONTRIBUTION_TYPE'

Line 1546: hr_api.mandatory_arg_error

1542:
1543: --
1544: -- Check mandatory parameters have been set
1545: --
1546: hr_api.mandatory_arg_error
1547: (p_api_name => l_proc
1548: ,p_argument => 'effective date'
1549: ,p_argument_value => p_effective_date
1550: );

Line 1581: hr_api.g_varchar2)

1577: end if;
1578: end if;
1579:
1580: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.old_age_cont_end_reason,
1581: hr_api.g_varchar2)
1582: <> nvl(p_old_age_cont_end_reason,hr_api.g_varchar2)) then
1583: --
1584: -- If Old Age Contribution End Reason is not null then
1585: -- Check if the Old Age Contribution End Reason value exists in hr_lookups

Line 1582: <> nvl(p_old_age_cont_end_reason,hr_api.g_varchar2)) then

1578: end if;
1579:
1580: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.old_age_cont_end_reason,
1581: hr_api.g_varchar2)
1582: <> nvl(p_old_age_cont_end_reason,hr_api.g_varchar2)) then
1583: --
1584: -- If Old Age Contribution End Reason is not null then
1585: -- Check if the Old Age Contribution End Reason value exists in hr_lookups
1586: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 1589: if hr_api.not_exists_in_dt_hr_lookups

1585: -- Check if the Old Age Contribution End Reason value exists in hr_lookups
1586: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
1587: --
1588: if p_old_age_cont_end_reason is not null then
1589: if hr_api.not_exists_in_dt_hr_lookups
1590: (p_effective_date => p_effective_date
1591: ,p_validation_start_date => p_validation_start_date
1592: ,p_validation_end_date => p_validation_end_date
1593: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 1701: hr_api.mandatory_arg_error

1697:
1698: --
1699: -- Check mandatory parameters have been set
1700: --
1701: hr_api.mandatory_arg_error
1702: (p_api_name => l_proc
1703: ,p_argument => 'effective date'
1704: ,p_argument_value => p_effective_date
1705: );

Line 1736: hr_api.g_varchar2)

1732: end if;
1733: end if;
1734:
1735: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.pension_cont_end_reason,
1736: hr_api.g_varchar2)
1737: <> nvl(p_pension_cont_end_reason,hr_api.g_varchar2)) then
1738: --
1739: -- If Pension Contribution End Reason is not null then
1740: -- Check if the Pension Contribution End Reason value exists in hr_lookups

Line 1737: <> nvl(p_pension_cont_end_reason,hr_api.g_varchar2)) then

1733: end if;
1734:
1735: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.pension_cont_end_reason,
1736: hr_api.g_varchar2)
1737: <> nvl(p_pension_cont_end_reason,hr_api.g_varchar2)) then
1738: --
1739: -- If Pension Contribution End Reason is not null then
1740: -- Check if the Pension Contribution End Reason value exists in hr_lookups
1741: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 1744: if hr_api.not_exists_in_dt_hr_lookups

1740: -- Check if the Pension Contribution End Reason value exists in hr_lookups
1741: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
1742: --
1743: if p_pension_cont_end_reason is not null then
1744: if hr_api.not_exists_in_dt_hr_lookups
1745: (p_effective_date => p_effective_date
1746: ,p_validation_start_date => p_validation_start_date
1747: ,p_validation_end_date => p_validation_end_date
1748: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 1854: hr_api.mandatory_arg_error

1850:
1851: --
1852: -- Check mandatory parameters have been set
1853: --
1854: hr_api.mandatory_arg_error
1855: (p_api_name => l_proc
1856: ,p_argument => 'effective date'
1857: ,p_argument_value => p_effective_date
1858: );

Line 1889: hr_api.g_varchar2)

1885: end if;
1886: end if;
1887:
1888: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.sickness_cont_end_reason,
1889: hr_api.g_varchar2)
1890: <> nvl(p_sickness_cont_end_reason,hr_api.g_varchar2)) then
1891: --
1892: -- If Sickness Contribution End Reason is not null then
1893: -- Check if the Sickness Contribution End Reason value exists in hr_lookups

Line 1890: <> nvl(p_sickness_cont_end_reason,hr_api.g_varchar2)) then

1886: end if;
1887:
1888: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.sickness_cont_end_reason,
1889: hr_api.g_varchar2)
1890: <> nvl(p_sickness_cont_end_reason,hr_api.g_varchar2)) then
1891: --
1892: -- If Sickness Contribution End Reason is not null then
1893: -- Check if the Sickness Contribution End Reason value exists in hr_lookups
1894: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 1897: if hr_api.not_exists_in_dt_hr_lookups

1893: -- Check if the Sickness Contribution End Reason value exists in hr_lookups
1894: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
1895: --
1896: if p_sickness_cont_end_reason is not null then
1897: if hr_api.not_exists_in_dt_hr_lookups
1898: (p_effective_date => p_effective_date
1899: ,p_validation_start_date => p_validation_start_date
1900: ,p_validation_end_date => p_validation_end_date
1901: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 2007: hr_api.mandatory_arg_error

2003:
2004: --
2005: -- Check mandatory parameters have been set
2006: --
2007: hr_api.mandatory_arg_error
2008: (p_api_name => l_proc
2009: ,p_argument => 'effective date'
2010: ,p_argument_value => p_effective_date
2011: );

Line 2042: hr_api.g_varchar2)

2038: end if;
2039: end if;
2040:
2041: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.work_injury_cont_end_reason,
2042: hr_api.g_varchar2)
2043: <> nvl(p_work_injury_cont_end_reason,hr_api.g_varchar2)) then
2044: --
2045: -- If Work Injury Contribution End Reason is not null then
2046: -- Check if the Work Injury Contribution End Reason value exists in hr_lookups

Line 2043: <> nvl(p_work_injury_cont_end_reason,hr_api.g_varchar2)) then

2039: end if;
2040:
2041: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.work_injury_cont_end_reason,
2042: hr_api.g_varchar2)
2043: <> nvl(p_work_injury_cont_end_reason,hr_api.g_varchar2)) then
2044: --
2045: -- If Work Injury Contribution End Reason is not null then
2046: -- Check if the Work Injury Contribution End Reason value exists in hr_lookups
2047: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 2050: if hr_api.not_exists_in_dt_hr_lookups

2046: -- Check if the Work Injury Contribution End Reason value exists in hr_lookups
2047: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
2048: --
2049: if p_work_injury_cont_end_reason is not null then
2050: if hr_api.not_exists_in_dt_hr_lookups
2051: (p_effective_date => p_effective_date
2052: ,p_validation_start_date => p_validation_start_date
2053: ,p_validation_end_date => p_validation_end_date
2054: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 2160: hr_api.mandatory_arg_error

2156:
2157: --
2158: -- Check mandatory parameters have been set
2159: --
2160: hr_api.mandatory_arg_error
2161: (p_api_name => l_proc
2162: ,p_argument => 'effective date'
2163: ,p_argument_value => p_effective_date
2164: );

Line 2195: hr_api.g_varchar2)

2191: end if;
2192: end if;
2193:
2194: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.labor_fund_cont_end_reason,
2195: hr_api.g_varchar2)
2196: <> nvl(p_labor_fund_cont_end_reason,hr_api.g_varchar2)) then
2197: --
2198: -- If Labor Fund Contribution End Reason is not null then
2199: -- Check if the Labor fund Contribution End Reason value exists in hr_lookups

Line 2196: <> nvl(p_labor_fund_cont_end_reason,hr_api.g_varchar2)) then

2192: end if;
2193:
2194: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.labor_fund_cont_end_reason,
2195: hr_api.g_varchar2)
2196: <> nvl(p_labor_fund_cont_end_reason,hr_api.g_varchar2)) then
2197: --
2198: -- If Labor Fund Contribution End Reason is not null then
2199: -- Check if the Labor fund Contribution End Reason value exists in hr_lookups
2200: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 2203: if hr_api.not_exists_in_dt_hr_lookups

2199: -- Check if the Labor fund Contribution End Reason value exists in hr_lookups
2200: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
2201: --
2202: if p_labor_fund_cont_end_reason is not null then
2203: if hr_api.not_exists_in_dt_hr_lookups
2204: (p_effective_date => p_effective_date
2205: ,p_validation_start_date => p_validation_start_date
2206: ,p_validation_end_date => p_validation_end_date
2207: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 2313: hr_api.mandatory_arg_error

2309:
2310: --
2311: -- Check mandatory parameters have been set
2312: --
2313: hr_api.mandatory_arg_error
2314: (p_api_name => l_proc
2315: ,p_argument => 'effective date'
2316: ,p_argument_value => p_effective_date
2317: );

Line 2348: hr_api.g_varchar2)

2344: end if;
2345: end if;
2346:
2347: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.health_cont_end_reason,
2348: hr_api.g_varchar2)
2349: <> nvl(p_health_cont_end_reason,hr_api.g_varchar2)) then
2350: --
2351: -- If Health Contribution End Reason is not null then
2352: -- Check if the Health Contribution End Reason value exists in hr_lookups

Line 2349: <> nvl(p_health_cont_end_reason,hr_api.g_varchar2)) then

2345: end if;
2346:
2347: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.health_cont_end_reason,
2348: hr_api.g_varchar2)
2349: <> nvl(p_health_cont_end_reason,hr_api.g_varchar2)) then
2350: --
2351: -- If Health Contribution End Reason is not null then
2352: -- Check if the Health Contribution End Reason value exists in hr_lookups
2353: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 2356: if hr_api.not_exists_in_dt_hr_lookups

2352: -- Check if the Health Contribution End Reason value exists in hr_lookups
2353: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
2354: --
2355: if p_health_cont_end_reason is not null then
2356: if hr_api.not_exists_in_dt_hr_lookups
2357: (p_effective_date => p_effective_date
2358: ,p_validation_start_date => p_validation_start_date
2359: ,p_validation_end_date => p_validation_end_date
2360: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 2466: hr_api.mandatory_arg_error

2462:
2463: --
2464: -- Check mandatory parameters have been set
2465: --
2466: hr_api.mandatory_arg_error
2467: (p_api_name => l_proc
2468: ,p_argument => 'effective date'
2469: ,p_argument_value => p_effective_date
2470: );

Line 2501: hr_api.g_varchar2)

2497: end if;
2498: end if;
2499:
2500: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.unemployment_cont_end_reason,
2501: hr_api.g_varchar2)
2502: <> nvl(p_unemployment_cont_end_reason,hr_api.g_varchar2)) then
2503: --
2504: -- If Unemployment Contribution End Reason is not null then
2505: -- Check if the Unemployment Contribution End Reason value exists in hr_lookups

Line 2502: <> nvl(p_unemployment_cont_end_reason,hr_api.g_varchar2)) then

2498: end if;
2499:
2500: if (l_api_updating and nvl(pay_psd_shd.g_old_rec.unemployment_cont_end_reason,
2501: hr_api.g_varchar2)
2502: <> nvl(p_unemployment_cont_end_reason,hr_api.g_varchar2)) then
2503: --
2504: -- If Unemployment Contribution End Reason is not null then
2505: -- Check if the Unemployment Contribution End Reason value exists in hr_lookups
2506: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'

Line 2509: if hr_api.not_exists_in_dt_hr_lookups

2505: -- Check if the Unemployment Contribution End Reason value exists in hr_lookups
2506: -- where the lookup_type is 'PL_CONTRIBUTION_END_REASON'
2507: --
2508: if p_unemployment_cont_end_reason is not null then
2509: if hr_api.not_exists_in_dt_hr_lookups
2510: (p_effective_date => p_effective_date
2511: ,p_validation_start_date => p_validation_start_date
2512: ,p_validation_end_date => p_validation_end_date
2513: ,p_lookup_type => 'PL_CONTRIBUTION_END_REASON'

Line 2616: if nvl(p_rec.business_group_id, hr_api.g_number) <>

2612: fnd_message.raise_error;
2613: END IF;
2614: --
2615:
2616: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2617: nvl(pay_psd_shd.g_old_rec.business_group_id
2618: ,hr_api.g_number
2619: ) then
2620: hr_api.argument_changed_error

Line 2618: ,hr_api.g_number

2614: --
2615:
2616: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2617: nvl(pay_psd_shd.g_old_rec.business_group_id
2618: ,hr_api.g_number
2619: ) then
2620: hr_api.argument_changed_error
2621: (p_api_name => l_proc
2622: ,p_argument => 'BUSINESS_GROUP_ID'

Line 2620: hr_api.argument_changed_error

2616: if nvl(p_rec.business_group_id, hr_api.g_number) <>
2617: nvl(pay_psd_shd.g_old_rec.business_group_id
2618: ,hr_api.g_number
2619: ) then
2620: hr_api.argument_changed_error
2621: (p_api_name => l_proc
2622: ,p_argument => 'BUSINESS_GROUP_ID'
2623: ,p_base_table => pay_psd_shd.g_tab_nam
2624: );

Line 2627: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>

2623: ,p_base_table => pay_psd_shd.g_tab_nam
2624: );
2625: end if;
2626:
2627: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
2628: nvl(pay_psd_shd.g_old_rec.contract_category
2629: ,hr_api.g_varchar2
2630: ) then
2631: hr_api.argument_changed_error

Line 2629: ,hr_api.g_varchar2

2625: end if;
2626:
2627: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
2628: nvl(pay_psd_shd.g_old_rec.contract_category
2629: ,hr_api.g_varchar2
2630: ) then
2631: hr_api.argument_changed_error
2632: (p_api_name => l_proc
2633: ,p_argument => 'CONTRACT_CATEGORY'

Line 2631: hr_api.argument_changed_error

2627: if nvl(p_rec.contract_category, hr_api.g_varchar2) <>
2628: nvl(pay_psd_shd.g_old_rec.contract_category
2629: ,hr_api.g_varchar2
2630: ) then
2631: hr_api.argument_changed_error
2632: (p_api_name => l_proc
2633: ,p_argument => 'CONTRACT_CATEGORY'
2634: ,p_base_table => pay_psd_shd.g_tab_nam
2635: );

Line 2638: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>

2634: ,p_base_table => pay_psd_shd.g_tab_nam
2635: );
2636: end if;
2637:
2638: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
2639: nvl(pay_psd_shd.g_old_rec.per_or_asg_id
2640: ,hr_api.g_number
2641: ) then
2642: hr_api.argument_changed_error

Line 2640: ,hr_api.g_number

2636: end if;
2637:
2638: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
2639: nvl(pay_psd_shd.g_old_rec.per_or_asg_id
2640: ,hr_api.g_number
2641: ) then
2642: hr_api.argument_changed_error
2643: (p_api_name => l_proc
2644: ,p_argument => 'PER_OR_ASG_ID'

Line 2642: hr_api.argument_changed_error

2638: if nvl(p_rec.per_or_asg_id, hr_api.g_number) <>
2639: nvl(pay_psd_shd.g_old_rec.per_or_asg_id
2640: ,hr_api.g_number
2641: ) then
2642: hr_api.argument_changed_error
2643: (p_api_name => l_proc
2644: ,p_argument => 'PER_OR_ASG_ID'
2645: ,p_base_table => pay_psd_shd.g_tab_nam
2646: );

Line 2693: hr_api.mandatory_arg_error

2689: Begin
2690: --
2691: -- Ensure that the p_datetrack_mode argument is not null
2692: --
2693: hr_api.mandatory_arg_error
2694: (p_api_name => l_proc
2695: ,p_argument => 'datetrack_mode'
2696: ,p_argument_value => p_datetrack_mode
2697: );

Line 2703: hr_api.mandatory_arg_error

2699: -- Mode will be valid, as this is checked at the start of the upd.
2700: --
2701: -- Ensure the arguments are not null
2702: --
2703: hr_api.mandatory_arg_error
2704: (p_api_name => l_proc
2705: ,p_argument => 'validation_start_date'
2706: ,p_argument_value => p_validation_start_date
2707: );

Line 2709: hr_api.mandatory_arg_error

2705: ,p_argument => 'validation_start_date'
2706: ,p_argument_value => p_validation_start_date
2707: );
2708: --
2709: hr_api.mandatory_arg_error
2710: (p_api_name => l_proc
2711: ,p_argument => 'validation_end_date'
2712: ,p_argument_value => p_validation_end_date
2713: );

Line 2777: hr_api.mandatory_arg_error

2773: Begin
2774: --
2775: -- Ensure that the p_datetrack_mode argument is not null
2776: --
2777: hr_api.mandatory_arg_error
2778: (p_api_name => l_proc
2779: ,p_argument => 'datetrack_mode'
2780: ,p_argument_value => p_datetrack_mode
2781: );

Line 2786: If (p_datetrack_mode = hr_api.g_delete or

2782: --
2783: -- Only perform the validation if the datetrack mode is either
2784: -- DELETE or ZAP
2785: --
2786: If (p_datetrack_mode = hr_api.g_delete or
2787: p_datetrack_mode = hr_api.g_zap) then
2788: --
2789: --
2790: -- Ensure the arguments are not null

Line 2787: p_datetrack_mode = hr_api.g_zap) then

2783: -- Only perform the validation if the datetrack mode is either
2784: -- DELETE or ZAP
2785: --
2786: If (p_datetrack_mode = hr_api.g_delete or
2787: p_datetrack_mode = hr_api.g_zap) then
2788: --
2789: --
2790: -- Ensure the arguments are not null
2791: --

Line 2792: hr_api.mandatory_arg_error

2788: --
2789: --
2790: -- Ensure the arguments are not null
2791: --
2792: hr_api.mandatory_arg_error
2793: (p_api_name => l_proc
2794: ,p_argument => 'validation_start_date'
2795: ,p_argument_value => p_validation_start_date
2796: );

Line 2798: hr_api.mandatory_arg_error

2794: ,p_argument => 'validation_start_date'
2795: ,p_argument_value => p_validation_start_date
2796: );
2797: --
2798: hr_api.mandatory_arg_error
2799: (p_api_name => l_proc
2800: ,p_argument => 'validation_end_date'
2801: ,p_argument_value => p_validation_end_date
2802: );

Line 2804: hr_api.mandatory_arg_error

2800: ,p_argument => 'validation_end_date'
2801: ,p_argument_value => p_validation_end_date
2802: );
2803: --
2804: hr_api.mandatory_arg_error
2805: (p_api_name => l_proc
2806: ,p_argument => 'sii_details_id'
2807: ,p_argument_value => p_sii_details_id
2808: );

Line 2845: hr_api.validate_bus_grp_id

2841: hr_utility.set_location('Entering:'||l_proc, 5);
2842: --
2843: -- Call all supporting business operations
2844: --
2845: hr_api.validate_bus_grp_id
2846: (p_business_group_id => p_rec.business_group_id
2847: ,p_associated_column1 => pay_psd_shd.g_tab_nam
2848: || '.BUSINESS_GROUP_ID');
2849: --

Line 3060: hr_api.validate_bus_grp_id

3056: hr_utility.set_location('Entering:'||l_proc, 5);
3057: --
3058: -- Call all supporting business operations
3059: --
3060: hr_api.validate_bus_grp_id
3061: (p_business_group_id => p_rec.business_group_id
3062: ,p_associated_column1 => pay_psd_shd.g_tab_nam
3063: || '.BUSINESS_GROUP_ID');
3064: --