DBA Data[Home] [Help]

APPS.AR_TRANSFER_DOCUMENT dependencies on FND_MESSAGE

Line 20: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_SRC_TBL_ID');

16: l_retcode := false;
17: end if;
18:
19: if not l_retcode then
20: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_SRC_TBL_ID');
21: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
22: p_doc_rec.status := 'FAILED';
23: p_doc_rec.exception_type := 'SYSTEM';
24: p_doc_rec.exception_message := fnd_message.get;

Line 21: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);

17: end if;
18:
19: if not l_retcode then
20: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_SRC_TBL_ID');
21: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
22: p_doc_rec.status := 'FAILED';
23: p_doc_rec.exception_type := 'SYSTEM';
24: p_doc_rec.exception_message := fnd_message.get;
25: end if;

Line 24: p_doc_rec.exception_message := fnd_message.get;

20: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_SRC_TBL_ID');
21: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
22: p_doc_rec.status := 'FAILED';
23: p_doc_rec.exception_type := 'SYSTEM';
24: p_doc_rec.exception_message := fnd_message.get;
25: end if;
26: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;
27: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateSource(-)'); end if;
28: return l_retcode;

Line 47: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SRC_TBL_ID');

43: l_retcode := false;
44: end if;
45:
46: if not l_retcode then
47: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SRC_TBL_ID');
48: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
49: p_doc_rec.status := 'FAILED';
50: p_doc_rec.exception_type := 'SYSTEM';
51: p_doc_rec.exception_message := fnd_message.get;

Line 48: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);

44: end if;
45:
46: if not l_retcode then
47: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SRC_TBL_ID');
48: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
49: p_doc_rec.status := 'FAILED';
50: p_doc_rec.exception_type := 'SYSTEM';
51: p_doc_rec.exception_message := fnd_message.get;
52: end if;

Line 51: p_doc_rec.exception_message := fnd_message.get;

47: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SRC_TBL_ID');
48: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
49: p_doc_rec.status := 'FAILED';
50: p_doc_rec.exception_type := 'SYSTEM';
51: p_doc_rec.exception_message := fnd_message.get;
52: end if;
53: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;
54: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTpSource(-)'); end if;
55: return l_retcode;

Line 69: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_BUS_EVENT');

65: open event; fetch event into l_exists; close event;
66: if l_exists is null then l_retcode := false;
67: else l_retcode := true; end if;
68: if not l_retcode then
69: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_BUS_EVENT');
70: fnd_message.set_token('EVENT_NAME', p_doc_rec.event_name);
71: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
72: p_doc_rec.status := 'FAILED';
73: p_doc_rec.exception_type := 'AR';

Line 70: fnd_message.set_token('EVENT_NAME', p_doc_rec.event_name);

66: if l_exists is null then l_retcode := false;
67: else l_retcode := true; end if;
68: if not l_retcode then
69: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_BUS_EVENT');
70: fnd_message.set_token('EVENT_NAME', p_doc_rec.event_name);
71: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
72: p_doc_rec.status := 'FAILED';
73: p_doc_rec.exception_type := 'AR';
74: p_doc_rec.exception_message := fnd_message.get;

Line 71: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);

67: else l_retcode := true; end if;
68: if not l_retcode then
69: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_BUS_EVENT');
70: fnd_message.set_token('EVENT_NAME', p_doc_rec.event_name);
71: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
72: p_doc_rec.status := 'FAILED';
73: p_doc_rec.exception_type := 'AR';
74: p_doc_rec.exception_message := fnd_message.get;
75: end if;

Line 74: p_doc_rec.exception_message := fnd_message.get;

70: fnd_message.set_token('EVENT_NAME', p_doc_rec.event_name);
71: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
72: p_doc_rec.status := 'FAILED';
73: p_doc_rec.exception_type := 'AR';
74: p_doc_rec.exception_message := fnd_message.get;
75: end if;
76: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;
77: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateEventName(-)'); end if;
78: return l_retcode;

Line 123: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SETUP');

119: if l_exists is null then l_retcode := false;
120: else l_retcode := true; end if;
121: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_exists:'||l_exists); end if;
122: if not l_retcode then
123: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SETUP');
124: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
125: p_doc_rec.status := 'FAILED';
126: p_doc_rec.exception_type := 'AR';
127: p_doc_rec.exception_message := fnd_message.get;

Line 124: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);

120: else l_retcode := true; end if;
121: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_exists:'||l_exists); end if;
122: if not l_retcode then
123: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SETUP');
124: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
125: p_doc_rec.status := 'FAILED';
126: p_doc_rec.exception_type := 'AR';
127: p_doc_rec.exception_message := fnd_message.get;
128: end if;

Line 127: p_doc_rec.exception_message := fnd_message.get;

123: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SETUP');
124: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
125: p_doc_rec.status := 'FAILED';
126: p_doc_rec.exception_type := 'AR';
127: p_doc_rec.exception_message := fnd_message.get;
128: end if;
129: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;
130: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(-)'); end if;
131: return l_retcode;

Line 281: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');

277: end if;
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',

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 283: l_subject := fnd_message.get;

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,
287: p_doc_pkg => 'AR_TRANSFER_DOCUMENT',

Line 301: fnd_message.set_name('AR','AR_DOC_TRS_SBJ');

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);
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);

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 303: l_subject := fnd_message.get;

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;
307: ar_notification_standard.notifyToSysadmin(l_subject,

Line 330: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');

326: begin
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,

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 368: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');

364: begin
365: if ar_doc_transfer_standard.isDebugOn then
366: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');
367: end if;
368: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');
369:
370: ar_notification_standard.parseDocumentId(document_id, l_item_type, l_item_key);
371: l_request_id := wf_engine.getItemAttrText(itemType => l_item_type,
372: itemKey => l_item_key,

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