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.FTE_MLS_WRAPPER dependencies on WSH_UTIL_CORE

Line 144: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

140: END IF;
141: --
142: --
143: -- Initialize API return status to success
144: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
145: x_msg_count := 0;
146: x_msg_data := 0;
147:
148: IF l_debug_on THEN

Line 277: IF ( ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

273: END IF;
274:
275:
276: --# Bug 2911100 : HBHAGAVA
277: IF ( ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
278: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
279: AND l_stop_out_tab.count > 0) THEN
280: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;
281: END IF;

Line 278: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)

274:
275:
276: --# Bug 2911100 : HBHAGAVA
277: IF ( ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
278: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
279: AND l_stop_out_tab.count > 0) THEN
280: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;
281: END IF;
282: ELSE

Line 358: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

354: END IF;
355:
356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
357: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
358: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
359: FND_MSG_PUB.Count_And_Get
360: (
361: p_count => x_msg_count,
362: p_data => x_msg_data,

Line 370: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

366: WSH_DEBUG_SV.pop(l_module_name);
367: END IF;
368: WHEN OTHERS THEN
369: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
370: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
371: FND_MSG_PUB.Count_And_Get
372: (
373: p_count => x_msg_count,
374: p_data => x_msg_data,

Line 407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;

403:
404: x_stop_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
405:
406: p_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
407: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
408: p_commit VARCHAR2(1);
409:
410: --
411: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 436: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

432: END IF;
433: --
434: --
435: -- Initialize API return status to success
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
437: x_msg_count := 0;
438: x_msg_data := 0;
439: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
440: l_number_of_warnings := 0;

Line 439: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

435: -- Initialize API return status to success
436: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
437: x_msg_count := 0;
438: x_msg_data := 0;
439: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
440: l_number_of_warnings := 0;
441: l_number_of_errors := 0;
442:
443: IF l_debug_on THEN

Line 485: wsh_util_core.api_post_call(

481:
482: END IF;
483:
484:
485: wsh_util_core.api_post_call(
486: p_return_status =>l_return_status,
487: x_num_warnings =>l_number_of_warnings,
488: x_num_errors =>l_number_of_errors,
489: p_msg_data =>l_msg_data);

Line 493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

489: p_msg_data =>l_msg_data);
490:
491: IF l_number_of_errors > 0
492: THEN
493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
494: ELSIF l_number_of_warnings > 0
495: THEN
496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
497: ELSE

Line 496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

492: THEN
493: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
494: ELSIF l_number_of_warnings > 0
495: THEN
496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
497: ELSE
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
499: END IF;
500:

Line 498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

494: ELSIF l_number_of_warnings > 0
495: THEN
496: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
497: ELSE
498: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
499: END IF;
500:
501: FND_MSG_PUB.Count_And_Get
502: (

Line 529: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

525: END IF;
526:
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: ROLLBACK TO STOP_ACTION_PUB;
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
530: FND_MSG_PUB.Count_And_Get
531: (
532: p_count => x_msg_count,
533: p_data => x_msg_data,

Line 541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

537: WSH_DEBUG_SV.pop(l_module_name);
538: END IF;
539: WHEN OTHERS THEN
540: ROLLBACK TO STOP_ACTION_PUB;
541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
542: FND_MSG_PUB.Count_And_Get
543: (
544: p_count => x_msg_count,
545: p_data => x_msg_data,

Line 609: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

605: --}
606:
607: p_commit VARCHAR2(1);
608: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
609: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
610: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
611:
612:
613:

Line 642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

638: END IF;
639: --
640: --
641: -- Initialize API return status to success
642: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
643: x_msg_count := 0;
644: x_msg_data := 0;
645:
646: l_number_of_errors := 0;

Line 693: p_delivery_id_tab =>l_delivery_id_tab, -- wsh_util_core.id_tab_type,

689: WSH_INTERFACE_GRP.Delivery_Action
690: ( p_api_version_number =>p_api_version_number, -- NUMBER
691: p_init_msg_list =>FND_API.G_FALSE, -- VARCHAR2
692: p_action_prms =>l_action_prms, -- WSH_DELIVERIES_GRP.action_parameters_rectype,
693: p_delivery_id_tab =>l_delivery_id_tab, -- wsh_util_core.id_tab_type,
694: x_delivery_out_rec =>l_delivery_out_rec, -- WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type,
695: x_return_status =>l_return_status,
696: x_msg_count =>l_msg_count,
697: x_msg_data =>l_msg_data

Line 707: wsh_util_core.api_post_call(

703: ' WSH_INTERFACE_GRP.DeliveryAction Return status ' || x_return_status,
704: WSH_DEBUG_SV.C_PROC_LEVEL);
705: END IF;
706:
707: wsh_util_core.api_post_call(
708: p_return_status =>l_return_status,
709: x_num_warnings =>l_number_of_warnings,
710: x_num_errors =>l_number_of_errors,
711: p_msg_data =>l_msg_data);

Line 715: 'after wsh_util_core: x_return_status ' || x_return_status || ' l_return_status '||l_return_status,

711: p_msg_data =>l_msg_data);
712:
713: IF l_debug_on THEN
714: WSH_DEBUG_SV.logmsg(l_module_name,
715: 'after wsh_util_core: x_return_status ' || x_return_status || ' l_return_status '||l_return_status,
716: WSH_DEBUG_SV.C_PROC_LEVEL);
717: END IF;
718:
719: x_return_status := l_return_status;

Line 736: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND

732: -- x_trip_id := l_delivery_out_rec.trip_id;
733: -- x_trip_name := l_delivery_out_rec.trip_name;
734: --
735:
736: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND
737: l_delivery_out_rec.result_id_tab.count > 0) THEN
738: x_trip_id := l_delivery_out_rec.result_id_tab(1);
739: --x_trip_name := l_delivery_out_rec(l_delivery_out_rec.FIRST).trip_name;
740: END IF;

Line 779: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

775: END IF;
776:
777: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
778: ROLLBACK TO DELIVERY_ACTION_PUB;
779: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
780: FND_MSG_PUB.Count_And_Get
781: (
782: p_count => x_msg_count,
783: p_data => x_msg_data,

Line 792: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_MLS_WRAPPER.Delivery_Action');

788: END IF;
789:
790: WHEN OTHERS THEN
791: ROLLBACK TO DELIVERY_ACTION_PUB;
792: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_MLS_WRAPPER.Delivery_Action');
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794: FND_MSG_PUB.Count_And_Get
795: (
796: p_count => x_msg_count,

Line 793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

789:
790: WHEN OTHERS THEN
791: ROLLBACK TO DELIVERY_ACTION_PUB;
792: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_MLS_WRAPPER.Delivery_Action');
793: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
794: FND_MSG_PUB.Count_And_Get
795: (
796: p_count => x_msg_count,
797: p_data => x_msg_data,

Line 910: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

906:
907: SAVEPOINT CREATE_UPDATE_TRIP_OLD_PUB;
908:
909:
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
911: x_msg_count := 0;
912: x_msg_data := 0;
913: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
914: l_number_of_warnings := 0;

Line 913: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

909:
910: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
911: x_msg_count := 0;
912: x_msg_data := 0;
913: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
914: l_number_of_warnings := 0;
915: l_number_of_errors := 0;
916:
917: Create_Update_Trip(p_api_version_number => p_api_version_number,

Line 998: wsh_util_core.api_post_call(

994:
995:
996: x_trip_id := l_trip_id;
997:
998: wsh_util_core.api_post_call(
999: p_return_status =>l_return_status,
1000: x_num_warnings =>l_number_of_warnings,
1001: x_num_errors =>l_number_of_errors,
1002: p_msg_data =>l_msg_data);

Line 1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1002: p_msg_data =>l_msg_data);
1003:
1004: IF l_number_of_errors > 0
1005: THEN
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1007: ELSIF l_number_of_warnings > 0
1008: THEN
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1010: ELSE

Line 1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1005: THEN
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1007: ELSIF l_number_of_warnings > 0
1008: THEN
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1010: ELSE
1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1012: END IF;
1013:

Line 1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1007: ELSIF l_number_of_warnings > 0
1008: THEN
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1010: ELSE
1011: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1012: END IF;
1013:
1014: FND_MSG_PUB.Count_And_Get
1015: (

Line 1033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1029: p_encoded => FND_API.G_FALSE
1030: );
1031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1032: ROLLBACK TO CREATE_UPDATE_TRIP_OLD_PUB;
1033: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1034: FND_MSG_PUB.Count_And_Get
1035: (
1036: p_count => x_msg_count,
1037: p_data => x_msg_data,

Line 1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1038: p_encoded => FND_API.G_FALSE
1039: );
1040: WHEN OTHERS THEN
1041: ROLLBACK TO CREATE_UPDATE_TRIP_OLD_PUB;
1042: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1043: FND_MSG_PUB.Count_And_Get
1044: (
1045: p_count => x_msg_count,
1046: p_data => x_msg_data,

Line 1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1182: END IF;
1183: --
1184: --
1185: -- Initialize API return status to success
1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1187: x_msg_count := 0;
1188: x_msg_data := 0;
1189: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1190: l_number_of_warnings := 0;

Line 1189: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1185: -- Initialize API return status to success
1186: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1187: x_msg_count := 0;
1188: x_msg_data := 0;
1189: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1190: l_number_of_warnings := 0;
1191: l_number_of_errors := 0;
1192:
1193: IF l_debug_on THEN

Line 1390: wsh_util_core.api_post_call(

1386: WSH_INTERFACE_GRP.Create_Update_Trip ' ||
1387: l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1388: END IF;
1389:
1390: wsh_util_core.api_post_call(
1391: p_return_status =>l_return_status,
1392: x_num_warnings =>l_number_of_warnings,
1393: x_num_errors =>l_number_of_errors,
1394: p_msg_data =>l_msg_data);

Line 1396: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

1392: x_num_warnings =>l_number_of_warnings,
1393: x_num_errors =>l_number_of_errors,
1394: p_msg_data =>l_msg_data);
1395:
1396: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
1397: and x_out_tab.count > 0) THEN
1398: x_trip_id := x_out_tab(x_out_tab.FIRST).trip_id;
1399: x_trip_name := x_out_tab(x_out_tab.FIRST).trip_name;
1400: END IF;

Line 1466: wsh_util_core.api_post_call(

1462: WSH_DEBUG_SV.logmsg(l_module_name,' l_return_status after
1463: Trpi_action ' || l_return_status,WSH_DEBUG_SV.C_PROC_LEVEL);
1464: END IF;
1465:
1466: wsh_util_core.api_post_call(
1467: p_return_status =>l_return_status,
1468: x_num_warnings =>l_number_of_warnings,
1469: x_num_errors =>l_number_of_errors,
1470: p_msg_data =>l_msg_data);

Line 1488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1484: END IF;
1485:
1486: IF l_number_of_errors > 0
1487: THEN
1488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1489: ELSIF l_number_of_warnings > 0
1490: THEN
1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1492: ELSE

Line 1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1487: THEN
1488: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1489: ELSIF l_number_of_warnings > 0
1490: THEN
1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1492: ELSE
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1494: END IF;
1495:

Line 1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1489: ELSIF l_number_of_warnings > 0
1490: THEN
1491: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1492: ELSE
1493: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1494: END IF;
1495:
1496: FND_MSG_PUB.Count_And_Get
1497: (

Line 1533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1529: END IF;
1530:
1531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1532: ROLLBACK TO CREATE_UPDATE_TRIP_PUB;
1533: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1534: FND_MSG_PUB.Count_And_Get
1535: (
1536: p_count => x_msg_count,
1537: p_data => x_msg_data,

Line 1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1548: WSH_DEBUG_SV.logmsg(l_module_name,'P1DEBUG:13 ',WSH_DEBUG_SV.C_PROC_LEVEL);
1549: END IF;
1550:
1551: ROLLBACK TO CREATE_UPDATE_TRIP_PUB;
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1553: FND_MSG_PUB.Count_And_Get
1554: (
1555: p_count => x_msg_count,
1556: p_data => x_msg_data,

Line 1584: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;

1580: p_wv_override_flag IN VARCHAR2 DEFAULT 'N') IS
1581:
1582:
1583:
1584: p_entity_id_tab WSH_UTIL_CORE.id_tab_type;
1585: p_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
1586: x_trip_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
1587: p_commit VARCHAR2(1);
1588:

Line 1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1605: END IF;
1606: --
1607: --
1608: -- Initialize API return status to success
1609: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1610: x_msg_count := 0;
1611: x_msg_data := 0;
1612:
1613: IF l_debug_on THEN

Line 1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1654: WSH_DEBUG_SV.pop(l_module_name);
1655: END IF;
1656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1657: ROLLBACK TO TRIP_ACTION_PUB;
1658: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1659: FND_MSG_PUB.Count_And_Get
1660: (
1661: p_count => x_msg_count,
1662: p_data => x_msg_data,

Line 1670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1666: WSH_DEBUG_SV.pop(l_module_name);
1667: END IF;
1668: WHEN OTHERS THEN
1669: ROLLBACK TO TRIP_ACTION_PUB;
1670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1671: FND_MSG_PUB.Count_And_Get
1672: (
1673: p_count => x_msg_count,
1674: p_data => x_msg_data,

Line 2292: WSH_UTIL_CORE.API_POST_CALL(

2288: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2289: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2290: WSH_DEBUG_SV.logmsg(l_module_name,'l_number_of_warnings: ' || l_number_of_warnings);
2291: END IF;
2292: WSH_UTIL_CORE.API_POST_CALL(
2293: p_return_status =>l_return_status,
2294: x_num_warnings =>l_number_of_warnings,
2295: x_num_errors =>l_number_of_errors,
2296: p_msg_data =>l_msg_data,

Line 2320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2316: x_action_out_rec := FTE_ACTION_OUT_REC(l_error_id_tab,l_valid_ids_tab,null,null,null,null,null,null);
2317:
2318: --Setting Return Status appropriately.
2319: IF l_number_of_errors > 0 THEN
2320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2321: ELSIF l_number_of_warnings > 0 THEN
2322: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2323: ELSE
2324: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2322: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2318: --Setting Return Status appropriately.
2319: IF l_number_of_errors > 0 THEN
2320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2321: ELSIF l_number_of_warnings > 0 THEN
2322: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2323: ELSE
2324: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2325: END IF;
2326:

Line 2324: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2321: ELSIF l_number_of_warnings > 0 THEN
2322: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2323: ELSE
2324: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2325: END IF;
2326:
2327:
2328: --If some trips failed and some passed, return warning msg.

Line 2330: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2326:
2327:
2328: --If some trips failed and some passed, return warning msg.
2329: IF ((l_error_id_tab.COUNT > 0) AND (l_error_id_tab.COUNT < p_trip_id_tab.COUNT)) THEN
2330: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2331: END IF;
2332:
2333: FND_MSG_PUB.Count_And_Get (
2334: p_count => x_msg_count,

Line 2367: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2363: l_tenderIds := GET_TRIP_MSG_TOKEN(l_valid_ids_tab);
2364: END IF;
2365:
2366: --Setting new user friendly message for Error and Warning.
2367: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2368: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_FAIL');
2369: FND_MESSAGE.SET_TOKEN('trip_names', l_tenderIds);
2370: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2371: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_WARN');

Line 2370: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2366: --Setting new user friendly message for Error and Warning.
2367: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2368: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_FAIL');
2369: FND_MESSAGE.SET_TOKEN('trip_names', l_tenderIds);
2370: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2371: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_WARN');
2372: FND_MESSAGE.SET_TOKEN('trip_names', l_tenderIds);
2373: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2374: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_PASS');

Line 2373: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2369: FND_MESSAGE.SET_TOKEN('trip_names', l_tenderIds);
2370: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2371: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_WARN');
2372: FND_MESSAGE.SET_TOKEN('trip_names', l_tenderIds);
2373: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2374: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_PASS');
2375: END IF;
2376: FND_MSG_PUB.ADD;
2377:

Line 2410: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2406: WSH_DEBUG_SV.pop(l_module_name);
2407: END IF;
2408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2409: ROLLBACK TO TENDER_TRIPS;
2410: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2411: FND_MSG_PUB.Count_And_Get
2412: (
2413: p_count => x_msg_count,
2414: p_data => x_msg_data,

Line 2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2419: WSH_DEBUG_SV.pop(l_module_name);
2420: END IF;
2421: WHEN OTHERS THEN
2422: ROLLBACK TO TENDER_TRIPS;
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2424: FND_MSG_PUB.Count_And_Get
2425: (
2426: p_count => x_msg_count,
2427: p_data => x_msg_data,

Line 2686: WSH_UTIL_CORE.API_POST_CALL(

2682: x_error_msg => l_msg_data,
2683: x_error_tkn => l_error_tkn --Check with HB
2684: );
2685:
2686: WSH_UTIL_CORE.API_POST_CALL(
2687: p_return_status =>l_return_status,
2688: x_num_warnings =>l_number_of_warnings,
2689: x_num_errors =>l_number_of_errors,
2690: p_msg_data =>l_msg_data,

Line 2702: WSH_UTIL_CORE.API_POST_CALL(

2698: x_return_status => l_return_status,
2699: x_msg_count => l_number_of_errors,
2700: x_msg_data => l_msg_data);
2701:
2702: WSH_UTIL_CORE.API_POST_CALL(
2703: p_return_status =>l_return_status,
2704: x_num_warnings =>l_number_of_warnings,
2705: x_num_errors =>l_number_of_errors,
2706: p_msg_data =>l_msg_data,

Line 2719: WSH_UTIL_CORE.API_POST_CALL(

2715: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_count: ' || l_msg_count);
2716: WSH_DEBUG_SV.logmsg(l_module_name,'l_msg_data: ' || l_msg_data);
2717: END IF;
2718:
2719: WSH_UTIL_CORE.API_POST_CALL(
2720: p_return_status =>l_return_status,
2721: x_num_warnings =>l_number_of_warnings,
2722: x_num_errors =>l_number_of_errors,
2723: p_msg_data =>l_msg_data,

Line 2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2748: l_error_id_tab,l_valid_ids_tab,NULL,NULL,NULL,NULL,NULL,NULL);
2749:
2750: --Setting Return Status appropriately.
2751: IF l_number_of_errors > 0 THEN
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2753: ELSIF l_number_of_warnings > 0 THEN
2754: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2755: ELSE
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2754: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2750: --Setting Return Status appropriately.
2751: IF l_number_of_errors > 0 THEN
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2753: ELSIF l_number_of_warnings > 0 THEN
2754: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2755: ELSE
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2757: END IF;
2758:

Line 2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2753: ELSIF l_number_of_warnings > 0 THEN
2754: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2755: ELSE
2756: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2757: END IF;
2758:
2759:
2760: --If some trips failed and some passed, return warning msg.

Line 2763: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

2759:
2760: --If some trips failed and some passed, return warning msg.
2761: IF ((l_error_id_tab.COUNT > 0) AND (l_error_id_tab.COUNT < p_trip_id_tab.COUNT)) THEN
2762: WSH_DEBUG_SV.logmsg(l_module_name,'Reset the return status to warn');
2763: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2764: END IF;
2765:
2766: IF l_debug_on THEN
2767: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status: ' || x_return_status);

Line 2786: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN

2782: l_tripNames := GET_TRIP_MSG_TOKEN(l_error_name_tab);
2783: END IF;
2784:
2785: --Setting new user friendly message for Error and Warning.
2786: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2787: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_FAIL');
2788: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2789: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_WARN');
2790: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 2788: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

2784:
2785: --Setting new user friendly message for Error and Warning.
2786: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2787: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_FAIL');
2788: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2789: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_WARN');
2790: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2791: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_PASS');
2792: END IF;

Line 2790: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2786: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2787: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_FAIL');
2788: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
2789: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_WARN');
2790: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2791: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_PASS');
2792: END IF;
2793:
2794: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

Line 2794: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2790: ELSIF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2791: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_CANCEL_TENDER_PASS');
2792: END IF;
2793:
2794: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2795: FND_MESSAGE.SET_TOKEN('trip_names', l_tripNames);
2796: END IF;
2797: FND_MSG_PUB.ADD;
2798:

Line 2822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2818: WSH_DEBUG_SV.pop(l_module_name);
2819: END IF;
2820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2821: ROLLBACK TO CANCEL_TENDER_TRIPS;
2822: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2823: FND_MSG_PUB.COUNT_AND_GET
2824: (
2825: p_count => x_msg_count,
2826: p_data => x_msg_data,

Line 2835: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2831: WSH_DEBUG_SV.pop(l_module_name);
2832: END IF;
2833: WHEN OTHERS THEN
2834: ROLLBACK TO CANCEL_TENDER_TRIPS;
2835: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2836: FND_MSG_PUB.COUNT_AND_GET
2837: (
2838: p_count => x_msg_count,
2839: p_data => x_msg_data,

Line 2882: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;

2878: ) IS
2879:
2880: l_trip_id NUMBER;
2881:
2882: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
2883: l_wsh_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
2884: l_wsh_out_rec WSH_TRIPS_GRP.tripActionOutRecType;
2885:
2886: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

Line 2907: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2903: END IF;
2904: --
2905: --
2906: -- Initialize API return status to success
2907: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2908: x_msg_count := 0;
2909: x_msg_data := 0;
2910:
2911: IF l_debug_on THEN

Line 3067: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3063: WSH_DEBUG_SV.pop(l_module_name);
3064: END IF;
3065: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3066: ROLLBACK TO TRIP_ACTION_PUB;
3067: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3068: FND_MSG_PUB.Count_And_Get
3069: (
3070: p_count => x_msg_count,
3071: p_data => x_msg_data,

Line 3079: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3075: WSH_DEBUG_SV.pop(l_module_name);
3076: END IF;
3077: WHEN OTHERS THEN
3078: ROLLBACK TO TRIP_ACTION_PUB;
3079: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3080: FND_MSG_PUB.Count_And_Get
3081: (
3082: p_count => x_msg_count,
3083: p_data => x_msg_data,

Line 3123: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;

3119:
3120:
3121: l_wsh_out_rec WSH_TRIP_STOPS_GRP.stopActionOutRecType;
3122: l_wsh_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
3123: l_wsh_id_tab WSH_UTIL_CORE.id_tab_type;
3124: l_commit VARCHAR2(1);
3125:
3126:
3127: l_return_status VARCHAR2(10);

Line 3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3150: END IF;
3151: --
3152: --
3153: -- Initialize API return status to success
3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3155: x_msg_count := 0;
3156: x_msg_data := 0;
3157:
3158: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3158: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3155: x_msg_count := 0;
3156: x_msg_data := 0;
3157:
3158: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3159: l_number_of_warnings := 0;
3160: l_number_of_errors := 0;
3161:
3162:

Line 3239: wsh_util_core.api_post_call(

3235: WSH_DEBUG_SV.logmsg(l_module_name,' l_number_of_errors ' || l_number_of_errors);
3236: END IF;
3237:
3238:
3239: wsh_util_core.api_post_call(
3240: p_return_status =>l_return_status,
3241: x_num_warnings =>l_number_of_warnings,
3242: x_num_errors =>l_number_of_errors,
3243: p_msg_data =>l_msg_data,

Line 3249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3245:
3246:
3247: IF l_number_of_errors > 0
3248: THEN
3249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3250: ELSIF l_number_of_warnings > 0
3251: THEN
3252: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3253: ELSE

Line 3252: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3248: THEN
3249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3250: ELSIF l_number_of_warnings > 0
3251: THEN
3252: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3253: ELSE
3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3255: END IF;
3256:

Line 3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3250: ELSIF l_number_of_warnings > 0
3251: THEN
3252: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3253: ELSE
3254: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3255: END IF;
3256:
3257: IF l_debug_on THEN
3258: WSH_DEBUG_SV.logmsg(l_module_name,' After count and get');

Line 3296: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3292: END IF;
3293:
3294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3295: ROLLBACK TO STOP_ACTION_PUB;
3296: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3297: FND_MSG_PUB.Count_And_Get
3298: (
3299: p_count => x_msg_count,
3300: p_data => x_msg_data,

Line 3308: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3304: WSH_DEBUG_SV.pop(l_module_name);
3305: END IF;
3306: WHEN OTHERS THEN
3307: ROLLBACK TO STOP_ACTION_PUB;
3308: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3309: FND_MSG_PUB.Count_And_Get
3310: (
3311: p_count => x_msg_count,
3312: p_data => x_msg_data,

Line 3368: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3364: END IF;
3365: --
3366: --
3367: -- Initialize API return status to success
3368: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3369: x_msg_count := 0;
3370: x_msg_data := 0;
3371:
3372: IF l_debug_on THEN

Line 3418: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3414: END IF;
3415:
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: ROLLBACK TO INIT_STOPS_PLS_TABLE_PUB;
3418: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3419: FND_MSG_PUB.Count_And_Get
3420: (
3421: p_count => x_msg_count,
3422: p_data => x_msg_data,

Line 3430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3426: WSH_DEBUG_SV.pop(l_module_name);
3427: END IF;
3428: WHEN OTHERS THEN
3429: ROLLBACK TO INIT_STOPS_PLS_TABLE_PUB;
3430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3431: FND_MSG_PUB.Count_And_Get
3432: (
3433: p_count => x_msg_count,
3434: p_data => x_msg_data,

Line 3504: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3500: END IF;
3501: --
3502: --
3503: -- Initialize API return status to success
3504: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3505: x_msg_count := 0;
3506: x_msg_data := 0;
3507: l_number_of_warnings := 0;
3508: l_number_of_errors := 0;

Line 3584: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3580: l_action_code := 'UPDATE';
3581: END IF;
3582:
3583:
3584: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3585: l_msg_count := 0;
3586: l_msg_data := 0;
3587:
3588: l_in_rec.caller:='FTEMLWRB';

Line 3606: IF ( ( l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

3602: );
3603:
3604:
3605: /**
3606: IF ( ( l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
3607: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
3608: AND l_stop_out_tab.count > 0)
3609: THEN
3610: x_stop_out_tab.EXTEND;

Line 3607: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)

3603:
3604:
3605: /**
3606: IF ( ( l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
3607: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
3608: AND l_stop_out_tab.count > 0)
3609: THEN
3610: x_stop_out_tab.EXTEND;
3611: x_stop_out_tab(l_idx) := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;

Line 3619: wsh_util_core.api_post_call(

3615: x_stop_seq_tab(l_idx) := l_stop_info.STOP_SEQUENCE_NUMBER;
3616: END IF;
3617: */
3618:
3619: wsh_util_core.api_post_call(
3620: p_return_status =>l_return_status,
3621: x_num_warnings =>l_number_of_warnings,
3622: x_num_errors =>l_number_of_errors,
3623: p_msg_data =>l_msg_data);

Line 3635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3631: END IF;
3632:
3633: IF l_number_of_errors > 0
3634: THEN
3635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3636: ELSIF l_number_of_warnings > 0
3637: THEN
3638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3639: ELSE

Line 3638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3634: THEN
3635: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3636: ELSIF l_number_of_warnings > 0
3637: THEN
3638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3639: ELSE
3640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3641: END IF;
3642:

Line 3640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3636: ELSIF l_number_of_warnings > 0
3637: THEN
3638: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3639: ELSE
3640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3641: END IF;
3642:
3643:
3644: FND_MSG_PUB.Count_And_Get

Line 3680: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3676: END IF;
3677:
3678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3679: ROLLBACK TO PROCESS_STOPS_PUB;
3680: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3681: FND_MSG_PUB.Count_And_Get
3682: (
3683: p_count => x_msg_count,
3684: p_data => x_msg_data,

Line 3692: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3688: WSH_DEBUG_SV.pop(l_module_name);
3689: END IF;
3690: WHEN OTHERS THEN
3691: ROLLBACK TO PROCESS_STOPS_PUB;
3692: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3693: x_msg_data := substr(sqlerrm,1,200);
3694: IF l_debug_on THEN
3695: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3696: WSH_DEBUG_SV.pop(l_module_name);

Line 3763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3759: END IF;
3760: --
3761: --
3762: -- Initialize API return status to success
3763: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3764: x_msg_count := 0;
3765: x_msg_data := 0;
3766: l_number_of_warnings := 0;
3767: l_number_of_errors := 0;

Line 3793: wsh_util_core.api_post_call(

3789: x_return_status=>l_return_status,
3790: x_msg_count=>l_msg_count,
3791: x_msg_data=>l_msg_data
3792: );
3793: wsh_util_core.api_post_call(
3794: p_return_status =>l_return_status,
3795: x_num_warnings =>l_number_of_warnings,
3796: x_num_errors =>l_number_of_errors,
3797: p_msg_data =>l_msg_data);

Line 3802: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3798:
3799:
3800: IF l_number_of_errors > 0
3801: THEN
3802: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3803: ELSIF l_number_of_warnings > 0
3804: THEN
3805: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3806: ELSE

Line 3805: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3801: THEN
3802: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3803: ELSIF l_number_of_warnings > 0
3804: THEN
3805: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3806: ELSE
3807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3808: END IF;
3809:

Line 3807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3803: ELSIF l_number_of_warnings > 0
3804: THEN
3805: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3806: ELSE
3807: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3808: END IF;
3809:
3810: FND_MSG_PUB.Count_And_Get
3811: (

Line 3843: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3839: END IF;
3840:
3841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3842: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
3843: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3844: FND_MSG_PUB.Count_And_Get
3845: (
3846: p_count => x_msg_count,
3847: p_data => x_msg_data,

Line 3855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3851: WSH_DEBUG_SV.pop(l_module_name);
3852: END IF;
3853: WHEN OTHERS THEN
3854: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
3855: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3856: FND_MSG_PUB.Count_And_Get
3857: (
3858: p_count => x_msg_count,
3859: p_data => x_msg_data,

Line 3884: l_trip_id_list WSH_UTIL_CORE.id_tab_type;

3880: --
3881: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'REPRICE_TRIP';
3882:
3883: l_action_params FTE_TRIP_RATING_GRP.action_param_rec;
3884: l_trip_id_list WSH_UTIL_CORE.id_tab_type;
3885:
3886: l_number_of_warnings NUMBER;
3887: l_number_of_errors NUMBER;
3888: l_return_status VARCHAR2(32767);

Line 3906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3902: END IF;
3903: --
3904: --
3905: -- Initialize API return status to success
3906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3907: x_msg_count := 0;
3908: x_msg_data := 0;
3909: l_number_of_warnings := 0;
3910: l_number_of_errors := 0;

Line 3933: wsh_util_core.api_post_call(

3929: x_return_status => l_return_status,
3930: x_msg_count => l_msg_count,
3931: x_msg_data => l_msg_data);
3932:
3933: wsh_util_core.api_post_call(
3934: p_return_status =>l_return_status,
3935: x_num_warnings =>l_number_of_warnings,
3936: x_num_errors =>l_number_of_errors,
3937: p_msg_data =>l_msg_data);

Line 3942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

3938:
3939:
3940: IF l_number_of_errors > 0
3941: THEN
3942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3943: ELSIF l_number_of_warnings > 0
3944: THEN
3945: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3946: ELSE

Line 3945: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

3941: THEN
3942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3943: ELSIF l_number_of_warnings > 0
3944: THEN
3945: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3946: ELSE
3947: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3948: END IF;
3949:

Line 3947: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

3943: ELSIF l_number_of_warnings > 0
3944: THEN
3945: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3946: ELSE
3947: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3948: END IF;
3949:
3950: FND_MSG_PUB.Count_And_Get
3951: (

Line 3983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3979: END IF;
3980:
3981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3982: ROLLBACK TO REPRICE_TRIP_PUB;
3983: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3984: FND_MSG_PUB.Count_And_Get
3985: (
3986: p_count => x_msg_count,
3987: p_data => x_msg_data,

Line 3995: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

3991: WSH_DEBUG_SV.pop(l_module_name);
3992: END IF;
3993: WHEN OTHERS THEN
3994: ROLLBACK TO REPRICE_TRIP_PUB;
3995: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3996: FND_MSG_PUB.Count_And_Get
3997: (
3998: p_count => x_msg_count,
3999: p_data => x_msg_data,

Line 4026: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;

4022: x_msg_data OUT NOCOPY VARCHAR2,
4023: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
4024: ) IS
4025:
4026: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
4027: l_detail_out_rec wsh_glbl_var_strct_grp.dd_action_out_rec_type;
4028: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
4029: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
4030:

Line 4029: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

4025:
4026: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
4027: l_detail_out_rec wsh_glbl_var_strct_grp.dd_action_out_rec_type;
4028: l_action_prms wsh_glbl_var_strct_grp.dd_action_parameters_rec_type;
4029: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
4030:
4031: -- Set action_out_rec
4032: l_result_id_tab FTE_ID_TAB_TYPE;
4033: l_valid_id_tab FTE_ID_TAB_TYPE;

Line 4060: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4056: END IF;
4057: --
4058: --
4059: -- Initialize API return status to success
4060: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4061: x_msg_count := 0;
4062: x_msg_data := 0;
4063:
4064: IF l_debug_on THEN

Line 4110: p_detail_id_tab =>l_detail_id_tab, -- wsh_util_core.id_tab_type

4106: p_commit =>FND_API.G_FALSE,
4107: x_return_status =>x_return_status,
4108: x_msg_count =>x_msg_count,
4109: x_msg_data =>x_msg_data,
4110: p_detail_id_tab =>l_detail_id_tab, -- wsh_util_core.id_tab_type
4111: p_action_prms =>l_action_prms, -- wsh_glbl_var_strct_grp.dd_action_parameters_rec_type
4112: x_action_out_rec =>l_detail_out_rec -- wsh_glbl_var_strct_grp.dd_action_out_rec_type
4113: );
4114:

Line 4190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4186: WSH_DEBUG_SV.pop(l_module_name);
4187: END IF;
4188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4189: ROLLBACK TO DETAIL_ACTION_PUB;
4190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4191: FND_MSG_PUB.Count_And_Get
4192: (
4193: p_count => x_msg_count,
4194: p_data => x_msg_data,

Line 4202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4198: WSH_DEBUG_SV.pop(l_module_name);
4199: END IF;
4200: WHEN OTHERS THEN
4201: ROLLBACK TO DETAIL_ACTION_PUB;
4202: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4203: FND_MSG_PUB.Count_And_Get
4204: (
4205: p_count => x_msg_count,
4206: p_data => x_msg_data,

Line 4261: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4257: END IF;
4258: --
4259: --
4260: -- Initialize API return status to success
4261: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4262: x_msg_count := 0;
4263: x_msg_data := 0;
4264:
4265: IF l_debug_on THEN

Line 4484: x_OUT_rec => l_detail_out_rec -- WSH_UTIL_CORE.Id_Tab_Type

4480: x_msg_count => x_msg_count,
4481: x_msg_data => x_msg_data,
4482: p_detail_info_tab => l_detail_attr_tab_type,
4483: p_IN_rec => l_detail_in_rec,
4484: x_OUT_rec => l_detail_out_rec -- WSH_UTIL_CORE.Id_Tab_Type
4485: );
4486:
4487: -- Handle detailsOutRec
4488:

Line 4523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4519: WSH_DEBUG_SV.pop(l_module_name);
4520: END IF;
4521: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4522: ROLLBACK TO DDL_CREATE_UPDATE_PUB;
4523: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4524: FND_MSG_PUB.Count_And_Get
4525: (
4526: p_count => x_msg_count,
4527: p_data => x_msg_data,

Line 4535: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4531: WSH_DEBUG_SV.pop(l_module_name);
4532: END IF;
4533: WHEN OTHERS THEN
4534: ROLLBACK TO DDL_CREATE_UPDATE_PUB;
4535: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4536: FND_MSG_PUB.Count_And_Get
4537: (
4538: p_count => x_msg_count,
4539: p_data => x_msg_data,

Line 4569: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

4565: x_msg_data OUT NOCOPY VARCHAR2,
4566: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
4567: ) IS
4568:
4569: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
4570: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
4571: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4572:
4573: -- Set delivery action_out_rec

Line 4614: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4610: END IF;
4611: --
4612: --
4613: -- Initialize API return status to success
4614: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4615: x_msg_count := 0;
4616: x_msg_data := null;
4617:
4618:

Line 4677: p_delivery_id_tab =>l_delivery_id_tab, -- wsh_util_core.id_tab_type

4673: p_api_version_number =>p_api_version_number,
4674: p_init_msg_list =>FND_API.G_TRUE,
4675: p_commit =>FND_API.G_FALSE,
4676: p_action_prms =>l_action_prms, -- WSH_DELIVERIES_GRP.action_parameters_rectype
4677: p_delivery_id_tab =>l_delivery_id_tab, -- wsh_util_core.id_tab_type
4678: x_delivery_out_rec =>l_delivery_out_rec, -- WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type
4679: x_return_status =>l_return_status,
4680: x_msg_count =>l_msg_count,
4681: x_msg_data =>l_msg_data

Line 4692: wsh_util_core.api_post_call(

4688: WSH_DEBUG_SV.logmsg(l_module_name,' l_msg_count ' || l_msg_count );
4689: END IF;
4690:
4691:
4692: wsh_util_core.api_post_call(
4693: p_return_status =>l_return_status,
4694: x_num_warnings =>l_number_of_warnings,
4695: x_num_errors =>l_number_of_errors,
4696: p_msg_data =>l_msg_data);

Line 4742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4738: END IF;
4739:
4740: IF l_number_of_errors > 0
4741: THEN
4742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4743: ELSIF l_number_of_warnings > 0
4744: THEN
4745: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4746: ELSE

Line 4745: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4741: THEN
4742: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4743: ELSIF l_number_of_warnings > 0
4744: THEN
4745: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4746: ELSE
4747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4748: END IF;
4749:

Line 4747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4743: ELSIF l_number_of_warnings > 0
4744: THEN
4745: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4746: ELSE
4747: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4748: END IF;
4749:
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);

Line 4788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4784: WSH_DEBUG_SV.pop(l_module_name);
4785: END IF;
4786: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4787: ROLLBACK TO DELIVERY_ACTION_PUB;
4788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4789: FND_MSG_PUB.Count_And_Get
4790: (
4791: p_count => x_msg_count,
4792: p_data => x_msg_data,

Line 4800: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4796: WSH_DEBUG_SV.pop(l_module_name);
4797: END IF;
4798: WHEN OTHERS THEN
4799: ROLLBACK TO DELIVERY_ACTION_PUB;
4800: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4801: FND_MSG_PUB.Count_And_Get
4802: (
4803: p_count => x_msg_count,
4804: p_data => x_msg_data,

Line 4840: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;

4836: x_msg_data OUT NOCOPY VARCHAR2,
4837: x_action_out_rec OUT NOCOPY FTE_ACTION_OUT_REC
4838: ) IS
4839:
4840: l_delivery_id_tab WSH_UTIL_CORE.id_tab_type;
4841: l_delivery_out_rec WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type;
4842: l_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
4843:
4844: -- Set delivery action_out_rec

Line 4876: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4872: END IF;
4873: --
4874: --
4875: -- Initialize API return status to success
4876: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4877: x_msg_count := 0;
4878: --x_msg_data := 0;
4879: l_number_of_warnings := 0;
4880: l_number_of_errors := 0;

Line 4901: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4897: -- set id tab
4898: l_delivery_id_tab(1) := p_mls_delivery_id_tab(i);
4899:
4900: -- Initialize API return status to success
4901: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4902: l_msg_count := 0;
4903: l_msg_data := 0;
4904:
4905: WSH_INTERFACE_GRP.Delivery_Action

Line 4911: p_delivery_id_tab =>l_delivery_id_tab, -- wsh_util_core.id_tab_type

4907: p_api_version_number =>p_api_version_number,
4908: p_init_msg_list =>p_init_msg_list,
4909: p_commit =>FND_API.G_FALSE,
4910: p_action_prms =>l_action_prms, -- WSH_DELIVERIES_GRP.action_parameters_rectype
4911: p_delivery_id_tab =>l_delivery_id_tab, -- wsh_util_core.id_tab_type
4912: x_delivery_out_rec =>l_delivery_out_rec, -- WSH_DELIVERIES_GRP.Delivery_Action_Out_Rec_Type
4913: x_return_status =>l_return_status,
4914: x_msg_count =>l_msg_count,
4915: x_msg_data =>l_msg_data

Line 4919: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)

4915: x_msg_data =>l_msg_data
4916: );
4917:
4918: -- if success, populate valid ids tab
4919: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
4920: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))
4921: THEN
4922: x_valid_id_tab.EXTEND;
4923: x_valid_id_tab(l_number_valid) := l_delivery_id_tab(1);

Line 4920: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))

4916: );
4917:
4918: -- if success, populate valid ids tab
4919: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
4920: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))
4921: THEN
4922: x_valid_id_tab.EXTEND;
4923: x_valid_id_tab(l_number_valid) := l_delivery_id_tab(1);
4924: END IF;

Line 4926: WSH_UTIL_CORE.API_POST_CALL(

4922: x_valid_id_tab.EXTEND;
4923: x_valid_id_tab(l_number_valid) := l_delivery_id_tab(1);
4924: END IF;
4925:
4926: WSH_UTIL_CORE.API_POST_CALL(
4927: p_return_status =>l_return_status,
4928: x_num_warnings =>l_number_of_warnings,
4929: x_num_errors =>l_number_of_errors,
4930: p_msg_data =>l_msg_data,

Line 4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

4957: x_result_id_tab,x_valid_id_tab,null,null,null,null,null,null);
4958:
4959: IF ((x_valid_id_tab.count > 0) AND (x_valid_id_tab.count = p_mls_delivery_id_tab.count))
4960: THEN
4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4962: ELSIF ((x_valid_id_tab.count > 0) AND (x_valid_id_tab.count <> p_mls_delivery_id_tab.count))
4963: THEN
4964: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4965: ELSIF (x_valid_id_tab.count <= 0)

Line 4964: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

4960: THEN
4961: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4962: ELSIF ((x_valid_id_tab.count > 0) AND (x_valid_id_tab.count <> p_mls_delivery_id_tab.count))
4963: THEN
4964: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4965: ELSIF (x_valid_id_tab.count <= 0)
4966: THEN
4967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4968: ELSE

Line 4967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4963: THEN
4964: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4965: ELSIF (x_valid_id_tab.count <= 0)
4966: THEN
4967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4968: ELSE
4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4970: END IF;
4971:

Line 4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

4965: ELSIF (x_valid_id_tab.count <= 0)
4966: THEN
4967: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4968: ELSE
4969: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4970: END IF;
4971:
4972: IF l_debug_on THEN
4973: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status count:' || x_return_status);

Line 4996: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

4992: WSH_DEBUG_SV.pop(l_module_name);
4993: END IF;
4994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4995: ROLLBACK TO DELIVERY_ACTION_ON_TRIP_PUB;
4996: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4997: FND_MSG_PUB.Count_And_Get
4998: (
4999: p_count => x_msg_count,
5000: p_data => x_msg_data,

Line 5008: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5004: WSH_DEBUG_SV.pop(l_module_name);
5005: END IF;
5006: WHEN OTHERS THEN
5007: ROLLBACK TO DELIVERY_ACTION_ON_TRIP_PUB;
5008: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5009: FND_MSG_PUB.Count_And_Get
5010: (
5011: p_count => x_msg_count,
5012: p_data => x_msg_data,

Line 5070: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5066: END IF;
5067: --
5068: --
5069: -- Initialize API return status to success
5070: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5071: x_msg_count := 0;
5072: x_msg_data := 0;
5073:
5074: IF l_debug_on THEN

Line 5308: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5304: WSH_DEBUG_SV.pop(l_module_name);
5305: END IF;
5306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5307: ROLLBACK TO DELIVERY_CREATE_UPDATE_PUB;
5308: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5309: FND_MSG_PUB.Count_And_Get
5310: (
5311: p_count => x_msg_count,
5312: p_data => x_msg_data,

Line 5320: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5316: WSH_DEBUG_SV.pop(l_module_name);
5317: END IF;
5318: WHEN OTHERS THEN
5319: ROLLBACK TO DELIVERY_CREATE_UPDATE_PUB;
5320: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5321: FND_MSG_PUB.Count_And_Get
5322: (
5323: p_count => x_msg_count,
5324: p_data => x_msg_data,

Line 5386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5382: END IF;
5383: --
5384: --
5385: -- Initialize API return status to success
5386: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5387: x_msg_count := 0;
5388: x_msg_data := '';
5389: l_number_of_warnings := 0;
5390: l_number_of_errors := 0;

Line 5480: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)

5476: p_action => p_action
5477: );
5478:
5479: -- if success, populate valid ids tab
5480: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
5481: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))
5482: THEN
5483: x_valid_id_tab.EXTEND;
5484: x_valid_id_tab(i) := l_exception_action_param_rec.exception_id;

Line 5481: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))

5477: );
5478:
5479: -- if success, populate valid ids tab
5480: IF ((l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS)
5481: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))
5482: THEN
5483: x_valid_id_tab.EXTEND;
5484: x_valid_id_tab(i) := l_exception_action_param_rec.exception_id;
5485: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 5485: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

5481: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING))
5482: THEN
5483: x_valid_id_tab.EXTEND;
5484: x_valid_id_tab(i) := l_exception_action_param_rec.exception_id;
5485: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5486: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5487: END IF;
5488:
5489: WSH_UTIL_CORE.API_POST_CALL(

Line 5486: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5482: THEN
5483: x_valid_id_tab.EXTEND;
5484: x_valid_id_tab(i) := l_exception_action_param_rec.exception_id;
5485: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5486: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5487: END IF;
5488:
5489: WSH_UTIL_CORE.API_POST_CALL(
5490: p_return_status =>l_return_status,

Line 5489: WSH_UTIL_CORE.API_POST_CALL(

5485: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
5486: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5487: END IF;
5488:
5489: WSH_UTIL_CORE.API_POST_CALL(
5490: p_return_status =>l_return_status,
5491: x_num_warnings =>l_number_of_warnings,
5492: x_num_errors =>l_number_of_errors,
5493: p_msg_data =>l_msg_data,

Line 5510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5506: END LOOP;
5507:
5508: IF x_valid_id_tab.count<=0 -- there are no valid ids
5509: THEN
5510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5511: ELSIF x_valid_id_tab.count>0 AND x_valid_id_tab.count < p_xc_action_tab.count
5512: THEN
5513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5514: ELSIF x_valid_id_tab.count>0 AND x_valid_id_tab.count = p_xc_action_tab.count

Line 5513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

5509: THEN
5510: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5511: ELSIF x_valid_id_tab.count>0 AND x_valid_id_tab.count < p_xc_action_tab.count
5512: THEN
5513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5514: ELSIF x_valid_id_tab.count>0 AND x_valid_id_tab.count = p_xc_action_tab.count
5515: THEN
5516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5517: ELSE

Line 5516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5512: THEN
5513: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5514: ELSIF x_valid_id_tab.count>0 AND x_valid_id_tab.count = p_xc_action_tab.count
5515: THEN
5516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5517: ELSE
5518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5519: END IF;
5520:

Line 5518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5514: ELSIF x_valid_id_tab.count>0 AND x_valid_id_tab.count = p_xc_action_tab.count
5515: THEN
5516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5517: ELSE
5518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5519: END IF;
5520:
5521: IF l_debug_on THEN
5522: WSH_DEBUG_SV.logmsg(l_module_name,'x_valid_id_tab.count:' || x_valid_id_tab.count);

Line 5560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5556: WSH_DEBUG_SV.pop(l_module_name);
5557: END IF;
5558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5559: ROLLBACK TO EXCEPTION_ACTION_PUB;
5560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5561: FND_MSG_PUB.Count_And_Get
5562: (
5563: p_count => x_msg_count,
5564: p_data => x_msg_data,

Line 5572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5568: WSH_DEBUG_SV.pop(l_module_name);
5569: END IF;
5570: WHEN OTHERS THEN
5571: ROLLBACK TO EXCEPTION_ACTION_PUB;
5572: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5573: FND_MSG_PUB.Count_And_Get
5574: (
5575: p_count => x_msg_count,
5576: p_data => x_msg_data,

Line 5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab

5600: )IS
5601:
5602: l_id_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- DetailIdTab
5603: l_id_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- DetailIdRec
5604: l_id_entity_tab WSH_UTIL_CORE.ID_TAB_TYPE; -- MatchingIdTab
5605: l_action_rec WSH_DELIVERY_AUTOCREATE.ACTION_REC_TYPE; -- ActionOutRec
5606: l_out_rec WSH_DELIVERY_AUTOCREATE.OUT_REC_TYPE; -- OutRecType
5607: l_targ_attr_rec WSH_DELIVERY_AUTOCREATE.GRP_ATTR_REC_TYPE; -- TargetIdRec
5608: l_grp_attr_tab WSH_DELIVERY_AUTOCREATE.GRP_ATTR_TAB_TYPE; -- GroupIdTab

Line 5629: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5625: END IF;
5626: --
5627: --
5628: -- Initialize API return status to success
5629: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5630: x_msg_count := 0;
5631: x_msg_data := 0;
5632:
5633: IF l_debug_on THEN

Line 5667: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS

5663: x_return_status => x_return_status
5664: );
5665:
5666: -- Check output params
5667: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
5668: AND l_grp_attr_tab.count>1)
5669: THEN
5670: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5671: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 5671: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5667: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS
5668: AND l_grp_attr_tab.count>1)
5669: THEN
5670: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5671: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5672: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5673: FND_MSG_PUB.ADD;
5674: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
5675: AND l_grp_attr_tab.count>1)

Line 5674: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING

5670: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5671: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5672: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5673: FND_MSG_PUB.ADD;
5674: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
5675: AND l_grp_attr_tab.count>1)
5676: THEN
5677: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5678: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 5678: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

5674: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING
5675: AND l_grp_attr_tab.count>1)
5676: THEN
5677: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5678: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5679: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5680: FND_MSG_PUB.ADD;
5681: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5682: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

Line 5681: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR

5677: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5678: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5679: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5680: FND_MSG_PUB.ADD;
5681: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5682: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
5683: THEN
5684: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5685: END IF;

Line 5682: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)

5678: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5679: FND_MESSAGE.SET_NAME('FTE','FTE_LINES_NOT_GROUPABLE');
5680: FND_MSG_PUB.ADD;
5681: ELSIF (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
5682: OR x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
5683: THEN
5684: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5685: END IF;
5686:

Line 5714: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5710: WSH_DEBUG_SV.pop(l_module_name);
5711: END IF;
5712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5713: ROLLBACK TO GROUP_DETAIL_SEARCH_DLVY_PUB;
5714: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5715: FND_MSG_PUB.Count_And_Get
5716: (
5717: p_count => x_msg_count,
5718: p_data => x_msg_data,

Line 5726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5722: WSH_DEBUG_SV.pop(l_module_name);
5723: END IF;
5724: WHEN OTHERS THEN
5725: ROLLBACK TO GROUP_DETAIL_SEARCH_DLVY_PUB;
5726: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5727: FND_MSG_PUB.Count_And_Get
5728: (
5729: p_count => x_msg_count,
5730: p_data => x_msg_data,

Line 5748: l_disabled_list wsh_util_core.column_tab_type;

5744: x_msg_count OUT NOCOPY NUMBER,
5745: x_msg_data OUT NOCOPY VARCHAR2
5746: ) IS
5747:
5748: l_disabled_list wsh_util_core.column_tab_type;
5749: i NUMBER;
5750:
5751:
5752: --

Line 5788: ((x_return_status <>WSH_UTIL_CORE.G_RET_STS_ERROR ) OR

5784:
5785:
5786:
5787: IF ((l_disabled_list IS NOT NULL) AND (l_disabled_list.COUNT > 0) AND
5788: ((x_return_status <>WSH_UTIL_CORE.G_RET_STS_ERROR ) OR
5789: (x_return_status <>WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)))
5790: THEN
5791: x_disabled_list:=FTE_NAME_TAB_TYPE('NULL');
5792: x_disabled_list.EXTEND(l_disabled_list.COUNT-1,1);

Line 5789: (x_return_status <>WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)))

5785:
5786:
5787: IF ((l_disabled_list IS NOT NULL) AND (l_disabled_list.COUNT > 0) AND
5788: ((x_return_status <>WSH_UTIL_CORE.G_RET_STS_ERROR ) OR
5789: (x_return_status <>WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)))
5790: THEN
5791: x_disabled_list:=FTE_NAME_TAB_TYPE('NULL');
5792: x_disabled_list.EXTEND(l_disabled_list.COUNT-1,1);
5793: i:=l_disabled_list.FIRST();

Line 5820: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

5816: EXCEPTION
5817:
5818: WHEN OTHERS THEN
5819:
5820: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5821: IF l_debug_on THEN
5822: WSH_DEBUG_SV.pop(l_module_name);
5823: END IF;
5824:

Line 5905: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5901: END IF;
5902: --
5903: --
5904: -- Initialize API return status to success
5905: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5906: x_msg_count := 0;
5907: x_msg_data := 0;
5908: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5909: l_number_of_warnings := 0;

Line 5908: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

5904: -- Initialize API return status to success
5905: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5906: x_msg_count := 0;
5907: x_msg_data := 0;
5908: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5909: l_number_of_warnings := 0;
5910: l_number_of_errors := 0;
5911:
5912: IF l_debug_on

Line 5940: wsh_util_core.api_post_call(

5936: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
5937: END IF;
5938:
5939:
5940: wsh_util_core.api_post_call(
5941: p_return_status =>l_return_status,
5942: x_num_warnings =>l_number_of_warnings,
5943: x_num_errors =>l_number_of_errors,
5944: p_msg_data =>l_msg_data);

Line 6034: wsh_util_core.api_post_call(

6030: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6031: END IF;
6032:
6033:
6034: wsh_util_core.api_post_call(
6035: p_return_status =>l_return_status,
6036: x_num_warnings =>l_number_of_warnings,
6037: x_num_errors =>l_number_of_errors,
6038: p_msg_data =>l_msg_data);

Line 6065: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

6061: THEN
6062: WSH_DEBUG_SV.logmsg(l_module_name,' MBOL is not generated ');
6063: END IF;
6064: FND_MESSAGE.SET_NAME('FTE','FTE_MBOL_NOT_GENERATED');
6065: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6066: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
6067: END IF;
6068:
6069: wsh_util_core.api_post_call(

Line 6066: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);

6062: WSH_DEBUG_SV.logmsg(l_module_name,' MBOL is not generated ');
6063: END IF;
6064: FND_MESSAGE.SET_NAME('FTE','FTE_MBOL_NOT_GENERATED');
6065: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6066: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
6067: END IF;
6068:
6069: wsh_util_core.api_post_call(
6070: p_return_status =>l_return_status,

Line 6069: wsh_util_core.api_post_call(

6065: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6066: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status);
6067: END IF;
6068:
6069: wsh_util_core.api_post_call(
6070: p_return_status =>l_return_status,
6071: x_num_warnings =>l_number_of_warnings,
6072: x_num_errors =>l_number_of_errors,
6073: p_msg_data =>l_msg_data);

Line 6101: wsh_util_core.api_post_call(

6097: || l_return_status, WSH_DEBUG_SV.C_PROC_LEVEL);
6098: END IF;
6099:
6100:
6101: wsh_util_core.api_post_call(
6102: p_return_status =>l_return_status,
6103: x_num_warnings =>l_number_of_warnings,
6104: x_num_errors =>l_number_of_errors,
6105: p_msg_data =>l_msg_data);

Line 6176: wsh_util_core.api_post_call(

6172: x_msg_count => l_msg_count,
6173: x_msg_data => l_msg_data,
6174: p_trip_info => l_trip_info_rec);
6175:
6176: wsh_util_core.api_post_call(
6177: p_return_status =>l_return_status,
6178: x_num_warnings =>l_number_of_warnings,
6179: x_num_errors =>l_number_of_errors,
6180: p_msg_data =>l_msg_data);

Line 6233: wsh_util_core.api_post_call(

6229: l_return_status,
6230: WSH_DEBUG_SV.C_PROC_LEVEL);
6231: END IF;
6232:
6233: wsh_util_core.api_post_call(
6234: p_return_status =>l_return_status,
6235: x_num_warnings =>l_number_of_warnings,
6236: x_num_errors =>l_number_of_errors,
6237: p_msg_data =>l_msg_data);

Line 6290: wsh_util_core.api_post_call(

6286: l_return_status,
6287: WSH_DEBUG_SV.C_PROC_LEVEL);
6288: END IF;
6289:
6290: wsh_util_core.api_post_call(
6291: p_return_status =>l_return_status,
6292: x_num_warnings =>l_number_of_warnings,
6293: x_num_errors =>l_number_of_errors,
6294: p_msg_data =>l_msg_data);

Line 6335: wsh_util_core.api_post_call(

6331: x_msg_count => l_msg_count,
6332: x_msg_data => l_msg_data,
6333: p_trip_info => l_trip_info_rec);
6334:
6335: wsh_util_core.api_post_call(
6336: p_return_status =>l_return_status,
6337: x_num_warnings =>l_number_of_warnings,
6338: x_num_errors =>l_number_of_errors,
6339: p_msg_data =>l_msg_data);

Line 6382: wsh_util_core.api_post_call(

6378: x_msg_count => l_msg_count,
6379: x_msg_data => l_msg_data,
6380: p_trip_info => l_trip_info_rec);
6381:
6382: wsh_util_core.api_post_call(
6383: p_return_status =>l_return_status,
6384: x_num_warnings =>l_number_of_warnings,
6385: x_num_errors =>l_number_of_errors,
6386: p_msg_data =>l_msg_data);

Line 6393: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6389: END IF;
6390:
6391: IF l_number_of_errors > 0
6392: THEN
6393: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6394: RAISE FND_API.G_EXC_ERROR;
6395: ELSIF l_number_of_warnings > 0 THEN
6396: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6397: ELSE

Line 6396: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

6392: THEN
6393: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6394: RAISE FND_API.G_EXC_ERROR;
6395: ELSIF l_number_of_warnings > 0 THEN
6396: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6397: ELSE
6398: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6399: END IF;
6400:

Line 6398: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6394: RAISE FND_API.G_EXC_ERROR;
6395: ELSIF l_number_of_warnings > 0 THEN
6396: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6397: ELSE
6398: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6399: END IF;
6400:
6401:
6402: FND_MSG_PUB.Count_And_Get

Line 6431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6427: WSH_DEBUG_SV.pop(l_module_name);
6428: END IF;
6429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6430: ROLLBACK TO TRIP_ACTION_PUB;
6431: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6432: FND_MSG_PUB.Count_And_Get
6433: (
6434: p_count => x_msg_count,
6435: p_data => x_msg_data,

Line 6443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6439: WSH_DEBUG_SV.pop(l_module_name);
6440: END IF;
6441: WHEN OTHERS THEN
6442: ROLLBACK TO TRIP_ACTION_PUB;
6443: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6444: FND_MSG_PUB.Count_And_Get
6445: (
6446: p_count => x_msg_count,
6447: p_data => x_msg_data,

Line 6516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6512: END IF;
6513: --
6514: --
6515: -- Initialize API return status to success
6516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6517: x_msg_count := 0;
6518: x_msg_data := 0;
6519: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6520: l_number_of_warnings := 0;

Line 6519: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6515: -- Initialize API return status to success
6516: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6517: x_msg_count := 0;
6518: x_msg_data := 0;
6519: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6520: l_number_of_warnings := 0;
6521: l_number_of_errors := 0;
6522:
6523: IF l_debug_on

Line 6553: wsh_util_core.api_post_call(

6549:
6550: --}
6551: END IF;
6552:
6553: wsh_util_core.api_post_call(
6554: p_return_status =>l_return_status,
6555: x_num_warnings =>l_number_of_warnings,
6556: x_num_errors =>l_number_of_errors,
6557: p_msg_data =>l_msg_data);

Line 6562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6558:
6559:
6560: IF l_number_of_errors > 0
6561: THEN
6562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6563: RAISE FND_API.G_EXC_ERROR;
6564: ELSIF l_number_of_warnings > 0 THEN
6565: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6566: ELSE

Line 6565: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

6561: THEN
6562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6563: RAISE FND_API.G_EXC_ERROR;
6564: ELSIF l_number_of_warnings > 0 THEN
6565: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6566: ELSE
6567: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6568: END IF;
6569:

Line 6567: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6563: RAISE FND_API.G_EXC_ERROR;
6564: ELSIF l_number_of_warnings > 0 THEN
6565: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6566: ELSE
6567: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6568: END IF;
6569:
6570:
6571: FND_MSG_PUB.Count_And_Get

Line 6599: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6595: WSH_DEBUG_SV.pop(l_module_name);
6596: END IF;
6597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6598: ROLLBACK TO TRIP_ACTION_PUB;
6599: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6600: FND_MSG_PUB.Count_And_Get
6601: (
6602: p_count => x_msg_count,
6603: p_data => x_msg_data,

Line 6611: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6607: WSH_DEBUG_SV.pop(l_module_name);
6608: END IF;
6609: WHEN OTHERS THEN
6610: ROLLBACK TO TRIP_ACTION_PUB;
6611: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6612: FND_MSG_PUB.Count_And_Get
6613: (
6614: p_count => x_msg_count,
6615: p_data => x_msg_data,

Line 6692: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6688: IF l_debug_on THEN
6689: wsh_debug_sv.push(l_module_name);
6690: END IF;
6691: --
6692: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6693: l_msg_count := 0;
6694:
6695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6696: x_msg_count := 0;

Line 6695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6691: --
6692: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6693: l_msg_count := 0;
6694:
6695: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6696: x_msg_count := 0;
6697: --
6698:
6699: IF l_debug_on THEN

Line 6725: WSH_UTIL_CORE.API_POST_CALL(

6721: p_rec_VEHICLE_ITEM_ID => p_vehicle_item_id,
6722: p_rec_CONSIGNEE_CAR_AC_NO => p_CONSIGNEE_CARRIER_AC_NO,
6723: p_rec_FREIGHT_TERMS_CODE => p_FREIGHT_TERMS_CODE);
6724:
6725: WSH_UTIL_CORE.API_POST_CALL(
6726: p_return_status =>l_return_status,
6727: x_num_warnings =>l_number_of_warnings,
6728: x_num_errors =>l_number_of_errors,
6729: p_msg_data =>l_msg_data);

Line 6756: WSH_UTIL_CORE.API_POST_CALL(

6752: FTE_WORKFLOW_UTIL.TRIP_CANCEL_SERVICE(
6753: p_trip_id => p_trip_id,
6754: x_return_status => l_return_status);
6755:
6756: WSH_UTIL_CORE.API_POST_CALL(
6757: p_return_status =>l_return_status,
6758: x_num_warnings =>l_number_of_warnings,
6759: x_num_errors =>l_number_of_errors,
6760: p_msg_data =>l_msg_data);

Line 6781: WSH_UTIL_CORE.API_POST_CALL(

6777: FTE_WORKFLOW_UTIL.TRIP_SELECT_SERVICE_INIT(
6778: p_trip_id => p_trip_id,
6779: x_return_status => l_return_status);
6780:
6781: WSH_UTIL_CORE.API_POST_CALL(
6782: p_return_status =>l_return_status,
6783: x_num_warnings =>l_number_of_warnings,
6784: x_num_errors =>l_number_of_errors,
6785: p_msg_data =>l_msg_data);

Line 6799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

6795: */
6796:
6797: IF l_number_of_errors > 0
6798: THEN
6799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6800: RAISE FND_API.G_EXC_ERROR;
6801: ELSIF l_number_of_warnings > 0 THEN
6802: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6803: ELSE

Line 6802: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

6798: THEN
6799: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6800: RAISE FND_API.G_EXC_ERROR;
6801: ELSIF l_number_of_warnings > 0 THEN
6802: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6803: ELSE
6804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6805: END IF;
6806:

Line 6804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

6800: RAISE FND_API.G_EXC_ERROR;
6801: ELSIF l_number_of_warnings > 0 THEN
6802: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6803: ELSE
6804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6805: END IF;
6806:
6807: FND_MSG_PUB.Count_And_Get
6808: (

Line 6827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6823: p_encoded => FND_API.G_FALSE
6824: );
6825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6826: ROLLBACK TO UPD_SERV_ON_TRIP_PUB;
6827: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6828: FND_MSG_PUB.Count_And_Get
6829: (
6830: p_count => x_msg_count,
6831: p_data => x_msg_data,

Line 6836: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

6832: p_encoded => FND_API.G_FALSE
6833: );
6834: WHEN OTHERS THEN
6835: ROLLBACK TO UPD_SERV_ON_TRIP_PUB;
6836: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6837: FND_MSG_PUB.Count_And_Get
6838: (
6839: p_count => x_msg_count,
6840: p_data => x_msg_data,