DBA Data[Home] [Help]

APPS.BIM_I_SGMT_ACT_FACTS_PKG dependencies on STANDARD

Line 60: -- Standard call to check for call compatibility.

56: END IF;
57:
58: bis_collection_utilities.log('Start of the Segment Activity Facts Program');
59:
60: -- Standard call to check for call compatibility.
61: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
62: p_api_version_number,
63: l_api_name,
64: g_pkg_name) THEN

Line 196: --Standard check of commit

192: RAISE FND_API.g_exc_unexpected_error;
193:
194: END IF;
195:
196: --Standard check of commit
197:
198: IF FND_API.To_Boolean ( p_commit ) THEN
199:
200: COMMIT WORK;

Line 206: -- Standard call to get message count and if count is 1, get message info.

202: END IF;
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: );

Line 217: -- Standard call to get message count and if count=1, get the message

213:
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: );

Line 227: -- Standard call to get message count and if count=1, get the message

223:
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: );

Line 239: -- Standard call to get message count and if count=1, get the message

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,
242: p_data => x_msg_data
243: );

Line 371: -- Standard call to check for call compatibility.

367:
368: bis_collection_utilities.log('Populated source_name column in source_query_safb table');
369:
370:
371: -- Standard call to check for call compatibility.
372: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
373: p_api_version_number,
374: l_api_name,
375: g_pkg_name)

Line 484: -- Standard call to get message count and if count=1, get the message

480:
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

Line 498: -- Standard call to get message count and if count=1, get the message

494:
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

Line 517: -- Standard call to get message count and if count=1, get the message

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 (
519: -- p_encoded => FND_API.G_FALSE,
520: p_count => x_msg_count,
521: p_data => x_msg_data

Line 652: -- Standard call to check for call compatibility.

648: CLOSE c_query_source;
649:
650: bis_collection_utilities.log('Populated source_name column in source_query_safb table');
651:
652: -- Standard call to check for call compatibility.
653: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
654: p_api_version_number,
655: l_api_name,
656: g_pkg_name)

Line 756: -- Standard call to get message count and if count=1, get the message

752:
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

Line 770: -- Standard call to get message count and if count=1, get the message

766:
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

Line 789: -- Standard call to get message count and if count=1, get the message

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 (
791: -- p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data