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.FTE_DIST_DWNLD_PKG dependencies on WSH_UTIL_CORE

Line 268: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

264: x_return_message => l_return_message,
265: x_return_status => l_return_status);
266:
267:
268: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
269: IF l_debug_on THEN
270: WSH_DEBUG_SV.logmsg(l_module_name,'Error from FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME , l_return_status = '||l_return_status);
271: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');
272: END IF;

Line 512: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

508: WSH_DEBUG_SV.logmsg(l_module_name,'---------------------------------');
509: END IF;
510:
511:
512: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
513: g_first_time := FIRST_TIME;
514: l_filename := p_src_filename;
515:
516:

Line 557: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

553:
554:
555: END IF;
556:
557: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
558: --
559: -- Concurrent Manager expects 0 for success.
560: --
561: IF l_debug_on THEN

Line 736: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

732: --
733: -- Set the return flags for the start of the procedure
734: --
735: x_return_message := null;
736: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
737:
738:
739: --
740: -- Set the filename and extension to the local variables

Line 954: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

950: x_return_status => l_return_status);
951:
952:
953:
954: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name,'FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME failed, return status = ',l_return_status);
957: WSH_DEBUG_SV.log(l_module_name,'l_return_message = ',l_return_message);
958: WSH_DEBUG_SV.logmsg(l_module_name,'RAISE FTE_DIST_ERR_CREATE_FILENAME');

Line 1222: IF (l_return_message <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

1218: x_return_message => l_return_message,
1219: x_return_status => l_return_status);
1220:
1221:
1222: IF (l_return_message <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1223: --
1224: -- The Download File suffered an error!
1225: --
1226: RAISE FTE_DIST_DWNLD_FAILED;

Line 1248: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1244: --
1245: -- Everything was OK
1246: --
1247: x_return_message := null;
1248: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1249:
1250: --
1251: -- commit the changes
1252: --

Line 1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1261:
1262: EXCEPTION
1263: WHEN FTE_DIST_INVALID_PROFILE THEN
1264: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_PROFILE');
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1266: x_return_message := FND_MESSAGE.GET;
1267: WSH_UTIL_CORE.add_message(x_return_status);
1268:
1269: --

Line 1267: WSH_UTIL_CORE.add_message(x_return_status);

1263: WHEN FTE_DIST_INVALID_PROFILE THEN
1264: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_PROFILE');
1265: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1266: x_return_message := FND_MESSAGE.GET;
1267: WSH_UTIL_CORE.add_message(x_return_status);
1268:
1269: --
1270: -- Close any open cursors
1271: --

Line 1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1289:
1290:
1291: WHEN FTE_DIST_NULL_PROFILE THEN
1292: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_PROFILE');
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1294: x_return_message := FND_MESSAGE.GET;
1295: WSH_UTIL_CORE.add_message(x_return_status);
1296:
1297: --

Line 1295: WSH_UTIL_CORE.add_message(x_return_status);

1291: WHEN FTE_DIST_NULL_PROFILE THEN
1292: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_PROFILE');
1293: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1294: x_return_message := FND_MESSAGE.GET;
1295: WSH_UTIL_CORE.add_message(x_return_status);
1296:
1297: --
1298: -- Close any open cursors
1299: --

Line 1321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1317:
1318:
1319: WHEN FTE_DIST_NULL_TEMPLATE_ID THEN
1320: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_TEMPLATE_ID');
1321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1322: x_return_message := FND_MESSAGE.GET;
1323: WSH_UTIL_CORE.add_message(x_return_status);
1324:
1325: --

Line 1323: WSH_UTIL_CORE.add_message(x_return_status);

1319: WHEN FTE_DIST_NULL_TEMPLATE_ID THEN
1320: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_TEMPLATE_ID');
1321: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1322: x_return_message := FND_MESSAGE.GET;
1323: WSH_UTIL_CORE.add_message(x_return_status);
1324:
1325: --
1326: -- Close any open cursors
1327: --

Line 1349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1345:
1346:
1347: WHEN FTE_DIST_NULL_ORIGIN_INPUT THEN
1348: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_ORIGIN_INPUT');
1349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1350: x_return_message := FND_MESSAGE.GET;
1351: WSH_UTIL_CORE.add_message(x_return_status);
1352:
1353: --

Line 1351: WSH_UTIL_CORE.add_message(x_return_status);

1347: WHEN FTE_DIST_NULL_ORIGIN_INPUT THEN
1348: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_ORIGIN_INPUT');
1349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1350: x_return_message := FND_MESSAGE.GET;
1351: WSH_UTIL_CORE.add_message(x_return_status);
1352:
1353: --
1354: -- Close any open cursors
1355: --

Line 1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1372: RETURN;
1373:
1374: WHEN FTE_DIST_NULL_DEST_INPUT THEN
1375: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_DEST_INPUT');
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: x_return_message := FND_MESSAGE.GET;
1378: WSH_UTIL_CORE.add_message(x_return_status);
1379:
1380: --

Line 1378: WSH_UTIL_CORE.add_message(x_return_status);

1374: WHEN FTE_DIST_NULL_DEST_INPUT THEN
1375: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_DEST_INPUT');
1376: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1377: x_return_message := FND_MESSAGE.GET;
1378: WSH_UTIL_CORE.add_message(x_return_status);
1379:
1380: --
1381: -- Close any open cursors
1382: --

Line 1403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1399: RETURN;
1400:
1401: WHEN FTE_DIST_MANY_ORIGIN_INPUT THEN
1402: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_ORIGIN_INPUT');
1403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1404: x_return_message := FND_MESSAGE.GET;
1405: WSH_UTIL_CORE.add_message(x_return_status);
1406:
1407: --

Line 1405: WSH_UTIL_CORE.add_message(x_return_status);

1401: WHEN FTE_DIST_MANY_ORIGIN_INPUT THEN
1402: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_ORIGIN_INPUT');
1403: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1404: x_return_message := FND_MESSAGE.GET;
1405: WSH_UTIL_CORE.add_message(x_return_status);
1406:
1407: --
1408: -- Close any open cursors
1409: --

Line 1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1426: RETURN;
1427:
1428: WHEN FTE_DIST_MANY_DEST_INPUT THEN
1429: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_DEST_INPUT');
1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1431: x_return_message := FND_MESSAGE.GET;
1432: WSH_UTIL_CORE.add_message(x_return_status);
1433:
1434: --

Line 1432: WSH_UTIL_CORE.add_message(x_return_status);

1428: WHEN FTE_DIST_MANY_DEST_INPUT THEN
1429: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_MANY_DEST_INPUT');
1430: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1431: x_return_message := FND_MESSAGE.GET;
1432: WSH_UTIL_CORE.add_message(x_return_status);
1433:
1434: --
1435: -- Close any open cursors
1436: --

Line 1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1454:
1455:
1456: WHEN FTE_DIST_NULL_REGION_TYPE THEN
1457: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_REGION_TYPE');
1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1459: x_return_message := FND_MESSAGE.GET;
1460: WSH_UTIL_CORE.add_message(x_return_status);
1461:
1462: --

Line 1460: WSH_UTIL_CORE.add_message(x_return_status);

1456: WHEN FTE_DIST_NULL_REGION_TYPE THEN
1457: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NULL_REGION_TYPE');
1458: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1459: x_return_message := FND_MESSAGE.GET;
1460: WSH_UTIL_CORE.add_message(x_return_status);
1461:
1462: --
1463: -- Close any open cursors
1464: --

Line 1486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1482:
1483:
1484: WHEN FTE_DIST_NO_FILENAME THEN
1485: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILENAME');
1486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1487: x_return_message := FND_MESSAGE.GET;
1488: WSH_UTIL_CORE.add_message(x_return_status);
1489:
1490: --

Line 1488: WSH_UTIL_CORE.add_message(x_return_status);

1484: WHEN FTE_DIST_NO_FILENAME THEN
1485: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILENAME');
1486: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1487: x_return_message := FND_MESSAGE.GET;
1488: WSH_UTIL_CORE.add_message(x_return_status);
1489:
1490: --
1491: -- Close any open cursors
1492: --

Line 1514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1510:
1511:
1512: WHEN FTE_DIST_INVALID_FILE_LENGTH THEN
1513: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_LENGTH');
1514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1515: x_return_message := FND_MESSAGE.GET;
1516: WSH_UTIL_CORE.add_message(x_return_status);
1517:
1518: --

Line 1516: WSH_UTIL_CORE.add_message(x_return_status);

1512: WHEN FTE_DIST_INVALID_FILE_LENGTH THEN
1513: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_LENGTH');
1514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1515: x_return_message := FND_MESSAGE.GET;
1516: WSH_UTIL_CORE.add_message(x_return_status);
1517:
1518: --
1519: -- Close any open cursors
1520: --

Line 1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1538:
1539:
1540: WHEN FTE_DIST_INVALID_FILE_EXT THEN
1541: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_EXT');
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: x_return_message := FND_MESSAGE.GET;
1544: WSH_UTIL_CORE.add_message(x_return_status);
1545:
1546: --

Line 1544: WSH_UTIL_CORE.add_message(x_return_status);

1540: WHEN FTE_DIST_INVALID_FILE_EXT THEN
1541: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_FILE_EXT');
1542: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1543: x_return_message := FND_MESSAGE.GET;
1544: WSH_UTIL_CORE.add_message(x_return_status);
1545:
1546: --
1547: -- Close any open cursors
1548: --

Line 1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');

1628: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --
1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1634: x_return_message := l_error_text;
1635: --
1636: -- Debug Statements

Line 1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1629: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1630: END IF;
1631: --
1632: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.DOWNLOAD_OD_DATA');
1633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1634: x_return_message := l_error_text;
1635: --
1636: -- Debug Statements
1637: --

Line 1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1713: --
1714: -- Set the return flags for the start of the procedure
1715: --
1716: x_return_message := null;
1717: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1718:
1719:
1720: IF l_debug_on THEN
1721: WSH_DEBUG_SV.logmsg(l_module_name,'Opening c_get_file_id cursor');

Line 1763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1759: WSH_DEBUG_SV.log(l_module_name,'x_file_extension = ',x_file_extension);
1760: END IF;
1761:
1762: x_return_message := null;
1763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1764:
1765: --
1766: -- Debug Statements
1767: --

Line 1779: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1775: EXCEPTION
1776: WHEN FTE_DIST_NO_FILE_ID THEN
1777:
1778: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_ID');
1779: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1780: x_return_message := FND_MESSAGE.GET;
1781: WSH_UTIL_CORE.add_message(x_return_status);
1782:
1783: --

Line 1781: WSH_UTIL_CORE.add_message(x_return_status);

1777:
1778: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILE_ID');
1779: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1780: x_return_message := FND_MESSAGE.GET;
1781: WSH_UTIL_CORE.add_message(x_return_status);
1782:
1783: --
1784: -- Close any open cursors
1785: --

Line 1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');

1821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --
1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
1826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1827: x_return_message := x_return_message||' - '||l_error_text;
1828: --
1829: -- Debug Statements

Line 1826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1822: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1823: END IF;
1824: --
1825: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILENAME');
1826: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1827: x_return_message := x_return_message||' - '||l_error_text;
1828: --
1829: -- Debug Statements
1830: --

Line 2231: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2227: --
2228: -- Set the return flags for the start of the procedure
2229: --
2230: x_return_message := null;
2231: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2232:
2233:
2234: --
2235: -- reset the tables

Line 4873: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4869: WSH_DEBUG_SV.logmsg(l_module_name,'set the return status to success and return back to the calling procedure');
4870: END IF;
4871:
4872: x_return_message := null;
4873: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4874:
4875: --
4876: -- Debug Statements
4877: --

Line 4888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4884:
4885: EXCEPTION
4886: WHEN FTE_DIST_NO_ORIG_REG_VALS THEN
4887: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_ORIG_REG_VALS');
4888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4889: x_return_message := FND_MESSAGE.GET;
4890: WSH_UTIL_CORE.add_message(x_return_status);
4891: --
4892: -- Close the file

Line 4890: WSH_UTIL_CORE.add_message(x_return_status);

4886: WHEN FTE_DIST_NO_ORIG_REG_VALS THEN
4887: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_ORIG_REG_VALS');
4888: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4889: x_return_message := FND_MESSAGE.GET;
4890: WSH_UTIL_CORE.add_message(x_return_status);
4891: --
4892: -- Close the file
4893: --
4894: IF (utl_file.is_open(l_target_file)) THEN

Line 4944: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4940:
4941:
4942: WHEN FTE_DIST_NO_DEST_REG_VALS THEN
4943: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DEST_REG_VALS');
4944: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4945: x_return_message := FND_MESSAGE.GET;
4946: WSH_UTIL_CORE.add_message(x_return_status);
4947: --
4948: -- Close the file

Line 4946: WSH_UTIL_CORE.add_message(x_return_status);

4942: WHEN FTE_DIST_NO_DEST_REG_VALS THEN
4943: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DEST_REG_VALS');
4944: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4945: x_return_message := FND_MESSAGE.GET;
4946: WSH_UTIL_CORE.add_message(x_return_status);
4947: --
4948: -- Close the file
4949: --
4950: IF (utl_file.is_open(l_target_file)) THEN

Line 5001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4997:
4998:
4999: WHEN FTE_DIST_NO_COLS_FOR_TEMPLATE THEN
5000: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_COLS_FOR_TEMPLATE');
5001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5002: x_return_message := FND_MESSAGE.GET;
5003: WSH_UTIL_CORE.add_message(x_return_status);
5004: --
5005: -- Close the file

Line 5003: WSH_UTIL_CORE.add_message(x_return_status);

4999: WHEN FTE_DIST_NO_COLS_FOR_TEMPLATE THEN
5000: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_COLS_FOR_TEMPLATE');
5001: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5002: x_return_message := FND_MESSAGE.GET;
5003: WSH_UTIL_CORE.add_message(x_return_status);
5004: --
5005: -- Close the file
5006: --
5007: IF (utl_file.is_open(l_target_file)) THEN

Line 5060: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5056:
5057:
5058: WHEN FTE_DIST_NO_OD_COLS THEN
5059: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_OD_COLS');
5060: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5061: x_return_message := FND_MESSAGE.GET;
5062: WSH_UTIL_CORE.add_message(x_return_status);
5063:
5064: --

Line 5062: WSH_UTIL_CORE.add_message(x_return_status);

5058: WHEN FTE_DIST_NO_OD_COLS THEN
5059: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_OD_COLS');
5060: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5061: x_return_message := FND_MESSAGE.GET;
5062: WSH_UTIL_CORE.add_message(x_return_status);
5063:
5064: --
5065: -- close file
5066: --

Line 5117: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5113:
5114:
5115: WHEN FTE_DIST_NO_RET_COLS THEN
5116: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_COLS');
5117: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5118: x_return_message := FND_MESSAGE.GET;
5119: WSH_UTIL_CORE.add_message(x_return_status);
5120: --
5121: -- Close the file

Line 5119: WSH_UTIL_CORE.add_message(x_return_status);

5115: WHEN FTE_DIST_NO_RET_COLS THEN
5116: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_COLS');
5117: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5118: x_return_message := FND_MESSAGE.GET;
5119: WSH_UTIL_CORE.add_message(x_return_status);
5120: --
5121: -- Close the file
5122: --
5123: IF (utl_file.is_open(l_target_file)) THEN

Line 5173: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5169:
5170:
5171: WHEN FTE_DIST_NO_RET_ATTRS THEN
5172: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_ATTRS');
5173: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5174: x_return_message := FND_MESSAGE.GET;
5175: WSH_UTIL_CORE.add_message(x_return_status);
5176: --
5177: -- Close the file

Line 5175: WSH_UTIL_CORE.add_message(x_return_status);

5171: WHEN FTE_DIST_NO_RET_ATTRS THEN
5172: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_ATTRS');
5173: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5174: x_return_message := FND_MESSAGE.GET;
5175: WSH_UTIL_CORE.add_message(x_return_status);
5176: --
5177: -- Close the file
5178: --
5179: IF (utl_file.is_open(l_target_file)) THEN

Line 5231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5227:
5228:
5229: WHEN FTE_DIST_NO_OD_ATTRS THEN
5230: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_OD_ATTRS');
5231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5232: x_return_message := FND_MESSAGE.GET;
5233: WSH_UTIL_CORE.add_message(x_return_status);
5234: --
5235: -- Close the file

Line 5233: WSH_UTIL_CORE.add_message(x_return_status);

5229: WHEN FTE_DIST_NO_OD_ATTRS THEN
5230: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_OD_ATTRS');
5231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5232: x_return_message := FND_MESSAGE.GET;
5233: WSH_UTIL_CORE.add_message(x_return_status);
5234: --
5235: -- Close the file
5236: --
5237: IF (utl_file.is_open(l_target_file)) THEN

Line 5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5283:
5284:
5285: WHEN FTE_DIST_INVALID_START_POS THEN
5286: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_START_POS');
5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5288: x_return_message := FND_MESSAGE.GET;
5289: WSH_UTIL_CORE.add_message(x_return_status);
5290: --
5291: -- Close the file

Line 5289: WSH_UTIL_CORE.add_message(x_return_status);

5285: WHEN FTE_DIST_INVALID_START_POS THEN
5286: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_START_POS');
5287: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5288: x_return_message := FND_MESSAGE.GET;
5289: WSH_UTIL_CORE.add_message(x_return_status);
5290: --
5291: -- Close the file
5292: --
5293: IF (utl_file.is_open(l_target_file)) THEN

Line 5344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5340:
5341:
5342: WHEN FTE_DIST_INVALID_COL_LENGTHS THEN
5343: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_COL_LENGTHS');
5344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5345: x_return_message := FND_MESSAGE.GET;
5346: WSH_UTIL_CORE.add_message(x_return_status);
5347: --
5348: -- Close the file

Line 5346: WSH_UTIL_CORE.add_message(x_return_status);

5342: WHEN FTE_DIST_INVALID_COL_LENGTHS THEN
5343: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INVALID_COL_LENGTHS');
5344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5345: x_return_message := FND_MESSAGE.GET;
5346: WSH_UTIL_CORE.add_message(x_return_status);
5347: --
5348: -- Close the file
5349: --
5350: IF (utl_file.is_open(l_target_file)) THEN

Line 5398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5394:
5395:
5396: WHEN FTE_DIST_NO_LOC_REG_MAP THEN
5397: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_LOC_REG_MAP');
5398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5399: x_return_message := FND_MESSAGE.GET;
5400: WSH_UTIL_CORE.add_message(x_return_status);
5401: --
5402: -- Close the file

Line 5400: WSH_UTIL_CORE.add_message(x_return_status);

5396: WHEN FTE_DIST_NO_LOC_REG_MAP THEN
5397: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_LOC_REG_MAP');
5398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5399: x_return_message := FND_MESSAGE.GET;
5400: WSH_UTIL_CORE.add_message(x_return_status);
5401: --
5402: -- Close the file
5403: --
5404: IF (utl_file.is_open(l_target_file)) THEN

Line 5454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5450:
5451:
5452: WHEN FTE_DIST_NO_LOC_SPEC_R1 THEN
5453: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_LOC_SPEC_R1');
5454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5455: x_return_message := FND_MESSAGE.GET;
5456: WSH_UTIL_CORE.add_message(x_return_status);
5457: --
5458: -- Close the file

Line 5456: WSH_UTIL_CORE.add_message(x_return_status);

5452: WHEN FTE_DIST_NO_LOC_SPEC_R1 THEN
5453: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_LOC_SPEC_R1');
5454: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5455: x_return_message := FND_MESSAGE.GET;
5456: WSH_UTIL_CORE.add_message(x_return_status);
5457: --
5458: -- Close the file
5459: --
5460: IF (utl_file.is_open(l_target_file)) THEN

Line 5509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5505: RETURN;
5506:
5507: WHEN FTE_DIST_NO_REGION_SPEC_R2 THEN
5508: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGION_SPEC_R2');
5509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5510: x_return_message := FND_MESSAGE.GET;
5511: WSH_UTIL_CORE.add_message(x_return_status);
5512: --
5513: -- Close the file

Line 5511: WSH_UTIL_CORE.add_message(x_return_status);

5507: WHEN FTE_DIST_NO_REGION_SPEC_R2 THEN
5508: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_REGION_SPEC_R2');
5509: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5510: x_return_message := FND_MESSAGE.GET;
5511: WSH_UTIL_CORE.add_message(x_return_status);
5512: --
5513: -- Close the file
5514: --
5515: IF (utl_file.is_open(l_target_file)) THEN

Line 5564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5560: RETURN;
5561:
5562: WHEN FTE_DIST_NO_ELIG_FACILI_R3 THEN
5563: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_ELIG_FACILI_R3');
5564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5565: x_return_message := FND_MESSAGE.GET;
5566: WSH_UTIL_CORE.add_message(x_return_status);
5567: --
5568: -- Close the file

Line 5566: WSH_UTIL_CORE.add_message(x_return_status);

5562: WHEN FTE_DIST_NO_ELIG_FACILI_R3 THEN
5563: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_ELIG_FACILI_R3');
5564: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5565: x_return_message := FND_MESSAGE.GET;
5566: WSH_UTIL_CORE.add_message(x_return_status);
5567: --
5568: -- Close the file
5569: --
5570: IF (utl_file.is_open(l_target_file)) THEN

Line 5620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5616: RETURN;
5617:
5618: WHEN FTE_DIST_NO_DWNLD_DIR THEN
5619: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DWNLD_DIR');
5620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5621: x_return_message := FND_MESSAGE.GET;
5622: WSH_UTIL_CORE.add_message(x_return_status);
5623: --
5624: -- Close the file

Line 5622: WSH_UTIL_CORE.add_message(x_return_status);

5618: WHEN FTE_DIST_NO_DWNLD_DIR THEN
5619: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_DWNLD_DIR');
5620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5621: x_return_message := FND_MESSAGE.GET;
5622: WSH_UTIL_CORE.add_message(x_return_status);
5623: --
5624: -- Close the file
5625: --
5626: IF (utl_file.is_open(l_target_file)) THEN

Line 5675: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5671: RETURN;
5672:
5673: WHEN FTE_DIST_COL_ZERO_START THEN
5674: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_COL_ZERO_START');
5675: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5676: x_return_message := FND_MESSAGE.GET;
5677: WSH_UTIL_CORE.add_message(x_return_status);
5678: --
5679: -- Close the file

Line 5677: WSH_UTIL_CORE.add_message(x_return_status);

5673: WHEN FTE_DIST_COL_ZERO_START THEN
5674: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_COL_ZERO_START');
5675: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5676: x_return_message := FND_MESSAGE.GET;
5677: WSH_UTIL_CORE.add_message(x_return_status);
5678: --
5679: -- Close the file
5680: --
5681: IF (utl_file.is_open(l_target_file)) THEN

Line 5731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5727:
5728:
5729: WHEN utl_file.invalid_path THEN
5730: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_PATH');
5731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5732: x_return_message := FND_MESSAGE.GET;
5733: WSH_UTIL_CORE.add_message(x_return_status);
5734: --
5735: -- Close the file

Line 5733: WSH_UTIL_CORE.add_message(x_return_status);

5729: WHEN utl_file.invalid_path THEN
5730: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_PATH');
5731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5732: x_return_message := FND_MESSAGE.GET;
5733: WSH_UTIL_CORE.add_message(x_return_status);
5734: --
5735: -- Close the file
5736: --
5737: IF (utl_file.is_open(l_target_file)) THEN

Line 5786: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5782: RETURN;
5783:
5784: WHEN utl_file.invalid_mode THEN
5785: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_MODE');
5786: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5787: x_return_message := FND_MESSAGE.GET;
5788: WSH_UTIL_CORE.add_message(x_return_status);
5789: --
5790: -- Close the file

Line 5788: WSH_UTIL_CORE.add_message(x_return_status);

5784: WHEN utl_file.invalid_mode THEN
5785: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_MODE');
5786: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5787: x_return_message := FND_MESSAGE.GET;
5788: WSH_UTIL_CORE.add_message(x_return_status);
5789: --
5790: -- Close the file
5791: --
5792: IF (utl_file.is_open(l_target_file)) THEN

Line 5841: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5837: RETURN;
5838:
5839: WHEN utl_file.invalid_operation THEN
5840: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_OPERATION');
5841: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5842: x_return_message := FND_MESSAGE.GET;
5843: WSH_UTIL_CORE.add_message(x_return_status);
5844: --
5845: -- Close the file

Line 5843: WSH_UTIL_CORE.add_message(x_return_status);

5839: WHEN utl_file.invalid_operation THEN
5840: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_FILE_OPERATION');
5841: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5842: x_return_message := FND_MESSAGE.GET;
5843: WSH_UTIL_CORE.add_message(x_return_status);
5844: --
5845: -- Close the file
5846: --
5847: IF (utl_file.is_open(l_target_file)) THEN

Line 5897: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5893: RETURN;
5894:
5895: WHEN FTE_DIST_NO_RET_LENGTH THEN
5896: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_LENGTH');
5897: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5898: x_return_message := FND_MESSAGE.GET;
5899: WSH_UTIL_CORE.add_message(x_return_status);
5900: --
5901: -- Close the file

Line 5899: WSH_UTIL_CORE.add_message(x_return_status);

5895: WHEN FTE_DIST_NO_RET_LENGTH THEN
5896: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_LENGTH');
5897: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5898: x_return_message := FND_MESSAGE.GET;
5899: WSH_UTIL_CORE.add_message(x_return_status);
5900: --
5901: -- Close the file
5902: --
5903: IF (utl_file.is_open(l_target_file)) THEN

Line 5953: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5949:
5950:
5951: WHEN FTE_DIST_NO_RET_ATTR THEN
5952: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_ATTR');
5953: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5954: x_return_message := FND_MESSAGE.GET;
5955: WSH_UTIL_CORE.add_message(x_return_status);
5956: --
5957: -- Close the file

Line 5955: WSH_UTIL_CORE.add_message(x_return_status);

5951: WHEN FTE_DIST_NO_RET_ATTR THEN
5952: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_RET_ATTR');
5953: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5954: x_return_message := FND_MESSAGE.GET;
5955: WSH_UTIL_CORE.add_message(x_return_status);
5956: --
5957: -- Close the file
5958: --
5959: IF (utl_file.is_open(l_target_file)) THEN

Line 6009: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6005:
6006:
6007: WHEN FTE_DIST_RET_DIST_INV_LENGTH THEN
6008: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_INV_LENGTH');
6009: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6010: x_return_message := FND_MESSAGE.GET;
6011: WSH_UTIL_CORE.add_message(x_return_status);
6012: --
6013: -- Close the file

Line 6011: WSH_UTIL_CORE.add_message(x_return_status);

6007: WHEN FTE_DIST_RET_DIST_INV_LENGTH THEN
6008: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_INV_LENGTH');
6009: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6010: x_return_message := FND_MESSAGE.GET;
6011: WSH_UTIL_CORE.add_message(x_return_status);
6012: --
6013: -- Close the file
6014: --
6015: IF (utl_file.is_open(l_target_file)) THEN

Line 6065: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6061:
6062:
6063: WHEN FTE_DIST_RET_DIST_INV_START THEN
6064: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_INV_START');
6065: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6066: x_return_message := FND_MESSAGE.GET;
6067: WSH_UTIL_CORE.add_message(x_return_status);
6068: --
6069: -- Close the file

Line 6067: WSH_UTIL_CORE.add_message(x_return_status);

6063: WHEN FTE_DIST_RET_DIST_INV_START THEN
6064: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_DIST_INV_START');
6065: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6066: x_return_message := FND_MESSAGE.GET;
6067: WSH_UTIL_CORE.add_message(x_return_status);
6068: --
6069: -- Close the file
6070: --
6071: IF (utl_file.is_open(l_target_file)) THEN

Line 6120: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6116:
6117:
6118: WHEN FTE_DIST_RET_TIME_INV_LENGTH THEN
6119: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_INV_LENGTH');
6120: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6121: x_return_message := FND_MESSAGE.GET;
6122: WSH_UTIL_CORE.add_message(x_return_status);
6123: --
6124: -- Close the file

Line 6122: WSH_UTIL_CORE.add_message(x_return_status);

6118: WHEN FTE_DIST_RET_TIME_INV_LENGTH THEN
6119: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_INV_LENGTH');
6120: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6121: x_return_message := FND_MESSAGE.GET;
6122: WSH_UTIL_CORE.add_message(x_return_status);
6123: --
6124: -- Close the file
6125: --
6126: IF (utl_file.is_open(l_target_file)) THEN

Line 6177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6173:
6174:
6175: WHEN FTE_DIST_RET_TIME_INV_START THEN
6176: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_INV_START');
6177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6178: x_return_message := FND_MESSAGE.GET;
6179: WSH_UTIL_CORE.add_message(x_return_status);
6180: --
6181: -- Close the file

Line 6179: WSH_UTIL_CORE.add_message(x_return_status);

6175: WHEN FTE_DIST_RET_TIME_INV_START THEN
6176: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_RET_TIME_INV_START');
6177: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6178: x_return_message := FND_MESSAGE.GET;
6179: WSH_UTIL_CORE.add_message(x_return_status);
6180: --
6181: -- Close the file
6182: --
6183: IF (utl_file.is_open(l_target_file)) THEN

Line 6232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6228:
6229:
6230: WHEN FTE_DIST_NO_OD_PAIRS THEN
6231: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_OD_PAIRS');
6232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6233: x_return_message := FND_MESSAGE.GET;
6234: WSH_UTIL_CORE.add_message(x_return_status);
6235: --
6236: -- Close the file

Line 6234: WSH_UTIL_CORE.add_message(x_return_status);

6230: WHEN FTE_DIST_NO_OD_PAIRS THEN
6231: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_OD_PAIRS');
6232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6233: x_return_message := FND_MESSAGE.GET;
6234: WSH_UTIL_CORE.add_message(x_return_status);
6235: --
6236: -- Close the file
6237: --
6238: IF (utl_file.is_open(l_target_file)) THEN

Line 6286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6282: RETURN;
6283:
6284: WHEN FTE_DIST_NO_MATCH_REGIONS_FND THEN
6285: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_MATCH_REGIONS_FND');
6286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6287: x_return_message := FND_MESSAGE.GET;
6288: WSH_UTIL_CORE.add_message(x_return_status);
6289: --
6290: -- Close the file

Line 6288: WSH_UTIL_CORE.add_message(x_return_status);

6284: WHEN FTE_DIST_NO_MATCH_REGIONS_FND THEN
6285: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_MATCH_REGIONS_FND');
6286: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6287: x_return_message := FND_MESSAGE.GET;
6288: WSH_UTIL_CORE.add_message(x_return_status);
6289: --
6290: -- Close the file
6291: --
6292: IF (utl_file.is_open(l_target_file)) THEN

Line 6340: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6336: RETURN;
6337:
6338: WHEN FTE_DIST_INV_REGION_LOW THEN
6339: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_REGION_LOW');
6340: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6341: x_return_message := FND_MESSAGE.GET;
6342: WSH_UTIL_CORE.add_message(x_return_status);
6343: --
6344: -- Close the file

Line 6342: WSH_UTIL_CORE.add_message(x_return_status);

6338: WHEN FTE_DIST_INV_REGION_LOW THEN
6339: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_INV_REGION_LOW');
6340: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6341: x_return_message := FND_MESSAGE.GET;
6342: WSH_UTIL_CORE.add_message(x_return_status);
6343: --
6344: -- Close the file
6345: --
6346: IF (utl_file.is_open(l_target_file)) THEN

Line 6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');

6440: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --
6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');
6445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6446: x_return_message := l_error_text;
6447:
6448: RETURN;

Line 6445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6441: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6442: END IF;
6443: --
6444: WSH_UTIL_CORE.default_handler('FTE_DIST_DWNLD_PKG.CREATE_DWNLD_FILE');
6445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6446: x_return_message := l_error_text;
6447:
6448: RETURN;
6449: