DBA Data[Home] [Help]

APPS.ARP_PROCESS_LINE dependencies on ARP_PROCESS_LINE

Line 1: PACKAGE BODY ARP_PROCESS_LINE AS

1: PACKAGE BODY ARP_PROCESS_LINE AS
2: /* $Header: ARTECTLB.pls 120.18.12010000.3 2008/11/07 13:01:19 ankuagar ship $ */
3:
4:
5: pg_base_curr_code fnd_currencies.currency_code%type;

Line 50: arp_util.debug('arp_process_line.make_incomplete()+');

46:
47: BEGIN
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_util.debug('arp_process_line.make_incomplete()+');
51: END IF;
52:
53: arp_ct_pkg.set_to_dummy( l_trx_rec );
54:

Line 61: arp_util.debug('arp_process_line.make_incomplete()-');

57: arp_ct_pkg.update_p( l_trx_rec,
58: p_customer_trx_id );
59:
60: IF PG_DEBUG in ('Y', 'C') THEN
61: arp_util.debug('arp_process_line.make_incomplete()-');
62: END IF;
63:
64: EXCEPTION
65: WHEN OTHERS THEN

Line 67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');

63:
64: EXCEPTION
65: WHEN OTHERS THEN
66: IF PG_DEBUG in ('Y', 'C') THEN
67: arp_util.debug('EXCEPTION: arp_process_line.make_incomplete()');
68: arp_util.debug('make_incomplete: ' || '');
69: arp_util.debug('---------- parameters for make_incomplete() ---------');
70: arp_util.debug('make_incomplete: ' || 'p_customer_trx_id = ' || p_customer_trx_id );
71: END IF;

Line 110: arp_util.debug('arp_process_line.get_commitment_line_id()+');

106: IS
107: BEGIN
108:
109: IF PG_DEBUG in ('Y', 'C') THEN
110: arp_util.debug('arp_process_line.get_commitment_line_id()+');
111: END IF;
112:
113: BEGIN
114:

Line 129: arp_util.debug('arp_process_line.get_commitment_line_id()-');

125: RAISE;
126: END;
127:
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('arp_process_line.get_commitment_line_id()-');
130: END IF;
131:
132: EXCEPTION
133: WHEN OTHERS THEN

Line 135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');

131:
132: EXCEPTION
133: WHEN OTHERS THEN
134: IF PG_DEBUG in ('Y', 'C') THEN
135: arp_util.debug('EXCEPTION: arp_process_line.get_commitment_line_id()');
136: arp_util.debug('------ parameters for get_commitment_line_id() -----');
137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
138: END IF;
139:

Line 200: arp_util.debug('arp_process_line.set_flags()+');

196: l_last_period_changed_flag boolean;
197:
198: BEGIN
199:
200: arp_util.debug('arp_process_line.set_flags()+');
201:
202:
203: /*--------------------------------+
204: | Set the flags appropriately |

Line 276: arp_util.debug('arp_process_line.set_flags()-');

272: arp_util.debug('l_last_period_changed_flag = ' ||
273: arp_trx_util.boolean_to_varchar2(
274: l_last_period_changed_flag ));
275:
276: arp_util.debug('arp_process_line.set_flags()-');
277:
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');

282: /*---------------------------------------------+
283: | Display parameters and raise the exception |
284: +---------------------------------------------*/
285:
286: arp_util.debug('EXCEPTION: arp_process_line.set_flags()');
287:
288: arp_util.debug('');
289: arp_util.debug('---------- parameters for set_flags() ---------');
290:

Line 350: arp_util.debug('arp_process_line.line_rerun_aa()+');

346: l_num_failed_dist_rows binary_integer;
347:
348: BEGIN
349:
350: arp_util.debug('arp_process_line.line_rerun_aa()+');
351:
352: BEGIN
353: arp_auto_accounting.do_autoaccounting
354: (

Line 380: arp_util.debug('arp_process_line.line_rerun_aa()-');

376: WHEN OTHERS THEN
377: RAISE;
378: END;
379:
380: arp_util.debug('arp_process_line.line_rerun_aa()-');
381:
382: EXCEPTION
383: WHEN OTHERS THEN
384:

Line 385: arp_util.debug('EXCEPTION: arp_process_line.line_rerun_aa()');

381:
382: EXCEPTION
383: WHEN OTHERS THEN
384:
385: arp_util.debug('EXCEPTION: arp_process_line.line_rerun_aa()');
386:
387:
388: /*---------------------------------------------+
389: | Display parameters and raise the exception |

Line 457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');

453: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
454:
455: BEGIN
456:
457: arp_util.debug('arp_process_line.header_freight_only_rules_case()+');
458:
459: IF (arp_trx_util.detect_freight_only_rules_case( p_customer_trx_id ) = TRUE)
460: THEN
461:

Line 509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');

505: null);
506:
507: END IF;
508:
509: arp_util.debug('arp_process_line.header_freight_only_rules_case()-');
510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: arp_util.debug(

Line 514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');

510:
511: EXCEPTION
512: WHEN OTHERS THEN
513: arp_util.debug(
514: 'EXCEPTION: arp_process_line.header_freight_only_rules_case()');
515:
516: arp_util.debug('');
517: arp_util.debug('-- parameters for header_freight_only_rules_case() --');
518:

Line 567: arp_util.debug('arp_process_line.val_insert_line()+');

563:
564:
565: BEGIN
566:
567: arp_util.debug('arp_process_line.val_insert_line()+');
568:
569: arp_trx_validate.check_dup_line_number(p_line_rec.line_number,
570: p_line_rec.customer_trx_id,
571: null);

Line 588: arp_util.debug('arp_process_line.val_insert_line()-');

584: p_line_rec.rule_start_date,
585: arp_global.set_of_books_id );
586: END IF;
587:
588: arp_util.debug('arp_process_line.val_insert_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');

Line 592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');

588: arp_util.debug('arp_process_line.val_insert_line()-');
589:
590: EXCEPTION
591: WHEN OTHERS THEN
592: arp_util.debug('EXCEPTION: arp_process_line.val_insert_line()');
593:
594: arp_util.debug('');
595: arp_util.debug('------ parameters for val_insert_line() -------');
596:

Line 648: arp_util.debug('arp_process_line.val_update_line()+');

644: l_line_rec ra_customer_trx_lines%rowtype;
645:
646: BEGIN
647:
648: arp_util.debug('arp_process_line.val_update_line()+');
649:
650:
651: arp_ctl_pkg.merge_line_recs( p_db_line_rec,
652: p_line_rec,

Line 663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');

659: +------------------------------------------*/
660:
661: IF (l_line_rec.line_type not in ('LINE', 'CHARGES', 'CB') )
662: THEN
663: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
664: arp_util.debug(
665: 'The specified line is not of type LINE, CHARGES or CB');
666: fnd_message.set_name('AR', 'C-1647');
667: app_exception.raise_exception;

Line 689: arp_util.debug('arp_process_line.val_update_line()-');

685: l_line_rec.rule_start_date,
686: arp_global.set_of_books_id );
687: END IF;
688:
689: arp_util.debug('arp_process_line.val_update_line()-');
690:
691:
692: EXCEPTION
693: WHEN OTHERS THEN

Line 694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');

690:
691:
692: EXCEPTION
693: WHEN OTHERS THEN
694: arp_util.debug('EXCEPTION: arp_process_line.val_update_line()');
695:
696: arp_util.debug('');
697: arp_util.debug('------ parameters for val_update_line() -------');
698:

Line 750: arp_util.debug('arp_process_line.val_delete_line()+');

746:
747:
748: BEGIN
749:
750: arp_util.debug('arp_process_line.val_delete_line()+');
751:
752: IF ( p_complete_flag = 'Y' )
753: THEN arp_trx_validate.check_has_one_line( p_line_rec.customer_trx_id );
754: END IF;

Line 757: arp_util.debug('arp_process_line.val_delete_line()-');

753: THEN arp_trx_validate.check_has_one_line( p_line_rec.customer_trx_id );
754: END IF;
755:
756:
757: arp_util.debug('arp_process_line.val_delete_line()-');
758:
759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');

Line 761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');

757: arp_util.debug('arp_process_line.val_delete_line()-');
758:
759: EXCEPTION
760: WHEN OTHERS THEN
761: arp_util.debug('EXCEPTION: arp_process_line.val_delete_line()');
762:
763: arp_util.debug('');
764: arp_util.debug('------ parameters for val_delete_line() -------');
765:

Line 912: arp_util.debug('arp_process_line.insert_line()+');

908:
909: l_mode VARCHAR2(50);
910: BEGIN
911:
912: arp_util.debug('arp_process_line.insert_line()+');
913:
914: arp_util.debug('ARTECTLB: p_line_rec.amount_includes_tax_flag = ' || p_line_rec.amount_includes_tax_flag);
915:
916: p_rule_start_date := p_line_rec.rule_start_date;

Line 930: arp_process_line.val_insert_line(p_line_rec);

926: /*-------------------------+
927: | Do required validation |
928: +-------------------------*/
929:
930: arp_process_line.val_insert_line(p_line_rec);
931:
932: /*----------------------------------------------------------------+
933: | Lock rows in other tables that reference this customer_trx_id |
934: +----------------------------------------------------------------*/

Line 1011: 'arp_process_line.insert_line before create_tax_f_ctl_id');

1007:
1008: BEGIN
1009:
1010: arp_util.debug(
1011: 'arp_process_line.insert_line before create_tax_f_ctl_id');
1012:
1013: -- Rel. 11: call to new tax engine procedure
1014: -- to handle tax-inclusive case:
1015:

Line 1059: 'arp_process_line.insert_line after create_tax_f_ctl_id');

1055:
1056: ****************************************************************************/
1057:
1058: arp_util.debug(
1059: 'arp_process_line.insert_line after create_tax_f_ctl_id');
1060:
1061: EXCEPTION
1062: WHEN OTHERS THEN
1063: l_status2 := 'AR_TAX_EXCEPTION';

Line 1101: 'arp_process_line.insert_line before credit_transactions');

1097:
1098: -- arp_global.msg_level := 99;
1099:
1100: arp_util.debug(
1101: 'arp_process_line.insert_line before credit_transactions');
1102:
1103: arp_credit_memo_module.credit_transactions(
1104: p_line_rec.customer_trx_id,
1105: l_customer_trx_line_id,

Line 1116: 'arp_process_line.insert_line after credit_transactions');

1112: p_run_autoaccounting_flag =>
1113: (p_run_autoacc_flag = 'Y'));
1114:
1115: arp_util.debug(
1116: 'arp_process_line.insert_line after credit_transactions');
1117:
1118: p_rule_start_date := l_rule_start_date;
1119: p_accounting_rule_duration := l_accounting_rule_duration;
1120:

Line 1247: arp_util.debug('arp_process_line.insert_line()-');

1243: l_ev_rec.xla_call := 'B';
1244: l_ev_rec.xla_fetch_size := 999;
1245: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1246:
1247: arp_util.debug('arp_process_line.insert_line()-');
1248:
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251:

Line 1260: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');

1256: /*---------------------------------------------+
1257: | Display parameters and raise the exception |
1258: +---------------------------------------------*/
1259:
1260: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1261:
1262: arp_util.debug('');
1263: arp_util.debug('---------- parameters for insert_line() ---------');
1264:

Line 1404: arp_util.debug('arp_process_line.update_line()+');

1400: l_test VARCHAR2(1);
1401: --}
1402: BEGIN
1403:
1404: arp_util.debug('arp_process_line.update_line()+');
1405:
1406: p_rule_start_date := p_line_rec.rule_start_date;
1407: p_accounting_rule_duration := p_line_rec.accounting_rule_duration;
1408:

Line 1431: arp_process_line.val_update_line(p_line_rec,

1427: /*-------------------------+
1428: | Do required validation |
1429: +-------------------------*/
1430:
1431: arp_process_line.val_update_line(p_line_rec,
1432: l_db_line_rec,
1433: l_new_line_rec);
1434:
1435:

Line 1763: arp_util.debug('arp_process_line.update_line()-');

1759: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1760: END IF;
1761: CLOSE cpost;
1762:
1763: arp_util.debug('arp_process_line.update_line()-');
1764:
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767:

Line 1768: arp_util.debug('EXCEPTION: arp_process_line.update_line()');

1764:
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767:
1768: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1769:
1770: arp_util.debug('');
1771: arp_util.debug('---------- parameters for update_line() ---------');
1772:

Line 1877: arp_util.debug('arp_process_line.delete_line()+');

1873: where customer_trx_line_id = p_customer_trx_line_id
1874: FOR UPDATE OF customer_trx_line_id NOWAIT;
1875: BEGIN
1876:
1877: arp_util.debug('arp_process_line.delete_line()+');
1878:
1879: p_status := 'OK';
1880:
1881: /*----------------------------------------------+

Line 1892: arp_process_line.val_delete_line(p_line_rec,

1888: /*-------------------------+
1889: | Do required validation |
1890: +-------------------------*/
1891:
1892: arp_process_line.val_delete_line(p_line_rec,
1893: p_complete_flag);
1894:
1895:
1896: l_recalculate_tax_flag := p_recalculate_tax_flag;

Line 2025: arp_util.debug('arp_process_line.delete_line()-');

2021: -- (the tax may not be valid for the new trx_date)
2022: null;
2023: END IF;
2024:
2025: arp_util.debug('arp_process_line.delete_line()-');
2026:
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029:

Line 2034: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');

2030: /*---------------------------------------------+
2031: | Display parameters and raise the exception |
2032: +---------------------------------------------*/
2033:
2034: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2035:
2036: arp_util.debug('');
2037: arp_util.debug('---------- parameters for delete_line() ---------');
2038:

Line 2072: arp_util.debug('EXCEPTION: arp_process_line.initialization');

2068: pg_earliest_date := to_date('01/01/1901', 'DD/MM/YYYY');
2069:
2070: EXCEPTION
2071: WHEN OTHERS THEN
2072: arp_util.debug('EXCEPTION: arp_process_line.initialization');
2073: RAISE;
2074:
2075:
2076: END ARP_PROCESS_LINE;

Line 2076: END ARP_PROCESS_LINE;

2072: arp_util.debug('EXCEPTION: arp_process_line.initialization');
2073: RAISE;
2074:
2075:
2076: END ARP_PROCESS_LINE;