69: -- initialize API return status to success.
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: -- Debug info.
73: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
74: hz_utility_v2pub.debug(p_message=>'save_contact_points(+)',
75: p_prefix=>l_debug_prefix,
76: p_msg_level=>fnd_log.level_procedure);
77: END IF;
72: -- Debug info.
73: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
74: hz_utility_v2pub.debug(p_message=>'save_contact_points(+)',
75: p_prefix=>l_debug_prefix,
76: p_msg_level=>fnd_log.level_procedure);
77: END IF;
78:
79: l_owner_table_id := p_owner_table_id;
80: l_owner_table_os := p_owner_table_os;
119: px_parent_osr => l_owner_table_osr,
120: px_parent_obj_type => l_parent_obj_type
121: );
122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'Create PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
122: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'Create PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
168: px_parent_osr => l_owner_table_osr,
169: px_parent_obj_type => l_parent_obj_type
170: );
171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
173: hz_utility_v2pub.debug(p_message=>'Create TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
174: p_prefix=>l_debug_prefix,
175: p_msg_level=>fnd_log.level_procedure);
176: END IF;
171: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
172: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
173: hz_utility_v2pub.debug(p_message=>'Create TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
174: p_prefix=>l_debug_prefix,
175: p_msg_level=>fnd_log.level_procedure);
176: END IF;
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
217: px_parent_osr => l_owner_table_osr,
218: px_parent_obj_type => l_parent_obj_type
219: );
220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
222: hz_utility_v2pub.debug(p_message=>'Create EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
223: p_prefix=>l_debug_prefix,
224: p_msg_level=>fnd_log.level_procedure);
225: END IF;
220: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
222: hz_utility_v2pub.debug(p_message=>'Create EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
223: p_prefix=>l_debug_prefix,
224: p_msg_level=>fnd_log.level_procedure);
225: END IF;
226: RAISE FND_API.G_EXC_ERROR;
227: END IF;
228:
266: px_parent_osr => l_owner_table_osr,
267: px_parent_obj_type => l_parent_obj_type
268: );
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'Create WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'Create WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
315: px_parent_osr => l_owner_table_osr,
316: px_parent_obj_type => l_parent_obj_type
317: );
318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
320: hz_utility_v2pub.debug(p_message=>'Create EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
321: p_prefix=>l_debug_prefix,
322: p_msg_level=>fnd_log.level_procedure);
323: END IF;
318: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
320: hz_utility_v2pub.debug(p_message=>'Create EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
321: p_prefix=>l_debug_prefix,
322: p_msg_level=>fnd_log.level_procedure);
323: END IF;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326:
364: px_parent_osr => l_owner_table_osr,
365: px_parent_obj_type => l_parent_obj_type
366: );
367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'Create EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;
367: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
368: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
369: hz_utility_v2pub.debug(p_message=>'Create EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
370: p_prefix=>l_debug_prefix,
371: p_msg_level=>fnd_log.level_procedure);
372: END IF;
373: RAISE FND_API.G_EXC_ERROR;
374: END IF;
375:
413: px_parent_osr => l_owner_table_osr,
414: px_parent_obj_type => l_parent_obj_type
415: );
416: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'Create SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
416: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'Create SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424:
462: px_parent_osr => l_owner_table_osr,
463: px_parent_obj_type => l_parent_obj_type
464: );
465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
467: hz_utility_v2pub.debug(p_message=>'Save PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
468: p_prefix=>l_debug_prefix,
469: p_msg_level=>fnd_log.level_procedure);
470: END IF;
465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
466: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
467: hz_utility_v2pub.debug(p_message=>'Save PHONE - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
468: p_prefix=>l_debug_prefix,
469: p_msg_level=>fnd_log.level_procedure);
470: END IF;
471: RAISE FND_API.G_EXC_ERROR;
472: END IF;
473:
511: px_parent_osr => l_owner_table_osr,
512: px_parent_obj_type => l_parent_obj_type
513: );
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
516: hz_utility_v2pub.debug(p_message=>'Save TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
517: p_prefix=>l_debug_prefix,
518: p_msg_level=>fnd_log.level_procedure);
519: END IF;
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
516: hz_utility_v2pub.debug(p_message=>'Save TLX - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
517: p_prefix=>l_debug_prefix,
518: p_msg_level=>fnd_log.level_procedure);
519: END IF;
520: RAISE FND_API.G_EXC_ERROR;
521: END IF;
522:
560: px_parent_osr => l_owner_table_osr,
561: px_parent_obj_type => l_parent_obj_type
562: );
563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'Save EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;
563: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
564: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
565: hz_utility_v2pub.debug(p_message=>'Save EMAIL - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
566: p_prefix=>l_debug_prefix,
567: p_msg_level=>fnd_log.level_procedure);
568: END IF;
569: RAISE FND_API.G_EXC_ERROR;
570: END IF;
571:
609: px_parent_osr => l_owner_table_osr,
610: px_parent_obj_type => l_parent_obj_type
611: );
612: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug(p_message=>'Save WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
615: p_prefix=>l_debug_prefix,
616: p_msg_level=>fnd_log.level_procedure);
617: END IF;
612: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
613: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
614: hz_utility_v2pub.debug(p_message=>'Save WEB - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
615: p_prefix=>l_debug_prefix,
616: p_msg_level=>fnd_log.level_procedure);
617: END IF;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620:
658: px_parent_osr => l_owner_table_osr,
659: px_parent_obj_type => l_parent_obj_type
660: );
661: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'Save EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
661: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'Save EDI - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
667: RAISE FND_API.G_EXC_ERROR;
668: END IF;
669:
707: px_parent_osr => l_owner_table_osr,
708: px_parent_obj_type => l_parent_obj_type
709: );
710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'Save EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
710: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug(p_message=>'Save EFT - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
713: p_prefix=>l_debug_prefix,
714: p_msg_level=>fnd_log.level_procedure);
715: END IF;
716: RAISE FND_API.G_EXC_ERROR;
717: END IF;
718:
756: px_parent_osr => l_owner_table_osr,
757: px_parent_obj_type => l_parent_obj_type
758: );
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
761: hz_utility_v2pub.debug(p_message=>'Save SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
762: p_prefix=>l_debug_prefix,
763: p_msg_level=>fnd_log.level_procedure);
764: END IF;
759: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
760: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
761: hz_utility_v2pub.debug(p_message=>'Save SMS - Error occurred at hz_contact_point_bo_pvt.save_contact_points: '||l_cp_id||' '||l_cp_os||' '||l_cp_osr||', owner table: '||l_owner_table_id||' '||l_owner_table_os||' '||l_owner_table_osr,
762: p_prefix=>l_debug_prefix,
763: p_msg_level=>fnd_log.level_procedure);
764: END IF;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
771: END IF;
772: END IF;
773:
774: -- Debug info.
775: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
777: p_msg_data=>x_msg_data,
778: p_msg_type=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
775: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
777: p_msg_data=>x_msg_data,
778: p_msg_type=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
780: END IF;
781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
783: p_prefix=>l_debug_prefix,
777: p_msg_data=>x_msg_data,
778: p_msg_type=>'WARNING',
779: p_msg_level=>fnd_log.level_exception);
780: END IF;
781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
783: p_prefix=>l_debug_prefix,
784: p_msg_level=>fnd_log.level_procedure);
785: END IF;
780: END IF;
781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
782: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
783: p_prefix=>l_debug_prefix,
784: p_msg_level=>fnd_log.level_procedure);
785: END IF;
786: EXCEPTION
787: WHEN fnd_api.g_exc_error THEN
788: x_return_status := fnd_api.g_ret_sts_error;
790: p_count => x_msg_count,
791: p_data => x_msg_data);
792:
793: -- Debug info.
794: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
796: p_msg_data=>x_msg_data,
797: p_msg_type=>'ERROR',
798: p_msg_level=>fnd_log.level_error);
794: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
796: p_msg_data=>x_msg_data,
797: p_msg_type=>'ERROR',
798: p_msg_level=>fnd_log.level_error);
799: END IF;
800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
801: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
802: p_prefix=>l_debug_prefix,
796: p_msg_data=>x_msg_data,
797: p_msg_type=>'ERROR',
798: p_msg_level=>fnd_log.level_error);
799: END IF;
800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
801: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
802: p_prefix=>l_debug_prefix,
803: p_msg_level=>fnd_log.level_procedure);
804: END IF;
799: END IF;
800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
801: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
802: p_prefix=>l_debug_prefix,
803: p_msg_level=>fnd_log.level_procedure);
804: END IF;
805:
806: WHEN fnd_api.g_exc_unexpected_error THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
810: p_count => x_msg_count,
811: p_data => x_msg_data);
812:
813: -- Debug info.
814: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
816: p_msg_data=>x_msg_data,
817: p_msg_type=>'UNEXPECTED ERROR',
818: p_msg_level=>fnd_log.level_error);
814: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
816: p_msg_data=>x_msg_data,
817: p_msg_type=>'UNEXPECTED ERROR',
818: p_msg_level=>fnd_log.level_error);
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
822: p_prefix=>l_debug_prefix,
816: p_msg_data=>x_msg_data,
817: p_msg_type=>'UNEXPECTED ERROR',
818: p_msg_level=>fnd_log.level_error);
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
819: END IF;
820: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
821: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
822: p_prefix=>l_debug_prefix,
823: p_msg_level=>fnd_log.level_procedure);
824: END IF;
825: WHEN OTHERS THEN
826: x_return_status := fnd_api.g_ret_sts_unexp_error;
827:
833: p_count => x_msg_count,
834: p_data => x_msg_data);
835:
836: -- Debug info.
837: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
839: p_msg_data=>x_msg_data,
840: p_msg_type=>'SQL ERROR',
841: p_msg_level=>fnd_log.level_error);
837: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
838: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
839: p_msg_data=>x_msg_data,
840: p_msg_type=>'SQL ERROR',
841: p_msg_level=>fnd_log.level_error);
842: END IF;
843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
845: p_prefix=>l_debug_prefix,
839: p_msg_data=>x_msg_data,
840: p_msg_type=>'SQL ERROR',
841: p_msg_level=>fnd_log.level_error);
842: END IF;
843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
845: p_prefix=>l_debug_prefix,
846: p_msg_level=>fnd_log.level_procedure);
847: END IF;
842: END IF;
843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(p_message=>'save_contact_points(-)',
845: p_prefix=>l_debug_prefix,
846: p_msg_level=>fnd_log.level_procedure);
847: END IF;
848: END save_contact_points;
849:
850: END hz_contact_point_bo_pvt;