393: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
394: END IF;
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: IF NOT gme_pending_product_lots_dbl.insert_row
398: (p_pending_product_lots_rec => p_pending_product_lots_rec
399: ,x_pending_product_lots_rec => l_pp_lot_rec) THEN
400: RAISE error_insert_row;
401: END IF;
433: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
434: END IF;
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437: IF NOT gme_pending_product_lots_dbl.update_row
438: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
439: RAISE error_update_row;
440: END IF;
441:
438: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
439: RAISE error_update_row;
440: END IF;
441:
442: IF NOT gme_pending_product_lots_dbl.fetch_row
443: (p_pending_product_lots_rec => p_pending_product_lots_rec
444: ,x_pending_product_lots_rec => x_pending_product_lots_rec) THEN
445: RAISE error_fetch_row;
446: END IF;
474: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
475: END IF;
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477:
478: IF NOT gme_pending_product_lots_dbl.delete_row
479: (p_pending_product_lots_rec => p_pending_product_lots_rec) THEN
480: RAISE error_delete_row;
481: END IF;
482:
521: LOOP
522: FETCH c_get_pending_lots INTO l_pending_product_lots_rec.pending_product_lot_id;
523: EXIT WHEN c_get_pending_lots%NOTFOUND;
524: --call dbl layer
525: IF NOT gme_pending_product_lots_dbl.delete_row
526: (p_pending_product_lots_rec => l_pending_product_lots_rec) THEN
527: CLOSE c_get_pending_lots;
528: RAISE error_delete_row;
529: END IF;
901: l_in_pending_product_lots_rec := p_pending_product_lots_rec;
902: l_in_pending_product_lots_rec.material_detail_id := p_material_detail_rec.material_detail_id;
903: l_in_pending_product_lots_rec.batch_id := p_material_detail_rec.batch_id;
904:
905: IF NOT gme_pending_product_lots_dbl.fetch_row
906: (p_pending_product_lots_rec => l_in_pending_product_lots_rec
907: ,x_pending_product_lots_rec => l_db_pending_product_lots_rec) THEN
908: RAISE error_fetch_row;
909: END IF;
1129: l_in_pending_product_lots_rec := p_pending_product_lots_rec;
1130: l_in_pending_product_lots_rec.material_detail_id := p_material_detail_rec.material_detail_id;
1131: l_in_pending_product_lots_rec.batch_id := p_material_detail_rec.batch_id;
1132:
1133: IF NOT gme_pending_product_lots_dbl.fetch_row
1134: (p_pending_product_lots_rec => l_in_pending_product_lots_rec
1135: ,x_pending_product_lots_rec => x_pending_product_lots_rec) THEN
1136: RAISE error_fetch_row;
1137: END IF;