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.OKI_DBI_LOAD_CLEB_PVT dependencies on FND_DATE

Line 120: fnd_date.date_to_displayDT(sysdate),0);

116: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
117: END IF;
118:
119: rlog( 'Service Contracts Intelligence - INITIAL LOAD: ' ||
120: fnd_date.date_to_displayDT(sysdate),0);
121: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(to_date(p_start_date,'yyyy/mm/dd hh24:mi:ss')), 1);
122: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss')), 1);
123:
124: l_sql_string := 'alter session set hash_area_size=100000000';

Line 121: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(to_date(p_start_date,'yyyy/mm/dd hh24:mi:ss')), 1);

117: END IF;
118:
119: rlog( 'Service Contracts Intelligence - INITIAL LOAD: ' ||
120: fnd_date.date_to_displayDT(sysdate),0);
121: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(to_date(p_start_date,'yyyy/mm/dd hh24:mi:ss')), 1);
122: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss')), 1);
123:
124: l_sql_string := 'alter session set hash_area_size=100000000';
125: EXECUTE IMMEDIATE l_sql_string;

Line 122: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss')), 1);

118:
119: rlog( 'Service Contracts Intelligence - INITIAL LOAD: ' ||
120: fnd_date.date_to_displayDT(sysdate),0);
121: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(to_date(p_start_date,'yyyy/mm/dd hh24:mi:ss')), 1);
122: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss')), 1);
123:
124: l_sql_string := 'alter session set hash_area_size=100000000';
125: EXECUTE IMMEDIATE l_sql_string;
126: l_sql_string := 'alter session set sort_area_size=100000000';

Line 134: fnd_date.date_to_displayDT(sysdate),1);

130: EXECUTE IMMEDIATE l_sql_string;
131:
132: OKI_DBI_LOAD_CLEB_PVT.g_load_type := 'INITIAL LOAD';
133: rlog( 'Resetting base tables and BIS log file ' ||
134: fnd_date.date_to_displayDT(sysdate),1);
135: reset_base_tables(errbuf, retcode);
136:
137: IF(retcode = 0 )
138: THEN

Line 147: fnd_date.date_to_displayDT(sysdate),0);

143: 1);
144: END IF;
145:
146: rlog( 'DONE : Initial Load Successfully completed ' ||
147: fnd_date.date_to_displayDT(sysdate),0);
148: DECLARE
149: l_days NUMBER;
150: l_hours NUMBER;
151: l_minutes NUMBER;

Line 244: rlog( 'Completed resetting base tables and BIS log file ' || fnd_date.date_to_displayDT(sysdate),1);

240: EXECUTE IMMEDIATE l_sql_string;
241: rlog( 'Truncated Table OKI_DBI_CLE_B' ,2);
242:
243: BIS_COLLECTION_UTILITIES.DeleteLogForObject('OKIDBICLEB');
244: rlog( 'Completed resetting base tables and BIS log file ' || fnd_date.date_to_displayDT(sysdate),1);
245: END IF;
246:
247: EXCEPTION
248: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 319: rlog( 'Service Contracts Intelligence - INCREMENTAL LOAD ' || fnd_date.date_to_displayDT(sysdate),0);

315: rlog( 'BIS Setup Failure ',0);
316: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
317: END IF;
318:
319: rlog( 'Service Contracts Intelligence - INCREMENTAL LOAD ' || fnd_date.date_to_displayDT(sysdate),0);
320: rlog( 'Number of workers requested : ' || g_no_of_workers,0);
321: END IF;
322:
323: g_debug := BIS_COLLECTION_UTILITIES.G_DEBUG;

Line 332: l_start_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('OKIDBICLEB'))

328: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
329: THEN
330: IF(p_start_date IS NULL )
331: THEN
332: l_start_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('OKIDBICLEB'))
333: - 0.004;
334: g_true_incr :=1;
335: ELSE
336: l_start_date := to_date(p_start_date,'YYYY/MM/DD HH24:MI:SS') - 0.004;

Line 356: rlog( 'Start date - '|| fnd_date.date_to_displayDT(l_start_date),1);

352: OKI_DBI_LOAD_CLEB_PVT.g_run_date := l_run_date;
353:
354: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
355: THEN
356: rlog( 'Start date - '|| fnd_date.date_to_displayDT(l_start_date),1);
357: rlog( 'End date - '|| fnd_date.date_to_displayDT(l_end_date),1);
358: rlog( 'Processing Deletes ' || fnd_date.date_to_displayDT(sysdate),1);
359: OKI_DBI_LOAD_CLEB_PVT.process_deletes;
360: OKI_DBI_LOAD_CLEB_PVT.populate_inc_table_inc;

Line 357: rlog( 'End date - '|| fnd_date.date_to_displayDT(l_end_date),1);

353:
354: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
355: THEN
356: rlog( 'Start date - '|| fnd_date.date_to_displayDT(l_start_date),1);
357: rlog( 'End date - '|| fnd_date.date_to_displayDT(l_end_date),1);
358: rlog( 'Processing Deletes ' || fnd_date.date_to_displayDT(sysdate),1);
359: OKI_DBI_LOAD_CLEB_PVT.process_deletes;
360: OKI_DBI_LOAD_CLEB_PVT.populate_inc_table_inc;
361: ELSE

Line 358: rlog( 'Processing Deletes ' || fnd_date.date_to_displayDT(sysdate),1);

354: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD')
355: THEN
356: rlog( 'Start date - '|| fnd_date.date_to_displayDT(l_start_date),1);
357: rlog( 'End date - '|| fnd_date.date_to_displayDT(l_end_date),1);
358: rlog( 'Processing Deletes ' || fnd_date.date_to_displayDT(sysdate),1);
359: OKI_DBI_LOAD_CLEB_PVT.process_deletes;
360: OKI_DBI_LOAD_CLEB_PVT.populate_inc_table_inc;
361: ELSE
362: OKI_DBI_LOAD_CLEB_PVT.populate_inc_table_init;

Line 365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);

361: ELSE
362: OKI_DBI_LOAD_CLEB_PVT.populate_inc_table_init;
363: END IF;
364:
365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);
366: OKI_DBI_LOAD_CLEB_PVT.load_currencies;
367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);
368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||

Line 367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);

363: END IF;
364:
365: rlog( 'Populating Currencies Table OKI_DBI_CURR_CONV - ' || fnd_date.date_to_displayDT(sysdate),1);
366: OKI_DBI_LOAD_CLEB_PVT.load_currencies;
367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);
368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||
370: fnd_date.date_to_displayDT(sysdate),1);
371: SELECT COUNT(1) INTO l_missing_flag

Line 370: fnd_date.date_to_displayDT(sysdate),1);

366: OKI_DBI_LOAD_CLEB_PVT.load_currencies;
367: rlog( 'Load of Currencies Table OKI_DBI_CURR_CONV completed - ' || fnd_date.date_to_displayDT(sysdate),1);
368:
369: rlog( 'Checking negative rates in Table OKI_DBI_CURR_CONV - ' ||
370: fnd_date.date_to_displayDT(sysdate),1);
371: SELECT COUNT(1) INTO l_missing_flag
372: FROM oki_dbi_curr_conv
373: --WHERE upper(rate_type) <> 'USER'
374: WHERE (rate_f <= 0 OR rate_g < 0 OR rate_sg < 0 OR rate_f is NULL);

Line 379: rlog( 'Reporting Missing Currencies ' || fnd_date.date_to_displayDT(sysdate),1);

375:
376:
377: IF(nvl(l_missing_flag,0) > 0) -- There are missing currencies
378: THEN
379: rlog( 'Reporting Missing Currencies ' || fnd_date.date_to_displayDT(sysdate),1);
380: OKI_DBI_LOAD_CLEB_PVT.report_missing_currencies;
381:
382: errbuf := 'There are missing currencies';
383: rlog( 'ERROR : Missing Currencies, view output file for details',0);

Line 415: rlog('SUCCESS: Load Program Successfully completed ' || fnd_date.date_to_displayDT(SYSDATE),0);

411: OKI_DBI_LOAD_CLEB_PVT.g_end_date
412: );
413:
414: IF( NVL(OKI_DBI_LOAD_CLEB_PVT.g_load_type,'INC LOAD') <> 'INITIAL LOAD') THEN
415: rlog('SUCCESS: Load Program Successfully completed ' || fnd_date.date_to_displayDT(SYSDATE),0);
416: DECLARE
417: l_days NUMBER;
418: l_hours NUMBER;
419: l_minutes NUMBER;

Line 560: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);

556: , 1000)
557: INTO l_batch_size
558: FROM DUAL ;
559:
560: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
561:
562: SELECT MAX(renewal_id),MAX(ren_con_id)
563: INTO g_renewal_id,g_ren_con_id
564: from

Line 664: fnd_date.date_to_displayDT(SYSDATE),1) ;

660:
661: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
662:
663: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
664: fnd_date.date_to_displayDT(SYSDATE),1) ;
665:
666: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
667:
668: INSERT /*+ append parallel(a) */ INTO oki_dbi_chr_inc a

Line 666: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);

662:
663: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
664: fnd_date.date_to_displayDT(SYSDATE),1) ;
665:
666: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
667:
668: INSERT /*+ append parallel(a) */ INTO oki_dbi_chr_inc a
669: (
670: chr_id

Line 1032: fnd_date.date_to_displayDT(SYSDATE),1) ;

1028:
1029: GATHER_TABLE_STATS( TABNAME => 'OKI_DBI_CHR_INC') ;
1030:
1031: rlog('Load of Incremental Table OKI_DBI_CHR_INC completed - ' ||
1032: fnd_date.date_to_displayDT(SYSDATE),1) ;
1033:
1034: EXCEPTION
1035: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1036: RAISE;

Line 1162: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);

1158: END IF;
1159:
1160: rlog ('Primary Rate Type is '||NVL(bis_common_parameters.get_rate_type,'Not Defined'),1);
1161:
1162: rlog( 'Populating Incremental Staging Table OKI_DBI_CHR_STAGE_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
1163:
1164:
1165:
1166: /* Added hint as per perf. teams recommendations*/

Line 1247: fnd_date.date_to_displayDT(SYSDATE),1) ;

1243:
1244: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_STAGE_INC');
1245:
1246: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
1247: fnd_date.date_to_displayDT(SYSDATE),1) ;
1248:
1249: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
1250:
1251: INSERT INTO oki_dbi_chr_inc

Line 1249: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);

1245:
1246: rlog('Load of Incremental Staging Table OKI_DBI_CHR_STAGE_INC completed - ' ||
1247: fnd_date.date_to_displayDT(SYSDATE),1) ;
1248:
1249: rlog( 'Populating Incremental Table OKI_DBI_CHR_INC - ' || fnd_date.date_to_displayDT(sysdate),1);
1250:
1251: INSERT INTO oki_dbi_chr_inc
1252: (
1253: chr_id

Line 1692: rlog( 'Load of Incremental Table OKI_DBI_CHR_INC completed - ' || fnd_date.date_to_displayDT(sysdate),1);

1688: g_contracts_count := SQL%ROWCOUNT ;
1689:
1690: rlog( 'Number of contracts identified for merge: ' || to_char(g_contracts_count), 2) ;
1691: COMMIT ;
1692: rlog( 'Load of Incremental Table OKI_DBI_CHR_INC completed - ' || fnd_date.date_to_displayDT(sysdate),1);
1693:
1694: GATHER_TABLE_STATS(TABNAME => 'OKI_DBI_CHR_INC') ;
1695: END IF ;
1696: EXCEPTION

Line 2220: ||fnd_date.date_to_displayDT(sysdate), 1) ;

2216:
2217: l_location := ' Inserting modified contract lines into OKI_DBI_CLE_B_OLD
2218: table with worker '|| p_worker||' ';
2219: rlog('Populating Staging Table OKI_DBI_CLE_B_OLD with updated/created Contracts : '
2220: ||fnd_date.date_to_displayDT(sysdate), 1) ;
2221:
2222: -- l_balance_logic:='EVENTDATE';
2223: -- l_balance_logic:=nvl(l_balance_logic,'CONTRDATE');
2224:

Line 2971: ||fnd_date.date_to_displayDT(sysdate), 1) ;

2967: ));
2968: p_recs_processed := SQL%ROWCOUNT ;
2969: rlog( 'Number of lines inserted into OKI_DBI_CLE_B_OLD is '||p_recs_processed,2);
2970: rlog('Load of Staging Table OKI_DBI_CLE_B_OLD for updated/created Contracts completed: '
2971: ||fnd_date.date_to_displayDT(sysdate), 1) ;
2972: COMMIT;
2973:
2974: EXCEPTION
2975: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 3020: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3016: l_end_date := OKI_DBI_LOAD_CLEB_PVT.g_end_date ;
3017: l_run_date := OKI_DBI_LOAD_CLEB_PVT.g_run_date ;
3018:
3019: rlog('Populating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3020: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3021: /* Changes to operation_lines */
3022: /* Changed for appsperf bug 4913262 */
3023: MERGE /*+ INDEX(B OKI_DBI_REN_INC_U1) */ INTO OKI_DBI_REN_INC b
3024: USING

Line 3077: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3073:
3074: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3075: ||TO_CHAR(l_count),2);
3076: rlog('Load of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '
3077: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3078: COMMIT;
3079:
3080: IF g_true_incr = 0 THEN
3081:

Line 3085: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3081:
3082: -- GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_REN_INC');
3083:
3084: rlog('Updating table OKI_DBI_REN_INC due to ''Operation Lines Changes'': '
3085: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3086:
3087: /* Changes to operation_lines */
3088: MERGE /*+ INDEX(B OKI_DBI_REN_INC_U1) */ INTO OKI_DBI_REN_INC b
3089: USING

Line 3132: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3128:
3129: rlog('Number of lines updated into OKI_DBI_REN_INC : '
3130: ||TO_CHAR(l_count),2);
3131: rlog('Updation of table OKI_DBI_REN_INC due to ''Operation Lines Changes'' completed: '
3132: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3133: COMMIT;
3134: END IF;
3135:
3136: /* Lines affected due to deletes */

Line 3140: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3136: /* Lines affected due to deletes */
3137: IF (g_del_count > 0 ) then
3138:
3139: rlog('Populating table OKI_DBI_REN_INC due to ''Deletes'': '
3140: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3141:
3142: MERGE INTO OKI_DBI_REN_INC b
3143: USING
3144: (SELECT cle_id

Line 3191: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3187: l_count := SQL%ROWCOUNT;
3188: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3189: ||TO_CHAR(l_count),2);
3190: rlog('Load of table OKI_DBI_REN_INC due to ''Deletes'' completed: '
3191: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3192: COMMIT;
3193: END IF;
3194: GATHER_TABLE_STATS( TABNAME=>'OKI_DBI_REN_INC' );
3195:

Line 3244: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3240:
3241: l_location := ' Updating Covered Lines in OKI_DBI_CLE_B_OLD with Renewals: ' ;
3242:
3243: rlog('Updating Staging Table OKI_DBI_CLE_B_OLD with renewal information : '
3244: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3245: UPDATE oki_dbi_cle_b_old b set (
3246: r_chr_id
3247: , r_cle_id
3248: , r_date_signed

Line 3273: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3269:
3270: rlog( 'Number of lines updated into OKI_DBI_CLE_B_OLD with renewal information is '
3271: || TO_CHAR(p_recs_processed),2) ;
3272: rlog('Updation of Staging Table OKI_DBI_CLE_B_OLD with renewal information completed: '
3273: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3274:
3275: COMMIT;
3276: EXCEPTION
3277: WHEN OTHERS THEN

Line 3315: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3311:
3312: l_location := 'Updating Covered Lines in OKI_DBI_CLE_B_OLD with Original Information: ' ;
3313:
3314: rlog('Updating Staging Table OKI_DBI_CLE_B_OLD with original information : '
3315: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3316:
3317: UPDATE oki_dbi_cle_b_old b SET
3318: ( p_chr_id
3319: , p_cle_id

Line 3396: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3392:
3393: rlog( 'Number of lines updated into OKI_DBI_CLE_B_OLD with original information is '
3394: || TO_CHAR(p_recs_processed),2) ;
3395: rlog('Updation of Staging Table OKI_DBI_CLE_B_OLD with original information completed: '
3396: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3397:
3398: COMMIT;
3399:
3400: EXCEPTION

Line 3483: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate), 1);

3479:
3480: FOR l_phase IN 1 .. 7
3481: LOOP
3482: IF l_phase = 1 THEN
3483: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate), 1);
3484: ELSIF l_phase = 2 THEN
3485: rlog ('Finding new renewal relationship information Phase I : '||fnd_date.date_to_displayDT(sysdate),1);
3486: ELSIF l_phase = 3 THEN
3487: rlog ('Finding new renewal relationship information Phase II : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3485: rlog ('Finding new renewal relationship information Phase I : '||fnd_date.date_to_displayDT(sysdate),1);

3481: LOOP
3482: IF l_phase = 1 THEN
3483: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate), 1);
3484: ELSIF l_phase = 2 THEN
3485: rlog ('Finding new renewal relationship information Phase I : '||fnd_date.date_to_displayDT(sysdate),1);
3486: ELSIF l_phase = 3 THEN
3487: rlog ('Finding new renewal relationship information Phase II : '||fnd_date.date_to_displayDT(sysdate),1);
3488: ELSIF l_phase = 4 THEN
3489: rlog ('Finding new renewal relationship information Phase III : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3487: rlog ('Finding new renewal relationship information Phase II : '||fnd_date.date_to_displayDT(sysdate),1);

3483: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate), 1);
3484: ELSIF l_phase = 2 THEN
3485: rlog ('Finding new renewal relationship information Phase I : '||fnd_date.date_to_displayDT(sysdate),1);
3486: ELSIF l_phase = 3 THEN
3487: rlog ('Finding new renewal relationship information Phase II : '||fnd_date.date_to_displayDT(sysdate),1);
3488: ELSIF l_phase = 4 THEN
3489: rlog ('Finding new renewal relationship information Phase III : '||fnd_date.date_to_displayDT(sysdate),1);
3490: ELSIF l_phase = 5 THEN
3491: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3489: rlog ('Finding new renewal relationship information Phase III : '||fnd_date.date_to_displayDT(sysdate),1);

3485: rlog ('Finding new renewal relationship information Phase I : '||fnd_date.date_to_displayDT(sysdate),1);
3486: ELSIF l_phase = 3 THEN
3487: rlog ('Finding new renewal relationship information Phase II : '||fnd_date.date_to_displayDT(sysdate),1);
3488: ELSIF l_phase = 4 THEN
3489: rlog ('Finding new renewal relationship information Phase III : '||fnd_date.date_to_displayDT(sysdate),1);
3490: ELSIF l_phase = 5 THEN
3491: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B : '||fnd_date.date_to_displayDT(sysdate),1);
3492: ELSIF l_phase = 6 THEN
3493: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3491: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B : '||fnd_date.date_to_displayDT(sysdate),1);

3487: rlog ('Finding new renewal relationship information Phase II : '||fnd_date.date_to_displayDT(sysdate),1);
3488: ELSIF l_phase = 4 THEN
3489: rlog ('Finding new renewal relationship information Phase III : '||fnd_date.date_to_displayDT(sysdate),1);
3490: ELSIF l_phase = 5 THEN
3491: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B : '||fnd_date.date_to_displayDT(sysdate),1);
3492: ELSIF l_phase = 6 THEN
3493: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);
3494: ELSIF l_phase = 7 THEN
3495: rlog ('Updating original information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3493: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);

3489: rlog ('Finding new renewal relationship information Phase III : '||fnd_date.date_to_displayDT(sysdate),1);
3490: ELSIF l_phase = 5 THEN
3491: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B : '||fnd_date.date_to_displayDT(sysdate),1);
3492: ELSIF l_phase = 6 THEN
3493: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);
3494: ELSIF l_phase = 7 THEN
3495: rlog ('Updating original information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);
3496: END IF;
3497: FOR i IN 1 .. l_no_of_workers

Line 3495: rlog ('Updating original information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);

3491: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B : '||fnd_date.date_to_displayDT(sysdate),1);
3492: ELSIF l_phase = 6 THEN
3493: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);
3494: ELSIF l_phase = 7 THEN
3495: rlog ('Updating original information into OKI_DBI_CLE_B_OLD : '||fnd_date.date_to_displayDT(sysdate),1);
3496: END IF;
3497: FOR i IN 1 .. l_no_of_workers
3498: LOOP
3499: g_worker(i) := LAUNCH_WORKER( i

Line 3533: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate), 1);

3529: END IF;
3530:
3531: IF ( l_tot_cnt = l_completed_cnt ) THEN
3532: IF l_phase = 1 THEN
3533: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate), 1);
3534: ELSIF l_phase = 2 THEN
3535: rlog ('Finding new renewal relationship information Phase I completed : '||fnd_date.date_to_displayDT(sysdate),1);
3536: ELSIF l_phase = 3 THEN
3537: rlog ('Finding new renewal relationship information Phase II completed : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3535: rlog ('Finding new renewal relationship information Phase I completed : '||fnd_date.date_to_displayDT(sysdate),1);

3531: IF ( l_tot_cnt = l_completed_cnt ) THEN
3532: IF l_phase = 1 THEN
3533: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate), 1);
3534: ELSIF l_phase = 2 THEN
3535: rlog ('Finding new renewal relationship information Phase I completed : '||fnd_date.date_to_displayDT(sysdate),1);
3536: ELSIF l_phase = 3 THEN
3537: rlog ('Finding new renewal relationship information Phase II completed : '||fnd_date.date_to_displayDT(sysdate),1);
3538: ELSIF l_phase = 4 THEN
3539: rlog ('Finding new renewal relationship information Phase III completed : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3537: rlog ('Finding new renewal relationship information Phase II completed : '||fnd_date.date_to_displayDT(sysdate),1);

3533: rlog ('Inserting modified/created contracts into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate), 1);
3534: ELSIF l_phase = 2 THEN
3535: rlog ('Finding new renewal relationship information Phase I completed : '||fnd_date.date_to_displayDT(sysdate),1);
3536: ELSIF l_phase = 3 THEN
3537: rlog ('Finding new renewal relationship information Phase II completed : '||fnd_date.date_to_displayDT(sysdate),1);
3538: ELSIF l_phase = 4 THEN
3539: rlog ('Finding new renewal relationship information Phase III completed : '||fnd_date.date_to_displayDT(sysdate),1);
3540: ELSIF l_phase = 5 THEN
3541: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B completed : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3539: rlog ('Finding new renewal relationship information Phase III completed : '||fnd_date.date_to_displayDT(sysdate),1);

3535: rlog ('Finding new renewal relationship information Phase I completed : '||fnd_date.date_to_displayDT(sysdate),1);
3536: ELSIF l_phase = 3 THEN
3537: rlog ('Finding new renewal relationship information Phase II completed : '||fnd_date.date_to_displayDT(sysdate),1);
3538: ELSIF l_phase = 4 THEN
3539: rlog ('Finding new renewal relationship information Phase III completed : '||fnd_date.date_to_displayDT(sysdate),1);
3540: ELSIF l_phase = 5 THEN
3541: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B completed : '||fnd_date.date_to_displayDT(sysdate),1);
3542: ELSIF l_phase = 6 THEN
3543: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3541: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B completed : '||fnd_date.date_to_displayDT(sysdate),1);

3537: rlog ('Finding new renewal relationship information Phase II completed : '||fnd_date.date_to_displayDT(sysdate),1);
3538: ELSIF l_phase = 4 THEN
3539: rlog ('Finding new renewal relationship information Phase III completed : '||fnd_date.date_to_displayDT(sysdate),1);
3540: ELSIF l_phase = 5 THEN
3541: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B completed : '||fnd_date.date_to_displayDT(sysdate),1);
3542: ELSIF l_phase = 6 THEN
3543: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);
3544: ELSIF l_phase = 7 THEN
3545: rlog ('Updating original information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);

Line 3543: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);

3539: rlog ('Finding new renewal relationship information Phase III completed : '||fnd_date.date_to_displayDT(sysdate),1);
3540: ELSIF l_phase = 5 THEN
3541: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B completed : '||fnd_date.date_to_displayDT(sysdate),1);
3542: ELSIF l_phase = 6 THEN
3543: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);
3544: ELSIF l_phase = 7 THEN
3545: rlog ('Updating original information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);
3546: END IF;
3547: EXIT;

Line 3545: rlog ('Updating original information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);

3541: rlog ('Inserting covered lines into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B completed : '||fnd_date.date_to_displayDT(sysdate),1);
3542: ELSIF l_phase = 6 THEN
3543: rlog ('Updating renewal information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);
3544: ELSIF l_phase = 7 THEN
3545: rlog ('Updating original information into OKI_DBI_CLE_B_OLD completed : '||fnd_date.date_to_displayDT(sysdate),1);
3546: END IF;
3547: EXIT;
3548: END IF;
3549: DBMS_LOCK.sleep(5);

Line 3559: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3555:
3556: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_PREV_INC');
3557:
3558: rlog('Populating table OKI_DBI_REN_INC from OKI_DBI_PREV_INC: '
3559: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3560:
3561: MERGE INTO OKI_DBI_REN_INC b
3562: USING
3563: (SELECT rel.p_cle_id cle_id

Line 3587: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3583: l_count := SQL%ROWCOUNT;
3584: rlog( 'Number of lines inserted into OKI_DBI_REN_INC : '
3585: ||TO_CHAR(l_count),2);
3586: rlog('Load of table OKI_DBI_REN_INC from OKI_DBI_PREV_INC completed: '
3587: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3588: COMMIT;
3589: OKI_DBI_LOAD_CLEB_PVT.populate_ren_rel(l_no_of_workers);
3590:
3591: ELSIF( l_phase = 3 ) THEN

Line 3604: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3600: EXECUTE IMMEDIATE l_sql_string;
3601: rlog('Truncated table OKI_DBI_CLE_DEL ',2);
3602:
3603: rlog('Populating table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC: '
3604: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3605: INSERT INTO OKI_DBI_CLE_DEL
3606: ( cle_id
3607: ,worker_number)
3608: (SELECT

Line 3631: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3627:
3628: COMMIT;
3629:
3630: rlog('Load of table OKI_DBI_CLE_DEL from OKI_DBI_REN_INC,OKI_DBI_PREV_INC completed: '
3631: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3632:
3633: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_DEL');
3634:
3635: END IF;

Line 3646: ||fnd_date.date_to_displayDT(sysdate), 1) ;

3642:
3643: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_B_OLD');
3644:
3645: rlog('Updating summary table OKI_DBI_CLE_B from OKI_DBI_CLE_B_OLD: '
3646: ||fnd_date.date_to_displayDT(sysdate), 1) ;
3647:
3648: UPDATE
3649: (
3650: SELECT /* + ordered use_nl(b) */

Line 4497: ||fnd_date.date_to_displayDT(sysdate), 1) ;

4493: p_recs_processed := l_count + p_recs_processed;
4494: COMMIT ;
4495:
4496: rlog('Updation of summary table OKI_DBI_CLE_B from OKI_DBI_CLE_B_OLD completed: '
4497: ||fnd_date.date_to_displayDT(sysdate), 1) ;
4498:
4499: EXCEPTION
4500: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4501: RAISE;

Line 4587: rlog('Populating Staging Table OKI_DBI_CLE_B_OLD - ' ||fnd_date.date_to_displayDT(sysdate),1) ;

4583: -- Lesters Feedback 5/19/04 force parallel qry
4584:
4585: EXECUTE IMMEDIATE 'alter session force parallel query';
4586:
4587: rlog('Populating Staging Table OKI_DBI_CLE_B_OLD - ' ||fnd_date.date_to_displayDT(sysdate),1) ;
4588: /* Balance logic for OI */
4589: l_balance_logic := nvl(fnd_profile.value('OKI_BAL_IDENT'),'CONTRDATE');
4590: /* Renewal logic for OI */
4591: l_renewal_logic := nvl(fnd_profile.value('OKI_REN_IDENT'),'STANDARD');

Line 5295: fnd_date.date_to_displayDT(SYSDATE),1) ;

5291: rlog( 'Number of lines inserted into OKI_DBI_CLE_B_OLD : ' ||
5292: to_char(l_count),2);
5293: COMMIT;
5294: rlog('Load of Staging Table OKI_DBI_CLE_B_OLD completed - ' ||
5295: fnd_date.date_to_displayDT(SYSDATE),1) ;
5296:
5297: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_B_OLD');
5298:
5299: rlog('Populating Base Summary Table OKI_DBI_CLE_B - ' || fnd_date.date_to_displayDT(SYSDATE),1) ;

Line 5299: rlog('Populating Base Summary Table OKI_DBI_CLE_B - ' || fnd_date.date_to_displayDT(SYSDATE),1) ;

5295: fnd_date.date_to_displayDT(SYSDATE),1) ;
5296:
5297: GATHER_TABLE_STATS(TABNAME=>'OKI_DBI_CLE_B_OLD');
5298:
5299: rlog('Populating Base Summary Table OKI_DBI_CLE_B - ' || fnd_date.date_to_displayDT(SYSDATE),1) ;
5300:
5301:
5302: -- Added enable parallel dml since change in dbms_stats implementation disables
5303: -- the parellel dml call which results in the subsequent insert being serialized.

Line 5664: fnd_date.date_to_displayDT(SYSDATE),1) ;

5660: l_count := p_recs_processed;
5661: rlog('Number of lines inserted into OKI_DBI_CLE_B : ' || to_char(l_count),2);
5662: COMMIT;
5663: rlog('Load of Base Summary Table OKI_DBI_CLE_B Completed - ' ||
5664: fnd_date.date_to_displayDT(SYSDATE),1) ;
5665:
5666: EXCEPTION
5667: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5668: RAISE;

Line 5713: rlog('Start of Worker '|| p_worker_no ||' : ' ||fnd_date.date_to_displayDT(SYSDATE),1);

5709: l_recs_processed NUMBER := 0;
5710:
5711: BEGIN
5712:
5713: rlog('Start of Worker '|| p_worker_no ||' : ' ||fnd_date.date_to_displayDT(SYSDATE),1);
5714: errbuf := NULL;
5715: retcode := 0;
5716: l_count := 0;
5717:

Line 5796: rlog('Finished Worker ' || p_worker_no || ' : ' ||fnd_date.date_to_displayDT(SYSDATE),1);

5792: RAISE G_CHILD_PROCESS_ISSUE;
5793: END;
5794: END IF;
5795:
5796: rlog('Finished Worker ' || p_worker_no || ' : ' ||fnd_date.date_to_displayDT(SYSDATE),1);
5797:
5798: EXCEPTION
5799: WHEN OTHERS THEN
5800: rlog('Error in procedure worker : Error : ' || SQLERRM,2);

Line 5823: -- fnd_date.date_to_displayDT(SYSDATE),2);

5819:
5820: BEGIN
5821:
5822: --rlog('Start of the procedure launch_worker for worker ' ||p_worker_no||' at : ' ||
5823: -- fnd_date.date_to_displayDT(SYSDATE),2);
5824:
5825: fnd_profile.put('CONC_SINGLE_THREAD','N');
5826:
5827: DECLARE

Line 5890: ||fnd_date.date_to_displayDT(sysdate), 1) ;

5886:
5887: BEGIN
5888: l_location := ' populating renewal increments table ' ;
5889: rlog('Populating renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'': '
5890: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5891:
5892: /* Delta Changes */
5893: INSERT INTO OKI_DBI_REN_INC
5894: (

Line 5912: ||fnd_date.date_to_displayDT(sysdate), 1) ;

5908: l_count := SQL%ROWCOUNT;
5909: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Delta Changes'' is '
5910: ||TO_CHAR(l_count),2);
5911: rlog('Load of renewal incremental table OKI_DBI_REN_INC due to ''Delta Changes'' completed: '
5912: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5913: COMMIT;
5914:
5915: l_location := ' populating original increments table ' ;
5916: rlog('Populating original incremental table OKI_DBI_PREV_INC due to ''Delta Changes'': '

Line 5917: ||fnd_date.date_to_displayDT(sysdate), 1) ;

5913: COMMIT;
5914:
5915: l_location := ' populating original increments table ' ;
5916: rlog('Populating original incremental table OKI_DBI_PREV_INC due to ''Delta Changes'': '
5917: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5918:
5919: /* Delta Changes */
5920: INSERT INTO OKI_DBI_PREV_INC
5921: (

Line 5943: ||fnd_date.date_to_displayDT(sysdate), 1) ;

5939:
5940: l_count := SQL%ROWCOUNT;
5941: rlog( 'Number of lines inserted into OKI_DBI_PREV_INC due to ''Delta Changes'' is ' ||TO_CHAR(l_count),2);
5942: rlog('Load of original incremental table OKI_DBI_PREV_INC due to ''Delta Changes'' completed: '
5943: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5944: COMMIT;
5945:
5946:
5947:

Line 5985: ||fnd_date.date_to_displayDT(sysdate), 1) ;

5981: BEGIN
5982:
5983:
5984: rlog('Populating staging table OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B: '
5985: ||fnd_date.date_to_displayDT(sysdate), 1) ;
5986:
5987: INSERT INTO oki_dbi_cle_b_old
5988: ( chr_id
5989: , cle_id

Line 6346: ||fnd_date.date_to_displayDT(sysdate), 1) ;

6342: l_count := SQL%ROWCOUNT;
6343: rlog( 'Number of lines inserted into OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B: '
6344: ||TO_CHAR(l_count),2);
6345: rlog('Load of staging table OKI_DBI_CLE_B_OLD from OKI_DBI_CLE_B complete: '
6346: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6347: COMMIT;
6348:
6349: p_recs_processed := NVL(l_count,0);
6350:

Line 6393: ||fnd_date.date_to_displayDT(sysdate), 1) ;

6389:
6390: IF( p_stage = 1 ) THEN
6391:
6392: rlog('Populating original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6393: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6394:
6395: /* Changes to Operation Lines...Use the information Already found in
6396: the previous merge to get p_cle_id*/
6397: MERGE INTO OKI_DBI_PREV_INC b

Line 6426: ||fnd_date.date_to_displayDT(sysdate), 1) ;

6422: rlog( 'Number of lines inserted into OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6423: ||TO_CHAR(l_count),2);
6424:
6425: rlog('Load of original incremental table OKI_DBI_PREV_INC from OKI_DBI_REN_INC: '
6426: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6427:
6428: COMMIT;
6429:
6430: ELSIF ( p_stage = 2 ) THEN

Line 6433: ||fnd_date.date_to_displayDT(sysdate), 1) ;

6429:
6430: ELSIF ( p_stage = 2 ) THEN
6431:
6432: rlog('Populating original incremental table OKI_DBI_PREV_INC for ''Intermediate Cancellations'': '
6433: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6434:
6435: /* Check for intermediate Cancellations*/
6436: MERGE INTO OKI_DBI_PREV_INC b
6437: USING

Line 6473: ||fnd_date.date_to_displayDT(sysdate), 1) ;

6469: rlog( 'Number of lines inserted into OKI_DBI_REN_INC due to ''Intermediate Cancellations'' is '
6470: ||TO_CHAR(l_count),2);
6471:
6472: rlog('Load of original incremental table OKI_DBI_PREV_INC for ''Intermediate Cancellations'' completed : '
6473: ||fnd_date.date_to_displayDT(sysdate), 1) ;
6474: COMMIT;
6475:
6476: END IF;
6477: p_recs_processed := l_count;