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 FV_UTILITY

Line 113: FV_utility.get_ledger_info(mo_global.get_current_org_id,parm_set_of_books_id,

109:
110:
111: -- Derive SOB,COA
112:
113: FV_utility.get_ledger_info(mo_global.get_current_org_id,parm_set_of_books_id,
114: parm_chart_of_accounts_id,
115: l_currency,l_status);
116: If l_status = 0 then
117:

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 196: ---FV_UTILITY.DEBUG_MESG('Start a100_clear_report_temp_table');

192: --
193: l_module_name VARCHAR2(200) ;
194: BEGIN
195: --
196: ---FV_UTILITY.DEBUG_MESG('Start a100_clear_report_temp_table');
197: --
198: l_module_name := g_module_name || 'a100_clear_report_temp_table';
199:
200: BEGIN

Line 204: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_HEADER_TEMP');

200: BEGIN
201:
202: DELETE
203: FROM FV_SF1080_HEADER_TEMP;
204: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_HEADER_TEMP');
205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: NULL;
208: WHEN OTHERS THEN

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 217: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_DETAIL_TEMP');

213:
214: BEGIN
215: DELETE
216: FROM FV_SF1080_DETAIL_TEMP;
217: ---FV_UTILITY.DEBUG_MESG('Deleting from FV_SF1080_DETAIL_TEMP');
218: EXCEPTION
219: WHEN NO_DATA_FOUND THEN
220: NULL;
221: WHEN OTHERS THEN

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 330: ---FV_UTILITY.DEBUG_MESG('Start a200_load_report_tables');

326:
327: l_module_name := g_module_name || 'a200_load_report_tables';
328:
329: --
330: ---FV_UTILITY.DEBUG_MESG('Start a200_load_report_tables');
331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);
332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);

Line 331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);

327: l_module_name := g_module_name || 'a200_load_report_tables';
328:
329: --
330: ---FV_UTILITY.DEBUG_MESG('Start a200_load_report_tables');
331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);
332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);

Line 332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);

328:
329: --
330: ---FV_UTILITY.DEBUG_MESG('Start a200_load_report_tables');
331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);
332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);

Line 333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);

329: --
330: ---FV_UTILITY.DEBUG_MESG('Start a200_load_report_tables');
331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);
332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);

Line 334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);

330: ---FV_UTILITY.DEBUG_MESG('Start a200_load_report_tables');
331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);
332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);

Line 335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);

331: ---FV_UTILITY.DEBUG_MESG('parm_chart_of_accounts_id = ' || parm_chart_of_accounts_id);
332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);

Line 336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);

332: ---FV_UTILITY.DEBUG_MESG('parm_set_of_books_id = ' || parm_set_of_books_id);
333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);

Line 337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);

333: ---FV_UTILITY.DEBUG_MESG('parm_order_by = ' || parm_order_by);
334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);

Line 338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);

334: ---FV_UTILITY.DEBUG_MESG('parm_batch = ' || parm_batch);
335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);

Line 339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);

335: ---FV_UTILITY.DEBUG_MESG('parm_transaction_class = ' || parm_transaction_class);
336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);

Line 340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);

336: ---FV_UTILITY.DEBUG_MESG('parm_transaction_type = ' || parm_transaction_type);
337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);
344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);

Line 341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);

337: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_low = ' || parm_trans_num_low);
338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);
344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);
345: ---FV_UTILITY.DEBUG_MESG('parm_print_choice = ' || parm_print_choice);

Line 342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);

338: ---FV_UTILITY.DEBUG_MESG('parm_trans_num_high = ' || parm_trans_num_high);
339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);
344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);
345: ---FV_UTILITY.DEBUG_MESG('parm_print_choice = ' || parm_print_choice);
346:

Line 343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);

339: ---FV_UTILITY.DEBUG_MESG('parm_print_date_low = ' || parm_print_date_low);
340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);
344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);
345: ---FV_UTILITY.DEBUG_MESG('parm_print_choice = ' || parm_print_choice);
346:
347: --

Line 344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);

340: ---FV_UTILITY.DEBUG_MESG('parm_print_date_high = ' || parm_print_date_high);
341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);
344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);
345: ---FV_UTILITY.DEBUG_MESG('parm_print_choice = ' || parm_print_choice);
346:
347: --
348: -- This for loop selects the remit address and then inserts into FV_SF1080_

Line 345: ---FV_UTILITY.DEBUG_MESG('parm_print_choice = ' || parm_print_choice);

341: ---FV_UTILITY.DEBUG_MESG('parm_customer_class = ' || parm_customer_class);
342: ---FV_UTILITY.DEBUG_MESG('parm_customer = ' || parm_customer);
343: ---FV_UTILITY.DEBUG_MESG('parm_open_invoices_only = ' || parm_open_invoices_only);
344: ---FV_UTILITY.DEBUG_MESG('parm_office_charged = ' || parm_office_charged);
345: ---FV_UTILITY.DEBUG_MESG('parm_print_choice = ' || parm_print_choice);
346:
347: --
348: -- This for loop selects the remit address and then inserts into FV_SF1080_
349: -- HEADER_TEMP table based on cursor records.

Line 353: ---FV_UTILITY.DEBUG_MESG('Inside the header cursor');

349: -- HEADER_TEMP table based on cursor records.
350: ---
351: FOR ts_report_header_entry IN ts_report_header_cursor LOOP
352: --
353: ---FV_UTILITY.DEBUG_MESG('Inside the header cursor');
354: ---FV_UTILITY.DEBUG_MESG('customer_trx_id = '||TS_REPORT_HEADER_ENTRY.customer_trx_id);
355:
356: BEGIN
357: SELECT ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,CITY,STATE,POSTAL_CODE

Line 354: ---FV_UTILITY.DEBUG_MESG('customer_trx_id = '||TS_REPORT_HEADER_ENTRY.customer_trx_id);

350: ---
351: FOR ts_report_header_entry IN ts_report_header_cursor LOOP
352: --
353: ---FV_UTILITY.DEBUG_MESG('Inside the header cursor');
354: ---FV_UTILITY.DEBUG_MESG('customer_trx_id = '||TS_REPORT_HEADER_ENTRY.customer_trx_id);
355:
356: BEGIN
357: SELECT ADDRESS1,ADDRESS2,ADDRESS3,ADDRESS4,CITY,STATE,POSTAL_CODE
358: INTO REMIT_ADDRESS1,REMIT_ADDRESS2,REMIT_ADDRESS3,REMIT_ADDRESS4,

Line 365: ---FV_UTILITY.DEBUG_MESG('remit_address1 = '||REMIT_ADDRESS1);

361: WHERE hzcas.cust_Acct_site_id =
362: TS_REPORT_HEADER_ENTRY.REMIT_TO_ADDRESS_ID
363: AND hzcas.party_site_id = hzps.party_site_id
364: AND hzps.location_id = hzl.location_id;
365: ---FV_UTILITY.DEBUG_MESG('remit_address1 = '||REMIT_ADDRESS1);
366: ---FV_UTILITY.DEBUG_MESG('remit_address2 = '||REMIT_ADDRESS2);
367: ---FV_UTILITY.DEBUG_MESG('remit_address3 = '||REMIT_ADDRESS3);
368: ---FV_UTILITY.DEBUG_MESG('remit_address4 = '||REMIT_ADDRESS4);
369: EXCEPTION

Line 366: ---FV_UTILITY.DEBUG_MESG('remit_address2 = '||REMIT_ADDRESS2);

362: TS_REPORT_HEADER_ENTRY.REMIT_TO_ADDRESS_ID
363: AND hzcas.party_site_id = hzps.party_site_id
364: AND hzps.location_id = hzl.location_id;
365: ---FV_UTILITY.DEBUG_MESG('remit_address1 = '||REMIT_ADDRESS1);
366: ---FV_UTILITY.DEBUG_MESG('remit_address2 = '||REMIT_ADDRESS2);
367: ---FV_UTILITY.DEBUG_MESG('remit_address3 = '||REMIT_ADDRESS3);
368: ---FV_UTILITY.DEBUG_MESG('remit_address4 = '||REMIT_ADDRESS4);
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN

Line 367: ---FV_UTILITY.DEBUG_MESG('remit_address3 = '||REMIT_ADDRESS3);

363: AND hzcas.party_site_id = hzps.party_site_id
364: AND hzps.location_id = hzl.location_id;
365: ---FV_UTILITY.DEBUG_MESG('remit_address1 = '||REMIT_ADDRESS1);
366: ---FV_UTILITY.DEBUG_MESG('remit_address2 = '||REMIT_ADDRESS2);
367: ---FV_UTILITY.DEBUG_MESG('remit_address3 = '||REMIT_ADDRESS3);
368: ---FV_UTILITY.DEBUG_MESG('remit_address4 = '||REMIT_ADDRESS4);
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: REMIT_ADDRESS1 := ' ';

Line 368: ---FV_UTILITY.DEBUG_MESG('remit_address4 = '||REMIT_ADDRESS4);

