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.23 2011/01/16 08:18:21 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 1988: arp_util.debug('arp_ct_pkg.lock_compare_p()+');

1984:
1985: l_new_trx_rec ra_customer_trx%rowtype;
1986:
1987: BEGIN
1988: arp_util.debug('arp_ct_pkg.lock_compare_p()+');
1989:
1990: IF p_lock_trx_flag THEN
1991: SELECT *
1992: INTO l_new_trx_rec

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

4671: p_trx_rec.billing_date),
4672: AR_DATE_DUMMY
4673: );
4674: END IF;
4675: arp_util.debug('arp_ct_pkg.lock_compare_p()-');
4676:
4677: EXCEPTION
4678: WHEN NO_DATA_FOUND THEN
4679: arp_util.debug(

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

4676:
4677: EXCEPTION
4678: WHEN NO_DATA_FOUND THEN
4679: arp_util.debug(
4680: 'EXCEPTION: arp_ct_pkg.lock_compare_p NO_DATA_FOUND' );
4681:
4682: arp_util.debug('');
4683: arp_util.debug('============= Old Record =============');
4684: display_header_p(p_customer_trx_id);

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

4688:
4689: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
4690: APP_EXCEPTION.Raise_Exception;
4691: WHEN OTHERS THEN
4692: arp_util.debug( 'EXCEPTION: arp_ct_pkg.lock_compare_p' );
4693: RAISE;
4694: END;
4695:
4696:

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

4726: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type )
4727: IS
4728:
4729: BEGIN
4730: arp_util.debug('arp_ct_pkg.fetch_p()+');
4731:
4732: SELECT *
4733: INTO p_trx_rec
4734: FROM ra_customer_trx

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

4733: INTO p_trx_rec
4734: FROM ra_customer_trx
4735: WHERE customer_trx_id = p_customer_trx_id;
4736:
4737: arp_util.debug('arp_ct_pkg.fetch_p()-');
4738:
4739: EXCEPTION
4740: WHEN OTHERS THEN
4741: arp_util.debug( 'EXCEPTION: arp_ct_pkg.fetch_p' );

Line 4741: arp_util.debug( 'EXCEPTION: arp_ct_pkg.fetch_p' );

4737: arp_util.debug('arp_ct_pkg.fetch_p()-');
4738:
4739: EXCEPTION
4740: WHEN OTHERS THEN
4741: arp_util.debug( 'EXCEPTION: arp_ct_pkg.fetch_p' );
4742: RAISE;
4743: END;
4744:
4745: /*===========================================================================+

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

4777:
4778: BEGIN
4779:
4780:
4781: arp_util.debug('arp_ct_pkg.delete_p()+');
4782:
4783: DELETE FROM ra_customer_trx
4784: WHERE customer_trx_id = p_customer_trx_id;
4785:

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

4794: -- p_mode => 'SINGLE',
4795: -- p_key_value => p_customer_trx_id);
4796: --}
4797: --
4798: arp_util.debug('arp_ct_pkg.delete_p()-');
4799:
4800: EXCEPTION
4801: WHEN OTHERS THEN
4802: arp_util.debug('EXCEPTION: arp_ct_pkg.delete_p()');

Line 4802: arp_util.debug('EXCEPTION: arp_ct_pkg.delete_p()');

4798: arp_util.debug('arp_ct_pkg.delete_p()-');
4799:
4800: EXCEPTION
4801: WHEN OTHERS THEN
4802: arp_util.debug('EXCEPTION: arp_ct_pkg.delete_p()');
4803:
4804: RAISE;
4805:
4806: END;

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

4843: l_ct_reference varchar2(150);
4844: --2528261 end
4845: BEGIN
4846:
4847: arp_util.debug('arp_ct_pkg.update_p()+ ' ||
4848: to_char(sysdate, 'HH:MI:SS'));
4849:
4850: arp_ct_pkg.generic_update( pg_cursor1,
4851: ' WHERE customer_trx_id = :where_1',

Line 4850: arp_ct_pkg.generic_update( pg_cursor1,

4846:
4847: arp_util.debug('arp_ct_pkg.update_p()+ ' ||
4848: to_char(sysdate, 'HH:MI:SS'));
4849:
4850: arp_ct_pkg.generic_update( pg_cursor1,
4851: ' WHERE customer_trx_id = :where_1',
4852: p_customer_trx_id,
4853: p_trx_rec);
4854:

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

4851: ' WHERE customer_trx_id = :where_1',
4852: p_customer_trx_id,
4853: p_trx_rec);
4854:
4855: arp_util.debug('arp_ct_pkg.update_p()- ' ||
4856: to_char(sysdate, 'HH:MI:SS'));
4857: --2528261 begin
4858: begin
4859: SELECT DECODE(DEFAULT_REFERENCE,

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

4894:
4895:
4896: EXCEPTION
4897: WHEN OTHERS THEN
4898: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p()');
4899: RAISE;
4900: END;
4901:
4902: /*===========================================================================+

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

4945: null,
4946: 'PRINT');
4947: EXCEPTION
4948: WHEN OTHERS THEN
4949: arp_util.debug('EXCEPTION: arp_ct_pkg.update_p_print()');
4950: RAISE;
4951: END;
4952:
4953:

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

5031: l_legal_entity_id number;
5032:
5033: BEGIN
5034:
5035: arp_util.debug('arp_ct_pkg.insert_p()+');
5036:
5037: arp_util.debug('CM trx number :' || p_trx_number );
5038: --p_trx_number := '';
5039:

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

5531:
5532: p_trx_number := l_trx_number;
5533: p_customer_trx_id := l_customer_trx_id;
5534:
5535: arp_util.debug('arp_ct_pkg.insert_p()-');
5536:
5537: EXCEPTION
5538: WHEN OTHERS THEN
5539: arp_util.debug('EXCEPTION: arp_ct_pkg.insert_p()');

Line 5539: arp_util.debug('EXCEPTION: arp_ct_pkg.insert_p()');

5535: arp_util.debug('arp_ct_pkg.insert_p()-');
5536:
5537: EXCEPTION
5538: WHEN OTHERS THEN
5539: arp_util.debug('EXCEPTION: arp_ct_pkg.insert_p()');
5540: RAISE;
5541: END;
5542:
5543: /*===========================================================================+

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

5573: l_trx_rec ra_customer_trx%rowtype;
5574:
5575: BEGIN
5576:
5577: arp_util.debug('arp_ct_pkg.display_header_p()+');
5578:
5579: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);
5580:
5581: arp_ct_pkg.display_header_rec(l_trx_rec);

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

5575: BEGIN
5576:
5577: arp_util.debug('arp_ct_pkg.display_header_p()+');
5578:
5579: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);
5580:
5581: arp_ct_pkg.display_header_rec(l_trx_rec);
5582:
5583: arp_util.debug('arp_ct_pkg.display_header_p()-');

Line 5581: arp_ct_pkg.display_header_rec(l_trx_rec);

5577: arp_util.debug('arp_ct_pkg.display_header_p()+');
5578:
5579: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);
5580:
5581: arp_ct_pkg.display_header_rec(l_trx_rec);
5582:
5583: arp_util.debug('arp_ct_pkg.display_header_p()-');
5584:
5585: EXCEPTION

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

5579: arp_ct_pkg.fetch_p(l_trx_rec, p_customer_trx_id);
5580:
5581: arp_ct_pkg.display_header_rec(l_trx_rec);
5582:
5583: arp_util.debug('arp_ct_pkg.display_header_p()-');
5584:
5585: EXCEPTION
5586: WHEN OTHERS THEN
5587: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_p()');

Line 5587: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_p()');

5583: arp_util.debug('arp_ct_pkg.display_header_p()-');
5584:
5585: EXCEPTION
5586: WHEN OTHERS THEN
5587: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_p()');
5588: RAISE;
5589:
5590: END;
5591:

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

5639: PROCEDURE display_header_rec ( p_trx_rec IN ra_customer_trx%rowtype ) IS
5640:
5641: BEGIN
5642:
5643: arp_util.debug('arp_ct_pkg.display_header_rec()+');
5644:
5645: arp_util.debug('************ Dump of ra_customer_trx record ************');
5646: arp_util.debug('customer_trx_id: ' || p_trx_rec.customer_trx_id);
5647: arp_util.debug('trx_number: ' || p_trx_rec.trx_number);

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

5850: arp_util.debug('billing_date: ' || p_trx_rec.billing_date);
5851:
5852: arp_util.debug('************* End ra_customer_trx record *************');
5853:
5854: arp_util.debug('arp_ct_pkg.display_header_rec()-');
5855:
5856: EXCEPTION
5857: WHEN OTHERS THEN
5858: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_rec()');

Line 5858: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_rec()');

5854: arp_util.debug('arp_ct_pkg.display_header_rec()-');
5855:
5856: EXCEPTION
5857: WHEN OTHERS THEN
5858: arp_util.debug('EXCEPTION: arp_ct_pkg.display_header_rec()');
5859: RAISE;
5860:
5861: END;
5862:

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

5900: p_fob_point IN ra_customer_trx.fob_point%type)
5901: IS
5902: l_trx_rec ra_customer_trx%rowtype;
5903: BEGIN
5904: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()+');
5905:
5906: /*------------------------------------------------+
5907: | Populate the header record with the values |
5908: | passed in as parameters. |

Line 5911: arp_ct_pkg.set_to_dummy(l_trx_rec);

5907: | Populate the header record with the values |
5908: | passed in as parameters. |
5909: +------------------------------------------------*/
5910:
5911: arp_ct_pkg.set_to_dummy(l_trx_rec);
5912:
5913: l_trx_rec.customer_trx_id := p_customer_trx_id;
5914: l_trx_rec.ship_via := p_ship_via;
5915: l_trx_rec.ship_date_actual := p_ship_date_actual;

Line 5926: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()-');

5922: arp_util.debug('calling lock compare p with p_customer_trx_id = ' || to_char(p_customer_trx_id));
5923:
5924: lock_compare_p( l_trx_rec, p_customer_trx_id);
5925:
5926: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()-');
5927:
5928: EXCEPTION
5929: WHEN OTHERS THEN
5930: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');

Line 5930: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');

5926: arp_util.debug('arp_ct_pkg.lock_compare_frt_cover()-');
5927:
5928: EXCEPTION
5929: WHEN OTHERS THEN
5930: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_frt_cover()');
5931:
5932: arp_util.debug('----- parameters for lock_compare_frt_cover() ' ||
5933: '-----');
5934: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );

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

6207:
6208: l_trx_rec ra_customer_trx%rowtype;
6209:
6210: BEGIN
6211: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
6212:
6213: /*------------------------------------------------+
6214: | Populate the header record with the values |
6215: | passed in as parameters. |

Line 6218: arp_ct_pkg.set_to_dummy(l_trx_rec);

6214: | Populate the header record with the values |
6215: | passed in as parameters. |
6216: +------------------------------------------------*/
6217:
6218: arp_ct_pkg.set_to_dummy(l_trx_rec);
6219:
6220: l_trx_rec.customer_trx_id := p_customer_trx_id;
6221: l_trx_rec.trx_number := p_trx_number;
6222:

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

6335: +-----------------------------------------*/
6336:
6337: lock_compare_p( l_trx_rec, p_customer_trx_id, p_lock_trx_flag);
6338:
6339: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
6340:
6341: EXCEPTION
6342: WHEN OTHERS THEN
6343: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');

Line 6343: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');

6339: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
6340:
6341: EXCEPTION
6342: WHEN OTHERS THEN
6343: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
6344:
6345: arp_util.debug('----- parameters for lock_compare_cover() ' ||
6346: '-----');
6347: arp_util.debug('p_customer_trx_id = ' ||

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

6584: FUNCTION get_text_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
6585:
6586: BEGIN
6587:
6588: arp_util.debug('arp_ct_pkg.get_text_dummy()+');
6589:
6590: arp_util.debug('arp_ct_pkg.get_text_dummy()-');
6591:
6592: return(AR_TEXT_DUMMY);

Line 6590: arp_util.debug('arp_ct_pkg.get_text_dummy()-');

6586: BEGIN
6587:
6588: arp_util.debug('arp_ct_pkg.get_text_dummy()+');
6589:
6590: arp_util.debug('arp_ct_pkg.get_text_dummy()-');
6591:
6592: return(AR_TEXT_DUMMY);
6593:
6594: EXCEPTION

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

6592: return(AR_TEXT_DUMMY);
6593:
6594: EXCEPTION
6595: WHEN OTHERS THEN
6596: arp_util.debug('EXCEPTION: arp_ct_pkg.get_text_dummy()');
6597: RAISE;
6598:
6599: END;
6600:

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

6629: FUNCTION get_flag_dummy(p_null IN NUMBER DEFAULT null) RETURN varchar2 IS
6630:
6631: BEGIN
6632:
6633: arp_util.debug('arp_ct_pkg.get_flag_dummy()+');
6634:
6635: arp_util.debug('arp_ct_pkg.get_flag_dummy()-');
6636:
6637: return(AR_FLAG_DUMMY);

Line 6635: arp_util.debug('arp_ct_pkg.get_flag_dummy()-');

6631: BEGIN
6632:
6633: arp_util.debug('arp_ct_pkg.get_flag_dummy()+');
6634:
6635: arp_util.debug('arp_ct_pkg.get_flag_dummy()-');
6636:
6637: return(AR_FLAG_DUMMY);
6638:
6639: EXCEPTION

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

6637: return(AR_FLAG_DUMMY);
6638:
6639: EXCEPTION
6640: WHEN OTHERS THEN
6641: arp_util.debug('EXCEPTION: arp_ct_pkg.get_flag_dummy()');
6642: RAISE;
6643:
6644: END;
6645:

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

6672: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
6673:
6674: BEGIN
6675:
6676: arp_util.debug('arp_ct_pkg.get_number_dummy()+');
6677:
6678: arp_util.debug('arp_ct_pkg.get_number_dummy()-');
6679:
6680: return(AR_NUMBER_DUMMY);

Line 6678: arp_util.debug('arp_ct_pkg.get_number_dummy()-');

6674: BEGIN
6675:
6676: arp_util.debug('arp_ct_pkg.get_number_dummy()+');
6677:
6678: arp_util.debug('arp_ct_pkg.get_number_dummy()-');
6679:
6680: return(AR_NUMBER_DUMMY);
6681:
6682: EXCEPTION

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

6680: return(AR_NUMBER_DUMMY);
6681:
6682: EXCEPTION
6683: WHEN OTHERS THEN
6684: arp_util.debug('EXCEPTION: arp_ct_pkg.get_number_dummy()');
6685: RAISE;
6686:
6687: END;
6688:

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

6715: FUNCTION get_date_dummy(p_null IN NUMBER DEFAULT null) RETURN date IS
6716:
6717: BEGIN
6718:
6719: arp_util.debug('arp_ct_pkg.get_date_dummy()+');
6720:
6721: arp_util.debug('arp_ct_pkg.get_date_dummy()-');
6722:
6723: return(AR_DATE_DUMMY);

Line 6721: arp_util.debug('arp_ct_pkg.get_date_dummy()-');

6717: BEGIN
6718:
6719: arp_util.debug('arp_ct_pkg.get_date_dummy()+');
6720:
6721: arp_util.debug('arp_ct_pkg.get_date_dummy()-');
6722:
6723: return(AR_DATE_DUMMY);
6724:
6725: EXCEPTION

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

6723: return(AR_DATE_DUMMY);
6724:
6725: EXCEPTION
6726: WHEN OTHERS THEN
6727: arp_util.debug('EXCEPTION: arp_ct_pkg.get_date_dummy()');
6728: RAISE;
6729:
6730: END;
6731:

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

6805: l_success BOOLEAN;
6806:
6807: BEGIN
6808:
6809: arp_util.debug('arp_ct_pkg.update_tax()+ ' ||
6810: to_char(sysdate, 'HH:MI:SS'));
6811:
6812: /*------------------------------------------------+
6813: | Call Tax API to get the value of vat_tax_id |

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

6954: where customer_trx_line_id = line.customer_trx_line_id;
6955:
6956: END LOOP;
6957: END IF;
6958: arp_util.debug('arp_ct_pkg.update_tax()- ' ||
6959: to_char(sysdate, 'HH:MI:SS'));
6960:
6961:
6962: EXCEPTION

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

6960:
6961:
6962: EXCEPTION
6963: WHEN OTHERS THEN
6964: arp_util.debug('EXCEPTION: arp_ct_pkg.update_tax()');
6965: RAISE;
6966: END ;
6967:
6968: /*===========================================================================+

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

7292:
7293: l_trx_rec ra_customer_trx%rowtype;
7294:
7295: BEGIN
7296: arp_util.debug('arp_ct_pkg.lock_compare_cover()+');
7297:
7298: /*------------------------------------------------+
7299: | Populate the header record with the values |
7300: | passed in as parameters. |

Line 7303: arp_ct_pkg.set_to_dummy(l_trx_rec);

7299: | Populate the header record with the values |
7300: | passed in as parameters. |
7301: +------------------------------------------------*/
7302:
7303: arp_ct_pkg.set_to_dummy(l_trx_rec);
7304:
7305: l_trx_rec.customer_trx_id := p_customer_trx_id;
7306: l_trx_rec.trx_number := p_trx_number;
7307:

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

7452: +-----------------------------------------*/
7453:
7454: lock_compare_p( l_trx_rec, p_customer_trx_id);
7455:
7456: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
7457:
7458: EXCEPTION
7459: WHEN OTHERS THEN
7460: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');

Line 7460: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');

7456: arp_util.debug('arp_ct_pkg.lock_compare_cover()-');
7457:
7458: EXCEPTION
7459: WHEN OTHERS THEN
7460: arp_util.debug('EXCEPTION : arp_ct_pkg.lock_compare_cover()');
7461:
7462: arp_util.debug('----- parameters for lock_compare_cover() ' ||
7463: '-----');
7464: arp_util.debug('p_customer_trx_id = ' ||

Line 7689: END ARP_CT_PKG;

7685: pg_prog_appl_id := fnd_global.prog_appl_id;
7686: pg_conc_program_id := fnd_global.conc_program_id;
7687:
7688:
7689: END ARP_CT_PKG;