eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_HEADER dependencies on ARP_PROCESS_HEADER

Line 1: PACKAGE BODY ARP_PROCESS_HEADER AS

1: PACKAGE BODY ARP_PROCESS_HEADER AS
2: /* $Header: ARTEHEAB.pls 120.24.12010000.4 2008/11/07 12:57:09 ankuagar ship $ */
3:
4: pg_tax_flag varchar2(10);
5: pg_text_dummy varchar2(10);

Line 54: arp_util.debug('arp_process_header.validate_insert_header()+');

50: l_status OUT NOCOPY varchar2 ) IS
51:
52: BEGIN
53:
54: arp_util.debug('arp_process_header.validate_insert_header()+');
55: if l_trx_rec.complete_flag is null then
56: arp_util.debug('Complete flag cannot be null,Valid values are Y or N');
57: l_status := 'E';
58: return;

Line 60: arp_util.debug('arp_process_header.validate_insert_header()-');

56: arp_util.debug('Complete flag cannot be null,Valid values are Y or N');
57: l_status := 'E';
58: return;
59: end if;
60: arp_util.debug('arp_process_header.validate_insert_header()-');
61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: arp_util.debug('EXCEPTION: arp_process_header.validate_insert_header()');

Line 64: arp_util.debug('EXCEPTION: arp_process_header.validate_insert_header()');

60: arp_util.debug('arp_process_header.validate_insert_header()-');
61:
62: EXCEPTION
63: WHEN OTHERS THEN
64: arp_util.debug('EXCEPTION: arp_process_header.validate_insert_header()');
65: RAISE;
66:
67: END;
68:

Line 99: arp_util.debug('arp_process_header.validate_update_header()+');

95: PROCEDURE validate_update_header IS
96:
97: BEGIN
98:
99: arp_util.debug('arp_process_header.validate_update_header()+');
100:
101: arp_util.debug('arp_process_header.validate_update_header()-');
102:
103: EXCEPTION

Line 101: arp_util.debug('arp_process_header.validate_update_header()-');

97: BEGIN
98:
99: arp_util.debug('arp_process_header.validate_update_header()+');
100:
101: arp_util.debug('arp_process_header.validate_update_header()-');
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: arp_util.debug('EXCEPTION: arp_process_header.validate_update_header()');

Line 105: arp_util.debug('EXCEPTION: arp_process_header.validate_update_header()');

101: arp_util.debug('arp_process_header.validate_update_header()-');
102:
103: EXCEPTION
104: WHEN OTHERS THEN
105: arp_util.debug('EXCEPTION: arp_process_header.validate_update_header()');
106: RAISE;
107:
108: END;
109:

Line 139: arp_util.debug('arp_process_header.validate_delete_header()+');

135: PROCEDURE validate_delete_header IS
136:
137: BEGIN
138:
139: arp_util.debug('arp_process_header.validate_delete_header()+');
140:
141: arp_util.debug('arp_process_header.validate_delete_header()-');
142:
143: EXCEPTION

Line 141: arp_util.debug('arp_process_header.validate_delete_header()-');

137: BEGIN
138:
139: arp_util.debug('arp_process_header.validate_delete_header()+');
140:
141: arp_util.debug('arp_process_header.validate_delete_header()-');
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: arp_util.debug('EXCEPTION: arp_process_header.validate_delete_header()');

Line 145: arp_util.debug('EXCEPTION: arp_process_header.validate_delete_header()');

141: arp_util.debug('arp_process_header.validate_delete_header()-');
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: arp_util.debug('EXCEPTION: arp_process_header.validate_delete_header()');
146: RAISE;
147:
148: END;
149:

Line 220: arp_util.debug('arp_process_header.set_flags()+');

216: ld_old_dispute_date DATE;
217:
218: BEGIN
219:
220: arp_util.debug('arp_process_header.set_flags()+');
221:
222: arp_ct_pkg.fetch_p(l_old_trx_rec,
223: p_customer_trx_id);
224:

Line 339: arp_util.debug('arp_process_header.set_flags()-');

335: ELSE
336: p_cust_trx_type_changed_flag := FALSE;
337: END IF;
338:
339: arp_util.debug('arp_process_header.set_flags()-');
340:
341:
342: EXCEPTION
343: WHEN OTHERS THEN

Line 349: arp_util.debug('EXCEPTION: arp_process_header.set_flags()');

345: /*---------------------------------------------+
346: | Display parameters and raise the exception |
347: +---------------------------------------------*/
348:
349: arp_util.debug('EXCEPTION: arp_process_header.set_flags()');
350:
351: arp_util.debug('');
352: arp_util.debug('---------- parameters for set_flags() ---------');
353:

Line 415: arp_util.debug('arp_process_header.header_rerun_aa()+');

411: l_status7 varchar2(100);
412:
413: BEGIN
414:
415: arp_util.debug('arp_process_header.header_rerun_aa()+');
416:
417: BEGIN
418: arp_auto_accounting.do_autoaccounting(
419: 'U',

Line 656: arp_util.debug('arp_process_header.header_rerun_aa()-');

652: THEN p_status := l_status7;
653: ELSE p_status := 'OK';
654: END IF;
655:
656: arp_util.debug('arp_process_header.header_rerun_aa()-');
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');

Line 660: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');

656: arp_util.debug('arp_process_header.header_rerun_aa()-');
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');
661: RAISE;
662:
663: END;
664:

Line 700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');

696: l_line_rec ra_customer_trx_lines%rowtype;
697: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
698: BEGIN
699:
700: arp_util.debug('arp_process_header.reverse_revrec_effect()+');
701:
702: arp_ctl_pkg.set_to_dummy( l_line_rec );
703:
704: l_line_rec.autorule_complete_flag := 'N';

Line 713: arp_util.debug('arp_process_header..reverse_revrec_effect: '||

709: p_customer_trx_id,
710: 'LINE');
711: EXCEPTION
712: WHEN NO_DATA_FOUND THEN
713: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
714: 'no child lines to update.');
715: WHEN OTHERS THEN
716: arp_util.debug('EXCEPTION: '||
717: 'arp_process_header..reverse_revrec_effect()');

Line 717: 'arp_process_header..reverse_revrec_effect()');

713: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
714: 'no child lines to update.');
715: WHEN OTHERS THEN
716: arp_util.debug('EXCEPTION: '||
717: 'arp_process_header..reverse_revrec_effect()');
718: RAISE;
719: END;
720:
721: BEGIN

Line 732: arp_util.debug('arp_process_header.reverse_revrec_effect: '||

728: 'N',
729: NULL);
730: EXCEPTION
731: WHEN NO_DATA_FOUND THEN
732: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
733: 'no dists to delete.');
734: WHEN OTHERS THEN
735: arp_util.debug('EXCEPTION: '||
736: 'arp_process_header.reverse_revrec_effect()');

Line 736: 'arp_process_header.reverse_revrec_effect()');

732: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
733: 'no dists to delete.');
734: WHEN OTHERS THEN
735: arp_util.debug('EXCEPTION: '||
736: 'arp_process_header.reverse_revrec_effect()');
737: RAISE;
738: END;
739:
740: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);

Line 749: arp_util.debug('arp_process_header.reverse_revrec_effect: '||

745: 'Y',
746: 'REC');
747: EXCEPTION
748: WHEN NO_DATA_FOUND THEN
749: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
750: 'no dists to update.');
751: WHEN OTHERS THEN
752: arp_util.debug('EXCEPTION: '||
753: 'arp_process_header.reverse_revrec_effect()');

Line 753: 'arp_process_header.reverse_revrec_effect()');

749: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
750: 'no dists to update.');
751: WHEN OTHERS THEN
752: arp_util.debug('EXCEPTION: '||
753: 'arp_process_header.reverse_revrec_effect()');
754: RAISE;
755: END;
756: EXCEPTION
757: WHEN OTHERS THEN

Line 759: 'arp_process_header.reverse_revrec_effect()');

755: END;
756: EXCEPTION
757: WHEN OTHERS THEN
758: arp_util.debug('EXCEPTION: '||
759: 'arp_process_header.reverse_revrec_effect()');
760: RAISE;
761: END ;
762: /*===========================================================================+
763: | PROCEDURE |

Line 837: arp_util.debug('arp_process_header.insert_header()+');

833: l_dist_count NUMBER;
834:
835: BEGIN
836:
837: arp_util.debug('arp_process_header.insert_header()+');
838:
839: p_trx_number := '';
840: p_customer_trx_id := '';
841: l_trx_rec := p_trx_rec;

Line 1034: arp_util.debug('arp_process_header.insert_header()-');

1030: l_ev_rec.xla_call := 'B';
1031: l_ev_rec.xla_fetch_size := 999;
1032: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1033:
1034: arp_util.debug('arp_process_header.insert_header()-');
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');

Line 1038: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');

1034: arp_util.debug('arp_process_header.insert_header()-');
1035:
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');
1039: RAISE;
1040:
1041: END;
1042:

Line 1143: arp_util.debug('arp_process_header.update_header()+');

1139: l_post_to_gl varchar2(100);
1140: l_event_status_code varchar2(100);
1141: BEGIN
1142:
1143: arp_util.debug('arp_process_header.update_header()+');
1144:
1145: -- check form version to determine if it is compatible with the
1146: -- entity handler.
1147: arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

Line 1364: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||

1360: p_customer_trx_id,
1361: 'LINE');
1362: EXCEPTION
1363: WHEN NO_DATA_FOUND THEN
1364: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1365: 'no child lines to update.');
1366: WHEN OTHERS THEN
1367: arp_util.debug('EXCEPTION: '||
1368: 'arp_process_header..Clearing Lines Rule Info()');

Line 1368: 'arp_process_header..Clearing Lines Rule Info()');

1364: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1365: 'no child lines to update.');
1366: WHEN OTHERS THEN
1367: arp_util.debug('EXCEPTION: '||
1368: 'arp_process_header..Clearing Lines Rule Info()');
1369: RAISE;
1370: END;
1371: EXCEPTION
1372: WHEN NO_DATA_FOUND THEN

Line 1373: arp_util.debug('EXCEPTION: arp_process_header.update_header: '||

1369: RAISE;
1370: END;
1371: EXCEPTION
1372: WHEN NO_DATA_FOUND THEN
1373: arp_util.debug('EXCEPTION: arp_process_header.update_header: '||
1374: 'no child lines to clear rule info.');
1375: END;
1376: BEGIN
1377: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,

Line 1383: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||

1379: NULL);
1380: l_rerun_autoacc_flag := TRUE;
1381: EXCEPTION
1382: WHEN NO_DATA_FOUND THEN
1383: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1384: 'no dists to delete.');
1385: WHEN OTHERS THEN
1386: arp_util.debug('EXCEPTION: '||
1387: 'arp_process_header.Clearing GL Dist Rule Info ()');

Line 1387: 'arp_process_header.Clearing GL Dist Rule Info ()');

1383: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1384: 'no dists to delete.');
1385: WHEN OTHERS THEN
1386: arp_util.debug('EXCEPTION: '||
1387: 'arp_process_header.Clearing GL Dist Rule Info ()');
1388: RAISE;
1389: END;
1390: arp_util.debug('Clearing Lines and dist Rule Info ()-');
1391: END IF;

Line 1439: arp_util.debug('arp_process_header.update_header: '||

1435: null);
1436:
1437: EXCEPTION
1438: WHEN NO_DATA_FOUND THEN
1439: arp_util.debug('arp_process_header.update_header: '||
1440: 'no dists to update.');
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: '||
1443: 'arp_process_header.update_header()');

Line 1443: 'arp_process_header.update_header()');

1439: arp_util.debug('arp_process_header.update_header: '||
1440: 'no dists to update.');
1441: WHEN OTHERS THEN
1442: arp_util.debug('EXCEPTION: '||
1443: 'arp_process_header.update_header()');
1444: RAISE;
1445:
1446: END;
1447: END IF; /* IF l_gl_date_changed_flag */

Line 1553: arp_util.debug('arp_process_header.update_header: '||

1549: 'LINE');
1550:
1551: EXCEPTION
1552: WHEN NO_DATA_FOUND THEN
1553: arp_util.debug('arp_process_header.update_header: '||
1554: 'no child lines to update.');
1555: WHEN OTHERS THEN
1556: arp_util.debug('EXCEPTION: '||
1557: 'arp_process_header.update_header()');

Line 1557: 'arp_process_header.update_header()');

1553: arp_util.debug('arp_process_header.update_header: '||
1554: 'no child lines to update.');
1555: WHEN OTHERS THEN
1556: arp_util.debug('EXCEPTION: '||
1557: 'arp_process_header.update_header()');
1558: RAISE;
1559: END;
1560: END IF;
1561:

Line 1698: 'EXCEPTION: arp_process_header.update_header()' );

1694: END IF;
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: arp_util.debug('Unable to get the XLA Entites Data ' ||
1698: 'EXCEPTION: arp_process_header.update_header()' );
1699: --RAISE;
1700: END;
1701: END IF;
1702:

Line 1722: arp_util.debug('arp_process_header.update_header()-');

1718:
1719: END IF;
1720: CLOSE cpost;
1721:
1722: arp_util.debug('arp_process_header.update_header()-');
1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: arp_util.debug('EXCEPTION: arp_process_header.update_header()');

Line 1726: arp_util.debug('EXCEPTION: arp_process_header.update_header()');

1722: arp_util.debug('arp_process_header.update_header()-');
1723:
1724: EXCEPTION
1725: WHEN OTHERS THEN
1726: arp_util.debug('EXCEPTION: arp_process_header.update_header()');
1727: RAISE;
1728:
1729: END;
1730:

Line 1777: arp_util.debug('arp_process_header.delete_cont_defer_data+');

1773: FOR UPDATE OF customer_trx_id NOWAIT;
1774:
1775:
1776: BEGIN
1777: arp_util.debug('arp_process_header.delete_cont_defer_data+');
1778:
1779: FOR l_cont_rec IN cont_cursor LOOP
1780: delete from ar_line_conts
1781: where customer_trx_line_id = l_cont_rec.customer_trx_line_id;

Line 1789: arp_util.debug('arp_process_header.delete_cont_defer_data-');

1785: delete from ar_deferred_lines
1786: WHERE customer_trx_id = l_deferred_rec.customer_trx_id;
1787: END LOOP;
1788:
1789: arp_util.debug('arp_process_header.delete_cont_defer_data-');
1790: EXCEPTION
1791: WHEN NO_DATA_FOUND THEN
1792: null;
1793: WHEN OTHERS THEN

Line 1795: 'arp_process_header.delete_cont_defer_data()-');

1791: WHEN NO_DATA_FOUND THEN
1792: null;
1793: WHEN OTHERS THEN
1794: arp_util.debug('EXCEPTION : '||
1795: 'arp_process_header.delete_cont_defer_data()-');
1796: END;
1797:
1798:
1799: /*===========================================================================+

Line 1838: arp_util.debug('arp_process_header.delete_header()+');

1834: l_new_tax_amount NUMBER;
1835:
1836: BEGIN
1837:
1838: arp_util.debug('arp_process_header.delete_header()+');
1839:
1840: p_status := 'OK';
1841:
1842: -- check form version to determine if it is compatible with the

Line 1887: arp_util.debug('arp_process_header.delete_header()-');

1883:
1884:
1885:
1886:
1887: arp_util.debug('arp_process_header.delete_header()-');
1888:
1889: EXCEPTION
1890: WHEN OTHERS THEN
1891: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');

Line 1891: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');

1887: arp_util.debug('arp_process_header.delete_header()-');
1888:
1889: EXCEPTION
1890: WHEN OTHERS THEN
1891: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');
1892: RAISE;
1893:
1894: END;
1895:

Line 1949: arp_process_header_post_commit.

1945: ) IS
1946:
1947: BEGIN
1948:
1949: arp_process_header_post_commit.
1950: post_commit( p_form_name,
1951: p_form_version,
1952: p_customer_trx_id,
1953: p_previous_customer_trx_id,

Line 2024: arp_util.debug('arp_process_header.update_header_freight_cover()+');

2020: l_dummy varchar2(80);
2021:
2022: BEGIN
2023:
2024: arp_util.debug('arp_process_header.update_header_freight_cover()+');
2025:
2026: arp_ct_pkg.set_to_dummy(l_trx_rec);
2027:
2028: l_trx_rec.ship_via := p_ship_via;

Line 2051: arp_util.debug('arp_process_header.update_header_freight_cover()-');

2047: null,
2048: null,
2049: p_status);
2050:
2051: arp_util.debug('arp_process_header.update_header_freight_cover()-');
2052:
2053: EXCEPTION
2054: WHEN OTHERS THEN
2055: arp_util.debug('EXCEPTION : '||

Line 2056: 'arp_process_header.update_header_freight_cover()-');

2052:
2053: EXCEPTION
2054: WHEN OTHERS THEN
2055: arp_util.debug('EXCEPTION : '||
2056: 'arp_process_header.update_header_freight_cover()-');
2057: arp_util.debug('------- parameters for update_header_freight_cover ----');
2058: arp_util.debug('p_form_name = '||p_form_name);
2059: arp_util.debug('p_form_version = '||p_form_version);
2060: arp_util.debug('p_ship_via = '||p_ship_via);

Line 2372: arp_util.debug('arp_process_header.post_query()+');

2368: l_commit_memo_line_desc ar_memo_lines.description%type;
2369:
2370: BEGIN
2371:
2372: arp_util.debug('arp_process_header.post_query()+');
2373:
2374: /*-----------------------------------------+
2375: | Initialize the OUT NOCOPY parameters to NULL |
2376: +-----------------------------------------*/

Line 2905: arp_util.debug('arp_process_header.post_query()-');

2901: l_ct_prev_post_to_gl_flag );
2902: arp_util.debug('p_al_cm_reason_meaning = ' ||
2903: l_al_cm_reason_meaning);
2904:
2905: arp_util.debug('arp_process_header.post_query()-');
2906:
2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: arp_util.debug('EXCEPTION : '||

Line 2910: 'arp_process_header.post_query()-');

2906:
2907: EXCEPTION
2908: WHEN OTHERS THEN
2909: arp_util.debug('EXCEPTION : '||
2910: 'arp_process_header.post_query()-');
2911: arp_util.debug('------- parameters for post_query ----');
2912: arp_util.debug('p_class = ' || p_class);
2913: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2914: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

Line 2954: END ARP_PROCESS_HEADER;

2950: END init;
2951:
2952: BEGIN
2953: init;
2954: END ARP_PROCESS_HEADER;