DBA Data[Home] [Help]

APPS.HZ_CONTACT_PREFERENCE_BO_PVT dependencies on FND_API

Line 47: -- be fnd_api.g_ret_sts_success (success),

43: -- p_contact_level_table_id Contact level table Id.
44: -- p_contact_level_table Contact level table.
45: -- OUT:
46: -- x_return_status Return status after the call. The status can
47: -- be fnd_api.g_ret_sts_success (success),
48: -- fnd_api.g_ret_sts_error (error),
49: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
50: -- x_msg_count Number of messages in message stack.
51: -- x_msg_data Message text if x_msg_count is 1.

Line 48: -- fnd_api.g_ret_sts_error (error),

44: -- p_contact_level_table Contact level table.
45: -- OUT:
46: -- x_return_status Return status after the call. The status can
47: -- be fnd_api.g_ret_sts_success (success),
48: -- fnd_api.g_ret_sts_error (error),
49: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
50: -- x_msg_count Number of messages in message stack.
51: -- x_msg_data Message text if x_msg_count is 1.
52: --

Line 49: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

45: -- OUT:
46: -- x_return_status Return status after the call. The status can
47: -- be fnd_api.g_ret_sts_success (success),
48: -- fnd_api.g_ret_sts_error (error),
49: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
50: -- x_msg_count Number of messages in message stack.
51: -- x_msg_data Message text if x_msg_count is 1.
52: --
53: -- NOTES

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: -- Standard start of API savepoint
73: SAVEPOINT create_contact_preferences_pvt;
74:
75: -- initialize API return status to success.
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78: -- Debug info.
79: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
80: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(+)',

Line 104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

100: );
101:
102: -- If error happen, push message into stack, raise exception out of the loop.
103: -- Reason is that we want to capture as manay as we can.
104: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
106: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_contact_preference_bo_pvt.create_contact_preferences: contact level table and id: '||p_contact_level_table||' '||p_contact_level_table_id,
107: p_prefix=>l_debug_prefix,
108: p_msg_level=>fnd_log.level_procedure);

Line 110: RAISE FND_API.G_EXC_ERROR;

106: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_contact_preference_bo_pvt.create_contact_preferences: contact level table and id: '||p_contact_level_table||' '||p_contact_level_table_id,
107: p_prefix=>l_debug_prefix,
108: p_msg_level=>fnd_log.level_procedure);
109: END IF;
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:
113: -- assign contact_preference_id
114: p_cp_pref_objs(i).contact_preference_id := l_contact_pref_id;

Line 130: WHEN fnd_api.g_exc_error THEN

126: p_prefix=>l_debug_prefix,
127: p_msg_level=>fnd_log.level_procedure);
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;

Line 136: x_return_status := fnd_api.g_ret_sts_error;

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:
138: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
139: p_count => x_msg_count,
140: p_data => x_msg_data);

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

134: FND_MSG_PUB.ADD;
135:
136: x_return_status := fnd_api.g_ret_sts_error;
137:
138: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
139: p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142: -- Debug info.

Line 155: WHEN fnd_api.g_exc_unexpected_error THEN

151: p_prefix=>l_debug_prefix,
152: p_msg_level=>fnd_log.level_procedure);
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;

Line 161: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
163: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
164: p_count => x_msg_count,
165: p_data => x_msg_data);

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

159: FND_MSG_PUB.ADD;
160:
161: x_return_status := fnd_api.g_ret_sts_unexp_error;
162:
163: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
164: p_count => x_msg_count,
165: p_data => x_msg_data);
166:
167: -- Debug info.

Line 186: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
188: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
189: fnd_message.set_token('ERROR' ,SQLERRM);
190: fnd_msg_pub.add;

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

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,
194: p_data => x_msg_data);
195:
196: -- Debug info.

Line 224: -- be fnd_api.g_ret_sts_success (success),

220: -- p_contact_level_table_id Contact level table Id.
221: -- p_contact_level_table Contact level table.
222: -- OUT:
223: -- x_return_status Return status after the call. The status can
224: -- be fnd_api.g_ret_sts_success (success),
225: -- fnd_api.g_ret_sts_error (error),
226: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
227: -- x_msg_count Number of messages in message stack.
228: -- x_msg_data Message text if x_msg_count is 1.

Line 225: -- fnd_api.g_ret_sts_error (error),

221: -- p_contact_level_table Contact level table.
222: -- OUT:
223: -- x_return_status Return status after the call. The status can
224: -- be fnd_api.g_ret_sts_success (success),
225: -- fnd_api.g_ret_sts_error (error),
226: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
227: -- x_msg_count Number of messages in message stack.
228: -- x_msg_data Message text if x_msg_count is 1.
229: --

Line 226: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

222: -- OUT:
223: -- x_return_status Return status after the call. The status can
224: -- be fnd_api.g_ret_sts_success (success),
225: -- fnd_api.g_ret_sts_error (error),
226: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
227: -- x_msg_count Number of messages in message stack.
228: -- x_msg_data Message text if x_msg_count is 1.
229: --
230: -- NOTES

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: -- Standard start of API savepoint
263: SAVEPOINT save_contact_preferences_pvt;
264:
265: -- initialize API return status to success.
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: -- Debug info.
269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
270: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(+)',

Line 307: RAISE FND_API.G_EXC_ERROR;

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:
310: IF(l_ovn IS NULL) THEN
311: HZ_CONTACT_PREFERENCE_V2PUB.create_contact_preference(

Line 336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

332: -- assign contact_preference_id
333: p_cp_pref_objs(i).contact_preference_id := l_contact_pref_rec.contact_preference_id;
334: END IF;
335:
336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
338: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_contact_preference_bo_pvt.save_contact_preferences: contact level table and id: '||p_contact_level_table||' '||p_contact_level_table_id,
339: p_prefix=>l_debug_prefix,
340: p_msg_level=>fnd_log.level_procedure);

Line 342: RAISE FND_API.G_EXC_ERROR;

338: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_contact_preference_bo_pvt.save_contact_preferences: contact level table and id: '||p_contact_level_table||' '||p_contact_level_table_id,
339: p_prefix=>l_debug_prefix,
340: p_msg_level=>fnd_log.level_procedure);
341: END IF;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: END LOOP;
345:
346: -- Debug info.

Line 359: WHEN fnd_api.g_exc_error THEN

355: p_prefix=>l_debug_prefix,
356: p_msg_level=>fnd_log.level_procedure);
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;

Line 365: x_return_status := fnd_api.g_ret_sts_error;

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:
367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
368: p_count => x_msg_count,
369: p_data => x_msg_data);

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

363: FND_MSG_PUB.ADD;
364:
365: x_return_status := fnd_api.g_ret_sts_error;
366:
367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
368: p_count => x_msg_count,
369: p_data => x_msg_data);
370:
371: -- Debug info.

Line 384: WHEN fnd_api.g_exc_unexpected_error THEN

380: p_prefix=>l_debug_prefix,
381: p_msg_level=>fnd_log.level_procedure);
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;

Line 390: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data);

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

388: FND_MSG_PUB.ADD;
389:
390: x_return_status := fnd_api.g_ret_sts_unexp_error;
391:
392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
393: p_count => x_msg_count,
394: p_data => x_msg_data);
395:
396: -- Debug info.

Line 415: x_return_status := fnd_api.g_ret_sts_unexp_error;

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:
417: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
418: fnd_message.set_token('ERROR' ,SQLERRM);
419: fnd_msg_pub.add;

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

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,
423: p_data => x_msg_data);
424:
425: -- Debug info.