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