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 593: x_return_status := fnd_api.g_ret_sts_success ;

589: IF p_status_id is null or p_transaction_type_id is null THEN
590: RETURN 'Y';
591: END IF;
592:
593: x_return_status := fnd_api.g_ret_sts_success ;
594:
595: IF p_status_id <> nvl(g_status_id,-9999) OR
596: p_transaction_type_id <> nvl(g_transaction_type_id,-9999) THEN
597: select is_allowed

Line 625: x_return_status := fnd_api.g_ret_sts_unexp_error ;

621: g_is_allowed := 'Y'; --Added as it was not being set for exception case Bug#6633612
622: return 'Y';
623:
624: when others then
625: x_return_status := fnd_api.g_ret_sts_unexp_error ;
626:
627: if (fnd_msg_pub.check_msg_level
628: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
629: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

Line 684: x_return_status := fnd_api.g_ret_sts_success ;

680: , x_default_serial_status_id OUT NOCOPY NUMBER
681: ) IS
682: c_api_name varchar2(30) := 'get_lot_serial_status_control';
683: BEGIN
684: x_return_status := fnd_api.g_ret_sts_success ;
685:
686: IF p_organization_id <> nvl(g_organization_id,-9999) OR
687: p_inventory_item_id <> nvl(g_inventory_item_id,-9999) THEN
688:

Line 717: x_return_status := fnd_api.g_ret_sts_unexp_error ;

713: x_default_serial_status_id := g_default_serial_status_id;
714:
715: exception
716: when others then
717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: if (fnd_msg_pub.check_msg_level
720: (fnd_msg_pub.g_msg_lvl_unexp_error)) then
721: fnd_msg_pub.add_exc_msg(g_pkg_name, c_api_name);

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

798: l_default_serial_status_id number;
799: l_wms_installed varchar2(30);
800:
801: -- New variables for MACD Validations
802: --l_old_item_id NUMBER := FND_API.g_miss_num;
803: l_item_trackable VARCHAR2(1) := 'N';
804: l_freeze_flag VARCHAR2(1) := NULL;
805: l_trx_action_id NUMBER;
806: l_trx_source_type NUMBER;

Line 884: g_transaction_action_id := FND_API.g_miss_num;

880: g_transaction_source_type_id := NULL;
881: END IF;
882: EXCEPTION
883: WHEN others THEN
884: g_transaction_action_id := FND_API.g_miss_num;
885: g_transaction_source_type_id := FND_API.g_miss_num;
886: END;
887:
888: -- Check to see if IB is active Only run this 1 time per session

Line 885: g_transaction_source_type_id := FND_API.g_miss_num;

881: END IF;
882: EXCEPTION
883: WHEN others THEN
884: g_transaction_action_id := FND_API.g_miss_num;
885: g_transaction_source_type_id := FND_API.g_miss_num;
886: END;
887:
888: -- Check to see if IB is active Only run this 1 time per session
889:

Line 1641: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1637: END is_status_applicable;
1638:
1639: PROCEDURE update_status
1640: ( p_api_version_number IN NUMBER
1641: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1642: , x_return_status OUT NOCOPY VARCHAR2
1643: , x_msg_count OUT NOCOPY NUMBER
1644: , x_msg_data OUT NOCOPY VARCHAR2
1645: , p_update_method IN NUMBER

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

1657: , p_initial_status_flag IN VARCHAR2:='N' -- Onhand Material Status Support
1658: ) IS
1659: l_api_version_number CONSTANT NUMBER := 1.0;
1660: l_api_name CONSTANT VARCHAR2(30) := 'update_status';
1661: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1662: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
1663: BEGIN
1664: --
1665: -- Standard call to check for call compatibility

Line 1666: IF NOT fnd_api.compatible_api_call(l_api_version_number

1662: l_status_rec INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type;
1663: BEGIN
1664: --
1665: -- Standard call to check for call compatibility
1666: IF NOT fnd_api.compatible_api_call(l_api_version_number
1667: , p_api_version_number
1668: , l_api_name
1669: , G_PKG_NAME
1670: ) THEN

Line 1671: RAISE fnd_api.g_exc_unexpected_error;

1667: , p_api_version_number
1668: , l_api_name
1669: , G_PKG_NAME
1670: ) THEN
1671: RAISE fnd_api.g_exc_unexpected_error;
1672: END IF;
1673: --
1674: -- Initialize message list.
1675: IF fnd_api.to_boolean(p_init_msg_lst) THEN

Line 1675: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1671: RAISE fnd_api.g_exc_unexpected_error;
1672: END IF;
1673: --
1674: -- Initialize message list.
1675: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1676: fnd_msg_pub.initialize;
1677: END IF;
1678:
1679: l_status_rec.organization_id := p_organization_id;

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

2036: l_update_method NUMBER := 2;
2037: l_api_version_number NUMBER := 1.0;
2038: l_init_msg_lst VARCHAR2(5) := 'F';
2039: l_initial_Status_Flag VARCHAR2(4) := 'Y';
2040: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2041: l_msg_count NUMBER;
2042: l_msg_data VARCHAR2(240);
2043:
2044: BEGIN

Line 2061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2057: ,p_inventory_item_id ,p_sub_code ,p_loc_id ,p_lot_number
2058: ,NULL ,NULL ,'Q' ,NULL ,p_lpn_id, l_initial_status_flag);
2059: end if;
2060:
2061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2062: RAISE fnd_api.g_exc_unexpected_error;
2063: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2064: RAISE fnd_api.g_exc_error;
2065: END IF;

Line 2062: RAISE fnd_api.g_exc_unexpected_error;

2058: ,NULL ,NULL ,'Q' ,NULL ,p_lpn_id, l_initial_status_flag);
2059: end if;
2060:
2061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2062: RAISE fnd_api.g_exc_unexpected_error;
2063: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2064: RAISE fnd_api.g_exc_error;
2065: END IF;
2066:

Line 2063: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

2059: end if;
2060:
2061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2062: RAISE fnd_api.g_exc_unexpected_error;
2063: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2064: RAISE fnd_api.g_exc_error;
2065: END IF;
2066:
2067: EXCEPTION

Line 2064: RAISE fnd_api.g_exc_error;

2060:
2061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2062: RAISE fnd_api.g_exc_unexpected_error;
2063: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2064: RAISE fnd_api.g_exc_error;
2065: END IF;
2066:
2067: EXCEPTION
2068:

Line 2351: x_return_status := fnd_api.g_ret_sts_success ;

2347: l_msg_data VARCHAR2(2000);
2348: l_revision_control BOOLEAN;
2349: l_serial_control BOOLEAN;
2350: BEGIN
2351: x_return_status := fnd_api.g_ret_sts_success ;
2352: x_post_action := 'N' ;
2353: --First get the value of move different status parameter.
2354: --Printing all input parameters to debug file
2355:

Line 2656: RAISE fnd_api.g_exc_error;

2652: IF l_return_status <> 'S' THEN
2653: FND_MESSAGE.set_name('INV','INV_INTERNAL_ERROR');
2654: FND_MESSAGE.set_token('token1','XACT_QTY1');
2655: fnd_msg_pub.ADD;
2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2658:
2659: IF nvl(l_qoh,0) = 0 THEN
2660: l_go := TRUE;

Line 2679: RAISE fnd_api.g_exc_error;

2675: end if ;
2676:
2677: fnd_message.set_name('INV','INV_TXF_MOVE_DIFF_MAT_STAT');
2678: fnd_msg_pub.ADD;
2679: RAISE fnd_api.g_exc_error;
2680: END IF ;
2681: END IF ;--Second if
2682:
2683: END IF ; --First if

Line 2685: WHEN fnd_api.g_exc_error THEN

2681: END IF ;--Second if
2682:
2683: END IF ; --First if
2684: EXCEPTION
2685: WHEN fnd_api.g_exc_error THEN
2686: x_return_status := fnd_api.g_ret_sts_error;
2687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2688: WHEN OTHERS THEN
2689: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2686: x_return_status := fnd_api.g_ret_sts_error;

2682:
2683: END IF ; --First if
2684: EXCEPTION
2685: WHEN fnd_api.g_exc_error THEN
2686: x_return_status := fnd_api.g_ret_sts_error;
2687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2688: WHEN OTHERS THEN
2689: x_return_status := fnd_api.g_ret_sts_unexp_error;
2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2689: x_return_status := fnd_api.g_ret_sts_unexp_error;

2685: WHEN fnd_api.g_exc_error THEN
2686: x_return_status := fnd_api.g_ret_sts_error;
2687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2688: WHEN OTHERS THEN
2689: x_return_status := fnd_api.g_ret_sts_unexp_error;
2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2691: END check_move_diff_status;
2692:
2693: --adding following procedure for lpn status project to get the lpn status

Line 3085: RAISE fnd_api.g_exc_error;

3081: IF(g_debug = 1)THEN
3082: inv_trx_util_pub.TRACE('Status_Commingle_Check: More than one status for the comming material: ', 1);
3083: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);
3084: END IF;
3085: RAISE fnd_api.g_exc_error;
3086: WHEN OTHERS THEN
3087: l_progress := 'WMSSCC-0003';
3088: l_source_status_id := null;
3089: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);

Line 3090: RAISE fnd_api.g_exc_error;

3086: WHEN OTHERS THEN
3087: l_progress := 'WMSSCC-0003';
3088: l_source_status_id := null;
3089: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);
3090: RAISE fnd_api.g_exc_error;
3091: END;
3092:
3093: IF l_source_status_id <> -9999 and p_item_id is not null THEN
3094: BEGIN

Line 3169: RAISE fnd_api.g_exc_error;

3165: WHEN OTHERS THEN
3166: IF(g_debug = 1)THEN
3167: inv_trx_util_pub.TRACE('l_progress: '|| l_progress,1);
3168: END IF;
3169: RAISE fnd_api.g_exc_error;
3170: END Status_Commingle_Check;
3171:
3172:
3173: FUNCTION is_trx_allow_lpns(

Line 3311: RAISE fnd_api.g_exc_unexpected_error;

3307: WHEN NO_DATA_FOUND THEN
3308: IF(g_debug = 1)THEN
3309: inv_trx_util_pub.TRACE('Unable to find the LPN -- Error occured');
3310: END IF;
3311: RAISE fnd_api.g_exc_unexpected_error;
3312:
3313: END;
3314:
3315: IF(g_debug = 1)THEN

Line 3456: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3452: ,x_return_status => l_trx_allowed
3453: ,x_msg_count => l_msg_count
3454: ,x_msg_data => l_msg_data);
3455:
3456: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3457: RAISE fnd_api.g_exc_unexpected_error;
3458: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3459: RAISE fnd_api.g_exc_error;
3460: END IF;

Line 3457: RAISE fnd_api.g_exc_unexpected_error;

3453: ,x_msg_count => l_msg_count
3454: ,x_msg_data => l_msg_data);
3455:
3456: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3457: RAISE fnd_api.g_exc_unexpected_error;
3458: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3459: RAISE fnd_api.g_exc_error;
3460: END IF;
3461:

Line 3458: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

3454: ,x_msg_data => l_msg_data);
3455:
3456: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3457: RAISE fnd_api.g_exc_unexpected_error;
3458: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3459: RAISE fnd_api.g_exc_error;
3460: END IF;
3461:
3462: IF l_trx_allowed='N' THEN

Line 3459: RAISE fnd_api.g_exc_error;

3455:
3456: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3457: RAISE fnd_api.g_exc_unexpected_error;
3458: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
3459: RAISE fnd_api.g_exc_error;
3460: END IF;
3461:
3462: IF l_trx_allowed='N' THEN
3463: l_trx_allowed_count := l_trx_allowed_count+1;