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 195: pay_in_utils.trace ('**************************************************','********************');

191: p_source_id := nvl(p_source_id, '-1');
192: CLOSE csr_get_lwf_org;
193: END IF;
194: IF g_debug THEN
195: pay_in_utils.trace ('**************************************************','********************');
196: pay_in_utils.trace ('p_source_id',p_source_id);
197: pay_in_utils.trace ('**************************************************','********************');
198: END IF;
199:

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

192: CLOSE csr_get_lwf_org;
193: END IF;
194: IF g_debug THEN
195: pay_in_utils.trace ('**************************************************','********************');
196: pay_in_utils.trace ('p_source_id',p_source_id);
197: pay_in_utils.trace ('**************************************************','********************');
198: END IF;
199:
200: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

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

193: END IF;
194: IF g_debug THEN
195: pay_in_utils.trace ('**************************************************','********************');
196: pay_in_utils.trace ('p_source_id',p_source_id);
197: pay_in_utils.trace ('**************************************************','********************');
198: END IF;
199:
200: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
201:

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

196: pay_in_utils.trace ('p_source_id',p_source_id);
197: pay_in_utils.trace ('**************************************************','********************');
198: END IF;
199:
200: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
201:
202: END get_source_context;
203:
204:

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

263: --
264: BEGIN
265: --
266: l_procedure := g_package||'get_default_jurisdiction';
267: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
268:
269: IF g_debug THEN
270: pay_in_utils.trace ('**************************************************','********************');
271: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

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

266: l_procedure := g_package||'get_default_jurisdiction';
267: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
268:
269: IF g_debug THEN
270: pay_in_utils.trace ('**************************************************','********************');
271: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
272: pay_in_utils.trace ('p_ee_id',p_ee_id);
273: pay_in_utils.trace ('**************************************************','********************');
274: END IF;

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

267: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
268:
269: IF g_debug THEN
270: pay_in_utils.trace ('**************************************************','********************');
271: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
272: pay_in_utils.trace ('p_ee_id',p_ee_id);
273: pay_in_utils.trace ('**************************************************','********************');
274: END IF;
275: --

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

268:
269: IF g_debug THEN
270: pay_in_utils.trace ('**************************************************','********************');
271: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
272: pay_in_utils.trace ('p_ee_id',p_ee_id);
273: pay_in_utils.trace ('**************************************************','********************');
274: END IF;
275: --
276: OPEN csr_element_name;

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

269: IF g_debug THEN
270: pay_in_utils.trace ('**************************************************','********************');
271: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
272: pay_in_utils.trace ('p_ee_id',p_ee_id);
273: pay_in_utils.trace ('**************************************************','********************');
274: END IF;
275: --
276: OPEN csr_element_name;
277: FETCH csr_element_name INTO l_element_name;

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

276: OPEN csr_element_name;
277: FETCH csr_element_name INTO l_element_name;
278: CLOSE csr_element_name;
279: --
280: pay_in_utils.trace('l_element_name ',l_element_name);
281: pay_in_utils.set_location(g_debug,l_procedure,20);
282: --
283: IF l_element_name in('Income Information', 'Professional Tax Information') THEN
284: OPEN csr_get_pt_org;

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

277: FETCH csr_element_name INTO l_element_name;
278: CLOSE csr_element_name;
279: --
280: pay_in_utils.trace('l_element_name ',l_element_name);
281: pay_in_utils.set_location(g_debug,l_procedure,20);
282: --
283: IF l_element_name in('Income Information', 'Professional Tax Information') THEN
284: OPEN csr_get_pt_org;
285: FETCH csr_get_pt_org into l_org_id;

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

284: OPEN csr_get_pt_org;
285: FETCH csr_get_pt_org into l_org_id;
286: l_org_id := nvl(l_org_id, '-1');
287: CLOSE csr_get_pt_org;
288: pay_in_utils.trace('l_org_id ',l_org_id);
289: pay_in_utils.set_location(g_debug,l_procedure,30);
290: IF l_org_id = '-1' THEN
291: p_jurisdiction := 'XX';
292: ELSE

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

285: FETCH csr_get_pt_org into l_org_id;
286: l_org_id := nvl(l_org_id, '-1');
287: CLOSE csr_get_pt_org;
288: pay_in_utils.trace('l_org_id ',l_org_id);
289: pay_in_utils.set_location(g_debug,l_procedure,30);
290: IF l_org_id = '-1' THEN
291: p_jurisdiction := 'XX';
292: ELSE
293: p_jurisdiction := nvl(pay_in_prof_tax_pkg.get_state(l_org_id), 'XX');

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

293: p_jurisdiction := nvl(pay_in_prof_tax_pkg.get_state(l_org_id), 'XX');
294: END IF;
295:
296: ELSIF l_element_name = 'LWF Information' THEN
297: pay_in_utils.trace('LWF information attached ',l_element_name);
298: OPEN csr_get_lwf_org;
299: FETCH csr_get_lwf_org into l_lwf_org_id;
300: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
301: CLOSE csr_get_lwf_org;

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

298: OPEN csr_get_lwf_org;
299: FETCH csr_get_lwf_org into l_lwf_org_id;
300: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
301: CLOSE csr_get_lwf_org;
302: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);
303: pay_in_utils.set_location(g_debug,l_procedure,40);
304: IF l_lwf_org_id = '-1' THEN
305: p_jurisdiction := 'XX';
306: ELSE

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

299: FETCH csr_get_lwf_org into l_lwf_org_id;
300: l_lwf_org_id := nvl(l_lwf_org_id, '-1');
301: CLOSE csr_get_lwf_org;
302: pay_in_utils.trace('l_lwf_org_id ',l_lwf_org_id);
303: pay_in_utils.set_location(g_debug,l_procedure,40);
304: IF l_lwf_org_id = '-1' THEN
305: p_jurisdiction := 'XX';
306: ELSE
307: p_jurisdiction := nvl(pay_in_ff_pkg.get_lwf_state(l_lwf_org_id), 'XX');

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

308: END IF;
309: END IF;
310:
311: IF g_debug THEN
312: pay_in_utils.trace ('**************************************************','********************');
313: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
314: pay_in_utils.trace ('**************************************************','********************');
315: END IF;
316:

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

309: END IF;
310:
311: IF g_debug THEN
312: pay_in_utils.trace ('**************************************************','********************');
313: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
314: pay_in_utils.trace ('**************************************************','********************');
315: END IF;
316:
317: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

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

310:
311: IF g_debug THEN
312: pay_in_utils.trace ('**************************************************','********************');
313: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
314: pay_in_utils.trace ('**************************************************','********************');
315: END IF;
316:
317: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
318:

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

313: pay_in_utils.trace ('p_jurisdiction',p_jurisdiction);
314: pay_in_utils.trace ('**************************************************','********************');
315: END IF;
316:
317: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
318:
319: END get_default_jurisdiction;
320: --
321:

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

341:
342: BEGIN
343:
344: l_procedure := g_package||'get_source_text2_context';
345: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
346:
347: IF g_debug THEN
348: pay_in_utils.trace ('**************************************************','********************');
349: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);

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

344: l_procedure := g_package||'get_source_text2_context';
345: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
346:
347: IF g_debug THEN
348: pay_in_utils.trace ('**************************************************','********************');
349: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
350: pay_in_utils.trace ('p_ee_id',p_ee_id);
351: pay_in_utils.trace ('**************************************************','********************');
352: END IF;

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

345: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
346:
347: IF g_debug THEN
348: pay_in_utils.trace ('**************************************************','********************');
349: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
350: pay_in_utils.trace ('p_ee_id',p_ee_id);
351: pay_in_utils.trace ('**************************************************','********************');
352: END IF;
353:

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

346:
347: IF g_debug THEN
348: pay_in_utils.trace ('**************************************************','********************');
349: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
350: pay_in_utils.trace ('p_ee_id',p_ee_id);
351: pay_in_utils.trace ('**************************************************','********************');
352: END IF;
353:
354: OPEN csr_context;

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

347: IF g_debug THEN
348: pay_in_utils.trace ('**************************************************','********************');
349: pay_in_utils.trace ('p_asg_act_id',p_asg_act_id);
350: pay_in_utils.trace ('p_ee_id',p_ee_id);
351: pay_in_utils.trace ('**************************************************','********************');
352: END IF;
353:
354: OPEN csr_context;
355: FETCH csr_context

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

359: END IF;
360: CLOSE csr_context;
361:
362: IF g_debug THEN
363: pay_in_utils.trace ('**************************************************','********************');
364: pay_in_utils.trace ('p_source_text2',p_source_text2);
365: pay_in_utils.trace ('**************************************************','********************');
366: END IF;
367:

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

360: CLOSE csr_context;
361:
362: IF g_debug THEN
363: pay_in_utils.trace ('**************************************************','********************');
364: pay_in_utils.trace ('p_source_text2',p_source_text2);
365: pay_in_utils.trace ('**************************************************','********************');
366: END IF;
367:
368: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

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

361:
362: IF g_debug THEN
363: pay_in_utils.trace ('**************************************************','********************');
364: pay_in_utils.trace ('p_source_text2',p_source_text2);
365: pay_in_utils.trace ('**************************************************','********************');
366: END IF;
367:
368: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
369:

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

364: pay_in_utils.trace ('p_source_text2',p_source_text2);
365: pay_in_utils.trace ('**************************************************','********************');
366: END IF;
367:
368: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
369:
370: END get_source_text2_context;
371:
372:

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

380: l_template_obj PAY_ELE_TMPLT_OBJ;
381:
382: BEGIN
383: l_procedure := g_package||'element_template_pre_process';
384: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
385:
386: l_template_obj := p_template_obj;
387: l_template_obj :=
388: pay_in_element_template_pkg.element_template_pre_process

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

387: l_template_obj :=
388: pay_in_element_template_pkg.element_template_pre_process
389: (p_template_obj => p_template_obj);
390:
391: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
392: RETURN l_template_obj;
393:
394: END element_template_pre_process;
395:

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

404:
405: BEGIN
406:
407: l_procedure := g_package||'element_template_upd_user_stru';
408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
409:
410: IF g_debug THEN
411: pay_in_utils.trace ('**************************************************','********************');
412: pay_in_utils.trace ('p_template_id',p_template_id);

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

407: l_procedure := g_package||'element_template_upd_user_stru';
408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
409:
410: IF g_debug THEN
411: pay_in_utils.trace ('**************************************************','********************');
412: pay_in_utils.trace ('p_template_id',p_template_id);
413: pay_in_utils.trace ('**************************************************','********************');
414: END IF;
415:

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

408: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
409:
410: IF g_debug THEN
411: pay_in_utils.trace ('**************************************************','********************');
412: pay_in_utils.trace ('p_template_id',p_template_id);
413: pay_in_utils.trace ('**************************************************','********************');
414: END IF;
415:
416: pay_in_element_template_pkg.element_template_upd_user_stru

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

409:
410: IF g_debug THEN
411: pay_in_utils.trace ('**************************************************','********************');
412: pay_in_utils.trace ('p_template_id',p_template_id);
413: pay_in_utils.trace ('**************************************************','********************');
414: END IF;
415:
416: pay_in_element_template_pkg.element_template_upd_user_stru
417: (p_template_id => p_template_id);

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

415:
416: pay_in_element_template_pkg.element_template_upd_user_stru
417: (p_template_id => p_template_id);
418:
419: pay_in_utils.trace('p_template_id ',p_template_id);
420: pay_in_utils.set_location(g_debug,l_procedure,20);
421:
422: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
423:

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

416: pay_in_element_template_pkg.element_template_upd_user_stru
417: (p_template_id => p_template_id);
418:
419: pay_in_utils.trace('p_template_id ',p_template_id);
420: pay_in_utils.set_location(g_debug,l_procedure,20);
421:
422: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
423:
424: END element_template_upd_user_stru;

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

418:
419: pay_in_utils.trace('p_template_id ',p_template_id);
420: pay_in_utils.set_location(g_debug,l_procedure,20);
421:
422: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
423:
424: END element_template_upd_user_stru;
425:
426:

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

434:
435: BEGIN
436:
437: l_procedure := g_package||'element_template_post_process';
438: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
439:
440: IF g_debug THEN
441: pay_in_utils.trace ('**************************************************','********************');
442: pay_in_utils.trace ('p_template_id',p_template_id);

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

437: l_procedure := g_package||'element_template_post_process';
438: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
439:
440: IF g_debug THEN
441: pay_in_utils.trace ('**************************************************','********************');
442: pay_in_utils.trace ('p_template_id',p_template_id);
443: pay_in_utils.trace ('**************************************************','********************');
444: END IF;
445:

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

438: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
439:
440: IF g_debug THEN
441: pay_in_utils.trace ('**************************************************','********************');
442: pay_in_utils.trace ('p_template_id',p_template_id);
443: pay_in_utils.trace ('**************************************************','********************');
444: END IF;
445:
446: pay_in_utils.set_location(g_debug, l_procedure, 20);

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

439:
440: IF g_debug THEN
441: pay_in_utils.trace ('**************************************************','********************');
442: pay_in_utils.trace ('p_template_id',p_template_id);
443: pay_in_utils.trace ('**************************************************','********************');
444: END IF;
445:
446: pay_in_utils.set_location(g_debug, l_procedure, 20);
447: pay_in_element_template_pkg.element_template_post_process

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

442: pay_in_utils.trace ('p_template_id',p_template_id);
443: pay_in_utils.trace ('**************************************************','********************');
444: END IF;
445:
446: pay_in_utils.set_location(g_debug, l_procedure, 20);
447: pay_in_element_template_pkg.element_template_post_process
448: (p_template_id => p_template_id);
449:
450: pay_in_utils.trace('p_template_id ',p_template_id);

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

446: pay_in_utils.set_location(g_debug, l_procedure, 20);
447: pay_in_element_template_pkg.element_template_post_process
448: (p_template_id => p_template_id);
449:
450: pay_in_utils.trace('p_template_id ',p_template_id);
451: pay_in_utils.set_location(g_debug,l_procedure,30);
452:
453: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
454:

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

447: pay_in_element_template_pkg.element_template_post_process
448: (p_template_id => p_template_id);
449:
450: pay_in_utils.trace('p_template_id ',p_template_id);
451: pay_in_utils.set_location(g_debug,l_procedure,30);
452:
453: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
454:
455: END element_template_post_process;

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

449:
450: pay_in_utils.trace('p_template_id ',p_template_id);
451: pay_in_utils.set_location(g_debug,l_procedure,30);
452:
453: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
454:
455: END element_template_post_process;
456:
457:

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

466:
467: BEGIN
468:
469: l_procedure := g_package||'get_source_text2_context';
470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN
473: pay_in_utils.trace ('**************************************************','********************');
474: pay_in_utils.trace ('p_template_id',p_template_id);

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

469: l_procedure := g_package||'get_source_text2_context';
470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN
473: pay_in_utils.trace ('**************************************************','********************');
474: pay_in_utils.trace ('p_template_id',p_template_id);
475: pay_in_utils.trace ('**************************************************','********************');
476: END IF;
477:

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

470: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
471:
472: IF g_debug THEN
473: pay_in_utils.trace ('**************************************************','********************');
474: pay_in_utils.trace ('p_template_id',p_template_id);
475: pay_in_utils.trace ('**************************************************','********************');
476: END IF;
477:
478: pay_in_element_template_pkg.delete_pre_process

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

471:
472: IF g_debug THEN
473: pay_in_utils.trace ('**************************************************','********************');
474: pay_in_utils.trace ('p_template_id',p_template_id);
475: pay_in_utils.trace ('**************************************************','********************');
476: END IF;
477:
478: pay_in_element_template_pkg.delete_pre_process
479: (p_template_id => p_template_id);

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

477:
478: pay_in_element_template_pkg.delete_pre_process
479: (p_template_id => p_template_id);
480:
481: pay_in_utils.trace('p_template_id ',p_template_id);
482: pay_in_utils.set_location(g_debug,l_procedure,20);
483:
484: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
485:

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

478: pay_in_element_template_pkg.delete_pre_process
479: (p_template_id => p_template_id);
480:
481: pay_in_utils.trace('p_template_id ',p_template_id);
482: pay_in_utils.set_location(g_debug,l_procedure,20);
483:
484: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
485:
486:

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

480:
481: pay_in_utils.trace('p_template_id ',p_template_id);
482: pay_in_utils.set_location(g_debug,l_procedure,20);
483:
484: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
485:
486:
487: END delete_pre_process;
488: