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 6737: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6733: l_current_calling_sequence := 'AP_APPROVAL_PKG.UPDATE_SCHEDULES <- '|| p_calling_sequence;
6734:
6735: l_debug_info := 'Begin UPDATE_SCHEDULES procedure';
6736: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6737: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6738: END IF;
6739:
6740: select terms_date
6741: into l_old_terms_date

Line 6747: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6743: where invoice_id = p_invoice_id;
6744:
6745: l_debug_info := 'Before updating invoice terms_date';
6746: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6747: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6748: END IF;
6749:
6750: Update ap_invoices_all
6751: set terms_date =trunc(sysdate),

Line 6769: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6765: --schedules.
6766:
6767: l_debug_info := 'Invoice contains paid schedules.';
6768: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6769: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6770: END IF;
6771:
6772: Update ap_payment_schedules_all
6773: set due_date = due_date +(sysdate-l_old_terms_date)

Line 6783: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6779: --If Invoice does not have paid schedules recreate payment schedules
6780:
6781: l_debug_info := 'Invoice does not have paid schedules.';
6782: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6783: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6784: END IF;
6785:
6786: OPEN invoice_cursor;
6787: FETCH invoice_cursor

Line 6805: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

6801:
6802:
6803: l_debug_info := 'Create the payment schedules';
6804: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
6805: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
6806: END IF;
6807:
6808: AP_CREATE_PAY_SCHEDS_PKG.AP_Create_From_Terms(
6809: p_invoice_id,

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

9696: /*commented for bug 6858309
9697: ELSE
9698: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
9699: fnd_message.set_token('INV_NUM', l_invoice_num);
9700: fnd_file.put_line(fnd_file.log, fnd_message.get);
9701: END IF; */
9702:
9703: UPDATE ap_invoices_all
9704: SET validation_request_id = NULL

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

9708:
9709: ELSE /*bug6858309- changed location of the call*/
9710: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
9711: fnd_message.set_token('INV_NUM', l_invoice_num);
9712: fnd_file.put_line(fnd_file.log, fnd_message.get);
9713:
9714: END IF; --if validate_period(p_invoice_id)
9715:
9716: ELSE /*Bug 9304530 - Exclude already validated invoices*/

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

9714: END IF; --if validate_period(p_invoice_id)
9715:
9716: ELSE /*Bug 9304530 - Exclude already validated invoices*/
9717: fnd_message.set_name('SQLAP', 'AP_APPRVL_INV_NOT_FOUND');
9718: fnd_file.put_line(fnd_file.log, fnd_message.get);
9719: -----------------------------------------------------------------
9720: -- Print_Debug(l_api_name, 'Invoice is already approved/cancelled');
9721: IF g_debug_mode = 'Y' THEN
9722: AP_Debug_Pkg.Print(g_debug_mode, 'Invoice is already approved/cancelled' );

Line 10029: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of Invoices selected for Processing: '||l_selected_invoice_ids.count);

10025: --Bug8587494
10026:
10027: -- Added debug msg for Bug 8234569
10028: ---------------------------------------------------------------------
10029: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'No. of Invoices selected for Processing: '||l_selected_invoice_ids.count);
10030: -- Print_Debug (l_api_name,'No. of Invoices selected for Processing: '||l_selected_invoice_ids.count);
10031: IF g_debug_mode = 'Y' THEN
10032: AP_Debug_Pkg.Print(g_debug_mode, 'No. of Invoices selected for Processing: '||l_selected_invoice_ids.count );
10033: END IF;

Line 10084: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk CALCULATE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854

10080: delete from zx_errors_gt; --Flusing the GT Table
10081: delete from ap_errors_gt; --Flusing the AP GT table --bug10140354
10082:
10083: --Moved Logging inside loop
10084: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk CALCULATE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10085:
10086: l_success := ap_etax_pkg.calling_etax(
10087: p_invoice_id => NULL,
10088: p_calling_mode => 'CALCULATE',

Line 10093: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk CALCULATE) END SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854

10089: p_all_error_messages => 'N',
10090: p_error_code => l_error_code,
10091: p_calling_sequence => l_curr_calling_sequence);
10092:
10093: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk CALCULATE) END SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10094: --Moved Logging inside loop
10095:
10096: OPEN c_tx_err ;
10097: FETCH c_tx_err

Line 10133: fnd_file.put_line (fnd_file.log, l_approval_error

10129:
10130: FOR i in 1..l_r_tx_err.count
10131: LOOP
10132:
10133: fnd_file.put_line (fnd_file.log, l_approval_error
10134: || 'Invoice Validation did not process Invoice Id Due to Tax Error:' || l_r_tx_err(i).trx_id
10135: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10136: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10137:

Line 10136: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);

10132:
10133: fnd_file.put_line (fnd_file.log, l_approval_error
10134: || 'Invoice Validation did not process Invoice Id Due to Tax Error:' || l_r_tx_err(i).trx_id
10135: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10136: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10137:
10138: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10139: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Invoice Validation did not process Invoice Id Due to Tax Error:'
10140: || l_r_tx_err(i).trx_id);

Line 10152: FND_FILE.PUT_LINE(FND_FILE.LOG,'(SERIAL CALCULATE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854

10148:
10149: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_ETAX;
10150:
10151: -- Moved logging inside IF
10152: FND_FILE.PUT_LINE(FND_FILE.LOG,'(SERIAL CALCULATE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10153:
10154: l_blk_err := 'Y';
10155:
10156: ---------------------------------------------------------------------

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

10374: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
10375: --Bug9436217
10376: fnd_message.set_token('INV_NUM', l_selected_invoices_cursor(i).invoice_num);
10377: --Bug9436217
10378: fnd_file.put_line(fnd_file.log, fnd_message.get);
10379: END IF;
10380: --Bug9436217
10381: --END IF;
10382: --Bug9436217

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

10396:
10397: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10398:
10399: ap_utilities_pkg.ap_get_message(l_approval_error);
10400: fnd_file.put_line (fnd_file.log, ' ');
10401: --Bug9436217
10402: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10403: --Bug9436217
10404: fnd_file.put_line (fnd_file.log, l_error_code); --7392260

Line 10402: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);

10398:
10399: ap_utilities_pkg.ap_get_message(l_approval_error);
10400: fnd_file.put_line (fnd_file.log, ' ');
10401: --Bug9436217
10402: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10403: --Bug9436217
10404: fnd_file.put_line (fnd_file.log, l_error_code); --7392260
10405: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10406: --Bug9436217

Line 10404: fnd_file.put_line (fnd_file.log, l_error_code); --7392260

10400: fnd_file.put_line (fnd_file.log, ' ');
10401: --Bug9436217
10402: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10403: --Bug9436217
10404: fnd_file.put_line (fnd_file.log, l_error_code); --7392260
10405: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10406: --Bug9436217
10407: -- Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
10408: -- l_selected_invoices_cursor(i).invoice_num);

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

10401: --Bug9436217
10402: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10403: --Bug9436217
10404: fnd_file.put_line (fnd_file.log, l_error_code); --7392260
10405: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10406: --Bug9436217
10407: -- Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
10408: -- l_selected_invoices_cursor(i).invoice_num);
10409: IF g_debug_mode = 'Y' THEN

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

10422:
10423: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_INV;
10424:
10425: ap_utilities_pkg.ap_get_message(l_approval_error);
10426: fnd_file.put_line (fnd_file.log, ' ');
10427: --Bug9436217
10428: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10429: --Bug9436217
10430: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);

Line 10428: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);

10424:
10425: ap_utilities_pkg.ap_get_message(l_approval_error);
10426: fnd_file.put_line (fnd_file.log, ' ');
10427: --Bug9436217
10428: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10429: --Bug9436217
10430: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10431: --Bug9436217
10432: -- Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

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

10426: fnd_file.put_line (fnd_file.log, ' ');
10427: --Bug9436217
10428: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '|| l_selected_invoices_cursor(i).invoice_num);
10429: --Bug9436217
10430: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10431: --Bug9436217
10432: -- Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||
10433: -- l_selected_invoices_cursor(i).invoice_num);
10434: IF g_debug_mode = 'Y' THEN

Line 10471: fnd_file.put_line (fnd_file.log, l_approval_error

10467: --bug9738293
10468: FOR i in 1..l_r_tx_err.count
10469: LOOP
10470:
10471: fnd_file.put_line (fnd_file.log, l_approval_error
10472: || 'Invoice Validation did not process Invoice Id Due to Expected Tax Error :' || l_r_tx_err(i).trx_id
10473: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10474: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10475:

Line 10474: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);

10470:
10471: fnd_file.put_line (fnd_file.log, l_approval_error
10472: || 'Invoice Validation did not process Invoice Id Due to Expected Tax Error :' || l_r_tx_err(i).trx_id
10473: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10474: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10475:
10476: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10477: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Invoice Validation did not process Invoice Id Due to Expected Tax Error:'
10478: || l_r_tx_err(i).trx_id);

Line 10491: fnd_file.put_line (fnd_file.log, l_approval_error

10487: FROM zx_errors_gt;
10488: r_tx_err c_tx_err%rowtype;
10489: BEGIN
10490: FOR r_tx_err IN c_tx_err LOOP
10491: fnd_file.put_line (fnd_file.log, l_approval_error
10492: || 'Invoice Validation did not process Invoice Id:' || r_tx_err.trx_id
10493: || ', Line Number: ' || r_tx_err.trx_line_id);
10494: fnd_file.put_line (fnd_file.log, r_tx_err.message_text);
10495: Print_Debug (l_api_name, ' Invoice Validation did not process Invoice Id: '

Line 10494: fnd_file.put_line (fnd_file.log, r_tx_err.message_text);

10490: FOR r_tx_err IN c_tx_err LOOP
10491: fnd_file.put_line (fnd_file.log, l_approval_error
10492: || 'Invoice Validation did not process Invoice Id:' || r_tx_err.trx_id
10493: || ', Line Number: ' || r_tx_err.trx_line_id);
10494: fnd_file.put_line (fnd_file.log, r_tx_err.message_text);
10495: Print_Debug (l_api_name, ' Invoice Validation did not process Invoice Id: '
10496: || r_tx_err.trx_id);
10497: END LOOP;
10498: END; */

Line 10583: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk DISTRIBUTE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854

10579: delete from zx_errors_gt; --Flusing GT table
10580: delete from ap_errors_gt; --Flusing the AP GT table --bug10140354
10581:
10582: -- Moved logging inside loop
10583: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk DISTRIBUTE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10584:
10585: l_success := ap_etax_pkg.calling_etax (
10586: p_invoice_id => NULL,
10587: p_calling_mode => 'DISTRIBUTE',

Line 10592: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk DISTRIBUTE) END SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854

10588: p_all_error_messages => 'N',
10589: p_error_code => l_error_code,
10590: p_calling_sequence => l_curr_calling_sequence);
10591:
10592: FND_FILE.PUT_LINE(FND_FILE.LOG,'(Bulk DISTRIBUTE) END SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10593: -- Moved logging inside loop
10594:
10595: OPEN c_tx_err ;
10596: FETCH c_tx_err

Line 10625: fnd_file.put_line (fnd_file.log, l_approval_error

10621: l_conc_status := 'WARNING';
10622: FOR i in 1..l_r_tx_err.count
10623: LOOP
10624:
10625: fnd_file.put_line (fnd_file.log, l_approval_error
10626: || 'Invoice Validation did not process Invoice Id Due to Tax Error in Distribution :' || l_r_tx_err(i).trx_id
10627: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10628: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10629:

Line 10628: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);

10624:
10625: fnd_file.put_line (fnd_file.log, l_approval_error
10626: || 'Invoice Validation did not process Invoice Id Due to Tax Error in Distribution :' || l_r_tx_err(i).trx_id
10627: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10628: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10629:
10630: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10631: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Invoice Validation did not process Invoice Id Due to Tax Error in Distribution:'
10632: || l_r_tx_err(i).trx_id);

Line 10677: FND_FILE.PUT_LINE(FND_FILE.LOG,'(SERIAL DISTRIBUTE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854

10673: ---------------------------------------------------------------------
10674:
10675: --Bug9436217
10676:
10677: FND_FILE.PUT_LINE(FND_FILE.LOG,'(SERIAL DISTRIBUTE) START SYSDATE '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS')); --Bug16390854
10678:
10679: l_selected_invoices_cursor.DELETE ;
10680: OPEN SELECTED_INVOICES_CURSOR ;
10681: FETCH SELECTED_INVOICES_CURSOR

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

10802: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
10803: --Bug9436217
10804: fnd_message.set_token('INV_NUM', l_selected_invoices_cursor(i).invoice_num);
10805: --Bug9436217
10806: fnd_file.put_line(fnd_file.log, fnd_message.get);
10807: END IF;
10808: --Bug9436217
10809: --END IF;
10810: --Bug9436217

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

10826: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10827:
10828: ap_utilities_pkg.ap_get_message(l_approval_error);
10829:
10830: fnd_file.put_line (fnd_file.log, ' ');
10831:
10832: --Bug9436217
10833:
10834: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||

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

10830: fnd_file.put_line (fnd_file.log, ' ');
10831:
10832: --Bug9436217
10833:
10834: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
10835: l_selected_invoices_cursor(i).invoice_num);
10836: --Bug9436217
10837:
10838: fnd_file.put_line (fnd_file.log, l_error_code); --7392260

Line 10838: fnd_file.put_line (fnd_file.log, l_error_code); --7392260

10834: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
10835: l_selected_invoices_cursor(i).invoice_num);
10836: --Bug9436217
10837:
10838: fnd_file.put_line (fnd_file.log, l_error_code); --7392260
10839: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10840:
10841: --Bug9436217
10842:

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

10835: l_selected_invoices_cursor(i).invoice_num);
10836: --Bug9436217
10837:
10838: fnd_file.put_line (fnd_file.log, l_error_code); --7392260
10839: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10840:
10841: --Bug9436217
10842:
10843: -- Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

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

10859: ROLLBACK TO SAVEPOINT AP_APPROVAL_PKG_SP_TAX_DIST;
10860:
10861: ap_utilities_pkg.ap_get_message(l_approval_error);
10862:
10863: fnd_file.put_line (fnd_file.log, ' ');
10864:
10865: --Bug9436217
10866:
10867: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||

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

10863: fnd_file.put_line (fnd_file.log, ' ');
10864:
10865: --Bug9436217
10866:
10867: fnd_file.put_line (fnd_file.log, l_approval_error || 'Invoice Validation did not process Invoice Number: '||
10868: l_selected_invoices_cursor(i).invoice_num);
10869:
10870: --Bug9436217
10871:

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

10869:
10870: --Bug9436217
10871:
10872:
10873: fnd_file.put_line (fnd_file.log, ' Error: ' ||sqlerrm);
10874:
10875: --Bug9436217
10876:
10877: -- Print_Debug (l_api_name, 'Exception: '|| sqlerrm ||' Invoice Validation did not process Invoice Number: '||

Line 10915: fnd_file.put_line (fnd_file.log, l_approval_error

10911: --bug9738293
10912: FOR i in 1..l_r_tx_err.count
10913: LOOP
10914:
10915: fnd_file.put_line (fnd_file.log, l_approval_error
10916: || 'Invoice Validation did not process Invoice Id Due to Expected Tax Error in Distribution :' || l_r_tx_err(i).trx_id
10917: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10918: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10919:

Line 10918: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);

10914:
10915: fnd_file.put_line (fnd_file.log, l_approval_error
10916: || 'Invoice Validation did not process Invoice Id Due to Expected Tax Error in Distribution :' || l_r_tx_err(i).trx_id
10917: || ', Line Number: ' || l_r_tx_err(i).trx_line_id);
10918: fnd_file.put_line (fnd_file.log, l_r_tx_err(i).message_text);
10919:
10920: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
10921: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,' Invoice Validation did not process Invoice Id Due to Expected Tax Error in Distribution:'
10922: || l_r_tx_err(i).trx_id);

Line 10935: fnd_file.put_line (fnd_file.log, l_approval_error

10931: FROM zx_errors_gt;
10932: r_tx_err c_tx_err%rowtype;
10933: BEGIN
10934: FOR r_tx_err IN c_tx_err LOOP
10935: fnd_file.put_line (fnd_file.log, l_approval_error
10936: || 'Invoice Validation did not process Invoice Id:' || r_tx_err.trx_id
10937: || ', Line Number: ' || r_tx_err.trx_line_id);
10938: fnd_file.put_line (fnd_file.log, r_tx_err.message_text);
10939: Print_Debug (l_api_name, ' Invoice Validation did not process Invoice Id: '

Line 10938: fnd_file.put_line (fnd_file.log, r_tx_err.message_text);

10934: FOR r_tx_err IN c_tx_err LOOP
10935: fnd_file.put_line (fnd_file.log, l_approval_error
10936: || 'Invoice Validation did not process Invoice Id:' || r_tx_err.trx_id
10937: || ', Line Number: ' || r_tx_err.trx_line_id);
10938: fnd_file.put_line (fnd_file.log, r_tx_err.message_text);
10939: Print_Debug (l_api_name, ' Invoice Validation did not process Invoice Id: '
10940: || r_tx_err.trx_id);
10941: END LOOP;
10942: END; */

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

11040:
11041: ELSE
11042: fnd_message.set_name('SQLAP', 'AP_INV_NEVER_OPEN_PERIOD');
11043: fnd_message.set_token('INV_NUM', AP_APPROVAL_PKG.G_SELECTED_INVOICES(i).invoice_num);
11044: fnd_file.put_line(fnd_file.log, fnd_message.get);
11045: END IF;
11046:
11047: END LOOP;
11048:

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

11137: EXCEPTION
11138:
11139: WHEN TAX_EXCEPTION THEN
11140: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
11141: fnd_file.put_line(fnd_file.log,l_approval_error);
11142: fnd_file.put_line(fnd_file.log,sqlerrm);
11143: -- Print_Debug(l_api_name, 'Exception: '||sqlerrm);
11144: IF g_debug_mode = 'Y' THEN
11145: AP_Debug_Pkg.Print(g_debug_mode, 'Exception: '||sqlerrm );

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

11138:
11139: WHEN TAX_EXCEPTION THEN
11140: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
11141: fnd_file.put_line(fnd_file.log,l_approval_error);
11142: fnd_file.put_line(fnd_file.log,sqlerrm);
11143: -- Print_Debug(l_api_name, 'Exception: '||sqlerrm);
11144: IF g_debug_mode = 'Y' THEN
11145: AP_Debug_Pkg.Print(g_debug_mode, 'Exception: '||sqlerrm );
11146: END IF;

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

11176: RETURN (FALSE);
11177:
11178: WHEN OTHERS THEN
11179: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
11180: fnd_file.put_line(fnd_file.log,l_approval_error);
11181: fnd_file.put_line(fnd_file.log,sqlerrm);
11182: -- Print_Debug(l_api_name, 'Others: Exception: '||sqlerrm);
11183: IF g_debug_mode = 'Y' THEN
11184: AP_Debug_Pkg.Print(g_debug_mode, 'Others: Exception: '||sqlerrm );

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

11177:
11178: WHEN OTHERS THEN
11179: AP_UTILITIES_PKG.AP_GET_MESSAGE(l_approval_error);
11180: fnd_file.put_line(fnd_file.log,l_approval_error);
11181: fnd_file.put_line(fnd_file.log,sqlerrm);
11182: -- Print_Debug(l_api_name, 'Others: Exception: '||sqlerrm);
11183: IF g_debug_mode = 'Y' THEN
11184: AP_Debug_Pkg.Print(g_debug_mode, 'Others: Exception: '||sqlerrm );
11185: END IF;

Line 12525: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

12521: FOR i IN 1..l_vendor_id_list.count LOOP
12522:
12523: l_debug_info := 'Before Submitting Request for vendor id: '||l_vendor_id_list(i) ;
12524: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
12525: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
12526: END IF;
12527:
12528:
12529: l_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 12546: fnd_file.put_line(FND_FILE.LOG,l_debug_info);

12542: );
12543:
12544: l_debug_info := 'request_id ='||to_char(l_request_id);
12545: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
12546: fnd_file.put_line(FND_FILE.LOG,l_debug_info);
12547: END IF;
12548:
12549: COMMIT;
12550: