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_BALANCE_TYPES_PKG dependencies on PAY_BALANCE_TYPES_PKG

Line 1: PACKAGE BODY PAY_BALANCE_TYPES_PKG as

1: PACKAGE BODY PAY_BALANCE_TYPES_PKG as
2: /* $Header: pyblt01t.pkb 120.1 2005/11/07 09:45:38 arashid noship $ */
3: --
4: -- dummy variable for values returned from cursors that are not needed
5: --

Line 59: l_package_name VARCHAR2(80) := 'PAY_BALANCE_TYPES_PKG.VALIDATE_TRANSLATION';

55: AND ( g_business_group_id = bt.business_group_id + 0 OR g_business_group_id is null )
56: AND ( g_legislation_code = bt.legislation_code OR g_legislation_code is null );
57:
58:
59: l_package_name VARCHAR2(80) := 'PAY_BALANCE_TYPES_PKG.VALIDATE_TRANSLATION';
60: l_name pay_balance_types.balance_name%type := balance_name;
61: l_dummy varchar2(100);
62:
63: BEGIN

Line 138: l_proc varchar2(72) := 'pay_balance_types_pkg.chk_balance_category';

134: ,p_business_group_id number default null
135: )
136: return boolean is
137: --
138: l_proc varchar2(72) := 'pay_balance_types_pkg.chk_balance_category';
139: l_leg_code pay_balance_types.legislation_code%type;
140: --
141: cursor get_legislation(p_bg_id number)
142: is

Line 485: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);

481: ,x_business_group_id) then
482: --
483: if x_balance_category_id is null then
484: --
485: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);
486: hr_utility.set_message(801, 'PAY_34261_CAT_IS_MANDATORY');
487: hr_utility.raise_error;
488: --
489: end if;

Line 608: 'pay_balance_types_pkg.insert_row');

604: if (C%NOTFOUND) then
605: CLOSE C;
606: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
607: hr_utility.set_message_token('PROCEDURE',
608: 'pay_balance_types_pkg.insert_row');
609: hr_utility.set_message_token('STEP','1');
610: hr_utility.raise_error;
611: end if;
612: CLOSE C;

Line 698: 'pay_balance_types_pkg.lock_row');

694: if (C%NOTFOUND) then
695: CLOSE C;
696: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
697: hr_utility.set_message_token('PROCEDURE',
698: 'pay_balance_types_pkg.lock_row');
699: hr_utility.set_message_token('STEP','1');
700: hr_utility.raise_error;
701: end if;
702: CLOSE C;

Line 730: -- hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.LOCK_TL_ROW');

726: --
727: --if (l_mls_count=0) then -- Trap system errors
728: -- close csr_balance_type_tl;
729: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
730: -- hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.LOCK_TL_ROW');
731: --end if;
732: --
733: -- ***************************************************************************
734: -- Remove trailing spaces.

Line 958: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);

954: ,x_business_group_id) then
955: --
956: if x_balance_category_id is null then
957: --
958: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);
959: hr_utility.set_message(801, 'PAY_34261_CAT_IS_MANDATORY');
960: hr_utility.raise_error;
961: --
962: end if;

Line 1008: 'pay_balance_types_pkg.update_row');

1004: --
1005: if (SQL%NOTFOUND) then
1006: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1007: hr_utility.set_message_token('PROCEDURE',
1008: 'pay_balance_types_pkg.update_row');
1009: hr_utility.set_message_token('STEP','1');
1010: hr_utility.raise_error;
1011: end if;
1012: --

Line 1028: hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.UPDATE_TL_ROW');

1024: --
1025: --
1026: if (sql%notfound) then -- trap system errors during update
1027: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1028: hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.UPDATE_TL_ROW');
1029: end if;
1030: --
1031: -- ***************************************************************************************
1032: --

Line 1062: 'pay_balance_types_pkg.delete_row');

1058: --
1059: if (SQL%NOTFOUND) then
1060: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1061: hr_utility.set_message_token('PROCEDURE',
1062: 'pay_balance_types_pkg.delete_row');
1063: hr_utility.set_message_token('STEP','1');
1064: hr_utility.raise_error;
1065: end if;
1066: --

Line 1083: hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.DELETE_TL_ROW');

1079: where BALANCE_TYPE_ID = X_BALANCE_TYPE_ID;
1080: --
1081: if sql%notfound then -- trap system errors during deletion
1082: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1083: hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.DELETE_TL_ROW');
1084: end if;
1085:
1086: --end if;
1087: --

Line 1174: hr_utility.set_message_token('PROCEDURE','PAY_BALANCE_TYPES_PKG.UNIQUE_CHK');

1170: and BUSINESS_GROUP_ID is NULL;
1171: --
1172: IF (result>1) THEN
1173: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1174: hr_utility.set_message_token('PROCEDURE','PAY_BALANCE_TYPES_PKG.UNIQUE_CHK');
1175: hr_utility.set_message_token('STEP','1');
1176: hr_utility.raise_error;
1177: END IF;
1178: EXCEPTION

Line 1181: hr_utility.set_message_token('PROCEDURE','PAY_BALANCE_TYPES_PKG.UNIQUE_CHK');

1177: END IF;
1178: EXCEPTION
1179: when NO_DATA_FOUND then
1180: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1181: hr_utility.set_message_token('PROCEDURE','PAY_BALANCE_TYPES_PKG.UNIQUE_CHK');
1182: hr_utility.set_message_token('STEP','1');
1183: hr_utility.raise_error;
1184: end unique_chk;
1185: --------------------------------------------------------------------------------

Line 1276: END PAY_BALANCE_TYPES_PKG;

1272: end if;
1273: end if;
1274: end TRANSLATE_ROW;
1275: --------------------------------------------------------------------------------
1276: END PAY_BALANCE_TYPES_PKG;