eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_CT_PKG dependencies on ARP_CT_PKG

Line 1: PACKAGE BODY ARP_CT_PKG AS

1: PACKAGE BODY ARP_CT_PKG AS
2: /* $Header: ARTITRXB.pls 120.18.12010000.3 2008/09/04 12:25:19 dgaurab ship $ */
3:
4: /*---------------------------------------------------------------+
5: | Package global variables to hold the parsed update cursors. |

Line 88: arp_util.debug('arp_ct_pkg.bind_trx_variables()+');

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: +------------------*/

Line 629: arp_util.debug('arp_ct_pkg.bind_trx_variables()-');

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()');

Line 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:

Line 696: arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()+');

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 =

Line 1255: arp_util.debug('arp_ct_pkg.construct_trx_update_stmt()-');

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()');

Line 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:

Line 1295: arp_util.debug('arp_ct_pkg.construct_global_attr_stmt()+');

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,

Line 1422: arp_util.debug('arp_ct_pkg.construct_global_attr_stmt()-');

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;

Line 1425: arp_util.debug('EXCEPTION: arp_ct_pkg.construct_global_attr_stmt()');

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:

Line 1480: arp_util.debug('arp_ct_pkg.generic_update()+');

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. |

Line 1498: arp_ct_pkg.construct_trx_update_stmt(l_update_statement_1);

1494: /*---------------------------------+
1495: | Construct the update statement |
1496: +---------------------------------*/
1497:
1498: arp_ct_pkg.construct_trx_update_stmt(l_update_statement_1);
1499: arp_ct_pkg.construct_global_attr_stmt(l_update_statement_2);
1500:
1501: l_update_statement := l_update_statement_1 || l_update_statement_2;
1502:

Line 1499: arp_ct_pkg.construct_global_attr_stmt(l_update_statement_2);

1495: | Construct the update statement |
1496: +---------------------------------*/
1497:
1498: arp_ct_pkg.construct_trx_update_stmt(l_update_statement_1);
1499: arp_ct_pkg.construct_global_attr_stmt(l_update_statement_2);
1500:
1501: l_update_statement := l_update_statement_1 || l_update_statement_2;
1502:
1503: l_update_statement := l_update_statement || p_where_clause;

Line 1522: arp_ct_pkg.bind_trx_variables(p_update_cursor, p_trx_rec);

1518: dbms_sql.v7);
1519:
1520: END IF;
1521:
1522: arp_ct_pkg.bind_trx_variables(p_update_cursor, p_trx_rec);
1523:
1524: /*----------------------------+
1525: | Bind output variable |
1526: +----------------------------*/

Line 1571: arp_util.debug('arp_ct_pkg.generic_update()-');

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()');

Line 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;

Line 1642: arp_util.debug('arp_ct_pkg.set_to_dummy()+');

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;

Line 1816: arp_util.debug('arp_ct_pkg.set_to_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()');

Line 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:

Line 1859: arp_util.debug('arp_ct_pkg.lock_p()+');

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

Line 1868: arp_util.debug('arp_ct_pkg.lock_p()-');

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' );

Line 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: /*===========================================================================+

Line 1909: arp_util.debug('arp_ct_pkg.lock_fetch_p()+');

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

Line 1917: arp_util.debug('arp_ct_pkg.lock_fetch_p()-');

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' );

Line 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: /*============================================================================+

Line 1987: arp_util.debug('arp_ct_pkg.lock_compare_p()+');

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

Line 3332: arp_util.debug('arp_ct_pkg.lock_compare_p()-');

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(

Line 3337: 'EXCEPTION: arp_ct_pkg.lock_compare_p NO_DATA_FOUND' );

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 =============');
3341: display_header_p(p_customer_trx_id);

Line 3349: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_compare_p' );

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:

Line 3387: arp_util.debug('arp_ct_pkg.fetch_p()+');

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

Line 3394: arp_util.debug('arp_ct_pkg.fetch_p()-');

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' );

Line 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: /*===========================================================================+

Line 3438: arp_util.debug('arp_ct_pkg.delete_p()+');

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:

Line 3455: arp_util.debug('arp_ct_pkg.delete_p()-');

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()');

Line 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;

Line 3504: arp_util.debug('arp_ct_pkg.update_p()+ ' ||

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',

Line 3507: arp_ct_pkg.generic_update( pg_cursor1,

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',
3509: p_customer_trx_id,
3510: p_trx_rec);
3511:

Line 3512: arp_util.debug('arp_ct_pkg.update_p()- ' ||

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,

Line 3555: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p()');

3551:
3552:
3553: EXCEPTION
3554: WHEN OTHERS THEN
3555: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p()');
3556: RAISE;
3557: END;
3558:
3559: /*===========================================================================+

Line 3606: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p_print()');

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:

Line 3692: arp_util.debug('arp_ct_pkg.insert_p()+');

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:

Line 4190: arp_util.debug('arp_ct_pkg.insert_p()-');

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()');

Line 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: /*===========================================================================+

Line 4232: arp_util.debug('arp_ct_pkg.display_header_p()+');

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);

Line 4234: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);

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);
4237:
4238: arp_util.debug('arp_ct_pkg.display_header_p()-');

Line 4236: arp_ct_pkg.display_header_rec(l_trx_rec);

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);
4237:
4238: arp_util.debug('arp_ct_pkg.display_header_p()-');
4239:
4240: EXCEPTION

Line 4238: arp_util.debug('arp_ct_pkg.display_header_p()-');

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()');

Line 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:

Line 4298: arp_util.debug('arp_ct_pkg.display_header_rec()+');

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);

Line 4509: arp_util.debug('arp_ct_pkg.display_header_rec()-');

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()');

Line 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:

Line 4559: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');

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. |

Line 4566: arp_ct_pkg.set_to_dummy(l_trx_rec);

4562: | Populate the header record with the values |
4563: | passed in as parameters. |
4564: +------------------------------------------------*/
4565:
4566: arp_ct_pkg.set_to_dummy(l_trx_rec);
4567:
4568: l_trx_rec.customer_trx_id := p_customer_trx_id;
4569: l_trx_rec.ship_via := p_ship_via;
4570: l_trx_rec.ship_date_actual := p_ship_date_actual;

Line 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()');

Line 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 );

Line 4865: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');

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. |

Line 4872: arp_ct_pkg.set_to_dummy(l_trx_rec);

4868: | Populate the header record with the values |
4869: | passed in as parameters. |
4870: +------------------------------------------------*/
4871:
4872: arp_ct_pkg.set_to_dummy(l_trx_rec);
4873:
4874: l_trx_rec.customer_trx_id := p_customer_trx_id;
4875: l_trx_rec.trx_number := p_trx_number;
4876:

Line 4993: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');

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()');

Line 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 = ' ||

Line 5242: arp_util.debug('arp_ct_pkg.get_text_dummy()+');

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);

Line 5244: arp_util.debug('arp_ct_pkg.get_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

Line 5250: arp_util.debug('EXCEPTION: arp_ct_pkg.get_text_dummy()');

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:

Line 5287: arp_util.debug('arp_ct_pkg.get_flag_dummy()+');

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);

Line 5289: arp_util.debug('arp_ct_pkg.get_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

Line 5295: arp_util.debug('EXCEPTION: arp_ct_pkg.get_flag_dummy()');

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:

Line 5330: arp_util.debug('arp_ct_pkg.get_number_dummy()+');

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);

Line 5332: arp_util.debug('arp_ct_pkg.get_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

Line 5338: arp_util.debug('EXCEPTION: arp_ct_pkg.get_number_dummy()');

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:

Line 5373: arp_util.debug('arp_ct_pkg.get_date_dummy()+');

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);

Line 5375: arp_util.debug('arp_ct_pkg.get_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

Line 5381: arp_util.debug('EXCEPTION: arp_ct_pkg.get_date_dummy()');

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:

Line 5463: arp_util.debug('arp_ct_pkg.update_tax()+ ' ||

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 |

Line 5612: arp_util.debug('arp_ct_pkg.update_tax()- ' ||

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

Line 5618: arp_util.debug('EXCEPTION: arp_ct_pkg.update_tax()');

5614:
5615:
5616: EXCEPTION
5617: WHEN OTHERS THEN
5618: arp_util.debug('EXCEPTION: arp_ct_pkg.update_tax()');
5619: RAISE;
5620: END ;
5621:
5622: /*===========================================================================+

Line 5950: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');

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. |

Line 5957: arp_ct_pkg.set_to_dummy(l_trx_rec);

5953: | Populate the header record with the values |
5954: | passed in as parameters. |
5955: +------------------------------------------------*/
5956:
5957: arp_ct_pkg.set_to_dummy(l_trx_rec);
5958:
5959: l_trx_rec.customer_trx_id := p_customer_trx_id;
5960: l_trx_rec.trx_number := p_trx_number;
5961:

Line 6110: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');

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()');

Line 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 = ' ||

Line 6343: END ARP_CT_PKG;

6339: pg_prog_appl_id := fnd_global.prog_appl_id;
6340: pg_conc_program_id := fnd_global.conc_program_id;
6341:
6342:
6343: END ARP_CT_PKG;