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 2006/08/04 01:52:42 bmishra 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 2006/08/04 01:52:42 bmishra 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
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 5699: 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');

5695:
5696: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5697:
5698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5699: 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');
5700: 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');
5701: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5702: 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');
5703: end if;

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

5696: FOR i in 1..p_qte_line_dtl_tbl.count LOOP
5697:
5698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5699: 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');
5700: 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');
5701: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5702: 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');
5703: end if;
5704:

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

5697:
5698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5699: 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');
5700: 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');
5701: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5702: 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');
5703: end if;
5704:
5705: IF ((p_qte_line_dtl_tbl(i).config_header_id IS NOT NULL AND

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

5698: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5699: 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');
5700: 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');
5701: aso_debug_pub.add('ASO_QUOTE_LINES_PVT:Update_Quote_Lines:component_code: '|| p_qte_line_dtl_tbl(i).component_code,1,'N');
5702: 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');
5703: end if;
5704:
5705: IF ((p_qte_line_dtl_tbl(i).config_header_id IS NOT NULL AND
5706: p_qte_line_dtl_tbL(i).config_header_id <> FND_API.G_MISS_NUM) AND

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

5819: ((lx_ln_shipment_tbl(1).ship_from_org_id IS NOT NULL) AND
5820: (lx_ln_shipment_tbl(1).ship_from_org_id <> FND_API.G_MISS_NUM))) THEN
5821:
5822: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5823: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: before Validate_ship_from_org_ID', 1, 'Y');
5824: end if;
5825:
5826: ASO_VALIDATE_PVT.Validate_ship_from_org_ID(
5827: P_Qte_Line_rec => lx_qte_line_rec,

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

5828: P_Shipment_rec => lx_ln_shipment_tbl(1),
5829: x_return_status => x_return_status);
5830:
5831: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5832: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID', 1, 'Y');
5833: end if;
5834:
5835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5836:

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

5834:
5835: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5836:
5837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5838: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_Line: after Validate_ship_from_org_ID: <> SUCCESS', 1, 'Y');
5839: end if;
5840:
5841: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5842: FND_MESSAGE.Set_Name('ASO', 'ASO_INVALID_SHIP_FROM_ORG_ID');

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

6095: l_orig_payment_tbl := l_Payment_Tbl;
6096:
6097: -- inter entity validations
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:

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

6388:
6389: END IF; -- inter entity validation
6390:
6391: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6392: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: UPDATE_QUOTE_LINE: End of Inter entity validations');
6393: end if;
6394:
6395:
6396: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

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

6757: WHEN OTHERS THEN
6758: x_return_status := FND_API.G_RET_STS_ERROR;
6759:
6760: if aso_debug_pub.g_debug_flag = 'Y' then
6761: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_quote_line: line_category_code
6762: update, inside WHEN OTHERS EXCEPTION');
6763: end if;
6764:
6765:

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

7042: END IF;
7043: OPEN c_service (l_Qte_Line_Rec.quote_line_id);
7044: FETCH c_service INTO l_service_item_flag, l_serviceable_product_flag;
7045: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7046: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_service_item_flag'||l_service_item_flag,1,'N');
7047: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag, 1, 'N');
7048: end if;
7049: IF c_service%FOUND THEN
7050: CLOSE c_service;

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

7043: OPEN c_service (l_Qte_Line_Rec.quote_line_id);
7044: FETCH c_service INTO l_service_item_flag, l_serviceable_product_flag;
7045: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7046: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_service_item_flag'||l_service_item_flag,1,'N');
7047: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_serviceable_product_flag'||l_serviceable_product_flag, 1, 'N');
7048: end if;
7049: IF c_service%FOUND THEN
7050: CLOSE c_service;
7051: IF l_service_item_flag = 'Y' THEN

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

7049: IF c_service%FOUND THEN
7050: CLOSE c_service;
7051: IF l_service_item_flag = 'Y' THEN
7052: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7053: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_service_item_flag = Y',1,'N');
7054: end if;
7055: l_service := FND_API.G_TRUE;
7056: l_call_update := FND_API.G_TRUE;
7057: ELSIF l_serviceable_product_flag = 'Y' THEN

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

7055: l_service := FND_API.G_TRUE;
7056: l_call_update := FND_API.G_TRUE;
7057: ELSIF l_serviceable_product_flag = 'Y' THEN
7058: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7059: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: Inside IF l_serviceable_product_flag = Y',
7060: 1,'N');
7061: end if;
7062: l_service := FND_API.G_FALSE;
7063: l_call_update := FND_API.G_TRUE;

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

7063: l_call_update := FND_API.G_TRUE;
7064: END IF;
7065:
7066: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7067: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_call_update'||l_call_update,1,'N');
7068: end if;
7069: IF l_call_update = FND_API.G_TRUE THEN
7070: ASO_QUOTE_LINES_PVT.service_item_qty_update
7071: (p_qte_line_rec => l_Qte_Line_Rec ,

Line 7070: ASO_QUOTE_LINES_PVT.service_item_qty_update

7066: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7067: aso_debug_pub.add('ASO_QUOTE_LINES_PVT: Update_Quote_lines: l_call_update'||l_call_update,1,'N');
7068: end if;
7069: IF l_call_update = FND_API.G_TRUE THEN
7070: ASO_QUOTE_LINES_PVT.service_item_qty_update
7071: (p_qte_line_rec => l_Qte_Line_Rec ,
7072: p_service_item_flag => l_service,
7073: x_return_status => X_return_status
7074: );

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

7072: p_service_item_flag => l_service,
7073: x_return_status => X_return_status
7074: );
7075: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7076: aso_debug_pub.add('Update_Quote_lines - after call to ASO_QUOTE_LINES_PVT.service_item_qty_update '||x_return_status, 1, 'Y');
7077: end if;
7078: END IF;
7079: ELSE
7080: CLOSE c_service;

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

9503:
9504: l_qte_line_rec := aso_quote_pub.g_miss_qte_line_rec;
9505: l_qte_line_rec.quote_line_id := row.quote_line_id;
9506:
9507: aso_quote_lines_pvt.delete_quote_line(
9508: P_Api_Version_Number => 1.0,
9509: p_control_rec => p_control_rec,
9510: p_update_header_flag => fnd_api.g_false,
9511: P_qte_Line_Rec => l_qte_line_rec,

Line 9748: ASO_QUOTE_LINES_PVT.Delete_Quote_Line(

9744: FOR Cur_Children IN C_Children(p_qte_line_rec.quote_line_id) LOOP
9745:
9746: l_qte_line_rec.quote_line_id := Cur_Children.quote_line_id;
9747:
9748: ASO_QUOTE_LINES_PVT.Delete_Quote_Line(
9749: P_Api_Version_Number => 1.0,
9750: p_control_rec => p_control_rec,
9751: p_update_header_flag => p_update_header_flag,
9752: P_qte_Line_Rec => l_qte_line_rec,

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

10264:
10265: END IF;
10266: End service_item_qty_update;
10267:
10268: END ASO_QUOTE_LINES_PVT;