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_LINES_PVT dependencies on ASO_UTILITY_PVT

Line 1158: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Insert_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

1154: open get_quote_number(X_Qte_Line_Rec.QUOTE_HEADER_ID);
1155: fetch get_quote_number into l_quote_number;
1156: if get_quote_number%FOUND then
1157: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1158: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Insert_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
1159: END IF;
1160:
1161: -- Call to insert record in ASO_CHANGED_QUOTES
1162: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 1162: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

1158: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Insert_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
1159: END IF;
1160:
1161: -- Call to insert record in ASO_CHANGED_QUOTES
1162: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
1163: end if;
1164: close get_quote_number;
1165:
1166: -- Change END

Line 2258: l_qte_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);

2254: end if;
2255:
2256: if p_qte_line_dtl_tbl.count = 0 then
2257:
2258: l_qte_line_dtl_tbl := aso_utility_pvt.Query_Line_Dtl_Rows(l_qte_line_rec.quote_line_id);
2259:
2260: if aso_debug_pub.g_debug_flag = 'Y' then
2261: aso_debug_pub.add('After querying line detail tbl from db: l_qte_line_dtl_tbl.count: '|| l_qte_line_dtl_tbl.count, 1, 'N');
2262: end if;

Line 2907: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);

2903: -- validate header information
2904:
2905: IF l_auto_version = 'Y' THEN
2906:
2907: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);
2908:
2909: -- header should be updated only if the flag is set to 'Y'
2910: -- update quote header with the new version number
2911: -- should be called after querying the existing rec and before copying

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

3093:
3094: -- bmishra defaulting framework end
3095:
3096:
3097: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
3098:
3099: -- item type code must exist in aso_lookups and the item, item type
3100: -- should exist in mtl_system_items
3101:

Line 3325: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN

3321: END IF;
3322:
3323:
3324:
3325: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN
3326:
3327: -- if organization id does not exist then it should be defaulted
3328:
3329: IF lx_qte_line_rec.organization_id is NULL or

Line 3559: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(

3555: ELSE
3556:
3557: l_hd_shipment_rec := NULL;
3558:
3559: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(
3560: P_Qte_Header_Id => lx_qte_line_rec.quote_header_id,
3561: P_Qte_Line_Id => NULL
3562: );
3563:

Line 3710: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY THEN

3706: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3707: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: CREATE_QUOTE_LINES: Begin Inter entity validations');
3708: end if;
3709:
3710: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY THEN
3711:
3712: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3713: ASO_DEBUG_PUB.add('cq organization_id = '||nvl(to_char(l_Qte_Line_Rec.organization_id),'null') , 1, 'Y');
3714: ASO_DEBUG_PUB.add('cq Inventory_item_id = '||l_qte_line_rec.inventory_item_id, 1, 'Y');

Line 3901: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_line_rec.QUOTE_HEADER_ID);

3897:
3898: END IF;
3899:
3900:
3901: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_qte_line_rec.QUOTE_HEADER_ID);
3902:
3903: -- IF NVL(FND_PROFILE.value('ASO_TCA_VALIDATE'),'N') = 'Y' THEN
3904: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3905: aso_debug_pub.add('Validation level is set',1,'N');

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

4009: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4010: aso_debug_pub.add('ASO_QUOTE_LINES Create_Quote_lines - after validate_IB_Return_Qty '||x_return_status, 1, 'Y');
4011: end if;
4012:
4013: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4014: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(
4015: p_init_msg_list => FND_API.G_FALSE,
4016: p_sales_credit_tbl => p_sales_credit_tbl,
4017: p_qte_line_rec => l_qte_line_rec,

Line 4065: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( p_qte_line_rec.QUOTE_HEADER_ID,p_qte_line_rec.quote_line_id);

4061: -- EDU
4062:
4063: -- Validate the invoice to cust party id and payment info, if any
4064: IF l_payment_tbl.count = 0 then
4065: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( p_qte_line_rec.QUOTE_HEADER_ID,p_qte_line_rec.quote_line_id);
4066: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4067: aso_debug_pub.add('Before calling Validate_cc_info payment_tbl count is: '|| l_payment_tbl.count, 1, 'Y');
4068: END IF;
4069: End if;

Line 4077: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (p_qte_line_rec.Quote_Header_Id );

4073: IF l_payment_rec.payment_type_code = 'CREDIT_CARD' THEN
4074: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4075: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
4076: END IF;
4077: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (p_qte_line_rec.Quote_Header_Id );
4078:
4079: aso_validate_pvt.Validate_cc_info
4080: (
4081: p_init_msg_list => fnd_api.g_false,

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

4199: aso_debug_pub.add('Validate_Quote_Percent: BEFORE: X_Qte_Line_Rec.quote_header_id: '||X_Qte_Line_Rec.quote_header_id,1,'N');
4200: aso_debug_pub.add('Validate_Quote_Percent: BEFORE: X_Qte_Line_Rec.quote_line_id: '||X_Qte_Line_Rec.quote_line_id,1,'N');
4201: end if;
4202:
4203: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
4204: IF x_sales_credit_tbl.count > 0 THEN
4205: IF x_sales_credit_tbl(1).quote_header_id IS NULL OR x_sales_credit_tbl(1).quote_header_id = FND_API.G_MISS_NUM THEN
4206: x_sales_credit_tbl(1).quote_header_id := X_Qte_Line_Rec.quote_header_id;
4207: END IF;

Line 4241: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);

4237: l_qte_line_tbl(1) := l_qte_line_rec;
4238:
4239: --New Code to call overload pricing_order
4240:
4241: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);
4242: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);
4243:
4244: if l_hd_shipment_tbl.count = 1 then
4245: l_hd_shipment_rec := l_hd_shipment_tbl(1);

Line 4242: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);

4238:
4239: --New Code to call overload pricing_order
4240:
4241: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);
4242: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);
4243:
4244: if l_hd_shipment_tbl.count = 1 then
4245: l_hd_shipment_rec := l_hd_shipment_tbl(1);
4246: end if;

Line 4335: lx_tax_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_line_rec.quote_header_id,x_qte_line_rec.quote_line_id);

4331: -- raise FND_API.G_EXC_ERROR;
4332: END IF;
4333: END IF;
4334:
4335: lx_tax_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_qte_line_rec.quote_header_id,x_qte_line_rec.quote_line_id);
4336:
4337: FOR i in 1..lx_tax_shipment_tbl.count LOOP
4338: l_tax_detail_rec.quote_shipment_id := lx_tax_shipment_tbl(i).shipment_id;
4339:

Line 4519: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Create_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

4515: FROM aso_quote_headers
4516: WHERE quote_header_id = x_Qte_line_rec.quote_header_id ;
4517:
4518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4519: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Create_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
4520: END IF;
4521:
4522: -- Call to insert record in ASO_CHANGED_QUOTES
4523: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 4523: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

4519: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.Create_Quote_lines : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
4520: END IF;
4521:
4522: -- Call to insert record in ASO_CHANGED_QUOTES
4523: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
4524:
4525: -- Change END
4526:
4527:

Line 4548: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4544: );
4545:
4546: EXCEPTION
4547: WHEN FND_API.G_EXC_ERROR THEN
4548: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4549: P_API_NAME => L_API_NAME
4550: ,P_PKG_NAME => G_PKG_NAME
4551: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4552: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4552: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4548: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4549: P_API_NAME => L_API_NAME
4550: ,P_PKG_NAME => G_PKG_NAME
4551: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4552: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4553: ,P_SQLCODE => SQLCODE
4554: ,P_SQLERRM => SQLERRM
4555: ,X_MSG_COUNT => X_MSG_COUNT
4556: ,X_MSG_DATA => X_MSG_DATA

Line 4560: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4556: ,X_MSG_DATA => X_MSG_DATA
4557: ,X_RETURN_STATUS => X_RETURN_STATUS);
4558:
4559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4560: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4561: P_API_NAME => L_API_NAME
4562: ,P_PKG_NAME => G_PKG_NAME
4563: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4564: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4564: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4560: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4561: P_API_NAME => L_API_NAME
4562: ,P_PKG_NAME => G_PKG_NAME
4563: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4564: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4565: ,P_SQLCODE => SQLCODE
4566: ,P_SQLERRM => SQLERRM
4567: ,X_MSG_COUNT => X_MSG_COUNT
4568: ,X_MSG_DATA => X_MSG_DATA

Line 4572: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4568: ,X_MSG_DATA => X_MSG_DATA
4569: ,X_RETURN_STATUS => X_RETURN_STATUS);
4570:
4571: WHEN OTHERS THEN
4572: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4573: P_API_NAME => L_API_NAME
4574: ,P_PKG_NAME => G_PKG_NAME
4575: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4576: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 4575: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

4571: WHEN OTHERS THEN
4572: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4573: P_API_NAME => L_API_NAME
4574: ,P_PKG_NAME => G_PKG_NAME
4575: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4576: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4577: ,P_SQLCODE => SQLCODE
4578: ,P_SQLERRM => SQLERRM
4579: ,X_MSG_COUNT => X_MSG_COUNT

Line 4576: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

4572: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4573: P_API_NAME => L_API_NAME
4574: ,P_PKG_NAME => G_PKG_NAME
4575: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4576: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
4577: ,P_SQLCODE => SQLCODE
4578: ,P_SQLERRM => SQLERRM
4579: ,X_MSG_COUNT => X_MSG_COUNT
4580: ,X_MSG_DATA => X_MSG_DATA

Line 5088: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);

5084: end if;
5085:
5086: IF l_auto_version = 'Y' THEN
5087:
5088: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);
5089:
5090: l_copy_quote_control_rec.new_version := FND_API.G_TRUE;
5091: l_copy_quote_header_rec.quote_header_id := l_old_header_rec.quote_header_id;
5092:

Line 5251: aso_debug_pub.add('Update_Quote_line: ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM: '||ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM, 1, 'Y');

5247: -- bmishra defaulting framework end
5248:
5249: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5250: aso_debug_pub.add('Update_Quote_line - before validation', 1, 'Y');
5251: aso_debug_pub.add('Update_Quote_line: ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM: '||ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM, 1, 'Y');
5252: end if;
5253:
5254: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5255:

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

5250: aso_debug_pub.add('Update_Quote_line - before validation', 1, 'Y');
5251: aso_debug_pub.add('Update_Quote_line: ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM: '||ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM, 1, 'Y');
5252: end if;
5253:
5254: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5255:
5256: ASO_VALIDATE_PVT.Validate_Item_Type_Code(
5257: p_init_msg_list => FND_API.G_FALSE,
5258: p_item_type_code => lx_qte_line_rec.item_type_code,

Line 5547: l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);

5543: END IF;
5544:
5545: END IF;
5546:
5547: l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5548:
5549: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5550: P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5551:

Line 5549: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,

5545: END IF;
5546:
5547: l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5548:
5549: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5550: P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5551:
5552:
5553: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN

Line 5553: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN

5549: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5550: P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5551:
5552:
5553: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN
5554:
5555: IF lx_qte_line_rec.organization_id is NULL or lx_qte_line_rec.organization_id = FND_API.G_MISS_NUM THEN
5556:
5557: IF lx_qte_line_rec.org_id is NULL OR lx_qte_line_rec.org_id = FND_API.G_MISS_NUM THEN

Line 5795: --l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);

5791: */
5792:
5793: -- new validation for ship_from_org_id
5794:
5795: --l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5796:
5797: -- l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5798: -- P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5799:

Line 5797: -- l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,

5793: -- new validation for ship_from_org_id
5794:
5795: --l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5796:
5797: -- l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5798: -- P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5799:
5800: IF l_db_shipment_tbl.count = 1 THEN
5801: l_db_shipment_rec := l_db_shipment_tbl(1);

Line 5902: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,

5898: ELSE
5899:
5900: IF (l_db_shipment_rec.ship_from_org_id IS NULL) OR (l_db_shipment_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
5901:
5902: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5903: P_Qte_Line_Id => NULL);
5904:
5905: IF l_hd_shipment_tbl.count = 1 THEN
5906: l_hd_shipment_rec := l_hd_shipment_tbl(1);

Line 5956: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD

5952: END IF;
5953:
5954: -- end new validation for ship_from_org_id
5955:
5956: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD
5957:
5958:
5959: -- if quantity is decreased check to see if the installation details quantity is not greater than the new quantity
5960: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6102: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY THEN

6098: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6099: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: Begin Inter entity validations');
6100: end if;
6101:
6102: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY THEN
6103:
6104: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6105: ASO_DEBUG_PUB.add('UQ organization_id = '||nvl(to_char(l_Qte_Line_Rec.organization_id),'null') , 1, 'Y');
6106: ASO_DEBUG_PUB.add('UQ Inventory_item_id = '||l_Qte_Line_Rec.inventory_item_id, 1, 'Y');

Line 6185: l_db_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows (P_Qte_Line_Id => l_Qte_Line_Rec.quote_line_id );

6181: END IF;
6182: end if; -- end if for shipment tbl check
6183:
6184:
6185: l_db_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows (P_Qte_Line_Id => l_Qte_Line_Rec.quote_line_id );
6186:
6187: FOR i in 1..l_qte_line_dtl_tbl.count LOOP
6188:
6189: -- bug 4258846

Line 6401: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_Qte_Line_Rec.QUOTE_HEADER_ID);

6397: RAISE FND_API.G_EXC_ERROR;
6398: END IF;
6399:
6400: -- order_type must exist and be active in OE_ORDER_TYPES
6401: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_Qte_Line_Rec.QUOTE_HEADER_ID);
6402:
6403: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6404: aso_debug_pub.add('Validation level is set',1,'N');
6405: aso_debug_pub.add('l_control_rec.application_type_code: '|| l_control_rec.application_type_code ,1,'N');

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

6492: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6493: aso_debug_pub.add('Update_Quote_Line - after Validate_IB_Return_Qty:x_return_status: '||x_return_status, 1, 'N');
6494: end if;
6495:
6496: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
6497:
6498: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(
6499: p_init_msg_list => FND_API.G_FALSE,
6500: p_sales_credit_tbl => p_sales_credit_tbl,

Line 6537: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( l_qte_line_rec.QUOTE_HEADER_ID,l_qte_line_rec.quote_line_id);

6533: END IF;
6534:
6535: -- Validate the invoice to cust party id and payment info, if any
6536: IF l_payment_tbl.count = 0 then
6537: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( l_qte_line_rec.QUOTE_HEADER_ID,l_qte_line_rec.quote_line_id);
6538: Else
6539: -- check to see if the value has been changed, if not get orig value from db
6540: if l_payment_tbl(1).payment_type_code = fnd_api.g_miss_char then
6541: open get_payment_type_code(l_payment_tbl(1).payment_id);

Line 6560: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_qte_line_rec.Quote_Header_Id );

6556: --IF l_payment_rec.payment_type_code = 'CREDIT_CARD' THEN
6557: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6558: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
6559: END IF;
6560: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_qte_line_rec.Quote_Header_Id );
6561:
6562: aso_validate_pvt.Validate_cc_info
6563: (
6564: p_init_msg_list => fnd_api.g_false,

Line 7004: l_db_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows (P_Qte_Line_Id => x_qte_line_rec.quote_line_id );

7000: p_ato_line_id => l_qte_line_dtl_rec.ato_line_id,
7001: p_component_sequence_id => l_qte_line_dtl_rec.component_sequence_id
7002: );
7003:
7004: l_db_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows (P_Qte_Line_Id => x_qte_line_rec.quote_line_id );
7005: IF l_db_qte_line_dtl_tbl(1).service_ref_type_code = 'QUOTE' THEN
7006: OPEN C_Line_relation(l_db_qte_line_dtl_tbl(1).service_ref_line_id, l_db_qte_line_dtl_tbl(1).quote_line_id);
7007: FETCH C_Line_relation INTO l_line_rel;
7008: IF C_Line_relation%NOTFOUND THEN

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

7199: aso_debug_pub.add('Validate_Quote_Percent: BEFORE: l_qte_line_rec.quote_header_id: '||l_qte_line_rec.quote_header_id,1,'N');
7200: aso_debug_pub.add('Validate_Quote_Percent: BEFORE: l_qte_line_rec.quote_line_id: '||l_qte_line_rec.quote_line_id,1,'N');
7201: end if;
7202:
7203: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7204: IF x_sales_credit_tbl.count > 0 THEN
7205: IF x_sales_credit_tbl(1).quote_header_id IS NULL OR x_sales_credit_tbl(1).quote_header_id = FND_API.G_MISS_NUM THEN
7206: x_sales_credit_tbl(1).quote_header_id := l_qte_line_rec.quote_header_id;
7207: END IF;

Line 8722: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);

8718: l_qte_line_tbl(1) := l_Qte_Line_Rec;
8719:
8720: --New Code to call overload pricing_order
8721:
8722: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);
8723: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);
8724:
8725: if l_hd_shipment_tbl.count = 1 then
8726: l_hd_shipment_rec := l_hd_shipment_tbl(1);

Line 8723: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);

8719:
8720: --New Code to call overload pricing_order
8721:
8722: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);
8723: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);
8724:
8725: if l_hd_shipment_tbl.count = 1 then
8726: l_hd_shipment_rec := l_hd_shipment_tbl(1);
8727: end if;

Line 8828: lx_tax_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_Qte_Line_Rec.quote_header_id,l_Qte_Line_Rec.quote_line_id);

8824: -- raise FND_API.G_EXC_ERROR;
8825: END IF;
8826: END IF;
8827:
8828: lx_tax_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_Qte_Line_Rec.quote_header_id,l_Qte_Line_Rec.quote_line_id);
8829:
8830: FOR i in 1..lx_tax_shipment_tbl.count LOOP
8831: l_calc_tax_detail_rec.quote_shipment_id := lx_tax_shipment_tbl(i).shipment_id;
8832:

Line 8972: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Private API: '|| l_api_name || 'error in updating header');

8968: END IF;
8969:
8970: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
8971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8972: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Private API: '|| l_api_name || 'error in updating header');
8973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8974: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
8975: x_return_status := FND_API.G_RET_STS_ERROR;
8976: END IF;

Line 8992: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.update_quote_line : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');

8988: FROM aso_quote_headers
8989: WHERE quote_header_id = l_Qte_Line_Rec.quote_header_id;
8990:
8991: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8992: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.update_quote_line : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
8993: END IF;
8994:
8995: -- Call to insert record in ASO_CHANGED_QUOTES
8996: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 8996: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

8992: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.update_quote_line : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_quote_number, 1, 'Y');
8993: END IF;
8994:
8995: -- Call to insert record in ASO_CHANGED_QUOTES
8996: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
8997:
8998: -- Change END
8999:
9000:

Line 9016: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9012: );
9013:
9014: EXCEPTION
9015: WHEN FND_API.G_EXC_ERROR THEN
9016: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9017: P_API_NAME => L_API_NAME
9018: ,P_PKG_NAME => G_PKG_NAME
9019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9020: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9020: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9016: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9017: P_API_NAME => L_API_NAME
9018: ,P_PKG_NAME => G_PKG_NAME
9019: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9020: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9021: ,P_SQLCODE => SQLCODE
9022: ,P_SQLERRM => SQLERRM
9023: ,X_MSG_COUNT => X_MSG_COUNT
9024: ,X_MSG_DATA => X_MSG_DATA

Line 9028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9024: ,X_MSG_DATA => X_MSG_DATA
9025: ,X_RETURN_STATUS => X_RETURN_STATUS);
9026:
9027: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9029: P_API_NAME => L_API_NAME
9030: ,P_PKG_NAME => G_PKG_NAME
9031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9028: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9029: P_API_NAME => L_API_NAME
9030: ,P_PKG_NAME => G_PKG_NAME
9031: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9032: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9033: ,P_SQLCODE => SQLCODE
9034: ,P_SQLERRM => SQLERRM
9035: ,X_MSG_COUNT => X_MSG_COUNT
9036: ,X_MSG_DATA => X_MSG_DATA

Line 9040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9036: ,X_MSG_DATA => X_MSG_DATA
9037: ,X_RETURN_STATUS => X_RETURN_STATUS);
9038:
9039: WHEN OTHERS THEN
9040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9041: P_API_NAME => L_API_NAME
9042: ,P_PKG_NAME => G_PKG_NAME
9043: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9043: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

9039: WHEN OTHERS THEN
9040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9041: P_API_NAME => L_API_NAME
9042: ,P_PKG_NAME => G_PKG_NAME
9043: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9045: ,P_SQLCODE => SQLCODE
9046: ,P_SQLERRM => SQLERRM
9047: ,X_MSG_COUNT => X_MSG_COUNT

Line 9044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9041: P_API_NAME => L_API_NAME
9042: ,P_PKG_NAME => G_PKG_NAME
9043: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9045: ,P_SQLCODE => SQLCODE
9046: ,P_SQLERRM => SQLERRM
9047: ,X_MSG_COUNT => X_MSG_COUNT
9048: ,X_MSG_DATA => X_MSG_DATA

Line 9321: l_old_header_rec := aso_utility_pvt.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);

9317:
9318:
9319: IF l_auto_version = 'Y' THEN
9320:
9321: l_old_header_rec := aso_utility_pvt.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);
9322:
9323: IF l_quote_header_id IS NULL OR l_quote_header_id = FND_API.G_MISS_NUM THEN
9324:
9325: open c_get_quote( p_qte_line_rec.quote_line_id);

Line 9619: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(p_qte_line_rec.quote_header_id,p_qte_line_rec.quote_line_id);

9615: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9616: aso_debug_pub.add('Delete_Quote_Line: Before call to delete_payment_row ', 1, 'Y');
9617: END IF;
9618:
9619: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(p_qte_line_rec.quote_header_id,p_qte_line_rec.quote_line_id);
9620:
9621: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9622: aso_debug_pub.add('Delete_Quote_Line: l_payment_tbl.count: '|| l_payment_tbl.count, 1, 'Y');
9623: END IF;

Line 9942: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.delete_quote_line : Before calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, Quote Header ID :' || p_qte_line_rec.quote_header_id, 1, 'Y');

9938:
9939: IF ((p_qte_line_rec.quote_header_id is not null) and (p_qte_line_rec.quote_header_id <> FND_API.G_MISS_NUM)) THEN
9940:
9941: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9942: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.delete_quote_line : Before calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, Quote Header ID :' || p_qte_line_rec.quote_header_id, 1, 'Y');
9943: END IF;
9944:
9945: OPEN get_qte_nbr(p_qte_line_rec.quote_header_id);
9946: FETCH get_qte_nbr INTO l_qte_number;

Line 9950: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.delete_quote_line : Before calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_qte_number, 1, 'Y');

9946: FETCH get_qte_nbr INTO l_qte_number;
9947: CLOSE get_qte_nbr;
9948:
9949: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9950: aso_debug_pub.add('ASO_QUOTE_LINES_PVT.delete_quote_line : Before calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_qte_number, 1, 'Y');
9951: END IF;
9952:
9953:
9954: -- Call to insert record in ASO_CHANGED_QUOTES

Line 9955: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_number);

9951: END IF;
9952:
9953:
9954: -- Call to insert record in ASO_CHANGED_QUOTES
9955: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_number);
9956:
9957: END IF ;
9958:
9959: -- Change END

Line 9978: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9974:
9975: EXCEPTION
9976:
9977: WHEN FND_API.G_EXC_ERROR THEN
9978: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9979: P_API_NAME => L_API_NAME
9980: ,P_PKG_NAME => G_PKG_NAME
9981: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9982: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9982: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9978: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9979: P_API_NAME => L_API_NAME
9980: ,P_PKG_NAME => G_PKG_NAME
9981: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9982: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9983: ,P_SQLCODE => SQLCODE
9984: ,P_SQLERRM => SQLERRM
9985: ,X_MSG_COUNT => X_MSG_COUNT
9986: ,X_MSG_DATA => X_MSG_DATA

Line 9990: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9986: ,X_MSG_DATA => X_MSG_DATA
9987: ,X_RETURN_STATUS => X_RETURN_STATUS);
9988:
9989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9990: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9991: P_API_NAME => L_API_NAME
9992: ,P_PKG_NAME => G_PKG_NAME
9993: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9994: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9994: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9990: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9991: P_API_NAME => L_API_NAME
9992: ,P_PKG_NAME => G_PKG_NAME
9993: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9994: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9995: ,P_SQLCODE => SQLCODE
9996: ,P_SQLERRM => SQLERRM
9997: ,X_MSG_COUNT => X_MSG_COUNT
9998: ,X_MSG_DATA => X_MSG_DATA

Line 10002: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9998: ,X_MSG_DATA => X_MSG_DATA
9999: ,X_RETURN_STATUS => X_RETURN_STATUS);
10000:
10001: WHEN OTHERS THEN
10002: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10003: P_API_NAME => L_API_NAME
10004: ,P_PKG_NAME => G_PKG_NAME
10005: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10006: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10005: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

10001: WHEN OTHERS THEN
10002: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10003: P_API_NAME => L_API_NAME
10004: ,P_PKG_NAME => G_PKG_NAME
10005: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10006: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10007: ,P_SQLCODE => SQLCODE
10008: ,P_SQLERRM => SQLERRM
10009: ,X_MSG_COUNT => X_MSG_COUNT

Line 10006: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10002: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10003: P_API_NAME => L_API_NAME
10004: ,P_PKG_NAME => G_PKG_NAME
10005: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10006: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10007: ,P_SQLCODE => SQLCODE
10008: ,P_SQLERRM => SQLERRM
10009: ,X_MSG_COUNT => X_MSG_COUNT
10010: ,X_MSG_DATA => X_MSG_DATA

Line 10140: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_rec.quote_line_id);

10136: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10137: aso_debug_pub.add('Service_item_qty_update: Inside IF condition p_service_item_flag = FND_API.G_FALSE', 1, 'N');
10138: end if;
10139:
10140: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_rec.quote_line_id);
10141: begin
10142: UPDATE aso_quote_lines_all
10143: set quantity = l_qte_line_rec.quantity,
10144: last_update_date = sysdate,

Line 10162: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_rec.quote_line_id);

10158: ELSE
10159: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10160: aso_debug_pub.add('Service_item_qty_update:ELSE condition of p_service_item_flag = FND_API.G_FALSE', 1, 'N');
10161: end if;
10162: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_rec.quote_line_id);
10163:
10164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10165: aso_debug_pub.add('Service_item_qty_update: ASO_UTILITY_PVT.Query_Line_Dtl_Rows', 1, 'N');
10166: end if;

Line 10165: aso_debug_pub.add('Service_item_qty_update: ASO_UTILITY_PVT.Query_Line_Dtl_Rows', 1, 'N');

10161: end if;
10162: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_rec.quote_line_id);
10163:
10164: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10165: aso_debug_pub.add('Service_item_qty_update: ASO_UTILITY_PVT.Query_Line_Dtl_Rows', 1, 'N');
10166: end if;
10167:
10168: FOR i IN 1..l_qte_line_detail_tbl.count LOOP
10169: IF l_qte_line_detail_tbl(i).service_ref_type_code = 'QUOTE' THEN