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

Line 66: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

62: -- Standard Start of API savepoint
63: SAVEPOINT create_item_acct_routes_PVT;
64:
65: -- Standard call to check for call compatibility.
66: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
67: p_api_version_number,
68:
69: l_api_name,
70: G_PKG_NAME)

Line 72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

68:
69: l_api_name,
70: G_PKG_NAME)
71: THEN
72: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76:

Line 77: IF FND_API.to_Boolean( p_init_msg_list ) THEN

73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE.
76:
77: IF FND_API.to_Boolean( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API return status to SUCCESS

Line 83: x_return_status := FND_API.G_RET_STS_SUCCESS;

79: END IF;
80:
81: -- Initialize API return status to SUCCESS
82:
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: --actual API begins here
86: SELECT IEM_ACCOUNT_EMAILPROCS_s1.nextval
87: INTO l_seq_id

Line 152: IF FND_API.To_Boolean(p_commit) THEN

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

Line 163: WHEN FND_API.G_EXC_ERROR THEN

159: p_data => x_msg_data
160: );
161:
162: EXCEPTION
163: WHEN FND_API.G_EXC_ERROR THEN
164:
165: ROLLBACK TO create_item_acct_routes_PVT;
166:
167: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 167: x_return_status := FND_API.G_RET_STS_ERROR ;

163: WHEN FND_API.G_EXC_ERROR THEN
164:
165: ROLLBACK TO create_item_acct_routes_PVT;
166:
167: x_return_status := FND_API.G_RET_STS_ERROR ;
168: FND_MSG_PUB.Count_And_Get
169: ( p_count => x_msg_count,
170: p_data => x_msg_data
171: );

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

171: );
172:
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: ROLLBACK TO create_item_acct_routes_PVT;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176: FND_MSG_PUB.Count_And_Get
177: ( p_count => x_msg_count,
178:
179: p_data => x_msg_data

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181:
182:
183: WHEN OTHERS THEN
184: ROLLBACK TO create_item_acct_routes_PVT;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: IF FND_MSG_PUB.Check_Msg_Level
187: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
188: THEN
189: FND_MSG_PUB.Add_Exc_Msg

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

216: x_msg_data OUT NOCOPY VARCHAR2
217: ) is
218: l_api_name VARCHAR2(255):='update_item_emailproc';
219: l_api_version_number NUMBER:=1.0;
220: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
221: l_msg_count NUMBER := 0;
222: l_msg_data VARCHAR2(2000);
223: l_proc_name VARCHAR2(256);
224: l_name_count NUMBER;

Line 235: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

231: -- Standard Start of API savepoint
232: SAVEPOINT update_item_route;
233:
234: -- Standard call to check for call compatibility.
235: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
236: p_api_version_number,
237: l_api_name,
238: G_PKG_NAME)
239: THEN

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: l_api_name,
238: G_PKG_NAME)
239: THEN
240:
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: END IF;
243:
244:
245: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 246: IF FND_API.to_Boolean( p_init_msg_list )

242: END IF;
243:
244:
245: -- Initialize message list if p_init_msg_list is set to TRUE.
246: IF FND_API.to_Boolean( p_init_msg_list )
247: THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250:

Line 252: x_return_status := FND_API.G_RET_STS_SUCCESS;

248: FND_MSG_PUB.initialize;
249: END IF;
250:
251: -- Initialize API return status to SUCCESS
252: x_return_status := FND_API.G_RET_STS_SUCCESS;
253:
254: --check duplicate value for attribute Name
255: select count(*) into l_name_count
256: from iem_emailprocs

Line 276: p_init_msg_list => FND_API.G_FALSE,

272: else
273: --validation goes here.
274: IEM_ROUTE_RUN_PROC_PVT.validProcedure(
275: p_api_version_number => P_Api_Version_Number,
276: p_init_msg_list => FND_API.G_FALSE,
277: p_commit => P_Commit,
278: p_ProcName => l_proc_name,
279: p_return_type => p_return_type,
280: x_return_status => l_return_status,

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

280: x_return_status => l_return_status,
281: x_msg_count => l_msg_count,
282: x_msg_data => l_msg_data
283: );
284: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
285: raise l_IEM_INVALID_PROCEDURE;
286: end if;
287: end if;
288: end if;

Line 293: if ( p_name = FND_API.G_MISS_CHAR ) then

289:
290: end if;
291: */
292:
293: if ( p_name = FND_API.G_MISS_CHAR ) then
294: raise IEM_ADM_G_MISS_FOR_NOTNULL;
295: elsif ( p_ruling_chain = FND_API.G_MISS_CHAR ) then
296: raise IEM_ADM_G_MISS_FOR_NOTNULL;
297: elsif ( p_all_email = FND_API.G_MISS_CHAR ) then

Line 295: elsif ( p_ruling_chain = FND_API.G_MISS_CHAR ) then

291: */
292:
293: if ( p_name = FND_API.G_MISS_CHAR ) then
294: raise IEM_ADM_G_MISS_FOR_NOTNULL;
295: elsif ( p_ruling_chain = FND_API.G_MISS_CHAR ) then
296: raise IEM_ADM_G_MISS_FOR_NOTNULL;
297: elsif ( p_all_email = FND_API.G_MISS_CHAR ) then
298: raise IEM_ADM_G_MISS_FOR_NOTNULL;
299: elsif ( p_rule_type = FND_API.G_MISS_CHAR ) then

Line 297: elsif ( p_all_email = FND_API.G_MISS_CHAR ) then

293: if ( p_name = FND_API.G_MISS_CHAR ) then
294: raise IEM_ADM_G_MISS_FOR_NOTNULL;
295: elsif ( p_ruling_chain = FND_API.G_MISS_CHAR ) then
296: raise IEM_ADM_G_MISS_FOR_NOTNULL;
297: elsif ( p_all_email = FND_API.G_MISS_CHAR ) then
298: raise IEM_ADM_G_MISS_FOR_NOTNULL;
299: elsif ( p_rule_type = FND_API.G_MISS_CHAR ) then
300: raise IEM_ADM_G_MISS_FOR_NOTNULL;
301: end if;

Line 299: elsif ( p_rule_type = FND_API.G_MISS_CHAR ) then

295: elsif ( p_ruling_chain = FND_API.G_MISS_CHAR ) then
296: raise IEM_ADM_G_MISS_FOR_NOTNULL;
297: elsif ( p_all_email = FND_API.G_MISS_CHAR ) then
298: raise IEM_ADM_G_MISS_FOR_NOTNULL;
299: elsif ( p_rule_type = FND_API.G_MISS_CHAR ) then
300: raise IEM_ADM_G_MISS_FOR_NOTNULL;
301: end if;
302:
303: update IEM_EMAILPROCS

Line 306: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),

302:
303: update IEM_EMAILPROCS
304: set
305: name=decode(p_name,null,name,p_name),
306: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
307: boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),
308: all_email=decode(p_all_email,null,all_email,p_all_email),
309: rule_type=decode(p_rule_type,null, rule_type, p_rule_type),
310: LAST_UPDATED_BY = decode(G_created_updated_by,FND_API.G_MISS_CHAR,-1,G_created_updated_by),

Line 310: LAST_UPDATED_BY = decode(G_created_updated_by,FND_API.G_MISS_CHAR,-1,G_created_updated_by),

306: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
307: boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),
308: all_email=decode(p_all_email,null,all_email,p_all_email),
309: rule_type=decode(p_rule_type,null, rule_type, p_rule_type),
310: LAST_UPDATED_BY = decode(G_created_updated_by,FND_API.G_MISS_CHAR,-1,G_created_updated_by),
311: LAST_UPDATE_DATE = sysdate,
312: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,FND_API.G_MISS_CHAR,-1,G_LAST_UPDATE_LOGIN)
313:
314: where emailproc_id=p_emailproc_id;

Line 312: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,FND_API.G_MISS_CHAR,-1,G_LAST_UPDATE_LOGIN)

308: all_email=decode(p_all_email,null,all_email,p_all_email),
309: rule_type=decode(p_rule_type,null, rule_type, p_rule_type),
310: LAST_UPDATED_BY = decode(G_created_updated_by,FND_API.G_MISS_CHAR,-1,G_created_updated_by),
311: LAST_UPDATE_DATE = sysdate,
312: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,FND_API.G_MISS_CHAR,-1,G_LAST_UPDATE_LOGIN)
313:
314: where emailproc_id=p_emailproc_id;
315:
316: -- Standard Check Of p_commit.

Line 317: IF FND_API.To_Boolean(p_commit) THEN

313:
314: where emailproc_id=p_emailproc_id;
315:
316: -- Standard Check Of p_commit.
317: IF FND_API.To_Boolean(p_commit) THEN
318: COMMIT WORK;
319: END IF;
320:
321: -- Standard callto get message count and if count is 1, get message info.

Line 331: x_return_status := FND_API.G_RET_STS_ERROR ;

327:
328: EXCEPTION
329: WHEN l_IEM_INVALID_PROCEDURE THEN
330: ROLLBACK TO update_item_route;
331: x_return_status := FND_API.G_RET_STS_ERROR ;
332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
333:
334: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
335: ROLLBACK TO update_item_route;

Line 338: x_return_status := FND_API.G_RET_STS_ERROR ;

334: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
335: ROLLBACK TO update_item_route;
336: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
337: FND_MSG_PUB.Add;
338: x_return_status := FND_API.G_RET_STS_ERROR ;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: WHEN IEM_ADM_DUP_NAME THEN
342: ROLLBACK TO update_item_route;

Line 345: x_return_status := FND_API.G_RET_STS_ERROR ;

341: WHEN IEM_ADM_DUP_NAME THEN
342: ROLLBACK TO update_item_route;
343: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');
344: FND_MSG_PUB.Add;
345: x_return_status := FND_API.G_RET_STS_ERROR ;
346: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
347:
348: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
349: ROLLBACK TO update_item_route;

Line 352: x_return_status := FND_API.G_RET_STS_ERROR ;

348: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
349: ROLLBACK TO update_item_route;
350: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
351: FND_MSG_PUB.Add;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_item_route;

Line 355: WHEN FND_API.G_EXC_ERROR THEN

351: FND_MSG_PUB.Add;
352: x_return_status := FND_API.G_RET_STS_ERROR ;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_item_route;
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MSG_PUB.Count_And_Get
359:

Line 357: x_return_status := FND_API.G_RET_STS_ERROR ;

353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_item_route;
357: x_return_status := FND_API.G_RET_STS_ERROR ;
358: FND_MSG_PUB.Count_And_Get
359:
360:
361: ( p_count => x_msg_count,

Line 365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

361: ( p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO update_item_route;
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,

Line 367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

363: );
364:
365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
366: ROLLBACK TO update_item_route;
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
368: FND_MSG_PUB.Count_And_Get
369: ( p_count => x_msg_count,
370: p_data => x_msg_data
371: );

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373:
374: WHEN OTHERS THEN
375:
376: ROLLBACK TO update_item_route;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: IF FND_MSG_PUB.Check_Msg_Level
379: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
380: THEN
381: FND_MSG_PUB.Add_Exc_Msg

Line 420: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

416: -- Standard Start of API savepoint
417:
418: SAVEPOINT update_item_rule;
419: -- Standard call to check for call compatibility.
420: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)
424: THEN

Line 425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

421: p_api_version_number,
422: l_api_name,
423: G_PKG_NAME)
424: THEN
425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
426:
427: END IF;
428:
429: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 430: IF FND_API.to_Boolean( p_init_msg_list )

426:
427: END IF;
428:
429: -- Initialize message list if p_init_msg_list is set to TRUE.
430: IF FND_API.to_Boolean( p_init_msg_list )
431: THEN
432:
433: FND_MSG_PUB.initialize;
434: END IF;

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432:
433: FND_MSG_PUB.initialize;
434: END IF;
435: -- Initialize API return status to SUCCESS
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: -- check if the route_id exist in iem_routes
439: select count(*) into l_rule from iem_emailproc_rules
440: where emailproc_rule_id = p_emailproc_rule_id;

Line 462: if ( p_key_type_code = FND_API.G_MISS_CHAR ) then

458: l_value := p_value;
459: end if;
460: */
461:
462: if ( p_key_type_code = FND_API.G_MISS_CHAR ) then
463: raise IEM_ADM_G_MISS_FOR_NOTNULL;
464: elsif ( p_operator_type_code = FND_API.G_MISS_CHAR ) then
465: raise IEM_ADM_G_MISS_FOR_NOTNULL;
466: elsif ( p_value = FND_API.G_MISS_CHAR ) then

Line 464: elsif ( p_operator_type_code = FND_API.G_MISS_CHAR ) then

460: */
461:
462: if ( p_key_type_code = FND_API.G_MISS_CHAR ) then
463: raise IEM_ADM_G_MISS_FOR_NOTNULL;
464: elsif ( p_operator_type_code = FND_API.G_MISS_CHAR ) then
465: raise IEM_ADM_G_MISS_FOR_NOTNULL;
466: elsif ( p_value = FND_API.G_MISS_CHAR ) then
467: raise IEM_ADM_G_MISS_FOR_NOTNULL;
468: end if;

Line 466: elsif ( p_value = FND_API.G_MISS_CHAR ) then

462: if ( p_key_type_code = FND_API.G_MISS_CHAR ) then
463: raise IEM_ADM_G_MISS_FOR_NOTNULL;
464: elsif ( p_operator_type_code = FND_API.G_MISS_CHAR ) then
465: raise IEM_ADM_G_MISS_FOR_NOTNULL;
466: elsif ( p_value = FND_API.G_MISS_CHAR ) then
467: raise IEM_ADM_G_MISS_FOR_NOTNULL;
468: end if;
469:
470: update IEM_EMAILPROC_RULES

Line 481: IF FND_API.To_Boolean(p_commit) THEN

477: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
478: where emailproc_rule_id=p_emailproc_rule_id;
479:
480: -- Standard Check Of p_commit.
481: IF FND_API.To_Boolean(p_commit) THEN
482: COMMIT WORK;
483: END IF;
484:
485: -- Standard callto get message count and if count is 1, get message info.

Line 496: x_return_status := FND_API.G_RET_STS_ERROR ;

492: ROLLBACK TO update_item_rule;
493: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
494:
495: FND_MSG_PUB.Add;
496: x_return_status := FND_API.G_RET_STS_ERROR ;
497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
498:
499: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
500: ROLLBACK TO update_item_rule;

Line 504: x_return_status := FND_API.G_RET_STS_ERROR ;

500: ROLLBACK TO update_item_rule;
501: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
502:
503: FND_MSG_PUB.Add;
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
506: /*
507: WHEN IEM_INVALID_DATE_FORMAT THEN
508: ROLLBACK TO update_item_rule;

Line 511: x_return_status := FND_API.G_RET_STS_ERROR ;

507: WHEN IEM_INVALID_DATE_FORMAT THEN
508: ROLLBACK TO update_item_rule;
509: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513: */
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO update_item_rule;

Line 514: WHEN FND_API.G_EXC_ERROR THEN

510: FND_MSG_PUB.Add;
511: x_return_status := FND_API.G_RET_STS_ERROR ;
512: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
513: */
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO update_item_rule;
516:
517: x_return_status := FND_API.G_RET_STS_ERROR ;
518: FND_MSG_PUB.Count_And_Get

Line 517: x_return_status := FND_API.G_RET_STS_ERROR ;

513: */
514: WHEN FND_API.G_EXC_ERROR THEN
515: ROLLBACK TO update_item_rule;
516:
517: x_return_status := FND_API.G_RET_STS_ERROR ;
518: FND_MSG_PUB.Count_And_Get
519:
520: ( p_count => x_msg_count,
521: p_data => x_msg_data

Line 523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

519:
520: ( p_count => x_msg_count,
521: p_data => x_msg_data
522: );
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: ROLLBACK TO update_item_rule;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

521: p_data => x_msg_data
522: );
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: ROLLBACK TO update_item_rule;
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,
528: p_data => x_msg_data
529: );

Line 534: x_return_status := FND_API.G_RET_STS_ERROR;

530: WHEN OTHERS THEN
531:
532: ROLLBACK TO update_item_rule;
533:
534: x_return_status := FND_API.G_RET_STS_ERROR;
535: IF FND_MSG_PUB.Check_Msg_Level
536: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
537: THEN
538: FND_MSG_PUB.Add_Exc_Msg

Line 580: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

576: BEGIN
577: -- Standard Start of API savepoint
578: SAVEPOINT update_account_emailprocs_PVT;
579: -- Standard call to check for call compatibility.
580: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
581: p_api_version_number,
582: l_api_name,
583: G_PKG_NAME)
584: THEN

Line 585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

581: p_api_version_number,
582: l_api_name,
583: G_PKG_NAME)
584: THEN
585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;
587: -- Initialize message list if p_init_msg_list is set to TRUE.
588:
589: IF FND_API.to_Boolean( p_init_msg_list )

Line 589: IF FND_API.to_Boolean( p_init_msg_list )

585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
586: END IF;
587: -- Initialize message list if p_init_msg_list is set to TRUE.
588:
589: IF FND_API.to_Boolean( p_init_msg_list )
590:
591: THEN
592: FND_MSG_PUB.initialize;
593: END IF;

Line 595: x_return_status := FND_API.G_RET_STS_SUCCESS;

591: THEN
592: FND_MSG_PUB.initialize;
593: END IF;
594: -- Initialize API return status to SUCCESS
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596:
597: -- Check For Existing IEM Server Group
598:
599: Select count(*) into l_emailproc_cnt from iem_emailprocs

Line 624: elsif(p_enabled_flag = FND_API.G_MISS_CHAR ) then

620: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
621: LAST_UPDATE_DATE = sysdate,
622: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
623: where emailproc_id = p_emailproc_id and email_account_id = p_email_account_id;
624: elsif(p_enabled_flag = FND_API.G_MISS_CHAR ) then
625: update IEM_ACCOUNT_EMAILPROCS
626: set
627: enabled_flag='N',
628: priority=decode(p_priority,null,priority,p_priority),

Line 649: IF FND_API.To_Boolean(p_commit) THEN

645: end if;
646:
647:
648: -- Standard Check Of p_commit.
649: IF FND_API.To_Boolean(p_commit) THEN
650: COMMIT WORK;
651:
652: END IF;
653: -- Standard callto get message count and if count is 1, get message info.

Line 661: WHEN FND_API.G_EXC_ERROR THEN

657:
658: );
659: EXCEPTION
660:
661: WHEN FND_API.G_EXC_ERROR THEN
662: ROLLBACK TO update_account_emailprocs_PVT;
663: x_return_status := FND_API.G_RET_STS_ERROR ;
664: FND_MSG_PUB.Count_And_Get
665:

Line 663: x_return_status := FND_API.G_RET_STS_ERROR ;

659: EXCEPTION
660:
661: WHEN FND_API.G_EXC_ERROR THEN
662: ROLLBACK TO update_account_emailprocs_PVT;
663: x_return_status := FND_API.G_RET_STS_ERROR ;
664: FND_MSG_PUB.Count_And_Get
665:
666: ( p_count => x_msg_count,
667: p_data => x_msg_data

Line 669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

665:
666: ( p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670: ROLLBACK TO update_account_emailprocs_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
672:
673: FND_MSG_PUB.Count_And_Get

Line 671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

667: p_data => x_msg_data
668: );
669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
670: ROLLBACK TO update_account_emailprocs_PVT;
671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
672:
673: FND_MSG_PUB.Count_And_Get
674: ( p_count => x_msg_count,
675: p_data => x_msg_data

Line 680: x_return_status := FND_API.G_RET_STS_ERROR;

676: );
677: WHEN OTHERS THEN
678: ROLLBACK TO update_account_emailprocs_PVT;
679:
680: x_return_status := FND_API.G_RET_STS_ERROR;
681: IF FND_MSG_PUB.Check_Msg_Level
682: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
683: THEN
684: FND_MSG_PUB.Add_Exc_Msg

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

720: l_seq_id NUMBER;
721: l_proc_name VARCHAR2(256);
722: l_name_count NUMBER;
723:
724: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
725: l_msg_count NUMBER := 0;
726: l_msg_data VARCHAR2(2000);
727:
728: l_all_email VARCHAR2(1);

Line 739: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

735: SAVEPOINT create_item_routes_PVT;
736:
737: -- Standard call to check for call compatibility.
738:
739: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
740: p_api_version_number,
741: l_api_name,
742: G_PKG_NAME)
743: THEN

Line 744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

740: p_api_version_number,
741: l_api_name,
742: G_PKG_NAME)
743: THEN
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745: END IF;
746:
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 749: IF FND_API.to_Boolean( p_init_msg_list )

745: END IF;
746:
747:
748: -- Initialize message list if p_init_msg_list is set to TRUE.
749: IF FND_API.to_Boolean( p_init_msg_list )
750: THEN
751: FND_MSG_PUB.initialize;
752: END IF;
753:

Line 756: x_return_status := FND_API.G_RET_STS_SUCCESS;

752: END IF;
753:
754:
755: -- Initialize API return status to SUCCESS
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:
758: --begins here
759:
760: --check duplicate value for attribute Name

Line 767: if ( p_all_email = FND_API.G_MISS_CHAR ) or ( p_all_email is null ) then

763: if l_name_count > 0 then
764: raise IEM_ADM_DUP_NAME;
765: end if;
766:
767: if ( p_all_email = FND_API.G_MISS_CHAR ) or ( p_all_email is null ) then
768: l_all_email := 'N';
769: else
770: l_all_email := p_all_email;
771: end if;

Line 773: if ( p_description = FND_API.G_MISS_CHAR ) or ( p_description is null ) then

769: else
770: l_all_email := p_all_email;
771: end if;
772:
773: if ( p_description = FND_API.G_MISS_CHAR ) or ( p_description is null ) then
774: l_description := null;
775: else
776: l_description := LTRIM(RTRIM(p_description));
777: end if;

Line 785: p_init_msg_list => FND_API.G_FALSE,

781: l_proc_name := LTRIM(RTRIM( p_proc_name ) );
782: --validation goes here.
783: IEM_ROUTE_RUN_PROC_PVT.validProcedure(
784: p_api_version_number => P_Api_Version_Number,
785: p_init_msg_list => FND_API.G_FALSE,
786: p_commit => P_Commit,
787: p_ProcName => l_proc_name,
788: p_return_type => p_return_type,
789: x_return_status => l_return_status,

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

789: x_return_status => l_return_status,
790: x_msg_count => l_msg_count,
791: x_msg_data => l_msg_data
792: );
793: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
794: raise l_IEM_INVALID_PROCEDURE;
795: end if;
796: else
797: l_proc_name := null;

Line 869: IF FND_API.To_Boolean(p_commit) THEN

865:
866: x_emailproc_id := l_seq_id;
867:
868: -- Standard Check Of p_commit.
869: IF FND_API.To_Boolean(p_commit) THEN
870: COMMIT WORK;
871: END IF;
872:
873: -- Standard callto get message count and if count is 1, get message info.

Line 884: x_return_status := FND_API.G_RET_STS_ERROR ;

880:
881: EXCEPTION
882: WHEN l_IEM_INVALID_PROCEDURE THEN
883: ROLLBACK TO create_item_routes_PVT;
884: x_return_status := FND_API.G_RET_STS_ERROR ;
885: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
886:
887: WHEN IEM_ADM_DUP_NAME THEN
888: ROLLBACK TO create_item_routes_PVT;

Line 891: x_return_status := FND_API.G_RET_STS_ERROR ;

887: WHEN IEM_ADM_DUP_NAME THEN
888: ROLLBACK TO create_item_routes_PVT;
889: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_DUP_NAME');
890: FND_MSG_PUB.Add;
891: x_return_status := FND_API.G_RET_STS_ERROR ;
892: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
893:
894: WHEN FND_API.G_EXC_ERROR THEN
895: ROLLBACK TO create_item_routes_PVT;

Line 894: WHEN FND_API.G_EXC_ERROR THEN

890: FND_MSG_PUB.Add;
891: x_return_status := FND_API.G_RET_STS_ERROR ;
892: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
893:
894: WHEN FND_API.G_EXC_ERROR THEN
895: ROLLBACK TO create_item_routes_PVT;
896: x_return_status := FND_API.G_RET_STS_ERROR ;
897:
898: FND_MSG_PUB.Count_And_Get

Line 896: x_return_status := FND_API.G_RET_STS_ERROR ;

892: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
893:
894: WHEN FND_API.G_EXC_ERROR THEN
895: ROLLBACK TO create_item_routes_PVT;
896: x_return_status := FND_API.G_RET_STS_ERROR ;
897:
898: FND_MSG_PUB.Count_And_Get
899:
900: ( p_count => x_msg_count,

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

902: );
903:
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: ROLLBACK TO create_item_routes_PVT;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
907: FND_MSG_PUB.Count_And_Get
908: ( p_count => x_msg_count,
909: p_data => x_msg_data
910: );

Line 916: x_return_status := FND_API.G_RET_STS_ERROR;

912:
913: WHEN OTHERS THEN
914:
915: ROLLBACK TO create_item_routes_PVT;
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: IF FND_MSG_PUB.Check_Msg_Level
918: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg

Line 959: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

955: -- Standard Start of API savepoint
956:
957: SAVEPOINT create_emailproc_rules_PVT;
958: -- Standard call to check for call compatibility.
959: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
960: p_api_version_number,
961: l_api_name,
962: G_PKG_NAME)
963:

Line 965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

961: l_api_name,
962: G_PKG_NAME)
963:
964: THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: END IF;
967:
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )

Line 969: IF FND_API.to_Boolean( p_init_msg_list )

965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: END IF;
967:
968: -- Initialize message list if p_init_msg_list is set to TRUE.
969: IF FND_API.to_Boolean( p_init_msg_list )
970: THEN
971:
972: FND_MSG_PUB.initialize;
973: END IF;

Line 976: x_return_status := FND_API.G_RET_STS_SUCCESS;

972: FND_MSG_PUB.initialize;
973: END IF;
974:
975: -- Initialize API return status to SUCCESS
976: x_return_status := FND_API.G_RET_STS_SUCCESS;
977:
978:
979:
980: /*

Line 1061: IF FND_API.To_Boolean(p_commit) THEN

1057: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
1058: );
1059:
1060: -- Standard Check Of p_commit.
1061: IF FND_API.To_Boolean(p_commit) THEN
1062:
1063: COMMIT WORK;
1064:
1065: END IF;

Line 1074: WHEN FND_API.G_EXC_ERROR THEN

1070: p_data => x_msg_data
1071: );
1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO create_emailproc_rules_PVT;
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: FND_MSG_PUB.Count_And_Get
1078: ( p_count => x_msg_count,

Line 1076: x_return_status := FND_API.G_RET_STS_ERROR ;

1072:
1073: EXCEPTION
1074: WHEN FND_API.G_EXC_ERROR THEN
1075: ROLLBACK TO create_emailproc_rules_PVT;
1076: x_return_status := FND_API.G_RET_STS_ERROR ;
1077: FND_MSG_PUB.Count_And_Get
1078: ( p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );

Line 1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1078: ( p_count => x_msg_count,
1079: p_data => x_msg_data
1080: );
1081:
1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1083: ROLLBACK TO create_emailproc_rules_PVT;
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: FND_MSG_PUB.Count_And_Get
1086: ( p_count => x_msg_count,

Line 1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1080: );
1081:
1082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1083: ROLLBACK TO create_emailproc_rules_PVT;
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1085: FND_MSG_PUB.Count_And_Get
1086: ( p_count => x_msg_count,
1087: p_data => x_msg_data
1088: );

Line 1092: x_return_status := FND_API.G_RET_STS_ERROR;

1088: );
1089:
1090: WHEN OTHERS THEN
1091: ROLLBACK TO create_emailproc_rules_PVT;
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: IF FND_MSG_PUB.Check_Msg_Level
1094: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1095: THEN
1096: FND_MSG_PUB.Add_Exc_Msg

Line 1128: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1124: -- Standard Start of API savepoint
1125: SAVEPOINT create_item_actions_PVT;
1126:
1127: -- Standard call to check for call compatibility.
1128: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1129: p_api_version_number,
1130:
1131: l_api_name,
1132: G_PKG_NAME)

Line 1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1130:
1131: l_api_name,
1132: G_PKG_NAME)
1133: THEN
1134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1135: END IF;
1136:
1137: -- Initialize message list if p_init_msg_list is set to TRUE.
1138:

Line 1139: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1135: END IF;
1136:
1137: -- Initialize message list if p_init_msg_list is set to TRUE.
1138:
1139: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1140: FND_MSG_PUB.initialize;
1141: END IF;
1142:
1143: -- Initialize API return status to SUCCESS

Line 1145: x_return_status := FND_API.G_RET_STS_SUCCESS;

1141: END IF;
1142:
1143: -- Initialize API return status to SUCCESS
1144:
1145: x_return_status := FND_API.G_RET_STS_SUCCESS;
1146:
1147: --actual API begins here
1148: SELECT IEM_ACTIONS_s1.nextval
1149: INTO l_seq_id

Line 1210: IF FND_API.To_Boolean(p_commit) THEN

1206:
1207: x_action_id := l_seq_id;
1208:
1209: -- Standard Check Of p_commit.
1210: IF FND_API.To_Boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:
1214: -- Standard callto get message count and if count is 1, get message info.

Line 1221: WHEN FND_API.G_EXC_ERROR THEN

1217: p_data => x_msg_data
1218: );
1219:
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
1222:
1223: ROLLBACK TO create_item_actions_PVT;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1225: x_return_status := FND_API.G_RET_STS_ERROR ;

1221: WHEN FND_API.G_EXC_ERROR THEN
1222:
1223: ROLLBACK TO create_item_actions_PVT;
1224:
1225: x_return_status := FND_API.G_RET_STS_ERROR ;
1226: FND_MSG_PUB.Count_And_Get
1227: ( p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );

Line 1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1227: ( p_count => x_msg_count,
1228: p_data => x_msg_data
1229: );
1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: ROLLBACK TO create_item_actions_PVT;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: FND_MSG_PUB.Count_And_Get
1235: ( p_count => x_msg_count,

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1229: );
1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: ROLLBACK TO create_item_actions_PVT;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1234: FND_MSG_PUB.Count_And_Get
1235: ( p_count => x_msg_count,
1236:
1237: p_data => x_msg_data

Line 1243: x_return_status := FND_API.G_RET_STS_ERROR;

1239:
1240:
1241: WHEN OTHERS THEN
1242: ROLLBACK TO create_item_actions_PVT;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: IF FND_MSG_PUB.Check_Msg_Level
1245: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1246: THEN
1247: FND_MSG_PUB.Add_Exc_Msg

Line 1283: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1279: -- Standard Start of API savepoint
1280: SAVEPOINT create_item_action_dtls_pvt;
1281:
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1284: p_api_version_number,
1285:
1286: l_api_name,
1287: G_PKG_NAME)

Line 1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1285:
1286: l_api_name,
1287: G_PKG_NAME)
1288: THEN
1289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293:

Line 1294: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1290: END IF;
1291:
1292: -- Initialize message list if p_init_msg_list is set to TRUE.
1293:
1294: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1295: FND_MSG_PUB.initialize;
1296: END IF;
1297:
1298: -- Initialize API return status to SUCCESS

Line 1300: x_return_status := FND_API.G_RET_STS_SUCCESS;

1296: END IF;
1297:
1298: -- Initialize API return status to SUCCESS
1299:
1300: x_return_status := FND_API.G_RET_STS_SUCCESS;
1301:
1302: --actual API begins here
1303: SELECT IEM_ACTION_DTLS_s1.nextval
1304: INTO l_seq_id

Line 1369: IF FND_API.To_Boolean(p_commit) THEN

1365:
1366: -- Standard Check Of p_commit.
1367:
1368:
1369: IF FND_API.To_Boolean(p_commit) THEN
1370: COMMIT WORK;
1371: END IF;
1372:
1373: -- Standard callto get message count and if count is 1, get message info.

Line 1380: WHEN FND_API.G_EXC_ERROR THEN

1376: p_data => x_msg_data
1377: );
1378:
1379: EXCEPTION
1380: WHEN FND_API.G_EXC_ERROR THEN
1381:
1382: ROLLBACK TO create_item_action_dtls_pvt;
1383:
1384: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR ;

1380: WHEN FND_API.G_EXC_ERROR THEN
1381:
1382: ROLLBACK TO create_item_action_dtls_pvt;
1383:
1384: x_return_status := FND_API.G_RET_STS_ERROR ;
1385: FND_MSG_PUB.Count_And_Get
1386: ( p_count => x_msg_count,
1387: p_data => x_msg_data
1388: );

Line 1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1386: ( p_count => x_msg_count,
1387: p_data => x_msg_data
1388: );
1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: ROLLBACK TO create_item_action_dtls_pvt;
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1393: FND_MSG_PUB.Count_And_Get
1394: ( p_count => x_msg_count,

Line 1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1388: );
1389:
1390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1391: ROLLBACK TO create_item_action_dtls_pvt;
1392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1393: FND_MSG_PUB.Count_And_Get
1394: ( p_count => x_msg_count,
1395:
1396: p_data => x_msg_data

Line 1402: x_return_status := FND_API.G_RET_STS_ERROR;

1398:
1399:
1400: WHEN OTHERS THEN
1401: ROLLBACK TO create_item_action_dtls_pvt;
1402: x_return_status := FND_API.G_RET_STS_ERROR;
1403: IF FND_MSG_PUB.Check_Msg_Level
1404: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: THEN
1406: FND_MSG_PUB.Add_Exc_Msg

Line 1444: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1440:
1441: SAVEPOINT delete_acct_emailproc_batch;
1442:
1443: -- Standard call to check for call compatibility.
1444: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1445: p_api_version_number,
1446: l_api_name,
1447: G_PKG_NAME)
1448: THEN

Line 1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1445: p_api_version_number,
1446: l_api_name,
1447: G_PKG_NAME)
1448: THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: END IF;
1451:
1452:
1453: --Initialize the message list if p_init_msg_list is set to TRUE

Line 1455: If FND_API.to_Boolean(p_init_msg_list) THEN

1451:
1452:
1453: --Initialize the message list if p_init_msg_list is set to TRUE
1454:
1455: If FND_API.to_Boolean(p_init_msg_list) THEN
1456: FND_MSG_PUB.initialize;
1457: END IF;
1458:
1459: --Initialize API status return

Line 1460: x_return_status := FND_API.G_RET_STS_SUCCESS;

1456: FND_MSG_PUB.initialize;
1457: END IF;
1458:
1459: --Initialize API status return
1460: x_return_status := FND_API.G_RET_STS_SUCCESS;
1461:
1462: --Actual API starts here
1463: if ( p_emailproc_ids_tbl.count <> 0 ) then
1464:

Line 1492: IF FND_API.to_Boolean(p_commit) THEN

1488: -- raise IEM_ACCOUNT_ROUTE_NOT_DELETED;
1489: --end if;
1490:
1491: --Standard check of p_commit
1492: IF FND_API.to_Boolean(p_commit) THEN
1493: COMMIT WORK;
1494: END IF;
1495:
1496:

Line 1499: WHEN FND_API.G_EXC_ERROR THEN

1495:
1496:
1497: EXCEPTION
1498:
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK TO delete_acct_emailproc_batch;
1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502: FND_MSG_PUB.Count_And_Get
1503: ( p_count => x_msg_count,p_data => x_msg_data);

Line 1501: x_return_status := FND_API.G_RET_STS_ERROR ;

1497: EXCEPTION
1498:
1499: WHEN FND_API.G_EXC_ERROR THEN
1500: ROLLBACK TO delete_acct_emailproc_batch;
1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502: FND_MSG_PUB.Count_And_Get
1503: ( p_count => x_msg_count,p_data => x_msg_data);
1504:
1505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1501: x_return_status := FND_API.G_RET_STS_ERROR ;
1502: FND_MSG_PUB.Count_And_Get
1503: ( p_count => x_msg_count,p_data => x_msg_data);
1504:
1505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1506:
1507: ROLLBACK TO delete_acct_emailproc_batch;
1508:
1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1506:
1507: ROLLBACK TO delete_acct_emailproc_batch;
1508:
1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1510: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1511:
1512: WHEN OTHERS THEN
1513: ROLLBACK TO delete_acct_emailproc_batch;

Line 1514: x_return_status := FND_API.G_RET_STS_ERROR;

1510: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
1511:
1512: WHEN OTHERS THEN
1513: ROLLBACK TO delete_acct_emailproc_batch;
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1516: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1517: END IF;
1518: