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_QUOTE_LINES_PVT

Line 1: PACKAGE BODY ASO_QUOTE_LINES_PVT as

1: PACKAGE BODY ASO_QUOTE_LINES_PVT as
2: /* $Header: asovqlnb.pls 120.34.12010000.5 2010/05/02 17:33:32 akushwah ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_LINES_PVT
5: -- Purpose :

Line 4: -- Package name : ASO_QUOTE_LINES_PVT

1: PACKAGE BODY ASO_QUOTE_LINES_PVT as
2: /* $Header: asovqlnb.pls 120.34.12010000.5 2010/05/02 17:33:32 akushwah ship $ */
3: -- Start of Comments
4: -- Package name : ASO_QUOTE_LINES_PVT
5: -- Purpose :
6: -- History :
7: -- 10/20/2002 hyang - 2633507 performance fix
8: -- 08/19/04 skulkarn - In new BC4J implementation, the primary key for

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_LINES_PVT';

14: -- NOTE :
15: -- End of Comments
16:
17:
18: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ASO_QUOTE_LINES_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asovqlnb.pls';
20:
21: type number_tbl_type is table of number index by BINARY_INTEGER;
22:

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 3436: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');

3432: END LOOP;
3433:
3434: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3436: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
3437: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
3438: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
3439: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
3440: end if;

Line 3437: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');

3433:
3434: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3436: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
3437: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
3438: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
3439: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
3440: end if;
3441:

Line 3438: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');

3434: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
3435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3436: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
3437: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
3438: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
3439: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
3440: end if;
3441:
3442: -- We will add config_item_id when we will implement solution model

Line 3439: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');

3435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3436: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
3437: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
3438: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
3439: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Create_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
3440: end if;
3441:
3442: -- We will add config_item_id when we will implement solution model
3443: IF ((p_qte_line_dtl_tbl(i).config_header_id IS NOT NULL AND

Line 3529: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID', 1, 'Y');

3525: end if;
3526:
3527: IF lx_ln_shipment_tbl(1).ship_from_org_id IS NOT NULL AND lx_ln_shipment_tbl(1).ship_from_org_id <> FND_API.G_MISS_NUM THEN
3528: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3529: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID', 1, 'Y');
3530: end if;
3531: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
3532: P_qte_line_rec => lx_qte_line_rec,
3533: P_Shipment_rec => lx_ln_shipment_tbl(1),

Line 3537: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID', 1, 'Y');

3533: P_Shipment_rec => lx_ln_shipment_tbl(1),
3534: x_return_status => x_return_status);
3535:
3536: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3537: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID', 1, 'Y');
3538: end if;
3539: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3540: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3541: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');

Line 3541: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');

3537: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID', 1, 'Y');
3538: end if;
3539: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3540: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3541: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
3542: end if;
3543:
3544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3545: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

Line 3569: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.quote_header_id: '||lx_qte_line_rec.quote_header_id, 1, 'Y');

3565: l_hd_shipment_rec := l_hd_shipment_tbl(1);
3566: END IF;
3567:
3568: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3569: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.quote_header_id: '||lx_qte_line_rec.quote_header_id, 1, 'Y');
3570: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.inventory_item_id: '||lx_qte_line_rec.inventory_item_id, 1, 'Y');
3571: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: l_hd_shipment_rec.ship_from_org_id: '||l_hd_shipment_rec.ship_from_org_id, 1, 'Y');
3572: end if;
3573:

Line 3570: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.inventory_item_id: '||lx_qte_line_rec.inventory_item_id, 1, 'Y');

3566: END IF;
3567:
3568: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3569: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.quote_header_id: '||lx_qte_line_rec.quote_header_id, 1, 'Y');
3570: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.inventory_item_id: '||lx_qte_line_rec.inventory_item_id, 1, 'Y');
3571: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: l_hd_shipment_rec.ship_from_org_id: '||l_hd_shipment_rec.ship_from_org_id, 1, 'Y');
3572: end if;
3573:
3574: IF l_hd_shipment_rec.ship_from_org_id IS NOT NULL AND l_hd_shipment_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN

Line 3571: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: l_hd_shipment_rec.ship_from_org_id: '||l_hd_shipment_rec.ship_from_org_id, 1, 'Y');

3567:
3568: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3569: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.quote_header_id: '||lx_qte_line_rec.quote_header_id, 1, 'Y');
3570: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: lx_qte_line_rec.inventory_item_id: '||lx_qte_line_rec.inventory_item_id, 1, 'Y');
3571: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID: l_hd_shipment_rec.ship_from_org_id: '||l_hd_shipment_rec.ship_from_org_id, 1, 'Y');
3572: end if;
3573:
3574: IF l_hd_shipment_rec.ship_from_org_id IS NOT NULL AND l_hd_shipment_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
3575: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 3576: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID (no ln_shipment_tbl)', 1, 'Y');

3572: end if;
3573:
3574: IF l_hd_shipment_rec.ship_from_org_id IS NOT NULL AND l_hd_shipment_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
3575: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3576: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: before Validate_ship_from_org_ID (no ln_shipment_tbl)', 1, 'Y');
3577: end if;
3578: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
3579: P_Qte_Line_rec => lx_qte_line_rec,
3580: P_Shipment_rec => l_hd_shipment_rec,

Line 3585: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID (no ln_shipment_tbl)', 1, 'Y');

3581: x_return_status => x_return_status
3582: );
3583:
3584: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3585: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID (no ln_shipment_tbl)', 1, 'Y');
3586: end if;
3587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3589: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');

Line 3589: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');

3585: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID (no ln_shipment_tbl)', 1, 'Y');
3586: end if;
3587: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3588: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3589: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_Lines: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
3590: end if;
3591:
3592: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3593: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

Line 3707: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: CREATE_QUOTE_LINES: Begin Inter entity validations');

3703:
3704: --inter entity validations
3705:
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:

Line 3885: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: CREATE_QUOTE_LINES: End of Inter entity validations');

3881:
3882: END IF;
3883:
3884: IF aso_debug_pub.g_debug_flag = 'Y' THEN
3885: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: CREATE_QUOTE_LINES: End of Inter entity validations');
3886: end if;
3887:
3888:
3889: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 4162: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_service_item_flag'||l_service_item_flag,1, 'N');

4158: OPEN c_service (X_Qte_Line_Rec.quote_line_id);
4159:
4160: FETCH c_service INTO l_service_item_flag, l_serviceable_product_flag;
4161: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4162: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_service_item_flag'||l_service_item_flag,1, 'N');
4163: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag,1, 'N');
4164: end if;
4165: IF c_service%FOUND THEN
4166: CLOSE c_service;

Line 4163: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag,1, 'N');

4159:
4160: FETCH c_service INTO l_service_item_flag, l_serviceable_product_flag;
4161: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4162: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_service_item_flag'||l_service_item_flag,1, 'N');
4163: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag,1, 'N');
4164: end if;
4165: IF c_service%FOUND THEN
4166: CLOSE c_service;
4167: IF l_service_item_flag = 'Y' THEN

Line 4176: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_call_update'||l_call_update,1, 'N');

4172: l_call_update := FND_API.G_TRUE;
4173: END IF;
4174:
4175: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4176: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_call_update'||l_call_update,1, 'N');
4177: end if;
4178:
4179: IF l_call_update = FND_API.G_TRUE THEN
4180: ASO_QUOTE_LINES_PVT.service_item_qty_update

Line 4180: ASO_QUOTE_LINES_PVT.service_item_qty_update

4176: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Create_Quote_lines: l_call_update'||l_call_update,1, 'N');
4177: end if;
4178:
4179: IF l_call_update = FND_API.G_TRUE THEN
4180: ASO_QUOTE_LINES_PVT.service_item_qty_update
4181: (p_qte_line_rec => X_Qte_Line_Rec ,
4182: p_service_item_flag => l_service,
4183: x_return_status => X_return_status
4184: );

Line 4186: aso_debug_pub.add('Create_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '|| x_return_status, 1, 'Y');

4182: p_service_item_flag => l_service,
4183: x_return_status => X_return_status
4184: );
4185: IF aso_debug_pub.g_debug_flag = 'Y' THEN
4186: aso_debug_pub.add('Create_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '|| x_return_status, 1, 'Y');
4187: end if;
4188: END IF;
4189: ELSE
4190: CLOSE c_service;

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 5817: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');

5813:
5814: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5815:
5816: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5817: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
5818: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5819: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5820: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
5821: end if;

Line 5818: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');

5814: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5815:
5816: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5817: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
5818: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5819: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5820: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
5821: end if;
5822:

Line 5819: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');

5815:
5816: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5817: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
5818: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5819: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5820: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
5821: end if;
5822:
5823: IF ((p_qte_line_dtl_tbl(i).config_header_id IS NOT NULL AND

Line 5820: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');

5816: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5817: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_header_id: '|| p_qte_line_dtl_tbl(i).config_header_id,1,'N');
5818: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_revision_num: '|| p_qte_line_dtl_tbl(i).config_revision_num,1,'N');
5819: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5820: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:config_item_id: '|| p_qte_line_dtl_tbl(i).config_item_id,1,'N');
5821: end if;
5822:
5823: IF ((p_qte_line_dtl_tbl(i).config_header_id IS NOT NULL AND
5824: p_qte_line_dtl_tbL(i).config_header_id <> FND_API.G_MISS_NUM) AND

Line 5941: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');

5937: ((lx_ln_shipment_tbl(1).ship_from_org_id IS NOT NULL) AND
5938: (lx_ln_shipment_tbl(1).ship_from_org_id <> FND_API.G_MISS_NUM))) THEN
5939:
5940: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5941: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');
5942: end if;
5943:
5944: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5945: P_Qte_Line_rec => lx_qte_line_rec,

Line 5950: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID', 1, 'Y');

5946: P_Shipment_rec => lx_ln_shipment_tbl(1),
5947: x_return_status => x_return_status);
5948:
5949: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5950: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID', 1, 'Y');
5951: end if;
5952:
5953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5954:

Line 5956: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');

5952:
5953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5954:
5955: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5956: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
5957: end if;
5958:
5959: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5960: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

Line 6217: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: Begin Inter entity validations');

6213: l_orig_payment_tbl := l_Payment_Tbl;
6214:
6215: -- inter entity validations
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:

Line 6510: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: End of Inter entity validations');

6506:
6507: END IF; -- inter entity validation
6508:
6509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6510: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: End of Inter entity validations');
6511: end if;
6512:
6513:
6514: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 6879: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_quote_line: line_category_code

6875: WHEN OTHERS THEN
6876: x_return_status := FND_API.G_RET_STS_ERROR;
6877:
6878: if aso_debug_pub.g_debug_flag = 'Y' then
6879: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_quote_line: line_category_code
6880: update, inside WHEN OTHERS EXCEPTION');
6881: end if;
6882:
6883:

Line 7164: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_service_item_flag'||l_service_item_flag,1,'N');

7160: END IF;
7161: OPEN c_service (l_Qte_Line_Rec.quote_line_id);
7162: FETCH c_service INTO l_service_item_flag, l_serviceable_product_flag;
7163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7164: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_service_item_flag'||l_service_item_flag,1,'N');
7165: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag, 1, 'N');
7166: end if;
7167: IF c_service%FOUND THEN
7168: CLOSE c_service;

Line 7165: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag, 1, 'N');

7161: OPEN c_service (l_Qte_Line_Rec.quote_line_id);
7162: FETCH c_service INTO l_service_item_flag, l_serviceable_product_flag;
7163: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7164: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_service_item_flag'||l_service_item_flag,1,'N');
7165: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag, 1, 'N');
7166: end if;
7167: IF c_service%FOUND THEN
7168: CLOSE c_service;
7169: IF l_service_item_flag = 'Y' THEN

Line 7171: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_service_item_flag = Y',1,'N');

7167: IF c_service%FOUND THEN
7168: CLOSE c_service;
7169: IF l_service_item_flag = 'Y' THEN
7170: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7171: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_service_item_flag = Y',1,'N');
7172: end if;
7173: l_service := FND_API.G_TRUE;
7174: l_call_update := FND_API.G_TRUE;
7175: ELSIF l_serviceable_product_flag = 'Y' THEN

Line 7177: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_serviceable_product_flag = Y',

7173: l_service := FND_API.G_TRUE;
7174: l_call_update := FND_API.G_TRUE;
7175: ELSIF l_serviceable_product_flag = 'Y' THEN
7176: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7177: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_serviceable_product_flag = Y',
7178: 1,'N');
7179: end if;
7180: l_service := FND_API.G_FALSE;
7181: l_call_update := FND_API.G_TRUE;

Line 7185: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_call_update'||l_call_update,1,'N');

7181: l_call_update := FND_API.G_TRUE;
7182: END IF;
7183:
7184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7185: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_call_update'||l_call_update,1,'N');
7186: end if;
7187: IF l_call_update = FND_API.G_TRUE THEN
7188: ASO_QUOTE_LINES_PVT.service_item_qty_update
7189: (p_qte_line_rec => l_Qte_Line_Rec ,

Line 7188: ASO_QUOTE_LINES_PVT.service_item_qty_update

7184: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7185: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_call_update'||l_call_update,1,'N');
7186: end if;
7187: IF l_call_update = FND_API.G_TRUE THEN
7188: ASO_QUOTE_LINES_PVT.service_item_qty_update
7189: (p_qte_line_rec => l_Qte_Line_Rec ,
7190: p_service_item_flag => l_service,
7191: x_return_status => X_return_status
7192: );

Line 7194: aso_debug_pub.add('Update_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '||x_return_status, 1, 'Y');

7190: p_service_item_flag => l_service,
7191: x_return_status => X_return_status
7192: );
7193: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7194: aso_debug_pub.add('Update_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '||x_return_status, 1, 'Y');
7195: end if;
7196: END IF;
7197: ELSE
7198: CLOSE c_service;

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 9625: aso_quote_lines_pvt.delete_quote_line(

9621:
9622: l_qte_line_rec := aso_quote_pub.g_miss_qte_line_rec;
9623: l_qte_line_rec.quote_line_id := row.quote_line_id;
9624:
9625: aso_quote_lines_pvt.delete_quote_line(
9626: P_Api_Version_Number => 1.0,
9627: p_control_rec => p_control_rec,
9628: p_update_header_flag => fnd_api.g_false,
9629: P_qte_Line_Rec => l_qte_line_rec,

Line 9866: ASO_QUOTE_LINES_PVT.Delete_Quote_Line(

9862: FOR Cur_Children IN C_Children(p_qte_line_rec.quote_line_id) LOOP
9863:
9864: l_qte_line_rec.quote_line_id := Cur_Children.quote_line_id;
9865:
9866: ASO_QUOTE_LINES_PVT.Delete_Quote_Line(
9867: P_Api_Version_Number => 1.0,
9868: p_control_rec => p_control_rec,
9869: p_update_header_flag => p_update_header_flag,
9870: P_qte_Line_Rec => l_qte_line_rec,

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 10410: END ASO_QUOTE_LINES_PVT;

10406:
10407: END IF;
10408: End service_item_qty_update;
10409:
10410: END ASO_QUOTE_LINES_PVT;