DBA Data[Home] [Help]

APPS.EAM_ASSET_ATTR_PVT dependencies on FND_MSG_PUB

Line 165: fnd_msg_pub.initialize;

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;

Line 327: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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;

Line 332: 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;
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(

Line 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;

Line 343: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 344: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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:

Line 347: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:

Line 439: fnd_msg_pub.initialize;

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;

Line 617: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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;

Line 622: 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;
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(

Line 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;

Line 633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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:

Line 637: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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(

Line 716: fnd_msg_pub.initialize;

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;

Line 796: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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;

Line 801: 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;
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(

Line 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;

Line 812: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 813: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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:

Line 816: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:

Line 849: fnd_msg_pub.initialize;

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;

Line 882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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;

Line 887: 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;
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(

Line 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;

Line 898: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 899: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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:

Line 902: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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:

Line 947: fnd_msg_pub.initialize;

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;

Line 1114: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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;

Line 1119: 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;
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(

Line 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;

Line 1130: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 1131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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:

Line 1134: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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;