APPS.PAY_IN_24Q_ER_RETURNS dependencies on PAY_IN_UTILS

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

38:
39: BEGIN
40: g_debug := hr_utility.debug_enabled;
41: l_procedure := g_package ||'challan_rec_count';
42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
43:
44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

41: l_procedure := g_package ||'challan_rec_count';
42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
43:
44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');

Line 46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

42: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
43:
44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;

Line 47: pay_in_utils.trace('p_assess_period',p_assess_period);

43:
44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;
51:

Line 48: pay_in_utils.trace('p_max_action_id',p_max_action_id);

44: IF g_debug THEN
45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;
51:
52: OPEN c_count;

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

45: pay_in_utils.trace('**************************************************','********************');
46: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
47: pay_in_utils.trace('p_assess_period',p_assess_period);
48: pay_in_utils.trace('p_max_action_id',p_max_action_id);
49: pay_in_utils.trace('**************************************************','********************');
50: END IF;
51:
52: OPEN c_count;
53: FETCH c_count INTO l_count;

Line 62: pay_in_utils.trace('l_count',TO_CHAR(l_count));

58: CLOSE c_count;
59:
60:
61: IF g_debug THEN
62: pay_in_utils.trace('l_count',TO_CHAR(l_count));
63: END IF;
64: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
65:
66: RETURN TO_CHAR(l_count);

Line 64: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

60:
61: IF g_debug THEN
62: pay_in_utils.trace('l_count',TO_CHAR(l_count));
63: END IF;
64: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
65:
66: RETURN TO_CHAR(l_count);
67:
68: END challan_rec_count;

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

127:
128: BEGIN
129: g_debug := hr_utility.debug_enabled;
130: l_procedure := g_package ||'deductee_rec_count';
131: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
132:
133: IF g_debug THEN
134: pay_in_utils.trace('**************************************************','********************');
135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

130: l_procedure := g_package ||'deductee_rec_count';
131: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
132:
133: IF g_debug THEN
134: pay_in_utils.trace('**************************************************','********************');
135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
136: pay_in_utils.trace('p_max_action_id',p_max_action_id);
137: pay_in_utils.trace('p_challan',p_challan);
138: pay_in_utils.trace('**************************************************','********************');

Line 135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

131: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
132:
133: IF g_debug THEN
134: pay_in_utils.trace('**************************************************','********************');
135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
136: pay_in_utils.trace('p_max_action_id',p_max_action_id);
137: pay_in_utils.trace('p_challan',p_challan);
138: pay_in_utils.trace('**************************************************','********************');
139: END IF;

Line 136: pay_in_utils.trace('p_max_action_id',p_max_action_id);

132:
133: IF g_debug THEN
134: pay_in_utils.trace('**************************************************','********************');
135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
136: pay_in_utils.trace('p_max_action_id',p_max_action_id);
137: pay_in_utils.trace('p_challan',p_challan);
138: pay_in_utils.trace('**************************************************','********************');
139: END IF;
140:

Line 137: pay_in_utils.trace('p_challan',p_challan);

133: IF g_debug THEN
134: pay_in_utils.trace('**************************************************','********************');
135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
136: pay_in_utils.trace('p_max_action_id',p_max_action_id);
137: pay_in_utils.trace('p_challan',p_challan);
138: pay_in_utils.trace('**************************************************','********************');
139: END IF;
140:
141: OPEN c_count;

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

134: pay_in_utils.trace('**************************************************','********************');
135: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
136: pay_in_utils.trace('p_max_action_id',p_max_action_id);
137: pay_in_utils.trace('p_challan',p_challan);
138: pay_in_utils.trace('**************************************************','********************');
139: END IF;
140:
141: OPEN c_count;
142: FETCH c_count INTO l_count;

Line 152: pay_in_utils.trace('l_count',TO_CHAR(l_count));

148:
149:
150:
151: IF g_debug THEN
152: pay_in_utils.trace('l_count',TO_CHAR(l_count));
153: END IF;
154:
155: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
156:

Line 155: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

151: IF g_debug THEN
152: pay_in_utils.trace('l_count',TO_CHAR(l_count));
153: END IF;
154:
155: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
156:
157: RETURN TO_CHAR(l_count);
158:
159: END deductee_rec_count;

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

207:
208: BEGIN
209: g_debug := hr_utility.debug_enabled;
210: l_procedure := g_package ||'gross_tot_tds_challan';
211: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
212:
213: IF g_debug THEN
214: pay_in_utils.trace('**************************************************','********************');
215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

210: l_procedure := g_package ||'gross_tot_tds_challan';
211: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
212:
213: IF g_debug THEN
214: pay_in_utils.trace('**************************************************','********************');
215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
216: pay_in_utils.trace('p_assess_period',p_assess_period);
217: pay_in_utils.trace('p_max_action_id',p_max_action_id);
218: pay_in_utils.trace('**************************************************','********************');

Line 215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

211: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
212:
213: IF g_debug THEN
214: pay_in_utils.trace('**************************************************','********************');
215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
216: pay_in_utils.trace('p_assess_period',p_assess_period);
217: pay_in_utils.trace('p_max_action_id',p_max_action_id);
218: pay_in_utils.trace('**************************************************','********************');
219: END IF;

Line 216: pay_in_utils.trace('p_assess_period',p_assess_period);

212:
213: IF g_debug THEN
214: pay_in_utils.trace('**************************************************','********************');
215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
216: pay_in_utils.trace('p_assess_period',p_assess_period);
217: pay_in_utils.trace('p_max_action_id',p_max_action_id);
218: pay_in_utils.trace('**************************************************','********************');
219: END IF;
220:

Line 217: pay_in_utils.trace('p_max_action_id',p_max_action_id);

213: IF g_debug THEN
214: pay_in_utils.trace('**************************************************','********************');
215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
216: pay_in_utils.trace('p_assess_period',p_assess_period);
217: pay_in_utils.trace('p_max_action_id',p_max_action_id);
218: pay_in_utils.trace('**************************************************','********************');
219: END IF;
220:
221: OPEN c_challan_tax_tot;

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

214: pay_in_utils.trace('**************************************************','********************');
215: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
216: pay_in_utils.trace('p_assess_period',p_assess_period);
217: pay_in_utils.trace('p_max_action_id',p_max_action_id);
218: pay_in_utils.trace('**************************************************','********************');
219: END IF;
220:
221: OPEN c_challan_tax_tot;
222: FETCH c_challan_tax_tot INTO l_tds,l_sur,l_ec,l_intr,l_oth;

Line 233: pay_in_utils.trace('l_total',SUBSTR(l_total,1,15));

229:
230:
231:
232: IF g_debug THEN
233: pay_in_utils.trace('l_total',SUBSTR(l_total,1,15));
234: END IF;
235:
236: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
237:

Line 236: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

232: IF g_debug THEN
233: pay_in_utils.trace('l_total',SUBSTR(l_total,1,15));
234: END IF;
235:
236: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
237:
238: RETURN SUBSTR(l_total,1,15);
239:
240: END gross_tot_tds_challan;

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

259:
260: BEGIN
261: g_debug := hr_utility.debug_enabled;
262: l_procedure := g_package ||'get_format_value';
263: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
264: IF g_debug THEN
265: pay_in_utils.trace('p_value',p_value);
266: END IF;
267:

Line 265: pay_in_utils.trace('p_value',p_value);

261: g_debug := hr_utility.debug_enabled;
262: l_procedure := g_package ||'get_format_value';
263: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
264: IF g_debug THEN
265: pay_in_utils.trace('p_value',p_value);
266: END IF;
267:
268: l_value_temp := trunc(fnd_number.canonical_to_number(p_value), 2);
269:

Line 284: pay_in_utils.trace('l_value',l_value);

280:
281:
282:
283: IF g_debug THEN
284: pay_in_utils.trace('l_value',l_value);
285: END IF;
286:
287: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
288:

Line 287: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

283: IF g_debug THEN
284: pay_in_utils.trace('l_value',l_value);
285: END IF;
286:
287: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
288:
289: RETURN l_value;
290:
291: END get_format_value;

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

338:
339: BEGIN
340: g_debug := hr_utility.debug_enabled;
341: l_procedure := g_package ||'gross_tot_tds_challan';
342: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
343:
344: IF g_debug THEN
345: pay_in_utils.trace('**************************************************','********************');
346: pay_in_utils.trace('p_challan_number',p_challan_number);

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

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

Line 346: pay_in_utils.trace('p_challan_number',p_challan_number);

342: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
343:
344: IF g_debug THEN
345: pay_in_utils.trace('**************************************************','********************');
346: pay_in_utils.trace('p_challan_number',p_challan_number);
347: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
348: pay_in_utils.trace('p_max_action_id',p_max_action_id);
349: pay_in_utils.trace('**************************************************','********************');
350: END IF;

Line 347: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

343:
344: IF g_debug THEN
345: pay_in_utils.trace('**************************************************','********************');
346: pay_in_utils.trace('p_challan_number',p_challan_number);
347: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
348: pay_in_utils.trace('p_max_action_id',p_max_action_id);
349: pay_in_utils.trace('**************************************************','********************');
350: END IF;
351:

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

344: IF g_debug THEN
345: pay_in_utils.trace('**************************************************','********************');
346: pay_in_utils.trace('p_challan_number',p_challan_number);
347: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
348: pay_in_utils.trace('p_max_action_id',p_max_action_id);
349: pay_in_utils.trace('**************************************************','********************');
350: END IF;
351:
352:

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

345: pay_in_utils.trace('**************************************************','********************');
346: pay_in_utils.trace('p_challan_number',p_challan_number);
347: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
348: pay_in_utils.trace('p_max_action_id',p_max_action_id);
349: pay_in_utils.trace('**************************************************','********************');
350: END IF;
351:
352:
353: l_value29 :=0;

Line 375: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);

371: l_total_tax_values := l_value29||'^'||l_value30||'^'||l_value31||'^'||l_value32||'^'||l_value33||'^';
372:
373:
374: IF g_debug THEN
375: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
376: END IF;
377:
378: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
379:

Line 378: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

374: IF g_debug THEN
375: pay_in_utils.trace('l_total_tax_values',l_total_tax_values);
376: END IF;
377:
378: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
379:
380: RETURN l_total_tax_values;
381:
382: END get_24Q_tax_values;

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

412:
413: BEGIN
414: g_debug := hr_utility.debug_enabled;
415: l_procedure := g_package ||'chapter_VIA_rec_count';
416: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
417:
418: IF g_debug THEN
419: pay_in_utils.trace('**************************************************','********************');
420: pay_in_utils.trace('p_action_context_id',p_action_context_id);

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

415: l_procedure := g_package ||'chapter_VIA_rec_count';
416: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
417:
418: IF g_debug THEN
419: pay_in_utils.trace('**************************************************','********************');
420: pay_in_utils.trace('p_action_context_id',p_action_context_id);
421: pay_in_utils.trace('p_source_id',p_source_id);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;

Line 420: pay_in_utils.trace('p_action_context_id',p_action_context_id);

416: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
417:
418: IF g_debug THEN
419: pay_in_utils.trace('**************************************************','********************');
420: pay_in_utils.trace('p_action_context_id',p_action_context_id);
421: pay_in_utils.trace('p_source_id',p_source_id);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:

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

417:
418: IF g_debug THEN
419: pay_in_utils.trace('**************************************************','********************');
420: pay_in_utils.trace('p_action_context_id',p_action_context_id);
421: pay_in_utils.trace('p_source_id',p_source_id);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:
425: OPEN c_count;

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

418: IF g_debug THEN
419: pay_in_utils.trace('**************************************************','********************');
420: pay_in_utils.trace('p_action_context_id',p_action_context_id);
421: pay_in_utils.trace('p_source_id',p_source_id);
422: pay_in_utils.trace('**************************************************','********************');
423: END IF;
424:
425: OPEN c_count;
426: FETCH c_count INTO l_count;

Line 435: pay_in_utils.trace('l_count',TO_CHAR(l_count));

431: CLOSE c_count;
432:
433:
434: IF g_debug THEN
435: pay_in_utils.trace('l_count',TO_CHAR(l_count));
436: END IF;
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
439:

Line 438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

434: IF g_debug THEN
435: pay_in_utils.trace('l_count',TO_CHAR(l_count));
436: END IF;
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
439:
440: RETURN TO_CHAR(l_count);
441:
442: END chapter_VIA_rec_count;

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

487:
488: BEGIN
489: g_debug := hr_utility.debug_enabled;
490: l_procedure := g_package ||'salary_rec_count';
491: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
492:
493: IF g_debug THEN
494: pay_in_utils.trace('**************************************************','********************');
495: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

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

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

491: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
492:
493: IF g_debug THEN
494: pay_in_utils.trace('**************************************************','********************');
495: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
496: pay_in_utils.trace('p_assess_period',p_assess_period);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499: OPEN c_count;

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

492:
493: IF g_debug THEN
494: pay_in_utils.trace('**************************************************','********************');
495: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
496: pay_in_utils.trace('p_assess_period',p_assess_period);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499: OPEN c_count;
500: FETCH c_count INTO l_count;

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

493: IF g_debug THEN
494: pay_in_utils.trace('**************************************************','********************');
495: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
496: pay_in_utils.trace('p_assess_period',p_assess_period);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499: OPEN c_count;
500: FETCH c_count INTO l_count;
501: IF c_count%NOTFOUND THEN

Line 509: pay_in_utils.trace('l_count',TO_CHAR(l_count));

505: CLOSE c_count;
506:
507:
508: IF g_debug THEN
509: pay_in_utils.trace('l_count',TO_CHAR(l_count));
510: END IF;
511:
512: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
513:

Line 512: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

508: IF g_debug THEN
509: pay_in_utils.trace('l_count',TO_CHAR(l_count));
510: END IF;
511:
512: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
513:
514: RETURN TO_CHAR(l_count);
515:
516: END salary_rec_count;

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

564:
565: BEGIN
566: g_debug := hr_utility.debug_enabled;
567: l_procedure := g_package ||'deductee_salary_count';
568: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

567: l_procedure := g_package ||'deductee_salary_count';
568: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
573: pay_in_utils.trace('p_assess_year',p_assess_year);
574: pay_in_utils.trace('p_assignment_id',p_assignment_id);
575: pay_in_utils.trace('**************************************************','********************');

Line 572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

568: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
573: pay_in_utils.trace('p_assess_year',p_assess_year);
574: pay_in_utils.trace('p_assignment_id',p_assignment_id);
575: pay_in_utils.trace('**************************************************','********************');
576: END IF;

Line 573: pay_in_utils.trace('p_assess_year',p_assess_year);

569:
570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
573: pay_in_utils.trace('p_assess_year',p_assess_year);
574: pay_in_utils.trace('p_assignment_id',p_assignment_id);
575: pay_in_utils.trace('**************************************************','********************');
576: END IF;
577:

Line 574: pay_in_utils.trace('p_assignment_id',p_assignment_id);

570: IF g_debug THEN
571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
573: pay_in_utils.trace('p_assess_year',p_assess_year);
574: pay_in_utils.trace('p_assignment_id',p_assignment_id);
575: pay_in_utils.trace('**************************************************','********************');
576: END IF;
577:
578: OPEN c_count;

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

571: pay_in_utils.trace('**************************************************','********************');
572: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
573: pay_in_utils.trace('p_assess_year',p_assess_year);
574: pay_in_utils.trace('p_assignment_id',p_assignment_id);
575: pay_in_utils.trace('**************************************************','********************');
576: END IF;
577:
578: OPEN c_count;
579: FETCH c_count INTO l_count;

Line 589: pay_in_utils.trace('l_count',TO_CHAR(l_count));

585:
586:
587:
588: IF g_debug THEN
589: pay_in_utils.trace('l_count',TO_CHAR(l_count));
590: END IF;
591:
592: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
593:

Line 592: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

588: IF g_debug THEN
589: pay_in_utils.trace('l_count',TO_CHAR(l_count));
590: END IF;
591:
592: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
593:
594: RETURN TO_CHAR(l_count);
595:
596: END deductee_salary_count;

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

633:
634: BEGIN
635: g_debug := hr_utility.debug_enabled;
636: l_procedure := g_package ||'get_24Q_values';
637: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
638:
639: IF g_debug THEN
640: pay_in_utils.trace('**************************************************','********************');
641: pay_in_utils.trace('p_category',p_category);

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

636: l_procedure := g_package ||'get_24Q_values';
637: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
638:
639: IF g_debug THEN
640: pay_in_utils.trace('**************************************************','********************');
641: pay_in_utils.trace('p_category',p_category);
642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));

Line 641: pay_in_utils.trace('p_category',p_category);

637: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
638:
639: IF g_debug THEN
640: pay_in_utils.trace('**************************************************','********************');
641: pay_in_utils.trace('p_category',p_category);
642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));

Line 642: pay_in_utils.trace('p_component_name',p_component_name);

638:
639: IF g_debug THEN
640: pay_in_utils.trace('**************************************************','********************');
641: pay_in_utils.trace('p_category',p_category);
642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
646: pay_in_utils.trace('**************************************************','********************');

Line 643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));

639: IF g_debug THEN
640: pay_in_utils.trace('**************************************************','********************');
641: pay_in_utils.trace('p_category',p_category);
642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
646: pay_in_utils.trace('**************************************************','********************');
647: END IF;

Line 644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));

640: pay_in_utils.trace('**************************************************','********************');
641: pay_in_utils.trace('p_category',p_category);
642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
646: pay_in_utils.trace('**************************************************','********************');
647: END IF;
648:

Line 645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));

641: pay_in_utils.trace('p_category',p_category);
642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
646: pay_in_utils.trace('**************************************************','********************');
647: END IF;
648:
649: OPEN c_form24Q_values;

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

642: pay_in_utils.trace('p_component_name',p_component_name);
643: pay_in_utils.trace('p_context_id',TO_CHAR(p_context_id));
644: pay_in_utils.trace('p_source_id',TO_CHAR(p_source_id));
645: pay_in_utils.trace('p_segment_num',TO_CHAR(p_segment_num));
646: pay_in_utils.trace('**************************************************','********************');
647: END IF;
648:
649: OPEN c_form24Q_values;
650: FETCH c_form24Q_values INTO l_value1,l_value2;

Line 661: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);

657: l_value2 := get_format_value(l_value2+l_value1);
658: l_value1 := get_format_value(l_value1);
659:
660:
661: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);
662: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);
663:
664: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
665:

Line 662: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);

658: l_value1 := get_format_value(l_value1);
659:
660:
661: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);
662: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);
663:
664: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
665:
666: IF(p_segment_num=1) THEN

Line 664: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);

660:
661: pay_in_utils.set_location(g_debug,'l_value1 = : '||l_value1,20);
662: pay_in_utils.set_location(g_debug,'l_value2 = : '||l_value2,30);
663:
664: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
665:
666: IF(p_segment_num=1) THEN
667: RETURN l_value1;
668: ELSIF(p_segment_num=2) THEN

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

698:
699: BEGIN
700: g_debug := hr_utility.debug_enabled;
701: l_procedure := g_package ||'get_emplr_class';
702: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
703:
704: IF g_debug THEN
705: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
706: END IF;

Line 705: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

701: l_procedure := g_package ||'get_emplr_class';
702: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
703:
704: IF g_debug THEN
705: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
706: END IF;
707:
708: OPEN c_employer;
709: FETCH c_employer INTO l_emplr_class;

Line 718: pay_in_utils.trace('l_emplr_class',l_emplr_class);

714: CLOSE c_employer;
715:
716:
717: IF g_debug THEN
718: pay_in_utils.trace('l_emplr_class',l_emplr_class);
719: END IF;
720:
721: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
722:

Line 721: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

717: IF g_debug THEN
718: pay_in_utils.trace('l_emplr_class',l_emplr_class);
719: END IF;
720:
721: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
722:
723: RETURN l_emplr_class;
724:
725: END get_emplr_class;

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

775:
776: BEGIN
777: g_debug := hr_utility.debug_enabled;
778: l_procedure := g_package ||'total_gross_tot_income';
779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
780:
781: IF g_debug THEN
782: pay_in_utils.trace('**************************************************','********************');
783: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

778: l_procedure := g_package ||'total_gross_tot_income';
779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
780:
781: IF g_debug THEN
782: pay_in_utils.trace('**************************************************','********************');
783: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
784: pay_in_utils.trace('p_assess_period',p_assess_period);
785: pay_in_utils.trace('**************************************************','********************');
786: END IF;

Line 783: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

779: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
780:
781: IF g_debug THEN
782: pay_in_utils.trace('**************************************************','********************');
783: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
784: pay_in_utils.trace('p_assess_period',p_assess_period);
785: pay_in_utils.trace('**************************************************','********************');
786: END IF;
787: FOR i IN csr_get_max_cont_id

Line 784: pay_in_utils.trace('p_assess_period',p_assess_period);

780:
781: IF g_debug THEN
782: pay_in_utils.trace('**************************************************','********************');
783: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
784: pay_in_utils.trace('p_assess_period',p_assess_period);
785: pay_in_utils.trace('**************************************************','********************');
786: END IF;
787: FOR i IN csr_get_max_cont_id
788: LOOP

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

781: IF g_debug THEN
782: pay_in_utils.trace('**************************************************','********************');
783: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
784: pay_in_utils.trace('p_assess_period',p_assess_period);
785: pay_in_utils.trace('**************************************************','********************');
786: END IF;
787: FOR i IN csr_get_max_cont_id
788: LOOP
789: OPEN csr_income_details('F16 Gross Total Income',i.action_cont_id,i.sour_id);

Line 798: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15));

794:
795: l_total_value :=get_format_value(l_total_gross);
796:
797: IF g_debug THEN
798: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15));
799: END IF;
800:
801: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
802:

Line 801: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

797: IF g_debug THEN
798: pay_in_utils.trace('l_total_value',SUBSTR(l_total_value,1,15));
799: END IF;
800:
801: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
802:
803: RETURN SUBSTR(l_total_value,1,15);
804:
805: END total_gross_tot_income;

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

861:
862: BEGIN
863: g_debug := hr_utility.debug_enabled;
864: l_procedure := g_package ||'get_location_details';
865: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
866:
867: IF g_debug THEN
868: pay_in_utils.trace('**************************************************','********************');
869: pay_in_utils.trace('p_location_id ',p_location_id );

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

864: l_procedure := g_package ||'get_location_details';
865: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
866:
867: IF g_debug THEN
868: pay_in_utils.trace('**************************************************','********************');
869: pay_in_utils.trace('p_location_id ',p_location_id );
870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );

Line 869: pay_in_utils.trace('p_location_id ',p_location_id );

865: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
866:
867: IF g_debug THEN
868: pay_in_utils.trace('**************************************************','********************');
869: pay_in_utils.trace('p_location_id ',p_location_id );
870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
873: pay_in_utils.trace('p_person_type ',p_person_type );

Line 870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);

866:
867: IF g_debug THEN
868: pay_in_utils.trace('**************************************************','********************');
869: pay_in_utils.trace('p_location_id ',p_location_id );
870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
873: pay_in_utils.trace('p_person_type ',p_person_type );
874: pay_in_utils.trace('**************************************************','********************');

Line 871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );

867: IF g_debug THEN
868: pay_in_utils.trace('**************************************************','********************');
869: pay_in_utils.trace('p_location_id ',p_location_id );
870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
873: pay_in_utils.trace('p_person_type ',p_person_type );
874: pay_in_utils.trace('**************************************************','********************');
875: END IF;

Line 872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );

868: pay_in_utils.trace('**************************************************','********************');
869: pay_in_utils.trace('p_location_id ',p_location_id );
870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
873: pay_in_utils.trace('p_person_type ',p_person_type );
874: pay_in_utils.trace('**************************************************','********************');
875: END IF;
876:

Line 873: pay_in_utils.trace('p_person_type ',p_person_type );

869: pay_in_utils.trace('p_location_id ',p_location_id );
870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
873: pay_in_utils.trace('p_person_type ',p_person_type );
874: pay_in_utils.trace('**************************************************','********************');
875: END IF;
876:
877:

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

870: pay_in_utils.trace('p_rep_email_id',p_rep_email_id);
871: pay_in_utils.trace('p_rep_phone ',p_rep_phone );
872: pay_in_utils.trace('p_segment_num ',to_char(p_segment_num) );
873: pay_in_utils.trace('p_person_type ',p_person_type );
874: pay_in_utils.trace('**************************************************','********************');
875: END IF;
876:
877:
878: OPEN csr_add;

Line 885: pay_in_utils.trace('3',RPAD('^',3,'^'));

881: CLOSE csr_add;
882: IF(p_segment_num=5 AND p_person_type='REP') THEN
883:
884: IF g_debug THEN
885: pay_in_utils.trace('3',RPAD('^',3,'^'));
886: END IF;
887:
888: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
889:

Line 888: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

884: IF g_debug THEN
885: pay_in_utils.trace('3',RPAD('^',3,'^'));
886: END IF;
887:
888: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
889:
890: RETURN RPAD('^',3,'^');
891: ELSE
892: IF g_debug THEN

Line 893: pay_in_utils.trace('2',RPAD('^',2,'^'));

889:
890: RETURN RPAD('^',3,'^');
891: ELSE
892: IF g_debug THEN
893: pay_in_utils.trace('2',RPAD('^',2,'^'));
894: END IF;
895: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);
896: RETURN RPAD('^',2,'^');
897: END IF;

Line 895: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);

891: ELSE
892: IF g_debug THEN
893: pay_in_utils.trace('2',RPAD('^',2,'^'));
894: END IF;
895: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);
896: RETURN RPAD('^',2,'^');
897: END IF;
898: END IF;
899: CLOSE csr_add;

Line 930: pay_in_utils.trace('p_address1',p_address1);

926: END IF;
927:
928: IF (p_segment_num=1) THEN
929: IF g_debug THEN
930: pay_in_utils.trace('p_address1',p_address1);
931: END IF;
932:
933: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
934:

Line 933: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);

929: IF g_debug THEN
930: pay_in_utils.trace('p_address1',p_address1);
931: END IF;
932:
933: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
934:
935: RETURN p_address1;
936: END IF;
937:

Line 965: pay_in_utils.trace('p_address2',p_address2);

961: END IF;
962:
963: IF (p_segment_num=2) THEN
964: IF g_debug THEN
965: pay_in_utils.trace('p_address2',p_address2);
966: END IF;
967: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,50);
968: RETURN p_address2;
969: END IF ;

Line 967: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,50);

963: IF (p_segment_num=2) THEN
964: IF g_debug THEN
965: pay_in_utils.trace('p_address2',p_address2);
966: END IF;
967: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,50);
968: RETURN p_address2;
969: END IF ;
970:
971: ---------Address3-------------------------

Line 991: pay_in_utils.trace('p_address3',p_address3);

987: p_address3 :=p_address3||l_state||l_pin;
988:
989: IF (p_segment_num=3) THEN
990: IF g_debug THEN
991: pay_in_utils.trace('p_address3',p_address3);
992: END IF;
993:
994: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
995:

Line 994: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);

990: IF g_debug THEN
991: pay_in_utils.trace('p_address3',p_address3);
992: END IF;
993:
994: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
995:
996: RETURN p_address3;
997: END IF ;
998:

Line 1013: pay_in_utils.trace('p_address4',p_address4);

1009: p_address4 :=l_email;
1010:
1011: IF (p_segment_num=4) THEN
1012: IF g_debug THEN
1013: pay_in_utils.trace('p_address4',p_address4);
1014: END IF;
1015: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,70);
1016: RETURN p_address4;
1017: END IF ;

Line 1015: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,70);

1011: IF (p_segment_num=4) THEN
1012: IF g_debug THEN
1013: pay_in_utils.trace('p_address4',p_address4);
1014: END IF;
1015: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,70);
1016: RETURN p_address4;
1017: END IF ;
1018:
1019: ---------Address5-------------------------

Line 1038: pay_in_utils.trace('p_address5',p_address5);

1034: END IF;
1035:
1036: IF (p_segment_num=5) THEN
1037: IF g_debug THEN
1038: pay_in_utils.trace('p_address5',p_address5);
1039: END IF;
1040: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,80);
1041: RETURN p_address5;
1042: END IF;

Line 1040: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,80);

1036: IF (p_segment_num=5) THEN
1037: IF g_debug THEN
1038: pay_in_utils.trace('p_address5',p_address5);
1039: END IF;
1040: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,80);
1041: RETURN p_address5;
1042: END IF;
1043:
1044: --------------------------------------------

Line 1059: pay_in_utils.trace('p_address6',p_address6);

1055: p_address6 := l_mob;
1056:
1057: IF (p_segment_num=6) THEN
1058: IF g_debug THEN
1059: pay_in_utils.trace('p_address6',p_address6);
1060: END IF;
1061: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,85);
1062: RETURN p_address6;
1063: END IF;

Line 1061: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,85);

1057: IF (p_segment_num=6) THEN
1058: IF g_debug THEN
1059: pay_in_utils.trace('p_address6',p_address6);
1060: END IF;
1061: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,85);
1062: RETURN p_address6;
1063: END IF;
1064:
1065: END get_location_details;

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

1093:
1094: BEGIN
1095: g_debug := hr_utility.debug_enabled;
1096: l_procedure := g_package ||'get_emp_category';
1097: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1098:
1099: IF g_debug THEN
1100: pay_in_utils.trace('**************************************************','********************');
1101: pay_in_utils.trace('p_person_id ',p_person_id );

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

1096: l_procedure := g_package ||'get_emp_category';
1097: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1098:
1099: IF g_debug THEN
1100: pay_in_utils.trace('**************************************************','********************');
1101: pay_in_utils.trace('p_person_id ',p_person_id );
1102: pay_in_utils.trace('**************************************************','********************');
1103: END IF;
1104:

Line 1101: pay_in_utils.trace('p_person_id ',p_person_id );

1097: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1098:
1099: IF g_debug THEN
1100: pay_in_utils.trace('**************************************************','********************');
1101: pay_in_utils.trace('p_person_id ',p_person_id );
1102: pay_in_utils.trace('**************************************************','********************');
1103: END IF;
1104:
1105: OPEN csr_person_category;

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

1098:
1099: IF g_debug THEN
1100: pay_in_utils.trace('**************************************************','********************');
1101: pay_in_utils.trace('p_person_id ',p_person_id );
1102: pay_in_utils.trace('**************************************************','********************');
1103: END IF;
1104:
1105: OPEN csr_person_category;
1106: FETCH csr_person_category INTO l_sex, l_age;

Line 1117: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);

1113: ELSE
1114: l_emp_category := 'G';
1115: END IF;
1116:
1117: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1118:
1119: RETURN l_emp_category;
1120:
1121: IF g_debug THEN

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

1118:
1119: RETURN l_emp_category;
1120:
1121: IF g_debug THEN
1122: pay_in_utils.trace('**************************************************','********************');
1123: pay_in_utils.trace('l_emp_category ',l_emp_category );
1124: pay_in_utils.trace('**************************************************','********************');
1125: END IF;
1126:

Line 1123: pay_in_utils.trace('l_emp_category ',l_emp_category );

1119: RETURN l_emp_category;
1120:
1121: IF g_debug THEN
1122: pay_in_utils.trace('**************************************************','********************');
1123: pay_in_utils.trace('l_emp_category ',l_emp_category );
1124: pay_in_utils.trace('**************************************************','********************');
1125: END IF;
1126:
1127: END get_emp_category;

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

1120:
1121: IF g_debug THEN
1122: pay_in_utils.trace('**************************************************','********************');
1123: pay_in_utils.trace('l_emp_category ',l_emp_category );
1124: pay_in_utils.trace('**************************************************','********************');
1125: END IF;
1126:
1127: END get_emp_category;
1128: