DBA Data[Home] [Help]

APPS.FTE_MLS_UTIL dependencies on FND_MESSAGE

Line 42: FND_MESSAGE.SET_NAME('FTE', p_message_name );

38: --{
39: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
40: THEN
41: --{
42: FND_MESSAGE.SET_NAME('FTE', p_message_name );
43: FND_MESSAGE.SET_TOKEN('PROGRAM_UNIT_NAME', p_api_name);
44: --
45: --
46: IF p_trip_segment_id IS NOT NULL

Line 43: FND_MESSAGE.SET_TOKEN('PROGRAM_UNIT_NAME', p_api_name);

39: IF p_api_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
40: THEN
41: --{
42: FND_MESSAGE.SET_NAME('FTE', p_message_name );
43: FND_MESSAGE.SET_TOKEN('PROGRAM_UNIT_NAME', p_api_name);
44: --
45: --
46: IF p_trip_segment_id IS NOT NULL
47: THEN

Line 48: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID', p_trip_segment_id);

44: --
45: --
46: IF p_trip_segment_id IS NOT NULL
47: THEN
48: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID', p_trip_segment_id);
49: END IF;
50: --
51: --
52: IF p_trip_segment_name IS NOT NULL

Line 54: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_name);

50: --
51: --
52: IF p_trip_segment_name IS NOT NULL
53: THEN
54: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME', p_trip_segment_name);
55: END IF;
56: --
57: --
58: IF p_trip_stop_id IS NOT NULL

Line 60: FND_MESSAGE.SET_TOKEN('STOP_ID', p_trip_stop_id);

56: --
57: --
58: IF p_trip_stop_id IS NOT NULL
59: THEN
60: FND_MESSAGE.SET_TOKEN('STOP_ID', p_trip_stop_id);
61: END IF;
62: --
63: --
64: IF p_stop_seq_number IS NOT NULL

Line 66: FND_MESSAGE.SET_TOKEN('STOP_SEQUENCE_NUMBER', p_stop_seq_number);

62: --
63: --
64: IF p_stop_seq_number IS NOT NULL
65: THEN
66: FND_MESSAGE.SET_TOKEN('STOP_SEQUENCE_NUMBER', p_stop_seq_number);
67: END IF;
68: --
69: --
70: IF p_trip_id IS NOT NULL

Line 72: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);

68: --
69: --
70: IF p_trip_id IS NOT NULL
71: THEN
72: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
73: END IF;
74: --
75: --
76: IF p_trip_name IS NOT NULL

Line 78: FND_MESSAGE.SET_TOKEN('TRIP_NAME', p_trip_name);

74: --
75: --
76: IF p_trip_name IS NOT NULL
77: THEN
78: FND_MESSAGE.SET_TOKEN('TRIP_NAME', p_trip_name);
79: END IF;
80: --
81: --
82: IF p_delivery_id IS NOT NULL

Line 84: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id);

80: --
81: --
82: IF p_delivery_id IS NOT NULL
83: THEN
84: FND_MESSAGE.SET_TOKEN('DELIVERY_ID', p_delivery_id);
85: END IF;
86: --
87: --
88: IF p_delivery_name IS NOT NULL

Line 90: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_name);

86: --
87: --
88: IF p_delivery_name IS NOT NULL
89: THEN
90: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME', p_delivery_name);
91: END IF;
92: --
93: --
94: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR);

Line 157: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');

153: EXCEPTION
154: --{
155: WHEN OTHERS THEN
156: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_TRIP_SEGMENT_NAME');
157: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
158: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
159: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
161: --}

Line 158: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);

154: --{
155: WHEN OTHERS THEN
156: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_TRIP_SEGMENT_NAME');
157: FND_MESSAGE.SET_NAME('FTE','FTE_GET_TRIP_SEG_NAME_ERROR');
158: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_segment_id);
159: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
161: --}
162: END get_trip_segment_name;

Line 308: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');

304: EXCEPTION
305: --{
306: WHEN OTHERS THEN
307: wsh_util_core.default_handler('WSH_MLS_UTIL.GET_NEXT_SEGMENT_ID');
308: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
309: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
310: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
311: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 309: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);

305: --{
306: WHEN OTHERS THEN
307: wsh_util_core.default_handler('WSH_MLS_UTIL.GET_NEXT_SEGMENT_ID');
308: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
309: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
310: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
311: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
313: --}

Line 310: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);

306: WHEN OTHERS THEN
307: wsh_util_core.default_handler('WSH_MLS_UTIL.GET_NEXT_SEGMENT_ID');
308: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
309: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
310: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
311: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
312: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
313: --}
314: END get_next_segment_id;

Line 422: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');

418: EXCEPTION
419: --{
420: WHEN OTHERS THEN
421: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PREVIOUS_SEGMENT_ID');
422: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
423: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
424: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
425: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 423: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);

419: --{
420: WHEN OTHERS THEN
421: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PREVIOUS_SEGMENT_ID');
422: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
423: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
424: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
425: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
427: --}

Line 424: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);

420: WHEN OTHERS THEN
421: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_PREVIOUS_SEGMENT_ID');
422: FND_MESSAGE.SET_NAME('FTE','FTE_GET_NEXT_SEGMENT_ERROR');
423: FND_MESSAGE.SET_TOKEN('TRIP_NAME',x_trip_name);
424: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
425: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
426: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
427: --}
428: END get_previous_segment_id;

Line 506: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');

502: EXCEPTION
503: --{
504: WHEN OTHERS THEN
505: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_FIRST_STOP_LOCATION_ID');
506: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
507: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
508: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
510: --}

Line 507: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);

503: --{
504: WHEN OTHERS THEN
505: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_FIRST_STOP_LOCATION_ID');
506: FND_MESSAGE.SET_NAME('FTE','FTE_GET_FIRST_STOP_ERROR');
507: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
508: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
509: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
510: --}
511: END get_first_stop_location_id;

Line 589: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');

585: EXCEPTION
586: --{
587: WHEN OTHERS THEN
588: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LAST_STOP_LOCATION_ID');
589: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
590: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
591: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
593: --}

Line 590: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);

586: --{
587: WHEN OTHERS THEN
588: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LAST_STOP_LOCATION_ID');
589: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LAST_STOP_ERROR');
590: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',x_trip_segment_name);
591: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
592: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
593: --}
594: END get_last_stop_location_id;

Line 1315: FND_MESSAGE.SET_NAME('FTE','FTE_GET_SHIPMETHOD_UNEXP_ERROR');

1311: EXCEPTION
1312: --{
1313: WHEN OTHERS THEN
1314: wsh_util_core.default_handler('FTE_MLS_UTIL.DERIVE_SHIP_METHOD_CODE');
1315: FND_MESSAGE.SET_NAME('FTE','FTE_GET_SHIPMETHOD_UNEXP_ERROR');
1316: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',p_carrier_name);
1317: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',NVL(p_mode_of_transport_meaning,'NULL'));
1318: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',NVL(p_service_level_meaning,'NULL'));
1319: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

Line 1316: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',p_carrier_name);

1312: --{
1313: WHEN OTHERS THEN
1314: wsh_util_core.default_handler('FTE_MLS_UTIL.DERIVE_SHIP_METHOD_CODE');
1315: FND_MESSAGE.SET_NAME('FTE','FTE_GET_SHIPMETHOD_UNEXP_ERROR');
1316: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',p_carrier_name);
1317: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',NVL(p_mode_of_transport_meaning,'NULL'));
1318: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',NVL(p_service_level_meaning,'NULL'));
1319: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1320: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1317: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',NVL(p_mode_of_transport_meaning,'NULL'));

1313: WHEN OTHERS THEN
1314: wsh_util_core.default_handler('FTE_MLS_UTIL.DERIVE_SHIP_METHOD_CODE');
1315: FND_MESSAGE.SET_NAME('FTE','FTE_GET_SHIPMETHOD_UNEXP_ERROR');
1316: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',p_carrier_name);
1317: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',NVL(p_mode_of_transport_meaning,'NULL'));
1318: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',NVL(p_service_level_meaning,'NULL'));
1319: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1320: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1321: --}

Line 1318: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',NVL(p_service_level_meaning,'NULL'));

1314: wsh_util_core.default_handler('FTE_MLS_UTIL.DERIVE_SHIP_METHOD_CODE');
1315: FND_MESSAGE.SET_NAME('FTE','FTE_GET_SHIPMETHOD_UNEXP_ERROR');
1316: FND_MESSAGE.SET_TOKEN('CARRIER_NAME',p_carrier_name);
1317: FND_MESSAGE.SET_TOKEN('MODE_OF_TRANSPORT',NVL(p_mode_of_transport_meaning,'NULL'));
1318: FND_MESSAGE.SET_TOKEN('SERVICE_LEVEL',NVL(p_service_level_meaning,'NULL'));
1319: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1320: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1321: --}
1322: END derive_ship_method;

Line 1385: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LOCATION_UNEXP_ERROR');

1381: EXCEPTION
1382: --{
1383: WHEN OTHERS THEN
1384: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LOCATION');
1385: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LOCATION_UNEXP_ERROR');
1386: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1387: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1388: --}
1389: END get_location_info;

Line 1660: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LOCATION_UNEXP_ERROR');

1656: EXCEPTION
1657: --{
1658: WHEN OTHERS THEN
1659: wsh_util_core.default_handler('FTE_MLS_UTIL.GET_LOCATION');
1660: FND_MESSAGE.SET_NAME('FTE','FTE_GET_LOCATION_UNEXP_ERROR');
1661: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1663: --}
1664: END get_location_info;

Line 1740: FND_MESSAGE.SET_NAME('FTE', 'FTE_DELIVERIES_MULTIPLE_NA');

1736: x_msg_count := 0;
1737: x_msg_data := 0;
1738:
1739: -- get default no contact info message
1740: FND_MESSAGE.SET_NAME('FTE', 'FTE_DELIVERIES_MULTIPLE_NA');
1741: l_na_mssg := FND_MESSAGE.GET;
1742:
1743: -- get contact id
1744: FOR get_contact_id_rec IN get_contact_id_cur(p_tender_number)

Line 1741: l_na_mssg := FND_MESSAGE.GET;

1737: x_msg_data := 0;
1738:
1739: -- get default no contact info message
1740: FND_MESSAGE.SET_NAME('FTE', 'FTE_DELIVERIES_MULTIPLE_NA');
1741: l_na_mssg := FND_MESSAGE.GET;
1742:
1743: -- get contact id
1744: FOR get_contact_id_rec IN get_contact_id_cur(p_tender_number)
1745: LOOP

Line 1758: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_CARRIER_CONTACT');

1754: END IF;
1755: --
1756: IF (l_contact_id IS NULL)
1757: THEN
1758: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_CARRIER_CONTACT');
1759: FND_MESSAGE.SET_TOKEN('TENDER_NUMBER',p_tender_number);
1760: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1761: RAISE FND_API.G_EXC_ERROR;
1762: END IF;

Line 1759: FND_MESSAGE.SET_TOKEN('TENDER_NUMBER',p_tender_number);

1755: --
1756: IF (l_contact_id IS NULL)
1757: THEN
1758: FND_MESSAGE.SET_NAME('FTE','FTE_INVLD_CARRIER_CONTACT');
1759: FND_MESSAGE.SET_TOKEN('TENDER_NUMBER',p_tender_number);
1760: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1761: RAISE FND_API.G_EXC_ERROR;
1762: END IF;
1763:

Line 2010: FND_MESSAGE.SET_NAME('FTE', 'FTE_DELIVERIES_MULTIPLE_NA');

2006: x_msg_count := 0;
2007: x_msg_data := 0;
2008:
2009: -- get default no contact info message
2010: FND_MESSAGE.SET_NAME('FTE', 'FTE_DELIVERIES_MULTIPLE_NA');
2011: l_na_mssg := FND_MESSAGE.GET;
2012:
2013: -- get contact inf
2014:

Line 2011: l_na_mssg := FND_MESSAGE.GET;

2007: x_msg_data := 0;
2008:
2009: -- get default no contact info message
2010: FND_MESSAGE.SET_NAME('FTE', 'FTE_DELIVERIES_MULTIPLE_NA');
2011: l_na_mssg := FND_MESSAGE.GET;
2012:
2013: -- get contact inf
2014:
2015: FOR get_shipper_contact_rec IN get_shipper_contact_cur(p_shipper_name)

Line 2664: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_NOTFOUND');

2660: END IF;
2661:
2662: EXCEPTION
2663: WHEN NO_DATA_FOUND THEN
2664: FND_MESSAGE.SET_NAME('FTE','FTE_ORG_NOTFOUND');
2665: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2666: wsh_util_core.add_message(x_return_status);
2667: END;
2668:

Line 2935: FND_MESSAGE.SET_NAME('FTE','FTE_VENDORSITE_NOT_FOUND');

2931: FETCH GET_VENDOR_SITE_ID_FOR_TRIP INTO l_vendor_site_id, l_currency_code,
2932: l_vendor_id,l_carrier_site_id;
2933:
2934: IF (GET_VENDOR_SITE_ID_FOR_TRIP%NOTFOUND) THEN
2935: FND_MESSAGE.SET_NAME('FTE','FTE_VENDORSITE_NOT_FOUND');
2936: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2937: wsh_util_core.add_message(x_return_status);
2938: END IF;
2939:

Line 2961: FND_MESSAGE.SET_NAME('FTE','FTE_VENDORSITE_NOT_FOUND');

2957:
2958:
2959:
2960: IF (GET_VENDOR_SITE_ID_FOR_DLVY%NOTFOUND) THEN
2961: FND_MESSAGE.SET_NAME('FTE','FTE_VENDORSITE_NOT_FOUND');
2962: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2963: wsh_util_core.add_message(x_return_status);
2964: END IF;
2965: