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_TBAT_PKG dependencies on ARP_TBAT_PKG

Line 1: PACKAGE BODY ARP_TBAT_PKG AS

1: PACKAGE BODY ARP_TBAT_PKG AS
2: /* $Header: ARTIBATB.pls 120.6 2005/04/14 22:44:45 hyu ship $ */
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

Line 173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);

169: BEGIN
170:
171: arp_util.debug('arp_tbat_pgk.display_batch()+');
172:
173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);
174:
175: arp_tbat_pkg.display_batch_rec (l_batch_rec);
176:
177: arp_util.debug('arp_tbat_pgk.display_batch()-');

Line 175: arp_tbat_pkg.display_batch_rec (l_batch_rec);

171: arp_util.debug('arp_tbat_pgk.display_batch()+');
172:
173: arp_tbat_pkg.fetch_p(l_batch_rec, p_batch_id);
174:
175: arp_tbat_pkg.display_batch_rec (l_batch_rec);
176:
177: arp_util.debug('arp_tbat_pgk.display_batch()-');
178:
179: EXCEPTION

Line 232: arp_util.debug('arp_tbat_pkg.bind_batch_variables()+');

228: p_batch_rec IN ra_batches%rowtype) IS
229:
230: BEGIN
231:
232: arp_util.debug('arp_tbat_pkg.bind_batch_variables()+');
233:
234: /*------------------+
235: | Dummy constants |
236: +------------------*/

Line 359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');

355: p_batch_rec.selection_criteria_id);
356: dbms_sql.bind_variable(p_update_cursor, ':request_id',
357: p_batch_rec.request_id);
358:
359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');

Line 363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');

359: arp_util.debug('arp_tbat_pkg.bind_batch_variables()-');
360:
361: EXCEPTION
362: WHEN OTHERS THEN
363: arp_util.debug('EXCEPTION: arp_tbat_pkg.bind_batch_variables()');
364: RAISE;
365:
366: END;
367:

Line 412: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()+');

408:
409: PROCEDURE construct_batch_update_stmt( update_text OUT NOCOPY varchar2) IS
410:
411: BEGIN
412: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()+');
413:
414: update_text :=
415: 'update ra_batches
416: SET batch_id =

Line 602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');

598: DECODE(:request_id,
599: :ar_number_dummy, request_id,
600: :request_id) ';
601:
602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');

Line 606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');

602: arp_util.debug('arp_tbat_pkg.construct_batch_update_stmt()-');
603:
604: EXCEPTION
605: WHEN OTHERS THEN
606: arp_util.debug('EXCEPTION: arp_tbat_pkg.construct_batch_update_stmt()');
607: RAISE;
608:
609: END;
610:

Line 658: arp_util.debug('arp_tbat_pkg.generic_update()+');

654: l_ra_batch_key_value_list gl_ca_utility_pkg.r_key_value_arr;
655: ra_batch_array dbms_sql.number_table;
656:
657: BEGIN
658: arp_util.debug('arp_tbat_pkg.generic_update()+');
659:
660: /*--------------------------------------------------------------+
661: | If this update statement has not already been parsed, |
662: | construct the statement and parse it. |

Line 676: arp_tbat_pkg.construct_batch_update_stmt(l_update_statement);

672: /*---------------------------------+
673: | Construct the update statement |
674: +---------------------------------*/
675:
676: arp_tbat_pkg.construct_batch_update_stmt(l_update_statement);
677:
678: l_update_statement := l_update_statement || p_where_clause;
679:
680: /* add on mrc variables for bulk collect */

Line 702: arp_tbat_pkg.bind_batch_variables(p_update_cursor, p_batch_rec);

698:
699:
700: END IF;
701:
702: arp_tbat_pkg.bind_batch_variables(p_update_cursor, p_batch_rec);
703:
704: /*-----------------------------------------+
705: | Bind the variables in the where clause |
706: +-----------------------------------------*/

Line 744: arp_util.debug('arp_tbat_pkg.generic_update()-');

740: -- p_key_value => ra_batch_array(I));
741: -- END LOOP;
742: --}
743:
744: arp_util.debug('arp_tbat_pkg.generic_update()-');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');

Line 748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');

744: arp_util.debug('arp_tbat_pkg.generic_update()-');
745:
746: EXCEPTION
747: WHEN OTHERS THEN
748: arp_util.debug('EXCEPTION: arp_tbat_pkg.generic_update()');
749: arp_util.debug(l_update_statement);
750: arp_util.debug('Error at character: ' ||
751: to_char(dbms_sql.last_error_position));
752: RAISE;

Line 802: arp_util.debug('arp_tbat_pkg.set_to_dummy()+');

798: PROCEDURE set_to_dummy( p_batch_rec OUT NOCOPY ra_batches%rowtype) IS
799:
800: BEGIN
801:
802: arp_util.debug('arp_tbat_pkg.set_to_dummy()+');
803:
804: p_batch_rec.batch_id := AR_NUMBER_DUMMY;
805: p_batch_rec.last_update_date := AR_DATE_DUMMY;
806: p_batch_rec.last_updated_by := AR_NUMBER_DUMMY;

Line 851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');

847: p_batch_rec.batch_process_status := AR_TEXT_DUMMY;
848: p_batch_rec.selection_criteria_id := AR_NUMBER_DUMMY;
849: p_batch_rec.request_id := AR_NUMBER_DUMMY;
850:
851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');

Line 855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');

851: arp_util.debug('arp_tbat_pkg.set_to_dummy()-');
852:
853: EXCEPTION
854: WHEN OTHERS THEN
855: arp_util.debug('EXCEPTION: arp_tbat_pkg.set_to_dummy()');
856: RAISE;
857:
858: END;
859:

Line 891: arp_util.debug('arp_tbat_pkg.fetch_p()+');

887: PROCEDURE fetch_p( p_batch_rec OUT NOCOPY ra_batches%rowtype,
888: p_batch_id IN ra_batches.batch_id%type ) IS
889:
890: BEGIN
891: arp_util.debug('arp_tbat_pkg.fetch_p()+');
892:
893: SELECT *
894: INTO p_batch_rec
895: FROM ra_batches

Line 898: arp_util.debug('arp_tbat_pkg.fetch_p()-');

894: INTO p_batch_rec
895: FROM ra_batches
896: WHERE batch_id = p_batch_id;
897:
898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );

Line 902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );

898: arp_util.debug('arp_tbat_pkg.fetch_p()-');
899:
900: EXCEPTION
901: WHEN OTHERS THEN
902: arp_util.debug('EXCEPTION: arp_tbat_pkg.fetch_p' );
903: RAISE;
904: END;
905:
906: /*===========================================================================+

Line 938: arp_util.debug('arp_tbat_pkg.lock_p()+');

934:
935: l_batch_id ra_batches.batch_id%type;
936:
937: BEGIN
938: arp_util.debug('arp_tbat_pkg.lock_p()+');
939:
940: SELECT batch_id
941: INTO l_batch_id
942: FROM ra_batches

Line 946: arp_util.debug('arp_tbat_pkg.lock_p()-');

942: FROM ra_batches
943: WHERE batch_id = p_batch_id
944: FOR UPDATE OF batch_id NOWAIT;
945:
946: arp_util.debug('arp_tbat_pkg.lock_p()-');
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );

Line 950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );

946: arp_util.debug('arp_tbat_pkg.lock_p()-');
947:
948: EXCEPTION
949: WHEN OTHERS THEN
950: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_p' );
951: RAISE;
952: END;
953:
954: /*===========================================================================+

Line 986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');

982: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ra_batches%rowtype,
983: p_batch_id IN ra_batches.batch_id%type ) IS
984:
985: BEGIN
986: arp_util.debug('arp_tbat_pkg.lock_fetch_p()+');
987:
988: SELECT *
989: INTO p_batch_rec
990: FROM ra_batches

Line 994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');

990: FROM ra_batches
991: WHERE batch_id = p_batch_id
992: FOR UPDATE OF batch_id NOWAIT;
993:
994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );

Line 998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );

994: arp_util.debug('arp_tbat_pkg.lock_fetch_p()-');
995:
996: EXCEPTION
997: WHEN OTHERS THEN
998: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_fetch_p' );
999: RAISE;
1000: END;
1001:
1002: /*===========================================================================+

Line 1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');

1044:
1045: l_new_batch_rec ra_batches%rowtype;
1046:
1047: BEGIN
1048: arp_util.debug('arp_tbat_pkg.lock_compare_p()+');
1049:
1050: SELECT *
1051: INTO l_new_batch_rec
1052: FROM ra_batches tbat

Line 1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');

1422: )
1423: )
1424: FOR UPDATE OF batch_id NOWAIT;
1425:
1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');
1427:
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );

Line 1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );

1426: arp_util.debug('arp_tbat_pkg.lock_compare_p()-');
1427:
1428: EXCEPTION
1429: WHEN OTHERS THEN
1430: arp_util.debug( 'EXCEPTION: arp_tbat_pkg.lock_compare_p' );
1431: RAISE;
1432: END;
1433:
1434: /*===========================================================================+

Line 1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');

1515: p_attribute15 IN ra_batches.attribute15%type)
1516: IS
1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN
1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');
1520:
1521: arp_tbat_pkg.set_to_dummy(l_batch_rec);
1522:
1523: l_batch_rec.batch_id := p_batch_id;

Line 1521: arp_tbat_pkg.set_to_dummy(l_batch_rec);

1517: l_batch_rec ra_batches%rowtype;
1518: BEGIN
1519: arp_util.debug('arp_tbat_pkg.lock_compare_cover()+');
1520:
1521: arp_tbat_pkg.set_to_dummy(l_batch_rec);
1522:
1523: l_batch_rec.batch_id := p_batch_id;
1524: l_batch_rec.name := p_name;
1525: l_batch_rec.batch_source_id := p_batch_source_id;

Line 1557: arp_tbat_pkg.lock_compare_p(l_batch_rec,

1553: l_batch_rec.attribute14 := p_attribute14;
1554: l_batch_rec.attribute15 := p_attribute15;
1555:
1556:
1557: arp_tbat_pkg.lock_compare_p(l_batch_rec,
1558: p_batch_id);
1559:
1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:

Line 1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');

1556:
1557: arp_tbat_pkg.lock_compare_p(l_batch_rec,
1558: p_batch_id);
1559:
1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');

Line 1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');

1560: arp_util.debug('arp_tbat_pkg.lock_compare_cover()-');
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: arp_util.debug('EXCEPTION : arp_tbat_pkg.lock_compare_cover');
1565: arp_util.debug('p_batch_id : '||p_batch_id);
1566: arp_util.debug('p_name : '||p_name);
1567: arp_util.debug('p_batch_source_id : '||p_batch_source_id);
1568: arp_util.debug('p_batch_date : '||p_batch_date);

Line 1634: arp_util.debug('arp_tbat_pkg.delete_p()+');

1630: l_count number;
1631:
1632: BEGIN
1633:
1634: arp_util.debug('arp_tbat_pkg.delete_p()+');
1635:
1636: /*-----------------------------------------------------+
1637: | Determine the number of transactions in the batch. |
1638: | The procedure only deletes batches that do not |

Line 1667: arp_util.debug('arp_tbat_pkg.delete_p()-');

1663: fnd_message.set_name('AR', '250');
1664: app_exception.raise_exception;
1665: END IF;
1666:
1667: arp_util.debug('arp_tbat_pkg.delete_p()-');
1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');

Line 1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');

1667: arp_util.debug('arp_tbat_pkg.delete_p()-');
1668:
1669: EXCEPTION
1670: WHEN OTHERS THEN
1671: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_p()');
1672: RAISE;
1673:
1674: END;
1675:

Line 1710: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()+');

1706: l_count number;
1707:
1708: BEGIN
1709:
1710: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()+');
1711:
1712: /*-----------------------------------------------------+
1713: | Determine the number of transactions in the batch. |
1714: | The procedure only deletes batches that do not |

Line 1743: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()-');

1739: fnd_message.set_name('AR', '250');
1740: app_exception.raise_exception;
1741: END IF;
1742:
1743: arp_util.debug('arp_tbat_pkg.delete_f_bs_id()-');
1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747:

Line 1748: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_f_bs_id()');

1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747:
1748: arp_util.debug('EXCEPTION: arp_tbat_pkg.delete_f_bs_id()');
1749: RAISE;
1750:
1751: END;
1752:

Line 1789: arp_util.debug('arp_tbat_pkg.update_p()+');

1785:
1786:
1787: BEGIN
1788:
1789: arp_util.debug('arp_tbat_pkg.update_p()+');
1790:
1791: arp_tbat_pkg.generic_update( pg_cursor1,
1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,

Line 1791: arp_tbat_pkg.generic_update( pg_cursor1,

1787: BEGIN
1788:
1789: arp_util.debug('arp_tbat_pkg.update_p()+');
1790:
1791: arp_tbat_pkg.generic_update( pg_cursor1,
1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,
1794: p_batch_rec);
1795:

Line 1796: arp_util.debug('arp_tbat_pkg.update_p()-');

1792: ' WHERE batch_id = :where_1',
1793: p_batch_id,
1794: p_batch_rec);
1795:
1796: arp_util.debug('arp_tbat_pkg.update_p()-');
1797:
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN

Line 1801: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_p()');

1797:
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_p()');
1802: RAISE;
1803: END;
1804:
1805: /*===========================================================================+

Line 1842: arp_util.debug('arp_tbat_pkg.update_f_bs_id()+');

1838:
1839:
1840: BEGIN
1841:
1842: arp_util.debug('arp_tbat_pkg.update_f_bs_id()+');
1843:
1844: arp_tbat_pkg.generic_update( pg_cursor2,
1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,

Line 1844: arp_tbat_pkg.generic_update( pg_cursor2,

1840: BEGIN
1841:
1842: arp_util.debug('arp_tbat_pkg.update_f_bs_id()+');
1843:
1844: arp_tbat_pkg.generic_update( pg_cursor2,
1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,
1847: p_batch_rec);
1848:

Line 1849: arp_util.debug('arp_tbat_pkg.update_f_bs_id()-');

1845: ' WHERE batch_source_id = :where_1',
1846: p_batch_source_id,
1847: p_batch_rec);
1848:
1849: arp_util.debug('arp_tbat_pkg.update_f_bs_id()-');
1850:
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN

Line 1854: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_f_bs_id()');

1850:
1851:
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: arp_util.debug('EXCEPTION: arp_tbat_pkg.update_f_bs_id()');
1855: RAISE;
1856: END;
1857:
1858: /*===========================================================================+

Line 1909: arp_util.debug('arp_tbat_pkg.insert_p()+');

1905: l_ra_batches_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
1906:
1907: BEGIN
1908:
1909: arp_util.debug('arp_tbat_pkg.insert_p()+');
1910:
1911: p_batch_id := '';
1912:
1913: /*---------------------------*

Line 2062: arp_util.debug('arp_tbat_pkg.insert_p()-');

2058: -- p_table_name => 'RA_BATCHES',
2059: -- p_mode => 'SINGLE',
2060: -- p_key_value => l_batch_id);
2061: --}
2062: arp_util.debug('arp_tbat_pkg.insert_p()-');
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');

Line 2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');

2062: arp_util.debug('arp_tbat_pkg.insert_p()-');
2063:
2064: EXCEPTION
2065: WHEN OTHERS THEN
2066: arp_util.debug('EXCEPTION: arp_tbat_pkg.insert_p()');
2067: RAISE;
2068: END;
2069:
2070:

Line 2085: END ARP_TBAT_PKG;

2081: pg_prog_appl_id := fnd_global.prog_appl_id;
2082: pg_conc_program_id := fnd_global.conc_program_id;
2083:
2084:
2085: END ARP_TBAT_PKG;