58:
59: EXCEPTION
60:
61: WHEN OTHERS THEN
62: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
63: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
64: x_error_message := fnd_message.get;
65: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
66:
59: EXCEPTION
60:
61: WHEN OTHERS THEN
62: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
63: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
64: x_error_message := fnd_message.get;
65: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
66:
67: END Decode_Message;
60:
61: WHEN OTHERS THEN
62: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
63: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
64: x_error_message := fnd_message.get;
65: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
66:
67: END Decode_Message;
68:
246:
247: --raise exception if the source record is not found
248:
249: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
250: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
251: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
252: l_error_message := fnd_message.get;
253: l_Return_Status := FND_API.G_RET_STS_ERROR;
254: RAISE Update_Ib_Exp;
247: --raise exception if the source record is not found
248:
249: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
250: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
251: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
252: l_error_message := fnd_message.get;
253: l_Return_Status := FND_API.G_RET_STS_ERROR;
254: RAISE Update_Ib_Exp;
255: END IF;
248:
249: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
250: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
251: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
252: l_error_message := fnd_message.get;
253: l_Return_Status := FND_API.G_RET_STS_ERROR;
254: RAISE Update_Ib_Exp;
255: END IF;
256:
256:
257: -- check if there exist multiple source instances
258:
259: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
260: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
261: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
262: l_error_message := fnd_message.get;
263: l_Return_Status := FND_API.G_RET_STS_ERROR;
264: RAISE Update_Ib_Exp;
257: -- check if there exist multiple source instances
258:
259: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
260: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
261: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
262: l_error_message := fnd_message.get;
263: l_Return_Status := FND_API.G_RET_STS_ERROR;
264: RAISE Update_Ib_Exp;
265: END IF;
258:
259: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
260: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
261: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
262: l_error_message := fnd_message.get;
263: l_Return_Status := FND_API.G_RET_STS_ERROR;
264: RAISE Update_Ib_Exp;
265: END IF;
266:
284: -- Step 3,Check if the txn_qty is more than source item instance qty
285:
286: IF(P_Proj_Item_Inst_Attr_Rec.Quantity >
287: l_Instance_Header_Tbl_Out(i).Quantity) THEN
288: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
289: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
290: l_error_message := fnd_message.get;
291: l_Return_Status := FND_API.G_RET_STS_ERROR;
292: RAISE Update_Ib_Exp;
285:
286: IF(P_Proj_Item_Inst_Attr_Rec.Quantity >
287: l_Instance_Header_Tbl_Out(i).Quantity) THEN
288: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
289: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
290: l_error_message := fnd_message.get;
291: l_Return_Status := FND_API.G_RET_STS_ERROR;
292: RAISE Update_Ib_Exp;
293: END IF;
286: IF(P_Proj_Item_Inst_Attr_Rec.Quantity >
287: l_Instance_Header_Tbl_Out(i).Quantity) THEN
288: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
289: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
290: l_error_message := fnd_message.get;
291: l_Return_Status := FND_API.G_RET_STS_ERROR;
292: RAISE Update_Ib_Exp;
293: END IF;
294:
748: X_Return_Status := l_Return_Status;
749: x_Error_Message := l_Error_Message;
750:
751: WHEN OTHERS THEN
752: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
753: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
754: x_error_message := fnd_message.get;
755: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
756: END Update_Ib_Repository;
749: x_Error_Message := l_Error_Message;
750:
751: WHEN OTHERS THEN
752: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
753: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
754: x_error_message := fnd_message.get;
755: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
756: END Update_Ib_Repository;
757: PROCEDURE Update_eib_instances(
750:
751: WHEN OTHERS THEN
752: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
753: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
754: x_error_message := fnd_message.get;
755: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
756: END Update_Ib_Repository;
757: PROCEDURE Update_eib_instances(
758: P_proj_item_inst_Attr_tbl IN proj_item_inst_Attr_tbl_Type,
773: END LOOP;
774: END IF; -- tbl.count IF
775: EXCEPTION
776: WHEN OTHERS THEN
777: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
778: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
779: x_error_message := fnd_message.get;
780: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
781:
774: END IF; -- tbl.count IF
775: EXCEPTION
776: WHEN OTHERS THEN
777: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
778: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
779: x_error_message := fnd_message.get;
780: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
781:
782: END update_eib_instances;
775: EXCEPTION
776: WHEN OTHERS THEN
777: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
778: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
779: x_error_message := fnd_message.get;
780: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
781:
782: END update_eib_instances;
783: