DBA Data[Home] [Help]

APPS.AR_TRANSFER_DOCUMENT dependencies on FND_GLOBAL

Line 156: p_role_name => 'FND_RESP222:'||to_char(fnd_global.resp_id),

152: p_event_name => p_event_name,
153: p_subject => p_subject,
154: p_doc_pkg => p_doc_pkg,
155: p_doc_proc => p_doc_proc,
156: p_role_name => 'FND_RESP222:'||to_char(fnd_global.resp_id),
157: p_url => l_url,
158: p_user_area1 => p_request_id,
159: p_user_area2 => p_exception_type);
160: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyAr(-)'); end if;

Line 246: doc_rec.request_id := fnd_global.conc_request_id;

242:
243: begin
244: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(+)'); end if;
245: for doc_rec in doc_trs loop
246: doc_rec.request_id := fnd_global.conc_request_id;
247: validate_document_record(doc_rec);
248: if doc_rec.status = 'WAITING' then
249: ar_doc_transfer_standard.raiseTransferEvent(
250: p_event_name => doc_rec.event_name,

Line 264: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);

260: end loop;
261: for err_rec in err_trs loop
262: if l_subject is null then
263: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');
264: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
265: l_subject := fnd_message.get;
266: end if;
267: notify(p_event_name => 'oracle.apps.ar.transmit.notification',
268: p_subject => l_subject,

Line 271: p_request_id => fnd_global.conc_request_id,

267: notify(p_event_name => 'oracle.apps.ar.transmit.notification',
268: p_subject => l_subject,
269: p_doc_pkg => 'AR_TRANSFER_DOCUMENT',
270: p_doc_proc => 'BUILD_BATCH_ERROR_MESSAGE',
271: p_request_id => fnd_global.conc_request_id,
272: p_exception_type => err_rec.exception_type);
273: end loop;
274: retcode := 0;
275: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(-)'); end if;

Line 279: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||

275: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(-)'); end if;
276:
277: exception
278: when others then
279: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
280: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||
281: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
282: retcode := 2;
283: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');

Line 280: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||

276:
277: exception
278: when others then
279: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
280: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||
281: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
282: retcode := 2;
283: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');
284: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);

Line 284: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);

280: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||
281: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
282: retcode := 2;
283: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');
284: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
285: l_subject := fnd_message.get;
286: if ar_doc_transfer_standard.isDebugOn then
287: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENTS.transfer_documents()EXCEPTION:'||l_sqlerrm);
288: end if;

Line 313: WF_NOTIFICATION.WriteToClob(document,fnd_message.get||fnd_global.newline||fnd_global.newline);

309: if ar_doc_transfer_standard.isDebugOn then
310: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');
311: end if;
312: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');
313: WF_NOTIFICATION.WriteToClob(document,fnd_message.get||fnd_global.newline||fnd_global.newline);
314: ar_notification_standard.parseDocumentId(document_id, l_item_type, l_item_key);
315: l_request_id := wf_engine.getItemAttrText(itemType => l_item_type,
316: itemKey => l_item_key,
317: aname => 'USER_AREA1');

Line 322: WF_NOTIFICATION.WriteToClob(document, err_rec.exception_message||fnd_global.newline);

318: l_exception_type := wf_engine.getItemAttrText(itemType => l_item_type,
319: itemKey => l_item_key,
320: aname => 'USER_AREA2');
321: for err_rec in err_csr loop
322: WF_NOTIFICATION.WriteToClob(document, err_rec.exception_message||fnd_global.newline);
323: end loop;
324: document_type := 'text/plain';
325: if ar_doc_transfer_standard.isDebugOn then
326: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(-)');

Line 359: l_buffer := l_buffer ||err_rec.exception_message||fnd_global.newline;

355: l_exception_type := wf_engine.getItemAttrText(itemType => l_item_type,
356: itemKey => l_item_key,
357: aname => 'USER_AREA2');
358: for err_rec in err_csr loop
359: l_buffer := l_buffer ||err_rec.exception_message||fnd_global.newline;
360: end loop;
361: document := fnd_message.get||fnd_global.newline||fnd_global.newline ||
362: l_buffer;
363: document_type := 'text/plain';

Line 361: document := fnd_message.get||fnd_global.newline||fnd_global.newline ||

357: aname => 'USER_AREA2');
358: for err_rec in err_csr loop
359: l_buffer := l_buffer ||err_rec.exception_message||fnd_global.newline;
360: end loop;
361: document := fnd_message.get||fnd_global.newline||fnd_global.newline ||
362: l_buffer;
363: document_type := 'text/plain';
364:
365: if ar_doc_transfer_standard.isDebugOn then