DBA Data[Home] [Help]

APPS.ARP_DEDUCTION_COVER dependencies on ARP_DEDUCTION_COVER

Line 1: PACKAGE BODY ARP_DEDUCTION_COVER AS

1: PACKAGE BODY ARP_DEDUCTION_COVER AS
2: /* $Header: ARXDECVB.pls 120.26.12010000.3 2008/10/20 13:25:38 spdixit ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARP_DEDUCTION_COVER';

3:
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARP_DEDUCTION_COVER';
8:
9:
10: /*========================================================================
11: | Prototype Declarations Procedures

Line 76: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()+');

72: l_active_claim_flag ar_payment_schedules.active_claim_flag%TYPE;
73:
74: BEGIN
75: IF PG_DEBUG in ('Y', 'C') THEN
76: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()+');
77: END IF;
78:
79: -- Standard Start of API savepoint
80: SAVEPOINT Update_amount_In_Dispute;

Line 172: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()-');

168: x_note_id => l_note_id);
169: END IF;
170:
171: IF PG_DEBUG in ('Y', 'C') THEN
172: arp_standard.debug('ARP_DEDUCTION_COVER.update_amount_in_dispute()-');
173: END IF;
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN

Line 186: ' at arp_deduction_cover.update_amount_in_dispute()+');

182: p_data => x_msg_data);
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: IF PG_DEBUG in ('Y', 'C') THEN
185: arp_standard.debug('update_amount_in_dispute: ' || 'Unexpected error '||sqlerrm||
186: ' at arp_deduction_cover.update_amount_in_dispute()+');
187: END IF;
188: ROLLBACK TO Update_Amount_In_Dispute;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
190: FND_MSG_PUB.Count_And_Get

Line 199: ' at arp_deduction_cover.update_amount_in_dispute()+');

195: IF (SQLCODE = -20001)
196: THEN
197: IF PG_DEBUG in ('Y', 'C') THEN
198: arp_util.debug('update_amount_in_dispute: ' || '20001 error '||
199: ' at arp_deduction_cover.update_amount_in_dispute()+');
200: END IF;
201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: ELSE
203: IF PG_DEBUG in ('Y', 'C') THEN

Line 205: ' at arp_deduction_cover.update_amount_in_dispute()+');

201: x_return_status := FND_API.G_RET_STS_ERROR ;
202: ELSE
203: IF PG_DEBUG in ('Y', 'C') THEN
204: arp_util.debug('update_amount_in_dispute: ' || 'Unexpected error '||sqlerrm||
205: ' at arp_deduction_cover.update_amount_in_dispute()+');
206: END IF;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
208: IF FND_MSG_PUB.Check_Msg_Level
209: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 339: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()+');

335:
336: BEGIN
337:
338: IF PG_DEBUG in ('Y', 'C') THEN
339: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()+');
340: END IF;
341:
342: -- Standard Start of API savepoint
343: SAVEPOINT Create_Receipt_Writeoff;

Line 605: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()-');

601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;
603:
604: IF PG_DEBUG in ('Y', 'C') THEN
605: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()-');
606: END IF;
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN

Line 619: ' at arp_deduction_cover.create_receipt_writeoff()+');

615: p_data => x_msg_data);
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: IF PG_DEBUG in ('Y', 'C') THEN
618: arp_standard.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||
619: ' at arp_deduction_cover.create_receipt_writeoff()+');
620: END IF;
621: ROLLBACK TO Create_Receipt_Writeoff;
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
623: FND_MSG_PUB.Count_And_Get

Line 632: ' at arp_deduction_cover.create_receipt_writeoff()+');

628: IF (SQLCODE = -20001)
629: THEN
630: IF PG_DEBUG in ('Y', 'C') THEN
631: arp_util.debug('create_receipt_writeoff: ' || '20001 error '||
632: ' at arp_deduction_cover.create_receipt_writeoff()+');
633: END IF;
634: x_return_status := FND_API.G_RET_STS_ERROR ;
635: ELSE
636: IF PG_DEBUG in ('Y', 'C') THEN

Line 638: ' at arp_deduction_cover.create_receipt_writeoff()+');

634: x_return_status := FND_API.G_RET_STS_ERROR ;
635: ELSE
636: IF PG_DEBUG in ('Y', 'C') THEN
637: arp_util.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||
638: ' at arp_deduction_cover.create_receipt_writeoff()+');
639: END IF;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
641: IF FND_MSG_PUB.Check_Msg_Level
642: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 795: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()+');

791:
792: BEGIN
793:
794: IF PG_DEBUG in ('Y', 'C') THEN
795: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()+');
796: END IF;
797:
798: -- Standard Start of API savepoint
799: SAVEPOINT split_claim_reapplication;

Line 1095: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');

1091: END IF;
1092: END IF;
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: arp_standard.debug('split_claim_reapplication: ' || 'After Inserting Claim Application (-)');
1095: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');
1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN

Line 1109: ' at arp_deduction_cover.split_claim_reapplication()+');

1105: p_data => x_msg_data);
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: IF PG_DEBUG in ('Y', 'C') THEN
1108: arp_standard.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||
1109: ' at arp_deduction_cover.split_claim_reapplication()+');
1110: END IF;
1111: ROLLBACK TO split_claim_reapplication;
1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1113: FND_MSG_PUB.Count_And_Get

Line 1122: ' at arp_deduction_cover.split_claim_reapplication()+');

1118: IF (SQLCODE = -20001)
1119: THEN
1120: IF PG_DEBUG in ('Y', 'C') THEN
1121: arp_util.debug('split_claim_reapplication: ' || '20001 error '||
1122: ' at arp_deduction_cover.split_claim_reapplication()+');
1123: END IF;
1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1125: ELSE
1126: IF PG_DEBUG in ('Y', 'C') THEN

Line 1128: ' at arp_deduction_cover.split_claim_reapplication()+');

1124: x_return_status := FND_API.G_RET_STS_ERROR ;
1125: ELSE
1126: IF PG_DEBUG in ('Y', 'C') THEN
1127: arp_util.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||
1128: ' at arp_deduction_cover.split_claim_reapplication()+');
1129: END IF;
1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1131: IF FND_MSG_PUB.Check_Msg_Level
1132: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1190: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()+');

1186: RETURN BOOLEAN
1187: IS
1188: BEGIN
1189: IF PG_DEBUG in ('Y', 'C') THEN
1190: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()+');
1191: END IF;
1192:
1193: x_receipt_number := NULL;
1194: x_receipt_date := NULL;

Line 1227: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()-');

1223: AND cr.cash_receipt_id = p_cash_receipt_id;
1224: END IF;
1225: RETURN TRUE;
1226: IF PG_DEBUG in ('Y', 'C') THEN
1227: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()-');
1228: END IF;
1229:
1230: EXCEPTION
1231: WHEN OTHERS

Line 1309: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()+');

1305:
1306: BEGIN
1307:
1308: IF PG_DEBUG in ('Y', 'C') THEN
1309: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()+');
1310: END IF;
1311:
1312: IF (p_claim_id IS NULL)
1313: THEN

Line 1548: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()-');

1544: FND_MSG_PUB.Add;
1545: RETURN FALSE;
1546: END IF;
1547: IF PG_DEBUG in ('Y', 'C') THEN
1548: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()-');
1549: END IF;
1550:
1551: EXCEPTION
1552: WHEN OTHERS

Line 1601: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()+');

1597: l_query VARCHAR2(2000);
1598: l_api_name CONSTANT VARCHAR2(30) := 'claim_valid';
1599: BEGIN
1600: IF PG_DEBUG in ('Y', 'C') THEN
1601: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()+');
1602: END IF;
1603: --
1604: -- The sql to check for the existence of the claim in iClaim is dynamic
1605: -- to avoid package compilation problems if iClaim is not installed

Line 1637: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()-');

1633: FND_MSG_PUB.Add;
1634: RETURN FALSE;
1635: END IF;
1636: IF PG_DEBUG in ('Y', 'C') THEN
1637: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()-');
1638: END IF;
1639: EXCEPTION
1640: WHEN OTHERS THEN
1641: IF (SQLCODE = -20001)

Line 1645: ' at arp_deduction_cover.claim_valid()+');

1641: IF (SQLCODE = -20001)
1642: THEN
1643: IF PG_DEBUG in ('Y', 'C') THEN
1644: arp_standard.debug('claim_valid: ' || '20001 error '||
1645: ' at arp_deduction_cover.claim_valid()+');
1646: END IF;
1647: ELSE
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_standard.debug('claim_valid: ' || 'Unexpected error '||sqlerrm||

Line 1650: ' at arp_deduction_cover.claim_valid()+');

1646: END IF;
1647: ELSE
1648: IF PG_DEBUG in ('Y', 'C') THEN
1649: arp_standard.debug('claim_valid: ' || 'Unexpected error '||sqlerrm||
1650: ' at arp_deduction_cover.claim_valid()+');
1651: END IF;
1652: IF FND_MSG_PUB.Check_Msg_Level
1653: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1654: THEN

Line 1693: arp_standard.debug('ARP_DEDUCTION_COVER.negative_rct_writeoffs_allowed()+');

1689: RETURN BOOLEAN
1690: IS
1691: BEGIN
1692: IF PG_DEBUG in ('Y', 'C') THEN
1693: arp_standard.debug('ARP_DEDUCTION_COVER.negative_rct_writeoffs_allowed()+');
1694: END IF;
1695: RETURN TRUE;
1696: END ;
1697:

Line 1737: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()+');

1733:
1734: BEGIN
1735:
1736: IF PG_DEBUG in ('Y', 'C') THEN
1737: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()+');
1738: END IF;
1739:
1740: x_return_status := FND_API.G_RET_STS_SUCCESS;
1741:

Line 1767: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()-');

1763: x_return_status := FND_API.G_RET_STS_ERROR;
1764: END IF;
1765:
1766: IF PG_DEBUG in ('Y', 'C') THEN
1767: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()-');
1768: END IF;
1769:
1770: EXCEPTION WHEN OTHERS THEN
1771: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

Line 1777: END ARP_DEDUCTION_COVER;

1773: FND_MSG_PUB.Add;
1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1775: END validate_amount_applied;
1776:
1777: END ARP_DEDUCTION_COVER;