eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_QUOTE_HEADERS_PVT dependencies on FND_PROFILE

Line 365: --l_order_type_id NUMBER := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));

361: -- Release 12 MOAC Changes : Bug 4500739
362: -- Changes Done by : Girish
363: -- Comments : Using HR EIT in place of org striped profile
364:
365: --l_order_type_id NUMBER := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
366: l_order_type_id NUMBER := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
367:
368: -- Change END
369:

Line 397: IF nvl( FND_PROFILE.Value('ASO_AUTO_NUMBERING'), 'Y') = 'Y' THEN

393:
394: IF (x_qte_header_rec.quote_number IS NULL OR
395: x_qte_header_rec.quote_number = FND_API.G_MISS_NUM) THEN
396:
397: IF nvl( FND_PROFILE.Value('ASO_AUTO_NUMBERING'), 'Y') = 'Y' THEN
398:
399: IF aso_debug_pub.g_debug_flag = 'Y' THEN
400: aso_debug_pub.add('Populate_Qte_Header: Inside IF cond ASO_AUTO_NUMBERING = Y', 1, 'N');
401: END IF;

Line 493: l_default_status_profile := fnd_profile.value( 'ASO_DEFAULT_STATUS_CODE');

489: IF (x_qte_header_rec.quote_status_id IS NULL OR
490: x_qte_header_rec.quote_status_id = FND_API.G_MISS_NUM) THEN
491: --OPEN c_qte_status_id ('DRAFT');
492: -- hyang 2269617
493: l_default_status_profile := fnd_profile.value( 'ASO_DEFAULT_STATUS_CODE');
494: IF aso_debug_pub.g_debug_flag = 'Y' THEN
495: aso_debug_pub.add('Populate_Qte_Header: Profile ASO_DEFAULT_STATUS_CODE is ' || l_default_status_profile, 1, 'Y');
496: END IF;
497: OPEN c_qte_status_id ( l_default_status_profile );

Line 532: aso_debug_pub.add('Before OM Defaulting Value of ASO_OM_DEFAULTING '||FND_PROFILE.Value('ASO_OM_DEFAULTING'), 1, 'N');

528: --New Code End Yogeshwar (MOAC)
529:
530: IF aso_debug_pub.g_debug_flag = 'Y' THEN
531: aso_debug_pub.add('Before OM Defaulting - Populate Qte header', 1, 'N');
532: aso_debug_pub.add('Before OM Defaulting Value of ASO_OM_DEFAULTING '||FND_PROFILE.Value('ASO_OM_DEFAULTING'), 1, 'N');
533: END IF;
534: -- IF (NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N') = 'N') THEN
535: IF (x_qte_header_rec.order_type_id IS NULL OR
536: x_qte_header_rec.order_type_id = FND_API.G_MISS_NUM) THEN

Line 534: -- IF (NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N') = 'N') THEN

530: IF aso_debug_pub.g_debug_flag = 'Y' THEN
531: aso_debug_pub.add('Before OM Defaulting - Populate Qte header', 1, 'N');
532: aso_debug_pub.add('Before OM Defaulting Value of ASO_OM_DEFAULTING '||FND_PROFILE.Value('ASO_OM_DEFAULTING'), 1, 'N');
533: END IF;
534: -- IF (NVL(FND_PROFILE.Value('ASO_OM_DEFAULTING'), 'N') = 'N') THEN
535: IF (x_qte_header_rec.order_type_id IS NULL OR
536: x_qte_header_rec.order_type_id = FND_API.G_MISS_NUM) THEN
537: x_qte_header_rec.order_type_id := l_order_type_id;
538: END IF;

Line 588: NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), G_QUOTE_DURATION);

584:
585: IF (--x_qte_header_rec.quote_expiration_date IS NULL OR
586: x_qte_header_rec.quote_expiration_date = FND_API.G_MISS_DATE) THEN
587: x_qte_header_rec.quote_expiration_date := sysdate +
588: NVL(FND_PROFILE.value('ASO_QUOTE_DURATION'), G_QUOTE_DURATION);
589: END IF;
590:
591: IF (x_qte_header_rec.resource_id IS NULL OR
592: x_qte_header_rec.resource_id = FND_API.G_MISS_NUM)

Line 4066: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');

4062:
4063: l_quota_id NUMBER;
4064:
4065: l_istore_source VARCHAR2(1) := 'N';
4066: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
4067:
4068: --New Code for to call overload pricing_order
4069: lv_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
4070: lx_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 4910: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN

4906:
4907: END IF; --IF p_validation_level >= ASO_UTILITY_PVT.G_VALID_LEVEL_INTER_RECORD THEN
4908:
4909:
4910: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
4911:
4912: IF l_hd_payment_tbl.count > 1 THEN
4913:
4914: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 4935: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN

4931: END IF;
4932:
4933: END IF;
4934:
4935: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN
4936:
4937: IF l_hd_payment_tbl.count > 1 THEN
4938:
4939: FOR i IN 1..l_hd_payment_tbl.count LOOP

Line 5190: aso_debug_pub.add('Create_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'), 1, 'Y');

5186: -- End of Add template rows
5187:
5188:
5189: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5190: aso_debug_pub.add('Create_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'), 1, 'Y');
5191: aso_debug_pub.add('Create_Quote: Before Assign_Team: l_sales_team_prof: ' || l_sales_team_prof, 1, 'Y');
5192: aso_debug_pub.add('Create_Quote: value of p_qte_header_rec.quote_type: ' || p_qte_header_rec.quote_type, 1, 'Y');
5193: END IF;
5194:

Line 5195: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' AND NVL(p_qte_header_rec.quote_type, 'X') <> 'T') THEN

5191: aso_debug_pub.add('Create_Quote: Before Assign_Team: l_sales_team_prof: ' || l_sales_team_prof, 1, 'Y');
5192: aso_debug_pub.add('Create_Quote: value of p_qte_header_rec.quote_type: ' || p_qte_header_rec.quote_type, 1, 'Y');
5193: END IF;
5194:
5195: IF (NVL(FND_PROFILE.Value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' AND NVL(p_qte_header_rec.quote_type, 'X') <> 'T') THEN
5196:
5197: lx_qte_header_rec := x_qte_header_rec;
5198:
5199: OPEN C_Check_Qte_Status (x_qte_header_rec.quote_header_id);

Line 6433: AND NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y' THEN

6429:
6430:
6431: IF ( p_qte_header_rec.contract_template_id IS NOT NULL
6432: AND p_qte_header_rec.contract_template_id <> FND_API.G_MISS_NUM)
6433: AND NVL(FND_PROFILE.Value('OKC_ENABLE_SALES_CONTRACTS'),'N') = 'Y' THEN
6434:
6435: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6436: aso_debug_pub.add( 'Create_Quote - before instantiating contract terms. ', 1, 'Y');
6437: aso_debug_pub.add( 'Create_Quote - template id: ' || p_qte_header_rec.contract_template_id, 1, 'Y');

Line 6873: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');

6869: l_quote_org_id NUMBER;
6870: l_scredit_exists VARCHAR2(1) := 'N';
6871: l_quota_id NUMBER;
6872: l_store_trans VARCHAR2(1) := 'N';
6873: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
6874:
6875: -- hyang defaulting framework
6876: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
6877: l_db_object_name VARCHAR2(30);

Line 7256: -- aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(fnd_profile.value('ASO_ORDER_TYPE_ID')), 1, 'N');

7252: -- Release 12 MOAC Changes : Bug 4500739
7253: -- Changes Done by : Girish
7254: -- Comments : Using HR EIT in place of org striped profile
7255:
7256: -- aso_debug_pub.add('Update_Quote - Value of Order Type Profile'||to_number(fnd_profile.value('ASO_ORDER_TYPE_ID')), 1, 'N');
7257: 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');
7258:
7259: -- Change END
7260:

Line 7272: --l_qte_header_rec.order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));

7268: -- Release 12 MOAC Changes : Bug 4500739
7269: -- Changes Done by : Girish
7270: -- Comments : Using HR EIT in place of org striped profile
7271:
7272: --l_qte_header_rec.order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
7273: l_qte_header_rec.order_type_id := to_number(ASO_UTILITY_PVT.GET_OU_ATTRIBUTE_VALUE(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
7274:
7275: -- Change END
7276:

Line 7768: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN

7764: END IF;
7765:
7766: END LOOP;
7767:
7768: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'N') THEN
7769:
7770: IF l_hd_payment_tbl.count > 1 THEN
7771:
7772: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 7791: END IF;-- FND_PROFILE.Value

7787: END IF;
7788:
7789: END IF;-- l_payment_db_tbl
7790:
7791: END IF;-- FND_PROFILE.Value
7792:
7793:
7794: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN
7795:

Line 7794: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN

7790:
7791: END IF;-- FND_PROFILE.Value
7792:
7793:
7794: IF (FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT') = 'Y') THEN
7795:
7796: IF l_hd_payment_tbl.count > 1 THEN
7797:
7798: l_index := l_payment_db_tbl.first;

Line 7814: END IF; ---- FND_PROFILE.Value

7810: l_index := l_payment_db_tbl.next(l_index);
7811: END LOOP;
7812:
7813: END IF;
7814: END IF; ---- FND_PROFILE.Value
7815:
7816: END IF;
7817:
7818:

Line 8162: aso_debug_pub.add('Update_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'Y');

8158: l_price_adj_attr_tbl := l_price_adj_attr_tbl_out;
8159:
8160: IF aso_debug_pub.g_debug_flag = 'Y' THEN
8161: aso_debug_pub.add('Update_Quote: After call to update_rows: l_return_status: ' || l_return_status, 1, 'Y');
8162: aso_debug_pub.add('Update_Quote: value of ASO_API_ENABLE_SECURITY: ' || FND_PROFILE.value('ASO_API_ENABLE_SECURITY'), 1, 'Y');
8163: END IF;
8164:
8165: -- Add template rows to p_qte_line_tbl and p_qte_line_dtl tbales
8166:

Line 8313: IF (NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' AND NVL(p_qte_header_rec.quote_type, 'X') <> 'T') THEN

8309: aso_debug_pub.add('Update_Quote: value of l_qte_header_rec.resource_id: ' || l_qte_header_rec.resource_id, 1, 'Y');
8310: aso_debug_pub.add('Update_Quote: value of l_qte_header_rec.resource_grp_id: ' || l_qte_header_rec.resource_grp_id, 1, 'Y');
8311: END IF;
8312:
8313: IF (NVL(FND_PROFILE.value('ASO_API_ENABLE_SECURITY'),'N') = 'Y' AND NVL(p_qte_header_rec.quote_type, 'X') <> 'T') THEN
8314:
8315: /* Bug4869321,4600313 */
8316: IF (l_qte_header_rec.resource_id IS NULL OR l_qte_header_rec.resource_id = FND_API.G_MISS_NUM) THEN
8317:

Line 11113: IF (NVL(FND_PROFILE.Value('ASO_AUTO_NUMBERING'), 'Y') = 'Y') THEN

11109: l_new_version := FND_API.G_TRUE;
11110: END IF;
11111: IF (l_new_version = FND_API.G_FALSE) THEN
11112: IF (p_qte_number IS NULL OR p_qte_number = FND_API.G_MISS_NUM) THEN
11113: IF (NVL(FND_PROFILE.Value('ASO_AUTO_NUMBERING'), 'Y') = 'Y') THEN
11114: OPEN C_Qte_Number;
11115: FETCH C_Qte_Number INTO l_qte_header_rec.quote_number;
11116: CLOSE C_Qte_Number;
11117: l_qte_header_rec.quote_version := 1;

Line 11131: IF (FND_PROFILE.Value('ASO_AUTO_NUMBERING') = 'N'

11127: ELSE
11128: OPEN C_Qte_Number_Exists(p_qte_number);
11129: FETCH C_Qte_Number_Exists into l_qte_num;
11130: CLOSE C_Qte_Number_Exists;
11131: IF (FND_PROFILE.Value('ASO_AUTO_NUMBERING') = 'N'
11132: AND l_qte_num = p_qte_number) THEN
11133: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
11134: THEN
11135: */ -- original cpy_qte

Line 11189: OPEN c_qte_status_id ( fnd_profile.value( 'ASO_DEFAULT_STATUS_CODE' ) );

11185: END IF;
11186:
11187: IF (p_qte_status_id IS NULL OR p_qte_status_id = FND_API.G_MISS_NUM) THEN
11188: --OPEN c_qte_status_id ('DRAFT');
11189: OPEN c_qte_status_id ( fnd_profile.value( 'ASO_DEFAULT_STATUS_CODE' ) );
11190: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
11191: CLOSE c_qte_status_id;
11192: ELSE
11193: IF l_first_version = FND_API.G_FALSE THEN

Line 12721: IF (FND_PROFILE.Value('ASO_ROLE_TYPE')) IS NOT NULL THEN

12717: IF X_Resource_Id IS NOT NULL THEN
12718: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12719: aso_debug_pub.add('Quote_Security_Check(): Resource_Id IS NOT NULL', 1, 'Y');
12720: END IF;
12721: IF (FND_PROFILE.Value('ASO_ROLE_TYPE')) IS NOT NULL THEN
12722: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12723: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE NOT NULL', 1, 'Y');
12724: END IF;
12725: FOR c_r IN C_role(X_Resource_Id, FND_PROFILE.Value('ASO_ROLE_TYPE')) LOOP

Line 12725: FOR c_r IN C_role(X_Resource_Id, FND_PROFILE.Value('ASO_ROLE_TYPE')) LOOP

12721: IF (FND_PROFILE.Value('ASO_ROLE_TYPE')) IS NOT NULL THEN
12722: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12723: aso_debug_pub.add('Quote_Security_Check(): ASO_ROLE_TYPE NOT NULL', 1, 'Y');
12724: END IF;
12725: FOR c_r IN C_role(X_Resource_Id, FND_PROFILE.Value('ASO_ROLE_TYPE')) LOOP
12726: IF aso_debug_pub.g_debug_flag = 'Y' THEN
12727: aso_debug_pub.add('Quote_Security_Check(): C_Role FOUND', 1, 'Y');
12728: END IF;
12729: l_mgr_flag := c_r.manager_flag;