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: cursor stop_to_del_cur( p_stop_id IN NUMBER ) is

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: cursor stop_to_del_cur( p_stop_id IN NUMBER ) is
900: select wnd.delivery_id,

Line 945: l_del_entity_ids WSH_UTIL_CORE.column_tab_type;

941: and (wdl.pick_up_stop_id = p_stop_id OR
942: wdl.drop_off_stop_id = p_stop_id );
943:
944: l_override_wf VARCHAR2(1);
945: l_del_entity_ids WSH_UTIL_CORE.column_tab_type;
946: l_purged_count NUMBER;
947: l_wf_rs VARCHAR2(1);
948: e_scpod_wf_inprogress EXCEPTION;
949: --==/

Line 952: l_valid_ids wsh_util_core.id_tab_type;

948: e_scpod_wf_inprogress EXCEPTION;
949: --==/
950:
951: l_stop_actions_tab StopActionsTabType;
952: l_valid_ids wsh_util_core.id_tab_type;
953: l_error_ids wsh_util_core.id_tab_type;
954: l_valid_index_tab wsh_util_core.id_tab_type;
955: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
956:

Line 953: l_error_ids wsh_util_core.id_tab_type;

949: --==/
950:
951: l_stop_actions_tab StopActionsTabType;
952: l_valid_ids wsh_util_core.id_tab_type;
953: l_error_ids wsh_util_core.id_tab_type;
954: l_valid_index_tab wsh_util_core.id_tab_type;
955: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
956:
957: l_tpw_temp VARCHAR2(1);

Line 954: l_valid_index_tab wsh_util_core.id_tab_type;

950:
951: l_stop_actions_tab StopActionsTabType;
952: l_valid_ids wsh_util_core.id_tab_type;
953: l_error_ids wsh_util_core.id_tab_type;
954: l_valid_index_tab wsh_util_core.id_tab_type;
955: l_dlvy_rec_tab WSH_DELIVERY_VALIDATIONS.dlvy_rec_tab_type;
956:
957: l_tpw_temp VARCHAR2(1);
958: l_return_status VARCHAR2(1);

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

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

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

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

Line 1074: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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

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

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

Line 1109: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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

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

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

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

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

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

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

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

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

Line 1155: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

Line 1163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1159: wsh_util_core.add_message(x_return_status,l_module_name);
1160: END IF;
1161: --}
1162: ELSIF (x_valid_ids.COUNT = p_stop_rec_tab.COUNT) THEN
1163: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1164: ELSIF (x_valid_ids.COUNT < p_stop_rec_tab.COUNT ) THEN
1165: --{
1166: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1167: --

Line 1166: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

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

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

Line 1175: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

Line 1204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 1586: p_disabled_list IN WSH_UTIL_CORE.column_tab_type

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

Line 1652: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1648: NULL;
1649: ELSE
1650: -- invalid name
1651: x_field_name := p_disabled_list(i);
1652: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1653: RETURN;
1654: --
1655: END IF;
1656: END LOOP;

Line 1772: p_disabled_list IN WSH_UTIL_CORE.column_tab_type

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

Line 1969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1965: --NULL;
1966: ELSE
1967: -- invalid name
1968: x_field_name := p_disabled_list(i);
1969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1970: RETURN;
1971: --
1972: END IF;
1973: END LOOP;

Line 1989: l_disabled_list WSH_UTIL_CORE.column_tab_type;

1985: , x_msg_data OUT NOCOPY VARCHAR2
1986: , x_stop_rec OUT NOCOPY WSH_TRIP_STOPS_PVT.trip_stop_rec_type
1987: )
1988: IS
1989: l_disabled_list WSH_UTIL_CORE.column_tab_type;
1990: l_db_col_rec WSH_TRIP_STOPS_PVT.trip_stop_rec_type;
1991: l_return_status VARCHAR2(30);
1992: l_field_name VARCHAR2(100);
1993: l_parent_entity_id NUMBER;

Line 2183: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR

2179: , x_msg_data
2180: , l_caller --3509004:public api changes
2181: );
2182: --
2183: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR
2184: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2185: THEN
2186: --
2187: IF l_debug_on THEN

Line 2184: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR

2180: , l_caller --3509004:public api changes
2181: );
2182: --
2183: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR
2184: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2185: THEN
2186: --
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 2245: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2241: x_stop_rec,
2242: l_return_status,
2243: l_field_name);
2244: --
2245: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2246: RAISE e_bad_field;
2247: END IF;
2248: --
2249: END IF;

Line 2277: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2273: l_return_status,
2274: l_field_name
2275: );
2276: --
2277: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2278: RAISE e_bad_field;
2279: END IF;
2280: --
2281: END IF;

Line 2296: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2292: p_out_rec => x_stop_rec,
2293: p_in_rec => p_in_rec,
2294: x_return_status => l_return_status);
2295: --
2296: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2297: x_return_status := l_return_status;
2298: END IF;
2299: --
2300: END IF;

Line 2315: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

Line 2331: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 2344: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

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

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

Line 2362: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 2399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2395: --
2396: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
2397: END IF;
2398: --
2399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2400:
2401: --
2402: -- J-IB-NPARIKH-{
2403: --

Line 2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 2570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2568: END IF;
2569: --
2570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2571: --
2572: IF p_trip_id IS NULL
2573: THEN
2574: --{

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

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

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

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

Line 2716: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

Line 2732: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

Line 2733: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

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

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

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

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

Line 2740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

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

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

Line 3176: l_itm_mark_dels wsh_util_core.id_tab_type;

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

Line 3233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3230: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3231: END IF;
3232: --
3233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3234: l_stop_warnings := 0;
3235: l_num_warnings := 0;
3236: l_num_errors := 0;
3237: --

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

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

Line 3354: WSH_UTIL_CORE.get_location_description

3350: l_location_id := l_stop_info_rec.stop_location_id;
3351: END IF;
3352:
3353: l_stop_name := SUBSTRB(
3354: WSH_UTIL_CORE.get_location_description
3355: (
3356: l_location_id,
3357: 'NEW UI CODE'
3358: ),

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

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

Line 3405: wsh_util_core.add_message(x_return_status);

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

Line 3417: WSH_UTIL_CORE.Get_Entity_Name

3413: FND_MESSAGE.SET_NAME('WSH','WSH_XC_EXIST_CONTENTS');
3414: END IF;
3415:
3416: -- BugFix #3947506
3417: WSH_UTIL_CORE.Get_Entity_Name
3418: ( l_exceptions_tbl(exp_cnt).entity_id,
3419: l_exceptions_tbl(exp_cnt).entity_name,
3420: l_out_entity_id,
3421: l_out_entity_name,

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

3420: l_out_entity_id,
3421: l_out_entity_name,
3422: l_out_status);
3423:
3424: IF ( l_out_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3425: wsh_util_core.add_message(l_out_status);
3426: RAISE FND_API.G_EXC_ERROR;
3427: END IF;
3428:

Line 3425: wsh_util_core.add_message(l_out_status);

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

Line 3434: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 3435: wsh_util_core.add_message(x_return_status);

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

Line 3437: RAISE wsh_util_core.e_not_allowed;

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

Line 3444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 3445: wsh_util_core.add_message(x_return_status);

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

Line 3449: WSH_UTIL_CORE.Get_Entity_Name

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

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

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

Line 3457: wsh_util_core.add_message(l_out_status);

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

Line 3465: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 3467: wsh_util_core.add_message(x_return_status);

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

Line 3499: WSH_UTIL_CORE.get_location_description

3495: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
3496: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
3497: --
3498: l_prev_stop_name := SUBSTRB(
3499: WSH_UTIL_CORE.get_location_description
3500: (
3501: prev_stop_rec.stop_location_id,
3502: 'NEW UI CODE'
3503: ),

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

3523: --{
3524: IF p_in_rec.put_messages
3525: THEN
3526: --{
3527: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3528: --}
3529: END IF;
3530: --
3531: l_stop_warnings := l_stop_warnings + 1;

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

3534: --{
3535: IF p_in_rec.put_messages
3536: THEN
3537: --{
3538: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3539: --}
3540: END IF;
3541: --
3542: --CLOSE prev_stop_csr;

Line 3544: RAISE wsh_util_core.e_not_allowed;

3540: END IF;
3541: --
3542: --CLOSE prev_stop_csr;
3543: --
3544: RAISE wsh_util_core.e_not_allowed;
3545: --}
3546: END IF;
3547: --}
3548: END LOOP;

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

3589: --{
3590: IF p_in_rec.put_messages
3591: THEN
3592: --{
3593: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3594: --}
3595: END IF;
3596: --
3597: --CLOSE open_pickup_dlvy_csr;

Line 3599: RAISE wsh_util_core.e_not_allowed;

3595: END IF;
3596: --
3597: --CLOSE open_pickup_dlvy_csr;
3598: --
3599: RAISE wsh_util_core.e_not_allowed;
3600: --}
3601: ELSE
3602: --{
3603: IF p_in_rec.put_messages

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

3602: --{
3603: IF p_in_rec.put_messages
3604: THEN
3605: --{
3606: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3607: --}
3608: END IF;
3609: --
3610: --CLOSE open_pickup_dlvy_csr;

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

3709: --{
3710: IF p_in_rec.put_messages
3711: THEN
3712: --{
3713: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3714: --}
3715: END IF;
3716: --
3717: --CLOSE open_dropoff_dlvy_csr;

Line 3719: RAISE wsh_util_core.e_not_allowed;

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

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

3732: --{
3733: IF p_in_rec.put_messages
3734: THEN
3735: --{
3736: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3737: --}
3738: END IF;
3739: --
3740: --CLOSE open_dropoff_dlvy_csr;

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

3804: --{
3805: IF p_in_rec.put_messages
3806: THEN
3807: --{
3808: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3809: --}
3810: END IF;
3811: --
3812: --CLOSE prev_leg_csr;

Line 3814: RAISE wsh_util_core.e_not_allowed;

3810: END IF;
3811: --
3812: --CLOSE prev_leg_csr;
3813: --
3814: RAISE wsh_util_core.e_not_allowed;
3815: --}
3816: ELSE
3817: --{
3818: IF p_in_rec.put_messages

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

3817: --{
3818: IF p_in_rec.put_messages
3819: THEN
3820: --{
3821: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3822: --}
3823: END IF;
3824: --
3825: --CLOSE prev_leg_csr;

Line 3854: WSH_UTIL_CORE.get_location_description

3850: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
3851: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
3852: --
3853: l_prev_stop_name := SUBSTRB(
3854: WSH_UTIL_CORE.get_location_description
3855: (
3856: prev_stop_rec.stop_location_id,
3857: 'NEW UI CODE'
3858: ),

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

3877: --{
3878: IF p_in_rec.put_messages
3879: THEN
3880: --{
3881: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3882: --}
3883: END IF;
3884: --
3885: --CLOSE prev_leg_csr;

Line 3887: RAISE wsh_util_core.e_not_allowed;

3883: END IF;
3884: --
3885: --CLOSE prev_leg_csr;
3886: --
3887: RAISE wsh_util_core.e_not_allowed;
3888: --}
3889: ELSE
3890: --{
3891: IF p_in_rec.put_messages

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

3890: --{
3891: IF p_in_rec.put_messages
3892: THEN
3893: --{
3894: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3895: --}
3896: END IF;
3897: --
3898: --CLOSE prev_leg_csr;

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

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

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

3961: --{
3962: IF p_in_rec.put_messages
3963: THEN
3964: --{
3965: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
3966: --}
3967: END IF;
3968: --
3969: --CLOSE prev_leg_csr;

Line 3971: RAISE wsh_util_core.e_not_allowed;

3967: END IF;
3968: --
3969: --CLOSE prev_leg_csr;
3970: --
3971: RAISE wsh_util_core.e_not_allowed;
3972: --}
3973: ELSE
3974: --{
3975: IF p_in_rec.put_messages

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

3974: --{
3975: IF p_in_rec.put_messages
3976: THEN
3977: --{
3978: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3979: --}
3980: END IF;
3981: --
3982: --CLOSE prev_leg_csr;

Line 4009: WSH_UTIL_CORE.get_location_description

4005: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
4006: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4007: --
4008: l_prev_stop_name := SUBSTRB(
4009: WSH_UTIL_CORE.get_location_description
4010: (
4011: prev_stop_rec.stop_location_id,
4012: 'NEW UI CODE'
4013: ),

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

4032: --{
4033: IF p_in_rec.put_messages
4034: THEN
4035: --{
4036: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4037: --}
4038: END IF;
4039: --
4040: --CLOSE prev_leg_csr;

Line 4042: RAISE wsh_util_core.e_not_allowed;

4038: END IF;
4039: --
4040: --CLOSE prev_leg_csr;
4041: --
4042: RAISE wsh_util_core.e_not_allowed;
4043: --}
4044: ELSE
4045: --{
4046: IF p_in_rec.put_messages

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

4045: --{
4046: IF p_in_rec.put_messages
4047: THEN
4048: --{
4049: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4050: --}
4051: END IF;
4052: --
4053: --CLOSE prev_leg_csr;

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

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

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

4164: --{
4165: IF p_in_rec.put_messages
4166: THEN
4167: --{
4168: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4169: --}
4170: END IF;
4171: --
4172: --CLOSE prev_leg_csr;

Line 4174: RAISE wsh_util_core.e_not_allowed;

4170: END IF;
4171: --
4172: --CLOSE prev_leg_csr;
4173: --
4174: RAISE wsh_util_core.e_not_allowed;
4175: --}
4176: ELSE
4177: --{
4178: IF p_in_rec.put_messages

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

4177: --{
4178: IF p_in_rec.put_messages
4179: THEN
4180: --{
4181: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4182: --}
4183: END IF;
4184: --
4185: --CLOSE prev_leg_csr;

Line 4212: WSH_UTIL_CORE.get_location_description

4208: FND_MESSAGE.SET_NAME('WSH','WSH_PREV_STOP_NOT_CLOSED');
4209: FND_MESSAGE.SET_TOKEN('STOP_NAME', l_stop_name );
4210: --
4211: l_prev_stop_name := SUBSTRB(
4212: WSH_UTIL_CORE.get_location_description
4213: (
4214: prev_stop_rec.stop_location_id,
4215: 'NEW UI CODE'
4216: ),

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

4235: --{
4236: IF p_in_rec.put_messages
4237: THEN
4238: --{
4239: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4240: --}
4241: END IF;
4242: --
4243: --CLOSE prev_leg_csr;

Line 4245: RAISE wsh_util_core.e_not_allowed;

4241: END IF;
4242: --
4243: --CLOSE prev_leg_csr;
4244: --
4245: RAISE wsh_util_core.e_not_allowed;
4246: --}
4247: ELSE
4248: --{
4249: IF p_in_rec.put_messages

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

4248: --{
4249: IF p_in_rec.put_messages
4250: THEN
4251: --{
4252: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4253: --}
4254: END IF;
4255: --
4256: --CLOSE prev_leg_csr;

Line 4327: WSH_UTIL_CORE.api_post_call

4323: IF l_debug_on THEN
4324: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4325: END IF;
4326: --
4327: WSH_UTIL_CORE.api_post_call
4328: (
4329: p_return_status => l_return_status,
4330: x_num_warnings => l_num_warnings,
4331: x_num_errors => l_num_errors

Line 4353: WSH_UTIL_CORE.api_post_call

4349: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4350: END IF;
4351: --
4352:
4353: WSH_UTIL_CORE.api_post_call
4354: (
4355: p_return_status => l_return_status,
4356: x_num_warnings => l_num_warnings,
4357: x_num_errors => l_num_errors

Line 4375: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 4376: wsh_util_core.add_message(x_return_status);

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

Line 4389: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 4390: wsh_util_core.add_message(x_return_status);

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

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

4408: --{
4409: IF p_in_rec.put_messages
4410: THEN
4411: --{
4412: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
4413: --}
4414: END IF;
4415: --
4416: l_stop_warnings := l_stop_warnings + 1;

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

4419: --{
4420: IF p_in_rec.put_messages
4421: THEN
4422: --{
4423: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4424: --}
4425: END IF;
4426: --
4427: --CLOSE initial_pu_dlvy_csr;

Line 4428: RAISE wsh_util_core.e_not_allowed;

4424: --}
4425: END IF;
4426: --
4427: --CLOSE initial_pu_dlvy_csr;
4428: RAISE wsh_util_core.e_not_allowed;
4429: --}
4430: END IF;
4431: --}
4432: END IF;

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

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

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

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

Line 4461: RAISE wsh_util_core.e_not_allowed;

4457: --}
4458: END IF;
4459: --
4460: --CLOSE initial_pu_dlvy_csr;
4461: RAISE wsh_util_core.e_not_allowed;
4462: --}
4463: END IF;
4464: --}
4465: END IF;

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

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

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

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

Line 4521: RAISE wsh_util_core.e_not_allowed;

4517: l_org_name := WSH_UTIL_CORE.Get_Org_Name(l_rec_organization_id);
4518: FND_MESSAGE.SET_TOKEN('ORG_NAME', l_org_name );
4519: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4520: END IF;
4521: RAISE wsh_util_core.e_not_allowed;
4522: END IF;
4523: END IF; --}
4524: END IF; --}
4525: END IF; --}

Line 4549: WSH_UTIL_CORE.api_post_call

4545: IF l_debug_on THEN
4546: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4547: END IF;
4548: --
4549: WSH_UTIL_CORE.api_post_call
4550: (
4551: p_return_status => l_return_status,
4552: x_num_warnings => l_num_warnings,
4553: x_num_errors => l_num_errors

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

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

Line 4573: RAISE wsh_util_core.e_not_allowed_warning;

4569: --}
4570: END IF;
4571: --
4572: --CLOSE initial_pu_dlvy_csr;
4573: RAISE wsh_util_core.e_not_allowed_warning;
4574: --}
4575: ELSE
4576: --{
4577: IF p_in_rec.put_messages

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

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

Line 4587: RAISE wsh_util_core.e_not_allowed;

4583: --}
4584: END IF;
4585: --
4586: --CLOSE initial_pu_dlvy_csr;
4587: RAISE wsh_util_core.e_not_allowed;
4588: --}
4589: END IF;
4590: --}
4591: END IF;

Line 4630: WSH_UTIL_CORE.api_post_call

4626: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4627: END IF;
4628: --
4629: --
4630: WSH_UTIL_CORE.api_post_call
4631: (
4632: p_return_status => l_return_status,
4633: x_num_warnings => l_num_warnings,
4634: x_num_errors => l_num_errors

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

4679: IF p_in_rec.put_messages
4680: THEN
4681: --{
4682: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_SM_NOT_FOUND');
4683: WSH_UTIL_CORE.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4684: --}
4685: END IF;
4686: --
4687: --CLOSE initial_pu_dlvy_csr;

Line 4688: RAISE wsh_util_core.e_not_allowed;

4684: --}
4685: END IF;
4686: --
4687: --CLOSE initial_pu_dlvy_csr;
4688: RAISE wsh_util_core.e_not_allowed;
4689: --}
4690: END IF;
4691: --}
4692: END IF;

Line 4709: RAISE wsh_util_core.e_not_allowed;

4705: --
4706: IF l_dlvy_cnt = 0 AND l_err_dlvy_cnt > 0
4707: THEN
4708: --{
4709: RAISE wsh_util_core.e_not_allowed;
4710: --}
4711: END IF;
4712: --
4713: --

Line 4756: WSH_UTIL_CORE.api_post_call

4752: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4753: END IF;
4754: --
4755: --
4756: WSH_UTIL_CORE.api_post_call
4757: (
4758: p_return_status => l_return_status,
4759: x_num_warnings => l_num_warnings,
4760: x_num_errors => l_num_errors

Line 4822: WSH_UTIL_CORE.api_post_call

4818: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4819: END IF;
4820: --
4821: --
4822: WSH_UTIL_CORE.api_post_call
4823: (
4824: p_return_status => l_return_status,
4825: x_num_warnings => l_num_warnings,
4826: x_num_errors => l_num_errors

Line 4833: RAISE wsh_util_core.e_not_allowed;

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

Line 4875: WSH_UTIL_CORE.api_post_call

4871: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4872: END IF;
4873: --
4874: --
4875: WSH_UTIL_CORE.api_post_call
4876: (
4877: p_return_status => l_return_status,
4878: x_num_warnings => l_num_warnings,
4879: x_num_errors => l_num_errors

Line 4886: RAISE wsh_util_core.e_not_allowed;

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

Line 4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4904: --
4905: --
4906: IF l_num_errors > 0
4907: THEN
4908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4909: x_out_rec.close_allowed := 'N';
4910: ELSIF l_num_warnings > 0
4911: THEN
4912: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4912: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 4914: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4910: ELSIF l_num_warnings > 0
4911: THEN
4912: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4913: ELSE
4914: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4915: END IF;
4916: --
4917: --
4918: IF l_stop_warnings > 0

Line 4934: WHEN wsh_util_core.e_not_allowed THEN

4930: --
4931: --}
4932: EXCEPTION
4933: --{
4934: WHEN wsh_util_core.e_not_allowed THEN
4935: IF l_num_warnings > 0
4936: THEN
4937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4938: ELSE

Line 4937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

Line 4939: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4935: IF l_num_warnings > 0
4936: THEN
4937: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4938: ELSE
4939: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4940: END IF;
4941: --
4942: x_out_rec.close_allowed := 'N';
4943: --

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

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

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

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

Line 4950: WHEN wsh_util_core.e_not_allowed_warning THEN

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

Line 4953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4949: --
4950: WHEN wsh_util_core.e_not_allowed_warning THEN
4951: IF l_num_warnings > 0
4952: THEN
4953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4954: ELSE
4955: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4956: END IF;
4957: --

Line 4955: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4951: IF l_num_warnings > 0
4952: THEN
4953: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4954: ELSE
4955: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4956: END IF;
4957: --
4958: x_out_Rec.close_allowed := 'NW';
4959: --

Line 4968: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 4977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

Line 4984: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

Line 4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

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

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

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

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

Line 4999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

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

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

Line 5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5124: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5125: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5126: END IF;
5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5129: --
5130: FOR ib_dlvy_rec IN ib_dlvy_cur(p_stop_id)
5131: LOOP
5132: --{

Line 5196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 5205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

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

Line 5212: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

Line 5213: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

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

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

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

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

Line 5222: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

5218: END IF;
5219: --
5220: WHEN OTHERS THEN
5221:
5222: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5223: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5224: IF l_debug_on THEN
5225: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5226: END IF;

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

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

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

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

Line 5776: x_return_status := wsh_util_core.G_RET_STS_WARNING;

5772: wsh_debug_sv.pop(l_module_name);
5773: END IF;
5774: return;
5775: ELSE
5776: x_return_status := wsh_util_core.G_RET_STS_WARNING;
5777: END IF;
5778: END IF;
5779:
5780: IF l_debug_on THEN

Line 5788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

5784:
5785:
5786: EXCEPTION
5787: WHEN OTHERS THEN
5788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5789: --
5790: IF l_debug_on THEN
5791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5792: END IF;