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.BIL_BI_OPDTL_F_PKG dependencies on BIS_COLLECTION_UTILITIES

Line 194: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');

190: BEGIN
191: g_pkg := 'bil.patch.115.sql.bil_bi_opdtl_f_pkg.';
192: l_proc := 'Init_load';
193:
194: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');
195: IF (not l_valid_setup) THEN
196: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
197: bil_bi_util_collection_pkg.writeLog(
198: p_log_level => fnd_log.LEVEL_EVENT,

Line 200: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );

196: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
197: bil_bi_util_collection_pkg.writeLog(
198: p_log_level => fnd_log.LEVEL_EVENT,
199: p_module => g_pkg || l_proc ,
200: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );
201: END IF;
202: retcode := g_retcode;
203: return;
204: END IF;

Line 264: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');

260: BEGIN
261: l_proc := 'Incr_load';
262: g_pkg := 'bil.patch.115.sql.bil_bi_opdtl_f_pkg.';
263:
264: l_valid_setup := BIS_COLLECTION_UTILITIES.SETUP('BIL_BI_OPDTL_F');
265:
266: IF (not l_valid_setup) THEN
267: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
268: bil_bi_util_collection_pkg.writeLog(

Line 271: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );

267: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
268: bil_bi_util_collection_pkg.writeLog(
269: p_log_level => fnd_log.LEVEL_EVENT,
270: p_module => g_pkg || l_proc ,
271: p_msg => 'BIS_COLLECTION_UTILITIES.SETUP failed' );
272: END IF;
273: retcode := g_retcode;
274: return;
275: END IF;

Line 283: to_char(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'))

279: p_module => g_pkg || l_proc || ' begin',
280: p_msg => 'Start of Procedure '|| l_proc);
281: END IF;
282: l_start_date :=
283: to_char(fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'))
284: ,'YYYY/MM/DD HH24:MI:SS');
285:
286: -- Find the last collection time and use it as the start date for
287: -- this time period.

Line 424: l_failure_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_failure_period('BIL_BI_OPDTL_F'));

420: Init(p_object_name => 'BIL_BI_OPDTL_F');
421:
422: /*ctoba ER 4160374 - uptake of BIS API */
423:
424: l_failure_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_failure_period('BIL_BI_OPDTL_F'));
425:
426:
427:
428:

Line 476: BIS_COLLECTION_UTILITIES.WRITE_BIS_REFRESH_LOG(

472:
473: l_bis_status := TRUE;
474: l_bis_message := 'Successful resumed from last run.';
475:
476: BIS_COLLECTION_UTILITIES.WRITE_BIS_REFRESH_LOG(
477: l_bis_status,
478: g_row_num ,
479: l_bis_message ,
480: g_start_date ,

Line 524: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_OPDTL_F');

520: p_module => g_pkg || l_proc ,
521: p_msg => 'Default Parameter : Global Start Date ='||G_global_Start_date);
522: END IF;
523: IF(g_refresh_flag = 'Y') THEN
524: BIS_COLLECTION_UTILITIES.deleteLogForObject ('BIL_BI_OPDTL_F');
525: bil_bi_util_collection_pkg.Truncate_Table('BIL_BI_OPDTL_F');
526:
527: IF p_start_date IS NOT NULL THEN
528: G_Start_date := TO_DATE(p_start_date, l_date_format);

Line 551: fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));

547: END IF;
548: END IF;
549: ELSE
550: G_Start_date :=
551: fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
552: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
553: bil_bi_util_collection_pkg.writeLog(
554: p_log_level => fnd_log.LEVEL_EVENT,
555: p_module => g_pkg || l_proc ,

Line 589: l_max_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));

585: SELECT COUNT(1) into l_fact_count FROM BIL_BI_OPDTL_F where rownum < 2;
586:
587: /* resume should called wrap up which should have set last_refresh_period */
588:
589: l_max_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('BIL_BI_OPDTL_F'));
590: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
591: bil_bi_util_collection_pkg.writeLog(
592: p_log_level => fnd_log.LEVEL_EVENT,
593: p_module => g_pkg || l_proc ,

Line 799: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;

795: p_module => g_pkg || l_proc || ' begin',
796: p_msg => 'Start of Procedure '|| l_proc);
797: END IF;
798:
799: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
800: FOR rate_record in MissingRate_p
801: LOOP
802: IF rate_record.prim_curr_type='P' THEN
803: BIS_COLLECTION_UTILITIES.writemissingrate(

Line 803: BIS_COLLECTION_UTILITIES.writemissingrate(

799: BIS_COLLECTION_UTILITIES.WriteMissingRateHeader;
800: FOR rate_record in MissingRate_p
801: LOOP
802: IF rate_record.prim_curr_type='P' THEN
803: BIS_COLLECTION_UTILITIES.writemissingrate(
804: g_prim_rate_type,
805: rate_record.txn_currency,
806: g_prim_currency,
807: rate_record.txn_date);

Line 811: BIS_COLLECTION_UTILITIES.writemissingrate(

807: rate_record.txn_date);
808: END IF;
809:
810: IF rate_record.sec_curr_type='S' THEN
811: BIS_COLLECTION_UTILITIES.writemissingrate(
812: g_sec_rate_type,
813: rate_record.txn_currency,
814: g_sec_currency,
815: rate_record.txn_date);

Line 877: BIS_COLLECTION_UTILITIES.wrapup(G_status,

873: Commented commit in write_log procedure. This is done to avoid
874: hanging of incremental program when ran with multiple workers.
875: */
876: COMMIT;
877: BIS_COLLECTION_UTILITIES.wrapup(G_status,
878: g_row_num,
879: null,
880: G_Start_Date,
881: G_end_date);

Line 972: g_debug := NVL(BIS_COLLECTION_UTILITIES.g_debug,FALSE);

968: G_program_id := FND_GLOBAL.CONC_PROGRAM_ID();
969: G_user_id := FND_GLOBAL.USER_ID();
970: G_login_id := FND_GLOBAL.CONC_LOGIN_ID();
971: -- Initialize Debug global variable
972: g_debug := NVL(BIS_COLLECTION_UTILITIES.g_debug,FALSE);
973:
974: -- Get primary currency code and rate type
975: g_prim_currency := bis_common_parameters.get_currency_code;
976: g_prim_rate_type := bis_common_parameters.get_rate_type;