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_AAH_PKG

Line 1: PACKAGE BODY ARP_AAH_PKG AS

1: PACKAGE BODY ARP_AAH_PKG AS
2: /* $Header: ARTIAAHB.pls 120.5 2005/10/30 04:27:15 appldev ship $ */
3:
4: /*--------------------------------------------------------+
5: | Dummy constants for use in update and lock operations |

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 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 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 410: arp_aah_pkg.construct_aah_update_stmt(l_update_statement);

406: /*---------------------------------+
407: | Construct the update statement |
408: +---------------------------------*/
409:
410: arp_aah_pkg.construct_aah_update_stmt(l_update_statement);
411:
412: l_update_statement := l_update_statement || p_where_clause;
413:
414: /*-----------------------------------------------+

Line 424: arp_aah_pkg.bind_aah_variables(p_update_cursor, p_aah_rec);

420: dbms_sql.v7);
421:
422: end if;
423:
424: arp_aah_pkg.bind_aah_variables(p_update_cursor, p_aah_rec);
425:
426: /*-----------------------------------------+
427: | Bind the variables in the where clause |
428: +-----------------------------------------*/

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 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 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 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 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 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 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 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 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 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 1143: arp_aah_pkg.generic_update( pg_cursor1,

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',
1145: p_approval_action_history_id,
1146: p_aah_rec);
1147:

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 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 1199: arp_aah_pkg.generic_update( pg_cursor2,

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',
1201: p_adjustment_id,
1202: p_aah_rec);
1203:

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 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 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 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 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 1469: arp_aah_pkg.fetch_p(l_aah_rec, p_approval_action_history_id);

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);
1472:
1473: arp_util.debug('arp_aah_pkg.display_aah_p()-');

Line 1471: arp_aah_pkg.display_aah_rec(l_aah_rec);

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);
1472:
1473: arp_util.debug('arp_aah_pkg.display_aah_p()-');
1474:
1475: EXCEPTION

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 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 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 1578: END ARP_AAH_PKG;

1574: pg_prog_appl_id := fnd_global.prog_appl_id;
1575: pg_conc_program_id := fnd_global.conc_program_id;
1576:
1577:
1578: END ARP_AAH_PKG;