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_LOAD_TERR_PVT dependencies on BIS_COLLECTION_UTILITIES

Line 117: BIS_COLLECTION_UTILITIES.DeleteLogForObject('OKIJTFTERR');

113: WHERE OBJECT_NAME = 'OKI_JTF_TERRITORIES';
114: COMMIT;
115:
116: If g_load_type ='INIT' THEN
117: BIS_COLLECTION_UTILITIES.DeleteLogForObject('OKIJTFTERR');
118: rlog( 'Completed resetting base tables and BIS log file ' || fnd_date.date_to_displayDT(sysdate),1);
119: ELSE
120: rlog( 'Completed resetting base tables ' || fnd_date.date_to_displayDT(sysdate),1);
121: END IF;

Line 126: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

122:
123: EXCEPTION
124: WHEN OTHERS
125: THEN
126: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
127: fnd_message.set_name( application => 'FND'
128: , name => 'CRM-DEBUG ERROR' ) ;
129: fnd_message.set_token(
130: token => 'ROUTINE'

Line 132: bis_collection_utilities.put_line(fnd_message.get) ;

128: , name => 'CRM-DEBUG ERROR' ) ;
129: fnd_message.set_token(
130: token => 'ROUTINE'
131: , value => 'OKI_LOAD_TERR_PVT.RESET_BASE_TABLES ' ) ;
132: bis_collection_utilities.put_line(fnd_message.get) ;
133: RAISE;
134: END reset_base_tables;
135:
136: /* This API calculates and prints the load duration. This is called by both

Line 320: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

316: END; -- Monitor child process Ends here.
317:
318: EXCEPTION
319: WHEN OTHERS THEN
320: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
321: fnd_message.set_name( application => 'FND'
322: , name => 'CRM-DEBUG ERROR' ) ;
323: fnd_message.set_token(
324: token => 'ROUTINE'

Line 326: bis_collection_utilities.put_line(fnd_message.get) ;

322: , name => 'CRM-DEBUG ERROR' ) ;
323: fnd_message.set_token(
324: token => 'ROUTINE'
325: , value => 'OKI_LOAD_TERR_PVT.spawn_workers ' ) ;
326: bis_collection_utilities.put_line(fnd_message.get) ;
327: RAISE;
328: END spawn_workers;
329:
330: /* This API is used to load the staging table.

Line 459: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;

455: rlog('Loading of Staging Table Completed - ' || fnd_date.date_to_displayDT(sysdate),1);
456:
457: EXCEPTION
458: WHEN OTHERS THEN
459: bis_collection_utilities.put_line(sqlerrm || '' || sqlcode ) ;
460: fnd_message.set_name( application => 'FND'
461: , name => 'CRM-DEBUG ERROR' ) ;
462: fnd_message.set_token(
463: token => 'ROUTINE'

Line 465: bis_collection_utilities.put_line(fnd_message.get) ;

461: , name => 'CRM-DEBUG ERROR' ) ;
462: fnd_message.set_token(
463: token => 'ROUTINE'
464: , value => 'OKI_LOAD_TERR_PVT.load_staging ' ) ;
465: bis_collection_utilities.put_line(fnd_message.get) ;
466: RAISE;
467: END load_staging;
468:
469: /* This API will be called by SubWorker Concurrent Program.

Line 590: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('OKIJTFTERR');

586: l_setup_ok BOOLEAN;
587: l_string VARCHAR2(1000);
588: BEGIN
589:
590: l_setup_ok := BIS_COLLECTION_UTILITIES.setup('OKIJTFTERR');
591: IF (NOT l_setup_ok) THEN
592: errbuf := fnd_message.get;
593: rlog( 'BIS Setup Failure ',0);
594: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);

Line 642: BIS_COLLECTION_UTILITIES.wrapup( TRUE

638: WHERE object_name ='OKI_JTF_TERRITORIES';
639:
640: rlog('No of records inserted/updated in OKI_JTF_TERRITORIES table - ' || l_count , 1);
641:
642: BIS_COLLECTION_UTILITIES.wrapup( TRUE
643: , l_count
644: , 'OKI TERRITORY ' || l_string || ' LOAD COMPLETED SUCCESSFULLY'
645: , g_start_date
646: , g_end_date

Line 665: BIS_COLLECTION_UTILITIES.wrapup( FALSE

661: errbuf := sqlerrm;
662: ROLLBACK;
663:
664: retcode := '2';
665: BIS_COLLECTION_UTILITIES.wrapup( FALSE
666: , l_count
667: , errbuf || ': ' || retcode
668: , g_start_date
669: , g_end_date

Line 675: bis_collection_utilities.put_line(fnd_message.get) ;

671: fnd_message.set_name( application => 'FND'
672: , name => 'CRM-DEBUG ERROR' ) ;
673: fnd_message.set_token( token => 'ROUTINE'
674: , value => 'OKI_LOAD_TERR_PVT.refresh_jtf_terr' ) ;
675: bis_collection_utilities.put_line(fnd_message.get) ;
676:
677: RAISE;
678: END refresh_jtf_terr;
679:

Line 704: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;

700: , p_number_of_workers
701: );
702: EXCEPTION
703: WHEN OTHERS THEN
704: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;
705: fnd_message.set_name( application => 'FND'
706: , name => 'CRM-DEBUG ERROR' ) ;
707: fnd_message.set_token(
708: token => 'ROUTINE'

Line 710: bis_collection_utilities.put_line(fnd_message.get) ;

706: , name => 'CRM-DEBUG ERROR' ) ;
707: fnd_message.set_token(
708: token => 'ROUTINE'
709: , value => 'OKI_LOAD_TERR_PVT.initial_load ' ) ;
710: bis_collection_utilities.put_line(fnd_message.get) ;
711: END initial_load;
712:
713: /* This API will be called by Incremental Load Concurrent Program.
714: It has three Parameters

Line 729: g_start_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('OKIJTFTERR'))

725: BEGIN
726:
727: g_load_type := 'INCR';
728:
729: g_start_date := fnd_date.displaydt_to_date(BIS_COLLECTION_UTILITIES.get_last_refresh_period('OKIJTFTERR'))
730: - 0.004;
731:
732: g_end_date := g_sysdate;
733:

Line 740: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;

736: , p_number_of_workers
737: );
738: EXCEPTION
739: WHEN OTHERS THEN
740: bis_collection_utilities.put_line(errbuf || '' || retcode ) ;
741: fnd_message.set_name( application => 'FND'
742: , name => 'CRM-DEBUG ERROR' ) ;
743: fnd_message.set_token(
744: token => 'ROUTINE'

Line 746: bis_collection_utilities.put_line(fnd_message.get) ;

742: , name => 'CRM-DEBUG ERROR' ) ;
743: fnd_message.set_token(
744: token => 'ROUTINE'
745: , value => 'OKI_LOAD_TERR_PVT.initial_load ' ) ;
746: bis_collection_utilities.put_line(fnd_message.get) ;
747: RAISE;
748: END incr_load;
749:
750: /* This API is used to load Territory fact.