[Home] [Help]
362: -- Release 12 MOAC Changes : Bug 4500739
363: -- Changes Done by : Girish
364: -- Comments : Using HR EIT in place of org striped profile
365:
366: --l_order_type_id NUMBER := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
367: l_order_type_id NUMBER := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
368:
369: -- Change END
370:
394:
395: IF (x_qte_header_rec.quote_number IS NULL OR
396: x_qte_header_rec.quote_number = FND_API.G_MISS_NUM) THEN
397:
398: IF nvl( FND_PROFILE.Value('ASO_AUTO_NUMBERING'), 'Y') = 'Y' THEN
399:
400: IF aso_debug_pub.g_debug_flag = 'Y' THEN
401: aso_debug_pub.add('Populate_Qte_Header: Inside IF cond ASO_AUTO_NUMBERING = Y', 1, 'N');
402: END IF;
490: IF (x_qte_header_rec.quote_status_id IS NULL OR
491: x_qte_header_rec.quote_status_id = FND_API.G_MISS_NUM) THEN
492: --OPEN c_qte_status_id ('DRAFT');
493: -- hyang 2269617
494: l_default_status_profile := fnd_profile.value( 'ASO_DEFAULT_STATUS_CODE');
495: IF aso_debug_pub.g_debug_flag = 'Y' THEN
496: aso_debug_pub.add('Populate_Qte_Header: Profile ASO_DEFAULT_STATUS_CODE is ' || l_default_status_profile, 1, 'Y');
497: END IF;
498: OPEN c_qte_status_id ( l_default_status_profile );
529: --New Code End Yogeshwar (MOAC)
530:
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('Before OM Defaulting - Populate Qte header', 1, 'N');
533: aso_debug_pub.add('Before OM Defaulting Value of ASO_OM_DEFAULTING '||FND_PROFILE.Value('ASO_OM_DEFAULTING'), 1, 'N');
534: END IF;
535: -- IF (NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N') = 'N') THEN
536: IF (x_qte_header_rec.order_type_id IS NULL OR
537: x_qte_header_rec.order_type_id = FND_API.G_MISS_NUM) THEN
531: IF aso_debug_pub.g_debug_flag = 'Y' THEN
532: aso_debug_pub.add('Before OM Defaulting - Populate Qte header', 1, 'N');
533: aso_debug_pub.add('Before OM Defaulting Value of ASO_OM_DEFAULTING '||FND_PROFILE.Value('ASO_OM_DEFAULTING'), 1, 'N');
534: END IF;
535: -- IF (NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N') = 'N') THEN
536: IF (x_qte_header_rec.order_type_id IS NULL OR
537: x_qte_header_rec.order_type_id = FND_API.G_MISS_NUM) THEN
538: x_qte_header_rec.order_type_id := l_order_type_id;
539: END IF;
585:
586: IF (--x_qte_header_rec.quote_expiration_date IS NULL OR
587: x_qte_header_rec.quote_expiration_date = FND_API.G_MISS_DATE) THEN
588: x_qte_header_rec.quote_expiration_date := sysdate +
589: NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), G_QUOTE_DURATION);
590: END IF;
591:
592: IF (x_qte_header_rec.resource_id IS NULL OR
593: x_qte_header_rec.resource_id = FND_API.G_MISS_NUM)
1879:
1880:
1881:
1882: -- Start bug fix 10217258 For limits reversal
1883: IF NVL(FND_PROFILE.VALUE('QP_LIMITS_INSTALLED'),'N') = 'Y' THEN
1884: select count(*) into ct
1885: from aso_quote_statuses_vl
1886: where status_code = 'INACTIVE'
1887: and quote_status_id = p_qte_header_rec.QUOTE_STATUS_ID;
4145:
4146: l_quota_id NUMBER;
4147:
4148: l_istore_source VARCHAR2(1) := 'N';
4149: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
4150:
4151: --New Code for to call overload pricing_order
4152: lv_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
4153: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
4993:
4994: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
4995:
4996:
4997: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
4998:
4999: IF l_hd_payment_tbl.count > 1 THEN
5000:
5001: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5018: END IF;
5019:
5020: END IF;
5021:
5022: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN
5023:
5024: IF l_hd_payment_tbl.count > 1 THEN
5025:
5026: FOR i IN 1..l_hd_payment_tbl.count LOOP
5273: -- End of Add template rows
5274:
5275:
5276: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5277: aso_debug_pub.add('Create_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'), 1, 'Y');
5278: aso_debug_pub.add('Create_Quote: Before Assign_Team: l_sales_team_prof: ' || l_sales_team_prof, 1, 'Y');
5279: aso_debug_pub.add('Create_Quote: value of p_qte_header_rec.quote_type: ' || p_qte_header_rec.quote_type, 1, 'Y');
5280: END IF;
5281:
5278: aso_debug_pub.add('Create_Quote: Before Assign_Team: l_sales_team_prof: ' || l_sales_team_prof, 1, 'Y');
5279: aso_debug_pub.add('Create_Quote: value of p_qte_header_rec.quote_type: ' || p_qte_header_rec.quote_type, 1, 'Y');
5280: END IF;
5281:
5282: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' AND NVL(p_qte_header_rec.quote_type, 'X') <> 'T') THEN
5283:
5284: lx_qte_header_rec := x_qte_header_rec;
5285:
5286: OPEN C_Check_Qte_Status (x_qte_header_rec.quote_header_id);
6567:
6568:
6569: IF ( p_qte_header_rec.contract_template_id IS NOT NULL
6570: AND p_qte_header_rec.contract_template_id <> FND_API.G_MISS_NUM)
6571: AND NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y' THEN
6572:
6573: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6574: aso_debug_pub.add( 'Create_Quote - before instantiating contract terms. ', 1, 'Y');
6575: aso_debug_pub.add( 'Create_Quote - template id: ' || p_qte_header_rec.contract_template_id, 1, 'Y');
7009: l_quote_org_id NUMBER;
7010: l_scredit_exists VARCHAR2(1) := 'N';
7011: l_quota_id NUMBER;
7012: l_store_trans VARCHAR2(1) := 'N';
7013: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
7014:
7015: -- hyang defaulting framework
7016: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
7017: l_db_object_name VARCHAR2(30);
7584: l_shipment_tbl(1).SHIPPING_INSTRUCTIONS := Null;
7585: l_shipment_tbl(1).PACKING_INSTRUCTIONS := Null;
7586: l_shipment_tbl(1).OPERATION_CODE := 'UPDATE';
7587:
7588: aso_debug_pub.add('Update_Quote - Change Customer Flow , Profile ASO_API_ENABLE_SECURITY : ' ||FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ),1,'Y');
7589: aso_debug_pub.add('Update_Quote - Change Customer Flow , l_sales_team_prof : ' ||l_sales_team_prof,1,'Y');
7590:
7591: If NVL ( FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ), 'N' ) = 'Y' Then
7592: If (l_sales_team_prof = 'FULL' OR l_sales_team_prof = 'PARTIAL') Then
7587:
7588: aso_debug_pub.add('Update_Quote - Change Customer Flow , Profile ASO_API_ENABLE_SECURITY : ' ||FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ),1,'Y');
7589: aso_debug_pub.add('Update_Quote - Change Customer Flow , l_sales_team_prof : ' ||l_sales_team_prof,1,'Y');
7590:
7591: If NVL ( FND_PROFILE.VALUE ('ASO_API_ENABLE_SECURITY' ), 'N' ) = 'Y' Then
7592: If (l_sales_team_prof = 'FULL' OR l_sales_team_prof = 'PARTIAL') Then
7593:
7594: IF aso_debug_pub.g_debug_flag = 'Y' THEN
7595: aso_debug_pub.ADD ( 'Update_Quote - Change Customer Flow , Before calling ASO_SALES_TEAM_PVT.Assign_Sales_Team ' , 1 , 'N' );
7839: -- Release 12 MOAC Changes : Bug 4500739
7840: -- Changes Done by : Girish
7841: -- Comments : Using HR EIT in place of org striped profile
7842:
7843: -- aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(fnd_profile.value('ASO_ORDER_TYPE_ID')), 1, 'N');
7844: aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE)), 1, 'N');
7845:
7846: -- Change END
7847:
7855: -- Release 12 MOAC Changes : Bug 4500739
7856: -- Changes Done by : Girish
7857: -- Comments : Using HR EIT in place of org striped profile
7858:
7859: --l_qte_header_rec.order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
7860: l_qte_header_rec.order_type_id := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
7861:
7862: -- Change END
7863:
8550: END IF;
8551:
8552: END LOOP;
8553:
8554: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
8555:
8556: IF l_hd_payment_tbl.count > 1 THEN
8557:
8558: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
8573: END IF;
8574:
8575: END IF;-- l_payment_db_tbl
8576:
8577: END IF;-- FND_PROFILE.Value
8578:
8579:
8580: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN
8581:
8576:
8577: END IF;-- FND_PROFILE.Value
8578:
8579:
8580: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN
8581:
8582: IF l_hd_payment_tbl.count > 1 THEN
8583:
8584: l_index := l_payment_db_tbl.first;
8596: l_index := l_payment_db_tbl.next(l_index);
8597: END LOOP;
8598:
8599: END IF;
8600: END IF; ---- FND_PROFILE.Value
8601:
8602: END IF;
8603:
8604:
8944: l_price_adj_attr_tbl := l_price_adj_attr_tbl_out;
8945:
8946: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8947: aso_debug_pub.add('Update_Quote: After call to update_rows: l_return_status: ' || l_return_status, 1, 'Y');
8948: aso_debug_pub.add('Update_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'Y');
8949: END IF;
8950:
8951: -- Add template rows to p_qte_line_tbl and p_qte_line_dtl tbales
8952:
9100: aso_debug_pub.add('Update_Quote: value of l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');
9101: aso_debug_pub.add('Update_Quote: value of l_qte_header_rec.resource_grp_id: ' || l_qte_header_rec.resource_grp_id, 1, 'Y');
9102: END IF;
9103:
9104: IF (NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' AND NVL(p_qte_header_rec.quote_type, 'X') <> 'T') THEN
9105:
9106: /* Bug4869321,4600313 */
9107: IF (l_qte_header_rec.resource_id IS NULL OR l_qte_header_rec.resource_id = FND_API.G_MISS_NUM) THEN
9108:
9495: /* Start : Code change for Bug 9847694
9496: Added validation like - If service line is having reference with Install Base
9497: then End Customer will not be allowed at Service Line
9498: */
9499: If nvl(fnd_profile.value('ASO_FILTER_SERVICE_RF_END_CUST'),'N')= 'Y' Then
9500:
9501: If (l_qte_line_rec.end_customer_cust_account_id Is Not Null And
9502: l_qte_line_rec.end_customer_cust_account_id <> FND_API.G_MISS_NUM) Then
9503:
10578: END IF;
10579:
10580: -- Refer bug 10217258 rassharm
10581: --bugrassharm
10582: IF NVL(FND_PROFILE.VALUE('QP_LIMITS_INSTALLED'),'N') = 'Y' THEN
10583:
10584: IF aso_debug_pub.g_debug_flag = 'Y' THEN
10585: aso_debug_pub.add('Update_Quote: Reverse Limits limit installed'||l_qte_line_rec.quote_line_id||'item type'||l_qte_line_rec.item_type_code);
10586: aso_debug_pub.add('Update_Quote RASSHARM: Reverse Limits for handling l_qln_id'||l_qln_id);
12180: l_new_version := FND_API.G_TRUE;
12181: END IF;
12182: IF (l_new_version = FND_API.G_FALSE) THEN
12183: IF (p_qte_number IS NULL OR p_qte_number = FND_API.G_MISS_NUM) THEN
12184: IF (NVL(FND_PROFILE.Value('ASO_AUTO_NUMBERING'), 'Y') = 'Y') THEN
12185: OPEN C_Qte_Number;
12186: FETCH C_Qte_Number INTO l_qte_header_rec.quote_number;
12187: CLOSE C_Qte_Number;
12188: l_qte_header_rec.quote_version := 1;
12198: ELSE
12199: OPEN C_Qte_Number_Exists(p_qte_number);
12200: FETCH C_Qte_Number_Exists into l_qte_num;
12201: CLOSE C_Qte_Number_Exists;
12202: IF (FND_PROFILE.Value('ASO_AUTO_NUMBERING') = 'N'
12203: AND l_qte_num = p_qte_number) THEN
12204: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
12205: THEN
12206: */ -- original cpy_qte
12256: END IF;
12257:
12258: IF (p_qte_status_id IS NULL OR p_qte_status_id = FND_API.G_MISS_NUM) THEN
12259: --OPEN c_qte_status_id ('DRAFT');
12260: OPEN c_qte_status_id ( fnd_profile.value( 'ASO_DEFAULT_STATUS_CODE' ) );
12261: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
12262: CLOSE c_qte_status_id;
12263: ELSE
12264: IF l_first_version = FND_API.G_FALSE THEN
13788: IF X_Resource_Id IS NOT NULL THEN
13789: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13790: aso_debug_pub.add('Quote_Security_Check(): Resource_Id IS NOT NULL', 1, 'Y');
13791: END IF;
13792: IF (FND_PROFILE.Value('ASO_ROLE_TYPE')) IS NOT NULL THEN
13793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13794: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE NOT NULL', 1, 'Y');
13795: END IF;
13796: FOR c_r IN C_role(X_Resource_Id, FND_PROFILE.Value('ASO_ROLE_TYPE')) LOOP
13792: IF (FND_PROFILE.Value('ASO_ROLE_TYPE')) IS NOT NULL THEN
13793: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13794: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE NOT NULL', 1, 'Y');
13795: END IF;
13796: FOR c_r IN C_role(X_Resource_Id, FND_PROFILE.Value('ASO_ROLE_TYPE')) LOOP
13797: IF aso_debug_pub.g_debug_flag = 'Y' THEN
13798: aso_debug_pub.add('Quote_Security_Check(): C_Role FOUND', 1, 'Y');
13799: END IF;
13800: l_mgr_flag := c_r.manager_flag;