DBA Data[Home] [Help]

APPS.CSE_PROJ_ITEM_UNINST_PKG dependencies on FND_MESSAGE

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

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

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

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

Line 69: x_error_message := fnd_message.get;

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

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

229:
230: --raise exception if the source record is not found
231:
232: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
233: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
234: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
235: l_error_message := fnd_message.get;
236: l_Return_Status := FND_API.G_RET_STS_ERROR;
237: RAISE Update_Ib_Exp;

Line 234: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);

230: --raise exception if the source record is not found
231:
232: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
233: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
234: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
235: l_error_message := fnd_message.get;
236: l_Return_Status := FND_API.G_RET_STS_ERROR;
237: RAISE Update_Ib_Exp;
238: END IF;

Line 235: l_error_message := fnd_message.get;

231:
232: IF(l_Instance_Header_Tbl_Out.COUNT=0) THEN
233: fnd_message.set_name('CSE','CSE_SRC_RECORD_NOTFOUND');
234: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
235: l_error_message := fnd_message.get;
236: l_Return_Status := FND_API.G_RET_STS_ERROR;
237: RAISE Update_Ib_Exp;
238: END IF;
239:

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

240:
241: -- check if there exist multiple source instances
242:
243: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
244: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
245: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
246: l_error_message := fnd_message.get;
247: l_Return_Status := FND_API.G_RET_STS_ERROR;
248: RAISE Update_Ib_Exp;

Line 245: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);

241: -- check if there exist multiple source instances
242:
243: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
244: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
245: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
246: l_error_message := fnd_message.get;
247: l_Return_Status := FND_API.G_RET_STS_ERROR;
248: RAISE Update_Ib_Exp;
249: END IF;

Line 246: l_error_message := fnd_message.get;

242:
243: IF(l_Instance_Header_Tbl_Out.COUNT>1) THEN
244: fnd_message.set_name('CSE','CSE_SRC_MULTIPLE_ITM_INSTANCES');
245: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
246: l_error_message := fnd_message.get;
247: l_Return_Status := FND_API.G_RET_STS_ERROR;
248: RAISE Update_Ib_Exp;
249: END IF;
250:

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

265: -- Step 3,Check if the txn_qty is more than source item instance qty
266:
267: IF(P_Proj_Item_Uninst_Attr_Rec.Quantity >
268: l_Instance_Header_Tbl_Out(i).Quantity) THEN
269: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
270: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
271: l_error_message := fnd_message.get;
272: l_Return_Status := FND_API.G_RET_STS_ERROR;
273: RAISE Update_Ib_Exp;

Line 270: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);

266:
267: IF(P_Proj_Item_Uninst_Attr_Rec.Quantity >
268: l_Instance_Header_Tbl_Out(i).Quantity) THEN
269: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
270: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
271: l_error_message := fnd_message.get;
272: l_Return_Status := FND_API.G_RET_STS_ERROR;
273: RAISE Update_Ib_Exp;
274: END IF;

Line 271: l_error_message := fnd_message.get;

267: IF(P_Proj_Item_Uninst_Attr_Rec.Quantity >
268: l_Instance_Header_Tbl_Out(i).Quantity) THEN
269: fnd_message.set_name('CSE','CSE_SRC_ITEM_QUANTITY');
270: fnd_message.set_token('ITEM',P_Proj_Item_Uninst_Attr_Rec.Item_Id);
271: l_error_message := fnd_message.get;
272: l_Return_Status := FND_API.G_RET_STS_ERROR;
273: RAISE Update_Ib_Exp;
274: END IF;
275:

Line 563: fnd_message.set_name('CSE','CSE_NO_ACTIVE_DEST_INSTANCES');

559: END IF;
560: END IF;
561:
562: ELSIF l_Dest_Instance_Rec.Instance_Id IS NULL THEN
563: fnd_message.set_name('CSE','CSE_NO_ACTIVE_DEST_INSTANCES');
564: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);
565: l_error_message := fnd_message.get;
566: l_Return_Status := FND_API.G_RET_STS_ERROR;
567: RAISE Update_Ib_Exp;

Line 564: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);

560: END IF;
561:
562: ELSIF l_Dest_Instance_Rec.Instance_Id IS NULL THEN
563: fnd_message.set_name('CSE','CSE_NO_ACTIVE_DEST_INSTANCES');
564: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);
565: l_error_message := fnd_message.get;
566: l_Return_Status := FND_API.G_RET_STS_ERROR;
567: RAISE Update_Ib_Exp;
568: END IF;

Line 565: l_error_message := fnd_message.get;

561:
562: ELSIF l_Dest_Instance_Rec.Instance_Id IS NULL THEN
563: fnd_message.set_name('CSE','CSE_NO_ACTIVE_DEST_INSTANCES');
564: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);
565: l_error_message := fnd_message.get;
566: l_Return_Status := FND_API.G_RET_STS_ERROR;
567: RAISE Update_Ib_Exp;
568: END IF;
569:

Line 571: fnd_message.set_name('CSE','CSE_DEST_RECORD_NOTFOUND');

567: RAISE Update_Ib_Exp;
568: END IF;
569:
570: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
571: fnd_message.set_name('CSE','CSE_DEST_RECORD_NOTFOUND');
572: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);
573: l_error_message := fnd_message.get;
574: l_Return_Status := FND_API.G_RET_STS_ERROR;
575: RAISE Update_Ib_Exp;

Line 572: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);

568: END IF;
569:
570: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
571: fnd_message.set_name('CSE','CSE_DEST_RECORD_NOTFOUND');
572: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);
573: l_error_message := fnd_message.get;
574: l_Return_Status := FND_API.G_RET_STS_ERROR;
575: RAISE Update_Ib_Exp;
576: END IF;

Line 573: l_error_message := fnd_message.get;

569:
570: ELSIF (l_Instance_Header_Tbl_Out.COUNT=0) THEN
571: fnd_message.set_name('CSE','CSE_DEST_RECORD_NOTFOUND');
572: fnd_message.set_token('ITEM',l_instance_header_tbl_out(i).inventory_item_id);
573: l_error_message := fnd_message.get;
574: l_Return_Status := FND_API.G_RET_STS_ERROR;
575: RAISE Update_Ib_Exp;
576: END IF;
577:

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

586: X_Return_Status := l_Return_Status;
587: x_Error_Message := l_Error_Message;
588:
589: WHEN OTHERS THEN
590: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
591: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
592: x_error_message := fnd_message.get;
593: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
594:

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

587: x_Error_Message := l_Error_Message;
588:
589: WHEN OTHERS THEN
590: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
591: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
592: x_error_message := fnd_message.get;
593: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
594:
595: END Update_Ib_Repository;

Line 592: x_error_message := fnd_message.get;

588:
589: WHEN OTHERS THEN
590: fnd_message.set_name('CSE','CSE_OTHERS_EXCEPTION');
591: fnd_message.set_token('ERR_MSG',l_Api_Name||'='|| SQLERRM);
592: x_error_message := fnd_message.get;
593: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
594:
595: END Update_Ib_Repository;
596: