eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_EOY_ER_RETURNS dependencies on PAY_IN_UTILS

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

34:
35: BEGIN
36: g_debug := hr_utility.debug_enabled;
37: l_procedure := g_package ||'challan_rec_count';
38: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

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

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

38: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
46:

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

39:
40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
46:
47: OPEN c_count;

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

40: IF g_debug THEN
41: pay_in_utils.trace('**************************************************','********************');
42: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
43: pay_in_utils.trace('p_assess_year',p_assess_year);
44: pay_in_utils.trace('**************************************************','********************');
45: END IF;
46:
47: OPEN c_count;
48: FETCH c_count INTO l_count;

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

52: END IF;
53: CLOSE c_count;
54:
55: IF g_debug THEN
56: pay_in_utils.trace('l_count',TO_CHAR(l_count));
57: END IF;
58:
59: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
60:

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

55: IF g_debug THEN
56: pay_in_utils.trace('l_count',TO_CHAR(l_count));
57: END IF;
58:
59: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
60:
61: RETURN TO_CHAR(l_count);
62:
63: END challan_rec_count;

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

105:
106: BEGIN
107: g_debug := hr_utility.debug_enabled;
108: l_procedure := g_package ||'deductee_rec_count';
109: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
110:
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

108: l_procedure := g_package ||'deductee_rec_count';
109: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
110:
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;

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

109: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
110:
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
117:

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

110:
111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
117:
118: OPEN c_count;

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

111: IF g_debug THEN
112: pay_in_utils.trace('**************************************************','********************');
113: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
114: pay_in_utils.trace('p_assess_year',p_assess_year);
115: pay_in_utils.trace('**************************************************','********************');
116: END IF;
117:
118: OPEN c_count;
119: FETCH c_count INTO l_count;

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

125:
126:
127:
128: IF g_debug THEN
129: pay_in_utils.trace('l_count',TO_CHAR(l_count));
130: END IF;
131:
132: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
133:

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

128: IF g_debug THEN
129: pay_in_utils.trace('l_count',TO_CHAR(l_count));
130: END IF;
131:
132: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
133:
134: RETURN TO_CHAR(l_count);
135:
136: END deductee_rec_count;

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

179:
180: BEGIN
181: g_debug := hr_utility.debug_enabled;
182: l_procedure := g_package ||'perq_rec_count';
183: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

182: l_procedure := g_package ||'perq_rec_count';
183: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;

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

183: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
191:

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

184:
185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
191:
192: OPEN c_count;

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

185: IF g_debug THEN
186: pay_in_utils.trace('**************************************************','********************');
187: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
188: pay_in_utils.trace('p_assess_year',p_assess_year);
189: pay_in_utils.trace('**************************************************','********************');
190: END IF;
191:
192: OPEN c_count;
193: FETCH c_count INTO l_count;

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

199:
200:
201:
202: IF g_debug THEN
203: pay_in_utils.trace('l_count',TO_CHAR(l_count));
204: END IF;
205:
206: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
207:

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

202: IF g_debug THEN
203: pay_in_utils.trace('l_count',TO_CHAR(l_count));
204: END IF;
205:
206: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
207:
208: RETURN TO_CHAR(l_count);
209:
210: END perq_rec_count;

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

250:
251: BEGIN
252: g_debug := hr_utility.debug_enabled;
253: l_procedure := g_package ||'gross_tot_tds_challan';
254: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

253: l_procedure := g_package ||'gross_tot_tds_challan';
254: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;

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

254: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
262:

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

255:
256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
262:
263: OPEN c_challan_tax_tot;

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

256: IF g_debug THEN
257: pay_in_utils.trace('**************************************************','********************');
258: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
259: pay_in_utils.trace('p_assess_year',p_assess_year);
260: pay_in_utils.trace('**************************************************','********************');
261: END IF;
262:
263: OPEN c_challan_tax_tot;
264: FETCH c_challan_tax_tot INTO l_tds,l_sur,l_ec,l_intr,l_oth;

Line 276: pay_in_utils.trace('l_tot',TO_CHAR(l_tot));

272: l_tot := NVL(l_tot,0) * 100;
273:
274:
275: IF g_debug THEN
276: pay_in_utils.trace('l_tot',TO_CHAR(l_tot));
277: END IF;
278: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
279:
280: RETURN TO_CHAR(l_tot);

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

274:
275: IF g_debug THEN
276: pay_in_utils.trace('l_tot',TO_CHAR(l_tot));
277: END IF;
278: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
279:
280: RETURN TO_CHAR(l_tot);
281:
282:

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

333:
334: BEGIN
335: g_debug := hr_utility.debug_enabled;
336: l_procedure := g_package ||'gross_tot_tds_deductee';
337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);

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

336: l_procedure := g_package ||'gross_tot_tds_deductee';
337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;

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

337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
345:

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

338:
339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
345:
346: FOR i IN csr_get_max_cont_id

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

339: IF g_debug THEN
340: pay_in_utils.trace('**************************************************','********************');
341: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
342: pay_in_utils.trace('p_assess_year',p_assess_year);
343: pay_in_utils.trace('**************************************************','********************');
344: END IF;
345:
346: FOR i IN csr_get_max_cont_id
347: LOOP

Line 358: pay_in_utils.trace('l_tds',TO_CHAR(l_tds));

354:
355: l_tds := l_tds * 100;
356:
357: IF g_debug THEN
358: pay_in_utils.trace('l_tds',TO_CHAR(l_tds));
359: END IF;
360: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
361: RETURN TO_CHAR(l_tds);
362:

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

356:
357: IF g_debug THEN
358: pay_in_utils.trace('l_tds',TO_CHAR(l_tds));
359: END IF;
360: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
361: RETURN TO_CHAR(l_tds);
362:
363: END gross_tot_tds_deductee;
364:

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

402:
403: BEGIN
404: g_debug := hr_utility.debug_enabled;
405: l_procedure := g_package ||'get_eoy_values';
406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);

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

405: l_procedure := g_package ||'get_eoy_values';
406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));

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

406: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));

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

407:
408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');

Line 412: pay_in_utils.trace('p_context_id',to_char(p_context_id));

408: IF g_debug THEN
409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:

Line 413: pay_in_utils.trace('p_source_id',to_char(p_source_id));

409: pay_in_utils.trace('**************************************************','********************');
410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
417: END IF;

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

410: pay_in_utils.trace('p_category',p_category);
411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
417: END IF;
418:

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

411: pay_in_utils.trace('p_component_name',p_component_name);
412: pay_in_utils.trace('p_context_id',to_char(p_context_id));
413: pay_in_utils.trace('p_source_id',to_char(p_source_id));
414: pay_in_utils.trace('p_segment_num',to_char(p_segment_num));
415: pay_in_utils.trace('**************************************************','********************');
416:
417: END IF;
418:
419: OPEN c_form24_values;

Line 432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);

428: l_ai3 := TO_CHAR(TO_NUMBER(l_ai3) * 100);
429: l_ai4 := TO_CHAR(TO_NUMBER(l_ai4) * 100);
430: l_ai5 := TO_CHAR(TO_NUMBER(l_ai5) * 100);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:

Line 433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);

429: l_ai4 := TO_CHAR(TO_NUMBER(l_ai4) * 100);
430: l_ai5 := TO_CHAR(TO_NUMBER(l_ai5) * 100);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:

Line 434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);

430: l_ai5 := TO_CHAR(TO_NUMBER(l_ai5) * 100);
431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);

Line 435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);

431:
432: pay_in_utils.set_location (g_debug,'l_ai2'||l_ai2,20);
433: pay_in_utils.set_location (g_debug,'l_ai3'||l_ai3,30);
434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
439:

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

434: pay_in_utils.set_location (g_debug,'l_ai4'||l_ai4,40);
435: pay_in_utils.set_location (g_debug,'l_ai5'||l_ai5,50);
436:
437:
438: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,60);
439:
440: IF p_segment_num = 2 THEN
441: RETURN l_ai2;
442: ELSIF p_segment_num = 3 THEN

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

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

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

489: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
490:
491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');

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

490:
491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;

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

491:
492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499:

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

492: IF g_debug THEN
493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499:
500: OPEN c_remarks;

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

493: pay_in_utils.trace('**************************************************','********************');
494: pay_in_utils.trace('p_person_id',p_person_id);
495: pay_in_utils.trace('p_assess_year',p_assess_year);
496: pay_in_utils.trace('p_date',p_date);
497: pay_in_utils.trace('**************************************************','********************');
498: END IF;
499:
500: OPEN c_remarks;
501: FETCH c_remarks INTO l_remarks;

Line 509: pay_in_utils.trace('l_remarks',l_remarks);

505: END IF;
506: CLOSE c_remarks;
507:
508: IF g_debug THEN
509: pay_in_utils.trace('l_remarks',l_remarks);
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_remarks',l_remarks);
510: END IF;
511:
512: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
513:
514: RETURN l_remarks;
515:
516: END get_tde_remarks;

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

540:
541: BEGIN
542: g_debug := hr_utility.debug_enabled;
543: l_procedure := g_package ||'get_emplr_class';
544: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
545:
546: IF g_debug THEN
547: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
548: END IF;

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

543: l_procedure := g_package ||'get_emplr_class';
544: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
545:
546: IF g_debug THEN
547: pay_in_utils.trace('p_gre_org_id',p_gre_org_id);
548: END IF;
549:
550: OPEN c_employer;
551: FETCH c_employer INTO l_emplr_class;

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

556: CLOSE c_employer;
557:
558:
559: IF g_debug THEN
560: pay_in_utils.trace('l_emplr_class',l_emplr_class);
561: END IF;
562: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
563:
564: RETURN l_emplr_class;

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

558:
559: IF g_debug THEN
560: pay_in_utils.trace('l_emplr_class',l_emplr_class);
561: END IF;
562: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
563:
564: RETURN l_emplr_class;
565:
566: END get_emplr_class;

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

605:
606: BEGIN
607: g_debug := hr_utility.debug_enabled;
608: l_procedure := g_package ||'get_location_details';
609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610:
611: IF g_debug THEN
612: pay_in_utils.trace('p_location_id',p_location_id);
613: END IF;

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

608: l_procedure := g_package ||'get_location_details';
609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610:
611: IF g_debug THEN
612: pay_in_utils.trace('p_location_id',p_location_id);
613: END IF;
614:
615: OPEN csr_add;
616: FETCH csr_add INTO l_add_1, l_add_2, l_add_3, l_add_4, l_add_5, l_state, l_pin;

Line 663: pay_in_utils.trace('p_address',p_address);

659: p_address := p_address||l_state||l_pin;
660:
661:
662: IF g_debug THEN
663: pay_in_utils.trace('p_address',p_address);
664: END IF;
665:
666: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
667:

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

662: IF g_debug THEN
663: pay_in_utils.trace('p_address',p_address);
664: END IF;
665:
666: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
667:
668:
669: RETURN p_address;
670: