DBA Data[Home] [Help]

APPS.HZ_ORG_CONTACT_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 77: px_org_contact_role_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

73: px_org_contact_role_rec.primary_contact_per_role_type := p_ocr_obj.primary_contact_per_role_type;
74: IF(p_ocr_obj.status in ('A','I')) THEN
75: px_org_contact_role_rec.status := p_ocr_obj.status;
76: END IF;
77: px_org_contact_role_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
78: END assign_org_contact_role_rec;
79:
80: -- PROCEDURE create_org_contact_roles
81: --

Line 124: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(+)',

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;
128:

Line 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,

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;
154: RAISE fnd_api.g_exc_error;

Line 164: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 170: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',

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;
174: EXCEPTION

Line 189: hz_utility_v2pub.debug_return_messages(p_msg_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);
193: END IF;

Line 195: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',

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;
199: WHEN fnd_api.g_exc_unexpected_error THEN

Line 213: hz_utility_v2pub.debug_return_messages(p_msg_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);
217: END IF;

Line 219: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',

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;
223: WHEN OTHERS THEN

Line 241: hz_utility_v2pub.debug_return_messages(p_msg_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);
245: END IF;

Line 247: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',

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;
251: END create_org_contact_roles;

Line 277: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(+)',

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;
281:

Line 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,

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;
307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 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,

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;
346: RAISE fnd_api.g_exc_error;

Line 353: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 359: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',

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;
363: EXCEPTION

Line 378: hz_utility_v2pub.debug_return_messages(p_msg_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);
382: END IF;

Line 384: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',

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;
388: WHEN fnd_api.g_exc_unexpected_error THEN

Line 402: hz_utility_v2pub.debug_return_messages(p_msg_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);
406: END IF;

Line 408: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',

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;
412: WHEN OTHERS THEN

Line 430: hz_utility_v2pub.debug_return_messages(p_msg_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);
434: END IF;

Line 436: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',

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;
440: END save_org_contact_roles;

Line 495: hz_utility_v2pub.debug(p_message=>'save_org_contacts(+)',

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;
499:

Line 504: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

500: l_parent_org_id := p_parent_org_id;
501: l_parent_org_os := p_parent_org_os;
502: l_parent_org_osr:= p_parent_org_osr;
503:
504: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
505:
506: IF(p_create_update_flag = 'C') THEN
507: -----------------------------
508: -- Create logical org contact

Line 515: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

511: HZ_ORG_CONTACT_BO_PUB.do_create_org_contact_bo(
512: p_init_msg_list => fnd_api.g_false,
513: p_validate_bo_flag => fnd_api.g_false,
514: p_org_contact_obj => p_oc_objs(i),
515: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
516: p_obj_source => p_obj_source,
517: x_return_status => x_return_status,
518: x_msg_count => x_msg_count,
519: x_msg_data => x_msg_data,

Line 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,

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;
534: RAISE fnd_api.g_exc_error;

Line 537: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

533: END IF;
534: RAISE fnd_api.g_exc_error;
535: END IF;
536:
537: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
538: END LOOP;
539: ELSE
540: ------------------------------------
541: -- Create/Update logical org contact

Line 548: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

544: HZ_ORG_CONTACT_BO_PUB.do_save_org_contact_bo(
545: p_init_msg_list => fnd_api.g_false,
546: p_validate_bo_flag => fnd_api.g_false,
547: p_org_contact_obj => p_oc_objs(i),
548: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
549: p_obj_source => p_obj_source,
550: x_return_status => x_return_status,
551: x_msg_count => x_msg_count,
552: x_msg_data => x_msg_data,

Line 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,

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;
567: RAISE fnd_api.g_exc_error;

Line 570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

566: END IF;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:
570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
571: END LOOP;
572: END IF;
573:
574: -- Debug info.

Line 576: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 582: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',

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;
586:

Line 597: hz_utility_v2pub.debug_return_messages(p_msg_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);
601: END IF;

Line 603: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',

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;
607: WHEN fnd_api.g_exc_unexpected_error THEN

Line 616: hz_utility_v2pub.debug_return_messages(p_msg_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);
620: END IF;

Line 622: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',

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;
626: WHEN OTHERS THEN

Line 639: hz_utility_v2pub.debug_return_messages(p_msg_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);
643: END IF;

Line 645: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',

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;
649: END save_org_contacts;