DBA Data[Home] [Help]

APPS.INV_EAM_ASSET_NUMBER_PVT dependencies on STANDARD

Line 92: -- Standard Start of API savepoint

88: l_serial_number_type number;
89: l_count number;
90: BEGIN
91:
92: -- Standard Start of API savepoint
93: SAVEPOINT serial_check;
94:
95: -- Standard call to check for call compatibility.
96: IF NOT fnd_api.compatible_api_call(

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

91:
92: -- Standard Start of API savepoint
93: SAVEPOINT serial_check;
94:
95: -- Standard call to check for call compatibility.
96: IF NOT fnd_api.compatible_api_call(
97: l_api_version
98: ,p_api_version
99: ,l_api_name

Line 155: -- Standard check of p_commit.

151:
152:
153:
154: -- End of API body.
155: -- Standard check of p_commit.
156: IF fnd_api.to_boolean(p_commit) THEN
157: COMMIT WORK;
158: END IF;
159:

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

156: IF fnd_api.to_boolean(p_commit) THEN
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:

Line 350: -- Standard Start of API savepoint

346: AND current_organization_id = P_ORGANIZATION_ID;
347:
348: BEGIN
349:
350: -- Standard Start of API savepoint
351: SAVEPOINT insert_row;
352:
353: -- Standard call to check for call compatibility.
354: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

349:
350: -- Standard Start of API savepoint
351: SAVEPOINT insert_row;
352:
353: -- Standard call to check for call compatibility.
354: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
355: RAISE fnd_api.g_exc_unexpected_error;
356: END IF;
357:

Line 649: -- Standard check of p_commit.

645: end if;
646: CLOSE C;
647:
648: -- End of API body.
649: -- Standard check of p_commit.
650: IF fnd_api.to_boolean(p_commit) THEN
651: COMMIT WORK;
652: END IF;
653:

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

650: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 821: -- Standard Start of API savepoint

817: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
818: l_api_version CONSTANT NUMBER := 1.0;
819: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
820: BEGIN
821: -- Standard Start of API savepoint
822: SAVEPOINT update_row;
823:
824: -- Standard call to check for call compatibility.
825: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

820: BEGIN
821: -- Standard Start of API savepoint
822: SAVEPOINT update_row;
823:
824: -- Standard call to check for call compatibility.
825: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
826: RAISE fnd_api.g_exc_unexpected_error;
827: END IF;
828:

Line 990: -- Standard check of p_commit.

986: Raise NO_DATA_FOUND;
987: end if;
988:
989: -- End of API body.
990: -- Standard check of p_commit.
991: IF fnd_api.to_boolean(p_commit) THEN
992: COMMIT WORK;
993: END IF;
994:

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

991: IF fnd_api.to_boolean(p_commit) THEN
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;

Line 1084: -- Standard Start of API savepoint

1080: Recinfo C%ROWTYPE;
1081:
1082: BEGIN
1083:
1084: -- Standard Start of API savepoint
1085: SAVEPOINT lock_row;
1086:
1087: -- Standard call to check for call compatibility.
1088: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1083:
1084: -- Standard Start of API savepoint
1085: SAVEPOINT lock_row;
1086:
1087: -- Standard call to check for call compatibility.
1088: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1089: RAISE fnd_api.g_exc_unexpected_error;
1090: END IF;
1091:

Line 1233: -- Standard check of p_commit.

1229: APP_EXCEPTION.Raise_Exception;
1230: end if;
1231:
1232: -- End of API body.
1233: -- Standard check of p_commit.
1234: IF fnd_api.to_boolean(p_commit) THEN
1235: COMMIT WORK;
1236: END IF;
1237:

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

1234: IF fnd_api.to_boolean(p_commit) THEN
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;