[Home] [Help]
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
56: l_mat_dtl_rec gme_material_details%ROWTYPE;
57: m_mat_dtl_rec gme_material_details%ROWTYPE;
58: l_ret NUMBER;
59: l_api_version NUMBER;
60: l_msg_count NUMBER;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
56: l_mat_dtl_rec gme_material_details%ROWTYPE;
57: m_mat_dtl_rec gme_material_details%ROWTYPE;
58: l_ret NUMBER;
59: l_api_version NUMBER;
60: l_msg_count NUMBER;
61: l_msg_data VARCHAR2 (2000);
78: l_mmli_tbl := p_mmli_tbl;
79: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
80:
81: -- Now fetch the material detials for the mateiral
82: IF NOT gme_material_details_dbl.fetch_row
83: (p_material_detail => l_mat_dtl_rec
84: ,x_material_detail => l_mat_dtl_rec) THEN
85: RAISE fnd_api.g_exc_error;
86: END IF;
163: || l_mmti_rec.transaction_type_id);
164: END IF;
165:
166: -- Now fetch the material detials for the phantom line
167: IF NOT gme_material_details_dbl.fetch_row
168: (p_material_detail => m_mat_dtl_rec
169: ,x_material_detail => m_mat_dtl_rec) THEN
170: RAISE fnd_api.g_exc_error;
171: END IF;
423: l_mmt_rec mtl_material_transactions%ROWTYPE;
424: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
425: l_mmti_rec mtl_transactions_interface%ROWTYPE;
426: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
427: l_mat_dtl_rec gme_material_details%ROWTYPE;
428: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
429: create_material_txn_err EXCEPTION;
430: delete_material_txn_err EXCEPTION;
431: BEGIN
542: l_mmt_rec mtl_material_transactions%ROWTYPE;
543: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
544: l_mmti_rec mtl_transactions_interface%ROWTYPE;
545: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
546: l_mat_dtl_rec gme_material_details%ROWTYPE;
547: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
548: create_material_txn_err EXCEPTION;
549: delete_material_txn_err EXCEPTION;
550: BEGIN
701: l_mmt_rec mtl_material_transactions%ROWTYPE;
702: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
703: l_mmti_rec mtl_transactions_interface%ROWTYPE;
704: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
705: l_mat_dtl_rec gme_material_details%ROWTYPE;
706: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
707: create_material_txn_err EXCEPTION;
708: delete_material_txn_err EXCEPTION;
709: get_trans_err EXCEPTION;
792: || 'getting material for '
793: || l_mat_dtl_rec.material_detail_id);
794: END IF;
795:
796: IF NOT gme_material_details_dbl.fetch_row
797: (p_material_detail => l_mat_dtl_rec
798: ,x_material_detail => l_mat_dtl_rec) THEN
799: RAISE fnd_api.g_exc_error;
800: END IF;
2379: NULL
2380: )
2381: )
2382: )
2383: FROM mtl_material_transactions t, gme_material_details d
2384: WHERE t.organization_id = v_organization_id
2385: AND t.inventory_item_id = v_item_id
2386: AND t.transaction_source_id = v_batch_id
2387: AND t.trx_source_line_id = v_mat_det_id
2411: NULL
2412: )
2413: )
2414: )
2415: FROM mtl_material_transactions m, mtl_transaction_lot_numbers l, gme_material_details d
2416: WHERE l.transaction_id = m.transaction_id
2417: AND m.trx_source_line_id = d.material_detail_id
2418: AND l.lot_number = v_lot_number
2419: AND l.inventory_item_id = v_item_id
2554: GROUP BY lot_number;
2555:
2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2557: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2558: l_mat_dtl_rec gme_material_details%ROWTYPE;
2559: l_batch_hdr_rec gme_batch_header%ROWTYPE;
2560: l_item_rec mtl_system_items_b%ROWTYPE;
2561: l_available_qty NUMBER;
2562: l_step_status NUMBER;
2610: IF l_batch_hdr_rec.update_inventory_ind = 'Y' THEN
2611: IF l_mmti_rec.trx_source_line_id IS NOT NULL THEN
2612: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
2613:
2614: IF NOT gme_material_details_dbl.fetch_row
2615: (p_material_detail => l_mat_dtl_rec
2616: ,x_material_detail => l_mat_dtl_rec) THEN
2617: RAISE fnd_api.g_exc_error;
2618: END IF; -- material fetch
2962: DECODE(d.dtl_um,t.transaction_uom, NVL(tl.transaction_quantity,t.transaction_quantity),
2963: Inv_Convert.inv_um_convert(d.inventory_item_id,tl.lot_number,t.organization_id, 5
2964: ,NVL(tl.transaction_quantity,t.transaction_quantity), t.transaction_uom
2965: ,d.dtl_um, NULL, NULL)) doc_qty
2966: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl
2967: WHERE t.organization_id = v_organization_id
2968: AND t.transaction_source_id = v_batch_id
2969: AND t.trx_source_line_id = v_mat_det_id
2970: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3014: l_inventory_item_id NUMBER;
3015: l_organization_id NUMBER;
3016: l_actual_qty NUMBER;
3017: l_gme_pairs_rec gme_transaction_pairs%ROWTYPE;
3018: l_mat_dtl_rec gme_material_details%ROWTYPE;
3019: l_api_name CONSTANT VARCHAR2 (30) := 'gme_post_process';
3020: l_exists NUMBER; -- Bug 5763818
3021: transfer_error EXCEPTION; -- B4944024
3022: dispense_error EXCEPTION;
3137:
3138: -- for transaction pairs
3139: IF l_transaction_reference IS NOT NULL THEN
3140: l_mat_dtl_rec.material_detail_id := l_trx_source_line_id ;
3141: IF NOT gme_material_details_dbl.fetch_row
3142: (p_material_detail => l_mat_dtl_rec
3143: ,x_material_detail => l_mat_dtl_rec) THEN
3144: RAISE fnd_api.g_exc_error;
3145: END IF;
3338:
3339: -- get the total quantity for actaul qty update of material detail line
3340: l_mat_dtl_rec.material_detail_id := l_trx_source_line_id;
3341:
3342: IF NOT gme_material_details_dbl.fetch_row
3343: (p_material_detail => l_mat_dtl_rec
3344: ,x_material_detail => l_mat_dtl_rec) THEN
3345: RAISE fnd_api.g_exc_error;
3346: END IF;
3372: END IF;
3373:
3374: l_mat_dtl_rec.actual_qty := ABS (l_actual_qty);
3375:
3376: IF NOT gme_material_details_dbl.update_row
3377: (p_material_detail => l_mat_dtl_rec) THEN
3378: RAISE fnd_api.g_exc_error;
3379: END IF;
3380:
3756: FROM
3757: mtl_material_transactions mmt,
3758: mtl_transaction_lot_numbers mtln,
3759: mtl_system_items_b msi,
3760: gme_material_details md,
3761: gme_transaction_pairs gtp
3762: WHERE
3763: mmt.transaction_set_id = gme_common_pvt.g_transaction_header_id
3764: AND mtln.transaction_id(+) = mmt.transaction_id
4752: SELECT step_status
4753: FROM gme_batch_steps s, gme_batch_step_items i
4754: WHERE s.batchstep_id = i.batchstep_id
4755: AND i.material_detail_id = v_matl_dtl_id;
4756: l_mat_dtl_rec gme_material_details%ROWTYPE;
4757: l_batch_hdr_rec gme_batch_header%ROWTYPE;
4758: l_item_rec mtl_system_items_b%ROWTYPE;
4759: l_available_qty NUMBER;
4760: l_step_status NUMBER;
4792:
4793: IF l_batch_hdr_rec.update_inventory_ind = 'Y' THEN
4794: IF p_mmti_rec.trx_source_line_id IS NOT NULL THEN
4795: l_mat_dtl_rec.material_detail_id := p_mmti_rec.trx_source_line_id;
4796: IF NOT gme_material_details_dbl.fetch_row(l_mat_dtl_rec, l_mat_dtl_rec) THEN
4797: RAISE fnd_api.g_exc_error;
4798: END IF; -- material fetch
4799: ELSE
4800: RAISE fnd_api.g_exc_error;