70: l_global_date:= bis_common_parameters.get_global_start_date;
71:
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Initialize API return status to SUCCESS
78:
202:
203: bis_collection_utilities.log('Successful Completion of Segment Customer Facts Program');
204:
205: -- Standard call to get message count and if count is 1, get message info.
206: FND_MSG_PUB.Count_And_Get
207: (p_count => x_msg_count,
208: p_data => x_msg_data
209: );
210:
213: WHEN FND_API.G_EXC_ERROR THEN
214:
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: -- Standard call to get message count and if count=1, get the message
217: FND_msg_PUB.Count_And_Get (
218: p_count => x_msg_count,
219: p_data => x_msg_data
220: );
221:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224:
225: x_return_status := FND_API.G_RET_STS_UNEXP_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:
230: );
231:
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
235: THEN
236: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
235: THEN
236: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_msg_PUB.Count_And_Get (
240: p_count => x_msg_count,
235: THEN
236: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_msg_PUB.Count_And_Get (
240: p_count => x_msg_count,
241: p_data => x_msg_data
242: );
243:
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF fnd_api.to_boolean( p_init_msg_list ) THEN
379:
380: FND_msg_PUB.initialize;
381:
382: END IF;
383:
384: -- Initialize API return status to SUCCESS
491: WHEN FND_API.G_EXC_ERROR THEN
492: x_return_status := FND_API.G_RET_STS_ERROR;
493: Execute Immediate 'DROP TABLE source_query_scfb';
494: -- Standard call to get message count and if count=1, get the message
495: FND_msg_PUB.Count_And_Get (
496: -- p_encoded => FND_API.G_FALSE,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: Execute Immediate 'DROP TABLE source_query_scfb';
507:
508: -- Standard call to get message count and if count=1, get the message
509: FND_msg_PUB.Count_And_Get (
510: --p_encoded => FND_API.G_FALSE,
511: p_count => x_msg_count,
512: p_data => x_msg_data
513: );
518:
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: Execute Immediate 'DROP TABLE source_query_scfb';
521:
522: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
523: THEN
524: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
525: END IF;
526:
520: Execute Immediate 'DROP TABLE source_query_scfb';
521:
522: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
523: THEN
524: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
525: END IF;
526:
527: -- Standard call to get message count and if count=1, get the message
528: FND_msg_PUB.Count_And_Get (
524: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
525: END IF;
526:
527: -- Standard call to get message count and if count=1, get the message
528: FND_msg_PUB.Count_And_Get (
529: -- p_encoded => FND_API.G_FALSE,
530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
671:
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:
675: FND_msg_PUB.initialize;
676:
677: END IF;
678:
679: -- Initialize API return status to SUCCESS
884: WHEN FND_API.G_EXC_ERROR THEN
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: Execute Immediate 'DROP TABLE source_query_scfb';
887: -- Standard call to get message count and if count=1, get the message
888: FND_msg_PUB.Count_And_Get (
889: -- p_encoded => FND_API.G_FALSE,
890: p_count => x_msg_count,
891: p_data => x_msg_data
892: );
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Execute Immediate 'DROP TABLE source_query_scfb';
900:
901: -- Standard call to get message count and if count=1, get the message
902: FND_msg_PUB.Count_And_Get (
903: --p_encoded => FND_API.G_FALSE,
904: p_count => x_msg_count,
905: p_data => x_msg_data
906: );
911:
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: Execute immediate 'DROP TABLE source_query_scfb';
914:
915: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
916: THEN
917: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
918: END IF;
919:
913: Execute immediate 'DROP TABLE source_query_scfb';
914:
915: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
916: THEN
917: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
918: END IF;
919:
920: -- Standard call to get message count and if count=1, get the message
921: FND_msg_PUB.Count_And_Get (
917: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
918: END IF;
919:
920: -- Standard call to get message count and if count=1, get the message
921: FND_msg_PUB.Count_And_Get (
922: -- p_encoded => FND_API.G_FALSE,
923: p_count => x_msg_count,
924: p_data => x_msg_data
925: );