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 37: fnd_msg_pub.ADD;

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

Line 48: fnd_msg_pub.ADD;

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:

Line 57: fnd_msg_pub.ADD;

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

Line 137: FND_MSG_PUB.initialize;

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

Line 201: FND_MSG_PUB.Count_And_Get

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

Line 209: FND_MSG_PUB.Count_And_Get

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

Line 216: FND_MSG_PUB.Count_And_Get

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

Line 223: IF FND_MSG_PUB.Check_Msg_Level

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

Line 224: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 226: FND_MSG_PUB.Add_Exc_Msg

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

Line 230: FND_MSG_PUB.Count_And_Get

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

Line 311: FND_MSG_PUB.initialize;

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

Line 319: fnd_msg_pub.ADD;

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

Line 336: fnd_msg_pub.ADD;

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

Line 375: FND_MSG_PUB.Count_And_Get

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

Line 383: FND_MSG_PUB.Count_And_Get

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

Line 390: FND_MSG_PUB.Count_And_Get

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

Line 397: IF FND_MSG_PUB.Check_Msg_Level

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

Line 398: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 400: FND_MSG_PUB.Add_Exc_Msg

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

Line 404: FND_MSG_PUB.Count_And_Get

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

Line 477: FND_MSG_PUB.initialize;

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

Line 484: fnd_msg_pub.ADD;

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

Line 509: fnd_msg_pub.ADD;

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

Line 531: FND_MSG_PUB.Count_And_Get

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

Line 539: FND_MSG_PUB.Count_And_Get

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

Line 546: FND_MSG_PUB.Count_And_Get

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

Line 553: IF FND_MSG_PUB.Check_Msg_Level

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

Line 554: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 556: FND_MSG_PUB.Add_Exc_Msg

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

Line 560: FND_MSG_PUB.Count_And_Get

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

Line 675: FND_MSG_PUB.initialize;

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

Line 683: fnd_msg_pub.ADD;

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

Line 701: fnd_msg_pub.ADD;

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:

Line 710: fnd_msg_pub.ADD;

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

Line 722: fnd_msg_pub.ADD;

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

Line 768: FND_MSG_PUB.Count_And_Get

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

Line 776: FND_MSG_PUB.Count_And_Get

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

Line 783: FND_MSG_PUB.Count_And_Get

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

Line 790: IF FND_MSG_PUB.Check_Msg_Level

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

Line 791: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 793: FND_MSG_PUB.Add_Exc_Msg

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

Line 797: FND_MSG_PUB.Count_And_Get

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

Line 919: FND_MSG_PUB.initialize;

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

Line 937: fnd_msg_pub.ADD;

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

Line 1007: FND_MSG_PUB.Count_And_Get

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

Line 1015: FND_MSG_PUB.Count_And_Get

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

Line 1022: FND_MSG_PUB.Count_And_Get

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

Line 1029: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1030: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1032: FND_MSG_PUB.Add_Exc_Msg

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

Line 1036: FND_MSG_PUB.Count_And_Get

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

Line 1116: FND_MSG_PUB.initialize;

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

Line 1127: fnd_msg_pub.ADD;

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

Line 1141: FND_MSG_PUB.Count_And_Get

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

Line 1149: FND_MSG_PUB.Count_And_Get

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

Line 1156: FND_MSG_PUB.Count_And_Get

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

Line 1163: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1164: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1166: FND_MSG_PUB.Add_Exc_Msg

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

Line 1170: FND_MSG_PUB.Count_And_Get

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