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

Line 48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

44: --Standard Savepoint
45: SAVEPOINT delete_item_batch;
46:
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56:
57:

Line 59: If FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: --Initialize API status return
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: --Actual API starts here
67: if ( p_tagKey_ids_tbl.count <> 0 ) then
68:

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

115:
116: --add names of un_deleted tags into message
117: if l_used_tag_name is not null then
118: l_used_tag_name := RTRIM(l_used_tag_name, ', ');
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: FND_MESSAGE.SET_NAME('IEM', 'IEM_ADMIN_TAG_NOT_DELETED');
121: FND_MESSAGE.SET_TOKEN('TAG', l_used_tag_name);
122: FND_MSG_PUB.ADD;
123: /* FND_MSG_PUB.Count_And_Get

Line 131: IF FND_API.to_Boolean(p_commit) THEN

127: */
128: end if;
129:
130: --Standard check of p_commit
131: IF FND_API.to_Boolean(p_commit) THEN
132: COMMIT WORK;
133: END IF;
134: FND_MSG_PUB.Count_And_Get
135: ( p_count => x_msg_count,

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139: EXCEPTION
140:
141: WHEN IEM_TAG_NOT_DELETED THEN
142: ROLLBACK TO delete_item_batch;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MESSAGE.SET_NAME('IEM', 'IEM_TAG_NOT_DELETED');
145:
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 149: WHEN FND_API.G_EXC_ERROR THEN

145:
146: FND_MSG_PUB.ADD;
147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO delete_item_batch;
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: FND_MSG_PUB.Count_And_Get
153: ( p_count => x_msg_count,p_data => x_msg_data);

Line 151: x_return_status := FND_API.G_RET_STS_ERROR ;

147: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO delete_item_batch;
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: FND_MSG_PUB.Count_And_Get
153: ( p_count => x_msg_count,p_data => x_msg_data);
154:
155:

Line 156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

154:
155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO delete_item_batch;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
160:
161:
162: WHEN OTHERS THEN

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160:
161:
162: WHEN OTHERS THEN
163: ROLLBACK TO delete_item_batch;
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
166: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
167: END IF;
168:

Line 196: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

192: --Standard Savepoint
193: SAVEPOINT delete_association_on_acct_ID;
194:
195: -- Standard call to check for call compatibility.
196: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
200: THEN

Line 201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

197: p_api_version_number,
198: l_api_name,
199: G_PKG_NAME)
200: THEN
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202: END IF;
203:
204:
205:

Line 207: If FND_API.to_Boolean(p_init_msg_list) THEN

203:
204:
205:
206: --Initialize the message list if p_init_msg_list is set to TRUE
207: If FND_API.to_Boolean(p_init_msg_list) THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210:
211: --Initialize API status return

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: FND_MSG_PUB.initialize;
209: END IF;
210:
211: --Initialize API status return
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213:
214: --Actual API starts here
215: l_acct_id := LTRIM(RTRIM(p_email_acct_id));
216: delete from iem_account_tag_keys where email_account_id = l_acct_id;

Line 219: IF FND_API.to_Boolean(p_commit) THEN

215: l_acct_id := LTRIM(RTRIM(p_email_acct_id));
216: delete from iem_account_tag_keys where email_account_id = l_acct_id;
217:
218: --Standard check of p_commit
219: IF FND_API.to_Boolean(p_commit) THEN
220: COMMIT WORK;
221: END IF;
222:
223:

Line 226: WHEN FND_API.G_EXC_ERROR THEN

222:
223:
224: EXCEPTION
225:
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO delete_acct_tag_on_acct_ID;
228: x_return_status := FND_API.G_RET_STS_ERROR ;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,p_data => x_msg_data);

Line 228: x_return_status := FND_API.G_RET_STS_ERROR ;

224: EXCEPTION
225:
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO delete_acct_tag_on_acct_ID;
228: x_return_status := FND_API.G_RET_STS_ERROR ;
229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,p_data => x_msg_data);
231:
232:

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: FND_MSG_PUB.Count_And_Get
230: ( p_count => x_msg_count,p_data => x_msg_data);
231:
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ROLLBACK TO delete_acct_tag_on_acct_ID;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
237:

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

231:
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234: ROLLBACK TO delete_acct_tag_on_acct_ID;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
237:
238:
239: WHEN OTHERS THEN

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237:
238:
239: WHEN OTHERS THEN
240: ROLLBACK TO delete_acct_tag_on_acct_ID;
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
243: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
244: END IF;
245:

Line 266: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

262: l_api_name VARCHAR2(255):='create_item_tag';
263: l_api_version_number NUMBER:=1.0;
264: l_seq_id NUMBER;
265:
266: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
267: l_msg_count NUMBER := 0;
268: l_msg_data VARCHAR2(2000);
269:
270: l_name_count NUMBER;

Line 294: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

290: SAVEPOINT create_item_tag_PVT;
291:
292: -- Standard call to check for call compatibility.
293:
294: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
295: p_api_version_number,
296: l_api_name,
297: G_PKG_NAME)
298: THEN

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: p_api_version_number,
296: l_api_name,
297: G_PKG_NAME)
298: THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302:
303: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 304: IF FND_API.to_Boolean( p_init_msg_list )

300: END IF;
301:
302:
303: -- Initialize message list if p_init_msg_list is set to TRUE.
304: IF FND_API.to_Boolean( p_init_msg_list )
305: THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:

Line 311: x_return_status := FND_API.G_RET_STS_SUCCESS;

307: END IF;
308:
309:
310: -- Initialize API return status to SUCCESS
311: x_return_status := FND_API.G_RET_STS_SUCCESS;
312:
313: --begins here
314: --Valid no Null passed in for NOT_NULL parameters
315: if ( p_key_name is null or p_value is null or p_key_id is null ) then

Line 317: elsif ( p_key_name=FND_API.G_MISS_CHAR or p_value=FND_API.G_MISS_CHAR or p_key_id=FND_API.G_MISS_CHAR ) then

313: --begins here
314: --Valid no Null passed in for NOT_NULL parameters
315: if ( p_key_name is null or p_value is null or p_key_id is null ) then
316: raise IEM_TAG_NAME_VALUE_KEY_NULL;
317: elsif ( p_key_name=FND_API.G_MISS_CHAR or p_value=FND_API.G_MISS_CHAR or p_key_id=FND_API.G_MISS_CHAR ) then
318: raise IEM_ADM_G_MISS_FOR_NOTNULL;
319: end if;
320:
321: l_key_name := LTRIM(RTRIM(p_key_name));

Line 378: p_init_msg_list => FND_API.G_FALSE,

374: elsif p_type_type_code = 'PROCEDURE' then
375: IF p_value is NOT NULL THEN
376: IEM_TAG_RUN_PROC_PVT.validProcedure(
377: p_api_version_number => P_Api_Version_Number,
378: p_init_msg_list => FND_API.G_FALSE,
379: p_commit => P_Commit,
380: p_ProcName => l_value,
381: x_return_status => l_return_status,
382: x_msg_count => l_msg_count,

Line 385: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

381: x_return_status => l_return_status,
382: x_msg_count => l_msg_count,
383: x_msg_data => l_msg_data
384: );
385: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
386: raise l_IEM_INVALID_PROCEDURE;
387: end if;
388:
389: END IF;

Line 459: IF FND_API.To_Boolean(p_commit) THEN

455: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
456: );
457:
458: -- Standard Check Of p_commit.
459: IF FND_API.To_Boolean(p_commit) THEN
460: COMMIT WORK;
461: END IF;
462:
463: -- Standard callto get message count and if count is 1, get message info.

Line 472: x_return_status := FND_API.G_RET_STS_ERROR ;

468:
469: EXCEPTION
470: WHEN l_invalid_query THEN
471: ROLLBACK TO create_item_tag_PVT;
472: x_return_status := FND_API.G_RET_STS_ERROR ;
473: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
474:
475: WHEN l_IEM_INVALID_PROCEDURE THEN
476: ROLLBACK TO create_item_tag_PVT;

Line 477: x_return_status := FND_API.G_RET_STS_ERROR ;

473: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
474:
475: WHEN l_IEM_INVALID_PROCEDURE THEN
476: ROLLBACK TO create_item_tag_PVT;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
479:
480: WHEN IEM_TAG_NAME_VALUE_KEY_NULL THEN
481: ROLLBACK TO create_item_tag_PVT;

Line 484: x_return_status := FND_API.G_RET_STS_ERROR ;

480: WHEN IEM_TAG_NAME_VALUE_KEY_NULL THEN
481: ROLLBACK TO create_item_tag_PVT;
482: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_NAME_VALUE_KEY_NULL');
483: FND_MSG_PUB.Add;
484: x_return_status := FND_API.G_RET_STS_ERROR ;
485: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
486:
487: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
488: ROLLBACK TO create_item_tag_PVT;

Line 491: x_return_status := FND_API.G_RET_STS_ERROR ;

487: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
488: ROLLBACK TO create_item_tag_PVT;
489: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
490: FND_MSG_PUB.Add;
491: x_return_status := FND_API.G_RET_STS_ERROR ;
492: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
493:
494: WHEN IEM_TAG_DUP_KEY_NAME THEN
495: ROLLBACK TO create_item_tag_PVT;

Line 498: x_return_status := FND_API.G_RET_STS_ERROR ;

494: WHEN IEM_TAG_DUP_KEY_NAME THEN
495: ROLLBACK TO create_item_tag_PVT;
496: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_NAME');
497: FND_MSG_PUB.Add;
498: x_return_status := FND_API.G_RET_STS_ERROR ;
499: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
500:
501: WHEN IEM_TAG_DUP_KEY_ID THEN
502: ROLLBACK TO create_item_tag_PVT;

Line 505: x_return_status := FND_API.G_RET_STS_ERROR ;

501: WHEN IEM_TAG_DUP_KEY_ID THEN
502: ROLLBACK TO create_item_tag_PVT;
503: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_ID');
504: FND_MSG_PUB.Add;
505: x_return_status := FND_API.G_RET_STS_ERROR ;
506: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO create_item_tag_PVT;

Line 508: WHEN FND_API.G_EXC_ERROR THEN

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

Line 510: x_return_status := FND_API.G_RET_STS_ERROR ;

506: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
507:
508: WHEN FND_API.G_EXC_ERROR THEN
509: ROLLBACK TO create_item_tag_PVT;
510: x_return_status := FND_API.G_RET_STS_ERROR ;
511: FND_MSG_PUB.Count_And_Get
512:
513: ( p_count => x_msg_count,
514: p_data => x_msg_data

Line 517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

513: ( p_count => x_msg_count,
514: p_data => x_msg_data
515: );
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO create_item_tag_PVT;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
520: FND_MSG_PUB.Count_And_Get
521: ( p_count => x_msg_count,

Line 519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

515: );
516:
517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
518: ROLLBACK TO create_item_tag_PVT;
519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
520: FND_MSG_PUB.Count_And_Get
521: ( p_count => x_msg_count,
522: p_data => x_msg_data
523: );

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: );
524:
525: WHEN OTHERS THEN
526: ROLLBACK TO create_item_tag_PVT;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: IF FND_MSG_PUB.Check_Msg_Level
529: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
530: THEN
531: FND_MSG_PUB.Add_Exc_Msg

Line 600: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

596: -- Standard Start of API savepoint
597: SAVEPOINT create_item_account_tags_PVT;
598:
599: -- Standard call to check for call compatibility.
600: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
601: p_api_version_number,
602: l_api_name,
603: G_PKG_NAME)
604: THEN

Line 605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

601: p_api_version_number,
602: l_api_name,
603: G_PKG_NAME)
604: THEN
605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: -- Initialize message list if p_init_msg_list is set to TRUE.
609: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 609: IF FND_API.to_Boolean( p_init_msg_list ) THEN

605: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
606: END IF;
607:
608: -- Initialize message list if p_init_msg_list is set to TRUE.
609: IF FND_API.to_Boolean( p_init_msg_list ) THEN
610: FND_MSG_PUB.initialize;
611: END IF;
612:
613: -- Initialize API return status to SUCCESS

Line 614: x_return_status := FND_API.G_RET_STS_SUCCESS;

610: FND_MSG_PUB.initialize;
611: END IF;
612:
613: -- Initialize API return status to SUCCESS
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615:
616: --valid tag_key_id
617: select count(*) into l_count from iem_tag_keys where tag_key_id = p_tag_key_id;
618: if l_count < 1 then

Line 689: IF FND_API.To_Boolean(p_commit) THEN

685: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
686: );
687:
688: -- Standard Check Of p_commit
689: IF FND_API.To_Boolean(p_commit) THEN
690: COMMIT WORK;
691: END IF;
692:
693: -- Standard callto get message count and if count is 1, get message info.

Line 704: x_return_status := FND_API.G_RET_STS_ERROR ;

700: WHEN IEM_TAG_KEY_ID_NOT_EXIST THEN
701: ROLLBACK TO create_item_account_tags_PVT;
702: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_KEY_ID_NOT_EXIST');
703: FND_MSG_PUB.Add;
704: x_return_status := FND_API.G_RET_STS_ERROR ;
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
706:
707: WHEN IEM_TAG_ACCT_ID_NOT_EXIST THEN
708: ROLLBACK TO create_item_account_tags_PVT;

Line 711: x_return_status := FND_API.G_RET_STS_ERROR ;

707: WHEN IEM_TAG_ACCT_ID_NOT_EXIST THEN
708: ROLLBACK TO create_item_account_tags_PVT;
709: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_ACCT_ID_NOT_EXIST');
710: FND_MSG_PUB.Add;
711: x_return_status := FND_API.G_RET_STS_ERROR ;
712: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
713:
714: WHEN FND_API.G_EXC_ERROR THEN
715: ROLLBACK TO create_item_account_tags_PVT;

Line 714: WHEN FND_API.G_EXC_ERROR THEN

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

Line 716: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

720: );
721:
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: ROLLBACK TO create_item_account_tags_PVT;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,
727: p_data => x_msg_data
728: );

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

728: );
729:
730: WHEN OTHERS THEN
731: ROLLBACK TO create_item_account_tags_PVT;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: IF FND_MSG_PUB.Check_Msg_Level
734: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
735: THEN
736: FND_MSG_PUB.Add_Exc_Msg

Line 762: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

758:
759: l_api_name VARCHAR2(255):='update_acct_tag_wrap';
760: l_api_version_number NUMBER:=1.0;
761:
762: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
763: l_msg_count NUMBER := 0;
764: l_msg_data VARCHAR2(2000);
765:
766: IEM_ACCT_TAG_NOT_UPD EXCEPTION;

Line 780: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

776: -- Standard Start of API savepoint
777: SAVEPOINT update_acct_tag_wrap;
778:
779: -- Standard call to check for call compatibility.
780: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
781: p_api_version_number,
782: l_api_name,
783: G_PKG_NAME)
784: THEN

Line 785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

781: p_api_version_number,
782: l_api_name,
783: G_PKG_NAME)
784: THEN
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786:
787: END IF;
788:
789: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 790: IF FND_API.to_Boolean( p_init_msg_list )

786:
787: END IF;
788:
789: -- Initialize message list if p_init_msg_list is set to TRUE.
790: IF FND_API.to_Boolean( p_init_msg_list )
791: THEN
792: FND_MSG_PUB.initialize;
793: END IF;
794:

Line 796: x_return_status := FND_API.G_RET_STS_SUCCESS;

792: FND_MSG_PUB.initialize;
793: END IF;
794:
795: -- Initialize API return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: --API Body
799: l_in_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_in_key_id);
800: l_out_tab := IEM_TAG_KEY_PVT.varChar_to_table(p_out_key_id);

Line 818: p_init_msg_list => FND_API.G_FALSE,

814: select tag_key_id into l_tag_key_id from iem_tag_keys where UPPER(tag_id) = UPPER(l_in_tab(j));
815:
816: create_item_account_tags (
817: p_api_version_number => l_api_version_number,
818: p_init_msg_list => FND_API.G_FALSE,
819: p_commit => FND_API.G_FALSE,
820: p_email_account_id => p_account_id,
821: p_tag_key_id => l_tag_key_id,
822: x_return_status => l_return_status,

Line 819: p_commit => FND_API.G_FALSE,

815:
816: create_item_account_tags (
817: p_api_version_number => l_api_version_number,
818: p_init_msg_list => FND_API.G_FALSE,
819: p_commit => FND_API.G_FALSE,
820: p_email_account_id => p_account_id,
821: p_tag_key_id => l_tag_key_id,
822: x_return_status => l_return_status,
823: x_msg_count => l_msg_count,

Line 826: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

822: x_return_status => l_return_status,
823: x_msg_count => l_msg_count,
824: x_msg_data => l_msg_data);
825:
826: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
827: raise IEM_ACCT_TAG_NOT_UPD;
828: end if;
829:
830: end if;

Line 835: IF FND_API.To_Boolean(p_commit) THEN

831:
832: end loop;
833:
834: -- Standard Check Of p_commit.
835: IF FND_API.To_Boolean(p_commit) THEN
836: COMMIT WORK;
837: END IF;
838:
839:

Line 845: x_return_status := FND_API.G_RET_STS_ERROR ;

841: WHEN NO_DATA_FOUND THEN
842: ROLLBACK TO update_acct_tag_wrap;
843: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_TAG_NOT_EXIST');
844: FND_MSG_PUB.Add;
845: x_return_status := FND_API.G_RET_STS_ERROR ;
846: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
847:
848: WHEN IEM_ACCT_TAG_NOT_UPD THEN
849: ROLLBACK TO update_acct_tag_wrap;

Line 852: x_return_status := FND_API.G_RET_STS_ERROR ;

848: WHEN IEM_ACCT_TAG_NOT_UPD THEN
849: ROLLBACK TO update_acct_tag_wrap;
850: FND_MESSAGE.SET_NAME('IEM','IEM_ACCT_TAG_NOT_UPD');
851: FND_MSG_PUB.Add;
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_acct_tag_wrap;

Line 855: WHEN FND_API.G_EXC_ERROR THEN

851: FND_MSG_PUB.Add;
852: x_return_status := FND_API.G_RET_STS_ERROR ;
853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_acct_tag_wrap;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
859:

Line 857: x_return_status := FND_API.G_RET_STS_ERROR ;

853: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: ROLLBACK TO update_acct_tag_wrap;
857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
859:
860:
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

857: x_return_status := FND_API.G_RET_STS_ERROR ;
858: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
859:
860:
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO update_acct_tag_wrap;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
865:

Line 863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

859:
860:
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: ROLLBACK TO update_acct_tag_wrap;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
864: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
865:
866:
867: WHEN OTHERS THEN

Line 869: x_return_status := FND_API.G_RET_STS_ERROR;

865:
866:
867: WHEN OTHERS THEN
868: ROLLBACK TO update_acct_tag_wrap;
869: x_return_status := FND_API.G_RET_STS_ERROR;
870: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
871: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
872: END IF;
873:

Line 895: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

891: x_msg_data OUT NOCOPY VARCHAR2
892: ) is
893: l_api_name VARCHAR2(255):='update_item_tag_key';
894: l_api_version_number NUMBER:=1.0;
895: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
896: l_msg_count NUMBER := 0;
897: l_msg_data VARCHAR2(2000);
898:
899: l_name_count NUMBER;

Line 915: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

911: -- Standard Start of API savepoint
912: SAVEPOINT update_item_tag_key;
913:
914: -- Standard call to check for call compatibility.
915: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
916: p_api_version_number,
917: l_api_name,
918: G_PKG_NAME)
919: THEN

Line 920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

916: p_api_version_number,
917: l_api_name,
918: G_PKG_NAME)
919: THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE.
924: IF FND_API.to_Boolean( p_init_msg_list )

Line 924: IF FND_API.to_Boolean( p_init_msg_list )

920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE.
924: IF FND_API.to_Boolean( p_init_msg_list )
925: THEN
926: FND_MSG_PUB.initialize;
927: END IF;
928:

Line 930: x_return_status := FND_API.G_RET_STS_SUCCESS;

926: FND_MSG_PUB.initialize;
927: END IF;
928:
929: -- Initialize API return status to SUCCESS
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: -- Valid g_miss
933: if ( p_key_id=FND_API.G_MISS_CHAR or p_key_name=FND_API.G_MISS_CHAR
934: or p_type_type_code=FND_API.G_MISS_CHAR or p_value=FND_API.G_MISS_CHAR) then

Line 933: if ( p_key_id=FND_API.G_MISS_CHAR or p_key_name=FND_API.G_MISS_CHAR

929: -- Initialize API return status to SUCCESS
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: -- Valid g_miss
933: if ( p_key_id=FND_API.G_MISS_CHAR or p_key_name=FND_API.G_MISS_CHAR
934: or p_type_type_code=FND_API.G_MISS_CHAR or p_value=FND_API.G_MISS_CHAR) then
935: raise IEM_ADM_G_MISS_FOR_NOTNULL;
936: end if;
937:

Line 934: or p_type_type_code=FND_API.G_MISS_CHAR or p_value=FND_API.G_MISS_CHAR) then

930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: -- Valid g_miss
933: if ( p_key_id=FND_API.G_MISS_CHAR or p_key_name=FND_API.G_MISS_CHAR
934: or p_type_type_code=FND_API.G_MISS_CHAR or p_value=FND_API.G_MISS_CHAR) then
935: raise IEM_ADM_G_MISS_FOR_NOTNULL;
936: end if;
937:
938: --check duplicate key name

Line 973: p_init_msg_list => FND_API.G_FALSE,

969: elsif p_type_type_code = 'PROCEDURE' then
970: IF p_value is NOT NULL THEN
971: IEM_TAG_RUN_PROC_PVT.validProcedure(
972: p_api_version_number => P_Api_Version_Number,
973: p_init_msg_list => FND_API.G_FALSE,
974: p_commit => P_Commit,
975: p_ProcName => p_value,
976: x_return_status => l_return_status,
977: x_msg_count => l_msg_count,

Line 980: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

976: x_return_status => l_return_status,
977: x_msg_count => l_msg_count,
978: x_msg_data => l_msg_data
979: );
980: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
981: raise l_IEM_INVALID_PROCEDURE;
982: end if;
983:
984: END IF;

Line 990: --tag_id=decode(p_key_id,FND_API.G_MISS_CHAR,tag_id,p_key_id),

986:
987:
988: update IEM_TAG_KEYS
989: set
990: --tag_id=decode(p_key_id,FND_API.G_MISS_CHAR,tag_id,p_key_id),
991: tag_name=decode(p_key_name,null,tag_name,p_key_name),
992: tag_type_code=decode(p_type_type_code,null,tag_type_code,p_type_type_code),
993: value=decode(p_value,null,tag_type_code,p_value),
994: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 1000: IF FND_API.To_Boolean(p_commit) THEN

996: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
997: where tag_key_id=p_tag_key_id;
998:
999: -- Standard Check Of p_commit.
1000: IF FND_API.To_Boolean(p_commit) THEN
1001: COMMIT WORK;
1002: END IF;
1003:
1004: -- Standard callto get message count and if count is 1, get message info.

Line 1013: x_return_status := FND_API.G_RET_STS_ERROR ;

1009: EXCEPTION
1010:
1011: WHEN l_invalid_query THEN
1012: ROLLBACK TO update_item_tag_key;
1013: x_return_status := FND_API.G_RET_STS_ERROR ;
1014: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1015:
1016: WHEN l_IEM_INVALID_PROCEDURE THEN
1017: ROLLBACK TO update_item_tag_key;

Line 1018: x_return_status := FND_API.G_RET_STS_ERROR ;

1014: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1015:
1016: WHEN l_IEM_INVALID_PROCEDURE THEN
1017: ROLLBACK TO update_item_tag_key;
1018: x_return_status := FND_API.G_RET_STS_ERROR ;
1019: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1020:
1021: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
1022: ROLLBACK TO update_item_tag_key;

Line 1025: x_return_status := FND_API.G_RET_STS_ERROR ;

1021: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
1022: ROLLBACK TO update_item_tag_key;
1023: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
1024: FND_MSG_PUB.Add;
1025: x_return_status := FND_API.G_RET_STS_ERROR ;
1026: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1027:
1028: WHEN IEM_TAG_DUP_KEY_NAME THEN
1029: ROLLBACK TO update_item_tag_key;

Line 1032: x_return_status := FND_API.G_RET_STS_ERROR ;

1028: WHEN IEM_TAG_DUP_KEY_NAME THEN
1029: ROLLBACK TO update_item_tag_key;
1030: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_NAME');
1031: FND_MSG_PUB.Add;
1032: x_return_status := FND_API.G_RET_STS_ERROR ;
1033: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1034:
1035: WHEN IEM_TAG_DUP_KEY_ID THEN
1036: ROLLBACK TO update_item_tag_key;

Line 1039: x_return_status := FND_API.G_RET_STS_ERROR ;

1035: WHEN IEM_TAG_DUP_KEY_ID THEN
1036: ROLLBACK TO update_item_tag_key;
1037: FND_MESSAGE.SET_NAME('IEM','IEM_TAG_DUP_KEY_ID');
1038: FND_MSG_PUB.Add;
1039: x_return_status := FND_API.G_RET_STS_ERROR ;
1040: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1041:
1042: WHEN FND_API.G_EXC_ERROR THEN
1043: ROLLBACK TO update_item_tag_key;

Line 1042: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057:
1058: WHEN OTHERS THEN
1059:
1060: ROLLBACK TO update_item_tag_key;
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: IF FND_MSG_PUB.Check_Msg_Level
1063: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1064: THEN
1065: FND_MSG_PUB.Add_Exc_Msg