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_GL_PKG dependencies on FV_UTILITY

Line 211: fv_utility.log_mesg(fnd_log.level_error, l_module_name,gbl_err_buff);

207: IF get_exception_count > 0 THEN
208: gbl_err_buff := 'Exceptions have occurred! '||
209: 'Please fix all exceptions and re run the process.';
210: gbl_err_code := 2;
211: fv_utility.log_mesg(fnd_log.level_error, l_module_name,gbl_err_buff);
212: ROLLBACK;
213: submit_exception_report;
214: END IF;
215: END IF;

Line 234: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

230: EXCEPTION WHEN OTHERS THEN
231: p_err_code := SQLCODE;
232: p_err_buff := 'When others exception in Main - '||SQLERRM;
233: ROLLBACK;
234: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
235: END MAIN;
236: --------------------------------------------------------------------------------
237: -- Get the period num for the parameter period and also the first period num
238: -- for the year.

Line 246: FV_UTILITY.LOG_MESG('Begin: '||l_module_name);

242: l_module_name VARCHAR2(200);
243: l_temp_mesg VARCHAR2(250);
244: BEGIN
245: l_module_name := g_module_name || 'GET_PROCESS_DATES';
246: FV_UTILITY.LOG_MESG('Begin: '||l_module_name);
247:
248: -- Get the period year for the period parameter passed.
249: l_temp_mesg := 'getting period year.';
250: SELECT period_year

Line 280: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

276:
277: IF (gbl_period_num_low = 0 OR gbl_period_num_high = 0) THEN
278: gbl_err_code := 2 ;
279: gbl_err_buff := l_module_name||' Period number '|| 'found zero for the passed fiscal year.' ;
280: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
281: RETURN;
282: END IF;
283: log(l_module_name, 'Period Year: '||gbl_period_year);
284: log(l_module_name, 'Period Number Low: '||gbl_period_num_low);

Line 292: FV_UTILITY.LOG_MESG(gbl_err_buff);

288: EXCEPTION
289: WHEN NO_DATA_FOUND THEN
290: gbl_err_code := 2;
291: gbl_err_buff := l_module_name||' - No data found when '||l_temp_mesg;
292: FV_UTILITY.LOG_MESG(gbl_err_buff);
293: WHEN OTHERS THEN
294: gbl_err_code := 2;
295: gbl_err_buff := l_module_name||' - When others error when '||l_temp_mesg||':'||SQLERRM;
296: FV_UTILITY.LOG_MESG(gbl_err_buff);

Line 296: FV_UTILITY.LOG_MESG(gbl_err_buff);

292: FV_UTILITY.LOG_MESG(gbl_err_buff);
293: WHEN OTHERS THEN
294: gbl_err_code := 2;
295: gbl_err_buff := l_module_name||' - When others error when '||l_temp_mesg||':'||SQLERRM;
296: FV_UTILITY.LOG_MESG(gbl_err_buff);
297: END get_process_dates;
298: --------------------------------------------------------------------------------
299: -- Get balancing and accounting segments
300: --------------------------------------------------------------------------------

Line 359: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN
357: gbl_err_code := -1 ;
358: gbl_err_buff := 'Balancing or Accounting segment not found.';
359: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
360: WHEN invalid_bal_segment THEN
361: gbl_err_code := -1 ;
362: gbl_err_buff := 'Error while fetching balancing segment.';
363: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

Line 363: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

359: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
360: WHEN invalid_bal_segment THEN
361: gbl_err_code := -1 ;
362: gbl_err_buff := 'Error while fetching balancing segment.';
363: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
364: WHEN invalid_acc_segment THEN
365: gbl_err_code := -1 ;
366: gbl_err_buff := 'Error while fetching accounting segment.';
367: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

Line 367: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

363: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
364: WHEN invalid_acc_segment THEN
365: gbl_err_code := -1 ;
366: gbl_err_buff := 'Error while fetching accounting segment.';
367: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
368: WHEN OTHERS THEN
369: gbl_err_code := -1 ;
370: gbl_err_buff := 'When others error while getting
371: Balancing or Accounting segment - '||SQLERRM;

Line 372: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

368: WHEN OTHERS THEN
369: gbl_err_code := -1 ;
370: gbl_err_buff := 'When others error while getting
371: Balancing or Accounting segment - '||SQLERRM;
372: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
373: END get_segment_names;
374: --------------------------------------------------------------------------------
375: -- Select all journal lines from gl_je_lines from the beginning of the year upto
376: -- the period being run, for all accounts existing in fv_gtas_fed_accounts and

Line 1031: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

1027: EXCEPTION WHEN
1028: OTHERS THEN
1029: gbl_err_code := SQLCODE;
1030: gbl_err_buff := l_module_name||' - When others error: '||SQLERRM;
1031: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
1032: END PROCESS_GL_LINES;
1033: --------------------------------------------------------------------------------
1034: PROCEDURE LOG
1035: (module IN VARCHAR2,

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

1040: BEGIN
1041: --log(l_module_name,message_line);
1042:
1043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, module, message_line);
1045: END IF;
1046:
1047: EXCEPTION
1048: WHEN OTHERS THEN

Line 1051: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

1047: EXCEPTION
1048: WHEN OTHERS THEN
1049: gbl_err_code := SQLCODE;
1050: gbl_err_buff := l_module_name||' - When others error: '||SQLERRM;
1051: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
1052: END log;
1053: --------------------------------------------------------------------------------
1054: --Authority type code is required for budget level 1 transactions or
1055: --reprogramming transactions.

Line 1281: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);

1277: log(l_module_name,'End: '||l_module_name);
1278: EXCEPTION WHEN OTHERS THEN
1279: gbl_err_code := SQLCODE;
1280: gbl_err_buff := l_module_name||' - When others error: '||SQLERRM;
1281: FV_UTILITY.LOG_MESG (FND_LOG.LEVEL_ERROR, l_module_name,gbl_err_buff);
1282: END GET_AUTHORITY_TYPE_CODE;
1283: --------------------------------------------------------------------------------
1284: PROCEDURE DELETE_EXCEPTION_RECS IS
1285: l_module_name VARCHAR2(200) := g_module_name||'DELETE_EXCEPTION_RECS';

Line 1301: FV_UTILITY.LOG_MESG(gbl_err_buff);

1297: COMMIT;
1298: EXCEPTION WHEN OTHERS THEN
1299: gbl_err_code := 2;
1300: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
1301: FV_UTILITY.LOG_MESG(gbl_err_buff);
1302: END DELETE_EXCEPTION_RECS;
1303: --------------------------------------------------------------------------------
1304: PROCEDURE INSERT_EXCEPTION_REC(
1305: p_set_of_books_id IN NUMBER, p_fund_value IN VARCHAR2,

Line 1351: FV_UTILITY.LOG_MESG(gbl_err_buff);

1347: EXCEPTION WHEN OTHERS THEN
1348: gbl_err_code := 2;
1349: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
1350: log(l_module_name,'-When others error: '||SQLERRM);
1351: FV_UTILITY.LOG_MESG(gbl_err_buff);
1352: END INSERT_EXCEPTION_REC;
1353:
1354: --------------------------------------------------------------------------------
1355: -- For suppliers use GDF, for customers(TCA)

Line 1559: FV_UTILITY.LOG_MESG(gbl_err_buff);

1555: log(l_module_name,'End: '||l_module_name);
1556: EXCEPTION WHEN OTHERS THEN
1557: gbl_err_code := 2;
1558: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
1559: FV_UTILITY.LOG_MESG(gbl_err_buff);
1560: END GET_TP_ATTRIBUTES;
1561: --------------------------------------------------------------------------------
1562: PROCEDURE GET_PARTY_INFO_R12(p_je_source IN VARCHAR2,
1563: p_je_category IN VARCHAR2,

Line 2016: fv_utility.log_mesg('End: '||l_module_name);

2012: END LOOP;
2013:
2014: END IF;
2015:
2016: fv_utility.log_mesg('End: '||l_module_name);
2017: EXCEPTION WHEN OTHERS THEN
2018: gbl_err_code := 2;
2019: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2020: FV_UTILITY.LOG_MESG(gbl_err_buff);

Line 2020: FV_UTILITY.LOG_MESG(gbl_err_buff);

2016: fv_utility.log_mesg('End: '||l_module_name);
2017: EXCEPTION WHEN OTHERS THEN
2018: gbl_err_code := 2;
2019: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2020: FV_UTILITY.LOG_MESG(gbl_err_buff);
2021: END GET_PARTY_INFO_R12;
2022: --------------------------------------------------------------------------------
2023: PROCEDURE GET_PARTY_INFO_11I(p_je_source IN VARCHAR2, p_je_category IN VARCHAR2,
2024: p_reference1 IN VARCHAR2,

Line 2059: fv_utility.log_mesg('Begin: '||l_module_name);

2055: AND cdl.expenditure_item_id = ei.expenditure_item_id
2056: AND ei.expenditure_id = e.expenditure_id;
2057:
2058: BEGIN
2059: fv_utility.log_mesg('Begin: '||l_module_name);
2060: IF (p_je_source = 'Payables' AND
2061: p_je_category <> 'Treasury Confirmation') THEN
2062: SELECT v.vendor_id, 'S', v.vendor_name,
2063: v.global_attribute4 "fed_nonfed_code",

Line 2194: fv_utility.log_mesg('End: '||l_module_name);

2190: ap_suppliers v
2191: WHERE apc.vendor_id = v.vendor_id
2192: AND apc.check_id = to_number(p_reference3);
2193: END IF;
2194: fv_utility.log_mesg('End: '||l_module_name);
2195: EXCEPTION WHEN OTHERS THEN
2196: gbl_err_code := 2;
2197: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2198: FV_UTILITY.LOG_MESG(gbl_err_buff);

Line 2198: FV_UTILITY.LOG_MESG(gbl_err_buff);

2194: fv_utility.log_mesg('End: '||l_module_name);
2195: EXCEPTION WHEN OTHERS THEN
2196: gbl_err_code := 2;
2197: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2198: FV_UTILITY.LOG_MESG(gbl_err_buff);
2199: END GET_PARTY_INFO_11I;
2200: --------------------------------------------------------------------------------
2201: PROCEDURE GET_SYSTEM_ATTRIBUTES IS
2202: l_module_name VARCHAR2(200) := g_module_name||'GET_SYSTEM_ATTRIBUTES';

Line 2249: FV_UTILITY.LOG_MESG(gbl_err_buff);

2245: log(l_module_name, gbl_err_buff);
2246: WHEN OTHERS THEN
2247: gbl_err_code := 2;
2248: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2249: FV_UTILITY.LOG_MESG(gbl_err_buff);
2250: END GET_SYSTEM_ATTRIBUTES;
2251: --------------------------------------------------------------------------------
2252: PROCEDURE GET_BUDGET_IMPACT_IND(p_je_batch_id IN NUMBER,
2253: p_je_header_id IN NUMBER,

Line 2405: FV_UTILITY.LOG_MESG(gbl_err_buff);

2401: log(l_module_name, gbl_err_buff);
2402: WHEN OTHERS THEN
2403: gbl_err_code := 2;
2404: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2405: FV_UTILITY.LOG_MESG(gbl_err_buff);
2406: END GET_BUDGET_IMPACT_IND;
2407: --------------------------------------------------------------------------------
2408: --Change request has been changed multiple times
2409: --This change is based on bug14255268.

Line 2651: FV_UTILITY.LOG_MESG(gbl_err_buff);

2647: log(l_module_name, gbl_err_buff);
2648: WHEN OTHERS THEN
2649: gbl_err_code := 2;
2650: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2651: FV_UTILITY.LOG_MESG(gbl_err_buff);
2652: END GET_FED_NONFED_CODE;
2653: --------------------------------------------------------------------------------
2654: PROCEDURE GET_ACCOUNT_TYPE(p_account_number IN VARCHAR2,
2655: p_account_type OUT NOCOPY VARCHAR2)

Line 2681: FV_UTILITY.LOG_MESG(gbl_err_buff);

2677: log(l_module_name, gbl_err_buff);
2678: WHEN OTHERS THEN
2679: gbl_err_code := 2;
2680: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2681: FV_UTILITY.LOG_MESG(gbl_err_buff);
2682: END GET_ACCOUNT_TYPE;
2683: --------------------------------------------------------------------------------
2684: PROCEDURE SUBMIT_EXCEPTION_REPORT
2685: IS

Line 2779: FV_UTILITY.LOG_MESG(gbl_err_buff);

2775: NULL;
2776: WHEN OTHERS THEN
2777: gbl_err_code := 2;
2778: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2779: FV_UTILITY.LOG_MESG(gbl_err_buff);
2780: END UPDATE_GTAS_RUN;
2781: --------------------------------------------------------------------------------
2782: --Modified for change request 12
2783: --Checks whether a passed value exists in fv_gtas_attributes.fed_non_fed1

Line 2818: FV_UTILITY.LOG_MESG(gbl_err_buff);

2814: log(l_module_name,'p_code_exists: '||p_code_exists);
2815: WHEN OTHERS THEN
2816: gbl_err_code := 2;
2817: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2818: FV_UTILITY.LOG_MESG(gbl_err_buff);
2819: END CHECK_FED_NONFED_CODE;
2820: --------------------------------------------------------------------------------
2821: PROCEDURE DELETE_PRIOR_GTAS_ACTIVITY
2822: IS

Line 2867: FV_UTILITY.LOG_MESG(gbl_err_buff);

2863: EXCEPTION
2864: WHEN OTHERS THEN
2865: gbl_err_code := 2;
2866: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2867: FV_UTILITY.LOG_MESG(gbl_err_buff);
2868: END DELETE_PRIOR_GTAS_ACTIVITY;
2869: --------------------------------------------------------------------------------
2870: FUNCTION GET_EXCEPTION_COUNT RETURN NUMBER IS
2871: l_module_name VARCHAR2(80) := g_module_name||'GET_EXCEPTION_COUNT';

Line 2890: FV_UTILITY.LOG_MESG(gbl_err_buff);

2886: EXCEPTION
2887: WHEN OTHERS THEN
2888: gbl_err_code := 2;
2889: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2890: FV_UTILITY.LOG_MESG(gbl_err_buff);
2891: END GET_EXCEPTION_COUNT;
2892: --------------------------------------------------------------------------------
2893: --Check whether the account exists in gtas attributes
2894: --If not, then we have to use the sgl account for getting the attributes

Line 2919: FV_UTILITY.LOG_MESG(gbl_err_buff);

2915:
2916: WHEN OTHERS THEN
2917: gbl_err_code := 2;
2918: gbl_err_buff := l_module_name||'-When others error: '||SQLERRM;
2919: FV_UTILITY.LOG_MESG(gbl_err_buff);
2920: END GET_USSGL_ACCT;
2921: --------------------------------------------------------------------------------
2922: BEGIN
2923: g_module_name := 'fv.plsql.FV_GTAS_GL_PKG.';