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_CASH_RECEIPTS_PKG dependencies on ARP_UTIL

Line 32: arp_util.debug( 'arp_cash_receipts_pkg.set_to_dummy()+' );

28:
29: PROCEDURE set_to_dummy( p_cr_rec OUT NOCOPY ar_cash_receipts%ROWTYPE ) IS
30: BEGIN
31: IF PG_DEBUG in ('Y', 'C') THEN
32: arp_util.debug( 'arp_cash_receipts_pkg.set_to_dummy()+' );
33: END IF;
34: --
35: p_cr_rec.amount := AR_NUMBER_DUMMY;
36: p_cr_rec.currency_code := AR_TEXT_DUMMY;

Line 138: arp_util.debug( 'arp_cash_receipts_pkg.set_to_dummy_p()-' );

134:
135: p_cr_rec.payment_trxn_extension_id := AR_NUMBER_DUMMY; /* bichatte payment uptake project */
136: --
137: IF PG_DEBUG in ('Y', 'C') THEN
138: arp_util.debug( 'arp_cash_receipts_pkg.set_to_dummy_p()-' );
139: END IF;
140: --
141: EXCEPTION
142: WHEN OTHERS THEN

Line 144: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.set_to_dummy' );

140: --
141: EXCEPTION
142: WHEN OTHERS THEN
143: IF PG_DEBUG in ('Y', 'C') THEN
144: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.set_to_dummy' );
145: END IF;
146: RAISE;
147: END set_to_dummy;
148: --

Line 161: arp_util.debug( 'arp_cash_receipts_pkg.insert_p()+' );

157: --end LE
158:
159: BEGIN
160: IF PG_DEBUG in ('Y', 'C') THEN
161: arp_util.debug( 'arp_cash_receipts_pkg.insert_p()+' );
162: END IF;
163: --
164: SELECT ar_cash_receipts_s.nextval
165: INTO l_cr_id

Line 387: arp_util.debug( 'arp_cash_receipts_pkg.insert_p()-' );

383: p_key_value => l_cr_id);
384:
385: --
386: IF PG_DEBUG in ('Y', 'C') THEN
387: arp_util.debug( 'arp_cash_receipts_pkg.insert_p()-' );
388: END IF;
389: --
390: EXCEPTION
391: WHEN OTHERS THEN

Line 393: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.insert_p' );

389: --
390: EXCEPTION
391: WHEN OTHERS THEN
392: IF PG_DEBUG in ('Y', 'C') THEN
393: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.insert_p' );
394: END IF;
395: RAISE;
396: END insert_p;
397: --

Line 402: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );

398: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,
399: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
400: BEGIN
401: IF PG_DEBUG in ('Y', 'C') THEN
402: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
403: END IF;
404: --
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');

Line 406: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');

402: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
403: END IF;
404: --
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');
407: END IF;
408: UPDATE ar_cash_receipts SET
409: amount = DECODE( p_cr_rec.amount,
410: AR_NUMBER_DUMMY, amount,

Line 701: arp_util.debug('update_p: ' || 'after updating cash_receipts');

697: WHERE
698: cash_receipt_id = p_cr_id; -- OSTEINME 3/12/01 bug 1683007
699:
700: IF PG_DEBUG in ('Y', 'C') THEN
701: arp_util.debug('update_p: ' || 'after updating cash_receipts');
702: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));
703: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));
704: END IF;
705: --

Line 702: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));

698: cash_receipt_id = p_cr_id; -- OSTEINME 3/12/01 bug 1683007
699:
700: IF PG_DEBUG in ('Y', 'C') THEN
701: arp_util.debug('update_p: ' || 'after updating cash_receipts');
702: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));
703: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));
704: END IF;
705: --
706:

Line 703: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));

699:
700: IF PG_DEBUG in ('Y', 'C') THEN
701: arp_util.debug('update_p: ' || 'after updating cash_receipts');
702: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));
703: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));
704: END IF;
705: --
706:
707: /*-----------------------------------+

Line 720: arp_util.debug( 'arp_cash_receipts_pkg.update_p()-' );

716: p_key_value => p_cr_id);
717:
718: --
719: IF PG_DEBUG in ('Y', 'C') THEN
720: arp_util.debug( 'arp_cash_receipts_pkg.update_p()-' );
721: END IF;
722: --
723: EXCEPTION
724: WHEN OTHERS THEN

Line 726: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.update_p' );

722: --
723: EXCEPTION
724: WHEN OTHERS THEN
725: IF PG_DEBUG in ('Y', 'C') THEN
726: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.update_p' );
727: END IF;
728: RAISE;
729: END update_p;
730: ---------------------------------------------------------------------------------

Line 740: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );

736: ---------------------------------------------------------------------------------
737: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
738: BEGIN
739: IF PG_DEBUG in ('Y', 'C') THEN
740: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
741: END IF;
742: --
743: arp_cash_receipts_pkg.update_p (p_cr_rec,
744: p_cr_rec.cash_receipt_id);

Line 747: arp_util.debug( 'arp_cash_receipts_pkg.update_p()-' );

743: arp_cash_receipts_pkg.update_p (p_cr_rec,
744: p_cr_rec.cash_receipt_id);
745: --
746: IF PG_DEBUG in ('Y', 'C') THEN
747: arp_util.debug( 'arp_cash_receipts_pkg.update_p()-' );
748: END IF;
749: --
750: END update_p;
751: --

Line 756: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );

752: PROCEDURE delete_p(
753: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
754: BEGIN
755: IF PG_DEBUG in ('Y', 'C') THEN
756: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );
757: END IF;
758: --
759: DELETE FROM ar_cash_receipts
760: WHERE cash_receipt_id = p_cr_id;

Line 775: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()-' );

771: p_key_value => p_cr_id);
772:
773: --
774: IF PG_DEBUG in ('Y', 'C') THEN
775: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()-' );
776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN
779: IF PG_DEBUG in ('Y', 'C') THEN

Line 780: arp_util.debug( 'Exception: arp_cash_receipts_pkg.delete_p' );

776: END IF;
777: EXCEPTION
778: WHEN OTHERS THEN
779: IF PG_DEBUG in ('Y', 'C') THEN
780: arp_util.debug( 'Exception: arp_cash_receipts_pkg.delete_p' );
781: END IF;
782: RAISE;
783: END delete_p;
784: --

Line 790: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );

786: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
787: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
788: BEGIN
789: IF PG_DEBUG in ('Y', 'C') THEN
790: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );
791: END IF;
792: --
793: SELECT cash_receipt_id
794: INTO l_cr_id

Line 800: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()-' );

796: WHERE cash_receipt_id = p_cr_id
797: FOR UPDATE OF STATUS;
798: --
799: IF PG_DEBUG in ('Y', 'C') THEN
800: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()-' );
801: END IF;
802: EXCEPTION
803: WHEN OTHERS THEN
804: IF PG_DEBUG in ('Y', 'C') THEN

Line 805: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.lock_p' );

801: END IF;
802: EXCEPTION
803: WHEN OTHERS THEN
804: IF PG_DEBUG in ('Y', 'C') THEN
805: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.lock_p' );
806: END IF;
807: RAISE;
808: END lock_p;
809: --

Line 816: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );

812: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
813: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
814: BEGIN
815: IF PG_DEBUG in ('Y', 'C') THEN
816: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );
817: END IF;
818: --
819: SELECT cash_receipt_id
820: INTO l_cr_id

Line 826: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()-' );

822: WHERE cash_receipt_id = p_cr_id
823: FOR UPDATE OF STATUS NOWAIT;
824: --
825: IF PG_DEBUG in ('Y', 'C') THEN
826: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()-' );
827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF PG_DEBUG in ('Y', 'C') THEN

Line 831: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_p' );

827: END IF;
828: EXCEPTION
829: WHEN OTHERS THEN
830: IF PG_DEBUG in ('Y', 'C') THEN
831: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_p' );
832: END IF;
833: RAISE;
834: END nowaitlock_p;
835: --

Line 844: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );

840: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
841: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
842: BEGIN
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
845: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));
846: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));
847: END IF;
848: --

Line 845: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));

841: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
842: BEGIN
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
845: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));
846: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));
847: END IF;
848: --
849:

Line 846: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));

842: BEGIN
843: IF PG_DEBUG in ('Y', 'C') THEN
844: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
845: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));
846: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));
847: END IF;
848: --
849:
850: SELECT cash_receipt_id

Line 863: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()-' );

859: )
860: FOR UPDATE OF REC_VERSION_NUMBER NOWAIT;
861: --
862: IF PG_DEBUG in ('Y', 'C') THEN
863: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()-' );
864: END IF;
865: EXCEPTION
866: WHEN OTHERS THEN
867: IF PG_DEBUG in ('Y', 'C') THEN

Line 868: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_version_p()' );

864: END IF;
865: EXCEPTION
866: WHEN OTHERS THEN
867: IF PG_DEBUG in ('Y', 'C') THEN
868: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_version_p()' );
869: END IF;
870: RAISE;
871: END nowaitlock_version_p;
872:

Line 876: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );

872:
873: PROCEDURE update_version_number(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE) IS
874: BEGIN
875: IF PG_DEBUG in ('Y', 'C') THEN
876: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );
877: END IF;
878:
879: update ar_cash_receipts
880: set rec_version_number = nvl(rec_version_number,1)+1

Line 884: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()-');

880: set rec_version_number = nvl(rec_version_number,1)+1
881: where cash_receipt_id = p_cr_id;
882:
883: IF PG_DEBUG in ('Y', 'C') THEN
884: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()-');
885: END IF;
886: EXCEPTION
887: WHEN OTHERS THEN
888: IF PG_DEBUG in ('Y', 'C') THEN

Line 889: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.update_version_number()' );

885: END IF;
886: EXCEPTION
887: WHEN OTHERS THEN
888: IF PG_DEBUG in ('Y', 'C') THEN
889: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.update_version_number()' );
890: END IF;
891: RAISE;
892: END update_version_number;
893:

Line 899: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()+' );

895: PROCEDURE fetch_p(
896: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
897: BEGIN
898: IF PG_DEBUG in ('Y', 'C') THEN
899: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()+' );
900: END IF;
901: --
902: SELECT *
903: INTO p_cr_rec

Line 908: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()-' );

904: FROM ar_cash_receipts
905: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
906: --
907: IF PG_DEBUG in ('Y', 'C') THEN
908: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()-' );
909: END IF;
910: --
911: EXCEPTION
912: WHEN OTHERS THEN

Line 914: arp_util.debug('fetch_p: ' ||

910: --
911: EXCEPTION
912: WHEN OTHERS THEN
913: IF PG_DEBUG in ('Y', 'C') THEN
914: arp_util.debug('fetch_p: ' ||
915: 'EXCEPTION: arp_cash_receipts_pkg.fetch error' );
916: END IF;
917: RAISE;
918: END fetch_p;

Line 925: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()+' );

921: PROCEDURE lock_fetch_p(
922: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
923: BEGIN
924: IF PG_DEBUG in ('Y', 'C') THEN
925: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()+' );
926: END IF;
927: --
928: SELECT *
929: INTO p_cr_rec

Line 935: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()-' );

931: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
932: FOR UPDATE OF status;
933: --
934: IF PG_DEBUG in ('Y', 'C') THEN
935: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()-' );
936: END IF;
937: --
938: EXCEPTION
939: WHEN OTHERS THEN

Line 941: arp_util.debug('lock_fetch_p: ' ||

937: --
938: EXCEPTION
939: WHEN OTHERS THEN
940: IF PG_DEBUG in ('Y', 'C') THEN
941: arp_util.debug('lock_fetch_p: ' ||
942: 'EXCEPTION: arp_cash_receipts_pkg.lock_fetch_p' );
943: END IF;
944: RAISE;
945: END lock_fetch_p;

Line 952: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()+' );

948: PROCEDURE nowaitlock_fetch_p(
949: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
950: BEGIN
951: IF PG_DEBUG in ('Y', 'C') THEN
952: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()+' );
953: END IF;
954: --
955: SELECT *
956: INTO p_cr_rec

Line 962: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()-' );

958: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
959: FOR UPDATE OF status NOWAIT;
960: --
961: IF PG_DEBUG in ('Y', 'C') THEN
962: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()-' );
963: END IF;
964: --
965: EXCEPTION
966: WHEN OTHERS THEN

Line 968: arp_util.debug('nowaitlock_fetch_p: ' ||

964: --
965: EXCEPTION
966: WHEN OTHERS THEN
967: IF PG_DEBUG in ('Y', 'C') THEN
968: arp_util.debug('nowaitlock_fetch_p: ' ||
969: 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_fetch_p' );
970: END IF;
971: RAISE;
972: END nowaitlock_fetch_p;

Line 988: arp_util.debug( 'arp_cash_receipts_pkg.lock_f_batch_id()+' );

984: FOR UPDATE OF cr.status;
985: --
986: BEGIN
987: IF PG_DEBUG in ('Y', 'C') THEN
988: arp_util.debug( 'arp_cash_receipts_pkg.lock_f_batch_id()+' );
989: END IF;
990: --
991: OPEN lock_C;
992: CLOSE lock_C;

Line 995: arp_util.debug( 'arp_cash_receipts_pkg.lock_f_batch_id()-' );

991: OPEN lock_C;
992: CLOSE lock_C;
993: --
994: IF PG_DEBUG in ('Y', 'C') THEN
995: arp_util.debug( 'arp_cash_receipts_pkg.lock_f_batch_id()-' );
996: END IF;
997: --
998: EXCEPTION
999: WHEN OTHERS THEN

Line 1005: arp_util.debug('lock_f_batch_id: ' ||

1001: CLOSE lock_C;
1002: END IF;
1003: --
1004: IF PG_DEBUG in ('Y', 'C') THEN
1005: arp_util.debug('lock_f_batch_id: ' ||
1006: 'EXCEPTION: arp_cash_receipts_pkg.lock_f_batch_id' );
1007: END IF;
1008: RAISE;
1009: END lock_f_batch_id;

Line 1025: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_f_batch_id()+' );

1021: FOR UPDATE OF cr.status NOWAIT;
1022: --
1023: BEGIN
1024: IF PG_DEBUG in ('Y', 'C') THEN
1025: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_f_batch_id()+' );
1026: END IF;
1027: --
1028: OPEN lock_C;
1029: CLOSE lock_C;

Line 1032: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_f_batch_id()-' );

1028: OPEN lock_C;
1029: CLOSE lock_C;
1030: --
1031: IF PG_DEBUG in ('Y', 'C') THEN
1032: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_f_batch_id()-' );
1033: END IF;
1034: --
1035: EXCEPTION
1036: WHEN OTHERS THEN

Line 1042: arp_util.debug('nowaitlock_f_batch_id: ' ||

1038: CLOSE lock_C;
1039: END IF;
1040: --
1041: IF PG_DEBUG in ('Y', 'C') THEN
1042: arp_util.debug('nowaitlock_f_batch_id: ' ||
1043: 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_f_batch_id' );
1044: END IF;
1045: RAISE;
1046: END nowaitlock_f_batch_id;

Line 1056: arp_util.debug('arp_cash_receipts_pkg.lock_compare_p()+');

1052: l_exchange_date DATE;
1053:
1054: BEGIN
1055: IF PG_DEBUG in ('Y', 'C') THEN
1056: arp_util.debug('arp_cash_receipts_pkg.lock_compare_p()+');
1057: END IF;
1058:
1059: /* For testing only:
1060:

Line 1767: arp_util.debug('arp_cash_receipts_pkg.lock_compare_p()-');

1763: )
1764: FOR UPDATE NOWAIT;
1765:
1766: IF PG_DEBUG in ('Y', 'C') THEN
1767: arp_util.debug('arp_cash_receipts_pkg.lock_compare_p()-');
1768: END IF;
1769:
1770: EXCEPTION
1771: WHEN OTHERS THEN

Line 1773: arp_util.debug('EXCEPTION: arp_cash_receipts_pkg.lock_compare_p()');

1769:
1770: EXCEPTION
1771: WHEN OTHERS THEN
1772: IF PG_DEBUG in ('Y', 'C') THEN
1773: arp_util.debug('EXCEPTION: arp_cash_receipts_pkg.lock_compare_p()');
1774: END IF;
1775: RAISE;
1776:
1777: END lock_compare_p;