eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ACCRUAL_PLANS_PKG dependencies on HR_UTILITY

Line 245: hr_utility.set_message(801, 'HR_13163_PTO_DUP_PLAN_NAME');

241: --
242: -- go ahead and check the value of the local variable
243: --
244: IF (l_comb_exists = 'Y') THEN
245: hr_utility.set_message(801, 'HR_13163_PTO_DUP_PLAN_NAME');
246: hr_utility.raise_error;
247: END IF;
248: --
249: --

Line 246: hr_utility.raise_error;

242: -- go ahead and check the value of the local variable
243: --
244: IF (l_comb_exists = 'Y') THEN
245: hr_utility.set_message(801, 'HR_13163_PTO_DUP_PLAN_NAME');
246: hr_utility.raise_error;
247: END IF;
248: --
249: --
250: l_comb_exists := 'N';

Line 260: hr_utility.set_message(801, 'HR_13164_PTO_INVALID_PLAN_NAME');

256: FETCH dup_rec2 INTO l_comb_exists;
257: CLOSE dup_rec2;
258: --
259: IF (l_comb_exists = 'Y') THEN
260: hr_utility.set_message(801, 'HR_13164_PTO_INVALID_PLAN_NAME');
261: hr_utility.raise_error;
262: END IF;
263: --
264: END chk_plan_name;

Line 261: hr_utility.raise_error;

257: CLOSE dup_rec2;
258: --
259: IF (l_comb_exists = 'Y') THEN
260: hr_utility.set_message(801, 'HR_13164_PTO_INVALID_PLAN_NAME');
261: hr_utility.raise_error;
262: END IF;
263: --
264: END chk_plan_name;
265: --

Line 319: hr_utility.set_location('pay_accrual_plans_pkg.create_element',1);

315: l_effective_end_date date;
316: l_element_type_id number;
317: BEGIN
318: --
319: hr_utility.set_location('pay_accrual_plans_pkg.create_element',1);
320: l_effective_start_date := hr_general.start_of_time;
321: l_effective_end_date := hr_general.end_of_time;
322: --
323: l_element_type_id := PAY_DB_PAY_SETUP.create_element

Line 395: hr_utility.set_location('pay_accrual_plans_pkg.create_input_value',1);

391: l_input_value_id number;
392: --
393: BEGIN
394: --
395: hr_utility.set_location('pay_accrual_plans_pkg.create_input_value',1);
396: l_effective_start_date := hr_general.start_of_time;
397: l_effective_end_date := hr_general.end_of_time;
398: --
399: l_input_value_id := pay_db_pay_setup.create_input_value(

Line 518: hr_utility.set_location

514: order by decode (classification_name, 'Information', 1, 2),
515: nvl (non_payments_flag, 'X') desc, classification_name;
516: --
517: BEGIN
518: hr_utility.set_location
519: ('pay_accrual_plans_pkg.pre_insert_actions',1);
520: --
521: -- create the accrual plan element type and input value...
522: --

Line 563: hr_utility.set_message(801,'HR_NO_F_TERM_RULE');

559: where hl.lookup_type='TERMINATION_RULE'
560: and hl.lookup_code='F';
561: exception
562: when no_data_found then
563: hr_utility.set_message(801,'HR_NO_F_TERM_RULE');
564: hr_utility.raise_error;
565: end;
566: --
567: l_element_name := p_plan_name;

Line 564: hr_utility.raise_error;

560: and hl.lookup_code='F';
561: exception
562: when no_data_found then
563: hr_utility.set_message(801,'HR_NO_F_TERM_RULE');
564: hr_utility.raise_error;
565: end;
566: --
567: l_element_name := p_plan_name;
568: l_element_description := 'Accrual plan for ' || l_element_name;

Line 716: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',1);

712: BEGIN
713: --
714: -- insert the pto input value (always reduces entitlement)
715: --
716: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',1);
717: insert into pay_net_calculation_rules(
718: net_calculation_rule_id,
719: accrual_plan_id,
720: business_group_id,

Line 733: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',2);

729: from dual;
730: --
731: -- insert the carried over input value (always increases entitlement)
732: --
733: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',2);
734: insert into pay_net_calculation_rules(
735: net_calculation_rule_id,
736: accrual_plan_id,
737: business_group_id,

Line 748: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',3);

744: p_co_input_value_id,
745: 1
746: from dual;
747: --
748: hr_utility.set_location('pay_accrual_plans_pkg.post_insert_actions',3);
749: --
750: -- The update below was originally written as a separate implicit SELECT
751: -- and UPDATE. Changed to a single UPDATE, because non-US accrual plans
752: -- create all element as non-payment, hence have no PAY INPUT VALUE. The

Line 821: hr_utility.set_location('pay_accrual_plans_pkg.post_update_actions',1);

817: if p_pto_input_value_id <> p_old_pto_input_value_id then
818: --
819: -- delete the old pto input value from the net calculation rules
820: --
821: hr_utility.set_location('pay_accrual_plans_pkg.post_update_actions',1);
822: delete from pay_net_calculation_rules
823: where input_value_id = p_old_pto_input_value_id
824: and accrual_plan_id = p_accrual_plan_id;
825: --

Line 829: hr_utility.set_location('pay_accrual_plans_pkg.post_update_actions',2);

825: --
826: -- create a new net calculation rule for the new pto input value if one
827: -- does not already exist
828: --
829: hr_utility.set_location('pay_accrual_plans_pkg.post_update_actions',2);
830: insert into pay_net_calculation_rules(
831: net_calculation_rule_id,
832: accrual_plan_id,
833: business_group_id,

Line 884: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 1);

880: --
881: --
882: -- delete the accrual bands
883: --
884: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 1);
885: delete from pay_accrual_bands
886: where accrual_plan_id = p_accrual_plan_id;
887: --
888: -- delete the net calculation rules

Line 890: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 2);

886: where accrual_plan_id = p_accrual_plan_id;
887: --
888: -- delete the net calculation rules
889: --
890: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 2);
891: delete from pay_net_calculation_rules
892: where accrual_plan_id = p_accrual_plan_id;
893: --
894: -- delete the element types created for the plan

Line 898: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 3);

894: -- delete the element types created for the plan
895: --
896: -- first the accrual plan element type...
897: --
898: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 3);
899: hr_elements.chk_del_element_type (
900: 'ZAP',
901: p_accrual_plan_element_type_id,
902: '',

Line 907: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 4);

903: p_session_date,
904: l_effective_start_date,
905: l_effective_end_date);
906: --
907: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 4);
908: hr_elements.del_3p_element_type (
909: p_accrual_plan_element_type_id,
910: 'ZAP',
911: p_session_date,

Line 916: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',5);

912: l_effective_start_date,
913: l_effective_end_date,
914: '');
915: --
916: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',5);
917: delete from pay_element_types_f
918: where element_type_id = p_accrual_plan_element_type_id;
919: --
920: --

Line 924: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 6);

920: --
921: -- ...then the carried over element type...
922: --
923: --
924: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 6);
925: hr_elements.chk_del_element_type (
926: 'ZAP',
927: p_co_element_type_id,
928: '',

Line 933: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 7);

929: p_session_date,
930: l_effective_start_date,
931: l_effective_end_date);
932: --
933: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 7);
934: hr_elements.del_3p_element_type (
935: p_co_element_type_id,
936: 'ZAP',
937: p_session_date,

Line 942: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',8);

938: l_effective_start_date,
939: l_effective_end_date,
940: '');
941: --
942: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions',8);
943: delete from pay_element_types_f
944: where element_type_id = p_co_element_type_id;
945: --
946: --

Line 950: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 9);

946: --
947: -- ...then the residual element type.
948: --
949: --
950: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 9);
951: hr_elements.chk_del_element_type (
952: 'ZAP',
953: p_residual_element_type_id,
954: '',

Line 959: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 10);

955: p_session_date,
956: l_effective_start_date,
957: l_effective_end_date);
958: --
959: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 10);
960: hr_elements.del_3p_element_type (
961: p_residual_element_type_id,
962: 'ZAP',
963: p_session_date,

Line 968: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 11);

964: l_effective_start_date,
965: l_effective_end_date,
966: '');
967: --
968: hr_utility.set_location('pay_accrual_plans_pkg.pre_delete_actions', 11);
969: delete from pay_element_types_f
970: where element_type_id = p_residual_element_type_id;
971: --
972: END pre_delete_actions;