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_EVC_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 => 'event_value_change_id'
48: ,p_argument_value => p_event_value_change_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 => 'event_value_change_id'
112: ,p_argument_value => p_event_value_change_id
113: );

Line 115: if ( nvl(pay_evc_bus.g_event_value_change_id, hr_api.g_number)

111: ,p_argument => 'event_value_change_id'
112: ,p_argument_value => p_event_value_change_id
113: );
114: --
115: if ( nvl(pay_evc_bus.g_event_value_change_id, hr_api.g_number)
116: = p_event_value_change_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 208: if (nvl(p_rec.event_value_change_id, hr_api.g_number) <>

204: END IF;
205: --
206: -- Checks to ensure non-updateable args have
207: -- not been updated.
208: if (nvl(p_rec.event_value_change_id, hr_api.g_number) <>
209: nvl(pay_evc_shd.g_old_rec.event_value_change_id,hr_api.g_number)
210: ) then
211: l_argument := 'event_value_change_id';
212: raise l_error;

Line 209: nvl(pay_evc_shd.g_old_rec.event_value_change_id,hr_api.g_number)

205: --
206: -- Checks to ensure non-updateable args have
207: -- not been updated.
208: if (nvl(p_rec.event_value_change_id, hr_api.g_number) <>
209: nvl(pay_evc_shd.g_old_rec.event_value_change_id,hr_api.g_number)
210: ) then
211: l_argument := 'event_value_change_id';
212: raise l_error;
213: END IF;

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

211: l_argument := 'event_value_change_id';
212: raise l_error;
213: END IF;
214: --
215: if (nvl(p_rec.event_qualifier_id, hr_api.g_number) <>
216: nvl(pay_evc_shd.g_old_rec.event_qualifier_id,hr_api.g_number)
217: ) then
218: l_argument := 'event_qualifier_id';
219: raise l_error;

Line 216: nvl(pay_evc_shd.g_old_rec.event_qualifier_id,hr_api.g_number)

212: raise l_error;
213: END IF;
214: --
215: if (nvl(p_rec.event_qualifier_id, hr_api.g_number) <>
216: nvl(pay_evc_shd.g_old_rec.event_qualifier_id,hr_api.g_number)
217: ) then
218: l_argument := 'event_qualifier_id';
219: raise l_error;
220: END IF;

Line 222: if (nvl(p_rec.datetracked_event_id, hr_api.g_number) <>

218: l_argument := 'event_qualifier_id';
219: raise l_error;
220: END IF;
221: --
222: if (nvl(p_rec.datetracked_event_id, hr_api.g_number) <>
223: nvl(pay_evc_shd.g_old_rec.datetracked_event_id,hr_api.g_number)
224: ) then
225: l_argument := 'datetracked_event_id';
226: raise l_error;

Line 223: nvl(pay_evc_shd.g_old_rec.datetracked_event_id,hr_api.g_number)

219: raise l_error;
220: END IF;
221: --
222: if (nvl(p_rec.datetracked_event_id, hr_api.g_number) <>
223: nvl(pay_evc_shd.g_old_rec.datetracked_event_id,hr_api.g_number)
224: ) then
225: l_argument := 'datetracked_event_id';
226: raise l_error;
227: END IF;

Line 229: if (nvl(p_rec.default_event, hr_api.g_varchar2) <>

225: l_argument := 'datetracked_event_id';
226: raise l_error;
227: END IF;
228: --
229: if (nvl(p_rec.default_event, hr_api.g_varchar2) <>
230: nvl(pay_evc_shd.g_old_rec.default_event,hr_api.g_varchar2)
231: ) then
232: l_argument := 'default_event';
233: raise l_error;

Line 230: nvl(pay_evc_shd.g_old_rec.default_event,hr_api.g_varchar2)

226: raise l_error;
227: END IF;
228: --
229: if (nvl(p_rec.default_event, hr_api.g_varchar2) <>
230: nvl(pay_evc_shd.g_old_rec.default_event,hr_api.g_varchar2)
231: ) then
232: l_argument := 'default_event';
233: raise l_error;
234: END IF;

Line 236: if (nvl(p_rec.qualifier_value, hr_api.g_varchar2) <>

232: l_argument := 'default_event';
233: raise l_error;
234: END IF;
235: --
236: if (nvl(p_rec.qualifier_value, hr_api.g_varchar2) <>
237: nvl(pay_evc_shd.g_old_rec.qualifier_value,hr_api.g_varchar2)
238: ) then
239: l_argument := 'qualifier_value';
240: raise l_error;

Line 237: nvl(pay_evc_shd.g_old_rec.qualifier_value,hr_api.g_varchar2)

233: raise l_error;
234: END IF;
235: --
236: if (nvl(p_rec.qualifier_value, hr_api.g_varchar2) <>
237: nvl(pay_evc_shd.g_old_rec.qualifier_value,hr_api.g_varchar2)
238: ) then
239: l_argument := 'qualifier_value';
240: raise l_error;
241: END IF;

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

239: l_argument := 'qualifier_value';
240: raise l_error;
241: END IF;
242: --
243: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
244: nvl(pay_evc_shd.g_old_rec.business_group_id,hr_api.g_number)
245: ) then
246: l_argument := 'business_group_id';
247: raise l_error;

Line 244: nvl(pay_evc_shd.g_old_rec.business_group_id,hr_api.g_number)

240: raise l_error;
241: END IF;
242: --
243: if (nvl(p_rec.business_group_id, hr_api.g_number) <>
244: nvl(pay_evc_shd.g_old_rec.business_group_id,hr_api.g_number)
245: ) then
246: l_argument := 'business_group_id';
247: raise l_error;
248: END IF;

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

246: l_argument := 'business_group_id';
247: raise l_error;
248: END IF;
249: --
250: if (nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
251: nvl(pay_evc_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
252: ) then
253: l_argument := 'legislation_code';
254: raise l_error;

Line 251: nvl(pay_evc_shd.g_old_rec.legislation_code,hr_api.g_varchar2)

247: raise l_error;
248: END IF;
249: --
250: if (nvl(p_rec.legislation_code, hr_api.g_varchar2) <>
251: nvl(pay_evc_shd.g_old_rec.legislation_code,hr_api.g_varchar2)
252: ) then
253: l_argument := 'legislation_code';
254: raise l_error;
255: END IF;

Line 299: hr_api.mandatory_arg_error

295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: -- Check that the mandatory effective date is not null.
298: --
299: hr_api.mandatory_arg_error
300: (p_api_name => l_proc
301: ,p_argument => 'effective_date'
302: ,p_argument_value => p_effective_date
303: );

Line 307: if hr_api.not_exists_in_hr_lookups

303: );
304: --
305: IF p_rec.business_group_id <> null then
306: --got BG so validate against hr_lookups
307: if hr_api.not_exists_in_hr_lookups
308: (p_lookup_type => 'YES_NO',
309: p_lookup_code => p_rec.default_event,
310: p_effective_date => p_effective_date)
311: then

Line 320: if hr_api.not_exists_in_dt_hrstanlookups

316: fnd_message.raise_error;
317: end if;
318: ELSE
319: -- Validate against hr_standard_lookups as DateTracked and no bg context.
320: if hr_api.not_exists_in_dt_hrstanlookups
321: (p_effective_date => p_effective_date
322: ,p_validation_start_date => p_validation_start_date
323: ,p_validation_end_date => p_validation_end_date
324: ,p_lookup_type => 'YES_NO'

Line 376: hr_api.mandatory_arg_error

372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- Check that the mandatory effective date is not null.
375: --
376: hr_api.mandatory_arg_error
377: (p_api_name => l_proc
378: ,p_argument => 'effective_date'
379: ,p_argument_value => p_effective_date
380: );

Line 384: if hr_api.not_exists_in_hr_lookups

380: );
381:
382: IF p_rec.business_group_id <> null then
383: --got BG so validate against hr_lookups
384: if hr_api.not_exists_in_hr_lookups
385: (p_lookup_type => 'YES_NO',
386: p_lookup_code => p_rec.valid_event,
387: p_effective_date => p_effective_date)
388: then

Line 397: if hr_api.not_exists_in_dt_hrstanlookups

393: fnd_message.raise_error;
394: end if;
395: ELSE
396: -- Validate against hr_standard_lookups as DateTracked and no bg context.
397: if hr_api.not_exists_in_dt_hrstanlookups
398: (p_effective_date => p_effective_date
399: ,p_validation_start_date => p_validation_start_date
400: ,p_validation_end_date => p_validation_end_date
401: ,p_lookup_type => 'YES_NO'

Line 455: hr_api.mandatory_arg_error

451: hr_utility.set_location('Entering:'||l_proc, 5);
452: --
453: -- Check that the mandatory effective date is not null.
454: --
455: hr_api.mandatory_arg_error
456: (p_api_name => l_proc
457: ,p_argument => 'effective_date'
458: ,p_argument_value => p_effective_date
459: );

Line 463: if hr_api.not_exists_in_hr_lookups

459: );
460:
461: IF p_rec.business_group_id <> null then
462: --got BG so validate against hr_lookups
463: if hr_api.not_exists_in_hr_lookups
464: (p_lookup_type => 'PAY_PRORATION_STYLE',
465: p_lookup_code => p_rec.proration_style,
466: p_effective_date => p_effective_date)
467: then

Line 476: if hr_api.not_exists_in_dt_hrstanlookups

472: fnd_message.raise_error;
473: end if;
474: ELSE
475: -- Validate against hr_standard_lookups as DateTracked and no bg context.
476: if hr_api.not_exists_in_dt_hrstanlookups
477: (p_effective_date => p_effective_date
478: ,p_validation_start_date => p_validation_start_date
479: ,p_validation_end_date => p_validation_end_date
480: ,p_lookup_type => 'PAY_PRORATION_STYLE'

Line 525: (p_event_qualifier_id in number default hr_api.g_number

521: --
522: -- {End Of Comments}
523: -- ----------------------------------------------------------------------------
524: Procedure dt_update_validate
525: (p_event_qualifier_id in number default hr_api.g_number
526: ,p_datetrack_mode in varchar2
527: ,p_validation_start_date in date
528: ,p_validation_end_date in date
529: ) Is

Line 537: hr_api.mandatory_arg_error

533: Begin
534: --
535: -- Ensure that the p_datetrack_mode argument is not null
536: --
537: hr_api.mandatory_arg_error
538: (p_api_name => l_proc
539: ,p_argument => 'datetrack_mode'
540: ,p_argument_value => p_datetrack_mode
541: );

Line 547: hr_api.mandatory_arg_error

543: -- Mode will be valid, as this is checked at the start of the upd.
544: --
545: -- Ensure the arguments are not null
546: --
547: hr_api.mandatory_arg_error
548: (p_api_name => l_proc
549: ,p_argument => 'validation_start_date'
550: ,p_argument_value => p_validation_start_date
551: );

Line 553: hr_api.mandatory_arg_error

549: ,p_argument => 'validation_start_date'
550: ,p_argument_value => p_validation_start_date
551: );
552: --
553: hr_api.mandatory_arg_error
554: (p_api_name => l_proc
555: ,p_argument => 'validation_end_date'
556: ,p_argument_value => p_validation_end_date
557: );

Line 559: If ((nvl(p_event_qualifier_id, hr_api.g_number) <> hr_api.g_number) and

555: ,p_argument => 'validation_end_date'
556: ,p_argument_value => p_validation_end_date
557: );
558: --
559: If ((nvl(p_event_qualifier_id, hr_api.g_number) <> hr_api.g_number) and
560: NOT (dt_api.check_min_max_dates
561: (p_base_table_name => 'pay_event_qualifiers_f'
562: ,p_base_key_column => 'EVENT_QUALIFIER_ID'
563: ,p_base_key_value => p_event_qualifier_id

Line 632: hr_api.mandatory_arg_error

628: Begin
629: --
630: -- Ensure that the p_datetrack_mode argument is not null
631: --
632: hr_api.mandatory_arg_error
633: (p_api_name => l_proc
634: ,p_argument => 'datetrack_mode'
635: ,p_argument_value => p_datetrack_mode
636: );

Line 641: If (p_datetrack_mode = hr_api.g_delete or

637: --
638: -- Only perform the validation if the datetrack mode is either
639: -- DELETE or ZAP
640: --
641: If (p_datetrack_mode = hr_api.g_delete or
642: p_datetrack_mode = hr_api.g_zap) then
643: --
644: --
645: -- Ensure the arguments are not null

Line 642: p_datetrack_mode = hr_api.g_zap) then

638: -- Only perform the validation if the datetrack mode is either
639: -- DELETE or ZAP
640: --
641: If (p_datetrack_mode = hr_api.g_delete or
642: p_datetrack_mode = hr_api.g_zap) then
643: --
644: --
645: -- Ensure the arguments are not null
646: --

Line 647: hr_api.mandatory_arg_error

643: --
644: --
645: -- Ensure the arguments are not null
646: --
647: hr_api.mandatory_arg_error
648: (p_api_name => l_proc
649: ,p_argument => 'validation_start_date'
650: ,p_argument_value => p_validation_start_date
651: );

Line 653: hr_api.mandatory_arg_error

649: ,p_argument => 'validation_start_date'
650: ,p_argument_value => p_validation_start_date
651: );
652: --
653: hr_api.mandatory_arg_error
654: (p_api_name => l_proc
655: ,p_argument => 'validation_end_date'
656: ,p_argument_value => p_validation_end_date
657: );

Line 659: hr_api.mandatory_arg_error

655: ,p_argument => 'validation_end_date'
656: ,p_argument_value => p_validation_end_date
657: );
658: --
659: hr_api.mandatory_arg_error
660: (p_api_name => l_proc
661: ,p_argument => 'event_value_change_id'
662: ,p_argument_value => p_event_value_change_id
663: );

Line 752: hr_api.validate_bus_grp_id

748: NOT IN ('GENERIC','STARTUP') THEN
749: --
750: -- Validate Important Attributes
751: --
752: hr_api.validate_bus_grp_id
753: (p_business_group_id => p_rec.business_group_id
754: ,p_associated_column1 => pay_evc_shd.g_tab_nam
755: || '.BUSINESS_GROUP_ID');
756: --

Line 806: hr_api.validate_bus_grp_id

802: NOT IN ('GENERIC','STARTUP') THEN
803: --
804: -- Validate Important Attributes
805: --
806: hr_api.validate_bus_grp_id
807: (p_business_group_id => p_rec.business_group_id
808: ,p_associated_column1 => pay_evc_shd.g_tab_nam
809: || '.BUSINESS_GROUP_ID');
810: --