69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean( p_init_msg_list )
72: THEN
73: FND_MSG_PUB.initialize;
74: END IF;
75:
76: l_global_date:= bis_common_parameters.get_global_start_date;
77:
203:
204: bis_collection_utilities.log('Successful Completion of Segment Activity Facts Program');
205:
206: -- Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: (p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:
214: WHEN FND_API.G_EXC_ERROR THEN
215:
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: -- Standard call to get message count and if count=1, get the message
218: FND_msg_PUB.Count_And_Get (
219: p_count => x_msg_count,
220: p_data => x_msg_data
221: );
222:
224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225:
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: -- Standard call to get message count and if count=1, get the message
228: FND_msg_PUB.Count_And_Get (
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232:
231: );
232:
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
236: THEN
237: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
236: THEN
237: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message
240: FND_msg_PUB.Count_And_Get (
241: p_count => x_msg_count,
236: THEN
237: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
238: END IF;
239: -- Standard call to get message count and if count=1, get the message
240: FND_msg_PUB.Count_And_Get (
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244:
379:
380: -- Initialize message list if p_init_msg_list is set to TRUE.
381: IF fnd_api.to_boolean( p_init_msg_list ) THEN
382:
383: FND_msg_PUB.initialize;
384:
385: END IF;
386:
387: -- Initialize API return status to SUCCESS
481: WHEN FND_API.G_EXC_ERROR THEN
482: x_return_status := FND_API.G_RET_STS_ERROR;
483: Execute Immediate 'DROP TABLE source_query_safb';
484: -- Standard call to get message count and if count=1, get the message
485: FND_msg_PUB.Count_And_Get (
486: -- p_encoded => FND_API.G_FALSE,
487: p_count => x_msg_count,
488: p_data => x_msg_data
489: );
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496: Execute Immediate 'DROP TABLE source_query_safb';
497:
498: -- Standard call to get message count and if count=1, get the message
499: FND_msg_PUB.Count_And_Get (
500: --p_encoded => FND_API.G_FALSE,
501: p_count => x_msg_count,
502: p_data => x_msg_data
503: );
508:
509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
510: Execute Immediate 'DROP TABLE source_query_safb';
511:
512: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
513: THEN
514: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
515: END IF;
516:
510: Execute Immediate 'DROP TABLE source_query_safb';
511:
512: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
513: THEN
514: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
515: END IF;
516:
517: -- Standard call to get message count and if count=1, get the message
518: FND_msg_PUB.Count_And_Get (
514: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
515: END IF;
516:
517: -- Standard call to get message count and if count=1, get the message
518: FND_msg_PUB.Count_And_Get (
519: -- p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data
522: );
660:
661: -- Initialize message list if p_init_msg_list is set to TRUE.
662: IF FND_API.to_Boolean( p_init_msg_list ) THEN
663:
664: FND_msg_PUB.initialize;
665:
666: END IF;
667:
668: -- Initialize API return status to SUCCESS
753: WHEN FND_API.G_EXC_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_ERROR;
755: Execute Immediate 'DROP TABLE source_query_safb';
756: -- Standard call to get message count and if count=1, get the message
757: FND_msg_PUB.Count_And_Get (
758: -- p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
768: Execute Immediate 'DROP TABLE source_query_safb';
769:
770: -- Standard call to get message count and if count=1, get the message
771: FND_msg_PUB.Count_And_Get (
772: --p_encoded => FND_API.G_FALSE,
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
780:
781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: Execute Immediate 'DROP TABLE source_query_safb';
783:
784: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
785: THEN
786: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
787: END IF;
788:
782: Execute Immediate 'DROP TABLE source_query_safb';
783:
784: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
785: THEN
786: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
787: END IF;
788:
789: -- Standard call to get message count and if count=1, get the message
790: FND_msg_PUB.Count_And_Get (
786: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
787: END IF;
788:
789: -- Standard call to get message count and if count=1, get the message
790: FND_msg_PUB.Count_And_Get (
791: -- p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );