DBA Data[Home] [Help]

APPS.BIM_I_SGMT_FACTS_PKG dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.initialize;

68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: l_global_date:= bis_common_parameters.get_global_start_date;
76:

Line 216: FND_MSG_PUB.Count_And_Get

212:
213: bis_collection_utilities.log('Successful Completion of Segment Base Summary Program');
214:
215: -- Standard call to get message count and if count is 1, get message info.
216: FND_MSG_PUB.Count_And_Get
217: (p_count => x_msg_count,
218: p_data => x_msg_data
219: );
220:

Line 227: FND_msg_PUB.Count_And_Get (

223: WHEN FND_API.G_EXC_ERROR THEN
224:
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_msg_PUB.Count_And_Get (
228: p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231:

Line 237: FND_msg_PUB.Count_And_Get (

233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: -- Standard call to get message count and if count=1, get the message
237: FND_msg_PUB.Count_And_Get (
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:

Line 244: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

240: );
241:
242: WHEN OTHERS THEN
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
245: THEN
246: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message

Line 246: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

242: WHEN OTHERS THEN
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
245: THEN
246: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_msg_PUB.Count_And_Get (
250: p_count => x_msg_count,

Line 249: FND_msg_PUB.Count_And_Get (

245: THEN
246: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_msg_PUB.Count_And_Get (
250: p_count => x_msg_count,
251: p_data => x_msg_data
252: );
253:

Line 392: FND_msg_PUB.initialize;

388:
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF fnd_api.to_boolean( p_init_msg_list ) THEN
391:
392: FND_msg_PUB.initialize;
393:
394: END IF;
395:
396: -- Initialize API return status to SUCCESS

Line 628: FND_msg_PUB.Count_And_Get (

624: WHEN FND_API.G_EXC_ERROR THEN
625: x_return_status := FND_API.G_RET_STS_ERROR;
626: Execute Immediate 'DROP TABLE source_query_sgfb';
627: -- Standard call to get message count and if count=1, get the message
628: FND_msg_PUB.Count_And_Get (
629: -- p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,
631: p_data => x_msg_data
632: );

Line 642: FND_msg_PUB.Count_And_Get (

638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: Execute immediate 'DROP TABLE source_query_sgfb';
640:
641: -- Standard call to get message count and if count=1, get the message
642: FND_msg_PUB.Count_And_Get (
643: --p_encoded => FND_API.G_FALSE,
644: p_count => x_msg_count,
645: p_data => x_msg_data
646: );

Line 656: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: Execute immediate 'DROP TABLE source_query_sgfb';
654:
655:
656: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
657: THEN
658: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
659: END IF;
660:

Line 658: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

654:
655:
656: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
657: THEN
658: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
659: END IF;
660:
661: -- Standard call to get message count and if count=1, get the message
662: FND_msg_PUB.Count_And_Get (

Line 662: FND_msg_PUB.Count_And_Get (

658: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
659: END IF;
660:
661: -- Standard call to get message count and if count=1, get the message
662: FND_msg_PUB.Count_And_Get (
663: -- p_encoded => FND_API.G_FALSE,
664: p_count => x_msg_count,
665: p_data => x_msg_data
666: );

Line 805: FND_msg_PUB.initialize;

801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list ) THEN
804:
805: FND_msg_PUB.initialize;
806:
807: END IF;
808:
809: -- Initialize API return status to SUCCESS

Line 1024: FND_msg_PUB.Count_And_Get (

1020: WHEN FND_API.G_EXC_ERROR THEN
1021: x_return_status := FND_API.G_RET_STS_ERROR;
1022: Execute Immediate 'DROP TABLE source_query_sgfb';
1023: -- Standard call to get message count and if count=1, get the message
1024: FND_msg_PUB.Count_And_Get (
1025: -- p_encoded => FND_API.G_FALSE,
1026: p_count => x_msg_count,
1027: p_data => x_msg_data
1028: );

Line 1038: FND_msg_PUB.Count_And_Get (

1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: Execute Immediate 'DROP TABLE source_query_sgfb';
1036:
1037: -- Standard call to get message count and if count=1, get the message
1038: FND_msg_PUB.Count_And_Get (
1039: --p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data
1042: );

Line 1051: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

1047:
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: Execute immediate 'DROP TABLE source_query_sgfb';
1050:
1051: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1054: END IF;
1055:

Line 1053: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

1049: Execute immediate 'DROP TABLE source_query_sgfb';
1050:
1051: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1054: END IF;
1055:
1056: -- Standard call to get message count and if count=1, get the message
1057: FND_msg_PUB.Count_And_Get (

Line 1057: FND_msg_PUB.Count_And_Get (

1053: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1054: END IF;
1055:
1056: -- Standard call to get message count and if count=1, get the message
1057: FND_msg_PUB.Count_And_Get (
1058: -- p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data
1061: );