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

Line 7395: fnd_file.put_line(fnd_file.log, fnd_message.get);

7391: /*commented for bug 6858309
7392: ELSE
7393: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
7394: fnd_message.set_token('INV_NUM', l_invoice_num);
7395: fnd_file.put_line(fnd_file.log, fnd_message.get);
7396: END IF; */
7397:
7398: UPDATE ap_invoices_all
7399: SET validation_request_id = NULL

Line 7407: fnd_file.put_line(fnd_file.log, fnd_message.get);

7403:
7404: ELSE /*bug6858309- changed location of the call*/
7405: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
7406: fnd_message.set_token('INV_NUM', l_invoice_num);
7407: fnd_file.put_line(fnd_file.log, fnd_message.get);
7408:
7409: END IF; --if validate_period(p_invoice_id)
7410:
7411: ---------------------------------------------------------------------

Line 7745: fnd_file.put_line(fnd_file.log, fnd_message.get);

7741: );
7742: ELSE
7743: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
7744: fnd_message.set_token('INV_NUM', l_invoice_num);
7745: fnd_file.put_line(fnd_file.log, fnd_message.get);
7746: END IF;
7747:
7748: END IF;
7749: -- BUG 7509921 Update Validation Request id to null

Line 7764: fnd_file.put_line (fnd_file.log, ' ');

7760:
7761: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7762:
7763: ap_utilities_pkg.ap_get_message(l_approval_error);
7764: fnd_file.put_line (fnd_file.log, ' ');
7765: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7766: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7767: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7768: l_invoice_num);

Line 7765: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);

7761: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7762:
7763: ap_utilities_pkg.ap_get_message(l_approval_error);
7764: fnd_file.put_line (fnd_file.log, ' ');
7765: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7766: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7767: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7768: l_invoice_num);
7769:

Line 7766: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);

7762:
7763: ap_utilities_pkg.ap_get_message(l_approval_error);
7764: fnd_file.put_line (fnd_file.log, ' ');
7765: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7766: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7767: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7768: l_invoice_num);
7769:
7770:

Line 7776: fnd_file.put_line (fnd_file.log, ' ');

7772:
7773: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7774:
7775: ap_utilities_pkg.ap_get_message(l_approval_error);
7776: fnd_file.put_line (fnd_file.log, ' ');
7777: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7778: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7779: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7780: l_invoice_num);

Line 7777: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);

7773: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
7774:
7775: ap_utilities_pkg.ap_get_message(l_approval_error);
7776: fnd_file.put_line (fnd_file.log, ' ');
7777: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7778: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7779: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7780: l_invoice_num);
7781:

Line 7778: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);

7774:
7775: ap_utilities_pkg.ap_get_message(l_approval_error);
7776: fnd_file.put_line (fnd_file.log, ' ');
7777: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_invoice_num);
7778: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7779: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7780: l_invoice_num);
7781:
7782: END;

Line 7949: fnd_file.put_line(fnd_file.log, fnd_message.get);

7945: );
7946: ELSE
7947: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
7948: fnd_message.set_token('INV_NUM', l_invoice_num);
7949: fnd_file.put_line(fnd_file.log, fnd_message.get);
7950: END IF;
7951:
7952: END IF;
7953: -- BUG 7509921 Update Validation Request id to null

Line 7970: fnd_file.put_line (fnd_file.log, ' ');

7966: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7967:
7968: ap_utilities_pkg.ap_get_message(l_approval_error);
7969:
7970: fnd_file.put_line (fnd_file.log, ' ');
7971: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7972: l_selc_inv_cursor_blk_err(i).invoice_num);
7973: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7974: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

Line 7971: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||

7967:
7968: ap_utilities_pkg.ap_get_message(l_approval_error);
7969:
7970: fnd_file.put_line (fnd_file.log, ' ');
7971: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7972: l_selc_inv_cursor_blk_err(i).invoice_num);
7973: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7974: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7975: l_selc_inv_cursor_blk_err(i).invoice_num);

Line 7973: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);

7969:
7970: fnd_file.put_line (fnd_file.log, ' ');
7971: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7972: l_selc_inv_cursor_blk_err(i).invoice_num);
7973: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7974: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7975: l_selc_inv_cursor_blk_err(i).invoice_num);
7976:
7977: WHEN OTHERS THEN

Line 7983: fnd_file.put_line (fnd_file.log, ' ');

7979: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
7980:
7981: ap_utilities_pkg.ap_get_message(l_approval_error);
7982:
7983: fnd_file.put_line (fnd_file.log, ' ');
7984: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7985: l_selc_inv_cursor_blk_err(i).invoice_num);
7986: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7987: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

Line 7984: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||

7980:
7981: ap_utilities_pkg.ap_get_message(l_approval_error);
7982:
7983: fnd_file.put_line (fnd_file.log, ' ');
7984: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7985: l_selc_inv_cursor_blk_err(i).invoice_num);
7986: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7987: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7988: l_selc_inv_cursor_blk_err(i).invoice_num);

Line 7986: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);

7982:
7983: fnd_file.put_line (fnd_file.log, ' ');
7984: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
7985: l_selc_inv_cursor_blk_err(i).invoice_num);
7986: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
7987: Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
7988: l_selc_inv_cursor_blk_err(i).invoice_num);
7989:
7990: END;

Line 8061: fnd_file.put_line(fnd_file.log, fnd_message.get);

8057:
8058: ELSE
8059: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
8060: fnd_message.set_token('INV_NUM', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_num);
8061: fnd_file.put_line(fnd_file.log, fnd_message.get);
8062: END IF;
8063:
8064: -- Update Validation Request_ID to NULL;
8065: UPDATE ap_invoices_all

Line 8122: fnd_file.put_line(fnd_file.log,l_approval_error);

8118: EXCEPTION
8119:
8120: WHEN TAX_EXCEPTION THEN
8121: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
8122: fnd_file.put_line(fnd_file.log,l_approval_error);
8123: fnd_file.put_line(fnd_file.log,sqlerrm);
8124: Print_Debug(l_api_name, 'Exception: '||sqlerrm);
8125:
8126: --Bug7246971

Line 8123: fnd_file.put_line(fnd_file.log,sqlerrm);

8119:
8120: WHEN TAX_EXCEPTION THEN
8121: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
8122: fnd_file.put_line(fnd_file.log,l_approval_error);
8123: fnd_file.put_line(fnd_file.log,sqlerrm);
8124: Print_Debug(l_api_name, 'Exception: '||sqlerrm);
8125:
8126: --Bug7246971
8127:

Line 8154: fnd_file.put_line(fnd_file.log,l_approval_error);

8150: RETURN (FALSE);
8151:
8152: WHEN OTHERS THEN
8153: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
8154: fnd_file.put_line(fnd_file.log,l_approval_error);
8155: fnd_file.put_line(fnd_file.log,sqlerrm);
8156: Print_Debug(l_api_name, 'Others: Exception: '||sqlerrm);
8157:
8158: --Bug7246971

Line 8155: fnd_file.put_line(fnd_file.log,sqlerrm);

8151:
8152: WHEN OTHERS THEN
8153: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
8154: fnd_file.put_line(fnd_file.log,l_approval_error);
8155: fnd_file.put_line(fnd_file.log,sqlerrm);
8156: Print_Debug(l_api_name, 'Others: Exception: '||sqlerrm);
8157:
8158: --Bug7246971
8159: