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

Line 44: | arp_util.debug - debug procedure |

40: | |
41: | SCOPE - PUBLIC |
42: | |
43: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
44: | arp_util.debug - debug procedure |
45: | |
46: | ARGUMENTS : IN: |
47: | p_row_id - Row ID |
48: | p_batch_source_id - Batch Source Id |

Line 107: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()+' );

103: --
104: l_batch_rec ar_batches%ROWTYPE;
105: BEGIN
106: IF PG_DEBUG in ('Y', 'C') THEN
107: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()+' );
108: arp_util.debug( 'Row Id : '||p_row_id );
109: arp_util.debug( 'Batch ID : '||p_batch_id );
110: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
111: END IF;

Line 108: arp_util.debug( 'Row Id : '||p_row_id );

104: l_batch_rec ar_batches%ROWTYPE;
105: BEGIN
106: IF PG_DEBUG in ('Y', 'C') THEN
107: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()+' );
108: arp_util.debug( 'Row Id : '||p_row_id );
109: arp_util.debug( 'Batch ID : '||p_batch_id );
110: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
111: END IF;
112: --

Line 109: arp_util.debug( 'Batch ID : '||p_batch_id );

105: BEGIN
106: IF PG_DEBUG in ('Y', 'C') THEN
107: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()+' );
108: arp_util.debug( 'Row Id : '||p_row_id );
109: arp_util.debug( 'Batch ID : '||p_batch_id );
110: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
111: END IF;
112: --
113: -- Set local batch record fields to DUMMY

Line 110: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );

106: IF PG_DEBUG in ('Y', 'C') THEN
107: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()+' );
108: arp_util.debug( 'Row Id : '||p_row_id );
109: arp_util.debug( 'Batch ID : '||p_batch_id );
110: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
111: END IF;
112: --
113: -- Set local batch record fields to DUMMY
114: --

Line 166: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()-' );

162: --
163: arp_rw_batches_check_pkg.update_batch_status( l_batch_rec.batch_id );
164: --
165: IF PG_DEBUG in ('Y', 'C') THEN
166: arp_util.debug( 'arp_rw_batches_pkg.update_manual_batch()-' );
167: END IF;
168: --
169: EXCEPTION
170: WHEN OTHERS THEN

Line 172: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.update_manual_batch' );

168: --
169: EXCEPTION
170: WHEN OTHERS THEN
171: IF PG_DEBUG in ('Y', 'C') THEN
172: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.update_manual_batch' );
173: END IF;
174: RAISE;
175: END update_manual_batch;
176: --

Line 189: | arp_util.debug - debug procedure |

185: | |
186: | SCOPE - PUBLIC |
187: | |
188: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
189: | arp_util.debug - debug procedure |
190: | |
191: | ARGUMENTS : IN: |
192: | p_row_id - Row ID |
193: | p_batch_source_id - Batch Source Id |

Line 253: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()+' );

249:
250: l_batch_rec ar_batches%ROWTYPE;
251: BEGIN
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()+' );
254: arp_util.debug( 'Row Id : '||p_row_id );
255: arp_util.debug( 'Batch ID : '||p_batch_id );
256: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
257: END IF;

Line 254: arp_util.debug( 'Row Id : '||p_row_id );

250: l_batch_rec ar_batches%ROWTYPE;
251: BEGIN
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()+' );
254: arp_util.debug( 'Row Id : '||p_row_id );
255: arp_util.debug( 'Batch ID : '||p_batch_id );
256: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
257: END IF;
258:

Line 255: arp_util.debug( 'Batch ID : '||p_batch_id );

251: BEGIN
252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()+' );
254: arp_util.debug( 'Row Id : '||p_row_id );
255: arp_util.debug( 'Batch ID : '||p_batch_id );
256: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
257: END IF;
258:
259: -- Set local batch record fields to DUMMY. This clears out NOCOPY any unwanted

Line 256: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );

252: IF PG_DEBUG in ('Y', 'C') THEN
253: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()+' );
254: arp_util.debug( 'Row Id : '||p_row_id );
255: arp_util.debug( 'Batch ID : '||p_batch_id );
256: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
257: END IF;
258:
259: -- Set local batch record fields to DUMMY. This clears out NOCOPY any unwanted
260: -- values from a previous update.

Line 318: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()-' );

314: arp_cr_batches_pkg.update_p( l_batch_rec, l_batch_rec.batch_id );
315:
316:
317: IF PG_DEBUG in ('Y', 'C') THEN
318: arp_util.debug( 'arp_rw_batches_pkg.update_remit_batch()-' );
319: END IF;
320:
321: EXCEPTION
322: WHEN OTHERS THEN

Line 324: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.update_remit_batch' );

320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: IF PG_DEBUG in ('Y', 'C') THEN
324: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.update_remit_batch' );
325: END IF;
326: RAISE;
327: END update_remit_batch;
328: ---

Line 342: | arp_util.debug - debug procedure |

338: | |
339: | SCOPE - PUBLIC |
340: | |
341: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
342: | arp_util.debug - debug procedure |
343: | |
344: | ARGUMENTS : IN: |
345: | p_row_id - Row ID |
346: | p_batch_source_id - Batch Source Id |

Line 406: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()+' );

402:
403: l_batch_rec ar_batches%ROWTYPE;
404: BEGIN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()+' );
407: arp_util.debug( 'Row Id : '||p_row_id );
408: arp_util.debug( 'Batch ID : '||p_batch_id );
409: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
410: END IF;

Line 407: arp_util.debug( 'Row Id : '||p_row_id );

403: l_batch_rec ar_batches%ROWTYPE;
404: BEGIN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()+' );
407: arp_util.debug( 'Row Id : '||p_row_id );
408: arp_util.debug( 'Batch ID : '||p_batch_id );
409: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
410: END IF;
411:

Line 408: arp_util.debug( 'Batch ID : '||p_batch_id );

404: BEGIN
405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()+' );
407: arp_util.debug( 'Row Id : '||p_row_id );
408: arp_util.debug( 'Batch ID : '||p_batch_id );
409: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
410: END IF;
411:
412: -- Set local batch record fields to DUMMY. This clears out NOCOPY any unwanted

Line 409: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );

405: IF PG_DEBUG in ('Y', 'C') THEN
406: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()+' );
407: arp_util.debug( 'Row Id : '||p_row_id );
408: arp_util.debug( 'Batch ID : '||p_batch_id );
409: arp_util.debug( 'Batch Date : '||TO_CHAR( p_batch_date ) );
410: END IF;
411:
412: -- Set local batch record fields to DUMMY. This clears out NOCOPY any unwanted
413: -- values from a previous update.

Line 471: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()-' );

467: arp_cr_batches_pkg.update_p( l_batch_rec, l_batch_rec.batch_id );
468:
469:
470: IF PG_DEBUG in ('Y', 'C') THEN
471: arp_util.debug( 'arp_rw_batches_pkg.update_auto_batch()-' );
472: END IF;
473:
474: EXCEPTION
475: WHEN OTHERS THEN

Line 477: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.update_auto_batch' );

473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: IF PG_DEBUG in ('Y', 'C') THEN
477: arp_util.debug( 'EXCEPTION: arp_rw_batches_pkg.update_auto_batch' );
478: END IF;
479: RAISE;
480: END update_auto_batch;
481:

Line 493: | arp_util.debug - debug procedure |

489: | |
490: | SCOPE - PUBLIC |
491: | |
492: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
493: | arp_util.debug - debug procedure |
494: | |
495: | ARGUMENTS : IN: |
496: | p_batch_id - Batch Id |
497: | |

Line 519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );

515: l_bat_id ar_batches.batch_id%TYPE;
516: l_type ar_batches.type%TYPE;
517: BEGIN
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );
520: arp_util.debug( 'Batch ID : '||p_batch_id );
521: END IF;
522: --
523: IF PG_DEBUG in ('Y', 'C') THEN

Line 520: arp_util.debug( 'Batch ID : '||p_batch_id );

516: l_type ar_batches.type%TYPE;
517: BEGIN
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );
520: arp_util.debug( 'Batch ID : '||p_batch_id );
521: END IF;
522: --
523: IF PG_DEBUG in ('Y', 'C') THEN
524: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()-' );

Line 524: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()-' );

520: arp_util.debug( 'Batch ID : '||p_batch_id );
521: END IF;
522: --
523: IF PG_DEBUG in ('Y', 'C') THEN
524: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()-' );
525: END IF;
526: --
527: -- Set batch record values to dummy
528: --

Line 682: arp_util.debug(

678: --
679: EXCEPTION
680: WHEN OTHERS THEN
681: IF PG_DEBUG in ('Y', 'C') THEN
682: arp_util.debug(
683: 'EXCEPTION: arp_rw_batches_check_pkg.update_batch_status' );
684: END IF;
685: RAISE;
686: END update_batch_status;

Line 698: | arp_util.debug - debug procedure |

694: | |
695: | SCOPE - PRIVATE |
696: | |
697: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
698: | arp_util.debug - debug procedure |
699: | |
700: | ARGUMENTS : IN: |
701: | p_type - Batch Type |
702: | OUT: |

Line 718: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()+' );

714: p_batch_date IN ar_batches.batch_date%TYPE ) IS
715:
716: BEGIN
717: IF PG_DEBUG in ('Y', 'C') THEN
718: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()+' );
719: END IF;
720: --
721: IF ( p_row_id IS NULL OR p_batch_id IS NULL OR
722: p_batch_date IS NULL ) THEN

Line 728: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()-' );

724: APP_EXCEPTION.raise_exception;
725: END IF;
726: --
727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()-' );
729: END IF;
730: --
731: EXCEPTION
732: WHEN OTHERS THEN

Line 734: arp_util.debug(

730: --
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF PG_DEBUG in ('Y', 'C') THEN
734: arp_util.debug(
735: 'EXCEPTION: arp_rw_batches_pkg.validate_args_update_manual' );
736: END IF;
737: RAISE;
738: END validate_args_update_manual;

Line 750: | arp_util.debug - debug procedure |

746: | |
747: | SCOPE - PRIVATE |
748: | |
749: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
750: | arp_util.debug - debug procedure |
751: | |
752: | ARGUMENTS : IN: |
753: | p_type - Batch Type |
754: | OUT: |

Line 770: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()+' );

766: p_batch_date IN ar_batches.batch_date%TYPE ) IS
767:
768: BEGIN
769: IF PG_DEBUG in ('Y', 'C') THEN
770: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()+' );
771: END IF;
772: --
773: IF ( p_row_id IS NULL OR p_batch_id IS NULL OR
774: p_batch_date IS NULL ) THEN

Line 780: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()-' );

776: APP_EXCEPTION.raise_exception;
777: END IF;
778: --
779: IF PG_DEBUG in ('Y', 'C') THEN
780: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()-' );
781: END IF;
782: --
783: EXCEPTION
784: WHEN OTHERS THEN

Line 786: arp_util.debug(

782: --
783: EXCEPTION
784: WHEN OTHERS THEN
785: IF PG_DEBUG in ('Y', 'C') THEN
786: arp_util.debug(
787: 'EXCEPTION: arp_rw_batches_pkg.validate_args_update_remit' );
788: END IF;
789: RAISE;
790: END validate_args_update_remit;

Line 802: | arp_util.debug - debug procedure |

798: | |
799: | SCOPE - PRIVATE |
800: | |
801: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
802: | arp_util.debug - debug procedure |
803: | |
804: | ARGUMENTS : IN: |
805: | p_type - Batch Type |
806: | OUT: |

Line 822: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()+' );

818: p_batch_date IN ar_batches.batch_date%TYPE ) IS
819:
820: BEGIN
821: IF PG_DEBUG in ('Y', 'C') THEN
822: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()+' );
823: END IF;
824: --
825: IF ( p_row_id IS NULL OR p_batch_id IS NULL OR
826: p_batch_date IS NULL ) THEN

Line 832: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()-' );

828: APP_EXCEPTION.raise_exception;
829: END IF;
830: --
831: IF PG_DEBUG in ('Y', 'C') THEN
832: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()-' );
833: END IF;
834: --
835: EXCEPTION
836: WHEN OTHERS THEN

Line 838: arp_util.debug(

834: --
835: EXCEPTION
836: WHEN OTHERS THEN
837: IF PG_DEBUG in ('Y', 'C') THEN
838: arp_util.debug(
839: 'EXCEPTION: arp_rw_batches_pkg.validate_args_update_auto' );
840: END IF;
841: RAISE;
842: END validate_args_update_auto;

Line 855: | arp_util.debug - debug procedure |

851: | |
852: | SCOPE - PUBLIC |
853: | |
854: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
855: | arp_util.debug - debug procedure |
856: | |
857: | ARGUMENTS : IN: |
858: | p_row_id - Row ID |
859: | p_batch_source_id - Batch Source Id |

Line 881: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );

877: p_module_version IN VARCHAR2 ) IS
878: l_count NUMBER := 0;
879: BEGIN
880: IF PG_DEBUG in ('Y', 'C') THEN
881: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
882: arp_util.debug( 'Row Id : '||p_row_id );
883: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
884: arp_util.debug( 'Batch Name : '||p_batch_name );
885: END IF;

Line 882: arp_util.debug( 'Row Id : '||p_row_id );

878: l_count NUMBER := 0;
879: BEGIN
880: IF PG_DEBUG in ('Y', 'C') THEN
881: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
882: arp_util.debug( 'Row Id : '||p_row_id );
883: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
884: arp_util.debug( 'Batch Name : '||p_batch_name );
885: END IF;
886: --

Line 883: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );

879: BEGIN
880: IF PG_DEBUG in ('Y', 'C') THEN
881: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
882: arp_util.debug( 'Row Id : '||p_row_id );
883: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
884: arp_util.debug( 'Batch Name : '||p_batch_name );
885: END IF;
886: --
887: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

Line 884: arp_util.debug( 'Batch Name : '||p_batch_name );

880: IF PG_DEBUG in ('Y', 'C') THEN
881: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
882: arp_util.debug( 'Row Id : '||p_row_id );
883: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
884: arp_util.debug( 'Batch Name : '||p_batch_name );
885: END IF;
886: --
887: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
888: validate_args_cu_batch_name( p_batch_source_id, p_batch_name );

Line 904: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()-' );

900: APP_EXCEPTION.raise_exception;
901: END IF;
902: --
903: IF PG_DEBUG in ('Y', 'C') THEN
904: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()-' );
905: END IF;
906: --
907: EXCEPTION
908: WHEN OTHERS THEN

Line 910: arp_util.debug(

906: --
907: EXCEPTION
908: WHEN OTHERS THEN
909: IF PG_DEBUG in ('Y', 'C') THEN
910: arp_util.debug(
911: 'EXCEPTION: arp_rw_batches_pkg.check_unique_batch_name' );
912: END IF;
913: RAISE;
914: END check_unique_batch_name;

Line 926: | arp_util.debug - debug procedure |

922: | |
923: | SCOPE - PRIVATE |
924: | |
925: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
926: | arp_util.debug - debug procedure |
927: | |
928: | ARGUMENTS : IN: |
929: | p_batch_source_id - Batch source ID |
930: | p_batch_name - Batch Name |

Line 945: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );

941: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
942: p_batch_name IN ar_batches.name%TYPE ) IS
943: BEGIN
944: IF PG_DEBUG in ('Y', 'C') THEN
945: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
946: END IF;
947: --
948: IF ( p_batch_source_id is NULL OR p_batch_name is NULL ) THEN
949: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 954: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()-' );

950: APP_EXCEPTION.raise_exception;
951: END IF;
952: --
953: IF PG_DEBUG in ('Y', 'C') THEN
954: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()-' );
955: END IF;
956: --
957: EXCEPTION
958: WHEN OTHERS THEN

Line 960: arp_util.debug(

956: --
957: EXCEPTION
958: WHEN OTHERS THEN
959: IF PG_DEBUG in ('Y', 'C') THEN
960: arp_util.debug(
961: 'EXCEPTION: arp_rw_batches_pkg.validate_args_cu_batch_name' );
962: END IF;
963: RAISE;
964: END validate_args_cu_batch_name;

Line 977: | arp_util.debug - debug procedure |

973: | |
974: | SCOPE - PUBLIC |
975: | |
976: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
977: | arp_util.debug - debug procedure |
978: | |
979: | ARGUMENTS : IN: |
980: | p_row_id - Row ID |
981: | p_batch_source_name - Batch source Name |

Line 1003: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );

999: p_module_version IN VARCHAR2 ) IS
1000: l_count NUMBER := 0;
1001: BEGIN
1002: IF PG_DEBUG in ('Y', 'C') THEN
1003: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
1004: arp_util.debug( 'Row Id : '||p_row_id );
1005: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
1006: arp_util.debug( 'Batch Name : '||p_batch_name );
1007: END IF;

Line 1004: arp_util.debug( 'Row Id : '||p_row_id );

1000: l_count NUMBER := 0;
1001: BEGIN
1002: IF PG_DEBUG in ('Y', 'C') THEN
1003: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
1004: arp_util.debug( 'Row Id : '||p_row_id );
1005: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
1006: arp_util.debug( 'Batch Name : '||p_batch_name );
1007: END IF;
1008: --

Line 1005: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );

1001: BEGIN
1002: IF PG_DEBUG in ('Y', 'C') THEN
1003: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
1004: arp_util.debug( 'Row Id : '||p_row_id );
1005: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
1006: arp_util.debug( 'Batch Name : '||p_batch_name );
1007: END IF;
1008: --
1009: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

Line 1006: arp_util.debug( 'Batch Name : '||p_batch_name );

1002: IF PG_DEBUG in ('Y', 'C') THEN
1003: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
1004: arp_util.debug( 'Row Id : '||p_row_id );
1005: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
1006: arp_util.debug( 'Batch Name : '||p_batch_name );
1007: END IF;
1008: --
1009: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1010: validate_args_cu_batch_name( p_batch_source_name, p_batch_name );

Line 1028: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()-' );

1024: APP_EXCEPTION.raise_exception;
1025: END IF;
1026: --
1027: IF PG_DEBUG in ('Y', 'C') THEN
1028: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()-' );
1029: END IF;
1030: --
1031: EXCEPTION
1032: WHEN OTHERS THEN

Line 1034: arp_util.debug(

1030: --
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF PG_DEBUG in ('Y', 'C') THEN
1034: arp_util.debug(
1035: 'EXCEPTION: arp_rw_batches_pkg.check_unique_batch_name' );
1036: END IF;
1037: RAISE;
1038: END check_unique_batch_name;

Line 1050: | arp_util.debug - debug procedure |

1046: | |
1047: | SCOPE - PRIVATE |
1048: | |
1049: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1050: | arp_util.debug - debug procedure |
1051: | |
1052: | ARGUMENTS : IN: |
1053: | p_batch_source_name - Batch source Name |
1054: | p_batch_name - Batch Name |

Line 1069: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );

1065: p_batch_source_name IN ar_batch_sources.name%TYPE,
1066: p_batch_name IN ar_batches.name%TYPE ) IS
1067: BEGIN
1068: IF PG_DEBUG in ('Y', 'C') THEN
1069: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
1070: END IF;
1071: --
1072: IF ( p_batch_source_name is NULL OR p_batch_name is NULL ) THEN
1073: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1078: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()-' );

1074: APP_EXCEPTION.raise_exception;
1075: END IF;
1076: --
1077: IF PG_DEBUG in ('Y', 'C') THEN
1078: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()-' );
1079: END IF;
1080: --
1081: EXCEPTION
1082: WHEN OTHERS THEN

Line 1084: arp_util.debug(

1080: --
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: IF PG_DEBUG in ('Y', 'C') THEN
1084: arp_util.debug(
1085: 'EXCEPTION: arp_rw_batches_pkg.validate_args_cu_batch_name' );
1086: END IF;
1087: RAISE;
1088: END validate_args_cu_batch_name;

Line 1100: | arp_util.debug - debug procedure |

1096: | |
1097: | SCOPE - PUBLIC |
1098: | |
1099: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1100: | arp_util.debug - debug procedure |
1101: | |
1102: | ARGUMENTS : IN: |
1103: | p_row_id - Row ID |
1104: | p_module_name - Module that called this procedure |

Line 1123: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );

1119: p_module_version IN VARCHAR2 ) IS
1120: l_count NUMBER := 0;
1121: BEGIN
1122: IF PG_DEBUG in ('Y', 'C') THEN
1123: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );
1124: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );
1125: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );
1126: END IF;
1127: --

Line 1124: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );

1120: l_count NUMBER := 0;
1121: BEGIN
1122: IF PG_DEBUG in ('Y', 'C') THEN
1123: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );
1124: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );
1125: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );
1126: END IF;
1127: --
1128: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

Line 1125: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );

1121: BEGIN
1122: IF PG_DEBUG in ('Y', 'C') THEN
1123: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );
1124: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );
1125: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );
1126: END IF;
1127: --
1128: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1129: validate_args_cu_media_ref( p_media_ref );

Line 1144: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()-' );

1140: APP_EXCEPTION.raise_exception;
1141: END IF;
1142: --
1143: IF PG_DEBUG in ('Y', 'C') THEN
1144: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()-' );
1145: END IF;
1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN

Line 1150: arp_util.debug('check_unique_media_ref: ' ||

1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: IF PG_DEBUG in ('Y', 'C') THEN
1150: arp_util.debug('check_unique_media_ref: ' ||
1151: 'EXCEPTION: arp_rw_batches_pkg.check_unique_media_ref' );
1152: END IF;
1153: RAISE;
1154: END check_unique_media_ref;

Line 1166: | arp_util.debug - debug procedure |

1162: | |
1163: | SCOPE - PRIVATE |
1164: | |
1165: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1166: | arp_util.debug - debug procedure |
1167: | |
1168: | ARGUMENTS : IN: |
1169: | p_media_ref - Media reference |
1170: | OUT: |

Line 1183: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()+' );

1179: PROCEDURE validate_args_cu_media_ref(
1180: p_media_ref IN ar_batches.media_reference%TYPE ) IS
1181: BEGIN
1182: IF PG_DEBUG in ('Y', 'C') THEN
1183: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()+' );
1184: END IF;
1185: --
1186: IF ( p_media_ref is NULL ) THEN
1187: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1192: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()-' );

1188: APP_EXCEPTION.raise_exception;
1189: END IF;
1190: --
1191: IF PG_DEBUG in ('Y', 'C') THEN
1192: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()-' );
1193: END IF;
1194: --
1195: EXCEPTION
1196: WHEN OTHERS THEN

Line 1198: arp_util.debug('validate_args_cu_media_ref: ' ||

1194: --
1195: EXCEPTION
1196: WHEN OTHERS THEN
1197: IF PG_DEBUG in ('Y', 'C') THEN
1198: arp_util.debug('validate_args_cu_media_ref: ' ||
1199: 'EXCEPTION: arp_rw_batches_pkg.validate_args_cu_media_ref' );
1200: END IF;
1201: RAISE;
1202: END validate_args_cu_media_ref;

Line 1214: | arp_util.debug - debug procedure |

1210: | |
1211: | SCOPE - PUBLIC |
1212: | |
1213: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1214: | arp_util.debug - debug procedure |
1215: | |
1216: | ARGUMENTS : IN: |
1217: | p_batch_id - Batch Id associated with the batch |
1218: | p_set_of_books_id - set of books id |

Line 1313: | arp_util.debug - debug procedure |

1309: | |
1310: | SCOPE - PUBLIC |
1311: | |
1312: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1313: | arp_util.debug - debug procedure |
1314: | |
1315: | ARGUMENTS : IN: |
1316: | p_batch_id - Batch Id associated with the batch |
1317: | p_module_name - Module name that called this procedure |