APPS.GME_TRANSACTIONS_PVT dependencies on GME_MATERIAL_DETAILS_DBL

Line 190: IF NOT gme_material_details_dbl.fetch_row

186: l_mmli_tbl := p_mmli_tbl;
187: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
188:
189: -- Now fetch the material details for the material
190: IF NOT gme_material_details_dbl.fetch_row
191: (p_material_detail => l_mat_dtl_rec
192: ,x_material_detail => l_mat_dtl_rec) THEN
193: RAISE fnd_api.g_exc_error;
194: END IF;

Line 315: IF NOT gme_material_details_dbl.fetch_row

311: || l_mmti_rec.transaction_type_id);
312: END IF;
313:
314: -- Now fetch the material details for the phantom line
315: IF NOT gme_material_details_dbl.fetch_row
316: (p_material_detail => m_mat_dtl_rec
317: ,x_material_detail => m_mat_dtl_rec) THEN
318: RAISE fnd_api.g_exc_error;
319: END IF;

Line 1254: IF NOT gme_material_details_dbl.fetch_row

1250: || 'getting material for '
1251: || l_mat_dtl_rec.material_detail_id);
1252: END IF;
1253:
1254: IF NOT gme_material_details_dbl.fetch_row
1255: (p_material_detail => l_mat_dtl_rec
1256: ,x_material_detail => l_mat_dtl_rec) THEN
1257: RAISE fnd_api.g_exc_error;
1258: END IF;

Line 3464: IF NOT gme_material_details_dbl.fetch_row

3460: IF l_batch_hdr_rec.update_inventory_ind = 'Y' THEN
3461: IF l_mmti_rec.trx_source_line_id IS NOT NULL THEN
3462: l_mat_dtl_rec.material_detail_id := l_mmti_rec.trx_source_line_id;
3463:
3464: IF NOT gme_material_details_dbl.fetch_row
3465: (p_material_detail => l_mat_dtl_rec
3466: ,x_material_detail => l_mat_dtl_rec) THEN
3467: RAISE fnd_api.g_exc_error;
3468: END IF; -- material fetch

Line 4006: IF NOT gme_material_details_dbl.fetch_row

4002:
4003: -- for transaction pairs
4004: IF l_transaction_reference IS NOT NULL THEN
4005: l_mat_dtl_rec.material_detail_id := l_trx_source_line_id ;
4006: IF NOT gme_material_details_dbl.fetch_row
4007: (p_material_detail => l_mat_dtl_rec
4008: ,x_material_detail => l_mat_dtl_rec) THEN
4009: RAISE fnd_api.g_exc_error;
4010: END IF;

Line 4218: IF NOT gme_material_details_dbl.fetch_row

4214:
4215: -- get the total quantity for actaul qty update of material detail line
4216: l_mat_dtl_rec.material_detail_id := l_trx_source_line_id;
4217:
4218: IF NOT gme_material_details_dbl.fetch_row
4219: (p_material_detail => l_mat_dtl_rec
4220: ,x_material_detail => l_mat_dtl_rec) THEN
4221: RAISE fnd_api.g_exc_error;
4222: END IF;

Line 4252: IF NOT gme_material_details_dbl.update_row

4248: END IF;
4249:
4250: l_mat_dtl_rec.actual_qty := ABS (l_actual_qty);
4251:
4252: IF NOT gme_material_details_dbl.update_row
4253: (p_material_detail => l_mat_dtl_rec) THEN
4254: RAISE fnd_api.g_exc_error;
4255: END IF;
4256:

Line 5842: IF NOT gme_material_details_dbl.fetch_row(l_mat_dtl_rec, l_mat_dtl_rec) THEN

5838:
5839: IF l_batch_hdr_rec.update_inventory_ind = 'Y' THEN
5840: IF p_mmti_rec.trx_source_line_id IS NOT NULL THEN
5841: l_mat_dtl_rec.material_detail_id := p_mmti_rec.trx_source_line_id;
5842: IF NOT gme_material_details_dbl.fetch_row(l_mat_dtl_rec, l_mat_dtl_rec) THEN
5843: RAISE fnd_api.g_exc_error;
5844: END IF; -- material fetch
5845: ELSE
5846: RAISE fnd_api.g_exc_error;