APPS.AR_PURGE dependencies on AR_ARCHIVE_HEADER

Line 784: select /*+ index(aah ar_archive_header_n1) */ 'already purged'

780: and ra1.cash_receipt_id = cp_cash_receipt_id
781: and ra1.status = 'APP'
782: -- bug2859402 Don't insert duplicate cash record.
783: and not exists (
784: select /*+ index(aah ar_archive_header_n1) */ 'already purged'
785: from ar_archive_header aah
786: where aah.transaction_id = cr.cash_receipt_id
787: and aah.transaction_class = 'CASH' )
788: AND cp_archive_level <>'N'

Line 785: from ar_archive_header aah

781: and ra1.status = 'APP'
782: -- bug2859402 Don't insert duplicate cash record.
783: and not exists (
784: select /*+ index(aah ar_archive_header_n1) */ 'already purged'
785: from ar_archive_header aah
786: where aah.transaction_id = cr.cash_receipt_id
787: and aah.transaction_class = 'CASH' )
788: AND cp_archive_level <>'N'
789: GROUP BY cr.type, /* transaction_class */

Line 990: INSERT INTO ar_archive_header

986: l_period_name := get_period_name ( select_header.gl_date ) ;
987:
988: BEGIN
989:
990: INSERT INTO ar_archive_header
991: ( archive_id,
992: transaction_class,
993: transaction_type,
994: transaction_id,

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

1263: END IF ;
1264:
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: print( 1, 'Failed while inserting into AR_ARCHIVE_HEADER') ;
1268: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
1269: RAISE ;
1270: END ;
1271:

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

1500: RETURN ( TRUE );
1501:
1502: EXCEPTION
1503: WHEN OTHERS THEN
1504: print( 1, ' ...Failed while inserting into AR_ARCHIVE_HEADER');
1505: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
1506: RAISE ;
1507: END ;
1508: END ;

Line 1512: -- Insert into AR_ARCHIVE_HEADER

1508: END ;
1509:
1510: --
1511: --
1512: -- Insert into AR_ARCHIVE_HEADER
1513: --
1514: FUNCTION archive_header( p_customer_trx_id IN NUMBER ,
1515: p_archive_id IN NUMBER) RETURN BOOLEAN IS
1516: BEGIN

Line 2033: from ar_archive_header aah

2029: and ra1.status = 'APP'
2030: -- bug2859402 Don't insert duplicate cash record.
2031: and not exists (
2032: select 'already purged'
2033: from ar_archive_header aah
2034: where aah.transaction_id = cr.cash_receipt_id
2035: and aah.transaction_class = 'CASH' )
2036: GROUP BY cr.type, /* transaction_class */
2037: cr.cash_receipt_id, /* transaction_id */

Line 2108: INSERT INTO ar_archive_header

2104: l_period_name := get_period_name ( select_header.gl_date ) ;
2105:
2106: BEGIN
2107:
2108: INSERT INTO ar_archive_header
2109: ( archive_id,
2110: transaction_class,
2111: transaction_type,
2112: transaction_id,

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

2381: END IF ;
2382:
2383: EXCEPTION
2384: WHEN OTHERS THEN
2385: print( 1, 'Failed while inserting into AR_ARCHIVE_HEADER') ;
2386: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
2387: RAISE ;
2388: END ;
2389:

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

2392: RETURN ( TRUE );
2393:
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: print( 1, ' ...Failed while inserting into AR_ARCHIVE_HEADER');
2397: print( 1, 'sqlcode = ' || SQLCODE || SQLERRM ) ;
2398: RAISE ;
2399: END ;
2400: END ;

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

3770:
3771: IF archive_header( p_customer_trx_id ,
3772: p_archive_id ) = FALSE
3773: THEN
3774: print( 0, ' ...Failed while inserting into AR_ARCHIVE_HEADER ');
3775: p_archive_status := FALSE ;
3776: END IF ;
3777:
3778: l_error_location := 'archive_detail' ;