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

Line 85: hr_api.mandatory_arg_error

81: hr_utility.set_location('Entering:'|| l_proc, 10);
82: --
83: -- Check mandatory parameters have been set
84: --
85: hr_api.mandatory_arg_error
86: (p_api_name => l_proc
87: ,p_argument => 'assignment_id'
88: ,p_argument_value => p_assignment_id
89: );

Line 209: hr_api.mandatory_arg_error

205: hr_utility.set_location('Entering:'|| l_proc, 10);
206: --
207: -- Check mandatory parameters have been set
208: --
209: hr_api.mandatory_arg_error
210: (p_api_name => l_proc
211: ,p_argument => 'assignment_id'
212: ,p_argument_value => p_assignment_id
213: );

Line 215: hr_api.mandatory_arg_error

211: ,p_argument => 'assignment_id'
212: ,p_argument_value => p_assignment_id
213: );
214: --
215: hr_api.mandatory_arg_error
216: (p_api_name => l_proc
217: ,p_argument => 'step_id'
218: ,p_argument_value => p_step_id
219: );

Line 221: hr_api.mandatory_arg_error

217: ,p_argument => 'step_id'
218: ,p_argument_value => p_step_id
219: );
220: --
221: hr_api.mandatory_arg_error
222: (p_api_name => l_proc
223: ,p_argument => 'parent_spine_id'
224: ,p_argument_value => p_parent_spine_id
225: );

Line 348: IF hr_api.not_exists_in_hr_lookups

344: hr_utility.set_location(l_proc, 20);
345: --
346: -- Check that the reason type exists in HR_LOOKUPS
347: --
348: IF hr_api.not_exists_in_hr_lookups
349: (p_effective_date => p_effective_date
350: ,p_lookup_type => 'PLACEMENT_REASON'
351: ,p_lookup_code => p_reason) THEN
352: --

Line 421: hr_api.mandatory_arg_error

417: hr_utility.set_location('Entering:'|| l_proc, 10);
418: --
419: -- Check mandatory parameters have been set
420: --
421: hr_api.mandatory_arg_error
422: (p_api_name => l_proc
423: ,p_argument => 'object_version_number'
424: ,p_argument_value => p_object_version_number
425: );

Line 501: hr_api.mandatory_arg_error

497: hr_utility.set_location('Entering:'|| l_proc, 10);
498: --
499: -- Check mandatory parameters have been set
500: --
501: hr_api.mandatory_arg_error
502: (p_api_name => l_proc
503: ,p_argument => 'auto_increment_flag'
504: ,p_argument_value => p_auto_increment_flag
505: );

Line 772: hr_api.mandatory_arg_error

768: hr_utility.set_location('Placement ID :'|| p_placement_id,10);
769: --
770: -- Check mandatory parameters have been set
771: --
772: hr_api.mandatory_arg_error
773: (p_api_name => l_proc
774: ,p_argument => 'step_id'
775: ,p_argument_value => p_step_id
776: );

Line 778: hr_api.mandatory_arg_error

774: ,p_argument => 'step_id'
775: ,p_argument_value => p_step_id
776: );
777: --
778: hr_api.mandatory_arg_error
779: (p_api_name => l_proc
780: ,p_argument => 'parent_spine_id'
781: ,p_argument_value => p_parent_spine_id
782: );

Line 784: hr_api.mandatory_arg_error

780: ,p_argument => 'parent_spine_id'
781: ,p_argument_value => p_parent_spine_id
782: );
783: --
784: hr_api.mandatory_arg_error
785: (p_api_name => l_proc
786: ,p_argument => 'effective_start_date'
787: ,p_argument_value => p_effective_start_date
788: );

Line 790: hr_api.mandatory_arg_error

786: ,p_argument => 'effective_start_date'
787: ,p_argument_value => p_effective_start_date
788: );
789: --
790: hr_api.mandatory_arg_error
791: (p_api_name => l_proc
792: ,p_argument => 'effective_end_date'
793: ,p_argument_value => p_effective_end_date
794: );

Line 898: l_end_date date := hr_api.g_eot;

894: as
895:
896: -- Define local variables
897: --
898: l_end_date date := hr_api.g_eot;
899: l_grade_id number;
900: l_dummy varchar2(1);
901: l_asg_id number;
902: l_proc varchar2(20) := 'CHK_FUTURE_ASG_CHNG';

Line 954: l_end_date := hr_api.g_eot;

950: open c_next_spp_eed;
951: fetch c_next_spp_eed into l_end_date;
952:
953: if c_next_spp_eed%notfound then
954: l_end_date := hr_api.g_eot;
955: end if;
956: close c_next_spp_eed;
957:
958: if g_debug then

Line 1033: hr_api.mandatory_arg_error

1029: hr_utility.set_location('Entering:'|| l_proc, 10);
1030: --
1031: -- Ensure that all the mandatory parameter are not null
1032: --
1033: hr_api.mandatory_arg_error
1034: (p_api_name => l_proc
1035: ,p_argument => 'placement_id'
1036: ,p_argument_value => p_placement_id
1037: );

Line 1056: hr_api.set_security_group_id

1052: close csr_sec_grp;
1053: --
1054: -- Set the security_group_id in CLIENT_INFO
1055: --
1056: hr_api.set_security_group_id
1057: (p_security_group_id => l_security_group_id
1058: );
1059: --
1060: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1093: hr_api.mandatory_arg_error

1089: hr_utility.set_location('Entering:'|| l_proc, 10);
1090: --
1091: -- Ensure that all the mandatory parameter are not null
1092: --
1093: hr_api.mandatory_arg_error
1094: (p_api_name => l_proc
1095: ,p_argument => 'placement_id'
1096: ,p_argument_value => p_placement_id
1097: );

Line 1099: if ( nvl(per_spp_bus.g_placement_id, hr_api.g_number)

1095: ,p_argument => 'placement_id'
1096: ,p_argument_value => p_placement_id
1097: );
1098: --
1099: if ( nvl(per_spp_bus.g_placement_id, hr_api.g_number)
1100: = p_placement_id) then
1101: --
1102: -- The legislation code has already been found with a previous
1103: -- call to this function. Just return the value in the global

Line 1195: hr_api.argument_changed_error

1191: -- not been updated.
1192: --
1193: EXCEPTION
1194: WHEN l_error THEN
1195: hr_api.argument_changed_error
1196: (p_api_name => l_proc
1197: ,p_argument => l_argument);
1198: WHEN OTHERS THEN
1199: RAISE;

Line 1250: hr_api.mandatory_arg_error

1246: -- Ensure that the p_datetrack_mode argument is not null
1247: --
1248: hr_utility.set_location(' Entering:'||l_proc,10);
1249: --
1250: hr_api.mandatory_arg_error
1251: (p_api_name => l_proc
1252: ,p_argument => 'datetrack_mode'
1253: ,p_argument_value => p_datetrack_mode
1254: );

Line 1260: hr_api.mandatory_arg_error

1256: -- Mode will be valid, as this is checked at the start of the upd.
1257: --
1258: -- Ensure the arguments are not null
1259: --
1260: hr_api.mandatory_arg_error
1261: (p_api_name => l_proc
1262: ,p_argument => 'validation_start_date'
1263: ,p_argument_value => p_validation_start_date
1264: );

Line 1268: hr_api.mandatory_arg_error

1264: );
1265: --
1266: hr_utility.set_location(' Entering: More VAlidation'||l_proc,15);
1267: --
1268: hr_api.mandatory_arg_error
1269: (p_api_name => l_proc
1270: ,p_argument => 'validation_end_date'
1271: ,p_argument_value => p_validation_end_date
1272: );

Line 1275: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and

1271: ,p_argument_value => p_validation_end_date
1272: );
1273: --
1274: /* -- bug 7457065. As we allow end dated Steps to be used now, this check is removed.
1275: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and
1276: NOT (dt_api.check_min_max_dates
1277: (p_base_table_name => 'per_spinal_point_steps_f'
1278: ,p_base_key_column => 'STEP_ID'
1279: ,p_base_key_value => p_step_id

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

1282: l_table_name := 'spinal point steps';
1283: raise l_integrity_error;
1284: End If;
1285: */
1286: If ((nvl(p_assignment_id, hr_api.g_number) <> hr_api.g_number) and
1287: NOT (dt_api.check_min_max_dates
1288: (p_base_table_name => 'per_all_assignments_f'
1289: ,p_base_key_column => 'ASSIGNMENT_ID'
1290: ,p_base_key_value => p_assignment_id

Line 1370: hr_api.mandatory_arg_error

1366: Begin
1367: --
1368: -- Ensure that the p_datetrack_mode argument is not null
1369: --
1370: hr_api.mandatory_arg_error
1371: (p_api_name => l_proc
1372: ,p_argument => 'datetrack_mode'
1373: ,p_argument_value => p_datetrack_mode
1374: );

Line 1379: If (p_datetrack_mode = hr_api.g_delete or

1375: --
1376: -- Only perform the validation if the datetrack mode is either
1377: -- DELETE or ZAP
1378: --
1379: If (p_datetrack_mode = hr_api.g_delete or
1380: p_datetrack_mode = hr_api.g_zap) then
1381: --
1382: --
1383: -- Ensure the arguments are not null

Line 1380: p_datetrack_mode = hr_api.g_zap) then

1376: -- Only perform the validation if the datetrack mode is either
1377: -- DELETE or ZAP
1378: --
1379: If (p_datetrack_mode = hr_api.g_delete or
1380: p_datetrack_mode = hr_api.g_zap) then
1381: --
1382: --
1383: -- Ensure the arguments are not null
1384: --

Line 1385: hr_api.mandatory_arg_error

1381: --
1382: --
1383: -- Ensure the arguments are not null
1384: --
1385: hr_api.mandatory_arg_error
1386: (p_api_name => l_proc
1387: ,p_argument => 'validation_start_date'
1388: ,p_argument_value => p_validation_start_date
1389: );

Line 1391: hr_api.mandatory_arg_error

1387: ,p_argument => 'validation_start_date'
1388: ,p_argument_value => p_validation_start_date
1389: );
1390: --
1391: hr_api.mandatory_arg_error
1392: (p_api_name => l_proc
1393: ,p_argument => 'validation_end_date'
1394: ,p_argument_value => p_validation_end_date
1395: );

Line 1397: hr_api.mandatory_arg_error

1393: ,p_argument => 'validation_end_date'
1394: ,p_argument_value => p_validation_end_date
1395: );
1396: --
1397: hr_api.mandatory_arg_error
1398: (p_api_name => l_proc
1399: ,p_argument => 'placement_id'
1400: ,p_argument_value => p_placement_id
1401: );

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

1444: hr_utility.set_location('Entering:'||l_proc, 5);
1445: --
1446: -- Call all supporting business operations
1447: --
1448: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1449: --
1450: l_effective_start_date := p_effective_date; -- bug 2491732
1451: --l_effective_start_date := hr_api.g_sys commented out for bug 2491732;
1452: l_effective_end_date := hr_api.g_eot; -- do i want this?

Line 1451: --l_effective_start_date := hr_api.g_sys commented out for bug 2491732;

1447: --
1448: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1449: --
1450: l_effective_start_date := p_effective_date; -- bug 2491732
1451: --l_effective_start_date := hr_api.g_sys commented out for bug 2491732;
1452: l_effective_end_date := hr_api.g_eot; -- do i want this?
1453: --
1454: hr_utility.set_location('Entering:chk_parent_spine_step_id : '||l_proc, 10);
1455: --

Line 1452: l_effective_end_date := hr_api.g_eot; -- do i want this?

1448: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1449: --
1450: l_effective_start_date := p_effective_date; -- bug 2491732
1451: --l_effective_start_date := hr_api.g_sys commented out for bug 2491732;
1452: l_effective_end_date := hr_api.g_eot; -- do i want this?
1453: --
1454: hr_utility.set_location('Entering:chk_parent_spine_step_id : '||l_proc, 10);
1455: --
1456: hr_utility.set_location('Start Date :'|| l_effective_start_date,969);

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

1529: hr_utility.set_location('Entering:'||l_proc, 5);
1530: --
1531: -- Call all supporting business operations
1532: --
1533: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1534: --
1535: open csr_start_end_date;
1536: fetch csr_start_end_date into l_effective_start_date, l_effective_end_date;
1537: if csr_start_end_date%notfound then