DBA Data[Home] [Help]

APPS.JTF_RS_SKILL_LEVELS_PUB dependencies on FND_MSG_PUB

Line 97: FND_MSG_PUB.Initialize;

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:
100: JTF_RS_SKILL_LEVELS_PVT.CREATE_SKILLS(
101: P_API_VERSION => l_api_version,

Line 141: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

137: THEN
138: COMMIT WORK;
139: END IF;
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

Line 148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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);
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);

Line 152: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
154: THEN
155: ROLLBACK TO CREATE_SKILL_LEVELS_SP;
156: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 160: FND_MSG_PUB.add;

156: fnd_message.set_name ('JTF', 'JTF_RS_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;

Line 162: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
166:

Line 228: FND_MSG_PUB.Initialize;

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:
231: JTF_RS_SKILL_LEVELS_PVT.UPDATE_SKILLS(
232: P_API_VERSION => l_api_version,

Line 272: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

268: THEN
269: COMMIT WORK;
270: END IF;
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

Line 278: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
280: WHEN fnd_api.g_exc_unexpected_error
281: THEN
282: ROLLBACK TO UPDATE_SKILL_LEVELS_SP;

Line 284: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
288: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 292: FND_MSG_PUB.add;

288: fnd_message.set_name ('JTF', 'JTF_RS_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:

Line 294: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
298: PROCEDURE delete_skills

Line 337: FND_MSG_PUB.Initialize;

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:
340:
341: JTF_RS_SKILL_LEVELS_PVT.DELETE_SKILLS

Line 361: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

357: THEN
358: COMMIT WORK;
359: END IF;
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

Line 367: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
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);

Line 371: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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
373: THEN
374: ROLLBACK TO DELETE_SKILL_LEVELS_SP;
375: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 379: FND_MSG_PUB.add;

375: fnd_message.set_name ('JTF', 'JTF_RS_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;

Line 381: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
385: END jtf_rs_skill_levels_pub;