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

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

829: Errbuf :=NULL;
830: Retcode:=0;
831: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
832: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
833: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
834: errbuf := fnd_message.get;
835: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
836: END IF;
837: FII_AP_INV_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,

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

834: errbuf := fnd_message.get;
835: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
836: END IF;
837: FII_AP_INV_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
838: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
839: FII_AP_INV_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
840: l_date1 := g_push_date_range1;
841: l_date2 := g_push_date_range2;
842: edw_log.put_line( 'The collection range is from '||

Line 839: FII_AP_INV_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

835: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
836: END IF;
837: FII_AP_INV_PAYMTS_F_C.g_push_date_range1 := nvl(l_from_date,
838: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
839: FII_AP_INV_PAYMTS_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
840: l_date1 := g_push_date_range1;
841: l_date2 := g_push_date_range2;
842: edw_log.put_line( 'The collection range is from '||
843: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||

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

1102: edw_log.put_line('Inserted '||nvl(g_row_count,0)||
1103: ' rows into the staging table');
1104: edw_log.put_line(' ');
1105: Retcode := g_retcode;
1106: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1107: if (g_missing_rates >0) then
1108: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
1109: end if;
1110: commit;

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

1123: Retcode:=g_retcode;
1124: l_exception_msg := Retcode || ':' || Errbuf;
1125: edw_log.put_line('Identifying changed records have Failed');
1126: rollback;
1127: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1128: /* Set the completion status to error. bug#3207823 */
1129: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1130: --raise;
1131: WHEN L_PUSH_LOCAL_FAILURE THEN

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

1133: Retcode:=g_retcode;
1134: l_exception_msg := Retcode || ':' || Errbuf;
1135: edw_log.put_line('Inserting into local staging have failed');
1136: rollback;
1137: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1138: /* Set the completion status to error. bug#3207823 */
1139: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1140: --raise;
1141: WHEN L_PUSH_REMOTE_FAILURE THEN

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

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

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

1153: Retcode:=g_retcode;
1154: l_exception_msg := Retcode || ':' || Errbuf;
1155: edw_log.put_line('Setting status to READY have failed');
1156: rollback;
1157: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1158: /* Set the completion status to error. bug#3207823 */
1159: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1160: --raise;
1161: WHEN OTHERS THEN

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

1162: Errbuf:=sqlerrm;
1163: Retcode:=sqlcode;
1164: l_exception_msg := Retcode || ':' || Errbuf;
1165: rollback;
1166: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1167: /* Set the completion status to error. bug#3207823 */
1168: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1169: --raise;
1170: