DBA Data[Home] [Help]

APPS.WSH_INTERFACE_GRP dependencies on FND_MSG_PUB

Line 439: FND_MSG_PUB.initialize;

435: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
436: END IF;
437: --
438: IF FND_API.to_Boolean( p_init_msg_list ) THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441: --
442: Rtrim_deliveries_action(p_action_prms,l_action_prms);
443:

Line 527: FND_MSG_PUB.Count_And_Get (

523: IF FND_API.To_Boolean( p_commit ) THEN
524: COMMIT WORK;
525: END IF;
526: --
527: FND_MSG_PUB.Count_And_Get (
528: p_count => x_msg_count,
529: p_data => x_msg_data);
530: --
531: IF l_debug_on THEN

Line 539: FND_MSG_PUB.Count_And_Get

535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN
537: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get
540: (
541: p_count => x_msg_count,
542: p_data => x_msg_data,
543: p_encoded => FND_API.G_FALSE

Line 554: FND_MSG_PUB.Count_And_Get

550: --
551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
552: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555: (
556: p_count => x_msg_count,
557: p_data => x_msg_data,
558: p_encoded => FND_API.G_FALSE

Line 568: FND_MSG_PUB.Count_And_Get

564: END IF;
565: --
566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
568: FND_MSG_PUB.Count_And_Get
569: (
570: p_count => x_msg_count,
571: p_data => x_msg_data,
572: p_encoded => FND_API.G_FALSE

Line 584: FND_MSG_PUB.Count_And_Get

580: WHEN OTHERS THEN
581: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
583: wsh_util_core.default_handler('WSH_INTERFACE_GRP.DELIVERY_ACTION');
584: FND_MSG_PUB.Count_And_Get
585: (
586: p_count => x_msg_count,
587: p_data => x_msg_data,
588: p_encoded => FND_API.G_FALSE

Line 817: FND_MSG_PUB.initialize;

813: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
814: END IF;
815: --
816: IF FND_API.to_Boolean( p_init_msg_list ) THEN
817: FND_MSG_PUB.initialize;
818: END IF;
819: --
820: l_in_rec := p_in_rec;
821: l_in_rec.caller := RTRIM(p_in_rec.caller);

Line 859: FND_MSG_PUB.Count_And_Get (

855: IF FND_API.To_Boolean( p_commit ) THEN
856: COMMIT WORK;
857: END IF;
858: --
859: FND_MSG_PUB.Count_And_Get (
860: p_count => x_msg_count,
861: p_data => x_msg_data);
862: --
863: IF l_debug_on THEN

Line 871: FND_MSG_PUB.Count_And_Get

867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
870: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get
872: (
873: p_count => x_msg_count,
874: p_data => x_msg_data,
875: p_encoded => FND_API.G_FALSE

Line 886: FND_MSG_PUB.Count_And_Get

882: --
883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
886: FND_MSG_PUB.Count_And_Get
887: (
888: p_count => x_msg_count,
889: p_data => x_msg_data,
890: p_encoded => FND_API.G_FALSE

Line 900: FND_MSG_PUB.Count_And_Get

896: END IF;
897: --
898: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
899: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
900: FND_MSG_PUB.Count_And_Get
901: (
902: p_count => x_msg_count,
903: p_data => x_msg_data,
904: p_encoded => FND_API.G_FALSE

Line 916: FND_MSG_PUB.Count_And_Get

912: WHEN OTHERS THEN
913: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
914: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
915: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
916: FND_MSG_PUB.Count_And_Get
917: (
918: p_count => x_msg_count,
919: p_data => x_msg_data,
920: p_encoded => FND_API.G_FALSE

Line 1042: FND_MSG_PUB.initialize;

1038: --
1039:
1040: IF FND_API.to_Boolean( p_init_msg_list )
1041: THEN
1042: FND_MSG_PUB.initialize;
1043: END IF;
1044: --
1045: --
1046: -- Initialize API return status to success

Line 1153: FND_MSG_PUB.Count_And_Get

1149: END IF;
1150: COMMIT WORK;
1151: END IF;
1152:
1153: FND_MSG_PUB.Count_And_Get
1154: (
1155: p_count => x_msg_count,
1156: p_data => x_msg_data
1157: );

Line 1167: FND_MSG_PUB.Count_And_Get

1163: EXCEPTION
1164: WHEN FND_API.G_EXC_ERROR THEN
1165: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1166: x_return_status := FND_API.G_RET_STS_ERROR ;
1167: FND_MSG_PUB.Count_And_Get
1168: (
1169: p_count => x_msg_count,
1170: p_data => x_msg_data,
1171: p_encoded => FND_API.G_FALSE

Line 1182: FND_MSG_PUB.Count_And_Get

1178: --
1179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1180: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1182: FND_MSG_PUB.Count_And_Get
1183: (
1184: p_count => x_msg_count,
1185: p_data => x_msg_data,
1186: p_encoded => FND_API.G_FALSE

Line 1196: FND_MSG_PUB.Count_And_Get

1192: END IF;
1193: --
1194: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1195: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1196: FND_MSG_PUB.Count_And_Get
1197: (
1198: p_count => x_msg_count,
1199: p_data => x_msg_data,
1200: p_encoded => FND_API.G_FALSE

Line 1212: FND_MSG_PUB.Count_And_Get

1208: WHEN OTHERS THEN
1209: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');
1210: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1212: FND_MSG_PUB.Count_And_Get
1213: (
1214: p_count => x_msg_count,
1215: p_data => x_msg_data,
1216: p_encoded => FND_API.G_FALSE

Line 1439: FND_MSG_PUB.initialize;

1435: --
1436: -- Initialize message list if p_init_msg_list is set to TRUE.
1437: IF FND_API.to_Boolean( p_init_msg_list )
1438: THEN
1439: FND_MSG_PUB.initialize;
1440: END IF;
1441: --
1442: --
1443: -- Initialize API return status to success

Line 1507: FND_MSG_PUB.Count_And_Get

1503: END IF;
1504: COMMIT WORK;
1505: END IF;
1506:
1507: FND_MSG_PUB.Count_And_Get
1508: (
1509: p_count => x_msg_count,
1510: p_data => x_msg_data
1511: );

Line 1521: FND_MSG_PUB.Count_And_Get

1517: EXCEPTION
1518: WHEN FND_API.G_EXC_ERROR THEN
1519: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1520: x_return_status := FND_API.G_RET_STS_ERROR ;
1521: FND_MSG_PUB.Count_And_Get
1522: (
1523: p_count => x_msg_count,
1524: p_data => x_msg_data,
1525: p_encoded => FND_API.G_FALSE

Line 1536: FND_MSG_PUB.Count_And_Get

1532: --
1533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1534: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1536: FND_MSG_PUB.Count_And_Get
1537: (
1538: p_count => x_msg_count,
1539: p_data => x_msg_data,
1540: p_encoded => FND_API.G_FALSE

Line 1551: FND_MSG_PUB.Count_And_Get

1547: END IF;
1548: --
1549: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1550: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1551: FND_MSG_PUB.Count_And_Get
1552: (
1553: p_count => x_msg_count,
1554: p_data => x_msg_data,
1555: p_encoded => FND_API.G_FALSE

Line 1567: FND_MSG_PUB.Count_And_Get

1563: WHEN OTHERS THEN
1564: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
1565: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;
1566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1567: FND_MSG_PUB.Count_And_Get
1568: (
1569: p_count => x_msg_count,
1570: p_data => x_msg_data,
1571: p_encoded => FND_API.G_FALSE

Line 1732: FND_MSG_PUB.Count_And_Get

1728:
1729: IF l_num_warning > 0 THEN
1730: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
1731: END IF;
1732: FND_MSG_PUB.Count_And_Get
1733: ( p_count => x_msg_count
1734: , p_data => x_msg_data
1735: );
1736:

Line 1745: FND_MSG_PUB.Count_And_Get

1741:
1742: EXCEPTION
1743: WHEN FND_API.G_EXC_ERROR THEN
1744: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_count => x_msg_count
1747: , p_data => x_msg_data
1748: );
1749: IF l_debug_on THEN

Line 1755: FND_MSG_PUB.Count_And_Get

1751: WSH_DEBUG_SV.pop(l_module_name);
1752: END IF;
1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1754: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1755: FND_MSG_PUB.Count_And_Get
1756: ( p_count => x_msg_count
1757: , p_data => x_msg_data
1758: );
1759: IF l_debug_on THEN

Line 1764: FND_MSG_PUB.Count_And_Get

1760: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1761: WSH_DEBUG_SV.pop(l_module_name);
1762: END IF;
1763: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1764: FND_MSG_PUB.Count_And_Get
1765: ( p_count => x_msg_count
1766: , p_data => x_msg_data
1767: );
1768: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1776: FND_MSG_PUB.Count_And_Get

1772: END IF;
1773: WHEN OTHERS THEN
1774: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1775: l_module_name);
1776: FND_MSG_PUB.Count_And_Get
1777: ( p_count => x_msg_count
1778: , p_data => x_msg_data
1779: );
1780:

Line 1924: FND_MSG_PUB.Count_And_Get

1920: END IF;
1921:
1922: x_return_status := l_return_status;
1923:
1924: FND_MSG_PUB.Count_And_Get
1925: ( p_count => x_msg_count
1926: , p_data => x_msg_data
1927: );
1928:

Line 1936: FND_MSG_PUB.Count_And_Get

1932:
1933: EXCEPTION
1934: WHEN FND_API.G_EXC_ERROR THEN
1935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1936: FND_MSG_PUB.Count_And_Get
1937: ( p_count => x_msg_count
1938: , p_data => x_msg_data
1939: );
1940: IF l_debug_on THEN

Line 1946: FND_MSG_PUB.Count_And_Get

1942: WSH_DEBUG_SV.pop(l_module_name);
1943: END IF;
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1946: FND_MSG_PUB.Count_And_Get
1947: ( p_count => x_msg_count
1948: , p_data => x_msg_data
1949: );
1950: IF l_debug_on THEN

Line 1955: FND_MSG_PUB.Count_And_Get

1951: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1952: WSH_DEBUG_SV.pop(l_module_name);
1953: END IF;
1954: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1955: FND_MSG_PUB.Count_And_Get
1956: ( p_count => x_msg_count
1957: , p_data => x_msg_data
1958: );
1959: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1967: FND_MSG_PUB.Count_And_Get

1963: END IF;
1964: WHEN OTHERS THEN
1965: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1966: l_module_name);
1967: FND_MSG_PUB.Count_And_Get
1968: ( p_count => x_msg_count
1969: , p_data => x_msg_data
1970: );
1971:

Line 2160: FND_MSG_PUB.Count_And_Get (

2156: IF l_num_warnings > 0 THEN
2157: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2158: END IF;
2159: --
2160: FND_MSG_PUB.Count_And_Get (
2161: p_count => x_msg_count,
2162: p_data => x_msg_data);
2163: --
2164: IF l_debug_on THEN

Line 2172: FND_MSG_PUB.Count_And_Get

2168: EXCEPTION
2169: WHEN FND_API.G_EXC_ERROR THEN
2170: ROLLBACK TO create_update_stop_wrap_grp;
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: FND_MSG_PUB.Count_And_Get
2173: (
2174: p_count => x_msg_count,
2175: p_data => x_msg_data,
2176: p_encoded => FND_API.G_FALSE

Line 2187: FND_MSG_PUB.Count_And_Get

2183: --
2184: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2185: ROLLBACK TO create_update_stop_wrap_grp;
2186: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2187: FND_MSG_PUB.Count_And_Get
2188: (
2189: p_count => x_msg_count,
2190: p_data => x_msg_data,
2191: p_encoded => FND_API.G_FALSE

Line 2201: FND_MSG_PUB.Count_And_Get

2197: END IF;
2198: --
2199: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2200: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2201: FND_MSG_PUB.Count_And_Get
2202: (
2203: p_count => x_msg_count,
2204: p_data => x_msg_data,
2205: p_encoded => FND_API.G_FALSE

Line 2216: FND_MSG_PUB.Count_And_Get

2212: WHEN OTHERS THEN
2213: ROLLBACK TO create_update_stop_wrap_grp;
2214: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2215: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
2216: FND_MSG_PUB.Count_And_Get
2217: (
2218: p_count => x_msg_count,
2219: p_data => x_msg_data,
2220: p_encoded => FND_API.G_FALSE

Line 2404: FND_MSG_PUB.Count_And_Get (

2400: IF l_num_warnings > 0 THEN
2401: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2402: END IF;
2403: --
2404: FND_MSG_PUB.Count_And_Get (
2405: p_count => x_msg_count,
2406: p_data => x_msg_data);
2407: --
2408: IF l_debug_on THEN

Line 2416: FND_MSG_PUB.Count_And_Get

2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN
2414: ROLLBACK TO create_update_trip_wrap_grp;
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2416: FND_MSG_PUB.Count_And_Get
2417: (
2418: p_count => x_msg_count,
2419: p_data => x_msg_data,
2420: p_encoded => FND_API.G_FALSE

Line 2431: FND_MSG_PUB.Count_And_Get

2427: --
2428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2429: ROLLBACK TO create_update_trip_wrap_grp;
2430: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2431: FND_MSG_PUB.Count_And_Get
2432: (
2433: p_count => x_msg_count,
2434: p_data => x_msg_data,
2435: p_encoded => FND_API.G_FALSE

Line 2445: FND_MSG_PUB.Count_And_Get

2441: END IF;
2442: --
2443: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2444: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2445: FND_MSG_PUB.Count_And_Get
2446: (
2447: p_count => x_msg_count,
2448: p_data => x_msg_data,
2449: p_encoded => FND_API.G_FALSE

Line 2460: FND_MSG_PUB.Count_And_Get

2456: WHEN OTHERS THEN
2457: ROLLBACK TO create_update_trip_wrap_grp;
2458: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2459: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
2460: FND_MSG_PUB.Count_And_Get
2461: (
2462: p_count => x_msg_count,
2463: p_data => x_msg_data,
2464: p_encoded => FND_API.G_FALSE

Line 2616: FND_MSG_PUB.Count_And_Get (

2612: IF l_num_warnings > 0 THEN
2613: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
2614: END IF;
2615: --
2616: FND_MSG_PUB.Count_And_Get (
2617: p_count => x_msg_count,
2618: p_data => x_msg_data);
2619: --
2620: IF l_debug_on THEN

Line 2628: FND_MSG_PUB.Count_And_Get

2624: EXCEPTION
2625: WHEN FND_API.G_EXC_ERROR THEN
2626: ROLLBACK TO Create_Update_Freight_Costs_WG;
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2628: FND_MSG_PUB.Count_And_Get
2629: (
2630: p_count => x_msg_count,
2631: p_data => x_msg_data,
2632: p_encoded => FND_API.G_FALSE

Line 2643: FND_MSG_PUB.Count_And_Get

2639: --
2640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2641: ROLLBACK TO Create_Update_Freight_Costs_WG;
2642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2643: FND_MSG_PUB.Count_And_Get
2644: (
2645: p_count => x_msg_count,
2646: p_data => x_msg_data,
2647: p_encoded => FND_API.G_FALSE

Line 2657: FND_MSG_PUB.Count_And_Get

2653: END IF;
2654: --
2655: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2656: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2657: FND_MSG_PUB.Count_And_Get
2658: (
2659: p_count => x_msg_count,
2660: p_data => x_msg_data,
2661: p_encoded => FND_API.G_FALSE

Line 2672: FND_MSG_PUB.Count_And_Get

2668: WHEN OTHERS THEN
2669: ROLLBACK TO Create_Update_Freight_Costs_WG;
2670: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2671: wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
2672: FND_MSG_PUB.Count_And_Get
2673: (
2674: p_count => x_msg_count,
2675: p_data => x_msg_data,
2676: p_encoded => FND_API.G_FALSE