210:
211: EXCEPTION
212: WHEN OTHERS THEN
213: EAM_WORKORDER_UTIL_PKG.show_mesg;
214: APP_EXCEPTION.RAISE_EXCEPTION;
215: END;
216:
217: IF (l_return_status = 'S') THEN
218: X_L_EAM_MAT_REC := l_out_eam_mat_req_tbl(1);
219: x_material_shortage_flag := l_out_eam_wo_rec.material_shortage_flag;
220: x_material_shortage_check_date := l_out_eam_wo_rec.material_shortage_check_date;
221: ELSE
222: EAM_WORKORDER_UTIL_PKG.show_mesg;
223: APP_EXCEPTION.RAISE_EXCEPTION;
224: END IF;
225:
226:
227: OPEN C;
429: x_material_shortage_flag := l_out_eam_wo_rec.material_shortage_flag;
430: x_material_shortage_check_date := l_out_eam_wo_rec.material_shortage_check_date;
431: ELSE
432: EAM_WORKORDER_UTIL_PKG.show_mesg;
433: APP_EXCEPTION.RAISE_EXCEPTION;
434: END IF;
435:
436:
437: END Update_Row;
481: IF (C%NOTFOUND) THEN
482: CLOSE C;
483: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');
484: FND_MESSAGE.RAISE_ERROR;
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487: CLOSE C;
488:
489: IF (Recinfo.inventory_item_id = X_Inventory_Item_Id)
547: RETURN;
548: ELSE
549: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_CHANGED');
550: FND_MESSAGE.RAISE_ERROR;
551: APP_EXCEPTION.RAISE_EXCEPTION;
552: END IF;
553: END Lock_Row;
554:
555:
678: x_material_shortage_flag := l_out_eam_wo_rec.material_shortage_flag;
679: x_material_shortage_check_date := l_out_eam_wo_rec.material_shortage_check_date;
680: ELSE
681: EAM_WORKORDER_UTIL_PKG.show_mesg;
682: APP_EXCEPTION.RAISE_EXCEPTION;
683: END IF;
684: EXCEPTION
685: WHEN OTHERS THEN
686: EAM_WORKORDER_UTIL_PKG.show_mesg;
683: END IF;
684: EXCEPTION
685: WHEN OTHERS THEN
686: EAM_WORKORDER_UTIL_PKG.show_mesg;
687: APP_EXCEPTION.RAISE_EXCEPTION;
688:
689:
690: END Delete_Row;
691: