DBA Data[Home] [Help]

APPS.WMS_UNLOAD_UTILS_PVT dependencies on FND_API

Line 246: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

242: , p_transaction_temp_id => l_temp_id
243: , p_quantity_to_delete => l_quantity
244: );
245:
246: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
247: IF (l_debug = 1) THEN
248: mydebug(' error returned from inv_mo_cancel_pvt.reduce_rsv_allocation');
249: mydebug(x_message);
250: END IF;

Line 252: RAISE fnd_api.g_exc_error;

248: mydebug(' error returned from inv_mo_cancel_pvt.reduce_rsv_allocation');
249: mydebug(x_message);
250: END IF;
251:
252: RAISE fnd_api.g_exc_error;
253: ELSE
254: IF (l_debug = 1) THEN
255: mydebug(' Successful from inv_mo_cancel_pvt.reduce_rsv_allocation Call');
256: END IF;

Line 531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

527: , p_temp_id
528: , l_allocate_lot_flag
529: , l_reserved_lot
530: , l_org_id);
531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
532: RAISE fnd_api.g_exc_error;
533: END IF;
534: END IF;
535: -- End changes for 14699845 (Flexible Lot Allocation)

Line 532: RAISE fnd_api.g_exc_error;

528: , l_allocate_lot_flag
529: , l_reserved_lot
530: , l_org_id);
531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
532: RAISE fnd_api.g_exc_error;
533: END IF;
534: END IF;
535: -- End changes for 14699845 (Flexible Lot Allocation)
536:

Line 556: , p_validation_level => fnd_api.g_valid_level_none

552:
553: wms_container_pvt.Modify_LPN
554: (
555: p_api_version => 1.0
556: , p_validation_level => fnd_api.g_valid_level_none
557: , x_return_status => l_return_status
558: , x_msg_count => l_msg_count
559: , x_msg_data => l_msg_data
560: , p_lpn => l_lpn

Line 637: , p_validation_level => fnd_api.g_valid_level_none

633:
634: wms_container_pvt.Modify_LPN
635: (
636: p_api_version => 1.0
637: , p_validation_level => fnd_api.g_valid_level_none
638: , x_return_status => l_return_status
639: , x_msg_count => l_msg_count
640: , x_msg_data => l_msg_data
641: , p_lpn => l_lpn

Line 659: , p_validation_level => fnd_api.g_valid_level_none

655:
656: wms_container_pvt.Modify_LPN
657: (
658: p_api_version => 1.0
659: , p_validation_level => fnd_api.g_valid_level_none
660: , x_return_status => l_return_status
661: , x_msg_count => l_msg_count
662: , x_msg_data => l_msg_data
663: , p_lpn => l_lpn

Line 697: , p_validation_level => fnd_api.g_valid_level_none

693:
694: wms_container_pvt.Modify_LPN
695: (
696: p_api_version => 1.0
697: , p_validation_level => fnd_api.g_valid_level_none
698: , x_return_status => l_return_status
699: , x_msg_count => l_msg_count
700: , x_msg_data => l_msg_data
701: , p_lpn => l_lpn

Line 959: x_return_status := fnd_api.g_ret_sts_success;

955: END IF;
956:
957: print_version_info;
958:
959: x_return_status := fnd_api.g_ret_sts_success;
960: x_next_temp_id := NULL;
961:
962: SAVEPOINT unload_bulk_sp;
963:

Line 1014: , p_validation_level => fnd_api.g_valid_level_none

1010:
1011: wms_container_pvt.Modify_LPN
1012: (
1013: p_api_version => 1.0
1014: , p_validation_level => fnd_api.g_valid_level_none
1015: , x_return_status => l_return_status
1016: , x_msg_count => l_msg_count
1017: , x_msg_data => l_msg_data
1018: , p_lpn => l_lpn

Line 1046: l_return_status := fnd_api.g_ret_sts_success;

1042: ', l_line_type: ' || l_line_type
1043: );
1044: END IF;
1045:
1046: l_return_status := fnd_api.g_ret_sts_success;
1047:
1048: IF l_line_type = 'CANCELLED'
1049: THEN
1050: inv_mo_cancel_pvt.reduce_rsv_allocation

Line 1068: IF (l_return_status <> fnd_api.g_ret_sts_success)

1064: , p_update_parent => TRUE
1065: );
1066: END IF;
1067:
1068: IF (l_return_status <> fnd_api.g_ret_sts_success)
1069: THEN
1070: IF (l_debug = 1) THEN
1071: mydebug('Error returned from API for deleting transaction');
1072: mydebug(l_msg_data);

Line 1075: RAISE fnd_api.g_exc_error;

1071: mydebug('Error returned from API for deleting transaction');
1072: mydebug(l_msg_data);
1073: END IF;
1074:
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: IF l_mo_line_id IS NOT NULL
1079: THEN

Line 1365: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1361: , l_allocate_lot_flag
1362: , l_reserved_lot
1363: , l_org_id
1364: , 'Y');
1365: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1366: RAISE fnd_api.g_exc_error;
1367: END IF;
1368: END IF;
1369: -- End changes for 14699845 (Flexible Lot Allocation)

Line 1366: RAISE fnd_api.g_exc_error;

1362: , l_reserved_lot
1363: , l_org_id
1364: , 'Y');
1365: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1366: RAISE fnd_api.g_exc_error;
1367: END IF;
1368: END IF;
1369: -- End changes for 14699845 (Flexible Lot Allocation)
1370: IF (l_debug = 1) THEN

Line 1421: , p_validation_level => fnd_api.g_valid_level_none

1417:
1418: wms_container_pvt.Modify_LPN
1419: (
1420: p_api_version => 1.0
1421: , p_validation_level => fnd_api.g_valid_level_none
1422: , x_return_status => l_return_status
1423: , x_msg_count => l_msg_count
1424: , x_msg_data => l_msg_data
1425: , p_lpn => l_lpn

Line 1452: x_return_status := fnd_api.g_ret_sts_error;

1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: ROLLBACK TO unload_bulk_sp;
1451:
1452: x_return_status := fnd_api.g_ret_sts_error;
1453:
1454: IF (l_debug = 1) THEN
1455: mydebug('Exception unload_bulk_task: ' || sqlerrm);
1456: END IF;

Line 1481: x_return_status := fnd_api.g_ret_sts_success;

1477: mydebug('FlexibleLotAlloc: p_org_id: '||p_org_id);
1478: mydebug('FlexibleLotAlloc: p_is_bulk_task: '||p_is_bulk_task);
1479: END IF;
1480:
1481: x_return_status := fnd_api.g_ret_sts_success;
1482:
1483: IF(p_allocate_lot_flag <> 'Y' AND p_reserved_lot IS NULL) THEN
1484: IF (p_is_bulk_task = 'Y') THEN
1485: DELETE FROM MTL_TRANSACTION_LOTS_TEMP

Line 1500: x_return_status := fnd_api.g_ret_sts_error;

1496: END IF;
1497:
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: x_return_status := fnd_api.g_ret_sts_error;
1501: END;
1502:
1503: -- Not Used Yet
1504: /*

Line 1517: x_return_status := fnd_api.g_ret_sts_success;

1513: IS
1514: l_reserved_lot VARCHAR2(80);
1515: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1516: BEGIN
1517: x_return_status := fnd_api.g_ret_sts_success;
1518: BEGIN
1519:
1520: IF ( l_debug = 1 ) THEN
1521: mydebug('FlexibleLotAlloc: In get_allocation_params: ');

Line 1558: x_return_status := fnd_api.g_ret_sts_error;

1554: x_allocate_serial_flag:= 'N';
1555: END IF;
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: x_return_status := fnd_api.g_ret_sts_error;
1559:
1560: END get_allocation_params;*/
1561: -- End Changes for 14699845 (Flexible Lot Allocation)
1562: END WMS_UNLOAD_UTILS_PVT;