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

Line 88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

84: -----------------------------------------------------------------------
85: PROCEDURE POPULATE
86: (
87: p_api_version_number IN NUMBER ,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: x_msg_count OUT NOCOPY NUMBER ,
92: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

85: PROCEDURE POPULATE
86: (
87: p_api_version_number IN NUMBER ,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: x_msg_count OUT NOCOPY NUMBER ,
92: x_msg_data OUT NOCOPY VARCHAR2 ,
93: x_return_status OUT NOCOPY VARCHAR2 ,

Line 90: p_commit IN VARCHAR2 := FND_API.G_FALSE,

86: (
87: p_api_version_number IN NUMBER ,
88: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: x_msg_count OUT NOCOPY NUMBER ,
92: x_msg_data OUT NOCOPY VARCHAR2 ,
93: x_return_status OUT NOCOPY VARCHAR2 ,
94: p_object IN VARCHAR2 ,

Line 122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

118:
119: BEGIN
120:
121: -- Standard call to check for call compatibility.
122: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: p_api_version_number,
124: l_api_name,
125: G_PKG_NAME)
126: THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list IF p_init_msg_list IS set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )

Line 131: IF FND_API.to_Boolean( p_init_msg_list )

127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: -- Initialize message list IF p_init_msg_list IS set to TRUE.
131: IF FND_API.to_Boolean( p_init_msg_list )
132: THEN
133: FND_MSG_PUB.initialize;
134: END IF;
135:

Line 140: x_return_status := FND_API.G_RET_STS_SUCCESS;

136: -- Debug Message
137: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
138:
139: -- Initialize API return status to SUCCESS
140: x_return_status := FND_API.G_RET_STS_SUCCESS;
141:
142: /* Find if the data will be loaded for the first time or not.*/
143:
144: OPEN chk_history_data;

Line 163: RAISE FND_API.G_EXC_ERROR;

159: IF (l_max_end_date IS NOT NULL AND p_start_date IS NOT NULL)
160: THEN
161: ams_utility_pvt.write_conc_log('First Time Load is already run. Subsequent Load should be run.');
162: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now');
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166:
167: IF p_start_date IS NOT NULL THEN

Line 172: RAISE FND_API.G_EXC_ERROR;

168:
169: IF (p_start_date > p_end_date) THEN
170: ams_utility_pvt.write_conc_log('The start date cannot be greater than current end date');
171: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: EVENT_SUBSEQUENT_LOAD(p_start_datel => p_start_date
176: ,p_end_datel => l_end_date

Line 183: IF x_return_status = FND_API.g_ret_sts_error

179: ,x_msg_data=>x_msg_data
180: ,x_return_status=>x_return_status
181: );
182:
183: IF x_return_status = FND_API.g_ret_sts_error
184: THEN
185: RAISE FND_API.g_exc_error;
186: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
187: RAISE FND_API.g_exc_unexpected_error;

Line 185: RAISE FND_API.g_exc_error;

181: );
182:
183: IF x_return_status = FND_API.g_ret_sts_error
184: THEN
185: RAISE FND_API.g_exc_error;
186: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
187: RAISE FND_API.g_exc_unexpected_error;
188: END IF;
189: ELSE

Line 186: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

182:
183: IF x_return_status = FND_API.g_ret_sts_error
184: THEN
185: RAISE FND_API.g_exc_error;
186: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
187: RAISE FND_API.g_exc_unexpected_error;
188: END IF;
189: ELSE
190:

Line 187: RAISE FND_API.g_exc_unexpected_error;

183: IF x_return_status = FND_API.g_ret_sts_error
184: THEN
185: RAISE FND_API.g_exc_error;
186: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
187: RAISE FND_API.g_exc_unexpected_error;
188: END IF;
189: ELSE
190:
191: IF l_max_end_date IS NOT NULL THEN

Line 196: RAISE FND_API.g_exc_error;

192:
193: IF (p_end_date <= l_max_end_date) THEN
194: ams_utility_pvt.write_conc_log('The current end date cannot be less than the last end date ');
195: ams_utility_pvt.write_conc_log('Concurrent Program Exits Now ');
196: RAISE FND_API.g_exc_error;
197: END IF;
198:
199: EVENT_SUBSEQUENT_LOAD(p_start_datel => l_max_end_date + 1
200: ,p_end_datel => l_end_date

Line 208: IF x_return_status = FND_API.g_ret_sts_error

204: ,x_return_status=>x_return_status
205: );
206: END IF;
207:
208: IF x_return_status = FND_API.g_ret_sts_error
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
212: RAISE FND_API.g_exc_unexpected_error;

