APPS.OKC_OPPORTUNITY_PVT dependencies on FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKC_OPPORTUNITY_PVT AS
2: /* $Header: OKCROPPB.pls 120.0 2005/05/25 19:31:13 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: g_sales_rep Number;
7: g_rty_code okc_k_rel_objs.rty_code%TYPE;
8: g_opp_h_created Boolean;

Line 295: IF nvl(fnd_profile.value('AS_OPP_ADDRESS_REQUIRED'), okc_api.g_miss_char) = 'Y' THEN

291: Close c5;
292:
293:
294: --TEMP okc_util.init_trace();
295: IF nvl(fnd_profile.value('AS_OPP_ADDRESS_REQUIRED'), okc_api.g_miss_char) = 'Y' THEN
296:
297: Open c5('STO'); --get the site_use_id of the ship_to_party_site_id
298: Fetch c5 Into c51_rec;
299: IF c5%NOTFOUND OR c51_rec.object1_id1 IS NULL THEN

Line 354: l_header_rec.win_probability := NVL(to_number(Fnd_Profile.Value('AS_OPP_WIN_PROBABILITY')), OKC_API.G_MISS_NUM);

350: IF p_context = 'EXPIRE' THEN
351: --Bug 2034318
352: --Action assembler defaults the win probability parameter to 50 when calling
353: --opportunity. This value may not be valid so we are defaulting it from profile option
354: l_header_rec.win_probability := NVL(to_number(Fnd_Profile.Value('AS_OPP_WIN_PROBABILITY')), OKC_API.G_MISS_NUM);
355: ELSE
356: --proceed as usual
357: l_header_rec.win_probability := l_win_probability;
358: END IF;

Line 385: IF nvl(TO_NUMBER(fnd_profile.value('OKC_DEFAULT_OPP_CODE')), okc_api.g_miss_num) = OKC_API.G_MISS_NUM

381: null;
382: end;
383:
384: --get value for AMS_P_SOURCE_CODES_V.SOURCE_CODE_ID
385: IF nvl(TO_NUMBER(fnd_profile.value('OKC_DEFAULT_OPP_CODE')), okc_api.g_miss_num) = OKC_API.G_MISS_NUM
386: AND
387: nvl(fnd_profile.value('AS_OPP_SOURCE_CODE_REQUIRED'), okc_api.g_miss_char) = 'Y'
388: THEN
389: okc_api.Set_Message(p_app_name => g_app_name,

Line 387: nvl(fnd_profile.value('AS_OPP_SOURCE_CODE_REQUIRED'), okc_api.g_miss_char) = 'Y'

383:
384: --get value for AMS_P_SOURCE_CODES_V.SOURCE_CODE_ID
385: IF nvl(TO_NUMBER(fnd_profile.value('OKC_DEFAULT_OPP_CODE')), okc_api.g_miss_num) = OKC_API.G_MISS_NUM
386: AND
387: nvl(fnd_profile.value('AS_OPP_SOURCE_CODE_REQUIRED'), okc_api.g_miss_char) = 'Y'
388: THEN
389: okc_api.Set_Message(p_app_name => g_app_name,
390: p_msg_name => 'OKC_OPP_NO_DEFLT_OPP_CODE'
391: );

Line 395: l_header_rec.source_promotion_id := nvl(TO_NUMBER(fnd_profile.value('OKC_DEFAULT_OPP_CODE')), okc_api.g_miss_num);

391: );
392: l_return_status := OKC_API.G_RET_STS_ERROR;
393: raise g_exception_halt_validation;
394: END IF;
395: l_header_rec.source_promotion_id := nvl(TO_NUMBER(fnd_profile.value('OKC_DEFAULT_OPP_CODE')), okc_api.g_miss_num);
396: --TEMP okc_util.print_trace(9,'l_header_rec.source_promotion_id: ' || l_header_rec.source_promotion_id);
397: IF (l_debug = 'Y') THEN
398: okc_debug.log('l_header_rec.source_promotion_id: ' || TO_CHAR(l_header_rec.source_promotion_id));
399: END IF;

Line 1436: x_win_probability := Fnd_Profile.Value('AS_OPP_WIN_PROBABILITY');

1432: If x_win_probability Is Null Then
1433: IF (l_debug = 'Y') THEN
1434: okc_debug.log('9050: Fetching win_probability from profile');
1435: END IF;
1436: x_win_probability := Fnd_Profile.Value('AS_OPP_WIN_PROBABILITY');
1437: End If;
1438: If x_closing_date_days Is Null Then
1439: IF (l_debug = 'Y') THEN
1440: okc_debug.log('9060: Fetching closing_date_days from profile');

Line 1442: x_closing_date_days := Fnd_Profile.Value('AS_OPP_CLOSING_DATE_DAYS');

1438: If x_closing_date_days Is Null Then
1439: IF (l_debug = 'Y') THEN
1440: okc_debug.log('9060: Fetching closing_date_days from profile');
1441: END IF;
1442: x_closing_date_days := Fnd_Profile.Value('AS_OPP_CLOSING_DATE_DAYS');
1443: End If;
1444: --
1445: IF (l_debug = 'Y') THEN
1446: okc_debug.log('9070: x_win_probability - ' || x_win_probability);