128: END IF;
129: EXCEPTION
130: WHEN fnd_api.g_exc_error THEN
131: ROLLBACK TO create_contact_preferences_pvt;
132: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
133: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
134: FND_MSG_PUB.ADD;
135:
136: x_return_status := fnd_api.g_ret_sts_error;
129: EXCEPTION
130: WHEN fnd_api.g_exc_error THEN
131: ROLLBACK TO create_contact_preferences_pvt;
132: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
133: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
134: FND_MSG_PUB.ADD;
135:
136: x_return_status := fnd_api.g_ret_sts_error;
137:
153: END IF;
154:
155: WHEN fnd_api.g_exc_unexpected_error THEN
156: ROLLBACK TO create_contact_preferences_pvt;
157: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
158: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
159: FND_MSG_PUB.ADD;
160:
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
154:
155: WHEN fnd_api.g_exc_unexpected_error THEN
156: ROLLBACK TO create_contact_preferences_pvt;
157: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
158: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
159: FND_MSG_PUB.ADD;
160:
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162:
178: END IF;
179:
180: WHEN OTHERS THEN
181: ROLLBACK TO create_contact_preferences_pvt;
182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
183: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
184: FND_MSG_PUB.ADD;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
179:
180: WHEN OTHERS THEN
181: ROLLBACK TO create_contact_preferences_pvt;
182: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
183: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
184: FND_MSG_PUB.ADD;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:
184: FND_MSG_PUB.ADD;
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:
188: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
189: fnd_message.set_token('ERROR' ,SQLERRM);
190: fnd_msg_pub.add;
191:
192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
185:
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187:
188: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
189: fnd_message.set_token('ERROR' ,SQLERRM);
190: fnd_msg_pub.add;
191:
192: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
193: p_count => x_msg_count,
298: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_contact_preference_bo_pvt.check_contact_pref_op: contact level table and id: '||p_contact_level_table||' '||p_contact_level_table_id,
299: p_prefix=>l_debug_prefix,
300: p_msg_level=>fnd_log.level_procedure);
301: END IF;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
303: FND_MSG_PUB.ADD;
304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
305: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
306: FND_MSG_PUB.ADD;
300: p_msg_level=>fnd_log.level_procedure);
301: END IF;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
303: FND_MSG_PUB.ADD;
304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
305: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
306: FND_MSG_PUB.ADD;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
301: END IF;
302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
303: FND_MSG_PUB.ADD;
304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
305: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
306: FND_MSG_PUB.ADD;
307: RAISE FND_API.G_EXC_ERROR;
308: END IF;
309:
357: END IF;
358: EXCEPTION
359: WHEN fnd_api.g_exc_error THEN
360: ROLLBACK TO save_contact_preferences_pvt;
361: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
362: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
363: FND_MSG_PUB.ADD;
364:
365: x_return_status := fnd_api.g_ret_sts_error;
358: EXCEPTION
359: WHEN fnd_api.g_exc_error THEN
360: ROLLBACK TO save_contact_preferences_pvt;
361: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
362: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
363: FND_MSG_PUB.ADD;
364:
365: x_return_status := fnd_api.g_ret_sts_error;
366:
382: END IF;
383:
384: WHEN fnd_api.g_exc_unexpected_error THEN
385: ROLLBACK TO save_contact_preferences_pvt;
386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
387: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
388: FND_MSG_PUB.ADD;
389:
390: x_return_status := fnd_api.g_ret_sts_unexp_error;
383:
384: WHEN fnd_api.g_exc_unexpected_error THEN
385: ROLLBACK TO save_contact_preferences_pvt;
386: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
387: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
388: FND_MSG_PUB.ADD;
389:
390: x_return_status := fnd_api.g_ret_sts_unexp_error;
391:
407: END IF;
408:
409: WHEN OTHERS THEN
410: ROLLBACK TO save_contact_preferences_pvt;
411: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
412: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
413: FND_MSG_PUB.ADD;
414:
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
408:
409: WHEN OTHERS THEN
410: ROLLBACK TO save_contact_preferences_pvt;
411: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
412: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CONTACT_PREFERENCES');
413: FND_MSG_PUB.ADD;
414:
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416:
413: FND_MSG_PUB.ADD;
414:
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416:
417: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
418: fnd_message.set_token('ERROR' ,SQLERRM);
419: fnd_msg_pub.add;
420:
421: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
414:
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416:
417: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
418: fnd_message.set_token('ERROR' ,SQLERRM);
419: fnd_msg_pub.add;
420:
421: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
422: p_count => x_msg_count,