eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_GNR_PKG dependencies on FND_MSG_PUB

Line 192: FND_MSG_PUB.initialize;

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

Line 199: FND_MSG_PUB.ADD;

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

Line 206: FND_MSG_PUB.ADD;

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:

Line 225: FND_MSG_PUB.ADD;

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

Line 235: FND_MSG_PUB.ADD;

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;

Line 249: FND_MSG_PUB.ADD;

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

Line 259: FND_MSG_PUB.ADD;

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;

Line 271: FND_MSG_PUB.ADD;

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

Line 284: FND_MSG_PUB.ADD;

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:

Line 302: FND_MSG_PUB.ADD;

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:

Line 317: FND_MSG_PUB.ADD;

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:

Line 934: FND_MSG_PUB.initialize;

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:

Line 998: FND_MSG_PUB.Reset;

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;

Line 999: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1000: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1002: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1007: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1008: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1010: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1015: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1016: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1018: FND_MSG_PUB.Delete_Msg;

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;

Line 1083: FND_MSG_PUB.Reset;

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;

Line 1084: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1085: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1087: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1092: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1093: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1095: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1100: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1101: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1103: FND_MSG_PUB.Delete_Msg;

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;

Line 1168: FND_MSG_PUB.Reset;

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;

Line 1169: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1170: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1172: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1177: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1178: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1180: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1185: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1186: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1188: FND_MSG_PUB.Delete_Msg;

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;

Line 1288: FND_MSG_PUB.Reset;

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;

Line 1289: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1290: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1292: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1297: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1298: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1300: FND_MSG_PUB.Delete_Msg;

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);

Line 1305: FND_MSG_PUB.Reset;

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;

Line 1306: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1307: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1309: FND_MSG_PUB.Delete_Msg;

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);

Line 1321: FND_MSG_PUB.Reset;

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;

Line 1322: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1323: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1325: FND_MSG_PUB.Delete_Msg;

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;

Line 1409: FND_MSG_PUB.Reset;

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;

Line 1410: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1411: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1413: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1418: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1419: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1421: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1426: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1427: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1429: FND_MSG_PUB.Delete_Msg;

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;

Line 1513: FND_MSG_PUB.Reset;

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;

Line 1514: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1515: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1517: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1522: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1523: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1525: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1530: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1531: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1533: FND_MSG_PUB.Delete_Msg;

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;

Line 1627: FND_MSG_PUB.Reset;

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;

Line 1628: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1629: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1631: FND_MSG_PUB.Delete_Msg;

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;

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

Line 1636: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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

Line 1637: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 1639: FND_MSG_PUB.Delete_Msg;

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);

Line 1644: FND_MSG_PUB.Reset;

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;

Line 1645: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1646: HZ_GNR_UTIL_PKG.out(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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:

Line 1648: FND_MSG_PUB.Delete_Msg;

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;

Line 1693: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

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;

Line 1694: HZ_GNR_UTIL_PKG.outandlog(FND_MSG_PUB.Get(p_encoded => FND_API.G_FALSE ));

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;

Line 2053: FND_MSG_PUB.ADD;

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

Line 2134: FND_MSG_PUB.ADD;

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

Line 2402: FND_MSG_PUB.ADD;

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;