APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_IN_UTILS

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

22:
23: BEGIN
24: g_debug := hr_utility.debug_enabled;
25: l_procedure := g_package ||'get_assessment_year';
26: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
27: IF (g_debug)
28: THEN
29: pay_in_utils.trace('**************************************************','********************');
30: pay_in_utils.trace('Assessment Year is :',g_assessment_year);

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

25: l_procedure := g_package ||'get_assessment_year';
26: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
27: IF (g_debug)
28: THEN
29: pay_in_utils.trace('**************************************************','********************');
30: pay_in_utils.trace('Assessment Year is :',g_assessment_year);
31: pay_in_utils.trace('**************************************************','********************');
32: END IF;
33: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 30: pay_in_utils.trace('Assessment Year is :',g_assessment_year);

26: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
27: IF (g_debug)
28: THEN
29: pay_in_utils.trace('**************************************************','********************');
30: pay_in_utils.trace('Assessment Year is :',g_assessment_year);
31: pay_in_utils.trace('**************************************************','********************');
32: END IF;
33: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
34: RETURN g_assessment_year;

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

27: IF (g_debug)
28: THEN
29: pay_in_utils.trace('**************************************************','********************');
30: pay_in_utils.trace('Assessment Year is :',g_assessment_year);
31: pay_in_utils.trace('**************************************************','********************');
32: END IF;
33: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
34: RETURN g_assessment_year;
35: END get_assessment_year;

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

29: pay_in_utils.trace('**************************************************','********************');
30: pay_in_utils.trace('Assessment Year is :',g_assessment_year);
31: pay_in_utils.trace('**************************************************','********************');
32: END IF;
33: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
34: RETURN g_assessment_year;
35: END get_assessment_year;
36:
37: --------------------------------------------------------------------------

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

50: l_message VARCHAR2(250);
51: BEGIN
52: g_debug := hr_utility.debug_enabled;
53: l_procedure := g_package ||'set_assessment_year';
54: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
55: g_assessment_year := p_assessment_year;
56: IF (g_debug)
57: THEN
58: pay_in_utils.trace('**************************************************','********************');

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

54: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
55: g_assessment_year := p_assessment_year;
56: IF (g_debug)
57: THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_assessment_year is :',p_assessment_year);
60: pay_in_utils.trace('g_assessment_year is :',g_assessment_year);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;

Line 59: pay_in_utils.trace('p_assessment_year is :',p_assessment_year);

55: g_assessment_year := p_assessment_year;
56: IF (g_debug)
57: THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_assessment_year is :',p_assessment_year);
60: pay_in_utils.trace('g_assessment_year is :',g_assessment_year);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 60: pay_in_utils.trace('g_assessment_year is :',g_assessment_year);

56: IF (g_debug)
57: THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_assessment_year is :',p_assessment_year);
60: pay_in_utils.trace('g_assessment_year is :',g_assessment_year);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
64: END set_assessment_year;

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

57: THEN
58: pay_in_utils.trace('**************************************************','********************');
59: pay_in_utils.trace('p_assessment_year is :',p_assessment_year);
60: pay_in_utils.trace('g_assessment_year is :',g_assessment_year);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
64: END set_assessment_year;
65: --------------------------------------------------------------------------

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

59: pay_in_utils.trace('p_assessment_year is :',p_assessment_year);
60: pay_in_utils.trace('g_assessment_year is :',g_assessment_year);
61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
64: END set_assessment_year;
65: --------------------------------------------------------------------------
66: -- --
67: -- Name : GET_EE_VALUE --

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

99: l_message VARCHAR2(250);
100: BEGIN
101: g_debug := hr_utility.debug_enabled;
102: l_procedure := g_package ||'get_ee_value';
103: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
104:
105: IF (g_debug)
106: THEN
107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

Line 107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

103: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
104:
105: IF (g_debug)
106: THEN
107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
108: pay_in_utils.trace('**************************************************','********************');
109: pay_in_utils.trace('p_element_entry_id ', p_element_entry_id);
110: pay_in_utils.trace('p_input_name ', p_input_name);
111: pay_in_utils.trace('p_effective_date ', p_effective_date);

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

104:
105: IF (g_debug)
106: THEN
107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
108: pay_in_utils.trace('**************************************************','********************');
109: pay_in_utils.trace('p_element_entry_id ', p_element_entry_id);
110: pay_in_utils.trace('p_input_name ', p_input_name);
111: pay_in_utils.trace('p_effective_date ', p_effective_date);
112: END IF;

Line 109: pay_in_utils.trace('p_element_entry_id ', p_element_entry_id);

105: IF (g_debug)
106: THEN
107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
108: pay_in_utils.trace('**************************************************','********************');
109: pay_in_utils.trace('p_element_entry_id ', p_element_entry_id);
110: pay_in_utils.trace('p_input_name ', p_input_name);
111: pay_in_utils.trace('p_effective_date ', p_effective_date);
112: END IF;
113:

Line 110: pay_in_utils.trace('p_input_name ', p_input_name);

106: THEN
107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
108: pay_in_utils.trace('**************************************************','********************');
109: pay_in_utils.trace('p_element_entry_id ', p_element_entry_id);
110: pay_in_utils.trace('p_input_name ', p_input_name);
111: pay_in_utils.trace('p_effective_date ', p_effective_date);
112: END IF;
113:
114: OPEN c_entry_value;

Line 111: pay_in_utils.trace('p_effective_date ', p_effective_date);

107: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
108: pay_in_utils.trace('**************************************************','********************');
109: pay_in_utils.trace('p_element_entry_id ', p_element_entry_id);
110: pay_in_utils.trace('p_input_name ', p_input_name);
111: pay_in_utils.trace('p_effective_date ', p_effective_date);
112: END IF;
113:
114: OPEN c_entry_value;
115: FETCH c_entry_value INTO l_screen_entry_value;

Line 120: pay_in_utils.trace('Screen Entry Value is :',l_screen_entry_value);

116: CLOSE c_entry_value;
117:
118: IF (g_debug)
119: THEN
120: pay_in_utils.trace('Screen Entry Value is :',l_screen_entry_value);
121: pay_in_utils.trace('**************************************************','********************');
122: END IF;
123:
124: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

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

117:
118: IF (g_debug)
119: THEN
120: pay_in_utils.trace('Screen Entry Value is :',l_screen_entry_value);
121: pay_in_utils.trace('**************************************************','********************');
122: END IF;
123:
124: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
125: RETURN l_screen_entry_value;

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

120: pay_in_utils.trace('Screen Entry Value is :',l_screen_entry_value);
121: pay_in_utils.trace('**************************************************','********************');
122: END IF;
123:
124: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
125: RETURN l_screen_entry_value;
126: END get_ee_value;
127:
128: --------------------------------------------------------------------------

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

156: l_message VARCHAR2(250);
157: BEGIN
158: g_debug := hr_utility.debug_enabled;
159: l_procedure := g_package ||'get_org_id';
160: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
161:
162: IF (g_debug)
163: THEN
164: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

Line 164: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

160: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
161:
162: IF (g_debug)
163: THEN
164: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
165: pay_in_utils.trace('**************************************************','********************');
166: pay_in_utils.trace('p_tan_number ', p_tan_number);
167: END IF;
168:

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

161:
162: IF (g_debug)
163: THEN
164: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
165: pay_in_utils.trace('**************************************************','********************');
166: pay_in_utils.trace('p_tan_number ', p_tan_number);
167: END IF;
168:
169: OPEN c_tan_number;

Line 166: pay_in_utils.trace('p_tan_number ', p_tan_number);

162: IF (g_debug)
163: THEN
164: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
165: pay_in_utils.trace('**************************************************','********************');
166: pay_in_utils.trace('p_tan_number ', p_tan_number);
167: END IF;
168:
169: OPEN c_tan_number;
170: FETCH c_tan_number INTO l_organization_id;

Line 175: pay_in_utils.trace('l_organization_id',l_organization_id);

171: CLOSE c_tan_number;
172:
173: IF (g_debug)
174: THEN
175: pay_in_utils.trace('l_organization_id',l_organization_id);
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
179: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

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

172:
173: IF (g_debug)
174: THEN
175: pay_in_utils.trace('l_organization_id',l_organization_id);
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
179: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
180:

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

175: pay_in_utils.trace('l_organization_id',l_organization_id);
176: pay_in_utils.trace('**************************************************','********************');
177: END IF;
178:
179: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
180:
181: RETURN NVL(l_organization_id,'%');
182: END get_org_id;
183:

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

220: l_message VARCHAR2(250);
221: BEGIN
222: g_debug := hr_utility.debug_enabled;
223: l_procedure := g_package ||'get_tan_number';
224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
225: IF (g_debug)
226: THEN
227: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
228: pay_in_utils.trace('**************************************************','********************');

Line 227: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

223: l_procedure := g_package ||'get_tan_number';
224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
225: IF (g_debug)
226: THEN
227: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
228: pay_in_utils.trace('**************************************************','********************');
229: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
230: pay_in_utils.trace('p_effective_date ',p_effective_date);
231: END IF;

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

224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
225: IF (g_debug)
226: THEN
227: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
228: pay_in_utils.trace('**************************************************','********************');
229: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
230: pay_in_utils.trace('p_effective_date ',p_effective_date);
231: END IF;
232:

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

225: IF (g_debug)
226: THEN
227: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
228: pay_in_utils.trace('**************************************************','********************');
229: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
230: pay_in_utils.trace('p_effective_date ',p_effective_date);
231: END IF;
232:
233: OPEN c_tan_number;

Line 230: pay_in_utils.trace('p_effective_date ',p_effective_date);

226: THEN
227: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
228: pay_in_utils.trace('**************************************************','********************');
229: pay_in_utils.trace('p_assignment_id ',p_assignment_id);
230: pay_in_utils.trace('p_effective_date ',p_effective_date);
231: END IF;
232:
233: OPEN c_tan_number;
234: FETCH c_tan_number INTO l_tan_number;

Line 239: pay_in_utils.trace('l_tan_number',l_tan_number);

235: CLOSE c_tan_number;
236:
237: IF (g_debug)
238: THEN
239: pay_in_utils.trace('l_tan_number',l_tan_number);
240: pay_in_utils.trace('**************************************************','********************');
241: END IF;
242:
243: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

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

236:
237: IF (g_debug)
238: THEN
239: pay_in_utils.trace('l_tan_number',l_tan_number);
240: pay_in_utils.trace('**************************************************','********************');
241: END IF;
242:
243: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
244: RETURN l_tan_number;

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

239: pay_in_utils.trace('l_tan_number',l_tan_number);
240: pay_in_utils.trace('**************************************************','********************');
241: END IF;
242:
243: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
244: RETURN l_tan_number;
245: END;
246:
247: --------------------------------------------------------------------------

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

275: l_message VARCHAR2(250);
276: BEGIN
277: g_debug := hr_utility.debug_enabled;
278: l_procedure := g_package ||'get_tan_number_ee';
279: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
280:
281: IF (g_debug)
282: THEN
283: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

Line 283: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

279: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
280:
281: IF (g_debug)
282: THEN
283: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
284: pay_in_utils.trace('**************************************************','********************');
285: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
286: END IF;
287:

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

280:
281: IF (g_debug)
282: THEN
283: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
284: pay_in_utils.trace('**************************************************','********************');
285: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
286: END IF;
287:
288: OPEN c_element_details;

Line 285: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);

281: IF (g_debug)
282: THEN
283: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
284: pay_in_utils.trace('**************************************************','********************');
285: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
286: END IF;
287:
288: OPEN c_element_details;
289: FETCH c_element_details INTO l_effective_date,l_assignment_id;

Line 294: pay_in_utils.trace('l_effective_date',l_effective_date);

290: CLOSE c_element_details;
291:
292: IF (g_debug)
293: THEN
294: pay_in_utils.trace('l_effective_date',l_effective_date);
295: pay_in_utils.trace('l_assignment_id',l_assignment_id);
296: END IF;
297: l_ee_payment_date := fnd_date.canonical_to_date
298: (

Line 295: pay_in_utils.trace('l_assignment_id',l_assignment_id);

291:
292: IF (g_debug)
293: THEN
294: pay_in_utils.trace('l_effective_date',l_effective_date);
295: pay_in_utils.trace('l_assignment_id',l_assignment_id);
296: END IF;
297: l_ee_payment_date := fnd_date.canonical_to_date
298: (
299: get_ee_value(p_element_entry_id

Line 304: pay_in_utils.trace('l_ee_payment_date',l_ee_payment_date);

300: ,'Payment Date'
301: ,l_effective_date
302: )
303: );
304: pay_in_utils.trace('l_ee_payment_date',l_ee_payment_date);
305:
306: l_tan_number := get_tan_number(l_assignment_id
307: ,l_ee_payment_date
308: );

Line 309: pay_in_utils.trace('l_tan_number',l_tan_number);

305:
306: l_tan_number := get_tan_number(l_assignment_id
307: ,l_ee_payment_date
308: );
309: pay_in_utils.trace('l_tan_number',l_tan_number);
310: pay_in_utils.trace('**************************************************','********************');
311: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
312: RETURN l_tan_number;
313: END get_tan_number_ee;

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

306: l_tan_number := get_tan_number(l_assignment_id
307: ,l_ee_payment_date
308: );
309: pay_in_utils.trace('l_tan_number',l_tan_number);
310: pay_in_utils.trace('**************************************************','********************');
311: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
312: RETURN l_tan_number;
313: END get_tan_number_ee;
314:

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

307: ,l_ee_payment_date
308: );
309: pay_in_utils.trace('l_tan_number',l_tan_number);
310: pay_in_utils.trace('**************************************************','********************');
311: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
312: RETURN l_tan_number;
313: END get_tan_number_ee;
314:
315: --------------------------------------------------------------------------

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

348: l_message VARCHAR2(250);
349: BEGIN
350: g_debug := hr_utility.debug_enabled;
351: l_procedure := g_package ||'get_date_earned';
352: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
353: IF (g_debug)
354: THEN
355: pay_in_utils.trace('**************************************************','********************');
356: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

351: l_procedure := g_package ||'get_date_earned';
352: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
353: IF (g_debug)
354: THEN
355: pay_in_utils.trace('**************************************************','********************');
356: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
357: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
358: END IF;
359:

Line 356: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

352: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
353: IF (g_debug)
354: THEN
355: pay_in_utils.trace('**************************************************','********************');
356: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
357: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
358: END IF;
359:
360: OPEN c_date_earned;

Line 357: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);

353: IF (g_debug)
354: THEN
355: pay_in_utils.trace('**************************************************','********************');
356: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
357: pay_in_utils.trace('p_assignment_action_id ',p_assignment_action_id);
358: END IF;
359:
360: OPEN c_date_earned;
361: FETCH c_date_earned INTO l_date_earned;

Line 366: pay_in_utils.trace('l_date_earned',l_date_earned);

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

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

365: THEN
366: pay_in_utils.trace('l_date_earned',l_date_earned);
367: END IF;
368:
369: pay_in_utils.trace('**************************************************','********************');
370: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
371: RETURN l_date_earned;
372: END get_date_earned;
373: --------------------------------------------------------------------------

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

366: pay_in_utils.trace('l_date_earned',l_date_earned);
367: END IF;
368:
369: pay_in_utils.trace('**************************************************','********************');
370: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
371: RETURN l_date_earned;
372: END get_date_earned;
373: --------------------------------------------------------------------------
374: -- --

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

472: l_message VARCHAR2(250);
473: BEGIN
474: g_debug := hr_utility.debug_enabled;
475: l_procedure := g_package ||'get_date_earned_ee';
476: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
477: IF (g_debug)
478: THEN
479: pay_in_utils.trace('**************************************************','********************');
480: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

475: l_procedure := g_package ||'get_date_earned_ee';
476: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
477: IF (g_debug)
478: THEN
479: pay_in_utils.trace('**************************************************','********************');
480: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
481: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
482: END IF;
483:

Line 480: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

476: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
477: IF (g_debug)
478: THEN
479: pay_in_utils.trace('**************************************************','********************');
480: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
481: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
482: END IF;
483:
484: OPEN c_element_details;

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

477: IF (g_debug)
478: THEN
479: pay_in_utils.trace('**************************************************','********************');
480: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
481: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
482: END IF;
483:
484: OPEN c_element_details;
485: FETCH c_element_details INTO l_effective_date,l_assignment_id;

Line 490: pay_in_utils.trace('l_effective_date',l_effective_date);

486: CLOSE c_element_details;
487:
488: IF (g_debug)
489: THEN
490: pay_in_utils.trace('l_effective_date',l_effective_date);
491: pay_in_utils.trace('l_assignment_id',l_assignment_id);
492: END IF;
493:
494: l_ee_payment_date := fnd_date.canonical_to_date

Line 491: pay_in_utils.trace('l_assignment_id',l_assignment_id);

487:
488: IF (g_debug)
489: THEN
490: pay_in_utils.trace('l_effective_date',l_effective_date);
491: pay_in_utils.trace('l_assignment_id',l_assignment_id);
492: END IF;
493:
494: l_ee_payment_date := fnd_date.canonical_to_date
495: (

Line 504: pay_in_utils.trace('l_ee_payment_date',l_ee_payment_date);

500: );
501:
502: IF (g_debug)
503: THEN
504: pay_in_utils.trace('l_ee_payment_date',l_ee_payment_date);
505: END IF;
506:
507: OPEN c_prepayment_record(l_assignment_id,l_ee_payment_date);
508: FETCH c_prepayment_record INTO l_asg_action_id;

Line 513: pay_in_utils.trace('l_asg_action_id',l_asg_action_id);

509: CLOSE c_prepayment_record;
510:
511: IF (g_debug)
512: THEN
513: pay_in_utils.trace('l_asg_action_id',l_asg_action_id);
514: END IF;
515:
516: IF (l_asg_action_id IS NULL)
517: THEN

Line 524: pay_in_utils.trace('l_asg_action_id',l_asg_action_id);

520: CLOSE c_prepayment_record_one;
521:
522: IF (g_debug)
523: THEN
524: pay_in_utils.trace('l_asg_action_id',l_asg_action_id);
525: END IF;
526:
527: IF (l_asg_action_id IS NULL)
528: THEN

Line 535: pay_in_utils.trace('l_asg_action_id',l_asg_action_id);

531: CLOSE c_prepayment_record_two;
532:
533: IF (g_debug)
534: THEN
535: pay_in_utils.trace('l_asg_action_id',l_asg_action_id);
536: END IF;
537: END IF;
538: END IF;
539:

Line 546: pay_in_utils.trace('l_date',l_date);

542: CLOSE c_payroll_run_record;
543:
544: IF (g_debug)
545: THEN
546: pay_in_utils.trace('l_date',l_date);
547: END IF;
548:
549: pay_in_utils.trace('**************************************************','********************');
550: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

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

545: THEN
546: pay_in_utils.trace('l_date',l_date);
547: END IF;
548:
549: pay_in_utils.trace('**************************************************','********************');
550: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
551: RETURN l_date;
552:
553: END get_date_earned_ee;

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

546: pay_in_utils.trace('l_date',l_date);
547: END IF;
548:
549: pay_in_utils.trace('**************************************************','********************');
550: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
551: RETURN l_date;
552:
553: END get_date_earned_ee;
554:

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

605: l_message VARCHAR2(250);
606: BEGIN
607: g_debug := hr_utility.debug_enabled;
608: l_procedure := g_package ||'get_balance_value';
609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610: IF (g_debug)
611: THEN
612: pay_in_utils.trace('**************************************************','********************');
613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

608: l_procedure := g_package ||'get_balance_value';
609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610: IF (g_debug)
611: THEN
612: pay_in_utils.trace('**************************************************','********************');
613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
614: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
615: pay_in_utils.trace('p_balance_name',p_balance_name);
616: pay_in_utils.trace('p_dimension',p_dimension);

Line 613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

609: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
610: IF (g_debug)
611: THEN
612: pay_in_utils.trace('**************************************************','********************');
613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
614: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
615: pay_in_utils.trace('p_balance_name',p_balance_name);
616: pay_in_utils.trace('p_dimension',p_dimension);
617: END IF;

Line 614: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);

610: IF (g_debug)
611: THEN
612: pay_in_utils.trace('**************************************************','********************');
613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
614: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
615: pay_in_utils.trace('p_balance_name',p_balance_name);
616: pay_in_utils.trace('p_dimension',p_dimension);
617: END IF;
618:

Line 615: pay_in_utils.trace('p_balance_name',p_balance_name);

611: THEN
612: pay_in_utils.trace('**************************************************','********************');
613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
614: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
615: pay_in_utils.trace('p_balance_name',p_balance_name);
616: pay_in_utils.trace('p_dimension',p_dimension);
617: END IF;
618:
619: OPEN c_action_type;

Line 616: pay_in_utils.trace('p_dimension',p_dimension);

612: pay_in_utils.trace('**************************************************','********************');
613: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
614: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
615: pay_in_utils.trace('p_balance_name',p_balance_name);
616: pay_in_utils.trace('p_dimension',p_dimension);
617: END IF;
618:
619: OPEN c_action_type;
620: FETCH c_action_type INTO l_action_type;

Line 625: pay_in_utils.trace('l_action_type',l_action_type);

621: CLOSE c_action_type;
622:
623: IF (g_debug)
624: THEN
625: pay_in_utils.trace('l_action_type',l_action_type);
626: END IF;
627:
628: IF (l_action_type IN ('P','U'))
629: THEN

Line 661: pay_in_utils.trace('l_assignment_action_id',l_assignment_action_id);

657: END IF;
658:
659: IF (g_debug)
660: THEN
661: pay_in_utils.trace('l_assignment_action_id',l_assignment_action_id);
662: pay_in_utils.trace('l_balance_value',l_balance_value);
663: END IF;
664: pay_in_utils.trace('**************************************************','********************');
665: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 662: pay_in_utils.trace('l_balance_value',l_balance_value);

658:
659: IF (g_debug)
660: THEN
661: pay_in_utils.trace('l_assignment_action_id',l_assignment_action_id);
662: pay_in_utils.trace('l_balance_value',l_balance_value);
663: END IF;
664: pay_in_utils.trace('**************************************************','********************');
665: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
666: RETURN TO_CHAR(l_balance_value);

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

660: THEN
661: pay_in_utils.trace('l_assignment_action_id',l_assignment_action_id);
662: pay_in_utils.trace('l_balance_value',l_balance_value);
663: END IF;
664: pay_in_utils.trace('**************************************************','********************');
665: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
666: RETURN TO_CHAR(l_balance_value);
667:
668: END get_balance_value;

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

661: pay_in_utils.trace('l_assignment_action_id',l_assignment_action_id);
662: pay_in_utils.trace('l_balance_value',l_balance_value);
663: END IF;
664: pay_in_utils.trace('**************************************************','********************');
665: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
666: RETURN TO_CHAR(l_balance_value);
667:
668: END get_balance_value;
669: --------------------------------------------------------------------------

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

685: l_message VARCHAR2(250);
686: BEGIN
687: g_debug := hr_utility.debug_enabled;
688: l_procedure := g_package ||'get_total_tax_deposited';
689: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
690: IF (g_debug)
691: THEN
692: pay_in_utils.trace('**************************************************','********************');
693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

688: l_procedure := g_package ||'get_total_tax_deposited';
689: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
690: IF (g_debug)
691: THEN
692: pay_in_utils.trace('**************************************************','********************');
693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
694: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
695: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
696: pay_in_utils.trace('p_effective_date',p_effective_date);

Line 693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

689: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
690: IF (g_debug)
691: THEN
692: pay_in_utils.trace('**************************************************','********************');
693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
694: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
695: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
696: pay_in_utils.trace('p_effective_date',p_effective_date);
697: END IF;

Line 694: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);

690: IF (g_debug)
691: THEN
692: pay_in_utils.trace('**************************************************','********************');
693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
694: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
695: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
696: pay_in_utils.trace('p_effective_date',p_effective_date);
697: END IF;
698:

Line 695: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);

691: THEN
692: pay_in_utils.trace('**************************************************','********************');
693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
694: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
695: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
696: pay_in_utils.trace('p_effective_date',p_effective_date);
697: END IF;
698:
699: IF (p_element_entry_id IS NULL)

Line 696: pay_in_utils.trace('p_effective_date',p_effective_date);

692: pay_in_utils.trace('**************************************************','********************');
693: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
694: pay_in_utils.trace('p_assignment_action_id',p_assignment_action_id);
695: pay_in_utils.trace('p_element_entry_id',p_element_entry_id);
696: pay_in_utils.trace('p_effective_date',p_effective_date);
697: END IF;
698:
699: IF (p_element_entry_id IS NULL)
700: THEN

Line 748: pay_in_utils.trace('l_total_tax',l_total_tax);

744: END IF;
745:
746: IF (g_debug)
747: THEN
748: pay_in_utils.trace('l_total_tax',l_total_tax);
749: END IF;
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
752:

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

746: IF (g_debug)
747: THEN
748: pay_in_utils.trace('l_total_tax',l_total_tax);
749: END IF;
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
752:
753: RETURN (TO_CHAR(NVL(l_total_tax,0),fnd_currency.get_format_mask('INR',40)));
754: END;

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

747: THEN
748: pay_in_utils.trace('l_total_tax',l_total_tax);
749: END IF;
750: pay_in_utils.trace('**************************************************','********************');
751: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
752:
753: RETURN (TO_CHAR(NVL(l_total_tax,0),fnd_currency.get_format_mask('INR',40)));
754: END;
755: --------------------------------------------------------------------------

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

776: l_message VARCHAR2(250);
777: BEGIN
778: g_debug := hr_utility.debug_enabled;
779: l_procedure := g_package ||'get_bg_id';
780: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
781:
782: OPEN c_bg;
783: FETCH c_bg INTO l_bg;
784: CLOSE c_bg;

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

784: CLOSE c_bg;
785:
786: IF (g_debug)
787: THEN
788: pay_in_utils.trace('**************************************************','********************');
789: pay_in_utils.trace('l_bg',l_bg);
790: pay_in_utils.trace('**************************************************','********************');
791: END IF;
792: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 789: pay_in_utils.trace('l_bg',l_bg);

785:
786: IF (g_debug)
787: THEN
788: pay_in_utils.trace('**************************************************','********************');
789: pay_in_utils.trace('l_bg',l_bg);
790: pay_in_utils.trace('**************************************************','********************');
791: END IF;
792: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
793:

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

786: IF (g_debug)
787: THEN
788: pay_in_utils.trace('**************************************************','********************');
789: pay_in_utils.trace('l_bg',l_bg);
790: pay_in_utils.trace('**************************************************','********************');
791: END IF;
792: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
793:
794: RETURN l_bg;

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

788: pay_in_utils.trace('**************************************************','********************');
789: pay_in_utils.trace('l_bg',l_bg);
790: pay_in_utils.trace('**************************************************','********************');
791: END IF;
792: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
793:
794: RETURN l_bg;
795:
796: END get_bg_id;

Line 858: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

854: FROM per_assignments_f assgn
855: , pay_element_links_f link
856: , pay_element_types_f types
857: WHERE assgn.assignment_id = p_assignment_id
858: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
859: ,p_pre_payment_date
860: ,types.element_type_id
861: )
862: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

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

938: l_message VARCHAR2(250);
939: BEGIN
940: g_debug := hr_utility.debug_enabled;
941: l_procedure := g_package ||'create_form_24';
942: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
943: IF (g_debug)
944: THEN
945: pay_in_utils.trace('**************************************************','********************');
946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

941: l_procedure := g_package ||'create_form_24';
942: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
943: IF (g_debug)
944: THEN
945: pay_in_utils.trace('**************************************************','********************');
946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );

Line 946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

942: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
943: IF (g_debug)
944: THEN
945: pay_in_utils.trace('**************************************************','********************');
946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );

Line 947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );

943: IF (g_debug)
944: THEN
945: pay_in_utils.trace('**************************************************','********************');
946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );

Line 948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );

944: THEN
945: pay_in_utils.trace('**************************************************','********************');
946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );

Line 949: pay_in_utils.trace('p_period ',p_period );

945: pay_in_utils.trace('**************************************************','********************');
946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );

Line 950: pay_in_utils.trace('p_earned_date ',p_earned_date );

946: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );

Line 951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );

947: pay_in_utils.trace('p_assessment_year ',p_assessment_year );
948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );

Line 952: pay_in_utils.trace('p_employee_id ',p_employee_id );

948: pay_in_utils.trace('p_payroll_name ',p_payroll_name );
949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );

Line 953: pay_in_utils.trace('p_employee_name ',p_employee_name );

949: pay_in_utils.trace('p_period ',p_period );
950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);

Line 954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );

950: pay_in_utils.trace('p_earned_date ',p_earned_date );
951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );

Line 955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );

951: pay_in_utils.trace('p_pre_payment_date ',p_pre_payment_date );
952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );

Line 956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );

952: pay_in_utils.trace('p_employee_id ',p_employee_id );
953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );

Line 957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);

953: pay_in_utils.trace('p_employee_name ',p_employee_name );
954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );

Line 958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );

954: pay_in_utils.trace('p_taxable_income ',p_taxable_income );
955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );

Line 959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );

955: pay_in_utils.trace('p_income_tax_deducted ',p_income_tax_deducted );
956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );

Line 960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );

956: pay_in_utils.trace('p_surcharge_deducted ',p_surcharge_deducted );
957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );

Line 961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );

957: pay_in_utils.trace('p_education_cess_deducted',p_education_cess_deducted);
958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );
965: pay_in_utils.trace('p_purge_record ',p_purge_record );

Line 962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );

958: pay_in_utils.trace('p_total_tax_deducted ',p_total_tax_deducted );
959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );
965: pay_in_utils.trace('p_purge_record ',p_purge_record );
966: pay_in_utils.trace('p_assignment_id ',p_assignment_id );

Line 963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );

959: pay_in_utils.trace('p_amount_deposited ',p_amount_deposited );
960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );
965: pay_in_utils.trace('p_purge_record ',p_purge_record );
966: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
967: END IF;

Line 964: pay_in_utils.trace('p_tan_number ',p_tan_number );

960: pay_in_utils.trace('p_voucher_number ',p_voucher_number );
961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );
965: pay_in_utils.trace('p_purge_record ',p_purge_record );
966: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
967: END IF;
968: flag := FALSE;

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

961: pay_in_utils.trace('p_correction_flag ',p_correction_flag );
962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );
965: pay_in_utils.trace('p_purge_record ',p_purge_record );
966: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
967: END IF;
968: flag := FALSE;
969: l_effective_date := pay_in_utils.get_effective_date(p_pre_payment_date);

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

962: pay_in_utils.trace('p_last_updated_date ',p_last_updated_date );
963: pay_in_utils.trace('p_element_entry_id ',p_element_entry_id );
964: pay_in_utils.trace('p_tan_number ',p_tan_number );
965: pay_in_utils.trace('p_purge_record ',p_purge_record );
966: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
967: END IF;
968: flag := FALSE;
969: l_effective_date := pay_in_utils.get_effective_date(p_pre_payment_date);
970: l_business_group_id := get_bg_id();

Line 969: l_effective_date := pay_in_utils.get_effective_date(p_pre_payment_date);

965: pay_in_utils.trace('p_purge_record ',p_purge_record );
966: pay_in_utils.trace('p_assignment_id ',p_assignment_id );
967: END IF;
968: flag := FALSE;
969: l_effective_date := pay_in_utils.get_effective_date(p_pre_payment_date);
970: l_business_group_id := get_bg_id();
971:
972: IF (g_debug)
973: THEN

Line 974: pay_in_utils.trace('l_effective_date',l_effective_date);

970: l_business_group_id := get_bg_id();
971:
972: IF (g_debug)
973: THEN
974: pay_in_utils.trace('l_effective_date',l_effective_date);
975: pay_in_utils.trace('l_business_group_id',l_business_group_id);
976: END IF;
977: --Record Deletion Starts
978: IF (NVL(p_purge_record,'N')= 'Y')

Line 975: pay_in_utils.trace('l_business_group_id',l_business_group_id);

971:
972: IF (g_debug)
973: THEN
974: pay_in_utils.trace('l_effective_date',l_effective_date);
975: pay_in_utils.trace('l_business_group_id',l_business_group_id);
976: END IF;
977: --Record Deletion Starts
978: IF (NVL(p_purge_record,'N')= 'Y')
979: THEN

Line 989: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);

985: CLOSE c_effective_start_date;
986:
987: IF (g_debug)
988: THEN
989: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
990: pay_in_utils.trace('l_object_version_number',l_object_version_number);
991: END IF;
992:
993: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);

Line 990: pay_in_utils.trace('l_object_version_number',l_object_version_number);

986:
987: IF (g_debug)
988: THEN
989: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
990: pay_in_utils.trace('l_object_version_number',l_object_version_number);
991: END IF;
992:
993: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);
994:

Line 993: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);

989: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
990: pay_in_utils.trace('l_object_version_number',l_object_version_number);
991: END IF;
992:
993: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);
994:
995: --Delete the element entry id.
996: pay_element_entry_api.delete_element_entry
997: (p_validate => FALSE

Line 1007: pay_in_utils.set_location(g_debug,'Deletion API Successful',30);

1003: ,p_effective_end_date => l_effective_end_date
1004: ,p_delete_warning => l_warnings
1005: );
1006:
1007: pay_in_utils.set_location(g_debug,'Deletion API Successful',30);
1008: pay_in_utils.trace('**************************************************','********************');
1009: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1010: RETURN;
1011: ELSE

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

1004: ,p_delete_warning => l_warnings
1005: );
1006:
1007: pay_in_utils.set_location(g_debug,'Deletion API Successful',30);
1008: pay_in_utils.trace('**************************************************','********************');
1009: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1010: RETURN;
1011: ELSE
1012: pay_in_utils.trace('**************************************************','********************');

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

1005: );
1006:
1007: pay_in_utils.set_location(g_debug,'Deletion API Successful',30);
1008: pay_in_utils.trace('**************************************************','********************');
1009: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1010: RETURN;
1011: ELSE
1012: pay_in_utils.trace('**************************************************','********************');
1013: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

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

1008: pay_in_utils.trace('**************************************************','********************');
1009: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1010: RETURN;
1011: ELSE
1012: pay_in_utils.trace('**************************************************','********************');
1013: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1014: RETURN;
1015: END IF;
1016: END IF;

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

1009: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1010: RETURN;
1011: ELSE
1012: pay_in_utils.trace('**************************************************','********************');
1013: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1014: RETURN;
1015: END IF;
1016: END IF;
1017: --Record Deletion ends

Line 1025: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);

1021: l_pre_payment_date := fnd_date.canonical_to_date(get_ee_value(p_element_entry_id,'Payment Date',l_effective_date));
1022:
1023: IF (g_debug)
1024: THEN
1025: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
1026: END IF;
1027:
1028: OPEN c_check_emp_number(p_element_entry_id,p_employee_id,l_effective_date,l_business_group_id);
1029: FETCH c_check_emp_number INTO l_flag;

Line 1034: pay_in_utils.trace('l_flag',l_flag);

1030: CLOSE c_check_emp_number;
1031:
1032: IF (g_debug)
1033: THEN
1034: pay_in_utils.trace('l_flag',l_flag);
1035: END IF;
1036:
1037: IF ((l_pre_payment_date IS NULL) OR (l_flag IS NULL))
1038: THEN

Line 1046: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);

1042: CLOSE c_effective_start_date;
1043:
1044: IF (g_debug)
1045: THEN
1046: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
1047: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1048: END IF;
1049: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);
1050:

Line 1047: pay_in_utils.trace('l_object_version_number',l_object_version_number);

1043:
1044: IF (g_debug)
1045: THEN
1046: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
1047: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1048: END IF;
1049: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);
1050:
1051: --Delete the element entry id.

Line 1049: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);

1045: THEN
1046: pay_in_utils.trace('l_pre_payment_date',l_pre_payment_date);
1047: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1048: END IF;
1049: pay_in_utils.set_location(g_debug,'Calling Deletion API',20);
1050:
1051: --Delete the element entry id.
1052: pay_element_entry_api.delete_element_entry
1053: (p_validate => FALSE

Line 1062: pay_in_utils.set_location(g_debug,'Deletion API Successful',30);

1058: ,p_effective_start_date => l_effective_start_date
1059: ,p_effective_end_date => l_effective_end_date
1060: ,p_delete_warning => l_warnings
1061: );
1062: pay_in_utils.set_location(g_debug,'Deletion API Successful',30);
1063: flag := TRUE;
1064:
1065: ELSE
1066: OPEN c_element_details(l_effective_date,l_business_group_id);

Line 1072: pay_in_utils.trace('l_element_type_id',l_element_type_id);

1068: CLOSE c_element_details;
1069:
1070: IF (g_debug)
1071: THEN
1072: pay_in_utils.trace('l_element_type_id',l_element_type_id);
1073: pay_in_utils.trace('l_element_link_id',l_element_link_id);
1074: pay_in_utils.trace('l_assignment_id',l_assignment_id);
1075: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1076: END IF;

Line 1073: pay_in_utils.trace('l_element_link_id',l_element_link_id);

1069:
1070: IF (g_debug)
1071: THEN
1072: pay_in_utils.trace('l_element_type_id',l_element_type_id);
1073: pay_in_utils.trace('l_element_link_id',l_element_link_id);
1074: pay_in_utils.trace('l_assignment_id',l_assignment_id);
1075: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1076: END IF;
1077: END IF;

Line 1074: pay_in_utils.trace('l_assignment_id',l_assignment_id);

1070: IF (g_debug)
1071: THEN
1072: pay_in_utils.trace('l_element_type_id',l_element_type_id);
1073: pay_in_utils.trace('l_element_link_id',l_element_link_id);
1074: pay_in_utils.trace('l_assignment_id',l_assignment_id);
1075: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1076: END IF;
1077: END IF;
1078: END IF;

Line 1075: pay_in_utils.trace('l_object_version_number',l_object_version_number);

1071: THEN
1072: pay_in_utils.trace('l_element_type_id',l_element_type_id);
1073: pay_in_utils.trace('l_element_link_id',l_element_link_id);
1074: pay_in_utils.trace('l_assignment_id',l_assignment_id);
1075: pay_in_utils.trace('l_object_version_number',l_object_version_number);
1076: END IF;
1077: END IF;
1078: END IF;
1079:

Line 1087: pay_in_utils.trace('l_assignment_id',l_assignment_id);

1083: l_assignment_id := p_assignment_id ;
1084:
1085: IF (g_debug)
1086: THEN
1087: pay_in_utils.trace('l_assignment_id',l_assignment_id);
1088: END IF;
1089:
1090: OPEN csr_element_details(l_assignment_id,l_effective_date);
1091: FETCH csr_element_details INTO l_element_type_id,l_element_link_id;

Line 1096: pay_in_utils.trace('l_element_type_id',l_element_type_id);

1092: CLOSE csr_element_details;
1093:
1094: IF (g_debug)
1095: THEN
1096: pay_in_utils.trace('l_element_type_id',l_element_type_id);
1097: pay_in_utils.trace('l_element_link_id',l_element_link_id);
1098: END IF;
1099:
1100: END IF;

Line 1097: pay_in_utils.trace('l_element_link_id',l_element_link_id);

1093:
1094: IF (g_debug)
1095: THEN
1096: pay_in_utils.trace('l_element_type_id',l_element_type_id);
1097: pay_in_utils.trace('l_element_link_id',l_element_link_id);
1098: END IF;
1099:
1100: END IF;
1101:

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

1188: WHERE input_value_id = l_input_values_rec(9).input_value_id
1189: AND element_entry_id = p_element_entry_id;
1190:
1191: END IF;
1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1194: END create_form_24;
1195:
1196: END pay_in_form_24q_web_adi;

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

1189: AND element_entry_id = p_element_entry_id;
1190:
1191: END IF;
1192: pay_in_utils.trace('**************************************************','********************');
1193: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1194: END create_form_24;
1195:
1196: END pay_in_form_24q_web_adi;