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

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

32:
33: BEGIN
34:
35: retcode := 2;
36: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
38: hr_utility.set_message_token('STEP', p_step);
39: hr_utility.raise_error;
40:

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

33: BEGIN
34:
35: retcode := 2;
36: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
38: hr_utility.set_message_token('STEP', p_step);
39: hr_utility.raise_error;
40:
41: END local_error;

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

34:
35: retcode := 2;
36: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
38: hr_utility.set_message_token('STEP', p_step);
39: hr_utility.raise_error;
40:
41: END local_error;
42:

Line 39: hr_utility.raise_error;

35: retcode := 2;
36: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
37: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
38: hr_utility.set_message_token('STEP', p_step);
39: hr_utility.raise_error;
40:
41: END local_error;
42:
43: procedure put_jl_in_cache (p_jl number)

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

48: begin
49:
50: -- Search for the defined balance in the Cache.
51:
52: hr_utility.set_location('paybalup.put_jl_in_cache', 10);
53: l_jur_level := nvl(p_jl, 999);
54: l_count := 1;
55: l_found := FALSE;
56: while (l_count < g_nxt_free_jl and l_found = FALSE) loop

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

54: l_count := 1;
55: l_found := FALSE;
56: while (l_count < g_nxt_free_jl and l_found = FALSE) loop
57: if (l_jur_level = g_jur_lev_tbl(l_count)) then
58: hr_utility.set_location('paybalup.put_jl_in_cache', 20);
59: l_found := TRUE;
60: end if;
61: l_count := l_count + 1;
62: end loop;

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

60: end if;
61: l_count := l_count + 1;
62: end loop;
63:
64: hr_utility.set_location('paybalup.put_jl_in_cache', 30);
65: if (l_found = FALSE) then
66: g_jur_lev_tbl(g_nxt_free_jl) := l_jur_level;
67: g_nxt_free_jl := g_nxt_free_jl + 1;
68: end if;

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

84: begin
85:
86: -- Search for the defined balance in the Cache.
87:
88: hr_utility.set_location('paybalup.check_balance_type', 10);
89: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
90: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
91: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
92: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);

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

85:
86: -- Search for the defined balance in the Cache.
87:
88: hr_utility.set_location('paybalup.check_balance_type', 10);
89: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
90: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
91: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
92: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
93: l_balance_type_id := null;

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

86: -- Search for the defined balance in the Cache.
87:
88: hr_utility.set_location('paybalup.check_balance_type', 10);
89: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
90: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
91: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
92: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
93: l_balance_type_id := null;
94: l_baltyp_name := upper(p_baltype_name);

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

87:
88: hr_utility.set_location('paybalup.check_balance_type', 10);
89: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
90: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
91: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
92: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
93: l_balance_type_id := null;
94: l_baltyp_name := upper(p_baltype_name);
95: l_count := 1;

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

88: hr_utility.set_location('paybalup.check_balance_type', 10);
89: hr_utility.trace('paybalup.check_balance_type p_baltype_id ' || p_baltype_id );
90: hr_utility.trace('paybalup.check_balance_type p_baltype_name ' || p_baltype_name);
91: hr_utility.trace('paybalup.check_balance_type p_busgrp_id ' || p_busgrp_id);
92: hr_utility.trace('paybalup.check_balance_type p_leg_code ' || p_leg_code);
93: l_balance_type_id := null;
94: l_baltyp_name := upper(p_baltype_name);
95: l_count := 1;
96: l_found := FALSE;

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

95: l_count := 1;
96: l_found := FALSE;
97: while (l_count < g_nxt_free_baltyp and l_found = FALSE) loop
98: if (l_baltyp_name = g_baltyp_tbl_name(l_count)) then
99: hr_utility.set_location('paybalup.check_balance_type', 20);
100: l_balance_type_id := g_baltyp_tbl_id(l_count);
101: l_found := TRUE;
102: end if;
103: l_count := l_count + 1;

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

104: end loop;
105:
106: -- If the balance is not in the Cache get it from the database.
107:
108: hr_utility.set_location('paybalup.check_balance_type' || l_baltyp_name, 30);
109: if (l_found = FALSE) then
110: BEGIN
111:
112: select balance_type_id,

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

125:
126:
127: -- Place the defined balance in cache.
128:
129: hr_utility.set_location('paybalup.check_balance_type', 40);
130: g_baltyp_tbl_name(g_nxt_free_baltyp) := l_baltyp_name;
131: g_baltyp_tbl_uom(g_nxt_free_baltyp) := l_bal_uom;
132: g_baltyp_tbl_id(g_nxt_free_baltyp) := l_balance_type_id;
133: g_baltyp_tbl_jl(g_nxt_free_baltyp) := l_jurisdiction_level;

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

134: g_nxt_free_baltyp := g_nxt_free_baltyp + 1;
135: put_jl_in_cache(l_jurisdiction_level);
136:
137: EXCEPTION WHEN no_data_found THEN
138: hr_utility.trace('Error: Failure to find balance type');
139: local_error(retcode, 'check_balance_type',1);
140:
141: END;
142:

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

163: begin
164:
165: -- Search for the defined balance in the Cache.
166:
167: hr_utility.set_location('paybalup.check_balance_dim', 10);
168: l_balance_dim_id := null;
169: l_baldim_name := upper(p_baldim_name);
170: l_count := 1;
171: l_found := FALSE;

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

170: l_count := 1;
171: l_found := FALSE;
172: while (l_count < g_nxt_free_baldim and l_found = FALSE) loop
173: if (l_baldim_name = g_baldim_tbl_name(l_count)) then
174: hr_utility.set_location('paybalup.check_balance_dim', 20);
175: l_balance_dim_id := g_baldim_tbl_id(l_count);
176: l_found := TRUE;
177: end if;
178: l_count := l_count + 1;

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

179: end loop;
180:
181: -- If the balance is not in the Cache get it from the database.
182:
183: hr_utility.set_location('paybalup.check_balance_dim', 30);
184: if (l_found = FALSE) then
185: BEGIN
186:
187: select balance_dimension_id

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

197:
198:
199: -- Place the defined balance in cache.
200:
201: hr_utility.set_location('paybalup.check_balance_dim', 40);
202: g_baldim_tbl_name(g_nxt_free_baldim) := l_baldim_name;
203: g_baldim_tbl_id(g_nxt_free_baldim) := l_balance_dim_id;
204: g_nxt_free_baldim := g_nxt_free_baldim + 1;
205:

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

203: g_baldim_tbl_id(g_nxt_free_baldim) := l_balance_dim_id;
204: g_nxt_free_baldim := g_nxt_free_baldim + 1;
205:
206: EXCEPTION WHEN no_data_found THEN
207: hr_utility.trace('Error: Failure to find balance dimension');
208: local_error(retcode,'check_balance_dim',2);
209:
210: END;
211:

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

237: from pay_balance_batch_lines
238: where batch_id = c_batch_id;
239:
240: BEGIN
241: hr_utility.set_location('paybalup.validate_batch_data', 10);
242: BEGIN /* check business group exists */
243: select hou.business_group_id,
244: hou.legislation_code
245: into l_bg_id,

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

251: EXCEPTION WHEN no_data_found THEN
252: local_error(retcode, 'validate_batch_data', 3);
253: END;
254:
255: hr_utility.set_location('paybalup.validate_batch_data', 20);
256: for l_each_batch_rec in c_each_batch (p_batch_id) loop
257: check_balance_type(l_bt_id, l_each_batch_rec.balance_name,
258: l_bg_id,
259: l_leg_code,

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

317: and BF.balance_type_id + 0 = p_balance_type_id
318: and nvl(BF.business_group_id, p_business_group) = p_business_group;
319:
320: BEGIN
321: hr_utility.set_location('paybalup.create_bal_upl_struct', 10);
322:
323: select pbg.business_group_id, bbh.business_group_name ,
324: pbg.currency_code, pbg.legislation_code
325: into l_bg_id, l_bg_name,

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

361:
362: l_jur_count := 1;
363: while (l_jur_count < g_nxt_free_jl) loop
364:
365: hr_utility.set_location('paybalup.create_bal_upl_struct', 20);
366: l_jur_level := g_jur_lev_tbl(l_jur_count);
367:
368: l_no_bal_for_jur := 0;
369: l_bal_count := 1;

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

385:
386: l_bal_count := 1;
387: for i in 1 .. l_n_elems loop
388:
389: hr_utility.set_location('paybalup.create_bal_upl_struct', 30);
390: j := 1;
391: while (l_bal_count< g_nxt_free_baltyp
392: and j <= p_input_value_limit) loop
393:

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

393:
394: -- Does this balance have the same jurisdiction level as the
395: -- current jurisdiction level.
396:
397: hr_utility.set_location('paybalup.create_bal_upl_struct', 40);
398: if (g_baltyp_tbl_jl(l_bal_count) = l_jur_level) then
399:
400: -- Does this balance already have an initial balance feed.
401:

Line 427: hr_utility.trace (

423: l_jur_level||
424: '_' ||
425: to_char(i);
426:
427: hr_utility.trace (
428: 'Element Name is:' || l_element_name);
429:
430: l_element_type_id := pay_db_pay_setup.create_element (
431: p_element_name => l_element_name,

Line 448: hr_utility.trace (

444: p_business_group_name => l_bg_name,
445: p_processing_priority => 0,
446: p_post_termination_rule => 'Final Close');
447:
448: hr_utility.trace (
449: 'Element name after is:' || l_element_name);
450:
451: update pay_element_types_f ELEM
452: set ELEM.element_information1 = 'B'