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_LTL_LOADER dependencies on FTE_BULKLOAD_PKG

Line 8: -- DESCRIPTION: Gets a block of data from FTE_BULKLOAD_PKG --

4: /*----------------------------------------------------------------------------------------
5: -- --
6: -- NAME: FTE_LTL_LOADER --
7: -- TYPE: BODY --
8: -- DESCRIPTION: Gets a block of data from FTE_BULKLOAD_PKG --
9: -- and creates RATE-CHARTS, ZONES, LANES and more !! --
10: -- --
11: -- PROCEDURES: --
12: -- --

Line 52: G_DUMMY_BLOCK_HDR_TBL FTE_BULKLOAD_PKG.block_header_tbl;

48: G_DATE_FORMAT CONSTANT VARCHAR2(50) := 'MM-DD-YYYY hh24:mi:ss';
49: G_DATE CONSTANT VARCHAR2(50) := 'MM-DD-YYYY';
50:
51: G_REPORT_HEADER LTL_Report_Header;
52: G_DUMMY_BLOCK_HDR_TBL FTE_BULKLOAD_PKG.block_header_tbl;
53:
54: --+
55: -- Cursors used by more than one procedures
56: --+

Line 129: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

125: FTE_UTIL_PKG.Enter_Debug(l_module_name);
126:
127: l_request_data := FND_CONC_GLOBAL.REQUEST_DATA;
128:
129: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
130: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_request_data', l_request_data);
131: END IF;
132:
133: IF (l_request_data IS NULL) THEN

Line 932: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

928:
929: FTE_UTIL_PKG.Enter_Debug(l_module_name);
930: x_status := -1;
931:
932: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
933:
934: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Obsoleting Lanes...');
935:
936: IF (p_delete_lanes) THEN

Line 986: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

982: l_lane_ids, l_effective_dates, l_expiry_dates;
983:
984: END IF;
985:
986: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
987: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Obsoleted ' || sql%rowcount || ' lanes.');
988: END IF;
989:
990: FORALL i in 1..l_lane_ids.COUNT

Line 1004: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1000: list_header_id = (select list_header_id
1001: from fte_lane_rate_charts
1002: where lane_id = l_lane_ids(i));
1003:
1004: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1005: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Obsolete Lane Rate Charts');
1006: END IF;
1007:
1008: FORALL i in 1..l_lane_ids.COUNT

Line 1073: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

1069:
1070: l_process_id NUMBER;
1071: l_process_ids NUMBER_TAB;
1072:
1073: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1074: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1075:
1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 1074: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1070: l_process_id NUMBER;
1071: l_process_ids NUMBER_TAB;
1072:
1073: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1074: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1075:
1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1078:

Line 1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;

1072:
1073: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1074: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1075:
1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1078:
1079: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
1080: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;

Line 1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1073: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1074: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1075:
1076: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1077: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1078:
1079: l_currency_tbl FTE_RATE_CHART_PKG.LH_CURRENCY_CODE_TAB;
1080: l_name FTE_RATE_CHART_PKG.LH_NAME_TAB;
1081:

Line 1137: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1133: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1134: RETURN;
1135: END IF;
1136:
1137: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1138: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Number of ratecharts to modify',l_list_header_ids.COUNT);
1139: END IF;
1140:
1141: FOR i IN 1..l_list_header_ids.COUNT

Line 1150: FTE_BULKLOAD_PKG.g_load_id := l_process_id;

1146: FROM DUAL;
1147:
1148: l_process_ids(l_process_ids.COUNT + 1) := l_process_id;
1149:
1150: FTE_BULKLOAD_PKG.g_load_id := l_process_id;
1151:
1152: l_rate_hdr_data('ACTION') := 'APPEND';
1153: l_rate_hdr_data('LTL_RATE_CHART_NAME') := l_rate_names(i);
1154: l_rate_hdr_data('CARRIER_ID') := l_existing_carriers(1);

Line 1158: l_rate_hdr_data('START_DATE') := to_char(l_start_dates(i),FTE_BULKLOAD_PKG.G_DATE_FORMAT);

1154: l_rate_hdr_data('CARRIER_ID') := l_existing_carriers(1);
1155: l_rate_hdr_data('DESCRIPTION') := l_descriptions(i);
1156: l_rate_hdr_data('CURRENCY') := l_currency_codes(i);
1157: l_rate_hdr_data('ATTRIBUTE1') := 'LTL_RC';
1158: l_rate_hdr_data('START_DATE') := to_char(l_start_dates(i),FTE_BULKLOAD_PKG.G_DATE_FORMAT);
1159:
1160: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1161:
1162: FTE_RATE_CHART_LOADER.PROCESS_RATE_CHART(p_block_header => g_dummy_block_hdr_tbl,

Line 1210: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1206: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1207: RETURN;
1208: END IF;
1209:
1210: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1211: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Calling QP for update ...');
1212: END IF;
1213:
1214: FOR i IN 1..l_process_ids.COUNT

Line 1336: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

1332: lane_function = 'LTL';
1333:
1334: END IF;
1335:
1336: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
1337: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_LANE_FUNCTION_ID ', G_LANE_FUNCTION_ID );
1338: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_MIN_CHARGE_ID ', G_MIN_CHARGE_ID);
1339: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_DEF_WT_ENABLED_ID', G_DEF_WT_ENABLED_ID);
1340: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_DEF_WT_BREAK_ID ', G_DEF_WT_BREAK_ID);

Line 1429: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

1425: ELSE
1426: l_abort := 'No';
1427: END IF;
1428:
1429: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
1430: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Cleanup Tables: Abort', ' ' || l_abort || ' ' );
1431: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_load_id', p_load_id);
1432: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Save Interface data', p_save_data);
1433: END IF;

Line 1444: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

1440: EXIT WHEN GET_PROCESS_IDS%NOTFOUND;
1441:
1442: IF (p_abort) THEN
1443:
1444: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
1445: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting Data From QP Tables');
1446: END IF;
1447:
1448: DELETE FROM

Line 1503: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

1499: END IF;
1500:
1501: IF p_save_data <> 1 THEN
1502:
1503: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
1504: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting Data From QP Interface Tables For Process Id ' || l_process_id);
1505: END IF;
1506:
1507: DELETE FROM QP_INTERFACE_LIST_LINES WHERE process_id = l_process_id;

Line 1525: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1521: DELETE FROM fte_interface_zones WHERE zone_id IS NULL;
1522:
1523: l_num_zn := l_num_zn + SQL%ROWCOUNT;
1524:
1525: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1526: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_lh || ' from QP_LIST_HEADERS');
1527: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_ll || ' from QP_LIST_LINES');
1528: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_at || ' from QP_PRICINg_ATTRIBUTES');
1529: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_ql || ' from QP_QUALIFIERS');

Line 1544: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1540: WHERE
1541: tariff_name = p_tariff_name AND
1542: action_code = 'N';
1543:
1544: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1545: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || SQL%ROWCOUNT || ' rows from fte_tariff_carriers for tariff ' || p_tariff_name);
1546: END IF;
1547:
1548: UPDATE

Line 1559: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

1555: WHERE
1556: tariff_name = p_tariff_name AND
1557: action_code = 'M';
1558:
1559: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1560: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Updated ' || sql%rowcount || ' rows in fte_tariff_carriers.');
1561: END IF;
1562:
1563: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 1651: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

1647: v_break_max NUMBER := -1; -- max charge for the current break
1648:
1649: v_numBreaks_perClass CONSTANT NUMBER := 9; -- this is standard for LTL.
1650:
1651: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1652: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1653:
1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 1652: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1648:
1649: v_numBreaks_perClass CONSTANT NUMBER := 9; -- this is standard for LTL.
1650:
1651: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1652: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1653:
1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1656:

Line 1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

1650:
1651: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1652: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1653:
1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1656:
1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1651: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
1652: l_rate_hdr_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1653:
1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1656:
1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1659:

Line 1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;

1653:
1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1656:
1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1659:
1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1654: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;
1655: l_rate_line_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1656:
1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1659:
1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1662:

Line 1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;

1656:
1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1659:
1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1662:
1663: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
1664: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

Line 1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1657: l_qualifier_data FTE_BULKLOAD_PKG.data_values_tbl;
1658: l_qualifier_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1659:
1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1662:
1663: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
1664: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1665:

Line 1663: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;

1659:
1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1662:
1663: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
1664: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1665:
1666: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.CREATE_RATE_CHART';
1667:

Line 1664: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;

1660: l_attribute_data FTE_BULKLOAD_PKG.data_values_tbl;
1661: l_attribute_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1662:
1663: l_rate_break_data FTE_BULKLOAD_PKG.data_values_tbl;
1664: l_rate_break_block_tbl FTE_BULKLOAD_PKG.block_data_tbl;
1665:
1666: l_module_name CONSTANT VARCHAR2(100) := 'FTE.PLSQL.' || G_PKG_NAME || '.CREATE_RATE_CHART';
1667:
1668: BEGIN

Line 1686: FTE_BULKLOAD_PKG.g_load_id := x_process_id;

1682: FTE_UTIL_PKG.Write_LogFile(l_module_name, x_error_msg);
1683: FTE_UTIL_PKG.Exit_Debug(l_module_name);
1684: END;
1685:
1686: FTE_BULKLOAD_PKG.g_load_id := x_process_id;
1687:
1688: G_TOTAL_NUMCHARTS := G_TOTAL_NUMCHARTS + 1;
1689:
1690: --+

Line 1767: l_rate_hdr_data('START_DATE') := to_char(G_VALID_DATE,FTE_BULKLOAD_PKG.G_DATE_FORMAT);

1763: l_rate_hdr_data('CARRIER_ID') := p_carrier_ids(1);
1764: l_rate_hdr_data('DESCRIPTION') := v_description;
1765: l_rate_hdr_data('CURRENCY') := G_LTL_CURRENCY;
1766: l_rate_hdr_data('ATTRIBUTE1') := 'LTL_RC';
1767: l_rate_hdr_data('START_DATE') := to_char(G_VALID_DATE,FTE_BULKLOAD_PKG.G_DATE_FORMAT);
1768: l_rate_hdr_data('END_DATE') := '';
1769:
1770: l_rate_hdr_block_tbl(1) := l_rate_hdr_data;
1771:

Line 2036: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN

2032: x_status := -1;
2033:
2034: l_catg_id := p_category_ids(1);
2035:
2036: IF ( FTE_BULKLOAD_PKG.g_debug_on ) THEN
2037: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_origin_id ',p_origin_id);
2038: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_destination_id ',p_destination_id );
2039: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_tariff_name ',p_tariff_name);
2040: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_list_header_id ',p_list_header_id);

Line 2227: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2223: l_lanes_temp.min_charge1 LIMIT 1000;
2224:
2225: FOR i IN 1..l_lanes_temp.origin_id.COUNT LOOP
2226:
2227: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2228: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_lanes_temp.rate_chart_name('||i||')',l_lanes_temp.rate_chart_name(i));
2229: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_lanes_temp.origin_id('||i||')',l_lanes_temp.origin_id(i));
2230: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_lanes_temp.dest_id('||i||')',l_lanes_temp.dest_id(i));
2231: END IF;

Line 2315: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2311: END LOOP;
2312:
2313: CLOSE GET_LANES;
2314:
2315: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2316: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Bulk Inserting Last Set of Data');
2317: END IF;
2318:
2319: Bulk_Insert_Lanes;

Line 2415: IF FTE_BULKLOAD_PKG.g_debug_on THEN

2411:
2412: x_identical_zone := NULL;
2413: x_zone_id := NULL;
2414:
2415: IF FTE_BULKLOAD_PKG.g_debug_on THEN
2416: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_zone_name ', p_zone_name);
2417: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_matching_zones.COUNT', p_matching_zones.COUNT);
2418: END IF;
2419:

Line 2457: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2453: ELSE
2454: l_new_country_code := G_DEST_COUNTRY;
2455: END IF;
2456:
2457: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2458: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_new_country_code', l_new_country_code);
2459: END IF;
2460:
2461: OPEN GET_ZONE_COUNTRY(p_matching_zones(i));

Line 2475: IF ( FTE_BULKLOAD_PKG.g_debug_on) THEN

2471: l_mismatch := TRUE;
2472:
2473: FOR k IN 1..l_country_codes.COUNT LOOP
2474:
2475: IF ( FTE_BULKLOAD_PKG.g_debug_on) THEN
2476: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_country_codes(' || k || ')', l_country_codes(k));
2477: END IF;
2478:
2479: IF (l_new_country_code = l_country_codes(k)) THEN -- if found a country match, then can use this zone

Line 2569: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

2565:
2566: p_retcode := '0';
2567: x_status := -1;
2568:
2569: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
2570: l_debug_on := 1;
2571: END IF;
2572:
2573: --

Line 2587: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

2583: argument1 => p_load_id,
2584: argument2 => l_counter,
2585: argument3 => l_debug_on);
2586:
2587: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
2588: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Submitted Sub-request with ID => ' || x_request_ids(l_counter));
2589: FTE_UTIL_PKG.Write_LogFile(l_module_name,'p_load_id ',p_load_id);
2590: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_counter ',l_counter);
2591: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_debug_on',l_debug_on);

Line 2762: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2758: OPEN GET_LOAD_NUMBER(p_tariff_name);
2759:
2760: FETCH GET_LOAD_NUMBER INTO l_number_of_loads;
2761:
2762: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2763: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_number_of_loads',l_number_of_loads);
2764: END IF;
2765:
2766: IF (GET_LOAD_NUMBER%FOUND) THEN

Line 2800: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2796: END IF;
2797:
2798: EXIT WHEN (NEW_ORIGIN%NOTFOUND);
2799:
2800: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2801: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_IN_OUT ', G_IN_OUT);
2802: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_ORIGIN_DEST', G_ORIGIN_DEST);
2803: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_origin ', l_origin);
2804: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_origin_high', l_origin_high);

Line 2870: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

2866: l_dest_low := l_lanes_temp.dest_low(l_counter);
2867: l_dest_high := l_lanes_temp.dest_high(l_counter);
2868: l_min_charge1 := l_lanes_temp.min_charge1(l_counter); -- it is the same for all of the classes
2869:
2870: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
2871: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_previous_dest_low ', l_previous_dest_low);
2872: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_previous_dest_high', l_previous_dest_high);
2873: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_dest_low ', l_dest_low);
2874: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_dest_high ', l_dest_high);

Line 2983: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2979:
2980: -- reuse the rate chart
2981: l_rate_name := l_rate_names(1);
2982:
2983: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
2984: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_rate_name' || l_rate_name);
2985: END IF;
2986:
2987: --+

Line 3000: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

2996:
2997: l_min_charge_match := TRUE;
2998: l_row_number := row_num_max(l_dest_names(i));
2999:
3000: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3001: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_row_number' || l_row_number);
3002: END IF;
3003:
3004: INSERT INTO fte_interface_zones(ZONE_NAME,

Line 3295: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

3291: l_zones_temp.dest_high LIMIT 1000;
3292:
3293: c_current_fetch := DEFINE_ZONES%ROWCOUNT - c_previous_fetch;
3294:
3295: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
3296: FTE_UTIL_PKG.Write_LogFile(l_module_name,'c_current_fetch ', c_current_fetch);
3297: FTE_UTIL_PKG.Write_LogFile(l_module_name,'DEFINE_ZONES%ROWCOUNT',define_zones%ROWCOUNT);
3298: FTE_UTIL_PKG.Write_LogFile(l_module_name,'c_previous_fetch ',c_previous_fetch);
3299: END IF;

Line 3305: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

3301: EXIT WHEN (c_current_fetch <= 0);
3302:
3303: WHILE (l_counter <= c_current_fetch) LOOP
3304:
3305: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
3306: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_counter ', l_counter);
3307: FTE_UTIL_PKG.Write_LogFile(l_module_name,'c_current_fetch', c_current_fetch);
3308: IF (l_need_to_fetch) THEN
3309: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_need_to_fetch','TRUE');

Line 3404: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

3400: l_new_zones_info.sum_row_number,
3401: l_new_zones_info.max_row_number,
3402: l_new_zones_info.sum_hash_value LIMIT 1000;
3403:
3404: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
3405: FTE_UTIL_PKG.Write_LogFile(l_module_name,'GET_NEW_ZONES_INFO%ROWCOUNT',GET_NEW_ZONES_INFO%ROWCOUNT);
3406: END IF;
3407:
3408:

Line 3416: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3412: l_sum_row_number := l_new_zones_info.sum_row_number(i);
3413: l_max_row_number := l_new_zones_info.max_row_number(i);
3414: l_sum_hash_value := l_new_zones_info.sum_hash_value(i);
3415:
3416: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3417: FTE_UTIL_PKG.Write_LogFile(l_module_name,'i',i);
3418: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_zone_name ',l_zone_name);
3419: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_sum_row_number ',l_sum_row_number);
3420: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_max_row_number ',l_max_row_number);

Line 3436: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3432: l_num_zone_matches := GET_EXISTING_ZONE_INFO%ROWCOUNT;
3433:
3434: CLOSE GET_EXISTING_ZONE_INFO;
3435:
3436: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3437: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_num_zone_matches', l_num_zone_matches);
3438: END IF;
3439:
3440: IF (l_num_zone_matches >= 1) THEN

Line 3463: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3459: x_status => l_return_status,
3460: x_error_msg => l_error_msg);
3461: END IF;
3462:
3463: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3464: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_identical_zone', l_identical_zone);
3465: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_zone_name ', l_zone_name);
3466: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_zone_id ', l_zone_id);
3467: END IF;

Line 3471: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3467: END IF;
3468:
3469: IF (l_identical_zone IS NOT NULL) THEN
3470:
3471: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3472: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Found Matching Zone');
3473: END IF;
3474:
3475: IF (l_zone_id IS NULL) THEN

Line 3615: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

3611: l_zones_temp.dest_high LIMIT 1000;
3612:
3613: c_current_fetch := BULK_ZONES%ROWCOUNT - c_previous_fetch;
3614:
3615: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
3616: FTE_UTIL_PKG.Write_LogFile(l_module_name,'c_current_fetch ', c_current_fetch);
3617: FTE_UTIL_PKG.Write_LogFile(l_module_name,'BULK_ZONES%ROWCOUNT ', BULK_ZONES%ROWCOUNT);
3618: FTE_UTIL_PKG.Write_LogFile(l_module_name,'c_previous_fetch ', c_previous_fetch);
3619: END IF;

Line 3627: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

3623: WHILE (l_counter <= c_current_fetch) LOOP
3624:
3625: l_zone_name := l_zones_temp.zone_name(l_counter);
3626:
3627: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
3628: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_zone_name ', l_zone_name);
3629: FTE_UTIL_PKG.Write_LogFile(l_module_name,'l_counter ', l_counter);
3630: END IF;
3631:

Line 3760: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3756: p_module_name => l_module_name,
3757: p_category => 'D',
3758: p_line_number => 0);
3759:
3760: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3761: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zones_temp.dest_low(' || l_counter || ')', l_zones_temp.dest_low(l_counter-1));
3762: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_zones_temp.dest_high(' || l_counter || ')', l_zones_temp.dest_high(l_counter-1));
3763: END IF;
3764:

Line 3908: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3904: l_debug_on := t_varchar2_tab(5);
3905: G_DIRECTION_FLAG := t_varchar2_tab(6);
3906: G_REPORT_HEADER.StartDate := t_varchar2_tab(7);
3907:
3908: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3909: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_VALID_DATE ', G_VALID_DATE);
3910: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_number_of_loads', l_number_of_loads);
3911: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_origin ', l_origin);
3912: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_origin_name ', l_origin_name);

Line 3927: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3923: l_counter := l_requests_tab.first;
3924:
3925: WHILE (l_counter is not null) LOOP
3926:
3927: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3928: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Status of sub-request ' || l_counter, l_requests_tab(l_counter).dev_status);
3929: END IF;
3930:
3931: IF (l_requests_tab(l_counter).dev_status IN('ERROR','TERMINATED')) THEN

Line 3949: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

3945: GET_PARAMETER_DEFAULTS(x_status => x_status,
3946: x_error_msg => x_error_msg);
3947:
3948: IF (x_status <> -1) THEN
3949: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
3950: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Return status from GET_PARAMETER_DEFAULTS ',x_status);
3951: END IF;
3952: FTE_UTIL_PKG.Exit_Debug(l_module_name);
3953: RETURN;

Line 4031: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4027: --+
4028: -- Update the dates in fte_tariff_carriers
4029: --+
4030:
4031: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4032: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update FTE_TARIFF_CARRIERS to complete process');
4033: END IF;
4034:
4035: FORALL n IN 1..p_carrier_ids.COUNT

Line 4097: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

4093:
4094: FTE_UTIL_PKG.Enter_Debug(l_module_name);
4095: x_status := -1;
4096:
4097: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4098: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting ' || FL_ORIGIN_LOW.COUNT || ' rows into fte_bulkload_file.');
4099: END IF;
4100:
4101: FORALL i in 1..FL_ORIGIN_LOW.COUNT

Line 4206: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4202:
4203: IF ( p_ltl_line IS NULL OR p_ltl_line = '' ) THEN
4204: x_status := 2;
4205: x_error_msg := 'Returning from PROCESS_LTL_LINE as p_ltl_line';
4206: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4207: FTE_UTIL_PKG.Write_LogFile(l_module_name,x_error_msg, p_ltl_line);
4208: END IF;
4209: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4210: RETURN;

Line 4305: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

4301: x_error_msg => x_error_msg);
4302:
4303: IF (x_status <> -1) THEN
4304:
4305: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4306: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'INSERT_LTL_DATA returned with ERROR');
4307: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Return status ', x_status);
4308: END IF;
4309: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 4389: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4385: BEGIN
4386: FTE_UTIL_PKG.Enter_Debug(l_module_name);
4387: x_status := -1;
4388:
4389: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4390: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'File name', p_file_name);
4391: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Load Id', p_load_id);
4392: END IF;
4393:

Line 4407: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4403:
4404: l_size := dbms_lob.getlength(l_content);
4405: data_buffer := NULL;
4406:
4407: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4408: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'File size', l_size);
4409: END IF;
4410:
4411: WHILE l_size > 0 LOOP

Line 4464: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4460: INSERT_LTL_DATA(p_load_id => p_load_id,
4461: x_status => x_status,
4462: x_error_msg => x_error_msg);
4463:
4464: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4465: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Finished Reading File.');
4466: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Number of lines processed ', g_processed_lines);
4467: END IF;
4468:

Line 4516: l_src_file_dir := FTE_BULKLOAD_PKG.GET_UPLOAD_DIR;

4512: BEGIN
4513: FTE_UTIL_PKG.Enter_Debug(l_module_name);
4514: x_status := -1;
4515:
4516: l_src_file_dir := FTE_BULKLOAD_PKG.GET_UPLOAD_DIR;
4517:
4518: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4519: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_src_file_dir ',l_src_file_dir);
4520: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_file_name ',p_file_name);

Line 4518: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4514: x_status := -1;
4515:
4516: l_src_file_dir := FTE_BULKLOAD_PKG.GET_UPLOAD_DIR;
4517:
4518: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4519: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_src_file_dir ',l_src_file_dir);
4520: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_file_name ',p_file_name);
4521: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'G_BULK_INSERT_LIMIT', G_BULK_INSERT_LIMIT);
4522: END IF;

Line 4531: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4527: UTL_FILE.GET_LINE(l_chart_file, l_line);
4528:
4529: l_line := replace(l_line, l_carriage_return, ''); -- dos2unix conversion
4530:
4531: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4532: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'l_line', l_line);
4533: END IF;
4534:
4535: PROCESS_LTL_LINE(p_load_id => p_load_id,

Line 4558: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4554: IF(isFileEmpty = 'N') THEN
4555: --
4556: -- Insert the last set of lines
4557: --
4558: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4559: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Inserting last set of lines :-)');
4560: END IF;
4561:
4562: INSERT_LTL_DATA(p_load_id => p_load_id,

Line 4566: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4562: INSERT_LTL_DATA(p_load_id => p_load_id,
4563: x_status => x_status,
4564: x_error_msg => x_error_msg);
4565:
4566: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4567: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Finished Reading File.');
4568: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Number of lines processed: ' || g_processed_lines);
4569: END IF;
4570: x_status := -1;

Line 4728: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4724: CLOSE GET_TARIFF_CARRIERS;
4725:
4726: IF (l_add_carriers.COUNT <= 0) THEN
4727:
4728: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4729: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'No new carriers to add');
4730: END IF;
4731:
4732: OPEN GET_LOAD_NUMBER(p_tariff_name => p_tariff_name);

Line 4786: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

4782: END IF;
4783:
4784: CLOSE GET_PREVIOUS_LOAD_INFO;
4785:
4786: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4787: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Service Code ', G_SERVICE_CODE);
4788: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Origin Country Code ', g_orig_country);
4789: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Destination Country Code', g_dest_country);
4790: END IF;

Line 4822: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

4818: l_current_fetch := Get_Tariff_Lanes%ROWCOUNT - l_fetch_total;
4819:
4820: EXIT WHEN (l_current_fetch <= 0);
4821:
4822: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4823: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Creating ' || l_lane_ids.COUNT || ' new lanes for carriers');
4824: END IF;
4825:
4826: IF (l_rc_start_dates.COUNT > 0) THEN

Line 4875: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4871: tariff_name = p_tariff_name AND
4872: action_code = 'N' AND
4873: carrier_id = l_add_carriers(p);
4874:
4875: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4876: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Calling Add_Carriers_To_RateCharts');
4877: END IF;
4878:
4879: ADD_CARRIERS_TO_RATECHARTS(p_tariff_name => p_tariff_name,

Line 4893: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

4889: END IF;
4890:
4891: END IF;
4892:
4893: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4894: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Bulk Insert Lane Data');
4895: END IF;
4896:
4897: Bulk_Insert_Lanes;

Line 4952: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN

4948: ELSE
4949: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Updating Tariff Lanes for ' || l_modified_carriers.COUNT || ' existing carrier(s)');
4950: END IF;
4951:
4952: IF(FTE_BULKLOAD_PKG.g_debug_on)THEN
4953: FOR lt IN 1..l_modified_carriers.COUNT loop
4954: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'carrier ' || lt , l_modified_carriers(lt));
4955: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'start date ' || lt , l_mod_start_dates(lt));
4956: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'end date ' || lt , l_mod_end_dates(lt));

Line 4975: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

4971: tariff_name = p_tariff_name AND
4972: lane_type = 'LTL_' || p_tariff_name || '_' || l_load_number AND
4973: carrier_id = l_modified_carriers(n);
4974:
4975: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
4976: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Update Tariff Carriers Table');
4977: END IF;
4978:
4979: --+

Line 5076: IF( FTE_BULKLOAD_PKG.g_debug_on ) THEN

5072: x_status := -1;
5073:
5074: FND_PROFILE.GET('FTE_BULKLOAD_SOURCE_TYPE', l_source);
5075:
5076: IF( FTE_BULKLOAD_PKG.g_debug_on ) THEN
5077: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Phase ' || x_phase);
5078: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Reading from ' || l_source);
5079: END IF;
5080:

Line 5121: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

5117: p_line_number => 0);
5118: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5119: RETURN;
5120: ELSE
5121: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
5122: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Fetched ' || l_carrier_ids.COUNT || ' carrier(s) to ' || p_action_code);
5123: END IF;
5124: END IF;
5125:

Line 5134: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

5130: p_expiry_dates => l_expiry_dates,
5131: x_status => x_status,
5132: x_error_msg => x_error_msg);
5133:
5134: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
5135: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Returned from LOAD_TEMP_TABLES with status ', x_status);
5136: END IF;
5137: ELSE
5138: -- Error while reading file.

Line 5220: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN

5216: G_SERVICE_CODE := p_service_code;
5217:
5218: g_report_header.StartDate := to_char(sysdate, 'Dy MM/DD/YYYY HH24:MI:SS');
5219:
5220: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
5221: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_action_code ', p_action_code);
5222: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_service_code', p_service_code);
5223: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_tariff_name ', p_tariff_name);
5224: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_uom_code ', p_uom_code);

Line 5367: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5363: -- Clean up the tables if we failed, or after the whole process is complete.
5364: --+
5365: IF (l_phase = 2 OR x_status <> -1) THEN
5366:
5367: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5368: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Finished ' || p_action_code || ' with status ' || x_status);
5369: END IF;
5370:
5371: CLEANUP_TABLES(p_load_id => p_load_id,

Line 5389: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5385:
5386: retcode := 0;
5387: errbuf := 'Completed phase ' || l_phase || ' successfully!' || errbuf;
5388:
5389: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5390: FTE_UTIL_PKG.Write_LogFile(l_module_name, errbuf);
5391: END IF;
5392:
5393: COMMIT;

Line 5431: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5427:
5428: ELSE
5429: retcode := 2;
5430: errbuf := 'Completed with errors. ' || errbuf || '. Please check logs for more details.';
5431: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5432: FTE_UTIL_PKG.Write_LogFile(l_module_name, errbuf);
5433: END IF;
5434: END IF;
5435:

Line 5505: FTE_BULKLOAD_PKG.g_debug_on := TRUE;

5501:
5502: FTE_UTIL_PKG.Enter_Debug(l_module_name);
5503:
5504: IF (p_user_debug = 1) THEN
5505: FTE_BULKLOAD_PKG.g_debug_on := TRUE;
5506: END IF;
5507:
5508: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5509: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'QP SUB PROCESS FOR Load ID, p_load_id', p_load_id);

Line 5508: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5504: IF (p_user_debug = 1) THEN
5505: FTE_BULKLOAD_PKG.g_debug_on := TRUE;
5506: END IF;
5507:
5508: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5509: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'QP SUB PROCESS FOR Load ID, p_load_id', p_load_id);
5510: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'p_group_process_id ', p_group_process_id);
5511: END IF;
5512:

Line 5515: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5511: END IF;
5512:
5513: OPEN GET_PROCESS_ID;
5514:
5515: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5516: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Number of Rate Charts is ' || get_process_id%ROWCOUNT);
5517: END IF;
5518:
5519: LOOP

Line 5525: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN

5521: EXIT WHEN get_process_id%NOTFOUND;
5522:
5523: IF (x_status <> -1) THEN
5524:
5525: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
5526: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'QP ERROR ' || x_error_msg);
5527: END IF;
5528:
5529: l_temp:= FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');