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_MSG_PUB

Line 372: FND_MSG_PUB.Initialize;

368:
369: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
370: IF FND_API.To_boolean(P_INIT_MSG_LIST)
371: THEN
372: FND_MSG_PUB.Initialize;
373: END IF;
374:
375:
376: l_date := sysdate;

Line 385: FND_MSG_PUB.add;

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

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

1112: THEN
1113: COMMIT WORK;
1114: END IF;
1115:
1116: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1117:
1118: EXCEPTION
1119: WHEN fnd_api.g_exc_unexpected_error
1120: THEN

Line 1123: --FND_MSG_PUB.add;

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

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

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
1127: THEN
1128: ROLLBACK TO member_denormalize;
1129: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1125: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1126: WHEN fnd_api.g_exc_error
1127: THEN
1128: ROLLBACK TO member_denormalize;
1129: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1130:
1131: WHEN OTHERS
1132: THEN
1133: ROLLBACK TO member_denormalize;

Line 1138: FND_MSG_PUB.add;

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

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

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:
1142:
1143: END INSERT_REP_MANAGER;
1144:

Line 1471: FND_MSG_PUB.Initialize;

1467:
1468: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1469: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1470: THEN
1471: FND_MSG_PUB.Initialize;
1472: END IF;
1473:
1474:
1475: l_date := sysdate;

Line 1484: FND_MSG_PUB.add;

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

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

2507: THEN
2508: COMMIT WORK;
2509: END IF;
2510:
2511: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2512:
2513: EXCEPTION
2514: WHEN fnd_api.g_exc_unexpected_error
2515: THEN

Line 2518: --FND_MSG_PUB.add;

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

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

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
2522: THEN
2523: ROLLBACK TO member_denormalize;
2524: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2520: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2521: WHEN fnd_api.g_exc_error
2522: THEN
2523: ROLLBACK TO member_denormalize;
2524: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2525:
2526: WHEN OTHERS
2527: THEN
2528: ROLLBACK TO member_denormalize;

Line 2533: FND_MSG_PUB.add;

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

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

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:
2537:
2538: END INSERT_REP_MANAGER_MIGR;
2539:

Line 2594: FND_MSG_PUB.Initialize;

2590:
2591: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2592: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2593: THEN
2594: FND_MSG_PUB.Initialize;
2595: END IF;
2596:
2597: IF fnd_api.to_boolean (p_commit)
2598: THEN

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

2647: THEN
2648: COMMIT WORK;
2649: END IF;
2650:
2651: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2652:
2653: EXCEPTION
2654: WHEN fnd_api.g_exc_unexpected_error
2655: THEN

Line 2658: --FND_MSG_PUB.add;

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

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

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
2662: THEN
2663: ROLLBACK TO member_denormalize;
2664: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2660: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2661: WHEN fnd_api.g_exc_error
2662: THEN
2663: ROLLBACK TO member_denormalize;
2664: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2665:
2666: WHEN OTHERS
2667: THEN
2668: ROLLBACK TO member_denormalize;

Line 2673: FND_MSG_PUB.add;

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:
2677: END UPDATE_REP_MANAGER;

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

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:
2677: END UPDATE_REP_MANAGER;
2678:
2679:

Line 2728: FND_MSG_PUB.Initialize;

2724:
2725: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2726: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2727: THEN
2728: FND_MSG_PUB.Initialize;
2729: END IF;
2730:
2731: IF fnd_api.to_boolean (p_commit)
2732: THEN

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

2772: THEN
2773: COMMIT WORK;
2774: END IF;
2775:
2776: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2777:
2778: EXCEPTION
2779: WHEN fnd_api.g_exc_unexpected_error
2780: THEN

Line 2783: --FND_MSG_PUB.add;

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

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

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
2787: THEN
2788: ROLLBACK TO member_denormalize;
2789: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2785: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2786: WHEN fnd_api.g_exc_error
2787: THEN
2788: ROLLBACK TO member_denormalize;
2789: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2790:
2791: WHEN OTHERS
2792: THEN
2793: ROLLBACK TO member_denormalize;

Line 2798: FND_MSG_PUB.add;

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

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

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:
2802:
2803: END DELETE_MEMBERS;
2804:

Line 2893: FND_MSG_PUB.Initialize;

2889:
2890: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2891: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2892: THEN
2893: FND_MSG_PUB.Initialize;
2894: END IF;
2895:
2896: l_date := sysdate;
2897: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

2972: THEN
2973: COMMIT WORK;
2974: END IF;
2975:
2976: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2977:
2978: EXCEPTION
2979: WHEN fnd_api.g_exc_unexpected_error
2980: THEN

Line 2983: --FND_MSG_PUB.add;

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

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

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
2987: THEN
2988: ROLLBACK TO member_denormalize;
2989: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2985: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2986: WHEN fnd_api.g_exc_error
2987: THEN
2988: ROLLBACK TO member_denormalize;
2989: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2990:
2991: WHEN OTHERS
2992: THEN
2993: ROLLBACK TO member_denormalize;

Line 2998: FND_MSG_PUB.add;

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

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

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:
3002:
3003: END DELETE_GROUP_DENORM;
3004:

Line 3197: FND_MSG_PUB.Initialize;

3193:
3194: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3195: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3196: THEN
3197: FND_MSG_PUB.Initialize;
3198: END IF;
3199:
3200:
3201: l_date := sysdate;

Line 3210: FND_MSG_PUB.add;

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

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

3434: THEN
3435: COMMIT WORK;
3436: END IF;
3437:
3438: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3439:
3440: EXCEPTION
3441: WHEN fnd_api.g_exc_unexpected_error
3442: THEN

Line 3445: --FND_MSG_PUB.add;

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

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

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
3449: THEN
3450: ROLLBACK TO member_denormalize;
3451: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3447: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3448: WHEN fnd_api.g_exc_error
3449: THEN
3450: ROLLBACK TO member_denormalize;
3451: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3452:
3453: WHEN OTHERS
3454: THEN
3455: ROLLBACK TO member_denormalize;

Line 3460: FND_MSG_PUB.add;

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

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

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:
3464:
3465: END INSERT_REP_MGR_PARENT;
3466:

Line 3781: FND_MSG_PUB.Initialize;

3777:
3778: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3779: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3780: THEN
3781: FND_MSG_PUB.Initialize;
3782: END IF;
3783:
3784:
3785: l_date := sysdate;

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

3836: EXCEPTION
3837: WHEN fnd_api.g_exc_unexpected_error
3838: THEN
3839: ROLLBACK TO member_denormalize;
3840: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3841: WHEN fnd_api.g_exc_error
3842: THEN
3843: ROLLBACK TO member_denormalize;
3844: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3840: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3841: WHEN fnd_api.g_exc_error
3842: THEN
3843: ROLLBACK TO member_denormalize;
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');

Line 3852: FND_MSG_PUB.add;

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

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

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;
3856:
3857:
3858: PROCEDURE DELETE_REP_MGR (

Line 3918: FND_MSG_PUB.Initialize;

3914: END IF;
3915:
3916: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3917: IF FND_API.To_boolean(P_INIT_MSG_LIST) THEN
3918: FND_MSG_PUB.Initialize;
3919: END IF;
3920:
3921:
3922: l_date := sysdate;

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

3947: IF fnd_api.to_boolean (p_commit) THEN
3948: COMMIT WORK;
3949: END IF;
3950:
3951: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3952:
3953: EXCEPTION
3954: WHEN fnd_api.g_exc_unexpected_error THEN
3955: ROLLBACK TO del_rep_mgr_sp;

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

3952:
3953: EXCEPTION
3954: WHEN fnd_api.g_exc_unexpected_error THEN
3955: ROLLBACK TO del_rep_mgr_sp;
3956: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN fnd_api.g_exc_error THEN
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

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

3955: ROLLBACK TO del_rep_mgr_sp;
3956: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3957: WHEN fnd_api.g_exc_error THEN
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);

Line 3966: FND_MSG_PUB.add;

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:
3970: END DELETE_REP_MGR;

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

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:
3970: END DELETE_REP_MGR;
3971:
3972:

Line 4200: FND_MSG_PUB.Initialize;

4196:
4197: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
4198: IF FND_API.To_boolean(P_INIT_MSG_LIST)
4199: THEN
4200: FND_MSG_PUB.Initialize;
4201: END IF;
4202:
4203:
4204: l_date := sysdate;

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

4776: THEN
4777: COMMIT WORK;
4778: END IF;
4779:
4780: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4781:
4782: EXCEPTION
4783: WHEN fnd_api.g_exc_unexpected_error
4784: THEN

Line 4788: --FND_MSG_PUB.add;

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

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

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
4792: THEN
4793: ROLLBACK TO member_denormalize;
4794: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

4790: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4791: WHEN fnd_api.g_exc_error
4792: THEN
4793: ROLLBACK TO member_denormalize;
4794: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4795:
4796: WHEN OTHERS
4797: THEN
4798: ROLLBACK TO member_denormalize;

Line 4803: FND_MSG_PUB.add;

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;
4807: END JTF_RS_REP_MGR_DENORM_PVT;

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

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;
4807: END JTF_RS_REP_MGR_DENORM_PVT;