113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115: --
116: IF FND_API.to_Boolean(p_init_msg_list) THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119: --
120: --
121:
326: IF FND_API.To_Boolean( p_commit ) THEN
327: commit;
328: END IF;
329:
330: FND_MSG_PUB.Count_And_Get (
331: p_count => x_msg_count,
332: p_data => x_msg_data,
333: p_encoded => FND_API.G_FALSE);
334: --
342: G_CALLBACK_REQUIRED := 'Y';
343: g_caller := NULL;
344: --g_update_to_container := 'N';
345: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
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
359: g_caller := NULL;
360: --g_update_to_container := 'N';
361: ROLLBACK TO create_update_WSHWLGPB;
362: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
363: FND_MSG_PUB.Count_And_Get
364: (
365: p_count => x_msg_count,
366: p_data => x_msg_data,
367: p_encoded => FND_API.G_FALSE
378: --g_update_to_container := 'N';
379: ROLLBACK TO create_update_WSHWLGPB;
380: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
381:
382: FND_MSG_PUB.Count_And_Get
383: (
384: p_count => x_msg_count,
385: p_data => x_msg_data,
386: p_encoded => FND_API.G_FALSE
397: g_caller := NULL;
398: --g_update_to_container := 'N';
399: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
400: --
401: FND_MSG_PUB.Count_And_Get
402: (
403: p_count => x_msg_count,
404: p_data => x_msg_data,
405: p_encoded => FND_API.G_FALSE
417: --g_update_to_container := 'N';
418: ROLLBACK TO create_update_WSHWLGPB;
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
420: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.create_update_containers');
421: FND_MSG_PUB.Count_And_Get
422: (
423: p_count => x_msg_count,
424: p_data => x_msg_data,
425: p_encoded => FND_API.G_FALSE
888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
889: END IF;
890: --
891: IF FND_API.to_Boolean(p_init_msg_list) THEN
892: FND_MSG_PUB.initialize;
893: END IF;
894: --
895:
896: IF p_action_prms.caller IS NULL THEN
1423: IF FND_API.To_Boolean( p_commit ) THEN
1424: commit;
1425: END IF;
1426:
1427: FND_MSG_PUB.Count_And_Get (
1428: p_count => x_msg_count,
1429: p_data => x_msg_data,
1430: p_encoded => FND_API.G_FALSE);
1431:
1446: WHEN FND_API.G_EXC_ERROR THEN
1447: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;
1448: g_callback_required := 'N';
1449: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1450: FND_MSG_PUB.Count_And_Get
1451: (
1452: p_count => x_msg_count,
1453: p_data => x_msg_data,
1454: p_encoded => FND_API.G_FALSE
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO DEL_DETAIL_ACTION_WMS_GRP;
1467: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1468:
1469: FND_MSG_PUB.Count_And_Get
1470: (
1471: p_count => x_msg_count,
1472: p_data => x_msg_data,
1473: p_encoded => FND_API.G_FALSE
1514:
1515: --}
1516: END IF;
1517: --
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
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613: END IF;
1614: --
1615: IF FND_API.to_Boolean(p_init_msg_list) THEN
1616: FND_MSG_PUB.initialize;
1617: END IF;
1618: --
1619: IF l_debug_on THEN
1620: --
1701: END IF; --}
1702:
1703: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1704:
1705: FND_MSG_PUB.Count_And_Get (
1706: p_count => x_msg_count,
1707: p_data => x_msg_data,
1708: p_encoded => FND_API.G_FALSE);
1709: --
1717: ROLLBACK TO check_purge_WSHWLGPB;
1718: --p_lpn_rec.lpn_ids.DELETE;
1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1720: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.check_purge');
1721: FND_MSG_PUB.Count_And_Get
1722: (
1723: p_count => x_msg_count,
1724: p_data => x_msg_data,
1725: p_encoded => FND_API.G_FALSE