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 FTE_BULKLOAD_PKG

Line 77: p_date := TO_DATE(p_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT);

73: x_status := -1;
74:
75: IF (p_date IS NOT NULL) THEN
76: BEGIN
77: p_date := TO_DATE(p_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT);
78: EXCEPTION
79: WHEN OTHERS THEN
80: BEGIN
81: p_date := TO_DATE(p_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT3);

Line 81: p_date := TO_DATE(p_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT3);

77: p_date := TO_DATE(p_date, FTE_BULKLOAD_PKG.G_DATE_FORMAT);
78: EXCEPTION
79: WHEN OTHERS THEN
80: BEGIN
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'),

Line 162: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

158:
159: BEGIN
160: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
161:
162: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
163: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute', p_pricing_attribute);
164: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value from', p_attr_value_from);
165: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Value to', p_attr_value_to);
166: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line Number', p_line_number);

Line 277: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

273: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_CURRENCY';
274: BEGIN
275: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
276:
277: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
278: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Currency', p_currency);
279: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
280: END IF;
281: x_status := -1;

Line 390: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

386: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.GET_FREQ_CODE';
387: BEGIN
388: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
389:
390: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
391: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Frequency', p_frequency);
392: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
393: END IF;
394: x_status := -1;

Line 466: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

462: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.CALCULATE_FREQ_ARRIVAL';
463: BEGIN
464: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
465:
466: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
467: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Frequency', p_frequency);
468: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Indicator', p_ind);
469: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
470: END IF;

Line 527: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

523:
524: BEGIN
525: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
526:
527: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
528: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate type', p_rate_type);
529: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
530: END IF;
531: x_status := -1;

Line 598: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

594:
595: BEGIN
596: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
597:
598: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
599: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Subtype', p_subtype);
600: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
601: END IF;
602: x_status := -1;

Line 663: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

659:
660: BEGIN
661: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
662:
663: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
664: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
665: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier Name', p_carrier_name);
666: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Service Level', p_service_level);
667: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);

Line 711: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

707: FTE_UTIL_PKG.Exit_Debug(l_module_name);
708: RETURN l_service_code;
709: END IF;
710:
711: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
712: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Service Code', l_service_code);
713: END IF;
714:
715: --Verify that the carrier has the correct service level

Line 810: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

806:
807: BEGIN
808: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
809:
810: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
811: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
812: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane Function', p_lane_function);
813: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Subtype', p_subtype);
814: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Name', p_name);

Line 884: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

880: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_LANE_BASIS';
881: BEGIN
882: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
883:
884: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
885: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
886: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
887: END IF;
888: x_status := -1;

Line 963: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

959: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_CARRIER_SERVICE';
960: BEGIN
961: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
962:
963: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
964: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID', p_lane_id);
965: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
966: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Service code', p_service_code);
967: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Mode', p_mode);

Line 984: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

980: l_numfetch := SQL%ROWCOUNT;
981: CLOSE GET_CARRIER_SERVICE2;
982: END IF;
983:
984: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
985: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Result', l_result);
986: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Num Fetch', l_numfetch);
987: END IF;
988:

Line 1047: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1043: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.IS_VALID_PRICELIST';
1044: BEGIN
1045: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1046:
1047: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1048: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Service count', p_service_count);
1049: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Price prefix', p_price_prefix);
1050: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
1051: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);

Line 1162: PROCEDURE VALIDATE_COLUMNS (p_keys IN FTE_BULKLOAD_PKG.block_header_tbl,

1158: -- OUT parameters:
1159: -- 1. x_status: status, -1 if no error(1 wrong number, 2 wrong column, 3 no such type)
1160: -- 2. x_error_msg: error message if status <> -1
1161: ----------------------------------------------------------------------------
1162: PROCEDURE VALIDATE_COLUMNS (p_keys IN FTE_BULKLOAD_PKG.block_header_tbl,
1163: p_type IN VARCHAR2,
1164: p_line_number IN NUMBER,
1165: x_status OUT NOCOPY NUMBER,
1166: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 1174: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1170: l_found BOOLEAN := false;
1171: BEGIN
1172: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1173:
1174: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1175: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
1176: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
1177: END IF;
1178: x_status := -1;

Line 1206: FTE_BULKLOAD_PKG.g_block_header_index(p_keys(l_column(i))) := null;

1202: p_category => 'D',
1203: p_line_number => p_line_number);
1204:
1205: ELSE
1206: FTE_BULKLOAD_PKG.g_block_header_index(p_keys(l_column(i))) := null;
1207: END IF;
1208: END LOOP;
1209:
1210: IF (x_status <> -1) THEN

Line 1215: FOR i IN 1..FTE_BULKLOAD_PKG.g_block_header_index.COUNT LOOP

1211: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1212: RETURN;
1213: END IF;
1214:
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'),

Line 1216: IF (FTE_BULKLOAD_PKG.g_block_header_index(i) IS NOT NULL) THEN

1212: RETURN;
1213: END IF;
1214:
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));

Line 1265: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1261: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_CARRIER';
1262: BEGIN
1263: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1264:
1265: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1266: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier Name', p_carrier_name);
1267: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
1268: END IF;
1269: x_status := -1;

Line 1275: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1271: p_carrier_id := -1;
1272: IF (p_carrier_name IS NOT NULL) THEN
1273: p_carrier_id := FTE_UTIL_PKG.GET_CARRIER_ID(p_carrier_name);
1274:
1275: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
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',

Line 1340: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1336: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_LANE_NUMBER';
1337: BEGIN
1338: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1339:
1340: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1341: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane Number', p_lane_number);
1342: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
1343: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
1344: END IF;

Line 1409: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1405: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_ACTION';
1406: BEGIN
1407: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1408:
1409: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1410: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
1411: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
1412: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
1413: END IF;

Line 1602: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1598: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_UOM';
1599: BEGIN
1600: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1601:
1602: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1603: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'UOM', p_uom);
1604: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Class', p_class);
1605: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
1606: END IF;

Line 1716: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1712: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_MODE_OF_TRANS';
1713: BEGIN
1714: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
1715:
1716: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1717: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Mode', p_mode);
1718: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier ID', p_carrier_id);
1719: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
1720: END IF;

Line 1797: PROCEDURE VALIDATE_RATING_ZONE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

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: ----------------------------------------------------------------------------
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

Line 1827: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1823: l_view_flag := FTE_UTIL_PKG.GET_DATA('RATE_CHART_VIEW_FLAG', p_values);
1824: l_start_date := FTE_UTIL_PKG.GET_DATA('START_DATE', p_values);
1825: l_end_date := FTE_UTIL_PKG.GET_DATA('END_DATE', p_values);
1826:
1827: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1828: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Name prefix', l_name_prefix );
1829: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Mode of transportation', l_mode_of_trans);
1830: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier name', l_carrier_name );
1831: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate chart prefix', l_price_prefix );

Line 1936: PROCEDURE VALIDATE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

1932: -- 2. p_last_service_type: last line's service type
1933: -- 3. x_status: status of the processing, -1 means no error
1934: -- 4. x_error_msg: error message if any.
1935: ----------------------------------------------------------------------------
1936: PROCEDURE VALIDATE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
1937: p_line_number IN NUMBER,
1938: p_setup_info IN OUT NOCOPY FTE_BULKLOAD_PKG.array_tbl,
1939: p_last_service_type IN OUT NOCOPY VARCHAR2,
1940: x_status OUT NOCOPY NUMBER,

Line 1938: p_setup_info IN OUT NOCOPY FTE_BULKLOAD_PKG.array_tbl,

1934: -- 4. x_error_msg: error message if any.
1935: ----------------------------------------------------------------------------
1936: PROCEDURE VALIDATE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
1937: p_line_number IN NUMBER,
1938: p_setup_info IN OUT NOCOPY FTE_BULKLOAD_PKG.array_tbl,
1939: p_last_service_type IN OUT NOCOPY VARCHAR2,
1940: x_status OUT NOCOPY NUMBER,
1941: x_error_msg OUT NOCOPY VARCHAR2) IS
1942:

Line 1969: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1965: l_value_to := FTE_UTIL_PKG.GET_DATA('VALUE_TO', p_values);
1966: l_uom := FTE_UTIL_PKG.GET_DATA('UOM', p_values);
1967: l_currency := FTE_UTIL_PKG.GET_DATA('CURRENCY', p_values);
1968:
1969: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1970: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Service Level', l_service_type);
1971: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', l_type);
1972: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Subtype', l_subtype);
1973: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Name', l_name);

