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;
685: END IF;
686:
687: /* Initialize message list if p_init_msg_list is set to TRUE. */
688: IF FND_API.to_Boolean( p_init_msg_list ) THEN
689: fnd_msg_pub.initialize;
690: END IF;
691:
692: /* Initialize API return status to success */
693: x_return_status := FND_API.G_RET_STS_SUCCESS;
704: ( application => 'EAM'
705: , name => 'EAM_INSTANCE_ID_INVALID'
706: );
707:
708: fnd_msg_pub.add;
709: x_return_status:= fnd_api.g_ret_sts_error;
710: fnd_msg_pub.Count_And_Get
711: ( p_count => x_msg_count,
712: p_data => x_msg_data
706: );
707:
708: fnd_msg_pub.add;
709: x_return_status:= fnd_api.g_ret_sts_error;
710: fnd_msg_pub.Count_And_Get
711: ( p_count => x_msg_count,
712: p_data => x_msg_data
713: );
714: null;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.
801:
802: fnd_msg_pub.get
803: ( p_msg_index_out => x_msg_count ,
804: p_data => x_msg_data
805: );
806: EXCEPTION
806: EXCEPTION
807: WHEN FND_API.G_EXC_ERROR THEN
808: ROLLBACK TO EAM_ASSET_LOG_PVT;
809: x_return_status := FND_API.G_RET_STS_ERROR ;
810: fnd_msg_pub.get
811: ( p_msg_index_out => x_msg_count ,
812: p_data => x_msg_data
813: );
814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: );
814: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
815: ROLLBACK TO EAM_ASSET_LOG_PVT;
816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
817: fnd_msg_pub.get
818: ( p_msg_index_out => x_msg_count ,
819: p_data => x_msg_data
820: );
821: WHEN OTHERS THEN
821: WHEN OTHERS THEN
822: ROLLBACK TO EAM_ASSET_LOG_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824:
825: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
826: fnd_msg_pub.add_exc_msg
827: ( G_PKG_NAME ,
828: l_api_name
829: );
822: ROLLBACK TO EAM_ASSET_LOG_PVT;
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824:
825: IF fnd_msg_pub.Check_Msg_Level(fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
826: fnd_msg_pub.add_exc_msg
827: ( G_PKG_NAME ,
828: l_api_name
829: );
830: END IF;
892: RAISE fnd_api.g_exc_unexpected_error;
893: END IF;
894:
895: IF fnd_api.to_boolean(p_init_msg_list) THEN
896: fnd_msg_pub.initialize;
897: END IF;
898:
899: x_return_status := fnd_api.g_ret_sts_success;
900: BEGIN
911: ( application => 'EAM'
912: , name => 'EAM_COUNTER_ID_INVALID'
913: );
914:
915: fnd_msg_pub.add;
916: x_return_status:= fnd_api.g_ret_sts_error;
917: fnd_msg_pub.count_and_get(
918: p_count => x_msg_count,
919: p_data => x_msg_data);
913: );
914:
915: fnd_msg_pub.add;
916: x_return_status:= fnd_api.g_ret_sts_error;
917: fnd_msg_pub.count_and_get(
918: p_count => x_msg_count,
919: p_data => x_msg_data);
920: RETURN;
921: END ;
932: ( application => 'EAM'
933: , name => 'EAM_COUNTER_ID_INVALID'
934: );
935:
936: fnd_msg_pub.add;
937: x_return_status:= fnd_api.g_ret_sts_error;
938: fnd_msg_pub.count_and_get(
939: p_count => x_msg_count,
940: p_data => x_msg_data);
934: );
935:
936: fnd_msg_pub.add;
937: x_return_status:= fnd_api.g_ret_sts_error;
938: fnd_msg_pub.count_and_get(
939: p_count => x_msg_count,
940: p_data => x_msg_data);
941: RETURN;
942: END ;
986: IF fnd_api.to_boolean(p_commit) THEN
987: COMMIT WORK;
988: END IF;
989:
990: fnd_msg_pub.count_and_get(
991: p_count => x_msg_count
992: ,p_data => x_msg_data);
993:
994: EXCEPTION
994: EXCEPTION
995: WHEN fnd_api.g_exc_error THEN
996: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
997: x_return_status := fnd_api.g_ret_sts_error;
998: fnd_msg_pub.count_and_get(
999: p_count => x_msg_count
1000: ,p_data => x_msg_data);
1001: WHEN fnd_api.g_exc_unexpected_error THEN
1002: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1000: ,p_data => x_msg_data);
1001: WHEN fnd_api.g_exc_unexpected_error THEN
1002: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1003: x_return_status := fnd_api.g_ret_sts_unexp_error;
1004: fnd_msg_pub.count_and_get(
1005: p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007: WHEN OTHERS THEN
1008: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1007: WHEN OTHERS THEN
1008: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010:
1011: IF fnd_msg_pub.check_msg_level(
1012: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1013: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1014: END IF;
1015:
1008: ROLLBACK TO EAM_ASSET_LOG_PVT_SV;
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010:
1011: IF fnd_msg_pub.check_msg_level(
1012: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1013: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1014: END IF;
1015:
1016: fnd_msg_pub.count_and_get(
1009: x_return_status := fnd_api.g_ret_sts_unexp_error;
1010:
1011: IF fnd_msg_pub.check_msg_level(
1012: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1013: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1014: END IF;
1015:
1016: fnd_msg_pub.count_and_get(
1017: p_count => x_msg_count,
1012: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1013: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1014: END IF;
1015:
1016: fnd_msg_pub.count_and_get(
1017: p_count => x_msg_count,
1018: p_data => x_msg_data);
1019:
1020: END insert_meter_log;