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

Line 19: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

15: -- Pre-reqs : None.
16: -- Parameters :
17: -- IN
18: -- p_api_version_number IN NUMBER Required
19: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
20: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
21: -- p_account_name IN VARCHAR2,
22: -- p_email_user IN VARCHAR2,
23: -- p_domain IN VARCHAR2,

Line 20: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

16: -- Parameters :
17: -- IN
18: -- p_api_version_number IN NUMBER Required
19: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
20: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
21: -- p_account_name IN VARCHAR2,
22: -- p_email_user IN VARCHAR2,
23: -- p_domain IN VARCHAR2,
24: -- p_email_password IN VARCHAR2,

Line 25: -- p_account_profile IN VARCHAR2:=FND_API.G_MISS_CHAR,

21: -- p_account_name IN VARCHAR2,
22: -- p_email_user IN VARCHAR2,
23: -- p_domain IN VARCHAR2,
24: -- p_email_password IN VARCHAR2,
25: -- p_account_profile IN VARCHAR2:=FND_API.G_MISS_CHAR,
26: -- p_db_server_id IN NUMBER,
27: -- p_server_group_id IN NUMBER,
28: --
29: -- OUT

Line 84: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

80: -- Standard Start of API savepoint
81: SAVEPOINT create_item_PVT;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
85: p_api_version_number,
86: l_api_name,
87: G_PKG_NAME)
88: THEN

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: p_api_version_number,
86: l_api_name,
87: G_PKG_NAME)
88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: -- Initialize message list if p_init_msg_list is set to TRUE.
93: IF FND_API.to_Boolean( p_init_msg_list )

Line 93: IF FND_API.to_Boolean( p_init_msg_list )

89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: -- Initialize message list if p_init_msg_list is set to TRUE.
93: IF FND_API.to_Boolean( p_init_msg_list )
94: THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97:

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Initialize API return status to SUCCESS
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: -- Take this out. Handle duplicates in exception handling.
102: SELECT count(*) into l_cnt from iem_classifications WHERE EMAIL_ACCOUNT_ID=p_email_account_id AND
103: CLASSIFICATION=p_classification AND rownum=1;

Line 158: x_return_status := FND_API.G_RET_STS_SUCCESS;

154: p_ATTRIBUTE13,
155: p_ATTRIBUTE14,
156: p_ATTRIBUTE15);
157: ELSE
158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: END IF;
160:
161: -- Standard Check Of p_commit.
162: IF FND_API.To_Boolean(p_commit) THEN

Line 162: IF FND_API.To_Boolean(p_commit) THEN

158: x_return_status := FND_API.G_RET_STS_SUCCESS;
159: END IF;
160:
161: -- Standard Check Of p_commit.
162: IF FND_API.To_Boolean(p_commit) THEN
163: COMMIT WORK;
164: END IF;
165: -- Standard callto get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: ( p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO create_item_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,

Line 173: x_return_status := FND_API.G_RET_STS_ERROR ;

169: );
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: ROLLBACK TO create_item_PVT;
173: x_return_status := FND_API.G_RET_STS_ERROR ;
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,
176: p_data => x_msg_data
177: );

Line 178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO update_item_PVT;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: ( p_count => x_msg_count,

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

176: p_data => x_msg_data
177: );
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO update_item_PVT;
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
181: FND_MSG_PUB.Count_And_Get
182: ( p_count => x_msg_count,
183: p_data => x_msg_data
184: );

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183: p_data => x_msg_data
184: );
185: WHEN OTHERS THEN
186: ROLLBACK TO create_item_PVT;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level
189: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
190: THEN
191: FND_MSG_PUB.Add_Exc_Msg

Line 212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

208: -- Pre-reqs : None.
209: -- Parameters :
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
215: -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
216:

Line 213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

209: -- Parameters :
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
215: -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
216:
217: -- OUT

Line 214: -- p_email_account_id in number:=FND_API.G_MISS_NUM,

210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
215: -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
216:
217: -- OUT
218: -- x_return_status OUT VARCHAR2

Line 215: -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,

211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_email_account_id in number:=FND_API.G_MISS_NUM,
215: -- p_account_name IN VARCHAR2 :=FND_API.G_MISS_CHAR,
216:
217: -- OUT
218: -- x_return_status OUT VARCHAR2
219: -- x_msg_count OUT NUMBER

Line 245: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT delete_item_PVT;
244: -- Standard call to check for call compatibility.
245: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
246: p_api_version_number,
247: l_api_name,
248: G_PKG_NAME)
249: THEN

Line 250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

246: p_api_version_number,
247: l_api_name,
248: G_PKG_NAME)
249: THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252: -- Initialize message list if p_init_msg_list is set to TRUE.
253: IF FND_API.to_Boolean( p_init_msg_list )
254: THEN

Line 253: IF FND_API.to_Boolean( p_init_msg_list )

249: THEN
250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
251: END IF;
252: -- Initialize message list if p_init_msg_list is set to TRUE.
253: IF FND_API.to_Boolean( p_init_msg_list )
254: THEN
255: FND_MSG_PUB.initialize;
256: END IF;
257: -- Initialize API return status to SUCCESS

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: THEN
255: FND_MSG_PUB.initialize;
256: END IF;
257: -- Initialize API return status to SUCCESS
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: IF p_classification_id IS NOT NULL THEN
260: DELETE FROM IEM_THEMES
261: WHERE CLASSIFICATION_ID=p_classification_id;
262: DELETE FROM IEM_CLASSIFICATIONS

Line 271: IF FND_API.To_Boolean(p_commit) THEN

267: AND CLASSIFICATION=P_CLASSIFICATION;
268: END IF;
269:
270: -- Standard Check Of p_commit.
271: IF FND_API.To_Boolean(p_commit) THEN
272: COMMIT WORK;
273: END IF;
274: -- Standard callto get message count and if count is 1, get message info.
275: FND_MSG_PUB.Count_And_Get

Line 280: WHEN FND_API.G_EXC_ERROR THEN

276: ( p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO delete_item_PVT;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_And_Get
284: ( p_count => x_msg_count,

Line 282: x_return_status := FND_API.G_RET_STS_ERROR ;

278: );
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: ROLLBACK TO delete_item_PVT;
282: x_return_status := FND_API.G_RET_STS_ERROR ;
283: FND_MSG_PUB.Count_And_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data
286: );

Line 287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

283: FND_MSG_PUB.Count_And_Get
284: ( p_count => x_msg_count,
285: p_data => x_msg_data
286: );
287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
288: ROLLBACK TO delete_item_PVT;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290: FND_MSG_PUB.Count_And_Get
291: ( p_count => x_msg_count,

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: p_data => x_msg_data
293: );
294: WHEN OTHERS THEN
295: ROLLBACK TO delete_item_PVT;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: IF FND_MSG_PUB.Check_Msg_Level
298: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg

Line 320: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

316: -- Pre-reqs : None.
317: -- Parameters :
318: -- IN
319: -- p_api_version_number IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
322: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
323: -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,
324: -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,

Line 321: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

317: -- Parameters :
318: -- IN
319: -- p_api_version_number IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
322: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
323: -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,
324: -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: --

Line 322: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,

318: -- IN
319: -- p_api_version_number IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
322: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
323: -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,
324: -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: --
326: -- OUT

Line 323: -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,

319: -- p_api_version_number IN NUMBER Required
320: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
322: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
323: -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,
324: -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: --
326: -- OUT
327: -- x_return_status OUT VARCHAR2

Line 324: -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,

320: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
321: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
322: -- p_classification_id IN NUMBER:=FND_API.G_MISS_NUM,
323: -- p_email_account_id IN NUMBER:=FND_API.G_MISS_NUM,
324: -- p_classification IN VARCHAR2:=FND_API.G_MISS_CHAR,
325: --
326: -- OUT
327: -- x_return_status OUT VARCHAR2
328: -- x_msg_count OUT NUMBER

Line 378: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

374: -- Standard Start of API savepoint
375: SAVEPOINT update_item_PVT;
376:
377: -- Standard call to check for call compatibility.
378: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
379: p_api_version_number,
380: l_api_name,
381: G_PKG_NAME)
382: THEN

Line 383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

379: p_api_version_number,
380: l_api_name,
381: G_PKG_NAME)
382: THEN
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385: -- Initialize message list if p_init_msg_list is set to TRUE.
386: IF FND_API.to_Boolean( p_init_msg_list )
387: THEN

Line 386: IF FND_API.to_Boolean( p_init_msg_list )

382: THEN
383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
384: END IF;
385: -- Initialize message list if p_init_msg_list is set to TRUE.
386: IF FND_API.to_Boolean( p_init_msg_list )
387: THEN
388: FND_MSG_PUB.initialize;
389: END IF;
390: -- Initialize API return status to SUCCESS

Line 391: x_return_status := FND_API.G_RET_STS_SUCCESS;

387: THEN
388: FND_MSG_PUB.initialize;
389: END IF;
390: -- Initialize API return status to SUCCESS
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392: UPDATE IEM_CLASSIFICATIONS
393: SET CLASSIFICATION=decode(p_classification,FND_API.G_MISS_CHAR,null,null,CLASSIFICATION,p_CLASSIFICATION),
394: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
395: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),

Line 393: SET CLASSIFICATION=decode(p_classification,FND_API.G_MISS_CHAR,null,null,CLASSIFICATION,p_CLASSIFICATION),

389: END IF;
390: -- Initialize API return status to SUCCESS
391: x_return_status := FND_API.G_RET_STS_SUCCESS;
392: UPDATE IEM_CLASSIFICATIONS
393: SET CLASSIFICATION=decode(p_classification,FND_API.G_MISS_CHAR,null,null,CLASSIFICATION,p_CLASSIFICATION),
394: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
395: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
396: LAST_UPDATE_LOGIN =decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),

Line 397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),

393: SET CLASSIFICATION=decode(p_classification,FND_API.G_MISS_CHAR,null,null,CLASSIFICATION,p_CLASSIFICATION),
394: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
395: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
396: LAST_UPDATE_LOGIN =decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),
398: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),

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

394: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,
395: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
396: LAST_UPDATE_LOGIN =decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),
398: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),

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

395: LAST_UPDATED_BY = decode(l_LAST_UPDATED_BY,null,-1,l_LAST_UPDATED_BY),
396: LAST_UPDATE_LOGIN =decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),
398: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),

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

396: LAST_UPDATE_LOGIN =decode(l_LAST_UPDATE_LOGIN,null,-1,l_LAST_UPDATE_LOGIN),
397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),
398: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),

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

397: EMAIL_ACCOUNT_ID =decode(p_email_account_id,FND_API.G_MISS_NUM,EMAIL_ACCOUNT_ID,p_email_account_id),
398: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),

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

398: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE1, p_ATTRIBUTE1),
399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),

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

399: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE2, p_ATTRIBUTE2),
400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),

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

400: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE3, p_ATTRIBUTE3),
401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),

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

401: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE4, p_ATTRIBUTE4),
402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),

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

402: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, null,null,ATTRIBUTE5, p_ATTRIBUTE5),
403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),

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

403: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE6, p_ATTRIBUTE6),
404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),

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

404: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE7, p_ATTRIBUTE7),
405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)

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

405: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE8, p_ATTRIBUTE8),
406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
413: WHERE CLASSIFICATION_ID=p_classification_id;

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

406: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE9, p_ATTRIBUTE9),
407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
413: WHERE CLASSIFICATION_ID=p_classification_id;
414:

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

407: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE10, p_ATTRIBUTE10),
408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
413: WHERE CLASSIFICATION_ID=p_classification_id;
414:
415: -- Standard Check Of p_commit.

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

408: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE11, p_ATTRIBUTE11),
409: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE12, p_ATTRIBUTE12),
410: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE13, p_ATTRIBUTE13),
411: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE14, p_ATTRIBUTE14),
412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
413: WHERE CLASSIFICATION_ID=p_classification_id;
414:
415: -- Standard Check Of p_commit.
416: IF FND_API.To_Boolean(p_commit) THEN

Line 416: IF FND_API.To_Boolean(p_commit) THEN

412: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR,null,null, ATTRIBUTE15, p_ATTRIBUTE15)
413: WHERE CLASSIFICATION_ID=p_classification_id;
414:
415: -- Standard Check Of p_commit.
416: IF FND_API.To_Boolean(p_commit) THEN
417: COMMIT WORK;
418: END IF;
419: -- Standard callto get message count and if count is 1, get message info.
420: FND_MSG_PUB.Count_And_Get

Line 425: WHEN FND_API.G_EXC_ERROR THEN

421: ( p_count => x_msg_count,
422: p_data => x_msg_data
423: );
424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO update_item_PVT;
427: x_return_status := FND_API.G_RET_STS_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,

Line 427: x_return_status := FND_API.G_RET_STS_ERROR ;

423: );
424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: ROLLBACK TO update_item_PVT;
427: x_return_status := FND_API.G_RET_STS_ERROR ;
428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,
430: p_data => x_msg_data
431: );

Line 432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

428: FND_MSG_PUB.Count_And_Get
429: ( p_count => x_msg_count,
430: p_data => x_msg_data
431: );
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: ROLLBACK TO update_item_PVT;
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: FND_MSG_PUB.Count_And_Get
436: ( p_count => x_msg_count,

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438: );
439: WHEN IEM_DUPLICATE_CLASS THEN
440: ROLLBACK TO update_item_PVT;
441: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_CLASSIFICATION');
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
444: THEN
445: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
446: END IF;

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446: END IF;
447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
448: WHEN OTHERS THEN
449: ROLLBACK TO update_item_PVT;
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 491: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 499: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: THEN
501: FND_MSG_PUB.initialize;
502: END IF;
503:
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Take this out when create_item procedure handles duplicates in the exception block.
507: SELECT count(*) into l_cnt from iem_classifications WHERE EMAIL_ACCOUNT_ID=p_email_account_id AND
508: CLASSIFICATION=p_classification AND rownum=1;

Line 557: IF FND_API.To_Boolean(p_commit) THEN

553: x_return_status =>x_return_status,
554: x_msg_count => x_msg_count,
555: x_msg_data => x_msg_data);
556:
557: IF FND_API.To_Boolean(p_commit) THEN
558: COMMIT WORK;
559: END IF;
560:
561: FND_MSG_PUB.Count_And_Get

Line 570: x_return_status := FND_API.G_RET_STS_ERROR ;

566: WHEN IEM_DUP_CLASS THEN
567: ROLLBACK TO create_item_jsp;
568: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_CLASSIFICATION');
569: FND_MSG_PUB.Add;
570: x_return_status := FND_API.G_RET_STS_ERROR ;
571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
572:
573: WHEN FND_API.G_EXC_ERROR THEN
574: ROLLBACK TO create_item_jsp;

Line 573: WHEN FND_API.G_EXC_ERROR THEN

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

Line 575: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

576: FND_MSG_PUB.Count_And_Get
577: ( p_count => x_msg_count,
578: p_data => x_msg_data
579: );
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO create_item_jsp;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,

Line 582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

578: p_data => x_msg_data
579: );
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: ROLLBACK TO create_item_jsp;
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
583: FND_MSG_PUB.Count_And_Get
584: ( p_count => x_msg_count,
585: p_data => x_msg_data
586: );

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: p_data => x_msg_data
586: );
587: WHEN OTHERS THEN
588: ROLLBACK TO create_item_jsp;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: IF FND_MSG_PUB.Check_Msg_Level
591: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg

Line 630: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

626: IEM_DUP_CLASS EXCEPTION;
627:
628: BEGIN
629: SAVEPOINT create_item_jsp;
630: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
631: p_api_version_number,
632: l_api_name,
633: G_PKG_NAME)
634: THEN

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

631: p_api_version_number,
632: l_api_name,
633: G_PKG_NAME)
634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637:
638: IF FND_API.to_Boolean( p_init_msg_list )
639: THEN

Line 638: IF FND_API.to_Boolean( p_init_msg_list )

634: THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END IF;
637:
638: IF FND_API.to_Boolean( p_init_msg_list )
639: THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:

Line 643: x_return_status := FND_API.G_RET_STS_SUCCESS;

639: THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
644:
645: -- Take this out when create_item procedure handles duplicates in the exception block.
646: SELECT count(*) into l_cnt from iem_classifications WHERE EMAIL_ACCOUNT_ID=p_email_account_id AND
647: CLASSIFICATION=p_classification AND rownum=1;

Line 696: IF FND_API.To_Boolean(p_commit) THEN

692: x_return_status =>x_return_status,
693: x_msg_count => x_msg_count,
694: x_msg_data => x_msg_data);
695:
696: IF FND_API.To_Boolean(p_commit) THEN
697: COMMIT WORK;
698: END IF;
699:
700: FND_MSG_PUB.Count_And_Get

Line 709: x_return_status := FND_API.G_RET_STS_ERROR ;

705: WHEN IEM_DUP_CLASS THEN
706: ROLLBACK TO create_item_jsp;
707: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_INTENT');
708: FND_MSG_PUB.Add;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO create_item_jsp;

Line 712: WHEN FND_API.G_EXC_ERROR THEN

708: FND_MSG_PUB.Add;
709: x_return_status := FND_API.G_RET_STS_ERROR ;
710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO create_item_jsp;
714: x_return_status := FND_API.G_RET_STS_ERROR ;
715: FND_MSG_PUB.Count_And_Get
716: ( p_count => x_msg_count,

Line 714: x_return_status := FND_API.G_RET_STS_ERROR ;

710: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
711:
712: WHEN FND_API.G_EXC_ERROR THEN
713: ROLLBACK TO create_item_jsp;
714: x_return_status := FND_API.G_RET_STS_ERROR ;
715: FND_MSG_PUB.Count_And_Get
716: ( p_count => x_msg_count,
717: p_data => x_msg_data
718: );

Line 719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

715: FND_MSG_PUB.Count_And_Get
716: ( p_count => x_msg_count,
717: p_data => x_msg_data
718: );
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_item_jsp;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: FND_MSG_PUB.Count_And_Get
723: ( p_count => x_msg_count,

Line 721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

717: p_data => x_msg_data
718: );
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_item_jsp;
721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
722: FND_MSG_PUB.Count_And_Get
723: ( p_count => x_msg_count,
724: p_data => x_msg_data
725: );

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

724: p_data => x_msg_data
725: );
726: WHEN OTHERS THEN
727: ROLLBACK TO create_item_jsp;
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: IF FND_MSG_PUB.Check_Msg_Level
730: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg

Line 761: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

757:
758: --Standard Savepoint
759: SAVEPOINT delete_item_wrap;
760: -- Standard call to check for call compatibility.
761: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
762: p_api_version_number,
763: l_api_name,
764: G_PKG_NAME)
765: THEN

Line 766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

762: p_api_version_number,
763: l_api_name,
764: G_PKG_NAME)
765: THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: END IF;
768:
769: --Initialize the message list if p_init_msg_list is set to TRUE
770: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 770: If FND_API.to_Boolean(p_init_msg_list) THEN

766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: END IF;
768:
769: --Initialize the message list if p_init_msg_list is set to TRUE
770: If FND_API.to_Boolean(p_init_msg_list) THEN
771: FND_MSG_PUB.initialize;
772: END IF;
773:
774: --Initialize API status return

Line 775: x_return_status := FND_API.G_RET_STS_SUCCESS;

771: FND_MSG_PUB.initialize;
772: END IF;
773:
774: --Initialize API status return
775: x_return_status := FND_API.G_RET_STS_SUCCESS;
776:
777: --Actual API starts here
778: FOR i IN p_clas_ids_tbl.FIRST..p_clas_ids_tbl.LAST
779: LOOP

Line 791: RAISE FND_API.G_EXC_ERROR;

787:
788: IF SQL%NOTFOUND THEN
789: FND_MESSAGE.SET_NAME('IEM', 'IEM_EXP_INVALID_ACCOUNT');
790: FND_MSG_PUB.ADD;
791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: --Standard check of p_commit
795: IF FND_API.to_Boolean(p_commit) THEN

Line 795: IF FND_API.to_Boolean(p_commit) THEN

791: RAISE FND_API.G_EXC_ERROR;
792: END IF;
793:
794: --Standard check of p_commit
795: IF FND_API.to_Boolean(p_commit) THEN
796: COMMIT WORK;
797: END IF;
798:
799: -- Standard callto get message count and if count is 1, get message info.

Line 805: WHEN FND_API.G_EXC_ERROR THEN

801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN
806: ROLLBACK TO delete_item_wrap;
807: x_return_status := FND_API.G_RET_STS_ERROR ;
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,

Line 807: x_return_status := FND_API.G_RET_STS_ERROR ;

803: );
804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN
806: ROLLBACK TO delete_item_wrap;
807: x_return_status := FND_API.G_RET_STS_ERROR ;
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );

Line 812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO delete_item_wrap;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815: FND_MSG_PUB.Count_And_Get
816: ( p_count => x_msg_count,

Line 814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

810: p_data => x_msg_data
811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: ROLLBACK TO delete_item_wrap;
814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
815: FND_MSG_PUB.Count_And_Get
816: ( p_count => x_msg_count,
817: p_data => x_msg_data
818: );

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817: p_data => x_msg_data
818: );
819: WHEN OTHERS THEN
820: ROLLBACK TO delete_item_wrap;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: IF FND_MSG_PUB.Check_Msg_Level
823: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
824: THEN
825: FND_MSG_PUB.Add_Exc_Msg

Line 858: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

854:
855: --Standard Savepoint
856: SAVEPOINT delete_item_wrap;
857: -- Standard call to check for call compatibility.
858: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
859: p_api_version_number,
860: l_api_name,
861: G_PKG_NAME)
862: THEN

Line 863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

859: p_api_version_number,
860: l_api_name,
861: G_PKG_NAME)
862: THEN
863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
866: --Initialize the message list if p_init_msg_list is set to TRUE
867: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 867: If FND_API.to_Boolean(p_init_msg_list) THEN

863: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
864: END IF;
865:
866: --Initialize the message list if p_init_msg_list is set to TRUE
867: If FND_API.to_Boolean(p_init_msg_list) THEN
868: FND_MSG_PUB.initialize;
869: END IF;
870:
871: --Initialize API status return

Line 872: x_return_status := FND_API.G_RET_STS_SUCCESS;

868: FND_MSG_PUB.initialize;
869: END IF;
870:
871: --Initialize API status return
872: x_return_status := FND_API.G_RET_STS_SUCCESS;
873:
874: --Actual API starts here
875: FOR j in p_clas_ids_tbl.FIRST..p_clas_ids_tbl.LAST LOOP
876: l_class_id:=p_clas_ids_tbl(j);

Line 905: IF FND_API.to_Boolean(p_commit) THEN

901: 'R' ,
902: l_status );
903:
904: --Standard check of p_commit
905: IF FND_API.to_Boolean(p_commit) THEN
906: COMMIT WORK;
907: END IF;
908:
909: -- Standard callto get message count and if count is 1, get message info.

Line 915: WHEN FND_API.G_EXC_ERROR THEN

911: ( p_count => x_msg_count,
912: p_data => x_msg_data
913: );
914: EXCEPTION
915: WHEN FND_API.G_EXC_ERROR THEN
916: ROLLBACK TO delete_item_wrap;
917: x_return_status := FND_API.G_RET_STS_ERROR ;
918: FND_MSG_PUB.Count_And_Get
919: ( p_count => x_msg_count,

Line 917: x_return_status := FND_API.G_RET_STS_ERROR ;

913: );
914: EXCEPTION
915: WHEN FND_API.G_EXC_ERROR THEN
916: ROLLBACK TO delete_item_wrap;
917: x_return_status := FND_API.G_RET_STS_ERROR ;
918: FND_MSG_PUB.Count_And_Get
919: ( p_count => x_msg_count,
920: p_data => x_msg_data
921: );

Line 922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

918: FND_MSG_PUB.Count_And_Get
919: ( p_count => x_msg_count,
920: p_data => x_msg_data
921: );
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923: ROLLBACK TO delete_item_wrap;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get
926: ( p_count => x_msg_count,

Line 924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

920: p_data => x_msg_data
921: );
922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
923: ROLLBACK TO delete_item_wrap;
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get
926: ( p_count => x_msg_count,
927: p_data => x_msg_data
928: );

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: p_data => x_msg_data
928: );
929: WHEN OTHERS THEN
930: ROLLBACK TO delete_item_wrap;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: IF FND_MSG_PUB.Check_Msg_Level
933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
934: THEN
935: FND_MSG_PUB.Add_Exc_Msg

Line 974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

970: BEGIN
971: -- Standard Start of API savepoint
972: SAVEPOINT update_item_PVT;
973: -- Standard call to check for call compatibility.
974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
975: p_api_version_number,
976: l_api_name,
977: G_PKG_NAME)
978: THEN

Line 979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

975: p_api_version_number,
976: l_api_name,
977: G_PKG_NAME)
978: THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: -- Initialize message list if p_init_msg_list is set to TRUE.
982: IF FND_API.to_Boolean( p_init_msg_list )
983: THEN

Line 982: IF FND_API.to_Boolean( p_init_msg_list )

978: THEN
979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
980: END IF;
981: -- Initialize message list if p_init_msg_list is set to TRUE.
982: IF FND_API.to_Boolean( p_init_msg_list )
983: THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986: -- Initialize API return status to SUCCESS

Line 987: x_return_status := FND_API.G_RET_STS_SUCCESS;

983: THEN
984: FND_MSG_PUB.initialize;
985: END IF;
986: -- Initialize API return status to SUCCESS
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: select replace (replace ( replace (p_classification, '<', ''), '>', ''), '"', '''') into l_classification
990: from dual;
991:

Line 1032: IF FND_API.To_Boolean(p_commit) THEN

1028: x_msg_data => x_msg_data);
1029:
1030:
1031: -- Standard Check Of p_commit.
1032: IF FND_API.To_Boolean(p_commit) THEN
1033: COMMIT WORK;
1034: END IF;
1035: -- Standard callto get message count and if count is 1, get message info.
1036: FND_MSG_PUB.Count_And_Get

Line 1041: WHEN FND_API.G_EXC_ERROR THEN

1037: ( p_count => x_msg_count,
1038: p_data => x_msg_data
1039: );
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO update_item_PVT;
1043: x_return_status := FND_API.G_RET_STS_ERROR ;
1044: FND_MSG_PUB.Count_And_Get
1045: ( p_count => x_msg_count,

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR ;

1039: );
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO update_item_PVT;
1043: x_return_status := FND_API.G_RET_STS_ERROR ;
1044: FND_MSG_PUB.Count_And_Get
1045: ( p_count => x_msg_count,
1046: p_data => x_msg_data
1047: );

Line 1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1044: FND_MSG_PUB.Count_And_Get
1045: ( p_count => x_msg_count,
1046: p_data => x_msg_data
1047: );
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: ROLLBACK TO update_item_PVT;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count,

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1046: p_data => x_msg_data
1047: );
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: ROLLBACK TO update_item_PVT;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count,
1053: p_data => x_msg_data
1054: );

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

1053: p_data => x_msg_data
1054: );
1055: WHEN OTHERS THEN
1056: ROLLBACK TO update_item_PVT;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg

Line 1101: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1097: BEGIN
1098: -- Standard Start of API savepoint
1099: SAVEPOINT update_item_PVT;
1100: -- Standard call to check for call compatibility.
1101: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1102: p_api_version_number,
1103: l_api_name,
1104: G_PKG_NAME)
1105: THEN

Line 1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1102: p_api_version_number,
1103: l_api_name,
1104: G_PKG_NAME)
1105: THEN
1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1107: END IF;
1108: -- Initialize message list if p_init_msg_list is set to TRUE.
1109: IF FND_API.to_Boolean( p_init_msg_list )
1110: THEN

Line 1109: IF FND_API.to_Boolean( p_init_msg_list )

1105: THEN
1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1107: END IF;
1108: -- Initialize message list if p_init_msg_list is set to TRUE.
1109: IF FND_API.to_Boolean( p_init_msg_list )
1110: THEN
1111: FND_MSG_PUB.initialize;
1112: END IF;
1113: -- Initialize API return status to SUCCESS

Line 1114: x_return_status := FND_API.G_RET_STS_SUCCESS;

1110: THEN
1111: FND_MSG_PUB.initialize;
1112: END IF;
1113: -- Initialize API return status to SUCCESS
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: select replace (replace ( replace (p_classification, '<', ''), '>', ''), '"', '''') into l_classification
1117: from dual;
1118:

Line 1181: IF FND_API.To_Boolean(p_commit) THEN

1177: l_status );
1178: END IF;
1179:
1180: -- Standard Check Of p_commit.
1181: IF FND_API.To_Boolean(p_commit) THEN
1182: COMMIT WORK;
1183: END IF;
1184: -- Standard callto get message count and if count is 1, get message info.
1185: FND_MSG_PUB.Count_And_Get

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR ;

1189: EXCEPTION
1190: WHEN DUPLICATE_INTENT THEN
1191: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_INTENT');
1192: FND_MSG_PUB.Add;
1193: x_return_status := FND_API.G_RET_STS_ERROR ;
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );

Line 1199: WHEN FND_API.G_EXC_ERROR THEN

1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );
1198:
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK TO update_item_PVT;
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count,

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR ;

1197: );
1198:
1199: WHEN FND_API.G_EXC_ERROR THEN
1200: ROLLBACK TO update_item_PVT;
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: FND_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );

Line 1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1202: FND_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207: ROLLBACK TO update_item_PVT;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: FND_MSG_PUB.Count_And_Get
1210: ( p_count => x_msg_count,

Line 1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1204: p_data => x_msg_data
1205: );
1206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1207: ROLLBACK TO update_item_PVT;
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: FND_MSG_PUB.Count_And_Get
1210: ( p_count => x_msg_count,
1211: p_data => x_msg_data
1212: );

Line 1215: x_return_status := FND_API.G_RET_STS_ERROR;

1211: p_data => x_msg_data
1212: );
1213: WHEN OTHERS THEN
1214: ROLLBACK TO update_item_PVT;
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: IF FND_MSG_PUB.Check_Msg_Level
1217: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1218: THEN
1219: FND_MSG_PUB.Add_Exc_Msg