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_FF_PKG dependencies on PAY_IN_UTILS

Line 6: p_token_name pay_in_utils.char_tab_type;

2: /* $Header: pyindedn.pkb 120.17 2011/05/18 12:07:56 nchinnam ship $ */
3:
4: g_debug BOOLEAN;
5: g_package CONSTANT VARCHAR2(100) := 'pay_in_ff_pkg.';
6: p_token_name pay_in_utils.char_tab_type;
7: p_token_value pay_in_utils.char_tab_type;
8:
9: --------------------------------------------------------------------------
10: -- Name : CHECK_RETAINER --

Line 7: p_token_value pay_in_utils.char_tab_type;

3:
4: g_debug BOOLEAN;
5: g_package CONSTANT VARCHAR2(100) := 'pay_in_ff_pkg.';
6: p_token_name pay_in_utils.char_tab_type;
7: p_token_value pay_in_utils.char_tab_type;
8:
9: --------------------------------------------------------------------------
10: -- Name : CHECK_RETAINER --
11: -- Type : Function --

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

45: BEGIN
46: g_debug:= hr_utility.debug_enabled;
47: l_procedure:= g_package ||'check_retainer';
48:
49: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_assignment_id',p_assignment_id);

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

48:
49: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_assignment_id',p_assignment_id);
54: pay_in_utils.trace('p_payroll_action_id',p_payroll_action_id);
55: pay_in_utils.trace('**************************************************','********************');
56: END IF;

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

49: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_assignment_id',p_assignment_id);
54: pay_in_utils.trace('p_payroll_action_id',p_payroll_action_id);
55: pay_in_utils.trace('**************************************************','********************');
56: END IF;
57: OPEN c_emp_cat;

Line 54: pay_in_utils.trace('p_payroll_action_id',p_payroll_action_id);

50:
51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_assignment_id',p_assignment_id);
54: pay_in_utils.trace('p_payroll_action_id',p_payroll_action_id);
55: pay_in_utils.trace('**************************************************','********************');
56: END IF;
57: OPEN c_emp_cat;
58: FETCH c_emp_cat INTO l_emp_cat;

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

51: IF g_debug THEN
52: pay_in_utils.trace('**************************************************','********************');
53: pay_in_utils.trace('p_assignment_id',p_assignment_id);
54: pay_in_utils.trace('p_payroll_action_id',p_payroll_action_id);
55: pay_in_utils.trace('**************************************************','********************');
56: END IF;
57: OPEN c_emp_cat;
58: FETCH c_emp_cat INTO l_emp_cat;
59: CLOSE c_emp_cat;

Line 62: pay_in_utils.trace('l_emp_cat',l_emp_cat);

58: FETCH c_emp_cat INTO l_emp_cat;
59: CLOSE c_emp_cat;
60:
61: IF g_debug THEN
62: pay_in_utils.trace('l_emp_cat',l_emp_cat);
63: END IF;
64:
65: IF (l_emp_cat = 'IN_RE') THEN
66: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);

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

62: pay_in_utils.trace('l_emp_cat',l_emp_cat);
63: END IF;
64:
65: IF (l_emp_cat = 'IN_RE') THEN
66: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
67: RETURN 1;
68: ELSE
69: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
70: RETURN 0;

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

65: IF (l_emp_cat = 'IN_RE') THEN
66: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,30);
67: RETURN 1;
68: ELSE
69: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,40);
70: RETURN 0;
71: END IF;
72:
73: EXCEPTION

Line 75: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

71: END IF;
72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
76: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
77: hr_utility.trace(l_message);
78: RETURN NULL;
79: END check_retainer;

Line 76: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);

72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
76: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 50);
77: hr_utility.trace(l_message);
78: RETURN NULL;
79: END check_retainer;
80:

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

115: BEGIN
116: g_debug:= hr_utility.debug_enabled;
117: l_procedure:= g_package ||'check_retainer';
118:
119: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
120:
121: IF g_debug THEN
122: pay_in_utils.trace('**************************************************','********************');
123: pay_in_utils.trace('p_assignment_id',p_assignment_id);

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

118:
119: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
120:
121: IF g_debug THEN
122: pay_in_utils.trace('**************************************************','********************');
123: pay_in_utils.trace('p_assignment_id',p_assignment_id);
124: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'dd/mm/yyyy'));
125: pay_in_utils.trace('**************************************************','********************');
126: END IF;

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

119: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
120:
121: IF g_debug THEN
122: pay_in_utils.trace('**************************************************','********************');
123: pay_in_utils.trace('p_assignment_id',p_assignment_id);
124: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'dd/mm/yyyy'));
125: pay_in_utils.trace('**************************************************','********************');
126: END IF;
127: OPEN c_get_edli;

Line 124: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'dd/mm/yyyy'));

120:
121: IF g_debug THEN
122: pay_in_utils.trace('**************************************************','********************');
123: pay_in_utils.trace('p_assignment_id',p_assignment_id);
124: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'dd/mm/yyyy'));
125: pay_in_utils.trace('**************************************************','********************');
126: END IF;
127: OPEN c_get_edli;
128: FETCH c_get_edli INTO l_edli;

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

121: IF g_debug THEN
122: pay_in_utils.trace('**************************************************','********************');
123: pay_in_utils.trace('p_assignment_id',p_assignment_id);
124: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'dd/mm/yyyy'));
125: pay_in_utils.trace('**************************************************','********************');
126: END IF;
127: OPEN c_get_edli;
128: FETCH c_get_edli INTO l_edli;
129: CLOSE c_get_edli;

Line 132: pay_in_utils.trace('l_edli',l_edli);

128: FETCH c_get_edli INTO l_edli;
129: CLOSE c_get_edli;
130:
131: IF g_debug THEN
132: pay_in_utils.trace('l_edli',l_edli);
133: END IF;
134:
135: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);
136: RETURN l_edli;

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

131: IF g_debug THEN
132: pay_in_utils.trace('l_edli',l_edli);
133: END IF;
134:
135: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,20);
136: RETURN l_edli;
137:
138: EXCEPTION
139: WHEN OTHERS THEN

Line 140: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

136: RETURN l_edli;
137:
138: EXCEPTION
139: WHEN OTHERS THEN
140: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
141: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
142: hr_utility.trace(l_message);
143: RETURN NULL;
144: END check_edli;

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

137:
138: EXCEPTION
139: WHEN OTHERS THEN
140: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
141: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
142: hr_utility.trace(l_message);
143: RETURN NULL;
144: END check_edli;
145:

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

233:
234: BEGIN
235: g_debug:= hr_utility.debug_enabled;
236: l_procedure := g_package ||'get_esi_cont_amt';
237: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
238:
239: l_half_year_start1:='01-04-';
240: l_half_year_start2:='01-10-';
241:

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

239: l_half_year_start1:='01-04-';
240: l_half_year_start2:='01-10-';
241:
242: IF g_debug THEN
243: pay_in_utils.trace('**************************************************','********************');
244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));
245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));

Line 244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));

240: l_half_year_start2:='01-10-';
241:
242: IF g_debug THEN
243: pay_in_utils.trace('**************************************************','********************');
244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));
245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));
248: pay_in_utils.trace('**************************************************','********************');

Line 245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));

241:
242: IF g_debug THEN
243: pay_in_utils.trace('**************************************************','********************');
244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));
245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));
248: pay_in_utils.trace('**************************************************','********************');
249: END IF;

Line 246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));

242: IF g_debug THEN
243: pay_in_utils.trace('**************************************************','********************');
244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));
245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));
248: pay_in_utils.trace('**************************************************','********************');
249: END IF;
250:

Line 247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));

243: pay_in_utils.trace('**************************************************','********************');
244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));
245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));
248: pay_in_utils.trace('**************************************************','********************');
249: END IF;
250:
251: l_month :=TO_NUMBER(TO_CHAR(p_date_earned,'mm'));

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

244: pay_in_utils.trace ('p_assignment_action_id ',to_char(p_assignment_action_id));
245: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
246: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
247: pay_in_utils.trace ('p_eligible_amt ',to_char(p_eligible_amt));
248: pay_in_utils.trace('**************************************************','********************');
249: END IF;
250:
251: l_month :=TO_NUMBER(TO_CHAR(p_date_earned,'mm'));
252: l_year := TO_NUMBER(TO_CHAR(p_date_earned,'yyyy'));

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

250:
251: l_month :=TO_NUMBER(TO_CHAR(p_date_earned,'mm'));
252: l_year := TO_NUMBER(TO_CHAR(p_date_earned,'yyyy'));
253:
254: pay_in_utils.set_location(g_debug,l_procedure, 20);
255:
256: IF l_month BETWEEN 4 AND 9 THEN
257: l_start := TO_DATE(l_half_year_start1||TO_CHAR(l_year),'dd-mm-yyyy');
258: ELSIF l_month BETWEEN 10 and 12 THEN

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

264: IF l_month BETWEEN 5 AND 9 and l_year =2010 THEN
265: l_start := TO_DATE('01-05-'||TO_CHAR(l_year),'dd-mm-yyyy');
266: END IF;
267:
268: pay_in_utils.set_location(g_debug,l_procedure, 30);
269:
270: OPEN get_date(l_start);
271: FETCH get_date INTO l_esi_cont_date;
272: CLOSE get_date;

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

270: OPEN get_date(l_start);
271: FETCH get_date INTO l_esi_cont_date;
272: CLOSE get_date;
273:
274: pay_in_utils.set_location(g_debug,l_procedure, 40);
275:
276: --Get the last date of the month to be considered for ESI Eligibility
277: l_esi_contr_month := last_day(l_esi_cont_date);
278:

Line 283: pay_in_utils.trace ('l_esi_contr_month : ' , to_char(l_esi_contr_month,'DD-MM-YYYY'));

279: --Get the last date of the current pay period
280: l_start_period := last_day(p_date_earned);
281:
282: IF g_debug THEN
283: pay_in_utils.trace ('l_esi_contr_month : ' , to_char(l_esi_contr_month,'DD-MM-YYYY'));
284: pay_in_utils.trace ('l_start_period : ' , to_char(l_start_period,'DD-MM-YYYY'));
285: END IF;
286:
287: pay_in_utils.set_location(g_debug,l_procedure, 50);

Line 284: pay_in_utils.trace ('l_start_period : ' , to_char(l_start_period,'DD-MM-YYYY'));

280: l_start_period := last_day(p_date_earned);
281:
282: IF g_debug THEN
283: pay_in_utils.trace ('l_esi_contr_month : ' , to_char(l_esi_contr_month,'DD-MM-YYYY'));
284: pay_in_utils.trace ('l_start_period : ' , to_char(l_start_period,'DD-MM-YYYY'));
285: END IF;
286:
287: pay_in_utils.set_location(g_debug,l_procedure, 50);
288:

Line 287: pay_in_utils.set_location(g_debug,l_procedure, 50);

283: pay_in_utils.trace ('l_esi_contr_month : ' , to_char(l_esi_contr_month,'DD-MM-YYYY'));
284: pay_in_utils.trace ('l_start_period : ' , to_char(l_start_period,'DD-MM-YYYY'));
285: END IF;
286:
287: pay_in_utils.set_location(g_debug,l_procedure, 50);
288:
289: --
290: -- IF Current month is to considered for finding ESI Eligibility
291: -- THEN return back the input value(p_eligible_amt)

Line 299: pay_in_utils.set_location(g_debug,l_procedure, 60);

295:
296: IF l_start_period =l_esi_contr_month THEN
297:
298: l_esi_eligible_amt :=p_eligible_amt;
299: pay_in_utils.set_location(g_debug,l_procedure, 60);
300:
301: ELSE
302: pay_in_utils.set_location(g_debug,l_procedure, 70);
303: OPEN get_defined_bal_id;

Line 302: pay_in_utils.set_location(g_debug,l_procedure, 70);

298: l_esi_eligible_amt :=p_eligible_amt;
299: pay_in_utils.set_location(g_debug,l_procedure, 60);
300:
301: ELSE
302: pay_in_utils.set_location(g_debug,l_procedure, 70);
303: OPEN get_defined_bal_id;
304: FETCH get_defined_bal_id INTO l_defined_balance_id;
305: CLOSE get_defined_bal_id;
306:

Line 314: pay_in_utils.set_location(g_debug,'Virtual ASACT ID : '||to_char(l_virtual_asact_id),80);

310: INTO l_virtual_asact_id;
311: CLOSE csr_casact;
312:
313:
314: pay_in_utils.set_location(g_debug,'Virtual ASACT ID : '||to_char(l_virtual_asact_id),80);
315:
316: l_esi_eligible_amt := pay_balance_pkg.get_value(
317: p_defined_balance_id => l_defined_balance_id,
318: p_assignment_action_id => l_virtual_asact_id

Line 321: pay_in_utils.set_location(g_debug,l_procedure, 80);

317: p_defined_balance_id => l_defined_balance_id,
318: p_assignment_action_id => l_virtual_asact_id
319: );
320:
321: pay_in_utils.set_location(g_debug,l_procedure, 80);
322:
323: END IF;
324:
325: IF g_debug THEN

Line 326: pay_in_utils.trace ('l_esi_eligible_amt : ' , l_esi_eligible_amt);

322:
323: END IF;
324:
325: IF g_debug THEN
326: pay_in_utils.trace ('l_esi_eligible_amt : ' , l_esi_eligible_amt);
327: END IF;
328:
329: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);
330: RETURN l_esi_eligible_amt;

Line 329: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);

325: IF g_debug THEN
326: pay_in_utils.trace ('l_esi_eligible_amt : ' , l_esi_eligible_amt);
327: END IF;
328:
329: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 90);
330: RETURN l_esi_eligible_amt;
331:
332: EXCEPTION
333: WHEN OTHERS THEN

Line 334: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

330: RETURN l_esi_eligible_amt;
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
335: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);
336: hr_utility.trace(l_message);
337: RETURN NULL;
338: END get_esi_cont_amt;

Line 335: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);

331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
335: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 100);
336: hr_utility.trace(l_message);
337: RETURN NULL;
338: END get_esi_cont_amt;
339:

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

393:
394: BEGIN
395: g_debug := hr_utility.debug_enabled;
396: l_procedure := g_package ||'get_esi_disability_details';
397: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
398:
399: l_half_year_start1:='01-04-';
400: l_half_year_start2:='01-10-';
401:

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

399: l_half_year_start1:='01-04-';
400: l_half_year_start2:='01-10-';
401:
402: IF g_debug THEN
403: pay_in_utils.trace('**************************************************','********************');
404: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
405: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
406: pay_in_utils.trace('**************************************************','********************');
407: END IF;

Line 404: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));

400: l_half_year_start2:='01-10-';
401:
402: IF g_debug THEN
403: pay_in_utils.trace('**************************************************','********************');
404: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
405: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
406: pay_in_utils.trace('**************************************************','********************');
407: END IF;
408:

Line 405: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));

401:
402: IF g_debug THEN
403: pay_in_utils.trace('**************************************************','********************');
404: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
405: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
406: pay_in_utils.trace('**************************************************','********************');
407: END IF;
408:
409: l_month := TO_NUMBER(TO_CHAR(p_date_earned,'mm'));

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

402: IF g_debug THEN
403: pay_in_utils.trace('**************************************************','********************');
404: pay_in_utils.trace ('p_assignment_id ',to_char(p_assignment_id));
405: pay_in_utils.trace ('p_date_earned ',to_char(p_date_earned,'DD-MM-YYYY'));
406: pay_in_utils.trace('**************************************************','********************');
407: END IF;
408:
409: l_month := TO_NUMBER(TO_CHAR(p_date_earned,'mm'));
410: l_year := TO_NUMBER(TO_CHAR(p_date_earned,'yyyy'));

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

408:
409: l_month := TO_NUMBER(TO_CHAR(p_date_earned,'mm'));
410: l_year := TO_NUMBER(TO_CHAR(p_date_earned,'yyyy'));
411:
412: pay_in_utils.set_location(g_debug,l_procedure, 20);
413:
414: IF l_month BETWEEN 4 AND 9 THEN
415: l_start := TO_DATE(l_half_year_start1||TO_CHAR(l_year),'dd-mm-yyyy');
416: ELSIF l_month BETWEEN 10 and 12 THEN

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

418: ELSE
419: l_start := TO_DATE(l_half_year_start2||TO_CHAR(l_year-1),'dd-mm-yyyy');
420: END IF;
421:
422: pay_in_utils.set_location(g_debug,l_procedure, 30);
423:
424: /*To get latest of first pay period date and contribution period start date*/
425:
426: OPEN get_date(l_start);

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

426: OPEN get_date(l_start);
427: FETCH get_date INTO l_esi_cont_date;
428: CLOSE get_date;
429:
430: pay_in_utils.set_location(g_debug,l_procedure, 40);
431:
432: IF g_debug THEN
433: pay_in_utils.trace ('l_esi_cont_date : ' , to_char(l_esi_cont_date,'DD-MM-YYYY'));
434: END IF;

Line 433: pay_in_utils.trace ('l_esi_cont_date : ' , to_char(l_esi_cont_date,'DD-MM-YYYY'));

429:
430: pay_in_utils.set_location(g_debug,l_procedure, 40);
431:
432: IF g_debug THEN
433: pay_in_utils.trace ('l_esi_cont_date : ' , to_char(l_esi_cont_date,'DD-MM-YYYY'));
434: END IF;
435:
436: pay_in_utils.set_location(g_debug,l_procedure, 50);
437:

Line 436: pay_in_utils.set_location(g_debug,l_procedure, 50);

432: IF g_debug THEN
433: pay_in_utils.trace ('l_esi_cont_date : ' , to_char(l_esi_cont_date,'DD-MM-YYYY'));
434: END IF;
435:
436: pay_in_utils.set_location(g_debug,l_procedure, 50);
437:
438: l_proof := 'N';
439:
440: Open c_disab_details(l_esi_cont_date);

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

442: Close c_disab_details;
443:
444: p_disable_proof := l_proof;
445:
446: pay_in_utils.set_location(g_debug,l_procedure, 60);
447:
448:
449: IF g_debug THEN
450: pay_in_utils.trace('p_disable_proof',p_disable_proof);

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

446: pay_in_utils.set_location(g_debug,l_procedure, 60);
447:
448:
449: IF g_debug THEN
450: pay_in_utils.trace('p_disable_proof',p_disable_proof);
451: END IF;
452:
453: pay_in_utils.set_location(g_debug,l_procedure, 70);
454:

Line 453: pay_in_utils.set_location(g_debug,l_procedure, 70);

449: IF g_debug THEN
450: pay_in_utils.trace('p_disable_proof',p_disable_proof);
451: END IF;
452:
453: pay_in_utils.set_location(g_debug,l_procedure, 70);
454:
455:
456: pay_in_utils.trace('**************************************************','********************');
457: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

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

452:
453: pay_in_utils.set_location(g_debug,l_procedure, 70);
454:
455:
456: pay_in_utils.trace('**************************************************','********************');
457: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
458: Return 0;
459:
460: END get_esi_disability_details;

Line 457: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);

453: pay_in_utils.set_location(g_debug,l_procedure, 70);
454:
455:
456: pay_in_utils.trace('**************************************************','********************');
457: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
458: Return 0;
459:
460: END get_esi_disability_details;
461:

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

483: l_procedure VARCHAR2(100);
484: BEGIN
485: g_debug := hr_utility.debug_enabled;
486: l_procedure := g_package ||'round_to_5paise';
487: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
488:
489:
490: IF g_debug THEN
491: pay_in_utils.trace('p_number',to_char(p_number));

Line 491: pay_in_utils.trace('p_number',to_char(p_number));

487: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
488:
489:
490: IF g_debug THEN
491: pay_in_utils.trace('p_number',to_char(p_number));
492: END IF;
493:
494: l_number := ROUND(p_number,2);
495: N := CEIL (l_number*10)/10;

Line 498: pay_in_utils.trace('N',to_char(N));

494: l_number := ROUND(p_number,2);
495: N := CEIL (l_number*10)/10;
496:
497: IF g_debug THEN
498: pay_in_utils.trace('N',to_char(N));
499: END IF;
500:
501: IF (N-l_number) >= 0.05 THEN
502: RETURN (N-0.05);

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

503: ELSE
504: RETURN N;
505: END IF;
506:
507: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
508:
509: END ROUND_TO_5PAISE;
510:
511: --------------------------------------------------------------------------

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

555:
556: BEGIN
557: g_debug := hr_utility.debug_enabled;
558: l_procedure := g_package ||'get_accrual_plan';
559: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
560:
561:
562: IF g_debug THEN
563: pay_in_utils.trace('**************************************************','********************');

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

559: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
560:
561:
562: IF g_debug THEN
563: pay_in_utils.trace('**************************************************','********************');
564: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
565: pay_in_utils.trace('p_effective_date',to_char(p_effective_date));
566: pay_in_utils.trace('p_plan_category ',to_char(p_plan_category ));
567: pay_in_utils.trace('**************************************************','********************');

Line 564: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));

560:
561:
562: IF g_debug THEN
563: pay_in_utils.trace('**************************************************','********************');
564: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
565: pay_in_utils.trace('p_effective_date',to_char(p_effective_date));
566: pay_in_utils.trace('p_plan_category ',to_char(p_plan_category ));
567: pay_in_utils.trace('**************************************************','********************');
568: END IF;

Line 565: pay_in_utils.trace('p_effective_date',to_char(p_effective_date));

561:
562: IF g_debug THEN
563: pay_in_utils.trace('**************************************************','********************');
564: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
565: pay_in_utils.trace('p_effective_date',to_char(p_effective_date));
566: pay_in_utils.trace('p_plan_category ',to_char(p_plan_category ));
567: pay_in_utils.trace('**************************************************','********************');
568: END IF;
569:

Line 566: pay_in_utils.trace('p_plan_category ',to_char(p_plan_category ));

562: IF g_debug THEN
563: pay_in_utils.trace('**************************************************','********************');
564: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
565: pay_in_utils.trace('p_effective_date',to_char(p_effective_date));
566: pay_in_utils.trace('p_plan_category ',to_char(p_plan_category ));
567: pay_in_utils.trace('**************************************************','********************');
568: END IF;
569:
570: OPEN csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;

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

563: pay_in_utils.trace('**************************************************','********************');
564: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
565: pay_in_utils.trace('p_effective_date',to_char(p_effective_date));
566: pay_in_utils.trace('p_plan_category ',to_char(p_plan_category ));
567: pay_in_utils.trace('**************************************************','********************');
568: END IF;
569:
570: OPEN csr_get_accrual_plan_id(p_assignment_id, p_effective_date, p_plan_category) ;
571: FETCH csr_get_accrual_plan_id INTO l_accrual_plan_id;

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

579: CLOSE csr_get_accrual_plan_id;
580: END IF ;
581:
582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('p_message ',p_message);
585: pay_in_utils.trace('l_accrual_plan_id ',to_char(l_accrual_plan_id ));
586: pay_in_utils.trace('**************************************************','********************');
587: END IF;

Line 584: pay_in_utils.trace('p_message ',p_message);

580: END IF ;
581:
582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('p_message ',p_message);
585: pay_in_utils.trace('l_accrual_plan_id ',to_char(l_accrual_plan_id ));
586: pay_in_utils.trace('**************************************************','********************');
587: END IF;
588:

Line 585: pay_in_utils.trace('l_accrual_plan_id ',to_char(l_accrual_plan_id ));

581:
582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('p_message ',p_message);
585: pay_in_utils.trace('l_accrual_plan_id ',to_char(l_accrual_plan_id ));
586: pay_in_utils.trace('**************************************************','********************');
587: END IF;
588:
589: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

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

582: IF g_debug THEN
583: pay_in_utils.trace('**************************************************','********************');
584: pay_in_utils.trace('p_message ',p_message);
585: pay_in_utils.trace('l_accrual_plan_id ',to_char(l_accrual_plan_id ));
586: pay_in_utils.trace('**************************************************','********************');
587: END IF;
588:
589: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
590:

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

585: pay_in_utils.trace('l_accrual_plan_id ',to_char(l_accrual_plan_id ));
586: pay_in_utils.trace('**************************************************','********************');
587: END IF;
588:
589: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
590:
591: RETURN l_accrual_plan_id;
592:
593: EXCEPTION

Line 595: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

591: RETURN l_accrual_plan_id;
592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
596: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
597: hr_utility.trace(l_message);
598: RETURN NULL;
599:

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

592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
596: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
597: hr_utility.trace(l_message);
598: RETURN NULL;
599:
600: END get_accrual_plan;

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

640: BEGIN
641:
642: g_debug:= hr_utility.debug_enabled;
643: l_procedure := g_package ||'get_net_accrual';
644: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));

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

643: l_procedure := g_package ||'get_net_accrual';
644: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));

Line 648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));

644: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));
652: pay_in_utils.trace('p_plan_category ',p_plan_category);

Line 649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));

645:
646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));
652: pay_in_utils.trace('p_plan_category ',p_plan_category);
653: pay_in_utils.trace('**************************************************','********************');

Line 650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));

646: IF g_debug THEN
647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));
652: pay_in_utils.trace('p_plan_category ',p_plan_category);
653: pay_in_utils.trace('**************************************************','********************');
654:

Line 651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));

647: pay_in_utils.trace('**************************************************','********************');
648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));
652: pay_in_utils.trace('p_plan_category ',p_plan_category);
653: pay_in_utils.trace('**************************************************','********************');
654:
655: END IF;

Line 652: pay_in_utils.trace('p_plan_category ',p_plan_category);

648: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));
652: pay_in_utils.trace('p_plan_category ',p_plan_category);
653: pay_in_utils.trace('**************************************************','********************');
654:
655: END IF;
656:

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

649: pay_in_utils.trace('p_payroll_id ',to_char(p_payroll_id ));
650: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
651: pay_in_utils.trace('p_calculation_date ',to_char(p_calculation_date,'yyyy-mm-dd'));
652: pay_in_utils.trace('p_plan_category ',p_plan_category);
653: pay_in_utils.trace('**************************************************','********************');
654:
655: END IF;
656:
657: l_plan_id := get_accrual_plan ( p_assignment_id => p_assignment_id

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

672: ,p_accrual => l_accrual
673: ,p_net_entitlement => l_accrued_leave) ;
674:
675: IF g_debug THEN
676: pay_in_utils.trace('**************************************************','********************');
677: pay_in_utils.trace('l_accrued_leave ',to_char(l_accrued_leave));
678: pay_in_utils.trace('p_message ',p_message);
679: pay_in_utils.trace('**************************************************','********************');
680: END IF;

Line 677: pay_in_utils.trace('l_accrued_leave ',to_char(l_accrued_leave));

673: ,p_net_entitlement => l_accrued_leave) ;
674:
675: IF g_debug THEN
676: pay_in_utils.trace('**************************************************','********************');
677: pay_in_utils.trace('l_accrued_leave ',to_char(l_accrued_leave));
678: pay_in_utils.trace('p_message ',p_message);
679: pay_in_utils.trace('**************************************************','********************');
680: END IF;
681: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);

Line 678: pay_in_utils.trace('p_message ',p_message);

674:
675: IF g_debug THEN
676: pay_in_utils.trace('**************************************************','********************');
677: pay_in_utils.trace('l_accrued_leave ',to_char(l_accrued_leave));
678: pay_in_utils.trace('p_message ',p_message);
679: pay_in_utils.trace('**************************************************','********************');
680: END IF;
681: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
682: RETURN l_accrued_leave;

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

675: IF g_debug THEN
676: pay_in_utils.trace('**************************************************','********************');
677: pay_in_utils.trace('l_accrued_leave ',to_char(l_accrued_leave));
678: pay_in_utils.trace('p_message ',p_message);
679: pay_in_utils.trace('**************************************************','********************');
680: END IF;
681: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
682: RETURN l_accrued_leave;
683: EXCEPTION

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

677: pay_in_utils.trace('l_accrued_leave ',to_char(l_accrued_leave));
678: pay_in_utils.trace('p_message ',p_message);
679: pay_in_utils.trace('**************************************************','********************');
680: END IF;
681: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
682: RETURN l_accrued_leave;
683: EXCEPTION
684: WHEN OTHERS THEN
685: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

Line 685: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

681: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 20);
682: RETURN l_accrued_leave;
683: EXCEPTION
684: WHEN OTHERS THEN
685: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
686: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
687: hr_utility.trace(l_message);
688: RETURN NULL;
689:

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

682: RETURN l_accrued_leave;
683: EXCEPTION
684: WHEN OTHERS THEN
685: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
686: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
687: hr_utility.trace(l_message);
688: RETURN NULL;
689:
690:

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

727:
728: BEGIN
729: g_debug := hr_utility.debug_enabled;
730: l_procedure := g_package ||'get_period_number';
731: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
732:
733:
734: IF g_debug THEN
735: pay_in_utils.trace('**************************************************','********************');

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

731: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
732:
733:
734: IF g_debug THEN
735: pay_in_utils.trace('**************************************************','********************');
736: pay_in_utils.trace('p_payroll_id',to_char(p_payroll_id ));
737: pay_in_utils.trace('p_term_date ',to_char(p_term_date,'yyyy-mm-dd'));
738: pay_in_utils.trace('**************************************************','********************');
739: END IF;

Line 736: pay_in_utils.trace('p_payroll_id',to_char(p_payroll_id ));

732:
733:
734: IF g_debug THEN
735: pay_in_utils.trace('**************************************************','********************');
736: pay_in_utils.trace('p_payroll_id',to_char(p_payroll_id ));
737: pay_in_utils.trace('p_term_date ',to_char(p_term_date,'yyyy-mm-dd'));
738: pay_in_utils.trace('**************************************************','********************');
739: END IF;
740:

Line 737: pay_in_utils.trace('p_term_date ',to_char(p_term_date,'yyyy-mm-dd'));

733:
734: IF g_debug THEN
735: pay_in_utils.trace('**************************************************','********************');
736: pay_in_utils.trace('p_payroll_id',to_char(p_payroll_id ));
737: pay_in_utils.trace('p_term_date ',to_char(p_term_date,'yyyy-mm-dd'));
738: pay_in_utils.trace('**************************************************','********************');
739: END IF;
740:
741: l_period_num := 12;

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

734: IF g_debug THEN
735: pay_in_utils.trace('**************************************************','********************');
736: pay_in_utils.trace('p_payroll_id',to_char(p_payroll_id ));
737: pay_in_utils.trace('p_term_date ',to_char(p_term_date,'yyyy-mm-dd'));
738: pay_in_utils.trace('**************************************************','********************');
739: END IF;
740:
741: l_period_num := 12;
742:

Line 748: pay_in_utils.trace('l_period_num',to_char(l_period_num ));

744: FETCH c_period_number INTO l_period_num;
745: CLOSE c_period_number;
746:
747: IF g_debug THEN
748: pay_in_utils.trace('l_period_num',to_char(l_period_num ));
749: END IF;
750:
751: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
752:

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

747: IF g_debug THEN
748: pay_in_utils.trace('l_period_num',to_char(l_period_num ));
749: END IF;
750:
751: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
752:
753: RETURN l_period_num;
754:
755: EXCEPTION

Line 757: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

753: RETURN l_period_num;
754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
758: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
759: hr_utility.trace(l_message);
760: RETURN NULL;
761:

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

754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
758: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
759: hr_utility.trace(l_message);
760: RETURN NULL;
761:
762:

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

808:
809: BEGIN
810: g_debug := hr_utility.debug_enabled;
811: l_procedure := g_package ||'sec_80dd_percent';
812: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
813:
814:
815: IF g_debug THEN
816: pay_in_utils.trace('**************************************************','********************');

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

812: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
813:
814:
815: IF g_debug THEN
816: pay_in_utils.trace('**************************************************','********************');
817: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id ));
818: pay_in_utils.trace('p_date_earned ',to_char(p_date_earned,'yyyy-mm-dd'));
819: pay_in_utils.trace('**************************************************','********************');
820: END IF;

Line 817: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id ));

813:
814:
815: IF g_debug THEN
816: pay_in_utils.trace('**************************************************','********************');
817: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id ));
818: pay_in_utils.trace('p_date_earned ',to_char(p_date_earned,'yyyy-mm-dd'));
819: pay_in_utils.trace('**************************************************','********************');
820: END IF;
821:

Line 818: pay_in_utils.trace('p_date_earned ',to_char(p_date_earned,'yyyy-mm-dd'));

814:
815: IF g_debug THEN
816: pay_in_utils.trace('**************************************************','********************');
817: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id ));
818: pay_in_utils.trace('p_date_earned ',to_char(p_date_earned,'yyyy-mm-dd'));
819: pay_in_utils.trace('**************************************************','********************');
820: END IF;
821:
822: OPEN c_80dd_80_percent;

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

815: IF g_debug THEN
816: pay_in_utils.trace('**************************************************','********************');
817: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id ));
818: pay_in_utils.trace('p_date_earned ',to_char(p_date_earned,'yyyy-mm-dd'));
819: pay_in_utils.trace('**************************************************','********************');
820: END IF;
821:
822: OPEN c_80dd_80_percent;
823: FETCH c_80dd_80_percent INTO l_80_percent;

Line 828: pay_in_utils.trace('l_80_percent',l_80_percent);

824: CLOSE c_80dd_80_percent;
825:
826:
827: IF g_debug THEN
828: pay_in_utils.trace('l_80_percent',l_80_percent);
829: END IF;
830:
831: IF l_80_percent > 0 THEN
832: RETURN 'Y';

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

833: ELSE
834: RETURN 'N';
835: END IF;
836:
837: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
838:
839: END sec_80dd_percent;
840: --------------------------------------------------------------------------
841: -- --

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

895: BEGIN
896:
897: g_debug := hr_utility.debug_enabled ;
898: l_procedure := g_package||'check_father_husband_name' ;
899: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
900:
901: IF g_debug THEN
902: pay_in_utils.trace('**************************************************','********************');
903: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));

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

898: l_procedure := g_package||'check_father_husband_name' ;
899: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
900:
901: IF g_debug THEN
902: pay_in_utils.trace('**************************************************','********************');
903: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
904: pay_in_utils.trace('p_effective_date ',to_char(p_effective_date,'yyyy-mm-dd'));
905: pay_in_utils.trace('**************************************************','********************');
906: END IF;

Line 903: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));

899: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
900:
901: IF g_debug THEN
902: pay_in_utils.trace('**************************************************','********************');
903: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
904: pay_in_utils.trace('p_effective_date ',to_char(p_effective_date,'yyyy-mm-dd'));
905: pay_in_utils.trace('**************************************************','********************');
906: END IF;
907:

Line 904: pay_in_utils.trace('p_effective_date ',to_char(p_effective_date,'yyyy-mm-dd'));

900:
901: IF g_debug THEN
902: pay_in_utils.trace('**************************************************','********************');
903: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
904: pay_in_utils.trace('p_effective_date ',to_char(p_effective_date,'yyyy-mm-dd'));
905: pay_in_utils.trace('**************************************************','********************');
906: END IF;
907:
908: p_message_name := 'SUCCESS';

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

901: IF g_debug THEN
902: pay_in_utils.trace('**************************************************','********************');
903: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
904: pay_in_utils.trace('p_effective_date ',to_char(p_effective_date,'yyyy-mm-dd'));
905: pay_in_utils.trace('**************************************************','********************');
906: END IF;
907:
908: p_message_name := 'SUCCESS';
909: p_token_value:=NULL;

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

930: p_token_value := 'Spouse';
931: END IF;
932:
933: IF g_debug THEN
934: pay_in_utils.trace('**************************************************','********************');
935: pay_in_utils.trace('p_message_name ',p_message_name);
936: pay_in_utils.trace('p_token_value ',p_token_value);
937: pay_in_utils.trace('**************************************************','********************');
938: END IF;

Line 935: pay_in_utils.trace('p_message_name ',p_message_name);

931: END IF;
932:
933: IF g_debug THEN
934: pay_in_utils.trace('**************************************************','********************');
935: pay_in_utils.trace('p_message_name ',p_message_name);
936: pay_in_utils.trace('p_token_value ',p_token_value);
937: pay_in_utils.trace('**************************************************','********************');
938: END IF;
939: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 936: pay_in_utils.trace('p_token_value ',p_token_value);

932:
933: IF g_debug THEN
934: pay_in_utils.trace('**************************************************','********************');
935: pay_in_utils.trace('p_message_name ',p_message_name);
936: pay_in_utils.trace('p_token_value ',p_token_value);
937: pay_in_utils.trace('**************************************************','********************');
938: END IF;
939: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
940: RETURN;

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

933: IF g_debug THEN
934: pay_in_utils.trace('**************************************************','********************');
935: pay_in_utils.trace('p_message_name ',p_message_name);
936: pay_in_utils.trace('p_token_value ',p_token_value);
937: pay_in_utils.trace('**************************************************','********************');
938: END IF;
939: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
940: RETURN;
941:

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

935: pay_in_utils.trace('p_message_name ',p_message_name);
936: pay_in_utils.trace('p_token_value ',p_token_value);
937: pay_in_utils.trace('**************************************************','********************');
938: END IF;
939: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
940: RETURN;
941:
942: END check_father_husband_name;
943: --------------------------------------------------------------------------

Line 970: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

966: ,p_gre IN NUMBER
967: ,p_pf IN NUMBER
968: ,p_esi IN NUMBER
969: ,p_message OUT NOCOPY VARCHAR2
970: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
971: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
972: )
973: IS
974: -- The cursor to obtain the maximum payroll run date for an assignment in a BG.

Line 971: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type

967: ,p_pf IN NUMBER
968: ,p_esi IN NUMBER
969: ,p_message OUT NOCOPY VARCHAR2
970: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
971: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type
972: )
973: IS
974: -- The cursor to obtain the maximum payroll run date for an assignment in a BG.
975: CURSOR c_max_pay_date

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

1060:
1061: BEGIN
1062: g_debug := hr_utility.debug_enabled;
1063: l_procedure := g_package ||'check_gre_update';
1064: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1065:
1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');

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

1064: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1065:
1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);

Line 1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));

1065:
1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );

Line 1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);

1066:
1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);

Line 1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));

1067: IF g_debug THEN
1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));

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

1068: pay_in_utils.trace('**************************************************','********************');
1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));

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

1069: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));
1077: pay_in_utils.trace('p_esi ',to_char(p_esi));

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

1070: pay_in_utils.trace('p_dt_mode ',p_dt_mode);
1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));
1077: pay_in_utils.trace('p_esi ',to_char(p_esi));
1078: pay_in_utils.trace('**************************************************','********************');

Line 1075: pay_in_utils.trace('p_gre ',to_char(p_gre));

1071: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));
1077: pay_in_utils.trace('p_esi ',to_char(p_esi));
1078: pay_in_utils.trace('**************************************************','********************');
1079: END IF;

Line 1076: pay_in_utils.trace('p_pf ',to_char(p_pf));

1072: pay_in_utils.trace('p_gre_org ',p_gre_org);
1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));
1077: pay_in_utils.trace('p_esi ',to_char(p_esi));
1078: pay_in_utils.trace('**************************************************','********************');
1079: END IF;
1080:

Line 1077: pay_in_utils.trace('p_esi ',to_char(p_esi));

1073: pay_in_utils.trace('p_pf_org ',p_pf_org );
1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));
1077: pay_in_utils.trace('p_esi ',to_char(p_esi));
1078: pay_in_utils.trace('**************************************************','********************');
1079: END IF;
1080:
1081: OPEN c_max_pay_date;

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

1074: pay_in_utils.trace('p_esi_org ',p_esi_org);
1075: pay_in_utils.trace('p_gre ',to_char(p_gre));
1076: pay_in_utils.trace('p_pf ',to_char(p_pf));
1077: pay_in_utils.trace('p_esi ',to_char(p_esi));
1078: pay_in_utils.trace('**************************************************','********************');
1079: END IF;
1080:
1081: OPEN c_max_pay_date;
1082: FETCH c_max_pay_date INTO l_max_date_earned;

Line 1138: pay_in_utils.trace('p_message ',p_message);

1134: p_token_name(1) := 'ORG';
1135: p_token_value(1) := hr_general.decode_lookup('IN_MESSAGE_TOKENS','ESI_ORG');
1136: ELSE
1137: IF g_debug THEN
1138: pay_in_utils.trace('p_message ',p_message);
1139: END IF;
1140: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1141: RETURN;
1142: END IF;

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

1136: ELSE
1137: IF g_debug THEN
1138: pay_in_utils.trace('p_message ',p_message);
1139: END IF;
1140: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1141: RETURN;
1142: END IF;
1143: ELSIF (l_count > 2)
1144: THEN

Line 1163: pay_in_utils.trace('p_message ',p_message );

1159: CLOSE c_flag;
1160:
1161: IF (l_flag IS NULL) THEN
1162: IF g_debug THEN
1163: pay_in_utils.trace('p_message ',p_message );
1164: END IF;
1165: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);
1166: RETURN;
1167: ELSE

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

1161: IF (l_flag IS NULL) THEN
1162: IF g_debug THEN
1163: pay_in_utils.trace('p_message ',p_message );
1164: END IF;
1165: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,30);
1166: RETURN;
1167: ELSE
1168: p_message := 'PER_IN_GRE_CHANGE_FORBIDDEN';
1169: END IF;

Line 1175: pay_in_utils.trace('p_message ',p_message );

1171: p_message := 'PER_IN_GRE_CHANGE_FORBIDDEN';
1172: END IF;
1173: ELSE
1174: IF g_debug THEN
1175: pay_in_utils.trace('p_message ',p_message );
1176: END IF;
1177: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
1178: RETURN;
1179: END IF;

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

1173: ELSE
1174: IF g_debug THEN
1175: pay_in_utils.trace('p_message ',p_message );
1176: END IF;
1177: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,40);
1178: RETURN;
1179: END IF;
1180:
1181: END check_gre_update;

Line 1199: -- 1.1 27-Dec-04 lnagaraj Used pay_in_utils.chk_element_link --

1195: --------------------------------------------------------------------------
1196: -- Rev# Date Userid Description --
1197: --------------------------------------------------------------------------
1198: -- 1.0 05-Dec-04 statkar Created this function --
1199: -- 1.1 27-Dec-04 lnagaraj Used pay_in_utils.chk_element_link --
1200: -- 1.2 24-Mar-05 aaagarwa Modified cursor c_pf --
1201: -- 1.3 10-Apr-05 abhjain Removed the automatic element entry code --
1202: -- 1.4 25-Jul-05 snekkala Removed check for PF organization --
1203: -- 1.5 18-Aug-05 abhjain Commented the call to check_father_husband_name--

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

1222:
1223: BEGIN
1224: g_debug := hr_utility.debug_enabled;
1225: l_procedure := g_package ||'check_pf_update';
1226: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
1227:
1228: IF g_debug THEN
1229: pay_in_utils.trace('**************************************************','********************');
1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));

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

1225: l_procedure := g_package ||'check_pf_update';
1226: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
1227:
1228: IF g_debug THEN
1229: pay_in_utils.trace('**************************************************','********************');
1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );

Line 1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));

1226: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure,10);
1227:
1228: IF g_debug THEN
1229: pay_in_utils.trace('**************************************************','********************');
1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );

Line 1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );

1227:
1228: IF g_debug THEN
1229: pay_in_utils.trace('**************************************************','********************');
1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );

Line 1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));

1228: IF g_debug THEN
1229: pay_in_utils.trace('**************************************************','********************');
1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));

Line 1233: pay_in_utils.trace('p_gre_org ',p_gre_org );

1229: pay_in_utils.trace('**************************************************','********************');
1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));

Line 1234: pay_in_utils.trace('p_pf_org ',p_pf_org );

1230: pay_in_utils.trace('p_effective_date',to_char(p_effective_date,'yyyy-mm-dd'));
1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));
1238: pay_in_utils.trace('p_esi ',to_char(p_esi));

Line 1235: pay_in_utils.trace('p_esi_org ',p_esi_org );

1231: pay_in_utils.trace('p_dt_mode ',p_dt_mode );
1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));
1238: pay_in_utils.trace('p_esi ',to_char(p_esi));
1239: pay_in_utils.trace('**************************************************','********************');

Line 1236: pay_in_utils.trace('p_gre ',to_char(p_gre));

1232: pay_in_utils.trace('p_assignment_id',to_char(p_assignment_id));
1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));
1238: pay_in_utils.trace('p_esi ',to_char(p_esi));
1239: pay_in_utils.trace('**************************************************','********************');
1240: END IF;

Line 1237: pay_in_utils.trace('p_pf ',to_char(p_pf));

1233: pay_in_utils.trace('p_gre_org ',p_gre_org );
1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));
1238: pay_in_utils.trace('p_esi ',to_char(p_esi));
1239: pay_in_utils.trace('**************************************************','********************');
1240: END IF;
1241:

Line 1238: pay_in_utils.trace('p_esi ',to_char(p_esi));

1234: pay_in_utils.trace('p_pf_org ',p_pf_org );
1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));
1238: pay_in_utils.trace('p_esi ',to_char(p_esi));
1239: pay_in_utils.trace('**************************************************','********************');
1240: END IF;
1241:
1242: l_message_name:='SUCCESS';

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

1235: pay_in_utils.trace('p_esi_org ',p_esi_org );
1236: pay_in_utils.trace('p_gre ',to_char(p_gre));
1237: pay_in_utils.trace('p_pf ',to_char(p_pf));
1238: pay_in_utils.trace('p_esi ',to_char(p_esi));
1239: pay_in_utils.trace('**************************************************','********************');
1240: END IF;
1241:
1242: l_message_name:='SUCCESS';
1243: pay_in_utils.null_message(p_token_name, p_token_value);

Line 1243: pay_in_utils.null_message(p_token_name, p_token_value);

1239: pay_in_utils.trace('**************************************************','********************');
1240: END IF;
1241:
1242: l_message_name:='SUCCESS';
1243: pay_in_utils.null_message(p_token_name, p_token_value);
1244: /*
1245: check_father_husband_name
1246: (p_assignment_id =>p_assignment_id
1247: ,p_effective_date =>p_effective_date

Line 1276: pay_in_utils.raise_message(800, l_message_name, p_token_name, p_token_value);

1272: ,p_token_value => p_token_value
1273: );
1274:
1275: IF l_message_name <> 'SUCCESS' THEN
1276: pay_in_utils.raise_message(800, l_message_name, p_token_name, p_token_value);
1277: END IF;
1278:
1279: IF g_debug THEN
1280: pay_in_utils.trace('p_message',p_message);

Line 1280: pay_in_utils.trace('p_message',p_message);

1276: pay_in_utils.raise_message(800, l_message_name, p_token_name, p_token_value);
1277: END IF;
1278:
1279: IF g_debug THEN
1280: pay_in_utils.trace('p_message',p_message);
1281: END IF;
1282:
1283: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,170);
1284:

Line 1283: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,170);

1279: IF g_debug THEN
1280: pay_in_utils.trace('p_message',p_message);
1281: END IF;
1282:
1283: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure,170);
1284:
1285: END check_pf_update;
1286:
1287: --------------------------------------------------------------------------

Line 1306: -- 1.2 27-Dec-04 lnagaraj Used pay_in_utils.chk_element_link --

1302: --------------------------------------------------------------------------
1303: -- 1.0 05-Dec-04 statkar Created this function --
1304: -- 1.1 14-Dec-04 aaagarwa Added code for deleting ESI element entry --
1305: -- when payroll has not been run. --
1306: -- 1.2 27-Dec-04 lnagaraj Used pay_in_utils.chk_element_link --
1307: -- 1.3 24-Mar-05 aaagarwa Modified the cursor c_esi --
1308: -- 1.4 10-Apr-05 abhjain NULLed out the procedure --
1309: --------------------------------------------------------------------------
1310: PROCEDURE check_esi_update

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

1374:
1375: BEGIN
1376: g_debug := hr_utility.debug_enabled;
1377: l_procedure := g_package ||'in_reset_input_values';
1378: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1379:
1380:
1381: IF g_debug THEN
1382: pay_in_utils.trace('**************************************************','********************');

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

1378: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1379:
1380:
1381: IF g_debug THEN
1382: pay_in_utils.trace('**************************************************','********************');
1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));

Line 1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));

1379:
1380:
1381: IF g_debug THEN
1382: pay_in_utils.trace('**************************************************','********************');
1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));

Line 1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));

1380:
1381: IF g_debug THEN
1382: pay_in_utils.trace('**************************************************','********************');
1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1388: pay_in_utils.trace('p_input_value ',p_input_value);

Line 1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));

1381: IF g_debug THEN
1382: pay_in_utils.trace('**************************************************','********************');
1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1388: pay_in_utils.trace('p_input_value ',p_input_value);
1389: pay_in_utils.trace('**************************************************','********************');

Line 1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));

1382: pay_in_utils.trace('**************************************************','********************');
1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1388: pay_in_utils.trace('p_input_value ',p_input_value);
1389: pay_in_utils.trace('**************************************************','********************');
1390: END IF;

Line 1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));

1383: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id ));
1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1388: pay_in_utils.trace('p_input_value ',p_input_value);
1389: pay_in_utils.trace('**************************************************','********************');
1390: END IF;
1391:

Line 1388: pay_in_utils.trace('p_input_value ',p_input_value);

1384: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1388: pay_in_utils.trace('p_input_value ',p_input_value);
1389: pay_in_utils.trace('**************************************************','********************');
1390: END IF;
1391:
1392: OPEN c_ovn;

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

1385: pay_in_utils.trace('p_element_type_id ',to_char(p_element_type_id ));
1386: pay_in_utils.trace('p_element_entry_id ',to_char(p_element_entry_id ));
1387: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1388: pay_in_utils.trace('p_input_value ',p_input_value);
1389: pay_in_utils.trace('**************************************************','********************');
1390: END IF;
1391:
1392: OPEN c_ovn;
1393: FETCH c_ovn INTO l_ovn;

Line 1414: pay_in_utils.trace('1','1');

1410: ,p_update_warning => l_warning
1411: );
1412:
1413: IF g_debug THEN
1414: pay_in_utils.trace('1','1');
1415: END IF;
1416:
1417: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1418:

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

1413: IF g_debug THEN
1414: pay_in_utils.trace('1','1');
1415: END IF;
1416:
1417: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1418:
1419: RETURN 1;
1420: EXCEPTION
1421: When OTHERS THEN

Line 1424: pay_in_utils.trace('0','0');

1420: EXCEPTION
1421: When OTHERS THEN
1422: BEGIN
1423: IF g_debug THEN
1424: pay_in_utils.trace('0','0');
1425: END IF;
1426:
1427: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1428:

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

1423: IF g_debug THEN
1424: pay_in_utils.trace('0','0');
1425: END IF;
1426:
1427: pay_in_utils.set_location(g_debug,'LEAVING: '||l_procedure,20);
1428:
1429: RETURN 0;
1430: END;
1431: END in_reset_input_values;

Line 1450: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

1446: PROCEDURE check_pf_location
1447: (p_organization_id IN NUMBER
1448: ,p_calling_procedure IN VARCHAR2
1449: ,p_message_name OUT NOCOPY VARCHAR2
1450: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
1451: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
1452: IS
1453: l_procedure VARCHAR2(100);
1454:

Line 1451: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

1447: (p_organization_id IN NUMBER
1448: ,p_calling_procedure IN VARCHAR2
1449: ,p_message_name OUT NOCOPY VARCHAR2
1450: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
1451: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
1452: IS
1453: l_procedure VARCHAR2(100);
1454:
1455: CURSOR csr_loc IS

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

1461:
1462: BEGIN
1463: g_debug := hr_utility.debug_enabled;
1464: l_procedure := g_package ||'check_pf_location';
1465: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1466:
1467: p_message_name := 'SUCCESS';
1468: pay_in_utils.null_message(p_token_name, p_token_value);
1469:

Line 1468: pay_in_utils.null_message(p_token_name, p_token_value);

1464: l_procedure := g_package ||'check_pf_location';
1465: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1466:
1467: p_message_name := 'SUCCESS';
1468: pay_in_utils.null_message(p_token_name, p_token_value);
1469:
1470:
1471: IF g_debug THEN
1472: pay_in_utils.trace('**************************************************','********************');

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

1468: pay_in_utils.null_message(p_token_name, p_token_value);
1469:
1470:
1471: IF g_debug THEN
1472: pay_in_utils.trace('**************************************************','********************');
1473: pay_in_utils.trace('p_organization_id ',to_char(p_organization_id));
1474: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
1475: pay_in_utils.trace('**************************************************','********************');
1476: END IF;

Line 1473: pay_in_utils.trace('p_organization_id ',to_char(p_organization_id));

1469:
1470:
1471: IF g_debug THEN
1472: pay_in_utils.trace('**************************************************','********************');
1473: pay_in_utils.trace('p_organization_id ',to_char(p_organization_id));
1474: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
1475: pay_in_utils.trace('**************************************************','********************');
1476: END IF;
1477:

Line 1474: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);

1470:
1471: IF g_debug THEN
1472: pay_in_utils.trace('**************************************************','********************');
1473: pay_in_utils.trace('p_organization_id ',to_char(p_organization_id));
1474: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
1475: pay_in_utils.trace('**************************************************','********************');
1476: END IF;
1477:
1478: OPEN csr_loc ;

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

1471: IF g_debug THEN
1472: pay_in_utils.trace('**************************************************','********************');
1473: pay_in_utils.trace('p_organization_id ',to_char(p_organization_id));
1474: pay_in_utils.trace('p_calling_procedure',p_calling_procedure);
1475: pay_in_utils.trace('**************************************************','********************');
1476: END IF;
1477:
1478: OPEN csr_loc ;
1479: FETCH csr_loc

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

1477:
1478: OPEN csr_loc ;
1479: FETCH csr_loc
1480: INTO l_location_id;
1481: pay_in_utils.set_location(g_debug,l_procedure,20);
1482:
1483: IF l_location_id IS NULL THEN
1484: CLOSE csr_loc;
1485: pay_in_utils.set_location(g_debug,l_procedure,30);

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

1481: pay_in_utils.set_location(g_debug,l_procedure,20);
1482:
1483: IF l_location_id IS NULL THEN
1484: CLOSE csr_loc;
1485: pay_in_utils.set_location(g_debug,l_procedure,30);
1486: p_message_name := 'PER_IN_NO_STATE_ENTERED';
1487: RETURN;
1488: END IF;
1489: CLOSE csr_loc;

Line 1492: pay_in_utils.trace('p_message_name ',p_message_name );

1488: END IF;
1489: CLOSE csr_loc;
1490:
1491: IF g_debug THEN
1492: pay_in_utils.trace('p_message_name ',p_message_name );
1493: END IF;
1494: pay_in_utils.set_location(g_debug,l_procedure,40);
1495: RETURN;
1496:

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

1490:
1491: IF g_debug THEN
1492: pay_in_utils.trace('p_message_name ',p_message_name );
1493: END IF;
1494: pay_in_utils.set_location(g_debug,l_procedure,40);
1495: RETURN;
1496:
1497: EXCEPTION
1498: WHEN OTHERS THEN

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

1538: l_procedure VARCHAR2(100);
1539: BEGIN
1540: l_procedure := g_package||'get_lwf_state';
1541: g_debug := hr_utility.debug_enabled;
1542: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1543: OPEN csr_state ;
1544: FETCH csr_state INTO l_state;
1545: pay_in_utils.set_location (g_debug,'l_state = '||l_state,20);
1546: CLOSE csr_state;

Line 1545: pay_in_utils.set_location (g_debug,'l_state = '||l_state,20);

1541: g_debug := hr_utility.debug_enabled;
1542: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1543: OPEN csr_state ;
1544: FETCH csr_state INTO l_state;
1545: pay_in_utils.set_location (g_debug,'l_state = '||l_state,20);
1546: CLOSE csr_state;
1547: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1548: RETURN l_state;
1549: EXCEPTION

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

1543: OPEN csr_state ;
1544: FETCH csr_state INTO l_state;
1545: pay_in_utils.set_location (g_debug,'l_state = '||l_state,20);
1546: CLOSE csr_state;
1547: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1548: RETURN l_state;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

Line 1551: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

1547: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1548: RETURN l_state;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1552: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 40);
1553: hr_utility.trace(l_message);
1554: RETURN NULL;
1555: END get_lwf_state;

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

1548: RETURN l_state;
1549: EXCEPTION
1550: WHEN OTHERS THEN
1551: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1552: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 40);
1553: hr_utility.trace(l_message);
1554: RETURN NULL;
1555: END get_lwf_state;
1556:

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

1601: BEGIN
1602:
1603: l_procedure := g_package||'get_org_id';
1604: g_debug := hr_utility.debug_enabled;
1605: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1606:
1607: IF g_debug THEN
1608: pay_in_utils.trace('**************************************************','********************');
1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));

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

1604: g_debug := hr_utility.debug_enabled;
1605: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1606:
1607: IF g_debug THEN
1608: pay_in_utils.trace('**************************************************','********************');
1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1612: pay_in_utils.trace('p_org_type ',p_org_type );

Line 1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));

1605: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
1606:
1607: IF g_debug THEN
1608: pay_in_utils.trace('**************************************************','********************');
1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1612: pay_in_utils.trace('p_org_type ',p_org_type );
1613: pay_in_utils.trace('**************************************************','********************');

Line 1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));

1606:
1607: IF g_debug THEN
1608: pay_in_utils.trace('**************************************************','********************');
1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1612: pay_in_utils.trace('p_org_type ',p_org_type );
1613: pay_in_utils.trace('**************************************************','********************');
1614: END IF;

Line 1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));

1607: IF g_debug THEN
1608: pay_in_utils.trace('**************************************************','********************');
1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1612: pay_in_utils.trace('p_org_type ',p_org_type );
1613: pay_in_utils.trace('**************************************************','********************');
1614: END IF;
1615:

Line 1612: pay_in_utils.trace('p_org_type ',p_org_type );

1608: pay_in_utils.trace('**************************************************','********************');
1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1612: pay_in_utils.trace('p_org_type ',p_org_type );
1613: pay_in_utils.trace('**************************************************','********************');
1614: END IF;
1615:
1616: OPEN cur_org (p_assignment_id

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

1609: pay_in_utils.trace('p_assignment_id ',to_char(p_assignment_id));
1610: pay_in_utils.trace('p_business_group_id',to_char(p_business_group_id));
1611: pay_in_utils.trace('p_date ',to_char(p_date,'yyyy-mm-dd'));
1612: pay_in_utils.trace('p_org_type ',p_org_type );
1613: pay_in_utils.trace('**************************************************','********************');
1614: END IF;
1615:
1616: OPEN cur_org (p_assignment_id
1617: ,p_business_group_id

Line 1622: pay_in_utils.set_location (g_debug,'l_segment2 = '||l_segment2,20);

1618: ,p_date);
1619: FETCH cur_org into l_segment2
1620: ,l_segment3
1621: ,l_segment4;
1622: pay_in_utils.set_location (g_debug,'l_segment2 = '||l_segment2,20);
1623: pay_in_utils.set_location (g_debug,'l_segment3 = '||l_segment3,30);
1624: pay_in_utils.set_location (g_debug,'l_segment4 = '||l_segment4,40);
1625: CLOSE cur_org;
1626:

Line 1623: pay_in_utils.set_location (g_debug,'l_segment3 = '||l_segment3,30);

1619: FETCH cur_org into l_segment2
1620: ,l_segment3
1621: ,l_segment4;
1622: pay_in_utils.set_location (g_debug,'l_segment2 = '||l_segment2,20);
1623: pay_in_utils.set_location (g_debug,'l_segment3 = '||l_segment3,30);
1624: pay_in_utils.set_location (g_debug,'l_segment4 = '||l_segment4,40);
1625: CLOSE cur_org;
1626:
1627: IF p_org_type = 'PF' THEN

Line 1624: pay_in_utils.set_location (g_debug,'l_segment4 = '||l_segment4,40);

1620: ,l_segment3
1621: ,l_segment4;
1622: pay_in_utils.set_location (g_debug,'l_segment2 = '||l_segment2,20);
1623: pay_in_utils.set_location (g_debug,'l_segment3 = '||l_segment3,30);
1624: pay_in_utils.set_location (g_debug,'l_segment4 = '||l_segment4,40);
1625: CLOSE cur_org;
1626:
1627: IF p_org_type = 'PF' THEN
1628: return to_number(l_segment2);

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

1631: ELSIF p_org_type = 'ESI' THEN
1632: return to_number(l_segment4);
1633: END IF;
1634:
1635: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

Line 1639: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);

1635: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1640: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 30);
1641: hr_utility.trace(l_message);
1642: RETURN NULL;
1643:

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

1636:
1637: EXCEPTION
1638: WHEN OTHERS THEN
1639: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1640: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 30);
1641: hr_utility.trace(l_message);
1642: RETURN NULL;
1643:
1644: