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_CTLS_PKG dependencies on ARP_CTLS_PKG

Line 1: PACKAGE BODY ARP_CTLS_PKG AS

1: PACKAGE BODY ARP_CTLS_PKG AS
2: /* $Header: ARTITLSB.pls 120.14.12010000.1 2008/07/24 16:57:02 appldev ship $ */
3: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
4:
5: pg_salesrep_required_flag ar_system_parameters.salesrep_required_flag%type;

Line 77: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()+');

73: l_dist_rec ra_cust_trx_line_gl_dist%rowtype;
74:
75: BEGIN
76:
77: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()+');
78:
79:
80:
81: /*------------------------------------------------------------------+

Line 93: arp_ctls_pkg.set_to_dummy(l_srep_rec);

89: | and erase ra_cust_trx_line_gl_dist.cust_trx_line_salesrep_id |
90: +-------------------------------------------------------------------*/
91:
92: BEGIN
93: arp_ctls_pkg.set_to_dummy(l_srep_rec);
94:
95: l_srep_rec.prev_cust_trx_line_salesrep_id := null;
96:
97: arp_ctlgd_pkg.set_to_dummy(l_dist_rec);

Line 109: arp_ctls_pkg.update_f_ct_id(l_srep_rec,

105:
106: IF ( p_customer_trx_id IS NOT NULL )
107: THEN
108: BEGIN
109: arp_ctls_pkg.update_f_ct_id(l_srep_rec,
110: p_customer_trx_id);
111: EXCEPTION
112: WHEN NO_DATA_FOUND THEN NULL;
113: WHEN OTHERS THEN RAISE;

Line 129: arp_ctls_pkg.update_f_ctl_id(l_srep_rec,

125:
126: ELSIF ( p_customer_trx_line_id IS NOT NULL )
127: THEN
128: BEGIN
129: arp_ctls_pkg.update_f_ctl_id(l_srep_rec,
130: p_customer_trx_line_id);
131: EXCEPTION
132: WHEN NO_DATA_FOUND THEN NULL;
133: WHEN OTHERS THEN RAISE;

Line 149: arp_ctls_pkg.update_f_psr_id(l_srep_rec,

145:
146: ELSIF ( p_cust_trx_line_salesrep_id IS NOT NULL)
147: THEN
148: BEGIN
149: arp_ctls_pkg.update_f_psr_id(l_srep_rec,
150: p_cust_trx_line_salesrep_id);
151: EXCEPTION
152: WHEN NO_DATA_FOUND THEN NULL;
153: WHEN OTHERS THEN RAISE;

Line 178: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()-');

174: 'EXCEPTION: arp_process_salescredit.delete_salescredit()');
175: RAISE;
176: END;
177:
178: arp_util.debug('arp_ctls_pkg.erase_foreign_key_references()-');
179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: arp_util.debug(

Line 183: 'EXCEPTION: arp_ctls_pkg.erase_foreign_key_references()');

179:
180: EXCEPTION
181: WHEN OTHERS THEN
182: arp_util.debug(
183: 'EXCEPTION: arp_ctls_pkg.erase_foreign_key_references()');
184: RAISE;
185:
186: END;
187:

Line 225: arp_util.debug('arp_ctls_pkg.bind_srep_variables()+');

221: IS
222:
223: BEGIN
224:
225: arp_util.debug('arp_ctls_pkg.bind_srep_variables()+');
226:
227: /*------------------+
228: | Dummy constants |
229: +------------------*/

Line 369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');

365: dbms_sql.bind_variable(p_update_cursor, ':program_update_date',
366: p_srep_rec.program_update_date);
367:
368:
369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: arp_util.debug('EXCEPTION: arp_ctls_pkg.bind_srep_variables()');

Line 373: arp_util.debug('EXCEPTION: arp_ctls_pkg.bind_srep_variables()');

369: arp_util.debug('arp_ctls_pkg.bind_srep_variables()-');
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: arp_util.debug('EXCEPTION: arp_ctls_pkg.bind_srep_variables()');
374: RAISE;
375:
376: END;
377:

Line 412: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()+');

408:
409: PROCEDURE construct_srep_update_stmt( update_text OUT NOCOPY varchar2) IS
410:
411: BEGIN
412: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()+');
413:
414: update_text :=
415: 'UPDATE ra_cust_trx_line_salesreps
416: SET cust_trx_line_salesrep_id =

Line 560: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()-');

556: DECODE(:program_update_date,
557: :ar_date_dummy, program_update_date,
558: :program_update_date)';
559:
560: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()-');
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: arp_util.debug('EXCEPTION: arp_ctls_pkg.construct_srep_update_stmt()');

Line 564: arp_util.debug('EXCEPTION: arp_ctls_pkg.construct_srep_update_stmt()');

560: arp_util.debug('arp_ctls_pkg.construct_srep_update_stmt()-');
561:
562: EXCEPTION
563: WHEN OTHERS THEN
564: arp_util.debug('EXCEPTION: arp_ctls_pkg.construct_srep_update_stmt()');
565: RAISE;
566:
567: END;
568:

Line 615: arp_util.debug('arp_ctls_pkg.generic_update()+');

611: l_count number;
612: l_update_statement varchar2(25000);
613:
614: BEGIN
615: arp_util.debug('arp_ctls_pkg.generic_update()+');
616:
617: /*--------------------------------------------------------------+
618: | If this update statement has not already been parsed, |
619: | construct the statement and parse it. |

Line 633: arp_ctls_pkg.construct_srep_update_stmt(l_update_statement);

629: /*---------------------------------+
630: | Construct the update statement |
631: +---------------------------------*/
632:
633: arp_ctls_pkg.construct_srep_update_stmt(l_update_statement);
634:
635: l_update_statement := l_update_statement || p_where_clause;
636:
637: /*-----------------------------------------------+

Line 647: arp_ctls_pkg.bind_srep_variables(p_update_cursor, p_srep_rec);

643: dbms_sql.v7);
644:
645: END IF;
646:
647: arp_ctls_pkg.bind_srep_variables(p_update_cursor, p_srep_rec);
648:
649: /*-----------------------------------------+
650: | Bind the variables in the where clause |
651: +-----------------------------------------*/

Line 671: arp_util.debug('arp_ctls_pkg.generic_update()-');

667: END IF;
668:
669: dbms_sql.close_cursor(p_update_cursor);
670:
671: arp_util.debug('arp_ctls_pkg.generic_update()-');
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');

Line 675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');

671: arp_util.debug('arp_ctls_pkg.generic_update()-');
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: arp_util.debug('EXCEPTION: arp_ctls_pkg.generic_update()');
676: arp_util.debug(l_update_statement);
677: arp_util.debug('Error at character: ' ||
678: to_char(dbms_sql.last_error_position));
679: IF dbms_sql.is_open( p_update_cursor ) THEN

Line 733: arp_util.debug('arp_ctls_pkg.select_summary()+');

729:
730: BEGIN
731:
732: IF PG_DEBUG in ('Y', 'C') THEN
733: arp_util.debug('arp_ctls_pkg.select_summary()+');
734: END IF;
735:
736: SELECT NVL( SUM( NVL(revenue_amount_split, 0 ) ), 0),
737: NVL( SUM( NVL(revenue_amount_split, 0 ) ), 0),

Line 753: arp_util.debug('arp_ctls_pkg.select_summary()-');

749: 'ALL', customer_trx_line_id,
750: -10 );
751:
752: IF PG_DEBUG in ('Y', 'C') THEN
753: arp_util.debug('arp_ctls_pkg.select_summary()-');
754: END IF;
755:
756:
757: EXCEPTION

Line 760: arp_util.debug('EXCEPTION: arp_ctls_pkg.select_summary()');

756:
757: EXCEPTION
758: WHEN OTHERS THEN
759: IF PG_DEBUG in ('Y', 'C') THEN
760: arp_util.debug('EXCEPTION: arp_ctls_pkg.select_summary()');
761: END IF;
762: RAISE;
763:
764: END select_summary;

Line 804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');

800: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
801:
802: BEGIN
803:
804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');
805:
806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);
807:
808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);

Line 806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);

802: BEGIN
803:
804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');
805:
806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);
807:
808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);
809:
810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');

Line 808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);

804: arp_util.debug('arp_ctls_pkg.display_salescredit()+');
805:
806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);
807:
808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);
809:
810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');
811:
812: EXCEPTION

Line 810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');

806: arp_ctls_pkg.fetch_p(l_srep_rec, p_cust_trx_line_salesrep_id);
807:
808: arp_ctls_pkg.display_salescredit_rec(l_srep_rec);
809:
810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit()');

Line 814: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit()');

810: arp_util.debug('arp_ctls_pkg.display_salescredit()-');
811:
812: EXCEPTION
813: WHEN OTHERS THEN
814: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit()');
815: RAISE;
816:
817: END;
818:

Line 855: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()+');

851:
852:
853: BEGIN
854:
855: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()+');
856:
857: arp_util.debug('************** Dump of ra_cust_trx_line_salesreps record '||
858: '**************');
859:

Line 906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');

902:
903: arp_util.debug('************** End ra_cust_trx_line_salesreps record ' ||
904: '**************');
905:
906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');
907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_rec()');

Line 910: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_rec()');

906: arp_util.debug('arp_ctls_pkg.display_salescredit_rec()-');
907:
908: EXCEPTION
909: WHEN OTHERS THEN
910: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_rec()');
911: RAISE;
912:
913: END;
914:

Line 962: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()+');

958:
959:
960: BEGIN
961:
962: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()+');
963:
964: arp_util.debug('=====================================================' ||
965: '==========================');
966: arp_util.debug('========= ' ||

Line 982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');

978: '=========');
979: arp_util.debug('=====================================================' ||
980: '==========================');
981:
982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');
983:
984: EXCEPTION
985: WHEN OTHERS THEN
986: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_f_ctl_id()');

Line 986: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_f_ctl_id()');

982: arp_util.debug('arp_ctls_pkg.display_salescredit_f_ctl_id()-');
983:
984: EXCEPTION
985: WHEN OTHERS THEN
986: arp_util.debug('EXCEPTION: arp_ctls_pkg.display_salescredit_f_ctl_id()');
987: RAISE;
988:
989: END;
990:

Line 1032: arp_util.debug('arp_ctls_pkg.merge_srep_recs()+');

1028: IS
1029:
1030: BEGIN
1031:
1032: arp_util.debug('arp_ctls_pkg.merge_srep_recs()+');
1033:
1034:
1035: if (p_new_srep_rec.customer_trx_id = AR_NUMBER_DUMMY)
1036: then p_out_srep_rec.customer_trx_id := p_old_srep_rec.customer_trx_id;

Line 1183: arp_util.debug('arp_ctls_pkg.merge_srep_recs()-');

1179: end if;
1180:
1181: /* END bug 3067675 */
1182:
1183: arp_util.debug('arp_ctls_pkg.merge_srep_recs()-');
1184:
1185: EXCEPTION
1186: WHEN OTHERS THEN
1187: arp_util.debug('EXCEPTION: merge_srep_recs.backout_salesrep()');

Line 1228: arp_util.debug('arp_ctls_pkg.set_to_dummy()+');

1224: PROCEDURE set_to_dummy( p_srep_rec OUT NOCOPY ra_cust_trx_line_salesreps%rowtype) IS
1225:
1226: BEGIN
1227:
1228: arp_util.debug('arp_ctls_pkg.set_to_dummy()+');
1229:
1230: p_srep_rec.cust_trx_line_salesrep_id := AR_NUMBER_DUMMY;
1231: p_srep_rec.customer_trx_id := AR_NUMBER_DUMMY;
1232: p_srep_rec.customer_trx_line_id := AR_NUMBER_DUMMY;

Line 1268: arp_util.debug('arp_ctls_pkg.set_to_dummy()-');

1264: p_srep_rec.program_application_id := AR_NUMBER_DUMMY;
1265: p_srep_rec.program_id := AR_NUMBER_DUMMY;
1266: p_srep_rec.program_update_date := AR_DATE_DUMMY;
1267:
1268: arp_util.debug('arp_ctls_pkg.set_to_dummy()-');
1269:
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: arp_util.debug('EXCEPTION: arp_ctls_pkg.set_to_dummy()');

Line 1272: arp_util.debug('EXCEPTION: arp_ctls_pkg.set_to_dummy()');

1268: arp_util.debug('arp_ctls_pkg.set_to_dummy()-');
1269:
1270: EXCEPTION
1271: WHEN OTHERS THEN
1272: arp_util.debug('EXCEPTION: arp_ctls_pkg.set_to_dummy()');
1273: RAISE;
1274:
1275: END;
1276:

Line 1307: arp_util.debug('arp_ctls_pkg.get_number_dummy()+');

1303: FUNCTION get_number_dummy(p_null IN NUMBER DEFAULT null) RETURN number IS
1304:
1305: BEGIN
1306:
1307: arp_util.debug('arp_ctls_pkg.get_number_dummy()+');
1308:
1309: arp_util.debug('arp_ctls_pkg.get_number_dummy()-');
1310:
1311: return(AR_NUMBER_DUMMY);

Line 1309: arp_util.debug('arp_ctls_pkg.get_number_dummy()-');

1305: BEGIN
1306:
1307: arp_util.debug('arp_ctls_pkg.get_number_dummy()+');
1308:
1309: arp_util.debug('arp_ctls_pkg.get_number_dummy()-');
1310:
1311: return(AR_NUMBER_DUMMY);
1312:
1313: EXCEPTION

Line 1315: arp_util.debug('EXCEPTION: arp_ctls_pkg.get_number_dummy()');

1311: return(AR_NUMBER_DUMMY);
1312:
1313: EXCEPTION
1314: WHEN OTHERS THEN
1315: arp_util.debug('EXCEPTION: arp_ctls_pkg.get_number_dummy()');
1316: RAISE;
1317:
1318: END;
1319:

Line 1357: arp_util.debug('arp_ctls_pkg.lock_p()+');

1353: l_cust_trx_line_salesrep_id
1354: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type;
1355:
1356: BEGIN
1357: arp_util.debug('arp_ctls_pkg.lock_p()+');
1358:
1359:
1360: SELECT cust_trx_line_salesrep_id
1361: INTO l_cust_trx_line_salesrep_id

Line 1366: arp_util.debug('arp_ctls_pkg.lock_p()-');

1362: FROM ra_cust_trx_line_salesreps
1363: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1364: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1365:
1366: arp_util.debug('arp_ctls_pkg.lock_p()-');
1367:
1368: EXCEPTION
1369: WHEN OTHERS THEN
1370: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_p' );

Line 1370: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_p' );

1366: arp_util.debug('arp_ctls_pkg.lock_p()-');
1367:
1368: EXCEPTION
1369: WHEN OTHERS THEN
1370: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_p' );
1371: RAISE;
1372: END;
1373:
1374: /*===========================================================================+

Line 1413: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()+');

1409: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1410:
1411:
1412: BEGIN
1413: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()+');
1414:
1415: OPEN lock_c;
1416: CLOSE lock_c;
1417:

Line 1418: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()-');

1414:
1415: OPEN lock_c;
1416: CLOSE lock_c;
1417:
1418: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()-');
1419:
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ct_id' );

Line 1422: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ct_id' );

1418: arp_util.debug('arp_ctls_pkg.lock_f_ct_id()-');
1419:
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ct_id' );
1423: RAISE;
1424: END;
1425:
1426: /*===========================================================================+

Line 1464: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()+');

1460: WHERE customer_trx_line_id = p_customer_trx_line_id
1461: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1462:
1463: BEGIN
1464: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()+');
1465:
1466: OPEN lock_c;
1467: CLOSE lock_c;
1468:

Line 1469: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()-');

1465:
1466: OPEN lock_c;
1467: CLOSE lock_c;
1468:
1469: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()-');
1470:
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ctl_id' );

Line 1473: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ctl_id' );

1469: arp_util.debug('arp_ctls_pkg.lock_f_ctl_id()-');
1470:
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_f_ctl_id' );
1474: RAISE;
1475: END;
1476:
1477: /*===========================================================================+

Line 1510: arp_util.debug('arp_ctls_pkg.lock_fetch_p()+');

1506: p_cust_trx_line_salesrep_id IN
1507: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type) IS
1508:
1509: BEGIN
1510: arp_util.debug('arp_ctls_pkg.lock_fetch_p()+');
1511:
1512: SELECT *
1513: INTO p_srep_rec
1514: FROM ra_cust_trx_line_salesreps

Line 1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');

1514: FROM ra_cust_trx_line_salesreps
1515: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id
1516: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1517:
1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_fetch_p' );

Line 1522: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_fetch_p' );

1518: arp_util.debug('arp_ctls_pkg.lock_fetch_p()-');
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_fetch_p' );
1523: RAISE;
1524: END;
1525:
1526: /*===========================================================================+

Line 1567: arp_util.debug('arp_ctls_pkg.lock_compare_p()+');

1563: l_temp_srep_rec ra_cust_trx_line_salesreps%rowtype;
1564: l_ignore_who_flag varchar2(2);
1565:
1566: BEGIN
1567: arp_util.debug('arp_ctls_pkg.lock_compare_p()+');
1568:
1569: IF (p_ignore_who_flag = TRUE)
1570: THEN l_ignore_who_flag := 'Y';
1571: ELSE l_ignore_who_flag := 'N';

Line 1932: arp_util.debug('arp_ctls_pkg.lock_compare_p()-');

1928: )
1929: FOR UPDATE OF cust_trx_line_salesrep_id NOWAIT;
1930:
1931:
1932: arp_util.debug('arp_ctls_pkg.lock_compare_p()-');
1933:
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN
1936:

Line 1956: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_compare_p' );

1952: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1953: APP_EXCEPTION.Raise_Exception;
1954:
1955: WHEN OTHERS THEN
1956: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.lock_compare_p' );
1957: arp_util.debug( SQLERRM );
1958:
1959: arp_util.debug('----- parameters for lock_compare_p -----');
1960:

Line 2017: arp_util.debug('arp_ctls_pkg.fetch_p()+');

2013: ra_cust_trx_line_salesreps.cust_trx_line_salesrep_id%type)
2014: IS
2015:
2016: BEGIN
2017: arp_util.debug('arp_ctls_pkg.fetch_p()+');
2018:
2019: SELECT *
2020: INTO p_srep_rec
2021: FROM ra_cust_trx_line_salesreps

Line 2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');

2020: INTO p_srep_rec
2021: FROM ra_cust_trx_line_salesreps
2022: WHERE cust_trx_line_salesrep_id = p_cust_trx_line_salesrep_id;
2023:
2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');
2025:
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.fetch_p' );

Line 2028: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.fetch_p' );

2024: arp_util.debug('arp_ctls_pkg.fetch_p()-');
2025:
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: arp_util.debug( 'EXCEPTION: arp_ctls_pkg.fetch_p' );
2029: RAISE;
2030: END;
2031:
2032: /*===========================================================================+

Line 2071: arp_util.debug('arp_ctls_pkg.delete_p()+');

2067:
2068: BEGIN
2069:
2070:
2071: arp_util.debug('arp_ctls_pkg.delete_p()+');
2072:
2073: wf_event.raise(
2074: p_event_name => 'oracle.apps.ar.transaction.SalesCredit.delete',
2075: p_event_key => to_char(p_cust_trx_line_salesrep_id) || '_' ||

Line 2086: THEN arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');

2082:
2083: arp_util.debug( rows || ' records deleted');
2084:
2085: IF ( rows = 0 )
2086: THEN arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');
2087: RAISE NO_DATA_FOUND;
2088: END IF;
2089:
2090: /*---------------------------------------------------------------------+

Line 2102: arp_util.debug('arp_ctls_pkg.delete_p()-');

2098: NULL,
2099: NULL );
2100: END IF;
2101:
2102: arp_util.debug('arp_ctls_pkg.delete_p()-');
2103:
2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');

Line 2106: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');

2102: arp_util.debug('arp_ctls_pkg.delete_p()-');
2103:
2104: EXCEPTION
2105: WHEN OTHERS THEN
2106: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_p()');
2107:
2108: RAISE;
2109:
2110: END;

Line 2157: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()+');

2153:
2154: BEGIN
2155:
2156:
2157: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()+');
2158:
2159: IF ( p_delete_default_recs_flag = TRUE )
2160: THEN
2161: FOR l_srep_rec IN srep_trx_cursor LOOP

Line 2190: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()-');

2186: erase_foreign_key_references( NULL,
2187: p_customer_trx_id,
2188: NULL );
2189:
2190: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()-');
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ct_id()');

Line 2194: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ct_id()');

2190: arp_util.debug('arp_ctls_pkg.delete_f_ct_id()-');
2191:
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ct_id()');
2195:
2196: RAISE;
2197:
2198: END;

Line 2238: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()+');

2234:
2235: BEGIN
2236:
2237:
2238: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()+');
2239:
2240: FOR l_srep_rec IN srep_cursor LOOP
2241: wf_event.raise(
2242: p_event_name => 'transaction.SalesCredit.apps.ar.salescredits.delete',

Line 2254: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()-');

2250: erase_foreign_key_references( NULL,
2251: NULL,
2252: p_customer_trx_line_id );
2253:
2254: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()-');
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ctl_id()');

Line 2258: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ctl_id()');

2254: arp_util.debug('arp_ctls_pkg.delete_f_ctl_id()-');
2255:
2256: EXCEPTION
2257: WHEN OTHERS THEN
2258: arp_util.debug('EXCEPTION: arp_ctls_pkg.delete_f_ctl_id()');
2259:
2260: RAISE;
2261:
2262: END;

Line 2302: arp_util.debug('arp_ctls_pkg.update_p()+ ' ||

2298:
2299:
2300: BEGIN
2301:
2302: arp_util.debug('arp_ctls_pkg.update_p()+ ' ||
2303: to_char(sysdate, 'HH:MI:SS'));
2304:
2305: wf_event.raise(
2306: p_event_name => 'oracle.apps.ar.transaction.SalesCredit.update',

Line 2310: arp_ctls_pkg.generic_update( pg_cursor1,

2306: p_event_name => 'oracle.apps.ar.transaction.SalesCredit.update',
2307: p_event_key => to_char(p_cust_trx_line_salesrep_id) || '_' ||
2308: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2309:
2310: arp_ctls_pkg.generic_update( pg_cursor1,
2311: ' WHERE cust_trx_line_salesrep_id = :where_1',
2312: p_cust_trx_line_salesrep_id,
2313: p_srep_rec);
2314:

Line 2315: arp_util.debug('arp_ctls_pkg.update_p()- ' ||

2311: ' WHERE cust_trx_line_salesrep_id = :where_1',
2312: p_cust_trx_line_salesrep_id,
2313: p_srep_rec);
2314:
2315: arp_util.debug('arp_ctls_pkg.update_p()- ' ||
2316: to_char(sysdate, 'HH:MI:SS'));
2317:
2318:
2319: EXCEPTION

Line 2321: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_p()');

2317:
2318:
2319: EXCEPTION
2320: WHEN OTHERS THEN
2321: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_p()');
2322: RAISE;
2323: END;
2324:
2325:

Line 2366: arp_util.debug('arp_ctls_pkg.update_f_ct_id()+ ' ||

2362: where customer_trx_id = p_customer_trx_id;
2363:
2364: BEGIN
2365:
2366: arp_util.debug('arp_ctls_pkg.update_f_ct_id()+ ' ||
2367: to_char(sysdate, 'HH:MI:SS'));
2368:
2369: FOR l_srep_rec IN srep_trx_cursor LOOP
2370: wf_event.raise(

Line 2376: arp_ctls_pkg.generic_update( pg_cursor2,

2372: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2373: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2374: END LOOP;
2375:
2376: arp_ctls_pkg.generic_update( pg_cursor2,
2377: ' WHERE customer_trx_id = :where_1',
2378: p_customer_trx_id,
2379: p_srep_rec);
2380:

Line 2381: arp_util.debug('arp_ctls_pkg.update_f_ct_id()- ' ||

2377: ' WHERE customer_trx_id = :where_1',
2378: p_customer_trx_id,
2379: p_srep_rec);
2380:
2381: arp_util.debug('arp_ctls_pkg.update_f_ct_id()- ' ||
2382: to_char(sysdate, 'HH:MI:SS'));
2383:
2384:
2385: EXCEPTION

Line 2387: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ct_id()');

2383:
2384:
2385: EXCEPTION
2386: WHEN OTHERS THEN
2387: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ct_id()');
2388: RAISE;
2389: END;
2390:
2391:

Line 2433: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()+ ' ||

2429: where customer_trx_line_id = p_customer_trx_line_id;
2430:
2431: BEGIN
2432:
2433: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()+ ' ||
2434: to_char(sysdate, 'HH:MI:SS'));
2435:
2436: FOR l_srep_rec IN srep_cursor LOOP
2437: wf_event.raise(

Line 2443: arp_ctls_pkg.generic_update( pg_cursor3,

2439: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2440: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2441: END LOOP;
2442:
2443: arp_ctls_pkg.generic_update( pg_cursor3,
2444: ' WHERE customer_trx_line_id = :where_1',
2445: p_customer_trx_line_id,
2446: p_srep_rec);
2447:

Line 2448: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()- ' ||

2444: ' WHERE customer_trx_line_id = :where_1',
2445: p_customer_trx_line_id,
2446: p_srep_rec);
2447:
2448: arp_util.debug('arp_ctls_pkg.update_f_ctl_id()- ' ||
2449: to_char(sysdate, 'HH:MI:SS'));
2450:
2451:
2452: EXCEPTION

Line 2454: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ctl_id()');

2450:
2451:
2452: EXCEPTION
2453: WHEN OTHERS THEN
2454: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_ctl_id()');
2455: RAISE;
2456: END;
2457:
2458: /*===========================================================================+

Line 2500: arp_util.debug('arp_ctls_pkg.update_f_psr_id()+ ' ||

2496: where prev_cust_trx_line_salesrep_id = p_prev_cust_trx_line_srep_id;
2497:
2498: BEGIN
2499:
2500: arp_util.debug('arp_ctls_pkg.update_f_psr_id()+ ' ||
2501: to_char(sysdate, 'HH:MI:SS'));
2502:
2503: FOR l_srep_rec IN srep_cursor LOOP
2504: wf_event.raise(

Line 2510: arp_ctls_pkg.generic_update(

2506: p_event_key => to_char(l_srep_rec.cust_trx_line_salesrep_id) || '_' ||
2507: to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
2508: END LOOP;
2509:
2510: arp_ctls_pkg.generic_update(
2511: pg_cursor3,
2512: ' WHERE prev_cust_trx_line_salesrep_id = :where_1',
2513: p_prev_cust_trx_line_srep_id,
2514: p_srep_rec);

Line 2516: arp_util.debug('arp_ctls_pkg.update_f_psr_id()- ' ||

2512: ' WHERE prev_cust_trx_line_salesrep_id = :where_1',
2513: p_prev_cust_trx_line_srep_id,
2514: p_srep_rec);
2515:
2516: arp_util.debug('arp_ctls_pkg.update_f_psr_id()- ' ||
2517: to_char(sysdate, 'HH:MI:SS'));
2518:
2519:
2520: EXCEPTION

Line 2522: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_psr_id()');

2518:
2519:
2520: EXCEPTION
2521: WHEN OTHERS THEN
2522: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_f_psr_id()');
2523: RAISE;
2524: END;
2525:
2526: /*===========================================================================+

Line 2571: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()+ ' ||

2567: where customer_trx_line_id = p_customer_trx_line_id;
2568:
2569: BEGIN
2570:
2571: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()+ ' ||
2572: to_char(sysdate, 'HH:MI:SS'));
2573:
2574: arp_util.debug('p_line_amount = ' || p_line_amount );
2575: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id );

Line 2603: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()- ' ||

2599: where customer_trx_line_id = p_customer_trx_line_id;
2600:
2601: arp_util.debug(SQL%ROWCOUNT || ' rows updated');
2602:
2603: arp_util.debug('arp_ctls_pkg.update_amounts_f_ctl_id()- ' ||
2604: to_char(sysdate, 'HH:MI:SS'));
2605:
2606:
2607: EXCEPTION

Line 2609: arp_util.debug('EXCEPTION: arp_ctls_pkg.update_amounts_f_ctl_id()');

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

Line 2655: arp_util.debug('arp_ctls_pkg.insert_p()+');

2651:
2652:
2653: BEGIN
2654:
2655: arp_util.debug('arp_ctls_pkg.insert_p()+');
2656:
2657: p_cust_trx_line_salesrep_id := '';
2658:
2659: /*---------------------------*

Line 2760: arp_util.debug('arp_ctls_pkg.insert_p()-');

2756:
2757:
2758: p_cust_trx_line_salesrep_id := l_cust_trx_line_salesrep_id;
2759:
2760: arp_util.debug('arp_ctls_pkg.insert_p()-');
2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_p()');

Line 2764: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_p()');

2760: arp_util.debug('arp_ctls_pkg.insert_p()-');
2761:
2762: EXCEPTION
2763: WHEN OTHERS THEN
2764: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_p()');
2765: RAISE;
2766: END;
2767:
2768: /*===========================================================================+

Line 2808: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()+');

2804:
2805:
2806: BEGIN
2807:
2808: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()+');
2809:
2810: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
2811: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
2812:

Line 3011: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()-');

3007: );
3008:
3009: END IF;
3010:
3011: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()-');
3012:
3013: EXCEPTION
3014: WHEN OTHERS THEN
3015: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_ct_ctl_id()');

Line 3015: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_ct_ctl_id()');

3011: arp_util.debug('arp_ctls_pkg.insert_f_ct_ctl_id()-');
3012:
3013: EXCEPTION
3014: WHEN OTHERS THEN
3015: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_ct_ctl_id()');
3016: RAISE;
3017: END;
3018:
3019: /*===========================================================================+

Line 3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');

3055: p_currency_code IN fnd_currencies.currency_code%type
3056: ) IS
3057: BEGIN
3058:
3059: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()+');
3060:
3061: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3062: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3063: arp_util.debug('p_currency_code = ' || p_currency_code);

Line 3129: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id() : '||

3125: AND ctl.line_type = 'LINE'
3126: AND ctl.customer_trx_line_id = nvl(p_customer_trx_line_id,
3127: ctl.customer_trx_line_id);
3128:
3129: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id() : '||
3130: SQL%ROWCOUNT||' rows inserted');
3131:
3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');
3133:

Line 3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');

3128:
3129: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id() : '||
3130: SQL%ROWCOUNT||' rows inserted');
3131:
3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');
3133:
3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');

Line 3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');

3132: arp_util.debug('arp_ctls_pkg.insert_f_cm_ct_ctl_id()-');
3133:
3134: EXCEPTION
3135: WHEN OTHERS THEN
3136: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cm_ct_ctl_id()');
3137: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3138: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3139: arp_util.debug('p_currency_code = ' || p_currency_code);
3140:

Line 3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');

3176: ra_customer_trx_lines.customer_trx_line_id%type
3177: ) IS
3178: BEGIN
3179:
3180: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()+');
3181:
3182: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3183: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3184:

Line 3266: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id() : '||

3262: AND ctl.line_type = 'LINE'
3263: AND ctl.customer_trx_line_id = nvl(p_customer_trx_line_id,
3264: ctl.customer_trx_line_id);
3265:
3266: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id() : '||
3267: SQL%ROWCOUNT||' rows inserted');
3268:
3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');
3270:

Line 3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');

3265:
3266: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id() : '||
3267: SQL%ROWCOUNT||' rows inserted');
3268:
3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');
3270:
3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');

Line 3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');

3269: arp_util.debug('arp_ctls_pkg.insert_f_cmn_ct_ctl_id()-');
3270:
3271: EXCEPTION
3272: WHEN OTHERS THEN
3273: arp_util.debug('EXCEPTION: arp_ctls_pkg.insert_f_cmn_ct_ctl_id()');
3274: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
3275: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
3276:
3277:

Line 3398: arp_util.debug('arp_ctls_pkg.lock_compare_cover()+');

3394: l_srep_rec ra_cust_trx_line_salesreps%rowtype;
3395:
3396: BEGIN
3397:
3398: arp_util.debug('arp_ctls_pkg.lock_compare_cover()+');
3399:
3400: /*------------------------------------------------+
3401: | Populate the salescredit record group with |
3402: | the values passed in as parameters. |

Line 3405: arp_ctls_pkg.set_to_dummy(l_srep_rec);

3401: | Populate the salescredit record group with |
3402: | the values passed in as parameters. |
3403: +------------------------------------------------*/
3404:
3405: arp_ctls_pkg.set_to_dummy(l_srep_rec);
3406:
3407: l_srep_rec.cust_trx_line_salesrep_id := p_cust_trx_line_salesrep_id;
3408: l_srep_rec.customer_trx_id := p_customer_trx_id;
3409: l_srep_rec.customer_trx_line_id := p_customer_trx_line_id;

Line 3449: arp_util.debug('arp_ctls_pkg.lock_compare_cover()-');

3445: p_cust_trx_line_salesrep_id,
3446: TRUE -- ignore who columns
3447: );
3448:
3449: arp_util.debug('arp_ctls_pkg.lock_compare_cover()-');
3450:
3451: EXCEPTION
3452: WHEN OTHERS THEN
3453:

Line 3455: 'EXCEPTION: arp_ctls_pkg.lock_compare_cover()');

3451: EXCEPTION
3452: WHEN OTHERS THEN
3453:
3454: arp_util.debug(
3455: 'EXCEPTION: arp_ctls_pkg.lock_compare_cover()');
3456:
3457: arp_util.debug('------- parameters for lock_compare_cover() ' ||
3458: '---------');
3459: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id );

Line 3507: arp_standard.debug('arp_ctls_pkg.init()+');

3503: +---------------------------------------------*/
3504: PROCEDURE init IS
3505: BEGIN
3506:
3507: arp_standard.debug('arp_ctls_pkg.init()+');
3508:
3509: pg_user_id := fnd_global.user_id;
3510: pg_conc_login_id := fnd_global.conc_login_id;
3511: pg_login_id := fnd_global.login_id;

Line 3518: arp_standard.debug('arp_ctls_pkg.init()-');

3514:
3515: pg_salesrep_required_flag :=
3516: arp_trx_global.system_info.system_parameters.salesrep_required_flag;
3517:
3518: arp_standard.debug('arp_ctls_pkg.init()-');
3519: END init;
3520:
3521: BEGIN
3522: init;

Line 3523: END ARP_CTLS_PKG;

3519: END init;
3520:
3521: BEGIN
3522: init;
3523: END ARP_CTLS_PKG;