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;
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
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;
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:
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);
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,
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;
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;
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);
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,
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;
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');
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);
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,
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;
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');
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);
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,
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;
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
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;
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
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;
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');
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;
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;
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);
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,
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;
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;
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);
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,
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;
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');
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);
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,
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;
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');
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);
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,
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;
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
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;
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;
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;
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:
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;
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:
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);
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,
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;
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
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);
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,
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;
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:
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);
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,
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;
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:
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);
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,
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;
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;