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

Line 47: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 58: If FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 63: x_return_status := FND_API.G_RET_STS_SUCCESS;

59: FND_MSG_PUB.initialize;
60: END IF;
61:
62: --Initialize API status return
63: x_return_status := FND_API.G_RET_STS_SUCCESS;
64:
65: --Actual API starts here
66: DELETE
67: FROM IEM_ACCOUNT_ROUTES

Line 72: IF FND_API.to_Boolean(p_commit) THEN

68: WHERE email_account_id = p_email_account_id;
69:
70:
71: --Standard check of p_commit
72: IF FND_API.to_Boolean(p_commit) THEN
73: COMMIT WORK;
74: END IF;
75:
76: FND_MSG_PUB.Count_And_Get

Line 80: WHEN FND_API.G_EXC_ERROR THEN

76: FND_MSG_PUB.Count_And_Get
77: ( p_count => x_msg_count,p_data => x_msg_data);
78:
79: EXCEPTION
80: WHEN FND_API.G_EXC_ERROR THEN
81: ROLLBACK TO delete_acct_route_by_acct;
82: x_return_status := FND_API.G_RET_STS_ERROR ;
83: FND_MSG_PUB.Count_And_Get
84:

Line 82: x_return_status := FND_API.G_RET_STS_ERROR ;

78:
79: EXCEPTION
80: WHEN FND_API.G_EXC_ERROR THEN
81: ROLLBACK TO delete_acct_route_by_acct;
82: x_return_status := FND_API.G_RET_STS_ERROR ;
83: FND_MSG_PUB.Count_And_Get
84:
85: ( p_count => x_msg_count,p_data => x_msg_data);
86:

Line 87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

83: FND_MSG_PUB.Count_And_Get
84:
85: ( p_count => x_msg_count,p_data => x_msg_data);
86:
87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
88: ROLLBACK TO delete_acct_route_by_acct;
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
90: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
91:

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

85: ( p_count => x_msg_count,p_data => x_msg_data);
86:
87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
88: ROLLBACK TO delete_acct_route_by_acct;
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
90: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
91:
92:
93: WHEN OTHERS THEN

Line 95: x_return_status := FND_API.G_RET_STS_ERROR;

91:
92:
93: WHEN OTHERS THEN
94: ROLLBACK TO delete_acct_route_by_acct;
95: x_return_status := FND_API.G_RET_STS_ERROR;
96: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
97: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
98:
99: END IF;

Line 130: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

126: --Standard Savepoint
127: SAVEPOINT delete_item_batch;
128:
129: -- Standard call to check for call compatibility.
130: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
131: p_api_version_number,
132: l_api_name,
133: G_PKG_NAME)
134: THEN

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: p_api_version_number,
132: l_api_name,
133: G_PKG_NAME)
134: THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137:
138:
139:

Line 141: If FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: FND_MSG_PUB.initialize;
143: END IF;
144:
145: --Initialize API status return
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: --Actual API starts here
149: FORALL i IN p_route_ids_tbl.FIRST..p_route_ids_tbl.LAST
150: DELETE

Line 188: IF FND_API.to_Boolean(p_commit) THEN

184:
185: end if;
186:
187: --Standard check of p_commit
188: IF FND_API.to_Boolean(p_commit) THEN
189: COMMIT WORK;
190: END IF;
191:
192:

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: EXCEPTION
194:
195: WHEN IEM_ROUTE_NOT_DELETED THEN
196: ROLLBACK TO delete_item_batch;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MESSAGE.SET_NAME('IEM', 'IEM_ROUTE_NOT_DELETED');
199:
200: FND_MSG_PUB.ADD;
201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199:
200: FND_MSG_PUB.ADD;
201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO delete_item_batch;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,p_data => x_msg_data);

Line 205: x_return_status := FND_API.G_RET_STS_ERROR ;

201: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: ROLLBACK TO delete_item_batch;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,p_data => x_msg_data);
208:
209:

Line 210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206: FND_MSG_PUB.Count_And_Get
207: ( p_count => x_msg_count,p_data => x_msg_data);
208:
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO delete_item_batch;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
214:

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

208:
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: ROLLBACK TO delete_item_batch;
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
214:
215:
216: WHEN OTHERS THEN

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214:
215:
216: WHEN OTHERS THEN
217: ROLLBACK TO delete_item_batch;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
220: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
221: END IF;
222:

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

252:
253: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
254: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
255:
256: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
257: l_msg_count NUMBER := 0;
258: l_msg_data VARCHAR2(2000);
259:
260: logMessage VARCHAR2(2000);

Line 272: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

268: -- Standard Start of API savepoint
269: SAVEPOINT create_item_wrap;
270:
271: -- Standard call to check for call compatibility.
272: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
273: p_api_version_number,
274: l_api_name,
275: G_PKG_NAME)
276: THEN

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274: l_api_name,
275: G_PKG_NAME)
276: THEN
277:
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280:
281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 283: IF FND_API.to_Boolean( p_init_msg_list )

279: END IF;
280:
281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.
283: IF FND_API.to_Boolean( p_init_msg_list )
284: THEN
285: FND_MSG_PUB.initialize;
286: END IF;
287:

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: FND_MSG_PUB.initialize;
286: END IF;
287:
288: -- Initialize API return status to SUCCESS
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: --API Body
292: /*
293: FND_LOG_REPOSITORY.init(null,null);

Line 304: l_return_type := FND_API.G_MISS_CHAR;

300: --Now call the create_item() to create the acccount
301: if ( p_route_boolean_type_code = 'DYNAMIC' ) then
302: l_return_type := p_rule_key_typecode_tbl(1);
303: else
304: l_return_type := FND_API.G_MISS_CHAR;
305: end if;
306:
307: iem_route_pvt.create_item_routes (
308: p_api_version_number=>p_api_version_number,

Line 310: p_commit => FND_API.G_FALSE,

306:
307: iem_route_pvt.create_item_routes (
308: p_api_version_number=>p_api_version_number,
309: p_init_msg_list => p_init_msg_list,
310: p_commit => FND_API.G_FALSE,
311: p_name => p_route_name,
312: p_description => p_route_description,
313: p_boolean_type_code =>p_route_boolean_type_code,
314: p_proc_name => p_proc_name,

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

318: x_msg_count => l_msg_count,
319: x_msg_data => l_msg_data);
320:
321:
322: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
323:
324: raise IEM_ROUTE_NOT_CREATED;
325: end if;
326:

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

347: x_msg_count => l_msg_count,
348: x_msg_data => l_msg_data);
349:
350:
351: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
352: raise IEM_ROUTE_RULE_NOT_CREATED;
353: end if;
354: end loop;
355: end if;

Line 357: IF FND_API.To_Boolean(p_commit) THEN

353: end if;
354: end loop;
355: end if;
356: -- Standard Check Of p_commit.
357: IF FND_API.To_Boolean(p_commit) THEN
358: COMMIT WORK;
359: END IF;
360:
361: -- Standard callto get message count and if count is 1, get message info.

Line 369: x_return_status := FND_API.G_RET_STS_ERROR ;

365: );
366: EXCEPTION
367: WHEN IEM_ROUTE_NOT_CREATED THEN
368: ROLLBACK TO create_item_wrap;
369: x_return_status := FND_API.G_RET_STS_ERROR ;
370: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
371:
372:
373: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN

Line 378: x_return_status := FND_API.G_RET_STS_ERROR ;

374:
375: ROLLBACK TO create_item_wrap;
376: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
380:
381:
382: WHEN FND_API.G_EXC_ERROR THEN

Line 382: WHEN FND_API.G_EXC_ERROR THEN

378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
380:
381:
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO create_item_wrap;
384: x_return_status := FND_API.G_RET_STS_ERROR ;
385: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
386:

Line 384: x_return_status := FND_API.G_RET_STS_ERROR ;

380:
381:
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO create_item_wrap;
384: x_return_status := FND_API.G_RET_STS_ERROR ;
385: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
386:
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

384: x_return_status := FND_API.G_RET_STS_ERROR ;
385: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
386:
387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389:
390: ROLLBACK TO create_item_wrap;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

387:
388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
389:
390: ROLLBACK TO create_item_wrap;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
393:
394: WHEN OTHERS THEN
395: ROLLBACK TO create_item_wrap;

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

392: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
393:
394: WHEN OTHERS THEN
395: ROLLBACK TO create_item_wrap;
396: x_return_status := FND_API.G_RET_STS_ERROR;
397: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
398: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
399: END IF;
400:

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

424: l_proc_name VARCHAR2(256);
425: l_name_count NUMBER;
426: l_all_email VARCHAR2(1);
427: l_description VARCHAR2(256);
428: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
429: l_msg_count NUMBER := 0;
430: l_msg_data VARCHAR2(2000);
431:
432: IEM_ADMIN_ROUTE_DUP_NAME EXCEPTION;

Line 442: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

438: SAVEPOINT create_item_routes_PVT;
439:
440: -- Standard call to check for call compatibility.
441:
442: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
443: p_api_version_number,
444: l_api_name,
445: G_PKG_NAME)
446: THEN

Line 447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

443: p_api_version_number,
444: l_api_name,
445: G_PKG_NAME)
446: THEN
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: END IF;
449:
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 452: IF FND_API.to_Boolean( p_init_msg_list )

448: END IF;
449:
450:
451: -- Initialize message list if p_init_msg_list is set to TRUE.
452: IF FND_API.to_Boolean( p_init_msg_list )
453: THEN
454: FND_MSG_PUB.initialize;
455: END IF;
456:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455: END IF;
456:
457:
458: -- Initialize API return status to SUCCESS
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: --begins here
462:
463: --check duplicate value for attribute Name

Line 470: if p_all_email is null or p_all_email = FND_API.G_MISS_CHAR then

466: if l_name_count > 0 then
467: raise IEM_ADMIN_ROUTE_DUP_NAME;
468: end if;
469:
470: if p_all_email is null or p_all_email = FND_API.G_MISS_CHAR then
471: l_all_email := 'N';
472: elsif ( p_all_email <> 'N' and p_all_email<>'Y') then
473: l_all_email := 'N';
474: else

Line 479: if p_proc_name is null or p_proc_name = FND_API.G_MISS_CHAR then

475: l_all_email := p_all_email;
476: end if;
477:
478: if ( p_boolean_type_code = 'DYNAMIC' ) then
479: if p_proc_name is null or p_proc_name = FND_API.G_MISS_CHAR then
480: raise IEM_ADM_NO_PROCEDURE_NAME;
481: else
482: l_proc_name := LTRIM(RTRIM( p_proc_name ) );
483: --validation goes here.

Line 486: p_init_msg_list => FND_API.G_FALSE,

482: l_proc_name := LTRIM(RTRIM( p_proc_name ) );
483: --validation goes here.
484: IEM_ROUTE_RUN_PROC_PVT.validProcedure(
485: p_api_version_number => P_Api_Version_Number,
486: p_init_msg_list => FND_API.G_FALSE,
487: p_commit => P_Commit,
488: p_ProcName => l_proc_name,
489: p_return_type => p_return_type,
490: x_return_status => l_return_status,

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

490: x_return_status => l_return_status,
491: x_msg_count => l_msg_count,
492: x_msg_data => l_msg_data
493: );
494: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
495: raise l_IEM_INVALID_PROCEDURE;
496: end if;
497: end if;
498: else

Line 502: if p_description=FND_API.G_MISS_CHAR then

498: else
499: l_proc_name := null;
500: end if;
501:
502: if p_description=FND_API.G_MISS_CHAR then
503: l_description := null;
504: else
505: l_description := p_description;
506: end if;

Line 582: IF FND_API.To_Boolean(p_commit) THEN

578:
579: );
580:
581: -- Standard Check Of p_commit.
582: IF FND_API.To_Boolean(p_commit) THEN
583: COMMIT WORK;
584: END IF;
585:
586: -- Standard callto get message count and if count is 1, get message info.

Line 597: x_return_status := FND_API.G_RET_STS_ERROR ;

593:
594: EXCEPTION
595: WHEN l_IEM_INVALID_PROCEDURE THEN
596: ROLLBACK TO create_item_routes_PVT;
597: x_return_status := FND_API.G_RET_STS_ERROR ;
598: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
599:
600: WHEN IEM_ADMIN_ROUTE_DUP_NAME THEN
601: ROLLBACK TO create_item_routes_PVT;

Line 604: x_return_status := FND_API.G_RET_STS_ERROR ;

600: WHEN IEM_ADMIN_ROUTE_DUP_NAME THEN
601: ROLLBACK TO create_item_routes_PVT;
602: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_DUP_NAME');
603: FND_MSG_PUB.Add;
604: x_return_status := FND_API.G_RET_STS_ERROR ;
605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
606:
607: WHEN IEM_ADM_NO_PROCEDURE_NAME THEN
608: ROLLBACK TO create_item_routes_PVT;

Line 611: x_return_status := FND_API.G_RET_STS_ERROR ;

607: WHEN IEM_ADM_NO_PROCEDURE_NAME THEN
608: ROLLBACK TO create_item_routes_PVT;
609: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_NO_PROCEDURE_NAME');
610: FND_MSG_PUB.Add;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615: ROLLBACK TO create_item_routes_PVT;

Line 614: WHEN FND_API.G_EXC_ERROR THEN

610: FND_MSG_PUB.Add;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615: ROLLBACK TO create_item_routes_PVT;
616: x_return_status := FND_API.G_RET_STS_ERROR ;
617:
618: FND_MSG_PUB.Count_And_Get

Line 616: x_return_status := FND_API.G_RET_STS_ERROR ;

612: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
613:
614: WHEN FND_API.G_EXC_ERROR THEN
615: ROLLBACK TO create_item_routes_PVT;
616: x_return_status := FND_API.G_RET_STS_ERROR ;
617:
618: FND_MSG_PUB.Count_And_Get
619:
620: ( p_count => x_msg_count,

Line 624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

620: ( p_count => x_msg_count,
621: p_data => x_msg_data
622: );
623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: ROLLBACK TO create_item_routes_PVT;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: ( p_count => x_msg_count,

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

622: );
623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: ROLLBACK TO create_item_routes_PVT;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
627: FND_MSG_PUB.Count_And_Get
628: ( p_count => x_msg_count,
629: p_data => x_msg_data
630: );

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632:
633: WHEN OTHERS THEN
634:
635: ROLLBACK TO create_item_routes_PVT;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: IF FND_MSG_PUB.Check_Msg_Level
638: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg

Line 695: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

691: -- Standard Start of API savepoint
692:
693: SAVEPOINT create_item_route_rules_PVT;
694: -- Standard call to check for call compatibility.
695: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
696: p_api_version_number,
697: l_api_name,
698: G_PKG_NAME)
699:

Line 701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

697: l_api_name,
698: G_PKG_NAME)
699:
700: THEN
701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: -- Initialize message list if p_init_msg_list is set to TRUE.
705: IF FND_API.to_Boolean( p_init_msg_list )

Line 705: IF FND_API.to_Boolean( p_init_msg_list )

701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
702: END IF;
703:
704: -- Initialize message list if p_init_msg_list is set to TRUE.
705: IF FND_API.to_Boolean( p_init_msg_list )
706: THEN
707:
708: FND_MSG_PUB.initialize;
709: END IF;

Line 712: x_return_status := FND_API.G_RET_STS_SUCCESS;

708: FND_MSG_PUB.initialize;
709: END IF;
710:
711: -- Initialize API return status to SUCCESS
712: x_return_status := FND_API.G_RET_STS_SUCCESS;
713:
714:
715:
716: /*

Line 808: IF FND_API.To_Boolean(p_commit) THEN

804: decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
805: );
806:
807: -- Standard Check Of p_commit.
808: IF FND_API.To_Boolean(p_commit) THEN
809:
810: COMMIT WORK;
811:
812: END IF;

Line 824: WHEN FND_API.G_EXC_ERROR THEN

820: EXCEPTION
821:
822:
823:
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO create_item_route_rules_PVT;
826:
827: x_return_status := FND_API.G_RET_STS_ERROR ;
828: FND_MSG_PUB.Count_And_Get

Line 827: x_return_status := FND_API.G_RET_STS_ERROR ;

823:
824: WHEN FND_API.G_EXC_ERROR THEN
825: ROLLBACK TO create_item_route_rules_PVT;
826:
827: x_return_status := FND_API.G_RET_STS_ERROR ;
828: FND_MSG_PUB.Count_And_Get
829: ( p_count => x_msg_count,
830: p_data => x_msg_data
831: );

Line 833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

829: ( p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832:
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834: ROLLBACK TO create_item_route_rules_PVT;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
836: FND_MSG_PUB.Count_And_Get
837:

Line 835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

831: );
832:
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834: ROLLBACK TO create_item_route_rules_PVT;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
836: FND_MSG_PUB.Count_And_Get
837:
838: ( p_count => x_msg_count,
839: p_data => x_msg_data

Line 845: x_return_status := FND_API.G_RET_STS_ERROR;

841:
842:
843: WHEN OTHERS THEN
844: ROLLBACK TO create_item_route_rules_PVT;
845: x_return_status := FND_API.G_RET_STS_ERROR;
846: IF FND_MSG_PUB.Check_Msg_Level
847: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg

Line 889: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

885: -- Standard Start of API savepoint
886: SAVEPOINT create_item_acct_routes_PVT;
887:
888: -- Standard call to check for call compatibility.
889: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
890: p_api_version_number,
891:
892: l_api_name,
893: G_PKG_NAME)

Line 895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

891:
892: l_api_name,
893: G_PKG_NAME)
894: THEN
895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
896: END IF;
897:
898: -- Initialize message list if p_init_msg_list is set to TRUE.
899:

Line 900: IF FND_API.to_Boolean( p_init_msg_list ) THEN

896: END IF;
897:
898: -- Initialize message list if p_init_msg_list is set to TRUE.
899:
900: IF FND_API.to_Boolean( p_init_msg_list ) THEN
901: FND_MSG_PUB.initialize;
902: END IF;
903:
904: -- Initialize API return status to SUCCESS

Line 906: x_return_status := FND_API.G_RET_STS_SUCCESS;

902: END IF;
903:
904: -- Initialize API return status to SUCCESS
905:
906: x_return_status := FND_API.G_RET_STS_SUCCESS;
907:
908: --actual API begins here
909: SELECT IEM_ACCOUNT_ROUTES_s1.nextval
910: INTO l_seq_id

Line 989: IF FND_API.To_Boolean(p_commit) THEN

985:
986: -- Standard Check Of p_commit.
987:
988:
989: IF FND_API.To_Boolean(p_commit) THEN
990: COMMIT WORK;
991: END IF;
992:
993: -- Standard callto get message count and if count is 1, get message info.

Line 1000: WHEN FND_API.G_EXC_ERROR THEN

996: p_data => x_msg_data
997: );
998:
999: EXCEPTION
1000: WHEN FND_API.G_EXC_ERROR THEN
1001:
1002: ROLLBACK TO create_item_acct_routes_PVT;
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR ;

1000: WHEN FND_API.G_EXC_ERROR THEN
1001:
1002: ROLLBACK TO create_item_acct_routes_PVT;
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR ;
1005: FND_MSG_PUB.Count_And_Get
1006: ( p_count => x_msg_count,
1007: p_data => x_msg_data
1008: );

Line 1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1006: ( p_count => x_msg_count,
1007: p_data => x_msg_data
1008: );
1009:
1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011: ROLLBACK TO create_item_acct_routes_PVT;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013: FND_MSG_PUB.Count_And_Get
1014: ( p_count => x_msg_count,

Line 1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1008: );
1009:
1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011: ROLLBACK TO create_item_acct_routes_PVT;
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013: FND_MSG_PUB.Count_And_Get
1014: ( p_count => x_msg_count,
1015:
1016: p_data => x_msg_data

Line 1022: x_return_status := FND_API.G_RET_STS_ERROR;

1018:
1019:
1020: WHEN OTHERS THEN
1021: ROLLBACK TO create_item_acct_routes_PVT;
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: IF FND_MSG_PUB.Check_Msg_Level
1024: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1025: THEN
1026: FND_MSG_PUB.Add_Exc_Msg

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

1064:
1065: l_api_name VARCHAR2(255):='update_item_wrap';
1066: l_api_version_number NUMBER:=1.0;
1067:
1068: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1069: l_msg_count NUMBER := 0;
1070: l_msg_data VARCHAR2(2000);
1071:
1072: IEM_NO_ROUTE_UPDATE EXCEPTION;

Line 1090: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1086: -- Standard Start of API savepoint
1087: SAVEPOINT update_item_wrap;
1088:
1089: -- Standard call to check for call compatibility.
1090: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1091:
1092: p_api_version_number,
1093: l_api_name,
1094: G_PKG_NAME)

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: p_api_version_number,
1093: l_api_name,
1094: G_PKG_NAME)
1095: THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097:
1098: END IF;
1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1101: IF FND_API.to_Boolean( p_init_msg_list )

1097:
1098: END IF;
1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.
1101: IF FND_API.to_Boolean( p_init_msg_list )
1102: THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105:

Line 1108: x_return_status := FND_API.G_RET_STS_SUCCESS;

1104: END IF;
1105:
1106:
1107: -- Initialize API return status to SUCCESS
1108: x_return_status := FND_API.G_RET_STS_SUCCESS;
1109:
1110: --API Body
1111:
1112:

Line 1126: l_proc_name := FND_API.G_MISS_CHAR;

1122: l_proc_name := LTRIM(RTRIM( p_procedure_name ) );
1123: l_return_type := p_update_rule_keys_tbl(1);
1124: --validation goes here
1125: else
1126: l_proc_name := FND_API.G_MISS_CHAR;
1127: l_return_type := FND_API.G_MISS_CHAR;
1128: end if;
1129:
1130: --update iem_routes table

Line 1127: l_return_type := FND_API.G_MISS_CHAR;

1123: l_return_type := p_update_rule_keys_tbl(1);
1124: --validation goes here
1125: else
1126: l_proc_name := FND_API.G_MISS_CHAR;
1127: l_return_type := FND_API.G_MISS_CHAR;
1128: end if;
1129:
1130: --update iem_routes table
1131: if p_description is null then

Line 1132: l_description := FND_API.G_MISS_CHAR;

1128: end if;
1129:
1130: --update iem_routes table
1131: if p_description is null then
1132: l_description := FND_API.G_MISS_CHAR;
1133: elsif l_description = FND_API.G_MISS_CHAR then
1134: l_description := null;
1135: else
1136: l_description := p_description;

Line 1133: elsif l_description = FND_API.G_MISS_CHAR then

1129:
1130: --update iem_routes table
1131: if p_description is null then
1132: l_description := FND_API.G_MISS_CHAR;
1133: elsif l_description = FND_API.G_MISS_CHAR then
1134: l_description := null;
1135: else
1136: l_description := p_description;
1137: end if;

Line 1140: p_init_msg_list => FND_API.G_FALSE,

1136: l_description := p_description;
1137: end if;
1138: iem_route_pvt.update_item_route(
1139: p_api_version_number => l_api_version_number,
1140: p_init_msg_list => FND_API.G_FALSE,
1141: p_commit => FND_API.G_FALSE,
1142: p_route_id => p_route_id,
1143: p_name => p_name,
1144: p_all_emails => p_all_emails,

Line 1141: p_commit => FND_API.G_FALSE,

1137: end if;
1138: iem_route_pvt.update_item_route(
1139: p_api_version_number => l_api_version_number,
1140: p_init_msg_list => FND_API.G_FALSE,
1141: p_commit => FND_API.G_FALSE,
1142: p_route_id => p_route_id,
1143: p_name => p_name,
1144: p_all_emails => p_all_emails,
1145: p_description =>l_description,

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

1150: x_msg_count => l_msg_count,
1151: x_msg_data => l_msg_data);
1152:
1153:
1154: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1155: raise l_IEM_FAIL_TO_CALL;
1156: end if;
1157:
1158:

Line 1164: p_init_msg_list => FND_API.G_FALSE,

1160: if ( p_update_rule_ids_tbl.count <>0 ) then
1161:
1162: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
1163: iem_route_pvt.update_item_rule(p_api_version_number => l_api_version_number,
1164: p_init_msg_list => FND_API.G_FALSE,
1165: p_commit => FND_API.G_FALSE,
1166: p_route_rule_id => p_update_rule_ids_tbl(i),
1167: p_key_type_code =>p_update_rule_keys_tbl(i),
1168: p_operator_type_code =>p_update_rule_operators_tbl(i),

Line 1165: p_commit => FND_API.G_FALSE,

1161:
1162: FOR i IN p_update_rule_ids_tbl.FIRST..p_update_rule_ids_tbl.LAST loop
1163: iem_route_pvt.update_item_rule(p_api_version_number => l_api_version_number,
1164: p_init_msg_list => FND_API.G_FALSE,
1165: p_commit => FND_API.G_FALSE,
1166: p_route_rule_id => p_update_rule_ids_tbl(i),
1167: p_key_type_code =>p_update_rule_keys_tbl(i),
1168: p_operator_type_code =>p_update_rule_operators_tbl(i),
1169: p_value => p_update_rule_values_tbl(i),

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

1171: x_return_status => l_return_status,
1172: x_msg_count => l_msg_count,
1173: x_msg_data => l_msg_data);
1174:
1175: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1176: raise IEM_NO_RULE_UPDATE;
1177: end if;
1178: end loop;
1179: end if;

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

1205: x_return_status =>l_return_status,
1206: x_msg_count => l_msg_count,
1207: x_msg_data => l_msg_data);
1208:
1209: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1210: raise IEM_ROUTE_RULE_NOT_CREATED;
1211: end if;
1212: END LOOP;
1213: end if;

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR ;

1229: ROLLBACK TO update_item_wrap;
1230: -- FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
1231:
1232: -- FND_MSG_PUB.Add;
1233: x_return_status := FND_API.G_RET_STS_ERROR ;
1234: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1235:
1236: WHEN IEM_NO_ROUTE_UPDATE THEN
1237: ROLLBACK TO update_item_wrap;

Line 1241: x_return_status := FND_API.G_RET_STS_ERROR ;

1237: ROLLBACK TO update_item_wrap;
1238: FND_MESSAGE.SET_NAME('IEM','IEM_NO_ROUTE_UPDATE');
1239:
1240: FND_MSG_PUB.Add;
1241: x_return_status := FND_API.G_RET_STS_ERROR ;
1242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1243: WHEN IEM_NO_RULE_UPDATE THEN
1244: ROLLBACK TO update_item_wrap;
1245: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR ;

1243: WHEN IEM_NO_RULE_UPDATE THEN
1244: ROLLBACK TO update_item_wrap;
1245: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1246: FND_MSG_PUB.Add;
1247: x_return_status := FND_API.G_RET_STS_ERROR ;
1248: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1249:
1250: WHEN IEM_RULE_NOT_DELETED THEN
1251:

Line 1255: x_return_status := FND_API.G_RET_STS_ERROR ;

1251:
1252: ROLLBACK TO update_item_wrap;
1253: FND_MESSAGE.SET_NAME('IEM','IEM_RULE_NOT_DELETED');
1254: FND_MSG_PUB.Add;
1255: x_return_status := FND_API.G_RET_STS_ERROR ;
1256:
1257: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1258:
1259: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN

Line 1263: x_return_status := FND_API.G_RET_STS_ERROR ;

1259: WHEN IEM_ROUTE_RULE_NOT_CREATED THEN
1260: ROLLBACK TO update_item_wrap;
1261: FND_MESSAGE.SET_NAME('IEM','IEM_ROUTE_RULE_NOT_CREATED');
1262: FND_MSG_PUB.Add;
1263: x_return_status := FND_API.G_RET_STS_ERROR ;
1264: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1265:
1266:
1267: WHEN IEM_ADMIN_ROUTE_NO_RULE THEN

Line 1272: x_return_status := FND_API.G_RET_STS_ERROR ;

1268: ROLLBACK TO update_item_wrap;
1269: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_RULE');
1270: FND_MSG_PUB.Add;
1271:
1272: x_return_status := FND_API.G_RET_STS_ERROR ;
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO update_item_wrap;

Line 1275: WHEN FND_API.G_EXC_ERROR THEN

1271:
1272: x_return_status := FND_API.G_RET_STS_ERROR ;
1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO update_item_wrap;
1277: x_return_status := FND_API.G_RET_STS_ERROR ;
1278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1279:

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR ;

1273: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO update_item_wrap;
1277: x_return_status := FND_API.G_RET_STS_ERROR ;
1278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1279:
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1277: x_return_status := FND_API.G_RET_STS_ERROR ;
1278: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,p_data => x_msg_data);
1279:
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: ROLLBACK TO update_item_wrap;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1284: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1285:

Line 1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1279:
1280:
1281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1282: ROLLBACK TO update_item_wrap;
1283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1284: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1285:
1286:
1287: WHEN OTHERS THEN

Line 1289: x_return_status := FND_API.G_RET_STS_ERROR;

1285:
1286:
1287: WHEN OTHERS THEN
1288: ROLLBACK TO update_item_wrap;
1289: x_return_status := FND_API.G_RET_STS_ERROR;
1290: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1291: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
1292: END IF;
1293:

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

1312: x_msg_data OUT NOCOPY VARCHAR2
1313: ) is
1314: l_api_name VARCHAR2(255):='update_item_route';
1315: l_api_version_number NUMBER:=1.0;
1316: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1317: l_msg_count NUMBER := 0;
1318: l_msg_data VARCHAR2(2000);
1319: l_proc_name VARCHAR2(256);
1320: l_name_count NUMBER;

Line 1330: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1326: -- Standard Start of API savepoint
1327: SAVEPOINT update_item_route;
1328:
1329: -- Standard call to check for call compatibility.
1330: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1331: p_api_version_number,
1332: l_api_name,
1333: G_PKG_NAME)
1334: THEN

Line 1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1332: l_api_name,
1333: G_PKG_NAME)
1334: THEN
1335:
1336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1337: END IF;
1338:
1339:
1340: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1341: IF FND_API.to_Boolean( p_init_msg_list )

1337: END IF;
1338:
1339:
1340: -- Initialize message list if p_init_msg_list is set to TRUE.
1341: IF FND_API.to_Boolean( p_init_msg_list )
1342: THEN
1343: FND_MSG_PUB.initialize;
1344: END IF;
1345:

Line 1347: x_return_status := FND_API.G_RET_STS_SUCCESS;

1343: FND_MSG_PUB.initialize;
1344: END IF;
1345:
1346: -- Initialize API return status to SUCCESS
1347: x_return_status := FND_API.G_RET_STS_SUCCESS;
1348:
1349: --check duplicate value for attribute Name
1350:
1351: select count(*) into l_name_count from iem_routes where UPPER(name) = UPPER(p_name) and route_id <> p_route_id;

Line 1370: p_init_msg_list => FND_API.G_FALSE,

1366: else
1367: --validation goes here.
1368: IEM_ROUTE_RUN_PROC_PVT.validProcedure(
1369: p_api_version_number => P_Api_Version_Number,
1370: p_init_msg_list => FND_API.G_FALSE,
1371: p_commit => P_Commit,
1372: p_ProcName => l_proc_name,
1373: p_return_type => p_return_type,
1374: x_return_status => l_return_status,

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

1374: x_return_status => l_return_status,
1375: x_msg_count => l_msg_count,
1376: x_msg_data => l_msg_data
1377: );
1378: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1379: raise l_IEM_INVALID_PROCEDURE;
1380: end if;
1381: end if;
1382: end if;

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

1385:
1386: update IEM_ROUTES
1387: set
1388: name=decode(p_name,null,name,p_name),
1389: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
1390: boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),
1391: procedure_name=decode(l_proc_name,FND_API.G_MISS_CHAR,null,null,procedure_name,l_proc_name),
1392: all_email=decode(p_all_emails,FND_API.G_MISS_CHAR,null,null,all_email,p_all_emails),
1393: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),

Line 1391: procedure_name=decode(l_proc_name,FND_API.G_MISS_CHAR,null,null,procedure_name,l_proc_name),

1387: set
1388: name=decode(p_name,null,name,p_name),
1389: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
1390: boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),
1391: procedure_name=decode(l_proc_name,FND_API.G_MISS_CHAR,null,null,procedure_name,l_proc_name),
1392: all_email=decode(p_all_emails,FND_API.G_MISS_CHAR,null,null,all_email,p_all_emails),
1393: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
1394: LAST_UPDATE_DATE = sysdate,
1395: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)

Line 1392: all_email=decode(p_all_emails,FND_API.G_MISS_CHAR,null,null,all_email,p_all_emails),

1388: name=decode(p_name,null,name,p_name),
1389: description=decode(p_description,FND_API.G_MISS_CHAR,null,null,description,p_description),
1390: boolean_type_code=decode(p_ruling_chain,null,boolean_type_code,p_ruling_chain),
1391: procedure_name=decode(l_proc_name,FND_API.G_MISS_CHAR,null,null,procedure_name,l_proc_name),
1392: all_email=decode(p_all_emails,FND_API.G_MISS_CHAR,null,null,all_email,p_all_emails),
1393: LAST_UPDATED_BY = decode(G_created_updated_by,null,-1,G_created_updated_by),
1394: LAST_UPDATE_DATE = sysdate,
1395: LAST_UPDATE_LOGIN = decode(G_LAST_UPDATE_LOGIN,null,-1,G_LAST_UPDATE_LOGIN)
1396:

Line 1400: IF FND_API.To_Boolean(p_commit) THEN

1396:
1397: where route_id=p_route_id;
1398:
1399: -- Standard Check Of p_commit.
1400: IF FND_API.To_Boolean(p_commit) THEN
1401: COMMIT WORK;
1402: END IF;
1403:
1404: -- Standard callto get message count and if count is 1, get message info.

Line 1414: x_return_status := FND_API.G_RET_STS_ERROR ;

1410:
1411: EXCEPTION
1412: WHEN l_IEM_INVALID_PROCEDURE THEN
1413: ROLLBACK TO update_item_route;
1414: x_return_status := FND_API.G_RET_STS_ERROR ;
1415: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1416:
1417: WHEN IEM_ADMIN_ROUTE_DUP_NAME THEN
1418: ROLLBACK TO update_item_route;

Line 1421: x_return_status := FND_API.G_RET_STS_ERROR ;

1417: WHEN IEM_ADMIN_ROUTE_DUP_NAME THEN
1418: ROLLBACK TO update_item_route;
1419: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_DUP_NAME');
1420: FND_MSG_PUB.Add;
1421: x_return_status := FND_API.G_RET_STS_ERROR ;
1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1423:
1424: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
1425: ROLLBACK TO update_item_route;

Line 1428: x_return_status := FND_API.G_RET_STS_ERROR ;

1424: WHEN IEM_ADMIN_ROUTE_NO_PROC THEN
1425: ROLLBACK TO update_item_route;
1426: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NO_PROC');
1427: FND_MSG_PUB.Add;
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO update_item_route;

Line 1431: WHEN FND_API.G_EXC_ERROR THEN

1427: FND_MSG_PUB.Add;
1428: x_return_status := FND_API.G_RET_STS_ERROR ;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO update_item_route;
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: FND_MSG_PUB.Count_And_Get
1435:

Line 1433: x_return_status := FND_API.G_RET_STS_ERROR ;

1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1430:
1431: WHEN FND_API.G_EXC_ERROR THEN
1432: ROLLBACK TO update_item_route;
1433: x_return_status := FND_API.G_RET_STS_ERROR ;
1434: FND_MSG_PUB.Count_And_Get
1435:
1436:
1437: ( p_count => x_msg_count,

Line 1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1437: ( p_count => x_msg_count,
1438: p_data => x_msg_data
1439: );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: ROLLBACK TO update_item_route;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1444: FND_MSG_PUB.Count_And_Get
1445: ( p_count => x_msg_count,

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1439: );
1440:
1441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1442: ROLLBACK TO update_item_route;
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1444: FND_MSG_PUB.Count_And_Get
1445: ( p_count => x_msg_count,
1446: p_data => x_msg_data
1447: );

Line 1453: x_return_status := FND_API.G_RET_STS_ERROR;

1449:
1450: WHEN OTHERS THEN
1451:
1452: ROLLBACK TO update_item_route;
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: IF FND_MSG_PUB.Check_Msg_Level
1455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1456: THEN
1457: FND_MSG_PUB.Add_Exc_Msg

Line 1496: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1492: -- Standard Start of API savepoint
1493:
1494: SAVEPOINT update_item_rule;
1495: -- Standard call to check for call compatibility.
1496: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1497: p_api_version_number,
1498: l_api_name,
1499: G_PKG_NAME)
1500: THEN

Line 1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1497: p_api_version_number,
1498: l_api_name,
1499: G_PKG_NAME)
1500: THEN
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502:
1503: END IF;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1506: IF FND_API.to_Boolean( p_init_msg_list )

1502:
1503: END IF;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF FND_API.to_Boolean( p_init_msg_list )
1507: THEN
1508:
1509: FND_MSG_PUB.initialize;
1510: END IF;

Line 1512: x_return_status := FND_API.G_RET_STS_SUCCESS;

1508:
1509: FND_MSG_PUB.initialize;
1510: END IF;
1511: -- Initialize API return status to SUCCESS
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1513:
1514: -- check if the route_id exist in iem_routes
1515: select count(*) into l_rule from iem_route_rules
1516:

Line 1554: IF FND_API.To_Boolean(p_commit) THEN

1550:
1551:
1552:
1553: -- Standard Check Of p_commit.
1554: IF FND_API.To_Boolean(p_commit) THEN
1555: COMMIT WORK;
1556: END IF;
1557:
1558: -- Standard callto get message count and if count is 1, get message info.

Line 1569: x_return_status := FND_API.G_RET_STS_ERROR ;

1565: ROLLBACK TO update_item_rule;
1566: FND_MESSAGE.SET_NAME('IEM','IEM_NO_RULE_UPDATE');
1567:
1568: FND_MSG_PUB.Add;
1569: x_return_status := FND_API.G_RET_STS_ERROR ;
1570: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1571:
1572: /*
1573: WHEN IEM_INVALID_DATE_FORMAT THEN

Line 1577: x_return_status := FND_API.G_RET_STS_ERROR ;

1573: WHEN IEM_INVALID_DATE_FORMAT THEN
1574: ROLLBACK TO update_item_rule;
1575: FND_MESSAGE.SET_NAME('IEM','IEM_INVALID_DATE_FORMAT');
1576: FND_MSG_PUB.Add;
1577: x_return_status := FND_API.G_RET_STS_ERROR ;
1578: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1579: */
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: ROLLBACK TO update_item_rule;

Line 1580: WHEN FND_API.G_EXC_ERROR THEN

1576: FND_MSG_PUB.Add;
1577: x_return_status := FND_API.G_RET_STS_ERROR ;
1578: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1579: */
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: ROLLBACK TO update_item_rule;
1582:
1583: x_return_status := FND_API.G_RET_STS_ERROR ;
1584: FND_MSG_PUB.Count_And_Get

Line 1583: x_return_status := FND_API.G_RET_STS_ERROR ;

1579: */
1580: WHEN FND_API.G_EXC_ERROR THEN
1581: ROLLBACK TO update_item_rule;
1582:
1583: x_return_status := FND_API.G_RET_STS_ERROR ;
1584: FND_MSG_PUB.Count_And_Get
1585:
1586: ( p_count => x_msg_count,
1587: p_data => x_msg_data

Line 1589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1585:
1586: ( p_count => x_msg_count,
1587: p_data => x_msg_data
1588: );
1589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1590: ROLLBACK TO update_item_rule;
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: FND_MSG_PUB.Count_And_Get
1593: ( p_count => x_msg_count,

Line 1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1587: p_data => x_msg_data
1588: );
1589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1590: ROLLBACK TO update_item_rule;
1591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1592: FND_MSG_PUB.Count_And_Get
1593: ( p_count => x_msg_count,
1594: p_data => x_msg_data
1595: );

Line 1600: x_return_status := FND_API.G_RET_STS_ERROR;

1596: WHEN OTHERS THEN
1597:
1598: ROLLBACK TO update_item_rule;
1599:
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: IF FND_MSG_PUB.Check_Msg_Level
1602: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1603: THEN
1604: FND_MSG_PUB.Add_Exc_Msg

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

1638:
1639: l_account number;
1640:
1641:
1642: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1643: l_msg_count NUMBER := 0;
1644: l_msg_data VARCHAR2(2000);
1645:
1646: IEM_ADMIN_ROUTE_NOT_EXIST EXCEPTION;

Line 1654: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1650: -- Standard Start of API savepoint
1651: SAVEPOINT create_wrap_account_routes_PVT;
1652:
1653: -- Standard call to check for call compatibility.
1654: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1655:
1656: p_api_version_number,
1657: l_api_name,
1658: G_PKG_NAME)

Line 1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1656: p_api_version_number,
1657: l_api_name,
1658: G_PKG_NAME)
1659: THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662:
1663: -- Initialize message list if p_init_msg_list is set to TRUE.
1664: IF FND_API.to_Boolean( p_init_msg_list )

Line 1664: IF FND_API.to_Boolean( p_init_msg_list )

1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662:
1663: -- Initialize message list if p_init_msg_list is set to TRUE.
1664: IF FND_API.to_Boolean( p_init_msg_list )
1665: THEN
1666:
1667: FND_MSG_PUB.initialize;
1668: END IF;

Line 1672: x_return_status := FND_API.G_RET_STS_SUCCESS;

1668: END IF;
1669:
1670:
1671: -- Initialize API return status to SUCCESS
1672: x_return_status := FND_API.G_RET_STS_SUCCESS;
1673:
1674:
1675: -- check if the route_id exist in iem_routes
1676: select count(*) into l_route from iem_routes

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

1709: x_return_status =>l_return_status,
1710: x_msg_count => l_msg_count,
1711: x_msg_data => l_msg_data);
1712:
1713: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1714: raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
1715:
1716: end if;
1717:

Line 1721: IF FND_API.To_Boolean(p_commit) THEN

1717:
1718:
1719: --dbms_output.put_line('after insert : ');
1720: -- Standard Check Of p_commit.
1721: IF FND_API.To_Boolean(p_commit) THEN
1722:
1723: COMMIT WORK;
1724: END IF;
1725: -- Standard callto get message count and if count is 1, get message info.

Line 1738: x_return_status := FND_API.G_RET_STS_ERROR ;

1734: ROLLBACK TO create_wrap_account_routes_PVT;
1735: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ROUTE_NOT_EXIST');
1736:
1737: FND_MSG_PUB.Add;
1738: x_return_status := FND_API.G_RET_STS_ERROR ;
1739: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1740:
1741: WHEN IEM_ADMIN_ACCOUNT_NOT_EXIST THEN
1742: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1746: x_return_status := FND_API.G_RET_STS_ERROR ;

1742: ROLLBACK TO create_wrap_account_routes_PVT;
1743: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_ACCOUNT_NOT_EXIST');
1744: FND_MSG_PUB.Add;
1745:
1746: x_return_status := FND_API.G_RET_STS_ERROR ;
1747: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1748:
1749: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
1750:

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR ;

1750:
1751: ROLLBACK TO create_wrap_account_routes_PVT;
1752: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
1753: FND_MSG_PUB.Add;
1754: x_return_status := FND_API.G_RET_STS_ERROR ;
1755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1756:
1757: WHEN FND_API.G_EXC_ERROR THEN
1758: ROLLBACK TO create_wrap_account_routes_PVT;

Line 1757: WHEN FND_API.G_EXC_ERROR THEN

1753: FND_MSG_PUB.Add;
1754: x_return_status := FND_API.G_RET_STS_ERROR ;
1755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1756:
1757: WHEN FND_API.G_EXC_ERROR THEN
1758: ROLLBACK TO create_wrap_account_routes_PVT;
1759: x_return_status := FND_API.G_RET_STS_ERROR ;
1760:
1761: FND_MSG_PUB.Count_And_Get

Line 1759: x_return_status := FND_API.G_RET_STS_ERROR ;

1755: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1756:
1757: WHEN FND_API.G_EXC_ERROR THEN
1758: ROLLBACK TO create_wrap_account_routes_PVT;
1759: x_return_status := FND_API.G_RET_STS_ERROR ;
1760:
1761: FND_MSG_PUB.Count_And_Get
1762: ( p_count => x_msg_count,
1763: p_data => x_msg_data

Line 1767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1763: p_data => x_msg_data
1764:
1765: );
1766:
1767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1768: ROLLBACK TO create_wrap_account_routes_PVT;
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1770: FND_MSG_PUB.Count_And_Get
1771: ( p_count => x_msg_count,

Line 1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1765: );
1766:
1767: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1768: ROLLBACK TO create_wrap_account_routes_PVT;
1769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1770: FND_MSG_PUB.Count_And_Get
1771: ( p_count => x_msg_count,
1772: p_data => x_msg_data
1773: );

Line 1779: x_return_status := FND_API.G_RET_STS_ERROR;

1775:
1776: WHEN OTHERS THEN
1777: ROLLBACK TO create_wrap_account_routes_PVT;
1778:
1779: x_return_status := FND_API.G_RET_STS_ERROR;
1780: IF FND_MSG_PUB.Check_Msg_Level
1781: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1782: THEN
1783: FND_MSG_PUB.Add_Exc_Msg

Line 1824: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1820: BEGIN
1821: -- Standard Start of API savepoint
1822: SAVEPOINT update_account_routes_PVT;
1823: -- Standard call to check for call compatibility.
1824: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1825: p_api_version_number,
1826: l_api_name,
1827: G_PKG_NAME)
1828: THEN

Line 1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1825: p_api_version_number,
1826: l_api_name,
1827: G_PKG_NAME)
1828: THEN
1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1830: END IF;
1831: -- Initialize message list if p_init_msg_list is set to TRUE.
1832:
1833: IF FND_API.to_Boolean( p_init_msg_list )

Line 1833: IF FND_API.to_Boolean( p_init_msg_list )

1829: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1830: END IF;
1831: -- Initialize message list if p_init_msg_list is set to TRUE.
1832:
1833: IF FND_API.to_Boolean( p_init_msg_list )
1834:
1835: THEN
1836: FND_MSG_PUB.initialize;
1837: END IF;

Line 1839: x_return_status := FND_API.G_RET_STS_SUCCESS;

1835: THEN
1836: FND_MSG_PUB.initialize;
1837: END IF;
1838: -- Initialize API return status to SUCCESS
1839: x_return_status := FND_API.G_RET_STS_SUCCESS;
1840:
1841: -- Check For Existing IEM Server Group
1842: IF p_route_id <> FND_API.G_MISS_NUM THEN
1843: Select count(*) into l_route_cnt from iem_routes

Line 1842: IF p_route_id <> FND_API.G_MISS_NUM THEN

1838: -- Initialize API return status to SUCCESS
1839: x_return_status := FND_API.G_RET_STS_SUCCESS;
1840:
1841: -- Check For Existing IEM Server Group
1842: IF p_route_id <> FND_API.G_MISS_NUM THEN
1843: Select count(*) into l_route_cnt from iem_routes
1844: where route_id=p_route_id;
1845:
1846:

Line 1854: IF p_email_account_id <> FND_API.G_MISS_NUM THEN

1850: APP_EXCEPTION.RAISE_EXCEPTION;
1851: END IF;
1852: END IF;
1853:
1854: IF p_email_account_id <> FND_API.G_MISS_NUM THEN
1855: /*Check For Existing DB Server Group Id */
1856:
1857: Select count(*) into l_acct_cnt from iem_mstemail_accounts
1858: where email_account_id=p_email_account_id;

Line 1868: if ( p_destination_grp_id = FND_API.G_MISS_CHAR ) Then

1864:
1865: END IF;
1866: END IF;
1867:
1868: if ( p_destination_grp_id = FND_API.G_MISS_CHAR ) Then
1869: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1870: elsif ( p_default_grp_id = FND_API.G_MISS_CHAR ) then
1871: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1872: elsif ( p_enabled_flag = FND_API.G_MISS_CHAR) then

Line 1870: elsif ( p_default_grp_id = FND_API.G_MISS_CHAR ) then

1866: END IF;
1867:
1868: if ( p_destination_grp_id = FND_API.G_MISS_CHAR ) Then
1869: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1870: elsif ( p_default_grp_id = FND_API.G_MISS_CHAR ) then
1871: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1872: elsif ( p_enabled_flag = FND_API.G_MISS_CHAR) then
1873: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1874: elsif ( p_priority = FND_API.G_MISS_CHAR) then

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

1868: if ( p_destination_grp_id = FND_API.G_MISS_CHAR ) Then
1869: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1870: elsif ( p_default_grp_id = FND_API.G_MISS_CHAR ) then
1871: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1872: elsif ( p_enabled_flag = FND_API.G_MISS_CHAR) then
1873: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1874: elsif ( p_priority = FND_API.G_MISS_CHAR) then
1875: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1876: end if;

Line 1874: elsif ( p_priority = FND_API.G_MISS_CHAR) then

1870: elsif ( p_default_grp_id = FND_API.G_MISS_CHAR ) then
1871: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1872: elsif ( p_enabled_flag = FND_API.G_MISS_CHAR) then
1873: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1874: elsif ( p_priority = FND_API.G_MISS_CHAR) then
1875: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1876: end if;
1877:
1878:

Line 1879: if ((p_email_account_id <> FND_API.G_MISS_NUM) and (p_route_id <> FND_API.G_MISS_NUM)) then

1875: raise IEM_ADM_G_MISS_FOR_NOTNULL;
1876: end if;
1877:
1878:
1879: if ((p_email_account_id <> FND_API.G_MISS_NUM) and (p_route_id <> FND_API.G_MISS_NUM)) then
1880: update IEM_ACCOUNT_ROUTES
1881: set
1882: destination_group_id = decode(p_destination_grp_id,null,destination_group_id,p_destination_grp_id),
1883: default_group_id =decode(p_default_grp_id,null,default_group_id,p_default_grp_id),

Line 1895: IF FND_API.To_Boolean(p_commit) THEN

1891:
1892:
1893:
1894: -- Standard Check Of p_commit.
1895: IF FND_API.To_Boolean(p_commit) THEN
1896: COMMIT WORK;
1897:
1898: END IF;
1899: -- Standard callto get message count and if count is 1, get message info.

Line 1910: x_return_status := FND_API.G_RET_STS_ERROR ;

1906: WHEN IEM_ADM_G_MISS_FOR_NOTNULL THEN
1907: ROLLBACK TO update_account_routes_PVT;
1908: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
1909: FND_MSG_PUB.Add;
1910: x_return_status := FND_API.G_RET_STS_ERROR ;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO update_account_routes_PVT;
1914: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 1912: WHEN FND_API.G_EXC_ERROR THEN

1908: FND_MESSAGE.SET_NAME('IEM','IEM_ADM_G_MISS_FOR_NOTNULL');
1909: FND_MSG_PUB.Add;
1910: x_return_status := FND_API.G_RET_STS_ERROR ;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO update_account_routes_PVT;
1914: x_return_status := FND_API.G_RET_STS_ERROR ;
1915: FND_MSG_PUB.Count_And_Get
1916:

Line 1914: x_return_status := FND_API.G_RET_STS_ERROR ;

1910: x_return_status := FND_API.G_RET_STS_ERROR ;
1911: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1912: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO update_account_routes_PVT;
1914: x_return_status := FND_API.G_RET_STS_ERROR ;
1915: FND_MSG_PUB.Count_And_Get
1916:
1917: ( p_count => x_msg_count,
1918: p_data => x_msg_data

Line 1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1916:
1917: ( p_count => x_msg_count,
1918: p_data => x_msg_data
1919: );
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1921: ROLLBACK TO update_account_routes_PVT;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1923:
1924: FND_MSG_PUB.Count_And_Get

Line 1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1918: p_data => x_msg_data
1919: );
1920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1921: ROLLBACK TO update_account_routes_PVT;
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1923:
1924: FND_MSG_PUB.Count_And_Get
1925: ( p_count => x_msg_count,
1926: p_data => x_msg_data

Line 1931: x_return_status := FND_API.G_RET_STS_ERROR;

1927: );
1928: WHEN OTHERS THEN
1929: ROLLBACK TO update_account_routes_PVT;
1930:
1931: x_return_status := FND_API.G_RET_STS_ERROR;
1932: IF FND_MSG_PUB.Check_Msg_Level
1933: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1934: THEN
1935: FND_MSG_PUB.Add_Exc_Msg

Line 1974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1970:
1971: SAVEPOINT delete_acct_route_batch;
1972:
1973: -- Standard call to check for call compatibility.
1974: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1975: p_api_version_number,
1976: l_api_name,
1977: G_PKG_NAME)
1978: THEN

Line 1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1975: p_api_version_number,
1976: l_api_name,
1977: G_PKG_NAME)
1978: THEN
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: END IF;
1981:
1982:
1983: --Initialize the message list if p_init_msg_list is set to TRUE

Line 1985: If FND_API.to_Boolean(p_init_msg_list) THEN

1981:
1982:
1983: --Initialize the message list if p_init_msg_list is set to TRUE
1984:
1985: If FND_API.to_Boolean(p_init_msg_list) THEN
1986: FND_MSG_PUB.initialize;
1987: END IF;
1988:
1989: --Initialize API status return

Line 1990: x_return_status := FND_API.G_RET_STS_SUCCESS;

1986: FND_MSG_PUB.initialize;
1987: END IF;
1988:
1989: --Initialize API status return
1990: x_return_status := FND_API.G_RET_STS_SUCCESS;
1991:
1992: --Actual API starts here
1993: if ( p_route_ids_tbl.count <> 0 ) then
1994:

Line 2018: IF FND_API.to_Boolean(p_commit) THEN

2014: -- raise IEM_ACCOUNT_ROUTE_NOT_DELETED;
2015: --end if;
2016:
2017: --Standard check of p_commit
2018: IF FND_API.to_Boolean(p_commit) THEN
2019: COMMIT WORK;
2020: END IF;
2021:
2022:

Line 2028: x_return_status := FND_API.G_RET_STS_ERROR;

2024: WHEN IEM_ACCOUNT_ROUTE_NOT_DELETED THEN
2025: ROLLBACK TO delete_acct_route_batch;
2026:
2027:
2028: x_return_status := FND_API.G_RET_STS_ERROR;
2029: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_ROUTE_NOT_DELETED');
2030: FND_MSG_PUB.ADD;
2031: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2032:

Line 2033: WHEN FND_API.G_EXC_ERROR THEN

2029: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUNT_ROUTE_NOT_DELETED');
2030: FND_MSG_PUB.ADD;
2031: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2032:
2033: WHEN FND_API.G_EXC_ERROR THEN
2034: ROLLBACK TO delete_acct_route_batch;
2035: x_return_status := FND_API.G_RET_STS_ERROR ;
2036: FND_MSG_PUB.Count_And_Get
2037: ( p_count => x_msg_count,p_data => x_msg_data);

Line 2035: x_return_status := FND_API.G_RET_STS_ERROR ;

2031: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2032:
2033: WHEN FND_API.G_EXC_ERROR THEN
2034: ROLLBACK TO delete_acct_route_batch;
2035: x_return_status := FND_API.G_RET_STS_ERROR ;
2036: FND_MSG_PUB.Count_And_Get
2037: ( p_count => x_msg_count,p_data => x_msg_data);
2038:
2039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2035: x_return_status := FND_API.G_RET_STS_ERROR ;
2036: FND_MSG_PUB.Count_And_Get
2037: ( p_count => x_msg_count,p_data => x_msg_data);
2038:
2039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2040:
2041: ROLLBACK TO delete_acct_route_batch;
2042:
2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2040:
2041: ROLLBACK TO delete_acct_route_batch;
2042:
2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
2045:
2046: WHEN OTHERS THEN
2047: ROLLBACK TO delete_acct_route_batch;

Line 2048: x_return_status := FND_API.G_RET_STS_ERROR;

2044: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
2045:
2046: WHEN OTHERS THEN
2047: ROLLBACK TO delete_acct_route_batch;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2050: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2051: END IF;
2052:

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

2080:
2081: l_api_version_number NUMBER:=1.0;
2082:
2083:
2084: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
2085:
2086: l_msg_count NUMBER := 0;
2087: l_msg_data VARCHAR2(2000);
2088:

Line 2096: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2092: -- Standard Start of API savepoint
2093: SAVEPOINT update_wrap_acct_routes_1_PVT;
2094:
2095: -- Standard call to check for call compatibility.
2096: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2097: p_api_version_number,
2098: l_api_name,
2099: G_PKG_NAME)
2100:

Line 2102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2098: l_api_name,
2099: G_PKG_NAME)
2100:
2101: THEN
2102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2103: END IF;
2104:
2105: -- Initialize message list if p_init_msg_list is set to TRUE.
2106: IF FND_API.to_Boolean( p_init_msg_list )

Line 2106: IF FND_API.to_Boolean( p_init_msg_list )

2102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2103: END IF;
2104:
2105: -- Initialize message list if p_init_msg_list is set to TRUE.
2106: IF FND_API.to_Boolean( p_init_msg_list )
2107: THEN
2108:
2109: FND_MSG_PUB.initialize;
2110: END IF;

Line 2112: x_return_status := FND_API.G_RET_STS_SUCCESS;

2108:
2109: FND_MSG_PUB.initialize;
2110: END IF;
2111: -- Initialize API return status to SUCCESS
2112: x_return_status := FND_API.G_RET_STS_SUCCESS;
2113:
2114: -- update first
2115:
2116: if ( p_route_ids_tbl.count <> 0 ) then

Line 2120: p_init_msg_list => FND_API.G_FALSE,

2116: if ( p_route_ids_tbl.count <> 0 ) then
2117: FOR i IN p_route_ids_tbl.FIRST..p_route_ids_tbl.LAST LOOP
2118:
2119: iem_route_pvt.update_account_routes (p_api_version_number =>p_api_version_number,
2120: p_init_msg_list => FND_API.G_FALSE,
2121: p_commit => FND_API.G_TRUE,
2122:
2123:
2124: p_route_id => p_route_ids_tbl(i),

Line 2121: p_commit => FND_API.G_TRUE,

2117: FOR i IN p_route_ids_tbl.FIRST..p_route_ids_tbl.LAST LOOP
2118:
2119: iem_route_pvt.update_account_routes (p_api_version_number =>p_api_version_number,
2120: p_init_msg_list => FND_API.G_FALSE,
2121: p_commit => FND_API.G_TRUE,
2122:
2123:
2124: p_route_id => p_route_ids_tbl(i),
2125: p_email_account_id => p_email_account_id,

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

2131: x_return_status =>l_return_status,
2132: x_msg_count => l_msg_count,
2133: x_msg_data => l_msg_data);
2134:
2135: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2136:
2137: raise IEM_ACCOUNT_ROUTE_NOT_UPDATED;
2138: end if;
2139: END LOOP;

Line 2149: P_init_msg_list => FND_API.G_FALSE,

2145:
2146: -- FOR i IN p_route_ids_tbl.FIRST..p_route_ids_tbl.LAST LOOP
2147: iem_route_pvt.delete_acct_route_batch
2148: (p_api_version_number => p_api_version_number,
2149: P_init_msg_list => FND_API.G_FALSE,
2150:
2151: p_commit => FND_API.G_TRUE,
2152: p_route_ids_tbl => p_delete_route_ids_tbl,
2153: p_account_id => p_email_account_id,

Line 2151: p_commit => FND_API.G_TRUE,

2147: iem_route_pvt.delete_acct_route_batch
2148: (p_api_version_number => p_api_version_number,
2149: P_init_msg_list => FND_API.G_FALSE,
2150:
2151: p_commit => FND_API.G_TRUE,
2152: p_route_ids_tbl => p_delete_route_ids_tbl,
2153: p_account_id => p_email_account_id,
2154: x_return_status => l_return_status,
2155: x_msg_count => l_msg_count,

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

2153: p_account_id => p_email_account_id,
2154: x_return_status => l_return_status,
2155: x_msg_count => l_msg_count,
2156: x_msg_data => l_msg_data) ;
2157: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
2158: raise IEM_ACCOUNT_ROUTE_NOT_DELETED;
2159: end if;
2160:
2161: -- END LOOP;

Line 2172: IF FND_API.To_Boolean(p_commit) THEN

2168:
2169:
2170: --dbms_output.put_line('after insert : ');
2171: -- Standard Check Of p_commit.
2172: IF FND_API.To_Boolean(p_commit) THEN
2173: COMMIT WORK;
2174: END IF;
2175:
2176: -- Standard callto get message count and if count is 1, get message info.

Line 2189: x_return_status := FND_API.G_RET_STS_ERROR ;

2185: WHEN IEM_ACCOUNT_ROUTE_NOT_UPDATED THEN
2186: ROLLBACK TO update_wrap_acct_routes_1_PVT;
2187: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_UPDATED');
2188: FND_MSG_PUB.Add;
2189: x_return_status := FND_API.G_RET_STS_ERROR ;
2190:
2191: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2192:
2193: WHEN IEM_ACCOUNT_ROUTE_NOT_DELETED THEN

Line 2197: x_return_status := FND_API.G_RET_STS_ERROR ;

2193: WHEN IEM_ACCOUNT_ROUTE_NOT_DELETED THEN
2194: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2195: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_DELETED');
2196: FND_MSG_PUB.Add;
2197: x_return_status := FND_API.G_RET_STS_ERROR ;
2198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2199: WHEN FND_API.G_EXC_ERROR THEN
2200: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2201: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2199: WHEN FND_API.G_EXC_ERROR THEN

2195: FND_MESSAGE.SET_NAME('IEM','IEM_ACCOUNT_ROUTE_NOT_DELETED');
2196: FND_MSG_PUB.Add;
2197: x_return_status := FND_API.G_RET_STS_ERROR ;
2198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2199: WHEN FND_API.G_EXC_ERROR THEN
2200: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2201: x_return_status := FND_API.G_RET_STS_ERROR ;
2202: FND_MSG_PUB.Count_And_Get
2203: ( p_count => x_msg_count,

Line 2201: x_return_status := FND_API.G_RET_STS_ERROR ;

2197: x_return_status := FND_API.G_RET_STS_ERROR ;
2198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2199: WHEN FND_API.G_EXC_ERROR THEN
2200: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2201: x_return_status := FND_API.G_RET_STS_ERROR ;
2202: FND_MSG_PUB.Count_And_Get
2203: ( p_count => x_msg_count,
2204: p_data => x_msg_data
2205:

Line 2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2205:
2206:
2207: );
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2212: FND_MSG_PUB.Count_And_Get
2213: ( p_count => x_msg_count,

Line 2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2207: );
2208:
2209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2210: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2212: FND_MSG_PUB.Count_And_Get
2213: ( p_count => x_msg_count,
2214: p_data => x_msg_data
2215: );

Line 2219: x_return_status := FND_API.G_RET_STS_ERROR;

2215: );
2216:
2217: WHEN OTHERS THEN
2218: ROLLBACK TO update_wrap_acct_routes_2_PVT;
2219: x_return_status := FND_API.G_RET_STS_ERROR;
2220:
2221:
2222: IF FND_MSG_PUB.Check_Msg_Level
2223: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)