APPS.IGP_WZ_PUBLISH_TEMPLATE_PKG dependencies on FND_PROFILE

Line 268: l_protocol_port := FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER');

264: OPEN temp_dtl_cur(l_template_id,'IGP_WZ_TEMP_TYPE');
265: FETCH temp_dtl_cur INTO temp_dtl_rec;
266: CLOSE temp_dtl_cur;
267:
268: l_protocol_port := FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER');
269: l_virtual_path := FND_PROFILE.VALUE('ICX_OA_HTML');
270:
271: -- Create the preview template link dynamically from the profiles
272: /* l_protocol_port_value := SUBSTR(l_protocol_port,1,INSTR(l_protocol_port,'/',1,3));

Line 269: l_virtual_path := FND_PROFILE.VALUE('ICX_OA_HTML');

265: FETCH temp_dtl_cur INTO temp_dtl_rec;
266: CLOSE temp_dtl_cur;
267:
268: l_protocol_port := FND_PROFILE.VALUE('ICX_FORMS_LAUNCHER');
269: l_virtual_path := FND_PROFILE.VALUE('ICX_OA_HTML');
270:
271: -- Create the preview template link dynamically from the profiles
272: /* l_protocol_port_value := SUBSTR(l_protocol_port,1,INSTR(l_protocol_port,'/',1,3));
273: l_preview_link := l_protocol_port_value || l_virtual_path ||'/'||'OA.jsp?OAFunc=IGP_WZ_PREVIEW_TEMP_PAGE'||l_var||'tempId='||l_template_id;

Line 333: l_approver := FND_PROFILE.VALUE('IGP_WZ_TEMP_APPROVER');

329: avalue => l_email_address);
330:
331: -- Check that the profile for approver is set properly.
332: -- If not set throw an error
333: l_approver := FND_PROFILE.VALUE('IGP_WZ_TEMP_APPROVER');
334:
335: IF l_approver IS NULL THEN
336:
337: FND_MESSAGE.SET_NAME('IGS','IGP_WZ_TEMP_APPROVE_NO_PROF');