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_CN_BAL_UPL_STRUCT dependencies on HR_UTILITY

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

48: ,p_step IN NUMBER)
49: IS
50: BEGIN
51: retcode := 2;
52: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
54: hr_utility.set_message_token('STEP', p_step);
55: hr_utility.raise_error;
56:

Line 53: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);

49: IS
50: BEGIN
51: retcode := 2;
52: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
54: hr_utility.set_message_token('STEP', p_step);
55: hr_utility.raise_error;
56:
57: END local_error;

Line 54: hr_utility.set_message_token('STEP', p_step);

50: BEGIN
51: retcode := 2;
52: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
54: hr_utility.set_message_token('STEP', p_step);
55: hr_utility.raise_error;
56:
57: END local_error;
58:

Line 55: hr_utility.raise_error;

51: retcode := 2;
52: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
54: hr_utility.set_message_token('STEP', p_step);
55: hr_utility.raise_error;
56:
57: END local_error;
58:
59: --------------------------------------------------------------------------

Line 85: hr_utility.set_location('paybalup.put_jl_in_cache', 10);

81: BEGIN
82:
83: -- Search for the defined balance in the Cache.
84:
85: hr_utility.set_location('paybalup.put_jl_in_cache', 10);
86: l_jur_level := nvl(p_jl, 999);
87: l_count := 1;
88: l_found := FALSE;
89: --

Line 94: hr_utility.set_location('paybalup.put_jl_in_cache', 20);

90: WHILE (l_count < g_nxt_free_jl AND l_found = FALSE)
91: LOOP
92: IF (l_jur_level = g_jur_lev_tbl(l_count)) THEN
93: --
94: hr_utility.set_location('paybalup.put_jl_in_cache', 20);
95: l_found := TRUE;
96: --
97: END IF;
98: l_count := l_count + 1;

Line 102: hr_utility.set_location('paybalup.put_jl_in_cache', 30);

98: l_count := l_count + 1;
99:
100: END LOOP;
101: --
102: hr_utility.set_location('paybalup.put_jl_in_cache', 30);
103: --
104: IF (l_found = FALSE) THEN
105: g_jur_lev_tbl(g_nxt_free_jl) := l_jur_level;
106: g_nxt_free_jl := g_nxt_free_jl + 1;

Line 165: hr_utility.set_location('paybalup.check_balance_type', 10);

161: BEGIN
162:
163: -- Search for the defined balance in the Cache.
164:
165: hr_utility.set_location('paybalup.check_balance_type', 10);
166: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
167: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
168: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
169: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);

Line 166: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );

162:
163: -- Search for the defined balance in the Cache.
164:
165: hr_utility.set_location('paybalup.check_balance_type', 10);
166: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
167: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
168: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
169: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
170:

Line 167: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);

163: -- Search for the defined balance in the Cache.
164:
165: hr_utility.set_location('paybalup.check_balance_type', 10);
166: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
167: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
168: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
169: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
170:
171: l_balance_type_id := null;

Line 168: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);

164:
165: hr_utility.set_location('paybalup.check_balance_type', 10);
166: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
167: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
168: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
169: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
170:
171: l_balance_type_id := null;
172: l_baltyp_name := p_baltype_name;

Line 169: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);

165: hr_utility.set_location('paybalup.check_balance_type', 10);
166: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
167: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
168: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
169: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
170:
171: l_balance_type_id := null;
172: l_baltyp_name := p_baltype_name;
173: l_count := 1;

Line 181: hr_utility.set_location('paybalup.check_balance_type', 20);

177: LOOP
178: --
179: IF (l_baltyp_name = g_baltyp_tbl_name(l_count)) THEN
180: --
181: hr_utility.set_location('paybalup.check_balance_type', 20);
182: --
183: l_balance_type_id := g_baltyp_tbl_id(l_count);
184: l_found := TRUE;
185: --

Line 194: hr_utility.set_location('paybalup.check_balance_type' || l_baltyp_name, 30);

190: END LOOP;
191:
192: -- If the balance IS not in the Cache get it from the database.
193:
194: hr_utility.set_location('paybalup.check_balance_type' || l_baltyp_name, 30);
195: --
196: IF (l_found = FALSE) THEN
197: --
198: OPEN csr_bal_type(l_baltyp_name);

Line 206: hr_utility.trace('Error: Failure to find balance type');

202: --
203: IF csr_bal_type%NOTFOUND THEN
204: --
205: CLOSE csr_bal_type;
206: hr_utility.trace('Error: Failure to find balance type');
207: local_error(retcode, 'check_balance_type',1);
208: --
209: END IF;
210: CLOSE csr_bal_type;

Line 213: hr_utility.set_location('paybalup.check_balance_type', 40);

209: END IF;
210: CLOSE csr_bal_type;
211: -- Place the defined balance in cache.
212:
213: hr_utility.set_location('paybalup.check_balance_type', 40);
214: --
215: g_baltyp_tbl_name(g_nxt_free_baltyp) := l_baltyp_name;
216: g_baltyp_tbl_uom(g_nxt_free_baltyp) := l_bal_uom;
217: g_baltyp_tbl_id(g_nxt_free_baltyp) := l_balance_type_id;

Line 280: hr_utility.set_location('paybalup.check_balance_dim', 10);

276: BEGIN
277:
278: -- Search for the defined balance in the Cache.
279:
280: hr_utility.set_location('paybalup.check_balance_dim', 10);
281: --
282: l_balance_dim_id := null;
283: l_baldim_name := upper(p_baldim_name);
284: l_count := 1;

Line 291: hr_utility.set_location('paybalup.check_balance_dim', 20);

287: WHILE (l_count < g_nxt_free_baldim AND l_found = FALSE)
288: LOOP
289: IF (l_baldim_name = g_baldim_tbl_name(l_count)) THEN
290: --
291: hr_utility.set_location('paybalup.check_balance_dim', 20);
292: l_balance_dim_id := g_baldim_tbl_id(l_count);
293: l_found := TRUE;
294: --
295: END IF;

Line 303: hr_utility.set_location('paybalup.check_balance_dim', 30);

299: END LOOP;
300:
301: -- If the balance IS not in the Cache get it from the database.
302:
303: hr_utility.set_location('paybalup.check_balance_dim', 30);
304: --
305: IF (l_found = FALSE) THEN
306: --
307: OPEN csr_bal_dim(l_baldim_name);

Line 314: hr_utility.trace('Error: Failure to find balance dimension');

310:
311: IF csr_bal_dim%NOTFOUND THEN
312: --
313: CLOSE csr_bal_dim;
314: hr_utility.trace('Error: Failure to find balance dimension');
315: local_error(retcode,'check_balance_dim',2);
316: --
317: END IF;
318: CLOSE csr_bal_dim;

Line 321: hr_utility.set_location('paybalup.check_balance_dim', 40);

317: END IF;
318: CLOSE csr_bal_dim;
319: -- Place the defined balance in cache.
320:
321: hr_utility.set_location('paybalup.check_balance_dim', 40);
322: --
323: g_baldim_tbl_name(g_nxt_free_baldim) := l_baldim_name;
324: g_baldim_tbl_id(g_nxt_free_baldim) := l_balance_dim_id;
325: g_nxt_free_baldim := g_nxt_free_baldim + 1;

Line 385: hr_utility.set_location('paybalup.validate_batch_data', 10);

381: FROM pay_balance_batch_lines
382: WHERE batch_id = c_batch_id;
383:
384: BEGIN
385: hr_utility.set_location('paybalup.validate_batch_data', 10);
386: --
387: -- Check business group exists
388: --
389: OPEN csr_bg;

Line 399: hr_utility.set_location('paybalup.validate_batch_data', 20);

395: local_error(retcode, 'validate_batch_data', 3);
396: END IF;
397: CLOSE csr_bg;
398: --
399: hr_utility.set_location('paybalup.validate_batch_data', 20);
400: --
401: FOR l_each_batch_rec IN c_each_batch (p_batch_id)
402: LOOP
403: --

Line 541: hr_utility.set_location('paybalup.create_bal_upl_struct', 10);

537: AND legislation_code = p_leg_code;
538:
539: BEGIN
540: --
541: hr_utility.set_location('paybalup.create_bal_upl_struct', 10);
542:
543: OPEN csr_bg;
544: FETCH csr_bg
545: INTO l_bg_id, l_bg_name, l_currency_code, l_leg_code;

Line 579: hr_utility.set_location('paybalup.create_bal_upl_struct', 20);

575: --
576: WHILE (l_jur_count < g_nxt_free_jl)
577: LOOP
578: --
579: hr_utility.set_location('paybalup.create_bal_upl_struct', 20);
580: --
581: l_jur_level := g_jur_lev_tbl(l_jur_count);
582: l_no_bal_for_jur := 0;
583: l_bal_count := 1;

Line 616: hr_utility.set_location('paybalup.create_bal_upl_struct', 30);

612:
613: FOR i in 1 .. l_n_elems
614: LOOP
615: --
616: hr_utility.set_location('paybalup.create_bal_upl_struct', 30);
617: j := 1;
618: --
619: -- Bug 3002366
620: -- Use local variable l_no_input_values instead of p_input_value_limit

Line 625: hr_utility.set_location('paybalup.create_bal_upl_struct', 40);

621: --
622: WHILE ( l_bal_count < g_nxt_free_baltyp AND j <= l_no_input_values )
623: LOOP
624:
625: hr_utility.set_location('paybalup.create_bal_upl_struct', 40);
626: --
627: IF (g_baltyp_tbl_jl(l_bal_count) = l_jur_level) THEN
628: --
629: OPEN csr_is_balance_fed(g_baltyp_tbl_id(l_bal_count), l_bg_id);

Line 662: hr_utility.trace ('Element Name IS:' || l_element_name);

658: l_jur_level||
659: '_' ||
660: to_char(i);
661:
662: hr_utility.trace ('Element Name IS:' || l_element_name);
663:
664: l_element_type_id :=
665: pay_db_pay_setup.create_element (
666: p_element_name => l_element_name,

Line 680: hr_utility.trace ('Element name after IS:' || l_element_name);

676: p_business_group_name => l_bg_name,
677: p_processing_priority => 0,
678: p_post_termination_rule => 'Final Close');
679:
680: hr_utility.trace ('Element name after IS:' || l_element_name);
681:
682: UPDATE pay_element_types_f ELEM
683: SET ELEM.element_information1 = 'B'
684: WHERE element_type_id = l_element_type_id;