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_MSG_PUB

Line 60: FND_MSG_PUB.initialize;

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:
63: -- Initialize API return status to SUCCESS
64: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 77: FND_MSG_PUB.Count_And_Get

73: END IF;
74:
75:
76: -- Standard callto get message count and if count is 1, get message info.
77: FND_MSG_PUB.Count_And_Get
78: ( p_count => x_msg_count,
79: p_data => x_msg_data
80: );
81:

Line 87: FND_MSG_PUB.Count_And_Get

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
91: );

Line 96: FND_MSG_PUB.Count_And_Get

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: );
100:

Line 104: IF FND_MSG_PUB.Check_Msg_Level

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
108: ( G_PKG_NAME ,

Line 105: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
108: ( G_PKG_NAME ,
109: l_api_name

Line 107: FND_MSG_PUB.Add_Exc_Msg

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
108: ( G_PKG_NAME ,
109: l_api_name
110: );
111: END IF;

Line 113: FND_MSG_PUB.Count_And_Get

109: l_api_name
110: );
111: END IF;
112:
113: FND_MSG_PUB.Count_And_Get
114: ( p_count => x_msg_count,
115: p_data => x_msg_data
116:
117: );

Line 182: FND_MSG_PUB.initialize;

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:
185: -- Initialize API return status to SUCCESS
186: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 326: FND_MSG_PUB.Count_And_Get

322: END IF;
323:
324:
325: -- Standard callto get message count and if count is 1, get message info.
326: FND_MSG_PUB.Count_And_Get
327: ( p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330:

Line 338: FND_MSG_PUB.ADD;

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;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';

Line 339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

335:
336: FND_MESSAGE.SET_NAME('IEM', 'IEM_INVALID_DATA_DO_NOTHING');
337:
338: FND_MSG_PUB.ADD;
339: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
340:
341: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
342: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';
343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);

Line 352: FND_MSG_PUB.ADD;

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;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
356: logMessage := '[Failed when calling IEM_UPDATE_DP_CONFIG_DATA!]';

Line 353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

349:
350: FND_MESSAGE.SET_NAME('IEM', 'IEM_UPD_DP_CONFIG_DATA_FAILED');
351:
352: FND_MSG_PUB.ADD;
353: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
354:
355: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
356: logMessage := '[Failed when calling IEM_UPDATE_DP_CONFIG_DATA!]';
357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);

Line 366: FND_MSG_PUB.ADD;

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;
367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
368:
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!]';

Line 367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

363:
364: FND_MESSAGE.SET_NAME('IEM', 'IEM_ACCOUT_ID_NOT_EXIST');
365:
366: FND_MSG_PUB.ADD;
367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
368:
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);

Line 376: FND_MSG_PUB.Count_And_Get

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
380: );

Line 385: FND_MSG_PUB.Count_And_Get

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: );
389:

Line 393: IF FND_MSG_PUB.Check_Msg_Level

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
397: ( G_PKG_NAME ,

Line 394: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
397: ( G_PKG_NAME ,
398: l_api_name

Line 396: FND_MSG_PUB.Add_Exc_Msg

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
397: ( G_PKG_NAME ,
398: l_api_name
399: );
400: END IF;

Line 402: FND_MSG_PUB.Count_And_Get

398: l_api_name
399: );
400: END IF;
401:
402: FND_MSG_PUB.Count_And_Get
403: ( p_count => x_msg_count,
404: p_data => x_msg_data
405:
406: );

Line 456: FND_MSG_PUB.initialize;

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:
459: -- Initialize API return status to SUCCESS
460: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 544: FND_MSG_PUB.Count_And_Get

540: END IF;
541:
542:
543: -- Standard callto get message count and if count is 1, get message info.
544: FND_MSG_PUB.Count_And_Get
545: ( p_count => x_msg_count,
546: p_data => x_msg_data
547: );
548:

Line 554: FND_MSG_PUB.Count_And_Get

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
558: );

Line 563: FND_MSG_PUB.Count_And_Get

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: );
567:

Line 571: IF FND_MSG_PUB.Check_Msg_Level

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
575: ( G_PKG_NAME ,

Line 572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
575: ( G_PKG_NAME ,
576: l_api_name

Line 574: FND_MSG_PUB.Add_Exc_Msg

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
575: ( G_PKG_NAME ,
576: l_api_name
577: );
578: END IF;

Line 580: FND_MSG_PUB.Count_And_Get

576: l_api_name
577: );
578: END IF;
579:
580: FND_MSG_PUB.Count_And_Get
581: ( p_count => x_msg_count,
582: p_data => x_msg_data
583:
584: );

Line 626: FND_MSG_PUB.initialize;

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
630: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 681: FND_MSG_PUB.Count_And_Get

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:
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 688: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

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
692: ROLLBACK TO GET_ACCOUNT_INFO_pvt;

Line 694: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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:
698: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

Line 695: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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:
698: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
699:

Line 698: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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:
698: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
699:
700: END ;
701:
702:

Line 738: FND_MSG_PUB.initialize;

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
742: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 760: FND_MSG_PUB.Count_And_Get

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:
764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 767: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);

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
771: ROLLBACK TO GET_ACCOUNT_INFO_pvt;

Line 773: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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:
777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

Line 774: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

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:
777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
778:

Line 777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);

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:
777: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count ,p_data => x_msg_data);
778:
779: END ;
780:
781:

Line 855: FND_MSG_PUB.ADD;

851:
852:
853: --FND_MESSAGE.SET_NAME('IEM', 'IEM_INVALID_DATA_DO_NOTHING');
854:
855: FND_MSG_PUB.ADD;
856: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
857:
858: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP') then
859: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';

Line 856: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

852:
853: --FND_MESSAGE.SET_NAME('IEM', 'IEM_INVALID_DATA_DO_NOTHING');
854:
855: FND_MSG_PUB.ADD;
856: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
857:
858: if fnd_log.test(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP') then
859: logMessage := '[input data is invalid, no data inserted to IEM_EMTA_CONFIG_PARAMS,return true!]';
860: dbms_output.put_line(logMessage);

Line 926: FND_MSG_PUB.initialize;

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:
929: -- Initialize API return status to SUCCESS
930: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 998: FND_MSG_PUB.Count_And_Get

994: END IF;
995:
996:
997: -- Standard callto get message count and if count is 1, get message info.
998: FND_MSG_PUB.Count_And_Get
999: ( p_count => x_msg_count,
1000: p_data => x_msg_data
1001: );
1002:

Line 1010: FND_MSG_PUB.ADD;

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;
1011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1012:
1013: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1014: logMessage := '[Unable to descript password for account_id=' || p_email_account_id ||'!]';

Line 1011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1007:
1008: FND_MESSAGE.SET_NAME('IEM', 'IEM_FAILED_DECRYPT_ACCT_PWD');
1009:
1010: FND_MSG_PUB.ADD;
1011: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1012:
1013: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1014: logMessage := '[Unable to descript password for account_id=' || p_email_account_id ||'!]';
1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.CHECK_IF_ACCOUNT_UPDATED', logMessage);

Line 1022: FND_MSG_PUB.Count_And_Get

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
1026: );

Line 1031: FND_MSG_PUB.Count_And_Get

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: );
1035:

Line 1039: IF FND_MSG_PUB.Check_Msg_Level

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
1043: ( G_PKG_NAME ,

Line 1040: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
1043: ( G_PKG_NAME ,
1044: l_api_name

Line 1042: FND_MSG_PUB.Add_Exc_Msg

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
1043: ( G_PKG_NAME ,
1044: l_api_name
1045: );
1046: END IF;

Line 1048: FND_MSG_PUB.Count_And_Get

1044: l_api_name
1045: );
1046: END IF;
1047:
1048: FND_MSG_PUB.Count_And_Get
1049: ( p_count => x_msg_count,
1050: p_data => x_msg_data
1051:
1052: );