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.15.12010000.2 2008/09/15 12:11:05 mgaleti 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 1153: arp_deduction.update_claim

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

Line 1305: arp_deduction.update_claim_create_status

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

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

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

Line 1358: arp_deduction.conc_req_log_msg

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

Line 1371: arp_deduction.conc_req_log_msg

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

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

1421:
1422: END IF; --IF p_matched_claim_creation_flag = 'Y' THEN
1423:
1424: IF PG_DEBUG in ('Y','C') THEN
1425: arp_standard.debug('ARP_DEDUCTION.claim_creation()-');
1426: END IF;
1427:
1428: EXCEPTION
1429: WHEN invalid_param THEN

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

1428: EXCEPTION
1429: WHEN invalid_param THEN
1430:
1431: IF PG_DEBUG in ('Y', 'C') THEN
1432: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CLAIM_CREATION');
1433: END IF;
1434: RAISE;
1435:
1436: WHEN OTHERS THEN

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

1435:
1436: WHEN OTHERS THEN
1437:
1438: IF PG_DEBUG in ('Y', 'C') THEN
1439: arp_standard.debug('EXCEPTION - OTHERS : ARP_DEDUCTION.CLAIM_CREATION');
1440: END IF;
1441: RAISE;
1442:
1443: END claim_creation;

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

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

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

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

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

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

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

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

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

1663:
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: IF PG_DEBUG in ('Y', 'C') THEN
1667: arp_standard.debug('update_action: EXCEPTION: arp_deduction.update_claim');
1668: END IF;
1669: RAISE;
1670:
1671: END update_claim;

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

1765:
1766: BEGIN
1767:
1768: IF PG_DEBUG in ('Y', 'C') THEN
1769: arp_standard.debug('arp_deduction.create_claims_rapp_dist()+' );
1770: END IF;
1771: x_return_status := FND_API.G_RET_STS_SUCCESS;
1772:
1773: IF PG_DEBUG in ('Y', 'C') THEN

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

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

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

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

Line 1961: arp_deduction.conc_req_log_msg

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

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

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

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

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

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

2042:
2043: BEGIN
2044:
2045: IF PG_DEBUG in ('Y', 'C') THEN
2046: arp_standard.debug('arp_deduction.claim_create_fail_recover()+' );
2047: END IF;
2048:
2049: IF PG_DEBUG in ('Y', 'C') THEN
2050: arp_standard.debug('p_rec_app_id = '||TO_CHAR(p_rapp_id));

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

2112: p_mode => 'SINGLE',
2113: p_key_value => ln_ra_id);
2114:
2115: IF PG_DEBUG in ('Y', 'C') THEN
2116: arp_standard.debug('arp_deduction.claim_create_fail_recover()-' );
2117: END IF;
2118:
2119: EXCEPTION
2120:

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

2119: EXCEPTION
2120:
2121: WHEN OTHERS THEN
2122: IF PG_DEBUG IN ('Y', 'C') THEN
2123: arp_standard.debug('EXCEPTION: arp_deduction.claim_create_fail_recover' );
2124: END IF;
2125: RAISE;
2126:
2127: END claim_create_fail_recover;

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

2172: EXCEPTION
2173: WHEN OTHERS THEN
2174:
2175: IF PG_DEBUG in ('Y', 'C') THEN
2176: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_FUNCTIONAL_CURRENCY');
2177: END IF;
2178: RETURN NULL;
2179:
2180: END GET_FUNCTIONAL_CURRENCY;

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

2213:
2214: BEGIN
2215:
2216: IF PG_DEBUG in ('Y', 'C') THEN
2217: arp_standard.debug('arp_deduction.GET_RECEIVABLES_TRX_ID()+' );
2218: END IF;
2219:
2220: SELECT rt.receivables_trx_id
2221: INTO l_receivables_trx_id

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

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

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

2235:
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: IF PG_DEBUG in ('Y', 'C') THEN
2239: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_RECEIVABLES_TRX_ID');
2240: END IF;
2241: RETURN NULL;
2242:
2243: END GET_RECEIVABLES_TRX_ID;

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

2286:
2287: EXCEPTION
2288: WHEN OTHERS THEN
2289: IF PG_DEBUG in ('Y', 'C') THEN
2290: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.UPDATE_CLAIM_CREATE_STATUS');
2291: END IF;
2292: RAISE;
2293:
2294: END UPDATE_CLAIM_CREATE_STATUS;

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

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

Line 2436: ('ARP_DEDUCTION.CHECK_APP_VIOLATE'

2432:
2433: ELSE --'Raise Invalid Arguments'
2434:
2435: APP_EXCEPTION.INVALID_ARGUMENT
2436: ('ARP_DEDUCTION.CHECK_APP_VIOLATE'
2437: ,'p_rapp_id'
2438: ,'NULL'
2439: );
2440:

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

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

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

2471: EXCEPTION
2472: WHEN invalid_param THEN
2473:
2474: IF PG_DEBUG in ('Y', 'C') THEN
2475: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.CHECK_APP_VIOLATE');
2476: END IF;
2477: RETURN(l_return);
2478:
2479: WHEN OTHERS THEN

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

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

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

2543: EXCEPTION
2544: WHEN OTHERS THEN
2545:
2546: IF PG_DEBUG in ('Y', 'C') THEN
2547: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_TM_ORACLE_REASON');
2548: END IF;
2549: RETURN NULL;
2550:
2551: END GET_TM_ORACLE_REASON;

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

2765:
2766: BEGIN
2767:
2768: IF PG_DEBUG in ('Y', 'C') THEN
2769: arp_standard.debug('update_action: arp_deduction.apply_open_receipt_cover()+');
2770: END IF;
2771:
2772: ---------------------------------------------------------------
2773: -- Fetch open_cash_receipt_id using applied_payment_schedule_id

Line 2795: ('ARP_DEDUCTION.APPLY_OPEN_RECEIPT_COVER'

2791: CLOSE get_open_cr_id;
2792:
2793: ELSE
2794: APP_EXCEPTION.INVALID_ARGUMENT
2795: ('ARP_DEDUCTION.APPLY_OPEN_RECEIPT_COVER'
2796: ,'P_APPLIED_PAYMENT_SCHEDULE_ID'
2797: ,'NULL'
2798: );
2799:

Line 2830: arp_deduction.conc_req_log_msg

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

Line 2851: arp_deduction.conc_req_log_msg

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

Line 2932: arp_deduction.conc_req_log_msg

2928: x_return_status := 'S';
2929:
2930: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2931: x_return_status := 'E';
2932: arp_deduction.conc_req_log_msg
2933: ('FAILURE - ERROR : Return status = E from API call apply_open_receipt');
2934:
2935: ELSE
2936: x_return_status := 'U';

Line 2937: arp_deduction.conc_req_log_msg

2933: ('FAILURE - ERROR : Return status = E from API call apply_open_receipt');
2934:
2935: ELSE
2936: x_return_status := 'U';
2937: arp_deduction.conc_req_log_msg
2938: ('FAILURE - UNIDENTIFIED : Return Status = U from API call apply_open_receipt');
2939:
2940: END IF; --IF l_return_status = FND_API.G_RET_STS_SUCCESS
2941:

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

2941:
2942: END IF; --IF l_process = 'Y' THEN
2943:
2944: IF PG_DEBUG in ('Y','C') THEN
2945: arp_standard.debug('update_action: ARP_DEDUCTION.apply_open_receipt_cover()-');
2946: END IF;
2947:
2948: EXCEPTION
2949: WHEN invalid_param THEN

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

2950:
2951: x_return_status := FND_API.G_RET_STS_ERROR;
2952:
2953: IF PG_DEBUG in ('Y','C') THEN
2954: arp_standard.debug('EXCEPTION - invalid_param : ARP_DEDUCTION.apply_open_receipt_cover()-');
2955: END IF;
2956:
2957: RAISE;
2958:

Line 2963: arp_deduction.conc_req_log_msg

2959: WHEN OTHERS THEN
2960:
2961: x_return_status := FND_API.G_RET_STS_ERROR;
2962:
2963: arp_deduction.conc_req_log_msg
2964: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');
2965: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
2966:
2967: RAISE;

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

2960:
2961: x_return_status := FND_API.G_RET_STS_ERROR;
2962:
2963: arp_deduction.conc_req_log_msg
2964: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');
2965: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
2966:
2967: RAISE;
2968:

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

2961: x_return_status := FND_API.G_RET_STS_ERROR;
2962:
2963: arp_deduction.conc_req_log_msg
2964: ('EXCEPTION - WHEN OTHERS : ARP_DEDUCTION.apply_open_receipt_cover()-');
2965: arp_deduction.conc_req_log_msg('SQLERRM='||substr(SQLERRM,1,255));
2966:
2967: RAISE;
2968:
2969: END apply_open_receipt_cover;

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

3013: EXCEPTION
3014: WHEN OTHERS THEN
3015:
3016: IF PG_DEBUG in ('Y', 'C') THEN
3017: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.GET_ACTIVE_CLAIM_FLAG');
3018: END IF;
3019: RETURN NULL;
3020:
3021: END GET_ACTIVE_CLAIM_FLAG;

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

3052: EXCEPTION
3053: WHEN NO_DATA_FOUND THEN
3054:
3055: IF PG_DEBUG in ('Y', 'C') THEN
3056: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3057: END IF;
3058: RAISE;
3059:
3060: WHEN OTHERS THEN

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

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

Line 3067: END ARP_DEDUCTION;

3063: arp_standard.debug('EXCEPTION: ARP_DEDUCTION.INITIALIZE');
3064: END IF;
3065: RAISE;
3066:
3067: END ARP_DEDUCTION;