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_MESSAGE

Line 198: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_MAND');

194: -- Validate location table name
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',

Line 205: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');

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

Line 224: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TO_LOC_NOT_NULL');

220: -- OR both location id from and location id to should be null
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;

Line 234: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_FROM_LOC_HIGHER');

230: IF l_to_location_id IS NULL THEN
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;

Line 248: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_TO_DATE_NOT_NULL');

244: -- OR both Start date and End date should be null
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;

Line 258: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_START_DATE_HIGHER');

254: IF l_end_date IS NULL THEN
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;

Line 270: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_RUN_TYPE');

266: -- 1. Run Type is Mandatory.
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(*)

Line 283: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_RUN_TYPE');

279: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
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;

Line 301: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_INVALID_USAGE_CODE');

297: AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE+1)
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;

Line 316: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NOT_VALID_COUNTRY');

312: WHERE territory_code = p_country_code
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;

Line 351: HZ_GNR_UTIL_PKG.log(fnd_message.get);

347: to_char(l_num_of_workers)
348: );
349: IF l_sub_requests(i) = 0 THEN
350: HZ_GNR_UTIL_PKG.log('Error submitting worker ' || i);
351: HZ_GNR_UTIL_PKG.log(fnd_message.get);
352: ELSE
353: HZ_GNR_UTIL_PKG.log('Submitted request for Worker ' || TO_CHAR(i) );
354: HZ_GNR_UTIL_PKG.log('Request ID : ' || l_sub_requests(i));
355: END IF;

Line 936: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_CUR_LOC_PREFIX');

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:
939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');
940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;

Line 937: l_curr_loc_msg_prefix := FND_MESSAGE.GET;

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:
939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');
940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;
941:

Line 939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');

935:
936: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_CUR_LOC_PREFIX');
937: l_curr_loc_msg_prefix := FND_MESSAGE.GET;
938:
939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');
940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;
941:
942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');
943: l_err_loc_msg_prefix := FND_MESSAGE.GET;

Line 940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;

936: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_CUR_LOC_PREFIX');
937: l_curr_loc_msg_prefix := FND_MESSAGE.GET;
938:
939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');
940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;
941:
942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');
943: l_err_loc_msg_prefix := FND_MESSAGE.GET;
944:

Line 942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');

938:
939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');
940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;
941:
942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');
943: l_err_loc_msg_prefix := FND_MESSAGE.GET;
944:
945: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUCC_LOC_PREFIX');
946: l_success_loc_msg_prefix := FND_MESSAGE.GET;

Line 943: l_err_loc_msg_prefix := FND_MESSAGE.GET;

939: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUM_LOC_PREFIX');
940: l_summ_loc_msg_prefix := FND_MESSAGE.GET;
941:
942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');
943: l_err_loc_msg_prefix := FND_MESSAGE.GET;
944:
945: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUCC_LOC_PREFIX');
946: l_success_loc_msg_prefix := FND_MESSAGE.GET;
947:

Line 945: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUCC_LOC_PREFIX');

941:
942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');
943: l_err_loc_msg_prefix := FND_MESSAGE.GET;
944:
945: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUCC_LOC_PREFIX');
946: l_success_loc_msg_prefix := FND_MESSAGE.GET;
947:
948: -- Depending on the location table name passed
949: -- open the appropriate cursor and call the gnr api.

Line 946: l_success_loc_msg_prefix := FND_MESSAGE.GET;

942: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_ERR_LOC_PREFIX');
943: l_err_loc_msg_prefix := FND_MESSAGE.GET;
944:
945: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_SUCC_LOC_PREFIX');
946: l_success_loc_msg_prefix := FND_MESSAGE.GET;
947:
948: -- Depending on the location table name passed
949: -- open the appropriate cursor and call the gnr api.
950: -- Commit as per commit size applicable to number of

Line 2052: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_MAP_FOR_COUNTRY');

2048: );
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.

Line 2133: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_USAGE_FOR_COUNTRY');

2129: );
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.

Line 2401: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_NO_USAGE_FOR_COUNTRY');

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