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_TRIP_STOPS_VALIDATIONS dependencies on WSH_UTIL_CORE

Line 42: l_del_to_unassign WSH_UTIL_CORE.id_tab_type;

38:
39:
40: l_return_status VARCHAR2(30);
41: l_trip_id NUMBER;
42: l_del_to_unassign WSH_UTIL_CORE.id_tab_type;
43:
44: RECORD_LOCKED EXCEPTION;
45: PRAGMA EXCEPTION_INIT(RECORD_LOCKED, -54);
46:

Line 74: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

70: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
72: END IF;
73: --
74: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
75:
76: OPEN c_lock_trip;
77: FETCH c_lock_trip
78: INTO l_trip_id;

Line 97: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

93: -- Check if sequence number is positive
94: check_for_negative_number(
95: p_stop_sequence_number => p_stop_sequence_number,
96: x_return_status => l_return_status);
97: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
98: x_return_status := l_return_status;
99: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_STOP_SEQUENCE');
100: wsh_util_core.add_message(x_return_status);
101: --

Line 100: wsh_util_core.add_message(x_return_status);

96: x_return_status => l_return_status);
97: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
98: x_return_status := l_return_status;
99: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_STOP_SEQUENCE');
100: wsh_util_core.add_message(x_return_status);
101: --
102: -- Debug Statements
103: --
104: IF l_debug_on THEN

Line 116: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

112: -- For new records pass this as OP as well
113: validate_stop_status(
114: p_stop_status => p_status_code,
115: x_return_status => l_return_status);
116: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
117: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');
118: x_return_status := l_return_status;
119: wsh_util_core.add_message(x_return_status);
120: --

Line 119: wsh_util_core.add_message(x_return_status);

115: x_return_status => l_return_status);
116: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
117: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_INVALID_STATUS');
118: x_return_status := l_return_status;
119: wsh_util_core.add_message(x_return_status);
120: --
121: -- Debug Statements
122: --
123: IF l_debug_on THEN

Line 136: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

132: validate_closed_stop_seq
133: (p_trip_id => p_trip_id,
134: p_stop_sequence_number => p_stop_sequence_number,
135: x_return_status => l_return_status);
136: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
137: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_SEQUENCE_LOWER');
138: x_return_status := l_return_status;
139: wsh_util_core.add_message(x_return_status);
140: --

Line 139: wsh_util_core.add_message(x_return_status);

135: x_return_status => l_return_status);
136: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
137: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_SEQUENCE_LOWER');
138: x_return_status := l_return_status;
139: wsh_util_core.add_message(x_return_status);
140: --
141: -- Debug Statements
142: --
143: IF l_debug_on THEN

Line 164: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

160: p_trip_id => p_trip_id,
161: p_stop_sequence_number => p_stop_sequence_number,
162: x_del_to_unassign => l_del_to_unassign,
163: x_return_status => l_return_status);
164: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
165: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
166: x_return_status := l_return_status;
167: ELSE
168: x_return_status := l_return_status;

Line 165: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

161: p_stop_sequence_number => p_stop_sequence_number,
162: x_del_to_unassign => l_del_to_unassign,
163: x_return_status => l_return_status);
164: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
165: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
166: x_return_status := l_return_status;
167: ELSE
168: x_return_status := l_return_status;
169: --

Line 190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

186: END IF;
187: --
188: EXCEPTION
189: WHEN RECORD_LOCKED THEN
190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
191: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
192: WSH_UTIL_CORE.add_message (x_return_status);
193: --
194: -- Debug Statements

Line 192: WSH_UTIL_CORE.add_message (x_return_status);

188: EXCEPTION
189: WHEN RECORD_LOCKED THEN
190: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
191: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
192: WSH_UTIL_CORE.add_message (x_return_status);
193: --
194: -- Debug Statements
195: --
196: IF l_debug_on THEN

Line 211: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_sequence_number');

207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
208: END IF;
209: --
210: WHEN OTHERS THEN
211: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_sequence_number');
212: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
213: --
214: -- Debug Statements
215: --

Line 212: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

208: END IF;
209: --
210: WHEN OTHERS THEN
211: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_sequence_number');
212: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
213: --
214: -- Debug Statements
215: --
216: IF l_debug_on THEN

Line 268: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

264: FETCH c_check_max
265: INTO l_max_sequence;
266:
267: IF (c_check_max%NOTFOUND or l_max_sequence = 0) THEN
268: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
269: ELSIF (l_max_sequence > p_stop_sequence_number) THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: END IF;
272:

Line 270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

266:
267: IF (c_check_max%NOTFOUND or l_max_sequence = 0) THEN
268: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
269: ELSIF (l_max_sequence > p_stop_sequence_number) THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: END IF;
272:
273: CLOSE c_check_max;
274: --

Line 283: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_closed_stop_seq');

279: END IF;
280: --
281: EXCEPTION
282: WHEN OTHERS THEN
283: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_closed_stop_seq');
284: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
285: --
286: -- Debug Statements
287: --

Line 284: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

280: --
281: EXCEPTION
282: WHEN OTHERS THEN
283: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_closed_stop_seq');
284: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
285: --
286: -- Debug Statements
287: --
288: IF l_debug_on THEN

Line 352: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

348: ) OR
349: (c_check_unique%NOTFOUND) OR
350: (l_stop_id IS NULL)
351: )THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
353: ELSE
354: -- l_stop_id is not null and <> p_stop_id
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: END IF;

Line 355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

351: )THEN
352: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
353: ELSE
354: -- l_stop_id is not null and <> p_stop_id
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
356: END IF;
357: /*
358: -- no records exist
359: IF (l_check_flag = 'N' OR c_check_unique%NOTFOUND) THEN

Line 360: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

356: END IF;
357: /*
358: -- no records exist
359: IF (l_check_flag = 'N' OR c_check_unique%NOTFOUND) THEN
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
361: ELSIF l_check_flag = 'Y' THEN
362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
363: END IF;
364: */

Line 362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

358: -- no records exist
359: IF (l_check_flag = 'N' OR c_check_unique%NOTFOUND) THEN
360: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
361: ELSIF l_check_flag = 'Y' THEN
362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
363: END IF;
364: */
365:
366: CLOSE c_check_unique;

Line 377: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_unique_sequence');

373: END IF;
374: --
375: EXCEPTION
376: WHEN OTHERS THEN
377: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_unique_sequence');
378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
379: --
380: -- Debug Statements
381: --

Line 378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

374: --
375: EXCEPTION
376: WHEN OTHERS THEN
377: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_unique_sequence');
378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
379: --
380: -- Debug Statements
381: --
382: IF l_debug_on THEN

Line 416: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

412: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
413: END IF;
414: --
415: IF p_stop_sequence_number > 0 THEN
416: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
417: ELSE
418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
419: END IF;
420:

Line 418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

414: --
415: IF p_stop_sequence_number > 0 THEN
416: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
417: ELSE
418: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
419: END IF;
420:
421: --
422: -- Debug Statements

Line 430: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.check_for_negative_number');

426: END IF;
427: --
428: EXCEPTION
429: WHEN OTHERS THEN
430: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.check_for_negative_number');
431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
432: --
433: -- Debug Statements
434: --

Line 431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

427: --
428: EXCEPTION
429: WHEN OTHERS THEN
430: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.check_for_negative_number');
431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
432: --
433: -- Debug Statements
434: --
435: IF l_debug_on THEN

Line 470: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

