DBA Data[Home] [Help]

APPS.FTE_ACS_PKG dependencies on FND_MESSAGE

Line 271: l_fnd_message_name VARCHAR2(60);

267: WHERE rule_id IS NULL;
268:
269:
270: l_failed_entity_tab FTE_CS_TEMP_ENTITY_TAB;
271: l_fnd_message_name VARCHAR2(60);
272: l_exception_name VARCHAR2(60);
273: l_exception_message VARCHAR2(5000);
274:
275: l_exception_id NUMBER;

Line 310: l_fnd_message_name := 'WSH_SELECT_CARRIER_FAIL';

306:
307: IF (p_entity = 'DLVY') THEN
308:
309: IF p_caller = 'WSH_DLMG' THEN
310: l_fnd_message_name := 'WSH_SELECT_CARRIER_FAIL';
311: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
312: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
313: l_fnd_message_name := 'WSH_CARRIER_CREATE_DEL';
314: l_exception_name := 'WSH_CARRIER_CREATE_DEL';

Line 313: l_fnd_message_name := 'WSH_CARRIER_CREATE_DEL';

309: IF p_caller = 'WSH_DLMG' THEN
310: l_fnd_message_name := 'WSH_SELECT_CARRIER_FAIL';
311: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
312: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
313: l_fnd_message_name := 'WSH_CARRIER_CREATE_DEL';
314: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
315: END IF;
316:
317: -- Start Logging exceptions.

Line 321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);

317: -- Start Logging exceptions.
318: itr := l_failed_entity_tab.FIRST;
319: LOOP
320: l_exception_id := NULL;
321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);
323: l_exception_message := FND_MESSAGE.Get;
324:
325: wsh_xc_util.log_exception(p_api_version => 1.0,

Line 322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);

318: itr := l_failed_entity_tab.FIRST;
319: LOOP
320: l_exception_id := NULL;
321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);
323: l_exception_message := FND_MESSAGE.Get;
324:
325: wsh_xc_util.log_exception(p_api_version => 1.0,
326: x_return_status => l_return_status,

Line 323: l_exception_message := FND_MESSAGE.Get;

319: LOOP
320: l_exception_id := NULL;
321: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
322: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,l_failed_entity_tab(itr).delivery_id);
323: l_exception_message := FND_MESSAGE.Get;
324:
325: wsh_xc_util.log_exception(p_api_version => 1.0,
326: x_return_status => l_return_status,
327: x_msg_count => l_msg_count,

Line 349: l_fnd_message_name := 'WSH_ROUTE_TRIP_FAIL';

345:
346:
347: ELSIF (p_entity = 'TRIP') THEN
348:
349: l_fnd_message_name := 'WSH_ROUTE_TRIP_FAIL';
350: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
351: itr := l_failed_entity_tab.FIRST;
352:
353: LOOP

Line 355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);

351: itr := l_failed_entity_tab.FIRST;
352:
353: LOOP
354: l_exception_id := NULL;
355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);
357: l_exception_message := FND_MESSAGE.Get;
358:
359: wsh_xc_util.log_exception(p_api_version => 1.0,

Line 356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);

352:
353: LOOP
354: l_exception_id := NULL;
355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);
357: l_exception_message := FND_MESSAGE.Get;
358:
359: wsh_xc_util.log_exception(p_api_version => 1.0,
360: x_return_status => l_return_status,

Line 357: l_exception_message := FND_MESSAGE.Get;

353: LOOP
354: l_exception_id := NULL;
355: FND_MESSAGE.SET_NAME('WSH',l_fnd_message_name);
356: FND_MESSAGE.SET_TOKEN('TRIP_ID' ,l_failed_entity_tab(itr).trip_id);
357: l_exception_message := FND_MESSAGE.Get;
358:
359: wsh_xc_util.log_exception(p_api_version => 1.0,
360: x_return_status => l_return_status,
361: x_msg_count => l_msg_count,

Line 393: FND_MESSAGE.SET_NAME('WSH', 'WSH_SELECT_CARRIER_FAIL');

389: -- Result could not be found
390: IF (p_entity = 'DLVY') THEN
391:
392: IF p_caller = 'WSH_DLMG' THEN
393: FND_MESSAGE.SET_NAME('WSH', 'WSH_SELECT_CARRIER_FAIL');
394: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
395: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';

Line 396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');

392: IF p_caller = 'WSH_DLMG' THEN
393: FND_MESSAGE.SET_NAME('WSH', 'WSH_SELECT_CARRIER_FAIL');
394: l_exception_name := 'WSH_SELECT_CARRIER_FAIL';
395: ELSIF p_caller in ('WSH_AUTO_CREATE_DEL','WSH_PICK_RELEASE','WSH_AUTO_CREATE_DEL_TRIP') THEN
396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
398: END IF;
399:
400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);

Line 400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);

396: FND_MESSAGE.SET_NAME('WSH', 'WSH_CARRIER_CREATE_DEL');
397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
398: END IF;
399:
400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);
401: l_exception_message := FND_MESSAGE.Get;
402: l_exception_id := NULL;
403:
404: wsh_xc_util.log_exception(

Line 401: l_exception_message := FND_MESSAGE.Get;

397: l_exception_name := 'WSH_CARRIER_CREATE_DEL';
398: END IF;
399:
400: FND_MESSAGE.SET_TOKEN('DELIVERY_ID' ,p_single_rec.delivery_id);
401: l_exception_message := FND_MESSAGE.Get;
402: l_exception_id := NULL;
403:
404: wsh_xc_util.log_exception(
405: p_api_version => 1.0,

Line 423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');

419: ELSIF (p_entity = 'TRIP') THEN
420: --
421: -- For Trip we need to log the exception
422: --
423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');
424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);
425: -- Seed this exception
426: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
427: l_exception_message := FND_MESSAGE.GET;

Line 424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);

420: --
421: -- For Trip we need to log the exception
422: --
423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');
424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);
425: -- Seed this exception
426: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
427: l_exception_message := FND_MESSAGE.GET;
428: l_exception_id := NULL;

Line 427: l_exception_message := FND_MESSAGE.GET;

423: FND_MESSAGE.SET_NAME('WSH','WSH_ROUTE_TRIP_FAIL');
424: FND_MESSAGE.SET_TOKEN('TRIP_NAME',p_single_rec.trip_name);
425: -- Seed this exception
426: l_exception_name := 'WSH_ROUTE_TRIP_FAIL';
427: l_exception_message := FND_MESSAGE.GET;
428: l_exception_id := NULL;
429:
430: wsh_xc_util.log_exception(
431: p_api_version => 1.0,

Line 1159: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');

1155: -- Put Message on the stack and return
1156: -- We can have multirecords in this case
1157: --
1158:
1159: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_CS_NO_CARRIER_SELECTED');
1160: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1161: WSH_UTIL_CORE.add_message(x_return_status);
1162:
1163: END IF;