117: l_alias := p_calc_ext_table_rec.alias || l_count ;
118: end if;
119:
120: --Check for missing parameters in the p_ruleset_rec parameter
121: IF (cn_api.chk_miss_null_char_para
122: ( p_calc_ext_table_rec.name,
123: cn_api.get_lkup_meaning('NAME', 'EXTERNAL_TABLE'),
124: x_loading_status,
125: x_loading_status) = FND_API.G_TRUE )
119:
120: --Check for missing parameters in the p_ruleset_rec parameter
121: IF (cn_api.chk_miss_null_char_para
122: ( p_calc_ext_table_rec.name,
123: cn_api.get_lkup_meaning('NAME', 'EXTERNAL_TABLE'),
124: x_loading_status,
125: x_loading_status) = FND_API.G_TRUE )
126: THEN
127: RAISE fnd_api.g_exc_error;
126: THEN
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:
130: IF (cn_api.chk_miss_null_num_para
131: ( p_calc_ext_table_rec.internal_table_id,
132: cn_api.get_lkup_meaning('INTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
133: x_loading_status,
134: x_loading_status) = FND_API.G_TRUE )
128: END IF;
129:
130: IF (cn_api.chk_miss_null_num_para
131: ( p_calc_ext_table_rec.internal_table_id,
132: cn_api.get_lkup_meaning('INTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
133: x_loading_status,
134: x_loading_status) = FND_API.G_TRUE )
135: THEN
136: RAISE fnd_api.g_exc_error;
145: x_loading_status := 'CN_INTERNAL_TABLE_NOT_NULL';
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;
148:
149: IF (cn_api.chk_miss_null_num_para
150: ( p_calc_ext_table_rec.external_table_id,
151: cn_api.get_lkup_meaning('EXTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
152: x_loading_status,
153: x_loading_status) = FND_API.G_TRUE )
147: END IF;
148:
149: IF (cn_api.chk_miss_null_num_para
150: ( p_calc_ext_table_rec.external_table_id,
151: cn_api.get_lkup_meaning('EXTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
152: x_loading_status,
153: x_loading_status) = FND_API.G_TRUE )
154: THEN
155: RAISE fnd_api.g_exc_error;
164: x_loading_status := 'CN_EXTERNAL_TABLE_NOT_NULL';
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;
167:
168: IF (cn_api.chk_miss_null_char_para
169: ( p_calc_ext_table_rec.used_flag,
170: cn_api.get_lkup_meaning('USED_FLAG', 'EXTERNAL_TABLE'),
171: x_loading_status,
172: x_loading_status) = FND_API.G_TRUE )
166: END IF;
167:
168: IF (cn_api.chk_miss_null_char_para
169: ( p_calc_ext_table_rec.used_flag,
170: cn_api.get_lkup_meaning('USED_FLAG', 'EXTERNAL_TABLE'),
171: x_loading_status,
172: x_loading_status) = FND_API.G_TRUE )
173: THEN
174: RAISE fnd_api.g_exc_error;
173: THEN
174: RAISE fnd_api.g_exc_error;
175: END IF;
176:
177: IF (cn_api.chk_miss_null_char_para
178: ( p_calc_ext_table_rec.schema,
179: cn_api.get_lkup_meaning('SCHEMA', 'EXTERNAL_TABLE'),
180: x_loading_status,
181: x_loading_status) = FND_API.G_TRUE )
175: END IF;
176:
177: IF (cn_api.chk_miss_null_char_para
178: ( p_calc_ext_table_rec.schema,
179: cn_api.get_lkup_meaning('SCHEMA', 'EXTERNAL_TABLE'),
180: x_loading_status,
181: x_loading_status) = FND_API.G_TRUE )
182: THEN
183: RAISE fnd_api.g_exc_error;
182: THEN
183: RAISE fnd_api.g_exc_error;
184: END IF;
185:
186: /* IF (cn_api.chk_miss_null_char_para
187: ( p_calc_ext_table_rec.alias,
188: cn_api.get_lkup_meaning('ALIAS', 'EXTERNAL_TABLE'),
189: x_loading_status,
190: x_loading_status) = FND_API.G_TRUE )
184: END IF;
185:
186: /* IF (cn_api.chk_miss_null_char_para
187: ( p_calc_ext_table_rec.alias,
188: cn_api.get_lkup_meaning('ALIAS', 'EXTERNAL_TABLE'),
189: x_loading_status,
190: x_loading_status) = FND_API.G_TRUE )
191: THEN
192: RAISE fnd_api.g_exc_error;
392: l_count := l_count + 1;
393: l_alias := p_calc_ext_table_rec.alias || l_count;
394: end if;
395:
396: IF (cn_api.chk_miss_null_char_para
397: ( p_calc_ext_table_rec.name,
398: cn_api.get_lkup_meaning('NAME', 'EXTERNAL_TABLE'),
399: x_loading_status,
400: x_loading_status) = FND_API.G_TRUE )
394: end if;
395:
396: IF (cn_api.chk_miss_null_char_para
397: ( p_calc_ext_table_rec.name,
398: cn_api.get_lkup_meaning('NAME', 'EXTERNAL_TABLE'),
399: x_loading_status,
400: x_loading_status) = FND_API.G_TRUE )
401: THEN
402: RAISE fnd_api.g_exc_error;
402: RAISE fnd_api.g_exc_error;
403: END IF;
404:
405:
406: IF (cn_api.chk_miss_null_num_para
407: ( p_calc_ext_table_rec.internal_table_id,
408: cn_api.get_lkup_meaning('INTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
409: x_loading_status,
410: x_loading_status) = FND_API.G_TRUE )
404:
405:
406: IF (cn_api.chk_miss_null_num_para
407: ( p_calc_ext_table_rec.internal_table_id,
408: cn_api.get_lkup_meaning('INTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
409: x_loading_status,
410: x_loading_status) = FND_API.G_TRUE )
411: THEN
412: RAISE fnd_api.g_exc_error;
421: x_loading_status := 'CN_INTERNAL_TABLE_NOT_NULL';
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
425: IF (cn_api.chk_miss_null_num_para
426: ( p_calc_ext_table_rec.external_table_id,
427: cn_api.get_lkup_meaning('EXTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
428: x_loading_status,
429: x_loading_status) = FND_API.G_TRUE )
423: END IF;
424:
425: IF (cn_api.chk_miss_null_num_para
426: ( p_calc_ext_table_rec.external_table_id,
427: cn_api.get_lkup_meaning('EXTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),
428: x_loading_status,
429: x_loading_status) = FND_API.G_TRUE )
430: THEN
431: RAISE fnd_api.g_exc_error;
430: THEN
431: RAISE fnd_api.g_exc_error;
432: END IF ;
433:
434: IF (cn_api.chk_miss_null_char_para
435: ( p_calc_ext_table_rec.used_flag,
436: cn_api.get_lkup_meaning('USED_FLAG', 'EXTERNAL_TABLE'),
437: x_loading_status,
438: x_loading_status) = FND_API.G_TRUE )
432: END IF ;
433:
434: IF (cn_api.chk_miss_null_char_para
435: ( p_calc_ext_table_rec.used_flag,
436: cn_api.get_lkup_meaning('USED_FLAG', 'EXTERNAL_TABLE'),
437: x_loading_status,
438: x_loading_status) = FND_API.G_TRUE )
439: THEN
440: RAISE fnd_api.g_exc_error;
449: x_loading_status := 'CN_EXTERNAL_TABLE_NOT_NULL';
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;
452:
453: IF (cn_api.chk_miss_null_char_para
454: ( p_calc_ext_table_rec.schema,
455: cn_api.get_lkup_meaning('SCHEMA', 'EXTERNAL_TABLE'),
456: x_loading_status,
457: x_loading_status) = FND_API.G_TRUE )
451: END IF;
452:
453: IF (cn_api.chk_miss_null_char_para
454: ( p_calc_ext_table_rec.schema,
455: cn_api.get_lkup_meaning('SCHEMA', 'EXTERNAL_TABLE'),
456: x_loading_status,
457: x_loading_status) = FND_API.G_TRUE )
458: THEN
459: RAISE fnd_api.g_exc_error;
458: THEN
459: RAISE fnd_api.g_exc_error;
460: END IF ;
461:
462: IF (cn_api.chk_miss_null_char_para
463: ( p_calc_ext_table_rec.alias,
464: cn_api.get_lkup_meaning('ALIAS', 'EXTERNAL_TABLE'),
465: x_loading_status,
466: x_loading_status) = FND_API.G_TRUE )
460: END IF ;
461:
462: IF (cn_api.chk_miss_null_char_para
463: ( p_calc_ext_table_rec.alias,
464: cn_api.get_lkup_meaning('ALIAS', 'EXTERNAL_TABLE'),
465: x_loading_status,
466: x_loading_status) = FND_API.G_TRUE )
467: THEN
468: RAISE fnd_api.g_exc_error;