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 1274: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and

1270: ,p_argument => 'validation_end_date'
1271: ,p_argument_value => p_validation_end_date
1272: );
1273: --
1274: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and
1275: NOT (dt_api.check_min_max_dates
1276: (p_base_table_name => 'per_spinal_point_steps_f'
1277: ,p_base_key_column => 'STEP_ID'
1278: ,p_base_key_value => p_step_id

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

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

Line 1368: hr_api.mandatory_arg_error

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

Line 1377: If (p_datetrack_mode = hr_api.g_delete or

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

Line 1378: p_datetrack_mode = hr_api.g_zap) then

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

Line 1383: hr_api.mandatory_arg_error

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

Line 1389: hr_api.mandatory_arg_error

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

Line 1395: hr_api.mandatory_arg_error

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

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

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

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

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

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

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

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

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