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.FII_AP_INV_ON_HOLD_F_C dependencies on EDW_COLLECTION_UTIL

Line 645: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN

641: Errbuf :=NULL;
642: Retcode:=0;
643: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
644: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
645: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
646: errbuf := fnd_message.get;
647: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
648: END IF;
649: FII_AP_INV_ON_HOLD_F_C.g_push_date_range1 := nvl(l_from_date,

Line 650: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

646: errbuf := fnd_message.get;
647: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
648: END IF;
649: FII_AP_INV_ON_HOLD_F_C.g_push_date_range1 := nvl(l_from_date,
650: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
651: FII_AP_INV_ON_HOLD_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
652: l_date1 := g_push_date_range1;
653: l_date2 := g_push_date_range2;
654: edw_log.put_line( 'The collection range is from '||

Line 651: FII_AP_INV_ON_HOLD_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

647: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
648: END IF;
649: FII_AP_INV_ON_HOLD_F_C.g_push_date_range1 := nvl(l_from_date,
650: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
651: FII_AP_INV_ON_HOLD_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
652: l_date1 := g_push_date_range1;
653: l_date2 := g_push_date_range2;
654: edw_log.put_line( 'The collection range is from '||
655: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 923: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);

919: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
920: ' rows into the staging table');
921: edw_log.put_line(' ');
922: Retcode := g_retcode;
923: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
924: if (g_missing_rates >0) then
925: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
926: end if;
927: commit;

Line 944: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);

940: Retcode:=g_retcode;
941: l_exception_msg := Retcode || ':' || Errbuf;
942: edw_log.put_line('Identifying changed records have Failed');
943: rollback;
944: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
945: /* Set the completion status to error. bug#3207823 */
946: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
947: --raise;
948: WHEN L_PUSH_LOCAL_FAILURE THEN

Line 954: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);

950: Retcode:=g_retcode;
951: l_exception_msg := Retcode || ':' || Errbuf;
952: edw_log.put_line('Inserting into local staging have failed');
953: rollback;
954: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
955: /* Set the completion status to error. bug#3207823 */
956: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
957: --raise;
958: WHEN L_PUSH_REMOTE_FAILURE THEN

Line 964: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);

960: Retcode:=g_retcode;
961: l_exception_msg := Retcode || ':' || Errbuf;
962: edw_log.put_line('Data migration from local to remote staging have failed');
963: rollback;
964: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
965: /* Set the completion status to error. bug#3207823 */
966: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
967: --raise;
968: WHEN L_SET_STATUS_FAILURE THEN

Line 974: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);

970: Retcode:=g_retcode;
971: l_exception_msg := Retcode || ':' || Errbuf;
972: edw_log.put_line('Setting status to READY have failed');
973: rollback;
974: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
975: /* Set the completion status to error. bug#3207823 */
976: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
977: --raise;
978: WHEN OTHERS THEN

Line 983: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);

979: Errbuf:=sqlerrm;
980: Retcode:=sqlcode;
981: l_exception_msg := Retcode || ':' || Errbuf;
982: rollback;
983: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
984: /* Set the completion status to error. bug#3207823 */
985: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
986: --raise;
987: