88:
89: BEGIN
90:
91: IF PG_DEBUG in ('Y', 'C') THEN
92: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry()+');
93: END IF;
94:
95: /*-----------------------------------------------------------------------+
96: |Dump the document record details usefull for debugging purposes. |
95: /*-----------------------------------------------------------------------+
96: |Dump the document record details usefull for debugging purposes. |
97: +-----------------------------------------------------------------------*/
98: IF PG_DEBUG in ('Y', 'C') THEN
99: arp_standard.debug( ' Document Type :' || p_ae_doc_rec.document_type);
100: arp_standard.debug( ' Document Id :' || p_ae_doc_rec.document_id);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
96: |Dump the document record details usefull for debugging purposes. |
97: +-----------------------------------------------------------------------*/
98: IF PG_DEBUG in ('Y', 'C') THEN
99: arp_standard.debug( ' Document Type :' || p_ae_doc_rec.document_type);
100: arp_standard.debug( ' Document Id :' || p_ae_doc_rec.document_id);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
97: +-----------------------------------------------------------------------*/
98: IF PG_DEBUG in ('Y', 'C') THEN
99: arp_standard.debug( ' Document Type :' || p_ae_doc_rec.document_type);
100: arp_standard.debug( ' Document Id :' || p_ae_doc_rec.document_id);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
98: IF PG_DEBUG in ('Y', 'C') THEN
99: arp_standard.debug( ' Document Type :' || p_ae_doc_rec.document_type);
100: arp_standard.debug( ' Document Id :' || p_ae_doc_rec.document_id);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
99: arp_standard.debug( ' Document Type :' || p_ae_doc_rec.document_type);
100: arp_standard.debug( ' Document Id :' || p_ae_doc_rec.document_id);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
100: arp_standard.debug( ' Document Id :' || p_ae_doc_rec.document_id);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
101: arp_standard.debug( ' Accounting Entity Level :' || p_ae_doc_rec.accounting_entity_level);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
102: arp_standard.debug( ' Source Table :' || p_ae_doc_rec.source_table);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
103: arp_standard.debug( ' Source Id :' || p_ae_doc_rec.source_id);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
104: arp_standard.debug( ' Source Id Old :' || p_ae_doc_rec.source_id_old);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
105: arp_standard.debug( ' Other Flag :' || p_ae_doc_rec.other_flag);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
106: arp_standard.debug( ' Miscel1 :' || p_ae_doc_rec.miscel1);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
107: arp_standard.debug( ' Miscel2 :' || p_ae_doc_rec.miscel2);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
108: arp_standard.debug( ' Miscel3 :' || p_ae_doc_rec.miscel3);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
109: arp_standard.debug( ' Miscel4 :' || p_ae_doc_rec.miscel4);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
110: arp_standard.debug( ' Miscel5 :' || p_ae_doc_rec.miscel5);
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
111: arp_standard.debug( ' Miscel6 :' || p_ae_doc_rec.miscel6);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
119: arp_standard.debug( ' p_from_llca_call :' || p_from_llca_call);
112: arp_standard.debug( ' Miscel7 :' || p_ae_doc_rec.miscel7);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
119: arp_standard.debug( ' p_from_llca_call :' || p_from_llca_call);
120: arp_standard.debug( ' p_gt_id :' || p_gt_id);
113: arp_standard.debug( ' Miscel8 :' || p_ae_doc_rec.miscel8);
114: arp_standard.debug( ' Event :' || p_ae_doc_rec.event);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
119: arp_standard.debug( ' p_from_llca_call :' || p_from_llca_call);
120: arp_standard.debug( ' p_gt_id :' || p_gt_id);
121: arp_standard.debug( ' p_called_from :' || p_called_from);
115: arp_standard.debug( ' Deferred Tax :' || p_ae_doc_rec.deferred_tax);
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
119: arp_standard.debug( ' p_from_llca_call :' || p_from_llca_call);
120: arp_standard.debug( ' p_gt_id :' || p_gt_id);
121: arp_standard.debug( ' p_called_from :' || p_called_from);
122: --}
123: END IF;
116: arp_standard.debug( ' Called_from :' || p_ae_doc_rec.called_from);
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
119: arp_standard.debug( ' p_from_llca_call :' || p_from_llca_call);
120: arp_standard.debug( ' p_gt_id :' || p_gt_id);
121: arp_standard.debug( ' p_called_from :' || p_called_from);
122: --}
123: END IF;
124: /* Bug fix 2300268 : Added debug message*/
117: arp_standard.debug( ' Tax account id :' || p_ae_doc_rec.gl_tax_acct);
118: --{HYUDETUPT
119: arp_standard.debug( ' p_from_llca_call :' || p_from_llca_call);
120: arp_standard.debug( ' p_gt_id :' || p_gt_id);
121: arp_standard.debug( ' p_called_from :' || p_called_from);
122: --}
123: END IF;
124: /* Bug fix 2300268 : Added debug message*/
125: /* Bug 13625713, Creating missing distribution for APP row of application. */
125: /* Bug 13625713, Creating missing distribution for APP row of application. */
126: FOR l_miss_rec_app IN get_miss_rec_app LOOP
127: --This cursor will return only one row.
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug('Creating missing distribution corresponding to APP row of application.');
130: arp_standard.debug('Only if: ');
131: arp_standard.debug(' 1. Receipt is upgraded from 11i.');
132: arp_standard.debug(' 2. Application done in 11i');
133: arp_standard.debug(' 3. Receipt posted in 11i using cash basis accounting.');
126: FOR l_miss_rec_app IN get_miss_rec_app LOOP
127: --This cursor will return only one row.
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug('Creating missing distribution corresponding to APP row of application.');
130: arp_standard.debug('Only if: ');
131: arp_standard.debug(' 1. Receipt is upgraded from 11i.');
132: arp_standard.debug(' 2. Application done in 11i');
133: arp_standard.debug(' 3. Receipt posted in 11i using cash basis accounting.');
134: arp_standard.debug(' 4. Doing Unapplication in R12.');
127: --This cursor will return only one row.
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug('Creating missing distribution corresponding to APP row of application.');
130: arp_standard.debug('Only if: ');
131: arp_standard.debug(' 1. Receipt is upgraded from 11i.');
132: arp_standard.debug(' 2. Application done in 11i');
133: arp_standard.debug(' 3. Receipt posted in 11i using cash basis accounting.');
134: arp_standard.debug(' 4. Doing Unapplication in R12.');
135: END IF;
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_standard.debug('Creating missing distribution corresponding to APP row of application.');
130: arp_standard.debug('Only if: ');
131: arp_standard.debug(' 1. Receipt is upgraded from 11i.');
132: arp_standard.debug(' 2. Application done in 11i');
133: arp_standard.debug(' 3. Receipt posted in 11i using cash basis accounting.');
134: arp_standard.debug(' 4. Doing Unapplication in R12.');
135: END IF;
136: arp_acct_main.create_Acct_entry('RECEIPT',
129: arp_standard.debug('Creating missing distribution corresponding to APP row of application.');
130: arp_standard.debug('Only if: ');
131: arp_standard.debug(' 1. Receipt is upgraded from 11i.');
132: arp_standard.debug(' 2. Application done in 11i');
133: arp_standard.debug(' 3. Receipt posted in 11i using cash basis accounting.');
134: arp_standard.debug(' 4. Doing Unapplication in R12.');
135: END IF;
136: arp_acct_main.create_Acct_entry('RECEIPT',
137: l_miss_rec_app.cash_receipt_id,
130: arp_standard.debug('Only if: ');
131: arp_standard.debug(' 1. Receipt is upgraded from 11i.');
132: arp_standard.debug(' 2. Application done in 11i');
133: arp_standard.debug(' 3. Receipt posted in 11i using cash basis accounting.');
134: arp_standard.debug(' 4. Doing Unapplication in R12.');
135: END IF;
136: arp_acct_main.create_Acct_entry('RECEIPT',
137: l_miss_rec_app.cash_receipt_id,
138: 'ONE',
145: 'N',
146: null);
147:
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_standard.debug('Matching the amount of the newly created REC row in ARD');
150: END IF;
151:
152: Select count(*)
153: INTO l_amount_flag
162: WHERE a.amount = b.amount;
163:
164: IF l_amount_flag = 0 THEN
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_standard.debug('Amounts in ARD is not matching with AR_CASH_BASIS_DISTS.');
167: END IF;
168: RAISE INVALID_AMOUNT_EROR;
169: END IF;
170:
168: RAISE INVALID_AMOUNT_EROR;
169: END IF;
170:
171: IF PG_DEBUG in ('Y', 'C') THEN
172: arp_standard.debug('Updating CCID of newly created row in ARD');
173: END IF;
174: END LOOP;
175:
176: Init_Curr_Details(p_accounting_method => l_accounting_method);
176: Init_Curr_Details(p_accounting_method => l_accounting_method);
177:
178:
179: IF PG_DEBUG in ('Y', 'C') THEN
180: arp_standard.debug( 'ARP_ACCT_MAIN - Accounting Method ' || l_accounting_method);
181: END IF;
182:
183: -- bug5655154, commented accounting_method = 'ACCRUAL' check
184: -- IF l_accounting_method = 'ACCRUAL' THEN
183: -- bug5655154, commented accounting_method = 'ACCRUAL' check
184: -- IF l_accounting_method = 'ACCRUAL' THEN
185:
186: IF PG_DEBUG in ('Y', 'C') THEN
187: arp_standard.debug( 'Create_Acct_Entry - Processing Accounting Method ' || l_accounting_method);
188: END IF;
189:
190: /*---------------------------------------------------------------------------+
191: |Determine whether we really need to create accounting, in the case of MCD |
198: AND (p_ae_doc_rec.source_table <> 'MCD')) THEN
199: BEGIN
200:
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry - check whether accounting required ');
203: END IF;
204:
205: select 'N'
206: into l_create_acct
210: where dist.source_id = p_ae_doc_rec.source_id
211: and dist.source_table = p_ae_doc_rec.source_table);
212:
213: IF PG_DEBUG in ('Y', 'C') THEN
214: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry - accounting already exists');
215: END IF;
216:
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
216:
217: EXCEPTION
218: WHEN NO_DATA_FOUND THEN
219: IF PG_DEBUG in ('Y', 'C') THEN
220: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry - creating accounting ');
221: END IF;
222: l_create_acct := 'Y';
223: END;
224:
225: END IF; --end if check accounting required
226: END IF;
227:
228: IF PG_DEBUG in ('Y', 'C') THEN
229: arp_standard.debug( 'l_create_acct = ' || l_create_acct);
230: END IF;
231:
232: IF (l_create_acct = 'N') THEN
233: IF PG_DEBUG in ('Y', 'C') THEN
230: END IF;
231:
232: IF (l_create_acct = 'N') THEN
233: IF PG_DEBUG in ('Y', 'C') THEN
234: arp_standard.debug( 'Ending Processing for l_create_acct = ' || l_create_acct);
235: END IF;
236: GOTO end_process_lbl;
237: END IF;
238:
363: -- END IF; --end if ACCRUAL method of accounting
364:
365: <
366: IF PG_DEBUG in ('Y', 'C') THEN
367: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry()-');
368: END IF;
369:
370: EXCEPTION
371: WHEN INVALID_AMOUNT_EROR THEN
372: fnd_message.set_name('AR','AR_AMOUNTS_NO_MATCH');
373: RAISE;
374: WHEN OTHERS THEN
375: IF PG_DEBUG in ('Y', 'C') THEN
376: arp_standard.debug( 'EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry');
377: END IF;
378: IF p_client_server IS NULL THEN
379: app_exception.raise_exception;
380: ELSE
412: l_ae_event_rec ae_event_rec_type ;
413:
414: BEGIN
415: IF PG_DEBUG in ('Y', 'C') THEN
416: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Create_Acct_Entry()+');
417: END IF;
418:
419: Create_Acct_Entry(p_mode => l_mode,
420: p_ae_doc_rec => p_ae_doc_rec,
424: p_gt_id => p_gt_id,
425: p_called_from => p_called_from );
426:
427: IF PG_DEBUG in ('Y', 'C') THEN
428: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Create_Acct_Entry()-');
429: END IF;
430:
431: EXCEPTION
432: WHEN OTHERS THEN
430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: IF PG_DEBUG in ('Y', 'C') THEN
434: arp_standard.debug( 'EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry');
435: END IF;
436: RAISE;
437: END Create_Acct_Entry;
438:
476:
477: BEGIN
478:
479: IF PG_DEBUG in ('Y', 'C') THEN
480: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()+');
481: END IF;
482:
483: l_ae_doc_rec.document_type := p_document_type ;
484: l_ae_doc_rec.document_id := p_document_id ;
495: p_from_llca_call=> p_from_llca_call,
496: p_gt_id => p_gt_id);
497:
498: IF PG_DEBUG in ('Y', 'C') THEN
499: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()-');
500: END IF;
501:
502: EXCEPTION
503: WHEN OTHERS THEN
501:
502: EXCEPTION
503: WHEN OTHERS THEN
504: IF PG_DEBUG in ('Y', 'C') THEN
505: arp_standard.debug( 'EXCEPTION: Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry');
506: END IF;
507: RAISE;
508:
509: END Create_Acct_Entry;
552:
553: BEGIN
554:
555: IF PG_DEBUG in ('Y', 'C') THEN
556: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()+');
557: END IF;
558:
559: l_ae_doc_rec.document_type := p_document_type ;
560: l_ae_doc_rec.document_id := p_document_id ;
572: p_from_llca_call => p_from_llca_call,
573: p_gt_id => p_gt_id);
574:
575: IF PG_DEBUG in ('Y', 'C') THEN
576: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()-');
577: END IF;
578:
579: EXCEPTION
580: WHEN OTHERS THEN
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: IF PG_DEBUG in ('Y', 'C') THEN
582: arp_standard.debug( 'EXCEPTION: Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry');
583: END IF;
584: RAISE;
585:
586: END Create_Acct_Entry;
610: ) IS
611: BEGIN
612:
613: IF PG_DEBUG in ('Y', 'C') THEN
614: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ai_Exceptions()+');
615: END IF;
616:
617: IF p_document_type = 'ADJUSTMENT' THEN
618:
621: MESSAGE_TEXT,
622: INVALID_VALUE,
623: ORG_ID )
624: SELECT il.interface_line_id,
625: arp_standard.fnd_message(p_message_code),
626: trx.customer_trx_id,
627: il.org_id
628: FROM RA_INTERFACE_LINES_GT il,
629: AR_ADJUSTMENTS adj,
641: MESSAGE_TEXT,
642: INVALID_VALUE,
643: ORG_ID )
644: SELECT il.interface_line_id,
645: arp_standard.fnd_message(p_message_code),
646: trx.customer_trx_id,
647: il.org_id
648: FROM RA_INTERFACE_LINES_GT il,
649: RA_CUSTOMER_TRX trx
654:
655: END IF;
656:
657: IF PG_DEBUG in ('Y', 'C') THEN
658: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ai_Exceptions()-');
659: END IF;
660:
661: END;
662:
715:
716: BEGIN
717:
718: IF PG_DEBUG in ('Y', 'C') THEN
719: arp_standard.debug( 'Overloaded2 ARP_ACCT_MAIN.Create_Acct_Entry()+');
720: END IF;
721:
722: IF (p_called_from = 'AUTOREC' ) THEN
723: IF PG_DEBUG in ('Y', 'C') THEN
720: END IF;
721:
722: IF (p_called_from = 'AUTOREC' ) THEN
723: IF PG_DEBUG in ('Y', 'C') THEN
724: arp_standard.debug( 'calling for AUTO RECEIPTS');
725: END IF;
726:
727: l_ae_doc_rec.document_type := 'RECEIPT';
728: l_ae_doc_rec.accounting_entity_level := 'ONE';
986: --
987: */
988: END IF;
989: IF PG_DEBUG in ('Y', 'C') THEN
990: arp_standard.debug( 'Overloaded2 ARP_ACCT_MAIN.Create_Acct_Entry()-');
991: END IF;
992:
993: END Create_Acct_Entry;
994:
1018: l_accounting_method ar_system_parameters.accounting_method%TYPE;
1019:
1020: BEGIN
1021: IF PG_DEBUG in ('Y', 'C') THEN
1022: arp_standard.debug( 'ARP_ACCT_MAIN.Delete_Acct_Entry()+');
1023: END IF;
1024:
1025: Init_Curr_Details(p_accounting_method => l_accounting_method);
1026:
1024:
1025: Init_Curr_Details(p_accounting_method => l_accounting_method);
1026:
1027: IF PG_DEBUG in ('Y', 'C') THEN
1028: arp_standard.debug( 'ARP_ACCT_MAIN - Accounting Method ' || l_accounting_method);
1029: END IF;
1030:
1031: --begin 5655154, commented the accounting_method = 'ACCRUAL' check
1032: -- IF l_accounting_method = 'ACCRUAL' THEN
1031: --begin 5655154, commented the accounting_method = 'ACCRUAL' check
1032: -- IF l_accounting_method = 'ACCRUAL' THEN
1033: --end 5655154
1034: IF PG_DEBUG in ('Y', 'C') THEN
1035: arp_standard.debug( 'Delete_Acct_Entry - Processing Accounting Method ' || l_accounting_method);
1036: END IF;
1037: /*------------------------------------------------------+
1038: | Delete Accounting for Document |
1039: +------------------------------------------------------*/
1068: -- END IF; --end if Accounting method is accrual
1069: --end 5655154
1070:
1071: IF PG_DEBUG in ('Y', 'C') THEN
1072: arp_standard.debug( 'ARP_ACCT_MAIN.Delete_Acct_Entry()-');
1073: END IF;
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: IF PG_DEBUG in ('Y', 'C') THEN
1078: arp_standard.debug( 'EXCEPTION: ARP_ACCT_MAIN.Delete_Acct_Entry');
1079: END IF;
1080: RAISE;
1081:
1082: END Delete_Acct_Entry;
1102: l_ae_event_rec ae_event_rec_type ;
1103:
1104: BEGIN
1105: IF PG_DEBUG in ('Y', 'C') THEN
1106: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry()+');
1107: END IF;
1108:
1109: Delete_Acct_Entry(l_mode, p_ae_doc_rec, l_ae_event_rec);
1110:
1108:
1109: Delete_Acct_Entry(l_mode, p_ae_doc_rec, l_ae_event_rec);
1110:
1111: IF PG_DEBUG in ('Y', 'C') THEN
1112: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry()-');
1113: END IF;
1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN
1114:
1115: EXCEPTION
1116: WHEN OTHERS THEN
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_standard.debug( 'EXCEPTION: Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry');
1119: END IF;
1120: RAISE;
1121:
1122: END Delete_Acct_Entry;
1149: l_ae_doc_rec ae_doc_rec_type;
1150:
1151: BEGIN
1152: IF PG_DEBUG in ('Y', 'C') THEN
1153: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry()+');
1154: END IF;
1155:
1156: l_ae_doc_rec.document_type := p_document_type ;
1157: l_ae_doc_rec.document_id := p_document_id ;
1165:
1166: p_source_id_old := l_ae_doc_rec.source_id_old;
1167:
1168: IF PG_DEBUG in ('Y', 'C') THEN
1169: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry()-');
1170: END IF;
1171:
1172: EXCEPTION
1173: WHEN OTHERS THEN
1171:
1172: EXCEPTION
1173: WHEN OTHERS THEN
1174: IF PG_DEBUG in ('Y', 'C') THEN
1175: arp_standard.debug( 'EXCEPTION: Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry');
1176: END IF;
1177: RAISE;
1178:
1179: END Delete_Acct_Entry;
1200:
1201: BEGIN
1202:
1203: IF PG_DEBUG in ('Y', 'C') THEN
1204: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ae_Lines()+');
1205: END IF;
1206:
1207:
1208: -- Insert AE Lines
1257: Dump_Dist_Amts(l_ae_line_rec);
1258:
1259:
1260: IF PG_DEBUG in ('Y', 'C') THEN
1261: arp_standard.debug( 'sob type = ' || ARP_ACCT_MAIN.ae_sys_rec.sob_type);
1262: END IF;
1263:
1264: IF (NVL(ARP_ACCT_MAIN.ae_sys_rec.sob_type,'P') = 'P') THEN
1265: arp_distributions_pkg.insert_p(l_ae_line_rec, l_dummy);
1266: END IF;
1267: END LOOP;
1268:
1269: IF PG_DEBUG in ('Y', 'C') THEN
1270: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ae_Lines()-');
1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: IF PG_DEBUG in ('Y', 'C') THEN
1276: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.Insert_Ae_Lines');
1277: END IF;
1278: RAISE;
1279:
1280: END Insert_Ae_Lines;
1293: PROCEDURE Dump_Dist_Amts(p_ae_line_rec IN ar_distributions%ROWTYPE) IS
1294: BEGIN
1295:
1296: IF PG_DEBUG in ('Y', 'C') THEN
1297: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()+');
1298: END IF;
1299:
1300: IF PG_DEBUG in ('Y', 'C') THEN
1301: arp_standard.debug( 'set_of_books_id = ' || ARP_ACCT_MAIN.ae_sys_rec.set_of_books_id);
1297: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()+');
1298: END IF;
1299:
1300: IF PG_DEBUG in ('Y', 'C') THEN
1301: arp_standard.debug( 'set_of_books_id = ' || ARP_ACCT_MAIN.ae_sys_rec.set_of_books_id);
1302: arp_standard.debug( 'source_type = ' || p_ae_line_rec.source_type);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1298: END IF;
1299:
1300: IF PG_DEBUG in ('Y', 'C') THEN
1301: arp_standard.debug( 'set_of_books_id = ' || ARP_ACCT_MAIN.ae_sys_rec.set_of_books_id);
1302: arp_standard.debug( 'source_type = ' || p_ae_line_rec.source_type);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1299:
1300: IF PG_DEBUG in ('Y', 'C') THEN
1301: arp_standard.debug( 'set_of_books_id = ' || ARP_ACCT_MAIN.ae_sys_rec.set_of_books_id);
1302: arp_standard.debug( 'source_type = ' || p_ae_line_rec.source_type);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1300: IF PG_DEBUG in ('Y', 'C') THEN
1301: arp_standard.debug( 'set_of_books_id = ' || ARP_ACCT_MAIN.ae_sys_rec.set_of_books_id);
1302: arp_standard.debug( 'source_type = ' || p_ae_line_rec.source_type);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1301: arp_standard.debug( 'set_of_books_id = ' || ARP_ACCT_MAIN.ae_sys_rec.set_of_books_id);
1302: arp_standard.debug( 'source_type = ' || p_ae_line_rec.source_type);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1302: arp_standard.debug( 'source_type = ' || p_ae_line_rec.source_type);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1303: arp_standard.debug( 'source_type_secondary = ' || p_ae_line_rec.source_type_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1304: arp_standard.debug( 'source_id = ' || p_ae_line_rec.source_id);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1305: arp_standard.debug( 'source_table = ' || p_ae_line_rec.source_table);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1306: arp_standard.debug( 'code_combination_id = ' || p_ae_line_rec.code_combination_id);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1307: arp_standard.debug( 'amount_dr = ' || p_ae_line_rec.amount_dr);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1308: arp_standard.debug( 'amount_cr = ' || p_ae_line_rec.amount_cr);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1309: arp_standard.debug( 'acctd_amount_dr = ' || p_ae_line_rec.acctd_amount_dr);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1310: arp_standard.debug( 'acctd_amount_cr = ' || p_ae_line_rec.acctd_amount_cr);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1311: arp_standard.debug( 'source_id_secondary = ' || p_ae_line_rec.source_id_secondary);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1312: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1313: arp_standard.debug( 'source_table_secondary = ' || p_ae_line_rec.source_table_secondary);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1314: arp_standard.debug( 'currency_code = ' || p_ae_line_rec.currency_code);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1315: arp_standard.debug( 'currency_conversion_rate = ' || p_ae_line_rec.currency_conversion_rate);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1316: arp_standard.debug( 'currency_conversion_type = ' || p_ae_line_rec.currency_conversion_type);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1317: arp_standard.debug( 'currency_conversion_date = ' || p_ae_line_rec.currency_conversion_date);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1318: arp_standard.debug( 'third_party_id = ' || p_ae_line_rec.third_party_id);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1319: arp_standard.debug( 'third_party_sub_id = ' || p_ae_line_rec.third_party_sub_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1320: arp_standard.debug( 'tax_group_code_id = ' || p_ae_line_rec.tax_group_code_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1321: arp_standard.debug( 'tax_code_id = ' || p_ae_line_rec.tax_code_id);
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1322: arp_standard.debug( 'location_segment_id = ' || p_ae_line_rec.location_segment_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1323: arp_standard.debug( 'taxable_entered_dr = ' || p_ae_line_rec.taxable_entered_dr);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1324: arp_standard.debug( 'taxable_entered_cr = ' || p_ae_line_rec.taxable_entered_cr);
1325: arp_standard.debug( 'taxable_accounted_dr = ' || p_ae_line_rec.taxable_accounted_dr);
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1326: arp_standard.debug( 'taxable_accounted_cr = ' || p_ae_line_rec.taxable_accounted_cr);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1327: arp_standard.debug( 'tax_link_id = ' || p_ae_line_rec.tax_link_id);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1328: arp_standard.debug( 'reversed_source_id = ' || p_ae_line_rec.reversed_source_id);
1329: --{2979254
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1330: arp_standard.debug( 'ref_customer_trx_line_id = ' || p_ae_line_rec.ref_customer_trx_line_id);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1331: arp_standard.debug( 'ref_prev_cust_trx_line_id = ' || p_ae_line_rec.ref_prev_cust_trx_line_id);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1332: arp_standard.debug( 'ref_cust_trx_line_gl_dist_id = '
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1333: || p_ae_line_rec.ref_cust_trx_line_gl_dist_id);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1341: arp_standard.debug( 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
1334: arp_standard.debug( 'ref_line_id = ' || p_ae_line_rec.ref_line_id);
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1341: arp_standard.debug( 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
1342: --}
1335: arp_standard.debug( 'from_amount_dr = ' || p_ae_line_rec.from_amount_dr);
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1341: arp_standard.debug( 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
1342: --}
1343:
1336: arp_standard.debug( 'from_amount_cr = ' || p_ae_line_rec.from_amount_cr);
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1341: arp_standard.debug( 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
1342: --}
1343:
1344: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()-');
1337: arp_standard.debug( 'from_acctd_amount_dr = ' || p_ae_line_rec.from_acctd_amount_dr);
1338: arp_standard.debug( 'from_acctd_amount_cr = ' || p_ae_line_rec.from_acctd_amount_cr);
1339: arp_standard.debug( 'ref_account_class = ' || p_ae_line_rec.ref_account_class);
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1341: arp_standard.debug( 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
1342: --}
1343:
1344: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()-');
1345: END IF;
1340: arp_standard.debug( 'activity_bucket = ' || p_ae_line_rec.activity_bucket);
1341: arp_standard.debug( 'ref_dist_ccid = ' || p_ae_line_rec.ref_dist_ccid);
1342: --}
1343:
1344: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()-');
1345: END IF;
1346:
1347: EXCEPTION
1348: WHEN OTHERS THEN
1346:
1347: EXCEPTION
1348: WHEN OTHERS THEN
1349: IF PG_DEBUG in ('Y', 'C') THEN
1350: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.Dump_Dist_Amts');
1351: END IF;
1352: RAISE;
1353:
1354: END Dump_Dist_Amts;
1367:
1368: BEGIN
1369:
1370: IF PG_DEBUG in ('Y', 'C') THEN
1371: arp_standard.debug('ARP_ACCT_MAIN.Init_Curr_Details(+)');
1372: END IF;
1373:
1374: SELECT sob.set_of_books_id,
1375: sob.chart_of_accounts_id,
1399: ae_sys_rec.sob_type := 'P';
1400: --}
1401:
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_standard.debug('ARP_ACCT_MAIN.Init_Curr_Details(-)');
1404: END IF;
1405:
1406: EXCEPTION
1407: WHEN NO_DATA_FOUND THEN
1405:
1406: EXCEPTION
1407: WHEN NO_DATA_FOUND THEN
1408: IF PG_DEBUG in ('Y', 'C') THEN
1409: arp_standard.debug('ARP_ACCT_MAIN.Init_Curr_Details - NO_DATA_FOUND' );
1410: END IF;
1411: RAISE;
1412:
1413: WHEN OTHERS THEN
1411: RAISE;
1412:
1413: WHEN OTHERS THEN
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.constructor(-)');
1416: arp_standard.debug(SQLERRM);
1417: END IF;
1418: RAISE;
1419:
1412:
1413: WHEN OTHERS THEN
1414: IF PG_DEBUG in ('Y', 'C') THEN
1415: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.constructor(-)');
1416: arp_standard.debug(SQLERRM);
1417: END IF;
1418: RAISE;
1419:
1420: END Init_Curr_Details;