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 795: -- Standard check of p_commit.

791: ,p_instance_id => l_instance_rec.instance_id
792: );
793:
794: -- End of API body.
795: -- Standard check of p_commit.
796: IF fnd_api.to_boolean(p_commit) THEN
797: COMMIT WORK;
798: END IF;
799:

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

796: IF fnd_api.to_boolean(p_commit) THEN
797: COMMIT WORK;
798: END IF;
799:
800: -- Standard call to get message count and if count is 1, get message info.
801: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
802: EXCEPTION
803: WHEN fnd_api.g_exc_error THEN
804: ROLLBACK TO update_row;

Line 1150: -- Standard Start of API savepoint

1146: l_x_maint_msg_data varchar2(20000);
1147: l_mfg_serial_number_flag varchar2(1);
1148: l_instance_id number;
1149: begin
1150: -- Standard Start of API savepoint
1151: SAVEPOINT create_asset;
1152:
1153: -- Standard call to check for call compatibility.
1154: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1149: begin
1150: -- Standard Start of API savepoint
1151: SAVEPOINT create_asset;
1152:
1153: -- Standard call to check for call compatibility.
1154: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1155: RAISE fnd_api.g_exc_unexpected_error;
1156: END IF;
1157:

Line 1282: -- Standard check of p_commit.

1278:
1279: x_object_id := l_instance_id;
1280:
1281: -- End of API body.
1282: -- Standard check of p_commit.
1283: IF fnd_api.to_boolean(p_commit) THEN
1284: COMMIT WORK;
1285: END IF;
1286:

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

1283: IF fnd_api.to_boolean(p_commit) THEN
1284: COMMIT WORK;
1285: END IF;
1286:
1287: -- Standard call to get message count and if count is 1, get message info.
1288: fnd_msg_pub.count_and_get(
1289: p_count => x_msg_count
1290: ,p_data => x_msg_data);
1291:

Line 1413: -- Standard Start of API savepoint

1409: l_owning_department_id number;
1410: l_accounting_class_code varchar2(10);
1411: l_area_id number;
1412: BEGIN
1413: -- Standard Start of API savepoint
1414: SAVEPOINT update_asset;
1415:
1416: -- Standard call to check for call compatibility.
1417: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1412: BEGIN
1413: -- Standard Start of API savepoint
1414: SAVEPOINT update_asset;
1415:
1416: -- Standard call to check for call compatibility.
1417: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1418: RAISE fnd_api.g_exc_unexpected_error;
1419: END IF;
1420:

Line 1629: -- Standard check of p_commit.

1625:
1626: end if;
1627:
1628: -- End of API body.
1629: -- Standard check of p_commit.
1630: IF fnd_api.to_boolean(p_commit) THEN
1631: COMMIT WORK;
1632: END IF;
1633:

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

1631: COMMIT WORK;
1632: END IF;
1633:
1634:
1635: -- Standard call to get message count and if count is 1, get message info.
1636: fnd_msg_pub.count_and_get(
1637: p_count => x_msg_count
1638: ,p_data => x_msg_data);
1639:

Line 1691: -- Standard Start of API savepoint

1687: l_serial_number_type number;
1688: l_count number;
1689: BEGIN
1690:
1691: -- Standard Start of API savepoint
1692: SAVEPOINT serial_check;
1693:
1694: -- Standard call to check for call compatibility.
1695: IF NOT fnd_api.compatible_api_call(

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

1690:
1691: -- Standard Start of API savepoint
1692: SAVEPOINT serial_check;
1693:
1694: -- Standard call to check for call compatibility.
1695: IF NOT fnd_api.compatible_api_call(
1696: l_api_version
1697: ,p_api_version
1698: ,l_api_name

Line 1754: -- Standard check of p_commit.

1750:
1751:
1752:
1753: -- End of API body.
1754: -- Standard check of p_commit.
1755: IF fnd_api.to_boolean(p_commit) THEN
1756: COMMIT WORK;
1757: END IF;
1758:

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

1755: IF fnd_api.to_boolean(p_commit) THEN
1756: COMMIT WORK;
1757: END IF;
1758:
1759: -- Standard call to get message count and if count is 1, get message info.
1760: fnd_msg_pub.count_and_get(
1761: p_count => x_msg_count
1762: ,p_data => x_msg_data);
1763: