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_THEMES_PVT dependencies on FND_API

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

8: G_PKG_NAME CONSTANT varchar2(30) :='IEM_THEMES_PVT ';
9:
10:
11: PROCEDURE create_item (p_api_version_number IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: p_score IN NUMBER,
15: p_classification_id IN NUMBER,
16: p_theme IN VARCHAR2,

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

9:
10:
11: PROCEDURE create_item (p_api_version_number IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
13: p_commit IN VARCHAR2 := FND_API.G_FALSE,
14: p_score IN NUMBER,
15: p_classification_id IN NUMBER,
16: p_theme IN VARCHAR2,
17: p_query_response IN VARCHAR2,

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47: l_seq_id NUMBER;
48:
49: BEGIN
50: -- Initialize API return status to SUCCESS
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: -- Take this out. Handle duplicates in the exception block.
54: SELECT COUNT(*) INTO l_cnt from IEM_THEMES WHERE classification_id=p_classification_id
55: and theme=p_theme and query_response=p_query_response;

Line 115: x_return_status := FND_API.G_RET_STS_ERROR;

111: p_ATTRIBUTE15);
112: END IF;
113: EXCEPTION
114: WHEN OTHERS THEN
115: x_return_status := FND_API.G_RET_STS_ERROR;
116: END;
117:
118: PROCEDURE delete_item (p_api_version_number IN NUMBER,
119: p_init_msg_list IN VARCHAR2 ,

Line 134: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

130: BEGIN
131: -- Standard Start of API savepoint
132: SAVEPOINT delete_item_PVT;
133: -- Standard call to check for call compatibility.
134: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
138: THEN

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: p_api_version_number,
136: l_api_name,
137: G_PKG_NAME)
138: THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list )
143: THEN

Line 142: IF FND_API.to_Boolean( p_init_msg_list )

138: THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141: -- Initialize message list if p_init_msg_list is set to TRUE.
142: IF FND_API.to_Boolean( p_init_msg_list )
143: THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to SUCCESS

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: THEN
144: FND_MSG_PUB.initialize;
145: END IF;
146: -- Initialize API return status to SUCCESS
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: DELETE FROM IEM_THEMES WHERE THEME_ID = p_theme_id;
150:
151: -- Standard Check Of p_commit.

Line 152: IF FND_API.To_Boolean(p_commit) THEN

148:
149: DELETE FROM IEM_THEMES WHERE THEME_ID = p_theme_id;
150:
151: -- Standard Check Of p_commit.
152: IF FND_API.To_Boolean(p_commit) THEN
153: COMMIT WORK;
154: END IF;
155: -- Standard callto get message count and if count is 1, get message info.
156: FND_MSG_PUB.Count_And_Get

Line 161: WHEN FND_API.G_EXC_ERROR THEN

157: ( p_count => x_msg_count,
158: p_data => x_msg_data
159: );
160: EXCEPTION
161: WHEN FND_API.G_EXC_ERROR THEN
162: ROLLBACK TO delete_item_PVT;
163: x_return_status := FND_API.G_RET_STS_ERROR ;
164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,

Line 163: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO delete_item_PVT;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

166: p_data => x_msg_data
167: );
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO delete_item_PVT;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );

Line 177: x_return_status := FND_API.G_RET_STS_ERROR;

173: p_data => x_msg_data
174: );
175: WHEN OTHERS THEN
176: ROLLBACK TO delete_item_PVT;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: IF FND_MSG_PUB.Check_Msg_Level
179: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
180: THEN
181: FND_MSG_PUB.Add_Exc_Msg

Line 240: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

236: BEGIN
237: -- Standard Start of API savepoint
238: SAVEPOINT update_item_PVT;
239: -- Standard call to check for call compatibility.
240: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
241: p_api_version_number,
242: l_api_name,
243: G_PKG_NAME)
244: THEN

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: p_api_version_number,
242: l_api_name,
243: G_PKG_NAME)
244: THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: -- Initialize message list if p_init_msg_list is set to TRUE.
248: IF FND_API.to_Boolean( p_init_msg_list )
249: THEN

Line 248: IF FND_API.to_Boolean( p_init_msg_list )

244: THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: -- Initialize message list if p_init_msg_list is set to TRUE.
248: IF FND_API.to_Boolean( p_init_msg_list )
249: THEN
250: FND_MSG_PUB.initialize;
251: END IF;
252: -- Initialize API return status to SUCCESS

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: THEN
250: FND_MSG_PUB.initialize;
251: END IF;
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: update IEM_THEMES SET
256: classification_id = decode( p_classification_id, FND_API.G_MISS_NUM,null,null, classification_id, p_classification_id),
257: theme = decode(p_theme,FND_API.G_MISS_CHAR,null,null,theme,p_theme),

Line 256: classification_id = decode( p_classification_id, FND_API.G_MISS_NUM,null,null, classification_id, p_classification_id),

252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: update IEM_THEMES SET
256: classification_id = decode( p_classification_id, FND_API.G_MISS_NUM,null,null, classification_id, p_classification_id),
257: theme = decode(p_theme,FND_API.G_MISS_CHAR,null,null,theme,p_theme),
258: score = decode(p_score,FND_API.G_MISS_CHAR,null,null,score,p_score),
259: query_response = decode( p_query_response, FND_API.G_MISS_CHAR,null,null, query_response, p_query_response),
260: LAST_UPDATE_DATE = sysdate,

Line 257: theme = decode(p_theme,FND_API.G_MISS_CHAR,null,null,theme,p_theme),

253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: update IEM_THEMES SET
256: classification_id = decode( p_classification_id, FND_API.G_MISS_NUM,null,null, classification_id, p_classification_id),
257: theme = decode(p_theme,FND_API.G_MISS_CHAR,null,null,theme,p_theme),
258: score = decode(p_score,FND_API.G_MISS_CHAR,null,null,score,p_score),
259: query_response = decode( p_query_response, FND_API.G_MISS_CHAR,null,null, query_response, p_query_response),
260: LAST_UPDATE_DATE = sysdate,
261: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),

Line 258: score = decode(p_score,FND_API.G_MISS_CHAR,null,null,score,p_score),

254:
255: update IEM_THEMES SET
256: classification_id = decode( p_classification_id, FND_API.G_MISS_NUM,null,null, classification_id, p_classification_id),
257: theme = decode(p_theme,FND_API.G_MISS_CHAR,null,null,theme,p_theme),
258: score = decode(p_score,FND_API.G_MISS_CHAR,null,null,score,p_score),
259: query_response = decode( p_query_response, FND_API.G_MISS_CHAR,null,null, query_response, p_query_response),
260: LAST_UPDATE_DATE = sysdate,
261: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
262: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),

Line 259: query_response = decode( p_query_response, FND_API.G_MISS_CHAR,null,null, query_response, p_query_response),

255: update IEM_THEMES SET
256: classification_id = decode( p_classification_id, FND_API.G_MISS_NUM,null,null, classification_id, p_classification_id),
257: theme = decode(p_theme,FND_API.G_MISS_CHAR,null,null,theme,p_theme),
258: score = decode(p_score,FND_API.G_MISS_CHAR,null,null,score,p_score),
259: query_response = decode( p_query_response, FND_API.G_MISS_CHAR,null,null, query_response, p_query_response),
260: LAST_UPDATE_DATE = sysdate,
261: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
262: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),

Line 263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),

259: query_response = decode( p_query_response, FND_API.G_MISS_CHAR,null,null, query_response, p_query_response),
260: LAST_UPDATE_DATE = sysdate,
261: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
262: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

Line 264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),

260: LAST_UPDATE_DATE = sysdate,
261: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
262: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

Line 265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),

261: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY, null,last_updated_by,l_LAST_UPDATED_BY),
262: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

Line 266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),

262: LAST_UPDATE_LOGIN = decode( l_LAST_UPDATE_LOGIN,null,last_update_login,l_LAST_UPDATE_LOGIN),
263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

Line 267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

263: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

Line 268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

264: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

Line 269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

265: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

Line 270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

266: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

Line 271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

267: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

Line 272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

268: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

Line 273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

269: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

Line 274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

270: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
278: where theme_id = p_theme_id;

Line 275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

271: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
278: where theme_id = p_theme_id;
279: -- Standard Check Of p_commit.

Line 276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

272: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
278: where theme_id = p_theme_id;
279: -- Standard Check Of p_commit.
280: IF FND_API.To_Boolean(p_commit) THEN

Line 277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

273: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
274: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
275: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
278: where theme_id = p_theme_id;
279: -- Standard Check Of p_commit.
280: IF FND_API.To_Boolean(p_commit) THEN
281: COMMIT WORK;

Line 280: IF FND_API.To_Boolean(p_commit) THEN

276: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
277: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
278: where theme_id = p_theme_id;
279: -- Standard Check Of p_commit.
280: IF FND_API.To_Boolean(p_commit) THEN
281: COMMIT WORK;
282: END IF;
283: -- Standard callto get message count and if count is 1, get message info.
284: FND_MSG_PUB.Count_And_Get

Line 289: WHEN FND_API.G_EXC_ERROR THEN

285: ( p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: EXCEPTION
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO update_item_PVT;
291: x_return_status := FND_API.G_RET_STS_ERROR ;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,

Line 291: x_return_status := FND_API.G_RET_STS_ERROR ;

287: );
288: EXCEPTION
289: WHEN FND_API.G_EXC_ERROR THEN
290: ROLLBACK TO update_item_PVT;
291: x_return_status := FND_API.G_RET_STS_ERROR ;
292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: FND_MSG_PUB.Count_And_Get
293: ( p_count => x_msg_count,
294: p_data => x_msg_data
295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO update_item_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,

Line 298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

294: p_data => x_msg_data
295: );
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: ROLLBACK TO update_item_PVT;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: );
303: WHEN IEM_DUPLICATE_THEME THEN
304: ROLLBACK TO update_item_PVT;
305: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: /*
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

Line 317: x_return_status := FND_API.G_RET_STS_ERROR;

313: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
314:
315: WHEN OTHERS THEN
316: ROLLBACK TO update_item_PVT;
317: x_return_status := FND_API.G_RET_STS_ERROR;
318: IF FND_MSG_PUB.Check_Msg_Level
319: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
320: THEN
321: FND_MSG_PUB.Add_Exc_Msg

Line 358: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

354: IEM_DUPLICATE_THEME EXCEPTION;
355:
356: BEGIN
357: SAVEPOINT create_item_jsp;
358: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
359: p_api_version_number,
360: l_api_name,
361: G_PKG_NAME)
362: THEN

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359: p_api_version_number,
360: l_api_name,
361: G_PKG_NAME)
362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF FND_API.to_Boolean( p_init_msg_list )
367: THEN

Line 366: IF FND_API.to_Boolean( p_init_msg_list )

362: THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365:
366: IF FND_API.to_Boolean( p_init_msg_list )
367: THEN
368: FND_MSG_PUB.initialize;
369: END IF;
370:

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: THEN
368: FND_MSG_PUB.initialize;
369: END IF;
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: select replace (replace ( replace (p_theme, '<', ''), '>', ''), '"', '''') into l_theme
374: from dual;
375:

Line 418: IF FND_API.To_Boolean(p_commit) THEN

414: x_return_status =>x_return_status,
415: x_msg_count => x_msg_count,
416: x_msg_data => x_msg_data);
417:
418: IF FND_API.To_Boolean(p_commit) THEN
419: COMMIT WORK;
420: END IF;
421:
422: FND_MSG_PUB.Count_And_Get

Line 431: x_return_status := FND_API.G_RET_STS_ERROR ;

427: WHEN IEM_DUPLICATE_THEME THEN
428: ROLLBACK TO create_item_jsp;
429: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
430: FND_MSG_PUB.Add;
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO create_item_jsp;

Line 434: WHEN FND_API.G_EXC_ERROR THEN

430: FND_MSG_PUB.Add;
431: x_return_status := FND_API.G_RET_STS_ERROR ;
432: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO create_item_jsp;
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,

Line 436: x_return_status := FND_API.G_RET_STS_ERROR ;

432: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
433:
434: WHEN FND_API.G_EXC_ERROR THEN
435: ROLLBACK TO create_item_jsp;
436: x_return_status := FND_API.G_RET_STS_ERROR ;
437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data
440: );

Line 441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

437: FND_MSG_PUB.Count_And_Get
438: ( p_count => x_msg_count,
439: p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: ROLLBACK TO create_item_jsp;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: FND_MSG_PUB.Count_And_Get
445: ( p_count => x_msg_count,

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

439: p_data => x_msg_data
440: );
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: ROLLBACK TO create_item_jsp;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
444: FND_MSG_PUB.Count_And_Get
445: ( p_count => x_msg_count,
446: p_data => x_msg_data
447: );

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446: p_data => x_msg_data
447: );
448: WHEN OTHERS THEN
449: ROLLBACK TO create_item_jsp;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: IF FND_MSG_PUB.Check_Msg_Level
452: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
453: THEN
454: FND_MSG_PUB.Add_Exc_Msg

Line 489: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

485: IEM_DUPLICATE_THEME EXCEPTION;
486:
487: BEGIN
488: SAVEPOINT create_item_jsp;
489: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
490: p_api_version_number,
491: l_api_name,
492: G_PKG_NAME)
493: THEN

Line 494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

490: p_api_version_number,
491: l_api_name,
492: G_PKG_NAME)
493: THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN

Line 497: IF FND_API.to_Boolean( p_init_msg_list )

493: THEN
494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
495: END IF;
496:
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:

Line 502: x_return_status := FND_API.G_RET_STS_SUCCESS;

498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501:
502: x_return_status := FND_API.G_RET_STS_SUCCESS;
503:
504: select replace (replace ( replace (p_theme, '<', ''), '>', ''), '"', '''') into l_theme
505: from dual;
506:

Line 549: IF FND_API.To_Boolean(p_commit) THEN

545: x_return_status =>x_return_status,
546: x_msg_count => x_msg_count,
547: x_msg_data => x_msg_data);
548:
549: IF FND_API.To_Boolean(p_commit) THEN
550: COMMIT WORK;
551: END IF;
552:
553: FND_MSG_PUB.Count_And_Get

Line 562: x_return_status := FND_API.G_RET_STS_ERROR ;

558: WHEN IEM_DUPLICATE_THEME THEN
559: ROLLBACK TO create_item_jsp;
560: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_KEYWORD');
561: FND_MSG_PUB.Add;
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_ERROR THEN
566: ROLLBACK TO create_item_jsp;

Line 565: WHEN FND_API.G_EXC_ERROR THEN

561: FND_MSG_PUB.Add;
562: x_return_status := FND_API.G_RET_STS_ERROR ;
563: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_ERROR THEN
566: ROLLBACK TO create_item_jsp;
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,

Line 567: x_return_status := FND_API.G_RET_STS_ERROR ;

563: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
564:
565: WHEN FND_API.G_EXC_ERROR THEN
566: ROLLBACK TO create_item_jsp;
567: x_return_status := FND_API.G_RET_STS_ERROR ;
568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

568: FND_MSG_PUB.Count_And_Get
569: ( p_count => x_msg_count,
570: p_data => x_msg_data
571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO create_item_jsp;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count,

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

570: p_data => x_msg_data
571: );
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO create_item_jsp;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count,
577: p_data => x_msg_data
578: );

Line 581: x_return_status := FND_API.G_RET_STS_ERROR;

577: p_data => x_msg_data
578: );
579: WHEN OTHERS THEN
580: ROLLBACK TO create_item_jsp;
581: x_return_status := FND_API.G_RET_STS_ERROR;
582: IF FND_MSG_PUB.Check_Msg_Level
583: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
584: THEN
585: FND_MSG_PUB.Add_Exc_Msg

Line 614: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

610:
611: --Standard Savepoint
612: SAVEPOINT delete_item_wrap;
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
615: p_api_version_number,
616: l_api_name,
617: G_PKG_NAME)
618: THEN

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

615: p_api_version_number,
616: l_api_name,
617: G_PKG_NAME)
618: THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621:
622: --Initialize the message list if p_init_msg_list is set to TRUE
623: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 623: If FND_API.to_Boolean(p_init_msg_list) THEN

619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621:
622: --Initialize the message list if p_init_msg_list is set to TRUE
623: If FND_API.to_Boolean(p_init_msg_list) THEN
624: FND_MSG_PUB.initialize;
625: END IF;
626:
627: --Initialize API status return

Line 628: x_return_status := FND_API.G_RET_STS_SUCCESS;

624: FND_MSG_PUB.initialize;
625: END IF;
626:
627: --Initialize API status return
628: x_return_status := FND_API.G_RET_STS_SUCCESS;
629:
630: --Actual API starts here
631: FORALL i IN p_thes_ids_tbl.FIRST..p_thes_ids_tbl.LAST
632: DELETE

Line 639: RAISE FND_API.G_EXC_ERROR;

635:
636: IF SQL%NOTFOUND THEN
637: FND_MESSAGE.SET_NAME('IEM', 'IEM_EXP_INVALID_ACCOUNT');
638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:
642: --Standard check of p_commit
643: IF FND_API.to_Boolean(p_commit) THEN

Line 643: IF FND_API.to_Boolean(p_commit) THEN

639: RAISE FND_API.G_EXC_ERROR;
640: END IF;
641:
642: --Standard check of p_commit
643: IF FND_API.to_Boolean(p_commit) THEN
644: COMMIT WORK;
645: END IF;
646:
647: -- Standard callto get message count and if count is 1, get message info.

Line 653: WHEN FND_API.G_EXC_ERROR THEN

649: ( p_count => x_msg_count,
650: p_data => x_msg_data
651: );
652: EXCEPTION
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO delete_item_wrap;
655: x_return_status := FND_API.G_RET_STS_ERROR ;
656: FND_MSG_PUB.Count_And_Get
657: ( p_count => x_msg_count,

Line 655: x_return_status := FND_API.G_RET_STS_ERROR ;

651: );
652: EXCEPTION
653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO delete_item_wrap;
655: x_return_status := FND_API.G_RET_STS_ERROR ;
656: FND_MSG_PUB.Count_And_Get
657: ( p_count => x_msg_count,
658: p_data => x_msg_data
659: );

Line 660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

656: FND_MSG_PUB.Count_And_Get
657: ( p_count => x_msg_count,
658: p_data => x_msg_data
659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO delete_item_wrap;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: FND_MSG_PUB.Count_And_Get
664: ( p_count => x_msg_count,

Line 662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

658: p_data => x_msg_data
659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO delete_item_wrap;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
663: FND_MSG_PUB.Count_And_Get
664: ( p_count => x_msg_count,
665: p_data => x_msg_data
666: );

Line 669: x_return_status := FND_API.G_RET_STS_ERROR;

665: p_data => x_msg_data
666: );
667: WHEN OTHERS THEN
668: ROLLBACK TO delete_item_wrap;
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: IF FND_MSG_PUB.Check_Msg_Level
671: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg

Line 706: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

702:
703: --Standard Savepoint
704: SAVEPOINT delete_item_wrap;
705: -- Standard call to check for call compatibility.
706: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
707: p_api_version_number,
708: l_api_name,
709: G_PKG_NAME)
710: THEN

Line 711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

707: p_api_version_number,
708: l_api_name,
709: G_PKG_NAME)
710: THEN
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;
713:
714: --Initialize the message list if p_init_msg_list is set to TRUE
715: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 715: If FND_API.to_Boolean(p_init_msg_list) THEN

711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;
713:
714: --Initialize the message list if p_init_msg_list is set to TRUE
715: If FND_API.to_Boolean(p_init_msg_list) THEN
716: FND_MSG_PUB.initialize;
717: END IF;
718:
719: --Initialize API status return

Line 720: x_return_status := FND_API.G_RET_STS_SUCCESS;

716: FND_MSG_PUB.initialize;
717: END IF;
718:
719: --Initialize API status return
720: x_return_status := FND_API.G_RET_STS_SUCCESS;
721:
722: --Actual API starts here
723: FOR j in p_thes_ids_tbl.FIRST..p_thes_ids_tbl.LAST LOOP
724: select classification_id into l_class_id

Line 751: RAISE FND_API.G_EXC_ERROR;

747:
748: IF SQL%NOTFOUND THEN
749: FND_MESSAGE.SET_NAME('IEM', 'IEM_EXP_INVALID_ACCOUNT');
750: FND_MSG_PUB.ADD;
751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: --Standard check of p_commit
755: IF FND_API.to_Boolean(p_commit) THEN

Line 755: IF FND_API.to_Boolean(p_commit) THEN

751: RAISE FND_API.G_EXC_ERROR;
752: END IF;
753:
754: --Standard check of p_commit
755: IF FND_API.to_Boolean(p_commit) THEN
756: COMMIT WORK;
757: END IF;
758:
759: -- Standard callto get message count and if count is 1, get message info.

Line 765: WHEN FND_API.G_EXC_ERROR THEN

761: ( p_count => x_msg_count,
762: p_data => x_msg_data
763: );
764: EXCEPTION
765: WHEN FND_API.G_EXC_ERROR THEN
766: ROLLBACK TO delete_item_wrap;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_And_Get
769: ( p_count => x_msg_count,

Line 767: x_return_status := FND_API.G_RET_STS_ERROR ;

763: );
764: EXCEPTION
765: WHEN FND_API.G_EXC_ERROR THEN
766: ROLLBACK TO delete_item_wrap;
767: x_return_status := FND_API.G_RET_STS_ERROR ;
768: FND_MSG_PUB.Count_And_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data
771: );

Line 772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

768: FND_MSG_PUB.Count_And_Get
769: ( p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: ROLLBACK TO delete_item_wrap;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775: FND_MSG_PUB.Count_And_Get
776: ( p_count => x_msg_count,

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

770: p_data => x_msg_data
771: );
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773: ROLLBACK TO delete_item_wrap;
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775: FND_MSG_PUB.Count_And_Get
776: ( p_count => x_msg_count,
777: p_data => x_msg_data
778: );

Line 781: x_return_status := FND_API.G_RET_STS_ERROR;

777: p_data => x_msg_data
778: );
779: WHEN OTHERS THEN
780: ROLLBACK TO delete_item_wrap;
781: x_return_status := FND_API.G_RET_STS_ERROR;
782: IF FND_MSG_PUB.Check_Msg_Level
783: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
784: THEN
785: FND_MSG_PUB.Add_Exc_Msg

Line 826: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

822: BEGIN
823: -- Standard Start of API savepoint
824: SAVEPOINT update_item_PVT;
825: -- Standard call to check for call compatibility.
826: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
827: p_api_version_number,
828: l_api_name,
829: G_PKG_NAME)
830: THEN

Line 831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

827: p_api_version_number,
828: l_api_name,
829: G_PKG_NAME)
830: THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833: -- Initialize message list if p_init_msg_list is set to TRUE.
834: IF FND_API.to_Boolean( p_init_msg_list )
835: THEN

Line 834: IF FND_API.to_Boolean( p_init_msg_list )

830: THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833: -- Initialize message list if p_init_msg_list is set to TRUE.
834: IF FND_API.to_Boolean( p_init_msg_list )
835: THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838: -- Initialize API return status to SUCCESS

Line 839: x_return_status := FND_API.G_RET_STS_SUCCESS;

835: THEN
836: FND_MSG_PUB.initialize;
837: END IF;
838: -- Initialize API return status to SUCCESS
839: x_return_status := FND_API.G_RET_STS_SUCCESS;
840:
841: select replace (replace ( replace (p_theme, '<', ''), '>', ''), '"', '''') into l_theme
842: from dual;
843:

Line 885: IF FND_API.To_Boolean(p_commit) THEN

881: x_msg_data => x_msg_data);
882:
883:
884: -- Standard Check Of p_commit.
885: IF FND_API.To_Boolean(p_commit) THEN
886: COMMIT WORK;
887: END IF;
888: -- Standard callto get message count and if count is 1, get message info.
889: FND_MSG_PUB.Count_And_Get

Line 898: x_return_status := FND_API.G_RET_STS_ERROR ;

894: WHEN IEM_DUPLICATE_THEME THEN
895: ROLLBACK TO update_item_PVT;
896: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_THEME');
897: FND_MSG_PUB.Add;
898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
900:
901:
902: WHEN FND_API.G_EXC_ERROR THEN

Line 902: WHEN FND_API.G_EXC_ERROR THEN

898: x_return_status := FND_API.G_RET_STS_ERROR ;
899: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
900:
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO update_item_PVT;
904: x_return_status := FND_API.G_RET_STS_ERROR ;
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count,

Line 904: x_return_status := FND_API.G_RET_STS_ERROR ;

900:
901:
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO update_item_PVT;
904: x_return_status := FND_API.G_RET_STS_ERROR ;
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count,
907: p_data => x_msg_data
908: );

Line 909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: ROLLBACK TO update_item_PVT;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
912: FND_MSG_PUB.Count_And_Get
913: ( p_count => x_msg_count,

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

907: p_data => x_msg_data
908: );
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: ROLLBACK TO update_item_PVT;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
912: FND_MSG_PUB.Count_And_Get
913: ( p_count => x_msg_count,
914: p_data => x_msg_data
915: );

Line 918: x_return_status := FND_API.G_RET_STS_ERROR;

914: p_data => x_msg_data
915: );
916: WHEN OTHERS THEN
917: ROLLBACK TO update_item_PVT;
918: x_return_status := FND_API.G_RET_STS_ERROR;
919: IF FND_MSG_PUB.Check_Msg_Level
920: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
921: THEN
922: FND_MSG_PUB.Add_Exc_Msg