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 FND_MESSAGE

Line 46: fnd_message.set_name( application => 'FND'

42: EXCEPTION
43: WHEN OTHERS THEN
44: fnd_file.put_line( which => fnd_file.log,
45: buff => sqlerrm || '' || sqlcode);
46: fnd_message.set_name( application => 'FND'
47: , name => 'CRM-DEBUG ERROR' ) ;
48: fnd_message.set_token( token => 'ROUTINE'
49: , value => 'OKI_LOAD_TERR_PVT.log' ) ;
50: fnd_file.put_line( which => fnd_file.log,

Line 48: fnd_message.set_token( token => 'ROUTINE'

44: fnd_file.put_line( which => fnd_file.log,
45: buff => sqlerrm || '' || sqlcode);
46: fnd_message.set_name( application => 'FND'
47: , name => 'CRM-DEBUG ERROR' ) ;
48: fnd_message.set_token( token => 'ROUTINE'
49: , value => 'OKI_LOAD_TERR_PVT.log' ) ;
50: fnd_file.put_line( which => fnd_file.log,
51: buff => fnd_message.get);
52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 51: buff => fnd_message.get);

47: , name => 'CRM-DEBUG ERROR' ) ;
48: fnd_message.set_token( token => 'ROUTINE'
49: , value => 'OKI_LOAD_TERR_PVT.log' ) ;
50: fnd_file.put_line( which => fnd_file.log,
51: buff => fnd_message.get);
52: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
53: END rlog;
54:
55: /* This API is used to launch the worker.

Line 127: fnd_message.set_name( application => 'FND'

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'
131: , value => 'OKI_LOAD_TERR_PVT.RESET_BASE_TABLES ' ) ;

Line 129: fnd_message.set_token(

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'
131: , value => 'OKI_LOAD_TERR_PVT.RESET_BASE_TABLES ' ) ;
132: bis_collection_utilities.put_line(fnd_message.get) ;
133: RAISE;

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 321: fnd_message.set_name( application => 'FND'

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'
325: , value => 'OKI_LOAD_TERR_PVT.spawn_workers ' ) ;

Line 323: fnd_message.set_token(

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'
325: , value => 'OKI_LOAD_TERR_PVT.spawn_workers ' ) ;
326: bis_collection_utilities.put_line(fnd_message.get) ;
327: RAISE;

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 460: fnd_message.set_name( application => 'FND'

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'
464: , value => 'OKI_LOAD_TERR_PVT.load_staging ' ) ;

Line 462: fnd_message.set_token(

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'
464: , value => 'OKI_LOAD_TERR_PVT.load_staging ' ) ;
465: bis_collection_utilities.put_line(fnd_message.get) ;
466: RAISE;

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 592: errbuf := fnd_message.get;

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);
595: END IF;
596:

Line 671: fnd_message.set_name( application => 'FND'

667: , errbuf || ': ' || retcode
668: , g_start_date
669: , g_end_date
670: );
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) ;

Line 673: fnd_message.set_token( token => 'ROUTINE'

669: , g_end_date
670: );
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;

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 705: fnd_message.set_name( application => 'FND'

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'
709: , value => 'OKI_LOAD_TERR_PVT.initial_load ' ) ;

Line 707: fnd_message.set_token(

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'
709: , value => 'OKI_LOAD_TERR_PVT.initial_load ' ) ;
710: bis_collection_utilities.put_line(fnd_message.get) ;
711: END initial_load;

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 741: fnd_message.set_name( application => 'FND'

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'
745: , value => 'OKI_LOAD_TERR_PVT.initial_load ' ) ;

Line 743: fnd_message.set_token(

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'
745: , value => 'OKI_LOAD_TERR_PVT.initial_load ' ) ;
746: bis_collection_utilities.put_line(fnd_message.get) ;
747: RAISE;

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.