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

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

669: -- initialize API return status to success.
670: x_return_status := FND_API.G_RET_STS_SUCCESS;
671:
672: -- Debug info.
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(+)',
675: p_prefix=>l_debug_prefix,
676: p_msg_level=>fnd_log.level_procedure);
677: END IF;

Line 676: p_msg_level=>fnd_log.level_procedure);

672: -- Debug info.
673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
674: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(+)',
675: p_prefix=>l_debug_prefix,
676: p_msg_level=>fnd_log.level_procedure);
677: END IF;
678:
679: --------------------------------
680: -- Assign credit rating record

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

694: x_msg_data => x_msg_data
695: );
696:
697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
700: p_prefix=>l_debug_prefix,
701: p_msg_level=>fnd_log.level_procedure);
702: END IF;

Line 701: p_msg_level=>fnd_log.level_procedure);

697: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
700: p_prefix=>l_debug_prefix,
701: p_msg_level=>fnd_log.level_procedure);
702: END IF;
703: RAISE FND_API.G_EXC_ERROR;
704: END IF;
705:

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

707: p_credit_rating_objs(i).credit_rating_id := l_dummy_id;
708: END LOOP;
709:
710: -- Debug info.
711: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
713: p_msg_data=>x_msg_data,
714: p_msg_type=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);

Line 715: p_msg_level=>fnd_log.level_exception);

711: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
712: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
713: p_msg_data=>x_msg_data,
714: p_msg_type=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: END IF;
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
719: p_prefix=>l_debug_prefix,

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

713: p_msg_data=>x_msg_data,
714: p_msg_type=>'WARNING',
715: p_msg_level=>fnd_log.level_exception);
716: END IF;
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;

Line 720: p_msg_level=>fnd_log.level_procedure);

716: END IF;
717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
718: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
719: p_prefix=>l_debug_prefix,
720: p_msg_level=>fnd_log.level_procedure);
721: END IF;
722: EXCEPTION
723: WHEN fnd_api.g_exc_error THEN
724: ROLLBACK TO create_credit_ratings_pub;

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

732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: -- Debug info.
736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
738: p_msg_data=>x_msg_data,
739: p_msg_type=>'ERROR',
740: p_msg_level=>fnd_log.level_error);

Line 740: p_msg_level=>fnd_log.level_error);

736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
738: p_msg_data=>x_msg_data,
739: p_msg_type=>'ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
744: p_prefix=>l_debug_prefix,

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

738: p_msg_data=>x_msg_data,
739: p_msg_type=>'ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;

Line 745: p_msg_level=>fnd_log.level_procedure);

741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747: WHEN fnd_api.g_exc_unexpected_error THEN
748: ROLLBACK TO create_credit_ratings_pub;
749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

756: p_count => x_msg_count,
757: p_data => x_msg_data);
758:
759: -- Debug info.
760: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
761: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
762: p_msg_data=>x_msg_data,
763: p_msg_type=>'UNEXPECTED ERROR',
764: p_msg_level=>fnd_log.level_error);

Line 764: p_msg_level=>fnd_log.level_error);

760: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
761: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
762: p_msg_data=>x_msg_data,
763: p_msg_type=>'UNEXPECTED ERROR',
764: p_msg_level=>fnd_log.level_error);
765: END IF;
766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
768: p_prefix=>l_debug_prefix,

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

762: p_msg_data=>x_msg_data,
763: p_msg_type=>'UNEXPECTED ERROR',
764: p_msg_level=>fnd_log.level_error);
765: END IF;
766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
768: p_prefix=>l_debug_prefix,
769: p_msg_level=>fnd_log.level_procedure);
770: END IF;

Line 769: p_msg_level=>fnd_log.level_procedure);

765: END IF;
766: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
768: p_prefix=>l_debug_prefix,
769: p_msg_level=>fnd_log.level_procedure);
770: END IF;
771: WHEN OTHERS THEN
772: ROLLBACK TO create_credit_ratings_pub;
773: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

784: p_count => x_msg_count,
785: p_data => x_msg_data);
786:
787: -- Debug info.
788: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
789: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
790: p_msg_data=>x_msg_data,
791: p_msg_type=>'SQL ERROR',
792: p_msg_level=>fnd_log.level_error);

Line 792: p_msg_level=>fnd_log.level_error);

788: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
789: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
790: p_msg_data=>x_msg_data,
791: p_msg_type=>'SQL ERROR',
792: p_msg_level=>fnd_log.level_error);
793: END IF;
794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
796: p_prefix=>l_debug_prefix,

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

790: p_msg_data=>x_msg_data,
791: p_msg_type=>'SQL ERROR',
792: p_msg_level=>fnd_log.level_error);
793: END IF;
794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
796: p_prefix=>l_debug_prefix,
797: p_msg_level=>fnd_log.level_procedure);
798: END IF;

Line 797: p_msg_level=>fnd_log.level_procedure);

793: END IF;
794: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
795: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',
796: p_prefix=>l_debug_prefix,
797: p_msg_level=>fnd_log.level_procedure);
798: END IF;
799: END create_credit_ratings;
800:
801: -- PRIVATE PROCEDURE save_credit_ratings

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

841: -- initialize API return status to success.
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: -- Debug info.
845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(+)',
847: p_prefix=>l_debug_prefix,
848: p_msg_level=>fnd_log.level_procedure);
849: END IF;

Line 848: p_msg_level=>fnd_log.level_procedure);

844: -- Debug info.
845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
846: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(+)',
847: p_prefix=>l_debug_prefix,
848: p_msg_level=>fnd_log.level_procedure);
849: END IF;
850: --------------------------------
851: -- Create/Update credit rating
852: --------------------------------

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

865: x_object_version_number => l_ovn
866: );
867:
868: IF(l_ovn = -1) THEN
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
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: IF(l_ovn = -1) THEN
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'Save Credit Ratings - Error occurred at hz_organization_bo_pub.check_credit_rating_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
875: FND_MSG_PUB.ADD;
876: RAISE FND_API.G_EXC_ERROR;

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

902: p_credit_rating_objs(i).credit_rating_id := l_credit_rating_rec.credit_rating_id;
903: END IF;
904:
905: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
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: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: END LOOP;

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

912: END IF;
913: END LOOP;
914:
915: -- Debug info.
916: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
918: p_msg_data=>x_msg_data,
919: p_msg_type=>'WARNING',
920: p_msg_level=>fnd_log.level_exception);

Line 920: p_msg_level=>fnd_log.level_exception);

916: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
918: p_msg_data=>x_msg_data,
919: p_msg_type=>'WARNING',
920: p_msg_level=>fnd_log.level_exception);
921: END IF;
922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
923: hz_utility_v2pub.debug(p_message=>'save_credit_rating(-)',
924: p_prefix=>l_debug_prefix,

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

918: p_msg_data=>x_msg_data,
919: p_msg_type=>'WARNING',
920: p_msg_level=>fnd_log.level_exception);
921: END IF;
922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
923: hz_utility_v2pub.debug(p_message=>'save_credit_rating(-)',
924: p_prefix=>l_debug_prefix,
925: p_msg_level=>fnd_log.level_procedure);
926: END IF;

Line 925: p_msg_level=>fnd_log.level_procedure);

921: END IF;
922: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
923: hz_utility_v2pub.debug(p_message=>'save_credit_rating(-)',
924: p_prefix=>l_debug_prefix,
925: p_msg_level=>fnd_log.level_procedure);
926: END IF;
927: EXCEPTION
928: WHEN fnd_api.g_exc_error THEN
929: ROLLBACK TO save_credit_ratings_pub;

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

937: p_count => x_msg_count,
938: p_data => x_msg_data);
939:
940: -- Debug info.
941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
943: p_msg_data=>x_msg_data,
944: p_msg_type=>'ERROR',
945: p_msg_level=>fnd_log.level_error);

Line 945: p_msg_level=>fnd_log.level_error);

941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
943: p_msg_data=>x_msg_data,
944: p_msg_type=>'ERROR',
945: p_msg_level=>fnd_log.level_error);
946: END IF;
947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
949: p_prefix=>l_debug_prefix,

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

943: p_msg_data=>x_msg_data,
944: p_msg_type=>'ERROR',
945: p_msg_level=>fnd_log.level_error);
946: END IF;
947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
949: p_prefix=>l_debug_prefix,
950: p_msg_level=>fnd_log.level_procedure);
951: END IF;

Line 950: p_msg_level=>fnd_log.level_procedure);

946: END IF;
947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
949: p_prefix=>l_debug_prefix,
950: p_msg_level=>fnd_log.level_procedure);
951: END IF;
952: WHEN fnd_api.g_exc_unexpected_error THEN
953: ROLLBACK TO save_credit_ratings_pub;
954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

961: p_count => x_msg_count,
962: p_data => x_msg_data);
963:
964: -- Debug info.
965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
967: p_msg_data=>x_msg_data,
968: p_msg_type=>'UNEXPECTED ERROR',
969: p_msg_level=>fnd_log.level_error);

Line 969: p_msg_level=>fnd_log.level_error);

965: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
966: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
967: p_msg_data=>x_msg_data,
968: p_msg_type=>'UNEXPECTED ERROR',
969: p_msg_level=>fnd_log.level_error);
970: END IF;
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
973: p_prefix=>l_debug_prefix,

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

967: p_msg_data=>x_msg_data,
968: p_msg_type=>'UNEXPECTED ERROR',
969: p_msg_level=>fnd_log.level_error);
970: END IF;
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
973: p_prefix=>l_debug_prefix,
974: p_msg_level=>fnd_log.level_procedure);
975: END IF;

Line 974: p_msg_level=>fnd_log.level_procedure);

970: END IF;
971: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
973: p_prefix=>l_debug_prefix,
974: p_msg_level=>fnd_log.level_procedure);
975: END IF;
976: WHEN OTHERS THEN
977: ROLLBACK TO save_credit_ratings_pub;
978: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

989: p_count => x_msg_count,
990: p_data => x_msg_data);
991:
992: -- Debug info.
993: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
994: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
995: p_msg_data=>x_msg_data,
996: p_msg_type=>'SQL ERROR',
997: p_msg_level=>fnd_log.level_error);

Line 997: p_msg_level=>fnd_log.level_error);

993: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
994: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
995: p_msg_data=>x_msg_data,
996: p_msg_type=>'SQL ERROR',
997: p_msg_level=>fnd_log.level_error);
998: END IF;
999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1000: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
1001: p_prefix=>l_debug_prefix,

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

995: p_msg_data=>x_msg_data,
996: p_msg_type=>'SQL ERROR',
997: p_msg_level=>fnd_log.level_error);
998: END IF;
999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1000: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
1001: p_prefix=>l_debug_prefix,
1002: p_msg_level=>fnd_log.level_procedure);
1003: END IF;

Line 1002: p_msg_level=>fnd_log.level_procedure);

998: END IF;
999: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1000: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',
1001: p_prefix=>l_debug_prefix,
1002: p_msg_level=>fnd_log.level_procedure);
1003: END IF;
1004: END save_credit_ratings;
1005:
1006: -- PRIVATE PROCEDURE create_financial_reports

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

1026: -- initialize API return status to success.
1027: x_return_status := FND_API.G_RET_STS_SUCCESS;
1028:
1029: -- Debug info.
1030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'create_financial_reports(+)',
1032: p_prefix=>l_debug_prefix,
1033: p_msg_level=>fnd_log.level_procedure);
1034: END IF;

Line 1033: p_msg_level=>fnd_log.level_procedure);

1029: -- Debug info.
1030: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'create_financial_reports(+)',
1032: p_prefix=>l_debug_prefix,
1033: p_msg_level=>fnd_log.level_procedure);
1034: END IF;
1035:
1036: ---------------------------------
1037: -- Assign financial report record

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

1051: x_msg_data => x_msg_data
1052: );
1053:
1054: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;

Line 1058: p_msg_level=>fnd_log.level_procedure);

1054: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1055: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,
1057: p_prefix=>l_debug_prefix,
1058: p_msg_level=>fnd_log.level_procedure);
1059: END IF;
1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1061: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1062: FND_MSG_PUB.ADD;

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

1086: x_msg_data => x_msg_data
1087: );
1088:
1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;

Line 1093: p_msg_level=>fnd_log.level_procedure);

1089: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1090: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,
1092: p_prefix=>l_debug_prefix,
1093: p_msg_level=>fnd_log.level_procedure);
1094: END IF;
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1097: FND_MSG_PUB.ADD;

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

1105: END IF;
1106: END LOOP;
1107:
1108: -- Debug info.
1109: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'WARNING',
1113: p_msg_level=>fnd_log.level_exception);

Line 1113: p_msg_level=>fnd_log.level_exception);

1109: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'WARNING',
1113: p_msg_level=>fnd_log.level_exception);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1117: p_prefix=>l_debug_prefix,

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

1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'WARNING',
1113: p_msg_level=>fnd_log.level_exception);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;

Line 1118: p_msg_level=>fnd_log.level_procedure);

1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: EXCEPTION
1121: WHEN fnd_api.g_exc_error THEN
1122: ROLLBACK TO create_financial_reports_pub;

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

1126: p_count => x_msg_count,
1127: p_data => x_msg_data);
1128:
1129: -- Debug info.
1130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);

Line 1134: p_msg_level=>fnd_log.level_error);

1130: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1131: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1138: p_prefix=>l_debug_prefix,

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

1132: p_msg_data=>x_msg_data,
1133: p_msg_type=>'ERROR',
1134: p_msg_level=>fnd_log.level_error);
1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;

Line 1139: p_msg_level=>fnd_log.level_procedure);

1135: END IF;
1136: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1138: p_prefix=>l_debug_prefix,
1139: p_msg_level=>fnd_log.level_procedure);
1140: END IF;
1141: WHEN fnd_api.g_exc_unexpected_error THEN
1142: ROLLBACK TO create_financial_reports_pub;
1143: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1146: p_count => x_msg_count,
1147: p_data => x_msg_data);
1148:
1149: -- Debug info.
1150: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1151: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1152: p_msg_data=>x_msg_data,
1153: p_msg_type=>'UNEXPECTED ERROR',
1154: p_msg_level=>fnd_log.level_error);

Line 1154: p_msg_level=>fnd_log.level_error);

1150: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1151: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1152: p_msg_data=>x_msg_data,
1153: p_msg_type=>'UNEXPECTED ERROR',
1154: p_msg_level=>fnd_log.level_error);
1155: END IF;
1156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1157: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1158: p_prefix=>l_debug_prefix,

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

1152: p_msg_data=>x_msg_data,
1153: p_msg_type=>'UNEXPECTED ERROR',
1154: p_msg_level=>fnd_log.level_error);
1155: END IF;
1156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1157: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1158: p_prefix=>l_debug_prefix,
1159: p_msg_level=>fnd_log.level_procedure);
1160: END IF;

Line 1159: p_msg_level=>fnd_log.level_procedure);

1155: END IF;
1156: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1157: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1158: p_prefix=>l_debug_prefix,
1159: p_msg_level=>fnd_log.level_procedure);
1160: END IF;
1161: WHEN OTHERS THEN
1162: ROLLBACK TO create_financial_reports_pub;
1163: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 1178: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1183: p_msg_level=>fnd_log.level_procedure);

1179: END IF;
1180: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1181: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',
1182: p_prefix=>l_debug_prefix,
1183: p_msg_level=>fnd_log.level_procedure);
1184: END IF;
1185: END create_financial_reports;
1186:
1187: -- PRIVATE PROCEDURE save_financial_reports

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

1208: -- initialize API return status to success.
1209: x_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: -- Debug info.
1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug(p_message=>'save_financial_reports(+)',
1214: p_prefix=>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;

Line 1215: p_msg_level=>fnd_log.level_procedure);

1211: -- Debug info.
1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug(p_message=>'save_financial_reports(+)',
1214: p_prefix=>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;
1217:
1218: -----------------------------------
1219: -- Create/Update financial reports

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

1235: x_object_version_number => l_ovn
1236: );
1237:
1238: IF(l_ovn = -1) THEN
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1241: p_prefix=>l_debug_prefix,
1242: p_msg_level=>fnd_log.level_procedure);
1243: END IF;

Line 1242: p_msg_level=>fnd_log.level_procedure);

1238: IF(l_ovn = -1) THEN
1239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug(p_message=>'Save Financial Report - Error occurred at hz_organization_bo_pub.check_fin_report_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1241: p_prefix=>l_debug_prefix,
1242: p_msg_level=>fnd_log.level_procedure);
1243: END IF;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
1245: FND_MSG_PUB.ADD;
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

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

1276: p_fin_objs(i).financial_report_id := l_dummy_id;
1277: END IF;
1278:
1279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,
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: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_id,
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
1284: END IF;
1285: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');
1286: FND_MESSAGE.SET_TOKEN('STRUCTURE', 'HZ_FINANCIAL_REPORTS');
1287: FND_MSG_PUB.ADD;

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

1306: x_object_version_number => l_ovn
1307: );
1308:
1309: IF(l_ovn = -1) THEN
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;

Line 1313: p_msg_level=>fnd_log.level_procedure);

1309: IF(l_ovn = -1) THEN
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'Save Financial Number - Error occurred at hz_organization_bo_pub.check_fin_number_op, organization id: '||p_organization_id||' '||' ovn:'||l_ovn,
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
1316: FND_MSG_PUB.ADD;
1317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

1345: -- assign financial_number_id
1346: p_fin_objs(i).financial_number_objs(j).financial_number_id := l_fin_number_rec.financial_number_id;
1347: END IF;
1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;

Line 1352: p_msg_level=>fnd_log.level_procedure);

1348: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1349: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_id,
1351: p_prefix=>l_debug_prefix,
1352: p_msg_level=>fnd_log.level_procedure);
1353: END IF;
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1355: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_NUMBERS');
1356: FND_MSG_PUB.ADD;

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

1361: END IF;
1362: END LOOP;
1363:
1364: -- Debug info.
1365: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1366: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1367: p_msg_data=>x_msg_data,
1368: p_msg_type=>'WARNING',
1369: p_msg_level=>fnd_log.level_exception);

Line 1369: p_msg_level=>fnd_log.level_exception);

1365: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1366: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1367: p_msg_data=>x_msg_data,
1368: p_msg_type=>'WARNING',
1369: p_msg_level=>fnd_log.level_exception);
1370: END IF;
1371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1372: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1373: p_prefix=>l_debug_prefix,

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

1367: p_msg_data=>x_msg_data,
1368: p_msg_type=>'WARNING',
1369: p_msg_level=>fnd_log.level_exception);
1370: END IF;
1371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1372: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1373: p_prefix=>l_debug_prefix,
1374: p_msg_level=>fnd_log.level_procedure);
1375: END IF;

Line 1374: p_msg_level=>fnd_log.level_procedure);

1370: END IF;
1371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1372: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1373: p_prefix=>l_debug_prefix,
1374: p_msg_level=>fnd_log.level_procedure);
1375: END IF;
1376: EXCEPTION
1377: WHEN fnd_api.g_exc_error THEN
1378: ROLLBACK TO save_financial_reports_pub;

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

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

Line 1390: p_msg_level=>fnd_log.level_error);

1386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'ERROR',
1390: p_msg_level=>fnd_log.level_error);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1394: p_prefix=>l_debug_prefix,

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

1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'ERROR',
1390: p_msg_level=>fnd_log.level_error);
1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1394: p_prefix=>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;

Line 1395: p_msg_level=>fnd_log.level_procedure);

1391: END IF;
1392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1394: p_prefix=>l_debug_prefix,
1395: p_msg_level=>fnd_log.level_procedure);
1396: END IF;
1397: WHEN fnd_api.g_exc_unexpected_error THEN
1398: ROLLBACK TO save_financial_reports_pub;
1399: x_return_status := fnd_api.g_ret_sts_unexp_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_financial_reports(-)',
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_financial_reports(-)',
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_financial_reports(-)',
1414: p_prefix=>l_debug_prefix,
1415: p_msg_level=>fnd_log.level_procedure);
1416: END IF;
1417: WHEN OTHERS THEN
1418: ROLLBACK TO save_financial_reports_pub;
1419: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1426: p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: -- Debug info.
1430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'SQL ERROR',
1434: p_msg_level=>fnd_log.level_error);

Line 1434: p_msg_level=>fnd_log.level_error);

1430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'SQL ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1438: p_prefix=>l_debug_prefix,

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

1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'SQL ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;

Line 1439: p_msg_level=>fnd_log.level_procedure);

1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;
1441: END save_financial_reports;
1442:
1443: -- PROCEDURE do_create_organization_bo

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

1489: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1490: END IF;
1491:
1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;

Line 1496: p_msg_level=>fnd_log.level_procedure);

1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:
1499: -- Base on p_validate_bo_flag to check completeness of business object
1500: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

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

1859: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1860: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1861:
1862: -- Debug info.
1863: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1865: p_msg_data=>x_msg_data,
1866: p_msg_type=>'WARNING',
1867: p_msg_level=>fnd_log.level_exception);

Line 1867: p_msg_level=>fnd_log.level_exception);

1863: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1865: p_msg_data=>x_msg_data,
1866: p_msg_type=>'WARNING',
1867: p_msg_level=>fnd_log.level_exception);
1868: END IF;
1869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1870: hz_utility_v2pub.debug(p_message=>'create_organization_bo(-)',
1871: p_prefix=>l_debug_prefix,

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

1865: p_msg_data=>x_msg_data,
1866: p_msg_type=>'WARNING',
1867: p_msg_level=>fnd_log.level_exception);
1868: END IF;
1869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1870: hz_utility_v2pub.debug(p_message=>'create_organization_bo(-)',
1871: p_prefix=>l_debug_prefix,
1872: p_msg_level=>fnd_log.level_procedure);
1873: END IF;

Line 1872: p_msg_level=>fnd_log.level_procedure);

1868: END IF;
1869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1870: hz_utility_v2pub.debug(p_message=>'create_organization_bo(-)',
1871: p_prefix=>l_debug_prefix,
1872: p_msg_level=>fnd_log.level_procedure);
1873: END IF;
1874:
1875: EXCEPTION
1876: WHEN fnd_api.g_exc_error THEN

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

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

Line 1898: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1903: p_msg_level=>fnd_log.level_procedure);

1899: END IF;
1900: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1901: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
1902: p_prefix=>l_debug_prefix,
1903: p_msg_level=>fnd_log.level_procedure);
1904: END IF;
1905:
1906: WHEN fnd_api.g_exc_unexpected_error THEN
1907: ROLLBACK TO do_create_organization_bo_pub;

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

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

Line 1928: p_msg_level=>fnd_log.level_error);

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

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

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

Line 1933: p_msg_level=>fnd_log.level_procedure);

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

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

1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: -- Debug info.
1958: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1959: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1960: p_msg_data=>x_msg_data,
1961: p_msg_type=>'SQL ERROR',
1962: p_msg_level=>fnd_log.level_error);

Line 1962: p_msg_level=>fnd_log.level_error);

1958: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1959: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1960: p_msg_data=>x_msg_data,
1961: p_msg_type=>'SQL ERROR',
1962: p_msg_level=>fnd_log.level_error);
1963: END IF;
1964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1965: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
1966: p_prefix=>l_debug_prefix,

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

1960: p_msg_data=>x_msg_data,
1961: p_msg_type=>'SQL ERROR',
1962: p_msg_level=>fnd_log.level_error);
1963: END IF;
1964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1965: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
1966: p_prefix=>l_debug_prefix,
1967: p_msg_level=>fnd_log.level_procedure);
1968: END IF;

Line 1967: p_msg_level=>fnd_log.level_procedure);

1963: END IF;
1964: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1965: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',
1966: p_prefix=>l_debug_prefix,
1967: p_msg_level=>fnd_log.level_procedure);
1968: END IF;
1969: END do_create_organization_bo;
1970:
1971: PROCEDURE create_organization_bo(

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

2096: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2097: END IF;
2098:
2099: -- Debug info.
2100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug(p_message=>'update_organization_bo(+)',
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=>'update_organization_bo(+)',
2102: p_prefix=>l_debug_prefix,
2103: p_msg_level=>fnd_log.level_procedure);
2104: END IF;
2105:
2106: x_organization_id := p_organization_obj.organization_id;
2107: x_organization_os := p_organization_obj.orig_system;

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

2489: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2490: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2491:
2492: -- Debug info.
2493: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2495: p_msg_data=>x_msg_data,
2496: p_msg_type=>'WARNING',
2497: p_msg_level=>fnd_log.level_exception);

Line 2497: p_msg_level=>fnd_log.level_exception);

2493: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2495: p_msg_data=>x_msg_data,
2496: p_msg_type=>'WARNING',
2497: p_msg_level=>fnd_log.level_exception);
2498: END IF;
2499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2501: p_prefix=>l_debug_prefix,

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

2495: p_msg_data=>x_msg_data,
2496: p_msg_type=>'WARNING',
2497: p_msg_level=>fnd_log.level_exception);
2498: END IF;
2499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2501: p_prefix=>l_debug_prefix,
2502: p_msg_level=>fnd_log.level_procedure);
2503: END IF;

Line 2502: p_msg_level=>fnd_log.level_procedure);

2498: END IF;
2499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2500: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2501: p_prefix=>l_debug_prefix,
2502: p_msg_level=>fnd_log.level_procedure);
2503: END IF;
2504: EXCEPTION
2505: WHEN fnd_api.g_exc_error THEN
2506: ROLLBACK TO do_update_organization_bo_pub;

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

2519: p_count => x_msg_count,
2520: p_data => x_msg_data);
2521:
2522: -- Debug info.
2523: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2524: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2525: p_msg_data=>x_msg_data,
2526: p_msg_type=>'ERROR',
2527: p_msg_level=>fnd_log.level_error);

Line 2527: p_msg_level=>fnd_log.level_error);

2523: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2524: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2525: p_msg_data=>x_msg_data,
2526: p_msg_type=>'ERROR',
2527: p_msg_level=>fnd_log.level_error);
2528: END IF;
2529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2530: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2531: p_prefix=>l_debug_prefix,

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

2525: p_msg_data=>x_msg_data,
2526: p_msg_type=>'ERROR',
2527: p_msg_level=>fnd_log.level_error);
2528: END IF;
2529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2530: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2531: p_prefix=>l_debug_prefix,
2532: p_msg_level=>fnd_log.level_procedure);
2533: END IF;

Line 2532: p_msg_level=>fnd_log.level_procedure);

2528: END IF;
2529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2530: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2531: p_prefix=>l_debug_prefix,
2532: p_msg_level=>fnd_log.level_procedure);
2533: END IF;
2534:
2535:
2536: WHEN fnd_api.g_exc_unexpected_error THEN

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

2550: p_count => x_msg_count,
2551: p_data => x_msg_data);
2552:
2553: -- Debug info.
2554: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'UNEXPECTED ERROR',
2558: p_msg_level=>fnd_log.level_error);

Line 2558: p_msg_level=>fnd_log.level_error);

2554: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2555: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'UNEXPECTED ERROR',
2558: p_msg_level=>fnd_log.level_error);
2559: END IF;
2560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2561: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2562: p_prefix=>l_debug_prefix,

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

2556: p_msg_data=>x_msg_data,
2557: p_msg_type=>'UNEXPECTED ERROR',
2558: p_msg_level=>fnd_log.level_error);
2559: END IF;
2560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2561: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2562: p_prefix=>l_debug_prefix,
2563: p_msg_level=>fnd_log.level_procedure);
2564: END IF;

Line 2563: p_msg_level=>fnd_log.level_procedure);

2559: END IF;
2560: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2561: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2562: p_prefix=>l_debug_prefix,
2563: p_msg_level=>fnd_log.level_procedure);
2564: END IF;
2565: WHEN OTHERS THEN
2566: ROLLBACK TO do_update_organization_bo_pub;
2567:

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

2583: p_count => x_msg_count,
2584: p_data => x_msg_data);
2585:
2586: -- Debug info.
2587: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2588: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2589: p_msg_data=>x_msg_data,
2590: p_msg_type=>'SQL ERROR',
2591: p_msg_level=>fnd_log.level_error);

Line 2591: p_msg_level=>fnd_log.level_error);

2587: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2588: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2589: p_msg_data=>x_msg_data,
2590: p_msg_type=>'SQL ERROR',
2591: p_msg_level=>fnd_log.level_error);
2592: END IF;
2593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2594: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2595: p_prefix=>l_debug_prefix,

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

2589: p_msg_data=>x_msg_data,
2590: p_msg_type=>'SQL ERROR',
2591: p_msg_level=>fnd_log.level_error);
2592: END IF;
2593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2594: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2595: p_prefix=>l_debug_prefix,
2596: p_msg_level=>fnd_log.level_procedure);
2597: END IF;

Line 2596: p_msg_level=>fnd_log.level_procedure);

2592: END IF;
2593: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2594: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',
2595: p_prefix=>l_debug_prefix,
2596: p_msg_level=>fnd_log.level_procedure);
2597: END IF;
2598: END do_update_organization_bo;
2599:
2600: PROCEDURE update_organization_bo(

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

2694: FND_MSG_PUB.initialize;
2695: END IF;
2696:
2697: -- Debug info.
2698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2699: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(+)',
2700: p_prefix=>l_debug_prefix,
2701: p_msg_level=>fnd_log.level_procedure);
2702: END IF;

Line 2701: p_msg_level=>fnd_log.level_procedure);

2697: -- Debug info.
2698: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2699: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(+)',
2700: p_prefix=>l_debug_prefix,
2701: p_msg_level=>fnd_log.level_procedure);
2702: END IF;
2703:
2704: x_organization_id := p_organization_obj.organization_id;
2705: x_organization_os := p_organization_obj.orig_system;

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

2759: RAISE FND_API.G_EXC_ERROR;
2760: END IF;
2761:
2762: -- Debug info.
2763: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2764: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'WARNING',
2767: p_msg_level=>fnd_log.level_exception);

Line 2767: p_msg_level=>fnd_log.level_exception);

2763: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2764: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'WARNING',
2767: p_msg_level=>fnd_log.level_exception);
2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2771: p_prefix=>l_debug_prefix,

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

2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'WARNING',
2767: p_msg_level=>fnd_log.level_exception);
2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;

Line 2772: p_msg_level=>fnd_log.level_procedure);

2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;
2774: EXCEPTION
2775: WHEN fnd_api.g_exc_error THEN
2776: x_return_status := fnd_api.g_ret_sts_error;

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

2779: p_count => x_msg_count,
2780: p_data => x_msg_data);
2781:
2782: -- Debug info.
2783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'ERROR',
2787: p_msg_level=>fnd_log.level_error);

Line 2787: p_msg_level=>fnd_log.level_error);

2783: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2784: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'ERROR',
2787: p_msg_level=>fnd_log.level_error);
2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2791: p_prefix=>l_debug_prefix,

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

2785: p_msg_data=>x_msg_data,
2786: p_msg_type=>'ERROR',
2787: p_msg_level=>fnd_log.level_error);
2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2791: p_prefix=>l_debug_prefix,
2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;

Line 2792: p_msg_level=>fnd_log.level_procedure);

2788: END IF;
2789: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2790: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2791: p_prefix=>l_debug_prefix,
2792: p_msg_level=>fnd_log.level_procedure);
2793: END IF;
2794:
2795: WHEN fnd_api.g_exc_unexpected_error THEN
2796: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

Line 2807: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2812: p_msg_level=>fnd_log.level_procedure);

2808: END IF;
2809: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2810: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2811: p_prefix=>l_debug_prefix,
2812: p_msg_level=>fnd_log.level_procedure);
2813: END IF;
2814: WHEN OTHERS THEN
2815: x_return_status := fnd_api.g_ret_sts_unexp_error;
2816:

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

2822: p_count => x_msg_count,
2823: p_data => x_msg_data);
2824:
2825: -- Debug info.
2826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2828: p_msg_data=>x_msg_data,
2829: p_msg_type=>'SQL ERROR',
2830: p_msg_level=>fnd_log.level_error);

Line 2830: p_msg_level=>fnd_log.level_error);

2826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2828: p_msg_data=>x_msg_data,
2829: p_msg_type=>'SQL ERROR',
2830: p_msg_level=>fnd_log.level_error);
2831: END IF;
2832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2833: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2834: p_prefix=>l_debug_prefix,

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

2828: p_msg_data=>x_msg_data,
2829: p_msg_type=>'SQL ERROR',
2830: p_msg_level=>fnd_log.level_error);
2831: END IF;
2832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2833: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2834: p_prefix=>l_debug_prefix,
2835: p_msg_level=>fnd_log.level_procedure);
2836: END IF;

Line 2835: p_msg_level=>fnd_log.level_procedure);

2831: END IF;
2832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2833: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',
2834: p_prefix=>l_debug_prefix,
2835: p_msg_level=>fnd_log.level_procedure);
2836: END IF;
2837: END do_save_organization_bo;
2838:
2839: PROCEDURE save_organization_bo(

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

3003: END IF;
3004:
3005:
3006: -- Debug info.
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;

Line 3010: p_msg_level=>fnd_log.level_procedure);

3006: -- Debug info.
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;
3012:
3013: -- check if pass in contact_point_id and/or os+osr
3014: -- extraction validation logic is same as update

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

3044: END IF;
3045:
3046:
3047: -- Debug info.
3048: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3050: p_msg_data=>x_msg_data,
3051: p_msg_type=>'WARNING',
3052: p_msg_level=>fnd_log.level_exception);

Line 3052: p_msg_level=>fnd_log.level_exception);

3048: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3049: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3050: p_msg_data=>x_msg_data,
3051: p_msg_type=>'WARNING',
3052: p_msg_level=>fnd_log.level_exception);
3053: END IF;
3054:
3055: -- Debug info.
3056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3052: p_msg_level=>fnd_log.level_exception);
3053: END IF;
3054:
3055: -- Debug info.
3056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3057: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3058: p_prefix=>l_debug_prefix,
3059: p_msg_level=>fnd_log.level_procedure);
3060: END IF;

Line 3059: p_msg_level=>fnd_log.level_procedure);

3055: -- Debug info.
3056: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3057: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3058: p_prefix=>l_debug_prefix,
3059: p_msg_level=>fnd_log.level_procedure);
3060: END IF;
3061:
3062:
3063: EXCEPTION

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

3069: p_count => x_msg_count,
3070: p_data => x_msg_data);
3071:
3072: -- Debug info.
3073: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3075: p_msg_data=>x_msg_data,
3076: p_msg_type=>'ERROR',
3077: p_msg_level=>fnd_log.level_error);

Line 3077: p_msg_level=>fnd_log.level_error);

3073: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3075: p_msg_data=>x_msg_data,
3076: p_msg_type=>'ERROR',
3077: p_msg_level=>fnd_log.level_error);
3078: END IF;
3079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3081: p_prefix=>l_debug_prefix,

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

3075: p_msg_data=>x_msg_data,
3076: p_msg_type=>'ERROR',
3077: p_msg_level=>fnd_log.level_error);
3078: END IF;
3079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3081: p_prefix=>l_debug_prefix,
3082: p_msg_level=>fnd_log.level_procedure);
3083: END IF;

Line 3082: p_msg_level=>fnd_log.level_procedure);

3078: END IF;
3079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3081: p_prefix=>l_debug_prefix,
3082: p_msg_level=>fnd_log.level_procedure);
3083: END IF;
3084: WHEN fnd_api.g_exc_unexpected_error THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086:

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

3088: p_count => x_msg_count,
3089: p_data => x_msg_data);
3090:
3091: -- Debug info.
3092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3094: p_msg_data=>x_msg_data,
3095: p_msg_type=>'UNEXPECTED ERROR',
3096: p_msg_level=>fnd_log.level_error);

Line 3096: p_msg_level=>fnd_log.level_error);

3092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3094: p_msg_data=>x_msg_data,
3095: p_msg_type=>'UNEXPECTED ERROR',
3096: p_msg_level=>fnd_log.level_error);
3097: END IF;
3098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3099: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3100: p_prefix=>l_debug_prefix,

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

3094: p_msg_data=>x_msg_data,
3095: p_msg_type=>'UNEXPECTED ERROR',
3096: p_msg_level=>fnd_log.level_error);
3097: END IF;
3098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3099: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3100: p_prefix=>l_debug_prefix,
3101: p_msg_level=>fnd_log.level_procedure);
3102: END IF;

Line 3101: p_msg_level=>fnd_log.level_procedure);

3097: END IF;
3098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3099: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3100: p_prefix=>l_debug_prefix,
3101: p_msg_level=>fnd_log.level_procedure);
3102: END IF;
3103: WHEN OTHERS THEN
3104: x_return_status := fnd_api.g_ret_sts_unexp_error;
3105:

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

3111: p_count => x_msg_count,
3112: p_data => x_msg_data);
3113:
3114: -- Debug info.
3115: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3117: p_msg_data=>x_msg_data,
3118: p_msg_type=>'SQL ERROR',
3119: p_msg_level=>fnd_log.level_error);

Line 3119: p_msg_level=>fnd_log.level_error);

3115: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3116: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3117: p_msg_data=>x_msg_data,
3118: p_msg_type=>'SQL ERROR',
3119: p_msg_level=>fnd_log.level_error);
3120: END IF;
3121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3123: p_prefix=>l_debug_prefix,

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

3117: p_msg_data=>x_msg_data,
3118: p_msg_type=>'SQL ERROR',
3119: p_msg_level=>fnd_log.level_error);
3120: END IF;
3121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3123: p_prefix=>l_debug_prefix,
3124: p_msg_level=>fnd_log.level_procedure);
3125: END IF;

Line 3124: p_msg_level=>fnd_log.level_procedure);

3120: END IF;
3121: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',
3123: p_prefix=>l_debug_prefix,
3124: p_msg_level=>fnd_log.level_procedure);
3125: END IF;
3126:
3127: end;
3128:

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

3222: END IF;
3223:
3224:
3225: -- Debug info.
3226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3227: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',
3228: p_prefix=>l_debug_prefix,
3229: p_msg_level=>fnd_log.level_procedure);
3230: END IF;

Line 3229: p_msg_level=>fnd_log.level_procedure);

3225: -- Debug info.
3226: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3227: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',
3228: p_prefix=>l_debug_prefix,
3229: p_msg_level=>fnd_log.level_procedure);
3230: END IF;
3231:
3232: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3233: p_party_id => null,

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

3253:
3254:
3255:
3256: -- Debug info.
3257: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3258: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3259: p_msg_data=>x_msg_data,
3260: p_msg_type=>'WARNING',
3261: p_msg_level=>fnd_log.level_exception);

Line 3261: p_msg_level=>fnd_log.level_exception);

3257: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3258: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3259: p_msg_data=>x_msg_data,
3260: p_msg_type=>'WARNING',
3261: p_msg_level=>fnd_log.level_exception);
3262: END IF;
3263:
3264: -- Debug info.
3265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3261: p_msg_level=>fnd_log.level_exception);
3262: END IF;
3263:
3264: -- Debug info.
3265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3266: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',
3267: p_prefix=>l_debug_prefix,
3268: p_msg_level=>fnd_log.level_procedure);
3269: END IF;

Line 3268: p_msg_level=>fnd_log.level_procedure);

3264: -- Debug info.
3265: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3266: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',
3267: p_prefix=>l_debug_prefix,
3268: p_msg_level=>fnd_log.level_procedure);
3269: END IF;
3270:
3271:
3272: EXCEPTION

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

3278: p_count => x_msg_count,
3279: p_data => x_msg_data);
3280:
3281: -- Debug info.
3282: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3284: p_msg_data=>x_msg_data,
3285: p_msg_type=>'ERROR',
3286: p_msg_level=>fnd_log.level_error);

Line 3286: p_msg_level=>fnd_log.level_error);

3282: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3283: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3284: p_msg_data=>x_msg_data,
3285: p_msg_type=>'ERROR',
3286: p_msg_level=>fnd_log.level_error);
3287: END IF;
3288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3290: p_prefix=>l_debug_prefix,

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

3284: p_msg_data=>x_msg_data,
3285: p_msg_type=>'ERROR',
3286: p_msg_level=>fnd_log.level_error);
3287: END IF;
3288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3290: p_prefix=>l_debug_prefix,
3291: p_msg_level=>fnd_log.level_procedure);
3292: END IF;

Line 3291: p_msg_level=>fnd_log.level_procedure);

3287: END IF;
3288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3290: p_prefix=>l_debug_prefix,
3291: p_msg_level=>fnd_log.level_procedure);
3292: END IF;
3293: WHEN fnd_api.g_exc_unexpected_error THEN
3294: x_return_status := fnd_api.g_ret_sts_unexp_error;
3295:

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

3297: p_count => x_msg_count,
3298: p_data => x_msg_data);
3299:
3300: -- Debug info.
3301: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3302: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3303: p_msg_data=>x_msg_data,
3304: p_msg_type=>'UNEXPECTED ERROR',
3305: p_msg_level=>fnd_log.level_error);

Line 3305: p_msg_level=>fnd_log.level_error);

3301: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3302: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3303: p_msg_data=>x_msg_data,
3304: p_msg_type=>'UNEXPECTED ERROR',
3305: p_msg_level=>fnd_log.level_error);
3306: END IF;
3307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3308: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3309: p_prefix=>l_debug_prefix,

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

3303: p_msg_data=>x_msg_data,
3304: p_msg_type=>'UNEXPECTED ERROR',
3305: p_msg_level=>fnd_log.level_error);
3306: END IF;
3307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3308: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3309: p_prefix=>l_debug_prefix,
3310: p_msg_level=>fnd_log.level_procedure);
3311: END IF;

Line 3310: p_msg_level=>fnd_log.level_procedure);

3306: END IF;
3307: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3308: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3309: p_prefix=>l_debug_prefix,
3310: p_msg_level=>fnd_log.level_procedure);
3311: END IF;
3312: WHEN OTHERS THEN
3313: x_return_status := fnd_api.g_ret_sts_unexp_error;
3314:

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

3320: p_count => x_msg_count,
3321: p_data => x_msg_data);
3322:
3323: -- Debug info.
3324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3326: p_msg_data=>x_msg_data,
3327: p_msg_type=>'SQL ERROR',
3328: p_msg_level=>fnd_log.level_error);

Line 3328: p_msg_level=>fnd_log.level_error);

3324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3326: p_msg_data=>x_msg_data,
3327: p_msg_type=>'SQL ERROR',
3328: p_msg_level=>fnd_log.level_error);
3329: END IF;
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3332: p_prefix=>l_debug_prefix,

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

3326: p_msg_data=>x_msg_data,
3327: p_msg_type=>'SQL ERROR',
3328: p_msg_level=>fnd_log.level_error);
3329: END IF;
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3332: p_prefix=>l_debug_prefix,
3333: p_msg_level=>fnd_log.level_procedure);
3334: END IF;

Line 3333: p_msg_level=>fnd_log.level_procedure);

3329: END IF;
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',
3332: p_prefix=>l_debug_prefix,
3333: p_msg_level=>fnd_log.level_procedure);
3334: END IF;
3335:
3336: end;
3337:

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

3426: END IF;
3427:
3428:
3429: -- Debug info.
3430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3431: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',
3432: p_prefix=>l_debug_prefix,
3433: p_msg_level=>fnd_log.level_procedure);
3434: END IF;

Line 3433: p_msg_level=>fnd_log.level_procedure);

3429: -- Debug info.
3430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3431: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',
3432: p_prefix=>l_debug_prefix,
3433: p_msg_level=>fnd_log.level_procedure);
3434: END IF;
3435:
3436: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3437: p_party_id => null,

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

3457:
3458:
3459:
3460: -- Debug info.
3461: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3462: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3463: p_msg_data=>x_msg_data,
3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);

Line 3465: p_msg_level=>fnd_log.level_exception);

3461: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3462: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3463: p_msg_data=>x_msg_data,
3464: p_msg_type=>'WARNING',
3465: p_msg_level=>fnd_log.level_exception);
3466: END IF;
3467:
3468: -- Debug info.
3469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3465: p_msg_level=>fnd_log.level_exception);
3466: END IF;
3467:
3468: -- Debug info.
3469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3470: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',
3471: p_prefix=>l_debug_prefix,
3472: p_msg_level=>fnd_log.level_procedure);
3473: END IF;

Line 3472: p_msg_level=>fnd_log.level_procedure);

3468: -- Debug info.
3469: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3470: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',
3471: p_prefix=>l_debug_prefix,
3472: p_msg_level=>fnd_log.level_procedure);
3473: END IF;
3474:
3475:
3476: EXCEPTION

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

3482: p_count => x_msg_count,
3483: p_data => x_msg_data);
3484:
3485: -- Debug info.
3486: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3487: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);

Line 3490: p_msg_level=>fnd_log.level_error);

3486: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3487: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3494: p_prefix=>l_debug_prefix,

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

3488: p_msg_data=>x_msg_data,
3489: p_msg_type=>'ERROR',
3490: p_msg_level=>fnd_log.level_error);
3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;

Line 3495: p_msg_level=>fnd_log.level_procedure);

3491: END IF;
3492: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3494: p_prefix=>l_debug_prefix,
3495: p_msg_level=>fnd_log.level_procedure);
3496: END IF;
3497: WHEN fnd_api.g_exc_unexpected_error THEN
3498: x_return_status := fnd_api.g_ret_sts_unexp_error;
3499:

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

3501: p_count => x_msg_count,
3502: p_data => x_msg_data);
3503:
3504: -- Debug info.
3505: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3506: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3507: p_msg_data=>x_msg_data,
3508: p_msg_type=>'UNEXPECTED ERROR',
3509: p_msg_level=>fnd_log.level_error);

Line 3509: p_msg_level=>fnd_log.level_error);

3505: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3506: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3507: p_msg_data=>x_msg_data,
3508: p_msg_type=>'UNEXPECTED ERROR',
3509: p_msg_level=>fnd_log.level_error);
3510: END IF;
3511: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3512: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3513: p_prefix=>l_debug_prefix,

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

3507: p_msg_data=>x_msg_data,
3508: p_msg_type=>'UNEXPECTED ERROR',
3509: p_msg_level=>fnd_log.level_error);
3510: END IF;
3511: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3512: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3513: p_prefix=>l_debug_prefix,
3514: p_msg_level=>fnd_log.level_procedure);
3515: END IF;

Line 3514: p_msg_level=>fnd_log.level_procedure);

3510: END IF;
3511: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3512: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3513: p_prefix=>l_debug_prefix,
3514: p_msg_level=>fnd_log.level_procedure);
3515: END IF;
3516: WHEN OTHERS THEN
3517: x_return_status := fnd_api.g_ret_sts_unexp_error;
3518:

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

3524: p_count => x_msg_count,
3525: p_data => x_msg_data);
3526:
3527: -- Debug info.
3528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3530: p_msg_data=>x_msg_data,
3531: p_msg_type=>'SQL ERROR',
3532: p_msg_level=>fnd_log.level_error);

Line 3532: p_msg_level=>fnd_log.level_error);

3528: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3530: p_msg_data=>x_msg_data,
3531: p_msg_type=>'SQL ERROR',
3532: p_msg_level=>fnd_log.level_error);
3533: END IF;
3534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3535: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3536: p_prefix=>l_debug_prefix,

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

3530: p_msg_data=>x_msg_data,
3531: p_msg_type=>'SQL ERROR',
3532: p_msg_level=>fnd_log.level_error);
3533: END IF;
3534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3535: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3536: p_prefix=>l_debug_prefix,
3537: p_msg_level=>fnd_log.level_procedure);
3538: END IF;

Line 3537: p_msg_level=>fnd_log.level_procedure);

3533: END IF;
3534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3535: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',
3536: p_prefix=>l_debug_prefix,
3537: p_msg_level=>fnd_log.level_procedure);
3538: END IF;
3539:
3540: end;
3541:

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

3615: END IF;
3616:
3617:
3618: -- Debug info.
3619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',
3621: p_prefix=>l_debug_prefix,
3622: p_msg_level=>fnd_log.level_procedure);
3623: END IF;

Line 3622: p_msg_level=>fnd_log.level_procedure);

3618: -- Debug info.
3619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3620: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',
3621: p_prefix=>l_debug_prefix,
3622: p_msg_level=>fnd_log.level_procedure);
3623: END IF;
3624:
3625: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3626: p_party_id => p_organization_id,

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

3647:
3648:
3649:
3650: -- Debug info.
3651: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3652: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3653: p_msg_data=>x_msg_data,
3654: p_msg_type=>'WARNING',
3655: p_msg_level=>fnd_log.level_exception);

Line 3655: p_msg_level=>fnd_log.level_exception);

3651: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3652: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3653: p_msg_data=>x_msg_data,
3654: p_msg_type=>'WARNING',
3655: p_msg_level=>fnd_log.level_exception);
3656: END IF;
3657:
3658: -- Debug info.
3659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3655: p_msg_level=>fnd_log.level_exception);
3656: END IF;
3657:
3658: -- Debug info.
3659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3660: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',
3661: p_prefix=>l_debug_prefix,
3662: p_msg_level=>fnd_log.level_procedure);
3663: END IF;

Line 3662: p_msg_level=>fnd_log.level_procedure);

3658: -- Debug info.
3659: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3660: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',
3661: p_prefix=>l_debug_prefix,
3662: p_msg_level=>fnd_log.level_procedure);
3663: END IF;
3664:
3665:
3666: EXCEPTION

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

3672: p_count => x_msg_count,
3673: p_data => x_msg_data);
3674:
3675: -- Debug info.
3676: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3677: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3678: p_msg_data=>x_msg_data,
3679: p_msg_type=>'ERROR',
3680: p_msg_level=>fnd_log.level_error);

Line 3680: p_msg_level=>fnd_log.level_error);

3676: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3677: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3678: p_msg_data=>x_msg_data,
3679: p_msg_type=>'ERROR',
3680: p_msg_level=>fnd_log.level_error);
3681: END IF;
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3684: p_prefix=>l_debug_prefix,

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

3678: p_msg_data=>x_msg_data,
3679: p_msg_type=>'ERROR',
3680: p_msg_level=>fnd_log.level_error);
3681: END IF;
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;

Line 3685: p_msg_level=>fnd_log.level_procedure);

3681: END IF;
3682: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3684: p_prefix=>l_debug_prefix,
3685: p_msg_level=>fnd_log.level_procedure);
3686: END IF;
3687: WHEN fnd_api.g_exc_unexpected_error THEN
3688: x_return_status := fnd_api.g_ret_sts_unexp_error;
3689:

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

3691: p_count => x_msg_count,
3692: p_data => x_msg_data);
3693:
3694: -- Debug info.
3695: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3696: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3697: p_msg_data=>x_msg_data,
3698: p_msg_type=>'UNEXPECTED ERROR',
3699: p_msg_level=>fnd_log.level_error);

Line 3699: p_msg_level=>fnd_log.level_error);

3695: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3696: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3697: p_msg_data=>x_msg_data,
3698: p_msg_type=>'UNEXPECTED ERROR',
3699: p_msg_level=>fnd_log.level_error);
3700: END IF;
3701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3702: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3703: p_prefix=>l_debug_prefix,

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

3697: p_msg_data=>x_msg_data,
3698: p_msg_type=>'UNEXPECTED ERROR',
3699: p_msg_level=>fnd_log.level_error);
3700: END IF;
3701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3702: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3703: p_prefix=>l_debug_prefix,
3704: p_msg_level=>fnd_log.level_procedure);
3705: END IF;

Line 3704: p_msg_level=>fnd_log.level_procedure);

3700: END IF;
3701: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3702: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3703: p_prefix=>l_debug_prefix,
3704: p_msg_level=>fnd_log.level_procedure);
3705: END IF;
3706: WHEN OTHERS THEN
3707: x_return_status := fnd_api.g_ret_sts_unexp_error;
3708:

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

3714: p_count => x_msg_count,
3715: p_data => x_msg_data);
3716:
3717: -- Debug info.
3718: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3719: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3720: p_msg_data=>x_msg_data,
3721: p_msg_type=>'SQL ERROR',
3722: p_msg_level=>fnd_log.level_error);

Line 3722: p_msg_level=>fnd_log.level_error);

3718: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3719: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3720: p_msg_data=>x_msg_data,
3721: p_msg_type=>'SQL ERROR',
3722: p_msg_level=>fnd_log.level_error);
3723: END IF;
3724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3725: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3726: p_prefix=>l_debug_prefix,

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

3720: p_msg_data=>x_msg_data,
3721: p_msg_type=>'SQL ERROR',
3722: p_msg_level=>fnd_log.level_error);
3723: END IF;
3724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3725: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3726: p_prefix=>l_debug_prefix,
3727: p_msg_level=>fnd_log.level_procedure);
3728: END IF;

Line 3727: p_msg_level=>fnd_log.level_procedure);

3723: END IF;
3724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3725: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',
3726: p_prefix=>l_debug_prefix,
3727: p_msg_level=>fnd_log.level_procedure);
3728: END IF;
3729:
3730: end;
3731:

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

3777: END IF;
3778:
3779:
3780: -- Debug info.
3781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3782: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(+)',
3783: p_prefix=>l_debug_prefix,
3784: p_msg_level=>fnd_log.level_procedure);
3785: END IF;

Line 3784: p_msg_level=>fnd_log.level_procedure);

3780: -- Debug info.
3781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3782: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(+)',
3783: p_prefix=>l_debug_prefix,
3784: p_msg_level=>fnd_log.level_procedure);
3785: END IF;
3786:
3787: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3788: p_party_id => null,

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

3807: END IF;
3808:
3809:
3810: -- Debug info.
3811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3813: p_msg_data=>x_msg_data,
3814: p_msg_type=>'WARNING',
3815: p_msg_level=>fnd_log.level_exception);

Line 3815: p_msg_level=>fnd_log.level_exception);

3811: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3813: p_msg_data=>x_msg_data,
3814: p_msg_type=>'WARNING',
3815: p_msg_level=>fnd_log.level_exception);
3816: END IF;
3817:
3818: -- Debug info.
3819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3815: p_msg_level=>fnd_log.level_exception);
3816: END IF;
3817:
3818: -- Debug info.
3819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3820: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created (-)',
3821: p_prefix=>l_debug_prefix,
3822: p_msg_level=>fnd_log.level_procedure);
3823: END IF;

Line 3822: p_msg_level=>fnd_log.level_procedure);

3818: -- Debug info.
3819: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3820: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created (-)',
3821: p_prefix=>l_debug_prefix,
3822: p_msg_level=>fnd_log.level_procedure);
3823: END IF;
3824:
3825:
3826: EXCEPTION

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

3832: p_count => x_msg_count,
3833: p_data => x_msg_data);
3834:
3835: -- Debug info.
3836: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3837: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3838: p_msg_data=>x_msg_data,
3839: p_msg_type=>'ERROR',
3840: p_msg_level=>fnd_log.level_error);

Line 3840: p_msg_level=>fnd_log.level_error);

3836: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3837: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3838: p_msg_data=>x_msg_data,
3839: p_msg_type=>'ERROR',
3840: p_msg_level=>fnd_log.level_error);
3841: END IF;
3842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3843: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3844: p_prefix=>l_debug_prefix,

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

3838: p_msg_data=>x_msg_data,
3839: p_msg_type=>'ERROR',
3840: p_msg_level=>fnd_log.level_error);
3841: END IF;
3842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3843: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3844: p_prefix=>l_debug_prefix,
3845: p_msg_level=>fnd_log.level_procedure);
3846: END IF;

Line 3845: p_msg_level=>fnd_log.level_procedure);

3841: END IF;
3842: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3843: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3844: p_prefix=>l_debug_prefix,
3845: p_msg_level=>fnd_log.level_procedure);
3846: END IF;
3847: WHEN fnd_api.g_exc_unexpected_error THEN
3848: x_return_status := fnd_api.g_ret_sts_unexp_error;
3849:

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

3851: p_count => x_msg_count,
3852: p_data => x_msg_data);
3853:
3854: -- Debug info.
3855: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3856: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3857: p_msg_data=>x_msg_data,
3858: p_msg_type=>'UNEXPECTED ERROR',
3859: p_msg_level=>fnd_log.level_error);

Line 3859: p_msg_level=>fnd_log.level_error);

3855: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3856: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3857: p_msg_data=>x_msg_data,
3858: p_msg_type=>'UNEXPECTED ERROR',
3859: p_msg_level=>fnd_log.level_error);
3860: END IF;
3861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3862: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3863: p_prefix=>l_debug_prefix,

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

3857: p_msg_data=>x_msg_data,
3858: p_msg_type=>'UNEXPECTED ERROR',
3859: p_msg_level=>fnd_log.level_error);
3860: END IF;
3861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3862: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3863: p_prefix=>l_debug_prefix,
3864: p_msg_level=>fnd_log.level_procedure);
3865: END IF;

Line 3864: p_msg_level=>fnd_log.level_procedure);

3860: END IF;
3861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3862: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3863: p_prefix=>l_debug_prefix,
3864: p_msg_level=>fnd_log.level_procedure);
3865: END IF;
3866: WHEN OTHERS THEN
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:

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

3874: p_count => x_msg_count,
3875: p_data => x_msg_data);
3876:
3877: -- Debug info.
3878: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3879: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3880: p_msg_data=>x_msg_data,
3881: p_msg_type=>'SQL ERROR',
3882: p_msg_level=>fnd_log.level_error);

Line 3882: p_msg_level=>fnd_log.level_error);

3878: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3879: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3880: p_msg_data=>x_msg_data,
3881: p_msg_type=>'SQL ERROR',
3882: p_msg_level=>fnd_log.level_error);
3883: END IF;
3884: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3885: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3886: p_prefix=>l_debug_prefix,

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

3880: p_msg_data=>x_msg_data,
3881: p_msg_type=>'SQL ERROR',
3882: p_msg_level=>fnd_log.level_error);
3883: END IF;
3884: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3885: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3886: p_prefix=>l_debug_prefix,
3887: p_msg_level=>fnd_log.level_procedure);
3888: END IF;

Line 3887: p_msg_level=>fnd_log.level_procedure);

3883: END IF;
3884: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3885: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',
3886: p_prefix=>l_debug_prefix,
3887: p_msg_level=>fnd_log.level_procedure);
3888: END IF;
3889:
3890: end;
3891:

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

3911: END IF;
3912:
3913:
3914: -- Debug info.
3915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3916: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(+)',
3917: p_prefix=>l_debug_prefix,
3918: p_msg_level=>fnd_log.level_procedure);
3919: END IF;

Line 3918: p_msg_level=>fnd_log.level_procedure);

3914: -- Debug info.
3915: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3916: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(+)',
3917: p_prefix=>l_debug_prefix,
3918: p_msg_level=>fnd_log.level_procedure);
3919: END IF;
3920:
3921: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
3922: p_party_id => null,

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

3941: END IF;
3942:
3943:
3944: -- Debug info.
3945: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'WARNING',
3949: p_msg_level=>fnd_log.level_exception);

Line 3949: p_msg_level=>fnd_log.level_exception);

3945: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3946: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3947: p_msg_data=>x_msg_data,
3948: p_msg_type=>'WARNING',
3949: p_msg_level=>fnd_log.level_exception);
3950: END IF;
3951:
3952: -- Debug info.
3953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

3949: p_msg_level=>fnd_log.level_exception);
3950: END IF;
3951:
3952: -- Debug info.
3953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3954: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated (-)',
3955: p_prefix=>l_debug_prefix,
3956: p_msg_level=>fnd_log.level_procedure);
3957: END IF;

Line 3956: p_msg_level=>fnd_log.level_procedure);

3952: -- Debug info.
3953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3954: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated (-)',
3955: p_prefix=>l_debug_prefix,
3956: p_msg_level=>fnd_log.level_procedure);
3957: END IF;
3958:
3959:
3960: EXCEPTION

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

3966: p_count => x_msg_count,
3967: p_data => x_msg_data);
3968:
3969: -- Debug info.
3970: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3971: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3972: p_msg_data=>x_msg_data,
3973: p_msg_type=>'ERROR',
3974: p_msg_level=>fnd_log.level_error);

Line 3974: p_msg_level=>fnd_log.level_error);

3970: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3971: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3972: p_msg_data=>x_msg_data,
3973: p_msg_type=>'ERROR',
3974: p_msg_level=>fnd_log.level_error);
3975: END IF;
3976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3977: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3978: p_prefix=>l_debug_prefix,

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

3972: p_msg_data=>x_msg_data,
3973: p_msg_type=>'ERROR',
3974: p_msg_level=>fnd_log.level_error);
3975: END IF;
3976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3977: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3978: p_prefix=>l_debug_prefix,
3979: p_msg_level=>fnd_log.level_procedure);
3980: END IF;

Line 3979: p_msg_level=>fnd_log.level_procedure);

3975: END IF;
3976: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3977: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3978: p_prefix=>l_debug_prefix,
3979: p_msg_level=>fnd_log.level_procedure);
3980: END IF;
3981: WHEN fnd_api.g_exc_unexpected_error THEN
3982: x_return_status := fnd_api.g_ret_sts_unexp_error;
3983:

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

3985: p_count => x_msg_count,
3986: p_data => x_msg_data);
3987:
3988: -- Debug info.
3989: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3990: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3991: p_msg_data=>x_msg_data,
3992: p_msg_type=>'UNEXPECTED ERROR',
3993: p_msg_level=>fnd_log.level_error);

Line 3993: p_msg_level=>fnd_log.level_error);

3989: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3990: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3991: p_msg_data=>x_msg_data,
3992: p_msg_type=>'UNEXPECTED ERROR',
3993: p_msg_level=>fnd_log.level_error);
3994: END IF;
3995: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3996: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3997: p_prefix=>l_debug_prefix,

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

3991: p_msg_data=>x_msg_data,
3992: p_msg_type=>'UNEXPECTED ERROR',
3993: p_msg_level=>fnd_log.level_error);
3994: END IF;
3995: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3996: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3997: p_prefix=>l_debug_prefix,
3998: p_msg_level=>fnd_log.level_procedure);
3999: END IF;

Line 3998: p_msg_level=>fnd_log.level_procedure);

3994: END IF;
3995: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3996: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
3997: p_prefix=>l_debug_prefix,
3998: p_msg_level=>fnd_log.level_procedure);
3999: END IF;
4000: WHEN OTHERS THEN
4001: x_return_status := fnd_api.g_ret_sts_unexp_error;
4002:

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

4008: p_count => x_msg_count,
4009: p_data => x_msg_data);
4010:
4011: -- Debug info.
4012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4014: p_msg_data=>x_msg_data,
4015: p_msg_type=>'SQL ERROR',
4016: p_msg_level=>fnd_log.level_error);

Line 4016: p_msg_level=>fnd_log.level_error);

4012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
4013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
4014: p_msg_data=>x_msg_data,
4015: p_msg_type=>'SQL ERROR',
4016: p_msg_level=>fnd_log.level_error);
4017: END IF;
4018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4019: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
4020: p_prefix=>l_debug_prefix,

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

4014: p_msg_data=>x_msg_data,
4015: p_msg_type=>'SQL ERROR',
4016: p_msg_level=>fnd_log.level_error);
4017: END IF;
4018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4019: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
4020: p_prefix=>l_debug_prefix,
4021: p_msg_level=>fnd_log.level_procedure);
4022: END IF;

Line 4021: p_msg_level=>fnd_log.level_procedure);

4017: END IF;
4018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4019: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',
4020: p_prefix=>l_debug_prefix,
4021: p_msg_level=>fnd_log.level_procedure);
4022: END IF;
4023:
4024: end;
4025: