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_EMAIL_PROC_PVT dependencies on FND_MSG_PUB

Line 1917: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);

1913: l_logmessage:= 'normal not advaned sr creation status is:'||l_ret_status || 'sr_id is:'||l_sr_id;
1914: iem_logger(l_logmessage);
1915:
1916: if l_ret_status <> 'S' THEN
1917: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
1918: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
1919:
1920: FND_MSG_PUB.Get(
1921: p_msg_index => j,

Line 1918: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

1914: iem_logger(l_logmessage);
1915:
1916: if l_ret_status <> 'S' THEN
1917: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
1918: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
1919:
1920: FND_MSG_PUB.Get(
1921: p_msg_index => j,
1922: p_encoded => 'F',

Line 1920: FND_MSG_PUB.Get(

1916: if l_ret_status <> 'S' THEN
1917: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
1918: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
1919:
1920: FND_MSG_PUB.Get(
1921: p_msg_index => j,
1922: p_encoded => 'F',
1923: p_data => l_msg_data,
1924: p_msg_index_out => l_msg_index_out);

Line 2529: FND_MSG_PUB.Add;

2525: l_logmessage:='Start Sending Out Autoacknowledgement' ;
2526: iem_logger(l_logmessage);
2527: end if;
2528: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
2529: FND_MSG_PUB.Add;
2530: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
2531: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,
2532: p_mailer =>l_header_rec.from_str,
2533: p_sender=>l_sender,

Line 2530: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

2526: iem_logger(l_logmessage);
2527: end if;
2528: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
2529: FND_MSG_PUB.Add;
2530: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
2531: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,
2532: p_mailer =>l_header_rec.from_str,
2533: p_sender=>l_sender,
2534: p_subject=>l_header_rec.subject,

Line 3359: FND_MSG_PUB.Add;

3355: l_logmessage:='Start Sending Out Autoacknowledgement' ;
3356: iem_logger(l_logmessage);
3357: end if;
3358: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
3359: FND_MSG_PUB.Add;
3360: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
3361:
3362:
3363: if g_statement_log then

Line 3360: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

3356: iem_logger(l_logmessage);
3357: end if;
3358: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
3359: FND_MSG_PUB.Add;
3360: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
3361:
3362:
3363: if g_statement_log then
3364: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_AUTOACK in SSTOP_PROCESSING';

Line 3694: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,

3690: EXCEPTION WHEN ACK_FAILED THEN
3691: x_status:='E';
3692: IF (l_msg_count >= 1) THEN
3693: --Only one error
3694: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,
3695: p_encoded=>'F',
3696: p_data=>l_data,
3697: p_msg_index_out=>l_msg_index_out);
3698: l_error_text:= substr(l_data,1,500);

Line 3701: FOR j in 2..FND_MSG_PUB.Count_Msg LOOP

3697: p_msg_index_out=>l_msg_index_out);
3698: l_error_text:= substr(l_data,1,500);
3699: If (l_msg_count > 1) THEN
3700: --Display all the error messages
3701: FOR j in 2..FND_MSG_PUB.Count_Msg LOOP
3702: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_NEXT,
3703: p_encoded=>'F',
3704: p_data=>l_data,
3705: p_msg_index_out=>l_msg_index_out);

Line 3702: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_NEXT,

3698: l_error_text:= substr(l_data,1,500);
3699: If (l_msg_count > 1) THEN
3700: --Display all the error messages
3701: FOR j in 2..FND_MSG_PUB.Count_Msg LOOP
3702: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_NEXT,
3703: p_encoded=>'F',
3704: p_data=>l_data,
3705: p_msg_index_out=>l_msg_index_out);
3706: l_error_text:= l_error_text||substr(l_data,1,500);

Line 3915: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,

3911: p_status=>l_sr_status,
3912: x_interaction_id=>l_interaction_id);
3913: IF l_ret_status<>'S' THEN
3914: x_out_text:='SR update Status Api fails for SR# '||p_sr_id;
3915: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,
3916: p_encoded=>'F',
3917: p_data=>l_str,
3918: p_msg_index_out=>l_msg_count);
3919: raise SR_STATUS_UPD_FAIL;

Line 4210: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,

4206: WHEN IH_EXCEPTION THEN
4207: x_status:='E';
4208: IF (l_msg_count >= 1) THEN
4209: --Only one error
4210: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,
4211: p_encoded=>'F',
4212: p_data=>l_data,
4213: p_msg_index_out=>l_msg_index_out);
4214: l_error_text:= substr(l_data,1,500);

Line 4481: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,

4477: X_MSG_COUNT=>l_msg_count,
4478: X_MSG_DATA=>l_msg_data);
4479: IF l_ret_status<>'S' THEN
4480: x_out_text:='Error Encountered While Calling Create Autonotification';
4481: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,
4482: p_encoded=>'F',
4483: p_data=>l_data,
4484: p_msg_index_out=>l_msg_index_out);
4485: raise AUTOREPLY_ERROR;

Line 4502: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,

4498: X_MSG_DATA=>l_msg_data);
4499:
4500: IF l_ret_status<>'S' THEN
4501: x_out_text:='Error Encountered While Calling Insert Document ';
4502: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,
4503: p_encoded=>'F',
4504: p_data=>l_data,
4505: p_msg_index_out=>l_msg_index_out);
4506: raise AUTOREPLY_ERROR;

Line 4510: FND_MSG_PUB.Add;

4506: raise AUTOREPLY_ERROR;
4507: END IF;
4508: else
4509: FND_MESSAGE.Set_Name('IEM','IEM_REDIRECT_EXT_HDR');
4510: FND_MSG_PUB.Add;
4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4512: -- Get value for merge fields
4513: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
4514: FND_MSG_PUB.Add;

Line 4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

4507: END IF;
4508: else
4509: FND_MESSAGE.Set_Name('IEM','IEM_REDIRECT_EXT_HDR');
4510: FND_MSG_PUB.Add;
4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4512: -- Get value for merge fields
4513: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
4514: FND_MSG_PUB.Add;
4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

Line 4514: FND_MSG_PUB.Add;

4510: FND_MSG_PUB.Add;
4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4512: -- Get value for merge fields
4513: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
4514: FND_MSG_PUB.Add;
4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4516: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_post_rec.email_account_id,
4517: p_mailer=>l_header_rec.from_str, -- passing the sender name, sanjana rao, bug 8839425
4518: p_dflt_sender=>l_dflt_sender ,

Line 4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

4511: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4512: -- Get value for merge fields
4513: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
4514: FND_MSG_PUB.Add;
4515: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
4516: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_post_rec.email_account_id,
4517: p_mailer=>l_header_rec.from_str, -- passing the sender name, sanjana rao, bug 8839425
4518: p_dflt_sender=>l_dflt_sender ,
4519: p_subject=>l_header_rec.subject, --passing the subject, sanjana rao , bug 8839425

Line 4579: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,

4575: X_MSG_COUNT=>l_msg_count,
4576: X_MSG_DATA=>l_msg_data);
4577: IF l_ret_status<>'S' THEN
4578: x_out_text:='Error Encountered While Submitting Outbox Request';
4579: FND_MSG_PUB.Get(p_msg_index => FND_MSG_PUB.G_FIRST,
4580: p_encoded=>'F',
4581: p_data=>l_data,
4582: p_msg_index_out=>l_msg_index_out);
4583: raise AUTOREPLY_ERROR;

Line 5430: FND_MSG_PUB.Count_And_Get

5426: IF p_commit='T' THEN
5427: COMMIT WORK;
5428: END IF;
5429: -- Standard callto get message count and if count is 1, get message info.
5430: FND_MSG_PUB.Count_And_Get
5431: ( p_count => x_msg_count,
5432: p_data => x_msg_data
5433: );
5434: x_return_status:='S';

Line 5446: IF FND_MSG_PUB.Check_Msg_Level

5442: iem_logger(l_logmessage);
5443: end if;
5444: rollback to processautoreply;
5445: x_return_status := FND_API.G_RET_STS_ERROR;
5446: IF FND_MSG_PUB.Check_Msg_Level
5447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5448: THEN
5449: FND_MSG_PUB.Add_Exc_Msg
5450: ( G_PKG_NAME ,

Line 5447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

5443: end if;
5444: rollback to processautoreply;
5445: x_return_status := FND_API.G_RET_STS_ERROR;
5446: IF FND_MSG_PUB.Check_Msg_Level
5447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5448: THEN
5449: FND_MSG_PUB.Add_Exc_Msg
5450: ( G_PKG_NAME ,
5451: l_api_name

Line 5449: FND_MSG_PUB.Add_Exc_Msg

5445: x_return_status := FND_API.G_RET_STS_ERROR;
5446: IF FND_MSG_PUB.Check_Msg_Level
5447: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5448: THEN
5449: FND_MSG_PUB.Add_Exc_Msg
5450: ( G_PKG_NAME ,
5451: l_api_name
5452: );
5453: END IF;

Line 5454: FND_MSG_PUB.Count_And_Get

5450: ( G_PKG_NAME ,
5451: l_api_name
5452: );
5453: END IF;
5454: FND_MSG_PUB.Count_And_Get
5455: ( p_count => x_msg_count ,
5456: p_data => x_msg_data
5457: );
5458: END REPROCESSAUTOREPLY;

Line 6848: FND_MSG_PUB.initialize;

6844:
6845: -- Initialize message list if p_init_msg_list is set to TRUE.
6846: IF FND_API.to_Boolean( p_init_msg_list )
6847: THEN
6848: FND_MSG_PUB.initialize;
6849: END IF;
6850:
6851: FND_PROFILE.Get('IEM_SR_SUM_PREFIX', l_summary_prefix);
6852: l_summary := l_summary_prefix||' : '|| p_subject ;

Line 7149: IF (FND_MSG_PUB.Count_Msg > 1) THEN

7145: --dbms_output.put_line(l_logmessage);
7146: raise IEM_SR_NOT_CREATE;
7147: --end if;
7148: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7149: IF (FND_MSG_PUB.Count_Msg > 1) THEN
7150: --Display all the warning messages
7151: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7152: FND_MSG_PUB.Get(
7153: p_msg_index => j,

Line 7151: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

7147: --end if;
7148: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7149: IF (FND_MSG_PUB.Count_Msg > 1) THEN
7150: --Display all the warning messages
7151: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7152: FND_MSG_PUB.Get(
7153: p_msg_index => j,
7154: p_encoded => 'F',
7155: p_data => lx_msg_data,

Line 7152: FND_MSG_PUB.Get(

7148: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7149: IF (FND_MSG_PUB.Count_Msg > 1) THEN
7150: --Display all the warning messages
7151: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7152: FND_MSG_PUB.Get(
7153: p_msg_index => j,
7154: p_encoded => 'F',
7155: p_data => lx_msg_data,
7156: p_msg_index_out => lx_msg_index_out);

Line 7168: FND_MSG_PUB.Get(

7164: --dbms_output.put_line(l_logmessage);
7165: END LOOP;
7166: ELSE
7167: --Only one warning
7168: FND_MSG_PUB.Get(
7169: p_msg_index => 1,
7170: p_encoded => 'F',
7171: p_data => lx_msg_data,
7172: p_msg_index_out => lx_msg_index_out);

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

7211: EXCEPTION
7212: WHEN IEM_SR_NOT_CREATE THEN
7213: ROLLBACK TO ADVANCED_CREATE_SR;
7214: x_return_status := l_return_status ;
7215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7216:
7217: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7218:
7219: FND_MSG_PUB.Get(

Line 7217: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

7213: ROLLBACK TO ADVANCED_CREATE_SR;
7214: x_return_status := l_return_status ;
7215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7216:
7217: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7218:
7219: FND_MSG_PUB.Get(
7220: p_msg_index => j,
7221: p_encoded => 'F',

Line 7219: FND_MSG_PUB.Get(

7215: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
7216:
7217: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
7218:
7219: FND_MSG_PUB.Get(
7220: p_msg_index => j,
7221: p_encoded => 'F',
7222: p_data => lx_msg_data,
7223: p_msg_index_out => lx_msg_index_out);

Line 7244: FND_MSG_PUB.Count_And_Get

7240:
7241: WHEN FND_API.G_EXC_ERROR THEN
7242: ROLLBACK TO ADVANCED_CREATE_SR;
7243: x_return_status := FND_API.G_RET_STS_ERROR ;
7244: FND_MSG_PUB.Count_And_Get
7245: ( p_count => x_msg_count,p_data => x_msg_data);
7246:
7247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7248: ROLLBACK TO ADVANCED_CREATE_SR;

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

7246:
7247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7248: ROLLBACK TO ADVANCED_CREATE_SR;
7249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7250: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
7251:
7252: WHEN OTHERS THEN
7253: ROLLBACK TO ADVANCED_CREATE_SR;
7254: x_return_status := FND_API.G_RET_STS_ERROR;

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

7251:
7252: WHEN OTHERS THEN
7253: ROLLBACK TO ADVANCED_CREATE_SR;
7254: x_return_status := FND_API.G_RET_STS_ERROR;
7255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
7257: END IF;
7258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
7259: END;

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

7252: WHEN OTHERS THEN
7253: ROLLBACK TO ADVANCED_CREATE_SR;
7254: x_return_status := FND_API.G_RET_STS_ERROR;
7255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
7257: END IF;
7258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
7259: END;
7260:

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

7254: x_return_status := FND_API.G_RET_STS_ERROR;
7255: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7256: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME , l_api_name);
7257: END IF;
7258: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data );
7259: END;
7260:
7261: END ADVANCED_SR_PROCESSING;
7262: