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.QP_PRICE_BOOK_UTIL dependencies on QP_UTIL

Line 914: l_pricing_status := QP_UTIL.Get_QP_Status;

910:
911: END IF; --If pricing perspective is PO
912:
913: --Get Pricing Status - Basic Pricing or Advanced Pricing
914: l_pricing_status := QP_UTIL.Get_QP_Status;
915:
916: --Check if price_book_type_code is valid
917: IF p_pb_input_header_rec.price_book_type_code IS NULL THEN
918: x_return_status := 'E';

Line 1578: AND organization_id = QP_UTIL.Get_Item_Validation_Org

1574: INTO l_count
1575: FROM mtl_system_items_kfv
1576: WHERE inventory_item_id =
1577: to_number(p_pb_input_header_rec.product_attr_value)
1578: AND organization_id = QP_UTIL.Get_Item_Validation_Org
1579: AND purchasing_enabled_flag =
1580: decode(p_pb_input_header_rec.pricing_perspective_code,
1581: 'PO', 'Y', purchasing_enabled_flag)
1582: AND rownum = 1;

Line 1672: QP_UTIL.get_item_cat_info(

1668: l_pte_code := 'ORDFUL';
1669: END;
1670:
1671: --Check if category is valid using Product Hierarchy validation API
1672: QP_UTIL.get_item_cat_info(
1673: p_item_id => to_number(p_pb_input_header_rec.product_attr_value),
1674: --category_id
1675: p_item_pte => l_pte_code,
1676: p_item_ss => null, --all source systems in the pte

Line 2019: QP_UTIL_PUB.Validate_Price_list_Curr_code (

2015: --Check if currency_code is valid
2016: IF p_pb_input_header_rec.limit_products_by = 'PRICE_LIST' AND
2017: p_pb_input_header_rec.pl_agr_bsa_id IS NOT NULL
2018: THEN
2019: QP_UTIL_PUB.Validate_Price_list_Curr_code (
2020: l_price_list_id => p_pb_input_header_rec.pl_agr_bsa_id,
2021: l_currency_code => p_pb_input_header_rec.currency_code,
2022: l_pricing_effective_date => p_pb_input_header_rec.effective_date,
2023: l_validate_result => l_valid_currency);

Line 2236: NOT QP_UTIL.value_exists(l_valueset_id,

2232: l_datatype := v_valueset_dr.format_type;
2233:
2234: IF (v_valueset_r.validation_type = 'I') AND
2235: --Validation type is independent
2236: NOT QP_UTIL.value_exists(l_valueset_id,
2237: p_pb_input_lines_tbl(j).attribute_value)
2238: OR (v_valueset_r.validation_type = 'F') AND
2239: --Validation type is table
2240: NOT QP_UTIL.value_exists_in_table(v_valueset_r.table_info,

Line 2240: NOT QP_UTIL.value_exists_in_table(v_valueset_r.table_info,

2236: NOT QP_UTIL.value_exists(l_valueset_id,
2237: p_pb_input_lines_tbl(j).attribute_value)
2238: OR (v_valueset_r.validation_type = 'F') AND
2239: --Validation type is table
2240: NOT QP_UTIL.value_exists_in_table(v_valueset_r.table_info,
2241: p_pb_input_lines_tbl(j).attribute_value, l_id, l_value)
2242: OR ((v_valueset_r.validation_type = 'N') OR
2243: l_datatype in( 'N','X','Y')) AND
2244: --added for handling of dates/number in multilingual envs.

Line 2245: QP_UTIL.validate_num_date(l_datatype,

2241: p_pb_input_lines_tbl(j).attribute_value, l_id, l_value)
2242: OR ((v_valueset_r.validation_type = 'N') OR
2243: l_datatype in( 'N','X','Y')) AND
2244: --added for handling of dates/number in multilingual envs.
2245: QP_UTIL.validate_num_date(l_datatype,
2246: p_pb_input_lines_tbl(j).attribute_value) <> 0
2247: THEN
2248: x_return_status := 'E';
2249: FND_MESSAGE.SET_NAME('QP', 'QP_INVALID_ATTRIBUTE');

Line 2682: WHERE organization_id = QP_UTIL.Get_Item_Validation_Org;

2678: BEGIN
2679: SELECT master_organization_id
2680: INTO l_master_org
2681: FROM mtl_parameters
2682: WHERE organization_id = QP_UTIL.Get_Item_Validation_Org;
2683: END;
2684:
2685: --Per M. Antyakula of INV team specifying master org filter as well in
2686: --the query below will ensure that a unique customer_item_number is selected.

Line 2733: WHERE organization_id = QP_UTIL.Get_Item_Validation_Org;

2729: BEGIN
2730: SELECT master_organization_id
2731: INTO l_master_org
2732: FROM mtl_parameters
2733: WHERE organization_id = QP_UTIL.Get_Item_Validation_Org;
2734: END;
2735:
2736: --Per M. Antyakula of INV team specifying master org filter as well in
2737: --the query below will ensure that a unique record is selected.

Line 2797: l_attribute_value := QP_UTIL.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',

2793: return varchar2 is
2794: l_attribute_value varchar2(240) := Null; --8721800
2795: begin
2796: if p_attribute_type = 'QUALIFIER' then
2797: l_attribute_value := QP_UTIL.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER',
2798: p_context,
2799: p_attribute,
2800: p_attribute_value,
2801: p_comparison_operator);

Line 2817: l_attribute_value := QP_UTIL.Get_Attribute_Value('QP_ATTR_DEFNS_PRICING',

2813: where category_id = to_number(p_attribute_value);
2814: return l_attribute_value;
2815: end;
2816: else
2817: l_attribute_value := QP_UTIL.Get_Attribute_Value('QP_ATTR_DEFNS_PRICING',
2818: p_context,
2819: p_attribute,
2820: p_attribute_value,
2821: p_comparison_operator);

Line 3321: qp_util.get_valueset_id(l_FlexField_Name, p_Context_Code,

3317: l_flexfield_name := 'QP_ATTR_DEFNS_PRICING';
3318: END IF;
3319:
3320: -- get valueset
3321: qp_util.get_valueset_id(l_FlexField_Name, p_Context_Code,
3322: l_segment_code, x_Vsid,
3323: x_Format_Type, x_Validation_Type);
3324:
3325: IF x_Validation_Type IN('F', 'I') AND x_Vsid IS NOT NULL THEN

Line 3629: l_inv_org_id := qp_util.Get_Item_Validation_Org;

3625: IF (l_debug = FND_API.G_TRUE) THEN
3626: QP_PREQ_GRP.engine_debug('l_operating_unit_id:' || l_operating_unit_id);
3627: END IF;
3628:
3629: l_inv_org_id := qp_util.Get_Item_Validation_Org;
3630: IF (l_debug = FND_API.G_TRUE) THEN
3631: QP_PREQ_GRP.engine_debug('l_inv_org_id:' || l_inv_org_id);
3632: END IF;
3633: