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

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

1248: Errbuf :=NULL;
1249: Retcode:=0;
1250: l_from_date :=to_date(p_from_date,'YYYY/MM/DD HH24:MI:SS');
1251: l_to_date :=to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
1252: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
1253: errbuf := fnd_message.get;
1254: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
1255: END IF;
1256: FII_AP_INV_LINES_F_C.g_push_date_range1 := nvl(l_from_date,

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

1253: errbuf := fnd_message.get;
1254: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
1255: END IF;
1256: FII_AP_INV_LINES_F_C.g_push_date_range1 := nvl(l_from_date,
1257: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1258: FII_AP_INV_LINES_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1259: l_date1 := g_push_date_range1;
1260: l_date2 := g_push_date_range2;
1261: edw_log.put_line( 'The collection range is from '||

Line 1258: FII_AP_INV_LINES_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

1254: RAISE_APPLICATION_ERROR(-20000,'Error in SETUP: ' || errbuf);
1255: END IF;
1256: FII_AP_INV_LINES_F_C.g_push_date_range1 := nvl(l_from_date,
1257: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1258: FII_AP_INV_LINES_F_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
1259: l_date1 := g_push_date_range1;
1260: l_date2 := g_push_date_range2;
1261: edw_log.put_line( 'The collection range is from '||
1262: to_char(l_date1,'MM/DD/YYYY HH24:MI:SS')||' to '||

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

1552: Retcode := g_retcode;
1553:
1554:
1555:
1556: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,null,g_push_date_range1, g_push_date_range2);
1557: if (g_missing_rates >0) then
1558: edw_log.put_line ('Records with missing rates identified in source and not loaded to warehouse');
1559: end if;
1560: commit;

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

1575: Retcode:=g_retcode;
1576: l_exception_msg := Retcode || ':' || Errbuf;
1577: edw_log.put_line('Identifying changed records have Failed');
1578: rollback;
1579: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1580: /* Set the completion status to error. bug#3207823 */
1581: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1582: --raise;
1583: WHEN L_PUSH_LOCAL_FAILURE THEN

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

1585: Retcode:=g_retcode;
1586: l_exception_msg := Retcode || ':' || Errbuf;
1587: edw_log.put_line('Inserting into local staging have failed');
1588: rollback;
1589: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1590: /* Set the completion status to error. bug#3207823 */
1591: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1592: --raise;
1593: WHEN L_PUSH_REMOTE_FAILURE THEN

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

1595: Retcode:=g_retcode;
1596: l_exception_msg := Retcode || ':' || Errbuf;
1597: edw_log.put_line('Data migration from local to remote staging have failed');
1598: rollback;
1599: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1600: /* Set the completion status to error. bug#3207823 */
1601: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1602: --raise;
1603: WHEN L_SET_STATUS_FAILURE THEN

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

1605: Retcode:=g_retcode;
1606: l_exception_msg := Retcode || ':' || Errbuf;
1607: edw_log.put_line('Setting status to READY have failed');
1608: rollback;
1609: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1610: /* Set the completion status to error. bug#3207823 */
1611: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1612: --raise;
1613: WHEN OTHERS THEN

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

1614: Errbuf:=sqlerrm;
1615: Retcode:=sqlcode;
1616: l_exception_msg := Retcode || ':' || Errbuf;
1617: rollback;
1618: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg,g_push_date_range1, g_push_date_range2);
1619: /* Set the completion status to error. bug#3207823 */
1620: l_set_completion_status:=FND_CONCURRENT.Set_Completion_Status(status=>'ERROR',message=>l_exception_msg);
1621: --raise;
1622: