APPS.PAY_IN_RULES dependencies on PAY_IN_UTILS

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

23: l_message VARCHAR2(250);
24:
25: BEGIN
26: l_procedure := g_package||'get_default_run_type';
27: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
28:
29: IF g_debug THEN
30: pay_in_utils.trace ('**************************************************','********************');
31: pay_in_utils.trace ('p_asg_id',p_asg_id);

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

26: l_procedure := g_package||'get_default_run_type';
27: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
28:
29: IF g_debug THEN
30: pay_in_utils.trace ('**************************************************','********************');
31: pay_in_utils.trace ('p_asg_id',p_asg_id);
32: pay_in_utils.trace ('p_ee_id',p_ee_id);
33: pay_in_utils.trace ('p_effdate',p_effdate);
34: pay_in_utils.trace ('**************************************************','********************');

Line 31: pay_in_utils.trace ('p_asg_id',p_asg_id);

27: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
28:
29: IF g_debug THEN
30: pay_in_utils.trace ('**************************************************','********************');
31: pay_in_utils.trace ('p_asg_id',p_asg_id);
32: pay_in_utils.trace ('p_ee_id',p_ee_id);
33: pay_in_utils.trace ('p_effdate',p_effdate);
34: pay_in_utils.trace ('**************************************************','********************');
35: END IF;

Line 32: pay_in_utils.trace ('p_ee_id',p_ee_id);

28:
29: IF g_debug THEN
30: pay_in_utils.trace ('**************************************************','********************');
31: pay_in_utils.trace ('p_asg_id',p_asg_id);
32: pay_in_utils.trace ('p_ee_id',p_ee_id);
33: pay_in_utils.trace ('p_effdate',p_effdate);
34: pay_in_utils.trace ('**************************************************','********************');
35: END IF;
36:

Line 33: pay_in_utils.trace ('p_effdate',p_effdate);

29: IF g_debug THEN
30: pay_in_utils.trace ('**************************************************','********************');
31: pay_in_utils.trace ('p_asg_id',p_asg_id);
32: pay_in_utils.trace ('p_ee_id',p_ee_id);
33: pay_in_utils.trace ('p_effdate',p_effdate);
34: pay_in_utils.trace ('**************************************************','********************');
35: END IF;
36:
37: OPEN c_run_type_id;

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

30: pay_in_utils.trace ('**************************************************','********************');
31: pay_in_utils.trace ('p_asg_id',p_asg_id);
32: pay_in_utils.trace ('p_ee_id',p_ee_id);
33: pay_in_utils.trace ('p_effdate',p_effdate);
34: pay_in_utils.trace ('**************************************************','********************');
35: END IF;
36:
37: OPEN c_run_type_id;
38: FETCH c_run_type_id INTO l_run_type_id;

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

39: CLOSE c_run_type_id;
40: p_run_type := to_char(l_run_type_id);
41:
42: IF g_debug THEN
43: pay_in_utils.trace ('**************************************************','********************');
44: pay_in_utils.trace ('p_run_type',p_run_type);
45: pay_in_utils.trace ('**************************************************','********************');
46: END IF;
47: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 44: pay_in_utils.trace ('p_run_type',p_run_type);

40: p_run_type := to_char(l_run_type_id);
41:
42: IF g_debug THEN
43: pay_in_utils.trace ('**************************************************','********************');
44: pay_in_utils.trace ('p_run_type',p_run_type);
45: pay_in_utils.trace ('**************************************************','********************');
46: END IF;
47: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
48:

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

41:
42: IF g_debug THEN
43: pay_in_utils.trace ('**************************************************','********************');
44: pay_in_utils.trace ('p_run_type',p_run_type);
45: pay_in_utils.trace ('**************************************************','********************');
46: END IF;
47: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
48:
49: END get_default_run_type;

Line 47: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

43: pay_in_utils.trace ('**************************************************','********************');
44: pay_in_utils.trace ('p_run_type',p_run_type);
45: pay_in_utils.trace ('**************************************************','********************');
46: END IF;
47: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
48:
49: END get_default_run_type;
50:
51:

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

147: AND paf.effective_end_date;
148: BEGIN
149: --
150: l_procedure := g_package||'get_source_context';
151: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
152:
153: IF g_debug THEN
154: pay_in_utils.trace ('**************************************************','********************');
155: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

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

150: l_procedure := g_package||'get_source_context';
151: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
152:
153: IF g_debug THEN
154: pay_in_utils.trace ('**************************************************','********************');
155: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
156: pay_in_utils.trace ('p_ee_id',p_ee_id);
157: pay_in_utils.trace ('**************************************************','********************');
158: END IF;

Line 155: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

151: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
152:
153: IF g_debug THEN
154: pay_in_utils.trace ('**************************************************','********************');
155: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
156: pay_in_utils.trace ('p_ee_id',p_ee_id);
157: pay_in_utils.trace ('**************************************************','********************');
158: END IF;
159:

Line 156: pay_in_utils.trace ('p_ee_id',p_ee_id);

152:
153: IF g_debug THEN
154: pay_in_utils.trace ('**************************************************','********************');
155: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
156: pay_in_utils.trace ('p_ee_id',p_ee_id);
157: pay_in_utils.trace ('**************************************************','********************');
158: END IF;
159:
160: OPEN csr_element_name;

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

153: IF g_debug THEN
154: pay_in_utils.trace ('**************************************************','********************');
155: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
156: pay_in_utils.trace ('p_ee_id',p_ee_id);
157: pay_in_utils.trace ('**************************************************','********************');
158: END IF;
159:
160: OPEN csr_element_name;
161: FETCH csr_element_name INTO l_element_name;

Line 164: pay_in_utils.trace('l_element_name ',l_element_name);

160: OPEN csr_element_name;
161: FETCH csr_element_name INTO l_element_name;
162: CLOSE csr_element_name;
163: --
164: pay_in_utils.trace('l_element_name ',l_element_name);
165: pay_in_utils.set_location(g_debug,l_procedure,20);
166:
167: IF l_element_name = 'PF Information' THEN
168: OPEN csr_get_pf_source;

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

161: FETCH csr_element_name INTO l_element_name;
162: CLOSE csr_element_name;
163: --
164: pay_in_utils.trace('l_element_name ',l_element_name);
165: pay_in_utils.set_location(g_debug,l_procedure,20);
166:
167: IF l_element_name = 'PF Information' THEN
168: OPEN csr_get_pf_source;
169: FETCH csr_get_pf_source INTO p_source_id;

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

199: CLOSE csr_get_lwf_org;
200: END IF;
201:
202: IF g_debug THEN
203: pay_in_utils.trace ('**************************************************','********************');
204: pay_in_utils.trace ('p_source_id',p_source_id);
205: pay_in_utils.trace ('**************************************************','********************');
206: END IF;
207:

Line 204: pay_in_utils.trace ('p_source_id',p_source_id);

200: END IF;
201:
202: IF g_debug THEN
203: pay_in_utils.trace ('**************************************************','********************');
204: pay_in_utils.trace ('p_source_id',p_source_id);
205: pay_in_utils.trace ('**************************************************','********************');
206: END IF;
207:
208: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

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

201:
202: IF g_debug THEN
203: pay_in_utils.trace ('**************************************************','********************');
204: pay_in_utils.trace ('p_source_id',p_source_id);
205: pay_in_utils.trace ('**************************************************','********************');
206: END IF;
207:
208: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
209:

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

204: pay_in_utils.trace ('p_source_id',p_source_id);
205: pay_in_utils.trace ('**************************************************','********************');
206: END IF;
207:
208: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
209:
210: END get_source_context;
211:
212:

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

271: --
272: BEGIN
273: --
274: l_procedure := g_package||'get_default_jurisdiction';
275: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
276:
277: IF g_debug THEN
278: pay_in_utils.trace ('**************************************************','********************');
279: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

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

274: l_procedure := g_package||'get_default_jurisdiction';
275: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
276:
277: IF g_debug THEN
278: pay_in_utils.trace ('**************************************************','********************');
279: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
280: pay_in_utils.trace ('p_ee_id',p_ee_id);
281: pay_in_utils.trace ('**************************************************','********************');
282: END IF;

Line 279: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

275: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
276:
277: IF g_debug THEN
278: pay_in_utils.trace ('**************************************************','********************');
279: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
280: pay_in_utils.trace ('p_ee_id',p_ee_id);
281: pay_in_utils.trace ('**************************************************','********************');
282: END IF;
283: --

Line 280: pay_in_utils.trace ('p_ee_id',p_ee_id);

276:
277: IF g_debug THEN
278: pay_in_utils.trace ('**************************************************','********************');
279: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
280: pay_in_utils.trace ('p_ee_id',p_ee_id);
281: pay_in_utils.trace ('**************************************************','********************');
282: END IF;
283: --
284: OPEN csr_element_name;

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

277: IF g_debug THEN
278: pay_in_utils.trace ('**************************************************','********************');
279: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
280: pay_in_utils.trace ('p_ee_id',p_ee_id);
281: pay_in_utils.trace ('**************************************************','********************');
282: END IF;
283: --
284: OPEN csr_element_name;
285: FETCH csr_element_name INTO l_element_name;

Line 288: pay_in_utils.trace('l_element_name ',l_element_name);

284: OPEN csr_element_name;
285: FETCH csr_element_name INTO l_element_name;
286: CLOSE csr_element_name;
287: --
288: pay_in_utils.trace('l_element_name ',l_element_name);
289: pay_in_utils.set_location(g_debug,l_procedure,20);
290: --
291: IF l_element_name in('Income Information', 'Professional Tax Information') THEN
292: OPEN csr_get_pt_org;

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

285: FETCH csr_element_name INTO l_element_name;
286: CLOSE csr_element_name;
287: --
288: pay_in_utils.trace('l_element_name ',l_element_name);
289: pay_in_utils.set_location(g_debug,l_procedure,20);
290: --
291: IF l_element_name in('Income Information', 'Professional Tax Information') THEN
292: OPEN csr_get_pt_org;
293: FETCH csr_get_pt_org into l_org_id;

Line 296: pay_in_utils.trace('l_org_id ',l_org_id);

292: OPEN csr_get_pt_org;
293: FETCH csr_get_pt_org into l_org_id;
294: l_org_id := nvl(l_org_id, '-1');
295: CLOSE csr_get_pt_org;
296: pay_in_utils.trace('l_org_id ',l_org_id);
297: pay_in_utils.set_location(g_debug,l_procedure,30);
298: IF l_org_id = '-1' THEN
299: p_jurisdiction := 'XX';
300: ELSE

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

293: FETCH csr_get_pt_org into l_org_id;
294: l_org_id := nvl(l_org_id, '-1');
295: CLOSE csr_get_pt_org;
296: pay_in_utils.trace('l_org_id ',l_org_id);
297: pay_in_utils.set_location(g_debug,l_procedure,30);
298: IF l_org_id = '-1' THEN
299: p_jurisdiction := 'XX';
300: ELSE
301: p_jurisdiction := nvl(pay_in_prof_tax_pkg.get_state(l_org_id), 'XX');

Line 305: pay_in_utils.trace('LWF information attached ',l_element_name);

301: p_jurisdiction := nvl(pay_in_prof_tax_pkg.get_state(l_org_id), 'XX');
302: END IF;
303:
304: ELSIF l_element_name = 'LWF Information' THEN
305: pay_in_utils.trace('LWF information attached ',l_element_name);
306: OPEN csr_get_lwf_org;
307: FETCH csr_get_lwf_org into l_lwf_org_id;
308: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
309: CLOSE csr_get_lwf_org;

Line 310: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);

306: OPEN csr_get_lwf_org;
307: FETCH csr_get_lwf_org into l_lwf_org_id;
308: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
309: CLOSE csr_get_lwf_org;
310: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);
311: pay_in_utils.set_location(g_debug,l_procedure,40);
312: IF l_lwf_org_id = '-1' THEN
313: p_jurisdiction := 'XX';
314: ELSE

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

307: FETCH csr_get_lwf_org into l_lwf_org_id;
308: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
309: CLOSE csr_get_lwf_org;
310: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);
311: pay_in_utils.set_location(g_debug,l_procedure,40);
312: IF l_lwf_org_id = '-1' THEN
313: p_jurisdiction := 'XX';
314: ELSE
315: p_jurisdiction := nvl(pay_in_ff_pkg.get_lwf_state(l_lwf_org_id), 'XX');

Line 319: pay_in_utils.trace('LWF Process Separate Information ',l_element_name);

315: p_jurisdiction := nvl(pay_in_ff_pkg.get_lwf_state(l_lwf_org_id), 'XX');
316: END IF;
317:
318: ELSIF l_element_name = 'LWF Process Separate' THEN ------bug 14161453
319: pay_in_utils.trace('LWF Process Separate Information ',l_element_name);
320: OPEN csr_get_lwf_org;
321: FETCH csr_get_lwf_org into l_lwf_org_id;
322: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
323: CLOSE csr_get_lwf_org;

Line 324: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);

320: OPEN csr_get_lwf_org;
321: FETCH csr_get_lwf_org into l_lwf_org_id;
322: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
323: CLOSE csr_get_lwf_org;
324: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);
325: pay_in_utils.set_location(g_debug,l_procedure,40);
326: IF l_lwf_org_id = '-1' THEN
327: p_jurisdiction := 'XX';
328: ELSE

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

321: FETCH csr_get_lwf_org into l_lwf_org_id;
322: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
323: CLOSE csr_get_lwf_org;
324: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);
325: pay_in_utils.set_location(g_debug,l_procedure,40);
326: IF l_lwf_org_id = '-1' THEN
327: p_jurisdiction := 'XX';
328: ELSE
329: p_jurisdiction := nvl(pay_in_ff_pkg.get_lwf_state(l_lwf_org_id), 'XX');

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

330: END IF;
331: END IF;
332:
333: IF g_debug THEN
334: pay_in_utils.trace ('**************************************************','********************');
335: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
336: pay_in_utils.trace ('**************************************************','********************');
337: END IF;
338:

Line 335: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);

331: END IF;
332:
333: IF g_debug THEN
334: pay_in_utils.trace ('**************************************************','********************');
335: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
336: pay_in_utils.trace ('**************************************************','********************');
337: END IF;
338:
339: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

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

332:
333: IF g_debug THEN
334: pay_in_utils.trace ('**************************************************','********************');
335: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
336: pay_in_utils.trace ('**************************************************','********************');
337: END IF;
338:
339: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
340:

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

335: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
336: pay_in_utils.trace ('**************************************************','********************');
337: END IF;
338:
339: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
340:
341: END get_default_jurisdiction;
342: --
343:

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

363:
364: BEGIN
365:
366: l_procedure := g_package||'get_source_text2_context';
367: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
368:
369: IF g_debug THEN
370: pay_in_utils.trace ('**************************************************','********************');
371: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

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

366: l_procedure := g_package||'get_source_text2_context';
367: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
368:
369: IF g_debug THEN
370: pay_in_utils.trace ('**************************************************','********************');
371: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
372: pay_in_utils.trace ('p_ee_id',p_ee_id);
373: pay_in_utils.trace ('**************************************************','********************');
374: END IF;

Line 371: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

367: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
368:
369: IF g_debug THEN
370: pay_in_utils.trace ('**************************************************','********************');
371: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
372: pay_in_utils.trace ('p_ee_id',p_ee_id);
373: pay_in_utils.trace ('**************************************************','********************');
374: END IF;
375:

Line 372: pay_in_utils.trace ('p_ee_id',p_ee_id);

368:
369: IF g_debug THEN
370: pay_in_utils.trace ('**************************************************','********************');
371: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
372: pay_in_utils.trace ('p_ee_id',p_ee_id);
373: pay_in_utils.trace ('**************************************************','********************');
374: END IF;
375:
376: OPEN csr_context;

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

369: IF g_debug THEN
370: pay_in_utils.trace ('**************************************************','********************');
371: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
372: pay_in_utils.trace ('p_ee_id',p_ee_id);
373: pay_in_utils.trace ('**************************************************','********************');
374: END IF;
375:
376: OPEN csr_context;
377: FETCH csr_context

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

381: END IF;
382: CLOSE csr_context;
383:
384: IF g_debug THEN
385: pay_in_utils.trace ('**************************************************','********************');
386: pay_in_utils.trace ('p_source_text2',p_source_text2);
387: pay_in_utils.trace ('**************************************************','********************');
388: END IF;
389:

Line 386: pay_in_utils.trace ('p_source_text2',p_source_text2);

382: CLOSE csr_context;
383:
384: IF g_debug THEN
385: pay_in_utils.trace ('**************************************************','********************');
386: pay_in_utils.trace ('p_source_text2',p_source_text2);
387: pay_in_utils.trace ('**************************************************','********************');
388: END IF;
389:
390: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

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

383:
384: IF g_debug THEN
385: pay_in_utils.trace ('**************************************************','********************');
386: pay_in_utils.trace ('p_source_text2',p_source_text2);
387: pay_in_utils.trace ('**************************************************','********************');
388: END IF;
389:
390: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
391:

Line 390: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

386: pay_in_utils.trace ('p_source_text2',p_source_text2);
387: pay_in_utils.trace ('**************************************************','********************');
388: END IF;
389:
390: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
391:
392: END get_source_text2_context;
393:
394:

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

402: l_template_obj PAY_ELE_TMPLT_OBJ;
403:
404: BEGIN
405: l_procedure := g_package||'element_template_pre_process';
406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: l_template_obj := p_template_obj;
409: l_template_obj :=
410: pay_in_element_template_pkg.element_template_pre_process

Line 413: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

409: l_template_obj :=
410: pay_in_element_template_pkg.element_template_pre_process
411: (p_template_obj => p_template_obj);
412:
413: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
414: RETURN l_template_obj;
415:
416: END element_template_pre_process;
417:

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

426:
427: BEGIN
428:
429: l_procedure := g_package||'element_template_upd_user_stru';
430: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
431:
432: IF g_debug THEN
433: pay_in_utils.trace ('**************************************************','********************');
434: pay_in_utils.trace ('p_template_id',p_template_id);

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

429: l_procedure := g_package||'element_template_upd_user_stru';
430: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
431:
432: IF g_debug THEN
433: pay_in_utils.trace ('**************************************************','********************');
434: pay_in_utils.trace ('p_template_id',p_template_id);
435: pay_in_utils.trace ('**************************************************','********************');
436: END IF;
437:

Line 434: pay_in_utils.trace ('p_template_id',p_template_id);

430: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
431:
432: IF g_debug THEN
433: pay_in_utils.trace ('**************************************************','********************');
434: pay_in_utils.trace ('p_template_id',p_template_id);
435: pay_in_utils.trace ('**************************************************','********************');
436: END IF;
437:
438: pay_in_element_template_pkg.element_template_upd_user_stru

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

431:
432: IF g_debug THEN
433: pay_in_utils.trace ('**************************************************','********************');
434: pay_in_utils.trace ('p_template_id',p_template_id);
435: pay_in_utils.trace ('**************************************************','********************');
436: END IF;
437:
438: pay_in_element_template_pkg.element_template_upd_user_stru
439: (p_template_id => p_template_id);

Line 441: pay_in_utils.trace('p_template_id ',p_template_id);

437:
438: pay_in_element_template_pkg.element_template_upd_user_stru
439: (p_template_id => p_template_id);
440:
441: pay_in_utils.trace('p_template_id ',p_template_id);
442: pay_in_utils.set_location(g_debug,l_procedure,20);
443:
444: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
445:

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

438: pay_in_element_template_pkg.element_template_upd_user_stru
439: (p_template_id => p_template_id);
440:
441: pay_in_utils.trace('p_template_id ',p_template_id);
442: pay_in_utils.set_location(g_debug,l_procedure,20);
443:
444: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
445:
446: END element_template_upd_user_stru;

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

440:
441: pay_in_utils.trace('p_template_id ',p_template_id);
442: pay_in_utils.set_location(g_debug,l_procedure,20);
443:
444: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
445:
446: END element_template_upd_user_stru;
447:
448:

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

456:
457: BEGIN
458:
459: l_procedure := g_package||'element_template_post_process';
460: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
461:
462: IF g_debug THEN
463: pay_in_utils.trace ('**************************************************','********************');
464: pay_in_utils.trace ('p_template_id',p_template_id);

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

459: l_procedure := g_package||'element_template_post_process';
460: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
461:
462: IF g_debug THEN
463: pay_in_utils.trace ('**************************************************','********************');
464: pay_in_utils.trace ('p_template_id',p_template_id);
465: pay_in_utils.trace ('**************************************************','********************');
466: END IF;
467:

Line 464: pay_in_utils.trace ('p_template_id',p_template_id);

460: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
461:
462: IF g_debug THEN
463: pay_in_utils.trace ('**************************************************','********************');
464: pay_in_utils.trace ('p_template_id',p_template_id);
465: pay_in_utils.trace ('**************************************************','********************');
466: END IF;
467:
468: pay_in_utils.set_location(g_debug, l_procedure, 20);

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

461:
462: IF g_debug THEN
463: pay_in_utils.trace ('**************************************************','********************');
464: pay_in_utils.trace ('p_template_id',p_template_id);
465: pay_in_utils.trace ('**************************************************','********************');
466: END IF;
467:
468: pay_in_utils.set_location(g_debug, l_procedure, 20);
469: pay_in_element_template_pkg.element_template_post_process

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

464: pay_in_utils.trace ('p_template_id',p_template_id);
465: pay_in_utils.trace ('**************************************************','********************');
466: END IF;
467:
468: pay_in_utils.set_location(g_debug, l_procedure, 20);
469: pay_in_element_template_pkg.element_template_post_process
470: (p_template_id => p_template_id);
471:
472: pay_in_utils.trace('p_template_id ',p_template_id);

Line 472: pay_in_utils.trace('p_template_id ',p_template_id);

468: pay_in_utils.set_location(g_debug, l_procedure, 20);
469: pay_in_element_template_pkg.element_template_post_process
470: (p_template_id => p_template_id);
471:
472: pay_in_utils.trace('p_template_id ',p_template_id);
473: pay_in_utils.set_location(g_debug,l_procedure,30);
474:
475: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
476:

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

469: pay_in_element_template_pkg.element_template_post_process
470: (p_template_id => p_template_id);
471:
472: pay_in_utils.trace('p_template_id ',p_template_id);
473: pay_in_utils.set_location(g_debug,l_procedure,30);
474:
475: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
476:
477: END element_template_post_process;

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

471:
472: pay_in_utils.trace('p_template_id ',p_template_id);
473: pay_in_utils.set_location(g_debug,l_procedure,30);
474:
475: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
476:
477: END element_template_post_process;
478:
479:

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

488:
489: BEGIN
490:
491: l_procedure := g_package||'get_source_text2_context';
492: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
493:
494: IF g_debug THEN
495: pay_in_utils.trace ('**************************************************','********************');
496: pay_in_utils.trace ('p_template_id',p_template_id);

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

491: l_procedure := g_package||'get_source_text2_context';
492: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
493:
494: IF g_debug THEN
495: pay_in_utils.trace ('**************************************************','********************');
496: pay_in_utils.trace ('p_template_id',p_template_id);
497: pay_in_utils.trace ('**************************************************','********************');
498: END IF;
499:

Line 496: pay_in_utils.trace ('p_template_id',p_template_id);

492: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
493:
494: IF g_debug THEN
495: pay_in_utils.trace ('**************************************************','********************');
496: pay_in_utils.trace ('p_template_id',p_template_id);
497: pay_in_utils.trace ('**************************************************','********************');
498: END IF;
499:
500: pay_in_element_template_pkg.delete_pre_process

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

493:
494: IF g_debug THEN
495: pay_in_utils.trace ('**************************************************','********************');
496: pay_in_utils.trace ('p_template_id',p_template_id);
497: pay_in_utils.trace ('**************************************************','********************');
498: END IF;
499:
500: pay_in_element_template_pkg.delete_pre_process
501: (p_template_id => p_template_id);

Line 503: pay_in_utils.trace('p_template_id ',p_template_id);

499:
500: pay_in_element_template_pkg.delete_pre_process
501: (p_template_id => p_template_id);
502:
503: pay_in_utils.trace('p_template_id ',p_template_id);
504: pay_in_utils.set_location(g_debug,l_procedure,20);
505:
506: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
507:

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

500: pay_in_element_template_pkg.delete_pre_process
501: (p_template_id => p_template_id);
502:
503: pay_in_utils.trace('p_template_id ',p_template_id);
504: pay_in_utils.set_location(g_debug,l_procedure,20);
505:
506: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
507:
508:

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

502:
503: pay_in_utils.trace('p_template_id ',p_template_id);
504: pay_in_utils.set_location(g_debug,l_procedure,20);
505:
506: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
507:
508:
509: END delete_pre_process;
510: