DBA Data[Home] [Help]

APPS.HZ_ORG_CONTACT_BO_PVT dependencies on FND_LOG

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

119: -- initialize API return status to success.
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: -- Debug info.
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(+)',
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;

Line 126: p_msg_level=>fnd_log.level_procedure);

122: -- Debug info.
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(+)',
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
128:
129: -- Create contact preferences
130: IF(p_ocr_objs IS NOT NULL) THEN

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

145: x_msg_data => x_msg_data
146: );
147:
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.create_org_contact_roles, org contact id: '||p_oc_id,
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: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.create_org_contact_roles, org contact id: '||p_oc_id,
151: p_prefix=>l_debug_prefix,
152: p_msg_level=>fnd_log.level_procedure);
153: END IF;
154: RAISE fnd_api.g_exc_error;
155: END IF;
156:

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

159: END LOOP;
160: END IF;
161:
162: -- Debug info.
163: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
164: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
165: p_msg_data=>x_msg_data,
166: p_msg_type=>'WARNING',
167: p_msg_level=>fnd_log.level_exception);

Line 167: p_msg_level=>fnd_log.level_exception);

163: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
164: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
165: p_msg_data=>x_msg_data,
166: p_msg_type=>'WARNING',
167: p_msg_level=>fnd_log.level_exception);
168: END IF;
169: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
171: p_prefix=>l_debug_prefix,

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

165: p_msg_data=>x_msg_data,
166: p_msg_type=>'WARNING',
167: p_msg_level=>fnd_log.level_exception);
168: END IF;
169: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
171: p_prefix=>l_debug_prefix,
172: p_msg_level=>fnd_log.level_procedure);
173: END IF;

Line 172: p_msg_level=>fnd_log.level_procedure);

168: END IF;
169: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
171: p_prefix=>l_debug_prefix,
172: p_msg_level=>fnd_log.level_procedure);
173: END IF;
174: EXCEPTION
175: WHEN fnd_api.g_exc_error THEN
176: ROLLBACK TO create_org_contact_roles_pvt;

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

184: p_count => x_msg_count,
185: p_data => x_msg_data);
186:
187: -- Debug info.
188: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
189: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
190: p_msg_data=>x_msg_data,
191: p_msg_type=>'ERROR',
192: p_msg_level=>fnd_log.level_error);

Line 192: p_msg_level=>fnd_log.level_error);

188: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
189: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
190: p_msg_data=>x_msg_data,
191: p_msg_type=>'ERROR',
192: p_msg_level=>fnd_log.level_error);
193: END IF;
194: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
195: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
196: p_prefix=>l_debug_prefix,

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

190: p_msg_data=>x_msg_data,
191: p_msg_type=>'ERROR',
192: p_msg_level=>fnd_log.level_error);
193: END IF;
194: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
195: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
196: p_prefix=>l_debug_prefix,
197: p_msg_level=>fnd_log.level_procedure);
198: END IF;

Line 197: p_msg_level=>fnd_log.level_procedure);

193: END IF;
194: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
195: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
196: p_prefix=>l_debug_prefix,
197: p_msg_level=>fnd_log.level_procedure);
198: END IF;
199: WHEN fnd_api.g_exc_unexpected_error THEN
200: ROLLBACK TO create_org_contact_roles_pvt;
201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

208: p_count => x_msg_count,
209: p_data => x_msg_data);
210:
211: -- Debug info.
212: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
214: p_msg_data=>x_msg_data,
215: p_msg_type=>'UNEXPECTED ERROR',
216: p_msg_level=>fnd_log.level_error);

Line 216: p_msg_level=>fnd_log.level_error);

212: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
213: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
214: p_msg_data=>x_msg_data,
215: p_msg_type=>'UNEXPECTED ERROR',
216: p_msg_level=>fnd_log.level_error);
217: END IF;
218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
219: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
220: p_prefix=>l_debug_prefix,

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

214: p_msg_data=>x_msg_data,
215: p_msg_type=>'UNEXPECTED ERROR',
216: p_msg_level=>fnd_log.level_error);
217: END IF;
218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
219: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
220: p_prefix=>l_debug_prefix,
221: p_msg_level=>fnd_log.level_procedure);
222: END IF;

Line 221: p_msg_level=>fnd_log.level_procedure);

217: END IF;
218: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
219: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
220: p_prefix=>l_debug_prefix,
221: p_msg_level=>fnd_log.level_procedure);
222: END IF;
223: WHEN OTHERS THEN
224: ROLLBACK TO create_org_contact_roles_pvt;
225: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

236: p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: -- Debug info.
240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
242: p_msg_data=>x_msg_data,
243: p_msg_type=>'SQL ERROR',
244: p_msg_level=>fnd_log.level_error);

Line 244: p_msg_level=>fnd_log.level_error);

240: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
241: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
242: p_msg_data=>x_msg_data,
243: p_msg_type=>'SQL ERROR',
244: p_msg_level=>fnd_log.level_error);
245: END IF;
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
248: p_prefix=>l_debug_prefix,

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

242: p_msg_data=>x_msg_data,
243: p_msg_type=>'SQL ERROR',
244: p_msg_level=>fnd_log.level_error);
245: END IF;
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;

Line 249: p_msg_level=>fnd_log.level_procedure);

245: END IF;
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251: END create_org_contact_roles;
252:
253: -- PROCEDURE save_org_contact_roles

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

272: -- initialize API return status to success.
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: -- Debug info.
276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
277: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(+)',
278: p_prefix=>l_debug_prefix,
279: p_msg_level=>fnd_log.level_procedure);
280: END IF;

Line 279: p_msg_level=>fnd_log.level_procedure);

275: -- Debug info.
276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
277: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(+)',
278: p_prefix=>l_debug_prefix,
279: p_msg_level=>fnd_log.level_procedure);
280: END IF;
281:
282: -- Create/Update org contact roles
283: IF(p_ocr_objs IS NOT NULL) THEN

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

298: x_object_version_number => l_ovn
299: );
300:
301: IF(l_ovn = -1) THEN
302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
303: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.check_org_contact_role_op, org contact id: '||p_oc_id,
304: p_prefix=>l_debug_prefix,
305: p_msg_level=>fnd_log.level_procedure);
306: END IF;

Line 305: p_msg_level=>fnd_log.level_procedure);

301: IF(l_ovn = -1) THEN
302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
303: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.check_org_contact_role_op, org contact id: '||p_oc_id,
304: p_prefix=>l_debug_prefix,
305: p_msg_level=>fnd_log.level_procedure);
306: END IF;
307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
308: FND_MSG_PUB.ADD;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

337: -- assign org_contact_role_id
338: p_ocr_objs(i).org_contact_role_id := l_ocr_rec.org_contact_role_id;
339: END IF;
340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contact_roles, org contact id: '||p_oc_id,
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;

Line 344: p_msg_level=>fnd_log.level_procedure);

340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contact_roles, org contact id: '||p_oc_id,
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;
346: RAISE fnd_api.g_exc_error;
347: END IF;
348: END LOOP;

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

348: END LOOP;
349: END IF;
350:
351: -- Debug info.
352: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
353: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
354: p_msg_data=>x_msg_data,
355: p_msg_type=>'WARNING',
356: p_msg_level=>fnd_log.level_exception);

Line 356: p_msg_level=>fnd_log.level_exception);

352: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
353: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
354: p_msg_data=>x_msg_data,
355: p_msg_type=>'WARNING',
356: p_msg_level=>fnd_log.level_exception);
357: END IF;
358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
359: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
360: p_prefix=>l_debug_prefix,

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

354: p_msg_data=>x_msg_data,
355: p_msg_type=>'WARNING',
356: p_msg_level=>fnd_log.level_exception);
357: END IF;
358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
359: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
360: p_prefix=>l_debug_prefix,
361: p_msg_level=>fnd_log.level_procedure);
362: END IF;

Line 361: p_msg_level=>fnd_log.level_procedure);

357: END IF;
358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
359: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
360: p_prefix=>l_debug_prefix,
361: p_msg_level=>fnd_log.level_procedure);
362: END IF;
363: EXCEPTION
364: WHEN fnd_api.g_exc_error THEN
365: ROLLBACK TO save_org_contact_roles_pvt;

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

373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: -- Debug info.
377: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
379: p_msg_data=>x_msg_data,
380: p_msg_type=>'ERROR',
381: p_msg_level=>fnd_log.level_error);

Line 381: p_msg_level=>fnd_log.level_error);

377: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
379: p_msg_data=>x_msg_data,
380: p_msg_type=>'ERROR',
381: p_msg_level=>fnd_log.level_error);
382: END IF;
383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
385: p_prefix=>l_debug_prefix,

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

379: p_msg_data=>x_msg_data,
380: p_msg_type=>'ERROR',
381: p_msg_level=>fnd_log.level_error);
382: END IF;
383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
385: p_prefix=>l_debug_prefix,
386: p_msg_level=>fnd_log.level_procedure);
387: END IF;

Line 386: p_msg_level=>fnd_log.level_procedure);

382: END IF;
383: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
384: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
385: p_prefix=>l_debug_prefix,
386: p_msg_level=>fnd_log.level_procedure);
387: END IF;
388: WHEN fnd_api.g_exc_unexpected_error THEN
389: ROLLBACK TO save_org_contact_roles_pvt;
390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

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

Line 405: p_msg_level=>fnd_log.level_error);

401: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
402: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
403: p_msg_data=>x_msg_data,
404: p_msg_type=>'UNEXPECTED ERROR',
405: p_msg_level=>fnd_log.level_error);
406: END IF;
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
409: p_prefix=>l_debug_prefix,

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

403: p_msg_data=>x_msg_data,
404: p_msg_type=>'UNEXPECTED ERROR',
405: p_msg_level=>fnd_log.level_error);
406: END IF;
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
409: p_prefix=>l_debug_prefix,
410: p_msg_level=>fnd_log.level_procedure);
411: END IF;

Line 410: p_msg_level=>fnd_log.level_procedure);

406: END IF;
407: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
408: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
409: p_prefix=>l_debug_prefix,
410: p_msg_level=>fnd_log.level_procedure);
411: END IF;
412: WHEN OTHERS THEN
413: ROLLBACK TO save_org_contact_roles_pvt;
414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

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

Line 433: p_msg_level=>fnd_log.level_error);

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

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

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

Line 438: p_msg_level=>fnd_log.level_procedure);

434: END IF;
435: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
436: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
437: p_prefix=>l_debug_prefix,
438: p_msg_level=>fnd_log.level_procedure);
439: END IF;
440: END save_org_contact_roles;
441:
442: -- PROCEDURE save_org_contacts

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

490: -- initialize API return status to success.
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: -- Debug info.
494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(p_message=>'save_org_contacts(+)',
496: p_prefix=>l_debug_prefix,
497: p_msg_level=>fnd_log.level_procedure);
498: END IF;

Line 497: p_msg_level=>fnd_log.level_procedure);

493: -- Debug info.
494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(p_message=>'save_org_contacts(+)',
496: p_prefix=>l_debug_prefix,
497: p_msg_level=>fnd_log.level_procedure);
498: END IF;
499:
500: l_parent_org_id := p_parent_org_id;
501: l_parent_org_os := p_parent_org_os;

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

525: px_parent_org_osr => l_parent_org_osr
526: );
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);
533: END IF;

Line 532: p_msg_level=>fnd_log.level_procedure);

528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);
533: END IF;
534: RAISE fnd_api.g_exc_error;
535: END IF;
536:

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

558: px_parent_org_osr => l_parent_org_osr
559: );
560:
561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
562: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
563: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
564: p_prefix=>l_debug_prefix,
565: p_msg_level=>fnd_log.level_procedure);
566: END IF;

Line 565: p_msg_level=>fnd_log.level_procedure);

561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
562: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
563: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
564: p_prefix=>l_debug_prefix,
565: p_msg_level=>fnd_log.level_procedure);
566: END IF;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:

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

571: END LOOP;
572: END IF;
573:
574: -- Debug info.
575: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
576: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
577: p_msg_data=>x_msg_data,
578: p_msg_type=>'WARNING',
579: p_msg_level=>fnd_log.level_exception);

Line 579: p_msg_level=>fnd_log.level_exception);

575: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
576: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
577: p_msg_data=>x_msg_data,
578: p_msg_type=>'WARNING',
579: p_msg_level=>fnd_log.level_exception);
580: END IF;
581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
583: p_prefix=>l_debug_prefix,

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

577: p_msg_data=>x_msg_data,
578: p_msg_type=>'WARNING',
579: p_msg_level=>fnd_log.level_exception);
580: END IF;
581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
583: p_prefix=>l_debug_prefix,
584: p_msg_level=>fnd_log.level_procedure);
585: END IF;

Line 584: p_msg_level=>fnd_log.level_procedure);

580: END IF;
581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
583: p_prefix=>l_debug_prefix,
584: p_msg_level=>fnd_log.level_procedure);
585: END IF;
586:
587: EXCEPTION
588: WHEN fnd_api.g_exc_error THEN

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

592: p_count => x_msg_count,
593: p_data => x_msg_data);
594:
595: -- Debug info.
596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
598: p_msg_data=>x_msg_data,
599: p_msg_type=>'ERROR',
600: p_msg_level=>fnd_log.level_error);

Line 600: p_msg_level=>fnd_log.level_error);

596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
598: p_msg_data=>x_msg_data,
599: p_msg_type=>'ERROR',
600: p_msg_level=>fnd_log.level_error);
601: END IF;
602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
603: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
604: p_prefix=>l_debug_prefix,

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

598: p_msg_data=>x_msg_data,
599: p_msg_type=>'ERROR',
600: p_msg_level=>fnd_log.level_error);
601: END IF;
602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
603: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
604: p_prefix=>l_debug_prefix,
605: p_msg_level=>fnd_log.level_procedure);
606: END IF;

Line 605: p_msg_level=>fnd_log.level_procedure);

601: END IF;
602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
603: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
604: p_prefix=>l_debug_prefix,
605: p_msg_level=>fnd_log.level_procedure);
606: END IF;
607: WHEN fnd_api.g_exc_unexpected_error THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:

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

611: p_count => x_msg_count,
612: p_data => x_msg_data);
613:
614: -- Debug info.
615: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
617: p_msg_data=>x_msg_data,
618: p_msg_type=>'UNEXPECTED ERROR',
619: p_msg_level=>fnd_log.level_error);

Line 619: p_msg_level=>fnd_log.level_error);

615: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
617: p_msg_data=>x_msg_data,
618: p_msg_type=>'UNEXPECTED ERROR',
619: p_msg_level=>fnd_log.level_error);
620: END IF;
621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
622: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
623: p_prefix=>l_debug_prefix,

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

617: p_msg_data=>x_msg_data,
618: p_msg_type=>'UNEXPECTED ERROR',
619: p_msg_level=>fnd_log.level_error);
620: END IF;
621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
622: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
623: p_prefix=>l_debug_prefix,
624: p_msg_level=>fnd_log.level_procedure);
625: END IF;

Line 624: p_msg_level=>fnd_log.level_procedure);

620: END IF;
621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
622: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
623: p_prefix=>l_debug_prefix,
624: p_msg_level=>fnd_log.level_procedure);
625: END IF;
626: WHEN OTHERS THEN
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:

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

634: p_count => x_msg_count,
635: p_data => x_msg_data);
636:
637: -- Debug info.
638: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
640: p_msg_data=>x_msg_data,
641: p_msg_type=>'SQL ERROR',
642: p_msg_level=>fnd_log.level_error);

Line 642: p_msg_level=>fnd_log.level_error);

638: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
639: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
640: p_msg_data=>x_msg_data,
641: p_msg_type=>'SQL ERROR',
642: p_msg_level=>fnd_log.level_error);
643: END IF;
644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
646: p_prefix=>l_debug_prefix,

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

640: p_msg_data=>x_msg_data,
641: p_msg_type=>'SQL ERROR',
642: p_msg_level=>fnd_log.level_error);
643: END IF;
644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
646: p_prefix=>l_debug_prefix,
647: p_msg_level=>fnd_log.level_procedure);
648: END IF;

Line 647: p_msg_level=>fnd_log.level_procedure);

643: END IF;
644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
646: p_prefix=>l_debug_prefix,
647: p_msg_level=>fnd_log.level_procedure);
648: END IF;
649: END save_org_contacts;
650:
651: END hz_org_contact_bo_pvt;