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.47.12010000.1 2008/07/25 10:31:25 appldev 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.47.12010000.1 2008/07/25 10:31:25 appldev ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_transactions_PVT';
5:
6: /*
7: REM *********************************************************************
8: REM *

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

1125: || l_mmli_tbl (i).transaction_quantity);
1126: END IF;
1127: /* Bug 4929610 added lot expiry check */
1128: IF (x_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue) THEN
1129: IF (gme_transactions_pvt.is_lot_expired (p_organization_id => x_mmti_rec.organization_id,
1130: p_inventory_item_id => x_mmti_rec.inventory_item_id,
1131: p_lot_number => l_mmli_tbl(i).lot_number,
1132: p_date => x_mmti_rec.transaction_date)) THEN
1133: RAISE lot_expired_err;

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

2704:
2705: /* Bug 5358129 for ingredients lots should exist */
2706: 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
2707: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP
2708: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => l_mmti_rec.organization_id,
2709: p_inventory_item_id => l_mmti_rec.inventory_item_id,
2710: p_lot_number => get_lots.lot_number,
2711: x_return_status => l_return_status);
2712: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 2824: gme_transactions_pvt.gme_txn_message

2820: WHEN lot_val_err THEN
2821: x_return_status := l_return_status;
2822: WHEN fnd_api.g_exc_error THEN
2823: x_return_status := fnd_api.g_ret_sts_error;
2824: gme_transactions_pvt.gme_txn_message
2825: (p_api_name => l_api_name
2826: ,p_transaction_interface_id => p_transaction_interface_id
2827: );
2828: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2843: gme_transactions_pvt.gme_txn_message

2839: || 'WHEN OTHERS:'
2840: || SQLERRM);
2841: END IF;
2842:
2843: gme_transactions_pvt.gme_txn_message
2844: (p_api_name => l_api_name
2845: ,p_transaction_interface_id => p_transaction_interface_id
2846: );
2847:

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

4850:
4851: /* Bug 5358129 for ingredients lots should exist */
4852: 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
4853: FOR i IN 1..p_mmli_tbl.COUNT LOOP
4854: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => p_mmti_rec.organization_id,
4855: p_inventory_item_id => p_mmti_rec.inventory_item_id,
4856: p_lot_number => p_mmli_tbl(i).lot_number,
4857: x_return_status => l_return_status);
4858: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

Line 4930: END gme_transactions_pvt;

4926: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4927: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4928: END IF;
4929: END gmo_pre_process_val;
4930: END gme_transactions_pvt;