APPS.AHL_PRD_PRINT_PVT dependencies on FND_PROFILE

Line 64: upgrade_tz_id = fnd_profile.VALUE('SERVER_TIMEZONE_ID');

60: timezone_code
61: FROM
62: fnd_timezones_vl
63: WHERE
64: upgrade_tz_id = fnd_profile.VALUE('SERVER_TIMEZONE_ID');
65:
66: CURSOR c_get_tz_offset(c_tz_code IN VARCHAR2)
67: IS
68: SELECT substr(tz_offset(c_tz_code),0,6)

Line 1819: x_file_location := FND_PROFILE.VALUE('AHL_ENIGMA_PDF_LOCATION') || x_file_location;

1815:
1816: OPEN get_file_location_csr(p_object_type,p_object_id);
1817: FETCH get_file_location_csr into x_file_location;
1818: IF(get_file_location_csr%FOUND)THEN
1819: x_file_location := FND_PROFILE.VALUE('AHL_ENIGMA_PDF_LOCATION') || x_file_location;
1820: END IF;
1821: CLOSE get_file_location_csr;
1822:
1823: RETURN x_file_location;

Line 3071: p_dir := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH');

3067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3068: END IF;
3069: END IF;
3070:
3071: p_dir := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH');
3072: x_file_name := p_object_type ||'-' || p_object_id || '-' || TO_CHAR(SYSDATE,'dd-Mon-yyyy-hh24-mi-ss') || '.xml';
3073:
3074: IF (l_log_statement >= l_log_current_level)THEN
3075: fnd_log.string (

Line 4138: l_xml_file_name := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH') ||'/' ||l_xml_file_name;

4134: RAISE FND_API.G_EXC_ERROR;
4135: END IF;
4136:
4137: fnd_file.put_line(FND_FILE.LOG,'Preparing to request Enigma to print');
4138: l_xml_file_name := FND_PROFILE.VALUE('AHL_ENIGMA_JCG_XML_FILEPATH') ||'/' ||l_xml_file_name;
4139:
4140: /*l_xmldocument := ''||
4141: ''|| + l_xml_file_name ||''||
4142: --'JCG'-- fnd_global.user_name

Line 4177: l_bpel_process_end_point := FND_PROFILE.VALUE('AHL_ENIGMA_JCGHBPEL_EPOINT');

4173:
4174:
4175: ';
4176: /* invoke BPEL process AhlTestJCGHandlerService - populate from profile*/
4177: l_bpel_process_end_point := FND_PROFILE.VALUE('AHL_ENIGMA_JCGHBPEL_EPOINT');
4178: --l_bpel_process_end_point := 'http://rws60140rems.us.oracle.com:7777/orabpel/Ebsmh0yd212domain1/AhlJCGHandlerService/1.0';
4179:
4180: fnd_file.put_line(FND_FILE.LOG,'BPEL process Address:' || l_bpel_process_end_point);
4181: fnd_file.put_line(FND_FILE.LOG,'XML file name for printing: :' || l_xml_file_name);