DBA Data[Home] [Help]

APPS.HZ_PERSON_BO_PUB dependencies on FND_MSG_PUB

Line 736: FND_MSG_PUB.initialize;

732: x_return_status := FND_API.G_RET_STS_SUCCESS;
733:
734: -- Initialize message list if p_init_msg_list is set to TRUE.
735: IF FND_API.to_Boolean(p_init_msg_list) THEN
736: FND_MSG_PUB.initialize;
737: END IF;
738:
739: -- initialize Global variable
740: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

Line 1504: FND_MSG_PUB.ADD;

1500: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1501:
1502: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1503: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1504: FND_MSG_PUB.ADD;
1505:
1506: x_return_status := fnd_api.g_ret_sts_error;
1507:
1508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1504: FND_MSG_PUB.ADD;
1505:
1506: x_return_status := fnd_api.g_ret_sts_error;
1507:
1508: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1509: p_count => x_msg_count,
1510: p_data => x_msg_data);
1511:
1512: -- Debug info.

Line 1534: FND_MSG_PUB.ADD;

1530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1531:
1532: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1533: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1534: FND_MSG_PUB.ADD;
1535:
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537:
1538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 1538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1534: FND_MSG_PUB.ADD;
1535:
1536: x_return_status := fnd_api.g_ret_sts_unexp_error;
1537:
1538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data);
1541:
1542: -- Debug info.

Line 1564: FND_MSG_PUB.ADD;

1560: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1561:
1562: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1563: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
1564: FND_MSG_PUB.ADD;
1565:
1566: x_return_status := fnd_api.g_ret_sts_unexp_error;
1567:
1568: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1570: fnd_msg_pub.add;

1566: x_return_status := fnd_api.g_ret_sts_unexp_error;
1567:
1568: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1569: fnd_message.set_token('ERROR' ,SQLERRM);
1570: fnd_msg_pub.add;
1571:
1572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1573: p_count => x_msg_count,
1574: p_data => x_msg_data);

Line 1572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1568: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1569: fnd_message.set_token('ERROR' ,SQLERRM);
1570: fnd_msg_pub.add;
1571:
1572: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1573: p_count => x_msg_count,
1574: p_data => x_msg_data);
1575:
1576: -- Debug info.

Line 1709: FND_MSG_PUB.initialize;

1705: x_return_status := FND_API.G_RET_STS_SUCCESS;
1706:
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN
1709: FND_MSG_PUB.initialize;
1710: END IF;
1711:
1712: -- initialize Global variable
1713: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

Line 2097: FND_MSG_PUB.ADD;

2093: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2094:
2095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2096: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2097: FND_MSG_PUB.ADD;
2098:
2099: x_return_status := fnd_api.g_ret_sts_error;
2100:
2101: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2101: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2097: FND_MSG_PUB.ADD;
2098:
2099: x_return_status := fnd_api.g_ret_sts_error;
2100:
2101: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2102: p_count => x_msg_count,
2103: p_data => x_msg_data);
2104:
2105: -- Debug info.

Line 2128: FND_MSG_PUB.ADD;

2124: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2125:
2126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2127: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2128: FND_MSG_PUB.ADD;
2129:
2130: x_return_status := fnd_api.g_ret_sts_unexp_error;
2131:
2132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 2132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2128: FND_MSG_PUB.ADD;
2129:
2130: x_return_status := fnd_api.g_ret_sts_unexp_error;
2131:
2132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2133: p_count => x_msg_count,
2134: p_data => x_msg_data);
2135:
2136: -- Debug info.

Line 2157: FND_MSG_PUB.ADD;

2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2156: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2157: FND_MSG_PUB.ADD;
2158:
2159: x_return_status := fnd_api.g_ret_sts_unexp_error;
2160:
2161: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2163: fnd_msg_pub.add;

2159: x_return_status := fnd_api.g_ret_sts_unexp_error;
2160:
2161: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2162: fnd_message.set_token('ERROR' ,SQLERRM);
2163: fnd_msg_pub.add;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);

Line 2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2161: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2162: fnd_message.set_token('ERROR' ,SQLERRM);
2163: fnd_msg_pub.add;
2164:
2165: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);
2168:
2169: -- Debug info.

Line 2277: FND_MSG_PUB.initialize;

2273: x_return_status := FND_API.G_RET_STS_SUCCESS;
2274:
2275: -- Initialize message list if p_init_msg_list is set to TRUE.
2276: IF FND_API.to_Boolean(p_init_msg_list) THEN
2277: FND_MSG_PUB.initialize;
2278: END IF;
2279:
2280: -- Debug info.
2281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2303: FND_MSG_PUB.ADD;

2299: p_parent_obj_type=> NULL);
2300:
2301: IF(l_create_update_flag = 'E') THEN
2302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2303: FND_MSG_PUB.ADD;
2304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2305: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;

Line 2306: FND_MSG_PUB.ADD;

2302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2303: FND_MSG_PUB.ADD;
2304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2305: FND_MESSAGE.SET_TOKEN('OBJECT', 'PERSON');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310: IF(l_create_update_flag = 'C') THEN

Line 2361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2357: EXCEPTION
2358: WHEN fnd_api.g_exc_error THEN
2359: x_return_status := fnd_api.g_ret_sts_error;
2360:
2361: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2362: p_count => x_msg_count,
2363: p_data => x_msg_data);
2364:
2365: -- Debug info.

Line 2381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2377:
2378: WHEN fnd_api.g_exc_unexpected_error THEN
2379: x_return_status := fnd_api.g_ret_sts_unexp_error;
2380:
2381: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2382: p_count => x_msg_count,
2383: p_data => x_msg_data);
2384:
2385: -- Debug info.

Line 2402: fnd_msg_pub.add;

2398: x_return_status := fnd_api.g_ret_sts_unexp_error;
2399:
2400: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR' ,SQLERRM);
2402: fnd_msg_pub.add;
2403:
2404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);

Line 2404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2400: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR' ,SQLERRM);
2402: fnd_msg_pub.add;
2403:
2404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);
2407:
2408: -- Debug info.

Line 2583: FND_MSG_PUB.ADD;

2579: p_msg_level=>fnd_log.level_procedure);
2580: END IF;
2581: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2582: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2583: FND_MSG_PUB.ADD;
2584: RAISE FND_API.G_EXC_ERROR;
2585: END IF;
2586:
2587: -- assign person language_use_reference_id

Line 2619: FND_MSG_PUB.ADD;

2615: p_msg_level=>fnd_log.level_procedure);
2616: END IF;
2617: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2618: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
2619: FND_MSG_PUB.ADD;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:
2623: -- assign education_id

Line 2655: FND_MSG_PUB.ADD;

2651: p_msg_level=>fnd_log.level_procedure);
2652: END IF;
2653: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2654: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
2655: FND_MSG_PUB.ADD;
2656: RAISE FND_API.G_EXC_ERROR;
2657: END IF;
2658:
2659: -- assign citizenship_id

Line 2691: FND_MSG_PUB.ADD;

2687: p_msg_level=>fnd_log.level_procedure);
2688: END IF;
2689: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
2690: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
2691: FND_MSG_PUB.ADD;
2692: RAISE FND_API.G_EXC_ERROR;
2693: ELSE
2694:
2695: -- assign employment_history_id

Line 2726: FND_MSG_PUB.ADD;

2722: p_msg_level=>fnd_log.level_procedure);
2723: END IF;
2724: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2725: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
2726: FND_MSG_PUB.ADD;
2727: RAISE FND_API.G_EXC_ERROR;
2728: END IF;
2729:
2730: -- assign work_class_id

Line 2765: FND_MSG_PUB.ADD;

2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2764: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
2765: FND_MSG_PUB.ADD;
2766: RAISE FND_API.G_EXC_ERROR;
2767: END IF;
2768:
2769: -- assign person_interest_id

Line 2791: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2787: WHEN fnd_api.g_exc_error THEN
2788: ROLLBACK TO create_person_info_pub;
2789: x_return_status := fnd_api.g_ret_sts_error;
2790:
2791: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2792: p_count => x_msg_count,
2793: p_data => x_msg_data);
2794:
2795: -- Debug info.

Line 2811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2807: WHEN fnd_api.g_exc_unexpected_error THEN
2808: ROLLBACK TO create_person_info_pub;
2809: x_return_status := fnd_api.g_ret_sts_unexp_error;
2810:
2811: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2812: p_count => x_msg_count,
2813: p_data => x_msg_data);
2814:
2815: -- Debug info.

Line 2834: fnd_msg_pub.add;

2830: x_return_status := fnd_api.g_ret_sts_unexp_error;
2831:
2832: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2833: fnd_message.set_token('ERROR' ,SQLERRM);
2834: fnd_msg_pub.add;
2835:
2836: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2837: p_count => x_msg_count,
2838: p_data => x_msg_data);

Line 2836: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2832: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2833: fnd_message.set_token('ERROR' ,SQLERRM);
2834: fnd_msg_pub.add;
2835:
2836: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2837: p_count => x_msg_count,
2838: p_data => x_msg_data);
2839:
2840: -- Debug info.

Line 2944: FND_MSG_PUB.ADD;

2940: p_prefix=>l_debug_prefix,
2941: p_msg_level=>fnd_log.level_procedure);
2942: END IF;
2943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2944: FND_MSG_PUB.ADD;
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2946: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2947: FND_MSG_PUB.ADD;
2948: RAISE FND_API.G_EXC_ERROR;

Line 2947: FND_MSG_PUB.ADD;

2943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2944: FND_MSG_PUB.ADD;
2945: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2946: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2947: FND_MSG_PUB.ADD;
2948: RAISE FND_API.G_EXC_ERROR;
2949: END IF;
2950:
2951: IF(l_ovn IS NULL) THEN

Line 2984: FND_MSG_PUB.ADD;

2980: p_msg_level=>fnd_log.level_procedure);
2981: END IF;
2982: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2983: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_LANGUAGE');
2984: FND_MSG_PUB.ADD;
2985: RAISE FND_API.G_EXC_ERROR;
2986: END IF;
2987: END LOOP;
2988: END IF;

Line 3017: FND_MSG_PUB.ADD;

3013: p_prefix=>l_debug_prefix,
3014: p_msg_level=>fnd_log.level_procedure);
3015: END IF;
3016: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3019: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;

Line 3020: FND_MSG_PUB.ADD;

3016: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3017: FND_MSG_PUB.ADD;
3018: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3019: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
3020: FND_MSG_PUB.ADD;
3021: RAISE FND_API.G_EXC_ERROR;
3022: END IF;
3023:
3024: IF(l_ovn IS NULL) THEN

Line 3057: FND_MSG_PUB.ADD;

3053: p_msg_level=>fnd_log.level_procedure);
3054: END IF;
3055: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3056: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_EDUCATION');
3057: FND_MSG_PUB.ADD;
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060: END LOOP;
3061: END IF;

Line 3088: FND_MSG_PUB.ADD;

3084: p_prefix=>l_debug_prefix,
3085: p_msg_level=>fnd_log.level_procedure);
3086: END IF;
3087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3088: FND_MSG_PUB.ADD;
3089: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3090: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
3091: FND_MSG_PUB.ADD;
3092: RAISE FND_API.G_EXC_ERROR;

Line 3091: FND_MSG_PUB.ADD;

3087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3088: FND_MSG_PUB.ADD;
3089: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3090: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
3091: FND_MSG_PUB.ADD;
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3095: IF(l_ovn IS NULL) THEN

Line 3128: FND_MSG_PUB.ADD;

3124: p_msg_level=>fnd_log.level_procedure);
3125: END IF;
3126: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3127: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CITIZENSHIP');
3128: FND_MSG_PUB.ADD;
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;
3131: END LOOP;
3132: END IF;

Line 3161: FND_MSG_PUB.ADD;

3157: p_prefix=>l_debug_prefix,
3158: p_msg_level=>fnd_log.level_procedure);
3159: END IF;
3160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3161: FND_MSG_PUB.ADD;
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
3163: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_ERROR;

Line 3164: FND_MSG_PUB.ADD;

3160: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3161: FND_MSG_PUB.ADD;
3162: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
3163: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
3164: FND_MSG_PUB.ADD;
3165: RAISE FND_API.G_EXC_ERROR;
3166: END IF;
3167:
3168: IF(l_ovn IS NULL) THEN

Line 3202: FND_MSG_PUB.ADD;

3198: p_msg_level=>fnd_log.level_procedure);
3199: END IF;
3200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
3201: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_EMPLOYMENT_HISTORY');
3202: FND_MSG_PUB.ADD;
3203: RAISE FND_API.G_EXC_ERROR;
3204: ELSE
3205: ---------------------------
3206: -- Create/Update work class

Line 3230: FND_MSG_PUB.ADD;

3226: p_prefix=>l_debug_prefix,
3227: p_msg_level=>fnd_log.level_procedure);
3228: END IF;
3229: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3230: FND_MSG_PUB.ADD;
3231: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3232: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
3233: FND_MSG_PUB.ADD;
3234: RAISE FND_API.G_EXC_ERROR;

Line 3233: FND_MSG_PUB.ADD;

3229: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3230: FND_MSG_PUB.ADD;
3231: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3232: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
3233: FND_MSG_PUB.ADD;
3234: RAISE FND_API.G_EXC_ERROR;
3235: END IF;
3236:
3237: IF(l_ovn IS NULL) THEN

Line 3270: FND_MSG_PUB.ADD;

3266: p_msg_level=>fnd_log.level_procedure);
3267: END IF;
3268: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3269: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_WORK_CLASS');
3270: FND_MSG_PUB.ADD;
3271: RAISE FND_API.G_EXC_ERROR;
3272: END IF;
3273: END LOOP;
3274: END IF;

Line 3306: FND_MSG_PUB.ADD;

3302: p_prefix=>l_debug_prefix,
3303: p_msg_level=>fnd_log.level_procedure);
3304: END IF;
3305: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3306: FND_MSG_PUB.ADD;
3307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;

Line 3309: FND_MSG_PUB.ADD;

3305: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3306: FND_MSG_PUB.ADD;
3307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3308: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
3309: FND_MSG_PUB.ADD;
3310: RAISE FND_API.G_EXC_ERROR;
3311: END IF;
3312:
3313: IF(l_ovn IS NULL) THEN

Line 3346: FND_MSG_PUB.ADD;

3342: p_msg_level=>fnd_log.level_procedure);
3343: END IF;
3344: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3345: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PERSON_INTEREST');
3346: FND_MSG_PUB.ADD;
3347: RAISE FND_API.G_EXC_ERROR;
3348: END IF;
3349: END LOOP;
3350: END IF;

Line 3369: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3365: WHEN fnd_api.g_exc_error THEN
3366: ROLLBACK TO save_person_info_pub;
3367: x_return_status := fnd_api.g_ret_sts_error;
3368:
3369: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3370: p_count => x_msg_count,
3371: p_data => x_msg_data);
3372:
3373: -- Debug info.

Line 3389: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3385: WHEN fnd_api.g_exc_unexpected_error THEN
3386: ROLLBACK TO save_person_info_pub;
3387: x_return_status := fnd_api.g_ret_sts_unexp_error;
3388:
3389: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3390: p_count => x_msg_count,
3391: p_data => x_msg_data);
3392:
3393: -- Debug info.

Line 3412: fnd_msg_pub.add;

3408: x_return_status := fnd_api.g_ret_sts_unexp_error;
3409:
3410: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3411: fnd_message.set_token('ERROR' ,SQLERRM);
3412: fnd_msg_pub.add;
3413:
3414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3415: p_count => x_msg_count,
3416: p_data => x_msg_data);

Line 3414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3410: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3411: fnd_message.set_token('ERROR' ,SQLERRM);
3412: fnd_msg_pub.add;
3413:
3414: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3415: p_count => x_msg_count,
3416: p_data => x_msg_data);
3417:
3418: -- Debug info.

Line 3523: FND_MSG_PUB.initialize;

3519: x_return_status := FND_API.G_RET_STS_SUCCESS;
3520:
3521: -- Initialize message list if p_init_msg_list is set to TRUE
3522: IF FND_API.to_Boolean(p_init_msg_list) THEN
3523: FND_MSG_PUB.initialize;
3524: END IF;
3525:
3526:
3527: -- Debug info.

Line 3589: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3585:
3586: WHEN fnd_api.g_exc_error THEN
3587: x_return_status := fnd_api.g_ret_sts_error;
3588:
3589: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3590: p_count => x_msg_count,
3591: p_data => x_msg_data);
3592:
3593: -- Debug info.

Line 3608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3604: END IF;
3605: WHEN fnd_api.g_exc_unexpected_error THEN
3606: x_return_status := fnd_api.g_ret_sts_unexp_error;
3607:
3608: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3609: p_count => x_msg_count,
3610: p_data => x_msg_data);
3611:
3612: -- Debug info.

Line 3629: fnd_msg_pub.add;

3625: x_return_status := fnd_api.g_ret_sts_unexp_error;
3626:
3627: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3628: fnd_message.set_token('ERROR' ,SQLERRM);
3629: fnd_msg_pub.add;
3630:
3631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3632: p_count => x_msg_count,
3633: p_data => x_msg_data);

Line 3631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3627: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3628: fnd_message.set_token('ERROR' ,SQLERRM);
3629: fnd_msg_pub.add;
3630:
3631: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3632: p_count => x_msg_count,
3633: p_data => x_msg_data);
3634:
3635: -- Debug info.

Line 3742: FND_MSG_PUB.initialize;

3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739:
3740: -- Initialize message list if p_init_msg_list is set to TRUE
3741: IF FND_API.to_Boolean(p_init_msg_list) THEN
3742: FND_MSG_PUB.initialize;
3743: END IF;
3744:
3745:
3746: -- Debug info.

Line 3799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3795:
3796: WHEN fnd_api.g_exc_error THEN
3797: x_return_status := fnd_api.g_ret_sts_error;
3798:
3799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3800: p_count => x_msg_count,
3801: p_data => x_msg_data);
3802:
3803: -- Debug info.

Line 3818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3814: END IF;
3815: WHEN fnd_api.g_exc_unexpected_error THEN
3816: x_return_status := fnd_api.g_ret_sts_unexp_error;
3817:
3818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data);
3821:
3822: -- Debug info.

Line 3839: fnd_msg_pub.add;

3835: x_return_status := fnd_api.g_ret_sts_unexp_error;
3836:
3837: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3838: fnd_message.set_token('ERROR' ,SQLERRM);
3839: fnd_msg_pub.add;
3840:
3841: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3842: p_count => x_msg_count,
3843: p_data => x_msg_data);

Line 3841: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3837: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3838: fnd_message.set_token('ERROR' ,SQLERRM);
3839: fnd_msg_pub.add;
3840:
3841: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3842: p_count => x_msg_count,
3843: p_data => x_msg_data);
3844:
3845: -- Debug info.

Line 3945: FND_MSG_PUB.initialize;

3941: x_return_status := FND_API.G_RET_STS_SUCCESS;
3942:
3943: -- Initialize message list if p_init_msg_list is set to TRUE
3944: IF FND_API.to_Boolean(p_init_msg_list) THEN
3945: FND_MSG_PUB.initialize;
3946: END IF;
3947:
3948:
3949: -- Debug info.

Line 4001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

3997:
3998: WHEN fnd_api.g_exc_error THEN
3999: x_return_status := fnd_api.g_ret_sts_error;
4000:
4001: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4002: p_count => x_msg_count,
4003: p_data => x_msg_data);
4004:
4005: -- Debug info.

Line 4020: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4016: END IF;
4017: WHEN fnd_api.g_exc_unexpected_error THEN
4018: x_return_status := fnd_api.g_ret_sts_unexp_error;
4019:
4020: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4021: p_count => x_msg_count,
4022: p_data => x_msg_data);
4023:
4024: -- Debug info.

Line 4041: fnd_msg_pub.add;

4037: x_return_status := fnd_api.g_ret_sts_unexp_error;
4038:
4039: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4040: fnd_message.set_token('ERROR' ,SQLERRM);
4041: fnd_msg_pub.add;
4042:
4043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4044: p_count => x_msg_count,
4045: p_data => x_msg_data);

Line 4043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4039: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4040: fnd_message.set_token('ERROR' ,SQLERRM);
4041: fnd_msg_pub.add;
4042:
4043: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4044: p_count => x_msg_count,
4045: p_data => x_msg_data);
4046:
4047: -- Debug info.

Line 4139: FND_MSG_PUB.initialize;

4135: x_return_status := FND_API.G_RET_STS_SUCCESS;
4136:
4137: -- Initialize message list if p_init_msg_list is set to TRUE
4138: IF FND_API.to_Boolean(p_init_msg_list) THEN
4139: FND_MSG_PUB.initialize;
4140: END IF;
4141:
4142:
4143: -- Debug info.

Line 4197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4193:
4194: WHEN fnd_api.g_exc_error THEN
4195: x_return_status := fnd_api.g_ret_sts_error;
4196:
4197: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4198: p_count => x_msg_count,
4199: p_data => x_msg_data);
4200:
4201: -- Debug info.

Line 4216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4212: END IF;
4213: WHEN fnd_api.g_exc_unexpected_error THEN
4214: x_return_status := fnd_api.g_ret_sts_unexp_error;
4215:
4216: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4217: p_count => x_msg_count,
4218: p_data => x_msg_data);
4219:
4220: -- Debug info.

Line 4237: fnd_msg_pub.add;

4233: x_return_status := fnd_api.g_ret_sts_unexp_error;
4234:
4235: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4236: fnd_message.set_token('ERROR' ,SQLERRM);
4237: fnd_msg_pub.add;
4238:
4239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4240: p_count => x_msg_count,
4241: p_data => x_msg_data);

Line 4239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4235: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4236: fnd_message.set_token('ERROR' ,SQLERRM);
4237: fnd_msg_pub.add;
4238:
4239: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4240: p_count => x_msg_count,
4241: p_data => x_msg_data);
4242:
4243: -- Debug info.

Line 4301: FND_MSG_PUB.initialize;

4297: x_return_status := FND_API.G_RET_STS_SUCCESS;
4298:
4299: -- Initialize message list if p_init_msg_list is set to TRUE
4300: IF FND_API.to_Boolean(p_init_msg_list) THEN
4301: FND_MSG_PUB.initialize;
4302: END IF;
4303:
4304:
4305: -- Debug info.

Line 4357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4353:
4354: WHEN fnd_api.g_exc_error THEN
4355: x_return_status := fnd_api.g_ret_sts_error;
4356:
4357: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4358: p_count => x_msg_count,
4359: p_data => x_msg_data);
4360:
4361: -- Debug info.

Line 4376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4372: END IF;
4373: WHEN fnd_api.g_exc_unexpected_error THEN
4374: x_return_status := fnd_api.g_ret_sts_unexp_error;
4375:
4376: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4377: p_count => x_msg_count,
4378: p_data => x_msg_data);
4379:
4380: -- Debug info.

Line 4397: fnd_msg_pub.add;

4393: x_return_status := fnd_api.g_ret_sts_unexp_error;
4394:
4395: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4396: fnd_message.set_token('ERROR' ,SQLERRM);
4397: fnd_msg_pub.add;
4398:
4399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4400: p_count => x_msg_count,
4401: p_data => x_msg_data);

Line 4399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4395: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4396: fnd_message.set_token('ERROR' ,SQLERRM);
4397: fnd_msg_pub.add;
4398:
4399: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4400: p_count => x_msg_count,
4401: p_data => x_msg_data);
4402:
4403: -- Debug info.

Line 4436: FND_MSG_PUB.initialize;

4432: x_return_status := FND_API.G_RET_STS_SUCCESS;
4433:
4434: -- Initialize message list if p_init_msg_list is set to TRUE
4435: IF FND_API.to_Boolean(p_init_msg_list) THEN
4436: FND_MSG_PUB.initialize;
4437: END IF;
4438:
4439:
4440: -- Debug info.

Line 4491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4487:
4488: WHEN fnd_api.g_exc_error THEN
4489: x_return_status := fnd_api.g_ret_sts_error;
4490:
4491: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4492: p_count => x_msg_count,
4493: p_data => x_msg_data);
4494:
4495: -- Debug info.

Line 4510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4506: END IF;
4507: WHEN fnd_api.g_exc_unexpected_error THEN
4508: x_return_status := fnd_api.g_ret_sts_unexp_error;
4509:
4510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4511: p_count => x_msg_count,
4512: p_data => x_msg_data);
4513:
4514: -- Debug info.

Line 4531: fnd_msg_pub.add;

4527: x_return_status := fnd_api.g_ret_sts_unexp_error;
4528:
4529: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4530: fnd_message.set_token('ERROR' ,SQLERRM);
4531: fnd_msg_pub.add;
4532:
4533: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4534: p_count => x_msg_count,
4535: p_data => x_msg_data);

Line 4533: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

4529: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4530: fnd_message.set_token('ERROR' ,SQLERRM);
4531: fnd_msg_pub.add;
4532:
4533: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
4534: p_count => x_msg_count,
4535: p_data => x_msg_data);
4536:
4537: -- Debug info.