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.45.12020000.5 2013/01/23 07:07:23 lkullamb 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.45.12020000.5 2013/01/23 07:07:23 lkullamb 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 235: IEM_EMAIL_PROC_PVT.iem_returned_msg_rec(l_post_rec);

231: l_logmessage:='starting to get the message in FIFO order to process from iem_rt_preproc_emails, messageID :';
232: iem_logger(l_logmessage||l_post_rec.message_id);
233: end if;
234:
235: IEM_EMAIL_PROC_PVT.iem_returned_msg_rec(l_post_rec);
236: IF l_post_rec.message_id is null then
237: raise NO_RECORD_TO_PROCESS ;
238: END IF;
239: l_message_id:=l_post_rec.message_id;

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

259: if g_statement_log then
260: l_logmessage:='intent is enabled for the account';
261: iem_logger(l_logmessage);
262: end if;
263: iem_email_proc_pvt.iem_process_intent(l_post_rec.email_account_id,l_post_rec.message_id,l_ret_status,l_out_text);
264: IF l_ret_status<>'S' then
265: if g_error_log then
266: l_logmessage:='Error During Intent Processing.Not able to Map intent to inbound emails.Continued Processing ';
267: iem_logger(l_logmessage);

Line 302: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID

298: l_logmessage:='Calling tag api';
299: iem_logger(l_logmessage);
300: end if;
301:
302: IEM_EMAIL_PROC_PVT.IEM_RETURN_ENCRYPTID
303: (p_subject=>l_header_rec.subject,
304: x_id=>l_encrypted_id,
305: x_Status=>l_ret_status);
306:

Line 710: IEM_EMAIL_PROC_PVT.IEM_CLASSIFICATION_PROC(

706: if g_statement_log then
707: l_logmessage:='rt_classification_id is null ,calling IEM_CLASSIFICATION_PROC' ;
708: iem_logger(l_logmessage);
709: end if;
710: IEM_EMAIL_PROC_PVT.IEM_CLASSIFICATION_PROC(
711: p_email_account_id=>l_post_rec.email_account_id,
712: p_keyval=>l_class_val_tbl ,
713: x_rt_classification_id=>l_rt_classification_id,
714: x_status=>l_status,

Line 899: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

895: l_logmessage:='Start calling add interaction';
896: iem_logger(l_logmessage);
897: end if;
898:
899: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
900: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
901: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
902: p_interaction_rec=>l_interaction_rec,
903: p_activity_rec=>l_activity_rec ,

Line 912: l_logmessage:='status in IEM_EMAIL_PROC_PVT.IEM_PROC_IH : ' ||l_stat || 'l_out_text : '|| l_out_text;

908: x_out_text=>l_out_text );
909:
910:
911: if g_statement_log then
912: l_logmessage:='status in IEM_EMAIL_PROC_PVT.IEM_PROC_IH : ' ||l_stat || 'l_out_text : '|| l_out_text;
913: iem_logger(l_logmessage);
914: end if;
915:
916: select contact_party_id into l_cust_contact_id from jtf_ih_interactions

Line 956: l_logmessage:='Before calling add IEM_EMAIL_PROC_PVT.IEM_PROC_IH media';

952:
953:
954:
955: if g_statement_log then
956: l_logmessage:='Before calling add IEM_EMAIL_PROC_PVT.IEM_PROC_IH media';
957: iem_logger(l_logmessage);
958: end if;
959:
960: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 960: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

956: l_logmessage:='Before calling add IEM_EMAIL_PROC_PVT.IEM_PROC_IH media';
957: iem_logger(l_logmessage);
958: end if;
959:
960: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
961: p_type=>'MEDIA' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
962: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
963: p_interaction_rec=>l_interaction_rec,
964: p_activity_rec=>l_activity_rec ,

Line 974: l_logmessage:='After calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH media: status : '||l_stat || 'text : '|| l_out_text || 'l_media_id : ' ||l_media_id;

970:
971:
972:
973: if g_statement_log then
974: l_logmessage:='After calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH media: status : '||l_stat || 'text : '|| l_out_text || 'l_media_id : ' ||l_media_id;
975: iem_logger(l_logmessage);
976: end if;
977:
978: IF l_stat<>'S' THEN

Line 990: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH media';

986: l_media_rec.address := l_sender; --new on MP-R 07/23/03 by rtripath
987:
988:
989: if g_statement_log then
990: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH media';
991: iem_logger(l_logmessage);
992: end if;
993:
994:

Line 995: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

991: iem_logger(l_logmessage);
992: end if;
993:
994:
995: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
996: p_type=>'MEDIA' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
997: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
998: p_interaction_rec=>l_interaction_rec,
999: p_activity_rec=>l_activity_rec ,

Line 1009: l_logmessage:='After calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH media update: status : '||l_stat || 'text : '|| l_out_text || 'l_media_id : ' ||l_media_id;

1005:
1006:
1007:
1008: if g_statement_log then
1009: l_logmessage:='After calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH media update: status : '||l_stat || 'text : '|| l_out_text || 'l_media_id : ' ||l_media_id;
1010: iem_logger(l_logmessage);
1011: end if;
1012: IF l_stat<>'S' THEN
1013: l_logmessage:=l_out_text;

Line 1046: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add';

1042:
1043:
1044:
1045: if g_statement_log then
1046: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add';
1047: iem_logger(l_logmessage);
1048: end if;
1049:
1050: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1050: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1046: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add';
1047: iem_logger(l_logmessage);
1048: end if;
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 1063: l_logmessage:='After calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add :status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;

1059: x_out_text=>l_out_text );
1060:
1061:
1062: if g_statement_log then
1063: l_logmessage:='After calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add :status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;
1064: iem_logger(l_logmessage);
1065: end if;
1066:
1067: IF l_stat<>'S' THEN

Line 1075: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1071:
1072: -- Update the Media Life Cycle for Mail Preprocessing
1073: l_media_lc_rec.milcs_id:=l_milcs_id;
1074:
1075: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1076: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1077: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1078: p_interaction_rec=>l_interaction_rec,
1079: p_activity_rec=>l_activity_rec ,

Line 1088: l_logmessage:='After calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add :status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;

1084: x_out_text=>l_out_text );
1085:
1086:
1087: if g_statement_log then
1088: l_logmessage:='After calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add :status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;
1089: iem_logger(l_logmessage);
1090: end if;
1091:
1092: IF l_stat<>'S' THEN

Line 1106: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS update';

1102: l_media_lc_rec.type_type := 'Email, Inbound';
1103:
1104:
1105: if g_statement_log then
1106: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS update';
1107: iem_logger(l_logmessage);
1108: end if;
1109:
1110: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1110: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1106: l_logmessage:='Before calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS update';
1107: iem_logger(l_logmessage);
1108: end if;
1109:
1110: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1111: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1112: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1113: p_interaction_rec=>l_interaction_rec,
1114: p_activity_rec=>l_activity_rec ,

Line 1123: l_logmessage:='After calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS update :status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;

1119: x_out_text=>l_out_text );
1120:
1121:
1122: if g_statement_log then
1123: l_logmessage:='After calling update IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS update :status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;
1124: iem_logger(l_logmessage);
1125: end if;
1126:
1127: IF l_stat<>'S' THEN

Line 1141: l_logmessage:='Before calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add for 17';

1137: l_activity_rec.action_item_id := 45;-- EMAIL
1138:
1139:
1140: if g_statement_log then
1141: l_logmessage:='Before calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add for 17';
1142: iem_logger(l_logmessage);
1143: end if;
1144:
1145: IEM_EMAIl_PROC_PVT.IEM_PROC_IH(

Line 1145: IEM_EMAIl_PROC_PVT.IEM_PROC_IH(

1141: l_logmessage:='Before calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add for 17';
1142: iem_logger(l_logmessage);
1143: end if;
1144:
1145: IEM_EMAIl_PROC_PVT.IEM_PROC_IH(
1146: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1147: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1148: p_interaction_rec=>l_interaction_rec,
1149: p_activity_rec=>l_activity_rec ,

Line 1159: l_logmessage:='After calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add for 17:status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;

1155:
1156:
1157:
1158: if g_statement_log then
1159: l_logmessage:='After calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH MLCS add for 17:status : '||l_stat ||' text : '||l_out_text||' l_milcs_id :'||l_milcs_id;
1160: iem_logger(l_logmessage);
1161: end if;
1162:
1163: IF l_stat<>'S' THEN

Line 1195: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';

1191:
1192:
1193:
1194: if g_statement_log then
1195: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';
1196: iem_logger(l_logmessage);
1197: end if;
1198:
1199: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1199: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1195: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';
1196: iem_logger(l_logmessage);
1197: end if;
1198:
1199: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1200: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1201: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1202: p_interaction_rec=>l_interaction_rec,
1203: p_activity_rec=>l_activity_rec ,

Line 1212: l_logmessage:='After call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH status : '||l_stat ||' text : '||l_out_text||' l_activity_id : '||l_activity_id;

1208: x_out_text=>l_out_text );
1209:
1210:
1211: if g_statement_log then
1212: l_logmessage:='After call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH status : '||l_stat ||' text : '||l_out_text||' l_activity_id : '||l_activity_id;
1213: iem_logger(l_logmessage);
1214: end if;
1215: IF l_stat<>'S' THEN
1216: l_logmessage:=l_out_text;

Line 1224: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';

1220: l_media_lc_rec.milcs_id:=l_milcs_id;
1221:
1222:
1223: if g_statement_log then
1224: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';
1225: iem_logger(l_logmessage);
1226: end if;
1227:
1228: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1228: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1224: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';
1225: iem_logger(l_logmessage);
1226: end if;
1227:
1228: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1229: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1230: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1231: p_interaction_rec=>l_interaction_rec,
1232: p_activity_rec=>l_activity_rec ,

Line 1241: l_logmessage:='After call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH status : '||l_stat ||' text : '||l_out_text||' l_activity_id : '||l_activity_id;

1237: x_out_text=>l_out_text );
1238:
1239:
1240: if g_statement_log then
1241: l_logmessage:='After call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH status : '||l_stat ||' text : '||l_out_text||' l_activity_id : '||l_activity_id;
1242: iem_logger(l_logmessage);
1243: end if;
1244:
1245: IF l_stat<>'S' THEN

Line 1259: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';

1255: l_activity_rec.action_item_id := 45;-- EMAIL
1256:
1257:
1258: if g_statement_log then
1259: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';
1260: iem_logger(l_logmessage);
1261: end if;
1262:
1263: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1263: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1259: l_logmessage:='Before call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH';
1260: iem_logger(l_logmessage);
1261: end if;
1262:
1263: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1264: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1265: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1266: p_interaction_rec=>l_interaction_rec,
1267: p_activity_rec=>l_activity_rec ,

Line 1276: l_logmessage:='After call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH status : '||l_stat ||' text : '||l_out_text||' l_activity_id : '||l_activity_id;

1272: x_out_text=>l_out_text );
1273:
1274:
1275: if g_statement_log then
1276: l_logmessage:='After call to add activity IEM_EMAIl_PROC_PVT.IEM_PROC_IH status : '||l_stat ||' text : '||l_out_text||' l_activity_id : '||l_activity_id;
1277: iem_logger(l_logmessage);
1278: end if;
1279:
1280: IF l_stat<>'S' THEN

Line 1333: l_logmessage:='before call to IEM_EMAIL_PROC_PVT.IEM_WRAPUP';

1329:
1330: -- This wrapup procedure will close the interaction and media and Stamp the message as Deleted in Archived Table.
1331:
1332: if g_statement_log then
1333: l_logmessage:='before call to IEM_EMAIL_PROC_PVT.IEM_WRAPUP';
1334: iem_logger(l_logmessage);
1335: end if;
1336:
1337: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,

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

1333: l_logmessage:='before call to IEM_EMAIL_PROC_PVT.IEM_WRAPUP';
1334: iem_logger(l_logmessage);
1335: end if;
1336:
1337: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1338: p_media_id=>l_media_id ,
1339: p_milcs_id=>l_mp_milcs_id,
1340: p_action=>'D',
1341: p_email_rec =>l_post_rec,

Line 1347: l_logmessage:='After call to IEM_EMAIL_PROC_PVT.IEM_WRAPUP status : '||l_stat ||' text : '||l_out_text;

1343: x_out_text=>l_out_text,
1344: x_status=>l_stat );
1345:
1346: if g_statement_log then
1347: l_logmessage:='After call to IEM_EMAIL_PROC_PVT.IEM_WRAPUP status : '||l_stat ||' text : '||l_out_text;
1348: iem_logger(l_logmessage);
1349: end if;
1350:
1351: IF l_stat<>'S' THEN

Line 1479: l_logmessage:='Calling add activity IEM_EMAIL_PROC_PVT.IEM_PROC_IH for action id 65';

1475: l_activity_rec.action_item_id := 45;-- EMAIL
1476:
1477:
1478: if g_statement_log then
1479: l_logmessage:='Calling add activity IEM_EMAIL_PROC_PVT.IEM_PROC_IH for action id 65';
1480: iem_logger(l_logmessage);
1481: end if;
1482:
1483: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1483: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1479: l_logmessage:='Calling add activity IEM_EMAIL_PROC_PVT.IEM_PROC_IH for action id 65';
1480: iem_logger(l_logmessage);
1481: end if;
1482:
1483: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1484: p_type=>'ACTIVITY' , -- 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 1496: l_logmessage:='after Calling add activity IEM_EMAIL_PROC_PVT.IEM_PROC_IH for action id 65 status : '||l_stat||' text : '||l_out_text||' act id : '||l_activity_id;

1492: x_out_text=>l_out_text );
1493:
1494:
1495: if g_statement_log then
1496: l_logmessage:='after Calling add activity IEM_EMAIL_PROC_PVT.IEM_PROC_IH for action id 65 status : '||l_stat||' text : '||l_out_text||' act id : '||l_activity_id;
1497: iem_logger(l_logmessage);
1498: end if;
1499:
1500: IF l_stat<>'S' THEN

Line 1513: l_logmessage:='Calling add MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 ';

1509:
1510:
1511:
1512: if g_statement_log then
1513: l_logmessage:='Calling add MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 ';
1514: iem_logger(l_logmessage);
1515: end if;
1516: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1517: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION

Line 1516: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1512: if g_statement_log then
1513: l_logmessage:='Calling add MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 ';
1514: iem_logger(l_logmessage);
1515: end if;
1516: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1517: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1518: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1519: p_interaction_rec=>l_interaction_rec,
1520: p_activity_rec=>l_activity_rec ,

Line 1529: l_logmessage:='After add MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 staus : '||l_stat||' text : '||l_out_text||' l_milcs_id : '||l_milcs_id;

1525: x_out_text=>l_out_text );
1526:
1527:
1528: if g_statement_log then
1529: l_logmessage:='After add MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 staus : '||l_stat||' text : '||l_out_text||' l_milcs_id : '||l_milcs_id;
1530: iem_logger(l_logmessage);
1531: end if;
1532:
1533: IF l_stat<>'S' THEN

Line 1542: l_logmessage:='Calling update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 ';

1538: l_media_lc_rec.milcs_id:=l_milcs_id;
1539:
1540:
1541: if g_statement_log then
1542: l_logmessage:='Calling update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 ';
1543: iem_logger(l_logmessage);
1544: end if;
1545:
1546: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 1546: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1542: l_logmessage:='Calling update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 ';
1543: iem_logger(l_logmessage);
1544: end if;
1545:
1546: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1547: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1548: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
1549: p_interaction_rec=>l_interaction_rec,
1550: p_activity_rec=>l_activity_rec ,

Line 1560: l_logmessage:='After update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 staus : '||l_stat||' text : '||l_out_text||' l_milcs_id : '||l_milcs_id;

1556:
1557:
1558:
1559: if g_statement_log then
1560: l_logmessage:='After update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 staus : '||l_stat||' text : '||l_out_text||' l_milcs_id : '||l_milcs_id;
1561: iem_logger(l_logmessage);
1562: end if;
1563:
1564: IF l_stat<>'S' THEN

Line 1607: l_logmessage:='After update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 staus : '||l_stat||' text : '||l_out_text||' l_milcs_id : '||l_milcs_id;

1603: x_msg_data=>l_msg_data);
1604:
1605:
1606: if g_statement_log then
1607: l_logmessage:='After update MLCS IEM_EMAIL_PROC_PVT.IEM_PROC_IH for milcs id 31 staus : '||l_stat||' text : '||l_out_text||' l_milcs_id : '||l_milcs_id;
1608: iem_logger(l_logmessage);
1609: end if;
1610:
1611: IF l_ret_status<>'S' THEN

Line 1624: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1620: l_activity_rec.interaction_id := l_interaction_id;
1621: l_activity_rec.action_item_id := 45;-- EMAIL
1622: l_activity_rec.DOC_ID := l_sr_id;
1623: l_activity_rec.DOC_REF := 'SR';
1624: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1625: p_type=>'ACTIVITY', -- MEDIA/ACTIVITY/MLCS/INTERACTION
1626: p_action=>'ADD', -- ADD/UPDATE/CLOSE
1627: p_interaction_rec=>l_interaction_rec,
1628: p_activity_rec=>l_activity_rec,

Line 1646: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP after update mlcs 31';

1642:
1643:
1644:
1645: if g_statement_log then
1646: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP after update mlcs 31';
1647: iem_logger(l_logmessage);
1648: end if;
1649: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1650: p_media_id=>l_media_id ,

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

1645: if g_statement_log then
1646: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP after update mlcs 31';
1647: iem_logger(l_logmessage);
1648: end if;
1649: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
1650: p_media_id=>l_media_id ,
1651: p_milcs_id=>l_mp_milcs_id,
1652: p_action=>'R',
1653: p_email_rec =>l_post_rec,

Line 1660: l_logmessage:='End of IEM_EMAIL_PROC_PVT.IEM_WRAPUP after update mlcs 31 status : '||l_stat ||' data: '||l_out_text;

1656: x_status=>l_stat );
1657:
1658:
1659: if g_statement_log then
1660: l_logmessage:='End of IEM_EMAIL_PROC_PVT.IEM_WRAPUP after update mlcs 31 status : '||l_stat ||' data: '||l_out_text;
1661: iem_logger(l_logmessage);
1662: end if;
1663:
1664: IF l_stat='E' THEN

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

1695: if g_statement_log then
1696: l_logmessage:='before call to Getting mergeval status';
1697: iem_logger(l_logmessage);
1698: end if;
1699: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>l_post_rec.email_account_id ,
1700: p_mailer =>l_header_rec.from_str,
1701: p_dflt_sender=>l_sender ,
1702: p_subject=>l_header_rec.subject,
1703: x_qual_tbl=> l_qual_tbl,

Line 1983: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto update sr';

1979:
1980:
1981:
1982: if g_statement_log then
1983: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto update sr';
1984: iem_logger(l_logmessage);
1985: end if;
1986: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1987: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION

Line 1986: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

1982: if g_statement_log then
1983: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto update sr';
1984: iem_logger(l_logmessage);
1985: end if;
1986: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
1987: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
1988: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
1989: p_interaction_rec=>l_interaction_rec,
1990: p_activity_rec=>l_activity_rec ,

Line 1999: l_logmessage:='after IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto update sr : status : '||l_stat||' text :'||l_out_text||' act id : '||l_activity_id;

1995: x_out_text=>l_out_text );
1996:
1997:
1998: if g_statement_log then
1999: l_logmessage:='after IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto update sr : status : '||l_stat||' text :'||l_out_text||' act id : '||l_activity_id;
2000: iem_logger(l_logmessage);
2001: end if;
2002:
2003: IF l_stat<>'S' THEN

Line 2064: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2060: if g_statement_log then
2061: l_logmessage:='update interaction for auto update sr';
2062: iem_logger(l_logmessage);
2063: end if;
2064: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2065: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2066: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2067: p_interaction_rec=>l_interaction_rec,
2068: p_activity_rec=>l_activity_rec ,

Line 2076: l_logmessage:='END IEM_EMAIL_PROC_PVT.IEM_PROC_IH update interaction for auto update sr : status : '||l_stat||' text :'||l_out_text|| ' inter id : '||l_id;

2072: x_status=>l_stat ,
2073: x_out_text=>l_out_text );
2074:
2075: if g_statement_log then
2076: l_logmessage:='END IEM_EMAIL_PROC_PVT.IEM_PROC_IH update interaction for auto update sr : status : '||l_stat||' text :'||l_out_text|| ' inter id : '||l_id;
2077: iem_logger(l_logmessage);
2078: end if;
2079:
2080:

Line 2097: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR email resolved 65';

2093: l_activity_rec.DOC_REF := 'SR';
2094:
2095:
2096: if g_statement_log then
2097: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR email resolved 65';
2098: iem_logger(l_logmessage);
2099: end if;
2100:
2101: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 2101: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2097: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR email resolved 65';
2098: iem_logger(l_logmessage);
2099: end if;
2100:
2101: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2102: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2103: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2104: p_interaction_rec=>l_interaction_rec,
2105: p_activity_rec=>l_activity_rec ,

Line 2113: l_logmessage:='After IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR email resolved 65 status : '||l_stat ||'text : '||l_out_text|| 'activity id : '||l_activity_id;

2109: x_status=>l_stat ,
2110: x_out_text=>l_out_text );
2111:
2112: if g_statement_log then
2113: l_logmessage:='After IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR email resolved 65 status : '||l_stat ||'text : '||l_out_text|| 'activity id : '||l_activity_id;
2114: iem_logger(l_logmessage);
2115: end if;
2116:
2117: IF l_stat<>'S' THEN

Line 2143: l_logmessage:='CAlling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR';

2139: from cs_incidents_all_b where incident_id=l_sr_id;
2140:
2141:
2142: if g_statement_log then
2143: l_logmessage:='CAlling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR';
2144: iem_logger(l_logmessage);
2145: end if;
2146: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2147: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION

Line 2146: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2142: if g_statement_log then
2143: l_logmessage:='CAlling IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR';
2144: iem_logger(l_logmessage);
2145: end if;
2146: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2147: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2148: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2149: p_interaction_rec=>l_interaction_rec,
2150: p_activity_rec=>l_activity_rec ,

Line 2158: l_logmessage:='After IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR e status : '||l_stat ||'text : '||l_out_text|| 'activity id : '||l_activity_id ;

2154: x_status=>l_stat ,
2155: x_out_text=>l_out_text );
2156:
2157: if g_statement_log then
2158: l_logmessage:='After IEM_EMAIL_PROC_PVT.IEM_PROC_IH add activity for auto create SR e status : '||l_stat ||'text : '||l_out_text|| 'activity id : '||l_activity_id ;
2159: iem_logger(l_logmessage);
2160: end if;
2161:
2162: IF l_stat<>'S' THEN

Line 2169: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2165: END IF;
2166: -- Update the mail Processing Life Cycles
2167: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
2168: l_media_lc_rec.milcs_type_id:=17;
2169: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2170: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2171: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2172: p_interaction_rec=>l_interaction_rec,
2173: p_activity_rec=>l_activity_rec ,

Line 2197: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2193: and aa.default_wrap_id = wu.wrap_id;
2194: l_interaction_rec.interaction_id:=l_interaction_id;
2195: select contact_party_id into l_cust_contact_id from jtf_ih_interactions
2196: where interaction_id=l_interaction_id;
2197: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2198: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2199: p_action=>'CLOSE' , -- ADD/UPDATE/CLOSE
2200: p_interaction_rec=>l_interaction_rec,
2201: p_activity_rec=>l_activity_rec ,

Line 2215: l_logmessage:='calling iem_email_proc_pvt.IEM_AUTOREPLY for auot update sr';

2211: END IF;
2212:
2213:
2214: if g_statement_log then
2215: l_logmessage:='calling iem_email_proc_pvt.IEM_AUTOREPLY for auot update sr';
2216: iem_logger(l_logmessage);
2217: end if;
2218: IEM_AUTOREPLY(p_interaction_id=>l_interaction_id ,
2219: p_media_id=>l_media_id,

Line 2235: l_logmessage:='END iem_email_proc_pvt.IEM_AUTOREPLY for auot update sr : status : '||l_stat ||' data : '||l_out_text;

2231: x_status=>l_stat ) ;
2232:
2233:
2234: if g_statement_log then
2235: l_logmessage:='END iem_email_proc_pvt.IEM_AUTOREPLY for auot update sr : status : '||l_stat ||' data : '||l_out_text;
2236: iem_logger(l_logmessage);
2237: end if;
2238:
2239: IF l_stat<>'S' THEN

Line 2249: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP for resolve on auto update sr';

2245: -- Resolving the message without sending notifications
2246:
2247:
2248: if g_statement_log then
2249: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP for resolve on auto update sr';
2250: iem_logger(l_logmessage);
2251: end if;
2252: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
2253: p_media_id=>l_media_id ,

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

2248: if g_statement_log then
2249: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP for resolve on auto update sr';
2250: iem_logger(l_logmessage);
2251: end if;
2252: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
2253: p_media_id=>l_media_id ,
2254: p_milcs_id=>l_mp_milcs_id,
2255: p_action=>'R',
2256: p_email_rec =>l_post_rec,

Line 2262: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP for resolve on auto update sr status : '||l_stat||' data :'||l_out_text;

2258: x_out_text=>l_out_text,
2259: x_status=>l_stat );
2260:
2261: if g_statement_log then
2262: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP for resolve on auto update sr status : '||l_stat||' data :'||l_out_text;
2263: iem_logger(l_logmessage);
2264: end if;
2265: IF l_stat<>'S' THEN
2266: l_logmessage:=l_out_text;

Line 2292: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE for auto update sr';

2288: ELSE
2289:
2290:
2291: if g_statement_log then
2292: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE for auto update sr';
2293: iem_logger(l_logmessage);
2294: end if;
2295:
2296: IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE(p_sr_id=>l_sr_id ,

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

2292: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE for auto update sr';
2293: iem_logger(l_logmessage);
2294: end if;
2295:
2296: IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE(p_sr_id=>l_sr_id ,
2297: p_status_id=>l_status_id,
2298: p_email_rec=>l_post_rec,
2299: x_status =>l_stat,
2300: x_out_text=>l_out_text) ;

Line 2303: l_logmessage:='after IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE for auto update l_out_textsr : status : '||l_stat||' text : '||l_out_text;

2299: x_status =>l_stat,
2300: x_out_text=>l_out_text) ;
2301:
2302: if g_statement_log then
2303: l_logmessage:='after IEM_EMAIL_PROC_PVT.IEM_SRSTATUS_UPDATE for auto update l_out_textsr : status : '||l_stat||' text : '||l_out_text;
2304: iem_logger(l_logmessage);
2305: end if;
2306: end if;
2307: IF l_stat='S' then

Line 2316: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2312: l_activity_rec.interaction_id := l_interaction_id;
2313: l_activity_rec.action_item_id := 45;-- EMAIL
2314: l_activity_rec.DOC_ID := l_sr_id;
2315: l_activity_rec.DOC_REF := 'SR';
2316: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2317: p_type=>'ACTIVITY' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2318: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2319: p_interaction_rec=>l_interaction_rec,
2320: p_activity_rec=>l_activity_rec ,

Line 2340: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for auto ack';

2336: l_media_lc_rec.handler_id := 680;
2337:
2338:
2339: if g_statement_log then
2340: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for auto ack';
2341: iem_logger(l_logmessage);
2342: end if;
2343:
2344: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 2344: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2340: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for auto ack';
2341: iem_logger(l_logmessage);
2342: end if;
2343:
2344: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2345: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2346: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2347: p_interaction_rec=>l_interaction_rec,
2348: p_activity_rec=>l_activity_rec ,

Line 2356: l_logmessage:='END IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for auto ack : status : '||l_stat||' txt : '||l_out_text||' mlcs id : '||l_milcs_id;

2352: x_status=>l_stat ,
2353: x_out_text=>l_out_text );
2354:
2355: if g_statement_log then
2356: l_logmessage:='END IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for auto ack : status : '||l_stat||' txt : '||l_out_text||' mlcs id : '||l_milcs_id;
2357: iem_logger(l_logmessage);
2358: end if;
2359:
2360: IF l_stat<>'S' THEN

Line 2366: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2362: raise ABORT_PROCESSING;
2363: END IF;
2364: -- Update the Media Life Cycle for Auto Update of SR
2365: l_media_lc_rec.milcs_id:=l_id;
2366: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2367: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2368: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2369: p_interaction_rec=>l_interaction_rec,
2370: p_activity_rec=>l_activity_rec ,

Line 2425: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2421: where aa.action_id =75
2422: and aa.action_item_id =45
2423: and aa.default_wrap_id = wu.wrap_id;
2424: l_interaction_rec.interaction_id:=l_interaction_id;
2425: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2426: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2427: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2428: p_interaction_rec=>l_interaction_rec,
2429: p_activity_rec=>l_activity_rec ,

Line 2474: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2470: l_autoack_flag:='N';
2471: -- Update the mail Processing Life Cycles
2472: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
2473: l_media_lc_rec.milcs_type_id:=17;
2474: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2475: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2476: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2477: p_interaction_rec=>l_interaction_rec,
2478: p_activity_rec=>l_activity_rec ,

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

2486: l_logmessage:=l_out_text;
2487: raise ABORT_PROCESSING;
2488: END IF;
2489: else -- notification flag is not set so resolve the message
2490: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
2491: p_media_id=>l_media_id ,
2492: p_milcs_id=>l_mp_milcs_id,
2493: p_action=>'R',
2494: p_email_rec =>l_post_rec,

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

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,
2535: p_domain_name=>l_email_domain_name,

Line 2554: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2550: l_logmessage:='Error In Autoack '||l_out_text;
2551: iem_logger(l_logmessage);
2552: end if;
2553: ELSE
2554: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2555: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2556: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2557: p_interaction_rec=>l_interaction_rec,
2558: p_activity_rec=>l_activity_rec ,

Line 2566: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2562: x_status=>l_stat ,
2563: x_out_text=>l_out_text );
2564:
2565: l_media_lc_rec.milcs_id:=l_milcs_id;
2566: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2567: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2568: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2569: p_interaction_rec=>l_interaction_rec,
2570: p_activity_rec=>l_activity_rec ,

Line 2621: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2617: l_media_lc_rec.media_id :=l_media_id ;
2618: l_media_lc_rec.start_date_time := sysdate;
2619: l_media_lc_rec.handler_id := 680;
2620: -- Create MLCS for Auto-Redirect
2621: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2622: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2623: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
2624: p_interaction_rec=>l_interaction_rec,
2625: p_activity_rec=>l_activity_rec ,

Line 2637: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

2633: raise ABORT_PROCESSING;
2634: END IF;
2635: -- Update the Media Life Cycle for Auto RRRR
2636: l_media_lc_rec.milcs_id:=l_milcs_id;
2637: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
2638: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
2639: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
2640: p_interaction_rec=>l_interaction_rec,
2641: p_activity_rec=>l_activity_rec ,

Line 2730: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP inside action = autoredirect internal';

2726:
2727:
2728:
2729: if g_statement_log then
2730: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP inside action = autoredirect internal';
2731: iem_logger(l_logmessage);
2732: end if;
2733: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
2734: p_media_id=>l_media_id ,

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

2729: if g_statement_log then
2730: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_WRAPUP inside action = autoredirect internal';
2731: iem_logger(l_logmessage);
2732: end if;
2733: IEM_EMAIL_PROC_PVT.IEM_WRAPUP(p_interaction_id=>l_interaction_id,
2734: p_media_id=>l_media_id ,
2735: p_milcs_id=>l_mp_milcs_id,
2736: p_action=>null,
2737: p_email_rec =>l_post_rec,

Line 2744: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_WRAPUP inside action = autoredirect internal status : '||l_stat||' text : '||l_out_text;

2740: x_status=>l_stat );
2741:
2742:
2743: if g_statement_log then
2744: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_WRAPUP inside action = autoredirect internal status : '||l_stat||' text : '||l_out_text;
2745: iem_logger(l_logmessage);
2746: end if;
2747:
2748: IF l_stat<>'S' THEN

Line 2805: l_logmessage:='calling iem_email_proc_pvt.IEM_AUTOREPLY inside if';

2801: end if;
2802:
2803:
2804: if g_statement_log then
2805: l_logmessage:='calling iem_email_proc_pvt.IEM_AUTOREPLY inside if';
2806: iem_logger(l_logmessage);
2807: end if;
2808: IEM_AUTOREPLY(p_interaction_id=>l_interaction_id ,
2809: p_media_id=>l_media_id,

Line 2825: l_logmessage:='end iem_email_proc_pvt.IEM_AUTOREPLY inside if : status : '||l_stat||' text : '||l_out_text;

2821: x_status=>l_stat ) ;
2822:
2823:
2824: if g_statement_log then
2825: l_logmessage:='end iem_email_proc_pvt.IEM_AUTOREPLY inside if : status : '||l_stat||' text : '||l_out_text;
2826: iem_logger(l_logmessage);
2827: end if;
2828:
2829: IF l_stat='S' THEN

Line 2908: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC';

2904: -- CALLING ROUTING ----
2905:
2906:
2907: if g_statement_log then
2908: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC';
2909: iem_logger(l_logmessage);
2910: end if;
2911:
2912: IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC(

Line 2912: IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC(

2908: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC';
2909: iem_logger(l_logmessage);
2910: end if;
2911:
2912: IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC(
2913: p_email_account_id=>l_post_rec.email_account_id,
2914: p_keyval=>l_class_val_tbl,
2915: x_routing_group_id=>l_group_id,
2916: x_status=>l_status,

Line 2921: l_logmessage:='end of IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC : status : '||l_status||' txt : '||l_out_text;

2917: x_out_text=>l_out_text) ;
2918:
2919:
2920: if g_statement_log then
2921: l_logmessage:='end of IEM_EMAIL_PROC_PVT.IEM_ROUTING_PROC : status : '||l_status||' txt : '||l_out_text;
2922: iem_logger(l_logmessage);
2923: end if;
2924:
2925:

Line 3033: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS for email inbound auto route ';

3029: -- IH activity;
3030:
3031:
3032: if g_statement_log then
3033: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS for email inbound auto route ';
3034: iem_logger(l_logmessage);
3035: end if;
3036: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3037: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION

Line 3036: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3032: if g_statement_log then
3033: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS for email inbound auto route ';
3034: iem_logger(l_logmessage);
3035: end if;
3036: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3037: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3038: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
3039: p_interaction_rec=>l_interaction_rec,
3040: p_activity_rec=>l_activity_rec ,

Line 3049: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS for email inbound auto route status : '||l_stat||' text : '||l_out_text||' id : '||l_milcs_id;

3045: x_out_text=>l_out_text );
3046:
3047:
3048: if g_statement_log then
3049: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS for email inbound auto route status : '||l_stat||' text : '||l_out_text||' id : '||l_milcs_id;
3050: iem_logger(l_logmessage);
3051: end if;
3052: IF l_stat<>'S' THEN
3053: if g_error_log then

Line 3067: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for email inbound auto route ';

3063:
3064:
3065:
3066: if g_statement_log then
3067: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for email inbound auto route ';
3068: iem_logger(l_logmessage);
3069: end if;
3070: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3071: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION

Line 3070: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3066: if g_statement_log then
3067: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for email inbound auto route ';
3068: iem_logger(l_logmessage);
3069: end if;
3070: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3071: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3072: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
3073: p_interaction_rec=>l_interaction_rec,
3074: p_activity_rec=>l_activity_rec ,

Line 3083: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for email inbound auto route status : '||l_stat||' text : '||l_out_text||' id : '||l_milcs_id;

3079: x_out_text=>l_out_text );
3080:
3081:
3082: if g_statement_log then
3083: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS for email inbound auto route status : '||l_stat||' text : '||l_out_text||' id : '||l_milcs_id;
3084: iem_logger(l_logmessage);
3085: end if;
3086:
3087: IF l_stat<>'S' THEN

Line 3150: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS after JTF call ';

3146: l_media_lc_rec.milcs_type_id := 17;
3147:
3148:
3149: if g_statement_log then
3150: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS after JTF call ';
3151: iem_logger(l_logmessage);
3152: end if;
3153:
3154: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 3154: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3150: l_logmessage:='calling IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS after JTF call ';
3151: iem_logger(l_logmessage);
3152: end if;
3153:
3154: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3155: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3156: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
3157: p_interaction_rec=>l_interaction_rec,
3158: p_activity_rec=>l_activity_rec ,

Line 3167: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS after JTF call : status : '||l_stat||' txt : '||l_out_text||' id : '||l_milcs_id;

3163: x_out_text=>l_out_text );
3164:
3165:
3166: if g_statement_log then
3167: l_logmessage:='end IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS after JTF call : status : '||l_stat||' txt : '||l_out_text||' id : '||l_milcs_id;
3168: iem_logger(l_logmessage);
3169: end if;
3170:
3171: IF l_stat<>'S' THEN

Line 3186: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(

3182: BEGIN
3183: IF l_search_type<>'CM' THEN -- Not a MES category based mapping
3184: l_start_search:=1;
3185: FOR v1 in c_class_id LOOP
3186: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
3187: l_post_rec.message_id ,
3188: l_post_rec.email_account_id ,
3189: v1.classification_id,
3190: l_category_id,

Line 3256: l_logmessage:=' Calling iem_email_proc_pvt.IEM_PROC_IH update MLCS in STOP_AUTO_PROCESS';

3252: l_media_lc_rec.milcs_id:=l_mp_milcs_id;
3253: l_media_lc_rec.milcs_type_id := 17;
3254:
3255: if g_statement_log then
3256: l_logmessage:=' Calling iem_email_proc_pvt.IEM_PROC_IH update MLCS in STOP_AUTO_PROCESS';
3257: iem_logger(l_logmessage);
3258: end if;
3259: iem_email_proc_pvt.IEM_PROC_IH(
3260: p_type=>'MLCS' ,-- MEDIA/ACTIVITY/MLCS/INTERACTION

Line 3259: iem_email_proc_pvt.IEM_PROC_IH(

3255: if g_statement_log then
3256: l_logmessage:=' Calling iem_email_proc_pvt.IEM_PROC_IH update MLCS in STOP_AUTO_PROCESS';
3257: iem_logger(l_logmessage);
3258: end if;
3259: iem_email_proc_pvt.IEM_PROC_IH(
3260: p_type=>'MLCS' ,-- MEDIA/ACTIVITY/MLCS/INTERACTION
3261: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
3262: p_interaction_rec=>l_interaction_rec,
3263: p_activity_rec=>l_activity_rec ,

Line 3271: l_logmessage:=' End iem_email_proc_pvt.IEM_PROC_IH update MLCS in STOP_AUTO_PROCESS :status : '||l_stat||' txt :'||l_out_text||' id : '||l_milcs_id;

3267: x_status=>l_stat ,
3268: x_out_text=>l_out_text );
3269:
3270: if g_statement_log then
3271: l_logmessage:=' End iem_email_proc_pvt.IEM_PROC_IH update MLCS in STOP_AUTO_PROCESS :status : '||l_stat||' txt :'||l_out_text||' id : '||l_milcs_id;
3272: iem_logger(l_logmessage);
3273: end if;
3274:
3275: IF l_stat<>'S' THEN

Line 3364: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_AUTOACK in SSTOP_PROCESSING';

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';
3365: iem_logger(l_logmessage);
3366: end if;
3367:
3368: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,

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

3364: l_logmessage:='Calling IEM_EMAIL_PROC_PVT.IEM_AUTOACK in SSTOP_PROCESSING';
3365: iem_logger(l_logmessage);
3366: end if;
3367:
3368: IEM_EMAIL_PROC_PVT.IEM_AUTOACK(p_email_user=>l_email_user_name,
3369: p_mailer =>l_header_rec.from_str,
3370: p_sender=>l_sender,
3371: p_subject=>l_header_rec.subject,
3372: p_domain_name=>l_email_domain_name,

Line 3381: l_logmessage:='End IEM_EMAIL_PROC_PVT.IEM_AUTOACK in SSTOP_PROCESSING status : '||l_status||' txt :'||l_out_text;

3377: x_status=>l_status,
3378: x_out_text=>l_out_text);
3379:
3380: if g_statement_log then
3381: l_logmessage:='End IEM_EMAIL_PROC_PVT.IEM_AUTOACK in SSTOP_PROCESSING status : '||l_status||' txt :'||l_out_text;
3382: iem_logger(l_logmessage);
3383: end if;
3384: l_media_lc_rec.media_id :=l_media_id ;
3385: l_media_lc_rec.milcs_type_id := 29; --MAIL_AUTOACKNOWLEDGED

Line 3399: l_logmessage:='call to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing';

3395: ELSE
3396:
3397:
3398: if g_statement_log then
3399: l_logmessage:='call to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing';
3400: iem_logger(l_logmessage);
3401: end IF;
3402:
3403: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 3403: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3399: l_logmessage:='call to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing';
3400: iem_logger(l_logmessage);
3401: end IF;
3402:
3403: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3404: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3405: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
3406: p_interaction_rec=>l_interaction_rec,
3407: p_activity_rec=>l_activity_rec ,

Line 3415: l_logmessage:='end to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing status : '||l_stat||' txt :'||l_out_text||' id :'||l_milcs_id;

3411: x_status=>l_stat ,
3412: x_out_text=>l_out_text );
3413:
3414: if g_statement_log then
3415: l_logmessage:='end to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing status : '||l_stat||' txt :'||l_out_text||' id :'||l_milcs_id;
3416: iem_logger(l_logmessage);
3417: end IF;
3418:
3419:

Line 3424: l_logmessage:='call to IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS in else statement of stop_processing';

3420: l_media_lc_rec.milcs_id:=l_milcs_id;
3421:
3422:
3423: if g_statement_log then
3424: l_logmessage:='call to IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS in else statement of stop_processing';
3425: iem_logger(l_logmessage);
3426: end IF;
3427:
3428: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

Line 3428: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

3424: l_logmessage:='call to IEM_EMAIL_PROC_PVT.IEM_PROC_IH update MLCS in else statement of stop_processing';
3425: iem_logger(l_logmessage);
3426: end IF;
3427:
3428: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
3429: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
3430: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
3431: p_interaction_rec=>l_interaction_rec,
3432: p_activity_rec=>l_activity_rec ,

Line 3440: l_logmessage:='end to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing status : '||l_stat||' txt :'||l_out_text;

3436: x_status=>l_stat ,
3437: x_out_text=>l_out_text );
3438:
3439: if g_statement_log then
3440: l_logmessage:='end to IEM_EMAIL_PROC_PVT.IEM_PROC_IH ADD MLCS in else statement of stop_processing status : '||l_stat||' txt :'||l_out_text;
3441: iem_logger(l_logmessage);
3442: end IF;
3443: END IF; -- End of MLCS Creation
3444: END IF; -- End if for if l_autoack_flag='Y';

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

3532: PROCEDURE iem_logger(l_logmessage in varchar2) IS
3533: begin
3534: if g_statement_log THEN
3535: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3536: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3537: end if;
3538: end if;
3539: if g_exception_log then
3540: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

3537: end if;
3538: end if;
3539: if g_exception_log then
3540: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3541: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3542: end if;
3543: end if;
3544: if g_error_log then
3545: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

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

3542: end if;
3543: end if;
3544: if g_error_log then
3545: if( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
3546: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'IEM.PLSQL.IEM_EMAIL_PROC_PVT',l_logmessage);
3547: end if;
3548: end if;
3549: end iem_logger;
3550:

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

3606: l_subject varchar2(500);
3607: l_msg_index_out number;
3608: BEGIN
3609: x_status:='S';
3610: IEM_EMAIL_PROC_PVT.IEM_GET_MERGEVAL(p_email_account_id=>p_master_account_id ,
3611: p_mailer=>p_mailer,
3612: p_dflt_sender=>p_dflt_sender ,
3613: p_subject=>p_subject,
3614: x_qual_tbl=> l_qual_tbl,

Line 3771: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(

3767: where message_id=p_message_id
3768: and score = (select max(score) from iem_email_classifications
3769: where message_id=p_message_id)
3770: and rownum=1;
3771: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
3772: p_message_id ,
3773: p_email_account_id ,
3774: l_class,
3775: l_category_id,

Line 4248: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

4244: l_msg_count number;
4245: begin
4246: -- Update the mail Processing Life Cycles
4247: l_media_lc_rec.milcs_id:=p_milcs_id;
4248: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
4249: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
4250: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
4251: p_interaction_rec=>l_interaction_rec,
4252: p_activity_rec=>l_activity_rec ,

Line 4278: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

4274: and aa.default_wrap_id = wu.wrap_id;
4275: EXCEPTION WHEN OTHERS THEN
4276: null;
4277: END;
4278: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
4279: p_type=>'INTERACTION' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
4280: p_action=>'CLOSE' , -- ADD/UPDATE/CLOSE
4281: p_interaction_rec=>l_interaction_rec,
4282: p_activity_rec=>l_activity_rec ,

Line 4294: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(

4290: raise WRAPUP_ERROR;
4291: END IF;
4292: --Closing the media Item
4293: l_media_rec.media_id:=p_media_id;
4294: IEM_EMAIL_PROC_PVT.IEM_PROC_IH(
4295: p_type=>'MEDIA' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
4296: p_action=>'CLOSE' , -- ADD/UPDATE/CLOSE
4297: p_interaction_rec=>l_interaction_rec,
4298: p_activity_rec=>l_activity_rec ,

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

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
4520: x_qual_tbl=> l_qual_tbl,

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

4966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4967: END IF;
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

Line 5221: iem_email_proc_pvt.IEM_ROUTING_PROC(

5217: l_search_type:=null;
5218: l_cm_Cat_id:=0;
5219: end if ; -- end if for l_autoproc_result='T'
5220: -- CALLING ROUTING ----
5221: iem_email_proc_pvt.IEM_ROUTING_PROC(
5222: p_email_account_id=>l_mail_rec.email_account_id,
5223: p_keyval=>l_class_val_tbl,
5224: x_routing_group_id=>l_group_id,
5225: x_status=>l_status,

Line 5283: iem_email_proc_pvt.IEM_PROC_IH(

5279: l_media_lc_rec.handler_id := 680;
5280: l_media_lc_rec.type_type := 'Email, Inbound';
5281: l_media_lc_rec.resource_id := l_agentid;
5282:
5283: iem_email_proc_pvt.IEM_PROC_IH(
5284: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
5285: p_action=>'ADD' , -- ADD/UPDATE/CLOSE
5286: p_interaction_rec=>l_interaction_rec,
5287: p_activity_rec=>l_activity_rec ,

Line 5302: iem_email_proc_pvt.IEM_PROC_IH(

5298: rollback to auto_route;
5299: ELSE
5300: -- Update the Media Life Cycle for Auto Routing
5301: l_media_lc_rec.milcs_id:=l_milcs_id;
5302: iem_email_proc_pvt.IEM_PROC_IH(
5303: p_type=>'MLCS' , -- MEDIA/ACTIVITY/MLCS/INTERACTION
5304: p_action=>'UPDATE' , -- ADD/UPDATE/CLOSE
5305: p_interaction_rec=>l_interaction_rec,
5306: p_activity_rec=>l_activity_rec ,

Line 5360: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(

5356: BEGIN
5357: IF l_search_type<>'CM' THEN -- Not a MES category based mapping
5358: l_start_search:=1;
5359: FOR v1 in c_class_id LOOP
5360: IEM_EMAIL_PROC_PVT.IEM_WF_SPECIFICSEARCH(
5361: l_mail_rec.message_id ,
5362: l_mail_rec.email_account_id ,
5363: v1.classification_id,
5364: l_category_id,

Line 9223: end IEM_EMAIL_PROC_PVT;

9219:
9220:
9221: --siahmed end of 12.1.3 advanced sr processing
9222:
9223: end IEM_EMAIL_PROC_PVT;