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.9.12010000.5 2008/11/25 23:40:11 rbadadar ship $ */
3:
4: l_debug VARCHAR2(3);
5: /************************************************************************

Line 519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;

515: l_line_group_exists QP_PRICING_PHASES.LINE_GROUP_EXISTS%TYPE :='U';
516: l_oid_exists QP_PRICING_PHASES.OID_EXISTS%TYPE :='U';
517: l_rltd_exists QP_PRICING_PHASES.RLTD_EXISTS%TYPE :='U';
518: l_list_line_type QP_LIST_LINES.LIST_LINE_TYPE_CODE%TYPE :='XXX';
519: l_order_status_rec Qp_Util_Pub.ORDER_LINES_STATUS_REC_TYPE;
520: l_dummy VARCHAR2(1);
521: BEGIN
522: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
523: l_dummy := NULL;

Line 945: l_org_id NUMBER := Qp_Util.get_org_id;

941:
942: l_temp_date DATE;
943: --passing null org_id to OE_Sys_Parameters for moac so that it will return CUSTOMER_RELATIONSHIPS_FLAG
944: --for the org_context set -- build_contexts API or calling app would have set 'single' org context
945: l_org_id NUMBER := Qp_Util.get_org_id;
946: l_cust_relation_flag VARCHAR2(30);
947: --OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG', l_org_id);
948:
949: CURSOR c_price_list_multi

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

1288: l_cust_relation_flag := '';
1289: END IF;
1290: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1291: IF l_debug = Fnd_Api.G_TRUE THEN
1292: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_List BEGIN ');
1293: Oe_Debug_Pub.ADD('l_currency_code = ' || l_currency_code);
1294: Oe_Debug_Pub.ADD('l_pricing_effective_date = ' ||l_pricing_effective_date);
1295: Oe_Debug_Pub.ADD('l_agreement_id = ' || l_agreement_id);
1296:

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

1436: BEGIN
1437:
1438: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1439: IF l_debug = Fnd_Api.G_TRUE THEN
1440: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Price_Lists BEGIN ');
1441: Oe_Debug_Pub.ADD('p_currency_code = ' || p_currency_code);
1442: END IF;
1443:
1444: l_temp_date := TRUNC(SYSDATE);

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

1641: l_agreement c_agreement%ROWTYPE;
1642: l_counter NUMBER := 0;
1643:
1644: BEGIN
1645: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Get_Agreement BEGIN ');
1646: Oe_Debug_Pub.ADD('p_pricing_effective_date = ' ||p_pricing_effective_date);
1647:
1648: IF p_pricing_effective_date IS NULL THEN
1649: l_temp_date := TRUNC(SYSDATE);

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

1801: l_status_code VARCHAR2(1);
1802: BEGIN
1803: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
1804: IF l_debug = Fnd_Api.G_TRUE THEN
1805: Oe_Debug_Pub.ADD('BEGIN qp_util_pub.get_rounding_factor');
1806: Oe_Debug_Pub.ADD('p_use_multi_currency = ' || p_use_multi_currency);
1807: Oe_Debug_Pub.ADD('p_price_list_id = ' || p_price_list_id);
1808: Oe_Debug_Pub.ADD('p_currency_code = ' || p_currency_code);
1809: Oe_Debug_Pub.ADD('p_pricing_effective_date = ' || p_pricing_effective_date);

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

1825: END IF;
1826: IF l_debug = Fnd_Api.G_TRUE THEN
1827: Oe_Debug_Pub.ADD('l_rounding_factor = ' || l_rounding_factor);
1828: Oe_Debug_Pub.ADD('l_status_code = ' || l_status_code);
1829: Oe_Debug_Pub.ADD('END qp_util_pub.get_rounding_factor');
1830:
1831: END IF;
1832: RETURN(l_rounding_factor);
1833:

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

2194: I NUMBER;
2195: BEGIN
2196: l_debug := Qp_Preq_Grp.G_DEBUG_ENGINE;
2197: IF l_debug = Fnd_Api.G_TRUE THEN
2198: Oe_Debug_Pub.ADD('QP_UTIL_PUB.Reprice_Debug_Engine_Request BEGIN');
2199: Oe_Debug_Pub.ADD('p_request_id = ' || p_request_id);
2200: END IF;
2201: --dbms_output.put_line('Reprice_Debug_Engine_Request Begins');
2202:

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

2202:
2203: /* profile settings */
2204: Fnd_Profile.PUT('QP_DEBUG','Y');
2205: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2206: x_return_status_text := 'Routine: QP_UTIL_PUB.Reprice_Debug_Engine_Request SUCCESS';
2207:
2208: IF ( p_request_id IS NULL) THEN
2209: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2210: x_return_status_text := 'Need request_id for Reprice_Debug_Engine_Request API';

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

2464:
2465: EXCEPTION
2466: WHEN OTHERS THEN
2467: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2468: x_return_status_text := 'Routine: QP_UTIL_PUB.Reprice_Debug_Engine_Request ERROR'||SQLERRM;
2469: END Reprice_Debug_Engine_Request;
2470:
2471: -- New procedure as per bug 2943038, required by Quoting
2472: PROCEDURE Get_Price_List_Currency

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

2562: FOR i IN 1..p_attributes_tbl.COUNT
2563: LOOP
2564: -- find context text
2565: IF p_attributes_tbl(i).attribute_type IN ('PRODUCT', 'PRICING') THEN
2566: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_PRICING',
2567: p_attributes_tbl(i).context_code);
2568: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2569: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_QUALIFIER',
2570: p_attributes_tbl(i).context_code);

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

2565: IF p_attributes_tbl(i).attribute_type IN ('PRODUCT', 'PRICING') THEN
2566: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_PRICING',
2567: p_attributes_tbl(i).context_code);
2568: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2569: p_attributes_tbl(i).context_text := Qp_Util.get_context('QP_ATTR_DEFNS_QUALIFIER',
2570: p_attributes_tbl(i).context_code);
2571: END IF;
2572:
2573: -- find attribute text

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

2571: END IF;
2572:
2573: -- find attribute text
2574: IF p_attributes_tbl(i).attribute_type IN ('PRODUCT', 'PRICING') THEN
2575: Qp_Util.Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_PRICING',
2576: p_Context_Name => p_attributes_tbl(i).context_code,
2577: p_attribute => p_attributes_tbl(i).attribute_code,
2578: x_attribute_code => p_attributes_tbl(i).attribute_text,
2579: x_segment_name => l_segment_code);

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

2577: p_attribute => p_attributes_tbl(i).attribute_code,
2578: x_attribute_code => p_attributes_tbl(i).attribute_text,
2579: x_segment_name => l_segment_code);
2580: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2581: Qp_Util.Get_Attribute_Code(p_FlexField_Name => 'QP_ATTR_DEFNS_QUALIFIER',
2582: p_Context_Name => p_attributes_tbl(i).context_code,
2583: p_attribute => p_attributes_tbl(i).attribute_code,
2584: x_attribute_code => p_attributes_tbl(i).attribute_text,
2585: x_segment_name => l_segment_code);

Line 2599: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_PRICING'

2595: );
2596:
2597: ELSIF p_attributes_tbl(i).attribute_type = 'PRICING' THEN
2598: p_attributes_tbl(i).attribute_value_from_text :=
2599: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_PRICING'
2600: ,p_attributes_tbl(i).context_code
2601: ,p_attributes_tbl(i).attribute_code
2602: ,p_attributes_tbl(i).attribute_value_from
2603: ,p_attributes_tbl(i).operator

Line 2607: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER'

2603: ,p_attributes_tbl(i).operator
2604: );
2605: ELSIF p_attributes_tbl(i).attribute_type = 'QUALIFIER' THEN
2606: p_attributes_tbl(i).attribute_value_from_text :=
2607: Qp_Util.Get_Attribute_Value('QP_ATTR_DEFNS_QUALIFIER'
2608: ,p_attributes_tbl(i).context_code
2609: ,p_attributes_tbl(i).attribute_code
2610: ,p_attributes_tbl(i).attribute_value_from
2611: ,p_attributes_tbl(i).operator

Line 3063: END Qp_Util_Pub;

3059: x_status:='N';
3060: END IF;
3061: END Flex_Enabled_Status;
3062:
3063: END Qp_Util_Pub;