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.2 2011/01/09 18:14:00 priupadh ship $ */
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 490: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);

486: ,x_business_group_id) then
487: --
488: if x_balance_category_id is null then
489: --
490: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);
491: hr_utility.set_message(801, 'PAY_34261_CAT_IS_MANDATORY');
492: hr_utility.raise_error;
493: --
494: end if;

Line 613: 'pay_balance_types_pkg.insert_row');

609: if (C%NOTFOUND) then
610: CLOSE C;
611: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
612: hr_utility.set_message_token('PROCEDURE',
613: 'pay_balance_types_pkg.insert_row');
614: hr_utility.set_message_token('STEP','1');
615: hr_utility.raise_error;
616: end if;
617: CLOSE C;

Line 703: 'pay_balance_types_pkg.lock_row');

699: if (C%NOTFOUND) then
700: CLOSE C;
701: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
702: hr_utility.set_message_token('PROCEDURE',
703: 'pay_balance_types_pkg.lock_row');
704: hr_utility.set_message_token('STEP','1');
705: hr_utility.raise_error;
706: end if;
707: CLOSE C;

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

731: --
732: --if (l_mls_count=0) then -- Trap system errors
733: -- close csr_balance_type_tl;
734: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
735: -- hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.LOCK_TL_ROW');
736: --end if;
737: --
738: -- ***************************************************************************
739: -- Remove trailing spaces.

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

959: ,x_business_group_id) then
960: --
961: if x_balance_category_id is null then
962: --
963: hr_utility.set_location('pay_balance_types_pkg.insert_row', 10);
964: hr_utility.set_message(801, 'PAY_34261_CAT_IS_MANDATORY');
965: hr_utility.raise_error;
966: --
967: end if;

Line 1013: 'pay_balance_types_pkg.update_row');

1009: --
1010: if (SQL%NOTFOUND) then
1011: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1012: hr_utility.set_message_token('PROCEDURE',
1013: 'pay_balance_types_pkg.update_row');
1014: hr_utility.set_message_token('STEP','1');
1015: hr_utility.raise_error;
1016: end if;
1017: --

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

1029: --
1030: --
1031: if (sql%notfound) then -- trap system errors during update
1032: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1033: hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.UPDATE_TL_ROW');
1034: end if;
1035: --
1036: -- ***************************************************************************************
1037: --

Line 1067: 'pay_balance_types_pkg.delete_row');

1063: --
1064: if (SQL%NOTFOUND) then
1065: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1066: hr_utility.set_message_token('PROCEDURE',
1067: 'pay_balance_types_pkg.delete_row');
1068: hr_utility.set_message_token('STEP','1');
1069: hr_utility.raise_error;
1070: end if;
1071: --

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

1084: where BALANCE_TYPE_ID = X_BALANCE_TYPE_ID;
1085: --
1086: if sql%notfound then -- trap system errors during deletion
1087: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
1088: hr_utility.set_message_token ('PROCEDURE','PAY_BALANCE_TYPES_PKG.DELETE_TL_ROW');
1089: end if;
1090:
1091: --end if;
1092: --

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

1175: and BUSINESS_GROUP_ID is NULL;
1176: --
1177: IF (result>1) THEN
1178: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1179: hr_utility.set_message_token('PROCEDURE','PAY_BALANCE_TYPES_PKG.UNIQUE_CHK');
1180: hr_utility.set_message_token('STEP','1');
1181: hr_utility.raise_error;
1182: END IF;
1183: EXCEPTION

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

1182: END IF;
1183: EXCEPTION
1184: when NO_DATA_FOUND then
1185: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1186: hr_utility.set_message_token('PROCEDURE','PAY_BALANCE_TYPES_PKG.UNIQUE_CHK');
1187: hr_utility.set_message_token('STEP','1');
1188: hr_utility.raise_error;
1189: end unique_chk;
1190: --------------------------------------------------------------------------------

Line 1281: END PAY_BALANCE_TYPES_PKG;

1277: end if;
1278: end if;
1279: end TRANSLATE_ROW;
1280: --------------------------------------------------------------------------------
1281: END PAY_BALANCE_TYPES_PKG;