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_PRICE_BOOK_UTIL

Line 1: PACKAGE BODY qp_price_book_util AS

1: PACKAGE BODY qp_price_book_util AS
2: /*$Header: QPXUPBKB.pls 120.106.12010000.7 2009/11/30 05:04:48 jputta ship $*/
3:
4: --Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PRICE_BOOK_UTIL';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PRICE_BOOK_UTIL';

1: PACKAGE BODY qp_price_book_util AS
2: /*$Header: QPXUPBKB.pls 120.106.12010000.7 2009/11/30 05:04:48 jputta ship $*/
3:
4: --Global constant holding the package name
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'QP_PRICE_BOOK_UTIL';
6:
7: /*****************************************************************************
8: Procedure to insert Price Book related error and warning messages into
9: qp_price_book_messages table.

Line 3424: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.PUBLISH_AND_DELIVER';

3420: IS
3421: L_MAX_STATUS_REQUESTS NUMBER:=240;
3422: L_STATUS_REQUEST_INTERVAL NUMBER:=10; -- seconds
3423: L_TRANSFER_TIMEOUT NUMBER:=3600; -- seconds
3424: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.PUBLISH_AND_DELIVER';
3425: l_output_file VARCHAR2(240);
3426: l_debug VARCHAR2(3);
3427: l_url_servlet_string VARCHAR2(240);
3428: l_url_param_string VARCHAR2(240);

Line 3581: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');

3577: QP_PREQ_GRP.Set_QP_Debug;
3578: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
3579:
3580: IF (l_debug = FND_API.G_TRUE) THEN
3581: QP_PREQ_GRP.engine_debug('ENTERING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG');
3582: END IF;
3583:
3584: IF (l_debug = FND_API.G_TRUE) THEN
3585: QP_PREQ_GRP.engine_debug('With the following parameters:');

Line 3634: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Parameters Initialized';

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:
3634: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Parameters Initialized';
3635: IF (l_debug = FND_API.G_TRUE) THEN
3636: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3637: END IF;
3638:

Line 3665: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : XML Setup Check';

3661: QP_PREQ_GRP.engine_debug('return_code:' || return_code);
3662: QP_PREQ_GRP.engine_debug('errmsg:' || errmsg);
3663: END IF;
3664:
3665: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : XML Setup Check';
3666: IF (l_debug = FND_API.G_TRUE) THEN
3667: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3668: END IF;
3669:

Line 3672: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : No Trading Partner found during XML Setup Check';

3668: END IF;
3669:
3670: IF NOT(result) THEN
3671: -- trading partner not found
3672: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : No Trading Partner found during XML Setup Check';
3673: IF (l_debug = FND_API.G_TRUE) THEN
3674: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3675: END IF;
3676:

Line 3679: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : No Number Limit Specified';

3675: END IF;
3676:
3677: ELSE -- no number specified, send in one message
3678:
3679: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : No Number Limit Specified';
3680: IF (l_debug = FND_API.G_TRUE) THEN
3681: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3682: END IF;
3683:

Line 3697: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Created Unique Key';

3693: QP_PREQ_GRP.engine_debug('l_date:' || l_date);
3694: END IF;
3695: l_canonical_date := FND_DATE.DATE_TO_CANONICAL(l_date);
3696:
3697: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Created Unique Key';
3698: IF (l_debug = FND_API.G_TRUE) THEN
3699: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3700: END IF;
3701:

Line 3734: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Initialize Create Event Parameters';

3730: wf_event.AddParameterToList(p_name => 'DOCUMENT_CREATION_DATE',
3731: p_value => l_canonical_date,
3732: p_parameterlist => l_create_cln_parameter_list);
3733:
3734: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Initialize Create Event Parameters';
3735: IF (l_debug = FND_API.G_TRUE) THEN
3736: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3737: end if;
3738:

Line 3744: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Create Event Raised';

3740: wf_event.raise(p_event_name => l_create_cln_event,
3741: p_event_key => l_event_key,
3742: p_parameters => l_create_cln_parameter_list);
3743:
3744: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Create Event Raised';
3745: IF (l_debug = FND_API.G_TRUE) THEN
3746: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3747: end if;
3748:

Line 3823: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Send Document Event Parameters Initialized';

3819: wf_event.AddParameterToList(p_name => 'ECX_PARAMETER5',
3820: p_value => NULL,
3821: p_parameterlist => l_send_syct_parameter_list);
3822:
3823: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Send Document Event Parameters Initialized';
3824: IF (l_debug = FND_API.G_TRUE) THEN
3825: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3826: END IF;
3827:

Line 3833: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Send Document Event Raised';

3829: wf_event.RAISE(p_event_name => l_send_syct_event,
3830: p_event_key => l_event_key,
3831: p_parameters => l_send_syct_parameter_list);
3832:
3833: x_progress := 'QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG : Send Document Event Raised';
3834: IF (l_debug = FND_API.G_TRUE) THEN
3835: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3836: END IF;
3837:

Line 3841: QP_PREQ_GRP.engine_debug('EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG Successfully');

3837:
3838: END IF;
3839:
3840: IF (l_debug = FND_API.G_TRUE) THEN
3841: QP_PREQ_GRP.engine_debug('EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG Successfully');
3842: END IF;
3843:
3844: x_return_status := FND_API.G_RET_STS_SUCCESS;
3845:

Line 3854: x_progress := 'EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG in Error ';

3850: IF (l_debug = FND_API.G_TRUE) THEN
3851: QP_PREQ_GRP.engine_debug('Exception ' || ':' || l_error_code || ':' || l_error_msg);
3852: END IF;
3853:
3854: x_progress := 'EXITING QP_PRICE_BOOK_UTIL.SEND_SYNC_CATALOG in Error ';
3855: IF (l_debug = FND_API.G_TRUE) THEN
3856: QP_PREQ_GRP.engine_debug('Failure point ' || x_progress);
3857: END IF;
3858: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3880: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.GENERATE_PUBLISH_PRICE_BOOK_WF:';

3876: l_request_id NUMBER;
3877: l_ret_code NUMBER;
3878: l_err_buf VARCHAR2(240);
3879: l_debug VARCHAR2(3);
3880: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.GENERATE_PUBLISH_PRICE_BOOK_WF:';
3881: BEGIN
3882: l_pb_input_header_id := Wf_Engine.GetItemAttrText(itemtype, itemkey, 'PARAMETER1');
3883: IF (l_pb_input_header_id is null) THEN
3884: wf_core.token('PARAMETER1','NULL');

Line 3921: Wf_Core.Context('QP_PRICE_BOOK_UTIL', 'GENERATE_PUBLISH_PRICE_BOOK_WF', itemtype, itemkey, to_char(actid), funcmode);

3917: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
3918:
3919: EXCEPTION
3920: WHEN OTHERS THEN
3921: Wf_Core.Context('QP_PRICE_BOOK_UTIL', 'GENERATE_PUBLISH_PRICE_BOOK_WF', itemtype, itemkey, to_char(actid), funcmode);
3922: raise;
3923: END GENERATE_PUBLISH_PRICE_BOOK_WF;
3924:
3925: PROCEDURE CATSO_SELECTOR

Line 4037: WF_CORE.Context('QP_PRICE_BOOK_UTIL', 'CATSO_SELECTOR',

4033: END IF;
4034:
4035: EXCEPTION
4036: WHEN OTHERS THEN NULL;
4037: WF_CORE.Context('QP_PRICE_BOOK_UTIL', 'CATSO_SELECTOR',
4038: p_itemtype, p_itemkey, p_actid, p_funcmode);
4039: RAISE;
4040:
4041: END CATSO_SELECTOR;

Line 4057: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.SET_XML_CONTEXT';

4053: l_resp_id NUMBER;
4054: l_resp_appl_id NUMBER;
4055: l_resp_appl_name VARCHAR2(30);
4056: l_debug VARCHAR2(3);
4057: l_routine VARCHAR2(240):='QP_PRICE_BOOK_UTIL.SET_XML_CONTEXT';
4058: BEGIN
4059: -- get user based on user name
4060: SELECT user_id
4061: INTO l_user_id

Line 4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;

4179: l_pb_input_header_id NUMBER;
4180: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4181: l_full_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4182:
4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4185: l_attribute_value_tbl QP_PRICE_BOOK_UTIL.VARCHAR_TYPE;
4186: l_attribute_type_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4187:

Line 4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;

4180: l_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4181: l_full_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4182:
4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4185: l_attribute_value_tbl QP_PRICE_BOOK_UTIL.VARCHAR_TYPE;
4186: l_attribute_type_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4187:
4188: l_user_id NUMBER;

Line 4185: l_attribute_value_tbl QP_PRICE_BOOK_UTIL.VARCHAR_TYPE;

4181: l_full_pb_input_header_rec qp_pb_input_headers_vl%ROWTYPE;
4182:
4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4185: l_attribute_value_tbl QP_PRICE_BOOK_UTIL.VARCHAR_TYPE;
4186: l_attribute_type_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4187:
4188: l_user_id NUMBER;
4189: l_login_id NUMBER;

Line 4186: l_attribute_type_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;

4182:
4183: l_context_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4184: l_attribute_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4185: l_attribute_value_tbl QP_PRICE_BOOK_UTIL.VARCHAR_TYPE;
4186: l_attribute_type_tbl QP_PRICE_BOOK_UTIL.VARCHAR30_TYPE;
4187:
4188: l_user_id NUMBER;
4189: l_login_id NUMBER;
4190: l_sysdate DATE;

Line 4480: QP_Price_Book_Util.value_to_meaning(''='',''COMPARISON_OPERATOR_FWK'') "OperatorCodeName")

4476: PBInputLIN.CONTEXT_NAME "ContextName",
4477: PBInputLIN.ATTRIBUTE_NAME "AttributeName",
4478: PBInputLIN.ATTRIBUTE_VALUE_NAME "AttributeValueName",
4479: PBInputLIN.ATTRIBUTE_TYPE_VALUE "AttributeTypeValue",
4480: QP_Price_Book_Util.value_to_meaning(''='',''COMPARISON_OPERATOR_FWK'') "OperatorCodeName")
4481: )
4482: )
4483: FROM QP_PB_INPUT_LINES_V PBInputLIN
4484: WHERE PBInputLIN.Pb_Input_Header_Id = PBInputHDR.Pb_Input_Header_Id

Line 4713: END QP_PRICE_BOOK_UTIL;

4709: x_return_text := 'Error in XML Generation: '||SQLERRM;
4710: END GENERATE_PRICE_BOOK_XML;
4711: /** KDURGASI **/
4712:
4713: END QP_PRICE_BOOK_UTIL;