DBA Data[Home] [Help]

APPS.AR_EXTRACT_DOCUMENT dependencies on AR_EXTRACT_DOCUMENT

Line 1: package body ar_extract_document as

1: package body ar_extract_document as
2: /*$Header: AREXTDCB.pls 120.11 2011/10/24 16:49:55 rravikir ship $ */
3: /*Removed gscc warnings NOCOPY hint Bug 4462243*/
4: procedure extract_documents(errbuf out NOCOPY varchar2,
5: retcode out NOCOPY varchar2,

Line 40: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(+)'); end if;

36: trx.PRINTING_ORIGINAL_DATE is null and
37: trx.LAST_PRINTED_SEQUENCE_NUM is null;
38:
39: begin
40: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(+)'); end if;
41: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(+)'); end if;
42: l_trx_class := argument1;
43: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_trx_class:'||l_trx_class); end if;
44: l_trx_type_id := argument2;

Line 41: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(+)'); end if;

37: trx.LAST_PRINTED_SEQUENCE_NUM is null;
38:
39: begin
40: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(+)'); end if;
41: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(+)'); end if;
42: l_trx_class := argument1;
43: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_trx_class:'||l_trx_class); end if;
44: l_trx_type_id := argument2;
45: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('l_trx_type_id:'||to_char(l_trx_type_id)); end if;

Line 136: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(-)');

132: LAST_PRINTED_SEQUENCE_NUM is null;
133:
134: retcode := 0; -- SUCCESS
135: if ar_doc_transfer_standard.isDebugOn then
136: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(-)');
137: end if;
138:
139: exception
140: when no_data_found then

Line 142: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(): NO Invoice Fetched');

138:
139: exception
140: when no_data_found then
141: if ar_doc_transfer_standard.isDebugOn then
142: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(): NO Invoice Fetched');
143: end if;
144:
145: when others then
146: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||

Line 147: 'Location: AR_EXTRACT_DOCUMENT.extract_documents()'||fnd_global.newline||

143: end if;
144:
145: when others then
146: l_sqlerrm := sqlerrm(sqlcode) || fnd_global.newline ||
147: 'Location: AR_EXTRACT_DOCUMENT.extract_documents()'||fnd_global.newline||
148: 'Time: '||to_char(sysdate, 'DD-MON-RRRR HH:MI:SS');
149: retcode := 2;
150: fnd_message.set_name('AR','AR_DOC_EXT_SBJ');
151: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);

Line 154: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents()EXCEPTION:'||l_sqlerrm);

150: fnd_message.set_name('AR','AR_DOC_EXT_SBJ');
151: fnd_message.set_token('REQUEST_ID', fnd_global.conc_request_id);
152: l_subject := fnd_message.get;
153: if ar_doc_transfer_standard.isDebugOn then
154: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents()EXCEPTION:'||l_sqlerrm);
155: end if;
156: ar_notification_standard.notifyToSysadmin(l_subject,
157: l_sqlerrm);
158: end;

Line 160: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(+)'); end if;

156: ar_notification_standard.notifyToSysadmin(l_subject,
157: l_sqlerrm);
158: end;
159: begin
160: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(+)'); end if;
161: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(-)'); end if;
162: end;

Line 161: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(-)'); end if;

157: l_sqlerrm);
158: end;
159: begin
160: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(+)'); end if;
161: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(-)'); end if;
162: end;