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_CMA_PKG dependencies on ARP_CMA_PKG

Line 1: PACKAGE BODY ARP_CMA_PKG AS

1: PACKAGE BODY ARP_CMA_PKG AS
2: /* $Header: ARTICMAB.pls 115.6 2003/04/11 21:12:44 mraymond ship $ */
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

Line 72: arp_util.debug('arp_cma_pkg.compare_cma_records()+');

68: l_result boolean;
69: l_sql_result varchar2(2);
70:
71: BEGIN
72: arp_util.debug('arp_cma_pkg.compare_cma_records()+');
73:
74:
75: select DECODE(max(dummy),
76: '', 'N',

Line 141: 'arp_cma_pkg.compare_cma_records(): result: FALSE');

137:
138: if (l_sql_result = 'N')
139: then l_result := FALSE;
140: arp_util.debug(
141: 'arp_cma_pkg.compare_cma_records(): result: FALSE');
142: else l_result := TRUE;
143: arp_util.debug(
144: 'arp_cma_pkg.compare_cma_records(): result: TRUE');
145: END IF;

Line 144: 'arp_cma_pkg.compare_cma_records(): result: TRUE');

140: arp_util.debug(
141: 'arp_cma_pkg.compare_cma_records(): result: FALSE');
142: else l_result := TRUE;
143: arp_util.debug(
144: 'arp_cma_pkg.compare_cma_records(): result: TRUE');
145: END IF;
146:
147: arp_util.debug('arp_cma_pkg.compare_cma_records()-');
148:

Line 147: arp_util.debug('arp_cma_pkg.compare_cma_records()-');

143: arp_util.debug(
144: 'arp_cma_pkg.compare_cma_records(): result: TRUE');
145: END IF;
146:
147: arp_util.debug('arp_cma_pkg.compare_cma_records()-');
148:
149: return(l_result);
150:
151: EXCEPTION

Line 153: arp_util.debug( 'EXCEPTION: arp_cma_pkg.compare_cma_records' );

149: return(l_result);
150:
151: EXCEPTION
152: WHEN OTHERS THEN
153: arp_util.debug( 'EXCEPTION: arp_cma_pkg.compare_cma_records' );
154: RAISE;
155: END;
156:
157: /*===========================================================================+

Line 193: arp_util.debug('arp_cma_pkg.bind_cma_variables()+');

189: IS
190:
191: BEGIN
192:
193: arp_util.debug('arp_cma_pkg.bind_cma_variables()+');
194:
195: /*------------------+
196: | Dummy constants |
197: +------------------*/

Line 267: arp_util.debug('arp_cma_pkg.bind_cma_variables()-');

263: dbms_sql.bind_variable(p_update_cursor, ':request_id',
264: p_cma_rec.request_id);
265:
266:
267: arp_util.debug('arp_cma_pkg.bind_cma_variables()-');
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: arp_util.debug('EXCEPTION: arp_cma_pkg.bind_cma_variables()');

Line 271: arp_util.debug('EXCEPTION: arp_cma_pkg.bind_cma_variables()');

267: arp_util.debug('arp_cma_pkg.bind_cma_variables()-');
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: arp_util.debug('EXCEPTION: arp_cma_pkg.bind_cma_variables()');
272: RAISE;
273:
274: END;
275:

Line 310: arp_util.debug('arp_cma_pkg.construct_cma_update_stmt()+');

306:
307: PROCEDURE construct_cma_update_stmt( update_text OUT NOCOPY varchar2) IS
308:
309: BEGIN
310: arp_util.debug('arp_cma_pkg.construct_cma_update_stmt()+');
311:
312: update_text :=
313: 'UPDATE ar_credit_memo_amounts
314: SET credit_memo_amount_id =

Line 368: arp_util.debug('arp_cma_pkg.construct_cma_update_stmt()-');

364: DECODE(:request_id,
365: :ar_number_dummy, request_id,
366: :request_id)';
367:
368: arp_util.debug('arp_cma_pkg.construct_cma_update_stmt()-');
369:
370: EXCEPTION
371: WHEN OTHERS THEN
372: arp_util.debug('EXCEPTION: arp_cma_pkg.construct_cma_update_stmt()');

Line 372: arp_util.debug('EXCEPTION: arp_cma_pkg.construct_cma_update_stmt()');

368: arp_util.debug('arp_cma_pkg.construct_cma_update_stmt()-');
369:
370: EXCEPTION
371: WHEN OTHERS THEN
372: arp_util.debug('EXCEPTION: arp_cma_pkg.construct_cma_update_stmt()');
373: RAISE;
374:
375: END;
376:

Line 422: arp_util.debug('arp_cma_pkg.generic_update()+');

418: l_count number;
419: l_update_statement varchar2(25000);
420:
421: BEGIN
422: arp_util.debug('arp_cma_pkg.generic_update()+');
423:
424: /*--------------------------------------------------------------+
425: | If this update statement has not already been parsed, |
426: | construct the statement and parse it. |

Line 440: arp_cma_pkg.construct_cma_update_stmt(l_update_statement);

436: /*---------------------------------+
437: | Construct the update statement |
438: +---------------------------------*/
439:
440: arp_cma_pkg.construct_cma_update_stmt(l_update_statement);
441:
442: l_update_statement := l_update_statement || p_where_clause;
443:
444: /*-----------------------------------------------+

Line 454: arp_cma_pkg.bind_cma_variables(p_update_cursor, p_cma_rec);

450: dbms_sql.v7);
451:
452: END IF;
453:
454: arp_cma_pkg.bind_cma_variables(p_update_cursor, p_cma_rec);
455:
456: /*-----------------------------------------+
457: | Bind the variables in the where clause |
458: +-----------------------------------------*/

Line 477: arp_util.debug('arp_cma_pkg.generic_update()-');

473: THEN RAISE NO_DATA_FOUND;
474: END IF;
475:
476:
477: arp_util.debug('arp_cma_pkg.generic_update()-');
478:
479: EXCEPTION
480: WHEN OTHERS THEN
481: arp_util.debug('EXCEPTION: arp_cma_pkg.generic_update()');

Line 481: arp_util.debug('EXCEPTION: arp_cma_pkg.generic_update()');

477: arp_util.debug('arp_cma_pkg.generic_update()-');
478:
479: EXCEPTION
480: WHEN OTHERS THEN
481: arp_util.debug('EXCEPTION: arp_cma_pkg.generic_update()');
482: arp_util.debug(l_update_statement);
483: arp_util.debug('Error at character: ' ||
484: to_char(dbms_sql.last_error_position));
485: RAISE;

Line 523: arp_util.debug('arp_cma_pkg.set_to_dummy()+');

519: PROCEDURE set_to_dummy( p_cma_rec OUT NOCOPY ar_credit_memo_amounts%rowtype) IS
520:
521: BEGIN
522:
523: arp_util.debug('arp_cma_pkg.set_to_dummy()+');
524:
525: p_cma_rec.credit_memo_amount_id := AR_NUMBER_DUMMY;
526: p_cma_rec.last_updated_by := AR_NUMBER_DUMMY;
527: p_cma_rec.last_update_date := AR_DATE_DUMMY;

Line 539: arp_util.debug('arp_cma_pkg.set_to_dummy()-');

535: p_cma_rec.program_id := AR_NUMBER_DUMMY;
536: p_cma_rec.program_update_date := AR_DATE_DUMMY;
537: p_cma_rec.request_id := AR_NUMBER_DUMMY;
538:
539: arp_util.debug('arp_cma_pkg.set_to_dummy()-');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: arp_util.debug('EXCEPTION: arp_cma_pkg.set_to_dummy()');

Line 543: arp_util.debug('EXCEPTION: arp_cma_pkg.set_to_dummy()');

539: arp_util.debug('arp_cma_pkg.set_to_dummy()-');
540:
541: EXCEPTION
542: WHEN OTHERS THEN
543: arp_util.debug('EXCEPTION: arp_cma_pkg.set_to_dummy()');
544: RAISE;
545:
546: END;
547:

Line 585: arp_util.debug('arp_cma_pkg.lock_p()+');

581: l_credit_memo_amount_id
582: ar_credit_memo_amounts.credit_memo_amount_id%type;
583:
584: BEGIN
585: arp_util.debug('arp_cma_pkg.lock_p()+');
586:
587:
588: SELECT credit_memo_amount_id
589: INTO l_credit_memo_amount_id

Line 594: arp_util.debug('arp_cma_pkg.lock_p()-');

590: FROM ar_credit_memo_amounts
591: WHERE credit_memo_amount_id = p_credit_memo_amount_id
592: FOR UPDATE OF credit_memo_amount_id NOWAIT;
593:
594: arp_util.debug('arp_cma_pkg.lock_p()-');
595:
596: EXCEPTION
597: WHEN OTHERS THEN
598: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_p' );

Line 598: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_p' );

594: arp_util.debug('arp_cma_pkg.lock_p()-');
595:
596: EXCEPTION
597: WHEN OTHERS THEN
598: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_p' );
599: RAISE;
600: END;
601:
602: /*===========================================================================+

Line 640: arp_util.debug('arp_cma_pkg.lock_f_ctl_id()+');

636: WHERE customer_trx_line_id = p_customer_trx_line_id
637: FOR UPDATE OF credit_memo_amount_id NOWAIT;
638:
639: BEGIN
640: arp_util.debug('arp_cma_pkg.lock_f_ctl_id()+');
641:
642: OPEN lock_c;
643: CLOSE lock_c;
644:

Line 645: arp_util.debug('arp_cma_pkg.lock_f_ctl_id()-');

641:
642: OPEN lock_c;
643: CLOSE lock_c;
644:
645: arp_util.debug('arp_cma_pkg.lock_f_ctl_id()-');
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_f_ctl_id' );

Line 649: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_f_ctl_id' );

645: arp_util.debug('arp_cma_pkg.lock_f_ctl_id()-');
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_f_ctl_id' );
650: RAISE;
651: END;
652:
653: /*===========================================================================+

Line 686: arp_util.debug('arp_cma_pkg.lock_fetch_p()+');

682: p_credit_memo_amount_id IN
683: ar_credit_memo_amounts.credit_memo_amount_id%type) IS
684:
685: BEGIN
686: arp_util.debug('arp_cma_pkg.lock_fetch_p()+');
687:
688: SELECT *
689: INTO p_cma_rec
690: FROM ar_credit_memo_amounts

Line 694: arp_util.debug('arp_cma_pkg.lock_fetch_p()-');

690: FROM ar_credit_memo_amounts
691: WHERE credit_memo_amount_id = p_credit_memo_amount_id
692: FOR UPDATE OF credit_memo_amount_id NOWAIT;
693:
694: arp_util.debug('arp_cma_pkg.lock_fetch_p()-');
695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_fetch_p' );

Line 698: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_fetch_p' );

694: arp_util.debug('arp_cma_pkg.lock_fetch_p()-');
695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_fetch_p' );
699: RAISE;
700: END;
701:
702: /*===========================================================================+

Line 738: arp_util.debug('arp_cma_pkg.lock_compare_p()+');

734:
735: l_new_cma_rec ar_credit_memo_amounts%rowtype;
736:
737: BEGIN
738: arp_util.debug('arp_cma_pkg.lock_compare_p()+');
739:
740: SELECT *
741: INTO l_new_cma_rec
742: FROM ar_credit_memo_amounts cma

Line 852: arp_util.debug('arp_cma_pkg.lock_compare_p()-');

848: )
849: )
850: FOR UPDATE OF credit_memo_amount_id NOWAIT;
851:
852: arp_util.debug('arp_cma_pkg.lock_compare_p()-');
853:
854: EXCEPTION
855: WHEN OTHERS THEN
856: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_compare_p' );

Line 856: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_compare_p' );

852: arp_util.debug('arp_cma_pkg.lock_compare_p()-');
853:
854: EXCEPTION
855: WHEN OTHERS THEN
856: arp_util.debug( 'EXCEPTION: arp_cma_pkg.lock_compare_p' );
857: RAISE;
858: END;
859:
860: /*===========================================================================+

Line 894: arp_util.debug('arp_cma_pkg.fetch_p()+');

890: ar_credit_memo_amounts.credit_memo_amount_id%type)
891: IS
892:
893: BEGIN
894: arp_util.debug('arp_cma_pkg.fetch_p()+');
895:
896: SELECT *
897: INTO p_cma_rec
898: FROM ar_credit_memo_amounts

Line 901: arp_util.debug('arp_cma_pkg.fetch_p()-');

897: INTO p_cma_rec
898: FROM ar_credit_memo_amounts
899: WHERE credit_memo_amount_id = p_credit_memo_amount_id;
900:
901: arp_util.debug('arp_cma_pkg.fetch_p()-');
902:
903: EXCEPTION
904: WHEN OTHERS THEN
905: arp_util.debug( 'EXCEPTION: arp_cma_pkg.fetch_p' );

Line 905: arp_util.debug( 'EXCEPTION: arp_cma_pkg.fetch_p' );

901: arp_util.debug('arp_cma_pkg.fetch_p()-');
902:
903: EXCEPTION
904: WHEN OTHERS THEN
905: arp_util.debug( 'EXCEPTION: arp_cma_pkg.fetch_p' );
906: RAISE;
907: END;
908:
909: /*===========================================================================+

Line 944: arp_util.debug('arp_cma_pkg.delete_p()+');

940:
941: BEGIN
942:
943:
944: arp_util.debug('arp_cma_pkg.delete_p()+');
945:
946: DELETE FROM ar_credit_memo_amounts
947: WHERE credit_memo_amount_id = p_credit_memo_amount_id;
948:

Line 949: arp_util.debug('arp_cma_pkg.delete_p()-');

945:
946: DELETE FROM ar_credit_memo_amounts
947: WHERE credit_memo_amount_id = p_credit_memo_amount_id;
948:
949: arp_util.debug('arp_cma_pkg.delete_p()-');
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_p()');

Line 953: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_p()');

949: arp_util.debug('arp_cma_pkg.delete_p()-');
950:
951: EXCEPTION
952: WHEN OTHERS THEN
953: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_p()');
954:
955: RAISE;
956:
957: END;

Line 994: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()+');

990:
991: BEGIN
992:
993:
994: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()+');
995:
996: DELETE FROM ar_credit_memo_amounts
997: WHERE customer_trx_line_id = p_customer_trx_line_id;
998:

Line 999: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()-');

995:
996: DELETE FROM ar_credit_memo_amounts
997: WHERE customer_trx_line_id = p_customer_trx_line_id;
998:
999: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()-');
1000:
1001: EXCEPTION
1002: WHEN OTHERS THEN
1003: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_f_ctl_id()');

Line 1003: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_f_ctl_id()');

999: arp_util.debug('arp_cma_pkg.delete_f_ctl_id()-');
1000:
1001: EXCEPTION
1002: WHEN OTHERS THEN
1003: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_f_ctl_id()');
1004:
1005: RAISE;
1006:
1007: END;

Line 1044: arp_util.debug('arp_cma_pkg.delete_f_ct_id()+');

1040:
1041:
1042: BEGIN
1043:
1044: arp_util.debug('arp_cma_pkg.delete_f_ct_id()+');
1045:
1046: DELETE FROM ar_credit_memo_amounts
1047: WHERE customer_trx_line_id IN
1048: (SELECT customer_trx_line_id

Line 1052: arp_util.debug('arp_cma_pkg.delete_f_ct_id()-');

1048: (SELECT customer_trx_line_id
1049: FROM ra_customer_trx_lines
1050: WHERE customer_trx_id = p_customer_trx_id);
1051:
1052: arp_util.debug('arp_cma_pkg.delete_f_ct_id()-');
1053:
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_f_ct_id()');

Line 1056: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_f_ct_id()');

1052: arp_util.debug('arp_cma_pkg.delete_f_ct_id()-');
1053:
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: arp_util.debug('EXCEPTION: arp_cma_pkg.delete_f_ct_id()');
1057:
1058: RAISE;
1059:
1060: END;

Line 1100: arp_util.debug('arp_cma_pkg.update_p()+ ' ||

1096:
1097:
1098: BEGIN
1099:
1100: arp_util.debug('arp_cma_pkg.update_p()+ ' ||
1101: to_char(sysdate, 'HH:MI:SS'));
1102:
1103: arp_cma_pkg.generic_update( pg_cursor1,
1104: ' WHERE credit_memo_amount_id = :where_1',

Line 1103: arp_cma_pkg.generic_update( pg_cursor1,

1099:
1100: arp_util.debug('arp_cma_pkg.update_p()+ ' ||
1101: to_char(sysdate, 'HH:MI:SS'));
1102:
1103: arp_cma_pkg.generic_update( pg_cursor1,
1104: ' WHERE credit_memo_amount_id = :where_1',
1105: p_credit_memo_amount_id,
1106: p_cma_rec);
1107:

Line 1108: arp_util.debug('arp_cma_pkg.update_p()- ' ||

1104: ' WHERE credit_memo_amount_id = :where_1',
1105: p_credit_memo_amount_id,
1106: p_cma_rec);
1107:
1108: arp_util.debug('arp_cma_pkg.update_p()- ' ||
1109: to_char(sysdate, 'HH:MI:SS'));
1110:
1111:
1112: EXCEPTION

Line 1114: arp_util.debug('EXCEPTION: arp_cma_pkg.update_p()');

1110:
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: arp_util.debug('EXCEPTION: arp_cma_pkg.update_p()');
1115: RAISE;
1116: END;
1117:
1118: /*===========================================================================+

Line 1156: arp_util.debug('arp_cma_pkg.update_f_ctl_id()+ ' ||

1152:
1153:
1154: BEGIN
1155:
1156: arp_util.debug('arp_cma_pkg.update_f_ctl_id()+ ' ||
1157: to_char(sysdate, 'HH:MI:SS'));
1158:
1159: arp_cma_pkg.generic_update( pg_cursor3,
1160: ' WHERE customer_trx_line_id = :where_1',

Line 1159: arp_cma_pkg.generic_update( pg_cursor3,

1155:
1156: arp_util.debug('arp_cma_pkg.update_f_ctl_id()+ ' ||
1157: to_char(sysdate, 'HH:MI:SS'));
1158:
1159: arp_cma_pkg.generic_update( pg_cursor3,
1160: ' WHERE customer_trx_line_id = :where_1',
1161: p_customer_trx_line_id,
1162: p_cma_rec);
1163:

Line 1164: arp_util.debug('arp_cma_pkg.update_f_ctl_id()- ' ||

1160: ' WHERE customer_trx_line_id = :where_1',
1161: p_customer_trx_line_id,
1162: p_cma_rec);
1163:
1164: arp_util.debug('arp_cma_pkg.update_f_ctl_id()- ' ||
1165: to_char(sysdate, 'HH:MI:SS'));
1166:
1167:
1168: EXCEPTION

Line 1170: arp_util.debug('EXCEPTION: arp_cma_pkg.update_f_ctl_id()');

1166:
1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: arp_util.debug('EXCEPTION: arp_cma_pkg.update_f_ctl_id()');
1171: RAISE;
1172: END;
1173:
1174:

Line 1216: arp_util.debug('arp_cma_pkg.insert_p()+');

1212:
1213:
1214: BEGIN
1215:
1216: arp_util.debug('arp_cma_pkg.insert_p()+');
1217:
1218: p_credit_memo_amount_id := '';
1219:
1220: /*---------------------------*

Line 1271: arp_util.debug('arp_cma_pkg.insert_p()-');

1267:
1268:
1269: p_credit_memo_amount_id := l_credit_memo_amount_id;
1270:
1271: arp_util.debug('arp_cma_pkg.insert_p()-');
1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: arp_util.debug('EXCEPTION: arp_cma_pkg.insert_p()');

Line 1275: arp_util.debug('EXCEPTION: arp_cma_pkg.insert_p()');

1271: arp_util.debug('arp_cma_pkg.insert_p()-');
1272:
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: arp_util.debug('EXCEPTION: arp_cma_pkg.insert_p()');
1276: RAISE;
1277: END;
1278:
1279:

Line 1294: END ARP_CMA_PKG;

1290: pg_prog_appl_id := fnd_global.prog_appl_id;
1291: pg_conc_program_id := fnd_global.conc_program_id;
1292:
1293:
1294: END ARP_CMA_PKG;