DBA Data[Home] [Help]

APPS.HZ_CUST_ACCT_CONTACT_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 78: px_role_responsibility_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

74: px_role_responsibility_rec.attribute12 := p_role_responsibility_obj.attribute12;
75: px_role_responsibility_rec.attribute13 := p_role_responsibility_obj.attribute13;
76: px_role_responsibility_rec.attribute14 := p_role_responsibility_obj.attribute14;
77: px_role_responsibility_rec.attribute15 := p_role_responsibility_obj.attribute15;
78: px_role_responsibility_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
79: END assign_role_responsibility_rec;
80:
81: -- PROCEDURE create_role_responsbilities
82: --

Line 125: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(+)',

121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: -- Debug info.
124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
125: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(+)',
126: p_prefix=>l_debug_prefix,
127: p_msg_level=>fnd_log.level_procedure);
128: END IF;
129:

Line 148: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.create_role_responsibilities, cust acct contact id: '||p_cac_id,

144: );
145:
146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
148: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.create_role_responsibilities, cust acct contact id: '||p_cac_id,
149: p_prefix=>l_debug_prefix,
150: p_msg_level=>fnd_log.level_procedure);
151: END IF;
152: RAISE fnd_api.g_exc_error;

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

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

Line 167: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',

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

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

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

Line 193: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',

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

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

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

Line 218: hz_utility_v2pub.debug(p_message=>'create_role_responsibilities(-)',

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

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_role_responsibilities(-)',

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_role_responsibilities(-)',
248: p_prefix=>l_debug_prefix,
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251: END create_role_responsibilities;

Line 298: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(+)',

294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: -- Debug info.
297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
298: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(+)',
299: p_prefix=>l_debug_prefix,
300: p_msg_level=>fnd_log.level_procedure);
301: END IF;
302:

Line 321: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.check_role_resp_op, cust acct contact id: '||p_cac_id,

317: );
318:
319: IF (l_ovn = -1) THEN
320: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
321: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.check_role_resp_op, cust acct contact id: '||p_cac_id,
322: p_prefix=>l_debug_prefix,
323: p_msg_level=>fnd_log.level_procedure);
324: END IF;
325: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 361: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_role_responsibilities, cust acct contact id: '||p_cac_id,

357: END IF;
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_role_responsibilities, cust acct contact id: '||p_cac_id,
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);
364: END IF;
365: RAISE fnd_api.g_exc_error;

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

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

Line 378: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',

374: p_msg_type=>'WARNING',
375: p_msg_level=>fnd_log.level_exception);
376: END IF;
377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
379: p_prefix=>l_debug_prefix,
380: p_msg_level=>fnd_log.level_procedure);
381: END IF;
382: EXCEPTION

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

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

Line 403: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',

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

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

418: p_data => x_msg_data);
419:
420: -- Debug info.
421: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
423: p_msg_data=>x_msg_data,
424: p_msg_type=>'UNEXPECTED ERROR',
425: p_msg_level=>fnd_log.level_error);
426: END IF;

Line 428: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',

424: p_msg_type=>'UNEXPECTED ERROR',
425: p_msg_level=>fnd_log.level_error);
426: END IF;
427: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
429: p_prefix=>l_debug_prefix,
430: p_msg_level=>fnd_log.level_procedure);
431: END IF;
432:

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

447: p_data => x_msg_data);
448:
449: -- Debug info.
450: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
451: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
452: p_msg_data=>x_msg_data,
453: p_msg_type=>'SQL ERROR',
454: p_msg_level=>fnd_log.level_error);
455: END IF;

Line 457: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',

453: p_msg_type=>'SQL ERROR',
454: p_msg_level=>fnd_log.level_error);
455: END IF;
456: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
457: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(-)',
458: p_prefix=>l_debug_prefix,
459: p_msg_level=>fnd_log.level_procedure);
460: END IF;
461: END save_role_responsibilities;

Line 519: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(+)',

515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(+)',
520: p_prefix=>l_debug_prefix,
521: p_msg_level=>fnd_log.level_procedure);
522: END IF;
523:

Line 529: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

525: l_parent_os := p_parent_os;
526: l_parent_osr := p_parent_osr;
527: l_parent_obj_type := p_parent_obj_type;
528:
529: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
530:
531: IF(p_create_update_flag = 'C') THEN
532: -- Create cust account contact
533: FOR i IN 1..p_cac_objs.COUNT LOOP

Line 538: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

534: HZ_CUST_ACCT_CONTACT_BO_PUB.do_create_cac_bo(
535: p_init_msg_list => fnd_api.g_false,
536: p_validate_bo_flag => fnd_api.g_false,
537: p_cust_acct_contact_obj => p_cac_objs(i),
538: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
539: p_obj_source => p_obj_source,
540: x_return_status => x_return_status,
541: x_msg_count => x_msg_count,
542: x_msg_data => x_msg_data,

Line 554: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,

550: );
551:
552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
554: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
555: p_prefix=>l_debug_prefix,
556: p_msg_level=>fnd_log.level_procedure);
557: END IF;
558: RAISE fnd_api.g_exc_error;

Line 561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

557: END IF;
558: RAISE fnd_api.g_exc_error;
559: END IF;
560:
561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
562: END LOOP;
563: ELSE
564: -- Create/update cust account contact
565: FOR i IN 1..p_cac_objs.COUNT LOOP

Line 570: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

566: HZ_CUST_ACCT_CONTACT_BO_PUB.do_save_cac_bo(
567: p_init_msg_list => fnd_api.g_false,
568: p_validate_bo_flag => fnd_api.g_false,
569: p_cust_acct_contact_obj => p_cac_objs(i),
570: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
571: p_obj_source => p_obj_source,
572: x_return_status => x_return_status,
573: x_msg_count => x_msg_count,
574: x_msg_data => x_msg_data,

Line 586: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,

582: );
583:
584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
587: p_prefix=>l_debug_prefix,
588: p_msg_level=>fnd_log.level_procedure);
589: END IF;
590: RAISE fnd_api.g_exc_error;

Line 593: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

589: END IF;
590: RAISE fnd_api.g_exc_error;
591: END IF;
592:
593: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
594: END LOOP;
595: END IF;
596:
597: -- Debug info.

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

595: END IF;
596:
597: -- Debug info.
598: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
599: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
600: p_msg_data=>x_msg_data,
601: p_msg_type=>'WARNING',
602: p_msg_level=>fnd_log.level_exception);
603: END IF;

Line 605: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',

601: p_msg_type=>'WARNING',
602: p_msg_level=>fnd_log.level_exception);
603: END IF;
604: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
605: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
606: p_prefix=>l_debug_prefix,
607: p_msg_level=>fnd_log.level_procedure);
608: END IF;
609: EXCEPTION

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

615: p_data => x_msg_data);
616:
617: -- Debug info.
618: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
620: p_msg_data=>x_msg_data,
621: p_msg_type=>'ERROR',
622: p_msg_level=>fnd_log.level_error);
623: END IF;

Line 625: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',

621: p_msg_type=>'ERROR',
622: p_msg_level=>fnd_log.level_error);
623: END IF;
624: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
625: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629: WHEN fnd_api.g_exc_unexpected_error THEN

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

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

Line 644: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',

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

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

657: p_data => x_msg_data);
658:
659: -- Debug info.
660: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
661: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
662: p_msg_data=>x_msg_data,
663: p_msg_type=>'SQL ERROR',
664: p_msg_level=>fnd_log.level_error);
665: END IF;

Line 667: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',

663: p_msg_type=>'SQL ERROR',
664: p_msg_level=>fnd_log.level_error);
665: END IF;
666: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
667: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
668: p_prefix=>l_debug_prefix,
669: p_msg_level=>fnd_log.level_procedure);
670: END IF;
671: END save_cust_acct_contacts;