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.20.12020000.2 2012/11/14 11:35:52 dgaurab 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 913: arp_util.debug('arp_process_line.insert_line()+');

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

Line 931: arp_process_line.val_insert_line(p_line_rec);

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

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

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

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

1069:
1070: ****************************************************************************/
1071:
1072: arp_util.debug(
1073: 'arp_process_line.insert_line after create_tax_f_ctl_id');
1074:
1075: EXCEPTION
1076: WHEN OTHERS THEN
1077: l_status2 := 'AR_TAX_EXCEPTION';

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

1111:
1112: -- arp_global.msg_level := 99;
1113:
1114: arp_util.debug(
1115: 'arp_process_line.insert_line before credit_transactions');
1116:
1117: arp_credit_memo_module.credit_transactions(
1118: p_line_rec.customer_trx_id,
1119: l_customer_trx_line_id,

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

1126: p_run_autoaccounting_flag =>
1127: (p_run_autoacc_flag = 'Y'));
1128:
1129: arp_util.debug(
1130: 'arp_process_line.insert_line after credit_transactions');
1131:
1132: p_rule_start_date := l_rule_start_date;
1133: p_accounting_rule_duration := l_accounting_rule_duration;
1134:

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

1257: l_ev_rec.xla_call := 'B';
1258: l_ev_rec.xla_fetch_size := 999;
1259: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1260:
1261: arp_util.debug('arp_process_line.insert_line()-');
1262:
1263: EXCEPTION
1264: WHEN OTHERS THEN
1265:

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

1270: /*---------------------------------------------+
1271: | Display parameters and raise the exception |
1272: +---------------------------------------------*/
1273:
1274: arp_util.debug('EXCEPTION: arp_process_line.insert_line()');
1275:
1276: arp_util.debug('');
1277: arp_util.debug('---------- parameters for insert_line() ---------');
1278:

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

1414: l_test VARCHAR2(1);
1415: --}
1416: BEGIN
1417:
1418: arp_util.debug('arp_process_line.update_line()+');
1419:
1420: p_rule_start_date := p_line_rec.rule_start_date;
1421: p_accounting_rule_duration := p_line_rec.accounting_rule_duration;
1422:

Line 1445: arp_process_line.val_update_line(p_line_rec,

1441: /*-------------------------+
1442: | Do required validation |
1443: +-------------------------*/
1444:
1445: arp_process_line.val_update_line(p_line_rec,
1446: l_db_line_rec,
1447: l_new_line_rec);
1448:
1449:

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

1773: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1774: END IF;
1775: CLOSE cpost;
1776:
1777: arp_util.debug('arp_process_line.update_line()-');
1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781:

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

1778:
1779: EXCEPTION
1780: WHEN OTHERS THEN
1781:
1782: arp_util.debug('EXCEPTION: arp_process_line.update_line()');
1783:
1784: arp_util.debug('');
1785: arp_util.debug('---------- parameters for update_line() ---------');
1786:

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

1887: where customer_trx_line_id = p_customer_trx_line_id
1888: FOR UPDATE OF customer_trx_line_id NOWAIT;
1889: BEGIN
1890:
1891: arp_util.debug('arp_process_line.delete_line()+');
1892:
1893: p_status := 'OK';
1894:
1895: /*----------------------------------------------+

Line 1906: arp_process_line.val_delete_line(p_line_rec,

1902: /*-------------------------+
1903: | Do required validation |
1904: +-------------------------*/
1905:
1906: arp_process_line.val_delete_line(p_line_rec,
1907: p_complete_flag);
1908:
1909:
1910: l_recalculate_tax_flag := p_recalculate_tax_flag;

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

2035: -- (the tax may not be valid for the new trx_date)
2036: null;
2037: END IF;
2038:
2039: arp_util.debug('arp_process_line.delete_line()-');
2040:
2041: EXCEPTION
2042: WHEN OTHERS THEN
2043:

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

2044: /*---------------------------------------------+
2045: | Display parameters and raise the exception |
2046: +---------------------------------------------*/
2047:
2048: arp_util.debug('EXCEPTION: arp_process_line.delete_line()');
2049:
2050: arp_util.debug('');
2051: arp_util.debug('---------- parameters for delete_line() ---------');
2052:

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

2082: pg_earliest_date := to_date('01/01/1901', 'DD/MM/YYYY');
2083:
2084: EXCEPTION
2085: WHEN OTHERS THEN
2086: arp_util.debug('EXCEPTION: arp_process_line.initialization');
2087: RAISE;
2088:
2089:
2090: END ARP_PROCESS_LINE;

Line 2090: END ARP_PROCESS_LINE;

2086: arp_util.debug('EXCEPTION: arp_process_line.initialization');
2087: RAISE;
2088:
2089:
2090: END ARP_PROCESS_LINE;