DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_CREDITS_PVT dependencies on FND_PROFILE

Line 392: FND_PROFILE.Value_Specific('AS_FORECAST_CREDIT_TYPE_ID', null, null, null);

388: -- Get the value for the Quota (or Revenue) sales credit type id from profile
389: -- 'OS: Forecast Sales Credit Type' (AS_FORECAST_CREDIT_TYPE_ID)
390: --
391: l_credit_type_id :=
392: FND_PROFILE.Value_Specific('AS_FORECAST_CREDIT_TYPE_ID', null, null, null);
393:
394: -- Log
395: IF (p_debug_flag = 'Y' AND
396: FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1441: l_default_status VARCHAR2(30) := fnd_profile.value('AS_OPP_STATUS');

1437:
1438:
1439: l_customer_id NUMBER;
1440: l_new_status VARCHAR2(30);
1441: l_default_status VARCHAR2(30) := fnd_profile.value('AS_OPP_STATUS');
1442: l_new_total_amount NUMBER;
1443: l_tot_revenue_opp_forecast_amt NUMBER := FND_API.G_MISS_NUM; -- Added for ASNB
1444: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
1445:

Line 1446: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');

1442: l_new_total_amount NUMBER;
1443: l_tot_revenue_opp_forecast_amt NUMBER := FND_API.G_MISS_NUM; -- Added for ASNB
1444: l_sales_credit_rec AS_OPPORTUNITY_PUB.Sales_Credit_Rec_type;
1445:
1446: l_forecast_credit_type_id NUMBER := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
1447: l_val NUMBER;
1448: l_date DATE;
1449: l_temp_lead_id NUMBER;
1450: l_cre_st_for_sc_flag VARCHAR2(1) := 'N';

Line 2347: l_forecast_credit_type_id := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');

2343: RETURN;
2344: END IF;
2345:
2346: -- Step 1. Initialize p_credit_type_id (l_forecast_credit_type_id in code)
2347: l_forecast_credit_type_id := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
2348: IF l_forecast_credit_type_id IS NULL THEN
2349: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module_name,
2351: 'Error: Profile AS_FORECAST_CREDIT_TYPE_ID is not set');

Line 2364: FND_PROFILE.PUT('AS_COMPETITOR_REQUIRED', 'N');

2360: 'l_forecast_credit_type_id =' || l_forecast_credit_type_id);
2361: END IF;
2362:
2363: -- Step 1.a. Set profile options to avoid errors during Copy Opp.
2364: FND_PROFILE.PUT('AS_COMPETITOR_REQUIRED', 'N');
2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');
2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');
2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');
2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');

Line 2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');

2361: END IF;
2362:
2363: -- Step 1.a. Set profile options to avoid errors during Copy Opp.
2364: FND_PROFILE.PUT('AS_COMPETITOR_REQUIRED', 'N');
2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');
2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');
2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');
2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');
2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);

Line 2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');

2362:
2363: -- Step 1.a. Set profile options to avoid errors during Copy Opp.
2364: FND_PROFILE.PUT('AS_COMPETITOR_REQUIRED', 'N');
2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');
2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');
2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');
2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');
2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);
2370: -- To avoid API_NO_ACC_MGR_PRIVILEGE error in AS_ACCESS_PVT when copying

Line 2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');

2363: -- Step 1.a. Set profile options to avoid errors during Copy Opp.
2364: FND_PROFILE.PUT('AS_COMPETITOR_REQUIRED', 'N');
2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');
2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');
2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');
2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');
2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);
2370: -- To avoid API_NO_ACC_MGR_PRIVILEGE error in AS_ACCESS_PVT when copying
2371: -- Sales Team with 'AM' as role.

Line 2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');

2364: FND_PROFILE.PUT('AS_COMPETITOR_REQUIRED', 'N');
2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');
2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');
2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');
2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');
2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);
2370: -- To avoid API_NO_ACC_MGR_PRIVILEGE error in AS_ACCESS_PVT when copying
2371: -- Sales Team with 'AM' as role.
2372: FND_PROFILE.PUT('AS_CUST_ACCESS', 'F');

Line 2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);

2365: FND_PROFILE.PUT('AS_OPP_SOURCE_CODE_REQUIRED', 'N');
2366: FND_PROFILE.PUT('AS_OPP_ADDRESS_REQUIRED', 'N');
2367: FND_PROFILE.PUT('AS_ENABLE_OPP_ONLINE_TAP', 'N');
2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');
2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);
2370: -- To avoid API_NO_ACC_MGR_PRIVILEGE error in AS_ACCESS_PVT when copying
2371: -- Sales Team with 'AM' as role.
2372: FND_PROFILE.PUT('AS_CUST_ACCESS', 'F');
2373:

Line 2372: FND_PROFILE.PUT('AS_CUST_ACCESS', 'F');

2368: FND_PROFILE.PUT('AS_ALLOW_UPDATE_FROZEN_OPP', 'Y');
2369: FND_PROFILE.PUT('AS_MAX_DAY_CLOSE_OPPORTUNITY', 1000000);
2370: -- To avoid API_NO_ACC_MGR_PRIVILEGE error in AS_ACCESS_PVT when copying
2371: -- Sales Team with 'AM' as role.
2372: FND_PROFILE.PUT('AS_CUST_ACCESS', 'F');
2373:
2374:
2375: -- Added for ASN.B migration changes
2376: -- Go thru all leads getting credit , as we need to update the sales team to sync