326: argument12 => p_dest_all_fac_flag,
327: argument13 => l_file_extension);
328:
329:
330: x_error_msg_text := fnd_message.get;
331:
332: IF l_debug_on THEN
333: WSH_DEBUG_SV.log(l_module_name,'x_request_id',x_request_id);
334: WSH_DEBUG_SV.log(l_module_name,'x_error_msg_text',x_error_msg_text);
366: --
367: RETURN;
368:
369: WHEN FTE_DIST_NO_FILENAME THEN
370: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILENAME');
371: x_error_msg_text := FND_MESSAGE.GET;
372: Fnd_File.Put_Line(Fnd_File.Log, x_error_msg_text);
373: x_request_id := 0;
374: --
367: RETURN;
368:
369: WHEN FTE_DIST_NO_FILENAME THEN
370: FND_MESSAGE.SET_NAME('FTE','FTE_DIST_NO_FILENAME');
371: x_error_msg_text := FND_MESSAGE.GET;
372: Fnd_File.Put_Line(Fnd_File.Log, x_error_msg_text);
373: x_request_id := 0;
374: --
375: -- Debug Statements
1260:
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:
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: --
1270: -- Close any open cursors
1288: RETURN;
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:
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: --
1298: -- Close any open cursors
1316: RETURN;
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:
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: --
1326: -- Close any open cursors
1344: RETURN;
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:
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: --
1354: -- Close any open cursors
1371: --
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:
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: --
1381: -- Close any open cursors
1398: --
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:
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: --
1408: -- Close any open cursors
1425: --
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:
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: --
1435: -- Close any open cursors
1453: RETURN;
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:
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: --
1463: -- Close any open cursors
1481: RETURN;
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:
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: --
1491: -- Close any open cursors
1509: RETURN;
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:
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: --
1519: -- Close any open cursors
1537: RETURN;
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:
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: --
1547: -- Close any open cursors
1774:
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:
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: --
1784: -- Close any open cursors
4883:
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: --
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
4893: --
4939: RETURN;
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: --
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
4949: --
4996:
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: --
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
5006: --
5055:
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:
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: --
5065: -- close file
5112: RETURN;
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: --
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
5122: --
5168: RETURN;
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: --
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
5178: --
5226: RETURN;
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: --
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
5236: --
5282: RETURN;
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: --
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
5292: --
5339: RETURN;
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: --
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
5349: --
5393: RETURN;
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: --
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
5403: --
5449: RETURN;
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: --
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
5459: --
5504: --
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: --
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
5514: --
5559: --
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: --
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
5569: --
5615: --
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: --
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
5625: --
5670: --
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: --
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
5680: --
5726: RETURN;
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: --
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
5736: --
5781: --
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: --
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
5791: --
5836: --
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: --
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
5846: --
5892: --
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: --
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
5902: --
5948: RETURN;
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: --
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
5958: --
6004: RETURN;
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: --
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
6014: --
6060:
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: --
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
6070: --
6115: RETURN;
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: --
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
6125: --
6172:
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: --
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
6182: --
6227: RETURN;
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: --
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
6237: --
6281: --
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: --
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
6291: --
6335: --
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: --
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
6345: --