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 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 158: hr_utility.set_location('Entering '||l_proc, 5);

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

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

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

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

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

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

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

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

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

Line 171: hr_utility.raise_error;

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

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

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

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

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

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

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

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

194: );
195: if leg_rule_found = FALSE
196: or l_rule_mode = 'N' then
197: --
198: hr_utility.set_location(l_proc, 30);
199: return false;
200: --
201: else
202: hr_utility.set_location(l_proc, 35);

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

198: hr_utility.set_location(l_proc, 30);
199: return false;
200: --
201: else
202: hr_utility.set_location(l_proc, 35);
203: return true;
204: end if;
205:
206: end chk_balance_category_rule;

Line 290: when hr_utility.hr_error then

286: 'N',
287: v_result_text,
288: null);
289: exception
290: when hr_utility.hr_error then
291: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');
292: hr_utility.set_message_token('VALUE_NAME', 'This');
293: raise;
294: end;

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

287: v_result_text,
288: null);
289: exception
290: when hr_utility.hr_error then
291: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');
292: hr_utility.set_message_token('VALUE_NAME', 'This');
293: raise;
294: end;
295: --

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

288: null);
289: exception
290: when hr_utility.hr_error then
291: hr_utility.set_message(801, 'HR_6016_ALL_RES_WORDS');
292: hr_utility.set_message_token('VALUE_NAME', 'This');
293: raise;
294: end;
295: --
296: -- Make sure balance name being created is unique within BG / LEG CODE.

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

297: open csr_unique_check('BALANCE_NAME');
298: fetch csr_unique_check into v_bal_type_id;
299: if csr_unique_check%found then
300: close csr_unique_check;
301: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
302: hr_utility.raise_error;
303: else
304: close csr_unique_check;
305: end if;

Line 302: hr_utility.raise_error;

298: fetch csr_unique_check into v_bal_type_id;
299: if csr_unique_check%found then
300: close csr_unique_check;
301: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
302: hr_utility.raise_error;
303: else
304: close csr_unique_check;
305: end if;
306: --

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

314: open csr_unique_check('REPORTING_NAME');
315: fetch csr_unique_check into v_bal_type_id;
316: if csr_unique_check%found then
317: close csr_unique_check;
318: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
319: hr_utility.raise_error;
320: else
321: close csr_unique_check;
322: end if;

Line 319: hr_utility.raise_error;

315: fetch csr_unique_check into v_bal_type_id;
316: if csr_unique_check%found then
317: close csr_unique_check;
318: hr_utility.set_message(801, 'HR_6108_BAL_UNI_BALANCE');
319: hr_utility.raise_error;
320: else
321: close csr_unique_check;
322: end if;
323: --

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

331: open csr_unique_check('ASSIGNMENT_RENUMERATION_ALLOWED_FLAG');
332: fetch csr_unique_check into v_bal_type_id;
333: if csr_unique_check%found then
334: close csr_unique_check;
335: hr_utility.set_message(801, 'HR_6957_PAY_ONLY_ONE_RENUM');
336: hr_utility.raise_error;
337: else
338: close csr_unique_check;
339: end if;

Line 336: hr_utility.raise_error;

332: fetch csr_unique_check into v_bal_type_id;
333: if csr_unique_check%found then
334: close csr_unique_check;
335: hr_utility.set_message(801, 'HR_6957_PAY_ONLY_ONE_RENUM');
336: hr_utility.raise_error;
337: else
338: close csr_unique_check;
339: end if;
340: --

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

370: for update;
371: --
372: begin
373: --
374: hr_utility.set_location('Entering balance_type_cascade_delete', 5);
375: --
376: delete from pay_balance_feeds_f bf
377: where bf.balance_type_id = p_balance_type_id;
378: --

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

375: --
376: delete from pay_balance_feeds_f bf
377: where bf.balance_type_id = p_balance_type_id;
378: --
379: hr_utility.set_location('balance_type_cascade_delete', 10);
380: --
381: delete from pay_balance_classifications bc
382: where bc.balance_type_id = p_balance_type_id;
383: --

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

380: --
381: delete from pay_balance_classifications bc
382: where bc.balance_type_id = p_balance_type_id;
383: --
384: hr_utility.set_location('balance_type_cascade_delete', 15);
385: --
386: for v_db_rec in csr_def_bals loop
387: --
388: hr_utility.set_location('balance_type_cascade_delete', 20);

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

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

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

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

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

402: pay_balance_attribute_api.delete_balance_attribute
403: (p_balance_attribute_id => each_pba.balance_attribute_id);
404: end loop;
405: --
406: hr_utility.set_location('balance_type_cascade_delete',3);
407: delete from pay_defined_balances
408: where current of csr_def_bals;
409: --
410: end loop;

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

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

Line 492: hr_utility.raise_error;

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

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

607: OPEN C;
608: FETCH C INTO X_Rowid;
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;

Line 612: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 615: hr_utility.raise_error;

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;
618: --
619: END Insert_Row;

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

697: OPEN C;
698: FETCH C INTO Recinfo;
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;

Line 702: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 705: hr_utility.raise_error;

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;
708: --
709: /** sbilling **/

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

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

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

951: X_Assignment_Remuneration_Flag);
952: --
953: -- Check if balance_category should be mandatory
954: --
955: hr_utility.trace('upd_leg: '||x_legislation_code);
956: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));
957: hr_utility.trace('upd_cat: '||x_balance_category_id);
958: if chk_balance_category_rule(x_legislation_code
959: ,x_business_group_id) then

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

952: --
953: -- Check if balance_category should be mandatory
954: --
955: hr_utility.trace('upd_leg: '||x_legislation_code);
956: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));
957: hr_utility.trace('upd_cat: '||x_balance_category_id);
958: if chk_balance_category_rule(x_legislation_code
959: ,x_business_group_id) then
960: --

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

953: -- Check if balance_category should be mandatory
954: --
955: hr_utility.trace('upd_leg: '||x_legislation_code);
956: hr_utility.trace('upd_bg: '||to_char(x_business_group_id));
957: hr_utility.trace('upd_cat: '||x_balance_category_id);
958: if chk_balance_category_rule(x_legislation_code
959: ,x_business_group_id) then
960: --
961: if x_balance_category_id is null then

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

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

Line 965: hr_utility.raise_error;

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

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

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

Line 1012: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 1015: hr_utility.raise_error;

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: --
1018: -- ****************************************************************************************
1019: --

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

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

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

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

Line 1066: hr_utility.set_message_token('PROCEDURE',

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

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

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

Line 1069: hr_utility.raise_error;

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: --
1072: -- ****************************************************************************
1073: --

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

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

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

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

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

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

Line 1181: hr_utility.raise_error;

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

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

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

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

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

Line 1188: hr_utility.raise_error;

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