DBA Data[Home] [Help]

APPS.IBE_MSITE_GRP dependencies on IBE_MSITE_GRP

Line 1: PACKAGE BODY IBE_MSite_GRP AS

1: PACKAGE BODY IBE_MSite_GRP AS
2: /* $Header: IBEGMSTB.pls 120.7 2006/07/03 10:32:33 apgupta ship $ */
3:
4: master_msite_exists_exception EXCEPTION;
5: store_not_exists_exception exception;

Line 370: IBE_UTIL.Debug('Start IBE_MSITE_GRP.Save_Msite');

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;
372:
373: --------------------- initialize -----------------------+
374: SAVEPOINT save_msite;

Line 398: IBE_UTIL.Debug('[IBE_MSITE_GRP]Minisite id is passed');

394: IF p_msite_rec.msite_id IS NOT NULL AND
395: p_msite_rec.msite_id <> FND_API.g_miss_num
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

Line 404: IBE_UTIL.Debug('[IBE_MSITE_GRP]Raising Exception: MiniSite Exists');

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');
405: END IF;
406: raise FND_API.g_exc_error;
407: end if;
408:

Line 412: IBE_UTIL.Debug('[IBE_MSITE_GRP]Operation is an Update');

408:
409: l_operation_type:='UPDATE';
410:
411: IF (l_debug = 'Y') THEN
412: IBE_UTIL.Debug('[IBE_MSITE_GRP]Operation is an Update');
413: END IF;
414:
415: END IF;
416: if p_msite_rec.msite_root_section_id <> FND_API.g_miss_num AND

Line 1009: l_msite_rec IBE_MSite_GRP.Msite_REC_TYPE;

1005: l_is_any_duplicate_status VARCHAR2(1);
1006:
1007: l_msite_id NUMBER;
1008: l_version_number NUMBER;
1009: l_msite_rec IBE_MSite_GRP.Msite_REC_TYPE;
1010: l_msite_languages_tbl IBE_MSite_GRP.msite_languages_tbl_type;
1011: l_msite_currencies_tbl IBE_MSite_GRP.MSITE_CURRENCIES_TBL_TYPE;
1012:
1013: CURSOR c_get_msite_detail_csr(c_msite_id NUMBER) IS

Line 1010: l_msite_languages_tbl IBE_MSite_GRP.msite_languages_tbl_type;

1006:
1007: l_msite_id NUMBER;
1008: l_version_number NUMBER;
1009: l_msite_rec IBE_MSite_GRP.Msite_REC_TYPE;
1010: l_msite_languages_tbl IBE_MSite_GRP.msite_languages_tbl_type;
1011: l_msite_currencies_tbl IBE_MSite_GRP.MSITE_CURRENCIES_TBL_TYPE;
1012:
1013: CURSOR c_get_msite_detail_csr(c_msite_id NUMBER) IS
1014: select party_access_code

Line 1011: l_msite_currencies_tbl IBE_MSite_GRP.MSITE_CURRENCIES_TBL_TYPE;

1007: l_msite_id NUMBER;
1008: l_version_number NUMBER;
1009: l_msite_rec IBE_MSite_GRP.Msite_REC_TYPE;
1010: l_msite_languages_tbl IBE_MSite_GRP.msite_languages_tbl_type;
1011: l_msite_currencies_tbl IBE_MSite_GRP.MSITE_CURRENCIES_TBL_TYPE;
1012:
1013: CURSOR c_get_msite_detail_csr(c_msite_id NUMBER) IS
1014: select party_access_code
1015: from ibe_msites_b

Line 1113: IBE_MSite_GRP.save_msite(

1109: l_msite_rec.theme_id := null;
1110: l_msite_rec.enable_traffic_filter := p_msite_rec.enable_traffic_filter;
1111: l_msite_rec.reporting_status := p_msite_rec.reporting_status;
1112: l_msite_rec.site_type := p_msite_rec.site_type;
1113: IBE_MSite_GRP.save_msite(
1114: p_api_version => l_api_version,
1115: p_init_msg_list => FND_API.g_false,
1116: p_commit => FND_API.g_false,
1117: x_return_status => l_return_status,

Line 1123: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');

1119: x_msg_data => l_msg_data,
1120: p_msite_rec => l_msite_rec);
1121: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1122: IF (l_debug = 'Y') THEN
1123: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1124: for i in 1..l_msg_count loop
1125: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1126: IBE_UTIL.debug(l_msg_data);
1127: end loop;

Line 1132: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');

1128: END IF;
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1131: IF (l_debug = 'Y') THEN
1132: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite');
1133: for i in 1..l_msg_count loop
1134: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1135: IBE_UTIL.debug(l_msg_data);
1136: end loop;

Line 1174: IBE_MSite_GRP.save_msite_languages(

1170: l_msite_languages_tbl(l_i).language_code := p_default_language_code;
1171: l_msite_languages_tbl(l_i).default_flag := FND_API.g_true;
1172: l_msite_languages_tbl(l_i).enable_flag := 'Y';
1173: END IF;
1174: IBE_MSite_GRP.save_msite_languages(
1175: p_api_version => l_api_version,
1176: p_init_msg_list => FND_API.g_false,
1177: p_commit => p_commit,
1178: x_return_status => l_return_status,

Line 1185: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');

1181: p_msite_id => l_msite_id,
1182: p_msite_languages_tbl => l_msite_languages_tbl);
1183: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: IF (l_debug = 'Y') THEN
1185: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1186: for i in 1..l_msg_count loop
1187: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1188: IBE_UTIL.debug(l_msg_data);
1189: end loop;

Line 1194: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');

1190: END IF;
1191: RAISE FND_API.G_EXC_ERROR;
1192: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1193: IF (l_debug = 'Y') THEN
1194: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_languages');
1195: for i in 1..l_msg_count loop
1196: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1197: IBE_UTIL.debug(l_msg_data);
1198: end loop;

Line 1274: IBE_MSite_GRP.save_msite_currencies(

1270: l_msite_currencies_tbl(l_i).partner_prc_lst_id
1271: := p_walkin_pricing_id;
1272:
1273: END IF;
1274: IBE_MSite_GRP.save_msite_currencies(
1275: p_api_version => 1.0,
1276: p_init_msg_list => FND_API.g_false,
1277: p_commit => p_commit,
1278: x_return_status => l_return_status,

Line 1285: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1281: p_msite_id => l_msite_id,
1282: p_msite_currencies_tbl => l_msite_currencies_tbl);
1283: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1284: IF (l_debug = 'Y') THEN
1285: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1286: for i in 1..l_msg_count loop
1287: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1288: IBE_UTIL.debug(l_msg_data);
1289: end loop;

Line 1294: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1290: END IF;
1291: RAISE FND_API.G_EXC_ERROR;
1292: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1293: IF (l_debug = 'Y') THEN
1294: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1295: for i in 1..l_msg_count loop
1296: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1297: IBE_UTIL.debug(l_msg_data);
1298: end loop;

Line 1455: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1451: x_msg_count => l_msg_count,
1452: x_msg_data => l_msg_data);
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: IF (l_debug = 'Y') THEN
1455: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1456: for i in 1..l_msg_count loop
1457: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1458: IBE_UTIL.debug(l_msg_data);
1459: end loop;

Line 1464: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');

1460: END IF;
1461: RAISE FND_API.G_EXC_ERROR;
1462: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1463: IF (l_debug = 'Y') THEN
1464: IBE_UTIL.debug('Error in IBE_MSite_GRP.save_msite_currencies');
1465: for i in 1..l_msg_count loop
1466: l_msg_data := FND_MSG_PUB.get(i,FND_API.G_FALSE);
1467: IBE_UTIL.debug(l_msg_data);
1468: end loop;

Line 3447: END IBE_Msite_GRP;

3443:
3444: END LOAD_SEED_ROW;
3445:
3446:
3447: END IBE_Msite_GRP;