DBA Data[Home] [Help]

APPS.FTE_WSH_TRIPS_PVT dependencies on FND_MESSAGE

Line 106: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_ID');

102: CLOSE check_wsh_trip_id;
103:
104: EXCEPTION
105: WHEN invalid_fte_trip_id THEN
106: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_ID');
107: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_fte_trip_id);
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN

Line 107: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_fte_trip_id);

103:
104: EXCEPTION
105: WHEN invalid_fte_trip_id THEN
106: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_ID');
107: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_fte_trip_id);
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');

Line 111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');

107: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_fte_trip_id);
108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');
112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN

Line 112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);

108: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
109: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
110: WHEN invalid_wsh_trip_id THEN
111: FND_MESSAGE.SET_NAME('FTE', 'FTE_NO_TRIP_SEGMENT_ID');
112: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
113: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
114: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
115: WHEN others THEN
116: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_PK');

Line 171: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_MISSING');

167: CLOSE check_sequence;
168:
169: EXCEPTION
170: WHEN empty_sequence THEN
171: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_MISSING');
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174: WHEN duplicate_sequence THEN
175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');

Line 175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');

171: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_MISSING');
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
173: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
174: WHEN duplicate_sequence THEN
175: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_SEQUENCE_DUP');
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
178: WHEN others THEN
179: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Sequence');

Line 212: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');

208: FETCH get_status INTO x_status;
209: CLOSE get_status;
210:
211: IF (x_status IS NULL) THEN
212: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
213: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
214: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
215: RETURN null;
216: END IF;

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

209: CLOSE get_status;
210:
211: IF (x_status IS NULL) THEN
212: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_ID');
213: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
214: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR);
215: RETURN null;
216: END IF;
217:

Line 410: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NO_TWO_STOPS');

406:
407: -- give warning
408: wsh_debug_sv.dlog (c_debug,'about to set the warning message...');
409:
410: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NO_TWO_STOPS');
411: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_wsh_trip_name);
412: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
414:

Line 411: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_wsh_trip_name);

407: -- give warning
408: wsh_debug_sv.dlog (c_debug,'about to set the warning message...');
409:
410: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NO_TWO_STOPS');
411: FND_MESSAGE.SET_TOKEN('WSH_TRIP_NAME',l_wsh_trip_name);
412: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
413: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
414:
415: return;

Line 526: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');

522:
523: wsh_debug_sv.dlog (c_debug,'about to set warning message...');
524:
525: -- give warning
526: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
527: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
528: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
529: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 527: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);

523: wsh_debug_sv.dlog (c_debug,'about to set warning message...');
524:
525: -- give warning
526: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
527: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
528: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
529: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
531: end if;

Line 528: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);

524:
525: -- give warning
526: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_PREV_CONNECT_ERROR');
527: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
528: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
529: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
530: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
531: end if;
532:

Line 635: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');

631:
632: wsh_debug_sv.dlog (c_debug,'about to set warning message...');
633:
634: -- give warning
635: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
636: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
637: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 636: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);

632: wsh_debug_sv.dlog (c_debug,'about to set warning message...');
633:
634: -- give warning
635: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
636: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
637: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
640:

Line 637: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);

633:
634: -- give warning
635: FND_MESSAGE.SET_NAME('FTE', 'FTE_SEGMENT_NEXT_CONNECT_ERROR');
636: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
637: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_NAME',l_wsh_trip_name);
638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
639: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
640:
641: end if;

Line 655: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS');

651: wsh_debug_sv.stop_debug;
652:
653: EXCEPTION
654: WHEN add_segment_to_closed_trip THEN
655: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS');
656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
657: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
658:
659: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

Line 664: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS2');

660: wsh_debug_sv.dpop (c_sdebug);
661: wsh_debug_sv.stop_debug;
662:
663: WHEN add_segment_to_in_transit_trip THEN
664: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS2');
665: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
666: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
667:
668: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

Line 673: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');

669: wsh_debug_sv.dpop (c_sdebug);
670: wsh_debug_sv.stop_debug;
671:
672: WHEN update_sequence_for_non_open THEN
673: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');
674: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
675: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
676:
677: wsh_debug_sv.dlog (c_debug,'Return Status',x_Return_Status);

Line 879: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');

875: end if;
876:
877: EXCEPTION
878: WHEN no_trip_found THEN
879: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
880: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_info.WSH_TRIP_ID);
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN

Line 880: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_info.WSH_TRIP_ID);

876:
877: EXCEPTION
878: WHEN no_trip_found THEN
879: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
880: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_trip_info.WSH_TRIP_ID);
881: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
882: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
883: WHEN others THEN
884: wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');

Line 1042: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_CONNECT_SEGMENT');

1038: set validation_required = 'Y'
1039: where fte_trip_id = p_fte_trip_id;
1040:
1041: -- give warning
1042: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_CONNECT_SEGMENT');
1043: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1045: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1046:

Line 1043: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);

1039: where fte_trip_id = p_fte_trip_id;
1040:
1041: -- give warning
1042: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_CONNECT_SEGMENT');
1043: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_fte_trip_name);
1044: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1045: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1046:
1047: end if;

Line 1058: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');

1054:
1055: EXCEPTION
1056: WHEN invalid_trip_status THEN
1057: -- cannot add/remove segments from trip with this status
1058: FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');
1059: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1060: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1061: FND_MSG_PUB.Count_And_Get
1062: ( p_count => x_msg_count

Line 1159: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');

1155: wsh_debug_sv.stop_debug;
1156:
1157: EXCEPTION
1158: WHEN no_trip_found THEN
1159: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
1160: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1162: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1163: FND_MSG_PUB.Count_And_Get

Line 1160: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);

1156:
1157: EXCEPTION
1158: WHEN no_trip_found THEN
1159: FND_MESSAGE.SET_NAME('FTE','FTE_NO_TRIP_SEGMENT_ID');
1160: FND_MESSAGE.SET_TOKEN('TRIP_SEGMENT_ID',p_wsh_trip_id);
1161: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1162: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1163: FND_MSG_PUB.Count_And_Get
1164: ( p_count => x_msg_count

Line 1298: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');

1294: );
1295:
1296: EXCEPTION
1297: WHEN invalid_action THEN
1298: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1299: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: wsh_util_core.add_message(x_return_status);
1302: FND_MSG_PUB.Count_And_Get

Line 1299: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);

1295:
1296: EXCEPTION
1297: WHEN invalid_action THEN
1298: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1299: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1301: wsh_util_core.add_message(x_return_status);
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_count => x_msg_count

Line 1449: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');

1445: wsh_debug_sv.stop_debug;
1446:
1447: EXCEPTION
1448: WHEN invalid_action THEN
1449: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1450: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: wsh_util_core.add_message(x_return_status);
1453: FND_MSG_PUB.Count_And_Get

Line 1450: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);

1446:
1447: EXCEPTION
1448: WHEN invalid_action THEN
1449: FND_MESSAGE.SET_NAME('FTE','FTE_WSH_TRIPS_WRAPPER_ERR1');
1450: FND_MESSAGE.SET_TOKEN('ACTION',p_action_code);
1451: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1452: wsh_util_core.add_message(x_return_status);
1453: FND_MSG_PUB.Count_And_Get
1454: ( p_count => x_msg_count