eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SKILL_LEVELS_PUB dependencies on FND_API

Line 39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

35: based on input values passed by calling routines. */
36:
37: PROCEDURE create_skills
38: (P_API_VERSION IN NUMBER,
39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
42: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,

Line 40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

36:
37: PROCEDURE create_skills
38: (P_API_VERSION IN NUMBER,
39: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE,
42: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE,
43: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT NULL,
44: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 86: x_return_status := fnd_api.g_ret_sts_success;

82: BEGIN
83: --Standard Start of API SAVEPOINT
84: SAVEPOINT CREATE_SKILL_LEVELS_SP;
85:
86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: --Standard Call to check API compatibility
89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
90: THEN

Line 89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

85:
86: x_return_status := fnd_api.g_ret_sts_success;
87:
88: --Standard Call to check API compatibility
89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:

Line 91: RAISE FND_API.G_EXC_ERROR;

87:
88: --Standard Call to check API compatibility
89: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
95: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 95: IF FND_API.To_boolean(P_INIT_MSG_LIST)

91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
95: IF FND_API.To_boolean(P_INIT_MSG_LIST)
96: THEN
97: FND_MSG_PUB.Initialize;
98: END IF;
99:

Line 136: IF fnd_api.to_boolean (p_commit)

132: X_MSG_DATA := l_msg_data;
133:
134:
135: --standard commit
136: IF fnd_api.to_boolean (p_commit)
137: THEN
138: COMMIT WORK;
139: END IF;
140:

Line 144: WHEN fnd_api.g_exc_unexpected_error

140:
141: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
142:
143: EXCEPTION
144: WHEN fnd_api.g_exc_unexpected_error
145: THEN
146:
147: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 149: WHEN fnd_api.g_exc_error

145: THEN
146:
147: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
149: WHEN fnd_api.g_exc_error
150: THEN
151: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
152: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
153: WHEN OTHERS

Line 161: x_return_status := fnd_api.g_ret_sts_unexp_error;

157: fnd_message.set_token('P_SQLCODE',SQLCODE);
158: fnd_message.set_token('P_SQLERRM',SQLERRM);
159: fnd_message.set_token('P_API_NAME', l_api_name);
160: FND_MSG_PUB.add;
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
163:
164: END CREATE_SKILLS;
165:

Line 172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

168: based on input values passed by calling routines. */
169:
170: PROCEDURE update_skills
171: (P_API_VERSION IN NUMBER,
172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

169:
170: PROCEDURE update_skills
171: (P_API_VERSION IN NUMBER,
172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,

171: (P_API_VERSION IN NUMBER,
172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

172: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

173: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
174: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL_ID%TYPE,
175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

175: P_SKILL_LEVEL IN JTF_RS_SKILL_LEVELS_B.SKILL_LEVEL%TYPE DEFAULT FND_API.G_MISS_NUM,
176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

176: P_LEVEL_NAME IN JTF_RS_SKILL_LEVELS_TL.LEVEL_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

177: P_LEVEL_DESC IN JTF_RS_SKILL_LEVELS_TL.LEVEL_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

178: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

179: P_ATTRIBUTE1 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

180: P_ATTRIBUTE2 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

181: P_ATTRIBUTE3 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

182: P_ATTRIBUTE4 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

183: P_ATTRIBUTE5 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

184: P_ATTRIBUTE6 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

185: P_ATTRIBUTE7 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

186: P_ATTRIBUTE8 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

187: P_ATTRIBUTE9 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

188: P_ATTRIBUTE10 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
196: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

189: P_ATTRIBUTE11 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
196: X_MSG_COUNT OUT NOCOPY NUMBER,
197: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

190: P_ATTRIBUTE12 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE13 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE14 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE15 IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE_CATEGORY IN JTF_RS_SKILL_LEVELS_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
196: X_MSG_COUNT OUT NOCOPY NUMBER,
197: X_MSG_DATA OUT NOCOPY VARCHAR2
198: ) IS

Line 217: x_return_status := fnd_api.g_ret_sts_success;

213: BEGIN
214: --Standard Start of API SAVEPOINT
215: SAVEPOINT UPDATE_SKILL_LEVELS_SP;
216:
217: x_return_status := fnd_api.g_ret_sts_success;
218:
219: --Standard Call to check API compatibility
220: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
221: THEN

Line 220: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

216:
217: x_return_status := fnd_api.g_ret_sts_success;
218:
219: --Standard Call to check API compatibility
220: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
221: THEN
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224:

Line 222: RAISE FND_API.G_EXC_ERROR;

218:
219: --Standard Call to check API compatibility
220: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
221: THEN
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224:
225: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
226: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 226: IF FND_API.To_boolean(P_INIT_MSG_LIST)

222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224:
225: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
226: IF FND_API.To_boolean(P_INIT_MSG_LIST)
227: THEN
228: FND_MSG_PUB.Initialize;
229: END IF;
230:

Line 267: IF fnd_api.to_boolean (p_commit)

263: X_MSG_DATA := l_msg_data;
264: P_OBJECT_VERSION_NUM := l_object_version_number;
265:
266:
267: IF fnd_api.to_boolean (p_commit)
268: THEN
269: COMMIT WORK;
270: END IF;
271:

Line 275: WHEN fnd_api.g_exc_error

271:
272: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
273:
274: EXCEPTION
275: WHEN fnd_api.g_exc_error
276: THEN
277: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
278: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
279:

Line 280: WHEN fnd_api.g_exc_unexpected_error

276: THEN
277: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
278: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
279:
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 283: x_return_status := fnd_api.g_ret_sts_unexp_error;

279:
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
285: WHEN OTHERS
286: THEN
287: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;

Line 293: x_return_status := fnd_api.g_ret_sts_unexp_error;

289: fnd_message.set_token('P_SQLCODE',SQLCODE);
290: fnd_message.set_token('P_SQLERRM',SQLERRM);
291: fnd_message.set_token('P_API_NAME',l_api_name);
292: FND_MSG_PUB.add;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
295: END update_skills;
296:
297:

Line 300: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

296:
297:
298: PROCEDURE delete_skills
299: (P_API_VERSION IN NUMBER,
300: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
303: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
304: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 301: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

297:
298: PROCEDURE delete_skills
299: (P_API_VERSION IN NUMBER,
300: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
301: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
302: P_SKILL_LEVEL_ID IN JTF_RS_SKILL_LEVELS_B.skill_level_id%TYPE,
303: P_OBJECT_VERSION_NUM IN JTF_RS_SKILL_LEVELS_B.OBJECT_VERSION_NUMBER%TYPE,
304: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
305: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 326: x_return_status := fnd_api.g_ret_sts_success;

322: BEGIN
323: --Standard Start of API SAVEPOINT
324: SAVEPOINT DELETE_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

Line 329: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

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_UNEXPECTED_ERROR;
332: END IF;
333:

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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_UNEXPECTED_ERROR;
332: END IF;
333:
334: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
335: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 335: IF FND_API.To_boolean(P_INIT_MSG_LIST)

331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
335: IF FND_API.To_boolean(P_INIT_MSG_LIST)
336: THEN
337: FND_MSG_PUB.Initialize;
338: END IF;
339:

Line 356: IF fnd_api.to_boolean (p_commit)

352: X_RETURN_STATUS := l_return_status;
353: X_MSG_COUNT := l_msg_count;
354: X_MSG_DATA := l_msg_data;
355:
356: IF fnd_api.to_boolean (p_commit)
357: THEN
358: COMMIT WORK;
359: END IF;
360:

Line 364: WHEN fnd_api.g_exc_unexpected_error

360:
361: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
362:
363: EXCEPTION
364: WHEN fnd_api.g_exc_unexpected_error
365: THEN
366: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
367: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
368: WHEN fnd_api.g_exc_error

Line 368: WHEN fnd_api.g_exc_error

364: WHEN fnd_api.g_exc_unexpected_error
365: THEN
366: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
367: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
368: WHEN fnd_api.g_exc_error
369: THEN
370: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
371: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
372: WHEN OTHERS

Line 380: x_return_status := fnd_api.g_ret_sts_unexp_error;

376: fnd_message.set_token('P_SQLCODE',SQLCODE);
377: fnd_message.set_token('P_SQLERRM',SQLERRM);
378: fnd_message.set_token('P_API_NAME',l_api_name);
379: FND_MSG_PUB.add;
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
382:
383: END delete_skills;
384: