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.24.12020000.2 2012/07/26 06:17:15 ashlkuma ship $*/
3:
4: /*===========================================================================+
5: | FUNCTION |

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

83: p_ra_rec IN ar_receivable_applications%ROWTYPE
84: , p_ra_id IN OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE ) IS
85: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
86: BEGIN
87: arp_standard.debug( 'arp_app_pkg.insert_p()+' );
88: arp_standard.debug(' p_ra_id = ' || p_ra_id);
89: IF p_ra_id IS NULL
90: THEN
91: SELECT ar_receivable_applications_s.nextval

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

342: ,p_ra_rec.on_acct_po_num
343: );
344: p_ra_id := l_ra_id;
345:
346: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
347: EXCEPTION
348: WHEN OTHERS THEN
349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );

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

346: arp_standard.debug( 'arp_app_pkg.insert_p()-' );
347: EXCEPTION
348: WHEN OTHERS THEN
349: arp_standard.debug(
350: 'EXCEPTION: arp_app_pkg.insert_p' );
351: arp_standard.debug('SYSDATE = ' || SYSDATE);
352: arp_standard.debug('arp_standard.profile.user_id = ' || TO_CHAR(arp_standard.profile.user_id));
353: arp_standard.debug('last_update_login = ' || NVL(TO_CHAR(NVL( arp_standard.profile.last_update_login,
354: p_ra_rec.last_update_login) ), ''));

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

459: PROCEDURE update_p( p_ra_rec IN ar_receivable_applications%ROWTYPE ) IS
460: lc_dump VARCHAR2(30000);
461:
462: BEGIN
463: arp_standard.debug( 'arp_app_pkg.update_p()+' );
464:
465: UPDATE ar_receivable_applications ra SET
466: acctd_amount_applied_from =
467: p_ra_rec.acctd_amount_applied_from,

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

595: on_acct_cust_site_use_id = p_ra_rec.on_acct_cust_site_use_id,
596: on_acct_po_num = p_ra_rec.on_acct_po_num
597: WHERE ra.receivable_application_id = p_ra_rec.receivable_application_id;
598:
599: arp_standard.debug('arp_app_pkg.update_p()-' );
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );

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

599: arp_standard.debug('arp_app_pkg.update_p()-' );
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: arp_standard.debug( 'EXCEPTION: arp_app_pkg.update_p' );
604:
605: -- Dump all parameter values and return them to error stack
606: -- for debugging purposes.
607: lc_dump := 'DUMP of procedure parameter values:'

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

744: +===========================================================================*/
745: PROCEDURE delete_p(
746: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE ) IS
747: BEGIN
748: arp_standard.debug( 'arp_app_pkg.delete_p()+' );
749:
750: DELETE FROM ar_receivable_applications ra
751: WHERE ra.receivable_application_id = p_ra_id;
752:

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

761: -- p_mode => 'SINGLE',
762: -- p_key_value => p_ra_id);
763: --}
764:
765: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
766: EXCEPTION
767: WHEN OTHERS THEN
768: arp_standard.debug(
769: 'EXCEPTION: arp_app_pkg.delete_p' );

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

765: arp_standard.debug( 'arp_app_pkg.delete_p()-' );
766: EXCEPTION
767: WHEN OTHERS THEN
768: arp_standard.debug(
769: 'EXCEPTION: arp_app_pkg.delete_p' );
770: RAISE;
771: END;
772:
773: /*===========================================================================+

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

803:
804: l_ar_dist_key_value_list gl_ca_utility_pkg.r_key_value_arr;
805:
806: BEGIN
807: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()+' );
808: FOR i IN c_ra_rec LOOP
809:
810: DELETE FROM ar_receivable_applications ra
811: WHERE ra.receivable_application_id = i.receivable_application_id;

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

839: -- p_mode => 'BATCH',
840: -- p_key_value_list => l_ar_dist_key_value_list);
841: --}
842: END LOOP;
843: arp_standard.debug( 'arp_app_pkg.delete_f_ct_id()-' );
844: EXCEPTION
845: WHEN OTHERS THEN
846: NULL;
847: END;

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

872: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
873: l_event_id xla_events.event_id%TYPE;
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_standard.debug( 'arp_app_pkg.lock_p()+');
877: END IF;
878:
879: SAVEPOINT lock_p_savepoint;
880:

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

899: WHERE ra.receivable_application_id = p_ra_id
900: FOR UPDATE OF STATUS NOWAIT;
901:
902: IF PG_DEBUG in ('Y', 'C') THEN
903: arp_standard.debug( 'arp_app_pkg.lock_p()-');
904: END IF;
905: EXCEPTION
906: WHEN OTHERS THEN
907: ROLLBACK TO lock_p_savepoint;

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

905: EXCEPTION
906: WHEN OTHERS THEN
907: ROLLBACK TO lock_p_savepoint;
908: IF PG_DEBUG in ('Y', 'C') THEN
909: arp_standard.debug( 'EXCEPTION: arp_app_pkg.lock_p' );
910: END IF;
911: RAISE;
912: END lock_p;
913:

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

939: l_ra_id ar_receivable_applications.receivable_application_id%TYPE;
940: l_event_id xla_events.event_id%TYPE;
941: BEGIN
942: IF PG_DEBUG in ('Y', 'C') THEN
943: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()+');
944: END IF;
945:
946: SAVEPOINT nowaitlock_p_savepoint;
947:

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

966: WHERE ra.receivable_application_id = p_ra_id
967: FOR UPDATE OF STATUS NOWAIT;
968:
969: IF PG_DEBUG in ('Y', 'C') THEN
970: arp_standard.debug( 'arp_app_pkg.nowaitlock_p()-');
971: END IF;
972: EXCEPTION
973: WHEN OTHERS THEN
974: ROLLBACK TO nowaitlock_p_savepoint;

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

972: EXCEPTION
973: WHEN OTHERS THEN
974: ROLLBACK TO nowaitlock_p_savepoint;
975: IF PG_DEBUG in ('Y', 'C') THEN
976: arp_standard.debug( 'EXCEPTION: arp_app_pkg.nowaitlock_p' );
977: END IF;
978: RAISE;
979: END nowaitlock_p;
980:

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

1005: p_ra_id IN ar_receivable_applications.receivable_application_id%TYPE,
1006: p_ra_rec OUT NOCOPY ar_receivable_applications%ROWTYPE ) IS
1007: BEGIN
1008: IF PG_DEBUG in ('Y', 'C') THEN
1009: arp_standard.debug( 'arp_app_pkg.fetch_p()+' );
1010: END IF;
1011:
1012: SELECT *
1013: INTO p_ra_rec

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

1014: FROM ar_receivable_applications
1015: WHERE receivable_application_id = p_ra_id;
1016:
1017: IF PG_DEBUG in ('Y', 'C') THEN
1018: arp_standard.debug( 'arp_app_pkg.fetch_p()-' );
1019: END IF;
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: IF PG_DEBUG in ('Y', 'C') THEN

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

1019: END IF;
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: IF PG_DEBUG in ('Y', 'C') THEN
1023: arp_standard.debug('fetch_p: ' || 'EXCEPTION: arp_app_pkg error' );
1024: END IF;
1025: RAISE;
1026:
1027: END fetch_p;

Line 1123: END ARP_APP_PKG;

1119: return llca_flow;
1120: END compare_for_llca;
1121:
1122:
1123: END ARP_APP_PKG;
1124: