APPS.FTE_CARRIER_RANK_LIST_PVT dependencies on WSH_UTIL_CORE

Line 34: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

30: ) IS
31:
32: BEGIN
33:
34: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
35:
36:
37: UPDATE FTE_CARRIER_RANK_LIST SET
38: CARRIER_ID = decode(p_rank_info_rec.CARRIER_ID,NULL,CARRIER_ID,

Line 146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

142:
143: EXCEPTION
144: WHEN no_data_found THEN
145: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
147: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
148: WHEN others THEN
149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');
150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 147: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

143: EXCEPTION
144: WHEN no_data_found THEN
145: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
147: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
148: WHEN others THEN
149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');
150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
151:

Line 149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');

145: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
147: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
148: WHEN others THEN
149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');
150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
151:
152: END UPDATE_RANK;
153:

Line 150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

146: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
147: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
148: WHEN others THEN
149: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.UPDATE');
150: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
151:
152: END UPDATE_RANK;
153:
154: PROCEDURE SET_RANK_CURRENT(

Line 205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

201: IF l_debug_on THEN
202: WSH_DEBUG_SV.push(l_module_name);
203: END IF;
204:
205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
206:
207:
208: IF l_debug_on
209: THEN

Line 273: wsh_util_core.api_post_call(

269: l_return_status,
270: WSH_DEBUG_SV.C_PROC_LEVEL);
271: END IF;
272:
273: wsh_util_core.api_post_call(
274: p_return_status =>l_return_status,
275: x_num_warnings =>l_number_of_warnings,
276: x_num_errors =>l_number_of_errors,
277: p_msg_data =>l_msg_data);

Line 282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

278:
279:
280: IF l_number_of_errors > 0
281: THEN
282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
283: RAISE FND_API.G_EXC_ERROR;
284: ELSIF l_number_of_warnings > 0
285: THEN
286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

282: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
283: RAISE FND_API.G_EXC_ERROR;
284: ELSIF l_number_of_warnings > 0
285: THEN
286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
287: ELSE
288: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
289: END IF;
290:

Line 288: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

284: ELSIF l_number_of_warnings > 0
285: THEN
286: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
287: ELSE
288: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
289: END IF;
290:
291:
292: IF l_debug_on THEN

Line 306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

302: END IF;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK TO SET_RANK_CURRENT_PUB;
306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.pop(l_module_name);
309: END IF;
310:

Line 313: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.SET_RANK_CURRENT');

309: END IF;
310:
311: WHEN OTHERS THEN
312: ROLLBACK TO SET_RANK_CURRENT_PUB;
313: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.SET_RANK_CURRENT');
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name);
317: END IF;

Line 314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

310:
311: WHEN OTHERS THEN
312: ROLLBACK TO SET_RANK_CURRENT_PUB;
313: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.SET_RANK_CURRENT');
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name);
317: END IF;
318:

Line 363: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

359: WSH_DEBUG_SV.push(l_module_name);
360: END IF;
361:
362:
363: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
364:
365: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
366: l_number_of_warnings := 0;
367: l_number_of_errors := 0;

Line 365: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

361:
362:
363: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
364:
365: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
366: l_number_of_warnings := 0;
367: l_number_of_errors := 0;
368:
369:

Line 382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

378: CLOSE GET_TENDER_STATUS;
379:
380: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP');
381: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
383: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
384: RAISE FND_API.G_EXC_ERROR;
385:
386: END IF;

Line 383: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

379:
380: FND_MESSAGE.SET_NAME('FTE','FTE_INVALID_TRIP');
381: FND_MESSAGE.SET_TOKEN('TRIP_ID', p_trip_id);
382: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
383: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
384: RAISE FND_API.G_EXC_ERROR;
385:
386: END IF;
387:

Line 397: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',

393: THEN
394:
395: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_DELETE_TENDER_CHECK');
396: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',
397: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
398: l_tender_status));
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
400: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
401: RAISE FND_API.G_EXC_ERROR;

Line 399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

395: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_DELETE_TENDER_CHECK');
396: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',
397: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
398: l_tender_status));
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
400: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:

Line 400: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

396: FND_MESSAGE.SET_TOKEN('TENDER_STATUS',
397: WSH_UTIL_CORE.Get_Lookup_Meaning('WSH_TENDER_STATUS',
398: l_tender_status));
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
400: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403:
404:

Line 419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

415: WHEN no_data_found THEN
416: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
417: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_TRIP_NOT_FOUND');
418: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
421: RAISE FND_API.G_EXC_ERROR;
422: END;
423:

Line 420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

416: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
417: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_TRIP_NOT_FOUND');
418: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_name);
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
420: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
421: RAISE FND_API.G_EXC_ERROR;
422: END;
423:
424:

Line 464: wsh_util_core.api_post_call(

460: l_return_status,
461: WSH_DEBUG_SV.C_PROC_LEVEL);
462: END IF;
463:
464: wsh_util_core.api_post_call(
465: p_return_status =>l_return_status,
466: x_num_warnings =>l_number_of_warnings,
467: x_num_errors =>l_number_of_errors,
468: p_msg_data =>l_msg_data);

Line 472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

468: p_msg_data =>l_msg_data);
469:
470: IF l_number_of_errors > 0
471: THEN
472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: RAISE FND_API.G_EXC_ERROR;
474: ELSIF l_number_of_warnings > 0
475: THEN
476: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 476: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
473: RAISE FND_API.G_EXC_ERROR;
474: ELSIF l_number_of_warnings > 0
475: THEN
476: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
477: ELSE
478: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
479: END IF;
480:

Line 478: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

474: ELSIF l_number_of_warnings > 0
475: THEN
476: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
477: ELSE
478: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
479: END IF;
480:
481: IF l_debug_on
482: THEN

Line 506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');

502: IF l_debug_on THEN
503: WSH_DEBUG_SV.pop(l_module_name);
504: END IF;
505: WHEN others THEN
506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.pop(l_module_name);
510: END IF;

Line 507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

503: WSH_DEBUG_SV.pop(l_module_name);
504: END IF;
505: WHEN others THEN
506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.pop(l_module_name);
510: END IF;
511:

Line 545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

541: WSH_DEBUG_SV.push(l_module_name);
542: END IF;
543:
544:
545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
546:
547:
548: if (p_rank_info_rec.trip_id IS NULL or
549: p_rank_info_rec.trip_id = FND_API.G_MISS_NUM) then

Line 714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

710:
711: EXCEPTION
712: WHEN EMPTY_TRIP_ID THEN
713: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_TRIP_ID_MISSING');
714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
716: WHEN EMPTY_RANK_SEQUENCE THEN
717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

711: EXCEPTION
712: WHEN EMPTY_TRIP_ID THEN
713: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_TRIP_ID_MISSING');
714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
716: WHEN EMPTY_RANK_SEQUENCE THEN
717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

Line 718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

714: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
716: WHEN EMPTY_RANK_SEQUENCE THEN
717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
720: WHEN others THEN
721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
716: WHEN EMPTY_RANK_SEQUENCE THEN
717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
720: WHEN others THEN
721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
723: END CREATE_RANK;

Line 721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');

717: FND_MESSAGE.SET_NAME('FTE', 'FTE_RANK_SEQUENCE_MISSING');
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
720: WHEN others THEN
721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
723: END CREATE_RANK;
724:
725:

Line 722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

718: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
719: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
720: WHEN others THEN
721: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE');
722: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
723: END CREATE_RANK;
724:
725:
726: PROCEDURE CREATE_RANK_LIST(

Line 777: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

773: IF l_debug_on THEN
774: WSH_DEBUG_SV.push(l_module_name);
775: END IF;
776:
777: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
778:
779: --{
780: IF l_debug_on
781: THEN

Line 800: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

796: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
797:
798: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_EXISTS');
799: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
800: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
801: RAISE FND_API.G_EXC_ERROR;
802: END IF;
803:
804: l_currentSet := FND_API.G_FALSE;

Line 846: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

842: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
843:
844: FND_MESSAGE.SET_NAME('FTE','FTE_CANNOT_SET_MORE_CURR');
845: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
846: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
849:
850: l_currentSet := FND_API.G_TRUE;

Line 883: wsh_util_core.api_post_call(

879: END IF;
880:
881: -- Change this call with Shipping API
882:
883: wsh_util_core.api_post_call(
884: p_return_status =>l_return_status,
885: x_num_warnings =>l_number_of_warnings,
886: x_num_errors =>l_number_of_errors,
887: p_msg_data =>l_msg_data);

Line 892: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

888:
889:
890: IF l_number_of_errors > 0
891: THEN
892: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_number_of_warnings > 0
895: THEN
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

892: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
893: RAISE FND_API.G_EXC_ERROR;
894: ELSIF l_number_of_warnings > 0
895: THEN
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
897: ELSE
898: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
899: END IF;
900:

Line 898: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

894: ELSIF l_number_of_warnings > 0
895: THEN
896: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
897: ELSE
898: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
899: END IF;
900:
901:
902: END IF;

Line 920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

916: END IF;
917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO CREATE_RANK_LIST_PUB;
920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
921: IF l_debug_on THEN
922: WSH_DEBUG_SV.pop(l_module_name);
923: END IF;
924:

Line 927: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST');

923: END IF;
924:
925: WHEN OTHERS THEN
926: ROLLBACK TO CREATE_RANK_LIST_PUB;
927: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST');
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.pop(l_module_name);
931: END IF;

Line 928: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

924:
925: WHEN OTHERS THEN
926: ROLLBACK TO CREATE_RANK_LIST_PUB;
927: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST');
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.pop(l_module_name);
931: END IF;
932:

Line 977: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

973: IF l_debug_on THEN
974: WSH_DEBUG_SV.push(l_module_name);
975: END IF;
976:
977: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
978:
979: --{
980: IF l_debug_on
981: THEN

Line 998: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

994: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
995:
996: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_NOTEXISTS');
997: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
998: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
999: RAISE FND_API.G_EXC_ERROR;
1000: END IF;
1001:
1002: CLOSE get_trip;

Line 1050: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1046: END IF;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1050: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.pop(l_module_name);
1053: END IF;
1054:

Line 1057: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.UPDATE_RANK_LIST');

1053: END IF;
1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1057: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.UPDATE_RANK_LIST');
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.pop(l_module_name);
1061: END IF;

Line 1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1057: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.UPDATE_RANK_LIST');
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.pop(l_module_name);
1061: END IF;
1062:

Line 1113: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1109: WSH_DEBUG_SV.push(l_module_name);
1110: END IF;
1111:
1112:
1113: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1114: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1115: l_number_of_warnings := 0;
1116: l_number_of_errors := 0;
1117:

Line 1114: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1110: END IF;
1111:
1112:
1113: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1114: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1115: l_number_of_warnings := 0;
1116: l_number_of_errors := 0;
1117:
1118: --{

Line 1132: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1128:
1129: IF (l_max_rank_seq IS NULL) THEN
1130: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_LIST_NOTEXISTS');
1131: FND_MESSAGE.SET_TOKEN('TRIP_ID',p_trip_id);
1132: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1133: RAISE FND_API.G_EXC_ERROR;
1134: END IF;
1135:
1136:

Line 1166: wsh_util_core.api_post_call(

1162: l_return_status,
1163: WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;
1165:
1166: wsh_util_core.api_post_call(
1167: p_return_status =>l_return_status,
1168: x_num_warnings =>l_number_of_warnings,
1169: x_num_errors =>l_number_of_errors,
1170: p_msg_data =>l_msg_data);

Line 1181: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);

1177: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_trip_id;
1178:
1179: FND_MESSAGE.SET_NAME('FTE','FTE_CANNOT_SET_MORE_CURR');
1180: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
1181: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:
1185: l_currentSet := FND_API.G_TRUE;

Line 1219: wsh_util_core.api_post_call(

1215: END IF;
1216:
1217: -- Change this call with Shipping API
1218:
1219: wsh_util_core.api_post_call(
1220: p_return_status =>l_return_status,
1221: x_num_warnings =>l_number_of_warnings,
1222: x_num_errors =>l_number_of_errors,
1223: p_msg_data =>l_msg_data);

Line 1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1228:
1229:
1230: IF l_number_of_errors > 0
1231: THEN
1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1233: RAISE FND_API.G_EXC_ERROR;
1234: ELSIF l_number_of_warnings > 0
1235: THEN
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1232: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1233: RAISE FND_API.G_EXC_ERROR;
1234: ELSIF l_number_of_warnings > 0
1235: THEN
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1237: ELSE
1238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1239: END IF;
1240:

Line 1238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1234: ELSIF l_number_of_warnings > 0
1235: THEN
1236: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1237: ELSE
1238: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1239: END IF;
1240:
1241: p_ranklist(i).RANK_ID := l_rank_id;
1242:

Line 1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1257: END IF;
1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO APPEND_RANK_LIST_PUB;
1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1262: IF l_debug_on THEN
1263: WSH_DEBUG_SV.pop(l_module_name);
1264: END IF;
1265:

Line 1268: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.APPEND_RANK_LIST');

1264: END IF;
1265:
1266: WHEN OTHERS THEN
1267: ROLLBACK TO APPEND_RANK_LIST_PUB;
1268: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.APPEND_RANK_LIST');
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.pop(l_module_name);
1272: END IF;

Line 1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1265:
1266: WHEN OTHERS THEN
1267: ROLLBACK TO APPEND_RANK_LIST_PUB;
1268: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.APPEND_RANK_LIST');
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.pop(l_module_name);
1272: END IF;
1273: END APPEND_RANK_LIST;

Line 1332: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1328: THEN
1329: FND_MSG_PUB.initialize;
1330: END IF;
1331:
1332: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1333: x_msg_count := 0;
1334: x_msg_data := 0;
1335: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1336: l_number_of_warnings := 0;

Line 1335: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1331:
1332: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1333: x_msg_count := 0;
1334: x_msg_data := 0;
1335: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1336: l_number_of_warnings := 0;
1337: l_number_of_errors := 0;
1338:
1339: --{

Line 1420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1416: EXCEPTION
1417: WHEN NO_DATA_FOUND THEN
1418: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
1419: FND_MESSAGE.SET_TOKEN('RANK_ID', p_rank_id);
1420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1421: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1422: RAISE FND_API.G_EXC_ERROR;
1423:
1424: END;

Line 1421: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

1417: WHEN NO_DATA_FOUND THEN
1418: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
1419: FND_MESSAGE.SET_TOKEN('RANK_ID', p_rank_id);
1420: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1421: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
1422: RAISE FND_API.G_EXC_ERROR;
1423:
1424: END;
1425:

Line 1542: wsh_util_core.api_post_call(

1538: l_return_status,
1539: WSH_DEBUG_SV.C_PROC_LEVEL);
1540: END IF;
1541:
1542: wsh_util_core.api_post_call(
1543: p_return_status =>l_return_status,
1544: x_num_warnings =>l_number_of_warnings,
1545: x_num_errors =>l_number_of_errors,
1546: p_msg_data =>l_msg_data);

Line 1550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1546: p_msg_data =>l_msg_data);
1547:
1548: IF l_number_of_errors > 0
1549: THEN
1550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1551: RAISE FND_API.G_EXC_ERROR;
1552: ELSIF l_number_of_warnings > 0
1553: THEN
1554: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1554: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1551: RAISE FND_API.G_EXC_ERROR;
1552: ELSIF l_number_of_warnings > 0
1553: THEN
1554: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1555: ELSE
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1557: END IF;
1558:

Line 1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1552: ELSIF l_number_of_warnings > 0
1553: THEN
1554: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1555: ELSE
1556: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1557: END IF;
1558:
1559: END IF;
1560:

Line 1597: wsh_util_core.api_post_call(

1593: END IF;
1594:
1595:
1596:
1597: wsh_util_core.api_post_call(
1598: p_return_status =>l_return_status,
1599: x_num_warnings =>l_number_of_warnings,
1600: x_num_errors =>l_number_of_errors,
1601: p_msg_data =>l_msg_data);

Line 1606: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1602:
1603:
1604: IF l_number_of_errors > 0
1605: THEN
1606: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1607: RAISE FND_API.G_EXC_ERROR;
1608: ELSIF l_number_of_warnings > 0
1609: THEN
1610: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1610: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1606: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1607: RAISE FND_API.G_EXC_ERROR;
1608: ELSIF l_number_of_warnings > 0
1609: THEN
1610: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1611: ELSE
1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1613: END IF;
1614:

Line 1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1608: ELSIF l_number_of_warnings > 0
1609: THEN
1610: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1611: ELSE
1612: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1613: END IF;
1614:
1615:
1616: -- Standard call to get message count and if count is 1,get message info.

Line 1658: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');

1654: );
1655:
1656: WHEN OTHERS THEN
1657: ROLLBACK TO RANK_LIST_ACTION_PUB;
1658: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');
1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1660: FND_MSG_PUB.Count_And_Get
1661: (
1662: p_count => x_msg_count,

Line 1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1655:
1656: WHEN OTHERS THEN
1657: ROLLBACK TO RANK_LIST_ACTION_PUB;
1658: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION');
1659: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1660: FND_MSG_PUB.Count_And_Get
1661: (
1662: p_count => x_msg_count,
1663: p_data => x_msg_data,

Line 1724: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1720: THEN
1721: FND_MSG_PUB.initialize;
1722: END IF;
1723:
1724: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1725: x_msg_count := 0;
1726: x_msg_data := 0;
1727: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1728: l_number_of_warnings := 0;

Line 1727: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1723:
1724: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1725: x_msg_count := 0;
1726: x_msg_data := 0;
1727: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1728: l_number_of_warnings := 0;
1729: l_number_of_errors := 0;
1730:
1731: --{

Line 1783: wsh_util_core.api_post_call(

1779: p_ranklist => l_carrier_rank_list_tbl,
1780: p_trip_id => p_trip_id,
1781: p_rank_id => p_rank_id);
1782:
1783: wsh_util_core.api_post_call(
1784: p_return_status =>l_return_status,
1785: x_num_warnings =>l_number_of_warnings,
1786: x_num_errors =>l_number_of_errors,
1787: p_msg_data =>l_msg_data);

Line 1792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1788:
1789:
1790: IF l_number_of_errors > 0
1791: THEN
1792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1793: RAISE FND_API.G_EXC_ERROR;
1794: ELSIF l_number_of_warnings > 0
1795: THEN
1796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1792: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1793: RAISE FND_API.G_EXC_ERROR;
1794: ELSIF l_number_of_warnings > 0
1795: THEN
1796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1797: ELSE
1798: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1799: END IF;
1800:

Line 1798: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1794: ELSIF l_number_of_warnings > 0
1795: THEN
1796: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1797: ELSE
1798: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1799: END IF;
1800:
1801: -- now send back all the information back through x_ranklist
1802:

Line 1895: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER_PUB');

1891: );
1892:
1893: WHEN OTHERS THEN
1894: ROLLBACK TO RANK_LIST_ACTION_UIWRAPPER_PUB;
1895: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER_PUB');
1896: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1897: FND_MSG_PUB.Count_And_Get
1898: (
1899: p_count => x_msg_count,

Line 1896: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1892:
1893: WHEN OTHERS THEN
1894: ROLLBACK TO RANK_LIST_ACTION_UIWRAPPER_PUB;
1895: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER_PUB');
1896: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1897: FND_MSG_PUB.Count_And_Get
1898: (
1899: p_count => x_msg_count,
1900: p_data => x_msg_data,

Line 1990: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1986: WSH_DEBUG_SV.push(l_module_name);
1987: END IF;
1988:
1989:
1990: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1991: x_msg_count := 0;
1992: x_msg_data := 0;
1993: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1994: l_number_of_warnings := 0;

Line 1993: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1989:
1990: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1991: x_msg_count := 0;
1992: x_msg_data := 0;
1993: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1994: l_number_of_warnings := 0;
1995: l_number_of_errors := 0;
1996:
1997:

Line 2003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1999: FETCH get_rank_details_c INTO x_rankdetails;
2000:
2001: IF (get_rank_details_c%NOTFOUND) THEN
2002: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2004: wsh_util_core.add_message(x_return_status);
2005: ELSE
2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2007: END IF;

Line 2004: wsh_util_core.add_message(x_return_status);

2000:
2001: IF (get_rank_details_c%NOTFOUND) THEN
2002: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2004: wsh_util_core.add_message(x_return_status);
2005: ELSE
2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2007: END IF;
2008:

Line 2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2002: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2003: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2004: wsh_util_core.add_message(x_return_status);
2005: ELSE
2006: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2007: END IF;
2008:
2009: CLOSE get_rank_details_c;
2010:

Line 2044: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_DETAILS');

2040: );
2041:
2042: WHEN OTHERS THEN
2043: ROLLBACK TO GET_RANK_DETAILS_PUB;
2044: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_DETAILS');
2045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2046: FND_MSG_PUB.Count_And_Get
2047: (
2048: p_count => x_msg_count,

Line 2045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2041:
2042: WHEN OTHERS THEN
2043: ROLLBACK TO GET_RANK_DETAILS_PUB;
2044: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_DETAILS');
2045: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2046: FND_MSG_PUB.Count_And_Get
2047: (
2048: p_count => x_msg_count,
2049: p_data => x_msg_data,

Line 2143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2139: WSH_DEBUG_SV.push(l_module_name);
2140: END IF;
2141:
2142:
2143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2144: x_msg_count := 0;
2145: x_msg_data := 0;
2146: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2147: l_number_of_warnings := 0;

Line 2146: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2142:
2143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2144: x_msg_count := 0;
2145: x_msg_data := 0;
2146: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2147: l_number_of_warnings := 0;
2148: l_number_of_errors := 0;
2149:
2150:

Line 2259: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST');

2255: );
2256:
2257: WHEN OTHERS THEN
2258: ROLLBACK TO GET_RANK_LIST_PUB;
2259: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST');
2260: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Count_And_Get
2262: (
2263: p_count => x_msg_count,

Line 2260: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2256:
2257: WHEN OTHERS THEN
2258: ROLLBACK TO GET_RANK_LIST_PUB;
2259: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.GET_RANK_LIST');
2260: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2261: FND_MSG_PUB.Count_And_Get
2262: (
2263: p_count => x_msg_count,
2264: p_data => x_msg_data,

Line 2371: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2367: THEN
2368: FND_MSG_PUB.initialize;
2369: END IF;
2370:
2371: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2372: x_msg_count := 0;
2373: x_msg_data := 0;
2374: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2375: l_number_of_warnings := 0;

Line 2374: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2370:
2371: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2372: x_msg_count := 0;
2373: x_msg_data := 0;
2374: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2375: l_number_of_warnings := 0;
2376: l_number_of_errors := 0;
2377: l_msg_data := 0;
2378:

Line 2402: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2398:
2399: EXCEPTION
2400: WHEN NO_DATA_FOUND THEN
2401: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2402: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2403: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2404: RAISE FND_API.G_EXC_ERROR;
2405: END;
2406:

Line 2403: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

2399: EXCEPTION
2400: WHEN NO_DATA_FOUND THEN
2401: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2402: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2403: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2404: RAISE FND_API.G_EXC_ERROR;
2405: END;
2406:
2407: IF l_debug_on

Line 2434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2430: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_LIST_EXAUSTED');
2431: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
2432:
2433: l_list_exhausted := 'T';
2434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2435: wsh_util_core.add_message(x_return_status);
2436: END IF;
2437:
2438: CLOSE get_next_rank;

Line 2435: wsh_util_core.add_message(x_return_status);

2431: FND_MESSAGE.SET_TOKEN('TRIP_NAME',l_trip_name);
2432:
2433: l_list_exhausted := 'T';
2434: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2435: wsh_util_core.add_message(x_return_status);
2436: END IF;
2437:
2438: CLOSE get_next_rank;
2439:

Line 2531: wsh_util_core.api_post_call(

2527: l_return_status,
2528: WSH_DEBUG_SV.C_PROC_LEVEL);
2529: END IF;
2530:
2531: wsh_util_core.api_post_call(
2532: p_return_status =>l_return_status,
2533: x_num_warnings =>l_number_of_warnings,
2534: x_num_errors =>l_number_of_errors,
2535: p_msg_data =>l_msg_data);

Line 2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2535: p_msg_data =>l_msg_data);
2536:
2537: IF l_number_of_errors > 0
2538: THEN
2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2540: RAISE FND_API.G_EXC_ERROR;
2541: ELSIF l_number_of_warnings > 0
2542: THEN
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2539: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2540: RAISE FND_API.G_EXC_ERROR;
2541: ELSIF l_number_of_warnings > 0
2542: THEN
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2544: ELSE
2545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2546: END IF;
2547:

Line 2545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2541: ELSIF l_number_of_warnings > 0
2542: THEN
2543: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2544: ELSE
2545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2546: END IF;
2547:
2548:
2549: IF (p_price_request_id IS NOT NULL)

Line 2571: wsh_util_core.api_post_call(

2567: WSH_DEBUG_SV.C_PROC_LEVEL);
2568: END IF;
2569:
2570:
2571: wsh_util_core.api_post_call(
2572: p_return_status =>l_return_status,
2573: x_num_warnings =>l_number_of_warnings,
2574: x_num_errors =>l_number_of_errors);
2575:

Line 2610: wsh_util_core.api_post_call(

2606: END IF;
2607:
2608: -- Continue even if rating failed
2609: /**
2610: wsh_util_core.api_post_call(
2611: p_return_status =>l_return_status,
2612: x_num_warnings =>l_number_of_warnings,
2613: x_num_errors =>l_number_of_errors,
2614: p_msg_data =>l_msg_data);

Line 2622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2618:
2619:
2620: IF l_number_of_errors > 0
2621: THEN
2622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2623: RAISE FND_API.G_EXC_ERROR;
2624: ELSIF l_number_of_warnings > 0
2625: THEN
2626: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2626: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2623: RAISE FND_API.G_EXC_ERROR;
2624: ELSIF l_number_of_warnings > 0
2625: THEN
2626: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2627: ELSE
2628: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2629: END IF;
2630:

Line 2628: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2624: ELSIF l_number_of_warnings > 0
2625: THEN
2626: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2627: ELSE
2628: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2629: END IF;
2630:
2631: l_list_tbl(1) := l_rank_rec;
2632:

Line 2660: wsh_util_core.api_post_call(

2656: l_return_status,
2657: WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659:
2660: wsh_util_core.api_post_call(
2661: p_return_status =>l_return_status,
2662: x_num_warnings =>l_number_of_warnings,
2663: x_num_errors =>l_number_of_errors,
2664: p_msg_data =>l_msg_data);

Line 2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2665:
2666:
2667: IF l_number_of_errors > 0
2668: THEN
2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSIF l_number_of_warnings > 0
2672: THEN
2673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2669: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2670: RAISE FND_API.G_EXC_ERROR;
2671: ELSIF l_number_of_warnings > 0
2672: THEN
2673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2674: ELSE
2675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2676: END IF;
2677: --}

Line 2675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2671: ELSIF l_number_of_warnings > 0
2672: THEN
2673: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2674: ELSE
2675: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2676: END IF;
2677: --}
2678: END IF;
2679:

Line 2727: wsh_util_core.default_handler('FTE_SS_INTERFACE.REMOVE_SERVICE_APPLY_NEXT');

2723: WSH_DEBUG_SV.pop(l_module_name);
2724: END IF;
2725: WHEN OTHERS THEN
2726: ROLLBACK TO REMOVE_SERVICE_APPLY_NEXT_PUB;
2727: wsh_util_core.default_handler('FTE_SS_INTERFACE.REMOVE_SERVICE_APPLY_NEXT');
2728: x_return_status := FND_API.G_RET_STS_ERROR;
2729: FND_MSG_PUB.Count_And_Get
2730: (
2731: p_count => x_msg_count,

Line 2780: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2776: THEN
2777: FND_MSG_PUB.initialize;
2778: END IF;
2779:
2780: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2781: x_msg_count := 0;
2782: x_msg_data := 0;
2783: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2784: l_number_of_warnings := 0;

Line 2783: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2779:
2780: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2781: x_msg_count := 0;
2782: x_msg_data := 0;
2783: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2784: l_number_of_warnings := 0;
2785: l_number_of_errors := 0;
2786:
2787:

Line 2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2800:
2801: EXCEPTION
2802: WHEN NO_DATA_FOUND THEN
2803: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2806: RAISE FND_API.G_EXC_ERROR;
2807:
2808: END;

Line 2805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);

2801: EXCEPTION
2802: WHEN NO_DATA_FOUND THEN
2803: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_NOT_FOUND');
2804: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2805: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
2806: RAISE FND_API.G_EXC_ERROR;
2807:
2808: END;
2809:

Line 2881: wsh_util_core.default_handler('FTE_SS_INTERFACE.REMOVE_SERVICE_APPLY_NEXT');

2877: WSH_DEBUG_SV.pop(l_module_name);
2878: END IF;
2879: WHEN OTHERS THEN
2880: ROLLBACK TO IS_RANK_LIST_EXHAUSTED_PUB;
2881: wsh_util_core.default_handler('FTE_SS_INTERFACE.REMOVE_SERVICE_APPLY_NEXT');
2882: x_return_status := FND_API.G_RET_STS_ERROR;
2883: FND_MSG_PUB.Count_And_Get
2884: (
2885: p_count => x_msg_count,

Line 2975: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2971: WSH_DEBUG_SV.push(l_module_name);
2972: END IF;
2973:
2974:
2975: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2976: l_number_of_warnings := 0;
2977: l_number_of_errors := 0;
2978:
2979:

Line 3043: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.PRINT_RANK_LIST');

3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3040: ROLLBACK TO PRINT_RANK_LIST_PUB;
3041: WHEN OTHERS THEN
3042: ROLLBACK TO PRINT_RANK_LIST_PUB;
3043: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.PRINT_RANK_LIST');
3044: END PRINT_RANK_LIST;
3045:
3046:
3047: --{

Line 3082: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3078: WSH_DEBUG_SV.push(l_module_name);
3079: END IF;
3080:
3081:
3082: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3083:
3084:
3085: IF l_debug_on
3086: THEN

Line 3120: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

3116: WSH_DEBUG_SV.C_PROC_LEVEL);
3117: END IF;
3118:
3119:
3120: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3121: THEN
3122: l_error_tab.EXTEND;
3123: l_error_tab(l_error_tab.COUNT) := p_trip_id(i);
3124: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3124: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3120: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3121: THEN
3122: l_error_tab.EXTEND;
3123: l_error_tab(l_error_tab.COUNT) := p_trip_id(i);
3124: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3125:
3126: -- Get the trip name
3127: SELECT NAME INTO l_temp_name FROM WSH_TRIPS
3128: WHERE TRIP_ID = p_trip_id(i);

Line 3131: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)

3127: SELECT NAME INTO l_temp_name FROM WSH_TRIPS
3128: WHERE TRIP_ID = p_trip_id(i);
3129:
3130: l_trip_names := l_trip_names || ', ' || l_temp_name;
3131: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
3132: THEN
3133: l_warning_tab.EXTEND;
3134: l_warning_tab(l_warning_tab.COUNT) := p_trip_id(i);
3135: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 3135: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3131: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
3132: THEN
3133: l_warning_tab.EXTEND;
3134: l_warning_tab(l_warning_tab.COUNT) := p_trip_id(i);
3135: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3136: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
3137: THEN
3138: l_success_tab.EXTEND;
3139: l_success_tab(l_success_Tab.COUNT) := p_trip_id(i);

Line 3136: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)

3132: THEN
3133: l_warning_tab.EXTEND;
3134: l_warning_tab(l_warning_tab.COUNT) := p_trip_id(i);
3135: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3136: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
3137: THEN
3138: l_success_tab.EXTEND;
3139: l_success_tab(l_success_Tab.COUNT) := p_trip_id(i);
3140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3136: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
3137: THEN
3138: l_success_tab.EXTEND;
3139: l_success_tab(l_success_Tab.COUNT) := p_trip_id(i);
3140: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3141: ELSE
3142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3143: END IF;
3144:

Line 3174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3170: IF (l_success_tab.count = p_trip_id.count)
3171: THEN
3172: --FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_SUCCESS');
3173: --FND_MSG_PUB.ADD;
3174: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3175: ELSIF (l_error_tab.count = p_trip_id.count)
3176: THEN
3177: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_FAIL');
3178: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);

Line 3185: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3181: ELSE
3182: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_RANK_DEL_WARN');
3183: FND_MESSAGE.SET_TOKEN('TRIP_NAMES', l_trip_names);
3184: FND_MSG_PUB.ADD;
3185: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3186: END IF;
3187:
3188:
3189: FND_MSG_PUB.Count_And_Get

Line 3201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3197: EXCEPTION
3198:
3199: WHEN FND_API.G_EXC_ERROR THEN
3200: ROLLBACK TO DELETE_RANK_LIST_UIWRAPPER_PUB;
3201: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3202: FND_MSG_PUB.Count_And_Get
3203: (
3204: p_count => x_msg_count,
3205: p_data => x_msg_data,

Line 3211: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3207: );
3208:
3209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3210: ROLLBACK TO DELETE_RANK_LIST_UIWRAPPER_PUB;
3211: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3212: FND_MSG_PUB.Count_And_Get
3213: (
3214: p_count => x_msg_count,
3215: p_data => x_msg_data,

Line 3220: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST_UIWRAPPER');

3216: p_encoded => FND_API.G_FALSE
3217: );
3218: WHEN OTHERS THEN
3219: ROLLBACK TO DELETE_RANK_LIST_UIWRAPPER_PUB;
3220: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST_UIWRAPPER');
3221: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3222: FND_MSG_PUB.Count_And_Get
3223: (
3224: p_count => x_msg_count,

Line 3221: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3217: );
3218: WHEN OTHERS THEN
3219: ROLLBACK TO DELETE_RANK_LIST_UIWRAPPER_PUB;
3220: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST_UIWRAPPER');
3221: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3222: FND_MSG_PUB.Count_And_Get
3223: (
3224: p_count => x_msg_count,
3225: p_data => x_msg_data,

Line 3278: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3274: WSH_DEBUG_SV.push(l_module_name);
3275: END IF;
3276:
3277:
3278: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3279: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3280: x_msg_count := 0;
3281:
3282: IF l_debug_on

Line 3279: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3275: END IF;
3276:
3277:
3278: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3279: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3280: x_msg_count := 0;
3281:
3282: IF l_debug_on
3283: THEN

Line 3496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3492:
3493: FND_MESSAGE.SET_NAME('FTE','FTE_RANK_CRE_FAILED_TRIPS');
3494: FND_MESSAGE.SET_TOKEN('trip_names', l_trip_names);
3495: FND_MSG_PUB.ADD;
3496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3497: END IF;
3498:
3499: EXCEPTION
3500:

Line 3503: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3499: EXCEPTION
3500:
3501: WHEN FND_API.G_EXC_ERROR THEN
3502: ROLLBACK TO CREATE_RANK_LIST_BULK_PUB;
3503: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3504: FND_MSG_PUB.Count_And_Get
3505: (
3506: p_count => x_msg_count,
3507: p_data => x_msg_data,

Line 3513: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3509: );
3510:
3511: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3512: ROLLBACK TO CREATE_RANK_LIST_BULK_PUB;
3513: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3514: FND_MSG_PUB.Count_And_Get
3515: (
3516: p_count => x_msg_count,
3517: p_data => x_msg_data,

Line 3522: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK');

3518: p_encoded => FND_API.G_FALSE
3519: );
3520: WHEN OTHERS THEN
3521: ROLLBACK TO CREATE_RANK_LIST_BULK_PUB;
3522: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK');
3523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3524: FND_MSG_PUB.Count_And_Get
3525: (
3526: p_count => x_msg_count,

Line 3523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3519: );
3520: WHEN OTHERS THEN
3521: ROLLBACK TO CREATE_RANK_LIST_BULK_PUB;
3522: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST_BULK');
3523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3524: FND_MSG_PUB.Count_And_Get
3525: (
3526: p_count => x_msg_count,
3527: p_data => x_msg_data,