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_CR_BATCHES_PKG dependencies on ARP_STANDARD

Line 70: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()+' );

66: l_bat_id ar_batches.batch_id%TYPE;
67: l_row_id VARCHAR2( 20 );
68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()+' );
71: END IF;
72: --
73: ARP_CR_BATCHES_PKG.insert_p( p_bat_rec, l_bat_id );
74: --

Line 84: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()-' );

80: p_bat_id := l_bat_id;
81: p_row_id := l_row_id;
82: --
83: IF PG_DEBUG in ('Y', 'C') THEN
84: arp_standard.debug( 'arp_cr_batches_pkg.insert_p()-' );
85: END IF;
86: EXCEPTION
87: WHEN OTHERS THEN
88: IF PG_DEBUG in ('Y', 'C') THEN

Line 89: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );

85: END IF;
86: EXCEPTION
87: WHEN OTHERS THEN
88: IF PG_DEBUG in ('Y', 'C') THEN
89: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );
90: END IF;
91: RAISE;
92: END insert_p;
93: --

Line 130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );

126: p_bat_id OUT NOCOPY ar_batches.batch_id%TYPE ) IS
127: l_bat_id ar_batches.batch_id%TYPE;
128:
129: BEGIN
130: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.insert_p' );
131: --
132: SELECT ar_batches_s.nextval
133: INTO l_bat_id
134: FROM dual;

Line 257: ,arp_standard.sysparm.org_id /* SSA changes anuj */

253: p_bat_rec.with_recourse_flag,
254: p_bat_rec.auto_print_program_id,
255: p_bat_rec.auto_trans_program_id,
256: p_bat_rec.purged_children_flag
257: ,arp_standard.sysparm.org_id /* SSA changes anuj */
258: );
259: p_bat_id := l_bat_id;
260:
261: /*---------------------------------+

Line 273: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.insert_p' );

269: -- p_mode => 'SINGLE',
270: -- p_key_value => l_bat_id);
271: --}
272: --
273: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.insert_p' );
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );
277: RAISE;

Line 276: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );

272: --
273: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.insert_p' );
274: EXCEPTION
275: WHEN OTHERS THEN
276: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.insert_p' );
277: RAISE;
278: END;
279: --
280: --

Line 284: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()+');

280: --
281: PROCEDURE construct_bat_update_stmt( update_text OUT NOCOPY varchar2) IS
282: --
283: BEGIN
284: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()+');
285: --
286: update_text :=
287: 'update ar_batches
288: SET batch_applied_status =

Line 499: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()-');

495: :ar_flag_dummy, purged_children_flag,
496: :purged_children_flag) ';
497:
498:
499: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()-');
500: --
501: EXCEPTION
502: WHEN OTHERS THEN
503: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg .construct_bat_update_stmt()');

Line 503: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg .construct_bat_update_stmt()');

499: arp_standard.debug('arp_cr_batches_pkg.construct_bat_update_stmt()-');
500: --
501: EXCEPTION
502: WHEN OTHERS THEN
503: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg .construct_bat_update_stmt()');
504: RAISE;
505: --
506: END;
507: --

Line 516: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()+');

512: IS
513: --
514: BEGIN
515: --
516: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()+');
517: --
518: --
519: /*------------------+
520: | Dummy constants |

Line 536: arp_standard.debug('after duummy');

532: AR_NUMBER_DUMMY);
533: --
534: dbms_sql.bind_variable(p_update_cursor, ':ar_date_dummy',
535: AR_DATE_DUMMY);
536: arp_standard.debug('after duummy');
537: --
538: /*------------------+
539: | WHO variables |
540: +------------------*/

Line 564: arp_standard.debug('after who');

560: dbms_sql.bind_variable(p_update_cursor, ':pg_last_update_login',
561: pg_last_update_login);
562: dbms_sql.bind_variable(p_update_cursor, ':pg_set_of_books_id',
563: arp_global.set_of_books_id);
564: arp_standard.debug('after who');
565: /*----------------------------------------------+
566: | Bind variables for all columns in the table |
567: +----------------------------------------------*/
568: --

Line 715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');

711: --
712: dbms_sql.bind_variable(p_update_cursor, ':purged_children_flag',
713: p_bat_rec.purged_children_flag);
714: --
715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');
716: --
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');

Line 719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');

715: arp_standard.debug('arp_cr_batches_pkg.bind_bat_variables()-');
716: --
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');
720: arp_standard.debug('Error at character: ' ||
721: to_char(dbms_sql.last_error_position));
722:
723: RAISE;

Line 720: arp_standard.debug('Error at character: ' ||

716: --
717: EXCEPTION
718: WHEN OTHERS THEN
719: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.bind_bat_variables()');
720: arp_standard.debug('Error at character: ' ||
721: to_char(dbms_sql.last_error_position));
722:
723: RAISE;
724: --

Line 741: arp_standard.debug('arp_cr_batches_pkg.generic_update()+');

737: ar_batch_array dbms_sql.number_table;
738:
739: --
740: BEGIN
741: arp_standard.debug('arp_cr_batches_pkg.generic_update()+');
742: --
743: /*--------------------------------------------------------------+
744: | If this update statement has not already been parsed, |
745: | construct the statement and parse it. |

Line 768: arp_standard.debug('after l_update_statement');

764: l_update_statement := l_update_statement ||
765: ' RETURNING batch_id INTO :ar_batch_key_value ';
766:
767: --
768: arp_standard.debug('after l_update_statement');
769: /*-----------------------------------------------+
770: | Parse, bind, execute and close the statement |
771: +-----------------------------------------------*/
772: --

Line 778: arp_standard.debug('after dbms_sql');

774: l_update_statement,
775: dbms_sql.v7);
776: --
777:
778: arp_standard.debug('after dbms_sql');
779:
780: end if;
781: --
782: arp_cr_batches_pkg.bind_bat_variables(p_update_cursor, p_bat_rec);

Line 785: arp_standard.debug('after .bind_app');

781: --
782: arp_cr_batches_pkg.bind_bat_variables(p_update_cursor, p_bat_rec);
783: --
784: --
785: arp_standard.debug('after .bind_app');
786: /*-----------------------------------------+
787: | Bind the variables in the where clause |
788: +-----------------------------------------*/
789: --

Line 795: arp_standard.debug('after bind_variable ');

791: then
792: dbms_sql.bind_variable(p_update_cursor, ':where_1',
793: p_where1);
794: end if;
795: arp_standard.debug('after bind_variable ');
796: --
797: /*---------------------------+
798: | Bind output variable |
799: +---------------------------*/

Line 805: arp_standard.debug( to_char(l_count) || ' rows updated');

801: ar_batch_array);
802:
803: l_count := dbms_sql.execute(p_update_cursor);
804: --
805: arp_standard.debug( to_char(l_count) || ' rows updated');
806: --
807: /*------------------------------------------+
808: | get RETURNING COLUMN into OUT NOCOPY bind array |
809: +------------------------------------------*/

Line 821: arp_standard.debug('after l_count = 0');

817: +------------------------------------------------------------*/
818: --
819: if (l_count = 0)
820: then raise NO_DATA_FOUND;
821: arp_standard.debug('after l_count = 0');
822: end if;
823: --
824: --{BUG#4301323
825: -- arp_standard.debug('before loop for MRC processing...');

Line 825: -- arp_standard.debug('before loop for MRC processing...');

821: arp_standard.debug('after l_count = 0');
822: end if;
823: --
824: --{BUG#4301323
825: -- arp_standard.debug('before loop for MRC processing...');
826: -- FOR I in ar_batch_array.FIRST .. ar_batch_array.LAST LOOP
827: /*---------------------------------------------+
828: | call mrc engine to update AR_MC_BATCHES |
829: +---------------------------------------------*/

Line 830: -- arp_standard.debug('before calling maintain_mrc ');

826: -- FOR I in ar_batch_array.FIRST .. ar_batch_array.LAST LOOP
827: /*---------------------------------------------+
828: | call mrc engine to update AR_MC_BATCHES |
829: +---------------------------------------------*/
830: -- arp_standard.debug('before calling maintain_mrc ');
831: -- arp_standard.debug('batch array('||to_char(I) || ') = ' || to_char(ar_batch_array(I)));
832:
833: -- ar_mrc_engine.maintain_mrc_data(
834: -- p_event_mode => 'UPDATE',

Line 831: -- arp_standard.debug('batch array('||to_char(I) || ') = ' || to_char(ar_batch_array(I)));

827: /*---------------------------------------------+
828: | call mrc engine to update AR_MC_BATCHES |
829: +---------------------------------------------*/
830: -- arp_standard.debug('before calling maintain_mrc ');
831: -- arp_standard.debug('batch array('||to_char(I) || ') = ' || to_char(ar_batch_array(I)));
832:
833: -- ar_mrc_engine.maintain_mrc_data(
834: -- p_event_mode => 'UPDATE',
835: -- p_table_name => 'AR_BATCHES',

Line 841: arp_standard.debug('arp_cr_batches_pkg.generic_update()-');

837: -- p_key_value => ar_batch_array(I));
838: -- END LOOP;
839: --}
840: --
841: arp_standard.debug('arp_cr_batches_pkg.generic_update()-');
842: --
843: EXCEPTION
844: WHEN OTHERS THEN
845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()

Line 845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()

841: arp_standard.debug('arp_cr_batches_pkg.generic_update()-');
842: --
843: EXCEPTION
844: WHEN OTHERS THEN
845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()
846: ');
847: arp_standard.debug(l_update_statement);
848: arp_standard.debug('Error at character: ' ||
849: to_char(dbms_sql.last_error_position));

Line 847: arp_standard.debug(l_update_statement);

843: EXCEPTION
844: WHEN OTHERS THEN
845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()
846: ');
847: arp_standard.debug(l_update_statement);
848: arp_standard.debug('Error at character: ' ||
849: to_char(dbms_sql.last_error_position));
850: --arp_standard.debug('ERROR MESSAGE: ' ||
851: -- sqlerrm);

Line 848: arp_standard.debug('Error at character: ' ||

844: WHEN OTHERS THEN
845: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.generic_update()
846: ');
847: arp_standard.debug(l_update_statement);
848: arp_standard.debug('Error at character: ' ||
849: to_char(dbms_sql.last_error_position));
850: --arp_standard.debug('ERROR MESSAGE: ' ||
851: -- sqlerrm);
852: RAISE;

Line 850: --arp_standard.debug('ERROR MESSAGE: ' ||

846: ');
847: arp_standard.debug(l_update_statement);
848: arp_standard.debug('Error at character: ' ||
849: to_char(dbms_sql.last_error_position));
850: --arp_standard.debug('ERROR MESSAGE: ' ||
851: -- sqlerrm);
852: RAISE;
853: END;
854: --

Line 862: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()+');

858: IS
859: --
860: BEGIN
861: --
862: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()+');
863: --
864: p_bat_rec.batch_applied_status := AR_TEXT_DUMMY;
865: p_bat_rec.batch_date := AR_DATE_DUMMY;
866: p_bat_rec.batch_source_id := AR_NUMBER_DUMMY;

Line 914: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()-');

910: p_bat_rec.auto_trans_program_id := AR_NUMBER_DUMMY;
911: p_bat_rec.purged_children_flag := AR_FLAG_DUMMY;
912: --
913:
914: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()-');
915: --
916: EXCEPTION
917: WHEN OTHERS THEN
918: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.set_to_dummy()');

Line 918: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.set_to_dummy()');

914: arp_standard.debug('arp_cr_batches_pkg.set_to_dummy()-');
915: --
916: EXCEPTION
917: WHEN OTHERS THEN
918: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.set_to_dummy()');
919: RAISE;
920: --
921: END;
922: --

Line 933: arp_standard.debug('arp_cr_batches_pkg.update_p()+ ');

929: ar_batches.batch_id%TYPE) IS
930: --
931: BEGIN
932: --
933: arp_standard.debug('arp_cr_batches_pkg.update_p()+ ');
934: --
935: --
936: arp_cr_batches_pkg.generic_update( pg_cursor1,
937: ' WHERE batch_id = :where_1',

Line 941: arp_standard.debug('arp_cr_batches_pkg.update_p()- ' ||

937: ' WHERE batch_id = :where_1',
938: p_batch_id,
939: p_bat_rec);
940: --
941: arp_standard.debug('arp_cr_batches_pkg.update_p()- ' ||
942: to_char(sysdate, 'HH:MI:SS'));
943: --
944: --
945: EXCEPTION

Line 947: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.update_p()');

943: --
944: --
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_standard.debug('EXCEPTION: arp_cr_batches_pkg.update_p()');
948: RAISE;
949: END;
950: --
951: /*===========================================================================+

Line 974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );

970: | |
971: +===========================================================================*/
972: PROCEDURE update_p( p_bat_rec IN ar_batches%ROWTYPE ) IS
973: BEGIN
974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );
975: --
976: update_p( p_bat_rec, p_bat_rec.batch_id );
977: --
978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );

Line 978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );

974: arp_standard.debug( ' arp_cr_batches_pkg.update_p()+ ' );
975: --
976: update_p( p_bat_rec, p_bat_rec.batch_id );
977: --
978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );
979: EXCEPTION
980: WHEN OTHERS THEN
981: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.update_p' );
982: RAISE;

Line 981: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.update_p' );

977: --
978: arp_standard.debug( 'arp_cr_batches_pkg.update_p()- ' );
979: EXCEPTION
980: WHEN OTHERS THEN
981: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.update_p' );
982: RAISE;
983: END;
984: --
985: /*===========================================================================+

Line 1009: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.delete_p' );

1005: +===========================================================================*/
1006: PROCEDURE delete_p(
1007: p_bat_id IN ar_batches.batch_id%TYPE ) IS
1008: BEGIN
1009: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.delete_p' );
1010: --
1011: DELETE FROM ar_batches
1012: WHERE batch_id = p_bat_id;
1013:

Line 1026: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.delete_p' );

1022: -- p_mode => 'SINGLE',
1023: -- p_key_value => p_bat_id);
1024: --}
1025: --
1026: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.delete_p' );
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.delete_p' );
1030: RAISE;

Line 1029: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.delete_p' );

1025: --
1026: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.delete_p' );
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.delete_p' );
1030: RAISE;
1031: END;
1032: --
1033: /*===========================================================================+

Line 1219: arp_standard.debug('lock_p: ' || 'set_of_books_id: ' || recinfo.set_of_books_id || ' -- ' || p_set_of_books_id);

1215: ) then
1216: return;
1217: else
1218: IF PG_DEBUG in ('Y', 'C') THEN
1219: arp_standard.debug('lock_p: ' || 'set_of_books_id: ' || recinfo.set_of_books_id || ' -- ' || p_set_of_books_id);
1220: arp_standard.debug('lock_p: ' || 'batch_id: ' || recinfo.batch_id || ' -- ' || p_batch_id);
1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||
1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);

Line 1220: arp_standard.debug('lock_p: ' || 'batch_id: ' || recinfo.batch_id || ' -- ' || p_batch_id);

1216: return;
1217: else
1218: IF PG_DEBUG in ('Y', 'C') THEN
1219: arp_standard.debug('lock_p: ' || 'set_of_books_id: ' || recinfo.set_of_books_id || ' -- ' || p_set_of_books_id);
1220: arp_standard.debug('lock_p: ' || 'batch_id: ' || recinfo.batch_id || ' -- ' || p_batch_id);
1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||
1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);

Line 1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||

1217: else
1218: IF PG_DEBUG in ('Y', 'C') THEN
1219: arp_standard.debug('lock_p: ' || 'set_of_books_id: ' || recinfo.set_of_books_id || ' -- ' || p_set_of_books_id);
1220: arp_standard.debug('lock_p: ' || 'batch_id: ' || recinfo.batch_id || ' -- ' || p_batch_id);
1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||
1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);

Line 1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);

1219: arp_standard.debug('lock_p: ' || 'set_of_books_id: ' || recinfo.set_of_books_id || ' -- ' || p_set_of_books_id);
1220: arp_standard.debug('lock_p: ' || 'batch_id: ' || recinfo.batch_id || ' -- ' || p_batch_id);
1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||
1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);

Line 1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);

1220: arp_standard.debug('lock_p: ' || 'batch_id: ' || recinfo.batch_id || ' -- ' || p_batch_id);
1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||
1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);

Line 1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);

1221: arp_standard.debug('lock_p: ' || 'batch_applied_status: ' || recinfo.batch_applied_status || ' -- ' ||
1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);

Line 1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);

1222: p_batch_applied_status);
1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);

Line 1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);

1223: arp_standard.debug('lock_p: ' || 'batch_date: ' || recinfo.batch_date || ' -- ' || p_batch_date);
1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);

Line 1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);

1224: arp_standard.debug('lock_p: ' || 'batch_source_id: ' || recinfo.batch_source_id || ' -- ' || p_batch_source_id);
1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||

Line 1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);

1225: arp_standard.debug('lock_p: ' || 'comments: ' || recinfo.comments || ' -- ' || p_comments);
1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);

Line 1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);

1226: arp_standard.debug('lock_p: ' || 'control_count: ' || recinfo.control_count || ' -- ' || p_control_count);
1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);

Line 1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);

1227: arp_standard.debug('lock_p: ' || 'exchange_date: ' || recinfo.exchange_date || ' -- ' || p_exchange_date);
1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);
1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);

Line 1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||

1228: arp_standard.debug('lock_p: ' || 'exchange_rate: ' || recinfo.exchange_rate || ' -- ' || p_exchange_rate);
1229: arp_standard.debug('lock_p: ' || 'exchange_Rate_type: ' || recinfo.exchange_Rate_type||' -- '||p_exchange_Rate_type);
1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);
1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);
1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);

Line 1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);

1230: arp_standard.debug('lock_p: ' || 'lockbox_batch_name: ' || recinfo.lockbox_batch_name||' -- '||p_lockbox_batch_name);
1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);
1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);
1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);
1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);

Line 1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);

1231: arp_standard.debug('lock_p: ' || 'media_reference: ' || recinfo.media_reference || ' -- ' || p_media_reference);
1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);
1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);
1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);
1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);

Line 1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);

1232: arp_standard.debug('lock_p: ' || 'operation_request_id: ' || recinfo.operation_request_id || ' -- ' ||
1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);
1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);
1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);
1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);

Line 1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||

1233: p_operation_request_id);
1234: arp_standard.debug('lock_p: ' || 'receipt_class_id: ' || recinfo.receipt_class_id || ' -- ' || p_receipt_class_id);
1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);
1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);
1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);

Line 1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);

1235: arp_standard.debug('lock_p: ' || 'receipt_method_id: ' || recinfo.receipt_method_id || ' -- ' || p_receipt_method_id);
1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);
1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);

Line 1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);

1236: arp_standard.debug('lock_p: ' || 'remit_method_code: ' || recinfo.remit_method_code || ' -- ' || p_remit_method_code);
1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);

Line 1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);

1237: arp_standard.debug('lock_p: ' || 'remit_bank_acct_use_id: ' || recinfo.remit_bank_acct_use_id || ' -- ' ||
1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);

Line 1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);

1238: p_remittance_bank_account_id);
1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);

Line 1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);

1239: arp_standard.debug('lock_p: ' || 'transmission_id: ' || recinfo.transmission_id || ' -- ' || p_transmission_id);
1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);

Line 1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);

1240: arp_standard.debug('lock_p: ' || 'request_id: ' || recinfo.request_id || ' -- ' || p_request_id);
1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);

Line 1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);

1241: arp_standard.debug('lock_p: ' || 'bank_deposit_number: ' || recinfo.bank_deposit_number||' -- '||p_bank_deposit_number);
1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);

Line 1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);

1242: arp_standard.debug('lock_p: ' || 'attribute_category: ' || recinfo.attribute_category||' -- '||p_attribute_category);
1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);

Line 1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);

1243: arp_standard.debug('lock_p: ' || 'attribute1: ' || recinfo.attribute1 || ' -- ' || p_attribute1);
1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);

Line 1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);

1244: arp_standard.debug('lock_p: ' || 'attribute2: ' || recinfo.attribute2 || ' -- ' || p_attribute2);
1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);

Line 1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);

1245: arp_standard.debug('lock_p: ' || 'attribute3: ' || recinfo.attribute3 || ' -- ' || p_attribute3);
1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);

Line 1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);

1246: arp_standard.debug('lock_p: ' || 'attribute4: ' || recinfo.attribute4 || ' -- ' || p_attribute4);
1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);

Line 1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);

1247: arp_standard.debug('lock_p: ' || 'attribute5: ' || recinfo.attribute5 || ' -- ' || p_attribute5);
1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);

Line 1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);

1248: arp_standard.debug('lock_p: ' || 'attribute6: ' || recinfo.attribute6 || ' -- ' || p_attribute6);
1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);
1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);

Line 1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);

1249: arp_standard.debug('lock_p: ' || 'attribute7: ' || recinfo.attribute7 || ' -- ' || p_attribute7);
1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);
1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);
1257: arp_standard.debug('lock_p: ' || 'attribute15: ' || recinfo.attribute15 || ' -- ' || p_attribute15);

Line 1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);

1250: arp_standard.debug('lock_p: ' || 'attribute8: ' || recinfo.attribute8 || ' -- ' || p_attribute8);
1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);
1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);
1257: arp_standard.debug('lock_p: ' || 'attribute15: ' || recinfo.attribute15 || ' -- ' || p_attribute15);
1258: END IF;

Line 1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);

1251: arp_standard.debug('lock_p: ' || 'attribute9: ' || recinfo.attribute9 || ' -- ' || p_attribute9);
1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);
1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);
1257: arp_standard.debug('lock_p: ' || 'attribute15: ' || recinfo.attribute15 || ' -- ' || p_attribute15);
1258: END IF;
1259:

Line 1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);

1252: arp_standard.debug('lock_p: ' || 'attribute10: ' || recinfo.attribute10 || ' -- ' || p_attribute10);
1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);
1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);
1257: arp_standard.debug('lock_p: ' || 'attribute15: ' || recinfo.attribute15 || ' -- ' || p_attribute15);
1258: END IF;
1259:
1260: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

Line 1257: arp_standard.debug('lock_p: ' || 'attribute15: ' || recinfo.attribute15 || ' -- ' || p_attribute15);

1253: arp_standard.debug('lock_p: ' || 'attribute11: ' || recinfo.attribute11 || ' -- ' || p_attribute11);
1254: arp_standard.debug('lock_p: ' || 'attribute12: ' || recinfo.attribute12 || ' -- ' || p_attribute12);
1255: arp_standard.debug('lock_p: ' || 'attribute13: ' || recinfo.attribute13 || ' -- ' || p_attribute13);
1256: arp_standard.debug('lock_p: ' || 'attribute14: ' || recinfo.attribute14 || ' -- ' || p_attribute14);
1257: arp_standard.debug('lock_p: ' || 'attribute15: ' || recinfo.attribute15 || ' -- ' || p_attribute15);
1258: END IF;
1259:
1260: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1261: APP_EXCEPTION.Raise_Exception;

Line 1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );

1264: --
1265: PROCEDURE nowaitlock_p( p_bat_id IN ar_batches.batch_id%TYPE ) IS
1266: l_bat_id ar_batches.batch_id%TYPE;
1267: BEGIN
1268: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.nowaitlock_p' );
1269: --
1270: SELECT batch_id
1271: INTO l_bat_id
1272: FROM ar_batches

Line 1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );

1272: FROM ar_batches
1273: WHERE batch_id = p_bat_id
1274: FOR UPDATE OF STATUS NOWAIT;
1275: --
1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_p' );
1280: RAISE;

Line 1279: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_p' );

1275: --
1276: arp_standard.debug( '<<<<<<<< arp_cr_batches_pkg.nowaitlock_p' );
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_p' );
1280: RAISE;
1281: END;
1282: --
1283: /*===========================================================================+

Line 1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );

1305: +===========================================================================*/
1306: PROCEDURE fetch_p( p_batch_id IN ar_batches.batch_id%TYPE,
1307: p_batch_rec OUT NOCOPY ar_batches%ROWTYPE ) IS
1308: BEGIN
1309: arp_standard.debug( '>>>>>>>> arp_cr_batches_pkg.fetch_p' );
1310: --
1311: SELECT *
1312: INTO p_batch_rec
1313: FROM ar_batches

Line 1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );

1312: INTO p_batch_rec
1313: FROM ar_batches
1314: WHERE batch_id = p_batch_id;
1315: --
1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );
1317: EXCEPTION
1318: --
1319: WHEN OTHERS THEN
1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );

Line 1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );

1316: arp_standard.debug( '<<<<<<<<< arp_cr_batches_pkg.fetch_p' );
1317: EXCEPTION
1318: --
1319: WHEN OTHERS THEN
1320: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.fetch_p' );
1321: RAISE;
1322: END;
1323: --
1324: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS

Line 1327: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()+' );

1323: --
1324: PROCEDURE lock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS
1325: BEGIN
1326: IF PG_DEBUG in ('Y', 'C') THEN
1327: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()+' );
1328: END IF;
1329: --
1330: SELECT *
1331: INTO p_batch_rec

Line 1337: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()-' );

1333: WHERE batch_id = p_batch_rec.batch_id
1334: FOR UPDATE OF STATUS;
1335: --
1336: IF PG_DEBUG in ('Y', 'C') THEN
1337: arp_standard.debug( 'arp_cr_batches_pkg.lock_fetch_p()-' );
1338: END IF;
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: IF PG_DEBUG in ('Y', 'C') THEN

Line 1342: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.lock_fetch_p' );

1338: END IF;
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: IF PG_DEBUG in ('Y', 'C') THEN
1342: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.lock_fetch_p' );
1343: END IF;
1344: RAISE;
1345: END lock_fetch_p;
1346: --

Line 1351: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()+' );

1347: --
1348: PROCEDURE nowaitlock_fetch_p( p_batch_rec IN OUT NOCOPY ar_batches%ROWTYPE ) IS
1349: BEGIN
1350: IF PG_DEBUG in ('Y', 'C') THEN
1351: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()+' );
1352: END IF;
1353: --
1354: SELECT *
1355: INTO p_batch_rec

Line 1361: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()-' );

1357: WHERE batch_id = p_batch_rec.batch_id
1358: FOR UPDATE OF STATUS NOWAIT;
1359: --
1360: IF PG_DEBUG in ('Y', 'C') THEN
1361: arp_standard.debug( 'arp_cr_batches_pkg.nowaitlock_fetch_p()-' );
1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF PG_DEBUG in ('Y', 'C') THEN

Line 1366: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_fetch_p' );

1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF PG_DEBUG in ('Y', 'C') THEN
1366: arp_standard.debug( 'EXCEPTION: arp_cr_batches_pkg.nowaitlock_fetch_p' );
1367: END IF;
1368: RAISE;
1369: END nowaitlock_fetch_p;
1370: --