APPS.CSE_PROJ_ITEM_INST_PKG dependencies on CSE_PROJ_ITEM_INST_PKG

Line 1: package body CSE_PROJ_ITEM_INST_PKG AS

1: package body CSE_PROJ_ITEM_INST_PKG AS
2: -- $Header: CSEITINB.pls 115.40 2003/09/22 16:05:45 stutika ship $
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSE_DEBUG_OPTION'),'N');
5: PROCEDURE Decode_Message(

Line 12: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';

8: X_Proj_Item_Inst_Attr_Rec OUT NOCOPY Proj_Item_Inst_Attr_Rec_Type,
9: X_Return_Status OUT NOCOPY VARCHAR2,
10: X_Error_Message OUT NOCOPY VARCHAR2) IS
11:
12: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';
13: l_Item_Id NUMBER;
14: l_Revision VARCHAR2(3);
15: l_Lot_Number VARCHAR2(30);
16: l_Serial_Number VARCHAR2(30);

Line 74: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';

70: P_Proj_Item_Inst_Attr_Rec IN Proj_Item_Inst_Attr_Rec_Type,
71: X_Return_Status OUT NOCOPY VARCHAR2,
72: X_Error_Message OUT NOCOPY VARCHAR2) IS
73:
74: l_Api_Name CONSTANT VARCHAR2(30) := 'CSE_PROJ_ITEM_INST_PKG';
75: l_api_version NUMBER DEFAULT 1.0;
76: l_Commit VARCHAR2(1) DEFAULT FND_API.G_FALSE;
77: l_Init_Msg_List VARCHAR2(1) DEFAULT FND_API.G_TRUE;
78: l_Create_Dest_Inst_Flag VARCHAR2(1) DEFAULT FND_API.G_FALSE;

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 784: END CSE_PROJ_ITEM_INST_PKG;

780: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
781:
782: END update_eib_instances;
783:
784: END CSE_PROJ_ITEM_INST_PKG;