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_UTIL

Line 45: | arp_util.debug |

41: | |
42: | SCOPE - PRIVATE |
43: | |
44: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
45: | arp_util.debug |
46: | |
47: | ARGUMENTS : IN: |
48: | p_old_cma_rec - first cma record |
49: | p_new_cma_rec - second cma record |

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 140: arp_util.debug(

136:
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');

Line 143: arp_util.debug(

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;
146:
147: arp_util.debug('arp_cma_pkg.compare_cma_records()-');

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 169: | arp_util.debug |

165: | SCOPE - PRIVATE |
166: | |
167: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
168: | dbms_sql.bind_variable |
169: | arp_util.debug |
170: | |
171: | ARGUMENTS : IN: |
172: | p_update_cursor - ID of the update cursor |
173: | p_cma_rec - ar_credit_memo_amounts record |

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 289: | arp_util.debug |

285: | |
286: | SCOPE - PRIVATE |
287: | |
288: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
289: | arp_util.debug |
290: | |
291: | ARGUMENTS : IN: |
292: | None. |
293: | OUT: |

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 390: | arp_util.debug |

386: | |
387: | SCOPE - PRIVATE |
388: | |
389: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
390: | arp_util.debug |
391: | dbms_sql.open_cursor |
392: | dbms_sql.parse |
393: | dbms_sql.execute |
394: | dbms_sql.close_cursor |

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 465: arp_util.debug( to_char(l_count) || ' rows updated');

461: p_where1);
462:
463: l_count := dbms_sql.execute(p_update_cursor);
464:
465: arp_util.debug( to_char(l_count) || ' rows updated');
466:
467:
468: /*------------------------------------------------------------+
469: | Raise the NO_DATA_FOUND exception if no rows were updated |

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 482: arp_util.debug(l_update_statement);

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;
486: END;

Line 483: arp_util.debug('Error at character: ' ||

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;
486: END;
487:

Line 503: | arp_util.debug |

499: | |
500: | SCOPE - PUBLIC |
501: | |
502: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
503: | arp_util.debug |
504: | |
505: | ARGUMENTS : IN: |
506: | None |
507: | OUT: |

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 560: | arp_util.debug |

556: | |
557: | SCOPE - PUBLIC |
558: | |
559: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
560: | arp_util.debug |
561: | |
562: | ARGUMENTS : IN: |
563: | p_credit_memo_amount_id - identifies the row to lock |
564: | OUT: |

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 613: | arp_util.debug |

609: | |
610: | SCOPE - PUBLIC |
611: | |
612: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
613: | arp_util.debug |
614: | |
615: | ARGUMENTS : IN: |
616: | p_customer_trx_line_id - identifies the rows to lock |
617: | OUT: |

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 665: | arp_util.debug |

661: | |
662: | SCOPE - PUBLIC |
663: | |
664: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
665: | arp_util.debug |
666: | |
667: | ARGUMENTS : IN: |
668: | p_credit_memo_amount_id - identifies the row to lock |
669: | OUT: |

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 714: | arp_util.debug |

710: | |
711: | SCOPE - PUBLIC |
712: | |
713: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
714: | arp_util.debug |
715: | |
716: | ARGUMENTS : IN: |
717: | p_credit_memo_amount_id - identifies the row to lock |
718: | p_cma_rec - cma record for comparison |

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 872: | arp_util.debug |

868: | |
869: | SCOPE - PUBLIC |
870: | |
871: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
872: | arp_util.debug |
873: | |
874: | ARGUMENTS : IN: |
875: | p_credit_memo_amount_id - identifies the record to fetch |
876: | OUT: |

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 920: | arp_util.debug |

916: | |
917: | SCOPE - PUBLIC |
918: | |
919: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
920: | arp_util.debug |
921: | |
922: | ARGUMENTS : IN: |
923: | p_credit_memo_amount_id - identifies the rows to delete |
924: | OUT: |

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 970: | arp_util.debug |

966: | |
967: | SCOPE - PUBLIC |
968: | |
969: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
970: | arp_util.debug |
971: | |
972: | ARGUMENTS : IN: |
973: | p_customer_trx_line_id - identifies the rows to delete |
974: | OUT: |

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 1020: | arp_util.debug |

1016: | |
1017: | SCOPE - PUBLIC |
1018: | |
1019: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1020: | arp_util.debug |
1021: | |
1022: | ARGUMENTS : IN: |
1023: | p_customer_trx_id - identifies the transactions
1024: | for which we then delete all CMA rows

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 1073: | arp_util.debug |

1069: | |
1070: | SCOPE - PUBLIC |
1071: | |
1072: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1073: | arp_util.debug |
1074: | |
1075: | ARGUMENTS : IN: |
1076: | p_credit_memo_amount_id - identifies the row to update |
1077: | p_cma_rec - contains the new column values |

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 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 1129: | arp_util.debug |

1125: | |
1126: | SCOPE - PUBLIC |
1127: | |
1128: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1129: | arp_util.debug |
1130: | |
1131: | ARGUMENTS : IN: |
1132: | p_customer_trx_line_id - identifies the rows to update |
1133: | p_cma_rec - contains the new column values |

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 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 1186: | arp_util.debug |

1182: | |
1183: | SCOPE - PUBLIC |
1184: | |
1185: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1186: | arp_util.debug |
1187: | |
1188: | ARGUMENTS : IN: |
1189: | p_cma_rec - contains the new column values |
1190: | OUT: |

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: