[Home] [Help]
1: PACKAGE BODY por_uda_pkg AS
2: /* $Header: POR_UDA_PKG.plb 120.13.12020000.2 2013/04/12 17:37:35 mzhussai ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('POR_UDA_PKG');
5:
1: PACKAGE BODY por_uda_pkg AS
2: /* $Header: POR_UDA_PKG.plb 120.13.12020000.2 2013/04/12 17:37:35 mzhussai ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('POR_UDA_PKG');
5:
6: PROCEDURE get_pr_line_attr_group_ids(
1: PACKAGE BODY por_uda_pkg AS
2: /* $Header: POR_UDA_PKG.plb 120.13.12020000.2 2013/04/12 17:37:35 mzhussai ship $ */
3:
4: d_pkg_name CONSTANT varchar2(50) := PO_LOG.get_package_base('POR_UDA_PKG');
5:
6: PROCEDURE get_pr_line_attr_group_ids(
7: p_template_id IN VARCHAR2,
8: p_req_line_id IN NUMBER,
150: -- To initialize the messages list.
151: fnd_msg_pub.Initialize();
152: l_final_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: POR_UDA_PKG.UDA_SUBMISSION_CHECK
155: (
156: p_pk1_value => p_req_header_id
157: ,p_template_id => l_template_id
158: ,x_external_attr_value_pairs => l_external_attr_value_pairs
183: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('CONTRACT_TYPE', l_contract_line_type || '', l_external_attr_value_pairs);
184: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('LINE_TYPE_ID', l_line_type_id || '', l_external_attr_value_pairs);
185: PO_UDA_DEFAULTING_PKG.SET_EXT_ATTR_NAME_VALUE_PAIR('SHIP_TO_LOC_ID', l_deliver_to_location_id || '', l_external_attr_value_pairs);
186:
187: POR_UDA_PKG.UDA_SUBMISSION_CHECK
188: (
189: p_pk1_value => c_get_lines_rec.requisition_line_id
190: ,p_template_id => l_template_id
191: ,x_external_attr_value_pairs => l_external_attr_value_pairs
565: EXCEPTION
566: WHEN OTHERS THEN
567: PO_MESSAGE_S.add_exc_msg
568: (
569: p_pkg_name => 'POR_UDA_PKG',
570: p_procedure_name => 'UDA_SUBMISSION_CHECK' || '.' || d_progress
571: );
572:
573: x_return_status := 'U';
1560: RAISE;
1561:
1562: END COPY_DOC_NUMBER_UDA;
1563:
1564: END POR_UDA_PKG;