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 FND_API

Line 172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

168: l_cust_contact_id number;
169: STOP_AUTO_PROCESSING EXCEPTION;
170: begin
171: -- Standard call to check for call compatibility.
172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
173: p_api_version_number,
174: l_api_name,
175: G_PKG_NAME)
176: THEN

Line 177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

173: p_api_version_number,
174: l_api_name,
175: G_PKG_NAME)
176: THEN
177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
178: END IF;
179: FND_LOG_REPOSITORY.init(null,null);
180: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
181: g_statement_log:=true;

Line 808: p_commit=>FND_API.G_FALSE,

804: END IF;
805:
806: -- Calling Auto Processing Engine For 'AUTODELETE'
807: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
808: p_commit=>FND_API.G_FALSE,
809: p_rule_type=>'AUTODELETE',
810: p_keyvals_tbl=>l_class_val_tbl,
811: p_accountid=>l_post_rec.email_account_id,
812: x_result=>l_autoproc_result,

Line 947: p_commit=>FND_API.G_FALSE,

943: END IF;
944: IF l_autoack_count=0 then --not auto acked yet for this message
945: l_autoack_flag:='N';
946: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
947: p_commit=>FND_API.G_FALSE,
948: p_rule_type=>'AUTOACKNOWLEDGE',
949: p_keyvals_tbl=>l_class_val_tbl,
950: p_accountid=>l_post_rec.email_account_id,
951: x_result=>l_autoproc_result,

Line 972: p_commit=>FND_API.G_FALSE,

968: END IF; -- for if autaock=0
969: -- Calling Rules Engine for AutoProcessing
970: l_param_rec_tbl.delete;
971: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
972: p_commit=>FND_API.G_FALSE,
973: p_rule_type=>'AUTOPROCESSING',
974: p_keyvals_tbl=>l_class_val_tbl,
975: p_accountid=>l_post_rec.email_account_id,
976: x_result=>l_autoproc_result,

Line 1214: p_init_msg_list => FND_API.G_TRUE,

1210: end if;
1211: l_note_type:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_NOTE_TYPE');
1212: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1213: p_api_version => 1.0,
1214: p_init_msg_list => FND_API.G_TRUE,
1215: p_commit => FND_API.G_FALSE,
1216: p_message_id => l_message_id,
1217: p_note => l_text,
1218: p_party_id => l_party_id,

Line 1215: p_commit => FND_API.G_FALSE,

1211: l_note_type:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_NOTE_TYPE');
1212: IEM_SERVICEREQUEST_PVT.IEM_CREATE_SR(
1213: p_api_version => 1.0,
1214: p_init_msg_list => FND_API.G_TRUE,
1215: p_commit => FND_API.G_FALSE,
1216: p_message_id => l_message_id,
1217: p_note => l_text,
1218: p_party_id => l_party_id,
1219: p_sr_type_id => l_status_id,

Line 1661: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

1657: iem_logger(l_logmessage);
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,

Line 1714: p_commit=>FND_API.G_FALSE,

1710: -- Prior to calling this check if the email is to be redirected on the profile
1711: -- set for autocreate/auto update SR fails for employee type
1712: if l_redirect_flag='N' then
1713: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
1714: p_commit=>FND_API.G_FALSE,
1715: p_rule_type=>'AUTOREDIRECT',
1716: p_keyvals_tbl=>l_class_val_tbl,
1717: p_accountid=>l_post_rec.email_account_id,
1718: x_result=>l_autoproc_result,

Line 1859: p_commit=>FND_API.G_FALSE,

1855: END IF; -- End if for both redirect actions
1856: END IF; --End if for autoproc_result='T'
1857: -- Calling Rules Engine For Auto-Reply
1858: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
1859: p_commit=>FND_API.G_FALSE,
1860: p_rule_type=>'AUTORRRS',
1861: p_keyvals_tbl=>l_class_val_tbl,
1862: p_accountid=>l_post_rec.email_account_id,
1863: x_result=>l_autoproc_result,

Line 1919: p_commit=>FND_API.G_FALSE,

1915: END IF; -- End if for autoproc_result='T'
1916: -- Calling DOCUMENT_RETRIEVAL 11.5.10 feature
1917: l_rule_id:=0;
1918: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
1919: p_commit=>FND_API.G_FALSE,
1920: p_rule_type=>'DOCUMENTRETRIEVAL',
1921: p_keyvals_tbl=>l_class_val_tbl,
1922: p_accountid=>l_post_rec.email_account_id,
1923: x_result=>l_autoproc_result,

Line 2310: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

2306: iem_logger(l_logmessage);
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,

Line 2412: IF FND_API.To_Boolean(p_commit) THEN

2408: l_count:=l_count+1;
2409: EXIT when l_count>p_count;
2410: END LOOP;
2411: -- Standard Check Of p_commit.
2412: IF FND_API.To_Boolean(p_commit) THEN
2413: COMMIT WORK;
2414: END IF;
2415: EXCEPTION
2416: WHEN FND_API.G_EXC_ERROR THEN

Line 2416: WHEN FND_API.G_EXC_ERROR THEN

2412: IF FND_API.To_Boolean(p_commit) THEN
2413: COMMIT WORK;
2414: END IF;
2415: EXCEPTION
2416: WHEN FND_API.G_EXC_ERROR THEN
2417: ROLLBACK TO process_emails_pvt;
2418: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_EXEC_ERROR');
2419: l_Error_Message := FND_MESSAGE.GET;
2420: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2418: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_EXEC_ERROR');
2419: l_Error_Message := FND_MESSAGE.GET;
2420: fnd_file.put_line(fnd_file.log, l_Error_Message);
2421: l_call_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_Error_Message);
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423: ROLLBACK TO process_emails_pvt;
2424: FND_MESSAGE.SET_NAME('IEM','IEM_RETRYPROCESS_UNXPTD_ERR');
2425: l_Error_Message := FND_MESSAGE.GET;
2426: fnd_file.put_line(fnd_file.log, l_Error_Message);

Line 2714: p_init_msg_list => FND_API.G_FALSE,

2710: raise CUSTOM_WF_EXCEP;
2711: end if;
2712:
2713: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
2714: p_init_msg_list => FND_API.G_FALSE,
2715: p_commit => FND_API.G_FALSE,
2716: p_type => 'WORKFLOW',
2717: p_param => p_message_id,
2718: p_value => l_outval,

Line 2715: p_commit => FND_API.G_FALSE,

2711: end if;
2712:
2713: IEM_COMP_RT_STATS_PVT.create_item(p_api_version_number =>1.0,
2714: p_init_msg_list => FND_API.G_FALSE,
2715: p_commit => FND_API.G_FALSE,
2716: p_type => 'WORKFLOW',
2717: p_param => p_message_id,
2718: p_value => l_outval,
2719: x_return_status => l_stat,

Line 2805: p_init_msg_list =>fnd_api.g_true,

2801: IF l_status_flag<>'C' THEN -- SR is not closed so we can update
2802: l_status_id:=p_status_id;
2803: IEM_ServiceRequest_PVT.Update_Status_Wrap
2804: ( p_api_version =>2.0,
2805: p_init_msg_list =>fnd_api.g_true,
2806: p_commit => fnd_api.g_false,
2807: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2808: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2809: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

Line 2806: p_commit => fnd_api.g_false,

2802: l_status_id:=p_status_id;
2803: IEM_ServiceRequest_PVT.Update_Status_Wrap
2804: ( p_api_version =>2.0,
2805: p_init_msg_list =>fnd_api.g_true,
2806: p_commit => fnd_api.g_false,
2807: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
2808: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
2809: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
2810: x_return_status =>l_ret_status,

Line 3335: p_init_msg_list=>FND_API.G_FALSE,

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',
3339: p_document_id=>p_doc_tbl(i).doc_id,

Line 3336: p_commit=>FND_API.G_TRUE,

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',
3339: p_document_id=>p_doc_tbl(i).doc_id,
3340: p_binary_source=>NULL,

Line 3373: P_INTERACTION_ID=>fnd_api.g_miss_num,

3369: p_bcc_address_list=>null,
3370: P_SUBJECT=>l_header_rec.subject,
3371: P_TAG_KEY_VALUE_TBL=>p_tag_key_value_tbl,
3372: P_CUSTOMER_ID=>p_customer_id,
3373: P_INTERACTION_ID=>fnd_api.g_miss_num,
3374: P_RESOURCE_ID=>p_resource_id,
3375: p_qualifiers =>p_qualifiers ,
3376: p_contact_id=>g_contact_id,
3377: p_relationship_id=>g_relation_id,

Line 3416: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

3412: END IF;
3413: else
3414: FND_MESSAGE.Set_Name('IEM','IEM_REDIRECT_EXT_HDR');
3415: FND_MSG_PUB.Add;
3416: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
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);

Line 3420: l_dflt_sender := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);

3416: l_ext_subject := FND_MSG_PUB.GET(FND_MSG_pub.Count_Msg,FND_API.G_FALSE);
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

Line 3866: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

3862:
3863: begin
3864: l_api_version_number:=1.0;
3865: -- Standard call to check for call compatibility.
3866: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3867: p_api_version_number,
3868: l_api_name,
3869: G_PKG_NAME)
3870: THEN

Line 3871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3867: p_api_version_number,
3868: l_api_name,
3869: G_PKG_NAME)
3870: THEN
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');

Line 4076: p_commit=>FND_API.G_FALSE,

4072:
4073: -- Now Calling Document Retrieval Rule
4074: l_rule_id:=0;
4075: iem_rules_engine_pub.auto_process_email(p_api_version_number=>1.0,
4076: p_commit=>FND_API.G_FALSE,
4077: p_rule_type=>'DOCUMENTRETRIEVAL',
4078: p_keyvals_tbl=>l_class_val_tbl,
4079: p_accountid=>l_mail_rec.email_account_id,
4080: x_result=>l_autoproc_result,

Line 4350: x_return_status := FND_API.G_RET_STS_ERROR;

4346: l_logmessage:='Error occur during Reprocessing autoreply message '||sqlerrm ;
4347: iem_logger(l_logmessage);
4348: end if;
4349: rollback to processautoreply;
4350: x_return_status := FND_API.G_RET_STS_ERROR;
4351: IF FND_MSG_PUB.Check_Msg_Level
4352: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4353: THEN
4354: FND_MSG_PUB.Add_Exc_Msg

Line 4481: p_init_msg_list => fnd_api.g_true,

4477: end if;
4478: l_rep :=cs_kb_varchar100_tbl_type('MES') ;
4479: cs_knowledge_grp.Specific_Search(
4480: p_api_version => 1.0,
4481: p_init_msg_list => fnd_api.g_true,
4482: --p_validation_level => p_validation_level,
4483: x_return_status => l_return_status,
4484: x_msg_count => l_msg_count,
4485: x_msg_data => l_msg_data,

Line 4489: p_check_login_user => FND_API.G_FALSE,

4485: x_msg_data => l_msg_data,
4486: p_repository_tbl => l_rep,
4487: p_search_string => l_imt_string,
4488: p_updated_in_days => l_days,
4489: p_check_login_user => FND_API.G_FALSE,
4490: p_application_id => G_APP_ID,
4491: p_area_array => l_area_array,
4492: p_content_array => l_content_array,
4493: p_param_array => l_param_array,

Line 4496: p_include_subcats => FND_API.G_FALSE,

4492: p_content_array => l_content_array,
4493: p_param_array => l_param_array,
4494: p_user_id => l_user_id,
4495: p_category_id => l_category_id,
4496: p_include_subcats => FND_API.G_FALSE,
4497: p_external_contents => FND_API.G_TRUE,
4498: p_rows_requested_tbl => l_rows_req,
4499: p_start_row_pos_tbl => l_start_row,
4500: p_get_total_cnt_flag => 'T',

Line 4497: p_external_contents => FND_API.G_TRUE,

4493: p_param_array => l_param_array,
4494: p_user_id => l_user_id,
4495: p_category_id => l_category_id,
4496: p_include_subcats => FND_API.G_FALSE,
4497: p_external_contents => FND_API.G_TRUE,
4498: p_rows_requested_tbl => l_rows_req,
4499: p_start_row_pos_tbl => l_start_row,
4500: p_get_total_cnt_flag => 'T',
4501: x_rows_returned_tbl => l_rows_returned,

Line 4555: p_init_msg_list => fnd_api.g_true,

4551: -- Calling Search Api for Response String Separately
4552: IF r_imt_string is not null then
4553: cs_knowledge_grp.Specific_Search(
4554: p_api_version => 1.0,
4555: p_init_msg_list => fnd_api.g_true,
4556: --p_validation_level => p_validation_level,
4557: x_return_status => l_return_status,
4558: x_msg_count => l_msg_count,
4559: x_msg_data => l_msg_data,

Line 4563: p_check_login_user => FND_API.G_FALSE,

4559: x_msg_data => l_msg_data,
4560: p_repository_tbl => l_rep,
4561: p_search_string => r_imt_string,
4562: p_updated_in_days => l_days,
4563: p_check_login_user => FND_API.G_FALSE,
4564: p_application_id => G_APP_ID,
4565: p_area_array => l_area_array,
4566: p_content_array => l_content_array,
4567: p_param_array => l_param_array,

Line 4570: p_include_subcats => FND_API.G_FALSE,

4566: p_content_array => l_content_array,
4567: p_param_array => l_param_array,
4568: p_user_id => l_user_id,
4569: p_category_id => l_category_id,
4570: p_include_subcats => FND_API.G_FALSE,
4571: p_external_contents => FND_API.G_TRUE,
4572: p_rows_requested_tbl => l_rows_req,
4573: p_start_row_pos_tbl => l_start_row,
4574: p_get_total_cnt_flag => 'T',

Line 4571: p_external_contents => FND_API.G_TRUE,

4567: p_param_array => l_param_array,
4568: p_user_id => l_user_id,
4569: p_category_id => l_category_id,
4570: p_include_subcats => FND_API.G_FALSE,
4571: p_external_contents => FND_API.G_TRUE,
4572: p_rows_requested_tbl => l_rows_req,
4573: p_start_row_pos_tbl => l_start_row,
4574: p_get_total_cnt_flag => 'T',
4575: x_rows_returned_tbl => l_rows_returned,

Line 4643: p_init_msg_list => fnd_api.g_true,

4639: l_imt_string:=substr(l_sms_string,1,l_sms_count-1);
4640: END IF;
4641: cs_knowledge_grp.Specific_Search(
4642: p_api_version => 1.0,
4643: p_init_msg_list => fnd_api.g_true,
4644: --p_validation_level => p_validation_level,
4645: x_return_status => l_return_status,
4646: x_msg_count => l_msg_count,
4647: x_msg_data => l_msg_data,

Line 4651: p_check_login_user => FND_API.G_FALSE,

4647: x_msg_data => l_msg_data,
4648: p_repository_tbl => l_rep,
4649: p_search_string => l_imt_string,
4650: p_updated_in_days => l_days,
4651: p_check_login_user => FND_API.G_FALSE,
4652: p_application_id => G_APP_ID,
4653: p_area_array => l_area_array,
4654: p_content_array => l_content_array,
4655: p_param_array => l_param_array,

Line 4658: p_include_subcats => FND_API.G_TRUE,

4654: p_content_array => l_content_array,
4655: p_param_array => l_param_array,
4656: p_user_id => l_user_id,
4657: p_category_id => l_category_id,
4658: p_include_subcats => FND_API.G_TRUE,
4659: p_external_contents => FND_API.G_TRUE,
4660: p_rows_requested_tbl => l_rows_req,
4661: p_start_row_pos_tbl => l_start_row,
4662: p_get_total_cnt_flag => 'T',

Line 4659: p_external_contents => FND_API.G_TRUE,

4655: p_param_array => l_param_array,
4656: p_user_id => l_user_id,
4657: p_category_id => l_category_id,
4658: p_include_subcats => FND_API.G_TRUE,
4659: p_external_contents => FND_API.G_TRUE,
4660: p_rows_requested_tbl => l_rows_req,
4661: p_start_row_pos_tbl => l_start_row,
4662: p_get_total_cnt_flag => 'T',
4663: x_rows_returned_tbl => l_rows_returned,

Line 4717: p_init_msg_list => fnd_api.g_true,

4713: IF r_imt_string is not null then
4714: -- Calling Specific Search for Response String
4715: cs_knowledge_grp.Specific_Search(
4716: p_api_version => 1.0,
4717: p_init_msg_list => fnd_api.g_true,
4718: --p_validation_level => p_validation_level,
4719: x_return_status => l_return_status,
4720: x_msg_count => l_msg_count,
4721: x_msg_data => l_msg_data,

Line 4725: p_check_login_user => FND_API.G_FALSE,

4721: x_msg_data => l_msg_data,
4722: p_repository_tbl => l_rep,
4723: p_search_string => r_imt_string,
4724: p_updated_in_days => l_days,
4725: p_check_login_user => FND_API.G_FALSE,
4726: p_application_id => G_APP_ID,
4727: p_area_array => l_area_array,
4728: p_content_array => l_content_array,
4729: p_param_array => l_param_array,

Line 4732: p_include_subcats => FND_API.G_FALSE,

4728: p_content_array => l_content_array,
4729: p_param_array => l_param_array,
4730: p_user_id => l_user_id,
4731: p_category_id => l_category_id,
4732: p_include_subcats => FND_API.G_FALSE,
4733: p_external_contents => FND_API.G_TRUE,
4734: p_rows_requested_tbl => l_rows_req,
4735: p_start_row_pos_tbl => l_start_row,
4736: p_get_total_cnt_flag => 'T',

Line 4733: p_external_contents => FND_API.G_TRUE,

4729: p_param_array => l_param_array,
4730: p_user_id => l_user_id,
4731: p_category_id => l_category_id,
4732: p_include_subcats => FND_API.G_FALSE,
4733: p_external_contents => FND_API.G_TRUE,
4734: p_rows_requested_tbl => l_rows_req,
4735: p_start_row_pos_tbl => l_start_row,
4736: p_get_total_cnt_flag => 'T',
4737: x_rows_returned_tbl => l_rows_returned,