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_PURGED_TREASURY_SYMBOLS dependencies on FND_LOG

Line 144: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' Inside Main');

140: gbl_year_established := n_year_established ;
141: gbl_new_established_year := new_established_year ;
142: gbl_request_id := fnd_global.conc_request_id;
143: ---gbl_purge_cancel_flg := purge_cancel_flg;
144: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' Inside Main');
145:
146: SELECT chart_of_accounts_id, period_set_name
147: INTO gbl_account_id , gbl_period_set_name
148: FROM gl_ledgers_public_v GL

Line 167: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);

163: exception
164: WHEN e_Invalid_Bal_segment THEN
165: retcode := 2 ;
166: errbuf := 'GET SEGMENT NAME - Error Reading Balancing Segments' ;
167: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);
168: return;
169: END;
170: ------To get the Accounting Segment Name ------------------------
171: BEGIN

Line 183: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);

179: exception
180: WHEN e_Invalid_Bal_segment THEN
181: retcode := 2 ;
182: errbuf := 'GET SEGMENT NAME - Error Reading accounting Segments' ;
183: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);
184: return;
185: END;
186:
187: ----To get the Accounting Segment Number---------

Line 203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);

199: exception
200: WHEN e_Invalid_Bal_segment THEN
201: retcode := 2 ;
202: errbuf := 'GET SEGMENT NUMBER- Error Reading accounting Segments' ;
203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,errbuf);
204: return;
205: END;
206:
207:

Line 249: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Balance or Unposted Transactions exists for Fund Values against Treasury Symbol: ' || c1_treasury_symb.treasury_symbol );

245: exit;
246: end if;
247: IF (n_balance <> 0 ) or (n_cnt > 0) then
248: v_open_flag := 'Y';
249: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'Balance or Unposted Transactions exists for Fund Values against Treasury Symbol: ' || c1_treasury_symb.treasury_symbol );
250:
251: exit;
252: END IF;
253: end loop; ----End of second cursor------

Line 260: ---- FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,gbl_error_buf);

256: end if;
257: if gbl_cursor_cnt =1 then
258: errbuf := ' No Fund value is defined for Treasury Symbol:'||c1_treasury_symb.treasury_symbol;
259: retcode := 1;
260: ---- FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name ,gbl_error_buf);
261: end if;
262: if v_result = false then
263: if gbl_error_code = 0 then
264: Populate_history_tab(c1_treasury_symb.treasury_symbol_id ,v_open_flag);

Line 289: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_ERROR, l_module_name || gbl_error_code,gbl_error_buf);

285: IF (gbl_error_code <> 0) THEN
286: errbuf := gbl_error_buf;
287: retcode := 2;
288: ROLLBACK;
289: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_ERROR, l_module_name || gbl_error_code,gbl_error_buf);
290: return;
291: ELSE
292: COMMIT;
293: /*---------------------------------------------------------------+

Line 312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);

308: gbl_cancellation_date) ;
309: IF l_request_id = 0 then
310: gbl_error_code := '2';
311: gbl_error_buf := 'Cannot submit Purge Treasury Symbol Report';
312: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
313: ELSE
314: COMMIT;
315: END IF;
316:

Line 328: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error4', gbl_error_buf) ;

324: message => v_message);
325: IF v_wait_req_status = FALSE THEN
326: gbl_error_buf := 'Cannot wait for the status of Purge Treasury Symbols Report';
327: retcode := -1;
328: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error4', gbl_error_buf) ;
329: return;
330: END IF;
331:
332: v_req_status := FND_CONCURRENT.GET_REQUEST_STATUS(request_id => l_request_id,

Line 381: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside populate_history_tab');

377: l_module_name VARCHAR2(200):='POPULATE_HISTORY_TAB';
378: begin
379: BEGIN
380: ---dbms_output.put_line('inside populate_history_tab');
381: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside populate_history_tab');
382: insert ALL into fv_treasury_symbols_history
383: (treasury_symbol_id,
384: treasury_symbol,
385: set_of_books_id,

Line 430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: gbl_error_code := SQLCODE;
429: gbl_error_buf := SQLERRM ||'-- Error No Data Found in populate_history_tab while populating symbol history table';
430: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
431: return;
432: WHEN OTHERS THEN
433: gbl_error_code := SQLCODE;
434: gbl_error_buf := SQLERRM ||

Line 436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

432: WHEN OTHERS THEN
433: gbl_error_code := SQLCODE;
434: gbl_error_buf := SQLERRM ||
435: ' -- Error in populate_history_tab when Inserting';
436: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
437: return;
438: END;
439: BEGIN
440: insert ALL into fv_fund_parameters_history

Line 491: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,gbl_error_buf);

487: WHEN NO_DATA_FOUND THEN
488: --gbl_error_code := SQLCODE;
489: --- dbms_output.put_line('No fund found for treasury symbol:'||gbl_treasury_symbol_id);
490: gbl_error_buf := '--No Fund value defined for Treasury_symbol : '||gbl_treasury_symbol_id;
491: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,gbl_error_buf);
492: return;
493: WHEN OTHERS THEN
494: gbl_error_code := SQLCODE;
495: gbl_error_buf := SQLERRM ||

Line 497: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

493: WHEN OTHERS THEN
494: gbl_error_code := SQLCODE;
495: gbl_error_buf := SQLERRM ||
496: ' -- Error in populate_history_tab while Inserting';
497: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
498: return;
499: END;
500: end populate_history_tab;
501:

Line 538: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside update_history_tab');

534: procedure update_history_tab(tres_id number,v_flag varchar2) is
535: l_module_name VARCHAR2(200) := g_module_name || 'UPDATE_HISTORY_TAB';
536: begin
537: ----dbms_output.put_line(' inside update_history_tab');
538: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside update_history_tab');
539: IF v_flag in ('Y','N') then
540: ---dbms_output.put_line(' inside update_history_tab updating for flag <>d');
541: update fv_treasury_symbols_history
542: set open_flag = v_flag ,

Line 583: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',gbl_error_buf);

579: EXCEPTION
580: WHEN NO_DATA_FOUND THEN
581: gbl_error_code := SQLCODE;
582: gbl_error_buf := SQLERRM;
583: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.final_exception',gbl_error_buf);
584: return;
585: WHEN OTHERS THEN
586: gbl_error_code := SQLCODE;
587: gbl_error_buf := SQLERRM;

Line 588: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',gbl_error_buf);

584: return;
585: WHEN OTHERS THEN
586: gbl_error_code := SQLCODE;
587: gbl_error_buf := SQLERRM;
588: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.final_exception',gbl_error_buf);
589: return;
590: end update_history_tab;
591:
592: -- *----------------------------------------------------------------------* --

Line 622: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' Inside ins_delete_treasury_symbols');

618: where set_of_books_id = gbl_set_of_books_id
619: and treasury_symbol_id = tres_id;*/
620: BEGIN
621: --dbms_output.put_line('inside ins_delete_treasury_symbols');
622: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' Inside ins_delete_treasury_symbols');
623: gbl_cursor_cnt := 0;
624: for c1 in c1_treas_symbol
625: loop
626: gbl_cursor_cnt := 2;

Line 629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Unable To Purge Treasury Symbol '||c1.treasury_symbol ||' as Balances or Unposted Transactions found.');

625: loop
626: gbl_cursor_cnt := 2;
627: gbl_treasury_symbol_id := c1.treasury_symbol_id;
628: IF c1.open_flag = 'Y' then
629: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,'Unable To Purge Treasury Symbol '||c1.treasury_symbol ||' as Balances or Unposted Transactions found.');
630: -- for c2 in c2_fund_param_hist(c1.treasury_symbol_id)
631: -- loop
632: --- calculate_gl_balances(c2.fund_value,n_balance,n_cnt);
633:

Line 662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);

658: WHEN OTHERS THEN
659: gbl_error_code := SQLCODE;
660: gbl_error_buf := SQLERRM ||
661: ' -- Error in Delete_treasury_symbols when deleting treasury symbol' ;
662: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);
663: END ins_delete_treasury_symbols;
664:
665: -- *----------------------------------------------------------------------* --
666: -- * PROCEDURE CALCULATE_GL_BALANCES * --

Line 721: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);

717: WHEN OTHERS THEN
718: gbl_error_code := SQLCODE;
719: gbl_error_buf := SQLERRM ||
720: ' -- Error in Calculate_Gl_Balances when finding balances and transactions for fund value';
721: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);
722: END;
723: -------------------------------------------------------------------------------------
724: ------***** To check if there any transaction unposted against the fund value *****------------
725: BEGIN

Line 759: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);

755: WHEN OTHERS THEN
756: gbl_error_code := SQLCODE;
757: gbl_error_buf := SQLERRM ||
758: ' -- Error in Calculate_Gl_Balances while finding transactions for fund value';
759: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);
760: END;
761: END calculate_gl_balances;
762:
763: -- *----------------------------------------------------------------------* --

Line 791: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',gbl_error_buf);

787:
788: gbl_error_code := SQLCODE;
789: gbl_error_buf := SQLERRM ||
790: ' -- Error in get_period_year finding current fiscal year';
791: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||'.error1',gbl_error_buf);
792:
793: WHEN OTHERS THEN
794: gbl_error_code := SQLCODE;
795: gbl_error_buf := SQLERRM ||

Line 797: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',gbl_error_buf);

793: WHEN OTHERS THEN
794: gbl_error_code := SQLCODE;
795: gbl_error_buf := SQLERRM ||
796: ' -- Error in Calculate_Gl_Balances when finding balances and transactions for fund value';
797: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',gbl_error_buf);
798: END get_period_year;
799:
800: -- *----------------------------------------------------------------------* --
801: -- * PROCEDURE DELETE_TREASURY_SYMBOLS * --

Line 825: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);

821: WHEN NO_DATA_FOUND THEN
822: --gbl_error_code := SQLCODE;
823: gbl_error_buf := SQLERRM ||
824: ' -- Error no-data-found of fund value in delete_treasury_symbols for treasury symbol '||gbl_treasury_symbol_id;
825: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);
826: WHEN OTHERS THEN
827: gbl_error_code := SQLCODE;
828: gbl_error_buf := SQLERRM ||
829: ' -- Error in delete_treasury_symbols while deleting Treasury symbols from Fund Parameters';

Line 830: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);

826: WHEN OTHERS THEN
827: gbl_error_code := SQLCODE;
828: gbl_error_buf := SQLERRM ||
829: ' -- Error in delete_treasury_symbols while deleting Treasury symbols from Fund Parameters';
830: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);
831: return;
832: END;
833:
834: BEGIN

Line 848: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);

844: WHEN NO_DATA_FOUND THEN
845: gbl_error_code := SQLCODE;
846: gbl_error_buf := SQLERRM ||
847: ' -- Error no-data-found in delete_treasury_symbols ';
848: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error1',gbl_error_buf);
849: return;
850: WHEN OTHERS THEN
851: gbl_error_code := SQLCODE;
852: gbl_error_buf := SQLERRM ||

Line 854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',gbl_error_buf);

850: WHEN OTHERS THEN
851: gbl_error_code := SQLCODE;
852: gbl_error_buf := SQLERRM ||
853: ' -- Error in delete_treasury_symbols while deleting Treasury symbols';
854: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',gbl_error_buf);
855: return;
856: END;
857: end delete_treasury_symbols;
858:

Line 868: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside clean up procedure');

864: -- *----------------------------------------------------------------------* --
865: procedure clean_up is
866: l_module_name VARCHAR2(200):= 'CLEAN UP';
867: begin
868: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_statement, l_module_name,' inside clean up procedure');
869:
870: delete from fv_fund_parameters_history ffp
871: where ffp.set_of_books_id = gbl_set_of_books_id
872: and exists ( select treasury_symbol_id

Line 891: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',gbl_error_buf);

887: WHEN OTHERS THEN
888: gbl_error_code := SQLCODE;
889: gbl_error_buf := SQLERRM ||
890: ' -- Error in clean_up while clearing history tables';
891: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error2',gbl_error_buf);
892:
893: end clean_up;
894: -------------------------------------------------------------------------------------------------------------
895: