APPS.AR_TRANSFER_DOCUMENT dependencies on AR_DOCUMENT_TRANSFERS

Line 4: function validateSource(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

1: package body ar_transfer_document as
2: /*$Header: ARTRSDCB.pls 115.7 2002/12/23 22:45:11 tkoshio noship $ */
3:
4: function validateSource(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is
5: cursor trx is
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;

Line 31: function validateTpSource(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

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
32: cursor tp is
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;

Line 58: function validateEventName(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

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
59: cursor event is
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;

Line 81: function validateTrx(p_doc_rec in out nocopy ar_document_transfers%rowtype) return boolean is

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
82:
83: l_exists varchar2(1);
84: l_retcode boolean := false;
85:

Line 126: procedure validate_document_record(p_doc_rec in out nocopy ar_document_transfers%rowtype) is

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

Line 231: select * from ar_document_transfers where status = 'WAITING';

227: procedure transfer_documents(errbuf out NOCOPY varchar2,
228: retcode out NOCOPY varchar2) is
229:
230: cursor doc_trs is
231: select * from ar_document_transfers where status = 'WAITING';
232:
233: cursor err_trs is
234: select distinct exception_type from ar_document_transfers
235: where status = 'FAILED';

Line 234: select distinct exception_type from ar_document_transfers

230: cursor doc_trs is
231: select * from ar_document_transfers where status = 'WAITING';
232:
233: cursor err_trs is
234: select distinct exception_type from ar_document_transfers
235: where status = 'FAILED';
236:
237: l_subject varchar2(100);
238: l_sqlerrm varchar2(1000);

Line 304: select exception_message from ar_document_transfers

300: l_request_id number;
301: l_exception_type varchar2(30);
302:
303: cursor err_csr is
304: select exception_message from ar_document_transfers
305: where exception_type = l_exception_type;
306: --where request_id = l_request_id and exception_type = l_exception_type;
307:
308: begin

Line 341: select exception_message from ar_document_transfers

337: l_request_id number;
338: l_exception_type varchar2(30);
339:
340: cursor err_csr is
341: select exception_message from ar_document_transfers
342: where exception_type = l_exception_type;
343: --where request_id = l_request_id and exception_type = l_exception_type;
344:
345: begin