72: RAISE fnd_api.g_exc_unexpected_error;
73: END IF;
74:
75: IF fnd_api.to_boolean(p_init_msg_list) THEN
76: fnd_msg_pub.initialize;
77: END IF;
78:
79: x_return_status := fnd_api.g_ret_sts_success;
80:
96: ( application => 'EAM'
97: , name => 'EAM_INSTANCE_ID_INVALID'
98: );
99:
100: fnd_msg_pub.add;
101: x_return_status:= fnd_api.g_ret_sts_error;
102: fnd_msg_pub.Count_And_Get
103: ( p_count => x_msg_count,
104: p_data => x_msg_data
98: );
99:
100: fnd_msg_pub.add;
101: x_return_status:= fnd_api.g_ret_sts_error;
102: fnd_msg_pub.Count_And_Get
103: ( p_count => x_msg_count,
104: p_data => x_msg_data
105: );
106: RETURN;
238: -- Standard check of p_commit.
239: IF fnd_api.to_boolean(p_commit) THEN
240: COMMIT WORK;
241: END IF;
242: fnd_msg_pub.count_and_get(
243: p_count => x_msg_count
244: ,p_data => x_msg_data);
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
245: EXCEPTION
246: WHEN fnd_api.g_exc_error THEN
247: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
248: x_return_status := fnd_api.g_ret_sts_error;
249: fnd_msg_pub.count_and_get(
250: p_count => x_msg_count
251: ,p_data => x_msg_data);
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
251: ,p_data => x_msg_data);
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get(
256: p_count => x_msg_count
257: ,p_data => x_msg_data);
258: WHEN OTHERS THEN
259: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
258: WHEN OTHERS THEN
259: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: IF fnd_msg_pub.check_msg_level(
263: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
264: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
265: END IF;
266:
259: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: IF fnd_msg_pub.check_msg_level(
263: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
264: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
265: END IF;
266:
267: fnd_msg_pub.count_and_get(
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261:
262: IF fnd_msg_pub.check_msg_level(
263: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
264: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
265: END IF;
266:
267: fnd_msg_pub.count_and_get(
268: p_count => x_msg_count,
263: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
264: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
265: END IF;
266:
267: fnd_msg_pub.count_and_get(
268: p_count => x_msg_count,
269: p_data => x_msg_data);
270:
271: END insert_row;
310: RAISE fnd_api.g_exc_unexpected_error;
311: END IF;
312:
313: IF fnd_api.to_boolean(p_init_msg_list) THEN
314: fnd_msg_pub.initialize;
315: END IF;
316:
317: x_return_status := fnd_api.g_ret_sts_success;
318:
323: fnd_message.set_name
324: ( application => 'EAM'
325: , name => 'EAM_EVENT_TYPE_INVALID'
326: );
327: fnd_msg_pub.add;
328: x_return_status:= fnd_api.g_ret_sts_error;
329: fnd_msg_pub.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data
325: , name => 'EAM_EVENT_TYPE_INVALID'
326: );
327: fnd_msg_pub.add;
328: x_return_status:= fnd_api.g_ret_sts_error;
329: fnd_msg_pub.Count_And_Get
330: ( p_count => x_msg_count,
331: p_data => x_msg_data
332: );
333:
341: ( application => 'EAM'
342: , name => 'EAM_EVENT_DATE_INVALID'
343: );
344:
345: fnd_msg_pub.add;
346: x_return_status:= fnd_api.g_ret_sts_error;
347: fnd_msg_pub.Count_And_Get
348: ( p_count => x_msg_count,
349: p_data => x_msg_data
343: );
344:
345: fnd_msg_pub.add;
346: x_return_status:= fnd_api.g_ret_sts_error;
347: fnd_msg_pub.Count_And_Get
348: ( p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351: return;
368: ( application => 'EAM'
369: , name => 'EAM_EVENT_ID_INVALID'
370: );
371:
372: fnd_msg_pub.add;
373: x_return_status:= fnd_api.g_ret_sts_error;
374: fnd_msg_pub.Count_And_Get
375: ( p_count => x_msg_count,
376: p_data => x_msg_data
370: );
371:
372: fnd_msg_pub.add;
373: x_return_status:= fnd_api.g_ret_sts_error;
374: fnd_msg_pub.Count_And_Get
375: ( p_count => x_msg_count,
376: p_data => x_msg_data
377: );
378: RETURN;
391: ( application => 'EAM'
392: , name => 'EAM_INSTANCE_ID_INVALID'
393: );
394:
395: fnd_msg_pub.add;
396: x_return_status:= fnd_api.g_ret_sts_error;
397: fnd_msg_pub.Count_And_Get
398: ( p_count => x_msg_count,
399: p_data => x_msg_data
393: );
394:
395: fnd_msg_pub.add;
396: x_return_status:= fnd_api.g_ret_sts_error;
397: fnd_msg_pub.Count_And_Get
398: ( p_count => x_msg_count,
399: p_data => x_msg_data
400: );
401: RETURN;
420: ( application => 'EAM'
421: , name => 'EAM_OPERABLE_INVALID'
422: );
423:
424: fnd_msg_pub.add;
425: x_return_status:= fnd_api.g_ret_sts_error;
426: fnd_msg_pub.Count_And_Get
427: ( p_count => x_msg_count,
428: p_data => x_msg_data
422: );
423:
424: fnd_msg_pub.add;
425: x_return_status:= fnd_api.g_ret_sts_error;
426: fnd_msg_pub.Count_And_Get
427: ( p_count => x_msg_count,
428: p_data => x_msg_data
429: );
430: RETURN;
448: ( application => 'EAM'
449: , name => 'EAM_RET_MAT_INVALID_REASON'
450: );
451:
452: fnd_msg_pub.add;
453: x_return_status:= fnd_api.g_ret_sts_error;
454: fnd_msg_pub.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
450: );
451:
452: fnd_msg_pub.add;
453: x_return_status:= fnd_api.g_ret_sts_error;
454: fnd_msg_pub.Count_And_Get
455: ( p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458: RETURN;
475: fnd_message.set_name
476: ( application => 'EAM'
477: , name => 'EAM_RI_INSTANCE_INVALID'
478: );
479: fnd_msg_pub.add;
480: x_return_status:= fnd_api.g_ret_sts_error;
481: fnd_msg_pub.Count_And_Get
482: ( p_count => x_msg_count,
483: p_data => x_msg_data
477: , name => 'EAM_RI_INSTANCE_INVALID'
478: );
479: fnd_msg_pub.add;
480: x_return_status:= fnd_api.g_ret_sts_error;
481: fnd_msg_pub.Count_And_Get
482: ( p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485: RETURN;
499: ( application => 'EAM'
500: , name => 'EAM_DOWNCODE_INVALID'
501: );
502:
503: fnd_msg_pub.add;
504: x_return_status:= fnd_api.g_ret_sts_error;
505: fnd_msg_pub.Count_And_Get
506: ( p_count => x_msg_count,
507: p_data => x_msg_data
501: );
502:
503: fnd_msg_pub.add;
504: x_return_status:= fnd_api.g_ret_sts_error;
505: fnd_msg_pub.Count_And_Get
506: ( p_count => x_msg_count,
507: p_data => x_msg_data
508: );
509: RETURN;
516: EXCEPTION
517: WHEN fnd_api.g_exc_error THEN
518: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
519: x_return_status := fnd_api.g_ret_sts_error;
520: fnd_msg_pub.count_and_get(
521: p_count => x_msg_count
522: ,p_data => x_msg_data);
523: WHEN fnd_api.g_exc_unexpected_error THEN
524: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
522: ,p_data => x_msg_data);
523: WHEN fnd_api.g_exc_unexpected_error THEN
524: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
525: x_return_status := fnd_api.g_ret_sts_unexp_error;
526: fnd_msg_pub.count_and_get(
527: p_count => x_msg_count
528: ,p_data => x_msg_data);
529: WHEN OTHERS THEN
530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
528: ,p_data => x_msg_data);
529: WHEN OTHERS THEN
530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: IF fnd_msg_pub.check_msg_level(
533: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
535: END IF;
536:
529: WHEN OTHERS THEN
530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: IF fnd_msg_pub.check_msg_level(
533: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
535: END IF;
536:
537: fnd_msg_pub.count_and_get(
530: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
531: x_return_status := fnd_api.g_ret_sts_unexp_error;
532: IF fnd_msg_pub.check_msg_level(
533: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
535: END IF;
536:
537: fnd_msg_pub.count_and_get(
538: p_count => x_msg_count,
533: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
534: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
535: END IF;
536:
537: fnd_msg_pub.count_and_get(
538: p_count => x_msg_count,
539: p_data => x_msg_data);
540:
541: END validate_event;
690: END IF;
691:
692: /* Initialize message list if p_init_msg_list is set to TRUE. */
693: IF FND_API.to_Boolean( p_init_msg_list ) THEN
694: fnd_msg_pub.initialize;
695: END IF;
696:
697: /* Initialize API return status to success */
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
709: ( application => 'EAM'
710: , name => 'EAM_INSTANCE_ID_INVALID'
711: );
712:
713: fnd_msg_pub.add;
714: x_return_status:= fnd_api.g_ret_sts_error;
715: fnd_msg_pub.Count_And_Get
716: ( p_count => x_msg_count,
717: p_data => x_msg_data
711: );
712:
713: fnd_msg_pub.add;
714: x_return_status:= fnd_api.g_ret_sts_error;
715: fnd_msg_pub.Count_And_Get
716: ( p_count => x_msg_count,
717: p_data => x_msg_data
718: );
719: null;
1142: END IF;
1143:
1144: -- Standard call to get message count and if count is 1, get message info.
1145:
1146: fnd_msg_pub.get
1147: ( p_msg_index_out => x_msg_count ,
1148: p_data => x_msg_data
1149: );
1150: EXCEPTION
1150: EXCEPTION
1151: WHEN FND_API.G_EXC_ERROR THEN
1152: ROLLBACK TO EAM_ASSET_LOG_PVT;
1153: x_return_status := FND_API.G_RET_STS_ERROR ;
1154: fnd_msg_pub.get
1155: ( p_msg_index_out => x_msg_count ,
1156: p_data => x_msg_data
1157: );
1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1157: );
1158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1159: ROLLBACK TO EAM_ASSET_LOG_PVT;
1160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1161: fnd_msg_pub.get
1162: ( p_msg_index_out => x_msg_count ,
1163: p_data => x_msg_data
1164: );
1165: WHEN OTHERS THEN
1165: WHEN OTHERS THEN
1166: ROLLBACK TO EAM_ASSET_LOG_PVT;
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168:
1169: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1170: fnd_msg_pub.add_exc_msg
1171: ( G_PKG_NAME ,
1172: l_api_name
1173: );
1166: ROLLBACK TO EAM_ASSET_LOG_PVT;
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168:
1169: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
1170: fnd_msg_pub.add_exc_msg
1171: ( G_PKG_NAME ,
1172: l_api_name
1173: );
1174: END IF;
1236: RAISE fnd_api.g_exc_unexpected_error;
1237: END IF;
1238:
1239: IF fnd_api.to_boolean(p_init_msg_list) THEN
1240: fnd_msg_pub.initialize;
1241: END IF;
1242:
1243: x_return_status := fnd_api.g_ret_sts_success;
1244: BEGIN
1255: ( application => 'EAM'
1256: , name => 'EAM_COUNTER_ID_INVALID'
1257: );
1258:
1259: fnd_msg_pub.add;
1260: x_return_status:= fnd_api.g_ret_sts_error;
1261: fnd_msg_pub.count_and_get(
1262: p_count => x_msg_count,
1263: p_data => x_msg_data);
1257: );
1258:
1259: fnd_msg_pub.add;
1260: x_return_status:= fnd_api.g_ret_sts_error;
1261: fnd_msg_pub.count_and_get(
1262: p_count => x_msg_count,
1263: p_data => x_msg_data);
1264: RETURN;
1265: END ;
1276: ( application => 'EAM'
1277: , name => 'EAM_COUNTER_ID_INVALID'
1278: );
1279:
1280: fnd_msg_pub.add;
1281: x_return_status:= fnd_api.g_ret_sts_error;
1282: fnd_msg_pub.count_and_get(
1283: p_count => x_msg_count,
1284: p_data => x_msg_data);
1278: );
1279:
1280: fnd_msg_pub.add;
1281: x_return_status:= fnd_api.g_ret_sts_error;
1282: fnd_msg_pub.count_and_get(
1283: p_count => x_msg_count,
1284: p_data => x_msg_data);
1285: RETURN;
1286: END ;
1330: IF fnd_api.to_boolean(p_commit) THEN
1331: COMMIT WORK;
1332: END IF;
1333:
1334: fnd_msg_pub.count_and_get(
1335: p_count => x_msg_count
1336: ,p_data => x_msg_data);
1337:
1338: EXCEPTION
1338: EXCEPTION
1339: WHEN fnd_api.g_exc_error THEN
1340: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1341: x_return_status := fnd_api.g_ret_sts_error;
1342: fnd_msg_pub.count_and_get(
1343: p_count => x_msg_count
1344: ,p_data => x_msg_data);
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1344: ,p_data => x_msg_data);
1345: WHEN fnd_api.g_exc_unexpected_error THEN
1346: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1347: x_return_status := fnd_api.g_ret_sts_unexp_error;
1348: fnd_msg_pub.count_and_get(
1349: p_count => x_msg_count
1350: ,p_data => x_msg_data);
1351: WHEN OTHERS THEN
1352: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1351: WHEN OTHERS THEN
1352: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1353: x_return_status := fnd_api.g_ret_sts_unexp_error;
1354:
1355: IF fnd_msg_pub.check_msg_level(
1356: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1357: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1358: END IF;
1359:
1352: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1353: x_return_status := fnd_api.g_ret_sts_unexp_error;
1354:
1355: IF fnd_msg_pub.check_msg_level(
1356: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1357: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1358: END IF;
1359:
1360: fnd_msg_pub.count_and_get(
1353: x_return_status := fnd_api.g_ret_sts_unexp_error;
1354:
1355: IF fnd_msg_pub.check_msg_level(
1356: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1357: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1358: END IF;
1359:
1360: fnd_msg_pub.count_and_get(
1361: p_count => x_msg_count,
1356: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1357: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1358: END IF;
1359:
1360: fnd_msg_pub.count_and_get(
1361: p_count => x_msg_count,
1362: p_data => x_msg_data);
1363:
1364: END insert_meter_log;