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_all -- bug 8968033
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 5112: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);

5108: end if;
5109:
5110: IF l_auto_version = 'Y' THEN
5111:
5112: l_old_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);
5113:
5114: l_copy_quote_control_rec.new_version := FND_API.G_TRUE;
5115: l_copy_quote_header_rec.quote_header_id := l_old_header_rec.quote_header_id;
5116:

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

5365: /* Code change for Quoting Usability Sun ER End */
5366:
5367: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5368: aso_debug_pub.add('Update_Quote_line - before validation', 1, 'Y');
5369: aso_debug_pub.add('Update_Quote_line: ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM: '||ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM, 1, 'Y');
5370: end if;
5371:
5372: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5373:

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

5368: aso_debug_pub.add('Update_Quote_line - before validation', 1, 'Y');
5369: aso_debug_pub.add('Update_Quote_line: ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM: '||ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM, 1, 'Y');
5370: end if;
5371:
5372: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
5373:
5374: ASO_VALIDATE_PVT.Validate_Item_Type_Code(
5375: p_init_msg_list => FND_API.G_FALSE,
5376: p_item_type_code => lx_qte_line_rec.item_type_code,

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

5661: END IF;
5662:
5663: END IF;
5664:
5665: l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5666:
5667: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5668: P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5669:

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

5663: END IF;
5664:
5665: l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5666:
5667: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5668: P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5669:
5670:
5671: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN

Line 5671: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN

5667: l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5668: P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5669:
5670:
5671: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD THEN
5672:
5673: IF lx_qte_line_rec.organization_id is NULL or lx_qte_line_rec.organization_id = FND_API.G_MISS_NUM THEN
5674:
5675: IF lx_qte_line_rec.org_id is NULL OR lx_qte_line_rec.org_id = FND_API.G_MISS_NUM THEN

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

5909: */
5910:
5911: -- new validation for ship_from_org_id
5912:
5913: --l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5914:
5915: -- l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5916: -- P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5917:

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

5911: -- new validation for ship_from_org_id
5912:
5913: --l_db_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row( P_Qte_Line_Id => lx_qte_line_rec.quote_line_id);
5914:
5915: -- l_db_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
5916: -- P_Qte_Line_Id => l_db_qte_line_rec.quote_line_id);
5917:
5918: IF l_db_shipment_tbl.count = 1 THEN
5919: l_db_shipment_rec := l_db_shipment_tbl(1);

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

6016: ELSE
6017:
6018: 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
6019:
6020: l_hd_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows( P_Qte_Header_Id => l_db_qte_line_rec.quote_header_id,
6021: P_Qte_Line_Id => NULL);
6022:
6023: IF l_hd_shipment_tbl.count = 1 THEN
6024: l_hd_shipment_rec := l_hd_shipment_tbl(1);

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

6070: END IF;
6071:
6072: -- end new validation for ship_from_org_id
6073:
6074: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_RECORD
6075:
6076:
6077: -- if quantity is decreased check to see if the installation details quantity is not greater than the new quantity
6078: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6220: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY THEN

6216: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6217: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: Begin Inter entity validations');
6218: end if;
6219:
6220: IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_ENTITY THEN
6221:
6222: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6223: ASO_DEBUG_PUB.add('UQ organization_id = '||nvl(to_char(l_Qte_Line_Rec.organization_id),'null') , 1, 'Y');
6224: ASO_DEBUG_PUB.add('UQ Inventory_item_id = '||l_Qte_Line_Rec.inventory_item_id, 1, 'Y');

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

6299: END IF;
6300: end if; -- end if for shipment tbl check
6301:
6302:
6303: l_db_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows (P_Qte_Line_Id => l_Qte_Line_Rec.quote_line_id );
6304:
6305: FOR i in 1..l_qte_line_dtl_tbl.count LOOP
6306:
6307: -- bug 4258846

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

6515: RAISE FND_API.G_EXC_ERROR;
6516: END IF;
6517:
6518: -- order_type must exist and be active in OE_ORDER_TYPES
6519: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(l_Qte_Line_Rec.QUOTE_HEADER_ID);
6520:
6521: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6522: aso_debug_pub.add('Validation level is set',1,'N');
6523: aso_debug_pub.add('l_control_rec.application_type_code: '|| l_control_rec.application_type_code ,1,'N');

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

6610: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6611: aso_debug_pub.add('Update_Quote_Line - after Validate_IB_Return_Qty:x_return_status: '||x_return_status, 1, 'N');
6612: end if;
6613:
6614: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
6615:
6616: ASO_VALIDATE_PVT.Validate_Sales_Credit_Return(
6617: p_init_msg_list => FND_API.G_FALSE,
6618: p_sales_credit_tbl => p_sales_credit_tbl,

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

6651: END IF;
6652:
6653: -- Validate the invoice to cust party id and payment info, if any
6654: IF l_payment_tbl.count = 0 then
6655: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows( l_qte_line_rec.QUOTE_HEADER_ID,l_qte_line_rec.quote_line_id);
6656: Else
6657: -- check to see if the value has been changed, if not get orig value from db
6658: if l_payment_tbl(1).payment_type_code = fnd_api.g_miss_char then
6659: open get_payment_type_code(l_payment_tbl(1).payment_id);

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

6674: --IF l_payment_rec.payment_type_code = 'CREDIT_CARD' THEN
6675: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6676: aso_debug_pub.add('Before calling Validate_cc_info ', 1, 'Y');
6677: END IF;
6678: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row (l_qte_line_rec.Quote_Header_Id );
6679:
6680: aso_validate_pvt.Validate_cc_info
6681: (
6682: p_init_msg_list => fnd_api.g_false,

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

7118: p_ato_line_id => l_qte_line_dtl_rec.ato_line_id,
7119: p_component_sequence_id => l_qte_line_dtl_rec.component_sequence_id
7120: );
7121:
7122: l_db_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows (P_Qte_Line_Id => x_qte_line_rec.quote_line_id );
7123: IF l_db_qte_line_dtl_tbl(1).service_ref_type_code = 'QUOTE' THEN
7124: 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);
7125: FETCH C_Line_relation INTO l_line_rel;
7126: IF C_Line_relation%NOTFOUND THEN

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

7317: aso_debug_pub.add('Validate_Quote_Percent: BEFORE: l_qte_line_rec.quote_header_id: '||l_qte_line_rec.quote_header_id,1,'N');
7318: aso_debug_pub.add('Validate_Quote_Percent: BEFORE: l_qte_line_rec.quote_line_id: '||l_qte_line_rec.quote_line_id,1,'N');
7319: end if;
7320:
7321: IF ( P_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM) THEN
7322: IF x_sales_credit_tbl.count > 0 THEN
7323: 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
7324: x_sales_credit_tbl(1).quote_header_id := l_qte_line_rec.quote_header_id;
7325: END IF;

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

8836: l_qte_line_tbl(1) := l_Qte_Line_Rec;
8837:
8838: --New Code to call overload pricing_order
8839:
8840: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);
8841: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);
8842:
8843: if l_hd_shipment_tbl.count = 1 then
8844: l_hd_shipment_rec := l_hd_shipment_tbl(1);

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

8837:
8838: --New Code to call overload pricing_order
8839:
8840: l_hd_price_attr_tbl := aso_utility_pvt.query_price_attr_rows(l_qte_header_rec.quote_header_id,null);
8841: l_hd_shipment_tbl := aso_utility_pvt.query_shipment_rows(l_qte_header_rec.quote_header_id,null);
8842:
8843: if l_hd_shipment_tbl.count = 1 then
8844: l_hd_shipment_rec := l_hd_shipment_tbl(1);
8845: end if;

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

8942: -- raise FND_API.G_EXC_ERROR;
8943: END IF;
8944: END IF;
8945:
8946: lx_tax_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(l_Qte_Line_Rec.quote_header_id,l_Qte_Line_Rec.quote_line_id);
8947:
8948: FOR i in 1..lx_tax_shipment_tbl.count LOOP
8949: l_calc_tax_detail_rec.quote_shipment_id := lx_tax_shipment_tbl(i).shipment_id;
8950:

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

9086: END IF;
9087:
9088: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
9089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9090: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH, 'Private API: '|| l_api_name || 'error in updating header');
9091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9092: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
9093: x_return_status := FND_API.G_RET_STS_ERROR;
9094: END IF;

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

9106: FROM aso_quote_headers_all -- bug 8968033
9107: WHERE quote_header_id = l_Qte_Line_Rec.quote_header_id;
9108:
9109: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9110: 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');
9111: END IF;
9112:
9113: -- Call to insert record in ASO_CHANGED_QUOTES
9114: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

Line 9114: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);

9110: 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');
9111: END IF;
9112:
9113: -- Call to insert record in ASO_CHANGED_QUOTES
9114: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_quote_number);
9115:
9116: -- Change END
9117:
9118:

Line 9134: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9130: );
9131:
9132: EXCEPTION
9133: WHEN FND_API.G_EXC_ERROR THEN
9134: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9135: P_API_NAME => L_API_NAME
9136: ,P_PKG_NAME => G_PKG_NAME
9137: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9138: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9138: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9134: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9135: P_API_NAME => L_API_NAME
9136: ,P_PKG_NAME => G_PKG_NAME
9137: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
9138: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9139: ,P_SQLCODE => SQLCODE
9140: ,P_SQLERRM => SQLERRM
9141: ,X_MSG_COUNT => X_MSG_COUNT
9142: ,X_MSG_DATA => X_MSG_DATA

Line 9146: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9142: ,X_MSG_DATA => X_MSG_DATA
9143: ,X_RETURN_STATUS => X_RETURN_STATUS);
9144:
9145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9146: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9147: P_API_NAME => L_API_NAME
9148: ,P_PKG_NAME => G_PKG_NAME
9149: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9150: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9150: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9146: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9147: P_API_NAME => L_API_NAME
9148: ,P_PKG_NAME => G_PKG_NAME
9149: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
9150: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9151: ,P_SQLCODE => SQLCODE
9152: ,P_SQLERRM => SQLERRM
9153: ,X_MSG_COUNT => X_MSG_COUNT
9154: ,X_MSG_DATA => X_MSG_DATA

Line 9158: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

9154: ,X_MSG_DATA => X_MSG_DATA
9155: ,X_RETURN_STATUS => X_RETURN_STATUS);
9156:
9157: WHEN OTHERS THEN
9158: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9159: P_API_NAME => L_API_NAME
9160: ,P_PKG_NAME => G_PKG_NAME
9161: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9162: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 9161: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

9157: WHEN OTHERS THEN
9158: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9159: P_API_NAME => L_API_NAME
9160: ,P_PKG_NAME => G_PKG_NAME
9161: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9162: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9163: ,P_SQLCODE => SQLCODE
9164: ,P_SQLERRM => SQLERRM
9165: ,X_MSG_COUNT => X_MSG_COUNT

Line 9162: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

9158: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
9159: P_API_NAME => L_API_NAME
9160: ,P_PKG_NAME => G_PKG_NAME
9161: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
9162: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
9163: ,P_SQLCODE => SQLCODE
9164: ,P_SQLERRM => SQLERRM
9165: ,X_MSG_COUNT => X_MSG_COUNT
9166: ,X_MSG_DATA => X_MSG_DATA

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

9435:
9436:
9437: IF l_auto_version = 'Y' THEN
9438:
9439: l_old_header_rec := aso_utility_pvt.Query_Header_Row(p_qte_line_rec.QUOTE_HEADER_ID);
9440:
9441: IF l_quote_header_id IS NULL OR l_quote_header_id = FND_API.G_MISS_NUM THEN
9442:
9443: open c_get_quote( p_qte_line_rec.quote_line_id);

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

9733: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9734: aso_debug_pub.add('Delete_Quote_Line: Before call to delete_payment_row ', 1, 'Y');
9735: END IF;
9736:
9737: l_payment_tbl := aso_utility_pvt.Query_Payment_Rows(p_qte_line_rec.quote_header_id,p_qte_line_rec.quote_line_id);
9738:
9739: IF aso_debug_pub.g_debug_flag = 'Y' THEN
9740: aso_debug_pub.add('Delete_Quote_Line: l_payment_tbl.count: '|| l_payment_tbl.count, 1, 'Y');
9741: END IF;

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

10056:
10057: 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
10058:
10059: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10060: 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');
10061: END IF;
10062:
10063: OPEN get_qte_nbr(p_qte_line_rec.quote_header_id);
10064: FETCH get_qte_nbr INTO l_qte_number;

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

10064: FETCH get_qte_nbr INTO l_qte_number;
10065: CLOSE get_qte_nbr;
10066:
10067: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10068: 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');
10069: END IF;
10070:
10071:
10072: -- Call to insert record in ASO_CHANGED_QUOTES

Line 10073: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_number);

10069: END IF;
10070:
10071:
10072: -- Call to insert record in ASO_CHANGED_QUOTES
10073: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_number);
10074:
10075: END IF ;
10076:
10077: -- Change END

Line 10096: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10092:
10093: EXCEPTION
10094:
10095: WHEN FND_API.G_EXC_ERROR THEN
10096: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10097: P_API_NAME => L_API_NAME
10098: ,P_PKG_NAME => G_PKG_NAME
10099: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10100: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10100: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10096: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10097: P_API_NAME => L_API_NAME
10098: ,P_PKG_NAME => G_PKG_NAME
10099: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
10100: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10101: ,P_SQLCODE => SQLCODE
10102: ,P_SQLERRM => SQLERRM
10103: ,X_MSG_COUNT => X_MSG_COUNT
10104: ,X_MSG_DATA => X_MSG_DATA

Line 10108: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10104: ,X_MSG_DATA => X_MSG_DATA
10105: ,X_RETURN_STATUS => X_RETURN_STATUS);
10106:
10107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10108: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10109: P_API_NAME => L_API_NAME
10110: ,P_PKG_NAME => G_PKG_NAME
10111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10112: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10112: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10108: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10109: P_API_NAME => L_API_NAME
10110: ,P_PKG_NAME => G_PKG_NAME
10111: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
10112: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10113: ,P_SQLCODE => SQLCODE
10114: ,P_SQLERRM => SQLERRM
10115: ,X_MSG_COUNT => X_MSG_COUNT
10116: ,X_MSG_DATA => X_MSG_DATA

Line 10120: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

10116: ,X_MSG_DATA => X_MSG_DATA
10117: ,X_RETURN_STATUS => X_RETURN_STATUS);
10118:
10119: WHEN OTHERS THEN
10120: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10121: P_API_NAME => L_API_NAME
10122: ,P_PKG_NAME => G_PKG_NAME
10123: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10124: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 10123: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

10119: WHEN OTHERS THEN
10120: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10121: P_API_NAME => L_API_NAME
10122: ,P_PKG_NAME => G_PKG_NAME
10123: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10124: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10125: ,P_SQLCODE => SQLCODE
10126: ,P_SQLERRM => SQLERRM
10127: ,X_MSG_COUNT => X_MSG_COUNT

Line 10124: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

10120: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
10121: P_API_NAME => L_API_NAME
10122: ,P_PKG_NAME => G_PKG_NAME
10123: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
10124: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
10125: ,P_SQLCODE => SQLCODE
10126: ,P_SQLERRM => SQLERRM
10127: ,X_MSG_COUNT => X_MSG_COUNT
10128: ,X_MSG_DATA => X_MSG_DATA

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

10254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10255: aso_debug_pub.add('Service_item_qty_update: Inside IF condition p_service_item_flag = FND_API.G_FALSE', 1, 'N');
10256: end if;
10257:
10258: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_rec.quote_line_id);
10259: begin
10260: UPDATE aso_quote_lines_all
10261: set quantity = l_qte_line_rec.quantity,
10262: last_update_date = sysdate,

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

10276: ELSE
10277: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10278: aso_debug_pub.add('Service_item_qty_update:ELSE condition of p_service_item_flag = FND_API.G_FALSE', 1, 'N');
10279: end if;
10280: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_rec.quote_line_id);
10281:
10282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10283: aso_debug_pub.add('Service_item_qty_update: ASO_UTILITY_PVT.Query_Line_Dtl_Rows', 1, 'N');
10284: end if;

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

10279: end if;
10280: l_qte_line_detail_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_qte_line_rec.quote_line_id);
10281:
10282: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10283: aso_debug_pub.add('Service_item_qty_update: ASO_UTILITY_PVT.Query_Line_Dtl_Rows', 1, 'N');
10284: end if;
10285:
10286: FOR i IN 1..l_qte_line_detail_tbl.count LOOP
10287: IF l_qte_line_detail_tbl(i).service_ref_type_code = 'QUOTE' THEN