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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2653: EXCEPTION
2654: WHEN fnd_api.g_exc_unexpected_error
2655: THEN
2656: ROLLBACK TO member_denormalize;
2657: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2658: --FND_MSG_PUB.add;
2659: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2660: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2661: WHEN fnd_api.g_exc_error

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

2665:
2666: WHEN OTHERS
2667: THEN
2668: ROLLBACK TO member_denormalize;
2669: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2670: fnd_message.set_token('P_SQLCODE',SQLCODE);
2671: fnd_message.set_token('P_SQLERRM',SQLERRM);
2672: fnd_message.set_token('P_API_NAME',l_api_name);
2673: FND_MSG_PUB.add;

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

2666: WHEN OTHERS
2667: THEN
2668: ROLLBACK TO member_denormalize;
2669: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2670: fnd_message.set_token('P_SQLCODE',SQLCODE);
2671: fnd_message.set_token('P_SQLERRM',SQLERRM);
2672: fnd_message.set_token('P_API_NAME',l_api_name);
2673: FND_MSG_PUB.add;
2674: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2667: THEN
2668: ROLLBACK TO member_denormalize;
2669: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2670: fnd_message.set_token('P_SQLCODE',SQLCODE);
2671: fnd_message.set_token('P_SQLERRM',SQLERRM);
2672: fnd_message.set_token('P_API_NAME',l_api_name);
2673: FND_MSG_PUB.add;
2674: x_return_status := fnd_api.g_ret_sts_unexp_error;
2675: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2668: ROLLBACK TO member_denormalize;
2669: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2670: fnd_message.set_token('P_SQLCODE',SQLCODE);
2671: fnd_message.set_token('P_SQLERRM',SQLERRM);
2672: fnd_message.set_token('P_API_NAME',l_api_name);
2673: FND_MSG_PUB.add;
2674: x_return_status := fnd_api.g_ret_sts_unexp_error;
2675: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2676:

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

2778: EXCEPTION
2779: WHEN fnd_api.g_exc_unexpected_error
2780: THEN
2781: ROLLBACK TO member_denormalize;
2782: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2783: --FND_MSG_PUB.add;
2784: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2785: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2786: WHEN fnd_api.g_exc_error

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

2790:
2791: WHEN OTHERS
2792: THEN
2793: ROLLBACK TO member_denormalize;
2794: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2795: fnd_message.set_token('P_SQLCODE',SQLCODE);
2796: fnd_message.set_token('P_SQLERRM',SQLERRM);
2797: fnd_message.set_token('P_API_NAME',l_api_name);
2798: FND_MSG_PUB.add;

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

2791: WHEN OTHERS
2792: THEN
2793: ROLLBACK TO member_denormalize;
2794: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2795: fnd_message.set_token('P_SQLCODE',SQLCODE);
2796: fnd_message.set_token('P_SQLERRM',SQLERRM);
2797: fnd_message.set_token('P_API_NAME',l_api_name);
2798: FND_MSG_PUB.add;
2799: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2792: THEN
2793: ROLLBACK TO member_denormalize;
2794: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2795: fnd_message.set_token('P_SQLCODE',SQLCODE);
2796: fnd_message.set_token('P_SQLERRM',SQLERRM);
2797: fnd_message.set_token('P_API_NAME',l_api_name);
2798: FND_MSG_PUB.add;
2799: x_return_status := fnd_api.g_ret_sts_unexp_error;
2800: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2793: ROLLBACK TO member_denormalize;
2794: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2795: fnd_message.set_token('P_SQLCODE',SQLCODE);
2796: fnd_message.set_token('P_SQLERRM',SQLERRM);
2797: fnd_message.set_token('P_API_NAME',l_api_name);
2798: FND_MSG_PUB.add;
2799: x_return_status := fnd_api.g_ret_sts_unexp_error;
2800: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2801:

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

2978: EXCEPTION
2979: WHEN fnd_api.g_exc_unexpected_error
2980: THEN
2981: ROLLBACK TO member_denormalize;
2982: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
2983: --FND_MSG_PUB.add;
2984: --x_return_status := fnd_api.g_ret_sts_unexp_error;
2985: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2986: WHEN fnd_api.g_exc_error

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

2990:
2991: WHEN OTHERS
2992: THEN
2993: ROLLBACK TO member_denormalize;
2994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2995: fnd_message.set_token('P_SQLCODE',SQLCODE);
2996: fnd_message.set_token('P_SQLERRM',SQLERRM);
2997: fnd_message.set_token('P_API_NAME',l_api_name);
2998: FND_MSG_PUB.add;

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

2991: WHEN OTHERS
2992: THEN
2993: ROLLBACK TO member_denormalize;
2994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2995: fnd_message.set_token('P_SQLCODE',SQLCODE);
2996: fnd_message.set_token('P_SQLERRM',SQLERRM);
2997: fnd_message.set_token('P_API_NAME',l_api_name);
2998: FND_MSG_PUB.add;
2999: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

2992: THEN
2993: ROLLBACK TO member_denormalize;
2994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2995: fnd_message.set_token('P_SQLCODE',SQLCODE);
2996: fnd_message.set_token('P_SQLERRM',SQLERRM);
2997: fnd_message.set_token('P_API_NAME',l_api_name);
2998: FND_MSG_PUB.add;
2999: x_return_status := fnd_api.g_ret_sts_unexp_error;
3000: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2993: ROLLBACK TO member_denormalize;
2994: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
2995: fnd_message.set_token('P_SQLCODE',SQLCODE);
2996: fnd_message.set_token('P_SQLERRM',SQLERRM);
2997: fnd_message.set_token('P_API_NAME',l_api_name);
2998: FND_MSG_PUB.add;
2999: x_return_status := fnd_api.g_ret_sts_unexp_error;
3000: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3001:

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

3205: -- if no group id or person id is passed in then return
3206: IF p_role_relate_id IS NULL
3207: THEN
3208: x_return_status := fnd_api.g_ret_sts_error;
3209: fnd_message.set_name ('JTF', 'JTF_RS_GROUP_RESOURCE_NULL');
3210: FND_MSG_PUB.add;
3211: RAISE fnd_api.g_exc_error;
3212: END IF;
3213:

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

3440: EXCEPTION
3441: WHEN fnd_api.g_exc_unexpected_error
3442: THEN
3443: ROLLBACK TO member_denormalize;
3444: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
3445: --FND_MSG_PUB.add;
3446: --x_return_status := fnd_api.g_ret_sts_unexp_error;
3447: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3448: WHEN fnd_api.g_exc_error

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

3452:
3453: WHEN OTHERS
3454: THEN
3455: ROLLBACK TO member_denormalize;
3456: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3457: fnd_message.set_token('P_SQLCODE',SQLCODE);
3458: fnd_message.set_token('P_SQLERRM',SQLERRM);
3459: fnd_message.set_token('P_API_NAME',l_api_name);
3460: FND_MSG_PUB.add;

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

3453: WHEN OTHERS
3454: THEN
3455: ROLLBACK TO member_denormalize;
3456: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3457: fnd_message.set_token('P_SQLCODE',SQLCODE);
3458: fnd_message.set_token('P_SQLERRM',SQLERRM);
3459: fnd_message.set_token('P_API_NAME',l_api_name);
3460: FND_MSG_PUB.add;
3461: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3454: THEN
3455: ROLLBACK TO member_denormalize;
3456: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3457: fnd_message.set_token('P_SQLCODE',SQLCODE);
3458: fnd_message.set_token('P_SQLERRM',SQLERRM);
3459: fnd_message.set_token('P_API_NAME',l_api_name);
3460: FND_MSG_PUB.add;
3461: x_return_status := fnd_api.g_ret_sts_unexp_error;
3462: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3455: ROLLBACK TO member_denormalize;
3456: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3457: fnd_message.set_token('P_SQLCODE',SQLCODE);
3458: fnd_message.set_token('P_SQLERRM',SQLERRM);
3459: fnd_message.set_token('P_API_NAME',l_api_name);
3460: FND_MSG_PUB.add;
3461: x_return_status := fnd_api.g_ret_sts_unexp_error;
3462: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3463:

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

3844: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3845: WHEN OTHERS
3846: THEN
3847: ROLLBACK TO member_denormalize;
3848: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3849: fnd_message.set_token('P_SQLCODE',SQLCODE);
3850: fnd_message.set_token('P_SQLERRM',SQLERRM);
3851: fnd_message.set_token('P_API_NAME',l_api_name);
3852: FND_MSG_PUB.add;

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

3845: WHEN OTHERS
3846: THEN
3847: ROLLBACK TO member_denormalize;
3848: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3849: fnd_message.set_token('P_SQLCODE',SQLCODE);
3850: fnd_message.set_token('P_SQLERRM',SQLERRM);
3851: fnd_message.set_token('P_API_NAME',l_api_name);
3852: FND_MSG_PUB.add;
3853: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3846: THEN
3847: ROLLBACK TO member_denormalize;
3848: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3849: fnd_message.set_token('P_SQLCODE',SQLCODE);
3850: fnd_message.set_token('P_SQLERRM',SQLERRM);
3851: fnd_message.set_token('P_API_NAME',l_api_name);
3852: FND_MSG_PUB.add;
3853: x_return_status := fnd_api.g_ret_sts_unexp_error;
3854: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3847: ROLLBACK TO member_denormalize;
3848: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3849: fnd_message.set_token('P_SQLCODE',SQLCODE);
3850: fnd_message.set_token('P_SQLERRM',SQLERRM);
3851: fnd_message.set_token('P_API_NAME',l_api_name);
3852: FND_MSG_PUB.add;
3853: x_return_status := fnd_api.g_ret_sts_unexp_error;
3854: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3855: END INSERT_GRP_DENORM;

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

3958: ROLLBACK TO del_rep_mgr_sp;
3959: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: ROLLBACK TO del_rep_mgr_sp;
3962: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3963: fnd_message.set_token('P_SQLCODE',SQLCODE);
3964: fnd_message.set_token('P_SQLERRM',SQLERRM);
3965: fnd_message.set_token('P_API_NAME',l_api_name);
3966: FND_MSG_PUB.add;

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

3959: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: ROLLBACK TO del_rep_mgr_sp;
3962: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3963: fnd_message.set_token('P_SQLCODE',SQLCODE);
3964: fnd_message.set_token('P_SQLERRM',SQLERRM);
3965: fnd_message.set_token('P_API_NAME',l_api_name);
3966: FND_MSG_PUB.add;
3967: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3960: WHEN OTHERS THEN
3961: ROLLBACK TO del_rep_mgr_sp;
3962: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3963: fnd_message.set_token('P_SQLCODE',SQLCODE);
3964: fnd_message.set_token('P_SQLERRM',SQLERRM);
3965: fnd_message.set_token('P_API_NAME',l_api_name);
3966: FND_MSG_PUB.add;
3967: x_return_status := fnd_api.g_ret_sts_unexp_error;
3968: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3961: ROLLBACK TO del_rep_mgr_sp;
3962: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
3963: fnd_message.set_token('P_SQLCODE',SQLCODE);
3964: fnd_message.set_token('P_SQLERRM',SQLERRM);
3965: fnd_message.set_token('P_API_NAME',l_api_name);
3966: FND_MSG_PUB.add;
3967: x_return_status := fnd_api.g_ret_sts_unexp_error;
3968: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3969:

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

4783: WHEN fnd_api.g_exc_unexpected_error
4784: THEN
4785:
4786: ROLLBACK TO member_denormalize;
4787: --fnd_message.set_name ('JTF', 'JTF_RS_REP_MGR_DENORM_ERR');
4788: --FND_MSG_PUB.add;
4789: --x_return_status := fnd_api.g_ret_sts_unexp_error;
4790: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4791: WHEN fnd_api.g_exc_error

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

4795:
4796: WHEN OTHERS
4797: THEN
4798: ROLLBACK TO member_denormalize;
4799: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4800: fnd_message.set_token('P_SQLCODE',SQLCODE);
4801: fnd_message.set_token('P_SQLERRM',SQLERRM);
4802: fnd_message.set_token('P_API_NAME',l_api_name);
4803: FND_MSG_PUB.add;

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

4796: WHEN OTHERS
4797: THEN
4798: ROLLBACK TO member_denormalize;
4799: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4800: fnd_message.set_token('P_SQLCODE',SQLCODE);
4801: fnd_message.set_token('P_SQLERRM',SQLERRM);
4802: fnd_message.set_token('P_API_NAME',l_api_name);
4803: FND_MSG_PUB.add;
4804: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4797: THEN
4798: ROLLBACK TO member_denormalize;
4799: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4800: fnd_message.set_token('P_SQLCODE',SQLCODE);
4801: fnd_message.set_token('P_SQLERRM',SQLERRM);
4802: fnd_message.set_token('P_API_NAME',l_api_name);
4803: FND_MSG_PUB.add;
4804: x_return_status := fnd_api.g_ret_sts_unexp_error;
4805: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

4798: ROLLBACK TO member_denormalize;
4799: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
4800: fnd_message.set_token('P_SQLCODE',SQLCODE);
4801: fnd_message.set_token('P_SQLERRM',SQLERRM);
4802: fnd_message.set_token('P_API_NAME',l_api_name);
4803: FND_MSG_PUB.add;
4804: x_return_status := fnd_api.g_ret_sts_unexp_error;
4805: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4806: END INSERT_GRP_RELATIONS;