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_RESOURCE_SKILLS_PVT dependencies on FND_MSG_PUB

Line 300: FND_MSG_PUB.Initialize;

296:
297: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
298: IF FND_API.To_boolean(P_INIT_MSG_LIST)
299: THEN
300: FND_MSG_PUB.Initialize;
301: END IF;
302:
303: --GET USER ID AND SYSDATE
304: l_date := sysdate;

Line 321: FND_MSG_PUB.add;

317: FETCH subcategory_cur into subcategory_rec;
318: IF (subcategory_cur%NOTFOUND) THEN
319: x_return_status := fnd_api.g_ret_sts_error;
320: fnd_message.set_name ('JTF', 'JTF_RS_SUBCATEGORY_INVALID');
321: FND_MSG_PUB.add;
322: RAISE fnd_api.g_exc_error;
323: END IF;
324: CLOSE subcategory_cur;
325:

Line 341: FND_MSG_PUB.add;

337: /*OR (p_problem_code IS NOT NULL)*/)
338: THEN
339: x_return_status := fnd_api.g_ret_sts_error;
340: fnd_message.set_name ('JTF', 'JTF_RS_PARAM_COMBO_INVALID');
341: FND_MSG_PUB.add;
342: RAISE fnd_api.g_exc_error;
343: END IF;
344:
345: -- If user doesn't pass org_id determine it and set it

Line 364: FND_MSG_PUB.add;

360: OR (p_problem_code IS NOT NULL))
361: THEN
362: x_return_status := fnd_api.g_ret_sts_error;
363: fnd_message.set_name ('JTF', 'JTF_RS_PARAM_COMBO_INVALID');
364: FND_MSG_PUB.add;
365: RAISE fnd_api.g_exc_error;
366: END IF;
367:
368: -- If user doesn't pass org_id determine it and set it

Line 388: FND_MSG_PUB.add;

384: OR (p_platform_org_id IS NOT NULL))
385: THEN
386: x_return_status := fnd_api.g_ret_sts_error;
387: fnd_message.set_name ('JTF', 'JTF_RS_PARAM_COMBO_INVALID');
388: FND_MSG_PUB.add;
389: RAISE fnd_api.g_exc_error;
390: END IF;
391: ELSE
392: IF (p_subcategory IS NOT NULL) THEN

Line 395: FND_MSG_PUB.add;

391: ELSE
392: IF (p_subcategory IS NOT NULL) THEN
393: x_return_status := fnd_api.g_ret_sts_error;
394: fnd_message.set_name ('JTF', 'JTF_RS_SUBCATEGORY_INVALID');
395: FND_MSG_PUB.add;
396: RAISE fnd_api.g_exc_error;
397: END IF;
398: END IF;
399:

Line 409: FND_MSG_PUB.add;

405: FETCH resource_id_cur into resource_id_rec;
406: IF (resource_id_cur%NOTFOUND) THEN
407: x_return_status := fnd_api.g_ret_sts_error;
408: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');
409: FND_MSG_PUB.add;
410: RAISE fnd_api.g_exc_error;
411: END IF;
412: CLOSE resource_id_cur;
413:

Line 423: FND_MSG_PUB.add;

419: FETCH skill_level_id_cur into skill_level_id_rec;
420: IF (skill_level_id_cur%NOTFOUND) THEN
421: x_return_status := fnd_api.g_ret_sts_error;
422: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');
423: FND_MSG_PUB.add;
424: RAISE fnd_api.g_exc_error;
425: END IF;
426: CLOSE skill_level_id_cur;
427:

Line 438: FND_MSG_PUB.add;

434: FETCH category_id_cur into category_id_rec;
435: IF (category_id_cur%NOTFOUND) THEN
436: x_return_status := fnd_api.g_ret_sts_error;
437: fnd_message.set_name ('JTF', 'JTF_RS_CATEGORY_ID_INVALID');
438: FND_MSG_PUB.add;
439: RAISE fnd_api.g_exc_error;
440: END IF;
441: CLOSE category_id_cur;
442: ELSE

Line 448: FND_MSG_PUB.add;

444: FETCH category_catset_id_cur into category_catset_id_rec;
445: IF (category_catset_id_cur%NOTFOUND) THEN
446: x_return_status := fnd_api.g_ret_sts_error;
447: fnd_message.set_name ('JTF', 'JTF_RS_CATEGORY_ID_INVALID');
448: FND_MSG_PUB.add;
449: RAISE fnd_api.g_exc_error;
450: END IF;
451: CLOSE category_catset_id_cur;
452: END IF;

Line 466: FND_MSG_PUB.add;

462: FETCH product_id_cur into product_id_rec;
463: IF (product_id_cur%NOTFOUND) THEN
464: x_return_status := fnd_api.g_ret_sts_error;
465: fnd_message.set_name ('JTF', 'JTF_RS_PRODUCT_ID_INVALID');
466: FND_MSG_PUB.add;
467: RAISE fnd_api.g_exc_error;
468: END IF;
469: CLOSE product_id_cur;
470: ELSE

Line 476: FND_MSG_PUB.add;

472: FETCH product_cat_id_cur into product_cat_id_rec;
473: IF (product_cat_id_cur%NOTFOUND) THEN
474: x_return_status := fnd_api.g_ret_sts_error;
475: fnd_message.set_name ('JTF', 'JTF_RS_PROD_CAT_ID_INVALID');
476: FND_MSG_PUB.add;
477: RAISE fnd_api.g_exc_error;
478: END IF;
479: CLOSE product_cat_id_cur;
480: END IF;

Line 486: FND_MSG_PUB.add;

482:
483: IF (p_component_id IS NOT NULL AND p_problem_code IS NOT NULL) THEN
484: x_return_status := fnd_api.g_ret_sts_error;
485: fnd_message.set_name ('JTF', 'JTF_RS_COMP_PROB_CODE_MUTEX');
486: FND_MSG_PUB.add;
487: RAISE fnd_api.g_exc_error;
488: END IF;
489:
490: IF (p_component_id IS NOT NULL) THEN

Line 496: FND_MSG_PUB.add;

492: FETCH component_id_cur into component_id_rec;
493: IF (component_id_cur%NOTFOUND) THEN
494: x_return_status := fnd_api.g_ret_sts_error;
495: fnd_message.set_name ('JTF', 'JTF_RS_COMPONENT_ID_INVALID');
496: FND_MSG_PUB.add;
497: RAISE fnd_api.g_exc_error;
498: END IF;
499: CLOSE component_id_cur;
500: END IF;

Line 518: FND_MSG_PUB.add;

514: FETCH prod_prob_code_cur into l_problem_code, l_product_id;
515: IF (prod_prob_code_cur%NOTFOUND) THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_message.set_name ('JTF', 'JTF_RS_PROD_PROB_CODE_INVALID');
518: FND_MSG_PUB.add;
519: RAISE fnd_api.g_exc_error;
520: END IF;
521: END IF;
522:

Line 530: FND_MSG_PUB.add;

526: FETCH platform_id_cur into platform_id_rec;
527: IF (platform_id_cur%NOTFOUND) THEN
528: x_return_status := fnd_api.g_ret_sts_error;
529: fnd_message.set_name ('JTF', 'JTF_RS_PLATFORM_ID_INVALID');
530: FND_MSG_PUB.add;
531: RAISE fnd_api.g_exc_error;
532: END IF;
533: CLOSE platform_id_cur;
534: ELSE

Line 540: FND_MSG_PUB.add;

536: FETCH platform_cat_id_cur into platform_cat_id_rec;
537: IF (platform_cat_id_cur%NOTFOUND) THEN
538: x_return_status := fnd_api.g_ret_sts_error;
539: fnd_message.set_name ('JTF', 'JTF_RS_PLAT_CAT_ID_INVALID');
540: FND_MSG_PUB.add;
541: RAISE fnd_api.g_exc_error;
542: END IF;
543: CLOSE platform_cat_id_cur;
544: END IF;

Line 552: FND_MSG_PUB.add;

548: FETCH problem_code_cur into problem_code_rec;
549: IF (problem_code_cur%NOTFOUND) THEN
550: x_return_status := fnd_api.g_ret_sts_error;
551: fnd_message.set_name ('JTF', 'JTF_RS_PROBLEM_CODE_INVALID');
552: FND_MSG_PUB.add;
553: RAISE fnd_api.g_exc_error;
554: END IF;
555: CLOSE problem_code_cur;
556: END IF;

Line 571: FND_MSG_PUB.add;

567: ELSE
568: l_go_ahead := 'NO';
569: x_return_status := fnd_api.g_ret_sts_error;
570: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');
571: FND_MSG_PUB.add;
572: RAISE fnd_api.g_exc_error;
573: END IF;
574: CLOSE product_dup_cur;
575: ELSIF (p_subcategory = 'PLATFORM') THEN

Line 584: FND_MSG_PUB.add;

580: ELSE
581: l_go_ahead := 'NO';
582: x_return_status := fnd_api.g_ret_sts_error;
583: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');
584: FND_MSG_PUB.add;
585: RAISE fnd_api.g_exc_error;
586: END IF;
587: CLOSE platform_dup_cur;
588: ELSIF (p_subcategory = 'PROBLEM_CODE') THEN

Line 597: FND_MSG_PUB.add;

593: ELSE
594: l_go_ahead := 'NO';
595: x_return_status := fnd_api.g_ret_sts_error;
596: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');
597: FND_MSG_PUB.add;
598: RAISE fnd_api.g_exc_error;
599: END IF;
600: CLOSE problem_code_dup_cur;
601: ELSE

Line 612: FND_MSG_PUB.add;

608: ELSE
609: l_go_ahead := 'NO';
610: x_return_status := fnd_api.g_ret_sts_error;
611: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');
612: FND_MSG_PUB.add;
613: RAISE fnd_api.g_exc_error;
614: END IF;
615: CLOSE category_dup_cur;
616: l_go_ahead := 'YES';

Line 672: FND_MSG_PUB.add;

668: x_resource_skill_id := l_resource_skill_id;
669:
670: ELSE
671: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');
672: FND_MSG_PUB.add;
673: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
674: raise fnd_api.g_exc_error;
675: END IF;
676:

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

669:
670: ELSE
671: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');
672: FND_MSG_PUB.add;
673: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
674: raise fnd_api.g_exc_error;
675: END IF;
676:
677:

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

680: THEN
681: COMMIT WORK;
682: END IF;
683:
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
685:
686: EXCEPTION
687: WHEN fnd_api.g_exc_unexpected_error
688: THEN

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

687: WHEN fnd_api.g_exc_unexpected_error
688: THEN
689: ROLLBACK TO RESOURCE_SKILLS_SP;
690: x_return_status := fnd_api.g_ret_sts_unexp_error;
691: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
692: WHEN fnd_api.g_exc_error
693: THEN
694: ROLLBACK TO RESOURCE_SKILLS_SP;
695: x_return_status := fnd_api.g_ret_sts_error;

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

692: WHEN fnd_api.g_exc_error
693: THEN
694: ROLLBACK TO RESOURCE_SKILLS_SP;
695: x_return_status := fnd_api.g_ret_sts_error;
696: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
697: WHEN OTHERS
698: THEN
699: ROLLBACK TO RESOURCE_SKILLS_SP;
700: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 704: FND_MSG_PUB.add;

700: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
701: fnd_message.set_token('P_SQLCODE',SQLCODE);
702: fnd_message.set_token('P_SQLERRM',SQLERRM);
703: fnd_message.set_token('P_API_NAME', l_api_name);
704: FND_MSG_PUB.add;
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
707:
708: END create_resource_skills;

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

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

Line 858: FND_MSG_PUB.Initialize;

854:
855: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
856: IF FND_API.To_boolean(P_INIT_MSG_LIST)
857: THEN
858: FND_MSG_PUB.Initialize;
859: END IF;
860:
861:
862: --GET USER ID AND SYSDATE

Line 1076: fnd_msg_pub.add;

1072:
1073: WHEN OTHERS THEN
1074: x_return_status := fnd_api.g_ret_sts_error;
1075: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1076: fnd_msg_pub.add;
1077: RAISE fnd_api.g_exc_error;
1078:
1079: END;
1080:

Line 1124: FND_MSG_PUB.add;

1120:
1121: ELSIF (resource_skills_cur%notfound) THEN
1122: x_return_status := fnd_api.g_ret_sts_error;
1123: fnd_message.set_name ('JTF', 'JTF_RS_RES_SKILL_ID_INVALID');
1124: FND_MSG_PUB.add;
1125: RAISE fnd_api.g_exc_error;
1126:
1127: END IF;
1128:

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

1132: THEN
1133: COMMIT WORK;
1134: END IF;
1135:
1136: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1137:
1138: EXCEPTION
1139: WHEN fnd_api.g_exc_error
1140: THEN

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

1139: WHEN fnd_api.g_exc_error
1140: THEN
1141: ROLLBACK TO RESOURCE_SKILLS_SP;
1142: x_return_status := fnd_api.g_ret_sts_error;
1143: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1144: WHEN fnd_api.g_exc_unexpected_error
1145: THEN
1146: ROLLBACK TO RESOURCE_SKILLS_SP;
1147: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1144: WHEN fnd_api.g_exc_unexpected_error
1145: THEN
1146: ROLLBACK TO RESOURCE_SKILLS_SP;
1147: x_return_status := fnd_api.g_ret_sts_unexp_error;
1148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1149: WHEN OTHERS
1150: THEN
1151: ROLLBACK TO RESOURCE_SKILLS_SP;
1152: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1156: FND_MSG_PUB.add;

1152: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1153: fnd_message.set_token('P_SQLCODE',SQLCODE);
1154: fnd_message.set_token('P_SQLERRM',SQLERRM);
1155: fnd_message.set_token('P_API_NAME',l_api_name);
1156: FND_MSG_PUB.add;
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;
1158: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1159: END update_resource_skills;
1160:

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

1154: fnd_message.set_token('P_SQLERRM',SQLERRM);
1155: fnd_message.set_token('P_API_NAME',l_api_name);
1156: FND_MSG_PUB.add;
1157: x_return_status := fnd_api.g_ret_sts_unexp_error;
1158: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1159: END update_resource_skills;
1160:
1161:
1162: /* Procedure to delete the resource skills */

Line 1217: FND_MSG_PUB.Initialize;

1213:
1214: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1215: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1216: THEN
1217: FND_MSG_PUB.Initialize;
1218: END IF;
1219:
1220: OPEN chk_res_exist_cur(l_resource_skill_id);
1221: FETCH chk_res_exist_cur INTO chk_res_exist_rec;

Line 1231: FND_MSG_PUB.add;

1227:
1228: ELSIF (chk_res_exist_cur%notfound) THEN
1229: x_return_status := fnd_api.g_ret_sts_error;
1230: fnd_message.set_name ('JTF', 'JTF_RS_RES_SKILL_ID_INVALID');
1231: FND_MSG_PUB.add;
1232: RAISE fnd_api.g_exc_error;
1233:
1234: END IF;
1235:

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

1239: THEN
1240: COMMIT WORK;
1241: END IF;
1242:
1243: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1244:
1245: EXCEPTION
1246: WHEN fnd_api.g_exc_unexpected_error
1247: THEN

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

1246: WHEN fnd_api.g_exc_unexpected_error
1247: THEN
1248: ROLLBACK TO RESOURCE_SKILLS_SP;
1249: x_return_status := fnd_api.g_ret_sts_unexp_error;
1250: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1251: WHEN fnd_api.g_exc_error
1252: THEN
1253: ROLLBACK TO RESOURCE_SKILLS_SP;
1254: x_return_status := fnd_api.g_ret_sts_error;

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

1251: WHEN fnd_api.g_exc_error
1252: THEN
1253: ROLLBACK TO RESOURCE_SKILLS_SP;
1254: x_return_status := fnd_api.g_ret_sts_error;
1255: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1256: WHEN OTHERS
1257: THEN
1258: ROLLBACK TO RESOURCE_SKILLS_SP;
1259: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 1263: FND_MSG_PUB.add;

1259: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1260: fnd_message.set_token('P_SQLCODE',SQLCODE);
1261: fnd_message.set_token('P_SQLERRM',SQLERRM);
1262: fnd_message.set_token('P_API_NAME',l_api_name);
1263: FND_MSG_PUB.add;
1264: x_return_status := fnd_api.g_ret_sts_unexp_error;
1265: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1266:
1267: END delete_resource_skills;

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

1261: fnd_message.set_token('P_SQLERRM',SQLERRM);
1262: fnd_message.set_token('P_API_NAME',l_api_name);
1263: FND_MSG_PUB.add;
1264: x_return_status := fnd_api.g_ret_sts_unexp_error;
1265: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1266:
1267: END delete_resource_skills;
1268:
1269: END JTF_RS_RESOURCE_SKILLS_PVT;