eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SYS_TABLES_PVT dependencies on FND_MSG_PUB

Line 36: fnd_msg_pub.ADD;

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:
40:

Line 47: fnd_msg_pub.ADD;

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:

Line 56: fnd_msg_pub.ADD;

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;
60: --}}}

Line 136: FND_MSG_PUB.initialize;

132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134: -- Initialize message list if p_init_msg_list is set to TRUE.
135: IF FND_API.to_Boolean( p_init_msg_list ) THEN
136: FND_MSG_PUB.initialize;
137: END IF;
138: -- Initialize API return status to success
139: x_return_status := FND_API.G_RET_STS_SUCCESS;
140: -- API body

Line 200: FND_MSG_PUB.Count_And_Get

196: IF FND_API.To_Boolean( p_commit ) THEN
197: COMMIT WORK;
198: END IF;
199: -- Standard call to get message count and if count is 1, get message info.
200: FND_MSG_PUB.Count_And_Get
201: (p_count => x_msg_count ,
202: p_data => x_msg_data ,
203: p_encoded => FND_API.G_FALSE );
204: EXCEPTION

Line 208: FND_MSG_PUB.Count_And_Get

204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: ROLLBACK TO create_table_pvt;
207: x_return_status := FND_API.G_RET_STS_ERROR ;
208: FND_MSG_PUB.Count_And_Get
209: (p_count => x_msg_count ,
210: p_data => x_msg_data ,
211: p_encoded => FND_API.G_FALSE );
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 215: FND_MSG_PUB.Count_And_Get

211: p_encoded => FND_API.G_FALSE );
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: ROLLBACK TO create_table_pvt;
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count ,
217: p_data => x_msg_data ,
218: p_encoded => FND_API.G_FALSE );
219: WHEN OTHERS THEN

Line 222: IF FND_MSG_PUB.Check_Msg_Level

218: p_encoded => FND_API.G_FALSE );
219: WHEN OTHERS THEN
220: ROLLBACK TO create_table_pvt;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: IF FND_MSG_PUB.Check_Msg_Level
223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg
226: (G_PKG_NAME ,

Line 223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

219: WHEN OTHERS THEN
220: ROLLBACK TO create_table_pvt;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: IF FND_MSG_PUB.Check_Msg_Level
223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg
226: (G_PKG_NAME ,
227: l_api_name );

Line 225: FND_MSG_PUB.Add_Exc_Msg

221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: IF FND_MSG_PUB.Check_Msg_Level
223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: FND_MSG_PUB.Add_Exc_Msg
226: (G_PKG_NAME ,
227: l_api_name );
228: END IF;
229: FND_MSG_PUB.Count_And_Get

Line 229: FND_MSG_PUB.Count_And_Get

225: FND_MSG_PUB.Add_Exc_Msg
226: (G_PKG_NAME ,
227: l_api_name );
228: END IF;
229: FND_MSG_PUB.Count_And_Get
230: (p_count => x_msg_count ,
231: p_data => x_msg_data ,
232: p_encoded => FND_API.G_FALSE );
233: END Create_Table;

Line 310: FND_MSG_PUB.initialize;

306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: END IF;
308: -- Initialize message list if p_init_msg_list is set to TRUE.
309: IF FND_API.to_Boolean( p_init_msg_list ) THEN
310: FND_MSG_PUB.initialize;
311: END IF;
312: -- Initialize API return status to success
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314: -- API body

Line 318: fnd_msg_pub.ADD;

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: */
322:

Line 335: fnd_msg_pub.ADD;

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:
339: OPEN l_repository_csr;

Line 374: FND_MSG_PUB.Count_And_Get

370: IF FND_API.To_Boolean( p_commit ) THEN
371: COMMIT WORK;
372: END IF;
373: -- Standard call to get message count and if count is 1, get message info.
374: FND_MSG_PUB.Count_And_Get
375: (p_count => x_msg_count ,
376: p_data => x_msg_data ,
377: p_encoded => FND_API.G_FALSE );
378: EXCEPTION

Line 382: FND_MSG_PUB.Count_And_Get

378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: ROLLBACK TO update_table_pvt;
381: x_return_status := FND_API.G_RET_STS_ERROR ;
382: FND_MSG_PUB.Count_And_Get
383: (p_count => x_msg_count ,
384: p_data => x_msg_data ,
385: p_encoded => FND_API.G_FALSE );
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 389: FND_MSG_PUB.Count_And_Get

385: p_encoded => FND_API.G_FALSE );
386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387: ROLLBACK TO update_table_pvt;
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
389: FND_MSG_PUB.Count_And_Get
390: (p_count => x_msg_count ,
391: p_data => x_msg_data ,
392: p_encoded => FND_API.G_FALSE );
393: WHEN OTHERS THEN

Line 396: IF FND_MSG_PUB.Check_Msg_Level

392: p_encoded => FND_API.G_FALSE );
393: WHEN OTHERS THEN
394: ROLLBACK TO update_table_pvt;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.Check_Msg_Level
397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg
400: (G_PKG_NAME ,

Line 397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

393: WHEN OTHERS THEN
394: ROLLBACK TO update_table_pvt;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.Check_Msg_Level
397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg
400: (G_PKG_NAME ,
401: l_api_name );

Line 399: FND_MSG_PUB.Add_Exc_Msg

395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
396: IF FND_MSG_PUB.Check_Msg_Level
397: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: FND_MSG_PUB.Add_Exc_Msg
400: (G_PKG_NAME ,
401: l_api_name );
402: END IF;
403: FND_MSG_PUB.Count_And_Get

Line 403: FND_MSG_PUB.Count_And_Get

399: FND_MSG_PUB.Add_Exc_Msg
400: (G_PKG_NAME ,
401: l_api_name );
402: END IF;
403: FND_MSG_PUB.Count_And_Get
404: (p_count => x_msg_count ,
405: p_data => x_msg_data ,
406: p_encoded => FND_API.G_FALSE );
407: END Update_Table;

Line 476: FND_MSG_PUB.initialize;

472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478: -- Initialize API return status to success
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480: -- API body

Line 483: fnd_msg_pub.ADD;

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:
487: -- By Hithanki For Bug Fix : 2698989

Line 508: fnd_msg_pub.ADD;

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: -------
512:

Line 530: FND_MSG_PUB.Count_And_Get

526: IF FND_API.To_Boolean( p_commit ) THEN
527: COMMIT WORK;
528: END IF;
529: -- Standard call to get message count and if count is 1, get message info.
530: FND_MSG_PUB.Count_And_Get
531: (p_count => x_msg_count ,
532: p_data => x_msg_data ,
533: p_encoded => FND_API.G_FALSE );
534: EXCEPTION

Line 538: FND_MSG_PUB.Count_And_Get

534: EXCEPTION
535: WHEN FND_API.G_EXC_ERROR THEN
536: ROLLBACK TO delete_table_pvt;
537: x_return_status := FND_API.G_RET_STS_ERROR ;
538: FND_MSG_PUB.Count_And_Get
539: (p_count => x_msg_count ,
540: p_data => x_msg_data ,
541: p_encoded => FND_API.G_FALSE );
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 545: FND_MSG_PUB.Count_And_Get

541: p_encoded => FND_API.G_FALSE );
542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
543: ROLLBACK TO delete_table_pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count ,
547: p_data => x_msg_data ,
548: p_encoded => FND_API.G_FALSE );
549: WHEN OTHERS THEN

Line 552: IF FND_MSG_PUB.Check_Msg_Level

548: p_encoded => FND_API.G_FALSE );
549: WHEN OTHERS THEN
550: ROLLBACK TO delete_table_pvt;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: IF FND_MSG_PUB.Check_Msg_Level
553: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: THEN
555: FND_MSG_PUB.Add_Exc_Msg
556: (G_PKG_NAME ,

Line 553: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

549: WHEN OTHERS THEN
550: ROLLBACK TO delete_table_pvt;
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: IF FND_MSG_PUB.Check_Msg_Level
553: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: THEN
555: FND_MSG_PUB.Add_Exc_Msg
556: (G_PKG_NAME ,
557: l_api_name );

Line 555: FND_MSG_PUB.Add_Exc_Msg

551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
552: IF FND_MSG_PUB.Check_Msg_Level
553: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
554: THEN
555: FND_MSG_PUB.Add_Exc_Msg
556: (G_PKG_NAME ,
557: l_api_name );
558: END IF;
559: FND_MSG_PUB.Count_And_Get

Line 559: FND_MSG_PUB.Count_And_Get

555: FND_MSG_PUB.Add_Exc_Msg
556: (G_PKG_NAME ,
557: l_api_name );
558: END IF;
559: FND_MSG_PUB.Count_And_Get
560: (p_count => x_msg_count ,
561: p_data => x_msg_data ,
562: p_encoded => FND_API.G_FALSE );
563: END Delete_Table;

Line 674: FND_MSG_PUB.initialize;

670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
671: END IF;
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean( p_init_msg_list ) THEN
674: FND_MSG_PUB.initialize;
675: END IF;
676: -- Initialize API return status to success
677: x_return_status := FND_API.G_RET_STS_SUCCESS;
678: -- API body

Line 682: fnd_msg_pub.ADD;

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:
686: --next check if dim is correct

Line 700: fnd_msg_pub.ADD;

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:

Line 709: fnd_msg_pub.ADD;

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: */
713:

Line 721: fnd_msg_pub.ADD;

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:
725: --

Line 767: FND_MSG_PUB.Count_And_Get

763: IF FND_API.To_Boolean( p_commit ) THEN
764: COMMIT WORK;
765: END IF;
766: -- Standard call to get message count and if count is 1, get message info.
767: FND_MSG_PUB.Count_And_Get
768: (p_count => x_msg_count ,
769: p_data => x_msg_data ,
770: p_encoded => FND_API.G_FALSE );
771: EXCEPTION

Line 775: FND_MSG_PUB.Count_And_Get

771: EXCEPTION
772: WHEN FND_API.G_EXC_ERROR THEN
773: ROLLBACK TO update_column_pvt;
774: x_return_status := FND_API.G_RET_STS_ERROR ;
775: FND_MSG_PUB.Count_And_Get
776: (p_count => x_msg_count ,
777: p_data => x_msg_data ,
778: p_encoded => FND_API.G_FALSE );
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 782: FND_MSG_PUB.Count_And_Get

778: p_encoded => FND_API.G_FALSE );
779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
780: ROLLBACK TO update_column_pvt;
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
782: FND_MSG_PUB.Count_And_Get
783: (p_count => x_msg_count ,
784: p_data => x_msg_data ,
785: p_encoded => FND_API.G_FALSE );
786: WHEN OTHERS THEN

Line 789: IF FND_MSG_PUB.Check_Msg_Level

785: p_encoded => FND_API.G_FALSE );
786: WHEN OTHERS THEN
787: ROLLBACK TO update_column_pvt;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
789: IF FND_MSG_PUB.Check_Msg_Level
790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg
793: (G_PKG_NAME ,

Line 790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

786: WHEN OTHERS THEN
787: ROLLBACK TO update_column_pvt;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
789: IF FND_MSG_PUB.Check_Msg_Level
790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg
793: (G_PKG_NAME ,
794: l_api_name );

Line 792: FND_MSG_PUB.Add_Exc_Msg

788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
789: IF FND_MSG_PUB.Check_Msg_Level
790: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
791: THEN
792: FND_MSG_PUB.Add_Exc_Msg
793: (G_PKG_NAME ,
794: l_api_name );
795: END IF;
796: FND_MSG_PUB.Count_And_Get

Line 796: FND_MSG_PUB.Count_And_Get

792: FND_MSG_PUB.Add_Exc_Msg
793: (G_PKG_NAME ,
794: l_api_name );
795: END IF;
796: FND_MSG_PUB.Count_And_Get
797: (p_count => x_msg_count ,
798: p_data => x_msg_data ,
799: p_encoded => FND_API.G_FALSE );
800: END Update_Column;

Line 916: FND_MSG_PUB.initialize;

912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
913: END IF;
914: -- Initialize message list if p_init_msg_list is set to TRUE.
915: IF FND_API.to_Boolean( p_init_msg_list ) THEN
916: FND_MSG_PUB.initialize;
917: END IF;
918: -- Initialize API return status to success
919: x_return_status := FND_API.G_RET_STS_SUCCESS;
920: -- API body

Line 934: fnd_msg_pub.ADD;

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:
938: OPEN l_col_data_csr;

Line 1004: FND_MSG_PUB.Count_And_Get

1000: IF FND_API.To_Boolean( p_commit ) THEN
1001: COMMIT WORK;
1002: END IF;
1003: -- Standard call to get message count and if count is 1, get message info.
1004: FND_MSG_PUB.Count_And_Get
1005: (p_count => x_msg_count ,
1006: p_data => x_msg_data ,
1007: p_encoded => FND_API.G_FALSE );
1008: EXCEPTION

Line 1012: FND_MSG_PUB.Count_And_Get

1008: EXCEPTION
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: ROLLBACK TO insert_column_pvt;
1011: x_return_status := FND_API.G_RET_STS_ERROR ;
1012: FND_MSG_PUB.Count_And_Get
1013: (p_count => x_msg_count ,
1014: p_data => x_msg_data ,
1015: p_encoded => FND_API.G_FALSE );
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1019: FND_MSG_PUB.Count_And_Get

1015: p_encoded => FND_API.G_FALSE );
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: ROLLBACK TO insert_column_pvt;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1019: FND_MSG_PUB.Count_And_Get
1020: (p_count => x_msg_count ,
1021: p_data => x_msg_data ,
1022: p_encoded => FND_API.G_FALSE );
1023: WHEN OTHERS THEN

Line 1026: IF FND_MSG_PUB.Check_Msg_Level

1022: p_encoded => FND_API.G_FALSE );
1023: WHEN OTHERS THEN
1024: ROLLBACK TO insert_column_pvt;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026: IF FND_MSG_PUB.Check_Msg_Level
1027: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg
1030: (G_PKG_NAME ,

Line 1027: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1023: WHEN OTHERS THEN
1024: ROLLBACK TO insert_column_pvt;
1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026: IF FND_MSG_PUB.Check_Msg_Level
1027: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg
1030: (G_PKG_NAME ,
1031: l_api_name );

Line 1029: FND_MSG_PUB.Add_Exc_Msg

1025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1026: IF FND_MSG_PUB.Check_Msg_Level
1027: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1028: THEN
1029: FND_MSG_PUB.Add_Exc_Msg
1030: (G_PKG_NAME ,
1031: l_api_name );
1032: END IF;
1033: FND_MSG_PUB.Count_And_Get

Line 1033: FND_MSG_PUB.Count_And_Get

1029: FND_MSG_PUB.Add_Exc_Msg
1030: (G_PKG_NAME ,
1031: l_api_name );
1032: END IF;
1033: FND_MSG_PUB.Count_And_Get
1034: (p_count => x_msg_count ,
1035: p_data => x_msg_data ,
1036: p_encoded => FND_API.G_FALSE );
1037: END Insert_Column;

Line 1113: FND_MSG_PUB.initialize;

1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: END IF;
1111: -- Initialize message list if p_init_msg_list is set to TRUE.
1112: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1113: FND_MSG_PUB.initialize;
1114: END IF;
1115: -- Initialize API return status to success
1116: x_return_status := FND_API.G_RET_STS_SUCCESS;
1117: -- API body

Line 1124: fnd_msg_pub.ADD;

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:
1128: DELETE FROM cn_obj_columns_v

Line 1138: FND_MSG_PUB.Count_And_Get

1134: IF FND_API.To_Boolean( p_commit ) THEN
1135: COMMIT WORK;
1136: END IF;
1137: -- Standard call to get message count and if count is 1, get message info.
1138: FND_MSG_PUB.Count_And_Get
1139: (p_count => x_msg_count ,
1140: p_data => x_msg_data ,
1141: p_encoded => FND_API.G_FALSE );
1142: EXCEPTION

Line 1146: FND_MSG_PUB.Count_And_Get

1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: ROLLBACK TO delete_column_pvt;
1145: x_return_status := FND_API.G_RET_STS_ERROR ;
1146: FND_MSG_PUB.Count_And_Get
1147: (p_count => x_msg_count ,
1148: p_data => x_msg_data ,
1149: p_encoded => FND_API.G_FALSE );
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1153: FND_MSG_PUB.Count_And_Get

1149: p_encoded => FND_API.G_FALSE );
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: ROLLBACK TO delete_column_pvt;
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1153: FND_MSG_PUB.Count_And_Get
1154: (p_count => x_msg_count ,
1155: p_data => x_msg_data ,
1156: p_encoded => FND_API.G_FALSE );
1157: WHEN OTHERS THEN

Line 1160: IF FND_MSG_PUB.Check_Msg_Level

1156: p_encoded => FND_API.G_FALSE );
1157: WHEN OTHERS THEN
1158: ROLLBACK TO delete_column_pvt;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: IF FND_MSG_PUB.Check_Msg_Level
1161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg
1164: (G_PKG_NAME ,

Line 1161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1157: WHEN OTHERS THEN
1158: ROLLBACK TO delete_column_pvt;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: IF FND_MSG_PUB.Check_Msg_Level
1161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg
1164: (G_PKG_NAME ,
1165: l_api_name );

Line 1163: FND_MSG_PUB.Add_Exc_Msg

1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1160: IF FND_MSG_PUB.Check_Msg_Level
1161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1162: THEN
1163: FND_MSG_PUB.Add_Exc_Msg
1164: (G_PKG_NAME ,
1165: l_api_name );
1166: END IF;
1167: FND_MSG_PUB.Count_And_Get

Line 1167: FND_MSG_PUB.Count_And_Get

1163: FND_MSG_PUB.Add_Exc_Msg
1164: (G_PKG_NAME ,
1165: l_api_name );
1166: END IF;
1167: FND_MSG_PUB.Count_And_Get
1168: (p_count => x_msg_count ,
1169: p_data => x_msg_data ,
1170: p_encoded => FND_API.G_FALSE );
1171: END Delete_Column;