APPS.AR_PURGE dependencies on AR_ARCHIVE_HEADER

Line 595: -- Insert into AR_ARCHIVE_HEADER

591: RAISE ;
592: END get_ccid;
593: --
594: --
595: -- Insert into AR_ARCHIVE_HEADER
596: --
597: FUNCTION archive_header( p_customer_trx_id IN NUMBER ,
598: p_archive_id IN NUMBER) RETURN BOOLEAN IS
599: BEGIN

Line 1116: from ar_archive_header aah

1112: and ra1.status = 'APP'
1113: -- bug2859402 Don't insert duplicate cash record.
1114: and not exists (
1115: select 'already purged'
1116: from ar_archive_header aah
1117: where aah.transaction_id = cr.cash_receipt_id
1118: and aah.transaction_class = 'CASH' )
1119: GROUP BY cr.type, /* transaction_class */
1120: cr.cash_receipt_id, /* transaction_id */

Line 1191: INSERT INTO ar_archive_header

1187: l_period_name := get_period_name ( select_header.gl_date ) ;
1188:
1189: BEGIN
1190:
1191: INSERT INTO ar_archive_header
1192: ( archive_id,
1193: transaction_class,
1194: transaction_type,
1195: transaction_id,

Line 1468: print( 1, 'Failed while inserting into AR_ARCHIVE_HEADER') ;

1464: END IF ;
1465:
1466: EXCEPTION
1467: WHEN OTHERS THEN
1468: print( 1, 'Failed while inserting into AR_ARCHIVE_HEADER') ;
1469: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
1470: RAISE ;
1471: END ;
1472:

Line 1479: print( 1, ' ...Failed while inserting into AR_ARCHIVE_HEADER');

1475: RETURN ( TRUE );
1476:
1477: EXCEPTION
1478: WHEN OTHERS THEN
1479: print( 1, ' ...Failed while inserting into AR_ARCHIVE_HEADER');
1480: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
1481: RAISE ;
1482: END ;
1483: END ;

Line 2857: print( 0, ' ...Failed while inserting into AR_ARCHIVE_HEADER ');

2853:
2854: IF archive_header( p_customer_trx_id ,
2855: p_archive_id ) = FALSE
2856: THEN
2857: print( 0, ' ...Failed while inserting into AR_ARCHIVE_HEADER ');
2858: p_archive_status := FALSE ;
2859: END IF ;
2860:
2861: l_error_location := 'archive_detail' ;