DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_INST_PKG dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

59:
60: EXCEPTION
61:
62: WHEN OTHERS THEN
63: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
64: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
65: x_error_message := fnd_message.get;
66: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
67:

Line 64: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);

60: EXCEPTION
61:
62: WHEN OTHERS THEN
63: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
64: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
65: x_error_message := fnd_message.get;
66: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
67:
68: END Decode_Message;

Line 65: x_error_message := fnd_message.get;

61:
62: WHEN OTHERS THEN
63: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
64: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
65: x_error_message := fnd_message.get;
66: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
67:
68: END Decode_Message;
69:

Line 251: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');

247:
248: --raise exception if the source record is not found
249:
250: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
251: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
252: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
253: l_error_message := fnd_message.get;
254: l_Return_Status := FND_API.G_RET_STS_ERROR;
255: RAISE Update_Ib_Exp;

Line 252: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);

248: --raise exception if the source record is not found
249:
250: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
251: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
252: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
253: l_error_message := fnd_message.get;
254: l_Return_Status := FND_API.G_RET_STS_ERROR;
255: RAISE Update_Ib_Exp;
256: END IF;

Line 253: l_error_message := fnd_message.get;

249:
250: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
251: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
252: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
253: l_error_message := fnd_message.get;
254: l_Return_Status := FND_API.G_RET_STS_ERROR;
255: RAISE Update_Ib_Exp;
256: END IF;
257:

Line 261: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');

257:
258: -- check if there exist multiple source instances
259:
260: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
261: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
262: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
263: l_error_message := fnd_message.get;
264: l_Return_Status := FND_API.G_RET_STS_ERROR;
265: RAISE Update_Ib_Exp;

Line 262: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);

258: -- check if there exist multiple source instances
259:
260: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
261: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
262: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
263: l_error_message := fnd_message.get;
264: l_Return_Status := FND_API.G_RET_STS_ERROR;
265: RAISE Update_Ib_Exp;
266: END IF;

Line 263: l_error_message := fnd_message.get;

259:
260: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
261: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
262: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
263: l_error_message := fnd_message.get;
264: l_Return_Status := FND_API.G_RET_STS_ERROR;
265: RAISE Update_Ib_Exp;
266: END IF;
267:

Line 289: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');

285: -- Step 3,Check if the txn_qty is more than source item instance qty
286:
287: IF(P_Proj_Item_Inst_Attr_Rec.Quantity >
288: l_Instance_Header_Tbl_Out(i).Quantity) THEN
289: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
290: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
291: l_error_message := fnd_message.get;
292: l_Return_Status := FND_API.G_RET_STS_ERROR;
293: RAISE Update_Ib_Exp;

Line 290: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);

286:
287: IF(P_Proj_Item_Inst_Attr_Rec.Quantity >
288: l_Instance_Header_Tbl_Out(i).Quantity) THEN
289: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
290: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
291: l_error_message := fnd_message.get;
292: l_Return_Status := FND_API.G_RET_STS_ERROR;
293: RAISE Update_Ib_Exp;
294: END IF;

Line 291: l_error_message := fnd_message.get;

287: IF(P_Proj_Item_Inst_Attr_Rec.Quantity >
288: l_Instance_Header_Tbl_Out(i).Quantity) THEN
289: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
290: fnd_message.set_token('ITEM',P_Proj_Item_Inst_Attr_Rec.Item_Id);
291: l_error_message := fnd_message.get;
292: l_Return_Status := FND_API.G_RET_STS_ERROR;
293: RAISE Update_Ib_Exp;
294: END IF;
295:

Line 753: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

749: X_Return_Status := l_Return_Status;
750: x_Error_Message := l_Error_Message;
751:
752: WHEN OTHERS THEN
753: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
754: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
755: x_error_message := fnd_message.get;
756: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
757: END Update_Ib_Repository;

Line 754: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);

750: x_Error_Message := l_Error_Message;
751:
752: WHEN OTHERS THEN
753: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
754: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
755: x_error_message := fnd_message.get;
756: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
757: END Update_Ib_Repository;
758: PROCEDURE Update_eib_instances(

Line 755: x_error_message := fnd_message.get;

751:
752: WHEN OTHERS THEN
753: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
754: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
755: x_error_message := fnd_message.get;
756: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
757: END Update_Ib_Repository;
758: PROCEDURE Update_eib_instances(
759: P_proj_item_inst_Attr_tbl IN proj_item_inst_Attr_tbl_Type,

Line 778: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');

774: END LOOP;
775: END IF; -- tbl.count IF
776: EXCEPTION
777: WHEN OTHERS THEN
778: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
779: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
780: x_error_message := fnd_message.get;
781: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
782:

Line 779: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);

775: END IF; -- tbl.count IF
776: EXCEPTION
777: WHEN OTHERS THEN
778: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
779: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
780: x_error_message := fnd_message.get;
781: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: END update_eib_instances;

Line 780: x_error_message := fnd_message.get;

776: EXCEPTION
777: WHEN OTHERS THEN
778: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
779: fnd_message.set_token('ERR_MSG','CSE_PROJ_ITEM_INST_PKG.UPDATE_EIB_INSTANCES'||'='|| SQLERRM);
780: x_error_message := fnd_message.get;
781: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: END update_eib_instances;
784: