DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 68: px_party_site_use_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

64: END IF;
65: IF(p_party_site_use_obj.status in ('A','I')) THEN
66: px_party_site_use_rec.status := p_party_site_use_obj.status;
67: END IF;
68: px_party_site_use_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
69: END assign_party_site_use_rec;
70:
71: -- PROCEDURE create_party_site_uses
72: --

Line 116: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(+)',

112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
114: -- Debug info.
115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
116: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(+)',
117: p_prefix=>l_debug_prefix,
118: p_msg_level=>fnd_log.level_procedure);
119: END IF;
120:

Line 139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.create_party_site_uses: party_site_id: '||p_ps_id,

135: );
136:
137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.create_party_site_uses: party_site_id: '||p_ps_id,
140: p_prefix=>l_debug_prefix,
141: p_msg_level=>fnd_log.level_procedure);
142: END IF;
143: RAISE fnd_api.g_exc_error;

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

148: END LOOP;
149:
150: -- Debug info.
151: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
153: p_msg_data=>x_msg_data,
154: p_msg_type=>'WARNING',
155: p_msg_level=>fnd_log.level_exception);
156: END IF;

Line 158: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',

154: p_msg_type=>'WARNING',
155: p_msg_level=>fnd_log.level_exception);
156: END IF;
157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
158: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;
162: EXCEPTION

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

173: p_data => x_msg_data);
174:
175: -- Debug info.
176: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
177: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
178: p_msg_data=>x_msg_data,
179: p_msg_type=>'ERROR',
180: p_msg_level=>fnd_log.level_error);
181: END IF;

Line 183: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',

179: p_msg_type=>'ERROR',
180: p_msg_level=>fnd_log.level_error);
181: END IF;
182: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
183: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
184: p_prefix=>l_debug_prefix,
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;
187: WHEN fnd_api.g_exc_unexpected_error THEN

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

197: p_data => x_msg_data);
198:
199: -- Debug info.
200: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
201: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
202: p_msg_data=>x_msg_data,
203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);
205: END IF;

Line 207: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',

203: p_msg_type=>'UNEXPECTED ERROR',
204: p_msg_level=>fnd_log.level_error);
205: END IF;
206: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
207: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
208: p_prefix=>l_debug_prefix,
209: p_msg_level=>fnd_log.level_procedure);
210: END IF;
211:

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

226: p_data => x_msg_data);
227:
228: -- Debug info.
229: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
231: p_msg_data=>x_msg_data,
232: p_msg_type=>'SQL ERROR',
233: p_msg_level=>fnd_log.level_error);
234: END IF;

Line 236: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',

232: p_msg_type=>'SQL ERROR',
233: p_msg_level=>fnd_log.level_error);
234: END IF;
235: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
236: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
237: p_prefix=>l_debug_prefix,
238: p_msg_level=>fnd_log.level_procedure);
239: END IF;
240: END create_party_site_uses;

Line 288: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(+)',

284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(+)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;
292:

Line 311: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.check_party_site_use_op: party_site_id: '||p_ps_id,

307: );
308:
309: IF(l_ovn = -1) THEN
310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
311: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.check_party_site_use_op: party_site_id: '||p_ps_id,
312: p_prefix=>l_debug_prefix,
313: p_msg_level=>fnd_log.level_procedure);
314: END IF;
315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 351: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_site_uses: party_site_id: '||p_ps_id,

347: END IF;
348:
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
351: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_site_uses: party_site_id: '||p_ps_id,
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;
355: RAISE fnd_api.g_exc_error;

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

357: END LOOP;
358:
359: -- Debug info.
360: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
362: p_msg_data=>x_msg_data,
363: p_msg_type=>'WARNING',
364: p_msg_level=>fnd_log.level_exception);
365: END IF;

Line 367: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',

363: p_msg_type=>'WARNING',
364: p_msg_level=>fnd_log.level_exception);
365: END IF;
366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
367: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
368: p_prefix=>l_debug_prefix,
369: p_msg_level=>fnd_log.level_procedure);
370: END IF;
371: EXCEPTION

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

382: p_data => x_msg_data);
383:
384: -- Debug info.
385: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
386: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
387: p_msg_data=>x_msg_data,
388: p_msg_type=>'ERROR',
389: p_msg_level=>fnd_log.level_error);
390: END IF;

Line 392: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',

388: p_msg_type=>'ERROR',
389: p_msg_level=>fnd_log.level_error);
390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;
396: WHEN fnd_api.g_exc_unexpected_error THEN

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

406: p_data => x_msg_data);
407:
408: -- Debug info.
409: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
410: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
411: p_msg_data=>x_msg_data,
412: p_msg_type=>'UNEXPECTED ERROR',
413: p_msg_level=>fnd_log.level_error);
414: END IF;

Line 416: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',

412: p_msg_type=>'UNEXPECTED ERROR',
413: p_msg_level=>fnd_log.level_error);
414: END IF;
415: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
416: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
417: p_prefix=>l_debug_prefix,
418: p_msg_level=>fnd_log.level_procedure);
419: END IF;
420:

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

435: p_data => x_msg_data);
436:
437: -- Debug info.
438: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
439: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
440: p_msg_data=>x_msg_data,
441: p_msg_type=>'SQL ERROR',
442: p_msg_level=>fnd_log.level_error);
443: END IF;

Line 445: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',

441: p_msg_type=>'SQL ERROR',
442: p_msg_level=>fnd_log.level_error);
443: END IF;
444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
445: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
446: p_prefix=>l_debug_prefix,
447: p_msg_level=>fnd_log.level_procedure);
448: END IF;
449: END save_party_site_uses;

Line 508: hz_utility_v2pub.debug(p_message=>'save_party_sites(+)',

504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'save_party_sites(+)',
509: p_prefix=>l_debug_prefix,
510: p_msg_level=>fnd_log.level_procedure);
511: END IF;
512:

Line 518: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

514: l_parent_os := p_parent_os;
515: l_parent_osr:= p_parent_osr;
516: l_parent_obj_type := p_parent_obj_type;
517:
518: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
519:
520: IF(p_create_update_flag = 'C') THEN
521: ----------------------------
522: -- Create logical party site

Line 529: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

525: HZ_PARTY_SITE_BO_PUB.do_create_party_site_bo(
526: p_init_msg_list => fnd_api.g_false,
527: p_validate_bo_flag => FND_API.G_FALSE,
528: p_party_site_obj => p_ps_objs(i),
529: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
530: p_obj_source => p_obj_source,
531: x_return_status => x_return_status,
532: x_msg_count => x_msg_count,
533: x_msg_data => x_msg_data,

Line 545: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,

541: );
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;
549: RAISE fnd_api.g_exc_error;

Line 552: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

548: END IF;
549: RAISE fnd_api.g_exc_error;
550: END IF;
551:
552: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
553: END LOOP;
554: ELSE
555: -----------------------------------
556: -- Create/Update logical party site

Line 563: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

559: HZ_PARTY_SITE_BO_PUB.do_save_party_site_bo(
560: p_init_msg_list => fnd_api.g_false,
561: p_validate_bo_flag => FND_API.G_FALSE,
562: p_party_site_obj => p_ps_objs(i),
563: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
564: p_obj_source => p_obj_source,
565: x_return_status => x_return_status,
566: x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data,

Line 579: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,

575: );
576:
577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
579: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
580: p_prefix=>l_debug_prefix,
581: p_msg_level=>fnd_log.level_procedure);
582: END IF;
583: RAISE fnd_api.g_exc_error;

Line 586: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

582: END IF;
583: RAISE fnd_api.g_exc_error;
584: END IF;
585:
586: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
587: END LOOP;
588: END IF;
589:
590: -- Debug info.

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

588: END IF;
589:
590: -- Debug info.
591: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'WARNING',
595: p_msg_level=>fnd_log.level_exception);
596: END IF;

Line 598: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',

594: p_msg_type=>'WARNING',
595: p_msg_level=>fnd_log.level_exception);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
602:

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

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

Line 619: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',

615: p_msg_type=>'ERROR',
616: p_msg_level=>fnd_log.level_error);
617: END IF;
618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;
623: WHEN fnd_api.g_exc_unexpected_error THEN

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

628: p_data => x_msg_data);
629:
630: -- Debug info.
631: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
632: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
633: p_msg_data=>x_msg_data,
634: p_msg_type=>'UNEXPECTED ERROR',
635: p_msg_level=>fnd_log.level_error);
636: END IF;

Line 638: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',

634: p_msg_type=>'UNEXPECTED ERROR',
635: p_msg_level=>fnd_log.level_error);
636: END IF;
637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
638: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
639: p_prefix=>l_debug_prefix,
640: p_msg_level=>fnd_log.level_procedure);
641: END IF;
642:

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

652: p_data => x_msg_data);
653:
654: -- Debug info.
655: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
657: p_msg_data=>x_msg_data,
658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;

Line 662: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',

658: p_msg_type=>'SQL ERROR',
659: p_msg_level=>fnd_log.level_error);
660: END IF;
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666: END save_party_sites;