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_VALIDATION_PKG dependencies on STRINGARRAY

Line 85: p_tokens => STRINGARRAY('DATE'),

81: p_date := TO_DATE(p_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT3);
82: EXCEPTION
83: WHEN OTHERS THEN
84: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
85: p_tokens => STRINGARRAY('DATE'),
86: p_values => STRINGARRAY(p_date));
87: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
88: p_msg => x_error_msg,
89: p_category => 'D',

Line 86: p_values => STRINGARRAY(p_date));

82: EXCEPTION
83: WHEN OTHERS THEN
84: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
85: p_tokens => STRINGARRAY('DATE'),
86: p_values => STRINGARRAY(p_date));
87: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
88: p_msg => x_error_msg,
89: p_category => 'D',
90: p_line_number => p_line_number);

Line 99: p_tokens => STRINGARRAY('DATE'),

95: END;
96:
97: IF (p_date IS NULL) THEN
98: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
99: p_tokens => STRINGARRAY('DATE'),
100: p_values => STRINGARRAY(p_date));
101: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
102: p_msg => x_error_msg,
103: p_category => 'D',

Line 100: p_values => STRINGARRAY(p_date));

96:
97: IF (p_date IS NULL) THEN
98: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
99: p_tokens => STRINGARRAY('DATE'),
100: p_values => STRINGARRAY(p_date));
101: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
102: p_msg => x_error_msg,
103: p_category => 'D',
104: p_line_number => p_line_number);

Line 544: p_tokens => STRINGARRAY('TYPE'),

540: l_rate_type := 'BREAKUNIT_PRICE';
541: ELSIF (p_rate_type NOT IN ('LUMPSUM')) THEN
542: x_status := 2;
543: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_TYPE_INVALID',
544: p_tokens => STRINGARRAY('TYPE'),
545: p_values => STRINGARRAY(p_rate_type));
546:
547: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
548: p_msg => x_error_msg,

Line 545: p_values => STRINGARRAY(p_rate_type));

541: ELSIF (p_rate_type NOT IN ('LUMPSUM')) THEN
542: x_status := 2;
543: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_TYPE_INVALID',
544: p_tokens => STRINGARRAY('TYPE'),
545: p_values => STRINGARRAY(p_rate_type));
546:
547: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
548: p_msg => x_error_msg,
549: p_category => 'D',

Line 686: P_Tokens => STRINGARRAY('SERVICE_TYPE'),

682: l_service_code := FTE_UTIL_PKG.GET_LOOKUP_CODE('WSH_SERVICE_LEVELS', p_service_level);
683:
684: IF (l_service_code IS NULL) THEN
685: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_SERVICE_UNKNOWN',
686: P_Tokens => STRINGARRAY('SERVICE_TYPE'),
687: P_values => STRINGARRAY(p_service_level));
688: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
689: p_msg => x_error_msg,
690: p_category => 'B',

Line 687: P_values => STRINGARRAY(p_service_level));

683:
684: IF (l_service_code IS NULL) THEN
685: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_SERVICE_UNKNOWN',
686: P_Tokens => STRINGARRAY('SERVICE_TYPE'),
687: P_values => STRINGARRAY(p_service_level));
688: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
689: p_msg => x_error_msg,
690: p_category => 'B',
691: p_line_number => p_line_number);

Line 732: p_tokens => STRINGARRAY('SERVICE_LEVEL', 'CARRIER_NAME'),

728: l_carrier_name := p_carrier_name;
729: END IF;
730:
731: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_SERVICE_INVALID',
732: p_tokens => STRINGARRAY('SERVICE_LEVEL', 'CARRIER_NAME'),
733: p_values => STRINGARRAY(p_service_level, l_carrier_name));
734:
735: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
736: p_msg => x_error_msg,

Line 733: p_values => STRINGARRAY(p_service_level, l_carrier_name));

729: END IF;
730:
731: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_SERVICE_INVALID',
732: p_tokens => STRINGARRAY('SERVICE_LEVEL', 'CARRIER_NAME'),
733: p_values => STRINGARRAY(p_service_level, l_carrier_name));
734:
735: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
736: p_msg => x_error_msg,
737: p_category => 'D',

Line 1064: p_tokens => STRINGARRAY('NAME'),

1060: p_attribute1 => l_temp);
1061:
1062: IF (l_result = -1) THEN
1063: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
1064: p_tokens => STRINGARRAY('NAME'),
1065: p_values => STRINGARRAY(p_price_prefix || p_array(i)));
1066:
1067: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1068: p_msg => x_error_msg,

Line 1065: p_values => STRINGARRAY(p_price_prefix || p_array(i)));

1061:
1062: IF (l_result = -1) THEN
1063: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
1064: p_tokens => STRINGARRAY('NAME'),
1065: p_values => STRINGARRAY(p_price_prefix || p_array(i)));
1066:
1067: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1068: p_msg => x_error_msg,
1069: p_category => 'D',

Line 1101: -- Returns STRINGARRAY of the columns

1097: --
1098: -- IN parameters:
1099: -- 1. p_type: type of the block which column is requested
1100: --
1101: -- Returns STRINGARRAY of the columns
1102: ----------------------------------------------------------------------------
1103: FUNCTION GET_COLUMN (p_type IN VARCHAR2) RETURN STRINGARRAY IS
1104: BEGIN
1105: IF (p_type = 'TL_BASE_RATES') THEN

Line 1103: FUNCTION GET_COLUMN (p_type IN VARCHAR2) RETURN STRINGARRAY IS

1099: -- 1. p_type: type of the block which column is requested
1100: --
1101: -- Returns STRINGARRAY of the columns
1102: ----------------------------------------------------------------------------
1103: FUNCTION GET_COLUMN (p_type IN VARCHAR2) RETURN STRINGARRAY IS
1104: BEGIN
1105: IF (p_type = 'TL_BASE_RATES') THEN
1106: RETURN TL_BASE_RATES;
1107: ELSIF (p_type = 'SERVICE') THEN

Line 1154: -- 1. p_keys: columns STRINGARRAY

1150: --
1151: -- Purpose: check if the columns read is valid
1152: --
1153: -- IN parameters:
1154: -- 1. p_keys: columns STRINGARRAY
1155: -- 2. p_type: type of the block
1156: -- 3. p_line_number: line number
1157: --
1158: -- OUT parameters:

Line 1169: l_column STRINGARRAY := STRINGARRAY();

1165: x_status OUT NOCOPY NUMBER,
1166: x_error_msg OUT NOCOPY VARCHAR2) IS
1167:
1168: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.VALIDATE_COLUMNS';
1169: l_column STRINGARRAY := STRINGARRAY();
1170: l_found BOOLEAN := false;
1171: BEGIN
1172: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1173:

Line 1198: p_tokens => STRINGARRAY('COLUMN', 'SECTION'),

1194: FOR i IN 1..l_column.COUNT LOOP
1195: IF (NOT p_keys.EXISTS(l_column(i))) THEN
1196: x_status := 2;
1197: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_MISSING_COLUMN',
1198: p_tokens => STRINGARRAY('COLUMN', 'SECTION'),
1199: p_values => STRINGARRAY(l_column(i), p_type));
1200: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1201: p_msg => x_error_msg,
1202: p_category => 'D',

Line 1199: p_values => STRINGARRAY(l_column(i), p_type));

1195: IF (NOT p_keys.EXISTS(l_column(i))) THEN
1196: x_status := 2;
1197: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_MISSING_COLUMN',
1198: p_tokens => STRINGARRAY('COLUMN', 'SECTION'),
1199: p_values => STRINGARRAY(l_column(i), p_type));
1200: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1201: p_msg => x_error_msg,
1202: p_category => 'D',
1203: p_line_number => p_line_number);

Line 1219: P_Tokens => STRINGARRAY('COLUMN', 'SECTION'),

1215: FOR i IN 1..FTE_BULKLOAD_PKG.g_block_header_index.COUNT LOOP
1216: IF (FTE_BULKLOAD_PKG.g_block_header_index(i) IS NOT NULL) THEN
1217: x_status := 2;
1218: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_INVALID_COLUMN',
1219: P_Tokens => STRINGARRAY('COLUMN', 'SECTION'),
1220: p_values => STRINGARRAY(l_column(i), p_type));
1221:
1222: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1223: p_msg => x_error_msg,

Line 1220: p_values => STRINGARRAY(l_column(i), p_type));

1216: IF (FTE_BULKLOAD_PKG.g_block_header_index(i) IS NOT NULL) THEN
1217: x_status := 2;
1218: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_INVALID_COLUMN',
1219: P_Tokens => STRINGARRAY('COLUMN', 'SECTION'),
1220: p_values => STRINGARRAY(l_column(i), p_type));
1221:
1222: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1223: p_msg => x_error_msg,
1224: p_category => 'D',

Line 1280: p_tokens => STRINGARRAY('CARRIER_NAME'),

1276: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
1277: END IF;
1278: IF (p_carrier_id = -1) THEN
1279: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_CARRIER_INVALID',
1280: p_tokens => STRINGARRAY('CARRIER_NAME'),
1281: p_values => STRINGARRAY(p_carrier_name));
1282:
1283: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1284: p_msg => x_error_msg,

Line 1281: p_values => STRINGARRAY(p_carrier_name));

1277: END IF;
1278: IF (p_carrier_id = -1) THEN
1279: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_CARRIER_INVALID',
1280: p_tokens => STRINGARRAY('CARRIER_NAME'),
1281: p_values => STRINGARRAY(p_carrier_name));
1282:
1283: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1284: p_msg => x_error_msg,
1285: p_category => 'C',

Line 1362: p_tokens => STRINGARRAY('SERVICE_NUMBER'),

1358: -- Vijay: added clause to check if laneId is already populated
1359: p_lane_id := FTE_LANE_PKG.GET_LANE_ID(p_lane_number, p_carrier_id);
1360: IF (p_lane_id = -1) THEN
1361: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_LANE_NUMBER_INVALID',
1362: p_tokens => STRINGARRAY('SERVICE_NUMBER'),
1363: p_values => STRINGARRAY(p_lane_number));
1364: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1365: p_msg => x_error_msg,
1366: p_category => 'C',

