DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on FND_GLOBAL

Line 140: /* fnd_global.APPS_INITIALIZE (p_user_id, p_resp_id, p_appl_id);

136: begin
137:
138: /* initialize APPS context */
139: /*Bug 6692126 Call procedure get_preparer_profile instead of getting profile options in preparers context*/
140: /* fnd_global.APPS_INITIALIZE (p_user_id, p_resp_id, p_appl_id);
141: FND_PROFILE.GET('PO_EMAIL_TERMS_DIR_NAME', l_filedir);
142: FND_PROFILE.GET('PO_EMAIL_TERMS_FILE_NAME', l_filename); */
143:
144: l_filedir := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_DIR_NAME');

Line 147: --bug#4278861: populate l_newline with new line value from FND_GLOBAL

143:
144: l_filedir := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_DIR_NAME');
145: l_filename := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_FILE_NAME');
146:
147: --bug#4278861: populate l_newline with new line value from FND_GLOBAL
148: select fnd_global.NEWLINE into l_newline from dual;
149:
150: if ((l_filedir is not null) and (l_filename is not null)) then
151:

Line 148: select fnd_global.NEWLINE into l_newline from dual;

144: l_filedir := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_DIR_NAME');
145: l_filename := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_FILE_NAME');
146:
147: --bug#4278861: populate l_newline with new line value from FND_GLOBAL
148: select fnd_global.NEWLINE into l_newline from dual;
149:
150: if ((l_filedir is not null) and (l_filename is not null)) then
151:
152: /* Check for supplier site language tandc file first if that doesn't exist then check for base language tandc file else check for just l_filename */

Line 163: l_filename_lang := l_filename || '_' || fnd_global.base_language;

159:
160: EXCEPTION WHEN OTHERS THEN
161:
162: BEGIN
163: l_filename_lang := l_filename || '_' || fnd_global.base_language;
164: v_filehandle := UTL_FILE.FOPEN(l_filedir,l_filename_lang, 'r',32000); --bug#4278861: Open the file handle with 32k buffer
165:
166: EXCEPTION WHEN OTHERS THEN
167: begin