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_HOLD_DATA_F_C dependencies on EDW_COLLECTION_UTIL

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

678: Errbuf :=NULL;
679: Retcode:=0;
680: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
681: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
682: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
683: errbuf := fnd_message.get;
684: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
685: END IF;
686: FII_AP_HOLD_DATA_F_C.g_push_date_range1 := nvl(l_from_date,

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

683: errbuf := fnd_message.get;
684: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
685: END IF;
686: FII_AP_HOLD_DATA_F_C.g_push_date_range1 := nvl(l_from_date,
687: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
688: FII_AP_HOLD_DATA_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
689: l_date1 := g_push_date_range1;
690: l_date2 := g_push_date_range2;
691: edw_log.put_line( 'The collection range is from '||

Line 688: FII_AP_HOLD_DATA_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

684: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
685: END IF;
686: FII_AP_HOLD_DATA_F_C.g_push_date_range1 := nvl(l_from_date,
687: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
688: FII_AP_HOLD_DATA_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
689: l_date1 := g_push_date_range1;
690: l_date2 := g_push_date_range2;
691: edw_log.put_line( 'The collection range is from '||
692: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||

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

962: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
963: ' rows into the staging table');
964: edw_log.put_line(' ');
965: Retcode := g_retcode;
966: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
967: if (g_missing_rates >0) then
968: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
969: end if;
970: commit;

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

984: Retcode:=g_retcode;
985: l_exception_msg := Retcode || ':' || Errbuf;
986: edw_log.put_line('Identifying changed records have Failed');
987: rollback;
988: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
989: /* Set the completion status to error. bug#3207823 */
990: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
991: --raise;
992: WHEN L_PUSH_LOCAL_FAILURE THEN

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

994: Retcode:=g_retcode;
995: l_exception_msg := Retcode || ':' || Errbuf;
996: edw_log.put_line('Inserting into local staging have failed');
997: rollback;
998: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
999: /* Set the completion status to error. bug#3207823 */
1000: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1001: --raise;
1002: WHEN L_PUSH_REMOTE_FAILURE THEN

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

1004: Retcode:=g_retcode;
1005: l_exception_msg := Retcode || ':' || Errbuf;
1006: edw_log.put_line('Data migration from local to remote staging have failed');
1007: rollback;
1008: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1009: /* Set the completion status to error. bug#3207823 */
1010: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1011: --raise;
1012: WHEN L_SET_STATUS_FAILURE THEN

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

1014: Retcode:=g_retcode;
1015: l_exception_msg := Retcode || ':' || Errbuf;
1016: edw_log.put_line('Setting status to READY have failed');
1017: rollback;
1018: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1019: raise;
1020: WHEN OTHERS THEN
1021: Errbuf:=sqlerrm;
1022: Retcode:=sqlcode;

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

1021: Errbuf:=sqlerrm;
1022: Retcode:=sqlcode;
1023: l_exception_msg := Retcode || ':' || Errbuf;
1024: rollback;
1025: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1026: /* Set the completion status to error. bug#3207823 */
1027: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1028: --raise;
1029: