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_PVT dependencies on FND_API

Line 32: x_return_status := fnd_api.g_ret_sts_success;

28: skill_level_id <> ll_skill_level_id;
29:
30: skill_levels_rec chk_dup_skill%rowtype;
31: BEGIN
32: x_return_status := fnd_api.g_ret_sts_success;
33: open chk_dup_skill(p_skill_level, x_skill_level_id);
34: fetch chk_dup_skill into skill_levels_rec;
35: if (chk_dup_skill%NOTFOUND) then
36: close chk_dup_skill;

Line 39: x_return_status := fnd_api.g_ret_sts_error;

35: if (chk_dup_skill%NOTFOUND) then
36: close chk_dup_skill;
37: ELSIF chk_dup_skill%FOUND THEN
38: close chk_dup_skill;
39: x_return_status := fnd_api.g_ret_sts_error;
40: x_skill_level_id := skill_levels_rec.skill_level_id;
41: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL');
42: FND_MSG_PUB.add;
43: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 44: raise fnd_api.g_exc_error;

40: x_skill_level_id := skill_levels_rec.skill_level_id;
41: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL');
42: FND_MSG_PUB.add;
43: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
44: raise fnd_api.g_exc_error;
45: END IF;
46: END;
47:
48: PROCEDURE chk_dup_level_name(P_LEVEL_NAME IN VARCHAR2,

Line 65: x_return_status := fnd_api.g_ret_sts_success;

61: skill_level_id <> ll_skill_level_id;
62:
63: levels_vl_rec chk_dup_name%rowtype;
64: BEGIN
65: x_return_status := fnd_api.g_ret_sts_success;
66: open chk_dup_name(p_level_name, x_skill_level_id);
67: fetch chk_dup_name INTO levels_vl_rec;
68:
69: if chk_dup_name%NOTFOUND then

Line 73: x_return_status := fnd_api.g_ret_sts_error;

69: if chk_dup_name%NOTFOUND then
70: CLOSE chk_dup_name;
71: ELSIF chk_dup_name%FOUND THEN
72: CLOSE chk_dup_name;
73: x_return_status := fnd_api.g_ret_sts_error;
74: x_skill_level_id := levels_vl_rec.skill_level_id;
75: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL_NAME');
76: FND_MSG_PUB.add;
77: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 78: raise fnd_api.g_exc_error;

74: x_skill_level_id := levels_vl_rec.skill_level_id;
75: fnd_message.set_name ('JTF', 'JTF_RS_DUP_SKILL_LEVEL_NAME');
76: FND_MSG_PUB.add;
77: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
78: raise fnd_api.g_exc_error;
79: END IF;
80:
81: END chk_dup_level_name;
82:

Line 139: x_return_status := fnd_api.g_ret_sts_success;

135: BEGIN
136: --Standard Start of API SAVEPOINT
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

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

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

Line 144: RAISE FND_API.G_EXC_ERROR;

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;
146:
147: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
148: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 148: IF FND_API.To_boolean(P_INIT_MSG_LIST)

144: RAISE FND_API.G_EXC_ERROR;
145: END IF;
146:
147: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
148: IF FND_API.To_boolean(P_INIT_MSG_LIST)
149: THEN
150: FND_MSG_PUB.Initialize;
151: END IF;
152:

Line 207: IF fnd_api.to_boolean (p_commit)

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

Line 215: WHEN fnd_api.g_exc_unexpected_error

211:
212: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
213:
214: EXCEPTION
215: WHEN fnd_api.g_exc_unexpected_error
216: THEN
217: ROLLBACK TO SKILL_SP;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 218: x_return_status := fnd_api.g_ret_sts_unexp_error;

214: EXCEPTION
215: WHEN fnd_api.g_exc_unexpected_error
216: THEN
217: ROLLBACK TO SKILL_SP;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
220: WHEN fnd_api.g_exc_error
221: THEN
222: ROLLBACK TO SKILL_SP;

Line 220: WHEN fnd_api.g_exc_error

216: THEN
217: ROLLBACK TO SKILL_SP;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
220: WHEN fnd_api.g_exc_error
221: THEN
222: ROLLBACK TO SKILL_SP;
223: x_return_status := fnd_api.g_ret_sts_error;
224: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 223: x_return_status := fnd_api.g_ret_sts_error;

219: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
220: WHEN fnd_api.g_exc_error
221: THEN
222: ROLLBACK TO SKILL_SP;
223: x_return_status := fnd_api.g_ret_sts_error;
224: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
225: WHEN OTHERS
226: THEN
227: ROLLBACK TO SKILL_SP;

Line 233: x_return_status := fnd_api.g_ret_sts_unexp_error;

229: fnd_message.set_token('P_SQLCODE',SQLCODE);
230: fnd_message.set_token('P_SQLERRM',SQLERRM);
231: fnd_message.set_token('P_API_NAME', l_api_name);
232: FND_MSG_PUB.add;
233: x_return_status := fnd_api.g_ret_sts_unexp_error;
234: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
235:
236: END create_skills;
237:

Line 326: x_return_status := fnd_api.g_ret_sts_success;

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

Line 331: RAISE FND_API.G_EXC_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_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_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 353: IF (p_skill_level = FND_API.G_MISS_NUM)

349: IF (chk_skill_cur%found) THEN
350: CLOSE chk_skill_cur;
351:
352:
353: IF (p_skill_level = FND_API.G_MISS_NUM)
354: THEN
355: l_skill_level := skill_levels_rec.skill_level;
356: ELSE
357: chk_dup_skill_level(P_SKILL_LEVEL => p_skill_level,

Line 365: IF (p_level_name = FND_API.G_MISS_CHAR)

361: X_MSG_DATA => x_msg_data);
362: l_skill_level := p_skill_level;
363: END IF;
364:
365: IF (p_level_name = FND_API.G_MISS_CHAR)
366: THEN
367: l_level_name := skill_levels_rec.level_name;
368: ELSE
369: chk_dup_level_name(P_LEVEL_NAME => p_level_name,

Line 377: IF (p_level_desc = FND_API.G_MISS_CHAR)

373: X_MSG_DATA => x_msg_data);
374: l_level_name := p_level_name;
375: END IF;
376:
377: IF (p_level_desc = FND_API.G_MISS_CHAR)
378: THEN
379: l_level_desc := skill_levels_rec.level_desc;
380: ELSE
381: l_level_desc := p_level_desc;

Line 384: IF(p_attribute1 = FND_API.G_MISS_CHAR)

380: ELSE
381: l_level_desc := p_level_desc;
382: END IF;
383:
384: IF(p_attribute1 = FND_API.G_MISS_CHAR)
385: THEN
386: l_attribute1 := skill_levels_rec.attribute1;
387: ELSE
388: l_attribute1 := p_attribute1;

Line 391: IF(p_attribute2 = FND_API.G_MISS_CHAR)

387: ELSE
388: l_attribute1 := p_attribute1;
389: END IF;
390:
391: IF(p_attribute2 = FND_API.G_MISS_CHAR)
392: THEN
393: l_attribute2 := skill_levels_rec.attribute2;
394: ELSE
395: l_attribute2 := p_attribute2;

Line 398: IF(p_attribute3 = FND_API.G_MISS_CHAR)

394: ELSE
395: l_attribute2 := p_attribute2;
396: END IF;
397:
398: IF(p_attribute3 = FND_API.G_MISS_CHAR)
399: THEN
400: l_attribute3 := skill_levels_rec.attribute3;
401: ELSE
402: l_attribute3 := p_attribute3;

Line 405: IF(p_attribute4 = FND_API.G_MISS_CHAR)

401: ELSE
402: l_attribute3 := p_attribute3;
403: END IF;
404:
405: IF(p_attribute4 = FND_API.G_MISS_CHAR)
406: THEN
407: l_attribute4 := skill_levels_rec.attribute4;
408: ELSE
409: l_attribute4 := p_attribute4;

Line 412: IF(p_attribute5 = FND_API.G_MISS_CHAR)

408: ELSE
409: l_attribute4 := p_attribute4;
410: END IF;
411:
412: IF(p_attribute5 = FND_API.G_MISS_CHAR)
413: THEN
414: l_attribute5 := skill_levels_rec.attribute5;
415: ELSE
416: l_attribute5 := p_attribute5;

Line 419: IF(p_attribute6 = FND_API.G_MISS_CHAR)

415: ELSE
416: l_attribute5 := p_attribute5;
417: END IF;
418:
419: IF(p_attribute6 = FND_API.G_MISS_CHAR)
420: THEN
421: l_attribute6 := skill_levels_rec.attribute6;
422: ELSE
423: l_attribute6 := p_attribute6;

Line 426: IF(p_attribute7 = FND_API.G_MISS_CHAR)

422: ELSE
423: l_attribute6 := p_attribute6;
424: END IF;
425:
426: IF(p_attribute7 = FND_API.G_MISS_CHAR)
427: THEN
428: l_attribute7 := skill_levels_rec.attribute7;
429: ELSE
430: l_attribute7 := p_attribute7;

Line 433: IF(p_attribute8 = FND_API.G_MISS_CHAR)

429: ELSE
430: l_attribute7 := p_attribute7;
431: END IF;
432:
433: IF(p_attribute8 = FND_API.G_MISS_CHAR)
434: THEN
435: l_attribute8 := skill_levels_rec.attribute8;
436: ELSE
437: l_attribute8 := p_attribute8;

Line 440: IF(p_attribute9 = FND_API.G_MISS_CHAR)

436: ELSE
437: l_attribute8 := p_attribute8;
438: END IF;
439:
440: IF(p_attribute9 = FND_API.G_MISS_CHAR)
441: THEN
442: l_attribute9 := skill_levels_rec.attribute9;
443: ELSE
444: l_attribute9 := p_attribute9;

Line 447: IF(p_attribute10 = FND_API.G_MISS_CHAR)

443: ELSE
444: l_attribute9 := p_attribute9;
445: END IF;
446:
447: IF(p_attribute10 = FND_API.G_MISS_CHAR)
448: THEN
449: l_attribute10 := skill_levels_rec.attribute10;
450: ELSE
451: l_attribute10 := p_attribute10;

Line 454: IF(p_attribute11 = FND_API.G_MISS_CHAR)

450: ELSE
451: l_attribute10 := p_attribute10;
452: END IF;
453:
454: IF(p_attribute11 = FND_API.G_MISS_CHAR)
455: THEN
456: l_attribute11 := skill_levels_rec.attribute11;
457: ELSE
458: l_attribute11 := p_attribute11;

Line 461: IF(p_attribute12 = FND_API.G_MISS_CHAR)

457: ELSE
458: l_attribute11 := p_attribute11;
459: END IF;
460:
461: IF(p_attribute12 = FND_API.G_MISS_CHAR)
462: THEN
463: l_attribute12 := skill_levels_rec.attribute12;
464: ELSE
465: l_attribute12 := p_attribute12;

Line 468: IF(p_attribute13 = FND_API.G_MISS_CHAR)

464: ELSE
465: l_attribute12 := p_attribute12;
466: END IF;
467:
468: IF(p_attribute13 = FND_API.G_MISS_CHAR)
469: THEN
470: l_attribute13 := skill_levels_rec.attribute13;
471: ELSE
472: l_attribute13 := p_attribute13;

Line 475: IF(p_attribute14 = FND_API.G_MISS_CHAR)

471: ELSE
472: l_attribute13 := p_attribute13;
473: END IF;
474:
475: IF(p_attribute14 = FND_API.G_MISS_CHAR)
476: THEN
477: l_attribute14 := skill_levels_rec.attribute14;
478: ELSE
479: l_attribute14 := p_attribute14;

Line 482: IF(p_attribute15 = FND_API.G_MISS_CHAR)

478: ELSE
479: l_attribute14 := p_attribute14;
480: END IF;
481:
482: IF(p_attribute15 = FND_API.G_MISS_CHAR)
483: THEN
484: l_attribute15 := skill_levels_rec.attribute15;
485: ELSE
486: l_attribute15 := p_attribute15;

Line 489: IF(p_attribute_category = FND_API.G_MISS_CHAR)

485: ELSE
486: l_attribute15 := p_attribute15;
487: END IF;
488:
489: IF(p_attribute_category = FND_API.G_MISS_CHAR)
490: THEN
491: l_attribute_category := skill_levels_rec.attribute_category;
492: ELSE
493: l_attribute_category := p_attribute_category;

Line 507: x_return_status := fnd_api.g_ret_sts_error;

503:
504: EXCEPTION
505:
506: WHEN OTHERS THEN
507: x_return_status := fnd_api.g_ret_sts_error;
508: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
509: fnd_msg_pub.add;
510: RAISE fnd_api.g_exc_error;
511:

Line 510: RAISE fnd_api.g_exc_error;

506: WHEN OTHERS THEN
507: x_return_status := fnd_api.g_ret_sts_error;
508: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
509: fnd_msg_pub.add;
510: RAISE fnd_api.g_exc_error;
511:
512: END;
513:
514:

Line 547: x_return_status := fnd_api.g_ret_sts_error;

543: P_OBJECT_VERSION_NUM := l_object_version_number;
544:
545: ELSIF (chk_skill_cur%notfound) THEN
546: CLOSE chk_skill_cur;
547: x_return_status := fnd_api.g_ret_sts_error;
548: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
549: FND_MSG_PUB.add;
550: RAISE fnd_api.g_exc_error;
551:

Line 550: RAISE fnd_api.g_exc_error;

546: CLOSE chk_skill_cur;
547: x_return_status := fnd_api.g_ret_sts_error;
548: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
549: FND_MSG_PUB.add;
550: RAISE fnd_api.g_exc_error;
551:
552: END IF;
553:
554:

Line 555: IF fnd_api.to_boolean (p_commit)

551:
552: END IF;
553:
554:
555: IF fnd_api.to_boolean (p_commit)
556: THEN
557: COMMIT WORK;
558: END IF;
559:

Line 563: WHEN fnd_api.g_exc_error

559:
560: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
561:
562: EXCEPTION
563: WHEN fnd_api.g_exc_error
564: THEN
565: ROLLBACK TO SKILL_LEVELS_SP;
566: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
567: x_return_status := fnd_api.g_ret_sts_error;

Line 567: x_return_status := fnd_api.g_ret_sts_error;

563: WHEN fnd_api.g_exc_error
564: THEN
565: ROLLBACK TO SKILL_LEVELS_SP;
566: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
567: x_return_status := fnd_api.g_ret_sts_error;
568:
569: WHEN fnd_api.g_exc_unexpected_error
570: THEN
571: ROLLBACK TO SKILL_LEVELS_SP;

Line 569: WHEN fnd_api.g_exc_unexpected_error

565: ROLLBACK TO SKILL_LEVELS_SP;
566: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
567: x_return_status := fnd_api.g_ret_sts_error;
568:
569: WHEN fnd_api.g_exc_unexpected_error
570: THEN
571: ROLLBACK TO SKILL_LEVELS_SP;
572: x_return_status := fnd_api.g_ret_sts_unexp_error;
573: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 572: x_return_status := fnd_api.g_ret_sts_unexp_error;

568:
569: WHEN fnd_api.g_exc_unexpected_error
570: THEN
571: ROLLBACK TO SKILL_LEVELS_SP;
572: x_return_status := fnd_api.g_ret_sts_unexp_error;
573: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
574: WHEN OTHERS
575: THEN
576: ROLLBACK TO SKILL_LEVELS_SP;

Line 582: x_return_status := fnd_api.g_ret_sts_unexp_error;

578: fnd_message.set_token('P_SQLCODE',SQLCODE);
579: fnd_message.set_token('P_SQLERRM',SQLERRM);
580: fnd_message.set_token('P_API_NAME',l_api_name);
581: FND_MSG_PUB.add;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
584: END update_skills;
585:
586:

Line 632: x_return_status := fnd_api.g_ret_sts_success;

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

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

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

Line 637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
639:
640: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
641: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 641: IF FND_API.To_boolean(P_INIT_MSG_LIST)

637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639:
640: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
641: IF FND_API.To_boolean(P_INIT_MSG_LIST)
642: THEN
643: FND_MSG_PUB.Initialize;
644: END IF;
645:

Line 663: x_return_status := fnd_api.g_ret_sts_error;

659:
660: EXCEPTION
661:
662: WHEN OTHERS THEN
663: x_return_status := fnd_api.g_ret_sts_error;
664: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
665: fnd_msg_pub.add;
666: RAISE fnd_api.g_exc_error;
667:

Line 666: RAISE fnd_api.g_exc_error;

662: WHEN OTHERS THEN
663: x_return_status := fnd_api.g_ret_sts_error;
664: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
665: fnd_msg_pub.add;
666: RAISE fnd_api.g_exc_error;
667:
668: END;
669:
670: JTF_RS_SKILL_LEVELS_PKG.DELETE_ROW(

Line 675: x_return_status := fnd_api.g_ret_sts_error;

671: X_SKILL_LEVEL_ID => l_skill_level_id);
672:
673: ELSIF (chk_skill_exist_cur%notfound) THEN
674: CLOSE chk_skill_exist_cur;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
677: FND_MSG_PUB.add;
678: RAISE fnd_api.g_exc_error;
679:

Line 678: RAISE fnd_api.g_exc_error;

674: CLOSE chk_skill_exist_cur;
675: x_return_status := fnd_api.g_ret_sts_error;
676: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
677: FND_MSG_PUB.add;
678: RAISE fnd_api.g_exc_error;
679:
680: END IF;
681:
682: IF fnd_api.to_boolean (p_commit)

Line 682: IF fnd_api.to_boolean (p_commit)

678: RAISE fnd_api.g_exc_error;
679:
680: END IF;
681:
682: IF fnd_api.to_boolean (p_commit)
683: THEN
684: COMMIT WORK;
685: END IF;
686:

Line 690: WHEN fnd_api.g_exc_unexpected_error

686:
687: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
688:
689: EXCEPTION
690: WHEN fnd_api.g_exc_unexpected_error
691: THEN
692: ROLLBACK TO SKILL_LEVELS_SP;
693: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
694: WHEN fnd_api.g_exc_error

Line 694: WHEN fnd_api.g_exc_error

690: WHEN fnd_api.g_exc_unexpected_error
691: THEN
692: ROLLBACK TO SKILL_LEVELS_SP;
693: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
694: WHEN fnd_api.g_exc_error
695: THEN
696: ROLLBACK TO SKILL_LEVELS_SP;
697: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
698: WHEN OTHERS

Line 706: x_return_status := fnd_api.g_ret_sts_unexp_error;

702: fnd_message.set_token('P_SQLCODE',SQLCODE);
703: fnd_message.set_token('P_SQLERRM',SQLERRM);
704: fnd_message.set_token('P_API_NAME',l_api_name);
705: FND_MSG_PUB.add;
706: x_return_status := fnd_api.g_ret_sts_unexp_error;
707: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
708:
709: END delete_skills;
710: