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

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

203: IF (gbl_period_num_low = 0 OR gbl_period_num_high = 0) THEN
204: gbl_error_code := 2 ;
205: gbl_error_buf := l_module_name||' Period number '||
206: 'found zero for the passed fiscal year.' ;
207: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
208: RETURN;
209: END IF;
210: FV_UTILITY.LOG_MESG('Period Year: '||gbl_period_year);
211: FV_UTILITY.LOG_MESG('Period Number Low: '||gbl_period_num_low);

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

446: EXCEPTION WHEN OTHERS THEN
447: p_err_code := SQLCODE;
448: p_err_buff := 'When others exception in Main - '||SQLERRM;
449: ROLLBACK;
450: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
451:
452: END main;
453: --------------------------------------------------------------------------------
454: -- Get balancing and accounting segments

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

519: EXCEPTION
520: WHEN invalid_bal_segment THEN
521: gbl_error_code := -1 ;
522: gbl_error_buf := 'Error while fetching balancing segment.';
523: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
524: WHEN invalid_acc_segment THEN
525: gbl_error_code := -1 ;
526: gbl_error_buf := 'Error while fetching accounting segment.';
527: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);

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

523: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
524: WHEN invalid_acc_segment THEN
525: gbl_error_code := -1 ;
526: gbl_error_buf := 'Error while fetching accounting segment.';
527: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
528: WHEN NO_DATA_FOUND THEN
529: gbl_error_code := -1 ;
530: gbl_error_buf := l_module_name||' - No data found when'||l_temp_mesg;
531: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);

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

527: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
528: WHEN NO_DATA_FOUND THEN
529: gbl_error_code := -1 ;
530: gbl_error_buf := l_module_name||' - No data found when'||l_temp_mesg;
531: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
532: WHEN OTHERS THEN
533: gbl_error_code := -1 ;
534: gbl_error_buf := l_module_name||' - When others error when'||
535: l_temp_mesg||SQLERRM;

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

532: WHEN OTHERS THEN
533: gbl_error_code := -1 ;
534: gbl_error_buf := l_module_name||' - When others error when'||
535: l_temp_mesg||SQLERRM;
536: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
537:
538: END get_segment_names;
539:
540: --------------------------------------------------------------------------------

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

574: BEGIN
575:
576: l_module_name := g_module_name||' POPULATE_TEMP2';
577:
578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
580: 'Inserting a record in T2 for record_category :'||
581: p_record_category||' for ccid: '||p_ccid);
582: END IF;

Line 579: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

575:
576: l_module_name := g_module_name||' POPULATE_TEMP2';
577:
578: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
579: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
580: 'Inserting a record in T2 for record_category :'||
581: p_record_category||' for ccid: '||p_ccid);
582: END IF;
583:

Line 650: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

646: WHEN OTHERS THEN
647: gbl_error_code := -1;
648: gbl_error_buf := l_module_name||' - When others exception -'||
649: to_char(SQLCODE) || ' - ' || SQLERRM;
650: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
651:
652: END populate_temp2;
653: --------------------------------------------------------------------------------
654: -- PROCEDURE GET_USSGL_ACCT_NUM

Line 1271: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1267: Where Period_Year = gbl_period_year
1268: AND set_of_books_id = gbl_set_of_books_id;
1269: EXCEPTION
1270: WHEN NO_DATA_FOUND THEN
1271: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1272: 'Please set up the Budget Fiscal Year Segment Mapping for period year '
1273: ||gbl_period_year);
1274: RAISE;
1275: END;

Line 1310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

1306: p_ccid => p_ccid,
1307: p_treasury_symbol_id => p_treasury_symbol_id);
1308: gbl_error_code := -1;
1309: gbl_error_buf := l_module_name||' - When no data found error: '||SQLERRM;
1310: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
1311: return;
1312:
1313: WHEN OTHERS THEN
1314: gbl_error_code := -1;

Line 1316: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

1312:
1313: WHEN OTHERS THEN
1314: gbl_error_code := -1;
1315: gbl_error_buf := l_module_name||' - When others error: '||SQLERRM;
1316: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
1317: RETURN;
1318: END GET_USSGL_ACCT_NUM ;
1319: --------------------------------------------------------------------------------
1320: PROCEDURE CHECK_PRC_MAP_SEG(p_fund_value IN VARCHAR2,

Line 1559: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,

1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: gbl_error_buf := SQLERRM;
1558: gbl_error_code := -1;
1559: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,
1560: l_module_name||'.final_exception',gbl_error_buf);
1561:
1562: END check_prc_map_seg;
1563: --------------------------------------------------------------------------------

Line 1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

1639: WHEN Others THEN
1640: gbl_error_code := -1 ;
1641: gbl_error_buf := l_module_name||' - When others exception - ' ||
1642: TO_CHAR(SQLCODE) || ' - ' ||SQLERRM ;
1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
1644: END get_account_type;
1645: --------------------------------------------------------------------------------
1646: -- PROCEDURE GET_USSGL_INFO
1647: --------------------------------------------------------------------------------

Line 1672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

1668: WHEN OTHERS THEN
1669: p_acct_not_found := 'Y';
1670: gbl_error_code := -1;
1671: gbl_error_buf := SQLERRM;
1672: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
1673: RETURN;
1674: END get_ussgl_info;
1675:
1676: --------------------------------------------------------------------------------

Line 1738: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, gbl_error_buf);

1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: gbl_error_code := -1;
1737: gbl_error_buf := l_module_name||' - When others error '||SQLERRM;
1738: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, gbl_error_buf);
1739: RAISE;
1740:
1741: END create_end_bal_record;
1742: --------------------------------------------------------------------------------

Line 1784: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,gbl_error_buf);

1780: EXCEPTION
1781: WHEN OTHERS THEN
1782: gbl_error_code := -1 ;
1783: gbl_error_buf := l_module_name||' - When others exception - '||SQLERRM;
1784: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED,l_module_name,gbl_error_buf);
1785: END;
1786: --------------------------------------------------------------------------------
1787: PROCEDURE SET_UP_GTAS_ATTRIBUTES(p_err_buf OUT NOCOPY VARCHAR2,
1788: p_err_code OUT NOCOPY NUMBER,

Line 2610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);

2606: WHEN OTHERS THEN
2607: p_err_code := -1;
2608: p_err_buf := l_module_name||' When others exception: '
2609: ||to_char(SQLCODE) || ' - ' || SQLERRM;
2610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,gbl_error_buf);
2611:
2612: END set_up_gtas_attributes;
2613: --------------------------------------------------------------------------------
2614: --------------------------------------------------------------------------------

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

2663:
2664: IF (l_req_id = 0) THEN
2665: Gbl_Error_Code := '-1';
2666: gbl_error_buf := 'Cannot submit GTAS Interface Exception report';
2667: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
2668: RETURN;
2669: ELSE
2670: COMMIT;
2671: call_status := Fnd_concurrent.Wait_for_request(l_req_id, 20, 0,

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

2681: --IF there are exceptions then error out and return
2682: Gbl_Error_Code := '-1';
2683: gbl_error_buf := 'Exceptions exist, please fix all exceptions '||
2684: 'and rerun the GTAS Interface Process';
2685: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_error_buf);
2686: RETURN;
2687: ELSE
2688: log(l_module_name, 'No exceptions found to report');
2689: END IF;

Line 2920: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,

2916: WHEN OTHERS THEN
2917: p_err_code := SQLCODE;
2918: p_err_buff := SQLERRM ||
2919: ' -- Error in Get_Federal_Accounts procedure';
2920: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR,
2921: l_module_name||'.exception1',p_err_buff);
2922: RETURN;
2923: END GET_FEDERAL_ACCOUNTS;
2924: --------------------------------------------------------------------------------

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

2924: --------------------------------------------------------------------------------
2925: PROCEDURE LOG (module IN VARCHAR2, message_line IN VARCHAR2) IS
2926:
2927: BEGIN
2928: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2929: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
2930: END IF;
2931: EXCEPTION
2932: WHEN OTHERS THEN

Line 2929: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);

2925: PROCEDURE LOG (module IN VARCHAR2, message_line IN VARCHAR2) IS
2926:
2927: BEGIN
2928: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2929: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
2930: END IF;
2931: EXCEPTION
2932: WHEN OTHERS THEN
2933: FV_UTILITY.LOG_MESG('When others error in module: log: '||sqlerrm);

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

2951: WHEN OTHERS THEN
2952: gbl_error_code := -1;
2953: gbl_error_buf := SQLERRM ||
2954: 'When others error in DELETE_FED_ACCOUNTS - '||SQLERRM;
2955: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
2956: END DELETE_FED_ACCOUNTS;
2957: --------------------------------------------------------------------------------
2958: PROCEDURE POPULATE_FV_GTAS_FED_ACCOUNTS IS
2959: l_module_name VARCHAR2(200):= g_module_name||'POPULATE_FV_GTAS_FED_ACCOUNTS';

Line 3003: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||

2999: WHEN TOO_MANY_ROWS THEN
3000: gbl_error_code := SQLCODE;
3001: gbl_error_buf := 'Account: '||vg_acct_number||' has multiple active parents!';
3002: log(l_module_name, 'Account: '||vg_acct_number||' has multiple active parents!');
3003: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||
3004: '.too many rows',gbl_error_buf);
3005: RETURN;
3006: END;
3007:

Line 3114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||

3110: WHEN OTHERS THEN
3111: gbl_error_code := SQLCODE;
3112: gbl_error_buf := SQLERRM ||
3113: ' -- Error in Populate_Fv_gtas_Fed_Accounts procedure';
3114: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name||
3115: '.exception1',gbl_error_buf);
3116:
3117: END POPULATE_FV_GTAS_FED_ACCOUNTS;
3118: --------------------------------------------------------------------------------

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

3151: gbl_error_buf := SQLERRM || 'In UPDATE_GTAS_RUN - '|| l_stage ;
3152: WHEN OTHERS THEN
3153: gbl_error_code := -1;
3154: gbl_error_buf := SQLERRM || 'When others error in UPDATE_GTAS_RUN - '||SQLERRM;
3155: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
3156: END UPDATE_GTAS_RUN;
3157: --------------------------------------------------------------------------------
3158: FUNCTION GET_ACCT_TYPE(p_acct_num IN VARCHAR2) RETURN VARCHAR2 IS
3159: l_module_name VARCHAR2(200):= g_module_name || 'GET_ACCT_TYPE';

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

3175: EXCEPTION
3176: WHEN OTHERS THEN
3177: gbl_error_code := -1;
3178: gbl_error_buf := SQLERRM || 'When others error in GET_ACCT_TYPE - '||SQLERRM;
3179: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
3180: END GET_ACCT_TYPE;
3181: --------------------------------------------------------------------------------
3182: PROCEDURE PRINT_HEADER IS
3183: l_module_name VARCHAR2(200):= g_module_name || 'PRINT_HEADER';

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

3199: EXCEPTION
3200: WHEN OTHERS THEN
3201: gbl_error_code := -1;
3202: gbl_error_buf := SQLERRM || 'When others error in PRINT_HEADER - '||SQLERRM;
3203: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
3204:
3205: END PRINT_HEADER;
3206: --------------------------------------------------------------------------------
3207: --If the USSGL is disabled, then delete all rows

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

3223: WHEN OTHERS THEN
3224: gbl_error_code := -1;
3225: gbl_error_buf := SQLERRM ||
3226: 'When others error in DEL_DISABLED_ACCTS - '||SQLERRM;
3227: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name, gbl_error_buf);
3228: END DEL_DISABLED_ACCTS;
3229: --------------------------------------------------------------------------------
3230: BEGIN
3231: g_module_name := 'fv.plsql.FV_GTAS_PKG.';