188: HZ_GNR_UTIL_PKG.outandlog('Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS'));
189: HZ_GNR_UTIL_PKG.outandlog('NEWLINE');
190:
191: -- Initialize return status and message stack
192: FND_MSG_PUB.initialize;
193:
194: -- Validate location table name
195:
196: IF p_location_table_name IS NULL THEN
195:
196: IF p_location_table_name IS NULL THEN
197:
198: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');
199: FND_MSG_PUB.ADD;
200: RAISE FND_API.G_EXC_ERROR;
201:
202: ELSIF p_location_table_name NOT IN ( 'HR_LOCATIONS_ALL',
203: 'HZ_LOCATIONS') THEN
202: ELSIF p_location_table_name NOT IN ( 'HR_LOCATIONS_ALL',
203: 'HZ_LOCATIONS') THEN
204:
205: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');
206: FND_MSG_PUB.ADD;
207: RAISE FND_API.G_EXC_ERROR;
208:
209: END IF;
210:
221:
222: IF l_from_location_id IS NULL THEN
223: IF l_to_location_id IS NOT NULL THEN
224: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TO_LOC_NOT_NULL');
225: FND_MSG_PUB.ADD;
226: RAISE FND_API.G_EXC_ERROR;
227:
228: END IF;
229: ELSE
231: NULL;
232: ELSE
233: IF l_from_location_id > l_to_location_id THEN
234: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_FROM_LOC_HIGHER');
235: FND_MSG_PUB.ADD;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238: END IF;
239: END IF;
245:
246: IF l_start_date IS NULL THEN
247: IF l_end_date IS NOT NULL THEN
248: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TO_DATE_NOT_NULL');
249: FND_MSG_PUB.ADD;
250: RAISE FND_API.G_EXC_ERROR;
251:
252: END IF;
253: ELSE
255: NULL;
256: ELSE
257: IF l_start_date > l_end_date THEN
258: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_START_DATE_HIGHER');
259: FND_MSG_PUB.ADD;
260: RAISE FND_API.G_EXC_ERROR;
261: END IF;
262: END IF;
263: END IF;
267: -- 2. It should be either 'ALL' or 'NEW' or 'ERROR' (seeded as lookup Type HZ_GEO_GNR_RUN_TYPE)
268: -- If new run type is added, message text will have to be changed.
269: IF (p_run_type IS NULL) THEN
270: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_RUN_TYPE');
271: FND_MSG_PUB.ADD;
272: RAISE FND_API.G_EXC_ERROR;
273: ELSE
274: SELECT COUNT(*)
275: INTO l_run_type_count
280: AND enabled_flag = 'Y';
281:
282: IF (l_run_type_count = 0) THEN
283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_RUN_TYPE');
284: FND_MSG_PUB.ADD;
285: RAISE FND_API.G_EXC_ERROR;
286: END IF;
287: END IF;
288:
298: AND enabled_flag = 'Y';
299:
300: IF (l_usage_count = 0) THEN
301: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');
302: FND_MSG_PUB.ADD;
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: END IF;
306:
313: AND obsolete_flag = 'N';
314:
315: IF (l_country_code_count = 0) THEN
316: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NOT_VALID_COUNTRY');
317: FND_MSG_PUB.ADD;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320: END IF;
321:
930: -- Nishant (Perf Bug 5881539 16-APR-2007)
931: HZ_GNR_PKG.G_API_PURPOSE := 'GNR';
932:
933: -- Initialize return status and message stack
934: FND_MSG_PUB.initialize;
935:
936: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_CUR_LOC_PREFIX');
937: l_curr_loc_msg_prefix := FND_MESSAGE.GET;
938:
994: EXCEPTION
995: WHEN FND_API.G_EXC_ERROR THEN
996: l_num_err_locations := l_num_err_locations + 1;
997: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
998: FND_MSG_PUB.Reset;
999: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1000: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1001: END LOOP;
1002: FND_MSG_PUB.Delete_Msg;
995: WHEN FND_API.G_EXC_ERROR THEN
996: l_num_err_locations := l_num_err_locations + 1;
997: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
998: FND_MSG_PUB.Reset;
999: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1000: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1001: END LOOP;
1002: FND_MSG_PUB.Delete_Msg;
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996: l_num_err_locations := l_num_err_locations + 1;
997: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
998: FND_MSG_PUB.Reset;
999: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1000: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1001: END LOOP;
1002: FND_MSG_PUB.Delete_Msg;
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: l_num_err_locations := l_num_err_locations + 1;
998: FND_MSG_PUB.Reset;
999: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1000: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1001: END LOOP;
1002: FND_MSG_PUB.Delete_Msg;
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: l_num_err_locations := l_num_err_locations + 1;
1005: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1006: FND_MSG_PUB.Reset;
1002: FND_MSG_PUB.Delete_Msg;
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: l_num_err_locations := l_num_err_locations + 1;
1005: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1006: FND_MSG_PUB.Reset;
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1009: END LOOP;
1010: FND_MSG_PUB.Delete_Msg;
1003: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1004: l_num_err_locations := l_num_err_locations + 1;
1005: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1006: FND_MSG_PUB.Reset;
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1009: END LOOP;
1010: FND_MSG_PUB.Delete_Msg;
1011: WHEN OTHERS THEN
1004: l_num_err_locations := l_num_err_locations + 1;
1005: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1006: FND_MSG_PUB.Reset;
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1009: END LOOP;
1010: FND_MSG_PUB.Delete_Msg;
1011: WHEN OTHERS THEN
1012: l_num_err_locations := l_num_err_locations + 1;
1006: FND_MSG_PUB.Reset;
1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1008: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1009: END LOOP;
1010: FND_MSG_PUB.Delete_Msg;
1011: WHEN OTHERS THEN
1012: l_num_err_locations := l_num_err_locations + 1;
1013: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1014: FND_MSG_PUB.Reset;
1010: FND_MSG_PUB.Delete_Msg;
1011: WHEN OTHERS THEN
1012: l_num_err_locations := l_num_err_locations + 1;
1013: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1014: FND_MSG_PUB.Reset;
1015: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1016: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1017: END LOOP;
1018: FND_MSG_PUB.Delete_Msg;
1011: WHEN OTHERS THEN
1012: l_num_err_locations := l_num_err_locations + 1;
1013: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1014: FND_MSG_PUB.Reset;
1015: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1016: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1017: END LOOP;
1018: FND_MSG_PUB.Delete_Msg;
1019: END;
1012: l_num_err_locations := l_num_err_locations + 1;
1013: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1014: FND_MSG_PUB.Reset;
1015: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1016: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1017: END LOOP;
1018: FND_MSG_PUB.Delete_Msg;
1019: END;
1020:
1014: FND_MSG_PUB.Reset;
1015: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1016: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1017: END LOOP;
1018: FND_MSG_PUB.Delete_Msg;
1019: END;
1020:
1021: IF l_count_num_of_rec = l_commit_size THEN
1022: COMMIT;
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: l_num_err_locations := l_num_err_locations + 1;
1082: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1083: FND_MSG_PUB.Reset;
1084: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1085: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1086: END LOOP;
1087: FND_MSG_PUB.Delete_Msg;
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: l_num_err_locations := l_num_err_locations + 1;
1082: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1083: FND_MSG_PUB.Reset;
1084: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1085: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1086: END LOOP;
1087: FND_MSG_PUB.Delete_Msg;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: l_num_err_locations := l_num_err_locations + 1;
1082: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1083: FND_MSG_PUB.Reset;
1084: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1085: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1086: END LOOP;
1087: FND_MSG_PUB.Delete_Msg;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: l_num_err_locations := l_num_err_locations + 1;
1083: FND_MSG_PUB.Reset;
1084: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1085: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1086: END LOOP;
1087: FND_MSG_PUB.Delete_Msg;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: l_num_err_locations := l_num_err_locations + 1;
1090: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1091: FND_MSG_PUB.Reset;
1087: FND_MSG_PUB.Delete_Msg;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: l_num_err_locations := l_num_err_locations + 1;
1090: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1091: FND_MSG_PUB.Reset;
1092: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1093: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1094: END LOOP;
1095: FND_MSG_PUB.Delete_Msg;
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: l_num_err_locations := l_num_err_locations + 1;
1090: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1091: FND_MSG_PUB.Reset;
1092: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1093: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1094: END LOOP;
1095: FND_MSG_PUB.Delete_Msg;
1096: WHEN OTHERS THEN
1089: l_num_err_locations := l_num_err_locations + 1;
1090: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1091: FND_MSG_PUB.Reset;
1092: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1093: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1094: END LOOP;
1095: FND_MSG_PUB.Delete_Msg;
1096: WHEN OTHERS THEN
1097: l_num_err_locations := l_num_err_locations + 1;
1091: FND_MSG_PUB.Reset;
1092: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1093: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1094: END LOOP;
1095: FND_MSG_PUB.Delete_Msg;
1096: WHEN OTHERS THEN
1097: l_num_err_locations := l_num_err_locations + 1;
1098: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1099: FND_MSG_PUB.Reset;
1095: FND_MSG_PUB.Delete_Msg;
1096: WHEN OTHERS THEN
1097: l_num_err_locations := l_num_err_locations + 1;
1098: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1099: FND_MSG_PUB.Reset;
1100: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1101: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1102: END LOOP;
1103: FND_MSG_PUB.Delete_Msg;
1096: WHEN OTHERS THEN
1097: l_num_err_locations := l_num_err_locations + 1;
1098: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1099: FND_MSG_PUB.Reset;
1100: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1101: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1102: END LOOP;
1103: FND_MSG_PUB.Delete_Msg;
1104: END;
1097: l_num_err_locations := l_num_err_locations + 1;
1098: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1099: FND_MSG_PUB.Reset;
1100: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1101: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1102: END LOOP;
1103: FND_MSG_PUB.Delete_Msg;
1104: END;
1105:
1099: FND_MSG_PUB.Reset;
1100: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1101: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1102: END LOOP;
1103: FND_MSG_PUB.Delete_Msg;
1104: END;
1105:
1106: IF l_count_num_of_rec = l_commit_size THEN
1107: COMMIT;
1164: EXCEPTION
1165: WHEN FND_API.G_EXC_ERROR THEN
1166: l_num_err_locations := l_num_err_locations + 1;
1167: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1168: FND_MSG_PUB.Reset;
1169: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1170: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1171: END LOOP;
1172: FND_MSG_PUB.Delete_Msg;
1165: WHEN FND_API.G_EXC_ERROR THEN
1166: l_num_err_locations := l_num_err_locations + 1;
1167: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1168: FND_MSG_PUB.Reset;
1169: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1170: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1171: END LOOP;
1172: FND_MSG_PUB.Delete_Msg;
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: l_num_err_locations := l_num_err_locations + 1;
1167: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1168: FND_MSG_PUB.Reset;
1169: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1170: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1171: END LOOP;
1172: FND_MSG_PUB.Delete_Msg;
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: l_num_err_locations := l_num_err_locations + 1;
1168: FND_MSG_PUB.Reset;
1169: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1170: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1171: END LOOP;
1172: FND_MSG_PUB.Delete_Msg;
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: l_num_err_locations := l_num_err_locations + 1;
1175: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1176: FND_MSG_PUB.Reset;
1172: FND_MSG_PUB.Delete_Msg;
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: l_num_err_locations := l_num_err_locations + 1;
1175: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1176: FND_MSG_PUB.Reset;
1177: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1178: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1179: END LOOP;
1180: FND_MSG_PUB.Delete_Msg;
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: l_num_err_locations := l_num_err_locations + 1;
1175: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1176: FND_MSG_PUB.Reset;
1177: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1178: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1179: END LOOP;
1180: FND_MSG_PUB.Delete_Msg;
1181: WHEN OTHERS THEN
1174: l_num_err_locations := l_num_err_locations + 1;
1175: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1176: FND_MSG_PUB.Reset;
1177: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1178: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1179: END LOOP;
1180: FND_MSG_PUB.Delete_Msg;
1181: WHEN OTHERS THEN
1182: l_num_err_locations := l_num_err_locations + 1;
1176: FND_MSG_PUB.Reset;
1177: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1178: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1179: END LOOP;
1180: FND_MSG_PUB.Delete_Msg;
1181: WHEN OTHERS THEN
1182: l_num_err_locations := l_num_err_locations + 1;
1183: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1184: FND_MSG_PUB.Reset;
1180: FND_MSG_PUB.Delete_Msg;
1181: WHEN OTHERS THEN
1182: l_num_err_locations := l_num_err_locations + 1;
1183: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1184: FND_MSG_PUB.Reset;
1185: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1186: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1187: END LOOP;
1188: FND_MSG_PUB.Delete_Msg;
1181: WHEN OTHERS THEN
1182: l_num_err_locations := l_num_err_locations + 1;
1183: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1184: FND_MSG_PUB.Reset;
1185: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1186: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1187: END LOOP;
1188: FND_MSG_PUB.Delete_Msg;
1189: END;
1182: l_num_err_locations := l_num_err_locations + 1;
1183: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1184: FND_MSG_PUB.Reset;
1185: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1186: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1187: END LOOP;
1188: FND_MSG_PUB.Delete_Msg;
1189: END;
1190:
1184: FND_MSG_PUB.Reset;
1185: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1186: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1187: END LOOP;
1188: FND_MSG_PUB.Delete_Msg;
1189: END;
1190:
1191: IF l_count_num_of_rec = l_commit_size THEN
1192: COMMIT;
1284: EXCEPTION
1285: WHEN FND_API.G_EXC_ERROR THEN
1286: l_num_err_locations := l_num_err_locations + 1;
1287: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1288: FND_MSG_PUB.Reset;
1289: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1290: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1291: END LOOP;
1292: FND_MSG_PUB.Delete_Msg;
1285: WHEN FND_API.G_EXC_ERROR THEN
1286: l_num_err_locations := l_num_err_locations + 1;
1287: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1288: FND_MSG_PUB.Reset;
1289: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1290: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1291: END LOOP;
1292: FND_MSG_PUB.Delete_Msg;
1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1286: l_num_err_locations := l_num_err_locations + 1;
1287: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1288: FND_MSG_PUB.Reset;
1289: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1290: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1291: END LOOP;
1292: FND_MSG_PUB.Delete_Msg;
1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1294: l_num_err_locations := l_num_err_locations + 1;
1288: FND_MSG_PUB.Reset;
1289: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1290: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1291: END LOOP;
1292: FND_MSG_PUB.Delete_Msg;
1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1294: l_num_err_locations := l_num_err_locations + 1;
1295: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1296: FND_MSG_PUB.Reset;
1292: FND_MSG_PUB.Delete_Msg;
1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1294: l_num_err_locations := l_num_err_locations + 1;
1295: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1296: FND_MSG_PUB.Reset;
1297: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1298: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1299: END LOOP;
1300: FND_MSG_PUB.Delete_Msg;
1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1294: l_num_err_locations := l_num_err_locations + 1;
1295: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1296: FND_MSG_PUB.Reset;
1297: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1298: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1299: END LOOP;
1300: FND_MSG_PUB.Delete_Msg;
1301: WHEN OTHERS THEN
1294: l_num_err_locations := l_num_err_locations + 1;
1295: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1296: FND_MSG_PUB.Reset;
1297: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1298: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1299: END LOOP;
1300: FND_MSG_PUB.Delete_Msg;
1301: WHEN OTHERS THEN
1302: l_num_err_locations := l_num_err_locations + 1;
1296: FND_MSG_PUB.Reset;
1297: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1298: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1299: END LOOP;
1300: FND_MSG_PUB.Delete_Msg;
1301: WHEN OTHERS THEN
1302: l_num_err_locations := l_num_err_locations + 1;
1303: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1304: HZ_GNR_UTIL_PKG.out(SQLERRM);
1301: WHEN OTHERS THEN
1302: l_num_err_locations := l_num_err_locations + 1;
1303: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1304: HZ_GNR_UTIL_PKG.out(SQLERRM);
1305: FND_MSG_PUB.Reset;
1306: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1307: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1308: END LOOP;
1309: FND_MSG_PUB.Delete_Msg;
1302: l_num_err_locations := l_num_err_locations + 1;
1303: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1304: HZ_GNR_UTIL_PKG.out(SQLERRM);
1305: FND_MSG_PUB.Reset;
1306: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1307: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1308: END LOOP;
1309: FND_MSG_PUB.Delete_Msg;
1310: END;
1303: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1304: HZ_GNR_UTIL_PKG.out(SQLERRM);
1305: FND_MSG_PUB.Reset;
1306: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1307: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1308: END LOOP;
1309: FND_MSG_PUB.Delete_Msg;
1310: END;
1311:
1305: FND_MSG_PUB.Reset;
1306: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1307: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1308: END LOOP;
1309: FND_MSG_PUB.Delete_Msg;
1310: END;
1311:
1312: ELSE
1313: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1317: EXCEPTION WHEN OTHERS THEN
1318: l_num_err_locations := l_num_err_locations + 1;
1319: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1320: HZ_GNR_UTIL_PKG.out('Error: '||SQLERRM);
1321: FND_MSG_PUB.Reset;
1322: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1323: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1324: END LOOP;
1325: FND_MSG_PUB.Delete_Msg;
1318: l_num_err_locations := l_num_err_locations + 1;
1319: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1320: HZ_GNR_UTIL_PKG.out('Error: '||SQLERRM);
1321: FND_MSG_PUB.Reset;
1322: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1323: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1324: END LOOP;
1325: FND_MSG_PUB.Delete_Msg;
1326: END;
1319: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1320: HZ_GNR_UTIL_PKG.out('Error: '||SQLERRM);
1321: FND_MSG_PUB.Reset;
1322: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1323: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1324: END LOOP;
1325: FND_MSG_PUB.Delete_Msg;
1326: END;
1327:
1321: FND_MSG_PUB.Reset;
1322: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1323: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1324: END LOOP;
1325: FND_MSG_PUB.Delete_Msg;
1326: END;
1327:
1328: IF l_count_num_of_rec = l_commit_size THEN
1329: COMMIT;
1405: EXCEPTION
1406: WHEN FND_API.G_EXC_ERROR THEN
1407: l_num_err_locations := l_num_err_locations + 1;
1408: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1409: FND_MSG_PUB.Reset;
1410: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1411: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1412: END LOOP;
1413: FND_MSG_PUB.Delete_Msg;
1406: WHEN FND_API.G_EXC_ERROR THEN
1407: l_num_err_locations := l_num_err_locations + 1;
1408: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1409: FND_MSG_PUB.Reset;
1410: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1411: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1412: END LOOP;
1413: FND_MSG_PUB.Delete_Msg;
1414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: l_num_err_locations := l_num_err_locations + 1;
1408: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1409: FND_MSG_PUB.Reset;
1410: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1411: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1412: END LOOP;
1413: FND_MSG_PUB.Delete_Msg;
1414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1415: l_num_err_locations := l_num_err_locations + 1;
1409: FND_MSG_PUB.Reset;
1410: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1411: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1412: END LOOP;
1413: FND_MSG_PUB.Delete_Msg;
1414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1415: l_num_err_locations := l_num_err_locations + 1;
1416: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1417: FND_MSG_PUB.Reset;
1413: FND_MSG_PUB.Delete_Msg;
1414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1415: l_num_err_locations := l_num_err_locations + 1;
1416: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1417: FND_MSG_PUB.Reset;
1418: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1419: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1420: END LOOP;
1421: FND_MSG_PUB.Delete_Msg;
1414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1415: l_num_err_locations := l_num_err_locations + 1;
1416: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1417: FND_MSG_PUB.Reset;
1418: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1419: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1420: END LOOP;
1421: FND_MSG_PUB.Delete_Msg;
1422: WHEN OTHERS THEN
1415: l_num_err_locations := l_num_err_locations + 1;
1416: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1417: FND_MSG_PUB.Reset;
1418: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1419: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1420: END LOOP;
1421: FND_MSG_PUB.Delete_Msg;
1422: WHEN OTHERS THEN
1423: l_num_err_locations := l_num_err_locations + 1;
1417: FND_MSG_PUB.Reset;
1418: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1419: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1420: END LOOP;
1421: FND_MSG_PUB.Delete_Msg;
1422: WHEN OTHERS THEN
1423: l_num_err_locations := l_num_err_locations + 1;
1424: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1425: FND_MSG_PUB.Reset;
1421: FND_MSG_PUB.Delete_Msg;
1422: WHEN OTHERS THEN
1423: l_num_err_locations := l_num_err_locations + 1;
1424: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1425: FND_MSG_PUB.Reset;
1426: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1427: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1428: END LOOP;
1429: FND_MSG_PUB.Delete_Msg;
1422: WHEN OTHERS THEN
1423: l_num_err_locations := l_num_err_locations + 1;
1424: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1425: FND_MSG_PUB.Reset;
1426: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1427: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1428: END LOOP;
1429: FND_MSG_PUB.Delete_Msg;
1430: END;
1423: l_num_err_locations := l_num_err_locations + 1;
1424: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1425: FND_MSG_PUB.Reset;
1426: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1427: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1428: END LOOP;
1429: FND_MSG_PUB.Delete_Msg;
1430: END;
1431:
1425: FND_MSG_PUB.Reset;
1426: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1427: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1428: END LOOP;
1429: FND_MSG_PUB.Delete_Msg;
1430: END;
1431:
1432: IF l_count_num_of_rec = l_commit_size THEN
1433: COMMIT;
1509: EXCEPTION
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: l_num_err_locations := l_num_err_locations + 1;
1512: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1513: FND_MSG_PUB.Reset;
1514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1515: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1516: END LOOP;
1517: FND_MSG_PUB.Delete_Msg;
1510: WHEN FND_API.G_EXC_ERROR THEN
1511: l_num_err_locations := l_num_err_locations + 1;
1512: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1513: FND_MSG_PUB.Reset;
1514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1515: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1516: END LOOP;
1517: FND_MSG_PUB.Delete_Msg;
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1511: l_num_err_locations := l_num_err_locations + 1;
1512: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1513: FND_MSG_PUB.Reset;
1514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1515: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1516: END LOOP;
1517: FND_MSG_PUB.Delete_Msg;
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: l_num_err_locations := l_num_err_locations + 1;
1513: FND_MSG_PUB.Reset;
1514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1515: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1516: END LOOP;
1517: FND_MSG_PUB.Delete_Msg;
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: l_num_err_locations := l_num_err_locations + 1;
1520: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1521: FND_MSG_PUB.Reset;
1517: FND_MSG_PUB.Delete_Msg;
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: l_num_err_locations := l_num_err_locations + 1;
1520: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1521: FND_MSG_PUB.Reset;
1522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1523: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1524: END LOOP;
1525: FND_MSG_PUB.Delete_Msg;
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: l_num_err_locations := l_num_err_locations + 1;
1520: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1521: FND_MSG_PUB.Reset;
1522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1523: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1524: END LOOP;
1525: FND_MSG_PUB.Delete_Msg;
1526: WHEN OTHERS THEN
1519: l_num_err_locations := l_num_err_locations + 1;
1520: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1521: FND_MSG_PUB.Reset;
1522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1523: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1524: END LOOP;
1525: FND_MSG_PUB.Delete_Msg;
1526: WHEN OTHERS THEN
1527: l_num_err_locations := l_num_err_locations + 1;
1521: FND_MSG_PUB.Reset;
1522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1523: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1524: END LOOP;
1525: FND_MSG_PUB.Delete_Msg;
1526: WHEN OTHERS THEN
1527: l_num_err_locations := l_num_err_locations + 1;
1528: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1529: FND_MSG_PUB.Reset;
1525: FND_MSG_PUB.Delete_Msg;
1526: WHEN OTHERS THEN
1527: l_num_err_locations := l_num_err_locations + 1;
1528: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1529: FND_MSG_PUB.Reset;
1530: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1531: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1532: END LOOP;
1533: FND_MSG_PUB.Delete_Msg;
1526: WHEN OTHERS THEN
1527: l_num_err_locations := l_num_err_locations + 1;
1528: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1529: FND_MSG_PUB.Reset;
1530: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1531: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1532: END LOOP;
1533: FND_MSG_PUB.Delete_Msg;
1534: END;
1527: l_num_err_locations := l_num_err_locations + 1;
1528: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1529: FND_MSG_PUB.Reset;
1530: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1531: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1532: END LOOP;
1533: FND_MSG_PUB.Delete_Msg;
1534: END;
1535:
1529: FND_MSG_PUB.Reset;
1530: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1531: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1532: END LOOP;
1533: FND_MSG_PUB.Delete_Msg;
1534: END;
1535:
1536: IF l_count_num_of_rec = l_commit_size THEN
1537: COMMIT;
1623: EXCEPTION
1624: WHEN FND_API.G_EXC_ERROR THEN
1625: l_num_err_locations := l_num_err_locations + 1;
1626: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1627: FND_MSG_PUB.Reset;
1628: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1629: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1630: END LOOP;
1631: FND_MSG_PUB.Delete_Msg;
1624: WHEN FND_API.G_EXC_ERROR THEN
1625: l_num_err_locations := l_num_err_locations + 1;
1626: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1627: FND_MSG_PUB.Reset;
1628: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1629: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1630: END LOOP;
1631: FND_MSG_PUB.Delete_Msg;
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: l_num_err_locations := l_num_err_locations + 1;
1626: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1627: FND_MSG_PUB.Reset;
1628: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1629: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1630: END LOOP;
1631: FND_MSG_PUB.Delete_Msg;
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1633: l_num_err_locations := l_num_err_locations + 1;
1627: FND_MSG_PUB.Reset;
1628: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1629: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1630: END LOOP;
1631: FND_MSG_PUB.Delete_Msg;
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1633: l_num_err_locations := l_num_err_locations + 1;
1634: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1635: FND_MSG_PUB.Reset;
1631: FND_MSG_PUB.Delete_Msg;
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1633: l_num_err_locations := l_num_err_locations + 1;
1634: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1635: FND_MSG_PUB.Reset;
1636: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1637: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1638: END LOOP;
1639: FND_MSG_PUB.Delete_Msg;
1632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1633: l_num_err_locations := l_num_err_locations + 1;
1634: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1635: FND_MSG_PUB.Reset;
1636: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1637: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1638: END LOOP;
1639: FND_MSG_PUB.Delete_Msg;
1640: WHEN OTHERS THEN
1633: l_num_err_locations := l_num_err_locations + 1;
1634: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1635: FND_MSG_PUB.Reset;
1636: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1637: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1638: END LOOP;
1639: FND_MSG_PUB.Delete_Msg;
1640: WHEN OTHERS THEN
1641: l_num_err_locations := l_num_err_locations + 1;
1635: FND_MSG_PUB.Reset;
1636: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1637: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1638: END LOOP;
1639: FND_MSG_PUB.Delete_Msg;
1640: WHEN OTHERS THEN
1641: l_num_err_locations := l_num_err_locations + 1;
1642: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1643: HZ_GNR_UTIL_PKG.out(SQLERRM);
1640: WHEN OTHERS THEN
1641: l_num_err_locations := l_num_err_locations + 1;
1642: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1643: HZ_GNR_UTIL_PKG.out(SQLERRM);
1644: FND_MSG_PUB.Reset;
1645: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1646: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1647: END LOOP;
1648: FND_MSG_PUB.Delete_Msg;
1641: l_num_err_locations := l_num_err_locations + 1;
1642: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1643: HZ_GNR_UTIL_PKG.out(SQLERRM);
1644: FND_MSG_PUB.Reset;
1645: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1646: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1647: END LOOP;
1648: FND_MSG_PUB.Delete_Msg;
1649: END;
1642: HZ_GNR_UTIL_PKG.out(l_curr_loc_msg_prefix ||' '|| l_cur_location_id);
1643: HZ_GNR_UTIL_PKG.out(SQLERRM);
1644: FND_MSG_PUB.Reset;
1645: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1646: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1647: END LOOP;
1648: FND_MSG_PUB.Delete_Msg;
1649: END;
1650:
1644: FND_MSG_PUB.Reset;
1645: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1646: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1647: END LOOP;
1648: FND_MSG_PUB.Delete_Msg;
1649: END;
1650:
1651: IF l_count_num_of_rec = l_commit_size THEN
1652: COMMIT;
1689: HZ_GNR_PKG.G_API_PURPOSE := NULL;
1690:
1691: HZ_GNR_UTIL_PKG.outandlog('Unknown Error at Location ID: ' || l_cur_location_id || ' : ' || SQLERRM);
1692: HZ_GNR_UTIL_PKG.outandlog('Error: Aborting Geo Name Referencing');
1693: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1694: HZ_GNR_UTIL_PKG.outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1695: END LOOP;
1696:
1697: retcode := 2;
1690:
1691: HZ_GNR_UTIL_PKG.outandlog('Unknown Error at Location ID: ' || l_cur_location_id || ' : ' || SQLERRM);
1692: HZ_GNR_UTIL_PKG.outandlog('Error: Aborting Geo Name Referencing');
1693: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
1694: HZ_GNR_UTIL_PKG.outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));
1695: END LOOP;
1696:
1697: retcode := 2;
1698: errbuf := 'Unexpected SQL Error at location id :' || l_cur_location_id;
2049: END IF;
2050: x_status := FND_API.G_RET_STS_ERROR;
2051: x_addr_val_status := FND_API.G_RET_STS_ERROR;
2052: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAP_FOR_COUNTRY');
2053: FND_MSG_PUB.ADD;
2054: RAISE FND_API.G_EXC_ERROR;
2055: ELSIF l_addr_val_level = 'NONE' THEN -- Validation level is set to none and no mapping for the country
2056: -- It is not required to do any further processing even for TAX.
2057: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2130: END IF;
2131: x_status := FND_API.G_RET_STS_ERROR;
2132: x_addr_val_status := FND_API.G_RET_STS_ERROR;
2133: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_USAGE_FOR_COUNTRY');
2134: FND_MSG_PUB.ADD;
2135: RAISE FND_API.G_EXC_ERROR;
2136: ELSIF l_addr_val_level = 'NONE' THEN -- Validation level is set to none and no usage defined for the country
2137: -- It is not required to do any further processing even for TAX.
2138: IF (l_usage_tbl(i).usage_code = 'TAX' OR i = l_usage_tbl.LAST) THEN
2398: END IF;
2399: x_status := FND_API.G_RET_STS_ERROR;
2400: x_addr_val_status := FND_API.G_RET_STS_ERROR;
2401: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_USAGE_FOR_COUNTRY');
2402: FND_MSG_PUB.ADD;
2403: RAISE FND_API.G_EXC_ERROR;
2404: ELSE
2405: NULL;
2406: END IF;