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

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

27: l_message VARCHAR2(250);
28: BEGIN
29: g_debug := hr_utility.debug_enabled;
30: l_procedure := g_package ||'get_bg_id';
31: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
32:
33: OPEN c_bg;
34: FETCH c_bg INTO l_bg;
35: CLOSE c_bg;

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

35: CLOSE c_bg;
36:
37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.trace('l_bg',l_bg);
41: pay_in_utils.trace('**************************************************','********************');
42: END IF;
43: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

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

36:
37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.trace('l_bg',l_bg);
41: pay_in_utils.trace('**************************************************','********************');
42: END IF;
43: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
44:

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

37: IF (g_debug)
38: THEN
39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.trace('l_bg',l_bg);
41: pay_in_utils.trace('**************************************************','********************');
42: END IF;
43: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
44:
45: RETURN l_bg;

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

39: pay_in_utils.trace('**************************************************','********************');
40: pay_in_utils.trace('l_bg',l_bg);
41: pay_in_utils.trace('**************************************************','********************');
42: END IF;
43: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
44:
45: RETURN l_bg;
46:
47: END get_bg_id;

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

96: FROM per_assignments_f assgn
97: , pay_element_links_f link
98: , pay_element_types_f types
99: WHERE assgn.assignment_id = p_assignment_id
100: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
101: ,P_ENTRY_DATE
102: ,types.element_type_id
103: )
104: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

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

220:
221: --hr_utility.trace_on(null,'LNAGARAJ');
222: g_debug := hr_utility.debug_enabled;
223: l_procedure := g_package ||'create_medical';
224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
225: IF (g_debug)
226: THEN
227: pay_in_utils.trace('**************************************************','********************');
228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);

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

223: l_procedure := g_package ||'create_medical';
224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
225: IF (g_debug)
226: THEN
227: pay_in_utils.trace('**************************************************','********************');
228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));

Line 228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);

224: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
225: IF (g_debug)
226: THEN
227: pay_in_utils.trace('**************************************************','********************');
228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));

Line 229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));

225: IF (g_debug)
226: THEN
227: pay_in_utils.trace('**************************************************','********************');
228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

Line 230: pay_in_utils.trace('p_month',TO_CHAR (p_month));

226: THEN
227: pay_in_utils.trace('**************************************************','********************');
228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));

Line 231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));

227: pay_in_utils.trace('**************************************************','********************');
228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));

Line 232: pay_in_utils.trace('p_name',TO_CHAR (p_name));

228: pay_in_utils.set_location(g_debug,'Input Paramters values are',20);
229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));

Line 233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));

229: pay_in_utils.trace('p_tax_year',TO_CHAR (p_tax_year));
230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));

Line 234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));

230: pay_in_utils.trace('p_month',TO_CHAR (p_month));
231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

Line 235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));

231: pay_in_utils.trace('p_bill_date',TO_CHAR (p_bill_date));
232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));

Line 236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));

232: pay_in_utils.trace('p_name',TO_CHAR (p_name));
233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

Line 237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));

233: pay_in_utils.trace('p_bill_number',TO_CHAR (p_bill_number));
234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));

Line 238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));

234: pay_in_utils.trace('p_bill_amount',TO_CHAR (p_bill_amount));
235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));

Line 239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));

235: pay_in_utils.trace('p_approved_bill_amount',TO_CHAR (p_approved_bill_amount));
236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));
243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));

Line 240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

236: pay_in_utils.trace('p_employee_remarks',TO_CHAR (p_employee_remarks));
237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));
243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));
244: pay_in_utils.trace('p_entry_date',TO_CHAR(p_entry_date));

Line 241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));

237: pay_in_utils.trace('p_employer_remarks',TO_CHAR (p_employer_remarks));
238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));
243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));
244: pay_in_utils.trace('p_entry_date',TO_CHAR(p_entry_date));
245:

Line 242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));

238: pay_in_utils.trace('p_element_entry_id',TO_CHAR (p_element_entry_id));
239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));
243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));
244: pay_in_utils.trace('p_entry_date',TO_CHAR(p_entry_date));
245:
246:

Line 243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));

239: pay_in_utils.trace('p_last_updated_date',TO_CHAR (p_last_updated_date));
240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));
243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));
244: pay_in_utils.trace('p_entry_date',TO_CHAR(p_entry_date));
245:
246:
247: END IF;

Line 244: pay_in_utils.trace('p_entry_date',TO_CHAR(p_entry_date));

240: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
241: pay_in_utils.trace('p_employee_id',TO_CHAR (p_employee_id));
242: pay_in_utils.trace('p_employee_name',TO_CHAR (p_employee_name));
243: pay_in_utils.trace('p_assignment_extra_info_id',TO_CHAR (p_assignment_extra_info_id));
244: pay_in_utils.trace('p_entry_date',TO_CHAR(p_entry_date));
245:
246:
247: END IF;
248:

Line 264: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));

260: l_business_group_id := get_bg_id();
261:
262: IF (g_debug)
263: THEN
264: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
265: END IF;
266:
267: IF ((p_element_entry_id IS NOT NULL))
268: THEN

Line 270: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);

266:
267: IF ((p_element_entry_id IS NOT NULL))
268: THEN
269:
270: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
271:
272: /*Code to change the Medical Bill Entry if the approved amount of a existing medical
273: bill has been changed.*/
274:

Line 300: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));

296: l_input_values_rec(l_count).value := c_rec.value;
297:
298: IF (g_debug)
299: THEN
300: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));
301: pay_in_utils.trace('l_input_values_rec(1).input_value_id',TO_CHAR (l_input_values_rec(1).input_value_id));
302: END IF;
303:
304: l_count := l_count + 1;

Line 301: pay_in_utils.trace('l_input_values_rec(1).input_value_id',TO_CHAR (l_input_values_rec(1).input_value_id));

297:
298: IF (g_debug)
299: THEN
300: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));
301: pay_in_utils.trace('l_input_values_rec(1).input_value_id',TO_CHAR (l_input_values_rec(1).input_value_id));
302: END IF;
303:
304: l_count := l_count + 1;
305: END LOOP;

Line 316: pay_in_utils.trace('l_entry_information1',TO_CHAR (l_entry_information1));

312: CLOSE c_get_screen_value ;
313:
314: IF (g_debug)
315: THEN
316: pay_in_utils.trace('l_entry_information1',TO_CHAR (l_entry_information1));
317: END IF;
318:
319:
320:

Line 323: pay_in_utils.trace('l_prev_bill_amount',TO_CHAR (l_prev_bill_amount));

319:
320:
321: IF (g_debug)
322: THEN
323: pay_in_utils.trace('l_prev_bill_amount',TO_CHAR (l_prev_bill_amount));
324: END IF;
325:
326:
327:

Line 372: pay_in_utils.trace('Benefit Input Value Name:'||l_count,TO_CHAR (c_rec.name));

368: l_ben_input_values_rec(l_count).value := c_rec.value;
369:
370: IF (g_debug)
371: THEN
372: pay_in_utils.trace('Benefit Input Value Name:'||l_count,TO_CHAR (c_rec.name));
373: END IF;
374:
375: l_count := l_count + 1;
376: END LOOP;

Line 393: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));

389: CLOSE c_get_screen_value ;
390:
391: IF (g_debug)
392: THEN
393: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
394: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
395: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));
396: END IF;
397:

Line 394: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));

390:
391: IF (g_debug)
392: THEN
393: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
394: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
395: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));
396: END IF;
397:
398:

Line 395: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));

391: IF (g_debug)
392: THEN
393: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
394: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
395: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));
396: END IF;
397:
398:
399: l_approved_bill_amount := NVL(p_approved_bill_amount,0) + NVL(l_entry_information3,0) - NVL(l_prev_bill_amount,0);

Line 446: pay_in_utils.trace('l_medical_bill_element',TO_CHAR (l_medical_bill_element));

442: CLOSE c_element_name ;
443:
444: IF (g_debug)
445: THEN
446: pay_in_utils.trace('l_medical_bill_element',TO_CHAR (l_medical_bill_element));
447: pay_in_utils.trace('l_medical_ben_element ',TO_CHAR (l_medical_ben_element));
448: END IF;
449:
450: OPEN csr_element_details(p_assignment_id, P_ENTRY_DATE, l_medical_bill_element) ;

Line 447: pay_in_utils.trace('l_medical_ben_element ',TO_CHAR (l_medical_ben_element));

443:
444: IF (g_debug)
445: THEN
446: pay_in_utils.trace('l_medical_bill_element',TO_CHAR (l_medical_bill_element));
447: pay_in_utils.trace('l_medical_ben_element ',TO_CHAR (l_medical_ben_element));
448: END IF;
449:
450: OPEN csr_element_details(p_assignment_id, P_ENTRY_DATE, l_medical_bill_element) ;
451: FETCH csr_element_details INTO l_bill_element_type_id, l_bill_element_link_id ;

Line 461: pay_in_utils.trace('l_bill_element_type_id',TO_CHAR (l_bill_element_type_id));

457:
458:
459: IF (g_debug)
460: THEN
461: pay_in_utils.trace('l_bill_element_type_id',TO_CHAR (l_bill_element_type_id));
462: pay_in_utils.trace('l_bill_element_link_id',TO_CHAR (l_bill_element_link_id));
463: pay_in_utils.trace('l_ben_element_type_id ',TO_CHAR (l_ben_element_type_id));
464: pay_in_utils.trace('l_ben_element_link_id ',TO_CHAR (l_ben_element_link_id));
465: END IF;

Line 462: pay_in_utils.trace('l_bill_element_link_id',TO_CHAR (l_bill_element_link_id));

458:
459: IF (g_debug)
460: THEN
461: pay_in_utils.trace('l_bill_element_type_id',TO_CHAR (l_bill_element_type_id));
462: pay_in_utils.trace('l_bill_element_link_id',TO_CHAR (l_bill_element_link_id));
463: pay_in_utils.trace('l_ben_element_type_id ',TO_CHAR (l_ben_element_type_id));
464: pay_in_utils.trace('l_ben_element_link_id ',TO_CHAR (l_ben_element_link_id));
465: END IF;
466:

Line 463: pay_in_utils.trace('l_ben_element_type_id ',TO_CHAR (l_ben_element_type_id));

459: IF (g_debug)
460: THEN
461: pay_in_utils.trace('l_bill_element_type_id',TO_CHAR (l_bill_element_type_id));
462: pay_in_utils.trace('l_bill_element_link_id',TO_CHAR (l_bill_element_link_id));
463: pay_in_utils.trace('l_ben_element_type_id ',TO_CHAR (l_ben_element_type_id));
464: pay_in_utils.trace('l_ben_element_link_id ',TO_CHAR (l_ben_element_link_id));
465: END IF;
466:
467: OPEN c_check_element_entry(l_bill_element_type_id, P_ENTRY_DATE);

Line 464: pay_in_utils.trace('l_ben_element_link_id ',TO_CHAR (l_ben_element_link_id));

460: THEN
461: pay_in_utils.trace('l_bill_element_type_id',TO_CHAR (l_bill_element_type_id));
462: pay_in_utils.trace('l_bill_element_link_id',TO_CHAR (l_bill_element_link_id));
463: pay_in_utils.trace('l_ben_element_type_id ',TO_CHAR (l_ben_element_type_id));
464: pay_in_utils.trace('l_ben_element_link_id ',TO_CHAR (l_ben_element_link_id));
465: END IF;
466:
467: OPEN c_check_element_entry(l_bill_element_type_id, P_ENTRY_DATE);
468: FETCH c_check_element_entry INTO l_element_entry_id ;

Line 473: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);

469: CLOSE c_check_element_entry ;
470:
471: IF l_element_entry_id IS NOT NULL THEN
472:
473: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);
474:
475: /*Code to change the Medical Bill Entry if an additional bill has been approved.*/
476: OPEN c_get_ele_object_version(l_element_entry_id) ;
477: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;

Line 490: pay_in_utils.trace('Bill'||l_count,TO_CHAR (c_rec.name));

486: l_input_values_rec(l_count).value := c_rec.value;
487:
488: IF (g_debug)
489: THEN
490: pay_in_utils.trace('Bill'||l_count,TO_CHAR (c_rec.name));
491: END IF;
492:
493: l_count := l_count + 1;
494: END LOOP;

Line 504: pay_in_utils.trace('l_entry_information1',TO_CHAR (l_entry_information1));

500: CLOSE c_get_screen_value ;
501:
502: IF (g_debug)
503: THEN
504: pay_in_utils.trace('l_entry_information1',TO_CHAR (l_entry_information1));
505: END IF;
506:
507:
508: l_approved_bill_amount := NVL(p_approved_bill_amount,0) + NVL(l_entry_information1,0) ;

Line 551: pay_in_utils.trace('Benefit Input Value Name:'||l_count,TO_CHAR (c_rec.name));

547: l_ben_input_values_rec(l_count).value := c_rec.value;
548:
549: IF (g_debug)
550: THEN
551: pay_in_utils.trace('Benefit Input Value Name:'||l_count,TO_CHAR (c_rec.name));
552: END IF;
553:
554: l_count := l_count + 1;
555: END LOOP;

Line 573: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));

569:
570:
571: IF (g_debug)
572: THEN
573: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
574: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
575: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));
576: END IF;
577:

Line 574: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));

570:
571: IF (g_debug)
572: THEN
573: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
574: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
575: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));
576: END IF;
577:
578:

Line 575: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));

571: IF (g_debug)
572: THEN
573: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
574: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
575: pay_in_utils.trace('l_entry_information7',TO_CHAR (l_entry_information7));
576: END IF;
577:
578:
579: l_approved_bill_amount := NVL(p_approved_bill_amount,0) + NVL(l_entry_information3,0) ;

Line 652: pay_in_utils.trace('Bill Input Value Name:'||l_count,TO_CHAR (c_rec.name));

648: l_input_values_rec(l_count).value := c_rec.value;
649:
650: IF (g_debug)
651: THEN
652: pay_in_utils.trace('Bill Input Value Name:'||l_count,TO_CHAR (c_rec.name));
653: END IF;
654:
655: l_count := l_count + 1;
656: END LOOP;

Line 667: pay_in_utils.trace('Benefit Input Value Name:'||l_count,TO_CHAR (c_rec.name));

663: l_ben_input_values_rec(l_count).value := c_rec.value;
664:
665: IF (g_debug)
666: THEN
667: pay_in_utils.trace('Benefit Input Value Name:'||l_count,TO_CHAR (c_rec.name));
668: END IF;
669:
670: l_count := l_count + 1;
671: END LOOP;

Line 678: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);

674:
675:
676:
677:
678: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);
679:
680: IF(p_approved_bill_amount IS NOT NULL) THEN
681: pay_element_entry_api.create_element_entry
682: (p_effective_date => p_entry_date

Line 712: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);

708: ,p_object_version_number => l_object_version_no
709: ,p_create_warning => l_warnings
710: );
711: END IF;
712: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);
713:
714:
715: pay_in_utils.set_location(g_debug,'Creating Benefit Bill Element Entries: '||l_procedure,70);
716:

Line 715: pay_in_utils.set_location(g_debug,'Creating Benefit Bill Element Entries: '||l_procedure,70);

711: END IF;
712: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);
713:
714:
715: pay_in_utils.set_location(g_debug,'Creating Benefit Bill Element Entries: '||l_procedure,70);
716:
717: IF(p_approved_bill_amount IS NOT NULL) THEN
718: pay_element_entry_api.create_element_entry
719: (p_effective_date => p_entry_date

Line 736: pay_in_utils.set_location(g_debug,'Benefit Bill Element Creation Completed'||l_procedure,80);

732: ,p_create_warning => l_warnings
733: );
734: END IF;
735:
736: pay_in_utils.set_location(g_debug,'Benefit Bill Element Creation Completed'||l_procedure,80);
737:
738: END IF ;
739: END IF;
740:

Line 742: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,90);

738: END IF ;
739: END IF;
740:
741:
742: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,90);
743:
744:
745:
746:

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

751: ,AEI_INFORMATION11 = l_ben_entry_id
752: WHERE ASSIGNMENT_EXTRA_INFO_ID = p_assignment_extra_info_id ;
753:
754:
755: pay_in_utils.trace('**************************************************','********************');
756: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,100);
757: END create_medical;
758:
759:

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

752: WHERE ASSIGNMENT_EXTRA_INFO_ID = p_assignment_extra_info_id ;
753:
754:
755: pay_in_utils.trace('**************************************************','********************');
756: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,100);
757: END create_medical;
758:
759:
760: --------------------------------------------------------------------------

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

837:
838:
839: g_debug := hr_utility.debug_enabled;
840: l_procedure := g_package ||'create_medical_ben';
841: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
842: IF (g_debug)
843: THEN
844: pay_in_utils.trace('**************************************************','********************');
845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

840: l_procedure := g_package ||'create_medical_ben';
841: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
842: IF (g_debug)
843: THEN
844: pay_in_utils.trace('**************************************************','********************');
845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));

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

841: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
842: IF (g_debug)
843: THEN
844: pay_in_utils.trace('**************************************************','********************');
845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));

Line 846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));

842: IF (g_debug)
843: THEN
844: pay_in_utils.trace('**************************************************','********************');
845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));

Line 847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));

843: THEN
844: pay_in_utils.trace('**************************************************','********************');
845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));

Line 848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));

844: pay_in_utils.trace('**************************************************','********************');
845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));

Line 849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));

845: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));
853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));

Line 850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));

846: pay_in_utils.trace('P_employee_number',TO_CHAR (P_employee_number));
847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));
853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));
854: pay_in_utils.trace('P_element_entry_id',TO_CHAR (P_element_entry_id));

Line 851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));

847: pay_in_utils.trace('P_full_name',TO_CHAR (P_full_name));
848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));
853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));
854: pay_in_utils.trace('P_element_entry_id',TO_CHAR (P_element_entry_id));
855:

Line 852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));

848: pay_in_utils.trace('P_effective_start_date',TO_CHAR (P_effective_start_date));
849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));
853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));
854: pay_in_utils.trace('P_element_entry_id',TO_CHAR (P_element_entry_id));
855:
856:

Line 853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));

849: pay_in_utils.trace('P_effective_end_date',TO_CHAR (P_effective_end_date));
850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));
853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));
854: pay_in_utils.trace('P_element_entry_id',TO_CHAR (P_element_entry_id));
855:
856:
857: END IF;

Line 854: pay_in_utils.trace('P_element_entry_id',TO_CHAR (P_element_entry_id));

850: pay_in_utils.trace('P_Benefit',TO_CHAR (P_Benefit));
851: pay_in_utils.trace('P_Add_to_NetPay',TO_CHAR (P_Add_to_NetPay));
852: pay_in_utils.trace('P_AnnualLimit',TO_CHAR (P_AnnualLimit));
853: pay_in_utils.trace('P_assignment_id',TO_CHAR (P_assignment_id));
854: pay_in_utils.trace('P_element_entry_id',TO_CHAR (P_element_entry_id));
855:
856:
857: END IF;
858:

Line 870: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));

866: l_business_group_id := get_bg_id();
867:
868: IF (g_debug)
869: THEN
870: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));
871: END IF;
872:
873:
874: IF ((p_element_entry_id IS NOT NULL))

Line 877: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);

873:
874: IF ((p_element_entry_id IS NOT NULL))
875: THEN
876:
877: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
878:
879: OPEN c_get_ele_object_version(p_element_entry_id) ;
880: FETCH c_get_ele_object_version INTO l_object_version_no ;
881: CLOSE c_get_ele_object_version ;

Line 896: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));

892: l_input_values_rec(l_count).value := c_rec.value;
893:
894: IF (g_debug)
895: THEN
896: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
897: END IF;
898:
899: l_count := l_count + 1;
900: END LOOP;

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

934:
935: END IF ;
936:
937:
938: pay_in_utils.trace('**************************************************','********************');
939: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
940:
941:
942:

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

935: END IF ;
936:
937:
938: pay_in_utils.trace('**************************************************','********************');
939: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
940:
941:
942:
943:

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

998: FROM per_assignments_f assgn
999: , pay_element_links_f link
1000: , pay_element_types_f types
1001: WHERE assgn.assignment_id = p_assignment_id
1002: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id
1003: ,P_ENTRY_DATE
1004: ,types.element_type_id
1005: )
1006: AND (types.processing_type = 'R' OR assgn.payroll_id IS NOT NULL)

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

1118: BEGIN
1119: --hr_utility.trace_on (null, 'ORACLE1234');
1120: g_debug := hr_utility.debug_enabled;
1121: l_procedure := g_package ||'create_ltc_element';
1122: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1123: IF (g_debug)
1124: THEN
1125: pay_in_utils.trace('**************************************************','********************');
1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

1121: l_procedure := g_package ||'create_ltc_element';
1122: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1123: IF (g_debug)
1124: THEN
1125: pay_in_utils.trace('**************************************************','********************');
1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));

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

1122: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1123: IF (g_debug)
1124: THEN
1125: pay_in_utils.trace('**************************************************','********************');
1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));

Line 1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));

1123: IF (g_debug)
1124: THEN
1125: pay_in_utils.trace('**************************************************','********************');
1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));

Line 1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));

1124: THEN
1125: pay_in_utils.trace('**************************************************','********************');
1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));

Line 1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));

1125: pay_in_utils.trace('**************************************************','********************');
1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));

Line 1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));

1126: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));

Line 1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));

1127: pay_in_utils.trace('P_LTCBLOCK',TO_CHAR (P_LTCBLOCK));
1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));

Line 1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));

1128: pay_in_utils.trace('P_PLACE_FROM',TO_CHAR (P_PLACE_FROM));
1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));

Line 1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));

1129: pay_in_utils.trace('P_PLACE_TO',TO_CHAR (P_PLACE_TO));
1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));

Line 1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));

1130: pay_in_utils.trace('P_MODE_CLASS',TO_CHAR (P_MODE_CLASS));
1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));

Line 1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));

1131: pay_in_utils.trace('P_CARRY_OVER',TO_CHAR (P_CARRY_OVER));
1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));

Line 1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));

1132: pay_in_utils.trace('P_SUBMITTED',TO_CHAR (P_SUBMITTED));
1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));

Line 1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));

1133: pay_in_utils.trace('P_EXEMPTED',TO_CHAR (P_EXEMPTED));
1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));

Line 1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));

1134: pay_in_utils.trace('P_ELEMENT_ENTRY_ID',TO_CHAR (P_ELEMENT_ENTRY_ID));
1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));

Line 1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));

1135: pay_in_utils.trace('P_START_DATE',TO_CHAR (P_START_DATE));
1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));

Line 1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));

1136: pay_in_utils.trace('P_END_DATE',TO_CHAR (P_END_DATE));
1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));
1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));

Line 1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));

1137: pay_in_utils.trace('P_BILL_NUM',TO_CHAR (P_BILL_NUM));
1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));
1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
1145: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));

Line 1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));

1138: pay_in_utils.trace('P_EE_COMMENTS',TO_CHAR (P_EE_COMMENTS));
1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));
1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
1145: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
1146:

Line 1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));

1139: pay_in_utils.trace('P_ER_COMMENTS',TO_CHAR (P_ER_COMMENTS));
1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));
1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
1145: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
1146:
1147:

Line 1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));

1140: pay_in_utils.trace('P_LAST_UPDATED_DATE',TO_CHAR (P_LAST_UPDATED_DATE));
1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));
1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
1145: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
1146:
1147:
1148: END IF;

Line 1145: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));

1141: pay_in_utils.trace('P_ASSIGNMENT_ID',TO_CHAR (P_ASSIGNMENT_ID));
1142: pay_in_utils.trace('P_EMPLOYEE_ID',TO_CHAR (P_EMPLOYEE_ID));
1143: pay_in_utils.trace('P_BENEFIT',TO_CHAR (P_BENEFIT));
1144: pay_in_utils.trace('P_ASSIGNMENT_EXTRA_INFO_ID ',TO_CHAR (P_ASSIGNMENT_EXTRA_INFO_ID));
1145: pay_in_utils.trace('P_ENTRY_DATE ',TO_CHAR (P_ENTRY_DATE));
1146:
1147:
1148: END IF;
1149:

Line 1165: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));

1161: l_business_group_id := get_bg_id();
1162:
1163: IF (g_debug)
1164: THEN
1165: pay_in_utils.trace('l_business_group_id',TO_CHAR (l_business_group_id));
1166: END IF;
1167:
1168: BEGIN
1169: SELECT 1 INTO l_session FROM fnd_sessions WHERE SESSION_ID = USERENV('SESSIONID') AND ROWNUM=1;

Line 1179: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);

1175:
1176: IF ((p_element_entry_id IS NOT NULL))
1177: THEN
1178:
1179: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
1180:
1181: OPEN c_get_ele_object_version(p_element_entry_id) ;
1182: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
1183: CLOSE c_get_ele_object_version ;

Line 1198: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));

1194: l_input_values_rec(l_count).value := c_rec.value;
1195:
1196: IF (g_debug)
1197: THEN
1198: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
1199: END IF;
1200:
1201: l_count := l_count + 1;
1202: END LOOP;

Line 1211: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));

1207: CLOSE c_get_screen_value ;
1208:
1209: IF (g_debug)
1210: THEN
1211: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
1212: END IF;
1213:
1214:
1215: OPEN c_get_screen_value(p_element_entry_id, l_input_values_rec(5).input_value_id);

Line 1225: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));

1221: CLOSE c_get_prev_amts ;
1222:
1223: IF (g_debug)
1224: THEN
1225: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));
1226: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));
1227: END IF;
1228:
1229:

Line 1226: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));

1222:
1223: IF (g_debug)
1224: THEN
1225: pay_in_utils.trace('l_prev_submitted',TO_CHAR (l_prev_submitted));
1226: pay_in_utils.trace('l_prev_exempted_amount',TO_CHAR (l_prev_exempted_amount));
1227: END IF;
1228:
1229:
1230: l_submitted := NVL(P_EXEMPTED,0) + NVL(l_entry_information3,0) - NVL(l_prev_exempted_amount,0) ;

Line 1280: pay_in_utils.trace('l_ltc_element ',TO_CHAR (l_ltc_element));

1276: CLOSE c_element_name ;
1277:
1278: IF (g_debug)
1279: THEN
1280: pay_in_utils.trace('l_ltc_element ',TO_CHAR (l_ltc_element));
1281: END IF;
1282:
1283:
1284: OPEN csr_element_details(p_assignment_id, p_entry_date, l_ltc_element) ;

Line 1291: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));

1287:
1288:
1289: IF (g_debug)
1290: THEN
1291: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
1292: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
1293: END IF;
1294:
1295: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);

Line 1292: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));

1288:
1289: IF (g_debug)
1290: THEN
1291: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
1292: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
1293: END IF;
1294:
1295: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);
1296: FETCH c_check_element_entry INTO l_element_entry_id ;

Line 1301: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);

1297: CLOSE c_check_element_entry ;
1298:
1299: IF l_element_entry_id IS NOT NULL THEN
1300:
1301: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,40);
1302:
1303: OPEN c_get_ele_object_version(l_element_entry_id) ;
1304: FETCH c_get_ele_object_version INTO l_object_version_no,l_effective_start_date ;
1305: CLOSE c_get_ele_object_version ;

Line 1319: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));

1315: l_input_values_rec(l_count).value := c_rec.value;
1316:
1317: IF (g_debug)
1318: THEN
1319: pay_in_utils.trace('Input Value Name'||l_count,TO_CHAR (c_rec.name));
1320: END IF;
1321:
1322: l_count := l_count + 1;
1323: END LOOP;

Line 1331: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));

1327: CLOSE c_get_screen_value ;
1328:
1329: IF (g_debug)
1330: THEN
1331: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
1332: END IF;
1333:
1334:
1335: OPEN c_get_screen_value(l_element_entry_id, l_input_values_rec(5).input_value_id);

Line 1341: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));

1337: CLOSE c_get_screen_value ;
1338:
1339: IF (g_debug)
1340: THEN
1341: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
1342: END IF;
1343:
1344:
1345:

Line 1416: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));

1412: l_ben_input_values_rec(l_count).value := c_rec.value;
1413:
1414: IF (g_debug)
1415: THEN
1416: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));
1417: END IF;
1418:
1419: l_count := l_count + 1;
1420: END LOOP;

Line 1422: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);

1418:
1419: l_count := l_count + 1;
1420: END LOOP;
1421:
1422: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);
1423:
1424:
1425:
1426:

Line 1462: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);

1458: ,p_create_warning => l_warnings
1459: );
1460:
1461: END IF;
1462: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);
1463:
1464:
1465:
1466: END IF ;

Line 1470: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);

1466: END IF ;
1467: END IF;
1468:
1469:
1470: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
1471:
1472: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
1473:
1474: UPDATE per_assignment_extra_info

Line 1482: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,72);

1478: ,aei_information18 = P_CARRY_OVER
1479: ,AEI_INFORMATION21 = P_BENEFIT
1480: WHERE ASSIGNMENT_EXTRA_INFO_ID = p_assignment_extra_info_id ;
1481:
1482: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,72);
1483:
1484: END IF;
1485:
1486: pay_in_utils.trace('**************************************************','********************');

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

1482: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,72);
1483:
1484: END IF;
1485:
1486: pay_in_utils.trace('**************************************************','********************');
1487: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1488: END create_ltc_element;
1489:
1490:

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

1483:
1484: END IF;
1485:
1486: pay_in_utils.trace('**************************************************','********************');
1487: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1488: END create_ltc_element;
1489:
1490:
1491: --------------------------------------------------------------------------

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

1576:
1577: --hr_utility.trace_on (null, 'ORACLE1212');
1578: g_debug := hr_utility.debug_enabled;
1579: l_procedure := g_package ||'update_ltc_element';
1580: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1581: IF (g_debug)
1582: THEN
1583: pay_in_utils.trace('**************************************************','********************');
1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

1579: l_procedure := g_package ||'update_ltc_element';
1580: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1581: IF (g_debug)
1582: THEN
1583: pay_in_utils.trace('**************************************************','********************');
1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

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

1580: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1581: IF (g_debug)
1582: THEN
1583: pay_in_utils.trace('**************************************************','********************');
1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));

Line 1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));

1581: IF (g_debug)
1582: THEN
1583: pay_in_utils.trace('**************************************************','********************');
1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));

Line 1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));

1582: THEN
1583: pay_in_utils.trace('**************************************************','********************');
1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));

Line 1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

1583: pay_in_utils.trace('**************************************************','********************');
1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));

Line 1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));

1584: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));

Line 1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));

1585: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

Line 1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));

1586: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1594: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));

Line 1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));

1587: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1594: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1595:

Line 1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));

1588: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1594: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1595:
1596: END IF;

Line 1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

1589: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1594: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1595:
1596: END IF;
1597:

Line 1594: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));

1590: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1591: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1592: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1593: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1594: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1595:
1596: END IF;
1597:
1598: IF p_fare < 0 THEN

Line 1621: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));

1617: l_business_group_id := get_bg_id();
1618:
1619: IF (g_debug)
1620: THEN
1621: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));
1622: END IF;
1623:
1624:
1625: IF ((p_element_entry_id IS NOT NULL))

Line 1628: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);

1624:
1625: IF ((p_element_entry_id IS NOT NULL))
1626: THEN
1627:
1628: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
1629:
1630: OPEN c_get_ele_object_version(p_element_entry_id) ;
1631: FETCH c_get_ele_object_version INTO l_object_version_no ;
1632: CLOSE c_get_ele_object_version ;

Line 1647: pay_in_utils.trace('Input Values Name:'||l_count,TO_CHAR (c_rec.name));

1643: l_input_values_rec(l_count).value := c_rec.value;
1644:
1645: IF (g_debug)
1646: THEN
1647: pay_in_utils.trace('Input Values Name:'||l_count,TO_CHAR (c_rec.name));
1648: END IF;
1649:
1650: l_count := l_count + 1;
1651: END LOOP;

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

1689: ,AEI_INFORMATION21 = P_BENEFIT
1690: where AEI_INFORMATION11 = p_element_entry_id
1691: and assignment_id = p_assignment_id;
1692:
1693: pay_in_utils.trace('**************************************************','********************');
1694: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1695:
1696:
1697:

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

1690: where AEI_INFORMATION11 = p_element_entry_id
1691: and assignment_id = p_assignment_id;
1692:
1693: pay_in_utils.trace('**************************************************','********************');
1694: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1695:
1696:
1697:
1698: