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 136: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

132: l_rt_media_item_id number;
133: l_rt_interaction_id number;
134: l_email_doc_tbl email_doc_tbl;
135: l_resource_id number;
136: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
137: l_outbox_tbl IEM_OUTBOX_PROC_PUB.keyVals_tbl_type;
138: l_auto_reply_flag varchar2(1):='N';
139: l_auto_forward_flag varchar2(1);
140: l_action_id number;

Line 137: l_outbox_tbl IEM_OUTBOX_PROC_PUB.keyVals_tbl_type;

133: l_rt_interaction_id number;
134: l_email_doc_tbl email_doc_tbl;
135: l_resource_id number;
136: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
137: l_outbox_tbl IEM_OUTBOX_PROC_PUB.keyVals_tbl_type;
138: l_auto_reply_flag varchar2(1):='N';
139: l_auto_forward_flag varchar2(1);
140: l_action_id number;
141: l_outbox_item_id number;

Line 3598: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

3594: l_text_data varchar2(500);
3595: l_reply_address varchar2(500);
3596: l_resource_id number;
3597: l_email_account_id number;
3598: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
3599: ACK_FAILED EXCEPTION;
3600: l_ret_status varchar2(10);
3601: l_msg_count number;
3602: l_msg_data varchar2(500);

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

3630: END;
3631: -- Calling OP Api for sending Out Auto Acknowledgement
3632:
3633: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;
3634: IEM_OUTBOX_PROC_PUB.createOutboxMessage(p_api_version_number=>1.0,
3635: p_init_msg_list=>'F',
3636: p_commit=>'F',
3637: P_RESOURCE_ID=>l_resource_id,
3638: p_application_id=>680,

Line 3663: IEM_OUTBOX_PROC_PUB.insertDocument(

3659: if l_ret_status<>'S' THEN
3660: x_out_text:='Failed in createoutbox message '||l_text_data;
3661: raise ACK_FAILED;
3662: end if;
3663: IEM_OUTBOX_PROC_PUB.insertDocument(
3664: p_api_version_number=>1.0 ,
3665: p_outbox_item_id=>l_outbox_id,
3666: p_document_source=>'MES' ,
3667: p_document_id =>p_document_id ,

Line 3675: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(

3671: if l_ret_status<>'S' THEN
3672: x_out_text:='Failed in insert document '||l_text_data;
3673: raise ACK_FAILED;
3674: end if;
3675: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(
3676: p_api_version_number=>1.0 ,
3677: p_init_msg_list=>'F',
3678: p_commit => 'F',
3679: p_outbox_item_id=>l_outbox_id ,

Line 4336: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,

4332: p_media_id in number,
4333: p_post_rec in iem_rt_preproc_emails%rowtype,
4334: p_doc_tbl in email_doc_tbl,
4335: p_subject in varchar2,
4336: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,
4337: P_CUSTOMER_ID in number,
4338: P_RESOURCE_ID in number,
4339: p_qualifiers in IEM_OUTBOX_PROC_PUB.QualifierRecordList,
4340: p_fwd_address in varchar2,

Line 4339: p_qualifiers in IEM_OUTBOX_PROC_PUB.QualifierRecordList,

4335: p_subject in varchar2,
4336: P_TAG_KEY_VALUE_TBL in IEM_OUTBOX_PROC_PUB.keyVals_tbl_type,
4337: P_CUSTOMER_ID in number,
4338: P_RESOURCE_ID in number,
4339: p_qualifiers in IEM_OUTBOX_PROC_PUB.QualifierRecordList,
4340: p_fwd_address in varchar2,
4341: p_fwd_doc_id in number,
4342: p_req_type in varchar2,
4343: x_out_text out NOCOPY varchar2,

Line 4355: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

4351: l_file_name varchar2(256);
4352: l_ext_subject varchar2(100);
4353: l_data varchar2(500);
4354: l_msg_index_out varchar2(10);
4355: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
4356: l_error_text varchar2(1000);
4357: l_dflt_sender varchar2(250);
4358: l_sender varchar2(256);
4359: l_from1 number;

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

4370: ELSE -- From Address contains only Address
4371: l_sender:=l_header_rec.from_str;
4372: END IF;
4373: if p_req_type='R' then -- Autoreply
4374: IEM_OUTBOX_PROC_PUB.createautoreply(p_api_version_number=>1.0,
4375: p_init_msg_list=>'F',
4376: p_commit=>'F',
4377: P_MEDIA_ID=>p_media_id, --- Then next 3 parameter will be null
4378: P_RFC822_MESSAGE_ID =>null,

Line 4404: IEM_OUTBOX_PROC_PUB.insertDocument(

4400: raise AUTOREPLY_ERROR;
4401: END IF;
4402: FOR i IN p_doc_tbl.FIRST..p_doc_tbl.LAST LOOP
4403: IF p_doc_tbl(i).type='I' THEN
4404: IEM_OUTBOX_PROC_PUB.insertDocument(
4405: p_api_version_number=>1.0 ,
4406: p_outbox_item_id=>l_outbox_id,
4407: p_document_source=>'MES' ,
4408: p_document_id =>p_doc_tbl(i).doc_id ,

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

4425: AND b.item_id=p_doc_tbl(i).doc_id
4426: AND b.language=USERENV('LANG')
4427: and rownum=1;
4428:
4429: IEM_OUTBOX_PROC_PUB.attachDocument(p_api_version_number=>1.0,
4430: p_init_msg_list=>FND_API.G_FALSE,
4431: p_commit=>FND_API.G_TRUE,
4432: p_outbox_item_id=>l_outbox_id,
4433: p_document_source=>'MES',

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

4453: ELSE -- From Address contains only Address
4454: l_sender:=l_header_rec.reply_to_str;
4455: END IF;
4456: END IF;
4457: IEM_OUTBOX_PROC_PUB.createSRAutoNotification(p_api_version_number=>1.0,
4458: p_init_msg_list=>'F',
4459: p_commit=>'F',
4460: P_MEDIA_ID=>p_media_id,
4461: P_MASTER_ACCOUNT_ID=>p_post_rec.email_account_id,

Line 4491: IEM_OUTBOX_PROC_PUB.insertDocument(

4487: FOR i IN p_doc_tbl.FIRST..p_doc_tbl.LAST LOOP
4488: l_notification_id:=p_doc_tbl(i).doc_id;
4489: EXIT;
4490: END LOOP;
4491: IEM_OUTBOX_PROC_PUB.insertDocument(
4492: p_api_version_number=>1.0 ,
4493: p_outbox_item_id=>l_outbox_id,
4494: p_document_source=>'MES' ,
4495: p_document_id =>l_notification_id ,

Line 4523: IEM_OUTBOX_PROC_PUB.autoForward(

4519: p_subject=>l_header_rec.subject, --passing the subject, sanjana rao , bug 8839425
4520: x_qual_tbl=> l_qual_tbl,
4521: x_status=>l_ret_status,
4522: x_out_text=>l_error_text);
4523: IEM_OUTBOX_PROC_PUB.autoForward(
4524: p_api_version_number=>1.0 ,
4525: p_init_msg_list=>'F' ,
4526: p_commit=>'F' ,
4527: p_media_id=>p_media_id,

Line 4553: IEM_OUTBOX_PROC_PUB.insertDocument(

4549: IF l_ret_status<>'S' THEN
4550: x_out_text:='Outbox Processing Return Error while creating a request for autoforward';
4551: raise AUTOREPLY_ERROR;
4552: END IF;
4553: IEM_OUTBOX_PROC_PUB.insertDocument(
4554: p_api_version_number=>1.0 ,
4555: p_outbox_item_id=>l_outbox_id,
4556: p_document_source=>'MES' ,
4557: p_document_id =>p_fwd_doc_id ,

Line 4568: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(

4564: raise AUTOREPLY_ERROR;
4565: END IF;
4566: end if;
4567: --submitting the request
4568: IEM_OUTBOX_PROC_PUB.submitOutboxMessage(
4569: p_api_version_number=>1.0 ,
4570: p_init_msg_list=>'F',
4571: p_commit=>'F',
4572: p_outbox_item_id=>l_outbox_id ,

Line 4599: x_qual_tbl out nocopy IEM_OUTBOX_PROC_PUB.QualifierRecordList,

4595: PROCEDURE IEM_GET_MERGEVAL(p_email_account_id in number,
4596: p_mailer in varchar2,
4597: p_dflt_sender in varchar2,
4598: p_subject in varchar2,
4599: x_qual_tbl out nocopy IEM_OUTBOX_PROC_PUB.QualifierRecordList,
4600: x_status out nocopy varchar2,
4601: x_out_text out nocopy varchar2) IS
4602: cursor c1 is select lookup_code,meaning
4603: from fnd_lookups

Line 4611: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;

4607: AND lookup_type ='IEM_MERGE_FIELDS'
4608: ANd lookup_code like 'ACK%';
4609: l_index number;
4610: l_sender_name varchar2(250);
4611: l_qual_tbl IEM_OUTBOX_PROC_PUB.QualifierRecordList;
4612: l_from_name iem_email_accounts.from_name%type;
4613: l_reply_address iem_email_accounts.reply_to_address%type;
4614: begin
4615: select from_name,reply_to_address