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

Line 53: | arp_util.debug |

49: | SCOPE - PRIVATE |
50: | |
51: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
52: | dbms_sql.bind_variable |
53: | arp_util.debug |
54: | |
55: | ARGUMENTS : IN: |
56: | p_update_cursor - ID of the update cursor |
57: | p_adj_rec - ar_adjustments record |

Line 101: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()+');

97: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;
98:
99: BEGIN
100:
101: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()+');
102:
103:
104: /*----------------------------------------+
105: | Rounding and exchange rate variables |

Line 370: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()-');

366:
367: dbms_sql.bind_variable(p_update_cursor, ':request_id',
368: p_adj_rec.request_id);
369:
370: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()-');
371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: arp_util.debug('EXCEPTION: arp_adjustments_pkg.bind_adj_variables()');

Line 374: arp_util.debug('EXCEPTION: arp_adjustments_pkg.bind_adj_variables()');

370: arp_util.debug('arp_adjustments_pkg.bind_adj_variables()-');
371:
372: EXCEPTION
373: WHEN OTHERS THEN
374: arp_util.debug('EXCEPTION: arp_adjustments_pkg.bind_adj_variables()');
375: RAISE;
376:
377: END;
378:

Line 392: | arp_util.debug |

388: | |
389: | SCOPE - PRIVATE |
390: | |
391: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
392: | arp_util.debug |
393: | |
394: | ARGUMENTS : IN: |
395: | None. |
396: | OUT: |

Line 420: arp_util.debug('arp_adjustments_pkg.construct_adj_update_stmt()+');

416:
417:
418: BEGIN
419:
420: arp_util.debug('arp_adjustments_pkg.construct_adj_update_stmt()+');
421:
422: update_text :=
423: 'UPDATE ar_adjustments
424: SET adjustment_id =

Line 700: arp_util.debug('arp_adjustments_pkg.construct_adj_update_stmt()-');

696: DECODE(:request_id,
697: :ar_number_dummy, request_id,
698: :request_id)';
699:
700: arp_util.debug('arp_adjustments_pkg.construct_adj_update_stmt()-');
701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: arp_util.debug('EXCEPTION: arp_adjustments_pkg.construct_adj_update_stmt()');

Line 704: arp_util.debug('EXCEPTION: arp_adjustments_pkg.construct_adj_update_stmt()');

700: arp_util.debug('arp_adjustments_pkg.construct_adj_update_stmt()-');
701:
702: EXCEPTION
703: WHEN OTHERS THEN
704: arp_util.debug('EXCEPTION: arp_adjustments_pkg.construct_adj_update_stmt()');
705: RAISE;
706:
707: END;
708:

Line 722: | arp_util.debug |

718: | |
719: | SCOPE - PRIVATE |
720: | |
721: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
722: | arp_util.debug |
723: | dbms_sql.open_cursor |
724: | dbms_sql.parse |
725: | dbms_sql.execute |
726: | dbms_sql.close_cursor |

Line 760: arp_util.debug('arp_adjustments_pkg.generic_update()+');

756: l_adj_key_value_list gl_ca_utility_pkg.r_key_value_arr;
757: adj_array dbms_sql.number_table;
758:
759: BEGIN
760: arp_util.debug('arp_adjustments_pkg.generic_update()+');
761:
762: arp_util.debug('');
763: arp_util.debug('-------- parameters for generic_update() ------');
764:

Line 762: arp_util.debug('');

758:
759: BEGIN
760: arp_util.debug('arp_adjustments_pkg.generic_update()+');
761:
762: arp_util.debug('');
763: arp_util.debug('-------- parameters for generic_update() ------');
764:
765: arp_util.debug('p_update_cursor = ' || p_update_cursor);
766: arp_util.debug('p_where_clause = ' || p_where_clause);

Line 763: arp_util.debug('-------- parameters for generic_update() ------');

759: BEGIN
760: arp_util.debug('arp_adjustments_pkg.generic_update()+');
761:
762: arp_util.debug('');
763: arp_util.debug('-------- parameters for generic_update() ------');
764:
765: arp_util.debug('p_update_cursor = ' || p_update_cursor);
766: arp_util.debug('p_where_clause = ' || p_where_clause);
767: arp_util.debug('p_where1 = ' || p_where1);

Line 765: arp_util.debug('p_update_cursor = ' || p_update_cursor);

761:
762: arp_util.debug('');
763: arp_util.debug('-------- parameters for generic_update() ------');
764:
765: arp_util.debug('p_update_cursor = ' || p_update_cursor);
766: arp_util.debug('p_where_clause = ' || p_where_clause);
767: arp_util.debug('p_where1 = ' || p_where1);
768: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
769:

Line 766: arp_util.debug('p_where_clause = ' || p_where_clause);

762: arp_util.debug('');
763: arp_util.debug('-------- parameters for generic_update() ------');
764:
765: arp_util.debug('p_update_cursor = ' || p_update_cursor);
766: arp_util.debug('p_where_clause = ' || p_where_clause);
767: arp_util.debug('p_where1 = ' || p_where1);
768: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
769:
770: arp_adjustments_pkg.display_adj_rec(p_adj_rec);

Line 767: arp_util.debug('p_where1 = ' || p_where1);

763: arp_util.debug('-------- parameters for generic_update() ------');
764:
765: arp_util.debug('p_update_cursor = ' || p_update_cursor);
766: arp_util.debug('p_where_clause = ' || p_where_clause);
767: arp_util.debug('p_where1 = ' || p_where1);
768: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
769:
770: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
771:

Line 768: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);

764:
765: arp_util.debug('p_update_cursor = ' || p_update_cursor);
766: arp_util.debug('p_where_clause = ' || p_where_clause);
767: arp_util.debug('p_where1 = ' || p_where1);
768: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
769:
770: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
771:
772: /*--------------------------------------------------------------+

Line 828: arp_util.debug( to_char(l_count) || ' rows updated');

824: p_where1);
825:
826: l_count := dbms_sql.execute(p_update_cursor);
827:
828: arp_util.debug( to_char(l_count) || ' rows updated');
829:
830: /*------------------------------------------+
831: | get RETURNING COLUMN into OUT NOCOPY bind array |
832: +------------------------------------------*/

Line 858: arp_util.debug('arp_adjustments_pkg.generic_update()-');

854: -- p_key_value => adj_array(I));
855: -- END LOOP;
856:
857:
858: arp_util.debug('arp_adjustments_pkg.generic_update()-');
859:
860: EXCEPTION
861: WHEN OTHERS THEN
862: arp_util.debug('EXCEPTION: arp_adjustments_pkg.generic_update()');

Line 862: arp_util.debug('EXCEPTION: arp_adjustments_pkg.generic_update()');

858: arp_util.debug('arp_adjustments_pkg.generic_update()-');
859:
860: EXCEPTION
861: WHEN OTHERS THEN
862: arp_util.debug('EXCEPTION: arp_adjustments_pkg.generic_update()');
863:
864: arp_util.debug('');
865: arp_util.debug('-------- parameters for generic_update() ------');
866:

Line 864: arp_util.debug('');

860: EXCEPTION
861: WHEN OTHERS THEN
862: arp_util.debug('EXCEPTION: arp_adjustments_pkg.generic_update()');
863:
864: arp_util.debug('');
865: arp_util.debug('-------- parameters for generic_update() ------');
866:
867: arp_util.debug('p_update_cursor = ' || p_update_cursor);
868: arp_util.debug('p_where_clause = ' || p_where_clause);

Line 865: arp_util.debug('-------- parameters for generic_update() ------');

861: WHEN OTHERS THEN
862: arp_util.debug('EXCEPTION: arp_adjustments_pkg.generic_update()');
863:
864: arp_util.debug('');
865: arp_util.debug('-------- parameters for generic_update() ------');
866:
867: arp_util.debug('p_update_cursor = ' || p_update_cursor);
868: arp_util.debug('p_where_clause = ' || p_where_clause);
869: arp_util.debug('p_where1 = ' || p_where1);

Line 867: arp_util.debug('p_update_cursor = ' || p_update_cursor);

863:
864: arp_util.debug('');
865: arp_util.debug('-------- parameters for generic_update() ------');
866:
867: arp_util.debug('p_update_cursor = ' || p_update_cursor);
868: arp_util.debug('p_where_clause = ' || p_where_clause);
869: arp_util.debug('p_where1 = ' || p_where1);
870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
871:

Line 868: arp_util.debug('p_where_clause = ' || p_where_clause);

864: arp_util.debug('');
865: arp_util.debug('-------- parameters for generic_update() ------');
866:
867: arp_util.debug('p_update_cursor = ' || p_update_cursor);
868: arp_util.debug('p_where_clause = ' || p_where_clause);
869: arp_util.debug('p_where1 = ' || p_where1);
870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
871:
872: arp_util.debug(l_update_statement);

Line 869: arp_util.debug('p_where1 = ' || p_where1);

865: arp_util.debug('-------- parameters for generic_update() ------');
866:
867: arp_util.debug('p_update_cursor = ' || p_update_cursor);
868: arp_util.debug('p_where_clause = ' || p_where_clause);
869: arp_util.debug('p_where1 = ' || p_where1);
870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
871:
872: arp_util.debug(l_update_statement);
873: arp_util.debug('Error at character: ' ||

Line 872: arp_util.debug(l_update_statement);

868: arp_util.debug('p_where_clause = ' || p_where_clause);
869: arp_util.debug('p_where1 = ' || p_where1);
870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
871:
872: arp_util.debug(l_update_statement);
873: arp_util.debug('Error at character: ' ||
874: to_char(dbms_sql.last_error_position));
875: RAISE;
876: END;

Line 873: arp_util.debug('Error at character: ' ||

869: arp_util.debug('p_where1 = ' || p_where1);
870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
871:
872: arp_util.debug(l_update_statement);
873: arp_util.debug('Error at character: ' ||
874: to_char(dbms_sql.last_error_position));
875: RAISE;
876: END;
877:

Line 895: | arp_util.debug |

891: | |
892: | SCOPE - PUBLIC |
893: | |
894: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
895: | arp_util.debug |
896: | |
897: | ARGUMENTS : IN: |
898: | None |
899: | OUT: |

Line 915: arp_util.debug('arp_adjustments_pkg.set_to_dummy()+');

911: PROCEDURE set_to_dummy( p_adj_rec OUT NOCOPY ar_adjustments%rowtype) IS
912:
913: BEGIN
914:
915: arp_util.debug('arp_adjustments_pkg.set_to_dummy()+');
916:
917: p_adj_rec.adjustment_id := AR_NUMBER_DUMMY;
918: p_adj_rec.amount := AR_NUMBER_DUMMY;
919: p_adj_rec.acctd_amount := AR_NUMBER_DUMMY;

Line 980: arp_util.debug('arp_adjustments_pkg.set_to_dummy()-');

976: p_adj_rec.program_id := AR_NUMBER_DUMMY;
977: p_adj_rec.program_update_date := AR_DATE_DUMMY;
978: p_adj_rec.request_id := AR_NUMBER_DUMMY;
979:
980: arp_util.debug('arp_adjustments_pkg.set_to_dummy()-');
981:
982: EXCEPTION
983: WHEN OTHERS THEN
984: arp_util.debug('EXCEPTION: arp_adjustments_pkg.set_to_dummy()');

Line 984: arp_util.debug('EXCEPTION: arp_adjustments_pkg.set_to_dummy()');

980: arp_util.debug('arp_adjustments_pkg.set_to_dummy()-');
981:
982: EXCEPTION
983: WHEN OTHERS THEN
984: arp_util.debug('EXCEPTION: arp_adjustments_pkg.set_to_dummy()');
985: RAISE;
986:
987: END;
988:

Line 1001: | arp_util.debug |

997: | |
998: | SCOPE - PUBLIC |
999: | |
1000: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1001: | arp_util.debug |
1002: | |
1003: | ARGUMENTS : IN: |
1004: | p_adjustment_id - identifies the row to lock |
1005: | OUT: |

Line 1024: arp_util.debug('arp_adjustments_pkg.lock_p()+');

1020:
1021: l_adjustment_id ar_adjustments.adjustment_id%type;
1022:
1023: BEGIN
1024: arp_util.debug('arp_adjustments_pkg.lock_p()+');
1025:
1026:
1027: SELECT adjustment_id
1028: INTO l_adjustment_id

Line 1033: arp_util.debug('arp_adjustments_pkg.lock_p()-');

1029: FROM ar_adjustments
1030: WHERE adjustment_id = p_adjustment_id
1031: FOR UPDATE OF adjustment_id NOWAIT;
1032:
1033: arp_util.debug('arp_adjustments_pkg.lock_p()-');
1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_p' );

Line 1037: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_p' );

1033: arp_util.debug('arp_adjustments_pkg.lock_p()-');
1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_p' );
1038: RAISE;
1039: END;
1040:
1041: /*===========================================================================+

Line 1052: | arp_util.debug |

1048: | |
1049: | SCOPE - PUBLIC |
1050: | |
1051: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1052: | arp_util.debug |
1053: | |
1054: | ARGUMENTS : IN: |
1055: | p_customer_trx_id - identifies the rows to lock |
1056: | OUT: |

Line 1080: arp_util.debug('arp_adjustments_pkg.lock_f_ct_id()+');

1076: FOR UPDATE OF adjustment_id NOWAIT;
1077:
1078:
1079: BEGIN
1080: arp_util.debug('arp_adjustments_pkg.lock_f_ct_id()+');
1081:
1082: OPEN lock_c;
1083: CLOSE lock_c;
1084:

Line 1085: arp_util.debug('arp_adjustments_pkg.lock_f_ct_id()-');

1081:
1082: OPEN lock_c;
1083: CLOSE lock_c;
1084:
1085: arp_util.debug('arp_adjustments_pkg.lock_f_ct_id()-');
1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ct_id' );

Line 1089: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ct_id' );

1085: arp_util.debug('arp_adjustments_pkg.lock_f_ct_id()-');
1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ct_id' );
1090: RAISE;
1091: END;
1092:
1093: /*===========================================================================+

Line 1104: | arp_util.debug |

1100: | |
1101: | SCOPE - PUBLIC |
1102: | |
1103: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1104: | arp_util.debug |
1105: | |
1106: | ARGUMENTS : IN: |
1107: | p_subsequent_trx_id - identifies the rows to lock |
1108: | OUT: |

Line 1132: arp_util.debug('arp_adjustments_pkg.lock_f_st_id()+');

1128: FOR UPDATE OF adjustment_id NOWAIT;
1129:
1130:
1131: BEGIN
1132: arp_util.debug('arp_adjustments_pkg.lock_f_st_id()+');
1133:
1134: OPEN lock_c;
1135: CLOSE lock_c;
1136:

Line 1137: arp_util.debug('arp_adjustments_pkg.lock_f_st_id()-');

1133:
1134: OPEN lock_c;
1135: CLOSE lock_c;
1136:
1137: arp_util.debug('arp_adjustments_pkg.lock_f_st_id()-');
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_st_id' );

Line 1141: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_st_id' );

1137: arp_util.debug('arp_adjustments_pkg.lock_f_st_id()-');
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_st_id' );
1142: RAISE;
1143: END;
1144:
1145: /*===========================================================================+

Line 1156: | arp_util.debug |

1152: | |
1153: | SCOPE - PUBLIC |
1154: | |
1155: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1156: | arp_util.debug |
1157: | |
1158: | ARGUMENTS : IN: |
1159: | p_payment_schedule_id - identifies the rows to lock |
1160: | OUT: |

Line 1184: arp_util.debug('arp_adjustments_pkg.lock_f_ps_id()+');

1180: FOR UPDATE OF adjustment_id NOWAIT;
1181:
1182:
1183: BEGIN
1184: arp_util.debug('arp_adjustments_pkg.lock_f_ps_id()+');
1185:
1186: OPEN lock_c;
1187: CLOSE lock_c;
1188:

Line 1189: arp_util.debug('arp_adjustments_pkg.lock_f_ps_id()-');

1185:
1186: OPEN lock_c;
1187: CLOSE lock_c;
1188:
1189: arp_util.debug('arp_adjustments_pkg.lock_f_ps_id()-');
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ps_id' );

Line 1193: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ps_id' );

1189: arp_util.debug('arp_adjustments_pkg.lock_f_ps_id()-');
1190:
1191: EXCEPTION
1192: WHEN OTHERS THEN
1193: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ps_id' );
1194: RAISE;
1195: END;
1196:
1197: /*===========================================================================+

Line 1208: | arp_util.debug |

1204: | |
1205: | SCOPE - PUBLIC |
1206: | |
1207: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1208: | arp_util.debug |
1209: | |
1210: | ARGUMENTS : IN: |
1211: | p_customer_trx_line_id - identifies the rows to lock |
1212: | OUT: |

Line 1235: arp_util.debug('arp_adjustments_pkg.lock_f_ctl_id()+');

1231: WHERE customer_trx_line_id = p_customer_trx_line_id
1232: FOR UPDATE OF adjustment_id NOWAIT;
1233:
1234: BEGIN
1235: arp_util.debug('arp_adjustments_pkg.lock_f_ctl_id()+');
1236:
1237: OPEN lock_c;
1238: CLOSE lock_c;
1239:

Line 1240: arp_util.debug('arp_adjustments_pkg.lock_f_ctl_id()-');

1236:
1237: OPEN lock_c;
1238: CLOSE lock_c;
1239:
1240: arp_util.debug('arp_adjustments_pkg.lock_f_ctl_id()-');
1241:
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ctl_id' );

Line 1244: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ctl_id' );

1240: arp_util.debug('arp_adjustments_pkg.lock_f_ctl_id()-');
1241:
1242: EXCEPTION
1243: WHEN OTHERS THEN
1244: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_f_ctl_id' );
1245: RAISE;
1246: END;
1247:
1248: /*===========================================================================+

Line 1260: | arp_util.debug |

1256: | |
1257: | SCOPE - PUBLIC |
1258: | |
1259: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1260: | arp_util.debug |
1261: | |
1262: | ARGUMENTS : IN: |
1263: | p_adjustment_id - identifies the row to lock |
1264: | OUT: |

Line 1281: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()+');

1277: p_adjustment_id IN
1278: ar_adjustments.adjustment_id%type) IS
1279:
1280: BEGIN
1281: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()+');
1282:
1283: SELECT *
1284: INTO p_adj_rec
1285: FROM ar_adjustments

Line 1289: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()-');

1285: FROM ar_adjustments
1286: WHERE adjustment_id = p_adjustment_id
1287: FOR UPDATE OF adjustment_id NOWAIT;
1288:
1289: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()-');
1290:
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_fetch_p' );

Line 1293: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_fetch_p' );

1289: arp_util.debug('arp_adjustments_pkg.lock_fetch_p()-');
1290:
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_fetch_p' );
1294: RAISE;
1295: END;
1296:
1297: /*===========================================================================+

Line 1309: | arp_util.debug |

1305: | |
1306: | SCOPE - PUBLIC |
1307: | |
1308: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1309: | arp_util.debug |
1310: | |
1311: | ARGUMENTS : IN: |
1312: | p_adjustment_id - identifies the row to lock |
1313: | p_adj_rec - srep record for comparison |

Line 1333: arp_util.debug('arp_adjustments_pkg.lock_compare_p()+');

1329:
1330: l_new_adj_rec ar_adjustments%rowtype;
1331:
1332: BEGIN
1333: arp_util.debug('arp_adjustments_pkg.lock_compare_p()+');
1334:
1335: SELECT *
1336: INTO l_new_adj_rec
1337: FROM ar_adjustments adj

Line 1842: arp_util.debug('arp_adjustments_pkg.lock_compare_p()-');

1838: )
1839: FOR UPDATE OF adjustment_id NOWAIT;
1840:
1841:
1842: arp_util.debug('arp_adjustments_pkg.lock_compare_p()-');
1843:
1844: EXCEPTION
1845: WHEN NO_DATA_FOUND THEN
1846: arp_util.debug(

Line 1846: arp_util.debug(

1842: arp_util.debug('arp_adjustments_pkg.lock_compare_p()-');
1843:
1844: EXCEPTION
1845: WHEN NO_DATA_FOUND THEN
1846: arp_util.debug(
1847: 'EXCEPTION: arp_adjustments_pkg.l.lock_compare_p NO_DATA_FOUND' );
1848:
1849: arp_util.debug('');
1850: arp_util.debug('============= Old Record =============');

Line 1849: arp_util.debug('');

1845: WHEN NO_DATA_FOUND THEN
1846: arp_util.debug(
1847: 'EXCEPTION: arp_adjustments_pkg.l.lock_compare_p NO_DATA_FOUND' );
1848:
1849: arp_util.debug('');
1850: arp_util.debug('============= Old Record =============');
1851: display_adj_p(p_adjustment_id);
1852: arp_util.debug('');
1853: arp_util.debug('============= New Record =============');

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

1846: arp_util.debug(
1847: 'EXCEPTION: arp_adjustments_pkg.l.lock_compare_p NO_DATA_FOUND' );
1848:
1849: arp_util.debug('');
1850: arp_util.debug('============= Old Record =============');
1851: display_adj_p(p_adjustment_id);
1852: arp_util.debug('');
1853: arp_util.debug('============= New Record =============');
1854: display_adj_rec(p_adj_rec);

Line 1852: arp_util.debug('');

1848:
1849: arp_util.debug('');
1850: arp_util.debug('============= Old Record =============');
1851: display_adj_p(p_adjustment_id);
1852: arp_util.debug('');
1853: arp_util.debug('============= New Record =============');
1854: display_adj_rec(p_adj_rec);
1855:
1856: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

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

1849: arp_util.debug('');
1850: arp_util.debug('============= Old Record =============');
1851: display_adj_p(p_adjustment_id);
1852: arp_util.debug('');
1853: arp_util.debug('============= New Record =============');
1854: display_adj_rec(p_adj_rec);
1855:
1856: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1857: APP_EXCEPTION.Raise_Exception;

Line 1860: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_compare_p' );

1856: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1857: APP_EXCEPTION.Raise_Exception;
1858:
1859: WHEN OTHERS THEN
1860: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.lock_compare_p' );
1861: RAISE;
1862: END;
1863:
1864: /*===========================================================================+

Line 1876: | arp_util.debug |

1872: | |
1873: | SCOPE - PUBLIC |
1874: | |
1875: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1876: | arp_util.debug |
1877: | |
1878: | ARGUMENTS : IN: |
1879: | p_adjustment_id |
1880: | p_amount |

Line 2021: arp_util.debug('arp_adjustments_pkg.lock_compare_cover()+');

2017:
2018: l_adj_rec ar_adjustments%rowtype;
2019:
2020: BEGIN
2021: arp_util.debug('arp_adjustments_pkg.lock_compare_cover()+');
2022:
2023: /*----------------------------------------------------+
2024: | Populate the adjustment record with the values |
2025: | passed in as parameters. |

Line 2100: arp_util.debug('arp_adjustments_pkg.lock_compare_cover()-');

2096: +-----------------------------------------*/
2097:
2098: lock_compare_p( l_adj_rec, p_adjustment_id);
2099:
2100: arp_util.debug('arp_adjustments_pkg.lock_compare_cover()-');
2101:
2102: EXCEPTION
2103: WHEN OTHERS THEN
2104: arp_util.debug('EXCEPTION : arp_adjustments_pkg.lock_compare_cover()');

Line 2104: arp_util.debug('EXCEPTION : arp_adjustments_pkg.lock_compare_cover()');

2100: arp_util.debug('arp_adjustments_pkg.lock_compare_cover()-');
2101:
2102: EXCEPTION
2103: WHEN OTHERS THEN
2104: arp_util.debug('EXCEPTION : arp_adjustments_pkg.lock_compare_cover()');
2105:
2106: arp_util.debug('----- parameters for lock_compare_cover() ' ||
2107: '-----');
2108: arp_util.debug('p_adjustment_id = ' ||

Line 2106: arp_util.debug('----- parameters for lock_compare_cover() ' ||

2102: EXCEPTION
2103: WHEN OTHERS THEN
2104: arp_util.debug('EXCEPTION : arp_adjustments_pkg.lock_compare_cover()');
2105:
2106: arp_util.debug('----- parameters for lock_compare_cover() ' ||
2107: '-----');
2108: arp_util.debug('p_adjustment_id = ' ||
2109: TO_CHAR(p_adjustment_id));
2110: arp_util.debug('p_amount = ' ||

Line 2108: arp_util.debug('p_adjustment_id = ' ||

2104: arp_util.debug('EXCEPTION : arp_adjustments_pkg.lock_compare_cover()');
2105:
2106: arp_util.debug('----- parameters for lock_compare_cover() ' ||
2107: '-----');
2108: arp_util.debug('p_adjustment_id = ' ||
2109: TO_CHAR(p_adjustment_id));
2110: arp_util.debug('p_amount = ' ||
2111: TO_CHAR(p_amount));
2112: arp_util.debug('p_acctd_amount = ' ||

Line 2110: arp_util.debug('p_amount = ' ||

2106: arp_util.debug('----- parameters for lock_compare_cover() ' ||
2107: '-----');
2108: arp_util.debug('p_adjustment_id = ' ||
2109: TO_CHAR(p_adjustment_id));
2110: arp_util.debug('p_amount = ' ||
2111: TO_CHAR(p_amount));
2112: arp_util.debug('p_acctd_amount = ' ||
2113: TO_CHAR(p_acctd_amount));
2114: arp_util.debug('p_apply_date = ' ||

Line 2112: arp_util.debug('p_acctd_amount = ' ||

2108: arp_util.debug('p_adjustment_id = ' ||
2109: TO_CHAR(p_adjustment_id));
2110: arp_util.debug('p_amount = ' ||
2111: TO_CHAR(p_amount));
2112: arp_util.debug('p_acctd_amount = ' ||
2113: TO_CHAR(p_acctd_amount));
2114: arp_util.debug('p_apply_date = ' ||
2115: TO_CHAR(p_apply_date, 'DD-MON-YYYY'));
2116: arp_util.debug('p_gl_date = ' ||

Line 2114: arp_util.debug('p_apply_date = ' ||

2110: arp_util.debug('p_amount = ' ||
2111: TO_CHAR(p_amount));
2112: arp_util.debug('p_acctd_amount = ' ||
2113: TO_CHAR(p_acctd_amount));
2114: arp_util.debug('p_apply_date = ' ||
2115: TO_CHAR(p_apply_date, 'DD-MON-YYYY'));
2116: arp_util.debug('p_gl_date = ' ||
2117: TO_CHAR(p_gl_date, 'DD-MON-YYYY'));
2118: arp_util.debug('p_gl_posted_date = ' ||

Line 2116: arp_util.debug('p_gl_date = ' ||

2112: arp_util.debug('p_acctd_amount = ' ||
2113: TO_CHAR(p_acctd_amount));
2114: arp_util.debug('p_apply_date = ' ||
2115: TO_CHAR(p_apply_date, 'DD-MON-YYYY'));
2116: arp_util.debug('p_gl_date = ' ||
2117: TO_CHAR(p_gl_date, 'DD-MON-YYYY'));
2118: arp_util.debug('p_gl_posted_date = ' ||
2119: TO_CHAR(p_gl_posted_date, 'DD-MON-YYYY'));
2120: arp_util.debug('p_set_of_books_id = ' ||

Line 2118: arp_util.debug('p_gl_posted_date = ' ||

2114: arp_util.debug('p_apply_date = ' ||
2115: TO_CHAR(p_apply_date, 'DD-MON-YYYY'));
2116: arp_util.debug('p_gl_date = ' ||
2117: TO_CHAR(p_gl_date, 'DD-MON-YYYY'));
2118: arp_util.debug('p_gl_posted_date = ' ||
2119: TO_CHAR(p_gl_posted_date, 'DD-MON-YYYY'));
2120: arp_util.debug('p_set_of_books_id = ' ||
2121: TO_CHAR(p_set_of_books_id));
2122: arp_util.debug('p_code_combination_id = ' ||

Line 2120: arp_util.debug('p_set_of_books_id = ' ||

2116: arp_util.debug('p_gl_date = ' ||
2117: TO_CHAR(p_gl_date, 'DD-MON-YYYY'));
2118: arp_util.debug('p_gl_posted_date = ' ||
2119: TO_CHAR(p_gl_posted_date, 'DD-MON-YYYY'));
2120: arp_util.debug('p_set_of_books_id = ' ||
2121: TO_CHAR(p_set_of_books_id));
2122: arp_util.debug('p_code_combination_id = ' ||
2123: TO_CHAR(p_code_combination_id));
2124: arp_util.debug('p_type = ' ||

Line 2122: arp_util.debug('p_code_combination_id = ' ||

2118: arp_util.debug('p_gl_posted_date = ' ||
2119: TO_CHAR(p_gl_posted_date, 'DD-MON-YYYY'));
2120: arp_util.debug('p_set_of_books_id = ' ||
2121: TO_CHAR(p_set_of_books_id));
2122: arp_util.debug('p_code_combination_id = ' ||
2123: TO_CHAR(p_code_combination_id));
2124: arp_util.debug('p_type = ' ||
2125: p_type);
2126: arp_util.debug('p_adjustment_type = ' ||

Line 2124: arp_util.debug('p_type = ' ||

2120: arp_util.debug('p_set_of_books_id = ' ||
2121: TO_CHAR(p_set_of_books_id));
2122: arp_util.debug('p_code_combination_id = ' ||
2123: TO_CHAR(p_code_combination_id));
2124: arp_util.debug('p_type = ' ||
2125: p_type);
2126: arp_util.debug('p_adjustment_type = ' ||
2127: p_adjustment_type);
2128: arp_util.debug('p_status = ' ||

Line 2126: arp_util.debug('p_adjustment_type = ' ||

2122: arp_util.debug('p_code_combination_id = ' ||
2123: TO_CHAR(p_code_combination_id));
2124: arp_util.debug('p_type = ' ||
2125: p_type);
2126: arp_util.debug('p_adjustment_type = ' ||
2127: p_adjustment_type);
2128: arp_util.debug('p_status = ' ||
2129: p_status);
2130: arp_util.debug('p_line_adjusted = ' ||

Line 2128: arp_util.debug('p_status = ' ||

2124: arp_util.debug('p_type = ' ||
2125: p_type);
2126: arp_util.debug('p_adjustment_type = ' ||
2127: p_adjustment_type);
2128: arp_util.debug('p_status = ' ||
2129: p_status);
2130: arp_util.debug('p_line_adjusted = ' ||
2131: TO_CHAR(p_line_adjusted));
2132: arp_util.debug('p_freight_adjusted = ' ||

Line 2130: arp_util.debug('p_line_adjusted = ' ||

2126: arp_util.debug('p_adjustment_type = ' ||
2127: p_adjustment_type);
2128: arp_util.debug('p_status = ' ||
2129: p_status);
2130: arp_util.debug('p_line_adjusted = ' ||
2131: TO_CHAR(p_line_adjusted));
2132: arp_util.debug('p_freight_adjusted = ' ||
2133: TO_CHAR(p_freight_adjusted));
2134: arp_util.debug('p_tax_adjusted = ' ||

Line 2132: arp_util.debug('p_freight_adjusted = ' ||

2128: arp_util.debug('p_status = ' ||
2129: p_status);
2130: arp_util.debug('p_line_adjusted = ' ||
2131: TO_CHAR(p_line_adjusted));
2132: arp_util.debug('p_freight_adjusted = ' ||
2133: TO_CHAR(p_freight_adjusted));
2134: arp_util.debug('p_tax_adjusted = ' ||
2135: TO_CHAR(p_tax_adjusted));
2136: arp_util.debug('p_receivables_charges_adj = ' ||

Line 2134: arp_util.debug('p_tax_adjusted = ' ||

2130: arp_util.debug('p_line_adjusted = ' ||
2131: TO_CHAR(p_line_adjusted));
2132: arp_util.debug('p_freight_adjusted = ' ||
2133: TO_CHAR(p_freight_adjusted));
2134: arp_util.debug('p_tax_adjusted = ' ||
2135: TO_CHAR(p_tax_adjusted));
2136: arp_util.debug('p_receivables_charges_adj = ' ||
2137: TO_CHAR(p_receivables_charges_adj ));
2138: arp_util.debug('p_batch_id = ' ||

Line 2136: arp_util.debug('p_receivables_charges_adj = ' ||

2132: arp_util.debug('p_freight_adjusted = ' ||
2133: TO_CHAR(p_freight_adjusted));
2134: arp_util.debug('p_tax_adjusted = ' ||
2135: TO_CHAR(p_tax_adjusted));
2136: arp_util.debug('p_receivables_charges_adj = ' ||
2137: TO_CHAR(p_receivables_charges_adj ));
2138: arp_util.debug('p_batch_id = ' ||
2139: TO_CHAR(p_batch_id));
2140: arp_util.debug('p_customer_trx_id = ' ||

Line 2138: arp_util.debug('p_batch_id = ' ||

2134: arp_util.debug('p_tax_adjusted = ' ||
2135: TO_CHAR(p_tax_adjusted));
2136: arp_util.debug('p_receivables_charges_adj = ' ||
2137: TO_CHAR(p_receivables_charges_adj ));
2138: arp_util.debug('p_batch_id = ' ||
2139: TO_CHAR(p_batch_id));
2140: arp_util.debug('p_customer_trx_id = ' ||
2141: TO_CHAR(p_customer_trx_id));
2142: arp_util.debug('p_subsequent_trx_id = ' ||

Line 2140: arp_util.debug('p_customer_trx_id = ' ||

2136: arp_util.debug('p_receivables_charges_adj = ' ||
2137: TO_CHAR(p_receivables_charges_adj ));
2138: arp_util.debug('p_batch_id = ' ||
2139: TO_CHAR(p_batch_id));
2140: arp_util.debug('p_customer_trx_id = ' ||
2141: TO_CHAR(p_customer_trx_id));
2142: arp_util.debug('p_subsequent_trx_id = ' ||
2143: TO_CHAR(p_subsequent_trx_id));
2144: arp_util.debug('p_customer_trx_line_id = ' ||

Line 2142: arp_util.debug('p_subsequent_trx_id = ' ||

2138: arp_util.debug('p_batch_id = ' ||
2139: TO_CHAR(p_batch_id));
2140: arp_util.debug('p_customer_trx_id = ' ||
2141: TO_CHAR(p_customer_trx_id));
2142: arp_util.debug('p_subsequent_trx_id = ' ||
2143: TO_CHAR(p_subsequent_trx_id));
2144: arp_util.debug('p_customer_trx_line_id = ' ||
2145: TO_CHAR(p_customer_trx_line_id));
2146: arp_util.debug('p_associated_cash_receipt_id = ' ||

Line 2144: arp_util.debug('p_customer_trx_line_id = ' ||

2140: arp_util.debug('p_customer_trx_id = ' ||
2141: TO_CHAR(p_customer_trx_id));
2142: arp_util.debug('p_subsequent_trx_id = ' ||
2143: TO_CHAR(p_subsequent_trx_id));
2144: arp_util.debug('p_customer_trx_line_id = ' ||
2145: TO_CHAR(p_customer_trx_line_id));
2146: arp_util.debug('p_associated_cash_receipt_id = ' ||
2147: TO_CHAR(p_associated_cash_receipt_id));
2148: arp_util.debug('p_chargeback_customer_trx_id = ' ||

Line 2146: arp_util.debug('p_associated_cash_receipt_id = ' ||

2142: arp_util.debug('p_subsequent_trx_id = ' ||
2143: TO_CHAR(p_subsequent_trx_id));
2144: arp_util.debug('p_customer_trx_line_id = ' ||
2145: TO_CHAR(p_customer_trx_line_id));
2146: arp_util.debug('p_associated_cash_receipt_id = ' ||
2147: TO_CHAR(p_associated_cash_receipt_id));
2148: arp_util.debug('p_chargeback_customer_trx_id = ' ||
2149: TO_CHAR(p_chargeback_customer_trx_id));
2150: arp_util.debug('p_payment_schedule_id = ' ||

Line 2148: arp_util.debug('p_chargeback_customer_trx_id = ' ||

2144: arp_util.debug('p_customer_trx_line_id = ' ||
2145: TO_CHAR(p_customer_trx_line_id));
2146: arp_util.debug('p_associated_cash_receipt_id = ' ||
2147: TO_CHAR(p_associated_cash_receipt_id));
2148: arp_util.debug('p_chargeback_customer_trx_id = ' ||
2149: TO_CHAR(p_chargeback_customer_trx_id));
2150: arp_util.debug('p_payment_schedule_id = ' ||
2151: TO_CHAR(p_payment_schedule_id));
2152: arp_util.debug('p_receivables_trx_id = ' ||

Line 2150: arp_util.debug('p_payment_schedule_id = ' ||

2146: arp_util.debug('p_associated_cash_receipt_id = ' ||
2147: TO_CHAR(p_associated_cash_receipt_id));
2148: arp_util.debug('p_chargeback_customer_trx_id = ' ||
2149: TO_CHAR(p_chargeback_customer_trx_id));
2150: arp_util.debug('p_payment_schedule_id = ' ||
2151: TO_CHAR(p_payment_schedule_id));
2152: arp_util.debug('p_receivables_trx_id = ' ||
2153: TO_CHAR(p_receivables_trx_id));
2154: arp_util.debug('p_distribution_set_id = ' ||

Line 2152: arp_util.debug('p_receivables_trx_id = ' ||

2148: arp_util.debug('p_chargeback_customer_trx_id = ' ||
2149: TO_CHAR(p_chargeback_customer_trx_id));
2150: arp_util.debug('p_payment_schedule_id = ' ||
2151: TO_CHAR(p_payment_schedule_id));
2152: arp_util.debug('p_receivables_trx_id = ' ||
2153: TO_CHAR(p_receivables_trx_id));
2154: arp_util.debug('p_distribution_set_id = ' ||
2155: TO_CHAR(p_distribution_set_id));
2156: arp_util.debug('p_associated_application_id = ' ||

Line 2154: arp_util.debug('p_distribution_set_id = ' ||

2150: arp_util.debug('p_payment_schedule_id = ' ||
2151: TO_CHAR(p_payment_schedule_id));
2152: arp_util.debug('p_receivables_trx_id = ' ||
2153: TO_CHAR(p_receivables_trx_id));
2154: arp_util.debug('p_distribution_set_id = ' ||
2155: TO_CHAR(p_distribution_set_id));
2156: arp_util.debug('p_associated_application_id = ' ||
2157: TO_CHAR(p_associated_application_id));
2158: arp_util.debug('p_comments = ' ||

Line 2156: arp_util.debug('p_associated_application_id = ' ||

2152: arp_util.debug('p_receivables_trx_id = ' ||
2153: TO_CHAR(p_receivables_trx_id));
2154: arp_util.debug('p_distribution_set_id = ' ||
2155: TO_CHAR(p_distribution_set_id));
2156: arp_util.debug('p_associated_application_id = ' ||
2157: TO_CHAR(p_associated_application_id));
2158: arp_util.debug('p_comments = ' ||
2159: p_comments);
2160: arp_util.debug('p_automatically_generated = ' ||

Line 2158: arp_util.debug('p_comments = ' ||

2154: arp_util.debug('p_distribution_set_id = ' ||
2155: TO_CHAR(p_distribution_set_id));
2156: arp_util.debug('p_associated_application_id = ' ||
2157: TO_CHAR(p_associated_application_id));
2158: arp_util.debug('p_comments = ' ||
2159: p_comments);
2160: arp_util.debug('p_automatically_generated = ' ||
2161: p_automatically_generated);
2162: arp_util.debug('p_created_from = ' ||

Line 2160: arp_util.debug('p_automatically_generated = ' ||

2156: arp_util.debug('p_associated_application_id = ' ||
2157: TO_CHAR(p_associated_application_id));
2158: arp_util.debug('p_comments = ' ||
2159: p_comments);
2160: arp_util.debug('p_automatically_generated = ' ||
2161: p_automatically_generated);
2162: arp_util.debug('p_created_from = ' ||
2163: p_created_from);
2164: arp_util.debug('p_reason_code = ' ||

Line 2162: arp_util.debug('p_created_from = ' ||

2158: arp_util.debug('p_comments = ' ||
2159: p_comments);
2160: arp_util.debug('p_automatically_generated = ' ||
2161: p_automatically_generated);
2162: arp_util.debug('p_created_from = ' ||
2163: p_created_from);
2164: arp_util.debug('p_reason_code = ' ||
2165: p_reason_code);
2166: arp_util.debug('p_postable = ' ||

Line 2164: arp_util.debug('p_reason_code = ' ||

2160: arp_util.debug('p_automatically_generated = ' ||
2161: p_automatically_generated);
2162: arp_util.debug('p_created_from = ' ||
2163: p_created_from);
2164: arp_util.debug('p_reason_code = ' ||
2165: p_reason_code);
2166: arp_util.debug('p_postable = ' ||
2167: p_postable);
2168: arp_util.debug('p_approved_by = ' ||

Line 2166: arp_util.debug('p_postable = ' ||

2162: arp_util.debug('p_created_from = ' ||
2163: p_created_from);
2164: arp_util.debug('p_reason_code = ' ||
2165: p_reason_code);
2166: arp_util.debug('p_postable = ' ||
2167: p_postable);
2168: arp_util.debug('p_approved_by = ' ||
2169: TO_CHAR(p_approved_by));
2170: arp_util.debug('p_adjustment_number = ' ||

Line 2168: arp_util.debug('p_approved_by = ' ||

2164: arp_util.debug('p_reason_code = ' ||
2165: p_reason_code);
2166: arp_util.debug('p_postable = ' ||
2167: p_postable);
2168: arp_util.debug('p_approved_by = ' ||
2169: TO_CHAR(p_approved_by));
2170: arp_util.debug('p_adjustment_number = ' ||
2171: p_adjustment_number);
2172: arp_util.debug('p_doc_sequence_value = ' ||

Line 2170: arp_util.debug('p_adjustment_number = ' ||

2166: arp_util.debug('p_postable = ' ||
2167: p_postable);
2168: arp_util.debug('p_approved_by = ' ||
2169: TO_CHAR(p_approved_by));
2170: arp_util.debug('p_adjustment_number = ' ||
2171: p_adjustment_number);
2172: arp_util.debug('p_doc_sequence_value = ' ||
2173: TO_CHAR(p_doc_sequence_value));
2174: arp_util.debug('p_doc_sequence_id = ' ||

Line 2172: arp_util.debug('p_doc_sequence_value = ' ||

2168: arp_util.debug('p_approved_by = ' ||
2169: TO_CHAR(p_approved_by));
2170: arp_util.debug('p_adjustment_number = ' ||
2171: p_adjustment_number);
2172: arp_util.debug('p_doc_sequence_value = ' ||
2173: TO_CHAR(p_doc_sequence_value));
2174: arp_util.debug('p_doc_sequence_id = ' ||
2175: TO_CHAR(p_doc_sequence_id));
2176: arp_util.debug('p_ussgl_transaction_code = ' ||

Line 2174: arp_util.debug('p_doc_sequence_id = ' ||

2170: arp_util.debug('p_adjustment_number = ' ||
2171: p_adjustment_number);
2172: arp_util.debug('p_doc_sequence_value = ' ||
2173: TO_CHAR(p_doc_sequence_value));
2174: arp_util.debug('p_doc_sequence_id = ' ||
2175: TO_CHAR(p_doc_sequence_id));
2176: arp_util.debug('p_ussgl_transaction_code = ' ||
2177: p_ussgl_transaction_code);
2178: arp_util.debug('p_ussgl_trans_code_context = ' ||

Line 2176: arp_util.debug('p_ussgl_transaction_code = ' ||

2172: arp_util.debug('p_doc_sequence_value = ' ||
2173: TO_CHAR(p_doc_sequence_value));
2174: arp_util.debug('p_doc_sequence_id = ' ||
2175: TO_CHAR(p_doc_sequence_id));
2176: arp_util.debug('p_ussgl_transaction_code = ' ||
2177: p_ussgl_transaction_code);
2178: arp_util.debug('p_ussgl_trans_code_context = ' ||
2179: p_ussgl_trans_code_context);
2180: arp_util.debug('p_attribute_category = ' ||

Line 2178: arp_util.debug('p_ussgl_trans_code_context = ' ||

2174: arp_util.debug('p_doc_sequence_id = ' ||
2175: TO_CHAR(p_doc_sequence_id));
2176: arp_util.debug('p_ussgl_transaction_code = ' ||
2177: p_ussgl_transaction_code);
2178: arp_util.debug('p_ussgl_trans_code_context = ' ||
2179: p_ussgl_trans_code_context);
2180: arp_util.debug('p_attribute_category = ' ||
2181: p_attribute_category);
2182: arp_util.debug('p_attribute1 = ' ||

Line 2180: arp_util.debug('p_attribute_category = ' ||

2176: arp_util.debug('p_ussgl_transaction_code = ' ||
2177: p_ussgl_transaction_code);
2178: arp_util.debug('p_ussgl_trans_code_context = ' ||
2179: p_ussgl_trans_code_context);
2180: arp_util.debug('p_attribute_category = ' ||
2181: p_attribute_category);
2182: arp_util.debug('p_attribute1 = ' ||
2183: p_attribute1);
2184: arp_util.debug('p_attribute2 = ' ||

Line 2182: arp_util.debug('p_attribute1 = ' ||

2178: arp_util.debug('p_ussgl_trans_code_context = ' ||
2179: p_ussgl_trans_code_context);
2180: arp_util.debug('p_attribute_category = ' ||
2181: p_attribute_category);
2182: arp_util.debug('p_attribute1 = ' ||
2183: p_attribute1);
2184: arp_util.debug('p_attribute2 = ' ||
2185: p_attribute2);
2186: arp_util.debug('p_attribute3 = ' ||

Line 2184: arp_util.debug('p_attribute2 = ' ||

2180: arp_util.debug('p_attribute_category = ' ||
2181: p_attribute_category);
2182: arp_util.debug('p_attribute1 = ' ||
2183: p_attribute1);
2184: arp_util.debug('p_attribute2 = ' ||
2185: p_attribute2);
2186: arp_util.debug('p_attribute3 = ' ||
2187: p_attribute3);
2188: arp_util.debug('p_attribute4 = ' ||

Line 2186: arp_util.debug('p_attribute3 = ' ||

2182: arp_util.debug('p_attribute1 = ' ||
2183: p_attribute1);
2184: arp_util.debug('p_attribute2 = ' ||
2185: p_attribute2);
2186: arp_util.debug('p_attribute3 = ' ||
2187: p_attribute3);
2188: arp_util.debug('p_attribute4 = ' ||
2189: p_attribute4);
2190: arp_util.debug('p_attribute5 = ' ||

Line 2188: arp_util.debug('p_attribute4 = ' ||

2184: arp_util.debug('p_attribute2 = ' ||
2185: p_attribute2);
2186: arp_util.debug('p_attribute3 = ' ||
2187: p_attribute3);
2188: arp_util.debug('p_attribute4 = ' ||
2189: p_attribute4);
2190: arp_util.debug('p_attribute5 = ' ||
2191: p_attribute5);
2192: arp_util.debug('p_attribute6 = ' ||

Line 2190: arp_util.debug('p_attribute5 = ' ||

2186: arp_util.debug('p_attribute3 = ' ||
2187: p_attribute3);
2188: arp_util.debug('p_attribute4 = ' ||
2189: p_attribute4);
2190: arp_util.debug('p_attribute5 = ' ||
2191: p_attribute5);
2192: arp_util.debug('p_attribute6 = ' ||
2193: p_attribute6);
2194: arp_util.debug('p_attribute7 = ' ||

Line 2192: arp_util.debug('p_attribute6 = ' ||

2188: arp_util.debug('p_attribute4 = ' ||
2189: p_attribute4);
2190: arp_util.debug('p_attribute5 = ' ||
2191: p_attribute5);
2192: arp_util.debug('p_attribute6 = ' ||
2193: p_attribute6);
2194: arp_util.debug('p_attribute7 = ' ||
2195: p_attribute7);
2196: arp_util.debug('p_attribute8 = ' ||

Line 2194: arp_util.debug('p_attribute7 = ' ||

2190: arp_util.debug('p_attribute5 = ' ||
2191: p_attribute5);
2192: arp_util.debug('p_attribute6 = ' ||
2193: p_attribute6);
2194: arp_util.debug('p_attribute7 = ' ||
2195: p_attribute7);
2196: arp_util.debug('p_attribute8 = ' ||
2197: p_attribute8);
2198: arp_util.debug('p_attribute9 = ' ||

Line 2196: arp_util.debug('p_attribute8 = ' ||

2192: arp_util.debug('p_attribute6 = ' ||
2193: p_attribute6);
2194: arp_util.debug('p_attribute7 = ' ||
2195: p_attribute7);
2196: arp_util.debug('p_attribute8 = ' ||
2197: p_attribute8);
2198: arp_util.debug('p_attribute9 = ' ||
2199: p_attribute9);
2200: arp_util.debug('p_attribute10 = ' ||

Line 2198: arp_util.debug('p_attribute9 = ' ||

2194: arp_util.debug('p_attribute7 = ' ||
2195: p_attribute7);
2196: arp_util.debug('p_attribute8 = ' ||
2197: p_attribute8);
2198: arp_util.debug('p_attribute9 = ' ||
2199: p_attribute9);
2200: arp_util.debug('p_attribute10 = ' ||
2201: p_attribute10);
2202: arp_util.debug('p_attribute11 = ' ||

Line 2200: arp_util.debug('p_attribute10 = ' ||

2196: arp_util.debug('p_attribute8 = ' ||
2197: p_attribute8);
2198: arp_util.debug('p_attribute9 = ' ||
2199: p_attribute9);
2200: arp_util.debug('p_attribute10 = ' ||
2201: p_attribute10);
2202: arp_util.debug('p_attribute11 = ' ||
2203: p_attribute11);
2204: arp_util.debug('p_attribute12 = ' ||

Line 2202: arp_util.debug('p_attribute11 = ' ||

2198: arp_util.debug('p_attribute9 = ' ||
2199: p_attribute9);
2200: arp_util.debug('p_attribute10 = ' ||
2201: p_attribute10);
2202: arp_util.debug('p_attribute11 = ' ||
2203: p_attribute11);
2204: arp_util.debug('p_attribute12 = ' ||
2205: p_attribute12);
2206: arp_util.debug('p_attribute13 = ' ||

Line 2204: arp_util.debug('p_attribute12 = ' ||

2200: arp_util.debug('p_attribute10 = ' ||
2201: p_attribute10);
2202: arp_util.debug('p_attribute11 = ' ||
2203: p_attribute11);
2204: arp_util.debug('p_attribute12 = ' ||
2205: p_attribute12);
2206: arp_util.debug('p_attribute13 = ' ||
2207: p_attribute13);
2208: arp_util.debug('p_attribute14 = ' ||

Line 2206: arp_util.debug('p_attribute13 = ' ||

2202: arp_util.debug('p_attribute11 = ' ||
2203: p_attribute11);
2204: arp_util.debug('p_attribute12 = ' ||
2205: p_attribute12);
2206: arp_util.debug('p_attribute13 = ' ||
2207: p_attribute13);
2208: arp_util.debug('p_attribute14 = ' ||
2209: p_attribute14);
2210: arp_util.debug('p_attribute15 = ' ||

Line 2208: arp_util.debug('p_attribute14 = ' ||

2204: arp_util.debug('p_attribute12 = ' ||
2205: p_attribute12);
2206: arp_util.debug('p_attribute13 = ' ||
2207: p_attribute13);
2208: arp_util.debug('p_attribute14 = ' ||
2209: p_attribute14);
2210: arp_util.debug('p_attribute15 = ' ||
2211: p_attribute15);
2212: arp_util.debug('p_posting_control_id = ' ||

Line 2210: arp_util.debug('p_attribute15 = ' ||

2206: arp_util.debug('p_attribute13 = ' ||
2207: p_attribute13);
2208: arp_util.debug('p_attribute14 = ' ||
2209: p_attribute14);
2210: arp_util.debug('p_attribute15 = ' ||
2211: p_attribute15);
2212: arp_util.debug('p_posting_control_id = ' ||
2213: TO_CHAR(p_posting_control_id));
2214: arp_util.debug('p_last_updated_by = ' ||

Line 2212: arp_util.debug('p_posting_control_id = ' ||

2208: arp_util.debug('p_attribute14 = ' ||
2209: p_attribute14);
2210: arp_util.debug('p_attribute15 = ' ||
2211: p_attribute15);
2212: arp_util.debug('p_posting_control_id = ' ||
2213: TO_CHAR(p_posting_control_id));
2214: arp_util.debug('p_last_updated_by = ' ||
2215: TO_CHAR(p_last_updated_by));
2216: arp_util.debug('p_last_update_date = ' ||

Line 2214: arp_util.debug('p_last_updated_by = ' ||

2210: arp_util.debug('p_attribute15 = ' ||
2211: p_attribute15);
2212: arp_util.debug('p_posting_control_id = ' ||
2213: TO_CHAR(p_posting_control_id));
2214: arp_util.debug('p_last_updated_by = ' ||
2215: TO_CHAR(p_last_updated_by));
2216: arp_util.debug('p_last_update_date = ' ||
2217: TO_CHAR(p_last_update_date, 'DD-MON-YYYY'));
2218: arp_util.debug('p_last_update_login = ' ||

Line 2216: arp_util.debug('p_last_update_date = ' ||

2212: arp_util.debug('p_posting_control_id = ' ||
2213: TO_CHAR(p_posting_control_id));
2214: arp_util.debug('p_last_updated_by = ' ||
2215: TO_CHAR(p_last_updated_by));
2216: arp_util.debug('p_last_update_date = ' ||
2217: TO_CHAR(p_last_update_date, 'DD-MON-YYYY'));
2218: arp_util.debug('p_last_update_login = ' ||
2219: TO_CHAR(p_last_update_login));
2220: arp_util.debug('p_created_by = ' ||

Line 2218: arp_util.debug('p_last_update_login = ' ||

2214: arp_util.debug('p_last_updated_by = ' ||
2215: TO_CHAR(p_last_updated_by));
2216: arp_util.debug('p_last_update_date = ' ||
2217: TO_CHAR(p_last_update_date, 'DD-MON-YYYY'));
2218: arp_util.debug('p_last_update_login = ' ||
2219: TO_CHAR(p_last_update_login));
2220: arp_util.debug('p_created_by = ' ||
2221: TO_CHAR(p_created_by));
2222: arp_util.debug('p_creation_date = ' ||

Line 2220: arp_util.debug('p_created_by = ' ||

2216: arp_util.debug('p_last_update_date = ' ||
2217: TO_CHAR(p_last_update_date, 'DD-MON-YYYY'));
2218: arp_util.debug('p_last_update_login = ' ||
2219: TO_CHAR(p_last_update_login));
2220: arp_util.debug('p_created_by = ' ||
2221: TO_CHAR(p_created_by));
2222: arp_util.debug('p_creation_date = ' ||
2223: TO_CHAR(p_creation_date, 'DD-MON-YYYY'));
2224: arp_util.debug('p_program_application_id = ' ||

Line 2222: arp_util.debug('p_creation_date = ' ||

2218: arp_util.debug('p_last_update_login = ' ||
2219: TO_CHAR(p_last_update_login));
2220: arp_util.debug('p_created_by = ' ||
2221: TO_CHAR(p_created_by));
2222: arp_util.debug('p_creation_date = ' ||
2223: TO_CHAR(p_creation_date, 'DD-MON-YYYY'));
2224: arp_util.debug('p_program_application_id = ' ||
2225: TO_CHAR(p_program_application_id));
2226: arp_util.debug('p_program_id = ' ||

Line 2224: arp_util.debug('p_program_application_id = ' ||

2220: arp_util.debug('p_created_by = ' ||
2221: TO_CHAR(p_created_by));
2222: arp_util.debug('p_creation_date = ' ||
2223: TO_CHAR(p_creation_date, 'DD-MON-YYYY'));
2224: arp_util.debug('p_program_application_id = ' ||
2225: TO_CHAR(p_program_application_id));
2226: arp_util.debug('p_program_id = ' ||
2227: TO_CHAR(p_program_id));
2228: arp_util.debug('p_program_update_date = ' ||

Line 2226: arp_util.debug('p_program_id = ' ||

2222: arp_util.debug('p_creation_date = ' ||
2223: TO_CHAR(p_creation_date, 'DD-MON-YYYY'));
2224: arp_util.debug('p_program_application_id = ' ||
2225: TO_CHAR(p_program_application_id));
2226: arp_util.debug('p_program_id = ' ||
2227: TO_CHAR(p_program_id));
2228: arp_util.debug('p_program_update_date = ' ||
2229: TO_CHAR(p_program_update_date, 'DD-MON-YYYY'));
2230: arp_util.debug('p_request_id = ' ||

Line 2228: arp_util.debug('p_program_update_date = ' ||

2224: arp_util.debug('p_program_application_id = ' ||
2225: TO_CHAR(p_program_application_id));
2226: arp_util.debug('p_program_id = ' ||
2227: TO_CHAR(p_program_id));
2228: arp_util.debug('p_program_update_date = ' ||
2229: TO_CHAR(p_program_update_date, 'DD-MON-YYYY'));
2230: arp_util.debug('p_request_id = ' ||
2231: TO_CHAR(p_request_id));
2232:

Line 2230: arp_util.debug('p_request_id = ' ||

2226: arp_util.debug('p_program_id = ' ||
2227: TO_CHAR(p_program_id));
2228: arp_util.debug('p_program_update_date = ' ||
2229: TO_CHAR(p_program_update_date, 'DD-MON-YYYY'));
2230: arp_util.debug('p_request_id = ' ||
2231: TO_CHAR(p_request_id));
2232:
2233: RAISE;
2234:

Line 2249: | arp_util.debug |

2245: | |
2246: | SCOPE - PUBLIC |
2247: | |
2248: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2249: | arp_util.debug |
2250: | |
2251: | ARGUMENTS : IN: |
2252: | p_adjustment_id - identifies the record to fetch |
2253: | OUT: |

Line 2270: arp_util.debug('arp_adjustments_pkg.fetch_p()+');

2266: p_adjustment_id IN ar_adjustments.adjustment_id%type)
2267: IS
2268:
2269: BEGIN
2270: arp_util.debug('arp_adjustments_pkg.fetch_p()+');
2271:
2272: SELECT *
2273: INTO p_adj_rec
2274: FROM ar_adjustments

Line 2277: arp_util.debug('arp_adjustments_pkg.fetch_p()-');

2273: INTO p_adj_rec
2274: FROM ar_adjustments
2275: WHERE adjustment_id = p_adjustment_id;
2276:
2277: arp_util.debug('arp_adjustments_pkg.fetch_p()-');
2278:
2279: EXCEPTION
2280: WHEN OTHERS THEN
2281: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.fetch_p' );

Line 2281: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.fetch_p' );

2277: arp_util.debug('arp_adjustments_pkg.fetch_p()-');
2278:
2279: EXCEPTION
2280: WHEN OTHERS THEN
2281: arp_util.debug( 'EXCEPTION: arp_adjustments_pkg.fetch_p' );
2282: RAISE;
2283: END;
2284:
2285: /*===========================================================================+

Line 2296: | arp_util.debug |

2292: | |
2293: | SCOPE - PUBLIC |
2294: | |
2295: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2296: | arp_util.debug |
2297: | |
2298: | ARGUMENTS : IN: |
2299: | p_adjustment_id - identifies the rows to delete |
2300: | OUT: |

Line 2321: arp_util.debug('arp_adjustments_pkg.delete_p()+');

2317:
2318: BEGIN
2319:
2320:
2321: arp_util.debug('arp_adjustments_pkg.delete_p()+');
2322:
2323: DELETE FROM ar_adjustments
2324: WHERE adjustment_id = p_adjustment_id;
2325:

Line 2337: arp_util.debug('arp_adjustments_pkg.delete_p()-');

2333: p_table_name => 'AR_ADJUSTMENTS',
2334: p_mode => 'SINGLE',
2335: p_key_value => p_adjustment_id);
2336: */
2337: arp_util.debug('arp_adjustments_pkg.delete_p()-');
2338:
2339: EXCEPTION
2340: WHEN OTHERS THEN
2341: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_p()');

Line 2341: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_p()');

2337: arp_util.debug('arp_adjustments_pkg.delete_p()-');
2338:
2339: EXCEPTION
2340: WHEN OTHERS THEN
2341: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_p()');
2342:
2343: RAISE;
2344:
2345: END;

Line 2358: | arp_util.debug |

2354: | |
2355: | SCOPE - PUBLIC |
2356: | |
2357: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2358: | arp_util.debug |
2359: | |
2360: | ARGUMENTS : IN: |
2361: | p_customer_trx_id - identifies the rows to delete |
2362: | OUT: |

Line 2385: arp_util.debug('arp_adjustments_pkg.delete_f_ct_id()+');

2381:
2382: BEGIN
2383:
2384:
2385: arp_util.debug('arp_adjustments_pkg.delete_f_ct_id()+');
2386:
2387: DELETE FROM ar_adjustments
2388: WHERE customer_trx_id = p_customer_trx_id
2389: RETURNING adjustment_id

Line 2404: arp_util.debug('arp_adjustments_pkg.delete_f_ct_id()-');

2400: p_mode => 'BATCH',
2401: p_key_value_list => l_adj_key_value_list);
2402: */
2403:
2404: arp_util.debug('arp_adjustments_pkg.delete_f_ct_id()-');
2405:
2406: EXCEPTION
2407: WHEN OTHERS THEN
2408: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ct_id()');

Line 2408: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ct_id()');

2404: arp_util.debug('arp_adjustments_pkg.delete_f_ct_id()-');
2405:
2406: EXCEPTION
2407: WHEN OTHERS THEN
2408: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ct_id()');
2409:
2410: RAISE;
2411:
2412: END;

Line 2425: | arp_util.debug |

2421: | |
2422: | SCOPE - PUBLIC |
2423: | |
2424: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2425: | arp_util.debug |
2426: | |
2427: | ARGUMENTS : IN: |
2428: | p_subsequent_trx_id - identifies the rows to delete |
2429: | OUT: |

Line 2452: arp_util.debug('arp_adjustments_pkg.delete_f_st_id()+');

2448:
2449: BEGIN
2450:
2451:
2452: arp_util.debug('arp_adjustments_pkg.delete_f_st_id()+');
2453:
2454: DELETE FROM ar_adjustments
2455: WHERE subsequent_trx_id = p_subsequent_trx_id
2456: RETURNING adjustment_id

Line 2471: arp_util.debug('arp_adjustments_pkg.delete_f_st_id()-');

2467: p_mode => 'BATCH',
2468: p_key_value_list => l_adj_key_value_list);
2469: */
2470:
2471: arp_util.debug('arp_adjustments_pkg.delete_f_st_id()-');
2472:
2473: EXCEPTION
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_st_id()');

Line 2475: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_st_id()');

2471: arp_util.debug('arp_adjustments_pkg.delete_f_st_id()-');
2472:
2473: EXCEPTION
2474: WHEN OTHERS THEN
2475: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_st_id()');
2476:
2477: RAISE;
2478:
2479: END;

Line 2493: | arp_util.debug |

2489: | |
2490: | SCOPE - PUBLIC |
2491: | |
2492: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2493: | arp_util.debug |
2494: | |
2495: | ARGUMENTS : IN: |
2496: | p_payment_schedule_id - identifies the rows to delete |
2497: | OUT: |

Line 2520: arp_util.debug('arp_adjustments_pkg.delete_f_ps_id()+');

2516:
2517: BEGIN
2518:
2519:
2520: arp_util.debug('arp_adjustments_pkg.delete_f_ps_id()+');
2521:
2522: DELETE FROM ar_adjustments
2523: WHERE payment_schedule_id = p_payment_schedule_id
2524: RETURNING adjustment_id

Line 2539: arp_util.debug('arp_adjustments_pkg.delete_f_ps_id()-');

2535: p_mode => 'BATCH',
2536: p_key_value_list => l_adj_key_value_list);
2537: */
2538:
2539: arp_util.debug('arp_adjustments_pkg.delete_f_ps_id()-');
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ps_id()');

Line 2543: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ps_id()');

2539: arp_util.debug('arp_adjustments_pkg.delete_f_ps_id()-');
2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ps_id()');
2544:
2545: RAISE;
2546:
2547: END;

Line 2560: | arp_util.debug |

2556: | |
2557: | SCOPE - PUBLIC |
2558: | |
2559: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2560: | arp_util.debug |
2561: | |
2562: | ARGUMENTS : IN: |
2563: | p_customer_trx_line_id - identifies the rows to delete |
2564: | OUT: |

Line 2587: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()+');

2583:
2584: BEGIN
2585:
2586:
2587: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()+');
2588:
2589: DELETE FROM ar_adjustments
2590: WHERE customer_trx_line_id = p_customer_trx_line_id
2591: RETURNING adjustment_id

Line 2605: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()-');

2601: p_table_name => 'AR_ADJUSTMENTS',
2602: p_mode => 'BATCH',
2603: p_key_value_list => l_adj_key_value_list);
2604: */
2605: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()-');
2606:
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ctl_id()');

Line 2609: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ctl_id()');

2605: arp_util.debug('arp_adjustments_pkg.delete_f_ctl_id()-');
2606:
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609: arp_util.debug('EXCEPTION: arp_adjustments_pkg.delete_f_ctl_id()');
2610:
2611: RAISE;
2612:
2613: END;

Line 2626: | arp_util.debug |

2622: | |
2623: | SCOPE - PUBLIC |
2624: | |
2625: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2626: | arp_util.debug |
2627: | |
2628: | ARGUMENTS : IN: |
2629: | p_adjustment_id - identifies the row to update |
2630: | p_exchange_rate |

Line 2655: arp_util.debug('arp_adjustments_pkg.update_p()+ ' ||

2651:
2652:
2653: BEGIN
2654:
2655: arp_util.debug('arp_adjustments_pkg.update_p()+ ' ||
2656: to_char(sysdate, 'HH:MI:SS'));
2657:
2658: arp_adjustments_pkg.generic_update( pg_cursor1,
2659: ' WHERE adjustment_id = :where_1',

Line 2664: arp_util.debug('arp_adjustments_pkg.update_p()- ' ||

2660: p_adjustment_id,
2661: p_exchange_rate,
2662: p_adj_rec);
2663:
2664: arp_util.debug('arp_adjustments_pkg.update_p()- ' ||
2665: to_char(sysdate, 'HH:MI:SS'));
2666:
2667:
2668: EXCEPTION

Line 2670: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_p()');

2666:
2667:
2668: EXCEPTION
2669: WHEN OTHERS THEN
2670: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_p()');
2671: RAISE;
2672: END;
2673:
2674:

Line 2686: | arp_util.debug |

2682: | |
2683: | SCOPE - PUBLIC |
2684: | |
2685: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2686: | arp_util.debug |
2687: | |
2688: | ARGUMENTS : IN: |
2689: | p_customer_trx_id - identifies the rows to update |
2690: | p_exchange_rate |

Line 2714: arp_util.debug('arp_adjustments_pkg.update_f_ct_id()+ ' ||

2710:
2711:
2712: BEGIN
2713:
2714: arp_util.debug('arp_adjustments_pkg.update_f_ct_id()+ ' ||
2715: to_char(sysdate, 'HH:MI:SS'));
2716:
2717: arp_adjustments_pkg.generic_update( pg_cursor2,
2718: ' WHERE customer_trx_id = :where_1',

Line 2723: arp_util.debug('arp_adjustments_pkg.update_f_ct_id()- ' ||

2719: p_customer_trx_id,
2720: p_exchange_rate,
2721: p_adj_rec);
2722:
2723: arp_util.debug('arp_adjustments_pkg.update_f_ct_id()- ' ||
2724: to_char(sysdate, 'HH:MI:SS'));
2725:
2726:
2727: EXCEPTION

Line 2729: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_ct_id()');

2725:
2726:
2727: EXCEPTION
2728: WHEN OTHERS THEN
2729: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_ct_id()');
2730: RAISE;
2731: END;
2732:
2733: /*===========================================================================+

Line 2744: | arp_util.debug |

2740: | |
2741: | SCOPE - PUBLIC |
2742: | |
2743: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2744: | arp_util.debug |
2745: | |
2746: | ARGUMENTS : IN: |
2747: | p_subsequent_trx_id - identifies the rows to update |
2748: | p_exchange_rate |

Line 2771: arp_util.debug('arp_adjustments_pkg.update_f_st_id()+ ' ||

2767: IS
2768:
2769: BEGIN
2770:
2771: arp_util.debug('arp_adjustments_pkg.update_f_st_id()+ ' ||
2772: to_char(sysdate, 'HH:MI:SS'));
2773:
2774: arp_adjustments_pkg.generic_update( pg_cursor3,
2775: ' WHERE subsequent_trx_id = :where_1',

Line 2781: arp_util.debug('arp_adjustments_pkg.update_f_st_id()- ' ||

2777: p_exchange_rate,
2778: p_adj_rec);
2779:
2780:
2781: arp_util.debug('arp_adjustments_pkg.update_f_st_id()- ' ||
2782: to_char(sysdate, 'HH:MI:SS'));
2783:
2784:
2785: EXCEPTION

Line 2787: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_st_id()');

2783:
2784:
2785: EXCEPTION
2786: WHEN OTHERS THEN
2787: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_st_id()');
2788: RAISE;
2789: END;
2790:
2791: /*===========================================================================+

Line 2802: | arp_util.debug |

2798: | |
2799: | SCOPE - PUBLIC |
2800: | |
2801: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2802: | arp_util.debug |
2803: | |
2804: | ARGUMENTS : IN: |
2805: | p_payment_schedule_id - identifies the rows to update |
2806: | p_exchange_rate |

Line 2832: arp_util.debug('arp_adjustments_pkg.update_f_ps_id()+ ' ||

2828:
2829:
2830: BEGIN
2831:
2832: arp_util.debug('arp_adjustments_pkg.update_f_ps_id()+ ' ||
2833: to_char(sysdate, 'HH:MI:SS'));
2834:
2835: arp_adjustments_pkg.generic_update( pg_cursor4,
2836: ' WHERE payment_schedule_id = :where_1',

Line 2841: arp_util.debug('arp_adjustments_pkg.update_f_ps_id()- ' ||

2837: p_payment_schedule_id,
2838: p_exchange_rate,
2839: p_adj_rec);
2840:
2841: arp_util.debug('arp_adjustments_pkg.update_f_ps_id()- ' ||
2842: to_char(sysdate, 'HH:MI:SS'));
2843:
2844:
2845: EXCEPTION

Line 2847: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_ps_id()');

2843:
2844:
2845: EXCEPTION
2846: WHEN OTHERS THEN
2847: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_ps_id()');
2848: RAISE;
2849: END;
2850:
2851:

Line 2863: | arp_util.debug |

2859: | |
2860: | SCOPE - PUBLIC |
2861: | |
2862: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2863: | arp_util.debug |
2864: | |
2865: | ARGUMENTS : IN: |
2866: | p_customer_trx_line_id - identifies the rows to update |
2867: | p_exchange_rate |

Line 2893: arp_util.debug('arp_adjustments_pkg.update_f_ctl_id()+ ' ||

2889:
2890:
2891: BEGIN
2892:
2893: arp_util.debug('arp_adjustments_pkg.update_f_ctl_id()+ ' ||
2894: to_char(sysdate, 'HH:MI:SS'));
2895:
2896: arp_adjustments_pkg.generic_update( pg_cursor5,
2897: ' WHERE customer_trx_line_id = :where_1',

Line 2902: arp_util.debug('arp_adjustments_pkg.update_f_ctl_id()- ' ||

2898: p_customer_trx_line_id,
2899: p_exchange_rate,
2900: p_adj_rec);
2901:
2902: arp_util.debug('arp_adjustments_pkg.update_f_ctl_id()- ' ||
2903: to_char(sysdate, 'HH:MI:SS'));
2904:
2905:
2906: EXCEPTION

Line 2908: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_ctl_id()');

2904:
2905:
2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: arp_util.debug('EXCEPTION: arp_adjustments_pkg.update_f_ctl_id()');
2909: RAISE;
2910: END;
2911:
2912:

Line 2924: | arp_util.debug |

2920: | |
2921: | SCOPE - PUBLIC |
2922: | |
2923: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2924: | arp_util.debug |
2925: | |
2926: | ARGUMENTS : IN: |
2927: | p_adj_rec - contains the new column values |
2928: | OUT: |

Line 2973: arp_util.debug('arp_adjustments_pkg.insert_p()+');

2969: l_adj_post_to_gl_flag ra_cust_trx_types.adj_post_to_gl%type;
2970:
2971: BEGIN
2972:
2973: arp_util.debug('arp_adjustments_pkg.insert_p()+');
2974:
2975: p_adjustment_id := NULL;
2976: p_adjustment_number := NULL;
2977:

Line 3176: arp_util.debug('p_adjustment_id = ' || to_char(p_adjustment_id));

3172:
3173: p_adjustment_id := l_adjustment_id;
3174: p_adjustment_number := l_adjustment_number;
3175:
3176: arp_util.debug('p_adjustment_id = ' || to_char(p_adjustment_id));
3177: arp_util.debug('l_adjust_id = ' || to_char(l_adjustment_id));
3178: /*-------------------------------------------+
3179: | Call central MRC library for insertion |
3180: | into MRC tables |

Line 3177: arp_util.debug('l_adjust_id = ' || to_char(l_adjustment_id));

3173: p_adjustment_id := l_adjustment_id;
3174: p_adjustment_number := l_adjustment_number;
3175:
3176: arp_util.debug('p_adjustment_id = ' || to_char(p_adjustment_id));
3177: arp_util.debug('l_adjust_id = ' || to_char(l_adjustment_id));
3178: /*-------------------------------------------+
3179: | Call central MRC library for insertion |
3180: | into MRC tables |
3181: +-------------------------------------------*/

Line 3189: arp_util.debug('arp_adjustments_pkg.insert_p()-');

3185: p_mode => 'SINGLE',
3186: p_key_value => p_adjustment_id);
3187:
3188: */
3189: arp_util.debug('arp_adjustments_pkg.insert_p()-');
3190:
3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: arp_util.debug('EXCEPTION: arp_adjustments_pkg.insert_p()');

Line 3193: arp_util.debug('EXCEPTION: arp_adjustments_pkg.insert_p()');

3189: arp_util.debug('arp_adjustments_pkg.insert_p()-');
3190:
3191: EXCEPTION
3192: WHEN OTHERS THEN
3193: arp_util.debug('EXCEPTION: arp_adjustments_pkg.insert_p()');
3194: RAISE;
3195: END;
3196:
3197: /*===========================================================================+

Line 3209: | arp_util.debug |

3205: | |
3206: | SCOPE - PUBLIC |
3207: | |
3208: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3209: | arp_util.debug |
3210: | |
3211: | ARGUMENTS : IN: |
3212: | p_old_adj_rec |
3213: | p_new_adj_rec |

Line 3230: arp_util.debug('arp_adjustments_pkg.merge_adj_recs()+');

3226: p_out_adj_rec OUT NOCOPY ar_adjustments%rowtype ) IS
3227:
3228: BEGIN
3229:
3230: arp_util.debug('arp_adjustments_pkg.merge_adj_recs()+');
3231:
3232: IF (p_new_adj_rec.adjustment_id = AR_NUMBER_DUMMY)
3233: THEN p_out_adj_rec.adjustment_id := p_old_adj_rec.adjustment_id;
3234: ELSE p_out_adj_rec.adjustment_id := p_new_adj_rec.adjustment_id;

Line 3576: arp_util.debug('arp_adjustments_pkg.merge_adj_recs()-');

3572: THEN p_out_adj_rec.request_id := p_old_adj_rec.request_id;
3573: ELSE p_out_adj_rec.request_id := p_new_adj_rec.request_id;
3574: END IF;
3575:
3576: arp_util.debug('arp_adjustments_pkg.merge_adj_recs()-');
3577:
3578:
3579: EXCEPTION
3580: WHEN OTHERS THEN

Line 3581: arp_util.debug('EXCEPTION: arp_adjustments_pkg.merge_adj_recs()');

3577:
3578:
3579: EXCEPTION
3580: WHEN OTHERS THEN
3581: arp_util.debug('EXCEPTION: arp_adjustments_pkg.merge_adj_recs()');
3582:
3583: arp_util.debug('------ old adjustment record ------');
3584: arp_adjustments_pkg.display_adj_rec( p_old_adj_rec );
3585: arp_util.debug('');

Line 3583: arp_util.debug('------ old adjustment record ------');

3579: EXCEPTION
3580: WHEN OTHERS THEN
3581: arp_util.debug('EXCEPTION: arp_adjustments_pkg.merge_adj_recs()');
3582:
3583: arp_util.debug('------ old adjustment record ------');
3584: arp_adjustments_pkg.display_adj_rec( p_old_adj_rec );
3585: arp_util.debug('');
3586: arp_util.debug('------ new adjustment record ------');
3587: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );

Line 3585: arp_util.debug('');

3581: arp_util.debug('EXCEPTION: arp_adjustments_pkg.merge_adj_recs()');
3582:
3583: arp_util.debug('------ old adjustment record ------');
3584: arp_adjustments_pkg.display_adj_rec( p_old_adj_rec );
3585: arp_util.debug('');
3586: arp_util.debug('------ new adjustment record ------');
3587: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );
3588: RAISE;
3589:

Line 3586: arp_util.debug('------ new adjustment record ------');

3582:
3583: arp_util.debug('------ old adjustment record ------');
3584: arp_adjustments_pkg.display_adj_rec( p_old_adj_rec );
3585: arp_util.debug('');
3586: arp_util.debug('------ new adjustment record ------');
3587: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );
3588: RAISE;
3589:
3590: END;

Line 3603: | arp_util.debug |

3599: | |
3600: | SCOPE - PRIVATE |
3601: | |
3602: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3603: | arp_util.debug |
3604: | |
3605: | ARGUMENTS : IN: |
3606: | p_adj_rec |
3607: | OUT: |

Line 3623: arp_util.debug('arp_adjustments_pkg.display_adj_rec()+',

3619: PROCEDURE display_adj_rec(
3620: p_adj_rec IN ar_adjustments%rowtype) IS
3621:
3622: BEGIN
3623: arp_util.debug('arp_adjustments_pkg.display_adj_rec()+',
3624: pg_msg_level_debug);
3625:
3626: arp_util.debug('******** Dump of ar_adjustments record *********');
3627:

Line 3626: arp_util.debug(' Dump of ar_adjustments record *');

3622: BEGIN
3623: arp_util.debug('arp_adjustments_pkg.display_adj_rec()+',
3624: pg_msg_level_debug);
3625:
3626: arp_util.debug('******** Dump of ar_adjustments record *********');
3627:
3628: arp_util.debug('adjustment_id : '||
3629: p_adj_rec.adjustment_id);
3630: arp_util.debug('acctd_amount : '||

Line 3628: arp_util.debug('adjustment_id : '||

3624: pg_msg_level_debug);
3625:
3626: arp_util.debug('******** Dump of ar_adjustments record *********');
3627:
3628: arp_util.debug('adjustment_id : '||
3629: p_adj_rec.adjustment_id);
3630: arp_util.debug('acctd_amount : '||
3631: p_adj_rec.acctd_amount);
3632: arp_util.debug('adjustment_type : '||

Line 3630: arp_util.debug('acctd_amount : '||

3626: arp_util.debug('******** Dump of ar_adjustments record *********');
3627:
3628: arp_util.debug('adjustment_id : '||
3629: p_adj_rec.adjustment_id);
3630: arp_util.debug('acctd_amount : '||
3631: p_adj_rec.acctd_amount);
3632: arp_util.debug('adjustment_type : '||
3633: p_adj_rec.adjustment_type);
3634: arp_util.debug('amount : '||

Line 3632: arp_util.debug('adjustment_type : '||

3628: arp_util.debug('adjustment_id : '||
3629: p_adj_rec.adjustment_id);
3630: arp_util.debug('acctd_amount : '||
3631: p_adj_rec.acctd_amount);
3632: arp_util.debug('adjustment_type : '||
3633: p_adj_rec.adjustment_type);
3634: arp_util.debug('amount : '||
3635: p_adj_rec.amount);
3636: arp_util.debug('code_combination_id : '||

Line 3634: arp_util.debug('amount : '||

3630: arp_util.debug('acctd_amount : '||
3631: p_adj_rec.acctd_amount);
3632: arp_util.debug('adjustment_type : '||
3633: p_adj_rec.adjustment_type);
3634: arp_util.debug('amount : '||
3635: p_adj_rec.amount);
3636: arp_util.debug('code_combination_id : '||
3637: p_adj_rec.code_combination_id);
3638: arp_util.debug('created_by : '||

Line 3636: arp_util.debug('code_combination_id : '||

3632: arp_util.debug('adjustment_type : '||
3633: p_adj_rec.adjustment_type);
3634: arp_util.debug('amount : '||
3635: p_adj_rec.amount);
3636: arp_util.debug('code_combination_id : '||
3637: p_adj_rec.code_combination_id);
3638: arp_util.debug('created_by : '||
3639: p_adj_rec.created_by);
3640: arp_util.debug('gl_date : '||

Line 3638: arp_util.debug('created_by : '||

3634: arp_util.debug('amount : '||
3635: p_adj_rec.amount);
3636: arp_util.debug('code_combination_id : '||
3637: p_adj_rec.code_combination_id);
3638: arp_util.debug('created_by : '||
3639: p_adj_rec.created_by);
3640: arp_util.debug('gl_date : '||
3641: p_adj_rec.gl_date);
3642: arp_util.debug('last_updated_by : '||

Line 3640: arp_util.debug('gl_date : '||

3636: arp_util.debug('code_combination_id : '||
3637: p_adj_rec.code_combination_id);
3638: arp_util.debug('created_by : '||
3639: p_adj_rec.created_by);
3640: arp_util.debug('gl_date : '||
3641: p_adj_rec.gl_date);
3642: arp_util.debug('last_updated_by : '||
3643: p_adj_rec.last_updated_by);
3644: arp_util.debug('set_of_books_id : '||

Line 3642: arp_util.debug('last_updated_by : '||

3638: arp_util.debug('created_by : '||
3639: p_adj_rec.created_by);
3640: arp_util.debug('gl_date : '||
3641: p_adj_rec.gl_date);
3642: arp_util.debug('last_updated_by : '||
3643: p_adj_rec.last_updated_by);
3644: arp_util.debug('set_of_books_id : '||
3645: p_adj_rec.set_of_books_id);
3646: arp_util.debug('status : '||

Line 3644: arp_util.debug('set_of_books_id : '||

3640: arp_util.debug('gl_date : '||
3641: p_adj_rec.gl_date);
3642: arp_util.debug('last_updated_by : '||
3643: p_adj_rec.last_updated_by);
3644: arp_util.debug('set_of_books_id : '||
3645: p_adj_rec.set_of_books_id);
3646: arp_util.debug('status : '||
3647: p_adj_rec.status);
3648: arp_util.debug('type : '||

Line 3646: arp_util.debug('status : '||

3642: arp_util.debug('last_updated_by : '||
3643: p_adj_rec.last_updated_by);
3644: arp_util.debug('set_of_books_id : '||
3645: p_adj_rec.set_of_books_id);
3646: arp_util.debug('status : '||
3647: p_adj_rec.status);
3648: arp_util.debug('type : '||
3649: p_adj_rec.type);
3650: arp_util.debug('created_from : '||

Line 3648: arp_util.debug('type : '||

3644: arp_util.debug('set_of_books_id : '||
3645: p_adj_rec.set_of_books_id);
3646: arp_util.debug('status : '||
3647: p_adj_rec.status);
3648: arp_util.debug('type : '||
3649: p_adj_rec.type);
3650: arp_util.debug('created_from : '||
3651: p_adj_rec.created_from);
3652: arp_util.debug('adjustment_number : '||

Line 3650: arp_util.debug('created_from : '||

3646: arp_util.debug('status : '||
3647: p_adj_rec.status);
3648: arp_util.debug('type : '||
3649: p_adj_rec.type);
3650: arp_util.debug('created_from : '||
3651: p_adj_rec.created_from);
3652: arp_util.debug('adjustment_number : '||
3653: p_adj_rec.adjustment_number);
3654: arp_util.debug('apply_date : '||

Line 3652: arp_util.debug('adjustment_number : '||

3648: arp_util.debug('type : '||
3649: p_adj_rec.type);
3650: arp_util.debug('created_from : '||
3651: p_adj_rec.created_from);
3652: arp_util.debug('adjustment_number : '||
3653: p_adj_rec.adjustment_number);
3654: arp_util.debug('apply_date : '||
3655: p_adj_rec.apply_date);
3656: arp_util.debug('approved_by : '||

Line 3654: arp_util.debug('apply_date : '||

3650: arp_util.debug('created_from : '||
3651: p_adj_rec.created_from);
3652: arp_util.debug('adjustment_number : '||
3653: p_adj_rec.adjustment_number);
3654: arp_util.debug('apply_date : '||
3655: p_adj_rec.apply_date);
3656: arp_util.debug('approved_by : '||
3657: p_adj_rec.approved_by);
3658: arp_util.debug('associated_cash_receipt_id : '||

Line 3656: arp_util.debug('approved_by : '||

3652: arp_util.debug('adjustment_number : '||
3653: p_adj_rec.adjustment_number);
3654: arp_util.debug('apply_date : '||
3655: p_adj_rec.apply_date);
3656: arp_util.debug('approved_by : '||
3657: p_adj_rec.approved_by);
3658: arp_util.debug('associated_cash_receipt_id : '||
3659: p_adj_rec.associated_cash_receipt_id);
3660: arp_util.debug('automatically_generated : '||

Line 3658: arp_util.debug('associated_cash_receipt_id : '||

3654: arp_util.debug('apply_date : '||
3655: p_adj_rec.apply_date);
3656: arp_util.debug('approved_by : '||
3657: p_adj_rec.approved_by);
3658: arp_util.debug('associated_cash_receipt_id : '||
3659: p_adj_rec.associated_cash_receipt_id);
3660: arp_util.debug('automatically_generated : '||
3661: p_adj_rec.automatically_generated);
3662: arp_util.debug('batch_id : '||

Line 3660: arp_util.debug('automatically_generated : '||

3656: arp_util.debug('approved_by : '||
3657: p_adj_rec.approved_by);
3658: arp_util.debug('associated_cash_receipt_id : '||
3659: p_adj_rec.associated_cash_receipt_id);
3660: arp_util.debug('automatically_generated : '||
3661: p_adj_rec.automatically_generated);
3662: arp_util.debug('batch_id : '||
3663: p_adj_rec.batch_id);
3664: arp_util.debug('chargeback_customer_trx_id : '||

Line 3662: arp_util.debug('batch_id : '||

3658: arp_util.debug('associated_cash_receipt_id : '||
3659: p_adj_rec.associated_cash_receipt_id);
3660: arp_util.debug('automatically_generated : '||
3661: p_adj_rec.automatically_generated);
3662: arp_util.debug('batch_id : '||
3663: p_adj_rec.batch_id);
3664: arp_util.debug('chargeback_customer_trx_id : '||
3665: p_adj_rec.chargeback_customer_trx_id);
3666: arp_util.debug('comments : '||

Line 3664: arp_util.debug('chargeback_customer_trx_id : '||

3660: arp_util.debug('automatically_generated : '||
3661: p_adj_rec.automatically_generated);
3662: arp_util.debug('batch_id : '||
3663: p_adj_rec.batch_id);
3664: arp_util.debug('chargeback_customer_trx_id : '||
3665: p_adj_rec.chargeback_customer_trx_id);
3666: arp_util.debug('comments : '||
3667: p_adj_rec.comments);
3668: arp_util.debug('customer_trx_id : '||

Line 3666: arp_util.debug('comments : '||

3662: arp_util.debug('batch_id : '||
3663: p_adj_rec.batch_id);
3664: arp_util.debug('chargeback_customer_trx_id : '||
3665: p_adj_rec.chargeback_customer_trx_id);
3666: arp_util.debug('comments : '||
3667: p_adj_rec.comments);
3668: arp_util.debug('customer_trx_id : '||
3669: p_adj_rec.customer_trx_id);
3670: arp_util.debug('customer_trx_line_id : '||

Line 3668: arp_util.debug('customer_trx_id : '||

3664: arp_util.debug('chargeback_customer_trx_id : '||
3665: p_adj_rec.chargeback_customer_trx_id);
3666: arp_util.debug('comments : '||
3667: p_adj_rec.comments);
3668: arp_util.debug('customer_trx_id : '||
3669: p_adj_rec.customer_trx_id);
3670: arp_util.debug('customer_trx_line_id : '||
3671: p_adj_rec.customer_trx_line_id);
3672: arp_util.debug('distribution_set_id : '||

Line 3670: arp_util.debug('customer_trx_line_id : '||

3666: arp_util.debug('comments : '||
3667: p_adj_rec.comments);
3668: arp_util.debug('customer_trx_id : '||
3669: p_adj_rec.customer_trx_id);
3670: arp_util.debug('customer_trx_line_id : '||
3671: p_adj_rec.customer_trx_line_id);
3672: arp_util.debug('distribution_set_id : '||
3673: p_adj_rec.distribution_set_id);
3674: arp_util.debug('freight_adjusted : '||

Line 3672: arp_util.debug('distribution_set_id : '||

3668: arp_util.debug('customer_trx_id : '||
3669: p_adj_rec.customer_trx_id);
3670: arp_util.debug('customer_trx_line_id : '||
3671: p_adj_rec.customer_trx_line_id);
3672: arp_util.debug('distribution_set_id : '||
3673: p_adj_rec.distribution_set_id);
3674: arp_util.debug('freight_adjusted : '||
3675: p_adj_rec.freight_adjusted);
3676: arp_util.debug('gl_posted_date : '||

Line 3674: arp_util.debug('freight_adjusted : '||

3670: arp_util.debug('customer_trx_line_id : '||
3671: p_adj_rec.customer_trx_line_id);
3672: arp_util.debug('distribution_set_id : '||
3673: p_adj_rec.distribution_set_id);
3674: arp_util.debug('freight_adjusted : '||
3675: p_adj_rec.freight_adjusted);
3676: arp_util.debug('gl_posted_date : '||
3677: p_adj_rec.gl_posted_date);
3678: arp_util.debug('last_update_login : '||

Line 3676: arp_util.debug('gl_posted_date : '||

3672: arp_util.debug('distribution_set_id : '||
3673: p_adj_rec.distribution_set_id);
3674: arp_util.debug('freight_adjusted : '||
3675: p_adj_rec.freight_adjusted);
3676: arp_util.debug('gl_posted_date : '||
3677: p_adj_rec.gl_posted_date);
3678: arp_util.debug('last_update_login : '||
3679: p_adj_rec.last_update_login);
3680: arp_util.debug('line_adjusted : '||

Line 3678: arp_util.debug('last_update_login : '||

3674: arp_util.debug('freight_adjusted : '||
3675: p_adj_rec.freight_adjusted);
3676: arp_util.debug('gl_posted_date : '||
3677: p_adj_rec.gl_posted_date);
3678: arp_util.debug('last_update_login : '||
3679: p_adj_rec.last_update_login);
3680: arp_util.debug('line_adjusted : '||
3681: p_adj_rec.line_adjusted);
3682: arp_util.debug('payment_schedule_id : '||

Line 3680: arp_util.debug('line_adjusted : '||

3676: arp_util.debug('gl_posted_date : '||
3677: p_adj_rec.gl_posted_date);
3678: arp_util.debug('last_update_login : '||
3679: p_adj_rec.last_update_login);
3680: arp_util.debug('line_adjusted : '||
3681: p_adj_rec.line_adjusted);
3682: arp_util.debug('payment_schedule_id : '||
3683: p_adj_rec.payment_schedule_id);
3684: arp_util.debug('postable : '||

Line 3682: arp_util.debug('payment_schedule_id : '||

3678: arp_util.debug('last_update_login : '||
3679: p_adj_rec.last_update_login);
3680: arp_util.debug('line_adjusted : '||
3681: p_adj_rec.line_adjusted);
3682: arp_util.debug('payment_schedule_id : '||
3683: p_adj_rec.payment_schedule_id);
3684: arp_util.debug('postable : '||
3685: p_adj_rec.postable);
3686: arp_util.debug('posting_control_id : '||

Line 3684: arp_util.debug('postable : '||

3680: arp_util.debug('line_adjusted : '||
3681: p_adj_rec.line_adjusted);
3682: arp_util.debug('payment_schedule_id : '||
3683: p_adj_rec.payment_schedule_id);
3684: arp_util.debug('postable : '||
3685: p_adj_rec.postable);
3686: arp_util.debug('posting_control_id : '||
3687: p_adj_rec.posting_control_id);
3688: arp_util.debug('reason_code : '||

Line 3686: arp_util.debug('posting_control_id : '||

3682: arp_util.debug('payment_schedule_id : '||
3683: p_adj_rec.payment_schedule_id);
3684: arp_util.debug('postable : '||
3685: p_adj_rec.postable);
3686: arp_util.debug('posting_control_id : '||
3687: p_adj_rec.posting_control_id);
3688: arp_util.debug('reason_code : '||
3689: p_adj_rec.reason_code);
3690: arp_util.debug('receivables_charges_adjusted : '||

Line 3688: arp_util.debug('reason_code : '||

3684: arp_util.debug('postable : '||
3685: p_adj_rec.postable);
3686: arp_util.debug('posting_control_id : '||
3687: p_adj_rec.posting_control_id);
3688: arp_util.debug('reason_code : '||
3689: p_adj_rec.reason_code);
3690: arp_util.debug('receivables_charges_adjusted : '||
3691: p_adj_rec.receivables_charges_adjusted);
3692: arp_util.debug('receivables_trx_id : '||

Line 3690: arp_util.debug('receivables_charges_adjusted : '||

3686: arp_util.debug('posting_control_id : '||
3687: p_adj_rec.posting_control_id);
3688: arp_util.debug('reason_code : '||
3689: p_adj_rec.reason_code);
3690: arp_util.debug('receivables_charges_adjusted : '||
3691: p_adj_rec.receivables_charges_adjusted);
3692: arp_util.debug('receivables_trx_id : '||
3693: p_adj_rec.receivables_trx_id);
3694: arp_util.debug('subsequent_trx_id : '||

Line 3692: arp_util.debug('receivables_trx_id : '||

3688: arp_util.debug('reason_code : '||
3689: p_adj_rec.reason_code);
3690: arp_util.debug('receivables_charges_adjusted : '||
3691: p_adj_rec.receivables_charges_adjusted);
3692: arp_util.debug('receivables_trx_id : '||
3693: p_adj_rec.receivables_trx_id);
3694: arp_util.debug('subsequent_trx_id : '||
3695: p_adj_rec.subsequent_trx_id);
3696: arp_util.debug('tax_adjusted : '||

Line 3694: arp_util.debug('subsequent_trx_id : '||

3690: arp_util.debug('receivables_charges_adjusted : '||
3691: p_adj_rec.receivables_charges_adjusted);
3692: arp_util.debug('receivables_trx_id : '||
3693: p_adj_rec.receivables_trx_id);
3694: arp_util.debug('subsequent_trx_id : '||
3695: p_adj_rec.subsequent_trx_id);
3696: arp_util.debug('tax_adjusted : '||
3697: p_adj_rec.tax_adjusted);
3698: arp_util.debug('attribute_category : '||

Line 3696: arp_util.debug('tax_adjusted : '||

3692: arp_util.debug('receivables_trx_id : '||
3693: p_adj_rec.receivables_trx_id);
3694: arp_util.debug('subsequent_trx_id : '||
3695: p_adj_rec.subsequent_trx_id);
3696: arp_util.debug('tax_adjusted : '||
3697: p_adj_rec.tax_adjusted);
3698: arp_util.debug('attribute_category : '||
3699: p_adj_rec.attribute_category);
3700: arp_util.debug('attribute1 : '||

Line 3698: arp_util.debug('attribute_category : '||

3694: arp_util.debug('subsequent_trx_id : '||
3695: p_adj_rec.subsequent_trx_id);
3696: arp_util.debug('tax_adjusted : '||
3697: p_adj_rec.tax_adjusted);
3698: arp_util.debug('attribute_category : '||
3699: p_adj_rec.attribute_category);
3700: arp_util.debug('attribute1 : '||
3701: p_adj_rec.attribute1);
3702: arp_util.debug('attribute2 : '||

Line 3700: arp_util.debug('attribute1 : '||

3696: arp_util.debug('tax_adjusted : '||
3697: p_adj_rec.tax_adjusted);
3698: arp_util.debug('attribute_category : '||
3699: p_adj_rec.attribute_category);
3700: arp_util.debug('attribute1 : '||
3701: p_adj_rec.attribute1);
3702: arp_util.debug('attribute2 : '||
3703: p_adj_rec.attribute2);
3704: arp_util.debug('attribute3 : '||

Line 3702: arp_util.debug('attribute2 : '||

3698: arp_util.debug('attribute_category : '||
3699: p_adj_rec.attribute_category);
3700: arp_util.debug('attribute1 : '||
3701: p_adj_rec.attribute1);
3702: arp_util.debug('attribute2 : '||
3703: p_adj_rec.attribute2);
3704: arp_util.debug('attribute3 : '||
3705: p_adj_rec.attribute3);
3706: arp_util.debug('attribute4 : '||

Line 3704: arp_util.debug('attribute3 : '||

3700: arp_util.debug('attribute1 : '||
3701: p_adj_rec.attribute1);
3702: arp_util.debug('attribute2 : '||
3703: p_adj_rec.attribute2);
3704: arp_util.debug('attribute3 : '||
3705: p_adj_rec.attribute3);
3706: arp_util.debug('attribute4 : '||
3707: p_adj_rec.attribute4);
3708: arp_util.debug('attribute5 : '||

Line 3706: arp_util.debug('attribute4 : '||

3702: arp_util.debug('attribute2 : '||
3703: p_adj_rec.attribute2);
3704: arp_util.debug('attribute3 : '||
3705: p_adj_rec.attribute3);
3706: arp_util.debug('attribute4 : '||
3707: p_adj_rec.attribute4);
3708: arp_util.debug('attribute5 : '||
3709: p_adj_rec.attribute5);
3710: arp_util.debug('attribute6 : '||

Line 3708: arp_util.debug('attribute5 : '||

3704: arp_util.debug('attribute3 : '||
3705: p_adj_rec.attribute3);
3706: arp_util.debug('attribute4 : '||
3707: p_adj_rec.attribute4);
3708: arp_util.debug('attribute5 : '||
3709: p_adj_rec.attribute5);
3710: arp_util.debug('attribute6 : '||
3711: p_adj_rec.attribute6);
3712: arp_util.debug('attribute7 : '||

Line 3710: arp_util.debug('attribute6 : '||

3706: arp_util.debug('attribute4 : '||
3707: p_adj_rec.attribute4);
3708: arp_util.debug('attribute5 : '||
3709: p_adj_rec.attribute5);
3710: arp_util.debug('attribute6 : '||
3711: p_adj_rec.attribute6);
3712: arp_util.debug('attribute7 : '||
3713: p_adj_rec.attribute7);
3714: arp_util.debug('attribute8 : '||

Line 3712: arp_util.debug('attribute7 : '||

3708: arp_util.debug('attribute5 : '||
3709: p_adj_rec.attribute5);
3710: arp_util.debug('attribute6 : '||
3711: p_adj_rec.attribute6);
3712: arp_util.debug('attribute7 : '||
3713: p_adj_rec.attribute7);
3714: arp_util.debug('attribute8 : '||
3715: p_adj_rec.attribute8);
3716: arp_util.debug('attribute9 : '||

Line 3714: arp_util.debug('attribute8 : '||

3710: arp_util.debug('attribute6 : '||
3711: p_adj_rec.attribute6);
3712: arp_util.debug('attribute7 : '||
3713: p_adj_rec.attribute7);
3714: arp_util.debug('attribute8 : '||
3715: p_adj_rec.attribute8);
3716: arp_util.debug('attribute9 : '||
3717: p_adj_rec.attribute9);
3718: arp_util.debug('attribute10 : '||

Line 3716: arp_util.debug('attribute9 : '||

3712: arp_util.debug('attribute7 : '||
3713: p_adj_rec.attribute7);
3714: arp_util.debug('attribute8 : '||
3715: p_adj_rec.attribute8);
3716: arp_util.debug('attribute9 : '||
3717: p_adj_rec.attribute9);
3718: arp_util.debug('attribute10 : '||
3719: p_adj_rec.attribute10);
3720: arp_util.debug('attribute11 : '||

Line 3718: arp_util.debug('attribute10 : '||

3714: arp_util.debug('attribute8 : '||
3715: p_adj_rec.attribute8);
3716: arp_util.debug('attribute9 : '||
3717: p_adj_rec.attribute9);
3718: arp_util.debug('attribute10 : '||
3719: p_adj_rec.attribute10);
3720: arp_util.debug('attribute11 : '||
3721: p_adj_rec.attribute11);
3722: arp_util.debug('attribute12 : '||

Line 3720: arp_util.debug('attribute11 : '||

3716: arp_util.debug('attribute9 : '||
3717: p_adj_rec.attribute9);
3718: arp_util.debug('attribute10 : '||
3719: p_adj_rec.attribute10);
3720: arp_util.debug('attribute11 : '||
3721: p_adj_rec.attribute11);
3722: arp_util.debug('attribute12 : '||
3723: p_adj_rec.attribute12);
3724: arp_util.debug('attribute13 : '||

Line 3722: arp_util.debug('attribute12 : '||

3718: arp_util.debug('attribute10 : '||
3719: p_adj_rec.attribute10);
3720: arp_util.debug('attribute11 : '||
3721: p_adj_rec.attribute11);
3722: arp_util.debug('attribute12 : '||
3723: p_adj_rec.attribute12);
3724: arp_util.debug('attribute13 : '||
3725: p_adj_rec.attribute13);
3726: arp_util.debug('attribute14 : '||

Line 3724: arp_util.debug('attribute13 : '||

3720: arp_util.debug('attribute11 : '||
3721: p_adj_rec.attribute11);
3722: arp_util.debug('attribute12 : '||
3723: p_adj_rec.attribute12);
3724: arp_util.debug('attribute13 : '||
3725: p_adj_rec.attribute13);
3726: arp_util.debug('attribute14 : '||
3727: p_adj_rec.attribute14);
3728: arp_util.debug('attribute15 : '||

Line 3726: arp_util.debug('attribute14 : '||

3722: arp_util.debug('attribute12 : '||
3723: p_adj_rec.attribute12);
3724: arp_util.debug('attribute13 : '||
3725: p_adj_rec.attribute13);
3726: arp_util.debug('attribute14 : '||
3727: p_adj_rec.attribute14);
3728: arp_util.debug('attribute15 : '||
3729: p_adj_rec.attribute15);
3730: arp_util.debug('ussgl_transaction_code : '||

Line 3728: arp_util.debug('attribute15 : '||

3724: arp_util.debug('attribute13 : '||
3725: p_adj_rec.attribute13);
3726: arp_util.debug('attribute14 : '||
3727: p_adj_rec.attribute14);
3728: arp_util.debug('attribute15 : '||
3729: p_adj_rec.attribute15);
3730: arp_util.debug('ussgl_transaction_code : '||
3731: p_adj_rec.ussgl_transaction_code);
3732: arp_util.debug('ussgl_transaction_code_context : '||

Line 3730: arp_util.debug('ussgl_transaction_code : '||

3726: arp_util.debug('attribute14 : '||
3727: p_adj_rec.attribute14);
3728: arp_util.debug('attribute15 : '||
3729: p_adj_rec.attribute15);
3730: arp_util.debug('ussgl_transaction_code : '||
3731: p_adj_rec.ussgl_transaction_code);
3732: arp_util.debug('ussgl_transaction_code_context : '||
3733: p_adj_rec.ussgl_transaction_code_context);
3734: arp_util.debug('request_id : '||

Line 3732: arp_util.debug('ussgl_transaction_code_context : '||

3728: arp_util.debug('attribute15 : '||
3729: p_adj_rec.attribute15);
3730: arp_util.debug('ussgl_transaction_code : '||
3731: p_adj_rec.ussgl_transaction_code);
3732: arp_util.debug('ussgl_transaction_code_context : '||
3733: p_adj_rec.ussgl_transaction_code_context);
3734: arp_util.debug('request_id : '||
3735: p_adj_rec.request_id);
3736: arp_util.debug('program_update_date : '||

Line 3734: arp_util.debug('request_id : '||

3730: arp_util.debug('ussgl_transaction_code : '||
3731: p_adj_rec.ussgl_transaction_code);
3732: arp_util.debug('ussgl_transaction_code_context : '||
3733: p_adj_rec.ussgl_transaction_code_context);
3734: arp_util.debug('request_id : '||
3735: p_adj_rec.request_id);
3736: arp_util.debug('program_update_date : '||
3737: p_adj_rec.program_update_date);
3738: arp_util.debug('program_id : '||

Line 3736: arp_util.debug('program_update_date : '||

3732: arp_util.debug('ussgl_transaction_code_context : '||
3733: p_adj_rec.ussgl_transaction_code_context);
3734: arp_util.debug('request_id : '||
3735: p_adj_rec.request_id);
3736: arp_util.debug('program_update_date : '||
3737: p_adj_rec.program_update_date);
3738: arp_util.debug('program_id : '||
3739: p_adj_rec.program_id);
3740: arp_util.debug('program_application_id : '||

Line 3738: arp_util.debug('program_id : '||

3734: arp_util.debug('request_id : '||
3735: p_adj_rec.request_id);
3736: arp_util.debug('program_update_date : '||
3737: p_adj_rec.program_update_date);
3738: arp_util.debug('program_id : '||
3739: p_adj_rec.program_id);
3740: arp_util.debug('program_application_id : '||
3741: p_adj_rec.program_application_id);
3742: arp_util.debug('doc_sequence_id : '||

Line 3740: arp_util.debug('program_application_id : '||

3736: arp_util.debug('program_update_date : '||
3737: p_adj_rec.program_update_date);
3738: arp_util.debug('program_id : '||
3739: p_adj_rec.program_id);
3740: arp_util.debug('program_application_id : '||
3741: p_adj_rec.program_application_id);
3742: arp_util.debug('doc_sequence_id : '||
3743: p_adj_rec.doc_sequence_id);
3744: arp_util.debug('doc_sequence_value : '||

Line 3742: arp_util.debug('doc_sequence_id : '||

3738: arp_util.debug('program_id : '||
3739: p_adj_rec.program_id);
3740: arp_util.debug('program_application_id : '||
3741: p_adj_rec.program_application_id);
3742: arp_util.debug('doc_sequence_id : '||
3743: p_adj_rec.doc_sequence_id);
3744: arp_util.debug('doc_sequence_value : '||
3745: p_adj_rec.doc_sequence_value);
3746: arp_util.debug('associated_application_id : '||

Line 3744: arp_util.debug('doc_sequence_value : '||

3740: arp_util.debug('program_application_id : '||
3741: p_adj_rec.program_application_id);
3742: arp_util.debug('doc_sequence_id : '||
3743: p_adj_rec.doc_sequence_id);
3744: arp_util.debug('doc_sequence_value : '||
3745: p_adj_rec.doc_sequence_value);
3746: arp_util.debug('associated_application_id : '||
3747: p_adj_rec.associated_application_id);
3748:

Line 3746: arp_util.debug('associated_application_id : '||

3742: arp_util.debug('doc_sequence_id : '||
3743: p_adj_rec.doc_sequence_id);
3744: arp_util.debug('doc_sequence_value : '||
3745: p_adj_rec.doc_sequence_value);
3746: arp_util.debug('associated_application_id : '||
3747: p_adj_rec.associated_application_id);
3748:
3749: arp_util.debug('arp_adjustments_pkg.display_adj_rec()-',
3750: pg_msg_level_debug);

Line 3749: arp_util.debug('arp_adjustments_pkg.display_adj_rec()-',

3745: p_adj_rec.doc_sequence_value);
3746: arp_util.debug('associated_application_id : '||
3747: p_adj_rec.associated_application_id);
3748:
3749: arp_util.debug('arp_adjustments_pkg.display_adj_rec()-',
3750: pg_msg_level_debug);
3751:
3752: EXCEPTION
3753: WHEN OTHERS THEN

Line 3754: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_rec()');

3750: pg_msg_level_debug);
3751:
3752: EXCEPTION
3753: WHEN OTHERS THEN
3754: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_rec()');
3755: RAISE;
3756: END;
3757:
3758: /*===========================================================================+

Line 3769: | arp_util.debug |

3765: | |
3766: | SCOPE - PUBLIC |
3767: | |
3768: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3769: | arp_util.debug |
3770: | |
3771: | ARGUMENTS : IN: |
3772: | p_adjustment_id |
3773: | OUT: |

Line 3792: arp_util.debug('arp_adjustments_pkg.display_adj_p()+',

3788:
3789: l_adj_rec ar_adjustments%rowtype;
3790:
3791: BEGIN
3792: arp_util.debug('arp_adjustments_pkg.display_adj_p()+',
3793: pg_msg_level_debug);
3794:
3795: fetch_p(l_adj_rec, p_adjustment_id);
3796:

Line 3799: arp_util.debug('arp_adjustments_pkg.display_adj_p()-',

3795: fetch_p(l_adj_rec, p_adjustment_id);
3796:
3797: display_adj_rec(l_adj_rec);
3798:
3799: arp_util.debug('arp_adjustments_pkg.display_adj_p()-',
3800: pg_msg_level_debug);
3801:
3802:
3803: EXCEPTION

Line 3805: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_p()');

3801:
3802:
3803: EXCEPTION
3804: WHEN OTHERS THEN
3805: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_p()');
3806:
3807: arp_util.debug('');
3808: arp_util.debug('-------- parameters for display_adj_p() ------');
3809: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );

Line 3807: arp_util.debug('');

3803: EXCEPTION
3804: WHEN OTHERS THEN
3805: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_p()');
3806:
3807: arp_util.debug('');
3808: arp_util.debug('-------- parameters for display_adj_p() ------');
3809: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );
3810:
3811: RAISE;

Line 3808: arp_util.debug('-------- parameters for display_adj_p() ------');

3804: WHEN OTHERS THEN
3805: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_p()');
3806:
3807: arp_util.debug('');
3808: arp_util.debug('-------- parameters for display_adj_p() ------');
3809: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );
3810:
3811: RAISE;
3812: END;

Line 3809: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );

3805: arp_util.debug('EXCEPTION: arp_adjustments_pkg.display_adj_p()');
3806:
3807: arp_util.debug('');
3808: arp_util.debug('-------- parameters for display_adj_p() ------');
3809: arp_util.debug('p_adjustment_id = ' || p_adjustment_id );
3810:
3811: RAISE;
3812: END;
3813:

Line 3824: | arp_util.debug |

3820: | |
3821: | SCOPE - PUBLIC |
3822: | |
3823: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3824: | arp_util.debug |
3825: | |
3826: | ARGUMENTS : IN: |
3827: | None |
3828: | OUT: |

Line 3844: arp_util.debug('arp_adjustments_pkg.get_text_dummy()+');

3840: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
3841:
3842: BEGIN
3843:
3844: arp_util.debug('arp_adjustments_pkg.get_text_dummy()+');
3845:
3846: arp_util.debug('arp_adjustments_pkg.get_text_dummy()-');
3847:
3848: return(AR_TEXT_DUMMY);

Line 3846: arp_util.debug('arp_adjustments_pkg.get_text_dummy()-');

3842: BEGIN
3843:
3844: arp_util.debug('arp_adjustments_pkg.get_text_dummy()+');
3845:
3846: arp_util.debug('arp_adjustments_pkg.get_text_dummy()-');
3847:
3848: return(AR_TEXT_DUMMY);
3849:
3850: EXCEPTION

Line 3852: arp_util.debug('EXCEPTION: arp_adjustments_pkg.get_text_dummy()');

3848: return(AR_TEXT_DUMMY);
3849:
3850: EXCEPTION
3851: WHEN OTHERS THEN
3852: arp_util.debug('EXCEPTION: arp_adjustments_pkg.get_text_dummy()');
3853: RAISE;
3854:
3855: END;
3856: