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

Line 145: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

141:
142: BEGIN
143:
144: -- Standard call to check for call compatibility.
145: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
146: p_api_version_number,
147: l_api_name,
148: g_pkg_name)
149: THEN

Line 150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

146: p_api_version_number,
147: l_api_name,
148: g_pkg_name)
149: THEN
150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: -- Initialize message list if p_init_msg_list is set to TRUE.
154: IF FND_API.to_Boolean( p_init_msg_list )

Line 154: IF FND_API.to_Boolean( p_init_msg_list )

150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
151: END IF;
152:
153: -- Initialize message list if p_init_msg_list is set to TRUE.
154: IF FND_API.to_Boolean( p_init_msg_list )
155: THEN
156: FND_MSG_PUB.initialize;
157: END IF;
158:

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: FND_MSG_PUB.initialize;
157: END IF;
158:
159: -- Initialize API return status to SUCCESS
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: -- Debug Message
163: -- AMS_UTILITY_PVT.debug_message('Private API: ' || 'Running the populate procedure');
164: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Facts load starts at:'||sysdate);

Line 178: RAISE FND_API.G_EXC_ERROR;

174: IF (l_end_date IS NULL) THEN
175:
176: IF (p_start_date IS NULL) THEN
177: bis_collection_utilities.log('Please run the Upadate budget Facts First Time Base Summary concurrent program before running this');
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: IF (p_start_date >= p_end_date) THEN
182: bis_collection_utilities.log('Start Date Can not be greater than End Date');

Line 183: RAISE FND_API.G_EXC_ERROR;

179: END IF;
180:
181: IF (p_start_date >= p_end_date) THEN
182: bis_collection_utilities.log('Start Date Can not be greater than End Date');
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: --Validate time dimension tables
186: fii_time_api.check_missing_date (greatest(l_global_start_date,p_start_date), sysdate, l_missing_date);
187: IF (l_missing_date) THEN

Line 189: RAISE FND_API.G_EXC_ERROR;

185: --Validate time dimension tables
186: fii_time_api.check_missing_date (greatest(l_global_start_date,p_start_date), sysdate, l_missing_date);
187: IF (l_missing_date) THEN
188: bis_collection_utilities.log('Time dimension has at least one missing date between ' || greatest(l_global_start_date,p_start_date) || ' and ' || sysdate);
189: RAISE FND_API.G_EXC_ERROR;
190: END IF;
191:
192: l_load_type := 'FIRST_LOAD';
193: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: First Load');

Line 198: ,p_init_msg_list => FND_API.G_FALSE

194:
195: FIRST_LOAD(p_start_date => greatest(l_global_start_date,p_start_date)
196: ,p_end_date => sysdate
197: ,p_api_version_number => l_api_version_number
198: ,p_init_msg_list => FND_API.G_FALSE
199: ,p_load_type => l_load_type
200: ,x_msg_count => x_msg_count
201: ,x_msg_data => x_msg_data
202: ,x_return_status => x_return_status

Line 215: ,p_init_msg_list => FND_API.G_FALSE

211:
212: FIRST_LOAD(p_start_date => greatest(l_global_start_date,p_start_date)
213: ,p_end_date => l_sysdate
214: ,p_api_version_number => l_api_version_number
215: ,p_init_msg_list => FND_API.G_FALSE
216: ,p_load_type => l_load_type
217: ,x_msg_count => x_msg_count
218: ,x_msg_data => x_msg_data
219: ,x_return_status => x_return_status

Line 226: RAISE FND_API.g_exc_error;

222:
223:
224: IF (l_end_date >= sysdate) THEN
225: bis_collection_utilities.log('Load Progarm already run upto ' || l_end_date);
226: RAISE FND_API.g_exc_error;
227: END IF;
228: --Validate time dimension tables
229: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);
230: IF (l_missing_date) THEN

Line 232: RAISE FND_API.G_EXC_ERROR;

228: --Validate time dimension tables
229: fii_time_api.check_missing_date (l_end_date, sysdate, l_missing_date);
230: IF (l_missing_date) THEN
231: bis_collection_utilities.log('Time dimension has atleast one missing date between ' || l_end_date || ' and ' || sysdate);
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: l_load_type := 'SUBSEQUENT_LOAD';
236: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Incremental Load');

Line 240: ,p_init_msg_list => FND_API.G_FALSE

236: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Incremental Load');
237: /*SUB_LOAD(p_start_date => l_end_date+1/86400
238: ,p_end_date => sysdate
239: ,p_api_version_number => l_api_version_number
240: ,p_init_msg_list => FND_API.G_FALSE
241: ,p_load_type => l_load_type
242: ,x_msg_count => x_msg_count
243: ,x_msg_data => x_msg_data
244: ,x_return_status => x_return_status

Line 249: ,p_init_msg_list => FND_API.G_FALSE

245: );*/
246: SUB_LOAD(p_start_date => trunc(l_end_date)
247: ,p_end_date => sysdate
248: ,p_api_version_number => l_api_version_number
249: ,p_init_msg_list => FND_API.G_FALSE
250: ,p_load_type => l_load_type
251: ,x_msg_count => x_msg_count
252: ,x_msg_data => x_msg_data
253: ,x_return_status => x_return_status

Line 258: IF x_return_status = FND_API.g_ret_sts_error

254: );
255: END IF;
256: END IF;
257:
258: IF x_return_status = FND_API.g_ret_sts_error
259: THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;

Line 260: RAISE FND_API.g_exc_error;

256: END IF;
257:
258: IF x_return_status = FND_API.g_ret_sts_error
259: THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:

Line 261: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

257:
258: IF x_return_status = FND_API.g_ret_sts_error
259: THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:
265: --Standard check of commit

Line 262: RAISE FND_API.g_exc_unexpected_error;

258: IF x_return_status = FND_API.g_ret_sts_error
259: THEN
260: RAISE FND_API.g_exc_error;
261: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:
265: --Standard check of commit
266: IF FND_API.To_Boolean ( p_commit ) THEN

Line 266: IF FND_API.To_Boolean ( p_commit ) THEN

262: RAISE FND_API.g_exc_unexpected_error;
263: END IF;
264:
265: --Standard check of commit
266: IF FND_API.To_Boolean ( p_commit ) THEN
267: COMMIT WORK;
268: END IF;
269:
270: COMMIT;

Line 281: WHEN FND_API.G_EXC_ERROR THEN

277: );
278:
279: EXCEPTION
280:
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_msg_PUB.Count_And_Get (
285: -- p_encoded => FND_API.G_FALSE,

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

278:
279: EXCEPTION
280:
281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_msg_PUB.Count_And_Get (
285: -- p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,

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

281: WHEN FND_API.G_EXC_ERROR THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: -- Standard call to get message count and if count=1, get the message
284: FND_msg_PUB.Count_And_Get (
285: -- p_encoded => FND_API.G_FALSE,
286: p_count => x_msg_count,
287: p_data => x_msg_data
288: );
289:

Line 291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

287: p_data => x_msg_data
288: );
289:
290:
291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292:
293: /* FOR l_counter IN 1 .. x_msg_count
294: LOOP
295: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);

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

291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
292:
293: /* FOR l_counter IN 1 .. x_msg_count
294: LOOP
295: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
296: fnd_msg_pub.dump_msg(l_counter);
297: end loop; */
298:
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

295: l_mesg_text := fnd_msg_pub.get (p_encoded => fnd_api.g_false);
296: fnd_msg_pub.dump_msg(l_counter);
297: end loop; */
298:
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: -- Standard call to get message count and if count=1, get the message
301: FND_msg_PUB.Count_And_Get (
302: --p_encoded => FND_API.G_FALSE,
303: p_count => x_msg_count,

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

298:
299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
300: -- Standard call to get message count and if count=1, get the message
301: FND_msg_PUB.Count_And_Get (
302: --p_encoded => FND_API.G_FALSE,
303: p_count => x_msg_count,
304: p_data => x_msg_data
305: );
306:

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: p_data => x_msg_data
305: );
306:
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: IF FND_msg_PUB.Check_msg_Level ( FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
310: THEN
311: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
312: END IF;

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

311: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
312: END IF;
313: -- Standard call to get message count and if count=1, get the message
314: /* FND_msg_PUB.Count_And_Get (
315: -- p_encoded => FND_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );*/
319:

Line 365: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

361:
362: --dbms_output.put_line('inside first load:'|| p_start_date || ' '|| p_end_date);
363:
364: -- Standard call to check for call compatibility.
365: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
366: p_api_version_number,
367: l_api_name,
368: g_pkg_name)
369: THEN

Line 370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

366: p_api_version_number,
367: l_api_name,
368: g_pkg_name)
369: THEN
370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
371: END IF;
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.
374: IF FND_API.to_Boolean( p_init_msg_list )

Line 374: IF FND_API.to_Boolean( p_init_msg_list )

370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
371: END IF;
372:
373: -- Initialize message list if p_init_msg_list is set to TRUE.
374: IF FND_API.to_Boolean( p_init_msg_list )
375: THEN
376: FND_msg_PUB.initialize;
377: END IF;
378:

Line 380: x_return_status := FND_API.G_RET_STS_SUCCESS;

376: FND_msg_PUB.initialize;
377: END IF;
378:
379: -- Initialize API return status to SUCCESS
380: x_return_status := FND_API.G_RET_STS_SUCCESS;
381:
382: --dbms_output.put_line('BIM_I_BUDGET_FACTS: Running the First Load '||sqlerrm(sqlcode));
383:
384: -- The below four commands are necessary for the purpose of the parallel insertion */

Line 1419: x_return_status := FND_API.G_RET_STS_ERROR;

1415: BIS_COLLECTION_UTILITIES.debug('before truncating first time load' );
1416: l_stmt := 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_stg';
1417: EXECUTE IMMEDIATE l_stmt;
1418: commit;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: end if;
1422:
1423: --BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserted '||SQL%COUNT);

Line 1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1416: l_stmt := 'TRUNCATE table '||l_schema||'.BIM_I_BUDGET_FACTS_stg';
1417: EXECUTE IMMEDIATE l_stmt;
1418: commit;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: end if;
1422:
1423: --BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Inserted '||SQL%COUNT);
1424: EXECUTE IMMEDIATE 'COMMIT';

Line 1537: RAISE FND_API.G_EXC_ERROR;

1533: -- Make entry in the history table
1534: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS: Wrapup');
1535: BEGIN
1536: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
1537: RAISE FND_API.G_EXC_ERROR;
1538: return;
1539: END IF;
1540:
1541: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1553: RAISE FND_API.G_EXC_ERROR;

1549: p_status => FALSE,
1550: p_period_from =>p_start_date,
1551: p_period_to =>sysdate
1552: );
1553: RAISE FND_API.G_EXC_ERROR;
1554: END;
1555:
1556: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before create index');
1557:

Line 1566: WHEN FND_API.G_EXC_ERROR THEN

1562: /*fnd_message.set_name('BIM','BIM_R_PROG_COMPLETION');
1563: fnd_message.set_token('program_name', 'Budget first load', FALSE);
1564: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
1565: EXCEPTION
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_msg_PUB.Count_And_Get (
1570: -- p_encoded => FND_API.G_FALSE,

Line 1567: x_return_status := FND_API.G_RET_STS_ERROR;

1563: fnd_message.set_token('program_name', 'Budget first load', FALSE);
1564: fnd_file.put_line(fnd_file.log,fnd_message.get);*/
1565: EXCEPTION
1566: WHEN FND_API.G_EXC_ERROR THEN
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_msg_PUB.Count_And_Get (
1570: -- p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count,

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

1566: WHEN FND_API.G_EXC_ERROR THEN
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: -- Standard call to get message count and if count=1, get the message
1569: FND_msg_PUB.Count_And_Get (
1570: -- p_encoded => FND_API.G_FALSE,
1571: p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:

Line 1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1572: p_data => x_msg_data
1573: );
1574:
1575: ams_utility_pvt.write_conc_log('BIM_I_BUDGET_FACTS:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_msg_PUB.Count_And_Get (
1580: --p_encoded => FND_API.G_FALSE,

Line 1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1573: );
1574:
1575: ams_utility_pvt.write_conc_log('BIM_I_BUDGET_FACTS:FIRST_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_msg_PUB.Count_And_Get (
1580: --p_encoded => FND_API.G_FALSE,
1581: p_count => x_msg_count,

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

1576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1578: -- Standard call to get message count and if count=1, get the message
1579: FND_msg_PUB.Count_And_Get (
1580: --p_encoded => FND_API.G_FALSE,
1581: p_count => x_msg_count,
1582: p_data => x_msg_data
1583: );
1584: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Unexpected'||sqlerrm(sqlcode));

Line 1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1583: );
1584: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Unexpected'||sqlerrm(sqlcode));
1585:
1586: WHEN OTHERS THEN
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
1589: THEN
1590: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);
1591: END IF;

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

1591: END IF;
1592:
1593: -- Standard call to get message count and if count=1, get the message
1594: FND_msg_PUB.Count_And_Get (
1595: -- p_encoded => FND_API.G_FALSE,
1596: p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1599: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:IN OTHERS EXCEPTION'||sqlerrm(sqlcode));

Line 1646: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1642: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
1643: --dbms_output.put_line('inside sub load:'||p_start_date || ' '|| p_end_date);
1644:
1645: -- Standard call to check for call compatibility.
1646: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1647: p_api_version_number,
1648: l_api_name,
1649: g_pkg_name)
1650: THEN

Line 1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1647: p_api_version_number,
1648: l_api_name,
1649: g_pkg_name)
1650: THEN
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: END IF;
1653:
1654: -- Initialize message list if p_init_msg_list is set to TRUE.
1655: IF FND_API.to_Boolean( p_init_msg_list )

Line 1655: IF FND_API.to_Boolean( p_init_msg_list )

1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: END IF;
1653:
1654: -- Initialize message list if p_init_msg_list is set to TRUE.
1655: IF FND_API.to_Boolean( p_init_msg_list )
1656: THEN
1657: FND_msg_PUB.initialize;
1658: END IF;
1659:

Line 1661: x_return_status := FND_API.G_RET_STS_SUCCESS;

1657: FND_msg_PUB.initialize;
1658: END IF;
1659:
1660: -- Initialize API return status to SUCCESS
1661: x_return_status := FND_API.G_RET_STS_SUCCESS;
1662:
1663: --dbms_output.put_line('inside sub load 2:');
1664:
1665: -- The below four commands are necessary for the purpose of the parallel insertion */

Line 2693: x_return_status := FND_API.G_RET_STS_ERROR;

2689: l_check_missing_rate := Check_Missing_Rates (p_start_date);
2690: if (l_check_missing_rate = -1) then
2691: DELETE from BIM_I_BUDGET_FACTS_stg where transaction_create_date>= p_start_date;
2692: commit;
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2695: end if;
2696: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental Load:after calling checking_missing_rates');
2697:

Line 2694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2690: if (l_check_missing_rate = -1) then
2691: DELETE from BIM_I_BUDGET_FACTS_stg where transaction_create_date>= p_start_date;
2692: commit;
2693: x_return_status := FND_API.G_RET_STS_ERROR;
2694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2695: end if;
2696: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Incremental Load:after calling checking_missing_rates');
2697:
2698: --insert into facts table

Line 2804: RAISE FND_API.G_EXC_ERROR;

2800: --dbms_output.put_line('b4 inserting log');
2801: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:Before Insert into log.');
2802: BEGIN
2803: IF (Not BIS_COLLECTION_UTILITIES.setup('BUDGET_FACTS')) THEN
2804: RAISE FND_API.G_EXC_ERROR;
2805: return;
2806: END IF;
2807: BIS_COLLECTION_UTILITIES.WRAPUP(
2808: p_status => TRUE ,

Line 2819: RAISE FND_API.G_EXC_ERROR;

2815: p_status => FALSE,
2816: p_period_from =>p_start_date,
2817: p_period_to =>sysdate
2818: );
2819: RAISE FND_API.G_EXC_ERROR;
2820: END;
2821: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After Insert into log.');
2822: EXCEPTION
2823: WHEN FND_API.G_EXC_ERROR THEN

Line 2823: WHEN FND_API.G_EXC_ERROR THEN

2819: RAISE FND_API.G_EXC_ERROR;
2820: END;
2821: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After Insert into log.');
2822: EXCEPTION
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: x_return_status := FND_API.G_RET_STS_ERROR;
2825: -- Standard call to get message count and if count=1, get the message
2826: FND_msg_PUB.Count_And_Get (
2827: -- p_encoded => FND_API.G_FALSE,

Line 2824: x_return_status := FND_API.G_RET_STS_ERROR;

2820: END;
2821: BIS_COLLECTION_UTILITIES.log('BIM_I_BUDGET_FACTS:After Insert into log.');
2822: EXCEPTION
2823: WHEN FND_API.G_EXC_ERROR THEN
2824: x_return_status := FND_API.G_RET_STS_ERROR;
2825: -- Standard call to get message count and if count=1, get the message
2826: FND_msg_PUB.Count_And_Get (
2827: -- p_encoded => FND_API.G_FALSE,
2828: p_count => x_msg_count,

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

2823: WHEN FND_API.G_EXC_ERROR THEN
2824: x_return_status := FND_API.G_RET_STS_ERROR;
2825: -- Standard call to get message count and if count=1, get the message
2826: FND_msg_PUB.Count_And_Get (
2827: -- p_encoded => FND_API.G_FALSE,
2828: p_count => x_msg_count,
2829: p_data => x_msg_data
2830: );
2831:

Line 2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2829: p_data => x_msg_data
2830: );
2831:
2832: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836:
2837: -- Standard call to get message count and if count=1, get the message

Line 2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2831:
2832: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2834:
2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836:
2837: -- Standard call to get message count and if count=1, get the message
2838: FND_msg_PUB.Count_And_Get (
2839: --p_encoded => FND_API.G_FALSE,

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

2835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2836:
2837: -- Standard call to get message count and if count=1, get the message
2838: FND_msg_PUB.Count_And_Get (
2839: --p_encoded => FND_API.G_FALSE,
2840: p_count => x_msg_count,
2841: p_data => x_msg_data
2842: );
2843:

Line 2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2844: ams_utility_pvt.write_conc_log('BIM_I_BUDGET_FACTS:SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2845: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2846: WHEN OTHERS THEN
2847:
2848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2849:
2850: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
2851: THEN
2852: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

2853: END IF;
2854:
2855: -- Standard call to get message count and if count=1, get the message
2856: FND_msg_PUB.Count_And_Get (
2857: -- p_encoded => FND_API.G_FALSE,
2858: p_count => x_msg_count,
2859: p_data => x_msg_data
2860: );
2861: BIS_COLLECTION_UTILITIES.log('SUBSEQUENT_LOAD:IN other EXCEPTION '||sqlerrm(sqlcode));