DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on QP_UTIL_PUB

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 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 3393: END Qp_Util_Pub;

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