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 140: arp_util.debug( 'arp_cash_receipts_pkg.set_to_dummy_p()-' );

136: p_cr_rec.automatch_set_id := AR_NUMBER_DUMMY; /* ER Automatch Application */
137: p_cr_rec.autoapply_flag := AR_FLAG_DUMMY;
138: --
139: IF PG_DEBUG in ('Y', 'C') THEN
140: arp_util.debug( 'arp_cash_receipts_pkg.set_to_dummy_p()-' );
141: END IF;
142: --
143: EXCEPTION
144: WHEN OTHERS THEN

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

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

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

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

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

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

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

395: --
396: EXCEPTION
397: WHEN OTHERS THEN
398: IF PG_DEBUG in ('Y', 'C') THEN
399: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.insert_p' );
400: END IF;
401: RAISE;
402: END insert_p;
403: --

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

404: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE,
405: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
406: BEGIN
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
409: END IF;
410: --
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');

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

408: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
409: END IF;
410: --
411: IF PG_DEBUG in ('Y', 'C') THEN
412: arp_util.debug('update_p: ' || 'before call to update ar_cash_receipts');
413: END IF;
414: UPDATE ar_cash_receipts SET
415: amount = DECODE( p_cr_rec.amount,
416: AR_NUMBER_DUMMY, amount,

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

709: WHERE
710: cash_receipt_id = p_cr_id; -- OSTEINME 3/12/01 bug 1683007
711:
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_util.debug('update_p: ' || 'after updating cash_receipts');
714: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));
715: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));
716: END IF;
717: --

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

710: cash_receipt_id = p_cr_id; -- OSTEINME 3/12/01 bug 1683007
711:
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_util.debug('update_p: ' || 'after updating cash_receipts');
714: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));
715: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));
716: END IF;
717: --
718:

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

711:
712: IF PG_DEBUG in ('Y', 'C') THEN
713: arp_util.debug('update_p: ' || 'after updating cash_receipts');
714: arp_util.debug('update_p: ' || 'exchange_rate = ' || to_char(p_cr_rec.exchange_rate));
715: arp_util.debug('update_p: ' || 'exchange date = ' || to_char(p_cr_rec.exchange_date));
716: END IF;
717: --
718:
719: /*-----------------------------------+

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

728: p_key_value => p_cr_id);
729:
730: --
731: IF PG_DEBUG in ('Y', 'C') THEN
732: arp_util.debug( 'arp_cash_receipts_pkg.update_p()-' );
733: END IF;
734: --
735: EXCEPTION
736: WHEN OTHERS THEN

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

734: --
735: EXCEPTION
736: WHEN OTHERS THEN
737: IF PG_DEBUG in ('Y', 'C') THEN
738: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.update_p' );
739: END IF;
740: RAISE;
741: END update_p;
742: ---------------------------------------------------------------------------------

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

748: ---------------------------------------------------------------------------------
749: PROCEDURE update_p( p_cr_rec IN ar_cash_receipts%ROWTYPE ) IS
750: BEGIN
751: IF PG_DEBUG in ('Y', 'C') THEN
752: arp_util.debug( 'arp_cash_receipts_pkg.update_p()+' );
753: END IF;
754: --
755: arp_cash_receipts_pkg.update_p (p_cr_rec,
756: p_cr_rec.cash_receipt_id);

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

755: arp_cash_receipts_pkg.update_p (p_cr_rec,
756: p_cr_rec.cash_receipt_id);
757: --
758: IF PG_DEBUG in ('Y', 'C') THEN
759: arp_util.debug( 'arp_cash_receipts_pkg.update_p()-' );
760: END IF;
761: --
762: END update_p;
763: --

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

764: PROCEDURE delete_p(
765: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
766: BEGIN
767: IF PG_DEBUG in ('Y', 'C') THEN
768: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()+' );
769: END IF;
770: --
771: DELETE FROM ar_cash_receipts
772: WHERE cash_receipt_id = p_cr_id;

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

783: p_key_value => p_cr_id);
784:
785: --
786: IF PG_DEBUG in ('Y', 'C') THEN
787: arp_util.debug( 'arp_cash_receipts_pkg.delete_p()-' );
788: END IF;
789: EXCEPTION
790: WHEN OTHERS THEN
791: IF PG_DEBUG in ('Y', 'C') THEN

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

788: END IF;
789: EXCEPTION
790: WHEN OTHERS THEN
791: IF PG_DEBUG in ('Y', 'C') THEN
792: arp_util.debug( 'Exception: arp_cash_receipts_pkg.delete_p' );
793: END IF;
794: RAISE;
795: END delete_p;
796: --

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

798: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
799: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
800: BEGIN
801: IF PG_DEBUG in ('Y', 'C') THEN
802: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()+' );
803: END IF;
804: --
805: SELECT cash_receipt_id
806: INTO l_cr_id

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

808: WHERE cash_receipt_id = p_cr_id
809: FOR UPDATE OF STATUS;
810: --
811: IF PG_DEBUG in ('Y', 'C') THEN
812: arp_util.debug( 'arp_cash_receipts_pkg.lock_p()-' );
813: END IF;
814: EXCEPTION
815: WHEN OTHERS THEN
816: IF PG_DEBUG in ('Y', 'C') THEN

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

813: END IF;
814: EXCEPTION
815: WHEN OTHERS THEN
816: IF PG_DEBUG in ('Y', 'C') THEN
817: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.lock_p' );
818: END IF;
819: RAISE;
820: END lock_p;
821: --

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

824: p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE ) IS
825: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
826: BEGIN
827: IF PG_DEBUG in ('Y', 'C') THEN
828: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()+' );
829: END IF;
830: --
831: SELECT cash_receipt_id
832: INTO l_cr_id

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

834: WHERE cash_receipt_id = p_cr_id
835: FOR UPDATE OF STATUS NOWAIT;
836: --
837: IF PG_DEBUG in ('Y', 'C') THEN
838: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_p()-' );
839: END IF;
840: EXCEPTION
841: WHEN OTHERS THEN
842: IF PG_DEBUG in ('Y', 'C') THEN

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

839: END IF;
840: EXCEPTION
841: WHEN OTHERS THEN
842: IF PG_DEBUG in ('Y', 'C') THEN
843: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_p' );
844: END IF;
845: RAISE;
846: END nowaitlock_p;
847: --

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

852: p_rec_version_number IN ar_cash_receipts.rec_version_number%TYPE DEFAULT NULL ) IS
853: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
857: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));
858: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));
859: END IF;
860: --

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

853: l_cr_id ar_cash_receipts.cash_receipt_id%TYPE;
854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
857: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));
858: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));
859: END IF;
860: --
861:

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

854: BEGIN
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()+' );
857: arp_util.debug('Cash receipt_id = '||to_char(p_cr_id));
858: arp_util.debug('receipt version number = '||to_char(p_rec_version_number));
859: END IF;
860: --
861:
862: SELECT cash_receipt_id

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

871: )
872: FOR UPDATE OF REC_VERSION_NUMBER NOWAIT;
873: --
874: IF PG_DEBUG in ('Y', 'C') THEN
875: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_version_p()-' );
876: END IF;
877: EXCEPTION
878: WHEN OTHERS THEN
879: IF PG_DEBUG in ('Y', 'C') THEN

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

876: END IF;
877: EXCEPTION
878: WHEN OTHERS THEN
879: IF PG_DEBUG in ('Y', 'C') THEN
880: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_version_p()' );
881: END IF;
882: RAISE;
883: END nowaitlock_version_p;
884:

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

884:
885: PROCEDURE update_version_number(p_cr_id IN ar_cash_receipts.cash_receipt_id%TYPE) IS
886: BEGIN
887: IF PG_DEBUG in ('Y', 'C') THEN
888: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()+' );
889: END IF;
890:
891: update ar_cash_receipts
892: set rec_version_number = nvl(rec_version_number,1)+1

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

892: set rec_version_number = nvl(rec_version_number,1)+1
893: where cash_receipt_id = p_cr_id;
894:
895: IF PG_DEBUG in ('Y', 'C') THEN
896: arp_util.debug( 'arp_cash_receipts_pkg.update_version_number()-');
897: END IF;
898: EXCEPTION
899: WHEN OTHERS THEN
900: IF PG_DEBUG in ('Y', 'C') THEN

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

897: END IF;
898: EXCEPTION
899: WHEN OTHERS THEN
900: IF PG_DEBUG in ('Y', 'C') THEN
901: arp_util.debug( 'EXCEPTION: arp_cash_receipts_pkg.update_version_number()' );
902: END IF;
903: RAISE;
904: END update_version_number;
905:

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

907: PROCEDURE fetch_p(
908: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
909: BEGIN
910: IF PG_DEBUG in ('Y', 'C') THEN
911: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()+' );
912: END IF;
913: --
914: SELECT *
915: INTO p_cr_rec

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

916: FROM ar_cash_receipts
917: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id;
918: --
919: IF PG_DEBUG in ('Y', 'C') THEN
920: arp_util.debug( 'arp_cash_receipts_pkg.fetch_p()-' );
921: END IF;
922: --
923: EXCEPTION
924: WHEN OTHERS THEN

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

922: --
923: EXCEPTION
924: WHEN OTHERS THEN
925: IF PG_DEBUG in ('Y', 'C') THEN
926: arp_util.debug('fetch_p: ' ||
927: 'EXCEPTION: arp_cash_receipts_pkg.fetch error' );
928: END IF;
929: RAISE;
930: END fetch_p;

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

933: PROCEDURE lock_fetch_p(
934: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
935: BEGIN
936: IF PG_DEBUG in ('Y', 'C') THEN
937: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()+' );
938: END IF;
939: --
940: SELECT *
941: INTO p_cr_rec

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

943: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
944: FOR UPDATE OF status;
945: --
946: IF PG_DEBUG in ('Y', 'C') THEN
947: arp_util.debug( 'arp_cash_receipts_pkg.lock_fetch_p()-' );
948: END IF;
949: --
950: EXCEPTION
951: WHEN OTHERS THEN

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

949: --
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF PG_DEBUG in ('Y', 'C') THEN
953: arp_util.debug('lock_fetch_p: ' ||
954: 'EXCEPTION: arp_cash_receipts_pkg.lock_fetch_p' );
955: END IF;
956: RAISE;
957: END lock_fetch_p;

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

960: PROCEDURE nowaitlock_fetch_p(
961: p_cr_rec IN OUT NOCOPY ar_cash_receipts%ROWTYPE) IS
962: BEGIN
963: IF PG_DEBUG in ('Y', 'C') THEN
964: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()+' );
965: END IF;
966: --
967: SELECT *
968: INTO p_cr_rec

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

970: WHERE cash_receipt_id = p_cr_rec.cash_receipt_id
971: FOR UPDATE OF status NOWAIT;
972: --
973: IF PG_DEBUG in ('Y', 'C') THEN
974: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_fetch_p()-' );
975: END IF;
976: --
977: EXCEPTION
978: WHEN OTHERS THEN

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

976: --
977: EXCEPTION
978: WHEN OTHERS THEN
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug('nowaitlock_fetch_p: ' ||
981: 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_fetch_p' );
982: END IF;
983: RAISE;
984: END nowaitlock_fetch_p;

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

996: FOR UPDATE OF cr.status;
997: --
998: BEGIN
999: IF PG_DEBUG in ('Y', 'C') THEN
1000: arp_util.debug( 'arp_cash_receipts_pkg.lock_f_batch_id()+' );
1001: END IF;
1002: --
1003: OPEN lock_C;
1004: CLOSE lock_C;

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

1003: OPEN lock_C;
1004: CLOSE lock_C;
1005: --
1006: IF PG_DEBUG in ('Y', 'C') THEN
1007: arp_util.debug( 'arp_cash_receipts_pkg.lock_f_batch_id()-' );
1008: END IF;
1009: --
1010: EXCEPTION
1011: WHEN OTHERS THEN

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

1013: CLOSE lock_C;
1014: END IF;
1015: --
1016: IF PG_DEBUG in ('Y', 'C') THEN
1017: arp_util.debug('lock_f_batch_id: ' ||
1018: 'EXCEPTION: arp_cash_receipts_pkg.lock_f_batch_id' );
1019: END IF;
1020: RAISE;
1021: END lock_f_batch_id;

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

1033: FOR UPDATE OF cr.status NOWAIT;
1034: --
1035: BEGIN
1036: IF PG_DEBUG in ('Y', 'C') THEN
1037: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_f_batch_id()+' );
1038: END IF;
1039: --
1040: OPEN lock_C;
1041: CLOSE lock_C;

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

1040: OPEN lock_C;
1041: CLOSE lock_C;
1042: --
1043: IF PG_DEBUG in ('Y', 'C') THEN
1044: arp_util.debug( 'arp_cash_receipts_pkg.nowaitlock_f_batch_id()-' );
1045: END IF;
1046: --
1047: EXCEPTION
1048: WHEN OTHERS THEN

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

1050: CLOSE lock_C;
1051: END IF;
1052: --
1053: IF PG_DEBUG in ('Y', 'C') THEN
1054: arp_util.debug('nowaitlock_f_batch_id: ' ||
1055: 'EXCEPTION: arp_cash_receipts_pkg.nowaitlock_f_batch_id' );
1056: END IF;
1057: RAISE;
1058: END nowaitlock_f_batch_id;

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

1064: l_exchange_date DATE;
1065:
1066: BEGIN
1067: IF PG_DEBUG in ('Y', 'C') THEN
1068: arp_util.debug('arp_cash_receipts_pkg.lock_compare_p()+');
1069: END IF;
1070:
1071: /* For testing only:
1072:

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

1792: )
1793: FOR UPDATE NOWAIT;
1794:
1795: IF PG_DEBUG in ('Y', 'C') THEN
1796: arp_util.debug('arp_cash_receipts_pkg.lock_compare_p()-');
1797: END IF;
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN

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

1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF PG_DEBUG in ('Y', 'C') THEN
1802: arp_util.debug('EXCEPTION: arp_cash_receipts_pkg.lock_compare_p()');
1803: END IF;
1804: RAISE;
1805:
1806: END lock_compare_p;