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_AAH_PKG dependencies on ARP_UTIL

Line 44: | arp_util.debug |

40: | SCOPE - PRIVATE |
41: | |
42: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
43: | dbms_sql.bind_variable |
44: | arp_util.debug |
45: | |
46: | ARGUMENTS : IN: |
47: | p_update_cursor - ID of the update cursor |
48: | p_aah_rec - ar_approval_action_history record |

Line 68: arp_util.debug('arp_aah_pkg.bind_aah_variables()+');

64: IS
65:
66: BEGIN
67:
68: arp_util.debug('arp_aah_pkg.bind_aah_variables()+');
69:
70: /*------------------+
71: | Dummy constants |
72: +------------------*/

Line 185: arp_util.debug('arp_aah_pkg.bind_aah_variables()-');

181: p_aah_rec.last_update_login);
182:
183:
184:
185: arp_util.debug('arp_aah_pkg.bind_aah_variables()-');
186:
187: EXCEPTION
188: WHEN OTHERS THEN
189: arp_util.debug('EXCEPTION: arp_aah_pkg.bind_aah_variables()');

Line 189: arp_util.debug('EXCEPTION: arp_aah_pkg.bind_aah_variables()');

185: arp_util.debug('arp_aah_pkg.bind_aah_variables()-');
186:
187: EXCEPTION
188: WHEN OTHERS THEN
189: arp_util.debug('EXCEPTION: arp_aah_pkg.bind_aah_variables()');
190: RAISE;
191:
192: END;
193:

Line 207: | arp_util.debug |

203: | |
204: | SCOPE - PRIVATE |
205: | |
206: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
207: | arp_util.debug |
208: | |
209: | ARGUMENTS : IN: |
210: | None. |
211: | OUT: |

Line 228: arp_util.debug('arp_aah_pkg.construct_aah_update_stmt()+');

224:
225: PROCEDURE construct_aah_update_stmt( update_text OUT NOCOPY varchar2) IS
226:
227: BEGIN
228: arp_util.debug('arp_aah_pkg.construct_aah_update_stmt()+');
229:
230: update_text :=
231: 'UPDATE ar_approval_action_history
232: SET approval_action_history_id =

Line 338: arp_util.debug('arp_aah_pkg.construct_aah_update_stmt()-');

334: :ar_number_dummy, nvl(:pg_conc_login_id,
335: :pg_login_id),
336: :last_update_login)';
337:
338: arp_util.debug('arp_aah_pkg.construct_aah_update_stmt()-');
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: arp_util.debug('EXCEPTION: arp_aah_pkg.construct_aah_update_stmt()');

Line 342: arp_util.debug('EXCEPTION: arp_aah_pkg.construct_aah_update_stmt()');

338: arp_util.debug('arp_aah_pkg.construct_aah_update_stmt()-');
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: arp_util.debug('EXCEPTION: arp_aah_pkg.construct_aah_update_stmt()');
343: RAISE;
344:
345: END;
346:

Line 360: | arp_util.debug |

356: | |
357: | SCOPE - PRIVATE |
358: | |
359: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
360: | arp_util.debug |
361: | dbms_sql.open_cursor |
362: | dbms_sql.parse |
363: | dbms_sql.execute |
364: | dbms_sql.close_cursor |

Line 392: arp_util.debug('arp_aah_pkg.generic_update()+');

388: l_count number;
389: l_update_statement varchar2(25000);
390:
391: BEGIN
392: arp_util.debug('arp_aah_pkg.generic_update()+');
393:
394: /*--------------------------------------------------------------+
395: | If this update statement has not already been parsed, |
396: | construct the statement and parse it. |

Line 435: arp_util.debug( to_char(l_count) || ' rows updated');

431: p_where1);
432:
433: l_count := dbms_sql.execute(p_update_cursor);
434:
435: arp_util.debug( to_char(l_count) || ' rows updated');
436:
437:
438: /*------------------------------------------------------------+
439: | Raise the NO_DATA_FOUND exception if no rows were updated |

Line 447: arp_util.debug('arp_aah_pkg.generic_update()-');

443: THEN raise NO_DATA_FOUND;
444: END IF;
445:
446:
447: arp_util.debug('arp_aah_pkg.generic_update()-');
448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: arp_util.debug('EXCEPTION: arp_aah_pkg.generic_update()');

Line 451: arp_util.debug('EXCEPTION: arp_aah_pkg.generic_update()');

447: arp_util.debug('arp_aah_pkg.generic_update()-');
448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: arp_util.debug('EXCEPTION: arp_aah_pkg.generic_update()');
452: arp_util.debug(l_update_statement);
453: arp_util.debug('Error at character: ' ||
454: to_char(dbms_sql.last_error_position));
455: RAISE;

Line 452: arp_util.debug(l_update_statement);

448:
449: EXCEPTION
450: WHEN OTHERS THEN
451: arp_util.debug('EXCEPTION: arp_aah_pkg.generic_update()');
452: arp_util.debug(l_update_statement);
453: arp_util.debug('Error at character: ' ||
454: to_char(dbms_sql.last_error_position));
455: RAISE;
456: END;

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

449: EXCEPTION
450: WHEN OTHERS THEN
451: arp_util.debug('EXCEPTION: arp_aah_pkg.generic_update()');
452: arp_util.debug(l_update_statement);
453: arp_util.debug('Error at character: ' ||
454: to_char(dbms_sql.last_error_position));
455: RAISE;
456: END;
457:

Line 474: | arp_util.debug |

470: | |
471: | SCOPE - PUBLIC |
472: | |
473: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
474: | arp_util.debug |
475: | |
476: | ARGUMENTS : IN: |
477: | None |
478: | OUT: |

Line 494: arp_util.debug('arp_aah_pkg.set_to_dummy()+');

490: PROCEDURE set_to_dummy( p_aah_rec OUT NOCOPY ar_approval_action_history%rowtype) IS
491:
492: BEGIN
493:
494: arp_util.debug('arp_aah_pkg.set_to_dummy()+');
495:
496: p_aah_rec.approval_action_history_id := AR_NUMBER_DUMMY;
497: p_aah_rec.action_name := AR_TEXT_DUMMY;
498: p_aah_rec.adjustment_id := AR_NUMBER_DUMMY;

Line 523: arp_util.debug('arp_aah_pkg.set_to_dummy()-');

519: p_aah_rec.last_updated_by := AR_NUMBER_DUMMY;
520: p_aah_rec.last_update_date := AR_DATE_DUMMY;
521: p_aah_rec.last_update_login := AR_NUMBER_DUMMY;
522:
523: arp_util.debug('arp_aah_pkg.set_to_dummy()-');
524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: arp_util.debug('EXCEPTION: arp_aah_pkg.set_to_dummy()');

Line 527: arp_util.debug('EXCEPTION: arp_aah_pkg.set_to_dummy()');

523: arp_util.debug('arp_aah_pkg.set_to_dummy()-');
524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: arp_util.debug('EXCEPTION: arp_aah_pkg.set_to_dummy()');
528: RAISE;
529:
530: END;
531:

Line 544: | arp_util.debug |

540: | |
541: | SCOPE - PUBLIC |
542: | |
543: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
544: | arp_util.debug |
545: | |
546: | ARGUMENTS : IN: |
547: | p_approval_action_history_id - identifies the row to lock |
548: | OUT: |

Line 569: arp_util.debug('arp_aah_pkg.lock_p()+');

565: l_approval_action_history_id
566: ar_approval_action_history.approval_action_history_id%type;
567:
568: BEGIN
569: arp_util.debug('arp_aah_pkg.lock_p()+');
570:
571:
572: SELECT approval_action_history_id
573: INTO l_approval_action_history_id

Line 578: arp_util.debug('arp_aah_pkg.lock_p()-');

574: FROM ar_approval_action_history
575: WHERE approval_action_history_id = p_approval_action_history_id
576: FOR UPDATE OF approval_action_history_id NOWAIT;
577:
578: arp_util.debug('arp_aah_pkg.lock_p()-');
579:
580: EXCEPTION
581: WHEN OTHERS THEN
582: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_p' );

Line 582: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_p' );

578: arp_util.debug('arp_aah_pkg.lock_p()-');
579:
580: EXCEPTION
581: WHEN OTHERS THEN
582: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_p' );
583: RAISE;
584: END;
585:
586: /*===========================================================================+

Line 597: | arp_util.debug |

593: | |
594: | SCOPE - PUBLIC |
595: | |
596: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
597: | arp_util.debug |
598: | |
599: | ARGUMENTS : IN: |
600: | p_adjustment_id - identifies the rows to lock |
601: | OUT: |

Line 625: arp_util.debug('arp_aah_pkg.lock_f_adj_id()+');

621: FOR UPDATE OF approval_action_history_id NOWAIT;
622:
623:
624: BEGIN
625: arp_util.debug('arp_aah_pkg.lock_f_adj_id()+');
626:
627: OPEN lock_c;
628: CLOSE lock_c;
629:

Line 630: arp_util.debug('arp_aah_pkg.lock_f_adj_id()-');

626:
627: OPEN lock_c;
628: CLOSE lock_c;
629:
630: arp_util.debug('arp_aah_pkg.lock_f_adj_id()-');
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_f_adj_id' );

Line 634: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_f_adj_id' );

630: arp_util.debug('arp_aah_pkg.lock_f_adj_id()-');
631:
632: EXCEPTION
633: WHEN OTHERS THEN
634: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_f_adj_id' );
635: RAISE;
636: END;
637:
638:

Line 651: | arp_util.debug |

647: | |
648: | SCOPE - PUBLIC |
649: | |
650: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
651: | arp_util.debug |
652: | |
653: | ARGUMENTS : IN: |
654: | p_approval_action_history_id - identifies the row to lock |
655: | OUT: |

Line 672: arp_util.debug('arp_aah_pkg.lock_fetch_p()+');

668: p_approval_action_history_id IN
669: ar_approval_action_history.approval_action_history_id%type) IS
670:
671: BEGIN
672: arp_util.debug('arp_aah_pkg.lock_fetch_p()+');
673:
674: SELECT *
675: INTO p_aah_rec
676: FROM ar_approval_action_history

Line 680: arp_util.debug('arp_aah_pkg.lock_fetch_p()-');

676: FROM ar_approval_action_history
677: WHERE approval_action_history_id = p_approval_action_history_id
678: FOR UPDATE OF approval_action_history_id NOWAIT;
679:
680: arp_util.debug('arp_aah_pkg.lock_fetch_p()-');
681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_fetch_p' );

Line 684: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_fetch_p' );

680: arp_util.debug('arp_aah_pkg.lock_fetch_p()-');
681:
682: EXCEPTION
683: WHEN OTHERS THEN
684: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_fetch_p' );
685: RAISE;
686: END;
687:
688: /*===========================================================================+

Line 700: | arp_util.debug |

696: | |
697: | SCOPE - PUBLIC |
698: | |
699: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
700: | arp_util.debug |
701: | |
702: | ARGUMENTS : IN: |
703: | p_approval_action_history_id - identifies the row to lock |
704: | p_aah_rec - aah record for comparison |

Line 725: arp_util.debug('arp_aah_pkg.lock_compare_p()+');

721:
722: l_dummy_aah_rec ar_approval_action_history%rowtype;
723:
724: BEGIN
725: arp_util.debug('arp_aah_pkg.lock_compare_p()+');
726:
727: SELECT *
728: INTO l_dummy_aah_rec
729: FROM ar_approval_action_history aah

Line 943: arp_util.debug('arp_aah_pkg.lock_compare_p()-');

939: )
940: )
941: FOR UPDATE OF approval_action_history_id NOWAIT;
942:
943: arp_util.debug('arp_aah_pkg.lock_compare_p()-');
944:
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_compare_p' );

Line 947: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_compare_p' );

943: arp_util.debug('arp_aah_pkg.lock_compare_p()-');
944:
945: EXCEPTION
946: WHEN OTHERS THEN
947: arp_util.debug( 'EXCEPTION: arp_aah_pkg.lock_compare_p' );
948: RAISE;
949: END;
950:
951:

Line 964: | arp_util.debug |

960: | |
961: | SCOPE - PUBLIC |
962: | |
963: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
964: | arp_util.debug |
965: | |
966: | ARGUMENTS : IN: |
967: | p_approval_action_history_id - identifies the record to fetch |
968: | OUT: |

Line 986: arp_util.debug('arp_aah_pkg.fetch_p()+');

982: ar_approval_action_history.approval_action_history_id%type)
983: IS
984:
985: BEGIN
986: arp_util.debug('arp_aah_pkg.fetch_p()+');
987:
988: SELECT *
989: INTO p_aah_rec
990: FROM ar_approval_action_history

Line 993: arp_util.debug('arp_aah_pkg.fetch_p()-');

989: INTO p_aah_rec
990: FROM ar_approval_action_history
991: WHERE approval_action_history_id = p_approval_action_history_id;
992:
993: arp_util.debug('arp_aah_pkg.fetch_p()-');
994:
995: EXCEPTION
996: WHEN OTHERS THEN
997: arp_util.debug( 'EXCEPTION: arp_aah_pkg.fetch_p' );

Line 997: arp_util.debug( 'EXCEPTION: arp_aah_pkg.fetch_p' );

993: arp_util.debug('arp_aah_pkg.fetch_p()-');
994:
995: EXCEPTION
996: WHEN OTHERS THEN
997: arp_util.debug( 'EXCEPTION: arp_aah_pkg.fetch_p' );
998: RAISE;
999: END;
1000:
1001: /*===========================================================================+

Line 1012: | arp_util.debug |

1008: | |
1009: | SCOPE - PUBLIC |
1010: | |
1011: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1012: | arp_util.debug |
1013: | |
1014: | ARGUMENTS : IN: |
1015: | p_approval_action_history_id - identifies the rows to delete |
1016: | OUT: |

Line 1036: arp_util.debug('arp_aah_pkg.delete_p()+');

1032:
1033: BEGIN
1034:
1035:
1036: arp_util.debug('arp_aah_pkg.delete_p()+');
1037:
1038: DELETE FROM ar_approval_action_history
1039: WHERE approval_action_history_id = p_approval_action_history_id;
1040:

Line 1041: arp_util.debug('arp_aah_pkg.delete_p()-');

1037:
1038: DELETE FROM ar_approval_action_history
1039: WHERE approval_action_history_id = p_approval_action_history_id;
1040:
1041: arp_util.debug('arp_aah_pkg.delete_p()-');
1042:
1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: arp_util.debug('EXCEPTION: arp_aah_pkg.delete_p()');

Line 1045: arp_util.debug('EXCEPTION: arp_aah_pkg.delete_p()');

1041: arp_util.debug('arp_aah_pkg.delete_p()-');
1042:
1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: arp_util.debug('EXCEPTION: arp_aah_pkg.delete_p()');
1046:
1047: RAISE;
1048:
1049: END;

Line 1062: | arp_util.debug |

1058: | |
1059: | SCOPE - PUBLIC |
1060: | |
1061: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1062: | arp_util.debug |
1063: | |
1064: | ARGUMENTS : IN: |
1065: | p_adjustment_id - identifies the rows to delete |
1066: | OUT: |

Line 1086: arp_util.debug('arp_aah_pkg.delete_f_adj_id()+');

1082:
1083: BEGIN
1084:
1085:
1086: arp_util.debug('arp_aah_pkg.delete_f_adj_id()+');
1087:
1088: DELETE FROM ar_approval_action_history
1089: WHERE adjustment_id = p_adjustment_id;
1090:

Line 1091: arp_util.debug('arp_aah_pkg.delete_f_adj_id()-');

1087:
1088: DELETE FROM ar_approval_action_history
1089: WHERE adjustment_id = p_adjustment_id;
1090:
1091: arp_util.debug('arp_aah_pkg.delete_f_adj_id()-');
1092:
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: arp_util.debug('EXCEPTION: arp_aah_pkg.delete_f_adj_id()');

Line 1095: arp_util.debug('EXCEPTION: arp_aah_pkg.delete_f_adj_id()');

1091: arp_util.debug('arp_aah_pkg.delete_f_adj_id()-');
1092:
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: arp_util.debug('EXCEPTION: arp_aah_pkg.delete_f_adj_id()');
1096:
1097: RAISE;
1098:
1099: END;

Line 1113: | arp_util.debug |

1109: | |
1110: | SCOPE - PUBLIC |
1111: | |
1112: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1113: | arp_util.debug |
1114: | |
1115: | ARGUMENTS : IN: |
1116: | p_approval_action_history_id - identifies the row to update |
1117: | p_aah_rec - contains the new column values |

Line 1140: arp_util.debug('arp_aah_pkg.update_p()+ ' ||

1136:
1137:
1138: BEGIN
1139:
1140: arp_util.debug('arp_aah_pkg.update_p()+ ' ||
1141: to_char(sysdate, 'HH:MI:SS'));
1142:
1143: arp_aah_pkg.generic_update( pg_cursor1,
1144: ' WHERE approval_action_history_id = :where_1',

Line 1148: arp_util.debug('arp_aah_pkg.update_p()- ' ||

1144: ' WHERE approval_action_history_id = :where_1',
1145: p_approval_action_history_id,
1146: p_aah_rec);
1147:
1148: arp_util.debug('arp_aah_pkg.update_p()- ' ||
1149: to_char(sysdate, 'HH:MI:SS'));
1150:
1151:
1152: EXCEPTION

Line 1154: arp_util.debug('EXCEPTION: arp_aah_pkg.update_p()');

1150:
1151:
1152: EXCEPTION
1153: WHEN OTHERS THEN
1154: arp_util.debug('EXCEPTION: arp_aah_pkg.update_p()');
1155: RAISE;
1156: END;
1157:
1158:

Line 1170: | arp_util.debug |

1166: | |
1167: | SCOPE - PUBLIC |
1168: | |
1169: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1170: | arp_util.debug |
1171: | |
1172: | ARGUMENTS : IN: |
1173: | p_adjustment_id - identifies the rows to update |
1174: | p_aah_rec - contains the new column values |

Line 1196: arp_util.debug('arp_aah_pkg.update_f_adj_id()+ ' ||

1192:
1193:
1194: BEGIN
1195:
1196: arp_util.debug('arp_aah_pkg.update_f_adj_id()+ ' ||
1197: to_char(sysdate, 'HH:MI:SS'));
1198:
1199: arp_aah_pkg.generic_update( pg_cursor2,
1200: ' WHERE adjustment_id = :where_1',

Line 1204: arp_util.debug('arp_aah_pkg.update_f_adj_id()- ' ||

1200: ' WHERE adjustment_id = :where_1',
1201: p_adjustment_id,
1202: p_aah_rec);
1203:
1204: arp_util.debug('arp_aah_pkg.update_f_adj_id()- ' ||
1205: to_char(sysdate, 'HH:MI:SS'));
1206:
1207:
1208: EXCEPTION

Line 1210: arp_util.debug('EXCEPTION: arp_aah_pkg.update_f_adj_id()');

1206:
1207:
1208: EXCEPTION
1209: WHEN OTHERS THEN
1210: arp_util.debug('EXCEPTION: arp_aah_pkg.update_f_adj_id()');
1211: RAISE;
1212: END;
1213:
1214:

Line 1226: | arp_util.debug |

1222: | |
1223: | SCOPE - PUBLIC |
1224: | |
1225: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1226: | arp_util.debug |
1227: | |
1228: | ARGUMENTS : IN: |
1229: | p_aah_rec - contains the new column values |
1230: | OUT: |

Line 1255: arp_util.debug('arp_aah_pkg.insert_p()+');

1251:
1252:
1253: BEGIN
1254:
1255: arp_util.debug('arp_aah_pkg.insert_p()+');
1256:
1257: p_approval_action_history_id := '';
1258:
1259: /*---------------------------*

Line 1336: arp_util.debug('arp_aah_pkg.insert_p()-');

1332:
1333:
1334: p_approval_action_history_id := l_approval_action_history_id;
1335:
1336: arp_util.debug('arp_aah_pkg.insert_p()-');
1337:
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340: arp_util.debug('EXCEPTION: arp_aah_pkg.insert_p()');

Line 1340: arp_util.debug('EXCEPTION: arp_aah_pkg.insert_p()');

1336: arp_util.debug('arp_aah_pkg.insert_p()-');
1337:
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340: arp_util.debug('EXCEPTION: arp_aah_pkg.insert_p()');
1341: RAISE;
1342: END;
1343:
1344: /*===========================================================================+

Line 1355: | arp_util.debug |

1351: | |
1352: | SCOPE - PRIVATE |
1353: | |
1354: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1355: | arp_util.debug |
1356: | |
1357: | ARGUMENTS : IN: |
1358: | p_aah_rec |
1359: | OUT: |

Line 1375: arp_util.debug('arp_aah_pkg.display_aah_rec()+');

1371: PROCEDURE display_aah_rec(
1372: p_aah_rec IN ar_approval_action_history%rowtype) IS
1373:
1374: BEGIN
1375: arp_util.debug('arp_aah_pkg.display_aah_rec()+');
1376:
1377: arp_util.debug('******** Dump of ar_approval_action_history record ' ||
1378: '*********');
1379:

Line 1377: arp_util.debug('******** Dump of ar_approval_action_history record ' ||

1373:
1374: BEGIN
1375: arp_util.debug('arp_aah_pkg.display_aah_rec()+');
1376:
1377: arp_util.debug('******** Dump of ar_approval_action_history record ' ||
1378: '*********');
1379:
1380: arp_util.debug('approval_action_history_id : '||
1381: p_aah_rec.approval_action_history_id);

Line 1380: arp_util.debug('approval_action_history_id : '||

1376:
1377: arp_util.debug('******** Dump of ar_approval_action_history record ' ||
1378: '*********');
1379:
1380: arp_util.debug('approval_action_history_id : '||
1381: p_aah_rec.approval_action_history_id);
1382: arp_util.debug('created_by : '||
1383: p_aah_rec.created_by);
1384: arp_util.debug('last_updated_by : '||

Line 1382: arp_util.debug('created_by : '||

1378: '*********');
1379:
1380: arp_util.debug('approval_action_history_id : '||
1381: p_aah_rec.approval_action_history_id);
1382: arp_util.debug('created_by : '||
1383: p_aah_rec.created_by);
1384: arp_util.debug('last_updated_by : '||
1385: p_aah_rec.last_updated_by);
1386: arp_util.debug('last_update_login : '||

Line 1384: arp_util.debug('last_updated_by : '||

1380: arp_util.debug('approval_action_history_id : '||
1381: p_aah_rec.approval_action_history_id);
1382: arp_util.debug('created_by : '||
1383: p_aah_rec.created_by);
1384: arp_util.debug('last_updated_by : '||
1385: p_aah_rec.last_updated_by);
1386: arp_util.debug('last_update_login : '||
1387: p_aah_rec.last_update_login);
1388: arp_util.debug('action_name : '||

Line 1386: arp_util.debug('last_update_login : '||

1382: arp_util.debug('created_by : '||
1383: p_aah_rec.created_by);
1384: arp_util.debug('last_updated_by : '||
1385: p_aah_rec.last_updated_by);
1386: arp_util.debug('last_update_login : '||
1387: p_aah_rec.last_update_login);
1388: arp_util.debug('action_name : '||
1389: p_aah_rec.action_name);
1390: arp_util.debug('adjustment_id : '||

Line 1388: arp_util.debug('action_name : '||

1384: arp_util.debug('last_updated_by : '||
1385: p_aah_rec.last_updated_by);
1386: arp_util.debug('last_update_login : '||
1387: p_aah_rec.last_update_login);
1388: arp_util.debug('action_name : '||
1389: p_aah_rec.action_name);
1390: arp_util.debug('adjustment_id : '||
1391: p_aah_rec.adjustment_id);
1392: arp_util.debug('comments : '||

Line 1390: arp_util.debug('adjustment_id : '||

1386: arp_util.debug('last_update_login : '||
1387: p_aah_rec.last_update_login);
1388: arp_util.debug('action_name : '||
1389: p_aah_rec.action_name);
1390: arp_util.debug('adjustment_id : '||
1391: p_aah_rec.adjustment_id);
1392: arp_util.debug('comments : '||
1393: p_aah_rec.comments);
1394: arp_util.debug('attribute_category : '||

Line 1392: arp_util.debug('comments : '||

1388: arp_util.debug('action_name : '||
1389: p_aah_rec.action_name);
1390: arp_util.debug('adjustment_id : '||
1391: p_aah_rec.adjustment_id);
1392: arp_util.debug('comments : '||
1393: p_aah_rec.comments);
1394: arp_util.debug('attribute_category : '||
1395: p_aah_rec.attribute_category);
1396: arp_util.debug('attribute1 : '||

Line 1394: arp_util.debug('attribute_category : '||

1390: arp_util.debug('adjustment_id : '||
1391: p_aah_rec.adjustment_id);
1392: arp_util.debug('comments : '||
1393: p_aah_rec.comments);
1394: arp_util.debug('attribute_category : '||
1395: p_aah_rec.attribute_category);
1396: arp_util.debug('attribute1 : '||
1397: p_aah_rec.attribute1);
1398: arp_util.debug('attribute2 : '||

Line 1396: arp_util.debug('attribute1 : '||

1392: arp_util.debug('comments : '||
1393: p_aah_rec.comments);
1394: arp_util.debug('attribute_category : '||
1395: p_aah_rec.attribute_category);
1396: arp_util.debug('attribute1 : '||
1397: p_aah_rec.attribute1);
1398: arp_util.debug('attribute2 : '||
1399: p_aah_rec.attribute2);
1400: arp_util.debug('attribute3 : '||

Line 1398: arp_util.debug('attribute2 : '||

1394: arp_util.debug('attribute_category : '||
1395: p_aah_rec.attribute_category);
1396: arp_util.debug('attribute1 : '||
1397: p_aah_rec.attribute1);
1398: arp_util.debug('attribute2 : '||
1399: p_aah_rec.attribute2);
1400: arp_util.debug('attribute3 : '||
1401: p_aah_rec.attribute3);
1402: arp_util.debug('attribute4 : '||

Line 1400: arp_util.debug('attribute3 : '||

1396: arp_util.debug('attribute1 : '||
1397: p_aah_rec.attribute1);
1398: arp_util.debug('attribute2 : '||
1399: p_aah_rec.attribute2);
1400: arp_util.debug('attribute3 : '||
1401: p_aah_rec.attribute3);
1402: arp_util.debug('attribute4 : '||
1403: p_aah_rec.attribute4);
1404: arp_util.debug('attribute5 : '||

Line 1402: arp_util.debug('attribute4 : '||

1398: arp_util.debug('attribute2 : '||
1399: p_aah_rec.attribute2);
1400: arp_util.debug('attribute3 : '||
1401: p_aah_rec.attribute3);
1402: arp_util.debug('attribute4 : '||
1403: p_aah_rec.attribute4);
1404: arp_util.debug('attribute5 : '||
1405: p_aah_rec.attribute5);
1406: arp_util.debug('attribute6 : '||

Line 1404: arp_util.debug('attribute5 : '||

1400: arp_util.debug('attribute3 : '||
1401: p_aah_rec.attribute3);
1402: arp_util.debug('attribute4 : '||
1403: p_aah_rec.attribute4);
1404: arp_util.debug('attribute5 : '||
1405: p_aah_rec.attribute5);
1406: arp_util.debug('attribute6 : '||
1407: p_aah_rec.attribute6);
1408: arp_util.debug('attribute7 : '||

Line 1406: arp_util.debug('attribute6 : '||

1402: arp_util.debug('attribute4 : '||
1403: p_aah_rec.attribute4);
1404: arp_util.debug('attribute5 : '||
1405: p_aah_rec.attribute5);
1406: arp_util.debug('attribute6 : '||
1407: p_aah_rec.attribute6);
1408: arp_util.debug('attribute7 : '||
1409: p_aah_rec.attribute7);
1410: arp_util.debug('attribute8 : '||

Line 1408: arp_util.debug('attribute7 : '||

1404: arp_util.debug('attribute5 : '||
1405: p_aah_rec.attribute5);
1406: arp_util.debug('attribute6 : '||
1407: p_aah_rec.attribute6);
1408: arp_util.debug('attribute7 : '||
1409: p_aah_rec.attribute7);
1410: arp_util.debug('attribute8 : '||
1411: p_aah_rec.attribute8);
1412: arp_util.debug('attribute9 : '||

Line 1410: arp_util.debug('attribute8 : '||

1406: arp_util.debug('attribute6 : '||
1407: p_aah_rec.attribute6);
1408: arp_util.debug('attribute7 : '||
1409: p_aah_rec.attribute7);
1410: arp_util.debug('attribute8 : '||
1411: p_aah_rec.attribute8);
1412: arp_util.debug('attribute9 : '||
1413: p_aah_rec.attribute9);
1414: arp_util.debug('attribute10 : '||

Line 1412: arp_util.debug('attribute9 : '||

1408: arp_util.debug('attribute7 : '||
1409: p_aah_rec.attribute7);
1410: arp_util.debug('attribute8 : '||
1411: p_aah_rec.attribute8);
1412: arp_util.debug('attribute9 : '||
1413: p_aah_rec.attribute9);
1414: arp_util.debug('attribute10 : '||
1415: p_aah_rec.attribute10);
1416: arp_util.debug('attribute11 : '||

Line 1414: arp_util.debug('attribute10 : '||

1410: arp_util.debug('attribute8 : '||
1411: p_aah_rec.attribute8);
1412: arp_util.debug('attribute9 : '||
1413: p_aah_rec.attribute9);
1414: arp_util.debug('attribute10 : '||
1415: p_aah_rec.attribute10);
1416: arp_util.debug('attribute11 : '||
1417: p_aah_rec.attribute11);
1418: arp_util.debug('attribute12 : '||

Line 1416: arp_util.debug('attribute11 : '||

1412: arp_util.debug('attribute9 : '||
1413: p_aah_rec.attribute9);
1414: arp_util.debug('attribute10 : '||
1415: p_aah_rec.attribute10);
1416: arp_util.debug('attribute11 : '||
1417: p_aah_rec.attribute11);
1418: arp_util.debug('attribute12 : '||
1419: p_aah_rec.attribute12);
1420: arp_util.debug('attribute13 : '||

Line 1418: arp_util.debug('attribute12 : '||

1414: arp_util.debug('attribute10 : '||
1415: p_aah_rec.attribute10);
1416: arp_util.debug('attribute11 : '||
1417: p_aah_rec.attribute11);
1418: arp_util.debug('attribute12 : '||
1419: p_aah_rec.attribute12);
1420: arp_util.debug('attribute13 : '||
1421: p_aah_rec.attribute13);
1422: arp_util.debug('attribute14 : '||

Line 1420: arp_util.debug('attribute13 : '||

1416: arp_util.debug('attribute11 : '||
1417: p_aah_rec.attribute11);
1418: arp_util.debug('attribute12 : '||
1419: p_aah_rec.attribute12);
1420: arp_util.debug('attribute13 : '||
1421: p_aah_rec.attribute13);
1422: arp_util.debug('attribute14 : '||
1423: p_aah_rec.attribute14);
1424: arp_util.debug('attribute15 : '||

Line 1422: arp_util.debug('attribute14 : '||

1418: arp_util.debug('attribute12 : '||
1419: p_aah_rec.attribute12);
1420: arp_util.debug('attribute13 : '||
1421: p_aah_rec.attribute13);
1422: arp_util.debug('attribute14 : '||
1423: p_aah_rec.attribute14);
1424: arp_util.debug('attribute15 : '||
1425: p_aah_rec.attribute15);
1426:

Line 1424: arp_util.debug('attribute15 : '||

1420: arp_util.debug('attribute13 : '||
1421: p_aah_rec.attribute13);
1422: arp_util.debug('attribute14 : '||
1423: p_aah_rec.attribute14);
1424: arp_util.debug('attribute15 : '||
1425: p_aah_rec.attribute15);
1426:
1427: arp_util.debug('arp_aah_pkg.display_aah_rec()-');
1428:

Line 1427: arp_util.debug('arp_aah_pkg.display_aah_rec()-');

1423: p_aah_rec.attribute14);
1424: arp_util.debug('attribute15 : '||
1425: p_aah_rec.attribute15);
1426:
1427: arp_util.debug('arp_aah_pkg.display_aah_rec()-');
1428:
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_rec()');

Line 1431: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_rec()');

1427: arp_util.debug('arp_aah_pkg.display_aah_rec()-');
1428:
1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_rec()');
1432: RAISE;
1433: END;
1434:
1435: /*===========================================================================+

Line 1446: | arp_util.debug |

1442: | |
1443: | SCOPE - PUBLIC |
1444: | |
1445: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1446: | arp_util.debug |
1447: | |
1448: | ARGUMENTS : IN: |
1449: | p_approval_action_history_id |
1450: | OUT: |

Line 1467: arp_util.debug('arp_aah_pkg.display_aah_p()+');

1463: ar_approval_action_history.approval_action_history_id%type) IS
1464:
1465: l_aah_rec ar_approval_action_history%rowtype;
1466: BEGIN
1467: arp_util.debug('arp_aah_pkg.display_aah_p()+');
1468:
1469: arp_aah_pkg.fetch_p(l_aah_rec, p_approval_action_history_id);
1470:
1471: arp_aah_pkg.display_aah_rec(l_aah_rec);

Line 1473: arp_util.debug('arp_aah_pkg.display_aah_p()-');

1469: arp_aah_pkg.fetch_p(l_aah_rec, p_approval_action_history_id);
1470:
1471: arp_aah_pkg.display_aah_rec(l_aah_rec);
1472:
1473: arp_util.debug('arp_aah_pkg.display_aah_p()-');
1474:
1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_p()');

Line 1477: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_p()');

1473: arp_util.debug('arp_aah_pkg.display_aah_p()-');
1474:
1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_p()');
1478:
1479: arp_util.debug('');
1480: arp_util.debug('-------- parameters for display_aah_p() ------');
1481: arp_util.debug('p_approval_action_history_id = ' ||

Line 1479: arp_util.debug('');

1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_p()');
1478:
1479: arp_util.debug('');
1480: arp_util.debug('-------- parameters for display_aah_p() ------');
1481: arp_util.debug('p_approval_action_history_id = ' ||
1482: p_approval_action_history_id);
1483:

Line 1480: arp_util.debug('-------- parameters for display_aah_p() ------');

1476: WHEN OTHERS THEN
1477: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_p()');
1478:
1479: arp_util.debug('');
1480: arp_util.debug('-------- parameters for display_aah_p() ------');
1481: arp_util.debug('p_approval_action_history_id = ' ||
1482: p_approval_action_history_id);
1483:
1484: RAISE;

Line 1481: arp_util.debug('p_approval_action_history_id = ' ||

1477: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_p()');
1478:
1479: arp_util.debug('');
1480: arp_util.debug('-------- parameters for display_aah_p() ------');
1481: arp_util.debug('p_approval_action_history_id = ' ||
1482: p_approval_action_history_id);
1483:
1484: RAISE;
1485: END;

Line 1498: | arp_util.debug |

1494: | |
1495: | SCOPE - PUBLIC |
1496: | |
1497: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1498: | arp_util.debug |
1499: | |
1500: | ARGUMENTS : IN: |
1501: | p_adjustment_id |
1502: | OUT: |

Line 1529: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()+');

1525: ORDER BY approval_action_history_id;
1526:
1527: BEGIN
1528:
1529: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()+');
1530:
1531: arp_util.debug('=====================================================' ||
1532: '==========================');
1533: arp_util.debug('======= ' ||

Line 1531: arp_util.debug('=====================================================' ||

1527: BEGIN
1528:
1529: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()+');
1530:
1531: arp_util.debug('=====================================================' ||
1532: '==========================');
1533: arp_util.debug('======= ' ||
1534: ' Dump of ar_approval_action_history records for adj_id: '||
1535: to_char( p_adjustment_id ) || ' ' ||

Line 1533: arp_util.debug('======= ' ||

1529: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()+');
1530:
1531: arp_util.debug('=====================================================' ||
1532: '==========================');
1533: arp_util.debug('======= ' ||
1534: ' Dump of ar_approval_action_history records for adj_id: '||
1535: to_char( p_adjustment_id ) || ' ' ||
1536: '======');
1537:

Line 1542: arp_util.debug('==== End ' ||

1538: FOR l_aah_rec IN aah_cursor LOOP
1539: display_aah_p(l_aah_rec.approval_action_history_id);
1540: END LOOP;
1541:
1542: arp_util.debug('==== End ' ||
1543: ' Dump of ar_approval_action_history records for adj_id: '||
1544: to_char( p_adjustment_id ) || ' ' ||
1545: '=====');
1546: arp_util.debug('=====================================================' ||

Line 1546: arp_util.debug('=====================================================' ||

1542: arp_util.debug('==== End ' ||
1543: ' Dump of ar_approval_action_history records for adj_id: '||
1544: to_char( p_adjustment_id ) || ' ' ||
1545: '=====');
1546: arp_util.debug('=====================================================' ||
1547: '==========================');
1548:
1549: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()-');
1550:

Line 1549: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()-');

1545: '=====');
1546: arp_util.debug('=====================================================' ||
1547: '==========================');
1548:
1549: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()-');
1550:
1551: EXCEPTION
1552: WHEN OTHERS THEN
1553: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_f_adj_id()');

Line 1553: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_f_adj_id()');

1549: arp_util.debug('arp_aah_pkg.display_aah_f_adj_id()-');
1550:
1551: EXCEPTION
1552: WHEN OTHERS THEN
1553: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_f_adj_id()');
1554:
1555: arp_util.debug('');
1556: arp_util.debug('-------- parameters for display_aah_f_adj_id() ------');
1557: arp_util.debug('p_adjustment_id = ' ||

Line 1555: arp_util.debug('');

1551: EXCEPTION
1552: WHEN OTHERS THEN
1553: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_f_adj_id()');
1554:
1555: arp_util.debug('');
1556: arp_util.debug('-------- parameters for display_aah_f_adj_id() ------');
1557: arp_util.debug('p_adjustment_id = ' ||
1558: p_adjustment_id);
1559:

Line 1556: arp_util.debug('-------- parameters for display_aah_f_adj_id() ------');

1552: WHEN OTHERS THEN
1553: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_f_adj_id()');
1554:
1555: arp_util.debug('');
1556: arp_util.debug('-------- parameters for display_aah_f_adj_id() ------');
1557: arp_util.debug('p_adjustment_id = ' ||
1558: p_adjustment_id);
1559:
1560: RAISE;

Line 1557: arp_util.debug('p_adjustment_id = ' ||

1553: arp_util.debug('EXCEPTION: arp_aah_pkg.display_aah_f_adj_id()');
1554:
1555: arp_util.debug('');
1556: arp_util.debug('-------- parameters for display_aah_f_adj_id() ------');
1557: arp_util.debug('p_adjustment_id = ' ||
1558: p_adjustment_id);
1559:
1560: RAISE;
1561: