DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on STANDARD

Line 209: -- Standard Start of API savepoint

205:
206: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
207: l_api_version CONSTANT NUMBER := 1.0;
208: begin
209: -- Standard Start of API savepoint
210: SAVEPOINT insert_row;
211:
212: -- Standard call to check for call compatibility.
213: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 212: -- Standard call to check for call compatibility.

208: begin
209: -- Standard Start of API savepoint
210: SAVEPOINT insert_row;
211:
212: -- Standard call to check for call compatibility.
213: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
214: RAISE fnd_api.g_exc_unexpected_error;
215: END IF;
216:

Line 408: -- Standard check of p_commit.

404: p_event => 'INSERT'
405: ,p_instance_id => l_instance_rec.instance_id
406: );
407:
408: -- Standard check of p_commit.
409: IF fnd_api.to_boolean(p_commit) THEN
410: COMMIT WORK;
411: END IF;
412:

Line 413: -- Standard call to get message count and if count is 1, get message info.

409: IF fnd_api.to_boolean(p_commit) THEN
410: COMMIT WORK;
411: END IF;
412:
413: -- Standard call to get message count and if count is 1, get message info.
414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
415: EXCEPTION
416: WHEN fnd_api.g_exc_error THEN
417: ROLLBACK TO insert_row;

Line 535: -- Standard Start of API savepoint

531: l_msg_index NUMBER;
532: l_msg_count NUMBER;
533: l_old_location_type_code varchar2(80);
534: begin
535: -- Standard Start of API savepoint
536: SAVEPOINT update_row;
537:
538: -- Standard call to check for call compatibility.
539: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 538: -- Standard call to check for call compatibility.

534: begin
535: -- Standard Start of API savepoint
536: SAVEPOINT update_row;
537:
538: -- Standard call to check for call compatibility.
539: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
540: RAISE fnd_api.g_exc_unexpected_error;
541: END IF;
542:

Line 801: -- Standard check of p_commit.

797: ,p_instance_id => l_instance_rec.instance_id
798: );
799:
800: -- End of API body.
801: -- Standard check of p_commit.
802: IF fnd_api.to_boolean(p_commit) THEN
803: COMMIT WORK;
804: END IF;
805:

Line 806: -- Standard call to get message count and if count is 1, get message info.

802: IF fnd_api.to_boolean(p_commit) THEN
803: COMMIT WORK;
804: END IF;
805:
806: -- Standard call to get message count and if count is 1, get message info.
807: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
808: EXCEPTION
809: WHEN fnd_api.g_exc_error THEN
810: ROLLBACK TO update_row;

Line 1156: -- Standard Start of API savepoint

1152: l_x_maint_msg_data varchar2(20000);
1153: l_mfg_serial_number_flag varchar2(1);
1154: l_instance_id number;
1155: begin
1156: -- Standard Start of API savepoint
1157: SAVEPOINT create_asset;
1158:
1159: -- Standard call to check for call compatibility.
1160: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1159: -- Standard call to check for call compatibility.

1155: begin
1156: -- Standard Start of API savepoint
1157: SAVEPOINT create_asset;
1158:
1159: -- Standard call to check for call compatibility.
1160: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163:

Line 1288: -- Standard check of p_commit.

1284:
1285: x_object_id := l_instance_id;
1286:
1287: -- End of API body.
1288: -- Standard check of p_commit.
1289: IF fnd_api.to_boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292:

Line 1293: -- Standard call to get message count and if count is 1, get message info.

1289: IF fnd_api.to_boolean(p_commit) THEN
1290: COMMIT WORK;
1291: END IF;
1292:
1293: -- Standard call to get message count and if count is 1, get message info.
1294: fnd_msg_pub.count_and_get(
1295: p_count => x_msg_count
1296: ,p_data => x_msg_data);
1297:

Line 1421: -- Standard Start of API savepoint

1417: l_area_id number;
1418: cursor associations is
1419: select activity_association_id from mtl_eam_asset_activities WHERE maintenance_object_id=l_instance_id; -- bug 10093296
1420: BEGIN
1421: -- Standard Start of API savepoint
1422: SAVEPOINT update_asset;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1424: -- Standard call to check for call compatibility.

1420: BEGIN
1421: -- Standard Start of API savepoint
1422: SAVEPOINT update_asset;
1423:
1424: -- Standard call to check for call compatibility.
1425: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1426: RAISE fnd_api.g_exc_unexpected_error;
1427: END IF;
1428:

Line 1656: -- Standard check of p_commit.

1652:
1653: end if;
1654:
1655: -- End of API body.
1656: -- Standard check of p_commit.
1657: IF fnd_api.to_boolean(p_commit) THEN
1658: COMMIT WORK;
1659: END IF;
1660:

Line 1662: -- Standard call to get message count and if count is 1, get message info.

1658: COMMIT WORK;
1659: END IF;
1660:
1661:
1662: -- Standard call to get message count and if count is 1, get message info.
1663: fnd_msg_pub.count_and_get(
1664: p_count => x_msg_count
1665: ,p_data => x_msg_data);
1666:

Line 1718: -- Standard Start of API savepoint

1714: l_serial_number_type number;
1715: l_count number;
1716: BEGIN
1717:
1718: -- Standard Start of API savepoint
1719: SAVEPOINT serial_check;
1720:
1721: -- Standard call to check for call compatibility.
1722: IF NOT fnd_api.compatible_api_call(

Line 1721: -- Standard call to check for call compatibility.

1717:
1718: -- Standard Start of API savepoint
1719: SAVEPOINT serial_check;
1720:
1721: -- Standard call to check for call compatibility.
1722: IF NOT fnd_api.compatible_api_call(
1723: l_api_version
1724: ,p_api_version
1725: ,l_api_name

Line 1781: -- Standard check of p_commit.

1777:
1778:
1779:
1780: -- End of API body.
1781: -- Standard check of p_commit.
1782: IF fnd_api.to_boolean(p_commit) THEN
1783: COMMIT WORK;
1784: END IF;
1785:

Line 1786: -- Standard call to get message count and if count is 1, get message info.

1782: IF fnd_api.to_boolean(p_commit) THEN
1783: COMMIT WORK;
1784: END IF;
1785:
1786: -- Standard call to get message count and if count is 1, get message info.
1787: fnd_msg_pub.count_and_get(
1788: p_count => x_msg_count
1789: ,p_data => x_msg_data);
1790: