[Home] [Help]
54: END IF;
55:
56: bis_collection_utilities.log('Start of the Segment Customer Facts Program');
57:
58: -- Standard call to check for call compatibility.
59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
60: p_api_version_number,
61: l_api_name,
62: g_pkg_name) THEN
191: RAISE FND_API.g_exc_unexpected_error;
192:
193: END IF;
194:
195: --Standard check of commit
196:
197: IF FND_API.To_Boolean ( p_commit ) THEN
198:
199: COMMIT WORK;
201: END IF;
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: );
212:
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: );
222:
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: );
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,
241: p_data => x_msg_data
242: );
364: END LOOP;
365: CLOSE c_query_source;
366:
367:
368: -- Standard call to check for call compatibility.
369: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
370: p_api_version_number,
371: l_api_name,
372: g_pkg_name)
490:
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
504:
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
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 (
529: -- p_encoded => FND_API.G_FALSE,
530: p_count => x_msg_count,
531: p_data => x_msg_data
659: END LOOP;
660: CLOSE c_query_source;
661:
662:
663: -- Standard call to check for call compatibility.
664: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
665: p_api_version_number,
666: l_api_name,
667: g_pkg_name)
883:
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
897:
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
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 (
922: -- p_encoded => FND_API.G_FALSE,
923: p_count => x_msg_count,
924: p_data => x_msg_data