[Home] [Help]
55: END IF;
56:
57: bis_collection_utilities.log('Start of the Segment Base Summary Program');
58:
59: -- Standard call to check for call compatibility.
60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
61: p_api_version_number,
62: l_api_name,
63: g_pkg_name) THEN
200: RAISE FND_API.g_exc_unexpected_error;
201:
202: END IF;
203:
204: --Standard check of commit
205:
206: IF FND_API.To_Boolean ( p_commit ) THEN
207:
208: COMMIT WORK;
211:
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: );
222:
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: );
232:
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: );
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,
251: p_data => x_msg_data
252: );
376: END LOOP;
377: CLOSE c_query_source;
378:
379:
380: -- Standard call to check for call compatibility.
381: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
382: p_api_version_number,
383: l_api_name,
384: g_pkg_name)
623:
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
637:
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
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 (
663: -- p_encoded => FND_API.G_FALSE,
664: p_count => x_msg_count,
665: p_data => x_msg_data
789: l_sql_id := NULL;
790: END LOOP;
791: CLOSE c_query_source;
792:
793: -- Standard call to check for call compatibility.
794: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
795: p_api_version_number,
796: l_api_name,
797: g_pkg_name)
1019:
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
1033:
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
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 (
1058: -- p_encoded => FND_API.G_FALSE,
1059: p_count => x_msg_count,
1060: p_data => x_msg_data