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.ASO_QUOTE_HEADERS_PVT dependencies on ASO_UTILITY_PVT

Line 366: l_order_type_id NUMBER := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));

362: -- Changes Done by : Girish
363: -- Comments : Using HR EIT in place of org striped profile
364:
365: --l_order_type_id NUMBER := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
366: l_order_type_id NUMBER := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
367:
368: -- Change END
369:
370: l_price_list_id NUMBER;

Line 1697: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( p_qte_header_rec.QUOTE_HEADER_ID,null);

1693: END IF;
1694:
1695: -- Validate the invoice to cust party id and payment info, if any
1696: IF p_payment_tbl.count = 0 then
1697: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( p_qte_header_rec.QUOTE_HEADER_ID,null);
1698: Else
1699: l_payment_tbl := p_payment_tbl;
1700: -- check to see if the value has been changed, if not get orig value from db
1701: if l_payment_tbl(1).payment_type_code = fnd_api.g_miss_char then

Line 4151: ASO_UTILITY_PVT.print_login_info;

4147:
4148: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
4149: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4150: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
4151: ASO_UTILITY_PVT.print_login_info;
4152: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
4153: END IF;
4154:
4155: -- Change Done By Girish

Line 4362: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

4358: if aso_debug_pub.g_debug_flag = 'Y' then
4359: aso_debug_pub.add('Create_Quote: p_validation_level: ' || p_validation_level, 1, 'Y');
4360: end if;
4361:
4362: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4363:
4364: ASO_PARTY_INT.Validate_CustAccount (
4365: p_init_msg_list => FND_API.G_FALSE,
4366: p_party_id => l_qte_header_rec.party_id,

Line 4639: END IF; --IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

4635: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4636: RAISE FND_API.G_EXC_ERROR;
4637: END IF;
4638:
4639: END IF; --IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4640:
4641:
4642: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4643: aso_debug_pub.add('Create_Quote: Before call to Populate_Qte_Header', 1, 'Y');

Line 4658: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

4654: aso_debug_pub.add('Create_Quote: After call to Populate_Qte_Header', 1, 'Y');
4655: END IF;
4656:
4657:
4658: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4659:
4660: IF l_hd_shipment_tbl.count > 0 THEN
4661: l_shipment_rec := l_hd_shipment_tbl(1);
4662: END IF;

Line 4720: END IF; --IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

4716: RAISE FND_API.G_EXC_ERROR;
4717: END IF;
4718: end if; -- end if for ship method code check
4719:
4720: END IF; --IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4721:
4722:
4723: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4724: aso_debug_pub.add('Create_Quote: Before call to check_tca', 1, 'N');

Line 4760: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN

4756: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4757: aso_debug_pub.add('Create_Quote: After call to OrderType: x_return_status: ' || x_return_status, 1, 'Y');
4758: END IF;
4759:
4760: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
4761:
4762:
4763: ASO_VALIDATE_PVT.Validate_NotNULL_VARCHAR2 (
4764: p_init_msg_list => FND_API.G_FALSE,

Line 4907: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN

4903: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4904: RAISE FND_API.G_EXC_ERROR;
4905: END IF;
4906:
4907: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
4908:
4909:
4910: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
4911:

Line 5437: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

5433: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5434: aso_debug_pub.add('Before validate quote percent: p_validation_level: '|| p_validation_level, 1, 'Y');
5435: END IF;
5436:
5437: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5438:
5439: IF x_hd_sales_credit_tbl.count > 0 THEN
5440:
5441: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6034: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);

6030: l_pricing_control_rec.price_mode := p_control_rec.price_mode;
6031:
6032: --New Code for to call overload pricing_order
6033:
6034: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6035: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
6036: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
6037:
6038: if lv_hd_shipment_tbl.count = 1 then

Line 6035: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);

6031:
6032: --New Code for to call overload pricing_order
6033:
6034: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6035: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
6036: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
6037:
6038: if lv_hd_shipment_tbl.count = 1 then
6039: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);

Line 6036: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);

6032: --New Code for to call overload pricing_order
6033:
6034: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6035: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
6036: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
6037:
6038: if lv_hd_shipment_tbl.count = 1 then
6039: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);
6040: end if;

Line 6234: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);

6230: END IF;
6231:
6232:
6233: -- Start of PNPL Changes
6234: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6235:
6236: l_installment_option := oe_sys_parameters.value(param_name => 'INSTALLMENT_OPTIONS',
6237: p_org_id =>x_qte_header_rec.org_id);
6238:

Line 6412: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);

6408: X_Return_Status => x_return_status,
6409: X_Msg_Count => x_msg_count,
6410: X_Msg_Data => x_msg_data);
6411:
6412: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6413:
6414: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6415:
6416: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 6475: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.CREATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');

6471: -- Release 12 TAP Changes
6472: -- Girish Sachdeva 8/30/2005
6473: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
6474: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6475: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.CREATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');
6476: END IF;
6477:
6478:
6479: -- Call to insert record in ASO_CHANGED_QUOTES

Line 6480: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

6476: END IF;
6477:
6478:
6479: -- Call to insert record in ASO_CHANGED_QUOTES
6480: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);
6481:
6482: -- Change END
6483:
6484:

Line 6512: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6508:
6509: EXCEPTION
6510:
6511: WHEN FND_API.G_EXC_ERROR THEN
6512: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6513: P_API_NAME => L_API_NAME
6514: ,P_PKG_NAME => G_PKG_NAME
6515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6516: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6516: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6512: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6513: P_API_NAME => L_API_NAME
6514: ,P_PKG_NAME => G_PKG_NAME
6515: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6516: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6517: ,P_SQLCODE => SQLCODE
6518: ,P_SQLERRM => SQLERRM
6519: ,X_MSG_COUNT => X_MSG_COUNT
6520: ,X_MSG_DATA => X_MSG_DATA

Line 6524: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6520: ,X_MSG_DATA => X_MSG_DATA
6521: ,X_RETURN_STATUS => X_RETURN_STATUS);
6522:
6523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6524: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6525: P_API_NAME => L_API_NAME
6526: ,P_PKG_NAME => G_PKG_NAME
6527: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6528: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6528: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6524: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6525: P_API_NAME => L_API_NAME
6526: ,P_PKG_NAME => G_PKG_NAME
6527: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6528: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6529: ,P_SQLCODE => SQLCODE
6530: ,P_SQLERRM => SQLERRM
6531: ,X_MSG_COUNT => X_MSG_COUNT
6532: ,X_MSG_DATA => X_MSG_DATA

Line 6536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6532: ,X_MSG_DATA => X_MSG_DATA
6533: ,X_RETURN_STATUS => X_RETURN_STATUS);
6534:
6535: WHEN OTHERS THEN
6536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6537: P_API_NAME => L_API_NAME
6538: ,P_PKG_NAME => G_PKG_NAME
6539: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6540: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6539: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

6535: WHEN OTHERS THEN
6536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6537: P_API_NAME => L_API_NAME
6538: ,P_PKG_NAME => G_PKG_NAME
6539: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6540: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6541: ,P_SQLCODE => SQLCODE
6542: ,P_SQLERRM => SQLERRM
6543: ,X_MSG_COUNT => X_MSG_COUNT

Line 6540: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6536: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6537: P_API_NAME => L_API_NAME
6538: ,P_PKG_NAME => G_PKG_NAME
6539: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6540: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6541: ,P_SQLCODE => SQLCODE
6542: ,P_SQLERRM => SQLERRM
6543: ,X_MSG_COUNT => X_MSG_COUNT
6544: ,X_MSG_DATA => X_MSG_DATA

Line 6946: ASO_UTILITY_PVT.print_login_info;

6942: END IF;
6943: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
6944: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6945: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
6946: ASO_UTILITY_PVT.print_login_info;
6947: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
6948: END IF;
6949:
6950: -- Change Done By Girish

Line 7257: aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE)), 1, 'N');

7253: -- Changes Done by : Girish
7254: -- Comments : Using HR EIT in place of org striped profile
7255:
7256: -- aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(fnd_profile.value('ASO_ORDER_TYPE_ID')), 1, 'N');
7257: aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE)), 1, 'N');
7258:
7259: -- Change END
7260:
7261: aso_debug_pub.add('Update_Quote - order_type_id from database '||l_order_type_id, 1, 'N');

Line 7273: l_qte_header_rec.order_type_id := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));

7269: -- Changes Done by : Girish
7270: -- Comments : Using HR EIT in place of org striped profile
7271:
7272: --l_qte_header_rec.order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
7273: l_qte_header_rec.order_type_id := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
7274:
7275: -- Change END
7276:
7277: END IF;

Line 7324: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

7320:
7321: END IF; --l_qte_header_rec.publish_flag = 'Y' THEN
7322:
7323:
7324: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7325:
7326: -- party_id must exist and be active in HZ_PARTIES
7327: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7328: aso_debug_pub.add('Update_Quote - before validate_party: ', 1, 'N');

Line 7604: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

7600: END IF;
7601:
7602: END LOOP;
7603:
7604: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7605:
7606: IF l_hd_Shipment_tbl.count > 0 THEN
7607: l_shipment_rec := l_hd_Shipment_tbl(1);
7608: END IF;

Line 7628: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN

7624: END IF;
7625:
7626: END IF;
7627:
7628: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
7629:
7630: IF l_qte_header_rec.currency_code IS NULL THEN
7631:
7632: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 7712: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

7708:
7709: END LOOP;
7710:
7711:
7712: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7713:
7714: IF l_hd_Shipment_tbl.count > 0 THEN
7715: l_shipment_rec := l_hd_Shipment_tbl(1);
7716: END IF;

Line 7889: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_rec.QUOTE_HEADER_ID);

7885:
7886:
7887: IF l_auto_version = 'Y' THEN
7888:
7889: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_rec.QUOTE_HEADER_ID);
7890:
7891: -- updating the existing version to a higher version
7892: -- this is done here because copy quote will fail to
7893: -- insert duplicate quote number/version

Line 7992: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

7988:
7989: END LOOP;
7990:
7991:
7992: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7993:
7994: IF l_hd_shipment_tbl.count > 0 THEN
7995: l_hd_shipment_tbl(1) := l_hd_shipment_tbl(1);
7996: l_shipment_rec := l_hd_shipment_tbl(1);

Line 8645: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN

8641:
8642:
8643: -- sales credits
8644:
8645: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
8646: IF x_hd_sales_credit_tbl.count > 0 THEN
8647: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8648: aso_debug_pub.add('Setting the qte hdr id in x_hd_sales_credit_tbl to : '|| x_qte_header_rec.QUOTE_HEADER_ID, 1, 'Y');
8649: END IF;

Line 8721: l_batch_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_qte_line_rec.quote_line_id);

8717: FETCH c_qte_line into l_qln_id;
8718: IF c_qte_line%FOUND THEN
8719:
8720: l_batch_qte_line_rec := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
8721: l_batch_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_qte_line_rec.quote_line_id);
8722:
8723: l_add_line := FND_API.G_FALSE;
8724: l_add_model_line := FND_API.G_FALSE;
8725:

Line 8729: l_batch_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);

8725:
8726: IF l_batch_qte_line_rec.item_type_code IN ('MDL','CFG') THEN
8727:
8728: l_batch_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
8729: l_batch_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
8730: IF l_batch_qte_line_dtl_tbl.count > 0 THEN
8731: IF l_batch_qte_line_dtl_tbl(1).config_header_id IS NOT NULL AND
8732: l_batch_qte_line_dtl_tbl(1).config_revision_num IS NOT NULL THEN
8733:

Line 10104: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);

10100: l_pricing_control_rec.price_mode := p_control_rec.price_mode;
10101:
10102: --New Code for to call overload pricing_order
10103:
10104: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
10105: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
10106: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
10107:
10108: if lv_hd_shipment_tbl.count = 1 then

Line 10105: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);

10101:
10102: --New Code for to call overload pricing_order
10103:
10104: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
10105: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
10106: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
10107:
10108: if lv_hd_shipment_tbl.count = 1 then
10109: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);

Line 10106: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);

10102: --New Code for to call overload pricing_order
10103:
10104: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
10105: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
10106: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
10107:
10108: if lv_hd_shipment_tbl.count = 1 then
10109: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);
10110: end if;

Line 10319: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);

10315: END IF;
10316:
10317:
10318: -- Start of PNPL Changes
10319: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
10320:
10321: l_installment_option := oe_sys_parameters.value(param_name => 'INSTALLMENT_OPTIONS',
10322: p_org_id =>x_qte_header_rec.org_id);
10323:

Line 10480: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);

10476: X_Return_Status => x_return_status,
10477: X_Msg_Count => x_msg_count,
10478: X_Msg_Data => x_msg_data);
10479:
10480: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
10481:
10482: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
10483:
10484:

Line 10509: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.UPDATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');

10505: -- Girish Sachdeva 8/30/2005
10506: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
10507:
10508: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10509: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.UPDATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');
10510: END IF;
10511:
10512: -- Call to insert record in ASO_CHANGED_QUOTES
10513: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

Line 10513: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

10509: aso_debug_pub.add('ASO_QUOTE_HEADERS_PVT.UPDATE_QUOTE : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || x_qte_header_rec.quote_number, 1, 'Y');
10510: END IF;
10511:
10512: -- Call to insert record in ASO_CHANGED_QUOTES
10513: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);
10514:
10515: -- Change END
10516:
10517:

Line 10531: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10527: );
10528:
10529: EXCEPTION
10530: WHEN FND_API.G_EXC_ERROR THEN
10531: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10532: P_API_NAME => L_API_NAME
10533: ,P_PKG_NAME => G_PKG_NAME
10534: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10535: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10535: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10531: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10532: P_API_NAME => L_API_NAME
10533: ,P_PKG_NAME => G_PKG_NAME
10534: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10535: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10536: ,P_SQLCODE => SQLCODE
10537: ,P_SQLERRM => SQLERRM
10538: ,X_MSG_COUNT => X_MSG_COUNT
10539: ,X_MSG_DATA => X_MSG_DATA

Line 10543: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10539: ,X_MSG_DATA => X_MSG_DATA
10540: ,X_RETURN_STATUS => X_RETURN_STATUS);
10541:
10542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10543: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10544: P_API_NAME => L_API_NAME
10545: ,P_PKG_NAME => G_PKG_NAME
10546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10547: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10547: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10543: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10544: P_API_NAME => L_API_NAME
10545: ,P_PKG_NAME => G_PKG_NAME
10546: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10547: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10548: ,P_SQLCODE => SQLCODE
10549: ,P_SQLERRM => SQLERRM
10550: ,X_MSG_COUNT => X_MSG_COUNT
10551: ,X_MSG_DATA => X_MSG_DATA

Line 10555: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10551: ,X_MSG_DATA => X_MSG_DATA
10552: ,X_RETURN_STATUS => X_RETURN_STATUS);
10553:
10554: WHEN OTHERS THEN
10555: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10556: P_API_NAME => L_API_NAME
10557: ,P_PKG_NAME => G_PKG_NAME
10558: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10559: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10558: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

10554: WHEN OTHERS THEN
10555: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10556: P_API_NAME => L_API_NAME
10557: ,P_PKG_NAME => G_PKG_NAME
10558: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10559: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10560: ,P_SQLCODE => SQLCODE
10561: ,P_SQLERRM => SQLERRM
10562: ,X_MSG_COUNT => X_MSG_COUNT

Line 10559: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10555: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10556: P_API_NAME => L_API_NAME
10557: ,P_PKG_NAME => G_PKG_NAME
10558: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10559: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10560: ,P_SQLCODE => SQLCODE
10561: ,P_SQLERRM => SQLERRM
10562: ,X_MSG_COUNT => X_MSG_COUNT
10563: ,X_MSG_DATA => X_MSG_DATA

Line 10730: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10726: );
10727:
10728: EXCEPTION
10729: WHEN FND_API.G_EXC_ERROR THEN
10730: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10731: P_API_NAME => L_API_NAME
10732: ,P_PKG_NAME => G_PKG_NAME
10733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10734: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10734: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10730: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10731: P_API_NAME => L_API_NAME
10732: ,P_PKG_NAME => G_PKG_NAME
10733: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10734: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10735: ,P_SQLCODE => SQLCODE
10736: ,P_SQLERRM => SQLERRM
10737: ,X_MSG_COUNT => X_MSG_COUNT
10738: ,X_MSG_DATA => X_MSG_DATA

Line 10742: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10738: ,X_MSG_DATA => X_MSG_DATA
10739: ,X_RETURN_STATUS => X_RETURN_STATUS);
10740:
10741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10742: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10743: P_API_NAME => L_API_NAME
10744: ,P_PKG_NAME => G_PKG_NAME
10745: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10746: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10746: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10742: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10743: P_API_NAME => L_API_NAME
10744: ,P_PKG_NAME => G_PKG_NAME
10745: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10746: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10747: ,P_SQLCODE => SQLCODE
10748: ,P_SQLERRM => SQLERRM
10749: ,X_MSG_COUNT => X_MSG_COUNT
10750: ,X_MSG_DATA => X_MSG_DATA

Line 10754: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10750: ,X_MSG_DATA => X_MSG_DATA
10751: ,X_RETURN_STATUS => X_RETURN_STATUS);
10752:
10753: WHEN OTHERS THEN
10754: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10755: P_API_NAME => L_API_NAME
10756: ,P_PKG_NAME => G_PKG_NAME
10757: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10758: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10757: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

10753: WHEN OTHERS THEN
10754: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10755: P_API_NAME => L_API_NAME
10756: ,P_PKG_NAME => G_PKG_NAME
10757: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10758: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10759: ,P_SQLCODE => SQLCODE
10760: ,P_SQLERRM => SQLERRM
10761: ,X_MSG_COUNT => X_MSG_COUNT

Line 10758: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10754: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10755: P_API_NAME => L_API_NAME
10756: ,P_PKG_NAME => G_PKG_NAME
10757: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10758: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10759: ,P_SQLCODE => SQLCODE
10760: ,P_SQLERRM => SQLERRM
10761: ,X_MSG_COUNT => X_MSG_COUNT
10762: ,X_MSG_DATA => X_MSG_DATA

Line 11106: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

11102: aso_debug_pub.add('Copy_Quote - P_Qte_Status_Id '||P_Qte_Status_Id, 1, 'N');
11103: aso_debug_pub.add('Copy_Quote - P_Qte_Number '||P_Qte_Number, 1, 'N');
11104: END IF;
11105:
11106: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
11107: IF (p_new_version = FND_API.G_TRUE AND
11108: l_qte_header_rec.quote_number = p_qte_number) THEN
11109: l_new_version := FND_API.G_TRUE;
11110: END IF;

Line 11285: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11281: );
11282:
11283: EXCEPTION
11284: WHEN FND_API.G_EXC_ERROR THEN
11285: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11286: P_API_NAME => L_API_NAME
11287: ,P_PKG_NAME => G_PKG_NAME
11288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11289: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11289: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11285: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11286: P_API_NAME => L_API_NAME
11287: ,P_PKG_NAME => G_PKG_NAME
11288: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11289: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11290: ,X_MSG_COUNT => X_MSG_COUNT
11291: ,X_MSG_DATA => X_MSG_DATA
11292: ,X_RETURN_STATUS => X_RETURN_STATUS);
11293:

Line 11295: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11291: ,X_MSG_DATA => X_MSG_DATA
11292: ,X_RETURN_STATUS => X_RETURN_STATUS);
11293:
11294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11295: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11296: P_API_NAME => L_API_NAME
11297: ,P_PKG_NAME => G_PKG_NAME
11298: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11299: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11299: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11295: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11296: P_API_NAME => L_API_NAME
11297: ,P_PKG_NAME => G_PKG_NAME
11298: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11299: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11300: ,X_MSG_COUNT => X_MSG_COUNT
11301: ,X_MSG_DATA => X_MSG_DATA
11302: ,X_RETURN_STATUS => X_RETURN_STATUS);
11303:

Line 11305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11301: ,X_MSG_DATA => X_MSG_DATA
11302: ,X_RETURN_STATUS => X_RETURN_STATUS);
11303:
11304: WHEN OTHERS THEN
11305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11306: P_API_NAME => L_API_NAME
11307: ,P_PKG_NAME => G_PKG_NAME
11308: ,P_SQLCODE => SQLCODE
11309: ,P_SQLERRM => SQLERRM

Line 11310: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

11306: P_API_NAME => L_API_NAME
11307: ,P_PKG_NAME => G_PKG_NAME
11308: ,P_SQLCODE => SQLCODE
11309: ,P_SQLERRM => SQLERRM
11310: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11311: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11312: ,X_MSG_COUNT => X_MSG_COUNT
11313: ,X_MSG_DATA => X_MSG_DATA
11314: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 11311: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11307: ,P_PKG_NAME => G_PKG_NAME
11308: ,P_SQLCODE => SQLCODE
11309: ,P_SQLERRM => SQLERRM
11310: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11311: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11312: ,X_MSG_COUNT => X_MSG_COUNT
11313: ,X_MSG_DATA => X_MSG_DATA
11314: ,X_RETURN_STATUS => X_RETURN_STATUS);
11315: END Copy_Quote;

Line 11503: l_util_order_by_tbl ASO_UTILITY_PVT.Util_order_by_tbl_type;

11499: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
11500: )
11501: IS
11502: l_order_by_cl VARCHAR2(1000) := NULL;
11503: l_util_order_by_tbl ASO_UTILITY_PVT.Util_order_by_tbl_type;
11504: BEGIN
11505:
11506: -- Hint: Developer should add more statements according to ASO_sort_rec_type
11507: -- Ex:

Line 11512: ASO_UTILITY_PVT.Translate_OrderBy(

11508: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
11509: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
11510:
11511:
11512: ASO_UTILITY_PVT.Translate_OrderBy(
11513: p_api_version_number => 1.0
11514: ,p_init_msg_list => FND_API.G_FALSE
11515: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
11516: ,p_order_by_tbl => l_util_order_by_tbl

Line 11837: l_flex_where_tbl_type ASO_UTILITY_PVT.flex_where_tbl_type;

11833: l_order_by_cl VARCHAR2(2000);
11834: l_QTE_where VARCHAR2(2000) := '';
11835:
11836: -- For flex field query
11837: l_flex_where_tbl_type ASO_UTILITY_PVT.flex_where_tbl_type;
11838: l_flex_where VARCHAR2(2000) := NULL;
11839: l_counter NUMBER;
11840:
11841: -- Local scratch record

Line 11910: ASO_UTILITY_PVT.Gen_Flexfield_Where(

11906: l_flex_where_tbl_type(14).value := P_Qte_Header_Rec.attribute14;
11907: l_flex_where_tbl_type(15).value := P_Qte_Header_Rec.attribute15;
11908: l_flex_where_tbl_type(16).value := P_Qte_Header_Rec.attribute_category;
11909:
11910: ASO_UTILITY_PVT.Gen_Flexfield_Where(
11911: p_flex_where_tbl_type => l_flex_where_tbl_type,
11912: x_flex_where_clause => l_flex_where);
11913:
11914: -- Hint: if master/detail relationship, generate Where clause for lines level criteria

Line 11934: ASO_UTILITY_PVT.Bind_Flexfield_Where(

11930: -- p_total_amt_ceiling, p_total_amt_floor,
11931: -- l_cur_get_QTE);
11932:
11933: -- Bind flexfield variables
11934: ASO_UTILITY_PVT.Bind_Flexfield_Where(
11935: p_cursor_id => l_cur_get_QTE,
11936: p_flex_where_tbl_type => l_flex_where_tbl_type);
11937:
11938: -- Define all Select Columns

Line 11998: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11994: );
11995:
11996: EXCEPTION
11997: WHEN FND_API.G_EXC_ERROR THEN
11998: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11999: P_API_NAME => L_API_NAME
12000: ,P_PKG_NAME => G_PKG_NAME
12001: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12002: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 12002: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11998: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11999: P_API_NAME => L_API_NAME
12000: ,P_PKG_NAME => G_PKG_NAME
12001: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12002: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12003: ,X_MSG_COUNT => X_MSG_COUNT
12004: ,X_MSG_DATA => X_MSG_DATA
12005: ,X_RETURN_STATUS => X_RETURN_STATUS);
12006:

Line 12008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

12004: ,X_MSG_DATA => X_MSG_DATA
12005: ,X_RETURN_STATUS => X_RETURN_STATUS);
12006:
12007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12009: P_API_NAME => L_API_NAME
12010: ,P_PKG_NAME => G_PKG_NAME
12011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 12012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

12008: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12009: P_API_NAME => L_API_NAME
12010: ,P_PKG_NAME => G_PKG_NAME
12011: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12012: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12013: ,X_MSG_COUNT => X_MSG_COUNT
12014: ,X_MSG_DATA => X_MSG_DATA
12015: ,X_RETURN_STATUS => X_RETURN_STATUS);
12016:

Line 12018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

12014: ,X_MSG_DATA => X_MSG_DATA
12015: ,X_RETURN_STATUS => X_RETURN_STATUS);
12016:
12017: WHEN OTHERS THEN
12018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12019: P_API_NAME => L_API_NAME
12020: ,P_PKG_NAME => G_PKG_NAME
12021: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
12022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 12021: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

12017: WHEN OTHERS THEN
12018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12019: P_API_NAME => L_API_NAME
12020: ,P_PKG_NAME => G_PKG_NAME
12021: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
12022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12023: ,X_MSG_COUNT => X_MSG_COUNT
12024: ,X_MSG_DATA => X_MSG_DATA
12025: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

12018: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12019: P_API_NAME => L_API_NAME
12020: ,P_PKG_NAME => G_PKG_NAME
12021: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
12022: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12023: ,X_MSG_COUNT => X_MSG_COUNT
12024: ,X_MSG_DATA => X_MSG_DATA
12025: ,X_RETURN_STATUS => X_RETURN_STATUS);
12026: End Get_quote;

Line 12191: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);

12187:
12188: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12189: aso_debug_pub.add('Copy_Config - inside cursor qte_line_id '|| qte_line_id, 1, 'Y');
12190: END IF;
12191: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
12192:
12193: l_qte_line_rec.quote_header_id := x_qte_header_id;
12194:
12195: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);

Line 12195: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);

12191: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
12192:
12193: l_qte_line_rec.quote_header_id := x_qte_header_id;
12194:
12195: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);
12196:
12197: FOR k IN 1..l_qte_line_dtl_tbl.count LOOP
12198: l_qte_line_dtl_tbl(k).config_header_id := p_config_header_id;
12199: l_qte_line_dtl_tbl(k).config_revision_num := p_config_revision_num;

Line 12203: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);

12199: l_qte_line_dtl_tbl(k).config_revision_num := p_config_revision_num;
12200: END LOOP;
12201:
12202:
12203: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
12204: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
12205:
12206: FOR j IN 1..l_price_adj_tbl.count LOOP
12207: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

Line 12204: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);

12200: END LOOP;
12201:
12202:
12203: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
12204: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
12205:
12206: FOR j IN 1..l_price_adj_tbl.count LOOP
12207: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12208: END LOOP;

Line 12210: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);

12206: FOR j IN 1..l_price_adj_tbl.count LOOP
12207: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12208: END LOOP;
12209:
12210: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
12211: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
12212:
12213: FOR j IN 1..l_price_attr_tbl.count LOOP
12214: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

Line 12211: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);

12207: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12208: END LOOP;
12209:
12210: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
12211: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
12212:
12213: FOR j IN 1..l_price_attr_tbl.count LOOP
12214: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12215: END LOOP;

Line 12217: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(qte_header_id, QTE_LINE_ID);

12213: FOR j IN 1..l_price_attr_tbl.count LOOP
12214: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12215: END LOOP;
12216:
12217: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(qte_header_id, QTE_LINE_ID);
12218:
12219: FOR j IN 1..l_payment_tbl.count LOOP
12220: l_payment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12221: l_payment_tbl(j).CREDIT_CARD_APPROVAL_CODE := NULL;

Line 12226: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(qte_header_id, QTE_LINE_ID);

12222: l_payment_tbl(j).CREDIT_CARD_APPROVAL_DATE := NULL;
12223: l_payment_tbl(j).PAYMENT_AMOUNT := NULL;
12224: END LOOP;
12225:
12226: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(qte_header_id, QTE_LINE_ID);
12227: FOR j IN 1..l_shipment_tbl.count LOOP
12228: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12229: END LOOP;
12230:

Line 12231: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(qte_header_id,QTE_LINE_ID);

12227: FOR j IN 1..l_shipment_tbl.count LOOP
12228: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12229: END LOOP;
12230:
12231: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(qte_header_id,QTE_LINE_ID);
12232: FOR j IN 1..l_sales_credit_tbl.count LOOP
12233: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12234: END LOOP;
12235:

Line 12236: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(qte_header_id,QTE_LINE_ID);

12232: FOR j IN 1..l_sales_credit_tbl.count LOOP
12233: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12234: END LOOP;
12235:
12236: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(qte_header_id,QTE_LINE_ID);
12237: FOR j IN 1..l_quote_party_tbl.count LOOP
12238: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12239: END LOOP;
12240:

Line 12241: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);

12237: FOR j IN 1..l_quote_party_tbl.count LOOP
12238: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12239: END LOOP;
12240:
12241: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
12242: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
12243:
12244: OPEN C_Serviceable_Product(l_qte_line_rec.organization_id, l_qte_line_rec.inventory_item_id);
12245: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;

Line 12242: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);

12238: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12239: END LOOP;
12240:
12241: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
12242: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
12243:
12244: OPEN C_Serviceable_Product(l_qte_line_rec.organization_id, l_qte_line_rec.inventory_item_id);
12245: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;
12246: CLOSE C_Serviceable_Product;

Line 12468: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);

12464: EXIT WHEN line_id_from_service%NOTFOUND;
12465: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12466: aso_debug_pub.add('Copy_Service - inside cursor qte_line_id '|| qte_line_id, 1, 'Y');
12467: END IF;
12468: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
12469:
12470: l_qte_line_rec.quote_header_id := x_qte_header_id;
12471:
12472: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);

Line 12472: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);

12468: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
12469:
12470: l_qte_line_rec.quote_header_id := x_qte_header_id;
12471:
12472: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);
12473:
12474:
12475: IF l_qte_line_dtl_tbl.count > 0 THEN
12476: FOR k IN 1..l_qte_line_dtl_tbl.count LOOP

Line 12499: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);

12495: l_qte_line_dtl_tbl(k).config_revision_num := p_config_revision_num;
12496: END LOOP;
12497: */
12498:
12499: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
12500: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
12501:
12502: FOR j IN 1..l_price_adj_tbl.count LOOP
12503: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

Line 12500: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);

12496: END LOOP;
12497: */
12498:
12499: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
12500: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
12501:
12502: FOR j IN 1..l_price_adj_tbl.count LOOP
12503: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12504: END LOOP;

Line 12506: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);

12502: FOR j IN 1..l_price_adj_tbl.count LOOP
12503: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12504: END LOOP;
12505:
12506: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
12507: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
12508:
12509: FOR j IN 1..l_price_attr_tbl.count LOOP
12510: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

Line 12507: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);

12503: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12504: END LOOP;
12505:
12506: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
12507: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
12508:
12509: FOR j IN 1..l_price_attr_tbl.count LOOP
12510: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12511: END LOOP;

Line 12513: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(qte_header_id, QTE_LINE_ID);

12509: FOR j IN 1..l_price_attr_tbl.count LOOP
12510: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12511: END LOOP;
12512:
12513: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(qte_header_id, QTE_LINE_ID);
12514:
12515: FOR j IN 1..l_payment_tbl.count LOOP
12516: l_payment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12517: l_payment_tbl(j).CREDIT_CARD_APPROVAL_CODE := NULL;

Line 12522: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(qte_header_id, QTE_LINE_ID);

12518: l_payment_tbl(j).CREDIT_CARD_APPROVAL_DATE := NULL;
12519: l_payment_tbl(j).PAYMENT_AMOUNT := NULL;
12520: END LOOP;
12521:
12522: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(qte_header_id, QTE_LINE_ID);
12523: FOR j IN 1..l_shipment_tbl.count LOOP
12524: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12525: END LOOP;
12526:

Line 12527: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(qte_header_id,QTE_LINE_ID);

12523: FOR j IN 1..l_shipment_tbl.count LOOP
12524: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12525: END LOOP;
12526:
12527: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(qte_header_id,QTE_LINE_ID);
12528: FOR j IN 1..l_sales_credit_tbl.count LOOP
12529: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12530: END LOOP;
12531:

Line 12532: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(qte_header_id,QTE_LINE_ID);

12528: FOR j IN 1..l_sales_credit_tbl.count LOOP
12529: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12530: END LOOP;
12531:
12532: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(qte_header_id,QTE_LINE_ID);
12533: FOR j IN 1..l_quote_party_tbl.count LOOP
12534: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12535: END LOOP;
12536:

Line 12537: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);

12533: FOR j IN 1..l_quote_party_tbl.count LOOP
12534: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12535: END LOOP;
12536:
12537: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
12538: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
12539: -- BC4J Fix
12540: --l_qte_line_rec.quote_line_id := null;
12541: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (

Line 12538: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);

12534: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
12535: END LOOP;
12536:
12537: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
12538: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
12539: -- BC4J Fix
12540: --l_qte_line_rec.quote_line_id := null;
12541: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
12542: p_control_rec => l_control_rec,