eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCT_SITE_BO_PVT dependencies on FND_LOG

Line 243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

239: -- initialize API return status to success.
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: -- Debug info.
243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
244: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(+)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;

Line 246: p_msg_level=>fnd_log.level_procedure);

242: -- Debug info.
243: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
244: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(+)',
245: p_prefix=>l_debug_prefix,
246: p_msg_level=>fnd_log.level_procedure);
247: END IF;
248:
249: -- Create cust site use with site use profile
250: -- HZ_CUST_ACCONT_SITE_V2PUB will create cust site use and then

Line 296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

292: x_msg_data => x_msg_data
293: );
294:
295: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;

Line 299: p_msg_level=>fnd_log.level_procedure);

295: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:

Line 385: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

381: END IF;
382: END LOOP;
383:
384: -- Debug info.
385: IF fnd_log.level_exception>=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=>'WARNING',
389: p_msg_level=>fnd_log.level_exception);

Line 389: p_msg_level=>fnd_log.level_exception);

385: IF fnd_log.level_exception>=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=>'WARNING',
389: p_msg_level=>fnd_log.level_exception);
390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
393: p_prefix=>l_debug_prefix,

Line 391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

387: p_msg_data=>x_msg_data,
388: p_msg_type=>'WARNING',
389: p_msg_level=>fnd_log.level_exception);
390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;

Line 394: p_msg_level=>fnd_log.level_procedure);

390: END IF;
391: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
392: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;
396:
397: EXCEPTION
398: WHEN fnd_api.g_exc_error THEN

Line 411: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 415: p_msg_level=>fnd_log.level_error);

411: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
412: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
413: p_msg_data=>x_msg_data,
414: p_msg_type=>'ERROR',
415: p_msg_level=>fnd_log.level_error);
416: END IF;
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
419: p_prefix=>l_debug_prefix,

Line 417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 420: p_msg_level=>fnd_log.level_procedure);

416: END IF;
417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
418: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
419: p_prefix=>l_debug_prefix,
420: p_msg_level=>fnd_log.level_procedure);
421: END IF;
422:
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: ROLLBACK TO create_casu_pvt;

Line 436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

432: p_count => x_msg_count,
433: p_data => x_msg_data);
434:
435: -- Debug info.
436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);

Line 440: p_msg_level=>fnd_log.level_error);

436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);
441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
444: p_prefix=>l_debug_prefix,

Line 442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

438: p_msg_data=>x_msg_data,
439: p_msg_type=>'UNEXPECTED ERROR',
440: p_msg_level=>fnd_log.level_error);
441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
444: p_prefix=>l_debug_prefix,
445: p_msg_level=>fnd_log.level_procedure);
446: END IF;

Line 445: p_msg_level=>fnd_log.level_procedure);

441: END IF;
442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
443: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
444: p_prefix=>l_debug_prefix,
445: p_msg_level=>fnd_log.level_procedure);
446: END IF;
447:
448: WHEN OTHERS THEN
449: ROLLBACK TO create_casu_pvt;

Line 465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.
465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);

Line 469: p_msg_level=>fnd_log.level_error);

465: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
466: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
473: p_prefix=>l_debug_prefix,

Line 471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

467: p_msg_data=>x_msg_data,
468: p_msg_type=>'SQL ERROR',
469: p_msg_level=>fnd_log.level_error);
470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;

Line 474: p_msg_level=>fnd_log.level_procedure);

470: END IF;
471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
472: hz_utility_v2pub.debug(p_message=>'create_cust_site_uses(-)',
473: p_prefix=>l_debug_prefix,
474: p_msg_level=>fnd_log.level_procedure);
475: END IF;
476: END create_cust_site_uses;
477:
478: -- PROCEDURE save_cust_site_uses

Line 565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

561: -- initialize API return status to success.
562: x_return_status := FND_API.G_RET_STS_SUCCESS;
563:
564: -- Debug info.
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(+)',
567: p_prefix=>l_debug_prefix,
568: p_msg_level=>fnd_log.level_procedure);
569: END IF;

Line 568: p_msg_level=>fnd_log.level_procedure);

564: -- Debug info.
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(+)',
567: p_prefix=>l_debug_prefix,
568: p_msg_level=>fnd_log.level_procedure);
569: END IF;
570:
571: -- Create/Update cust site uses
572: FOR i IN 1..p_casu_objs.COUNT LOOP

Line 641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

637: x_msg_data => x_msg_data
638: );
639:
640: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;

Line 644: p_msg_level=>fnd_log.level_procedure);

640: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
643: p_prefix=>l_debug_prefix,
644: p_msg_level=>fnd_log.level_procedure);
645: END IF;
646: RAISE fnd_api.g_exc_error;
647: END IF;
648:

Line 728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

724: x_msg_data => x_msg_data
725: );
726:
727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
730: p_prefix=>l_debug_prefix,
731: p_msg_level=>fnd_log.level_procedure);
732: END IF;

Line 731: p_msg_level=>fnd_log.level_procedure);

727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
730: p_prefix=>l_debug_prefix,
731: p_msg_level=>fnd_log.level_procedure);
732: END IF;
733: RAISE fnd_api.g_exc_error;
734: END IF;
735:

Line 813: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

809:
810: END LOOP;
811:
812: -- Debug info.
813: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
815: p_msg_data=>x_msg_data,
816: p_msg_type=>'WARNING',
817: p_msg_level=>fnd_log.level_exception);

Line 817: p_msg_level=>fnd_log.level_exception);

813: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
815: p_msg_data=>x_msg_data,
816: p_msg_type=>'WARNING',
817: p_msg_level=>fnd_log.level_exception);
818: END IF;
819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
820: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
821: p_prefix=>l_debug_prefix,

Line 819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

815: p_msg_data=>x_msg_data,
816: p_msg_type=>'WARNING',
817: p_msg_level=>fnd_log.level_exception);
818: END IF;
819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
820: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
821: p_prefix=>l_debug_prefix,
822: p_msg_level=>fnd_log.level_procedure);
823: END IF;

Line 822: p_msg_level=>fnd_log.level_procedure);

818: END IF;
819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
820: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
821: p_prefix=>l_debug_prefix,
822: p_msg_level=>fnd_log.level_procedure);
823: END IF;
824: EXCEPTION
825: WHEN fnd_api.g_exc_error THEN
826: ROLLBACK TO save_casu_pvt;

Line 838: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

834: p_count => x_msg_count,
835: p_data => x_msg_data);
836:
837: -- Debug info.
838: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
839: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
840: p_msg_data=>x_msg_data,
841: p_msg_type=>'ERROR',
842: p_msg_level=>fnd_log.level_error);

Line 842: p_msg_level=>fnd_log.level_error);

838: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
839: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
840: p_msg_data=>x_msg_data,
841: p_msg_type=>'ERROR',
842: p_msg_level=>fnd_log.level_error);
843: END IF;
844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
846: p_prefix=>l_debug_prefix,

Line 844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

840: p_msg_data=>x_msg_data,
841: p_msg_type=>'ERROR',
842: p_msg_level=>fnd_log.level_error);
843: END IF;
844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
846: p_prefix=>l_debug_prefix,
847: p_msg_level=>fnd_log.level_procedure);
848: END IF;

Line 847: p_msg_level=>fnd_log.level_procedure);

843: END IF;
844: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
845: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
846: p_prefix=>l_debug_prefix,
847: p_msg_level=>fnd_log.level_procedure);
848: END IF;
849:
850: WHEN fnd_api.g_exc_unexpected_error THEN
851: ROLLBACK TO save_casu_pvt;

Line 863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: -- Debug info.
863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
865: p_msg_data=>x_msg_data,
866: p_msg_type=>'UNEXPECTED ERROR',
867: p_msg_level=>fnd_log.level_error);

Line 867: p_msg_level=>fnd_log.level_error);

863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
865: p_msg_data=>x_msg_data,
866: p_msg_type=>'UNEXPECTED ERROR',
867: p_msg_level=>fnd_log.level_error);
868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
871: p_prefix=>l_debug_prefix,

Line 869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

865: p_msg_data=>x_msg_data,
866: p_msg_type=>'UNEXPECTED ERROR',
867: p_msg_level=>fnd_log.level_error);
868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;

Line 872: p_msg_level=>fnd_log.level_procedure);

868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874:
875: WHEN OTHERS THEN
876: ROLLBACK TO save_casu_pvt;

Line 892: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

888: p_count => x_msg_count,
889: p_data => x_msg_data);
890:
891: -- Debug info.
892: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
894: p_msg_data=>x_msg_data,
895: p_msg_type=>'SQL ERROR',
896: p_msg_level=>fnd_log.level_error);

Line 896: p_msg_level=>fnd_log.level_error);

892: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
893: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
894: p_msg_data=>x_msg_data,
895: p_msg_type=>'SQL ERROR',
896: p_msg_level=>fnd_log.level_error);
897: END IF;
898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
899: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
900: p_prefix=>l_debug_prefix,

Line 898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

894: p_msg_data=>x_msg_data,
895: p_msg_type=>'SQL ERROR',
896: p_msg_level=>fnd_log.level_error);
897: END IF;
898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
899: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
900: p_prefix=>l_debug_prefix,
901: p_msg_level=>fnd_log.level_procedure);
902: END IF;

Line 901: p_msg_level=>fnd_log.level_procedure);

897: END IF;
898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
899: hz_utility_v2pub.debug(p_message=>'save_cust_site_uses(-)',
900: p_prefix=>l_debug_prefix,
901: p_msg_level=>fnd_log.level_procedure);
902: END IF;
903: END save_cust_site_uses;
904:
905: -- PROCEDURE save_cust_acct_sites

Line 933: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

929: -- initialize API return status to success
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: -- Debug info.
933: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
934: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(+)',
935: p_prefix=>l_debug_prefix,
936: p_msg_level=>fnd_log.level_procedure);
937: END IF;

Line 936: p_msg_level=>fnd_log.level_procedure);

932: -- Debug info.
933: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
934: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(+)',
935: p_prefix=>l_debug_prefix,
936: p_msg_level=>fnd_log.level_procedure);
937: END IF;
938:
939: l_parent_acct_id := p_parent_acct_id;
940: l_parent_acct_os := p_parent_acct_os;

Line 966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

962: px_parent_acct_osr => l_parent_acct_osr
963: );
964:
965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
968: p_prefix=>l_debug_prefix,
969: p_msg_level=>fnd_log.level_procedure);
970: END IF;

Line 969: p_msg_level=>fnd_log.level_procedure);

965: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
968: p_prefix=>l_debug_prefix,
969: p_msg_level=>fnd_log.level_procedure);
970: END IF;
971: RAISE fnd_api.g_exc_error;
972: END IF;
973:

Line 997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

993: px_parent_acct_osr => l_parent_acct_osr
994: );
995:
996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;

Line 1000: p_msg_level=>fnd_log.level_procedure);

996: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;
1002: RAISE fnd_api.g_exc_error;
1003: END IF;
1004:

Line 1010: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1006: END LOOP;
1007: END IF;
1008:
1009: -- Debug info.
1010: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1012: p_msg_data=>x_msg_data,
1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);

Line 1014: p_msg_level=>fnd_log.level_exception);

1010: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1011: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1012: p_msg_data=>x_msg_data,
1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);
1015: END IF;
1016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1017: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1018: p_prefix=>l_debug_prefix,

Line 1016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1012: p_msg_data=>x_msg_data,
1013: p_msg_type=>'WARNING',
1014: p_msg_level=>fnd_log.level_exception);
1015: END IF;
1016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1017: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1018: p_prefix=>l_debug_prefix,
1019: p_msg_level=>fnd_log.level_procedure);
1020: END IF;

Line 1019: p_msg_level=>fnd_log.level_procedure);

1015: END IF;
1016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1017: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1018: p_prefix=>l_debug_prefix,
1019: p_msg_level=>fnd_log.level_procedure);
1020: END IF;
1021: EXCEPTION
1022: WHEN fnd_api.g_exc_error THEN
1023: x_return_status := fnd_api.g_ret_sts_error;

Line 1030: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1026: p_count => x_msg_count,
1027: p_data => x_msg_data);
1028:
1029: -- Debug info.
1030: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1032: p_msg_data=>x_msg_data,
1033: p_msg_type=>'ERROR',
1034: p_msg_level=>fnd_log.level_error);

Line 1034: p_msg_level=>fnd_log.level_error);

1030: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1032: p_msg_data=>x_msg_data,
1033: p_msg_type=>'ERROR',
1034: p_msg_level=>fnd_log.level_error);
1035: END IF;
1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1037: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1038: p_prefix=>l_debug_prefix,

Line 1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1032: p_msg_data=>x_msg_data,
1033: p_msg_type=>'ERROR',
1034: p_msg_level=>fnd_log.level_error);
1035: END IF;
1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1037: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1038: p_prefix=>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_procedure);
1040: END IF;

Line 1039: p_msg_level=>fnd_log.level_procedure);

1035: END IF;
1036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1037: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1038: p_prefix=>l_debug_prefix,
1039: p_msg_level=>fnd_log.level_procedure);
1040: END IF;
1041: WHEN fnd_api.g_exc_unexpected_error THEN
1042: x_return_status := fnd_api.g_ret_sts_unexp_error;
1043:

Line 1049: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1045: p_count => x_msg_count,
1046: p_data => x_msg_data);
1047:
1048: -- Debug info.
1049: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1051: p_msg_data=>x_msg_data,
1052: p_msg_type=>'UNEXPECTED ERROR',
1053: p_msg_level=>fnd_log.level_error);

Line 1053: p_msg_level=>fnd_log.level_error);

1049: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1051: p_msg_data=>x_msg_data,
1052: p_msg_type=>'UNEXPECTED ERROR',
1053: p_msg_level=>fnd_log.level_error);
1054: END IF;
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1057: p_prefix=>l_debug_prefix,

Line 1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1051: p_msg_data=>x_msg_data,
1052: p_msg_type=>'UNEXPECTED ERROR',
1053: p_msg_level=>fnd_log.level_error);
1054: END IF;
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;

Line 1058: p_msg_level=>fnd_log.level_procedure);

1054: END IF;
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;
1060: WHEN OTHERS THEN
1061: x_return_status := fnd_api.g_ret_sts_unexp_error;
1062:

Line 1072: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1068: p_count => x_msg_count,
1069: p_data => x_msg_data);
1070:
1071: -- Debug info.
1072: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'SQL ERROR',
1076: p_msg_level=>fnd_log.level_error);

Line 1076: p_msg_level=>fnd_log.level_error);

1072: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1073: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'SQL ERROR',
1076: p_msg_level=>fnd_log.level_error);
1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1080: p_prefix=>l_debug_prefix,

Line 1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1074: p_msg_data=>x_msg_data,
1075: p_msg_type=>'SQL ERROR',
1076: p_msg_level=>fnd_log.level_error);
1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;

Line 1081: p_msg_level=>fnd_log.level_procedure);

1077: END IF;
1078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1079: hz_utility_v2pub.debug(p_message=>'save_cust_acct_sites(-)',
1080: p_prefix=>l_debug_prefix,
1081: p_msg_level=>fnd_log.level_procedure);
1082: END IF;
1083: END save_cust_acct_sites;
1084:
1085: -- PRIVATE PROCEDURE assign_cust_site_use_v2_rec

Line 1324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1320: -- initialize API return status to success.
1321: x_return_status := FND_API.G_RET_STS_SUCCESS;
1322:
1323: -- Debug info.
1324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(+)',
1326: p_prefix=>l_debug_prefix,
1327: p_msg_level=>fnd_log.level_procedure);
1328: END IF;

Line 1327: p_msg_level=>fnd_log.level_procedure);

1323: -- Debug info.
1324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(+)',
1326: p_prefix=>l_debug_prefix,
1327: p_msg_level=>fnd_log.level_procedure);
1328: END IF;
1329:
1330: -- Create cust site use with site use profile
1331: -- HZ_CUST_ACCONT_SITE_V2PUB will create cust site use and then

Line 1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1373: x_msg_data => x_msg_data
1374: );
1375:
1376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1379: p_prefix=>l_debug_prefix,
1380: p_msg_level=>fnd_log.level_procedure);
1381: END IF;

Line 1380: p_msg_level=>fnd_log.level_procedure);

1376: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1377: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1378: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.create_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1379: p_prefix=>l_debug_prefix,
1380: p_msg_level=>fnd_log.level_procedure);
1381: END IF;
1382: RAISE FND_API.G_EXC_ERROR;
1383: END IF;
1384:

Line 1467: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1463: END IF;
1464: END LOOP;
1465:
1466: -- Debug info.
1467: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1469: p_msg_data=>x_msg_data,
1470: p_msg_type=>'WARNING',
1471: p_msg_level=>fnd_log.level_exception);

Line 1471: p_msg_level=>fnd_log.level_exception);

1467: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1468: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1469: p_msg_data=>x_msg_data,
1470: p_msg_type=>'WARNING',
1471: p_msg_level=>fnd_log.level_exception);
1472: END IF;
1473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1474: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1475: p_prefix=>l_debug_prefix,

Line 1473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1469: p_msg_data=>x_msg_data,
1470: p_msg_type=>'WARNING',
1471: p_msg_level=>fnd_log.level_exception);
1472: END IF;
1473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1474: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1475: p_prefix=>l_debug_prefix,
1476: p_msg_level=>fnd_log.level_procedure);
1477: END IF;

Line 1476: p_msg_level=>fnd_log.level_procedure);

1472: END IF;
1473: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1474: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1475: p_prefix=>l_debug_prefix,
1476: p_msg_level=>fnd_log.level_procedure);
1477: END IF;
1478:
1479: EXCEPTION
1480: WHEN fnd_api.g_exc_error THEN

Line 1493: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1489: p_count => x_msg_count,
1490: p_data => x_msg_data);
1491:
1492: -- Debug info.
1493: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1495: p_msg_data=>x_msg_data,
1496: p_msg_type=>'ERROR',
1497: p_msg_level=>fnd_log.level_error);

Line 1497: p_msg_level=>fnd_log.level_error);

1493: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1495: p_msg_data=>x_msg_data,
1496: p_msg_type=>'ERROR',
1497: p_msg_level=>fnd_log.level_error);
1498: END IF;
1499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1500: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1501: p_prefix=>l_debug_prefix,

Line 1499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1495: p_msg_data=>x_msg_data,
1496: p_msg_type=>'ERROR',
1497: p_msg_level=>fnd_log.level_error);
1498: END IF;
1499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1500: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1501: p_prefix=>l_debug_prefix,
1502: p_msg_level=>fnd_log.level_procedure);
1503: END IF;

Line 1502: p_msg_level=>fnd_log.level_procedure);

1498: END IF;
1499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1500: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1501: p_prefix=>l_debug_prefix,
1502: p_msg_level=>fnd_log.level_procedure);
1503: END IF;
1504:
1505: WHEN fnd_api.g_exc_unexpected_error THEN
1506: ROLLBACK TO create_casu_v2_pvt;

Line 1518: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1514: p_count => x_msg_count,
1515: p_data => x_msg_data);
1516:
1517: -- Debug info.
1518: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1520: p_msg_data=>x_msg_data,
1521: p_msg_type=>'UNEXPECTED ERROR',
1522: p_msg_level=>fnd_log.level_error);

Line 1522: p_msg_level=>fnd_log.level_error);

1518: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1520: p_msg_data=>x_msg_data,
1521: p_msg_type=>'UNEXPECTED ERROR',
1522: p_msg_level=>fnd_log.level_error);
1523: END IF;
1524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1526: p_prefix=>l_debug_prefix,

Line 1524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1520: p_msg_data=>x_msg_data,
1521: p_msg_type=>'UNEXPECTED ERROR',
1522: p_msg_level=>fnd_log.level_error);
1523: END IF;
1524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1526: p_prefix=>l_debug_prefix,
1527: p_msg_level=>fnd_log.level_procedure);
1528: END IF;

Line 1527: p_msg_level=>fnd_log.level_procedure);

1523: END IF;
1524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1525: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1526: p_prefix=>l_debug_prefix,
1527: p_msg_level=>fnd_log.level_procedure);
1528: END IF;
1529:
1530: WHEN OTHERS THEN
1531: ROLLBACK TO create_casu_v2_pvt;

Line 1547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1543: p_count => x_msg_count,
1544: p_data => x_msg_data);
1545:
1546: -- Debug info.
1547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'SQL ERROR',
1551: p_msg_level=>fnd_log.level_error);

Line 1551: p_msg_level=>fnd_log.level_error);

1547: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1548: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'SQL ERROR',
1551: p_msg_level=>fnd_log.level_error);
1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1555: p_prefix=>l_debug_prefix,

Line 1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1549: p_msg_data=>x_msg_data,
1550: p_msg_type=>'SQL ERROR',
1551: p_msg_level=>fnd_log.level_error);
1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;

Line 1556: p_msg_level=>fnd_log.level_procedure);

1552: END IF;
1553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1554: hz_utility_v2pub.debug(p_message=>'create_cust_site_v2_uses(-)',
1555: p_prefix=>l_debug_prefix,
1556: p_msg_level=>fnd_log.level_procedure);
1557: END IF;
1558: END create_cust_site_v2_uses;
1559:
1560: -- PROCEDURE save_cust_site_v2_uses

Line 1637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1633: -- initialize API return status to success.
1634: x_return_status := FND_API.G_RET_STS_SUCCESS;
1635:
1636: -- Debug info.
1637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1638: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(+)',
1639: p_prefix=>l_debug_prefix,
1640: p_msg_level=>fnd_log.level_procedure);
1641: END IF;

Line 1640: p_msg_level=>fnd_log.level_procedure);

1636: -- Debug info.
1637: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1638: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(+)',
1639: p_prefix=>l_debug_prefix,
1640: p_msg_level=>fnd_log.level_procedure);
1641: END IF;
1642:
1643: -- Create/Update cust site uses
1644: FOR i IN 1..p_casu_v2_objs.COUNT LOOP

Line 1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1695: x_msg_data => x_msg_data
1696: );
1697:
1698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;

Line 1702: p_msg_level=>fnd_log.level_procedure);

1698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1699: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1700: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1701: p_prefix=>l_debug_prefix,
1702: p_msg_level=>fnd_log.level_procedure);
1703: END IF;
1704: RAISE fnd_api.g_exc_error;
1705: END IF;
1706:

Line 1786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1782: x_msg_data => x_msg_data
1783: );
1784:
1785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1787: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1788: p_prefix=>l_debug_prefix,
1789: p_msg_level=>fnd_log.level_procedure);
1790: END IF;

Line 1789: p_msg_level=>fnd_log.level_procedure);

1785: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1787: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_site_v2_uses, acct_site_id: '||p_cas_id||' , cust_acct_site_os: '||l_casu_os||' , cust_acct_site_osr: '||l_casu_osr,
1788: p_prefix=>l_debug_prefix,
1789: p_msg_level=>fnd_log.level_procedure);
1790: END IF;
1791: RAISE fnd_api.g_exc_error;
1792: END IF;
1793:

Line 1872: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1868:
1869: END LOOP;
1870:
1871: -- Debug info.
1872: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1874: p_msg_data=>x_msg_data,
1875: p_msg_type=>'WARNING',
1876: p_msg_level=>fnd_log.level_exception);

Line 1876: p_msg_level=>fnd_log.level_exception);

1872: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1873: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1874: p_msg_data=>x_msg_data,
1875: p_msg_type=>'WARNING',
1876: p_msg_level=>fnd_log.level_exception);
1877: END IF;
1878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1879: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1880: p_prefix=>l_debug_prefix,

Line 1878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1874: p_msg_data=>x_msg_data,
1875: p_msg_type=>'WARNING',
1876: p_msg_level=>fnd_log.level_exception);
1877: END IF;
1878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1879: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1880: p_prefix=>l_debug_prefix,
1881: p_msg_level=>fnd_log.level_procedure);
1882: END IF;

Line 1881: p_msg_level=>fnd_log.level_procedure);

1877: END IF;
1878: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1879: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1880: p_prefix=>l_debug_prefix,
1881: p_msg_level=>fnd_log.level_procedure);
1882: END IF;
1883: EXCEPTION
1884: WHEN fnd_api.g_exc_error THEN
1885: ROLLBACK TO save_casu_v2_pvt;

Line 1897: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1893: p_count => x_msg_count,
1894: p_data => x_msg_data);
1895:
1896: -- Debug info.
1897: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1898: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1899: p_msg_data=>x_msg_data,
1900: p_msg_type=>'ERROR',
1901: p_msg_level=>fnd_log.level_error);

Line 1901: p_msg_level=>fnd_log.level_error);

1897: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1898: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1899: p_msg_data=>x_msg_data,
1900: p_msg_type=>'ERROR',
1901: p_msg_level=>fnd_log.level_error);
1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1905: p_prefix=>l_debug_prefix,

Line 1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1899: p_msg_data=>x_msg_data,
1900: p_msg_type=>'ERROR',
1901: p_msg_level=>fnd_log.level_error);
1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1905: p_prefix=>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_procedure);
1907: END IF;

Line 1906: p_msg_level=>fnd_log.level_procedure);

1902: END IF;
1903: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1904: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1905: p_prefix=>l_debug_prefix,
1906: p_msg_level=>fnd_log.level_procedure);
1907: END IF;
1908:
1909: WHEN fnd_api.g_exc_unexpected_error THEN
1910: ROLLBACK TO save_casu_v2_pvt;

Line 1922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1918: p_count => x_msg_count,
1919: p_data => x_msg_data);
1920:
1921: -- Debug info.
1922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1924: p_msg_data=>x_msg_data,
1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);

Line 1926: p_msg_level=>fnd_log.level_error);

1922: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1923: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1924: p_msg_data=>x_msg_data,
1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);
1927: END IF;
1928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1929: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1930: p_prefix=>l_debug_prefix,

Line 1928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1924: p_msg_data=>x_msg_data,
1925: p_msg_type=>'UNEXPECTED ERROR',
1926: p_msg_level=>fnd_log.level_error);
1927: END IF;
1928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1929: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1930: p_prefix=>l_debug_prefix,
1931: p_msg_level=>fnd_log.level_procedure);
1932: END IF;

Line 1931: p_msg_level=>fnd_log.level_procedure);

1927: END IF;
1928: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1929: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1930: p_prefix=>l_debug_prefix,
1931: p_msg_level=>fnd_log.level_procedure);
1932: END IF;
1933:
1934: WHEN OTHERS THEN
1935: ROLLBACK TO save_casu_v2_pvt;

Line 1951: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1947: p_count => x_msg_count,
1948: p_data => x_msg_data);
1949:
1950: -- Debug info.
1951: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1952: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1953: p_msg_data=>x_msg_data,
1954: p_msg_type=>'SQL ERROR',
1955: p_msg_level=>fnd_log.level_error);

Line 1955: p_msg_level=>fnd_log.level_error);

1951: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1952: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1953: p_msg_data=>x_msg_data,
1954: p_msg_type=>'SQL ERROR',
1955: p_msg_level=>fnd_log.level_error);
1956: END IF;
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1959: p_prefix=>l_debug_prefix,

Line 1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1953: p_msg_data=>x_msg_data,
1954: p_msg_type=>'SQL ERROR',
1955: p_msg_level=>fnd_log.level_error);
1956: END IF;
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1959: p_prefix=>l_debug_prefix,
1960: p_msg_level=>fnd_log.level_procedure);
1961: END IF;

Line 1960: p_msg_level=>fnd_log.level_procedure);

1956: END IF;
1957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1958: hz_utility_v2pub.debug(p_message=>'save_cust_site_v2_uses(-)',
1959: p_prefix=>l_debug_prefix,
1960: p_msg_level=>fnd_log.level_procedure);
1961: END IF;
1962: END save_cust_site_v2_uses;
1963:
1964: -- PROCEDURE save_cust_acct_v2_sites

Line 1992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1988: -- initialize API return status to success
1989: x_return_status := FND_API.G_RET_STS_SUCCESS;
1990:
1991: -- Debug info.
1992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1993: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(+)',
1994: p_prefix=>l_debug_prefix,
1995: p_msg_level=>fnd_log.level_procedure);
1996: END IF;

Line 1995: p_msg_level=>fnd_log.level_procedure);

1991: -- Debug info.
1992: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1993: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(+)',
1994: p_prefix=>l_debug_prefix,
1995: p_msg_level=>fnd_log.level_procedure);
1996: END IF;
1997:
1998: l_parent_acct_id := p_parent_acct_id;
1999: l_parent_acct_os := p_parent_acct_os;

Line 2025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2021: px_parent_acct_osr => l_parent_acct_osr
2022: );
2023:
2024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2026: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
2027: p_prefix=>l_debug_prefix,
2028: p_msg_level=>fnd_log.level_procedure);
2029: END IF;

Line 2028: p_msg_level=>fnd_log.level_procedure);

2024: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2026: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
2027: p_prefix=>l_debug_prefix,
2028: p_msg_level=>fnd_log.level_procedure);
2029: END IF;
2030: RAISE fnd_api.g_exc_error;
2031: END IF;
2032:

Line 2056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2052: px_parent_acct_osr => l_parent_acct_osr
2053: );
2054:
2055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2057: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
2058: p_prefix=>l_debug_prefix,
2059: p_msg_level=>fnd_log.level_procedure);
2060: END IF;

Line 2059: p_msg_level=>fnd_log.level_procedure);

2055: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2057: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_site_bo_pvt.save_cust_acct_v2_sites, parent id: '||l_parent_acct_id||' '||l_parent_acct_os||'-'||l_parent_acct_osr,
2058: p_prefix=>l_debug_prefix,
2059: p_msg_level=>fnd_log.level_procedure);
2060: END IF;
2061: RAISE fnd_api.g_exc_error;
2062: END IF;
2063:

Line 2069: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

2065: END LOOP;
2066: END IF;
2067:
2068: -- Debug info.
2069: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2070: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2071: p_msg_data=>x_msg_data,
2072: p_msg_type=>'WARNING',
2073: p_msg_level=>fnd_log.level_exception);

Line 2073: p_msg_level=>fnd_log.level_exception);

2069: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2070: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2071: p_msg_data=>x_msg_data,
2072: p_msg_type=>'WARNING',
2073: p_msg_level=>fnd_log.level_exception);
2074: END IF;
2075: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2076: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2077: p_prefix=>l_debug_prefix,

Line 2075: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2071: p_msg_data=>x_msg_data,
2072: p_msg_type=>'WARNING',
2073: p_msg_level=>fnd_log.level_exception);
2074: END IF;
2075: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2076: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2077: p_prefix=>l_debug_prefix,
2078: p_msg_level=>fnd_log.level_procedure);
2079: END IF;

Line 2078: p_msg_level=>fnd_log.level_procedure);

2074: END IF;
2075: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2076: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2077: p_prefix=>l_debug_prefix,
2078: p_msg_level=>fnd_log.level_procedure);
2079: END IF;
2080: EXCEPTION
2081: WHEN fnd_api.g_exc_error THEN
2082: x_return_status := fnd_api.g_ret_sts_error;

Line 2089: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2085: p_count => x_msg_count,
2086: p_data => x_msg_data);
2087:
2088: -- Debug info.
2089: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2091: p_msg_data=>x_msg_data,
2092: p_msg_type=>'ERROR',
2093: p_msg_level=>fnd_log.level_error);

Line 2093: p_msg_level=>fnd_log.level_error);

2089: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2090: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2091: p_msg_data=>x_msg_data,
2092: p_msg_type=>'ERROR',
2093: p_msg_level=>fnd_log.level_error);
2094: END IF;
2095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2096: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2097: p_prefix=>l_debug_prefix,

Line 2095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2091: p_msg_data=>x_msg_data,
2092: p_msg_type=>'ERROR',
2093: p_msg_level=>fnd_log.level_error);
2094: END IF;
2095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2096: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2097: p_prefix=>l_debug_prefix,
2098: p_msg_level=>fnd_log.level_procedure);
2099: END IF;

Line 2098: p_msg_level=>fnd_log.level_procedure);

2094: END IF;
2095: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2096: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2097: p_prefix=>l_debug_prefix,
2098: p_msg_level=>fnd_log.level_procedure);
2099: END IF;
2100: WHEN fnd_api.g_exc_unexpected_error THEN
2101: x_return_status := fnd_api.g_ret_sts_unexp_error;
2102:

Line 2108: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2104: p_count => x_msg_count,
2105: p_data => x_msg_data);
2106:
2107: -- Debug info.
2108: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2109: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2110: p_msg_data=>x_msg_data,
2111: p_msg_type=>'UNEXPECTED ERROR',
2112: p_msg_level=>fnd_log.level_error);

Line 2112: p_msg_level=>fnd_log.level_error);

2108: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2109: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2110: p_msg_data=>x_msg_data,
2111: p_msg_type=>'UNEXPECTED ERROR',
2112: p_msg_level=>fnd_log.level_error);
2113: END IF;
2114: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2115: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2116: p_prefix=>l_debug_prefix,

Line 2114: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2110: p_msg_data=>x_msg_data,
2111: p_msg_type=>'UNEXPECTED ERROR',
2112: p_msg_level=>fnd_log.level_error);
2113: END IF;
2114: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2115: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2116: p_prefix=>l_debug_prefix,
2117: p_msg_level=>fnd_log.level_procedure);
2118: END IF;

Line 2117: p_msg_level=>fnd_log.level_procedure);

2113: END IF;
2114: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2115: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2116: p_prefix=>l_debug_prefix,
2117: p_msg_level=>fnd_log.level_procedure);
2118: END IF;
2119: WHEN OTHERS THEN
2120: x_return_status := fnd_api.g_ret_sts_unexp_error;
2121:

Line 2131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

2127: p_count => x_msg_count,
2128: p_data => x_msg_data);
2129:
2130: -- Debug info.
2131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2133: p_msg_data=>x_msg_data,
2134: p_msg_type=>'SQL ERROR',
2135: p_msg_level=>fnd_log.level_error);

Line 2135: p_msg_level=>fnd_log.level_error);

2131: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2132: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2133: p_msg_data=>x_msg_data,
2134: p_msg_type=>'SQL ERROR',
2135: p_msg_level=>fnd_log.level_error);
2136: END IF;
2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2139: p_prefix=>l_debug_prefix,

Line 2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

2133: p_msg_data=>x_msg_data,
2134: p_msg_type=>'SQL ERROR',
2135: p_msg_level=>fnd_log.level_error);
2136: END IF;
2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2139: p_prefix=>l_debug_prefix,
2140: p_msg_level=>fnd_log.level_procedure);
2141: END IF;

Line 2140: p_msg_level=>fnd_log.level_procedure);

2136: END IF;
2137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug(p_message=>'save_cust_acct_v2_sites(-)',
2139: p_prefix=>l_debug_prefix,
2140: p_msg_level=>fnd_log.level_procedure);
2141: END IF;
2142: END save_cust_acct_v2_sites;
2143:
2144: END hz_cust_acct_site_bo_pvt;