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 120.1 2010/11/22 11:02:01 dnema 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_Lot_Number VARCHAR2(80); --bug 10322621

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

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

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

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