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 367: l_order_type_id NUMBER := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));

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

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

1701: END IF;
1702:
1703: -- Validate the invoice to cust party id and payment info, if any
1704: IF p_payment_tbl.count = 0 then
1705: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( p_qte_header_rec.QUOTE_HEADER_ID,null);
1706: Else
1707: l_payment_tbl := p_payment_tbl;
1708: -- check to see if the value has been changed, if not get orig value from db
1709: if l_payment_tbl(1).payment_type_code = fnd_api.g_miss_char then

Line 4238: ASO_UTILITY_PVT.print_login_info;

4234:
4235: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
4236: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4237: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
4238: ASO_UTILITY_PVT.print_login_info;
4239: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
4240: END IF;
4241:
4242: -- Change Done By Girish

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

4445: if aso_debug_pub.g_debug_flag = 'Y' then
4446: aso_debug_pub.add('Create_Quote: p_validation_level: ' || p_validation_level, 1, 'Y');
4447: end if;
4448:
4449: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4450:
4451: ASO_PARTY_INT.Validate_CustAccount (
4452: p_init_msg_list => FND_API.G_FALSE,
4453: p_party_id => l_qte_header_rec.party_id,

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

4722: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4723: RAISE FND_API.G_EXC_ERROR;
4724: END IF;
4725:
4726: END IF; --IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4727:
4728:
4729: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4730: aso_debug_pub.add('Create_Quote: Before call to Populate_Qte_Header', 1, 'Y');

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

4741: aso_debug_pub.add('Create_Quote: After call to Populate_Qte_Header', 1, 'Y');
4742: END IF;
4743:
4744:
4745: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4746:
4747: IF l_hd_shipment_tbl.count > 0 THEN
4748: l_shipment_rec := l_hd_shipment_tbl(1);
4749: END IF;

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

4803: RAISE FND_API.G_EXC_ERROR;
4804: END IF;
4805: end if; -- end if for ship method code check
4806:
4807: END IF; --IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4808:
4809:
4810: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4811: aso_debug_pub.add('Create_Quote: Before call to check_tca', 1, 'N');

Line 4847: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN

4843: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4844: aso_debug_pub.add('Create_Quote: After call to OrderType: x_return_status: ' || x_return_status, 1, 'Y');
4845: END IF;
4846:
4847: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
4848:
4849:
4850: ASO_VALIDATE_PVT.Validate_NotNULL_VARCHAR2 (
4851: p_init_msg_list => FND_API.G_FALSE,

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

4990: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
4991: RAISE FND_API.G_EXC_ERROR;
4992: END IF;
4993:
4994: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
4995:
4996:
4997: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
4998:

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

5520: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5521: aso_debug_pub.add('Before validate quote percent: p_validation_level: '|| p_validation_level, 1, 'Y');
5522: END IF;
5523:
5524: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5525:
5526: IF x_hd_sales_credit_tbl.count > 0 THEN
5527:
5528: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6062: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);

6058: end loop;
6059: --vidya
6060: FOR i in 1..x_qte_line_tbl.count LOOP
6061: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
6062: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
6063: IF x_qte_line_dtl_tbl.count > 0 THEN
6064: IF x_qte_line_dtl_tbl(1).ref_line_id IS NOT NULL AND x_qte_line_dtl_tbl(1).ref_line_id <> FND_API.G_MISS_NUM THEN
6065: l_line_rltship_rec.OPERATION_CODE := 'CREATE';
6066: l_line_rltship_rec.QUOTE_LINE_ID := x_qte_line_dtl_tbl(1).ref_line_id;

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

6168: l_pricing_control_rec.price_mode := p_control_rec.price_mode;
6169:
6170: --New Code for to call overload pricing_order
6171:
6172: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6173: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
6174: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
6175:
6176: if lv_hd_shipment_tbl.count = 1 then

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

6169:
6170: --New Code for to call overload pricing_order
6171:
6172: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6173: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
6174: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
6175:
6176: if lv_hd_shipment_tbl.count = 1 then
6177: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);

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

6170: --New Code for to call overload pricing_order
6171:
6172: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6173: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
6174: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
6175:
6176: if lv_hd_shipment_tbl.count = 1 then
6177: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);
6178: end if;

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

6368: END IF;
6369:
6370:
6371: -- Start of PNPL Changes
6372: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6373:
6374: l_installment_option := oe_sys_parameters.value(param_name => 'INSTALLMENT_OPTIONS',
6375: p_org_id =>x_qte_header_rec.org_id);
6376:

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

6546: X_Return_Status => x_return_status,
6547: X_Msg_Count => x_msg_count,
6548: X_Msg_Data => x_msg_data);
6549:
6550: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
6551:
6552: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6553:
6554: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 6613: 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');

6609: -- Release 12 TAP Changes
6610: -- Girish Sachdeva 8/30/2005
6611: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
6612: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6613: 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');
6614: END IF;
6615:
6616:
6617: -- Call to insert record in ASO_CHANGED_QUOTES

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

6614: END IF;
6615:
6616:
6617: -- Call to insert record in ASO_CHANGED_QUOTES
6618: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);
6619:
6620: -- Change END
6621:
6622:

Line 6650: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6646:
6647: EXCEPTION
6648:
6649: WHEN FND_API.G_EXC_ERROR THEN
6650: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6651: P_API_NAME => L_API_NAME
6652: ,P_PKG_NAME => G_PKG_NAME
6653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6654: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6654: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6650: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6651: P_API_NAME => L_API_NAME
6652: ,P_PKG_NAME => G_PKG_NAME
6653: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6654: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6655: ,P_SQLCODE => SQLCODE
6656: ,P_SQLERRM => SQLERRM
6657: ,X_MSG_COUNT => X_MSG_COUNT
6658: ,X_MSG_DATA => X_MSG_DATA

Line 6662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6658: ,X_MSG_DATA => X_MSG_DATA
6659: ,X_RETURN_STATUS => X_RETURN_STATUS);
6660:
6661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6663: P_API_NAME => L_API_NAME
6664: ,P_PKG_NAME => G_PKG_NAME
6665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6663: P_API_NAME => L_API_NAME
6664: ,P_PKG_NAME => G_PKG_NAME
6665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6667: ,P_SQLCODE => SQLCODE
6668: ,P_SQLERRM => SQLERRM
6669: ,X_MSG_COUNT => X_MSG_COUNT
6670: ,X_MSG_DATA => X_MSG_DATA

Line 6674: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6670: ,X_MSG_DATA => X_MSG_DATA
6671: ,X_RETURN_STATUS => X_RETURN_STATUS);
6672:
6673: WHEN OTHERS THEN
6674: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6675: P_API_NAME => L_API_NAME
6676: ,P_PKG_NAME => G_PKG_NAME
6677: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6678: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 6677: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

6673: WHEN OTHERS THEN
6674: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6675: P_API_NAME => L_API_NAME
6676: ,P_PKG_NAME => G_PKG_NAME
6677: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6678: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6679: ,P_SQLCODE => SQLCODE
6680: ,P_SQLERRM => SQLERRM
6681: ,X_MSG_COUNT => X_MSG_COUNT

Line 6678: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

6674: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6675: P_API_NAME => L_API_NAME
6676: ,P_PKG_NAME => G_PKG_NAME
6677: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6678: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
6679: ,P_SQLCODE => SQLCODE
6680: ,P_SQLERRM => SQLERRM
6681: ,X_MSG_COUNT => X_MSG_COUNT
6682: ,X_MSG_DATA => X_MSG_DATA

Line 7246: ASO_UTILITY_PVT.print_login_info;

7242: END IF;
7243: --Procedure added by Anoop Rajan on 30/09/2005 to print login details
7244: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7245: aso_debug_pub.add('Before call to printing login info details', 1, 'Y');
7246: ASO_UTILITY_PVT.print_login_info;
7247: aso_debug_pub.add('After call to printing login info details', 1, 'Y');
7248: END IF;
7249:
7250: -- Change Done By Girish

Line 7438: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( p_qte_header_rec.Quote_Header_Id );

7434: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7435: aso_debug_pub.add('Update_Quote - Change Customer Flow starts', 1, 'Y');
7436: END IF ;
7437:
7438: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( p_qte_header_rec.Quote_Header_Id );
7439:
7440: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,
7441: p_qte_line_id => NULL );
7442:

Line 7440: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,

7436: END IF ;
7437:
7438: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row ( p_qte_header_rec.Quote_Header_Id );
7439:
7440: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,
7441: p_qte_line_id => NULL );
7442:
7443: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id =>p_qte_header_rec.Quote_Header_Id,p_qte_line_id =>NULL);
7444:

Line 7443: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id =>p_qte_header_rec.Quote_Header_Id,p_qte_line_id =>NULL);

7439:
7440: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,
7441: p_qte_line_id => NULL );
7442:
7443: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id =>p_qte_header_rec.Quote_Header_Id,p_qte_line_id =>NULL);
7444:
7445: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,
7446: p_qte_line_id => NULL,
7447: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl );

Line 7445: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,

7441: p_qte_line_id => NULL );
7442:
7443: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id =>p_qte_header_rec.Quote_Header_Id,p_qte_line_id =>NULL);
7444:
7445: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows ( p_qte_header_id => p_qte_header_rec.Quote_Header_Id,
7446: p_qte_line_id => NULL,
7447: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl );
7448:
7449: l_qte_header_rec.BATCH_PRICE_FLAG := FND_API.G_FALSE;

Line 7844: 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');

7840: -- Changes Done by : Girish
7841: -- Comments : Using HR EIT in place of org striped profile
7842:
7843: -- aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(fnd_profile.value('ASO_ORDER_TYPE_ID')), 1, 'N');
7844: 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');
7845:
7846: -- Change END
7847:
7848: aso_debug_pub.add('Update_Quote - order_type_id from database '||l_order_type_id, 1, 'N');

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

7856: -- Changes Done by : Girish
7857: -- Comments : Using HR EIT in place of org striped profile
7858:
7859: --l_qte_header_rec.order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
7860: l_qte_header_rec.order_type_id := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
7861:
7862: -- Change END
7863:
7864: END IF;

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

7907:
7908: END IF; --l_qte_header_rec.publish_flag = 'Y' THEN
7909:
7910:
7911: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7912:
7913: -- party_id must exist and be active in HZ_PARTIES
7914: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7915: aso_debug_pub.add('Update_Quote - before validate_party: ', 1, 'N');

Line 8103: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(c1.quote_line_id);

8099:
8100: END IF;
8101: if found=0 then
8102: l_qte_line_rec := aso_quote_pub.g_miss_qte_line_rec;
8103: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(c1.quote_line_id);
8104: if (l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM) or (l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID is null) then
8105: l_qte_line_rec.operation_code:='DELETE';
8106: ls_qte_line_tbl(ls_qte_line_tbl.count+1):=l_qte_line_rec;
8107: end if;

Line 8172: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(c1.quote_line_id);

8168:
8169: END IF;
8170: if found=0 then
8171: l_qte_line_rec := aso_quote_pub.g_miss_qte_line_rec;
8172: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(c1.quote_line_id);
8173: if (l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID = FND_API.G_MISS_NUM) or (l_qte_line_rec.END_CUSTOMER_CUST_ACCOUNT_ID is null) then
8174: l_qte_line_rec.operation_code:='DELETE';
8175: ls_qte_line_tbl(ls_qte_line_tbl.count+1):=l_qte_line_rec;
8176: end if;

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

8386: END IF;
8387:
8388: END LOOP;
8389:
8390: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
8391:
8392: IF l_hd_Shipment_tbl.count > 0 THEN
8393: l_shipment_rec := l_hd_Shipment_tbl(1);
8394: END IF;

Line 8414: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN

8410: END IF;
8411:
8412: END IF;
8413:
8414: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
8415:
8416: IF l_qte_header_rec.currency_code IS NULL THEN
8417:
8418: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

8494:
8495: END LOOP;
8496:
8497:
8498: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
8499:
8500: IF l_hd_Shipment_tbl.count > 0 THEN
8501: l_shipment_rec := l_hd_Shipment_tbl(1);
8502: END IF;

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

8671:
8672:
8673: IF l_auto_version = 'Y' THEN
8674:
8675: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_header_rec.QUOTE_HEADER_ID);
8676:
8677: -- updating the existing version to a higher version
8678: -- this is done here because copy quote will fail to
8679: -- insert duplicate quote number/version

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

8774:
8775: END LOOP;
8776:
8777:
8778: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
8779:
8780: IF l_hd_shipment_tbl.count > 0 THEN
8781: l_hd_shipment_tbl(1) := l_hd_shipment_tbl(1);
8782: l_shipment_rec := l_hd_shipment_tbl(1);

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

9432:
9433:
9434: -- sales credits
9435:
9436: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
9437: IF x_hd_sales_credit_tbl.count > 0 THEN
9438: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9439: 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');
9440: END IF;

Line 9534: l_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);

9530:
9531: -- Validation check for Trade in product
9532: If l_control_rec.Change_Customer_flag = FND_API.G_TRUE Then -- Code change done for Bug 11076978
9533:
9534: l_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
9535:
9536: IF (l_qte_line_rec.item_type_code = 'STD' ) and (l_qte_line_rec.line_category_code = 'RETURN' )THEN
9537: IF (l_line_dtl_tbl(1).INSTANCE_ID IS NOT NULL) Then
9538: l_qte_line_rec.operation_code:='DELETE';

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

9663: FETCH c_qte_line into l_qln_id;
9664: IF c_qte_line%FOUND THEN
9665:
9666: l_batch_qte_line_rec := ASO_QUOTE_PUB.G_MISS_QTE_LINE_REC;
9667: l_batch_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(l_qte_line_rec.quote_line_id);
9668:
9669: l_add_line := FND_API.G_FALSE;
9670: l_add_model_line := FND_API.G_FALSE;
9671:

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

9671:
9672: IF l_batch_qte_line_rec.item_type_code IN ('MDL','CFG') THEN
9673:
9674: l_batch_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
9675: l_batch_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
9676: IF l_batch_qte_line_dtl_tbl.count > 0 THEN
9677: IF l_batch_qte_line_dtl_tbl(1).config_header_id IS NOT NULL AND
9678: l_batch_qte_line_dtl_tbl(1).config_revision_num IS NOT NULL THEN
9679:

Line 10969: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);

10965: aso_debug_pub.ADD('x_qte_line_dtl_tbl.ref_line_id' || x_qte_line_dtl_tbl(i).ref_line_id);
10966: end loop;
10967: FOR i in 1..x_qte_line_tbl.count LOOP
10968: l_line_rltship_rec := ASO_QUOTE_PUB.G_Miss_Line_Rltship_Rec;
10969: x_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(x_qte_line_tbl(i).quote_line_id);
10970: IF x_qte_line_dtl_tbl.count > 0 THEN
10971: IF x_qte_line_dtl_tbl(1).ref_line_id IS NOT NULL AND x_qte_line_dtl_tbl(1).ref_line_id <> FND_API.G_MISS_NUM THEN
10972: -- Adding a check to find if find line relationship already exists bug 12608111 to avoid data corruption in aso_line_relationships
10973: select count(*) into ct_rel

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

11171: l_pricing_control_rec.price_mode := p_control_rec.price_mode;
11172:
11173: --New Code for to call overload pricing_order
11174:
11175: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
11176: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
11177: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
11178:
11179: if lv_hd_shipment_tbl.count = 1 then

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

11172:
11173: --New Code for to call overload pricing_order
11174:
11175: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
11176: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
11177: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
11178:
11179: if lv_hd_shipment_tbl.count = 1 then
11180: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);

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

11173: --New Code for to call overload pricing_order
11174:
11175: lv_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
11176: lv_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(x_qte_header_rec.quote_header_id,null);
11177: lv_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(x_qte_header_rec.quote_header_id,null);
11178:
11179: if lv_hd_shipment_tbl.count = 1 then
11180: lv_hd_shipment_rec := lv_hd_shipment_tbl(1);
11181: end if;

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

11386: END IF;
11387:
11388:
11389: -- Start of PNPL Changes
11390: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
11391:
11392: l_installment_option := oe_sys_parameters.value(param_name => 'INSTALLMENT_OPTIONS',
11393: p_org_id =>x_qte_header_rec.org_id);
11394:

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

11547: X_Return_Status => x_return_status,
11548: X_Msg_Count => x_msg_count,
11549: X_Msg_Data => x_msg_data);
11550:
11551: x_qte_header_rec := aso_utility_pvt.query_header_row(x_qte_header_rec.quote_header_id);
11552:
11553: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
11554:
11555:

Line 11580: 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');

11576: -- Girish Sachdeva 8/30/2005
11577: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
11578:
11579: IF aso_debug_pub.g_debug_flag = 'Y' THEN
11580: 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');
11581: END IF;
11582:
11583: -- Call to insert record in ASO_CHANGED_QUOTES
11584: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);

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

11580: 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');
11581: END IF;
11582:
11583: -- Call to insert record in ASO_CHANGED_QUOTES
11584: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(x_qte_header_rec.quote_number);
11585:
11586: -- Change END
11587:
11588:

Line 11602: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11598: );
11599:
11600: EXCEPTION
11601: WHEN FND_API.G_EXC_ERROR THEN
11602: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11603: P_API_NAME => L_API_NAME
11604: ,P_PKG_NAME => G_PKG_NAME
11605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11606: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11606: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11602: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11603: P_API_NAME => L_API_NAME
11604: ,P_PKG_NAME => G_PKG_NAME
11605: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11606: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11607: ,P_SQLCODE => SQLCODE
11608: ,P_SQLERRM => SQLERRM
11609: ,X_MSG_COUNT => X_MSG_COUNT
11610: ,X_MSG_DATA => X_MSG_DATA

Line 11614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11610: ,X_MSG_DATA => X_MSG_DATA
11611: ,X_RETURN_STATUS => X_RETURN_STATUS);
11612:
11613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11615: P_API_NAME => L_API_NAME
11616: ,P_PKG_NAME => G_PKG_NAME
11617: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11618: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11618: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11615: P_API_NAME => L_API_NAME
11616: ,P_PKG_NAME => G_PKG_NAME
11617: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11618: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11619: ,P_SQLCODE => SQLCODE
11620: ,P_SQLERRM => SQLERRM
11621: ,X_MSG_COUNT => X_MSG_COUNT
11622: ,X_MSG_DATA => X_MSG_DATA

Line 11626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11622: ,X_MSG_DATA => X_MSG_DATA
11623: ,X_RETURN_STATUS => X_RETURN_STATUS);
11624:
11625: WHEN OTHERS THEN
11626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11627: P_API_NAME => L_API_NAME
11628: ,P_PKG_NAME => G_PKG_NAME
11629: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11629: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

11625: WHEN OTHERS THEN
11626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11627: P_API_NAME => L_API_NAME
11628: ,P_PKG_NAME => G_PKG_NAME
11629: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11631: ,P_SQLCODE => SQLCODE
11632: ,P_SQLERRM => SQLERRM
11633: ,X_MSG_COUNT => X_MSG_COUNT

Line 11630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11626: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11627: P_API_NAME => L_API_NAME
11628: ,P_PKG_NAME => G_PKG_NAME
11629: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11630: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11631: ,P_SQLCODE => SQLCODE
11632: ,P_SQLERRM => SQLERRM
11633: ,X_MSG_COUNT => X_MSG_COUNT
11634: ,X_MSG_DATA => X_MSG_DATA

Line 11801: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11797: );
11798:
11799: EXCEPTION
11800: WHEN FND_API.G_EXC_ERROR THEN
11801: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11802: P_API_NAME => L_API_NAME
11803: ,P_PKG_NAME => G_PKG_NAME
11804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11805: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11805: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11801: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11802: P_API_NAME => L_API_NAME
11803: ,P_PKG_NAME => G_PKG_NAME
11804: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
11805: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11806: ,P_SQLCODE => SQLCODE
11807: ,P_SQLERRM => SQLERRM
11808: ,X_MSG_COUNT => X_MSG_COUNT
11809: ,X_MSG_DATA => X_MSG_DATA

Line 11813: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11809: ,X_MSG_DATA => X_MSG_DATA
11810: ,X_RETURN_STATUS => X_RETURN_STATUS);
11811:
11812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11813: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11814: P_API_NAME => L_API_NAME
11815: ,P_PKG_NAME => G_PKG_NAME
11816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11817: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11817: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11813: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11814: P_API_NAME => L_API_NAME
11815: ,P_PKG_NAME => G_PKG_NAME
11816: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
11817: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11818: ,P_SQLCODE => SQLCODE
11819: ,P_SQLERRM => SQLERRM
11820: ,X_MSG_COUNT => X_MSG_COUNT
11821: ,X_MSG_DATA => X_MSG_DATA

Line 11825: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

11821: ,X_MSG_DATA => X_MSG_DATA
11822: ,X_RETURN_STATUS => X_RETURN_STATUS);
11823:
11824: WHEN OTHERS THEN
11825: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11826: P_API_NAME => L_API_NAME
11827: ,P_PKG_NAME => G_PKG_NAME
11828: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11829: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 11828: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

11824: WHEN OTHERS THEN
11825: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11826: P_API_NAME => L_API_NAME
11827: ,P_PKG_NAME => G_PKG_NAME
11828: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11829: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11830: ,P_SQLCODE => SQLCODE
11831: ,P_SQLERRM => SQLERRM
11832: ,X_MSG_COUNT => X_MSG_COUNT

Line 11829: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

11825: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
11826: P_API_NAME => L_API_NAME
11827: ,P_PKG_NAME => G_PKG_NAME
11828: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
11829: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
11830: ,P_SQLCODE => SQLCODE
11831: ,P_SQLERRM => SQLERRM
11832: ,X_MSG_COUNT => X_MSG_COUNT
11833: ,X_MSG_DATA => X_MSG_DATA

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

12173: aso_debug_pub.add('Copy_Quote - P_Qte_Status_Id '||P_Qte_Status_Id, 1, 'N');
12174: aso_debug_pub.add('Copy_Quote - P_Qte_Number '||P_Qte_Number, 1, 'N');
12175: END IF;
12176:
12177: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
12178: IF (p_new_version = FND_API.G_TRUE AND
12179: l_qte_header_rec.quote_number = p_qte_number) THEN
12180: l_new_version := FND_API.G_TRUE;
12181: END IF;

Line 12356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

12352: );
12353:
12354: EXCEPTION
12355: WHEN FND_API.G_EXC_ERROR THEN
12356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12357: P_API_NAME => L_API_NAME
12358: ,P_PKG_NAME => G_PKG_NAME
12359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12360: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 12360: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

12356: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12357: P_API_NAME => L_API_NAME
12358: ,P_PKG_NAME => G_PKG_NAME
12359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
12360: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12361: ,X_MSG_COUNT => X_MSG_COUNT
12362: ,X_MSG_DATA => X_MSG_DATA
12363: ,X_RETURN_STATUS => X_RETURN_STATUS);
12364:

Line 12366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

12362: ,X_MSG_DATA => X_MSG_DATA
12363: ,X_RETURN_STATUS => X_RETURN_STATUS);
12364:
12365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
12366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12367: P_API_NAME => L_API_NAME
12368: ,P_PKG_NAME => G_PKG_NAME
12369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12370: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 12370: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

12366: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12367: P_API_NAME => L_API_NAME
12368: ,P_PKG_NAME => G_PKG_NAME
12369: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
12370: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12371: ,X_MSG_COUNT => X_MSG_COUNT
12372: ,X_MSG_DATA => X_MSG_DATA
12373: ,X_RETURN_STATUS => X_RETURN_STATUS);
12374:

Line 12376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

12372: ,X_MSG_DATA => X_MSG_DATA
12373: ,X_RETURN_STATUS => X_RETURN_STATUS);
12374:
12375: WHEN OTHERS THEN
12376: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
12377: P_API_NAME => L_API_NAME
12378: ,P_PKG_NAME => G_PKG_NAME
12379: ,P_SQLCODE => SQLCODE
12380: ,P_SQLERRM => SQLERRM

Line 12381: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

12377: P_API_NAME => L_API_NAME
12378: ,P_PKG_NAME => G_PKG_NAME
12379: ,P_SQLCODE => SQLCODE
12380: ,P_SQLERRM => SQLERRM
12381: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
12382: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12383: ,X_MSG_COUNT => X_MSG_COUNT
12384: ,X_MSG_DATA => X_MSG_DATA
12385: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 12382: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

12378: ,P_PKG_NAME => G_PKG_NAME
12379: ,P_SQLCODE => SQLCODE
12380: ,P_SQLERRM => SQLERRM
12381: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
12382: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
12383: ,X_MSG_COUNT => X_MSG_COUNT
12384: ,X_MSG_DATA => X_MSG_DATA
12385: ,X_RETURN_STATUS => X_RETURN_STATUS);
12386: END Copy_Quote;

Line 12574: l_util_order_by_tbl ASO_UTILITY_PVT.Util_order_by_tbl_type;

12570: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
12571: )
12572: IS
12573: l_order_by_cl VARCHAR2(1000) := NULL;
12574: l_util_order_by_tbl ASO_UTILITY_PVT.Util_order_by_tbl_type;
12575: BEGIN
12576:
12577: -- Hint: Developer should add more statements according to ASO_sort_rec_type
12578: -- Ex:

Line 12583: ASO_UTILITY_PVT.Translate_OrderBy(

12579: -- l_util_order_by_tbl(1).col_choice := p_order_by_rec.customer_name;
12580: -- l_util_order_by_tbl(1).col_name := 'Customer_Name';
12581:
12582:
12583: ASO_UTILITY_PVT.Translate_OrderBy(
12584: p_api_version_number => 1.0
12585: ,p_init_msg_list => FND_API.G_FALSE
12586: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
12587: ,p_order_by_tbl => l_util_order_by_tbl

Line 12908: l_flex_where_tbl_type ASO_UTILITY_PVT.flex_where_tbl_type;

12904: l_order_by_cl VARCHAR2(2000);
12905: l_QTE_where VARCHAR2(2000) := '';
12906:
12907: -- For flex field query
12908: l_flex_where_tbl_type ASO_UTILITY_PVT.flex_where_tbl_type;
12909: l_flex_where VARCHAR2(2000) := NULL;
12910: l_counter NUMBER;
12911:
12912: -- Local scratch record

Line 12981: ASO_UTILITY_PVT.Gen_Flexfield_Where(

12977: l_flex_where_tbl_type(14).value := P_Qte_Header_Rec.attribute14;
12978: l_flex_where_tbl_type(15).value := P_Qte_Header_Rec.attribute15;
12979: l_flex_where_tbl_type(16).value := P_Qte_Header_Rec.attribute_category;
12980:
12981: ASO_UTILITY_PVT.Gen_Flexfield_Where(
12982: p_flex_where_tbl_type => l_flex_where_tbl_type,
12983: x_flex_where_clause => l_flex_where);
12984:
12985: -- Hint: if master/detail relationship, generate Where clause for lines level criteria

Line 13005: ASO_UTILITY_PVT.Bind_Flexfield_Where(

13001: -- p_total_amt_ceiling, p_total_amt_floor,
13002: -- l_cur_get_QTE);
13003:
13004: -- Bind flexfield variables
13005: ASO_UTILITY_PVT.Bind_Flexfield_Where(
13006: p_cursor_id => l_cur_get_QTE,
13007: p_flex_where_tbl_type => l_flex_where_tbl_type);
13008:
13009: -- Define all Select Columns

Line 13069: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

13065: );
13066:
13067: EXCEPTION
13068: WHEN FND_API.G_EXC_ERROR THEN
13069: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13070: P_API_NAME => L_API_NAME
13071: ,P_PKG_NAME => G_PKG_NAME
13072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
13073: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 13073: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

13069: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13070: P_API_NAME => L_API_NAME
13071: ,P_PKG_NAME => G_PKG_NAME
13072: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
13073: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
13074: ,X_MSG_COUNT => X_MSG_COUNT
13075: ,X_MSG_DATA => X_MSG_DATA
13076: ,X_RETURN_STATUS => X_RETURN_STATUS);
13077:

Line 13079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

13075: ,X_MSG_DATA => X_MSG_DATA
13076: ,X_RETURN_STATUS => X_RETURN_STATUS);
13077:
13078: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13080: P_API_NAME => L_API_NAME
13081: ,P_PKG_NAME => G_PKG_NAME
13082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 13083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

