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_APP_PKG dependencies on ARP_APP_PKG

Line 1: PACKAGE BODY ARP_APP_PKG AS

1: PACKAGE BODY ARP_APP_PKG AS
2: /* $Header: ARCIAPPB.pls 120.12 2006/12/14 03:16:21 mraymond ship $*/
3:
4: /*===========================================================================+
5: | FUNCTION |

Line 81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );

77: p_ra_rec IN ar_receivable_applications%ROWTYPE
78: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
79: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
80: BEGIN
81: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
82: arp_standard.debug(' p_ra_id = ' || p_ra_id);
83: IF p_ra_id IS NULL
84: THEN
85: SELECT ar_receivable_applications_s.nextval

Line 332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );

328: ,'R12'
329: );
330: p_ra_id := l_ra_id;
331:
332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );

Line 336: 'EXCEPTION: arp_app_pkg.insert_p' );

332: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
333: EXCEPTION
334: WHEN OTHERS THEN
335: arp_standard.debug(
336: 'EXCEPTION: arp_app_pkg.insert_p' );
337: arp_standard.debug('SYSDATE = ' || SYSDATE);
338: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
339: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
340: p_ra_rec.last_update_login) ), ''));

Line 445: arp_standard.debug( 'arp_app_pkg.update_p()+' );

441: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
442: lc_dump VARCHAR2(30000);
443:
444: BEGIN
445: arp_standard.debug( 'arp_app_pkg.update_p()+' );
446:
447: UPDATE ar_receivable_applications ra SET
448: acctd_amount_applied_from =
449: p_ra_rec.acctd_amount_applied_from,

Line 577: arp_standard.debug('arp_app_pkg.update_p()-' );

573: customer_reason = p_ra_rec.customer_reason,
574: applied_rec_app_id = p_ra_rec.applied_rec_app_id
575: WHERE ra.receivable_application_id = p_ra_rec.receivable_application_id;
576:
577: arp_standard.debug('arp_app_pkg.update_p()-' );
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );

Line 581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );

577: arp_standard.debug('arp_app_pkg.update_p()-' );
578:
579: EXCEPTION
580: WHEN OTHERS THEN
581: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );
582:
583: -- Dump all parameter values and return them to error stack
584: -- for debugging purposes.
585: lc_dump := 'DUMP of procedure parameter values:'

Line 723: arp_standard.debug( 'arp_app_pkg.delete_p()+' );

719: +===========================================================================*/
720: PROCEDURE delete_p(
721: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
722: BEGIN
723: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
724:
725: DELETE FROM ar_receivable_applications ra
726: WHERE ra.receivable_application_id = p_ra_id;
727:

Line 740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );

736: -- p_mode => 'SINGLE',
737: -- p_key_value => p_ra_id);
738: --}
739:
740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
741: EXCEPTION
742: WHEN OTHERS THEN
743: arp_standard.debug(
744: 'EXCEPTION: arp_app_pkg.delete_p' );

Line 744: 'EXCEPTION: arp_app_pkg.delete_p' );

740: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
741: EXCEPTION
742: WHEN OTHERS THEN
743: arp_standard.debug(
744: 'EXCEPTION: arp_app_pkg.delete_p' );
745: RAISE;
746: END;
747:
748: /*===========================================================================+

Line 782: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );

778:
779: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
780:
781: BEGIN
782: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
783: FOR i IN c_ra_rec LOOP
784:
785: DELETE FROM ar_receivable_applications ra
786: WHERE ra.receivable_application_id = i.receivable_application_id;

Line 818: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );

814: -- p_mode => 'BATCH',
815: -- p_key_value_list => l_ar_dist_key_value_list);
816: --}
817: END LOOP;
818: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );
819: EXCEPTION
820: WHEN OTHERS THEN
821: NULL;
822: END;

Line 850: arp_standard.debug( 'arp_app_pkg.lock_p()+');

846: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
847: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
848: BEGIN
849: IF PG_DEBUG in ('Y', 'C') THEN
850: arp_standard.debug( 'arp_app_pkg.lock_p()+');
851: END IF;
852:
853: SELECT ra.receivable_application_id
854: INTO l_ra_id

Line 860: arp_standard.debug( 'arp_app_pkg.lock_p()-');

856: WHERE ra.receivable_application_id = p_ra_id
857: FOR UPDATE OF STATUS NOWAIT;
858:
859: IF PG_DEBUG in ('Y', 'C') THEN
860: arp_standard.debug( 'arp_app_pkg.lock_p()-');
861: END IF;
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF PG_DEBUG in ('Y', 'C') THEN

Line 865: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );

861: END IF;
862: EXCEPTION
863: WHEN OTHERS THEN
864: IF PG_DEBUG in ('Y', 'C') THEN
865: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );
866: END IF;
867: RAISE;
868: END lock_p;
869:

Line 898: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');

894: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
895: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
896: BEGIN
897: IF PG_DEBUG in ('Y', 'C') THEN
898: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
899: END IF;
900:
901: SELECT ra.receivable_application_id
902: INTO l_ra_id

Line 908: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');

904: WHERE ra.receivable_application_id = p_ra_id
905: FOR UPDATE OF STATUS NOWAIT;
906:
907: IF PG_DEBUG in ('Y', 'C') THEN
908: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');
909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF PG_DEBUG in ('Y', 'C') THEN

Line 913: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );

909: END IF;
910: EXCEPTION
911: WHEN OTHERS THEN
912: IF PG_DEBUG in ('Y', 'C') THEN
913: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );
914: END IF;
915: RAISE;
916: END nowaitlock_p;
917:

Line 946: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );

942: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
943: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
944: BEGIN
945: IF PG_DEBUG in ('Y', 'C') THEN
946: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
947: END IF;
948:
949: SELECT *
950: INTO p_ra_rec

Line 955: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );

951: FROM ar_receivable_applications
952: WHERE receivable_application_id = p_ra_id;
953:
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );
956: END IF;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN

Line 960: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );

956: END IF;
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN
960: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );
961: END IF;
962: RAISE;
963:
964: END fetch_p;

Line 966: END ARP_APP_PKG;

962: RAISE;
963:
964: END fetch_p;
965:
966: END ARP_APP_PKG;
967: