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_EMAIL_PROC_PVT

Line 1: PACKAGE BODY IEM_EMAIL_PROC_PVT as

1: PACKAGE BODY IEM_EMAIL_PROC_PVT as
2: /* $Header: iemmprpb.pls 120.20.12010000.3 2008/11/26 00:26:51 rtripath ship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_PROC_PVT ';
5: g_statement_log boolean; -- Statement Level Logging

Line 4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_PROC_PVT ';

1: PACKAGE BODY IEM_EMAIL_PROC_PVT as
2: /* $Header: iemmprpb.pls 120.20.12010000.3 2008/11/26 00:26:51 rtripath ship $ */
3:
4: G_PKG_NAME CONSTANT varchar2(30) :='IEM_EMAIL_PROC_PVT ';
5: g_statement_log boolean; -- Statement Level Logging
6: g_exception_log boolean; -- Statement Level Logging
7: g_error_log boolean; -- Statement Level Logging
8: g_contact_id number;

Line 195: IEM_EMAIL_PROC_PVT.iem_returned_msg_rec(l_post_rec);

191: BEGIN
192:
193: /* Get the message in FIFO order to process from iem_rt_preproc_emails */
194:
195: IEM_EMAIL_PROC_PVT.iem_returned_msg_rec(l_post_rec);
196: IF l_post_rec.message_id is null then
197: raise NO_RECORD_TO_PROCESS ;
198: END IF;
199: l_message_id:=l_post_rec.message_id;

Line 210: iem_email_proc_pvt.iem_process_intent(l_post_rec.email_account_id,l_post_rec.message_id,l_ret_status,l_out_text);

206: where email_account_id=l_post_rec.email_account_id;
207: l_email_domain_name:=substr(l_email_address,instr(l_email_address,'@',1)+1,length(l_email_address));
208: -- Do Intent Processing if Enabled for Intent
209: IF l_intent_flg>0 THEN -- intent is enabled for the account
210: iem_email_proc_pvt.iem_process_intent(l_post_rec.email_account_id,l_post_rec.message_id,l_ret_status,l_out_text);
211: IF l_ret_status<>'S' then
212: if g_error_log then
213: l_logmessage:='Error During Intent Processing.Not able to Map intent to inbound emails.Continued Processing ';
214: iem_logger(l_logmessage);

Line 241: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

237:
238: -- Check For TAG DATA in Inbound Emails
239:
240: l_tag_keyval.delete;
241: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID
242: (p_subject=>l_header_rec.subject,
243: x_id=>l_encrypted_id,
244: x_Status=>l_ret_status);
245: if l_ret_status='E' then

Line 503: IEM_EMAIL_PROC_PVT.IEM_CLASSIFICATION_PROC(

499: l_class_val_tbl(l_counter).datatype:=l_tag_keyval(j).datatype;
500: END LOOP;
501: END IF;
502: IF l_post_rec.rt_classification_id is null THEN
503: IEM_EMAIL_PROC_PVT.IEM_CLASSIFICATION_PROC(
504: p_email_account_id=>l_post_rec.email_account_id,
505: p_keyval=>l_class_val_tbl ,
506: x_rt_classification_id=>l_rt_classification_id,
507: x_status=>l_status,

Line 627: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

623: l_logmessage:='New Interaction is not created and use old one for Redirect message ';
624: iem_logger(l_logmessage);
625: end if;
626: ELSE
627: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
628: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
629: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
630: p_interaction_rec=>l_interaction_rec,
631: p_activity_rec=>l_activity_rec ,

Line 665: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

661: l_media_rec.media_item_ref := l_post_rec.message_id; -- Change for 11iX
662: l_media_rec.media_data := l_ih_subject;
663: l_media_rec.classification := l_routing_classification;
664: l_media_rec.address := l_sender; --new on MP-R 07/23/03 by rtripath
665: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
666: p_type=>'MEDIA' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
667: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
668: p_interaction_rec=>l_interaction_rec,
669: p_activity_rec=>l_activity_rec ,

Line 685: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

681: l_media_rec.source_id := l_post_rec.email_account_id;
682: l_media_rec.classification := l_routing_classification;
683: l_media_rec.address := l_sender; --new on MP-R 07/23/03 by rtripath
684:
685: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
686: p_type=>'MEDIA' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
687: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
688: p_interaction_rec=>l_interaction_rec,
689: p_activity_rec=>l_activity_rec ,

Line 726: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

722: end if;
723: l_media_lc_rec.handler_id := 680;
724: l_media_lc_rec.type_type := 'Email, Inbound';
725:
726: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
727: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
728: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
729: p_interaction_rec=>l_interaction_rec,
730: p_activity_rec=>l_activity_rec ,

Line 745: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

741:
742: -- Update the Media Life Cycle for Mail Preprocessing
743: l_media_lc_rec.milcs_id:=l_milcs_id;
744:
745: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
746: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
747: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
748: p_interaction_rec=>l_interaction_rec,
749: p_activity_rec=>l_activity_rec ,

Line 768: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

764: l_media_lc_rec.start_date_time := sysdate;
765: l_media_lc_rec.handler_id := 680;
766: l_media_lc_rec.type_type := 'Email, Inbound';
767:
768: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
769: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
770: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
771: p_interaction_rec=>l_interaction_rec,
772: p_activity_rec=>l_activity_rec ,

Line 790: IEM_EMAIl_PROC_PVT.IEM_PROC_IH(

786: l_activity_rec.action_id := 95; -- EMAILPROCESSED
787: l_activity_rec.interaction_id := l_interaction_id;
788: l_activity_rec.action_item_id := 45;-- EMAIL
789:
790: IEM_EMAIl_PROC_PVT.IEM_PROC_IH(
791: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
792: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
793: p_interaction_rec=>l_interaction_rec,
794: p_activity_rec=>l_activity_rec ,

Line 830: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

826: l_media_lc_rec.start_date_time := sysdate;
827: l_media_lc_rec.handler_id := 680;
828: l_media_lc_rec.type_type := 'Email, Inbound';
829:
830: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
831: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
832: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
833: p_interaction_rec=>l_interaction_rec,
834: p_activity_rec=>l_activity_rec ,

Line 847: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

843: END IF;
844: -- Update the Media Life Cycle for Auto Delete
845: l_media_lc_rec.milcs_id:=l_milcs_id;
846:
847: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
848: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
849: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
850: p_interaction_rec=>l_interaction_rec,
851: p_activity_rec=>l_activity_rec ,

Line 870: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

866: l_activity_rec.action_id := 72; -- EMAIL AUTO _DELETED
867: l_activity_rec.interaction_id := l_interaction_id;
868: l_activity_rec.action_item_id := 45;-- EMAIL
869:
870: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
871: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
872: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
873: p_interaction_rec=>l_interaction_rec,
874: p_activity_rec=>l_activity_rec ,

Line 920: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,

916: raise ABORT_PROCESSING;
917: END IF;
918:
919: -- This wrapup procedure will close the interaction and media and Stamp the message as Deleted in Archived Table.
920: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
921: p_media_id=>l_media_id ,
922: p_milcs_id=>l_mp_milcs_id,
923: p_action=>'D',
924: p_email_rec =>l_post_rec,

Line 1029: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1025: l_activity_rec.action_id := 65; -- EMAIL Resolved No Reply
1026: l_activity_rec.interaction_id := l_interaction_id;
1027: l_activity_rec.action_item_id := 45;-- EMAIL
1028:
1029: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1030: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1031: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1032: p_interaction_rec=>l_interaction_rec,
1033: p_activity_rec=>l_activity_rec ,

Line 1050: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1046: l_media_lc_rec.start_date_time := sysdate;
1047: l_media_lc_rec.handler_id := 680;
1048: l_media_lc_rec.type_type := 'Email, Inbound';
1049:
1050: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1051: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1052: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1053: p_interaction_rec=>l_interaction_rec,
1054: p_activity_rec=>l_activity_rec ,

Line 1067: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1063: END IF;
1064: -- Update the Media Life Cycle for Auto Resolve
1065: l_media_lc_rec.milcs_id:=l_milcs_id;
1066:
1067: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1068: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1069: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1070: p_interaction_rec=>l_interaction_rec,
1071: p_activity_rec=>l_activity_rec ,

Line 1115: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,

1111: IF l_ret_status<>'S' THEN
1112: l_logmessage:='EXECPROC:Error While Inserting Record in Proc Emails Table ';
1113: raise ABORT_PROCESSING;
1114: END IF;
1115: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1116: p_media_id=>l_media_id ,
1117: p_milcs_id=>l_mp_milcs_id,
1118: p_action=>'R',
1119: p_email_rec =>l_post_rec,

Line 1142: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>l_post_rec.email_account_id ,

1138: l_email_doc_tbl(l_param_index).type:='I';
1139: EXIT;
1140: END LOOP;
1141: l_qual_tbl.delete;
1142: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>l_post_rec.email_account_id ,
1143: p_mailer =>l_header_rec.from_str,
1144: p_dflt_sender=>l_sender ,
1145: p_subject=>l_header_rec.subject,
1146: x_qual_tbl=> l_qual_tbl,

Line 1237: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1233: l_media_lc_rec.start_date_time := sysdate;
1234: l_media_lc_rec.handler_id := 680;
1235: l_media_lc_rec.type_type := 'Email, Inbound';
1236:
1237: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1238: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1239: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1240: p_interaction_rec=>l_interaction_rec,
1241: p_activity_rec=>l_activity_rec ,

Line 1285: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1281: raise ABORT_PROCESSING;
1282: END IF;
1283: -- Update the Media Life Cycle for Auto Create SR
1284: l_media_lc_rec.milcs_id:=l_milcs_id;
1285: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1286: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1287: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1288: p_interaction_rec=>l_interaction_rec,
1289: p_activity_rec=>l_activity_rec ,

Line 1308: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1304: l_activity_rec.interaction_id := l_interaction_id;
1305: l_activity_rec.action_item_id := 45;-- EMAIL
1306: l_activity_rec.DOC_ID := l_sr_id;
1307: l_activity_rec.DOC_REF := 'SR';
1308: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1309: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1310: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1311: p_interaction_rec=>l_interaction_rec,
1312: p_activity_rec=>l_activity_rec ,

Line 1338: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1334: l_activity_rec.interaction_id := l_interaction_id;
1335: l_activity_rec.action_item_id := 17;-- SR
1336: l_activity_rec.DOC_ID := l_sr_id;
1337: l_activity_rec.DOC_REF := 'SR';
1338: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1339: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1340: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1341: p_interaction_rec=>l_interaction_rec,
1342: p_activity_rec=>l_activity_rec ,

Line 1356: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1352: END IF;
1353: -- Update the mail Processing Life Cycles
1354: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
1355: l_media_lc_rec.milcs_type_id:=17;
1356: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1357: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1358: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1359: p_interaction_rec=>l_interaction_rec,
1360: p_activity_rec=>l_activity_rec ,

Line 1384: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1380: and aa.default_wrap_id = wu.wrap_id;
1381: l_interaction_rec.interaction_id:=l_interaction_id;
1382: select contact_party_id into l_cust_contact_id from jtf_ih_interactions
1383: where interaction_id=l_interaction_id;
1384: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1385: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1386: p_action=>'CLOSE' , -- ADD/UPDATE/CLOSE
1387: p_interaction_rec=>l_interaction_rec,
1388: p_activity_rec=>l_activity_rec ,

Line 1421: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,

1417: END IF;
1418: l_autoack_flag:='N'; --so that no autoack is send.
1419: else
1420: -- Resolving the message without sending notifications
1421: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1422: p_media_id=>l_media_id ,
1423: p_milcs_id=>l_mp_milcs_id,
1424: p_action=>'R',
1425: p_email_rec =>l_post_rec,

Line 1448: IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE(p_sr_id=>l_sr_id ,

1444: end if; -- for if l_party_id is not null
1445: -- End of create Sr
1446: ELSE -- This is a update service request
1447: IF (l_status_id is not null) and (l_sr_id is not null) then
1448: IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE(p_sr_id=>l_sr_id ,
1449: p_status_id=>l_status_id,
1450: p_email_rec=>l_post_rec,
1451: x_status =>l_stat,
1452: x_out_text=>l_out_text) ;

Line 1462: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1458: l_activity_rec.interaction_id := l_interaction_id;
1459: l_activity_rec.action_item_id := 45;-- EMAIL
1460: l_activity_rec.DOC_ID := l_sr_id;
1461: l_activity_rec.DOC_REF := 'SR';
1462: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1463: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1464: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1465: p_interaction_rec=>l_interaction_rec,
1466: p_activity_rec=>l_activity_rec ,

Line 1483: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1479: l_media_lc_rec.media_id :=l_media_id ;
1480: l_media_lc_rec.milcs_type_id := 40; --EMAIL_AUTO_UPDATED_SR
1481: l_media_lc_rec.start_date_time := sysdate;
1482: l_media_lc_rec.handler_id := 680;
1483: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1484: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1485: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1486: p_interaction_rec=>l_interaction_rec,
1487: p_activity_rec=>l_activity_rec ,

Line 1499: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1495: raise ABORT_PROCESSING;
1496: END IF;
1497: -- Update the Media Life Cycle for Auto Update of SR
1498: l_media_lc_rec.milcs_id:=l_id;
1499: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1500: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1501: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1502: p_interaction_rec=>l_interaction_rec,
1503: p_activity_rec=>l_activity_rec ,

Line 1558: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1554: where aa.action_id =75
1555: and aa.action_item_id =45
1556: and aa.default_wrap_id = wu.wrap_id;
1557: l_interaction_rec.interaction_id:=l_interaction_id;
1558: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1559: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1560: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1561: p_interaction_rec=>l_interaction_rec,
1562: p_activity_rec=>l_activity_rec ,

Line 1605: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1601: l_autoack_flag:='N';
1602: -- Update the mail Processing Life Cycles
1603: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
1604: l_media_lc_rec.milcs_type_id:=17;
1605: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1606: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1607: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1608: p_interaction_rec=>l_interaction_rec,
1609: p_activity_rec=>l_activity_rec ,

Line 1621: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,

1617: l_logmessage:=l_out_text;
1618: raise ABORT_PROCESSING;
1619: END IF;
1620: else -- notification flag is not set so resolve the message
1621: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1622: p_media_id=>l_media_id ,
1623: p_milcs_id=>l_mp_milcs_id,
1624: p_action=>'R',
1625: p_email_rec =>l_post_rec,

Line 1662: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,

1658: end if;
1659: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
1660: FND_MSG_PUB.Add;
1661: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
1662: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,
1663: p_mailer =>l_header_rec.from_str,
1664: p_sender=>l_sender,
1665: p_subject=>l_header_rec.subject,
1666: p_domain_name=>l_email_domain_name,

Line 1685: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1681: l_logmessage:='Error In Autoack '||l_out_text;
1682: iem_logger(l_logmessage);
1683: end if;
1684: ELSE
1685: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1686: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1687: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1688: p_interaction_rec=>l_interaction_rec,
1689: p_activity_rec=>l_activity_rec ,

Line 1697: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1693: x_status=>l_stat ,
1694: x_out_text=>l_out_text );
1695:
1696: l_media_lc_rec.milcs_id:=l_milcs_id;
1697: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1698: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1699: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1700: p_interaction_rec=>l_interaction_rec,
1701: p_activity_rec=>l_activity_rec ,

Line 1752: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1748: l_media_lc_rec.media_id :=l_media_id ;
1749: l_media_lc_rec.start_date_time := sysdate;
1750: l_media_lc_rec.handler_id := 680;
1751: -- Create MLCS for Auto-Redirect
1752: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1753: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1754: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1755: p_interaction_rec=>l_interaction_rec,
1756: p_activity_rec=>l_activity_rec ,

Line 1768: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1764: raise ABORT_PROCESSING;
1765: END IF;
1766: -- Update the Media Life Cycle for Auto RRRR
1767: l_media_lc_rec.milcs_id:=l_milcs_id;
1768: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1769: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1770: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1771: p_interaction_rec=>l_interaction_rec,
1772: p_activity_rec=>l_activity_rec ,

Line 1842: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,

1838: msg_status='REDIRECT',
1839: ih_media_item_id=l_media_id
1840: where message_id=l_post_rec.message_id;
1841:
1842: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1843: p_media_id=>l_media_id ,
1844: p_milcs_id=>l_mp_milcs_id,
1845: p_action=>null,
1846: p_email_rec =>l_post_rec,

Line 1970: IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC(

1966: l_search_type:=null;
1967: l_cm_Cat_id:=0;
1968: end if ; -- end if for l_autoproc_result='T'
1969: -- CALLING ROUTING ----
1970: IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC(
1971: p_email_account_id=>l_post_rec.email_account_id,
1972: p_keyval=>l_class_val_tbl,
1973: x_routing_group_id=>l_group_id,
1974: x_status=>l_status,

Line 2057: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2053: l_media_lc_rec.resource_id := l_agentid;
2054: l_stat:='S' ; -- reset to 'S' before starting any MLCS
2055: -- IH activity;
2056:
2057: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2058: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2059: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2060: p_interaction_rec=>l_interaction_rec,
2061: p_activity_rec=>l_activity_rec ,

Line 2077: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2073: END IF;
2074: -- Update the Media Life Cycle for Auto Routing
2075: if l_stat='S' then
2076: l_media_lc_rec.milcs_id:=l_milcs_id;
2077: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2078: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2079: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2080: p_interaction_rec=>l_interaction_rec,
2081: p_activity_rec=>l_activity_rec ,

Line 2134: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2130: END IF;
2131: -- Update the Media Life Cycle for Mail processing
2132: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
2133: l_media_lc_rec.milcs_type_id := 17;
2134: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2135: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2136: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2137: p_interaction_rec=>l_interaction_rec,
2138: p_activity_rec=>l_activity_rec ,

Line 2160: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(

2156: BEGIN
2157: IF l_search_type<>'CM' THEN -- Not a MES category based mapping
2158: l_start_search:=1;
2159: FOR v1 in c_class_id LOOP
2160: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
2161: l_post_rec.message_id ,
2162: l_post_rec.email_account_id ,
2163: v1.classification_id,
2164: l_category_id,

Line 2228: iem_email_proc_pvt.IEM_PROC_IH(

2224: when STOP_AUTO_PROCESSING THEN
2225: -- Update the Media Life Cycle for Mail processing -- no need to call wrapup
2226: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
2227: l_media_lc_rec.milcs_type_id := 17;
2228: iem_email_proc_pvt.IEM_PROC_IH(
2229: p_type=>'MLCS' ,-- MEDIA/ACTIVITY/MLCS/INTERACTION
2230: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2231: p_interaction_rec=>l_interaction_rec,
2232: p_activity_rec=>l_activity_rec ,

Line 2311: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,

2307: end if;
2308: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
2309: FND_MSG_PUB.Add;
2310: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
2311: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,
2312: p_mailer =>l_header_rec.from_str,
2313: p_sender=>l_sender,
2314: p_subject=>l_header_rec.subject,
2315: p_domain_name=>l_email_domain_name,

Line 2334: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2330: l_logmessage:='Error In Autoack '||l_out_text;
2331: iem_logger(l_logmessage);
2332: end if;
2333: ELSE
2334: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2335: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2336: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2337: p_interaction_rec=>l_interaction_rec,
2338: p_activity_rec=>l_activity_rec ,

Line 2346: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2342: x_status=>l_stat ,
2343: x_out_text=>l_out_text );
2344:
2345: l_media_lc_rec.milcs_id:=l_milcs_id;
2346: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2347: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2348: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2349: p_interaction_rec=>l_interaction_rec,
2350: p_activity_rec=>l_activity_rec ,

Line 2441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);

2437: PROCEDURE iem_logger(l_logmessage in varchar2) IS
2438: begin
2439: if g_statement_log THEN
2440: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2441: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2442: end if;
2443: end if;
2444: if g_exception_log then
2445: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);

2442: end if;
2443: end if;
2444: if g_exception_log then
2445: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2446: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2447: end if;
2448: end if;
2449: if g_error_log then
2450: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2451: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);

2447: end if;
2448: end if;
2449: if g_error_log then
2450: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2451: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
2452: end if;
2453: end if;
2454: end iem_logger;
2455:

Line 2515: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_master_account_id ,

2511: l_subject varchar2(500);
2512: l_msg_index_out number;
2513: BEGIN
2514: x_status:='S';
2515: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_master_account_id ,
2516: p_mailer=>p_mailer,
2517: p_dflt_sender=>p_dflt_sender ,
2518: p_subject=>p_subject,
2519: x_qual_tbl=> l_qual_tbl,

Line 2676: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(

2672: where message_id=p_message_id
2673: and score = (select max(score) from iem_email_classifications
2674: where message_id=p_message_id)
2675: and rownum=1;
2676: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
2677: p_message_id ,
2678: p_email_account_id ,
2679: l_class,
2680: l_category_id,

Line 3153: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3149: l_msg_count number;
3150: begin
3151: -- Update the mail Processing Life Cycles
3152: l_media_lc_rec.milcs_id:=p_milcs_id;
3153: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3154: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3155: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
3156: p_interaction_rec=>l_interaction_rec,
3157: p_activity_rec=>l_activity_rec ,

Line 3183: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3179: and aa.default_wrap_id = wu.wrap_id;
3180: EXCEPTION WHEN OTHERS THEN
3181: null;
3182: END;
3183: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3184: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3185: p_action=>'CLOSE' , -- ADD/UPDATE/CLOSE
3186: p_interaction_rec=>l_interaction_rec,
3187: p_activity_rec=>l_activity_rec ,

Line 3199: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3195: raise WRAPUP_ERROR;
3196: END IF;
3197: --Closing the media Item
3198: l_media_rec.media_id:=p_media_id;
3199: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3200: p_type=>'MEDIA' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3201: p_action=>'CLOSE' , -- ADD/UPDATE/CLOSE
3202: p_interaction_rec=>l_interaction_rec,
3203: p_activity_rec=>l_activity_rec ,

Line 3421: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_post_rec.email_account_id,

3417: -- Get value for merge fields
3418: FND_MESSAGE.Set_Name('IEM','IEM_ADM_AUTO_ACK_CUSTOMER');
3419: FND_MSG_PUB.Add;
3420: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
3421: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_post_rec.email_account_id,
3422: p_mailer=>null, -- need to pass from address
3423: p_dflt_sender=>l_dflt_sender ,
3424: p_subject=>null, -- pass the subject
3425: x_qual_tbl=> l_qual_tbl,

Line 3875: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');

3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3872: END IF;
3873: l_level:='STATEMENT';
3874: FND_LOG_REPOSITORY.init(null,null);
3875: g_statement_log:= fnd_log.test(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.iem_email_proc_pvt');
3876: SAVEPOINT processautoreply;
3877: -- Find the record from iem_rt_proc_emails based on media id
3878: BEGIN
3879: select * into l_mail_rec from iem_rt_proc_emails

Line 4126: iem_email_proc_pvt.IEM_ROUTING_PROC(

4122: l_search_type:=null;
4123: l_cm_Cat_id:=0;
4124: end if ; -- end if for l_autoproc_result='T'
4125: -- CALLING ROUTING ----
4126: iem_email_proc_pvt.IEM_ROUTING_PROC(
4127: p_email_account_id=>l_mail_rec.email_account_id,
4128: p_keyval=>l_class_val_tbl,
4129: x_routing_group_id=>l_group_id,
4130: x_status=>l_status,

Line 4188: iem_email_proc_pvt.IEM_PROC_IH(

4184: l_media_lc_rec.handler_id := 680;
4185: l_media_lc_rec.type_type := 'Email, Inbound';
4186: l_media_lc_rec.resource_id := l_agentid;
4187:
4188: iem_email_proc_pvt.IEM_PROC_IH(
4189: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
4190: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
4191: p_interaction_rec=>l_interaction_rec,
4192: p_activity_rec=>l_activity_rec ,

Line 4207: iem_email_proc_pvt.IEM_PROC_IH(

4203: rollback to auto_route;
4204: ELSE
4205: -- Update the Media Life Cycle for Auto Routing
4206: l_media_lc_rec.milcs_id:=l_milcs_id;
4207: iem_email_proc_pvt.IEM_PROC_IH(
4208: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
4209: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
4210: p_interaction_rec=>l_interaction_rec,
4211: p_activity_rec=>l_activity_rec ,

Line 4265: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(

4261: BEGIN
4262: IF l_search_type<>'CM' THEN -- Not a MES category based mapping
4263: l_start_search:=1;
4264: FOR v1 in c_class_id LOOP
4265: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
4266: l_mail_rec.message_id ,
4267: l_mail_rec.email_account_id ,
4268: v1.classification_id,
4269: l_category_id,

Line 4838: end IEM_EMAIL_PROC_PVT;

4834: x_status:='E';
4835: end IEM_RETURN_ENCRYPTID;
4836:
4837:
4838: end IEM_EMAIL_PROC_PVT;