DBA Data[Home] [Help]

APPS.PAY_BTH_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 => 'batch_id'
47: ,p_argument_value => p_batch_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 => 'batch_id'
107: ,p_argument_value => p_batch_id
108: );

Line 110: if ( nvl(pay_bth_bus.g_batch_id, hr_api.g_number)

106: ,p_argument => 'batch_id'
107: ,p_argument_value => p_batch_id
108: );
109: --
110: if ( nvl(pay_bth_bus.g_batch_id, hr_api.g_number)
111: = p_batch_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 202: if nvl(p_rec.business_group_id, hr_api.g_number) <>

198: END IF;
199: --
200: hr_utility.set_location(l_proc, 10);
201: --
202: if nvl(p_rec.business_group_id, hr_api.g_number) <>
203: pay_bth_shd.g_old_rec.business_group_id then
204: l_argument := 'business_group_id';
205: raise l_error;
206: end if;

Line 212: hr_api.argument_changed_error

208: hr_utility.set_location(l_proc, 20);
209: --
210: EXCEPTION
211: WHEN l_error THEN
212: hr_api.argument_changed_error
213: (p_api_name => l_proc
214: ,p_argument => l_argument);
215: WHEN OTHERS THEN
216: RAISE;

Line 313: hr_api.mandatory_arg_error

309: hr_utility.set_location('Entering:'||l_proc, 1);
310: --
311: -- Check mandatory batch_name exists
312: --
313: hr_api.mandatory_arg_error
314: (p_api_name => l_proc
315: ,p_argument => 'batch_name'
316: ,p_argument_value => p_batch_name
317: );

Line 371: hr_api.mandatory_arg_error

367: hr_utility.set_location('Entering:'||l_proc, 1);
368: --
369: -- Check mandatory batch_name exists
370: --
371: hr_api.mandatory_arg_error
372: (p_api_name => l_proc
373: ,p_argument => 'batch_status'
374: ,p_argument_value => p_batch_status
375: );

Line 379: hr_api.mandatory_arg_error

375: );
376: --
377: -- Check mandatory session_date exists
378: --
379: hr_api.mandatory_arg_error
380: (p_api_name => l_proc
381: ,p_argument => 'session_date'
382: ,p_argument_value => p_session_date
383: );

Line 396: nvl(pay_bth_shd.g_old_rec.batch_status,hr_api.g_varchar2) <>

392: --
393: -- Only proceed with SQL validation if absolutely necessary
394: --
395: if ((l_api_updating and
396: nvl(pay_bth_shd.g_old_rec.batch_status,hr_api.g_varchar2) <>
397: nvl(p_batch_status,hr_api.g_varchar2))
398: or (NOT l_api_updating)) then
399: --
400: hr_utility.set_location(l_proc,30);

Line 397: nvl(p_batch_status,hr_api.g_varchar2))

393: -- Only proceed with SQL validation if absolutely necessary
394: --
395: if ((l_api_updating and
396: nvl(pay_bth_shd.g_old_rec.batch_status,hr_api.g_varchar2) <>
397: nvl(p_batch_status,hr_api.g_varchar2))
398: or (NOT l_api_updating)) then
399: --
400: hr_utility.set_location(l_proc,30);
401: --

Line 404: if hr_api.not_exists_in_hr_lookups

400: hr_utility.set_location(l_proc,30);
401: --
402: -- Validate against the hr_lookup.
403: --
404: if hr_api.not_exists_in_hr_lookups
405: (p_effective_date => p_session_date,
406: p_lookup_type => 'BATCH_STATUS',
407: p_lookup_code => p_batch_status) then
408: pay_bth_shd.constraint_error('PAY_BCH_BATCH_STATUS_CHK');

Line 465: hr_api.mandatory_arg_error

461: hr_utility.set_location('Entering:'||l_proc, 1);
462: --
463: -- Check mandatory session_date exists
464: --
465: hr_api.mandatory_arg_error
466: (p_api_name => l_proc
467: ,p_argument => 'session_date'
468: ,p_argument_value => p_session_date
469: );

Line 482: nvl(pay_bth_shd.g_old_rec.action_if_exists,hr_api.g_varchar2) <>

478: --
479: -- Only proceed with SQL validation if absolutely necessary
480: --
481: if ((l_api_updating and
482: nvl(pay_bth_shd.g_old_rec.action_if_exists,hr_api.g_varchar2) <>
483: nvl(p_action_if_exists,hr_api.g_varchar2))
484: or (NOT l_api_updating)) then
485: --
486: hr_utility.set_location(l_proc,30);

Line 483: nvl(p_action_if_exists,hr_api.g_varchar2))

479: -- Only proceed with SQL validation if absolutely necessary
480: --
481: if ((l_api_updating and
482: nvl(pay_bth_shd.g_old_rec.action_if_exists,hr_api.g_varchar2) <>
483: nvl(p_action_if_exists,hr_api.g_varchar2))
484: or (NOT l_api_updating)) then
485: --
486: hr_utility.set_location(l_proc,30);
487: --

Line 494: if hr_api.not_exists_in_hr_lookups

490: hr_utility.set_location(l_proc,35);
491: --
492: -- Validate against the hr_lookup.
493: --
494: if hr_api.not_exists_in_hr_lookups
495: (p_effective_date => p_session_date,
496: p_lookup_type => 'ACTION_IF_EXISTS',
497: p_lookup_code => p_action_if_exists) then
498: pay_bth_shd.constraint_error('PAY_BCH_ACTION_IF_EXISTS_CHK');

Line 557: hr_api.mandatory_arg_error

553: hr_utility.set_location('Entering:'||l_proc, 1);
554: --
555: -- Check mandatory session_date exists
556: --
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc
559: ,p_argument => 'session_date'
560: ,p_argument_value => p_session_date
561: );

Line 574: nvl(pay_bth_shd.g_old_rec.purge_after_transfer,hr_api.g_varchar2) <>

570: --
571: -- Only proceed with SQL validation if absolutely necessary
572: --
573: if ((l_api_updating and
574: nvl(pay_bth_shd.g_old_rec.purge_after_transfer,hr_api.g_varchar2) <>
575: nvl(p_purge_after_transfer,hr_api.g_varchar2))
576: or (NOT l_api_updating)) then
577: --
578: hr_utility.set_location(l_proc,30);

Line 575: nvl(p_purge_after_transfer,hr_api.g_varchar2))

571: -- Only proceed with SQL validation if absolutely necessary
572: --
573: if ((l_api_updating and
574: nvl(pay_bth_shd.g_old_rec.purge_after_transfer,hr_api.g_varchar2) <>
575: nvl(p_purge_after_transfer,hr_api.g_varchar2))
576: or (NOT l_api_updating)) then
577: --
578: hr_utility.set_location(l_proc,30);
579: --

Line 586: if hr_api.not_exists_in_hr_lookups

582: hr_utility.set_location(l_proc,35);
583: --
584: -- Validate against the hr_lookup.
585: --
586: if hr_api.not_exists_in_hr_lookups
587: (p_effective_date => p_session_date,
588: p_lookup_type => 'YES_NO',
589: p_lookup_code => p_purge_after_transfer) then
590: pay_bth_shd.constraint_error('PAY_BCH_PURGE_AFTER_TRANSF_CHK');

Line 649: hr_api.mandatory_arg_error

645: hr_utility.set_location('Entering:'||l_proc, 1);
646: --
647: -- Check mandatory session_date exists
648: --
649: hr_api.mandatory_arg_error
650: (p_api_name => l_proc
651: ,p_argument => 'session_date'
652: ,p_argument_value => p_session_date
653: );

Line 666: nvl(pay_bth_shd.g_old_rec.reject_if_future_changes,hr_api.g_varchar2) <>

662: --
663: -- Only proceed with SQL validation if absolutely necessary
664: --
665: if ((l_api_updating and
666: nvl(pay_bth_shd.g_old_rec.reject_if_future_changes,hr_api.g_varchar2) <>
667: nvl(p_reject_if_future_changes,hr_api.g_varchar2))
668: or (NOT l_api_updating)) then
669: --
670: hr_utility.set_location(l_proc,30);

Line 667: nvl(p_reject_if_future_changes,hr_api.g_varchar2))

663: -- Only proceed with SQL validation if absolutely necessary
664: --
665: if ((l_api_updating and
666: nvl(pay_bth_shd.g_old_rec.reject_if_future_changes,hr_api.g_varchar2) <>
667: nvl(p_reject_if_future_changes,hr_api.g_varchar2))
668: or (NOT l_api_updating)) then
669: --
670: hr_utility.set_location(l_proc,30);
671: --

Line 678: if hr_api.not_exists_in_hr_lookups

674: hr_utility.set_location(l_proc,35);
675: --
676: -- Validate against the hr_lookup.
677: --
678: if hr_api.not_exists_in_hr_lookups
679: (p_effective_date => p_session_date,
680: p_lookup_type => 'YES_NO',
681: p_lookup_code => p_reject_if_future_changes) then
682: pay_bth_shd.constraint_error('PAY_BCH_REJECT_IF_FUTURE_C_CHK');

Line 741: hr_api.mandatory_arg_error

737: hr_utility.set_location('Entering:'||l_proc, 1);
738: --
739: -- Check mandatory session_date exists
740: --
741: hr_api.mandatory_arg_error
742: (p_api_name => l_proc
743: ,p_argument => 'session_date'
744: ,p_argument_value => p_session_date
745: );

Line 758: nvl(pay_bth_shd.g_old_rec.reject_if_results_exists,hr_api.g_varchar2) <>

754: --
755: -- Only proceed with SQL validation if absolutely necessary
756: --
757: if ((l_api_updating and
758: nvl(pay_bth_shd.g_old_rec.reject_if_results_exists,hr_api.g_varchar2) <>
759: nvl(p_reject_if_results_exists,hr_api.g_varchar2))
760: or (NOT l_api_updating)) then
761: --
762: hr_utility.set_location(l_proc,30);

Line 759: nvl(p_reject_if_results_exists,hr_api.g_varchar2))

755: -- Only proceed with SQL validation if absolutely necessary
756: --
757: if ((l_api_updating and
758: nvl(pay_bth_shd.g_old_rec.reject_if_results_exists,hr_api.g_varchar2) <>
759: nvl(p_reject_if_results_exists,hr_api.g_varchar2))
760: or (NOT l_api_updating)) then
761: --
762: hr_utility.set_location(l_proc,30);
763: --

Line 770: if hr_api.not_exists_in_hr_lookups

766: hr_utility.set_location(l_proc,35);
767: --
768: -- Validate against the hr_lookup.
769: --
770: if hr_api.not_exists_in_hr_lookups
771: (p_effective_date => p_session_date,
772: p_lookup_type => 'YES_NO',
773: p_lookup_code => p_reject_if_results_exists) then
774: pay_bth_shd.constraint_error('PAY_BCH_REJECT_IF_RESULTS_E_CHK');

Line 833: hr_api.mandatory_arg_error

829: hr_utility.set_location('Entering:'||l_proc, 1);
830: --
831: -- Check mandatory session_date exists
832: --
833: hr_api.mandatory_arg_error
834: (p_api_name => l_proc
835: ,p_argument => 'session_date'
836: ,p_argument_value => p_session_date
837: );

Line 850: nvl(pay_bth_shd.g_old_rec.purge_after_rollback,hr_api.g_varchar2) <>

846: --
847: -- Only proceed with SQL validation if absolutely necessary
848: --
849: if ((l_api_updating and
850: nvl(pay_bth_shd.g_old_rec.purge_after_rollback,hr_api.g_varchar2) <>
851: nvl(p_purge_after_rollback,hr_api.g_varchar2))
852: or (NOT l_api_updating)) then
853: --
854: hr_utility.set_location(l_proc,30);

Line 851: nvl(p_purge_after_rollback,hr_api.g_varchar2))

847: -- Only proceed with SQL validation if absolutely necessary
848: --
849: if ((l_api_updating and
850: nvl(pay_bth_shd.g_old_rec.purge_after_rollback,hr_api.g_varchar2) <>
851: nvl(p_purge_after_rollback,hr_api.g_varchar2))
852: or (NOT l_api_updating)) then
853: --
854: hr_utility.set_location(l_proc,30);
855: --

Line 862: if hr_api.not_exists_in_hr_lookups

858: hr_utility.set_location(l_proc,35);
859: --
860: -- Validate against the hr_lookup.
861: --
862: if hr_api.not_exists_in_hr_lookups
863: (p_effective_date => p_session_date,
864: p_lookup_type => 'YES_NO',
865: p_lookup_code => p_purge_after_rollback) then
866: pay_bth_shd.constraint_error('PAY_BCH_PURGE_AFTER_R_CHK');

Line 926: hr_api.mandatory_arg_error

922: hr_utility.set_location('Entering:'||l_proc, 1);
923: --
924: -- Check mandatory session_date exists
925: --
926: hr_api.mandatory_arg_error
927: (p_api_name => l_proc
928: ,p_argument => 'session_date'
929: ,p_argument_value => p_session_date
930: );

Line 943: nvl(pay_bth_shd.g_old_rec.date_effective_changes,hr_api.g_varchar2) <>

939: --
940: -- Only proceed with SQL validation if absolutely necessary
941: --
942: if ((l_api_updating and
943: nvl(pay_bth_shd.g_old_rec.date_effective_changes,hr_api.g_varchar2) <>
944: nvl(p_date_effective_changes,hr_api.g_varchar2))
945: or (NOT l_api_updating)) then
946: --
947: hr_utility.set_location(l_proc,30);

Line 944: nvl(p_date_effective_changes,hr_api.g_varchar2))

940: -- Only proceed with SQL validation if absolutely necessary
941: --
942: if ((l_api_updating and
943: nvl(pay_bth_shd.g_old_rec.date_effective_changes,hr_api.g_varchar2) <>
944: nvl(p_date_effective_changes,hr_api.g_varchar2))
945: or (NOT l_api_updating)) then
946: --
947: hr_utility.set_location(l_proc,30);
948: --

Line 955: if hr_api.not_exists_in_hr_lookups

951: hr_utility.set_location(l_proc,35);
952: --
953: -- Validate against the hr_lookup.
954: --
955: if hr_api.not_exists_in_hr_lookups
956: (p_effective_date => p_session_date,
957: p_lookup_type => 'DATE_EFFECTIVE_CHANGES',
958: p_lookup_code => p_date_effective_changes) then
959: pay_bth_shd.constraint_error('PAY_BCH_DATE_EFFECTIVE_CHA_CHK');

Line 1038: hr_api.mandatory_arg_error

1034: hr_utility.set_location('Entering:'||l_proc, 1);
1035: --
1036: -- Check mandatory batch_id exists
1037: --
1038: hr_api.mandatory_arg_error
1039: (p_api_name => l_proc
1040: ,p_argument => 'batch_id'
1041: ,p_argument_value => p_batch_id
1042: );

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

1110: hr_utility.set_location('Entering:'||l_proc, 5);
1111: --
1112: -- Call all supporting business operations
1113: --
1114: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1115: --
1116: hr_utility.set_location(l_proc, 20);
1117: --
1118: chk_batch_name(p_batch_name => p_rec.batch_name);

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

1171: hr_utility.set_location('Entering:'||l_proc, 5);
1172: --
1173: -- Call all supporting business operations
1174: --
1175: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1176: --
1177: chk_non_updateable_args
1178: (p_rec => p_rec
1179: );