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

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

843: Errbuf :=NULL;
844: Retcode:=0;
845: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
846: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
847: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
848: errbuf := fnd_message.get;
849: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
850: END IF;
851: FII_AP_SCH_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,

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

848: errbuf := fnd_message.get;
849: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
850: END IF;
851: FII_AP_SCH_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
852: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
853: FII_AP_SCH_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
854: l_date1 := g_push_date_range1;
855: l_date2 := g_push_date_range2;
856: edw_log.put_line( 'The collection range is from '||

Line 853: FII_AP_SCH_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

849: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
850: END IF;
851: FII_AP_SCH_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
852: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
853: FII_AP_SCH_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
854: l_date1 := g_push_date_range1;
855: l_date2 := g_push_date_range2;
856: edw_log.put_line( 'The collection range is from '||
857: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||

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

1114: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1115: ' rows into the staging table');
1116: edw_log.put_line(' ');
1117: Retcode := g_retcode;
1118: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1119: if (g_missing_rates >0) then
1120: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
1121: end if;
1122: commit;

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

1135: Retcode:=g_retcode;
1136: l_exception_msg := Retcode || ':' || Errbuf;
1137: edw_log.put_line('Identifying changed records have Failed');
1138: rollback;
1139: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1140: /* Set the completion status to error. bug#3207823 */
1141: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1142: --raise;
1143: WHEN L_PUSH_LOCAL_FAILURE THEN

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

1145: Retcode:=g_retcode;
1146: l_exception_msg := Retcode || ':' || Errbuf;
1147: edw_log.put_line('Inserting into local staging have failed');
1148: rollback;
1149: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1150: /* Set the completion status to error. bug#3207823 */
1151: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1152: --raise;
1153: WHEN L_PUSH_REMOTE_FAILURE THEN

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

1155: Retcode:=g_retcode;
1156: l_exception_msg := Retcode || ':' || Errbuf;
1157: edw_log.put_line('Data migration from local to remote staging have failed');
1158: rollback;
1159: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1160: /* Set the completion status to error. bug#3207823 */
1161: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1162: --raise;
1163: WHEN L_SET_STATUS_FAILURE THEN

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

1165: Retcode:=g_retcode;
1166: l_exception_msg := Retcode || ':' || Errbuf;
1167: edw_log.put_line('Setting status to READY have failed');
1168: rollback;
1169: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1170: /* Set the completion status to error. bug#3207823 */
1171: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1172: --raise;
1173: WHEN OTHERS THEN

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

1174: Errbuf:=sqlerrm;
1175: Retcode:=sqlcode;
1176: l_exception_msg := Retcode || ':' || Errbuf;
1177: rollback;
1178: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1179: /* Set the completion status to error. bug#3207823 */
1180: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1181: --raise;
1182: