[Home] [Help]
51:
52: BEGIN
53: l_api_name := UPPER(p_api_name);
54:
55: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
56: aso_debug_pub.add('Exception in package : '|| P_PKG_NAME, 1, 'N');
57: aso_debug_pub.add('Exception in API : '|| P_API_NAME, 1, 'N');
58: aso_debug_pub.add('SQLCODE : '|| P_SQLCODE, 1, 'N');
59: aso_debug_pub.add('SQLERRM : '|| P_SQLERRM, 1, 'N');
52: BEGIN
53: l_api_name := UPPER(p_api_name);
54:
55: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
56: aso_debug_pub.add('Exception in package : '|| P_PKG_NAME, 1, 'N');
57: aso_debug_pub.add('Exception in API : '|| P_API_NAME, 1, 'N');
58: aso_debug_pub.add('SQLCODE : '|| P_SQLCODE, 1, 'N');
59: aso_debug_pub.add('SQLERRM : '|| P_SQLERRM, 1, 'N');
60: END IF;
53: l_api_name := UPPER(p_api_name);
54:
55: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
56: aso_debug_pub.add('Exception in package : '|| P_PKG_NAME, 1, 'N');
57: aso_debug_pub.add('Exception in API : '|| P_API_NAME, 1, 'N');
58: aso_debug_pub.add('SQLCODE : '|| P_SQLCODE, 1, 'N');
59: aso_debug_pub.add('SQLERRM : '|| P_SQLERRM, 1, 'N');
60: END IF;
61:
54:
55: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
56: aso_debug_pub.add('Exception in package : '|| P_PKG_NAME, 1, 'N');
57: aso_debug_pub.add('Exception in API : '|| P_API_NAME, 1, 'N');
58: aso_debug_pub.add('SQLCODE : '|| P_SQLCODE, 1, 'N');
59: aso_debug_pub.add('SQLERRM : '|| P_SQLERRM, 1, 'N');
60: END IF;
61:
62: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
55: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
56: aso_debug_pub.add('Exception in package : '|| P_PKG_NAME, 1, 'N');
57: aso_debug_pub.add('Exception in API : '|| P_API_NAME, 1, 'N');
58: aso_debug_pub.add('SQLCODE : '|| P_SQLCODE, 1, 'N');
59: aso_debug_pub.add('SQLERRM : '|| P_SQLERRM, 1, 'N');
60: END IF;
61:
62: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || p_package_type);
63: IF p_exception_level = FND_MSG_PUB.G_MSG_LVL_ERROR
4328: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4329:
4330: BEGIN
4331:
4332: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4333: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Rows p_qte_header_id: '||p_qte_header_id,1,'Y');
4334: END IF;
4335:
4336: FOR c_qte_line_rec IN c_Qte_Line LOOP
4329:
4330: BEGIN
4331:
4332: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4333: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Rows p_qte_header_id: '||p_qte_header_id,1,'Y');
4334: END IF;
4335:
4336: FOR c_qte_line_rec IN c_Qte_Line LOOP
4337: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4333: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Rows p_qte_header_id: '||p_qte_header_id,1,'Y');
4334: END IF;
4335:
4336: FOR c_qte_line_rec IN c_Qte_Line LOOP
4337: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4338: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.quote_line_id: '
4339: ||c_qte_line_rec.quote_line_id,1,'Y');
4340: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.service_item_flag: '
4341: ||c_qte_line_rec.service_item_flag,1,'Y');
4334: END IF;
4335:
4336: FOR c_qte_line_rec IN c_Qte_Line LOOP
4337: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4338: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.quote_line_id: '
4339: ||c_qte_line_rec.quote_line_id,1,'Y');
4340: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.service_item_flag: '
4341: ||c_qte_line_rec.service_item_flag,1,'Y');
4342: END IF;
4336: FOR c_qte_line_rec IN c_Qte_Line LOOP
4337: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4338: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.quote_line_id: '
4339: ||c_qte_line_rec.quote_line_id,1,'Y');
4340: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.service_item_flag: '
4341: ||c_qte_line_rec.service_item_flag,1,'Y');
4342: END IF;
4343:
4344: IF NVL(c_qte_line_rec.service_item_flag,'N') = 'Y' THEN
4344: IF NVL(c_qte_line_rec.service_item_flag,'N') = 'Y' THEN
4345: OPEN c_qte_line_SVC_ref(c_qte_line_rec.quote_line_id);
4346: FETCH c_qte_line_SVC_ref INTO l_ref_type_code, l_service_ref_line_id;
4347: CLOSE c_qte_line_SVC_ref;
4348: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4349: aso_debug_pub.add('ASO_UTL_PVT: Parent Service Line collection ... ',1,'Y');
4350: END IF;
4351:
4352: IF l_ref_type_code = 'ORDER' THEN
4345: OPEN c_qte_line_SVC_ref(c_qte_line_rec.quote_line_id);
4346: FETCH c_qte_line_SVC_ref INTO l_ref_type_code, l_service_ref_line_id;
4347: CLOSE c_qte_line_SVC_ref;
4348: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4349: aso_debug_pub.add('ASO_UTL_PVT: Parent Service Line collection ... ',1,'Y');
4350: END IF;
4351:
4352: IF l_ref_type_code = 'ORDER' THEN
4353: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4350: END IF;
4351:
4352: IF l_ref_type_code = 'ORDER' THEN
4353: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4354: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4355: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has already been added to l_qte_line_tbl.',1,'Y');
4356: END IF;
4357: ELSE
4358: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4351:
4352: IF l_ref_type_code = 'ORDER' THEN
4353: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4354: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4355: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has already been added to l_qte_line_tbl.',1,'Y');
4356: END IF;
4357: ELSE
4358: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4359: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4356: END IF;
4357: ELSE
4358: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4359: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4361: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4362: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4363: ||NVL(to_char(l_order_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4364: END IF;
4357: ELSE
4358: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4359: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4361: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4362: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4363: ||NVL(to_char(l_order_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4364: END IF;
4365: l_qte_line_rec.QUOTE_LINE_ID := c_order_line_rec.LINE_ID;
4358: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4359: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4360: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4361: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4362: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4363: ||NVL(to_char(l_order_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4364: END IF;
4365: l_qte_line_rec.QUOTE_LINE_ID := c_order_line_rec.LINE_ID;
4366: l_qte_line_rec.INVENTORY_ITEM_ID := c_order_line_rec.INVENTORY_ITEM_ID;
4373:
4374: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4375: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4376: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4378: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4379: END IF;
4380: If P_change_line_flag = FND_API.G_FALSE Then
4381: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4374: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4375: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4376: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4377: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4378: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4379: END IF;
4380: If P_change_line_flag = FND_API.G_FALSE Then
4381: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4382: else
4381: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4382: else
4383: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4384: end if;
4385: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4386: aso_debug_pub.add('Order Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
4387: END IF;
4388:
4389: END LOOP;
4382: else
4383: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4384: end if;
4385: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4386: aso_debug_pub.add('Order Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
4387: END IF;
4388:
4389: END LOOP;
4390: END IF;--l_order_ref_line_id_tbl.exists(l_service_ref_line_id)
4389: END LOOP;
4390: END IF;--l_order_ref_line_id_tbl.exists(l_service_ref_line_id)
4391: ELSIF l_ref_type_code = 'CUSTOMER_PRODUCT' THEN
4392: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4393: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4394: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4395: END IF;
4396: ELSE
4397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4390: END IF;--l_order_ref_line_id_tbl.exists(l_service_ref_line_id)
4391: ELSIF l_ref_type_code = 'CUSTOMER_PRODUCT' THEN
4392: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4393: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4394: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4395: END IF;
4396: ELSE
4397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4398: aso_debug_pub.add('ASO_UTL_PVT: Before customer install processing:',1,'Y');
4393: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4394: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4395: END IF;
4396: ELSE
4397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4398: aso_debug_pub.add('ASO_UTL_PVT: Before customer install processing:',1,'Y');
4399: END IF;
4400: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4401: --FOR c_get_cust_acct_id_rec IN c_get_cust_acct_id LOOP
4394: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4395: END IF;
4396: ELSE
4397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4398: aso_debug_pub.add('ASO_UTL_PVT: Before customer install processing:',1,'Y');
4399: END IF;
4400: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4401: --FOR c_get_cust_acct_id_rec IN c_get_cust_acct_id LOOP
4402: open c_get_cust_acct_id_ln(c_qte_line_rec.quote_line_id);
4409: end if;
4410: close c_get_cust_acct_id;
4411: end if;
4412: close c_get_cust_acct_id_ln;
4413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4414: aso_debug_pub.add('ASO_UTL_PVT: l_cust_account_id:'||l_cust_account_id,1,'Y');
4415:
4416: END IF;
4417: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4410: close c_get_cust_acct_id;
4411: end if;
4412: close c_get_cust_acct_id_ln;
4413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4414: aso_debug_pub.add('ASO_UTL_PVT: l_cust_account_id:'||l_cust_account_id,1,'Y');
4415:
4416: END IF;
4417: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4418: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4420: For c_get_orig_order_line_id_rec IN c_get_orig_order_line_id(l_service_ref_line_id,l_cust_account_id) LOOP
4421:
4422: l_order_found := FALSE; -- fix for bug Bug 9724104
4423:
4424: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4425: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4426: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4427: ||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4428: END IF;
4421:
4422: l_order_found := FALSE; -- fix for bug Bug 9724104
4423:
4424: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4425: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4426: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4427: ||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4428: END IF;
4429:
4422: l_order_found := FALSE; -- fix for bug Bug 9724104
4423:
4424: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4425: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4426: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4427: ||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4428: END IF;
4429:
4430: FOR c_order_line_rec IN c_order_line(c_get_orig_order_line_id_rec.original_order_line_id) LOOP
4440:
4441: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4442: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4443: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4445: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4446: END IF;
4447: If P_change_line_flag = FND_API.G_FALSE Then
4448: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4441: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4442: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4443: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4444: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4445: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4446: END IF;
4447: If P_change_line_flag = FND_API.G_FALSE Then
4448: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4449: else
4448: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4449: else
4450: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4451: end if;
4452: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4453: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4454: END IF;
4455:
4456: END LOOP;
4449: else
4450: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4451: end if;
4452: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4453: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4454: END IF;
4455:
4456: END LOOP;
4457:
4461: /****** Start SUN Changes ER:3802859 *******/
4462:
4463: IF l_order_found = FALSE THEN -- this means no order line was found then
4464:
4465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4466: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4467: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4468: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4469: END IF;
4462:
4463: IF l_order_found = FALSE THEN -- this means no order line was found then
4464:
4465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4466: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4467: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4468: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4469: END IF;
4470:
4463: IF l_order_found = FALSE THEN -- this means no order line was found then
4464:
4465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4466: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4467: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4468: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4469: END IF;
4470:
4471: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
4464:
4465: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4466: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4467: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4468: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4469: END IF;
4470:
4471: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
4472: fetch c_csi_line_details into l_prod,l_item_id,l_qty,l_uom;
4470:
4471: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
4472: fetch c_csi_line_details into l_prod,l_item_id,l_qty,l_uom;
4473:
4474: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4475: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** After fetching the csi line details', 1, 'N');
4476: END IF;
4477:
4478: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id;
4471: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
4472: fetch c_csi_line_details into l_prod,l_item_id,l_qty,l_uom;
4473:
4474: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4475: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** After fetching the csi line details', 1, 'N');
4476: END IF;
4477:
4478: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id;
4479: l_qte_line_rec.INVENTORY_ITEM_ID := l_item_id;
4492:
4493: l_qte_line_rec.PRICING_QUANTITY := l_qty;
4494: l_qte_line_rec.PRICING_QUANTITY_UOM := l_UOM;
4495: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4497: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4498: END IF;
4499: If P_change_line_flag = FND_API.G_FALSE Then
4500: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4493: l_qte_line_rec.PRICING_QUANTITY := l_qty;
4494: l_qte_line_rec.PRICING_QUANTITY_UOM := l_UOM;
4495: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4496: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4497: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4498: END IF;
4499: If P_change_line_flag = FND_API.G_FALSE Then
4500: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4501: else
4500: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4501: else
4502: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4503: end if;
4504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4505: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4506: END IF;
4507:
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4501: else
4502: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4503: end if;
4504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4505: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4506: END IF;
4507:
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4504: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4505: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4506: END IF;
4507:
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4505: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4506: END IF;
4507:
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4513: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4506: END IF;
4507:
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4513: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4514: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4507:
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4513: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4514: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4515: END IF;
4508: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4513: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4514: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4515: END IF;
4516:
4509: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4513: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4514: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4515: END IF;
4516:
4517: close c_csi_line_details;
4510: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
4511: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
4512: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
4513: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4514: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4515: END IF;
4516:
4517: close c_csi_line_details;
4518: END IF;
4524: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
4525: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4526: ELSIF l_ref_type_code = 'PRODUCT_CATALOG' THEN
4527: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4528: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4529: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4530: END IF;
4531: ELSE
4532: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4525: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4526: ELSIF l_ref_type_code = 'PRODUCT_CATALOG' THEN
4527: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4528: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4529: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4530: END IF;
4531: ELSE
4532: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4533: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before product catalog processing:',1,'Y');
4528: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4529: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4530: END IF;
4531: ELSE
4532: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4533: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before product catalog processing:',1,'Y');
4534: END IF;
4535:
4536:
4529: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
4530: END IF;
4531: ELSE
4532: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4533: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before product catalog processing:',1,'Y');
4534: END IF;
4535:
4536:
4537: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4534: END IF;
4535:
4536:
4537: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4538: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4539: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
4540: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4541:
4542: END IF;
4535:
4536:
4537: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4538: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4539: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
4540: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4541:
4542: END IF;
4543:
4536:
4537: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4538: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4539: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
4540: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4541:
4542: END IF;
4543:
4544: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id; --c_qte_line_rec.QUOTE_LINE_ID;
4560: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4561: else
4562: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4563: end if;
4564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4565: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4566: END IF;
4567:
4568:
4561: else
4562: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4563: end if;
4564: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4565: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4566: END IF;
4567:
4568:
4569:
4566: END IF;
4567:
4568:
4569:
4570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4571: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4567:
4568:
4569:
4570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4571: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4575: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4568:
4569:
4570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4571: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4575: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4576: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4569:
4570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4571: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4575: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4576: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4577: END IF;
4570: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4571: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4575: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4576: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4577: END IF;
4578: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
4571: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4575: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4576: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4577: END IF;
4578: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
4579:
4572: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_item_id: '|| l_qte_line_rec.INVENTORY_ITEM_ID , 1, 'N');
4573: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qty: '|| l_qte_line_rec.QUANTITY , 1, 'N');
4574: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_uom: '|| l_qte_line_rec.UOM_CODE, 1, 'N');
4575: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
4576: aso_debug_pub.add('ASO_UTL_PVT: **** ER:II ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
4577: END IF;
4578: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
4579:
4580: END IF;--elsif l_ref_type_code = 'PRODUCT_CATALOG'
4667: /* l_qte_line_rec.PRODUCT_FISC_CLASSIFICATION := c_qte_line_rec.PRODUCT_FISC_CLASSIFICATION;
4668: l_qte_line_rec.TRX_BUSINESS_CATEGORY := c_qte_line_rec.TRX_BUSINESS_CATEGORY;*/
4669:
4670: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4672: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4673: END IF;
4674: If P_change_line_flag = FND_API.G_FALSE Then
4675: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4668: l_qte_line_rec.TRX_BUSINESS_CATEGORY := c_qte_line_rec.TRX_BUSINESS_CATEGORY;*/
4669:
4670: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
4671: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4672: aso_debug_pub.add('ASO_UTL_PVT:P_change_line_flag:'||P_change_line_flag,1,'Y');
4673: END IF;
4674: If P_change_line_flag = FND_API.G_FALSE Then
4675: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4676: else
4676: else
4677: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4678: end if;
4679:
4680: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4681: aso_debug_pub.add('Quote Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
4682: END IF;
4683: END LOOP;
4684: RETURN l_Qte_Line_tbl;
4677: l_Qte_Line_tbl(l_qte_line_rec.QUOTE_LINE_ID) := l_Qte_Line_rec;
4678: end if;
4679:
4680: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4681: aso_debug_pub.add('Quote Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
4682: END IF;
4683: END LOOP;
4684: RETURN l_Qte_Line_tbl;
4685:
4877: l_Qte_Line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4878: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4879: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4880: BEGIN
4881: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row p_qte_header_id: '||p_qte_header_id,1,'Y');
4883: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row P_Qte_Line_Id: '||P_Qte_Line_Id,1,'Y');
4884: END IF;
4885:
4878: l_service_ref_line_id_tbl Index_Link_Tbl_Type;
4879: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4880: BEGIN
4881: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row p_qte_header_id: '||p_qte_header_id,1,'Y');
4883: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row P_Qte_Line_Id: '||P_Qte_Line_Id,1,'Y');
4884: END IF;
4885:
4886: FOR c_qte_line_rec IN c_Qte_Line LOOP
4879: l_order_ref_line_id_tbl Index_Link_Tbl_Type;
4880: BEGIN
4881: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4882: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row p_qte_header_id: '||p_qte_header_id,1,'Y');
4883: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row P_Qte_Line_Id: '||P_Qte_Line_Id,1,'Y');
4884: END IF;
4885:
4886: FOR c_qte_line_rec IN c_Qte_Line LOOP
4887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4883: aso_debug_pub.add('ASO_UTL_PVT: Start Query Pricing Line Row P_Qte_Line_Id: '||P_Qte_Line_Id,1,'Y');
4884: END IF;
4885:
4886: FOR c_qte_line_rec IN c_Qte_Line LOOP
4887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4888: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.quote_line_id: '
4889: ||c_qte_line_rec.quote_line_id,1,'Y');
4890: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.service_item_flag: '
4891: ||c_qte_line_rec.service_item_flag,1,'Y');
4884: END IF;
4885:
4886: FOR c_qte_line_rec IN c_Qte_Line LOOP
4887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4888: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.quote_line_id: '
4889: ||c_qte_line_rec.quote_line_id,1,'Y');
4890: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.service_item_flag: '
4891: ||c_qte_line_rec.service_item_flag,1,'Y');
4892: END IF;
4886: FOR c_qte_line_rec IN c_Qte_Line LOOP
4887: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4888: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.quote_line_id: '
4889: ||c_qte_line_rec.quote_line_id,1,'Y');
4890: aso_debug_pub.add('ASO_UTL_PVT: Inside c_qte_line_rec with c_qte_line_rec.service_item_flag: '
4891: ||c_qte_line_rec.service_item_flag,1,'Y');
4892: END IF;
4893:
4894: IF NVL(c_qte_line_rec.service_item_flag,'N') = 'Y' THEN
4895: OPEN c_qte_line_SVC_ref(c_qte_line_rec.quote_line_id);
4896: FETCH c_qte_line_SVC_ref INTO l_ref_type_code, l_service_ref_line_id;
4897: CLOSE c_qte_line_SVC_ref;
4898:
4899: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4900: aso_debug_pub.add('ASO_UTL_PVT: Parent Service Line collection ... ',1,'Y');
4901: END IF;
4902: IF l_ref_type_code = 'ORDER' THEN
4903: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4896: FETCH c_qte_line_SVC_ref INTO l_ref_type_code, l_service_ref_line_id;
4897: CLOSE c_qte_line_SVC_ref;
4898:
4899: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4900: aso_debug_pub.add('ASO_UTL_PVT: Parent Service Line collection ... ',1,'Y');
4901: END IF;
4902: IF l_ref_type_code = 'ORDER' THEN
4903: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4904: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4900: aso_debug_pub.add('ASO_UTL_PVT: Parent Service Line collection ... ',1,'Y');
4901: END IF;
4902: IF l_ref_type_code = 'ORDER' THEN
4903: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4904: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4905: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has already been added to l_qte_line_tbl.',1,'Y');
4906: END IF;
4907: ELSE
4908: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4901: END IF;
4902: IF l_ref_type_code = 'ORDER' THEN
4903: IF l_order_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4904: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4905: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has already been added to l_qte_line_tbl.',1,'Y');
4906: END IF;
4907: ELSE
4908: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4909: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4906: END IF;
4907: ELSE
4908: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4909: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4910: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4911: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4912: aso_debug_pub.add('ASO_UTL_PVT: l_order_ref_line_id_tbl('||l_service_ref_line_id||').:'
4913: ||NVL(to_char(l_order_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4914: END IF;
4907: ELSE
4908: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4909: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4910: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4911: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4912: aso_debug_pub.add('ASO_UTL_PVT: l_order_ref_line_id_tbl('||l_service_ref_line_id||').:'
4913: ||NVL(to_char(l_order_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4914: END IF;
4915: l_qte_line_rec.QUOTE_LINE_ID := c_order_line_rec.LINE_ID;
4908: FOR c_order_line_rec IN c_order_line(l_service_ref_line_id) LOOP
4909: l_order_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4910: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4911: aso_debug_pub.add('ASO_UTL_PVT: Parent Order Line has not yet been added to l_qte_line_tbl.', 1, 'N');
4912: aso_debug_pub.add('ASO_UTL_PVT: l_order_ref_line_id_tbl('||l_service_ref_line_id||').:'
4913: ||NVL(to_char(l_order_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4914: END IF;
4915: l_qte_line_rec.QUOTE_LINE_ID := c_order_line_rec.LINE_ID;
4916: l_qte_line_rec.INVENTORY_ITEM_ID := c_order_line_rec.INVENTORY_ITEM_ID;
4923:
4924: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4925: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4926: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4927: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4928: aso_debug_pub.add('Order Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
4929: END IF;
4930: END LOOP;
4931: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
4924: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4925: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4926: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4927: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4928: aso_debug_pub.add('Order Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
4929: END IF;
4930: END LOOP;
4931: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
4932:
4932:
4933: ELSIF l_ref_type_code = 'CUSTOMER_PRODUCT' THEN
4934:
4935: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4936: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4937: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line already added to l_qte_line_tbl.',1,'Y');
4938: END IF;
4939: ELSE
4940: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4933: ELSIF l_ref_type_code = 'CUSTOMER_PRODUCT' THEN
4934:
4935: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
4936: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4937: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line already added to l_qte_line_tbl.',1,'Y');
4938: END IF;
4939: ELSE
4940: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4941: aso_debug_pub.add('ASO_UTL_PVT: Before customer install processing:',1,'Y');
4936: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4937: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line already added to l_qte_line_tbl.',1,'Y');
4938: END IF;
4939: ELSE
4940: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4941: aso_debug_pub.add('ASO_UTL_PVT: Before customer install processing:',1,'Y');
4942: END IF;
4943: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4944: --FOR c_get_cust_acct_id_rec IN c_get_cust_acct_id LOOP
4937: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line already added to l_qte_line_tbl.',1,'Y');
4938: END IF;
4939: ELSE
4940: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4941: aso_debug_pub.add('ASO_UTL_PVT: Before customer install processing:',1,'Y');
4942: END IF;
4943: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4944: --FOR c_get_cust_acct_id_rec IN c_get_cust_acct_id LOOP
4945: open c_get_cust_acct_id_ln(c_qte_line_rec.quote_line_id);
4952: end if;
4953: close c_get_cust_acct_id;
4954: end if;
4955: close c_get_cust_acct_id_ln;
4956: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4957: aso_debug_pub.add('ASO_UTL_PVT: l_cust_account_id:'||l_cust_account_id,1,'Y');
4958:
4959: END IF;
4960: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4953: close c_get_cust_acct_id;
4954: end if;
4955: close c_get_cust_acct_id_ln;
4956: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4957: aso_debug_pub.add('ASO_UTL_PVT: l_cust_account_id:'||l_cust_account_id,1,'Y');
4958:
4959: END IF;
4960: /*** End: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
4961:
4962:
4963: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4964: For c_get_orig_order_line_id_rec IN c_get_orig_order_line_id(l_service_ref_line_id,l_cust_account_id) LOOP
4965: l_order_found := FALSE;
4966: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4967: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line not added to l_qte_line_tbl', 1, 'N');
4968: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4969: ||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4970: END IF;
4963: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
4964: For c_get_orig_order_line_id_rec IN c_get_orig_order_line_id(l_service_ref_line_id,l_cust_account_id) LOOP
4965: l_order_found := FALSE;
4966: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4967: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line not added to l_qte_line_tbl', 1, 'N');
4968: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4969: ||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4970: END IF;
4971: FOR c_order_line_rec IN c_order_line(c_get_orig_order_line_id_rec.original_order_line_id) LOOP
4964: For c_get_orig_order_line_id_rec IN c_get_orig_order_line_id(l_service_ref_line_id,l_cust_account_id) LOOP
4965: l_order_found := FALSE;
4966: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4967: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line not added to l_qte_line_tbl', 1, 'N');
4968: aso_debug_pub.add('ASO_UTL_PVT: l_service_ref_line_id_tbl('||l_service_ref_line_id||').:'
4969: ||NVL(to_char(l_service_ref_line_id_tbl(l_service_ref_line_id)),'null'),1,'Y');
4970: END IF;
4971: FOR c_order_line_rec IN c_order_line(c_get_orig_order_line_id_rec.original_order_line_id) LOOP
4972: l_order_found := TRUE;
4981:
4982: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4983: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4984: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4985: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4986: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4987: END IF;
4988: END LOOP;
4989:
4982: l_qte_line_rec.PRICING_QUANTITY := c_order_line_rec.PRICING_QUANTITY;
4983: l_qte_line_rec.PRICING_QUANTITY_UOM := c_order_line_rec.PRICING_QUANTITY_UOM;
4984: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
4985: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4986: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
4987: END IF;
4988: END LOOP;
4989:
4990: /****** Start SUN Changes ER:3802859 *******/
4990: /****** Start SUN Changes ER:3802859 *******/
4991:
4992: IF l_order_found = FALSE THEN -- this means no order line was found then
4993:
4994: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4995: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4996: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4997: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4998: END IF;
4991:
4992: IF l_order_found = FALSE THEN -- this means no order line was found then
4993:
4994: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4995: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4996: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4997: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4998: END IF;
4999:
4992: IF l_order_found = FALSE THEN -- this means no order line was found then
4993:
4994: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4995: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4996: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4997: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4998: END IF;
4999:
5000: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
4993:
4994: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
4995: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Inside new condition', 1, 'N');
4996: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
4997: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_cust_account_id: '|| l_cust_account_id, 1, 'N');
4998: END IF;
4999:
5000: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
5001: fetch c_csi_line_details into l_prod,l_item_id,l_qty,l_uom;
4999:
5000: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
5001: fetch c_csi_line_details into l_prod,l_item_id,l_qty,l_uom;
5002:
5003: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5004: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** After fetching the csi line details', 1, 'N');
5005: END IF;
5006:
5007: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id;
5000: open c_csi_line_details(l_service_ref_line_id,l_cust_account_id);
5001: fetch c_csi_line_details into l_prod,l_item_id,l_qty,l_uom;
5002:
5003: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5004: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** After fetching the csi line details', 1, 'N');
5005: END IF;
5006:
5007: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id;
5008: l_qte_line_rec.INVENTORY_ITEM_ID := l_item_id;
5022: l_qte_line_rec.PRICING_QUANTITY := l_qty;
5023: l_qte_line_rec.PRICING_QUANTITY_UOM := l_UOM;
5024: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
5025: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5026: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5027: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5028: END IF;
5029:
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5023: l_qte_line_rec.PRICING_QUANTITY_UOM := l_UOM;
5024: l_qte_line_rec.IS_LINE_CHANGED_FLAG := 'Y';
5025: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5026: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5027: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5028: END IF;
5029:
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5026: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5027: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5028: END IF;
5029:
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5027: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5028: END IF;
5029:
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5035: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
5028: END IF;
5029:
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5035: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
5036: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
5029:
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5035: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
5036: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
5037: END IF;
5030: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5035: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
5036: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
5037: END IF;
5038:
5031: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5035: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
5036: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
5037: END IF;
5038:
5039: close c_csi_line_details;
5032: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_item_id: '|| l_item_id, 1, 'N');
5033: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qty: '|| l_qty, 1, 'N');
5034: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_uom: '|| l_uom, 1, 'N');
5035: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** l_qte_line_rec.PRICE_LIST_ID: '||l_qte_line_rec.PRICE_LIST_ID, 1, 'N');
5036: aso_debug_pub.add('ASO_UTL_PVT: **** ER:3802859 ****** Instance Line Count: '|| NVL(l_Qte_line_tbl.COUNT,0), 1, 'N');
5037: END IF;
5038:
5039: close c_csi_line_details;
5040: END IF;
5044: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
5045: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
5046: ELSIF l_ref_type_code = 'PRODUCT_CATALOG' THEN
5047: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
5048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5049: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5050: END IF;
5051: ELSE
5052: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5045: /*** Start: BugNo 8647883: R12.1.2 Service reference SUN ER ***/
5046: ELSIF l_ref_type_code = 'PRODUCT_CATALOG' THEN
5047: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
5048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5049: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5050: END IF;
5051: ELSE
5052: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5053: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before product catalog processing:',1,'Y');
5048: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5049: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5050: END IF;
5051: ELSE
5052: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5053: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before product catalog processing:',1,'Y');
5054: END IF;
5055:
5056:
5049: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5050: END IF;
5051: ELSE
5052: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5053: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before product catalog processing:',1,'Y');
5054: END IF;
5055:
5056:
5057: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5054: END IF;
5055:
5056:
5057: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5058: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5059: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
5060: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5061:
5062: END IF;
5055:
5056:
5057: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5058: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5059: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
5060: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5061:
5062: END IF;
5063:
5056:
5057: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5058: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5059: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
5060: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5061:
5062: END IF;
5063:
5064: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id; --c_qte_line_rec.QUOTE_LINE_ID;
5075: l_qte_line_rec.PRICING_QUANTITY := c_qte_line_rec.PRICING_QUANTITY;
5076: l_qte_line_rec.PRICING_QUANTITY_UOM := c_qte_line_rec.PRICING_QUANTITY_UOM;
5077:
5078: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5079: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5080: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5081: END IF;
5082:
5083: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
5076: l_qte_line_rec.PRICING_QUANTITY_UOM := c_qte_line_rec.PRICING_QUANTITY_UOM;
5077:
5078: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5079: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5080: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5081: END IF;
5082:
5083: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
5084:
5083: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
5084:
5085: ELSIF l_ref_type_code = 'QUOTE' THEN -- bug 13482837
5086: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
5087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5088: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5089: END IF;
5090: ELSE
5091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5084:
5085: ELSIF l_ref_type_code = 'QUOTE' THEN -- bug 13482837
5086: IF l_service_ref_line_id_tbl.exists(l_service_ref_line_id) THEN
5087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5088: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5089: END IF;
5090: ELSE
5091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5092: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before current quote processing:',1,'Y');
5087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5088: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5089: END IF;
5090: ELSE
5091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5092: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before current quote processing:',1,'Y');
5093: END IF;
5094:
5095:
5088: aso_debug_pub.add('ASO_UTL_PVT: Parent Instance Line has already been added to l_qte_line_tbl.',1,'Y');
5089: END IF;
5090: ELSE
5091: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5092: aso_debug_pub.add('ASO_UTL_PVT: **** ER: II****** Before current quote processing:',1,'Y');
5093: END IF;
5094:
5095:
5096: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5093: END IF;
5094:
5095:
5096: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5097: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5098: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
5099: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5100:
5101: END IF;
5094:
5095:
5096: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5097: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5098: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
5099: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5100:
5101: END IF;
5102:
5095:
5096: l_service_ref_line_id_tbl(l_service_ref_line_id) := l_service_ref_line_id;
5097: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5098: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** Inside new condition', 1, 'N');
5099: aso_debug_pub.add('ASO_UTL_PVT: **** **** ER: II****** ****** l_service_ref_line_id: '|| l_service_ref_line_id, 1, 'N');
5100:
5101: END IF;
5102:
5103: l_qte_line_rec.QUOTE_LINE_ID := l_service_ref_line_id;
5117: l_qte_line_rec.PRICING_QUANTITY_UOM := c_quote_line1.PRICING_QUANTITY_UOM;
5118: end loop;
5119:
5120: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5121: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5122: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5123: END IF;
5124: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
5125:
5118: end loop;
5119:
5120: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5121: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5122: aso_debug_pub.add('Instance Line Count '|| l_Qte_line_tbl.COUNT, 1, 'N');
5123: END IF;
5124: END IF;--l_service_ref_line_id_tbl.exists(l_service_ref_line_id)
5125:
5126: END IF;--elsif l_ref_type_code = 'PRODUCT_CATALOG'
5211: /* l_qte_line_rec.PRODUCT_FISC_CLASSIFICATION := c_qte_line_rec.PRODUCT_FISC_CLASSIFICATION;
5212: l_qte_line_rec.TRX_BUSINESS_CATEGORY := c_qte_line_rec.TRX_BUSINESS_CATEGORY;*/
5213:
5214: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5215: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5216: aso_debug_pub.add('Quote Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
5217: END IF;
5218: END LOOP;
5219:
5212: l_qte_line_rec.TRX_BUSINESS_CATEGORY := c_qte_line_rec.TRX_BUSINESS_CATEGORY;*/
5213:
5214: l_Qte_Line_tbl(l_Qte_Line_tbl.COUNT+1) := l_Qte_Line_rec;
5215: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5216: aso_debug_pub.add('Quote Line Count'|| l_Qte_line_tbl.COUNT, 1, 'N');
5217: END IF;
5218: END LOOP;
5219:
5220: RETURN l_Qte_Line_tbl;
5940:
5941: l_end_date_active date;
5942:
5943: begin
5944: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5945: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: p_profile_name: '||p_profile_name,1,'Y');
5946: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: p_application_id: '||p_application_id,1,'Y');
5947: END IF;
5948:
5941: l_end_date_active date;
5942:
5943: begin
5944: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5945: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: p_profile_name: '||p_profile_name,1,'Y');
5946: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: p_application_id: '||p_application_id,1,'Y');
5947: END IF;
5948:
5949: open c_end_date;
5942:
5943: begin
5944: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5945: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: p_profile_name: '||p_profile_name,1,'Y');
5946: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: p_application_id: '||p_application_id,1,'Y');
5947: END IF;
5948:
5949: open c_end_date;
5950: fetch c_end_date into l_end_date_active;
5948:
5949: open c_end_date;
5950: fetch c_end_date into l_end_date_active;
5951:
5952: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5953: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: l_end_date_active: '||l_end_date_active,1,'Y');
5954: END IF;
5955:
5956: if c_end_date%found then
5949: open c_end_date;
5950: fetch c_end_date into l_end_date_active;
5951:
5952: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5953: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: l_end_date_active: '||l_end_date_active,1,'Y');
5954: END IF;
5955:
5956: if c_end_date%found then
5957:
5954: END IF;
5955:
5956: if c_end_date%found then
5957:
5958: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5959: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: Inside c_end_date%found cond',1,'Y');
5960: END IF;
5961:
5962: close c_end_date;
5955:
5956: if c_end_date%found then
5957:
5958: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5959: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: Inside c_end_date%found cond',1,'Y');
5960: END IF;
5961:
5962: close c_end_date;
5963: return 'F';
5962: close c_end_date;
5963: return 'F';
5964: else
5965:
5966: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5967: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: Inside else c_end_date%found cond',1,'Y');
5968: END IF;
5969:
5970: close c_end_date;
5963: return 'F';
5964: else
5965:
5966: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
5967: aso_debug_pub.add('ASO_UTL_PVT: Get_Profile_Obsolete_Status: Inside else c_end_date%found cond',1,'Y');
5968: END IF;
5969:
5970: close c_end_date;
5971: return 'T';
6331: FUNCTION GET_OU_ATTRIBUTE_VALUE(p_attribute IN VARCHAR2, p_organization_id IN NUMBER) RETURN VARCHAR2
6332: IS
6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6334: BEGIN
6335: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');
6338: END IF;
6339:
6332: IS
6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6334: BEGIN
6335: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');
6338: END IF;
6339:
6340: IF (p_attribute = G_DEFAULT_ORDER_TYPE) THEN
6333: l_attribute_value HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE; -- bug 12324106
6334: BEGIN
6335: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6336: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6337: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_organization_id '||p_organization_id,1,'Y');
6338: END IF;
6339:
6340: IF (p_attribute = G_DEFAULT_ORDER_TYPE) THEN
6341: BEGIN
6393: RETURN NULL ;
6394: END;
6395: END IF;
6396:
6397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6398: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');
6399: END IF;
6400:
6401: RETURN l_attribute_value;
6394: END;
6395: END IF;
6396:
6397: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6398: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');
6399: END IF;
6400:
6401: RETURN l_attribute_value;
6402:
6409: BEGIN
6410:
6411: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
6412:
6413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6414: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6415: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_organization_id '||l_organization_id,1,'Y');
6416: END IF;
6417:
6410:
6411: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
6412:
6413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6414: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6415: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_organization_id '||l_organization_id,1,'Y');
6416: END IF;
6417:
6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);
6411: l_organization_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
6412:
6413: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6414: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: p_attribute '||p_attribute,1,'Y');
6415: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_organization_id '||l_organization_id,1,'Y');
6416: END IF;
6417:
6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);
6419:
6417:
6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);
6419:
6420:
6421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6422: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');
6423: END IF;
6424:
6425: RETURN l_attribute_value;
6418: l_attribute_value := GET_OU_ATTRIBUTE_VALUE(p_attribute, l_organization_id);
6419:
6420:
6421: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6422: aso_debug_pub.add('ASO_UTILITY_PVT: GET_OU_ATTRIBUTE_VALUE: l_attribute_value '||l_attribute_value,1,'Y');
6423: END IF;
6424:
6425: RETURN l_attribute_value;
6426:
6494: LOOP
6495: FETCH cur_find_rec INTO l_quote_number, l_conc_request_id ;
6496:
6497: IF (cur_find_rec%ROWCOUNT = 0) THEN
6498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6499: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : No record found for the quote number, inserting the new record.', 1, 'Y');
6500: END IF;
6501: l_to_insert := 1;
6502: END IF ;
6495: FETCH cur_find_rec INTO l_quote_number, l_conc_request_id ;
6496:
6497: IF (cur_find_rec%ROWCOUNT = 0) THEN
6498: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6499: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : No record found for the quote number, inserting the new record.', 1, 'Y');
6500: END IF;
6501: l_to_insert := 1;
6502: END IF ;
6503:
6505:
6506: IF (l_conc_request_id IS NOT null)
6507: THEN
6508: -- Record exists but a conc request id is also present, hence insert the record
6509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6510: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number passed but the conc request id is not null, hence inserting the new record.', 1, 'Y');
6511: END IF;
6512: l_to_insert := 1;
6513: END IF;
6506: IF (l_conc_request_id IS NOT null)
6507: THEN
6508: -- Record exists but a conc request id is also present, hence insert the record
6509: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6510: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number passed but the conc request id is not null, hence inserting the new record.', 1, 'Y');
6511: END IF;
6512: l_to_insert := 1;
6513: END IF;
6514:
6514:
6515: IF (l_conc_request_id IS null)
6516: THEN
6517: -- Record exists with a null conc request id, hence we need not insert a new record
6518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6519: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number and the conc request id is null, hence no need to insert the new record.', 1, 'Y');
6520: END IF;
6521: l_found_rec := 1;
6522: END IF;
6515: IF (l_conc_request_id IS null)
6516: THEN
6517: -- Record exists with a null conc request id, hence we need not insert a new record
6518: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6519: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Found record with quote number and the conc request id is null, hence no need to insert the new record.', 1, 'Y');
6520: END IF;
6521: l_found_rec := 1;
6522: END IF;
6523:
6534:
6535:
6536: IF (l_to_insert = 1) THEN
6537:
6538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6535:
6536: IF (l_to_insert = 1) THEN
6537:
6538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6543: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
6536: IF (l_to_insert = 1) THEN
6537:
6538: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6539: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Before Inserting record in ASO_CHANGED_QUOTES', 1, 'Y');
6540: aso_debug_pub.add('ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES : Quote Number : ' || p_quote_number, 1, 'Y');
6541: END IF;
6542:
6543: ASO_CHANGED_QUOTES_PKG.INSERT_ROW(
6544: P_QUOTE_NUMBER => p_quote_number,
6580: l_org_id NUMBER;
6581: l_def_org_id NUMBER;
6582: l_file VARCHAR2(200);
6583: begin
6584: IF (aso_debug_pub.g_debug_flag = 'Y' ) THEN
6585:
6586: aso_debug_pub.add( '*******************************************',1, 'Y' );
6587: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6582: l_file VARCHAR2(200);
6583: begin
6584: IF (aso_debug_pub.g_debug_flag = 'Y' ) THEN
6585:
6586: aso_debug_pub.add( '*******************************************',1, 'Y' );
6587: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6583: begin
6584: IF (aso_debug_pub.g_debug_flag = 'Y' ) THEN
6585:
6586: aso_debug_pub.add( '*******************************************',1, 'Y' );
6587: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6584: IF (aso_debug_pub.g_debug_flag = 'Y' ) THEN
6585:
6586: aso_debug_pub.add( '*******************************************',1, 'Y' );
6587: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6585:
6586: aso_debug_pub.add( '*******************************************',1, 'Y' );
6587: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6587: aso_debug_pub.add( '***** Printing the Variable Values *****',1, 'Y' );
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6588: aso_debug_pub.add( '*******************************************',1, 'Y' );
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6589: aso_debug_pub.add( ' ',1, 'Y' );
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6597: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6590:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6597: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6598:
6591: aso_debug_pub.add(rpad('USER ID',50,'------')||'------>'||FND_GLOBAL.USER_ID , 1, 'Y');
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6597: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6598:
6599: aso_debug_pub.add( ' ',1, 'Y' );
6592: aso_debug_pub.add(rpad('RESPONSIBILITY ID',50,'------')||'------>'||FND_GLOBAL.RESP_ID , 1, 'Y');
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6597: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6598:
6599: aso_debug_pub.add( ' ',1, 'Y' );
6600:
6593: aso_debug_pub.add(rpad('RESPONSIBILITY APPLICATION ID',50,'------')||'------>'||FND_GLOBAL.RESP_APPL_ID , 1, 'Y');
6594: aso_debug_pub.add(rpad('USER NAME',50,'------')||'------>'||FND_GLOBAL.USER_NAME , 1, 'Y');
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6597: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6598:
6599: aso_debug_pub.add( ' ',1, 'Y' );
6600:
6601:
6595: aso_debug_pub.add(rpad('RESPONSIBILITY NAME',50,'------')||'------>'||FND_GLOBAL.RESP_NAME , 1, 'Y');
6596: aso_debug_pub.add(rpad('APPLICATION NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_NAME , 1, 'Y');
6597: aso_debug_pub.add(rpad('APPLICATION SHORT NAME',50,'------')||'------>'||FND_GLOBAL.APPLICATION_SHORT_NAME , 1, 'Y');
6598:
6599: aso_debug_pub.add( ' ',1, 'Y' );
6600:
6601:
6602: aso_debug_pub.add( '******************************************',1, 'Y' );
6603: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6598:
6599: aso_debug_pub.add( ' ',1, 'Y' );
6600:
6601:
6602: aso_debug_pub.add( '******************************************',1, 'Y' );
6603: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6604: aso_debug_pub.add( '******************************************',1, 'Y' );
6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6599: aso_debug_pub.add( ' ',1, 'Y' );
6600:
6601:
6602: aso_debug_pub.add( '******************************************',1, 'Y' );
6603: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6604: aso_debug_pub.add( '******************************************',1, 'Y' );
6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6600:
6601:
6602: aso_debug_pub.add( '******************************************',1, 'Y' );
6603: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6604: aso_debug_pub.add( '******************************************',1, 'Y' );
6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6601:
6602: aso_debug_pub.add( '******************************************',1, 'Y' );
6603: aso_debug_pub.add( '***** Printing the profile values *****',1, 'Y' );
6604: aso_debug_pub.add( '******************************************',1, 'Y' );
6605: aso_debug_pub.add( ' ',1, 'Y' );
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6606:
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6612: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');
6613:
6614: aso_debug_pub.add( ' ',1, 'Y' );
6607: fnd_profile.get('XLA_MO_SECURITY_PROFILE_LEVEL',l_security_profile_id);
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6612: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');
6613:
6614: aso_debug_pub.add( ' ',1, 'Y' );
6615:
6608: fnd_profile.get('DEFAULT_ORG_ID',l_def_org_id);
6609: fnd_profile.get('ORG_ID',l_org_id);
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6612: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');
6613:
6614: aso_debug_pub.add( ' ',1, 'Y' );
6615:
6616:
6610: aso_debug_pub.add(rpad('SECURITY PROFILE ID',50,'------')||'------>'||l_security_profile_id , 1, 'Y');
6611: aso_debug_pub.add(rpad('DEFAULT ORG ID',50,'------')||'------>'||l_def_org_id , 1, 'Y');
6612: aso_debug_pub.add(rpad('ORG ID',50,'------')||'------>'||l_org_id , 1, 'Y');
6613:
6614: aso_debug_pub.add( ' ',1, 'Y' );
6615:
6616:
6617: aso_debug_pub.add( '********************************************************',1, 'Y' );
6618: aso_debug_pub.add( '***** Printing the MO_GLOB_ORG_ACCESS_TMP details *****',1, 'Y' );
6613:
6614: aso_debug_pub.add( ' ',1, 'Y' );
6615:
6616:
6617: aso_debug_pub.add( '********************************************************',1, 'Y' );
6618: aso_debug_pub.add( '***** Printing the MO_GLOB_ORG_ACCESS_TMP details *****',1, 'Y' );
6619: aso_debug_pub.add( '********************************************************',1, 'Y' );
6620: aso_debug_pub.add( ' ',1, 'Y' );
6621:
6614: aso_debug_pub.add( ' ',1, 'Y' );
6615:
6616:
6617: aso_debug_pub.add( '********************************************************',1, 'Y' );
6618: aso_debug_pub.add( '***** Printing the MO_GLOB_ORG_ACCESS_TMP details *****',1, 'Y' );
6619: aso_debug_pub.add( '********************************************************',1, 'Y' );
6620: aso_debug_pub.add( ' ',1, 'Y' );
6621:
6622: aso_debug_pub.add(rpad('ORGANIZATION_ID',50,'------')||'<----->'||rpad('ORGANIZATION_NAME',50,' ') , 1, 'Y');
6615:
6616:
6617: aso_debug_pub.add( '********************************************************',1, 'Y' );
6618: aso_debug_pub.add( '***** Printing the MO_GLOB_ORG_ACCESS_TMP details *****',1, 'Y' );
6619: aso_debug_pub.add( '********************************************************',1, 'Y' );
6620: aso_debug_pub.add( ' ',1, 'Y' );
6621:
6622: aso_debug_pub.add(rpad('ORGANIZATION_ID',50,'------')||'<----->'||rpad('ORGANIZATION_NAME',50,' ') , 1, 'Y');
6623: for i in CUR_MO_GLOB loop
6616:
6617: aso_debug_pub.add( '********************************************************',1, 'Y' );
6618: aso_debug_pub.add( '***** Printing the MO_GLOB_ORG_ACCESS_TMP details *****',1, 'Y' );
6619: aso_debug_pub.add( '********************************************************',1, 'Y' );
6620: aso_debug_pub.add( ' ',1, 'Y' );
6621:
6622: aso_debug_pub.add(rpad('ORGANIZATION_ID',50,'------')||'<----->'||rpad('ORGANIZATION_NAME',50,' ') , 1, 'Y');
6623: for i in CUR_MO_GLOB loop
6624: aso_debug_pub.add(rpad(i.ORGANIZATION_ID,50,'------')||'------>'||rpad(i.ORGANIZATION_NAME,50,' '), 1, 'Y');
6618: aso_debug_pub.add( '***** Printing the MO_GLOB_ORG_ACCESS_TMP details *****',1, 'Y' );
6619: aso_debug_pub.add( '********************************************************',1, 'Y' );
6620: aso_debug_pub.add( ' ',1, 'Y' );
6621:
6622: aso_debug_pub.add(rpad('ORGANIZATION_ID',50,'------')||'<----->'||rpad('ORGANIZATION_NAME',50,' ') , 1, 'Y');
6623: for i in CUR_MO_GLOB loop
6624: aso_debug_pub.add(rpad(i.ORGANIZATION_ID,50,'------')||'------>'||rpad(i.ORGANIZATION_NAME,50,' '), 1, 'Y');
6625: end loop;
6626:
6620: aso_debug_pub.add( ' ',1, 'Y' );
6621:
6622: aso_debug_pub.add(rpad('ORGANIZATION_ID',50,'------')||'<----->'||rpad('ORGANIZATION_NAME',50,' ') , 1, 'Y');
6623: for i in CUR_MO_GLOB loop
6624: aso_debug_pub.add(rpad(i.ORGANIZATION_ID,50,'------')||'------>'||rpad(i.ORGANIZATION_NAME,50,' '), 1, 'Y');
6625: end loop;
6626:
6627: aso_debug_pub.add( ' ',1, 'Y' );
6628:
6623: for i in CUR_MO_GLOB loop
6624: aso_debug_pub.add(rpad(i.ORGANIZATION_ID,50,'------')||'------>'||rpad(i.ORGANIZATION_NAME,50,' '), 1, 'Y');
6625: end loop;
6626:
6627: aso_debug_pub.add( ' ',1, 'Y' );
6628:
6629:
6630: aso_debug_pub.add( '********************************************************',1, 'Y' );
6631: aso_debug_pub.add( '************** Printing the ORG details **************',1, 'Y' );
6626:
6627: aso_debug_pub.add( ' ',1, 'Y' );
6628:
6629:
6630: aso_debug_pub.add( '********************************************************',1, 'Y' );
6631: aso_debug_pub.add( '************** Printing the ORG details **************',1, 'Y' );
6632: aso_debug_pub.add( '********************************************************',1, 'Y' );
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6627: aso_debug_pub.add( ' ',1, 'Y' );
6628:
6629:
6630: aso_debug_pub.add( '********************************************************',1, 'Y' );
6631: aso_debug_pub.add( '************** Printing the ORG details **************',1, 'Y' );
6632: aso_debug_pub.add( '********************************************************',1, 'Y' );
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6628:
6629:
6630: aso_debug_pub.add( '********************************************************',1, 'Y' );
6631: aso_debug_pub.add( '************** Printing the ORG details **************',1, 'Y' );
6632: aso_debug_pub.add( '********************************************************',1, 'Y' );
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6629:
6630: aso_debug_pub.add( '********************************************************',1, 'Y' );
6631: aso_debug_pub.add( '************** Printing the ORG details **************',1, 'Y' );
6632: aso_debug_pub.add( '********************************************************',1, 'Y' );
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6631: aso_debug_pub.add( '************** Printing the ORG details **************',1, 'Y' );
6632: aso_debug_pub.add( '********************************************************',1, 'Y' );
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6638: aso_debug_pub.add(rpad('DEFAULT ORG_ID',50,'------')||'------>'||MO_UTILS.get_default_org_id , 1, 'Y');
6639: aso_debug_pub.add(rpad('SYS CONTEXT',50,'------')||'------>'||sys_context('multi_org2','current_org_id') , 1, 'Y');
6632: aso_debug_pub.add( '********************************************************',1, 'Y' );
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6638: aso_debug_pub.add(rpad('DEFAULT ORG_ID',50,'------')||'------>'||MO_UTILS.get_default_org_id , 1, 'Y');
6639: aso_debug_pub.add(rpad('SYS CONTEXT',50,'------')||'------>'||sys_context('multi_org2','current_org_id') , 1, 'Y');
6640:
6633: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6638: aso_debug_pub.add(rpad('DEFAULT ORG_ID',50,'------')||'------>'||MO_UTILS.get_default_org_id , 1, 'Y');
6639: aso_debug_pub.add(rpad('SYS CONTEXT',50,'------')||'------>'||sys_context('multi_org2','current_org_id') , 1, 'Y');
6640:
6641: aso_debug_pub.add( ' ',1, 'Y' );
6634:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6638: aso_debug_pub.add(rpad('DEFAULT ORG_ID',50,'------')||'------>'||MO_UTILS.get_default_org_id , 1, 'Y');
6639: aso_debug_pub.add(rpad('SYS CONTEXT',50,'------')||'------>'||sys_context('multi_org2','current_org_id') , 1, 'Y');
6640:
6641: aso_debug_pub.add( ' ',1, 'Y' );
6642:
6635: aso_debug_pub.add(rpad('CURRENT ORG ID',50,'------')||'------>'||MO_GLOBAL.get_current_org_id , 1, 'Y');
6636: aso_debug_pub.add(rpad('ACCESS MODE',50,'------')||'------>'||MO_GLOBAL.get_access_mode , 1, 'Y');
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6638: aso_debug_pub.add(rpad('DEFAULT ORG_ID',50,'------')||'------>'||MO_UTILS.get_default_org_id , 1, 'Y');
6639: aso_debug_pub.add(rpad('SYS CONTEXT',50,'------')||'------>'||sys_context('multi_org2','current_org_id') , 1, 'Y');
6640:
6641: aso_debug_pub.add( ' ',1, 'Y' );
6642:
6643: END IF;
6637: aso_debug_pub.add(rpad('OPERATING UNITS COUNT',50,'------')||'------>'||MO_GLOBAL.get_ou_count , 1, 'Y');
6638: aso_debug_pub.add(rpad('DEFAULT ORG_ID',50,'------')||'------>'||MO_UTILS.get_default_org_id , 1, 'Y');
6639: aso_debug_pub.add(rpad('SYS CONTEXT',50,'------')||'------>'||sys_context('multi_org2','current_org_id') , 1, 'Y');
6640:
6641: aso_debug_pub.add( ' ',1, 'Y' );
6642:
6643: END IF;
6644: END print_login_info;
6645:
6647: FUNCTION Tax_Rec_Exists( p_tax_rec IN ASO_QUOTE_PUB.Tax_Detail_Rec_Type ) RETURN BOOLEAN
6648: IS
6649:
6650: BEGIN
6651: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6652: aso_debug_pub.add('Begin tax_Rec_Exists function.', 1, 'Y');
6653: END IF;
6654:
6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6648: IS
6649:
6650: BEGIN
6651: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6652: aso_debug_pub.add('Begin tax_Rec_Exists function.', 1, 'Y');
6653: END IF;
6654:
6655: IF ( P_tax_rec.ATTRIBUTE1<> FND_API.G_MISS_CHAR OR
6656: P_tax_rec.ATTRIBUTE10<> FND_API.G_MISS_CHAR OR
6689: P_tax_rec.TAX_EXEMPT_NUMBER<> FND_API.G_MISS_CHAR OR
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6692:
6693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6694: aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');
6695: END IF;
6696:
6697: return TRUE;
6690: P_tax_rec.TAX_EXEMPT_REASON_CODE<> FND_API.G_MISS_CHAR OR
6691: P_tax_rec.TAX_RATE<> FND_API.G_MISS_NUM ) THEN
6692:
6693: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6694: aso_debug_pub.add('Tax_Rec_Exists function returning TRUE');
6695: END IF;
6696:
6697: return TRUE;
6698:
6697: return TRUE;
6698:
6699: ELSE
6700:
6701: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6702: aso_debug_pub.add('Tax_Rec_Exists function returning FALSE');
6703: END IF;
6704:
6705: return FALSE;
6698:
6699: ELSE
6700:
6701: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6702: aso_debug_pub.add('Tax_Rec_Exists function returning FALSE');
6703: END IF;
6704:
6705: return FALSE;
6706: