APPS.BIC_SUMMARY_EXTRACT_PKG dependencies on FND_PROFILE

Line 53: g_debug := fnd_profile.value('BIC_DEBUG');

49: procedure process_sql_type_measures;
50: -------------------------------------------------------------------
51: PROCEDURE debug( debug_str VARCHAR2) IS
52: BEGIN
53: g_debug := fnd_profile.value('BIC_DEBUG');
54: FND_LOG.G_CURRENT_RUNTIME_LEVEL := 1;
55: FND_GLOBAL.APPS_INITIALIZE (fnd_global.user_id,fnd_global.resp_id,fnd_global.prog_appl_id);
56: if g_debug = 'Y' then
57: --This is to meet 11.5.10 logging standards

Line 61: FND_PROFILE.value('AFLOG_MODULE')||'_'||g_proc_name, debug_str);

57: --This is to meet 11.5.10 logging standards
58: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
59:
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
61: FND_PROFILE.value('AFLOG_MODULE')||'_'||g_proc_name, debug_str);
62: end if;
63: end if;
64: END debug;
65: procedure extract_calendar(errbuf out NOCOPY varchar2,

Line 101: PERIOD_SET_NAME=FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME')

97: , quarter_start_date act_quarter_start_date
98: , decode(quarter_num,1,1,2,1,3,2,4,2,null) act_half_year
99: from gl_periods gprd
100: WHERE
101: PERIOD_SET_NAME=FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME')
102: AND ADJUSTMENT_PERIOD_FLAG <>'Y'
103: AND PERIOD_TYPE=FND_PROFILE.VALUE('CRMBIS:PERIOD_TYPE')
104: ;
105: commit;

Line 103: AND PERIOD_TYPE=FND_PROFILE.VALUE('CRMBIS:PERIOD_TYPE')

99: from gl_periods gprd
100: WHERE
101: PERIOD_SET_NAME=FND_PROFILE.VALUE('CRMBIS:PERIOD_SET_NAME')
102: AND ADJUSTMENT_PERIOD_FLAG <>'Y'
103: AND PERIOD_TYPE=FND_PROFILE.VALUE('CRMBIS:PERIOD_TYPE')
104: ;
105: commit;
106:
107: --------- Bic_periods table refreshed.

Line 160: select fnd_profile.value('BIC_SMRY_EXTRACTION_DATE') into x_date

156: if g_measure_code is null then
157: if p_start_date is not null then
158: g_period_start_date := fnd_date.canonical_to_date(p_start_date);
159: else
160: select fnd_profile.value('BIC_SMRY_EXTRACTION_DATE') into x_date
161: from dual;
162: if x_date is null then
163: write_log('Error: Start Date not Specified and Profile Option' ||
164: ' BIC_SMRY_EXTRACTION_DATE is not set');

Line 329: g_to_currency_code := FND_PROFILE.VALUE('CRMBIS:CURRENCY_CODE');

325: p_date date,
326: p_amt number) return number is
327: x_converted_amt number;
328: begin
329: g_to_currency_code := FND_PROFILE.VALUE('CRMBIS:CURRENCY_CODE');
330: g_conversion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');
331: if p_from_currency_code is null then return p_amt;
332: end if;
333: x_converted_amt := gl_currency_api.convert_amount_sql(

Line 330: g_conversion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');

326: p_amt number) return number is
327: x_converted_amt number;
328: begin
329: g_to_currency_code := FND_PROFILE.VALUE('CRMBIS:CURRENCY_CODE');
330: g_conversion_type := FND_PROFILE.VALUE('CRMBIS:GL_CONVERSION_TYPE');
331: if p_from_currency_code is null then return p_amt;
332: end if;
333: x_converted_amt := gl_currency_api.convert_amount_sql(
334: x_from_currency => p_from_currency_code,

Line 347: g_debug := fnd_profile.value('BIC_DEBUG');

343: -- is 'Y' then it sets g_log_output variable and message are inserted into
344: -- bic_debug table.
345: procedure set_debug is
346: begin
347: g_debug := fnd_profile.value('BIC_DEBUG');
348: exception
349: when others then null;
350: end set_debug;
351: --

Line 2299: fnd_profile.put('BIC_SMRY_EXTRACTION_DATE',

2295: bic_consolidate_cust_data_pkg.update_market_segment;
2296: -- set profile value of BIC_SMRY_EXTRACTION_DATE iff start and end dates
2297: -- passed to the procedure are null.
2298: if p_start_date is null and p_end_date is null then
2299: fnd_profile.put('BIC_SMRY_EXTRACTION_DATE',
2300: to_char(g_period_end_date,'dd-mm-yyyy'));
2301: write_log('BIC_SMRY_EXTRACTION_DATE profile option is set to ' ||
2302: to_char(g_period_end_date,'dd-mm-yyyy'));
2303: end if;