DBA Data[Home] [Help]

APPS.PAY_BTH_BUS dependencies on PAY_BTH_SHD

Line 176: (p_rec in pay_bth_shd.g_rec_type

172: --
173: -- {End Of Comments}
174: -- ----------------------------------------------------------------------------
175: Procedure chk_non_updateable_args
176: (p_rec in pay_bth_shd.g_rec_type
177: ) IS
178: --
179: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
180: l_error EXCEPTION;

Line 190: IF NOT pay_bth_shd.api_updating

186: --
187: -- Only proceed with the validation if a row exists for the current
188: -- record in the HR Schema.
189: --
190: IF NOT pay_bth_shd.api_updating
191: (p_batch_id => p_rec.batch_id
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 203: pay_bth_shd.g_old_rec.business_group_id then

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;
207: --

Line 387: l_api_updating := pay_bth_shd.api_updating

383: );
384: --
385: hr_utility.set_location(l_proc, 10);
386: --
387: l_api_updating := pay_bth_shd.api_updating
388: (p_batch_id => p_batch_id,
389: p_object_version_number => p_object_version_number
390: );
391: hr_utility.set_location(l_proc,20);

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 408: pay_bth_shd.constraint_error('PAY_BCH_BATCH_STATUS_CHK');

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');
409: end if;
410: --
411: end if;
412: --

Line 473: l_api_updating := pay_bth_shd.api_updating

469: );
470: --
471: hr_utility.set_location(l_proc, 10);
472: --
473: l_api_updating := pay_bth_shd.api_updating
474: (p_batch_id => p_batch_id,
475: p_object_version_number => p_object_version_number
476: );
477: hr_utility.set_location(l_proc,20);

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 498: pay_bth_shd.constraint_error('PAY_BCH_ACTION_IF_EXISTS_CHK');

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');
499: end if;
500: --
501: end if;
502: --

Line 565: l_api_updating := pay_bth_shd.api_updating

561: );
562: --
563: hr_utility.set_location(l_proc, 10);
564: --
565: l_api_updating := pay_bth_shd.api_updating
566: (p_batch_id => p_batch_id,
567: p_object_version_number => p_object_version_number
568: );
569: hr_utility.set_location(l_proc,20);

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 590: pay_bth_shd.constraint_error('PAY_BCH_PURGE_AFTER_TRANSF_CHK');

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');
591: end if;
592: --
593: end if;
594: --

Line 657: l_api_updating := pay_bth_shd.api_updating

653: );
654: --
655: hr_utility.set_location(l_proc, 10);
656: --
657: l_api_updating := pay_bth_shd.api_updating
658: (p_batch_id => p_batch_id,
659: p_object_version_number => p_object_version_number
660: );
661: hr_utility.set_location(l_proc,20);

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 682: pay_bth_shd.constraint_error('PAY_BCH_REJECT_IF_FUTURE_C_CHK');

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');
683: end if;
684: --
685: end if;
686: --

Line 749: l_api_updating := pay_bth_shd.api_updating

745: );
746: --
747: hr_utility.set_location(l_proc, 10);
748: --
749: l_api_updating := pay_bth_shd.api_updating
750: (p_batch_id => p_batch_id,
751: p_object_version_number => p_object_version_number
752: );
753: hr_utility.set_location(l_proc,20);

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 774: pay_bth_shd.constraint_error('PAY_BCH_REJECT_IF_RESULTS_E_CHK');

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');
775: end if;
776: --
777: end if;
778: --

Line 841: l_api_updating := pay_bth_shd.api_updating

837: );
838: --
839: hr_utility.set_location(l_proc, 10);
840: --
841: l_api_updating := pay_bth_shd.api_updating
842: (p_batch_id => p_batch_id,
843: p_object_version_number => p_object_version_number
844: );
845: hr_utility.set_location(l_proc,20);

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 866: pay_bth_shd.constraint_error('PAY_BCH_PURGE_AFTER_R_CHK');

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');
867: end if;
868: --
869: end if;
870: --

Line 934: l_api_updating := pay_bth_shd.api_updating

930: );
931: --
932: hr_utility.set_location(l_proc, 10);
933: --
934: l_api_updating := pay_bth_shd.api_updating
935: (p_batch_id => p_batch_id,
936: p_object_version_number => p_object_version_number
937: );
938: hr_utility.set_location(l_proc,20);

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 959: pay_bth_shd.constraint_error('PAY_BCH_DATE_EFFECTIVE_CHA_CHK');

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');
960: end if;
961: --
962: end if;
963: --

Line 970: pay_bth_shd.constraint_error('PAY_BCH_DATE_EFFECTIVE_CHA_CHK');

966: if (((p_reject_if_future_changes <> 'N' or p_action_if_exists <> 'U') and p_date_effective_changes = 'O')
967: or (p_action_if_exists = 'U' and p_date_effective_changes not in ('O','C','U'))
968: or (p_action_if_exists <> 'U' and p_date_effective_changes in ('O','C','U'))) then
969: --
970: pay_bth_shd.constraint_error('PAY_BCH_DATE_EFFECTIVE_CHA_CHK');
971: --
972: end if;
973: --
974: hr_utility.set_location(' Leaving:'||l_proc, 40);

Line 1104: p_rec in pay_bth_shd.g_rec_type

1100: -- |---------------------------< insert_validate >----------------------------|
1101: -- ----------------------------------------------------------------------------
1102: Procedure insert_validate
1103: (p_session_date in date,
1104: p_rec in pay_bth_shd.g_rec_type
1105: ) is
1106: --
1107: l_proc varchar2(72) := g_package||'insert_validate';
1108: --

Line 1165: p_rec in pay_bth_shd.g_rec_type

1161: -- |---------------------------< update_validate >----------------------------|
1162: -- ----------------------------------------------------------------------------
1163: Procedure update_validate
1164: (p_session_date in date,
1165: p_rec in pay_bth_shd.g_rec_type
1166: ) is
1167: --
1168: l_proc varchar2(72) := g_package||'update_validate';
1169: --

Line 1234: (p_rec in pay_bth_shd.g_rec_type

1230: -- ----------------------------------------------------------------------------
1231: -- |---------------------------< delete_validate >----------------------------|
1232: -- ----------------------------------------------------------------------------
1233: Procedure delete_validate
1234: (p_rec in pay_bth_shd.g_rec_type
1235: ) is
1236: --
1237: l_proc varchar2(72) := g_package||'delete_validate';
1238: --