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.FV_SF1080_TRANSACTION dependencies on FND_LOG

Line 145: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_request_id is'||l_request_id);

141: sub_request => FALSE,
142: argument1 => parm_set_of_books_id,
143: argument2 => order_by);
144: IF (l_request_id = 0) THEN
145: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_request_id is'||l_request_id);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'argument1 is'||parm_set_of_books_id);
147: RAISE report_failure;
148: ELSE
149: COMMIT;

Line 146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'argument1 is'||parm_set_of_books_id);

142: argument1 => parm_set_of_books_id,
143: argument2 => order_by);
144: IF (l_request_id = 0) THEN
145: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'l_request_id is'||l_request_id);
146: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'argument1 is'||parm_set_of_books_id);
147: RAISE report_failure;
148: ELSE
149: COMMIT;
150: END IF;

Line 171: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.abort_error',g_error_message);

167: --
168: WHEN abort_error THEN
169: error_code := g_error_code;
170: error_message := g_error_message;
171: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.abort_error',g_error_message);
172:
173: --- in case the report submission is not successful ---
174: WHEN report_failure THEN
175: g_error_message := 'Submission of FVSF1080 Report failed';

Line 176: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.report_failure',g_error_message);

172:
173: --- in case the report submission is not successful ---
174: WHEN report_failure THEN
175: g_error_message := 'Submission of FVSF1080 Report failed';
176: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.report_failure',g_error_message);
177:
178: WHEN OTHERS THEN
179: g_error_code := SQLCODE;
180: g_error_message := SQLERRM;

Line 181: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);

177:
178: WHEN OTHERS THEN
179: g_error_code := SQLCODE;
180: g_error_message := SQLERRM;
181: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);
182: RAISE_APPLICATION_ERROR(-20222,
183: 'FVSF1080 Exception-'||g_error_message);
184: --
185: END a000_load_table;

Line 211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',g_error_message);

207: NULL;
208: WHEN OTHERS THEN
209: g_error_code := SQLCODE;
210: g_error_message := 'a100_clear_report_header_table: /'||SQLERRM;
211: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',g_error_message);
212: END;
213:
214: BEGIN
215: DELETE

Line 224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);

220: NULL;
221: WHEN OTHERS THEN
222: g_error_code := SQLCODE;
223: g_error_message := 'a100_clear_report_detail_table: /'||SQLERRM;
224: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);
225: END;
226: --
227: COMMIT;
228: --

Line 381: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error3',g_error_message);

377: REMIT_POSTAL_CODE := NULL;
378: WHEN OTHERS THEN
379: g_error_code := SQLCODE;
380: g_error_message := 'remit_address_info: /'||SQLERRM;
381: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error3',g_error_message);
382: END;
383:
384: Begin
385: INSERT INTO FV_SF1080_HEADER_TEMP

Line 427: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',g_error_message);

423: EXCEPTION
424: WHEN OTHERS THEN
425: g_error_code := SQLCODE;
426: g_error_message := 'INSERT_HEADER_info: /'||SQLERRM;
427: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',g_error_message);
428: END;
429:
430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);

Line 430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

426: g_error_message := 'INSERT_HEADER_info: /'||SQLERRM;
427: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',g_error_message);
428: END;
429:
430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRX_NUMBER = ' ||TS_REPORT_HEADER_ENTRY.TRX_NUMBER);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_NAME = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_NAME);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUST_POSTAL_CODE = ' || TS_REPORT_HEADER_ENTRY.CUST_POSTAL_CODE);

Line 431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);

427: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',g_error_message);
428: END;
429:
430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRX_NUMBER = ' ||TS_REPORT_HEADER_ENTRY.TRX_NUMBER);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_NAME = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_NAME);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUST_POSTAL_CODE = ' || TS_REPORT_HEADER_ENTRY.CUST_POSTAL_CODE);
435: END IF;

Line 432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRX_NUMBER = ' ||TS_REPORT_HEADER_ENTRY.TRX_NUMBER);

428: END;
429:
430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRX_NUMBER = ' ||TS_REPORT_HEADER_ENTRY.TRX_NUMBER);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_NAME = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_NAME);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUST_POSTAL_CODE = ' || TS_REPORT_HEADER_ENTRY.CUST_POSTAL_CODE);
435: END IF;
436: BEGIN

Line 433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_NAME = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_NAME);

429:
430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRX_NUMBER = ' ||TS_REPORT_HEADER_ENTRY.TRX_NUMBER);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_NAME = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_NAME);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUST_POSTAL_CODE = ' || TS_REPORT_HEADER_ENTRY.CUST_POSTAL_CODE);
435: END IF;
436: BEGIN
437: LINE_COUNT := 0;

Line 434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUST_POSTAL_CODE = ' || TS_REPORT_HEADER_ENTRY.CUST_POSTAL_CODE);

430: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_TRX_ID = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID);
432: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRX_NUMBER = ' ||TS_REPORT_HEADER_ENTRY.TRX_NUMBER);
433: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUSTOMER_NAME = ' || TS_REPORT_HEADER_ENTRY.CUSTOMER_NAME);
434: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CUST_POSTAL_CODE = ' || TS_REPORT_HEADER_ENTRY.CUST_POSTAL_CODE);
435: END IF;
436: BEGIN
437: LINE_COUNT := 0;
438: line_count_flag := 0;

Line 450: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',g_error_message);

446: line_count_flag := 1;
447: WHEN OTHERS THEN
448: g_error_code := SQLCODE;
449: g_error_message := 'line_count_info: /'||SQLERRM;
450: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',g_error_message);
451: END;
452:
453: BEGIN
454: segment := NULL;

Line 579: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);

575: --
576: WHEN OTHERS THEN
577: g_error_code := SQLCODE;
578: g_error_message := SQLERRM;
579: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',g_error_message);
580: IF ts_report_header_cursor%ISOPEN THEN
581: close ts_report_header_cursor;
582: END IF;
583: --