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

Line 45: hr_api.mandatory_arg_error

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

Line 71: hr_api.set_security_group_id

67: close csr_sec_grp;
68: --
69: -- Set the security_group_id in CLIENT_INFO
70: --
71: hr_api.set_security_group_id
72: (p_security_group_id => l_security_group_id
73: );
74: end if;
75: --

Line 109: hr_api.mandatory_arg_error

105: hr_utility.set_location('Entering:'|| l_proc, 10);
106: --
107: -- Ensure that all the mandatory parameter are not null
108: --
109: hr_api.mandatory_arg_error
110: (p_api_name => l_proc
111: ,p_argument => 'user_column_instance_id'
112: ,p_argument_value => p_user_column_instance_id
113: );

Line 115: if ( nvl(pay_uci_bus.g_user_column_instance_id, hr_api.g_number)

111: ,p_argument => 'user_column_instance_id'
112: ,p_argument_value => p_user_column_instance_id
113: );
114: --
115: if ( nvl(pay_uci_bus.g_user_column_instance_id, hr_api.g_number)
116: = p_user_column_instance_id) then
117: --
118: -- The legislation code has already been found with a previous
119: -- call to this function. Just return the value in the global

Line 206: if nvl(p_rec.user_row_id, hr_api.g_number) <>

202: fnd_message.raise_error;
203: END IF;
204: --
205: --
206: if nvl(p_rec.user_row_id, hr_api.g_number) <>
207: pay_uci_shd.g_old_rec.user_row_id then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'USER_ROW_ID'

Line 208: hr_api.argument_changed_error

204: --
205: --
206: if nvl(p_rec.user_row_id, hr_api.g_number) <>
207: pay_uci_shd.g_old_rec.user_row_id then
208: hr_api.argument_changed_error
209: (p_api_name => l_proc
210: ,p_argument => 'USER_ROW_ID'
211: ,p_base_table => pay_uci_shd.g_tab_nam
212: );

Line 215: if nvl(p_rec.user_column_id, hr_api.g_number) <>

211: ,p_base_table => pay_uci_shd.g_tab_nam
212: );
213: end if;
214: --
215: if nvl(p_rec.user_column_id, hr_api.g_number) <>
216: pay_uci_shd.g_old_rec.user_column_id then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'USER_COLUMN_ID'

Line 217: hr_api.argument_changed_error

213: end if;
214: --
215: if nvl(p_rec.user_column_id, hr_api.g_number) <>
216: pay_uci_shd.g_old_rec.user_column_id then
217: hr_api.argument_changed_error
218: (p_api_name => l_proc
219: ,p_argument => 'USER_COLUMN_ID'
220: ,p_base_table => pay_uci_shd.g_tab_nam
221: );

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

220: ,p_base_table => pay_uci_shd.g_tab_nam
221: );
222: end if;
223: --
224: if nvl(p_rec.business_group_id, hr_api.g_number) <>
225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'BUSINESS_GROUP_ID'

Line 225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then

221: );
222: end if;
223: --
224: if nvl(p_rec.business_group_id, hr_api.g_number) <>
225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'BUSINESS_GROUP_ID'
229: ,p_base_table => pay_uci_shd.g_tab_nam

Line 226: hr_api.argument_changed_error

222: end if;
223: --
224: if nvl(p_rec.business_group_id, hr_api.g_number) <>
225: nvl(pay_uci_shd.g_old_rec.business_group_id, hr_api.g_number) then
226: hr_api.argument_changed_error
227: (p_api_name => l_proc
228: ,p_argument => 'BUSINESS_GROUP_ID'
229: ,p_base_table => pay_uci_shd.g_tab_nam
230: );

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

229: ,p_base_table => pay_uci_shd.g_tab_nam
230: );
231: end if;
232: --
233: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'LEGISLATION_CODE'

Line 234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then

230: );
231: end if;
232: --
233: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'LEGISLATION_CODE'
238: ,p_base_table => pay_uci_shd.g_tab_nam

Line 235: hr_api.argument_changed_error

231: end if;
232: --
233: if nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
234: nvl(pay_uci_shd.g_old_rec.legislation_code, hr_api.g_varchar2) then
235: hr_api.argument_changed_error
236: (p_api_name => l_proc
237: ,p_argument => 'LEGISLATION_CODE'
238: ,p_base_table => pay_uci_shd.g_tab_nam
239: );

Line 276: (p_user_row_id in number default hr_api.g_number

272: --
273: -- {End Of Comments}
274: -- ----------------------------------------------------------------------------
275: Procedure dt_update_validate
276: (p_user_row_id in number default hr_api.g_number
277: ,p_datetrack_mode in varchar2
278: ,p_validation_start_date in date
279: ,p_validation_end_date in date
280: ) Is

Line 288: hr_api.mandatory_arg_error

284: Begin
285: --
286: -- Ensure that the p_datetrack_mode argument is not null
287: --
288: hr_api.mandatory_arg_error
289: (p_api_name => l_proc
290: ,p_argument => 'datetrack_mode'
291: ,p_argument_value => p_datetrack_mode
292: );

Line 298: hr_api.mandatory_arg_error

294: -- Mode will be valid, as this is checked at the start of the upd.
295: --
296: -- Ensure the arguments are not null
297: --
298: hr_api.mandatory_arg_error
299: (p_api_name => l_proc
300: ,p_argument => 'validation_start_date'
301: ,p_argument_value => p_validation_start_date
302: );

Line 304: hr_api.mandatory_arg_error

300: ,p_argument => 'validation_start_date'
301: ,p_argument_value => p_validation_start_date
302: );
303: --
304: hr_api.mandatory_arg_error
305: (p_api_name => l_proc
306: ,p_argument => 'validation_end_date'
307: ,p_argument_value => p_validation_end_date
308: );

Line 310: If ((nvl(p_user_row_id, hr_api.g_number) <> hr_api.g_number) and

306: ,p_argument => 'validation_end_date'
307: ,p_argument_value => p_validation_end_date
308: );
309: --
310: If ((nvl(p_user_row_id, hr_api.g_number) <> hr_api.g_number) and
311: NOT (dt_api.check_min_max_dates
312: (p_base_table_name => 'pay_user_rows_f'
313: ,p_base_key_column => 'USER_ROW_ID'
314: ,p_base_key_value => p_user_row_id

Line 383: hr_api.mandatory_arg_error

379: Begin
380: --
381: -- Ensure that the p_datetrack_mode argument is not null
382: --
383: hr_api.mandatory_arg_error
384: (p_api_name => l_proc
385: ,p_argument => 'datetrack_mode'
386: ,p_argument_value => p_datetrack_mode
387: );

Line 392: If (p_datetrack_mode = hr_api.g_delete or

388: --
389: -- Only perform the validation if the datetrack mode is either
390: -- DELETE or ZAP
391: --
392: If (p_datetrack_mode = hr_api.g_delete or
393: p_datetrack_mode = hr_api.g_zap) then
394: --
395: --
396: -- Ensure the arguments are not null

Line 393: p_datetrack_mode = hr_api.g_zap) then

389: -- Only perform the validation if the datetrack mode is either
390: -- DELETE or ZAP
391: --
392: If (p_datetrack_mode = hr_api.g_delete or
393: p_datetrack_mode = hr_api.g_zap) then
394: --
395: --
396: -- Ensure the arguments are not null
397: --

Line 398: hr_api.mandatory_arg_error

394: --
395: --
396: -- Ensure the arguments are not null
397: --
398: hr_api.mandatory_arg_error
399: (p_api_name => l_proc
400: ,p_argument => 'validation_start_date'
401: ,p_argument_value => p_validation_start_date
402: );

Line 404: hr_api.mandatory_arg_error

400: ,p_argument => 'validation_start_date'
401: ,p_argument_value => p_validation_start_date
402: );
403: --
404: hr_api.mandatory_arg_error
405: (p_api_name => l_proc
406: ,p_argument => 'validation_end_date'
407: ,p_argument_value => p_validation_end_date
408: );

Line 410: hr_api.mandatory_arg_error

406: ,p_argument => 'validation_end_date'
407: ,p_argument_value => p_validation_end_date
408: );
409: --
410: hr_api.mandatory_arg_error
411: (p_api_name => l_proc
412: ,p_argument => 'user_column_instance_id'
413: ,p_argument_value => p_user_column_instance_id
414: );

Line 604: hr_api.mandatory_arg_error

600: hr_utility.set_location('Entering:'|| l_proc, 10);
601: --
602: -- USER_ROW_ID is mandatory.
603: --
604: hr_api.mandatory_arg_error
605: (p_api_name => l_proc
606: ,p_argument => 'USER_ROW_ID'
607: ,p_argument_value => p_user_row_id
608: );

Line 703: hr_api.mandatory_arg_error

699: hr_utility.set_location('Entering:'|| l_proc, 10);
700: --
701: -- USER_COLUMN_ID is mandatory.
702: --
703: hr_api.mandatory_arg_error
704: (p_api_name => l_proc
705: ,p_argument => 'USER_COLUMN_ID'
706: ,p_argument_value => p_user_column_id
707: );

Line 805: uci.legislation_code = hr_api.return_legislation_code(p_business_group_id )))

801: or ( p_business_group_id is not null and p_business_group_id = uci.business_group_id )
802: or ( p_business_group_id is not null and
803: uci.legislation_code is null and uci.business_group_id is null )
804: or ( p_business_group_id is not null and
805: uci.legislation_code = hr_api.return_legislation_code(p_business_group_id )))
806: and ( p_legislation_code is null
807: or ( p_legislation_code is not null and p_legislation_code = uci.legislation_code )
808: or ( p_legislation_code is not null and
809: uci.legislation_code is null and uci.business_group_id is null)

Line 811: p_legislation_code = hr_api.return_legislation_code(uci.business_group_id )))

807: or ( p_legislation_code is not null and p_legislation_code = uci.legislation_code )
808: or ( p_legislation_code is not null and
809: uci.legislation_code is null and uci.business_group_id is null)
810: or ( p_legislation_code is not null and
811: p_legislation_code = hr_api.return_legislation_code(uci.business_group_id )))
812: and (uci.effective_start_date <= p_validation_end_date and
813: uci.effective_end_date >= p_validation_start_date );
814:
815: l_proc varchar2(100) := g_package || 'chk_row_column_id';

Line 953: nvl(p_value, hr_api.g_varchar2) <>

949: (p_user_column_instance_id => p_user_column_instance_id
950: ,p_effective_date => p_effective_date
951: ,p_object_version_number => p_object_version_number
952: ) or
953: nvl(p_value, hr_api.g_varchar2) <>
954: nvl(pay_uci_shd.g_old_rec.value, hr_api.g_varchar2)
955: ) then
956: --
957: open csr_formula_id;

Line 954: nvl(pay_uci_shd.g_old_rec.value, hr_api.g_varchar2)

950: ,p_effective_date => p_effective_date
951: ,p_object_version_number => p_object_version_number
952: ) or
953: nvl(p_value, hr_api.g_varchar2) <>
954: nvl(pay_uci_shd.g_old_rec.value, hr_api.g_varchar2)
955: ) then
956: --
957: open csr_formula_id;
958: fetch csr_formula_id into l_formula_id;

Line 1106: hr_api.validate_bus_grp_id

1102: NOT IN ('GENERIC','STARTUP') THEN
1103: --
1104: -- Validate Important Attributes
1105: --
1106: hr_api.validate_bus_grp_id
1107: (p_business_group_id => p_rec.business_group_id
1108: ,p_associated_column1 => pay_uci_shd.g_tab_nam
1109: || '.BUSINESS_GROUP_ID');
1110: --

Line 1202: hr_api.validate_bus_grp_id

1198: NOT IN ('GENERIC','STARTUP') THEN
1199: --
1200: -- Validate Important Attributes
1201: --
1202: hr_api.validate_bus_grp_id
1203: (p_business_group_id => p_rec.business_group_id
1204: ,p_associated_column1 => pay_uci_shd.g_tab_nam
1205: || '.BUSINESS_GROUP_ID');
1206: --