APPS.FTE_TL_LOADER dependencies on FTE_BULKLOAD_PKG

Line 36: G_DUMMY_BLOCK_HDR_TBL FTE_BULKLOAD_PKG.block_header_tbl;

32: G_LANE_RATE_CHART_TBL FTE_LANE_PKG.lane_rate_chart_tbl;
33: G_LANE_SERVICE_TBL FTE_LANE_PKG.lane_service_tbl;
34: G_LANE_COMMODITY_TBL FTE_LANE_PKG.LANE_COMMODITY_TBL;
35:
36: G_DUMMY_BLOCK_HDR_TBL FTE_BULKLOAD_PKG.block_header_tbl;
37:
38: G_PKG_NAME CONSTANT VARCHAR2(50) := 'FTE_TL_LOADER';
39:
40: ------------------------- GLOBAL Variables END -----------------------------------

Line 144: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

140:
141: FTE_UTIL_PKG.Enter_Debug(l_module_name);
142: x_status := -1;
143:
144: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
145: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Getting Carrier Preferences for ' || p_carrier_name);
146: END IF;
147:
148: -- Unit rate basis for WEIGHT/VOLUME/CONTAINER/PALLET

Line 237: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

233: g_service_level := p_service_level;
234:
235: END IF;
236:
237: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
238: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'g_carrier_name ', g_carrier_name);
239: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'g_service_level ', g_service_level);
240: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'g_carrier_id ', g_carrier_id);
241: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'g_rate_basis ', g_carrier_unit_basis);

Line 298: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

294: FTE_UTIL_PKG.Enter_Debug(l_module_name);
295: x_status := -1;
296: l_basis_type := p_rate_basis;
297:
298: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
299: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_carrier_name ',p_carrier_name);
300: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_rate_basis ',p_rate_basis);
301: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_rate_basis_uom',p_rate_basis_uom);
302: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_service_level',p_service_level);

Line 539: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

535:
536: FTE_UTIL_PKG.Enter_Debug(l_module_name);
537: x_status := -1;
538:
539: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
540: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_chart_name',p_chart_name);
541: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_currency ',p_currency);
542: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_chart_type', p_chart_type);
543: END IF;

Line 585: x_job_id := FTE_BULKLOAD_PKG.GET_PROCESS_ID;

581: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Programmer Error: Chart_Type NOT SPECIFIED');
582: x_status := 2;
583: END IF;
584:
585: x_job_id := FTE_BULKLOAD_PKG.GET_PROCESS_ID;
586: Chart_Process_Ids(Chart_Process_Ids.COUNT + 1) := x_job_id;
587:
588: --+
589: -- validate the rate chart to ensure that it can be loaded.

Line 677: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN

673: x_status := -1;
674:
675: l_name := UPPER(p_chart_name);
676:
677: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN
678: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_name ',l_name );
679: END IF;
680:
681: OPEN GET_LANES(p_chart_name);

Line 703: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

699: x_error_msg => x_error_msg,
700: x_status => x_status);
701:
702: IF (x_status <> -1) THEN
703: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
704: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Error message from GET_CARRIER_PREFERENCES => ' || x_error_msg );
705: END IF;
706: FTE_UTIL_PKG.Exit_Debug(l_module_name);
707: RETURN FALSE;

Line 711: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

707: RETURN FALSE;
708: END IF;
709:
710: FOR i IN 1..l_carrier_ids.COUNT LOOP
711: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
712: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_lane_numbers(' || i || ')', l_lane_numbers(i));
713: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_lane_services('|| i || ')', l_lane_services(i));
714: END IF;
715:

Line 794: IF( FTE_BULKLOAD_PKG.g_debug_on) THEN

790: END LOOP;
791:
792: x_status := 2;
793:
794: IF( FTE_BULKLOAD_PKG.g_debug_on) THEN
795: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Error: Rate Chart ' || p_chart_name || ' not found');
796: END IF;
797:
798: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 840: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;

836: l_mod_name VARCHAR2(50);
837: l_temp VARCHAR2(30);
838: l_carrier_name VARCHAR2(100);
839:
840: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
841: l_qualifier_data_tbl FTE_BULKLOAD_PKG.block_data_tbl;
842:
843: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.LINK_RC_MODIFIERS';
844:

Line 841: l_qualifier_data_tbl FTE_BULKLOAD_PKG.block_data_tbl;

837: l_temp VARCHAR2(30);
838: l_carrier_name VARCHAR2(100);
839:
840: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
841: l_qualifier_data_tbl FTE_BULKLOAD_PKG.block_data_tbl;
842:
843: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.LINK_RC_MODIFIERS';
844:
845: BEGIN

Line 859: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

855: IF (Link_ChartNames(i) = p_chart_name) THEN
856:
857: l_mod_name := Link_ModifierNames(i);
858:
859: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
860: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Modifier for ' || p_chart_name || ' is ' || l_mod_name);
861: END IF;
862:
863: BEGIN

Line 896: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

892: p_line_number => 0,
893: x_error_msg => x_error_msg,
894: x_status => x_status);
895:
896: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
897: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_chart_name', p_chart_name);
898: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_mod_name ', l_mod_name);
899: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rc_id ', l_rc_id);
900: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_mod_pid ', l_mod_pid);

Line 988: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

984: END IF;
985: END LOOP;
986:
987: x_status := 2;
988: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
989: x_error_msg:='Facility Rate Chart Name Not Found';
990: FTE_UTIL_PKG.Write_LogFile(l_module_name , x_error_msg);
991: FTE_UTIL_PKG.Exit_Debug(l_module_name);
992: RETURN;

Line 1042: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;

1038: x_error_msg OUT NOCOPY VARCHAR2,
1039: x_status OUT NOCOPY NUMBER ) IS
1040:
1041:
1042: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1043: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1044:
1045: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'||G_PKG_NAME||'.ADD_ATTRIBUTE';
1046:

Line 1043: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1039: x_status OUT NOCOPY NUMBER ) IS
1040:
1041:
1042: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1043: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1044:
1045: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'||G_PKG_NAME||'.ADD_ATTRIBUTE';
1046:
1047: BEGIN

Line 1194: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;

1190: l_index1 NUMBER;
1191: l_index2 NUMBER;
1192: p_line_number NUMBER := 0;
1193:
1194: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
1195: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1196:
1197: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.CREATE_BREAKS';
1198:

Line 1195: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1191: l_index2 NUMBER;
1192: p_line_number NUMBER := 0;
1193:
1194: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
1195: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1196:
1197: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.CREATE_BREAKS';
1198:
1199: BEGIN

Line 1216: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1212: l_break_min := l_break_max + p_break_gap;
1213: l_break_max := Fnd_Number.Canonical_To_Number(p_break_limits(l_index2));
1214: x_linenum := x_linenum + 1;
1215:
1216: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1217: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'x_linenum ' || x_linenum);
1218: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_break_min' || l_break_min);
1219: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_break_max' || l_break_max);
1220: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate ' || l_rate);

Line 1318: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

1314: l_charge_info STRINGARRAY;
1315: l_formula_id NUMBER;
1316: l_carrier_name VARCHAR2(100);
1317:
1318: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1319: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1320:
1321: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1322: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 1319: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1315: l_formula_id NUMBER;
1316: l_carrier_name VARCHAR2(100);
1317:
1318: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1319: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1320:
1321: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1322: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1323:

Line 1321: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

1317:
1318: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1319: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1320:
1321: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1322: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1323:
1324: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.CREATE_MINCHARGE_MODIFIER';
1325:

Line 1322: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1318: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1319: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1320:
1321: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1322: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1323:
1324: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.CREATE_MINCHARGE_MODIFIER';
1325:
1326: BEGIN

Line 1336: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1332: l_service_level := p_service_level;
1333: l_chart_type := 'MIN_MODIFIER';
1334: l_carrier_name := p_carrier_name;
1335:
1336: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1337: FTE_UTIL_PKG.Write_LogFile(l_module_name, p_service_level||'::'||p_chart_name||'::'||p_currency);
1338: END IF;
1339:
1340: -- Store modifier data.

Line 1352: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1348: p_line_number => p_line_number,
1349: x_error_msg => x_error_msg,
1350: x_status => x_status);
1351:
1352: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1353: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_linenum ', l_linenum);
1354: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_process_id ', l_process_id);
1355: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_service_level', l_service_level);
1356: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating Modifier Header For ' || x_mod_name);

Line 1397: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1393: RETURN;
1394: END IF;
1395:
1396:
1397: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1398: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_charge_data', p_charge_data);
1399: END IF;
1400:
1401: l_charge_info := FTE_UTIL_PKG.TOKENIZE_STRING(p_string => p_charge_data,

Line 1457: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1453: -- WEIGHT/VOLUME/PALLET/CONTAINER
1454: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_UNIT_CH;
1455: END IF;
1456:
1457: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1458: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);
1459: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_subtype ', l_subtype);
1460: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_basis ', l_basis);
1461: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_vehicle_type',l_vehicle_type);

Line 1746: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

1742: l_context VARCHAR2(50);
1743: l_attribute_value VARCHAR2(50);
1744: l_attribute_type VARCHAR2(50);
1745:
1746: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1747: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1748:
1749: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.PROCESS_WKND_LAYOVR_CHARGES';
1750:

Line 1747: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1743: l_attribute_value VARCHAR2(50);
1744: l_attribute_type VARCHAR2(50);
1745:
1746: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1747: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1748:
1749: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.PROCESS_WKND_LAYOVR_CHARGES';
1750:
1751: BEGIN

Line 1758: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1754:
1755: x_linenum := x_linenum + 1;
1756: l_description := 'Weekend Layover Charge: Line ' || x_linenum;
1757:
1758: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1759: FTE_UTIL_PKG.Write_LogFile(l_module_name, l_description);
1760: END IF;
1761:
1762: l_type := 'ACCESSORIAL_SURCHARGE';

Line 1813: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1809: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1810: RETURN;
1811: END IF;
1812:
1813: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1814: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Begin Create Breaks');
1815: END IF;
1816:
1817: CREATE_BREAKS (p_break_charges => g_layovr_charges,

Line 2012: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2008: x_status := 2;
2009: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'ERROR BREAK: No Rate Chart Name Previously Defined');
2010: END IF;
2011:
2012: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2013: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_name ', g_chart_name);
2014: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_process_id ', l_process_id);
2015: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_service_level', l_service_level);
2016: END IF;

Line 2067: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2063: FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS(p_qp_call => FALSE,
2064: x_error_msg => x_error_msg,
2065: x_status => x_status);
2066:
2067: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2068: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Status from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_status);
2069: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return Message from FTE_RATE_CHART_LOADER.SUBMIT_QP_PROCESS', x_error_msg);
2070: END IF;
2071:

Line 2081: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2077:
2078: FND_PROFILE.PUT('QP_PRICING_TRANSACTION_ENTITY', 'LOGSTX');
2079: FND_PROFILE.PUT('QP_SOURCE_SYSTEM_CODE', 'FTE');
2080:
2081: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2082: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Chart_Process_Ids.COUNT ', Chart_Process_Ids.COUNT);
2083: END IF;
2084:
2085: FOR i IN 1..Chart_Process_Ids.COUNT LOOP

Line 2093: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2089: l_service_level := Chart_Service_Levels(i);
2090: l_chart_type := Chart_Types(i);
2091: l_currency := Chart_Currencies(i);
2092:
2093: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2094: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_chart_name ', l_chart_name);
2095: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_carrier_name ', l_carrier_name);
2096: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_process_id ', l_process_id);
2097: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_service_level', l_service_level);

Line 2186: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2182: FTE_UTIL_PKG.Exit_Debug(l_module_name);
2183: RETURN;
2184: END IF;
2185:
2186: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2187: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Found ' || l_lane_ids.COUNT || ' lanes matching rate chart');
2188: END IF;
2189:
2190: IF (l_lane_loaded) THEN

Line 2192: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2188: END IF;
2189:
2190: IF (l_lane_loaded) THEN
2191:
2192: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2193: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Updating Existing Lanes with Rate Chart Info');
2194: END IF;
2195:
2196: BEGIN

Line 2231: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2227: FTE_UTIL_PKG.Exit_Debug(l_module_name);
2228: RETURN;
2229: END;
2230:
2231: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2232: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_list_header_id', l_list_header_id);
2233: END IF;
2234:
2235: --+

Line 2240: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2236: -- Update the lane with the rate chart ID:
2237: --+
2238: FOR j IN 1..l_lane_ids.COUNT LOOP
2239: BEGIN
2240: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2241: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'lane id('|| j|| ')',l_lane_ids(j));
2242: END IF;
2243:
2244: INSERT INTO FTE_LANE_RATE_CHARTS (LANE_ID,

Line 2270: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2266: FTE_UTIL_PKG.Exit_Debug(l_module_name);
2267: END;
2268:
2269: BEGIN
2270: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2271: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Updating Fte_Lanes with service level ', l_service_level);
2272: END IF;
2273:
2274: UPDATE fte_lanes

Line 2295: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2291: END IF;
2292:
2293: ELSIF (l_chart_type = 'FAC_MODIFIER') THEN
2294:
2295: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2296: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Postprocessing Facility Modifier');
2297: END IF;
2298:
2299: BEGIN

Line 2352: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2348: --+
2349: -- Insert Facility Data into FTE_PRC_PARAMETERS
2350: --+
2351: BEGIN
2352: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2353: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting into FTE_PRC_PARAMETERS');
2354: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_chart_name ', l_chart_name);
2355: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate_basis ', l_rate_basis);
2356: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate_basis_uom', l_rate_basis_uom);

Line 2440: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

2436: l_attribute_value VARCHAR2(50);
2437: l_attribute_type VARCHAR2(50);
2438: l_context VARCHAR2(30);
2439:
2440: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2441: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2442:
2443: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.PROCESS_FUEL_CHARGES';
2444:

Line 2441: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

2437: l_attribute_type VARCHAR2(50);
2438: l_context VARCHAR2(30);
2439:
2440: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2441: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2442:
2443: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.PROCESS_FUEL_CHARGES';
2444:
2445: BEGIN

Line 2452: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2448:
2449: x_linenum := x_linenum + 1;
2450: l_description := 'Fuel Surcharge Line ' || x_linenum;
2451:
2452: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2453: FTE_UTIL_PKG.Write_LogFile(l_module_name, l_description);
2454: END IF;
2455:
2456: l_type := 'ACCESSORIAL_SURCHARGE';

Line 2548: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

2544: l_attribute_value VARCHAR2(50);
2545: l_attribute_type VARCHAR2(50);
2546: l_context VARCHAR2(30);
2547:
2548: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2549: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2550:
2551: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.PROCESS_REGION_CHARGES';
2552:

Line 2549: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

2545: l_attribute_type VARCHAR2(50);
2546: l_context VARCHAR2(30);
2547:
2548: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2549: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2550:
2551: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.'||G_PKG_NAME||'.PROCESS_REGION_CHARGES';
2552:
2553: BEGIN

Line 2577: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2573:
2574: x_linenum := x_linenum + 1;
2575: l_description := p_region_type || ' Surcharge Line ' || x_linenum;
2576:
2577: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2578: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Zone Id', l_zone_id);
2579: FTE_UTIL_PKG.Write_LogFile(l_module_name, l_description);
2580: END IF;
2581:

Line 2698: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

2694: l_context VARCHAR2(50);
2695: l_attribute_value VARCHAR2(50);
2696: l_attribute_type VARCHAR2(50);
2697:
2698: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2699: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2700:
2701: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_STOPOFF_CHARGES';
2702:

Line 2699: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

2695: l_attribute_value VARCHAR2(50);
2696: l_attribute_type VARCHAR2(50);
2697:
2698: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2699: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2700:
2701: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_STOPOFF_CHARGES';
2702:
2703: BEGIN

Line 2709: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2705: x_status := -1;
2706:
2707: l_break_charges := p_break_charges;
2708:
2709: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2710: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_num_free_stops', p_num_free_stops);
2711: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_process_id ', p_process_id);
2712: FTE_UTIL_PKG.Write_LogFile(l_module_name,'x_linenum ', x_linenum);
2713: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_line_number ', p_line_number);

Line 2751: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2747: IF (l_break_charges.COUNT > 0) THEN
2748: x_linenum := x_linenum + 1;
2749: l_description := 'Stop Off Charge: Line ' || x_linenum;
2750:
2751: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2752: FTE_UTIL_PKG.Write_LogFile(l_module_name, l_description, l_description);
2753: END IF;
2754:
2755: l_type := 'ACCESSORIAL_SURCHARGE';

Line 2827: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2823:
2824: --+
2825: -- Create Breaks
2826: --+
2827: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2828: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Begin Create Breaks');
2829: END IF;
2830:
2831: CREATE_BREAKS(p_break_charges => l_break_charges,

Line 2902: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

2898: l_attr3_context VARCHAR2(50);
2899: l_attr_value_from VARCHAR2(50);
2900: l_attr_value_to VARCHAR2(50);
2901:
2902: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2903: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2904:
2905: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
2906: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 2903: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

2899: l_attr_value_from VARCHAR2(50);
2900: l_attr_value_to VARCHAR2(50);
2901:
2902: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2903: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2904:
2905: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
2906: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2907:

Line 2905: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;

2901:
2902: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2903: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2904:
2905: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
2906: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2907:
2908: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_LOADING_CHARGES';
2909:

Line 2906: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

2902: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
2903: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2904:
2905: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
2906: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
2907:
2908: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_LOADING_CHARGES';
2909:
2910: BEGIN

Line 3294: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3290:
3291: x_linenum := x_linenum + 1;
3292: l_description := p_load_type || ' : Line ' || x_linenum;
3293:
3294: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3295: FTE_UTIL_PKG.Write_LogFile(l_module_name, l_description);
3296: END IF;
3297:
3298: l_rate_line_data('ACTION') := G_ACTION;

Line 3531: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

3527: l_rate_type VARCHAR2(25);
3528: l_volume_type VARCHAR2(25);
3529: l_subtype VARCHAR2(30);
3530:
3531: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
3532: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
3533: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3534: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3535:

Line 3532: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;

3528: l_volume_type VARCHAR2(25);
3529: l_subtype VARCHAR2(30);
3530:
3531: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
3532: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
3533: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3534: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3535:
3536: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_BLOCK_UNIT_CHARGES';

Line 3533: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

3529: l_subtype VARCHAR2(30);
3530:
3531: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
3532: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
3533: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3534: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3535:
3536: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_BLOCK_UNIT_CHARGES';
3537:

Line 3534: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

3530:
3531: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
3532: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
3533: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3534: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3535:
3536: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_BLOCK_UNIT_CHARGES';
3537:
3538: BEGIN

Line 3554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3550: ELSIF (p_subtype = FTE_RTG_GLOBALS.G_C_WEEKDAY_LAYOVER_CH) THEN
3551: l_description := 'Weekday Layover Charge: Line ' || x_linenum;
3552: END IF;
3553:
3554: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3555: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_description', l_description);
3556: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_type ', l_type);
3557: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_break_type ', l_break_type);
3558: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_subtype ', p_subtype);

Line 3695: PROCEDURE PROCESS_CHART_SURCHARGES (p_values IN FTE_BULKLOAD_PKG.data_values_tbl,

3691: -- x_error_msg, the corresponding error message,
3692: -- if any exception occurs during the process.
3693: --_________________________________________________________________________________--
3694:
3695: PROCEDURE PROCESS_CHART_SURCHARGES (p_values IN FTE_BULKLOAD_PKG.data_values_tbl,
3696: p_chart_type IN VARCHAR2,
3697: p_process_id IN NUMBER,
3698: p_line_number IN NUMBER,
3699: p_doValidate IN BOOLEAN DEFAULT TRUE,

Line 3741: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

3737: l_subtype VARCHAR2(50);
3738: l_carrier_name VARCHAR2(100);
3739: l_service_level VARCHAR2(30);
3740:
3741: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
3742: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3743:
3744: BEGIN
3745:

Line 3742: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

3738: l_carrier_name VARCHAR2(100);
3739: l_service_level VARCHAR2(30);
3740:
3741: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
3742: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
3743:
3744: BEGIN
3745:
3746: FTE_UTIL_PKG.Enter_Debug(l_module_name);

Line 3843: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3839: FTE_UTIL_PKG.Exit_Debug(l_module_name);
3840: RETURN;
3841: END IF;
3842:
3843: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3844:
3845: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Validating Modifier for Process ID ' || p_process_id);
3846: FTE_UTIL_PKG.Write_LogFile(l_module_name, '-------------------------------------------');
3847: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_num_free_stops ',l_num_free_stops);

Line 4236: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4232: --+
4233:
4234: IF (p_chart_type = 'FAC_MODIFIER') THEN
4235:
4236: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4237: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Facility Modifier : Storing UOM ',l_rate_basis_uom);
4238: END IF;
4239:
4240: Fac_Modifier_Names(Fac_Modifier_Names.COUNT+1) := FTE_UTIL_PKG.GET_DATA('FACILITY_RATE_CHART_NAME', p_values);

Line 4283: PROCEDURE PROCESS_FACILITY_CHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

4279: -- 2.x_error_msg: the corresponding error meassge, --
4280: -- if any exception occurs during the process. --
4281: --_________________________________________________________________________________--
4282:
4283: PROCEDURE PROCESS_FACILITY_CHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
4284: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
4285: p_line_number IN NUMBER,
4286: x_error_msg OUT NOCOPY VARCHAR2,
4287: x_status OUT NOCOPY NUMBER) IS

Line 4284: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

4280: -- if any exception occurs during the process. --
4281: --_________________________________________________________________________________--
4282:
4283: PROCEDURE PROCESS_FACILITY_CHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
4284: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
4285: p_line_number IN NUMBER,
4286: x_error_msg OUT NOCOPY VARCHAR2,
4287: x_status OUT NOCOPY NUMBER) IS
4288:

Line 4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;

4300: l_status VARCHAR2(4000);
4301: l_service_level VARCHAR2(30);
4302: l_assoc_rc_ids STRINGARRAY;
4303:
4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
4307: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4308: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

4301: l_service_level VARCHAR2(30);
4302: l_assoc_rc_ids STRINGARRAY;
4303:
4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
4307: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4308: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4309:

Line 4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

4302: l_assoc_rc_ids STRINGARRAY;
4303:
4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
4307: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4308: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4309:
4310: l_type CONSTANT VARCHAR2(30) := 'FACILITY_CHARGES';

Line 4307: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

4303:
4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
4307: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4308: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4309:
4310: l_type CONSTANT VARCHAR2(30) := 'FACILITY_CHARGES';
4311: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_FACILITY_CHARGES';

Line 4308: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
4307: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4308: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4309:
4310: l_type CONSTANT VARCHAR2(30) := 'FACILITY_CHARGES';
4311: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_FACILITY_CHARGES';
4312:

Line 4379: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4375: RETURN;
4376: END;
4377: END IF;
4378:
4379: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4380: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_ACTION ',G_ACTION);
4381: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_name ',l_name);
4382: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_currency ',l_currency);
4383: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_start_date',l_start_date);

Line 4430: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

4426: p_action => 'DELETE',
4427: p_line_number => p_line_number + i + 1,
4428: x_status => x_status,
4429: x_error_msg => x_error_msg);
4430: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
4431: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Deleting Rate Chart with ID '||l_assoc_rc_ids(i)|| ' of Modifier ' || l_name);
4432: END IF;
4433: END LOOP;
4434:

Line 4470: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

4466: -- For update, the dummy pricelist already exists. We don't need to recreate it.
4467: --+
4468: IF (G_ACTION = 'ADD') THEN
4469:
4470: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
4471: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Create Dummy Rate Chart');
4472: END IF;
4473:
4474: l_rc_name := l_name || '_RC';

Line 4491: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

4487: x_error_msg => x_error_msg,
4488: x_status => x_status);
4489:
4490:
4491: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
4492: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating Fac Chart Header');
4493: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Name', l_rc_name);
4494: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'PID ', l_process_id);
4495: END IF;

Line 4567: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

4563:
4564: --+
4565: -- Create Modifier Header
4566: --+
4567: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
4568: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating Modifier Header For ' || l_name);
4569: END IF;
4570:
4571: l_description := 'Rate Chart ' || l_name;

Line 4618: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4614: END LOOP;
4615:
4616: SUBMIT_TL_CHART(x_status, x_error_msg);
4617:
4618: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4619: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return status from SUBMIT_TL_CHART',x_status);
4620: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return Message from SUBMIT_TL_CHART',x_error_msg);
4621: END IF;
4622:

Line 4668: PROCEDURE PROCESS_TL_SURCHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

4664: -- 2.x_error_msg: the corresponding error meassge, --
4665: -- if any exception occurs during the process. --
4666: --_________________________________________________________________________________--
4667:
4668: PROCEDURE PROCESS_TL_SURCHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
4669: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
4670: p_line_number IN NUMBER,
4671: p_doValidate IN BOOLEAN DEFAULT TRUE,
4672: x_error_msg OUT NOCOPY VARCHAR2,

Line 4669: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

4665: -- if any exception occurs during the process. --
4666: --_________________________________________________________________________________--
4667:
4668: PROCEDURE PROCESS_TL_SURCHARGES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
4669: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
4670: p_line_number IN NUMBER,
4671: p_doValidate IN BOOLEAN DEFAULT TRUE,
4672: x_error_msg OUT NOCOPY VARCHAR2,
4673: x_status OUT NOCOPY NUMBER) IS

Line 4704: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

4700: l_chart_type CONSTANT VARCHAR2(50) := 'TL_MODIFIER';
4701: l_block_type CONSTANT VARCHAR2(25) := 'TL_SURCHARGES';
4702: l_region_info wsh_regions_search_pkg.region_rec;
4703:
4704: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4705: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4706: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4707:
4708: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_TL_SURCHARGES';

Line 4705: l_values FTE_BULKLOAD_PKG.data_values_tbl;

4701: l_block_type CONSTANT VARCHAR2(25) := 'TL_SURCHARGES';
4702: l_region_info wsh_regions_search_pkg.region_rec;
4703:
4704: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4705: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4706: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4707:
4708: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_TL_SURCHARGES';
4709:

Line 4706: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

4702: l_region_info wsh_regions_search_pkg.region_rec;
4703:
4704: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4705: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4706: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
4707:
4708: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_TL_SURCHARGES';
4709:
4710: BEGIN

Line 4726: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4722: RETURN;
4723: END IF;
4724: END IF;
4725:
4726: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4727: FTE_UTIL_PKG.Write_LogFile(l_module_name,'g_unit_uom',g_unit_uom);
4728: END IF;
4729:
4730: IF( p_doValidate ) THEN

Line 4750: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4746:
4747: l_type := FTE_UTIL_PKG.GET_DATA('TYPE',l_values);
4748: l_type := UPPER(l_type);
4749:
4750: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4751: FTE_UTIL_PKG.Write_LogFile(l_module_name,'i ',i);
4752: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_type',l_type);
4753: END IF;
4754:

Line 4808: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4804: END IF;
4805:
4806: G_ACTION := UPPER(G_ACTION);
4807:
4808: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4809: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_ACTION ',G_ACTION);
4810: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_name ',l_name);
4811: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_service_level',l_service_level);
4812: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_carrier_name ',l_carrier_name);

Line 4932: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4928: END IF;
4929:
4930: IF (G_ACTION = 'DELETE') THEN
4931:
4932: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4933: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting TL_MODIFIER ' || l_name);
4934: END IF;
4935:
4936: FTE_RATE_CHART_PKG.G_CHART_TYPE := l_chart_type;

Line 4984: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

4980: --
4981: -- Create Modifier Header
4982: --
4983:
4984: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
4985: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating Modifier Header For ' || l_name);
4986: END IF;
4987:
4988: l_description := 'Rate Chart ' || g_chart_name;

Line 5036: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

5032: END IF;
5033:
5034: ELSIF (l_type = 'B') THEN
5035:
5036: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
5037: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Weekend Layover Break.');
5038: END IF;
5039:
5040: GET_CHART_DATA(p_chart_name => g_chart_name,

Line 5072: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5068: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5069: RETURN;
5070: END IF;
5071:
5072: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5073: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate ', l_rate);
5074: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'g_chart_name ', g_chart_name);
5075: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_linenum ', l_linenum);
5076: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_process_id ', l_process_id);

Line 5167: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5163: p_line_number => p_line_number + i + 1,
5164: x_error_msg => x_error_msg,
5165: x_status => x_status);
5166:
5167: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5168: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'g_chart_name', g_chart_name);
5169: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_linenum', l_linenum);
5170: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_process_id', l_process_id);
5171: END IF;

Line 5184: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5180: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5181: RETURN;
5182: END IF;
5183:
5184: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5185: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate', l_rate);
5186: END IF;
5187:
5188: IF (l_type IN ('O', 'D')) THEN

Line 5204: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5200: l_zipcode_from := FTE_UTIL_PKG.GET_DATA('POSTAL_CODE_FROM', l_values);
5201: l_zipcode_to := FTE_UTIL_PKG.GET_DATA('POSTAL_CODE_TO', l_values);
5202: l_zone := FTE_UTIL_PKG.GET_DATA('ZONE', l_values);
5203:
5204: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5205: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_country', l_country);
5206: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_state', l_state);
5207: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_city', l_city);
5208: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zipcode_to', l_zipcode_to);

Line 5270: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5266: END LOOP;
5267:
5268: SUBMIT_TL_CHART(x_status, x_error_msg);
5269:
5270: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5271: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return status from SUBMIT_TL_CHART',x_status);
5272: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return Message from SUBMIT_TL_CHART',x_error_msg);
5273: END IF;
5274:

Line 5331: PROCEDURE PROCESS_TL_BASE_RATES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

5327: -- DISTANCE_TYPE, SERVICE_LEVEL,VEHICLE_TYPE, RATE, MINIMUM_CHARGE, --
5328: -- START_DATE, END_DATE --
5329: --_________________________________________________________________________________--
5330:
5331: PROCEDURE PROCESS_TL_BASE_RATES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
5332: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
5333: p_line_number IN NUMBER,
5334: p_doValidate IN BOOLEAN DEFAULT TRUE,
5335: x_status OUT NOCOPY NUMBER,

Line 5332: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

5328: -- START_DATE, END_DATE --
5329: --_________________________________________________________________________________--
5330:
5331: PROCEDURE PROCESS_TL_BASE_RATES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
5332: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
5333: p_line_number IN NUMBER,
5334: p_doValidate IN BOOLEAN DEFAULT TRUE,
5335: x_status OUT NOCOPY NUMBER,
5336: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 5374: l_values FTE_BULKLOAD_PKG.data_values_tbl;

5370: --+
5371: l_carrier_id NUMBER;
5372:
5373:
5374: l_values FTE_BULKLOAD_PKG.data_values_tbl;
5375: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
5376: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
5377: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5378: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 5375: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

5371: l_carrier_id NUMBER;
5372:
5373:
5374: l_values FTE_BULKLOAD_PKG.data_values_tbl;
5375: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
5376: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
5377: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5378: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5379:

Line 5376: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

5372:
5373:
5374: l_values FTE_BULKLOAD_PKG.data_values_tbl;
5375: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
5376: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
5377: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5378: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5379:
5380: l_type CONSTANT VARCHAR2(25) := 'TL_BASE_RATES';

Line 5377: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

5373:
5374: l_values FTE_BULKLOAD_PKG.data_values_tbl;
5375: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
5376: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
5377: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5378: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5379:
5380: l_type CONSTANT VARCHAR2(25) := 'TL_BASE_RATES';
5381: l_module_name CONSTANT VARCHAR2(100):= 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_TL_BASE_RATES';

Line 5378: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

5374: l_values FTE_BULKLOAD_PKG.data_values_tbl;
5375: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
5376: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
5377: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5378: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
5379:
5380: l_type CONSTANT VARCHAR2(25) := 'TL_BASE_RATES';
5381: l_module_name CONSTANT VARCHAR2(100):= 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_TL_BASE_RATES';
5382:

Line 5541: l_start_date := to_char(to_date(l_start_date, 'MM/DD/YYYY'), FTE_BULKLOAD_PKG.G_DATE_FORMAT);

5537:
5538: IF (l_start_date IS NOT NULL) THEN
5539: BEGIN
5540: IF (p_doValidate) THEN
5541: l_start_date := to_char(to_date(l_start_date, 'MM/DD/YYYY'), FTE_BULKLOAD_PKG.G_DATE_FORMAT);
5542: END IF;
5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: x_status := 2;

Line 5559: l_end_date := to_char(to_date(l_end_date, 'MM/DD/YYYY'), FTE_BULKLOAD_PKG.G_DATE_FORMAT);

5555:
5556: IF (l_end_date IS NOT NULL) THEN
5557: BEGIN
5558: IF (p_doValidate) THEN
5559: l_end_date := to_char(to_date(l_end_date, 'MM/DD/YYYY'), FTE_BULKLOAD_PKG.G_DATE_FORMAT);
5560: END IF;
5561: EXCEPTION
5562: WHEN OTHERS THEN
5563: x_status := 2;

Line 5602: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5598: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5599: RETURN;
5600: END IF;
5601:
5602: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5603: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_ACTION ',G_ACTION);
5604: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_rate_chart_name',l_rate_chart_name);
5605: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_carrier_name ',l_carrier_name);
5606: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_currency ',l_currency);

Line 5639: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5635: l_assoc_modifier_ids := FTE_RATE_CHART_PKG.GET_ASSOC_MODIFIERS(NULL, l_rate_chart_name);
5636:
5637: FOR i IN 1..l_assoc_modifier_ids.COUNT
5638: LOOP
5639: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5640: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting Modifier ' || l_assoc_modifier_ids(i) || ' of Rate Chart ' || l_rate_chart_name);
5641: END IF;
5642:
5643: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_MODIFIER';

Line 5670: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5666: GOTO next_record;
5667: END IF;
5668: END LOOP;
5669:
5670: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5671: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting TL_RATE_CHART ' || l_rate_chart_name);
5672: END IF;
5673:
5674: FTE_RATE_CHART_PKG.G_CHART_TYPE := 'TL_RATE_CHART';

Line 5931: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

5927: -- else it will have a non-zero value equal to the number of lines processed + 1 (header)
5928: --+
5929: IF (l_linenum = 0) THEN
5930:
5931: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
5932: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating Rate Chart Header For ' || l_rate_chart_name);
5933: END IF;
5934:
5935: l_description := 'Rate Chart ' || l_rate_chart_name;

Line 5975: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

5971: --+
5972: l_linenum := l_linenum + 1;
5973: l_description := 'Line ' || l_linenum || ' Of ' || l_rate_chart_name;
5974:
5975: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
5976: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);
5977: END IF;
5978:
5979: l_rate_line_data('ACTION') := G_ACTION;

Line 6035: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

6031: --+
6032: l_linenum := l_linenum + 1;
6033: l_description := 'Line ' || l_linenum || ' Of ' || l_rate_chart_name;
6034:
6035: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
6036: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);
6037: END IF;
6038:
6039: l_rate_line_data('ACTION') := G_ACTION;

Line 6091: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

6087: --+
6088: l_linenum := l_linenum + 1;
6089: l_description := 'Line ' || l_linenum || ' Of ' || l_rate_chart_name;
6090:
6091: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
6092: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);
6093: END IF;
6094:
6095: l_rate_line_data('ACTION') := G_ACTION;

Line 6230: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

6226:
6227: l_attribute := FTE_RTG_GLOBALS.G_C_CONTINUOUS_MOVE_DH_RT;
6228: l_precedence := G_CONST_PRECEDENCE_LOW;
6229:
6230: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
6231: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_description);
6232: END IF;
6233:
6234: l_rate_line_data('ACTION') := G_ACTION;

Line 6411: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

6407: END LOOP;
6408:
6409: SUBMIT_TL_CHART(x_status, x_error_msg);
6410:
6411: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
6412: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return status from SUBMIT_TL_CHART ', x_status);
6413: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return Message from SUBMIT_TL_CHART ', x_error_msg);
6414: END IF;
6415:

Line 6457: PROCEDURE PROCESS_TL_SERVICES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

6453: -- x_error_msg: the corresponding error meassge, --
6454: -- if any exception occurs during the process. --
6455: --_________________________________________________________________________________--
6456:
6457: PROCEDURE PROCESS_TL_SERVICES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
6458: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
6459: p_line_number IN NUMBER,
6460: x_status OUT NOCOPY NUMBER,
6461: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 6458: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

6454: -- if any exception occurs during the process. --
6455: --_________________________________________________________________________________--
6456:
6457: PROCEDURE PROCESS_TL_SERVICES(p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
6458: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
6459: p_line_number IN NUMBER,
6460: x_status OUT NOCOPY NUMBER,
6461: x_error_msg OUT NOCOPY VARCHAR2) IS
6462:

Line 6464: l_values FTE_BULKLOAD_PKG.data_values_tbl;

6460: x_status OUT NOCOPY NUMBER,
6461: x_error_msg OUT NOCOPY VARCHAR2) IS
6462:
6463: l_action VARCHAR2(100);
6464: l_values FTE_BULKLOAD_PKG.data_values_tbl;
6465:
6466: l_mode CONSTANT VARCHAR2(50) := 'TRUCK';
6467: l_type VARCHAR2(25) := 'TL_SERVICES';
6468: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.PROCESS_TL_SERVICES';

Line 6583: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,

6579: -- 2. x_error_msg: error message if any. --
6580: --_________________________________________________________________________________--
6581:
6582: PROCEDURE PROCESS_DATA ( p_type IN VARCHAR2,
6583: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
6584: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
6585: p_line_number IN NUMBER,
6586: x_status OUT NOCOPY NUMBER,
6587: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 6584: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,

6580: --_________________________________________________________________________________--
6581:
6582: PROCEDURE PROCESS_DATA ( p_type IN VARCHAR2,
6583: p_block_header IN FTE_BULKLOAD_PKG.block_header_tbl,
6584: p_block_data IN FTE_BULKLOAD_PKG.block_data_tbl,
6585: p_line_number IN NUMBER,
6586: x_status OUT NOCOPY NUMBER,
6587: x_error_msg OUT NOCOPY VARCHAR2) IS
6588:

Line 6596: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

6592:
6593: FTE_UTIL_PKG.Enter_Debug(l_module_name);
6594: x_status := -1;
6595:
6596: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
6597: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_type ', p_type);
6598: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_block_header count', p_block_header.COUNT);
6599: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_block_data.count ', p_block_data.count);
6600: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_line_number ', p_line_number);