364: AND hzps.location_id = hzl.location_id;
365: ---FV_UTILITY.DEBUG_MESG('remit_address1 = '||REMIT_ADDRESS1);
366: ---FV_UTILITY.DEBUG_MESG('remit_address2 = '||REMIT_ADDRESS2);
367: ---FV_UTILITY.DEBUG_MESG('remit_address3 = '||REMIT_ADDRESS3);
368: ---FV_UTILITY.DEBUG_MESG('remit_address4 = '||REMIT_ADDRESS4);
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: REMIT_ADDRESS1 := ' ';
372: REMIT_ADDRESS2 := NULL;

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 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 443: ---FV_UTILITY.DEBUG_MESG('line_count = ' ||line_count);

439: SELECT COUNT(*)
440: INTO LINE_COUNT
441: FROM RA_CUSTOMER_TRX_LINES
442: WHERE CUSTOMER_TRX_ID = TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID;
443: ---FV_UTILITY.DEBUG_MESG('line_count = ' ||line_count);
444: EXCEPTION
445: WHEN NO_DATA_FOUND THEN
446: line_count_flag := 1;
447: WHEN OTHERS THEN

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 503: ---FV_UTILITY.DEBUG_MESG('line_count= '||line_count);

499:
500:
501: BEGIN
502: LINE_COUNTER := 1;
503: ---FV_UTILITY.DEBUG_MESG('line_count= '||line_count);
504: ---FV_UTILITY.DEBUG_MESG('line_counter = '||line_counter);
505: ---FV_UTILITY.DEBUG_MESG('line_count_flag = '||line_count_flag);
506: IF LINE_COUNT > 1 AND line_count_flag = 0 THEN
507: ---FV_UTILITY.DEBUG_MESG('Inside the multi line if statement');

Line 504: ---FV_UTILITY.DEBUG_MESG('line_counter = '||line_counter);

500:
501: BEGIN
502: LINE_COUNTER := 1;
503: ---FV_UTILITY.DEBUG_MESG('line_count= '||line_count);
504: ---FV_UTILITY.DEBUG_MESG('line_counter = '||line_counter);
505: ---FV_UTILITY.DEBUG_MESG('line_count_flag = '||line_count_flag);
506: IF LINE_COUNT > 1 AND line_count_flag = 0 THEN
507: ---FV_UTILITY.DEBUG_MESG('Inside the multi line if statement');
508: BEGIN

Line 505: ---FV_UTILITY.DEBUG_MESG('line_count_flag = '||line_count_flag);

501: BEGIN
502: LINE_COUNTER := 1;
503: ---FV_UTILITY.DEBUG_MESG('line_count= '||line_count);
504: ---FV_UTILITY.DEBUG_MESG('line_counter = '||line_counter);
505: ---FV_UTILITY.DEBUG_MESG('line_count_flag = '||line_count_flag);
506: IF LINE_COUNT > 1 AND line_count_flag = 0 THEN
507: ---FV_UTILITY.DEBUG_MESG('Inside the multi line if statement');
508: BEGIN
509: FOR LINE_COUNTER IN 1..LINE_COUNT LOOP

Line 507: ---FV_UTILITY.DEBUG_MESG('Inside the multi line if statement');

503: ---FV_UTILITY.DEBUG_MESG('line_count= '||line_count);
504: ---FV_UTILITY.DEBUG_MESG('line_counter = '||line_counter);
505: ---FV_UTILITY.DEBUG_MESG('line_count_flag = '||line_count_flag);
506: IF LINE_COUNT > 1 AND line_count_flag = 0 THEN
507: ---FV_UTILITY.DEBUG_MESG('Inside the multi line if statement');
508: BEGIN
509: FOR LINE_COUNTER IN 1..LINE_COUNT LOOP
510: INSERT INTO FV_SF1080_DETAIL_TEMP
511: (

Line 540: ---FV_UTILITY.DEBUG_MESG('Inside the single line if statement');

536: END LOOP; --- for loop ended
537:
538: END;
539: ELSIF LINE_COUNT = 1 AND line_count_flag = 0 THEN
540: ---FV_UTILITY.DEBUG_MESG('Inside the single line if statement');
541: INSERT INTO FV_SF1080_DETAIL_TEMP
542: (
543: CUSTOMER_TRX_ID,
544: LINE_NUMBER,

Line 568: ---FV_UTILITY.DEBUG_MESG('End of multiple line invoice loop.');

564: TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID;
565: END IF;
566: END;
567: END LOOP;
568: ---FV_UTILITY.DEBUG_MESG('End of multiple line invoice loop.');
569: commit;
570: --
571: -- ------------------------------------
572: -- Exceptions

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: --