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_NOTES_PKG dependencies on ARP_NOTES_PKG

Line 1: PACKAGE BODY ARP_NOTES_PKG AS

1: PACKAGE BODY ARP_NOTES_PKG AS
2: /* $Header: ARTINOTB.pls 115.7 2004/02/10 09:02:01 ksankara ship $ */
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

Line 55: arp_util.debug('arp_notes_pkg.get_number_dummy()+');

51: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
52:
53: BEGIN
54:
55: arp_util.debug('arp_notes_pkg.get_number_dummy()+');
56:
57: arp_util.debug('arp_notes_pkg.get_number_dummy()-');
58:
59: return(AR_NUMBER_DUMMY);

Line 57: arp_util.debug('arp_notes_pkg.get_number_dummy()-');

53: BEGIN
54:
55: arp_util.debug('arp_notes_pkg.get_number_dummy()+');
56:
57: arp_util.debug('arp_notes_pkg.get_number_dummy()-');
58:
59: return(AR_NUMBER_DUMMY);
60:
61: EXCEPTION

Line 63: arp_util.debug('EXCEPTION: arp_notes_pkg.get_number_dummy()');

59: return(AR_NUMBER_DUMMY);
60:
61: EXCEPTION
62: WHEN OTHERS THEN
63: arp_util.debug('EXCEPTION: arp_notes_pkg.get_number_dummy()');
64: RAISE;
65:
66: END;
67:

Line 106: arp_util.debug('arp_notes_pkg.set_to_dummy()+');

102: PROCEDURE set_to_dummy( p_notes_rec OUT NOCOPY ar_notes%rowtype) IS
103:
104: BEGIN
105:
106: arp_util.debug('arp_notes_pkg.set_to_dummy()+');
107:
108: p_notes_rec.note_id := AR_NUMBER_DUMMY;
109: p_notes_rec.customer_trx_id := AR_NUMBER_DUMMY;
110: p_notes_rec.customer_call_id := AR_NUMBER_DUMMY;

Line 123: arp_util.debug('arp_notes_pkg.set_to_dummy()-');

119: p_notes_rec.creation_date := AR_DATE_DUMMY;
120: p_notes_rec.created_by := AR_NUMBER_DUMMY;
121:
122:
123: arp_util.debug('arp_notes_pkg.set_to_dummy()-');
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_notes_pkg.set_to_dummy()');

Line 127: arp_util.debug('EXCEPTION: arp_notes_pkg.set_to_dummy()');

123: arp_util.debug('arp_notes_pkg.set_to_dummy()-');
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: arp_util.debug('EXCEPTION: arp_notes_pkg.set_to_dummy()');
128: RAISE;
129:
130: END;
131:

Line 166: arp_util.debug('arp_notes_pkg.lock_p()+');

162:
163: l_customer_trx_id ar_notes.customer_trx_id%type;
164:
165: BEGIN
166: arp_util.debug('arp_notes_pkg.lock_p()+');
167:
168:
169: SELECT customer_trx_id
170: INTO l_customer_trx_id

Line 175: arp_util.debug('arp_notes_pkg.lock_p()-');

171: FROM ar_notes
172: WHERE customer_trx_id = p_customer_trx_id
173: FOR UPDATE OF customer_trx_id NOWAIT;
174:
175: arp_util.debug('arp_notes_pkg.lock_p()-');
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_p' );

Line 179: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_p' );

175: arp_util.debug('arp_notes_pkg.lock_p()-');
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_p' );
180: RAISE;
181: END;
182:
183: /*===========================================================================+

Line 215: arp_util.debug('arp_notes_pkg.lock_fetch_p()+');

211: PROCEDURE lock_fetch_p( p_notes_rec IN OUT NOCOPY ar_notes%rowtype,
212: p_note_id IN ar_notes.note_id%type) IS
213:
214: BEGIN
215: arp_util.debug('arp_notes_pkg.lock_fetch_p()+');
216:
217: SELECT *
218: INTO p_notes_rec
219: FROM ar_notes

Line 223: arp_util.debug('arp_notes_pkg.lock_fetch_p()-');

219: FROM ar_notes
220: WHERE note_id = p_note_id
221: FOR UPDATE OF note_id NOWAIT;
222:
223: arp_util.debug('arp_notes_pkg.lock_fetch_p()-');
224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_fetch_p' );

Line 227: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_fetch_p' );

223: arp_util.debug('arp_notes_pkg.lock_fetch_p()-');
224:
225: EXCEPTION
226: WHEN OTHERS THEN
227: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_fetch_p' );
228: RAISE;
229: END;
230:
231: /*===========================================================================+

Line 267: arp_util.debug('arp_notes_pkg.lock_compare_p()+');

263:
264: l_new_note_rec ar_notes%rowtype;
265:
266: BEGIN
267: arp_util.debug('arp_notes_pkg.lock_compare_p()+');
268:
269: SELECT *
270: INTO l_new_note_rec
271: FROM ar_notes n

Line 370: arp_util.debug('arp_notes_pkg.lock_compare_p()-');

366: )
367: )
368: FOR UPDATE OF note_id NOWAIT;
369:
370: arp_util.debug('arp_notes_pkg.lock_compare_p()-');
371:
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: arp_util.debug(

Line 375: 'EXCEPTION: arp_notes_pkg.lock_compare_p NO_DATA_FOUND' );

371:
372: EXCEPTION
373: WHEN NO_DATA_FOUND THEN
374: arp_util.debug(
375: 'EXCEPTION: arp_notes_pkg.lock_compare_p NO_DATA_FOUND' );
376:
377: arp_util.debug('');
378: arp_util.debug('============= Old Record =============');
379: display_note_p(p_note_id);

Line 387: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_compare_p' );

383:
384: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
385: APP_EXCEPTION.Raise_Exception;
386: WHEN OTHERS THEN
387: arp_util.debug( 'EXCEPTION: arp_notes_pkg.lock_compare_p' );
388: RAISE;
389: END;
390:
391:

Line 424: arp_util.debug('arp_notes_pkg.fetch_p()+');

420: PROCEDURE fetch_p( p_notes_rec OUT NOCOPY ar_notes%rowtype,
421: p_note_id IN ar_notes.note_id%type) IS
422:
423: BEGIN
424: arp_util.debug('arp_notes_pkg.fetch_p()+');
425:
426: SELECT *
427: INTO p_notes_rec
428: FROM ar_notes

Line 431: arp_util.debug('arp_notes_pkg.fetch_p()-');

427: INTO p_notes_rec
428: FROM ar_notes
429: WHERE note_id = p_note_id;
430:
431: arp_util.debug('arp_notes_pkg.fetch_p()-');
432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: arp_util.debug( 'EXCEPTION: arp_notes_pkg.fetch_p' );

Line 435: arp_util.debug( 'EXCEPTION: arp_notes_pkg.fetch_p' );

431: arp_util.debug('arp_notes_pkg.fetch_p()-');
432:
433: EXCEPTION
434: WHEN OTHERS THEN
435: arp_util.debug( 'EXCEPTION: arp_notes_pkg.fetch_p' );
436: RAISE;
437: END;
438:
439: /*===========================================================================+

Line 473: arp_util.debug('arp_notes_pkg.delete_f_ct_id()+');

469:
470: BEGIN
471:
472:
473: arp_util.debug('arp_notes_pkg.delete_f_ct_id()+');
474:
475: DELETE FROM ar_notes
476: WHERE customer_trx_id = p_customer_trx_id;
477:

Line 478: arp_util.debug('arp_notes_pkg.delete_f_ct_id()-');

474:
475: DELETE FROM ar_notes
476: WHERE customer_trx_id = p_customer_trx_id;
477:
478: arp_util.debug('arp_notes_pkg.delete_f_ct_id()-');
479:
480: EXCEPTION
481: WHEN OTHERS THEN
482: arp_util.debug('EXCEPTION: arp_notes_pkg.delete_f_ct_id()');

Line 482: arp_util.debug('EXCEPTION: arp_notes_pkg.delete_f_ct_id()');

478: arp_util.debug('arp_notes_pkg.delete_f_ct_id()-');
479:
480: EXCEPTION
481: WHEN OTHERS THEN
482: arp_util.debug('EXCEPTION: arp_notes_pkg.delete_f_ct_id()');
483:
484: RAISE;
485:
486: END;

Line 526: arp_util.debug('arp_notes_pkg.update_p()+ ' ||

522:
523:
524: BEGIN
525:
526: arp_util.debug('arp_notes_pkg.update_p()+ ' ||
527: to_char(sysdate, 'HH:MI:SS'));
528:
529: SELECT
530: DECODE(p_notes_rec.last_updated_by,

Line 585: arp_util.debug('arp_notes_pkg.update_p()- ' ||

581: WHERE note_id = p_note_id;
582:
583:
584:
585: arp_util.debug('arp_notes_pkg.update_p()- ' ||
586: to_char(sysdate, 'HH:MI:SS'));
587:
588:
589: EXCEPTION

Line 591: arp_util.debug('EXCEPTION: arp_notes_pkg.update_p()');

587:
588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: arp_util.debug('EXCEPTION: arp_notes_pkg.update_p()');
592: RAISE;
593: END;
594:
595:

Line 634: arp_util.debug('arp_notes_pkg.insert_p()+');

630: l_note_id ar_notes.note_id%type;
631:
632: BEGIN
633:
634: arp_util.debug('arp_notes_pkg.insert_p()+');
635:
636: /*------------------------------+
637: | get the unique id |
638: +------------------------------*/

Line 707: arp_util.debug('arp_notes_pkg.insert_p()-');

703: p_notes_rec.creation_date
704: );
705:
706:
707: arp_util.debug('arp_notes_pkg.insert_p()-');
708:
709: EXCEPTION
710: WHEN OTHERS THEN
711: arp_util.debug('EXCEPTION: arp_notes_pkg.insert_p()');

Line 711: arp_util.debug('EXCEPTION: arp_notes_pkg.insert_p()');

707: arp_util.debug('arp_notes_pkg.insert_p()-');
708:
709: EXCEPTION
710: WHEN OTHERS THEN
711: arp_util.debug('EXCEPTION: arp_notes_pkg.insert_p()');
712: RAISE;
713: END;
714:
715: /*===========================================================================+

Line 748: arp_util.debug('arp_notes_pkg.display_note_p()+');

744: l_notes_rec ar_notes%rowtype;
745:
746: BEGIN
747:
748: arp_util.debug('arp_notes_pkg.display_note_p()+');
749:
750: arp_notes_pkg.fetch_p(l_notes_rec, p_note_id);
751:
752: arp_notes_pkg.display_note_rec(l_notes_rec);

Line 750: arp_notes_pkg.fetch_p(l_notes_rec, p_note_id);

746: BEGIN
747:
748: arp_util.debug('arp_notes_pkg.display_note_p()+');
749:
750: arp_notes_pkg.fetch_p(l_notes_rec, p_note_id);
751:
752: arp_notes_pkg.display_note_rec(l_notes_rec);
753:
754: arp_util.debug('arp_notes_pkg.display_note_p()-');

Line 752: arp_notes_pkg.display_note_rec(l_notes_rec);

748: arp_util.debug('arp_notes_pkg.display_note_p()+');
749:
750: arp_notes_pkg.fetch_p(l_notes_rec, p_note_id);
751:
752: arp_notes_pkg.display_note_rec(l_notes_rec);
753:
754: arp_util.debug('arp_notes_pkg.display_note_p()-');
755:
756: EXCEPTION

Line 754: arp_util.debug('arp_notes_pkg.display_note_p()-');

750: arp_notes_pkg.fetch_p(l_notes_rec, p_note_id);
751:
752: arp_notes_pkg.display_note_rec(l_notes_rec);
753:
754: arp_util.debug('arp_notes_pkg.display_note_p()-');
755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: arp_util.debug('EXCEPTION: arp_notes_pkg.display_note_p()');

Line 758: arp_util.debug('EXCEPTION: arp_notes_pkg.display_note_p()');

754: arp_util.debug('arp_notes_pkg.display_note_p()-');
755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: arp_util.debug('EXCEPTION: arp_notes_pkg.display_note_p()');
759: RAISE;
760:
761: END;
762:

Line 793: arp_util.debug('arp_notes_pkg.display_note_rec()+');

789: PROCEDURE display_note_rec ( p_notes_rec IN ar_notes%rowtype ) IS
790:
791: BEGIN
792:
793: arp_util.debug('arp_notes_pkg.display_note_rec()+');
794:
795: arp_util.debug('************ Dump of ar_notes record ************');
796: arp_util.debug('customer_trx_id: ' || p_notes_rec.customer_trx_id);
797:

Line 811: arp_util.debug('arp_notes_pkg.display_note_rec()-');

807: arp_util.debug('customer_trx_id : ' ||p_notes_rec.customer_trx_id);
808:
809: arp_util.debug('************* End ar_notes record *************');
810:
811: arp_util.debug('arp_notes_pkg.display_note_rec()-');
812:
813: EXCEPTION
814: WHEN OTHERS THEN
815: arp_util.debug('EXCEPTION: arp_notes_pkg.display_note_rec()');

Line 815: arp_util.debug('EXCEPTION: arp_notes_pkg.display_note_rec()');

811: arp_util.debug('arp_notes_pkg.display_note_rec()-');
812:
813: EXCEPTION
814: WHEN OTHERS THEN
815: arp_util.debug('EXCEPTION: arp_notes_pkg.display_note_rec()');
816: RAISE;
817:
818: END;
819:

Line 882: arp_util.debug('arp_notes_pkg.lock_compare_cover()+');

878:
879: l_notes_rec ar_notes%rowtype;
880:
881: BEGIN
882: arp_util.debug('arp_notes_pkg.lock_compare_cover()+');
883:
884: /*------------------------------------------------+
885: | Populate the header record with the values |
886: | passed in as parameters. |

Line 889: arp_notes_pkg.set_to_dummy(l_notes_rec);

885: | Populate the header record with the values |
886: | passed in as parameters. |
887: +------------------------------------------------*/
888:
889: arp_notes_pkg.set_to_dummy(l_notes_rec);
890:
891: l_notes_rec.note_id := p_note_id;
892: l_notes_rec.last_updated_by := p_last_updated_by;
893: l_notes_rec.last_update_date := p_last_update_date;

Line 911: arp_util.debug('arp_notes_pkg.lock_compare_cover()-');

907: +-----------------------------------------*/
908:
909: lock_compare_p( l_notes_rec, p_note_id);
910:
911: arp_util.debug('arp_notes_pkg.lock_compare_cover()-');
912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: arp_util.debug('EXCEPTION : arp_notes_pkg.lock_compare_cover()');

Line 915: arp_util.debug('EXCEPTION : arp_notes_pkg.lock_compare_cover()');

911: arp_util.debug('arp_notes_pkg.lock_compare_cover()-');
912:
913: EXCEPTION
914: WHEN OTHERS THEN
915: arp_util.debug('EXCEPTION : arp_notes_pkg.lock_compare_cover()');
916:
917: arp_util.debug('----- parameters for lock_compare_cover() ' ||
918: '-----');
919: arp_util.debug('p_note_id : ' || p_note_id);

Line 997: arp_util.debug('arp_notes_pkg.insert_cover()+');

993:
994: l_notes_rec ar_notes%rowtype;
995:
996: BEGIN
997: arp_util.debug('arp_notes_pkg.insert_cover()+');
998:
999: /*------------------------------------------------+
1000: | Populate the header record with the values |
1001: | passed in as parameters. |

Line 1037: arp_util.debug('arp_notes_pkg.insert_cover()-');

1033: p_last_update_login := l_notes_rec.last_update_login;
1034: p_created_by := l_notes_rec.created_by;
1035: p_creation_date := l_notes_rec.creation_date;
1036:
1037: arp_util.debug('arp_notes_pkg.insert_cover()-');
1038:
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: arp_util.debug('EXCEPTION : arp_notes_pkg.insert_cover()');

Line 1041: arp_util.debug('EXCEPTION : arp_notes_pkg.insert_cover()');

1037: arp_util.debug('arp_notes_pkg.insert_cover()-');
1038:
1039: EXCEPTION
1040: WHEN OTHERS THEN
1041: arp_util.debug('EXCEPTION : arp_notes_pkg.insert_cover()');
1042:
1043: arp_util.debug('----- parameters for insert_cover() ' ||
1044: '-----');
1045: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);

Line 1123: arp_util.debug('arp_notes_pkg.update_cover()+');

1119:
1120: l_notes_rec ar_notes%rowtype;
1121:
1122: BEGIN
1123: arp_util.debug('arp_notes_pkg.update_cover()+');
1124:
1125: /*------------------------------------------------+
1126: | Populate the header record with the values |
1127: | passed in as parameters. |

Line 1159: arp_util.debug('arp_notes_pkg.update_cover()-');

1155: p_last_updated_by := l_notes_rec.last_updated_by;
1156: p_last_update_date := l_notes_rec.last_update_date;
1157: p_last_update_login := l_notes_rec.last_update_login;
1158:
1159: arp_util.debug('arp_notes_pkg.update_cover()-');
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: arp_util.debug('EXCEPTION : arp_notes_pkg.update_cover()');

Line 1163: arp_util.debug('EXCEPTION : arp_notes_pkg.update_cover()');

1159: arp_util.debug('arp_notes_pkg.update_cover()-');
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: arp_util.debug('EXCEPTION : arp_notes_pkg.update_cover()');
1164:
1165: arp_util.debug('----- parameters for update_cover() ' ||
1166: '-----');
1167: arp_util.debug('p_note_id : ' || p_note_id);

Line 1199: END ARP_NOTES_PKG;

1195: pg_prog_appl_id := fnd_global.prog_appl_id;
1196: pg_conc_program_id := fnd_global.conc_program_id;
1197:
1198:
1199: END ARP_NOTES_PKG;