[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
316: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',2);
317: --
318: ---------------------------- Check Element Name ---------------------------
319: --
320: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',25);
321: --
322: BEGIN
323: select 'Y'
324: into l_reserved
332:
333: END;
334: --
335: if l_reserved = 'Y' then
336: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_deduction',26);
337: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
338: hr_utility.raise_error;
339: end if;
340: --
643: -- Added update for jurisdiction level, this needs to be set for all balances
644: -- to '2'. This is currently a hardcoded update to base table as the balance
645: -- apis do not support jurisdiction_level.
646: --
647: pay_ca_user_init_earn.update_jd_level_on_balance(l_template_id);
648: --
649: ------------------ Conclude Create_User_Init_Deduction Main -----------------
650: --
651: hr_utility.set_location('pay_ca_user_init_dedn.create_user_init_deduction',18);
829: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',2);
830: --
831: ---------------------------- Check Element Name ---------------------------
832: --
833: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',25);
834: --
835: BEGIN
836: select 'Y'
837: into l_reserved
845:
846: END;
847: --
848: if l_reserved = 'Y' then
849: hr_utility.set_location('pay_ca_user_init_earn.create_user_init_garnishment',26);
850:
851: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
852: hr_utility.raise_error;
853: end if;
1223: -- Added update for jurisdiction level, this needs to be set for all balances
1224: -- to '2'. This is currently a hardcoded update to base table as the balance
1225: -- apis do not support jurisdiction_level.
1226: --
1227: pay_ca_user_init_earn.update_jd_level_on_balance(l_template_id);
1228: --
1229: ------------------ Conclude Create_User_Init_Deduction Main -----------------
1230: --
1231: hr_utility.set_location('pay_ca_user_init_garn.create_user_init_garnishment',18);