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_QP_ENGINE dependencies on QP_PREQ_GRP

Line 567: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

563:
564:
565: -- delete from event tables for the specified line_index
566: PROCEDURE delete_lines(p_line_index IN NUMBER,
567: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
568: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
569: x_return_status OUT NOCOPY VARCHAR2)
570: IS
571: i NUMBER;

Line 568: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

564:
565: -- delete from event tables for the specified line_index
566: PROCEDURE delete_lines(p_line_index IN NUMBER,
567: x_qp_output_line_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
568: x_qp_output_detail_rows IN OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
569: x_return_status OUT NOCOPY VARCHAR2)
570: IS
571: i NUMBER;
572: l_return_status VARCHAR2(1);

Line 861: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

857:
858: -- creates a control record based on defaults and adds it to the input table for the event
859: PROCEDURE create_control_record (p_event_num IN NUMBER,
860: x_return_status OUT NOCOPY VARCHAR2) IS
861: l_control_rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
862: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
863: l_method_name VARCHAR2(50) := 'create_control_record';
864: BEGIN
865:

Line 933: G_I_PRICING_STATUS_CODE(i) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

929: G_I_ADJUSTED_UNIT_PRICE(i) := null;
930: G_I_UPD_ADJUSTED_UNIT_PRICE(i) := null;
931: G_I_PROCESSED_FLAG(i) := null;
932: G_I_PROCESSING_ORDER(i) := null;
933: G_I_PRICING_STATUS_CODE(i) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
934: G_I_PRICING_STATUS_TEXT(i) := null;
935: G_I_ROUNDING_FLAG(i) := null;
936: G_I_ROUNDING_FACTOR(i) := null;
937: G_I_QUALIFIERS_EXIST_FLAG(i) := 'N';

Line 942: G_I_USAGE_PRICING_TYPE(i) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE;

938: G_I_PRICING_ATTRS_EXIST_FLAG(i) := 'N';
939: G_I_PRICE_LIST_ID(i) := -9999;
940: G_I_VALIDATED_FLAG(i) := 'N';
941: G_I_PRICE_REQUEST_CODE(i) := null;
942: G_I_USAGE_PRICING_TYPE(i) := QP_PREQ_GRP.G_REGULAR_USAGE_TYPE;
943: G_I_LINE_CATEGORY(i) := null;
944:
945: line_extras.line_index := p_pricing_engine_input_rec.input_index ;
946: line_extras.input_set_number := p_pricing_engine_input_rec.input_set_number;

Line 1004: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;

1000: -- default values in attributes
1001: G_I_A_COMPARISON_OPERATOR_TYPE(j) := '=';
1002: G_I_A_VALIDATED_FLAG(j) :='N';
1003: G_I_A_LINE_DETAIL_INDEX(j) := null;
1004: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;
1005: G_I_A_LIST_HEADER_ID(j) := null;
1006: G_I_A_LIST_LINE_ID(j) := null;
1007: G_I_A_SETUP_VALUE_FROM(j) := null;
1008: G_I_A_VALUE_TO(j) := null;

Line 1013: G_I_A_PRICING_STATUS_CODE(j) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

1009: G_I_A_SETUP_VALUE_TO(j) := null;
1010: G_I_A_GROUPING_NUMBER(j) := null;
1011: G_I_A_NO_QUALIFIERS_IN_GRP(j) := null;
1012: G_I_A_APPLIED_FLAG(j) := null;
1013: G_I_A_PRICING_STATUS_CODE(j) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1014: G_I_A_PRICING_STATUS_TEXT(j) := null;
1015: G_I_A_QUALIFIER_PRECEDENCE(j) := null;
1016: G_I_A_DATATYPE(j) := null;
1017: G_I_A_PRICING_ATTR_FLAG(j) := null;

Line 1021: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;

1017: G_I_A_PRICING_ATTR_FLAG(j) := null;
1018: -- default values in qualifiers
1019: G_I_A_VALIDATED_FLAG(j) :='Y';
1020: G_I_A_LINE_DETAIL_INDEX(j) := null;
1021: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;
1022: G_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1023: G_I_A_LIST_HEADER_ID(j) := null;
1024: G_I_A_LIST_LINE_ID(j) := null;
1025: G_I_A_SETUP_VALUE_FROM(j) := null;

Line 1022: G_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_QUALIFIER_TYPE;

1018: -- default values in qualifiers
1019: G_I_A_VALIDATED_FLAG(j) :='Y';
1020: G_I_A_LINE_DETAIL_INDEX(j) := null;
1021: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;
1022: G_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_QUALIFIER_TYPE;
1023: G_I_A_LIST_HEADER_ID(j) := null;
1024: G_I_A_LIST_LINE_ID(j) := null;
1025: G_I_A_SETUP_VALUE_FROM(j) := null;
1026: G_I_A_VALUE_TO(j) := null;

Line 1031: G_I_A_PRICING_STATUS_CODE(j) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

1027: G_I_A_SETUP_VALUE_TO(j) := null;
1028: G_I_A_GROUPING_NUMBER(j) := null;
1029: G_I_A_NO_QUALIFIERS_IN_GRP(j) := null;
1030: G_I_A_APPLIED_FLAG(j) := null;
1031: G_I_A_PRICING_STATUS_CODE(j) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1032: G_I_A_PRICING_STATUS_TEXT(j) := null;
1033: G_I_A_QUALIFIER_PRECEDENCE(j) := null;
1034: G_I_A_DATATYPE(j) := null;
1035: G_I_A_PRICING_ATTR_FLAG(j) := null;

Line 1100: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1096: g_I_A_LINE_INDEX(j) := p_attr_rec.input_index;
1097:
1098: IF (p_attr_rec.attribute_name = 'CONTAINER_TYPE') THEN
1099: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1100: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1101: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE2';
1102: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1103: ELSIF (p_attr_rec.attribute_name = 'CATEGORY_ID') THEN
1104: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1105: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1101: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE2';
1102: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1103: ELSIF (p_attr_rec.attribute_name = 'CATEGORY_ID') THEN
1104: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1105: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1106: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE1';
1107: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1108: ELSIF (p_attr_rec.attribute_name = 'SERVICE_TYPE') THEN
1109: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1110: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1106: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE1';
1107: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1108: ELSIF (p_attr_rec.attribute_name = 'SERVICE_TYPE') THEN
1109: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1110: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1111: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE3';
1112: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1113: ELSIF (p_attr_rec.attribute_name = 'ADDITIONAL_CHARGE') THEN
1114: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1115: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1111: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE3';
1112: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1113: ELSIF (p_attr_rec.attribute_name = 'ADDITIONAL_CHARGE') THEN
1114: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1115: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1116: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE4';
1117: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1118: ELSIF (p_attr_rec.attribute_name = 'ORIGIN_ZONE') THEN
1119: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1120: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1116: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE4';
1117: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1118: ELSIF (p_attr_rec.attribute_name = 'ORIGIN_ZONE') THEN
1119: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1120: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1121: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE7';
1122: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1123: ELSIF (p_attr_rec.attribute_name = 'DESTINATION_ZONE') THEN
1124: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1125: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1121: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE7';
1122: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1123: ELSIF (p_attr_rec.attribute_name = 'DESTINATION_ZONE') THEN
1124: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1125: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1126: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE8';
1127: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1128: ELSIF (p_attr_rec.attribute_name = 'TOTAL_SHIPMENT_QUANTITY') THEN
1129: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1130: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1126: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE8';
1127: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1128: ELSIF (p_attr_rec.attribute_name = 'TOTAL_SHIPMENT_QUANTITY') THEN
1129: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1130: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1131: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE9';
1132: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1133: ELSIF (p_attr_rec.attribute_name = 'TOTAL_ITEM_QUANTITY') THEN
1134: g_I_A_CONTEXT(j) :='VOLUME'; --

Line 1135: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1131: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE9';
1132: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1133: ELSIF (p_attr_rec.attribute_name = 'TOTAL_ITEM_QUANTITY') THEN
1134: g_I_A_CONTEXT(j) :='VOLUME'; --
1135: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1136: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE20';
1137: -- trunc it to 10 positions after the decimal point
1138: -- in order to avoid converting error in QP
1139: --k := instr(p_attr_rec.attribute_value, '.', 1, 1);

Line 1148: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRODUCT_TYPE;

1144: --end if;
1145: g_I_A_VALUE_FROM(j) := get_qp_volume_string(p_attr_rec.attribute_value);
1146: ELSIF (p_attr_rec.attribute_name = 'ITEM_ALL') THEN
1147: g_I_A_CONTEXT(j) :='ITEM'; --
1148: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRODUCT_TYPE;
1149: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE3';
1150: g_I_A_VALUE_FROM(j) := 'ALL';
1151: ELSIF (p_attr_rec.attribute_name = 'MULTIPIECE_FLAG') THEN
1152: g_I_A_CONTEXT(j) :='LOGISTICS'; --

Line 1153: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1149: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE3';
1150: g_I_A_VALUE_FROM(j) := 'ALL';
1151: ELSIF (p_attr_rec.attribute_name = 'MULTIPIECE_FLAG') THEN
1152: g_I_A_CONTEXT(j) :='LOGISTICS'; --
1153: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1154: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE10';
1155: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1156: ELSIF (p_attr_rec.attribute_name = 'TL_RATE_BASIS') THEN
1157: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_RATE_BASIS;

Line 1158: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1154: g_I_A_ATTRIBUTE(j) :='PRICING_ATTRIBUTE10';
1155: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1156: ELSIF (p_attr_rec.attribute_name = 'TL_RATE_BASIS') THEN
1157: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_RATE_BASIS;
1158: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1159: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_RATE_BASIS;
1160: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1161: ELSIF (p_attr_rec.attribute_name = 'TL_RATE_TYPE') THEN
1162: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_RATE_TYPE;

Line 1163: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1159: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_RATE_BASIS;
1160: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1161: ELSIF (p_attr_rec.attribute_name = 'TL_RATE_TYPE') THEN
1162: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_RATE_TYPE;
1163: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1164: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_RATE_TYPE;
1165: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1166: ELSIF (p_attr_rec.attribute_name = 'TL_DISTANCE_TYPE') THEN
1167: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DISTANCE_TYPE;

Line 1168: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1164: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_RATE_TYPE;
1165: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1166: ELSIF (p_attr_rec.attribute_name = 'TL_DISTANCE_TYPE') THEN
1167: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DISTANCE_TYPE;
1168: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1169: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DISTANCE_TYPE;
1170: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1171: -- ELSIF (p_attr_rec.attribute_name = 'SERVICE_TYPE') THEN
1172: -- g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_SERVICE_TYPE;

Line 1173: -- g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1169: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DISTANCE_TYPE;
1170: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1171: -- ELSIF (p_attr_rec.attribute_name = 'SERVICE_TYPE') THEN
1172: -- g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_SERVICE_TYPE;
1173: -- g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1174: -- g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_SERVICE_TYPE;
1175: -- g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1176: ELSIF (p_attr_rec.attribute_name = 'VEHICLE') THEN
1177: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_VEHICLE;

Line 1178: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1174: -- g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_SERVICE_TYPE;
1175: -- g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1176: ELSIF (p_attr_rec.attribute_name = 'VEHICLE') THEN
1177: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_VEHICLE;
1178: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1179: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_VEHICLE;
1180: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1181: ELSIF (p_attr_rec.attribute_name = 'TL_ORIGIN_ZONE') THEN
1182: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_ORIGIN_ZONE;

Line 1183: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1179: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_VEHICLE;
1180: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1181: ELSIF (p_attr_rec.attribute_name = 'TL_ORIGIN_ZONE') THEN
1182: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_ORIGIN_ZONE;
1183: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1184: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_ORIGIN_ZONE;
1185: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1186: ELSIF (p_attr_rec.attribute_name = 'TL_DESTINATION_ZONE') THEN
1187: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_DESTINATION_ZONE;

Line 1188: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1184: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_ORIGIN_ZONE;
1185: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1186: ELSIF (p_attr_rec.attribute_name = 'TL_DESTINATION_ZONE') THEN
1187: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_DESTINATION_ZONE;
1188: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1189: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_DESTINATION_ZONE;
1190: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1191: ELSIF (p_attr_rec.attribute_name = 'TL_NUM_WEEKEND_LAYOVERS') THEN
1192: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_NUM_WEEKEND_LAYOVERS;

Line 1193: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1189: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_DESTINATION_ZONE;
1190: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1191: ELSIF (p_attr_rec.attribute_name = 'TL_NUM_WEEKEND_LAYOVERS') THEN
1192: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_NUM_WEEKEND_LAYOVERS;
1193: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1194: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_NUM_WEEKEND_LAYOVERS;
1195: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1196: ELSIF (p_attr_rec.attribute_name = 'LOADING_PROTOCOL') THEN
1197: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_LOADING_PROTOCOL;

Line 1198: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1194: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_NUM_WEEKEND_LAYOVERS;
1195: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1196: ELSIF (p_attr_rec.attribute_name = 'LOADING_PROTOCOL') THEN
1197: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_LOADING_PROTOCOL;
1198: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1199: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_LOADING_PROTOCOL;
1200: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1201: ELSIF (p_attr_rec.attribute_name = 'TL_CM_DISCOUNT_FLG') THEN
1202: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_CM_DISCOUNT_FLG;

Line 1203: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1199: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_LOADING_PROTOCOL;
1200: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1201: ELSIF (p_attr_rec.attribute_name = 'TL_CM_DISCOUNT_FLG') THEN
1202: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_CM_DISCOUNT_FLG;
1203: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1204: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_CM_DISCOUNT_FLG;
1205: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1206: ELSIF (p_attr_rec.attribute_name = 'TL_DEADHEAD_RT_VAR') THEN
1207: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DEADHEAD_RT_VAR;

Line 1208: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1204: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_CM_DISCOUNT_FLG;
1205: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1206: ELSIF (p_attr_rec.attribute_name = 'TL_DEADHEAD_RT_VAR') THEN
1207: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DEADHEAD_RT_VAR;
1208: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1209: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DEADHEAD_RT_VAR;
1210: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1211: ELSIF (p_attr_rec.attribute_name = 'TL_NUM_STOPS') THEN
1212: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_NUM_STOPS;

Line 1213: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1209: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DEADHEAD_RT_VAR;
1210: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1211: ELSIF (p_attr_rec.attribute_name = 'TL_NUM_STOPS') THEN
1212: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_NUM_STOPS;
1213: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1214: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_NUM_STOPS;
1215: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1216: ELSIF (p_attr_rec.attribute_name = 'TL_CHARGED_OUT_RT_DISTANCE') THEN
1217: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_CHARGED_OUT_RT_DIST;

Line 1218: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1214: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_NUM_STOPS;
1215: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1216: ELSIF (p_attr_rec.attribute_name = 'TL_CHARGED_OUT_RT_DISTANCE') THEN
1217: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_CHARGED_OUT_RT_DIST;
1218: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1219: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_CHARGED_OUT_RT_DIST;
1220: --g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1221: g_I_A_VALUE_FROM(j) := get_qp_volume_string(p_attr_rec.attribute_value);
1222: ELSIF (p_attr_rec.attribute_name = 'TL_HANDLING_WT') THEN

Line 1224: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1220: --g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1221: g_I_A_VALUE_FROM(j) := get_qp_volume_string(p_attr_rec.attribute_value);
1222: ELSIF (p_attr_rec.attribute_name = 'TL_HANDLING_WT') THEN
1223: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_HANDLING_WT;
1224: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1225: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_HANDLING_WT;
1226: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1227: ELSIF (p_attr_rec.attribute_name = 'TL_HANDLING_VOL') THEN
1228: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_HANDLING_VOL;

Line 1229: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1225: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_HANDLING_WT;
1226: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1227: ELSIF (p_attr_rec.attribute_name = 'TL_HANDLING_VOL') THEN
1228: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_HANDLING_VOL;
1229: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1230: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_HANDLING_VOL;
1231: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1232: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_WT') THEN
1233: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_WT;

Line 1234: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1230: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_HANDLING_VOL;
1231: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1232: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_WT') THEN
1233: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_WT;
1234: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1235: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_WT;
1236: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1237: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_VOL') THEN
1238: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_VOL;

Line 1239: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1235: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_WT;
1236: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1237: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_VOL') THEN
1238: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_VOL;
1239: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1240: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_VOL;
1241: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1242: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_CONTAINER') THEN
1243: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_CONTAINER;

Line 1244: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1240: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_VOL;
1241: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1242: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_CONTAINER') THEN
1243: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_CONTAINER;
1244: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1245: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_CONTAINER;
1246: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1247: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_PALLET') THEN
1248: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_PALLET;

Line 1249: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1245: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_CONTAINER;
1246: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1247: ELSIF (p_attr_rec.attribute_name = 'TL_PICKUP_PALLET') THEN
1248: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_PICKUP_PALLET;
1249: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1250: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_PALLET;
1251: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1252: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_WT') THEN
1253: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_WT;

Line 1254: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1250: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_PICKUP_PALLET;
1251: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1252: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_WT') THEN
1253: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_WT;
1254: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1255: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_WT;
1256: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1257: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_VOL') THEN
1258: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_VOL;

Line 1259: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1255: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_WT;
1256: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1257: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_VOL') THEN
1258: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_VOL;
1259: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1260: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_VOL;
1261: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1262: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_CONTAINER') THEN
1263: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_CONTAINER;

Line 1264: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1260: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_VOL;
1261: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1262: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_CONTAINER') THEN
1263: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_CONTAINER;
1264: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1265: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_CONTAINER;
1266: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1267: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_PALLET') THEN
1268: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_PALLET;

Line 1269: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1265: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_CONTAINER;
1266: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1267: ELSIF (p_attr_rec.attribute_name = 'TL_DROPOFF_PALLET') THEN
1268: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_DROPOFF_PALLET;
1269: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1270: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_PALLET;
1271: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1272: ELSIF (p_attr_rec.attribute_name = 'TL_NUM_WEEKDAY_LAYOVERS') THEN
1273: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_NUM_WEEKDAY_LAYOVERS;

Line 1274: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1270: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_DROPOFF_PALLET;
1271: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1272: ELSIF (p_attr_rec.attribute_name = 'TL_NUM_WEEKDAY_LAYOVERS') THEN
1273: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_NUM_WEEKDAY_LAYOVERS;
1274: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1275: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_NUM_WEEKDAY_LAYOVERS;
1276: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1277: ELSIF (p_attr_rec.attribute_name = 'TL_WEEKEND_LAYOVER_MILEAGE') THEN
1278: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_WEEKEND_LAYOVER_MIL;

Line 1279: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1275: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_NUM_WEEKDAY_LAYOVERS;
1276: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1277: ELSIF (p_attr_rec.attribute_name = 'TL_WEEKEND_LAYOVER_MILEAGE') THEN
1278: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_WEEKEND_LAYOVER_MIL;
1279: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1280: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_WEEKEND_LAYOVER_MIL;
1281: --g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1282: g_I_A_VALUE_FROM(j) := get_qp_volume_string(p_attr_rec.attribute_value);
1283: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_WT') THEN

Line 1285: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1281: --g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1282: g_I_A_VALUE_FROM(j) := get_qp_volume_string(p_attr_rec.attribute_value);
1283: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_WT') THEN
1284: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_WT;
1285: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1286: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_WT;
1287: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1288: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_VOL') THEN
1289: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_VOL;

Line 1290: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1286: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_WT;
1287: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1288: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_VOL') THEN
1289: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_VOL;
1290: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1291: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_VOL;
1292: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1293: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_CONTAINER') THEN
1294: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_CONTAINER;

Line 1295: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1291: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_VOL;
1292: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1293: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_CONTAINER') THEN
1294: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_CONTAINER;
1295: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1296: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_CONTAINER;
1297: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1298: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_PALLET') THEN
1299: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_PALLET;

Line 1300: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1296: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_CONTAINER;
1297: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1298: ELSIF (p_attr_rec.attribute_name = 'FAC_PICKUP_PALLET') THEN
1299: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_PICKUP_PALLET;
1300: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1301: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_PALLET;
1302: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1303: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_WT') THEN
1304: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_WT;

Line 1305: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1301: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_PICKUP_PALLET;
1302: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1303: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_WT') THEN
1304: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_WT;
1305: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1306: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_WT;
1307: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1308: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_VOL') THEN
1309: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_VOL;

Line 1310: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1306: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_WT;
1307: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1308: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_VOL') THEN
1309: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_VOL;
1310: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1311: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_VOL;
1312: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1313: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_CONTAINER') THEN
1314: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_CONTAINER;

Line 1315: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1311: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_VOL;
1312: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1313: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_CONTAINER') THEN
1314: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_CONTAINER;
1315: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1316: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_CONTAINER;
1317: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1318: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_PALLET') THEN
1319: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_PALLET;

Line 1320: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1316: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_CONTAINER;
1317: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1318: ELSIF (p_attr_rec.attribute_name = 'FAC_DROPOFF_PALLET') THEN
1319: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_DROPOFF_PALLET;
1320: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1321: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_PALLET;
1322: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1323: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_WT') THEN
1324: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_WT;

Line 1325: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1321: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_DROPOFF_PALLET;
1322: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1323: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_WT') THEN
1324: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_WT;
1325: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1326: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_WT;
1327: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1328: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_VOL') THEN
1329: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_VOL;

Line 1330: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1326: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_WT;
1327: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1328: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_VOL') THEN
1329: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_VOL;
1330: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1331: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_VOL;
1332: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1333: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_CONTAINER') THEN
1334: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_CONTAINER;

Line 1335: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1331: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_VOL;
1332: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1333: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_CONTAINER') THEN
1334: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_CONTAINER;
1335: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1336: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_CONTAINER;
1337: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1338: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_PALLET') THEN
1339: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_PALLET;

Line 1340: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1336: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_CONTAINER;
1337: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1338: ELSIF (p_attr_rec.attribute_name = 'FAC_HANDLING_PALLET') THEN
1339: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_FAC_HANDLING_PALLET;
1340: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1341: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_PALLET;
1342: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1343: ELSIF (p_attr_rec.attribute_name = 'TL_STOP_LOADING_ACT') THEN
1344: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_STOP_LOADING_ACT;

Line 1345: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1341: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_FAC_HANDLING_PALLET;
1342: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1343: ELSIF (p_attr_rec.attribute_name = 'TL_STOP_LOADING_ACT') THEN
1344: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_STOP_LOADING_ACT;
1345: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1346: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_STOP_LOADING_ACT;
1347: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1348: ELSIF (p_attr_rec.attribute_name = 'TL_STOP_UNLOADING_ACT') THEN
1349: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_STOP_UNLOADING_ACT;

Line 1350: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1346: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_STOP_LOADING_ACT;
1347: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1348: ELSIF (p_attr_rec.attribute_name = 'TL_STOP_UNLOADING_ACT') THEN
1349: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_STOP_UNLOADING_ACT;
1350: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1351: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_STOP_UNLOADING_ACT;
1352: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1353: ELSIF (p_attr_rec.attribute_name = 'TL_HANDLING_ACT') THEN
1354: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_HANDLING_ACT;

Line 1355: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;

1351: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_STOP_UNLOADING_ACT;
1352: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1353: ELSIF (p_attr_rec.attribute_name = 'TL_HANDLING_ACT') THEN
1354: g_I_A_CONTEXT(j) := fte_rtg_globals.G_AX_TL_HANDLING_ACT;
1355: g_I_A_ATTRIBUTE_TYPE(j) := QP_PREQ_GRP.G_PRICING_TYPE;
1356: g_I_A_ATTRIBUTE(j) := fte_rtg_globals.G_A_TL_HANDLING_ACT;
1357: g_I_A_VALUE_FROM(j) := p_attr_rec.attribute_value;
1358: ELSE
1359: null;

Line 1370: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;

1366: -- default values in attributes
1367: G_I_A_COMPARISON_OPERATOR_TYPE(j) := '=';
1368: G_I_A_VALIDATED_FLAG(j) :='N';
1369: G_I_A_LINE_DETAIL_INDEX(j) := null;
1370: G_I_A_ATTRIBUTE_LEVEL(j) := QP_PREQ_GRP.G_LINE_LEVEL;
1371: G_I_A_LIST_HEADER_ID(j) := null;
1372: G_I_A_LIST_LINE_ID(j) := null;
1373: G_I_A_SETUP_VALUE_FROM(j) := null;
1374: G_I_A_VALUE_TO(j) := null;

Line 1379: G_I_A_PRICING_STATUS_CODE(j) := QP_PREQ_GRP.G_STATUS_UNCHANGED;

1375: G_I_A_SETUP_VALUE_TO(j) := null;
1376: G_I_A_GROUPING_NUMBER(j) := null;
1377: G_I_A_NO_QUALIFIERS_IN_GRP(j) := null;
1378: G_I_A_APPLIED_FLAG(j) := null;
1379: G_I_A_PRICING_STATUS_CODE(j) := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1380: G_I_A_PRICING_STATUS_TEXT(j) := null;
1381: G_I_A_QUALIFIER_PRECEDENCE(j) := null;
1382: G_I_A_DATATYPE(j) := null;
1383: G_I_A_PRICING_ATTR_FLAG(j) := null;

Line 1543: l_qp_output_detail_row QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;

1539: p_charge_subtype_code IN VARCHAR2,
1540: p_adjustment_amount IN NUMBER,
1541: x_return_status OUT NOCOPY VARCHAR2)
1542: IS
1543: l_qp_output_detail_row QP_PREQ_GRP.LINE_DETAIL_REC_TYPE;
1544: l_line_detail_index NUMBER;
1545: l_return_status VARCHAR2(1);
1546: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;
1547: l_method_name VARCHAR2(50) := 'add_qp_output_detail';

Line 1597: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,

1593: i := g_O_line_tbl.FIRST;
1594: IF (i IS NOT NULL) THEN
1595: LOOP
1596: IF (g_O_line_tbl(i).status_code IN (
1597: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

Line 1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,

1594: IF (i IS NOT NULL) THEN
1595: LOOP
1596: IF (g_O_line_tbl(i).status_code IN (
1597: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

Line 1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,

1595: LOOP
1596: IF (g_O_line_tbl(i).status_code IN (
1597: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

Line 1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,

1596: IF (g_O_line_tbl(i).status_code IN (
1597: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

Line 1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

1597: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

Line 1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

1598: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

Line 1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

1599: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

Line 1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

1600: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

Line 1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

1601: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1609: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

Line 1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

1602: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1609: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1610: l_error_flag := true;

Line 1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

1603: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1609: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1610: l_error_flag := true;
1611: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);

Line 1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

1604: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1609: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1610: l_error_flag := true;
1611: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1612: IF (g_O_line_tbl(i).status_code = 'IPL') THEN

Line 1609: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

1605: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1606: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1607: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1608: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1609: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1610: l_error_flag := true;
1611: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1612: IF (g_O_line_tbl(i).status_code = 'IPL') THEN
1613: raise fte_freight_pricing_util.g_not_on_pricelist;

Line 1688: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,

1684: IF (i IS NOT NULL) THEN
1685: LOOP
1686: l_line_cnt := l_line_cnt + 1;
1687: IF (g_O_line_tbl(i).status_code IN (
1688: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

Line 1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,

1685: LOOP
1686: l_line_cnt := l_line_cnt + 1;
1687: IF (g_O_line_tbl(i).status_code IN (
1688: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

Line 1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,

1686: l_line_cnt := l_line_cnt + 1;
1687: IF (g_O_line_tbl(i).status_code IN (
1688: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

Line 1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,

1687: IF (g_O_line_tbl(i).status_code IN (
1688: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

Line 1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

1688: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

Line 1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

1689: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

Line 1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

1690: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

Line 1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

1691: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

Line 1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

1692: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1700: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

Line 1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

1693: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1700: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1701: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);

Line 1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

1694: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1700: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1701: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1702: IF (g_O_line_tbl(i).status_code = 'IPL') THEN

Line 1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

1695: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1700: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1701: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1702: IF (g_O_line_tbl(i).status_code = 'IPL') THEN
1703: l_ipl_cnt := l_ipl_cnt + 1;

Line 1700: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

1696: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1697: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1698: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1699: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1700: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1701: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1702: IF (g_O_line_tbl(i).status_code = 'IPL') THEN
1703: l_ipl_cnt := l_ipl_cnt + 1;
1704: g_O_line_tbl(i).unit_price := 0;

Line 1839: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,

1835: IF (i IS NOT NULL) THEN
1836: LOOP
1837: IF (g_I_line_extras_tbl(i).input_set_number = 1) THEN
1838: IF (g_O_line_tbl(i).status_code IN (
1839: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

Line 1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,

1836: LOOP
1837: IF (g_I_line_extras_tbl(i).input_set_number = 1) THEN
1838: IF (g_O_line_tbl(i).status_code IN (
1839: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

Line 1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,

1837: IF (g_I_line_extras_tbl(i).input_set_number = 1) THEN
1838: IF (g_O_line_tbl(i).status_code IN (
1839: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

Line 1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,

1838: IF (g_O_line_tbl(i).status_code IN (
1839: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

Line 1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

1839: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

Line 1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

1840: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

Line 1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

1841: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

Line 1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

1842: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

Line 1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

1843: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

Line 1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

1844: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1852: l_error_flag := true;

Line 1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

1845: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1852: l_error_flag := true;
1853: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);

Line 1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

1846: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1852: l_error_flag := true;
1853: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1854: END IF;

Line 1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

1847: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1848: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1849: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1850: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1852: l_error_flag := true;
1853: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1854: END IF;
1855: IF (g_O_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST) THEN

Line 1855: IF (g_O_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST) THEN

1851: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1852: l_error_flag := true;
1853: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1854: END IF;
1855: IF (g_O_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST) THEN
1856: --IF (g_O_line_tbl(i).status_code = 'IPL') THEN
1857: l_sp_ipl_cnt := l_sp_ipl_cnt + 1;
1858: --raise fte_freight_pricing_util.g_not_on_pricelist;
1859: ELSIF (g_O_line_tbl(i).unit_price IS NULL) THEN

Line 1869: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,

1865: END IF;
1866: ELSIF (g_I_line_extras_tbl(i).input_set_number = 2) THEN
1867: l_mp_line_cnt := l_mp_line_cnt + 1;
1868: IF (g_O_line_tbl(i).status_code IN (
1869: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

Line 1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,

1866: ELSIF (g_I_line_extras_tbl(i).input_set_number = 2) THEN
1867: l_mp_line_cnt := l_mp_line_cnt + 1;
1868: IF (g_O_line_tbl(i).status_code IN (
1869: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

Line 1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,

1867: l_mp_line_cnt := l_mp_line_cnt + 1;
1868: IF (g_O_line_tbl(i).status_code IN (
1869: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

Line 1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,

1868: IF (g_O_line_tbl(i).status_code IN (
1869: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

Line 1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

1869: --QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

Line 1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

1870: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

Line 1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

1871: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

Line 1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

1872: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

Line 1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

1873: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1881: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

Line 1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

1874: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1881: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1882: l_error_flag := true;

Line 1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

1875: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1881: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1882: l_error_flag := true;
1883: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);

Line 1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

1876: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1881: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1882: l_error_flag := true;
1883: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1884: END IF;

Line 1881: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

1877: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1878: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1879: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1880: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1881: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1882: l_error_flag := true;
1883: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1884: END IF;
1885: -- check for IPL

Line 1886: IF (g_O_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST) THEN

1882: l_error_flag := true;
1883: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1884: END IF;
1885: -- check for IPL
1886: IF (g_O_line_tbl(i).status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST) THEN
1887: l_mp_ipl_cnt := l_mp_ipl_cnt +1;
1888: ELSIF (g_O_line_tbl(i).unit_price IS NULL) THEN
1889: l_error_flag := true;
1890: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Unit price is

Line 1947: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,

1943: i := g_O_line_tbl.FIRST ;
1944: IF (i IS NOT NULL) THEN
1945: LOOP
1946: IF (g_O_line_tbl(i).status_code IN (
1947: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

Line 1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,

1944: IF (i IS NOT NULL) THEN
1945: LOOP
1946: IF (g_O_line_tbl(i).status_code IN (
1947: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

Line 1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,

1945: LOOP
1946: IF (g_O_line_tbl(i).status_code IN (
1947: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

Line 1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,

1946: IF (g_O_line_tbl(i).status_code IN (
1947: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

Line 1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,

1947: QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST ,
1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

Line 1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,

1948: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION ,
1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

Line 1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,

1949: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND ,
1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

Line 1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,

1950: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR ,
1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

Line 1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,

1951: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS ,
1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1959: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

Line 1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,

1952: QP_PREQ_GRP.G_STATUS_INCOMP_LOGIC ,
1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1959: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1960: l_error_flag := true;

Line 1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,

1953: QP_PREQ_GRP.G_STATUS_CALC_ERROR ,
1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1959: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1960: l_error_flag := true;
1961: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);

Line 1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,

1954: QP_PREQ_GRP.G_STATUS_UOM_FAILURE ,
1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1959: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1960: l_error_flag := true;
1961: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1962: IF (g_O_line_tbl(i).status_code = 'IPL') THEN

Line 1959: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN

1955: QP_PREQ_GRP.G_STATUS_INVALID_UOM ,
1956: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST ,
1957: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV ,
1958: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP ,
1959: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR )) THEN
1960: l_error_flag := true;
1961: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_LOG,'Event = '||p_event_num||' LineIndex = '||i||' Status Code = '||g_O_line_tbl(i).status_code||' Text = '||g_O_line_tbl(i).status_text);
1962: IF (g_O_line_tbl(i).status_code = 'IPL') THEN
1963: raise fte_freight_pricing_util.g_not_on_pricelist;

Line 2019: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

2015: END check_parcel_output_errors;
2016:
2017: -- return the pointer to the qp outputs
2018: PROCEDURE get_qp_output(
2019: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2020: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2021: x_return_status OUT NOCOPY VARCHAR2)
2022: IS
2023: l_return_status VARCHAR2(1);

Line 2020: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2016:
2017: -- return the pointer to the qp outputs
2018: PROCEDURE get_qp_output(
2019: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2020: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2021: x_return_status OUT NOCOPY VARCHAR2)
2022: IS
2023: l_return_status VARCHAR2(1);
2024: l_log_level NUMBER := fte_freight_pricing_util.G_DBG;

Line 2045: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

2041: END get_qp_output;
2042:
2043: -- populate qp output from the temp table
2044: PROCEDURE populate_qp_output (
2045: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2046: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2047: x_return_status OUT NOCOPY VARCHAR2)
2048: IS
2049: l_return_status_text VARCHAR2(240);

Line 2046: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2042:
2043: -- populate qp output from the temp table
2044: PROCEDURE populate_qp_output (
2045: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2046: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2047: x_return_status OUT NOCOPY VARCHAR2)
2048: IS
2049: l_return_status_text VARCHAR2(240);
2050: l_return_status VARCHAR2(1);

Line 2096: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2092: override_flag,
2093: pricing_status_code,
2094: pricing_status_text
2095: from qp_ldets_v
2096: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2097: and ( list_line_type_code = QP_PREQ_GRP.G_DISCOUNT
2098: or ((list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2099: or list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE ) -- TL
2100: and charge_subtype_code IS NOT NULL) -- TL

Line 2097: and ( list_line_type_code = QP_PREQ_GRP.G_DISCOUNT

2093: pricing_status_code,
2094: pricing_status_text
2095: from qp_ldets_v
2096: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2097: and ( list_line_type_code = QP_PREQ_GRP.G_DISCOUNT
2098: or ((list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2099: or list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE ) -- TL
2100: and charge_subtype_code IS NOT NULL) -- TL
2101: );

Line 2098: or ((list_line_type_code = QP_PREQ_GRP.G_SURCHARGE

2094: pricing_status_text
2095: from qp_ldets_v
2096: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2097: and ( list_line_type_code = QP_PREQ_GRP.G_DISCOUNT
2098: or ((list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2099: or list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE ) -- TL
2100: and charge_subtype_code IS NOT NULL) -- TL
2101: );
2102:

Line 2099: or list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE ) -- TL

2095: from qp_ldets_v
2096: where pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2097: and ( list_line_type_code = QP_PREQ_GRP.G_DISCOUNT
2098: or ((list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2099: or list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE ) -- TL
2100: and charge_subtype_code IS NOT NULL) -- TL
2101: );
2102:
2103: -- Note : discounts not guaranteed to have a subtype code in LTL / Parcel

Line 2133: AND rltd.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE

2129: rltd.related_line_index = ldets.line_index
2130: AND rltd.related_line_detail_index = ldets.line_detail_index
2131: AND rltd.line_index = c_parent_line_index
2132: AND rltd.line_detail_index = c_parent_line_detail_index
2133: AND rltd.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE
2134: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2135: AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2136: AND ldets.list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2137: AND ldets.operand_calculation_code = 'LUMPSUM'

Line 2134: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2130: AND rltd.related_line_detail_index = ldets.line_detail_index
2131: AND rltd.line_index = c_parent_line_index
2132: AND rltd.line_detail_index = c_parent_line_detail_index
2133: AND rltd.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE
2134: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2135: AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2136: AND ldets.list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2137: AND ldets.operand_calculation_code = 'LUMPSUM'
2138: AND ldets.line_quantity >0;

Line 2135: AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

2131: AND rltd.line_index = c_parent_line_index
2132: AND rltd.line_detail_index = c_parent_line_detail_index
2133: AND rltd.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE
2134: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2135: AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2136: AND ldets.list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2137: AND ldets.operand_calculation_code = 'LUMPSUM'
2138: AND ldets.line_quantity >0;
2139:

Line 2136: AND ldets.list_line_type_code = QP_PREQ_GRP.G_SURCHARGE

2132: AND rltd.line_detail_index = c_parent_line_detail_index
2133: AND rltd.relationship_type_code = QP_PREQ_GRP.G_PBH_LINE
2134: AND rltd.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2135: AND ldets.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
2136: AND ldets.list_line_type_code = QP_PREQ_GRP.G_SURCHARGE
2137: AND ldets.operand_calculation_code = 'LUMPSUM'
2138: AND ldets.line_quantity >0;
2139:
2140:

Line 2627: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,

2623: fte_freight_pricing_util.unset_method(l_log_level,l_method_name);
2624: END peek_qp_input_line;
2625:
2626: PROCEDURE call_qp_api (
2627: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2628: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2629: x_return_status OUT NOCOPY VARCHAR2)
2630: IS
2631: l_return_status_text VARCHAR2(240);

Line 2628: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2624: END peek_qp_input_line;
2625:
2626: PROCEDURE call_qp_api (
2627: x_qp_output_line_rows OUT NOCOPY QP_PREQ_GRP.LINE_TBL_TYPE,
2628: x_qp_output_detail_rows OUT NOCOPY QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2629: x_return_status OUT NOCOPY VARCHAR2)
2630: IS
2631: l_return_status_text VARCHAR2(240);
2632: l_return_status VARCHAR2(1);

Line 2657: QP_PREQ_GRP.INSERT_LINES2(

2653: --set request_id
2654: QP_PRICE_REQUEST_CONTEXT.set_request_id();
2655:
2656: IF G_I_LINE_INDEX.COUNT > 0 THEN
2657: QP_PREQ_GRP.INSERT_LINES2(
2658: p_LINE_INDEX => G_I_LINE_INDEX,
2659: p_LINE_TYPE_CODE => G_I_LINE_TYPE_CODE,
2660: p_PRICING_EFFECTIVE_DATE => G_I_PRICING_EFFECTIVE_DATE,
2661: p_ACTIVE_DATE_FIRST => G_I_ACTIVE_DATE_FIRST,

Line 2696: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after QP_PREQ_GRP_INSERT_LINES2');

2692: x_status_text => l_return_status_text);
2693:
2694: END IF;
2695:
2696: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after QP_PREQ_GRP_INSERT_LINES2');
2697: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2698: raise FTE_FREIGHT_PRICING_UTIL.g_qp_insert_lines2_failed;
2699: END IF;
2700:

Line 2702: QP_PREQ_GRP.INSERT_LINE_ATTRS2(

2698: raise FTE_FREIGHT_PRICING_UTIL.g_qp_insert_lines2_failed;
2699: END IF;
2700:
2701: IF G_I_A_LINE_INDEX.count > 0 THEN
2702: QP_PREQ_GRP.INSERT_LINE_ATTRS2(
2703: p_LINE_INDEX_tbl => G_I_A_LINE_INDEX,
2704: p_LINE_DETAIL_INDEX_tbl => G_I_A_LINE_DETAIL_INDEX,
2705: p_ATTRIBUTE_LEVEL_tbl => G_I_A_ATTRIBUTE_LEVEL,
2706: p_ATTRIBUTE_TYPE_tbl => G_I_A_ATTRIBUTE_TYPE,

Line 2738: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after QP_PREQ_GRP_INSERT_LINE_ATTRS2');

2734: x_status_text => l_return_status_text);
2735:
2736: end if;
2737:
2738: FTE_FREIGHT_PRICING_UTIL.set_location(p_loc=>'after QP_PREQ_GRP_INSERT_LINE_ATTRS2');
2739: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2740: raise FTE_FREIGHT_PRICING_UTIL.g_qp_insert_line_attrs2_failed;
2741: END IF;
2742: