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_OUTBOX_PROC_PUB

Line 117: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

113: l_rt_media_item_id number;
114: l_rt_interaction_id number;
115: l_email_doc_tbl email_doc_tbl;
116: l_resource_id number;
117: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
118: l_outbox_tbl IEM_OUTBOX_PROC_PUB.keyVals_tbl_type;
119: l_auto_reply_flag varchar2(1):='N';
120: l_auto_forward_flag varchar2(1);
121: l_action_id number;

Line 118: l_outbox_tbl IEM_OUTBOX_PROC_PUB.keyVals_tbl_type;

114: l_rt_interaction_id number;
115: l_email_doc_tbl email_doc_tbl;
116: l_resource_id number;
117: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
118: l_outbox_tbl IEM_OUTBOX_PROC_PUB.keyVals_tbl_type;
119: l_auto_reply_flag varchar2(1):='N';
120: l_auto_forward_flag varchar2(1);
121: l_action_id number;
122: l_outbox_item_id number;

Line 2503: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

2499: l_text_data varchar2(500);
2500: l_reply_address varchar2(500);
2501: l_resource_id number;
2502: l_email_account_id number;
2503: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
2504: ACK_FAILED EXCEPTION;
2505: l_ret_status varchar2(10);
2506: l_msg_count number;
2507: l_msg_data varchar2(500);

Line 2539: IEM_OUTBOX_PROC_PUB.createOutboxMessage(p_api_version_number=>1.0,

2535: END;
2536: -- Calling OP Api for sending Out Auto Acknowledgement
2537:
2538: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;
2539: IEM_OUTBOX_PROC_PUB.createOutboxMessage(p_api_version_number=>1.0,
2540: p_init_msg_list=>'F',
2541: p_commit=>'F',
2542: P_RESOURCE_ID=>l_resource_id,
2543: p_application_id=>680,

Line 2568: IEM_OUTBOX_PROC_PUB.insertDocument(

2564: if l_ret_status<>'S' THEN
2565: x_out_text:='Failed in createoutbox message '||l_text_data;
2566: raise ACK_FAILED;
2567: end if;
2568: IEM_OUTBOX_PROC_PUB.insertDocument(
2569: p_api_version_number=>1.0 ,
2570: p_outbox_item_id=>l_outbox_id,
2571: p_document_source=>'MES' ,
2572: p_document_id =>p_document_id ,

Line 2580: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(

2576: if l_ret_status<>'S' THEN
2577: x_out_text:='Failed in insert document '||l_text_data;
2578: raise ACK_FAILED;
2579: end if;
2580: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(
2581: p_api_version_number=>1.0 ,
2582: p_init_msg_list=>'F',
2583: p_commit => 'F',
2584: p_outbox_item_id=>l_outbox_id ,

Line 3241: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,

3237: p_media_id in number,
3238: p_post_rec in iem_rt_preproc_emails%rowtype,
3239: p_doc_tbl in email_doc_tbl,
3240: p_subject in varchar2,
3241: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,
3242: P_CUSTOMER_ID in number,
3243: P_RESOURCE_ID in number,
3244: p_qualifiers in IEM_OUTBOX_PROC_PUB.QualifierRecordList,
3245: p_fwd_address in varchar2,

Line 3244: p_qualifiers in IEM_OUTBOX_PROC_PUB.QualifierRecordList,

3240: p_subject in varchar2,
3241: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,
3242: P_CUSTOMER_ID in number,
3243: P_RESOURCE_ID in number,
3244: p_qualifiers in IEM_OUTBOX_PROC_PUB.QualifierRecordList,
3245: p_fwd_address in varchar2,
3246: p_fwd_doc_id in number,
3247: p_req_type in varchar2,
3248: x_out_text out NOCOPY varchar2,

Line 3260: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

3256: l_file_name varchar2(256);
3257: l_ext_subject varchar2(100);
3258: l_data varchar2(500);
3259: l_msg_index_out varchar2(10);
3260: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
3261: l_error_text varchar2(1000);
3262: l_dflt_sender varchar2(250);
3263: l_sender varchar2(256);
3264: l_from1 number;

Line 3279: IEM_OUTBOX_PROC_PUB.createautoreply(p_api_version_number=>1.0,

3275: ELSE -- From Address contains only Address
3276: l_sender:=l_header_rec.from_str;
3277: END IF;
3278: if p_req_type='R' then -- Autoreply
3279: IEM_OUTBOX_PROC_PUB.createautoreply(p_api_version_number=>1.0,
3280: p_init_msg_list=>'F',
3281: p_commit=>'F',
3282: P_MEDIA_ID=>p_media_id, --- Then next 3 parameter will be null
3283: P_RFC822_MESSAGE_ID =>null,

Line 3309: IEM_OUTBOX_PROC_PUB.insertDocument(

3305: raise AUTOREPLY_ERROR;
3306: END IF;
3307: FOR i IN p_doc_tbl.FIRST..p_doc_tbl.LAST LOOP
3308: IF p_doc_tbl(i).type='I' THEN
3309: IEM_OUTBOX_PROC_PUB.insertDocument(
3310: p_api_version_number=>1.0 ,
3311: p_outbox_item_id=>l_outbox_id,
3312: p_document_source=>'MES' ,
3313: p_document_id =>p_doc_tbl(i).doc_id ,

Line 3334: IEM_OUTBOX_PROC_PUB.attachDocument(p_api_version_number=>1.0,

3330: AND b.item_id=p_doc_tbl(i).doc_id
3331: AND b.language=USERENV('LANG')
3332: and rownum=1;
3333:
3334: IEM_OUTBOX_PROC_PUB.attachDocument(p_api_version_number=>1.0,
3335: p_init_msg_list=>FND_API.G_FALSE,
3336: p_commit=>FND_API.G_TRUE,
3337: p_outbox_item_id=>l_outbox_id,
3338: p_document_source=>'MES',

Line 3362: IEM_OUTBOX_PROC_PUB.createSRAutoNotification(p_api_version_number=>1.0,

3358: ELSE -- From Address contains only Address
3359: l_sender:=l_header_rec.reply_to_str;
3360: END IF;
3361: END IF;
3362: IEM_OUTBOX_PROC_PUB.createSRAutoNotification(p_api_version_number=>1.0,
3363: p_init_msg_list=>'F',
3364: p_commit=>'F',
3365: P_MEDIA_ID=>p_media_id,
3366: P_MASTER_ACCOUNT_ID=>p_post_rec.email_account_id,

Line 3396: IEM_OUTBOX_PROC_PUB.insertDocument(

3392: FOR i IN p_doc_tbl.FIRST..p_doc_tbl.LAST LOOP
3393: l_notification_id:=p_doc_tbl(i).doc_id;
3394: EXIT;
3395: END LOOP;
3396: IEM_OUTBOX_PROC_PUB.insertDocument(
3397: p_api_version_number=>1.0 ,
3398: p_outbox_item_id=>l_outbox_id,
3399: p_document_source=>'MES' ,
3400: p_document_id =>l_notification_id ,

Line 3428: IEM_OUTBOX_PROC_PUB.autoForward(

3424: p_subject=>null, -- pass the subject
3425: x_qual_tbl=> l_qual_tbl,
3426: x_status=>l_ret_status,
3427: x_out_text=>l_error_text);
3428: IEM_OUTBOX_PROC_PUB.autoForward(
3429: p_api_version_number=>1.0 ,
3430: p_init_msg_list=>'F' ,
3431: p_commit=>'F' ,
3432: p_media_id=>p_media_id,

Line 3458: IEM_OUTBOX_PROC_PUB.insertDocument(

3454: IF l_ret_status<>'S' THEN
3455: x_out_text:='Outbox Processing Return Error while creating a request for autoforward';
3456: raise AUTOREPLY_ERROR;
3457: END IF;
3458: IEM_OUTBOX_PROC_PUB.insertDocument(
3459: p_api_version_number=>1.0 ,
3460: p_outbox_item_id=>l_outbox_id,
3461: p_document_source=>'MES' ,
3462: p_document_id =>p_fwd_doc_id ,

Line 3473: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(

3469: raise AUTOREPLY_ERROR;
3470: END IF;
3471: end if;
3472: --submitting the request
3473: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(
3474: p_api_version_number=>1.0 ,
3475: p_init_msg_list=>'F',
3476: p_commit=>'F',
3477: p_outbox_item_id=>l_outbox_id ,

Line 3504: x_qual_tbl out nocopy IEM_OUTBOX_PROC_PUB.QualifierRecordList,

3500: PROCEDURE IEM_GET_MERGEVAL(p_email_account_id in number,
3501: p_mailer in varchar2,
3502: p_dflt_sender in varchar2,
3503: p_subject in varchar2,
3504: x_qual_tbl out nocopy IEM_OUTBOX_PROC_PUB.QualifierRecordList,
3505: x_status out nocopy varchar2,
3506: x_out_text out nocopy varchar2) IS
3507: cursor c1 is select lookup_code,meaning
3508: from fnd_lookups

Line 3516: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

3512: AND lookup_type ='IEM_MERGE_FIELDS'
3513: ANd lookup_code like 'ACK%';
3514: l_index number;
3515: l_sender_name varchar2(250);
3516: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
3517: l_from_name iem_email_accounts.from_name%type;
3518: l_reply_address iem_email_accounts.reply_to_address%type;
3519: begin
3520: select from_name,reply_to_address