DBA Data[Home] [Help]

APPS.HZ_ORGANIZATION_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 336: px_organization_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

332: px_organization_rec.displayed_duns_party_id:= p_organization_obj.displayed_duns_party_id;
333: IF(p_create_or_update = 'C') THEN
334: px_organization_rec.party_rec.orig_system:= p_organization_os;
335: px_organization_rec.party_rec.orig_system_reference:= p_organization_osr;
336: px_organization_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
337: END IF;
338: px_organization_rec.do_not_confuse_with:= p_organization_obj.do_not_confuse_with;
339: px_organization_rec.actual_content_source:= p_organization_obj.actual_content_source;
340: px_organization_rec.party_rec.party_id:= p_organization_id;

Line 508: px_credit_rating_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

504: px_credit_rating_rec.num_spcl_event:= p_credit_rating_obj.num_spcl_event;
505: px_credit_rating_rec.spcl_event_update_date:= p_credit_rating_obj.spcl_event_update_date;
506: px_credit_rating_rec.spcl_evnt_txt:= p_credit_rating_obj.spcl_evnt_txt;
507: px_credit_rating_rec.actual_content_source:= p_credit_rating_obj.actual_content_source;
508: px_credit_rating_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
509: END assign_credit_rating_rec;
510:
511: -- PRIVATE PROCEDURE assign_financial_report_rec
512: --

Line 588: px_fin_report_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

584: END IF;
585: IF(p_fin_report_obj.status in ('A','I')) THEN
586: px_fin_report_rec.status := p_fin_report_obj.status;
587: END IF;
588: px_fin_report_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
589: END assign_financial_report_rec;
590:
591: -- PRIVATE PROCEDURE assign_financial_number_rec
592: --

Line 627: px_fin_number_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

623: px_fin_number_rec.projected_actual_flag := p_fin_number_obj.projected_actual_flag;
624: IF(p_fin_number_obj.status in ('A','I')) THEN
625: px_fin_number_rec.status := p_fin_number_obj.status;
626: END IF;
627: px_fin_number_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
628: END assign_financial_number_rec;
629:
630: -- PRIVATE PROCEDURE create_credit_ratings
631: --

Line 674: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(+)',

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;
678:

Line 699: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_id,

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;
703: RAISE FND_API.G_EXC_ERROR;

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

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);
716: END IF;

Line 718: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

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;
722: EXCEPTION

Line 737: hz_utility_v2pub.debug_return_messages(p_msg_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);
741: END IF;

Line 743: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

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;
747: WHEN fnd_api.g_exc_unexpected_error THEN

Line 761: hz_utility_v2pub.debug_return_messages(p_msg_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);
765: END IF;

Line 767: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

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;
771: WHEN OTHERS THEN

Line 789: hz_utility_v2pub.debug_return_messages(p_msg_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);
793: END IF;

Line 795: hz_utility_v2pub.debug(p_message=>'create_credit_ratings(-)',

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;
799: END create_credit_ratings;

Line 846: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(+)',

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;
850: --------------------------------

Line 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,

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;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 907: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_credit_ratings, organization id: '||p_organization_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;
911: RAISE FND_API.G_EXC_ERROR;

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

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);
921: END IF;

Line 923: hz_utility_v2pub.debug(p_message=>'save_credit_rating(-)',

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;
927: EXCEPTION

Line 942: hz_utility_v2pub.debug_return_messages(p_msg_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);
946: END IF;

Line 948: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',

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;
952: WHEN fnd_api.g_exc_unexpected_error THEN

Line 966: hz_utility_v2pub.debug_return_messages(p_msg_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);
970: END IF;

Line 972: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',

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;
976: WHEN OTHERS THEN

Line 994: hz_utility_v2pub.debug_return_messages(p_msg_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);
998: END IF;

Line 1000: hz_utility_v2pub.debug(p_message=>'save_credit_ratings(-)',

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;
1004: END save_credit_ratings;

Line 1031: hz_utility_v2pub.debug(p_message=>'create_financial_reports(+)',

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;
1035:

Line 1056: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, org id: '||p_organization_id,

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;
1060: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 1091: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.create_financial_reports, fin_number_id: '||l_dummy_id,

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;
1095: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

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);
1114: END IF;

Line 1116: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

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;
1120: EXCEPTION

Line 1131: hz_utility_v2pub.debug_return_messages(p_msg_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);
1135: END IF;

Line 1137: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

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;
1141: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1151: hz_utility_v2pub.debug_return_messages(p_msg_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);
1155: END IF;

Line 1157: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

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;
1161: WHEN OTHERS THEN

Line 1175: hz_utility_v2pub.debug_return_messages(p_msg_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);
1179: END IF;

Line 1181: hz_utility_v2pub.debug(p_message=>'create_financial_reports(-)',

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;
1185: END create_financial_reports;

Line 1213: hz_utility_v2pub.debug(p_message=>'save_financial_reports(+)',

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;
1217:

Line 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,

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;
1244: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1281: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, org id: '||p_organization_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;
1285: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_STRUCT_ERROR');

Line 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,

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;
1315: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1350: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_organization_bo_pub.save_financial_reports, fin_number_id: '||l_dummy_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;
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');

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

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);
1370: END IF;

Line 1372: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

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;
1376: EXCEPTION

Line 1387: hz_utility_v2pub.debug_return_messages(p_msg_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);
1391: END IF;

Line 1393: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

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;
1397: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1407: hz_utility_v2pub.debug_return_messages(p_msg_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);
1411: END IF;

Line 1413: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

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;
1417: WHEN OTHERS THEN

Line 1431: hz_utility_v2pub.debug_return_messages(p_msg_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);
1435: END IF;

Line 1437: hz_utility_v2pub.debug(p_message=>'save_financial_reports(-)',

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;
1441: END save_financial_reports;

Line 1485: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

1481: FND_MSG_PUB.initialize;
1482: END IF;
1483:
1484: -- initialize Global variable
1485: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1486: IF(p_created_by_module IS NULL) THEN
1487: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1488: ELSE
1489: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 1487: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

1483:
1484: -- initialize Global variable
1485: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1486: IF(p_created_by_module IS NULL) THEN
1487: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1488: ELSE
1489: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1490: END IF;
1491:

Line 1489: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1485: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1486: IF(p_created_by_module IS NULL) THEN
1487: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1488: ELSE
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

Line 1494: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(+)',

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;
1498:

Line 1671: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1667: RAISE FND_API.G_EXC_ERROR;
1668: END IF;
1669: END IF;
1670:
1671: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1672:
1673: -----------------------------
1674: -- Create logical org contact
1675: -----------------------------

Line 1695: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1691: RAISE FND_API.G_EXC_ERROR;
1692: END IF;
1693: END IF;
1694:
1695: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1696:
1697: ----------------------------
1698: -- Create logical party site
1699: ----------------------------

Line 1720: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1716: RAISE FND_API.G_EXC_ERROR;
1717: END IF;
1718: END IF;
1719:
1720: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1721:
1722: ------------------------
1723: -- Create contact points
1724: ------------------------

Line 1755: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1751: RAISE FND_API.G_EXC_ERROR;
1752: END IF;
1753: END IF;
1754:
1755: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1756:
1757: ----------------------------
1758: -- Certifications
1759: ----------------------------

Line 1859: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1855: );
1856: END IF;
1857:
1858: -- reset Global variable
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

Line 1860: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1856: END IF;
1857:
1858: -- reset Global variable
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,

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

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);
1868: END IF;

Line 1870: hz_utility_v2pub.debug(p_message=>'create_organization_bo(-)',

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;
1874:

Line 1880: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1876: WHEN fnd_api.g_exc_error THEN
1877: ROLLBACK TO do_create_organization_bo_pub;
1878:
1879: -- reset Global variable
1880: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1882:
1883: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1884: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 1881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1877: ROLLBACK TO do_create_organization_bo_pub;
1878:
1879: -- reset Global variable
1880: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1881: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1882:
1883: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1884: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
1885: FND_MSG_PUB.ADD;

Line 1895: hz_utility_v2pub.debug_return_messages(p_msg_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);
1899: END IF;

Line 1901: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',

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;
1905:

Line 1910: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1906: WHEN fnd_api.g_exc_unexpected_error THEN
1907: ROLLBACK TO do_create_organization_bo_pub;
1908:
1909: -- reset Global variable
1910: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1911: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1912:
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1914: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 1911: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1907: ROLLBACK TO do_create_organization_bo_pub;
1908:
1909: -- reset Global variable
1910: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1911: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1912:
1913: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1914: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
1915: FND_MSG_PUB.ADD;

Line 1925: hz_utility_v2pub.debug_return_messages(p_msg_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);
1929: END IF;

Line 1931: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',

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;
1935:

Line 1940: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1936: WHEN OTHERS THEN
1937: ROLLBACK TO do_create_organization_bo_pub;
1938:
1939: -- reset Global variable
1940: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1941: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1942:
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1944: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 1941: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1937: ROLLBACK TO do_create_organization_bo_pub;
1938:
1939: -- reset Global variable
1940: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1941: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1942:
1943: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1944: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
1945: FND_MSG_PUB.ADD;

Line 1959: hz_utility_v2pub.debug_return_messages(p_msg_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);
1963: END IF;

Line 1965: hz_utility_v2pub.debug(p_message=>'do_create_organization_bo(-)',

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;
1969: END do_create_organization_bo;

Line 2092: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

2088: FND_MSG_PUB.initialize;
2089: END IF;
2090:
2091: -- initialize Global variable
2092: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2093: IF(p_created_by_module IS NULL) THEN
2094: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2095: ELSE
2096: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 2094: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

2090:
2091: -- initialize Global variable
2092: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2093: IF(p_created_by_module IS NULL) THEN
2094: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2095: ELSE
2096: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2097: END IF;
2098:

Line 2096: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2092: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2093: IF(p_created_by_module IS NULL) THEN
2094: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2095: ELSE
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

Line 2101: hz_utility_v2pub.debug(p_message=>'update_organization_bo(+)',

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;
2105:

Line 2290: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2286: RAISE FND_API.G_EXC_ERROR;
2287: END IF;
2288: END IF;
2289:
2290: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2291:
2292: -----------------------------
2293: -- Create logical org contact
2294: -----------------------------

Line 2313: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2309: RAISE FND_API.G_EXC_ERROR;
2310: END IF;
2311: END IF;
2312:
2313: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2314:
2315: -----------------
2316: -- For Party Site
2317: -----------------

Line 2338: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2334: RAISE FND_API.G_EXC_ERROR;
2335: END IF;
2336: END IF;
2337:
2338: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2339:
2340: ---------------------
2341: -- For Contact Points
2342: ---------------------

Line 2373: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: END IF;
2372:
2373: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2374:
2375: ---------------------
2376: -- Certifications
2377: ---------------------

Line 2489: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2485: );
2486: END IF;
2487:
2488: -- reset Global variable
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

Line 2490: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2486: END IF;
2487:
2488: -- reset Global variable
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,

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

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);
2498: END IF;

Line 2500: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

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;
2504: EXCEPTION

Line 2509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2505: WHEN fnd_api.g_exc_error THEN
2506: ROLLBACK TO do_update_organization_bo_pub;
2507:
2508: -- reset Global variable
2509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2511:
2512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2513: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 2510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2506: ROLLBACK TO do_update_organization_bo_pub;
2507:
2508: -- reset Global variable
2509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2511:
2512: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2513: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2514: FND_MSG_PUB.ADD;

Line 2524: hz_utility_v2pub.debug_return_messages(p_msg_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);
2528: END IF;

Line 2530: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

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;
2534:

Line 2540: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2536: WHEN fnd_api.g_exc_unexpected_error THEN
2537: ROLLBACK TO do_update_organization_bo_pub;
2538:
2539: -- reset Global variable
2540: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2541: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2542:
2543: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2544: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 2541: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2537: ROLLBACK TO do_update_organization_bo_pub;
2538:
2539: -- reset Global variable
2540: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2541: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2542:
2543: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2544: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2545: FND_MSG_PUB.ADD;

Line 2555: hz_utility_v2pub.debug_return_messages(p_msg_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);
2559: END IF;

Line 2561: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

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;
2565: WHEN OTHERS THEN

Line 2569: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2565: WHEN OTHERS THEN
2566: ROLLBACK TO do_update_organization_bo_pub;
2567:
2568: -- reset Global variable
2569: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2571:
2572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2573: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');

Line 2570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2566: ROLLBACK TO do_update_organization_bo_pub;
2567:
2568: -- reset Global variable
2569: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2571:
2572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2573: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG');
2574: FND_MSG_PUB.ADD;

Line 2588: hz_utility_v2pub.debug_return_messages(p_msg_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);
2592: END IF;

Line 2594: hz_utility_v2pub.debug(p_message=>'do_update_organization_bo(-)',

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;
2598: END do_update_organization_bo;

Line 2699: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(+)',

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;
2703:

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

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);
2768: END IF;

Line 2770: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

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;
2774: EXCEPTION

Line 2784: hz_utility_v2pub.debug_return_messages(p_msg_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);
2788: END IF;

Line 2790: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

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;
2794:

Line 2804: hz_utility_v2pub.debug_return_messages(p_msg_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);
2808: END IF;

Line 2810: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

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;
2814: WHEN OTHERS THEN

Line 2827: hz_utility_v2pub.debug_return_messages(p_msg_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);
2831: END IF;

Line 2833: hz_utility_v2pub.debug(p_message=>'do_save_organization_bo(-)',

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;
2837: END do_save_organization_bo;

Line 3008: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo(+)',

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;
3012:

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

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);
3053: END IF;

Line 3057: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

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;
3061:

Line 3074: hz_utility_v2pub.debug_return_messages(p_msg_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);
3078: END IF;

Line 3080: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

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;
3084: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3093: hz_utility_v2pub.debug_return_messages(p_msg_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);
3097: END IF;

Line 3099: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

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;
3103: WHEN OTHERS THEN

Line 3116: hz_utility_v2pub.debug_return_messages(p_msg_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);
3120: END IF;

Line 3122: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_bo (-)',

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;
3126:

Line 3227: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(+)',

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;
3231:

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

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);
3262: END IF;

Line 3266: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created (-)',

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;
3270:

Line 3283: hz_utility_v2pub.debug_return_messages(p_msg_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);
3287: END IF;

Line 3289: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

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;
3293: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3302: hz_utility_v2pub.debug_return_messages(p_msg_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);
3306: END IF;

Line 3308: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

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;
3312: WHEN OTHERS THEN

Line 3325: hz_utility_v2pub.debug_return_messages(p_msg_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);
3329: END IF;

Line 3331: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_created(-)',

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;
3335:

Line 3431: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(+)',

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;
3435:

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

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);
3466: END IF;

Line 3470: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated (-)',

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;
3474:

Line 3487: hz_utility_v2pub.debug_return_messages(p_msg_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);
3491: END IF;

Line 3493: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

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;
3497: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3506: hz_utility_v2pub.debug_return_messages(p_msg_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);
3510: END IF;

Line 3512: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

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;
3516: WHEN OTHERS THEN

Line 3529: hz_utility_v2pub.debug_return_messages(p_msg_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);
3533: END IF;

Line 3535: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organizations_updated(-)',

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;
3539:

Line 3620: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(+)',

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;
3624:

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

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);
3656: END IF;

Line 3660: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated (-)',

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;
3664:

Line 3677: hz_utility_v2pub.debug_return_messages(p_msg_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);
3681: END IF;

Line 3683: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

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;
3687: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3696: hz_utility_v2pub.debug_return_messages(p_msg_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);
3700: END IF;

Line 3702: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

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;
3706: WHEN OTHERS THEN

Line 3719: hz_utility_v2pub.debug_return_messages(p_msg_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);
3723: END IF;

Line 3725: hz_utility_v2pub.debug(p_message=>'hz_organization_bo_pub.get_organization_updated(-)',

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;
3729:

Line 3782: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(+)',

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;
3786:

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

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);
3816: END IF;

Line 3820: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created (-)',

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;
3824:

Line 3837: hz_utility_v2pub.debug_return_messages(p_msg_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);
3841: END IF;

Line 3843: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',

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;
3847: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3856: hz_utility_v2pub.debug_return_messages(p_msg_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);
3860: END IF;

Line 3862: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',

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;
3866: WHEN OTHERS THEN

Line 3879: hz_utility_v2pub.debug_return_messages(p_msg_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);
3883: END IF;

Line 3885: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_created(-)',

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;
3889:

Line 3916: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(+)',

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;
3920:

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

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);
3950: END IF;

Line 3954: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated (-)',

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;
3958:

Line 3971: hz_utility_v2pub.debug_return_messages(p_msg_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);
3975: END IF;

Line 3977: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',

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;
3981: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3990: hz_utility_v2pub.debug_return_messages(p_msg_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);
3994: END IF;

Line 3996: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',

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;
4000: WHEN OTHERS THEN

Line 4013: hz_utility_v2pub.debug_return_messages(p_msg_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);
4017: END IF;

Line 4019: hz_utility_v2pub.debug(p_message=>'get_ids_organizations_updated(-)',

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;
4023: