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_RATE_CHART_PKG

Line 148: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,

144: p_attr_value_to IN VARCHAR2,
145: p_line_number IN VARCHAR2,
146: p_context IN VARCHAR2,
147: p_comp_operator IN VARCHAR2,
148: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,
149: x_status OUT NOCOPY NUMBER,
150: x_error_msg OUT NOCOPY VARCHAR2) IS
151:
152: l_pricing_attr_datatype VARCHAR2(30);

Line 189: IF (p_pricing_attribute = 'CONTAINER_TYPE' AND FTE_RATE_CHART_PKG.g_chart_type = 'FTE_RATE_CHART') THEN

185: IF (p_pricing_attribute = 'COMMODITY_TYPE') OR (p_pricing_attribute = 'COMMODITY') THEN
186: l_pricing_attribute := 'COMMODITY';
187: END IF;
188:
189: IF (p_pricing_attribute = 'CONTAINER_TYPE' AND FTE_RATE_CHART_PKG.g_chart_type = 'FTE_RATE_CHART') THEN
190: l_pricing_attribute := 'CONTAINER_TYPE';
191: END IF;
192:
193: IF (p_pricing_attribute = 'VEHICLE') THEN

Line 220: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

216: END IF;
217:
218: l_count := p_qp_pricing_attrib_tbl.COUNT+1;
219:
220: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
221: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := FTE_RATE_CHART_PKG.G_Product_UOM;
222: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTRIBUTE_DATATYPE := l_pricing_attr_datatype;
223: p_qp_pricing_attrib_tbl(l_count).ATTRIBUTE_GROUPING_NO := 1;
224: p_qp_pricing_attrib_tbl(l_count).LIST_LINE_NO := p_line_number;

Line 221: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := FTE_RATE_CHART_PKG.G_Product_UOM;

217:
218: l_count := p_qp_pricing_attrib_tbl.COUNT+1;
219:
220: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
221: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := FTE_RATE_CHART_PKG.G_Product_UOM;
222: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTRIBUTE_DATATYPE := l_pricing_attr_datatype;
223: p_qp_pricing_attrib_tbl(l_count).ATTRIBUTE_GROUPING_NO := 1;
224: p_qp_pricing_attrib_tbl(l_count).LIST_LINE_NO := p_line_number;
225: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTRIBUTE := l_pricing_attribute;

Line 1058: l_result := FTE_RATE_CHART_PKG.GET_PRICELIST_ID(p_name => p_price_prefix || p_array(i),

1054:
1055: FOR i IN 1..p_service_count LOOP
1056: -- Search for Pricelist_id
1057: IF (p_array(i) IS NOT NULL) THEN
1058: l_result := FTE_RATE_CHART_PKG.GET_PRICELIST_ID(p_name => p_price_prefix || p_array(i),
1059: p_carrier_id => p_carrier_id,
1060: p_attribute1 => l_temp);
1061:
1062: IF (l_result = -1) THEN

Line 2278: l_rate_chart_info := FTE_RATE_CHART_PKG.GET_RATE_CHART_INFO(p_name => l_rate_chart_name,

2274: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
2275: x_status := 1;
2276: RETURN;
2277: END IF;
2278: l_rate_chart_info := FTE_RATE_CHART_PKG.GET_RATE_CHART_INFO(p_name => l_rate_chart_name,
2279: p_carrier_id => p_lane_tbl(p_lane_tbl.COUNT).carrier_id,
2280: x_status => x_status,
2281: x_error_msg => x_error_msg);
2282: IF (x_status <> -1) THEN

Line 4672: p_qp_list_header_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_header_tbl,

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,
4673: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,
4674: p_action OUT NOCOPY VARCHAR2,
4675: p_carrier_id OUT NOCOPY NUMBER,
4676: x_status OUT NOCOPY NUMBER,

Line 4673: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_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,
4673: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,
4674: p_action OUT NOCOPY VARCHAR2,
4675: p_carrier_id OUT NOCOPY NUMBER,
4676: x_status OUT NOCOPY NUMBER,
4677: x_error_msg OUT NOCOPY VARCHAR2) IS

Line 4702: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;

4698: l_temp VARCHAR2(50);
4699: l_tokens STRINGARRAY:=STRINGARRAY();
4700: l_list_type_code VARCHAR2(10);
4701: l_count NUMBER;
4702: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
4703:
4704: BEGIN
4705: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
4706:

Line 4739: FTE_RATE_CHART_PKG.g_is_LTL := TRUE;

4735: l_name := FTE_UTIL_PKG.Get_Data('LTL_RATE_CHART_NAME', p_values);
4736: IF (l_name IS NOT NULL) THEN
4737: l_chart_type := 'FTE_RATE_CHART';
4738: l_list_type_code := 'PRL';
4739: FTE_RATE_CHART_PKG.g_is_LTL := TRUE;
4740: END IF;
4741: END IF;
4742:
4743: IF (l_name IS NULL) THEN

Line 4884: l_list_header_id := FTE_RATE_CHART_PKG.Get_Pricelist_Id(p_name => l_name,

4880:
4881: END IF; --End Validating Carrier.
4882: END IF;
4883:
4884: l_list_header_id := FTE_RATE_CHART_PKG.Get_Pricelist_Id(p_name => l_name,
4885: p_carrier_id => p_carrier_id,
4886: p_attribute1 => l_temp);
4887:
4888: -- Validate Price List and Check if the Pricelist is assigned to any Lane for DELETE

Line 5031: FTE_RATE_CHART_PKG.LH_NEW_RC(FTE_RATE_CHART_PKG.lh_new_rc.COUNT + 1) := l_name;

5027: FROM qp_list_headers_tl
5028: WHERE name = l_replaced_rc
5029: AND language = userenv('LANG');
5030:
5031: FTE_RATE_CHART_PKG.LH_NEW_RC(FTE_RATE_CHART_PKG.lh_new_rc.COUNT + 1) := l_name;
5032: FTE_RATE_CHART_PKG.LH_REPLACE_RC(FTE_RATE_CHART_PKG.lh_replace_rc.COUNT + 1) := l_old_rc_id;
5033:
5034: EXCEPTION
5035: WHEN NO_DATA_FOUND THEN

Line 5032: FTE_RATE_CHART_PKG.LH_REPLACE_RC(FTE_RATE_CHART_PKG.lh_replace_rc.COUNT + 1) := l_old_rc_id;

5028: WHERE name = l_replaced_rc
5029: AND language = userenv('LANG');
5030:
5031: FTE_RATE_CHART_PKG.LH_NEW_RC(FTE_RATE_CHART_PKG.lh_new_rc.COUNT + 1) := l_name;
5032: FTE_RATE_CHART_PKG.LH_REPLACE_RC(FTE_RATE_CHART_PKG.lh_replace_rc.COUNT + 1) := l_old_rc_id;
5033:
5034: EXCEPTION
5035: WHEN NO_DATA_FOUND THEN
5036: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_REPLACE_RC_NOT_FOUND',

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 5065: FTE_RATE_CHART_PKG.G_Process_Id := p_process_id;

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:
5068: IF (p_action = 'DELETE') THEN
5069: l_count := p_qp_list_header_tbl.COUNT+1;

Line 5090: p_qp_list_header_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

5086: -- Inserting insertdata into QP_INTERFACE_LIST_HEADERS
5087:
5088: l_count := p_qp_list_header_tbl.COUNT+1;
5089:
5090: p_qp_list_header_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
5091: p_qp_list_header_tbl(l_count).INTERFACE_ACTION_CODE := l_intAction;
5092: p_qp_list_header_tbl(l_count).START_DATE_ACTIVE := l_start_date;
5093: p_qp_list_header_tbl(l_count).LIST_TYPE_CODE := l_list_type_code;
5094: p_qp_list_header_tbl(l_count).END_DATE_ACTIVE := l_end_date;

Line 5113: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

5109: AND l_chart_type NOT IN ('FAC_RATE_CHART', 'FAC_MODIFIER', 'MIN_MODIFIER')) THEN
5110:
5111: l_count := p_qp_qualifier_tbl.COUNT+1;
5112:
5113: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
5114: p_qp_qualifier_tbl(l_count).INTERFACE_ACTION_CODE := l_intAction;
5115: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTR_VALUE := p_carrier_id;
5116: p_qp_qualifier_tbl(l_count).QUALIFIER_GROUPING_NO := l_qualifier_group;
5117: p_qp_qualifier_tbl(l_count).QUALIFIER_CONTEXT := 'PARTY';

Line 5127: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

5123: IF (p_action = 'ADD' AND l_chart_type IN ('TL_RATE_CHART', 'TL_MODIFIER')) THEN
5124: --Service_Type
5125: l_count := p_qp_qualifier_tbl.COUNT+1;
5126:
5127: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
5128: p_qp_qualifier_tbl(l_count).INTERFACE_ACTION_CODE := l_intAction;
5129: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTRIBUTE := 'SERVICE_TYPE';
5130: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTR_VALUE := l_service_level;
5131: p_qp_qualifier_tbl(l_count).QUALIFIER_GROUPING_NO := l_qualifier_group;

Line 5137: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

5133:
5134: --Mode_Of_Transport
5135: l_count := p_qp_qualifier_tbl.COUNT+1;
5136:
5137: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
5138: p_qp_qualifier_tbl(l_count).INTERFACE_ACTION_CODE := l_intAction;
5139: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTRIBUTE := 'MODE_OF_TRANSPORTATION';
5140: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTR_VALUE := 'TRUCK';
5141: p_qp_qualifier_tbl(l_count).QUALIFIER_GROUPING_NO := l_qualifier_group;

Line 5147: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;

5143: END IF;
5144: END IF;
5145: END IF;
5146:
5147: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
5148:
5149: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5150:
5151: EXCEPTION

Line 5183: p_qp_list_line_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_line_tbl,

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,
5185: x_status OUT NOCOPY NUMBER,
5186: x_error_msg OUT NOCOPY VARCHAR2) IS
5187:

Line 5184: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,

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,
5185: x_status OUT NOCOPY NUMBER,
5186: x_error_msg OUT NOCOPY VARCHAR2) IS
5187:
5188: l_intAction VARCHAR2(30);

Line 5226: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;

5222: l_type VARCHAR2(30);
5223: l_subtype VARCHAR2(30);
5224:
5225: l_attribute1 VARCHAR2(100);
5226: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
5227: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_RATE_LINE';
5228: l_count NUMBER;
5229:
5230: BEGIN

Line 5234: FTE_RATE_CHART_PKG.G_previous_upper := 0;

5230: BEGIN
5231: FTE_UTIL_PKG.ENTER_Debug(l_module_name);
5232:
5233: --reset the upper value used for parcel LTL breaks.
5234: FTE_RATE_CHART_PKG.G_previous_upper := 0;
5235:
5236: l_list_header_id := -1;
5237: x_status := -1;
5238:

Line 5396: FTE_RATE_CHART_PKG.G_line_number := l_linenum;

5392: RETURN;
5393: END IF;
5394: END IF;
5395:
5396: FTE_RATE_CHART_PKG.G_line_number := l_linenum;
5397:
5398: IF (l_precedence IS NULL) THEN
5399: l_precedence := 220;
5400: END IF;

Line 5596: FTE_RATE_CHART_PKG.G_Prc_Brk_Type := l_break_type;

5592: RETURN;
5593: END IF;
5594: END IF; --end validation of specific Attributes.
5595:
5596: FTE_RATE_CHART_PKG.G_Prc_Brk_Type := l_break_type;
5597: FTE_RATE_CHART_PKG.G_Prc_Rate_Type := l_rate_type;
5598: FTE_RATE_CHART_PKG.G_Prc_Vol_Type := l_volume_type;
5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;
5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;

Line 5597: FTE_RATE_CHART_PKG.G_Prc_Rate_Type := l_rate_type;

5593: END IF;
5594: END IF; --end validation of specific Attributes.
5595:
5596: FTE_RATE_CHART_PKG.G_Prc_Brk_Type := l_break_type;
5597: FTE_RATE_CHART_PKG.G_Prc_Rate_Type := l_rate_type;
5598: FTE_RATE_CHART_PKG.G_Prc_Vol_Type := l_volume_type;
5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;
5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;
5601:

Line 5598: FTE_RATE_CHART_PKG.G_Prc_Vol_Type := l_volume_type;

5594: END IF; --end validation of specific Attributes.
5595:
5596: FTE_RATE_CHART_PKG.G_Prc_Brk_Type := l_break_type;
5597: FTE_RATE_CHART_PKG.G_Prc_Rate_Type := l_rate_type;
5598: FTE_RATE_CHART_PKG.G_Prc_Vol_Type := l_volume_type;
5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;
5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;
5601:
5602: --Save the current line number, so we can associate with breaks, if there are any.

Line 5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;

5595:
5596: FTE_RATE_CHART_PKG.G_Prc_Brk_Type := l_break_type;
5597: FTE_RATE_CHART_PKG.G_Prc_Rate_Type := l_rate_type;
5598: FTE_RATE_CHART_PKG.G_Prc_Vol_Type := l_volume_type;
5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;
5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;
5601:
5602: --Save the current line number, so we can associate with breaks, if there are any.
5603: FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index := l_linenum;

Line 5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;

5596: FTE_RATE_CHART_PKG.G_Prc_Brk_Type := l_break_type;
5597: FTE_RATE_CHART_PKG.G_Prc_Rate_Type := l_rate_type;
5598: FTE_RATE_CHART_PKG.G_Prc_Vol_Type := l_volume_type;
5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;
5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;
5601:
5602: --Save the current line number, so we can associate with breaks, if there are any.
5603: FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index := l_linenum;
5604:

Line 5603: FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index := l_linenum;

5599: FTE_RATE_CHART_PKG.G_Prc_Line_Desc := l_description;
5600: FTE_RATE_CHART_PKG.G_Product_UOM := l_uom_code;
5601:
5602: --Save the current line number, so we can associate with breaks, if there are any.
5603: FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index := l_linenum;
5604:
5605: IF (l_action IN ('ADD', 'UPDATE')) THEN
5606: -- Insert into QP_INTERFACE_LIST_LINES
5607: l_count := p_qp_list_line_tbl.COUNT+1;

Line 5618: p_qp_list_line_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

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;
5619: p_qp_list_line_tbl(l_count).OPERAND := fnd_number.canonical_to_number(l_operamt);
5620: p_qp_list_line_tbl(l_count).COMMENTS := l_description;
5621: p_qp_list_line_tbl(l_count).LIST_LINE_NO := l_linenum;
5622: p_qp_list_line_tbl(l_count).PROCESS_TYPE := 'SSH';

Line 5649: FTE_RATE_CHART_PKG.G_Cur_Line_Index := l_count;

5645: p_qp_list_line_tbl(l_count).END_DATE_ACTIVE := l_end_date;
5646:
5647: --Save the current index into p_qp_list_line_tbl, so we can
5648: --update list_type_code to 'PBH' in case of breaks.
5649: FTE_RATE_CHART_PKG.G_Cur_Line_Index := l_count;
5650:
5651: IF (l_chart_type = 'FTE_RATE_CHART') THEN
5652: --rate chart
5653: p_qp_list_line_tbl(l_count).PRIMARY_UOM_FLAG := 'Y';

Line 5696: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

5692: --insert into QP_INTERFACE_PRICING_ATTRIBS
5693: l_product_attribute := 'PRICING_ATTRIBUTE3';
5694:
5695: l_count := p_qp_pricing_attrib_tbl.COUNT+1;
5696: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
5697: p_qp_pricing_attrib_tbl(l_count).PRODUCT_ATTRIBUTE := l_product_attribute;
5698: p_qp_pricing_attrib_tbl(l_count).PRODUCT_ATTR_VALUE := l_item;
5699: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := l_uom_code;
5700: p_qp_pricing_attrib_tbl(l_count).ATTRIBUTE_GROUPING_NO := l_group;

Line 5716: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;

5712: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTR_VALUE_TO := l_attr_value_to;
5713:
5714: END IF;
5715:
5716: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
5717:
5718: FTE_UTIL_PKG.Exit_Debug(l_module_name);
5719: EXCEPTION
5720: WHEN OTHERS THEN

Line 5751: p_qp_list_line_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_list_line_tbl,

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,
5753: x_status OUT NOCOPY NUMBER,
5754: x_error_msg OUT NOCOPY VARCHAR2) IS
5755:

Line 5752: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,

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,
5753: x_status OUT NOCOPY NUMBER,
5754: x_error_msg OUT NOCOPY VARCHAR2) IS
5755:
5756: l_group NUMBER;

Line 5792: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;

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

Line 5869: l_rate_type := FTE_RATE_CHART_PKG.G_Prc_Rate_Type;

5865: END IF;
5866:
5867: --Inherit line level rate type if not specified at the break level.
5868: IF (l_rate_type IS NULL) THEN
5869: l_rate_type := FTE_RATE_CHART_PKG.G_Prc_Rate_Type;
5870:
5871: -- if both line rate type and break line rate type are null, then error
5872: IF (l_rate_type IS NULL) THEN
5873: x_error_msg := Fte_Util_PKG.Get_Msg(p_name => 'FTE_RATE_TYPE_INVALID',

Line 5924: IF (FTE_RATE_CHART_PKG.G_previous_upper = 0 OR FTE_RATE_CHART_PKG.G_previous_upper IS NULL) THEN

5920: RETURN;
5921: ELSE
5922: IF (l_attr_value_from IS NULL) THEN
5923: -- set break_from
5924: IF (FTE_RATE_CHART_PKG.G_previous_upper = 0 OR FTE_RATE_CHART_PKG.G_previous_upper IS NULL) THEN
5925: l_attr_value_from := 0; --continuous break start with 0
5926: ELSE
5927: l_low_val := FTE_RATE_CHART_PKG.G_previous_upper;
5928: l_attr_value_from := l_low_val;

Line 5927: l_low_val := FTE_RATE_CHART_PKG.G_previous_upper;

5923: -- set break_from
5924: IF (FTE_RATE_CHART_PKG.G_previous_upper = 0 OR FTE_RATE_CHART_PKG.G_previous_upper IS NULL) THEN
5925: l_attr_value_from := 0; --continuous break start with 0
5926: ELSE
5927: l_low_val := FTE_RATE_CHART_PKG.G_previous_upper;
5928: l_attr_value_from := l_low_val;
5929: END IF;
5930: END IF;
5931: -- check if UPPER_LIMIT is greater than or equal to LOWER_LIMIT

Line 5952: FTE_RATE_CHART_PKG.G_previous_upper := l_tmp_d;

5948: RETURN;
5949: END IF;
5950:
5951: l_tmp_d := l_attr_value_to;
5952: FTE_RATE_CHART_PKG.G_previous_upper := l_tmp_d;
5953: END IF;
5954:
5955: IF (l_break_price IS NULL) THEN
5956: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_CAT_RATE_MISSING');

Line 5966: IF (FTE_RATE_CHART_PKG.G_Prc_Brk_Type IS NULL) THEN

5962: x_status := 2;
5963: RETURN;
5964: END IF;
5965:
5966: IF (FTE_RATE_CHART_PKG.G_Prc_Brk_Type IS NULL) THEN
5967: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_RATE_BREAK_TYPE_MISSING');
5968: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5969: p_msg => x_error_msg,
5970: p_category => 'A',

Line 5977: IF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type IS NULL) THEN

5973: x_status := 2;
5974: RETURN;
5975: END IF;
5976:
5977: IF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type IS NULL) THEN
5978: x_error_msg := FTE_UTIL_PKG.GET_MSG('FTE_VOLUME_TYPE_MISSING');
5979: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
5980: p_msg => x_error_msg,
5981: p_category => 'A',

Line 5993: IF (FTE_RATE_CHART_PKG.G_IS_LTL) THEN

5989: IF (l_context IS NULL) THEN
5990: l_context := 'VOLUME';
5991: END IF;
5992:
5993: IF (FTE_RATE_CHART_PKG.G_IS_LTL) THEN
5994: l_attribute2 := l_break_price*100;
5995: END IF;
5996:
5997: IF (l_action IN ('ADD', 'UPDATE')) THEN

Line 6002: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).LIST_LINE_TYPE_CODE := 'PBH';

5998:
5999: --Update this break's header line with the code 'PBH'
6000: l_count := p_qp_list_line_tbl.COUNT;
6001:
6002: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).LIST_LINE_TYPE_CODE := 'PBH';
6003: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.g_prc_brk_type;
6004:
6005: l_count := p_qp_list_line_tbl.COUNT+1;
6006:

Line 6003: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.g_prc_brk_type;

5999: --Update this break's header line with the code 'PBH'
6000: l_count := p_qp_list_line_tbl.COUNT;
6001:
6002: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).LIST_LINE_TYPE_CODE := 'PBH';
6003: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.g_prc_brk_type;
6004:
6005: l_count := p_qp_list_line_tbl.COUNT+1;
6006:
6007: p_qp_list_line_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

Line 6007: p_qp_list_line_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

6003: p_qp_list_line_tbl(FTE_RATE_CHART_PKG.g_cur_line_index).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.g_prc_brk_type;
6004:
6005: l_count := p_qp_list_line_tbl.COUNT+1;
6006:
6007: p_qp_list_line_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
6008: p_qp_list_line_tbl(l_count).OPERAND := l_break_price;
6009:
6010: p_qp_list_line_tbl(l_count).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.G_Prc_Brk_Type;
6011: p_qp_list_line_tbl(l_count).PRODUCT_PRECEDENCE := l_precedence;

Line 6010: p_qp_list_line_tbl(l_count).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.G_Prc_Brk_Type;

6006:
6007: p_qp_list_line_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
6008: p_qp_list_line_tbl(l_count).OPERAND := l_break_price;
6009:
6010: p_qp_list_line_tbl(l_count).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.G_Prc_Brk_Type;
6011: p_qp_list_line_tbl(l_count).PRODUCT_PRECEDENCE := l_precedence;
6012: p_qp_list_line_tbl(l_count).COMMENTS := FTE_RATE_CHART_PKG.G_Prc_Line_Desc;
6013: p_qp_list_line_tbl(l_count).LIST_LINE_NO := l_linenum;
6014: p_qp_list_line_tbl(l_count).PRICE_BREAK_HEADER_INDEX := FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index;

Line 6012: p_qp_list_line_tbl(l_count).COMMENTS := FTE_RATE_CHART_PKG.G_Prc_Line_Desc;

6008: p_qp_list_line_tbl(l_count).OPERAND := l_break_price;
6009:
6010: p_qp_list_line_tbl(l_count).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.G_Prc_Brk_Type;
6011: p_qp_list_line_tbl(l_count).PRODUCT_PRECEDENCE := l_precedence;
6012: p_qp_list_line_tbl(l_count).COMMENTS := FTE_RATE_CHART_PKG.G_Prc_Line_Desc;
6013: p_qp_list_line_tbl(l_count).LIST_LINE_NO := l_linenum;
6014: p_qp_list_line_tbl(l_count).PRICE_BREAK_HEADER_INDEX := FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index;
6015: p_qp_list_line_tbl(l_count).RLTD_MODIFIER_GRP_NO := FTE_RATE_CHART_PKG.G_Mod_Grp;
6016: p_qp_list_line_tbl(l_count).ATTRIBUTE2 := l_attribute2;

Line 6014: p_qp_list_line_tbl(l_count).PRICE_BREAK_HEADER_INDEX := FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index;

6010: p_qp_list_line_tbl(l_count).PRICE_BREAK_TYPE_CODE := FTE_RATE_CHART_PKG.G_Prc_Brk_Type;
6011: p_qp_list_line_tbl(l_count).PRODUCT_PRECEDENCE := l_precedence;
6012: p_qp_list_line_tbl(l_count).COMMENTS := FTE_RATE_CHART_PKG.G_Prc_Line_Desc;
6013: p_qp_list_line_tbl(l_count).LIST_LINE_NO := l_linenum;
6014: p_qp_list_line_tbl(l_count).PRICE_BREAK_HEADER_INDEX := FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index;
6015: p_qp_list_line_tbl(l_count).RLTD_MODIFIER_GRP_NO := FTE_RATE_CHART_PKG.G_Mod_Grp;
6016: p_qp_list_line_tbl(l_count).ATTRIBUTE2 := l_attribute2;
6017: p_qp_list_line_tbl(l_count).ARITHMETIC_OPERATOR := l_operator;
6018:

Line 6015: p_qp_list_line_tbl(l_count).RLTD_MODIFIER_GRP_NO := FTE_RATE_CHART_PKG.G_Mod_Grp;

6011: p_qp_list_line_tbl(l_count).PRODUCT_PRECEDENCE := l_precedence;
6012: p_qp_list_line_tbl(l_count).COMMENTS := FTE_RATE_CHART_PKG.G_Prc_Line_Desc;
6013: p_qp_list_line_tbl(l_count).LIST_LINE_NO := l_linenum;
6014: p_qp_list_line_tbl(l_count).PRICE_BREAK_HEADER_INDEX := FTE_RATE_CHART_PKG.G_Prc_Brk_Hdr_Index;
6015: p_qp_list_line_tbl(l_count).RLTD_MODIFIER_GRP_NO := FTE_RATE_CHART_PKG.G_Mod_Grp;
6016: p_qp_list_line_tbl(l_count).ATTRIBUTE2 := l_attribute2;
6017: p_qp_list_line_tbl(l_count).ARITHMETIC_OPERATOR := l_operator;
6018:
6019: p_qp_list_line_tbl(l_count).PROCESS_TYPE := 'SSH';

Line 6038: FTE_RATE_CHART_PKG.G_Mod_Grp := FTE_RATE_CHART_PKG.G_Mod_Grp + 1;

6034:
6035: p_qp_list_line_tbl(l_count).RLTD_MODIFIER_GRP_TYPE := 'PRICE BREAK';
6036: p_qp_list_line_tbl(l_count).PRIMARY_UOM_FLAG := NULL;
6037:
6038: FTE_RATE_CHART_PKG.G_Mod_Grp := FTE_RATE_CHART_PKG.G_Mod_Grp + 1;
6039:
6040: l_product_attribute := 'PRICING_ATTRIBUTE3';
6041:
6042: IF (l_pricing_attribute IS NULL) THEN

Line 6043: IF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type = 'QUANTITY') THEN

6039:
6040: l_product_attribute := 'PRICING_ATTRIBUTE3';
6041:
6042: IF (l_pricing_attribute IS NULL) THEN
6043: IF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type = 'QUANTITY') THEN
6044: l_pricing_attribute := 'ITEM_QUANTITY';
6045: ELSIF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type = 'TOTAL_QUANTITY') THEN
6046: l_pricing_attribute := 'TOTAL_ITEM_QUANTITY';
6047: END IF;

Line 6045: ELSIF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type = 'TOTAL_QUANTITY') THEN

6041:
6042: IF (l_pricing_attribute IS NULL) THEN
6043: IF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type = 'QUANTITY') THEN
6044: l_pricing_attribute := 'ITEM_QUANTITY';
6045: ELSIF (FTE_RATE_CHART_PKG.G_Prc_Vol_Type = 'TOTAL_QUANTITY') THEN
6046: l_pricing_attribute := 'TOTAL_ITEM_QUANTITY';
6047: END IF;
6048: END IF;
6049:

Line 6061: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

6057: l_group := 1;
6058:
6059: l_count := p_qp_pricing_attrib_tbl.COUNT+1;
6060:
6061: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
6062: p_qp_pricing_attrib_tbl(l_count).PRODUCT_ATTRIBUTE := l_product_attribute;
6063: p_qp_pricing_attrib_tbl(l_count).PRODUCT_ATTR_VALUE := l_item;
6064: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := FTE_RATE_CHART_PKG.G_Product_UOM;
6065: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTRIBUTE := l_pricing_attribute;

Line 6064: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := FTE_RATE_CHART_PKG.G_Product_UOM;

6060:
6061: p_qp_pricing_attrib_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
6062: p_qp_pricing_attrib_tbl(l_count).PRODUCT_ATTRIBUTE := l_product_attribute;
6063: p_qp_pricing_attrib_tbl(l_count).PRODUCT_ATTR_VALUE := l_item;
6064: p_qp_pricing_attrib_tbl(l_count).PRODUCT_UOM_CODE := FTE_RATE_CHART_PKG.G_Product_UOM;
6065: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTRIBUTE := l_pricing_attribute;
6066: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTR_VALUE_FROM := fnd_number.number_to_canonical(l_attr_value_from);
6067: p_qp_pricing_attrib_tbl(l_count).PRICING_ATTR_VALUE_TO := fnd_number.number_to_canonical(l_attr_value_to);
6068: p_qp_pricing_attrib_tbl(l_count).ATTRIBUTE_GROUPING_NO := l_group;

Line 6082: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;

6078: p_qp_pricing_attrib_tbl(l_count).COMPARISON_OPERATOR_CODE := l_comp_operator;
6079:
6080: END IF;
6081:
6082: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
6083:
6084: FTE_UTIL_PKG.Exit_Debug(l_module_name);
6085: EXCEPTION
6086: WHEN OTHERS THEN

Line 6114: p_qp_pricing_attrib_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_pricing_attrib_tbl,

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
6117:
6118: l_intAction VARCHAR2(30);

Line 6139: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;

6135: l_catg_id NUMBER;
6136: l_attr_code VARCHAR2(50);
6137:
6138: l_zone_id NUMBER;
6139: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
6140:
6141: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_RATING_ATTRIBUTE';
6142:
6143: BEGIN

Line 6274: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN

6270: --G_region_info until we are sure we have all the information.
6271: IF (SUBSTR(l_pricing_attribute, 1, 6) = 'ORIGIN' AND
6272: l_pricing_attribute NOT IN ('ORIGIN_ZONE', 'ORIGIN_ZONE_ID')) THEN --(1)
6273:
6274: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN
6275: FTE_RATE_CHART_PKG.Reset_Region_Info;
6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6278:

Line 6275: FTE_RATE_CHART_PKG.Reset_Region_Info;

6271: IF (SUBSTR(l_pricing_attribute, 1, 6) = 'ORIGIN' AND
6272: l_pricing_attribute NOT IN ('ORIGIN_ZONE', 'ORIGIN_ZONE_ID')) THEN --(1)
6273:
6274: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN
6275: FTE_RATE_CHART_PKG.Reset_Region_Info;
6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6278:
6279: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN

Line 6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN

6272: l_pricing_attribute NOT IN ('ORIGIN_ZONE', 'ORIGIN_ZONE_ID')) THEN --(1)
6273:
6274: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN
6275: FTE_RATE_CHART_PKG.Reset_Region_Info;
6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6278:
6279: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6280: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',

Line 6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

6273:
6274: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN
6275: FTE_RATE_CHART_PKG.Reset_Region_Info;
6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6278:
6279: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6280: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6281: p_attr_value_from => l_region_id,

Line 6280: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',

6276: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'DESTINATION' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6277: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6278:
6279: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6280: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6281: p_attr_value_from => l_region_id,
6282: p_attr_value_to => NULL,
6283: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,
6284: p_context => l_context,

Line 6283: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,

6279: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6280: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6281: p_attr_value_from => l_region_id,
6282: p_attr_value_to => NULL,
6283: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,
6284: p_context => l_context,
6285: p_comp_operator => NULL,
6286: p_qp_pricing_attrib_tbl => p_qp_pricing_attrib_tbl,
6287: x_status => x_status,

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

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

Line 6293: FTE_RATE_CHART_PKG.g_region_info.state ||' '||

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

Line 6294: FTE_RATE_CHART_PKG.g_region_info.city));

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

Line 6300: FTE_RATE_CHART_PKG.Reset_Region_Info;

6296: p_msg => x_error_msg,
6297: p_category => 'D',
6298: p_line_number => p_line_number);
6299:
6300: FTE_RATE_CHART_PKG.Reset_Region_Info;
6301: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
6302: x_status := 2;
6303: RETURN;
6304: END IF;

Line 6305: FTE_RATE_CHART_PKG.Reset_Region_Info;

6301: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
6302: x_status := 2;
6303: RETURN;
6304: END IF;
6305: FTE_RATE_CHART_PKG.Reset_Region_Info;
6306: END IF;
6307:
6308: IF (l_pricing_attribute = 'ORIGIN_COUNTRY') THEN
6309: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;

Line 6309: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;

6305: FTE_RATE_CHART_PKG.Reset_Region_Info;
6306: END IF;
6307:
6308: IF (l_pricing_attribute = 'ORIGIN_COUNTRY') THEN
6309: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;
6310: ELSIF (l_pricing_attribute = 'ORIGIN_STATE') THEN
6311: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6312: ELSIF (l_pricing_attribute = 'ORIGIN_CITY') THEN
6313: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;

Line 6311: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;

6307:
6308: IF (l_pricing_attribute = 'ORIGIN_COUNTRY') THEN
6309: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;
6310: ELSIF (l_pricing_attribute = 'ORIGIN_STATE') THEN
6311: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6312: ELSIF (l_pricing_attribute = 'ORIGIN_CITY') THEN
6313: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6314: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_FROM') THEN
6315: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;

Line 6313: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;

6309: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;
6310: ELSIF (l_pricing_attribute = 'ORIGIN_STATE') THEN
6311: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6312: ELSIF (l_pricing_attribute = 'ORIGIN_CITY') THEN
6313: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6314: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_FROM') THEN
6315: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6316: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_TO') THEN
6317: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;

Line 6315: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;

6311: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6312: ELSIF (l_pricing_attribute = 'ORIGIN_CITY') THEN
6313: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6314: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_FROM') THEN
6315: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6316: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_TO') THEN
6317: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6318: END IF;
6319: FTE_RATE_CHART_PKG.g_region_flag := 'ORIGIN';

Line 6317: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;

6313: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6314: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_FROM') THEN
6315: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6316: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_TO') THEN
6317: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6318: END IF;
6319: FTE_RATE_CHART_PKG.g_region_flag := 'ORIGIN';
6320: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;
6321:

Line 6319: FTE_RATE_CHART_PKG.g_region_flag := 'ORIGIN';

6315: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6316: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_TO') THEN
6317: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6318: END IF;
6319: FTE_RATE_CHART_PKG.g_region_flag := 'ORIGIN';
6320: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;
6321:
6322: ELSIF (substr(l_pricing_attribute,1,11) = 'DESTINATION' AND
6323: l_pricing_attribute NOT IN ('DESTINATION_ZONE', 'DESTINATION_ZONE_ID')) THEN --(1)

Line 6320: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;

6316: ELSIF (l_pricing_attribute = 'ORIGIN_POSTAL_CODE_TO') THEN
6317: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6318: END IF;
6319: FTE_RATE_CHART_PKG.g_region_flag := 'ORIGIN';
6320: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;
6321:
6322: ELSIF (substr(l_pricing_attribute,1,11) = 'DESTINATION' AND
6323: l_pricing_attribute NOT IN ('DESTINATION_ZONE', 'DESTINATION_ZONE_ID')) THEN --(1)
6324:

Line 6325: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN -- start of New DESTINATION

6321:
6322: ELSIF (substr(l_pricing_attribute,1,11) = 'DESTINATION' AND
6323: l_pricing_attribute NOT IN ('DESTINATION_ZONE', 'DESTINATION_ZONE_ID')) THEN --(1)
6324:
6325: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN -- start of New DESTINATION
6326: FTE_RATE_CHART_PKG.Reset_Region_Info;
6327: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'ORIGIN' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6328:
6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

Line 6326: FTE_RATE_CHART_PKG.Reset_Region_Info;

6322: ELSIF (substr(l_pricing_attribute,1,11) = 'DESTINATION' AND
6323: l_pricing_attribute NOT IN ('DESTINATION_ZONE', 'DESTINATION_ZONE_ID')) THEN --(1)
6324:
6325: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN -- start of New DESTINATION
6326: FTE_RATE_CHART_PKG.Reset_Region_Info;
6327: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'ORIGIN' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6328:
6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6330:

Line 6327: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'ORIGIN' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN

6323: l_pricing_attribute NOT IN ('DESTINATION_ZONE', 'DESTINATION_ZONE_ID')) THEN --(1)
6324:
6325: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN -- start of New DESTINATION
6326: FTE_RATE_CHART_PKG.Reset_Region_Info;
6327: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'ORIGIN' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6328:
6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6330:
6331: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN

Line 6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

6325: IF (FTE_RATE_CHART_PKG.g_region_flag IS NULL) THEN -- start of New DESTINATION
6326: FTE_RATE_CHART_PKG.Reset_Region_Info;
6327: ELSIF (FTE_RATE_CHART_PKG.g_region_flag = 'ORIGIN' OR FTE_RATE_CHART_PKG.g_region_linenum <> l_linenum) THEN
6328:
6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6330:
6331: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6332: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6333: p_attr_value_from => l_region_id,

Line 6332: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',

6328:
6329: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6330:
6331: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6332: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6333: p_attr_value_from => l_region_id,
6334: p_attr_value_to => NULL,
6335: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,
6336: p_context => l_context,

Line 6335: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,

6331: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6332: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag||'_ZONE',
6333: p_attr_value_from => l_region_id,
6334: p_attr_value_to => NULL,
6335: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,
6336: p_context => l_context,
6337: p_comp_operator => NULL,
6338: p_qp_pricing_attrib_tbl => p_qp_pricing_attrib_tbl,
6339: x_status => x_status,

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

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

Line 6345: FTE_RATE_CHART_PKG.g_region_info.state ||' '||

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

Line 6346: FTE_RATE_CHART_PKG.g_region_info.city));

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

Line 6352: FTE_RATE_CHART_PKG.Reset_Region_Info;

6348: p_msg => x_error_msg,
6349: p_category => 'D',
6350: p_line_number => p_line_number);
6351:
6352: FTE_RATE_CHART_PKG.Reset_Region_Info;
6353: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
6354: x_status := 2;
6355: RETURN;
6356: END IF;

Line 6357: FTE_RATE_CHART_PKG.Reset_Region_Info;

6353: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
6354: x_status := 2;
6355: RETURN;
6356: END IF;
6357: FTE_RATE_CHART_PKG.Reset_Region_Info;
6358: END IF;
6359:
6360: IF (l_pricing_attribute = 'DESTINATION_COUNTRY') THEN
6361: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;

Line 6361: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;

6357: FTE_RATE_CHART_PKG.Reset_Region_Info;
6358: END IF;
6359:
6360: IF (l_pricing_attribute = 'DESTINATION_COUNTRY') THEN
6361: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;
6362: ELSIF (l_pricing_attribute = 'DESTINATION_STATE') THEN
6363: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6364: ELSIF (l_pricing_attribute = 'DESTINATION_CITY') THEN
6365: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;

Line 6363: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;

6359:
6360: IF (l_pricing_attribute = 'DESTINATION_COUNTRY') THEN
6361: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;
6362: ELSIF (l_pricing_attribute = 'DESTINATION_STATE') THEN
6363: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6364: ELSIF (l_pricing_attribute = 'DESTINATION_CITY') THEN
6365: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6366: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_FROM') THEN
6367: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;

Line 6365: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;

6361: FTE_RATE_CHART_PKG.G_region_info.country := l_pricing_attr_value_from;
6362: ELSIF (l_pricing_attribute = 'DESTINATION_STATE') THEN
6363: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6364: ELSIF (l_pricing_attribute = 'DESTINATION_CITY') THEN
6365: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6366: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_FROM') THEN
6367: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6368: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_TO') THEN
6369: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;

Line 6367: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;

6363: FTE_RATE_CHART_PKG.G_region_info.state := l_pricing_attr_value_from;
6364: ELSIF (l_pricing_attribute = 'DESTINATION_CITY') THEN
6365: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6366: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_FROM') THEN
6367: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6368: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_TO') THEN
6369: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6370: END IF;
6371:

Line 6369: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;

6365: FTE_RATE_CHART_PKG.G_region_info.city := l_pricing_attr_value_from;
6366: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_FROM') THEN
6367: FTE_RATE_CHART_PKG.G_region_info.postal_code_from := l_pricing_attr_value_from;
6368: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_TO') THEN
6369: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6370: END IF;
6371:
6372: FTE_RATE_CHART_PKG.g_region_flag := 'DESTINATION';
6373: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;

Line 6372: FTE_RATE_CHART_PKG.g_region_flag := 'DESTINATION';

6368: ELSIF (l_pricing_attribute = 'DESTINATION_POSTAL_CODE_TO') THEN
6369: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6370: END IF;
6371:
6372: FTE_RATE_CHART_PKG.g_region_flag := 'DESTINATION';
6373: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;
6374: FTE_RATE_CHART_PKG.g_region_context := l_context;
6375: ELSE --(1)
6376: IF (l_pricing_attribute IN ('ORIGIN_ZONE', 'DESTINATION_ZONE')) THEN --(2)

Line 6373: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;

6369: FTE_RATE_CHART_PKG.G_region_info.postal_code_to := l_pricing_attr_value_from;
6370: END IF;
6371:
6372: FTE_RATE_CHART_PKG.g_region_flag := 'DESTINATION';
6373: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;
6374: FTE_RATE_CHART_PKG.g_region_context := l_context;
6375: ELSE --(1)
6376: IF (l_pricing_attribute IN ('ORIGIN_ZONE', 'DESTINATION_ZONE')) THEN --(2)
6377:

Line 6374: FTE_RATE_CHART_PKG.g_region_context := l_context;

6370: END IF;
6371:
6372: FTE_RATE_CHART_PKG.g_region_flag := 'DESTINATION';
6373: FTE_RATE_CHART_PKG.g_region_linenum := l_linenum;
6374: FTE_RATE_CHART_PKG.g_region_context := l_context;
6375: ELSE --(1)
6376: IF (l_pricing_attribute IN ('ORIGIN_ZONE', 'DESTINATION_ZONE')) THEN --(2)
6377:
6378: -- get ZONE_ID from ZONE_NAME

Line 6485: IF (FTE_RATE_CHART_PKG.g_region_flag IS NOT NULL) THEN

6481: ELSIF (l_pricing_attribute = 'TL_NUM_STOPS') THEN
6482: l_pricing_attr_value_from := NULL;
6483: END IF; --end --(2)
6484:
6485: IF (FTE_RATE_CHART_PKG.g_region_flag IS NOT NULL) THEN
6486: -- Insert previous ORIGIN or DESTINATION Region Attribute
6487: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6488:
6489: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN

Line 6487: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);

6483: END IF; --end --(2)
6484:
6485: IF (FTE_RATE_CHART_PKG.g_region_flag IS NOT NULL) THEN
6486: -- Insert previous ORIGIN or DESTINATION Region Attribute
6487: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6488:
6489: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6490: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag ||'_ZONE',
6491: p_attr_value_from => l_region_id,

Line 6490: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag ||'_ZONE',

6486: -- Insert previous ORIGIN or DESTINATION Region Attribute
6487: l_region_id := FTE_REGION_ZONE_LOADER.GET_REGION_ID(p_region_info => FTE_RATE_CHART_PKG.G_region_info);
6488:
6489: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6490: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag ||'_ZONE',
6491: p_attr_value_from => l_region_id,
6492: p_attr_value_to => NULL,
6493: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,
6494: p_context => l_context,

Line 6493: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,

6489: IF (l_region_id IS NOT NULL OR l_region_id <> -1) THEN
6490: ADD_ATTRIBUTE(p_pricing_attribute => FTE_RATE_CHART_PKG.g_region_flag ||'_ZONE',
6491: p_attr_value_from => l_region_id,
6492: p_attr_value_to => NULL,
6493: p_line_number => FTE_RATE_CHART_PKG.g_region_linenum,
6494: p_context => l_context,
6495: p_comp_operator => NULL,
6496: p_qp_pricing_attrib_tbl => p_qp_pricing_attrib_tbl,
6497: x_status => x_status,

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

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

Line 6503: FTE_RATE_CHART_PKG.g_region_info.state ||' '||

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

Line 6504: FTE_RATE_CHART_PKG.g_region_info.city));

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

Line 6510: FTE_RATE_CHART_PKG.Reset_Region_Info;

6506: p_msg => x_error_msg,
6507: p_category => 'D',
6508: p_line_number => p_line_number);
6509:
6510: FTE_RATE_CHART_PKG.Reset_Region_Info;
6511: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
6512: x_status := 2;
6513: RETURN;
6514: END IF;

Line 6518: IF (l_linenum <> FTE_RATE_CHART_PKG.g_line_number) THEN

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

Line 6542: FTE_RATE_CHART_PKG.g_region_flag := NULL;

6538: p_qp_pricing_attrib_tbl => p_qp_pricing_attrib_tbl,
6539: x_status => x_status,
6540: x_error_msg => x_error_msg);
6541:
6542: FTE_RATE_CHART_PKG.g_region_flag := NULL;
6543: FTE_RATE_CHART_PKG.Reset_Region_Info;
6544: END IF; --end --(1)
6545: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
6546:

Line 6543: FTE_RATE_CHART_PKG.Reset_Region_Info;

6539: x_status => x_status,
6540: x_error_msg => x_error_msg);
6541:
6542: FTE_RATE_CHART_PKG.g_region_flag := NULL;
6543: FTE_RATE_CHART_PKG.Reset_Region_Info;
6544: END IF; --end --(1)
6545: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
6546:
6547: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 6545: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;

6541:
6542: FTE_RATE_CHART_PKG.g_region_flag := NULL;
6543: FTE_RATE_CHART_PKG.Reset_Region_Info;
6544: END IF; --end --(1)
6545: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
6546:
6547: FTE_UTIL_PKG.Exit_Debug(l_module_name);
6548: EXCEPTION
6549: WHEN OTHERS THEN

Line 6579: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,

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,
6581: x_error_msg OUT NOCOPY VARCHAR2) IS
6582:
6583: l_action VARCHAR2(30);

Line 6597: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;

6593: l_valid_carrier BOOLEAN;
6594: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.VALIDATE_ADJUSTED_RATE_CHART';
6595: l_temp VARCHAR2(50);
6596: l_count NUMBER;
6597: l_chart_type VARCHAR2(50) := FTE_RATE_CHART_PKG.g_chart_type;
6598:
6599: BEGIN
6600: FTE_UTIL_PKG.ENTER_Debug(l_module_name);
6601: x_status := -1;

Line 6669: l_list_header_id := FTE_RATE_CHART_PKG.Get_Pricelist_Id(p_name => l_name,

6665: l_qualifier_context := 'MODLIST';
6666: END IF;
6667:
6668: IF (l_name IS NOT NULL) THEN
6669: l_list_header_id := FTE_RATE_CHART_PKG.Get_Pricelist_Id(p_name => l_name,
6670: p_carrier_id => l_carrier_id,
6671: p_attribute1 => l_temp);
6672:
6673: IF (l_list_header_id = -1) THEN

Line 6731: FTE_RATE_CHART_PKG.g_qualifier_group := FTE_RATE_CHART_PKG.g_qualifier_group + 1;

6727: IF (l_action = 'ADD'
6728: AND l_chart_type in ('FTE_MODIFIER', 'FAC_MODIFIER')) THEN
6729: FOR i IN 1..l_list_header_ids.COUNT LOOP
6730: --Store the Qualifier
6731: FTE_RATE_CHART_PKG.g_qualifier_group := FTE_RATE_CHART_PKG.g_qualifier_group + 1;
6732:
6733: l_count := p_qp_qualifier_tbl.COUNT+1;
6734:
6735: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

Line 6735: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;

6731: FTE_RATE_CHART_PKG.g_qualifier_group := FTE_RATE_CHART_PKG.g_qualifier_group + 1;
6732:
6733: l_count := p_qp_qualifier_tbl.COUNT+1;
6734:
6735: p_qp_qualifier_tbl(l_count).PROCESS_ID := FTE_RATE_CHART_PKG.G_Process_Id;
6736: p_qp_qualifier_tbl(l_count).INTERFACE_ACTION_CODE := 'C';
6737: p_qp_qualifier_tbl(l_count).QUALIFIER_CONTEXT := l_qualifier_context;
6738: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTRIBUTE := l_qualifier_attr;
6739: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTR_VALUE := l_list_header_ids(i);

Line 6740: p_qp_qualifier_tbl(l_count).QUALIFIER_GROUPING_NO := FTE_RATE_CHART_PKG.g_qualifier_group;

6736: p_qp_qualifier_tbl(l_count).INTERFACE_ACTION_CODE := 'C';
6737: p_qp_qualifier_tbl(l_count).QUALIFIER_CONTEXT := l_qualifier_context;
6738: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTRIBUTE := l_qualifier_attr;
6739: p_qp_qualifier_tbl(l_count).QUALIFIER_ATTR_VALUE := l_list_header_ids(i);
6740: p_qp_qualifier_tbl(l_count).QUALIFIER_GROUPING_NO := FTE_RATE_CHART_PKG.g_qualifier_group;
6741: END LOOP;
6742: END IF;
6743:
6744: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;

Line 6744: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;

6740: p_qp_qualifier_tbl(l_count).QUALIFIER_GROUPING_NO := FTE_RATE_CHART_PKG.g_qualifier_group;
6741: END LOOP;
6742: END IF;
6743:
6744: FTE_RATE_CHART_PKG.g_chart_type := l_chart_type;
6745:
6746: FTE_UTIL_PKG.Exit_Debug(l_module_name);
6747:
6748: EXCEPTION

Line 6777: p_qp_qualifier_tbl IN OUT NOCOPY FTE_RATE_CHART_PKG.qp_qualifier_tbl,

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
6780:
6781: l_action VARCHAR2(30);