DBA Data[Home] [Help]

APPS.PA_DEDUCTIONS dependencies on FND_FILE

Line 1992: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1988: OPEN C3;
1989: FETCH C3 INTO l_report_rec;
1990: CLOSE C3;
1991: -- display details in the log
1992: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1993: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':' || l_report_rec.deduction_req_num);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num);
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);
1996:

Line 1993: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':' || l_report_rec.deduction_req_num);

1989: FETCH C3 INTO l_report_rec;
1990: CLOSE C3;
1991: -- display details in the log
1992: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1993: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':' || l_report_rec.deduction_req_num);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num);
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);
1996:
1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');

Line 1994: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num);

1990: CLOSE C3;
1991: -- display details in the log
1992: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1993: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':' || l_report_rec.deduction_req_num);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num);
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);
1996:
1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');
1998:

Line 1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);

1991: -- display details in the log
1992: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
1993: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':' || l_report_rec.deduction_req_num);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num);
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);
1996:
1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');
1998:
1999: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

Line 1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');

1993: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':' || l_report_rec.deduction_req_num);
1994: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num);
1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);
1996:
1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');
1998:
1999: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2000:
2001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,LPAD(SYSDATE,130));

Line 1999: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');

1995: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':'|| l_report_rec.deduction_req_date);
1996:
1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');
1998:
1999: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2000:
2001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,LPAD(SYSDATE,130));
2002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_rec.hr_name,120));
2003: -- display the rejected header in the output file

Line 2001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,LPAD(SYSDATE,130));

1997: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Payables Interface Status : ' || 'Failed');
1998:
1999: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2000:
2001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,LPAD(SYSDATE,130));
2002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_rec.hr_name,120));
2003: -- display the rejected header in the output file
2004: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,'DED_IMP_FAIL_REP');
2005: l_header_len := LENGTH(l_content);

Line 2002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_rec.hr_name,120));

1998:
1999: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
2000:
2001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,LPAD(SYSDATE,130));
2002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_rec.hr_name,120));
2003: -- display the rejected header in the output file
2004: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,'DED_IMP_FAIL_REP');
2005: l_header_len := LENGTH(l_content);
2006: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header

Line 2007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2003: -- display the rejected header in the output file
2004: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,'DED_IMP_FAIL_REP');
2005: l_header_len := LENGTH(l_content);
2006: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
2007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2010:
2011: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':'|| l_report_rec.deduction_req_num,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num;

Line 2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

2004: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,'DED_IMP_FAIL_REP');
2005: l_header_len := LENGTH(l_content);
2006: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
2007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2010:
2011: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':'|| l_report_rec.deduction_req_num,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num;
2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

Line 2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

2005: l_header_len := LENGTH(l_content);
2006: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
2007: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2010:
2011: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':'|| l_report_rec.deduction_req_num,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num;
2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2013:

Line 2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2009: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2010:
2011: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':'|| l_report_rec.deduction_req_num,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num;
2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2013:
2014: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':' || l_report_rec.deduction_req_date,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_DATE')||':' || l_report_rec.debit_memo_date;
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2016:

Line 2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

2011: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_NUMBER')||':'|| l_report_rec.deduction_req_num,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_NUMBER')||':' ||l_report_rec.debit_memo_num;
2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2013:
2014: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':' || l_report_rec.deduction_req_date,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_DATE')||':' || l_report_rec.debit_memo_date;
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2016:
2017: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PROJECT_NAME')||':' || l_report_rec.name,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_CURRENCY')||':' || l_report_rec.currency_code;
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2019:

Line 2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

2014: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'DEDUCTION_DATE')||':' || l_report_rec.deduction_req_date,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_DATE')||':' || l_report_rec.debit_memo_date;
2015: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2016:
2017: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PROJECT_NAME')||':' || l_report_rec.name,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_CURRENCY')||':' || l_report_rec.currency_code;
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2019:
2020: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PROJECT_NUMBER')||':' || l_report_rec.segment1,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'SUPPLIER_NAME')||':' || l_report_rec.vendor_name;
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2022:

Line 2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

2017: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PROJECT_NAME')||':' || l_report_rec.name,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'DEBIT_MEMO_CURRENCY')||':' || l_report_rec.currency_code;
2018: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2019:
2020: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PROJECT_NUMBER')||':' || l_report_rec.segment1,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'SUPPLIER_NAME')||':' || l_report_rec.vendor_name;
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2022:
2023: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PAYABLES_INTERFACE_STATUS')||':'|| 'Failed',60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'SUPPLIER_SITE')||':' || l_report_rec.vendor_site_code;
2024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2025:

Line 2024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);

2020: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PROJECT_NUMBER')||':' || l_report_rec.segment1,60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'SUPPLIER_NAME')||':' || l_report_rec.vendor_name;
2021: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2022:
2023: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PAYABLES_INTERFACE_STATUS')||':'|| 'Failed',60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'SUPPLIER_SITE')||':' || l_report_rec.vendor_site_code;
2024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2025:
2026:
2027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2028:

Line 2027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');

2023: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'PAYABLES_INTERFACE_STATUS')||':'|| 'Failed',60)||FND_MESSAGE.GET_STRING(G_APP_NAME,'SUPPLIER_SITE')||':' || l_report_rec.vendor_site_code;
2024: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_content);
2025:
2026:
2027: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' ');
2028:
2029: -- check if failure at header level or line level
2030: FOR reject_hdr_rec IN C5
2031: LOOP

Line 2038: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2034:
2035: IF hdrcount > 0 THEN -- header level failure
2036:
2037: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'REASON_FOR_FAILURE'),20);
2038: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2039: FOR reject_hdr_rec IN C5
2040: LOOP
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,reject_hdr_rec.reason);
2042: END LOOP;

Line 2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,reject_hdr_rec.reason);

2037: l_content:=RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'REASON_FOR_FAILURE'),20);
2038: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2039: FOR reject_hdr_rec IN C5
2040: LOOP
2041: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,reject_hdr_rec.reason);
2042: END LOOP;
2043:
2044: ELSE --lines level failure
2045: -- Failed records report header

Line 2050: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2046:
2047: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,'DED_PAY_IMP_FAIL_REP');
2048: l_header_len := LENGTH(l_content);
2049: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2); -- center align header
2050: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2051:
2052: l_content := RPAD('=',l_header_len,'='); -- underline header
2053: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

Line 2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2050: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2051:
2052: l_content := RPAD('=',l_header_len,'='); -- underline header
2053: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2055:
2056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2058:

Line 2056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

2052: l_content := RPAD('=',l_header_len,'='); -- underline header
2053: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2055:
2056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2058:
2059:
2060: -- Table header

Line 2057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');

2053: l_content := RPAD(LPAD(l_content,l_max_len/2),l_max_len/2,'='); -- center align
2054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2055:
2056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2057: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
2058:
2059:
2060: -- Table header
2061: l_content := RPAD('-',l_row_num_len-1,'-') || ' '

Line 2068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2064: || RPAD('-',l_lessee_len-1,'-') || ' '
2065: || RPAD('-',l_sty_subclass_len-1,'-') || ' '
2066: || RPAD('-',l_reject_code_len-1,'-');
2067:
2068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2069:
2070: l_content := RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'SERIAL_NO'),l_row_num_len-1) || ' '
2071: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'TASK_NUMBER'),l_contract_num_len-1) || ' '
2072: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'EXPENDITURE_TYPE'),l_asset_num_len-1) || ' '

Line 2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2075: || RPAD(FND_MESSAGE.GET_STRING(G_APP_NAME,'REASON_FOR_FAILURE'),l_reject_code_len-1);
2076:
2077:
2078:
2079: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2080:
2081: l_content := RPAD('-',l_row_num_len-1,'-') || ' '
2082: || RPAD('-',l_contract_num_len-1,'-') || ' '
2083: || RPAD('-',l_asset_num_len-1,'-') || ' '

Line 2088: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2084: || RPAD('-',l_lessee_len-1,'-') || ' '
2085: || RPAD('-',l_sty_subclass_len-1,'-') || ' '
2086: || RPAD('-',l_reject_code_len-1,'-');
2087:
2088: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2089:
2090: -- initialize counter for serial number
2091: counter:=0;
2092:

Line 2105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);

2101: || RPAD(reject_dtls_rec.exp_org,l_lessee_len-1) || ' '
2102: || RPAD(reject_dtls_rec.amount,l_sty_subclass_len-1) || ' '
2103: || RPAD(reject_dtls_rec.reason,l_reject_code_len-1);
2104:
2105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_content);
2106:
2107: END LOOP;
2108: END IF;
2109:

Line 2117: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Process successful');

2113: ELSE
2114: IF P_DEBUG_MODE = 'Y' THEN
2115: log_message ('Interface process successful', g_api_name);
2116: END IF;
2117: FND_FILE.PUT_LINE(FND_FILE.LOG,'Import Process successful');
2118: Update_Deduction_Status(p_dctn_req_id,
2119: 'PROCESSED');
2120:
2121: END IF;