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_DATE

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

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;
122:

Line 120: rlog( 'Completed resetting base tables ' || fnd_date.date_to_displayDT(sysdate),1);

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;
122:
123: EXCEPTION
124: WHEN OTHERS

Line 297: rlog('All Workers Finished Successfully at '||fnd_date.date_to_displayDT(sysdate),2);

293: RAISE G_CHILD_PROCESS_ISSUE;
294: END IF;
295:
296: IF ( l_tot_cnt = l_completed_cnt ) THEN
297: rlog('All Workers Finished Successfully at '||fnd_date.date_to_displayDT(sysdate),2);
298: EXIT;
299: END IF;
300: DBMS_LOCK.sleep(5);
301: END LOOP;

Line 338: rlog('Loading of Staging Table Started - ' || fnd_date.date_to_displayDT(sysdate),1);

334: PROCEDURE load_staging ( p_terr_count OUT NOCOPY NUMBER)
335: IS
336: l_tab_name VARCHAR2(1000);
337: BEGIN
338: rlog('Loading of Staging Table Started - ' || fnd_date.date_to_displayDT(sysdate),1);
339:
340: IF g_load_type ='INIT' THEN
341:
342: INSERT /* + APPEND */ INTO OKI_JTF_TERRITORIES_STG

Line 455: rlog('Loading of Staging Table Completed - ' || fnd_date.date_to_displayDT(sysdate),1);

451: l_tab_name := 'OKI_JTF_TERRITORIES_STG';
452: fnd_stats.gather_table_stats( ownname=> g_table_owner
453: , tabname=> l_tab_name
454: , percent=> 10);
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 ) ;

Line 531: rlog('Subworker ' || p_worker_no ||' Starts: - ' ||fnd_date.date_to_displayDT(SYSDATE),1);

527: rlog('No more jobs left. Terminating.',1);
528: ELSIF (l_completed_cnt = l_total_cnt) THEN
529: rlog('All jobs completed, no more job. Terminating',1);
530: ELSIF (l_unassigned_cnt > 0) THEN
531: rlog('Subworker ' || p_worker_no ||' Starts: - ' ||fnd_date.date_to_displayDT(SYSDATE),1);
532:
533: UPDATE OKI_DBI_WORKER_STATUS
534: SET status = 'IN PROCESS'
535: WHERE object_name = 'OKI_JTF_TERRITORIES'

Line 554: rlog('Subworker ' || p_worker_no || ' Finishes: - ' ||fnd_date.date_to_displayDT(SYSDATE),1);

550: COMMIT;
551:
552: END IF;
553:
554: rlog('Subworker ' || p_worker_no || ' Finishes: - ' ||fnd_date.date_to_displayDT(SYSDATE),1);
555:
556: l_string := 'Subworker ' || p_worker_no || ' Completed in ' ;
557:
558: find_time_diff( l_start_date

Line 607: fnd_date.date_to_displayDT(SYSDATE),0);

603: l_string := 'INCREMENTAL';
604: END IF;
605:
606: rlog( 'Service Contracts Intelligence - TERRITORY '||l_string ||' LOAD: ' ||
607: fnd_date.date_to_displayDT(SYSDATE),0);
608: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(g_start_date), 1);
609: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(g_end_date), 1);
610: rlog( 'Parameter : Number of Workers '|| p_number_of_workers, 1);
611:

Line 608: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(g_start_date), 1);

604: END IF;
605:
606: rlog( 'Service Contracts Intelligence - TERRITORY '||l_string ||' LOAD: ' ||
607: fnd_date.date_to_displayDT(SYSDATE),0);
608: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(g_start_date), 1);
609: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(g_end_date), 1);
610: rlog( 'Parameter : Number of Workers '|| p_number_of_workers, 1);
611:
612:

Line 609: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(g_end_date), 1);

605:
606: rlog( 'Service Contracts Intelligence - TERRITORY '||l_string ||' LOAD: ' ||
607: fnd_date.date_to_displayDT(SYSDATE),0);
608: rlog( 'Parameter : Start date '|| fnd_date.date_to_displayDT(g_start_date), 1);
609: rlog( 'Parameter : End date '|| fnd_date.date_to_displayDT(g_end_date), 1);
610: rlog( 'Parameter : Number of Workers '|| p_number_of_workers, 1);
611:
612:
613: l_errpos := 2;

Line 623: rlog('Launching Sub-Workers to load/update OKI_JTF_TERRITORIES table ' || fnd_date.date_to_displayDT(SYSDATE),1);

619: load_staging(l_count);
620:
621: l_errpos := 4;
622: IF l_count > 0 THEN
623: rlog('Launching Sub-Workers to load/update OKI_JTF_TERRITORIES table ' || fnd_date.date_to_displayDT(SYSDATE),1);
624: spawn_workers( p_number_of_workers
625: , l_count);
626: END IF;
627: l_errpos := 5;

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

645: , g_start_date
646: , g_end_date
647: );
648:
649: rlog('SUCCESS: Load Program Successfully completed ' || fnd_date.date_to_displayDT(SYSDATE),0);
650:
651: find_time_diff( g_sysdate
652: , sysdate
653: , NULL);

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 832: rlog('Calling JTF get_winners - ' || fnd_date.date_to_displayDT(SYSDATE),2);

828: -- Now, the l_gen_bulk_rec has been initialized with all the customer name, country code, state code
829: -- combinations. We call the JTF API with this.
830: --
831: BEGIN
832: rlog('Calling JTF get_winners - ' || fnd_date.date_to_displayDT(SYSDATE),2);
833:
834: JTF_TERR_ASSIGN_PUB.get_winners
835: ( p_api_version_number => 1.0
836: , p_init_msg_list => OKC_API.G_FALSE

Line 854: rlog ('Returned From JTF get_winners - ' || fnd_date.date_to_displayDT(SYSDATE),2);

850:
851: rlog ('Get winners :: x_return_status : '|| l_return_status, 2);
852: rlog ('Get Winners :: x_msg_count : '|| l_msg_count, 2);
853: rlog ('Get Winners :: x_msg_data : '|| l_msg_data, 2);
854: rlog ('Returned From JTF get_winners - ' || fnd_date.date_to_displayDT(SYSDATE),2);
855:
856: EXCEPTION
857: WHEN OTHERS THEN
858: rlog('Error in JTF_TERR_ASSIGN_PUB call ',1);

Line 878: || fnd_date.date_to_displayDT(SYSDATE),2);

874: END;
875: END LOOP;
876:
877: rlog('Loading of table OKI_JTF_TERRITORIES using subworker '|| p_worker_number ||' started - '
878: || fnd_date.date_to_displayDT(SYSDATE),2);
879:
880: IF(l_gen_return_rec.trans_object_id.FIRST IS NULL) THEN
881: rlog('Empty output from jtf function call' , 2);
882: ELSE

Line 968: || fnd_date.date_to_displayDT(SYSDATE),2);

964: END IF;
965: rlog('No of records inserted/updated in OKI_JTF_TERRITORIES table using subworker '
966: || p_worker_number ||' - ' || x_rec_count,2);
967: rlog('Loading of table OKI_JTF_TERRITORIES using subworker '|| p_worker_number ||' completed - '
968: || fnd_date.date_to_displayDT(SYSDATE),2);
969: END IF;
970:
971: COMMIT;
972: