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