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.

[Home] [Help]

APPS.ARP_PROCESS_DET_PKG dependencies on FND_API

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
617: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_customer_trx_cache
618: Please verify if initialization has been successfully' );
619: FND_MSG_PUB.ADD;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: arp_standard.debug
622: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
623: WHEN no_installed_inv_allowed THEN
624: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

Line 628: x_return_status := FND_API.G_RET_STS_ERROR;

624: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
625: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_installed_inv_allowed customer_trx_id:'
626: ||g_customer_trx.customer_trx_id);
627: FND_MSG_PUB.ADD;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: arp_standard.debug
630: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
631: WHEN no_op_trx_pay_schedule THEN
632: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

Line 636: x_return_status := FND_API.G_RET_STS_ERROR;

632: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
633: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_open_trx_pay_schedule customer_trx_id:'
634: ||g_customer_trx.customer_trx_id);
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: arp_standard.debug
638: ('EXCEPTION get_inv_ps no_op_trx_pay_schedule customer_trx_id '||g_customer_trx.customer_trx_id);
639: WHEN OTHERS THEN
640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: WHEN OTHERS THEN
640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
641: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-'||SQLERRM);
642: FND_MSG_PUB.ADD;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: arp_standard.debug('EXCEPTION get_inv_ps OTHERS '||SQLERRM);
645: END get_inv_ps;
646:
647:

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: WHEN no_op_rec_pay_schedule THEN
681: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
682: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps no_open_rec_pay_schedule' );
683: FND_MSG_PUB.ADD;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: arp_standard.debug
686: ('EXCEPTION get_rec_ps no_op_rec_pay_schedule p_cr_id '||p_cr_id);
687: WHEN OTHERS THEN
688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

Line 691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

687: WHEN OTHERS THEN
688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
689: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps:'||SQLERRM );
690: FND_MSG_PUB.ADD;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: arp_standard.debug
693: ('EXCEPTION get_rec_ps OTHERS '||SQLERRM);
694: END get_rec_ps;
695:

Line 1070: x_return_status := FND_API.G_RET_STS_ERROR;

1066: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1067: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge applied amt is negative');
1068: END IF;
1069: FND_MSG_PUB.ADD;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: WHEN neg_earned_amt THEN
1072: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1073: IF l_earned_concern = 'PBLINENEG' THEN
1074: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line earned amt is negative');

Line 1083: x_return_status := FND_API.G_RET_STS_ERROR;

1079: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1080: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge earned amt is negative');
1081: END IF;
1082: FND_MSG_PUB.ADD;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: WHEN neg_unearned_amt THEN
1085: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1086: IF l_earned_concern = 'PBLINENEG' THEN
1087: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line unearned amt is negative');

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1093: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge unearned amt is negative');
1094: END IF;
1095: FND_MSG_PUB.ADD;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1099: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-'||SQLERRM );
1100: FND_MSG_PUB.ADD;

Line 1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1099: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-'||SQLERRM );
1100: FND_MSG_PUB.ADD;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: arp_util.debug('EXCEPTION OTHERS arp_process_det_pkg.upd_inv_ps:'||SQLERRM );
1103: END upd_inv_ps;
1104:
1105:

Line 1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1258: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1259: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1260: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS insert_rapps_p:'||SQLERRM );
1261: FND_MSG_PUB.ADD;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: END insert_rapps_p;
1264:
1265:
1266: /*-----------------------------------------------------------------------------+

Line 1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1411: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1412: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1413: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_ctl_rem_amt_for_app:'||SQLERRM );
1414: FND_MSG_PUB.ADD;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: END res_ctl_rem_amt_for_app;
1417:
1418:
1419: /*-----------------------------------------------------------------------------+

Line 1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1478: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1479: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1480: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_inv_ps:'||SQLERRM );
1481: FND_MSG_PUB.ADD;
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: END res_inv_ps;
1484:
1485:
1486: /*-----------------------------------------------------------------------------+

Line 1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1525: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1526: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1527: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS delete_application:'||SQLERRM );
1528: FND_MSG_PUB.ADD;
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: END delete_application;
1531:
1532:
1533: PROCEDURE copy_app_rec

Line 1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1584: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1585: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1586: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS copy_app_rec:'||SQLERRM );
1587: FND_MSG_PUB.ADD;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: END copy_app_rec;
1590:
1591:
1592: /*-----------------------------------------------------------------------------+

Line 1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1657: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1658: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1659: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS do_apply:'||SQLERRM );
1660: FND_MSG_PUB.ADD;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: END do_apply;
1663:
1664:
1665: /*-----------------------------------------------------------------------------+

Line 1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1769: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1770: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1771: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS apply:'||SQLERRM );
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: END apply;
1775:
1776: PROCEDURE dump_ccid
1777: IS

Line 1890: x_return_status := fnd_api.g_ret_sts_success;

1886: rev_rec_error EXCEPTION;
1887: BEGIN
1888: arp_standard.debug('initialization +');
1889: SAVEPOINT initialization;
1890: x_return_status := fnd_api.g_ret_sts_success;
1891: OPEN c;
1892: FETCH c INTO g_customer_trx;
1893: IF c%NOTFOUND THEN
1894: CLOSE c;

Line 1979: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1975: SELECT ar_receivable_applications_s.nextval
1976: INTO g_app_ra_id
1977: FROM dual;
1978:
1979: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1980: RAISE FND_API.G_EXC_ERROR;
1981: END IF;
1982:
1983: arp_standard.debug('initialization -');

Line 1980: RAISE FND_API.G_EXC_ERROR;

1976: INTO g_app_ra_id
1977: FROM dual;
1978:
1979: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1980: RAISE FND_API.G_EXC_ERROR;
1981: END IF;
1982:
1983: arp_standard.debug('initialization -');
1984: EXCEPTION

Line 1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1986: ROLLBACK TO initialization;
1987: arp_standard.debug('EXCEPTION initialization no_sys_param');
1988: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' );
1989: FND_MSG_PUB.ADD;
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1992: p_count => x_msg_count,
1993: p_data => x_msg_data);
1994: WHEN not_valid_trx THEN

Line 1991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1987: arp_standard.debug('EXCEPTION initialization no_sys_param');
1988: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' );
1989: FND_MSG_PUB.ADD;
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1992: p_count => x_msg_count,
1993: p_data => x_msg_data);
1994: WHEN not_valid_trx THEN
1995: ROLLBACK TO initialization;

Line 2001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1997: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1998: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||
1999: p_customer_trx_id );
2000: FND_MSG_PUB.ADD;
2001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => x_msg_data);
2005: WHEN not_valid_cr THEN

Line 2002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1998: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||
1999: p_customer_trx_id );
2000: FND_MSG_PUB.ADD;
2001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => x_msg_data);
2005: WHEN not_valid_cr THEN
2006: ROLLBACK TO initialization;

Line 2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2008: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2009: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||
2010: p_cash_receipt_id );
2011: FND_MSG_PUB.ADD;
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: WHEN FND_API.G_EXC_ERROR THEN

Line 2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2009: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||
2010: p_cash_receipt_id );
2011: FND_MSG_PUB.ADD;
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO initialization;

Line 2016: WHEN FND_API.G_EXC_ERROR THEN

2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO initialization;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,

Line 2018: x_return_status := FND_API.G_RET_STS_ERROR;

2014: p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO initialization;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022: WHEN rev_rec_error THEN

Line 2019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2015: p_data => x_msg_data);
2016: WHEN FND_API.G_EXC_ERROR THEN
2017: ROLLBACK TO initialization;
2018: x_return_status := FND_API.G_RET_STS_ERROR;
2019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022: WHEN rev_rec_error THEN
2023: ROLLBACK TO initialization;

Line 2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2027: arp_standard.debug('Error in Rev Rec - ARP_AUTO_RULE.create_distributions for trx_id :'||p_customer_trx_id);
2028: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTORULE_ERROR' );
2029: FND_MESSAGE.SET_TOKEN( 'TRX_NUMBER', l_trx_number );
2030: FND_MSG_PUB.ADD;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2033: p_count => x_msg_count,
2034: p_data => x_msg_data);
2035:

Line 2032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2028: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTORULE_ERROR' );
2029: FND_MESSAGE.SET_TOKEN( 'TRX_NUMBER', l_trx_number );
2030: FND_MSG_PUB.ADD;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2033: p_count => x_msg_count,
2034: p_data => x_msg_data);
2035:
2036: WHEN OTHERS THEN

Line 2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2038: arp_standard.debug('EXCEPTION initialization OTHERS:'||SQLERRM);
2039: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2040: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );
2041: FND_MSG_PUB.ADD;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2044: p_count => x_msg_count,
2045: p_data => x_msg_data);
2046: END initialization;

Line 2043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2039: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2040: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );
2041: FND_MSG_PUB.ADD;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2044: p_count => x_msg_count,
2045: p_data => x_msg_data);
2046: END initialization;
2047:

Line 2147: RETURN FND_API.G_RET_STS_UNEXP_ERROR;

2143: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2144: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2145: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS cur_app_gt_id:'||SQLERRM );
2146: FND_MSG_PUB.ADD;
2147: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2148: END cur_app_gt_id;
2149:
2150:
2151: /*-----------------------------------------------------------------------------+

Line 2216: x_return_status := fnd_api.g_ret_sts_success;

2212: BEGIN
2213: arp_standard.debug('application_execute +');
2214: SAVEPOINT first_delete_then_apply;
2215:
2216: x_return_status := fnd_api.g_ret_sts_success;
2217:
2218: cur_gt_id := cur_app_gt_id( p_app_level ,
2219: p_source_data_key1 ,
2220: p_source_data_key2 ,

Line 2235: ELSIF cur_gt_id = FND_API.G_RET_STS_UNEXP_ERROR THEN

2231: delete_application
2232: (p_app_rec => l_app_rec,
2233: x_return_status => x_return_status);
2234:
2235: ELSIF cur_gt_id = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238:
2239: -- Apply

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232: (p_app_rec => l_app_rec,
2233: x_return_status => x_return_status);
2234:
2235: ELSIF cur_gt_id = FND_API.G_RET_STS_UNEXP_ERROR THEN
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238:
2239: -- Apply
2240: apply(p_app_level => p_app_level,

Line 2267: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2263: p_charges_uediscounted => p_charges_uediscounted,
2264: --
2265: x_return_status => x_return_status);
2266:
2267: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2268: RAISE FND_API.G_EXC_ERROR;
2269: END IF;
2270:
2271: arp_standard.debug('application_execute -');

Line 2268: RAISE FND_API.G_EXC_ERROR;

2264: --
2265: x_return_status => x_return_status);
2266:
2267: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2268: RAISE FND_API.G_EXC_ERROR;
2269: END IF;
2270:
2271: arp_standard.debug('application_execute -');
2272: EXCEPTION

Line 2273: WHEN FND_API.G_EXC_ERROR THEN

2269: END IF;
2270:
2271: arp_standard.debug('application_execute -');
2272: EXCEPTION
2273: WHEN FND_API.G_EXC_ERROR THEN
2274: ROLLBACK TO first_delete_then_apply;
2275: x_return_status := FND_API.G_RET_STS_ERROR;
2276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2277: p_count => x_msg_count,

Line 2275: x_return_status := FND_API.G_RET_STS_ERROR;

2271: arp_standard.debug('application_execute -');
2272: EXCEPTION
2273: WHEN FND_API.G_EXC_ERROR THEN
2274: ROLLBACK TO first_delete_then_apply;
2275: x_return_status := FND_API.G_RET_STS_ERROR;
2276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2277: p_count => x_msg_count,
2278: p_data => x_msg_data);
2279: WHEN unexpected_error THEN

Line 2276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2272: EXCEPTION
2273: WHEN FND_API.G_EXC_ERROR THEN
2274: ROLLBACK TO first_delete_then_apply;
2275: x_return_status := FND_API.G_RET_STS_ERROR;
2276: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2277: p_count => x_msg_count,
2278: p_data => x_msg_data);
2279: WHEN unexpected_error THEN
2280: ROLLBACK TO first_delete_then_apply;

Line 2287: x_return_status := FND_API.G_RET_STS_ERROR;

2283: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2284: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'
2285: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2286: FND_MSG_PUB.ADD;
2287: x_return_status := FND_API.G_RET_STS_ERROR;
2288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2289: p_count => x_msg_count,
2290: p_data => x_msg_data);
2291: WHEN OTHERS THEN

Line 2288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2284: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'
2285: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2286: FND_MSG_PUB.ADD;
2287: x_return_status := FND_API.G_RET_STS_ERROR;
2288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2289: p_count => x_msg_count,
2290: p_data => x_msg_data);
2291: WHEN OTHERS THEN
2292: ROLLBACK TO first_delete_then_apply;

Line 2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2293: arp_standard.debug('EXCEPTION first_delete_then_apply OTHERS:'||SQLERRM);
2294: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2295: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );
2296: FND_MSG_PUB.ADD;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2299: p_count => x_msg_count,
2300: p_data => x_msg_data);
2301: END application_execute;

Line 2298: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2294: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2295: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );
2296: FND_MSG_PUB.ADD;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2299: p_count => x_msg_count,
2300: p_data => x_msg_data);
2301: END application_execute;
2302:

Line 2463: x_return_status := fnd_api.g_ret_sts_success;

2459: arp_standard.debug(' customer_trx_id :'||g_customer_trx.customer_trx_id);
2460:
2461: savepoint final_commit;
2462:
2463: x_return_status := fnd_api.g_ret_sts_success;
2464: OPEN c;
2465: FETCH c INTO x_ra_rec.AMOUNT_APPLIED,
2466: x_ra_rec.AMOUNT_APPLIED_FROM,
2467: x_ra_rec.EARNED_DISCOUNT_TAKEN,

Line 2625: IF x_return_status = fnd_api.g_ret_sts_success THEN

2621:
2622: END IF;
2623: CLOSE c;
2624:
2625: IF x_return_status = fnd_api.g_ret_sts_success THEN
2626: arp_ps_util.populate_closed_dates( p_gl_date,
2627: p_apply_date,
2628: g_payschedule_trx.class,
2629: g_payschedule_trx );

Line 2665: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2661: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2662: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2663: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.final_commit-'||SQLERRM );
2664: FND_MSG_PUB.ADD;
2665: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2666: p_count => x_msg_count,
2667: p_data => x_msg_data);
2668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2669: END final_commit;

Line 2668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2664: FND_MSG_PUB.ADD;
2665: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2666: p_count => x_msg_count,
2667: p_data => x_msg_data);
2668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2669: END final_commit;
2670:
2671:
2672: /*-----------------------------------------------------------------------------+

Line 2771: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2767: customer_trx_id :'||g_customer_trx.customer_trx_id||'
2768: p_app_level :'||p_app_level||'
2769: p_ctl_id :'||p_ctl_id);
2770: FND_MSG_PUB.ADD;
2771: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774: x_return_status := FND_API.G_RET_STS_SUCCESS;
2775: WHEN OTHERS THEN

Line 2774: x_return_status := FND_API.G_RET_STS_SUCCESS;

2770: FND_MSG_PUB.ADD;
2771: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774: x_return_status := FND_API.G_RET_STS_SUCCESS;
2775: WHEN OTHERS THEN
2776: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_remaining:'||SQLERRM);
2777: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2778: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );

Line 2780: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2776: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_remaining:'||SQLERRM);
2777: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2778: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );
2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);
2783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2784:

Line 2783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);
2783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2784:
2785: END get_latest_amount_remaining;
2786:
2787: /*-----------------------------------------------------------------------------+

Line 3118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

3114: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3115: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3116: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_applied-'||SQLERRM );
3117: FND_MSG_PUB.ADD;
3118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3119: p_count => x_msg_count,
3120: p_data => x_msg_data);
3121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3122: END get_latest_amount_applied;

Line 3121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3117: FND_MSG_PUB.ADD;
3118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3119: p_count => x_msg_count,
3120: p_data => x_msg_data);
3121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3122: END get_latest_amount_applied;
3123:
3124:
3125:

Line 3218: x_return_status := fnd_api.g_ret_sts_error;

3214: arp_standard.debug(' p_line_flag :'||p_line_flag);
3215: arp_standard.debug(' p_tax_flag :'||p_tax_flag);
3216:
3217: IF p_gt_id IS NULL THEN
3218: x_return_status := fnd_api.g_ret_sts_error;
3219: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3220: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3221: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3222: FND_MSG_PUB.ADD;

Line 3229: x_return_status := fnd_api.g_ret_sts_error;

3225: IF ((p_adj_rec.amount IS NULL) AND (p_adj_rec.acctd_amount IS NULL))
3226: OR
3227: ((p_adj_rec.amount = 0 ) AND (p_adj_rec.acctd_amount = 0 ))
3228: THEN
3229: x_return_status := fnd_api.g_ret_sts_error;
3230: arp_standard.debug(' Adjustment record amount and accounted amount causes no need to execute');
3231: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3232: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record amount and accounted amount causes no need to execute');
3233: FND_MSG_PUB.ADD;

Line 3241: x_return_status := fnd_api.g_ret_sts_error;

3237: OR
3238: ((p_adj_rec.amount <> p_adj_rec.acctd_amount) AND
3239: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: arp_standard.debug(' Adjustment record combination causes an invalid combination');
3243: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3244: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record combination causes an invalid combination');
3245: FND_MSG_PUB.ADD;

Line 3258: x_return_status := fnd_api.g_ret_sts_error;

3254: arp_standard.debug(' sum tax from ar_line_dist_interface_gt, l_sum_tax :'||l_sum_tax);
3255:
3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN
3258: x_return_status := fnd_api.g_ret_sts_error;
3259: arp_standard.debug(' There is no line amount and tax amount in the interface table for this adjustment');
3260: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3261: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount and tax amount in the interface table for adjustment -'||
3262: ' adjustment_id : ' || p_adj_rec.adjustment_id);

Line 3267: x_return_status := fnd_api.g_ret_sts_error;

3263: END IF;
3264:
3265:
3266: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3267: x_return_status := fnd_api.g_ret_sts_error;
3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3271: FND_MSG_PUB.ADD;

Line 3275: x_return_status := fnd_api.g_ret_sts_error;

3271: FND_MSG_PUB.ADD;
3272: END IF;
3273:
3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3279: FND_MSG_PUB.ADD;

Line 3335: x_return_status := fnd_api.g_ret_sts_error;

3331: arp_standard.debug(' p_uned_line_flag :'||p_uned_line_flag);
3332: arp_standard.debug(' p_uned_tax_flag :'||p_uned_tax_flag);
3333:
3334: IF p_gt_id IS NULL THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3336: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3337: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3338: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3339: FND_MSG_PUB.ADD;

Line 3346: x_return_status := fnd_api.g_ret_sts_error;

3342: IF ((p_app_rec.amount_applied IS NULL) AND (p_app_rec.acctd_amount_applied_to IS NULL))
3343: OR
3344: ((p_app_rec.amount_applied = 0 ) AND (p_app_rec.acctd_amount_applied_to = 0 ))
3345: THEN
3346: x_return_status := fnd_api.g_ret_sts_error;
3347: arp_standard.debug(' Application record amount and accounted amount to causes no need to execute'||
3348: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3349: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3350: FND_MESSAGE.SET_TOKEN('TEXT',' Application record amount and accounted amount to causes no need to execute'||

Line 3360: x_return_status := fnd_api.g_ret_sts_error;

3356: OR
3357: ((p_app_rec.amount_applied <> p_app_rec.acctd_amount_applied_to) AND
3358: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3359: THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: arp_standard.debug(' Application record combination causes an invalid combination on amount bucket');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: FND_MESSAGE.SET_TOKEN('TEXT',' Application record combination causes an invalid combination');
3364: FND_MSG_PUB.ADD;

Line 3397: x_return_status := fnd_api.g_ret_sts_error;

3393: IF (l_sum_line = NULL) AND (l_sum_tax = NULL ) AND
3394: (l_sum_ed_line = NULL) AND (l_sum_ed_tax = NULL ) AND
3395: (l_sum_uned_line = NULL) AND (l_sum_uned_tax = NULL )
3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_error;
3398: arp_standard.debug(' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application');
3399: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3400: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application'||
3401: ' receivable_application_id : ' || p_app_rec.receivable_application_id);

Line 3406: x_return_status := fnd_api.g_ret_sts_error;

3402: END IF;
3403:
3404:
3405: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3406: x_return_status := fnd_api.g_ret_sts_error;
3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3410: FND_MSG_PUB.ADD;

Line 3414: x_return_status := fnd_api.g_ret_sts_error;

3410: FND_MSG_PUB.ADD;
3411: END IF;
3412:
3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3414: x_return_status := fnd_api.g_ret_sts_error;
3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3418: FND_MSG_PUB.ADD;

Line 3422: x_return_status := fnd_api.g_ret_sts_error;

3418: FND_MSG_PUB.ADD;
3419: END IF;
3420:
3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3426: FND_MSG_PUB.ADD;

Line 3430: x_return_status := fnd_api.g_ret_sts_error;

3426: FND_MSG_PUB.ADD;
3427: END IF;
3428:
3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3430: x_return_status := fnd_api.g_ret_sts_error;
3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3434: FND_MSG_PUB.ADD;

Line 3438: x_return_status := fnd_api.g_ret_sts_error;

3434: FND_MSG_PUB.ADD;
3435: END IF;
3436:
3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3438: x_return_status := fnd_api.g_ret_sts_error;
3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3442: FND_MSG_PUB.ADD;

Line 3446: x_return_status := fnd_api.g_ret_sts_error;

3442: FND_MSG_PUB.ADD;
3443: END IF;
3444:
3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3446: x_return_status := fnd_api.g_ret_sts_error;
3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3450: FND_MSG_PUB.ADD;