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.CREATE_GB_RTI_EPS_RECORD dependencies on FND_FILE

Line 97: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');

93: --13741983 begin
94: /*
95: if g_employers_name = ' ' or g_employers_name is null then
96: HR_UTILITY.TRACE('Error: The Employer name is missing.');
97: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');
98: RAISE MANDATORY_VALUES_MISSING;
99: elsif PAY_GB_RTI.validate_input(g_employers_name,'EMP_NAME') > 0 then
100: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');
101: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name has invalid characters.');

Line 101: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name has invalid characters.');

97: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name is missing.');
98: RAISE MANDATORY_VALUES_MISSING;
99: elsif PAY_GB_RTI.validate_input(g_employers_name,'EMP_NAME') > 0 then
100: HR_UTILITY.TRACE('Error: The Employer name has invalid characters.');
101: fnd_file.put_line(fnd_file.LOG,'Error: The Employer name has invalid characters.');
102: RAISE MANDATORY_VALUES_MISSING;
103: end if;
104:
105: if g_acc_ref_no = ' ' or g_acc_ref_no is null then

Line 107: fnd_file.put_line(fnd_file.LOG,'Error: The Account Office Reference Number is missing.');

103: end if;
104:
105: if g_acc_ref_no = ' ' or g_acc_ref_no is null then
106: HR_UTILITY.TRACE('Error: The Account Office Reference Number is missing.');
107: fnd_file.put_line(fnd_file.LOG,'Error: The Account Office Reference Number is missing.');
108: RAISE MANDATORY_VALUES_MISSING;
109: elsif (length(g_acc_ref_no) > 13
110: OR REGEXP_INSTR(g_acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
111: HR_UTILITY.TRACE('Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');

Line 112: fnd_file.put_line(fnd_file.LOG,'Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');

108: RAISE MANDATORY_VALUES_MISSING;
109: elsif (length(g_acc_ref_no) > 13
110: OR REGEXP_INSTR(g_acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
111: HR_UTILITY.TRACE('Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
112: fnd_file.put_line(fnd_file.LOG,'Error: Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
113: RAISE MANDATORY_VALUES_MISSING;
114: end if;
115: --13741983 End
116: */

Line 356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

352:
353: HR_UTILITY.TRACE(' EPS record insert complete ');
354: --Write Output Information
355: l_msg_output:= ' RTI - Employer Payment Summary - Created ';
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
357: L_MSG_OUTPUT:= ' ';
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
359: l_msg_output:= ' ';
360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

354: --Write Output Information
355: l_msg_output:= ' RTI - Employer Payment Summary - Created ';
356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
357: L_MSG_OUTPUT:= ' ';
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
359: l_msg_output:= ' ';
360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
361: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
357: L_MSG_OUTPUT:= ' ';
358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
359: l_msg_output:= ' ';
360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
361: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
363: L_MSG_OUTPUT:= ' ';
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

358: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
359: l_msg_output:= ' ';
360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
361: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
363: L_MSG_OUTPUT:= ' ';
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
365: --Start of 13726549
366: IF G_SMP_RECOVERY = 'Full' THEN

Line 364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

360: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
361: L_MSG_OUTPUT:= 'PAYE Reference : '||rpad(P_PAYE_REFERENCE,20,' ') ||' Effective Date: '||FND_DATE.CANONICAL_TO_DATE(P_EFFECTIVE_DT);
362: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
363: L_MSG_OUTPUT:= ' ';
364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
365: --Start of 13726549
366: IF G_SMP_RECOVERY = 'Full' THEN
367: l_msg_output:= 'SMP/SAP/OSPP/ASPP Recovery Type: '||rpad(g_smp_recovery,20,' ')||' Recovery Percentage Used: '||(100);
368: ELSIF G_SMP_RECOVERY = 'Partial' THEN

Line 374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

370: ELSE
371: l_msg_output:= 'SMP/SAP/OSPP/ASPP Recovery Type: '||rpad(g_smp_recovery,20,' ')||' Recovery Percentage Used: '||(0);
372: END IF;
373: --End of 13726549
374: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
375: IF G_SSP_RECOVERY = 'Full' THEN
376: L_MSG_OUTPUT:= 'SSP Recovery Type : '||rpad(G_SSP_RECOVERY,20,' ')||' Recovery Percentage Used: '||'100';
377: ELSE
378: L_MSG_OUTPUT:= 'SSP Recovery Type : '||rpad(G_SSP_RECOVERY,20,' ')||' Recovery Percentage Used: '||'0';

Line 381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

377: ELSE
378: L_MSG_OUTPUT:= 'SSP Recovery Type : '||rpad(G_SSP_RECOVERY,20,' ')||' Recovery Percentage Used: '||'0';
379: END IF;
380:
381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
382: L_MSG_OUTPUT:= ' ';
383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
384: L_MSG_OUTPUT:= 'SMP Amount Recovered : '||rpad(to_char(L_SMP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SMP : '||to_char(L_NIC_SMP/100,'FM9999999990D00');
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

379: END IF;
380:
381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
382: L_MSG_OUTPUT:= ' ';
383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
384: L_MSG_OUTPUT:= 'SMP Amount Recovered : '||rpad(to_char(L_SMP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SMP : '||to_char(L_NIC_SMP/100,'FM9999999990D00');
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
386: L_MSG_OUTPUT:= 'SAP Amount Recovered : '||rpad(to_char(L_SAP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SAP : '||to_char(L_NIC_SAP/100,'FM9999999990D00');
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

381: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
382: L_MSG_OUTPUT:= ' ';
383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
384: L_MSG_OUTPUT:= 'SMP Amount Recovered : '||rpad(to_char(L_SMP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SMP : '||to_char(L_NIC_SMP/100,'FM9999999990D00');
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
386: L_MSG_OUTPUT:= 'SAP Amount Recovered : '||rpad(to_char(L_SAP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SAP : '||to_char(L_NIC_SAP/100,'FM9999999990D00');
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
388: L_MSG_OUTPUT:= 'OSPP Amount Recovered : '||rpad(to_char(L_SPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on OSPP : '||to_char(L_NIC_SPP/100,'FM9999999990D00');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

383: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
384: L_MSG_OUTPUT:= 'SMP Amount Recovered : '||rpad(to_char(L_SMP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SMP : '||to_char(L_NIC_SMP/100,'FM9999999990D00');
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
386: L_MSG_OUTPUT:= 'SAP Amount Recovered : '||rpad(to_char(L_SAP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SAP : '||to_char(L_NIC_SAP/100,'FM9999999990D00');
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
388: L_MSG_OUTPUT:= 'OSPP Amount Recovered : '||rpad(to_char(L_SPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on OSPP : '||to_char(L_NIC_SPP/100,'FM9999999990D00');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
390: L_MSG_OUTPUT:= 'ASPP Amount Recovered : '||rpad(to_char(L_ASPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on ASPP : '||to_char(L_NIC_ASPP/100,'FM9999999990D00');
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
386: L_MSG_OUTPUT:= 'SAP Amount Recovered : '||rpad(to_char(L_SAP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SAP : '||to_char(L_NIC_SAP/100,'FM9999999990D00');
387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
388: L_MSG_OUTPUT:= 'OSPP Amount Recovered : '||rpad(to_char(L_SPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on OSPP : '||to_char(L_NIC_SPP/100,'FM9999999990D00');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
390: L_MSG_OUTPUT:= 'ASPP Amount Recovered : '||rpad(to_char(L_ASPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on ASPP : '||to_char(L_NIC_ASPP/100,'FM9999999990D00');
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
392: L_MSG_OUTPUT:= 'SSP Amount Recovered : '||rpad(to_char(L_SSP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SSP : '||to_char(L_NIC_SSP/100,'FM9999999990D00');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

Line 391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

387: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
388: L_MSG_OUTPUT:= 'OSPP Amount Recovered : '||rpad(to_char(L_SPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on OSPP : '||to_char(L_NIC_SPP/100,'FM9999999990D00');
389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
390: L_MSG_OUTPUT:= 'ASPP Amount Recovered : '||rpad(to_char(L_ASPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on ASPP : '||to_char(L_NIC_ASPP/100,'FM9999999990D00');
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
392: L_MSG_OUTPUT:= 'SSP Amount Recovered : '||rpad(to_char(L_SSP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SSP : '||to_char(L_NIC_SSP/100,'FM9999999990D00');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
394: HR_UTILITY.TRACE('Create_EPS_RECORD completed '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
395: END IF;

Line 393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);

389: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
390: L_MSG_OUTPUT:= 'ASPP Amount Recovered : '||rpad(to_char(L_ASPP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on ASPP : '||to_char(L_NIC_ASPP/100,'FM9999999990D00');
391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
392: L_MSG_OUTPUT:= 'SSP Amount Recovered : '||rpad(to_char(L_SSP/100,'FM9999999990D00'),30,' ')||' NIC Compensation on SSP : '||to_char(L_NIC_SSP/100,'FM9999999990D00');
393: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, L_MSG_OUTPUT);
394: HR_UTILITY.TRACE('Create_EPS_RECORD completed '||to_char(sysdate,'dd-mon-yyyy hh24:mm:ss'));
395: END IF;
396: EXCEPTION
397: --13741983 begin

Line 405: fnd_file.put_line(fnd_file.log,l_msg_output);

401: --13741983 end
402: WHEN Global_missing THEN
403: hr_utility.trace('Error: The globals required for processing EPS are not present. Please check ');
404: l_msg_output := 'Error: The globals required for processing EPS are not present. Please check ';
405: fnd_file.put_line(fnd_file.log,l_msg_output);
406: raise_application_error(-20001,' Globals missing');
407: WHEN EPS_ALREADY_PRESENT THEN
408: l_msg_output:= 'EPS record already created for the given parameters. Please check ';
409: hr_utility.trace('EPS record already created for the given parameters. Please check ');

Line 410: fnd_file.put_line(fnd_file.log,l_msg_output);

406: raise_application_error(-20001,' Globals missing');
407: WHEN EPS_ALREADY_PRESENT THEN
408: l_msg_output:= 'EPS record already created for the given parameters. Please check ';
409: hr_utility.trace('EPS record already created for the given parameters. Please check ');
410: fnd_file.put_line(fnd_file.log,l_msg_output);
411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_MSG_OUTPUT);
412: raise_application_error(-20001,' EPS record already created for the given parameters. Please check');
413: WHEN OTHERS THEN
414: fnd_file.put_line(fnd_file.log, SUBSTR(sqlerrm(SQLCODE),1,80));

Line 411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_MSG_OUTPUT);

407: WHEN EPS_ALREADY_PRESENT THEN
408: l_msg_output:= 'EPS record already created for the given parameters. Please check ';
409: hr_utility.trace('EPS record already created for the given parameters. Please check ');
410: fnd_file.put_line(fnd_file.log,l_msg_output);
411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_MSG_OUTPUT);
412: raise_application_error(-20001,' EPS record already created for the given parameters. Please check');
413: WHEN OTHERS THEN
414: fnd_file.put_line(fnd_file.log, SUBSTR(sqlerrm(SQLCODE),1,80));
415: RAISE_APPLICATION_ERROR(-20001,' Error'||SQLERRM(SQLCODE));

Line 414: fnd_file.put_line(fnd_file.log, SUBSTR(sqlerrm(SQLCODE),1,80));

410: fnd_file.put_line(fnd_file.log,l_msg_output);
411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_MSG_OUTPUT);
412: raise_application_error(-20001,' EPS record already created for the given parameters. Please check');
413: WHEN OTHERS THEN
414: fnd_file.put_line(fnd_file.log, SUBSTR(sqlerrm(SQLCODE),1,80));
415: RAISE_APPLICATION_ERROR(-20001,' Error'||SQLERRM(SQLCODE));
416: rollback;
417: END Create_EPS_RECORD;
418:

Line 461: fnd_file.put_line(fnd_file.LOG,'Pamount:' || p_amount );

457: AND NVL(HOI.ORG_INFORMATION10,'UK') = 'UK'
458: AND hoi.org_information1 = g_paye_reference;
459:
460: begin
461: fnd_file.put_line(fnd_file.LOG,'Pamount:' || p_amount );
462: fnd_file.put_line(fnd_file.LOG,'p_element_type_id:' || p_element_type_id);
463: fnd_file.put_line(fnd_file.LOG,'p_assignment_action_id:' || p_assignment_action_id);
464:
465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id

Line 462: fnd_file.put_line(fnd_file.LOG,'p_element_type_id:' || p_element_type_id);

458: AND hoi.org_information1 = g_paye_reference;
459:
460: begin
461: fnd_file.put_line(fnd_file.LOG,'Pamount:' || p_amount );
462: fnd_file.put_line(fnd_file.LOG,'p_element_type_id:' || p_element_type_id);
463: fnd_file.put_line(fnd_file.LOG,'p_assignment_action_id:' || p_assignment_action_id);
464:
465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id
466: and paa.assignment_action_id = p_assignment_action_id;

Line 463: fnd_file.put_line(fnd_file.LOG,'p_assignment_action_id:' || p_assignment_action_id);

459:
460: begin
461: fnd_file.put_line(fnd_file.LOG,'Pamount:' || p_amount );
462: fnd_file.put_line(fnd_file.LOG,'p_element_type_id:' || p_element_type_id);
463: fnd_file.put_line(fnd_file.LOG,'p_assignment_action_id:' || p_assignment_action_id);
464:
465: select effective_date into l_eff_date from pay_assignment_actions paa, pay_payroll_actions ppa where ppa.payroll_action_id = paa.payroll_action_id
466: and paa.assignment_action_id = p_assignment_action_id;
467:

Line 491: fnd_file.put_line(fnd_file.LOG,'Entering in get_rec_and_nic. l_rec_rate: ' || l_rec_rate);

487: select global_value into l_nic_rate from ff_globals_f where global_name = 'NIC_COMPENSATION_RATE_ON_SMP' and legislation_code = 'GB' and
488: l_eff_date between effective_start_date and effective_end_date;
489:
490:
491: fnd_file.put_line(fnd_file.LOG,'Entering in get_rec_and_nic. l_rec_rate: ' || l_rec_rate);
492: fnd_file.put_line(fnd_file.LOG,'l_nic_rate' || l_nic_rate);
493: if g_smp_recovery = 'Partial' THEN
494: fnd_file.put_line(fnd_file.LOG,'Partial');
495: p_rec_amount := round(l_rec_rate*p_amount,2);

Line 492: fnd_file.put_line(fnd_file.LOG,'l_nic_rate' || l_nic_rate);

488: l_eff_date between effective_start_date and effective_end_date;
489:
490:
491: fnd_file.put_line(fnd_file.LOG,'Entering in get_rec_and_nic. l_rec_rate: ' || l_rec_rate);
492: fnd_file.put_line(fnd_file.LOG,'l_nic_rate' || l_nic_rate);
493: if g_smp_recovery = 'Partial' THEN
494: fnd_file.put_line(fnd_file.LOG,'Partial');
495: p_rec_amount := round(l_rec_rate*p_amount,2);
496: p_nic_amount :=0;

Line 494: fnd_file.put_line(fnd_file.LOG,'Partial');

490:
491: fnd_file.put_line(fnd_file.LOG,'Entering in get_rec_and_nic. l_rec_rate: ' || l_rec_rate);
492: fnd_file.put_line(fnd_file.LOG,'l_nic_rate' || l_nic_rate);
493: if g_smp_recovery = 'Partial' THEN
494: fnd_file.put_line(fnd_file.LOG,'Partial');
495: p_rec_amount := round(l_rec_rate*p_amount,2);
496: p_nic_amount :=0;
497: fnd_file.put_line(fnd_file.LOG,'p_rec_amount: ' || p_rec_amount || ' p_nic_amount: ' ||p_nic_amount);
498: elsif g_smp_recovery = 'Full' THEN

Line 497: fnd_file.put_line(fnd_file.LOG,'p_rec_amount: ' || p_rec_amount || ' p_nic_amount: ' ||p_nic_amount);

493: if g_smp_recovery = 'Partial' THEN
494: fnd_file.put_line(fnd_file.LOG,'Partial');
495: p_rec_amount := round(l_rec_rate*p_amount,2);
496: p_nic_amount :=0;
497: fnd_file.put_line(fnd_file.LOG,'p_rec_amount: ' || p_rec_amount || ' p_nic_amount: ' ||p_nic_amount);
498: elsif g_smp_recovery = 'Full' THEN
499: fnd_file.put_line(fnd_file.LOG,'Full');
500: p_rec_amount := p_amount;
501: begin

Line 499: fnd_file.put_line(fnd_file.LOG,'Full');

495: p_rec_amount := round(l_rec_rate*p_amount,2);
496: p_nic_amount :=0;
497: fnd_file.put_line(fnd_file.LOG,'p_rec_amount: ' || p_rec_amount || ' p_nic_amount: ' ||p_nic_amount);
498: elsif g_smp_recovery = 'Full' THEN
499: fnd_file.put_line(fnd_file.LOG,'Full');
500: p_rec_amount := p_amount;
501: begin
502: -- calculate the NIC value from the PTD value
503: select element_name into l_element_name from pay_element_types_f where element_type_id = p_element_type_id

Line 556: fnd_file.put_line(fnd_file.LOG,'Exception in get_rec_and_nic ' || sqlerrm);

552: p_nic_amount := 0;
553: end if;
554: return 1;
555: exception when others then
556: fnd_file.put_line(fnd_file.LOG,'Exception in get_rec_and_nic ' || sqlerrm);
557: return -1;
558: end GET_REC_AND_NIC_VALUES;
559:
560: