DBA Data[Home] [Help]

APPS.PAYBALUP dependencies on HR_UTILITY

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

91: --
92: BEGIN
93: --
94: retcode := 2;
95: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
97: hr_utility.set_message_token('STEP', p_step);
98: hr_utility.raise_error;
99: --

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

92: BEGIN
93: --
94: retcode := 2;
95: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
97: hr_utility.set_message_token('STEP', p_step);
98: hr_utility.raise_error;
99: --
100: END local_error;

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

93: --
94: retcode := 2;
95: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
97: hr_utility.set_message_token('STEP', p_step);
98: hr_utility.raise_error;
99: --
100: END local_error;
101: --

Line 98: hr_utility.raise_error;

94: retcode := 2;
95: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
96: hr_utility.set_message_token('PROCEDURE', 'paybalup.'||p_procedure);
97: hr_utility.set_message_token('STEP', p_step);
98: hr_utility.raise_error;
99: --
100: END local_error;
101: --
102: procedure put_jl_in_cache (p_jl number)

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

107: begin
108: --
109: -- Search for the defined balance in the Cache.
110: --
111: hr_utility.set_location('paybalup.put_jl_in_cache', 10);
112: l_jur_level := nvl(p_jl, 999);
113: l_count := 1;
114: l_found := FALSE;
115: while (l_count < g_nxt_free_jl and l_found = FALSE) loop

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

113: l_count := 1;
114: l_found := FALSE;
115: while (l_count < g_nxt_free_jl and l_found = FALSE) loop
116: if (l_jur_level = g_jur_lev_tbl(l_count)) then
117: hr_utility.set_location('paybalup.put_jl_in_cache', 20);
118: l_found := TRUE;
119: end if;
120: l_count := l_count + 1;
121: end loop;

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

119: end if;
120: l_count := l_count + 1;
121: end loop;
122: --
123: hr_utility.set_location('paybalup.put_jl_in_cache', 30);
124: if (l_found = FALSE) then
125: g_jur_lev_tbl(g_nxt_free_jl) := l_jur_level;
126: g_nxt_free_jl := g_nxt_free_jl + 1;
127: end if;

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

143: begin
144: --
145: -- Search for the defined balance in the Cache.
146: --
147: hr_utility.set_location('paybalup.check_balance_type', 10);
148: l_balance_type_id := null;
149: l_baltyp_name := upper(p_baltype_name);
150: l_count := 1;
151: l_found := FALSE;

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

150: l_count := 1;
151: l_found := FALSE;
152: while (l_count < g_nxt_free_baltyp and l_found = FALSE) loop
153: if (l_baltyp_name = g_baltyp_tbl_name(l_count)) then
154: hr_utility.set_location('paybalup.check_balance_type', 20);
155: l_balance_type_id := g_baltyp_tbl_id(l_count);
156: l_found := TRUE;
157: end if;
158: l_count := l_count + 1;

Line 163: hr_utility.set_location('paybalup.check_balance_type', 30);

159: end loop;
160: --
161: -- If the balance is not in the Cache get it from the database.
162: --
163: hr_utility.set_location('paybalup.check_balance_type', 30);
164: if (l_found = FALSE) then
165: BEGIN
166: --
167: select balance_type_id,

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

180: --
181: --
182: -- Place the defined balance in cache.
183: --
184: hr_utility.set_location('paybalup.check_balance_type', 40);
185: g_baltyp_tbl_name(g_nxt_free_baltyp) := l_baltyp_name;
186: g_baltyp_tbl_uom(g_nxt_free_baltyp) := l_bal_uom;
187: g_baltyp_tbl_id(g_nxt_free_baltyp) := l_balance_type_id;
188: g_baltyp_tbl_jl(g_nxt_free_baltyp) := l_jurisdiction_level;

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

189: g_nxt_free_baltyp := g_nxt_free_baltyp + 1;
190: put_jl_in_cache(l_jurisdiction_level);
191: --
192: EXCEPTION WHEN no_data_found THEN
193: hr_utility.trace('Error: Failure to find balance type');
194: local_error(retcode, 'check_balance_type',1);
195: --
196: END;
197: --

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

215: begin
216: --
217: -- Search for the defined balance in the Cache.
218: --
219: hr_utility.set_location('paybalup.check_balance_dim', 10);
220: l_balance_dim_id := null;
221: l_baldim_name := upper(p_baldim_name);
222: l_count := 1;
223: l_found := FALSE;

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

222: l_count := 1;
223: l_found := FALSE;
224: while (l_count < g_nxt_free_baldim and l_found = FALSE) loop
225: if (l_baldim_name = g_baldim_tbl_name(l_count)) then
226: hr_utility.set_location('paybalup.check_balance_dim', 20);
227: l_balance_dim_id := g_baldim_tbl_id(l_count);
228: l_found := TRUE;
229: end if;
230: l_count := l_count + 1;

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

231: end loop;
232: --
233: -- If the balance is not in the Cache get it from the database.
234: --
235: hr_utility.set_location('paybalup.check_balance_dim', 30);
236: if (l_found = FALSE) then
237: BEGIN
238: --
239: select balance_dimension_id

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

249: --
250: --
251: -- Place the defined balance in cache.
252: --
253: hr_utility.set_location('paybalup.check_balance_dim', 40);
254: g_baldim_tbl_name(g_nxt_free_baldim) := l_baldim_name;
255: g_baldim_tbl_id(g_nxt_free_baldim) := l_balance_dim_id;
256: g_nxt_free_baldim := g_nxt_free_baldim + 1;
257: --

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

255: g_baldim_tbl_id(g_nxt_free_baldim) := l_balance_dim_id;
256: g_nxt_free_baldim := g_nxt_free_baldim + 1;
257: --
258: EXCEPTION WHEN no_data_found THEN
259: hr_utility.trace('Error: Failure to find balance dimension');
260: local_error(retcode,'check_balance_dim',2);
261: --
262: END;
263: --

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

287: from pay_balance_batch_lines
288: where batch_id = c_batch_id;
289: --
290: BEGIN
291: hr_utility.set_location('paybalup.validate_batch_data', 10);
292: BEGIN /* check business group exists */
293: select hou.business_group_id,
294: hou.legislation_code
295: into l_bg_id,

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

301: EXCEPTION WHEN no_data_found THEN
302: local_error(retcode, 'validate_batch_data', 3);
303: END;
304: --
305: hr_utility.set_location('paybalup.validate_batch_data', 20);
306: for l_each_batch_rec in c_each_batch (p_batch_id) loop
307: check_balance_type(l_bt_id, l_each_batch_rec.balance_name,
308: l_bg_id,
309: l_leg_code,

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

366: and BF.effective_end_date = to_date('4712/12/31','YYYY/MM/DD')
367: and nvl(BF.business_group_id, p_business_group) = p_business_group;
368: --
369: BEGIN
370: hr_utility.set_location('paybalup.create_bal_upl_struct', 10);
371: --
372: select pbg.business_group_id, pbg.name ,
373: pbg.currency_code
374: into l_bg_id, l_bg_name,

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

382: --
383: l_jur_count := 1;
384: while (l_jur_count < g_nxt_free_jl) loop
385: --
386: hr_utility.set_location('paybalup.create_bal_upl_struct', 20);
387: l_jur_level := g_jur_lev_tbl(l_jur_count);
388: --
389: l_no_bal_for_jur := 0;
390: l_bal_count := 1;

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

400: --
401: l_bal_count := 1;
402: for i in 1 .. l_n_elems loop
403: --
404: hr_utility.set_location('paybalup.create_bal_upl_struct', 30);
405: j := 1;
406: while (l_bal_count< g_nxt_free_baltyp
407: and j <= p_input_value_limit) loop
408: --

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

408: --
409: -- Does this balance have the same jurisdiction level as the
410: -- current jurisdiction level.
411: --
412: hr_utility.set_location('paybalup.create_bal_upl_struct', 40);
413: if (g_baltyp_tbl_jl(l_bal_count) = l_jur_level) then
414: --
415: -- Does this balance already have an initial balance feed.
416: --

Line 441: hr_utility.trace (

437: l_jur_level||
438: '_' ||
439: to_char(i);
440: --
441: hr_utility.trace (
442: 'Element Name is:' || l_element_name);
443: --
444: l_element_type_id := pay_db_pay_setup.create_element (
445: p_element_name => l_element_name,

Line 462: hr_utility.trace (

458: p_business_group_name => l_bg_name,
459: p_processing_priority => 0,
460: p_post_termination_rule => 'Final Close');
461: --
462: hr_utility.trace (
463: 'Element name after is:' || l_element_name);
464: --
465: update pay_element_types_f ELEM
466: set ELEM.element_information1 = 'B'