Line 210: RAISE FND_API.g_exc_error;

206: END IF;
207:
208: IF x_return_status = FND_API.g_ret_sts_error
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
212: RAISE FND_API.g_exc_unexpected_error;
213: END IF;
214: END IF;

Line 211: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

207:
208: IF x_return_status = FND_API.g_ret_sts_error
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
212: RAISE FND_API.g_exc_unexpected_error;
213: END IF;
214: END IF;
215: ELSE

Line 212: RAISE FND_API.g_exc_unexpected_error;

208: IF x_return_status = FND_API.g_ret_sts_error
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
212: RAISE FND_API.g_exc_unexpected_error;
213: END IF;
214: END IF;
215: ELSE
216: ams_utility_pvt.write_conc_log('----Period Validation----');

Line 223: IF FND_API.To_Boolean ( p_commit ) THEN

219: ams_utility_pvt.write_conc_log(l_currency_error);
220: END IF;
221:
222: --Standard check of commit
223: IF FND_API.To_Boolean ( p_commit ) THEN
224: COMMIT WORK;
225: END IF;
226: --add this
227: commit;

Line 236: WHEN FND_API.G_EXC_ERROR THEN

232: p_data => x_msg_data
233: );
234: EXCEPTION
235:
236: WHEN FND_API.G_EXC_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: -- Standard call to get message count and IF count=1, get the message
239: FND_msg_PUB.Count_And_Get (
240: -- p_encoded => FND_API.G_FALSE,

Line 237: x_return_status := FND_API.G_RET_STS_ERROR;

233: );
234: EXCEPTION
235:
236: WHEN FND_API.G_EXC_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: -- Standard call to get message count and IF count=1, get the message
239: FND_msg_PUB.Count_And_Get (
240: -- p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,

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

236: WHEN FND_API.G_EXC_ERROR THEN
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: -- Standard call to get message count and IF count=1, get the message
239: FND_msg_PUB.Count_And_Get (
240: -- p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

240: -- p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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,

Line 245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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 449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

445: l_return := fnd_installation.get_app_info('BIM', l_status1, l_industry1, l_schema);
446: --dbms_output.put_line('in first insert ');
447:
448: -- Standard call to check for call compatibility.
449: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
450: l_api_version_number,
451: l_api_name,
452: G_PKG_NAME)
453: THEN

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450: l_api_version_number,
451: l_api_name,
452: G_PKG_NAME)
453: THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456: -- Debug Message
457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
458:

Line 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456: -- Debug Message
457: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
458:
459: -- Initialize API return status to SUCCESS
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Running the First Load '||sqlerrm(sqlcode));
462: l_profile := FND_PROFILE.VALUE('AMS Budget Adjustment Grace Period in Days')+0; --for grace period
463: if l_profile is null then
464: l_profile :=0;

Line 838: x_return_status := FND_API.G_RET_STS_ERROR;

834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
838: x_return_status := FND_API.G_RET_STS_ERROR;
839: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
840: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
841: FND_MSG_PUB.Add;
842: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));

Line 843: RAISE FND_API.G_EXC_ERROR;

839: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
840: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
841: FND_MSG_PUB.Add;
842: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
843: RAISE FND_API.G_EXC_ERROR;
844: end;
845:
846: begin
847:

Line 1171: x_return_status := FND_API.G_RET_STS_ERROR;

1167: EXCEPTION
1168: WHEN OTHERS THEN
1169: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
1170: --dbms_output.put_line('even_daily:'||sqlerrm(sqlcode));
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1173: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1174: FND_MSG_PUB.Add;
1175: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1173: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1174: FND_MSG_PUB.Add;
1175: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
1176: RAISE FND_API.G_EXC_ERROR;
1177: END;
1178:
1179: --dbms_output.put_line('before second insert row count:');
1180:

Line 1471: x_return_status := FND_API.G_RET_STS_ERROR;

1467: EXECUTE IMMEDIATE 'ALTER TABLE '||l_schema||'.bim_r_even_daily_facts nologging';
1468: EXCEPTION
1469: WHEN OTHERS THEN
1470: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1473: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1474: FND_MSG_PUB.Add;
1475: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR THIRD INSERT. '||sqlerrm(sqlcode));

Line 1476: RAISE FND_API.G_EXC_ERROR;

1472: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
1473: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
1474: FND_MSG_PUB.Add;
1475: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR THIRD INSERT. '||sqlerrm(sqlcode));
1476: RAISE FND_API.G_EXC_ERROR;
1477: END;
1478:
1479:
1480:

Line 1909: RAISE FND_API.G_EXC_ERROR;

1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: NULL;
1908: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Exception for finding the min of creation date for cost and revenue. '||sqlerrm(sqlcode));
1909: RAISE FND_API.G_EXC_ERROR;
1910: END;
1911:
1912: IF l_min_date IS NOT NULL THEN
1913:

Line 2052: RAISE FND_API.G_EXC_ERROR;

2048: EXCEPTION
2049: WHEN NO_DATA_FOUND THEN
2050: NULL;
2051: ams_utility_pvt.write_conc_log('Exception for registered no data found. '||sqlerrm(sqlcode));
2052: RAISE FND_API.G_EXC_ERROR;
2053: END;
2054:
2055: END IF;
2056:

Line 2068: x_return_status := FND_API.G_RET_STS_ERROR;

2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
2067: --dbms_output.put_line('even_update:'||sqlerrm(sqlcode));
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2070: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2071: FND_MSG_PUB.Add;
2072: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));

Line 2073: RAISE FND_API.G_EXC_ERROR;

2069: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2070: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2071: FND_MSG_PUB.Add;
2072: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2073: RAISE FND_API.G_EXC_ERROR;
2074: END;
2075:
2076:
2077: /*********************************************************************************************/

Line 2096: RAISE FND_API.G_EXC_ERROR;

2092: EXCEPTION
2093: WHEN OTHERS THEN
2094: NULL;
2095: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: Exception for finding the min of creation date for cost and revenue. '||sqlerrm(sqlcode));
2096: RAISE FND_API.G_EXC_ERROR;
2097: END;
2098:
2099: IF l_min_date IS NOT NULL THEN
2100:

Line 2245: RAISE FND_API.G_EXC_ERROR;

2241: EXCEPTION
2242: WHEN NO_DATA_FOUND THEN
2243: NULL;
2244: ams_utility_pvt.write_conc_log('Exception for registered no data found. '||sqlerrm(sqlcode));
2245: RAISE FND_API.G_EXC_ERROR;
2246: END;
2247:
2248: END IF;
2249:

Line 2263: x_return_status := FND_API.G_RET_STS_ERROR;

2259: EXCEPTION
2260: WHEN OTHERS THEN
2261: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
2262: --dbms_output.put_line('even_update:'||sqlerrm(sqlcode));
2263: x_return_status := FND_API.G_RET_STS_ERROR;
2264: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2265: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2266: FND_MSG_PUB.Add;
2267: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));

Line 2268: RAISE FND_API.G_EXC_ERROR;

2264: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2265: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2266: FND_MSG_PUB.Add;
2267: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION registration insert statement. '||sqlerrm(sqlcode));
2268: RAISE FND_API.G_EXC_ERROR;
2269: END;
2270:
2271: -- analyze the bim_r_event_daily_facts with dbms_stats
2272: BEGIN

Line 2319: RAISE FND_API.G_EXC_ERROR;

2315: WHEN NO_DATA_FOUND THEN
2316: NULL;
2317: WHEN OTHERS THEN
2318: ams_utility_pvt.write_conc_log('FROM COST SELECT SQL ' || sqlerrm(sqlcode));
2319: RAISE FND_API.G_EXC_ERROR;
2320: END;
2321:
2322: BEGIN
2323: SELECT sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_actual_value,0)))

Line 2339: RAISE FND_API.G_EXC_ERROR;

2335: WHEN NO_DATA_FOUND THEN
2336: NULL;
2337: WHEN OTHERS THEN
2338: ams_utility_pvt.write_conc_log('FROM REVENUE SELECT SQL ' || sqlerrm(sqlcode));
2339: RAISE FND_API.G_EXC_ERROR;
2340: END;
2341:
2342: BEGIN
2343:

Line 2357: RAISE FND_API.G_EXC_ERROR;

2353: WHEN NO_DATA_FOUND THEN
2354: NULL;
2355: WHEN OTHERS THEN
2356: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR UPDATE FOR COST AND REVENUE' || sqlerrm(sqlcode));
2357: RAISE FND_API.G_EXC_ERROR;
2358: END;
2359: END LOOP;
2360: END;
2361:

Line 2398: RAISE FND_API.G_EXC_ERROR;

2394: WHEN NO_DATA_FOUND THEN
2395: NULL;
2396: WHEN OTHERS THEN
2397: ams_utility_pvt.write_conc_log('FROM COST SELECT SQL ' || sqlerrm(sqlcode));
2398: RAISE FND_API.G_EXC_ERROR;
2399: END;
2400:
2401: BEGIN
2402: SELECT sum(convert_currency(nvl(a.FUNCTIONAL_CURRENCY_CODE,'USD'),nvl(a.trans_actual_value,0)))

Line 2417: RAISE FND_API.G_EXC_ERROR;

2413: WHEN NO_DATA_FOUND THEN
2414: NULL;
2415: WHEN OTHERS THEN
2416: ams_utility_pvt.write_conc_log('FROM REVENUE SELECT SQL ' || sqlerrm(sqlcode));
2417: RAISE FND_API.G_EXC_ERROR;
2418: END;
2419:
2420:
2421: BEGIN

Line 2435: RAISE FND_API.G_EXC_ERROR;

2431: WHEN NO_DATA_FOUND THEN
2432: NULL;
2433: WHEN OTHERS THEN
2434: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR UPDATE FOR COST AND REVENUE' || sqlerrm(sqlcode));
2435: RAISE FND_API.G_EXC_ERROR;
2436: END;
2437:
2438: END LOOP;
2439:

Line 2661: RAISE FND_API.G_EXC_ERROR;

2657: WHEN NO_DATA_FOUND THEN
2658: null;
2659: ams_utility_pvt.write_conc_log('When no data found in weekly insert in first load. '||sqlerrm(sqlcode));
2660:
2661: RAISE FND_API.G_EXC_ERROR;
2662: WHEN OTHERS THEN
2663:
2664: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 20';
2665:

Line 2666: x_return_status := FND_API.G_RET_STS_ERROR;

2662: WHEN OTHERS THEN
2663:
2664: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_weekly_facts_s CACHE 20';
2665:
2666: x_return_status := FND_API.G_RET_STS_ERROR;
2667: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2668: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2669: FND_MSG_PUB.Add;
2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));

Line 2671: RAISE FND_API.G_EXC_ERROR;

2667: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
2668: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
2669: FND_MSG_PUB.Add;
2670: ams_utility_pvt.write_conc_log('EVENT:FIRST_LOAD: EXCEPTION FOR INSERT INTO WEEKLY FACTS. '||sqlerrm(sqlcode));
2671: RAISE FND_API.G_EXC_ERROR;
2672: END;
2673:
2674: -- analyze the BIM_R_EVEN_WEEKLY_FACTS with dbms_stats
2675: BEGIN

Line 2713: RAISE FND_API.G_EXC_ERROR;

2709: EXCEPTION
2710: WHEN OTHERS THEN
2711: -- DBMS_OUTPUT.PUT_LINE(sqlerrm(sqlcode));
2712: ams_utility_pvt.write_conc_log('Exception for creating index for first load. '||sqlerrm(sqlcode));
2713: RAISE FND_API.G_EXC_ERROR;
2714: NULL;
2715: END;
2716:
2717: EXCEPTION

Line 2719: WHEN FND_API.G_EXC_ERROR THEN

2715: END;
2716:
2717: EXCEPTION
2718:
2719: WHEN FND_API.G_EXC_ERROR THEN
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: -- Standard call to get message count and if count=1, get the message
2722: FND_msg_PUB.Count_And_Get (
2723: p_count => x_msg_count,

Line 2720: x_return_status := FND_API.G_RET_STS_ERROR;

2716:
2717: EXCEPTION
2718:
2719: WHEN FND_API.G_EXC_ERROR THEN
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721: -- Standard call to get message count and if count=1, get the message
2722: FND_msg_PUB.Count_And_Get (
2723: p_count => x_msg_count,
2724: p_data => x_msg_data

Line 2728: RAISE FND_API.G_EXC_ERROR;

2724: p_data => x_msg_data
2725: );
2726:
2727: ams_utility_pvt.write_conc_log('EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2728: RAISE FND_API.G_EXC_ERROR;
2729:
2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2726:
2727: ams_utility_pvt.write_conc_log('EXPECTED EXCEPTION '||sqlerrm(sqlcode));
2728: RAISE FND_API.G_EXC_ERROR;
2729:
2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: -- Standard call to get message count and if count=1, get the message

Line 2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2728: RAISE FND_API.G_EXC_ERROR;
2729:
2730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2731:
2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: -- Standard call to get message count and if count=1, get the message
2735: FND_msg_PUB.Count_And_Get (
2736: --p_encoded => FND_API.G_FALSE,

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

2732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2733:
2734: -- Standard call to get message count and if count=1, get the message
2735: FND_msg_PUB.Count_And_Get (
2736: --p_encoded => FND_API.G_FALSE,
2737: p_count => x_msg_count,
2738: p_data => x_msg_data
2739: );
2740:

Line 2742: RAISE FND_API.G_EXC_ERROR;

2738: p_data => x_msg_data
2739: );
2740:
2741: ams_utility_pvt.write_conc_log('UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
2742: RAISE FND_API.G_EXC_ERROR;
2743:
2744: WHEN OTHERS THEN
2745:
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2742: RAISE FND_API.G_EXC_ERROR;
2743:
2744: WHEN OTHERS THEN
2745:
2746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2747:
2748: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
2749: THEN
2750: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

2751: END IF;
2752:
2753: -- Standard call to get message count and if count=1, get the message
2754: FND_msg_PUB.Count_And_Get (
2755: -- p_encoded => FND_API.G_FALSE,
2756: p_count => x_msg_count,
2757: p_data => x_msg_data
2758: );
2759:

Line 2762: RAISE FND_API.G_EXC_ERROR;

2758: );
2759:
2760: ams_utility_pvt.write_conc_log('OTHERS EXCEPTION '||sqlerrm(sqlcode));
2761: ams_utility_pvt.write_conc_log('Before end of event_first_load for first load. ');
2762: RAISE FND_API.G_EXC_ERROR;
2763: END EVENT_FIRST_LOAD;
2764:
2765:
2766: PROCEDURE EVENT_SUBSEQUENT_LOAD

Line 2803: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

2799:
2800: l_return := fnd_installation.get_app_info('BIM', l_status1, l_industry1, l_schema);
2801:
2802: -- Standard call to check for call compatibility.
2803: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2804: l_api_version_number,
2805: l_api_name,
2806: G_PKG_NAME)
2807: THEN

Line 2808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2804: l_api_version_number,
2805: l_api_name,
2806: G_PKG_NAME)
2807: THEN
2808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2809: END IF;
2810:
2811: -- Debug Message
2812: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 3785: x_return_status := FND_API.G_RET_STS_ERROR;

3781: EXCEPTION
3782: WHEN OTHERS THEN
3783: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
3784: --dbms_output.put_line('even_daily:'||sqlerrm(sqlcode));
3785: x_return_status := FND_API.G_RET_STS_ERROR;
3786: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3787: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3788: FND_MSG_PUB.Add;
3789: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));

Line 3790: RAISE FND_API.G_EXC_ERROR;

3786: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
3787: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
3788: FND_MSG_PUB.Add;
3789: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR FIRST INSERT. '||sqlerrm(sqlcode));
3790: RAISE FND_API.G_EXC_ERROR;
3791: END;
3792:
3793:
3794: BEGIN

Line 4257: x_return_status := FND_API.G_RET_STS_ERROR;

4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_schema||'.bim_r_even_daily_facts_s CACHE 20';
4256: --dbms_output.put_line('even_update:'||sqlerrm(sqlcode));
4257: x_return_status := FND_API.G_RET_STS_ERROR;
4258: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4259: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4260: FND_MSG_PUB.Add;
4261:

Line 4263: RAISE FND_API.G_EXC_ERROR;

4259: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4260: FND_MSG_PUB.Add;
4261:
4262: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR SECOND INSERT. '||sqlerrm(sqlcode));
4263: RAISE FND_API.G_EXC_ERROR;
4264: END;
4265:
4266: -- analyze the BIM_R_EVEN_daily_facts with dbms_stats
4267: BEGIN

Line 4475: x_return_status := FND_API.G_RET_STS_ERROR;

4471: ams_utility_pvt.write_conc_log('End of Events Facts Program -- Subsequent Load');
4472:
4473: EXCEPTION
4474: WHEN OTHERS THEN
4475: x_return_status := FND_API.G_RET_STS_ERROR;
4476: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4477: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4478: FND_MSG_PUB.Add;
4479: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR INSERT INTO WEEKLY TABLE. '||sqlerrm(sqlcode));

Line 4480: RAISE FND_API.G_EXC_ERROR;

4476: FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');
4477: FND_MESSAGE.Set_token('table_name', l_table_name, FALSE);
4478: FND_MSG_PUB.Add;
4479: ams_utility_pvt.write_conc_log('EVENT:LOAD: EXCEPTION FOR INSERT INTO WEEKLY TABLE. '||sqlerrm(sqlcode));
4480: RAISE FND_API.G_EXC_ERROR;
4481: END ;
4482: --END IF;
4483: EXCEPTION
4484:

Line 4485: WHEN FND_API.G_EXC_ERROR THEN

4481: END ;
4482: --END IF;
4483: EXCEPTION
4484:
4485: WHEN FND_API.G_EXC_ERROR THEN
4486: x_return_status := FND_API.G_RET_STS_ERROR;
4487: -- Standard call to get message count and if count=1, get the message
4488: FND_msg_PUB.Count_And_Get (
4489: -- p_encoded => FND_API.G_FALSE,

Line 4486: x_return_status := FND_API.G_RET_STS_ERROR;

4482: --END IF;
4483: EXCEPTION
4484:
4485: WHEN FND_API.G_EXC_ERROR THEN
4486: x_return_status := FND_API.G_RET_STS_ERROR;
4487: -- Standard call to get message count and if count=1, get the message
4488: FND_msg_PUB.Count_And_Get (
4489: -- p_encoded => FND_API.G_FALSE,
4490: p_count => x_msg_count,

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

4485: WHEN FND_API.G_EXC_ERROR THEN
4486: x_return_status := FND_API.G_RET_STS_ERROR;
4487: -- Standard call to get message count and if count=1, get the message
4488: FND_msg_PUB.Count_And_Get (
4489: -- p_encoded => FND_API.G_FALSE,
4490: p_count => x_msg_count,
4491: p_data => x_msg_data
4492: );
4493:

Line 4495: RAISE FND_API.G_EXC_ERROR;

4491: p_data => x_msg_data
4492: );
4493:
4494: ams_utility_pvt.write_conc_log('EVENT:LOAD:EXPECTED EXCEPTION '||sqlerrm(sqlcode));
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497:
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499:

Line 4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4492: );
4493:
4494: ams_utility_pvt.write_conc_log('EVENT:LOAD:EXPECTED EXCEPTION '||sqlerrm(sqlcode));
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497:
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499:
4500: -- Standard call to get message count and if count=1, get the message

Line 4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4494: ams_utility_pvt.write_conc_log('EVENT:LOAD:EXPECTED EXCEPTION '||sqlerrm(sqlcode));
4495: RAISE FND_API.G_EXC_ERROR;
4496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4497:
4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499:
4500: -- Standard call to get message count and if count=1, get the message
4501: FND_msg_PUB.Count_And_Get (
4502: --p_encoded => FND_API.G_FALSE,

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

4498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4499:
4500: -- Standard call to get message count and if count=1, get the message
4501: FND_msg_PUB.Count_And_Get (
4502: --p_encoded => FND_API.G_FALSE,
4503: p_count => x_msg_count,
4504: p_data => x_msg_data
4505: );
4506:

Line 4508: RAISE FND_API.G_EXC_ERROR;

4504: p_data => x_msg_data
4505: );
4506:
4507: ams_utility_pvt.write_conc_log('EVENT:LOAD: UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
4508: RAISE FND_API.G_EXC_ERROR;
4509: WHEN OTHERS THEN
4510:
4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4512:

Line 4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4507: ams_utility_pvt.write_conc_log('EVENT:LOAD: UNEXPECTED EXCEPTION '||sqlerrm(sqlcode));
4508: RAISE FND_API.G_EXC_ERROR;
4509: WHEN OTHERS THEN
4510:
4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4512:
4513: IF FND_msg_PUB.Check_msg_Level (FND_msg_PUB.G_msg_LVL_UNEXP_ERROR)
4514: THEN
4515: FND_msg_PUB.Add_Exc_msg( g_pkg_name,l_api_name);

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

4516: END IF;
4517:
4518: -- Standard call to get message count and if count=1, get the message
4519: FND_msg_PUB.Count_And_Get (
4520: -- p_encoded => FND_API.G_FALSE,
4521: p_count => x_msg_count,
4522: p_data => x_msg_data
4523: );
4524: