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 888: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

884:
885: procedure copy_Header_to_request(
886: p_request_type_code in varchar2
887: ,p_calculate_price_flag in varchar2
888: ,px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
889: ) is
890:
891: l_line_index pls_integer := 0;
892:

Line 941: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE

937:
938: END copy_Header_to_request;
939:
940: PROCEDURE copy_Line_to_request(
941: px_req_line_tbl in out nocopy QP_PREQ_GRP.LINE_TBL_TYPE
942: ,p_pricing_event in varchar2
943: ,p_Request_Type_Code in varchar2
944: ,p_honor_price_flag in VARCHAR2 Default 'Y'
945: ) IS

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

1031:
1032: END copy_Line_to_request;
1033:
1034: PROCEDURE set_pricing_control_record (
1035: l_Control_Rec in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.CONTROL_RECORD_TYPE
1036: ,in_pricing_event in varchar2)IS
1037:
1038: --
1039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

1044: l_control_rec.gsa_check_flag := 'Y';
1045: l_control_rec.gsa_dup_check_flag := 'Y';
1046:
1047:
1048: l_control_rec.calculate_flag := QP_PREQ_GRP.G_SEARCH_N_CALCULATE;
1049: l_control_rec.simulation_flag :='Y';
1050: l_control_rec.pricing_event := in_pricing_Event;
1051: -- l_control_rec.temp_table_insert_flag := 'N';
1052: l_control_rec.check_cust_view_flag := 'Y';

Line 1068: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

1064: PROCEDURE build_context_for_line(
1065: p_req_line_tbl_count in number,
1066: p_price_request_code in varchar2,
1067: p_item_type_code in varchar2,
1068: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1069: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1070: )IS
1071:
1072: qp_attr_mapping_error exception;

Line 1069: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1065: p_req_line_tbl_count in number,
1066: p_price_request_code in varchar2,
1067: p_item_type_code in varchar2,
1068: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1069: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1070: )IS
1071:
1072: qp_attr_mapping_error exception;
1073: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 1154: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

1150: END build_context_for_line;
1151:
1152: PROCEDURE copy_attribs_to_Req(
1153: p_line_index number
1154: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1155: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1156: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1157: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1158: ) IS

Line 1155: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1151:
1152: PROCEDURE copy_attribs_to_Req(
1153: p_line_index number
1154: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1155: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1156: ,p_pricing_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1157: ,p_qualifier_contexts_Tbl in out nocopy QP_Attr_Mapping_PUB.Contexts_Result_Tbl_Type
1158: ) IS
1159:

Line 1230: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

1226: PROCEDURE build_context_for_header(
1227: p_req_line_tbl_count in number,
1228: p_price_request_code in varchar2,
1229: p_item_type_code in varchar2,
1230: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1231: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1232: )IS
1233:
1234: qp_attr_mapping_error exception;

Line 1231: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1227: p_req_line_tbl_count in number,
1228: p_price_request_code in varchar2,
1229: p_item_type_code in varchar2,
1230: p_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
1231: p_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1232: )IS
1233:
1234: qp_attr_mapping_error exception;
1235: l_org_id Number:= OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

Line 1345: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE

1341: procedure Append_attributes(
1342: p_header_id number default null
1343: ,p_Line_id number default null
1344: ,p_line_index number
1345: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1346: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1347: ) is
1348:
1349: i pls_integer;

Line 1346: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE

1342: p_header_id number default null
1343: ,p_Line_id number default null
1344: ,p_line_index number
1345: ,px_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE
1346: ,px_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE
1347: ) is
1348:
1349: i pls_integer;
1350:

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

2268:
2269: END Append_attributes;
2270:
2271: PROCEDURE price_item(
2272: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

Line 2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,

2269: END Append_attributes;
2270:
2271: PROCEDURE price_item(
2272: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

Line 2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,

2270:
2271: PROCEDURE price_item(
2272: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2278: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

Line 2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,

2271: PROCEDURE price_item(
2272: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2278: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2279: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,

Line 2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,

2272: out_req_line_tbl in out NOCOPY /* file.sql.39 change */ QP_PREQ_GRP.LINE_TBL_TYPE,
2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2278: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2279: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
2280: in_related_item_id in number,

Line 2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,

2273: out_Req_line_attr_tbl in out nocopy QP_PREQ_GRP.LINE_ATTR_TBL_TYPE,
2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2278: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2279: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
2280: in_related_item_id in number,
2281: in_qty in number,

Line 2278: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,

2274: out_Req_LINE_DETAIL_attr_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE,
2275: out_Req_LINE_DETAIL_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE,
2276: out_Req_related_lines_tbl in out nocopy QP_PREQ_GRP.RELATED_LINES_TBL_TYPE,
2277: out_Req_qual_tbl in out nocopy QP_PREQ_GRP.QUAL_TBL_TYPE,
2278: out_Req_LINE_DETAIL_qual_tbl in out nocopy QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE,
2279: out_child_detail_type out NOCOPY /* file.sql.39 change */ varchar2,
2280: in_related_item_id in number,
2281: in_qty in number,
2282: in_uom in varchar2,

Line 2400: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;

2396: ) IS
2397:
2398: l_return_status varchar2(10);
2399: l_return_status_Text varchar2(240) ;
2400: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

Line 2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;

2397:
2398: l_return_status varchar2(10);
2399: l_return_status_Text varchar2(240) ;
2400: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

Line 2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;

2398: l_return_status varchar2(10);
2399: l_return_status_Text varchar2(240) ;
2400: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

Line 2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;

2399: l_return_status_Text varchar2(240) ;
2400: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

Line 2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;

2400: l_Control_Rec QP_PREQ_GRP.CONTROL_RECORD_TYPE;
2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2408:

Line 2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;

2401: l_req_line_tbl QP_PREQ_GRP.LINE_TBL_TYPE;
2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2408:
2409: --

Line 2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;

2402: l_Req_qual_tbl QP_PREQ_GRP.QUAL_TBL_TYPE;
2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2408:
2409: --
2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;

2403: l_Req_line_attr_tbl QP_PREQ_GRP.LINE_ATTR_TBL_TYPE;
2404: l_Req_LINE_DETAIL_tbl QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
2405: l_Req_LINE_DETAIL_qual_tbl QP_PREQ_GRP.LINE_DETAIL_QUAL_TBL_TYPE;
2406: l_Req_LINE_DETAIL_attr_tbl QP_PREQ_GRP.LINE_DETAIL_ATTR_TBL_TYPE;
2407: l_Req_related_lines_tbl QP_PREQ_GRP.RELATED_LINES_TBL_TYPE;
2408:
2409: --
2410: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2411: --

Line 2538: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;

2534: /*4163551*/
2535: g_header_id := in_header_id;
2536: /*4163551*/
2537:
2538: out_child_detail_type := qp_preq_grp.G_CHILD_DETAIL_TYPE;
2539:
2540: /*4163551*/
2541: set_pricing_control_record (
2542: l_Control_Rec => l_control_rec

Line 2596: QP_PREQ_GRP.PRICE_REQUEST

2592:
2593: IF l_debug_level > 0 THEN
2594: print_time('Calling PE');
2595: END IF;
2596: QP_PREQ_GRP.PRICE_REQUEST
2597: (p_control_rec =>l_control_rec
2598: ,p_line_tbl =>l_Req_line_tbl
2599: ,p_qual_tbl =>l_Req_qual_tbl
2600: ,p_line_attr_tbl =>l_Req_line_attr_tbl

Line 3119: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,

3115: END IF;
3116:
3117:
3118: IF in_line_Type_code ='LINE' and
3119: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,

Line 3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,

3116:
3117:
3118: IF in_line_Type_code ='LINE' and
3119: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,

Line 3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,

3117:
3118: IF in_line_Type_code ='LINE' and
3119: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

Line 3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,

3118: IF in_line_Type_code ='LINE' and
3119: in_status_code in ( QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST,
3120: QP_PREQ_GRP.G_STS_LHS_NOT_FOUND,
3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

Line 3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,

3121: QP_PREQ_GRP.G_STATUS_FORMULA_ERROR,
3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

Line 3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,

3122: QP_PREQ_GRP.G_STATUS_OTHER_ERRORS,
3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

Line 3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,

3123: FND_API.G_RET_STS_UNEXP_ERROR,
3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3131: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

Line 3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,

3124: FND_API.G_RET_STS_ERROR,
3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3131: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3132: then

Line 3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,

3125: QP_PREQ_GRP.G_STATUS_CALC_ERROR,
3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3131: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3132: then
3133:

Line 3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,

3126: QP_PREQ_GRP.G_STATUS_UOM_FAILURE,
3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3131: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3132: then
3133:
3134: l_return_status := 'E';

Line 3131: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)

3127: QP_PREQ_GRP.G_STATUS_INVALID_UOM,
3128: QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST,
3129: QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV,
3130: QP_PREQ_GRP.G_STATUS_INVALID_INCOMP,
3131: QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR)
3132: then
3133:
3134: l_return_status := 'E';
3135:

Line 3146: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then

3142: l_price_list := in_price_list_id;
3143: End;
3144: END IF;
3145:
3146: IF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_PRICE_LIST then
3147:
3148: IF l_debug_level > 0 THEN
3149: oe_debug_pub.add( 'INVALID PRICE LIST'|| ' PRICE_LIST_ID='||G_PRICE_LIST_ID ) ;
3150: END IF;

Line 3172: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then

3168: OE_MSG_PUB.Add;
3169:
3170: END IF;
3171:
3172: ELSIF in_status_code = QP_PREQ_GRP.G_STS_LHS_NOT_FOUND Then
3173:
3174: FND_MESSAGE.SET_NAME('ONT','ONT_NO_PRICE_LIST_FOUND');
3175: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3176: FND_MESSAGE.SET_TOKEN('UOM',in_uom);

Line 3179: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then

3175: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3176: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3177: OE_MSG_PUB.Add;
3178:
3179: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_FORMULA_ERROR then
3180: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3181: OE_MSG_PUB.Add;
3182:
3183: ELSIF in_status_code in

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

3180: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_ERROR_IN_FORMULA');
3181: OE_MSG_PUB.Add;
3182:
3183: ELSIF in_status_code in
3184: ( QP_PREQ_GRP.G_STATUS_OTHER_ERRORS , FND_API.G_RET_STS_UNEXP_ERROR,
3185: FND_API.G_RET_STS_ERROR) then
3186: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3187: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3188: OE_MSG_PUB.Add;

Line 3190: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then

3186: FND_MESSAGE.SET_NAME('ONT','ONT_PRICING_ERRORS');
3187: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3188: OE_MSG_PUB.Add;
3189:
3190: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM then
3191: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM');
3192: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3193: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3194: OE_MSG_PUB.Add;

Line 3196: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then

3192: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3193: FND_MESSAGE.SET_TOKEN('UOM',in_uom);
3194: OE_MSG_PUB.Add;
3195:
3196: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_DUP_PRICE_LIST then
3197: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
3198:
3199: IF l_debug_level > 0 THEN
3200: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;

Line 3240: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then

3236:
3237: FND_MESSAGE.SET_TOKEN('PRICE_LIST2',l_price_list);
3238: OE_MSG_PUB.Add;
3239:
3240: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_UOM_CONV then
3241: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_UOM_CONVERSION');
3242: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3243: in_status_text);
3244: OE_MSG_PUB.Add;

Line 3246: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then

3242: FND_MESSAGE.SET_TOKEN('UOM_TEXT','( '||in_Ordered_Item||' ) '||
3243: in_status_text);
3244: OE_MSG_PUB.Add;
3245:
3246: ElSIF in_status_code = QP_PREQ_GRP.G_STATUS_INVALID_INCOMP then
3247: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_INVALID_INCOMP');
3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3249: in_status_text);
3250: OE_MSG_PUB.Add;

Line 3252: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then

3248: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||
3249: in_status_text);
3250: OE_MSG_PUB.Add;
3251:
3252: ELSIF in_status_code = QP_PREQ_GRP.G_STATUS_BEST_PRICE_EVAL_ERROR then
3253: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_BEST_PRICE_ERROR');
3254: FND_MESSAGE.SET_TOKEN('ITEM',in_Ordered_Item);
3255: FND_MESSAGE.SET_TOKEN('ERR_TEXT',in_status_text);
3256: OE_MSG_PUB.Add;

Line 3276: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then

3272: l_return_status := 'E';
3273: --RAISE FND_API.G_EXC_ERROR;*/
3274:
3275: ELSIF in_line_Type_code ='LINE' and
3276: in_status_code = QP_PREQ_GRP.G_STATUS_OTHER_ERRORS Then
3277:
3278: IF l_debug_level > 0 THEN
3279: oe_debug_pub.add( 'OE_PRICING_ERROR' ) ;
3280: END IF;

Line 3286: --( QP_PREQ_GRP.G_STATUS_UPDATED,

3282: FND_MESSAGE.SET_TOKEN('ERR_TEXT','( '||in_Ordered_Item||' ) '||in_STATUS_TEXT);
3283: OE_MSG_PUB.Add;
3284:
3285: ELSIF in_line_Type_code ='LINE' and in_status_code in
3286: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3287: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3288: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3289: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3290: and in_price_flag IN ('Y','P')

Line 3287: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and

3283: OE_MSG_PUB.Add;
3284:
3285: ELSIF in_line_Type_code ='LINE' and in_status_code in
3286: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3287: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3288: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3289: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3290: and in_price_flag IN ('Y','P')
3291: --we do not want to go in this loop if price_flag is set up 'N' because

Line 3288: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and

3284:
3285: ELSIF in_line_Type_code ='LINE' and in_status_code in
3286: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3287: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3288: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3289: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3290: and in_price_flag IN ('Y','P')
3291: --we do not want to go in this loop if price_flag is set up 'N' because
3292: --engine doesn't look at the line and will not return adjustments. In this

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

3285: ELSIF in_line_Type_code ='LINE' and in_status_code in
3286: --( QP_PREQ_GRP.G_STATUS_UPDATED,
3287: (QP_PREQ_GRP.G_STATUS_GSA_VIOLATION) and
3288: -- QP_PREQ_GRP.G_STATUS_UNCHANGED) and
3289: nvl(in_process_code,'0') <> QP_PREQ_GRP.G_BY_ENGINE
3290: and in_price_flag IN ('Y','P')
3291: --we do not want to go in this loop if price_flag is set up 'N' because
3292: --engine doesn't look at the line and will not return adjustments. In this
3293: --case we DON't want to remove the adjustments that engine doesn't return.

Line 3348: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,

3344:
3345:
3346: ELSIF -- Process header level adjustments
3347: in_line_type_code ='ORDER' and
3348: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
3349: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3350: --In this case even engine doesn't update the order (status = UNCHANGED)
3351: --because of one of the lined is frozen,
3352: --there can be some order level adjustments in database which

Line 3349: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)

3345:
3346: ELSIF -- Process header level adjustments
3347: in_line_type_code ='ORDER' and
3348: (in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
3349: QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
3350: --In this case even engine doesn't update the order (status = UNCHANGED)
3351: --because of one of the lined is frozen,
3352: --there can be some order level adjustments in database which
3353: --need to be pulled out by append_adjustment_lines routine

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

3350: --In this case even engine doesn't update the order (status = UNCHANGED)
3351: --because of one of the lined is frozen,
3352: --there can be some order level adjustments in database which
3353: --need to be pulled out by append_adjustment_lines routine
3354: or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
3355: Then
3356: IF l_debug_level > 0 THEN
3357: oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
3358: END IF;