APPS.AS_FOUNDATION_PVT dependencies on FND_PROFILE

Line 362: l_period_set_name := fnd_profile.value('AS_FORECAST_CALENDAR');

358: FND_MSG_PUB.ADD;
359: END IF;
360: END IF;
361:
362: l_period_set_name := fnd_profile.value('AS_FORECAST_CALENDAR');
363: open get_period_name_csr(p_period_rec.period_name, p_period_rec.start_date, p_period_rec.end_date,
364: l_period_set_name);
365: loop
366: i := i + 1;

Line 1226: -- IF FND_PROFILE.Value('AS_MC_PRICE_LIST_GROUP') IS NULL

1222: -- THEN
1223: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_List_Id - Open Price list Cursor');
1224: -- END IF;
1225:
1226: -- IF FND_PROFILE.Value('AS_MC_PRICE_LIST_GROUP') IS NULL
1227: -- THEN
1228: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_List_Id - No Price List Group is set');
1229: -- END IF;
1230: OPEN l_price_list_id_csr(FND_PROFILE.Value('AS_MC_PRICE_LIST_GROUP'),p_currency_code);

Line 1230: OPEN l_price_list_id_csr(FND_PROFILE.Value('AS_MC_PRICE_LIST_GROUP'),p_currency_code);

1226: -- IF FND_PROFILE.Value('AS_MC_PRICE_LIST_GROUP') IS NULL
1227: -- THEN
1228: -- dbms_output.put_line('AS_Foundation_PVT.Get_Price_List_Id - No Price List Group is set');
1229: -- END IF;
1230: OPEN l_price_list_id_csr(FND_PROFILE.Value('AS_MC_PRICE_LIST_GROUP'),p_currency_code);
1231:
1232: -- Debug Message
1233: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)
1234: -- THEN

Line 1562: l_vol_tolerance_margin NUMBER := TO_NUMBER(NVL(FND_PROFILE.Value('AS_PRICE_VOLUME_TOLERANCE_MARGIN'),'100'));

1558: l_price_list_id NUMBER;
1559: l_price NUMBER;
1560: l_amount_floor NUMBER;
1561: l_amount_ceiling NUMBER;
1562: l_vol_tolerance_margin NUMBER := TO_NUMBER(NVL(FND_PROFILE.Value('AS_PRICE_VOLUME_TOLERANCE_MARGIN'),'100'));
1563: BEGIN
1564: -- Standard call to check for call compatibility.
1565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1566: p_api_version_number,

Line 1586: l_volume_forecast_enable := NVL(FND_PROFILE.Value('AS_VOLUME_FORECASTING_ENABLED'),'N');

1582: -- Initialize API return status to success
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: -- API body
1586: l_volume_forecast_enable := NVL(FND_PROFILE.Value('AS_VOLUME_FORECASTING_ENABLED'),'N');
1587: -- Debug Message
1588: -- IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1589: -- dbms_output.put_line('AS_Foundation_PVT - AS_VOLUME_FORECASTING_ENABLED:' || l_volume_forecast_enable);
1590: -- END IF;

Line 1870: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));

1866: l_message_num := NULL;
1867: IF l_id is not NULL
1868: THEN
1869: OPEN Get_Message_Num (l_message_name, l_id,
1870: to_number(NVL(FND_PROFILE.Value('LANGUAGE'), '0')));
1871: FETCH Get_Message_Num into l_message_num;
1872: CLOSE Get_Message_Num;
1873: END IF;
1874: