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_DEDUCTION dependencies on ARP_DEDUCTION

Line 1: PACKAGE BODY ARP_DEDUCTION AS

1: PACKAGE BODY ARP_DEDUCTION AS
2: /* $Header: ARXLDEDB.pls 120.19.12020000.2 2012/07/26 07:44:30 ashlkuma ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 59: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM');

55:
56: WHEN OTHERS THEN
57:
58: IF PG_DEBUG in ('Y','C') THEN
59: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM');
60: END IF;
61: RETURN FALSE;
62:
63: END CHECK_TM;

Line 113: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM_DEFAULT_SETUP');

109:
110: WHEN OTHERS THEN
111:
112: IF PG_DEBUG in ('Y','C') THEN
113: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_TM_DEFAULT_SETUP');
114: END IF;
115: RETURN FALSE;
116:
117: END CHECK_TM_DEFAULT_SETUP;

Line 524: arp_standard.debug('ARP_DEDUCTION.claim_creation()+');

520:
521: BEGIN
522:
523: IF PG_DEBUG in ('Y','C') THEN
524: arp_standard.debug('ARP_DEDUCTION.claim_creation()+');
525: END IF;
526:
527: IF (p_request_id IS NULL) THEN
528:

Line 530: ('ARP_DEDUCTION.CLAIM_CREATION'

526:
527: IF (p_request_id IS NULL) THEN
528:
529: APP_EXCEPTION.INVALID_ARGUMENT
530: ('ARP_DEDUCTION.CLAIM_CREATION'
531: ,'P_REQUEST_ID'
532: ,'NULL'
533: );
534:

Line 742: arp_standard.debug('arp_deduction.claim_creation: Fetch amount_aplied from '

738: -- Amount applied from initial UNAPP record for the receipt
739: -- Used in the determination of full or partial recovery
740: ------------------------------------------------------------------
741: IF PG_DEBUG in ('Y','C') THEN
742: arp_standard.debug('arp_deduction.claim_creation: Fetch amount_aplied from '
743: ||'first UNAPP record for the receipt - Fail Recover');
744: END IF;
745: OPEN unapp_amt_rec(l_cash_receipt_id);
746: FETCH unapp_amt_rec into l_unapp_amt_appl;

Line 754: arp_standard.debug('arp_deduction.claim_creation: Fetch Sum amount_aplied '

750: -- SUM(Amount applied) from the Paired UNAPP records for the receipt
751: -- Used in the determination of full or partial recovery
752: ------------------------------------------------------------------
753: IF PG_DEBUG in ('Y','C') THEN
754: arp_standard.debug('arp_deduction.claim_creation: Fetch Sum amount_aplied '
755: ||'from the paired UNAPP records for the receipt - Fail Recover');
756: END IF;
757: OPEN pair_unapp_amt_rec(l_cash_receipt_id);
758: FETCH pair_unapp_amt_rec into l_sum_pair_unapp_amt_appl;

Line 773: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in Partial');

769: -------------------------------------------------------------
770: -- Claim creation in TM failed. Initiate Partial recovery process
771: -------------------------------------------------------------
772: IF PG_DEBUG in ('Y','C') THEN
773: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in Partial');
774: END IF;
775: arp_deduction.claim_create_fail_recover
776: (p_rapp_id => claim_tbl.receivable_application_id(i)
777: ,p_cr_id => l_cash_receipt_id

Line 775: arp_deduction.claim_create_fail_recover

771: -------------------------------------------------------------
772: IF PG_DEBUG in ('Y','C') THEN
773: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in Partial');
774: END IF;
775: arp_deduction.claim_create_fail_recover
776: (p_rapp_id => claim_tbl.receivable_application_id(i)
777: ,p_cr_id => l_cash_receipt_id
778: );
779:

Line 783: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in FULL');

779:
780: ELSE -- Full Reversal
781:
782: IF PG_DEBUG in ('Y','C') THEN
783: arp_standard.debug('arp_deduction.claim_creation: Fail Recover in FULL');
784: END IF;
785: FOR l_fail_rec in fail_rec_rapp_id(l_cash_receipt_id)
786: LOOP
787:

Line 791: arp_deduction.claim_create_fail_recover

787:
788: -------------------------------------------------------------
789: -- Claim creation in TM failed. Initiate full recovery process
790: -------------------------------------------------------------
791: arp_deduction.claim_create_fail_recover
792: (p_rapp_id => l_fail_rec.receivable_application_id
793: ,p_cr_id => l_cash_receipt_id
794: );
795:

Line 821: arp_deduction.conc_req_log_msg

817:
818: --------------------------------------------------
819: -- Write Failure Message to Concurrent Request Log
820: --------------------------------------------------
821: arp_deduction.conc_req_log_msg
822: ('Claim Investigation - Creation Failure '
823: ||' RAPP ID = '||claim_tbl.receivable_application_id(i)
824: ||' Receipt Number = '||l_receipt_number
825: ||' PS ID = '||to_char(claim_tbl.payment_schedule_id(i))

Line 835: arp_deduction.update_claim_create_status

831: l_claim_status := 'Y';
832: ---------------------------------------------------------
833: -- Update AR_PAYMENT_SCHEDULES.ACTIVE_CLAIM appropriately
834: ---------------------------------------------------------
835: arp_deduction.update_claim_create_status
836: (p_ps_id => claim_tbl.payment_schedule_id(i)
837: ,p_claim_status => l_claim_status
838: );
839:

Line 1157: arp_deduction.update_claim

1153: ---------------------------------------------------------
1154: IF PG_DEBUG in ('Y','C') THEN
1155: arp_standard.debug('Call Subsequent Receipt API. Open Claim exist in TM');
1156: END IF;
1157: arp_deduction.update_claim
1158: (p_claim_id => claim_rec.secondary_application_ref_id
1159: ,p_claim_number => claim_rec.application_ref_num
1160: ,p_amount => l_claim_amount
1161: ,p_currency_code => l_currency_code

Line 1309: arp_deduction.update_claim_create_status

1305:
1306: IF PG_DEBUG in ('Y','C') THEN
1307: arp_standard.debug('Update PS with active_claim_flag = C');
1308: END IF;
1309: arp_deduction.update_claim_create_status
1310: (p_ps_id => claim_rec.applied_payment_schedule_id
1311: ,p_claim_status => l_claim_status
1312: );
1313:

Line 1331: ,receivables_trx_id = ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID(l_cash_receipt_id)

1327: UPDATE ar_receivable_applications
1328: SET secondary_application_ref_id = claim_rec.secondary_application_ref_id
1329: ,application_ref_num = claim_rec.application_ref_num
1330: ,application_ref_type = 'CLAIM'
1331: ,receivables_trx_id = ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID(l_cash_receipt_id)
1332: WHERE applied_payment_schedule_id = claim_rec.applied_payment_schedule_id
1333: AND applied_customer_trx_id = claim_rec.applied_customer_trx_id;
1334:
1335: END IF; --IF l_trx_claim_type = 'S' AND l_trx_claim_exist = 'N' THEN

Line 1362: arp_deduction.conc_req_log_msg

1358: IF l_trx_claim_type = 'S' AND l_trx_claim_exist = 'N' THEN
1359: ---------------------------------------
1360: -- Specific to Short Pay Claim Creation
1361: ---------------------------------------
1362: arp_deduction.conc_req_log_msg
1363: ('Short Pay Claim Creation Failure - '
1364: ||' Receipt Number = '||l_receipt_number
1365: ||' Applied Payment Schedule ID = '
1366: ||to_char(claim_rec.applied_payment_schedule_id)

Line 1375: arp_deduction.conc_req_log_msg

1371: ELSIF l_trx_claim_exist = 'Y' THEN
1372: ---------------------------------------------
1373: -- Specific to Subsequent Receipt Application
1374: ---------------------------------------------
1375: arp_deduction.conc_req_log_msg
1376: ('Subsequent Receipt Application Failure - '
1377: ||' Receipt Number = '||l_receipt_number
1378: ||' Receipt ID = '||l_cash_receipt_id
1379: ||' Claim ID = '||to_char(claim_rec.secondary_application_ref_id)

Line 1429: arp_standard.debug('ARP_DEDUCTION.claim_creation()-');

1425:
1426: END IF; --IF p_matched_claim_creation_flag = 'Y' THEN
1427:
1428: IF PG_DEBUG in ('Y','C') THEN
1429: arp_standard.debug('ARP_DEDUCTION.claim_creation()-');
1430: END IF;
1431:
1432: EXCEPTION
1433: WHEN invalid_param THEN

Line 1436: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CLAIM_CREATION');

1432: EXCEPTION
1433: WHEN invalid_param THEN
1434:
1435: IF PG_DEBUG in ('Y', 'C') THEN
1436: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CLAIM_CREATION');
1437: END IF;
1438: RAISE;
1439:
1440: WHEN OTHERS THEN

Line 1443: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CLAIM_CREATION');

1439:
1440: WHEN OTHERS THEN
1441:
1442: IF PG_DEBUG in ('Y', 'C') THEN
1443: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CLAIM_CREATION');
1444: END IF;
1445: RAISE;
1446:
1447: END claim_creation;

Line 1536: arp_standard.debug('update_action: ' || 'arp_deduction.update_claim()+' );

1532:
1533: BEGIN
1534:
1535: IF PG_DEBUG in ('Y', 'C') THEN
1536: arp_standard.debug('update_action: ' || 'arp_deduction.update_claim()+' );
1537: END IF;
1538:
1539: x_return_status := 'S';
1540: l_claim_rec.claim_id := p_claim_id;

Line 1614: arp_standard.debug('insert_trx_notes: arp_deduction.update_claim');

1610: --------------------
1611: -- Insert Trx Notes
1612: --------------------
1613: IF PG_DEBUG in ('Y', 'C') THEN
1614: arp_standard.debug('insert_trx_notes: arp_deduction.update_claim');
1615: END IF;
1616:
1617: l_text := 'RECEIPT_NUM : '||p_receipt_number||' CLAIM_NUM : '
1618: ||p_claim_number||' TRX_NUM : '||p_trx_number;

Line 1646: arp_standard.debug('put_trx_in_dispute: arp_deduction.update_claim');

1642: --
1643: -- Update TRX Amount in Dispute
1644: --
1645: IF PG_DEBUG in ('Y', 'C') THEN
1646: arp_standard.debug('put_trx_in_dispute: arp_deduction.update_claim');
1647: END IF;
1648: arp_process_application.update_dispute_on_trx
1649: (p_invoice_ps_id
1650: ,'Y' --p_active_claim

Line 1665: arp_standard.debug('update_action: arp_deduction.update_claim()-');

1661:
1662: END IF; --IF l_return_status = FND_API.G_RET_STS_SUCCESS
1663:
1664: IF PG_DEBUG in ('Y', 'C') THEN
1665: arp_standard.debug('update_action: arp_deduction.update_claim()-');
1666: END IF;
1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN

Line 1671: arp_standard.debug('update_action: EXCEPTION: arp_deduction.update_claim');

1667:
1668: EXCEPTION
1669: WHEN OTHERS THEN
1670: IF PG_DEBUG in ('Y', 'C') THEN
1671: arp_standard.debug('update_action: EXCEPTION: arp_deduction.update_claim');
1672: END IF;
1673: RAISE;
1674:
1675: END update_claim;

Line 1773: arp_standard.debug('arp_deduction.create_claims_rapp_dist()+' );

1769:
1770: BEGIN
1771:
1772: IF PG_DEBUG in ('Y', 'C') THEN
1773: arp_standard.debug('arp_deduction.create_claims_rapp_dist()+' );
1774: END IF;
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;
1776:
1777: IF PG_DEBUG in ('Y', 'C') THEN

Line 1954: arp_standard.debug('arp_deduction.create_claims_rapp_dist()-' );

1950: l_ae_doc_rec.other_flag := 'PAIR';
1951: arp_acct_main.Create_Acct_Entry(l_ae_doc_rec);
1952:
1953: IF PG_DEBUG in ('Y', 'C') THEN
1954: arp_standard.debug('arp_deduction.create_claims_rapp_dist()-' );
1955: END IF;
1956:
1957: EXCEPTION
1958: WHEN OTHERS THEN

Line 1961: arp_standard.debug('EXCEPTION: arp_deduction.create_claims_rapp_dist()-');

1957: EXCEPTION
1958: WHEN OTHERS THEN
1959:
1960: IF PG_DEBUG in ('Y', 'C') THEN
1961: arp_standard.debug('EXCEPTION: arp_deduction.create_claims_rapp_dist()-');
1962: END IF;
1963:
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: arp_deduction.conc_req_log_msg

Line 1965: arp_deduction.conc_req_log_msg

1961: arp_standard.debug('EXCEPTION: arp_deduction.create_claims_rapp_dist()-');
1962: END IF;
1963:
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: arp_deduction.conc_req_log_msg
1966: ('EXCEPTION: arp_deduction.create_claims_rapp_dist'||
1967: ' STATUS='||p_status||
1968: ' CCID='||to_char(l_ra_rec.code_combination_id)||
1969: ' Cash_Receipt_ID='||to_char(l_ra_rec.cash_receipt_id)||

Line 1966: ('EXCEPTION: arp_deduction.create_claims_rapp_dist'||

1962: END IF;
1963:
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: arp_deduction.conc_req_log_msg
1966: ('EXCEPTION: arp_deduction.create_claims_rapp_dist'||
1967: ' STATUS='||p_status||
1968: ' CCID='||to_char(l_ra_rec.code_combination_id)||
1969: ' Cash_Receipt_ID='||to_char(l_ra_rec.cash_receipt_id)||
1970: ' Payment Schedule_ID='||to_char(l_ra_rec.payment_schedule_id)

Line 1972: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));

1968: ' CCID='||to_char(l_ra_rec.code_combination_id)||
1969: ' Cash_Receipt_ID='||to_char(l_ra_rec.cash_receipt_id)||
1970: ' Payment Schedule_ID='||to_char(l_ra_rec.payment_schedule_id)
1971: );
1972: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
1973:
1974: RAISE;
1975:
1976: END create_claims_rapp_dist;

Line 2050: arp_standard.debug('arp_deduction.claim_create_fail_recover()+' );

2046:
2047: BEGIN
2048:
2049: IF PG_DEBUG in ('Y', 'C') THEN
2050: arp_standard.debug('arp_deduction.claim_create_fail_recover()+' );
2051: END IF;
2052:
2053: IF PG_DEBUG in ('Y', 'C') THEN
2054: arp_standard.debug('p_rec_app_id = '||TO_CHAR(p_rapp_id));

Line 2120: arp_standard.debug('arp_deduction.claim_create_fail_recover()-' );

2116: p_mode => 'SINGLE',
2117: p_key_value => ln_ra_id);
2118:
2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_standard.debug('arp_deduction.claim_create_fail_recover()-' );
2121: END IF;
2122:
2123: EXCEPTION
2124:

Line 2127: arp_standard.debug('EXCEPTION: arp_deduction.claim_create_fail_recover' );

2123: EXCEPTION
2124:
2125: WHEN OTHERS THEN
2126: IF PG_DEBUG IN ('Y', 'C') THEN
2127: arp_standard.debug('EXCEPTION: arp_deduction.claim_create_fail_recover' );
2128: END IF;
2129: RAISE;
2130:
2131: END claim_create_fail_recover;

Line 2180: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_FUNCTIONAL_CURRENCY');

2176: EXCEPTION
2177: WHEN OTHERS THEN
2178:
2179: IF PG_DEBUG in ('Y', 'C') THEN
2180: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_FUNCTIONAL_CURRENCY');
2181: END IF;
2182: RETURN NULL;
2183:
2184: END GET_FUNCTIONAL_CURRENCY;

Line 2221: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()+' );

2217:
2218: BEGIN
2219:
2220: IF PG_DEBUG in ('Y', 'C') THEN
2221: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()+' );
2222: END IF;
2223:
2224: SELECT rt.receivables_trx_id
2225: INTO l_receivables_trx_id

Line 2235: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()-' );

2231: AND cr.cash_receipt_id = p_cash_receipt_id
2232: AND rma.primary_flag = 'Y' );
2233:
2234: IF PG_DEBUG in ('Y', 'C') THEN
2235: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()-' );
2236: END IF;
2237:
2238: RETURN l_receivables_trx_id;
2239:

Line 2243: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID');

2239:
2240: EXCEPTION
2241: WHEN OTHERS THEN
2242: IF PG_DEBUG in ('Y', 'C') THEN
2243: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID');
2244: END IF;
2245: RETURN NULL;
2246:
2247: END GET_RECEIVABLES_TRX_ID;

Line 2294: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.UPDATE_CLAIM_CREATE_STATUS');

2290:
2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: IF PG_DEBUG in ('Y', 'C') THEN
2294: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.UPDATE_CLAIM_CREATE_STATUS');
2295: END IF;
2296: RAISE;
2297:
2298: END UPDATE_CLAIM_CREATE_STATUS;

Line 2419: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()+' );

2415:
2416: BEGIN
2417:
2418: IF PG_DEBUG in ('Y', 'C') THEN
2419: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()+' );
2420: END IF;
2421:
2422: IF (p_rapp_id IS NOT NULL) AND (p_cr_id IS NOT NULL) THEN --'On Account'
2423:

Line 2440: ('ARP_DEDUCTION.CHECK_APP_VIOLATE'

2436:
2437: ELSE --'Raise Invalid Arguments'
2438:
2439: APP_EXCEPTION.INVALID_ARGUMENT
2440: ('ARP_DEDUCTION.CHECK_APP_VIOLATE'
2441: ,'p_rapp_id'
2442: ,'NULL'
2443: );
2444:

Line 2470: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()-' );

2466:
2467: END IF; -- IF ( SIGN(ln_amount_applied * -1) = SIGN(p_amount) )
2468:
2469: IF PG_DEBUG in ('Y', 'C') THEN
2470: arp_standard.debug('arp_deduction.CHECK_APP_VIOLATE()-' );
2471: END IF;
2472:
2473: RETURN (l_return);
2474:

Line 2479: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CHECK_APP_VIOLATE');

2475: EXCEPTION
2476: WHEN invalid_param THEN
2477:
2478: IF PG_DEBUG in ('Y', 'C') THEN
2479: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CHECK_APP_VIOLATE');
2480: END IF;
2481: RETURN(l_return);
2482:
2483: WHEN OTHERS THEN

Line 2486: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_APP_VIOLATE');

2482:
2483: WHEN OTHERS THEN
2484:
2485: IF PG_DEBUG in ('Y', 'C') THEN
2486: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CHECK_APP_VIOLATE');
2487: END IF;
2488: RETURN(l_return);
2489:
2490: END CHECK_APP_VIOLATE;

Line 2552: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_TM_ORACLE_REASON');

2548: EXCEPTION
2549: WHEN OTHERS THEN
2550:
2551: IF PG_DEBUG in ('Y', 'C') THEN
2552: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_TM_ORACLE_REASON');
2553: END IF;
2554: RETURN NULL;
2555:
2556: END GET_TM_ORACLE_REASON;

Line 2774: arp_standard.debug('update_action: arp_deduction.apply_open_receipt_cover()+');

2770:
2771: BEGIN
2772:
2773: IF PG_DEBUG in ('Y', 'C') THEN
2774: arp_standard.debug('update_action: arp_deduction.apply_open_receipt_cover()+');
2775: END IF;
2776:
2777: ---------------------------------------------------------------
2778: -- Fetch open_cash_receipt_id using applied_payment_schedule_id

Line 2800: ('ARP_DEDUCTION.APPLY_OPEN_RECEIPT_COVER'

2796: CLOSE get_open_cr_id;
2797:
2798: ELSE
2799: APP_EXCEPTION.INVALID_ARGUMENT
2800: ('ARP_DEDUCTION.APPLY_OPEN_RECEIPT_COVER'
2801: ,'P_APPLIED_PAYMENT_SCHEDULE_ID'
2802: ,'NULL'
2803: );
2804:

Line 2835: arp_deduction.conc_req_log_msg

2831:
2832: x_return_status := FND_API.G_RET_STS_ERROR;
2833: l_process := 'N';
2834:
2835: arp_deduction.conc_req_log_msg
2836: ('Failed Validation : display<>Y for the application. No Call will be '
2837: ||' initiated for receipt API - apply_open_receipt'
2838: ||' Receivable Application id = '||to_char(p_open_rec_app_id)
2839: ||' Cash Receipt id = '||to_char(l_open_cash_receipt_id));

Line 2856: arp_deduction.conc_req_log_msg

2852:
2853: x_return_status := FND_API.G_RET_STS_ERROR;
2854: l_process := 'N';
2855:
2856: arp_deduction.conc_req_log_msg
2857: ('Failed Validation : sum(amount_applied) is less than apply_amount for '
2858: ||' UNAPP. No call will be initiated for receipt API - apply_open_receipt'
2859: ||' Cash Receipt ID = '||to_char(l_open_cash_receipt_id));
2860:

Line 2937: arp_deduction.conc_req_log_msg

2933: x_return_status := 'S';
2934:
2935: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2936: x_return_status := 'E';
2937: arp_deduction.conc_req_log_msg
2938: ('FAILURE - ERROR : Return status = E from API call apply_open_receipt');
2939:
2940: ELSE
2941: x_return_status := 'U';

Line 2942: arp_deduction.conc_req_log_msg

2938: ('FAILURE - ERROR : Return status = E from API call apply_open_receipt');
2939:
2940: ELSE
2941: x_return_status := 'U';
2942: arp_deduction.conc_req_log_msg
2943: ('FAILURE - UNIDENTIFIED : Return Status = U from API call apply_open_receipt');
2944:
2945: END IF; --IF l_return_status = FND_API.G_RET_STS_SUCCESS
2946:

Line 2950: arp_standard.debug('update_action: ARP_DEDUCTION.apply_open_receipt_cover()-');

2946:
2947: END IF; --IF l_process = 'Y' THEN
2948:
2949: IF PG_DEBUG in ('Y','C') THEN
2950: arp_standard.debug('update_action: ARP_DEDUCTION.apply_open_receipt_cover()-');
2951: END IF;
2952:
2953: EXCEPTION
2954: WHEN invalid_param THEN

Line 2959: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.apply_open_receipt_cover()-');

2955:
2956: x_return_status := FND_API.G_RET_STS_ERROR;
2957:
2958: IF PG_DEBUG in ('Y','C') THEN
2959: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.apply_open_receipt_cover()-');
2960: END IF;
2961:
2962: RAISE;
2963:

Line 2968: arp_deduction.conc_req_log_msg

2964: WHEN OTHERS THEN
2965:
2966: x_return_status := FND_API.G_RET_STS_ERROR;
2967:
2968: arp_deduction.conc_req_log_msg
2969: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');
2970: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
2971:
2972: RAISE;

Line 2969: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');

2965:
2966: x_return_status := FND_API.G_RET_STS_ERROR;
2967:
2968: arp_deduction.conc_req_log_msg
2969: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');
2970: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
2971:
2972: RAISE;
2973:

Line 2970: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));

2966: x_return_status := FND_API.G_RET_STS_ERROR;
2967:
2968: arp_deduction.conc_req_log_msg
2969: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');
2970: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
2971:
2972: RAISE;
2973:
2974: END apply_open_receipt_cover;

Line 3022: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_ACTIVE_CLAIM_FLAG');

3018: EXCEPTION
3019: WHEN OTHERS THEN
3020:
3021: IF PG_DEBUG in ('Y', 'C') THEN
3022: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_ACTIVE_CLAIM_FLAG');
3023: END IF;
3024: RETURN NULL;
3025:
3026: END GET_ACTIVE_CLAIM_FLAG;

Line 3061: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');

3057: EXCEPTION
3058: WHEN NO_DATA_FOUND THEN
3059:
3060: IF PG_DEBUG in ('Y', 'C') THEN
3061: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3062: END IF;
3063: RAISE;
3064:
3065: WHEN OTHERS THEN

Line 3068: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');

3064:
3065: WHEN OTHERS THEN
3066:
3067: IF PG_DEBUG in ('Y', 'C') THEN
3068: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3069: END IF;
3070: RAISE;
3071:
3072: END ARP_DEDUCTION;

Line 3072: END ARP_DEDUCTION;

3068: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3069: END IF;
3070: RAISE;
3071:
3072: END ARP_DEDUCTION;