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.INV_MATERIAL_STATUS_GRP dependencies on FND_API

Line 607: x_return_status := fnd_api.g_ret_sts_success ;

603: IF p_status_id is null or p_transaction_type_id is null THEN
604: RETURN 'Y';
605: END IF;
606:
607: x_return_status := fnd_api.g_ret_sts_success ;
608:
609: IF p_status_id <> nvl(g_status_id,-9999) OR
610: p_transaction_type_id <> nvl(g_transaction_type_id,-9999) THEN
611: select is_allowed

Line 639: x_return_status := fnd_api.g_ret_sts_unexp_error ;

635: g_is_allowed := 'Y'; --Added as it was not being set for exception case Bug#6633612
636: return 'Y';
637:
638: when others then
639: x_return_status := fnd_api.g_ret_sts_unexp_error ;
640:
641: if (fnd_msg_pub.check_msg_level
642: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
643: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

Line 698: x_return_status := fnd_api.g_ret_sts_success ;

694: , x_default_serial_status_id OUT NOCOPY NUMBER
695: ) IS
696: c_api_name varchar2(30) := 'get_lot_serial_status_control';
697: BEGIN
698: x_return_status := fnd_api.g_ret_sts_success ;
699:
700: IF p_organization_id <> nvl(g_organization_id,-9999) OR
701: p_inventory_item_id <> nvl(g_inventory_item_id,-9999) THEN
702:

Line 731: x_return_status := fnd_api.g_ret_sts_unexp_error ;

727: x_default_serial_status_id := g_default_serial_status_id;
728:
729: exception
730: when others then
731: x_return_status := fnd_api.g_ret_sts_unexp_error ;
732:
733: if (fnd_msg_pub.check_msg_level
734: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
735: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

Line 821: --l_old_item_id NUMBER := FND_API.g_miss_num;

817: l_pending_eres_chk NUMBER :=0;
818: l_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('EDR_ERES_ENABLED'), 'N');
819: g_eres_enabled VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_DEF_ERES_ENABLED'), 'N');
820: -- New variables for MACD Validations
821: --l_old_item_id NUMBER := FND_API.g_miss_num;
822: l_item_trackable VARCHAR2(1) := 'N';
823: l_freeze_flag VARCHAR2(1) := NULL;
824: l_trx_action_id NUMBER;
825: l_trx_source_type NUMBER;

Line 906: g_transaction_action_id := FND_API.g_miss_num;

902: g_transaction_source_type_id := NULL;
903: END IF;
904: EXCEPTION
905: WHEN others THEN
906: g_transaction_action_id := FND_API.g_miss_num;
907: g_transaction_source_type_id := FND_API.g_miss_num;
908: END;
909:
910: -- Check to see if IB is active Only run this 1 time per session

Line 907: g_transaction_source_type_id := FND_API.g_miss_num;

903: END IF;
904: EXCEPTION
905: WHEN others THEN
906: g_transaction_action_id := FND_API.g_miss_num;
907: g_transaction_source_type_id := FND_API.g_miss_num;
908: END;
909:
910: -- Check to see if IB is active Only run this 1 time per session
911:

Line 2029: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

2025: END is_status_applicable;
2026:
2027: PROCEDURE update_status
2028: ( p_api_version_number IN NUMBER
2029: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
2030: , x_return_status OUT NOCOPY VARCHAR2
2031: , x_msg_count OUT NOCOPY NUMBER
2032: , x_msg_data OUT NOCOPY VARCHAR2
2033: , p_update_method IN NUMBER

Line 2049: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2045: , p_initial_status_flag IN VARCHAR2:='N' -- Onhand Material Status Support
2046: ) IS
2047: l_api_version_number CONSTANT NUMBER := 1.0;
2048: l_api_name CONSTANT VARCHAR2(30) := 'update_status';
2049: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2050: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
2051: BEGIN
2052: --
2053: -- Standard call to check for call compatibility

Line 2054: IF NOT fnd_api.compatible_api_call(l_api_version_number

2050: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
2051: BEGIN
2052: --
2053: -- Standard call to check for call compatibility
2054: IF NOT fnd_api.compatible_api_call(l_api_version_number
2055: , p_api_version_number
2056: , l_api_name
2057: , G_PKG_NAME
2058: ) THEN

Line 2059: RAISE fnd_api.g_exc_unexpected_error;

2055: , p_api_version_number
2056: , l_api_name
2057: , G_PKG_NAME
2058: ) THEN
2059: RAISE fnd_api.g_exc_unexpected_error;
2060: END IF;
2061: --
2062: -- Initialize message list.
2063: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 2063: IF fnd_api.to_boolean(p_init_msg_lst) THEN

2059: RAISE fnd_api.g_exc_unexpected_error;
2060: END IF;
2061: --
2062: -- Initialize message list.
2063: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2064: fnd_msg_pub.initialize;
2065: END IF;
2066:
2067: l_status_rec.organization_id := p_organization_id;

Line 2546: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

2542: l_update_method NUMBER := 2;
2543: l_api_version_number NUMBER := 1.0;
2544: l_init_msg_lst VARCHAR2(5) := 'F';
2545: l_initial_Status_Flag VARCHAR2(4) := 'Y';
2546: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2547: l_msg_count NUMBER;
2548: l_msg_data VARCHAR2(240);
2549:
2550: BEGIN

Line 2567: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2563: ,p_inventory_item_id ,p_sub_code ,p_loc_id ,p_lot_number
2564: ,NULL ,NULL ,'Q' ,NULL ,p_lpn_id, l_initial_status_flag);
2565: end if;
2566:
2567: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2568: RAISE fnd_api.g_exc_unexpected_error;
2569: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2570: RAISE fnd_api.g_exc_error;
2571: END IF;

Line 2568: RAISE fnd_api.g_exc_unexpected_error;

2564: ,NULL ,NULL ,'Q' ,NULL ,p_lpn_id, l_initial_status_flag);
2565: end if;
2566:
2567: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2568: RAISE fnd_api.g_exc_unexpected_error;
2569: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2570: RAISE fnd_api.g_exc_error;
2571: END IF;
2572:

Line 2569: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

2565: end if;
2566:
2567: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2568: RAISE fnd_api.g_exc_unexpected_error;
2569: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2570: RAISE fnd_api.g_exc_error;
2571: END IF;
2572:
2573: EXCEPTION

Line 2570: RAISE fnd_api.g_exc_error;

2566:
2567: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2568: RAISE fnd_api.g_exc_unexpected_error;
2569: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2570: RAISE fnd_api.g_exc_error;
2571: END IF;
2572:
2573: EXCEPTION
2574:

Line 2858: x_return_status := fnd_api.g_ret_sts_success ;

2854: l_msg_data VARCHAR2(2000);
2855: l_revision_control BOOLEAN;
2856: l_serial_control BOOLEAN;
2857: BEGIN
2858: x_return_status := fnd_api.g_ret_sts_success ;
2859: x_post_action := 'N' ;
2860: --First get the value of move different status parameter.
2861: --Printing all input parameters to debug file
2862:

Line 3177: RAISE fnd_api.g_exc_error;

3173: IF l_return_status <> 'S' THEN
3174: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
3175: FND_MESSAGE.set_token('token1','XACT_QTY1');
3176: fnd_msg_pub.ADD;
3177: RAISE fnd_api.g_exc_error;
3178: END IF;
3179:
3180: IF (g_debug = 1) then
3181: inv_trx_util_pub.TRACE('l_qoh: '||l_qoh, 'INV_MATERIAL_STATUS_GRP', 9);

Line 3210: RAISE fnd_api.g_exc_error;

3206: end if ;
3207:
3208: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');
3209: fnd_msg_pub.ADD;
3210: RAISE fnd_api.g_exc_error;
3211: END IF ;
3212: END IF ;--Second if
3213:
3214: END IF ; --First if

Line 3216: WHEN fnd_api.g_exc_error THEN

3212: END IF ;--Second if
3213:
3214: END IF ; --First if
3215: EXCEPTION
3216: WHEN fnd_api.g_exc_error THEN
3217: x_return_status := fnd_api.g_ret_sts_error;
3218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3219: WHEN OTHERS THEN
3220: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3217: x_return_status := fnd_api.g_ret_sts_error;

3213:
3214: END IF ; --First if
3215: EXCEPTION
3216: WHEN fnd_api.g_exc_error THEN
3217: x_return_status := fnd_api.g_ret_sts_error;
3218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3219: WHEN OTHERS THEN
3220: x_return_status := fnd_api.g_ret_sts_unexp_error;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3220: x_return_status := fnd_api.g_ret_sts_unexp_error;

3216: WHEN fnd_api.g_exc_error THEN
3217: x_return_status := fnd_api.g_ret_sts_error;
3218: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3219: WHEN OTHERS THEN
3220: x_return_status := fnd_api.g_ret_sts_unexp_error;
3221: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3222: END check_move_diff_status;
3223:
3224: --adding following procedure for lpn status project to get the lpn status

Line 3616: RAISE fnd_api.g_exc_error;

3612: IF(g_debug = 1)THEN
3613: inv_trx_util_pub.TRACE('Status_Commingle_Check: More than one status for the comming material: ', 1);
3614: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);
3615: END IF;
3616: RAISE fnd_api.g_exc_error;
3617: WHEN OTHERS THEN
3618: l_progress := 'WMSSCC-0003';
3619: l_source_status_id := null;
3620: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);

Line 3621: RAISE fnd_api.g_exc_error;

3617: WHEN OTHERS THEN
3618: l_progress := 'WMSSCC-0003';
3619: l_source_status_id := null;
3620: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);
3621: RAISE fnd_api.g_exc_error;
3622: END;
3623:
3624: IF l_source_status_id <> -9999 and p_item_id is not null THEN
3625: BEGIN

Line 3700: RAISE fnd_api.g_exc_error;

3696: WHEN OTHERS THEN
3697: IF(g_debug = 1)THEN
3698: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);
3699: END IF;
3700: RAISE fnd_api.g_exc_error;
3701: END Status_Commingle_Check;
3702:
3703:
3704: FUNCTION is_trx_allow_lpns(

Line 3847: RAISE fnd_api.g_exc_unexpected_error;

3843: WHEN NO_DATA_FOUND THEN
3844: IF(g_debug = 1)THEN
3845: inv_trx_util_pub.TRACE('Unable to find the LPN -- Error occured');
3846: END IF;
3847: RAISE fnd_api.g_exc_unexpected_error;
3848:
3849: END;
3850:
3851: IF(g_debug = 1)THEN

Line 3992: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3988: ,x_return_status => l_trx_allowed
3989: ,x_msg_count => l_msg_count
3990: ,x_msg_data => l_msg_data);
3991:
3992: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3993: RAISE fnd_api.g_exc_unexpected_error;
3994: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: END IF;

Line 3993: RAISE fnd_api.g_exc_unexpected_error;

3989: ,x_msg_count => l_msg_count
3990: ,x_msg_data => l_msg_data);
3991:
3992: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3993: RAISE fnd_api.g_exc_unexpected_error;
3994: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: END IF;
3997:

Line 3994: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3990: ,x_msg_data => l_msg_data);
3991:
3992: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3993: RAISE fnd_api.g_exc_unexpected_error;
3994: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: END IF;
3997:
3998: IF l_trx_allowed='N' THEN

Line 3995: RAISE fnd_api.g_exc_error;

3991:
3992: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3993: RAISE fnd_api.g_exc_unexpected_error;
3994: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3995: RAISE fnd_api.g_exc_error;
3996: END IF;
3997:
3998: IF l_trx_allowed='N' THEN
3999: l_trx_allowed_count := l_trx_allowed_count+1;