eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BIM_I_SGMT_FACTS_PKG dependencies on FND_API

Line 54: RAISE FND_API.G_EXC_ERROR;

50: BEGIN
51:
52: IF NOT bis_collection_utilities.setup(l_object_name) THEN
53: bis_collection_utilities.log('Object BIM_SGMT_SIZE Not Setup Properly');
54: RAISE FND_API.G_EXC_ERROR;
55: END IF;
56:
57: bis_collection_utilities.log('Start of the Segment Base Summary Program');
58:

Line 60: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

61: p_api_version_number,
62: l_api_name,
63: g_pkg_name) THEN
64:
65: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
66:
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 70: IF FND_API.to_Boolean( p_init_msg_list )

66:
67: END IF;
68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: l_global_date:= bis_common_parameters.get_global_start_date;
76:
77: -- Initialize API return status to SUCCESS
78:
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: --Get last Refresh dates of the program
82:
83: bis_collection_utilities.get_last_refresh_dates(l_object_name,

Line 110: RAISE FND_API.G_EXC_ERROR;

106:
107: IF (p_start_date IS NULL) THEN
108: --i.e the user initiated incremental program request. raise exception and exit
109: bis_collection_utilities.log('Please run the Update Segment First Time Base Summary Concurrent Program before running this');
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: --- Validate Time Dimension Tables
114: fii_time_api.check_missing_date (GREATEST(l_global_date,p_start_date), SYSDATE, l_missing_date);

Line 118: RAISE FND_API.G_EXC_ERROR;

114: fii_time_api.check_missing_date (GREATEST(l_global_date,p_start_date), SYSDATE, l_missing_date);
115:
116: IF (l_missing_date) THEN
117: bis_collection_utilities.log('Time Dimension has atleast one missing date between ' || greatest(l_global_date,p_start_date) || ' and ' || sysdate);
118: RAISE FND_API.G_EXC_ERROR;
119: END IF;
120:
121:
122: l_load_type := 'FIRST_LOAD';

Line 130: ,p_init_msg_list => FND_API.G_FALSE

126:
127: FIRST_LOAD(p_start_date => greatest(l_global_date,p_start_date)
128: ,p_end_date => l_sysdate
129: ,p_api_version_number => l_api_version_number
130: ,p_init_msg_list => FND_API.G_FALSE
131: ,x_msg_count => x_msg_count
132: ,x_msg_data => x_msg_data
133: ,x_return_status => x_return_status
134: );

Line 147: ,p_init_msg_list => FND_API.G_FALSE

143:
144: FIRST_LOAD(p_start_date => greatest(l_global_date,p_start_date)
145: ,p_end_date => l_sysdate
146: ,p_api_version_number => l_api_version_number
147: ,p_init_msg_list => FND_API.G_FALSE
148: ,x_msg_count => x_msg_count
149: ,x_msg_data => x_msg_data
150: ,x_return_status => x_return_status
151: );

Line 163: RAISE FND_API.G_EXC_ERROR;

159:
160: IF l_year_start_date IS NULL THEN
161:
162: bis_collection_utilities.log('Time Dimension Not Defined Till '||l_end_date );
163: RAISE FND_API.G_EXC_ERROR;
164:
165: END IF;
166:
167: fii_time_api.check_missing_date (l_year_start_date, sysdate, l_missing_date);

Line 173: RAISE FND_API.G_EXC_ERROR;

169: IF (l_missing_date) THEN
170:
171: --Check it from the year start Date of the Year Passed as used in Active Customer Count
172: bis_collection_utilities.log('Time Dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
173: RAISE FND_API.G_EXC_ERROR;
174:
175: END IF;
176:
177: l_load_type := 'SUBSEQUENT_LOAD';

Line 185: ,p_init_msg_list => FND_API.G_FALSE

181: INCREMENTAL_LOAD(p_start_date => l_end_date +1/86400 -- add one second
182: ,p_end_date => l_sysdate
183: ,p_year_start_date =>l_year_start_date
184: ,p_api_version_number => l_api_version_number
185: ,p_init_msg_list => FND_API.G_FALSE
186: ,x_msg_count => x_msg_count
187: ,x_msg_data => x_msg_data
188: ,x_return_status => x_return_status
189: );

Line 194: IF x_return_status = FND_API.g_ret_sts_error THEN

190: END IF;
191:
192: END IF;
193:
194: IF x_return_status = FND_API.g_ret_sts_error THEN
195:
196: RAISE FND_API.g_exc_error;
197:
198: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 196: RAISE FND_API.g_exc_error;

192: END IF;
193:
194: IF x_return_status = FND_API.g_ret_sts_error THEN
195:
196: RAISE FND_API.g_exc_error;
197:
198: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
199:
200: RAISE FND_API.g_exc_unexpected_error;

Line 198: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

194: IF x_return_status = FND_API.g_ret_sts_error THEN
195:
196: RAISE FND_API.g_exc_error;
197:
198: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
199:
200: RAISE FND_API.g_exc_unexpected_error;
201:
202: END IF;

Line 200: RAISE FND_API.g_exc_unexpected_error;

196: RAISE FND_API.g_exc_error;
197:
198: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
199:
200: RAISE FND_API.g_exc_unexpected_error;
201:
202: END IF;
203:
204: --Standard check of commit

Line 206: IF FND_API.To_Boolean ( p_commit ) THEN

202: END IF;
203:
204: --Standard check of commit
205:
206: IF FND_API.To_Boolean ( p_commit ) THEN
207:
208: COMMIT WORK;
209:
210: END IF;

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219: );
220:
221: EXCEPTION
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 (

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: EXCEPTION
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

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: p_data => x_msg_data
230: );
231:
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 (

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

239: p_data => x_msg_data
240: );
241:
242: WHEN OTHERS THEN
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 381: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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)
385: THEN

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382: p_api_version_number,
383: l_api_name,
384: g_pkg_name)
385: THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388:
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF fnd_api.to_boolean( p_init_msg_list ) THEN

Line 390: IF fnd_api.to_boolean( p_init_msg_list ) THEN

386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388:
389: -- Initialize message list if p_init_msg_list is set to TRUE.
390: IF fnd_api.to_boolean( p_init_msg_list ) THEN
391:
392: FND_msg_PUB.initialize;
393:
394: END IF;

Line 397: x_return_status := FND_API.G_RET_STS_SUCCESS;

393:
394: END IF;
395:
396: -- Initialize API return status to SUCCESS
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: bis_collection_utilities.log('Running Initial Load of Segment Facts');
400: ---populating Segment Size
401: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);

Line 624: WHEN FND_API.G_EXC_ERROR THEN

620: );
621:
622: EXCEPTION
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 (

Line 625: x_return_status := FND_API.G_RET_STS_ERROR;

621:
622: EXCEPTION
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,

Line 629: -- p_encoded => FND_API.G_FALSE,

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
632: );
633:

Line 636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

632: );
633:
634: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637:
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: Execute immediate 'DROP TABLE source_query_sgfb';
640:

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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 (

Line 643: --p_encoded => FND_API.G_FALSE,

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
646: );
647:

Line 652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

648: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
649:
650: WHEN OTHERS THEN
651:
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: Execute immediate 'DROP TABLE source_query_sgfb';
654:
655:
656: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)

Line 663: -- p_encoded => FND_API.G_FALSE,

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
666: );
667:

Line 794: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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)
798: THEN

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: p_api_version_number,
796: l_api_name,
797: g_pkg_name)
798: THEN
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 803: IF FND_API.to_Boolean( p_init_msg_list ) THEN

799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: -- Initialize message list if p_init_msg_list is set to TRUE.
803: IF FND_API.to_Boolean( p_init_msg_list ) THEN
804:
805: FND_msg_PUB.initialize;
806:
807: END IF;

Line 810: x_return_status := FND_API.G_RET_STS_SUCCESS;

806:
807: END IF;
808:
809: -- Initialize API return status to SUCCESS
810: x_return_status := FND_API.G_RET_STS_SUCCESS;
811:
812: bis_collection_utilities.log('Running Incremental Load of Segment Facts');
813:
814:

Line 1020: WHEN FND_API.G_EXC_ERROR THEN

1016: /***************************************************************/
1017:
1018: EXCEPTION
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 (

Line 1021: x_return_status := FND_API.G_RET_STS_ERROR;

1017:
1018: EXCEPTION
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,

Line 1025: -- p_encoded => FND_API.G_FALSE,

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
1028: );
1029:

Line 1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1028: );
1029:
1030: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1031:
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1033:
1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1035: Execute Immediate 'DROP TABLE source_query_sgfb';
1036:

Line 1034: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1030: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1031:
1032: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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 (

Line 1039: --p_encoded => FND_API.G_FALSE,

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
1042: );
1043:

Line 1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1044: bis_collection_utilities.log('BIM_I_SGMT_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1045:
1046: WHEN OTHERS THEN
1047:
1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: Execute immediate 'DROP TABLE source_query_sgfb';
1050:
1051: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1052: THEN

Line 1058: -- p_encoded => FND_API.G_FALSE,

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
1061: );
1062: