eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ROM_BUS dependencies on HR_API

Line 44: hr_api.mandatory_arg_error

40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error
45: (p_api_name => l_proc
46: ,p_argument => 'run_type_org_method_id'
47: ,p_argument_value => p_run_type_org_method_id
48: );

Line 67: hr_api.set_security_group_id

63: close csr_sec_grp;
64: --
65: -- Set the security_group_id in CLIENT_INFO
66: --
67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 104: hr_api.mandatory_arg_error

100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error
105: (p_api_name => l_proc
106: ,p_argument => 'run_type_org_method_id'
107: ,p_argument_value => p_run_type_org_method_id
108: );

Line 110: if ( nvl(pay_rom_bus.g_run_type_org_method_id, hr_api.g_number)

106: ,p_argument => 'run_type_org_method_id'
107: ,p_argument_value => p_run_type_org_method_id
108: );
109: --
110: if ( nvl(pay_rom_bus.g_run_type_org_method_id, hr_api.g_number)
111: = p_run_type_org_method_id) then
112: --
113: -- The legislation code has already been found with a previous
114: -- call to this function. Just return the value in the global

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

201: -- not been updated.
202: --
203: hr_utility.set_location(l_proc, 10);
204: --
205: if nvl(p_rec.business_group_id, hr_api.g_number) <>
206: nvl(pay_rom_shd.g_old_rec.business_group_id, hr_api.g_number) then
207: l_argument := 'business_group_id';
208: raise l_error;
209: end if;

Line 206: nvl(pay_rom_shd.g_old_rec.business_group_id, hr_api.g_number) then

202: --
203: hr_utility.set_location(l_proc, 10);
204: --
205: if nvl(p_rec.business_group_id, hr_api.g_number) <>
206: nvl(pay_rom_shd.g_old_rec.business_group_id, hr_api.g_number) then
207: l_argument := 'business_group_id';
208: raise l_error;
209: end if;
210: hr_utility.set_location(l_proc, 15);

Line 212: if nvl(p_rec.run_type_org_method_id, hr_api.g_number) <>

208: raise l_error;
209: end if;
210: hr_utility.set_location(l_proc, 15);
211: --
212: if nvl(p_rec.run_type_org_method_id, hr_api.g_number) <>
213: nvl(pay_rom_shd.g_old_rec.run_type_org_method_id,hr_api.g_number) then
214: l_argument := 'run_type_org_method_id';
215: raise l_error;
216: end if;

Line 213: nvl(pay_rom_shd.g_old_rec.run_type_org_method_id,hr_api.g_number) then

209: end if;
210: hr_utility.set_location(l_proc, 15);
211: --
212: if nvl(p_rec.run_type_org_method_id, hr_api.g_number) <>
213: nvl(pay_rom_shd.g_old_rec.run_type_org_method_id,hr_api.g_number) then
214: l_argument := 'run_type_org_method_id';
215: raise l_error;
216: end if;
217: hr_utility.set_location(l_proc, 20);

Line 219: if nvl(p_rec.legislation_code,hr_api.g_varchar2) <>

215: raise l_error;
216: end if;
217: hr_utility.set_location(l_proc, 20);
218: --
219: if nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
220: nvl(pay_rom_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
221: l_argument := 'legislation_code';
222: raise l_error;
223: end if;

Line 220: nvl(pay_rom_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then

216: end if;
217: hr_utility.set_location(l_proc, 20);
218: --
219: if nvl(p_rec.legislation_code,hr_api.g_varchar2) <>
220: nvl(pay_rom_shd.g_old_rec.legislation_code,hr_api.g_varchar2) then
221: l_argument := 'legislation_code';
222: raise l_error;
223: end if;
224: hr_utility.set_location(l_proc, 25);

Line 226: if nvl(p_rec.run_type_id, hr_api.g_number) <>

222: raise l_error;
223: end if;
224: hr_utility.set_location(l_proc, 25);
225: --
226: if nvl(p_rec.run_type_id, hr_api.g_number) <>
227: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) then
228: l_argument := 'run_type_id';
229: raise l_error;
230: end if;

Line 227: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) then

223: end if;
224: hr_utility.set_location(l_proc, 25);
225: --
226: if nvl(p_rec.run_type_id, hr_api.g_number) <>
227: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) then
228: l_argument := 'run_type_id';
229: raise l_error;
230: end if;
231: hr_utility.set_location(l_proc, 30);

Line 233: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>

229: raise l_error;
230: end if;
231: hr_utility.set_location(l_proc, 30);
232: --
233: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
234: nvl(pay_rom_shd.g_old_rec.org_payment_method_id,hr_api.g_number) then
235: l_argument := 'org_payment_method_id';
236: raise l_error;
237: end if;

Line 234: nvl(pay_rom_shd.g_old_rec.org_payment_method_id,hr_api.g_number) then

230: end if;
231: hr_utility.set_location(l_proc, 30);
232: --
233: if nvl(p_rec.org_payment_method_id, hr_api.g_number) <>
234: nvl(pay_rom_shd.g_old_rec.org_payment_method_id,hr_api.g_number) then
235: l_argument := 'org_payment_method_id';
236: raise l_error;
237: end if;
238: hr_utility.set_location(l_proc, 35);

Line 242: hr_api.argument_changed_error

238: hr_utility.set_location(l_proc, 35);
239: --
240: EXCEPTION
241: WHEN l_error THEN
242: hr_api.argument_changed_error
243: (p_api_name => l_proc
244: ,p_argument => l_argument);
245: WHEN OTHERS THEN
246: RAISE;

Line 355: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) <>

351: -- primary key value. For update it will be not null. For insert it will be
352: -- null because pre_insert has not been called yet.
353: --
354: IF (((p_run_type_org_method_id is not null) and
355: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) <>
356: nvl(p_run_type_id, hr_api.g_number)) or
357: (p_run_type_org_method_id is null)) THEN
358: --
359: hr_utility.set_location(l_proc, 10);

Line 356: nvl(p_run_type_id, hr_api.g_number)) or

352: -- null because pre_insert has not been called yet.
353: --
354: IF (((p_run_type_org_method_id is not null) and
355: nvl(pay_rom_shd.g_old_rec.run_type_id, hr_api.g_number) <>
356: nvl(p_run_type_id, hr_api.g_number)) or
357: (p_run_type_org_method_id is null)) THEN
358: --
359: hr_utility.set_location(l_proc, 10);
360: --

Line 398: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);

394: --
395: IF p_run_type_org_method_id is not null THEN
396: l_legislation_code := pay_rom_bus.return_legislation_code(p_run_type_org_method_id);
397: ELSE
398: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
399: END IF;
400: --
401: OPEN csr_chk_user_run_type(l_legislation_code);
402: FETCH csr_chk_user_run_type INTO l_exists;

Line 493: nvl(pay_rom_shd.g_old_rec.org_payment_method_id, hr_api.g_number) <>

489: -- primary key value. For update it will be not null. For insert it will be
490: -- null because pre_insert has not been called yet.
491: --
492: IF (((p_run_type_org_method_id is not null) and
493: nvl(pay_rom_shd.g_old_rec.org_payment_method_id, hr_api.g_number) <>
494: nvl(p_org_payment_method_id, hr_api.g_number)) or
495: (p_run_type_org_method_id is null)) THEN
496: --
497: hr_utility.set_location(l_proc, 10);

Line 494: nvl(p_org_payment_method_id, hr_api.g_number)) or

490: -- null because pre_insert has not been called yet.
491: --
492: IF (((p_run_type_org_method_id is not null) and
493: nvl(pay_rom_shd.g_old_rec.org_payment_method_id, hr_api.g_number) <>
494: nvl(p_org_payment_method_id, hr_api.g_number)) or
495: (p_run_type_org_method_id is null)) THEN
496: --
497: hr_utility.set_location(l_proc, 10);
498: --

Line 627: nvl(pay_rom_shd.g_old_rec.priority, hr_api.g_number) <>

623: -- primary key value. For update it will be not null. For insert it will be
624: -- null, because pre_inset has not been called yet.
625: --
626: IF (((p_run_type_org_method_id is not null) and
627: nvl(pay_rom_shd.g_old_rec.priority, hr_api.g_number) <>
628: nvl(p_priority, hr_api.g_number))
629: or
630: (p_run_type_org_method_id is null)) then
631: --

Line 628: nvl(p_priority, hr_api.g_number))

624: -- null, because pre_inset has not been called yet.
625: --
626: IF (((p_run_type_org_method_id is not null) and
627: nvl(pay_rom_shd.g_old_rec.priority, hr_api.g_number) <>
628: nvl(p_priority, hr_api.g_number))
629: or
630: (p_run_type_org_method_id is null)) then
631: --
632: hr_utility.set_location(l_proc, 10);

Line 908: (p_org_payment_method_id in number default hr_api.g_number

904: --
905: -- {End Of Comments}
906: -- ----------------------------------------------------------------------------
907: Procedure dt_update_validate
908: (p_org_payment_method_id in number default hr_api.g_number
909: ,p_run_type_id in number default hr_api.g_number
910: ,p_datetrack_mode in varchar2
911: ,p_validation_start_date in date
912: ,p_validation_end_date in date

Line 909: ,p_run_type_id in number default hr_api.g_number

905: -- {End Of Comments}
906: -- ----------------------------------------------------------------------------
907: Procedure dt_update_validate
908: (p_org_payment_method_id in number default hr_api.g_number
909: ,p_run_type_id in number default hr_api.g_number
910: ,p_datetrack_mode in varchar2
911: ,p_validation_start_date in date
912: ,p_validation_end_date in date
913: ) Is

Line 923: hr_api.mandatory_arg_error

919: Begin
920: --
921: -- Ensure that the p_datetrack_mode argument is not null
922: --
923: hr_api.mandatory_arg_error
924: (p_api_name => l_proc
925: ,p_argument => 'datetrack_mode'
926: ,p_argument_value => p_datetrack_mode
927: );

Line 933: hr_api.mandatory_arg_error

929: -- Mode will be valid, as this is checked at the start of the upd.
930: --
931: -- Ensure the arguments are not null
932: --
933: hr_api.mandatory_arg_error
934: (p_api_name => l_proc
935: ,p_argument => 'validation_start_date'
936: ,p_argument_value => p_validation_start_date
937: );

Line 939: hr_api.mandatory_arg_error

935: ,p_argument => 'validation_start_date'
936: ,p_argument_value => p_validation_start_date
937: );
938: --
939: hr_api.mandatory_arg_error
940: (p_api_name => l_proc
941: ,p_argument => 'validation_end_date'
942: ,p_argument_value => p_validation_end_date
943: );

Line 945: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and

941: ,p_argument => 'validation_end_date'
942: ,p_argument_value => p_validation_end_date
943: );
944: --
945: If ((nvl(p_org_payment_method_id, hr_api.g_number) <> hr_api.g_number) and
946: NOT (dt_api.check_min_max_dates
947: (p_base_table_name => 'pay_org_payment_methods_f'
948: ,p_base_key_column => 'ORG_PAYMENT_METHOD_ID'
949: ,p_base_key_value => p_org_payment_method_id

Line 955: If ((nvl(p_run_type_id, hr_api.g_number) <> hr_api.g_number) and

951: ,p_to_date => p_validation_end_date))) Then
952: l_table_name := 'org payment methods';
953: raise l_integrity_error;
954: End If;
955: If ((nvl(p_run_type_id, hr_api.g_number) <> hr_api.g_number) and
956: NOT (dt_api.check_min_max_dates
957: (p_base_table_name => 'pay_run_types_f'
958: ,p_base_key_column => 'RUN_TYPE_ID'
959: ,p_base_key_value => p_run_type_id

Line 1036: hr_api.mandatory_arg_error

1032: Begin
1033: --
1034: -- Ensure that the p_datetrack_mode argument is not null
1035: --
1036: hr_api.mandatory_arg_error
1037: (p_api_name => l_proc
1038: ,p_argument => 'datetrack_mode'
1039: ,p_argument_value => p_datetrack_mode
1040: );

Line 1045: If (p_datetrack_mode = hr_api.g_delete or

1041: --
1042: -- Only perform the validation if the datetrack mode is either
1043: -- DELETE or ZAP
1044: --
1045: If (p_datetrack_mode = hr_api.g_delete or
1046: p_datetrack_mode = hr_api.g_zap) then
1047: --
1048: --
1049: -- Ensure the arguments are not null

Line 1046: p_datetrack_mode = hr_api.g_zap) then

1042: -- Only perform the validation if the datetrack mode is either
1043: -- DELETE or ZAP
1044: --
1045: If (p_datetrack_mode = hr_api.g_delete or
1046: p_datetrack_mode = hr_api.g_zap) then
1047: --
1048: --
1049: -- Ensure the arguments are not null
1050: --

Line 1051: hr_api.mandatory_arg_error

1047: --
1048: --
1049: -- Ensure the arguments are not null
1050: --
1051: hr_api.mandatory_arg_error
1052: (p_api_name => l_proc
1053: ,p_argument => 'validation_start_date'
1054: ,p_argument_value => p_validation_start_date
1055: );

Line 1057: hr_api.mandatory_arg_error

1053: ,p_argument => 'validation_start_date'
1054: ,p_argument_value => p_validation_start_date
1055: );
1056: --
1057: hr_api.mandatory_arg_error
1058: (p_api_name => l_proc
1059: ,p_argument => 'validation_end_date'
1060: ,p_argument_value => p_validation_end_date
1061: );

Line 1063: hr_api.mandatory_arg_error

1059: ,p_argument => 'validation_end_date'
1060: ,p_argument_value => p_validation_end_date
1061: );
1062: --
1063: hr_api.mandatory_arg_error
1064: (p_api_name => l_proc
1065: ,p_argument => 'run_type_org_method_id'
1066: ,p_argument_value => p_run_type_org_method_id
1067: );

Line 1163: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1159: chk_startup_action(True
1160: ,p_rec.business_group_id
1161: ,p_rec.legislation_code);
1162: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1163: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1164: END IF;
1165: --
1166: hr_utility.set_location(l_proc, 10);
1167: --

Line 1229: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

1225: chk_startup_action(False
1226: ,p_rec.business_group_id
1227: ,p_rec.legislation_code);
1228: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
1229: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
1230: END IF;
1231: --
1232: hr_utility.set_location(l_proc, 10);
1233: --