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.9 2006/04/05 13:44:02 nsomawar noship $ */
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 133: ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT.extract_documents(-)');

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

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

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

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

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

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

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

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

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

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

154: l_sqlerrm);
155: end;
156: begin
157: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(+)'); end if;
158: if ar_doc_transfer_standard.isDebugOn then ar_doc_transfer_standard.debug('AR_EXTRACT_DOCUMENT(-)'); end if;
159: end;