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_PARTY_BO_PVT dependencies on FND_LOG

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

464: -- initialize API return status to success.
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: -- Debug info.
468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
469: hz_utility_v2pub.debug(p_message=>'create_relationships(+)',
470: p_prefix=>l_debug_prefix,
471: p_msg_level=>fnd_log.level_procedure);
472: END IF;

Line 471: p_msg_level=>fnd_log.level_procedure);

467: -- Debug info.
468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
469: hz_utility_v2pub.debug(p_message=>'create_relationships(+)',
470: p_prefix=>l_debug_prefix,
471: p_msg_level=>fnd_log.level_procedure);
472: END IF;
473:
474: -- Create relationships
475: FOR i IN 1..p_rel_objs.COUNT LOOP

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

516: x_msg_data => x_msg_data
517: );
518:
519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
521: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,
522: p_prefix=>l_debug_prefix,
523: p_msg_level=>fnd_log.level_procedure);
524: END IF;

Line 523: p_msg_level=>fnd_log.level_procedure);

519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
521: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,
522: p_prefix=>l_debug_prefix,
523: p_msg_level=>fnd_log.level_procedure);
524: END IF;
525: RAISE FND_API.G_EXC_ERROR;
526: END IF;
527:

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

530: END IF;
531: END LOOP;
532:
533: -- Debug info.
534: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
536: p_msg_data=>x_msg_data,
537: p_msg_type=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);

Line 538: p_msg_level=>fnd_log.level_exception);

534: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
536: p_msg_data=>x_msg_data,
537: p_msg_type=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: END IF;
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
542: p_prefix=>l_debug_prefix,

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

536: p_msg_data=>x_msg_data,
537: p_msg_type=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: END IF;
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;

Line 543: p_msg_level=>fnd_log.level_procedure);

539: END IF;
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545: EXCEPTION
546: WHEN fnd_api.g_exc_error THEN
547: ROLLBACK TO create_relationships_pvt;

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

555: p_count => x_msg_count,
556: p_data => x_msg_data);
557:
558: -- Debug info.
559: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
560: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
561: p_msg_data=>x_msg_data,
562: p_msg_type=>'ERROR',
563: p_msg_level=>fnd_log.level_error);

Line 563: p_msg_level=>fnd_log.level_error);

559: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
560: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
561: p_msg_data=>x_msg_data,
562: p_msg_type=>'ERROR',
563: p_msg_level=>fnd_log.level_error);
564: END IF;
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
567: p_prefix=>l_debug_prefix,

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

561: p_msg_data=>x_msg_data,
562: p_msg_type=>'ERROR',
563: p_msg_level=>fnd_log.level_error);
564: END IF;
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
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: END IF;
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
567: p_prefix=>l_debug_prefix,
568: p_msg_level=>fnd_log.level_procedure);
569: END IF;
570: WHEN fnd_api.g_exc_unexpected_error THEN
571: ROLLBACK TO create_relationships_pvt;
572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

579: p_count => x_msg_count,
580: p_data => x_msg_data);
581:
582: -- Debug info.
583: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
585: p_msg_data=>x_msg_data,
586: p_msg_type=>'UNEXPECTED ERROR',
587: p_msg_level=>fnd_log.level_error);

Line 587: p_msg_level=>fnd_log.level_error);

583: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
585: p_msg_data=>x_msg_data,
586: p_msg_type=>'UNEXPECTED ERROR',
587: p_msg_level=>fnd_log.level_error);
588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
591: p_prefix=>l_debug_prefix,

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

585: p_msg_data=>x_msg_data,
586: p_msg_type=>'UNEXPECTED ERROR',
587: p_msg_level=>fnd_log.level_error);
588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
591: p_prefix=>l_debug_prefix,
592: p_msg_level=>fnd_log.level_procedure);
593: END IF;

Line 592: p_msg_level=>fnd_log.level_procedure);

588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
591: p_prefix=>l_debug_prefix,
592: p_msg_level=>fnd_log.level_procedure);
593: END IF;
594:
595: WHEN OTHERS THEN
596: ROLLBACK TO create_relationships_pvt;

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

608: p_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=>'SQL ERROR',
616: p_msg_level=>fnd_log.level_error);

Line 616: p_msg_level=>fnd_log.level_error);

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=>'SQL 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=>'create_relationships(-)',
620: p_prefix=>l_debug_prefix,

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

614: p_msg_data=>x_msg_data,
615: p_msg_type=>'SQL 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=>'create_relationships(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;

Line 621: p_msg_level=>fnd_log.level_procedure);

617: END IF;
618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;
623: END create_relationships;
624:
625: -- PROCEDURE save_relationships

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

688: -- initialize API return status to success.
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: -- Debug info.
692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'save_relationships(+)',
694: p_prefix=>l_debug_prefix,
695: p_msg_level=>fnd_log.level_procedure);
696: END IF;

Line 695: p_msg_level=>fnd_log.level_procedure);

691: -- Debug info.
692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'save_relationships(+)',
694: p_prefix=>l_debug_prefix,
695: p_msg_level=>fnd_log.level_procedure);
696: END IF;
697:
698: -- Create/Update relationship
699: FOR i IN 1..p_rel_objs.COUNT LOOP

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

770: p_rel_objs(i).relationship_id := l_rel_rec.relationship_id;
771: END IF;
772:
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
775: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,
776: p_prefix=>l_debug_prefix,
777: p_msg_level=>fnd_log.level_procedure);
778: END IF;

Line 777: p_msg_level=>fnd_log.level_procedure);

773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
775: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,
776: p_prefix=>l_debug_prefix,
777: p_msg_level=>fnd_log.level_procedure);
778: END IF;
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781: END IF;

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

781: END IF;
782: END LOOP;
783:
784: -- Debug info.
785: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
787: p_msg_data=>x_msg_data,
788: p_msg_type=>'WARNING',
789: p_msg_level=>fnd_log.level_exception);

Line 789: p_msg_level=>fnd_log.level_exception);

785: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
787: p_msg_data=>x_msg_data,
788: p_msg_type=>'WARNING',
789: p_msg_level=>fnd_log.level_exception);
790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
793: p_prefix=>l_debug_prefix,

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

787: p_msg_data=>x_msg_data,
788: p_msg_type=>'WARNING',
789: p_msg_level=>fnd_log.level_exception);
790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
793: p_prefix=>l_debug_prefix,
794: p_msg_level=>fnd_log.level_procedure);
795: END IF;

Line 794: p_msg_level=>fnd_log.level_procedure);

790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
793: p_prefix=>l_debug_prefix,
794: p_msg_level=>fnd_log.level_procedure);
795: END IF;
796: EXCEPTION
797: WHEN fnd_api.g_exc_error THEN
798: ROLLBACK TO save_relationships_pvt;

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

806: p_count => x_msg_count,
807: p_data => x_msg_data);
808:
809: -- Debug info.
810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
812: p_msg_data=>x_msg_data,
813: p_msg_type=>'ERROR',
814: p_msg_level=>fnd_log.level_error);

Line 814: p_msg_level=>fnd_log.level_error);

810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
812: p_msg_data=>x_msg_data,
813: p_msg_type=>'ERROR',
814: p_msg_level=>fnd_log.level_error);
815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
818: p_prefix=>l_debug_prefix,

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

812: p_msg_data=>x_msg_data,
813: p_msg_type=>'ERROR',
814: p_msg_level=>fnd_log.level_error);
815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;

Line 819: p_msg_level=>fnd_log.level_procedure);

815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;
821: WHEN fnd_api.g_exc_unexpected_error THEN
822: ROLLBACK TO save_relationships_pvt;
823: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

830: p_count => x_msg_count,
831: p_data => x_msg_data);
832:
833: -- Debug info.
834: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
835: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
836: p_msg_data=>x_msg_data,
837: p_msg_type=>'UNEXPECTED ERROR',
838: p_msg_level=>fnd_log.level_error);

Line 838: p_msg_level=>fnd_log.level_error);

834: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
835: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
836: p_msg_data=>x_msg_data,
837: p_msg_type=>'UNEXPECTED ERROR',
838: p_msg_level=>fnd_log.level_error);
839: END IF;
840: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
842: p_prefix=>l_debug_prefix,

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

836: p_msg_data=>x_msg_data,
837: p_msg_type=>'UNEXPECTED ERROR',
838: p_msg_level=>fnd_log.level_error);
839: END IF;
840: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
842: p_prefix=>l_debug_prefix,
843: p_msg_level=>fnd_log.level_procedure);
844: END IF;

Line 843: p_msg_level=>fnd_log.level_procedure);

839: END IF;
840: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
842: p_prefix=>l_debug_prefix,
843: p_msg_level=>fnd_log.level_procedure);
844: END IF;
845:
846: WHEN OTHERS THEN
847: ROLLBACK TO save_relationships_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=>'SQL 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=>'SQL 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_relationships(-)',
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=>'SQL 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_relationships(-)',
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_relationships(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: END save_relationships;
875:
876: PROCEDURE create_relationship_obj(

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

902: FND_MSG_PUB.initialize;
903: END IF;
904:
905: -- Debug info.
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(+)',
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;

Line 909: p_msg_level=>fnd_log.level_procedure);

905: -- Debug info.
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(+)',
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;
911:
912:
913: IF(p_created_by_module IS NULL) THEN

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

947: x_msg_data => x_msg_data
948: );
949:
950: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;

Line 954: p_msg_level=>fnd_log.level_procedure);

950: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;
956: RAISE FND_API.G_EXC_ERROR;
957: END IF;
958:

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

959: -- assign relationship_id and party_id
960: p_rel_obj.relationship_id := x_relationship_id;
961:
962: -- Debug info.
963: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
965: p_msg_data=>x_msg_data,
966: p_msg_type=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);

Line 967: p_msg_level=>fnd_log.level_exception);

963: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
965: p_msg_data=>x_msg_data,
966: p_msg_type=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: END IF;
969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
970: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
971: p_prefix=>l_debug_prefix,

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

965: p_msg_data=>x_msg_data,
966: p_msg_type=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: END IF;
969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
970: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
971: p_prefix=>l_debug_prefix,
972: p_msg_level=>fnd_log.level_procedure);
973: END IF;

Line 972: p_msg_level=>fnd_log.level_procedure);

968: END IF;
969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
970: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
971: p_prefix=>l_debug_prefix,
972: p_msg_level=>fnd_log.level_procedure);
973: END IF;
974: EXCEPTION
975: WHEN fnd_api.g_exc_error THEN
976: ROLLBACK TO create_relatobj_pvt;

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

984: p_count => x_msg_count,
985: p_data => x_msg_data);
986:
987: -- Debug info.
988: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
990: p_msg_data=>x_msg_data,
991: p_msg_type=>'ERROR',
992: p_msg_level=>fnd_log.level_error);

Line 992: p_msg_level=>fnd_log.level_error);

988: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
990: p_msg_data=>x_msg_data,
991: p_msg_type=>'ERROR',
992: p_msg_level=>fnd_log.level_error);
993: END IF;
994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
996: p_prefix=>l_debug_prefix,

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

990: p_msg_data=>x_msg_data,
991: p_msg_type=>'ERROR',
992: p_msg_level=>fnd_log.level_error);
993: END IF;
994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
996: p_prefix=>l_debug_prefix,
997: p_msg_level=>fnd_log.level_procedure);
998: END IF;

Line 997: p_msg_level=>fnd_log.level_procedure);

993: END IF;
994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
996: p_prefix=>l_debug_prefix,
997: p_msg_level=>fnd_log.level_procedure);
998: END IF;
999: WHEN fnd_api.g_exc_unexpected_error THEN
1000: ROLLBACK TO create_relatobj_pvt;
1001: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

1008: p_count => x_msg_count,
1009: p_data => x_msg_data);
1010:
1011: -- Debug info.
1012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1014: p_msg_data=>x_msg_data,
1015: p_msg_type=>'UNEXPECTED ERROR',
1016: p_msg_level=>fnd_log.level_error);

Line 1016: p_msg_level=>fnd_log.level_error);

1012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1014: p_msg_data=>x_msg_data,
1015: p_msg_type=>'UNEXPECTED ERROR',
1016: p_msg_level=>fnd_log.level_error);
1017: END IF;
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1019: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1020: p_prefix=>l_debug_prefix,

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

1014: p_msg_data=>x_msg_data,
1015: p_msg_type=>'UNEXPECTED ERROR',
1016: p_msg_level=>fnd_log.level_error);
1017: END IF;
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1019: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1020: p_prefix=>l_debug_prefix,
1021: p_msg_level=>fnd_log.level_procedure);
1022: END IF;

Line 1021: p_msg_level=>fnd_log.level_procedure);

1017: END IF;
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1019: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1020: p_prefix=>l_debug_prefix,
1021: p_msg_level=>fnd_log.level_procedure);
1022: END IF;
1023:
1024: WHEN OTHERS THEN
1025: ROLLBACK TO create_relatobj_pvt;

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

1037: p_count => x_msg_count,
1038: p_data => x_msg_data);
1039:
1040: -- Debug info.
1041: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'SQL ERROR',
1045: p_msg_level=>fnd_log.level_error);

Line 1045: p_msg_level=>fnd_log.level_error);

1041: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'SQL ERROR',
1045: p_msg_level=>fnd_log.level_error);
1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1049: p_prefix=>l_debug_prefix,

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

1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'SQL ERROR',
1045: p_msg_level=>fnd_log.level_error);
1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1049: p_prefix=>l_debug_prefix,
1050: p_msg_level=>fnd_log.level_procedure);
1051: END IF;

Line 1050: p_msg_level=>fnd_log.level_procedure);

1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1049: p_prefix=>l_debug_prefix,
1050: p_msg_level=>fnd_log.level_procedure);
1051: END IF;
1052: END create_relationship_obj;
1053:
1054: PROCEDURE update_relationship_obj(

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

1090: FND_MSG_PUB.initialize;
1091: END IF;
1092:
1093: -- Debug info.
1094: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1095: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(+)',
1096: p_prefix=>l_debug_prefix,
1097: p_msg_level=>fnd_log.level_procedure);
1098: END IF;

Line 1097: p_msg_level=>fnd_log.level_procedure);

1093: -- Debug info.
1094: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1095: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(+)',
1096: p_prefix=>l_debug_prefix,
1097: p_msg_level=>fnd_log.level_procedure);
1098: END IF;
1099:
1100: IF(p_rel_obj.parent_object_type = 'ORG') THEN
1101: l_subject_type := 'ORGANIZATION';

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

1134: -- assign relationship_id
1135: p_rel_obj.relationship_id := x_relationship_id;
1136:
1137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.update_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;

Line 1141: p_msg_level=>fnd_log.level_procedure);

1137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.update_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;
1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:

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

1143: RAISE FND_API.G_EXC_ERROR;
1144: END IF;
1145:
1146: -- Debug info.
1147: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1148: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1149: p_msg_data=>x_msg_data,
1150: p_msg_type=>'WARNING',
1151: p_msg_level=>fnd_log.level_exception);

Line 1151: p_msg_level=>fnd_log.level_exception);

1147: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1148: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1149: p_msg_data=>x_msg_data,
1150: p_msg_type=>'WARNING',
1151: p_msg_level=>fnd_log.level_exception);
1152: END IF;
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1155: p_prefix=>l_debug_prefix,

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

1149: p_msg_data=>x_msg_data,
1150: p_msg_type=>'WARNING',
1151: p_msg_level=>fnd_log.level_exception);
1152: END IF;
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1155: p_prefix=>l_debug_prefix,
1156: p_msg_level=>fnd_log.level_procedure);
1157: END IF;

Line 1156: p_msg_level=>fnd_log.level_procedure);

1152: END IF;
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1155: p_prefix=>l_debug_prefix,
1156: p_msg_level=>fnd_log.level_procedure);
1157: END IF;
1158: EXCEPTION
1159: WHEN fnd_api.g_exc_error THEN
1160: ROLLBACK TO update_relatobj_pvt;

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

1168: p_count => x_msg_count,
1169: p_data => x_msg_data);
1170:
1171: -- Debug info.
1172: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1173: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1174: p_msg_data=>x_msg_data,
1175: p_msg_type=>'ERROR',
1176: p_msg_level=>fnd_log.level_error);

Line 1176: p_msg_level=>fnd_log.level_error);

1172: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1173: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1174: p_msg_data=>x_msg_data,
1175: p_msg_type=>'ERROR',
1176: p_msg_level=>fnd_log.level_error);
1177: END IF;
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1180: p_prefix=>l_debug_prefix,

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

1174: p_msg_data=>x_msg_data,
1175: p_msg_type=>'ERROR',
1176: p_msg_level=>fnd_log.level_error);
1177: END IF;
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1180: p_prefix=>l_debug_prefix,
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;

Line 1181: p_msg_level=>fnd_log.level_procedure);

1177: END IF;
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1180: p_prefix=>l_debug_prefix,
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;
1183: WHEN fnd_api.g_exc_unexpected_error THEN
1184: ROLLBACK TO update_relatobj_pvt;
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:
1195: -- Debug info.
1196: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1197: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1198: p_msg_data=>x_msg_data,
1199: p_msg_type=>'UNEXPECTED ERROR',
1200: p_msg_level=>fnd_log.level_error);

Line 1200: p_msg_level=>fnd_log.level_error);

1196: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1197: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1198: p_msg_data=>x_msg_data,
1199: p_msg_type=>'UNEXPECTED ERROR',
1200: p_msg_level=>fnd_log.level_error);
1201: END IF;
1202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1203: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1204: p_prefix=>l_debug_prefix,

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

1198: p_msg_data=>x_msg_data,
1199: p_msg_type=>'UNEXPECTED ERROR',
1200: p_msg_level=>fnd_log.level_error);
1201: END IF;
1202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1203: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1204: p_prefix=>l_debug_prefix,
1205: p_msg_level=>fnd_log.level_procedure);
1206: END IF;

Line 1205: p_msg_level=>fnd_log.level_procedure);

1201: END IF;
1202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1203: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1204: p_prefix=>l_debug_prefix,
1205: p_msg_level=>fnd_log.level_procedure);
1206: END IF;
1207:
1208: WHEN OTHERS THEN
1209: ROLLBACK TO update_relatobj_pvt;

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

1221: p_count => x_msg_count,
1222: p_data => x_msg_data);
1223:
1224: -- Debug info.
1225: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1226: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1227: p_msg_data=>x_msg_data,
1228: p_msg_type=>'SQL ERROR',
1229: p_msg_level=>fnd_log.level_error);

Line 1229: p_msg_level=>fnd_log.level_error);

1225: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1226: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1227: p_msg_data=>x_msg_data,
1228: p_msg_type=>'SQL ERROR',
1229: p_msg_level=>fnd_log.level_error);
1230: END IF;
1231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1233: p_prefix=>l_debug_prefix,

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

1227: p_msg_data=>x_msg_data,
1228: p_msg_type=>'SQL ERROR',
1229: p_msg_level=>fnd_log.level_error);
1230: END IF;
1231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1233: p_prefix=>l_debug_prefix,
1234: p_msg_level=>fnd_log.level_procedure);
1235: END IF;

Line 1234: p_msg_level=>fnd_log.level_procedure);

1230: END IF;
1231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1233: p_prefix=>l_debug_prefix,
1234: p_msg_level=>fnd_log.level_procedure);
1235: END IF;
1236: END update_relationship_obj;
1237:
1238: PROCEDURE save_relationship_obj(

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

1276: END IF;
1277:
1278:
1279: -- Debug info.
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(+)',
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
1284: END IF;

Line 1283: p_msg_level=>fnd_log.level_procedure);

1279: -- Debug info.
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(+)',
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
1284: END IF;
1285:
1286: IF(p_created_by_module IS NULL) THEN
1287: l_created_by_module := 'BO_API';

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

1344: p_rel_obj.relationship_id := x_relationship_id;
1345: END IF;
1346:
1347: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1349: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
1350: p_prefix=>l_debug_prefix,
1351: p_msg_level=>fnd_log.level_procedure);
1352: END IF;

Line 1351: p_msg_level=>fnd_log.level_procedure);

1347: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1349: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
1350: p_prefix=>l_debug_prefix,
1351: p_msg_level=>fnd_log.level_procedure);
1352: END IF;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:

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

1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356: -- Debug info.
1357: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);

Line 1361: p_msg_level=>fnd_log.level_exception);

1357: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);
1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1365: p_prefix=>l_debug_prefix,

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

1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);
1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;

Line 1366: p_msg_level=>fnd_log.level_procedure);

1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;
1368: EXCEPTION
1369: WHEN fnd_api.g_exc_error THEN
1370: ROLLBACK TO save_relatobj_pvt;

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

1378: p_count => x_msg_count,
1379: p_data => x_msg_data);
1380:
1381: -- Debug info.
1382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);

Line 1386: p_msg_level=>fnd_log.level_error);

1382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);
1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1390: p_prefix=>l_debug_prefix,

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

1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);
1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;

Line 1391: p_msg_level=>fnd_log.level_procedure);

1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: ROLLBACK TO save_relatobj_pvt;
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

1402: p_count => x_msg_count,
1403: p_data => x_msg_data);
1404:
1405: -- Debug info.
1406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1408: p_msg_data=>x_msg_data,
1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);

Line 1410: p_msg_level=>fnd_log.level_error);

1406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1408: p_msg_data=>x_msg_data,
1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);
1411: END IF;
1412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1414: p_prefix=>l_debug_prefix,

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

1408: p_msg_data=>x_msg_data,
1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);
1411: END IF;
1412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1414: p_prefix=>l_debug_prefix,
1415: p_msg_level=>fnd_log.level_procedure);
1416: END IF;

Line 1415: p_msg_level=>fnd_log.level_procedure);

1411: END IF;
1412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1414: p_prefix=>l_debug_prefix,
1415: p_msg_level=>fnd_log.level_procedure);
1416: END IF;
1417:
1418: WHEN OTHERS THEN
1419: ROLLBACK TO save_relatobj_pvt;

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

1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: -- Debug info.
1435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'SQL ERROR',
1439: p_msg_level=>fnd_log.level_error);

Line 1439: p_msg_level=>fnd_log.level_error);

1435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'SQL ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1443: p_prefix=>l_debug_prefix,

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

1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'SQL ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;

Line 1444: p_msg_level=>fnd_log.level_procedure);

1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446: END save_relationship_obj;
1447:
1448: -- PROCEDURE get_relationship_obj

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

1568: FND_MSG_PUB.initialize;
1569: END IF;
1570:
1571: -- Debug info.
1572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1573: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (+)',
1574: p_prefix=>l_debug_prefix,
1575: p_msg_level=>fnd_log.level_procedure);
1576: END IF;

Line 1575: p_msg_level=>fnd_log.level_procedure);

1571: -- Debug info.
1572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1573: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (+)',
1574: p_prefix=>l_debug_prefix,
1575: p_msg_level=>fnd_log.level_procedure);
1576: END IF;
1577:
1578: OPEN c1(p_relationship_id);
1579: FETCH c1 into x_relationship_obj;

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

1579: FETCH c1 into x_relationship_obj;
1580: CLOSE c1;
1581:
1582: -- Debug info.
1583: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1585: p_msg_data=>x_msg_data,
1586: p_msg_type=>'WARNING',
1587: p_msg_level=>fnd_log.level_exception);

Line 1587: p_msg_level=>fnd_log.level_exception);

1583: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1585: p_msg_data=>x_msg_data,
1586: p_msg_type=>'WARNING',
1587: p_msg_level=>fnd_log.level_exception);
1588: END IF;
1589:
1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1587: p_msg_level=>fnd_log.level_exception);
1588: END IF;
1589:
1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1592: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (-)',
1593: p_prefix=>l_debug_prefix,
1594: p_msg_level=>fnd_log.level_procedure);
1595: END IF;

Line 1594: p_msg_level=>fnd_log.level_procedure);

1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1592: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (-)',
1593: p_prefix=>l_debug_prefix,
1594: p_msg_level=>fnd_log.level_procedure);
1595: END IF;
1596: EXCEPTION
1597: WHEN fnd_api.g_exc_error THEN
1598: x_return_status := fnd_api.g_ret_sts_error;

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

1600: p_count => x_msg_count,
1601: p_data => x_msg_data);
1602:
1603: -- Debug info.
1604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'ERROR',
1608: p_msg_level=>fnd_log.level_error);

Line 1608: p_msg_level=>fnd_log.level_error);

1604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1612: p_prefix=>l_debug_prefix,

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

1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;

Line 1613: p_msg_level=>fnd_log.level_procedure);

1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;
1615: WHEN fnd_api.g_exc_unexpected_error THEN
1616: x_return_status := fnd_api.g_ret_sts_unexp_error;
1617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: -- Debug info.
1622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);

Line 1626: p_msg_level=>fnd_log.level_error);

1622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1630: p_prefix=>l_debug_prefix,

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

1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;

Line 1631: p_msg_level=>fnd_log.level_procedure);

1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;
1633:
1634: WHEN OTHERS THEN
1635: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1642: p_count => x_msg_count,
1643: p_data => x_msg_data);
1644:
1645: -- Debug info.
1646: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1647: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1648: p_msg_data=>x_msg_data,
1649: p_msg_type=>'SQL ERROR',
1650: p_msg_level=>fnd_log.level_error);

Line 1650: p_msg_level=>fnd_log.level_error);

1646: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1647: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1648: p_msg_data=>x_msg_data,
1649: p_msg_type=>'SQL ERROR',
1650: p_msg_level=>fnd_log.level_error);
1651: END IF;
1652: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1653: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1654: p_prefix=>l_debug_prefix,

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

1648: p_msg_data=>x_msg_data,
1649: p_msg_type=>'SQL ERROR',
1650: p_msg_level=>fnd_log.level_error);
1651: END IF;
1652: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1653: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1654: p_prefix=>l_debug_prefix,
1655: p_msg_level=>fnd_log.level_procedure);
1656: END IF;

Line 1655: p_msg_level=>fnd_log.level_procedure);

1651: END IF;
1652: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1653: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1654: p_prefix=>l_debug_prefix,
1655: p_msg_level=>fnd_log.level_procedure);
1656: END IF;
1657: END get_relationship_obj;
1658:
1659: -- PROCEDURE create_classifications

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

1711: -- initialize API return status to success.
1712: x_return_status := FND_API.G_RET_STS_SUCCESS;
1713:
1714: -- Debug info.
1715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1716: hz_utility_v2pub.debug(p_message=>'create_classifications(+)',
1717: p_prefix=>l_debug_prefix,
1718: p_msg_level=>fnd_log.level_procedure);
1719: END IF;

Line 1718: p_msg_level=>fnd_log.level_procedure);

1714: -- Debug info.
1715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1716: hz_utility_v2pub.debug(p_message=>'create_classifications(+)',
1717: p_prefix=>l_debug_prefix,
1718: p_msg_level=>fnd_log.level_procedure);
1719: END IF;
1720:
1721: -- Create code assignments
1722: FOR i IN 1..p_code_assign_objs.COUNT LOOP

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

1735: x_msg_data => x_msg_data
1736: );
1737:
1738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;

Line 1742: p_msg_level=>fnd_log.level_procedure);

1738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;
1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;
1746:

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

1748: p_code_assign_objs(i).code_assignment_id := l_code_assign_id;
1749: END LOOP;
1750:
1751: -- Debug info.
1752: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1754: p_msg_data=>x_msg_data,
1755: p_msg_type=>'WARNING',
1756: p_msg_level=>fnd_log.level_exception);

Line 1756: p_msg_level=>fnd_log.level_exception);

1752: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1754: p_msg_data=>x_msg_data,
1755: p_msg_type=>'WARNING',
1756: p_msg_level=>fnd_log.level_exception);
1757: END IF;
1758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1759: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1760: p_prefix=>l_debug_prefix,

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

1754: p_msg_data=>x_msg_data,
1755: p_msg_type=>'WARNING',
1756: p_msg_level=>fnd_log.level_exception);
1757: END IF;
1758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1759: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1760: p_prefix=>l_debug_prefix,
1761: p_msg_level=>fnd_log.level_procedure);
1762: END IF;

Line 1761: p_msg_level=>fnd_log.level_procedure);

1757: END IF;
1758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1759: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1760: p_prefix=>l_debug_prefix,
1761: p_msg_level=>fnd_log.level_procedure);
1762: END IF;
1763: EXCEPTION
1764: WHEN fnd_api.g_exc_error THEN
1765: ROLLBACK TO create_classifications_pvt;

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

1773: p_count => x_msg_count,
1774: p_data => x_msg_data);
1775:
1776: -- Debug info.
1777: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1779: p_msg_data=>x_msg_data,
1780: p_msg_type=>'ERROR',
1781: p_msg_level=>fnd_log.level_error);

Line 1781: p_msg_level=>fnd_log.level_error);

1777: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1779: p_msg_data=>x_msg_data,
1780: p_msg_type=>'ERROR',
1781: p_msg_level=>fnd_log.level_error);
1782: END IF;
1783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1784: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1785: p_prefix=>l_debug_prefix,

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

1779: p_msg_data=>x_msg_data,
1780: p_msg_type=>'ERROR',
1781: p_msg_level=>fnd_log.level_error);
1782: END IF;
1783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1784: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1785: p_prefix=>l_debug_prefix,
1786: p_msg_level=>fnd_log.level_procedure);
1787: END IF;

Line 1786: p_msg_level=>fnd_log.level_procedure);

1782: END IF;
1783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1784: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1785: p_prefix=>l_debug_prefix,
1786: p_msg_level=>fnd_log.level_procedure);
1787: END IF;
1788: WHEN fnd_api.g_exc_unexpected_error THEN
1789: ROLLBACK TO create_classifications_pvt;
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

1797: p_count => x_msg_count,
1798: p_data => x_msg_data);
1799:
1800: -- Debug info.
1801: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1802: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1803: p_msg_data=>x_msg_data,
1804: p_msg_type=>'UNEXPECTED ERROR',
1805: p_msg_level=>fnd_log.level_error);

Line 1805: p_msg_level=>fnd_log.level_error);

1801: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1802: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1803: p_msg_data=>x_msg_data,
1804: p_msg_type=>'UNEXPECTED ERROR',
1805: p_msg_level=>fnd_log.level_error);
1806: END IF;
1807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1809: p_prefix=>l_debug_prefix,

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

1803: p_msg_data=>x_msg_data,
1804: p_msg_type=>'UNEXPECTED ERROR',
1805: p_msg_level=>fnd_log.level_error);
1806: END IF;
1807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1809: p_prefix=>l_debug_prefix,
1810: p_msg_level=>fnd_log.level_procedure);
1811: END IF;

Line 1810: p_msg_level=>fnd_log.level_procedure);

1806: END IF;
1807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1809: p_prefix=>l_debug_prefix,
1810: p_msg_level=>fnd_log.level_procedure);
1811: END IF;
1812:
1813: WHEN OTHERS THEN
1814: ROLLBACK TO create_classifications_pvt;

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

1826: p_count => x_msg_count,
1827: p_data => x_msg_data);
1828:
1829: -- Debug info.
1830: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1831: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1832: p_msg_data=>x_msg_data,
1833: p_msg_type=>'SQL ERROR',
1834: p_msg_level=>fnd_log.level_error);

Line 1834: p_msg_level=>fnd_log.level_error);

1830: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1831: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1832: p_msg_data=>x_msg_data,
1833: p_msg_type=>'SQL ERROR',
1834: p_msg_level=>fnd_log.level_error);
1835: END IF;
1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1837: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1838: p_prefix=>l_debug_prefix,

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

1832: p_msg_data=>x_msg_data,
1833: p_msg_type=>'SQL ERROR',
1834: p_msg_level=>fnd_log.level_error);
1835: END IF;
1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1837: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1838: p_prefix=>l_debug_prefix,
1839: p_msg_level=>fnd_log.level_procedure);
1840: END IF;

Line 1839: p_msg_level=>fnd_log.level_procedure);

1835: END IF;
1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1837: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1838: p_prefix=>l_debug_prefix,
1839: p_msg_level=>fnd_log.level_procedure);
1840: END IF;
1841: END create_classifications;
1842:
1843: -- PROCEDURE save_classifications

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

1886: -- initialize API return status to success.
1887: x_return_status := FND_API.G_RET_STS_SUCCESS;
1888:
1889: -- Debug info.
1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'save_classifications(+)',
1892: p_prefix=>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_procedure);
1894: END IF;

Line 1893: p_msg_level=>fnd_log.level_procedure);

1889: -- Debug info.
1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'save_classifications(+)',
1892: p_prefix=>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_procedure);
1894: END IF;
1895:
1896: -- Create/Update classification
1897: FOR i IN 1..p_code_assign_objs.COUNT LOOP

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

1912: x_object_version_number => l_ovn
1913: );
1914:
1915: IF (l_ovn = -1) THEN
1916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1917: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_code_assign_op, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1918: p_prefix=>l_debug_prefix,
1919: p_msg_level=>fnd_log.level_procedure);
1920: END IF;

Line 1919: p_msg_level=>fnd_log.level_procedure);

1915: IF (l_ovn = -1) THEN
1916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1917: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_code_assign_op, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1918: p_prefix=>l_debug_prefix,
1919: p_msg_level=>fnd_log.level_procedure);
1920: END IF;
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
1922: FND_MSG_PUB.ADD;
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

1952: p_code_assign_objs(i).code_assignment_id := l_code_assign_rec.code_assignment_id;
1953: END IF;
1954:
1955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1957: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1958: p_prefix=>l_debug_prefix,
1959: p_msg_level=>fnd_log.level_procedure);
1960: END IF;

Line 1959: p_msg_level=>fnd_log.level_procedure);

1955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1957: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1958: p_prefix=>l_debug_prefix,
1959: p_msg_level=>fnd_log.level_procedure);
1960: END IF;
1961: RAISE FND_API.G_EXC_ERROR;
1962: END IF;
1963: END LOOP;

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

1962: END IF;
1963: END LOOP;
1964:
1965: -- Debug info.
1966: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1967: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1968: p_msg_data=>x_msg_data,
1969: p_msg_type=>'WARNING',
1970: p_msg_level=>fnd_log.level_exception);

Line 1970: p_msg_level=>fnd_log.level_exception);

1966: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1967: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1968: p_msg_data=>x_msg_data,
1969: p_msg_type=>'WARNING',
1970: p_msg_level=>fnd_log.level_exception);
1971: END IF;
1972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1973: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1974: p_prefix=>l_debug_prefix,

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

1968: p_msg_data=>x_msg_data,
1969: p_msg_type=>'WARNING',
1970: p_msg_level=>fnd_log.level_exception);
1971: END IF;
1972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1973: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1974: p_prefix=>l_debug_prefix,
1975: p_msg_level=>fnd_log.level_procedure);
1976: END IF;

Line 1975: p_msg_level=>fnd_log.level_procedure);

1971: END IF;
1972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1973: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1974: p_prefix=>l_debug_prefix,
1975: p_msg_level=>fnd_log.level_procedure);
1976: END IF;
1977: EXCEPTION
1978: WHEN fnd_api.g_exc_error THEN
1979: ROLLBACK TO save_classifications_pvt;

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

1987: p_count => x_msg_count,
1988: p_data => x_msg_data);
1989:
1990: -- Debug info.
1991: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1992: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1993: p_msg_data=>x_msg_data,
1994: p_msg_type=>'ERROR',
1995: p_msg_level=>fnd_log.level_error);

Line 1995: p_msg_level=>fnd_log.level_error);

1991: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1992: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1993: p_msg_data=>x_msg_data,
1994: p_msg_type=>'ERROR',
1995: p_msg_level=>fnd_log.level_error);
1996: END IF;
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1999: p_prefix=>l_debug_prefix,

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

1993: p_msg_data=>x_msg_data,
1994: p_msg_type=>'ERROR',
1995: p_msg_level=>fnd_log.level_error);
1996: END IF;
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1999: p_prefix=>l_debug_prefix,
2000: p_msg_level=>fnd_log.level_procedure);
2001: END IF;

Line 2000: p_msg_level=>fnd_log.level_procedure);

1996: END IF;
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1999: p_prefix=>l_debug_prefix,
2000: p_msg_level=>fnd_log.level_procedure);
2001: END IF;
2002: WHEN fnd_api.g_exc_unexpected_error THEN
2003: ROLLBACK TO save_classifications_pvt;
2004: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2011: p_count => x_msg_count,
2012: p_data => x_msg_data);
2013:
2014: -- Debug info.
2015: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2016: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'UNEXPECTED ERROR',
2019: p_msg_level=>fnd_log.level_error);

Line 2019: p_msg_level=>fnd_log.level_error);

2015: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2016: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'UNEXPECTED ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2023: p_prefix=>l_debug_prefix,

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

2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'UNEXPECTED ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2023: p_prefix=>l_debug_prefix,
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;

Line 2024: p_msg_level=>fnd_log.level_procedure);

2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2023: p_prefix=>l_debug_prefix,
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;
2026: WHEN OTHERS THEN
2027: ROLLBACK TO save_classifications_pvt;
2028: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2039: p_count => x_msg_count,
2040: p_data => x_msg_data);
2041:
2042: -- Debug info.
2043: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2045: p_msg_data=>x_msg_data,
2046: p_msg_type=>'SQL ERROR',
2047: p_msg_level=>fnd_log.level_error);

Line 2047: p_msg_level=>fnd_log.level_error);

2043: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2045: p_msg_data=>x_msg_data,
2046: p_msg_type=>'SQL ERROR',
2047: p_msg_level=>fnd_log.level_error);
2048: END IF;
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2051: p_prefix=>l_debug_prefix,

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

2045: p_msg_data=>x_msg_data,
2046: p_msg_type=>'SQL ERROR',
2047: p_msg_level=>fnd_log.level_error);
2048: END IF;
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2051: p_prefix=>l_debug_prefix,
2052: p_msg_level=>fnd_log.level_procedure);
2053: END IF;

Line 2052: p_msg_level=>fnd_log.level_procedure);

2048: END IF;
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2051: p_prefix=>l_debug_prefix,
2052: p_msg_level=>fnd_log.level_procedure);
2053: END IF;
2054: END save_classifications;
2055:
2056: -- PROCEDURE create_certifications

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

2096: -- initialize API return status to success.
2097: x_return_status := FND_API.G_RET_STS_SUCCESS;
2098:
2099: -- Debug info.
2100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug(p_message=>'create_certifications(+)',
2102: p_prefix=>l_debug_prefix,
2103: p_msg_level=>fnd_log.level_procedure);
2104: END IF;

Line 2103: p_msg_level=>fnd_log.level_procedure);

2099: -- Debug info.
2100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug(p_message=>'create_certifications(+)',
2102: p_prefix=>l_debug_prefix,
2103: p_msg_level=>fnd_log.level_procedure);
2104: END IF;
2105:
2106: -- Create certification
2107: FOR i IN 1..p_cert_objs.COUNT LOOP

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

2120: x_certification_id => l_cert_id
2121: );
2122:
2123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2125: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_certifications, party id: '||p_party_id,
2126: p_prefix=>l_debug_prefix,
2127: p_msg_level=>fnd_log.level_procedure);
2128: END IF;

Line 2127: p_msg_level=>fnd_log.level_procedure);

2123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2125: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_certifications, party id: '||p_party_id,
2126: p_prefix=>l_debug_prefix,
2127: p_msg_level=>fnd_log.level_procedure);
2128: END IF;
2129: RAISE FND_API.G_EXC_ERROR;
2130: END IF;
2131:

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

2133: p_cert_objs(i).certification_id := l_cert_id;
2134: END LOOP;
2135:
2136: -- Debug info.
2137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2139: p_msg_data=>x_msg_data,
2140: p_msg_type=>'WARNING',
2141: p_msg_level=>fnd_log.level_exception);

Line 2141: p_msg_level=>fnd_log.level_exception);

2137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2139: p_msg_data=>x_msg_data,
2140: p_msg_type=>'WARNING',
2141: p_msg_level=>fnd_log.level_exception);
2142: END IF;
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2145: p_prefix=>l_debug_prefix,

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

2139: p_msg_data=>x_msg_data,
2140: p_msg_type=>'WARNING',
2141: p_msg_level=>fnd_log.level_exception);
2142: END IF;
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;

Line 2146: p_msg_level=>fnd_log.level_procedure);

2142: END IF;
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;
2148: EXCEPTION
2149: WHEN fnd_api.g_exc_error THEN
2150: ROLLBACK TO create_certifications_pvt;

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

2158: p_count => x_msg_count,
2159: p_data => x_msg_data);
2160:
2161: -- Debug info.
2162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2164: p_msg_data=>x_msg_data,
2165: p_msg_type=>'ERROR',
2166: p_msg_level=>fnd_log.level_error);

Line 2166: p_msg_level=>fnd_log.level_error);

2162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2164: p_msg_data=>x_msg_data,
2165: p_msg_type=>'ERROR',
2166: p_msg_level=>fnd_log.level_error);
2167: END IF;
2168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2169: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2170: p_prefix=>l_debug_prefix,

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

2164: p_msg_data=>x_msg_data,
2165: p_msg_type=>'ERROR',
2166: p_msg_level=>fnd_log.level_error);
2167: END IF;
2168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2169: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2170: p_prefix=>l_debug_prefix,
2171: p_msg_level=>fnd_log.level_procedure);
2172: END IF;

Line 2171: p_msg_level=>fnd_log.level_procedure);

2167: END IF;
2168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2169: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2170: p_prefix=>l_debug_prefix,
2171: p_msg_level=>fnd_log.level_procedure);
2172: END IF;
2173: WHEN fnd_api.g_exc_unexpected_error THEN
2174: ROLLBACK TO create_certifications_pvt;
2175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2182: p_count => x_msg_count,
2183: p_data => x_msg_data);
2184:
2185: -- Debug info.
2186: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2187: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2188: p_msg_data=>x_msg_data,
2189: p_msg_type=>'UNEXPECTED ERROR',
2190: p_msg_level=>fnd_log.level_error);

Line 2190: p_msg_level=>fnd_log.level_error);

2186: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2187: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2188: p_msg_data=>x_msg_data,
2189: p_msg_type=>'UNEXPECTED ERROR',
2190: p_msg_level=>fnd_log.level_error);
2191: END IF;
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2194: p_prefix=>l_debug_prefix,

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

2188: p_msg_data=>x_msg_data,
2189: p_msg_type=>'UNEXPECTED ERROR',
2190: p_msg_level=>fnd_log.level_error);
2191: END IF;
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;

Line 2195: p_msg_level=>fnd_log.level_procedure);

2191: END IF;
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;
2197:
2198: WHEN OTHERS THEN
2199: ROLLBACK TO create_certifications_pvt;

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

2211: p_count => x_msg_count,
2212: p_data => x_msg_data);
2213:
2214: -- Debug info.
2215: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2217: p_msg_data=>x_msg_data,
2218: p_msg_type=>'SQL ERROR',
2219: p_msg_level=>fnd_log.level_error);

Line 2219: p_msg_level=>fnd_log.level_error);

2215: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2217: p_msg_data=>x_msg_data,
2218: p_msg_type=>'SQL ERROR',
2219: p_msg_level=>fnd_log.level_error);
2220: END IF;
2221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2222: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2223: p_prefix=>l_debug_prefix,

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

2217: p_msg_data=>x_msg_data,
2218: p_msg_type=>'SQL ERROR',
2219: p_msg_level=>fnd_log.level_error);
2220: END IF;
2221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2222: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2223: p_prefix=>l_debug_prefix,
2224: p_msg_level=>fnd_log.level_procedure);
2225: END IF;

Line 2224: p_msg_level=>fnd_log.level_procedure);

2220: END IF;
2221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2222: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2223: p_prefix=>l_debug_prefix,
2224: p_msg_level=>fnd_log.level_procedure);
2225: END IF;
2226: END create_certifications;
2227:
2228: -- PROCEDURE save_certifications

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

2269: -- initialize API return status to success.
2270: x_return_status := FND_API.G_RET_STS_SUCCESS;
2271:
2272: -- Debug info.
2273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2274: hz_utility_v2pub.debug(p_message=>'save_certifications(+)',
2275: p_prefix=>l_debug_prefix,
2276: p_msg_level=>fnd_log.level_procedure);
2277: END IF;

Line 2276: p_msg_level=>fnd_log.level_procedure);

2272: -- Debug info.
2273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2274: hz_utility_v2pub.debug(p_message=>'save_certifications(+)',
2275: p_prefix=>l_debug_prefix,
2276: p_msg_level=>fnd_log.level_procedure);
2277: END IF;
2278:
2279: -- Create/Update classification
2280: FOR i IN 1..p_cert_objs.COUNT LOOP

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

2293: x_return_status => x_return_status
2294: );
2295:
2296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_certification_op, party id: '||p_party_id,
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;

Line 2300: p_msg_level=>fnd_log.level_procedure);

2296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_certification_op, party id: '||p_party_id,
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2303: FND_MSG_PUB.ADD;
2304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2333: p_cert_objs(i).certification_id := l_cert_rec.certification_id;
2334: END IF;
2335:
2336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2338: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_certifications, party id: '||p_party_id,
2339: p_prefix=>l_debug_prefix,
2340: p_msg_level=>fnd_log.level_procedure);
2341: END IF;

Line 2340: p_msg_level=>fnd_log.level_procedure);

2336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2338: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_certifications, party id: '||p_party_id,
2339: p_prefix=>l_debug_prefix,
2340: p_msg_level=>fnd_log.level_procedure);
2341: END IF;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344: END LOOP;

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

2343: END IF;
2344: END LOOP;
2345:
2346: -- Debug info.
2347: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2349: p_msg_data=>x_msg_data,
2350: p_msg_type=>'WARNING',
2351: p_msg_level=>fnd_log.level_exception);

Line 2351: p_msg_level=>fnd_log.level_exception);

2347: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2349: p_msg_data=>x_msg_data,
2350: p_msg_type=>'WARNING',
2351: p_msg_level=>fnd_log.level_exception);
2352: END IF;
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2355: p_prefix=>l_debug_prefix,

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

2349: p_msg_data=>x_msg_data,
2350: p_msg_type=>'WARNING',
2351: p_msg_level=>fnd_log.level_exception);
2352: END IF;
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2355: p_prefix=>l_debug_prefix,
2356: p_msg_level=>fnd_log.level_procedure);
2357: END IF;

Line 2356: p_msg_level=>fnd_log.level_procedure);

2352: END IF;
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2355: p_prefix=>l_debug_prefix,
2356: p_msg_level=>fnd_log.level_procedure);
2357: END IF;
2358: EXCEPTION
2359: WHEN fnd_api.g_exc_error THEN
2360: ROLLBACK TO save_certifications_pvt;

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

2368: p_count => x_msg_count,
2369: p_data => x_msg_data);
2370:
2371: -- Debug info.
2372: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2373: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2374: p_msg_data=>x_msg_data,
2375: p_msg_type=>'ERROR',
2376: p_msg_level=>fnd_log.level_error);

Line 2376: p_msg_level=>fnd_log.level_error);

2372: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2373: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2374: p_msg_data=>x_msg_data,
2375: p_msg_type=>'ERROR',
2376: p_msg_level=>fnd_log.level_error);
2377: END IF;
2378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2379: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2380: p_prefix=>l_debug_prefix,

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

2374: p_msg_data=>x_msg_data,
2375: p_msg_type=>'ERROR',
2376: p_msg_level=>fnd_log.level_error);
2377: END IF;
2378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2379: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2380: p_prefix=>l_debug_prefix,
2381: p_msg_level=>fnd_log.level_procedure);
2382: END IF;

Line 2381: p_msg_level=>fnd_log.level_procedure);

2377: END IF;
2378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2379: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2380: p_prefix=>l_debug_prefix,
2381: p_msg_level=>fnd_log.level_procedure);
2382: END IF;
2383: WHEN fnd_api.g_exc_unexpected_error THEN
2384: ROLLBACK TO save_certifications_pvt;
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394:
2395: -- Debug info.
2396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2398: p_msg_data=>x_msg_data,
2399: p_msg_type=>'UNEXPECTED ERROR',
2400: p_msg_level=>fnd_log.level_error);

Line 2400: p_msg_level=>fnd_log.level_error);

2396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2398: p_msg_data=>x_msg_data,
2399: p_msg_type=>'UNEXPECTED ERROR',
2400: p_msg_level=>fnd_log.level_error);
2401: END IF;
2402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2403: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2404: p_prefix=>l_debug_prefix,

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

2398: p_msg_data=>x_msg_data,
2399: p_msg_type=>'UNEXPECTED ERROR',
2400: p_msg_level=>fnd_log.level_error);
2401: END IF;
2402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2403: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2404: p_prefix=>l_debug_prefix,
2405: p_msg_level=>fnd_log.level_procedure);
2406: END IF;

Line 2405: p_msg_level=>fnd_log.level_procedure);

2401: END IF;
2402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2403: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2404: p_prefix=>l_debug_prefix,
2405: p_msg_level=>fnd_log.level_procedure);
2406: END IF;
2407: WHEN OTHERS THEN
2408: ROLLBACK TO save_certifications_pvt;
2409: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2420: p_count => x_msg_count,
2421: p_data => x_msg_data);
2422:
2423: -- Debug info.
2424: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2425: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2426: p_msg_data=>x_msg_data,
2427: p_msg_type=>'SQL ERROR',
2428: p_msg_level=>fnd_log.level_error);

Line 2428: p_msg_level=>fnd_log.level_error);

2424: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2425: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2426: p_msg_data=>x_msg_data,
2427: p_msg_type=>'SQL ERROR',
2428: p_msg_level=>fnd_log.level_error);
2429: END IF;
2430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2431: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2432: p_prefix=>l_debug_prefix,

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

2426: p_msg_data=>x_msg_data,
2427: p_msg_type=>'SQL ERROR',
2428: p_msg_level=>fnd_log.level_error);
2429: END IF;
2430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2431: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2432: p_prefix=>l_debug_prefix,
2433: p_msg_level=>fnd_log.level_procedure);
2434: END IF;

Line 2433: p_msg_level=>fnd_log.level_procedure);

2429: END IF;
2430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2431: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2432: p_prefix=>l_debug_prefix,
2433: p_msg_level=>fnd_log.level_procedure);
2434: END IF;
2435: END save_certifications;
2436:
2437: -- PROCEDURE create_financial_profiles

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

2477: -- initialize API return status to success.
2478: x_return_status := FND_API.G_RET_STS_SUCCESS;
2479:
2480: -- Debug info.
2481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2482: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(+)',
2483: p_prefix=>l_debug_prefix,
2484: p_msg_level=>fnd_log.level_procedure);
2485: END IF;

Line 2484: p_msg_level=>fnd_log.level_procedure);

2480: -- Debug info.
2481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2482: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(+)',
2483: p_prefix=>l_debug_prefix,
2484: p_msg_level=>fnd_log.level_procedure);
2485: END IF;
2486:
2487: -- Create financial profiles
2488: FOR i IN 1..p_fin_prof_objs.COUNT LOOP

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

2501: x_financial_profile_id => l_fin_prof_id
2502: );
2503:
2504: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2505: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2506: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_financial_profiles, party id: '||p_party_id,
2507: p_prefix=>l_debug_prefix,
2508: p_msg_level=>fnd_log.level_procedure);
2509: END IF;

Line 2508: p_msg_level=>fnd_log.level_procedure);

2504: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2505: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2506: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_financial_profiles, party id: '||p_party_id,
2507: p_prefix=>l_debug_prefix,
2508: p_msg_level=>fnd_log.level_procedure);
2509: END IF;
2510: RAISE FND_API.G_EXC_ERROR;
2511: END IF;
2512:

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

2514: p_fin_prof_objs(i).financial_profile_id := l_fin_prof_id;
2515: END LOOP;
2516:
2517: -- Debug info.
2518: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'WARNING',
2522: p_msg_level=>fnd_log.level_exception);

Line 2522: p_msg_level=>fnd_log.level_exception);

2518: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'WARNING',
2522: p_msg_level=>fnd_log.level_exception);
2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2526: p_prefix=>l_debug_prefix,

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

2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'WARNING',
2522: p_msg_level=>fnd_log.level_exception);
2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2526: p_prefix=>l_debug_prefix,
2527: p_msg_level=>fnd_log.level_procedure);
2528: END IF;

Line 2527: p_msg_level=>fnd_log.level_procedure);

2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2526: p_prefix=>l_debug_prefix,
2527: p_msg_level=>fnd_log.level_procedure);
2528: END IF;
2529: EXCEPTION
2530: WHEN fnd_api.g_exc_error THEN
2531: ROLLBACK TO create_financial_profiles_pvt;

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

2539: p_count => x_msg_count,
2540: p_data => x_msg_data);
2541:
2542: -- Debug info.
2543: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2544: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2545: p_msg_data=>x_msg_data,
2546: p_msg_type=>'ERROR',
2547: p_msg_level=>fnd_log.level_error);

Line 2547: p_msg_level=>fnd_log.level_error);

2543: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2544: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2545: p_msg_data=>x_msg_data,
2546: p_msg_type=>'ERROR',
2547: p_msg_level=>fnd_log.level_error);
2548: END IF;
2549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2550: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2551: p_prefix=>l_debug_prefix,

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

2545: p_msg_data=>x_msg_data,
2546: p_msg_type=>'ERROR',
2547: p_msg_level=>fnd_log.level_error);
2548: END IF;
2549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2550: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2551: p_prefix=>l_debug_prefix,
2552: p_msg_level=>fnd_log.level_procedure);
2553: END IF;

Line 2552: p_msg_level=>fnd_log.level_procedure);

2548: END IF;
2549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2550: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2551: p_prefix=>l_debug_prefix,
2552: p_msg_level=>fnd_log.level_procedure);
2553: END IF;
2554: WHEN fnd_api.g_exc_unexpected_error THEN
2555: ROLLBACK TO create_financial_profiles_pvt;
2556: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2563: p_count => x_msg_count,
2564: p_data => x_msg_data);
2565:
2566: -- Debug info.
2567: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2568: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'UNEXPECTED ERROR',
2571: p_msg_level=>fnd_log.level_error);

Line 2571: p_msg_level=>fnd_log.level_error);

2567: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2568: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'UNEXPECTED ERROR',
2571: p_msg_level=>fnd_log.level_error);
2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2575: p_prefix=>l_debug_prefix,

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

2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'UNEXPECTED ERROR',
2571: p_msg_level=>fnd_log.level_error);
2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;

Line 2576: p_msg_level=>fnd_log.level_procedure);

2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;
2578:
2579: WHEN OTHERS THEN
2580: ROLLBACK TO create_financial_profiles_pvt;

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

2592: p_count => x_msg_count,
2593: p_data => x_msg_data);
2594:
2595: -- Debug info.
2596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2598: p_msg_data=>x_msg_data,
2599: p_msg_type=>'SQL ERROR',
2600: p_msg_level=>fnd_log.level_error);

Line 2600: p_msg_level=>fnd_log.level_error);

2596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2598: p_msg_data=>x_msg_data,
2599: p_msg_type=>'SQL ERROR',
2600: p_msg_level=>fnd_log.level_error);
2601: END IF;
2602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2603: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2604: p_prefix=>l_debug_prefix,

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

2598: p_msg_data=>x_msg_data,
2599: p_msg_type=>'SQL ERROR',
2600: p_msg_level=>fnd_log.level_error);
2601: END IF;
2602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2603: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2604: p_prefix=>l_debug_prefix,
2605: p_msg_level=>fnd_log.level_procedure);
2606: END IF;

Line 2605: p_msg_level=>fnd_log.level_procedure);

2601: END IF;
2602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2603: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2604: p_prefix=>l_debug_prefix,
2605: p_msg_level=>fnd_log.level_procedure);
2606: END IF;
2607: END create_financial_profiles;
2608:
2609: -- PROCEDURE save_financial_profiles

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

2650: -- initialize API return status to success.
2651: x_return_status := FND_API.G_RET_STS_SUCCESS;
2652:
2653: -- Debug info.
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(+)',
2656: p_prefix=>l_debug_prefix,
2657: p_msg_level=>fnd_log.level_procedure);
2658: END IF;

Line 2657: p_msg_level=>fnd_log.level_procedure);

2653: -- Debug info.
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(+)',
2656: p_prefix=>l_debug_prefix,
2657: p_msg_level=>fnd_log.level_procedure);
2658: END IF;
2659:
2660: -- Create/Update financial profiles
2661: FOR i IN 1..p_fin_prof_objs.COUNT LOOP

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

2673: x_return_status => x_return_status
2674: );
2675:
2676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2678: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_financial_prof_op, financial profile id: '||l_fin_prof_rec.financial_profile_id||', party id: '||p_party_id,
2679: p_prefix=>l_debug_prefix,
2680: p_msg_level=>fnd_log.level_procedure);
2681: END IF;

Line 2680: p_msg_level=>fnd_log.level_procedure);

2676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2678: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_financial_prof_op, financial profile id: '||l_fin_prof_rec.financial_profile_id||', party id: '||p_party_id,
2679: p_prefix=>l_debug_prefix,
2680: p_msg_level=>fnd_log.level_procedure);
2681: END IF;
2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2683: FND_MSG_PUB.ADD;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2713: p_fin_prof_objs(i).financial_profile_id := l_fin_prof_rec.financial_profile_id;
2714: END IF;
2715:
2716: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2718: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_financial_profiles, party id: '||p_party_id,
2719: p_prefix=>l_debug_prefix,
2720: p_msg_level=>fnd_log.level_procedure);
2721: END IF;

Line 2720: p_msg_level=>fnd_log.level_procedure);

2716: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2718: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_financial_profiles, party id: '||p_party_id,
2719: p_prefix=>l_debug_prefix,
2720: p_msg_level=>fnd_log.level_procedure);
2721: END IF;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724: END LOOP;

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

2723: END IF;
2724: END LOOP;
2725:
2726: -- Debug info.
2727: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2728: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2729: p_msg_data=>x_msg_data,
2730: p_msg_type=>'WARNING',
2731: p_msg_level=>fnd_log.level_exception);

Line 2731: p_msg_level=>fnd_log.level_exception);

2727: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2728: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2729: p_msg_data=>x_msg_data,
2730: p_msg_type=>'WARNING',
2731: p_msg_level=>fnd_log.level_exception);
2732: END IF;
2733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2734: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2735: p_prefix=>l_debug_prefix,

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

2729: p_msg_data=>x_msg_data,
2730: p_msg_type=>'WARNING',
2731: p_msg_level=>fnd_log.level_exception);
2732: END IF;
2733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2734: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2735: p_prefix=>l_debug_prefix,
2736: p_msg_level=>fnd_log.level_procedure);
2737: END IF;

Line 2736: p_msg_level=>fnd_log.level_procedure);

2732: END IF;
2733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2734: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2735: p_prefix=>l_debug_prefix,
2736: p_msg_level=>fnd_log.level_procedure);
2737: END IF;
2738: EXCEPTION
2739: WHEN fnd_api.g_exc_error THEN
2740: ROLLBACK TO save_financial_profiles_pvt;

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

2748: p_count => x_msg_count,
2749: p_data => x_msg_data);
2750:
2751: -- Debug info.
2752: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2754: p_msg_data=>x_msg_data,
2755: p_msg_type=>'ERROR',
2756: p_msg_level=>fnd_log.level_error);

Line 2756: p_msg_level=>fnd_log.level_error);

2752: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2754: p_msg_data=>x_msg_data,
2755: p_msg_type=>'ERROR',
2756: p_msg_level=>fnd_log.level_error);
2757: END IF;
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2760: p_prefix=>l_debug_prefix,

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

2754: p_msg_data=>x_msg_data,
2755: p_msg_type=>'ERROR',
2756: p_msg_level=>fnd_log.level_error);
2757: END IF;
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;

Line 2761: p_msg_level=>fnd_log.level_procedure);

2757: END IF;
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763: WHEN fnd_api.g_exc_unexpected_error THEN
2764: ROLLBACK TO save_financial_profiles_pvt;
2765: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774:
2775: -- Debug info.
2776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'UNEXPECTED ERROR',
2780: p_msg_level=>fnd_log.level_error);

Line 2780: p_msg_level=>fnd_log.level_error);

2776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'UNEXPECTED ERROR',
2780: p_msg_level=>fnd_log.level_error);
2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2784: p_prefix=>l_debug_prefix,

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

2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'UNEXPECTED ERROR',
2780: p_msg_level=>fnd_log.level_error);
2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2784: p_prefix=>l_debug_prefix,
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;

Line 2785: p_msg_level=>fnd_log.level_procedure);

2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2784: p_prefix=>l_debug_prefix,
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;
2787: WHEN OTHERS THEN
2788: ROLLBACK TO save_financial_profiles_pvt;
2789: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2800: p_count => x_msg_count,
2801: p_data => x_msg_data);
2802:
2803: -- Debug info.
2804: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2806: p_msg_data=>x_msg_data,
2807: p_msg_type=>'SQL ERROR',
2808: p_msg_level=>fnd_log.level_error);

Line 2808: p_msg_level=>fnd_log.level_error);

2804: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2806: p_msg_data=>x_msg_data,
2807: p_msg_type=>'SQL ERROR',
2808: p_msg_level=>fnd_log.level_error);
2809: END IF;
2810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2811: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2812: p_prefix=>l_debug_prefix,

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

2806: p_msg_data=>x_msg_data,
2807: p_msg_type=>'SQL ERROR',
2808: p_msg_level=>fnd_log.level_error);
2809: END IF;
2810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2811: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2812: p_prefix=>l_debug_prefix,
2813: p_msg_level=>fnd_log.level_procedure);
2814: END IF;

Line 2813: p_msg_level=>fnd_log.level_procedure);

2809: END IF;
2810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2811: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2812: p_prefix=>l_debug_prefix,
2813: p_msg_level=>fnd_log.level_procedure);
2814: END IF;
2815: END save_financial_profiles;
2816:
2817: -- PROCEDURE save_party_preferences

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

2856: -- initialize API return status to success.
2857: x_return_status := FND_API.G_RET_STS_SUCCESS;
2858:
2859: -- Debug info.
2860: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2861: hz_utility_v2pub.debug(p_message=>'save_party_preferences(+)',
2862: p_prefix=>l_debug_prefix,
2863: p_msg_level=>fnd_log.level_procedure);
2864: END IF;

Line 2863: p_msg_level=>fnd_log.level_procedure);

2859: -- Debug info.
2860: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2861: hz_utility_v2pub.debug(p_message=>'save_party_preferences(+)',
2862: p_prefix=>l_debug_prefix,
2863: p_msg_level=>fnd_log.level_procedure);
2864: END IF;
2865:
2866: -- Create/Update party preferences
2867: FOR i IN 1..p_party_pref_objs.COUNT LOOP

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

2894: x_msg_data => x_msg_data
2895: );
2896:
2897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2899: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_preferences, party id: '||p_party_id,
2900: p_prefix=>l_debug_prefix,
2901: p_msg_level=>fnd_log.level_procedure);
2902: END IF;

Line 2901: p_msg_level=>fnd_log.level_procedure);

2897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2899: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_preferences, party id: '||p_party_id,
2900: p_prefix=>l_debug_prefix,
2901: p_msg_level=>fnd_log.level_procedure);
2902: END IF;
2903: RAISE FND_API.G_EXC_ERROR;
2904: END IF;
2905: END LOOP;

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

2904: END IF;
2905: END LOOP;
2906:
2907: -- Debug info.
2908: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2910: p_msg_data=>x_msg_data,
2911: p_msg_type=>'WARNING',
2912: p_msg_level=>fnd_log.level_exception);

Line 2912: p_msg_level=>fnd_log.level_exception);

2908: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2910: p_msg_data=>x_msg_data,
2911: p_msg_type=>'WARNING',
2912: p_msg_level=>fnd_log.level_exception);
2913: END IF;
2914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2915: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2916: p_prefix=>l_debug_prefix,

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

2910: p_msg_data=>x_msg_data,
2911: p_msg_type=>'WARNING',
2912: p_msg_level=>fnd_log.level_exception);
2913: END IF;
2914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2915: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2916: p_prefix=>l_debug_prefix,
2917: p_msg_level=>fnd_log.level_procedure);
2918: END IF;

Line 2917: p_msg_level=>fnd_log.level_procedure);

2913: END IF;
2914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2915: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2916: p_prefix=>l_debug_prefix,
2917: p_msg_level=>fnd_log.level_procedure);
2918: END IF;
2919: EXCEPTION
2920: WHEN fnd_api.g_exc_error THEN
2921: ROLLBACK TO save_party_preferences_pvt;

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

2929: p_count => x_msg_count,
2930: p_data => x_msg_data);
2931:
2932: -- Debug info.
2933: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2934: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2935: p_msg_data=>x_msg_data,
2936: p_msg_type=>'ERROR',
2937: p_msg_level=>fnd_log.level_error);

Line 2937: p_msg_level=>fnd_log.level_error);

2933: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2934: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2935: p_msg_data=>x_msg_data,
2936: p_msg_type=>'ERROR',
2937: p_msg_level=>fnd_log.level_error);
2938: END IF;
2939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2940: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2941: p_prefix=>l_debug_prefix,

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

2935: p_msg_data=>x_msg_data,
2936: p_msg_type=>'ERROR',
2937: p_msg_level=>fnd_log.level_error);
2938: END IF;
2939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2940: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2941: p_prefix=>l_debug_prefix,
2942: p_msg_level=>fnd_log.level_procedure);
2943: END IF;

Line 2942: p_msg_level=>fnd_log.level_procedure);

2938: END IF;
2939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2940: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2941: p_prefix=>l_debug_prefix,
2942: p_msg_level=>fnd_log.level_procedure);
2943: END IF;
2944: WHEN fnd_api.g_exc_unexpected_error THEN
2945: ROLLBACK TO save_party_preferences_pvt;
2946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2953: p_count => x_msg_count,
2954: p_data => x_msg_data);
2955:
2956: -- Debug info.
2957: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2958: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2959: p_msg_data=>x_msg_data,
2960: p_msg_type=>'UNEXPECTED ERROR',
2961: p_msg_level=>fnd_log.level_error);

Line 2961: p_msg_level=>fnd_log.level_error);

2957: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2958: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2959: p_msg_data=>x_msg_data,
2960: p_msg_type=>'UNEXPECTED ERROR',
2961: p_msg_level=>fnd_log.level_error);
2962: END IF;
2963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2965: p_prefix=>l_debug_prefix,

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

2959: p_msg_data=>x_msg_data,
2960: p_msg_type=>'UNEXPECTED ERROR',
2961: p_msg_level=>fnd_log.level_error);
2962: END IF;
2963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2965: p_prefix=>l_debug_prefix,
2966: p_msg_level=>fnd_log.level_procedure);
2967: END IF;

Line 2966: p_msg_level=>fnd_log.level_procedure);

2962: END IF;
2963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2965: p_prefix=>l_debug_prefix,
2966: p_msg_level=>fnd_log.level_procedure);
2967: END IF;
2968: WHEN OTHERS THEN
2969: ROLLBACK TO save_party_preferences_pvt;
2970: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

2981: p_count => x_msg_count,
2982: p_data => x_msg_data);
2983:
2984: -- Debug info.
2985: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);

Line 2989: p_msg_level=>fnd_log.level_error);

2985: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990: END IF;
2991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2992: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2993: p_prefix=>l_debug_prefix,

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

2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990: END IF;
2991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2992: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2993: p_prefix=>l_debug_prefix,
2994: p_msg_level=>fnd_log.level_procedure);
2995: END IF;

Line 2994: p_msg_level=>fnd_log.level_procedure);

2990: END IF;
2991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2992: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2993: p_prefix=>l_debug_prefix,
2994: p_msg_level=>fnd_log.level_procedure);
2995: END IF;
2996: END save_party_preferences;
2997:
2998:

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

3097: -- initialize API return status to success.
3098: x_return_status := FND_API.G_RET_STS_SUCCESS;
3099:
3100: -- Debug info.
3101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3102: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',
3103: p_prefix=>l_debug_prefix,
3104: p_msg_level=>fnd_log.level_procedure);
3105: END IF;

Line 3104: p_msg_level=>fnd_log.level_procedure);

3100: -- Debug info.
3101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3102: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',
3103: p_prefix=>l_debug_prefix,
3104: p_msg_level=>fnd_log.level_procedure);
3105: END IF;
3106:
3107: FOR i IN 1..p_party_usg_objs.COUNT LOOP
3108: assign_party_usge_assgmnt_rec(

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

3118: x_msg_data => x_msg_data
3119: );
3120:
3121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_party_usage_assignment, party id: '||p_party_id,
3124: p_prefix=>l_debug_prefix,
3125: p_msg_level=>fnd_log.level_procedure);
3126: END IF;

Line 3125: p_msg_level=>fnd_log.level_procedure);

3121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_party_usage_assignment, party id: '||p_party_id,
3124: p_prefix=>l_debug_prefix,
3125: p_msg_level=>fnd_log.level_procedure);
3126: END IF;
3127: RAISE FND_API.G_EXC_ERROR;
3128: END IF;
3129: END LOOP;

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

3128: END IF;
3129: END LOOP;
3130:
3131: -- Debug info.
3132: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3134: p_msg_data=>x_msg_data,
3135: p_msg_type=>'WARNING',
3136: p_msg_level=>fnd_log.level_exception);

Line 3136: p_msg_level=>fnd_log.level_exception);

3132: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3134: p_msg_data=>x_msg_data,
3135: p_msg_type=>'WARNING',
3136: p_msg_level=>fnd_log.level_exception);
3137: END IF;
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3140: p_prefix=>l_debug_prefix,

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

3134: p_msg_data=>x_msg_data,
3135: p_msg_type=>'WARNING',
3136: p_msg_level=>fnd_log.level_exception);
3137: END IF;
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3140: p_prefix=>l_debug_prefix,
3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;

Line 3141: p_msg_level=>fnd_log.level_procedure);

3137: END IF;
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3140: p_prefix=>l_debug_prefix,
3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;
3143:
3144: EXCEPTION
3145: WHEN fnd_api.g_exc_error THEN

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

3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156:
3157: -- Debug info.
3158: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3159: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3160: p_msg_data=>x_msg_data,
3161: p_msg_type=>'ERROR',
3162: p_msg_level=>fnd_log.level_error);

Line 3162: p_msg_level=>fnd_log.level_error);

3158: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3159: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3160: p_msg_data=>x_msg_data,
3161: p_msg_type=>'ERROR',
3162: p_msg_level=>fnd_log.level_error);
3163: END IF;
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3166: p_prefix=>l_debug_prefix,

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

3160: p_msg_data=>x_msg_data,
3161: p_msg_type=>'ERROR',
3162: p_msg_level=>fnd_log.level_error);
3163: END IF;
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;

Line 3167: p_msg_level=>fnd_log.level_procedure);

3163: END IF;
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;
3169: WHEN fnd_api.g_exc_unexpected_error THEN
3170: ROLLBACK TO create_party_usage_assgmnt_pvt;
3171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3178: p_count => x_msg_count,
3179: p_data => x_msg_data);
3180:
3181: -- Debug info.
3182: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3183: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3184: p_msg_data=>x_msg_data,
3185: p_msg_type=>'UNEXPECTED ERROR',
3186: p_msg_level=>fnd_log.level_error);

Line 3186: p_msg_level=>fnd_log.level_error);

3182: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3183: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3184: p_msg_data=>x_msg_data,
3185: p_msg_type=>'UNEXPECTED ERROR',
3186: p_msg_level=>fnd_log.level_error);
3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3190: p_prefix=>l_debug_prefix,

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

3184: p_msg_data=>x_msg_data,
3185: p_msg_type=>'UNEXPECTED ERROR',
3186: p_msg_level=>fnd_log.level_error);
3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3190: p_prefix=>l_debug_prefix,
3191: p_msg_level=>fnd_log.level_procedure);
3192: END IF;

Line 3191: p_msg_level=>fnd_log.level_procedure);

3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3190: p_prefix=>l_debug_prefix,
3191: p_msg_level=>fnd_log.level_procedure);
3192: END IF;
3193:
3194: WHEN OTHERS THEN
3195: ROLLBACK TO create_party_usage_assgmnt_pvt;

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

3207: p_count => x_msg_count,
3208: p_data => x_msg_data);
3209:
3210: -- Debug info.
3211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);

Line 3215: p_msg_level=>fnd_log.level_error);

3211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216: END IF;
3217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3218: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3219: p_prefix=>l_debug_prefix,

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

3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216: END IF;
3217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3218: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3219: p_prefix=>l_debug_prefix,
3220: p_msg_level=>fnd_log.level_procedure);
3221: END IF;

Line 3220: p_msg_level=>fnd_log.level_procedure);

3216: END IF;
3217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3218: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3219: p_prefix=>l_debug_prefix,
3220: p_msg_level=>fnd_log.level_procedure);
3221: END IF;
3222:
3223: end create_party_usage_assgmnt;
3224:

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

3267: -- initialize API return status to success.
3268: x_return_status := FND_API.G_RET_STS_SUCCESS;
3269:
3270: -- Debug info.
3271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3272: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',
3273: p_prefix=>l_debug_prefix,
3274: p_msg_level=>fnd_log.level_procedure);
3275: END IF;

Line 3274: p_msg_level=>fnd_log.level_procedure);

3270: -- Debug info.
3271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3272: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',
3273: p_prefix=>l_debug_prefix,
3274: p_msg_level=>fnd_log.level_procedure);
3275: END IF;
3276:
3277: FOR i IN 1..p_party_usg_objs.COUNT LOOP
3278: --hz_registry_validate_bo_pvt.assign_party_usge_assgmnt_rec(

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

3289: x_last_update_date => l_lud,
3290: x_return_status => x_return_status
3291: );
3292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3294: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_party_usage_op, party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
3295: p_prefix=>l_debug_prefix,
3296: p_msg_level=>fnd_log.level_procedure);
3297: END IF;

Line 3296: p_msg_level=>fnd_log.level_procedure);

3292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3294: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_party_usage_op, party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
3295: p_prefix=>l_debug_prefix,
3296: p_msg_level=>fnd_log.level_procedure);
3297: END IF;
3298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3299: FND_MSG_PUB.ADD;
3300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3321: ) ;
3322: ENd IF;
3323:
3324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_usage_assgmnt,party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;

Line 3328: p_msg_level=>fnd_log.level_procedure);

3324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_usage_assgmnt,party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;
3330: RAISE FND_API.G_EXC_ERROR;
3331: END IF;
3332: END LOOP;

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

3331: END IF;
3332: END LOOP;
3333:
3334: -- Debug info.
3335: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3336: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3337: p_msg_data=>x_msg_data,
3338: p_msg_type=>'WARNING',
3339: p_msg_level=>fnd_log.level_exception);

Line 3339: p_msg_level=>fnd_log.level_exception);

3335: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3336: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3337: p_msg_data=>x_msg_data,
3338: p_msg_type=>'WARNING',
3339: p_msg_level=>fnd_log.level_exception);
3340: END IF;
3341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3342: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3343: p_prefix=>l_debug_prefix,

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

3337: p_msg_data=>x_msg_data,
3338: p_msg_type=>'WARNING',
3339: p_msg_level=>fnd_log.level_exception);
3340: END IF;
3341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3342: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3343: p_prefix=>l_debug_prefix,
3344: p_msg_level=>fnd_log.level_procedure);
3345: END IF;

Line 3344: p_msg_level=>fnd_log.level_procedure);

3340: END IF;
3341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3342: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3343: p_prefix=>l_debug_prefix,
3344: p_msg_level=>fnd_log.level_procedure);
3345: END IF;
3346: EXCEPTION
3347: WHEN fnd_api.g_exc_error THEN
3348: ROLLBACK TO save_party_usage_assgmnt_pvt;

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

3356: p_count => x_msg_count,
3357: p_data => x_msg_data);
3358:
3359: -- Debug info.
3360: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3362: p_msg_data=>x_msg_data,
3363: p_msg_type=>'ERROR',
3364: p_msg_level=>fnd_log.level_error);

Line 3364: p_msg_level=>fnd_log.level_error);

3360: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3362: p_msg_data=>x_msg_data,
3363: p_msg_type=>'ERROR',
3364: p_msg_level=>fnd_log.level_error);
3365: END IF;
3366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3367: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3368: p_prefix=>l_debug_prefix,

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

3362: p_msg_data=>x_msg_data,
3363: p_msg_type=>'ERROR',
3364: p_msg_level=>fnd_log.level_error);
3365: END IF;
3366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3367: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3368: p_prefix=>l_debug_prefix,
3369: p_msg_level=>fnd_log.level_procedure);
3370: END IF;

Line 3369: p_msg_level=>fnd_log.level_procedure);

3365: END IF;
3366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3367: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3368: p_prefix=>l_debug_prefix,
3369: p_msg_level=>fnd_log.level_procedure);
3370: END IF;
3371: WHEN fnd_api.g_exc_unexpected_error THEN
3372: ROLLBACK TO save_party_usage_assgmnt_pvt;
3373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3380: p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: -- Debug info.
3384: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3385: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3386: p_msg_data=>x_msg_data,
3387: p_msg_type=>'UNEXPECTED ERROR',
3388: p_msg_level=>fnd_log.level_error);

Line 3388: p_msg_level=>fnd_log.level_error);

3384: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3385: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3386: p_msg_data=>x_msg_data,
3387: p_msg_type=>'UNEXPECTED ERROR',
3388: p_msg_level=>fnd_log.level_error);
3389: END IF;
3390: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3391: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3392: p_prefix=>l_debug_prefix,

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

3386: p_msg_data=>x_msg_data,
3387: p_msg_type=>'UNEXPECTED ERROR',
3388: p_msg_level=>fnd_log.level_error);
3389: END IF;
3390: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3391: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3392: p_prefix=>l_debug_prefix,
3393: p_msg_level=>fnd_log.level_procedure);
3394: END IF;

Line 3393: p_msg_level=>fnd_log.level_procedure);

3389: END IF;
3390: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3391: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3392: p_prefix=>l_debug_prefix,
3393: p_msg_level=>fnd_log.level_procedure);
3394: END IF;
3395: WHEN OTHERS THEN
3396: ROLLBACK TO save_party_usage_assgmnt_pvt;
3397: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

3408: p_count => x_msg_count,
3409: p_data => x_msg_data);
3410:
3411: -- Debug info.
3412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);

Line 3416: p_msg_level=>fnd_log.level_error);

3412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3420: p_prefix=>l_debug_prefix,

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

3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;

Line 3421: p_msg_level=>fnd_log.level_procedure);

3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3423: END save_party_usage_assgmnt;
3424:
3425: -- PROCEDURE call_bes

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

3728: message IN VARCHAR2,
3729: newline IN BOOLEAN DEFAULT TRUE) IS
3730: l_prefix VARCHAR2(20) := 'V3API_BO_RAISE';
3731: BEGIN
3732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3733: hz_utility_v2pub.DEBUG (p_message=>message,
3734: p_prefix=>l_prefix,
3735: p_msg_level=>fnd_log.level_procedure);
3736: END IF ;

Line 3735: p_msg_level=>fnd_log.level_procedure);

3731: BEGIN
3732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3733: hz_utility_v2pub.DEBUG (p_message=>message,
3734: p_prefix=>l_prefix,
3735: p_msg_level=>fnd_log.level_procedure);
3736: END IF ;
3737:
3738: IF newline THEN
3739: FND_FILE.put_line(FND_FILE.LOG,message);

Line 3789: p_msg_level=>fnd_log.level_procedure);

3785: IF l_child_rec_exists_no <> 0 THEN
3786: -- data already exists, no need to write
3787: hz_utility_v2pub.DEBUG(p_message=> 'Record already exists in BOT',
3788: p_prefix=>l_debug_prefix,
3789: p_msg_level=>fnd_log.level_procedure);
3790: END IF;
3791: EXCEPTION
3792: WHEN NO_DATA_FOUND THEN
3793: INSERT INTO HZ_BUS_OBJ_TRACKING

Line 3820: p_msg_level=>fnd_log.level_procedure);

3816: IF l_child_rec_exists_no <> 0 THEN
3817: -- data already exists, no need to write
3818: hz_utility_v2pub.DEBUG(p_message=> 'Record already exists in BOT',
3819: p_prefix=>l_debug_prefix,
3820: p_msg_level=>fnd_log.level_procedure);
3821: END IF;
3822: EXCEPTION
3823: WHEN NO_DATA_FOUND THEN
3824: INSERT INTO HZ_BUS_OBJ_TRACKING