APPS.GME_TRANSACTIONS_PVT dependencies on GME_TRANSACTIONS_PVT

Line 1: PACKAGE BODY gme_transactions_pvt AS

1: PACKAGE BODY gme_transactions_pvt AS
2: /* $Header: GMEVPTXB.pls 120.69.12020000.8 2013/02/06 19:06:52 gmurator ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_transactions_PVT';
5: /*

Line 4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_transactions_PVT';

1: PACKAGE BODY gme_transactions_pvt AS
2: /* $Header: GMEVPTXB.pls 120.69.12020000.8 2013/02/06 19:06:52 gmurator ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_transactions_PVT';
5: /*
6: REM *********************************************************************
7: REM *
8: REM * FILE: GMEVPTXB.pls

Line 1692: IF (gme_transactions_pvt.is_lot_expired (p_organization_id => x_mmti_rec.organization_id,

1688: || l_mmli_tbl (i).transaction_quantity);
1689: END IF;
1690: /* Bug 4929610 added lot expiry check */
1691: IF (x_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue) THEN
1692: IF (gme_transactions_pvt.is_lot_expired (p_organization_id => x_mmti_rec.organization_id,
1693: p_inventory_item_id => x_mmti_rec.inventory_item_id,
1694: p_lot_number => l_mmli_tbl(i).lot_number,
1695: p_date => x_mmti_rec.transaction_date)) THEN
1696: RAISE lot_expired_err;

Line 3561: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => l_mmti_rec.organization_id,

3557:
3558: /* Bug 5358129 for ingredients lots should exist */
3559: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN
3560: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP
3561: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => l_mmti_rec.organization_id,
3562: p_inventory_item_id => l_mmti_rec.inventory_item_id,
3563: p_lot_number => get_lots.lot_number,
3564: x_return_status => l_return_status);
3565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 3677: gme_transactions_pvt.gme_txn_message

3673: WHEN lot_val_err THEN
3674: x_return_status := l_return_status;
3675: WHEN fnd_api.g_exc_error THEN
3676: x_return_status := fnd_api.g_ret_sts_error;
3677: gme_transactions_pvt.gme_txn_message
3678: (p_api_name => l_api_name
3679: ,p_transaction_interface_id => p_transaction_interface_id
3680: );
3681: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3696: gme_transactions_pvt.gme_txn_message

3692: || 'WHEN OTHERS:'
3693: || SQLERRM);
3694: END IF;
3695:
3696: gme_transactions_pvt.gme_txn_message
3697: (p_api_name => l_api_name
3698: ,p_transaction_interface_id => p_transaction_interface_id
3699: );
3700:

Line 5902: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => p_mmti_rec.organization_id,

5898:
5899: /* Bug 5358129 for ingredients lots should exist */
5900: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN
5901: FOR i IN 1..p_mmli_tbl.COUNT LOOP
5902: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => p_mmti_rec.organization_id,
5903: p_inventory_item_id => p_mmti_rec.inventory_item_id,
5904: p_lot_number => p_mmli_tbl(i).lot_number,
5905: x_return_status => l_return_status);
5906: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 5978: END gme_transactions_pvt;

5974: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5975: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5976: END IF;
5977: END gmo_pre_process_val;
5978: END gme_transactions_pvt;
5979: