DBA Data[Home] [Help]

APPS.IBE_MSITE_GRP dependencies on IBE_DSPMGRVALIDATION_GRP

Line 400: if ibe_dspmgrvalidation_grp.check_msite_exists(

396: THEN
397: IF (l_debug = 'Y') THEN
398: IBE_UTIL.Debug('[IBE_MSITE_GRP]Minisite id is passed');
399: END IF;
400: if ibe_dspmgrvalidation_grp.check_msite_exists(
401: p_msite_rec.msite_id, p_msite_rec.Object_version_Number) = false
402: then
403: IF (l_debug = 'Y') THEN
404: IBE_UTIL.Debug('[IBE_MSITE_GRP]Raising Exception: MiniSite Exists');

Line 419: if ibe_dspmgrvalidation_grp.check_root_section_exists(

415: END IF;
416: if p_msite_rec.msite_root_section_id <> FND_API.g_miss_num AND
417: p_msite_rec.msite_root_section_id is not null then
418:
419: if ibe_dspmgrvalidation_grp.check_root_section_exists(
420: p_msite_rec.msite_root_section_id) = false
421: then
422: IF (l_debug = 'Y') THEN
423: IBE_UTIL.Debug('Raising Exception:Root Section Does not exist');

Line 456: If Ibe_Dspmgrvalidation_Grp.Check_Msite_Accessname(

452: If ( p_msite_rec.msite_id IS NULL OR
453: p_msite_rec.msite_id = FND_API.g_miss_num) AND
454: (p_msite_rec.access_name IS NOT NULL AND
455: p_msite_rec.access_name <> FND_API.G_MISS_CHAR) Then
456: If Ibe_Dspmgrvalidation_Grp.Check_Msite_Accessname(
457: p_access_name => p_msite_rec.access_name)= FALSE
458: Then
459: IF (l_debug = 'Y') THEN
460: IBE_UTIL.Debug('Exception:Access Name is not Unique');

Line 476: if ibe_dspmgrvalidation_grp.check_root_section_exists(

472: raise store_not_exists_exception;
473: end if;
474: close store_id_cur;*/
475:
476: if ibe_dspmgrvalidation_grp.check_root_section_exists(
477: p_msite_rec.msite_root_section_id) = false
478: then
479: raise FND_API.g_exc_error;
480: end if;

Line 1573: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

1569: --- Check if the msite_id exists
1570: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
1571: THEN
1572:
1573: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
1574: raise FND_API.g_exc_error;
1575: end if;
1576:
1577: --dbms_output.put_line('Minisite id is passed ' );

Line 1673: raise ibe_dspmgrvalidation_grp.msite_req_exception;

1669: else
1670: raise FND_API.g_exc_error;
1671: end if;
1672: else
1673: raise ibe_dspmgrvalidation_grp.msite_req_exception;
1674: end if;
1675: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
1676: p_count => x_msg_count,
1677: p_data => x_msg_data

Line 1688: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN

1684: p_encoded => FND_API.g_false,
1685: p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );
1688: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
1689: ROLLBACK TO save_msite_languages;
1690: x_return_status := FND_API.g_ret_sts_error;
1691: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
1692: FND_MSG_PUB.ADD;

Line 1778: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

1774: --- Check if the msite_id exists
1775: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
1776: THEN
1777: --dbms_output.put_line('Minisite id is passed ' );
1778: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
1779: raise FND_API.g_exc_error;
1780: end if;
1781: if (p_msite_currencies_tbl.count > 0 ) then
1782: ---- Delete all the entries for the mini-site

Line 1934: raise ibe_dspmgrvalidation_grp.msite_req_exception;

1930: --dbms_output.put_line('raising an error' || l_insert_row);
1931: raise FND_API.g_exc_error;
1932: end if;
1933: else
1934: raise ibe_dspmgrvalidation_grp.msite_req_exception;
1935: end if;
1936: FND_MSG_PUB.count_and_get(
1937: p_encoded => FND_API.g_false,
1938: p_count => x_msg_count,

Line 1951: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN

1947: p_encoded => FND_API.g_false,
1948: p_count => x_msg_count,
1949: p_data => x_msg_data
1950: );
1951: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
1952: ROLLBACK TO save_msite_currencies;
1953: x_return_status := FND_API.g_ret_sts_error;
1954: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
1955: FND_MSG_PUB.ADD;

Line 2050: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

2046: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
2047: THEN
2048: --dbms_output.put_line('Minisite id is passed ' );
2049:
2050: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
2051: raise FND_API.g_exc_error;
2052: end if;
2053:
2054: if (p_msite_orgids_tbl.count > 0 ) then

Line 2136: raise ibe_dspmgrvalidation_grp.msite_req_exception;

2132: raise FND_API.g_exc_error;
2133: end if;
2134:
2135: else
2136: raise ibe_dspmgrvalidation_grp.msite_req_exception;
2137: end if;
2138:
2139: FND_MSG_PUB.count_and_get(
2140: p_encoded => FND_API.g_false,

Line 2156: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN

2152: p_count => x_msg_count,
2153: p_data => x_msg_data
2154: );
2155:
2156: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
2157: ROLLBACK TO save_msite_orgids;
2158: x_return_status := FND_API.g_ret_sts_error;
2159: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2160: FND_MSG_PUB.ADD;

Line 2261: --- if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id_tbl(l_index).msite_id) = false then

2257: p_msite_id_tbl(l_index).msite_id <> FND_API.g_miss_num
2258: THEN
2259: --dbms_output.put_line('Minisite id is passed ' );
2260:
2261: --- if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id_tbl(l_index).msite_id) = false then
2262: --- raise FND_API.g_exc_error;
2263: --- end if;
2264:
2265: ibe_physicalmap_grp.delete_msite(p_msite_id_tbl(l_index).msite_id);

Line 2311: raise ibe_dspmgrvalidation_grp.msite_req_exception;

2307: delete from ibe_wf_notif_msg_maps
2308: where msite_id = p_msite_id_tbl(l_index).msite_id;
2309:
2310: else
2311: raise ibe_dspmgrvalidation_grp.msite_req_exception;
2312: end if;
2313:
2314: EXCEPTION
2315: WHEN OTHERS THEN

Line 2346: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN

2342: p_count => x_msg_count,
2343: p_data => x_msg_data
2344: );
2345:
2346: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
2347: ROLLBACK TO delete_msite;
2348: x_return_status := FND_API.g_ret_sts_error;
2349: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2350: FND_MSG_PUB.ADD;

Line 2425: if ibe_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

2421: IF p_msite_id IS NOT NULL AND p_msite_id <> FND_API.g_miss_num
2422: THEN
2423: --dbms_output.put_line('Minisite id is passed ' );
2424:
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);

Line 2431: raise ibe_dspmgrvalidation_grp.msite_req_exception;

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:
2434: x_return_status := FND_API.G_RET_STS_SUCCESS;
2435:

Line 2452: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN

2448: p_count => x_msg_count,
2449: p_data => x_msg_data
2450: );
2451:
2452: WHEN ibe_dspmgrvalidation_grp.msite_req_exception THEN
2453: ROLLBACK TO get_msite_attribute;
2454: x_return_status := FND_API.g_ret_sts_error;
2455: FND_MESSAGE.set_name('IBE','IBE_MSITE_REQ');
2456: FND_MSG_PUB.ADD;