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_CALC_EXT_TABLES_PVT dependencies on FND_MSG_PUB

Line 100: FND_MSG_PUB.initialize;

96:
97: -- Initialize message list if p_init_msg_list is set to TRUE.
98: IF FND_API.to_Boolean( p_init_msg_list )
99: THEN
100: FND_MSG_PUB.initialize;
101: END IF;
102:
103: -- Initialize API return status to success
104: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

136: RAISE fnd_api.g_exc_error;
137: END IF;
138:
139: if p_calc_ext_table_rec.internal_table_id = 0 THEN
140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
141: THEN
142: fnd_message.set_name('CN', 'CN_INTERNAL_TABLE_NOT_NULL');
143: fnd_msg_pub.add;
144: END IF;

Line 143: fnd_msg_pub.add;

139: if p_calc_ext_table_rec.internal_table_id = 0 THEN
140: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
141: THEN
142: fnd_message.set_name('CN', 'CN_INTERNAL_TABLE_NOT_NULL');
143: fnd_msg_pub.add;
144: END IF;
145: x_loading_status := 'CN_INTERNAL_TABLE_NOT_NULL';
146: RAISE FND_API.G_EXC_ERROR;
147: END IF;

Line 159: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

155: RAISE fnd_api.g_exc_error;
156: END IF;
157:
158: if p_calc_ext_table_rec.external_table_id = 0 THEN
159: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
160: THEN
161: fnd_message.set_name('CN', 'CN_EXTERNAL_TABLE_NOT_NULL');
162: fnd_msg_pub.add;
163: END IF;

Line 162: fnd_msg_pub.add;

158: if p_calc_ext_table_rec.external_table_id = 0 THEN
159: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
160: THEN
161: fnd_message.set_name('CN', 'CN_EXTERNAL_TABLE_NOT_NULL');
162: fnd_msg_pub.add;
163: END IF;
164: x_loading_status := 'CN_EXTERNAL_TABLE_NOT_NULL';
165: RAISE FND_API.G_EXC_ERROR;
166: END IF;

Line 225: FND_MSG_PUB.Count_And_Get

221: THEN
222: COMMIT WORK;
223: END IF;
224:
225: FND_MSG_PUB.Count_And_Get
226: (
227: p_count => x_msg_count ,
228: p_data => x_msg_data ,
229: p_encoded => FND_API.G_FALSE

Line 235: FND_MSG_PUB.Count_And_Get

231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO Create_Calc_Ext_Table;
234: x_return_status := FND_API.G_RET_STS_ERROR ;
235: FND_MSG_PUB.Count_And_Get
236: (
237: p_count => x_msg_count ,
238: p_data => x_msg_data ,
239: p_encoded => FND_API.G_FALSE

Line 245: FND_MSG_PUB.Count_And_Get

241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: ROLLBACK TO Create_Calc_Ext_Table;
243: x_loading_status := 'UNEXPECTED_ERR';
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: FND_MSG_PUB.Count_And_Get
246: (
247: p_count => x_msg_count ,
248: p_data => x_msg_data ,
249: p_encoded => FND_API.G_FALSE

Line 255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

251: WHEN OTHERS THEN
252: ROLLBACK TO Create_Calc_Ext_Table;
253: x_loading_status := 'UNEXPECTED_ERR';
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
258: END IF;
259: FND_MSG_PUB.Count_And_Get

Line 257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

253: x_loading_status := 'UNEXPECTED_ERR';
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
258: END IF;
259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,

Line 259: FND_MSG_PUB.Count_And_Get

255: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
258: END IF;
259: FND_MSG_PUB.Count_And_Get
260: (
261: p_count => x_msg_count ,
262: p_data => x_msg_data ,
263: p_encoded => FND_API.G_FALSE

Line 375: FND_MSG_PUB.initialize;

371:
372: -- Initialize message list if p_init_msg_list is set to TRUE.
373: IF FND_API.to_Boolean( p_init_msg_list )
374: THEN
375: FND_MSG_PUB.initialize;
376: END IF;
377:
378: -- Initialize API return status to success
379: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 416: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

412: RAISE fnd_api.g_exc_error;
413: END IF ;
414:
415: if p_calc_ext_table_rec.internal_table_id = 0 THEN
416: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
417: THEN
418: fnd_message.set_name('CN', 'CN_INTERNAL_TABLE_NOT_NULL');
419: fnd_msg_pub.add;
420: END IF;

Line 419: fnd_msg_pub.add;

415: if p_calc_ext_table_rec.internal_table_id = 0 THEN
416: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
417: THEN
418: fnd_message.set_name('CN', 'CN_INTERNAL_TABLE_NOT_NULL');
419: fnd_msg_pub.add;
420: END IF;
421: x_loading_status := 'CN_INTERNAL_TABLE_NOT_NULL';
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;

Line 444: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

440: RAISE fnd_api.g_exc_error;
441: END IF;
442:
443: if p_calc_ext_table_rec.external_table_id = 0 THEN
444: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
445: THEN
446: fnd_message.set_name('CN', 'CN_EXTERNAL_TABLE_NOT_NULL');
447: fnd_msg_pub.add;
448: END IF;

Line 447: fnd_msg_pub.add;

443: if p_calc_ext_table_rec.external_table_id = 0 THEN
444: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
445: THEN
446: fnd_message.set_name('CN', 'CN_EXTERNAL_TABLE_NOT_NULL');
447: fnd_msg_pub.add;
448: END IF;
449: x_loading_status := 'CN_EXTERNAL_TABLE_NOT_NULL';
450: RAISE FND_API.G_EXC_ERROR;
451: END IF;

Line 489: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

485: fetch get_dtl_curs into l_col_found;
486: close get_dtl_curs;
487:
488: if l_col_found = 1 THEN
489: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
490: THEN
491: fnd_message.set_name('CN', 'CN_EXT_UPDATE_NOT_ALLOWED');
492: fnd_msg_pub.add;
493: END IF;

Line 492: fnd_msg_pub.add;

488: if l_col_found = 1 THEN
489: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
490: THEN
491: fnd_message.set_name('CN', 'CN_EXT_UPDATE_NOT_ALLOWED');
492: fnd_msg_pub.add;
493: END IF;
494: x_loading_status := 'CN_EXT_UPDATE_NOT_ALLOWED';
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;

Line 524: FND_MSG_PUB.Count_And_Get

520: END IF;
521:
522:
523: -- Standard call to get message count and if count is 1, get message info.
524: FND_MSG_PUB.Count_And_Get
525: (
526: p_count => x_msg_count ,
527: p_data => x_msg_data ,
528: p_encoded => FND_API.G_FALSE

Line 536: FND_MSG_PUB.Count_And_Get

532: WHEN FND_API.G_EXC_ERROR THEN
533: ROLLBACK TO Update_CALC_EXT_TABLES;
534: x_return_status := FND_API.G_RET_STS_ERROR ;
535:
536: FND_MSG_PUB.Count_And_Get
537: (
538: p_count => x_msg_count ,
539: p_data => x_msg_data ,
540: p_encoded => FND_API.G_FALSE

Line 546: FND_MSG_PUB.Count_And_Get

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

Line 556: IF FND_MSG_PUB.Check_Msg_Level

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

Line 557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

553: WHEN OTHERS THEN
554: ROLLBACK TO Update_CALC_EXT_TABLES;
555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: IF FND_MSG_PUB.Check_Msg_Level
557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
558: THEN
559: FND_MSG_PUB.Add_Exc_Msg
560: (G_PKG_NAME,
561: l_api_name

Line 559: FND_MSG_PUB.Add_Exc_Msg

555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
556: IF FND_MSG_PUB.Check_Msg_Level
557: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
558: THEN
559: FND_MSG_PUB.Add_Exc_Msg
560: (G_PKG_NAME,
561: l_api_name
562: );
563: END IF;

Line 565: FND_MSG_PUB.Count_And_Get

561: l_api_name
562: );
563: END IF;
564:
565: FND_MSG_PUB.Count_And_Get
566: (
567: p_count => x_msg_count ,
568: p_data => x_msg_data ,
569: p_encoded => FND_API.G_FALSE

Line 645: FND_MSG_PUB.initialize;

641:
642: -- Initialize message list if p_init_msg_list is set to TRUE.
643: IF FND_API.to_Boolean( p_init_msg_list )
644: THEN
645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to success
649: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 660: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)

656: fetch get_col into l_count;
657: close get_col;
658:
659: IF l_count > 0 THEN
660: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
661: THEN
662: fnd_message.set_name('CN', 'CN_COLUMN_EXISTS');
663: fnd_msg_pub.add;
664: END IF;

Line 663: fnd_msg_pub.add;

659: IF l_count > 0 THEN
660: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
661: THEN
662: fnd_message.set_name('CN', 'CN_COLUMN_EXISTS');
663: fnd_msg_pub.add;
664: END IF;
665: x_loading_status := 'CN_COLUMN_EXISTS';
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;

Line 681: FND_MSG_PUB.Count_And_Get

677: COMMIT WORK;
678: END IF;
679:
680: -- Standard call to get message count and if count is 1, get message info.
681: FND_MSG_PUB.Count_And_Get
682: (
683: p_count => x_msg_count ,
684: p_data => x_msg_data ,
685: p_encoded => FND_API.G_FALSE

Line 692: FND_MSG_PUB.Count_And_Get

688: EXCEPTION
689: WHEN FND_API.G_EXC_ERROR THEN
690: ROLLBACK TO Delete_CALC_EXT_TABLES;
691: x_return_status := FND_API.G_RET_STS_ERROR ;
692: FND_MSG_PUB.Count_And_Get
693: (
694: p_count => x_msg_count ,
695: p_data => x_msg_data ,
696: p_encoded => FND_API.G_FALSE

Line 703: FND_MSG_PUB.Count_And_Get

699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: ROLLBACK TO Delete_CALC_EXT_TABLES;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
702:
703: FND_MSG_PUB.Count_And_Get
704: (
705: p_count => x_msg_count ,
706: p_data => x_msg_data ,
707: p_encoded => FND_API.G_FALSE

Line 713: IF FND_MSG_PUB.Check_Msg_Level

709:
710: WHEN OTHERS THEN
711: ROLLBACK TO Delete_CALC_EXT_TABLES;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: IF FND_MSG_PUB.Check_Msg_Level
714: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg
717: (G_PKG_NAME,

Line 714: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

710: WHEN OTHERS THEN
711: ROLLBACK TO Delete_CALC_EXT_TABLES;
712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: IF FND_MSG_PUB.Check_Msg_Level
714: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg
717: (G_PKG_NAME,
718: l_api_name

Line 716: FND_MSG_PUB.Add_Exc_Msg

712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
713: IF FND_MSG_PUB.Check_Msg_Level
714: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
715: THEN
716: FND_MSG_PUB.Add_Exc_Msg
717: (G_PKG_NAME,
718: l_api_name
719: );
720: END IF;

Line 722: FND_MSG_PUB.Count_And_Get

718: l_api_name
719: );
720: END IF;
721:
722: FND_MSG_PUB.Count_And_Get
723: (
724: p_count => x_msg_count ,
725: p_data => x_msg_data ,
726: p_encoded => FND_API.G_FALSE