DBA Data[Home] [Help]

APPS.JTF_MSITE_GRP dependencies on JTF_DSPMGRVALIDATION_GRP

Line 404: if jtf_dspmgrvalidation_grp.check_msite_exists(

400: p_msite_rec.msite_id <> FND_API.g_miss_num
401: THEN
402: --dbms_output.put_line('Minisite id is passed ' );
403:
404: if jtf_dspmgrvalidation_grp.check_msite_exists(
405: p_msite_rec.msite_id, p_msite_rec.Object_version_Number) = false
406: then
407: raise FND_API.g_exc_error;
408: end if;

Line 418: if jtf_dspmgrvalidation_grp.check_root_section_exists(

414: END IF;
415: if p_msite_rec.msite_root_section_id <> FND_API.g_miss_num AND
416: p_msite_rec.msite_root_section_id is not null then
417:
418: if jtf_dspmgrvalidation_grp.check_root_section_exists(
419: p_msite_rec.msite_root_section_id) = false
420: then
421: raise FND_API.g_exc_error;
422: end if;

Line 452: If Jtf_Dspmgrvalidation_Grp.Check_Msite_Accessname(

448: If ( p_msite_rec.msite_id IS NULL OR
449: p_msite_rec.msite_id = FND_API.g_miss_num) AND
450: (p_msite_rec.access_name IS NOT NULL AND
451: p_msite_rec.access_name <> FND_API.G_MISS_CHAR) Then
452: If Jtf_Dspmgrvalidation_Grp.Check_Msite_Accessname(
453: p_access_name => p_msite_rec.access_name)= FALSE
454: Then
455: Raise FND_API.G_EXC_ERROR ;
456: End If;

Line 469: if jtf_dspmgrvalidation_grp.check_root_section_exists(

465: raise store_not_exists_exception;
466: end if;
467: close store_id_cur;
468:
469: if jtf_dspmgrvalidation_grp.check_root_section_exists(
470: p_msite_rec.msite_root_section_id) = false
471: then
472: raise FND_API.g_exc_error;
473: end if;

Line 895: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

891: --- Check if the msite_id exists
892: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
893: THEN
894:
895: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
896: raise FND_API.g_exc_error;
897: end if;
898:
899: --dbms_output.put_line('Minisite id is passed ' );

Line 992: raise jtf_dspmgrvalidation_grp.msite_req_exception;

988: else
989: raise FND_API.g_exc_error;
990: end if;
991: else
992: raise jtf_dspmgrvalidation_grp.msite_req_exception;
993: end if;
994: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false,
995: p_count => x_msg_count,
996: p_data => x_msg_data

Line 1007: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN

1003: p_encoded => FND_API.g_false,
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1007: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1008: ROLLBACK TO save_msite_languages;
1009: x_return_status := FND_API.g_ret_sts_error;
1010: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1011: FND_MSG_PUB.ADD;

Line 1089: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

1085: --- Check if the msite_id exists
1086: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
1087: THEN
1088: --dbms_output.put_line('Minisite id is passed ' );
1089: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
1090: raise FND_API.g_exc_error;
1091: end if;
1092: if (p_msite_currencies_tbl.count > 0 ) then
1093: ---- Delete all the entries for the mini-site

Line 1186: raise jtf_dspmgrvalidation_grp.msite_req_exception;

1182: --dbms_output.put_line('raising an error' || l_insert_row);
1183: raise FND_API.g_exc_error;
1184: end if;
1185: else
1186: raise jtf_dspmgrvalidation_grp.msite_req_exception;
1187: end if;
1188: FND_MSG_PUB.count_and_get(
1189: p_encoded => FND_API.g_false,
1190: p_count => x_msg_count,

Line 1203: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN

1199: p_encoded => FND_API.g_false,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data
1202: );
1203: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1204: ROLLBACK TO save_msite_currencies;
1205: x_return_status := FND_API.g_ret_sts_error;
1206: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1207: FND_MSG_PUB.ADD;

Line 1300: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

1296: IF p_msite_id IS NOT NULL and p_msite_id <> FND_API.g_miss_num
1297: THEN
1298: --dbms_output.put_line('Minisite id is passed ' );
1299:
1300: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
1301: raise FND_API.g_exc_error;
1302: end if;
1303:
1304: if (p_msite_orgids_tbl.count > 0 ) then

Line 1386: raise jtf_dspmgrvalidation_grp.msite_req_exception;

1382: raise FND_API.g_exc_error;
1383: end if;
1384:
1385: else
1386: raise jtf_dspmgrvalidation_grp.msite_req_exception;
1387: end if;
1388:
1389: FND_MSG_PUB.count_and_get(
1390: p_encoded => FND_API.g_false,

Line 1406: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN

1402: p_count => x_msg_count,
1403: p_data => x_msg_data
1404: );
1405:
1406: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1407: ROLLBACK TO save_msite_orgids;
1408: x_return_status := FND_API.g_ret_sts_error;
1409: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1410: FND_MSG_PUB.ADD;

Line 1508: --- if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id_tbl(l_index).msite_id) = false then

1504: p_msite_id_tbl(l_index).msite_id <> FND_API.g_miss_num
1505: THEN
1506: --dbms_output.put_line('Minisite id is passed ' );
1507:
1508: --- if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id_tbl(l_index).msite_id) = false then
1509: --- raise FND_API.g_exc_error;
1510: --- end if;
1511:
1512: jtf_physicalmap_grp.delete_msite(p_msite_id_tbl(l_index).msite_id);

Line 1555: raise jtf_dspmgrvalidation_grp.msite_req_exception;

1551: delete from jtf_msite_prty_accss
1552: where msite_id = p_msite_id_tbl(l_index).msite_id;
1553:
1554: else
1555: raise jtf_dspmgrvalidation_grp.msite_req_exception;
1556: end if;
1557:
1558: EXCEPTION
1559: WHEN OTHERS THEN

Line 1590: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN

1586: p_count => x_msg_count,
1587: p_data => x_msg_data
1588: );
1589:
1590: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1591: ROLLBACK TO delete_msite;
1592: x_return_status := FND_API.g_ret_sts_error;
1593: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1594: FND_MSG_PUB.ADD;

Line 1667: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then

1663: IF p_msite_id IS NOT NULL AND p_msite_id <> FND_API.g_miss_num
1664: THEN
1665: --dbms_output.put_line('Minisite id is passed ' );
1666:
1667: if jtf_dspmgrvalidation_grp.check_msite_exists(p_msite_id) = false then
1668: raise FND_API.g_exc_error;
1669: end if;
1670:
1671: x_msite_attribute_value := FND_PROFILE.VALUE_SPECIFIC(p_msite_attribute_name,null,null,671);

Line 1673: raise jtf_dspmgrvalidation_grp.msite_req_exception;

1669: end if;
1670:
1671: x_msite_attribute_value := FND_PROFILE.VALUE_SPECIFIC(p_msite_attribute_name,null,null,671);
1672: ELSE
1673: raise jtf_dspmgrvalidation_grp.msite_req_exception;
1674: END IF;
1675:
1676: x_return_status := FND_API.G_RET_STS_SUCCESS;
1677:

Line 1694: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN

1690: p_count => x_msg_count,
1691: p_data => x_msg_data
1692: );
1693:
1694: WHEN jtf_dspmgrvalidation_grp.msite_req_exception THEN
1695: ROLLBACK TO get_msite_attribute;
1696: x_return_status := FND_API.g_ret_sts_error;
1697: FND_MESSAGE.set_name('JTF','JTF_MSITE_REQ');
1698: FND_MSG_PUB.ADD;