[Home] [Help]
44: raised. This prevents users from
45: creating elements with reserved
46: words as names.
47: 05-APR-00 RThirlby 115.6 Added call to new procedure
48: pay_ca_user_init_earn.update_jd_level-
49: _on_balance. This updates jurisdiction_
50: level on pay_balance_types for all
51: balances. Call added to create user-
52: _init_deduction. NB. THIS WILL NEED TO
313: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',2);
314: --
315: ---------------------------- Check Element Name ---------------------------
316: --
317: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',25);
318: --
319: BEGIN
320: select 'Y'
321: into l_reserved
329:
330: END;
331: --
332: if l_reserved = 'Y' then
333: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',26);
334: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
335: hr_utility.raise_error;
336: end if;
337: --
640: -- Added update for jurisdiction level, this needs to be set for all balances
641: -- to '2'. This is currently a hardcoded update to base table as the balance
642: -- apis do not support jurisdiction_level.
643: --
644: pay_ca_user_init_earn.update_jd_level_on_balance(l_template_id);
645: --
646: ------------------ Conclude Create_User_Init_Deduction Main -----------------
647: --
648: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',18);
826: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',2);
827: --
828: ---------------------------- Check Element Name ---------------------------
829: --
830: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',25);
831: --
832: BEGIN
833: select 'Y'
834: into l_reserved
842:
843: END;
844: --
845: if l_reserved = 'Y' then
846: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',26);
847:
848: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
849: hr_utility.raise_error;
850: end if;
1220: -- Added update for jurisdiction level, this needs to be set for all balances
1221: -- to '2'. This is currently a hardcoded update to base table as the balance
1222: -- apis do not support jurisdiction_level.
1223: --
1224: pay_ca_user_init_earn.update_jd_level_on_balance(l_template_id);
1225: --
1226: ------------------ Conclude Create_User_Init_Deduction Main -----------------
1227: --
1228: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',18);