eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_TRANSFER_DOCUMENT dependencies on AR_DOC_TRANSFER_STANDARD

Line 10: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateSource(+)'); end if;

6: select 'x' from ra_customer_trx where customer_trx_id = p_doc_rec.source_id;
7: l_exists varchar2(1);
8: l_retcode boolean := false;
9: begin
10: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateSource(+)'); end if;
11: if p_doc_rec.source_table = 'RA_CUSTOMER_TRX' then
12: open trx; fetch trx into l_exists; close trx;
13: if l_exists is null then l_retcode := false;
14: else l_retcode := true; end if;

Line 26: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;

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;
29: end;
30:

Line 27: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateSource(-)'); end if;

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;
29: end;
30:
31: function validateTpSource(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

Line 37: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTpSource(+)'); end if;

33: select 'x' from hz_party_sites where party_site_id = p_doc_rec.tp_source_id;
34: l_exists varchar2(1);
35: l_retcode boolean := false;
36: begin
37: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTpSource(+)'); end if;
38: if p_doc_rec.tp_source_table = 'HZ_PARTY_SITES' then
39: open tp; fetch tp into l_exists; close tp;
40: if l_exists is null then l_retcode := false;
41: else l_retcode := true; end if;

Line 53: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;

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;
56: end;
57:

Line 54: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTpSource(-)'); end if;

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;
56: end;
57:
58: function validateEventName(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

Line 64: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateEventName(+)'); end if;

60: select 'x' from wf_events where name = p_doc_rec.event_name and status = 'ENABLED' and type = 'EVENT';
61: l_exists varchar2(1);
62: l_retcode boolean := false;
63: begin
64: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateEventName(+)'); end if;
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

Line 76: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;

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;
79: end;
80:

Line 77: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateEventName(-)'); end if;

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;
79: end;
80:
81: function validateTrx(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

Line 102: if ar_doc_transfer_standard.isDebugOn then

98: tph.tp_header_id = tpd.tp_header_id and
99: tpd.ext_process_id = proc.ext_process_id;
100:
101: begin
102: if ar_doc_transfer_standard.isDebugOn then
103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');
104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);
105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);
106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);

Line 103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');

99: tpd.ext_process_id = proc.ext_process_id;
100:
101: begin
102: if ar_doc_transfer_standard.isDebugOn then
103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');
104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);
105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);
106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);
107: ar_doc_transfer_standard.debug('p_doc_rec.tp_source_id:'||p_doc_rec.tp_source_id);

Line 104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);

100:
101: begin
102: if ar_doc_transfer_standard.isDebugOn then
103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');
104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);
105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);
106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);
107: ar_doc_transfer_standard.debug('p_doc_rec.tp_source_id:'||p_doc_rec.tp_source_id);
108: end if;

Line 105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);

101: begin
102: if ar_doc_transfer_standard.isDebugOn then
103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');
104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);
105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);
106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);
107: ar_doc_transfer_standard.debug('p_doc_rec.tp_source_id:'||p_doc_rec.tp_source_id);
108: end if;
109:

Line 106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);

102: if ar_doc_transfer_standard.isDebugOn then
103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');
104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);
105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);
106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);
107: ar_doc_transfer_standard.debug('p_doc_rec.tp_source_id:'||p_doc_rec.tp_source_id);
108: end if;
109:
110: open ecxTrx; fetch ecxTrx into l_exists; close ecxTrx;

Line 107: ar_doc_transfer_standard.debug('p_doc_rec.tp_source_id:'||p_doc_rec.tp_source_id);

103: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(+)');
104: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_type:'||p_doc_rec.ecx_trx_type);
105: ar_doc_transfer_standard.debug('p_doc_rec.ecx_trx_subtype:'||p_doc_rec.ecx_trx_subtype);
106: ar_doc_transfer_standard.debug('p_doc_rec.ecx_party_type:'||p_doc_rec.ecx_party_type);
107: ar_doc_transfer_standard.debug('p_doc_rec.tp_source_id:'||p_doc_rec.tp_source_id);
108: end if;
109:
110: open ecxTrx; fetch ecxTrx into l_exists; close ecxTrx;
111: if l_exists is null then l_retcode := false;

Line 113: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_exists:'||l_exists); end if;

109:
110: open ecxTrx; fetch ecxTrx into l_exists; close ecxTrx;
111: if l_exists is null then l_retcode := false;
112: else l_retcode := true; end if;
113: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_exists:'||l_exists); end if;
114: if not l_retcode then
115: fnd_message.set_name('AR', 'AR_DOC_TRS_INV_TP_SETUP');
116: fnd_message.set_token('DOCUMENT_TRANSFER_ID', p_doc_rec.document_transfer_id);
117: p_doc_rec.status := 'FAILED';

Line 121: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;

117: p_doc_rec.status := 'FAILED';
118: p_doc_rec.exception_type := 'AR';
119: p_doc_rec.exception_message := fnd_message.get;
120: end if;
121: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;
122: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(-)'); end if;
123: return l_retcode;
124: end;
125:

Line 122: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(-)'); end if;

118: p_doc_rec.exception_type := 'AR';
119: p_doc_rec.exception_message := fnd_message.get;
120: end if;
121: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('STATUS:'||p_doc_rec.status); end if;
122: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validateTrx(-)'); end if;
123: return l_retcode;
124: end;
125:
126: procedure validate_document_record(p_doc_rec in out nocopy ar_document_transfers%rowtype) is

Line 128: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validate_document_record(+)'); end if;

124: end;
125:
126: procedure validate_document_record(p_doc_rec in out nocopy ar_document_transfers%rowtype) is
127: begin
128: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validate_document_record(+)'); end if;
129: if not validateSource(p_doc_rec) then return; end if;
130: if not validateTpSource(p_doc_rec) then return; end if;
131: if not validateEventName(p_doc_rec) then return; end if;
132: if not validateTrx(p_doc_rec) then return; end if;

Line 133: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validate_document_record(-)');end if;

129: if not validateSource(p_doc_rec) then return; end if;
130: if not validateTpSource(p_doc_rec) then return; end if;
131: if not validateEventName(p_doc_rec) then return; end if;
132: if not validateTrx(p_doc_rec) then return; end if;
133: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.validate_document_record(-)');end if;
134: end;
135:
136: procedure notifyToAr(p_event_name in varchar2,
137: p_subject in varchar2,

Line 145: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyAr(+)'); end if;

141: p_exception_type in varchar2) is
142: l_url varchar2(200);
143:
144: begin
145: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyAr(+)'); end if;
146:
147: l_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=ARDOCTRSPG'||'&'||
148: 'akRegionApplicationId=222'||'&'||
149: 'Query=Y'||'&'||

Line 160: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyAr(-)'); end if;

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;
161: end;
162:
163: procedure notifyToSysadmin(p_event_name in varchar2,
164: p_subject in varchar2,

Line 175: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyToSysadmin(+)'); end if;

171: from fnd_responsibility_tl
172: where application_id = 1;
173: l_url varchar2(200);
174: begin
175: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyToSysadmin(+)'); end if;
176: l_url := 'JSP:/OA_HTML/OA.jsp?akRegionCode=ARDOCTRSPG'||'&'||
177: 'akRegionApplicationId=222'||'&'||
178: 'Query=Y'||'&'||
179: 'ExceptionType=SYSTEM';

Line 191: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyToSysadmin(-)'); end if;

187: p_url => l_url,
188: p_user_area1 => p_request_id,
189: p_user_area2 => p_exception_type);
190: end loop;
191: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notifyToSysadmin(-)'); end if;
192: end;
193:
194: procedure notify(p_event_name in varchar2,
195: p_subject in varchar2,

Line 201: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notify(+)'); end if;

197: p_doc_proc in varchar2,
198: p_request_id in number,
199: p_exception_type in varchar2) is
200: begin
201: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notify(+)'); end if;
202: if p_exception_type = 'SYSTEM' then
203: notifyToSysadmin(p_event_name,
204: p_subject,
205: p_doc_pkg,

Line 224: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notify(-)'); end if;

220: p_doc_proc,
221: p_request_id,
222: p_exception_type);
223: end if;
224: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.notify(-)'); end if;
225: end;
226:
227: procedure transfer_documents(errbuf out NOCOPY varchar2,
228: retcode out NOCOPY varchar2) is

Line 244: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(+)'); end if;

240: l_trx_type varchar2(100);
241: l_trx_subtype varchar2(100);
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

Line 249: ar_doc_transfer_standard.raiseTransferEvent(

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,
251: p_trx_type => doc_rec.ecx_trx_type,
252: p_trx_sub_type => doc_rec.ecx_trx_subtype,
253: p_party_id => null,

Line 275: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.transfer_documents(-)'); end if;

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;
276:
277: exception
278: when others then
279: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||

Line 286: if ar_doc_transfer_standard.isDebugOn then

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;
289: ar_notification_standard.notifyToSysadmin(l_subject,
290: l_sqlerrm);

Line 287: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENTS.transfer_documents()EXCEPTION:'||l_sqlerrm);

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;
289: ar_notification_standard.notifyToSysadmin(l_subject,
290: l_sqlerrm);
291: end;

Line 309: if ar_doc_transfer_standard.isDebugOn then

305: where exception_type = l_exception_type;
306: --where request_id = l_request_id and exception_type = l_exception_type;
307:
308: begin
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);

Line 310: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');

306: --where request_id = l_request_id and exception_type = l_exception_type;
307:
308: begin
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);

Line 325: if ar_doc_transfer_standard.isDebugOn then

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(-)');
327: end if;
328: end;
329:

Line 326: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(-)');

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(-)');
327: end if;
328: end;
329:
330: procedure build_batch_error_message( document_id in varchar2,

Line 346: if ar_doc_transfer_standard.isDebugOn then

342: where exception_type = l_exception_type;
343: --where request_id = l_request_id and exception_type = l_exception_type;
344:
345: begin
346: if ar_doc_transfer_standard.isDebugOn then
347: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');
348: end if;
349: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');
350:

Line 347: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');

343: --where request_id = l_request_id and exception_type = l_exception_type;
344:
345: begin
346: if ar_doc_transfer_standard.isDebugOn then
347: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(+)');
348: end if;
349: fnd_message.set_name('AR', 'AR_DOC_TRS_BODY');
350:
351: ar_notification_standard.parseDocumentId(document_id, l_item_type, l_item_key);

Line 365: if ar_doc_transfer_standard.isDebugOn then

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
366: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(-)');
367: end if;
368: end;
369:

Line 366: ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT.build_batch_error_message(-)');

362: l_buffer;
363: document_type := 'text/plain';
364:
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: end;
369:
370:

Line 372: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT(+)'); end if;

368: end;
369:
370:
371: begin
372: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT(+)'); end if;
373: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT(-)'); end if;
374: end;

Line 373: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT(-)'); end if;

369:
370:
371: begin
372: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT(+)'); end if;
373: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_TRANSFER_DOCUMENT(-)'); end if;
374: end;