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 IEM_RT_PROC_EMAILS

Line 1287: l_logmessage:='before calling IEM_RT_PROC_EMAILS_PVT.create_item';

1283: END IF;
1284:
1285:
1286: if g_statement_log then
1287: l_logmessage:='before calling IEM_RT_PROC_EMAILS_PVT.create_item';
1288: iem_logger(l_logmessage);
1289: end if;
1290: IEM_RT_PROC_EMAILS_PVT.create_item (
1291: p_api_version_number => 1.0,

Line 1290: IEM_RT_PROC_EMAILS_PVT.create_item (

1286: if g_statement_log then
1287: l_logmessage:='before calling IEM_RT_PROC_EMAILS_PVT.create_item';
1288: iem_logger(l_logmessage);
1289: end if;
1290: IEM_RT_PROC_EMAILS_PVT.create_item (
1291: p_api_version_number => 1.0,
1292: p_init_msg_list=>'F' ,
1293: p_commit=>'F',
1294: p_message_id =>l_post_rec.message_id,

Line 1321: l_logmessage:='After call to IEM_RT_PROC_EMAILS_PVT.create_item status :'||l_ret_status||' l_msg_data : '||l_msg_data;

1317: x_msg_data=>l_msg_data);
1318:
1319:
1320: if g_statement_log then
1321: l_logmessage:='After call to IEM_RT_PROC_EMAILS_PVT.create_item status :'||l_ret_status||' l_msg_data : '||l_msg_data;
1322: iem_logger(l_logmessage);
1323: end if;
1324:
1325: IF l_ret_status<>'S' THEN

Line 1568: -- Create a Record in IEM_RT_PROC_EMAILS

1564: IF l_stat<>'S' THEN
1565: l_logmessage:=l_out_text;
1566: raise ABORT_PROCESSING;
1567: END IF;
1568: -- Create a Record in IEM_RT_PROC_EMAILS
1569:
1570:
1571: if g_statement_log then
1572: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item after update mlcs 31';

Line 1572: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item after update mlcs 31';

1568: -- Create a Record in IEM_RT_PROC_EMAILS
1569:
1570:
1571: if g_statement_log then
1572: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item after update mlcs 31';
1573: iem_logger(l_logmessage);
1574: end if;
1575:
1576: IEM_RT_PROC_EMAILS_PVT.create_item (

Line 1576: IEM_RT_PROC_EMAILS_PVT.create_item (

1572: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item after update mlcs 31';
1573: iem_logger(l_logmessage);
1574: end if;
1575:
1576: IEM_RT_PROC_EMAILS_PVT.create_item (
1577: p_api_version_number => 1.0,
1578: p_init_msg_list=>'F' ,
1579: p_commit=>'F',
1580: p_message_id =>l_post_rec.message_id,

Line 2011: l_logmessage:='calling IEM_RT_PROC_EMAILS_PVT.create_item after auto update sr';

2007:
2008:
2009:
2010: if g_statement_log then
2011: l_logmessage:='calling IEM_RT_PROC_EMAILS_PVT.create_item after auto update sr';
2012: iem_logger(l_logmessage);
2013: end if;
2014: IEM_RT_PROC_EMAILS_PVT.create_item (
2015: p_api_version_number => 1.0,

Line 2014: IEM_RT_PROC_EMAILS_PVT.create_item (

2010: if g_statement_log then
2011: l_logmessage:='calling IEM_RT_PROC_EMAILS_PVT.create_item after auto update sr';
2012: iem_logger(l_logmessage);
2013: end if;
2014: IEM_RT_PROC_EMAILS_PVT.create_item (
2015: p_api_version_number => 1.0,
2016: p_init_msg_list=>'F' ,
2017: p_commit=>'F',
2018: p_message_id =>l_post_rec.message_id,

Line 2045: l_logmessage:='after IEM_RT_PROC_EMAILS_PVT.create_item after auto update sr : status :'||l_ret_status ||' data : '||l_msg_data;

2041: x_msg_data=>l_msg_data);
2042:
2043:
2044: if g_statement_log then
2045: l_logmessage:='after IEM_RT_PROC_EMAILS_PVT.create_item after auto update sr : status :'||l_ret_status ||' data : '||l_msg_data;
2046: iem_logger(l_logmessage);
2047: end if;
2048:
2049:

Line 2381: IEM_RT_PROC_EMAILS_PVT.create_item (

2377: l_logmessage:=l_out_text;
2378: raise ABORT_PROCESSING;
2379: END IF;
2380:
2381: IEM_RT_PROC_EMAILS_PVT.create_item (
2382: p_api_version_number => 1.0,
2383: p_init_msg_list=>'F' ,
2384: p_commit=>'F',
2385: p_message_id =>l_post_rec.message_id,

Line 2942: l_logmessage:='calling IEM_RT_PROC_EMAILS_PVT.create_item after routing';

2938: END IF;
2939:
2940:
2941: if g_statement_log then
2942: l_logmessage:='calling IEM_RT_PROC_EMAILS_PVT.create_item after routing';
2943: iem_logger(l_logmessage);
2944: end if;
2945: IEM_RT_PROC_EMAILS_PVT.create_item (
2946: p_api_version_number => 1.0,

Line 2945: IEM_RT_PROC_EMAILS_PVT.create_item (

2941: if g_statement_log then
2942: l_logmessage:='calling IEM_RT_PROC_EMAILS_PVT.create_item after routing';
2943: iem_logger(l_logmessage);
2944: end if;
2945: IEM_RT_PROC_EMAILS_PVT.create_item (
2946: p_api_version_number => 1.0,
2947: p_init_msg_list=>'F' ,
2948: p_commit=>'F',
2949: p_message_id =>l_post_rec.message_id,

Line 2976: l_logmessage:='end IEM_RT_PROC_EMAILS_PVT.create_item after routing : '||l_ret_status||' l_msg_data : '||l_msg_data;

2972: x_msg_data=>l_msg_data);
2973:
2974:
2975: if g_statement_log then
2976: l_logmessage:='end IEM_RT_PROC_EMAILS_PVT.create_item after routing : '||l_ret_status||' l_msg_data : '||l_msg_data;
2977: iem_logger(l_logmessage);
2978: end if;
2979: IF l_ret_status='S' THEN
2980: IF l_auto_flag='Y' THEN -- auto Routing Processing

Line 3017: update iem_rt_proc_emails

3013: iem_logger(l_logmessage);
3014: end if;
3015: ELSE -- as part of bug fix 7428636
3016: -- Able to create RT Item So do autorouting
3017: update iem_rt_proc_emails
3018: set resource_id=l_agentid
3019: where message_id=l_post_rec.message_id;
3020: -- Create MLCS for Auto Routing
3021:

Line 3290: -- Create a Record in IEM_RT_PROC_EMAILS_PVT

3286: set creation_date=sysdate
3287: where message_id=l_post_rec.message_id;
3288: commit;
3289: ELSE
3290: -- Create a Record in IEM_RT_PROC_EMAILS_PVT
3291:
3292: if g_statement_log then
3293: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item in STOP_AUTO_PROCESS';
3294: iem_logger(l_logmessage);

Line 3293: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item in STOP_AUTO_PROCESS';

3289: ELSE
3290: -- Create a Record in IEM_RT_PROC_EMAILS_PVT
3291:
3292: if g_statement_log then
3293: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item in STOP_AUTO_PROCESS';
3294: iem_logger(l_logmessage);
3295: end if;
3296: IEM_RT_PROC_EMAILS_PVT.create_item (
3297: p_api_version_number => 1.0,

Line 3296: IEM_RT_PROC_EMAILS_PVT.create_item (

3292: if g_statement_log then
3293: l_logmessage:='Calling IEM_RT_PROC_EMAILS_PVT.create_item in STOP_AUTO_PROCESS';
3294: iem_logger(l_logmessage);
3295: end if;
3296: IEM_RT_PROC_EMAILS_PVT.create_item (
3297: p_api_version_number => 1.0,
3298: p_init_msg_list=>'F' ,
3299: p_commit=>'F',
3300: p_message_id =>l_post_rec.message_id,

Line 3326: l_logmessage:=' Calling IEM_RT_PROC_EMAILS_PVT.create_item in STOP_AUTO_PROCESS :status : '||l_ret_status||' l_msg_data: '||l_msg_data;

3322: x_msg_count=>l_msg_count ,
3323: x_msg_data=>l_msg_data);
3324:
3325: if g_statement_log then
3326: l_logmessage:=' Calling IEM_RT_PROC_EMAILS_PVT.create_item in STOP_AUTO_PROCESS :status : '||l_ret_status||' l_msg_data: '||l_msg_data;
3327: iem_logger(l_logmessage);
3328: end if;
3329:
3330:

Line 4884: l_mail_rec iem_rt_proc_emails%rowtype;

4880: x_msg_count OUT NOCOPY NUMBER,
4881: x_msg_data OUT NOCOPY VARCHAR2) IS
4882:
4883: l_header_rec iem_ms_base_headers%rowtype;
4884: l_mail_rec iem_rt_proc_emails%rowtype;
4885: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
4886: l_counter number;
4887: l_message_id number;
4888: l_top_intent varchar2(50);

Line 4972: -- Find the record from iem_rt_proc_emails based on media id

4968: l_level:='STATEMENT';
4969: FND_LOG_REPOSITORY.init(null,null);
4970: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
4971: SAVEPOINT processautoreply;
4972: -- Find the record from iem_rt_proc_emails based on media id
4973: BEGIN
4974: select * into l_mail_rec from iem_rt_proc_emails
4975: where ih_media_item_id=p_media_id and msg_status='AUTOREPLY';
4976: EXCEPTION WHEN OTHERS THEN

Line 4974: select * into l_mail_rec from iem_rt_proc_emails

4970: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
4971: SAVEPOINT processautoreply;
4972: -- Find the record from iem_rt_proc_emails based on media id
4973: BEGIN
4974: select * into l_mail_rec from iem_rt_proc_emails
4975: where ih_media_item_id=p_media_id and msg_status='AUTOREPLY';
4976: EXCEPTION WHEN OTHERS THEN
4977: if g_exception_log then
4978: l_logmessage:='Error while selecting Message For re-processing '||sqlerrm;

Line 5238: update iem_rt_proc_emails

5234: IF l_group_id=-1 then
5235: l_group_id:=0;
5236: l_auto_flag:='Y';
5237: END IF;
5238: update iem_rt_proc_emails
5239: set resource_id=0,
5240: group_id=l_group_id,
5241: customer_id=p_customer_id,
5242: contact_id=p_contact_id,