161: END IF;
162:
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF fnd_api.to_boolean(p_init_msg_list) THEN
165: fnd_msg_pub.initialize;
166: END IF;
167:
168: -- Initialize API return status to success
169: x_return_status := fnd_api.g_ret_sts_success;
323: COMMIT WORK;
324: END IF;
325:
326: -- Standard call to get message count and if count is 1, get message info.
327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO eam_asset_attr;
331: x_return_status := fnd_api.g_ret_sts_error;
328: EXCEPTION
329: WHEN fnd_api.g_exc_error THEN
330: ROLLBACK TO eam_asset_attr;
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
333: WHEN fnd_api.g_exc_unexpected_error THEN
334: ROLLBACK TO eam_asset_attr;
335: x_return_status := fnd_api.g_ret_sts_unexp_error;
336: fnd_msg_pub.count_and_get(
332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
333: WHEN fnd_api.g_exc_unexpected_error THEN
334: ROLLBACK TO eam_asset_attr;
335: x_return_status := fnd_api.g_ret_sts_unexp_error;
336: fnd_msg_pub.count_and_get(
337: p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN OTHERS THEN
340: ROLLBACK TO eam_asset_attr;
339: WHEN OTHERS THEN
340: ROLLBACK TO eam_asset_attr;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342:
343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
345: END IF;
346:
347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
340: ROLLBACK TO eam_asset_attr;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342:
343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
345: END IF;
346:
347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
348:
343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
345: END IF;
346:
347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
348:
349: END Insert_Row;
350:
351:
435: END IF;
436:
437: -- Initialize message list if p_init_msg_list is set to TRUE.
438: IF fnd_api.to_boolean(p_init_msg_list) THEN
439: fnd_msg_pub.initialize;
440: END IF;
441:
442: -- Initialize API return status to success
443: x_return_status := fnd_api.g_ret_sts_success;
613: COMMIT WORK;
614: END IF;
615:
616: -- Standard call to get message count and if count is 1, get message info.
617: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
618: EXCEPTION
619: WHEN fnd_api.g_exc_error THEN
620: ROLLBACK TO eam_asset_attr;
621: x_return_status := fnd_api.g_ret_sts_error;
618: EXCEPTION
619: WHEN fnd_api.g_exc_error THEN
620: ROLLBACK TO eam_asset_attr;
621: x_return_status := fnd_api.g_ret_sts_error;
622: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: ROLLBACK TO eam_asset_attr;
625: x_return_status := fnd_api.g_ret_sts_unexp_error;
626: fnd_msg_pub.count_and_get(
622: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: ROLLBACK TO eam_asset_attr;
625: x_return_status := fnd_api.g_ret_sts_unexp_error;
626: fnd_msg_pub.count_and_get(
627: p_count => x_msg_count
628: ,p_data => x_msg_data);
629: WHEN OTHERS THEN
630: ROLLBACK TO eam_asset_attr;
629: WHEN OTHERS THEN
630: ROLLBACK TO eam_asset_attr;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632:
633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
635: END IF;
636:
637: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
630: ROLLBACK TO eam_asset_attr;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632:
633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
635: END IF;
636:
637: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
638:
633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
635: END IF;
636:
637: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
638:
639: END Lock_Row;
640:
641: PROCEDURE UPDATE_ROW(
712: END IF;
713:
714: -- Initialize message list if p_init_msg_list is set to TRUE.
715: IF fnd_api.to_boolean(p_init_msg_list) THEN
716: fnd_msg_pub.initialize;
717: END IF;
718:
719: -- Initialize API return status to success
720: x_return_status := fnd_api.g_ret_sts_success;
792: COMMIT WORK;
793: END IF;
794:
795: -- Standard call to get message count and if count is 1, get message info.
796: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
797: EXCEPTION
798: WHEN fnd_api.g_exc_error THEN
799: ROLLBACK TO eam_asset_attr;
800: x_return_status := fnd_api.g_ret_sts_error;
797: EXCEPTION
798: WHEN fnd_api.g_exc_error THEN
799: ROLLBACK TO eam_asset_attr;
800: x_return_status := fnd_api.g_ret_sts_error;
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: WHEN fnd_api.g_exc_unexpected_error THEN
803: ROLLBACK TO eam_asset_attr;
804: x_return_status := fnd_api.g_ret_sts_unexp_error;
805: fnd_msg_pub.count_and_get(
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: WHEN fnd_api.g_exc_unexpected_error THEN
803: ROLLBACK TO eam_asset_attr;
804: x_return_status := fnd_api.g_ret_sts_unexp_error;
805: fnd_msg_pub.count_and_get(
806: p_count => x_msg_count
807: ,p_data => x_msg_data);
808: WHEN OTHERS THEN
809: ROLLBACK TO eam_asset_attr;
808: WHEN OTHERS THEN
809: ROLLBACK TO eam_asset_attr;
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811:
812: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
813: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
814: END IF;
815:
816: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
809: ROLLBACK TO eam_asset_attr;
810: x_return_status := fnd_api.g_ret_sts_unexp_error;
811:
812: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
813: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
814: END IF;
815:
816: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
817:
812: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
813: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
814: END IF;
815:
816: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
817:
818: END Update_Row;
819:
820:
845: END IF;
846:
847: -- Initialize message list if p_init_msg_list is set to TRUE.
848: IF fnd_api.to_boolean(p_init_msg_list) THEN
849: fnd_msg_pub.initialize;
850: END IF;
851:
852: -- Initialize API return status to success
853: x_return_status := fnd_api.g_ret_sts_success;
878: COMMIT WORK;
879: END IF;
880:
881: -- Standard call to get message count and if count is 1, get message info.
882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
883: EXCEPTION
884: WHEN fnd_api.g_exc_error THEN
885: ROLLBACK TO eam_asset_attr;
886: x_return_status := fnd_api.g_ret_sts_error;
883: EXCEPTION
884: WHEN fnd_api.g_exc_error THEN
885: ROLLBACK TO eam_asset_attr;
886: x_return_status := fnd_api.g_ret_sts_error;
887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
888: WHEN fnd_api.g_exc_unexpected_error THEN
889: ROLLBACK TO eam_asset_attr;
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891: fnd_msg_pub.count_and_get(
887: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
888: WHEN fnd_api.g_exc_unexpected_error THEN
889: ROLLBACK TO eam_asset_attr;
890: x_return_status := fnd_api.g_ret_sts_unexp_error;
891: fnd_msg_pub.count_and_get(
892: p_count => x_msg_count
893: ,p_data => x_msg_data);
894: WHEN OTHERS THEN
895: ROLLBACK TO eam_asset_attr;
894: WHEN OTHERS THEN
895: ROLLBACK TO eam_asset_attr;
896: x_return_status := fnd_api.g_ret_sts_unexp_error;
897:
898: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
899: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
895: ROLLBACK TO eam_asset_attr;
896: x_return_status := fnd_api.g_ret_sts_unexp_error;
897:
898: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
899: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903:
898: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
899: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
900: END IF;
901:
902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
903:
904: END Delete_Row;
905:
906:
943: END IF;
944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF fnd_api.to_boolean(p_init_msg_list) THEN
947: fnd_msg_pub.initialize;
948: END IF;
949:
950: -- Initialize API return status to success
951: x_return_status := fnd_api.g_ret_sts_success;
1110: COMMIT WORK;
1111: END IF;
1112:
1113: -- Standard call to get message count and if count is 1, get message info.
1114: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1115: EXCEPTION
1116: WHEN fnd_api.g_exc_error THEN
1117: ROLLBACK TO copy_attr;
1118: x_return_status := fnd_api.g_ret_sts_error;
1115: EXCEPTION
1116: WHEN fnd_api.g_exc_error THEN
1117: ROLLBACK TO copy_attr;
1118: x_return_status := fnd_api.g_ret_sts_error;
1119: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: ROLLBACK TO copy_attr;
1122: x_return_status := fnd_api.g_ret_sts_unexp_error;
1123: fnd_msg_pub.count_and_get(
1119: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: ROLLBACK TO copy_attr;
1122: x_return_status := fnd_api.g_ret_sts_unexp_error;
1123: fnd_msg_pub.count_and_get(
1124: p_count => x_msg_count
1125: ,p_data => x_msg_data);
1126: WHEN OTHERS THEN
1127: ROLLBACK TO copy_attr;
1126: WHEN OTHERS THEN
1127: ROLLBACK TO copy_attr;
1128: x_return_status := fnd_api.g_ret_sts_unexp_error;
1129:
1130: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1132: END IF;
1133:
1134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1127: ROLLBACK TO copy_attr;
1128: x_return_status := fnd_api.g_ret_sts_unexp_error;
1129:
1130: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1132: END IF;
1133:
1134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1135:
1130: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1132: END IF;
1133:
1134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1135:
1136: END COPY_ATTRIBUTE;
1137:
1138: END EAM_ASSET_ATTR_PVT;