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.32.12020000.2 2012/07/10 00:40:12 dgaurab 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 441: arp_util.debug('arp_process_header.header_rerun_aa()+');

437:
438:
439: BEGIN
440:
441: arp_util.debug('arp_process_header.header_rerun_aa()+');
442:
443:
444: -- Bug9005547
445: -- Delete the existing event_id that has been latched to the GLD rows:

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

709: THEN p_status := l_status7;
710: ELSE p_status := 'OK';
711: END IF;
712:
713: arp_util.debug('arp_process_header.header_rerun_aa()-');
714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');

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

713: arp_util.debug('arp_process_header.header_rerun_aa()-');
714:
715: EXCEPTION
716: WHEN OTHERS THEN
717: arp_util.debug('EXCEPTION: arp_process_header.header_rerun_aa()');
718: RAISE;
719:
720: END;
721:

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

753: l_line_rec ra_customer_trx_lines%rowtype;
754: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
755: BEGIN
756:
757: arp_util.debug('arp_process_header.reverse_revrec_effect()+');
758:
759: arp_ctl_pkg.set_to_dummy( l_line_rec );
760:
761: l_line_rec.autorule_complete_flag := 'N';

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

766: p_customer_trx_id,
767: 'LINE');
768: EXCEPTION
769: WHEN NO_DATA_FOUND THEN
770: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
771: 'no child lines to update.');
772: WHEN OTHERS THEN
773: arp_util.debug('EXCEPTION: '||
774: 'arp_process_header..reverse_revrec_effect()');

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

770: arp_util.debug('arp_process_header..reverse_revrec_effect: '||
771: 'no child lines to update.');
772: WHEN OTHERS THEN
773: arp_util.debug('EXCEPTION: '||
774: 'arp_process_header..reverse_revrec_effect()');
775: RAISE;
776: END;
777:
778: BEGIN

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

785: 'N',
786: NULL);
787: EXCEPTION
788: WHEN NO_DATA_FOUND THEN
789: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
790: 'no dists to delete.');
791: WHEN OTHERS THEN
792: arp_util.debug('EXCEPTION: '||
793: 'arp_process_header.reverse_revrec_effect()');

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

789: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
790: 'no dists to delete.');
791: WHEN OTHERS THEN
792: arp_util.debug('EXCEPTION: '||
793: 'arp_process_header.reverse_revrec_effect()');
794: RAISE;
795: END;
796:
797: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);

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

802: 'Y',
803: 'REC');
804: EXCEPTION
805: WHEN NO_DATA_FOUND THEN
806: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
807: 'no dists to update.');
808: WHEN OTHERS THEN
809: arp_util.debug('EXCEPTION: '||
810: 'arp_process_header.reverse_revrec_effect()');

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

806: arp_util.debug('arp_process_header.reverse_revrec_effect: '||
807: 'no dists to update.');
808: WHEN OTHERS THEN
809: arp_util.debug('EXCEPTION: '||
810: 'arp_process_header.reverse_revrec_effect()');
811: RAISE;
812: END;
813: EXCEPTION
814: WHEN OTHERS THEN

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

812: END;
813: EXCEPTION
814: WHEN OTHERS THEN
815: arp_util.debug('EXCEPTION: '||
816: 'arp_process_header.reverse_revrec_effect()');
817: RAISE;
818: END ;
819: /*===========================================================================+
820: | PROCEDURE |

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

890: l_dist_count NUMBER;
891:
892: BEGIN
893:
894: arp_util.debug('arp_process_header.insert_header()+');
895:
896: p_trx_number := '';
897: p_customer_trx_id := '';
898: l_trx_rec := p_trx_rec;

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

1087: l_ev_rec.xla_call := 'B';
1088: l_ev_rec.xla_fetch_size := 999;
1089: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1090:
1091: arp_util.debug('arp_process_header.insert_header()-');
1092:
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');

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

1091: arp_util.debug('arp_process_header.insert_header()-');
1092:
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: arp_util.debug('EXCEPTION: arp_process_header.insert_header()');
1096: RAISE;
1097:
1098: END;
1099:

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

1196: l_post_to_gl varchar2(100);
1197: l_event_status_code varchar2(100);
1198: BEGIN
1199:
1200: arp_util.debug('arp_process_header.update_header()+');
1201:
1202: -- check form version to determine if it is compatible with the
1203: -- entity handler.
1204: arp_trx_validate.ar_entity_version_check(p_form_name, p_form_version);

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

1417: p_customer_trx_id,
1418: 'LINE');
1419: EXCEPTION
1420: WHEN NO_DATA_FOUND THEN
1421: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1422: 'no child lines to update.');
1423: WHEN OTHERS THEN
1424: arp_util.debug('EXCEPTION: '||
1425: 'arp_process_header..Clearing Lines Rule Info()');

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

1421: arp_util.debug('EXCEPTION: arp_process_header.Clearing Lines Rule Info: '||
1422: 'no child lines to update.');
1423: WHEN OTHERS THEN
1424: arp_util.debug('EXCEPTION: '||
1425: 'arp_process_header..Clearing Lines Rule Info()');
1426: RAISE;
1427: END;
1428: EXCEPTION
1429: WHEN NO_DATA_FOUND THEN

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

1426: RAISE;
1427: END;
1428: EXCEPTION
1429: WHEN NO_DATA_FOUND THEN
1430: arp_util.debug('EXCEPTION: arp_process_header.update_header: '||
1431: 'no child lines to clear rule info.');
1432: END;
1433: BEGIN
1434: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,

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

1436: NULL);
1437: l_rerun_autoacc_flag := TRUE;
1438: EXCEPTION
1439: WHEN NO_DATA_FOUND THEN
1440: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1441: 'no dists to delete.');
1442: WHEN OTHERS THEN
1443: arp_util.debug('EXCEPTION: '||
1444: 'arp_process_header.Clearing GL Dist Rule Info ()');

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

1440: arp_util.debug('arp_process_header.Clearing GL Dist Rule Info : '||
1441: 'no dists to delete.');
1442: WHEN OTHERS THEN
1443: arp_util.debug('EXCEPTION: '||
1444: 'arp_process_header.Clearing GL Dist Rule Info ()');
1445: RAISE;
1446: END;
1447: arp_util.debug('Clearing Lines and dist Rule Info ()-');
1448: END IF;

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

1515: null);
1516:
1517: EXCEPTION
1518: WHEN NO_DATA_FOUND THEN
1519: arp_util.debug('arp_process_header.update_header: '||
1520: 'no dists to update.');
1521: WHEN OTHERS THEN
1522: arp_util.debug('EXCEPTION: '||
1523: 'arp_process_header.update_header()');

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

1519: arp_util.debug('arp_process_header.update_header: '||
1520: 'no dists to update.');
1521: WHEN OTHERS THEN
1522: arp_util.debug('EXCEPTION: '||
1523: 'arp_process_header.update_header()');
1524: RAISE;
1525:
1526: END;
1527: END IF; /* IF l_gl_date_changed_flag */

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

1629: 'LINE');
1630:
1631: EXCEPTION
1632: WHEN NO_DATA_FOUND THEN
1633: arp_util.debug('arp_process_header.update_header: '||
1634: 'no child lines to update.');
1635: WHEN OTHERS THEN
1636: arp_util.debug('EXCEPTION: '||
1637: 'arp_process_header.update_header()');

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

1633: arp_util.debug('arp_process_header.update_header: '||
1634: 'no child lines to update.');
1635: WHEN OTHERS THEN
1636: arp_util.debug('EXCEPTION: '||
1637: 'arp_process_header.update_header()');
1638: RAISE;
1639: END;
1640: END IF;
1641:

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

1774: END IF;
1775: EXCEPTION
1776: WHEN OTHERS THEN
1777: arp_util.debug('Unable to get the XLA Entites Data ' ||
1778: 'EXCEPTION: arp_process_header.update_header()' );
1779: --RAISE;
1780: END;
1781: END IF;
1782:

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

1798:
1799: END IF;
1800: CLOSE cpost;
1801:
1802: arp_util.debug('arp_process_header.update_header()-');
1803:
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: arp_util.debug('EXCEPTION: arp_process_header.update_header()');

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

1802: arp_util.debug('arp_process_header.update_header()-');
1803:
1804: EXCEPTION
1805: WHEN OTHERS THEN
1806: arp_util.debug('EXCEPTION: arp_process_header.update_header()');
1807: RAISE;
1808:
1809: END;
1810:

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

1853: FOR UPDATE OF customer_trx_id NOWAIT;
1854:
1855:
1856: BEGIN
1857: arp_util.debug('arp_process_header.delete_cont_defer_data+');
1858:
1859: FOR l_cont_rec IN cont_cursor LOOP
1860: delete from ar_line_conts
1861: where customer_trx_line_id = l_cont_rec.customer_trx_line_id;

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

1865: delete from ar_deferred_lines
1866: WHERE customer_trx_id = l_deferred_rec.customer_trx_id;
1867: END LOOP;
1868:
1869: arp_util.debug('arp_process_header.delete_cont_defer_data-');
1870: EXCEPTION
1871: WHEN NO_DATA_FOUND THEN
1872: null;
1873: WHEN OTHERS THEN

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

1871: WHEN NO_DATA_FOUND THEN
1872: null;
1873: WHEN OTHERS THEN
1874: arp_util.debug('EXCEPTION : '||
1875: 'arp_process_header.delete_cont_defer_data()-');
1876: END;
1877:
1878:
1879: /*===========================================================================+

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

1914: l_new_tax_amount NUMBER;
1915:
1916: BEGIN
1917:
1918: arp_util.debug('arp_process_header.delete_header()+');
1919:
1920: p_status := 'OK';
1921:
1922: -- check form version to determine if it is compatible with the

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

1963:
1964:
1965:
1966:
1967: arp_util.debug('arp_process_header.delete_header()-');
1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');

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

1967: arp_util.debug('arp_process_header.delete_header()-');
1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: arp_util.debug('EXCEPTION: arp_process_header.delete_header()');
1972: RAISE;
1973:
1974: END;
1975:

Line 2029: arp_process_header_post_commit.

2025: ) IS
2026:
2027: BEGIN
2028:
2029: arp_process_header_post_commit.
2030: post_commit( p_form_name,
2031: p_form_version,
2032: p_customer_trx_id,
2033: p_previous_customer_trx_id,

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

2100: l_dummy varchar2(80);
2101:
2102: BEGIN
2103:
2104: arp_util.debug('arp_process_header.update_header_freight_cover()+');
2105:
2106: arp_ct_pkg.set_to_dummy(l_trx_rec);
2107:
2108: l_trx_rec.ship_via := p_ship_via;

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

2127: null,
2128: null,
2129: p_status);
2130:
2131: arp_util.debug('arp_process_header.update_header_freight_cover()-');
2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: arp_util.debug('EXCEPTION : '||

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

2132:
2133: EXCEPTION
2134: WHEN OTHERS THEN
2135: arp_util.debug('EXCEPTION : '||
2136: 'arp_process_header.update_header_freight_cover()-');
2137: arp_util.debug('------- parameters for update_header_freight_cover ----');
2138: arp_util.debug('p_form_name = '||p_form_name);
2139: arp_util.debug('p_form_version = '||p_form_version);
2140: arp_util.debug('p_ship_via = '||p_ship_via);

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

2448: l_commit_memo_line_desc ar_memo_lines.description%type;
2449:
2450: BEGIN
2451:
2452: arp_util.debug('arp_process_header.post_query()+');
2453:
2454: /*-----------------------------------------+
2455: | Initialize the OUT NOCOPY parameters to NULL |
2456: +-----------------------------------------*/

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

2981: l_ct_prev_post_to_gl_flag );
2982: arp_util.debug('p_al_cm_reason_meaning = ' ||
2983: l_al_cm_reason_meaning);
2984:
2985: arp_util.debug('arp_process_header.post_query()-');
2986:
2987: EXCEPTION
2988: WHEN OTHERS THEN
2989: arp_util.debug('EXCEPTION : '||

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

2986:
2987: EXCEPTION
2988: WHEN OTHERS THEN
2989: arp_util.debug('EXCEPTION : '||
2990: 'arp_process_header.post_query()-');
2991: arp_util.debug('------- parameters for post_query ----');
2992: arp_util.debug('p_class = ' || p_class);
2993: arp_util.debug('p_ct_rowid = ' || p_ct_rowid);
2994: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);

Line 3034: END ARP_PROCESS_HEADER;

3030: END init;
3031:
3032: BEGIN
3033: init;
3034: END ARP_PROCESS_HEADER;