466: WSH_DEBUG_SV.log(l_module_name,'P_STOP_STATUS',P_STOP_STATUS);
467: END IF;
468: --
469: IF p_stop_status = 'OP' THEN
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
471: ELSE
472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: END IF;
474:

Line 472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

468: --
469: IF p_stop_status = 'OP' THEN
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
471: ELSE
472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: END IF;
474:
475: --
476: -- Debug Statements

Line 484: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_stop_status');

480: END IF;
481: --
482: EXCEPTION
483: WHEN OTHERS THEN
484: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_stop_status');
485: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
486: --
487: -- Debug Statements
488: --

Line 485: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

481: --
482: EXCEPTION
483: WHEN OTHERS THEN
484: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_stop_status');
485: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
486: --
487: -- Debug Statements
488: --
489: IF l_debug_on THEN

Line 512: x_del_to_unassign OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

508: PROCEDURE valid_delivery_on_trip
509: (p_stop_id IN NUMBER,
510: p_trip_id IN NUMBER,
511: p_stop_sequence_number IN NUMBER,
512: x_del_to_unassign OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
513: x_return_status OUT NOCOPY VARCHAR2) IS
514:
515: CURSOR c_stop_details IS
516: SELECT stop_sequence_number,

Line 549: l_del_to_unassign WSH_UTIL_CORE.id_tab_type;

545: dleg_count NUMBER := 0;
546: l_num_warn NUMBER := 0;
547:
548: --this will be used to unassign deliveries from trip
549: l_del_to_unassign WSH_UTIL_CORE.id_tab_type;
550: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551:
552:
553: --

Line 550: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

546: l_num_warn NUMBER := 0;
547:
548: --this will be used to unassign deliveries from trip
549: l_del_to_unassign WSH_UTIL_CORE.id_tab_type;
550: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551:
552:
553: --
554: l_debug_on BOOLEAN;

Line 579: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

575: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
576: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
577: END IF;
578: --
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
580:
581: FOR rec in c_stop_details
582: LOOP
583: stop_count := stop_count + 1;

Line 647: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

643: --
644: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
645: WSH_TRIPS_PVT.get_name(p_trip_id));
646: l_num_warn := l_num_warn + 1;
647: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
648: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
649:
650: END IF;
651:

Line 648: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

644: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
645: WSH_TRIPS_PVT.get_name(p_trip_id));
646: l_num_warn := l_num_warn + 1;
647: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
648: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
649:
650: END IF;
651:
652: -- Both cases for pickup and drop off cannot be true separately at the same time

Line 682: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

678: --
679: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
680: WSH_TRIPS_PVT.get_name(p_trip_id));
681: l_num_warn := l_num_warn + 1;
682: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
683: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
684:
685: END IF;
686:

Line 683: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);

679: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
680: WSH_TRIPS_PVT.get_name(p_trip_id));
681: l_num_warn := l_num_warn + 1;
682: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
683: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_WARNING);
684:
685: END IF;
686:
687: END IF;

Line 707: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

703: END IF;
704:
705:
706: IF l_num_warn > 0 THEN
707: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
708: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
709: x_return_status := l_return_status;
710: END IF;
711:

Line 708: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

704:
705:
706: IF l_num_warn > 0 THEN
707: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
708: ELSIF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
709: x_return_status := l_return_status;
710: END IF;
711:
712:

Line 722: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.valid_delivery_on_trip');

718: END IF;
719: --
720: EXCEPTION
721: WHEN OTHERS THEN
722: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.valid_delivery_on_trip');
723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
724: --
725: -- Debug Statements
726: --

Line 723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

719: --
720: EXCEPTION
721: WHEN OTHERS THEN
722: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.valid_delivery_on_trip');
723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
724: --
725: -- Debug Statements
726: --
727: IF l_debug_on THEN

Line 801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);
799: END IF;
800: --
801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
802: l_stop_sequence_number := 0;
803:
804: -- new pickup or dropoff
805: IF (p_new_flag IN ('PICKUP','DROPOFF')) THEN /* pickup or dropoff */

Line 814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

810: p_trip_id => p_trip_id,
811: p_status_code => p_status_code,
812: x_return_status => x_return_status);
813:
814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
815: --
816: -- Debug Statements
817: --
818: IF l_debug_on THEN

Line 852: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

848: p_trip_id => p_trip_id,
849: p_status_code => p_status_code,
850: x_return_status => x_return_status);
851:
852: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
853: -- try another number,append by 10 more
854: get_new_sequence_number
855: (x_stop_sequence_number => l_stop_sequence_number,
856: p_trip_id => p_trip_id,

Line 876: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.get_new_sequence_number');

872: END IF;
873: --
874: EXCEPTION
875: WHEN OTHERS THEN
876: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.get_new_sequence_number');
877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
878: --
879: -- Debug Statements
880: --

Line 877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

873: --
874: EXCEPTION
875: WHEN OTHERS THEN
876: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.get_new_sequence_number');
877: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
878: --
879: -- Debug Statements
880: --
881: IF l_debug_on THEN

Line 894: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,

890: p_stop_rec_tab IN stop_rec_tab_type,
891: p_action IN VARCHAR2,
892: p_caller IN VARCHAR2,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
895: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
896: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type
897: ) IS
898:

Line 895: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,

891: p_action IN VARCHAR2,
892: p_caller IN VARCHAR2,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
895: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
896: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type
897: ) IS
898:
899:

Line 896: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type

892: p_caller IN VARCHAR2,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_valid_ids OUT NOCOPY wsh_util_core.id_tab_type,
895: x_error_ids OUT NOCOPY wsh_util_core.id_tab_type,
896: x_valid_index_tab OUT NOCOPY wsh_util_core.id_tab_type
897: ) IS
898:
899:
900: cursor stop_to_del_cur( p_stop_id IN NUMBER ) is

Line 949: l_del_entity_ids WSH_UTIL_CORE.column_tab_type;

945: and (wdl.pick_up_stop_id = p_stop_id OR
946: wdl.drop_off_stop_id = p_stop_id );
947:
948: l_override_wf VARCHAR2(1);
949: l_del_entity_ids WSH_UTIL_CORE.column_tab_type;
950: l_purged_count NUMBER;
951: l_wf_rs VARCHAR2(1);
952: e_scpod_wf_inprogress EXCEPTION;
953: --==/

Line 956: l_valid_ids wsh_util_core.id_tab_type;

952: e_scpod_wf_inprogress EXCEPTION;
953: --==/
954:
955: l_stop_actions_tab StopActionsTabType;
956: l_valid_ids wsh_util_core.id_tab_type;
957: l_error_ids wsh_util_core.id_tab_type;
958: l_valid_index_tab wsh_util_core.id_tab_type;
959: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
960:

Line 957: l_error_ids wsh_util_core.id_tab_type;

953: --==/
954:
955: l_stop_actions_tab StopActionsTabType;
956: l_valid_ids wsh_util_core.id_tab_type;
957: l_error_ids wsh_util_core.id_tab_type;
958: l_valid_index_tab wsh_util_core.id_tab_type;
959: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
960:
961: l_tpw_temp VARCHAR2(1);

Line 958: l_valid_index_tab wsh_util_core.id_tab_type;

954:
955: l_stop_actions_tab StopActionsTabType;
956: l_valid_ids wsh_util_core.id_tab_type;
957: l_error_ids wsh_util_core.id_tab_type;
958: l_valid_index_tab wsh_util_core.id_tab_type;
959: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
960:
961: l_tpw_temp VARCHAR2(1);
962: l_return_status VARCHAR2(1);

Line 996: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

992: IF l_debug_on THEN
993: WSH_DEBUG_SV.log(l_module_name,'Init_Detail_Actions_Tbl x_return_status',x_return_status);
994: END IF;
995:
996: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
997: raise error_in_init_actions;
998: END IF;
999:
1000: FOR j IN p_stop_rec_tab.FIRST..p_stop_rec_tab.LAST LOOP

Line 1077: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
1075: END IF;
1076:
1077: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1078: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1079: RAISE e_set_messages;
1080: ELSE
1081: x_valid_ids(x_valid_ids.COUNT + 1) := p_stop_rec_tab(j).stop_id;

Line 1078: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1074: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
1075: END IF;
1076:
1077: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1078: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1079: RAISE e_set_messages;
1080: ELSE
1081: x_valid_ids(x_valid_ids.COUNT + 1) := p_stop_rec_tab(j).stop_id;
1082: x_valid_index_tab(j) := j;

Line 1112: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

1108: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',
1109: l_return_status);
1110: END IF;
1111:
1112: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1113: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1114: RAISE e_set_messages;
1115: ELSE
1116: x_valid_ids(x_valid_ids.COUNT + 1) := p_stop_rec_tab(j).stop_id;

Line 1113: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1109: l_return_status);
1110: END IF;
1111:
1112: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1113: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1114: RAISE e_set_messages;
1115: ELSE
1116: x_valid_ids(x_valid_ids.COUNT + 1) := p_stop_rec_tab(j).stop_id;
1117: x_valid_index_tab(j) := j;

Line 1143: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('STOP', p_action));

1139: WHEN e_scpod_wf_inprogress THEN --/== Workflow Changes
1140: x_error_ids(x_error_ids.count +1) := p_stop_rec_tab(j).stop_id;
1141: FND_MESSAGE.SET_NAME('WSH','WSH_WF_STOP_ACTION_INELIGIBLE');
1142: FND_MESSAGE.Set_Token('STOP_ID',x_error_ids(x_error_ids.count));
1143: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('STOP', p_action));
1144: wsh_util_core.add_message('E',l_module_name); --==/
1145: WHEN e_set_messages THEN
1146: x_error_ids(x_error_ids.count +1) := p_stop_rec_tab(j).stop_id;
1147: IF p_caller = 'WSH_PUB'

Line 1144: wsh_util_core.add_message('E',l_module_name); --==/

1140: x_error_ids(x_error_ids.count +1) := p_stop_rec_tab(j).stop_id;
1141: FND_MESSAGE.SET_NAME('WSH','WSH_WF_STOP_ACTION_INELIGIBLE');
1142: FND_MESSAGE.Set_Token('STOP_ID',x_error_ids(x_error_ids.count));
1143: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('STOP', p_action));
1144: wsh_util_core.add_message('E',l_module_name); --==/
1145: WHEN e_set_messages THEN
1146: x_error_ids(x_error_ids.count +1) := p_stop_rec_tab(j).stop_id;
1147: IF p_caller = 'WSH_PUB'
1148: OR p_caller like 'FTE%' THEN

Line 1151: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('STOP', p_action));

1147: IF p_caller = 'WSH_PUB'
1148: OR p_caller like 'FTE%' THEN
1149: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ACTION_INELIGIBLE');
1150: FND_MESSAGE.Set_Token('STOP_ID',x_error_ids(x_error_ids.count));
1151: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('STOP', p_action));
1152: wsh_util_core.add_message('E',l_module_name);
1153: END IF;
1154: END;
1155: END LOOP;

Line 1152: wsh_util_core.add_message('E',l_module_name);

1148: OR p_caller like 'FTE%' THEN
1149: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_ACTION_INELIGIBLE');
1150: FND_MESSAGE.Set_Token('STOP_ID',x_error_ids(x_error_ids.count));
1151: FND_MESSAGE.Set_Token('ACTION',wsh_util_core.get_action_meaning('STOP', p_action));
1152: wsh_util_core.add_message('E',l_module_name);
1153: END IF;
1154: END;
1155: END LOOP;
1156:

Line 1159: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1155: END LOOP;
1156:
1157: IF (x_valid_ids.COUNT = 0 ) THEN
1158: --{
1159: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1160: --
1161: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
1162: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');
1163: wsh_util_core.add_message(x_return_status,l_module_name);

Line 1163: wsh_util_core.add_message(x_return_status,l_module_name);

1159: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1160: --
1161: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
1162: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');
1163: wsh_util_core.add_message(x_return_status,l_module_name);
1164: END IF;
1165: --}
1166: ELSIF (x_valid_ids.COUNT = p_stop_rec_tab.COUNT) THEN
1167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1163: wsh_util_core.add_message(x_return_status,l_module_name);
1164: END IF;
1165: --}
1166: ELSIF (x_valid_ids.COUNT = p_stop_rec_tab.COUNT) THEN
1167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1168: ELSIF (x_valid_ids.COUNT < p_stop_rec_tab.COUNT ) THEN
1169: --{
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1171: --

Line 1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1166: ELSIF (x_valid_ids.COUNT = p_stop_rec_tab.COUNT) THEN
1167: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1168: ELSIF (x_valid_ids.COUNT < p_stop_rec_tab.COUNT ) THEN
1169: --{
1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1171: --
1172: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
1173: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED_WARN');
1174: wsh_util_core.add_message(x_return_status,l_module_name);

Line 1174: wsh_util_core.add_message(x_return_status,l_module_name);

1170: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1171: --
1172: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
1173: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED_WARN');
1174: wsh_util_core.add_message(x_return_status,l_module_name);
1175: END IF;
1176: --}
1177: ELSE
1178: --{

Line 1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1175: END IF;
1176: --}
1177: ELSE
1178: --{
1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1180: --
1181: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
1182: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');
1183: wsh_util_core.add_message(x_return_status,l_module_name);

Line 1183: wsh_util_core.add_message(x_return_status,l_module_name);

1179: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1180: --
1181: IF NOT (l_caller = 'WSH_PUB' OR l_caller LIKE 'FTE%') THEN
1182: FND_MESSAGE.SET_NAME('WSH','WSH_ACTION_ENABLED');
1183: wsh_util_core.add_message(x_return_status,l_module_name);
1184: END IF;
1185: --}
1186: END IF;
1187:

Line 1208: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1204: -- OTM R12, glog proj, other cursors are not using OPEN/FETCH
1205: IF stop_to_det_cur%ISOPEN THEN
1206: CLOSE stop_to_det_cur;
1207: END IF;
1208: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1209: IF l_debug_on THEN
1210: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1211: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1590: p_disabled_list IN WSH_UTIL_CORE.column_tab_type

1586: -- and disables the field contained in p_disabled_list.
1587: -----------------------------------------------------------*/
1588:
1589: PROCEDURE disable_from_list(
1590: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1591: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1592: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1593: , x_return_status OUT NOCOPY VARCHAR2
1594: , x_field_name OUT NOCOPY VARCHAR2

Line 1656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1652: NULL;
1653: ELSE
1654: -- invalid name
1655: x_field_name := p_disabled_list(i);
1656: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1657: RETURN;
1658: --
1659: END IF;
1660: END LOOP;

Line 1776: p_disabled_list IN WSH_UTIL_CORE.column_tab_type

1772: -- included in p_disabled_list and will enable them
1773: -----------------------------------------------------------*/
1774:
1775: PROCEDURE enable_from_list(
1776: p_disabled_list IN WSH_UTIL_CORE.column_tab_type
1777: , p_in_rec IN WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1778: , x_out_rec IN OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1779: , x_return_status OUT NOCOPY VARCHAR2
1780: , x_field_name OUT NOCOPY VARCHAR2

Line 1973: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1969: --NULL;
1970: ELSE
1971: -- invalid name
1972: x_field_name := p_disabled_list(i);
1973: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1974: RETURN;
1975: --
1976: END IF;
1977: END LOOP;

Line 1993: l_disabled_list WSH_UTIL_CORE.column_tab_type;

1989: , x_msg_data OUT NOCOPY VARCHAR2
1990: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1991: )
1992: IS
1993: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1994: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1995: l_return_status VARCHAR2(30);
1996: l_field_name VARCHAR2(100);
1997: l_parent_entity_id NUMBER;

Line 2187: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR

2183: , x_msg_data
2184: , l_caller --3509004:public api changes
2185: );
2186: --
2187: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR
2188: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2189: THEN
2190: --
2191: IF l_debug_on THEN

Line 2188: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

2184: , l_caller --3509004:public api changes
2185: );
2186: --
2187: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR
2188: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2189: THEN
2190: --
2191: IF l_debug_on THEN
2192: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 2249: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2245: x_stop_rec,
2246: l_return_status,
2247: l_field_name);
2248: --
2249: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2250: RAISE e_bad_field;
2251: END IF;
2252: --
2253: END IF;

Line 2281: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2277: l_return_status,
2278: l_field_name
2279: );
2280: --
2281: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2282: RAISE e_bad_field;
2283: END IF;
2284: --
2285: END IF;

Line 2300: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2296: p_out_rec => x_stop_rec,
2297: p_in_rec => p_in_rec,
2298: x_return_status => l_return_status);
2299: --
2300: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2301: x_return_status := l_return_status;
2302: END IF;
2303: --
2304: END IF;

Line 2319: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2315: END IF;
2316: IF c_tbl_rec%ISOPEN THEN
2317: CLOSE c_tbl_rec;
2318: END IF;
2319: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2320: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
2321: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_rec.stop_id);
2322: wsh_util_core.add_message(x_return_status,l_module_name);
2323: IF l_debug_on THEN

Line 2322: wsh_util_core.add_message(x_return_status,l_module_name);

2318: END IF;
2319: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2320: FND_MESSAGE.SET_NAME('WSH','WSH_ALL_COLS_DISABLED');
2321: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_rec.stop_id);
2322: wsh_util_core.add_message(x_return_status,l_module_name);
2323: IF l_debug_on THEN
2324: -- Nothing is updateable
2325: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2326: END IF;

Line 2335: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2331: END IF;
2332: IF c_tbl_rec%ISOPEN THEN
2333: CLOSE c_tbl_rec;
2334: END IF;
2335: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2336: -- the message for this is set in original get_disabled_list
2337: IF l_debug_on THEN
2338: WSH_DEBUG_SV.pop(l_module_name,'e_dp_no_entity');
2339: END IF;

Line 2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2344: END IF;
2345: IF c_tbl_rec%ISOPEN THEN
2346: CLOSE c_tbl_rec;
2347: END IF;
2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2349: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
2350: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
2351: wsh_util_core.add_message(x_return_status,l_module_name);
2352: IF l_debug_on THEN

Line 2351: wsh_util_core.add_message(x_return_status,l_module_name);

2347: END IF;
2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2349: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
2350: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
2351: wsh_util_core.add_message(x_return_status,l_module_name);
2352: IF l_debug_on THEN
2353: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
2354: ,l_field_name);
2355: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');

Line 2366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2362: END IF;
2363: IF c_tbl_rec%ISOPEN THEN
2364: CLOSE c_tbl_rec;
2365: END IF;
2366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2367: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2368: IF l_debug_on THEN
2369: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2367: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);

2363: IF c_tbl_rec%ISOPEN THEN
2364: CLOSE c_tbl_rec;
2365: END IF;
2366: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2367: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2368: IF l_debug_on THEN
2369: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2370: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2371: END IF;

Line 2403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2399: --
2400: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
2401: END IF;
2402: --
2403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2404:
2405: --
2406: -- J-IB-NPARIKH-{
2407: --

Line 2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2470: WSH_DEBUG_SV.pop(l_module_name);
2471: END IF;
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2475: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2475: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);

2471: END IF;
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2475: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2476: IF l_debug_on THEN
2477: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2479: END IF;

Line 2574: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2570: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2571: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2572: END IF;
2573: --
2574: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2575: --
2576: IF p_trip_id IS NULL
2577: THEN
2578: --{

Line 2584: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

2580: -- Trip ID is a required parameter. Raise error.
2581: --
2582: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2583: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_trip_id');
2584: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2585: RAISE FND_API.G_EXC_ERROR;
2586: --}
2587: END IF;
2588: --

Line 2597: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);

2593: -- Stop ID is a required parameter. Raise error.
2594: --
2595: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2596: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_stop_id');
2597: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error,l_module_name);
2598: RAISE FND_API.G_EXC_ERROR;
2599: --}
2600: END IF;
2601: --

Line 2720: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2716: --{
2717: --
2718: WHEN FND_API.G_EXC_ERROR THEN
2719:
2720: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2721: --
2722: IF l_debug_on THEN
2723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 2729: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2725: END IF;
2726: --
2727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2728:
2729: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2730: --
2731: IF l_debug_on THEN
2732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2736: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

2732: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2734: END IF;
2735: --
2736: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2738: --
2739: IF l_debug_on THEN
2740: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2734: END IF;
2735: --
2736: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2738: --
2739: IF l_debug_on THEN
2740: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 2740: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2736: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2738: --
2739: IF l_debug_on THEN
2740: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2742: END IF;
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2737: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2738: --
2739: IF l_debug_on THEN
2740: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2742: END IF;
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);

Line 2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

2740: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2742: END IF;
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);
2746: IF l_debug_on THEN
2747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2748: END IF;

Line 2745: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);

2741: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2742: END IF;
2743: WHEN OTHERS THEN
2744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2745: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);
2746: IF l_debug_on THEN
2747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2748: END IF;
2749: --}

Line 3180: l_itm_mark_dels wsh_util_core.id_tab_type;

3176: -- Bug 3346237 : Parameters Enforce Ship Method and Allow future ship date
3177: -- should use values present in Global Parameters table.
3178: l_global_info WSH_SHIPPING_PARAMS_PVT.Global_Parameters_Rec_Typ;
3179:
3180: l_itm_mark_dels wsh_util_core.id_tab_type;
3181: l_exceptions_tab wsh_delivery_validations.exception_rec_tab_type;
3182: l_exceptions_exist VARCHAR2(1);
3183: l_period_id NUMBER;
3184: l_open_past_period BOOLEAN;

Line 3237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3233: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3234: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3235: END IF;
3236: --
3237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3238: l_stop_warnings := 0;
3239: l_num_warnings := 0;
3240: l_num_errors := 0;
3241: --

Line 3266: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3262: --{
3263: --CLOSE stop_info_csr;
3264: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_NOT_EXIST');
3265: FND_MESSAGE.SET_TOKEN('STOP_ID',p_in_rec.stop_id);
3266: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3267: RAISE FND_API.G_EXC_ERROR;
3268: --}
3269: END IF;
3270: --

Line 3358: WSH_UTIL_CORE.get_location_description

3354: l_location_id := l_stop_info_rec.stop_location_id;
3355: END IF;
3356:
3357: l_stop_name := SUBSTRB(
3358: WSH_UTIL_CORE.get_location_description
3359: (
3360: l_location_id,
3361: 'NEW UI CODE'
3362: ),

Line 3407: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

3403: x_exceptions_tab => l_exceptions_tbl,
3404: --tkt
3405: p_caller => p_in_rec.caller
3406: );
3407: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3408: x_return_status := l_return_status;
3409: wsh_util_core.add_message(x_return_status);
3410: RAISE FND_API.G_EXC_ERROR;
3411: END IF;

Line 3409: wsh_util_core.add_message(x_return_status);

3405: p_caller => p_in_rec.caller
3406: );
3407: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3408: x_return_status := l_return_status;
3409: wsh_util_core.add_message(x_return_status);
3410: RAISE FND_API.G_EXC_ERROR;
3411: END IF;
3412: FOR exp_cnt in 1..l_exceptions_tbl.COUNT LOOP
3413: IF l_exceptions_tbl(exp_cnt).exception_behavior = 'ERROR' THEN

Line 3421: WSH_UTIL_CORE.Get_Entity_Name

3417: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3418: END IF;
3419:
3420: -- BugFix #3947506
3421: WSH_UTIL_CORE.Get_Entity_Name
3422: ( l_exceptions_tbl(exp_cnt).entity_id,
3423: l_exceptions_tbl(exp_cnt).entity_name,
3424: l_out_entity_id,
3425: l_out_entity_name,

Line 3428: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

3424: l_out_entity_id,
3425: l_out_entity_name,
3426: l_out_status);
3427:
3428: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3429: wsh_util_core.add_message(l_out_status);
3430: RAISE FND_API.G_EXC_ERROR;
3431: END IF;
3432:

Line 3429: wsh_util_core.add_message(l_out_status);

3425: l_out_entity_name,
3426: l_out_status);
3427:
3428: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3429: wsh_util_core.add_message(l_out_status);
3430: RAISE FND_API.G_EXC_ERROR;
3431: END IF;
3432:
3433: -- End of code BugFix #3947506

Line 3438: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3434:
3435: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
3436: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
3437: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
3438: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3439: wsh_util_core.add_message(x_return_status);
3440: l_stop_warnings := l_stop_warnings + 1;
3441: RAISE wsh_util_core.e_not_allowed;
3442: ELSIF l_exceptions_tbl(exp_cnt).exception_behavior = 'WARNING' THEN

Line 3439: wsh_util_core.add_message(x_return_status);

3435: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
3436: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
3437: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
3438: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3439: wsh_util_core.add_message(x_return_status);
3440: l_stop_warnings := l_stop_warnings + 1;
3441: RAISE wsh_util_core.e_not_allowed;
3442: ELSIF l_exceptions_tbl(exp_cnt).exception_behavior = 'WARNING' THEN
3443: IF l_exceptions_tbl(exp_cnt).entity_name = 'STOP' THEN

Line 3441: RAISE wsh_util_core.e_not_allowed;

3437: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Error');
3438: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3439: wsh_util_core.add_message(x_return_status);
3440: l_stop_warnings := l_stop_warnings + 1;
3441: RAISE wsh_util_core.e_not_allowed;
3442: ELSIF l_exceptions_tbl(exp_cnt).exception_behavior = 'WARNING' THEN
3443: IF l_exceptions_tbl(exp_cnt).entity_name = 'STOP' THEN
3444: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
3445: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Stop');

Line 3448: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3444: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_ENTITY');
3445: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Stop');
3446: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trip_stops_pvt.get_name(l_exceptions_tbl(exp_cnt).entity_id)); --BugFix #3925590
3447: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
3448: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3449: wsh_util_core.add_message(x_return_status);
3450: l_stop_warnings := l_stop_warnings + 1;
3451: ELSIF NOT (l_exp_logged) THEN
3452: -- BugFix #3947506

Line 3449: wsh_util_core.add_message(x_return_status);

3445: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Stop');
3446: FND_MESSAGE.SET_TOKEN('ENTITY_ID',wsh_trip_stops_pvt.get_name(l_exceptions_tbl(exp_cnt).entity_id)); --BugFix #3925590
3447: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
3448: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3449: wsh_util_core.add_message(x_return_status);
3450: l_stop_warnings := l_stop_warnings + 1;
3451: ELSIF NOT (l_exp_logged) THEN
3452: -- BugFix #3947506
3453: WSH_UTIL_CORE.Get_Entity_Name

Line 3453: WSH_UTIL_CORE.Get_Entity_Name

3449: wsh_util_core.add_message(x_return_status);
3450: l_stop_warnings := l_stop_warnings + 1;
3451: ELSIF NOT (l_exp_logged) THEN
3452: -- BugFix #3947506
3453: WSH_UTIL_CORE.Get_Entity_Name
3454: ( l_exceptions_tbl(exp_cnt).entity_id,
3455: l_exceptions_tbl(exp_cnt).entity_name,
3456: l_out_entity_id,
3457: l_out_entity_name,

Line 3460: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN

3456: l_out_entity_id,
3457: l_out_entity_name,
3458: l_out_status);
3459:
3460: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3461: wsh_util_core.add_message(l_out_status);
3462: RAISE FND_API.G_EXC_ERROR;
3463: END IF;
3464: -- End of code BugFix #3947506

Line 3461: wsh_util_core.add_message(l_out_status);

3457: l_out_entity_name,
3458: l_out_status);
3459:
3460: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3461: wsh_util_core.add_message(l_out_status);
3462: RAISE FND_API.G_EXC_ERROR;
3463: END IF;
3464: -- End of code BugFix #3947506
3465: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');

Line 3469: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3465: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3466: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_out_entity_name); -- BugFix #3947506
3467: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
3468: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
3469: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3470: l_exp_logged := TRUE;
3471: wsh_util_core.add_message(x_return_status);
3472: l_stop_warnings := l_stop_warnings + 1;
3473: END IF;

Line 3471: wsh_util_core.add_message(x_return_status);

3467: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_out_entity_id); -- BugFix #3947506
3468: FND_MESSAGE.SET_TOKEN('EXCEPTION_BEHAVIOR','Warning');
3469: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3470: l_exp_logged := TRUE;
3471: wsh_util_core.add_message(x_return_status);
3472: l_stop_warnings := l_stop_warnings + 1;
3473: END IF;
3474: END IF;
3475: END LOOP;

Line 3503: WSH_UTIL_CORE.get_location_description

3499: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
3500: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
3501: --
3502: l_prev_stop_name := SUBSTRB(
3503: WSH_UTIL_CORE.get_location_description
3504: (
3505: prev_stop_rec.stop_location_id,
3506: 'NEW UI CODE'
3507: ),

Line 3531: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3527: --{
3528: IF p_in_rec.put_messages
3529: THEN
3530: --{
3531: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3532: --}
3533: END IF;
3534: --
3535: l_stop_warnings := l_stop_warnings + 1;

Line 3542: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3538: --{
3539: IF p_in_rec.put_messages
3540: THEN
3541: --{
3542: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3543: --}
3544: END IF;
3545: --
3546: --CLOSE prev_stop_csr;

Line 3548: RAISE wsh_util_core.e_not_allowed;

3544: END IF;
3545: --
3546: --CLOSE prev_stop_csr;
3547: --
3548: RAISE wsh_util_core.e_not_allowed;
3549: --}
3550: END IF;
3551: --}
3552: END LOOP;

Line 3597: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3593: --{
3594: IF p_in_rec.put_messages
3595: THEN
3596: --{
3597: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3598: --}
3599: END IF;
3600: --
3601: --CLOSE open_pickup_dlvy_csr;

Line 3603: RAISE wsh_util_core.e_not_allowed;

3599: END IF;
3600: --
3601: --CLOSE open_pickup_dlvy_csr;
3602: --
3603: RAISE wsh_util_core.e_not_allowed;
3604: --}
3605: ELSE
3606: --{
3607: IF p_in_rec.put_messages

Line 3610: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3606: --{
3607: IF p_in_rec.put_messages
3608: THEN
3609: --{
3610: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3611: --}
3612: END IF;
3613: --
3614: --CLOSE open_pickup_dlvy_csr;

Line 3717: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3713: --{
3714: IF p_in_rec.put_messages
3715: THEN
3716: --{
3717: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3718: --}
3719: END IF;
3720: --
3721: --CLOSE open_dropoff_dlvy_csr;

Line 3723: RAISE wsh_util_core.e_not_allowed;

3719: END IF;
3720: --
3721: --CLOSE open_dropoff_dlvy_csr;
3722: --
3723: RAISE wsh_util_core.e_not_allowed;
3724: --}
3725: --ELSE
3726: ELSIF
3727: -- stop's shipments type flag is mixed; checking status of inbound deliveries

Line 3740: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3736: --{
3737: IF p_in_rec.put_messages
3738: THEN
3739: --{
3740: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3741: --}
3742: END IF;
3743: --
3744: --CLOSE open_dropoff_dlvy_csr;

Line 3812: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3808: --{
3809: IF p_in_rec.put_messages
3810: THEN
3811: --{
3812: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3813: --}
3814: END IF;
3815: --
3816: --CLOSE prev_leg_csr;

Line 3818: RAISE wsh_util_core.e_not_allowed;

3814: END IF;
3815: --
3816: --CLOSE prev_leg_csr;
3817: --
3818: RAISE wsh_util_core.e_not_allowed;
3819: --}
3820: ELSE
3821: --{
3822: IF p_in_rec.put_messages

Line 3825: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3821: --{
3822: IF p_in_rec.put_messages
3823: THEN
3824: --{
3825: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3826: --}
3827: END IF;
3828: --
3829: --CLOSE prev_leg_csr;

Line 3858: WSH_UTIL_CORE.get_location_description

3854: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
3855: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
3856: --
3857: l_prev_stop_name := SUBSTRB(
3858: WSH_UTIL_CORE.get_location_description
3859: (
3860: prev_stop_rec.stop_location_id,
3861: 'NEW UI CODE'
3862: ),

Line 3885: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3881: --{
3882: IF p_in_rec.put_messages
3883: THEN
3884: --{
3885: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3886: --}
3887: END IF;
3888: --
3889: --CLOSE prev_leg_csr;

Line 3891: RAISE wsh_util_core.e_not_allowed;

3887: END IF;
3888: --
3889: --CLOSE prev_leg_csr;
3890: --
3891: RAISE wsh_util_core.e_not_allowed;
3892: --}
3893: ELSE
3894: --{
3895: IF p_in_rec.put_messages

Line 3898: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3894: --{
3895: IF p_in_rec.put_messages
3896: THEN
3897: --{
3898: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3899: --}
3900: END IF;
3901: --
3902: --CLOSE prev_leg_csr;

Line 3959: --wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3955: THEN
3956: --{
3957: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DLEG_ERROR');
3958: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
3959: --wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3960: --}
3961: END IF;
3962: --
3963: IF l_virtual_shipments_Type_flag = 'I'

Line 3969: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

3965: --{
3966: IF p_in_rec.put_messages
3967: THEN
3968: --{
3969: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3970: --}
3971: END IF;
3972: --
3973: --CLOSE prev_leg_csr;

Line 3975: RAISE wsh_util_core.e_not_allowed;

3971: END IF;
3972: --
3973: --CLOSE prev_leg_csr;
3974: --
3975: RAISE wsh_util_core.e_not_allowed;
3976: --}
3977: ELSE
3978: --{
3979: IF p_in_rec.put_messages

Line 3982: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

3978: --{
3979: IF p_in_rec.put_messages
3980: THEN
3981: --{
3982: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3983: --}
3984: END IF;
3985: --
3986: --CLOSE prev_leg_csr;

Line 4013: WSH_UTIL_CORE.get_location_description

4009: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
4010: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4011: --
4012: l_prev_stop_name := SUBSTRB(
4013: WSH_UTIL_CORE.get_location_description
4014: (
4015: prev_stop_rec.stop_location_id,
4016: 'NEW UI CODE'
4017: ),

Line 4040: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4036: --{
4037: IF p_in_rec.put_messages
4038: THEN
4039: --{
4040: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4041: --}
4042: END IF;
4043: --
4044: --CLOSE prev_leg_csr;

Line 4046: RAISE wsh_util_core.e_not_allowed;

4042: END IF;
4043: --
4044: --CLOSE prev_leg_csr;
4045: --
4046: RAISE wsh_util_core.e_not_allowed;
4047: --}
4048: ELSE
4049: --{
4050: IF p_in_rec.put_messages

Line 4053: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

4049: --{
4050: IF p_in_rec.put_messages
4051: THEN
4052: --{
4053: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4054: --}
4055: END IF;
4056: --
4057: --CLOSE prev_leg_csr;

Line 4162: --wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4158: THEN
4159: --{
4160: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_CLOSE_DO_DO_ERROR');
4161: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4162: --wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4163: --}
4164: END IF;
4165: --
4166: IF l_virtual_shipments_Type_flag = 'I'

Line 4172: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4168: --{
4169: IF p_in_rec.put_messages
4170: THEN
4171: --{
4172: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4173: --}
4174: END IF;
4175: --
4176: --CLOSE prev_leg_csr;

Line 4178: RAISE wsh_util_core.e_not_allowed;

4174: END IF;
4175: --
4176: --CLOSE prev_leg_csr;
4177: --
4178: RAISE wsh_util_core.e_not_allowed;
4179: --}
4180: ELSE
4181: --{
4182: IF p_in_rec.put_messages

Line 4185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

4181: --{
4182: IF p_in_rec.put_messages
4183: THEN
4184: --{
4185: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4186: --}
4187: END IF;
4188: --
4189: --CLOSE prev_leg_csr;

Line 4216: WSH_UTIL_CORE.get_location_description

4212: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
4213: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4214: --
4215: l_prev_stop_name := SUBSTRB(
4216: WSH_UTIL_CORE.get_location_description
4217: (
4218: prev_stop_rec.stop_location_id,
4219: 'NEW UI CODE'
4220: ),

Line 4243: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4239: --{
4240: IF p_in_rec.put_messages
4241: THEN
4242: --{
4243: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4244: --}
4245: END IF;
4246: --
4247: --CLOSE prev_leg_csr;

Line 4249: RAISE wsh_util_core.e_not_allowed;

4245: END IF;
4246: --
4247: --CLOSE prev_leg_csr;
4248: --
4249: RAISE wsh_util_core.e_not_allowed;
4250: --}
4251: ELSE
4252: --{
4253: IF p_in_rec.put_messages

Line 4256: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

4252: --{
4253: IF p_in_rec.put_messages
4254: THEN
4255: --{
4256: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4257: --}
4258: END IF;
4259: --
4260: --CLOSE prev_leg_csr;

Line 4331: WSH_UTIL_CORE.api_post_call

4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4329: END IF;
4330: --
4331: WSH_UTIL_CORE.api_post_call
4332: (
4333: p_return_status => l_return_status,
4334: x_num_warnings => l_num_warnings,
4335: x_num_errors => l_num_errors

Line 4357: WSH_UTIL_CORE.api_post_call

4353: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4354: END IF;
4355: --
4356:
4357: WSH_UTIL_CORE.api_post_call
4358: (
4359: p_return_status => l_return_status,
4360: x_num_warnings => l_num_warnings,
4361: x_num_errors => l_num_errors

Line 4379: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4375: --
4376: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4378: FND_MESSAGE.SET_TOKEN('WV','Weight');
4379: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4380: wsh_util_core.add_message(x_return_status);
4381: l_stop_warnings := l_stop_warnings + 1;
4382: END IF;
4383:

Line 4380: wsh_util_core.add_message(x_return_status);

4376: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4377: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4378: FND_MESSAGE.SET_TOKEN('WV','Weight');
4379: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4380: wsh_util_core.add_message(x_return_status);
4381: l_stop_warnings := l_stop_warnings + 1;
4382: END IF;
4383:
4384: IF (l_param_info.percent_fill_basis_flag = 'V' and l_stop_info_rec.departure_volume is NULL) THEN

Line 4393: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4389: --
4390: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4392: FND_MESSAGE.SET_TOKEN('WV','Volume');
4393: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4394: wsh_util_core.add_message(x_return_status);
4395: l_stop_warnings := l_stop_warnings + 1;
4396: END IF;
4397: END IF;

Line 4394: wsh_util_core.add_message(x_return_status);

4390: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4391: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));
4392: FND_MESSAGE.SET_TOKEN('WV','Volume');
4393: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4394: wsh_util_core.add_message(x_return_status);
4395: l_stop_warnings := l_stop_warnings + 1;
4396: END IF;
4397: END IF;
4398: --

Line 4416: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

4412: --{
4413: IF p_in_rec.put_messages
4414: THEN
4415: --{
4416: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4417: --}
4418: END IF;
4419: --
4420: l_stop_warnings := l_stop_warnings + 1;

Line 4427: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4423: --{
4424: IF p_in_rec.put_messages
4425: THEN
4426: --{
4427: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4428: --}
4429: END IF;
4430: --
4431: --CLOSE initial_pu_dlvy_csr;

Line 4432: RAISE wsh_util_core.e_not_allowed;

4428: --}
4429: END IF;
4430: --
4431: --CLOSE initial_pu_dlvy_csr;
4432: RAISE wsh_util_core.e_not_allowed;
4433: --}
4434: END IF;
4435: --}
4436: END IF;

Line 4458: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_initial_pu_dlvy_rec.organization_id);

4454: THEN
4455: --{
4456: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DATE_UNOPEN_PERIOD');
4457: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4458: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_initial_pu_dlvy_rec.organization_id);
4459: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name );
4460: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4461: --}
4462: END IF;

Line 4460: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4456: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DATE_UNOPEN_PERIOD');
4457: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4458: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_initial_pu_dlvy_rec.organization_id);
4459: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name );
4460: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4461: --}
4462: END IF;
4463: --
4464: --CLOSE initial_pu_dlvy_csr;

Line 4465: RAISE wsh_util_core.e_not_allowed;

4461: --}
4462: END IF;
4463: --
4464: --CLOSE initial_pu_dlvy_csr;
4465: RAISE wsh_util_core.e_not_allowed;
4466: --}
4467: END IF;
4468: --}
4469: END IF;

Line 4521: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_rec_organization_id);

4517: IF (l_period_id <= 0) THEN
4518: IF p_in_rec.put_messages THEN
4519: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DATE_UNOPEN_PERIOD');
4520: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4521: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_rec_organization_id);
4522: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name );
4523: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4524: END IF;
4525: RAISE wsh_util_core.e_not_allowed;

Line 4523: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4519: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_DATE_UNOPEN_PERIOD');
4520: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4521: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_rec_organization_id);
4522: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name );
4523: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4524: END IF;
4525: RAISE wsh_util_core.e_not_allowed;
4526: END IF;
4527: END IF; --}

Line 4525: RAISE wsh_util_core.e_not_allowed;

4521: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_rec_organization_id);
4522: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name );
4523: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4524: END IF;
4525: RAISE wsh_util_core.e_not_allowed;
4526: END IF;
4527: END IF; --}
4528: END IF; --}
4529: END IF; --}

Line 4553: WSH_UTIL_CORE.api_post_call

4549: IF l_debug_on THEN
4550: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4551: END IF;
4552: --
4553: WSH_UTIL_CORE.api_post_call
4554: (
4555: p_return_status => l_return_status,
4556: x_num_warnings => l_num_warnings,
4557: x_num_errors => l_num_errors

Line 4572: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);

4568: THEN
4569: --{
4570: FND_MESSAGE.SET_NAME('WSH','WSH_ITM_COMPLIANCE_WARN');
4571: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_initial_pu_dlvy_rec.name);
4572: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4573: --}
4574: END IF;
4575: --
4576: --CLOSE initial_pu_dlvy_csr;

Line 4577: RAISE wsh_util_core.e_not_allowed_warning;

4573: --}
4574: END IF;
4575: --
4576: --CLOSE initial_pu_dlvy_csr;
4577: RAISE wsh_util_core.e_not_allowed_warning;
4578: --}
4579: ELSE
4580: --{
4581: IF p_in_rec.put_messages

Line 4586: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4582: THEN
4583: --{
4584: FND_MESSAGE.SET_NAME('WSH','WSH_ITM_ERROR_STOP');
4585: FND_MESSAGE.SET_TOKEN('DEL_NAME', l_initial_pu_dlvy_rec.name);
4586: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4587: --}
4588: END IF;
4589: --
4590: --CLOSE initial_pu_dlvy_csr;

Line 4591: RAISE wsh_util_core.e_not_allowed;

4587: --}
4588: END IF;
4589: --
4590: --CLOSE initial_pu_dlvy_csr;
4591: RAISE wsh_util_core.e_not_allowed;
4592: --}
4593: END IF;
4594: --}
4595: END IF;

Line 4634: WSH_UTIL_CORE.api_post_call

4630: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4631: END IF;
4632: --
4633: --
4634: WSH_UTIL_CORE.api_post_call
4635: (
4636: p_return_status => l_return_status,
4637: x_num_warnings => l_num_warnings,
4638: x_num_errors => l_num_errors

Line 4687: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

4683: IF p_in_rec.put_messages
4684: THEN
4685: --{
4686: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_SM_NOT_FOUND');
4687: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4688: --}
4689: END IF;
4690: --
4691: --CLOSE initial_pu_dlvy_csr;

Line 4692: RAISE wsh_util_core.e_not_allowed;

4688: --}
4689: END IF;
4690: --
4691: --CLOSE initial_pu_dlvy_csr;
4692: RAISE wsh_util_core.e_not_allowed;
4693: --}
4694: END IF;
4695: --}
4696: END IF;

Line 4713: RAISE wsh_util_core.e_not_allowed;

4709: --
4710: IF l_dlvy_cnt = 0 AND l_err_dlvy_cnt > 0
4711: THEN
4712: --{
4713: RAISE wsh_util_core.e_not_allowed;
4714: --}
4715: END IF;
4716: --
4717: --

Line 4760: WSH_UTIL_CORE.api_post_call

4756: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4757: END IF;
4758: --
4759: --
4760: WSH_UTIL_CORE.api_post_call
4761: (
4762: p_return_status => l_return_status,
4763: x_num_warnings => l_num_warnings,
4764: x_num_errors => l_num_errors

Line 4826: WSH_UTIL_CORE.api_post_call

4822: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4823: END IF;
4824: --
4825: --
4826: WSH_UTIL_CORE.api_post_call
4827: (
4828: p_return_status => l_return_status,
4829: x_num_warnings => l_num_warnings,
4830: x_num_errors => l_num_errors

Line 4837: RAISE wsh_util_core.e_not_allowed;

4833: IF l_Allowed = 'N'
4834: THEN
4835: -- If trip cannot be set to In-transit, the stop cannot be closed
4836: l_num_warnings := l_num_warnings + 1;
4837: RAISE wsh_util_core.e_not_allowed;
4838: END IF;
4839: --
4840: IF l_Allowed IN ( 'YW', 'NW' )
4841: THEN

Line 4879: WSH_UTIL_CORE.api_post_call

4875: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4876: END IF;
4877: --
4878: --
4879: WSH_UTIL_CORE.api_post_call
4880: (
4881: p_return_status => l_return_status,
4882: x_num_warnings => l_num_warnings,
4883: x_num_errors => l_num_errors

Line 4890: RAISE wsh_util_core.e_not_allowed;

4886: IF l_Allowed = 'N'
4887: THEN
4888: -- If trip cannot be closed, the stop cannot be closed
4889: l_num_warnings := l_num_warnings + 1;
4890: RAISE wsh_util_core.e_not_allowed;
4891: END IF;
4892: --
4893: IF l_Allowed IN ( 'YW', 'NW' )
4894: THEN

Line 4912: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4908: --
4909: --
4910: IF l_num_errors > 0
4911: THEN
4912: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4913: x_out_rec.close_allowed := 'N';
4914: ELSIF l_num_warnings > 0
4915: THEN
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4912: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4913: x_out_rec.close_allowed := 'N';
4914: ELSIF l_num_warnings > 0
4915: THEN
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4917: ELSE
4918: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4919: END IF;
4920: --

Line 4918: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4914: ELSIF l_num_warnings > 0
4915: THEN
4916: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4917: ELSE
4918: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4919: END IF;
4920: --
4921: --
4922: IF l_stop_warnings > 0

Line 4938: WHEN wsh_util_core.e_not_allowed THEN

4934: --
4935: --}
4936: EXCEPTION
4937: --{
4938: WHEN wsh_util_core.e_not_allowed THEN
4939: IF l_num_warnings > 0
4940: THEN
4941: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4942: ELSE

Line 4941: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4937: --{
4938: WHEN wsh_util_core.e_not_allowed THEN
4939: IF l_num_warnings > 0
4940: THEN
4941: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4942: ELSE
4943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4944: END IF;
4945: --

Line 4943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4939: IF l_num_warnings > 0
4940: THEN
4941: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4942: ELSE
4943: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4944: END IF;
4945: --
4946: x_out_rec.close_allowed := 'N';
4947: --

Line 4950: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4946: x_out_rec.close_allowed := 'N';
4947: --
4948: --
4949: IF l_debug_on THEN
4950: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4951: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');
4952: END IF;
4953: --
4954: WHEN wsh_util_core.e_not_allowed_warning THEN

Line 4951: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');

4947: --
4948: --
4949: IF l_debug_on THEN
4950: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4951: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');
4952: END IF;
4953: --
4954: WHEN wsh_util_core.e_not_allowed_warning THEN
4955: IF l_num_warnings > 0

Line 4954: WHEN wsh_util_core.e_not_allowed_warning THEN

4950: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4951: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');
4952: END IF;
4953: --
4954: WHEN wsh_util_core.e_not_allowed_warning THEN
4955: IF l_num_warnings > 0
4956: THEN
4957: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4958: ELSE

Line 4957: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4953: --
4954: WHEN wsh_util_core.e_not_allowed_warning THEN
4955: IF l_num_warnings > 0
4956: THEN
4957: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4958: ELSE
4959: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4960: END IF;
4961: --

Line 4959: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4955: IF l_num_warnings > 0
4956: THEN
4957: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4958: ELSE
4959: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4960: END IF;
4961: --
4962: x_out_Rec.close_allowed := 'NW';
4963: --

Line 4972: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4968: END IF;
4969: --
4970: WHEN FND_API.G_EXC_ERROR THEN
4971:
4972: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4973: --
4974: IF l_debug_on THEN
4975: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4976: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 4981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4977: END IF;
4978: --
4979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4980:
4981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4982: --
4983: IF l_debug_on THEN
4984: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4985: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 4988: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

4984: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4985: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4986: END IF;
4987: --
4988: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4990: --
4991: IF l_debug_on THEN
4992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4985: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4986: END IF;
4987: --
4988: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4990: --
4991: IF l_debug_on THEN
4992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4993: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 4992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4988: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4990: --
4991: IF l_debug_on THEN
4992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4993: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4994: END IF;
4995: --
4996: WHEN OTHERS THEN

Line 4993: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

4989: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4990: --
4991: IF l_debug_on THEN
4992: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4993: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4994: END IF;
4995: --
4996: WHEN OTHERS THEN
4997: IF linked_stop_info_csr%ISOPEN THEN

Line 5003: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

4999: END IF;
5000: IF wsh_linked_stop_csr%ISOPEN THEN
5001: CLOSE wsh_linked_stop_csr;
5002: END IF;
5003: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5004: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE',l_module_name);
5005: --
5006: IF l_debug_on THEN
5007: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5004: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE',l_module_name);

5000: IF wsh_linked_stop_csr%ISOPEN THEN
5001: CLOSE wsh_linked_stop_csr;
5002: END IF;
5003: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5004: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE',l_module_name);
5005: --
5006: IF l_debug_on THEN
5007: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5008: END IF;

Line 5132: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5128: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5129: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5130: END IF;
5131: --
5132: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5133: --
5134: FOR ib_dlvy_rec IN ib_dlvy_cur(p_stop_id)
5135: LOOP
5136: --{

Line 5200: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5196: EXCEPTION
5197: --
5198: WHEN FND_API.G_EXC_ERROR THEN
5199:
5200: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5201: --
5202: IF l_debug_on THEN
5203: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5204: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

Line 5209: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

5205: END IF;
5206: --
5207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5208:
5209: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5210: --
5211: IF l_debug_on THEN
5212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 5216: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

5212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5214: END IF;
5215: --
5216: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

5213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5214: END IF;
5215: --
5216: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

Line 5220: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5216: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5222: END IF;
5223: --
5224: WHEN OTHERS THEN

Line 5221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

5217: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5218: --
5219: IF l_debug_on THEN
5220: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5222: END IF;
5223: --
5224: WHEN OTHERS THEN
5225:

Line 5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

5222: END IF;
5223: --
5224: WHEN OTHERS THEN
5225:
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5227: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5228: IF l_debug_on THEN
5229: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5230: END IF;

Line 5227: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);

5223: --
5224: WHEN OTHERS THEN
5225:
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5227: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5228: IF l_debug_on THEN
5229: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5230: END IF;
5231: --

Line 5770: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)

5766: p_attributes => l_attributes,
5767: x_return_status => l_return_status
5768: );
5769:
5770: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5771: THEN
5772: x_return_status := l_return_status;
5773: IF l_debug_on THEN
5774: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 5780: x_return_status := wsh_util_core.G_RET_STS_WARNING;

5776: wsh_debug_sv.pop(l_module_name);
5777: END IF;
5778: return;
5779: ELSE
5780: x_return_status := wsh_util_core.G_RET_STS_WARNING;
5781: END IF;
5782: END IF;
5783:
5784: IF l_debug_on THEN

Line 5792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

5788:
5789:
5790: EXCEPTION
5791: WHEN OTHERS THEN
5792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5793: --
5794: IF l_debug_on THEN
5795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5796: END IF;