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 371: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);

367: cursor csr_add_style is
368: select style
369: from per_addresses a
370: where a.person_id = p_person_id and a.primary_flag = 'Y'
371: and p_effective_date between a.date_from and nvl(a.date_to,hr_api.g_eot);
372: l_style per_addresses.style%TYPE;
373: -- end of fix 10040024
374: --
375: begin

Line 384: hr_api.mandatory_arg_error

380: p_payroll_id_updated := FALSE;
381: --
382: -- Check mandatory parameters have been set
383: --
384: hr_api.mandatory_arg_error
385: (p_api_name => l_proc
386: ,p_argument => 'business_group_id'
387: ,p_argument_value => p_business_group_id
388: );

Line 390: hr_api.mandatory_arg_error

386: ,p_argument => 'business_group_id'
387: ,p_argument_value => p_business_group_id
388: );
389: --
390: hr_api.mandatory_arg_error
391: (p_api_name => l_proc
392: ,p_argument => 'validation_start_date'
393: ,p_argument_value => p_validation_start_date
394: );

Line 396: hr_api.mandatory_arg_error

392: ,p_argument => 'validation_start_date'
393: ,p_argument_value => p_validation_start_date
394: );
395: --
396: hr_api.mandatory_arg_error
397: (p_api_name => l_proc
398: ,p_argument => 'effective_date'
399: ,p_argument_value => p_effective_date
400: );

Line 402: hr_api.mandatory_arg_error

398: ,p_argument => 'effective_date'
399: ,p_argument_value => p_effective_date
400: );
401: --
402: hr_api.mandatory_arg_error
403: (p_api_name => l_proc
404: ,p_argument => 'validation_end_date'
405: ,p_argument_value => p_validation_end_date
406: );

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

413: );
414: hr_utility.set_location(l_proc, 30);
415: --
416: if (l_api_updating and
417: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
418: <> nvl(p_payroll_id, hr_api.g_number)) or
419: (per_asg_shd.g_old_rec.assignment_type='A' and
420: p_assignment_type='E')
421: )

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

414: hr_utility.set_location(l_proc, 30);
415: --
416: if (l_api_updating and
417: ((nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
418: <> nvl(p_payroll_id, hr_api.g_number)) or
419: (per_asg_shd.g_old_rec.assignment_type='A' and
420: p_assignment_type='E')
421: )
422: )

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

424: then
425: hr_utility.set_location(l_proc, 40);
426: --
427: if (l_api_updating and
428: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
429: <> nvl(p_payroll_id, hr_api.g_number)) then
430: --
431: -- As payroll id has been updated, set p_payroll_id_updated to true.
432: -- This functionality is required for the /update/delete_assignment

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

425: hr_utility.set_location(l_proc, 40);
426: --
427: if (l_api_updating and
428: nvl(per_asg_shd.g_old_rec.payroll_id, hr_api.g_number)
429: <> nvl(p_payroll_id, hr_api.g_number)) then
430: --
431: -- As payroll id has been updated, set p_payroll_id_updated to true.
432: -- This functionality is required for the /update/delete_assignment
433: -- business processes

Line 664: hr_api.g_eot);

660: ,l_cur_opu_effective_start_date
661: ,l_cur_opu_effective_end_date;
662: --
663: l_min_opu_effective_start_date := nvl(l_cur_opu_effective_start_date,
664: hr_api.g_eot);
665: l_max_opu_effective_end_date := nvl(l_cur_opu_effective_end_date,
666: hr_api.g_date);
667: --
668: hr_utility.set_location(l_proc, 140);

Line 666: hr_api.g_date);

662: --
663: l_min_opu_effective_start_date := nvl(l_cur_opu_effective_start_date,
664: hr_api.g_eot);
665: l_max_opu_effective_end_date := nvl(l_cur_opu_effective_end_date,
666: hr_api.g_date);
667: --
668: hr_utility.set_location(l_proc, 140);
669: hr_utility.trace
670: ('l_org_pay_method_usage_id = ' || l_org_pay_method_usage_id);

Line 790: and NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)

786: --
787: --
788: if (l_api_updating
789: -- and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id changed for bug 8404508
790: and NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
791: <> NVL(p_payroll_id,hr_api.g_number)
792: )
793: or (p_datetrack_mode = 'DELETE_NEXT_CHANGE'
794: or p_datetrack_mode = 'FUTURE_CHANGE'

Line 791: <> NVL(p_payroll_id,hr_api.g_number)

787: --
788: if (l_api_updating
789: -- and per_asg_shd.g_old_rec.payroll_id <> p_payroll_id changed for bug 8404508
790: and NVL(per_asg_shd.g_old_rec.payroll_id,hr_api.g_number)
791: <> NVL(p_payroll_id,hr_api.g_number)
792: )
793: or (p_datetrack_mode = 'DELETE_NEXT_CHANGE'
794: or p_datetrack_mode = 'FUTURE_CHANGE'
795: or p_datetrack_mode = 'UPDATE_OVERRIDE'

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

856: select enabled_flag
857: from pay_people_groups
858: where people_group_id = p_people_group_id
859: and p_validation_start_date
860: between nvl(start_date_active,hr_api.g_sot)
861: and nvl(end_date_active,hr_api.g_eot);
862: --
863: cursor csr_valid_id_flex_num is
864: select null

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

857: from pay_people_groups
858: where people_group_id = p_people_group_id
859: and p_validation_start_date
860: between nvl(start_date_active,hr_api.g_sot)
861: and nvl(end_date_active,hr_api.g_eot);
862: --
863: cursor csr_valid_id_flex_num is
864: select null
865: from per_business_groups_perf pbg

Line 877: hr_api.mandatory_arg_error

873: --
874: --
875: -- Check mandatory parameters have been set
876: --
877: hr_api.mandatory_arg_error
878: (p_api_name => l_proc
879: ,p_argument => 'business_group_id'
880: ,p_argument_value => p_business_group_id
881: );

Line 883: hr_api.mandatory_arg_error

879: ,p_argument => 'business_group_id'
880: ,p_argument_value => p_business_group_id
881: );
882: --
883: hr_api.mandatory_arg_error
884: (p_api_name => l_proc
885: ,p_argument => 'validation_start_date'
886: ,p_argument_value => p_validation_start_date
887: );

Line 889: hr_api.mandatory_arg_error

885: ,p_argument => 'validation_start_date'
886: ,p_argument_value => p_validation_start_date
887: );
888: --
889: hr_api.mandatory_arg_error
890: (p_api_name => l_proc
891: ,p_argument => 'effective_date'
892: ,p_argument_value => p_effective_date
893: );

Line 895: hr_api.mandatory_arg_error

891: ,p_argument => 'effective_date'
892: ,p_argument_value => p_effective_date
893: );
894: --
895: hr_api.mandatory_arg_error
896: (p_api_name => l_proc
897: ,p_argument => 'validation_end_date'
898: ,p_argument_value => p_validation_end_date
899: );

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

910: );
911: hr_utility.set_location(l_proc, 30);
912: --
913: if ((l_api_updating and
914: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>
915: nvl(p_people_group_id, hr_api.g_number)) or
916: (NOT l_api_updating))
917: then
918: hr_utility.set_location(l_proc, 40);

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

911: hr_utility.set_location(l_proc, 30);
912: --
913: if ((l_api_updating and
914: nvl(per_asg_shd.g_old_rec.people_group_id, hr_api.g_number) <>
915: nvl(p_people_group_id, hr_api.g_number)) or
916: (NOT l_api_updating))
917: then
918: hr_utility.set_location(l_proc, 40);
919: --

Line 1002: hr_api.mandatory_arg_error

998: hr_utility.set_location('Entering:'|| l_proc, 10);
999: --
1000: -- Check mandatory parameters have been set
1001: --
1002: hr_api.mandatory_arg_error
1003: (p_api_name => l_proc
1004: ,p_argument => 'effective_date'
1005: ,p_argument_value => p_effective_date
1006: );

Line 1008: hr_api.mandatory_arg_error

1004: ,p_argument => 'effective_date'
1005: ,p_argument_value => p_effective_date
1006: );
1007: --
1008: hr_api.mandatory_arg_error
1009: (p_api_name => l_proc
1010: ,p_argument => 'validation_start_date'
1011: ,p_argument_value => p_validation_start_date
1012: );

Line 1014: hr_api.mandatory_arg_error

1010: ,p_argument => 'validation_start_date'
1011: ,p_argument_value => p_validation_start_date
1012: );
1013: --
1014: hr_api.mandatory_arg_error
1015: (p_api_name => l_proc
1016: ,p_argument => 'validation_end_date'
1017: ,p_argument_value => p_validation_end_date
1018: );

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

1030: hr_utility.set_location(l_proc, 30);
1031: --
1032: if ((l_api_updating and
1033: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1034: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,
1035: hr_api.g_varchar2))
1036: or
1037: (NOT l_api_updating))
1038: then

Line 1035: hr_api.g_varchar2))

1031: --
1032: if ((l_api_updating and
1033: nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1034: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency,
1035: hr_api.g_varchar2))
1036: or
1037: (NOT l_api_updating))
1038: then
1039: hr_utility.set_location(l_proc, 40);

Line 1065: if hr_api.not_exists_in_dt_hr_lookups

1061: -- flag set to 'Y' and that the effective start date of the
1062: -- assignment is between start date active and end date active
1063: -- in hr_lookups.
1064: --
1065: if hr_api.not_exists_in_dt_hr_lookups
1066: (p_effective_date => p_effective_date
1067: ,p_validation_start_date => p_validation_start_date
1068: ,p_validation_end_date => p_validation_end_date
1069: ,p_lookup_type => 'FREQUENCY'

Line 1112: hr_api.mandatory_arg_error

1108: hr_utility.set_location('Entering:'|| l_proc, 1);
1109: --
1110: -- Check mandatory parameters have been set
1111: --
1112: hr_api.mandatory_arg_error
1113: (p_api_name => l_proc
1114: ,p_argument => 'effective_date'
1115: ,p_argument_value => p_effective_date
1116: );

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

1127: hr_utility.set_location(l_proc, 2);
1128: --
1129: if ((l_api_updating and
1130: nvl(per_asg_shd.g_old_rec.perf_review_period,
1131: hr_api.g_number) <> nvl(p_perf_review_period,
1132: hr_api.g_number))
1133: or (NOT l_api_updating))
1134: then
1135: --

Line 1132: hr_api.g_number))

1128: --
1129: if ((l_api_updating and
1130: nvl(per_asg_shd.g_old_rec.perf_review_period,
1131: hr_api.g_number) <> nvl(p_perf_review_period,
1132: hr_api.g_number))
1133: or (NOT l_api_updating))
1134: then
1135: --
1136: hr_utility.set_location(l_proc, 3);

Line 1197: hr_api.mandatory_arg_error

1193: ) then
1194: --
1195: -- Check mandatory parameters have been set
1196: --
1197: hr_api.mandatory_arg_error
1198: (p_api_name => l_proc
1199: ,p_argument => 'effective_date'
1200: ,p_argument_value => p_effective_date
1201: );

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

1214: --
1215: if ((l_api_updating)
1216: and
1217: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1218: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1219: or
1220: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1221: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))
1222: or

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

1217: ((nvl(per_asg_shd.g_old_rec.perf_review_period_frequency,
1218: hr_api.g_varchar2) <> nvl(p_perf_review_period_frequency, hr_api.g_varchar2))
1219: or
1220: (nvl(per_asg_shd.g_old_rec.perf_review_period,
1221: hr_api.g_number) <> nvl(p_perf_review_period, hr_api.g_number)))
1222: or
1223: (NOT l_api_updating)) then
1224: --
1225: hr_utility.set_location(l_proc, 2);

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

1288: from per_periods_of_service
1289: where period_of_service_id = p_period_of_service_id
1290: and p_validation_start_date
1291: between date_start
1292: and nvl(actual_termination_date, hr_api.g_eot);
1293: --
1294: begin
1295: hr_utility.set_location('Entering:'|| l_proc, 10);
1296: --

Line 1299: hr_api.mandatory_arg_error

1295: hr_utility.set_location('Entering:'|| l_proc, 10);
1296: --
1297: -- Check mandatory parameters have been set
1298: --
1299: hr_api.mandatory_arg_error
1300: (p_api_name => l_proc
1301: ,p_argument => 'person_id'
1302: ,p_argument_value => p_person_id
1303: );

Line 1305: hr_api.mandatory_arg_error

1301: ,p_argument => 'person_id'
1302: ,p_argument_value => p_person_id
1303: );
1304: --
1305: hr_api.mandatory_arg_error
1306: (p_api_name => l_proc
1307: ,p_argument => 'validation_start_date'
1308: ,p_argument_value => p_validation_start_date
1309: );

Line 1311: hr_api.mandatory_arg_error

1307: ,p_argument => 'validation_start_date'
1308: ,p_argument_value => p_validation_start_date
1309: );
1310: --
1311: hr_api.mandatory_arg_error
1312: (p_api_name => l_proc
1313: ,p_argument => 'validation_end_date'
1314: ,p_argument_value => p_validation_end_date
1315: );

Line 1317: hr_api.mandatory_arg_error

1313: ,p_argument => 'validation_end_date'
1314: ,p_argument_value => p_validation_end_date
1315: );
1316: --
1317: hr_api.mandatory_arg_error
1318: (p_api_name => l_proc
1319: ,p_argument => 'validation_end_date'
1320: ,p_argument_value => p_effective_date
1321: );

Line 1359: hr_api.mandatory_arg_error

1355: --
1356: -- Check the mandatory parameter period of service for
1357: -- an employee.
1358: --
1359: hr_api.mandatory_arg_error
1360: (p_api_name => l_proc
1361: ,p_argument => 'period_of_service_id'
1362: ,p_argument_value => p_period_of_service_id
1363: );

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

1396: --
1397: -- Check if the period of service has been closed before the
1398: -- validation end date.
1399: --
1400: If p_validation_end_date > nvl(l_actual_termination_date, hr_api.g_eot) then
1401: --
1402: hr_utility.set_message(801, 'HR_6434_EMP_ASS_PER_CLOSED');
1403: hr_multi_message.add
1404: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERIOD_OF_SERVICE_ID'

Line 1446: hr_api.mandatory_arg_error

1442: hr_utility.set_location('Entering:'|| l_proc, 1);
1443: --
1444: -- Check mandatory parameters have been set
1445: --
1446: hr_api.mandatory_arg_error
1447: (p_api_name => l_proc
1448: ,p_argument => 'person_id'
1449: ,p_argument_value => p_person_id
1450: );

Line 1515: hr_api.mandatory_arg_error

1511: hr_utility.set_location('Entering:'|| l_proc, 10);
1512: --
1513: -- Check mandatory parameters have been set
1514: --
1515: hr_api.mandatory_arg_error
1516: (p_api_name => l_proc
1517: ,p_argument => 'effective_date'
1518: ,p_argument_value => p_effective_date
1519: );

Line 1521: hr_api.mandatory_arg_error

1517: ,p_argument => 'effective_date'
1518: ,p_argument_value => p_effective_date
1519: );
1520: --
1521: hr_api.mandatory_arg_error
1522: (p_api_name => l_proc
1523: ,p_argument => 'validation_start_date'
1524: ,p_argument_value => p_validation_start_date
1525: );

Line 1527: hr_api.mandatory_arg_error

1523: ,p_argument => 'validation_start_date'
1524: ,p_argument_value => p_validation_start_date
1525: );
1526: --
1527: hr_api.mandatory_arg_error
1528: (p_api_name => l_proc
1529: ,p_argument => 'validation_end_date'
1530: ,p_argument_value => p_validation_end_date
1531: );

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

1542: ,p_object_version_number => p_object_version_number);
1543: hr_utility.set_location(l_proc, 30);
1544: --
1545: if ((l_api_updating and
1546: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)
1547: <> nvl(p_person_referred_by_id, hr_api.g_number)) or
1548: (NOT l_api_updating)) then
1549: hr_utility.set_location(l_proc, 40);
1550: --

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

1543: hr_utility.set_location(l_proc, 30);
1544: --
1545: if ((l_api_updating and
1546: nvl(per_asg_shd.g_old_rec.person_referred_by_id, hr_api.g_number)
1547: <> nvl(p_person_referred_by_id, hr_api.g_number)) or
1548: (NOT l_api_updating)) then
1549: hr_utility.set_location(l_proc, 40);
1550: --
1551: -- Check if person referred by is not null

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

1627: -- Bug 3190625
1628: -- Condition to check profile value also added
1629: -- If he is an employee or a contingent worker with the profile set,
1630: -- no errors shown
1631: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
1632: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
1633: nvl(l_current_npw_flag, 'N') = 'Y') ) then
1634: hr_utility.set_message(801, 'HR_51305_ASG_PER_RB_NOT_EMP');
1635: hr_multi_message.add

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

1680: between hp.effective_start_date
1681: and hp.effective_end_date
1682: and p_validation_start_date
1683: between hp.date_effective
1684: and nvl(hp.date_end, hr_api.g_eot)
1685: and ps.shared_type_id = hp.availability_status_id
1686: and ps.system_type_cd = 'ACTIVE' ;
1687: --
1688: begin

Line 1694: hr_api.mandatory_arg_error

1690: --
1691: --
1692: -- Check mandatory parameters have been set
1693: --
1694: hr_api.mandatory_arg_error
1695: (p_api_name => l_proc
1696: ,p_argument => 'effective_date'
1697: ,p_argument_value => p_effective_date
1698: );

Line 1700: hr_api.mandatory_arg_error

1696: ,p_argument => 'effective_date'
1697: ,p_argument_value => p_effective_date
1698: );
1699: --
1700: hr_api.mandatory_arg_error
1701: (p_api_name => l_proc
1702: ,p_argument => 'validation_start_date'
1703: ,p_argument_value => p_validation_start_date
1704: );

Line 1706: hr_api.mandatory_arg_error

1702: ,p_argument => 'validation_start_date'
1703: ,p_argument_value => p_validation_start_date
1704: );
1705: --
1706: hr_api.mandatory_arg_error
1707: (p_api_name => l_proc
1708: ,p_argument => 'validation_end_date'
1709: ,p_argument_value => p_validation_end_date
1710: );

Line 1712: hr_api.mandatory_arg_error

1708: ,p_argument => 'validation_end_date'
1709: ,p_argument_value => p_validation_end_date
1710: );
1711: --
1712: hr_api.mandatory_arg_error
1713: (p_api_name => l_proc
1714: ,p_argument => 'business_group_id'
1715: ,p_argument_value => p_business_group_id
1716: );

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

1726: ,p_object_version_number => p_object_version_number);
1727: --
1728: if ((l_api_updating
1729: and
1730: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1731: nvl(p_position_id, hr_api.g_number))
1732: or
1733: (NOT l_api_updating)) then
1734: hr_utility.set_location(l_proc, 30);

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

1727: --
1728: if ((l_api_updating
1729: and
1730: nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1731: nvl(p_position_id, hr_api.g_number))
1732: or
1733: (NOT l_api_updating)) then
1734: hr_utility.set_location(l_proc, 30);
1735: --

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

1805: from per_valid_grades
1806: where position_id = p_position_id
1807: and p_validation_start_date
1808: between date_from
1809: and nvl(date_to, hr_api.g_eot);
1810: --
1811: -- Bug 3566686 Ends Here
1812: --
1813: cursor csr_valid_pos_val_grd is

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

1816: where position_id = p_position_id
1817: and grade_id = p_grade_id
1818: and p_validation_start_date
1819: between date_from
1820: and nvl(date_to, hr_api.g_eot);
1821: --
1822: begin
1823: --
1824: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 1833: hr_api.mandatory_arg_error

1829: ) then
1830: --
1831: -- Check mandatory parameters have been set
1832: --
1833: hr_api.mandatory_arg_error
1834: (p_api_name => l_proc
1835: ,p_argument => 'validation_start_date'
1836: ,p_argument_value => p_validation_start_date
1837: );

Line 1839: hr_api.mandatory_arg_error

1835: ,p_argument => 'validation_start_date'
1836: ,p_argument_value => p_validation_start_date
1837: );
1838: --
1839: hr_api.mandatory_arg_error
1840: (p_api_name => l_proc
1841: ,p_argument => 'validation_end_date'
1842: ,p_argument_value => p_validation_end_date
1843: );

Line 1845: hr_api.mandatory_arg_error

1841: ,p_argument => 'validation_end_date'
1842: ,p_argument_value => p_validation_end_date
1843: );
1844: --
1845: hr_api.mandatory_arg_error
1846: (p_api_name => l_proc
1847: ,p_argument => 'effective_date'
1848: ,p_argument_value => p_effective_date
1849: );

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

1857: ,p_effective_date => p_effective_date
1858: ,p_object_version_number => p_object_version_number);
1859: --
1860: if (l_api_updating and
1861: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1862: nvl(p_position_id, hr_api.g_number))
1863: or
1864: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1865: nvl(p_grade_id, hr_api.g_number))))

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

1858: ,p_object_version_number => p_object_version_number);
1859: --
1860: if (l_api_updating and
1861: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1862: nvl(p_position_id, hr_api.g_number))
1863: or
1864: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1865: nvl(p_grade_id, hr_api.g_number))))
1866: or

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

1860: if (l_api_updating and
1861: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1862: nvl(p_position_id, hr_api.g_number))
1863: or
1864: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1865: nvl(p_grade_id, hr_api.g_number))))
1866: or
1867: (NOT l_api_updating) then
1868: --

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

1861: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1862: nvl(p_position_id, hr_api.g_number))
1863: or
1864: (nvl(per_asg_shd.g_old_rec.grade_id, hr_api.g_number) <>
1865: nvl(p_grade_id, hr_api.g_number))))
1866: or
1867: (NOT l_api_updating) then
1868: --
1869: hr_utility.set_location(l_proc, 2);

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

1939: and hp.effective_end_date
1940: and hp.organization_id = p_organization_id
1941: and p_validation_start_date
1942: between hp.date_effective
1943: and nvl(hp.date_end, hr_api.g_eot)
1944: and ps.shared_type_id = hp.availability_status_id
1945: and ps.system_type_cd = 'ACTIVE' ;
1946: --
1947: begin

Line 1958: hr_api.mandatory_arg_error

1954: ) then
1955: --
1956: -- Check mandatory parameters have been set
1957: --
1958: hr_api.mandatory_arg_error
1959: (p_api_name => l_proc
1960: ,p_argument => 'validation_start_date'
1961: ,p_argument_value => p_validation_start_date
1962: );

Line 1964: hr_api.mandatory_arg_error

1960: ,p_argument => 'validation_start_date'
1961: ,p_argument_value => p_validation_start_date
1962: );
1963: --
1964: hr_api.mandatory_arg_error
1965: (p_api_name => l_proc
1966: ,p_argument => 'validation_end_date'
1967: ,p_argument_value => p_validation_end_date
1968: );

Line 1970: hr_api.mandatory_arg_error

1966: ,p_argument => 'validation_end_date'
1967: ,p_argument_value => p_validation_end_date
1968: );
1969: --
1970: hr_api.mandatory_arg_error
1971: (p_api_name => l_proc
1972: ,p_argument => 'effective_date'
1973: ,p_argument_value => p_effective_date
1974: );

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

1983: ,p_object_version_number => p_object_version_number);
1984: --
1985:
1986: if (l_api_updating and
1987: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1988: nvl(p_position_id, hr_api.g_number))
1989: or
1990: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1991: nvl(p_organization_id, hr_api.g_number))))

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

1984: --
1985:
1986: if (l_api_updating and
1987: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1988: nvl(p_position_id, hr_api.g_number))
1989: or
1990: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1991: nvl(p_organization_id, hr_api.g_number))))
1992: or

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

1986: if (l_api_updating and
1987: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1988: nvl(p_position_id, hr_api.g_number))
1989: or
1990: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1991: nvl(p_organization_id, hr_api.g_number))))
1992: or
1993: (NOT l_api_updating) then
1994: --

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

1987: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
1988: nvl(p_position_id, hr_api.g_number))
1989: or
1990: (nvl(per_asg_shd.g_old_rec.organization_id, hr_api.g_number) <>
1991: nvl(p_organization_id, hr_api.g_number))))
1992: or
1993: (NOT l_api_updating) then
1994: --
1995: hr_utility.set_location(l_proc, 2);

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

2059: and hp.effective_end_date
2060: and hp.job_id = p_job_id
2061: and p_validation_start_date
2062: between hp.date_effective
2063: and nvl(hp.date_end,hr_api.g_eot)
2064: and ps.shared_type_id = hp.availability_status_id
2065: and ps.system_type_cd = 'ACTIVE' ;
2066: --
2067: begin

Line 2077: hr_api.mandatory_arg_error

2073: ) then
2074: --
2075: -- Check mandatory parameters have been set
2076: --
2077: hr_api.mandatory_arg_error
2078: (p_api_name => l_proc
2079: ,p_argument => 'validation_start_date'
2080: ,p_argument_value => p_validation_start_date
2081: );

Line 2083: hr_api.mandatory_arg_error

2079: ,p_argument => 'validation_start_date'
2080: ,p_argument_value => p_validation_start_date
2081: );
2082: --
2083: hr_api.mandatory_arg_error
2084: (p_api_name => l_proc
2085: ,p_argument => 'validation_end_date'
2086: ,p_argument_value => p_validation_end_date
2087: );

Line 2089: hr_api.mandatory_arg_error

2085: ,p_argument => 'validation_end_date'
2086: ,p_argument_value => p_validation_end_date
2087: );
2088: --
2089: hr_api.mandatory_arg_error
2090: (p_api_name => l_proc
2091: ,p_argument => 'effective_date'
2092: ,p_argument_value => p_effective_date
2093: );

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

2103: ,p_object_version_number => p_object_version_number);
2104: hr_utility.set_location(l_proc, 30);
2105: --
2106: if (l_api_updating and
2107: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2108: nvl(p_position_id, hr_api.g_number))
2109: or
2110: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2111: nvl(p_job_id, hr_api.g_number))))

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

2104: hr_utility.set_location(l_proc, 30);
2105: --
2106: if (l_api_updating and
2107: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2108: nvl(p_position_id, hr_api.g_number))
2109: or
2110: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2111: nvl(p_job_id, hr_api.g_number))))
2112: or

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

2106: if (l_api_updating and
2107: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2108: nvl(p_position_id, hr_api.g_number))
2109: or
2110: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2111: nvl(p_job_id, hr_api.g_number))))
2112: or
2113: (NOT l_api_updating)
2114: then

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

2107: ((nvl(per_asg_shd.g_old_rec.position_id, hr_api.g_number) <>
2108: nvl(p_position_id, hr_api.g_number))
2109: or
2110: (nvl(per_asg_shd.g_old_rec.job_id, hr_api.g_number) <>
2111: nvl(p_job_id, hr_api.g_number))))
2112: or
2113: (NOT l_api_updating)
2114: then
2115: hr_utility.set_location(l_proc, 40);

Line 2280: hr_api.mandatory_arg_error

2276: --
2277: --
2278: -- Check mandatory parameters have been set
2279: --
2280: hr_api.mandatory_arg_error
2281: (p_api_name => l_proc
2282: ,p_argument => 'primary_flag'
2283: ,p_argument_value => p_primary_flag
2284: );

Line 2286: hr_api.mandatory_arg_error

2282: ,p_argument => 'primary_flag'
2283: ,p_argument_value => p_primary_flag
2284: );
2285: --
2286: hr_api.mandatory_arg_error
2287: (p_api_name => l_proc
2288: ,p_argument => 'person_id'
2289: ,p_argument_value => p_person_id
2290: );

Line 2292: hr_api.mandatory_arg_error

2288: ,p_argument => 'person_id'
2289: ,p_argument_value => p_person_id
2290: );
2291: --
2292: hr_api.mandatory_arg_error
2293: (p_api_name => l_proc
2294:
2295: ,p_argument => 'validation_start_date'
2296: ,p_argument_value => p_validation_start_date

Line 2299: hr_api.mandatory_arg_error

2295: ,p_argument => 'validation_start_date'
2296: ,p_argument_value => p_validation_start_date
2297: );
2298: --
2299: hr_api.mandatory_arg_error
2300: (p_api_name => l_proc
2301: ,p_argument => 'validation_end_date'
2302: ,p_argument_value => p_validation_end_date
2303: );

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

2314: --
2315: hr_utility.set_location(l_proc, 30);
2316: --
2317: if ((l_api_updating and
2318: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>
2319: nvl(p_primary_flag, hr_api.g_varchar2)) or
2320: (NOT l_api_updating)) then
2321: --
2322: -- Check if primary flag is either 'Y' or 'N'.

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

2315: hr_utility.set_location(l_proc, 30);
2316: --
2317: if ((l_api_updating and
2318: nvl(per_asg_shd.g_old_rec.primary_flag, hr_api.g_varchar2) <>
2319: nvl(p_primary_flag, hr_api.g_varchar2)) or
2320: (NOT l_api_updating)) then
2321: --
2322: -- Check if primary flag is either 'Y' or 'N'.
2323: --

Line 2357: If p_validation_end_date <> hr_api.g_eot then

2353: hr_utility.set_location(l_proc, 50);
2354: --
2355: -- Check that the effective end date is the end of time
2356: --
2357: If p_validation_end_date <> hr_api.g_eot then
2358: --
2359: hr_utility.set_message(801, 'HR_51323_ASG_INV_PRIM_ASG_EED');
2360: --
2361: hr_multi_message.add

Line 2571: hr_api.mandatory_arg_error

2567: --
2568: begin
2569: hr_utility.set_location('Entering:'|| l_proc, 10);
2570: --
2571: hr_api.mandatory_arg_error
2572: (p_api_name => l_proc
2573: ,p_argument => 'effective_date'
2574: ,p_argument_value => p_effective_date
2575: );

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

2586: );
2587: hr_utility.set_location(l_proc, 30);
2588: --
2589: if ((l_api_updating and
2590: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2591: <> nvl(p_probation_period, hr_api.g_number))
2592: or
2593: (NOT l_api_updating))
2594: then

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

2587: hr_utility.set_location(l_proc, 30);
2588: --
2589: if ((l_api_updating and
2590: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2591: <> nvl(p_probation_period, hr_api.g_number))
2592: or
2593: (NOT l_api_updating))
2594: then
2595: hr_utility.set_location(l_proc, 40);

Line 2647: hr_api.mandatory_arg_error

2643: hr_utility.set_location('Entering:'|| l_proc, 10);
2644: --
2645: -- Check mandatory parameters have been set
2646: --
2647: hr_api.mandatory_arg_error
2648: (p_api_name => l_proc
2649: ,p_argument => 'effective_date'
2650: ,p_argument_value => p_effective_date
2651: );

Line 2653: hr_api.mandatory_arg_error

2649: ,p_argument => 'effective_date'
2650: ,p_argument_value => p_effective_date
2651: );
2652: --
2653: hr_api.mandatory_arg_error
2654: (p_api_name => l_proc
2655: ,p_argument => 'validation_start_date'
2656: ,p_argument_value => p_validation_start_date
2657: );

Line 2659: hr_api.mandatory_arg_error

2655: ,p_argument => 'validation_start_date'
2656: ,p_argument_value => p_validation_start_date
2657: );
2658: --
2659: hr_api.mandatory_arg_error
2660: (p_api_name => l_proc
2661: ,p_argument => 'validation_end_date'
2662: ,p_argument_value => p_validation_end_date
2663: );

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

2674: );
2675: hr_utility.set_location(l_proc, 30);
2676: --
2677: if ((l_api_updating and
2678: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2679: <> nvl(p_probation_unit, hr_api.g_varchar2))
2680: or
2681: (NOT l_api_updating))
2682: then

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

2675: hr_utility.set_location(l_proc, 30);
2676: --
2677: if ((l_api_updating and
2678: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2679: <> nvl(p_probation_unit, hr_api.g_varchar2))
2680: or
2681: (NOT l_api_updating))
2682: then
2683: hr_utility.set_location(l_proc, 40);

Line 2694: if hr_api.not_exists_in_dt_hr_lookups

2690: -- lookup type 'QUALIFYING_UNITS' with an enabled flag set to 'Y'
2691: -- and that the effective start date of the assignment is between
2692: -- start date active and end date active in hr_lookups.
2693: --
2694: if hr_api.not_exists_in_dt_hr_lookups
2695: (p_effective_date => p_effective_date
2696: ,p_validation_start_date => p_validation_start_date
2697: ,p_validation_end_date => p_validation_end_date
2698: ,p_lookup_type => 'QUALIFYING_UNITS'

Line 2749: hr_api.mandatory_arg_error

2745: if hr_multi_message.no_exclusive_error
2746: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2747: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2748: ) then
2749: hr_api.mandatory_arg_error
2750: (p_api_name => l_proc
2751: ,p_argument => 'effective_date'
2752: ,p_argument_value => p_effective_date
2753: );

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

2762: ,p_object_version_number => p_object_version_number);
2763: --
2764: if ((l_api_updating
2765: and
2766: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2767: <> nvl(p_probation_unit, hr_api.g_varchar2)
2768: or
2769: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2770: <> nvl(p_probation_period, hr_api.g_number))

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

2763: --
2764: if ((l_api_updating
2765: and
2766: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2767: <> nvl(p_probation_unit, hr_api.g_varchar2)
2768: or
2769: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2770: <> nvl(p_probation_period, hr_api.g_number))
2771: or

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

2765: and
2766: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2767: <> nvl(p_probation_unit, hr_api.g_varchar2)
2768: or
2769: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2770: <> nvl(p_probation_period, hr_api.g_number))
2771: or
2772: (NOT l_api_updating)) then
2773: --

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

2766: nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2)
2767: <> nvl(p_probation_unit, hr_api.g_varchar2)
2768: or
2769: nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number)
2770: <> nvl(p_probation_period, hr_api.g_number))
2771: or
2772: (NOT l_api_updating)) then
2773: --
2774: hr_utility.set_location(l_proc, 2);

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

2837: from per_all_people_f
2838: where person_id = p_recruiter_id
2839: and p_validation_start_date
2840: between effective_start_date
2841: and nvl(effective_end_date, hr_api.g_eot);
2842: --
2843: begin
2844: hr_utility.set_location('Entering:'|| l_proc, 10);
2845: --

Line 2849: hr_api.mandatory_arg_error

2845: --
2846: --
2847: -- Check mandatory parameters have been set
2848: --
2849: hr_api.mandatory_arg_error
2850: (p_api_name => l_proc
2851: ,p_argument => 'effective_date'
2852: ,p_argument_value => p_effective_date
2853: );

Line 2856: hr_api.mandatory_arg_error

2852: ,p_argument_value => p_effective_date
2853: );
2854: hr_utility.set_location(l_proc, 20);
2855: --
2856: hr_api.mandatory_arg_error
2857: (p_api_name => l_proc
2858: ,p_argument => 'validation_start_date'
2859: ,p_argument_value => p_validation_start_date
2860: );

Line 2863: hr_api.mandatory_arg_error

2859: ,p_argument_value => p_validation_start_date
2860: );
2861: hr_utility.set_location(l_proc, 30);
2862: --
2863: hr_api.mandatory_arg_error
2864: (p_api_name => l_proc
2865: ,p_argument => 'validation_end_date'
2866: ,p_argument_value => p_validation_end_date
2867: );

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

2877: ,p_object_version_number => p_object_version_number);
2878: hr_utility.set_location(l_proc, 50);
2879: --
2880: if ((l_api_updating and
2881: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>
2882: nvl(p_recruiter_id, hr_api.g_number)) or
2883: (NOT l_api_updating)) then
2884: hr_utility.set_location(l_proc, 60);
2885: --

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

2878: hr_utility.set_location(l_proc, 50);
2879: --
2880: if ((l_api_updating and
2881: nvl(per_asg_shd.g_old_rec.recruiter_id, hr_api.g_number) <>
2882: nvl(p_recruiter_id, hr_api.g_number)) or
2883: (NOT l_api_updating)) then
2884: hr_utility.set_location(l_proc, 60);
2885: --
2886: -- Check if recruiter is not null

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

2937: -- Check that the recruiter is an employee.
2938: --
2939: -- Bug 3190625
2940: -- Condition to check profile value also added
2941: if not ( (nvl(l_current_employee_flag,hr_api.g_varchar2) = 'Y' ) or
2942: ( nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y' and
2943: nvl(l_current_npw_flag, 'N') = 'Y') ) then
2944: hr_utility.set_message(801, 'HR_51290_ASG_RECRUIT_NOT_EMP');
2945: hr_multi_message.add

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

2995: from per_recruitment_activities
2996: where recruitment_activity_id = p_recruitment_activity_id
2997: and p_validation_start_date
2998: between date_start
2999: and nvl(date_end, hr_api.g_eot);
3000: --
3001: begin
3002: hr_utility.set_location('Entering:'|| l_proc, 10);
3003: --

Line 3006: hr_api.mandatory_arg_error

3002: hr_utility.set_location('Entering:'|| l_proc, 10);
3003: --
3004: -- Check mandatory parameters have been set
3005: --
3006: hr_api.mandatory_arg_error
3007: (p_api_name => l_proc
3008: ,p_argument => 'effective_date'
3009: ,p_argument_value => p_effective_date
3010: );

Line 3012: hr_api.mandatory_arg_error

3008: ,p_argument => 'effective_date'
3009: ,p_argument_value => p_effective_date
3010: );
3011: --
3012: hr_api.mandatory_arg_error
3013: (p_api_name => l_proc
3014: ,p_argument => 'validation_start_date'
3015: ,p_argument_value => p_validation_start_date
3016: );

Line 3018: hr_api.mandatory_arg_error

3014: ,p_argument => 'validation_start_date'
3015: ,p_argument_value => p_validation_start_date
3016: );
3017: --
3018: hr_api.mandatory_arg_error
3019: (p_api_name => l_proc
3020: ,p_argument => 'validation_end_date'
3021: ,p_argument_value => p_validation_end_date
3022: );

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

3033: );
3034: hr_utility.set_location(l_proc, 30);
3035: --
3036: if ((l_api_updating and
3037: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>
3038: nvl(p_recruitment_activity_id, hr_api.g_number)) or
3039: (NOT l_api_updating))
3040: then
3041: hr_utility.set_location(l_proc, 40);

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

3034: hr_utility.set_location(l_proc, 30);
3035: --
3036: if ((l_api_updating and
3037: nvl(per_asg_shd.g_old_rec.recruitment_activity_id, hr_api.g_number) <>
3038: nvl(p_recruitment_activity_id, hr_api.g_number)) or
3039: (NOT l_api_updating))
3040: then
3041: hr_utility.set_location(l_proc, 40);
3042: --

Line 3450: hr_api.mandatory_arg_error

3446: hr_utility.set_location('Entering:'|| l_proc, 10);
3447: --
3448: -- Check mandatory parameters have been set
3449: --
3450: hr_api.mandatory_arg_error
3451: (p_api_name => l_proc
3452: ,p_argument => 'effective_date'
3453: ,p_argument_value => p_effective_date
3454: );

Line 3456: hr_api.mandatory_arg_error

3452: ,p_argument => 'effective_date'
3453: ,p_argument_value => p_effective_date
3454: );
3455: --
3456: hr_api.mandatory_arg_error
3457: (p_api_name => l_proc
3458: ,p_argument => 'validation_start_date'
3459: ,p_argument_value => p_validation_start_date
3460: );

Line 3462: hr_api.mandatory_arg_error

3458: ,p_argument => 'validation_start_date'
3459: ,p_argument_value => p_validation_start_date
3460: );
3461: --
3462: hr_api.mandatory_arg_error
3463: (p_api_name => l_proc
3464: ,p_argument => 'validation_end_date'
3465: ,p_argument_value => p_validation_end_date
3466: );

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

3478: hr_utility.set_location(l_proc, 30);
3479: --
3480: if ((l_api_updating and
3481: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3482: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,
3483: hr_api.g_varchar2))
3484: or
3485: (NOT l_api_updating))
3486: then

Line 3483: hr_api.g_varchar2))

3479: --
3480: if ((l_api_updating and
3481: nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3482: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency,
3483: hr_api.g_varchar2))
3484: or
3485: (NOT l_api_updating))
3486: then
3487: hr_utility.set_location(l_proc, 40);

Line 3513: if hr_api.not_exists_in_dt_hr_lookups

3509: -- flag set to 'Y' and that the effective start date of the
3510: -- assignment is between start date active and end date active
3511: -- in hr_lookups.
3512: --
3513: if hr_api.not_exists_in_dt_hr_lookups
3514: (p_effective_date => p_effective_date
3515: ,p_validation_start_date => p_validation_start_date
3516: ,p_validation_end_date => p_validation_end_date
3517: ,p_lookup_type => 'FREQUENCY'

Line 3559: hr_api.mandatory_arg_error

3555: hr_utility.set_location('Entering:'|| l_proc, 1);
3556: --
3557: -- Check mandatory parameters have been set
3558: --
3559: hr_api.mandatory_arg_error
3560: (p_api_name => l_proc
3561: ,p_argument => 'effective_date'
3562: ,p_argument_value => p_effective_date
3563: );

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

3574: hr_utility.set_location(l_proc, 2);
3575: --
3576: if ((l_api_updating and
3577: nvl(per_asg_shd.g_old_rec.sal_review_period,
3578: hr_api.g_number) <> nvl(p_sal_review_period,
3579: hr_api.g_number)) or (NOT l_api_updating)) then
3580: --
3581: hr_utility.set_location(l_proc, 3);
3582: --

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

3575: --
3576: if ((l_api_updating and
3577: nvl(per_asg_shd.g_old_rec.sal_review_period,
3578: hr_api.g_number) <> nvl(p_sal_review_period,
3579: hr_api.g_number)) or (NOT l_api_updating)) then
3580: --
3581: hr_utility.set_location(l_proc, 3);
3582: --
3583: -- Check if sal review period is not null

Line 3641: hr_api.mandatory_arg_error

3637: ) then
3638: --
3639: -- Check mandatory parameters have been set
3640: --
3641: hr_api.mandatory_arg_error
3642: (p_api_name => l_proc
3643: ,p_argument => 'effective_date'
3644: ,p_argument_value => p_effective_date
3645: );

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

3654: ,p_effective_date => p_effective_date
3655: ,p_object_version_number => p_object_version_number);
3656: --
3657: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3658: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3659: or
3660: nvl(per_asg_shd.g_old_rec.sal_review_period,
3661: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))
3662: or

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

3657: if ((l_api_updating and nvl(per_asg_shd.g_old_rec.sal_review_period_frequency,
3658: hr_api.g_varchar2) <> nvl(p_sal_review_period_frequency, hr_api.g_varchar2)
3659: or
3660: nvl(per_asg_shd.g_old_rec.sal_review_period,
3661: hr_api.g_number) <> nvl(p_sal_review_period, hr_api.g_number))
3662: or
3663: (NOT l_api_updating)) then
3664: --
3665: hr_utility.set_location(l_proc, 2);

Line 3738: hr_api.mandatory_arg_error

3734: hr_utility.set_location('Entering:'|| l_proc, 10);
3735: --
3736: -- Check mandatory parameters have been set
3737: --
3738: hr_api.mandatory_arg_error
3739: (p_api_name => l_proc
3740: ,p_argument => 'effective_date'
3741: ,p_argument_value => p_effective_date
3742: );

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

3754: hr_utility.set_location(l_proc, 30);
3755: --
3756: if ((l_api_updating and
3757: nvl(per_asg_shd.g_old_rec.set_of_books_id,
3758: hr_api.g_number) <> nvl(p_set_of_books_id, hr_api.g_number)) or
3759: (NOT l_api_updating))
3760: then
3761: hr_utility.set_location(l_proc, 40);
3762: --

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

3846: from hr_soft_coding_keyflex
3847: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
3848: and enabled_flag = 'Y'
3849: and p_validation_start_date
3850: between nvl(start_date_active,hr_api.g_sot)
3851: and nvl(end_date_active,hr_api.g_eot);
3852: --
3853: cursor csr_bg is
3854: select legislation_code

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

3847: where soft_coding_keyflex_id = p_soft_coding_keyflex_id
3848: and enabled_flag = 'Y'
3849: and p_validation_start_date
3850: between nvl(start_date_active,hr_api.g_sot)
3851: and nvl(end_date_active,hr_api.g_eot);
3852: --
3853: cursor csr_bg is
3854: select legislation_code
3855: from per_business_groups_perf

Line 3875: hr_api.mandatory_arg_error

3871: hr_utility.set_location('Entering:'|| l_proc, 10);
3872: --
3873: -- Check mandatory parameters have been set
3874: --
3875: hr_api.mandatory_arg_error
3876: (p_api_name => l_proc
3877: ,p_argument => 'effective_date'
3878: ,p_argument_value => p_effective_date
3879: );

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

3891: );
3892: hr_utility.set_location(l_proc, 30);
3893: --
3894: if ((l_api_updating and
3895: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>
3896: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or
3897: --
3898: -- ****** Start new code for bug #2182184 **************************
3899: --

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

3892: hr_utility.set_location(l_proc, 30);
3893: --
3894: if ((l_api_updating and
3895: nvl(per_asg_shd.g_old_rec.soft_coding_keyflex_id, hr_api.g_number) <>
3896: nvl(p_soft_coding_keyflex_id, hr_api.g_number)) or
3897: --
3898: -- ****** Start new code for bug #2182184 **************************
3899: --
3900: (l_api_updating and

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

4009: from per_organization_units
4010: where organization_id = p_source_organization_id
4011: and p_validation_start_date
4012: between date_from
4013: and nvl(date_to, hr_api.g_eot);
4014: --
4015: begin
4016: hr_utility.set_location('Entering:'|| l_proc, 10);
4017: --

Line 4020: hr_api.mandatory_arg_error

4016: hr_utility.set_location('Entering:'|| l_proc, 10);
4017: --
4018: -- Check mandatory parameters have been set
4019: --
4020: hr_api.mandatory_arg_error
4021: (p_api_name => l_proc
4022: ,p_argument => 'effective_date'
4023: ,p_argument_value => p_effective_date
4024: );

Line 4026: hr_api.mandatory_arg_error

4022: ,p_argument => 'effective_date'
4023: ,p_argument_value => p_effective_date
4024: );
4025: --
4026: hr_api.mandatory_arg_error
4027: (p_api_name => l_proc
4028: ,p_argument => 'validation_start_date'
4029: ,p_argument_value => p_validation_start_date
4030: );

Line 4032: hr_api.mandatory_arg_error

4028: ,p_argument => 'validation_start_date'
4029: ,p_argument_value => p_validation_start_date
4030: );
4031: --
4032: hr_api.mandatory_arg_error
4033: (p_api_name => l_proc
4034: ,p_argument => 'validation_end_date'
4035: ,p_argument_value => p_validation_end_date
4036: );

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

4047: );
4048: hr_utility.set_location(l_proc, 30);
4049: --
4050: if ((l_api_updating
4051: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)
4052: <> nvl(p_source_organization_id, hr_api.g_number))
4053: or
4054: (NOT l_api_updating))
4055: then

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

4048: hr_utility.set_location(l_proc, 30);
4049: --
4050: if ((l_api_updating
4051: and nvl(per_asg_shd.g_old_rec.source_organization_id, hr_api.g_number)
4052: <> nvl(p_source_organization_id, hr_api.g_number))
4053: or
4054: (NOT l_api_updating))
4055: then
4056: hr_utility.set_location(l_proc, 40);

Line 4157: hr_api.mandatory_arg_error

4153: hr_utility.set_location('Entering:'|| l_proc, 10);
4154: --
4155: -- Check mandatory parameters have been set
4156: --
4157: hr_api.mandatory_arg_error
4158: (p_api_name => l_proc
4159: ,p_argument => 'effective_date'
4160: ,p_argument_value => p_effective_date
4161: );

Line 4162: hr_api.mandatory_arg_error

4158: (p_api_name => l_proc
4159: ,p_argument => 'effective_date'
4160: ,p_argument_value => p_effective_date
4161: );
4162: hr_api.mandatory_arg_error
4163: (p_api_name => l_proc
4164: ,p_argument => 'validation_start_date'
4165: ,p_argument_value => p_validation_start_date
4166: );

Line 4168: hr_api.mandatory_arg_error

4164: ,p_argument => 'validation_start_date'
4165: ,p_argument_value => p_validation_start_date
4166: );
4167: --
4168: hr_api.mandatory_arg_error
4169: (p_api_name => l_proc
4170: ,p_argument => 'validation_end_date'
4171: ,p_argument_value => p_validation_end_date
4172: );

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

4183: );
4184: hr_utility.set_location(l_proc, 30);
4185: --
4186: if ((l_api_updating and
4187: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>
4188: nvl(p_source_type, hr_api.g_varchar2))
4189: or (NOT l_api_updating))
4190: then
4191: hr_utility.set_location(l_proc, 40);

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

4184: hr_utility.set_location(l_proc, 30);
4185: --
4186: if ((l_api_updating and
4187: nvl(per_asg_shd.g_old_rec.source_type, hr_api.g_varchar2) <>
4188: nvl(p_source_type, hr_api.g_varchar2))
4189: or (NOT l_api_updating))
4190: then
4191: hr_utility.set_location(l_proc, 40);
4192: --

Line 4202: if hr_api.not_exists_in_dt_hr_lookups

4198: -- type 'REC_TYPE' with an enabled flag set to 'Y' and that the
4199: -- effective start date of the assignment is between start date
4200: -- active and end date active in hr_lookups.
4201: --
4202: if hr_api.not_exists_in_dt_hr_lookups
4203: (p_effective_date => p_effective_date
4204: ,p_validation_start_date => p_validation_start_date
4205: ,p_validation_end_date => p_validation_end_date
4206: ,p_lookup_type => 'REC_TYPE'

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

4227: fetch csr_get_rec_act_type into l_rec_act_type;
4228: close csr_get_rec_act_type;
4229: hr_utility.set_location(l_proc, 60);
4230: --
4231: If p_source_type <> nvl(l_rec_act_type, hr_api.g_varchar2) then
4232: --
4233: hr_utility.set_message(801, 'HR_51325_ASG_INV_SOU_TYP_RAT');
4234: hr_multi_message.add
4235: (p_associated_column1 =>

Line 4336: hr_api.mandatory_arg_error

4332: --
4333: --
4334: -- Check mandatory parameters have been set
4335: --
4336: hr_api.mandatory_arg_error
4337: (p_api_name => l_proc
4338: ,p_argument => 'validation_start_date'
4339: ,p_argument_value => p_validation_start_date
4340: );

Line 4342: hr_api.mandatory_arg_error

4338: ,p_argument => 'validation_start_date'
4339: ,p_argument_value => p_validation_start_date
4340: );
4341: --
4342: hr_api.mandatory_arg_error
4343: (p_api_name => l_proc
4344: ,p_argument => 'validation_end_date'
4345: ,p_argument_value => p_validation_end_date
4346: );

Line 4348: hr_api.mandatory_arg_error

4344: ,p_argument => 'validation_end_date'
4345: ,p_argument_value => p_validation_end_date
4346: );
4347: --
4348: hr_api.mandatory_arg_error
4349: (p_api_name => l_proc
4350: ,p_argument => 'effective_date'
4351: ,p_argument_value => p_effective_date
4352: );

Line 4354: hr_api.mandatory_arg_error

4350: ,p_argument => 'effective_date'
4351: ,p_argument_value => p_effective_date
4352: );
4353: --
4354: hr_api.mandatory_arg_error
4355: (p_api_name => l_proc
4356: ,p_argument => 'business_group_id'
4357: ,p_argument_value => p_business_group_id
4358: );

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

4369: );
4370: hr_utility.set_location(l_proc, 30);
4371: --
4372: if ((l_api_updating and
4373: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>
4374: nvl(p_special_ceiling_step_id, hr_api.g_number)) or
4375: (NOT l_api_updating)) then
4376: hr_utility.set_location(l_proc, 40);
4377: --

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

4370: hr_utility.set_location(l_proc, 30);
4371: --
4372: if ((l_api_updating and
4373: nvl(per_asg_shd.g_old_rec.special_ceiling_step_id, hr_api.g_number) <>
4374: nvl(p_special_ceiling_step_id, hr_api.g_number)) or
4375: (NOT l_api_updating)) then
4376: hr_utility.set_location(l_proc, 40);
4377: --
4378: if p_special_ceiling_step_id is not null then

Line 4571: hr_api.mandatory_arg_error

4567: ) then
4568: --
4569: -- Check mandatory parameters have been set
4570: --
4571: hr_api.mandatory_arg_error
4572: (p_api_name => l_proc
4573: ,p_argument => 'person_id'
4574: ,p_argument_value => p_person_id
4575: );

Line 4577: hr_api.mandatory_arg_error

4573: ,p_argument => 'person_id'
4574: ,p_argument_value => p_person_id
4575: );
4576: --
4577: hr_api.mandatory_arg_error
4578: (p_api_name => l_proc
4579: ,p_argument => 'business_group_id'
4580: ,p_argument_value => p_business_group_id
4581: );

Line 4583: hr_api.mandatory_arg_error

4579: ,p_argument => 'business_group_id'
4580: ,p_argument_value => p_business_group_id
4581: );
4582: --
4583: hr_api.mandatory_arg_error
4584: (p_api_name => l_proc
4585: ,p_argument => 'validation_start_date'
4586: ,p_argument_value => p_validation_start_date
4587: );

Line 4589: hr_api.mandatory_arg_error

4585: ,p_argument => 'validation_start_date'
4586: ,p_argument_value => p_validation_start_date
4587: );
4588: --
4589: hr_api.mandatory_arg_error
4590: (p_api_name => l_proc
4591: ,p_argument => 'effective_date'
4592: ,p_argument_value => p_effective_date
4593: );

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

4604: );
4605: hr_utility.set_location(l_proc, 30);
4606: --
4607: if ((l_api_updating and
4608: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4609: nvl(p_supervisor_id, hr_api.g_number)) or
4610: (NOT l_api_updating))
4611: then
4612: hr_utility.set_location(l_proc, 40);

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

4605: hr_utility.set_location(l_proc, 30);
4606: --
4607: if ((l_api_updating and
4608: nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4609: nvl(p_supervisor_id, hr_api.g_number)) or
4610: (NOT l_api_updating))
4611: then
4612: hr_utility.set_location(l_proc, 40);
4613: --

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

4710: --
4711: -- Check that the supervisor is an employee or a contingent
4712: -- worker where the profile option permits.
4713: --
4714: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'
4715: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and
4716: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4717: Then
4718: --Bug3917021

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

4711: -- Check that the supervisor is an employee or a contingent
4712: -- worker where the profile option permits.
4713: --
4714: If not (nvl(l_current_employee_flag, hr_api.g_varchar2) = 'Y'
4715: or (nvl(l_current_npw_flag, hr_api.g_varchar2) = 'Y' and
4716: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4717: Then
4718: --Bug3917021
4719: if csr_asg_typ%isopen then

Line 4781: hr_api.mandatory_arg_error

4777: ) then
4778: --
4779: -- Check mandatory parameters have been set
4780: --
4781: hr_api.mandatory_arg_error
4782: (p_api_name => l_proc
4783: ,p_argument => 'validation_start_date'
4784: ,p_argument_value => p_validation_start_date
4785: );

Line 4787: hr_api.mandatory_arg_error

4783: ,p_argument => 'validation_start_date'
4784: ,p_argument_value => p_validation_start_date
4785: );
4786: --
4787: hr_api.mandatory_arg_error
4788: (p_api_name => l_proc
4789: ,p_argument => 'effective_date'
4790: ,p_argument_value => p_effective_date
4791: );

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

4806: -- Re-validate if either the supervisor or supervisor assignment
4807: -- has changed.
4808: --
4809: if (l_api_updating and
4810: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4811: nvl(p_supervisor_id, hr_api.g_number))
4812: or
4813: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4814: nvl(p_supervisor_assignment_id, hr_api.g_number))) or

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

4807: -- has changed.
4808: --
4809: if (l_api_updating and
4810: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4811: nvl(p_supervisor_id, hr_api.g_number))
4812: or
4813: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4814: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4815: (NOT l_api_updating))

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

4809: if (l_api_updating and
4810: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4811: nvl(p_supervisor_id, hr_api.g_number))
4812: or
4813: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4814: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4815: (NOT l_api_updating))
4816: then
4817:

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

4810: ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4811: nvl(p_supervisor_id, hr_api.g_number))
4812: or
4813: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) <>
4814: nvl(p_supervisor_assignment_id, hr_api.g_number))) or
4815: (NOT l_api_updating))
4816: then
4817:
4818: hr_utility.set_location(l_proc, 40);

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

4816: then
4817:
4818: hr_utility.set_location(l_proc, 40);
4819: ----
4820: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4821: nvl(p_supervisor_id, hr_api.g_number))
4822: and
4823: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4824: nvl(p_supervisor_assignment_id, hr_api.g_number))) then

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

4817:
4818: hr_utility.set_location(l_proc, 40);
4819: ----
4820: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4821: nvl(p_supervisor_id, hr_api.g_number))
4822: and
4823: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4824: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4825: p_supervisor_assignment_id := NULL;

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

4819: ----
4820: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4821: nvl(p_supervisor_id, hr_api.g_number))
4822: and
4823: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4824: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4825: p_supervisor_assignment_id := NULL;
4826: end if;
4827: ---

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

4820: if ((nvl(per_asg_shd.g_old_rec.supervisor_id, hr_api.g_number) <>
4821: nvl(p_supervisor_id, hr_api.g_number))
4822: and
4823: (nvl(per_asg_shd.g_old_rec.supervisor_assignment_id, hr_api.g_number) =
4824: nvl(p_supervisor_assignment_id, hr_api.g_number))) then
4825: p_supervisor_assignment_id := NULL;
4826: end if;
4827: ---
4828:

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

4864: --
4865: -- Check that the supervisor assignment is an employee or a contingent
4866: -- worker assignment.
4867: --
4868: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'
4869: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and
4870: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4871: Then
4872: --

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

4865: -- Check that the supervisor assignment is an employee or a contingent
4866: -- worker assignment.
4867: --
4868: If not (nvl(l_assignment_type, hr_api.g_varchar2) = 'E'
4869: or (nvl(l_assignment_type, hr_api.g_varchar2) = 'C' and
4870: nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'), 'N') = 'Y'))
4871: Then
4872: --
4873: hr_utility.set_location(l_proc, 80);

Line 4936: hr_api.mandatory_arg_error

4932: hr_utility.set_location('Entering:'|| l_proc, 1);
4933: --
4934: -- Check mandatory parameters have been set
4935: --
4936: hr_api.mandatory_arg_error
4937: (p_api_name => l_proc
4938: ,p_argument => 'person_id'
4939: ,p_argument_value => p_person_id
4940: );

Line 4942: hr_api.mandatory_arg_error

4938: ,p_argument => 'person_id'
4939: ,p_argument_value => p_person_id
4940: );
4941: --
4942: hr_api.mandatory_arg_error
4943: (p_api_name => l_proc
4944: ,p_argument => 'validation_start_date'
4945: ,p_argument_value => p_validation_start_date
4946: );

Line 4948: hr_api.mandatory_arg_error

4944: ,p_argument => 'validation_start_date'
4945: ,p_argument_value => p_validation_start_date
4946: );
4947: --
4948: hr_api.mandatory_arg_error
4949: (p_api_name => l_proc
4950: ,p_argument => 'validation_end_date'
4951: ,p_argument_value => p_validation_end_date
4952: );

Line 5216: ,p_validation_end_date => hr_api.g_eot

5212: ,p_effective_date => p_effective_date
5213: ,p_assignment_type => p_assignment_type
5214: ,p_assignment_id => Null
5215: ,p_validation_start_date => p_effective_date
5216: ,p_validation_end_date => hr_api.g_eot
5217: ,p_datetrack_mode => 'INSERT'
5218: );
5219:
5220: hr_utility.set_location('Leaving: old'|| l_proc, 100);

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

5408: from per_vacancies
5409: where vacancy_id = p_vacancy_id
5410: and p_validation_start_date
5411: between date_from
5412: and nvl(date_to, hr_api.g_eot);
5413: --
5414: cursor csr_val_vacancy_id_offer is
5415: select business_group_id
5416: from per_vacancies

Line 5424: hr_api.mandatory_arg_error

5420: hr_utility.set_location('Entering:'|| l_proc, 10);
5421: --
5422: -- Check mandatory parameters have been set
5423: --
5424: hr_api.mandatory_arg_error
5425: (p_api_name => l_proc
5426: ,p_argument => 'effective_date'
5427: ,p_argument_value => p_effective_date
5428: );

Line 5430: hr_api.mandatory_arg_error

5426: ,p_argument => 'effective_date'
5427: ,p_argument_value => p_effective_date
5428: );
5429: --
5430: hr_api.mandatory_arg_error
5431: (p_api_name => l_proc
5432: ,p_argument => 'validation_start_date'
5433: ,p_argument_value => p_validation_start_date
5434: );

Line 5436: hr_api.mandatory_arg_error

5432: ,p_argument => 'validation_start_date'
5433: ,p_argument_value => p_validation_start_date
5434: );
5435: --
5436: hr_api.mandatory_arg_error
5437: (p_api_name => l_proc
5438: ,p_argument => 'validation_end_date'
5439: ,p_argument_value => p_validation_end_date
5440: );

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

5451: );
5452: hr_utility.set_location(l_proc, 30);
5453: --
5454: if ((l_api_updating and
5455: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>
5456: nvl(p_vacancy_id, hr_api.g_number)) or
5457: (NOT l_api_updating)) then
5458: hr_utility.set_location(l_proc, 40);
5459: --

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

5452: hr_utility.set_location(l_proc, 30);
5453: --
5454: if ((l_api_updating and
5455: nvl(per_asg_shd.g_old_rec.vacancy_id, hr_api.g_number) <>
5456: nvl(p_vacancy_id, hr_api.g_number)) or
5457: (NOT l_api_updating)) then
5458: hr_utility.set_location(l_proc, 40);
5459: --
5460: -- Check if vacancy is not null

Line 5581: hr_api.mandatory_arg_error

5577: ) then
5578: --
5579: -- Check mandatory parameters have been set
5580: --
5581: hr_api.mandatory_arg_error
5582: (p_api_name => l_proc
5583: ,p_argument => 'assignment_type'
5584: ,p_argument_value => p_assignment_type
5585: );

Line 5587: hr_api.mandatory_arg_error

5583: ,p_argument => 'assignment_type'
5584: ,p_argument_value => p_assignment_type
5585: );
5586: --
5587: hr_api.mandatory_arg_error
5588: (p_api_name => l_proc
5589: ,p_argument => 'person_id'
5590: ,p_argument_value => p_person_id
5591: );

Line 5660: hr_api.mandatory_arg_error

5656: hr_utility.set_location('Entering:'|| l_proc, 1);
5657: --
5658: -- Check mandatory parameters have been set
5659: --
5660: hr_api.mandatory_arg_error
5661: (p_api_name => l_proc
5662: ,p_argument => 'organization_id'
5663: ,p_argument_value => p_organization_id
5664: );

Line 5666: hr_api.mandatory_arg_error

5662: ,p_argument => 'organization_id'
5663: ,p_argument_value => p_organization_id
5664: );
5665: --
5666: hr_api.mandatory_arg_error
5667: (p_api_name => l_proc
5668: ,p_argument => 'effective_date'
5669: ,p_argument_value => p_effective_date
5670: );

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

5670: );
5671: --
5672: -- Assigment_id will be NULL on insert, so set to default value.
5673: --
5674: l_assignment_id := nvl(p_assignment_id, hr_api.g_number);
5675: --
5676: -- Check whether another current assignment exists in the same
5677: -- organization with manager flag set to 'Y'.
5678: --

Line 5714: hr_api.mandatory_arg_error

5710: hr_utility.set_location('Entering:'|| l_proc, 10);
5711: --
5712: -- Check mandatory parameters have been set
5713: --
5714: hr_api.mandatory_arg_error
5715: (p_api_name => l_proc
5716: ,p_argument => 'effective_date'
5717: ,p_argument_value => p_effective_date
5718: );

Line 5720: hr_api.mandatory_arg_error

5716: ,p_argument => 'effective_date'
5717: ,p_argument_value => p_effective_date
5718: );
5719: --
5720: hr_api.mandatory_arg_error
5721: (p_api_name => l_proc
5722: ,p_argument => 'validation_start_date'
5723: ,p_argument_value => p_validation_start_date
5724: );

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

5738: --
5739: if NOT l_api_updating
5740: or
5741: (l_api_updating and
5742: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5743: nvl(p_date_probation_end, hr_api.g_date))
5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))

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

5739: if NOT l_api_updating
5740: or
5741: (l_api_updating and
5742: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5743: nvl(p_date_probation_end, hr_api.g_date))
5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or

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

5741: (l_api_updating and
5742: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5743: nvl(p_date_probation_end, hr_api.g_date))
5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or
5748: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5749: nvl(p_probation_period, hr_api.g_number))))

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

5742: ((nvl(per_asg_shd.g_old_rec.date_probation_end, hr_api.g_date) <>
5743: nvl(p_date_probation_end, hr_api.g_date))
5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or
5748: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5749: nvl(p_probation_period, hr_api.g_number))))
5750: then

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

5744: or
5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or
5748: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5749: nvl(p_probation_period, hr_api.g_number))))
5750: then
5751: hr_utility.set_location(l_proc, 40);
5752: --

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

5745: (nvl(per_asg_shd.g_old_rec.probation_unit, hr_api.g_varchar2) <>
5746: nvl(p_probation_unit, hr_api.g_varchar2))
5747: or
5748: (nvl(per_asg_shd.g_old_rec.probation_period, hr_api.g_number) <>
5749: nvl(p_probation_period, hr_api.g_number))))
5750: then
5751: hr_utility.set_location(l_proc, 40);
5752: --
5753: -- Check if probation unit and probation period are both not null.

Line 5826: hr_api.mandatory_arg_error

5822: hr_utility.set_location('Entering:'|| l_proc, 10);
5823: --
5824: -- Check mandatory parameters have been set
5825: --
5826: hr_api.mandatory_arg_error
5827: (p_api_name => l_proc
5828: ,p_argument => 'effective_date'
5829: ,p_argument_value => p_effective_date
5830: );

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

5840: ,p_object_version_number => p_object_version_number);
5841: hr_utility.set_location(l_proc, 30);
5842: --
5843: if ((l_api_updating and
5844: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)
5845: <> nvl(p_internal_address_line, hr_api.g_varchar2))
5846: or
5847: (NOT l_api_updating)) then
5848: hr_utility.set_location(l_proc, 40);

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

5841: hr_utility.set_location(l_proc, 30);
5842: --
5843: if ((l_api_updating and
5844: nvl(per_asg_shd.g_old_rec.internal_address_line, hr_api.g_varchar2)
5845: <> nvl(p_internal_address_line, hr_api.g_varchar2))
5846: or
5847: (NOT l_api_updating)) then
5848: hr_utility.set_location(l_proc, 40);
5849: --

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

5906: ,p_object_version_number => p_object_version_number
5907: );
5908: --
5909: if ((l_api_updating and
5910: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>
5911: nvl(p_applicant_rank, hr_api.g_number)) or
5912: (NOT l_api_updating)) then
5913:
5914: hr_utility.set_location(l_proc, 20);

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

5907: );
5908: --
5909: if ((l_api_updating and
5910: nvl(per_asg_shd.g_old_rec.applicant_rank, hr_api.g_number) <>
5911: nvl(p_applicant_rank, hr_api.g_number)) or
5912: (NOT l_api_updating)) then
5913:
5914: hr_utility.set_location(l_proc, 20);
5915: --

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

6002: ,p_object_version_number => p_object_version_number
6003: );
6004: --
6005: if ((l_api_updating and
6006: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>
6007: nvl(p_posting_content_id, hr_api.g_number)) or
6008: (NOT l_api_updating)) then
6009:
6010: hr_utility.set_location(l_proc, 20);

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

6003: );
6004: --
6005: if ((l_api_updating and
6006: nvl(per_asg_shd.g_old_rec.posting_content_id, hr_api.g_number) <>
6007: nvl(p_posting_content_id, hr_api.g_number)) or
6008: (NOT l_api_updating)) then
6009:
6010: hr_utility.set_location(l_proc, 20);
6011: --