2181: OPEN sel_jsp_name_csr;
2182: FETCH sel_jsp_name_csr INTO l_jsp_name;
2183: CLOSE sel_jsp_name_csr;
2184:
2185: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2186: || '?srID=' || sel_link_rec.incident_number;
2187:
2188: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || sel_link_rec.incident_number;
2189: WF_ENGINE.SetItemAttrText(
2184:
2185: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2186: || '?srID=' || sel_link_rec.incident_number;
2187:
2188: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || sel_link_rec.incident_number;
2189: WF_ENGINE.SetItemAttrText(
2190: itemtype => itemtype,
2191: itemkey => itemkey,
2192: aname => 'NTFY_REQUEST_NUMBER_URL',
2511: OPEN sel_jsp_name_csr;
2512: FETCH sel_jsp_name_csr INTO l_jsp_name;
2513: CLOSE sel_jsp_name_csr;
2514:
2515: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2516: || '?srID=' || l_request_number;
2517:
2518: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || l_request_number;
2519: WF_ENGINE.SetItemAttrText(
2514:
2515: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2516: || '?srID=' || l_request_number;
2517:
2518: --l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/ibuSRDetails.jsp?srID=' || l_request_number;
2519: WF_ENGINE.SetItemAttrText(
2520: itemtype => itemtype,
2521: itemkey => itemkey,
2522: aname => 'NTFY_REQUEST_NUMBER_URL',
2906: OPEN sel_jsp_name_csr;
2907: FETCH sel_jsp_name_csr INTO l_jsp_name;
2908: CLOSE sel_jsp_name_csr;
2909:
2910: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
2911: || '?srID=' || l_request_number;
2912:
2913: WF_ENGINE.SetItemAttrText(
2914: itemtype => itemtype,
3222: OPEN sel_jsp_name_csr;
3223: FETCH sel_jsp_name_csr INTO l_jsp_name;
3224: CLOSE sel_jsp_name_csr;
3225:
3226: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3227: || '?srID=' || l_request_number;
3228: WF_ENGINE.SetItemAttrText(
3229: itemtype => itemtype,
3230: itemkey => itemkey,
3404: OPEN sel_jsp_name_csr;
3405: FETCH sel_jsp_name_csr INTO l_jsp_name;
3406: CLOSE sel_jsp_name_csr;
3407:
3408: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3409: || '?srID=' || l_request_number;
3410: WF_ENGINE.SetItemAttrText(
3411: itemtype => itemtype,
3412: itemkey => itemkey,
3682: OPEN sel_jsp_name_csr;
3683: FETCH sel_jsp_name_csr INTO l_jsp_name;
3684: CLOSE sel_jsp_name_csr;
3685:
3686: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3687: || '?srID=' || l_request_number;
3688: WF_ENGINE.SetItemAttrText(
3689: itemtype => itemtype,
3690: itemkey => itemkey,
3920: OPEN sel_jsp_name_csr;
3921: FETCH sel_jsp_name_csr INTO l_jsp_name;
3922: CLOSE sel_jsp_name_csr;
3923:
3924: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
3925: || '?srID=' || l_request_number;
3926: WF_ENGINE.SetItemAttrText(
3927: itemtype => itemtype,
3928: itemkey => itemkey,
4092: OPEN sel_jsp_name_csr;
4093: FETCH sel_jsp_name_csr INTO l_jsp_name;
4094: CLOSE sel_jsp_name_csr;
4095:
4096: l_serviceRequest_URL := FND_PROFILE.Value('JTF_BIS_OA_HTML') || '/' || l_jsp_name
4097: || '?srID=' || l_request_number;
4098: WF_ENGINE.SetItemAttrText(
4099: itemtype => itemtype,
4100: itemkey => itemkey,
6594: aname => 'SENDER_ROLE' );
6595:
6596: IF (l_role_name IS NULL) THEN
6597:
6598: l_resource_id := NVL(FND_PROFILE.VALUE('CS_SR_DEFAULT_SYSTEM_RESOURCE'), -1);
6599: OPEN l_get_source_id(l_resource_id);
6600: FETCH l_get_source_id INTO l_get_source_id_rec;
6601:
6602: l_role_name := 'CS_WF_ROLE_DUMMY';
6852: BEGIN
6853:
6854: x_return_status := FND_API.G_RET_STS_SUCCESS;
6855:
6856: l_int_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_INTERACTION_DEFAULTS');
6857:
6858: l_action_item := 'Sr';
6859: l_action := 'Automated Email Sent';
6860:
6860:
6861: l_interaction_rec := JTF_IH_PUB.INIT_INTERACTION_REC;
6862: l_activity_rec := JTF_IH_PUB.INIT_ACTIVITY_REC;
6863:
6864: l_int_profile := FND_PROFILE.Value('CS_SR_INTERACTION_LOGGING');
6865: NL := fnd_global.Local_Chr(10);
6866:
6867: IF ( l_int_profile is null or l_int_profile ='AUTO_INT_LOG' ) THEN
6868:
6867: IF ( l_int_profile is null or l_int_profile ='AUTO_INT_LOG' ) THEN
6868:
6869:
6870: IF (p_user_id is null) THEN
6871: fnd_profile.get('USER_ID', d_user_id);
6872: ELSE
6873: d_user_id := p_user_id;
6874: END IF;
6875:
6873: d_user_id := p_user_id;
6874: END IF;
6875:
6876: IF (p_login_id is null) THEN
6877: fnd_profile.get('LOGIN_ID', d_login_id);
6878: ELSE
6879: d_login_id := p_login_id;
6880: END IF;
6881:
6879: d_login_id := p_login_id;
6880: END IF;
6881:
6882: IF (p_resp_id is null) THEN
6883: fnd_profile.get('RESP_ID', d_resp_id);
6884: ELSE
6885: d_resp_id := p_resp_id;
6886: END IF;
6887:
6885: d_resp_id := p_resp_id;
6886: END IF;
6887:
6888: IF (p_resp_appl_id is null) THEN
6889: fnd_profile.get('RESP_APPL_ID', d_resp_appl_id);
6890: ELSE
6891: d_resp_appl_id := p_resp_appl_id;
6892: END IF;
6893:
6943: ****/
6944:
6945: -- Get the resource from the profile instead. Part of fix for bug 3360069.
6946: -- rmanabat 01/19/04.
6947: l_interaction_rec.resource_id := FND_PROFILE.VALUE('CS_SR_DEFAULT_SYSTEM_RESOURCE');
6948: IF (l_interaction_rec.resource_id is NULL) THEN
6949: raise l_NO_RESOURCE_FOUND;
6950: END IF;
6951:
6980:
6981: ELSE
6982:
6983:
6984: l_act_wrapup_id := FND_PROFILE.Value('CSC_CC_WRAPUP_ACTIVITY_DEFAULTS');
6985:
6986: IF (l_act_wrapup_id is not null) THEN
6987: -- Get the Activity defaults
6988: p_wrap_id := l_act_wrapup_id;
7719: || p_contact_type || l_amp||'IBULanguage=' || p_user_language ;
7720:
7721: -- Get the host
7722:
7723: FND_PROFILE.GET('APPS_FRAMEWORK_AGENT',l_host);
7724:
7725: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
7726: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_WF_AUTO_NTFY_UPDATE_PKG.SET_HTML_NOTIFICATION_DETAILS')) THEN
7727:
7739: END IF;
7740:
7741: -- bug 5661159
7742: IF lower(substr(nvl(l_host, ''), 1, 5)) = 'https' THEN
7743: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));
7744: END IF;
7745: -- bug 5661159_eof
7746:
7747: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);