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_REP_MGR_DENORM_PVT dependencies on FND_MESSAGE

Line 385: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');

381: -- if no group id or person id is passed in then return
382: IF p_role_relate_id IS NULL
383: THEN
384: x_return_status := fnd_api.g_ret_sts_error;
385: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');
386: FND_MSG_PUB.add;
387: RAISE fnd_api.g_exc_error;
388: END IF;
389:

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

1119: EXCEPTION
1120: WHEN fnd_api.g_exc_unexpected_error
1121: THEN
1122: ROLLBACK TO member_denormalize;
1123: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
1124: --FND_MSG_PUB.add;
1125: --x_return_status := fnd_api.g_ret_sts_unexp_error;
1126: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1127: WHEN fnd_api.g_exc_error

Line 1135: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1131:
1132: WHEN OTHERS
1133: THEN
1134: ROLLBACK TO member_denormalize;
1135: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1136: fnd_message.set_token('P_SQLCODE',SQLCODE);
1137: fnd_message.set_token('P_SQLERRM',SQLERRM);
1138: fnd_message.set_token('P_API_NAME',l_api_name);
1139: FND_MSG_PUB.add;

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

1132: WHEN OTHERS
1133: THEN
1134: ROLLBACK TO member_denormalize;
1135: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1136: fnd_message.set_token('P_SQLCODE',SQLCODE);
1137: fnd_message.set_token('P_SQLERRM',SQLERRM);
1138: fnd_message.set_token('P_API_NAME',l_api_name);
1139: FND_MSG_PUB.add;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1133: THEN
1134: ROLLBACK TO member_denormalize;
1135: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1136: fnd_message.set_token('P_SQLCODE',SQLCODE);
1137: fnd_message.set_token('P_SQLERRM',SQLERRM);
1138: fnd_message.set_token('P_API_NAME',l_api_name);
1139: FND_MSG_PUB.add;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1134: ROLLBACK TO member_denormalize;
1135: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1136: fnd_message.set_token('P_SQLCODE',SQLCODE);
1137: fnd_message.set_token('P_SQLERRM',SQLERRM);
1138: fnd_message.set_token('P_API_NAME',l_api_name);
1139: FND_MSG_PUB.add;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1142:

Line 1484: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');

1480: -- if no group id or person id is passed in then return
1481: IF p_role_relate_id IS NULL
1482: THEN
1483: x_return_status := fnd_api.g_ret_sts_error;
1484: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');
1485: FND_MSG_PUB.add;
1486: RAISE fnd_api.g_exc_error;
1487: END IF;
1488:

Line 2518: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');

2514: EXCEPTION
2515: WHEN fnd_api.g_exc_unexpected_error
2516: THEN
2517: ROLLBACK TO member_denormalize;
2518: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2519: --FND_MSG_PUB.add;
2520: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2521: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2522: WHEN fnd_api.g_exc_error

Line 2530: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2526:
2527: WHEN OTHERS
2528: THEN
2529: ROLLBACK TO member_denormalize;
2530: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2531: fnd_message.set_token('P_SQLCODE',SQLCODE);
2532: fnd_message.set_token('P_SQLERRM',SQLERRM);
2533: fnd_message.set_token('P_API_NAME',l_api_name);
2534: FND_MSG_PUB.add;

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

2527: WHEN OTHERS
2528: THEN
2529: ROLLBACK TO member_denormalize;
2530: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2531: fnd_message.set_token('P_SQLCODE',SQLCODE);
2532: fnd_message.set_token('P_SQLERRM',SQLERRM);
2533: fnd_message.set_token('P_API_NAME',l_api_name);
2534: FND_MSG_PUB.add;
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2528: THEN
2529: ROLLBACK TO member_denormalize;
2530: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2531: fnd_message.set_token('P_SQLCODE',SQLCODE);
2532: fnd_message.set_token('P_SQLERRM',SQLERRM);
2533: fnd_message.set_token('P_API_NAME',l_api_name);
2534: FND_MSG_PUB.add;
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;
2536: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2529: ROLLBACK TO member_denormalize;
2530: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2531: fnd_message.set_token('P_SQLCODE',SQLCODE);
2532: fnd_message.set_token('P_SQLERRM',SQLERRM);
2533: fnd_message.set_token('P_API_NAME',l_api_name);
2534: FND_MSG_PUB.add;
2535: x_return_status := fnd_api.g_ret_sts_unexp_error;
2536: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2537:

Line 2670: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');

2666: EXCEPTION
2667: WHEN fnd_api.g_exc_unexpected_error
2668: THEN
2669: ROLLBACK TO member_denormalize;
2670: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2671: --FND_MSG_PUB.add;
2672: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2673: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2674: WHEN fnd_api.g_exc_error

Line 2682: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2678:
2679: WHEN OTHERS
2680: THEN
2681: ROLLBACK TO member_denormalize;
2682: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2683: fnd_message.set_token('P_SQLCODE',SQLCODE);
2684: fnd_message.set_token('P_SQLERRM',SQLERRM);
2685: fnd_message.set_token('P_API_NAME',l_api_name);
2686: FND_MSG_PUB.add;

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

2679: WHEN OTHERS
2680: THEN
2681: ROLLBACK TO member_denormalize;
2682: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2683: fnd_message.set_token('P_SQLCODE',SQLCODE);
2684: fnd_message.set_token('P_SQLERRM',SQLERRM);
2685: fnd_message.set_token('P_API_NAME',l_api_name);
2686: FND_MSG_PUB.add;
2687: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2680: THEN
2681: ROLLBACK TO member_denormalize;
2682: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2683: fnd_message.set_token('P_SQLCODE',SQLCODE);
2684: fnd_message.set_token('P_SQLERRM',SQLERRM);
2685: fnd_message.set_token('P_API_NAME',l_api_name);
2686: FND_MSG_PUB.add;
2687: x_return_status := fnd_api.g_ret_sts_unexp_error;
2688: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2681: ROLLBACK TO member_denormalize;
2682: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2683: fnd_message.set_token('P_SQLCODE',SQLCODE);
2684: fnd_message.set_token('P_SQLERRM',SQLERRM);
2685: fnd_message.set_token('P_API_NAME',l_api_name);
2686: FND_MSG_PUB.add;
2687: x_return_status := fnd_api.g_ret_sts_unexp_error;
2688: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2689:

Line 2795: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');

2791: EXCEPTION
2792: WHEN fnd_api.g_exc_unexpected_error
2793: THEN
2794: ROLLBACK TO member_denormalize;
2795: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2796: --FND_MSG_PUB.add;
2797: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2798: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2799: WHEN fnd_api.g_exc_error

Line 2807: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

2803:
2804: WHEN OTHERS
2805: THEN
2806: ROLLBACK TO member_denormalize;
2807: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2808: fnd_message.set_token('P_SQLCODE',SQLCODE);
2809: fnd_message.set_token('P_SQLERRM',SQLERRM);
2810: fnd_message.set_token('P_API_NAME',l_api_name);
2811: FND_MSG_PUB.add;

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

2804: WHEN OTHERS
2805: THEN
2806: ROLLBACK TO member_denormalize;
2807: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2808: fnd_message.set_token('P_SQLCODE',SQLCODE);
2809: fnd_message.set_token('P_SQLERRM',SQLERRM);
2810: fnd_message.set_token('P_API_NAME',l_api_name);
2811: FND_MSG_PUB.add;
2812: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2805: THEN
2806: ROLLBACK TO member_denormalize;
2807: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2808: fnd_message.set_token('P_SQLCODE',SQLCODE);
2809: fnd_message.set_token('P_SQLERRM',SQLERRM);
2810: fnd_message.set_token('P_API_NAME',l_api_name);
2811: FND_MSG_PUB.add;
2812: x_return_status := fnd_api.g_ret_sts_unexp_error;
2813: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2806: ROLLBACK TO member_denormalize;
2807: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2808: fnd_message.set_token('P_SQLCODE',SQLCODE);
2809: fnd_message.set_token('P_SQLERRM',SQLERRM);
2810: fnd_message.set_token('P_API_NAME',l_api_name);
2811: FND_MSG_PUB.add;
2812: x_return_status := fnd_api.g_ret_sts_unexp_error;
2813: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2814:

Line 2995: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');

2991: EXCEPTION
2992: WHEN fnd_api.g_exc_unexpected_error
2993: THEN
2994: ROLLBACK TO member_denormalize;
2995: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2996: --FND_MSG_PUB.add;
2997: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2998: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2999: WHEN fnd_api.g_exc_error

Line 3007: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3003:
3004: WHEN OTHERS
3005: THEN
3006: ROLLBACK TO member_denormalize;
3007: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3008: fnd_message.set_token('P_SQLCODE',SQLCODE);
3009: fnd_message.set_token('P_SQLERRM',SQLERRM);
3010: fnd_message.set_token('P_API_NAME',l_api_name);
3011: FND_MSG_PUB.add;

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

3004: WHEN OTHERS
3005: THEN
3006: ROLLBACK TO member_denormalize;
3007: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3008: fnd_message.set_token('P_SQLCODE',SQLCODE);
3009: fnd_message.set_token('P_SQLERRM',SQLERRM);
3010: fnd_message.set_token('P_API_NAME',l_api_name);
3011: FND_MSG_PUB.add;
3012: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3005: THEN
3006: ROLLBACK TO member_denormalize;
3007: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3008: fnd_message.set_token('P_SQLCODE',SQLCODE);
3009: fnd_message.set_token('P_SQLERRM',SQLERRM);
3010: fnd_message.set_token('P_API_NAME',l_api_name);
3011: FND_MSG_PUB.add;
3012: x_return_status := fnd_api.g_ret_sts_unexp_error;
3013: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3006: ROLLBACK TO member_denormalize;
3007: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3008: fnd_message.set_token('P_SQLCODE',SQLCODE);
3009: fnd_message.set_token('P_SQLERRM',SQLERRM);
3010: fnd_message.set_token('P_API_NAME',l_api_name);
3011: FND_MSG_PUB.add;
3012: x_return_status := fnd_api.g_ret_sts_unexp_error;
3013: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3014:

Line 3222: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');

3218: -- if no group id or person id is passed in then return
3219: IF p_role_relate_id IS NULL
3220: THEN
3221: x_return_status := fnd_api.g_ret_sts_error;
3222: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');
3223: FND_MSG_PUB.add;
3224: RAISE fnd_api.g_exc_error;
3225: END IF;
3226:

Line 3457: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');

3453: EXCEPTION
3454: WHEN fnd_api.g_exc_unexpected_error
3455: THEN
3456: ROLLBACK TO member_denormalize;
3457: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
3458: --FND_MSG_PUB.add;
3459: --x_return_status := fnd_api.g_ret_sts_unexp_error;
3460: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3461: WHEN fnd_api.g_exc_error

Line 3469: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3465:
3466: WHEN OTHERS
3467: THEN
3468: ROLLBACK TO member_denormalize;
3469: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3470: fnd_message.set_token('P_SQLCODE',SQLCODE);
3471: fnd_message.set_token('P_SQLERRM',SQLERRM);
3472: fnd_message.set_token('P_API_NAME',l_api_name);
3473: FND_MSG_PUB.add;

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

3466: WHEN OTHERS
3467: THEN
3468: ROLLBACK TO member_denormalize;
3469: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3470: fnd_message.set_token('P_SQLCODE',SQLCODE);
3471: fnd_message.set_token('P_SQLERRM',SQLERRM);
3472: fnd_message.set_token('P_API_NAME',l_api_name);
3473: FND_MSG_PUB.add;
3474: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3467: THEN
3468: ROLLBACK TO member_denormalize;
3469: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3470: fnd_message.set_token('P_SQLCODE',SQLCODE);
3471: fnd_message.set_token('P_SQLERRM',SQLERRM);
3472: fnd_message.set_token('P_API_NAME',l_api_name);
3473: FND_MSG_PUB.add;
3474: x_return_status := fnd_api.g_ret_sts_unexp_error;
3475: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3468: ROLLBACK TO member_denormalize;
3469: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3470: fnd_message.set_token('P_SQLCODE',SQLCODE);
3471: fnd_message.set_token('P_SQLERRM',SQLERRM);
3472: fnd_message.set_token('P_API_NAME',l_api_name);
3473: FND_MSG_PUB.add;
3474: x_return_status := fnd_api.g_ret_sts_unexp_error;
3475: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3476:

Line 3861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3857: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3858: WHEN OTHERS
3859: THEN
3860: ROLLBACK TO member_denormalize;
3861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3862: fnd_message.set_token('P_SQLCODE',SQLCODE);
3863: fnd_message.set_token('P_SQLERRM',SQLERRM);
3864: fnd_message.set_token('P_API_NAME',l_api_name);
3865: FND_MSG_PUB.add;

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

3858: WHEN OTHERS
3859: THEN
3860: ROLLBACK TO member_denormalize;
3861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3862: fnd_message.set_token('P_SQLCODE',SQLCODE);
3863: fnd_message.set_token('P_SQLERRM',SQLERRM);
3864: fnd_message.set_token('P_API_NAME',l_api_name);
3865: FND_MSG_PUB.add;
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3859: THEN
3860: ROLLBACK TO member_denormalize;
3861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3862: fnd_message.set_token('P_SQLCODE',SQLCODE);
3863: fnd_message.set_token('P_SQLERRM',SQLERRM);
3864: fnd_message.set_token('P_API_NAME',l_api_name);
3865: FND_MSG_PUB.add;
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3860: ROLLBACK TO member_denormalize;
3861: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3862: fnd_message.set_token('P_SQLCODE',SQLCODE);
3863: fnd_message.set_token('P_SQLERRM',SQLERRM);
3864: fnd_message.set_token('P_API_NAME',l_api_name);
3865: FND_MSG_PUB.add;
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3868: END INSERT_GRP_DENORM;

Line 3975: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

3971: ROLLBACK TO del_rep_mgr_sp;
3972: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3973: WHEN OTHERS THEN
3974: ROLLBACK TO del_rep_mgr_sp;
3975: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3976: fnd_message.set_token('P_SQLCODE',SQLCODE);
3977: fnd_message.set_token('P_SQLERRM',SQLERRM);
3978: fnd_message.set_token('P_API_NAME',l_api_name);
3979: FND_MSG_PUB.add;

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

3972: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3973: WHEN OTHERS THEN
3974: ROLLBACK TO del_rep_mgr_sp;
3975: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3976: fnd_message.set_token('P_SQLCODE',SQLCODE);
3977: fnd_message.set_token('P_SQLERRM',SQLERRM);
3978: fnd_message.set_token('P_API_NAME',l_api_name);
3979: FND_MSG_PUB.add;
3980: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3973: WHEN OTHERS THEN
3974: ROLLBACK TO del_rep_mgr_sp;
3975: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3976: fnd_message.set_token('P_SQLCODE',SQLCODE);
3977: fnd_message.set_token('P_SQLERRM',SQLERRM);
3978: fnd_message.set_token('P_API_NAME',l_api_name);
3979: FND_MSG_PUB.add;
3980: x_return_status := fnd_api.g_ret_sts_unexp_error;
3981: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3974: ROLLBACK TO del_rep_mgr_sp;
3975: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3976: fnd_message.set_token('P_SQLCODE',SQLCODE);
3977: fnd_message.set_token('P_SQLERRM',SQLERRM);
3978: fnd_message.set_token('P_API_NAME',l_api_name);
3979: FND_MSG_PUB.add;
3980: x_return_status := fnd_api.g_ret_sts_unexp_error;
3981: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3982:

Line 4800: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');

4796: WHEN fnd_api.g_exc_unexpected_error
4797: THEN
4798:
4799: ROLLBACK TO member_denormalize;
4800: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
4801: --FND_MSG_PUB.add;
4802: --x_return_status := fnd_api.g_ret_sts_unexp_error;
4803: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4804: WHEN fnd_api.g_exc_error

Line 4812: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

4808:
4809: WHEN OTHERS
4810: THEN
4811: ROLLBACK TO member_denormalize;
4812: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4813: fnd_message.set_token('P_SQLCODE',SQLCODE);
4814: fnd_message.set_token('P_SQLERRM',SQLERRM);
4815: fnd_message.set_token('P_API_NAME',l_api_name);
4816: FND_MSG_PUB.add;

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

4809: WHEN OTHERS
4810: THEN
4811: ROLLBACK TO member_denormalize;
4812: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4813: fnd_message.set_token('P_SQLCODE',SQLCODE);
4814: fnd_message.set_token('P_SQLERRM',SQLERRM);
4815: fnd_message.set_token('P_API_NAME',l_api_name);
4816: FND_MSG_PUB.add;
4817: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4810: THEN
4811: ROLLBACK TO member_denormalize;
4812: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4813: fnd_message.set_token('P_SQLCODE',SQLCODE);
4814: fnd_message.set_token('P_SQLERRM',SQLERRM);
4815: fnd_message.set_token('P_API_NAME',l_api_name);
4816: FND_MSG_PUB.add;
4817: x_return_status := fnd_api.g_ret_sts_unexp_error;
4818: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

4811: ROLLBACK TO member_denormalize;
4812: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4813: fnd_message.set_token('P_SQLCODE',SQLCODE);
4814: fnd_message.set_token('P_SQLERRM',SQLERRM);
4815: fnd_message.set_token('P_API_NAME',l_api_name);
4816: FND_MSG_PUB.add;
4817: x_return_status := fnd_api.g_ret_sts_unexp_error;
4818: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4819: END INSERT_GRP_RELATIONS;