DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_INST_PKG dependencies on FND_MESSAGE

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

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:

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

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;

Line 64: x_error_message := fnd_message.get;

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:

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

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;

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

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;

Line 252: l_error_message := fnd_message.get;

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:

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

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;

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

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;

Line 262: l_error_message := fnd_message.get;

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:

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

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;

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

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;

Line 290: l_error_message := fnd_message.get;

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:

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

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;

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

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(

Line 754: x_error_message := fnd_message.get;

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,

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

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:

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

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;

Line 779: x_error_message := fnd_message.get;

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: