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.

[Home] [Help]

APPS.PAY_BALANCE_TYPES_PKG dependencies on HR_UTILITY

Line 64: hr_utility.set_location (l_package_name,1);

60: l_name pay_balance_types.balance_name%type := balance_name;
61: l_dummy varchar2(100);
62:
63: BEGIN
64: hr_utility.set_location (l_package_name,1);
65:
66: BEGIN
67: hr_chkfmt.checkformat (l_name,
68: 'PAY_NAME',

Line 70: hr_utility.set_location (l_package_name,2);

66: BEGIN
67: hr_chkfmt.checkformat (l_name,
68: 'PAY_NAME',
69: l_dummy, null, null, 'N', l_dummy, null);
70: hr_utility.set_location (l_package_name,2);
71:
72: EXCEPTION
73: when app_exception.application_exception then
74: hr_utility.set_location (l_package_name,3);

Line 74: hr_utility.set_location (l_package_name,3);

70: hr_utility.set_location (l_package_name,2);
71:
72: EXCEPTION
73: when app_exception.application_exception then
74: hr_utility.set_location (l_package_name,3);
75: fnd_message.set_name ('PAY','PAY_6365_ELEMENT_NO_DB_NAME'); -- checkformat failure
76: fnd_message.raise_error;
77: END;
78:

Line 79: hr_utility.set_location (l_package_name,10);

75: fnd_message.set_name ('PAY','PAY_6365_ELEMENT_NO_DB_NAME'); -- checkformat failure
76: fnd_message.raise_error;
77: END;
78:
79: hr_utility.set_location (l_package_name,10);
80: OPEN c_translation(language
81: , balance_name
82: , reporting_name
83: , balance_type_id

Line 85: hr_utility.set_location (l_package_name,20);

81: , balance_name
82: , reporting_name
83: , balance_type_id
84: , 'BALANCE_NAME');
85: hr_utility.set_location (l_package_name,20);
86:
87: FETCH c_translation INTO g_dummy_number;
88: hr_utility.set_location (l_package_name,25);
89:

Line 88: hr_utility.set_location (l_package_name,25);

84: , 'BALANCE_NAME');
85: hr_utility.set_location (l_package_name,20);
86:
87: FETCH c_translation INTO g_dummy_number;
88: hr_utility.set_location (l_package_name,25);
89:
90: IF c_translation%NOTFOUND THEN
91: hr_utility.set_location (l_package_name,30);
92: CLOSE c_translation;

Line 91: hr_utility.set_location (l_package_name,30);

87: FETCH c_translation INTO g_dummy_number;
88: hr_utility.set_location (l_package_name,25);
89:
90: IF c_translation%NOTFOUND THEN
91: hr_utility.set_location (l_package_name,30);
92: CLOSE c_translation;
93: ELSE
94: hr_utility.set_location (l_package_name,40);
95: CLOSE c_translation;

Line 94: hr_utility.set_location (l_package_name,40);

90: IF c_translation%NOTFOUND THEN
91: hr_utility.set_location (l_package_name,30);
92: CLOSE c_translation;
93: ELSE
94: hr_utility.set_location (l_package_name,40);
95: CLOSE c_translation;
96: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
97: fnd_message.raise_error;
98: END IF;

Line 105: hr_utility.set_location (l_package_name,50);

101: , balance_name
102: , reporting_name
103: , balance_type_id
104: , 'REPORTING_NAME');
105: hr_utility.set_location (l_package_name,50);
106: FETCH c_translation INTO g_dummy_number;
107: hr_utility.set_location (l_package_name,55);
108:
109: IF c_translation%NOTFOUND THEN

Line 107: hr_utility.set_location (l_package_name,55);

103: , balance_type_id
104: , 'REPORTING_NAME');
105: hr_utility.set_location (l_package_name,50);
106: FETCH c_translation INTO g_dummy_number;
107: hr_utility.set_location (l_package_name,55);
108:
109: IF c_translation%NOTFOUND THEN
110: hr_utility.set_location (l_package_name,60);
111: CLOSE c_translation;

Line 110: hr_utility.set_location (l_package_name,60);

106: FETCH c_translation INTO g_dummy_number;
107: hr_utility.set_location (l_package_name,55);
108:
109: IF c_translation%NOTFOUND THEN
110: hr_utility.set_location (l_package_name,60);
111: CLOSE c_translation;
112: ELSE
113: hr_utility.set_location (l_package_name,70);
114: CLOSE c_translation;

Line 113: hr_utility.set_location (l_package_name,70);

109: IF c_translation%NOTFOUND THEN
110: hr_utility.set_location (l_package_name,60);
111: CLOSE c_translation;
112: ELSE
113: hr_utility.set_location (l_package_name,70);
114: CLOSE c_translation;
115: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
116: fnd_message.raise_error;
117: END IF;

Line 119: hr_utility.set_location ('Leaving: '||l_package_name,140);

115: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
116: fnd_message.raise_error;
117: END IF;
118:
119: hr_utility.set_location ('Leaving: '||l_package_name,140);
120: END validate_translation;
121:
122: -----------------------------------------------------------------------------
123: -- Name

Line 157: hr_utility.set_location('Entering '||l_proc, 5);

153: --
154: l_rule_mode pay_legislation_rules.rule_mode%type;
155: --
156: begin
157: hr_utility.set_location('Entering '||l_proc, 5);
158: --
159: hr_utility.trace('leg code '||p_legislation_code);
160: hr_utility.trace('bg: '||to_char(p_business_group_id));
161: if p_legislation_code is null then

Line 159: hr_utility.trace('leg code '||p_legislation_code);

155: --
156: begin
157: hr_utility.set_location('Entering '||l_proc, 5);
158: --
159: hr_utility.trace('leg code '||p_legislation_code);
160: hr_utility.trace('bg: '||to_char(p_business_group_id));
161: if p_legislation_code is null then
162: if p_business_group_id is not null then
163: open get_legislation(p_business_group_id);

Line 160: hr_utility.trace('bg: '||to_char(p_business_group_id));

156: begin
157: hr_utility.set_location('Entering '||l_proc, 5);
158: --
159: hr_utility.trace('leg code '||p_legislation_code);
160: hr_utility.trace('bg: '||to_char(p_business_group_id));
161: if p_legislation_code is null then
162: if p_business_group_id is not null then
163: open get_legislation(p_business_group_id);
164: fetch get_legislation into l_leg_code;

Line 168: hr_utility.set_location(l_proc, 10);

164: fetch get_legislation into l_leg_code;
165: if get_legislation%notfound then
166: --
167: close get_legislation;
168: hr_utility.set_location(l_proc, 10);
169: hr_utility.set_message(801, 'PAY_34260_BG_HAS_NO_LEG');
170: hr_utility.raise_error;
171: --
172: else

Line 169: hr_utility.set_message(801, 'PAY_34260_BG_HAS_NO_LEG');

165: if get_legislation%notfound then
166: --
167: close get_legislation;
168: hr_utility.set_location(l_proc, 10);
169: hr_utility.set_message(801, 'PAY_34260_BG_HAS_NO_LEG');
170: hr_utility.raise_error;
171: --
172: else
173: hr_utility.set_location(l_proc, 15);

Line 170: hr_utility.raise_error;

166: --
167: close get_legislation;
168: hr_utility.set_location(l_proc, 10);
169: hr_utility.set_message(801, 'PAY_34260_BG_HAS_NO_LEG');
170: hr_utility.raise_error;
171: --
172: else
173: hr_utility.set_location(l_proc, 15);
174: close get_legislation;

Line 173: hr_utility.set_location(l_proc, 15);

169: hr_utility.set_message(801, 'PAY_34260_BG_HAS_NO_LEG');
170: hr_utility.raise_error;
171: --
172: else
173: hr_utility.set_location(l_proc, 15);
174: close get_legislation;
175: end if;
176: else -- bg is null, so global row being checked, category cannot be mandatory
177: hr_utility.set_location(l_proc, 20);

Line 177: hr_utility.set_location(l_proc, 20);

173: hr_utility.set_location(l_proc, 15);
174: close get_legislation;
175: end if;
176: else -- bg is null, so global row being checked, category cannot be mandatory
177: hr_utility.set_location(l_proc, 20);
178: return false;
179: end if;
180: else -- p_legislation is not null
181: hr_utility.set_location(l_proc, 25);

Line 181: hr_utility.set_location(l_proc, 25);

177: hr_utility.set_location(l_proc, 20);
178: return false;
179: end if;
180: else -- p_legislation is not null
181: hr_utility.set_location(l_proc, 25);
182: l_leg_code := p_legislation_code;
183: end if;
184: --
185: -- check the legislation_rule BAL_CATEGORY_MANDATORY

Line 192: hr_utility.set_location(l_proc, 30);

188: fetch get_leg_rule into l_rule_mode;
189: if get_leg_rule%notfound
190: or l_rule_mode = 'N' then
191: --
192: hr_utility.set_location(l_proc, 30);
193: close get_leg_rule;
194: return false;
195: --
196: else

Line 197: hr_utility.set_location(l_proc, 35);

193: close get_leg_rule;
194: return false;
195: --
196: else
197: hr_utility.set_location(l_proc, 35);
198: close get_leg_rule;
199: return true;
200: end if;
201: end chk_balance_category_rule;

Line 285: when hr_utility.hr_error then

281: 'N',
282: v_result_text,
283: null);
284: exception
285: when hr_utility.hr_error then
286: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');
287: hr_utility.set_message_token('VALUE_NAME', 'This');
288: raise;
289: end;

Line 286: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');

282: v_result_text,
283: null);
284: exception
285: when hr_utility.hr_error then
286: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');
287: hr_utility.set_message_token('VALUE_NAME', 'This');
288: raise;
289: end;
290: --

Line 287: hr_utility.set_message_token('VALUE_NAME', 'This');

283: null);
284: exception
285: when hr_utility.hr_error then
286: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');
287: hr_utility.set_message_token('VALUE_NAME', 'This');
288: raise;
289: end;
290: --
291: -- Make sure balance name being created is unique within BG / LEG CODE.

Line 296: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');

292: open csr_unique_check('BALANCE_NAME');
293: fetch csr_unique_check into v_bal_type_id;
294: if csr_unique_check%found then
295: close csr_unique_check;
296: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
297: hr_utility.raise_error;
298: else
299: close csr_unique_check;
300: end if;

Line 297: hr_utility.raise_error;

293: fetch csr_unique_check into v_bal_type_id;
294: if csr_unique_check%found then
295: close csr_unique_check;
296: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
297: hr_utility.raise_error;
298: else
299: close csr_unique_check;
300: end if;
301: --

Line 313: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');

309: open csr_unique_check('REPORTING_NAME');
310: fetch csr_unique_check into v_bal_type_id;
311: if csr_unique_check%found then
312: close csr_unique_check;
313: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
314: hr_utility.raise_error;
315: else
316: close csr_unique_check;
317: end if;

Line 314: hr_utility.raise_error;

310: fetch csr_unique_check into v_bal_type_id;
311: if csr_unique_check%found then
312: close csr_unique_check;
313: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
314: hr_utility.raise_error;
315: else
316: close csr_unique_check;
317: end if;
318: --

Line 330: hr_utility.set_message(801, 'HR_6957_PAY_ONLY_ONE_RENUM');

326: open csr_unique_check('ASSIGNMENT_RENUMERATION_ALLOWED_FLAG');
327: fetch csr_unique_check into v_bal_type_id;
328: if csr_unique_check%found then
329: close csr_unique_check;
330: hr_utility.set_message(801, 'HR_6957_PAY_ONLY_ONE_RENUM');
331: hr_utility.raise_error;
332: else
333: close csr_unique_check;
334: end if;

Line 331: hr_utility.raise_error;

327: fetch csr_unique_check into v_bal_type_id;
328: if csr_unique_check%found then
329: close csr_unique_check;
330: hr_utility.set_message(801, 'HR_6957_PAY_ONLY_ONE_RENUM');
331: hr_utility.raise_error;
332: else
333: close csr_unique_check;
334: end if;
335: --

Line 369: hr_utility.set_location('Entering balance_type_cascade_delete', 5);

365: for update;
366: --
367: begin
368: --
369: hr_utility.set_location('Entering balance_type_cascade_delete', 5);
370: --
371: delete from pay_balance_feeds_f bf
372: where bf.balance_type_id = p_balance_type_id;
373: --

Line 374: hr_utility.set_location('balance_type_cascade_delete', 10);

370: --
371: delete from pay_balance_feeds_f bf
372: where bf.balance_type_id = p_balance_type_id;
373: --
374: hr_utility.set_location('balance_type_cascade_delete', 10);
375: --
376: delete from pay_balance_classifications bc
377: where bc.balance_type_id = p_balance_type_id;
378: --

Line 379: hr_utility.set_location('balance_type_cascade_delete', 15);

375: --
376: delete from pay_balance_classifications bc
377: where bc.balance_type_id = p_balance_type_id;
378: --
379: hr_utility.set_location('balance_type_cascade_delete', 15);
380: --
381: for v_db_rec in csr_def_bals loop
382: --
383: hr_utility.set_location('balance_type_cascade_delete', 20);

Line 383: hr_utility.set_location('balance_type_cascade_delete', 20);

379: hr_utility.set_location('balance_type_cascade_delete', 15);
380: --
381: for v_db_rec in csr_def_bals loop
382: --
383: hr_utility.set_location('balance_type_cascade_delete', 20);
384: --
385: -- Make sure defined balance is not used by an organization payment
386: -- method or a backpay set.
387: pay_defined_balances_pkg.chk_delete_defined_balance

Line 394: hr_utility.set_location('balance_type_cascade_delete',2);

390: -- need to delete child rows of pay_defined_balances. User entities are don
391: -- in trigger pay_defined_balances_brd, going to delete for new table
392: -- pay_balance_attributes here.
393: --
394: hr_utility.set_location('balance_type_cascade_delete',2);
395: --
396: for each_pba in get_pbas(v_db_rec.defined_balance_id) loop
397: pay_balance_attribute_api.delete_balance_attribute
398: (p_balance_attribute_id => each_pba.balance_attribute_id);

Line 401: hr_utility.set_location('balance_type_cascade_delete',3);

397: pay_balance_attribute_api.delete_balance_attribute
398: (p_balance_attribute_id => each_pba.balance_attribute_id);
399: end loop;
400: --
401: hr_utility.set_location('balance_type_cascade_delete',3);
402: delete from pay_defined_balances
403: where current of csr_def_bals;
404: --
405: end loop;

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 486: hr_utility.set_message(801, 'PAY_34261_CAT_IS_MANDATORY');

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;
490: end if;

Line 487: hr_utility.raise_error;

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;
490: end if;
491: --

Line 606: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

602: OPEN C;
603: FETCH C INTO X_Rowid;
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;

Line 607: hr_utility.set_message_token('PROCEDURE',

603: FETCH C INTO X_Rowid;
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;

Line 609: hr_utility.set_message_token('STEP','1');

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;
613: --

Line 610: hr_utility.raise_error;

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;
613: --
614: END Insert_Row;

Line 696: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

692: OPEN C;
693: FETCH C INTO Recinfo;
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;

Line 697: hr_utility.set_message_token('PROCEDURE',

693: FETCH C INTO Recinfo;
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;

Line 699: hr_utility.set_message_token('STEP','1');

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;
703: --

Line 700: hr_utility.raise_error;

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;
703: --
704: /** sbilling **/

Line 729: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

725: --end loop;
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: -- ***************************************************************************

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 950: hr_utility.trace('upd_leg: '||x_legislation_code);

946: X_Assignment_Remuneration_Flag);
947: --
948: -- Check if balance_category should be mandatory
949: --
950: hr_utility.trace('upd_leg: '||x_legislation_code);
951: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));
952: hr_utility.trace('upd_cat: '||x_balance_category_id);
953: if chk_balance_category_rule(x_legislation_code
954: ,x_business_group_id) then

Line 951: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));

947: --
948: -- Check if balance_category should be mandatory
949: --
950: hr_utility.trace('upd_leg: '||x_legislation_code);
951: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));
952: hr_utility.trace('upd_cat: '||x_balance_category_id);
953: if chk_balance_category_rule(x_legislation_code
954: ,x_business_group_id) then
955: --

Line 952: hr_utility.trace('upd_cat: '||x_balance_category_id);

948: -- Check if balance_category should be mandatory
949: --
950: hr_utility.trace('upd_leg: '||x_legislation_code);
951: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));
952: hr_utility.trace('upd_cat: '||x_balance_category_id);
953: if chk_balance_category_rule(x_legislation_code
954: ,x_business_group_id) then
955: --
956: if x_balance_category_id is null then

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 959: hr_utility.set_message(801, 'PAY_34261_CAT_IS_MANDATORY');

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;
963: end if;

Line 960: hr_utility.raise_error;

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;
963: end if;
964: --

Line 1006: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1002:
1003: WHERE rowid = X_rowid;
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;

Line 1007: hr_utility.set_message_token('PROCEDURE',

1003: WHERE rowid = X_rowid;
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;

Line 1009: hr_utility.set_message_token('STEP','1');

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: --
1013: -- ****************************************************************************************

Line 1010: hr_utility.raise_error;

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: --
1013: -- ****************************************************************************************
1014: --

Line 1027: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

1023: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
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: -- ***************************************************************************************

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 1060: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1056: DELETE FROM pay_balance_types
1057: WHERE rowid = X_Rowid;
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;

Line 1061: hr_utility.set_message_token('PROCEDURE',

1057: WHERE rowid = X_Rowid;
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;

Line 1063: hr_utility.set_message_token('STEP','1');

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: --
1067: -- ****************************************************************************

Line 1064: hr_utility.raise_error;

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: --
1067: -- ****************************************************************************
1068: --

Line 1082: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');

1078: delete from PAY_BALANCE_TYPES_TL
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;

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 1173: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1169: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_B_LEGISLATION_CODE,'~null~')
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;

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 1175: hr_utility.set_message_token('STEP','1');

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
1179: when NO_DATA_FOUND then

Line 1176: hr_utility.raise_error;

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
1179: when NO_DATA_FOUND then
1180: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 1180: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1176: hr_utility.raise_error;
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;

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 1182: hr_utility.set_message_token('STEP','1');

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: --------------------------------------------------------------------------------
1186: procedure TRANSLATE_ROW (

Line 1183: hr_utility.raise_error;

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: --------------------------------------------------------------------------------
1186: procedure TRANSLATE_ROW (
1187: X_B_BALANCE_NAME in VARCHAR2,