[Home] [Help]
275: END IF;
276:
277: /* Find the profile value set for Processing Number of Intents for suggested Documents */
278:
279: l_intent_counter:=FND_PROFILE.VALUE_SPECIFIC('IEM_INTENT_RESPONSE_NUM');
280: if l_intent_counter is null then
281: l_intent_counter:=1;
282: end if;
283:
759:
760: -- *** Open an Interaction *** --
761:
762: l_interaction_rec.start_date_time := sysdate;
763: l_resource_id:=FND_PROFILE.VALUE_SPECIFIC('IEM_SRVR_ARES') ;
764: l_interaction_rec.resource_id:=l_resource_id ;
765:
766:
767: if g_statement_log then
778: IF l_ih_id is not null then
779: l_interaction_rec.parent_id := l_ih_id;
780: end if;
781: if l_acct_type='I' then -- For internal account type it will come from profile
782: l_customer_id := FND_PROFILE.VALUE_SPECIFIC('CS_SR_DEFAULT_CUSTOMER_NAME');
783:
784:
785: if g_statement_log then
786: l_logmessage:='l_customer_id from profile CS_SR_DEFAULT_CUSTOMER_NAME : ' || l_customer_id;
1432:
1433: IF l_autoproc_result='T' THEN
1434: IF l_action='EXECPROCEDURE' THEN
1435: IF ((l_post_rec.ih_media_item_id is not null) and
1436: (FND_PROFILE.VALUE_SPECIFIC('IEM_RERUN_CUSTOM_PROCEDURE')='N')) THEN
1437: if g_statement_log then
1438: l_logmessage:='Not Executing Custom Procedure Again ';
1439: iem_logger(l_logmessage);
1440:
1723: Where upper(email_address)=upper(l_sender);
1724: exception when others then
1725: l_contact_id:=null;
1726: END;
1727: l_party_id:=FND_PROFILE.VALUE_SPECIFIC('CS_SR_DEFAULT_CUSTOMER_NAME');
1728:
1729:
1730: if g_statement_log then
1731: l_logmessage:='insided auto create sr account Type I : l_party_id : '||l_party_id;
1796: l_logmessage:='customer id is -1';
1797: iem_logger(l_logmessage);
1798: end if;
1799:
1800: if fnd_profile.value_specific('IEM_SR_NO_CUST')='CREATESR' then
1801: l_party_id:=fnd_profile.value_specific('IEM_DEFAULT_CUSTOMER_ID');
1802: else
1803: l_party_id:=null;
1804: end if;
1797: iem_logger(l_logmessage);
1798: end if;
1799:
1800: if fnd_profile.value_specific('IEM_SR_NO_CUST')='CREATESR' then
1801: l_party_id:=fnd_profile.value_specific('IEM_DEFAULT_CUSTOMER_ID');
1802: else
1803: l_party_id:=null;
1804: end if;
1805: else -- Multiple Customer Match.
1833: l_logmessage:='Error Encountered while Retrieving Notes';
1834: iem_logger(l_logmessage);
1835: raise ABORT_PROCESSING;
1836: end if;
1837: l_note_type:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_NOTE_TYPE');
1838:
1839:
1840: if g_statement_log then
1841: l_logmessage:='Message id '||l_message_id ||'Note '||substr(l_text,1,200)||'Party id '||l_party_id||'SR type Id '||l_status_id||'Note type '||l_note_type||'Contact id '||l_contact_id ||'Contact Point id '||l_contact_point_id;
1842: iem_logger(l_logmessage);
1843: END if;
1844:
1845: --Fix for bug 14202765
1846: l_notes_flag := FND_PROFILE.VALUE('IEM_AUTO_CREATE_SR_ADD_EMAIL_AS_NOTE');
1847: IF ( l_notes_flag = 'N') THEN
1848: l_text := null;
1849: END IF;
1850:
2181: l_logmessage:=l_out_text;
2182: raise ABORT_PROCESSING;
2183: END IF;
2184: -- Check for Sending out notifications
2185: l_noti_flag:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_CREATE_NOTI');
2186: if l_noti_flag='Y' then
2187: -- update the itneraction with result reason outcome
2188: select wu.outcome_id, wu.result_id, wu.reason_id INTO
2189: l_interaction_rec.outcome_id, l_interaction_rec.result_id, l_interaction_rec.reason_id
2269: end if; -- for if l_noti_flag='Y'
2270: raise STOP_PROCESSING;
2271: else -- Sr creation fails so if it is internal type in that casecheck prfile value for next action. in case of external account it is always route.
2272: if l_acct_type='I' then
2273: if (fnd_profile.value_specific('IEM_SR_NOT_UPDATED'))='REDIRECT'
2274: then
2275: l_redirect_flag:='Y';
2276: end if;
2277: end if;
2410: l_logmessage:='AUTOUPDSR:Error While Inserting Record in Proc Emails Table ';
2411: raise ABORT_PROCESSING;
2412: END IF;
2413: -- Check for Sending Out Notifications
2414: l_noti_flag:=FND_PROFILE.VALUE_SPECIFIC('IEM_SR_UPDATE_NOTI');
2415: if l_noti_flag='Y' then -- Sends out notifications
2416:
2417: -- update the itneraction with result reason outcome
2418: select wu.outcome_id, wu.result_id, wu.reason_id INTO
2503: raise STOP_PROCESSING;
2504: ELSE
2505: -- Sr updation fails so if it is internal type in that casecheck prfile value for next action. in case of external account it is always route.
2506: if l_acct_type='I' then
2507: if (fnd_profile.value_specific('IEM_SR_NOT_UPDATED'))='REDIRECT'
2508: then
2509: l_redirect_flag:='Y';
2510: end if;
2511: end if;
2596: END IF;
2597: else -- As auto redirect flag is set for autoupdate/create SR
2598: l_autoproc_result:='T';
2599: l_action:='AUTOREDIRECT_EXTERNAL';
2600: l_ext_address:=fnd_profile.value_specific('IEM_SR_REDIRECT_EMAIL_ADDR');
2601: end if;
2602: if l_action='AUTOREDIRECT_EXTERNAL' and l_autoproc_result='T' THEN
2603: IF l_auto_forward_flag='Y' THEN --donot autoforward to a already autofwd message
2604: l_autoproc_result:='F';
3104: iem_logger(l_logmessage);
3105: end if;
3106:
3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3108: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3109: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3110: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3111: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3112: x_return_status => l_ret_status,
3105: end if;
3106:
3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3108: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3109: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3110: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3111: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3112: x_return_status => l_ret_status,
3113: x_msg_count => l_msg_count,
3106:
3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3108: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3109: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3110: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3111: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3112: x_return_status => l_ret_status,
3113: x_msg_count => l_msg_count,
3114: x_msg_data => l_msg_data,
3107: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
3108: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3109: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3110: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
3111: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
3112: x_return_status => l_ret_status,
3113: x_msg_count => l_msg_count,
3114: x_msg_data => l_msg_data,
3115: p_interaction_rec => l_interaction_rec
3212: p_doc_last_modified_date=>v_item.last_update_date,
3213: p_score =>l_kb_rank,
3214: p_url =>' ',
3215: p_kb_delete=>'N',
3216: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3217: p_CREATION_DATE =>SYSDATE,
3218: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3219: p_LAST_UPDATE_DATE =>SYSDATE,
3220: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
3214: p_url =>' ',
3215: p_kb_delete=>'N',
3216: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3217: p_CREATION_DATE =>SYSDATE,
3218: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3219: p_LAST_UPDATE_DATE =>SYSDATE,
3220: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
3221: p_ATTRIBUTE1 =>null,
3222: p_ATTRIBUTE2 =>null,
3216: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3217: p_CREATION_DATE =>SYSDATE,
3218: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3219: p_LAST_UPDATE_DATE =>SYSDATE,
3220: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
3221: p_ATTRIBUTE1 =>null,
3222: p_ATTRIBUTE2 =>null,
3223: p_ATTRIBUTE3 =>null,
3224: p_ATTRIBUTE4 =>null,
3629: null;
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,
3898: IEM_ServiceRequest_PVT.Update_Status_Wrap
3899: ( p_api_version =>2.0,
3900: p_init_msg_list =>fnd_api.g_true,
3901: p_commit => fnd_api.g_false,
3902: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3903: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3904: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3905: x_return_status =>l_ret_status,
3906: x_msg_count=>l_msg_count,
3899: ( p_api_version =>2.0,
3900: p_init_msg_list =>fnd_api.g_true,
3901: p_commit => fnd_api.g_false,
3902: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3903: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3904: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3905: x_return_status =>l_ret_status,
3906: x_msg_count=>l_msg_count,
3907: x_msg_data =>l_msg_data,
3900: p_init_msg_list =>fnd_api.g_true,
3901: p_commit => fnd_api.g_false,
3902: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
3903: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
3904: p_user_id =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
3905: x_return_status =>l_ret_status,
3906: x_msg_count=>l_msg_count,
3907: x_msg_data =>l_msg_data,
3908: p_request_id =>p_sr_id,
4029: if p_action='ADD' THEN
4030: JTF_IH_PUB.Open_MediaItem(1.0,
4031: 'T',
4032: 'F',
4033: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4034: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4035: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4036: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4037: l_ret_status,
4030: JTF_IH_PUB.Open_MediaItem(1.0,
4031: 'T',
4032: 'F',
4033: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4034: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4035: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4036: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4037: l_ret_status,
4038: l_msg_count,
4031: 'T',
4032: 'F',
4033: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4034: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4035: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4036: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4037: l_ret_status,
4038: l_msg_count,
4039: l_msg_data,
4032: 'F',
4033: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4034: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4035: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4036: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4037: l_ret_status,
4038: l_msg_count,
4039: l_msg_data,
4040: p_media_rec,
4050:
4051: JTF_IH_PUB.Update_MediaItem( 1.0,
4052: 'T',
4053: 'F',
4054: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4055: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4056: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4057: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4058: l_ret_status,
4051: JTF_IH_PUB.Update_MediaItem( 1.0,
4052: 'T',
4053: 'F',
4054: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4055: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4056: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4057: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4058: l_ret_status,
4059: l_msg_count,
4052: 'T',
4053: 'F',
4054: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4055: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4056: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4057: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4058: l_ret_status,
4059: l_msg_count,
4060: l_msg_data,
4053: 'F',
4054: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4055: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4056: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4057: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4058: l_ret_status,
4059: l_msg_count,
4060: l_msg_data,
4061: p_media_rec);
4067:
4068: JTF_IH_PUB.Close_MediaItem( 1.0,
4069: 'T',
4070: 'F',
4071: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4072: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4073: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4074: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4075: l_ret_status,
4068: JTF_IH_PUB.Close_MediaItem( 1.0,
4069: 'T',
4070: 'F',
4071: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4072: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4073: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4074: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4075: l_ret_status,
4076: l_msg_count,
4069: 'T',
4070: 'F',
4071: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4072: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4073: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4074: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4075: l_ret_status,
4076: l_msg_count,
4077: l_msg_data,
4070: 'F',
4071: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4072: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4073: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4074: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4075: l_ret_status,
4076: l_msg_count,
4077: l_msg_data,
4078: p_media_rec);
4085: if p_action='ADD' THEN
4086: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
4087: 'T',
4088: 'F',
4089: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4090: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4091: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4092: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4093: l_ret_status,
4086: JTF_IH_PUB.Add_MediaLifeCycle( 1.0,
4087: 'T',
4088: 'F',
4089: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4090: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4091: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4092: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4093: l_ret_status,
4094: l_msg_count,
4087: 'T',
4088: 'F',
4089: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4090: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4091: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4092: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4093: l_ret_status,
4094: l_msg_count,
4095: l_msg_data,
4088: 'F',
4089: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4090: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4091: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4092: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4093: l_ret_status,
4094: l_msg_count,
4095: l_msg_data,
4096: p_media_lc_rec,
4105: elsif p_action='UPDATE' THEN
4106: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
4107: 'T',
4108: 'F',
4109: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4110: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4111: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4112: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4113: l_ret_status,
4106: JTF_IH_PUB.Update_MediaLifeCycle( 1.0,
4107: 'T',
4108: 'F',
4109: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4110: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4111: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4112: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4113: l_ret_status,
4114: l_msg_count,
4107: 'T',
4108: 'F',
4109: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4110: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4111: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4112: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4113: l_ret_status,
4114: l_msg_count,
4115: l_msg_data,
4108: 'F',
4109: TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4110: TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4111: nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4112: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4113: l_ret_status,
4114: l_msg_count,
4115: l_msg_data,
4116: p_media_lc_rec);
4122: elsif p_type='INTERACTION' THEN
4123: IF p_action='ADD' THEN
4124:
4125: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
4126: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4127: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4128: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4129: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4130: x_return_status => l_ret_status,
4123: IF p_action='ADD' THEN
4124:
4125: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
4126: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4127: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4128: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4129: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4130: x_return_status => l_ret_status,
4131: x_msg_count => l_msg_count,
4124:
4125: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
4126: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4127: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4128: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4129: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4130: x_return_status => l_ret_status,
4131: x_msg_count => l_msg_count,
4132: x_msg_data => l_msg_data,
4125: JTF_IH_PUB.Open_Interaction( p_api_version => 1.1,
4126: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4127: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4128: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4129: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4130: x_return_status => l_ret_status,
4131: x_msg_count => l_msg_count,
4132: x_msg_data => l_msg_data,
4133: x_interaction_id => l_interaction_id,
4140: x_id:=l_interaction_id;
4141: end if;
4142: ELSIF p_action='UPDATE' THEN
4143: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4144: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4145: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4146: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4147: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4148: x_return_status => l_ret_status,
4141: end if;
4142: ELSIF p_action='UPDATE' THEN
4143: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4144: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4145: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4146: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4147: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4148: x_return_status => l_ret_status,
4149: x_msg_count => l_msg_count,
4142: ELSIF p_action='UPDATE' THEN
4143: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4144: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4145: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4146: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4147: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4148: x_return_status => l_ret_status,
4149: x_msg_count => l_msg_count,
4150: x_msg_data => l_msg_data,
4143: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
4144: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4145: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4146: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4147: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4148: x_return_status => l_ret_status,
4149: x_msg_count => l_msg_count,
4150: x_msg_data => l_msg_data,
4151: p_interaction_rec => p_interaction_rec
4155: raise IH_EXCEPTION;
4156: END IF;
4157: ELSIF p_action='CLOSE' THEN
4158: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
4159: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4160: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4161: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4162: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4163: x_return_status => l_ret_status,
4156: END IF;
4157: ELSIF p_action='CLOSE' THEN
4158: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
4159: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4160: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4161: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4162: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4163: x_return_status => l_ret_status,
4164: x_msg_count => l_msg_count,
4157: ELSIF p_action='CLOSE' THEN
4158: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
4159: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4160: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4161: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4162: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4163: x_return_status => l_ret_status,
4164: x_msg_count => l_msg_count,
4165: x_msg_data => l_msg_data,
4158: JTF_IH_PUB.Close_Interaction( p_api_version => 1.1,
4159: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4160: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4161: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4162: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4163: x_return_status => l_ret_status,
4164: x_msg_count => l_msg_count,
4165: x_msg_data => l_msg_data,
4166: p_interaction_rec => p_interaction_rec);
4182: EXCEPTION WHEN OTHERS THEN
4183: NULL;
4184: END;
4185: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
4186: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4187: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4188: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4189: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4190: x_return_status => l_ret_status,
4183: NULL;
4184: END;
4185: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
4186: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4187: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4188: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4189: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4190: x_return_status => l_ret_status,
4191: x_msg_count => l_msg_count,
4184: END;
4185: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
4186: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4187: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4188: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4189: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4190: x_return_status => l_ret_status,
4191: x_msg_count => l_msg_count,
4192: x_msg_data => l_msg_data,
4185: JTF_IH_PUB.Add_Activity(p_api_version => 1.0,
4186: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
4187: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
4188: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
4189: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
4190: x_return_status => l_ret_status,
4191: x_msg_count => l_msg_count,
4192: x_msg_data => l_msg_data,
4193: p_activity_rec => l_activity_rec,
4841: p_classification_id=>x.classification_id,
4842: p_score=>x.score,
4843: p_message_id=>l_msg_id,
4844: p_class_string=>l_class_str,
4845: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4846: p_CREATION_DATE=> SYSDATE,
4847: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
4848: p_LAST_UPDATE_DATE=>SYSDATE,
4849: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
4843: p_message_id=>l_msg_id,
4844: p_class_string=>l_class_str,
4845: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4846: p_CREATION_DATE=> SYSDATE,
4847: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
4848: p_LAST_UPDATE_DATE=>SYSDATE,
4849: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
4850: x_return_Status=>l_status,
4851: x_msg_count=>l_count,
4845: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
4846: p_CREATION_DATE=> SYSDATE,
4847: p_LAST_UPDATED_BY=>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
4848: p_LAST_UPDATE_DATE=>SYSDATE,
4849: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
4850: x_return_Status=>l_status,
4851: x_msg_count=>l_count,
4852: x_msg_data=>l_msg_data);
4853: l_class_count:=l_class_count+1;
5322: -- the message is autorouted to
5323: l_interaction_rec.interaction_id:=p_interaction_id;
5324: l_interaction_rec.resource_id:=l_agentid;
5325: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
5326: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
5327: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
5328: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
5329: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5330: x_return_status => l_ret_status,
5323: l_interaction_rec.interaction_id:=p_interaction_id;
5324: l_interaction_rec.resource_id:=l_agentid;
5325: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
5326: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
5327: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
5328: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
5329: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5330: x_return_status => l_ret_status,
5331: x_msg_count => l_msg_count,
5324: l_interaction_rec.resource_id:=l_agentid;
5325: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
5326: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
5327: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
5328: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
5329: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5330: x_return_status => l_ret_status,
5331: x_msg_count => l_msg_count,
5332: x_msg_data => l_msg_data,
5325: JTF_IH_PUB.Update_Interaction( p_api_version => 1.1,
5326: p_resp_appl_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID')),
5327: p_resp_id => TO_NUMBER(FND_PROFILE.VALUE('RESP_ID')),
5328: p_user_id =>nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
5329: p_login_id =>TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
5330: x_return_status => l_ret_status,
5331: x_msg_count => l_msg_count,
5332: x_msg_data => l_msg_data,
5333: p_interaction_rec => l_interaction_rec
5386: p_doc_last_modified_date=>v_item.last_update_date,
5387: p_score =>l_kb_rank,
5388: p_url =>' ',
5389: p_kb_delete=>'N',
5390: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5391: p_CREATION_DATE =>SYSDATE,
5392: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5393: p_LAST_UPDATE_DATE =>SYSDATE,
5394: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5388: p_url =>' ',
5389: p_kb_delete=>'N',
5390: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5391: p_CREATION_DATE =>SYSDATE,
5392: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5393: p_LAST_UPDATE_DATE =>SYSDATE,
5394: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5395: p_ATTRIBUTE1 =>null,
5396: p_ATTRIBUTE2 =>null,
5390: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5391: p_CREATION_DATE =>SYSDATE,
5392: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5393: p_LAST_UPDATE_DATE =>SYSDATE,
5394: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5395: p_ATTRIBUTE1 =>null,
5396: p_ATTRIBUTE2 =>null,
5397: p_ATTRIBUTE3 =>null,
5398: p_ATTRIBUTE4 =>null,
5557: from IEM_EMAIL_CLASSIFICATIONS
5558: WHERE MESSAGE_ID=l_msg_id AND EMAIL_ACCOUNT_ID=l_email_account_id
5559: and classification_id=l_classification_id;
5560: IF l_repos is null then
5561: l_search_repos:=FND_PROFILE.VALUE_SPECIFIC('IEM_KNOWLEDGE_BASE');
5562: IF l_search_repos is null then
5563: l_search_repos:='MES';
5564: END IF;
5565: else
5618: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
5619: p_score =>to_char(l_result_array(l_count).score),
5620: p_url =>l_result_array(l_count).url_string,
5621: p_kb_delete=>'N',
5622: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5623: p_CREATION_DATE =>SYSDATE,
5624: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5625: p_LAST_UPDATE_DATE =>SYSDATE,
5626: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5620: p_url =>l_result_array(l_count).url_string,
5621: p_kb_delete=>'N',
5622: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5623: p_CREATION_DATE =>SYSDATE,
5624: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5625: p_LAST_UPDATE_DATE =>SYSDATE,
5626: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5627: p_ATTRIBUTE1 =>null,
5628: p_ATTRIBUTE2 =>null,
5622: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5623: p_CREATION_DATE =>SYSDATE,
5624: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5625: p_LAST_UPDATE_DATE =>SYSDATE,
5626: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5627: p_ATTRIBUTE1 =>null,
5628: p_ATTRIBUTE2 =>null,
5629: p_ATTRIBUTE3 =>null,
5630: p_ATTRIBUTE4 =>null,
5692: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
5693: p_score =>to_char(l_result_array(l_count).score),
5694: p_url =>l_result_array(l_count).url_string,
5695: p_kb_delete=>'N',
5696: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5697: p_CREATION_DATE =>SYSDATE,
5698: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5699: p_LAST_UPDATE_DATE =>SYSDATE,
5700: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5694: p_url =>l_result_array(l_count).url_string,
5695: p_kb_delete=>'N',
5696: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5697: p_CREATION_DATE =>SYSDATE,
5698: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5699: p_LAST_UPDATE_DATE =>SYSDATE,
5700: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5701: p_ATTRIBUTE1 =>null,
5702: p_ATTRIBUTE2 =>null,
5696: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5697: p_CREATION_DATE =>SYSDATE,
5698: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5699: p_LAST_UPDATE_DATE =>SYSDATE,
5700: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5701: p_ATTRIBUTE1 =>null,
5702: p_ATTRIBUTE2 =>null,
5703: p_ATTRIBUTE3 =>null,
5704: p_ATTRIBUTE4 =>null,
5780: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
5781: p_score =>to_char(l_result_array(l_count).score),
5782: p_url =>l_result_array(l_count).url_string,
5783: p_kb_delete=>'N',
5784: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5785: p_CREATION_DATE =>SYSDATE,
5786: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5787: p_LAST_UPDATE_DATE =>SYSDATE,
5788: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5782: p_url =>l_result_array(l_count).url_string,
5783: p_kb_delete=>'N',
5784: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5785: p_CREATION_DATE =>SYSDATE,
5786: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5787: p_LAST_UPDATE_DATE =>SYSDATE,
5788: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5789: p_ATTRIBUTE1 =>null,
5790: p_ATTRIBUTE2 =>null,
5784: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5785: p_CREATION_DATE =>SYSDATE,
5786: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5787: p_LAST_UPDATE_DATE =>SYSDATE,
5788: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5789: p_ATTRIBUTE1 =>null,
5790: p_ATTRIBUTE2 =>null,
5791: p_ATTRIBUTE3 =>null,
5792: p_ATTRIBUTE4 =>null,
5854: p_doc_last_modified_date=>l_result_array(l_count).last_update_date,
5855: p_score =>to_char(l_result_array(l_count).score),
5856: p_url =>l_result_array(l_count).url_string,
5857: p_kb_delete=>'N',
5858: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5859: p_CREATION_DATE =>SYSDATE,
5860: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5861: p_LAST_UPDATE_DATE =>SYSDATE,
5862: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5856: p_url =>l_result_array(l_count).url_string,
5857: p_kb_delete=>'N',
5858: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5859: p_CREATION_DATE =>SYSDATE,
5860: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5861: p_LAST_UPDATE_DATE =>SYSDATE,
5862: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5863: p_ATTRIBUTE1 =>null,
5864: p_ATTRIBUTE2 =>null,
5858: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5859: p_CREATION_DATE =>SYSDATE,
5860: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
5861: p_LAST_UPDATE_DATE =>SYSDATE,
5862: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
5863: p_ATTRIBUTE1 =>null,
5864: p_ATTRIBUTE2 =>null,
5865: p_ATTRIBUTE3 =>null,
5866: p_ATTRIBUTE4 =>null,
6847: THEN
6848: FND_MSG_PUB.initialize;
6849: END IF;
6850:
6851: FND_PROFILE.Get('IEM_SR_SUM_PREFIX', l_summary_prefix);
6852: l_summary := l_summary_prefix||' : '|| p_subject ;
6853:
6854: l_logmessage:='customer _id is '|| g_customer_id ;
6855: iem_logger(l_logmessage);
6932:
6933: l_service_request_rec.caller_type := l_party_type; -- 'ORGANIZATION'/'PERSON';
6934: --needed attributes
6935: --get the severity id from profile; if its null then default to 4
6936: l_service_request_rec.severity_id := nvl(TO_NUMBER(FND_PROFILE.VALUE('CS_DEFAULT_WEB_INC_SEVERITY')),4);
6937: --l_service_request_rec.severity_id := 4;
6938: --l_service_request_rec.status_id := 1;
6939:
6940: l_service_request_rec.type_id := l_type_id;
6969: WHERE ic.category_id = c.category_id
6970: AND t.category_id (+) = c.category_id
6971: AND t.language (+) = userenv('LANG')
6972: AND ic.category_set_id = cs.category_set_id
6973: AND ic.category_set_id = fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET')
6974: AND itc.inventory_item_id = l_inventory_item_id
6975: AND itc.category_id = c.category_id
6976: AND itc.category_set_id = ic.category_set_id
6977: AND itc.organization_id = cs_std.Get_Item_Valdn_Orgzn_Id
7001:
7002: END IF;
7003:
7004: If l_category_id IS NOT NULL THEN
7005: l_service_request_rec.category_set_id := fnd_profile.value('CS_SR_DEFAULT_CATEGORY_SET');
7006: l_service_request_rec.category_id := l_category_id;
7007:
7008: END IF;
7009:
7105: l_service_request_rec.ship_to_account_id :=l_billship_account;
7106: END IF;
7107: --end of bug 12663292
7108:
7109: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');
7110: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
7111:
7112: l_logmessage:='start calling service request' ;
7113: iem_logger(l_logmessage);
7106: END IF;
7107: --end of bug 12663292
7108:
7109: l_auto_assign := fnd_profile.value('CS_AUTO_ASSIGN_OWNER_HTML');
7110: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
7111:
7112: l_logmessage:='start calling service request' ;
7113: iem_logger(l_logmessage);
7114: --dbms_output.put_line(l_logmessage);
7120: x_msg_count => l_msg_count,
7121: x_msg_data => l_msg_data,
7122: p_resp_appl_id => NULL,
7123: p_resp_id => NULL,
7124: p_user_id => nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1),
7125: --p_user_id => 1318,
7126: p_login_id => NULL,
7127: p_org_id => NULL,
7128: p_request_id => NULL,
8807: BEGIN
8808: select DISTINCT inventory_item_id, organization_id
8809: into x_inventory_item_id, x_inventory_org_id
8810: from mtl_system_items_b
8811: where organization_id=FND_PROFILE.value('CS_INV_VALIDATION_ORG') and
8812: upper(segment1)= upper(p_inventory_item_name);
8813:
8814: l_logmessage:='inventoryItemName is '||p_inventory_item_name||' inventory_item_id is '|| x_inventory_item_id;
8815: iem_logger(l_logmessage);