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.

APPS.BIM_I_SGMT_CUST_FACTS_PKG dependencies on FND_API

Line 53: RAISE FND_API.G_EXC_ERROR;

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

Line 59: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 64: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 72: IF FND_API.to_Boolean( p_init_msg_list )

68: -- Initialize message list if p_init_msg_list is set to TRUE.
69:
70: l_global_date:= bis_common_parameters.get_global_start_date;
71:
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: END IF;
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 Customer Base Summary - Initial Load 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: l_load_type := 'FIRST_LOAD';
122:

Line 129: ,p_init_msg_list => FND_API.G_FALSE

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

Line 146: ,p_init_msg_list => FND_API.G_FALSE

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

Line 162: RAISE FND_API.G_EXC_ERROR;

158: IF (l_missing_date) THEN
159:
160: --Check it from the year start Date of the Year Passed as used in Active Customer Count
161: bis_collection_utilities.log('Time Dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
162: RAISE FND_API.G_EXC_ERROR;
163:
164: END IF;
165:
166: l_load_type := 'SUBSEQUENT_LOAD';

Line 174: ,p_init_msg_list => FND_API.G_FALSE

170:
171: INCREMENTAL_LOAD(p_start_date => l_end_date +1/86400 -- add one second
172: ,p_end_date => l_sysdate
173: ,p_api_version_number => l_api_version_number
174: ,p_init_msg_list => FND_API.G_FALSE
175: ,x_msg_count => x_msg_count
176: ,x_msg_data => x_msg_data
177: ,x_return_status => x_return_status
178: );

Line 185: IF x_return_status = FND_API.g_ret_sts_error THEN

181: END IF;
182:
183: ---If Incremental/Inital Load Executes Sucessfully, then call the Load_Schedule_Data Procedure
184:
185: IF x_return_status = FND_API.g_ret_sts_error THEN
186:
187: RAISE FND_API.g_exc_error;
188:
189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 187: RAISE FND_API.g_exc_error;

183: ---If Incremental/Inital Load Executes Sucessfully, then call the Load_Schedule_Data Procedure
184:
185: IF x_return_status = FND_API.g_ret_sts_error THEN
186:
187: RAISE FND_API.g_exc_error;
188:
189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
190:
191: RAISE FND_API.g_exc_unexpected_error;

Line 189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

185: IF x_return_status = FND_API.g_ret_sts_error THEN
186:
187: RAISE FND_API.g_exc_error;
188:
189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
190:
191: RAISE FND_API.g_exc_unexpected_error;
192:
193: END IF;

Line 191: RAISE FND_API.g_exc_unexpected_error;

187: RAISE FND_API.g_exc_error;
188:
189: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
190:
191: RAISE FND_API.g_exc_unexpected_error;
192:
193: END IF;
194:
195: --Standard check of commit

Line 197: IF FND_API.To_Boolean ( p_commit ) THEN

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

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: );
210:
211: EXCEPTION
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 (

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

219: p_data => x_msg_data
220: );
221:
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 (

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

229: p_data => x_msg_data
230: );
231:
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 369: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

370: p_api_version_number,
371: l_api_name,
372: g_pkg_name)
373: THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF fnd_api.to_boolean( p_init_msg_list ) THEN

Line 378: IF fnd_api.to_boolean( p_init_msg_list ) THEN

374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377: -- Initialize message list if p_init_msg_list is set to TRUE.
378: IF fnd_api.to_boolean( p_init_msg_list ) THEN
379:
380: FND_msg_PUB.initialize;
381:
382: END IF;

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381:
382: END IF;
383:
384: -- Initialize API return status to SUCCESS
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: bis_collection_utilities.log('Running Initial Load of Segment Customer Facts');
388:
389: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);

Line 491: WHEN FND_API.G_EXC_ERROR THEN

487: /***************************************************************/
488:
489: EXCEPTION
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 (

Line 492: x_return_status := FND_API.G_RET_STS_ERROR;

488:
489: EXCEPTION
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,

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

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
499: );
500:

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

499: );
500:
501: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504:
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: Execute Immediate 'DROP TABLE source_query_scfb';
507:

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

501: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
502:
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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 (

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

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
513: );
514:

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

515: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG : FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
516:
517: WHEN OTHERS THEN
518:
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
520: Execute Immediate 'DROP TABLE source_query_scfb';
521:
522: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
523: THEN

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

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
532: );
533:

Line 664: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

665: p_api_version_number,
666: l_api_name,
667: g_pkg_name)
668: THEN
669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 673: IF FND_API.to_Boolean( p_init_msg_list ) THEN

669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
670: END IF;
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean( p_init_msg_list ) THEN
674:
675: FND_msg_PUB.initialize;
676:
677: END IF;

Line 680: x_return_status := FND_API.G_RET_STS_SUCCESS;

676:
677: END IF;
678:
679: -- Initialize API return status to SUCCESS
680: x_return_status := FND_API.G_RET_STS_SUCCESS;
681:
682:
683: bis_collection_utilities.log('Running Incremental Load of Segment Customer Facts');
684:

Line 884: WHEN FND_API.G_EXC_ERROR THEN

880: COMMIT;
881:
882: EXCEPTION
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 (

Line 885: x_return_status := FND_API.G_RET_STS_ERROR;

881:
882: EXCEPTION
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,

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

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
892: );
893:

Line 896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

892: );
893:
894: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
897:
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Execute Immediate 'DROP TABLE source_query_scfb';
900:

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

894: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
895:
896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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 (

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

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
906: );
907:

Line 912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

908: bis_collection_utilities.log('BIM_I_SGMT_CUST_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
909:
910: WHEN OTHERS THEN
911:
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913: Execute immediate 'DROP TABLE source_query_scfb';
914:
915: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
916: THEN

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

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
925: );
926: