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.OE_RELATED_ITEMS_PVT dependencies on QP_PREQ_GRP

Line 855: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

851:
852: procedure copy_Header_to_request(
853: p_request_type_code in varchar2
854: ,p_calculate_price_flag in varchar2
855: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
856: ) is
857:
858: l_line_index pls_integer := 0;
859:

Line 908: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

904:
905: END copy_Header_to_request;
906:
907: PROCEDURE copy_Line_to_request(
908: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
909: ,p_pricing_event in varchar2
910: ,p_Request_Type_Code in varchar2
911: ,p_honor_price_flag in VARCHAR2 Default 'Y'
912: ) IS

Line 1002: l_Control_Rec in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE

998:
999: END copy_Line_to_request;
1000:
1001: PROCEDURE set_pricing_control_record (
1002: l_Control_Rec in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE
1003: ,in_pricing_event in varchar2)IS
1004:
1005: --
1006: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1015: l_control_rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;

1011: l_control_rec.gsa_check_flag := 'Y';
1012: l_control_rec.gsa_dup_check_flag := 'Y';
1013:
1014:
1015: l_control_rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1016: l_control_rec.simulation_flag :='Y';
1017: l_control_rec.pricing_event := in_pricing_Event;
1018: -- l_control_rec.temp_table_insert_flag := 'N';
1019: l_control_rec.check_cust_view_flag := 'Y';

Line 1035: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

1031: PROCEDURE build_context_for_line(
1032: p_req_line_tbl_count in number,
1033: p_price_request_code in varchar2,
1034: p_item_type_code in varchar2,
1035: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1036: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1037: )IS
1038:
1039: qp_attr_mapping_error exception;

Line 1036: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1032: p_req_line_tbl_count in number,
1033: p_price_request_code in varchar2,
1034: p_item_type_code in varchar2,
1035: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1036: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1037: )IS
1038:
1039: qp_attr_mapping_error exception;
1040: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 1120: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

1116: END build_context_for_line;
1117:
1118: PROCEDURE copy_attribs_to_Req(
1119: p_line_index number
1120: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1121: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1122: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1123: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1124: ) IS

Line 1121: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1117:
1118: PROCEDURE copy_attribs_to_Req(
1119: p_line_index number
1120: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1121: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1122: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1123: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1124: ) IS
1125:

Line 1196: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

1192: PROCEDURE build_context_for_header(
1193: p_req_line_tbl_count in number,
1194: p_price_request_code in varchar2,
1195: p_item_type_code in varchar2,
1196: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1197: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1198: )IS
1199:
1200: qp_attr_mapping_error exception;

Line 1197: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1193: p_req_line_tbl_count in number,
1194: p_price_request_code in varchar2,
1195: p_item_type_code in varchar2,
1196: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1197: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1198: )IS
1199:
1200: qp_attr_mapping_error exception;
1201: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 1311: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

1307: procedure Append_attributes(
1308: p_header_id number default null
1309: ,p_Line_id number default null
1310: ,p_line_index number
1311: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1312: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1313: ) is
1314:
1315: i pls_integer;

Line 1312: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1308: p_header_id number default null
1309: ,p_Line_id number default null
1310: ,p_line_index number
1311: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1312: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1313: ) is
1314:
1315: i pls_integer;
1316:

Line 2238: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,

2234:
2235: END Append_attributes;
2236:
2237: PROCEDURE price_item(
2238: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

2235: END Append_attributes;
2236:
2237: PROCEDURE price_item(
2238: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

2236:
2237: PROCEDURE price_item(
2238: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2244: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2237: PROCEDURE price_item(
2238: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2244: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2245: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,

Line 2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

2238: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2244: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2245: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
2246: in_related_item_id in number,

Line 2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

2239: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2244: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2245: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
2246: in_related_item_id in number,
2247: in_qty in number,

Line 2244: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

2240: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2241: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2242: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2243: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2244: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2245: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
2246: in_related_item_id in number,
2247: in_qty in number,
2248: in_uom in varchar2,

Line 2366: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

2362: ) IS
2363:
2364: l_return_status varchar2(10);
2365: l_return_status_Text varchar2(240) ;
2366: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

2363:
2364: l_return_status varchar2(10);
2365: l_return_status_Text varchar2(240) ;
2366: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

2364: l_return_status varchar2(10);
2365: l_return_status_Text varchar2(240) ;
2366: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

2365: l_return_status_Text varchar2(240) ;
2366: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

2366: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2374:

Line 2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

2367: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2374:
2375: --

Line 2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

2368: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2374:
2375: --
2376: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

2369: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2370: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2371: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2372: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2373: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2374:
2375: --
2376: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2377: --

Line 2504: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;

2500: /*4163551*/
2501: g_header_id := in_header_id;
2502: /*4163551*/
2503:
2504: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
2505:
2506: /*4163551*/
2507: set_pricing_control_record (
2508: l_Control_Rec => l_control_rec

Line 2562: QP_PREQ_GRP.PRICE_REQUEST

2558:
2559: IF l_debug_level > 0 THEN
2560: print_time('Calling PE');
2561: END IF;
2562: QP_PREQ_GRP.PRICE_REQUEST
2563: (p_control_rec =>l_control_rec
2564: ,p_line_tbl =>l_Req_line_tbl
2565: ,p_qual_tbl =>l_Req_qual_tbl
2566: ,p_line_attr_tbl =>l_Req_line_attr_tbl

Line 3085: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,

3081: END IF;
3082:
3083:
3084: IF in_line_Type_code ='LINE' and
3085: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,

Line 3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,

3082:
3083:
3084: IF in_line_Type_code ='LINE' and
3085: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,

Line 3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,

3083:
3084: IF in_line_Type_code ='LINE' and
3085: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

Line 3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,

3084: IF in_line_Type_code ='LINE' and
3085: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3086: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

Line 3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

3087: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

Line 3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

3088: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

Line 3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

3089: FND_API.G_RET_STS_UNEXP_ERROR,
3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3097: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

Line 3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

3090: FND_API.G_RET_STS_ERROR,
3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3097: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3098: then

Line 3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

3091: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3097: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3098: then
3099:

Line 3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

3092: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3097: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3098: then
3099:
3100: l_return_status := 'E';

Line 3097: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

3093: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3094: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3095: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3096: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3097: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3098: then
3099:
3100: l_return_status := 'E';
3101:

Line 3112: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then

3108: l_price_list := in_price_list_id;
3109: End;
3110: END IF;
3111:
3112: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3113:
3114: IF l_debug_level > 0 THEN
3115: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;
3116: END IF;

Line 3138: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

3134: OE_MSG_PUB.Add;
3135:
3136: END IF;
3137:
3138: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3139:
3140: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3141: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3142: FND_MESSAGE.SET_TOKEN('UOM',in_uom);

Line 3145: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

3141: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3142: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3143: OE_MSG_PUB.Add;
3144:
3145: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3146: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3147: OE_MSG_PUB.Add;
3148:
3149: ELSIF in_status_code in

Line 3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,

3146: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3147: OE_MSG_PUB.Add;
3148:
3149: ELSIF in_status_code in
3150: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3151: FND_API.G_RET_STS_ERROR) then
3152: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3153: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3154: OE_MSG_PUB.Add;

Line 3156: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

3152: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3153: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3154: OE_MSG_PUB.Add;
3155:
3156: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3157: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3158: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3159: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3160: OE_MSG_PUB.Add;

Line 3162: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

3158: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3159: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3160: OE_MSG_PUB.Add;
3161:
3162: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3163: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3164:
3165: IF l_debug_level > 0 THEN
3166: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;

Line 3206: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then

3202:
3203: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3204: OE_MSG_PUB.Add;
3205:
3206: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3207: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3208: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3209: in_status_text);
3210: OE_MSG_PUB.Add;

Line 3212: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

3208: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3209: in_status_text);
3210: OE_MSG_PUB.Add;
3211:
3212: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3213: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3214: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3215: in_status_text);
3216: OE_MSG_PUB.Add;

Line 3218: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

3214: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3215: in_status_text);
3216: OE_MSG_PUB.Add;
3217:
3218: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3219: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3220: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3221: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3222: OE_MSG_PUB.Add;

Line 3242: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then

3238: l_return_status := 'E';
3239: --RAISE FND_API.G_EXC_ERROR;*/
3240:
3241: ELSIF in_line_Type_code ='LINE' and
3242: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
3243:
3244: IF l_debug_level > 0 THEN
3245: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
3246: END IF;

Line 3252: --( QP_PREQ_GRP.G_STATUS_UPDATED,

3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3249: OE_MSG_PUB.Add;
3250:
3251: ELSIF in_line_Type_code ='LINE' and in_status_code in
3252: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3253: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3254: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3255: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3256: and in_price_flag IN ('Y','P')

Line 3253: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and

3249: OE_MSG_PUB.Add;
3250:
3251: ELSIF in_line_Type_code ='LINE' and in_status_code in
3252: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3253: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3254: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3255: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3256: and in_price_flag IN ('Y','P')
3257: --we do not want to go in this loop if price_flag is set up 'N' because

Line 3254: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and

3250:
3251: ELSIF in_line_Type_code ='LINE' and in_status_code in
3252: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3253: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3254: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3255: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3256: and in_price_flag IN ('Y','P')
3257: --we do not want to go in this loop if price_flag is set up 'N' because
3258: --engine doesn't look at the line and will not return adjustments. In this

Line 3255: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE

3251: ELSIF in_line_Type_code ='LINE' and in_status_code in
3252: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3253: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3254: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3255: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3256: and in_price_flag IN ('Y','P')
3257: --we do not want to go in this loop if price_flag is set up 'N' because
3258: --engine doesn't look at the line and will not return adjustments. In this
3259: --case we DON't want to remove the adjustments that engine doesn't return.

Line 3314: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,

3310:
3311:
3312: ELSIF -- Process header level adjustments
3313: in_line_type_code ='ORDER' and
3314: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
3315: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3316: --In this case even engine doesn't update the order (status = UNCHANGED)
3317: --because of one of the lined is frozen,
3318: --there can be some order level adjustments in database which

Line 3315: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

3311:
3312: ELSIF -- Process header level adjustments
3313: in_line_type_code ='ORDER' and
3314: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
3315: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3316: --In this case even engine doesn't update the order (status = UNCHANGED)
3317: --because of one of the lined is frozen,
3318: --there can be some order level adjustments in database which
3319: --need to be pulled out by append_adjustment_lines routine

Line 3320: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))

3316: --In this case even engine doesn't update the order (status = UNCHANGED)
3317: --because of one of the lined is frozen,
3318: --there can be some order level adjustments in database which
3319: --need to be pulled out by append_adjustment_lines routine
3320: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
3321: Then
3322: IF l_debug_level > 0 THEN
3323: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
3324: END IF;