DBA Data[Home] [Help]

APPS.CN_CALC_EXT_TABLES_PVT dependencies on CN_API

Line 121: IF (cn_api.chk_miss_null_char_para

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 )

Line 123: cn_api.get_lkup_meaning('NAME', 'EXTERNAL_TABLE'),

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;

Line 130: IF (cn_api.chk_miss_null_num_para

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 )

Line 132: cn_api.get_lkup_meaning('INTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),

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;

Line 149: IF (cn_api.chk_miss_null_num_para

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 )

Line 151: cn_api.get_lkup_meaning('EXTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),

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;

Line 168: IF (cn_api.chk_miss_null_char_para

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 )

Line 170: cn_api.get_lkup_meaning('USED_FLAG', 'EXTERNAL_TABLE'),

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;

Line 177: IF (cn_api.chk_miss_null_char_para

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 )

Line 179: cn_api.get_lkup_meaning('SCHEMA', 'EXTERNAL_TABLE'),

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;

Line 186: /* IF (cn_api.chk_miss_null_char_para

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 )

Line 188: cn_api.get_lkup_meaning('ALIAS', 'EXTERNAL_TABLE'),

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;

Line 396: IF (cn_api.chk_miss_null_char_para

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 )

Line 398: cn_api.get_lkup_meaning('NAME', 'EXTERNAL_TABLE'),

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;

Line 406: IF (cn_api.chk_miss_null_num_para

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 )

Line 408: cn_api.get_lkup_meaning('INTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),

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;

Line 425: IF (cn_api.chk_miss_null_num_para

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 )

Line 427: cn_api.get_lkup_meaning('EXTERNAL_TABLE_ID', 'EXTERNAL_TABLE'),

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;

Line 434: IF (cn_api.chk_miss_null_char_para

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 )

Line 436: cn_api.get_lkup_meaning('USED_FLAG', 'EXTERNAL_TABLE'),

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;

Line 453: IF (cn_api.chk_miss_null_char_para

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 )

Line 455: cn_api.get_lkup_meaning('SCHEMA', 'EXTERNAL_TABLE'),

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;

Line 462: IF (cn_api.chk_miss_null_char_para

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 )

Line 464: cn_api.get_lkup_meaning('ALIAS', 'EXTERNAL_TABLE'),

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;