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_CR_ICR_LINES_PKG dependencies on ARP_CR_ICR_LINES_PKG

Line 1: PACKAGE BODY ARP_CR_ICR_LINES_PKG AS

1: PACKAGE BODY ARP_CR_ICR_LINES_PKG AS
2: /* $Header: ARRIICLB.pls 120.9 2006/05/24 12:55:42 shveeram ship $*/
3:
4: --
5: --

Line 69: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()+' );

65: ar_interim_cash_receipt_lines%ROWTYPE ) IS
66: l_cr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;
67: l_row_id VARCHAR2( 20 );
68: BEGIN
69: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()+' );
70: --
71: arp_cr_icr_lines_pkg.insert_p( p_icr_lines_rec,
72: p_icr_lines_rec.cash_receipt_id,
73: l_cr_line_id );

Line 71: arp_cr_icr_lines_pkg.insert_p( p_icr_lines_rec,

67: l_row_id VARCHAR2( 20 );
68: BEGIN
69: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()+' );
70: --
71: arp_cr_icr_lines_pkg.insert_p( p_icr_lines_rec,
72: p_icr_lines_rec.cash_receipt_id,
73: l_cr_line_id );
74: --
75: SELECT ROWID

Line 84: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()-' );

80: --
81: p_cr_line_id := l_cr_line_id;
82: p_row_id := l_row_id;
83: --
84: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()-' );
85: --
86: EXCEPTION
87: WHEN OTHERS THEN
88: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.insert_p' );

Line 88: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.insert_p' );

84: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()-' );
85: --
86: EXCEPTION
87: WHEN OTHERS THEN
88: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.insert_p' );
89: RAISE;
90: END;
91:
92: /*===========================================================================+

Line 133: arp_standard.debug( ' arp_cr_icr_lines_pkg.insert_p()+' );

129: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS
130: l_cr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;
131: l_org_id ar_interim_cash_receipt_lines.org_id%TYPE;
132: BEGIN
133: arp_standard.debug( ' arp_cr_icr_lines_pkg.insert_p()+' );
134: /* Adding the following line to populate the org_id as per the bug:5244971*/
135: l_org_id := arp_standard.sysparm.org_id;
136: --
137: /* Changing the following query to remove the org id as per the bug:5244971*/

Line 277: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()-' );

273: l_org_id
274: );
275: p_icr_line_id := l_cr_line_id;
276: --
277: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()-' );
278: EXCEPTION
279: WHEN OTHERS THEN
280: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.insert_p' );
281: RAISE;

Line 280: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.insert_p' );

276: --
277: arp_standard.debug( 'arp_cr_icr_lines_pkg.insert_p()-' );
278: EXCEPTION
279: WHEN OTHERS THEN
280: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.insert_p' );
281: RAISE;
282: END;
283: --
284: /*===========================================================================+

Line 315: arp_standard.debug('arp_cr_icr_lines_pkg.const_icr_lines_update_stmt()+');

311:
312: PROCEDURE const_icr_lines_update_stmt( update_text OUT NOCOPY varchar2) IS
313: --
314: BEGIN
315: arp_standard.debug('arp_cr_icr_lines_pkg.const_icr_lines_update_stmt()+');
316: --
317: update_text :=
318: 'update ar_interim_cash_receipt_lines
319: SET payment_amount =

Line 558: arp_standard.debug('arp_cr_icr_lines_pkg.const_icr_lines_update_stmt()-');

554: decode(:applied_rec_app_id,
555: :ar_number_dummy, applied_rec_app_id,
556: :applied_rec_app_id)';
557: --
558: arp_standard.debug('arp_cr_icr_lines_pkg.const_icr_lines_update_stmt()-');
559: --
560: EXCEPTION
561: WHEN OTHERS THEN
562: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg .const_icr_lines_update_stmt()');

Line 562: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg .const_icr_lines_update_stmt()');

558: arp_standard.debug('arp_cr_icr_lines_pkg.const_icr_lines_update_stmt()-');
559: --
560: EXCEPTION
561: WHEN OTHERS THEN
562: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg .const_icr_lines_update_stmt()');
563: RAISE;
564: --
565: END;
566: --

Line 603: arp_standard.debug('arp_cr_icr_lines_pkg.bind_icr_lines_variables()+');

599: p_icr_lines_rec IN ar_interim_cash_receipt_lines%rowtype ) IS
600: --
601: BEGIN
602: --
603: arp_standard.debug('arp_cr_icr_lines_pkg.bind_icr_lines_variables()+');
604: --
605: --
606: /*------------------+
607: | Dummy constants |

Line 815: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.bind_icr_lines_variables()');

811: p_icr_lines_rec.applied_rec_app_id);
812: --
813: EXCEPTION
814: WHEN OTHERS THEN
815: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.bind_icr_lines_variables()');
816: arp_standard.debug('Error at character: ' ||
817: to_char(dbms_sql.last_error_position));
818:
819: RAISE;

Line 840: arp_standard.debug('arp_cr_icr_lines_pkg.generic_update()+');

836: l_count number;
837: l_update_statement varchar2(20000);
838: --
839: BEGIN
840: arp_standard.debug('arp_cr_icr_lines_pkg.generic_update()+');
841: --
842: /*--------------------------------------------------------------+
843: | If this update statement has not already been parsed, |
844: | construct the statement and parse it. |

Line 858: arp_cr_icr_lines_pkg.const_icr_lines_update_stmt(l_update_statement);

854: /*---------------------------------+
855: | Construct the update statement |
856: +---------------------------------*/
857: --
858: arp_cr_icr_lines_pkg.const_icr_lines_update_stmt(l_update_statement);
859: --
860: l_update_statement := l_update_statement || p_where_clause;
861: --
862: arp_standard.debug('after l_update_statement');

Line 875: arp_cr_icr_lines_pkg.bind_icr_lines_variables(p_update_cursor, p_icr_lines_rec);

871: arp_standard.debug('after dbms_sql');
872:
873: end if;
874: --
875: arp_cr_icr_lines_pkg.bind_icr_lines_variables(p_update_cursor, p_icr_lines_rec);
876: --
877: --
878: arp_standard.debug('after .bind_app');
879: /*-----------------------------------------+

Line 920: arp_standard.debug('arp_cr_icr_lines_pkg.generic_update()-');

916: arp_standard.debug('after l_count = 0');
917: end if;
918: --
919: --
920: arp_standard.debug('arp_cr_icr_lines_pkg.generic_update()-');
921: --
922: EXCEPTION
923: WHEN OTHERS THEN
924: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.generic_update()

Line 924: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.generic_update()

920: arp_standard.debug('arp_cr_icr_lines_pkg.generic_update()-');
921: --
922: EXCEPTION
923: WHEN OTHERS THEN
924: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.generic_update()
925: ');
926: arp_standard.debug(l_update_statement);
927: arp_standard.debug('Error at character: ' ||
928: to_char(dbms_sql.last_error_position));

Line 941: arp_standard.debug('arp_cr_icr_lines_pkg.set_to_dummy()+');

937: ar_interim_cash_receipt_lines%rowtype) IS
938: --
939: BEGIN
940: --
941: arp_standard.debug('arp_cr_icr_lines_pkg.set_to_dummy()+');
942: --
943: p_icr_lines_rec.cash_receipt_line_id := AR_NUMBER_DUMMY;
944: p_icr_lines_rec.cash_receipt_id := AR_NUMBER_DUMMY;
945: p_icr_lines_rec.payment_amount := AR_NUMBER_DUMMY;

Line 998: arp_standard.debug('arp_cr_icr_lines_pkg.set_to_dummy()-');

994: p_icr_lines_rec.customer_reason := AR_TEXT_DUMMY;
995: p_icr_lines_rec.applied_rec_app_id := AR_NUMBER_DUMMY;
996:
997: --
998: arp_standard.debug('arp_cr_icr_lines_pkg.set_to_dummy()-');
999: --
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.set_to_dummy()');

Line 1002: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.set_to_dummy()');

998: arp_standard.debug('arp_cr_icr_lines_pkg.set_to_dummy()-');
999: --
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.set_to_dummy()');
1003: RAISE;
1004: --
1005: END;
1006: --

Line 1022: arp_standard.debug('arp_cr_icr_lines_pkg.update_p()+ ');

1018: ar_interim_cash_receipt_lines.cash_receipt_id%TYPE) IS
1019: --
1020: BEGIN
1021: --
1022: arp_standard.debug('arp_cr_icr_lines_pkg.update_p()+ ');
1023: --
1024: --
1025: -- Bug 744228: added 2nd where clause and additional parameter of p_batch_id
1026: -- 746872: added 3nd where clause and additional parameter of cash_receipt

Line 1028: arp_cr_icr_lines_pkg.generic_update( pg_cursor1,

1024: --
1025: -- Bug 744228: added 2nd where clause and additional parameter of p_batch_id
1026: -- 746872: added 3nd where clause and additional parameter of cash_receipt
1027: -- id.
1028: arp_cr_icr_lines_pkg.generic_update( pg_cursor1,
1029: ' WHERE cash_receipt_line_id = :where_1 and
1030: batch_id = :where_2 and
1031: cash_receipt_id = :where_3',
1032: p_cash_receipt_line_id,

Line 1037: arp_standard.debug('arp_cr_icr_lines_pkg.update_p()- ' ||

1033: p_batch_id,
1034: p_cash_receipt_id,
1035: p_icr_lines_rec);
1036: --
1037: arp_standard.debug('arp_cr_icr_lines_pkg.update_p()- ' ||
1038: to_char(sysdate, 'HH:MI:SS'));
1039: --
1040: --
1041: EXCEPTION

Line 1043: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.update_p()');

1039: --
1040: --
1041: EXCEPTION
1042: WHEN OTHERS THEN
1043: arp_standard.debug('EXCEPTION: arp_cr_icr_lines_pkg.update_p()');
1044: RAISE;
1045: END;
1046: --
1047: /*===========================================================================+

Line 1073: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_p()+' );

1069: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE,
1070: p_icr_line_id IN
1071: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS
1072: BEGIN
1073: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_p()+' );
1074: --
1075: DELETE FROM ar_interim_cash_receipt_lines
1076: WHERE cash_receipt_id = p_icr_id
1077: AND cash_receipt_line_id = p_icr_line_id;

Line 1079: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_p()-' );

1075: DELETE FROM ar_interim_cash_receipt_lines
1076: WHERE cash_receipt_id = p_icr_id
1077: AND cash_receipt_line_id = p_icr_line_id;
1078: --
1079: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_p()-' );
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.delete_p' );
1083: RAISE;

Line 1082: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.delete_p' );

1078: --
1079: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_p()-' );
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.delete_p' );
1083: RAISE;
1084: END;
1085: --
1086: /*===========================================================================+

Line 1115: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_fk()+' );

1111: PROCEDURE delete_fk(
1112: p_icr_id IN ar_interim_cash_receipts.cash_receipt_id%TYPE ) IS
1113: BEGIN
1114: IF PG_DEBUG in ('Y', 'C') THEN
1115: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_fk()+' );
1116: END IF;
1117: --
1118: DELETE FROM ar_interim_cash_receipt_lines
1119: WHERE cash_receipt_id = p_icr_id;

Line 1122: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_fk()-' );

1118: DELETE FROM ar_interim_cash_receipt_lines
1119: WHERE cash_receipt_id = p_icr_id;
1120: --
1121: IF PG_DEBUG in ('Y', 'C') THEN
1122: arp_standard.debug( 'arp_cr_icr_lines_pkg.delete_fk()-' );
1123: END IF;
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: IF PG_DEBUG in ('Y', 'C') THEN

Line 1127: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.delete_fk' );

1123: END IF;
1124: EXCEPTION
1125: WHEN OTHERS THEN
1126: IF PG_DEBUG in ('Y', 'C') THEN
1127: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.delete_fk' );
1128: END IF;
1129: RAISE;
1130: END delete_fk;
1131: --

Line 1161: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_p()+' );

1157: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS
1158: --
1159: l_cr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;
1160: BEGIN
1161: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_p()+' );
1162: --
1163: SELECT cash_receipt_line_id
1164: INTO l_cr_line_id
1165: FROM ar_interim_cash_receipt_lines

Line 1169: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_p()-' );

1165: FROM ar_interim_cash_receipt_lines
1166: WHERE cash_receipt_line_id = p_icr_line_id
1167: FOR UPDATE OF PAYMENT_AMOUNT;
1168: --
1169: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_p()-' );
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.lock_p' );
1173: RAISE;

Line 1172: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.lock_p' );

1168: --
1169: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_p()-' );
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.lock_p' );
1173: RAISE;
1174: END;
1175: --
1176: PROCEDURE nowaitlock_p(

Line 1181: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_p()+' );

1177: p_icr_line_id IN
1178: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE ) IS
1179: l_cr_line_id ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE;
1180: BEGIN
1181: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_p()+' );
1182: --
1183: SELECT cash_receipt_line_id
1184: INTO l_cr_line_id
1185: FROM ar_interim_cash_receipt_lines

Line 1189: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_p()-' );

1185: FROM ar_interim_cash_receipt_lines
1186: WHERE cash_receipt_line_id = p_icr_line_id
1187: FOR UPDATE OF PAYMENT_AMOUNT NOWAIT;
1188: --
1189: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_p()-' );
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.nowaitlock_p' );
1193: RAISE;

Line 1192: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.nowaitlock_p' );

1188: --
1189: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_p()-' );
1190: EXCEPTION
1191: WHEN OTHERS THEN
1192: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.nowaitlock_p' );
1193: RAISE;
1194: END;
1195: --
1196: /*===========================================================================+

Line 1225: arp_standard.debug( 'arp_cr_icr_lines_pkg.fetch_p()+' );

1221: ar_interim_cash_receipt_lines.cash_receipt_line_id%TYPE,
1222: p_icr_lines_rec OUT NOCOPY
1223: ar_interim_cash_receipt_lines%ROWTYPE ) IS
1224: BEGIN
1225: arp_standard.debug( 'arp_cr_icr_lines_pkg.fetch_p()+' );
1226: --
1227: SELECT *
1228: INTO p_icr_lines_rec
1229: FROM ar_interim_cash_receipt_lines

Line 1232: arp_standard.debug( 'arp_cr_icr_lines_pkg.fetch_p()-' );

1228: INTO p_icr_lines_rec
1229: FROM ar_interim_cash_receipt_lines
1230: WHERE cash_receipt_line_id = p_icr_line_id;
1231: --
1232: arp_standard.debug( 'arp_cr_icr_lines_pkg.fetch_p()-' );
1233: EXCEPTION
1234: --
1235: WHEN OTHERS THEN
1236: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.fetch_p' );

Line 1236: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.fetch_p' );

1232: arp_standard.debug( 'arp_cr_icr_lines_pkg.fetch_p()-' );
1233: EXCEPTION
1234: --
1235: WHEN OTHERS THEN
1236: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.fetch_p' );
1237: RAISE;
1238: END;
1239: --
1240: PROCEDURE lock_fetch_p( p_icr_lines_rec IN OUT NOCOPY

Line 1244: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_fetch_p()+' );

1240: PROCEDURE lock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
1241: ar_interim_cash_receipt_lines%ROWTYPE ) IS
1242: BEGIN
1243: IF PG_DEBUG in ('Y', 'C') THEN
1244: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_fetch_p()+' );
1245: END IF;
1246: --
1247: SELECT *
1248: INTO p_icr_lines_rec

Line 1254: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_fetch_p()-' );

1250: WHERE cash_receipt_line_id = p_icr_lines_rec.cash_receipt_line_id
1251: FOR UPDATE OF PAYMENT_AMOUNT;
1252: --
1253: IF PG_DEBUG in ('Y', 'C') THEN
1254: arp_standard.debug( 'arp_cr_icr_lines_pkg.lock_fetch_p()-' );
1255: END IF;
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: IF PG_DEBUG in ('Y', 'C') THEN

Line 1259: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.lock_fetch_p' );

1255: END IF;
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: IF PG_DEBUG in ('Y', 'C') THEN
1259: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.lock_fetch_p' );
1260: END IF;
1261: RAISE;
1262: END lock_fetch_p;
1263: --

Line 1269: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_fetch_p()+' );

1265: PROCEDURE nowaitlock_fetch_p( p_icr_lines_rec IN OUT NOCOPY
1266: ar_interim_cash_receipt_lines%ROWTYPE ) IS
1267: BEGIN
1268: IF PG_DEBUG in ('Y', 'C') THEN
1269: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_fetch_p()+' );
1270: END IF;
1271: --
1272: SELECT *
1273: INTO p_icr_lines_rec

Line 1279: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_fetch_p()-' );

1275: WHERE cash_receipt_line_id = p_icr_lines_rec.cash_receipt_line_id
1276: FOR UPDATE OF PAYMENT_AMOUNT NOWAIT;
1277: --
1278: IF PG_DEBUG in ('Y', 'C') THEN
1279: arp_standard.debug( 'arp_cr_icr_lines_pkg.nowaitlock_fetch_p()-' );
1280: END IF;
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: IF PG_DEBUG in ('Y', 'C') THEN

Line 1284: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.nowaitlock_fetch_p' );

1280: END IF;
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: IF PG_DEBUG in ('Y', 'C') THEN
1284: arp_standard.debug( 'EXCEPTION: arp_cr_icr_lines_pkg.nowaitlock_fetch_p' );
1285: END IF;
1286: RAISE;
1287: END nowaitlock_fetch_p;
1288: --

Line 1312: END ARP_CR_ICR_LINES_PKG;

1308: pg_last_update_login := arp_global.last_update_login;
1309: pg_set_of_books_id := arp_global.set_of_books_id;
1310: --
1311: --
1312: END ARP_CR_ICR_LINES_PKG;
1313: --