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_MESSAGE

Line 320: fnd_message.set_name ('JTF', 'JTF_RS_SUBCATEGORY_INVALID');

316: OPEN subcategory_cur(p_subcategory);
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;

Line 340: fnd_message.set_name ('JTF', 'JTF_RS_PARAM_COMBO_INVALID');

336: OR (p_platform_org_id IS NOT NULL)
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:

Line 363: fnd_message.set_name ('JTF', 'JTF_RS_PARAM_COMBO_INVALID');

359: OR (p_component_id IS NOT NULL)
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:

Line 387: fnd_message.set_name ('JTF', 'JTF_RS_PARAM_COMBO_INVALID');

383: OR (p_platform_id IS NOT NULL)
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

Line 394: fnd_message.set_name ('JTF', 'JTF_RS_SUBCATEGORY_INVALID');

390: END IF;
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;

Line 408: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');

404: OPEN resource_id_cur(p_resource_id);
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;

Line 422: fnd_message.set_name ('JTF', 'JTF_RS_SKILL_LEVEL_ID_INVALID');

418: OPEN skill_level_id_cur(p_skill_level_id);
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;

Line 437: fnd_message.set_name ('JTF', 'JTF_RS_CATEGORY_ID_INVALID');

433: OPEN category_id_cur(p_category_id);
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;

Line 447: fnd_message.set_name ('JTF', 'JTF_RS_CATEGORY_ID_INVALID');

443: OPEN category_catset_id_cur(p_category_id, l_catset);
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;

Line 465: fnd_message.set_name ('JTF', 'JTF_RS_PRODUCT_ID_INVALID');

461: OPEN product_id_cur(p_product_id, l_product_org_id);
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;

Line 475: fnd_message.set_name ('JTF', 'JTF_RS_PROD_CAT_ID_INVALID');

471: OPEN product_cat_id_cur(p_product_id, p_category_id, l_product_org_id);
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;

Line 485: fnd_message.set_name ('JTF', 'JTF_RS_COMP_PROB_CODE_MUTEX');

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

Line 495: fnd_message.set_name ('JTF', 'JTF_RS_COMPONENT_ID_INVALID');

491: OPEN component_id_cur(p_component_id, p_product_id, l_product_org_id);
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;

Line 517: fnd_message.set_name ('JTF', 'JTF_RS_PROD_PROB_CODE_INVALID');

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

Line 529: fnd_message.set_name ('JTF', 'JTF_RS_PLATFORM_ID_INVALID');

525: OPEN platform_id_cur(p_platform_id, l_platform_org_id);
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;

Line 539: fnd_message.set_name ('JTF', 'JTF_RS_PLAT_CAT_ID_INVALID');

535: OPEN platform_cat_id_cur(p_platform_id, p_category_id, l_platform_org_id);
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;

Line 551: fnd_message.set_name ('JTF', 'JTF_RS_PROBLEM_CODE_INVALID');

547: OPEN problem_code_cur(p_problem_code);
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;

Line 570: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');

566: l_go_ahead := 'YES';
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;

Line 583: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');

579: l_go_ahead := 'YES';
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;

Line 596: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');

592: l_go_ahead := 'YES';
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;

Line 611: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');

607: l_go_ahead := 'YES';
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;

Line 671: fnd_message.set_name ('JTF', 'JTF_RS_DUPLICATE_SKILL');

667: -- return resource_skill_id
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;

Line 700: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_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');
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;

Line 701: fnd_message.set_token('P_SQLCODE',SQLCODE);

697: WHEN OTHERS
698: THEN
699: ROLLBACK TO RESOURCE_SKILLS_SP;
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;

Line 702: fnd_message.set_token('P_SQLERRM',SQLERRM);

698: THEN
699: ROLLBACK TO RESOURCE_SKILLS_SP;
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);

Line 703: fnd_message.set_token('P_API_NAME', l_api_name);

699: ROLLBACK TO RESOURCE_SKILLS_SP;
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:

Line 1075: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

1071: EXCEPTION
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;

Line 1123: fnd_message.set_name ('JTF', 'JTF_RS_RES_SKILL_ID_INVALID');

1119: P_OBJECT_VERSION_NUM := l_object_version_number;
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;

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

Line 1153: fnd_message.set_token('P_SQLCODE',SQLCODE);

1149: WHEN OTHERS
1150: THEN
1151: ROLLBACK TO RESOURCE_SKILLS_SP;
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;

Line 1154: fnd_message.set_token('P_SQLERRM',SQLERRM);

1150: THEN
1151: ROLLBACK TO RESOURCE_SKILLS_SP;
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);

Line 1155: fnd_message.set_token('P_API_NAME',l_api_name);

1151: ROLLBACK TO RESOURCE_SKILLS_SP;
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;

Line 1230: fnd_message.set_name ('JTF', 'JTF_RS_RES_SKILL_ID_INVALID');

1226: X_RESOURCE_SKILL_ID => l_resource_skill_id);
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;

Line 1259: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_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');
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;

Line 1260: fnd_message.set_token('P_SQLCODE',SQLCODE);

1256: WHEN OTHERS
1257: THEN
1258: ROLLBACK TO RESOURCE_SKILLS_SP;
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;

Line 1261: fnd_message.set_token('P_SQLERRM',SQLERRM);

1257: THEN
1258: ROLLBACK TO RESOURCE_SKILLS_SP;
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);

Line 1262: fnd_message.set_token('P_API_NAME',l_api_name);

1258: ROLLBACK TO RESOURCE_SKILLS_SP;
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: