132: l_user_id Number;
133: l_login_id Number;
134:
135: BEGIN
136: --Standard Start of API SAVEPOINT
137: SAVEPOINT SKILL_SP;
138:
139: x_return_status := fnd_api.g_ret_sts_success;
140:
137: SAVEPOINT SKILL_SP;
138:
139: x_return_status := fnd_api.g_ret_sts_success;
140:
141: --Standard Call to check API compatibility
142: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
143: THEN
144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
202: X_LAST_UPDATED_BY => l_user_id,
203: X_LAST_UPDATE_LOGIN => 0);
204:
205: x_skill_level_id := l_skill_level_id;
206: --standard commit
207: IF fnd_api.to_boolean (p_commit)
208: THEN
209: COMMIT WORK;
210: END IF;
319: l_login_id Number;
320: x_skill_level_id number;
321:
322: BEGIN
323: --Standard Start of API SAVEPOINT
324: SAVEPOINT SKILL_LEVELS_SP;
325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:
324: SAVEPOINT SKILL_LEVELS_SP;
325:
326: x_return_status := fnd_api.g_ret_sts_success;
327:
328: --Standard Call to check API compatibility
329: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
330: THEN
331: RAISE FND_API.G_EXC_ERROR;
332: END IF;
625: l_msg_count NUMBER;
626: l_msg_data VARCHAR2(200);
627:
628: BEGIN
629: --Standard Start of API SAVEPOINT
630: SAVEPOINT SKILL_LEVELS_SP;
631:
632: x_return_status := fnd_api.g_ret_sts_success;
633:
630: SAVEPOINT SKILL_LEVELS_SP;
631:
632: x_return_status := fnd_api.g_ret_sts_success;
633:
634: --Standard Call to check API compatibility
635: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
636: THEN
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;