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.WSH_DELIVERY_LEGS_ACTIONS dependencies on FND_MESSAGE

Line 488: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DROP_NOTINT');

484: --which are not the same internal loc being assigned to the trip
485: IF l_trip_dropoff_loc_id IS NOT NULL AND
486: l_phys_trip_dropoff_loc_id IS NOT NULL AND
487: l_dropoff_location_id <> l_trip_dropoff_loc_id THEN
488: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DROP_NOTINT');
489: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
490: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
491: goto skip_delivery;
492: END IF;

Line 489: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);

485: IF l_trip_dropoff_loc_id IS NOT NULL AND
486: l_phys_trip_dropoff_loc_id IS NOT NULL AND
487: l_dropoff_location_id <> l_trip_dropoff_loc_id THEN
488: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_DROP_NOTINT');
489: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
490: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
491: goto skip_delivery;
492: END IF;
493:

Line 513: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');

509: goto loop_end1;
510:
511: <>
512:
513: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');
514: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
516: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
517: l_num_error := l_num_error + 1;

Line 514: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);

510:
511: <>
512:
513: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');
514: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
516: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
517: l_num_error := l_num_error + 1;
518:

Line 515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

511: <>
512:
513: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');
514: FND_MESSAGE.SET_TOKEN('DEL_NAME',l_delivery_name);
515: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
516: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
517: l_num_error := l_num_error + 1;
518:
519: <>

Line 702: FND_MESSAGE.Set_Name('WSH', 'WSH_RATE_MIXED_TRIP_WARN');

698: -- the above call.
699:
700:
701: -- Raise Warning
702: FND_MESSAGE.Set_Name('WSH', 'WSH_RATE_MIXED_TRIP_WARN');
703: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING, l_module_name);
704: l_num_warn := l_num_warn + 1;
705:
706: -- Log Exception

Line 709: l_msg := FND_MESSAGE.Get_String('WSH', 'WSH_RATE_MIXED_TRIP_EXC');

705:
706: -- Log Exception
707:
708: l_exception_name := 'WSH_RATE_MIXED_TRIP';
709: l_msg := FND_MESSAGE.Get_String('WSH', 'WSH_RATE_MIXED_TRIP_EXC');
710:
711:
712: wsh_xc_util.log_exception(
713: p_api_version => 1.0,

Line 972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');

968: CLOSE c_check_dummystops;
969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
974: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
975: RAISE e_InvalidDelExcep; -- Bug 5336308
976: END IF;

Line 973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

969: IF l_debug_on THEN
970: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
973: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
974: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
975: RAISE e_InvalidDelExcep; -- Bug 5336308
976: END IF;
977: CLOSE c_check_dummystops;

Line 1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');

1390: CLOSE c_check_dummystops;
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1396: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1397: RAISE e_InvalidDelExcep; -- Bug 5336308
1398: END IF;

Line 1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_trips_pvt.get_name',WSH_DEBUG_SV.C_PROC_LEVEL);
1393: END IF;
1394: FND_MESSAGE.SET_NAME('WSH','WSH_FIRMTRIP_NO_NEW_STOP');
1395: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1396: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1397: RAISE e_InvalidDelExcep; -- Bug 5336308
1398: END IF;
1399: CLOSE c_check_dummystops;

Line 1577: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_PLANNED_DATE');

1573: -- as long as p_pickup_arr_date >= p_dropoff_arr_date
1574: IF (p_pickup_dep_date > p_dropoff_arr_date) OR
1575: ((p_pickup_dep_date = p_dropoff_arr_date) AND (p_pickup_arr_date >= p_dropoff_arr_date))
1576: THEN
1577: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_PLANNED_DATE');
1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date));
1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date));
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1581: l_num_error := l_num_error + 1;

Line 1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date));

1574: IF (p_pickup_dep_date > p_dropoff_arr_date) OR
1575: ((p_pickup_dep_date = p_dropoff_arr_date) AND (p_pickup_arr_date >= p_dropoff_arr_date))
1576: THEN
1577: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_PLANNED_DATE');
1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date));
1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date));
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1581: l_num_error := l_num_error + 1;
1582: RAISE e_CommonExcep; -- Bug 5336308

Line 1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date));

1575: ((p_pickup_dep_date = p_dropoff_arr_date) AND (p_pickup_arr_date >= p_dropoff_arr_date))
1576: THEN
1577: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_PLANNED_DATE');
1578: FND_MESSAGE.SET_TOKEN('PICKUP_DATE', fnd_date.date_to_displaydt(l_pickup_dep_date));
1579: FND_MESSAGE.SET_TOKEN('DROPOFF_DATE', fnd_date.date_to_displaydt(l_dropoff_arr_date));
1580: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1581: l_num_error := l_num_error + 1;
1582: RAISE e_CommonExcep; -- Bug 5336308
1583: END IF;

Line 1596: FND_MESSAGE.Set_Name('WSH', 'WSH_PICKUP_STOP_SEQUENCE');

1592: WSH_DEBUG_SV.log(l_module_name,'l_dropoff_stop_seq', l_dropoff_stop_seq);
1593: END IF;
1594:
1595: IF l_pickup_stop_seq >= l_dropoff_stop_seq THEN
1596: FND_MESSAGE.Set_Name('WSH', 'WSH_PICKUP_STOP_SEQUENCE');
1597: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
1598: l_num_error := l_num_error + 1;
1599: RAISE e_CommonExcep; -- Bug 5336308
1600: END IF;

Line 1620: FND_MESSAGE.SET_NAME('WSH','WSH_LEG_NOT_FOUND');

1616: set pick_up_stop_id = l_pickup_stop_id
1617: where delivery_leg_id = l_leg_id;
1618:
1619: IF (SQL%NOTFOUND) THEN
1620: FND_MESSAGE.SET_NAME('WSH','WSH_LEG_NOT_FOUND');
1621: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1622: wsh_util_core.add_message(x_return_status);
1623: RAISE e_CommonExcep; -- Bug 5336308
1624: END IF;

Line 1668: FND_MESSAGE.SET_NAME('WSH','WSH_LEG_NOT_FOUND');

1664: set drop_off_stop_id = l_dropoff_stop_id
1665: where delivery_leg_id = l_leg_id;
1666:
1667: IF (SQL%NOTFOUND) THEN
1668: FND_MESSAGE.SET_NAME('WSH','WSH_LEG_NOT_FOUND');
1669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1670: wsh_util_core.add_message(x_return_status);
1671: RAISE e_CommonExcep; -- Bug 5336308
1672: END IF;

Line 1953: FND_MESSAGE.SET_NAME(l_dlvy_trip_tbl(1).r_message_appl,l_dlvy_trip_tbl(1).r_message_code);

1949: x_msg_data => l_msg_data);
1950:
1951: IF l_dlvy_trip_tbl(1).r_message_type IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)
1952: OR l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
1953: FND_MESSAGE.SET_NAME(l_dlvy_trip_tbl(1).r_message_appl,l_dlvy_trip_tbl(1).r_message_code);
1954: IF l_dlvy_trip_tbl(1).r_message_token IS NOT NULL THEN
1955: FND_MESSAGE.SET_TOKEN(l_dlvy_trip_tbl(1).r_message_token_name, l_dlvy_trip_tbl(1).r_message_token);
1956: END IF;
1957: WSH_UTIL_CORE.ADD_MESSAGE(l_dlvy_trip_tbl(1).r_message_type);

Line 1955: FND_MESSAGE.SET_TOKEN(l_dlvy_trip_tbl(1).r_message_token_name, l_dlvy_trip_tbl(1).r_message_token);

1951: IF l_dlvy_trip_tbl(1).r_message_type IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)
1952: OR l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
1953: FND_MESSAGE.SET_NAME(l_dlvy_trip_tbl(1).r_message_appl,l_dlvy_trip_tbl(1).r_message_code);
1954: IF l_dlvy_trip_tbl(1).r_message_token IS NOT NULL THEN
1955: FND_MESSAGE.SET_TOKEN(l_dlvy_trip_tbl(1).r_message_token_name, l_dlvy_trip_tbl(1).r_message_token);
1956: END IF;
1957: WSH_UTIL_CORE.ADD_MESSAGE(l_dlvy_trip_tbl(1).r_message_type);
1958: RAISE e_InvalidDelExcep; -- Bug 5336308
1959: END IF;

Line 1971: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');

1967: --
1968: WHEN e_InvalidDelExcep THEN
1969: --
1970: ROLLBACK TO ASSIGN_DEL_TO_TRIP;
1971: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_ERROR');
1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: END IF;
1975: --

Line 1976: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_rows(i)));

1972: IF l_debug_on THEN
1973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1974: END IF;
1975: --
1976: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_rows(i)));
1977: -- Bug 3439165
1978: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1979: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1980: l_num_error := l_num_error + 1;

Line 1978: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

1974: END IF;
1975: --
1976: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_rows(i)));
1977: -- Bug 3439165
1978: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
1979: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
1980: l_num_error := l_num_error + 1;
1981: --
1982: WHEN e_CommonExcep THEN

Line 2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');

2339: --
2340: IF (l_num_error > 0) THEN
2341: IF (p_del_rows.count > 1) THEN
2342:
2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');
2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);
2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2347:

Line 2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);

2340: IF (l_num_error > 0) THEN
2341: IF (p_del_rows.count > 1) THEN
2342:
2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');
2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);
2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2347:
2348: IF (l_num_error = p_del_rows.count) THEN

Line 2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);

2341: IF (p_del_rows.count > 1) THEN
2342:
2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');
2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);
2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2347:
2348: IF (l_num_error = p_del_rows.count) THEN
2349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

2342:
2343: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGN_SUMMARY');
2344: FND_MESSAGE.SET_TOKEN('NUM_ERROR',l_num_error);
2345: FND_MESSAGE.SET_TOKEN('NUM_SUCCESS',p_del_rows.count-l_num_error);
2346: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
2347:
2348: IF (l_num_error = p_del_rows.count) THEN
2349: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2350: ELSE

Line 2536: FND_MESSAGE.SET_NAME('WSH', 'WSH_REPRICE_REQUIRED_ERR');

2532: END IF;
2533: IF c_next_seq_exists%ISOPEN THEN
2534: close c_next_seq_exists;
2535: END IF;
2536: FND_MESSAGE.SET_NAME('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2537: WSH_UTIL_CORE.add_message(l_return_status);
2538: x_return_status := l_return_status;
2539: --
2540: --

Line 2592: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TRIP');

2588: END IF;
2589: IF c_next_seq_exists%ISOPEN THEN
2590: close c_next_seq_exists;
2591: END IF;
2592: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_TRIP');
2593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2594: wsh_util_core.add_message(x_return_status);
2595: --
2596: -- K LPN CONV. rv

Line 2648: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

2644: END IF;
2645: IF c_next_seq_exists%ISOPEN THEN
2646: close c_next_seq_exists;
2647: END IF;
2648: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
2649: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2650: wsh_util_core.add_message(x_return_status);
2651: --
2652: --

Line 2705: FND_MESSAGE.Set_Name('WSH', 'WSH_RATE_TRIP_CONTENTS_FAIL');

2701: IF c_next_seq_exists%ISOPEN THEN
2702: close c_next_seq_exists;
2703: END IF;
2704: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2705: FND_MESSAGE.Set_Name('WSH', 'WSH_RATE_TRIP_CONTENTS_FAIL');
2706: WSH_UTIL_CORE.Add_Message(x_return_status);
2707: --
2708: -- K LPN CONV. rv
2709: --

Line 2758: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');

2754: END IF;
2755:
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2757:
2758: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
2759: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR, l_module_name);
2760: IF l_debug_on THEN
2761: WSH_DEBUG_SV.logmsg(l_module_name,'e_lock_error' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2762: END IF;

Line 3041: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_ERROR');

3037: -- Bug 2307456, allow this action for status of SR and SC
3038:
3039: -- Check if the delivery is in a valid status.
3040: IF l_del_status IN ( 'CA') THEN
3041: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_ERROR');
3042: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3043: wsh_util_core.add_message(l_return_status);
3044: END IF;
3045: --

Line 3049: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_ERROR');

3045: --
3046:
3047: IF l_del_status = 'CL'
3048: THEN
3049: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_ERROR');
3050: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3051: wsh_util_core.add_message(l_return_status);
3052: END IF;
3053: --

Line 3064: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

3060: FETCH del_pickup_exists INTO l_del_leg_id;
3061: CLOSE del_pickup_exists;
3062:
3063: IF (l_del_leg_id IS NULL) THEN
3064: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
3065: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3066: wsh_util_core.add_message(l_return_status);
3067: END IF;
3068:

Line 3076: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');

3072: FETCH del_dropoff_exists INTO l_del_leg_id;
3073: CLOSE del_dropoff_exists;
3074:
3075: IF (l_del_leg_id IS NULL) THEN
3076: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_FOUND');
3077: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3078: wsh_util_core.add_message(l_return_status);
3079: END IF;
3080:

Line 3087: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');

3083: FETCH del_trip_exists INTO l_del_leg_id, l_stop_pu_location_id;
3084: CLOSE del_trip_exists;
3085:
3086: IF (l_del_leg_id IS NULL) THEN
3087: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_NOT_FOUND');
3088: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3089: wsh_util_core.add_message(l_return_status);
3090: END IF;
3091:

Line 3136: FND_MESSAGE.SET_NAME(l_dlvy_trip_tbl(1).r_message_appl,l_dlvy_trip_tbl(1).r_message_code);

3132: x_msg_count => l_msg_count,
3133: x_msg_data => l_msg_data);
3134: IF l_dlvy_trip_tbl(1).r_message_type IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)
3135: OR l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
3136: FND_MESSAGE.SET_NAME(l_dlvy_trip_tbl(1).r_message_appl,l_dlvy_trip_tbl(1).r_message_code);
3137: IF l_dlvy_trip_tbl(1).r_message_token IS NOT NULL THEN
3138: FND_MESSAGE.SET_TOKEN(l_dlvy_trip_tbl(1).r_message_token_name, l_dlvy_trip_tbl(1).r_message_token);
3139: END IF;
3140: WSH_UTIL_CORE.ADD_MESSAGE(l_dlvy_trip_tbl(1).r_message_type);

Line 3138: FND_MESSAGE.SET_TOKEN(l_dlvy_trip_tbl(1).r_message_token_name, l_dlvy_trip_tbl(1).r_message_token);

3134: IF l_dlvy_trip_tbl(1).r_message_type IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)
3135: OR l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR ) THEN
3136: FND_MESSAGE.SET_NAME(l_dlvy_trip_tbl(1).r_message_appl,l_dlvy_trip_tbl(1).r_message_code);
3137: IF l_dlvy_trip_tbl(1).r_message_token IS NOT NULL THEN
3138: FND_MESSAGE.SET_TOKEN(l_dlvy_trip_tbl(1).r_message_token_name, l_dlvy_trip_tbl(1).r_message_token);
3139: END IF;
3140: WSH_UTIL_CORE.ADD_MESSAGE(l_dlvy_trip_tbl(1).r_message_type);
3141: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3142: l_num_error := l_num_error + 1;

Line 3429: FND_MESSAGE.SET_NAME('FND','FORM_UNABLE_TO_RESERVE_RECORD');

3425: WHEN lock_error THEN
3426: IF c_is_first_leg%isopen THEN
3427: close c_is_first_leg;
3428: END IF;
3429: FND_MESSAGE.SET_NAME('FND','FORM_UNABLE_TO_RESERVE_RECORD');
3430: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3431: wsh_util_core.add_message(x_return_status);
3432: --
3433: -- K LPN CONV. rv

Line 3476: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_ERROR');

3472: WHEN cannot_unassign THEN
3473: IF c_is_first_leg%isopen THEN
3474: close c_is_first_leg;
3475: END IF;
3476: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_ERROR');
3477: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3478: wsh_util_core.add_message(x_return_status);
3479: --
3480: -- K LPN CONV. rv

Line 3951: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LEG_LOCKED');

3947: IF c_lock_delivery_leg%ISOPEN THEN
3948: CLOSE c_lock_delivery_leg;
3949: END IF;
3950: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3951: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LEG_LOCKED');
3952: WSH_UTIL_CORE.Add_Message(x_return_status);
3953: IF l_debug_on THEN
3954: WSH_DEBUG_SV.logmsg(l_module_name,'DELIVERY_LEG_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3955: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_LEG_LOCKED');

Line 3982: FND_MESSAGE.Set_Name('WSH', 'WSH_PUB_INVALID_PARAMETER');

3978: EXCEPTION
3979:
3980: WHEN invalid_parameter THEN
3981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3982: FND_MESSAGE.Set_Name('WSH', 'WSH_PUB_INVALID_PARAMETER');
3983: FND_MESSAGE.Set_Token('PARAMETER', 'P_ENTITY_TYPE');
3984: WSH_UTIL_CORE.Add_Message(x_return_status);
3985:
3986: --

Line 3983: FND_MESSAGE.Set_Token('PARAMETER', 'P_ENTITY_TYPE');

3979:
3980: WHEN invalid_parameter THEN
3981: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3982: FND_MESSAGE.Set_Name('WSH', 'WSH_PUB_INVALID_PARAMETER');
3983: FND_MESSAGE.Set_Token('PARAMETER', 'P_ENTITY_TYPE');
3984: WSH_UTIL_CORE.Add_Message(x_return_status);
3985:
3986: --
3987: -- Debug Statements

Line 3997: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LEG_LOCKED');

3993: --
3994: WHEN delivery_leg_locked THEN
3995: CLOSE c_lock_delivery_leg;
3996: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3997: FND_MESSAGE.Set_Name('WSH', 'WSH_DEL_LEG_LOCKED');
3998: WSH_UTIL_CORE.Add_Message(x_return_status);
3999:
4000: --
4001: -- Debug Statements

Line 4149: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_DELIVERY');

4145: EXCEPTION
4146:
4147: WHEN invalid_delivery THEN
4148: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4149: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_DELIVERY');
4150: WSH_UTIL_CORE.Add_Message(x_return_status);
4151: IF l_debug_on THEN
4152: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4153: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DELIVERY');

Line 4158: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');

4154: END IF;
4155:
4156: WHEN invalid_global_params THEN
4157: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4158: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');
4159: WSH_UTIL_CORE.Add_Message(x_return_status);
4160: IF l_debug_on THEN
4161: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_PARAMETER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4162: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETER');

Line 4344: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TRIP');

4340: EXCEPTION
4341:
4342: WHEN invalid_trip THEN
4343: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4344: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_TRIP');
4345: WSH_UTIL_CORE.Add_Message(x_return_status);
4346: IF l_debug_on THEN
4347: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_DELIVERY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4348: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_DELIVERY');

Line 4353: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');

4349: END IF;
4350:
4351: WHEN invalid_global_params THEN
4352: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4353: FND_MESSAGE.Set_Name('WSH', 'WSH_INVALID_GLOBAL_PARAMETER');
4354: WSH_UTIL_CORE.Add_Message(x_return_status);
4355: IF l_debug_on THEN
4356: WSH_DEBUG_SV.logmsg(l_module_name,'INVALID_PARAMETER exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4357: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_PARAMETER');