DBA Data[Home] [Help]

APPS.PAY_GBE_BUS dependencies on PAY_GBE_SHD

Line 188: (p_rec in pay_gbe_shd.g_rec_type

184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure chk_non_updateable_args
188: (p_rec in pay_gbe_shd.g_rec_type
189: ) IS
190: --
191: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
192: l_error EXCEPTION;

Line 200: IF NOT pay_gbe_shd.api_updating

196: --
197: -- Only proceed with the validation if a row exists for the current
198: -- record in the HR Schema.
199: --
200: IF NOT pay_gbe_shd.api_updating
201: (p_grossup_balances_id => p_rec.grossup_balances_id
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 214: nvl(pay_gbe_shd.g_old_rec.grossup_balances_id, hr_api.g_number) then

210: -- EDIT_HERE: Add checks to ensure non-updateable args have
211: -- not been updated.
212: --
213: if nvl(p_rec.grossup_balances_id, hr_api.g_number) <>
214: nvl(pay_gbe_shd.g_old_rec.grossup_balances_id, hr_api.g_number) then
215: l_argument := 'grossup_balances_id';
216: raise l_error;
217: end if;
218: hr_utility.set_location(l_proc, 7);

Line 304: l_api_updating := pay_gbe_shd.api_updating (

300: hr_utility.raise_error;
301: --
302: END IF;
303: --
304: l_api_updating := pay_gbe_shd.api_updating (
305: p_grossup_balances_id => p_grossup_balances_id
306: ,p_object_version_number => p_object_version_number );
307: --
308: if (l_api_updating

Line 478: pay_gbe_shd.constraint_error(p_constraint_name => 'PAY_GBE_SOURCE_TYPE_CHK');

474: ,p_argument_value => p_source_id
475: );
476: --
477: if (p_source_type not in ('EE', 'ET') ) then
478: pay_gbe_shd.constraint_error(p_constraint_name => 'PAY_GBE_SOURCE_TYPE_CHK');
479: end if;
480: --
481: if (p_source_type = 'EE') then
482: open C_ee;

Line 558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');

554: if C1%notfound then
555: hr_utility.set_location(l_proc, 3);
556: close C1;
557: -- raise error as FK does not relate to PK in pay_balance_types
558: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_FK1');
559: end if;
560: close C1;
561: hr_utility.set_location('Leaving:'|| l_proc, 10);
562: end chk_bal_type_id;

Line 621: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_UK1');

617: if C1%found then
618: hr_utility.set_location(l_proc, 3);
619: -- row is not unique
620: close C1;
621: pay_gbe_shd.constraint_error('PAY_GROSSUP_BAL_EXCLUSIONS_UK1');
622: end if;
623: close C1;
624: --
625: hr_utility.set_location('Leaving:'|| l_proc, 10);

Line 633: (p_rec in pay_gbe_shd.g_rec_type

629: -- ----------------------------------------------------------------------------
630: -- |---------------------------< insert_validate >----------------------------|
631: -- ----------------------------------------------------------------------------
632: Procedure insert_validate
633: (p_rec in pay_gbe_shd.g_rec_type
634: ) is
635: --
636: l_proc varchar2(72) := g_package||'insert_validate';
637: --

Line 670: (p_rec in pay_gbe_shd.g_rec_type

666: -- ----------------------------------------------------------------------------
667: -- |---------------------------< update_validate >----------------------------|
668: -- ----------------------------------------------------------------------------
669: Procedure update_validate
670: (p_rec in pay_gbe_shd.g_rec_type
671: ) is
672: --
673: l_proc varchar2(72) := g_package||'update_validate';
674: --

Line 711: (p_rec in pay_gbe_shd.g_rec_type

707: -- ----------------------------------------------------------------------------
708: -- |---------------------------< delete_validate >----------------------------|
709: -- ----------------------------------------------------------------------------
710: Procedure delete_validate
711: (p_rec in pay_gbe_shd.g_rec_type
712: ) is
713: --
714: l_proc varchar2(72) := g_package||'delete_validate';
715: --