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

APPS.ARP_ADJUSTMENTS_PKG dependencies on ARP_ADJUSTMENTS_PKG

Line 1: PACKAGE BODY ARP_ADJUSTMENTS_PKG AS

1: PACKAGE BODY ARP_ADJUSTMENTS_PKG AS
2: /* $Header: ARTIADJB.pls 120.11 2008/11/03 03:58:04 naneja ship $ */
3:
4: pg_base_curr_code gl_sets_of_books.currency_code%type;
5: pg_base_precision fnd_currencies.precision%type;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 770: arp_adjustments_pkg.display_adj_rec(p_adj_rec);

766: arp_util.debug('p_where_clause = ' || p_where_clause);
767: arp_util.debug('p_where1 = ' || p_where1);
768: arp_util.debug('p_exchange_rate = ' || p_exchange_rate);
769:
770: arp_adjustments_pkg.display_adj_rec(p_adj_rec);
771:
772: /*--------------------------------------------------------------+
773: | If this update statement has not already been parsed, |
774: | construct the statement and parse it. |

Line 788: arp_adjustments_pkg.construct_adj_update_stmt(l_update_statement);

784: /*---------------------------------+
785: | Construct the update statement |
786: +---------------------------------*/
787:
788: arp_adjustments_pkg.construct_adj_update_stmt(l_update_statement);
789:
790: l_update_statement := l_update_statement || p_where_clause;
791:
792: /* add on mrc variables for bulk collect */

Line 806: arp_adjustments_pkg.bind_adj_variables(p_update_cursor,

802: dbms_sql.v7);
803:
804: END IF;
805:
806: arp_adjustments_pkg.bind_adj_variables(p_update_cursor,
807: p_adj_rec,
808: p_exchange_rate,
809: pg_base_curr_code,
810: pg_base_precision,

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

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

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

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

Line 870: arp_adjustments_pkg.display_adj_rec(p_adj_rec);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1847: 'EXCEPTION: arp_adjustments_pkg.l.lock_compare_p NO_DATA_FOUND' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2658: arp_adjustments_pkg.generic_update( pg_cursor1,

2654:
2655: arp_util.debug('arp_adjustments_pkg.update_p()+ ' ||
2656: to_char(sysdate, 'HH:MI:SS'));
2657:
2658: arp_adjustments_pkg.generic_update( pg_cursor1,
2659: ' WHERE adjustment_id = :where_1',
2660: p_adjustment_id,
2661: p_exchange_rate,
2662: p_adj_rec);

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

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

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

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

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

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

Line 2717: arp_adjustments_pkg.generic_update( pg_cursor2,

2713:
2714: arp_util.debug('arp_adjustments_pkg.update_f_ct_id()+ ' ||
2715: to_char(sysdate, 'HH:MI:SS'));
2716:
2717: arp_adjustments_pkg.generic_update( pg_cursor2,
2718: ' WHERE customer_trx_id = :where_1',
2719: p_customer_trx_id,
2720: p_exchange_rate,
2721: p_adj_rec);

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

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

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

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

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

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

Line 2774: arp_adjustments_pkg.generic_update( pg_cursor3,

2770:
2771: arp_util.debug('arp_adjustments_pkg.update_f_st_id()+ ' ||
2772: to_char(sysdate, 'HH:MI:SS'));
2773:
2774: arp_adjustments_pkg.generic_update( pg_cursor3,
2775: ' WHERE subsequent_trx_id = :where_1',
2776: p_subsequent_trx_id,
2777: p_exchange_rate,
2778: p_adj_rec);

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

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

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

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

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

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

Line 2835: arp_adjustments_pkg.generic_update( pg_cursor4,

2831:
2832: arp_util.debug('arp_adjustments_pkg.update_f_ps_id()+ ' ||
2833: to_char(sysdate, 'HH:MI:SS'));
2834:
2835: arp_adjustments_pkg.generic_update( pg_cursor4,
2836: ' WHERE payment_schedule_id = :where_1',
2837: p_payment_schedule_id,
2838: p_exchange_rate,
2839: p_adj_rec);

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

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

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

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

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

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

Line 2896: arp_adjustments_pkg.generic_update( pg_cursor5,

2892:
2893: arp_util.debug('arp_adjustments_pkg.update_f_ctl_id()+ ' ||
2894: to_char(sysdate, 'HH:MI:SS'));
2895:
2896: arp_adjustments_pkg.generic_update( pg_cursor5,
2897: ' WHERE customer_trx_line_id = :where_1',
2898: p_customer_trx_line_id,
2899: p_exchange_rate,
2900: p_adj_rec);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3584: arp_adjustments_pkg.display_adj_rec( p_old_adj_rec );

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

Line 3587: arp_adjustments_pkg.display_adj_rec( p_new_adj_rec );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3877: END ARP_ADJUSTMENTS_PKG;

3873: pg_base_min_acc_unit := arp_global.base_min_acc_unit;
3874:
3875: pg_msg_level_debug := arp_global.MSG_LEVEL_DEBUG;
3876:
3877: END ARP_ADJUSTMENTS_PKG;