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,
1257: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
1402: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1403: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1404: */
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1405:
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1406: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_RATES');
1407: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ***'||fnd_message.get||'*** ');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1408: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1409: FND_MESSAGE.SET_NAME('FII','FII_PAST_CONV_RATES');
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1410: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1412: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1413: l_msg := l_msg||fnd_message.get||' ';
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1414: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1422:
1415: l_msg := l_msg||fnd_message.get||' ';
1416: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1417: l_msg := l_msg||fnd_message.get||' ';
1418: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1419: l_msg := l_msg||fnd_message.get;
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1421: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1422:
1423: FOR c in c1 loop
1439: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1440: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'FROM CURRENCY TO CURRENCY CONVERSION DATE COLLECTION STATUS');
1441: */
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1443: FND_MESSAGE.SET_NAME('FII','FII_FUTURE_CONV_RATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1444: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,fnd_message.get);
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1445: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1446: l_msg := NULL;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1447: FND_MESSAGE.SET_NAME('FII','FII_FROM_CURRENCY');
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1448: l_msg := l_msg||fnd_message.get||' ';
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1449: FND_MESSAGE.SET_NAME('FII','FII_TO_CURRENCY');
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1457:
1450: l_msg := l_msg||fnd_message.get||' ';
1451: FND_MESSAGE.SET_NAME('FII','FII_MISS_CONV_DATES');
1452: l_msg := l_msg||fnd_message.get||' ';
1453: FND_MESSAGE.SET_NAME('FII','FII_COLLECTION_STATUS');
1454: l_msg := l_msg||fnd_message.get;
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_msg);
1456: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '------------- ----------- --------------- -----------------');
1457:
1458: FOR d in c2 loop