DBA Data[Home] [Help]

APPS.AR_DOC_TRANSFER_STANDARD dependencies on AR_DOC_TRANSFER_STANDARD

Line 1: package body ar_doc_transfer_standard as

1: package body ar_doc_transfer_standard as
2: /*$Header: ARDOCTFB.pls 120.10.12000000.4 2007/08/17 14:24:12 nproddut ship $ */
3:
4: PG_DEBUG varchar2(1);
5: PG_DEBUG_PATH varchar2(1000);

Line 52: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.otaCallBackRule(+)'); end if;

48: l_msg varchar2(4000);
49: l_returnCode varchar2(240);
50: l_errType varchar2(10);
51: begin
52: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.otaCallBackRule(+)'); end if;
53:
54: l_msgid := p_event.getValueForParameter('ECX_MSGID');
55: l_extType := p_event.getValueForParameter('ECX_TRANSACTION_TYPE');
56: l_extSubType := p_event.getValueForParameter('ECX_TRANSACTION_SUBTYPE');

Line 71: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.otaCallBackRule(-)'); end if;

67: exception_message = decode(l_returnCode, '0', null, l_msg),
68: exception_type = l_errType
69: where document_msgid = l_msgid;
70: end if;
71: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.otaCallBackRule(-)'); end if;
72: return 'SUCCESS';
73: exception
74: when others then
75: if isDebugOn then

Line 76: debug('AR_DOC_TRANSFER_STANDARD.otaCallBackRule(Exception)');

72: return 'SUCCESS';
73: exception
74: when others then
75: if isDebugOn then
76: debug('AR_DOC_TRANSFER_STANDARD.otaCallBackRule(Exception)');
77: debug(sqlerrm);
78: end if;
79: return 'ERROR';
80: end;

Line 103: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.updateStatus(+)'); end if;

99:
100:
101: procedure updateStatus is
102: begin
103: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.updateStatus(+)'); end if;
104: /*
105: update ar_document_transfers doc
106: set doc.status = 'TRANSMITTED'
107: where doc.status = 'STARTED' and

Line 131: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.updateStatus(-)');end if;

127: ecx.party_site_id = doc.tp_source_id and
128: ecx.out_msgid = doc.document_msgid and
129: ltrim(rtrim(ecx.delivery_status)) <> '0');
130: */
131: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.updateStatus(-)');end if;
132: end;
133:
134:
135: procedure email_transfer( ITEMTYPE IN VARCHAR2,

Line 141: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.email_transfer(-)');end if;

137: ACTID IN NUMBER,
138: FUNCMODE IN VARCHAR2,
139: RESULTOUT IN OUT NOCOPY VARCHAR2) is
140: begin
141: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.email_transfer(-)');end if;
142: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.email_transfer(-)');end if;
143: end;
144:
145: procedure edi_transfer( ITEMTYPE IN VARCHAR2,

Line 142: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.email_transfer(-)');end if;

138: FUNCMODE IN VARCHAR2,
139: RESULTOUT IN OUT NOCOPY VARCHAR2) is
140: begin
141: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.email_transfer(-)');end if;
142: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.email_transfer(-)');end if;
143: end;
144:
145: procedure edi_transfer( ITEMTYPE IN VARCHAR2,
146: ITEMKEY IN VARCHAR2,

Line 151: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.edi_transfer(-)');end if;

147: ACTID IN NUMBER,
148: FUNCMODE IN VARCHAR2,
149: RESULTOUT IN OUT NOCOPY VARCHAR2) is
150: begin
151: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.edi_transfer(-)');end if;
152: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.edi_transfer(-)');end if;
153: end;
154:
155:

Line 152: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.edi_transfer(-)');end if;

148: FUNCMODE IN VARCHAR2,
149: RESULTOUT IN OUT NOCOPY VARCHAR2) is
150: begin
151: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.edi_transfer(-)');end if;
152: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.edi_transfer(-)');end if;
153: end;
154:
155:
156: procedure xml_transfer( ITEMTYPE IN VARCHAR2,

Line 176: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.xml_transfer(+)');end if;

172: l_org_id NUMBER;
173:
174:
175: begin
176: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.xml_transfer(+)');end if;
177:
178: l_doc_transfer_id := wf_engine.getItemAttrText(itemtype,
179: itemkey,
180: 'ECX_DOCUMENT_ID');

Line 250: debug('AR_DOC_TRANSFER_STANDARD.xml_transfer(-)');

246: end if;
247: ar_document_transfer_pkg.updateRow(doc_rec);
248: resultout := 'COMPLETE';
249: if isDebugOn then
250: debug('AR_DOC_TRANSFER_STANDARD.xml_transfer(-)');
251: end if;
252: end;
253:
254: procedure raiseTransferEvent(p_event_name in VARCHAR2,

Line 266: debug('AR_DOC_TRANSFER_STANDARD.raiseTransferEvent(+)');

262: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
263: l_itemkey varchar2(100);
264: begin
265: if isDebugOn then
266: debug('AR_DOC_TRANSFER_STANDARD.raiseTransferEvent(+)');
267: debug('p_event_name:'||p_event_name);
268: debug('p_trx_type:'||p_trx_type);
269: debug('p_trx_sub_type:'||p_trx_sub_type);
270: debug('p_party_id:'||p_party_id);

Line 319: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.raiseTransferEvent(-)'); end if;

315: p_event_key => l_itemkey,
316: p_parameters => l_parameter_list);
317:
318: l_parameter_list.DELETE;
319: if isDebugOn then debug('AR_DOC_TRANSFER_STANDARD.raiseTransferEvent(-)'); end if;
320: end;
321:
322: begin
323: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');