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_UTIL

Line 35: | arp_util.debug |

31: | |
32: | SCOPE - PUBLIC |
33: | |
34: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
35: | arp_util.debug |
36: | |
37: | ARGUMENTS : IN: |
38: | None |
39: | OUT: |

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 85: | arp_util.debug |

81: | |
82: | SCOPE - PUBLIC |
83: | |
84: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
85: | arp_util.debug |
86: | |
87: | ARGUMENTS : IN: |
88: | None |
89: | OUT: |

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 144: | arp_util.debug |

140: | |
141: | SCOPE - PUBLIC |
142: | |
143: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
144: | arp_util.debug |
145: | |
146: | ARGUMENTS : IN: |
147: | p_customer_trx_id - identifies the rows to lock |
148: | OUT: |

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 195: | arp_util.debug |

191: | |
192: | SCOPE - PUBLIC |
193: | |
194: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
195: | arp_util.debug |
196: | |
197: | ARGUMENTS : IN: |
198: | p_noteid - identifies the row to lock |
199: | OUT: |

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 243: | arp_util.debug |

239: | |
240: | SCOPE - PUBLIC |
241: | |
242: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
243: | arp_util.debug |
244: | |
245: | ARGUMENTS : IN: |
246: | p_note_id - identifies the row to lock |
247: | p_notes_rec - note record for comparison |

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 374: arp_util.debug(

370: arp_util.debug('arp_notes_pkg.lock_compare_p()-');
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 =============');

Line 377: arp_util.debug('');

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);
380: arp_util.debug('');
381: arp_util.debug('============= New Record =============');

Line 378: arp_util.debug('============= Old Record =============');

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);
380: arp_util.debug('');
381: arp_util.debug('============= New Record =============');
382: display_note_rec(p_notes_rec);

Line 380: arp_util.debug('');

376:
377: arp_util.debug('');
378: arp_util.debug('============= Old Record =============');
379: display_note_p(p_note_id);
380: arp_util.debug('');
381: arp_util.debug('============= New Record =============');
382: display_note_rec(p_notes_rec);
383:
384: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 381: arp_util.debug('============= New Record =============');

377: arp_util.debug('');
378: arp_util.debug('============= Old Record =============');
379: display_note_p(p_note_id);
380: arp_util.debug('');
381: arp_util.debug('============= New Record =============');
382: display_note_rec(p_notes_rec);
383:
384: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
385: APP_EXCEPTION.Raise_Exception;

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 404: | arp_util.debug |

400: | |
401: | SCOPE - PUBLIC |
402: | |
403: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
404: | arp_util.debug |
405: | |
406: | ARGUMENTS : IN: |
407: | p_note_id - identifies the record to fetch |
408: | OUT: |

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 450: | arp_util.debug |

446: | |
447: | SCOPE - PUBLIC |
448: | |
449: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
450: | arp_util.debug |
451: | |
452: | ARGUMENTS : IN: |
453: | p_customer_trx_id - identifies the row to delete |
454: | OUT: |

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 499: | arp_util.debug |

495: | |
496: | SCOPE - PUBLIC |
497: | |
498: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
499: | arp_util.debug |
500: | |
501: | ARGUMENTS : IN: |
502: | p_note_id - identifies the row to update |
503: | OUT: |

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 608: | arp_util.debug |

604: | |
605: | SCOPE - PUBLIC |
606: | |
607: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
608: | arp_util.debug |
609: | |
610: | ARGUMENTS : IN OUT: |
611: | p_notes_rec - contains the new column values |
612: | OUT: |

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 656: arp_util.debug('l_note_id : ' || to_char(l_note_id));

652: p_notes_rec.created_by := pg_user_id;
653: p_notes_rec.creation_date := NVL(p_notes_rec.creation_date, sysdate);
654:
655:
656: arp_util.debug('l_note_id : ' || to_char(l_note_id));
657: arp_util.debug('p_notes_rec.note_type : ' || p_notes_rec.note_type);
658: /* 3206020 */
659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */
660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||

Line 657: arp_util.debug('p_notes_rec.note_type : ' || p_notes_rec.note_type);

653: p_notes_rec.creation_date := NVL(p_notes_rec.creation_date, sysdate);
654:
655:
656: arp_util.debug('l_note_id : ' || to_char(l_note_id));
657: arp_util.debug('p_notes_rec.note_type : ' || p_notes_rec.note_type);
658: /* 3206020 */
659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */
660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||
661: to_char(p_notes_rec.customer_trx_id));

Line 659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */

655:
656: arp_util.debug('l_note_id : ' || to_char(l_note_id));
657: arp_util.debug('p_notes_rec.note_type : ' || p_notes_rec.note_type);
658: /* 3206020 */
659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */
660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||
661: to_char(p_notes_rec.customer_trx_id));
662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));

Line 660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||

656: arp_util.debug('l_note_id : ' || to_char(l_note_id));
657: arp_util.debug('p_notes_rec.note_type : ' || p_notes_rec.note_type);
658: /* 3206020 */
659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */
660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||
661: to_char(p_notes_rec.customer_trx_id));
662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));

Line 662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));

658: /* 3206020 */
659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */
660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||
661: to_char(p_notes_rec.customer_trx_id));
662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));

Line 663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));

659: /* arp_util.debug('p_notes_rec.text : ' || p_notes_rec.text); */
660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||
661: to_char(p_notes_rec.customer_trx_id));
662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));

Line 664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));

660: arp_util.debug('p_notes_rec.customer_trx_id : ' ||
661: to_char(p_notes_rec.customer_trx_id));
662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));
668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));

Line 665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));

661: to_char(p_notes_rec.customer_trx_id));
662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));
668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));
669: arp_util.debug('p_notes_rec.creation_date : ' || to_char(p_notes_rec.creation_date));

Line 666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));

662: arp_util.debug('p_notes_rec.customer_call_id : ' || to_char(p_notes_rec.customer_call_id));
663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));
668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));
669: arp_util.debug('p_notes_rec.creation_date : ' || to_char(p_notes_rec.creation_date));
670:

Line 667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));

663: arp_util.debug('p_notes_rec.customer_call_topic_id : ' || to_char(p_notes_rec.customer_call_topic_id));
664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));
668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));
669: arp_util.debug('p_notes_rec.creation_date : ' || to_char(p_notes_rec.creation_date));
670:
671:

Line 668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));

664: arp_util.debug('p_notes_rec.call_action_id : ' || to_char(p_notes_rec.call_action_id));
665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));
668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));
669: arp_util.debug('p_notes_rec.creation_date : ' || to_char(p_notes_rec.creation_date));
670:
671:
672: /*------------------------------+

Line 669: arp_util.debug('p_notes_rec.creation_date : ' || to_char(p_notes_rec.creation_date));

665: arp_util.debug('p_notes_rec.last_updated_by : ' || to_char(p_notes_rec.last_updated_by));
666: arp_util.debug('p_notes_rec.last_update_date : ' || to_char(p_notes_rec.last_update_date));
667: arp_util.debug('p_notes_rec.last_update_login : ' || to_char(p_notes_rec.last_update_login));
668: arp_util.debug('p_notes_rec.created_by : ' || to_char(p_notes_rec.created_by));
669: arp_util.debug('p_notes_rec.creation_date : ' || to_char(p_notes_rec.creation_date));
670:
671:
672: /*------------------------------+
673: | insert the record |

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 725: | arp_util.debug |

721: | |
722: | SCOPE - PUBLIC |
723: | |
724: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
725: | arp_util.debug |
726: | |
727: | ARGUMENTS : IN: |
728: | p_note_id |
729: | OUT: |

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 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 773: | arp_util.debug |

769: | |
770: | SCOPE - PUBLIC |
771: | |
772: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
773: | arp_util.debug |
774: | |
775: | ARGUMENTS : IN: |
776: | p_notes_rec |
777: | OUT: |

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 795: arp_util.debug(' Dump of ar_notes record ');

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:
798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);

Line 796: arp_util.debug('customer_trx_id: ' || p_notes_rec.customer_trx_id);

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:
798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);
800: arp_util.debug('note_type : ' || p_notes_rec.note_type);

Line 798: arp_util.debug('note_id : ' || p_notes_rec.note_id);

794:
795: arp_util.debug('************ Dump of ar_notes record ************');
796: arp_util.debug('customer_trx_id: ' || p_notes_rec.customer_trx_id);
797:
798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);
800: arp_util.debug('note_type : ' || p_notes_rec.note_type);
801: /* Bug 3206020 */
802: /*arp_util.debug('text : ' || p_notes_rec.text); */

Line 799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);

795: arp_util.debug('************ Dump of ar_notes record ************');
796: arp_util.debug('customer_trx_id: ' || p_notes_rec.customer_trx_id);
797:
798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);
800: arp_util.debug('note_type : ' || p_notes_rec.note_type);
801: /* Bug 3206020 */
802: /*arp_util.debug('text : ' || p_notes_rec.text); */
803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );

Line 800: arp_util.debug('note_type : ' || p_notes_rec.note_type);

796: arp_util.debug('customer_trx_id: ' || p_notes_rec.customer_trx_id);
797:
798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);
800: arp_util.debug('note_type : ' || p_notes_rec.note_type);
801: /* Bug 3206020 */
802: /*arp_util.debug('text : ' || p_notes_rec.text); */
803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );
804: arp_util.debug('customer_call_topic_id : ' ||

Line 802: /arp_util.debug('text : ' || p_notes_rec.text); /

798: arp_util.debug('note_id : ' || p_notes_rec.note_id);
799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);
800: arp_util.debug('note_type : ' || p_notes_rec.note_type);
801: /* Bug 3206020 */
802: /*arp_util.debug('text : ' || p_notes_rec.text); */
803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );
804: arp_util.debug('customer_call_topic_id : ' ||
805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );

Line 803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );

799: arp_util.debug('creation_date : ' || p_notes_rec.creation_date);
800: arp_util.debug('note_type : ' || p_notes_rec.note_type);
801: /* Bug 3206020 */
802: /*arp_util.debug('text : ' || p_notes_rec.text); */
803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );
804: arp_util.debug('customer_call_topic_id : ' ||
805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );
807: arp_util.debug('customer_trx_id : ' ||p_notes_rec.customer_trx_id);

Line 804: arp_util.debug('customer_call_topic_id : ' ||

800: arp_util.debug('note_type : ' || p_notes_rec.note_type);
801: /* Bug 3206020 */
802: /*arp_util.debug('text : ' || p_notes_rec.text); */
803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );
804: arp_util.debug('customer_call_topic_id : ' ||
805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );
807: arp_util.debug('customer_trx_id : ' ||p_notes_rec.customer_trx_id);
808:

Line 806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );

802: /*arp_util.debug('text : ' || p_notes_rec.text); */
803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );
804: arp_util.debug('customer_call_topic_id : ' ||
805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );
807: arp_util.debug('customer_trx_id : ' ||p_notes_rec.customer_trx_id);
808:
809: arp_util.debug('************* End ar_notes record *************');
810:

Line 807: arp_util.debug('customer_trx_id : ' ||p_notes_rec.customer_trx_id);

803: arp_util.debug('customer_call_id : ' || p_notes_rec.customer_call_id );
804: arp_util.debug('customer_call_topic_id : ' ||
805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );
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()-');

Line 809: arp_util.debug('* End ar_notes record *');

805: p_notes_rec.customer_call_topic_id );
806: arp_util.debug('call_action_id : ' ||p_notes_rec.call_action_id );
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

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 833: | arp_util.debug |

829: | SCOPE - PUBLIC |
830: | |
831: | |
832: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
833: | arp_util.debug |
834: | |
835: | IN: |
836: | p_note_id |
837: | p_last_updated_by |

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 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 917: arp_util.debug('----- parameters for lock_compare_cover() ' ||

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);
920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);

Line 919: arp_util.debug('p_note_id : ' || p_note_id);

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);
920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);

Line 920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);

916:
917: arp_util.debug('----- parameters for lock_compare_cover() ' ||
918: '-----');
919: arp_util.debug('p_note_id : ' || p_note_id);
920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);

Line 921: arp_util.debug('p_last_update_date : ' || p_last_update_date);

917: arp_util.debug('----- parameters for lock_compare_cover() ' ||
918: '-----');
919: arp_util.debug('p_note_id : ' || p_note_id);
920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);

Line 922: arp_util.debug('p_last_update_login : ' || p_last_update_login);

918: '-----');
919: arp_util.debug('p_note_id : ' || p_note_id);
920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */

Line 923: arp_util.debug('p_created_by : ' || p_created_by);

919: arp_util.debug('p_note_id : ' || p_note_id);
920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */

Line 924: arp_util.debug('p_creation_date : ' || p_creation_date);

920: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);

Line 925: arp_util.debug('p_note_type : ' || p_note_type);

921: arp_util.debug('p_last_update_date : ' || p_last_update_date);
922: arp_util.debug('p_last_update_login : ' || p_last_update_login);
923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);

Line 927: /* arp_util.debug('p_text : ' || p_text); */

923: arp_util.debug('p_created_by : ' || p_created_by);
924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
930: arp_util.debug('p_call_action_id : ' || p_call_action_id);
931: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);

Line 928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);

924: arp_util.debug('p_creation_date : ' || p_creation_date);
925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
930: arp_util.debug('p_call_action_id : ' || p_call_action_id);
931: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
932:

Line 929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);

925: arp_util.debug('p_note_type : ' || p_note_type);
926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
930: arp_util.debug('p_call_action_id : ' || p_call_action_id);
931: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
932:
933: RAISE;

Line 930: arp_util.debug('p_call_action_id : ' || p_call_action_id);

926: /* Bg 3206020 */
927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
930: arp_util.debug('p_call_action_id : ' || p_call_action_id);
931: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
932:
933: RAISE;
934:

Line 931: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);

927: /* arp_util.debug('p_text : ' || p_text); */
928: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
929: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
930: arp_util.debug('p_call_action_id : ' || p_call_action_id);
931: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
932:
933: RAISE;
934:
935: END;

Line 950: | arp_util.debug |

946: | SCOPE - PUBLIC |
947: | |
948: | |
949: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
950: | arp_util.debug |
951: | |
952: | IN: |
953: | p_note_id |
954: | p_note_type |

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 1043: arp_util.debug('----- parameters for insert_cover() ' ||

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);
1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);

Line 1045: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);

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);
1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);

Line 1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);

1042:
1043: arp_util.debug('----- parameters for insert_cover() ' ||
1044: '-----');
1045: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);

Line 1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);

1043: arp_util.debug('----- parameters for insert_cover() ' ||
1044: '-----');
1045: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */

Line 1048: arp_util.debug('p_created_by : ' || p_created_by);

1044: '-----');
1045: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */

Line 1049: arp_util.debug('p_creation_date : ' || p_creation_date);

1045: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);

Line 1050: arp_util.debug('p_note_type : ' || p_note_type);

1046: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1047: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);

Line 1052: /* arp_util.debug('p_text : ' || p_text); */

1048: arp_util.debug('p_created_by : ' || p_created_by);
1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1055: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1056: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);

Line 1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);

1049: arp_util.debug('p_creation_date : ' || p_creation_date);
1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1055: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1056: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1057:

Line 1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);

1050: arp_util.debug('p_note_type : ' || p_note_type);
1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1055: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1056: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1057:
1058: RAISE;

Line 1055: arp_util.debug('p_call_action_id : ' || p_call_action_id);

1051: /* Bug 3206020 */
1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1055: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1056: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1057:
1058: RAISE;
1059:

Line 1056: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);

1052: /* arp_util.debug('p_text : ' || p_text); */
1053: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1054: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1055: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1056: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1057:
1058: RAISE;
1059:
1060: END;

Line 1074: | arp_util.debug |

1070: | SCOPE - PUBLIC |
1071: | |
1072: | |
1073: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1074: | arp_util.debug |
1075: | |
1076: | IN: |
1077: | p_note_id |
1078: | p_created_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 1165: arp_util.debug('----- parameters for update_cover() ' ||

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);
1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);

Line 1167: arp_util.debug('p_note_id : ' || p_note_id);

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);
1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);

Line 1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);

1164:
1165: arp_util.debug('----- parameters for update_cover() ' ||
1166: '-----');
1167: arp_util.debug('p_note_id : ' || p_note_id);
1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);

Line 1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);

1165: arp_util.debug('----- parameters for update_cover() ' ||
1166: '-----');
1167: arp_util.debug('p_note_id : ' || p_note_id);
1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);

Line 1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);

1166: '-----');
1167: arp_util.debug('p_note_id : ' || p_note_id);
1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */

Line 1171: arp_util.debug('p_created_by : ' || p_created_by);

1167: arp_util.debug('p_note_id : ' || p_note_id);
1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */

Line 1172: arp_util.debug('p_creation_date : ' || p_creation_date);

1168: arp_util.debug('p_last_updated_by : ' || p_last_updated_by);
1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);

Line 1173: arp_util.debug('p_note_type : ' || p_note_type);

1169: arp_util.debug('p_last_update_date : ' || p_last_update_date);
1170: arp_util.debug('p_last_update_login : ' || p_last_update_login);
1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);

Line 1175: /* arp_util.debug('p_text : ' || p_text); */

1171: arp_util.debug('p_created_by : ' || p_created_by);
1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1178: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1179: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);

Line 1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);

1172: arp_util.debug('p_creation_date : ' || p_creation_date);
1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1178: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1179: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1180:

Line 1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);

1173: arp_util.debug('p_note_type : ' || p_note_type);
1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1178: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1179: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1180:
1181: RAISE;

Line 1178: arp_util.debug('p_call_action_id : ' || p_call_action_id);

1174: /* Bug 3206020 */
1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1178: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1179: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1180:
1181: RAISE;
1182:

Line 1179: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);

1175: /* arp_util.debug('p_text : ' || p_text); */
1176: arp_util.debug('p_customer_call_id : ' || p_customer_call_id);
1177: arp_util.debug('p_customer_call_topic_id : ' || p_customer_call_topic_id);
1178: arp_util.debug('p_call_action_id : ' || p_call_action_id);
1179: arp_util.debug('p_customer_trx_id : ' || p_customer_trx_id);
1180:
1181: RAISE;
1182:
1183: END;