13079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13080: P_API_NAME => L_API_NAME
13081: ,P_PKG_NAME => G_PKG_NAME
13082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
13083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
13084: ,X_MSG_COUNT => X_MSG_COUNT
13085: ,X_MSG_DATA => X_MSG_DATA
13086: ,X_RETURN_STATUS => X_RETURN_STATUS);
13087:

Line 13089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

13085: ,X_MSG_DATA => X_MSG_DATA
13086: ,X_RETURN_STATUS => X_RETURN_STATUS);
13087:
13088: WHEN OTHERS THEN
13089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13090: P_API_NAME => L_API_NAME
13091: ,P_PKG_NAME => G_PKG_NAME
13092: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
13093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 13092: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

13088: WHEN OTHERS THEN
13089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13090: P_API_NAME => L_API_NAME
13091: ,P_PKG_NAME => G_PKG_NAME
13092: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
13093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
13094: ,X_MSG_COUNT => X_MSG_COUNT
13095: ,X_MSG_DATA => X_MSG_DATA
13096: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 13093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

13089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
13090: P_API_NAME => L_API_NAME
13091: ,P_PKG_NAME => G_PKG_NAME
13092: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
13093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
13094: ,X_MSG_COUNT => X_MSG_COUNT
13095: ,X_MSG_DATA => X_MSG_DATA
13096: ,X_RETURN_STATUS => X_RETURN_STATUS);
13097: End Get_quote;

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

13258:
13259: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13260: aso_debug_pub.add('Copy_Config - inside cursor qte_line_id '|| qte_line_id, 1, 'Y');
13261: END IF;
13262: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
13263:
13264: l_qte_line_rec.quote_header_id := x_qte_header_id;
13265:
13266: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);

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

13262: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
13263:
13264: l_qte_line_rec.quote_header_id := x_qte_header_id;
13265:
13266: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);
13267:
13268: FOR k IN 1..l_qte_line_dtl_tbl.count LOOP
13269: l_qte_line_dtl_tbl(k).config_header_id := p_config_header_id;
13270: l_qte_line_dtl_tbl(k).config_revision_num := p_config_revision_num;

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

13270: l_qte_line_dtl_tbl(k).config_revision_num := p_config_revision_num;
13271: END LOOP;
13272:
13273:
13274: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
13275: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
13276:
13277: FOR j IN 1..l_price_adj_tbl.count LOOP
13278: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

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

13271: END LOOP;
13272:
13273:
13274: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
13275: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
13276:
13277: FOR j IN 1..l_price_adj_tbl.count LOOP
13278: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13279: END LOOP;

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

13277: FOR j IN 1..l_price_adj_tbl.count LOOP
13278: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13279: END LOOP;
13280:
13281: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
13282: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
13283:
13284: FOR j IN 1..l_price_attr_tbl.count LOOP
13285: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

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

13278: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13279: END LOOP;
13280:
13281: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
13282: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
13283:
13284: FOR j IN 1..l_price_attr_tbl.count LOOP
13285: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13286: END LOOP;

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

13284: FOR j IN 1..l_price_attr_tbl.count LOOP
13285: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13286: END LOOP;
13287:
13288: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(qte_header_id, QTE_LINE_ID);
13289:
13290: FOR j IN 1..l_payment_tbl.count LOOP
13291: l_payment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13292: l_payment_tbl(j).CREDIT_CARD_APPROVAL_CODE := NULL;

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

13293: l_payment_tbl(j).CREDIT_CARD_APPROVAL_DATE := NULL;
13294: l_payment_tbl(j).PAYMENT_AMOUNT := NULL;
13295: END LOOP;
13296:
13297: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(qte_header_id, QTE_LINE_ID);
13298: FOR j IN 1..l_shipment_tbl.count LOOP
13299: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13300: END LOOP;
13301:

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

13298: FOR j IN 1..l_shipment_tbl.count LOOP
13299: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13300: END LOOP;
13301:
13302: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(qte_header_id,QTE_LINE_ID);
13303: FOR j IN 1..l_sales_credit_tbl.count LOOP
13304: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13305: END LOOP;
13306:

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

13303: FOR j IN 1..l_sales_credit_tbl.count LOOP
13304: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13305: END LOOP;
13306:
13307: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(qte_header_id,QTE_LINE_ID);
13308: FOR j IN 1..l_quote_party_tbl.count LOOP
13309: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13310: END LOOP;
13311:

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

13308: FOR j IN 1..l_quote_party_tbl.count LOOP
13309: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13310: END LOOP;
13311:
13312: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
13313: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
13314:
13315: OPEN C_Serviceable_Product(l_qte_line_rec.organization_id, l_qte_line_rec.inventory_item_id);
13316: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;

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

13309: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13310: END LOOP;
13311:
13312: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
13313: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
13314:
13315: OPEN C_Serviceable_Product(l_qte_line_rec.organization_id, l_qte_line_rec.inventory_item_id);
13316: FETCH C_Serviceable_Product INTO l_serviceable_product_flag;
13317: CLOSE C_Serviceable_Product;

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

13535: EXIT WHEN line_id_from_service%NOTFOUND;
13536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13537: aso_debug_pub.add('Copy_Service - inside cursor qte_line_id '|| qte_line_id, 1, 'Y');
13538: END IF;
13539: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
13540:
13541: l_qte_line_rec.quote_header_id := x_qte_header_id;
13542:
13543: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);

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

13539: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(qte_line_id);
13540:
13541: l_qte_line_rec.quote_header_id := x_qte_header_id;
13542:
13543: l_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(qte_line_id);
13544:
13545:
13546: IF l_qte_line_dtl_tbl.count > 0 THEN
13547: FOR k IN 1..l_qte_line_dtl_tbl.count LOOP

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

13566: l_qte_line_dtl_tbl(k).config_revision_num := p_config_revision_num;
13567: END LOOP;
13568: */
13569:
13570: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
13571: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
13572:
13573: FOR j IN 1..l_price_adj_tbl.count LOOP
13574: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

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

13567: END LOOP;
13568: */
13569:
13570: l_line_attr_Ext_Tbl := ASO_UTILITY_PVT.Query_Line_Attribs_Ext_Rows(qte_line_id);
13571: l_price_adj_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Rows(qte_header_id,qte_line_id);
13572:
13573: FOR j IN 1..l_price_adj_tbl.count LOOP
13574: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13575: END LOOP;

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

13573: FOR j IN 1..l_price_adj_tbl.count LOOP
13574: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13575: END LOOP;
13576:
13577: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
13578: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
13579:
13580: FOR j IN 1..l_price_attr_tbl.count LOOP
13581: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;

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

13574: l_price_adj_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13575: END LOOP;
13576:
13577: l_price_adj_attr_tbl := ASO_UTILITY_PVT.Query_Price_Adj_Attr_Rows(p_price_adj_tbl => l_price_adj_tbl);
13578: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(qte_header_id, qte_line_id);
13579:
13580: FOR j IN 1..l_price_attr_tbl.count LOOP
13581: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13582: END LOOP;

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

13580: FOR j IN 1..l_price_attr_tbl.count LOOP
13581: l_price_attr_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13582: END LOOP;
13583:
13584: l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(qte_header_id, QTE_LINE_ID);
13585:
13586: FOR j IN 1..l_payment_tbl.count LOOP
13587: l_payment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13588: l_payment_tbl(j).CREDIT_CARD_APPROVAL_CODE := NULL;

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

13589: l_payment_tbl(j).CREDIT_CARD_APPROVAL_DATE := NULL;
13590: l_payment_tbl(j).PAYMENT_AMOUNT := NULL;
13591: END LOOP;
13592:
13593: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(qte_header_id, QTE_LINE_ID);
13594: FOR j IN 1..l_shipment_tbl.count LOOP
13595: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13596: END LOOP;
13597:

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

13594: FOR j IN 1..l_shipment_tbl.count LOOP
13595: l_shipment_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13596: END LOOP;
13597:
13598: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(qte_header_id,QTE_LINE_ID);
13599: FOR j IN 1..l_sales_credit_tbl.count LOOP
13600: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13601: END LOOP;
13602:

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

13599: FOR j IN 1..l_sales_credit_tbl.count LOOP
13600: l_sales_credit_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13601: END LOOP;
13602:
13603: l_quote_party_tbl := ASO_UTILITY_PVT.Query_Quote_Party_Row(qte_header_id,QTE_LINE_ID);
13604: FOR j IN 1..l_quote_party_tbl.count LOOP
13605: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13606: END LOOP;
13607:

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

13604: FOR j IN 1..l_quote_party_tbl.count LOOP
13605: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13606: END LOOP;
13607:
13608: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
13609: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
13610: -- BC4J Fix
13611: --l_qte_line_rec.quote_line_id := null;
13612: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (

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

13605: l_quote_party_tbl(j).QUOTE_HEADER_ID := x_qte_header_id;
13606: END LOOP;
13607:
13608: l_freight_charge_tbl := ASO_UTILITY_PVT.Query_Freight_Charge_Rows(l_shipment_tbl);
13609: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows(qte_header_id,QTE_LINE_ID, l_shipment_tbl);
13610: -- BC4J Fix
13611: --l_qte_line_rec.quote_line_id := null;
13612: ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
13613: p_control_rec => l_control_rec,