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_IN_BAL_UPL_STRUCT dependencies on PAY_IN_UTILS

Line 58: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

54:
55: -- Search for the defined balance in the Cache.
56: g_debug := hr_utility.debug_enabled ;
57: l_procedure := g_package || 'put_jl_in_cache' ;
58: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
59:
60: l_jur_level := nvl(p_jl, 999);
61: l_count := 1;
62: l_found := FALSE;

Line 65: pay_in_utils.set_location(g_debug,l_procedure,20);

61: l_count := 1;
62: l_found := FALSE;
63: WHILE (l_count < g_nxt_free_jl and l_found = FALSE) LOOP
64: if (l_jur_level = g_jur_lev_tbl(l_count)) then
65: pay_in_utils.set_location(g_debug,l_procedure,20);
66: l_found := TRUE;
67: END IF;
68: l_count := l_count + 1;
69: END LOOP;

Line 75: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);

71: IF (l_found = FALSE) THEN
72: g_jur_lev_tbl(g_nxt_free_jl) := l_jur_level;
73: g_nxt_free_jl := g_nxt_free_jl + 1;
74: END IF;
75: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
76: EXCEPTION
77: WHEN OTHERS THEN
78: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
79: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

Line 78: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

74: END IF;
75: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
76: EXCEPTION
77: WHEN OTHERS THEN
78: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
79: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
80: pay_in_utils.trace(l_message,l_procedure);
81: END put_jl_in_cache;
82:

Line 79: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);

75: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
76: EXCEPTION
77: WHEN OTHERS THEN
78: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
79: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
80: pay_in_utils.trace(l_message,l_procedure);
81: END put_jl_in_cache;
82:
83: PROCEDURE check_balance_type(p_baltype_id out NOCOPY NUMBER,

Line 80: pay_in_utils.trace(l_message,l_procedure);

76: EXCEPTION
77: WHEN OTHERS THEN
78: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
79: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
80: pay_in_utils.trace(l_message,l_procedure);
81: END put_jl_in_cache;
82:
83: PROCEDURE check_balance_type(p_baltype_id out NOCOPY NUMBER,
84: p_baltype_name VARCHAR2,

Line 116: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

112:
113: -- Search for the defined balance in the Cache.
114: g_debug := hr_utility.debug_enabled ;
115: l_procedure := g_package || 'check_balance_type' ;
116: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
117:
118: if g_debug then
119: pay_in_utils.trace('******************************','********************');
120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);

Line 119: pay_in_utils.trace('**********','');

115: l_procedure := g_package || 'check_balance_type' ;
116: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
117:
118: if g_debug then
119: pay_in_utils.trace('******************************','********************');
120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);
121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);
122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
123: pay_in_utils.trace('p_leg_code : ',p_leg_code);

Line 120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);

116: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
117:
118: if g_debug then
119: pay_in_utils.trace('******************************','********************');
120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);
121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);
122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
123: pay_in_utils.trace('p_leg_code : ',p_leg_code);
124: pay_in_utils.trace('******************************','********************');

Line 121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);

117:
118: if g_debug then
119: pay_in_utils.trace('******************************','********************');
120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);
121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);
122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
123: pay_in_utils.trace('p_leg_code : ',p_leg_code);
124: pay_in_utils.trace('******************************','********************');
125: end if;

Line 122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);

118: if g_debug then
119: pay_in_utils.trace('******************************','********************');
120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);
121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);
122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
123: pay_in_utils.trace('p_leg_code : ',p_leg_code);
124: pay_in_utils.trace('******************************','********************');
125: end if;
126:

Line 123: pay_in_utils.trace('p_leg_code : ',p_leg_code);

119: pay_in_utils.trace('******************************','********************');
120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);
121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);
122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
123: pay_in_utils.trace('p_leg_code : ',p_leg_code);
124: pay_in_utils.trace('******************************','********************');
125: end if;
126:
127: l_balance_type_id := NULL;

Line 124: pay_in_utils.trace('**********','');

120: pay_in_utils.trace('p_baltype_id : ',p_baltype_id);
121: pay_in_utils.trace('p_baltype_name : ',p_baltype_name);
122: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
123: pay_in_utils.trace('p_leg_code : ',p_leg_code);
124: pay_in_utils.trace('******************************','********************');
125: end if;
126:
127: l_balance_type_id := NULL;
128: l_baltyp_name := p_baltype_name;

Line 133: pay_in_utils.set_location(g_debug,l_procedure,20);

129: l_count := 1;
130: l_found := FALSE;
131: WHILE (l_count < g_nxt_free_baltyp and l_found = FALSE) LOOP
132: IF (l_baltyp_name = g_baltyp_tbl_name(l_count)) THEN
133: pay_in_utils.set_location(g_debug,l_procedure,20);
134: l_balance_type_id := g_baltyp_tbl_id(l_count);
135: l_found := TRUE;
136: END IF;
137: l_count := l_count + 1;

Line 142: pay_in_utils.set_location(g_debug,l_procedure,30);

138: END LOOP;
139:
140: -- If the balance is not in the Cache get it from the database.
141:
142: pay_in_utils.set_location(g_debug,l_procedure,30);
143: pay_in_utils.trace('l_baltyp_name : ',l_baltyp_name);
144: if (l_found = FALSE) then
145: OPEN csr_bal_type(l_baltyp_name);
146: --

Line 143: pay_in_utils.trace('l_baltyp_name : ',l_baltyp_name);

139:
140: -- If the balance is not in the Cache get it from the database.
141:
142: pay_in_utils.set_location(g_debug,l_procedure,30);
143: pay_in_utils.trace('l_baltyp_name : ',l_baltyp_name);
144: if (l_found = FALSE) then
145: OPEN csr_bal_type(l_baltyp_name);
146: --
147: FETCH csr_bal_type

Line 153: pay_in_utils.trace('Error: Failure to find balance type',l_procedure);

149: --
150: IF csr_bal_type%NOTFOUND THEN
151: --
152: CLOSE csr_bal_type;
153: pay_in_utils.trace('Error: Failure to find balance type',l_procedure);
154: local_error(retcode, 'check_balance_type',1);
155: --
156: END IF;
157: CLOSE csr_bal_type;

Line 164: pay_in_utils.set_location(g_debug,l_procedure,40);

160:
161:
162: -- Place the defined balance in cache.
163:
164: pay_in_utils.set_location(g_debug,l_procedure,40);
165: g_baltyp_tbl_name(g_nxt_free_baltyp) := l_baltyp_name;
166: g_baltyp_tbl_uom(g_nxt_free_baltyp) := l_bal_uom;
167: g_baltyp_tbl_id(g_nxt_free_baltyp) := l_balance_type_id;
168: g_baltyp_tbl_jl(g_nxt_free_baltyp) := l_jurisdiction_level;

Line 174: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);

170: put_jl_in_cache(l_jurisdiction_level);
171:
172:
173: END IF;
174: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);
175:
176: p_baltype_id := l_balance_type_id;
177:
178: EXCEPTION

Line 180: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

176: p_baltype_id := l_balance_type_id;
177:
178: EXCEPTION
179: WHEN OTHERS THEN
180: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
181: IF csr_bal_type%ISOPEN THEN
182: CLOSE csr_bal_type;
183: END IF;
184: p_baltype_id := NULL;

Line 185: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

181: IF csr_bal_type%ISOPEN THEN
182: CLOSE csr_bal_type;
183: END IF;
184: p_baltype_id := NULL;
185: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
186: pay_in_utils.trace(l_message,l_procedure);
187: END check_balance_type;
188:
189:

Line 186: pay_in_utils.trace(l_message,l_procedure);

182: CLOSE csr_bal_type;
183: END IF;
184: p_baltype_id := NULL;
185: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
186: pay_in_utils.trace(l_message,l_procedure);
187: END check_balance_type;
188:
189:
190: PROCEDURE check_balance_dim(p_baldim_id OUT NOCOPY NUMBER,

Line 218: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

214:
215: -- Search for the defined balance in the Cache.
216: g_debug := hr_utility.debug_enabled ;
217: l_procedure := g_package || 'check_balance_dim' ;
218: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
219: if g_debug then
220: pay_in_utils.trace('******************************','********************');
221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);
222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);

Line 220: pay_in_utils.trace('**********','');

216: g_debug := hr_utility.debug_enabled ;
217: l_procedure := g_package || 'check_balance_dim' ;
218: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
219: if g_debug then
220: pay_in_utils.trace('******************************','********************');
221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);
222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
223: pay_in_utils.trace('p_leg_code : ',p_leg_code);
224: pay_in_utils.trace('******************************','********************');

Line 221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);

217: l_procedure := g_package || 'check_balance_dim' ;
218: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
219: if g_debug then
220: pay_in_utils.trace('******************************','********************');
221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);
222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
223: pay_in_utils.trace('p_leg_code : ',p_leg_code);
224: pay_in_utils.trace('******************************','********************');
225: end if;

Line 222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);

218: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
219: if g_debug then
220: pay_in_utils.trace('******************************','********************');
221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);
222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
223: pay_in_utils.trace('p_leg_code : ',p_leg_code);
224: pay_in_utils.trace('******************************','********************');
225: end if;
226: l_balance_dim_id := NULL;

Line 223: pay_in_utils.trace('p_leg_code : ',p_leg_code);

219: if g_debug then
220: pay_in_utils.trace('******************************','********************');
221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);
222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
223: pay_in_utils.trace('p_leg_code : ',p_leg_code);
224: pay_in_utils.trace('******************************','********************');
225: end if;
226: l_balance_dim_id := NULL;
227: l_baldim_name := UPPER(p_baldim_name);

Line 224: pay_in_utils.trace('**********','');

220: pay_in_utils.trace('******************************','********************');
221: pay_in_utils.trace('p_baldim_name : ',p_baldim_name);
222: pay_in_utils.trace('p_busgrp_id : ',p_busgrp_id);
223: pay_in_utils.trace('p_leg_code : ',p_leg_code);
224: pay_in_utils.trace('******************************','********************');
225: end if;
226: l_balance_dim_id := NULL;
227: l_baldim_name := UPPER(p_baldim_name);
228: l_count := 1;

Line 232: pay_in_utils.set_location(g_debug,l_procedure,20);

228: l_count := 1;
229: l_found := FALSE;
230: WHILE (l_count < g_nxt_free_baldim AND l_found = FALSE) LOOP
231: IF (l_baldim_name = g_baldim_tbl_name(l_count)) THEN
232: pay_in_utils.set_location(g_debug,l_procedure,20);
233: l_balance_dim_id := g_baldim_tbl_id(l_count);
234: l_found := TRUE;
235: END IF;
236: l_count := l_count + 1;

Line 241: pay_in_utils.set_location(g_debug,l_procedure,30);

237: END LOOP;
238:
239: -- If the balance is not in the Cache get it from the database.
240:
241: pay_in_utils.set_location(g_debug,l_procedure,30);
242: IF (l_found = FALSE) then
243: OPEN csr_bal_dim(l_baldim_name);
244: FETCH csr_bal_dim
245: INTO l_balance_dim_id;

Line 260: pay_in_utils.set_location(g_debug,l_procedure,40);

256:
257:
258: -- Place the defined balance in cache.
259:
260: pay_in_utils.set_location(g_debug,l_procedure,40);
261: g_baldim_tbl_name(g_nxt_free_baldim) := l_baldim_name;
262: g_baldim_tbl_id(g_nxt_free_baldim) := l_balance_dim_id;
263: g_nxt_free_baldim := g_nxt_free_baldim + 1;
264:

Line 270: pay_in_utils.trace('**********','');

266:
267: p_baldim_id := l_balance_dim_id;
268:
269: if g_debug then
270: pay_in_utils.trace('******************************','********************');
271: pay_in_utils.trace('p_baldim_id : ',p_baldim_id);
272: pay_in_utils.trace('retcode : ',retcode);
273: pay_in_utils.trace('******************************','********************');
274: end if;

Line 271: pay_in_utils.trace('p_baldim_id : ',p_baldim_id);

267: p_baldim_id := l_balance_dim_id;
268:
269: if g_debug then
270: pay_in_utils.trace('******************************','********************');
271: pay_in_utils.trace('p_baldim_id : ',p_baldim_id);
272: pay_in_utils.trace('retcode : ',retcode);
273: pay_in_utils.trace('******************************','********************');
274: end if;
275:

Line 272: pay_in_utils.trace('retcode : ',retcode);

268:
269: if g_debug then
270: pay_in_utils.trace('******************************','********************');
271: pay_in_utils.trace('p_baldim_id : ',p_baldim_id);
272: pay_in_utils.trace('retcode : ',retcode);
273: pay_in_utils.trace('******************************','********************');
274: end if;
275:
276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);

Line 273: pay_in_utils.trace('**********','');

269: if g_debug then
270: pay_in_utils.trace('******************************','********************');
271: pay_in_utils.trace('p_baldim_id : ',p_baldim_id);
272: pay_in_utils.trace('retcode : ',retcode);
273: pay_in_utils.trace('******************************','********************');
274: end if;
275:
276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);
277:

Line 276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);

272: pay_in_utils.trace('retcode : ',retcode);
273: pay_in_utils.trace('******************************','********************');
274: end if;
275:
276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);
277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

Line 280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

276: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,50);
277:
278: EXCEPTION
279: WHEN OTHERS THEN
280: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
281: IF csr_bal_dim%ISOPEN THEN
282: CLOSE csr_bal_dim;
283: END IF;
284: p_baldim_id := NULL;

Line 285: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

281: IF csr_bal_dim%ISOPEN THEN
282: CLOSE csr_bal_dim;
283: END IF;
284: p_baldim_id := NULL;
285: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
286: pay_in_utils.trace(l_message,l_procedure);
287: END check_balance_dim;
288:
289: FUNCTION validate_batch_data (p_batch_id number) RETURN number IS

Line 286: pay_in_utils.trace(l_message,l_procedure);

282: CLOSE csr_bal_dim;
283: END IF;
284: p_baldim_id := NULL;
285: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
286: pay_in_utils.trace(l_message,l_procedure);
287: END check_balance_dim;
288:
289: FUNCTION validate_batch_data (p_batch_id number) RETURN number IS
290:

Line 322: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

318:
319: BEGIN
320: g_debug := hr_utility.debug_enabled ;
321: l_procedure := g_package || 'validate_batch_data' ;
322: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
323: OPEN csr_bg;
324: FETCH csr_bg
325: INTO l_bg_id, l_leg_code;
326:

Line 333: pay_in_utils.set_location(g_debug,l_procedure,20);

329: local_error(retcode, 'validate_batch_data', 3);
330: END IF;
331: CLOSE csr_bg;
332:
333: pay_in_utils.set_location(g_debug,l_procedure,20);
334: for l_each_batch_rec in c_each_batch (p_batch_id) loop
335:
336: check_balance_type(l_bt_id, l_each_batch_rec.balance_name,
337: l_bg_id,

Line 347: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

343: l_leg_code,
344: retcode);
345: end loop;
346:
347: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
348:
349: if g_debug then
350: pay_in_utils.trace('******************************','********************');
351: pay_in_utils.trace('retcode : ',retcode);

Line 350: pay_in_utils.trace('**********','');

346:
347: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
348:
349: if g_debug then
350: pay_in_utils.trace('******************************','********************');
351: pay_in_utils.trace('retcode : ',retcode);
352: pay_in_utils.trace('******************************','********************');
353: end if;
354:

Line 351: pay_in_utils.trace('retcode : ',retcode);

347: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
348:
349: if g_debug then
350: pay_in_utils.trace('******************************','********************');
351: pay_in_utils.trace('retcode : ',retcode);
352: pay_in_utils.trace('******************************','********************');
353: end if;
354:
355: return retcode;

Line 352: pay_in_utils.trace('**********','');

348:
349: if g_debug then
350: pay_in_utils.trace('******************************','********************');
351: pay_in_utils.trace('retcode : ',retcode);
352: pay_in_utils.trace('******************************','********************');
353: end if;
354:
355: return retcode;
356:

Line 359: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

355: return retcode;
356:
357: EXCEPTION
358: WHEN OTHERS THEN
359: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
360: IF csr_bg%ISOPEN THEN
361: CLOSE csr_bg;
362: END IF;
363: IF c_each_batch%ISOPEN THEN

Line 366: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

362: END IF;
363: IF c_each_batch%ISOPEN THEN
364: CLOSE c_each_batch;
365: END IF;
366: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
367: pay_in_utils.trace(l_message,l_procedure);
368: local_error(retcode,'validate_batch_data',4);
369: END validate_batch_data;
370:

Line 367: pay_in_utils.trace(l_message,l_procedure);

363: IF c_each_batch%ISOPEN THEN
364: CLOSE c_each_batch;
365: END IF;
366: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
367: pay_in_utils.trace(l_message,l_procedure);
368: local_error(retcode,'validate_batch_data',4);
369: END validate_batch_data;
370:
371:

Line 472: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);

468: BEGIN
469:
470: g_debug := hr_utility.debug_enabled ;
471: l_procedure := g_package || 'create_bal_upl_struct' ;
472: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
473:
474: OPEN csr_bg;
475: FETCH csr_bg
476: INTO l_bg_id, l_bg_name, l_currency_code, l_leg_code;

Line 535: pay_in_utils.set_location(g_debug,l_procedure,20);

531: l_jur_count := 1;
532:
533: while (l_jur_count < g_nxt_free_jl) loop
534:
535: pay_in_utils.set_location(g_debug,l_procedure,20);
536: l_jur_level := g_jur_lev_tbl(l_jur_count);
537:
538: l_no_bal_for_jur := 0;
539: l_bal_count := 1;

Line 562: pay_in_utils.set_location(g_debug,l_procedure,30);

558:
559: l_bal_count := 1;
560: for i in 1 .. l_n_elems loop
561:
562: pay_in_utils.set_location(g_debug,l_procedure,30);
563: j := 1;
564: while (l_bal_count< g_nxt_free_baltyp
565: and j <= l_no_input_values) loop
566:

Line 570: pay_in_utils.set_location(g_debug,l_procedure,40);

566:
567: -- Does this balance have the same jurisdiction level as the
568: -- current jurisdiction level.
569:
570: pay_in_utils.set_location(g_debug,l_procedure,40);
571: if (g_baltyp_tbl_jl(l_bal_count) = l_jur_level) then
572:
573: -- Does this balance already have an initial balance feed.
574:

Line 601: pay_in_utils.trace (

597: l_jur_level||
598: '_' ||
599: to_char(i);
600:
601: pay_in_utils.trace (
602: 'Element Name is:' || l_element_name, l_procedure);
603:
604: l_element_type_id := pay_db_pay_setup.create_element (
605: p_element_name => l_element_name,

Line 622: pay_in_utils.trace (

618: p_business_group_name => l_bg_name,
619: p_processing_priority => 0,
620: p_post_termination_rule => 'Final Close');
621:
622: pay_in_utils.trace (
623: 'Element name after is:' || l_element_name, l_procedure);
624:
625: update pay_element_types_f ELEM
626: set ELEM.element_information1 = 'B'

Line 864: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);

860: l_jur_count := l_jur_count + 1;
861: end loop;
862:
863: commit;
864: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
865: EXCEPTION
866: WHEN OTHERS THEN
867: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);
868: IF csr_bg%ISOPEN THEN

Line 867: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);

863: commit;
864: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,50);
865: EXCEPTION
866: WHEN OTHERS THEN
867: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,60);
868: IF csr_bg%ISOPEN THEN
869: CLOSE csr_bg;
870: END IF;
871: IF csr_rule1%ISOPEN THEN

Line 887: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

883: IF csr_is_balance_fed%ISOPEN THEN
884: CLOSE csr_is_balance_fed;
885: END IF;
886: errbuf :=SQLERRM;
887: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
888: pay_in_utils.trace(l_message,l_procedure);
889: local_error(retcode,'create_bal_upl_struct',1);
890:
891: END create_bal_upl_struct;

Line 888: pay_in_utils.trace(l_message,l_procedure);

884: CLOSE csr_is_balance_fed;
885: END IF;
886: errbuf :=SQLERRM;
887: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
888: pay_in_utils.trace(l_message,l_procedure);
889: local_error(retcode,'create_bal_upl_struct',1);
890:
891: END create_bal_upl_struct;
892: