DBA Data[Home] [Help]

APPS.INV_EAM_ASSET_NUMBER_PVT dependencies on FND_MSG_PUB

Line 106: fnd_msg_pub.initialize;

102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF fnd_api.to_boolean(p_init_msg_list) THEN
106: fnd_msg_pub.initialize;
107: END IF;
108:
109: -- Initialize API return status to success
110: x_return_status := fnd_api.g_ret_sts_success;

Line 161: fnd_msg_pub.count_and_get(

157: COMMIT WORK;
158: END IF;
159:
160: -- Standard call to get message count and if count is 1, get message info.
161: fnd_msg_pub.count_and_get(
162: p_count => x_msg_count
163: ,p_data => x_msg_data);
164:
165:

Line 170: fnd_msg_pub.count_and_get(

166: EXCEPTION
167: WHEN fnd_api.g_exc_error THEN
168: ROLLBACK TO serial_check;
169: x_return_status := fnd_api.g_ret_sts_error;
170: fnd_msg_pub.count_and_get(
171: p_count => x_msg_count
172: ,p_data => x_msg_data);
173: WHEN fnd_api.g_exc_unexpected_error THEN
174: ROLLBACK TO serial_check;

Line 176: fnd_msg_pub.count_and_get(

172: ,p_data => x_msg_data);
173: WHEN fnd_api.g_exc_unexpected_error THEN
174: ROLLBACK TO serial_check;
175: x_return_status := fnd_api.g_ret_sts_unexp_error;
176: fnd_msg_pub.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN OTHERS THEN
180: ROLLBACK TO serial_check;

Line 183: IF fnd_msg_pub.check_msg_level(

179: WHEN OTHERS THEN
180: ROLLBACK TO serial_check;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182:
183: IF fnd_msg_pub.check_msg_level(
184: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
186: END IF;
187:

Line 184: fnd_msg_pub.g_msg_lvl_unexp_error) THEN

180: ROLLBACK TO serial_check;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182:
183: IF fnd_msg_pub.check_msg_level(
184: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
186: END IF;
187:
188: fnd_msg_pub.count_and_get(

Line 185: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);

181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182:
183: IF fnd_msg_pub.check_msg_level(
184: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
186: END IF;
187:
188: fnd_msg_pub.count_and_get(
189: p_count => x_msg_count

Line 188: fnd_msg_pub.count_and_get(

184: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
185: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
186: END IF;
187:
188: fnd_msg_pub.count_and_get(
189: p_count => x_msg_count
190: ,p_data => x_msg_data);
191:
192: END SERIAL_CHECK;

Line 360: fnd_msg_pub.initialize;

356: END IF;
357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF fnd_api.to_boolean(p_init_msg_list) THEN
360: fnd_msg_pub.initialize;
361: END IF;
362:
363: -- Initialize API return status to success
364: x_return_status := fnd_api.g_ret_sts_success;

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

651: COMMIT WORK;
652: END IF;
653:
654: -- Standard call to get message count and if count is 1, get message info.
655: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
656: EXCEPTION
657: WHEN fnd_api.g_exc_error THEN
658: ROLLBACK TO insert_row;
659: x_return_status := fnd_api.g_ret_sts_error;

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

656: EXCEPTION
657: WHEN fnd_api.g_exc_error THEN
658: ROLLBACK TO insert_row;
659: x_return_status := fnd_api.g_ret_sts_error;
660: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
661: WHEN fnd_api.g_exc_unexpected_error THEN
662: ROLLBACK TO insert_row;
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: fnd_msg_pub.count_and_get(

Line 664: fnd_msg_pub.count_and_get(

660: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
661: WHEN fnd_api.g_exc_unexpected_error THEN
662: ROLLBACK TO insert_row;
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: fnd_msg_pub.count_and_get(
665: p_count => x_msg_count
666: ,p_data => x_msg_data);
667: WHEN OTHERS THEN
668: ROLLBACK TO insert_row;

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

667: WHEN OTHERS THEN
668: ROLLBACK TO insert_row;
669: x_return_status := fnd_api.g_ret_sts_unexp_error;
670:
671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
672: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
673: END IF;
674:
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

668: ROLLBACK TO insert_row;
669: x_return_status := fnd_api.g_ret_sts_unexp_error;
670:
671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
672: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
673: END IF;
674:
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676:

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

671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
672: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
673: END IF;
674:
675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
676:
677: END Insert_Row;
678:
679:

Line 831: fnd_msg_pub.initialize;

827: END IF;
828:
829: -- Initialize message list if p_init_msg_list is set to TRUE.
830: IF fnd_api.to_boolean(p_init_msg_list) THEN
831: fnd_msg_pub.initialize;
832: END IF;
833:
834: -- Initialize API return status to success
835: x_return_status := fnd_api.g_ret_sts_success;

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

992: COMMIT WORK;
993: END IF;
994:
995: -- Standard call to get message count and if count is 1, get message info.
996: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
997: EXCEPTION
998: WHEN fnd_api.g_exc_error THEN
999: ROLLBACK TO update_row;
1000: x_return_status := fnd_api.g_ret_sts_error;

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

997: EXCEPTION
998: WHEN fnd_api.g_exc_error THEN
999: ROLLBACK TO update_row;
1000: x_return_status := fnd_api.g_ret_sts_error;
1001: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: ROLLBACK TO update_row;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: fnd_msg_pub.count_and_get(

Line 1005: fnd_msg_pub.count_and_get(

1001: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: ROLLBACK TO update_row;
1004: x_return_status := fnd_api.g_ret_sts_unexp_error;
1005: fnd_msg_pub.count_and_get(
1006: p_count => x_msg_count
1007: ,p_data => x_msg_data);
1008: WHEN OTHERS THEN
1009: ROLLBACK TO update_row;

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

1008: WHEN OTHERS THEN
1009: ROLLBACK TO update_row;
1010: x_return_status := fnd_api.g_ret_sts_unexp_error;
1011:
1012: IF fnd_msg_pub.check_msg_level(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(p_count => x_msg_count, p_data => x_msg_data);

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

1009: ROLLBACK TO update_row;
1010: x_return_status := fnd_api.g_ret_sts_unexp_error;
1011:
1012: IF fnd_msg_pub.check_msg_level(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(p_count => x_msg_count, p_data => x_msg_data);
1017:

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

1012: IF fnd_msg_pub.check_msg_level(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(p_count => x_msg_count, p_data => x_msg_data);
1017:
1018: END Update_Row;
1019:
1020:

Line 1094: fnd_msg_pub.initialize;

1090: END IF;
1091:
1092: -- Initialize message list if p_init_msg_list is set to TRUE.
1093: IF fnd_api.to_boolean(p_init_msg_list) THEN
1094: fnd_msg_pub.initialize;
1095: END IF;
1096:
1097: -- Initialize API return status to success
1098: x_return_status := fnd_api.g_ret_sts_success;

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

1235: COMMIT WORK;
1236: END IF;
1237:
1238: -- Standard call to get message count and if count is 1, get message info.
1239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1240: EXCEPTION
1241: WHEN fnd_api.g_exc_error THEN
1242: ROLLBACK TO lock_row;
1243: x_return_status := fnd_api.g_ret_sts_error;

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

1240: EXCEPTION
1241: WHEN fnd_api.g_exc_error THEN
1242: ROLLBACK TO lock_row;
1243: x_return_status := fnd_api.g_ret_sts_error;
1244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1245: WHEN fnd_api.g_exc_unexpected_error THEN
1246: ROLLBACK TO lock_row;
1247: x_return_status := fnd_api.g_ret_sts_unexp_error;
1248: fnd_msg_pub.count_and_get(

Line 1248: fnd_msg_pub.count_and_get(

1244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1245: WHEN fnd_api.g_exc_unexpected_error THEN
1246: ROLLBACK TO lock_row;
1247: x_return_status := fnd_api.g_ret_sts_unexp_error;
1248: fnd_msg_pub.count_and_get(
1249: p_count => x_msg_count
1250: ,p_data => x_msg_data);
1251: WHEN OTHERS THEN
1252: ROLLBACK TO lock_row;

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

1251: WHEN OTHERS THEN
1252: ROLLBACK TO lock_row;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254:
1255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1257: END IF;
1258:
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1252: ROLLBACK TO lock_row;
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254:
1255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1257: END IF;
1258:
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260:

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

1255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1257: END IF;
1258:
1259: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1260:
1261: END Lock_Row;
1262:
1263: