124: END IF;
125:
126:
127: -- Debug info.
128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
129: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos(+)',
130: p_prefix=>l_debug_prefix,
131: p_msg_level=>fnd_log.level_procedure);
132: END IF;
127: -- Debug info.
128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
129: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos(+)',
130: p_prefix=>l_debug_prefix,
131: p_msg_level=>fnd_log.level_procedure);
132: END IF;
133:
134: x_financial_report_objs := HZ_FINANCIAL_BO_TBL();
135: open c1;
136: fetch c1 BULK COLLECT into x_financial_report_objs;
137: close c1;
138:
139: -- Debug info.
140: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
141: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
142: p_msg_data=>x_msg_data,
143: p_msg_type=>'WARNING',
144: p_msg_level=>fnd_log.level_exception);
140: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
141: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
142: p_msg_data=>x_msg_data,
143: p_msg_type=>'WARNING',
144: p_msg_level=>fnd_log.level_exception);
145: END IF;
146:
147: -- Debug info.
148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
144: p_msg_level=>fnd_log.level_exception);
145: END IF;
146:
147: -- Debug info.
148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
149: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
150: p_prefix=>l_debug_prefix,
151: p_msg_level=>fnd_log.level_procedure);
152: END IF;
147: -- Debug info.
148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
149: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
150: p_prefix=>l_debug_prefix,
151: p_msg_level=>fnd_log.level_procedure);
152: END IF;
153:
154:
155: EXCEPTION
161: p_count => x_msg_count,
162: p_data => x_msg_data);
163:
164: -- Debug info.
165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
167: p_msg_data=>x_msg_data,
168: p_msg_type=>'ERROR',
169: p_msg_level=>fnd_log.level_error);
165: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
167: p_msg_data=>x_msg_data,
168: p_msg_type=>'ERROR',
169: p_msg_level=>fnd_log.level_error);
170: END IF;
171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
172: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
173: p_prefix=>l_debug_prefix,
167: p_msg_data=>x_msg_data,
168: p_msg_type=>'ERROR',
169: p_msg_level=>fnd_log.level_error);
170: END IF;
171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
172: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);
175: END IF;
170: END IF;
171: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
172: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
173: p_prefix=>l_debug_prefix,
174: p_msg_level=>fnd_log.level_procedure);
175: END IF;
176: WHEN fnd_api.g_exc_unexpected_error THEN
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178:
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: -- Debug info.
184: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
186: p_msg_data=>x_msg_data,
187: p_msg_type=>'UNEXPECTED ERROR',
188: p_msg_level=>fnd_log.level_error);
184: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
186: p_msg_data=>x_msg_data,
187: p_msg_type=>'UNEXPECTED ERROR',
188: p_msg_level=>fnd_log.level_error);
189: END IF;
190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
191: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
192: p_prefix=>l_debug_prefix,
186: p_msg_data=>x_msg_data,
187: p_msg_type=>'UNEXPECTED ERROR',
188: p_msg_level=>fnd_log.level_error);
189: END IF;
190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
191: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
192: p_prefix=>l_debug_prefix,
193: p_msg_level=>fnd_log.level_procedure);
194: END IF;
189: END IF;
190: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
191: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
192: p_prefix=>l_debug_prefix,
193: p_msg_level=>fnd_log.level_procedure);
194: END IF;
195: WHEN OTHERS THEN
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197:
203: p_count => x_msg_count,
204: p_data => x_msg_data);
205:
206: -- Debug info.
207: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
209: p_msg_data=>x_msg_data,
210: p_msg_type=>'SQL ERROR',
211: p_msg_level=>fnd_log.level_error);
207: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
209: p_msg_data=>x_msg_data,
210: p_msg_type=>'SQL ERROR',
211: p_msg_level=>fnd_log.level_error);
212: END IF;
213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
214: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
215: p_prefix=>l_debug_prefix,
209: p_msg_data=>x_msg_data,
210: p_msg_type=>'SQL ERROR',
211: p_msg_level=>fnd_log.level_error);
212: END IF;
213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
214: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
215: p_prefix=>l_debug_prefix,
216: p_msg_level=>fnd_log.level_procedure);
217: END IF;
212: END IF;
213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
214: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
215: p_prefix=>l_debug_prefix,
216: p_msg_level=>fnd_log.level_procedure);
217: END IF;
218:
219: end;
220:
665: END IF;
666:
667:
668: -- Debug info.
669: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
670: hz_utility_v2pub.debug(p_message=>'get_organization_bo(+)',
671: p_prefix=>l_debug_prefix,
672: p_msg_level=>fnd_log.level_procedure);
673: END IF;
668: -- Debug info.
669: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
670: hz_utility_v2pub.debug(p_message=>'get_organization_bo(+)',
671: p_prefix=>l_debug_prefix,
672: p_msg_level=>fnd_log.level_procedure);
673: END IF;
674:
675: open c1;
676: fetch c1 into x_organization_obj;
889: END IF;
890:
891:
892: -- Debug info.
893: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
895: p_msg_data=>x_msg_data,
896: p_msg_type=>'WARNING',
897: p_msg_level=>fnd_log.level_exception);
893: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
895: p_msg_data=>x_msg_data,
896: p_msg_type=>'WARNING',
897: p_msg_level=>fnd_log.level_exception);
898: END IF;
899:
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
897: p_msg_level=>fnd_log.level_exception);
898: END IF;
899:
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;
906:
907:
908: EXCEPTION
914: p_count => x_msg_count,
915: p_data => x_msg_data);
916:
917: -- Debug info.
918: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
920: p_msg_data=>x_msg_data,
921: p_msg_type=>'ERROR',
922: p_msg_level=>fnd_log.level_error);
918: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
920: p_msg_data=>x_msg_data,
921: p_msg_type=>'ERROR',
922: p_msg_level=>fnd_log.level_error);
923: END IF;
924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,
920: p_msg_data=>x_msg_data,
921: p_msg_type=>'ERROR',
922: p_msg_level=>fnd_log.level_error);
923: END IF;
924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,
927: p_msg_level=>fnd_log.level_procedure);
928: END IF;
923: END IF;
924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,
927: p_msg_level=>fnd_log.level_procedure);
928: END IF;
929: WHEN fnd_api.g_exc_unexpected_error THEN
930: x_return_status := fnd_api.g_ret_sts_unexp_error;
931:
933: p_count => x_msg_count,
934: p_data => x_msg_data);
935:
936: -- Debug info.
937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
939: p_msg_data=>x_msg_data,
940: p_msg_type=>'UNEXPECTED ERROR',
941: p_msg_level=>fnd_log.level_error);
937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
939: p_msg_data=>x_msg_data,
940: p_msg_type=>'UNEXPECTED ERROR',
941: p_msg_level=>fnd_log.level_error);
942: END IF;
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
945: p_prefix=>l_debug_prefix,
939: p_msg_data=>x_msg_data,
940: p_msg_type=>'UNEXPECTED ERROR',
941: p_msg_level=>fnd_log.level_error);
942: END IF;
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;
942: END IF;
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;
948: WHEN OTHERS THEN
949: x_return_status := fnd_api.g_ret_sts_unexp_error;
950:
956: p_count => x_msg_count,
957: p_data => x_msg_data);
958:
959: -- Debug info.
960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
961: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
962: p_msg_data=>x_msg_data,
963: p_msg_type=>'SQL ERROR',
964: p_msg_level=>fnd_log.level_error);
960: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
961: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
962: p_msg_data=>x_msg_data,
963: p_msg_type=>'SQL ERROR',
964: p_msg_level=>fnd_log.level_error);
965: END IF;
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
968: p_prefix=>l_debug_prefix,
962: p_msg_data=>x_msg_data,
963: p_msg_type=>'SQL ERROR',
964: p_msg_level=>fnd_log.level_error);
965: END IF;
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
968: p_prefix=>l_debug_prefix,
969: p_msg_level=>fnd_log.level_procedure);
970: END IF;
965: END IF;
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
968: p_prefix=>l_debug_prefix,
969: p_msg_level=>fnd_log.level_procedure);
970: END IF;
971:
972: end;
973:
1045: END IF;
1046:
1047:
1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'get_organization_created(+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;
1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'get_organization_created(+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;
1054:
1055:
1056: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1080: x_msg_data => x_msg_data);
1081: end loop;
1082:
1083: -- Debug info.
1084: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'WARNING',
1088: p_msg_level=>fnd_log.level_exception);
1084: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'WARNING',
1088: p_msg_level=>fnd_log.level_exception);
1089: END IF;
1090:
1091: -- Debug info.
1092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1088: p_msg_level=>fnd_log.level_exception);
1089: END IF;
1090:
1091: -- Debug info.
1092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1093: hz_utility_v2pub.debug(p_message=>'get_organization_created (-)',
1094: p_prefix=>l_debug_prefix,
1095: p_msg_level=>fnd_log.level_procedure);
1096: END IF;
1091: -- Debug info.
1092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1093: hz_utility_v2pub.debug(p_message=>'get_organization_created (-)',
1094: p_prefix=>l_debug_prefix,
1095: p_msg_level=>fnd_log.level_procedure);
1096: END IF;
1097:
1098:
1099: EXCEPTION
1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107:
1108: -- Debug info.
1109: IF fnd_log.level_error>=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=>'ERROR',
1113: p_msg_level=>fnd_log.level_error);
1109: IF fnd_log.level_error>=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=>'ERROR',
1113: p_msg_level=>fnd_log.level_error);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,
1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'ERROR',
1113: p_msg_level=>fnd_log.level_error);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:
1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:
1127: -- Debug info.
1128: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1130: p_msg_data=>x_msg_data,
1131: p_msg_type=>'UNEXPECTED ERROR',
1132: p_msg_level=>fnd_log.level_error);
1128: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1130: p_msg_data=>x_msg_data,
1131: p_msg_type=>'UNEXPECTED ERROR',
1132: p_msg_level=>fnd_log.level_error);
1133: END IF;
1134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1136: p_prefix=>l_debug_prefix,
1130: p_msg_data=>x_msg_data,
1131: p_msg_type=>'UNEXPECTED ERROR',
1132: p_msg_level=>fnd_log.level_error);
1133: END IF;
1134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1136: p_prefix=>l_debug_prefix,
1137: p_msg_level=>fnd_log.level_procedure);
1138: END IF;
1133: END IF;
1134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1136: p_prefix=>l_debug_prefix,
1137: p_msg_level=>fnd_log.level_procedure);
1138: END IF;
1139: WHEN OTHERS THEN
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141:
1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:
1150: -- Debug info.
1151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'SQL ERROR',
1155: p_msg_level=>fnd_log.level_error);
1151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'SQL ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1159: p_prefix=>l_debug_prefix,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'SQL ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;
1162:
1163: end;
1164:
1234: END IF;
1235:
1236:
1237: -- Debug info.
1238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1239: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
1240: p_prefix=>l_debug_prefix,
1241: p_msg_level=>fnd_log.level_procedure);
1242: END IF;
1237: -- Debug info.
1238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1239: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
1240: p_prefix=>l_debug_prefix,
1241: p_msg_level=>fnd_log.level_procedure);
1242: END IF;
1243:
1244:
1245: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(
1276:
1277:
1278:
1279: -- Debug info.
1280: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1282: p_msg_data=>x_msg_data,
1283: p_msg_type=>'WARNING',
1284: p_msg_level=>fnd_log.level_exception);
1280: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1282: p_msg_data=>x_msg_data,
1283: p_msg_type=>'WARNING',
1284: p_msg_level=>fnd_log.level_exception);
1285: END IF;
1286:
1287: -- Debug info.
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1284: p_msg_level=>fnd_log.level_exception);
1285: END IF;
1286:
1287: -- Debug info.
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
1290: p_prefix=>l_debug_prefix,
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;
1287: -- Debug info.
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
1290: p_prefix=>l_debug_prefix,
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;
1293:
1294:
1295: EXCEPTION
1301: p_count => x_msg_count,
1302: p_data => x_msg_data);
1303:
1304: -- Debug info.
1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'ERROR',
1309: p_msg_level=>fnd_log.level_error);
1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316: WHEN fnd_api.g_exc_unexpected_error THEN
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318:
1320: p_count => x_msg_count,
1321: p_data => x_msg_data);
1322:
1323: -- Debug info.
1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'UNEXPECTED ERROR',
1328: p_msg_level=>fnd_log.level_error);
1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'UNEXPECTED ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1332: p_prefix=>l_debug_prefix,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'UNEXPECTED ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335: WHEN OTHERS THEN
1336: x_return_status := fnd_api.g_ret_sts_unexp_error;
1337:
1343: p_count => x_msg_count,
1344: p_data => x_msg_data);
1345:
1346: -- Debug info.
1347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1349: p_msg_data=>x_msg_data,
1350: p_msg_type=>'SQL ERROR',
1351: p_msg_level=>fnd_log.level_error);
1347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1349: p_msg_data=>x_msg_data,
1350: p_msg_type=>'SQL ERROR',
1351: p_msg_level=>fnd_log.level_error);
1352: END IF;
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1355: p_prefix=>l_debug_prefix,
1349: p_msg_data=>x_msg_data,
1350: p_msg_type=>'SQL ERROR',
1351: p_msg_level=>fnd_log.level_error);
1352: END IF;
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1355: p_prefix=>l_debug_prefix,
1356: p_msg_level=>fnd_log.level_procedure);
1357: END IF;
1352: END IF;
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1355: p_prefix=>l_debug_prefix,
1356: p_msg_level=>fnd_log.level_procedure);
1357: END IF;
1358:
1359: end;
1360:
2074: END IF;
2075:
2076:
2077: -- Debug info.
2078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2079: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
2080: p_prefix=>l_debug_prefix,
2081: p_msg_level=>fnd_log.level_procedure);
2082: END IF;
2077: -- Debug info.
2078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2079: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
2080: p_prefix=>l_debug_prefix,
2081: p_msg_level=>fnd_log.level_procedure);
2082: END IF;
2083: /* moved to public api
2084: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
2085: p_party_id => p_organization_id,
2122:
2123:
2124:
2125: -- Debug info.
2126: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2127: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2128: p_msg_data=>x_msg_data,
2129: p_msg_type=>'WARNING',
2130: p_msg_level=>fnd_log.level_exception);
2126: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2127: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2128: p_msg_data=>x_msg_data,
2129: p_msg_type=>'WARNING',
2130: p_msg_level=>fnd_log.level_exception);
2131: END IF;
2132:
2133: -- Debug info.
2134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2130: p_msg_level=>fnd_log.level_exception);
2131: END IF;
2132:
2133: -- Debug info.
2134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2135: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
2136: p_prefix=>l_debug_prefix,
2137: p_msg_level=>fnd_log.level_procedure);
2138: END IF;
2133: -- Debug info.
2134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2135: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
2136: p_prefix=>l_debug_prefix,
2137: p_msg_level=>fnd_log.level_procedure);
2138: END IF;
2139:
2140:
2141: EXCEPTION
2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:
2150: -- Debug info.
2151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2153: p_msg_data=>x_msg_data,
2154: p_msg_type=>'ERROR',
2155: p_msg_level=>fnd_log.level_error);
2151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2153: p_msg_data=>x_msg_data,
2154: p_msg_type=>'ERROR',
2155: p_msg_level=>fnd_log.level_error);
2156: END IF;
2157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,
2153: p_msg_data=>x_msg_data,
2154: p_msg_type=>'ERROR',
2155: p_msg_level=>fnd_log.level_error);
2156: END IF;
2157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,
2160: p_msg_level=>fnd_log.level_procedure);
2161: END IF;
2156: END IF;
2157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,
2160: p_msg_level=>fnd_log.level_procedure);
2161: END IF;
2162: WHEN fnd_api.g_exc_unexpected_error THEN
2163: x_return_status := fnd_api.g_ret_sts_unexp_error;
2164:
2166: p_count => x_msg_count,
2167: p_data => x_msg_data);
2168:
2169: -- Debug info.
2170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'UNEXPECTED ERROR',
2174: p_msg_level=>fnd_log.level_error);
2170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'UNEXPECTED ERROR',
2174: p_msg_level=>fnd_log.level_error);
2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2178: p_prefix=>l_debug_prefix,
2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'UNEXPECTED ERROR',
2174: p_msg_level=>fnd_log.level_error);
2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: END IF;
2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: END IF;
2181: WHEN OTHERS THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:
2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: -- Debug info.
2193: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2195: p_msg_data=>x_msg_data,
2196: p_msg_type=>'SQL ERROR',
2197: p_msg_level=>fnd_log.level_error);
2193: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2195: p_msg_data=>x_msg_data,
2196: p_msg_type=>'SQL ERROR',
2197: p_msg_level=>fnd_log.level_error);
2198: END IF;
2199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2201: p_prefix=>l_debug_prefix,
2195: p_msg_data=>x_msg_data,
2196: p_msg_type=>'SQL ERROR',
2197: p_msg_level=>fnd_log.level_error);
2198: END IF;
2199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2201: p_prefix=>l_debug_prefix,
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;
2198: END IF;
2199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2201: p_prefix=>l_debug_prefix,
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;
2204:
2205: end;
2206: