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 373: FND_MSG_PUB.Initialize;

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

Line 386: FND_MSG_PUB.add;

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

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

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

Line 1124: --FND_MSG_PUB.add;

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

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

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

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

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

Line 1139: FND_MSG_PUB.add;

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

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

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

Line 1472: FND_MSG_PUB.Initialize;

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

Line 1485: FND_MSG_PUB.add;

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

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

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

Line 2519: --FND_MSG_PUB.add;

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

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

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

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

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

Line 2534: FND_MSG_PUB.add;

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

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

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

Line 2599: FND_MSG_PUB.Initialize;

2595:
2596: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2597: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2598: THEN
2599: FND_MSG_PUB.Initialize;
2600: END IF;
2601:
2602: IF fnd_api.to_boolean (p_commit)
2603: THEN

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

2660: THEN
2661: COMMIT WORK;
2662: END IF;
2663:
2664: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2665:
2666: EXCEPTION
2667: WHEN fnd_api.g_exc_unexpected_error
2668: THEN

Line 2671: --FND_MSG_PUB.add;

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

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

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

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

2673: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2674: WHEN fnd_api.g_exc_error
2675: THEN
2676: ROLLBACK TO member_denormalize;
2677: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2678:
2679: WHEN OTHERS
2680: THEN
2681: ROLLBACK TO member_denormalize;

Line 2686: FND_MSG_PUB.add;

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

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

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:
2690: END UPDATE_REP_MANAGER;
2691:
2692:

Line 2741: FND_MSG_PUB.Initialize;

2737:
2738: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2739: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2740: THEN
2741: FND_MSG_PUB.Initialize;
2742: END IF;
2743:
2744: IF fnd_api.to_boolean (p_commit)
2745: THEN

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

2785: THEN
2786: COMMIT WORK;
2787: END IF;
2788:
2789: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2790:
2791: EXCEPTION
2792: WHEN fnd_api.g_exc_unexpected_error
2793: THEN

Line 2796: --FND_MSG_PUB.add;

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

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

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

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

2798: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2799: WHEN fnd_api.g_exc_error
2800: THEN
2801: ROLLBACK TO member_denormalize;
2802: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2803:
2804: WHEN OTHERS
2805: THEN
2806: ROLLBACK TO member_denormalize;

Line 2811: FND_MSG_PUB.add;

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

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

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:
2815:
2816: END DELETE_MEMBERS;
2817:

Line 2906: FND_MSG_PUB.Initialize;

2902:
2903: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
2904: IF FND_API.To_boolean(P_INIT_MSG_LIST)
2905: THEN
2906: FND_MSG_PUB.Initialize;
2907: END IF;
2908:
2909: l_date := sysdate;
2910: l_user_id := NVL(FND_PROFILE.Value('USER_ID'), -1);

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

2985: THEN
2986: COMMIT WORK;
2987: END IF;
2988:
2989: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2990:
2991: EXCEPTION
2992: WHEN fnd_api.g_exc_unexpected_error
2993: THEN

Line 2996: --FND_MSG_PUB.add;

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

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

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

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

2998: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2999: WHEN fnd_api.g_exc_error
3000: THEN
3001: ROLLBACK TO member_denormalize;
3002: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3003:
3004: WHEN OTHERS
3005: THEN
3006: ROLLBACK TO member_denormalize;

Line 3011: FND_MSG_PUB.add;

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

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

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:
3015:
3016: END DELETE_GROUP_DENORM;
3017:

Line 3210: FND_MSG_PUB.Initialize;

3206:
3207: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3208: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3209: THEN
3210: FND_MSG_PUB.Initialize;
3211: END IF;
3212:
3213:
3214: l_date := sysdate;

Line 3223: FND_MSG_PUB.add;

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

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

3447: THEN
3448: COMMIT WORK;
3449: END IF;
3450:
3451: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3452:
3453: EXCEPTION
3454: WHEN fnd_api.g_exc_unexpected_error
3455: THEN

Line 3458: --FND_MSG_PUB.add;

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

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

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

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

3460: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3461: WHEN fnd_api.g_exc_error
3462: THEN
3463: ROLLBACK TO member_denormalize;
3464: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3465:
3466: WHEN OTHERS
3467: THEN
3468: ROLLBACK TO member_denormalize;

Line 3473: FND_MSG_PUB.add;

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

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

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:
3477:
3478: END INSERT_REP_MGR_PARENT;
3479:

Line 3794: FND_MSG_PUB.Initialize;

3790:
3791: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3792: IF FND_API.To_boolean(P_INIT_MSG_LIST)
3793: THEN
3794: FND_MSG_PUB.Initialize;
3795: END IF;
3796:
3797:
3798: l_date := sysdate;

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

3849: EXCEPTION
3850: WHEN fnd_api.g_exc_unexpected_error
3851: THEN
3852: ROLLBACK TO member_denormalize;
3853: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3854: WHEN fnd_api.g_exc_error
3855: THEN
3856: ROLLBACK TO member_denormalize;
3857: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3853: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3854: WHEN fnd_api.g_exc_error
3855: THEN
3856: ROLLBACK TO member_denormalize;
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');

Line 3865: FND_MSG_PUB.add;

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

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

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;
3869:
3870:
3871: PROCEDURE DELETE_REP_MGR (

Line 3931: FND_MSG_PUB.Initialize;

3927: END IF;
3928:
3929: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
3930: IF FND_API.To_boolean(P_INIT_MSG_LIST) THEN
3931: FND_MSG_PUB.Initialize;
3932: END IF;
3933:
3934:
3935: l_date := sysdate;

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

3960: IF fnd_api.to_boolean (p_commit) THEN
3961: COMMIT WORK;
3962: END IF;
3963:
3964: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3965:
3966: EXCEPTION
3967: WHEN fnd_api.g_exc_unexpected_error THEN
3968: ROLLBACK TO del_rep_mgr_sp;

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

3965:
3966: EXCEPTION
3967: WHEN fnd_api.g_exc_unexpected_error THEN
3968: ROLLBACK TO del_rep_mgr_sp;
3969: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3970: WHEN fnd_api.g_exc_error THEN
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

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

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

Line 3979: FND_MSG_PUB.add;

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

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

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:
3983: END DELETE_REP_MGR;
3984:
3985:

Line 4213: FND_MSG_PUB.Initialize;

4209:
4210: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
4211: IF FND_API.To_boolean(P_INIT_MSG_LIST)
4212: THEN
4213: FND_MSG_PUB.Initialize;
4214: END IF;
4215:
4216:
4217: l_date := sysdate;

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

4789: THEN
4790: COMMIT WORK;
4791: END IF;
4792:
4793: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4794:
4795: EXCEPTION
4796: WHEN fnd_api.g_exc_unexpected_error
4797: THEN

Line 4801: --FND_MSG_PUB.add;

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

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

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

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

4803: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4804: WHEN fnd_api.g_exc_error
4805: THEN
4806: ROLLBACK TO member_denormalize;
4807: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4808:
4809: WHEN OTHERS
4810: THEN
4811: ROLLBACK TO member_denormalize;

Line 4816: FND_MSG_PUB.add;

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

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

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