DBA Data[Home] [Help]

APPS.AR_TRANSFER_DOCUMENT dependencies on FND_GLOBAL

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

160: p_event_name => p_event_name,
161: p_subject => p_subject,
162: p_doc_pkg => p_doc_pkg,
163: p_doc_proc => p_doc_proc,
164: p_role_name => 'FND_RESP222:'||to_char(fnd_global.resp_id),
165: p_url => l_url,
166: p_user_area1 => p_request_id,
167: p_user_area2 => p_exception_type);
168: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyAr(-)'); end if;

Line 245: and request_id = fnd_global.conc_request_id;

241: cursor err_trs is
242: select distinct exception_type from ar_document_transfers
243: where status = 'FAILED'
244: --bug 6667346
245: and request_id = fnd_global.conc_request_id;
246:
247: l_subject varchar2(100);
248: l_sqlerrm varchar2(1000);
249: l_ok_rec boolean := false;

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

253:
254: begin
255: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(+)'); end if;
256: for doc_rec in doc_trs loop
257: doc_rec.request_id := fnd_global.conc_request_id;
258: validate_document_record(doc_rec);
259: if doc_rec.status = 'WAITING' then
260: ar_doc_transfer_standard.raiseTransferEvent(
261: p_event_name => doc_rec.event_name,

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

278: end loop;
279: for err_rec in err_trs loop
280: if l_subject is null then
281: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');
282: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
283: l_subject := fnd_message.get;
284: end if;
285: notify(p_event_name => 'oracle.apps.ar.transmit.notification',
286: p_subject => l_subject,

Line 289: p_request_id => fnd_global.conc_request_id,

285: notify(p_event_name => 'oracle.apps.ar.transmit.notification',
286: p_subject => l_subject,
287: p_doc_pkg => 'AR_TRANSFER_DOCUMENT',
288: p_doc_proc => 'BUILD_BATCH_ERROR_MESSAGE',
289: p_request_id => fnd_global.conc_request_id,
290: p_exception_type => err_rec.exception_type);
291: end loop;
292: retcode := 0;
293: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(-)'); end if;

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

293: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(-)'); end if;
294:
295: exception
296: when others then
297: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
298: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||
299: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
300: retcode := 2;
301: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');

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

294:
295: exception
296: when others then
297: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
298: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||
299: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
300: retcode := 2;
301: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');
302: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);

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

298: 'Location: AR_TRANSFER_DOCUMENT.transfer_documents()'||fnd_global.newline||
299: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
300: retcode := 2;
301: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');
302: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
303: l_subject := fnd_message.get;
304: if ar_doc_transfer_standard.isDebugOn then
305: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENTS.transfer_documents()EXCEPTION:'||l_sqlerrm);
306: end if;

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

327: if ar_doc_transfer_standard.isDebugOn then
328: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');
329: end if;
330: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');
331: WF_NOTIFICATION.WriteToClob(document,fnd_message.get||fnd_global.newline||fnd_global.newline);
332: ar_notification_standard.parseDocumentId(document_id, l_item_type, l_item_key);
333: l_request_id := wf_engine.getItemAttrText(itemType => l_item_type,
334: itemKey => l_item_key,
335: aname => 'USER_AREA1');

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

336: l_exception_type := wf_engine.getItemAttrText(itemType => l_item_type,
337: itemKey => l_item_key,
338: aname => 'USER_AREA2');
339: for err_rec in err_csr loop
340: WF_NOTIFICATION.WriteToClob(document, err_rec.exception_message||fnd_global.newline);
341: end loop;
342: document_type := 'text/plain';
343: if ar_doc_transfer_standard.isDebugOn then
344: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(-)');

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

374: l_exception_type := wf_engine.getItemAttrText(itemType => l_item_type,
375: itemKey => l_item_key,
376: aname => 'USER_AREA2');
377: for err_rec in err_csr loop
378: l_buffer := l_buffer ||err_rec.exception_message||fnd_global.newline;
379: end loop;
380: document := fnd_message.get||fnd_global.newline||fnd_global.newline ||
381: l_buffer;
382: document_type := 'text/plain';

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

376: aname => 'USER_AREA2');
377: for err_rec in err_csr loop
378: l_buffer := l_buffer ||err_rec.exception_message||fnd_global.newline;
379: end loop;
380: document := fnd_message.get||fnd_global.newline||fnd_global.newline ||
381: l_buffer;
382: document_type := 'text/plain';
383:
384: if ar_doc_transfer_standard.isDebugOn then