38: | SCOPE - PRIVATE |
39: | |
40: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
41: | dbms_sql.bind_variable |
42: | arp_util.debug |
43: | |
44: | ARGUMENTS : IN: |
45: | p_update_cursor - ID of the update cursor |
46: | p_trx_rec - ra_customer_trx record |
84: p_trx_rec IN ra_customer_trx%rowtype) IS
85:
86: BEGIN
87:
88: arp_util.debug('arp_ct_pkg.bind_trx_variables()+');
89:
90: /*------------------+
91: | Dummy constants |
92: +------------------*/
625: dbms_sql.bind_variable(p_update_cursor, ':global_attribute30',
626: p_trx_rec.global_attribute30);
627:
628: /*End of Bug2427456*/
629: arp_util.debug('arp_ct_pkg.bind_trx_variables()-');
630:
631: EXCEPTION
632: WHEN OTHERS THEN
633: arp_util.debug('EXCEPTION: arp_ct_pkg.bind_trx_variables()');
629: arp_util.debug('arp_ct_pkg.bind_trx_variables()-');
630:
631: EXCEPTION
632: WHEN OTHERS THEN
633: arp_util.debug('EXCEPTION: arp_ct_pkg.bind_trx_variables()');
634: RAISE;
635:
636: END;
637:
647: | |
648: | SCOPE - PRIVATE |
649: | |
650: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
651: | arp_util.debug |
652: | |
653: | ARGUMENTS : IN: |
654: | None. |
655: | OUT: |
692:
693: PROCEDURE construct_trx_update_stmt( update_text OUT NOCOPY varchar2) IS
694:
695: BEGIN
696: arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()+');
697:
698: update_text :=
699: 'UPDATE ra_customer_trx
700: SET customer_trx_id =
1251: DECODE(:billing_date,
1252: :ar_date_dummy, billing_date,
1253: :billing_date)';
1254:
1255: arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()-');
1256:
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: arp_util.debug('EXCEPTION: arp_ct_pkg.construct_trx_update_stmt()');
1255: arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()-');
1256:
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: arp_util.debug('EXCEPTION: arp_ct_pkg.construct_trx_update_stmt()');
1260: RAISE;
1261:
1262: END;
1263:
1274: | |
1275: | SCOPE - PRIVATE |
1276: | |
1277: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1278: | arp_util.debug |
1279: | |
1280: | ARGUMENTS : IN: |
1281: | None |
1282: | OUT: |
1291: | |
1292: +===========================================================================*/
1293: PROCEDURE construct_global_attr_stmt( update_text OUT NOCOPY varchar2) IS
1294: BEGIN
1295: arp_util.debug('arp_ct_pkg.construct_global_attr_stmt()+');
1296: update_text := '
1297: ,global_attribute_category =
1298: DECODE(:global_attribute_category,
1299: :ar_text_dummy, global_attribute_category,
1418: DECODE(:global_attribute30,
1419: :ar_text_dummy, global_attribute30,
1420: :global_attribute30)';
1421:
1422: arp_util.debug('arp_ct_pkg.construct_global_attr_stmt()-');
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: arp_util.debug('EXCEPTION: arp_ct_pkg.construct_global_attr_stmt()');
1426: RAISE;
1421:
1422: arp_util.debug('arp_ct_pkg.construct_global_attr_stmt()-');
1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: arp_util.debug('EXCEPTION: arp_ct_pkg.construct_global_attr_stmt()');
1426: RAISE;
1427:
1428: END;
1429:
1439: | |
1440: | SCOPE - PRIVATE |
1441: | |
1442: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1443: | arp_util.debug |
1444: | dbms_sql.open_cursor |
1445: | dbms_sql.parse |
1446: | dbms_sql.execute |
1447: | dbms_sql.close_cursor |
1476: l_update_statement long;
1477: ctrx_array dbms_sql.number_table;
1478:
1479: BEGIN
1480: arp_util.debug('arp_ct_pkg.generic_update()+');
1481:
1482: /*--------------------------------------------------------------+
1483: | If this update statement has not already been parsed, |
1484: | construct the statement and parse it. |
1536: p_where1);
1537:
1538: l_count := dbms_sql.execute(p_update_cursor);
1539:
1540: arp_util.debug( to_char(l_count) || ' rows updated');
1541:
1542: /*------------------------------------------+
1543: | get RETURNING COLUMN into OUT NOCOPY bind array |
1544: +------------------------------------------*/
1567: -- END LOOP;
1568:
1569:
1570:
1571: arp_util.debug('arp_ct_pkg.generic_update()-');
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: arp_util.debug('EXCEPTION: arp_ct_pkg.generic_update()');
1571: arp_util.debug('arp_ct_pkg.generic_update()-');
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: arp_util.debug('EXCEPTION: arp_ct_pkg.generic_update()');
1576: arp_util.debug(l_update_statement);
1577: arp_util.debug('Error at character: ' ||
1578: to_char(dbms_sql.last_error_position));
1579: RAISE;
1572:
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: arp_util.debug('EXCEPTION: arp_ct_pkg.generic_update()');
1576: arp_util.debug(l_update_statement);
1577: arp_util.debug('Error at character: ' ||
1578: to_char(dbms_sql.last_error_position));
1579: RAISE;
1580: END;
1573: EXCEPTION
1574: WHEN OTHERS THEN
1575: arp_util.debug('EXCEPTION: arp_ct_pkg.generic_update()');
1576: arp_util.debug(l_update_statement);
1577: arp_util.debug('Error at character: ' ||
1578: to_char(dbms_sql.last_error_position));
1579: RAISE;
1580: END;
1581:
1595: | |
1596: | SCOPE - PUBLIC |
1597: | |
1598: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1599: | arp_util.debug |
1600: | |
1601: | ARGUMENTS : IN: |
1602: | None |
1603: | OUT: |
1638: PROCEDURE set_to_dummy( p_trx_rec OUT NOCOPY ra_customer_trx%rowtype) IS
1639:
1640: BEGIN
1641:
1642: arp_util.debug('arp_ct_pkg.set_to_dummy()+');
1643:
1644: p_trx_rec.customer_trx_id := AR_NUMBER_DUMMY;
1645: p_trx_rec.trx_number := AR_TEXT_DUMMY;
1646: p_trx_rec.created_by := AR_NUMBER_DUMMY;
1812: /* PAYMENT_UPTAKE */
1813: p_trx_rec.payment_trxn_extension_id := AR_NUMBER_DUMMY;
1814: p_trx_rec.billing_date := AR_DATE_DUMMY;
1815:
1816: arp_util.debug('arp_ct_pkg.set_to_dummy()-');
1817:
1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: arp_util.debug('EXCEPTION: arp_ct_pkg.set_to_dummy()');
1816: arp_util.debug('arp_ct_pkg.set_to_dummy()-');
1817:
1818: EXCEPTION
1819: WHEN OTHERS THEN
1820: arp_util.debug('EXCEPTION: arp_ct_pkg.set_to_dummy()');
1821: RAISE;
1822:
1823: END;
1824:
1833: | |
1834: | SCOPE - PUBLIC |
1835: | |
1836: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1837: | arp_util.debug |
1838: | |
1839: | ARGUMENTS : IN: |
1840: | p_customer_trx_id - identifies the row to lock |
1841: | OUT: |
1855:
1856: l_customer_trx_id ra_customer_trx.customer_trx_id%type;
1857:
1858: BEGIN
1859: arp_util.debug('arp_ct_pkg.lock_p()+');
1860:
1861:
1862: SELECT customer_trx_id
1863: INTO l_customer_trx_id
1864: FROM ra_customer_trx
1865: WHERE customer_trx_id = p_customer_trx_id
1866: FOR UPDATE OF customer_trx_id NOWAIT;
1867:
1868: arp_util.debug('arp_ct_pkg.lock_p()-');
1869:
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_p' );
1868: arp_util.debug('arp_ct_pkg.lock_p()-');
1869:
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_p' );
1873: RAISE;
1874: END;
1875:
1876: /*===========================================================================+
1884: | |
1885: | SCOPE - PUBLIC |
1886: | |
1887: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1888: | arp_util.debug |
1889: | |
1890: | ARGUMENTS : IN: |
1891: | p_customer_trx_id - identifies the row to lock |
1892: | OUT: |
1905: p_customer_trx_id IN
1906: ra_customer_trx.customer_trx_id%type ) IS
1907:
1908: BEGIN
1909: arp_util.debug('arp_ct_pkg.lock_fetch_p()+');
1910:
1911: SELECT *
1912: INTO p_trx_rec
1913: FROM ra_customer_trx
1913: FROM ra_customer_trx
1914: WHERE customer_trx_id = p_customer_trx_id
1915: FOR UPDATE OF customer_trx_id NOWAIT;
1916:
1917: arp_util.debug('arp_ct_pkg.lock_fetch_p()-');
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_fetch_p' );
1917: arp_util.debug('arp_ct_pkg.lock_fetch_p()-');
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_fetch_p' );
1922: RAISE;
1923: END;
1924:
1925: /*============================================================================+
1933: | |
1934: | SCOPE - PUBLIC |
1935: | |
1936: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1937: | arp_util.debug |
1938: | |
1939: | ARGUMENTS : IN: |
1940: | p_customer_trx_id - identifies the row to lock |
1941: | p_trx_rec - trx record for comparison |
1983:
1984: l_new_trx_rec ra_customer_trx%rowtype;
1985:
1986: BEGIN
1987: arp_util.debug('arp_ct_pkg.lock_compare_p()+');
1988:
1989: SELECT *
1990: INTO l_new_trx_rec
1991: FROM ra_customer_trx trx
3328: )
3329:
3330: FOR UPDATE OF customer_trx_id NOWAIT;
3331:
3332: arp_util.debug('arp_ct_pkg.lock_compare_p()-');
3333:
3334: EXCEPTION
3335: WHEN NO_DATA_FOUND THEN
3336: arp_util.debug(
3332: arp_util.debug('arp_ct_pkg.lock_compare_p()-');
3333:
3334: EXCEPTION
3335: WHEN NO_DATA_FOUND THEN
3336: arp_util.debug(
3337: 'EXCEPTION: arp_ct_pkg.lock_compare_p NO_DATA_FOUND' );
3338:
3339: arp_util.debug('');
3340: arp_util.debug('============= Old Record =============');
3335: WHEN NO_DATA_FOUND THEN
3336: arp_util.debug(
3337: 'EXCEPTION: arp_ct_pkg.lock_compare_p NO_DATA_FOUND' );
3338:
3339: arp_util.debug('');
3340: arp_util.debug('============= Old Record =============');
3341: display_header_p(p_customer_trx_id);
3342: arp_util.debug('');
3343: arp_util.debug('============= New Record =============');
3336: arp_util.debug(
3337: 'EXCEPTION: arp_ct_pkg.lock_compare_p NO_DATA_FOUND' );
3338:
3339: arp_util.debug('');
3340: arp_util.debug('============= Old Record =============');
3341: display_header_p(p_customer_trx_id);
3342: arp_util.debug('');
3343: arp_util.debug('============= New Record =============');
3344: display_header_rec(p_trx_rec);
3338:
3339: arp_util.debug('');
3340: arp_util.debug('============= Old Record =============');
3341: display_header_p(p_customer_trx_id);
3342: arp_util.debug('');
3343: arp_util.debug('============= New Record =============');
3344: display_header_rec(p_trx_rec);
3345:
3346: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3339: arp_util.debug('');
3340: arp_util.debug('============= Old Record =============');
3341: display_header_p(p_customer_trx_id);
3342: arp_util.debug('');
3343: arp_util.debug('============= New Record =============');
3344: display_header_rec(p_trx_rec);
3345:
3346: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3347: APP_EXCEPTION.Raise_Exception;
3345:
3346: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
3347: APP_EXCEPTION.Raise_Exception;
3348: WHEN OTHERS THEN
3349: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_compare_p' );
3350: RAISE;
3351: END;
3352:
3353:
3362: | |
3363: | SCOPE - PUBLIC |
3364: | |
3365: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3366: | arp_util.debug |
3367: | |
3368: | ARGUMENTS : IN: |
3369: | p_customer_trx_id - identifies the record to fetch |
3370: | OUT: |
3383: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
3384: IS
3385:
3386: BEGIN
3387: arp_util.debug('arp_ct_pkg.fetch_p()+');
3388:
3389: SELECT *
3390: INTO p_trx_rec
3391: FROM ra_customer_trx
3390: INTO p_trx_rec
3391: FROM ra_customer_trx
3392: WHERE customer_trx_id = p_customer_trx_id;
3393:
3394: arp_util.debug('arp_ct_pkg.fetch_p()-');
3395:
3396: EXCEPTION
3397: WHEN OTHERS THEN
3398: arp_util.debug( 'EXCEPTION: arp_ct_pkg.fetch_p' );
3394: arp_util.debug('arp_ct_pkg.fetch_p()-');
3395:
3396: EXCEPTION
3397: WHEN OTHERS THEN
3398: arp_util.debug( 'EXCEPTION: arp_ct_pkg.fetch_p' );
3399: RAISE;
3400: END;
3401:
3402: /*===========================================================================+
3409: | |
3410: | SCOPE - PUBLIC |
3411: | |
3412: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3413: | arp_util.debug |
3414: | |
3415: | ARGUMENTS : IN: |
3416: | p_customer_trx_id - identifies the row to delete |
3417: | OUT: |
3434:
3435: BEGIN
3436:
3437:
3438: arp_util.debug('arp_ct_pkg.delete_p()+');
3439:
3440: DELETE FROM ra_customer_trx
3441: WHERE customer_trx_id = p_customer_trx_id;
3442:
3451: -- p_mode => 'SINGLE',
3452: -- p_key_value => p_customer_trx_id);
3453: --}
3454: --
3455: arp_util.debug('arp_ct_pkg.delete_p()-');
3456:
3457: EXCEPTION
3458: WHEN OTHERS THEN
3459: arp_util.debug('EXCEPTION: arp_ct_pkg.delete_p()');
3455: arp_util.debug('arp_ct_pkg.delete_p()-');
3456:
3457: EXCEPTION
3458: WHEN OTHERS THEN
3459: arp_util.debug('EXCEPTION: arp_ct_pkg.delete_p()');
3460:
3461: RAISE;
3462:
3463: END;
3472: | |
3473: | SCOPE - PUBLIC |
3474: | |
3475: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3476: | arp_util.debug |
3477: | |
3478: | ARGUMENTS : IN: |
3479: | p_customer_trx_id - identifies the row to update |
3480: | p_trx_rec - contains the new column values |
3500: l_ct_reference varchar2(30);
3501: --2528261 end
3502: BEGIN
3503:
3504: arp_util.debug('arp_ct_pkg.update_p()+ ' ||
3505: to_char(sysdate, 'HH:MI:SS'));
3506:
3507: arp_ct_pkg.generic_update( pg_cursor1,
3508: ' WHERE customer_trx_id = :where_1',
3508: ' WHERE customer_trx_id = :where_1',
3509: p_customer_trx_id,
3510: p_trx_rec);
3511:
3512: arp_util.debug('arp_ct_pkg.update_p()- ' ||
3513: to_char(sysdate, 'HH:MI:SS'));
3514: --2528261 begin
3515: begin
3516: SELECT DECODE(DEFAULT_REFERENCE,
3551:
3552:
3553: EXCEPTION
3554: WHEN OTHERS THEN
3555: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p()');
3556: RAISE;
3557: END;
3558:
3559: /*===========================================================================+
3567: | |
3568: | SCOPE - PUBLIC |
3569: | |
3570: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3571: | arp_util.debug |
3572: | |
3573: | ARGUMENTS : IN: |
3574: | p_customer_trx_id - identifies the row to update |
3575: | p_trx_rec - contains the new column values |
3602: null,
3603: 'PRINT');
3604: EXCEPTION
3605: WHEN OTHERS THEN
3606: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p_print()');
3607: RAISE;
3608: END;
3609:
3610:
3619: | |
3620: | SCOPE - PUBLIC |
3621: | |
3622: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
3623: | arp_util.debug |
3624: | arp_global.set_of_books_id |
3625: | |
3626: | ARGUMENTS : IN: |
3627: | p_trx_rec - contains the new column values |
3688: l_legal_entity_id number;
3689:
3690: BEGIN
3691:
3692: arp_util.debug('arp_ct_pkg.insert_p()+');
3693:
3694: p_trx_number := '';
3695: p_customer_trx_id := '';
3696:
4186:
4187: p_trx_number := l_trx_number;
4188: p_customer_trx_id := l_customer_trx_id;
4189:
4190: arp_util.debug('arp_ct_pkg.insert_p()-');
4191:
4192: EXCEPTION
4193: WHEN OTHERS THEN
4194: arp_util.debug('EXCEPTION: arp_ct_pkg.insert_p()');
4190: arp_util.debug('arp_ct_pkg.insert_p()-');
4191:
4192: EXCEPTION
4193: WHEN OTHERS THEN
4194: arp_util.debug('EXCEPTION: arp_ct_pkg.insert_p()');
4195: RAISE;
4196: END;
4197:
4198: /*===========================================================================+
4205: | |
4206: | SCOPE - PRIVATE |
4207: | |
4208: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4209: | arp_util.debug |
4210: | |
4211: | ARGUMENTS : IN: |
4212: | p_customer_trx_id |
4213: | OUT: |
4228: l_trx_rec ra_customer_trx%rowtype;
4229:
4230: BEGIN
4231:
4232: arp_util.debug('arp_ct_pkg.display_header_p()+');
4233:
4234: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);
4235:
4236: arp_ct_pkg.display_header_rec(l_trx_rec);
4234: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);
4235:
4236: arp_ct_pkg.display_header_rec(l_trx_rec);
4237:
4238: arp_util.debug('arp_ct_pkg.display_header_p()-');
4239:
4240: EXCEPTION
4241: WHEN OTHERS THEN
4242: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_p()');
4238: arp_util.debug('arp_ct_pkg.display_header_p()-');
4239:
4240: EXCEPTION
4241: WHEN OTHERS THEN
4242: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_p()');
4243: RAISE;
4244:
4245: END;
4246:
4254: | |
4255: | SCOPE - PRIVATE |
4256: | |
4257: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4258: | arp_util.debug |
4259: | |
4260: | ARGUMENTS : IN: |
4261: | p_customer_trx_id |
4262: | OUT: |
4294: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype ) IS
4295:
4296: BEGIN
4297:
4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');
4299:
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4296: BEGIN
4297:
4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');
4299:
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4297:
4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');
4299:
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');
4299:
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4299:
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4300: arp_util.debug('************ Dump of ra_customer_trx record ************');
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4301: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4302: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4303: arp_util.debug('created_by: ' || p_trx_rec.created_by);
4304: arp_util.debug('last_updated_by: ' || p_trx_rec.last_updated_by);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4305: arp_util.debug('last_update_login: ' || p_trx_rec.last_update_login);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4306: arp_util.debug('set_of_books_id: ' || p_trx_rec.set_of_books_id);
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4314: arp_util.debug('initial_customer_trx_id: '||
4307: arp_util.debug('program_application_id: ' ||
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4314: arp_util.debug('initial_customer_trx_id: '||
4315: p_trx_rec.initial_customer_trx_id);
4308: p_trx_rec.program_application_id);
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4314: arp_util.debug('initial_customer_trx_id: '||
4315: p_trx_rec.initial_customer_trx_id);
4316: arp_util.debug('previous_customer_trx_id: ' ||
4309: arp_util.debug('program_id: ' || p_trx_rec.program_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4314: arp_util.debug('initial_customer_trx_id: '||
4315: p_trx_rec.initial_customer_trx_id);
4316: arp_util.debug('previous_customer_trx_id: ' ||
4317: p_trx_rec.previous_customer_trx_id);
4310: arp_util.debug('program_update_date: ' || p_trx_rec.program_update_date);
4311: arp_util.debug('posting_control_id: ' || p_trx_rec.posting_control_id);
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4314: arp_util.debug('initial_customer_trx_id: '||
4315: p_trx_rec.initial_customer_trx_id);
4316: arp_util.debug('previous_customer_trx_id: ' ||
4317: p_trx_rec.previous_customer_trx_id);
4318: arp_util.debug('related_customer_trx_id: '||
4312: arp_util.debug('ra_post_loop_number: ' || p_trx_rec.ra_post_loop_number);
4313: arp_util.debug('complete_flag: ' || p_trx_rec.complete_flag);
4314: arp_util.debug('initial_customer_trx_id: '||
4315: p_trx_rec.initial_customer_trx_id);
4316: arp_util.debug('previous_customer_trx_id: ' ||
4317: p_trx_rec.previous_customer_trx_id);
4318: arp_util.debug('related_customer_trx_id: '||
4319: p_trx_rec.related_customer_trx_id);
4320: arp_util.debug('recurred_from_trx_number: ' ||
4314: arp_util.debug('initial_customer_trx_id: '||
4315: p_trx_rec.initial_customer_trx_id);
4316: arp_util.debug('previous_customer_trx_id: ' ||
4317: p_trx_rec.previous_customer_trx_id);
4318: arp_util.debug('related_customer_trx_id: '||
4319: p_trx_rec.related_customer_trx_id);
4320: arp_util.debug('recurred_from_trx_number: ' ||
4321: p_trx_rec.recurred_from_trx_number);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4316: arp_util.debug('previous_customer_trx_id: ' ||
4317: p_trx_rec.previous_customer_trx_id);
4318: arp_util.debug('related_customer_trx_id: '||
4319: p_trx_rec.related_customer_trx_id);
4320: arp_util.debug('recurred_from_trx_number: ' ||
4321: p_trx_rec.recurred_from_trx_number);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4318: arp_util.debug('related_customer_trx_id: '||
4319: p_trx_rec.related_customer_trx_id);
4320: arp_util.debug('recurred_from_trx_number: ' ||
4321: p_trx_rec.recurred_from_trx_number);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4319: p_trx_rec.related_customer_trx_id);
4320: arp_util.debug('recurred_from_trx_number: ' ||
4321: p_trx_rec.recurred_from_trx_number);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4320: arp_util.debug('recurred_from_trx_number: ' ||
4321: p_trx_rec.recurred_from_trx_number);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4321: p_trx_rec.recurred_from_trx_number);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4322: arp_util.debug('cust_trx_type_id: ' || p_trx_rec.cust_trx_type_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4323: arp_util.debug('batch_id: ' || p_trx_rec.batch_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4324: arp_util.debug('batch_source_id: ' || p_trx_rec.batch_source_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4325: arp_util.debug('agreement_id: ' || p_trx_rec.agreement_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4326: arp_util.debug('trx_date: ' || p_trx_rec.trx_date);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4327: arp_util.debug('bill_to_customer_id: ' || p_trx_rec.bill_to_customer_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4328: arp_util.debug('bill_to_contact_id: ' || p_trx_rec.bill_to_contact_id);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4329: arp_util.debug('bill_to_site_use_id: ' || p_trx_rec.bill_to_site_use_id);
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4337: arp_util.debug('customer_reference_date: '||
4330: arp_util.debug('ship_to_customer_id: ' || p_trx_rec.ship_to_customer_id);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4337: arp_util.debug('customer_reference_date: '||
4338: p_trx_rec.customer_reference_date);
4331: arp_util.debug('ship_to_contact_id: ' || p_trx_rec.ship_to_contact_id);
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4337: arp_util.debug('customer_reference_date: '||
4338: p_trx_rec.customer_reference_date);
4339: arp_util.debug('credit_method_for_installments: ' ||
4332: arp_util.debug('ship_to_site_use_id: ' || p_trx_rec.ship_to_site_use_id);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4337: arp_util.debug('customer_reference_date: '||
4338: p_trx_rec.customer_reference_date);
4339: arp_util.debug('credit_method_for_installments: ' ||
4340: p_trx_rec.credit_method_for_installments);
4333: arp_util.debug('sold_to_customer_id: ' || p_trx_rec.sold_to_customer_id);
4334: arp_util.debug('sold_to_site_use_id: ' || p_trx_rec.sold_to_site_use_id);
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4337: arp_util.debug('customer_reference_date: '||
4338: p_trx_rec.customer_reference_date);
4339: arp_util.debug('credit_method_for_installments: ' ||
4340: p_trx_rec.credit_method_for_installments);
4341: arp_util.debug('credit_method_for_rules: ' ||
4335: arp_util.debug('sold_to_contact_id: ' || p_trx_rec.sold_to_contact_id);
4336: arp_util.debug('customer_reference: ' || p_trx_rec.customer_reference);
4337: arp_util.debug('customer_reference_date: '||
4338: p_trx_rec.customer_reference_date);
4339: arp_util.debug('credit_method_for_installments: ' ||
4340: p_trx_rec.credit_method_for_installments);
4341: arp_util.debug('credit_method_for_rules: ' ||
4342: p_trx_rec.credit_method_for_rules);
4343: arp_util.debug('start_date_commitment: ' ||
4337: arp_util.debug('customer_reference_date: '||
4338: p_trx_rec.customer_reference_date);
4339: arp_util.debug('credit_method_for_installments: ' ||
4340: p_trx_rec.credit_method_for_installments);
4341: arp_util.debug('credit_method_for_rules: ' ||
4342: p_trx_rec.credit_method_for_rules);
4343: arp_util.debug('start_date_commitment: ' ||
4344: p_trx_rec.start_date_commitment);
4345: arp_util.debug('end_date_commitment: ' ||
4339: arp_util.debug('credit_method_for_installments: ' ||
4340: p_trx_rec.credit_method_for_installments);
4341: arp_util.debug('credit_method_for_rules: ' ||
4342: p_trx_rec.credit_method_for_rules);
4343: arp_util.debug('start_date_commitment: ' ||
4344: p_trx_rec.start_date_commitment);
4345: arp_util.debug('end_date_commitment: ' ||
4346: p_trx_rec.end_date_commitment);
4347: arp_util.debug('exchange_date: ' || p_trx_rec.exchange_date);
4341: arp_util.debug('credit_method_for_rules: ' ||
4342: p_trx_rec.credit_method_for_rules);
4343: arp_util.debug('start_date_commitment: ' ||
4344: p_trx_rec.start_date_commitment);
4345: arp_util.debug('end_date_commitment: ' ||
4346: p_trx_rec.end_date_commitment);
4347: arp_util.debug('exchange_date: ' || p_trx_rec.exchange_date);
4348: arp_util.debug('exchange_rate: ' || p_trx_rec.exchange_rate);
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4343: arp_util.debug('start_date_commitment: ' ||
4344: p_trx_rec.start_date_commitment);
4345: arp_util.debug('end_date_commitment: ' ||
4346: p_trx_rec.end_date_commitment);
4347: arp_util.debug('exchange_date: ' || p_trx_rec.exchange_date);
4348: arp_util.debug('exchange_rate: ' || p_trx_rec.exchange_rate);
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4344: p_trx_rec.start_date_commitment);
4345: arp_util.debug('end_date_commitment: ' ||
4346: p_trx_rec.end_date_commitment);
4347: arp_util.debug('exchange_date: ' || p_trx_rec.exchange_date);
4348: arp_util.debug('exchange_rate: ' || p_trx_rec.exchange_rate);
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4345: arp_util.debug('end_date_commitment: ' ||
4346: p_trx_rec.end_date_commitment);
4347: arp_util.debug('exchange_date: ' || p_trx_rec.exchange_date);
4348: arp_util.debug('exchange_rate: ' || p_trx_rec.exchange_rate);
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4346: p_trx_rec.end_date_commitment);
4347: arp_util.debug('exchange_date: ' || p_trx_rec.exchange_date);
4348: arp_util.debug('exchange_rate: ' || p_trx_rec.exchange_rate);
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4348: arp_util.debug('exchange_rate: ' || p_trx_rec.exchange_rate);
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4349: arp_util.debug('exchange_rate_type: ' || p_trx_rec.exchange_rate_type);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4357: p_trx_rec.invoice_currency_code);
4350: arp_util.debug('customer_bank_account_id: '||
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4357: p_trx_rec.invoice_currency_code);
4358: arp_util.debug('invoicing_rule_id: ' || p_trx_rec.invoicing_rule_id);
4351: p_trx_rec.customer_bank_account_id);
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4357: p_trx_rec.invoice_currency_code);
4358: arp_util.debug('invoicing_rule_id: ' || p_trx_rec.invoicing_rule_id);
4359: arp_util.debug('last_printed_sequence_num: ' ||
4352: arp_util.debug('finance_charges: ' || p_trx_rec.finance_charges);
4353: arp_util.debug('fob_point: ' || p_trx_rec.fob_point);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4357: p_trx_rec.invoice_currency_code);
4358: arp_util.debug('invoicing_rule_id: ' || p_trx_rec.invoicing_rule_id);
4359: arp_util.debug('last_printed_sequence_num: ' ||
4360: p_trx_rec.last_printed_sequence_num);
4354: arp_util.debug('comments: ' || p_trx_rec.comments);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4357: p_trx_rec.invoice_currency_code);
4358: arp_util.debug('invoicing_rule_id: ' || p_trx_rec.invoicing_rule_id);
4359: arp_util.debug('last_printed_sequence_num: ' ||
4360: p_trx_rec.last_printed_sequence_num);
4361: arp_util.debug('orig_system_batch_name: ' ||
4362: p_trx_rec.orig_system_batch_name);
4355: arp_util.debug('internal_notes: ' || p_trx_rec.internal_notes);
4356: arp_util.debug('invoice_currency_code: ' ||
4357: p_trx_rec.invoice_currency_code);
4358: arp_util.debug('invoicing_rule_id: ' || p_trx_rec.invoicing_rule_id);
4359: arp_util.debug('last_printed_sequence_num: ' ||
4360: p_trx_rec.last_printed_sequence_num);
4361: arp_util.debug('orig_system_batch_name: ' ||
4362: p_trx_rec.orig_system_batch_name);
4363: arp_util.debug('primary_salesrep_id: ' ||
4357: p_trx_rec.invoice_currency_code);
4358: arp_util.debug('invoicing_rule_id: ' || p_trx_rec.invoicing_rule_id);
4359: arp_util.debug('last_printed_sequence_num: ' ||
4360: p_trx_rec.last_printed_sequence_num);
4361: arp_util.debug('orig_system_batch_name: ' ||
4362: p_trx_rec.orig_system_batch_name);
4363: arp_util.debug('primary_salesrep_id: ' ||
4364: p_trx_rec.primary_salesrep_id);
4365: arp_util.debug('printing_count: ' || p_trx_rec.printing_count);
4359: arp_util.debug('last_printed_sequence_num: ' ||
4360: p_trx_rec.last_printed_sequence_num);
4361: arp_util.debug('orig_system_batch_name: ' ||
4362: p_trx_rec.orig_system_batch_name);
4363: arp_util.debug('primary_salesrep_id: ' ||
4364: p_trx_rec.primary_salesrep_id);
4365: arp_util.debug('printing_count: ' || p_trx_rec.printing_count);
4366: arp_util.debug('printing_last_printed: ' ||
4367: p_trx_rec.printing_last_printed);
4361: arp_util.debug('orig_system_batch_name: ' ||
4362: p_trx_rec.orig_system_batch_name);
4363: arp_util.debug('primary_salesrep_id: ' ||
4364: p_trx_rec.primary_salesrep_id);
4365: arp_util.debug('printing_count: ' || p_trx_rec.printing_count);
4366: arp_util.debug('printing_last_printed: ' ||
4367: p_trx_rec.printing_last_printed);
4368: arp_util.debug('printing_option: ' || p_trx_rec.printing_option);
4369: arp_util.debug('printing_original_date: ' ||
4362: p_trx_rec.orig_system_batch_name);
4363: arp_util.debug('primary_salesrep_id: ' ||
4364: p_trx_rec.primary_salesrep_id);
4365: arp_util.debug('printing_count: ' || p_trx_rec.printing_count);
4366: arp_util.debug('printing_last_printed: ' ||
4367: p_trx_rec.printing_last_printed);
4368: arp_util.debug('printing_option: ' || p_trx_rec.printing_option);
4369: arp_util.debug('printing_original_date: ' ||
4370: p_trx_rec.printing_original_date);
4364: p_trx_rec.primary_salesrep_id);
4365: arp_util.debug('printing_count: ' || p_trx_rec.printing_count);
4366: arp_util.debug('printing_last_printed: ' ||
4367: p_trx_rec.printing_last_printed);
4368: arp_util.debug('printing_option: ' || p_trx_rec.printing_option);
4369: arp_util.debug('printing_original_date: ' ||
4370: p_trx_rec.printing_original_date);
4371: arp_util.debug('printing_pending: ' || p_trx_rec.printing_pending);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4365: arp_util.debug('printing_count: ' || p_trx_rec.printing_count);
4366: arp_util.debug('printing_last_printed: ' ||
4367: p_trx_rec.printing_last_printed);
4368: arp_util.debug('printing_option: ' || p_trx_rec.printing_option);
4369: arp_util.debug('printing_original_date: ' ||
4370: p_trx_rec.printing_original_date);
4371: arp_util.debug('printing_pending: ' || p_trx_rec.printing_pending);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4367: p_trx_rec.printing_last_printed);
4368: arp_util.debug('printing_option: ' || p_trx_rec.printing_option);
4369: arp_util.debug('printing_original_date: ' ||
4370: p_trx_rec.printing_original_date);
4371: arp_util.debug('printing_pending: ' || p_trx_rec.printing_pending);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4368: arp_util.debug('printing_option: ' || p_trx_rec.printing_option);
4369: arp_util.debug('printing_original_date: ' ||
4370: p_trx_rec.printing_original_date);
4371: arp_util.debug('printing_pending: ' || p_trx_rec.printing_pending);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4369: arp_util.debug('printing_original_date: ' ||
4370: p_trx_rec.printing_original_date);
4371: arp_util.debug('printing_pending: ' || p_trx_rec.printing_pending);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4370: p_trx_rec.printing_original_date);
4371: arp_util.debug('printing_pending: ' || p_trx_rec.printing_pending);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4372: arp_util.debug('purchase_order: ' || p_trx_rec.purchase_order);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4373: arp_util.debug('purchase_order_date: ' || p_trx_rec.purchase_order_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4374: arp_util.debug('purchase_order_revision: ' ||
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4375: p_trx_rec.purchase_order_revision);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4376: arp_util.debug('receipt_method_id: ' || p_trx_rec.receipt_method_id);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4377: arp_util.debug('remit_to_address_id: ' || p_trx_rec.remit_to_address_id);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4378: arp_util.debug('shipment_id: ' || p_trx_rec.shipment_id);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4379: arp_util.debug('ship_date_actual: ' || p_trx_rec.ship_date_actual);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4380: arp_util.debug('ship_via: ' || p_trx_rec.ship_via);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4381: arp_util.debug('term_due_date: ' || p_trx_rec.term_due_date);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4382: arp_util.debug('term_id: ' || p_trx_rec.term_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4383: arp_util.debug('territory_id: ' || p_trx_rec.territory_id);
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4391: arp_util.debug('related_batch_source_id: '||
4384: arp_util.debug('waybill_number: ' || p_trx_rec.waybill_number);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4391: arp_util.debug('related_batch_source_id: '||
4392: p_trx_rec.related_batch_source_id);
4385: arp_util.debug('status_trx: ' || p_trx_rec.status_trx);
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4391: arp_util.debug('related_batch_source_id: '||
4392: p_trx_rec.related_batch_source_id);
4393: arp_util.debug('default_tax_exempt_flag: '||
4386: arp_util.debug('reason_code: ' || p_trx_rec.reason_code);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4391: arp_util.debug('related_batch_source_id: '||
4392: p_trx_rec.related_batch_source_id);
4393: arp_util.debug('default_tax_exempt_flag: '||
4394: p_trx_rec.default_tax_exempt_flag);
4387: arp_util.debug('doc_sequence_id: ' || p_trx_rec.doc_sequence_id);
4388: arp_util.debug('doc_sequence_value: ' || p_trx_rec.doc_sequence_value);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4391: arp_util.debug('related_batch_source_id: '||
4392: p_trx_rec.related_batch_source_id);
4393: arp_util.debug('default_tax_exempt_flag: '||
4394: p_trx_rec.default_tax_exempt_flag);
4395: arp_util.debug('created_from: ' || p_trx_rec.created_from);
4389: arp_util.debug('paying_customer_id: ' || p_trx_rec.paying_customer_id);
4390: arp_util.debug('paying_site_use_id: ' || p_trx_rec.paying_site_use_id);
4391: arp_util.debug('related_batch_source_id: '||
4392: p_trx_rec.related_batch_source_id);
4393: arp_util.debug('default_tax_exempt_flag: '||
4394: p_trx_rec.default_tax_exempt_flag);
4395: arp_util.debug('created_from: ' || p_trx_rec.created_from);
4396: arp_util.debug('default_ussgl_trx_code_context: ' ||
4397: p_trx_rec.default_ussgl_trx_code_context);
4391: arp_util.debug('related_batch_source_id: '||
4392: p_trx_rec.related_batch_source_id);
4393: arp_util.debug('default_tax_exempt_flag: '||
4394: p_trx_rec.default_tax_exempt_flag);
4395: arp_util.debug('created_from: ' || p_trx_rec.created_from);
4396: arp_util.debug('default_ussgl_trx_code_context: ' ||
4397: p_trx_rec.default_ussgl_trx_code_context);
4398: arp_util.debug('default_ussgl_transaction_code: ' ||
4399: p_trx_rec.default_ussgl_transaction_code);
4392: p_trx_rec.related_batch_source_id);
4393: arp_util.debug('default_tax_exempt_flag: '||
4394: p_trx_rec.default_tax_exempt_flag);
4395: arp_util.debug('created_from: ' || p_trx_rec.created_from);
4396: arp_util.debug('default_ussgl_trx_code_context: ' ||
4397: p_trx_rec.default_ussgl_trx_code_context);
4398: arp_util.debug('default_ussgl_transaction_code: ' ||
4399: p_trx_rec.default_ussgl_transaction_code);
4400: arp_util.debug('old_trx_number: ' || p_trx_rec.old_trx_number);
4394: p_trx_rec.default_tax_exempt_flag);
4395: arp_util.debug('created_from: ' || p_trx_rec.created_from);
4396: arp_util.debug('default_ussgl_trx_code_context: ' ||
4397: p_trx_rec.default_ussgl_trx_code_context);
4398: arp_util.debug('default_ussgl_transaction_code: ' ||
4399: p_trx_rec.default_ussgl_transaction_code);
4400: arp_util.debug('old_trx_number: ' || p_trx_rec.old_trx_number);
4401: arp_util.debug('interface_header_context: ' ||
4402: p_trx_rec.interface_header_context);
4396: arp_util.debug('default_ussgl_trx_code_context: ' ||
4397: p_trx_rec.default_ussgl_trx_code_context);
4398: arp_util.debug('default_ussgl_transaction_code: ' ||
4399: p_trx_rec.default_ussgl_transaction_code);
4400: arp_util.debug('old_trx_number: ' || p_trx_rec.old_trx_number);
4401: arp_util.debug('interface_header_context: ' ||
4402: p_trx_rec.interface_header_context);
4403: arp_util.debug('interface_header_attribute1: ' ||
4404: p_trx_rec.interface_header_attribute1);
4397: p_trx_rec.default_ussgl_trx_code_context);
4398: arp_util.debug('default_ussgl_transaction_code: ' ||
4399: p_trx_rec.default_ussgl_transaction_code);
4400: arp_util.debug('old_trx_number: ' || p_trx_rec.old_trx_number);
4401: arp_util.debug('interface_header_context: ' ||
4402: p_trx_rec.interface_header_context);
4403: arp_util.debug('interface_header_attribute1: ' ||
4404: p_trx_rec.interface_header_attribute1);
4405: arp_util.debug('interface_header_attribute2: ' ||
4399: p_trx_rec.default_ussgl_transaction_code);
4400: arp_util.debug('old_trx_number: ' || p_trx_rec.old_trx_number);
4401: arp_util.debug('interface_header_context: ' ||
4402: p_trx_rec.interface_header_context);
4403: arp_util.debug('interface_header_attribute1: ' ||
4404: p_trx_rec.interface_header_attribute1);
4405: arp_util.debug('interface_header_attribute2: ' ||
4406: p_trx_rec.interface_header_attribute2);
4407: arp_util.debug('interface_header_attribute3: ' ||
4401: arp_util.debug('interface_header_context: ' ||
4402: p_trx_rec.interface_header_context);
4403: arp_util.debug('interface_header_attribute1: ' ||
4404: p_trx_rec.interface_header_attribute1);
4405: arp_util.debug('interface_header_attribute2: ' ||
4406: p_trx_rec.interface_header_attribute2);
4407: arp_util.debug('interface_header_attribute3: ' ||
4408: p_trx_rec.interface_header_attribute3);
4409: arp_util.debug('interface_header_attribute4: ' ||
4403: arp_util.debug('interface_header_attribute1: ' ||
4404: p_trx_rec.interface_header_attribute1);
4405: arp_util.debug('interface_header_attribute2: ' ||
4406: p_trx_rec.interface_header_attribute2);
4407: arp_util.debug('interface_header_attribute3: ' ||
4408: p_trx_rec.interface_header_attribute3);
4409: arp_util.debug('interface_header_attribute4: ' ||
4410: p_trx_rec.interface_header_attribute4);
4411: arp_util.debug('interface_header_attribute5: ' ||
4405: arp_util.debug('interface_header_attribute2: ' ||
4406: p_trx_rec.interface_header_attribute2);
4407: arp_util.debug('interface_header_attribute3: ' ||
4408: p_trx_rec.interface_header_attribute3);
4409: arp_util.debug('interface_header_attribute4: ' ||
4410: p_trx_rec.interface_header_attribute4);
4411: arp_util.debug('interface_header_attribute5: ' ||
4412: p_trx_rec.interface_header_attribute5);
4413: arp_util.debug('interface_header_attribute6: ' ||
4407: arp_util.debug('interface_header_attribute3: ' ||
4408: p_trx_rec.interface_header_attribute3);
4409: arp_util.debug('interface_header_attribute4: ' ||
4410: p_trx_rec.interface_header_attribute4);
4411: arp_util.debug('interface_header_attribute5: ' ||
4412: p_trx_rec.interface_header_attribute5);
4413: arp_util.debug('interface_header_attribute6: ' ||
4414: p_trx_rec.interface_header_attribute6);
4415: arp_util.debug('interface_header_attribute7: ' ||
4409: arp_util.debug('interface_header_attribute4: ' ||
4410: p_trx_rec.interface_header_attribute4);
4411: arp_util.debug('interface_header_attribute5: ' ||
4412: p_trx_rec.interface_header_attribute5);
4413: arp_util.debug('interface_header_attribute6: ' ||
4414: p_trx_rec.interface_header_attribute6);
4415: arp_util.debug('interface_header_attribute7: ' ||
4416: p_trx_rec.interface_header_attribute7);
4417: arp_util.debug('interface_header_attribute8: ' ||
4411: arp_util.debug('interface_header_attribute5: ' ||
4412: p_trx_rec.interface_header_attribute5);
4413: arp_util.debug('interface_header_attribute6: ' ||
4414: p_trx_rec.interface_header_attribute6);
4415: arp_util.debug('interface_header_attribute7: ' ||
4416: p_trx_rec.interface_header_attribute7);
4417: arp_util.debug('interface_header_attribute8: ' ||
4418: p_trx_rec.interface_header_attribute8);
4419: arp_util.debug('interface_header_attribute9: ' ||
4413: arp_util.debug('interface_header_attribute6: ' ||
4414: p_trx_rec.interface_header_attribute6);
4415: arp_util.debug('interface_header_attribute7: ' ||
4416: p_trx_rec.interface_header_attribute7);
4417: arp_util.debug('interface_header_attribute8: ' ||
4418: p_trx_rec.interface_header_attribute8);
4419: arp_util.debug('interface_header_attribute9: ' ||
4420: p_trx_rec.interface_header_attribute9);
4421: arp_util.debug('interface_header_attribute10: '||
4415: arp_util.debug('interface_header_attribute7: ' ||
4416: p_trx_rec.interface_header_attribute7);
4417: arp_util.debug('interface_header_attribute8: ' ||
4418: p_trx_rec.interface_header_attribute8);
4419: arp_util.debug('interface_header_attribute9: ' ||
4420: p_trx_rec.interface_header_attribute9);
4421: arp_util.debug('interface_header_attribute10: '||
4422: p_trx_rec.interface_header_attribute10);
4423: arp_util.debug('interface_header_attribute11: '||
4417: arp_util.debug('interface_header_attribute8: ' ||
4418: p_trx_rec.interface_header_attribute8);
4419: arp_util.debug('interface_header_attribute9: ' ||
4420: p_trx_rec.interface_header_attribute9);
4421: arp_util.debug('interface_header_attribute10: '||
4422: p_trx_rec.interface_header_attribute10);
4423: arp_util.debug('interface_header_attribute11: '||
4424: p_trx_rec.interface_header_attribute11);
4425: arp_util.debug('interface_header_attribute12: '||
4419: arp_util.debug('interface_header_attribute9: ' ||
4420: p_trx_rec.interface_header_attribute9);
4421: arp_util.debug('interface_header_attribute10: '||
4422: p_trx_rec.interface_header_attribute10);
4423: arp_util.debug('interface_header_attribute11: '||
4424: p_trx_rec.interface_header_attribute11);
4425: arp_util.debug('interface_header_attribute12: '||
4426: p_trx_rec.interface_header_attribute12);
4427: arp_util.debug('interface_header_attribute13: '||
4421: arp_util.debug('interface_header_attribute10: '||
4422: p_trx_rec.interface_header_attribute10);
4423: arp_util.debug('interface_header_attribute11: '||
4424: p_trx_rec.interface_header_attribute11);
4425: arp_util.debug('interface_header_attribute12: '||
4426: p_trx_rec.interface_header_attribute12);
4427: arp_util.debug('interface_header_attribute13: '||
4428: p_trx_rec.interface_header_attribute13);
4429: arp_util.debug('interface_header_attribute14: '||
4423: arp_util.debug('interface_header_attribute11: '||
4424: p_trx_rec.interface_header_attribute11);
4425: arp_util.debug('interface_header_attribute12: '||
4426: p_trx_rec.interface_header_attribute12);
4427: arp_util.debug('interface_header_attribute13: '||
4428: p_trx_rec.interface_header_attribute13);
4429: arp_util.debug('interface_header_attribute14: '||
4430: p_trx_rec.interface_header_attribute14);
4431: arp_util.debug('interface_header_attribute15: '||
4425: arp_util.debug('interface_header_attribute12: '||
4426: p_trx_rec.interface_header_attribute12);
4427: arp_util.debug('interface_header_attribute13: '||
4428: p_trx_rec.interface_header_attribute13);
4429: arp_util.debug('interface_header_attribute14: '||
4430: p_trx_rec.interface_header_attribute14);
4431: arp_util.debug('interface_header_attribute15: '||
4432: p_trx_rec.interface_header_attribute15);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4427: arp_util.debug('interface_header_attribute13: '||
4428: p_trx_rec.interface_header_attribute13);
4429: arp_util.debug('interface_header_attribute14: '||
4430: p_trx_rec.interface_header_attribute14);
4431: arp_util.debug('interface_header_attribute15: '||
4432: p_trx_rec.interface_header_attribute15);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4429: arp_util.debug('interface_header_attribute14: '||
4430: p_trx_rec.interface_header_attribute14);
4431: arp_util.debug('interface_header_attribute15: '||
4432: p_trx_rec.interface_header_attribute15);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4430: p_trx_rec.interface_header_attribute14);
4431: arp_util.debug('interface_header_attribute15: '||
4432: p_trx_rec.interface_header_attribute15);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4431: arp_util.debug('interface_header_attribute15: '||
4432: p_trx_rec.interface_header_attribute15);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4432: p_trx_rec.interface_header_attribute15);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4433: arp_util.debug('attribute_category: ' || p_trx_rec.attribute_category);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4434: arp_util.debug('attribute1: ' || p_trx_rec.attribute1);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4435: arp_util.debug('attribute2: ' || p_trx_rec.attribute2);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4436: arp_util.debug('attribute3: ' || p_trx_rec.attribute3);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4437: arp_util.debug('attribute4: ' || p_trx_rec.attribute4);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4438: arp_util.debug('attribute5: ' || p_trx_rec.attribute5);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4439: arp_util.debug('attribute6: ' || p_trx_rec.attribute6);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4440: arp_util.debug('attribute7: ' || p_trx_rec.attribute7);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4441: arp_util.debug('attribute8: ' || p_trx_rec.attribute8);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4442: arp_util.debug('attribute9: ' || p_trx_rec.attribute9);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4443: arp_util.debug('attribute10: ' || p_trx_rec.attribute10);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4444: arp_util.debug('attribute11: ' || p_trx_rec.attribute11);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4445: arp_util.debug('attribute12: ' || p_trx_rec.attribute12);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4446: arp_util.debug('attribute13: ' || p_trx_rec.attribute13);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4447: arp_util.debug('attribute14: ' || p_trx_rec.attribute14);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4448: arp_util.debug('attribute15: ' || p_trx_rec.attribute15);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4449: arp_util.debug('br_amount: ' || p_trx_rec.br_amount);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4450: arp_util.debug('br_unpaid_flag: ' || p_trx_rec.br_unpaid_flag);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4451: arp_util.debug('br_on_hold_flag: ' || p_trx_rec.br_on_hold_flag);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4452: arp_util.debug('drawee_id: ' || p_trx_rec.drawee_id);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4453: arp_util.debug('drawee_contact_id: ' || p_trx_rec.drawee_contact_id);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4454: arp_util.debug('drawee_site_use_id: ' || p_trx_rec.drawee_site_use_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4455: arp_util.debug('drawee_bank_account_id: ' || p_trx_rec.drawee_bank_account_id);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4456: arp_util.debug('remit_bank_acct_use_id: ' || p_trx_rec.remit_bank_acct_use_id);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4457: arp_util.debug('override_remit_account_flag: ' || p_trx_rec.override_remit_account_flag);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4458: arp_util.debug('special_instructions: ' || p_trx_rec.special_instructions);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4459: arp_util.debug('remittance_batch_id: ' || p_trx_rec.remittance_batch_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4460: arp_util.debug('address_verification_code: ' || p_trx_rec.address_verification_code);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4461: arp_util.debug('approval_code: ' || p_trx_rec.approval_code);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4462: arp_util.debug('bill_to_address_id: ' || p_trx_rec.bill_to_address_id);
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4463: arp_util.debug('edi_processed_flag: ' || p_trx_rec.edi_processed_flag);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4464: arp_util.debug('edi_processed_status: ' || p_trx_rec.edi_processed_status);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4465: arp_util.debug('payment_server_order_num: ' || p_trx_rec.payment_server_order_num);
4466: arp_util.debug('post_request_id: ' || p_trx_rec.post_request_id);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4467: arp_util.debug('request_id: ' || p_trx_rec.request_id);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4468: arp_util.debug('ship_to_address_id: ' || p_trx_rec.ship_to_address_id);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4469: arp_util.debug('wh_update_date: ' || p_trx_rec.wh_update_date);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4470:
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4471: arp_util.debug('global_attribute_category: ' || p_trx_rec.global_attribute_category);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4472: arp_util.debug('global_attribute1: ' || p_trx_rec.global_attribute1);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4473: arp_util.debug('global_attribute2: ' || p_trx_rec.global_attribute2);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4474: arp_util.debug('global_attribute3: ' || p_trx_rec.global_attribute3);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4475: arp_util.debug('global_attribute4: ' || p_trx_rec.global_attribute4);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4476: arp_util.debug('global_attribute5: ' || p_trx_rec.global_attribute5);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4477: arp_util.debug('global_attribute6: ' || p_trx_rec.global_attribute6);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4478: arp_util.debug('global_attribute7: ' || p_trx_rec.global_attribute7);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4479: arp_util.debug('global_attribute8: ' || p_trx_rec.global_attribute8);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4480: arp_util.debug('global_attribute9: ' || p_trx_rec.global_attribute9);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4481: arp_util.debug('global_attribute10: ' || p_trx_rec.global_attribute10);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4482: arp_util.debug('global_attribute11: ' || p_trx_rec.global_attribute11);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4483: arp_util.debug('global_attribute12: ' || p_trx_rec.global_attribute12);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4484: arp_util.debug('global_attribute13: ' || p_trx_rec.global_attribute13);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4485: arp_util.debug('global_attribute14: ' || p_trx_rec.global_attribute14);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4486: arp_util.debug('global_attribute15: ' || p_trx_rec.global_attribute15);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4487: arp_util.debug('global_attribute16: ' || p_trx_rec.global_attribute16);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4488: arp_util.debug('global_attribute17: ' || p_trx_rec.global_attribute17);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4489: arp_util.debug('global_attribute18: ' || p_trx_rec.global_attribute18);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4490: arp_util.debug('global_attribute19: ' || p_trx_rec.global_attribute19);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4491: arp_util.debug('global_attribute20: ' || p_trx_rec.global_attribute20);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4492: arp_util.debug('global_attribute21: ' || p_trx_rec.global_attribute21);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4493: arp_util.debug('global_attribute22: ' || p_trx_rec.global_attribute22);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4494: arp_util.debug('global_attribute23: ' || p_trx_rec.global_attribute23);
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4495: arp_util.debug('global_attribute24: ' || p_trx_rec.global_attribute24);
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4496: arp_util.debug('global_attribute25: ' || p_trx_rec.global_attribute25);
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4497: arp_util.debug('global_attribute26: ' || p_trx_rec.global_attribute26);
4498: arp_util.debug('global_attribute27: ' || p_trx_rec.global_attribute27);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4499: arp_util.debug('global_attribute28: ' || p_trx_rec.global_attribute28);
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4506:
4507: arp_util.debug('************* End ra_customer_trx record *************');
4500: arp_util.debug('global_attribute29: ' || p_trx_rec.global_attribute29);
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4506:
4507: arp_util.debug('************* End ra_customer_trx record *************');
4508:
4501: arp_util.debug('global_attribute30: ' || p_trx_rec.global_attribute30);
4502:
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4506:
4507: arp_util.debug('************* End ra_customer_trx record *************');
4508:
4509: arp_util.debug('arp_ct_pkg.display_header_rec()-');
4503: arp_util.debug('legal_entity_id: ' || to_char(p_trx_rec.legal_entity_id));
4504: arp_util.debug('payment_trxn_extension_id: ' || to_char(p_trx_rec.payment_trxn_extension_id));
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4506:
4507: arp_util.debug('************* End ra_customer_trx record *************');
4508:
4509: arp_util.debug('arp_ct_pkg.display_header_rec()-');
4510:
4511: EXCEPTION
4505: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
4506:
4507: arp_util.debug('************* End ra_customer_trx record *************');
4508:
4509: arp_util.debug('arp_ct_pkg.display_header_rec()-');
4510:
4511: EXCEPTION
4512: WHEN OTHERS THEN
4513: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_rec()');
4509: arp_util.debug('arp_ct_pkg.display_header_rec()-');
4510:
4511: EXCEPTION
4512: WHEN OTHERS THEN
4513: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_rec()');
4514: RAISE;
4515:
4516: END;
4517:
4525: | |
4526: | SCOPE - PUBLIC |
4527: | |
4528: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4529: | arp_util.debug |
4530: | |
4531: | ARGUMENTS : IN: |
4532: | p_customer_trx_id |
4533: | p_ship_via |
4555: p_fob_point IN ra_customer_trx.fob_point%type)
4556: IS
4557: l_trx_rec ra_customer_trx%rowtype;
4558: BEGIN
4559: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');
4560:
4561: /*------------------------------------------------+
4562: | Populate the header record with the values |
4563: | passed in as parameters. |
4573:
4574: /*-----------------------------------------+
4575: | Call the standard header table handler |
4576: +-----------------------------------------*/
4577: arp_util.debug('calling lock compare p with p_customer_trx_id = ' || to_char(p_customer_trx_id));
4578:
4579: lock_compare_p( l_trx_rec, p_customer_trx_id);
4580:
4581: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()-');
4577: arp_util.debug('calling lock compare p with p_customer_trx_id = ' || to_char(p_customer_trx_id));
4578:
4579: lock_compare_p( l_trx_rec, p_customer_trx_id);
4580:
4581: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()-');
4582:
4583: EXCEPTION
4584: WHEN OTHERS THEN
4585: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');
4581: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()-');
4582:
4583: EXCEPTION
4584: WHEN OTHERS THEN
4585: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');
4586:
4587: arp_util.debug('----- parameters for lock_compare_frt_cover() ' ||
4588: '-----');
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4583: EXCEPTION
4584: WHEN OTHERS THEN
4585: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');
4586:
4587: arp_util.debug('----- parameters for lock_compare_frt_cover() ' ||
4588: '-----');
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4590: arp_util.debug('p_ship_via = ' || p_ship_via );
4591: arp_util.debug('p_ship_date_actual = ' || p_ship_date_actual );
4585: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');
4586:
4587: arp_util.debug('----- parameters for lock_compare_frt_cover() ' ||
4588: '-----');
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4590: arp_util.debug('p_ship_via = ' || p_ship_via );
4591: arp_util.debug('p_ship_date_actual = ' || p_ship_date_actual );
4592: arp_util.debug('p_waybill_number = ' || p_waybill_number );
4593: arp_util.debug('p_fob_point = ' || p_fob_point );
4586:
4587: arp_util.debug('----- parameters for lock_compare_frt_cover() ' ||
4588: '-----');
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4590: arp_util.debug('p_ship_via = ' || p_ship_via );
4591: arp_util.debug('p_ship_date_actual = ' || p_ship_date_actual );
4592: arp_util.debug('p_waybill_number = ' || p_waybill_number );
4593: arp_util.debug('p_fob_point = ' || p_fob_point );
4594:
4587: arp_util.debug('----- parameters for lock_compare_frt_cover() ' ||
4588: '-----');
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4590: arp_util.debug('p_ship_via = ' || p_ship_via );
4591: arp_util.debug('p_ship_date_actual = ' || p_ship_date_actual );
4592: arp_util.debug('p_waybill_number = ' || p_waybill_number );
4593: arp_util.debug('p_fob_point = ' || p_fob_point );
4594:
4595: RAISE;
4588: '-----');
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4590: arp_util.debug('p_ship_via = ' || p_ship_via );
4591: arp_util.debug('p_ship_date_actual = ' || p_ship_date_actual );
4592: arp_util.debug('p_waybill_number = ' || p_waybill_number );
4593: arp_util.debug('p_fob_point = ' || p_fob_point );
4594:
4595: RAISE;
4596:
4589: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );
4590: arp_util.debug('p_ship_via = ' || p_ship_via );
4591: arp_util.debug('p_ship_date_actual = ' || p_ship_date_actual );
4592: arp_util.debug('p_waybill_number = ' || p_waybill_number );
4593: arp_util.debug('p_fob_point = ' || p_fob_point );
4594:
4595: RAISE;
4596:
4597: END;
4606: | |
4607: | SCOPE - PUBLIC |
4608: | |
4609: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
4610: | arp_util.debug |
4611: | |
4612: | ARGUMENTS : IN: |
4613: | p_customer_trx_id |
4614: | p_trx_number |
4861:
4862: l_trx_rec ra_customer_trx%rowtype;
4863:
4864: BEGIN
4865: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
4866:
4867: /*------------------------------------------------+
4868: | Populate the header record with the values |
4869: | passed in as parameters. |
4989: +-----------------------------------------*/
4990:
4991: lock_compare_p( l_trx_rec, p_customer_trx_id);
4992:
4993: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
4994:
4995: EXCEPTION
4996: WHEN OTHERS THEN
4997: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
4993: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
4994:
4995: EXCEPTION
4996: WHEN OTHERS THEN
4997: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
4998:
4999: arp_util.debug('----- parameters for lock_compare_cover() ' ||
5000: '-----');
5001: arp_util.debug('p_customer_trx_id = ' ||
4995: EXCEPTION
4996: WHEN OTHERS THEN
4997: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
4998:
4999: arp_util.debug('----- parameters for lock_compare_cover() ' ||
5000: '-----');
5001: arp_util.debug('p_customer_trx_id = ' ||
5002: TO_CHAR(p_customer_trx_id));
5003: arp_util.debug('p_trx_number = ' ||
4997: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
4998:
4999: arp_util.debug('----- parameters for lock_compare_cover() ' ||
5000: '-----');
5001: arp_util.debug('p_customer_trx_id = ' ||
5002: TO_CHAR(p_customer_trx_id));
5003: arp_util.debug('p_trx_number = ' ||
5004: p_trx_number);
5005: arp_util.debug('p_posting_control_id = ' ||
4999: arp_util.debug('----- parameters for lock_compare_cover() ' ||
5000: '-----');
5001: arp_util.debug('p_customer_trx_id = ' ||
5002: TO_CHAR(p_customer_trx_id));
5003: arp_util.debug('p_trx_number = ' ||
5004: p_trx_number);
5005: arp_util.debug('p_posting_control_id = ' ||
5006: TO_CHAR(p_posting_control_id));
5007: arp_util.debug('p_ra_post_loop_number = ' ||
5001: arp_util.debug('p_customer_trx_id = ' ||
5002: TO_CHAR(p_customer_trx_id));
5003: arp_util.debug('p_trx_number = ' ||
5004: p_trx_number);
5005: arp_util.debug('p_posting_control_id = ' ||
5006: TO_CHAR(p_posting_control_id));
5007: arp_util.debug('p_ra_post_loop_number = ' ||
5008: p_ra_post_loop_number);
5009: arp_util.debug('p_complete_flag = ' ||
5003: arp_util.debug('p_trx_number = ' ||
5004: p_trx_number);
5005: arp_util.debug('p_posting_control_id = ' ||
5006: TO_CHAR(p_posting_control_id));
5007: arp_util.debug('p_ra_post_loop_number = ' ||
5008: p_ra_post_loop_number);
5009: arp_util.debug('p_complete_flag = ' ||
5010: p_complete_flag);
5011: arp_util.debug('p_initial_customer_trx_id = ' ||
5005: arp_util.debug('p_posting_control_id = ' ||
5006: TO_CHAR(p_posting_control_id));
5007: arp_util.debug('p_ra_post_loop_number = ' ||
5008: p_ra_post_loop_number);
5009: arp_util.debug('p_complete_flag = ' ||
5010: p_complete_flag);
5011: arp_util.debug('p_initial_customer_trx_id = ' ||
5012: TO_CHAR(p_initial_customer_trx_id));
5013: arp_util.debug('p_previous_customer_trx_id = ' ||
5007: arp_util.debug('p_ra_post_loop_number = ' ||
5008: p_ra_post_loop_number);
5009: arp_util.debug('p_complete_flag = ' ||
5010: p_complete_flag);
5011: arp_util.debug('p_initial_customer_trx_id = ' ||
5012: TO_CHAR(p_initial_customer_trx_id));
5013: arp_util.debug('p_previous_customer_trx_id = ' ||
5014: TO_CHAR(p_previous_customer_trx_id));
5015: arp_util.debug('p_related_customer_trx_id = ' ||
5009: arp_util.debug('p_complete_flag = ' ||
5010: p_complete_flag);
5011: arp_util.debug('p_initial_customer_trx_id = ' ||
5012: TO_CHAR(p_initial_customer_trx_id));
5013: arp_util.debug('p_previous_customer_trx_id = ' ||
5014: TO_CHAR(p_previous_customer_trx_id));
5015: arp_util.debug('p_related_customer_trx_id = ' ||
5016: TO_CHAR(p_related_customer_trx_id));
5017: arp_util.debug('p_recurred_from_trx_number = ' ||
5011: arp_util.debug('p_initial_customer_trx_id = ' ||
5012: TO_CHAR(p_initial_customer_trx_id));
5013: arp_util.debug('p_previous_customer_trx_id = ' ||
5014: TO_CHAR(p_previous_customer_trx_id));
5015: arp_util.debug('p_related_customer_trx_id = ' ||
5016: TO_CHAR(p_related_customer_trx_id));
5017: arp_util.debug('p_recurred_from_trx_number = ' ||
5018: p_recurred_from_trx_number);
5019: arp_util.debug('p_cust_trx_type_id = ' ||
5013: arp_util.debug('p_previous_customer_trx_id = ' ||
5014: TO_CHAR(p_previous_customer_trx_id));
5015: arp_util.debug('p_related_customer_trx_id = ' ||
5016: TO_CHAR(p_related_customer_trx_id));
5017: arp_util.debug('p_recurred_from_trx_number = ' ||
5018: p_recurred_from_trx_number);
5019: arp_util.debug('p_cust_trx_type_id = ' ||
5020: TO_CHAR(p_cust_trx_type_id));
5021: arp_util.debug('p_batch_id = ' ||
5015: arp_util.debug('p_related_customer_trx_id = ' ||
5016: TO_CHAR(p_related_customer_trx_id));
5017: arp_util.debug('p_recurred_from_trx_number = ' ||
5018: p_recurred_from_trx_number);
5019: arp_util.debug('p_cust_trx_type_id = ' ||
5020: TO_CHAR(p_cust_trx_type_id));
5021: arp_util.debug('p_batch_id = ' ||
5022: TO_CHAR(p_batch_id));
5023: arp_util.debug('p_batch_source_id = ' ||
5017: arp_util.debug('p_recurred_from_trx_number = ' ||
5018: p_recurred_from_trx_number);
5019: arp_util.debug('p_cust_trx_type_id = ' ||
5020: TO_CHAR(p_cust_trx_type_id));
5021: arp_util.debug('p_batch_id = ' ||
5022: TO_CHAR(p_batch_id));
5023: arp_util.debug('p_batch_source_id = ' ||
5024: TO_CHAR(p_batch_source_id));
5025: arp_util.debug('p_agreement_id = ' ||
5019: arp_util.debug('p_cust_trx_type_id = ' ||
5020: TO_CHAR(p_cust_trx_type_id));
5021: arp_util.debug('p_batch_id = ' ||
5022: TO_CHAR(p_batch_id));
5023: arp_util.debug('p_batch_source_id = ' ||
5024: TO_CHAR(p_batch_source_id));
5025: arp_util.debug('p_agreement_id = ' ||
5026: TO_CHAR(p_agreement_id));
5027: arp_util.debug('p_trx_date = ' ||
5021: arp_util.debug('p_batch_id = ' ||
5022: TO_CHAR(p_batch_id));
5023: arp_util.debug('p_batch_source_id = ' ||
5024: TO_CHAR(p_batch_source_id));
5025: arp_util.debug('p_agreement_id = ' ||
5026: TO_CHAR(p_agreement_id));
5027: arp_util.debug('p_trx_date = ' ||
5028: p_trx_date);
5029: arp_util.debug('p_bill_to_customer_id = ' ||
5023: arp_util.debug('p_batch_source_id = ' ||
5024: TO_CHAR(p_batch_source_id));
5025: arp_util.debug('p_agreement_id = ' ||
5026: TO_CHAR(p_agreement_id));
5027: arp_util.debug('p_trx_date = ' ||
5028: p_trx_date);
5029: arp_util.debug('p_bill_to_customer_id = ' ||
5030: TO_CHAR(p_bill_to_customer_id));
5031: arp_util.debug('p_bill_to_contact_id = ' ||
5025: arp_util.debug('p_agreement_id = ' ||
5026: TO_CHAR(p_agreement_id));
5027: arp_util.debug('p_trx_date = ' ||
5028: p_trx_date);
5029: arp_util.debug('p_bill_to_customer_id = ' ||
5030: TO_CHAR(p_bill_to_customer_id));
5031: arp_util.debug('p_bill_to_contact_id = ' ||
5032: TO_CHAR(p_bill_to_contact_id));
5033: arp_util.debug('p_bill_to_site_use_id = ' ||
5027: arp_util.debug('p_trx_date = ' ||
5028: p_trx_date);
5029: arp_util.debug('p_bill_to_customer_id = ' ||
5030: TO_CHAR(p_bill_to_customer_id));
5031: arp_util.debug('p_bill_to_contact_id = ' ||
5032: TO_CHAR(p_bill_to_contact_id));
5033: arp_util.debug('p_bill_to_site_use_id = ' ||
5034: TO_CHAR(p_bill_to_site_use_id));
5035: arp_util.debug('p_ship_to_customer_id = ' ||
5029: arp_util.debug('p_bill_to_customer_id = ' ||
5030: TO_CHAR(p_bill_to_customer_id));
5031: arp_util.debug('p_bill_to_contact_id = ' ||
5032: TO_CHAR(p_bill_to_contact_id));
5033: arp_util.debug('p_bill_to_site_use_id = ' ||
5034: TO_CHAR(p_bill_to_site_use_id));
5035: arp_util.debug('p_ship_to_customer_id = ' ||
5036: TO_CHAR(p_ship_to_customer_id));
5037: arp_util.debug('p_ship_to_contact_id = ' ||
5031: arp_util.debug('p_bill_to_contact_id = ' ||
5032: TO_CHAR(p_bill_to_contact_id));
5033: arp_util.debug('p_bill_to_site_use_id = ' ||
5034: TO_CHAR(p_bill_to_site_use_id));
5035: arp_util.debug('p_ship_to_customer_id = ' ||
5036: TO_CHAR(p_ship_to_customer_id));
5037: arp_util.debug('p_ship_to_contact_id = ' ||
5038: TO_CHAR(p_ship_to_contact_id));
5039: arp_util.debug('p_ship_to_site_use_id = ' ||
5033: arp_util.debug('p_bill_to_site_use_id = ' ||
5034: TO_CHAR(p_bill_to_site_use_id));
5035: arp_util.debug('p_ship_to_customer_id = ' ||
5036: TO_CHAR(p_ship_to_customer_id));
5037: arp_util.debug('p_ship_to_contact_id = ' ||
5038: TO_CHAR(p_ship_to_contact_id));
5039: arp_util.debug('p_ship_to_site_use_id = ' ||
5040: TO_CHAR(p_ship_to_site_use_id));
5041: arp_util.debug('p_sold_to_customer_id = ' ||
5035: arp_util.debug('p_ship_to_customer_id = ' ||
5036: TO_CHAR(p_ship_to_customer_id));
5037: arp_util.debug('p_ship_to_contact_id = ' ||
5038: TO_CHAR(p_ship_to_contact_id));
5039: arp_util.debug('p_ship_to_site_use_id = ' ||
5040: TO_CHAR(p_ship_to_site_use_id));
5041: arp_util.debug('p_sold_to_customer_id = ' ||
5042: TO_CHAR(p_sold_to_customer_id));
5043: arp_util.debug('p_sold_to_site_use_id = ' ||
5037: arp_util.debug('p_ship_to_contact_id = ' ||
5038: TO_CHAR(p_ship_to_contact_id));
5039: arp_util.debug('p_ship_to_site_use_id = ' ||
5040: TO_CHAR(p_ship_to_site_use_id));
5041: arp_util.debug('p_sold_to_customer_id = ' ||
5042: TO_CHAR(p_sold_to_customer_id));
5043: arp_util.debug('p_sold_to_site_use_id = ' ||
5044: TO_CHAR(p_sold_to_site_use_id));
5045: arp_util.debug('p_sold_to_contact_id = ' ||
5039: arp_util.debug('p_ship_to_site_use_id = ' ||
5040: TO_CHAR(p_ship_to_site_use_id));
5041: arp_util.debug('p_sold_to_customer_id = ' ||
5042: TO_CHAR(p_sold_to_customer_id));
5043: arp_util.debug('p_sold_to_site_use_id = ' ||
5044: TO_CHAR(p_sold_to_site_use_id));
5045: arp_util.debug('p_sold_to_contact_id = ' ||
5046: TO_CHAR(p_sold_to_contact_id));
5047: arp_util.debug('p_customer_reference = ' ||
5041: arp_util.debug('p_sold_to_customer_id = ' ||
5042: TO_CHAR(p_sold_to_customer_id));
5043: arp_util.debug('p_sold_to_site_use_id = ' ||
5044: TO_CHAR(p_sold_to_site_use_id));
5045: arp_util.debug('p_sold_to_contact_id = ' ||
5046: TO_CHAR(p_sold_to_contact_id));
5047: arp_util.debug('p_customer_reference = ' ||
5048: p_customer_reference);
5049: arp_util.debug('p_customer_reference_date = ' ||
5043: arp_util.debug('p_sold_to_site_use_id = ' ||
5044: TO_CHAR(p_sold_to_site_use_id));
5045: arp_util.debug('p_sold_to_contact_id = ' ||
5046: TO_CHAR(p_sold_to_contact_id));
5047: arp_util.debug('p_customer_reference = ' ||
5048: p_customer_reference);
5049: arp_util.debug('p_customer_reference_date = ' ||
5050: p_customer_reference_date);
5051: arp_util.debug('p_cr_method_for_installments = ' ||
5045: arp_util.debug('p_sold_to_contact_id = ' ||
5046: TO_CHAR(p_sold_to_contact_id));
5047: arp_util.debug('p_customer_reference = ' ||
5048: p_customer_reference);
5049: arp_util.debug('p_customer_reference_date = ' ||
5050: p_customer_reference_date);
5051: arp_util.debug('p_cr_method_for_installments = ' ||
5052: p_cr_method_for_installments);
5053: arp_util.debug('p_credit_method_for_rules = ' ||
5047: arp_util.debug('p_customer_reference = ' ||
5048: p_customer_reference);
5049: arp_util.debug('p_customer_reference_date = ' ||
5050: p_customer_reference_date);
5051: arp_util.debug('p_cr_method_for_installments = ' ||
5052: p_cr_method_for_installments);
5053: arp_util.debug('p_credit_method_for_rules = ' ||
5054: p_credit_method_for_rules);
5055: arp_util.debug('p_start_date_commitment = ' ||
5049: arp_util.debug('p_customer_reference_date = ' ||
5050: p_customer_reference_date);
5051: arp_util.debug('p_cr_method_for_installments = ' ||
5052: p_cr_method_for_installments);
5053: arp_util.debug('p_credit_method_for_rules = ' ||
5054: p_credit_method_for_rules);
5055: arp_util.debug('p_start_date_commitment = ' ||
5056: p_start_date_commitment);
5057: arp_util.debug('p_end_date_commitment = ' ||
5051: arp_util.debug('p_cr_method_for_installments = ' ||
5052: p_cr_method_for_installments);
5053: arp_util.debug('p_credit_method_for_rules = ' ||
5054: p_credit_method_for_rules);
5055: arp_util.debug('p_start_date_commitment = ' ||
5056: p_start_date_commitment);
5057: arp_util.debug('p_end_date_commitment = ' ||
5058: p_end_date_commitment);
5059: arp_util.debug('p_exchange_date = ' ||
5053: arp_util.debug('p_credit_method_for_rules = ' ||
5054: p_credit_method_for_rules);
5055: arp_util.debug('p_start_date_commitment = ' ||
5056: p_start_date_commitment);
5057: arp_util.debug('p_end_date_commitment = ' ||
5058: p_end_date_commitment);
5059: arp_util.debug('p_exchange_date = ' ||
5060: p_exchange_date);
5061: arp_util.debug('p_exchange_rate = ' ||
5055: arp_util.debug('p_start_date_commitment = ' ||
5056: p_start_date_commitment);
5057: arp_util.debug('p_end_date_commitment = ' ||
5058: p_end_date_commitment);
5059: arp_util.debug('p_exchange_date = ' ||
5060: p_exchange_date);
5061: arp_util.debug('p_exchange_rate = ' ||
5062: p_exchange_rate);
5063: arp_util.debug('p_exchange_rate_type = ' ||
5057: arp_util.debug('p_end_date_commitment = ' ||
5058: p_end_date_commitment);
5059: arp_util.debug('p_exchange_date = ' ||
5060: p_exchange_date);
5061: arp_util.debug('p_exchange_rate = ' ||
5062: p_exchange_rate);
5063: arp_util.debug('p_exchange_rate_type = ' ||
5064: p_exchange_rate_type);
5065: arp_util.debug('p_customer_bank_account_id = ' ||
5059: arp_util.debug('p_exchange_date = ' ||
5060: p_exchange_date);
5061: arp_util.debug('p_exchange_rate = ' ||
5062: p_exchange_rate);
5063: arp_util.debug('p_exchange_rate_type = ' ||
5064: p_exchange_rate_type);
5065: arp_util.debug('p_customer_bank_account_id = ' ||
5066: TO_CHAR(p_customer_bank_account_id));
5067: arp_util.debug('p_finance_charges = ' ||
5061: arp_util.debug('p_exchange_rate = ' ||
5062: p_exchange_rate);
5063: arp_util.debug('p_exchange_rate_type = ' ||
5064: p_exchange_rate_type);
5065: arp_util.debug('p_customer_bank_account_id = ' ||
5066: TO_CHAR(p_customer_bank_account_id));
5067: arp_util.debug('p_finance_charges = ' ||
5068: p_finance_charges);
5069: arp_util.debug('p_fob_point = ' ||
5063: arp_util.debug('p_exchange_rate_type = ' ||
5064: p_exchange_rate_type);
5065: arp_util.debug('p_customer_bank_account_id = ' ||
5066: TO_CHAR(p_customer_bank_account_id));
5067: arp_util.debug('p_finance_charges = ' ||
5068: p_finance_charges);
5069: arp_util.debug('p_fob_point = ' ||
5070: p_fob_point);
5071: arp_util.debug('p_comments = ' ||
5065: arp_util.debug('p_customer_bank_account_id = ' ||
5066: TO_CHAR(p_customer_bank_account_id));
5067: arp_util.debug('p_finance_charges = ' ||
5068: p_finance_charges);
5069: arp_util.debug('p_fob_point = ' ||
5070: p_fob_point);
5071: arp_util.debug('p_comments = ' ||
5072: p_comments);
5073: arp_util.debug('p_internal_notes = ' ||
5067: arp_util.debug('p_finance_charges = ' ||
5068: p_finance_charges);
5069: arp_util.debug('p_fob_point = ' ||
5070: p_fob_point);
5071: arp_util.debug('p_comments = ' ||
5072: p_comments);
5073: arp_util.debug('p_internal_notes = ' ||
5074: p_internal_notes);
5075: arp_util.debug('p_invoice_currency_code = ' ||
5069: arp_util.debug('p_fob_point = ' ||
5070: p_fob_point);
5071: arp_util.debug('p_comments = ' ||
5072: p_comments);
5073: arp_util.debug('p_internal_notes = ' ||
5074: p_internal_notes);
5075: arp_util.debug('p_invoice_currency_code = ' ||
5076: p_invoice_currency_code);
5077: arp_util.debug('p_invoicing_rule_id = ' ||
5071: arp_util.debug('p_comments = ' ||
5072: p_comments);
5073: arp_util.debug('p_internal_notes = ' ||
5074: p_internal_notes);
5075: arp_util.debug('p_invoice_currency_code = ' ||
5076: p_invoice_currency_code);
5077: arp_util.debug('p_invoicing_rule_id = ' ||
5078: TO_CHAR(p_invoicing_rule_id));
5079: arp_util.debug('p_last_printed_sequence_num = ' ||
5073: arp_util.debug('p_internal_notes = ' ||
5074: p_internal_notes);
5075: arp_util.debug('p_invoice_currency_code = ' ||
5076: p_invoice_currency_code);
5077: arp_util.debug('p_invoicing_rule_id = ' ||
5078: TO_CHAR(p_invoicing_rule_id));
5079: arp_util.debug('p_last_printed_sequence_num = ' ||
5080: p_last_printed_sequence_num);
5081: arp_util.debug('p_orig_system_batch_name = ' ||
5075: arp_util.debug('p_invoice_currency_code = ' ||
5076: p_invoice_currency_code);
5077: arp_util.debug('p_invoicing_rule_id = ' ||
5078: TO_CHAR(p_invoicing_rule_id));
5079: arp_util.debug('p_last_printed_sequence_num = ' ||
5080: p_last_printed_sequence_num);
5081: arp_util.debug('p_orig_system_batch_name = ' ||
5082: p_orig_system_batch_name);
5083: arp_util.debug('p_primary_salesrep_id = ' ||
5077: arp_util.debug('p_invoicing_rule_id = ' ||
5078: TO_CHAR(p_invoicing_rule_id));
5079: arp_util.debug('p_last_printed_sequence_num = ' ||
5080: p_last_printed_sequence_num);
5081: arp_util.debug('p_orig_system_batch_name = ' ||
5082: p_orig_system_batch_name);
5083: arp_util.debug('p_primary_salesrep_id = ' ||
5084: TO_CHAR(p_primary_salesrep_id));
5085: arp_util.debug('p_printing_count = ' ||
5079: arp_util.debug('p_last_printed_sequence_num = ' ||
5080: p_last_printed_sequence_num);
5081: arp_util.debug('p_orig_system_batch_name = ' ||
5082: p_orig_system_batch_name);
5083: arp_util.debug('p_primary_salesrep_id = ' ||
5084: TO_CHAR(p_primary_salesrep_id));
5085: arp_util.debug('p_printing_count = ' ||
5086: p_printing_count);
5087: arp_util.debug('p_printing_last_printed = ' ||
5081: arp_util.debug('p_orig_system_batch_name = ' ||
5082: p_orig_system_batch_name);
5083: arp_util.debug('p_primary_salesrep_id = ' ||
5084: TO_CHAR(p_primary_salesrep_id));
5085: arp_util.debug('p_printing_count = ' ||
5086: p_printing_count);
5087: arp_util.debug('p_printing_last_printed = ' ||
5088: p_printing_last_printed);
5089: arp_util.debug('p_printing_option = ' ||
5083: arp_util.debug('p_primary_salesrep_id = ' ||
5084: TO_CHAR(p_primary_salesrep_id));
5085: arp_util.debug('p_printing_count = ' ||
5086: p_printing_count);
5087: arp_util.debug('p_printing_last_printed = ' ||
5088: p_printing_last_printed);
5089: arp_util.debug('p_printing_option = ' ||
5090: p_printing_option);
5091: arp_util.debug('p_printing_original_date = ' ||
5085: arp_util.debug('p_printing_count = ' ||
5086: p_printing_count);
5087: arp_util.debug('p_printing_last_printed = ' ||
5088: p_printing_last_printed);
5089: arp_util.debug('p_printing_option = ' ||
5090: p_printing_option);
5091: arp_util.debug('p_printing_original_date = ' ||
5092: p_printing_original_date);
5093: arp_util.debug('p_printing_pending = ' ||
5087: arp_util.debug('p_printing_last_printed = ' ||
5088: p_printing_last_printed);
5089: arp_util.debug('p_printing_option = ' ||
5090: p_printing_option);
5091: arp_util.debug('p_printing_original_date = ' ||
5092: p_printing_original_date);
5093: arp_util.debug('p_printing_pending = ' ||
5094: p_printing_pending);
5095: arp_util.debug('p_purchase_order = ' ||
5089: arp_util.debug('p_printing_option = ' ||
5090: p_printing_option);
5091: arp_util.debug('p_printing_original_date = ' ||
5092: p_printing_original_date);
5093: arp_util.debug('p_printing_pending = ' ||
5094: p_printing_pending);
5095: arp_util.debug('p_purchase_order = ' ||
5096: p_purchase_order);
5097: arp_util.debug('p_purchase_order_date = ' ||
5091: arp_util.debug('p_printing_original_date = ' ||
5092: p_printing_original_date);
5093: arp_util.debug('p_printing_pending = ' ||
5094: p_printing_pending);
5095: arp_util.debug('p_purchase_order = ' ||
5096: p_purchase_order);
5097: arp_util.debug('p_purchase_order_date = ' ||
5098: p_purchase_order_date);
5099: arp_util.debug('p_purchase_order_revision = ' ||
5093: arp_util.debug('p_printing_pending = ' ||
5094: p_printing_pending);
5095: arp_util.debug('p_purchase_order = ' ||
5096: p_purchase_order);
5097: arp_util.debug('p_purchase_order_date = ' ||
5098: p_purchase_order_date);
5099: arp_util.debug('p_purchase_order_revision = ' ||
5100: p_purchase_order_revision);
5101: arp_util.debug('p_receipt_method_id = ' ||
5095: arp_util.debug('p_purchase_order = ' ||
5096: p_purchase_order);
5097: arp_util.debug('p_purchase_order_date = ' ||
5098: p_purchase_order_date);
5099: arp_util.debug('p_purchase_order_revision = ' ||
5100: p_purchase_order_revision);
5101: arp_util.debug('p_receipt_method_id = ' ||
5102: TO_CHAR(p_receipt_method_id));
5103: arp_util.debug('p_remit_to_address_id = ' ||
5097: arp_util.debug('p_purchase_order_date = ' ||
5098: p_purchase_order_date);
5099: arp_util.debug('p_purchase_order_revision = ' ||
5100: p_purchase_order_revision);
5101: arp_util.debug('p_receipt_method_id = ' ||
5102: TO_CHAR(p_receipt_method_id));
5103: arp_util.debug('p_remit_to_address_id = ' ||
5104: TO_CHAR(p_remit_to_address_id));
5105: arp_util.debug('p_shipment_id = ' ||
5099: arp_util.debug('p_purchase_order_revision = ' ||
5100: p_purchase_order_revision);
5101: arp_util.debug('p_receipt_method_id = ' ||
5102: TO_CHAR(p_receipt_method_id));
5103: arp_util.debug('p_remit_to_address_id = ' ||
5104: TO_CHAR(p_remit_to_address_id));
5105: arp_util.debug('p_shipment_id = ' ||
5106: TO_CHAR(p_shipment_id));
5107: arp_util.debug('p_ship_date_actual = ' ||
5101: arp_util.debug('p_receipt_method_id = ' ||
5102: TO_CHAR(p_receipt_method_id));
5103: arp_util.debug('p_remit_to_address_id = ' ||
5104: TO_CHAR(p_remit_to_address_id));
5105: arp_util.debug('p_shipment_id = ' ||
5106: TO_CHAR(p_shipment_id));
5107: arp_util.debug('p_ship_date_actual = ' ||
5108: p_ship_date_actual);
5109: arp_util.debug('p_ship_via = ' ||
5103: arp_util.debug('p_remit_to_address_id = ' ||
5104: TO_CHAR(p_remit_to_address_id));
5105: arp_util.debug('p_shipment_id = ' ||
5106: TO_CHAR(p_shipment_id));
5107: arp_util.debug('p_ship_date_actual = ' ||
5108: p_ship_date_actual);
5109: arp_util.debug('p_ship_via = ' ||
5110: p_ship_via);
5111: arp_util.debug('p_term_due_date = ' ||
5105: arp_util.debug('p_shipment_id = ' ||
5106: TO_CHAR(p_shipment_id));
5107: arp_util.debug('p_ship_date_actual = ' ||
5108: p_ship_date_actual);
5109: arp_util.debug('p_ship_via = ' ||
5110: p_ship_via);
5111: arp_util.debug('p_term_due_date = ' ||
5112: p_term_due_date);
5113: arp_util.debug('p_term_id = ' ||
5107: arp_util.debug('p_ship_date_actual = ' ||
5108: p_ship_date_actual);
5109: arp_util.debug('p_ship_via = ' ||
5110: p_ship_via);
5111: arp_util.debug('p_term_due_date = ' ||
5112: p_term_due_date);
5113: arp_util.debug('p_term_id = ' ||
5114: TO_CHAR(p_term_id));
5115: arp_util.debug('p_territory_id = ' ||
5109: arp_util.debug('p_ship_via = ' ||
5110: p_ship_via);
5111: arp_util.debug('p_term_due_date = ' ||
5112: p_term_due_date);
5113: arp_util.debug('p_term_id = ' ||
5114: TO_CHAR(p_term_id));
5115: arp_util.debug('p_territory_id = ' ||
5116: TO_CHAR(p_territory_id));
5117: arp_util.debug('p_waybill_number = ' ||
5111: arp_util.debug('p_term_due_date = ' ||
5112: p_term_due_date);
5113: arp_util.debug('p_term_id = ' ||
5114: TO_CHAR(p_term_id));
5115: arp_util.debug('p_territory_id = ' ||
5116: TO_CHAR(p_territory_id));
5117: arp_util.debug('p_waybill_number = ' ||
5118: p_waybill_number);
5119: arp_util.debug('p_status_trx = ' ||
5113: arp_util.debug('p_term_id = ' ||
5114: TO_CHAR(p_term_id));
5115: arp_util.debug('p_territory_id = ' ||
5116: TO_CHAR(p_territory_id));
5117: arp_util.debug('p_waybill_number = ' ||
5118: p_waybill_number);
5119: arp_util.debug('p_status_trx = ' ||
5120: p_status_trx);
5121: arp_util.debug('p_reason_code = ' ||
5115: arp_util.debug('p_territory_id = ' ||
5116: TO_CHAR(p_territory_id));
5117: arp_util.debug('p_waybill_number = ' ||
5118: p_waybill_number);
5119: arp_util.debug('p_status_trx = ' ||
5120: p_status_trx);
5121: arp_util.debug('p_reason_code = ' ||
5122: p_reason_code);
5123: arp_util.debug('p_doc_sequence_id = ' ||
5117: arp_util.debug('p_waybill_number = ' ||
5118: p_waybill_number);
5119: arp_util.debug('p_status_trx = ' ||
5120: p_status_trx);
5121: arp_util.debug('p_reason_code = ' ||
5122: p_reason_code);
5123: arp_util.debug('p_doc_sequence_id = ' ||
5124: TO_CHAR(p_doc_sequence_id));
5125: arp_util.debug('p_doc_sequence_value = ' ||
5119: arp_util.debug('p_status_trx = ' ||
5120: p_status_trx);
5121: arp_util.debug('p_reason_code = ' ||
5122: p_reason_code);
5123: arp_util.debug('p_doc_sequence_id = ' ||
5124: TO_CHAR(p_doc_sequence_id));
5125: arp_util.debug('p_doc_sequence_value = ' ||
5126: p_doc_sequence_value);
5127: arp_util.debug('p_paying_customer_id = ' ||
5121: arp_util.debug('p_reason_code = ' ||
5122: p_reason_code);
5123: arp_util.debug('p_doc_sequence_id = ' ||
5124: TO_CHAR(p_doc_sequence_id));
5125: arp_util.debug('p_doc_sequence_value = ' ||
5126: p_doc_sequence_value);
5127: arp_util.debug('p_paying_customer_id = ' ||
5128: TO_CHAR(p_paying_customer_id));
5129: arp_util.debug('p_paying_site_use_id = ' ||
5123: arp_util.debug('p_doc_sequence_id = ' ||
5124: TO_CHAR(p_doc_sequence_id));
5125: arp_util.debug('p_doc_sequence_value = ' ||
5126: p_doc_sequence_value);
5127: arp_util.debug('p_paying_customer_id = ' ||
5128: TO_CHAR(p_paying_customer_id));
5129: arp_util.debug('p_paying_site_use_id = ' ||
5130: TO_CHAR(p_paying_site_use_id));
5131: arp_util.debug('p_related_batch_source_id = ' ||
5125: arp_util.debug('p_doc_sequence_value = ' ||
5126: p_doc_sequence_value);
5127: arp_util.debug('p_paying_customer_id = ' ||
5128: TO_CHAR(p_paying_customer_id));
5129: arp_util.debug('p_paying_site_use_id = ' ||
5130: TO_CHAR(p_paying_site_use_id));
5131: arp_util.debug('p_related_batch_source_id = ' ||
5132: TO_CHAR(p_related_batch_source_id));
5133: arp_util.debug('p_default_tax_exempt_flag = ' ||
5127: arp_util.debug('p_paying_customer_id = ' ||
5128: TO_CHAR(p_paying_customer_id));
5129: arp_util.debug('p_paying_site_use_id = ' ||
5130: TO_CHAR(p_paying_site_use_id));
5131: arp_util.debug('p_related_batch_source_id = ' ||
5132: TO_CHAR(p_related_batch_source_id));
5133: arp_util.debug('p_default_tax_exempt_flag = ' ||
5134: p_default_tax_exempt_flag);
5135: arp_util.debug('p_created_from = ' ||
5129: arp_util.debug('p_paying_site_use_id = ' ||
5130: TO_CHAR(p_paying_site_use_id));
5131: arp_util.debug('p_related_batch_source_id = ' ||
5132: TO_CHAR(p_related_batch_source_id));
5133: arp_util.debug('p_default_tax_exempt_flag = ' ||
5134: p_default_tax_exempt_flag);
5135: arp_util.debug('p_created_from = ' ||
5136: p_created_from);
5137: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
5131: arp_util.debug('p_related_batch_source_id = ' ||
5132: TO_CHAR(p_related_batch_source_id));
5133: arp_util.debug('p_default_tax_exempt_flag = ' ||
5134: p_default_tax_exempt_flag);
5135: arp_util.debug('p_created_from = ' ||
5136: p_created_from);
5137: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
5138: p_deflt_ussgl_trx_code_context);
5139: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
5133: arp_util.debug('p_default_tax_exempt_flag = ' ||
5134: p_default_tax_exempt_flag);
5135: arp_util.debug('p_created_from = ' ||
5136: p_created_from);
5137: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
5138: p_deflt_ussgl_trx_code_context);
5139: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
5140: p_deflt_ussgl_transaction_code);
5141: arp_util.debug('p_old_trx_number = ' ||
5135: arp_util.debug('p_created_from = ' ||
5136: p_created_from);
5137: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
5138: p_deflt_ussgl_trx_code_context);
5139: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
5140: p_deflt_ussgl_transaction_code);
5141: arp_util.debug('p_old_trx_number = ' ||
5142: p_old_trx_number);
5143: arp_util.debug('p_interface_header_context = ' ||
5137: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
5138: p_deflt_ussgl_trx_code_context);
5139: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
5140: p_deflt_ussgl_transaction_code);
5141: arp_util.debug('p_old_trx_number = ' ||
5142: p_old_trx_number);
5143: arp_util.debug('p_interface_header_context = ' ||
5144: p_interface_header_context);
5145: arp_util.debug('p_interface_header_attribute1 = ' ||
5139: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
5140: p_deflt_ussgl_transaction_code);
5141: arp_util.debug('p_old_trx_number = ' ||
5142: p_old_trx_number);
5143: arp_util.debug('p_interface_header_context = ' ||
5144: p_interface_header_context);
5145: arp_util.debug('p_interface_header_attribute1 = ' ||
5146: p_interface_header_attribute1);
5147: arp_util.debug('p_interface_header_attribute2 = ' ||
5141: arp_util.debug('p_old_trx_number = ' ||
5142: p_old_trx_number);
5143: arp_util.debug('p_interface_header_context = ' ||
5144: p_interface_header_context);
5145: arp_util.debug('p_interface_header_attribute1 = ' ||
5146: p_interface_header_attribute1);
5147: arp_util.debug('p_interface_header_attribute2 = ' ||
5148: p_interface_header_attribute2);
5149: arp_util.debug('p_interface_header_attribute3 = ' ||
5143: arp_util.debug('p_interface_header_context = ' ||
5144: p_interface_header_context);
5145: arp_util.debug('p_interface_header_attribute1 = ' ||
5146: p_interface_header_attribute1);
5147: arp_util.debug('p_interface_header_attribute2 = ' ||
5148: p_interface_header_attribute2);
5149: arp_util.debug('p_interface_header_attribute3 = ' ||
5150: p_interface_header_attribute3);
5151: arp_util.debug('p_interface_header_attribute4 = ' ||
5145: arp_util.debug('p_interface_header_attribute1 = ' ||
5146: p_interface_header_attribute1);
5147: arp_util.debug('p_interface_header_attribute2 = ' ||
5148: p_interface_header_attribute2);
5149: arp_util.debug('p_interface_header_attribute3 = ' ||
5150: p_interface_header_attribute3);
5151: arp_util.debug('p_interface_header_attribute4 = ' ||
5152: p_interface_header_attribute4);
5153: arp_util.debug('p_interface_header_attribute5 = ' ||
5147: arp_util.debug('p_interface_header_attribute2 = ' ||
5148: p_interface_header_attribute2);
5149: arp_util.debug('p_interface_header_attribute3 = ' ||
5150: p_interface_header_attribute3);
5151: arp_util.debug('p_interface_header_attribute4 = ' ||
5152: p_interface_header_attribute4);
5153: arp_util.debug('p_interface_header_attribute5 = ' ||
5154: p_interface_header_attribute5);
5155: arp_util.debug('p_interface_header_attribute6 = ' ||
5149: arp_util.debug('p_interface_header_attribute3 = ' ||
5150: p_interface_header_attribute3);
5151: arp_util.debug('p_interface_header_attribute4 = ' ||
5152: p_interface_header_attribute4);
5153: arp_util.debug('p_interface_header_attribute5 = ' ||
5154: p_interface_header_attribute5);
5155: arp_util.debug('p_interface_header_attribute6 = ' ||
5156: p_interface_header_attribute6);
5157: arp_util.debug('p_interface_header_attribute7 = ' ||
5151: arp_util.debug('p_interface_header_attribute4 = ' ||
5152: p_interface_header_attribute4);
5153: arp_util.debug('p_interface_header_attribute5 = ' ||
5154: p_interface_header_attribute5);
5155: arp_util.debug('p_interface_header_attribute6 = ' ||
5156: p_interface_header_attribute6);
5157: arp_util.debug('p_interface_header_attribute7 = ' ||
5158: p_interface_header_attribute7);
5159: arp_util.debug('p_interface_header_attribute8 = ' ||
5153: arp_util.debug('p_interface_header_attribute5 = ' ||
5154: p_interface_header_attribute5);
5155: arp_util.debug('p_interface_header_attribute6 = ' ||
5156: p_interface_header_attribute6);
5157: arp_util.debug('p_interface_header_attribute7 = ' ||
5158: p_interface_header_attribute7);
5159: arp_util.debug('p_interface_header_attribute8 = ' ||
5160: p_interface_header_attribute8);
5161: arp_util.debug('p_interface_header_attribute9 = ' ||
5155: arp_util.debug('p_interface_header_attribute6 = ' ||
5156: p_interface_header_attribute6);
5157: arp_util.debug('p_interface_header_attribute7 = ' ||
5158: p_interface_header_attribute7);
5159: arp_util.debug('p_interface_header_attribute8 = ' ||
5160: p_interface_header_attribute8);
5161: arp_util.debug('p_interface_header_attribute9 = ' ||
5162: p_interface_header_attribute9);
5163: arp_util.debug('p_interface_header_attribute10 = ' ||
5157: arp_util.debug('p_interface_header_attribute7 = ' ||
5158: p_interface_header_attribute7);
5159: arp_util.debug('p_interface_header_attribute8 = ' ||
5160: p_interface_header_attribute8);
5161: arp_util.debug('p_interface_header_attribute9 = ' ||
5162: p_interface_header_attribute9);
5163: arp_util.debug('p_interface_header_attribute10 = ' ||
5164: p_interface_header_attribute10);
5165: arp_util.debug('p_interface_header_attribute11 = ' ||
5159: arp_util.debug('p_interface_header_attribute8 = ' ||
5160: p_interface_header_attribute8);
5161: arp_util.debug('p_interface_header_attribute9 = ' ||
5162: p_interface_header_attribute9);
5163: arp_util.debug('p_interface_header_attribute10 = ' ||
5164: p_interface_header_attribute10);
5165: arp_util.debug('p_interface_header_attribute11 = ' ||
5166: p_interface_header_attribute11);
5167: arp_util.debug('p_interface_header_attribute12 = ' ||
5161: arp_util.debug('p_interface_header_attribute9 = ' ||
5162: p_interface_header_attribute9);
5163: arp_util.debug('p_interface_header_attribute10 = ' ||
5164: p_interface_header_attribute10);
5165: arp_util.debug('p_interface_header_attribute11 = ' ||
5166: p_interface_header_attribute11);
5167: arp_util.debug('p_interface_header_attribute12 = ' ||
5168: p_interface_header_attribute12);
5169: arp_util.debug('p_interface_header_attribute13 = ' ||
5163: arp_util.debug('p_interface_header_attribute10 = ' ||
5164: p_interface_header_attribute10);
5165: arp_util.debug('p_interface_header_attribute11 = ' ||
5166: p_interface_header_attribute11);
5167: arp_util.debug('p_interface_header_attribute12 = ' ||
5168: p_interface_header_attribute12);
5169: arp_util.debug('p_interface_header_attribute13 = ' ||
5170: p_interface_header_attribute13);
5171: arp_util.debug('p_interface_header_attribute14 = ' ||
5165: arp_util.debug('p_interface_header_attribute11 = ' ||
5166: p_interface_header_attribute11);
5167: arp_util.debug('p_interface_header_attribute12 = ' ||
5168: p_interface_header_attribute12);
5169: arp_util.debug('p_interface_header_attribute13 = ' ||
5170: p_interface_header_attribute13);
5171: arp_util.debug('p_interface_header_attribute14 = ' ||
5172: p_interface_header_attribute14);
5173: arp_util.debug('p_interface_header_attribute15 = ' ||
5167: arp_util.debug('p_interface_header_attribute12 = ' ||
5168: p_interface_header_attribute12);
5169: arp_util.debug('p_interface_header_attribute13 = ' ||
5170: p_interface_header_attribute13);
5171: arp_util.debug('p_interface_header_attribute14 = ' ||
5172: p_interface_header_attribute14);
5173: arp_util.debug('p_interface_header_attribute15 = ' ||
5174: p_interface_header_attribute15);
5175: arp_util.debug('p_attribute_category = ' ||
5169: arp_util.debug('p_interface_header_attribute13 = ' ||
5170: p_interface_header_attribute13);
5171: arp_util.debug('p_interface_header_attribute14 = ' ||
5172: p_interface_header_attribute14);
5173: arp_util.debug('p_interface_header_attribute15 = ' ||
5174: p_interface_header_attribute15);
5175: arp_util.debug('p_attribute_category = ' ||
5176: p_attribute_category);
5177: arp_util.debug('p_attribute1 = ' ||
5171: arp_util.debug('p_interface_header_attribute14 = ' ||
5172: p_interface_header_attribute14);
5173: arp_util.debug('p_interface_header_attribute15 = ' ||
5174: p_interface_header_attribute15);
5175: arp_util.debug('p_attribute_category = ' ||
5176: p_attribute_category);
5177: arp_util.debug('p_attribute1 = ' ||
5178: p_attribute1);
5179: arp_util.debug('p_attribute2 = ' ||
5173: arp_util.debug('p_interface_header_attribute15 = ' ||
5174: p_interface_header_attribute15);
5175: arp_util.debug('p_attribute_category = ' ||
5176: p_attribute_category);
5177: arp_util.debug('p_attribute1 = ' ||
5178: p_attribute1);
5179: arp_util.debug('p_attribute2 = ' ||
5180: p_attribute2);
5181: arp_util.debug('p_attribute3 = ' ||
5175: arp_util.debug('p_attribute_category = ' ||
5176: p_attribute_category);
5177: arp_util.debug('p_attribute1 = ' ||
5178: p_attribute1);
5179: arp_util.debug('p_attribute2 = ' ||
5180: p_attribute2);
5181: arp_util.debug('p_attribute3 = ' ||
5182: p_attribute3);
5183: arp_util.debug('p_attribute4 = ' ||
5177: arp_util.debug('p_attribute1 = ' ||
5178: p_attribute1);
5179: arp_util.debug('p_attribute2 = ' ||
5180: p_attribute2);
5181: arp_util.debug('p_attribute3 = ' ||
5182: p_attribute3);
5183: arp_util.debug('p_attribute4 = ' ||
5184: p_attribute4);
5185: arp_util.debug('p_attribute5 = ' ||
5179: arp_util.debug('p_attribute2 = ' ||
5180: p_attribute2);
5181: arp_util.debug('p_attribute3 = ' ||
5182: p_attribute3);
5183: arp_util.debug('p_attribute4 = ' ||
5184: p_attribute4);
5185: arp_util.debug('p_attribute5 = ' ||
5186: p_attribute5);
5187: arp_util.debug('p_attribute6 = ' ||
5181: arp_util.debug('p_attribute3 = ' ||
5182: p_attribute3);
5183: arp_util.debug('p_attribute4 = ' ||
5184: p_attribute4);
5185: arp_util.debug('p_attribute5 = ' ||
5186: p_attribute5);
5187: arp_util.debug('p_attribute6 = ' ||
5188: p_attribute6);
5189: arp_util.debug('p_attribute7 = ' ||
5183: arp_util.debug('p_attribute4 = ' ||
5184: p_attribute4);
5185: arp_util.debug('p_attribute5 = ' ||
5186: p_attribute5);
5187: arp_util.debug('p_attribute6 = ' ||
5188: p_attribute6);
5189: arp_util.debug('p_attribute7 = ' ||
5190: p_attribute7);
5191: arp_util.debug('p_attribute8 = ' ||
5185: arp_util.debug('p_attribute5 = ' ||
5186: p_attribute5);
5187: arp_util.debug('p_attribute6 = ' ||
5188: p_attribute6);
5189: arp_util.debug('p_attribute7 = ' ||
5190: p_attribute7);
5191: arp_util.debug('p_attribute8 = ' ||
5192: p_attribute8);
5193: arp_util.debug('p_attribute9 = ' ||
5187: arp_util.debug('p_attribute6 = ' ||
5188: p_attribute6);
5189: arp_util.debug('p_attribute7 = ' ||
5190: p_attribute7);
5191: arp_util.debug('p_attribute8 = ' ||
5192: p_attribute8);
5193: arp_util.debug('p_attribute9 = ' ||
5194: p_attribute9);
5195: arp_util.debug('p_attribute10 = ' ||
5189: arp_util.debug('p_attribute7 = ' ||
5190: p_attribute7);
5191: arp_util.debug('p_attribute8 = ' ||
5192: p_attribute8);
5193: arp_util.debug('p_attribute9 = ' ||
5194: p_attribute9);
5195: arp_util.debug('p_attribute10 = ' ||
5196: p_attribute10);
5197: arp_util.debug('p_attribute11 = ' ||
5191: arp_util.debug('p_attribute8 = ' ||
5192: p_attribute8);
5193: arp_util.debug('p_attribute9 = ' ||
5194: p_attribute9);
5195: arp_util.debug('p_attribute10 = ' ||
5196: p_attribute10);
5197: arp_util.debug('p_attribute11 = ' ||
5198: p_attribute11);
5199: arp_util.debug('p_attribute12 = ' ||
5193: arp_util.debug('p_attribute9 = ' ||
5194: p_attribute9);
5195: arp_util.debug('p_attribute10 = ' ||
5196: p_attribute10);
5197: arp_util.debug('p_attribute11 = ' ||
5198: p_attribute11);
5199: arp_util.debug('p_attribute12 = ' ||
5200: p_attribute12);
5201: arp_util.debug('p_attribute13 = ' ||
5195: arp_util.debug('p_attribute10 = ' ||
5196: p_attribute10);
5197: arp_util.debug('p_attribute11 = ' ||
5198: p_attribute11);
5199: arp_util.debug('p_attribute12 = ' ||
5200: p_attribute12);
5201: arp_util.debug('p_attribute13 = ' ||
5202: p_attribute13);
5203: arp_util.debug('p_attribute14 = ' ||
5197: arp_util.debug('p_attribute11 = ' ||
5198: p_attribute11);
5199: arp_util.debug('p_attribute12 = ' ||
5200: p_attribute12);
5201: arp_util.debug('p_attribute13 = ' ||
5202: p_attribute13);
5203: arp_util.debug('p_attribute14 = ' ||
5204: p_attribute14);
5205: arp_util.debug('p_attribute15 = ' ||
5199: arp_util.debug('p_attribute12 = ' ||
5200: p_attribute12);
5201: arp_util.debug('p_attribute13 = ' ||
5202: p_attribute13);
5203: arp_util.debug('p_attribute14 = ' ||
5204: p_attribute14);
5205: arp_util.debug('p_attribute15 = ' ||
5206: p_attribute15);
5207:
5201: arp_util.debug('p_attribute13 = ' ||
5202: p_attribute13);
5203: arp_util.debug('p_attribute14 = ' ||
5204: p_attribute14);
5205: arp_util.debug('p_attribute15 = ' ||
5206: p_attribute15);
5207:
5208: RAISE;
5209:
5218: | |
5219: | SCOPE - PUBLIC |
5220: | |
5221: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5222: | arp_util.debug |
5223: | |
5224: | ARGUMENTS : IN: |
5225: | None |
5226: | OUT: |
5238: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
5239:
5240: BEGIN
5241:
5242: arp_util.debug('arp_ct_pkg.get_text_dummy()+');
5243:
5244: arp_util.debug('arp_ct_pkg.get_text_dummy()-');
5245:
5246: return(AR_TEXT_DUMMY);
5240: BEGIN
5241:
5242: arp_util.debug('arp_ct_pkg.get_text_dummy()+');
5243:
5244: arp_util.debug('arp_ct_pkg.get_text_dummy()-');
5245:
5246: return(AR_TEXT_DUMMY);
5247:
5248: EXCEPTION
5246: return(AR_TEXT_DUMMY);
5247:
5248: EXCEPTION
5249: WHEN OTHERS THEN
5250: arp_util.debug('EXCEPTION: arp_ct_pkg.get_text_dummy()');
5251: RAISE;
5252:
5253: END;
5254:
5263: | |
5264: | SCOPE - PUBLIC |
5265: | |
5266: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5267: | arp_util.debug |
5268: | |
5269: | ARGUMENTS : IN: |
5270: | None |
5271: | OUT: |
5283: FUNCTION get_flag_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
5284:
5285: BEGIN
5286:
5287: arp_util.debug('arp_ct_pkg.get_flag_dummy()+');
5288:
5289: arp_util.debug('arp_ct_pkg.get_flag_dummy()-');
5290:
5291: return(AR_FLAG_DUMMY);
5285: BEGIN
5286:
5287: arp_util.debug('arp_ct_pkg.get_flag_dummy()+');
5288:
5289: arp_util.debug('arp_ct_pkg.get_flag_dummy()-');
5290:
5291: return(AR_FLAG_DUMMY);
5292:
5293: EXCEPTION
5291: return(AR_FLAG_DUMMY);
5292:
5293: EXCEPTION
5294: WHEN OTHERS THEN
5295: arp_util.debug('EXCEPTION: arp_ct_pkg.get_flag_dummy()');
5296: RAISE;
5297:
5298: END;
5299:
5306: | |
5307: | SCOPE - PUBLIC |
5308: | |
5309: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5310: | arp_util.debug |
5311: | |
5312: | ARGUMENTS : IN: |
5313: | None |
5314: | OUT: |
5326: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
5327:
5328: BEGIN
5329:
5330: arp_util.debug('arp_ct_pkg.get_number_dummy()+');
5331:
5332: arp_util.debug('arp_ct_pkg.get_number_dummy()-');
5333:
5334: return(AR_NUMBER_DUMMY);
5328: BEGIN
5329:
5330: arp_util.debug('arp_ct_pkg.get_number_dummy()+');
5331:
5332: arp_util.debug('arp_ct_pkg.get_number_dummy()-');
5333:
5334: return(AR_NUMBER_DUMMY);
5335:
5336: EXCEPTION
5334: return(AR_NUMBER_DUMMY);
5335:
5336: EXCEPTION
5337: WHEN OTHERS THEN
5338: arp_util.debug('EXCEPTION: arp_ct_pkg.get_number_dummy()');
5339: RAISE;
5340:
5341: END;
5342:
5349: | |
5350: | SCOPE - PUBLIC |
5351: | |
5352: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5353: | arp_util.debug |
5354: | |
5355: | ARGUMENTS : IN: |
5356: | None |
5357: | OUT: |
5369: FUNCTION get_date_dummy(p_null IN NUMBER DEFAULT null) RETURN date IS
5370:
5371: BEGIN
5372:
5373: arp_util.debug('arp_ct_pkg.get_date_dummy()+');
5374:
5375: arp_util.debug('arp_ct_pkg.get_date_dummy()-');
5376:
5377: return(AR_DATE_DUMMY);
5371: BEGIN
5372:
5373: arp_util.debug('arp_ct_pkg.get_date_dummy()+');
5374:
5375: arp_util.debug('arp_ct_pkg.get_date_dummy()-');
5376:
5377: return(AR_DATE_DUMMY);
5378:
5379: EXCEPTION
5377: return(AR_DATE_DUMMY);
5378:
5379: EXCEPTION
5380: WHEN OTHERS THEN
5381: arp_util.debug('EXCEPTION: arp_ct_pkg.get_date_dummy()');
5382: RAISE;
5383:
5384: END;
5385:
5394: | |
5395: | SCOPE - PUBLIC |
5396: | |
5397: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5398: | arp_util.debug |
5399: | |
5400: | ARGUMENTS : IN: |
5401: | p_customer_trx_id - identifies the row to update |
5402: | p_trx_rec - contains the new column values |
5459: l_success BOOLEAN;
5460:
5461: BEGIN
5462:
5463: arp_util.debug('arp_ct_pkg.update_tax()+ ' ||
5464: to_char(sysdate, 'HH:MI:SS'));
5465:
5466: /*------------------------------------------------+
5467: | Call Tax API to get the value of vat_tax_id |
5470: l_warehouse_id := oe_profile.value('SO_ORGANIZATION_ID');
5471: l_organization_id := arp_global.sysparam.org_id;
5472: l_sob_id := arp_global.set_of_books_id;
5473:
5474: arp_util.debug('default warehouse_id ' || to_char(l_warehouse_id));
5475: arp_util.debug('ship_to_site_use_id ' || to_char(p_ship_to_site_use_id ));
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5471: l_organization_id := arp_global.sysparam.org_id;
5472: l_sob_id := arp_global.set_of_books_id;
5473:
5474: arp_util.debug('default warehouse_id ' || to_char(l_warehouse_id));
5475: arp_util.debug('ship_to_site_use_id ' || to_char(p_ship_to_site_use_id ));
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5479: arp_util.debug('trx_date ' || to_char(p_trx_date ));
5472: l_sob_id := arp_global.set_of_books_id;
5473:
5474: arp_util.debug('default warehouse_id ' || to_char(l_warehouse_id));
5475: arp_util.debug('ship_to_site_use_id ' || to_char(p_ship_to_site_use_id ));
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5479: arp_util.debug('trx_date ' || to_char(p_trx_date ));
5480: arp_util.debug('p_affect_tax_flag ' || p_tax_affect_flag);
5473:
5474: arp_util.debug('default warehouse_id ' || to_char(l_warehouse_id));
5475: arp_util.debug('ship_to_site_use_id ' || to_char(p_ship_to_site_use_id ));
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5479: arp_util.debug('trx_date ' || to_char(p_trx_date ));
5480: arp_util.debug('p_affect_tax_flag ' || p_tax_affect_flag);
5481: l_autotax := 'Y';
5474: arp_util.debug('default warehouse_id ' || to_char(l_warehouse_id));
5475: arp_util.debug('ship_to_site_use_id ' || to_char(p_ship_to_site_use_id ));
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5479: arp_util.debug('trx_date ' || to_char(p_trx_date ));
5480: arp_util.debug('p_affect_tax_flag ' || p_tax_affect_flag);
5481: l_autotax := 'Y';
5482:
5475: arp_util.debug('ship_to_site_use_id ' || to_char(p_ship_to_site_use_id ));
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5479: arp_util.debug('trx_date ' || to_char(p_trx_date ));
5480: arp_util.debug('p_affect_tax_flag ' || p_tax_affect_flag);
5481: l_autotax := 'Y';
5482:
5483: /* bug fix : 1070949 */
5476: arp_util.debug('bill_to_site_use_id ' || to_char(p_bill_to_site_use_id ));
5477: arp_util.debug('organization_id ' || to_char(l_organization_id));
5478: arp_util.debug('set_of_books_id ' || to_char(arp_global.set_of_books_id ));
5479: arp_util.debug('trx_date ' || to_char(p_trx_date ));
5480: arp_util.debug('p_affect_tax_flag ' || p_tax_affect_flag);
5481: l_autotax := 'Y';
5482:
5483: /* bug fix : 1070949 */
5484: BEGIN
5487: FROM RA_CUST_TRX_TYPES
5488: WHERE cust_trx_type_id = p_cust_trx_type_id ;
5489: EXCEPTION
5490: WHEN OTHERS THEN
5491: arp_util.debug('arp_ct_pkd.update_tax - exception for select');
5492: END;
5493:
5494: l_success := arp_etax_util.get_event_information(
5495: p_customer_trx_id => p_customer_trx_id,
5534: p_event_class_code => l_event_class_code,
5535: p_function_short_name => 'GL_ACCT_FIXUP',
5536: p_tax_classification_code => l_tax_code );
5537:
5538: arp_util.debug('line.inventory_item_id ' ||
5539: to_char(line.inventory_item_id ));
5540: arp_util.debug('line.warehouse_id ' ||
5541: to_char(line.warehouse_id));
5542: arp_util.debug('returned tax_code/classification: ' || l_tax_code);
5536: p_tax_classification_code => l_tax_code );
5537:
5538: arp_util.debug('line.inventory_item_id ' ||
5539: to_char(line.inventory_item_id ));
5540: arp_util.debug('line.warehouse_id ' ||
5541: to_char(line.warehouse_id));
5542: arp_util.debug('returned tax_code/classification: ' || l_tax_code);
5543:
5544: EXCEPTION
5538: arp_util.debug('line.inventory_item_id ' ||
5539: to_char(line.inventory_item_id ));
5540: arp_util.debug('line.warehouse_id ' ||
5541: to_char(line.warehouse_id));
5542: arp_util.debug('returned tax_code/classification: ' || l_tax_code);
5543:
5544: EXCEPTION
5545: WHEN NO_DATA_FOUND THEN
5546: l_autotax := 'Y';
5589: l_tax_code := NULL;
5590: l_autotax := 'Y';
5591: END IF;
5592:
5593: arp_util.debug('line.inventory_item_id ' ||
5594: to_char(line.inventory_item_id ));
5595: arp_util.debug('line.warehouse_id ' ||
5596: to_char(line.warehouse_id));
5597: arp_util.debug('returned tax_code/classif: ' || l_tax_code);
5591: END IF;
5592:
5593: arp_util.debug('line.inventory_item_id ' ||
5594: to_char(line.inventory_item_id ));
5595: arp_util.debug('line.warehouse_id ' ||
5596: to_char(line.warehouse_id));
5597: arp_util.debug('returned tax_code/classif: ' || l_tax_code);
5598:
5599: EXCEPTION
5593: arp_util.debug('line.inventory_item_id ' ||
5594: to_char(line.inventory_item_id ));
5595: arp_util.debug('line.warehouse_id ' ||
5596: to_char(line.warehouse_id));
5597: arp_util.debug('returned tax_code/classif: ' || l_tax_code);
5598:
5599: EXCEPTION
5600: WHEN NO_DATA_FOUND THEN
5601: l_tax_code := NULL;
5608: where customer_trx_line_id = line.customer_trx_line_id;
5609:
5610: END LOOP;
5611: END IF;
5612: arp_util.debug('arp_ct_pkg.update_tax()- ' ||
5613: to_char(sysdate, 'HH:MI:SS'));
5614:
5615:
5616: EXCEPTION
5614:
5615:
5616: EXCEPTION
5617: WHEN OTHERS THEN
5618: arp_util.debug('EXCEPTION: arp_ct_pkg.update_tax()');
5619: RAISE;
5620: END ;
5621:
5622: /*===========================================================================+
5629: | |
5630: | SCOPE - PUBLIC |
5631: | |
5632: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
5633: | arp_util.debug |
5634: | |
5635: | ARGUMENTS : IN: |
5636: | p_customer_trx_id |
5637: | p_trx_number |
5946:
5947: l_trx_rec ra_customer_trx%rowtype;
5948:
5949: BEGIN
5950: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
5951:
5952: /*------------------------------------------------+
5953: | Populate the header record with the values |
5954: | passed in as parameters. |
6106: +-----------------------------------------*/
6107:
6108: lock_compare_p( l_trx_rec, p_customer_trx_id);
6109:
6110: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
6111:
6112: EXCEPTION
6113: WHEN OTHERS THEN
6114: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
6110: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
6111:
6112: EXCEPTION
6113: WHEN OTHERS THEN
6114: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
6115:
6116: arp_util.debug('----- parameters for lock_compare_cover() ' ||
6117: '-----');
6118: arp_util.debug('p_customer_trx_id = ' ||
6112: EXCEPTION
6113: WHEN OTHERS THEN
6114: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
6115:
6116: arp_util.debug('----- parameters for lock_compare_cover() ' ||
6117: '-----');
6118: arp_util.debug('p_customer_trx_id = ' ||
6119: TO_CHAR(p_customer_trx_id));
6120: arp_util.debug('p_trx_number = ' ||
6114: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
6115:
6116: arp_util.debug('----- parameters for lock_compare_cover() ' ||
6117: '-----');
6118: arp_util.debug('p_customer_trx_id = ' ||
6119: TO_CHAR(p_customer_trx_id));
6120: arp_util.debug('p_trx_number = ' ||
6121: p_trx_number);
6122: arp_util.debug('p_posting_control_id = ' ||
6116: arp_util.debug('----- parameters for lock_compare_cover() ' ||
6117: '-----');
6118: arp_util.debug('p_customer_trx_id = ' ||
6119: TO_CHAR(p_customer_trx_id));
6120: arp_util.debug('p_trx_number = ' ||
6121: p_trx_number);
6122: arp_util.debug('p_posting_control_id = ' ||
6123: TO_CHAR(p_posting_control_id));
6124: arp_util.debug('p_ra_post_loop_number = ' ||
6118: arp_util.debug('p_customer_trx_id = ' ||
6119: TO_CHAR(p_customer_trx_id));
6120: arp_util.debug('p_trx_number = ' ||
6121: p_trx_number);
6122: arp_util.debug('p_posting_control_id = ' ||
6123: TO_CHAR(p_posting_control_id));
6124: arp_util.debug('p_ra_post_loop_number = ' ||
6125: p_ra_post_loop_number);
6126: arp_util.debug('p_complete_flag = ' ||
6120: arp_util.debug('p_trx_number = ' ||
6121: p_trx_number);
6122: arp_util.debug('p_posting_control_id = ' ||
6123: TO_CHAR(p_posting_control_id));
6124: arp_util.debug('p_ra_post_loop_number = ' ||
6125: p_ra_post_loop_number);
6126: arp_util.debug('p_complete_flag = ' ||
6127: p_complete_flag);
6128: arp_util.debug('p_initial_customer_trx_id = ' ||
6122: arp_util.debug('p_posting_control_id = ' ||
6123: TO_CHAR(p_posting_control_id));
6124: arp_util.debug('p_ra_post_loop_number = ' ||
6125: p_ra_post_loop_number);
6126: arp_util.debug('p_complete_flag = ' ||
6127: p_complete_flag);
6128: arp_util.debug('p_initial_customer_trx_id = ' ||
6129: TO_CHAR(p_initial_customer_trx_id));
6130: arp_util.debug('p_previous_customer_trx_id = ' ||
6124: arp_util.debug('p_ra_post_loop_number = ' ||
6125: p_ra_post_loop_number);
6126: arp_util.debug('p_complete_flag = ' ||
6127: p_complete_flag);
6128: arp_util.debug('p_initial_customer_trx_id = ' ||
6129: TO_CHAR(p_initial_customer_trx_id));
6130: arp_util.debug('p_previous_customer_trx_id = ' ||
6131: TO_CHAR(p_previous_customer_trx_id));
6132: arp_util.debug('p_related_customer_trx_id = ' ||
6126: arp_util.debug('p_complete_flag = ' ||
6127: p_complete_flag);
6128: arp_util.debug('p_initial_customer_trx_id = ' ||
6129: TO_CHAR(p_initial_customer_trx_id));
6130: arp_util.debug('p_previous_customer_trx_id = ' ||
6131: TO_CHAR(p_previous_customer_trx_id));
6132: arp_util.debug('p_related_customer_trx_id = ' ||
6133: TO_CHAR(p_related_customer_trx_id));
6134: arp_util.debug('p_recurred_from_trx_number = ' ||
6128: arp_util.debug('p_initial_customer_trx_id = ' ||
6129: TO_CHAR(p_initial_customer_trx_id));
6130: arp_util.debug('p_previous_customer_trx_id = ' ||
6131: TO_CHAR(p_previous_customer_trx_id));
6132: arp_util.debug('p_related_customer_trx_id = ' ||
6133: TO_CHAR(p_related_customer_trx_id));
6134: arp_util.debug('p_recurred_from_trx_number = ' ||
6135: p_recurred_from_trx_number);
6136: arp_util.debug('p_cust_trx_type_id = ' ||
6130: arp_util.debug('p_previous_customer_trx_id = ' ||
6131: TO_CHAR(p_previous_customer_trx_id));
6132: arp_util.debug('p_related_customer_trx_id = ' ||
6133: TO_CHAR(p_related_customer_trx_id));
6134: arp_util.debug('p_recurred_from_trx_number = ' ||
6135: p_recurred_from_trx_number);
6136: arp_util.debug('p_cust_trx_type_id = ' ||
6137: TO_CHAR(p_cust_trx_type_id));
6138: arp_util.debug('p_batch_id = ' ||
6132: arp_util.debug('p_related_customer_trx_id = ' ||
6133: TO_CHAR(p_related_customer_trx_id));
6134: arp_util.debug('p_recurred_from_trx_number = ' ||
6135: p_recurred_from_trx_number);
6136: arp_util.debug('p_cust_trx_type_id = ' ||
6137: TO_CHAR(p_cust_trx_type_id));
6138: arp_util.debug('p_batch_id = ' ||
6139: TO_CHAR(p_batch_id));
6140: arp_util.debug('p_batch_source_id = ' ||
6134: arp_util.debug('p_recurred_from_trx_number = ' ||
6135: p_recurred_from_trx_number);
6136: arp_util.debug('p_cust_trx_type_id = ' ||
6137: TO_CHAR(p_cust_trx_type_id));
6138: arp_util.debug('p_batch_id = ' ||
6139: TO_CHAR(p_batch_id));
6140: arp_util.debug('p_batch_source_id = ' ||
6141: TO_CHAR(p_batch_source_id));
6142: arp_util.debug('p_agreement_id = ' ||
6136: arp_util.debug('p_cust_trx_type_id = ' ||
6137: TO_CHAR(p_cust_trx_type_id));
6138: arp_util.debug('p_batch_id = ' ||
6139: TO_CHAR(p_batch_id));
6140: arp_util.debug('p_batch_source_id = ' ||
6141: TO_CHAR(p_batch_source_id));
6142: arp_util.debug('p_agreement_id = ' ||
6143: TO_CHAR(p_agreement_id));
6144: arp_util.debug('p_trx_date = ' ||
6138: arp_util.debug('p_batch_id = ' ||
6139: TO_CHAR(p_batch_id));
6140: arp_util.debug('p_batch_source_id = ' ||
6141: TO_CHAR(p_batch_source_id));
6142: arp_util.debug('p_agreement_id = ' ||
6143: TO_CHAR(p_agreement_id));
6144: arp_util.debug('p_trx_date = ' ||
6145: p_trx_date);
6146: arp_util.debug('p_bill_to_customer_id = ' ||
6140: arp_util.debug('p_batch_source_id = ' ||
6141: TO_CHAR(p_batch_source_id));
6142: arp_util.debug('p_agreement_id = ' ||
6143: TO_CHAR(p_agreement_id));
6144: arp_util.debug('p_trx_date = ' ||
6145: p_trx_date);
6146: arp_util.debug('p_bill_to_customer_id = ' ||
6147: TO_CHAR(p_bill_to_customer_id));
6148: arp_util.debug('p_bill_to_contact_id = ' ||
6142: arp_util.debug('p_agreement_id = ' ||
6143: TO_CHAR(p_agreement_id));
6144: arp_util.debug('p_trx_date = ' ||
6145: p_trx_date);
6146: arp_util.debug('p_bill_to_customer_id = ' ||
6147: TO_CHAR(p_bill_to_customer_id));
6148: arp_util.debug('p_bill_to_contact_id = ' ||
6149: TO_CHAR(p_bill_to_contact_id));
6150: arp_util.debug('p_bill_to_site_use_id = ' ||
6144: arp_util.debug('p_trx_date = ' ||
6145: p_trx_date);
6146: arp_util.debug('p_bill_to_customer_id = ' ||
6147: TO_CHAR(p_bill_to_customer_id));
6148: arp_util.debug('p_bill_to_contact_id = ' ||
6149: TO_CHAR(p_bill_to_contact_id));
6150: arp_util.debug('p_bill_to_site_use_id = ' ||
6151: TO_CHAR(p_bill_to_site_use_id));
6152: arp_util.debug('p_ship_to_customer_id = ' ||
6146: arp_util.debug('p_bill_to_customer_id = ' ||
6147: TO_CHAR(p_bill_to_customer_id));
6148: arp_util.debug('p_bill_to_contact_id = ' ||
6149: TO_CHAR(p_bill_to_contact_id));
6150: arp_util.debug('p_bill_to_site_use_id = ' ||
6151: TO_CHAR(p_bill_to_site_use_id));
6152: arp_util.debug('p_ship_to_customer_id = ' ||
6153: TO_CHAR(p_ship_to_customer_id));
6154: arp_util.debug('p_ship_to_contact_id = ' ||
6148: arp_util.debug('p_bill_to_contact_id = ' ||
6149: TO_CHAR(p_bill_to_contact_id));
6150: arp_util.debug('p_bill_to_site_use_id = ' ||
6151: TO_CHAR(p_bill_to_site_use_id));
6152: arp_util.debug('p_ship_to_customer_id = ' ||
6153: TO_CHAR(p_ship_to_customer_id));
6154: arp_util.debug('p_ship_to_contact_id = ' ||
6155: TO_CHAR(p_ship_to_contact_id));
6156: arp_util.debug('p_ship_to_site_use_id = ' ||
6150: arp_util.debug('p_bill_to_site_use_id = ' ||
6151: TO_CHAR(p_bill_to_site_use_id));
6152: arp_util.debug('p_ship_to_customer_id = ' ||
6153: TO_CHAR(p_ship_to_customer_id));
6154: arp_util.debug('p_ship_to_contact_id = ' ||
6155: TO_CHAR(p_ship_to_contact_id));
6156: arp_util.debug('p_ship_to_site_use_id = ' ||
6157: TO_CHAR(p_ship_to_site_use_id));
6158: arp_util.debug('p_sold_to_customer_id = ' ||
6152: arp_util.debug('p_ship_to_customer_id = ' ||
6153: TO_CHAR(p_ship_to_customer_id));
6154: arp_util.debug('p_ship_to_contact_id = ' ||
6155: TO_CHAR(p_ship_to_contact_id));
6156: arp_util.debug('p_ship_to_site_use_id = ' ||
6157: TO_CHAR(p_ship_to_site_use_id));
6158: arp_util.debug('p_sold_to_customer_id = ' ||
6159: TO_CHAR(p_sold_to_customer_id));
6160: arp_util.debug('p_sold_to_site_use_id = ' ||
6154: arp_util.debug('p_ship_to_contact_id = ' ||
6155: TO_CHAR(p_ship_to_contact_id));
6156: arp_util.debug('p_ship_to_site_use_id = ' ||
6157: TO_CHAR(p_ship_to_site_use_id));
6158: arp_util.debug('p_sold_to_customer_id = ' ||
6159: TO_CHAR(p_sold_to_customer_id));
6160: arp_util.debug('p_sold_to_site_use_id = ' ||
6161: TO_CHAR(p_sold_to_site_use_id));
6162: arp_util.debug('p_sold_to_contact_id = ' ||
6156: arp_util.debug('p_ship_to_site_use_id = ' ||
6157: TO_CHAR(p_ship_to_site_use_id));
6158: arp_util.debug('p_sold_to_customer_id = ' ||
6159: TO_CHAR(p_sold_to_customer_id));
6160: arp_util.debug('p_sold_to_site_use_id = ' ||
6161: TO_CHAR(p_sold_to_site_use_id));
6162: arp_util.debug('p_sold_to_contact_id = ' ||
6163: TO_CHAR(p_sold_to_contact_id));
6164: arp_util.debug('p_customer_reference = ' ||
6158: arp_util.debug('p_sold_to_customer_id = ' ||
6159: TO_CHAR(p_sold_to_customer_id));
6160: arp_util.debug('p_sold_to_site_use_id = ' ||
6161: TO_CHAR(p_sold_to_site_use_id));
6162: arp_util.debug('p_sold_to_contact_id = ' ||
6163: TO_CHAR(p_sold_to_contact_id));
6164: arp_util.debug('p_customer_reference = ' ||
6165: p_customer_reference);
6166: arp_util.debug('p_customer_reference_date = ' ||
6160: arp_util.debug('p_sold_to_site_use_id = ' ||
6161: TO_CHAR(p_sold_to_site_use_id));
6162: arp_util.debug('p_sold_to_contact_id = ' ||
6163: TO_CHAR(p_sold_to_contact_id));
6164: arp_util.debug('p_customer_reference = ' ||
6165: p_customer_reference);
6166: arp_util.debug('p_customer_reference_date = ' ||
6167: p_customer_reference_date);
6168: arp_util.debug('p_cr_method_for_installments = ' ||
6162: arp_util.debug('p_sold_to_contact_id = ' ||
6163: TO_CHAR(p_sold_to_contact_id));
6164: arp_util.debug('p_customer_reference = ' ||
6165: p_customer_reference);
6166: arp_util.debug('p_customer_reference_date = ' ||
6167: p_customer_reference_date);
6168: arp_util.debug('p_cr_method_for_installments = ' ||
6169: p_cr_method_for_installments);
6170: arp_util.debug('p_credit_method_for_rules = ' ||
6164: arp_util.debug('p_customer_reference = ' ||
6165: p_customer_reference);
6166: arp_util.debug('p_customer_reference_date = ' ||
6167: p_customer_reference_date);
6168: arp_util.debug('p_cr_method_for_installments = ' ||
6169: p_cr_method_for_installments);
6170: arp_util.debug('p_credit_method_for_rules = ' ||
6171: p_credit_method_for_rules);
6172: arp_util.debug('p_start_date_commitment = ' ||
6166: arp_util.debug('p_customer_reference_date = ' ||
6167: p_customer_reference_date);
6168: arp_util.debug('p_cr_method_for_installments = ' ||
6169: p_cr_method_for_installments);
6170: arp_util.debug('p_credit_method_for_rules = ' ||
6171: p_credit_method_for_rules);
6172: arp_util.debug('p_start_date_commitment = ' ||
6173: p_start_date_commitment);
6174: arp_util.debug('p_end_date_commitment = ' ||
6168: arp_util.debug('p_cr_method_for_installments = ' ||
6169: p_cr_method_for_installments);
6170: arp_util.debug('p_credit_method_for_rules = ' ||
6171: p_credit_method_for_rules);
6172: arp_util.debug('p_start_date_commitment = ' ||
6173: p_start_date_commitment);
6174: arp_util.debug('p_end_date_commitment = ' ||
6175: p_end_date_commitment);
6176: arp_util.debug('p_exchange_date = ' ||
6170: arp_util.debug('p_credit_method_for_rules = ' ||
6171: p_credit_method_for_rules);
6172: arp_util.debug('p_start_date_commitment = ' ||
6173: p_start_date_commitment);
6174: arp_util.debug('p_end_date_commitment = ' ||
6175: p_end_date_commitment);
6176: arp_util.debug('p_exchange_date = ' ||
6177: p_exchange_date);
6178: arp_util.debug('p_exchange_rate = ' ||
6172: arp_util.debug('p_start_date_commitment = ' ||
6173: p_start_date_commitment);
6174: arp_util.debug('p_end_date_commitment = ' ||
6175: p_end_date_commitment);
6176: arp_util.debug('p_exchange_date = ' ||
6177: p_exchange_date);
6178: arp_util.debug('p_exchange_rate = ' ||
6179: p_exchange_rate);
6180: arp_util.debug('p_exchange_rate_type = ' ||
6174: arp_util.debug('p_end_date_commitment = ' ||
6175: p_end_date_commitment);
6176: arp_util.debug('p_exchange_date = ' ||
6177: p_exchange_date);
6178: arp_util.debug('p_exchange_rate = ' ||
6179: p_exchange_rate);
6180: arp_util.debug('p_exchange_rate_type = ' ||
6181: p_exchange_rate_type);
6182: arp_util.debug('p_customer_bank_account_id = ' ||
6176: arp_util.debug('p_exchange_date = ' ||
6177: p_exchange_date);
6178: arp_util.debug('p_exchange_rate = ' ||
6179: p_exchange_rate);
6180: arp_util.debug('p_exchange_rate_type = ' ||
6181: p_exchange_rate_type);
6182: arp_util.debug('p_customer_bank_account_id = ' ||
6183: TO_CHAR(p_customer_bank_account_id));
6184: arp_util.debug('p_finance_charges = ' ||
6178: arp_util.debug('p_exchange_rate = ' ||
6179: p_exchange_rate);
6180: arp_util.debug('p_exchange_rate_type = ' ||
6181: p_exchange_rate_type);
6182: arp_util.debug('p_customer_bank_account_id = ' ||
6183: TO_CHAR(p_customer_bank_account_id));
6184: arp_util.debug('p_finance_charges = ' ||
6185: p_finance_charges);
6186: arp_util.debug('p_fob_point = ' ||
6180: arp_util.debug('p_exchange_rate_type = ' ||
6181: p_exchange_rate_type);
6182: arp_util.debug('p_customer_bank_account_id = ' ||
6183: TO_CHAR(p_customer_bank_account_id));
6184: arp_util.debug('p_finance_charges = ' ||
6185: p_finance_charges);
6186: arp_util.debug('p_fob_point = ' ||
6187: p_fob_point);
6188: arp_util.debug('p_comments = ' ||
6182: arp_util.debug('p_customer_bank_account_id = ' ||
6183: TO_CHAR(p_customer_bank_account_id));
6184: arp_util.debug('p_finance_charges = ' ||
6185: p_finance_charges);
6186: arp_util.debug('p_fob_point = ' ||
6187: p_fob_point);
6188: arp_util.debug('p_comments = ' ||
6189: p_comments);
6190: arp_util.debug('p_internal_notes = ' ||
6184: arp_util.debug('p_finance_charges = ' ||
6185: p_finance_charges);
6186: arp_util.debug('p_fob_point = ' ||
6187: p_fob_point);
6188: arp_util.debug('p_comments = ' ||
6189: p_comments);
6190: arp_util.debug('p_internal_notes = ' ||
6191: p_internal_notes);
6192: arp_util.debug('p_invoice_currency_code = ' ||
6186: arp_util.debug('p_fob_point = ' ||
6187: p_fob_point);
6188: arp_util.debug('p_comments = ' ||
6189: p_comments);
6190: arp_util.debug('p_internal_notes = ' ||
6191: p_internal_notes);
6192: arp_util.debug('p_invoice_currency_code = ' ||
6193: p_invoice_currency_code);
6194: arp_util.debug('p_invoicing_rule_id = ' ||
6188: arp_util.debug('p_comments = ' ||
6189: p_comments);
6190: arp_util.debug('p_internal_notes = ' ||
6191: p_internal_notes);
6192: arp_util.debug('p_invoice_currency_code = ' ||
6193: p_invoice_currency_code);
6194: arp_util.debug('p_invoicing_rule_id = ' ||
6195: TO_CHAR(p_invoicing_rule_id));
6196: arp_util.debug('p_last_printed_sequence_num = ' ||
6190: arp_util.debug('p_internal_notes = ' ||
6191: p_internal_notes);
6192: arp_util.debug('p_invoice_currency_code = ' ||
6193: p_invoice_currency_code);
6194: arp_util.debug('p_invoicing_rule_id = ' ||
6195: TO_CHAR(p_invoicing_rule_id));
6196: arp_util.debug('p_last_printed_sequence_num = ' ||
6197: p_last_printed_sequence_num);
6198: arp_util.debug('p_orig_system_batch_name = ' ||
6192: arp_util.debug('p_invoice_currency_code = ' ||
6193: p_invoice_currency_code);
6194: arp_util.debug('p_invoicing_rule_id = ' ||
6195: TO_CHAR(p_invoicing_rule_id));
6196: arp_util.debug('p_last_printed_sequence_num = ' ||
6197: p_last_printed_sequence_num);
6198: arp_util.debug('p_orig_system_batch_name = ' ||
6199: p_orig_system_batch_name);
6200: arp_util.debug('p_primary_salesrep_id = ' ||
6194: arp_util.debug('p_invoicing_rule_id = ' ||
6195: TO_CHAR(p_invoicing_rule_id));
6196: arp_util.debug('p_last_printed_sequence_num = ' ||
6197: p_last_printed_sequence_num);
6198: arp_util.debug('p_orig_system_batch_name = ' ||
6199: p_orig_system_batch_name);
6200: arp_util.debug('p_primary_salesrep_id = ' ||
6201: TO_CHAR(p_primary_salesrep_id));
6202: arp_util.debug('p_printing_count = ' ||
6196: arp_util.debug('p_last_printed_sequence_num = ' ||
6197: p_last_printed_sequence_num);
6198: arp_util.debug('p_orig_system_batch_name = ' ||
6199: p_orig_system_batch_name);
6200: arp_util.debug('p_primary_salesrep_id = ' ||
6201: TO_CHAR(p_primary_salesrep_id));
6202: arp_util.debug('p_printing_count = ' ||
6203: p_printing_count);
6204: arp_util.debug('p_printing_last_printed = ' ||
6198: arp_util.debug('p_orig_system_batch_name = ' ||
6199: p_orig_system_batch_name);
6200: arp_util.debug('p_primary_salesrep_id = ' ||
6201: TO_CHAR(p_primary_salesrep_id));
6202: arp_util.debug('p_printing_count = ' ||
6203: p_printing_count);
6204: arp_util.debug('p_printing_last_printed = ' ||
6205: p_printing_last_printed);
6206: arp_util.debug('p_printing_option = ' ||
6200: arp_util.debug('p_primary_salesrep_id = ' ||
6201: TO_CHAR(p_primary_salesrep_id));
6202: arp_util.debug('p_printing_count = ' ||
6203: p_printing_count);
6204: arp_util.debug('p_printing_last_printed = ' ||
6205: p_printing_last_printed);
6206: arp_util.debug('p_printing_option = ' ||
6207: p_printing_option);
6208: arp_util.debug('p_printing_original_date = ' ||
6202: arp_util.debug('p_printing_count = ' ||
6203: p_printing_count);
6204: arp_util.debug('p_printing_last_printed = ' ||
6205: p_printing_last_printed);
6206: arp_util.debug('p_printing_option = ' ||
6207: p_printing_option);
6208: arp_util.debug('p_printing_original_date = ' ||
6209: p_printing_original_date);
6210: arp_util.debug('p_printing_pending = ' ||
6204: arp_util.debug('p_printing_last_printed = ' ||
6205: p_printing_last_printed);
6206: arp_util.debug('p_printing_option = ' ||
6207: p_printing_option);
6208: arp_util.debug('p_printing_original_date = ' ||
6209: p_printing_original_date);
6210: arp_util.debug('p_printing_pending = ' ||
6211: p_printing_pending);
6212: arp_util.debug('p_purchase_order = ' ||
6206: arp_util.debug('p_printing_option = ' ||
6207: p_printing_option);
6208: arp_util.debug('p_printing_original_date = ' ||
6209: p_printing_original_date);
6210: arp_util.debug('p_printing_pending = ' ||
6211: p_printing_pending);
6212: arp_util.debug('p_purchase_order = ' ||
6213: p_purchase_order);
6214: arp_util.debug('p_purchase_order_date = ' ||
6208: arp_util.debug('p_printing_original_date = ' ||
6209: p_printing_original_date);
6210: arp_util.debug('p_printing_pending = ' ||
6211: p_printing_pending);
6212: arp_util.debug('p_purchase_order = ' ||
6213: p_purchase_order);
6214: arp_util.debug('p_purchase_order_date = ' ||
6215: p_purchase_order_date);
6216: arp_util.debug('p_purchase_order_revision = ' ||
6210: arp_util.debug('p_printing_pending = ' ||
6211: p_printing_pending);
6212: arp_util.debug('p_purchase_order = ' ||
6213: p_purchase_order);
6214: arp_util.debug('p_purchase_order_date = ' ||
6215: p_purchase_order_date);
6216: arp_util.debug('p_purchase_order_revision = ' ||
6217: p_purchase_order_revision);
6218: arp_util.debug('p_receipt_method_id = ' ||
6212: arp_util.debug('p_purchase_order = ' ||
6213: p_purchase_order);
6214: arp_util.debug('p_purchase_order_date = ' ||
6215: p_purchase_order_date);
6216: arp_util.debug('p_purchase_order_revision = ' ||
6217: p_purchase_order_revision);
6218: arp_util.debug('p_receipt_method_id = ' ||
6219: TO_CHAR(p_receipt_method_id));
6220: arp_util.debug('p_remit_to_address_id = ' ||
6214: arp_util.debug('p_purchase_order_date = ' ||
6215: p_purchase_order_date);
6216: arp_util.debug('p_purchase_order_revision = ' ||
6217: p_purchase_order_revision);
6218: arp_util.debug('p_receipt_method_id = ' ||
6219: TO_CHAR(p_receipt_method_id));
6220: arp_util.debug('p_remit_to_address_id = ' ||
6221: TO_CHAR(p_remit_to_address_id));
6222: arp_util.debug('p_shipment_id = ' ||
6216: arp_util.debug('p_purchase_order_revision = ' ||
6217: p_purchase_order_revision);
6218: arp_util.debug('p_receipt_method_id = ' ||
6219: TO_CHAR(p_receipt_method_id));
6220: arp_util.debug('p_remit_to_address_id = ' ||
6221: TO_CHAR(p_remit_to_address_id));
6222: arp_util.debug('p_shipment_id = ' ||
6223: TO_CHAR(p_shipment_id));
6224: arp_util.debug('p_ship_date_actual = ' ||
6218: arp_util.debug('p_receipt_method_id = ' ||
6219: TO_CHAR(p_receipt_method_id));
6220: arp_util.debug('p_remit_to_address_id = ' ||
6221: TO_CHAR(p_remit_to_address_id));
6222: arp_util.debug('p_shipment_id = ' ||
6223: TO_CHAR(p_shipment_id));
6224: arp_util.debug('p_ship_date_actual = ' ||
6225: p_ship_date_actual);
6226: arp_util.debug('p_ship_via = ' ||
6220: arp_util.debug('p_remit_to_address_id = ' ||
6221: TO_CHAR(p_remit_to_address_id));
6222: arp_util.debug('p_shipment_id = ' ||
6223: TO_CHAR(p_shipment_id));
6224: arp_util.debug('p_ship_date_actual = ' ||
6225: p_ship_date_actual);
6226: arp_util.debug('p_ship_via = ' ||
6227: p_ship_via);
6228: arp_util.debug('p_term_due_date = ' ||
6222: arp_util.debug('p_shipment_id = ' ||
6223: TO_CHAR(p_shipment_id));
6224: arp_util.debug('p_ship_date_actual = ' ||
6225: p_ship_date_actual);
6226: arp_util.debug('p_ship_via = ' ||
6227: p_ship_via);
6228: arp_util.debug('p_term_due_date = ' ||
6229: p_term_due_date);
6230: arp_util.debug('p_term_id = ' ||
6224: arp_util.debug('p_ship_date_actual = ' ||
6225: p_ship_date_actual);
6226: arp_util.debug('p_ship_via = ' ||
6227: p_ship_via);
6228: arp_util.debug('p_term_due_date = ' ||
6229: p_term_due_date);
6230: arp_util.debug('p_term_id = ' ||
6231: TO_CHAR(p_term_id));
6232: arp_util.debug('p_territory_id = ' ||
6226: arp_util.debug('p_ship_via = ' ||
6227: p_ship_via);
6228: arp_util.debug('p_term_due_date = ' ||
6229: p_term_due_date);
6230: arp_util.debug('p_term_id = ' ||
6231: TO_CHAR(p_term_id));
6232: arp_util.debug('p_territory_id = ' ||
6233: TO_CHAR(p_territory_id));
6234: arp_util.debug('p_waybill_number = ' ||
6228: arp_util.debug('p_term_due_date = ' ||
6229: p_term_due_date);
6230: arp_util.debug('p_term_id = ' ||
6231: TO_CHAR(p_term_id));
6232: arp_util.debug('p_territory_id = ' ||
6233: TO_CHAR(p_territory_id));
6234: arp_util.debug('p_waybill_number = ' ||
6235: p_waybill_number);
6236: arp_util.debug('p_status_trx = ' ||
6230: arp_util.debug('p_term_id = ' ||
6231: TO_CHAR(p_term_id));
6232: arp_util.debug('p_territory_id = ' ||
6233: TO_CHAR(p_territory_id));
6234: arp_util.debug('p_waybill_number = ' ||
6235: p_waybill_number);
6236: arp_util.debug('p_status_trx = ' ||
6237: p_status_trx);
6238: arp_util.debug('p_reason_code = ' ||
6232: arp_util.debug('p_territory_id = ' ||
6233: TO_CHAR(p_territory_id));
6234: arp_util.debug('p_waybill_number = ' ||
6235: p_waybill_number);
6236: arp_util.debug('p_status_trx = ' ||
6237: p_status_trx);
6238: arp_util.debug('p_reason_code = ' ||
6239: p_reason_code);
6240: arp_util.debug('p_doc_sequence_id = ' ||
6234: arp_util.debug('p_waybill_number = ' ||
6235: p_waybill_number);
6236: arp_util.debug('p_status_trx = ' ||
6237: p_status_trx);
6238: arp_util.debug('p_reason_code = ' ||
6239: p_reason_code);
6240: arp_util.debug('p_doc_sequence_id = ' ||
6241: TO_CHAR(p_doc_sequence_id));
6242: arp_util.debug('p_doc_sequence_value = ' ||
6236: arp_util.debug('p_status_trx = ' ||
6237: p_status_trx);
6238: arp_util.debug('p_reason_code = ' ||
6239: p_reason_code);
6240: arp_util.debug('p_doc_sequence_id = ' ||
6241: TO_CHAR(p_doc_sequence_id));
6242: arp_util.debug('p_doc_sequence_value = ' ||
6243: p_doc_sequence_value);
6244: arp_util.debug('p_paying_customer_id = ' ||
6238: arp_util.debug('p_reason_code = ' ||
6239: p_reason_code);
6240: arp_util.debug('p_doc_sequence_id = ' ||
6241: TO_CHAR(p_doc_sequence_id));
6242: arp_util.debug('p_doc_sequence_value = ' ||
6243: p_doc_sequence_value);
6244: arp_util.debug('p_paying_customer_id = ' ||
6245: TO_CHAR(p_paying_customer_id));
6246: arp_util.debug('p_paying_site_use_id = ' ||
6240: arp_util.debug('p_doc_sequence_id = ' ||
6241: TO_CHAR(p_doc_sequence_id));
6242: arp_util.debug('p_doc_sequence_value = ' ||
6243: p_doc_sequence_value);
6244: arp_util.debug('p_paying_customer_id = ' ||
6245: TO_CHAR(p_paying_customer_id));
6246: arp_util.debug('p_paying_site_use_id = ' ||
6247: TO_CHAR(p_paying_site_use_id));
6248: arp_util.debug('p_related_batch_source_id = ' ||
6242: arp_util.debug('p_doc_sequence_value = ' ||
6243: p_doc_sequence_value);
6244: arp_util.debug('p_paying_customer_id = ' ||
6245: TO_CHAR(p_paying_customer_id));
6246: arp_util.debug('p_paying_site_use_id = ' ||
6247: TO_CHAR(p_paying_site_use_id));
6248: arp_util.debug('p_related_batch_source_id = ' ||
6249: TO_CHAR(p_related_batch_source_id));
6250: arp_util.debug('p_default_tax_exempt_flag = ' ||
6244: arp_util.debug('p_paying_customer_id = ' ||
6245: TO_CHAR(p_paying_customer_id));
6246: arp_util.debug('p_paying_site_use_id = ' ||
6247: TO_CHAR(p_paying_site_use_id));
6248: arp_util.debug('p_related_batch_source_id = ' ||
6249: TO_CHAR(p_related_batch_source_id));
6250: arp_util.debug('p_default_tax_exempt_flag = ' ||
6251: p_default_tax_exempt_flag);
6252: arp_util.debug('p_created_from = ' ||
6246: arp_util.debug('p_paying_site_use_id = ' ||
6247: TO_CHAR(p_paying_site_use_id));
6248: arp_util.debug('p_related_batch_source_id = ' ||
6249: TO_CHAR(p_related_batch_source_id));
6250: arp_util.debug('p_default_tax_exempt_flag = ' ||
6251: p_default_tax_exempt_flag);
6252: arp_util.debug('p_created_from = ' ||
6253: p_created_from);
6254: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
6248: arp_util.debug('p_related_batch_source_id = ' ||
6249: TO_CHAR(p_related_batch_source_id));
6250: arp_util.debug('p_default_tax_exempt_flag = ' ||
6251: p_default_tax_exempt_flag);
6252: arp_util.debug('p_created_from = ' ||
6253: p_created_from);
6254: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
6255: p_deflt_ussgl_trx_code_context);
6256: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
6250: arp_util.debug('p_default_tax_exempt_flag = ' ||
6251: p_default_tax_exempt_flag);
6252: arp_util.debug('p_created_from = ' ||
6253: p_created_from);
6254: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
6255: p_deflt_ussgl_trx_code_context);
6256: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
6257: p_deflt_ussgl_transaction_code);
6258: arp_util.debug('p_old_trx_number = ' ||
6252: arp_util.debug('p_created_from = ' ||
6253: p_created_from);
6254: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
6255: p_deflt_ussgl_trx_code_context);
6256: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
6257: p_deflt_ussgl_transaction_code);
6258: arp_util.debug('p_old_trx_number = ' ||
6259: p_old_trx_number);
6260: arp_util.debug('p_interface_header_context = ' ||
6254: arp_util.debug('p_deflt_ussgl_trx_code_context = ' ||
6255: p_deflt_ussgl_trx_code_context);
6256: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
6257: p_deflt_ussgl_transaction_code);
6258: arp_util.debug('p_old_trx_number = ' ||
6259: p_old_trx_number);
6260: arp_util.debug('p_interface_header_context = ' ||
6261: p_interface_header_context);
6262: arp_util.debug('p_interface_header_attribute1 = ' ||
6256: arp_util.debug('p_deflt_ussgl_transaction_code = ' ||
6257: p_deflt_ussgl_transaction_code);
6258: arp_util.debug('p_old_trx_number = ' ||
6259: p_old_trx_number);
6260: arp_util.debug('p_interface_header_context = ' ||
6261: p_interface_header_context);
6262: arp_util.debug('p_interface_header_attribute1 = ' ||
6263: p_interface_header_attribute1);
6264: arp_util.debug('p_interface_header_attribute2 = ' ||
6258: arp_util.debug('p_old_trx_number = ' ||
6259: p_old_trx_number);
6260: arp_util.debug('p_interface_header_context = ' ||
6261: p_interface_header_context);
6262: arp_util.debug('p_interface_header_attribute1 = ' ||
6263: p_interface_header_attribute1);
6264: arp_util.debug('p_interface_header_attribute2 = ' ||
6265: p_interface_header_attribute2);
6266: arp_util.debug('p_interface_header_attribute3 = ' ||
6260: arp_util.debug('p_interface_header_context = ' ||
6261: p_interface_header_context);
6262: arp_util.debug('p_interface_header_attribute1 = ' ||
6263: p_interface_header_attribute1);
6264: arp_util.debug('p_interface_header_attribute2 = ' ||
6265: p_interface_header_attribute2);
6266: arp_util.debug('p_interface_header_attribute3 = ' ||
6267: p_interface_header_attribute3);
6268: arp_util.debug('p_interface_header_attribute4 = ' ||
6262: arp_util.debug('p_interface_header_attribute1 = ' ||
6263: p_interface_header_attribute1);
6264: arp_util.debug('p_interface_header_attribute2 = ' ||
6265: p_interface_header_attribute2);
6266: arp_util.debug('p_interface_header_attribute3 = ' ||
6267: p_interface_header_attribute3);
6268: arp_util.debug('p_interface_header_attribute4 = ' ||
6269: p_interface_header_attribute4);
6270: arp_util.debug('p_interface_header_attribute5 = ' ||
6264: arp_util.debug('p_interface_header_attribute2 = ' ||
6265: p_interface_header_attribute2);
6266: arp_util.debug('p_interface_header_attribute3 = ' ||
6267: p_interface_header_attribute3);
6268: arp_util.debug('p_interface_header_attribute4 = ' ||
6269: p_interface_header_attribute4);
6270: arp_util.debug('p_interface_header_attribute5 = ' ||
6271: p_interface_header_attribute5);
6272: arp_util.debug('p_interface_header_attribute6 = ' ||
6266: arp_util.debug('p_interface_header_attribute3 = ' ||
6267: p_interface_header_attribute3);
6268: arp_util.debug('p_interface_header_attribute4 = ' ||
6269: p_interface_header_attribute4);
6270: arp_util.debug('p_interface_header_attribute5 = ' ||
6271: p_interface_header_attribute5);
6272: arp_util.debug('p_interface_header_attribute6 = ' ||
6273: p_interface_header_attribute6);
6274: arp_util.debug('p_interface_header_attribute7 = ' ||
6268: arp_util.debug('p_interface_header_attribute4 = ' ||
6269: p_interface_header_attribute4);
6270: arp_util.debug('p_interface_header_attribute5 = ' ||
6271: p_interface_header_attribute5);
6272: arp_util.debug('p_interface_header_attribute6 = ' ||
6273: p_interface_header_attribute6);
6274: arp_util.debug('p_interface_header_attribute7 = ' ||
6275: p_interface_header_attribute7);
6276: arp_util.debug('p_interface_header_attribute8 = ' ||
6270: arp_util.debug('p_interface_header_attribute5 = ' ||
6271: p_interface_header_attribute5);
6272: arp_util.debug('p_interface_header_attribute6 = ' ||
6273: p_interface_header_attribute6);
6274: arp_util.debug('p_interface_header_attribute7 = ' ||
6275: p_interface_header_attribute7);
6276: arp_util.debug('p_interface_header_attribute8 = ' ||
6277: p_interface_header_attribute8);
6278: arp_util.debug('p_interface_header_attribute9 = ' ||
6272: arp_util.debug('p_interface_header_attribute6 = ' ||
6273: p_interface_header_attribute6);
6274: arp_util.debug('p_interface_header_attribute7 = ' ||
6275: p_interface_header_attribute7);
6276: arp_util.debug('p_interface_header_attribute8 = ' ||
6277: p_interface_header_attribute8);
6278: arp_util.debug('p_interface_header_attribute9 = ' ||
6279: p_interface_header_attribute9);
6280: arp_util.debug('p_interface_header_attribute10 = ' ||
6274: arp_util.debug('p_interface_header_attribute7 = ' ||
6275: p_interface_header_attribute7);
6276: arp_util.debug('p_interface_header_attribute8 = ' ||
6277: p_interface_header_attribute8);
6278: arp_util.debug('p_interface_header_attribute9 = ' ||
6279: p_interface_header_attribute9);
6280: arp_util.debug('p_interface_header_attribute10 = ' ||
6281: p_interface_header_attribute10);
6282: arp_util.debug('p_interface_header_attribute11 = ' ||
6276: arp_util.debug('p_interface_header_attribute8 = ' ||
6277: p_interface_header_attribute8);
6278: arp_util.debug('p_interface_header_attribute9 = ' ||
6279: p_interface_header_attribute9);
6280: arp_util.debug('p_interface_header_attribute10 = ' ||
6281: p_interface_header_attribute10);
6282: arp_util.debug('p_interface_header_attribute11 = ' ||
6283: p_interface_header_attribute11);
6284: arp_util.debug('p_interface_header_attribute12 = ' ||
6278: arp_util.debug('p_interface_header_attribute9 = ' ||
6279: p_interface_header_attribute9);
6280: arp_util.debug('p_interface_header_attribute10 = ' ||
6281: p_interface_header_attribute10);
6282: arp_util.debug('p_interface_header_attribute11 = ' ||
6283: p_interface_header_attribute11);
6284: arp_util.debug('p_interface_header_attribute12 = ' ||
6285: p_interface_header_attribute12);
6286: arp_util.debug('p_interface_header_attribute13 = ' ||
6280: arp_util.debug('p_interface_header_attribute10 = ' ||
6281: p_interface_header_attribute10);
6282: arp_util.debug('p_interface_header_attribute11 = ' ||
6283: p_interface_header_attribute11);
6284: arp_util.debug('p_interface_header_attribute12 = ' ||
6285: p_interface_header_attribute12);
6286: arp_util.debug('p_interface_header_attribute13 = ' ||
6287: p_interface_header_attribute13);
6288: arp_util.debug('p_interface_header_attribute14 = ' ||
6282: arp_util.debug('p_interface_header_attribute11 = ' ||
6283: p_interface_header_attribute11);
6284: arp_util.debug('p_interface_header_attribute12 = ' ||
6285: p_interface_header_attribute12);
6286: arp_util.debug('p_interface_header_attribute13 = ' ||
6287: p_interface_header_attribute13);
6288: arp_util.debug('p_interface_header_attribute14 = ' ||
6289: p_interface_header_attribute14);
6290: arp_util.debug('p_interface_header_attribute15 = ' ||
6284: arp_util.debug('p_interface_header_attribute12 = ' ||
6285: p_interface_header_attribute12);
6286: arp_util.debug('p_interface_header_attribute13 = ' ||
6287: p_interface_header_attribute13);
6288: arp_util.debug('p_interface_header_attribute14 = ' ||
6289: p_interface_header_attribute14);
6290: arp_util.debug('p_interface_header_attribute15 = ' ||
6291: p_interface_header_attribute15);
6292: arp_util.debug('p_attribute_category = ' ||
6286: arp_util.debug('p_interface_header_attribute13 = ' ||
6287: p_interface_header_attribute13);
6288: arp_util.debug('p_interface_header_attribute14 = ' ||
6289: p_interface_header_attribute14);
6290: arp_util.debug('p_interface_header_attribute15 = ' ||
6291: p_interface_header_attribute15);
6292: arp_util.debug('p_attribute_category = ' ||
6293: p_attribute_category);
6294: arp_util.debug('p_attribute1 = ' ||
6288: arp_util.debug('p_interface_header_attribute14 = ' ||
6289: p_interface_header_attribute14);
6290: arp_util.debug('p_interface_header_attribute15 = ' ||
6291: p_interface_header_attribute15);
6292: arp_util.debug('p_attribute_category = ' ||
6293: p_attribute_category);
6294: arp_util.debug('p_attribute1 = ' ||
6295: p_attribute1);
6296: arp_util.debug('p_attribute2 = ' ||
6290: arp_util.debug('p_interface_header_attribute15 = ' ||
6291: p_interface_header_attribute15);
6292: arp_util.debug('p_attribute_category = ' ||
6293: p_attribute_category);
6294: arp_util.debug('p_attribute1 = ' ||
6295: p_attribute1);
6296: arp_util.debug('p_attribute2 = ' ||
6297: p_attribute2);
6298: arp_util.debug('p_attribute3 = ' ||
6292: arp_util.debug('p_attribute_category = ' ||
6293: p_attribute_category);
6294: arp_util.debug('p_attribute1 = ' ||
6295: p_attribute1);
6296: arp_util.debug('p_attribute2 = ' ||
6297: p_attribute2);
6298: arp_util.debug('p_attribute3 = ' ||
6299: p_attribute3);
6300: arp_util.debug('p_attribute4 = ' ||
6294: arp_util.debug('p_attribute1 = ' ||
6295: p_attribute1);
6296: arp_util.debug('p_attribute2 = ' ||
6297: p_attribute2);
6298: arp_util.debug('p_attribute3 = ' ||
6299: p_attribute3);
6300: arp_util.debug('p_attribute4 = ' ||
6301: p_attribute4);
6302: arp_util.debug('p_attribute5 = ' ||
6296: arp_util.debug('p_attribute2 = ' ||
6297: p_attribute2);
6298: arp_util.debug('p_attribute3 = ' ||
6299: p_attribute3);
6300: arp_util.debug('p_attribute4 = ' ||
6301: p_attribute4);
6302: arp_util.debug('p_attribute5 = ' ||
6303: p_attribute5);
6304: arp_util.debug('p_attribute6 = ' ||
6298: arp_util.debug('p_attribute3 = ' ||
6299: p_attribute3);
6300: arp_util.debug('p_attribute4 = ' ||
6301: p_attribute4);
6302: arp_util.debug('p_attribute5 = ' ||
6303: p_attribute5);
6304: arp_util.debug('p_attribute6 = ' ||
6305: p_attribute6);
6306: arp_util.debug('p_attribute7 = ' ||
6300: arp_util.debug('p_attribute4 = ' ||
6301: p_attribute4);
6302: arp_util.debug('p_attribute5 = ' ||
6303: p_attribute5);
6304: arp_util.debug('p_attribute6 = ' ||
6305: p_attribute6);
6306: arp_util.debug('p_attribute7 = ' ||
6307: p_attribute7);
6308: arp_util.debug('p_attribute8 = ' ||
6302: arp_util.debug('p_attribute5 = ' ||
6303: p_attribute5);
6304: arp_util.debug('p_attribute6 = ' ||
6305: p_attribute6);
6306: arp_util.debug('p_attribute7 = ' ||
6307: p_attribute7);
6308: arp_util.debug('p_attribute8 = ' ||
6309: p_attribute8);
6310: arp_util.debug('p_attribute9 = ' ||
6304: arp_util.debug('p_attribute6 = ' ||
6305: p_attribute6);
6306: arp_util.debug('p_attribute7 = ' ||
6307: p_attribute7);
6308: arp_util.debug('p_attribute8 = ' ||
6309: p_attribute8);
6310: arp_util.debug('p_attribute9 = ' ||
6311: p_attribute9);
6312: arp_util.debug('p_attribute10 = ' ||
6306: arp_util.debug('p_attribute7 = ' ||
6307: p_attribute7);
6308: arp_util.debug('p_attribute8 = ' ||
6309: p_attribute8);
6310: arp_util.debug('p_attribute9 = ' ||
6311: p_attribute9);
6312: arp_util.debug('p_attribute10 = ' ||
6313: p_attribute10);
6314: arp_util.debug('p_attribute11 = ' ||
6308: arp_util.debug('p_attribute8 = ' ||
6309: p_attribute8);
6310: arp_util.debug('p_attribute9 = ' ||
6311: p_attribute9);
6312: arp_util.debug('p_attribute10 = ' ||
6313: p_attribute10);
6314: arp_util.debug('p_attribute11 = ' ||
6315: p_attribute11);
6316: arp_util.debug('p_attribute12 = ' ||
6310: arp_util.debug('p_attribute9 = ' ||
6311: p_attribute9);
6312: arp_util.debug('p_attribute10 = ' ||
6313: p_attribute10);
6314: arp_util.debug('p_attribute11 = ' ||
6315: p_attribute11);
6316: arp_util.debug('p_attribute12 = ' ||
6317: p_attribute12);
6318: arp_util.debug('p_attribute13 = ' ||
6312: arp_util.debug('p_attribute10 = ' ||
6313: p_attribute10);
6314: arp_util.debug('p_attribute11 = ' ||
6315: p_attribute11);
6316: arp_util.debug('p_attribute12 = ' ||
6317: p_attribute12);
6318: arp_util.debug('p_attribute13 = ' ||
6319: p_attribute13);
6320: arp_util.debug('p_attribute14 = ' ||
6314: arp_util.debug('p_attribute11 = ' ||
6315: p_attribute11);
6316: arp_util.debug('p_attribute12 = ' ||
6317: p_attribute12);
6318: arp_util.debug('p_attribute13 = ' ||
6319: p_attribute13);
6320: arp_util.debug('p_attribute14 = ' ||
6321: p_attribute14);
6322: arp_util.debug('p_attribute15 = ' ||
6316: arp_util.debug('p_attribute12 = ' ||
6317: p_attribute12);
6318: arp_util.debug('p_attribute13 = ' ||
6319: p_attribute13);
6320: arp_util.debug('p_attribute14 = ' ||
6321: p_attribute14);
6322: arp_util.debug('p_attribute15 = ' ||
6323: p_attribute15);
6324:
6318: arp_util.debug('p_attribute13 = ' ||
6319: p_attribute13);
6320: arp_util.debug('p_attribute14 = ' ||
6321: p_attribute14);
6322: arp_util.debug('p_attribute15 = ' ||
6323: p_attribute15);
6324:
6325: RAISE;
6326: