DBA Data[Home] [Help]

APPS.HZ_CONTACT_PREFERENCE_BO_PVT dependencies on FND_LOG

Line 79: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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(+)',
81: p_prefix=>l_debug_prefix,
82: p_msg_level=>fnd_log.level_procedure);
83: END IF;

Line 82: p_msg_level=>fnd_log.level_procedure);

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(+)',
81: p_prefix=>l_debug_prefix,
82: p_msg_level=>fnd_log.level_procedure);
83: END IF;
84:
85: -- Create contact preferences
86: FOR i IN 1..p_cp_pref_objs.COUNT LOOP

Line 105: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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);
109: END IF;

Line 108: p_msg_level=>fnd_log.level_procedure);

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);
109: END IF;
110: RAISE FND_API.G_EXC_ERROR;
111: END IF;
112:

Line 118: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

114: p_cp_pref_objs(i).contact_preference_id := l_contact_pref_id;
115: END LOOP;
116:
117: -- Debug info.
118: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
119: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
120: p_msg_data=>x_msg_data,
121: p_msg_type=>'WARNING',
122: p_msg_level=>fnd_log.level_exception);

Line 122: p_msg_level=>fnd_log.level_exception);

118: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
119: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
120: p_msg_data=>x_msg_data,
121: p_msg_type=>'WARNING',
122: p_msg_level=>fnd_log.level_exception);
123: END IF;
124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
126: p_prefix=>l_debug_prefix,

Line 124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

120: p_msg_data=>x_msg_data,
121: p_msg_type=>'WARNING',
122: p_msg_level=>fnd_log.level_exception);
123: END IF;
124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
126: p_prefix=>l_debug_prefix,
127: p_msg_level=>fnd_log.level_procedure);
128: END IF;

Line 127: p_msg_level=>fnd_log.level_procedure);

123: END IF;
124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
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;

Line 143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

139: p_count => x_msg_count,
140: p_data => x_msg_data);
141:
142: -- Debug info.
143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
145: p_msg_data=>x_msg_data,
146: p_msg_type=>'ERROR',
147: p_msg_level=>fnd_log.level_error);

Line 147: p_msg_level=>fnd_log.level_error);

143: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
144: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
145: p_msg_data=>x_msg_data,
146: p_msg_type=>'ERROR',
147: p_msg_level=>fnd_log.level_error);
148: END IF;
149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
151: p_prefix=>l_debug_prefix,

Line 149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

145: p_msg_data=>x_msg_data,
146: p_msg_type=>'ERROR',
147: p_msg_level=>fnd_log.level_error);
148: END IF;
149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
151: p_prefix=>l_debug_prefix,
152: p_msg_level=>fnd_log.level_procedure);
153: END IF;

Line 152: p_msg_level=>fnd_log.level_procedure);

148: END IF;
149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
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;

Line 168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

164: p_count => x_msg_count,
165: p_data => x_msg_data);
166:
167: -- Debug info.
168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
170: p_msg_data=>x_msg_data,
171: p_msg_type=>'UNEXPECTED ERROR',
172: p_msg_level=>fnd_log.level_error);

Line 172: p_msg_level=>fnd_log.level_error);

168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
170: p_msg_data=>x_msg_data,
171: p_msg_type=>'UNEXPECTED ERROR',
172: p_msg_level=>fnd_log.level_error);
173: END IF;
174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
176: p_prefix=>l_debug_prefix,

Line 174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

170: p_msg_data=>x_msg_data,
171: p_msg_type=>'UNEXPECTED ERROR',
172: p_msg_level=>fnd_log.level_error);
173: END IF;
174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
176: p_prefix=>l_debug_prefix,
177: p_msg_level=>fnd_log.level_procedure);
178: END IF;

Line 177: p_msg_level=>fnd_log.level_procedure);

173: END IF;
174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
175: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
176: p_prefix=>l_debug_prefix,
177: p_msg_level=>fnd_log.level_procedure);
178: END IF;
179:
180: WHEN OTHERS THEN
181: ROLLBACK TO create_contact_preferences_pvt;

Line 197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

193: p_count => x_msg_count,
194: p_data => x_msg_data);
195:
196: -- Debug info.
197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
199: p_msg_data=>x_msg_data,
200: p_msg_type=>'SQL ERROR',
201: p_msg_level=>fnd_log.level_error);

Line 201: p_msg_level=>fnd_log.level_error);

197: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
198: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
199: p_msg_data=>x_msg_data,
200: p_msg_type=>'SQL ERROR',
201: p_msg_level=>fnd_log.level_error);
202: END IF;
203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
204: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
205: p_prefix=>l_debug_prefix,

Line 203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

199: p_msg_data=>x_msg_data,
200: p_msg_type=>'SQL ERROR',
201: p_msg_level=>fnd_log.level_error);
202: END IF;
203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
204: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
205: p_prefix=>l_debug_prefix,
206: p_msg_level=>fnd_log.level_procedure);
207: END IF;

Line 206: p_msg_level=>fnd_log.level_procedure);

202: END IF;
203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
204: hz_utility_v2pub.debug(p_message=>'create_contact_preferences(-)',
205: p_prefix=>l_debug_prefix,
206: p_msg_level=>fnd_log.level_procedure);
207: END IF;
208: END create_contact_preferences;
209:
210: -- PROCEDURE save_contact_preferences

Line 269: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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(+)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;

Line 272: p_msg_level=>fnd_log.level_procedure);

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(+)',
271: p_prefix=>l_debug_prefix,
272: p_msg_level=>fnd_log.level_procedure);
273: END IF;
274:
275: -- Create/Update contact preferences
276: FOR i IN 1..p_cp_pref_objs.COUNT LOOP

Line 297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

293: x_object_version_number => l_ovn
294: );
295:
296: IF(l_ovn = -1) THEN
297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
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;

Line 300: p_msg_level=>fnd_log.level_procedure);

296: IF(l_ovn = -1) THEN
297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
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');

Line 337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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);
341: END IF;

Line 340: p_msg_level=>fnd_log.level_procedure);

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);
341: END IF;
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344: END LOOP;

Line 347: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

343: END IF;
344: END LOOP;
345:
346: -- Debug info.
347: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
349: p_msg_data=>x_msg_data,
350: p_msg_type=>'WARNING',
351: p_msg_level=>fnd_log.level_exception);

Line 351: p_msg_level=>fnd_log.level_exception);

347: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
349: p_msg_data=>x_msg_data,
350: p_msg_type=>'WARNING',
351: p_msg_level=>fnd_log.level_exception);
352: END IF;
353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
354: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
355: p_prefix=>l_debug_prefix,

Line 353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

349: p_msg_data=>x_msg_data,
350: p_msg_type=>'WARNING',
351: p_msg_level=>fnd_log.level_exception);
352: END IF;
353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
354: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
355: p_prefix=>l_debug_prefix,
356: p_msg_level=>fnd_log.level_procedure);
357: END IF;

Line 356: p_msg_level=>fnd_log.level_procedure);

352: END IF;
353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
354: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
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;

Line 372: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

368: p_count => x_msg_count,
369: p_data => x_msg_data);
370:
371: -- Debug info.
372: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
373: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
374: p_msg_data=>x_msg_data,
375: p_msg_type=>'ERROR',
376: p_msg_level=>fnd_log.level_error);

Line 376: p_msg_level=>fnd_log.level_error);

372: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
373: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
374: p_msg_data=>x_msg_data,
375: p_msg_type=>'ERROR',
376: p_msg_level=>fnd_log.level_error);
377: END IF;
378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
380: p_prefix=>l_debug_prefix,

Line 378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

374: p_msg_data=>x_msg_data,
375: p_msg_type=>'ERROR',
376: p_msg_level=>fnd_log.level_error);
377: END IF;
378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
380: p_prefix=>l_debug_prefix,
381: p_msg_level=>fnd_log.level_procedure);
382: END IF;

Line 381: p_msg_level=>fnd_log.level_procedure);

377: END IF;
378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
379: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
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;

Line 397: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

393: p_count => x_msg_count,
394: p_data => x_msg_data);
395:
396: -- Debug info.
397: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
399: p_msg_data=>x_msg_data,
400: p_msg_type=>'UNEXPECTED ERROR',
401: p_msg_level=>fnd_log.level_error);

Line 401: p_msg_level=>fnd_log.level_error);

397: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
399: p_msg_data=>x_msg_data,
400: p_msg_type=>'UNEXPECTED ERROR',
401: p_msg_level=>fnd_log.level_error);
402: END IF;
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
405: p_prefix=>l_debug_prefix,

Line 403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

399: p_msg_data=>x_msg_data,
400: p_msg_type=>'UNEXPECTED ERROR',
401: p_msg_level=>fnd_log.level_error);
402: END IF;
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
405: p_prefix=>l_debug_prefix,
406: p_msg_level=>fnd_log.level_procedure);
407: END IF;

Line 406: p_msg_level=>fnd_log.level_procedure);

402: END IF;
403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
404: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
405: p_prefix=>l_debug_prefix,
406: p_msg_level=>fnd_log.level_procedure);
407: END IF;
408:
409: WHEN OTHERS THEN
410: ROLLBACK TO save_contact_preferences_pvt;

Line 426: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

422: p_count => x_msg_count,
423: p_data => x_msg_data);
424:
425: -- Debug info.
426: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
427: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
428: p_msg_data=>x_msg_data,
429: p_msg_type=>'SQL ERROR',
430: p_msg_level=>fnd_log.level_error);

Line 430: p_msg_level=>fnd_log.level_error);

426: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
427: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
428: p_msg_data=>x_msg_data,
429: p_msg_type=>'SQL ERROR',
430: p_msg_level=>fnd_log.level_error);
431: END IF;
432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
433: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
434: p_prefix=>l_debug_prefix,

Line 432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

428: p_msg_data=>x_msg_data,
429: p_msg_type=>'SQL ERROR',
430: p_msg_level=>fnd_log.level_error);
431: END IF;
432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
433: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
434: p_prefix=>l_debug_prefix,
435: p_msg_level=>fnd_log.level_procedure);
436: END IF;

Line 435: p_msg_level=>fnd_log.level_procedure);

431: END IF;
432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
433: hz_utility_v2pub.debug(p_message=>'save_contact_preferences(-)',
434: p_prefix=>l_debug_prefix,
435: p_msg_level=>fnd_log.level_procedure);
436: END IF;
437: END save_contact_preferences;
438:
439: -- PRIVATE PROCEDURE assign_contact_pref_rec