Line 2031: PROCEDURE VALIDATE_ORIGIN(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

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,
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

Line 2053: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2049: l_origin_country := FTE_UTIL_PKG.GET_DATA('COUNTRY', p_values);
2050: l_origin_state := FTE_UTIL_PKG.GET_DATA('STATE', p_values);
2051: l_origin_city := FTE_UTIL_PKG.GET_DATA('CITY', p_values);
2052:
2053: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2054: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Country', l_origin_country);
2055: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'State', l_origin_state);
2056: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'City', l_origin_city);
2057: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Postal', l_origin_postal);

Line 2110: PROCEDURE VALIDATE_DESTINATION(p_values IN OUT NOCOPY FTE_BULKLOAD_PKG.data_values_tbl,

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,
2111: p_line_number IN NUMBER,
2112: p_price_prefix IN VARCHAR2,
2113: p_carrier_id IN NUMBER,
2114: p_origin_zone IN FTE_BULKLOAD_PKG.data_values_tbl,

Line 2114: p_origin_zone IN FTE_BULKLOAD_PKG.data_values_tbl,

2110: PROCEDURE VALIDATE_DESTINATION(p_values IN OUT NOCOPY FTE_BULKLOAD_PKG.data_values_tbl,
2111: p_line_number IN NUMBER,
2112: p_price_prefix IN VARCHAR2,
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,

Line 2140: l_service_value := p_values(FTE_BULKLOAD_PKG.g_block_header_index(p_services(i)));

2136: --replace invalid PricelistNames with empty string("")
2137: --UPS has -, [1], [2], [3]
2138: --Fedex has *, NA
2139: FOR i IN 1..p_service_count LOOP
2140: l_service_value := p_values(FTE_BULKLOAD_PKG.g_block_header_index(p_services(i)));
2141: IF (l_service_value IS NULL OR l_service_value IN ('-', '*', 'NA')
2142: OR ((INSTR(l_service_value, '[') > 0) AND (INSTR(l_service_value, ']') > 0)
2143: AND (INSTR(l_service_value, ']') > INSTR(l_service_value, '[')))) THEN
2144: p_values(FTE_BULKLOAD_PKG.g_block_header_index(p_services(i))) := '';

Line 2144: p_values(FTE_BULKLOAD_PKG.g_block_header_index(p_services(i))) := '';

2140: l_service_value := p_values(FTE_BULKLOAD_PKG.g_block_header_index(p_services(i)));
2141: IF (l_service_value IS NULL OR l_service_value IN ('-', '*', 'NA')
2142: OR ((INSTR(l_service_value, '[') > 0) AND (INSTR(l_service_value, ']') > 0)
2143: AND (INSTR(l_service_value, ']') > INSTR(l_service_value, '[')))) THEN
2144: p_values(FTE_BULKLOAD_PKG.g_block_header_index(p_services(i))) := '';
2145: END IF;
2146: l_array.EXTEND;
2147: l_array(i) := l_service_value;
2148: END LOOP;

Line 2168: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2164: l_dest_country := FTE_UTIL_PKG.GET_DATA('COUNTRY', p_values);
2165: l_dest_state := FTE_UTIL_PKG.GET_DATA('STATE', p_values);
2166: l_dest_city := FTE_UTIL_PKG.GET_DATA('CITY', p_values);
2167:
2168: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2169: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Country', l_dest_country);
2170: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'State', l_dest_state);
2171: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'City', l_dest_city);
2172: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Postal', l_dest_postal);

Line 2230: PROCEDURE VALIDATE_LANE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

2226: -- 1. p_lane_rate_chart_tbl: pl/sql table for lane rate charts
2227: -- 2. x_status: status of the processing, -1 means no error
2228: -- 3. x_error_msg: error message if any.
2229: ----------------------------------------------------------------------------
2230: PROCEDURE VALIDATE_LANE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2231: p_line_number IN NUMBER,
2232: p_action IN VARCHAR2,
2233: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,
2234: p_lane_rate_chart_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_rate_chart_tbl,

Line 2247: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2243: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
2244:
2245: x_status := -1;
2246:
2247: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2248: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action ', p_action);
2249: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane ID ', p_lane_tbl(p_lane_tbl.COUNT).lane_id);
2250: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
2251: END IF;

Line 2308: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2304: RETURN;
2305:
2306: END IF;
2307:
2308: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2309: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate chart name', l_rate_chart_name);
2310: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'List header ID', l_rate_chart_info(1));
2311: END IF;
2312:

Line 2359: p_lane_rate_chart_tbl(l_count).start_date_active := TO_DATE(l_rate_chart_info(2), FTE_BULKLOAD_PKG.G_DATE_FORMAT2);

2355: p_lane_rate_chart_tbl(l_count).list_header_id := TO_NUMBER(l_rate_chart_info(1));
2356:
2357: IF (l_rate_chart_info(2) IS NOT NULL) THEN
2358: BEGIN
2359: p_lane_rate_chart_tbl(l_count).start_date_active := TO_DATE(l_rate_chart_info(2), FTE_BULKLOAD_PKG.G_DATE_FORMAT2);
2360: EXCEPTION
2361: WHEN OTHERS THEN
2362: x_error_msg := sqlerrm;
2363: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 2385: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2381: x_status := 1;
2382: RETURN;
2383: END IF;
2384:
2385: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2386: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date', l_rate_chart_info(2));
2387: END IF;
2388: END IF;
2389:

Line 2392: p_lane_rate_chart_tbl(l_count).end_date_active := TO_DATE(l_rate_chart_info(3), FTE_BULKLOAD_PKG.G_DATE_FORMAT2);

2388: END IF;
2389:
2390: IF (l_rate_chart_info(3) IS NOT NULL) THEN
2391: BEGIN
2392: p_lane_rate_chart_tbl(l_count).end_date_active := TO_DATE(l_rate_chart_info(3), FTE_BULKLOAD_PKG.G_DATE_FORMAT2);
2393: EXCEPTION
2394: WHEN OTHERS THEN
2395: x_error_msg := sqlerrm;
2396: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 2418: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2414: x_status := 1;
2415: RETURN;
2416: END IF;
2417:
2418: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2419: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date', l_rate_chart_info(3));
2420: END IF;
2421: END IF;
2422: END IF;

Line 2464: PROCEDURE VALIDATE_LANE_COMMODITY(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

2460: -- 1. p_lane_commodity_tbl: pl/sql table for lane commodity
2461: -- 2. x_status: status of the processing, -1 means no error
2462: -- 3. x_error_msg: error message if any.
2463: ----------------------------------------------------------------------------
2464: PROCEDURE VALIDATE_LANE_COMMODITY(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2465: p_line_number IN NUMBER,
2466: p_type IN VARCHAR2,
2467: p_action IN VARCHAR2,
2468: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,

Line 2485: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2481: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
2482:
2483: x_status := -1;
2484:
2485: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2486: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
2487: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
2488: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
2489: END IF;

Line 2502: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2498: IF (p_lane_tbl(p_lane_tbl.COUNT).lane_id <> 0) THEN
2499: l_com_class := p_lane_tbl(p_lane_tbl.COUNT).comm_fc_class_code;
2500: l_com_type := FTE_UTIL_PKG.GET_DATA('COMMODITY_TYPE', p_values);
2501:
2502: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2503: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Commodity class', l_com_class);
2504: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Commodity type', l_com_type);
2505: END IF;
2506:

Line 2669: PROCEDURE VALIDATE_LANE_SERVICE_LEVEL(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

2665: -- 1. p_lane_service_tbl: pl/sql table for lane service level
2666: -- 2. x_status: status of the processing, -1 means no error
2667: -- 3. x_error_msg: error message if any.
2668: ----------------------------------------------------------------------------
2669: PROCEDURE VALIDATE_LANE_SERVICE_LEVEL(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2670: p_line_number IN NUMBER,
2671: p_type IN VARCHAR2,
2672: p_action IN VARCHAR2,
2673: p_lane_tbl IN FTE_LANE_PKG.lane_tbl,

Line 2688: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2684: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
2685:
2686: x_status := -1;
2687:
2688: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2689: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
2690: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
2691: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
2692: END IF;

Line 2704: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2700:
2701: IF (p_type = 'SERVICE_LEVEL') THEN
2702: l_service_level := FTE_UTIL_PKG.GET_DATA('SERVICE_LEVEL', p_values);
2703:
2704: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2705: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Service Level', l_service_level);
2706: END IF;
2707: END IF;
2708:

Line 2849: PROCEDURE VALIDATE_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

2845: -- 6. p_lane_commodity_tbl: pl/sql table for lane commodity
2846: -- 7. x_status: status of the processing, -1 means no error
2847: -- 8. x_error_msg: error message if any.
2848: ----------------------------------------------------------------------------
2849: PROCEDURE VALIDATE_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
2850: p_line_number IN NUMBER,
2851: p_type OUT NOCOPY VARCHAR2,
2852: p_action OUT NOCOPY VARCHAR2,
2853: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,

Line 2900: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2896:
2897: p_type := FTE_UTIL_PKG.GET_DATA('TYPE', p_values);
2898: p_action := FTE_UTIL_PKG.GET_DATA('ACTION', p_values);
2899:
2900: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2901: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', p_type);
2902: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
2903: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);
2904: END IF;

Line 2962: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2958: l_effect_date := FTE_UTIL_PKG.GET_DATA('START_DATE', p_values);
2959: l_expiry_date := FTE_UTIL_PKG.GET_DATA('END_DATE', p_values);
2960: l_editable_flag := FTE_UTIL_PKG.GET_DATA('EDITABLE_FLAG', p_values);
2961:
2962: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2963: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane number', l_lane_number);
2964: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier name', l_carrier_name);
2965: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate chart name', l_rate_chart_name);
2966: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Mode of transportation', l_mode);

Line 3032: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3028: RETURN;
3029: ELSE
3030: l_old_lane_id := FTE_LANE_PKG.GET_LANE_ID(l_lane_number, l_carrier_id);
3031:
3032: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3033: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Old Lane ID', l_old_lane_id);
3034: END IF;
3035:
3036: p_lane_tbl(l_count).lane_id := l_old_lane_id;

Line 3237: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3233:
3234:
3235: END IF;
3236:
3237: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3238: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Origin ID', p_lane_tbl(l_count).origin_id);
3239: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Destination ID', p_lane_tbl(l_count).destination_id);
3240: END IF;
3241:

Line 3569: PROCEDURE VALIDATE_SERVICE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

3565: -- 5. p_action: action value of the line
3566: -- 6. x_status: status of the processing, -1 means no error
3567: -- 7. x_error_msg: error message if any.
3568: ----------------------------------------------------------------------------
3569: PROCEDURE VALIDATE_SERVICE_RATING_SETUP(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
3570: p_line_number IN NUMBER,
3571: p_pre_lane_number IN VARCHAR2,
3572: p_prc_parameter_tbl IN OUT NOCOPY FTE_LANE_PKG.prc_parameter_tbl,
3573: p_deficit_wt IN OUT NOCOPY BOOLEAN,

Line 3634: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3630: l_value_to := FTE_UTIL_PKG.GET_DATA('VALUE_TO', p_values);
3631: l_uom := FTE_UTIL_PKG.GET_DATA('UOM', p_values);
3632: l_currency := FTE_UTIL_PKG.GET_DATA('CURRENCY', p_values);
3633:
3634: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3635: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Type', l_type);
3636: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
3637: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Pre Lane Number', p_pre_lane_number);
3638: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane function', p_lane_function);

Line 4090: PROCEDURE VALIDATE_SCHEDULE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

4086: -- 2. p_action: action value of the line
4087: -- 3. x_status: status of the processing, -1 means no error
4088: -- 4. x_error_msg: error message if any.
4089: ----------------------------------------------------------------------------
4090: PROCEDURE VALIDATE_SCHEDULE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
4091: p_line_number IN NUMBER,
4092: p_schedule_tbl IN OUT NOCOPY FTE_LANE_PKG.schedule_tbl,
4093: p_action OUT NOCOPY VARCHAR2,
4094: x_status OUT NOCOPY NUMBER,

Line 4155: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4151: l_port_discharge := FTE_UTIL_PKG.GET_DATA('PORT_OF_DISCHARGE', p_values);
4152: l_start_date := FTE_UTIL_PKG.GET_DATA('START_DATE', p_values);
4153: l_end_date := FTE_UTIL_PKG.GET_DATA('END_DATE', p_values);
4154:
4155: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4156: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
4157: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Lane Number', l_lane_number);
4158: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Carrier name', l_carrier_name);
4159: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Vessel type', l_vessel_type);

Line 4372: l_tmp_tm := TO_CHAR(TO_DATE(l_departure_tm, FTE_BULKLOAD_PKG.G_TIME_FORMAT), FTE_BULKLOAD_PKG.G_TIME_FORMAT);

4368: RETURN;
4369: ELSE
4370: l_departure_tm := TRIM(' ' FROM l_departure_tm);
4371: BEGIN
4372: l_tmp_tm := TO_CHAR(TO_DATE(l_departure_tm, FTE_BULKLOAD_PKG.G_TIME_FORMAT), FTE_BULKLOAD_PKG.G_TIME_FORMAT);
4373: EXCEPTION
4374: WHEN OTHERS THEN
4375: x_error_msg := sqlerrm;
4376: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 4411: l_tmp_tm := TO_CHAR(TO_DATE(l_arrival_tm, FTE_BULKLOAD_PKG.G_TIME_FORMAT), FTE_BULKLOAD_PKG.G_TIME_FORMAT);

4407: RETURN;
4408: ELSE
4409: l_arrival_tm := TRIM(' ' FROM l_arrival_tm);
4410: BEGIN
4411: l_tmp_tm := TO_CHAR(TO_DATE(l_arrival_tm, FTE_BULKLOAD_PKG.G_TIME_FORMAT), FTE_BULKLOAD_PKG.G_TIME_FORMAT);
4412: EXCEPTION
4413: WHEN OTHERS THEN
4414: x_error_msg := sqlerrm;
4415: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 4451: p_schedule_tbl(l_count).departure_date := TO_DATE(TRIM(' ' FROM l_departure), FTE_BULKLOAD_PKG.G_DATE_FORMAT);

4447: l_departure := l_departure_dt || ' ' || l_departure_tm;
4448: END IF;
4449:
4450: BEGIN
4451: p_schedule_tbl(l_count).departure_date := TO_DATE(TRIM(' ' FROM l_departure), FTE_BULKLOAD_PKG.G_DATE_FORMAT);
4452: EXCEPTION
4453: WHEN OTHERS THEN
4454: x_error_msg := sqlerrm;
4455: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 4488: p_schedule_tbl(l_count).arrival_date := TO_DATE(TRIM(' ' FROM l_arrival), FTE_BULKLOAD_PKG.G_DATE_FORMAT);

4484: l_arrival := l_arrival_dt || ' ' || l_arrival_tm;
4485: END IF;
4486:
4487: BEGIN
4488: p_schedule_tbl(l_count).arrival_date := TO_DATE(TRIM(' ' FROM l_arrival), FTE_BULKLOAD_PKG.G_DATE_FORMAT);
4489: EXCEPTION
4490: WHEN OTHERS THEN
4491: x_error_msg := sqlerrm;
4492: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,

Line 4627: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4623: p_schedule_tbl(l_count).lane_id := l_lane_id;
4624: ELSE
4625: p_schedule_tbl(l_count).schedules_id := l_old_schedule_id;
4626: -- schedule already exist
4627: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4628: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Schedule already exist');
4629: END IF;
4630: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
4631: RETURN;

Line 4668: PROCEDURE VALIDATE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

4664: -- 4. p_carrier_id: carrier id
4665: -- 4. x_status: status of the processing, -1 means no error
4666: -- 5. x_error_msg: error message if any.
4667: -----------------------------------------------------------------------------
4668: PROCEDURE VALIDATE_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
4669: p_line_number IN NUMBER,
4670: p_validate IN BOOLEAN DEFAULT TRUE,
4671: p_process_id IN NUMBER default null,
4672: p_qp_list_header_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_header_tbl,

Line 4797: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4793: END IF;
4794: END IF;
4795:
4796: --DEBUG MESSAGES
4797: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4798: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', p_action);
4799: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Description', l_description);
4800: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Start date', l_start_date);
4801: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'End date', l_end_date);

Line 5063: FTE_RATE_CHART_PKG.G_Process_Id := FTE_BULKLOAD_PKG.get_process_id;

5059: l_list_header_id := TO_NUMBER(FTE_UTIL_PKG.Get_Data('LIST_HEADER_ID', p_values));
5060: END IF;
5061:
5062: IF (p_process_id is NULL) THEN
5063: FTE_RATE_CHART_PKG.G_Process_Id := FTE_BULKLOAD_PKG.get_process_id;
5064: ELSE
5065: FTE_RATE_CHART_PKG.G_Process_Id := p_process_id;
5066: END IF;
5067:

Line 5180: PROCEDURE VALIDATE_RATE_LINE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

5176: -- 2. p_qp_pricing_attrib_tbl: pl/sql table for the attributes
5177: -- 3. x_status: status of the processing, -1 means no error
5178: -- 4. x_error_msg: error message if any.
5179: -----------------------------------------------------------------------------
5180: PROCEDURE VALIDATE_RATE_LINE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
5181: p_line_number IN NUMBER,
5182: p_validate IN BOOLEAN DEFAULT TRUE,
5183: p_qp_list_line_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_line_tbl,
5184: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,

Line 5314: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5310: ELSE
5311: l_mod_level_code := 'LINE';
5312: END IF;
5313:
5314: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5315: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', l_action);
5316: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Description', l_description );
5317: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate', l_operamt);
5318: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'UOM', l_uom);

Line 5614: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5610: IF (l_chart_type IN ('FTE_RATE_CHART', 'FAC_RATE_CHART')) THEN
5611: l_break_type := NULL;
5612: END IF;
5613:
5614: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5615: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Chart Type', l_chart_type);
5616: END IF;
5617:
5618: p_qp_list_line_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

Line 5748: PROCEDURE VALIDATE_RATE_BREAK(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

5744: -- 2. p_qp_pricing_attrib_tbl: pl/sql table for the attributes
5745: -- 3. x_status: status of the processing, -1 means no error
5746: -- 4. x_error_msg: error message if any.
5747: -----------------------------------------------------------------------------
5748: PROCEDURE VALIDATE_RATE_BREAK(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
5749: p_line_number IN NUMBER,
5750: p_validate IN BOOLEAN DEFAULT TRUE,
5751: p_qp_list_line_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_line_tbl,
5752: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,

Line 5833: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5829: ELSE
5830: l_mod_level_code := 'LINE';
5831: END IF;
5832:
5833: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5834: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', l_action);
5835: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate type', l_rate_type);
5836: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute', l_pricing_attribute);
5837: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute value', l_attr_value_from );

Line 5935: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5931: -- check if UPPER_LIMIT is greater than or equal to LOWER_LIMIT
5932: l_lower := l_attr_value_from;
5933: l_upper := l_attr_value_to;
5934:
5935: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5936: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute Value From', l_attr_value_from);
5937: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute Value To', l_attr_value_to);
5938: END IF;
5939:

Line 6112: PROCEDURE VALIDATE_RATING_ATTRIBUTE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

6108: -- 1. p_qp_pricing_attrib_tbl: pl/sql table for the attributes
6109: -- 2. x_status: status of the processing, -1 means no error
6110: -- 3. x_error_msg: error message if any.
6111: -----------------------------------------------------------------------------
6112: PROCEDURE VALIDATE_RATING_ATTRIBUTE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
6113: p_line_number IN NUMBER,
6114: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,
6115: x_status OUT NOCOPY NUMBER,
6116: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 6157: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

6153: l_pricing_attr_value_to := FTE_UTIL_PKG.GET_DATA('ATTRIBUTE_VALUE_TO', p_values);
6154: l_context := FTE_UTIL_PKG.GET_DATA('CONTEXT', p_values);
6155: l_comp_operator := FTE_UTIL_PKG.GET_DATA('COMPARISON_OPERATOR', p_values);
6156:
6157: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
6158: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', l_action);
6159: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute', l_pricing_attribute);
6160: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute value', l_pricing_attr_value_from );
6161: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute value to', l_pricing_attr_value_to );

Line 6576: PROCEDURE VALIDATE_ADJUSTED_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

6572: -- 1. p_qp_qualifier_tbl: pl/sql table for the attributes
6573: -- 2. x_status: status of the processing, -1 means no error
6574: -- 3. x_error_msg: error message if any.
6575: -----------------------------------------------------------------------------
6576: PROCEDURE VALIDATE_ADJUSTED_RATE_CHART(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
6577: p_line_number IN NUMBER,
6578: p_carrier_id IN NUMBER,
6579: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,
6580: x_status OUT NOCOPY NUMBER,

Line 6608: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

6604: l_action := FTE_UTIL_PKG.GET_DATA('ACTION', p_values);
6605: l_name := FTE_UTIL_PKG.GET_DATA('RATE_CHART_NAME', p_values);
6606: l_tariff := FTE_UTIL_PKG.GET_DATA('TARIFF_NAME', p_values);
6607:
6608: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
6609: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', l_action);
6610: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Rate Chart name', l_name);
6611: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Tariff Name', l_tariff);
6612: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Line number', p_line_number);

Line 6775: PROCEDURE VALIDATE_QUALIFIER(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

6771: -- 1. p_qp_qualifier_tbl: pl/sql table for the attributes
6772: -- 2. x_status: status of the processing, -1 means no error
6773: -- 3. x_error_msg: error message if any.
6774: -----------------------------------------------------------------------------
6775: PROCEDURE VALIDATE_QUALIFIER(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
6776: p_line_number IN NUMBER,
6777: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,
6778: x_status OUT NOCOPY NUMBER,
6779: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 6807: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

6803: IF (l_qual_group IS NULL) THEN
6804: l_qual_group := 1;
6805: END IF;
6806:
6807: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
6808: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Action', l_action);
6809: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Process ID', l_process_id);
6810: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute', l_qual_attr);
6811: FTE_UTIL_PKG.WRITE_LOGFILE(l_module_name, 'Attribute Value', l_qual_attr_value);

Line 6889: -- 1. FTE_UTIL_PKG.GET_DATA: FTE_BULKLOAD_PKG.data_values_tbl

6885: --
6886: -- Purpose: does validation for a line in tl service block
6887: --
6888: -- IN parameters:
6889: -- 1. FTE_UTIL_PKG.GET_DATA: FTE_BULKLOAD_PKG.data_values_tbl
6890: -- 2. p_line_number: line number of current line
6891: --
6892: -- OUT parameters:
6893: -- 1. p_type: type value of the line

Line 6898: PROCEDURE VALIDATE_TL_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

6894: -- 2. p_action: action value of the line
6895: -- 3. x_status: status of the processing, -1 means no error
6896: -- 4. x_error_msg: error message if any.
6897: ----------------------------------------------------------------------------
6898: PROCEDURE VALIDATE_TL_SERVICE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
6899: p_line_number IN NUMBER,
6900: p_type OUT NOCOPY VARCHAR2,
6901: p_action OUT NOCOPY VARCHAR2,
6902: p_lane_tbl IN OUT NOCOPY FTE_LANE_PKG.lane_tbl,

Line 6931: l_lane_rate_chart_data FTE_BULKLOAD_PKG.data_values_tbl;

6927: l_apply_hold BOOLEAN;
6928:
6929: l_zone_id NUMBER;
6930:
6931: l_lane_rate_chart_data FTE_BULKLOAD_PKG.data_values_tbl;
6932: l_lane_service_level_data FTE_BULKLOAD_PKG.data_values_tbl;
6933:
6934: l_region_id WSH_REGIONS.REGION_ID%TYPE;
6935:

Line 6932: l_lane_service_level_data FTE_BULKLOAD_PKG.data_values_tbl;

6928:
6929: l_zone_id NUMBER;
6930:
6931: l_lane_rate_chart_data FTE_BULKLOAD_PKG.data_values_tbl;
6932: l_lane_service_level_data FTE_BULKLOAD_PKG.data_values_tbl;
6933:
6934: l_region_id WSH_REGIONS.REGION_ID%TYPE;
6935:
6936: g_debug_on BOOLEAN := TRUE;

Line 7388: PROCEDURE VALIDATE_ZONE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

7384: -- 7. x_status: status of the processing, -1 means no error
7385: -- 8. x_error_msg: error message if any.
7386: --_______________________________________________________________________________________--
7387:
7388: PROCEDURE VALIDATE_ZONE(p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
7389: p_line_number IN NUMBER,
7390: p_region_type IN VARCHAR2,
7391: p_action OUT NOCOPY VARCHAR2,
7392: p_zone_name OUT NOCOPY VARCHAR2,