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

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

32: l_api_name VARCHAR2(255):='IS_DLPS_RUNNING';
33: l_api_version_number NUMBER:=1.0;
34: l_seq_id NUMBER;
35:
36: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
37: l_msg_count NUMBER := 0;
38: l_msg_data VARCHAR2(2000);
39: i INTEGER;
40:

Line 48: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 58: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: FND_MSG_PUB.initialize;
61: END IF;
62:
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: --begins here
67:
68: x_running_status := 'N';

Line 71: IF FND_API.To_Boolean(p_commit) THEN

67:
68: x_running_status := 'N';
69:
70: -- Standard Check Of p_commit.
71: IF FND_API.To_Boolean(p_commit) THEN
72: COMMIT WORK;
73: END IF;
74:
75:

Line 84: WHEN FND_API.G_EXC_ERROR THEN

80: );
81:
82: EXCEPTION
83:
84: WHEN FND_API.G_EXC_ERROR THEN
85: ROLLBACK TO IS_DLPS_RUNNING_PVT;
86: x_return_status := FND_API.G_RET_STS_ERROR ;
87: FND_MSG_PUB.Count_And_Get
88:

Line 86: x_return_status := FND_API.G_RET_STS_ERROR ;

82: EXCEPTION
83:
84: WHEN FND_API.G_EXC_ERROR THEN
85: ROLLBACK TO IS_DLPS_RUNNING_PVT;
86: x_return_status := FND_API.G_RET_STS_ERROR ;
87: FND_MSG_PUB.Count_And_Get
88:
89: ( p_count => x_msg_count,
90: p_data => x_msg_data

Line 93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

89: ( p_count => x_msg_count,
90: p_data => x_msg_data
91: );
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
94: ROLLBACK TO IS_DLPS_RUNNING_PVT;
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
96: FND_MSG_PUB.Count_And_Get
97: ( p_count => x_msg_count,

Line 95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

91: );
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
94: ROLLBACK TO IS_DLPS_RUNNING_PVT;
95: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
96: FND_MSG_PUB.Count_And_Get
97: ( p_count => x_msg_count,
98: p_data => x_msg_data
99: );

Line 103: x_return_status := FND_API.G_RET_STS_ERROR;

99: );
100:
101: WHEN OTHERS THEN
102: ROLLBACK TO IS_DLPS_RUNNING_PVT;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: IF FND_MSG_PUB.Check_Msg_Level
105: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
106: THEN
107: FND_MSG_PUB.Add_Exc_Msg

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

136: is
137: l_api_name VARCHAR2(255):='IS_DLPS_RUNNING';
138: l_api_version_number NUMBER:=1.0;
139:
140: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
141: l_msg_count NUMBER := 0;
142: l_msg_data VARCHAR2(2000);
143:
144: l_email_acct_id NUMBER;

Line 170: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

166: SAVEPOINT UPDATE_DP_CONFIG_DATA_WRAP_PVT;
167:
168: -- Standard call to check for call compatibility.
169:
170: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178:
179: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 180: IF FND_API.to_Boolean( p_init_msg_list )

176: END IF;
177:
178:
179: -- Initialize message list if p_init_msg_list is set to TRUE.
180: IF FND_API.to_Boolean( p_init_msg_list )
181: THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to SUCCESS
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187:
188: --begins here
189:
190: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 213: p_init_msg_list => FND_API.G_FALSE,

209: l_is_acct_updated := 'Y';
210:
211: IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA(
212: p_api_version_number => P_Api_Version_Number,
213: p_init_msg_list => FND_API.G_FALSE,
214: p_commit => P_Commit,
215: p_email_acct_id => p_email_acct_id,
216: p_active_flag => p_active_flag,
217: p_is_acct_update => l_is_acct_updated,

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

218: x_return_status => l_return_status,
219: x_msg_count => x_msg_count,
220: x_msg_data => x_msg_data
221: );
222: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
223: raise IEM_UPD_DP_CONFIG_DATA_FAILED;
224: end if;
225:
226:

Line 253: p_init_msg_list => FND_API.G_FALSE,

249:
250:
251: CHECK_IF_ACCOUNT_UPDATED (
252: p_api_version_number => l_api_version_number,
253: p_init_msg_list => FND_API.G_FALSE,
254: p_commit => P_Commit,
255: p_email_account_id => p_email_acct_id,
256: P_ACTIVE_FLAG => P_ACTIVE_FLAG,
257: P_USER_NAME => l_USER_NAME,

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

264: x_msg_count => x_msg_count,
265: x_msg_data => x_msg_data
266: );
267:
268: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
269: raise IEM_UPD_DP_CONFIG_DATA_FAILED;
270: end if;
271:
272: if ( l_is_data_changed = 'Y' ) then

Line 276: p_init_msg_list => FND_API.G_FALSE,

272: if ( l_is_data_changed = 'Y' ) then
273:
274: IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA(
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_email_acct_id => p_email_acct_id,
279: p_active_flag => p_active_flag,
280: p_is_acct_update => l_is_acct_updated,

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

282: x_msg_count => x_msg_count,
283: x_msg_data => x_msg_data
284: );
285:
286: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
287: raise IEM_UPD_DP_CONFIG_DATA_FAILED;
288: end if;
289:
290: end if;

Line 298: p_init_msg_list => FND_API.G_FALSE,

294: l_is_acct_updated := 'N';
295:
296: IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA(
297: p_api_version_number => P_Api_Version_Number,
298: p_init_msg_list => FND_API.G_FALSE,
299: p_commit => P_Commit,
300: p_email_acct_id => p_email_acct_id,
301: p_active_flag => l_active_flag,
302: p_is_acct_update => l_is_acct_updated,

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

304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data
306: );
307:
308: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
309: --dbms_output.put_line('ERROR when calling IEM_ENCRYPT_TAGS_PVT.duplicate_tags ');
310: raise IEM_UPD_DP_CONFIG_DATA_FAILED;
311: end if;
312:

Line 320: IF FND_API.To_Boolean(p_commit) THEN

316:
317:
318:
319: -- Standard Check Of p_commit.
320: IF FND_API.To_Boolean(p_commit) THEN
321: COMMIT WORK;
322: END IF;
323:
324:

Line 334: x_return_status := FND_API.G_RET_STS_ERROR; --FND_API.G_RET_STS_SUCCESS ;

330:
331: EXCEPTION
332: WHEN IEM_INVALID_DATA_DO_NOTHING THEN
333: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;
334: x_return_status := FND_API.G_RET_STS_ERROR; --FND_API.G_RET_STS_SUCCESS ;
335:
336: FND_MESSAGE.SET_NAME('IEM', 'IEM_INVALID_DATA_DO_NOTHING');
337:
338: FND_MSG_PUB.ADD;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR ;

344: end if;
345:
346: WHEN IEM_UPD_DP_CONFIG_DATA_FAILED THEN
347: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;
348: x_return_status := FND_API.G_RET_STS_ERROR ;
349:
350: FND_MESSAGE.SET_NAME('IEM', 'IEM_UPD_DP_CONFIG_DATA_FAILED');
351:
352: FND_MSG_PUB.ADD;

Line 362: x_return_status := FND_API.G_RET_STS_ERROR ;

358: end if;
359: WHEN IEM_ACCOUT_ID_NOT_EXIST THEN
360:
361: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;
362: x_return_status := FND_API.G_RET_STS_ERROR ;
363:
364: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUT_ID_NOT_EXIST');
365:
366: FND_MSG_PUB.ADD;

Line 373: WHEN FND_API.G_EXC_ERROR THEN

369: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
370: logMessage := '[Email Account Id does not exist in IEM_MSTEMAIL_ACCOUNTS!]';
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);
372: end if;
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get
377:

Line 375: x_return_status := FND_API.G_RET_STS_ERROR ;

371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);
372: end if;
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;
375: x_return_status := FND_API.G_RET_STS_ERROR ;
376: FND_MSG_PUB.Count_And_Get
377:
378: ( p_count => x_msg_count,
379: p_data => x_msg_data

Line 382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 392: x_return_status := FND_API.G_RET_STS_ERROR;

388: );
389:
390: WHEN OTHERS THEN
391: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;
392: x_return_status := FND_API.G_RET_STS_ERROR;
393: IF FND_MSG_PUB.Check_Msg_Level
394: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
395: THEN
396: FND_MSG_PUB.Add_Exc_Msg

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

421: is
422: l_api_name VARCHAR2(255):='IS_DLPS_RUNNING';
423: l_api_version_number NUMBER:=1.0;
424:
425: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
426: l_msg_count NUMBER := 0;
427: l_msg_data VARCHAR2(2000);
428:
429: l_seq_id NUMBER;

Line 444: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 454: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456: FND_MSG_PUB.initialize;
457: END IF;
458:
459: -- Initialize API return status to SUCCESS
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461:
462: --begins here
463: l_has_updated := 'N';
464:

Line 538: IF FND_API.To_Boolean(p_commit) THEN

534: );
535: end if;
536:
537: -- Standard Check Of p_commit.
538: IF FND_API.To_Boolean(p_commit) THEN
539: COMMIT WORK;
540: END IF;
541:
542:

Line 551: WHEN FND_API.G_EXC_ERROR THEN

547: );
548:
549: EXCEPTION
550:
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO UPDATE_DP_CONFIG_DATA_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555:

Line 553: x_return_status := FND_API.G_RET_STS_ERROR ;

549: EXCEPTION
550:
551: WHEN FND_API.G_EXC_ERROR THEN
552: ROLLBACK TO UPDATE_DP_CONFIG_DATA_PVT;
553: x_return_status := FND_API.G_RET_STS_ERROR ;
554: FND_MSG_PUB.Count_And_Get
555:
556: ( p_count => x_msg_count,
557: p_data => x_msg_data

Line 560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

556: ( p_count => x_msg_count,
557: p_data => x_msg_data
558: );
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO UPDATE_DP_CONFIG_DATA_PVT;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,

Line 562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

558: );
559:
560: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
561: ROLLBACK TO UPDATE_DP_CONFIG_DATA_PVT;
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: FND_MSG_PUB.Count_And_Get
564: ( p_count => x_msg_count,
565: p_data => x_msg_data
566: );

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

566: );
567:
568: WHEN OTHERS THEN
569: ROLLBACK TO UPDATE_DP_CONFIG_DATA_PVT;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg

Line 616: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

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

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 625: If FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 630: x_return_status := FND_API.G_RET_STS_SUCCESS;

626: FND_MSG_PUB.initialize;
627: END IF;
628:
629: --Initialize API status return
630: x_return_status := FND_API.G_RET_STS_SUCCESS;
631:
632: --Actual API starts here
633:
634: Y := 1;

Line 669: IF FND_API.to_Boolean(p_commit) THEN

665:
666: x_acct_info := l_acct_info;
667:
668: --Standard check of p_commit
669: IF FND_API.to_Boolean(p_commit) THEN
670: COMMIT WORK;
671: END IF;
672:
673:

Line 678: WHEN FND_API.G_EXC_ERROR THEN

674: EXCEPTION
675: WHEN e_nowait THEN
676: NULL;
677:
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
680: x_return_status := FND_API.G_RET_STS_ERROR ;
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count,p_data => x_msg_data);

Line 680: x_return_status := FND_API.G_RET_STS_ERROR ;

676: NULL;
677:
678: WHEN FND_API.G_EXC_ERROR THEN
679: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
680: x_return_status := FND_API.G_RET_STS_ERROR ;
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count,p_data => x_msg_data);
683:
684:

Line 685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count,p_data => x_msg_data);
683:
684:
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
689:

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

683:
684:
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
689:
690:
691: WHEN OTHERS THEN

Line 693: x_return_status := FND_API.G_RET_STS_ERROR;

689:
690:
691: WHEN OTHERS THEN
692: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
695: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
696: END IF;
697:

Line 728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

724: --Standard Savepoint
725: SAVEPOINT GET_ACCOUNT_INFO_pvt;
726:
727: -- Standard call to check for call compatibility.
728: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
729: p_api_version_number,
730: l_api_name,
731: G_PKG_NAME)
732: THEN

Line 733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

729: p_api_version_number,
730: l_api_name,
731: G_PKG_NAME)
732: THEN
733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: --Initialize the message list if p_init_msg_list is set to TRUE
737: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 737: If FND_API.to_Boolean(p_init_msg_list) THEN

733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
734: END IF;
735:
736: --Initialize the message list if p_init_msg_list is set to TRUE
737: If FND_API.to_Boolean(p_init_msg_list) THEN
738: FND_MSG_PUB.initialize;
739: END IF;
740:
741: --Initialize API status return

Line 742: x_return_status := FND_API.G_RET_STS_SUCCESS;

738: FND_MSG_PUB.initialize;
739: END IF;
740:
741: --Initialize API status return
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743:
744: --Actual API starts here
745: delete iem_emta_config_params where flag='A';
746:

Line 748: IF FND_API.to_Boolean(p_commit) THEN

744: --Actual API starts here
745: delete iem_emta_config_params where flag='A';
746:
747: --Standard check of p_commit
748: IF FND_API.to_Boolean(p_commit) THEN
749: COMMIT WORK;
750: END IF;
751:
752:

Line 757: WHEN FND_API.G_EXC_ERROR THEN

753: EXCEPTION
754: WHEN e_nowait THEN
755: NULL;
756:
757: WHEN FND_API.G_EXC_ERROR THEN
758: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
759: x_return_status := FND_API.G_RET_STS_ERROR ;
760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count,p_data => x_msg_data);

Line 759: x_return_status := FND_API.G_RET_STS_ERROR ;

755: NULL;
756:
757: WHEN FND_API.G_EXC_ERROR THEN
758: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
759: x_return_status := FND_API.G_RET_STS_ERROR ;
760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count,p_data => x_msg_data);
762:
763:

Line 764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

760: FND_MSG_PUB.Count_And_Get
761: ( p_count => x_msg_count,p_data => x_msg_data);
762:
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
768:

Line 766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

762:
763:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
765: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
767: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
768:
769:
770: WHEN OTHERS THEN

Line 772: x_return_status := FND_API.G_RET_STS_ERROR;

768:
769:
770: WHEN OTHERS THEN
771: ROLLBACK TO GET_ACCOUNT_INFO_pvt;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
774: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
775: END IF;
776:

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

819: x_return_status =>l_return_status,
820: x_msg_count => l_msg_count,
821: x_msg_data => l_msg_data);
822:
823: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
824: raise IEM_FAILED_DECRYPT_ACCT_PWD;
825: end if;
826: */
827: l_decrypted_pwd := fnd_vault.get('IEM', p_email_account_id );

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

885: is
886: l_api_name VARCHAR2(255):='CHECK_IF_ACCOUNT_UPDATED';
887: l_api_version_number NUMBER:=1.0;
888:
889: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
890: l_msg_count NUMBER := 0;
891: l_msg_data VARCHAR2(2000);
892:
893: l_data_changed varchar2(1);

Line 914: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

910: SAVEPOINT CHECK_IF_ACCOUNT_UPDATED_PVT;
911:
912: -- Standard call to check for call compatibility.
913:
914: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
915: p_api_version_number,
916: l_api_name,
917: G_PKG_NAME)
918: THEN

Line 919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 924: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 930: x_return_status := FND_API.G_RET_STS_SUCCESS;

926: FND_MSG_PUB.initialize;
927: END IF;
928:
929: -- Initialize API return status to SUCCESS
930: x_return_status := FND_API.G_RET_STS_SUCCESS;
931:
932: --begins here
933: x_is_acct_updated := 'N';
934: x_is_data_changed := 'N';

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

967: x_return_status =>l_return_status,
968: x_msg_count => l_msg_count,
969: x_msg_data => l_msg_data);
970:
971: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
972: raise IEM_FAILED_DECRYPT_ACCT_PWD;
973: end if;
974: */
975: l_decrypted_pwd := fnd_vault.get('IEM', p_email_account_id );

Line 992: IF FND_API.To_Boolean(p_commit) THEN

988: x_is_acct_updated := l_is_acct_updated;
989: x_is_data_changed := l_data_changed;
990:
991: -- Standard Check Of p_commit.
992: IF FND_API.To_Boolean(p_commit) THEN
993: COMMIT WORK;
994: END IF;
995:
996:

Line 1006: x_return_status := FND_API.G_RET_STS_ERROR;

1002:
1003: EXCEPTION
1004: WHEN IEM_FAILED_DECRYPT_ACCT_PWD THEN
1005: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007:
1008: FND_MESSAGE.SET_NAME('IEM', 'IEM_FAILED_DECRYPT_ACCT_PWD');
1009:
1010: FND_MSG_PUB.ADD;

Line 1019: WHEN FND_API.G_EXC_ERROR THEN

1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.CHECK_IF_ACCOUNT_UPDATED', logMessage);
1016: end if;
1017:
1018:
1019: WHEN FND_API.G_EXC_ERROR THEN
1020: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
1021: x_return_status := FND_API.G_RET_STS_ERROR ;
1022: FND_MSG_PUB.Count_And_Get
1023:

Line 1021: x_return_status := FND_API.G_RET_STS_ERROR ;

1017:
1018:
1019: WHEN FND_API.G_EXC_ERROR THEN
1020: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
1021: x_return_status := FND_API.G_RET_STS_ERROR ;
1022: FND_MSG_PUB.Count_And_Get
1023:
1024: ( p_count => x_msg_count,
1025: p_data => x_msg_data

Line 1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1024: ( p_count => x_msg_count,
1025: p_data => x_msg_data
1026: );
1027:
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: FND_MSG_PUB.Count_And_Get
1032: ( p_count => x_msg_count,

Line 1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1026: );
1027:
1028: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1029: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
1030: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1031: FND_MSG_PUB.Count_And_Get
1032: ( p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );

Line 1038: x_return_status := FND_API.G_RET_STS_ERROR;

1034: );
1035:
1036: WHEN OTHERS THEN
1037: ROLLBACK TO CHECK_IF_ACCOUNT_UPDATED_PVT;
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: IF FND_MSG_PUB.Check_Msg_Level
1040: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1041: THEN
1042: FND_MSG_PUB.Add_Exc_Msg