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_TRANSACTION_HISTORY_PKG dependencies on STANDARD

Line 50: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.set_to_dummy()+' );

46: PROCEDURE set_to_dummy( p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
47: BEGIN
48:
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.set_to_dummy()+' );
51: END IF;
52:
53: p_trh_rec.customer_trx_id := AR_NUMBER_DUMMY;
54: p_trh_rec.status := AR_TEXT_DUMMY;

Line 87: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.set_to_dummy()-' );

83: p_trh_rec.attribute14 := AR_TEXT_DUMMY;
84: p_trh_rec.attribute15 := AR_TEXT_DUMMY;
85:
86: IF PG_DEBUG in ('Y', 'C') THEN
87: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.set_to_dummy()-' );
88: END IF;
89:
90: EXCEPTION
91: WHEN OTHERS THEN

Line 93: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.set_to_dummy' );

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: IF PG_DEBUG in ('Y', 'C') THEN
93: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.set_to_dummy' );
94: END IF;
95: RAISE;
96: END set_to_dummy;
97:

Line 122: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()+' );

118: PROCEDURE update_p( p_trh_rec IN AR_TRANSACTION_HISTORY%ROWTYPE,
119: p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
120: BEGIN
121: IF PG_DEBUG in ('Y', 'C') THEN
122: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()+' );
123: END IF;
124:
125: UPDATE AR_TRANSACTION_HISTORY SET
126: customer_trx_id =

Line 265: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()-' );

261:
262: WHERE transaction_history_id = p_trh_id;
263:
264: IF PG_DEBUG in ('Y', 'C') THEN
265: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.update_p()-' );
266: END IF;
267:
268: EXCEPTION
269: WHEN OTHERS THEN

Line 271: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.update_p' );

267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: IF PG_DEBUG in ('Y', 'C') THEN
271: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.update_p' );
272: END IF;
273: RAISE;
274: END update_p;
275:

Line 302: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.insert_p()+' );

298:
299: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
300: BEGIN
301: IF PG_DEBUG in ('Y', 'C') THEN
302: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.insert_p()+' );
303: END IF;
304:
305: SELECT AR_TRANSACTION_HISTORY_s.nextval
306: INTO l_trh_id

Line 386: NVL( arp_standard.profile.program_application_id,p_trh_rec.program_application_id ),

382: p_trh_rec.attribute12,
383: p_trh_rec.attribute13,
384: p_trh_rec.attribute14,
385: p_trh_rec.attribute15,
386: NVL( arp_standard.profile.program_application_id,p_trh_rec.program_application_id ),
387: NVL( arp_standard.profile.program_id,p_trh_rec.program_id ),
388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),
389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),
390: SYSDATE,

Line 387: NVL( arp_standard.profile.program_id,p_trh_rec.program_id ),

383: p_trh_rec.attribute13,
384: p_trh_rec.attribute14,
385: p_trh_rec.attribute15,
386: NVL( arp_standard.profile.program_application_id,p_trh_rec.program_application_id ),
387: NVL( arp_standard.profile.program_id,p_trh_rec.program_id ),
388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),
389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),
390: SYSDATE,
391: arp_standard.profile.user_id,

Line 388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),

384: p_trh_rec.attribute14,
385: p_trh_rec.attribute15,
386: NVL( arp_standard.profile.program_application_id,p_trh_rec.program_application_id ),
387: NVL( arp_standard.profile.program_id,p_trh_rec.program_id ),
388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),
389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),
390: SYSDATE,
391: arp_standard.profile.user_id,
392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),

Line 389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),

385: p_trh_rec.attribute15,
386: NVL( arp_standard.profile.program_application_id,p_trh_rec.program_application_id ),
387: NVL( arp_standard.profile.program_id,p_trh_rec.program_id ),
388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),
389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),
390: SYSDATE,
391: arp_standard.profile.user_id,
392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),
393: SYSDATE,

Line 391: arp_standard.profile.user_id,

387: NVL( arp_standard.profile.program_id,p_trh_rec.program_id ),
388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),
389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),
390: SYSDATE,
391: arp_standard.profile.user_id,
392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),
393: SYSDATE,
394: arp_standard.profile.user_id
395: ,arp_standard.sysparm.org_id /* SSA changes anuj */);

Line 392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),

388: DECODE( arp_standard.profile.program_id,NULL, NULL, SYSDATE),
389: NVL( arp_standard.profile.request_id, p_trh_rec.request_id ),
390: SYSDATE,
391: arp_standard.profile.user_id,
392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),
393: SYSDATE,
394: arp_standard.profile.user_id
395: ,arp_standard.sysparm.org_id /* SSA changes anuj */);
396:

Line 394: arp_standard.profile.user_id

390: SYSDATE,
391: arp_standard.profile.user_id,
392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),
393: SYSDATE,
394: arp_standard.profile.user_id
395: ,arp_standard.sysparm.org_id /* SSA changes anuj */);
396:
397: p_trh_id := l_trh_id;
398:

Line 395: ,arp_standard.sysparm.org_id /* SSA changes anuj */);

391: arp_standard.profile.user_id,
392: NVL( arp_standard.profile.last_update_login,p_trh_rec.last_update_login ),
393: SYSDATE,
394: arp_standard.profile.user_id
395: ,arp_standard.sysparm.org_id /* SSA changes anuj */);
396:
397: p_trh_id := l_trh_id;
398:
399: IF PG_DEBUG in ('Y', 'C') THEN

Line 400: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.insert_p()-' );

396:
397: p_trh_id := l_trh_id;
398:
399: IF PG_DEBUG in ('Y', 'C') THEN
400: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.insert_p()-' );
401: END IF;
402:
403: EXCEPTION
404: WHEN OTHERS THEN

Line 406: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.insert_p' );

402:
403: EXCEPTION
404: WHEN OTHERS THEN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.insert_p' );
407: END IF;
408: RAISE;
409: END insert_p;
410:

Line 433: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );

429: +===========================================================================*/
430: PROCEDURE delete_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
431: BEGIN
432: IF PG_DEBUG in ('Y', 'C') THEN
433: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );
434: END IF;
435:
436: DELETE FROM AR_TRANSACTION_HISTORY
437: WHERE transaction_history_id = p_trh_id;

Line 440: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()-' );

436: DELETE FROM AR_TRANSACTION_HISTORY
437: WHERE transaction_history_id = p_trh_id;
438:
439: IF PG_DEBUG in ('Y', 'C') THEN
440: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()-' );
441: END IF;
442: EXCEPTION
443: WHEN OTHERS THEN
444: IF PG_DEBUG in ('Y', 'C') THEN

Line 445: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.delete_p' );

441: END IF;
442: EXCEPTION
443: WHEN OTHERS THEN
444: IF PG_DEBUG in ('Y', 'C') THEN
445: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.delete_p' );
446: END IF;
447: RAISE;
448: END delete_p;
449:

Line 472: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );

468: +===========================================================================*/
469: PROCEDURE delete_p(p_trx_id IN ra_customer_trx.customer_trx_id%TYPE ) IS
470: BEGIN
471: IF PG_DEBUG in ('Y', 'C') THEN
472: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()+' );
473: END IF;
474:
475: DELETE FROM AR_TRANSACTION_HISTORY
476: WHERE customer_trx_id = p_trx_id;

Line 479: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()-' );

475: DELETE FROM AR_TRANSACTION_HISTORY
476: WHERE customer_trx_id = p_trx_id;
477:
478: IF PG_DEBUG in ('Y', 'C') THEN
479: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.delete_p()-' );
480: END IF;
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF PG_DEBUG in ('Y', 'C') THEN

Line 484: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.delete_p' );

480: END IF;
481: EXCEPTION
482: WHEN OTHERS THEN
483: IF PG_DEBUG in ('Y', 'C') THEN
484: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.delete_p' );
485: END IF;
486: RAISE;
487: END delete_p;
488:

Line 513: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_p()+' );

509: PROCEDURE lock_p(p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
510: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
511: BEGIN
512: IF PG_DEBUG in ('Y', 'C') THEN
513: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_p()+' );
514: END IF;
515:
516: SELECT transaction_history_id
517: INTO l_trh_id

Line 523: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_p()-' );

519: WHERE transaction_history_id = p_trh_id
520: FOR UPDATE OF STATUS;
521:
522: IF PG_DEBUG in ('Y', 'C') THEN
523: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_p()-' );
524: END IF;
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF PG_DEBUG in ('Y', 'C') THEN

Line 528: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_p' );

524: END IF;
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF PG_DEBUG in ('Y', 'C') THEN
528: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_p' );
529: END IF;
530: RAISE;
531: END lock_p;
532:

Line 557: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p()+' );

553: PROCEDURE nowaitlock_p( p_trh_id IN AR_TRANSACTION_HISTORY.transaction_history_id%TYPE ) IS
554: l_trh_id AR_TRANSACTION_HISTORY.transaction_history_id%TYPE;
555: BEGIN
556: IF PG_DEBUG in ('Y', 'C') THEN
557: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p()+' );
558: END IF;
559:
560: SELECT transaction_history_id
561: INTO l_trh_id

Line 567: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p()-' );

563: WHERE transaction_history_id = p_trh_id
564: FOR UPDATE OF status NOWAIT;
565:
566: IF PG_DEBUG in ('Y', 'C') THEN
567: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p()-' );
568: END IF;
569: EXCEPTION
570: WHEN OTHERS THEN
571: IF PG_DEBUG in ('Y', 'C') THEN

Line 572: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p' );

568: END IF;
569: EXCEPTION
570: WHEN OTHERS THEN
571: IF PG_DEBUG in ('Y', 'C') THEN
572: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_p' );
573: END IF;
574: RAISE;
575: END nowaitlock_p;
576:

Line 601: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_p()+' );

597: p_trh_rec OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
598: BEGIN
599:
600: IF PG_DEBUG in ('Y', 'C') THEN
601: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_p()+' );
602: END IF;
603:
604: SELECT *
605: INTO p_trh_rec

Line 609: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_p()-' );

605: INTO p_trh_rec
606: FROM AR_TRANSACTION_HISTORY
607: WHERE transaction_history_id = p_trh_id;
608: IF PG_DEBUG in ('Y', 'C') THEN
609: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_p()-' );
610: END IF;
611:
612: EXCEPTION
613: WHEN OTHERS THEN

Line 615: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.fetch_p' );

611:
612: EXCEPTION
613: WHEN OTHERS THEN
614: IF PG_DEBUG in ('Y', 'C') THEN
615: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.fetch_p' );
616: END IF;
617: RAISE;
618: END fetch_p;
619:

Line 642: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id()+' );

638: +===========================================================================*/
639: PROCEDURE fetch_f_trx_id( p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE ) IS
640: BEGIN
641: IF PG_DEBUG in ('Y', 'C') THEN
642: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id()+' );
643: END IF;
644:
645: SELECT *
646: INTO p_trh_rec

Line 652: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id()-' );

648: WHERE customer_trx_id = p_trh_rec.customer_trx_id AND
649: current_record_flag = 'Y';
650:
651: IF PG_DEBUG in ('Y', 'C') THEN
652: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id()-' );
653: END IF;
654:
655: EXCEPTION
656: WHEN OTHERS THEN

Line 658: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id' );

654:
655: EXCEPTION
656: WHEN OTHERS THEN
657: IF PG_DEBUG in ('Y', 'C') THEN
658: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.fetch_f_trx_id' );
659: END IF;
660: RAISE;
661: END fetch_f_trx_id;
662:

Line 686: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p()+' );

682: +===========================================================================*/
683: PROCEDURE lock_fetch_p(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
684: BEGIN
685: IF PG_DEBUG in ('Y', 'C') THEN
686: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p()+' );
687: END IF;
688:
689: SELECT *
690: INTO p_trh_rec

Line 696: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p()-' );

692: WHERE transaction_history_id = p_trh_rec.transaction_history_id
693: FOR UPDATE OF status;
694:
695: IF PG_DEBUG in ('Y', 'C') THEN
696: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p()-' );
697: END IF;
698:
699: EXCEPTION
700: WHEN OTHERS THEN

Line 702: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p' );

698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: IF PG_DEBUG in ('Y', 'C') THEN
702: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_fetch_p' );
703: END IF;
704: RAISE;
705: END lock_fetch_p;
706:

Line 730: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p()+' );

726: +===========================================================================*/
727: PROCEDURE nowaitlock_fetch_p(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
728: BEGIN
729: IF PG_DEBUG in ('Y', 'C') THEN
730: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p()+' );
731: END IF;
732:
733: SELECT *
734: INTO p_trh_rec

Line 740: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p()-' );

736: WHERE transaction_history_id = p_trh_rec.transaction_history_id
737: FOR UPDATE OF status NOWAIT;
738:
739: IF PG_DEBUG in ('Y', 'C') THEN
740: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p()-' );
741: END IF;
742:
743: EXCEPTION
744: WHEN OTHERS THEN

Line 746: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p' );

742:
743: EXCEPTION
744: WHEN OTHERS THEN
745: IF PG_DEBUG in ('Y', 'C') THEN
746: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_p' );
747: END IF;
748: RAISE;
749: END nowaitlock_fetch_p;
750:

Line 781: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_f_trx_id()+' );

777: FOR UPDATE OF status;
778:
779: BEGIN
780: IF PG_DEBUG in ('Y', 'C') THEN
781: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_f_trx_id()+' );
782: END IF;
783:
784: OPEN lock_C;
785: CLOSE lock_C;

Line 788: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_f_trx_id()-' );

784: OPEN lock_C;
785: CLOSE lock_C;
786:
787: IF PG_DEBUG in ('Y', 'C') THEN
788: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_f_trx_id()-' );
789: END IF;
790:
791: EXCEPTION
792: WHEN OTHERS THEN

Line 798: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_f_trx_id' );

794: CLOSE lock_C;
795: END IF;
796:
797: IF PG_DEBUG in ('Y', 'C') THEN
798: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_f_trx_id' );
799: END IF;
800: RAISE;
801: END lock_f_trx_id;
802: /*===========================================================================+

Line 832: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_f_trx_id()+' );

828: FOR UPDATE OF status NOWAIT;
829:
830: BEGIN
831: IF PG_DEBUG in ('Y', 'C') THEN
832: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_f_trx_id()+' );
833: END IF;
834:
835: OPEN lock_C;
836: CLOSE lock_C;

Line 839: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_f_trx_id()-' );

835: OPEN lock_C;
836: CLOSE lock_C;
837:
838: IF PG_DEBUG in ('Y', 'C') THEN
839: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_f_trx_id()-' );
840: END IF;
841:
842: EXCEPTION
843: WHEN OTHERS THEN

Line 849: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_f_trx_id' );

845: CLOSE lock_C;
846: END IF;
847:
848: IF PG_DEBUG in ('Y', 'C') THEN
849: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_f_trx_id' );
850: END IF;
851: RAISE;
852: END nowaitlock_f_trx_id;
853:

Line 877: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id()+' );

873: +===========================================================================*/
874: PROCEDURE lock_fetch_f_trx_id(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
875: BEGIN
876: IF PG_DEBUG in ('Y', 'C') THEN
877: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id()+' );
878: END IF;
879:
880: SELECT *
881: INTO p_trh_rec

Line 888: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id()-' );

884: AND current_record_flag = 'Y'
885: FOR UPDATE OF status;
886:
887: IF PG_DEBUG in ('Y', 'C') THEN
888: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id()-' );
889: END IF;
890:
891: EXCEPTION
892: WHEN OTHERS THEN

Line 894: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id' );

890:
891: EXCEPTION
892: WHEN OTHERS THEN
893: IF PG_DEBUG in ('Y', 'C') THEN
894: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.lock_fetch_f_trx_id' );
895: END IF;
896: RAISE;
897: END lock_fetch_f_trx_id;
898: /*===========================================================================+

Line 921: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id()+' );

917: +===========================================================================*/
918: PROCEDURE nowaitlock_fetch_f_trx_id(p_trh_rec IN OUT NOCOPY AR_TRANSACTION_HISTORY%ROWTYPE) IS
919: BEGIN
920: IF PG_DEBUG in ('Y', 'C') THEN
921: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id()+' );
922: END IF;
923:
924: SELECT *
925: INTO p_trh_rec

Line 932: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id()-' );

928: AND current_record_flag = 'Y'
929: FOR UPDATE OF status NOWAIT;
930:
931: IF PG_DEBUG in ('Y', 'C') THEN
932: arp_standard.debug( 'ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id()-' );
933: END IF;
934:
935: EXCEPTION
936: WHEN OTHERS THEN

Line 938: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id' );

934:
935: EXCEPTION
936: WHEN OTHERS THEN
937: IF PG_DEBUG in ('Y', 'C') THEN
938: arp_standard.debug( 'EXCEPTION: ARP_TRANSACTION_HISTORY_PKG.nowaitlock_fetch_f_trx_id' );
939: END IF;
940: RAISE;
941: END nowaitlock_fetch_f_trx_id;
942: