DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on FND_GLOBAL

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

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

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

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

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

146: l_filedir := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_DIR_NAME');
147: l_filename := PO_COMMUNICATION_PVT.get_preparer_profile(p_document_id,p_document_type,'PO_EMAIL_TERMS_FILE_NAME');
148:
149: --bug#4278861: populate l_newline with new line value from FND_GLOBAL
150: select fnd_global.NEWLINE into l_newline from dual;
151:
152: if ((l_filedir is not null) and (l_filename is not null)) then
153:
154: /* 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 165: l_filename_lang := l_filename || '_' || fnd_global.base_language;

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