Line 1363: p_values => STRINGARRAY(p_lane_number));

1359: p_lane_id := FTE_LANE_PKG.GET_LANE_ID(p_lane_number, p_carrier_id);
1360: IF (p_lane_id = -1) THEN
1361: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_LANE_NUMBER_INVALID',
1362: p_tokens => STRINGARRAY('SERVICE_NUMBER'),
1363: p_values => STRINGARRAY(p_lane_number));
1364: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1365: p_msg => x_error_msg,
1366: p_category => 'C',
1367: p_line_number => p_line_number);

Line 1429: p_tokens => STRINGARRAY('ACTION'),

1425: ELSE
1426: p_action := UPPER(p_action);
1427: IF (p_type = 'ZONE' AND p_action <> 'ADD') THEN
1428: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_ACTION_INVALID_ZONE',
1429: p_tokens => STRINGARRAY('ACTION'),
1430: p_values => STRINGARRAY(p_action));
1431: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1432: p_msg => x_error_msg,
1433: p_category => 'D',

Line 1430: p_values => STRINGARRAY(p_action));

1426: p_action := UPPER(p_action);
1427: IF (p_type = 'ZONE' AND p_action <> 'ADD') THEN
1428: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_ACTION_INVALID_ZONE',
1429: p_tokens => STRINGARRAY('ACTION'),
1430: p_values => STRINGARRAY(p_action));
1431: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1432: p_msg => x_error_msg,
1433: p_category => 'D',
1434: p_line_number => p_line_number);

Line 1442: p_tokens => STRINGARRAY('ACTION'),

1438: END IF;
1439:
1440: IF (p_type = 'REGION' AND p_action <> 'ADD') THEN
1441: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_ACTION_INVALID_REGION',
1442: p_tokens => STRINGARRAY('ACTION'),
1443: p_values => STRINGARRAY(p_action));
1444: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1445: p_msg => x_error_msg,
1446: p_category => 'D',

Line 1443: p_values => STRINGARRAY(p_action));

1439:
1440: IF (p_type = 'REGION' AND p_action <> 'ADD') THEN
1441: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_ACTION_INVALID_REGION',
1442: p_tokens => STRINGARRAY('ACTION'),
1443: p_values => STRINGARRAY(p_action));
1444: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1445: p_msg => x_error_msg,
1446: p_category => 'D',
1447: p_line_number => p_line_number);

Line 1613: p_tokens => STRINGARRAY('UOM'),

1609: p_uom_code := FTE_UTIL_PKG.GET_UOM_CODE(p_uom, p_class);
1610: IF (p_uom_code IS NULL) THEN
1611: IF (p_class IS NULL) THEN
1612: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
1613: p_tokens => STRINGARRAY('UOM'),
1614: p_values => STRINGARRAY(p_uom));
1615: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1616: p_msg => x_error_msg,
1617: p_category => 'B',

Line 1614: p_values => STRINGARRAY(p_uom));

1610: IF (p_uom_code IS NULL) THEN
1611: IF (p_class IS NULL) THEN
1612: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
1613: p_tokens => STRINGARRAY('UOM'),
1614: p_values => STRINGARRAY(p_uom));
1615: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1616: p_msg => x_error_msg,
1617: p_category => 'B',
1618: p_line_number => p_line_number);

Line 1624: p_tokens => STRINGARRAY('UOM'),

1620: x_status := 1;
1621: RETURN;
1622: ELSIF (p_class = 'Weight') THEN
1623: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_WT_UOM_INVALID',
1624: p_tokens => STRINGARRAY('UOM'),
1625: p_values => STRINGARRAY(p_uom));
1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1627: p_msg => x_error_msg,
1628: p_category => 'A',

Line 1625: p_values => STRINGARRAY(p_uom));

1621: RETURN;
1622: ELSIF (p_class = 'Weight') THEN
1623: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_WT_UOM_INVALID',
1624: p_tokens => STRINGARRAY('UOM'),
1625: p_values => STRINGARRAY(p_uom));
1626: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1627: p_msg => x_error_msg,
1628: p_category => 'A',
1629: p_line_number => p_line_number);

Line 1635: p_tokens => STRINGARRAY('UOM'),

1631: x_status := 1;
1632: RETURN;
1633: ELSIF (p_class = 'Volume') THEN
1634: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VOL_UOM_INVALID',
1635: p_tokens => STRINGARRAY('UOM'),
1636: p_values => STRINGARRAY(p_uom));
1637: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1638: p_msg => x_error_msg,
1639: p_category => 'A',

Line 1636: p_values => STRINGARRAY(p_uom));

1632: RETURN;
1633: ELSIF (p_class = 'Volume') THEN
1634: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VOL_UOM_INVALID',
1635: p_tokens => STRINGARRAY('UOM'),
1636: p_values => STRINGARRAY(p_uom));
1637: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1638: p_msg => x_error_msg,
1639: p_category => 'A',
1640: p_line_number => p_line_number);

Line 1646: p_tokens => STRINGARRAY('UOM'),

1642: x_status := 1;
1643: RETURN;
1644: ELSIF (p_class = 'Length') THEN
1645: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DIM_UOM_INVALID',
1646: p_tokens => STRINGARRAY('UOM'),
1647: p_values =>STRINGARRAY(p_uom));
1648: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1649: p_msg => x_error_msg,
1650: p_category => 'A',

Line 1647: p_values =>STRINGARRAY(p_uom));

1643: RETURN;
1644: ELSIF (p_class = 'Length') THEN
1645: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DIM_UOM_INVALID',
1646: p_tokens => STRINGARRAY('UOM'),
1647: p_values =>STRINGARRAY(p_uom));
1648: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1649: p_msg => x_error_msg,
1650: p_category => 'A',
1651: p_line_number => p_line_number);

Line 1657: p_tokens => STRINGARRAY('UOM'),

1653: x_status := 1;
1654: RETURN;
1655: ELSIF (p_class = 'Time') THEN
1656: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
1657: p_tokens => STRINGARRAY('UOM'),
1658: p_values => STRINGARRAY(p_uom));
1659: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1660: p_msg => x_error_msg,
1661: p_category => 'B',

Line 1658: p_values => STRINGARRAY(p_uom));

1654: RETURN;
1655: ELSIF (p_class = 'Time') THEN
1656: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
1657: p_tokens => STRINGARRAY('UOM'),
1658: p_values => STRINGARRAY(p_uom));
1659: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1660: p_msg => x_error_msg,
1661: p_category => 'B',
1662: p_line_number => p_line_number);

Line 1743: p_tokens => STRINGARRAY('MODE'),

1739: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1740: RETURN;
1741: ELSE
1742: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_MODE_INVALID',
1743: p_tokens => STRINGARRAY('MODE'),
1744: p_values => STRINGARRAY(p_mode));
1745: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1746: p_msg => x_error_msg,
1747: p_category => 'D',

Line 1744: p_values => STRINGARRAY(p_mode));

1740: RETURN;
1741: ELSE
1742: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_MODE_INVALID',
1743: p_tokens => STRINGARRAY('MODE'),
1744: p_values => STRINGARRAY(p_mode));
1745: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1746: p_msg => x_error_msg,
1747: p_category => 'D',
1748: p_line_number => p_line_number);

Line 1755: p_tokens => STRINGARRAY('MODE'),

1751: RETURN;
1752: END IF;
1753: ELSE
1754: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_MODE_OF_TRANS_INVALID',
1755: p_tokens => STRINGARRAY('MODE'),
1756: p_values => STRINGARRAY(p_mode));
1757: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1758: p_msg => x_error_msg,
1759: p_category => 'D',

Line 1756: p_values => STRINGARRAY(p_mode));

1752: END IF;
1753: ELSE
1754: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_MODE_OF_TRANS_INVALID',
1755: p_tokens => STRINGARRAY('MODE'),
1756: p_values => STRINGARRAY(p_mode));
1757: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1758: p_msg => x_error_msg,
1759: p_category => 'D',
1760: p_line_number => p_line_number);

Line 1792: -- 1. p_chart_info: a STRINGARRAY that contains name_prefix, mode_of_trans, carrier_name,

1788: -- 1. p_values: pl/sql table of the rating zone chart line
1789: -- 2. p_line_number: line number of current line
1790: --
1791: -- OUT parameters:
1792: -- 1. p_chart_info: a STRINGARRAY that contains name_prefix, mode_of_trans, carrier_name,
1793: -- carrier_id, price_prefix, view_flag, start_date, and end_date
1794: -- 2. x_status: status of the processing, -1 means no error
1795: -- 3. x_error_msg: error message if any.
1796: ----------------------------------------------------------------------------

Line 1799: p_chart_info OUT NOCOPY STRINGARRAY,

1795: -- 3. x_error_msg: error message if any.
1796: ----------------------------------------------------------------------------
1797: PROCEDURE VALIDATE_RATING_ZONE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
1798: p_line_number IN NUMBER,
1799: p_chart_info OUT NOCOPY STRINGARRAY,
1800: x_status OUT NOCOPY NUMBER,
1801: x_error_msg OUT NOCOPY VARCHAR2) IS
1802:
1803: l_name_prefix VARCHAR2(200);

Line 1868: p_tokens => STRINGARRAY('FLAG'),

1864: IF (l_view_flag IS NULL) THEN
1865: l_view_flag := 'N';
1866: ELSIF (l_view_flag NOT IN ('Y', 'N')) THEN
1867: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_VIEW_INVALID',
1868: p_tokens => STRINGARRAY('FLAG'),
1869: p_values => STRINGARRAY(l_view_flag));
1870: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1871: p_msg => x_error_msg,
1872: p_category => 'D',

Line 1869: p_values => STRINGARRAY(l_view_flag));

1865: l_view_flag := 'N';
1866: ELSIF (l_view_flag NOT IN ('Y', 'N')) THEN
1867: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_VIEW_INVALID',
1868: p_tokens => STRINGARRAY('FLAG'),
1869: p_values => STRINGARRAY(l_view_flag));
1870: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1871: p_msg => x_error_msg,
1872: p_category => 'D',
1873: p_line_number => p_line_number);

Line 1905: p_chart_info := STRINGARRAY(l_name_prefix, l_mode_of_trans, '', l_carrier_name,

1901: END IF;
1902:
1903: --VALIDATE_EFFECTIVE_DATE
1904:
1905: p_chart_info := STRINGARRAY(l_name_prefix, l_mode_of_trans, '', l_carrier_name,
1906: l_price_prefix, l_view_flag, l_carrier_id,
1907: l_start_date, l_end_date);
1908: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1909: EXCEPTION

Line 1995: p_setup_info(l_count) := STRINGARRAY(l_service_type, l_type, l_subtype, l_name,

1991: END IF;
1992:
1993: l_count := p_setup_info.COUNT+1;
1994: IF (p_last_service_type IS NULL OR (p_last_service_type IS NOT NULL AND l_service_type <> p_last_service_type)) THEN
1995: p_setup_info(l_count) := STRINGARRAY(l_service_type, l_type, l_subtype, l_name,
1996: l_value_from, l_value_to, l_uom, l_currency);
1997: ELSE
1998: p_setup_info(l_count) := STRINGARRAY('', l_type, l_subtype, l_name,
1999: l_value_from, l_value_to, l_uom, l_currency);

Line 1998: p_setup_info(l_count) := STRINGARRAY('', l_type, l_subtype, l_name,

1994: IF (p_last_service_type IS NULL OR (p_last_service_type IS NOT NULL AND l_service_type <> p_last_service_type)) THEN
1995: p_setup_info(l_count) := STRINGARRAY(l_service_type, l_type, l_subtype, l_name,
1996: l_value_from, l_value_to, l_uom, l_currency);
1997: ELSE
1998: p_setup_info(l_count) := STRINGARRAY('', l_type, l_subtype, l_name,
1999: l_value_from, l_value_to, l_uom, l_currency);
2000: END IF;
2001:
2002: p_last_service_type := l_service_type;

Line 2027: -- 1. p_origin: STRINGARRAY of origin_postal, origin_country, origin_state, and origin_city

2023: -- 1. p_values: pl/sql table of origin line
2024: -- 2. p_line_number: line number of current line
2025: --
2026: -- OUT parameters:
2027: -- 1. p_origin: STRINGARRAY of origin_postal, origin_country, origin_state, and origin_city
2028: -- 2. x_status: status of the processing, -1 means no error
2029: -- 3. x_error_msg: error message if any.
2030: ----------------------------------------------------------------------------
2031: PROCEDURE VALIDATE_ORIGIN(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

Line 2033: p_origin OUT NOCOPY STRINGARRAY,

2029: -- 3. x_error_msg: error message if any.
2030: ----------------------------------------------------------------------------
2031: PROCEDURE VALIDATE_ORIGIN(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2032: p_line_number IN NUMBER,
2033: p_origin OUT NOCOPY STRINGARRAY,
2034: x_status OUT NOCOPY NUMBER,
2035: x_error_msg OUT NOCOPY VARCHAR2) IS
2036:
2037: l_origin_postal VARCHAR2(200);

Line 2076: p_origin := STRINGARRAY(l_origin_postal, l_origin_country, l_origin_state, l_origin_city);

2072: x_status := 1;
2073: RETURN;
2074: END IF;
2075:
2076: p_origin := STRINGARRAY(l_origin_postal, l_origin_country, l_origin_state, l_origin_city);
2077:
2078: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
2079: EXCEPTION
2080: WHEN OTHERS THEN

Line 2106: -- 1. p_dest: STRINGARRAY of dest_postal, dest_country, dest_state, and dest_city

2102: -- 6. p_service_count: number of service columns
2103: -- 7. p_services: service column names
2104: --
2105: -- OUT parameters:
2106: -- 1. p_dest: STRINGARRAY of dest_postal, dest_country, dest_state, and dest_city
2107: -- 2. x_status: status of the processing, -1 means no error
2108: -- 3. x_error_msg: error message if any.
2109: ----------------------------------------------------------------------------
2110: PROCEDURE VALIDATE_DESTINATION(p_values IN OUT NOCOPY FTE_BULKLOAD_PKG.data_values_tbl,

Line 2117: p_dest OUT NOCOPY STRINGARRAY,

2113: p_carrier_id IN NUMBER,
2114: p_origin_zone IN FTE_BULKLOAD_PKG.data_values_tbl,
2115: p_service_count IN OUT NOCOPY NUMBER,
2116: p_services IN OUT NOCOPY FTE_PARCEL_LOADER.service_array,
2117: p_dest OUT NOCOPY STRINGARRAY,
2118: x_status OUT NOCOPY NUMBER,
2119: x_error_msg OUT NOCOPY VARCHAR2) IS
2120:
2121: l_service_value VARCHAR2(200);

Line 2199: p_dest := STRINGARRAY(l_dest_postal, l_dest_country, l_dest_state, l_dest_city);

2195: x_status := 1;
2196: RETURN;
2197: END IF;
2198:
2199: p_dest := STRINGARRAY(l_dest_postal, l_dest_country, l_dest_state, l_dest_city);
2200:
2201: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
2202: EXCEPTION
2203: WHEN OTHERS THEN

Line 2239: l_rate_chart_info STRINGARRAY := STRINGARRAY();

2235: p_set_error IN BOOLEAN DEFAULT TRUE,
2236: x_status OUT NOCOPY NUMBER,
2237: x_error_msg OUT NOCOPY VARCHAR2) IS
2238: l_rate_chart_name VARCHAR2(200);
2239: l_rate_chart_info STRINGARRAY := STRINGARRAY();
2240: l_count NUMBER;
2241: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.VALIDATE_LANE_RATE_CHART';
2242: BEGIN
2243: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);

Line 2296: p_tokens => STRINGARRAY('RATE_CHART'),

2292: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
2293: RETURN;
2294: END IF;
2295: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_RATE_CHART_UNKNOWN',
2296: p_tokens => STRINGARRAY('RATE_CHART'),
2297: p_values => STRINGARRAY(l_rate_chart_name));
2298: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2299: p_msg => x_error_msg,
2300: p_category => 'C',

Line 2297: p_values => STRINGARRAY(l_rate_chart_name));

2293: RETURN;
2294: END IF;
2295: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_RATE_CHART_UNKNOWN',
2296: p_tokens => STRINGARRAY('RATE_CHART'),
2297: p_values => STRINGARRAY(l_rate_chart_name));
2298: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2299: p_msg => x_error_msg,
2300: p_category => 'C',
2301: p_line_number => p_line_number);

Line 2326: p_tokens => STRINGARRAY('NAME'),

2322: RETURN;
2323: END IF;
2324: x_status := 2;
2325: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_LANE_RATE_CHART_EXIST',
2326: p_tokens => STRINGARRAY('NAME'),
2327: p_values => STRINGARRAY(l_rate_chart_name));
2328: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2329: p_msg => x_error_msg,
2330: p_category => 'D',

Line 2327: p_values => STRINGARRAY(l_rate_chart_name));

2323: END IF;
2324: x_status := 2;
2325: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_LANE_RATE_CHART_EXIST',
2326: p_tokens => STRINGARRAY('NAME'),
2327: p_values => STRINGARRAY(l_rate_chart_name));
2328: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2329: p_msg => x_error_msg,
2330: p_category => 'D',
2331: p_line_number => p_line_number);

Line 2341: p_tokens => STRINGARRAY('RATE_CHART1', 'RATE_CHART2'),

2337: p_lane_id => p_lane_tbl(p_lane_tbl.COUNT).lane_id,
2338: x_status => x_status,
2339: x_error_msg => x_error_msg)) THEN
2340: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DATE_OVERLAP',
2341: p_tokens => STRINGARRAY('RATE_CHART1', 'RATE_CHART2'),
2342: p_values => STRINGARRAY(l_rate_chart_name, NULL));
2343: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2344: p_msg => x_error_msg,
2345: p_category => 'D',

Line 2342: p_values => STRINGARRAY(l_rate_chart_name, NULL));

2338: x_status => x_status,
2339: x_error_msg => x_error_msg)) THEN
2340: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DATE_OVERLAP',
2341: p_tokens => STRINGARRAY('RATE_CHART1', 'RATE_CHART2'),
2342: p_values => STRINGARRAY(l_rate_chart_name, NULL));
2343: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2344: p_msg => x_error_msg,
2345: p_category => 'D',
2346: p_line_number => p_line_number);

Line 2374: p_tokens => STRINGARRAY('DATE'),

2370: END;
2371:
2372: IF (p_lane_rate_chart_tbl(l_count).start_date_active IS NULL) THEN
2373: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
2374: p_tokens => STRINGARRAY('DATE'),
2375: p_values => STRINGARRAY(l_rate_chart_info(2)));
2376: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2377: p_msg => x_error_msg,
2378: p_category => 'D',

Line 2375: p_values => STRINGARRAY(l_rate_chart_info(2)));

2371:
2372: IF (p_lane_rate_chart_tbl(l_count).start_date_active IS NULL) THEN
2373: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
2374: p_tokens => STRINGARRAY('DATE'),
2375: p_values => STRINGARRAY(l_rate_chart_info(2)));
2376: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2377: p_msg => x_error_msg,
2378: p_category => 'D',
2379: p_line_number => p_line_number);

Line 2407: p_tokens => STRINGARRAY('DATE'),

2403: END;
2404:
2405: IF (p_lane_rate_chart_tbl(l_count).end_date_active IS NULL) THEN
2406: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
2407: p_tokens => STRINGARRAY('DATE'),
2408: p_values => STRINGARRAY(l_rate_chart_info(3)));
2409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2410: p_msg => x_error_msg,
2411: p_category => 'D',

Line 2408: p_values => STRINGARRAY(l_rate_chart_info(3)));

2404:
2405: IF (p_lane_rate_chart_tbl(l_count).end_date_active IS NULL) THEN
2406: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
2407: p_tokens => STRINGARRAY('DATE'),
2408: p_values => STRINGARRAY(l_rate_chart_info(3)));
2409: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2410: p_msg => x_error_msg,
2411: p_category => 'D',
2412: p_line_number => p_line_number);

Line 2532: p_tokens => STRINGARRAY('COMMODITY'),

2528: l_catg_id := FTE_UTIL_PKG.GET_CATG_ID(l_com_class, l_com_type);
2529:
2530: IF (l_catg_id = -1) THEN
2531: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMMODITY_UNKNOWN',
2532: p_tokens => STRINGARRAY('COMMODITY'),
2533: p_values => STRINGARRAY(l_com_type));
2534: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2535: p_msg => x_error_msg,
2536: p_category => 'D',

Line 2533: p_values => STRINGARRAY(l_com_type));

2529:
2530: IF (l_catg_id = -1) THEN
2531: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMMODITY_UNKNOWN',
2532: p_tokens => STRINGARRAY('COMMODITY'),
2533: p_values => STRINGARRAY(l_com_type));
2534: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2535: p_msg => x_error_msg,
2536: p_category => 'D',
2537: p_line_number => p_line_number);

Line 2543: p_tokens => STRINGARRAY('COMMODITY'),

2539: x_status := 1;
2540: RETURN;
2541: ELSIF (l_catg_id = -2) THEN
2542: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMMODITY_AMBIG',
2543: p_tokens => STRINGARRAY('COMMODITY'),
2544: p_values => STRINGARRAY(l_com_type));
2545: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2546: p_msg => x_error_msg,
2547: p_category => 'D',

Line 2544: p_values => STRINGARRAY(l_com_type));

2540: RETURN;
2541: ELSIF (l_catg_id = -2) THEN
2542: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMMODITY_AMBIG',
2543: p_tokens => STRINGARRAY('COMMODITY'),
2544: p_values => STRINGARRAY(l_com_type));
2545: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2546: p_msg => x_error_msg,
2547: p_category => 'D',
2548: p_line_number => p_line_number);

Line 2554: p_tokens => STRINGARRAY('COMMODITY'),

2550: x_status := 1;
2551: RETURN;
2552: ELSIF (l_catg_id = -3) THEN
2553: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMM_MISMATCH',
2554: p_tokens => STRINGARRAY('COMMODITY'),
2555: p_values => STRINGARRAY(l_com_type));
2556: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2557: p_msg => x_error_msg,
2558: p_category => 'D',

Line 2555: p_values => STRINGARRAY(l_com_type));

2551: RETURN;
2552: ELSIF (l_catg_id = -3) THEN
2553: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMM_MISMATCH',
2554: p_tokens => STRINGARRAY('COMMODITY'),
2555: p_values => STRINGARRAY(l_com_type));
2556: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2557: p_msg => x_error_msg,
2558: p_category => 'D',
2559: p_line_number => p_line_number);

Line 2577: p_tokens => STRINGARRAY('NAME'),

2573: RETURN;
2574: END IF;
2575: x_status := 2;
2576: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_LANE_COMMODITY_EXIST',
2577: p_tokens => STRINGARRAY('NAME'),
2578: p_values => STRINGARRAY(l_com_type));
2579: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2580: p_msg => x_error_msg,
2581: p_category => 'D',

Line 2578: p_values => STRINGARRAY(l_com_type));

2574: END IF;
2575: x_status := 2;
2576: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_LANE_COMMODITY_EXIST',
2577: p_tokens => STRINGARRAY('NAME'),
2578: p_values => STRINGARRAY(l_com_type));
2579: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2580: p_msg => x_error_msg,
2581: p_category => 'D',
2582: p_line_number => p_line_number);

Line 2611: p_tokens => STRINGARRAY('BASIS'),

2607: p_lane_commodity_tbl(l_count).basis := l_basis_code;
2608: p_lane_commodity_tbl(l_count).basis_flag := true;
2609: ELSE
2610: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_COMM_BASIS_INVALID',
2611: p_tokens => STRINGARRAY('BASIS'),
2612: p_values => STRINGARRAY(l_basis));
2613: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2614: p_msg => x_error_msg,
2615: p_category => 'D',

Line 2612: p_values => STRINGARRAY(l_basis));

2608: p_lane_commodity_tbl(l_count).basis_flag := true;
2609: ELSE
2610: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_COMM_BASIS_INVALID',
2611: p_tokens => STRINGARRAY('BASIS'),
2612: p_values => STRINGARRAY(l_basis));
2613: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2614: p_msg => x_error_msg,
2615: p_category => 'D',
2616: p_line_number => p_line_number);

Line 2732: p_tokens => STRINGARRAY('SERVICE'),

2728: END IF;
2729:
2730: IF (l_service_code IS NULL) THEN
2731: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_SERVICE_UNKNOWN',
2732: p_tokens => STRINGARRAY('SERVICE'),
2733: p_values => STRINGARRAY(l_service_level));
2734: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2735: p_msg => x_error_msg,
2736: p_category => 'D',

Line 2733: p_values => STRINGARRAY(l_service_level));

2729:
2730: IF (l_service_code IS NULL) THEN
2731: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_SERVICE_UNKNOWN',
2732: p_tokens => STRINGARRAY('SERVICE'),
2733: p_values => STRINGARRAY(l_service_level));
2734: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2735: p_msg => x_error_msg,
2736: p_category => 'D',
2737: p_line_number => p_line_number);

Line 2760: p_tokens => STRINGARRAY('SERVICE_LEVEL', 'CARRIER_NAME'),

2756: x_error_msg => x_error_msg))) THEN
2757:
2758: l_carrier_name := FTE_UTIL_PKG.GET_CARRIER_NAME(p_lane_tbl(p_lane_tbl.COUNT).carrier_id);
2759: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_SERVICE_INVALID',
2760: p_tokens => STRINGARRAY('SERVICE_LEVEL', 'CARRIER_NAME'),
2761: p_values => STRINGARRAY(l_service_level, l_carrier_name));
2762: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2763: p_msg => x_error_msg,
2764: p_category => 'B',

Line 2761: p_values => STRINGARRAY(l_service_level, l_carrier_name));

2757:
2758: l_carrier_name := FTE_UTIL_PKG.GET_CARRIER_NAME(p_lane_tbl(p_lane_tbl.COUNT).carrier_id);
2759: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_SERVICE_INVALID',
2760: p_tokens => STRINGARRAY('SERVICE_LEVEL', 'CARRIER_NAME'),
2761: p_values => STRINGARRAY(l_service_level, l_carrier_name));
2762: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2763: p_msg => x_error_msg,
2764: p_category => 'B',
2765: p_line_number => p_line_number);

Line 2786: p_tokens => STRINGARRAY('NAME'),

2782: RETURN;
2783: END IF;
2784: x_status := 2;
2785: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_LANE_SERVICE_EXIST',
2786: p_tokens => STRINGARRAY('NAME'),
2787: p_values => STRINGARRAY(l_service_level));
2788: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2789: p_msg => x_error_msg,
2790: p_category => 'D',

Line 2787: p_values => STRINGARRAY(l_service_level));

2783: END IF;
2784: x_status := 2;
2785: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_LANE_SERVICE_EXIST',
2786: p_tokens => STRINGARRAY('NAME'),
2787: p_values => STRINGARRAY(l_service_level));
2788: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2789: p_msg => x_error_msg,
2790: p_category => 'D',
2791: p_line_number => p_line_number);

Line 2921: P_Tokens => STRINGARRAY('TYPE'),

2917: END IF;
2918:
2919: IF (p_type NOT IN ('SERVICE', 'COMMODITY_TYPE', 'SERVICE_LEVEL', 'RATE_CHART')) THEN
2920: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_LANE_TYPE_UNKNOWN',
2921: P_Tokens => STRINGARRAY('TYPE'),
2922: P_values => STRINGARRAY(p_type));
2923: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2924: p_msg => x_error_msg,
2925: p_category => 'D',

Line 2922: P_values => STRINGARRAY(p_type));

2918:
2919: IF (p_type NOT IN ('SERVICE', 'COMMODITY_TYPE', 'SERVICE_LEVEL', 'RATE_CHART')) THEN
2920: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_LANE_TYPE_UNKNOWN',
2921: P_Tokens => STRINGARRAY('TYPE'),
2922: P_values => STRINGARRAY(p_type));
2923: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
2924: p_msg => x_error_msg,
2925: p_category => 'D',
2926: p_line_number => p_line_number);

Line 3040: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),

3036: p_lane_tbl(l_count).lane_id := l_old_lane_id;
3037: p_lane_tbl(l_count).lane_number := l_lane_number;
3038: IF (l_old_lane_id = -1) THEN
3039: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_NUMBER_INVALID',
3040: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3041: P_values => STRINGARRAY(l_lane_number));
3042:
3043: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3044: p_msg => x_error_msg,

Line 3041: P_values => STRINGARRAY(l_lane_number));

3037: p_lane_tbl(l_count).lane_number := l_lane_number;
3038: IF (l_old_lane_id = -1) THEN
3039: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_NUMBER_INVALID',
3040: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3041: P_values => STRINGARRAY(l_lane_number));
3042:
3043: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3044: p_msg => x_error_msg,
3045: p_category => 'C',

Line 3075: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),

3071: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
3072: p_lane_tbl(l_count).lane_id := l_old_lane_id;
3073: IF (l_old_lane_id = -1) THEN
3074: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_NUMBER_INVALID',
3075: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3076: P_values => STRINGARRAY(l_lane_number));
3077: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3078: p_msg => x_error_msg,
3079: p_category => 'C',

Line 3076: P_values => STRINGARRAY(l_lane_number));

3072: p_lane_tbl(l_count).lane_id := l_old_lane_id;
3073: IF (l_old_lane_id = -1) THEN
3074: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_NUMBER_INVALID',
3075: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3076: P_values => STRINGARRAY(l_lane_number));
3077: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3078: p_msg => x_error_msg,
3079: p_category => 'C',
3080: p_line_number => p_line_number);

Line 3091: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),

3087: ELSIF (p_action = 'ADD') THEN
3088:
3089: IF (-1 <> FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id)) THEN
3090: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_REF_EXISTS',
3091: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3092: P_values => STRINGARRAY(l_lane_number));
3093: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3094: p_msg => x_error_msg,
3095: p_category => 'D',

Line 3092: P_values => STRINGARRAY(l_lane_number));

3088:
3089: IF (-1 <> FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id)) THEN
3090: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_LANE_REF_EXISTS',
3091: P_Tokens => STRINGARRAY('SERVICE_NUMBER'),
3092: P_values => STRINGARRAY(l_lane_number));
3093: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3094: p_msg => x_error_msg,
3095: p_category => 'D',
3096: p_line_number => p_line_number);

Line 3143: p_tokens => STRINGARRAY('REGION_NAME'),

3139: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
3140:
3141: IF (l_region_id IS NULL OR l_region_id = -1) THEN
3142: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
3143: p_tokens => STRINGARRAY('REGION_NAME'),
3144: p_values => STRINGARRAY(l_region_info.country ||' '||
3145: l_region_info.state ||' '||
3146: l_region_info.city));
3147: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 3144: p_values => STRINGARRAY(l_region_info.country ||' '||

3140:
3141: IF (l_region_id IS NULL OR l_region_id = -1) THEN
3142: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
3143: p_tokens => STRINGARRAY('REGION_NAME'),
3144: p_values => STRINGARRAY(l_region_info.country ||' '||
3145: l_region_info.state ||' '||
3146: l_region_info.city));
3147: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3148: p_msg => x_error_msg,

Line 3206: p_tokens => STRINGARRAY('REGION_NAME'),

3202: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
3203:
3204: IF (l_region_id IS NULL OR l_region_id = -1) THEN
3205: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
3206: p_tokens => STRINGARRAY('REGION_NAME'),
3207: p_values => STRINGARRAY(l_region_info.country ||' '||
3208: l_region_info.state ||' '||
3209: l_region_info.city));
3210: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 3207: p_values => STRINGARRAY(l_region_info.country ||' '||

3203:
3204: IF (l_region_id IS NULL OR l_region_id = -1) THEN
3205: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_CAT_REGION_UNKNOWN',
3206: p_tokens => STRINGARRAY('REGION_NAME'),
3207: p_values => STRINGARRAY(l_region_info.country ||' '||
3208: l_region_info.state ||' '||
3209: l_region_info.city));
3210: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3211: p_msg => x_error_msg,

Line 3400: p_tokens => STRINGARRAY('BASIS'),

3396: p_lane_tbl(l_count).basis := l_basis_code;
3397: p_lane_tbl(l_count).basis_flag := true;
3398: ELSE
3399: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_BASIS_INVALID',
3400: p_tokens => STRINGARRAY('BASIS'),
3401: p_values => STRINGARRAY(l_basis));
3402: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3403: p_msg => x_error_msg,
3404: p_category => 'D',

Line 3401: p_values => STRINGARRAY(l_basis));

3397: p_lane_tbl(l_count).basis_flag := true;
3398: ELSE
3399: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_BASIS_INVALID',
3400: p_tokens => STRINGARRAY('BASIS'),
3401: p_values => STRINGARRAY(l_basis));
3402: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3403: p_msg => x_error_msg,
3404: p_category => 'D',
3405: p_line_number => p_line_number);

Line 3426: p_tokens => STRINGARRAY('COMMODITY_CLASS'),

3422: IF (l_com_class_code IS NOT NULL) THEN
3423: p_lane_tbl(l_count).comm_fc_class_code := l_com_class_code;
3424: ELSE
3425: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_COMM_CLASS_INVALID',
3426: p_tokens => STRINGARRAY('COMMODITY_CLASS'),
3427: p_values => STRINGARRAY(l_com_class));
3428: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3429: p_msg => x_error_msg,
3430: p_category => 'D',

Line 3427: p_values => STRINGARRAY(l_com_class));

3423: p_lane_tbl(l_count).comm_fc_class_code := l_com_class_code;
3424: ELSE
3425: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_COMM_CLASS_INVALID',
3426: p_tokens => STRINGARRAY('COMMODITY_CLASS'),
3427: p_values => STRINGARRAY(l_com_class));
3428: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3429: p_msg => x_error_msg,
3430: p_category => 'D',
3431: p_line_number => p_line_number);

Line 3476: p_tokens => STRINGARRAY('VIEW_FLAG'),

3472: ELSIF (l_view_flag = 'Y' OR l_view_flag = 'N') THEN
3473: p_lane_tbl(l_count).pricelist_view_flag := l_view_flag;
3474: ELSE
3475: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_PRICELIST_VIEW_INVALID',
3476: p_tokens => STRINGARRAY('VIEW_FLAG'),
3477: p_values => STRINGARRAY(l_view_flag));
3478: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3479: p_msg => x_error_msg,
3480: p_category => 'D',

Line 3477: p_values => STRINGARRAY(l_view_flag));

3473: p_lane_tbl(l_count).pricelist_view_flag := l_view_flag;
3474: ELSE
3475: x_error_msg := FTE_UTIL_PKG.GET_MSG(P_Name => 'FTE_PRICELIST_VIEW_INVALID',
3476: p_tokens => STRINGARRAY('VIEW_FLAG'),
3477: p_values => STRINGARRAY(l_view_flag));
3478: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3479: p_msg => x_error_msg,
3480: p_category => 'D',
3481: p_line_number => p_line_number);

Line 3593: l_data_keys STRINGARRAY := STRINGARRAY();

3589: l_currency VARCHAR2(100);
3590: l_carrier_id NUMBER := -1;
3591: l_uom_code VARCHAR2(100) := '';
3592: l_parameter_data_type VARCHAR2(100);
3593: l_data_keys STRINGARRAY := STRINGARRAY();
3594: l_data_values STRINGARRAY := STRINGARRAY();
3595: l_count NUMBER;
3596: l_lane_id NUMBER := -1;
3597: l_parameter_id NUMBER;

Line 3594: l_data_values STRINGARRAY := STRINGARRAY();

3590: l_carrier_id NUMBER := -1;
3591: l_uom_code VARCHAR2(100) := '';
3592: l_parameter_data_type VARCHAR2(100);
3593: l_data_keys STRINGARRAY := STRINGARRAY();
3594: l_data_values STRINGARRAY := STRINGARRAY();
3595: l_count NUMBER;
3596: l_lane_id NUMBER := -1;
3597: l_parameter_id NUMBER;
3598: l_prc_parameter_id NUMBER;

Line 3927: p_tokens => STRINGARRAY('VALUE'),

3923: ELSIF (l_name = 'GROUPING_LEVEL') THEN
3924: l_temp := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_PRC_GROUPING_LEVEL', l_value_from);
3925: IF (l_temp IS NULL) THEN
3926: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_GROUPING_LEVEL_INVALID',
3927: p_tokens => STRINGARRAY('VALUE'),
3928: p_values => STRINGARRAY(l_value_from));
3929: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3930: p_msg => x_error_msg,
3931: p_category => 'A',

Line 3928: p_values => STRINGARRAY(l_value_from));

3924: l_temp := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_PRC_GROUPING_LEVEL', l_value_from);
3925: IF (l_temp IS NULL) THEN
3926: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_GROUPING_LEVEL_INVALID',
3927: p_tokens => STRINGARRAY('VALUE'),
3928: p_values => STRINGARRAY(l_value_from));
3929: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3930: p_msg => x_error_msg,
3931: p_category => 'A',
3932: p_line_number => p_line_number);

Line 3941: p_tokens => STRINGARRAY('VALUE'),

3937: ELSIF (l_name = 'COMMODITY_AGGREGATION') THEN
3938: l_temp := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_PRC_COMM_AGGREGATION', l_value_from);
3939: IF (l_temp IS NULL) THEN
3940: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_COMM_AGGREGATION_INVALID',
3941: p_tokens => STRINGARRAY('VALUE'),
3942: p_values => STRINGARRAY(l_value_from));
3943: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3944: p_msg => x_error_msg,
3945: p_category => 'A',

Line 3942: p_values => STRINGARRAY(l_value_from));

3938: l_temp := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_PRC_COMM_AGGREGATION', l_value_from);
3939: IF (l_temp IS NULL) THEN
3940: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_COMM_AGGREGATION_INVALID',
3941: p_tokens => STRINGARRAY('VALUE'),
3942: p_values => STRINGARRAY(l_value_from));
3943: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3944: p_msg => x_error_msg,
3945: p_category => 'A',
3946: p_line_number => p_line_number);

Line 3955: p_tokens => STRINGARRAY('VALUE'),

3951: ELSIF (l_name = 'PRICING_OBJECTIVE') THEN
3952: l_temp := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_PRC_PRICING_OBJECTIVE', l_value_from);
3953: IF (l_temp IS NULL) THEN
3954: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICING_OBJECTIVE_INVALID',
3955: p_tokens => STRINGARRAY('VALUE'),
3956: p_values => STRINGARRAY(l_value_from));
3957: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3958: p_msg => x_error_msg,
3959: p_category => 'A',

Line 3956: p_values => STRINGARRAY(l_value_from));

3952: l_temp := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_PRC_PRICING_OBJECTIVE', l_value_from);
3953: IF (l_temp IS NULL) THEN
3954: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICING_OBJECTIVE_INVALID',
3955: p_tokens => STRINGARRAY('VALUE'),
3956: p_values => STRINGARRAY(l_value_from));
3957: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3958: p_msg => x_error_msg,
3959: p_category => 'A',
3960: p_line_number => p_line_number);

Line 3994: p_tokens => STRINGARRAY(''),

3990: -- If it's already defined,
3991: IF (l_prc_parameter_id <> -1) THEN
3992: IF (p_action = 'ADD' AND (NOT p_deficit_wt)) THEN
3993: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_ADD_ERROR',
3994: p_tokens => STRINGARRAY(''),
3995: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));
3996: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3997: p_msg => x_error_msg,
3998: p_category => 'D',

Line 3995: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));

3991: IF (l_prc_parameter_id <> -1) THEN
3992: IF (p_action = 'ADD' AND (NOT p_deficit_wt)) THEN
3993: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_ADD_ERROR',
3994: p_tokens => STRINGARRAY(''),
3995: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));
3996: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
3997: p_msg => x_error_msg,
3998: p_category => 'D',
3999: p_line_number => p_line_number);

Line 4008: p_tokens => STRINGARRAY(''),

4004: p_action := 'UPDATE';
4005: ELSE
4006: IF (p_action = 'UPDATE') THEN
4007: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UPDATE_ERROR',
4008: p_tokens => STRINGARRAY(''),
4009: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));
4010: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4011: p_msg => x_error_msg,
4012: p_category => 'D',

Line 4009: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));

4005: ELSE
4006: IF (p_action = 'UPDATE') THEN
4007: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UPDATE_ERROR',
4008: p_tokens => STRINGARRAY(''),
4009: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));
4010: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4011: p_msg => x_error_msg,
4012: p_category => 'D',
4013: p_line_number => p_line_number);

Line 4032: p_tokens => STRINGARRAY(''),

4028: p_prc_parameter_tbl(l_count).lane_id := l_lane_id;
4029: p_prc_parameter_tbl(l_count).parameter_id := l_parameter_id;
4030: ELSE
4031: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UPDATE_ERROR',
4032: p_tokens => STRINGARRAY(''),
4033: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));
4034: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4035: p_msg => x_error_msg,
4036: p_category => 'D',

Line 4033: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));

4029: p_prc_parameter_tbl(l_count).parameter_id := l_parameter_id;
4030: ELSE
4031: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UPDATE_ERROR',
4032: p_tokens => STRINGARRAY(''),
4033: p_values => STRINGARRAY(p_lane_function||':'||l_type||','||l_subtype||','||l_name));
4034: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4035: p_msg => x_error_msg,
4036: p_category => 'D',
4037: p_line_number => p_line_number);

Line 4301: p_tokens => STRINGARRAY(''),

4297: l_freq_type := FTE_UTIL_PKG.GET_LOOKUP_CODE('FTE_FREQUENCY_TYPE', l_old_freq_type);
4298:
4299: IF (l_freq_type IS NULL) THEN
4300: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UNDEFINED_FREQ_TYPE',
4301: p_tokens => STRINGARRAY(''),
4302: p_values => STRINGARRAY(l_old_freq_type));
4303: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4304: p_msg => x_error_msg,
4305: p_category => 'D',

Line 4302: p_values => STRINGARRAY(l_old_freq_type));

4298:
4299: IF (l_freq_type IS NULL) THEN
4300: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UNDEFINED_FREQ_TYPE',
4301: p_tokens => STRINGARRAY(''),
4302: p_values => STRINGARRAY(l_old_freq_type));
4303: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4304: p_msg => x_error_msg,
4305: p_category => 'D',
4306: p_line_number => p_line_number);

Line 4333: p_tokens => STRINGARRAY('frequency'),

4329: x_status => x_status,
4330: x_error_msg => x_error_msg);
4331: IF (l_freq_code IS NULL) THEN
4332: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INVALID_FREQUENCY',
4333: p_tokens => STRINGARRAY('frequency'),
4334: p_values => STRINGARRAY(l_frequency));
4335: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4336: p_msg => x_error_msg,
4337: p_category => 'D',

Line 4334: p_values => STRINGARRAY(l_frequency));

4330: x_error_msg => x_error_msg);
4331: IF (l_freq_code IS NULL) THEN
4332: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INVALID_FREQUENCY',
4333: p_tokens => STRINGARRAY('frequency'),
4334: p_values => STRINGARRAY(l_frequency));
4335: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4336: p_msg => x_error_msg,
4337: p_category => 'D',
4338: p_line_number => p_line_number);

Line 4466: p_tokens => STRINGARRAY('DATE'),

4462: END;
4463:
4464: IF (p_schedule_tbl(l_count).departure_date IS NULL) THEN
4465: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
4466: p_tokens => STRINGARRAY('DATE'),
4467: p_values => STRINGARRAY(l_departure));
4468: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4469: p_msg => x_error_msg,
4470: p_category => 'D',

Line 4467: p_values => STRINGARRAY(l_departure));

4463:
4464: IF (p_schedule_tbl(l_count).departure_date IS NULL) THEN
4465: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
4466: p_tokens => STRINGARRAY('DATE'),
4467: p_values => STRINGARRAY(l_departure));
4468: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4469: p_msg => x_error_msg,
4470: p_category => 'D',
4471: p_line_number => p_line_number);

Line 4503: p_tokens => STRINGARRAY('DATE'),

4499: END;
4500:
4501: IF (p_schedule_tbl(l_count).arrival_date IS NULL) THEN
4502: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
4503: p_tokens => STRINGARRAY('DATE'),
4504: p_values => STRINGARRAY(l_arrival));
4505: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4506: p_msg => x_error_msg,
4507: p_category => 'D',

Line 4504: p_values => STRINGARRAY(l_arrival));

4500:
4501: IF (p_schedule_tbl(l_count).arrival_date IS NULL) THEN
4502: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INCORRECT_DATE',
4503: p_tokens => STRINGARRAY('DATE'),
4504: p_values => STRINGARRAY(l_arrival));
4505: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4506: p_msg => x_error_msg,
4507: p_category => 'D',
4508: p_line_number => p_line_number);

Line 4587: p_tokens => STRINGARRAY('UOM'),

4583: IF (l_transit_uom_code IS NOT NULL) THEN
4584: p_schedule_tbl(l_count).transit_time_uom := l_transit_uom_code;
4585: ELSE
4586: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
4587: p_tokens => STRINGARRAY('UOM'),
4588: p_values => STRINGARRAY(l_transit_uom));
4589: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4590: p_msg => x_error_msg,
4591: p_category => 'B',

Line 4588: p_values => STRINGARRAY(l_transit_uom));

4584: p_schedule_tbl(l_count).transit_time_uom := l_transit_uom_code;
4585: ELSE
4586: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
4587: p_tokens => STRINGARRAY('UOM'),
4588: p_values => STRINGARRAY(l_transit_uom));
4589: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4590: p_msg => x_error_msg,
4591: p_category => 'B',
4592: p_line_number => p_line_number);

Line 4699: l_tokens STRINGARRAY:=STRINGARRAY();

4695: l_replaced_rc VARCHAR2(60);
4696: l_old_rc_id NUMBER;
4697:
4698: l_temp VARCHAR2(50);
4699: l_tokens STRINGARRAY:=STRINGARRAY();
4700: l_list_type_code VARCHAR2(10);
4701: l_count NUMBER;
4702: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
4703:

Line 4892: p_tokens => StringArray('NAME'),

4888: -- Validate Price List and Check if the Pricelist is assigned to any Lane for DELETE
4889: -- If the pricelist already exists, set status to 999 and return immediately.
4890: IF (p_action = 'ADD' AND l_list_header_id <> -1) THEN
4891: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_PRICELIST_EXIST',
4892: p_tokens => StringArray('NAME'),
4893: p_values => StringArray(l_name));
4894:
4895: IF (l_chart_type <> 'LTL_RATE_CHART') THEN
4896: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 4893: p_values => StringArray(l_name));

4889: -- If the pricelist already exists, set status to 999 and return immediately.
4890: IF (p_action = 'ADD' AND l_list_header_id <> -1) THEN
4891: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_PRICELIST_EXIST',
4892: p_tokens => StringArray('NAME'),
4893: p_values => StringArray(l_name));
4894:
4895: IF (l_chart_type <> 'LTL_RATE_CHART') THEN
4896: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4897: p_msg => x_error_msg,

Line 4954: p_tokens => StringArray('NAME', 'TYPE', 'ACTUAL'),

4950: l_tokens(l_tokens.COUNT) := 'Unknown Type Chart';
4951: END IF;
4952:
4953: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_DELETE_TYPE_WRONG',
4954: p_tokens => StringArray('NAME', 'TYPE', 'ACTUAL'),
4955: p_values => l_tokens);
4956:
4957: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4958: p_msg => x_error_msg,

Line 4967: p_tokens => StringArray('NAME'),

4963: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4964: RETURN;
4965: ELSIF (p_action IN ('DELETE', 'UPDATE', 'APPEND') AND l_list_header_id = -1) THEN
4966: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_PRICELIST_INVALID',
4967: p_tokens => StringArray('NAME'),
4968: p_values => StringArray(l_name));
4969:
4970: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4971: p_msg => x_error_msg,

Line 4968: p_values => StringArray(l_name));

4964: RETURN;
4965: ELSIF (p_action IN ('DELETE', 'UPDATE', 'APPEND') AND l_list_header_id = -1) THEN
4966: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_PRICELIST_INVALID',
4967: p_tokens => StringArray('NAME'),
4968: p_values => StringArray(l_name));
4969:
4970: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
4971: p_msg => x_error_msg,
4972: p_category => 'C',

Line 5037: p_tokens => StringArray('RATE_CHART'),

5033:
5034: EXCEPTION
5035: WHEN NO_DATA_FOUND THEN
5036: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_REPLACE_RC_NOT_FOUND',
5037: p_tokens => StringArray('RATE_CHART'),
5038: p_values => STRINGARRAY(l_replaced_rc));
5039: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5040: p_msg => x_error_msg,
5041: p_category => 'D',

Line 5038: p_values => STRINGARRAY(l_replaced_rc));

5034: EXCEPTION
5035: WHEN NO_DATA_FOUND THEN
5036: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_REPLACE_RC_NOT_FOUND',
5037: p_tokens => StringArray('RATE_CHART'),
5038: p_values => STRINGARRAY(l_replaced_rc));
5039: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5040: p_msg => x_error_msg,
5041: p_category => 'D',
5042: p_line_number => p_line_number);

Line 5384: p_tokens => STRINGARRAY('NUMBER'),

5380: x_status := 2;
5381: RETURN;
5382: ELSIF (isNum(l_linenum) = 0) THEN
5383: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_NUMBER_INVALID', -- need change
5384: p_tokens => STRINGARRAY('NUMBER'),
5385: p_values => STRINGARRAY(l_linenum));
5386: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5387: p_msg => x_error_msg,
5388: p_category => 'D',

Line 5385: p_values => STRINGARRAY(l_linenum));

5381: RETURN;
5382: ELSIF (isNum(l_linenum) = 0) THEN
5383: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_CAT_NUMBER_INVALID', -- need change
5384: p_tokens => STRINGARRAY('NUMBER'),
5385: p_values => STRINGARRAY(l_linenum));
5386: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5387: p_msg => x_error_msg,
5388: p_category => 'D',
5389: p_line_number => p_line_number);

Line 5436: p_tokens => STRINGARRAY('BREAK_TYPE'),

5432: IF (LENGTH(l_break_type) > 0) THEN
5433: l_break_type := UPPER(l_break_type);
5434: IF (NOT( l_break_type = 'POINT' OR l_break_type = 'RANGE' )) THEN
5435: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_BREAK_TYPE_INVALID',
5436: p_tokens => STRINGARRAY('BREAK_TYPE'),
5437: p_values => STRINGARRAY(l_break_type));
5438: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5439: p_msg => x_error_msg,
5440: p_category => 'D',

Line 5437: p_values => STRINGARRAY(l_break_type));

5433: l_break_type := UPPER(l_break_type);
5434: IF (NOT( l_break_type = 'POINT' OR l_break_type = 'RANGE' )) THEN
5435: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_BREAK_TYPE_INVALID',
5436: p_tokens => STRINGARRAY('BREAK_TYPE'),
5437: p_values => STRINGARRAY(l_break_type));
5438: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5439: p_msg => x_error_msg,
5440: p_category => 'D',
5441: p_line_number => p_line_number);

Line 5477: p_tokens => STRINGARRAY('VOLUME_TYPE'),

5473: IF (LENGTH(l_volume_type) > 0) THEN
5474: l_volume_type := UPPER(l_volume_type);
5475: IF (NOT (l_volume_type = 'QUANTITY' OR l_volume_type = 'TOTAL_QUANTITY') ) THEN
5476: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_VOLUME_TYPE_INVALID',
5477: p_tokens => STRINGARRAY('VOLUME_TYPE'),
5478: p_values => STRINGARRAY(l_volume_type));
5479:
5480: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5481: p_msg => x_error_msg,

Line 5478: p_values => STRINGARRAY(l_volume_type));

5474: l_volume_type := UPPER(l_volume_type);
5475: IF (NOT (l_volume_type = 'QUANTITY' OR l_volume_type = 'TOTAL_QUANTITY') ) THEN
5476: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_VOLUME_TYPE_INVALID',
5477: p_tokens => STRINGARRAY('VOLUME_TYPE'),
5478: p_values => STRINGARRAY(l_volume_type));
5479:
5480: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5481: p_msg => x_error_msg,
5482: p_category => 'D',

Line 5545: p_tokens => STRINGARRAY('SUBTYPE'),

5541:
5542: IF (l_subtype IS NULL) THEN
5543: l_subtype := FTE_UTIL_PKG.GET_DATA('SUBTYPE', p_values);
5544: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_SUBTYPE_INVALID',
5545: p_tokens => STRINGARRAY('SUBTYPE'),
5546: p_values => STRINGARRAY(l_subtype));
5547:
5548: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5549: p_msg => x_error_msg,

Line 5546: p_values => STRINGARRAY(l_subtype));

5542: IF (l_subtype IS NULL) THEN
5543: l_subtype := FTE_UTIL_PKG.GET_DATA('SUBTYPE', p_values);
5544: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_SUBTYPE_INVALID',
5545: p_tokens => STRINGARRAY('SUBTYPE'),
5546: p_values => STRINGARRAY(l_subtype));
5547:
5548: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5549: p_msg => x_error_msg,
5550: p_category => 'D',

Line 5561: p_tokens => STRINGARRAY('TYPE'),

5557: ELSIF (l_type = 'DISCOUNT') THEN
5558: l_list_type_code := 'DIS';
5559: ELSE
5560: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_MOD_TYPE_INVALID',
5561: p_tokens => STRINGARRAY('TYPE'),
5562: p_values => STRINGARRAY(l_type));
5563:
5564: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5565: p_msg => x_error_msg,

Line 5562: p_values => STRINGARRAY(l_type));

5558: l_list_type_code := 'DIS';
5559: ELSE
5560: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_MOD_TYPE_INVALID',
5561: p_tokens => STRINGARRAY('TYPE'),
5562: p_values => STRINGARRAY(l_type));
5563:
5564: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5565: p_msg => x_error_msg,
5566: p_category => 'D',

Line 5790: l_tokens STRINGARRAY;

5786: l_mod_level_code VARCHAR2(30);
5787: l_formula_id NUMBER;
5788:
5789: -- Variables used for error messages
5790: l_tokens STRINGARRAY;
5791: l_values STRINGARRAY;
5792: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
5793:
5794: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_RATE_BREAK';

Line 5791: l_values STRINGARRAY;

5787: l_formula_id NUMBER;
5788:
5789: -- Variables used for error messages
5790: l_tokens STRINGARRAY;
5791: l_values STRINGARRAY;
5792: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
5793:
5794: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_RATE_BREAK';
5795:

Line 5874: p_tokens => STRINGARRAY('RATE_TYPE'),

5870:
5871: -- if both line rate type and break line rate type are null, then error
5872: IF (l_rate_type IS NULL) THEN
5873: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_RATE_TYPE_INVALID',
5874: p_tokens => STRINGARRAY('RATE_TYPE'),
5875: p_values => STRINGARRAY(l_rate_type));
5876: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5877: p_msg => x_error_msg,
5878: p_category => 'D',

Line 5875: p_values => STRINGARRAY(l_rate_type));

5871: -- if both line rate type and break line rate type are null, then error
5872: IF (l_rate_type IS NULL) THEN
5873: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_RATE_TYPE_INVALID',
5874: p_tokens => STRINGARRAY('RATE_TYPE'),
5875: p_values => STRINGARRAY(l_rate_type));
5876: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5877: p_msg => x_error_msg,
5878: p_category => 'D',
5879: p_line_number => p_line_number);

Line 6291: p_tokens => STRINGARRAY('REGION_NAME'),

6287: x_status => x_status,
6288: x_error_msg => x_error_msg);
6289: ELSE
6290: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
6291: p_tokens => STRINGARRAY('REGION_NAME'),
6292: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||
6293: FTE_RATE_CHART_PKG.g_region_info.state ||' '||
6294: FTE_RATE_CHART_PKG.g_region_info.city));
6295: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 6292: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||

6288: x_error_msg => x_error_msg);
6289: ELSE
6290: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
6291: p_tokens => STRINGARRAY('REGION_NAME'),
6292: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||
6293: FTE_RATE_CHART_PKG.g_region_info.state ||' '||
6294: FTE_RATE_CHART_PKG.g_region_info.city));
6295: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6296: p_msg => x_error_msg,

Line 6343: p_tokens => STRINGARRAY('REGION_NAME'),

6339: x_status => x_status,
6340: x_error_msg => x_error_msg);
6341: ELSE
6342: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
6343: p_tokens => STRINGARRAY('REGION_NAME'),
6344: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||
6345: FTE_RATE_CHART_PKG.g_region_info.state ||' '||
6346: FTE_RATE_CHART_PKG.g_region_info.city));
6347: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 6344: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||

6340: x_error_msg => x_error_msg);
6341: ELSE
6342: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
6343: p_tokens => STRINGARRAY('REGION_NAME'),
6344: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||
6345: FTE_RATE_CHART_PKG.g_region_info.state ||' '||
6346: FTE_RATE_CHART_PKG.g_region_info.city));
6347: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6348: p_msg => x_error_msg,

Line 6385: p_tokens => STRINGARRAY('ZONE'),

6381: IF (l_zone_id <> -1 OR l_zone_id IS NOT NULL) THEN
6382: l_pricing_attr_value_from := l_zone_id;
6383: ELSE
6384: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_ZONE_UNKNOWN',
6385: p_tokens => STRINGARRAY('ZONE'),
6386: p_values => STRINGARRAY(l_pricing_attr_value_from));
6387: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6388: p_msg => x_error_msg,
6389: p_category => 'D',

Line 6386: p_values => STRINGARRAY(l_pricing_attr_value_from));

6382: l_pricing_attr_value_from := l_zone_id;
6383: ELSE
6384: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_ZONE_UNKNOWN',
6385: p_tokens => STRINGARRAY('ZONE'),
6386: p_values => STRINGARRAY(l_pricing_attr_value_from));
6387: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6388: p_msg => x_error_msg,
6389: p_category => 'D',
6390: p_line_number => p_line_number);

Line 6429: p_tokens => STRINGARRAY('CONTAINER'),

6425: IF (l_attr_code IS NOT NULL) THEN
6426: l_pricing_attr_value_from := l_attr_code;
6427: ELSE
6428: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_CONTAINER_UNKNOWN',
6429: p_tokens => STRINGARRAY('CONTAINER'),
6430: p_values => STRINGARRAY(l_pricing_attr_value_from));
6431: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6432: p_msg => x_error_msg,
6433: p_category => 'D',

Line 6430: p_values => STRINGARRAY(l_pricing_attr_value_from));

6426: l_pricing_attr_value_from := l_attr_code;
6427: ELSE
6428: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_CONTAINER_UNKNOWN',
6429: p_tokens => STRINGARRAY('CONTAINER'),
6430: p_values => STRINGARRAY(l_pricing_attr_value_from));
6431: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6432: p_msg => x_error_msg,
6433: p_category => 'D',
6434: p_line_number => p_line_number);

Line 6450: p_tokens => STRINGARRAY('COMM'),

6446:
6447: IF (l_pricing_attr_value_from IS NULL) THEN
6448: l_pricing_attr_value_from := FTE_UTIL_PKG.GET_DATA('ATTRIBUTE_VALUE', p_values);
6449: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMMODITY_UNKNOWN',
6450: p_tokens => STRINGARRAY('COMM'),
6451: p_values => STRINGARRAY(l_pricing_attr_value_from));
6452: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6453: p_msg => x_error_msg,
6454: p_category => 'D',

Line 6451: p_values => STRINGARRAY(l_pricing_attr_value_from));

6447: IF (l_pricing_attr_value_from IS NULL) THEN
6448: l_pricing_attr_value_from := FTE_UTIL_PKG.GET_DATA('ATTRIBUTE_VALUE', p_values);
6449: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_COMMODITY_UNKNOWN',
6450: p_tokens => STRINGARRAY('COMM'),
6451: p_values => STRINGARRAY(l_pricing_attr_value_from));
6452: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6453: p_msg => x_error_msg,
6454: p_category => 'D',
6455: p_line_number => p_line_number);

Line 6470: p_tokens => STRINGARRAY('NAME'),

6466:
6467: l_pricing_attr_value_from := FTE_UTIL_PKG.GET_DATA('ATTRIBUTE_VALUE', p_values);
6468:
6469: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_VEHICLE_NAME_INVALID',
6470: p_tokens => STRINGARRAY('NAME'),
6471: p_values => STRINGARRAY(l_pricing_attr_value_from));
6472: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6473: p_msg => x_error_msg,
6474: p_category => 'D',

Line 6471: p_values => STRINGARRAY(l_pricing_attr_value_from));

6467: l_pricing_attr_value_from := FTE_UTIL_PKG.GET_DATA('ATTRIBUTE_VALUE', p_values);
6468:
6469: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_VEHICLE_NAME_INVALID',
6470: p_tokens => STRINGARRAY('NAME'),
6471: p_values => STRINGARRAY(l_pricing_attr_value_from));
6472: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6473: p_msg => x_error_msg,
6474: p_category => 'D',
6475: p_line_number => p_line_number);

Line 6501: p_tokens => STRINGARRAY('REGION_NAME'),

6497: x_status => x_status,
6498: x_error_msg => x_error_msg);
6499: ELSE
6500: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
6501: p_tokens => STRINGARRAY('REGION_NAME'),
6502: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||
6503: FTE_RATE_CHART_PKG.g_region_info.state ||' '||
6504: FTE_RATE_CHART_PKG.g_region_info.city));
6505: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 6502: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||

6498: x_error_msg => x_error_msg);
6499: ELSE
6500: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
6501: p_tokens => STRINGARRAY('REGION_NAME'),
6502: p_values => STRINGARRAY(FTE_RATE_CHART_PKG.g_region_info.country ||' '||
6503: FTE_RATE_CHART_PKG.g_region_info.state ||' '||
6504: FTE_RATE_CHART_PKG.g_region_info.city));
6505: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6506: p_msg => x_error_msg,

Line 6520: p_tokens => STRINGARRAY('VALUE'),

6516:
6517: -- Insert Current Attribute
6518: IF (l_linenum <> FTE_RATE_CHART_PKG.g_line_number) THEN
6519: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRC_ATTR_WRONG_LINE',
6520: p_tokens => STRINGARRAY('VALUE'),
6521: p_values => STRINGARRAY(l_pricing_attr_value_from));
6522: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6523: p_msg => x_error_msg,
6524: p_category => 'D',

Line 6521: p_values => STRINGARRAY(l_pricing_attr_value_from));

6517: -- Insert Current Attribute
6518: IF (l_linenum <> FTE_RATE_CHART_PKG.g_line_number) THEN
6519: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRC_ATTR_WRONG_LINE',
6520: p_tokens => STRINGARRAY('VALUE'),
6521: p_values => STRINGARRAY(l_pricing_attr_value_from));
6522: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6523: p_msg => x_error_msg,
6524: p_category => 'D',
6525: p_line_number => p_line_number);

Line 6675: p_tokens => STRINGARRAY('NAME'),

6671: p_attribute1 => l_temp);
6672:
6673: IF (l_list_header_id = -1) THEN
6674: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
6675: p_tokens => STRINGARRAY('NAME'),
6676: p_values => STRINGARRAY(l_name));
6677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6678: p_msg => x_error_msg,
6679: p_category => 'C',

Line 6676: p_values => STRINGARRAY(l_name));

6672:
6673: IF (l_list_header_id = -1) THEN
6674: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_PRICELIST_INVALID',
6675: p_tokens => STRINGARRAY('NAME'),
6676: p_values => STRINGARRAY(l_name));
6677: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6678: p_msg => x_error_msg,
6679: p_category => 'C',
6680: p_line_number => p_line_number);

Line 6698: p_tokens => STRINGARRAY('TARIFF', 'CARRIER'),

6694: l_list_header_ids := FTE_LTL_LOADER.Get_Tariff_Ratecharts(p_tariff_name => l_tariff,
6695: x_error_msg => x_error_msg);
6696: ELSE
6697: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_TARIFF_NOT_ASSOC',
6698: p_tokens => STRINGARRAY('TARIFF', 'CARRIER'),
6699: p_values => STRINGARRAY(l_tariff, FTE_UTIL_PKG.GET_CARRIER_NAME(l_carrier_id)));
6700: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6701: p_msg => x_error_msg,
6702: p_category => 'A',

Line 6699: p_values => STRINGARRAY(l_tariff, FTE_UTIL_PKG.GET_CARRIER_NAME(l_carrier_id)));

6695: x_error_msg => x_error_msg);
6696: ELSE
6697: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_TARIFF_NOT_ASSOC',
6698: p_tokens => STRINGARRAY('TARIFF', 'CARRIER'),
6699: p_values => STRINGARRAY(l_tariff, FTE_UTIL_PKG.GET_CARRIER_NAME(l_carrier_id)));
6700: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
6701: p_msg => x_error_msg,
6702: p_category => 'A',
6703: p_line_number => p_line_number);

Line 7116: p_tokens => STRINGARRAY('REGION_NAME'),

7112: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
7113:
7114: IF (l_region_id IS NULL OR l_region_id = -1) THEN
7115: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7116: p_tokens => STRINGARRAY('REGION_NAME'),
7117: p_values => STRINGARRAY(l_region_info.country ||' '||
7118: l_region_info.state ||' '||
7119: l_region_info.city));
7120: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 7117: p_values => STRINGARRAY(l_region_info.country ||' '||

7113:
7114: IF (l_region_id IS NULL OR l_region_id = -1) THEN
7115: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7116: p_tokens => STRINGARRAY('REGION_NAME'),
7117: p_values => STRINGARRAY(l_region_info.country ||' '||
7118: l_region_info.state ||' '||
7119: l_region_info.city));
7120: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
7121: p_msg => x_error_msg,

Line 7187: p_tokens => STRINGARRAY('REGION_NAME'),

7183: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => l_region_info);
7184:
7185: IF (l_region_id IS NULL OR l_region_id = -1) THEN
7186: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7187: p_tokens => STRINGARRAY('REGION_NAME'),
7188: p_values => STRINGARRAY(l_region_info.country ||' '||
7189: l_region_info.state ||' '||
7190: l_region_info.city));
7191: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 7188: p_values => STRINGARRAY(l_region_info.country ||' '||

7184:
7185: IF (l_region_id IS NULL OR l_region_id = -1) THEN
7186: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7187: p_tokens => STRINGARRAY('REGION_NAME'),
7188: p_values => STRINGARRAY(l_region_info.country ||' '||
7189: l_region_info.state ||' '||
7190: l_region_info.city));
7191: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
7192: p_msg => x_error_msg,

Line 7372: -- 1. p_columns: STRINGARRAY of the column names

7368: --
7369: -- Purpose: does validation for one line in zone block
7370: --
7371: -- IN parameters:
7372: -- 1. p_columns: STRINGARRAY of the column names
7373: -- 2. p_values: STRINGARRAY of the line values
7374: -- 3. p_line_number: line number of current line
7375: -- 4. p_region_type: region type for the zone (10, 11 etc)
7376: --

Line 7373: -- 2. p_values: STRINGARRAY of the line values

7369: -- Purpose: does validation for one line in zone block
7370: --
7371: -- IN parameters:
7372: -- 1. p_columns: STRINGARRAY of the column names
7373: -- 2. p_values: STRINGARRAY of the line values
7374: -- 3. p_line_number: line number of current line
7375: -- 4. p_region_type: region type for the zone (10, 11 etc)
7376: --
7377: -- OUT parameters:

Line 7465: p_tokens => STRINGARRAY('REGION_NAME'),

7461: --+
7462: IF (p_region_id IS NULL OR p_region_id = -1) THEN
7463: x_status := 2;
7464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7465: p_tokens => STRINGARRAY('REGION_NAME'),
7466: p_values => STRINGARRAY(p_region_rec.country ||' '||
7467: p_region_rec.state ||' '||
7468: p_region_rec.city));
7469: FTE_UTIL_PKG.Write_OutFile(p_module_name => l_module_name,

Line 7466: p_values => STRINGARRAY(p_region_rec.country ||' '||

7462: IF (p_region_id IS NULL OR p_region_id = -1) THEN
7463: x_status := 2;
7464: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_REGION_UNKNOWN',
7465: p_tokens => STRINGARRAY('REGION_NAME'),
7466: p_values => STRINGARRAY(p_region_rec.country ||' '||
7467: p_region_rec.state ||' '||
7468: p_region_rec.city));
7469: FTE_UTIL_PKG.Write_OutFile(p_module_name => l_module_name,
7470: p_msg => x_error_msg,