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 1001: AND link.element_link_id = pay_in_utils.get_element_link_id(p_assignment_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1272: CLOSE c_element_name ;
1273:
1274: IF (g_debug)
1275: THEN
1276: pay_in_utils.trace('l_ltc_element ',TO_CHAR (l_ltc_element));
1277: END IF;
1278:
1279:
1280: OPEN csr_element_details(p_assignment_id, p_entry_date, l_ltc_element) ;

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

1283:
1284:
1285: IF (g_debug)
1286: THEN
1287: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
1288: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
1289: END IF;
1290:
1291: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);

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

1284:
1285: IF (g_debug)
1286: THEN
1287: pay_in_utils.trace('l_ltc_element_type_id ',TO_CHAR (l_ltc_element_type_id));
1288: pay_in_utils.trace('l_ltc_element_link_id ',TO_CHAR (l_ltc_element_link_id));
1289: END IF;
1290:
1291: OPEN c_check_element_entry(l_ltc_element_type_id, p_entry_date);
1292: FETCH c_check_element_entry INTO l_element_entry_id ;

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

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

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

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

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

1323: CLOSE c_get_screen_value ;
1324:
1325: IF (g_debug)
1326: THEN
1327: pay_in_utils.trace('l_entry_information3',TO_CHAR (l_entry_information3));
1328: END IF;
1329:
1330:
1331: OPEN c_get_screen_value(l_element_entry_id, l_input_values_rec(5).input_value_id);

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

1333: CLOSE c_get_screen_value ;
1334:
1335: IF (g_debug)
1336: THEN
1337: pay_in_utils.trace('l_entry_information5',TO_CHAR (l_entry_information5));
1338: END IF;
1339:
1340:
1341:

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

1404: l_ben_input_values_rec(l_count).value := c_rec.value;
1405:
1406: IF (g_debug)
1407: THEN
1408: pay_in_utils.trace('Input Value Name:'||l_count,TO_CHAR (c_rec.name));
1409: END IF;
1410:
1411: l_count := l_count + 1;
1412: END LOOP;

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

1410:
1411: l_count := l_count + 1;
1412: END LOOP;
1413:
1414: pay_in_utils.set_location(g_debug,'Creating Benefit Element Entries: '||l_procedure,50);
1415:
1416:
1417:
1418:

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

1450: ,p_create_warning => l_warnings
1451: );
1452:
1453: END IF;
1454: pay_in_utils.set_location(g_debug,'Benefit Element Creation Completed'||l_procedure,60);
1455:
1456:
1457:
1458: END IF ;

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

1458: END IF ;
1459: END IF;
1460:
1461:
1462: pay_in_utils.set_location(g_debug,'Updating Assignment_Extra_Info: '||l_procedure,70);
1463:
1464: IF P_EMPLOYEE_ID <> 0 THEN /* To prevent this from Self Service page and execute only for web adi*/
1465:
1466: UPDATE per_assignment_extra_info

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

1470: ,aei_information18 = P_CARRY_OVER
1471: WHERE ASSIGNMENT_EXTRA_INFO_ID = p_assignment_extra_info_id ;
1472: END IF;
1473:
1474: pay_in_utils.trace('**************************************************','********************');
1475: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1476: END create_ltc_element;
1477:
1478:

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

1471: WHERE ASSIGNMENT_EXTRA_INFO_ID = p_assignment_extra_info_id ;
1472: END IF;
1473:
1474: pay_in_utils.trace('**************************************************','********************');
1475: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,80);
1476: END create_ltc_element;
1477:
1478:
1479: --------------------------------------------------------------------------

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

1564:
1565:
1566: g_debug := hr_utility.debug_enabled;
1567: l_procedure := g_package ||'update_ltc_element';
1568: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1569: IF (g_debug)
1570: THEN
1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);

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

1567: l_procedure := g_package ||'update_ltc_element';
1568: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1569: IF (g_debug)
1570: THEN
1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));

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

1568: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1569: IF (g_debug)
1570: THEN
1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));

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

1569: IF (g_debug)
1570: THEN
1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));

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

1570: THEN
1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));

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

1571: pay_in_utils.trace('**************************************************','********************');
1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));

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

1572: pay_in_utils.set_location(g_debug,'Input Paramters value is',20);
1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));

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

1573: pay_in_utils.trace('p_employee_number',TO_CHAR (p_employee_number));
1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1581: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));

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

1574: pay_in_utils.trace('p_full_name',TO_CHAR (p_full_name));
1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1581: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1582: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));

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

1575: pay_in_utils.trace('p_start_date',TO_CHAR (p_start_date));
1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1581: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1582: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1583:

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

1576: pay_in_utils.trace('p_effective_end_date',TO_CHAR (p_effective_end_date));
1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1581: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1582: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1583:
1584: END IF;

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

1577: pay_in_utils.trace('p_fare',TO_CHAR (p_fare));
1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1581: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1582: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1583:
1584: END IF;
1585:

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

1578: pay_in_utils.trace('p_blockYr',TO_CHAR (p_blockYr));
1579: pay_in_utils.trace('p_carry',TO_CHAR (p_carry));
1580: pay_in_utils.trace('p_benefit',TO_CHAR (p_benefit));
1581: pay_in_utils.trace('p_assignment_id',TO_CHAR (p_assignment_id));
1582: pay_in_utils.trace(' p_element_entry_id',TO_CHAR (p_element_entry_id));
1583:
1584: END IF;
1585:
1586: IF p_fare < 0 THEN

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

1605: l_business_group_id := get_bg_id();
1606:
1607: IF (g_debug)
1608: THEN
1609: pay_in_utils.trace('Business Group:',TO_CHAR (l_business_group_id));
1610: END IF;
1611:
1612:
1613: IF ((p_element_entry_id IS NOT NULL))

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

1612:
1613: IF ((p_element_entry_id IS NOT NULL))
1614: THEN
1615:
1616: pay_in_utils.set_location(g_debug,'Updating Element Entries: '||l_procedure,30);
1617:
1618: OPEN c_get_ele_object_version(p_element_entry_id) ;
1619: FETCH c_get_ele_object_version INTO l_object_version_no ;
1620: CLOSE c_get_ele_object_version ;

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

1631: l_input_values_rec(l_count).value := c_rec.value;
1632:
1633: IF (g_debug)
1634: THEN
1635: pay_in_utils.trace('Input Values Name:'||l_count,TO_CHAR (c_rec.name));
1636: END IF;
1637:
1638: l_count := l_count + 1;
1639: END LOOP;

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

1676: SET AEI_INFORMATION18 = p_carry
1677: where AEI_INFORMATION11 = p_element_entry_id
1678: and assignment_id = p_assignment_id;
1679:
1680: pay_in_utils.trace('**************************************************','********************');
1681: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1682:
1683:
1684:

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

1677: where AEI_INFORMATION11 = p_element_entry_id
1678: and assignment_id = p_assignment_id;
1679:
1680: pay_in_utils.trace('**************************************************','********************');
1681: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
1682:
1683:
1684:
1685: