DBA Data[Home] [Help]

APPS.ARP_ACCT_MAIN dependencies on ARP_ACCT_MAIN

Line 1: PACKAGE BODY ARP_ACCT_MAIN AS

1: PACKAGE BODY ARP_ACCT_MAIN AS
2: /* $Header: ARTACCMB.pls 120.26.12020000.2 2012/07/25 13:52:50 kkikkise ship $ */
3:
4: /*========================================================================
5: | Prototype Declarations

Line 92: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry()+');

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

Line 136: arp_acct_main.create_Acct_entry('RECEIPT',

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',
139: 'RA',
140: l_miss_rec_app.receivable_application_id,

Line 180: arp_standard.debug( 'ARP_ACCT_MAIN - 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

Line 202: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry - check whether accounting required ');

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

Line 214: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry - accounting already exists');

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

Line 220: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry - creating accounting ');

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:

Line 367: arp_standard.debug( 'ARP_ACCT_MAIN.Create_Acct_Entry()-');

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

Line 376: arp_standard.debug( 'EXCEPTION: ARP_ACCT_MAIN.Create_Acct_Entry');

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

Line 416: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Create_Acct_Entry()+');

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,

Line 428: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Create_Acct_Entry()-');

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

Line 434: arp_standard.debug( 'EXCEPTION: Overloaded ARP_ACCT_MAIN.Create_Acct_Entry');

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:

Line 480: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()+');

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 ;

Line 499: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()-');

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

Line 505: arp_standard.debug( 'EXCEPTION: Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry');

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;

Line 556: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.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 ;

Line 576: arp_standard.debug( 'Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry()-');

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

Line 582: arp_standard.debug( 'EXCEPTION: Overloaded1 ARP_ACCT_MAIN.Create_Acct_Entry');

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;

Line 614: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ai_Exceptions()+');

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:

Line 658: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ai_Exceptions()-');

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:

Line 719: arp_standard.debug( 'Overloaded2 ARP_ACCT_MAIN.Create_Acct_Entry()+');

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

Line 762: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);

758: END IF;
759: END IF;
760:
761: /* call Accting engine */
762: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
763:
764: END LOOP;
765: END LOOP;
766:

Line 794: arp_acct_main.Create_Acct_Entry('ADJUSTMENT',

790:
791: SAVEPOINT Adj_Accounting_Call_Point;
792:
793: BEGIN
794: arp_acct_main.Create_Acct_Entry('ADJUSTMENT',
795: adj_info.adjustment_id,
796: 'ONE',
797: 'ADJ',
798: adj_info.adjustment_id,

Line 884: arp_acct_main.Create_Acct_Entry('CREDIT_MEMO',

880:
881: SAVEPOINT RA_Accounting_Call_Point;
882:
883: BEGIN
884: arp_acct_main.Create_Acct_Entry('CREDIT_MEMO',
885: cm_info.customer_trx_id,
886: 'ONE',
887: 'RA',
888: cm_info.rec_app_id,

Line 990: arp_standard.debug( 'Overloaded2 ARP_ACCT_MAIN.Create_Acct_Entry()-');

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:

Line 1022: arp_standard.debug( 'ARP_ACCT_MAIN.Delete_Acct_Entry()+');

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:

Line 1028: arp_standard.debug( 'ARP_ACCT_MAIN - Accounting Method ' || l_accounting_method);

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

Line 1072: arp_standard.debug( 'ARP_ACCT_MAIN.Delete_Acct_Entry()-');

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

Line 1078: arp_standard.debug( 'EXCEPTION: ARP_ACCT_MAIN.Delete_Acct_Entry');

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;

Line 1106: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.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:

Line 1112: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry()-');

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

Line 1118: arp_standard.debug( 'EXCEPTION: Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry');

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;

Line 1153: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.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 ;

Line 1169: arp_standard.debug( 'Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry()-');

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

Line 1175: arp_standard.debug( 'EXCEPTION: Overloaded ARP_ACCT_MAIN.Delete_Acct_Entry');

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;

Line 1204: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ae_Lines()+');

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

Line 1261: arp_standard.debug( 'sob type = ' || ARP_ACCT_MAIN.ae_sys_rec.sob_type);

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

Line 1264: IF (NVL(ARP_ACCT_MAIN.ae_sys_rec.sob_type,'P') = 'P') THEN

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:

Line 1270: arp_standard.debug( 'ARP_ACCT_MAIN.Insert_Ae_Lines()-');

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

Line 1276: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.Insert_Ae_Lines');

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;

Line 1297: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()+');

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

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

Line 1344: arp_standard.debug('ARP_ACCT_MAIN.Dump_Dist_Amts()-');

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

Line 1350: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.Dump_Dist_Amts');

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;

Line 1371: arp_standard.debug('ARP_ACCT_MAIN.Init_Curr_Details(+)');

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,

Line 1403: arp_standard.debug('ARP_ACCT_MAIN.Init_Curr_Details(-)');

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

Line 1409: arp_standard.debug('ARP_ACCT_MAIN.Init_Curr_Details - NO_DATA_FOUND' );

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

Line 1415: arp_standard.debug('EXCEPTION: ARP_ACCT_MAIN.constructor(-)');

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:

Line 1422: END ARP_ACCT_MAIN;

1418: RAISE;
1419:
1420: END Init_Curr_Details;
1421:
1422: END ARP_ACCT_MAIN;