[Home] [Help]
32: FETCH l_schema_csr INTO l_schema;
33: CLOSE l_schema_csr;
34:
35: IF (l_schema is null) THEN
36: fnd_message.set_name('CN', 'CN_TBL_NO_SUCH_SCH');
37: fnd_msg_pub.ADD;
38: RAISE fnd_api.g_exc_error;
39: END IF;
40:
43: FETCH l_table_csr INTO l_table;
44: CLOSE l_table_csr;
45:
46: IF (l_table is null) THEN
47: fnd_message.set_name('CN', 'CN_TBL_NO_SUCH_TBL');
48: fnd_msg_pub.ADD;
49: RAISE fnd_api.g_exc_error;
50: END IF;
51: END IF;
52:
53: IF (p_table_rec.calc_eligible_flag <> 'Y' AND
54: p_table_rec.calc_eligible_flag <> 'C' AND
55: p_table_rec.calc_eligible_flag <> 'N') THEN
56: fnd_message.set_name('CN', 'CN_TBL_INC_CALC_FLAG');
57: fnd_msg_pub.ADD;
58: RAISE fnd_api.g_exc_error;
59: END IF;
60: END check_table_rec;
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315: -- API body
316: /* seeded tables can be updated
317: if (p_table_rec.object_id < 0) then
318: fnd_message.set_name('CN', 'CN_SD_TBL_NO_UPD');
319: fnd_msg_pub.ADD;
320: RAISE fnd_api.g_exc_error;
321: end if;
322: */
331:
332: if (l_row.schema <> p_table_rec.schema OR
333: l_row.name <> p_table_rec.name OR
334: l_row.ALIAS <> p_table_rec.ALIAS) then
335: fnd_message.set_name('CN', 'CN_TBL_ATTR_NO_UPD');
336: fnd_msg_pub.ADD;
337: RAISE fnd_api.g_exc_error;
338: end if;
339:
479: -- Initialize API return status to success
480: x_return_status := FND_API.G_RET_STS_SUCCESS;
481: -- API body
482: if (p_table_rec.object_id < 0) then
483: fnd_message.set_name('CN', 'CN_SD_TBL_NO_DEL');
484: fnd_msg_pub.ADD;
485: RAISE fnd_api.g_exc_error;
486: end if;
487:
504: --
505: -- IF Yes, Do Not Allow User To Delete That Table
506: --
507: IF ( l_dest_count > 0 OR l_sorc_count > 0 )
508: THEN fnd_message.set_name('CN','CN_TBL_MAP_EXIST');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_error;
511: END IF;
512: -------
678: x_return_status := FND_API.G_RET_STS_SUCCESS;
679: -- API body
680: -- first check if both pk and fk are Y
681: if (p_column_rec.primary_key = 'Y' and p_column_rec.foreign_key = 'Y') then
682: fnd_message.set_name('CN', 'CN_TBL_PK_FK_ERR');
683: fnd_msg_pub.ADD;
684: RAISE fnd_api.g_exc_error;
685: end if;
686:
696: CLOSE l_dim_csr;
697:
698: if (l_dimension_id = 0 OR
699: l_dimension_id <> p_column_rec.dimension_id) then
700: fnd_message.set_name('CN', 'DIM_PK_ALERT');
701: fnd_msg_pub.ADD;
702: RAISE fnd_api.g_exc_error;
703: end if;
704: end if;
705:
706: /* Not Enforced ???
707: if (p_column_rec.foreign_key = 'Y' and
708: p_column_rec.dimension_id is null) then
709: fnd_message.set_name('CN', 'CN_TBL_DIM_FK_ERR');
710: fnd_msg_pub.ADD;
711: RAISE fnd_api.g_exc_error;
712: end if;
713: */
717: FETCH l_dim_value_csr INTO l_dim_value_ctr;
718: CLOSE l_dim_value_csr;
719:
720: if (l_dim_value_ctr = 1 AND p_column_rec.user_column_name = 'Y') then
721: fnd_message.set_name('CN', 'CN_TBL_DIM_VAL_ERR');
722: fnd_msg_pub.ADD;
723: RAISE fnd_api.g_exc_error;
724: end if;
725:
932: FETCH l_valid_col_csr INTO l_col_count;
933: CLOSE l_valid_col_csr;
934:
935: IF (l_col_count = 0) THEN
936: fnd_message.set_name('CN', 'CN_TBL_NO_SUCH_DUP_COL');
937: fnd_msg_pub.ADD;
938: RAISE fnd_api.g_exc_error;
939: END IF;
940:
1122: fetch l_delete_csr into l_table_id;
1123: close l_delete_csr;
1124:
1125: if (l_table_id < 0) then
1126: fnd_message.set_name('CN', 'CN_SD_TBL_COL_NO_DEL');
1127: fnd_msg_pub.ADD;
1128: RAISE fnd_api.g_exc_error;
1129: end if;
1130: