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 514: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );

510: l_batch_status VARCHAR2( 30 );
511: l_batch_rec ar_batches%ROWTYPE;
512: BEGIN
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );
515: arp_util.debug( 'Batch ID : '||p_batch_id );
516: END IF;
517: --
518: IF PG_DEBUG in ('Y', 'C') THEN

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

511: l_batch_rec ar_batches%ROWTYPE;
512: BEGIN
513: IF PG_DEBUG in ('Y', 'C') THEN
514: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()+' );
515: arp_util.debug( 'Batch ID : '||p_batch_id );
516: END IF;
517: --
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()-' );

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

515: arp_util.debug( 'Batch ID : '||p_batch_id );
516: END IF;
517: --
518: IF PG_DEBUG in ('Y', 'C') THEN
519: arp_util.debug( 'arp_rw_batches_check_pkg.update_batch_status()-' );
520: END IF;
521: --
522: -- Set batch record values to dummy
523: --

Line 634: arp_util.debug(

630: --
631: EXCEPTION
632: WHEN OTHERS THEN
633: IF PG_DEBUG in ('Y', 'C') THEN
634: arp_util.debug(
635: 'EXCEPTION: arp_rw_batches_check_pkg.update_batch_status' );
636: END IF;
637: RAISE;
638: END update_batch_status;

Line 650: | arp_util.debug - debug procedure |

646: | |
647: | SCOPE - PRIVATE |
648: | |
649: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
650: | arp_util.debug - debug procedure |
651: | |
652: | ARGUMENTS : IN: |
653: | p_type - Batch Type |
654: | OUT: |

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

666: p_batch_date IN ar_batches.batch_date%TYPE ) IS
667:
668: BEGIN
669: IF PG_DEBUG in ('Y', 'C') THEN
670: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()+' );
671: END IF;
672: --
673: IF ( p_row_id IS NULL OR p_batch_id IS NULL OR
674: p_batch_date IS NULL ) THEN

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

676: APP_EXCEPTION.raise_exception;
677: END IF;
678: --
679: IF PG_DEBUG in ('Y', 'C') THEN
680: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_manual()-' );
681: END IF;
682: --
683: EXCEPTION
684: WHEN OTHERS THEN

Line 686: arp_util.debug(

682: --
683: EXCEPTION
684: WHEN OTHERS THEN
685: IF PG_DEBUG in ('Y', 'C') THEN
686: arp_util.debug(
687: 'EXCEPTION: arp_rw_batches_pkg.validate_args_update_manual' );
688: END IF;
689: RAISE;
690: END validate_args_update_manual;

Line 702: | arp_util.debug - debug procedure |

698: | |
699: | SCOPE - PRIVATE |
700: | |
701: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
702: | arp_util.debug - debug procedure |
703: | |
704: | ARGUMENTS : IN: |
705: | p_type - Batch Type |
706: | OUT: |

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

718: p_batch_date IN ar_batches.batch_date%TYPE ) IS
719:
720: BEGIN
721: IF PG_DEBUG in ('Y', 'C') THEN
722: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()+' );
723: END IF;
724: --
725: IF ( p_row_id IS NULL OR p_batch_id IS NULL OR
726: p_batch_date IS NULL ) THEN

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

728: APP_EXCEPTION.raise_exception;
729: END IF;
730: --
731: IF PG_DEBUG in ('Y', 'C') THEN
732: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_remit()-' );
733: END IF;
734: --
735: EXCEPTION
736: WHEN OTHERS THEN

Line 738: arp_util.debug(

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

Line 754: | arp_util.debug - debug procedure |

750: | |
751: | SCOPE - PRIVATE |
752: | |
753: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
754: | arp_util.debug - debug procedure |
755: | |
756: | ARGUMENTS : IN: |
757: | p_type - Batch Type |
758: | OUT: |

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

770: p_batch_date IN ar_batches.batch_date%TYPE ) IS
771:
772: BEGIN
773: IF PG_DEBUG in ('Y', 'C') THEN
774: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()+' );
775: END IF;
776: --
777: IF ( p_row_id IS NULL OR p_batch_id IS NULL OR
778: p_batch_date IS NULL ) THEN

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

780: APP_EXCEPTION.raise_exception;
781: END IF;
782: --
783: IF PG_DEBUG in ('Y', 'C') THEN
784: arp_util.debug( 'arp_rw_batches_pkg.validate_args_update_auto()-' );
785: END IF;
786: --
787: EXCEPTION
788: WHEN OTHERS THEN

Line 790: arp_util.debug(

786: --
787: EXCEPTION
788: WHEN OTHERS THEN
789: IF PG_DEBUG in ('Y', 'C') THEN
790: arp_util.debug(
791: 'EXCEPTION: arp_rw_batches_pkg.validate_args_update_auto' );
792: END IF;
793: RAISE;
794: END validate_args_update_auto;

Line 807: | arp_util.debug - debug procedure |

803: | |
804: | SCOPE - PUBLIC |
805: | |
806: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
807: | arp_util.debug - debug procedure |
808: | |
809: | ARGUMENTS : IN: |
810: | p_row_id - Row ID |
811: | p_batch_source_id - Batch Source Id |

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

829: p_module_version IN VARCHAR2 ) IS
830: l_count NUMBER := 0;
831: BEGIN
832: IF PG_DEBUG in ('Y', 'C') THEN
833: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
834: arp_util.debug( 'Row Id : '||p_row_id );
835: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
836: arp_util.debug( 'Batch Name : '||p_batch_name );
837: END IF;

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

830: l_count NUMBER := 0;
831: BEGIN
832: IF PG_DEBUG in ('Y', 'C') THEN
833: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
834: arp_util.debug( 'Row Id : '||p_row_id );
835: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
836: arp_util.debug( 'Batch Name : '||p_batch_name );
837: END IF;
838: --

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

831: BEGIN
832: IF PG_DEBUG in ('Y', 'C') THEN
833: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
834: arp_util.debug( 'Row Id : '||p_row_id );
835: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
836: arp_util.debug( 'Batch Name : '||p_batch_name );
837: END IF;
838: --
839: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

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

832: IF PG_DEBUG in ('Y', 'C') THEN
833: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
834: arp_util.debug( 'Row Id : '||p_row_id );
835: arp_util.debug( 'Batch Source Id : '||TO_CHAR( p_batch_source_id ) );
836: arp_util.debug( 'Batch Name : '||p_batch_name );
837: END IF;
838: --
839: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
840: validate_args_cu_batch_name( p_batch_source_id, p_batch_name );

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

852: APP_EXCEPTION.raise_exception;
853: END IF;
854: --
855: IF PG_DEBUG in ('Y', 'C') THEN
856: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()-' );
857: END IF;
858: --
859: EXCEPTION
860: WHEN OTHERS THEN

Line 862: arp_util.debug(

858: --
859: EXCEPTION
860: WHEN OTHERS THEN
861: IF PG_DEBUG in ('Y', 'C') THEN
862: arp_util.debug(
863: 'EXCEPTION: arp_rw_batches_pkg.check_unique_batch_name' );
864: END IF;
865: RAISE;
866: END check_unique_batch_name;

Line 878: | arp_util.debug - debug procedure |

874: | |
875: | SCOPE - PRIVATE |
876: | |
877: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
878: | arp_util.debug - debug procedure |
879: | |
880: | ARGUMENTS : IN: |
881: | p_batch_source_id - Batch source ID |
882: | p_batch_name - Batch Name |

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

893: p_batch_source_id IN ar_batch_sources.batch_source_id%TYPE,
894: p_batch_name IN ar_batches.name%TYPE ) IS
895: BEGIN
896: IF PG_DEBUG in ('Y', 'C') THEN
897: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
898: END IF;
899: --
900: IF ( p_batch_source_id is NULL OR p_batch_name is NULL ) THEN
901: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

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

Line 912: arp_util.debug(

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

Line 929: | arp_util.debug - debug procedure |

925: | |
926: | SCOPE - PUBLIC |
927: | |
928: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
929: | arp_util.debug - debug procedure |
930: | |
931: | ARGUMENTS : IN: |
932: | p_row_id - Row ID |
933: | p_batch_source_name - Batch source Name |

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

951: p_module_version IN VARCHAR2 ) IS
952: l_count NUMBER := 0;
953: BEGIN
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
956: arp_util.debug( 'Row Id : '||p_row_id );
957: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
958: arp_util.debug( 'Batch Name : '||p_batch_name );
959: END IF;

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

952: l_count NUMBER := 0;
953: BEGIN
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
956: arp_util.debug( 'Row Id : '||p_row_id );
957: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
958: arp_util.debug( 'Batch Name : '||p_batch_name );
959: END IF;
960: --

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

953: BEGIN
954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
956: arp_util.debug( 'Row Id : '||p_row_id );
957: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
958: arp_util.debug( 'Batch Name : '||p_batch_name );
959: END IF;
960: --
961: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

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

954: IF PG_DEBUG in ('Y', 'C') THEN
955: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()+' );
956: arp_util.debug( 'Row Id : '||p_row_id );
957: arp_util.debug( 'Batch Source Name : '||p_batch_source_name );
958: arp_util.debug( 'Batch Name : '||p_batch_name );
959: END IF;
960: --
961: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
962: validate_args_cu_batch_name( p_batch_source_name, p_batch_name );

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

976: APP_EXCEPTION.raise_exception;
977: END IF;
978: --
979: IF PG_DEBUG in ('Y', 'C') THEN
980: arp_util.debug( 'arp_rw_batches_pkg.check_unique_batch_name()-' );
981: END IF;
982: --
983: EXCEPTION
984: WHEN OTHERS THEN

Line 986: arp_util.debug(

982: --
983: EXCEPTION
984: WHEN OTHERS THEN
985: IF PG_DEBUG in ('Y', 'C') THEN
986: arp_util.debug(
987: 'EXCEPTION: arp_rw_batches_pkg.check_unique_batch_name' );
988: END IF;
989: RAISE;
990: END check_unique_batch_name;

Line 1002: | arp_util.debug - debug procedure |

998: | |
999: | SCOPE - PRIVATE |
1000: | |
1001: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1002: | arp_util.debug - debug procedure |
1003: | |
1004: | ARGUMENTS : IN: |
1005: | p_batch_source_name - Batch source Name |
1006: | p_batch_name - Batch Name |

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

1017: p_batch_source_name IN ar_batch_sources.name%TYPE,
1018: p_batch_name IN ar_batches.name%TYPE ) IS
1019: BEGIN
1020: IF PG_DEBUG in ('Y', 'C') THEN
1021: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_batch_name()+' );
1022: END IF;
1023: --
1024: IF ( p_batch_source_name is NULL OR p_batch_name is NULL ) THEN
1025: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

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

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

Line 1036: arp_util.debug(

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

Line 1052: | arp_util.debug - debug procedure |

1048: | |
1049: | SCOPE - PUBLIC |
1050: | |
1051: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1052: | arp_util.debug - debug procedure |
1053: | |
1054: | ARGUMENTS : IN: |
1055: | p_row_id - Row ID |
1056: | p_module_name - Module that called this procedure |

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

1071: p_module_version IN VARCHAR2 ) IS
1072: l_count NUMBER := 0;
1073: BEGIN
1074: IF PG_DEBUG in ('Y', 'C') THEN
1075: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );
1076: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );
1077: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );
1078: END IF;
1079: --

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

1072: l_count NUMBER := 0;
1073: BEGIN
1074: IF PG_DEBUG in ('Y', 'C') THEN
1075: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );
1076: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );
1077: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );
1078: END IF;
1079: --
1080: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN

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

1073: BEGIN
1074: IF PG_DEBUG in ('Y', 'C') THEN
1075: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()+' );
1076: arp_util.debug('check_unique_media_ref: ' || 'Row Id : '||p_row_id );
1077: arp_util.debug('check_unique_media_ref: ' || 'Media Reference : '||p_media_ref );
1078: END IF;
1079: --
1080: IF ( p_module_name IS NOT NULL AND p_module_version IS NOT NULL ) THEN
1081: validate_args_cu_media_ref( p_media_ref );

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

1092: APP_EXCEPTION.raise_exception;
1093: END IF;
1094: --
1095: IF PG_DEBUG in ('Y', 'C') THEN
1096: arp_util.debug( 'arp_rw_batches_pkg.check_unique_media_ref()-' );
1097: END IF;
1098: --
1099: EXCEPTION
1100: WHEN OTHERS THEN

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

1098: --
1099: EXCEPTION
1100: WHEN OTHERS THEN
1101: IF PG_DEBUG in ('Y', 'C') THEN
1102: arp_util.debug('check_unique_media_ref: ' ||
1103: 'EXCEPTION: arp_rw_batches_pkg.check_unique_media_ref' );
1104: END IF;
1105: RAISE;
1106: END check_unique_media_ref;

Line 1118: | arp_util.debug - debug procedure |

1114: | |
1115: | SCOPE - PRIVATE |
1116: | |
1117: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1118: | arp_util.debug - debug procedure |
1119: | |
1120: | ARGUMENTS : IN: |
1121: | p_media_ref - Media reference |
1122: | OUT: |

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

1131: PROCEDURE validate_args_cu_media_ref(
1132: p_media_ref IN ar_batches.media_reference%TYPE ) IS
1133: BEGIN
1134: IF PG_DEBUG in ('Y', 'C') THEN
1135: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_media_ref()+' );
1136: END IF;
1137: --
1138: IF ( p_media_ref is NULL ) THEN
1139: FND_MESSAGE.set_name ('AR', 'AR_ARGUEMENTS_FAIL' );

Line 1144: arp_util.debug( 'arp_rw_batches_pkg.validate_args_cu_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.validate_args_cu_media_ref()-' );
1145: END IF;
1146: --
1147: EXCEPTION
1148: WHEN OTHERS THEN

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

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

Line 1166: | arp_util.debug - debug procedure |

1162: | |
1163: | SCOPE - PUBLIC |
1164: | |
1165: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1166: | arp_util.debug - debug procedure |
1167: | |
1168: | ARGUMENTS : IN: |
1169: | p_batch_id - Batch Id associated with the batch |
1170: | p_set_of_books_id - set of books id |

Line 1261: | arp_util.debug - debug procedure |

1257: | |
1258: | SCOPE - PUBLIC |
1259: | |
1260: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1261: | arp_util.debug - debug procedure |
1262: | |
1263: | ARGUMENTS : IN: |
1264: | p_batch_id - Batch Id associated with the batch |
1265: | p_module_name - Module name that called this procedure |