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_UTIL_PUB dependencies on QP_UTIL

Line 1: PACKAGE BODY Qp_Util_Pub AS

1: PACKAGE BODY Qp_Util_Pub AS
2: /* $Header: QPXRTCNB.pls 120.19.12020000.3 2012/12/19 07:24:38 smbalara ship $ */
3:
4: l_debug VARCHAR2(3);
5: /************************************************************************

Line 587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;

583: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
584: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
585: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
586: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
587: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
588: l_dummy VARCHAR2(1);
589: BEGIN
590: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
591: l_dummy := NULL;

Line 831: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;

827: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
828: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
829: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
830: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
831: l_order_status_rec QP_UTIL_PUB.ORDER_LINES_STATUS_REC_TYPE;
832: l_dummy VARCHAR2(1);
833: x_pass_all_lines varchar2(1):='Y'; -- 9251187
834: l_QP_CUSTOM_HOOK4_ADV_MOD varchar2(1):=nvl(fnd_profile.value('QP_CUSTOM_HOOK_ADV_MOD'),'N'); -- 9251187
835: BEGIN

Line 1275: l_org_id NUMBER := Qp_Util.get_org_id;

1271:
1272: l_temp_date DATE;
1273: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
1274: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
1275: l_org_id NUMBER := Qp_Util.get_org_id;
1276: l_cust_relation_flag VARCHAR2(30);
1277: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);
1278:
1279: CURSOR c_price_list_multi

Line 1622: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_List BEGIN ');

1618: l_cust_relation_flag := '';
1619: END IF;
1620: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1621: IF l_debug = Fnd_Api.G_TRUE THEN
1622: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_List BEGIN ');
1623: Oe_Debug_Pub.ADD('l_currency_code = ' || l_currency_code);
1624: Oe_Debug_Pub.ADD('l_pricing_effective_date = ' ||l_pricing_effective_date);
1625: Oe_Debug_Pub.ADD('l_agreement_id = ' || l_agreement_id);
1626:

Line 1770: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_Lists BEGIN ');

1766: BEGIN
1767:
1768: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1769: IF l_debug = Fnd_Api.G_TRUE THEN
1770: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_Lists BEGIN ');
1771: Oe_Debug_Pub.ADD('p_currency_code = ' || p_currency_code);
1772: END IF;
1773:
1774: l_temp_date := TRUNC(SYSDATE);

Line 1975: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Agreement BEGIN ');

1971: l_agreement c_agreement%ROWTYPE;
1972: l_counter NUMBER := 0;
1973:
1974: BEGIN
1975: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Agreement BEGIN ');
1976: Oe_Debug_Pub.ADD('p_pricing_effective_date = ' ||p_pricing_effective_date);
1977:
1978: IF p_pricing_effective_date IS NULL THEN
1979: l_temp_date := TRUNC(SYSDATE);

Line 2135: Oe_Debug_Pub.ADD('BEGIN qp_util_pub.get_rounding_factor');

2131: l_status_code VARCHAR2(1);
2132: BEGIN
2133: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2134: IF l_debug = Fnd_Api.G_TRUE THEN
2135: Oe_Debug_Pub.ADD('BEGIN qp_util_pub.get_rounding_factor');
2136: Oe_Debug_Pub.ADD('p_use_multi_currency = ' || p_use_multi_currency);
2137: Oe_Debug_Pub.ADD('p_price_list_id = ' || p_price_list_id);
2138: Oe_Debug_Pub.ADD('p_currency_code = ' || p_currency_code);
2139: Oe_Debug_Pub.ADD('p_pricing_effective_date = ' || p_pricing_effective_date);

Line 2159: Oe_Debug_Pub.ADD('END qp_util_pub.get_rounding_factor');

2155: END IF;
2156: IF l_debug = Fnd_Api.G_TRUE THEN
2157: Oe_Debug_Pub.ADD('l_rounding_factor = ' || l_rounding_factor);
2158: Oe_Debug_Pub.ADD('l_status_code = ' || l_status_code);
2159: Oe_Debug_Pub.ADD('END qp_util_pub.get_rounding_factor');
2160:
2161: END IF;
2162: RETURN(l_rounding_factor);
2163:

Line 2528: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Reprice_Debug_Engine_Request BEGIN');

2524: I NUMBER;
2525: BEGIN
2526: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2527: IF l_debug = Fnd_Api.G_TRUE THEN
2528: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Reprice_Debug_Engine_Request BEGIN');
2529: Oe_Debug_Pub.ADD('p_request_id = ' || p_request_id);
2530: END IF;
2531: --dbms_output.put_line('Reprice_Debug_Engine_Request Begins');
2532:

Line 2536: x_return_status_text := 'Routine: QP_UTIL_PUB.Reprice_Debug_Engine_Request SUCCESS';

2532:
2533: /* profile settings */
2534: Fnd_Profile.PUT('QP_DEBUG','Y');
2535: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2536: x_return_status_text := 'Routine: QP_UTIL_PUB.Reprice_Debug_Engine_Request SUCCESS';
2537:
2538: IF ( p_request_id IS NULL) THEN
2539: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2540: x_return_status_text := 'Need request_id for Reprice_Debug_Engine_Request API';

Line 2798: x_return_status_text := 'Routine: QP_UTIL_PUB.Reprice_Debug_Engine_Request ERROR'||SQLERRM;

2794:
2795: EXCEPTION
2796: WHEN OTHERS THEN
2797: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2798: x_return_status_text := 'Routine: QP_UTIL_PUB.Reprice_Debug_Engine_Request ERROR'||SQLERRM;
2799: END Reprice_Debug_Engine_Request;
2800:
2801: -- New procedure as per bug 2943038, required by Quoting
2802: PROCEDURE Get_Price_List_Currency

Line 2896: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_PRICING',

2892: FOR i IN 1..p_attributes_tbl.COUNT
2893: LOOP
2894: -- find context text
2895: IF p_attributes_tbl(i).attribute_type IN ('PRODUCT', 'PRICING') THEN
2896: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_PRICING',
2897: p_attributes_tbl(i).context_code);
2898: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2899: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_QUALIFIER',
2900: p_attributes_tbl(i).context_code);

Line 2899: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_QUALIFIER',

2895: IF p_attributes_tbl(i).attribute_type IN ('PRODUCT', 'PRICING') THEN
2896: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_PRICING',
2897: p_attributes_tbl(i).context_code);
2898: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2899: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_QUALIFIER',
2900: p_attributes_tbl(i).context_code);
2901: END IF;
2902:
2903: -- find attribute text

Line 2905: Qp_Util.Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_PRICING',

2901: END IF;
2902:
2903: -- find attribute text
2904: IF p_attributes_tbl(i).attribute_type IN ('PRODUCT', 'PRICING') THEN
2905: Qp_Util.Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_PRICING',
2906: p_Context_Name => p_attributes_tbl(i).context_code,
2907: p_attribute => p_attributes_tbl(i).attribute_code,
2908: x_attribute_code => p_attributes_tbl(i).attribute_text,
2909: x_segment_name => l_segment_code);

Line 2911: Qp_Util.Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',

2907: p_attribute => p_attributes_tbl(i).attribute_code,
2908: x_attribute_code => p_attributes_tbl(i).attribute_text,
2909: x_segment_name => l_segment_code);
2910: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2911: Qp_Util.Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
2912: p_Context_Name => p_attributes_tbl(i).context_code,
2913: p_attribute => p_attributes_tbl(i).attribute_code,
2914: x_attribute_code => p_attributes_tbl(i).attribute_text,
2915: x_segment_name => l_segment_code);

Line 2929: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_PRICING'

2925: );
2926:
2927: ELSIF p_attributes_tbl(i).attribute_type = 'PRICING' THEN
2928: p_attributes_tbl(i).attribute_value_from_text :=
2929: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_PRICING'
2930: ,p_attributes_tbl(i).context_code
2931: ,p_attributes_tbl(i).attribute_code
2932: ,p_attributes_tbl(i).attribute_value_from
2933: ,p_attributes_tbl(i).operator

Line 2937: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER'

2933: ,p_attributes_tbl(i).operator
2934: );
2935: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2936: p_attributes_tbl(i).attribute_value_from_text :=
2937: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER'
2938: ,p_attributes_tbl(i).context_code
2939: ,p_attributes_tbl(i).attribute_code
2940: ,p_attributes_tbl(i).attribute_value_from
2941: ,p_attributes_tbl(i).operator

Line 3393: END Qp_Util_Pub;

3389: x_status:='N';
3390: END IF;
3391: END Flex_Enabled_Status;
3392:
3393: END Qp_Util_Pub;