eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_DB_CONNECTIONS_PVT dependencies on FND_API

Line 7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DB_CONNECTIONS_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_db_link IN VARCHAR2,
10: p_db_username IN VARCHAR2,
11: p_db_password IN VARCHAR2,

Line 8: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_DB_CONNECTIONS_PVT ';
5:
6: PROCEDURE create_item (p_api_version_number IN NUMBER,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8: p_commit IN VARCHAR2 := FND_API.G_FALSE,
9: p_db_link IN VARCHAR2,
10: p_db_username IN VARCHAR2,
11: p_db_password IN VARCHAR2,
12: p_db_server_id IN NUMBER,

Line 51: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT create_item_PVT;
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
55: THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF FND_API.to_Boolean( p_init_msg_list )
60: THEN

Line 59: IF FND_API.to_Boolean( p_init_msg_list )

55: THEN
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
57: END IF;
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: IF FND_API.to_Boolean( p_init_msg_list )
60: THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63: -- Initialize API return status to SUCCESS

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: THEN
61: FND_MSG_PUB.initialize;
62: END IF;
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: SELECT IEM_DB_CONNECTIONS_s1.nextval
67: INTO l_seq_id
68: FROM dual;

Line 71: if p_db_server_id <> FND_API.G_MISS_NUM THEN

67: INTO l_seq_id
68: FROM dual;
69:
70: /*Check For Existing Server Group Id */
71: if p_db_server_id <> FND_API.G_MISS_NUM THEN
72: Select count(*) into l_grp_cnt from iem_db_servers
73: where db_server_id=p_db_server_id
74: and rownum=1;
75: IF l_grp_cnt = 0 then

Line 78: x_return_status := FND_API.G_RET_STS_ERROR ;

74: and rownum=1;
75: IF l_grp_cnt = 0 then
76: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
77: FND_MSG_PUB.ADD;
78: x_return_status := FND_API.G_RET_STS_ERROR ;
79: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
80: p_data =>x_msg_data);
81: APP_EXCEPTION.RAISE_EXCEPTION;
82: END IF;

Line 123: decode(p_conn_desc,FND_API.G_MISS_CHAR,NULL,p_conn_desc),

119: p_db_username,
120: p_db_password,
121: p_db_server_id,
122: p_is_admin,
123: decode(p_conn_desc,FND_API.G_MISS_CHAR,NULL,p_conn_desc),
124: decode(l_CREATED_BY,null,-1,l_CREATED_BY),
125: sysdate,
126: decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
127: sysdate,

Line 129: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

125: sysdate,
126: decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
127: sysdate,
128: decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
129: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

Line 130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

126: decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
127: sysdate,
128: decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
129: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

Line 131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

127: sysdate,
128: decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
129: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

Line 132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

128: decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
129: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

Line 133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

129: decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

Line 134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

130: decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

Line 135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

131: decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

Line 136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

132: decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

Line 137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

133: decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

Line 138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

134: decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

Line 139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

135: decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

Line 140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

136: decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );

Line 141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

137: decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );
145:

Line 142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

138: decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );
145:
146: -- Standard Check Of p_commit.

Line 143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)

139: decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
140: decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
141: decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
142: decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );
145:
146: -- Standard Check Of p_commit.
147: IF FND_API.To_Boolean(p_commit) THEN

Line 147: IF FND_API.To_Boolean(p_commit) THEN

143: decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
144: );
145:
146: -- Standard Check Of p_commit.
147: IF FND_API.To_Boolean(p_commit) THEN
148: COMMIT WORK;
149: END IF;
150: -- Standard callto get message count and if count is 1, get message info.
151: FND_MSG_PUB.Count_And_Get

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO create_item_PVT;
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,

Line 158: x_return_status := FND_API.G_RET_STS_ERROR ;

154: );
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: ROLLBACK TO create_item_PVT;
158: x_return_status := FND_API.G_RET_STS_ERROR ;
159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );

Line 163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

159: FND_MSG_PUB.Count_And_Get
160: ( p_count => x_msg_count,
161: p_data => x_msg_data
162: );
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO create_item_PVT;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count,

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

161: p_data => x_msg_data
162: );
163: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
164: ROLLBACK TO create_item_PVT;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: FND_MSG_PUB.Count_And_Get
167: ( p_count => x_msg_count,
168: p_data => x_msg_data
169: );

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: p_data => x_msg_data
169: );
170: WHEN OTHERS THEN
171: ROLLBACK TO create_item_PVT;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: IF FND_MSG_PUB.Check_Msg_Level
174: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg

Line 189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

185:
186: END create_item;
187:
188: PROCEDURE delete_item (p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_db_conn_id in number:=null,
192: p_db_username IN VARCHAR2 :=null,
193: p_db_server_id IN NUMBER:=null,

Line 190: p_commit IN VARCHAR2 := FND_API.G_FALSE,

186: END create_item;
187:
188: PROCEDURE delete_item (p_api_version_number IN NUMBER,
189: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
190: p_commit IN VARCHAR2 := FND_API.G_FALSE,
191: p_db_conn_id in number:=null,
192: p_db_username IN VARCHAR2 :=null,
193: p_db_server_id IN NUMBER:=null,
194: x_return_status OUT NOCOPY VARCHAR2,

Line 205: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

201: BEGIN
202: -- Standard Start of API savepoint
203: SAVEPOINT delete_item_PVT;
204: -- Standard call to check for call compatibility.
205: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
206: p_api_version_number,
207: l_api_name,
208: G_PKG_NAME)
209: THEN

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: p_api_version_number,
207: l_api_name,
208: G_PKG_NAME)
209: THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212: -- Initialize message list if p_init_msg_list is set to TRUE.
213: IF FND_API.to_Boolean( p_init_msg_list )
214: THEN

Line 213: IF FND_API.to_Boolean( p_init_msg_list )

209: THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: END IF;
212: -- Initialize message list if p_init_msg_list is set to TRUE.
213: IF FND_API.to_Boolean( p_init_msg_list )
214: THEN
215: FND_MSG_PUB.initialize;
216: END IF;
217: -- Initialize API return status to SUCCESS

Line 218: x_return_status := FND_API.G_RET_STS_SUCCESS;

214: THEN
215: FND_MSG_PUB.initialize;
216: END IF;
217: -- Initialize API return status to SUCCESS
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: if p_db_conn_id = FND_API.G_MISS_NUM then
220: delete from IEM_DB_CONNECTIONS
221: where db_username=p_db_username and db_server_id=p_db_server_id ;
222: else

Line 219: if p_db_conn_id = FND_API.G_MISS_NUM then

215: FND_MSG_PUB.initialize;
216: END IF;
217: -- Initialize API return status to SUCCESS
218: x_return_status := FND_API.G_RET_STS_SUCCESS;
219: if p_db_conn_id = FND_API.G_MISS_NUM then
220: delete from IEM_DB_CONNECTIONS
221: where db_username=p_db_username and db_server_id=p_db_server_id ;
222: else
223: delete from IEM_DB_CONNECTIONS

Line 228: IF FND_API.To_Boolean(p_commit) THEN

224: where db_connection_id=p_db_conn_id;
225: end if;
226:
227: -- Standard Check Of p_commit.
228: IF FND_API.To_Boolean(p_commit) THEN
229: COMMIT WORK;
230: END IF;
231: -- Standard callto get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO delete_item_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,

Line 239: x_return_status := FND_API.G_RET_STS_ERROR ;

235: );
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO delete_item_PVT;
239: x_return_status := FND_API.G_RET_STS_ERROR ;
240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

240: FND_MSG_PUB.Count_And_Get
241: ( p_count => x_msg_count,
242: p_data => x_msg_data
243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO delete_item_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

242: p_data => x_msg_data
243: );
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO delete_item_PVT;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
247: FND_MSG_PUB.Count_And_Get
248: ( p_count => x_msg_count,
249: p_data => x_msg_data
250: );

Line 253: x_return_status := FND_API.G_RET_STS_ERROR;

249: p_data => x_msg_data
250: );
251: WHEN OTHERS THEN
252: ROLLBACK TO delete_item_PVT;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: IF FND_MSG_PUB.Check_Msg_Level
255: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
256: THEN
257: FND_MSG_PUB.Add_Exc_Msg

Line 270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

266:
267: END delete_item;
268:
269: PROCEDURE update_item (p_api_version_number IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_db_conn_id IN NUMBER:=null,
273: p_db_link IN VARCHAR2:=null,
274: p_db_username IN VARCHAR2:=null,

Line 271: p_commit IN VARCHAR2 := FND_API.G_FALSE,

267: END delete_item;
268:
269: PROCEDURE update_item (p_api_version_number IN NUMBER,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_db_conn_id IN NUMBER:=null,
273: p_db_link IN VARCHAR2:=null,
274: p_db_username IN VARCHAR2:=null,
275: p_db_password IN VARCHAR2:=null,

Line 313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

309: BEGIN
310: -- Standard Start of API savepoint
311: SAVEPOINT update_item_PVT;
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)
317: THEN

Line 318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

314: p_api_version_number,
315: l_api_name,
316: G_PKG_NAME)
317: THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean( p_init_msg_list )
322: THEN

Line 321: IF FND_API.to_Boolean( p_init_msg_list )

317: THEN
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319: END IF;
320: -- Initialize message list if p_init_msg_list is set to TRUE.
321: IF FND_API.to_Boolean( p_init_msg_list )
322: THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325: -- Initialize API return status to SUCCESS

Line 326: x_return_status := FND_API.G_RET_STS_SUCCESS;

322: THEN
323: FND_MSG_PUB.initialize;
324: END IF;
325: -- Initialize API return status to SUCCESS
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: if p_db_server_id is not null then
329:
330: /*Check For Existing DB Server Id */

Line 338: x_return_status := FND_API.G_RET_STS_ERROR ;

334: and rownum=1;
335: IF l_grp_cnt = 0 then
336: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DB_SRV_GRP');
337: FND_MSG_PUB.ADD;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
340: p_data =>x_msg_data);
341: APP_EXCEPTION.RAISE_EXCEPTION;
342: END IF;

Line 346: set db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL, db_link,p_db_link),

342: END IF;
343: end if;
344: if p_db_conn_id is null then
345: update IEM_DB_CONNECTIONS
346: set db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL, db_link,p_db_link),
347: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,is_admin),
348: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),

Line 347: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,is_admin),

343: end if;
344: if p_db_conn_id is null then
345: update IEM_DB_CONNECTIONS
346: set db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL, db_link,p_db_link),
347: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,is_admin),
348: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
351: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),

Line 348: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),

344: if p_db_conn_id is null then
345: update IEM_DB_CONNECTIONS
346: set db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL, db_link,p_db_link),
347: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,is_admin),
348: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
351: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),

Line 352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),

348: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
351: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),

Line 353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),

349: LAST_UPDATE_DATE = sysdate,
350: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
351: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),

Line 354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),

350: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
351: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),

Line 355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),

351: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),

Line 356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),

352: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),

Line 357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),

353: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),

Line 358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),

354: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),

Line 359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),

355: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),

Line 360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),

356: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),

Line 361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),

357: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),

Line 362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),

358: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

Line 363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),

359: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
367: where db_username=p_db_username and db_server_id=p_db_server_id;

Line 364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),

360: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
367: where db_username=p_db_username and db_server_id=p_db_server_id;
368:

Line 365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),

361: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
367: where db_username=p_db_username and db_server_id=p_db_server_id;
368:
369: else

Line 366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

362: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
363: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
364: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
365: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
366: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
367: where db_username=p_db_username and db_server_id=p_db_server_id;
368:
369: else
370: update IEM_DB_CONNECTIONS

Line 371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),

367: where db_username=p_db_username and db_server_id=p_db_server_id;
368:
369: else
370: update IEM_DB_CONNECTIONS
371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),
372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),
375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),

Line 372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),

368:
369: else
370: update IEM_DB_CONNECTIONS
371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),
372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),
375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),

Line 373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),

369: else
370: update IEM_DB_CONNECTIONS
371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),
372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),
375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),
377: LAST_UPDATE_DATE = sysdate,

Line 374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),

370: update IEM_DB_CONNECTIONS
371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),
372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),
375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),
377: LAST_UPDATE_DATE = sysdate,
378: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),

Line 375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),

371: set db_username=decode(p_db_username,FND_API.G_MISS_CHAR, NULL, NULL,db_username,p_db_username),
372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),
375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),
377: LAST_UPDATE_DATE = sysdate,
378: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
379: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),

Line 376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),

372: db_password=decode(p_db_password,FND_API.G_MISS_CHAR, NULL, NULL,db_password,p_db_password),
373: db_link=decode(p_db_link,FND_API.G_MISS_CHAR, NULL, NULL,db_link,p_db_link),
374: is_admin=decode(p_is_admin,FND_API.G_MISS_CHAR, NULL, NULL,is_admin,p_is_admin),
375: connection_desc=decode(p_conn_desc,FND_API.G_MISS_CHAR, NULL, NULL,connection_desc,p_conn_desc),
376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),
377: LAST_UPDATE_DATE = sysdate,
378: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
379: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),

Line 380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),

376: db_server_id=decode(p_db_server_id,FND_API.G_MISS_CHAR, NULL, NULL,db_server_id,p_db_server_id),
377: LAST_UPDATE_DATE = sysdate,
378: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
379: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),

Line 381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),

377: LAST_UPDATE_DATE = sysdate,
378: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
379: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),

Line 382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),

378: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,-1,l_LAST_UPDATED_BY),
379: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),

Line 383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),

379: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,l_LAST_UPDATE_LOGIN),
380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),

Line 384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),

380: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1),
381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),

Line 385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),

381: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2),
382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),

Line 386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),

382: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3),
383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),

Line 387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),

383: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4),
384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),

Line 388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),

384: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5),
385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),

Line 389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),

385: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6),
386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),

Line 390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),

386: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7),
387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

Line 391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),

387: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8),
388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
395: where db_connection_id=p_db_conn_id;

Line 392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),

388: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9),
389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
395: where db_connection_id=p_db_conn_id;
396: end if;

Line 393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),

389: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10),
390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
395: where db_connection_id=p_db_conn_id;
396: end if;
397:

Line 394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)

390: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11),
391: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12),
392: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13),
393: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14),
394: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
395: where db_connection_id=p_db_conn_id;
396: end if;
397:
398: -- Standard Check Of p_commit.

Line 399: IF FND_API.To_Boolean(p_commit) THEN

395: where db_connection_id=p_db_conn_id;
396: end if;
397:
398: -- Standard Check Of p_commit.
399: IF FND_API.To_Boolean(p_commit) THEN
400: COMMIT WORK;
401: END IF;
402: -- Standard callto get message count and if count is 1, get message info.
403: FND_MSG_PUB.Count_And_Get

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: ( p_count => x_msg_count,
405: p_data => x_msg_data
406: );
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO update_item_PVT;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,

Line 410: x_return_status := FND_API.G_RET_STS_ERROR ;

406: );
407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK TO update_item_PVT;
410: x_return_status := FND_API.G_RET_STS_ERROR ;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );

Line 415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO update_item_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

413: p_data => x_msg_data
414: );
415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
416: ROLLBACK TO update_item_PVT;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: FND_MSG_PUB.Count_And_Get
419: ( p_count => x_msg_count,
420: p_data => x_msg_data
421: );

Line 424: x_return_status := FND_API.G_RET_STS_ERROR;

420: p_data => x_msg_data
421: );
422: WHEN OTHERS THEN
423: ROLLBACK TO update_item_PVT;
424: x_return_status := FND_API.G_RET_STS_ERROR;
425: IF FND_MSG_PUB.Check_Msg_Level
426: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
427: THEN
428: FND_MSG_PUB.Add_Exc_Msg

Line 441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

437:
438: END update_item;
439:
440: PROCEDURE select_item (p_api_version_number IN NUMBER,
441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
443: p_db_server_id in number:=null,
444: p_is_admin IN VARCHAR2 :=null,
445: x_db_link OUT NOCOPY VARCHAR2,

Line 442: p_commit IN VARCHAR2 := FND_API.G_FALSE,

438: END update_item;
439:
440: PROCEDURE select_item (p_api_version_number IN NUMBER,
441: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
442: p_commit IN VARCHAR2 := FND_API.G_FALSE,
443: p_db_server_id in number:=null,
444: p_is_admin IN VARCHAR2 :=null,
445: x_db_link OUT NOCOPY VARCHAR2,
446: x_return_status OUT NOCOPY VARCHAR2,

Line 457: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

453: BEGIN
454: -- Standard Start of API savepoint
455: SAVEPOINT select_item_PVT;
456: -- Standard call to check for call compatibility.
457: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
458: p_api_version_number,
459: l_api_name,
460: G_PKG_NAME)
461: THEN

Line 462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

458: p_api_version_number,
459: l_api_name,
460: G_PKG_NAME)
461: THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464: -- Initialize message list if p_init_msg_list is set to TRUE.
465: IF FND_API.to_Boolean( p_init_msg_list )
466: THEN

Line 465: IF FND_API.to_Boolean( p_init_msg_list )

461: THEN
462: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
463: END IF;
464: -- Initialize message list if p_init_msg_list is set to TRUE.
465: IF FND_API.to_Boolean( p_init_msg_list )
466: THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469: -- Initialize API return status to SUCCESS

Line 470: x_return_status := FND_API.G_RET_STS_SUCCESS;

466: THEN
467: FND_MSG_PUB.initialize;
468: END IF;
469: -- Initialize API return status to SUCCESS
470: x_return_status := FND_API.G_RET_STS_SUCCESS;
471: BEGIN
472: SELECT DB_LINK into x_db_link
473: FROM IEM_DB_CONNECTIONS
474: where db_server_id=p_db_server_id

Line 479: x_return_status := FND_API.G_RET_STS_ERROR ;

475: and is_admin=p_is_admin;
476: EXCEPTION WHEN NO_DATA_FOUND THEN
477: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_DBLINK_NAME');
478: FND_MSG_PUB.Add;
479: x_return_status := FND_API.G_RET_STS_ERROR ;
480: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
481: p_data =>x_msg_data);
482: WHEN TOO_MANY_ROWS THEN
483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');

Line 485: x_return_status := FND_API.G_RET_STS_ERROR ;

481: p_data =>x_msg_data);
482: WHEN TOO_MANY_ROWS THEN
483: FND_MESSAGE.SET_NAME('IEM','IEM_MORE_THAN_ONE_DBLINK');
484: FND_MSG_PUB.Add;
485: x_return_status := FND_API.G_RET_STS_ERROR ;
486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data =>x_msg_data);
488: END;
489: -- Standard Check Of p_commit.

Line 490: IF FND_API.To_Boolean(p_commit) THEN

486: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
487: p_data =>x_msg_data);
488: END;
489: -- Standard Check Of p_commit.
490: IF FND_API.To_Boolean(p_commit) THEN
491: COMMIT WORK;
492: END IF;
493: -- Standard callto get message count and if count is 1, get message info.
494: FND_MSG_PUB.Count_And_Get

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495: ( p_count => x_msg_count,
496: p_data => x_msg_data
497: );
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO select_item_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,

Line 501: x_return_status := FND_API.G_RET_STS_ERROR ;

497: );
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO select_item_PVT;
501: x_return_status := FND_API.G_RET_STS_ERROR ;
502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,
504: p_data => x_msg_data
505: );

Line 506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

502: FND_MSG_PUB.Count_And_Get
503: ( p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO select_item_PVT;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,

Line 508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

504: p_data => x_msg_data
505: );
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: ROLLBACK TO select_item_PVT;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,
511: p_data => x_msg_data
512: );

Line 515: x_return_status := FND_API.G_RET_STS_ERROR;

511: p_data => x_msg_data
512: );
513: WHEN OTHERS THEN
514: ROLLBACK TO select_item_PVT;
515: x_return_status := FND_API.G_RET_STS_ERROR;
516: IF FND_MSG_PUB.Check_Msg_Level
517: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
518: THEN
519: FND_MSG_PUB.Add_Exc_Msg