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_LEAD_FACTS_PKG dependencies on FND_API

Line 112: RAISE FND_API.G_EXC_ERROR;

108: l_global_date:= bis_common_parameters.get_global_start_date;
109:
110: IF NOT bis_collection_utilities.setup(l_object_name) THEN
111: bis_collection_utilities.log('Object BIM_LEADS Not Setup Properly');
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114: bis_collection_utilities.log('Start of the Lead Facts Program');
115:
116: -- Standard call to check for call compatibility.

Line 117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

113: END IF;
114: bis_collection_utilities.log('Start of the Lead Facts Program');
115:
116: -- Standard call to check for call compatibility.
117: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
118: p_api_version_number,
119: l_api_name,
120: g_pkg_name)
121: THEN

Line 122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

118: p_api_version_number,
119: l_api_name,
120: g_pkg_name)
121: THEN
122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )

Line 126: IF FND_API.to_Boolean( p_init_msg_list )

122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
123: END IF;
124:
125: -- Initialize message list if p_init_msg_list is set to TRUE.
126: IF FND_API.to_Boolean( p_init_msg_list )
127: THEN
128: FND_MSG_PUB.initialize;
129: END IF;
130:

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: FND_MSG_PUB.initialize;
129: END IF;
130:
131: -- Initialize API return status to SUCCESS
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: bis_collection_utilities.get_last_refresh_dates(l_object_name,
135: l_conc_start_date,
136: l_conc_end_date,

Line 143: RAISE FND_API.G_EXC_ERROR;

139: IF (l_end_date IS NULL) THEN
140:
141: IF (p_start_date IS NULL) THEN
142: bis_collection_utilities.log('Please run the Upadate Leads First Time Base Summary concurrent program before running this');
143: RAISE FND_API.G_EXC_ERROR;
144: END IF;
145:
146: --- Validate Time Dimension Tables
147: fii_time_api.check_missing_date (greatest(l_global_date,p_start_date), sysdate, l_missing_date);

Line 150: RAISE FND_API.G_EXC_ERROR;

146: --- Validate Time Dimension Tables
147: fii_time_api.check_missing_date (greatest(l_global_date,p_start_date), sysdate, l_missing_date);
148: IF (l_missing_date) THEN
149: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || greatest(l_global_date,p_start_date) || ' and ' || sysdate);
150: RAISE FND_API.G_EXC_ERROR;
151: END IF;
152:
153:
154: l_load_type := 'FIRST_LOAD';

Line 159: ,p_init_msg_list => FND_API.G_FALSE

155:
156: FIRST_LOAD(p_start_date => greatest(l_global_date,p_start_date)
157: ,p_end_date => sysdate
158: ,p_api_version_number => l_api_version_number
159: ,p_init_msg_list => FND_API.G_FALSE
160: ,x_msg_count => x_msg_count
161: ,x_msg_data => x_msg_data
162: ,x_return_status => x_return_status
163: );

Line 175: ,p_init_msg_list => FND_API.G_FALSE

171:
172: FIRST_LOAD(p_start_date => greatest(l_global_date,p_start_date)
173: ,p_end_date => l_sysdate
174: ,p_api_version_number => l_api_version_number
175: ,p_init_msg_list => FND_API.G_FALSE
176: ,x_msg_count => x_msg_count
177: ,x_msg_data => x_msg_data
178: ,x_return_status => x_return_status
179: );

Line 185: RAISE FND_API.G_EXC_ERROR;

181: --- Validate Time Dimension Tables
182: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);
183: IF (l_missing_date) THEN
184: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187:
188: l_load_type := 'SUBSEQUENT_LOAD';
189:

Line 194: ,p_init_msg_list => FND_API.G_FALSE

190: INCREMENTAL_LOAD(p_start_date => l_end_date +1/86400 -- add one second
191: ,p_end_date => sysdate
192: ,p_global_date =>l_global_date
193: ,p_api_version_number => l_api_version_number
194: ,p_init_msg_list => FND_API.G_FALSE
195: ,x_msg_count => x_msg_count
196: ,x_msg_data => x_msg_data
197: ,x_return_status => x_return_status
198: );

Line 203: IF x_return_status = FND_API.g_ret_sts_error

199: END IF;
200: END IF;
201:
202:
203: IF x_return_status = FND_API.g_ret_sts_error
204: THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;

Line 205: RAISE FND_API.g_exc_error;

201:
202:
203: IF x_return_status = FND_API.g_ret_sts_error
204: THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;
209:

Line 206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

202:
203: IF x_return_status = FND_API.g_ret_sts_error
204: THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;
209:
210: --Standard check of commit

Line 207: RAISE FND_API.g_exc_unexpected_error;

203: IF x_return_status = FND_API.g_ret_sts_error
204: THEN
205: RAISE FND_API.g_exc_error;
206: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
207: RAISE FND_API.g_exc_unexpected_error;
208: END IF;
209:
210: --Standard check of commit
211:

Line 212: IF FND_API.To_Boolean ( p_commit ) THEN

208: END IF;
209:
210: --Standard check of commit
211:
212: IF FND_API.To_Boolean ( p_commit ) THEN
213: COMMIT WORK;
214: END IF;
215:
216: COMMIT;

Line 227: WHEN FND_API.G_EXC_ERROR THEN

223: );
224:
225: EXCEPTION
226:
227: WHEN FND_API.G_EXC_ERROR THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: -- Standard call to get message count and if count=1, get the message
230: FND_msg_PUB.Count_And_Get (
231: -- p_encoded => FND_API.G_FALSE,

Line 228: x_return_status := FND_API.G_RET_STS_ERROR;

224:
225: EXCEPTION
226:
227: WHEN FND_API.G_EXC_ERROR THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: -- Standard call to get message count and if count=1, get the message
230: FND_msg_PUB.Count_And_Get (
231: -- p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count,

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

227: WHEN FND_API.G_EXC_ERROR THEN
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: -- Standard call to get message count and if count=1, get the message
230: FND_msg_PUB.Count_And_Get (
231: -- p_encoded => FND_API.G_FALSE,
232: p_count => x_msg_count,
233: p_data => x_msg_data
234: );
235:

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: p_data => x_msg_data
234: );
235:
236:
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238:
239: /* FOR l_counter IN 1 .. x_msg_count
240: LOOP
241: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

Line 241: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238:
239: /* FOR l_counter IN 1 .. x_msg_count
240: LOOP
241: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
242: fnd_msg_pub.dump_msg(l_counter);
243: end loop; */
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
242: fnd_msg_pub.dump_msg(l_counter);
243: end loop; */
244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: -- Standard call to get message count and if count=1, get the message
247: FND_msg_PUB.Count_And_Get (
248: --p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,

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

244:
245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246: -- Standard call to get message count and if count=1, get the message
247: FND_msg_PUB.Count_And_Get (
248: --p_encoded => FND_API.G_FALSE,
249: p_count => x_msg_count,
250: p_data => x_msg_data
251: );
252:

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: p_data => x_msg_data
251: );
252:
253: WHEN OTHERS THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
256: THEN
257: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
258: END IF;

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

257: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
258: END IF;
259: -- Standard call to get message count and if count=1, get the message
260: FND_msg_PUB.Count_And_Get (
261: -- p_encoded => FND_API.G_FALSE,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265:

Line 319: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

315:
316: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
317:
318: -- Standard call to check for call compatibility.
319: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
320: p_api_version_number,
321: l_api_name,
322: g_pkg_name)
323: THEN

Line 324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

320: p_api_version_number,
321: l_api_name,
322: g_pkg_name)
323: THEN
324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean( p_init_msg_list )

Line 328: IF FND_API.to_Boolean( p_init_msg_list )

324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
325: END IF;
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean( p_init_msg_list )
329: THEN
330: FND_msg_PUB.initialize;
331: END IF;
332:

Line 334: x_return_status := FND_API.G_RET_STS_SUCCESS;

330: FND_msg_PUB.initialize;
331: END IF;
332:
333: -- Initialize API return status to SUCCESS
334: x_return_status := FND_API.G_RET_STS_SUCCESS;
335:
336: --Get status codes for 'opportunity created' and 'dead lead'
337: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
338: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');

Line 455: x_return_status := FND_API.G_RET_STS_ERROR;

451: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
452: EXECUTE IMMEDIATE l_stmt;
453: commit;
454:
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: end if;
458: */
459:

Line 456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

452: EXECUTE IMMEDIATE l_stmt;
453: commit;
454:
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
457: end if;
458: */
459:
460: --update to get customer category

Line 783: WHEN FND_API.G_EXC_ERROR THEN

779:
780:
781: EXCEPTION
782:
783: WHEN FND_API.G_EXC_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_msg_PUB.Count_And_Get (
787: -- p_encoded => FND_API.G_FALSE,

Line 784: x_return_status := FND_API.G_RET_STS_ERROR;

780:
781: EXCEPTION
782:
783: WHEN FND_API.G_EXC_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_msg_PUB.Count_And_Get (
787: -- p_encoded => FND_API.G_FALSE,
788: p_count => x_msg_count,

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

783: WHEN FND_API.G_EXC_ERROR THEN
784: x_return_status := FND_API.G_RET_STS_ERROR;
785: -- Standard call to get message count and if count=1, get the message
786: FND_msg_PUB.Count_And_Get (
787: -- p_encoded => FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data
790: );
791:

Line 794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

790: );
791:
792: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
793:
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795:
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797:
798: -- Standard call to get message count and if count=1, get the message

Line 796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

792: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
793:
794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
795:
796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797:
798: -- Standard call to get message count and if count=1, get the message
799: FND_msg_PUB.Count_And_Get (
800: --p_encoded => FND_API.G_FALSE,

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

796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
797:
798: -- Standard call to get message count and if count=1, get the message
799: FND_msg_PUB.Count_And_Get (
800: --p_encoded => FND_API.G_FALSE,
801: p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804:

Line 809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

805: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:FIRST_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
806:
807: WHEN OTHERS THEN
808:
809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
810:
811: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
812: THEN
813: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

814: END IF;
815:
816: -- Standard call to get message count and if count=1, get the message
817: FND_msg_PUB.Count_And_Get (
818: -- p_encoded => FND_API.G_FALSE,
819: p_count => x_msg_count,
820: p_data => x_msg_data
821: );
822:

Line 876: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

872: l_sysdate date;
873: BEGIN
874: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
875: -- Standard call to check for call compatibility.
876: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
877: p_api_version_number,
878: l_api_name,
879: g_pkg_name)
880: THEN

Line 881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

877: p_api_version_number,
878: l_api_name,
879: g_pkg_name)
880: THEN
881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: END IF;
883:
884: -- Initialize message list if p_init_msg_list is set to TRUE.
885: IF FND_API.to_Boolean( p_init_msg_list )

Line 885: IF FND_API.to_Boolean( p_init_msg_list )

881: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
882: END IF;
883:
884: -- Initialize message list if p_init_msg_list is set to TRUE.
885: IF FND_API.to_Boolean( p_init_msg_list )
886: THEN
887: FND_msg_PUB.initialize;
888: END IF;
889:

Line 891: x_return_status := FND_API.G_RET_STS_SUCCESS;

887: FND_msg_PUB.initialize;
888: END IF;
889:
890: -- Initialize API return status to SUCCESS
891: x_return_status := FND_API.G_RET_STS_SUCCESS;
892:
893: --Get status codes for 'opportunity created' and 'dead lead'
894: l_conv_opp_status := nvl(FND_PROFILE.Value('AS_LEAD_LINK_STATUS'),'CONVERTED_TO_OPPORTUNITY');
895: l_dead_status := nvl(FND_PROFILE.Value('AS_DEAD_LEAD_STATUS'),'DEAD_LEAD');

Line 1075: x_return_status := FND_API.G_RET_STS_ERROR;

1071: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
1072: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
1073: EXECUTE IMMEDIATE l_stmt;
1074: commit;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077: end if;
1078: */
1079:

Line 1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1072: l_stmt := 'TRUNCATE table '||l_schema||'.bim_i_lead_facts_stg';
1073: EXECUTE IMMEDIATE l_stmt;
1074: commit;
1075: x_return_status := FND_API.G_RET_STS_ERROR;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077: end if;
1078: */
1079:
1080: --update to get customer category

Line 1503: WHEN FND_API.G_EXC_ERROR THEN

1499:
1500:
1501: EXCEPTION
1502:
1503: WHEN FND_API.G_EXC_ERROR THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: -- Standard call to get message count and if count=1, get the message
1506: FND_msg_PUB.Count_And_Get (
1507: -- p_encoded => FND_API.G_FALSE,

Line 1504: x_return_status := FND_API.G_RET_STS_ERROR;

1500:
1501: EXCEPTION
1502:
1503: WHEN FND_API.G_EXC_ERROR THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: -- Standard call to get message count and if count=1, get the message
1506: FND_msg_PUB.Count_And_Get (
1507: -- p_encoded => FND_API.G_FALSE,
1508: p_count => x_msg_count,

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

1503: WHEN FND_API.G_EXC_ERROR THEN
1504: x_return_status := FND_API.G_RET_STS_ERROR;
1505: -- Standard call to get message count and if count=1, get the message
1506: FND_msg_PUB.Count_And_Get (
1507: -- p_encoded => FND_API.G_FALSE,
1508: p_count => x_msg_count,
1509: p_data => x_msg_data
1510: );
1511:

Line 1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1510: );
1511:
1512: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515:
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517:
1518: -- Standard call to get message count and if count=1, get the message

Line 1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1512: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515:
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517:
1518: -- Standard call to get message count and if count=1, get the message
1519: FND_msg_PUB.Count_And_Get (
1520: --p_encoded => FND_API.G_FALSE,

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

1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517:
1518: -- Standard call to get message count and if count=1, get the message
1519: FND_msg_PUB.Count_And_Get (
1520: --p_encoded => FND_API.G_FALSE,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data
1523: );
1524:

Line 1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1525: ams_utility_pvt.write_conc_log('BIM_I_LEAD_FACTS_PKG:INCREMENTAL_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
1526:
1527: WHEN OTHERS THEN
1528:
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530:
1531: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1532: THEN
1533: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

1534: END IF;
1535:
1536: -- Standard call to get message count and if count=1, get the message
1537: FND_msg_PUB.Count_And_Get (
1538: -- p_encoded => FND_API.G_FALSE,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );
1542: