DBA Data[Home] [Help]

APPS.IBE_MSITE_GRP dependencies on FND_PROFILE

Line 367: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

363: where lookup_type = 'IBE_PARTY_ACCESS_CODE'
364: and lookup_code = p_code ;
365: BEGIN
366: l_operation_type:= 'INSERT';
367: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
368:
369: IF (l_debug = 'Y') THEN
370: IBE_UTIL.Debug('Start IBE_MSITE_GRP.Save_Msite');
371: END IF;

Line 1047: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

1043: WHERE msite_id = c_msite_id;
1044: BEGIN
1045: SAVEPOINT DUPLICATE_MSITE_SAVE;
1046: l_api_name:= 'duplicate_msite';
1047: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1048:
1049: IF (l_debug = 'Y') THEN
1050: IBE_UTIL.debug('duplicate_msite Starts +');
1051: IBE_UTIL.debug('p_api_version = '||p_api_version);

Line 1547: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

1543: l_debug VARCHAR2(1);
1544:
1545:
1546: BEGIN
1547: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1548:
1549: --------------------- initialize -----------------------+
1550: SAVEPOINT save_msite_languages;
1551:

Line 1756: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

1752: l_debug VARCHAR2(1);
1753: l_validate_result VARCHAR2(3);
1754:
1755: BEGIN
1756: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
1757:
1758: --------------------- initialize -----------------------+
1759:
1760: SAVEPOINT save_msite_currencies;

Line 2023: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

2019: default_index NUMBER := 0;
2020: l_debug VARCHAR2(1);
2021:
2022: BEGIN
2023: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
2024:
2025: --------------------- initialize -----------------------+
2026: SAVEPOINT save_msite_orgids;
2027:

Line 2229: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

2225: Where msite_id = p_msite_id ;
2226: l_debug VARCHAR2(1);
2227:
2228: BEGIN
2229: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
2230:
2231: --------------------- initialize -----------------------+
2232: SAVEPOINT delete_msite;
2233:

Line 2399: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');

2395: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
2396: l_debug VARCHAR2(1);
2397:
2398: BEGIN
2399: l_debug := NVL(FND_PROFILE.VALUE('IBE_DEBUG'),'N');
2400:
2401: --------------------- initialize -----------------------+
2402: SAVEPOINT get_msite_attribute;
2403:

Line 2429: x_msite_attribute_value := FND_PROFILE.VALUE_SPECIFIC(p_msite_attribute_name,null,null,671);

2425: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
2426: raise FND_API.g_exc_error;
2427: end if;
2428:
2429: x_msite_attribute_value := FND_PROFILE.VALUE_SPECIFIC(p_msite_attribute_name,null,null,671);
2430: ELSE
2431: raise ibe_dspmgrvalidation_grp.msite_req_exception;
2432: END IF;
2433: