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 FND_MSG_PUB

Line 139: FND_MSG_PUB.initialize;

135: --
136: --
137: IF FND_API.to_Boolean( p_init_msg_list )
138: THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141: --
142: --
143: -- Initialize API return status to success

Line 334: FND_MSG_PUB.Count_And_Get (

330:
331: END IF;
332:
333:
334: FND_MSG_PUB.Count_And_Get (
335: p_count => x_msg_count,
336: p_data => x_msg_data);
337:
338: IF l_debug_on THEN

Line 346: FND_MSG_PUB.Count_And_Get

342: EXCEPTION
343: WHEN FND_API.G_EXC_ERROR THEN
344: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: FND_MSG_PUB.Count_And_Get
347: (
348: p_count => x_msg_count,
349: p_data => x_msg_data,
350: p_encoded => FND_API.G_FALSE

Line 359: FND_MSG_PUB.Count_And_Get

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,
363: p_encoded => FND_API.G_FALSE

Line 371: FND_MSG_PUB.Count_And_Get

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,
375: p_encoded => FND_API.G_FALSE

Line 431: FND_MSG_PUB.initialize;

427: --
428: --
429: IF FND_API.to_Boolean( p_init_msg_list )
430: THEN
431: FND_MSG_PUB.initialize;
432: END IF;
433: --
434: --
435: -- Initialize API return status to success

Line 501: FND_MSG_PUB.Count_And_Get

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: (
503: p_count => x_msg_count,
504: p_data => x_msg_data,
505: p_encoded => FND_API.G_FALSE

Line 517: FND_MSG_PUB.Count_And_Get

513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO STOP_ACTION_PUB;
516: x_return_status := FND_API.G_RET_STS_ERROR;
517: FND_MSG_PUB.Count_And_Get
518: (
519: p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => FND_API.G_FALSE

Line 530: FND_MSG_PUB.Count_And_Get

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,
534: p_encoded => FND_API.G_FALSE

Line 542: FND_MSG_PUB.Count_And_Get

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,
546: p_encoded => FND_API.G_FALSE

Line 637: FND_MSG_PUB.initialize;

633: --
634: --
635: IF FND_API.to_Boolean( p_init_msg_list )
636: THEN
637: FND_MSG_PUB.initialize;
638: END IF;
639: --
640: --
641: -- Initialize API return status to success

Line 751: FND_MSG_PUB.Count_And_Get

747: x_delivery_leg_seq := delivery_leg_rec.sequence_number;
748: --}
749: END LOOP;
750:
751: FND_MSG_PUB.Count_And_Get
752: (
753: p_count => x_msg_count,
754: p_data => x_msg_data,
755: p_encoded => FND_API.G_FALSE

Line 767: FND_MSG_PUB.Count_And_Get

763: EXCEPTION
764: WHEN FND_API.G_EXC_ERROR THEN
765: ROLLBACK TO DELIVERY_ACTION_PUB;
766: x_return_status := FND_API.G_RET_STS_ERROR;
767: FND_MSG_PUB.Count_And_Get
768: (
769: p_count => x_msg_count,
770: p_data => x_msg_data,
771: p_encoded => FND_API.G_FALSE

Line 780: FND_MSG_PUB.Count_And_Get

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,
784: p_encoded => FND_API.G_FALSE

Line 794: FND_MSG_PUB.Count_And_Get

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,
798: p_encoded => FND_API.G_FALSE

Line 1014: FND_MSG_PUB.Count_And_Get

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: (
1016: p_count => x_msg_count,
1017: p_data => x_msg_data,
1018: p_encoded => FND_API.G_FALSE

Line 1025: FND_MSG_PUB.Count_And_Get

1021: EXCEPTION
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: ROLLBACK TO CREATE_UPDATE_TRIP_OLD_PUB;
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: FND_MSG_PUB.Count_And_Get
1026: (
1027: p_count => x_msg_count,
1028: p_data => x_msg_data,
1029: p_encoded => FND_API.G_FALSE

Line 1034: FND_MSG_PUB.Count_And_Get

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,
1038: p_encoded => FND_API.G_FALSE

Line 1043: FND_MSG_PUB.Count_And_Get

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,
1047: p_encoded => FND_API.G_FALSE

Line 1181: FND_MSG_PUB.initialize;

1177: --
1178: --
1179: IF FND_API.to_Boolean( p_init_msg_list )
1180: THEN
1181: FND_MSG_PUB.initialize;
1182: END IF;
1183: --
1184: --
1185: -- Initialize API return status to success

Line 1496: FND_MSG_PUB.Count_And_Get

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: (
1498: p_count => x_msg_count,
1499: p_data => x_msg_data,
1500: p_encoded => FND_API.G_FALSE

Line 1518: FND_MSG_PUB.Count_And_Get

1514: EXCEPTION
1515: WHEN FND_API.G_EXC_ERROR THEN
1516: ROLLBACK TO CREATE_UPDATE_TRIP_PUB;
1517: x_return_status := FND_API.G_RET_STS_ERROR;
1518: FND_MSG_PUB.Count_And_Get
1519: (
1520: p_count => x_msg_count,
1521: p_data => x_msg_data,
1522: p_encoded => FND_API.G_FALSE

Line 1534: FND_MSG_PUB.Count_And_Get

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,
1538: p_encoded => FND_API.G_FALSE

Line 1553: FND_MSG_PUB.Count_And_Get

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,
1557: p_encoded => FND_API.G_FALSE

Line 1604: FND_MSG_PUB.initialize;

1600: --
1601: --
1602: IF FND_API.to_Boolean( p_init_msg_list )
1603: THEN
1604: FND_MSG_PUB.initialize;
1605: END IF;
1606: --
1607: --
1608: -- Initialize API return status to success

Line 1646: FND_MSG_PUB.Count_And_Get

1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: ROLLBACK TO TRIP_ACTION_PUB;
1645: x_return_status := FND_API.G_RET_STS_ERROR;
1646: FND_MSG_PUB.Count_And_Get
1647: (
1648: p_count => x_msg_count,
1649: p_data => x_msg_data,
1650: p_encoded => FND_API.G_FALSE

Line 1659: FND_MSG_PUB.Count_And_Get

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,
1663: p_encoded => FND_API.G_FALSE

Line 1671: FND_MSG_PUB.Count_And_Get

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,
1675: p_encoded => FND_API.G_FALSE

Line 1849: FND_MSG_PUB.ADD;

1845: (l_modeOfTransport IS NULL) OR
1846: (l_serviceLevel IS NULL)) THEN
1847:
1848: FND_MESSAGE.SET_NAME('FTE','FTE_MLS_TENDER_INIT_FAIL');
1849: FND_MSG_PUB.ADD;
1850:
1851: IF l_debug_on THEN
1852: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier/Lane/ServiceLevel/Mode is null. Trip Cannot be tendered.');
1853: WSH_DEBUG_SV.pop(l_module_name);

Line 1880: FND_MSG_PUB.ADD;

1876: IF l_isCarrierTenderEnabled <> 'Y' THEN
1877: --Log exception into FND
1878: FND_MESSAGE.SET_NAME('FTE','FTE_CARRIER_NOT_TENDER_ENBL');
1879: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1880: FND_MSG_PUB.ADD;
1881: IF l_debug_on THEN
1882: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier is not tender Enabled');
1883: WSH_DEBUG_SV.pop(l_module_name);
1884: END IF;

Line 1899: FND_MSG_PUB.ADD;

1895:
1896: IF l_autoTenderEnabled <> 'Y' THEN
1897: FND_MESSAGE.SET_NAME('FTE','FTE_CARRIER_NO_AUTO_TENDER');
1898: FND_MESSAGE.SET_TOKEN('CARRIER_NAME', l_carrier_name);
1899: FND_MSG_PUB.ADD;
1900: IF l_debug_on THEN
1901: WSH_DEBUG_SV.logmsg(l_module_name,' Carrier is not auto tender enabled ');
1902: WSH_DEBUG_SV.pop(l_module_name);
1903: END IF;

Line 1922: FND_MSG_PUB.ADD;

1918: IF l_numberOfDeliveries = 0 THEN
1919: --Log Exception FTE_TRIP_CNT_TENDER_NO_DLVY with token TRIP_NAME
1920: FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_CNT_TENDER_NO_DLVY');
1921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', x_tripName);
1922: FND_MSG_PUB.ADD;
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.logmsg(l_module_name,' Trip Cannot be tendered since there are no delieries on the trip ');
1925: WSH_DEBUG_SV.pop(l_module_name);
1926: END IF;

Line 2134: FND_MSG_PUB.initialize;

2130: SAVEPOINT TENDER_TRIPS;
2131: -- Initialize message list if p_init_msg_list is set to TRUE.
2132: --
2133: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2134: FND_MSG_PUB.initialize;
2135: END IF;
2136:
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.PUSH(l_module_name);

Line 2333: FND_MSG_PUB.Count_And_Get (

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,
2335: p_data => x_msg_data,
2336: p_encoded => FND_API.G_FALSE);
2337:

Line 2354: FND_MSG_PUB.initialize; -- FND messages are not sent back to the UI hence clearing the stack

2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.logmsg(l_module_name,'Clearing off unrequired messages');
2352: END IF;
2353:
2354: FND_MSG_PUB.initialize; -- FND messages are not sent back to the UI hence clearing the stack
2355: x_msg_data := '';
2356: x_msg_count := 0;
2357:
2358: IF (l_error_id_tab.COUNT > 0) THEN --In case any error is present.

Line 2376: FND_MSG_PUB.ADD;

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:
2378: FND_MSG_PUB.Count_And_Get (
2379: p_count => x_msg_count,
2380: p_data => x_msg_data,

Line 2378: FND_MSG_PUB.Count_And_Get (

2374: FND_MESSAGE.SET_NAME('FTE','FTE_MULTI_TENDER_PASS');
2375: END IF;
2376: FND_MSG_PUB.ADD;
2377:
2378: FND_MSG_PUB.Count_And_Get (
2379: p_count => x_msg_count,
2380: p_data => x_msg_data,
2381: p_encoded => FND_API.G_FALSE);
2382:

Line 2399: FND_MSG_PUB.Count_And_Get

2395: EXCEPTION
2396: WHEN FND_API.G_EXC_ERROR THEN
2397: ROLLBACK TO TENDER_TRIPS;
2398: x_return_status := FND_API.G_RET_STS_ERROR;
2399: FND_MSG_PUB.Count_And_Get
2400: (
2401: p_count => x_msg_count,
2402: p_data => x_msg_data,
2403: p_encoded => FND_API.G_FALSE

Line 2411: FND_MSG_PUB.Count_And_Get

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,
2415: p_encoded => FND_API.G_FALSE

Line 2424: FND_MSG_PUB.Count_And_Get

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,
2428: p_encoded => FND_API.G_FALSE

Line 2499: FND_MSG_PUB.ADD;

2495: --Check if PlannedFlag = F (Firm) or Y (Planned)
2496: IF ((l_tripPlannedFlag = TRIP_FIRM) OR (l_tripPlannedFlag = TRIP_PLANNED)) THEN
2497: FND_MESSAGE.SET_NAME('FTE','FTE_CNT_CAN_TENDER_FIRMED');
2498: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_tripName);
2499: FND_MSG_PUB.ADD;
2500: IF l_debug_on THEN
2501: WSH_DEBUG_SV.logmsg(l_module_name,'Failed since Planned Flag is ' || l_tripPlannedFlag);
2502: WSH_DEBUG_SV.pop(l_module_name);
2503: END IF;

Line 2586: FND_MSG_PUB.initialize;

2582:
2583: BEGIN
2584: -- Initialize message list if p_init_msg_list is set to TRUE.
2585: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2586: FND_MSG_PUB.initialize;
2587: END IF;
2588: SAVEPOINT CANCEL_TENDER_TRIPS;
2589: IF l_debug_on THEN
2590: WSH_DEBUG_SV.PUSH(l_module_name);

Line 2777: FND_MSG_PUB.initialize; -- FND messages are not sent back to the UI hence clearing the stack

2773: --Suppressing the detailed msg to be shown to the user
2774: IF l_debug_on THEN
2775: WSH_DEBUG_SV.logmsg(l_module_name,'Clearing off unrequired messages - ' || l_msg_data);
2776: END IF;
2777: FND_MSG_PUB.initialize; -- FND messages are not sent back to the UI hence clearing the stack
2778: x_msg_data := '';
2779: x_msg_count := 0;
2780:
2781: IF (l_error_name_tab.COUNT > 0) THEN -- If error/warning get trip name list

Line 2797: FND_MSG_PUB.ADD;

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:
2799: FND_MSG_PUB.Count_And_Get (
2800: p_count => x_msg_count,
2801: p_data => x_msg_data,

Line 2799: FND_MSG_PUB.Count_And_Get (

2795: FND_MESSAGE.SET_TOKEN('trip_names', l_tripNames);
2796: END IF;
2797: FND_MSG_PUB.ADD;
2798:
2799: FND_MSG_PUB.Count_And_Get (
2800: p_count => x_msg_count,
2801: p_data => x_msg_data,
2802: p_encoded => FND_API.G_FALSE);
2803:

Line 2811: FND_MSG_PUB.COUNT_AND_GET

2807: EXCEPTION
2808: WHEN FND_API.G_EXC_ERROR THEN
2809: ROLLBACK TO CANCEL_TENDER_TRIPS;
2810: x_return_status := FND_API.G_RET_STS_ERROR;
2811: FND_MSG_PUB.COUNT_AND_GET
2812: (
2813: p_count => x_msg_count,
2814: p_data => x_msg_data,
2815: p_encoded => FND_API.G_FALSE

Line 2823: FND_MSG_PUB.COUNT_AND_GET

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,
2827: p_encoded => FND_API.G_FALSE

Line 2836: FND_MSG_PUB.COUNT_AND_GET

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,
2840: p_encoded => FND_API.G_FALSE

Line 2902: FND_MSG_PUB.initialize;

2898: --
2899: --
2900: IF FND_API.to_Boolean( p_init_msg_list )
2901: THEN
2902: FND_MSG_PUB.initialize;
2903: END IF;
2904: --
2905: --
2906: -- Initialize API return status to success

Line 3038: FND_MSG_PUB.Count_And_Get

3034: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3035: END IF;
3036:
3037:
3038: FND_MSG_PUB.Count_And_Get
3039: (
3040: p_count => x_msg_count,
3041: p_data => x_msg_data,
3042: p_encoded => FND_API.G_FALSE

Line 3055: FND_MSG_PUB.Count_And_Get

3051: EXCEPTION
3052: WHEN FND_API.G_EXC_ERROR THEN
3053: ROLLBACK TO TRIP_ACTION_PUB;
3054: x_return_status := FND_API.G_RET_STS_ERROR;
3055: FND_MSG_PUB.Count_And_Get
3056: (
3057: p_count => x_msg_count,
3058: p_data => x_msg_data,
3059: p_encoded => FND_API.G_FALSE

Line 3068: FND_MSG_PUB.Count_And_Get

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,
3072: p_encoded => FND_API.G_FALSE

Line 3080: FND_MSG_PUB.Count_And_Get

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,
3084: p_encoded => FND_API.G_FALSE

Line 3149: FND_MSG_PUB.initialize;

3145: --
3146: --
3147: IF FND_API.to_Boolean( p_init_msg_list )
3148: THEN
3149: FND_MSG_PUB.initialize;
3150: END IF;
3151: --
3152: --
3153: -- Initialize API return status to success

Line 3265: FND_MSG_PUB.Count_And_Get

3261: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_data:' || x_msg_data);
3262: END IF;
3263:
3264:
3265: FND_MSG_PUB.Count_And_Get
3266: (
3267: p_count => x_msg_count,
3268: p_data => x_msg_data,
3269: p_encoded => FND_API.G_FALSE

Line 3284: FND_MSG_PUB.Count_And_Get

3280: EXCEPTION
3281: WHEN FND_API.G_EXC_ERROR THEN
3282: ROLLBACK TO STOP_ACTION_PUB;
3283: x_return_status := FND_API.G_RET_STS_ERROR;
3284: FND_MSG_PUB.Count_And_Get
3285: (
3286: p_count => x_msg_count,
3287: p_data => x_msg_data,
3288: p_encoded => FND_API.G_FALSE

Line 3297: FND_MSG_PUB.Count_And_Get

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,
3301: p_encoded => FND_API.G_FALSE

Line 3309: FND_MSG_PUB.Count_And_Get

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,
3313: p_encoded => FND_API.G_FALSE

Line 3363: FND_MSG_PUB.initialize;

3359: --
3360: --
3361: IF FND_API.to_Boolean( p_init_msg_list )
3362: THEN
3363: FND_MSG_PUB.initialize;
3364: END IF;
3365: --
3366: --
3367: -- Initialize API return status to success

Line 3389: FND_MSG_PUB.Count_And_Get

3385: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
3386: END IF;
3387:
3388:
3389: FND_MSG_PUB.Count_And_Get
3390: (
3391: p_count => x_msg_count,
3392: p_data => x_msg_data,
3393: p_encoded => FND_API.G_FALSE

Line 3406: FND_MSG_PUB.Count_And_Get

3402: EXCEPTION
3403: WHEN FND_API.G_EXC_ERROR THEN
3404: ROLLBACK TO INIT_STOPS_PLS_TABLE_PUB;
3405: x_return_status := FND_API.G_RET_STS_ERROR;
3406: FND_MSG_PUB.Count_And_Get
3407: (
3408: p_count => x_msg_count,
3409: p_data => x_msg_data,
3410: p_encoded => FND_API.G_FALSE

Line 3419: FND_MSG_PUB.Count_And_Get

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,
3423: p_encoded => FND_API.G_FALSE

Line 3431: FND_MSG_PUB.Count_And_Get

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,
3435: p_encoded => FND_API.G_FALSE

Line 3499: FND_MSG_PUB.initialize;

3495: --
3496: --
3497: IF FND_API.to_Boolean( p_init_msg_list )
3498: THEN
3499: FND_MSG_PUB.initialize;
3500: END IF;
3501: --
3502: --
3503: -- Initialize API return status to success

Line 3644: FND_MSG_PUB.Count_And_Get

3640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3641: END IF;
3642:
3643:
3644: FND_MSG_PUB.Count_And_Get
3645: (
3646: p_count => x_msg_count,
3647: p_data => x_msg_data,
3648: p_encoded => FND_API.G_FALSE

Line 3666: FND_MSG_PUB.Count_And_Get

3662: EXCEPTION
3663: WHEN FND_API.G_EXC_ERROR THEN
3664: ROLLBACK TO PROCESS_STOPS_PUB;
3665: x_return_status := FND_API.G_RET_STS_ERROR;
3666: FND_MSG_PUB.Count_And_Get
3667: (
3668: p_count => x_msg_count,
3669: p_data => x_msg_data,
3670: p_encoded => FND_API.G_FALSE

Line 3681: FND_MSG_PUB.Count_And_Get

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,
3685: p_encoded => FND_API.G_FALSE

Line 3699: FND_MSG_PUB.Count_And_Get

3695: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
3696: WSH_DEBUG_SV.pop(l_module_name);
3697: END IF;
3698:
3699: FND_MSG_PUB.Count_And_Get
3700: (
3701: p_count => x_msg_count,
3702: p_data => x_msg_data,
3703: p_encoded => FND_API.G_FALSE

Line 3758: FND_MSG_PUB.initialize;

3754: --
3755: --
3756: IF FND_API.to_Boolean( p_init_msg_list )
3757: THEN
3758: FND_MSG_PUB.initialize;
3759: END IF;
3760: --
3761: --
3762: -- Initialize API return status to success

Line 3810: FND_MSG_PUB.Count_And_Get

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: (
3812: p_count => x_msg_count,
3813: p_data => x_msg_data,
3814: p_encoded => FND_API.G_FALSE

Line 3831: FND_MSG_PUB.Count_And_Get

3827: EXCEPTION
3828: WHEN FND_API.G_EXC_ERROR THEN
3829: ROLLBACK TO CREATE_UPDATE_STOP_PUB;
3830: x_return_status := FND_API.G_RET_STS_ERROR;
3831: FND_MSG_PUB.Count_And_Get
3832: (
3833: p_count => x_msg_count,
3834: p_data => x_msg_data,
3835: p_encoded => FND_API.G_FALSE

Line 3844: FND_MSG_PUB.Count_And_Get

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,
3848: p_encoded => FND_API.G_FALSE

Line 3856: FND_MSG_PUB.Count_And_Get

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,
3860: p_encoded => FND_API.G_FALSE

Line 3901: FND_MSG_PUB.initialize;

3897: --
3898: --
3899: IF FND_API.to_Boolean( p_init_msg_list )
3900: THEN
3901: FND_MSG_PUB.initialize;
3902: END IF;
3903: --
3904: --
3905: -- Initialize API return status to success

Line 3950: FND_MSG_PUB.Count_And_Get

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: (
3952: p_count => x_msg_count,
3953: p_data => x_msg_data,
3954: p_encoded => FND_API.G_FALSE

Line 3971: FND_MSG_PUB.Count_And_Get

3967: EXCEPTION
3968: WHEN FND_API.G_EXC_ERROR THEN
3969: ROLLBACK TO REPRICE_TRIP_PUB;
3970: x_return_status := FND_API.G_RET_STS_ERROR;
3971: FND_MSG_PUB.Count_And_Get
3972: (
3973: p_count => x_msg_count,
3974: p_data => x_msg_data,
3975: p_encoded => FND_API.G_FALSE

Line 3984: FND_MSG_PUB.Count_And_Get

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,
3988: p_encoded => FND_API.G_FALSE

Line 3996: FND_MSG_PUB.Count_And_Get

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,
4000: p_encoded => FND_API.G_FALSE

Line 4055: FND_MSG_PUB.initialize;

4051: --
4052: --
4053: IF FND_API.to_Boolean( p_init_msg_list )
4054: THEN
4055: FND_MSG_PUB.initialize;
4056: END IF;
4057: --
4058: --
4059: -- Initialize API return status to success

Line 4162: FND_MSG_PUB.Count_And_Get

4158: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4159: END IF;
4160:
4161:
4162: FND_MSG_PUB.Count_And_Get
4163: (
4164: p_count => x_msg_count,
4165: p_data => x_msg_data,
4166: p_encoded => FND_API.G_FALSE

Line 4178: FND_MSG_PUB.Count_And_Get

4174: EXCEPTION
4175: WHEN FND_API.G_EXC_ERROR THEN
4176: ROLLBACK TO DETAIL_ACTION_PUB;
4177: x_return_status := FND_API.G_RET_STS_ERROR;
4178: FND_MSG_PUB.Count_And_Get
4179: (
4180: p_count => x_msg_count,
4181: p_data => x_msg_data,
4182: p_encoded => FND_API.G_FALSE

Line 4191: FND_MSG_PUB.Count_And_Get

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,
4195: p_encoded => FND_API.G_FALSE

Line 4203: FND_MSG_PUB.Count_And_Get

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,
4207: p_encoded => FND_API.G_FALSE

Line 4256: FND_MSG_PUB.initialize;

4252: --
4253: --
4254: IF FND_API.to_Boolean( p_init_msg_list )
4255: THEN
4256: FND_MSG_PUB.initialize;
4257: END IF;
4258: --
4259: --
4260: -- Initialize API return status to success

Line 4494: FND_MSG_PUB.Count_And_Get

4490: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
4491: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
4492: END IF;
4493:
4494: FND_MSG_PUB.Count_And_Get
4495: (
4496: p_count => x_msg_count,
4497: p_data => x_msg_data,
4498: p_encoded => FND_API.G_FALSE

Line 4511: FND_MSG_PUB.Count_And_Get

4507: EXCEPTION
4508: WHEN FND_API.G_EXC_ERROR THEN
4509: ROLLBACK TO DDL_CREATE_UPDATE_PUB;
4510: x_return_status := FND_API.G_RET_STS_ERROR;
4511: FND_MSG_PUB.Count_And_Get
4512: (
4513: p_count => x_msg_count,
4514: p_data => x_msg_data,
4515: p_encoded => FND_API.G_FALSE

Line 4524: FND_MSG_PUB.Count_And_Get

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,
4528: p_encoded => FND_API.G_FALSE

Line 4536: FND_MSG_PUB.Count_And_Get

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,
4540: p_encoded => FND_API.G_FALSE

Line 4609: FND_MSG_PUB.initialize;

4605: --
4606: --
4607: IF FND_API.to_Boolean( p_init_msg_list )
4608: THEN
4609: FND_MSG_PUB.initialize;
4610: END IF;
4611: --
4612: --
4613: -- Initialize API return status to success

Line 4758: FND_MSG_PUB.Count_And_Get

4754: END IF;
4755:
4756:
4757: /**
4758: FND_MSG_PUB.Count_And_Get
4759: (
4760: p_count => x_msg_count,
4761: p_data => x_msg_data,
4762: p_encoded => FND_API.G_FALSE

Line 4776: FND_MSG_PUB.Count_And_Get

4772: EXCEPTION
4773: WHEN FND_API.G_EXC_ERROR THEN
4774: ROLLBACK TO DELIVERY_ACTION_PUB;
4775: x_return_status := FND_API.G_RET_STS_ERROR;
4776: FND_MSG_PUB.Count_And_Get
4777: (
4778: p_count => x_msg_count,
4779: p_data => x_msg_data,
4780: p_encoded => FND_API.G_FALSE

Line 4789: FND_MSG_PUB.Count_And_Get

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,
4793: p_encoded => FND_API.G_FALSE

Line 4801: FND_MSG_PUB.Count_And_Get

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,
4805: p_encoded => FND_API.G_FALSE

Line 4871: FND_MSG_PUB.initialize;

4867: --
4868: --
4869: IF FND_API.to_Boolean( p_init_msg_list )
4870: THEN
4871: FND_MSG_PUB.initialize;
4872: END IF;
4873: --
4874: --
4875: -- Initialize API return status to success

Line 4985: FND_MSG_PUB.Count_And_Get

4981: EXCEPTION
4982: WHEN FND_API.G_EXC_ERROR THEN
4983: ROLLBACK TO DELIVERY_ACTION_ON_TRIP_PUB;
4984: x_return_status := FND_API.G_RET_STS_ERROR;
4985: FND_MSG_PUB.Count_And_Get
4986: (
4987: p_count => x_msg_count,
4988: p_data => x_msg_data,
4989: p_encoded => FND_API.G_FALSE

Line 4997: FND_MSG_PUB.Count_And_Get

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,
5001: p_encoded => FND_API.G_FALSE

Line 5009: FND_MSG_PUB.Count_And_Get

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,
5013: p_encoded => FND_API.G_FALSE

Line 5065: FND_MSG_PUB.initialize;

5061: --
5062: --
5063: IF FND_API.to_Boolean( p_init_msg_list )
5064: THEN
5065: FND_MSG_PUB.initialize;
5066: END IF;
5067: --
5068: --
5069: -- Initialize API return status to success

Line 5279: FND_MSG_PUB.Count_And_Get

5275: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5276: WSH_DEBUG_SV.logmsg(l_module_name,'x_msg_count:' || x_msg_count);
5277: END IF;
5278:
5279: FND_MSG_PUB.Count_And_Get
5280: (
5281: p_count => x_msg_count,
5282: p_data => x_msg_data,
5283: p_encoded => FND_API.G_FALSE

Line 5296: FND_MSG_PUB.Count_And_Get

5292: EXCEPTION
5293: WHEN FND_API.G_EXC_ERROR THEN
5294: ROLLBACK TO DELIVERY_CREATE_UPDATE_PUB;
5295: x_return_status := FND_API.G_RET_STS_ERROR;
5296: FND_MSG_PUB.Count_And_Get
5297: (
5298: p_count => x_msg_count,
5299: p_data => x_msg_data,
5300: p_encoded => FND_API.G_FALSE

Line 5309: FND_MSG_PUB.Count_And_Get

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,
5313: p_encoded => FND_API.G_FALSE

Line 5321: FND_MSG_PUB.Count_And_Get

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,
5325: p_encoded => FND_API.G_FALSE

Line 5381: FND_MSG_PUB.initialize;

5377: --
5378: --
5379: IF FND_API.to_Boolean( p_init_msg_list )
5380: THEN
5381: FND_MSG_PUB.initialize;
5382: END IF;
5383: --
5384: --
5385: -- Initialize API return status to success

Line 5528: FND_MSG_PUB.Count_And_Get

5524: WSH_DEBUG_SV.logmsg(l_module_name,'x_return_status:' || x_return_status);
5525: END IF;
5526:
5527: /**
5528: FND_MSG_PUB.Count_And_Get
5529: (
5530: p_count => x_msg_count,
5531: p_data => x_msg_data,
5532: p_encoded => FND_API.G_FALSE

Line 5548: FND_MSG_PUB.Count_And_Get

5544: EXCEPTION
5545: WHEN FND_API.G_EXC_ERROR THEN
5546: ROLLBACK TO EXCEPTION_ACTION_PUB;
5547: x_return_status := FND_API.G_RET_STS_ERROR;
5548: FND_MSG_PUB.Count_And_Get
5549: (
5550: p_count => x_msg_count,
5551: p_data => x_msg_data,
5552: p_encoded => FND_API.G_FALSE

Line 5561: FND_MSG_PUB.Count_And_Get

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,
5565: p_encoded => FND_API.G_FALSE

Line 5573: FND_MSG_PUB.Count_And_Get

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,
5577: p_encoded => FND_API.G_FALSE

Line 5624: FND_MSG_PUB.initialize;

5620: --
5621: --
5622: IF FND_API.to_Boolean( p_init_msg_list )
5623: THEN
5624: FND_MSG_PUB.initialize;
5625: END IF;
5626: --
5627: --
5628: -- Initialize API return status to success

Line 5673: FND_MSG_PUB.ADD;

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)
5676: THEN
5677: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;

Line 5680: FND_MSG_PUB.ADD;

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)
5683: THEN
5684: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;

Line 5687: FND_MSG_PUB.Count_And_Get

5683: THEN
5684: WSH_DELIVERY_AUTOCREATE.Reset_WSH_TMP;
5685: END IF;
5686:
5687: FND_MSG_PUB.Count_And_Get
5688: (
5689: p_count => x_msg_count,
5690: p_data => x_msg_data,
5691: p_encoded => FND_API.G_FALSE

Line 5702: FND_MSG_PUB.Count_And_Get

5698: EXCEPTION
5699: WHEN FND_API.G_EXC_ERROR THEN
5700: ROLLBACK TO GROUP_DETAIL_SEARCH_DLVY_PUB;
5701: x_return_status := FND_API.G_RET_STS_ERROR;
5702: FND_MSG_PUB.Count_And_Get
5703: (
5704: p_count => x_msg_count,
5705: p_data => x_msg_data,
5706: p_encoded => FND_API.G_FALSE

Line 5715: FND_MSG_PUB.Count_And_Get

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,
5719: p_encoded => FND_API.G_FALSE

Line 5727: FND_MSG_PUB.Count_And_Get

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,
5731: p_encoded => FND_API.G_FALSE

Line 5900: FND_MSG_PUB.initialize;

5896: --
5897:
5898: IF FND_API.to_Boolean( p_init_msg_list )
5899: THEN
5900: FND_MSG_PUB.initialize;
5901: END IF;
5902: --
5903: --
5904: -- Initialize API return status to success

Line 6402: FND_MSG_PUB.Count_And_Get

6398: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6399: END IF;
6400:
6401:
6402: FND_MSG_PUB.Count_And_Get
6403: (
6404: p_count => x_msg_count,
6405: p_data => x_msg_data,
6406: p_encoded => FND_API.G_FALSE

Line 6419: FND_MSG_PUB.Count_And_Get

6415: EXCEPTION
6416: WHEN FND_API.G_EXC_ERROR THEN
6417: ROLLBACK TO TRIP_ACTION_PUB;
6418: x_return_status := FND_API.G_RET_STS_ERROR;
6419: FND_MSG_PUB.Count_And_Get
6420: (
6421: p_count => x_msg_count,
6422: p_data => x_msg_data,
6423: p_encoded => FND_API.G_FALSE

Line 6432: FND_MSG_PUB.Count_And_Get

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,
6436: p_encoded => FND_API.G_FALSE

Line 6444: FND_MSG_PUB.Count_And_Get

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,
6448: p_encoded => FND_API.G_FALSE

Line 6511: FND_MSG_PUB.initialize;

6507: -- we are going to default them from the first
6508: -- found carrier site.
6509: IF FND_API.to_Boolean( p_init_msg_list )
6510: THEN
6511: FND_MSG_PUB.initialize;
6512: END IF;
6513: --
6514: --
6515: -- Initialize API return status to success

Line 6571: FND_MSG_PUB.Count_And_Get

6567: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
6568: END IF;
6569:
6570:
6571: FND_MSG_PUB.Count_And_Get
6572: (
6573: p_count => x_msg_count,
6574: p_data => x_msg_data,
6575: p_encoded => FND_API.G_FALSE

Line 6587: FND_MSG_PUB.Count_And_Get

6583: EXCEPTION
6584: WHEN FND_API.G_EXC_ERROR THEN
6585: ROLLBACK TO TRIP_ACTION_PUB;
6586: x_return_status := FND_API.G_RET_STS_ERROR;
6587: FND_MSG_PUB.Count_And_Get
6588: (
6589: p_count => x_msg_count,
6590: p_data => x_msg_data,
6591: p_encoded => FND_API.G_FALSE

Line 6600: FND_MSG_PUB.Count_And_Get

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,
6604: p_encoded => FND_API.G_FALSE

Line 6612: FND_MSG_PUB.Count_And_Get

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,
6616: p_encoded => FND_API.G_FALSE

Line 6685: FND_MSG_PUB.initialize;

6681: -- Initialize message list if p_init_msg_list is set to TRUE.
6682: --
6683: --IF FND_API.to_Boolean( p_init_msg_list )
6684: --THEN
6685: FND_MSG_PUB.initialize;
6686: --END IF;
6687: --
6688: IF l_debug_on THEN
6689: wsh_debug_sv.push(l_module_name);

Line 6807: FND_MSG_PUB.Count_And_Get

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: (
6809: p_count => x_msg_count,
6810: p_data => x_msg_data,
6811: p_encoded => FND_API.G_FALSE

Line 6819: FND_MSG_PUB.Count_And_Get

6815: EXCEPTION
6816: WHEN FND_API.G_EXC_ERROR THEN
6817: ROLLBACK TO UPD_SERV_ON_TRIP_PUB;
6818: x_return_status := FND_API.G_RET_STS_ERROR;
6819: FND_MSG_PUB.Count_And_Get
6820: (
6821: p_count => x_msg_count,
6822: p_data => x_msg_data,
6823: p_encoded => FND_API.G_FALSE

Line 6828: FND_MSG_PUB.Count_And_Get

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,
6832: p_encoded => FND_API.G_FALSE

Line 6837: FND_MSG_PUB.Count_And_Get

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,
6841: p_encoded => FND_API.G_FALSE