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.PER_ASG_BUS2 dependencies on HR_API

Line 51: hr_api.mandatory_arg_error

47: hr_utility.set_location('Entering:'|| l_proc, 1);
48: --
49: -- Check mandatory parameters have been set
50: --
51: hr_api.mandatory_arg_error
52: (p_api_name => l_proc
53: ,p_argument => 'effective_date'
54: ,p_argument_value => p_effective_date
55: );

Line 69: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number)

65: --
66: -- Check if the assignment is being inserted or updated.
67: --
68: if ((l_api_updating and
69: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number)
70: <> nvl(p_pay_basis_id, hr_api.g_number)) or
71: (NOT l_api_updating)) then
72: hr_utility.set_location(l_proc, 3);
73: --

Line 70: <> nvl(p_pay_basis_id, hr_api.g_number)) or

66: -- Check if the assignment is being inserted or updated.
67: --
68: if ((l_api_updating and
69: nvl(per_asg_shd.g_old_rec.pay_basis_id, hr_api.g_number)
70: <> nvl(p_pay_basis_id, hr_api.g_number)) or
71: (NOT l_api_updating)) then
72: hr_utility.set_location(l_proc, 3);
73: --
74: -- Check if the pay basis is set

Line 374: hr_api.mandatory_arg_error

370: p_payroll_id_updated := FALSE;
371: --
372: -- Check mandatory parameters have been set
373: --
374: hr_api.mandatory_arg_error
375: (p_api_name => l_proc
376: ,p_argument => 'business_group_id'
377: ,p_argument_value => p_business_group_id
378: );

Line 380: hr_api.mandatory_arg_error

376: ,p_argument => 'business_group_id'
377: ,p_argument_value => p_business_group_id
378: );
379: --
380: hr_api.mandatory_arg_error
381: (p_api_name => l_proc
382: ,p_argument => 'validation_start_date'
383: ,p_argument_value => p_validation_start_date
384: );

Line 386: hr_api.mandatory_arg_error

382: ,p_argument => 'validation_start_date'
383: ,p_argument_value => p_validation_start_date
384: );
385: --
386: hr_api.mandatory_arg_error
387: (p_api_name => l_proc
388: ,p_argument => 'effective_date'
389: ,p_argument_value => p_effective_date
390: );

Line 392: hr_api.mandatory_arg_error

388: ,p_argument => 'effective_date'
389: ,p_argument_value => p_effective_date
390: );
391: --
392: hr_api.mandatory_arg_error
393: (p_api_name => l_proc
394: ,p_argument => 'validation_end_date'
395: ,p_argument_value => p_validation_end_date
396: );

Line 407: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)

403: );
404: hr_utility.set_location(l_proc, 30);
405: --
406: if (l_api_updating and
407: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
408: <> nvl(p_payroll_id, hr_api.g_number)) or
409: (per_asg_shd.g_old_rec.assignment_type='A' and
410: p_assignment_type='E')
411: )

Line 408: <> nvl(p_payroll_id, hr_api.g_number)) or

404: hr_utility.set_location(l_proc, 30);
405: --
406: if (l_api_updating and
407: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
408: <> nvl(p_payroll_id, hr_api.g_number)) or
409: (per_asg_shd.g_old_rec.assignment_type='A' and
410: p_assignment_type='E')
411: )
412: )

Line 418: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)

414: then
415: hr_utility.set_location(l_proc, 40);
416: --
417: if (l_api_updating and
418: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
419: <> nvl(p_payroll_id, hr_api.g_number)) then
420: --
421: -- As payroll id has been updated, set p_payroll_id_updated to true.
422: -- This functionality is required for the /update/delete_assignment

Line 419: <> nvl(p_payroll_id, hr_api.g_number)) then

415: hr_utility.set_location(l_proc, 40);
416: --
417: if (l_api_updating and
418: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
419: <> nvl(p_payroll_id, hr_api.g_number)) then
420: --
421: -- As payroll id has been updated, set p_payroll_id_updated to true.
422: -- This functionality is required for the /update/delete_assignment
423: -- business processes

Line 628: hr_api.g_eot);

624: ,l_cur_opu_effective_start_date
625: ,l_cur_opu_effective_end_date;
626: --
627: l_min_opu_effective_start_date := nvl(l_cur_opu_effective_start_date,
628: hr_api.g_eot);
629: l_max_opu_effective_end_date := nvl(l_cur_opu_effective_end_date,
630: hr_api.g_date);
631: --
632: hr_utility.set_location(l_proc, 140);

Line 630: hr_api.g_date);

626: --
627: l_min_opu_effective_start_date := nvl(l_cur_opu_effective_start_date,
628: hr_api.g_eot);
629: l_max_opu_effective_end_date := nvl(l_cur_opu_effective_end_date,
630: hr_api.g_date);
631: --
632: hr_utility.set_location(l_proc, 140);
633: hr_utility.trace
634: ('l_org_pay_method_usage_id = ' || l_org_pay_method_usage_id);

Line 820: between nvl(start_date_active,hr_api.g_sot)

816: select enabled_flag
817: from pay_people_groups
818: where people_group_id = p_people_group_id
819: and p_validation_start_date
820: between nvl(start_date_active,hr_api.g_sot)
821: and nvl(end_date_active,hr_api.g_eot);
822: --
823: cursor csr_valid_id_flex_num is
824: select null

Line 821: and nvl(end_date_active,hr_api.g_eot);

817: from pay_people_groups
818: where people_group_id = p_people_group_id
819: and p_validation_start_date
820: between nvl(start_date_active,hr_api.g_sot)
821: and nvl(end_date_active,hr_api.g_eot);
822: --
823: cursor csr_valid_id_flex_num is
824: select null
825: from per_business_groups_perf pbg

Line 837: hr_api.mandatory_arg_error

833: --
834: --
835: -- Check mandatory parameters have been set
836: --
837: hr_api.mandatory_arg_error
838: (p_api_name => l_proc
839: ,p_argument => 'business_group_id'
840: ,p_argument_value => p_business_group_id
841: );

Line 843: hr_api.mandatory_arg_error

839: ,p_argument => 'business_group_id'
840: ,p_argument_value => p_business_group_id
841: );
842: --
843: hr_api.mandatory_arg_error
844: (p_api_name => l_proc
845: ,p_argument => 'validation_start_date'
846: ,p_argument_value => p_validation_start_date
847: );

Line 849: hr_api.mandatory_arg_error

845: ,p_argument => 'validation_start_date'
846: ,p_argument_value => p_validation_start_date
847: );
848: --
849: hr_api.mandatory_arg_error
850: (p_api_name => l_proc
851: ,p_argument => 'effective_date'
852: ,p_argument_value => p_effective_date
853: );

Line 855: hr_api.mandatory_arg_error

851: ,p_argument => 'effective_date'
852: ,p_argument_value => p_effective_date
853: );
854: --
855: hr_api.mandatory_arg_error
856: (p_api_name => l_proc
857: ,p_argument => 'validation_end_date'
858: ,p_argument_value => p_validation_end_date
859: );

Line 874: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>

870: );
871: hr_utility.set_location(l_proc, 30);
872: --
873: if ((l_api_updating and
874: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>
875: nvl(p_people_group_id, hr_api.g_number)) or
876: (NOT l_api_updating))
877: then
878: hr_utility.set_location(l_proc, 40);

Line 875: nvl(p_people_group_id, hr_api.g_number)) or

871: hr_utility.set_location(l_proc, 30);
872: --
873: if ((l_api_updating and
874: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>
875: nvl(p_people_group_id, hr_api.g_number)) or
876: (NOT l_api_updating))
877: then
878: hr_utility.set_location(l_proc, 40);
879: --

Line 962: hr_api.mandatory_arg_error

958: hr_utility.set_location('Entering:'|| l_proc, 10);
959: --
960: -- Check mandatory parameters have been set
961: --
962: hr_api.mandatory_arg_error
963: (p_api_name => l_proc
964: ,p_argument => 'effective_date'
965: ,p_argument_value => p_effective_date
966: );

Line 968: hr_api.mandatory_arg_error

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

Line 974: hr_api.mandatory_arg_error

970: ,p_argument => 'validation_start_date'
971: ,p_argument_value => p_validation_start_date
972: );
973: --
974: hr_api.mandatory_arg_error
975: (p_api_name => l_proc
976: ,p_argument => 'validation_end_date'
977: ,p_argument_value => p_validation_end_date
978: );

Line 994: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,

990: hr_utility.set_location(l_proc, 30);
991: --
992: if ((l_api_updating and
993: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
994: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,
995: hr_api.g_varchar2))
996: or
997: (NOT l_api_updating))
998: then

Line 995: hr_api.g_varchar2))

991: --
992: if ((l_api_updating and
993: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
994: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,
995: hr_api.g_varchar2))
996: or
997: (NOT l_api_updating))
998: then
999: hr_utility.set_location(l_proc, 40);

Line 1025: if hr_api.not_exists_in_dt_hr_lookups

1021: -- flag set to 'Y' and that the effective start date of the
1022: -- assignment is between start date active and end date active
1023: -- in hr_lookups.
1024: --
1025: if hr_api.not_exists_in_dt_hr_lookups
1026: (p_effective_date => p_effective_date
1027: ,p_validation_start_date => p_validation_start_date
1028: ,p_validation_end_date => p_validation_end_date
1029: ,p_lookup_type => 'FREQUENCY'

Line 1072: hr_api.mandatory_arg_error

1068: hr_utility.set_location('Entering:'|| l_proc, 1);
1069: --
1070: -- Check mandatory parameters have been set
1071: --
1072: hr_api.mandatory_arg_error
1073: (p_api_name => l_proc
1074: ,p_argument => 'effective_date'
1075: ,p_argument_value => p_effective_date
1076: );

Line 1091: hr_api.g_number) <> nvl(p_perf_review_period,

1087: hr_utility.set_location(l_proc, 2);
1088: --
1089: if ((l_api_updating and
1090: nvl(per_asg_shd.g_old_rec.perf_review_period,
1091: hr_api.g_number) <> nvl(p_perf_review_period,
1092: hr_api.g_number))
1093: or (NOT l_api_updating))
1094: then
1095: --

Line 1092: hr_api.g_number))

1088: --
1089: if ((l_api_updating and
1090: nvl(per_asg_shd.g_old_rec.perf_review_period,
1091: hr_api.g_number) <> nvl(p_perf_review_period,
1092: hr_api.g_number))
1093: or (NOT l_api_updating))
1094: then
1095: --
1096: hr_utility.set_location(l_proc, 3);

Line 1157: hr_api.mandatory_arg_error

1153: ) then
1154: --
1155: -- Check mandatory parameters have been set
1156: --
1157: hr_api.mandatory_arg_error
1158: (p_api_name => l_proc
1159: ,p_argument => 'effective_date'
1160: ,p_argument_value => p_effective_date
1161: );

Line 1178: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))

1174: --
1175: if ((l_api_updating)
1176: and
1177: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1178: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1179: or
1180: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1181: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))
1182: or

Line 1181: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))

1177: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1178: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1179: or
1180: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1181: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))
1182: or
1183: (NOT l_api_updating)) then
1184: --
1185: hr_utility.set_location(l_proc, 2);

Line 1252: and nvl(actual_termination_date, hr_api.g_eot);

1248: from per_periods_of_service
1249: where period_of_service_id = p_period_of_service_id
1250: and p_validation_start_date
1251: between date_start
1252: and nvl(actual_termination_date, hr_api.g_eot);
1253: --
1254: begin
1255: hr_utility.set_location('Entering:'|| l_proc, 10);
1256: --

Line 1259: hr_api.mandatory_arg_error

1255: hr_utility.set_location('Entering:'|| l_proc, 10);
1256: --
1257: -- Check mandatory parameters have been set
1258: --
1259: hr_api.mandatory_arg_error
1260: (p_api_name => l_proc
1261: ,p_argument => 'person_id'
1262: ,p_argument_value => p_person_id
1263: );

Line 1265: hr_api.mandatory_arg_error

1261: ,p_argument => 'person_id'
1262: ,p_argument_value => p_person_id
1263: );
1264: --
1265: hr_api.mandatory_arg_error
1266: (p_api_name => l_proc
1267: ,p_argument => 'validation_start_date'
1268: ,p_argument_value => p_validation_start_date
1269: );

Line 1271: hr_api.mandatory_arg_error

1267: ,p_argument => 'validation_start_date'
1268: ,p_argument_value => p_validation_start_date
1269: );
1270: --
1271: hr_api.mandatory_arg_error
1272: (p_api_name => l_proc
1273: ,p_argument => 'validation_end_date'
1274: ,p_argument_value => p_validation_end_date
1275: );

Line 1277: hr_api.mandatory_arg_error

1273: ,p_argument => 'validation_end_date'
1274: ,p_argument_value => p_validation_end_date
1275: );
1276: --
1277: hr_api.mandatory_arg_error
1278: (p_api_name => l_proc
1279: ,p_argument => 'validation_end_date'
1280: ,p_argument_value => p_effective_date
1281: );

Line 1319: hr_api.mandatory_arg_error

1315: --
1316: -- Check the mandatory parameter period of service for
1317: -- an employee.
1318: --
1319: hr_api.mandatory_arg_error
1320: (p_api_name => l_proc
1321: ,p_argument => 'period_of_service_id'
1322: ,p_argument_value => p_period_of_service_id
1323: );

Line 1360: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then

1356: --
1357: -- Check if the period of service has been closed before the
1358: -- validation end date.
1359: --
1360: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then
1361: --
1362: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1363: hr_multi_message.add
1364: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

Line 1406: hr_api.mandatory_arg_error

1402: hr_utility.set_location('Entering:'|| l_proc, 1);
1403: --
1404: -- Check mandatory parameters have been set
1405: --
1406: hr_api.mandatory_arg_error
1407: (p_api_name => l_proc
1408: ,p_argument => 'person_id'
1409: ,p_argument_value => p_person_id
1410: );

Line 1475: hr_api.mandatory_arg_error

1471: hr_utility.set_location('Entering:'|| l_proc, 10);
1472: --
1473: -- Check mandatory parameters have been set
1474: --
1475: hr_api.mandatory_arg_error
1476: (p_api_name => l_proc
1477: ,p_argument => 'effective_date'
1478: ,p_argument_value => p_effective_date
1479: );

Line 1481: hr_api.mandatory_arg_error

1477: ,p_argument => 'effective_date'
1478: ,p_argument_value => p_effective_date
1479: );
1480: --
1481: hr_api.mandatory_arg_error
1482: (p_api_name => l_proc
1483: ,p_argument => 'validation_start_date'
1484: ,p_argument_value => p_validation_start_date
1485: );

Line 1487: hr_api.mandatory_arg_error

1483: ,p_argument => 'validation_start_date'
1484: ,p_argument_value => p_validation_start_date
1485: );
1486: --
1487: hr_api.mandatory_arg_error
1488: (p_api_name => l_proc
1489: ,p_argument => 'validation_end_date'
1490: ,p_argument_value => p_validation_end_date
1491: );

Line 1506: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)

1502: ,p_object_version_number => p_object_version_number);
1503: hr_utility.set_location(l_proc, 30);
1504: --
1505: if ((l_api_updating and
1506: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)
1507: <> nvl(p_person_referred_by_id, hr_api.g_number)) or
1508: (NOT l_api_updating)) then
1509: hr_utility.set_location(l_proc, 40);
1510: --

Line 1507: <> nvl(p_person_referred_by_id, hr_api.g_number)) or

1503: hr_utility.set_location(l_proc, 30);
1504: --
1505: if ((l_api_updating and
1506: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)
1507: <> nvl(p_person_referred_by_id, hr_api.g_number)) or
1508: (NOT l_api_updating)) then
1509: hr_utility.set_location(l_proc, 40);
1510: --
1511: -- Check if person referred by is not null

Line 1591: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or

1587: -- Bug 3190625
1588: -- Condition to check profile value also added
1589: -- If he is an employee or a contingent worker with the profile set,
1590: -- no errors shown
1591: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
1592: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1593: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1594: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1595: hr_multi_message.add

Line 1644: and nvl(hp.date_end, hr_api.g_eot)

1640: between hp.effective_start_date
1641: and hp.effective_end_date
1642: and p_validation_start_date
1643: between hp.date_effective
1644: and nvl(hp.date_end, hr_api.g_eot)
1645: and ps.shared_type_id = hp.availability_status_id
1646: and ps.system_type_cd = 'ACTIVE' ;
1647: --
1648: begin

Line 1654: hr_api.mandatory_arg_error

1650: --
1651: --
1652: -- Check mandatory parameters have been set
1653: --
1654: hr_api.mandatory_arg_error
1655: (p_api_name => l_proc
1656: ,p_argument => 'effective_date'
1657: ,p_argument_value => p_effective_date
1658: );

Line 1660: hr_api.mandatory_arg_error

1656: ,p_argument => 'effective_date'
1657: ,p_argument_value => p_effective_date
1658: );
1659: --
1660: hr_api.mandatory_arg_error
1661: (p_api_name => l_proc
1662: ,p_argument => 'validation_start_date'
1663: ,p_argument_value => p_validation_start_date
1664: );

Line 1666: hr_api.mandatory_arg_error

1662: ,p_argument => 'validation_start_date'
1663: ,p_argument_value => p_validation_start_date
1664: );
1665: --
1666: hr_api.mandatory_arg_error
1667: (p_api_name => l_proc
1668: ,p_argument => 'validation_end_date'
1669: ,p_argument_value => p_validation_end_date
1670: );

Line 1672: hr_api.mandatory_arg_error

1668: ,p_argument => 'validation_end_date'
1669: ,p_argument_value => p_validation_end_date
1670: );
1671: --
1672: hr_api.mandatory_arg_error
1673: (p_api_name => l_proc
1674: ,p_argument => 'business_group_id'
1675: ,p_argument_value => p_business_group_id
1676: );

Line 1690: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

1686: ,p_object_version_number => p_object_version_number);
1687: --
1688: if ((l_api_updating
1689: and
1690: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1691: nvl(p_position_id, hr_api.g_number))
1692: or
1693: (NOT l_api_updating)) then
1694: hr_utility.set_location(l_proc, 30);

Line 1691: nvl(p_position_id, hr_api.g_number))

1687: --
1688: if ((l_api_updating
1689: and
1690: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1691: nvl(p_position_id, hr_api.g_number))
1692: or
1693: (NOT l_api_updating)) then
1694: hr_utility.set_location(l_proc, 30);
1695: --

Line 1769: and nvl(date_to, hr_api.g_eot);

1765: from per_valid_grades
1766: where position_id = p_position_id
1767: and p_validation_start_date
1768: between date_from
1769: and nvl(date_to, hr_api.g_eot);
1770: --
1771: -- Bug 3566686 Ends Here
1772: --
1773: cursor csr_valid_pos_val_grd is

Line 1780: and nvl(date_to, hr_api.g_eot);

1776: where position_id = p_position_id
1777: and grade_id = p_grade_id
1778: and p_validation_start_date
1779: between date_from
1780: and nvl(date_to, hr_api.g_eot);
1781: --
1782: begin
1783: --
1784: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1793: hr_api.mandatory_arg_error

1789: ) then
1790: --
1791: -- Check mandatory parameters have been set
1792: --
1793: hr_api.mandatory_arg_error
1794: (p_api_name => l_proc
1795: ,p_argument => 'validation_start_date'
1796: ,p_argument_value => p_validation_start_date
1797: );

Line 1799: hr_api.mandatory_arg_error

1795: ,p_argument => 'validation_start_date'
1796: ,p_argument_value => p_validation_start_date
1797: );
1798: --
1799: hr_api.mandatory_arg_error
1800: (p_api_name => l_proc
1801: ,p_argument => 'validation_end_date'
1802: ,p_argument_value => p_validation_end_date
1803: );

Line 1805: hr_api.mandatory_arg_error

1801: ,p_argument => 'validation_end_date'
1802: ,p_argument_value => p_validation_end_date
1803: );
1804: --
1805: hr_api.mandatory_arg_error
1806: (p_api_name => l_proc
1807: ,p_argument => 'effective_date'
1808: ,p_argument_value => p_effective_date
1809: );

Line 1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

1817: ,p_effective_date => p_effective_date
1818: ,p_object_version_number => p_object_version_number);
1819: --
1820: if (l_api_updating and
1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1822: nvl(p_position_id, hr_api.g_number))
1823: or
1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1825: nvl(p_grade_id, hr_api.g_number))))

Line 1822: nvl(p_position_id, hr_api.g_number))

1818: ,p_object_version_number => p_object_version_number);
1819: --
1820: if (l_api_updating and
1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1822: nvl(p_position_id, hr_api.g_number))
1823: or
1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1825: nvl(p_grade_id, hr_api.g_number))))
1826: or

Line 1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>

1820: if (l_api_updating and
1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1822: nvl(p_position_id, hr_api.g_number))
1823: or
1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1825: nvl(p_grade_id, hr_api.g_number))))
1826: or
1827: (NOT l_api_updating) then
1828: --

Line 1825: nvl(p_grade_id, hr_api.g_number))))

1821: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1822: nvl(p_position_id, hr_api.g_number))
1823: or
1824: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1825: nvl(p_grade_id, hr_api.g_number))))
1826: or
1827: (NOT l_api_updating) then
1828: --
1829: hr_utility.set_location(l_proc, 2);

Line 1903: and nvl(hp.date_end, hr_api.g_eot)

1899: and hp.effective_end_date
1900: and hp.organization_id = p_organization_id
1901: and p_validation_start_date
1902: between hp.date_effective
1903: and nvl(hp.date_end, hr_api.g_eot)
1904: and ps.shared_type_id = hp.availability_status_id
1905: and ps.system_type_cd = 'ACTIVE' ;
1906: --
1907: begin

Line 1918: hr_api.mandatory_arg_error

1914: ) then
1915: --
1916: -- Check mandatory parameters have been set
1917: --
1918: hr_api.mandatory_arg_error
1919: (p_api_name => l_proc
1920: ,p_argument => 'validation_start_date'
1921: ,p_argument_value => p_validation_start_date
1922: );

Line 1924: hr_api.mandatory_arg_error

1920: ,p_argument => 'validation_start_date'
1921: ,p_argument_value => p_validation_start_date
1922: );
1923: --
1924: hr_api.mandatory_arg_error
1925: (p_api_name => l_proc
1926: ,p_argument => 'validation_end_date'
1927: ,p_argument_value => p_validation_end_date
1928: );

Line 1930: hr_api.mandatory_arg_error

1926: ,p_argument => 'validation_end_date'
1927: ,p_argument_value => p_validation_end_date
1928: );
1929: --
1930: hr_api.mandatory_arg_error
1931: (p_api_name => l_proc
1932: ,p_argument => 'effective_date'
1933: ,p_argument_value => p_effective_date
1934: );

Line 1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

1943: ,p_object_version_number => p_object_version_number);
1944: --
1945:
1946: if (l_api_updating and
1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1948: nvl(p_position_id, hr_api.g_number))
1949: or
1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1951: nvl(p_organization_id, hr_api.g_number))))

Line 1948: nvl(p_position_id, hr_api.g_number))

1944: --
1945:
1946: if (l_api_updating and
1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1948: nvl(p_position_id, hr_api.g_number))
1949: or
1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1951: nvl(p_organization_id, hr_api.g_number))))
1952: or

Line 1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>

1946: if (l_api_updating and
1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1948: nvl(p_position_id, hr_api.g_number))
1949: or
1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1951: nvl(p_organization_id, hr_api.g_number))))
1952: or
1953: (NOT l_api_updating) then
1954: --

Line 1951: nvl(p_organization_id, hr_api.g_number))))

1947: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1948: nvl(p_position_id, hr_api.g_number))
1949: or
1950: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1951: nvl(p_organization_id, hr_api.g_number))))
1952: or
1953: (NOT l_api_updating) then
1954: --
1955: hr_utility.set_location(l_proc, 2);

Line 2023: and nvl(hp.date_end,hr_api.g_eot)

2019: and hp.effective_end_date
2020: and hp.job_id = p_job_id
2021: and p_validation_start_date
2022: between hp.date_effective
2023: and nvl(hp.date_end,hr_api.g_eot)
2024: and ps.shared_type_id = hp.availability_status_id
2025: and ps.system_type_cd = 'ACTIVE' ;
2026: --
2027: begin

Line 2037: hr_api.mandatory_arg_error

2033: ) then
2034: --
2035: -- Check mandatory parameters have been set
2036: --
2037: hr_api.mandatory_arg_error
2038: (p_api_name => l_proc
2039: ,p_argument => 'validation_start_date'
2040: ,p_argument_value => p_validation_start_date
2041: );

Line 2043: hr_api.mandatory_arg_error

2039: ,p_argument => 'validation_start_date'
2040: ,p_argument_value => p_validation_start_date
2041: );
2042: --
2043: hr_api.mandatory_arg_error
2044: (p_api_name => l_proc
2045: ,p_argument => 'validation_end_date'
2046: ,p_argument_value => p_validation_end_date
2047: );

Line 2049: hr_api.mandatory_arg_error

2045: ,p_argument => 'validation_end_date'
2046: ,p_argument_value => p_validation_end_date
2047: );
2048: --
2049: hr_api.mandatory_arg_error
2050: (p_api_name => l_proc
2051: ,p_argument => 'effective_date'
2052: ,p_argument_value => p_effective_date
2053: );

Line 2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>

2063: ,p_object_version_number => p_object_version_number);
2064: hr_utility.set_location(l_proc, 30);
2065: --
2066: if (l_api_updating and
2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2068: nvl(p_position_id, hr_api.g_number))
2069: or
2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2071: nvl(p_job_id, hr_api.g_number))))

Line 2068: nvl(p_position_id, hr_api.g_number))

2064: hr_utility.set_location(l_proc, 30);
2065: --
2066: if (l_api_updating and
2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2068: nvl(p_position_id, hr_api.g_number))
2069: or
2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2071: nvl(p_job_id, hr_api.g_number))))
2072: or

Line 2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>

2066: if (l_api_updating and
2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2068: nvl(p_position_id, hr_api.g_number))
2069: or
2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2071: nvl(p_job_id, hr_api.g_number))))
2072: or
2073: (NOT l_api_updating)
2074: then

Line 2071: nvl(p_job_id, hr_api.g_number))))

2067: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2068: nvl(p_position_id, hr_api.g_number))
2069: or
2070: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2071: nvl(p_job_id, hr_api.g_number))))
2072: or
2073: (NOT l_api_updating)
2074: then
2075: hr_utility.set_location(l_proc, 40);

Line 2240: hr_api.mandatory_arg_error

2236: --
2237: --
2238: -- Check mandatory parameters have been set
2239: --
2240: hr_api.mandatory_arg_error
2241: (p_api_name => l_proc
2242: ,p_argument => 'primary_flag'
2243: ,p_argument_value => p_primary_flag
2244: );

Line 2246: hr_api.mandatory_arg_error

2242: ,p_argument => 'primary_flag'
2243: ,p_argument_value => p_primary_flag
2244: );
2245: --
2246: hr_api.mandatory_arg_error
2247: (p_api_name => l_proc
2248: ,p_argument => 'person_id'
2249: ,p_argument_value => p_person_id
2250: );

Line 2252: hr_api.mandatory_arg_error

2248: ,p_argument => 'person_id'
2249: ,p_argument_value => p_person_id
2250: );
2251: --
2252: hr_api.mandatory_arg_error
2253: (p_api_name => l_proc
2254:
2255: ,p_argument => 'validation_start_date'
2256: ,p_argument_value => p_validation_start_date

Line 2259: hr_api.mandatory_arg_error

2255: ,p_argument => 'validation_start_date'
2256: ,p_argument_value => p_validation_start_date
2257: );
2258: --
2259: hr_api.mandatory_arg_error
2260: (p_api_name => l_proc
2261: ,p_argument => 'validation_end_date'
2262: ,p_argument_value => p_validation_end_date
2263: );

Line 2278: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>

2274: --
2275: hr_utility.set_location(l_proc, 30);
2276: --
2277: if ((l_api_updating and
2278: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>
2279: nvl(p_primary_flag, hr_api.g_varchar2)) or
2280: (NOT l_api_updating)) then
2281: --
2282: -- Check if primary flag is either 'Y' or 'N'.

Line 2279: nvl(p_primary_flag, hr_api.g_varchar2)) or

2275: hr_utility.set_location(l_proc, 30);
2276: --
2277: if ((l_api_updating and
2278: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>
2279: nvl(p_primary_flag, hr_api.g_varchar2)) or
2280: (NOT l_api_updating)) then
2281: --
2282: -- Check if primary flag is either 'Y' or 'N'.
2283: --

Line 2317: If p_validation_end_date <> hr_api.g_eot then

2313: hr_utility.set_location(l_proc, 50);
2314: --
2315: -- Check that the effective end date is the end of time
2316: --
2317: If p_validation_end_date <> hr_api.g_eot then
2318: --
2319: hr_utility.set_message(801, 'HR_51323_ASG_INV_PRIM_ASG_EED');
2320: --
2321: hr_multi_message.add

Line 2531: hr_api.mandatory_arg_error

2527: --
2528: begin
2529: hr_utility.set_location('Entering:'|| l_proc, 10);
2530: --
2531: hr_api.mandatory_arg_error
2532: (p_api_name => l_proc
2533: ,p_argument => 'effective_date'
2534: ,p_argument_value => p_effective_date
2535: );

Line 2550: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)

2546: );
2547: hr_utility.set_location(l_proc, 30);
2548: --
2549: if ((l_api_updating and
2550: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2551: <> nvl(p_probation_period, hr_api.g_number))
2552: or
2553: (NOT l_api_updating))
2554: then

Line 2551: <> nvl(p_probation_period, hr_api.g_number))

2547: hr_utility.set_location(l_proc, 30);
2548: --
2549: if ((l_api_updating and
2550: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2551: <> nvl(p_probation_period, hr_api.g_number))
2552: or
2553: (NOT l_api_updating))
2554: then
2555: hr_utility.set_location(l_proc, 40);

Line 2607: hr_api.mandatory_arg_error

2603: hr_utility.set_location('Entering:'|| l_proc, 10);
2604: --
2605: -- Check mandatory parameters have been set
2606: --
2607: hr_api.mandatory_arg_error
2608: (p_api_name => l_proc
2609: ,p_argument => 'effective_date'
2610: ,p_argument_value => p_effective_date
2611: );

Line 2613: hr_api.mandatory_arg_error

2609: ,p_argument => 'effective_date'
2610: ,p_argument_value => p_effective_date
2611: );
2612: --
2613: hr_api.mandatory_arg_error
2614: (p_api_name => l_proc
2615: ,p_argument => 'validation_start_date'
2616: ,p_argument_value => p_validation_start_date
2617: );

Line 2619: hr_api.mandatory_arg_error

2615: ,p_argument => 'validation_start_date'
2616: ,p_argument_value => p_validation_start_date
2617: );
2618: --
2619: hr_api.mandatory_arg_error
2620: (p_api_name => l_proc
2621: ,p_argument => 'validation_end_date'
2622: ,p_argument_value => p_validation_end_date
2623: );

Line 2638: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)

2634: );
2635: hr_utility.set_location(l_proc, 30);
2636: --
2637: if ((l_api_updating and
2638: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2639: <> nvl(p_probation_unit, hr_api.g_varchar2))
2640: or
2641: (NOT l_api_updating))
2642: then

Line 2639: <> nvl(p_probation_unit, hr_api.g_varchar2))

2635: hr_utility.set_location(l_proc, 30);
2636: --
2637: if ((l_api_updating and
2638: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2639: <> nvl(p_probation_unit, hr_api.g_varchar2))
2640: or
2641: (NOT l_api_updating))
2642: then
2643: hr_utility.set_location(l_proc, 40);

Line 2654: if hr_api.not_exists_in_dt_hr_lookups

2650: -- lookup type 'QUALIFYING_UNITS' with an enabled flag set to 'Y'
2651: -- and that the effective start date of the assignment is between
2652: -- start date active and end date active in hr_lookups.
2653: --
2654: if hr_api.not_exists_in_dt_hr_lookups
2655: (p_effective_date => p_effective_date
2656: ,p_validation_start_date => p_validation_start_date
2657: ,p_validation_end_date => p_validation_end_date
2658: ,p_lookup_type => 'QUALIFYING_UNITS'

Line 2709: hr_api.mandatory_arg_error

2705: if hr_multi_message.no_exclusive_error
2706: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2707: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2708: ) then
2709: hr_api.mandatory_arg_error
2710: (p_api_name => l_proc
2711: ,p_argument => 'effective_date'
2712: ,p_argument_value => p_effective_date
2713: );

Line 2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)

2722: ,p_object_version_number => p_object_version_number);
2723: --
2724: if ((l_api_updating
2725: and
2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2727: <> nvl(p_probation_unit, hr_api.g_varchar2)
2728: or
2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2730: <> nvl(p_probation_period, hr_api.g_number))

Line 2727: <> nvl(p_probation_unit, hr_api.g_varchar2)

2723: --
2724: if ((l_api_updating
2725: and
2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2727: <> nvl(p_probation_unit, hr_api.g_varchar2)
2728: or
2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2730: <> nvl(p_probation_period, hr_api.g_number))
2731: or

Line 2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)

2725: and
2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2727: <> nvl(p_probation_unit, hr_api.g_varchar2)
2728: or
2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2730: <> nvl(p_probation_period, hr_api.g_number))
2731: or
2732: (NOT l_api_updating)) then
2733: --

Line 2730: <> nvl(p_probation_period, hr_api.g_number))

2726: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2727: <> nvl(p_probation_unit, hr_api.g_varchar2)
2728: or
2729: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2730: <> nvl(p_probation_period, hr_api.g_number))
2731: or
2732: (NOT l_api_updating)) then
2733: --
2734: hr_utility.set_location(l_proc, 2);

Line 2801: and nvl(effective_end_date, hr_api.g_eot);

2797: from per_all_people_f
2798: where person_id = p_recruiter_id
2799: and p_validation_start_date
2800: between effective_start_date
2801: and nvl(effective_end_date, hr_api.g_eot);
2802: --
2803: begin
2804: hr_utility.set_location('Entering:'|| l_proc, 10);
2805: --

Line 2809: hr_api.mandatory_arg_error

2805: --
2806: --
2807: -- Check mandatory parameters have been set
2808: --
2809: hr_api.mandatory_arg_error
2810: (p_api_name => l_proc
2811: ,p_argument => 'effective_date'
2812: ,p_argument_value => p_effective_date
2813: );

Line 2816: hr_api.mandatory_arg_error

2812: ,p_argument_value => p_effective_date
2813: );
2814: hr_utility.set_location(l_proc, 20);
2815: --
2816: hr_api.mandatory_arg_error
2817: (p_api_name => l_proc
2818: ,p_argument => 'validation_start_date'
2819: ,p_argument_value => p_validation_start_date
2820: );

Line 2823: hr_api.mandatory_arg_error

2819: ,p_argument_value => p_validation_start_date
2820: );
2821: hr_utility.set_location(l_proc, 30);
2822: --
2823: hr_api.mandatory_arg_error
2824: (p_api_name => l_proc
2825: ,p_argument => 'validation_end_date'
2826: ,p_argument_value => p_validation_end_date
2827: );

Line 2841: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>

2837: ,p_object_version_number => p_object_version_number);
2838: hr_utility.set_location(l_proc, 50);
2839: --
2840: if ((l_api_updating and
2841: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>
2842: nvl(p_recruiter_id, hr_api.g_number)) or
2843: (NOT l_api_updating)) then
2844: hr_utility.set_location(l_proc, 60);
2845: --

Line 2842: nvl(p_recruiter_id, hr_api.g_number)) or

2838: hr_utility.set_location(l_proc, 50);
2839: --
2840: if ((l_api_updating and
2841: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>
2842: nvl(p_recruiter_id, hr_api.g_number)) or
2843: (NOT l_api_updating)) then
2844: hr_utility.set_location(l_proc, 60);
2845: --
2846: -- Check if recruiter is not null

Line 2901: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or

2897: -- Check that the recruiter is an employee.
2898: --
2899: -- Bug 3190625
2900: -- Condition to check profile value also added
2901: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
2902: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2903: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2904: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2905: hr_multi_message.add

Line 2959: and nvl(date_end, hr_api.g_eot);

2955: from per_recruitment_activities
2956: where recruitment_activity_id = p_recruitment_activity_id
2957: and p_validation_start_date
2958: between date_start
2959: and nvl(date_end, hr_api.g_eot);
2960: --
2961: begin
2962: hr_utility.set_location('Entering:'|| l_proc, 10);
2963: --

Line 2966: hr_api.mandatory_arg_error

2962: hr_utility.set_location('Entering:'|| l_proc, 10);
2963: --
2964: -- Check mandatory parameters have been set
2965: --
2966: hr_api.mandatory_arg_error
2967: (p_api_name => l_proc
2968: ,p_argument => 'effective_date'
2969: ,p_argument_value => p_effective_date
2970: );

Line 2972: hr_api.mandatory_arg_error

2968: ,p_argument => 'effective_date'
2969: ,p_argument_value => p_effective_date
2970: );
2971: --
2972: hr_api.mandatory_arg_error
2973: (p_api_name => l_proc
2974: ,p_argument => 'validation_start_date'
2975: ,p_argument_value => p_validation_start_date
2976: );

Line 2978: hr_api.mandatory_arg_error

2974: ,p_argument => 'validation_start_date'
2975: ,p_argument_value => p_validation_start_date
2976: );
2977: --
2978: hr_api.mandatory_arg_error
2979: (p_api_name => l_proc
2980: ,p_argument => 'validation_end_date'
2981: ,p_argument_value => p_validation_end_date
2982: );

Line 2997: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>

2993: );
2994: hr_utility.set_location(l_proc, 30);
2995: --
2996: if ((l_api_updating and
2997: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>
2998: nvl(p_recruitment_activity_id, hr_api.g_number)) or
2999: (NOT l_api_updating))
3000: then
3001: hr_utility.set_location(l_proc, 40);

Line 2998: nvl(p_recruitment_activity_id, hr_api.g_number)) or

2994: hr_utility.set_location(l_proc, 30);
2995: --
2996: if ((l_api_updating and
2997: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>
2998: nvl(p_recruitment_activity_id, hr_api.g_number)) or
2999: (NOT l_api_updating))
3000: then
3001: hr_utility.set_location(l_proc, 40);
3002: --

Line 3410: hr_api.mandatory_arg_error

3406: hr_utility.set_location('Entering:'|| l_proc, 10);
3407: --
3408: -- Check mandatory parameters have been set
3409: --
3410: hr_api.mandatory_arg_error
3411: (p_api_name => l_proc
3412: ,p_argument => 'effective_date'
3413: ,p_argument_value => p_effective_date
3414: );

Line 3416: hr_api.mandatory_arg_error

3412: ,p_argument => 'effective_date'
3413: ,p_argument_value => p_effective_date
3414: );
3415: --
3416: hr_api.mandatory_arg_error
3417: (p_api_name => l_proc
3418: ,p_argument => 'validation_start_date'
3419: ,p_argument_value => p_validation_start_date
3420: );

Line 3422: hr_api.mandatory_arg_error

3418: ,p_argument => 'validation_start_date'
3419: ,p_argument_value => p_validation_start_date
3420: );
3421: --
3422: hr_api.mandatory_arg_error
3423: (p_api_name => l_proc
3424: ,p_argument => 'validation_end_date'
3425: ,p_argument_value => p_validation_end_date
3426: );

Line 3442: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,

3438: hr_utility.set_location(l_proc, 30);
3439: --
3440: if ((l_api_updating and
3441: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3442: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,
3443: hr_api.g_varchar2))
3444: or
3445: (NOT l_api_updating))
3446: then

Line 3443: hr_api.g_varchar2))

3439: --
3440: if ((l_api_updating and
3441: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3442: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,
3443: hr_api.g_varchar2))
3444: or
3445: (NOT l_api_updating))
3446: then
3447: hr_utility.set_location(l_proc, 40);

Line 3473: if hr_api.not_exists_in_dt_hr_lookups

3469: -- flag set to 'Y' and that the effective start date of the
3470: -- assignment is between start date active and end date active
3471: -- in hr_lookups.
3472: --
3473: if hr_api.not_exists_in_dt_hr_lookups
3474: (p_effective_date => p_effective_date
3475: ,p_validation_start_date => p_validation_start_date
3476: ,p_validation_end_date => p_validation_end_date
3477: ,p_lookup_type => 'FREQUENCY'

Line 3519: hr_api.mandatory_arg_error

3515: hr_utility.set_location('Entering:'|| l_proc, 1);
3516: --
3517: -- Check mandatory parameters have been set
3518: --
3519: hr_api.mandatory_arg_error
3520: (p_api_name => l_proc
3521: ,p_argument => 'effective_date'
3522: ,p_argument_value => p_effective_date
3523: );

Line 3538: hr_api.g_number) <> nvl(p_sal_review_period,

3534: hr_utility.set_location(l_proc, 2);
3535: --
3536: if ((l_api_updating and
3537: nvl(per_asg_shd.g_old_rec.sal_review_period,
3538: hr_api.g_number) <> nvl(p_sal_review_period,
3539: hr_api.g_number)) or (NOT l_api_updating)) then
3540: --
3541: hr_utility.set_location(l_proc, 3);
3542: --

Line 3539: hr_api.g_number)) or (NOT l_api_updating)) then

3535: --
3536: if ((l_api_updating and
3537: nvl(per_asg_shd.g_old_rec.sal_review_period,
3538: hr_api.g_number) <> nvl(p_sal_review_period,
3539: hr_api.g_number)) or (NOT l_api_updating)) then
3540: --
3541: hr_utility.set_location(l_proc, 3);
3542: --
3543: -- Check if sal review period is not null

Line 3601: hr_api.mandatory_arg_error

3597: ) then
3598: --
3599: -- Check mandatory parameters have been set
3600: --
3601: hr_api.mandatory_arg_error
3602: (p_api_name => l_proc
3603: ,p_argument => 'effective_date'
3604: ,p_argument_value => p_effective_date
3605: );

Line 3618: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)

3614: ,p_effective_date => p_effective_date
3615: ,p_object_version_number => p_object_version_number);
3616: --
3617: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3618: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3619: or
3620: nvl(per_asg_shd.g_old_rec.sal_review_period,
3621: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))
3622: or

Line 3621: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))

3617: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3618: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3619: or
3620: nvl(per_asg_shd.g_old_rec.sal_review_period,
3621: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))
3622: or
3623: (NOT l_api_updating)) then
3624: --
3625: hr_utility.set_location(l_proc, 2);

Line 3698: hr_api.mandatory_arg_error

3694: hr_utility.set_location('Entering:'|| l_proc, 10);
3695: --
3696: -- Check mandatory parameters have been set
3697: --
3698: hr_api.mandatory_arg_error
3699: (p_api_name => l_proc
3700: ,p_argument => 'effective_date'
3701: ,p_argument_value => p_effective_date
3702: );

Line 3718: hr_api.g_number) <> nvl(p_set_of_books_id, hr_api.g_number)) or

3714: hr_utility.set_location(l_proc, 30);
3715: --
3716: if ((l_api_updating and
3717: nvl(per_asg_shd.g_old_rec.set_of_books_id,
3718: hr_api.g_number) <> nvl(p_set_of_books_id, hr_api.g_number)) or
3719: (NOT l_api_updating))
3720: then
3721: hr_utility.set_location(l_proc, 40);
3722: --

Line 3810: between nvl(start_date_active,hr_api.g_sot)

3806: from hr_soft_coding_keyflex
3807: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
3808: and enabled_flag = 'Y'
3809: and p_validation_start_date
3810: between nvl(start_date_active,hr_api.g_sot)
3811: and nvl(end_date_active,hr_api.g_eot);
3812: --
3813: cursor csr_bg is
3814: select legislation_code

Line 3811: and nvl(end_date_active,hr_api.g_eot);

3807: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
3808: and enabled_flag = 'Y'
3809: and p_validation_start_date
3810: between nvl(start_date_active,hr_api.g_sot)
3811: and nvl(end_date_active,hr_api.g_eot);
3812: --
3813: cursor csr_bg is
3814: select legislation_code
3815: from per_business_groups_perf

Line 3835: hr_api.mandatory_arg_error

3831: hr_utility.set_location('Entering:'|| l_proc, 10);
3832: --
3833: -- Check mandatory parameters have been set
3834: --
3835: hr_api.mandatory_arg_error
3836: (p_api_name => l_proc
3837: ,p_argument => 'effective_date'
3838: ,p_argument_value => p_effective_date
3839: );

Line 3855: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>

3851: );
3852: hr_utility.set_location(l_proc, 30);
3853: --
3854: if ((l_api_updating and
3855: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>
3856: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or
3857: --
3858: -- ****** Start new code for bug #2182184 **************************
3859: --

Line 3856: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or

3852: hr_utility.set_location(l_proc, 30);
3853: --
3854: if ((l_api_updating and
3855: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>
3856: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or
3857: --
3858: -- ****** Start new code for bug #2182184 **************************
3859: --
3860: (l_api_updating and

Line 3973: and nvl(date_to, hr_api.g_eot);

3969: from per_organization_units
3970: where organization_id = p_source_organization_id
3971: and p_validation_start_date
3972: between date_from
3973: and nvl(date_to, hr_api.g_eot);
3974: --
3975: begin
3976: hr_utility.set_location('Entering:'|| l_proc, 10);
3977: --

Line 3980: hr_api.mandatory_arg_error

3976: hr_utility.set_location('Entering:'|| l_proc, 10);
3977: --
3978: -- Check mandatory parameters have been set
3979: --
3980: hr_api.mandatory_arg_error
3981: (p_api_name => l_proc
3982: ,p_argument => 'effective_date'
3983: ,p_argument_value => p_effective_date
3984: );

Line 3986: hr_api.mandatory_arg_error

3982: ,p_argument => 'effective_date'
3983: ,p_argument_value => p_effective_date
3984: );
3985: --
3986: hr_api.mandatory_arg_error
3987: (p_api_name => l_proc
3988: ,p_argument => 'validation_start_date'
3989: ,p_argument_value => p_validation_start_date
3990: );

Line 3992: hr_api.mandatory_arg_error

3988: ,p_argument => 'validation_start_date'
3989: ,p_argument_value => p_validation_start_date
3990: );
3991: --
3992: hr_api.mandatory_arg_error
3993: (p_api_name => l_proc
3994: ,p_argument => 'validation_end_date'
3995: ,p_argument_value => p_validation_end_date
3996: );

Line 4011: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)

4007: );
4008: hr_utility.set_location(l_proc, 30);
4009: --
4010: if ((l_api_updating
4011: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)
4012: <> nvl(p_source_organization_id, hr_api.g_number))
4013: or
4014: (NOT l_api_updating))
4015: then

Line 4012: <> nvl(p_source_organization_id, hr_api.g_number))

4008: hr_utility.set_location(l_proc, 30);
4009: --
4010: if ((l_api_updating
4011: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)
4012: <> nvl(p_source_organization_id, hr_api.g_number))
4013: or
4014: (NOT l_api_updating))
4015: then
4016: hr_utility.set_location(l_proc, 40);

Line 4117: hr_api.mandatory_arg_error

4113: hr_utility.set_location('Entering:'|| l_proc, 10);
4114: --
4115: -- Check mandatory parameters have been set
4116: --
4117: hr_api.mandatory_arg_error
4118: (p_api_name => l_proc
4119: ,p_argument => 'effective_date'
4120: ,p_argument_value => p_effective_date
4121: );

Line 4122: hr_api.mandatory_arg_error

4118: (p_api_name => l_proc
4119: ,p_argument => 'effective_date'
4120: ,p_argument_value => p_effective_date
4121: );
4122: hr_api.mandatory_arg_error
4123: (p_api_name => l_proc
4124: ,p_argument => 'validation_start_date'
4125: ,p_argument_value => p_validation_start_date
4126: );

Line 4128: hr_api.mandatory_arg_error

4124: ,p_argument => 'validation_start_date'
4125: ,p_argument_value => p_validation_start_date
4126: );
4127: --
4128: hr_api.mandatory_arg_error
4129: (p_api_name => l_proc
4130: ,p_argument => 'validation_end_date'
4131: ,p_argument_value => p_validation_end_date
4132: );

Line 4147: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>

4143: );
4144: hr_utility.set_location(l_proc, 30);
4145: --
4146: if ((l_api_updating and
4147: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>
4148: nvl(p_source_type, hr_api.g_varchar2))
4149: or (NOT l_api_updating))
4150: then
4151: hr_utility.set_location(l_proc, 40);

Line 4148: nvl(p_source_type, hr_api.g_varchar2))

4144: hr_utility.set_location(l_proc, 30);
4145: --
4146: if ((l_api_updating and
4147: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>
4148: nvl(p_source_type, hr_api.g_varchar2))
4149: or (NOT l_api_updating))
4150: then
4151: hr_utility.set_location(l_proc, 40);
4152: --

Line 4162: if hr_api.not_exists_in_dt_hr_lookups

4158: -- type 'REC_TYPE' with an enabled flag set to 'Y' and that the
4159: -- effective start date of the assignment is between start date
4160: -- active and end date active in hr_lookups.
4161: --
4162: if hr_api.not_exists_in_dt_hr_lookups
4163: (p_effective_date => p_effective_date
4164: ,p_validation_start_date => p_validation_start_date
4165: ,p_validation_end_date => p_validation_end_date
4166: ,p_lookup_type => 'REC_TYPE'

Line 4191: If p_source_type <> nvl(l_rec_act_type, hr_api.g_varchar2) then

4187: fetch csr_get_rec_act_type into l_rec_act_type;
4188: close csr_get_rec_act_type;
4189: hr_utility.set_location(l_proc, 60);
4190: --
4191: If p_source_type <> nvl(l_rec_act_type, hr_api.g_varchar2) then
4192: --
4193: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4194: hr_multi_message.add
4195: (p_associated_column1 =>

Line 4296: hr_api.mandatory_arg_error

4292: --
4293: --
4294: -- Check mandatory parameters have been set
4295: --
4296: hr_api.mandatory_arg_error
4297: (p_api_name => l_proc
4298: ,p_argument => 'validation_start_date'
4299: ,p_argument_value => p_validation_start_date
4300: );

Line 4302: hr_api.mandatory_arg_error

4298: ,p_argument => 'validation_start_date'
4299: ,p_argument_value => p_validation_start_date
4300: );
4301: --
4302: hr_api.mandatory_arg_error
4303: (p_api_name => l_proc
4304: ,p_argument => 'validation_end_date'
4305: ,p_argument_value => p_validation_end_date
4306: );

Line 4308: hr_api.mandatory_arg_error

4304: ,p_argument => 'validation_end_date'
4305: ,p_argument_value => p_validation_end_date
4306: );
4307: --
4308: hr_api.mandatory_arg_error
4309: (p_api_name => l_proc
4310: ,p_argument => 'effective_date'
4311: ,p_argument_value => p_effective_date
4312: );

Line 4314: hr_api.mandatory_arg_error

4310: ,p_argument => 'effective_date'
4311: ,p_argument_value => p_effective_date
4312: );
4313: --
4314: hr_api.mandatory_arg_error
4315: (p_api_name => l_proc
4316: ,p_argument => 'business_group_id'
4317: ,p_argument_value => p_business_group_id
4318: );

Line 4333: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>

4329: );
4330: hr_utility.set_location(l_proc, 30);
4331: --
4332: if ((l_api_updating and
4333: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>
4334: nvl(p_special_ceiling_step_id, hr_api.g_number)) or
4335: (NOT l_api_updating)) then
4336: hr_utility.set_location(l_proc, 40);
4337: --

Line 4334: nvl(p_special_ceiling_step_id, hr_api.g_number)) or

4330: hr_utility.set_location(l_proc, 30);
4331: --
4332: if ((l_api_updating and
4333: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>
4334: nvl(p_special_ceiling_step_id, hr_api.g_number)) or
4335: (NOT l_api_updating)) then
4336: hr_utility.set_location(l_proc, 40);
4337: --
4338: if p_special_ceiling_step_id is not null then

Line 4521: hr_api.mandatory_arg_error

4517: ) then
4518: --
4519: -- Check mandatory parameters have been set
4520: --
4521: hr_api.mandatory_arg_error
4522: (p_api_name => l_proc
4523: ,p_argument => 'person_id'
4524: ,p_argument_value => p_person_id
4525: );

Line 4527: hr_api.mandatory_arg_error

4523: ,p_argument => 'person_id'
4524: ,p_argument_value => p_person_id
4525: );
4526: --
4527: hr_api.mandatory_arg_error
4528: (p_api_name => l_proc
4529: ,p_argument => 'business_group_id'
4530: ,p_argument_value => p_business_group_id
4531: );

Line 4533: hr_api.mandatory_arg_error

4529: ,p_argument => 'business_group_id'
4530: ,p_argument_value => p_business_group_id
4531: );
4532: --
4533: hr_api.mandatory_arg_error
4534: (p_api_name => l_proc
4535: ,p_argument => 'validation_start_date'
4536: ,p_argument_value => p_validation_start_date
4537: );

Line 4539: hr_api.mandatory_arg_error

4535: ,p_argument => 'validation_start_date'
4536: ,p_argument_value => p_validation_start_date
4537: );
4538: --
4539: hr_api.mandatory_arg_error
4540: (p_api_name => l_proc
4541: ,p_argument => 'effective_date'
4542: ,p_argument_value => p_effective_date
4543: );

Line 4558: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>

4554: );
4555: hr_utility.set_location(l_proc, 30);
4556: --
4557: if ((l_api_updating and
4558: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4559: nvl(p_supervisor_id, hr_api.g_number)) or
4560: (NOT l_api_updating))
4561: then
4562: hr_utility.set_location(l_proc, 40);

Line 4559: nvl(p_supervisor_id, hr_api.g_number)) or

4555: hr_utility.set_location(l_proc, 30);
4556: --
4557: if ((l_api_updating and
4558: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4559: nvl(p_supervisor_id, hr_api.g_number)) or
4560: (NOT l_api_updating))
4561: then
4562: hr_utility.set_location(l_proc, 40);
4563: --

Line 4641: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'

4637: --
4638: -- Check that the supervisor is an employee or a contingent
4639: -- worker where the profile option permits.
4640: --
4641: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'
4642: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and
4643: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4644: Then
4645: --Bug3917021

Line 4642: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and

4638: -- Check that the supervisor is an employee or a contingent
4639: -- worker where the profile option permits.
4640: --
4641: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'
4642: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and
4643: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4644: Then
4645: --Bug3917021
4646: if csr_asg_typ%isopen then

Line 4708: hr_api.mandatory_arg_error

4704: ) then
4705: --
4706: -- Check mandatory parameters have been set
4707: --
4708: hr_api.mandatory_arg_error
4709: (p_api_name => l_proc
4710: ,p_argument => 'validation_start_date'
4711: ,p_argument_value => p_validation_start_date
4712: );

Line 4714: hr_api.mandatory_arg_error

4710: ,p_argument => 'validation_start_date'
4711: ,p_argument_value => p_validation_start_date
4712: );
4713: --
4714: hr_api.mandatory_arg_error
4715: (p_api_name => l_proc
4716: ,p_argument => 'effective_date'
4717: ,p_argument_value => p_effective_date
4718: );

Line 4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>

4733: -- Re-validate if either the supervisor or supervisor assignment
4734: -- has changed.
4735: --
4736: if (l_api_updating and
4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4738: nvl(p_supervisor_id, hr_api.g_number))
4739: or
4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or

Line 4738: nvl(p_supervisor_id, hr_api.g_number))

4734: -- has changed.
4735: --
4736: if (l_api_updating and
4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4738: nvl(p_supervisor_id, hr_api.g_number))
4739: or
4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4742: (NOT l_api_updating))

Line 4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>

4736: if (l_api_updating and
4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4738: nvl(p_supervisor_id, hr_api.g_number))
4739: or
4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4742: (NOT l_api_updating))
4743: then
4744:

Line 4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or

4737: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4738: nvl(p_supervisor_id, hr_api.g_number))
4739: or
4740: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4741: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4742: (NOT l_api_updating))
4743: then
4744:
4745: hr_utility.set_location(l_proc, 40);

Line 4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>

4743: then
4744:
4745: hr_utility.set_location(l_proc, 40);
4746: ----
4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4748: nvl(p_supervisor_id, hr_api.g_number))
4749: and
4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then

Line 4748: nvl(p_supervisor_id, hr_api.g_number))

4744:
4745: hr_utility.set_location(l_proc, 40);
4746: ----
4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4748: nvl(p_supervisor_id, hr_api.g_number))
4749: and
4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4752: p_supervisor_assignment_id := NULL;

Line 4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =

4746: ----
4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4748: nvl(p_supervisor_id, hr_api.g_number))
4749: and
4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4752: p_supervisor_assignment_id := NULL;
4753: end if;
4754: ---

Line 4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then

4747: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4748: nvl(p_supervisor_id, hr_api.g_number))
4749: and
4750: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4751: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4752: p_supervisor_assignment_id := NULL;
4753: end if;
4754: ---
4755:

Line 4795: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'

4791: --
4792: -- Check that the supervisor assignment is an employee or a contingent
4793: -- worker assignment.
4794: --
4795: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'
4796: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and
4797: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4798: Then
4799: --

Line 4796: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and

4792: -- Check that the supervisor assignment is an employee or a contingent
4793: -- worker assignment.
4794: --
4795: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'
4796: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and
4797: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4798: Then
4799: --
4800: hr_utility.set_location(l_proc, 80);

Line 4863: hr_api.mandatory_arg_error

4859: hr_utility.set_location('Entering:'|| l_proc, 1);
4860: --
4861: -- Check mandatory parameters have been set
4862: --
4863: hr_api.mandatory_arg_error
4864: (p_api_name => l_proc
4865: ,p_argument => 'person_id'
4866: ,p_argument_value => p_person_id
4867: );

Line 4869: hr_api.mandatory_arg_error

4865: ,p_argument => 'person_id'
4866: ,p_argument_value => p_person_id
4867: );
4868: --
4869: hr_api.mandatory_arg_error
4870: (p_api_name => l_proc
4871: ,p_argument => 'validation_start_date'
4872: ,p_argument_value => p_validation_start_date
4873: );

Line 4875: hr_api.mandatory_arg_error

4871: ,p_argument => 'validation_start_date'
4872: ,p_argument_value => p_validation_start_date
4873: );
4874: --
4875: hr_api.mandatory_arg_error
4876: (p_api_name => l_proc
4877: ,p_argument => 'validation_end_date'
4878: ,p_argument_value => p_validation_end_date
4879: );

Line 5207: and nvl(date_to, hr_api.g_eot);

5203: from per_vacancies
5204: where vacancy_id = p_vacancy_id
5205: and p_validation_start_date
5206: between date_from
5207: and nvl(date_to, hr_api.g_eot);
5208: --
5209: cursor csr_val_vacancy_id_offer is
5210: select business_group_id
5211: from per_vacancies

Line 5219: hr_api.mandatory_arg_error

5215: hr_utility.set_location('Entering:'|| l_proc, 10);
5216: --
5217: -- Check mandatory parameters have been set
5218: --
5219: hr_api.mandatory_arg_error
5220: (p_api_name => l_proc
5221: ,p_argument => 'effective_date'
5222: ,p_argument_value => p_effective_date
5223: );

Line 5225: hr_api.mandatory_arg_error

5221: ,p_argument => 'effective_date'
5222: ,p_argument_value => p_effective_date
5223: );
5224: --
5225: hr_api.mandatory_arg_error
5226: (p_api_name => l_proc
5227: ,p_argument => 'validation_start_date'
5228: ,p_argument_value => p_validation_start_date
5229: );

Line 5231: hr_api.mandatory_arg_error

5227: ,p_argument => 'validation_start_date'
5228: ,p_argument_value => p_validation_start_date
5229: );
5230: --
5231: hr_api.mandatory_arg_error
5232: (p_api_name => l_proc
5233: ,p_argument => 'validation_end_date'
5234: ,p_argument_value => p_validation_end_date
5235: );

Line 5250: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>

5246: );
5247: hr_utility.set_location(l_proc, 30);
5248: --
5249: if ((l_api_updating and
5250: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>
5251: nvl(p_vacancy_id, hr_api.g_number)) or
5252: (NOT l_api_updating)) then
5253: hr_utility.set_location(l_proc, 40);
5254: --

Line 5251: nvl(p_vacancy_id, hr_api.g_number)) or

5247: hr_utility.set_location(l_proc, 30);
5248: --
5249: if ((l_api_updating and
5250: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>
5251: nvl(p_vacancy_id, hr_api.g_number)) or
5252: (NOT l_api_updating)) then
5253: hr_utility.set_location(l_proc, 40);
5254: --
5255: -- Check if vacancy is not null

Line 5376: hr_api.mandatory_arg_error

5372: ) then
5373: --
5374: -- Check mandatory parameters have been set
5375: --
5376: hr_api.mandatory_arg_error
5377: (p_api_name => l_proc
5378: ,p_argument => 'assignment_type'
5379: ,p_argument_value => p_assignment_type
5380: );

Line 5382: hr_api.mandatory_arg_error

5378: ,p_argument => 'assignment_type'
5379: ,p_argument_value => p_assignment_type
5380: );
5381: --
5382: hr_api.mandatory_arg_error
5383: (p_api_name => l_proc
5384: ,p_argument => 'person_id'
5385: ,p_argument_value => p_person_id
5386: );

Line 5455: hr_api.mandatory_arg_error

5451: hr_utility.set_location('Entering:'|| l_proc, 1);
5452: --
5453: -- Check mandatory parameters have been set
5454: --
5455: hr_api.mandatory_arg_error
5456: (p_api_name => l_proc
5457: ,p_argument => 'organization_id'
5458: ,p_argument_value => p_organization_id
5459: );

Line 5461: hr_api.mandatory_arg_error

5457: ,p_argument => 'organization_id'
5458: ,p_argument_value => p_organization_id
5459: );
5460: --
5461: hr_api.mandatory_arg_error
5462: (p_api_name => l_proc
5463: ,p_argument => 'effective_date'
5464: ,p_argument_value => p_effective_date
5465: );

Line 5469: l_assignment_id := nvl(p_assignment_id, hr_api.g_number);

5465: );
5466: --
5467: -- Assigment_id will be NULL on insert, so set to default value.
5468: --
5469: l_assignment_id := nvl(p_assignment_id, hr_api.g_number);
5470: --
5471: -- Check whether another current assignment exists in the same
5472: -- organization with manager flag set to 'Y'.
5473: --

Line 5509: hr_api.mandatory_arg_error

5505: hr_utility.set_location('Entering:'|| l_proc, 10);
5506: --
5507: -- Check mandatory parameters have been set
5508: --
5509: hr_api.mandatory_arg_error
5510: (p_api_name => l_proc
5511: ,p_argument => 'effective_date'
5512: ,p_argument_value => p_effective_date
5513: );

Line 5515: hr_api.mandatory_arg_error

5511: ,p_argument => 'effective_date'
5512: ,p_argument_value => p_effective_date
5513: );
5514: --
5515: hr_api.mandatory_arg_error
5516: (p_api_name => l_proc
5517: ,p_argument => 'validation_start_date'
5518: ,p_argument_value => p_validation_start_date
5519: );

Line 5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>

5533: --
5534: if NOT l_api_updating
5535: or
5536: (l_api_updating and
5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5538: nvl(p_date_probation_end, hr_api.g_date))
5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))

Line 5538: nvl(p_date_probation_end, hr_api.g_date))

5534: if NOT l_api_updating
5535: or
5536: (l_api_updating and
5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5538: nvl(p_date_probation_end, hr_api.g_date))
5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or

Line 5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>

5536: (l_api_updating and
5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5538: nvl(p_date_probation_end, hr_api.g_date))
5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or
5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5544: nvl(p_probation_period, hr_api.g_number))))

Line 5541: nvl(p_probation_unit, hr_api.g_varchar2))

5537: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5538: nvl(p_date_probation_end, hr_api.g_date))
5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or
5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5544: nvl(p_probation_period, hr_api.g_number))))
5545: then

Line 5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>

5539: or
5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or
5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5544: nvl(p_probation_period, hr_api.g_number))))
5545: then
5546: hr_utility.set_location(l_proc, 40);
5547: --

Line 5544: nvl(p_probation_period, hr_api.g_number))))

5540: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5541: nvl(p_probation_unit, hr_api.g_varchar2))
5542: or
5543: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5544: nvl(p_probation_period, hr_api.g_number))))
5545: then
5546: hr_utility.set_location(l_proc, 40);
5547: --
5548: -- Check if probation unit and probation period are both not null.

Line 5621: hr_api.mandatory_arg_error

5617: hr_utility.set_location('Entering:'|| l_proc, 10);
5618: --
5619: -- Check mandatory parameters have been set
5620: --
5621: hr_api.mandatory_arg_error
5622: (p_api_name => l_proc
5623: ,p_argument => 'effective_date'
5624: ,p_argument_value => p_effective_date
5625: );

Line 5639: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)

5635: ,p_object_version_number => p_object_version_number);
5636: hr_utility.set_location(l_proc, 30);
5637: --
5638: if ((l_api_updating and
5639: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)
5640: <> nvl(p_internal_address_line, hr_api.g_varchar2))
5641: or
5642: (NOT l_api_updating)) then
5643: hr_utility.set_location(l_proc, 40);

Line 5640: <> nvl(p_internal_address_line, hr_api.g_varchar2))

5636: hr_utility.set_location(l_proc, 30);
5637: --
5638: if ((l_api_updating and
5639: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)
5640: <> nvl(p_internal_address_line, hr_api.g_varchar2))
5641: or
5642: (NOT l_api_updating)) then
5643: hr_utility.set_location(l_proc, 40);
5644: --

Line 5705: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>

5701: ,p_object_version_number => p_object_version_number
5702: );
5703: --
5704: if ((l_api_updating and
5705: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>
5706: nvl(p_applicant_rank, hr_api.g_number)) or
5707: (NOT l_api_updating)) then
5708:
5709: hr_utility.set_location(l_proc, 20);

Line 5706: nvl(p_applicant_rank, hr_api.g_number)) or

5702: );
5703: --
5704: if ((l_api_updating and
5705: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>
5706: nvl(p_applicant_rank, hr_api.g_number)) or
5707: (NOT l_api_updating)) then
5708:
5709: hr_utility.set_location(l_proc, 20);
5710: --

Line 5801: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>

5797: ,p_object_version_number => p_object_version_number
5798: );
5799: --
5800: if ((l_api_updating and
5801: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>
5802: nvl(p_posting_content_id, hr_api.g_number)) or
5803: (NOT l_api_updating)) then
5804:
5805: hr_utility.set_location(l_proc, 20);

Line 5802: nvl(p_posting_content_id, hr_api.g_number)) or

5798: );
5799: --
5800: if ((l_api_updating and
5801: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>
5802: nvl(p_posting_content_id, hr_api.g_number)) or
5803: (NOT l_api_updating)) then
5804:
5805: hr_utility.set_location(l_proc, 20);
5806: --