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.28.12020000.2 2013/03/01 09:57:04 dgaurab 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 340: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()+');

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

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

618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: END IF;
620:
621: IF PG_DEBUG in ('Y', 'C') THEN
622: arp_standard.debug('ARP_DEDUCTION_COVER.create_receipt_writeoff()-');
623: END IF;
624:
625: EXCEPTION
626: WHEN FND_API.G_EXC_ERROR THEN

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

632: p_data => x_msg_data);
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: IF PG_DEBUG in ('Y', 'C') THEN
635: arp_standard.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||
636: ' at arp_deduction_cover.create_receipt_writeoff()+');
637: END IF;
638: ROLLBACK TO Create_Receipt_Writeoff;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640: FND_MSG_PUB.Count_And_Get

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

645: IF (SQLCODE = -20001)
646: THEN
647: IF PG_DEBUG in ('Y', 'C') THEN
648: arp_util.debug('create_receipt_writeoff: ' || '20001 error '||
649: ' at arp_deduction_cover.create_receipt_writeoff()+');
650: END IF;
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: ELSE
653: IF PG_DEBUG in ('Y', 'C') THEN

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

651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: ELSE
653: IF PG_DEBUG in ('Y', 'C') THEN
654: arp_util.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||
655: ' at arp_deduction_cover.create_receipt_writeoff()+');
656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
658: IF FND_MSG_PUB.Check_Msg_Level
659: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

809:
810: BEGIN
811:
812: IF PG_DEBUG in ('Y', 'C') THEN
813: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()+');
814: END IF;
815:
816: -- Standard Start of API savepoint
817: SAVEPOINT split_claim_reapplication;

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

1125: END IF;
1126: END IF;
1127: IF PG_DEBUG in ('Y', 'C') THEN
1128: arp_standard.debug('split_claim_reapplication: ' || 'After Inserting Claim Application (-)');
1129: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');
1130: END IF;
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN

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

1139: p_data => x_msg_data);
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: IF PG_DEBUG in ('Y', 'C') THEN
1142: arp_standard.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||
1143: ' at arp_deduction_cover.split_claim_reapplication()+');
1144: END IF;
1145: ROLLBACK TO split_claim_reapplication;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: FND_MSG_PUB.Count_And_Get

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

1152: IF (SQLCODE = -20001)
1153: THEN
1154: IF PG_DEBUG in ('Y', 'C') THEN
1155: arp_util.debug('split_claim_reapplication: ' || '20001 error '||
1156: ' at arp_deduction_cover.split_claim_reapplication()+');
1157: END IF;
1158: x_return_status := FND_API.G_RET_STS_ERROR ;
1159: ELSE
1160: IF PG_DEBUG in ('Y', 'C') THEN

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

1158: x_return_status := FND_API.G_RET_STS_ERROR ;
1159: ELSE
1160: IF PG_DEBUG in ('Y', 'C') THEN
1161: arp_util.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||
1162: ' at arp_deduction_cover.split_claim_reapplication()+');
1163: END IF;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1165: IF FND_MSG_PUB.Check_Msg_Level
1166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1220: RETURN BOOLEAN
1221: IS
1222: BEGIN
1223: IF PG_DEBUG in ('Y', 'C') THEN
1224: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()+');
1225: END IF;
1226:
1227: x_receipt_number := NULL;
1228: x_receipt_date := NULL;

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

1257: AND cr.cash_receipt_id = p_cash_receipt_id;
1258: END IF;
1259: RETURN TRUE;
1260: IF PG_DEBUG in ('Y', 'C') THEN
1261: arp_standard.debug('ARP_DEDUCTION_COVER.receipt_valid()-');
1262: END IF;
1263:
1264: EXCEPTION
1265: WHEN OTHERS

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

1339:
1340: BEGIN
1341:
1342: IF PG_DEBUG in ('Y', 'C') THEN
1343: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()+');
1344: END IF;
1345:
1346: IF (p_claim_id IS NULL)
1347: THEN

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

1578: FND_MSG_PUB.Add;
1579: RETURN FALSE;
1580: END IF;
1581: IF PG_DEBUG in ('Y', 'C') THEN
1582: arp_standard.debug('ARP_DEDUCTION_COVER.claim_on_receipt()-');
1583: END IF;
1584:
1585: EXCEPTION
1586: WHEN OTHERS

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

1631: l_query VARCHAR2(2000);
1632: l_api_name CONSTANT VARCHAR2(30) := 'claim_valid';
1633: BEGIN
1634: IF PG_DEBUG in ('Y', 'C') THEN
1635: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()+');
1636: END IF;
1637: --
1638: -- The sql to check for the existence of the claim in iClaim is dynamic
1639: -- to avoid package compilation problems if iClaim is not installed

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

1667: FND_MSG_PUB.Add;
1668: RETURN FALSE;
1669: END IF;
1670: IF PG_DEBUG in ('Y', 'C') THEN
1671: arp_standard.debug('ARP_DEDUCTION_COVER.claim_valid()-');
1672: END IF;
1673: EXCEPTION
1674: WHEN OTHERS THEN
1675: IF (SQLCODE = -20001)

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

1675: IF (SQLCODE = -20001)
1676: THEN
1677: IF PG_DEBUG in ('Y', 'C') THEN
1678: arp_standard.debug('claim_valid: ' || '20001 error '||
1679: ' at arp_deduction_cover.claim_valid()+');
1680: END IF;
1681: ELSE
1682: IF PG_DEBUG in ('Y', 'C') THEN
1683: arp_standard.debug('claim_valid: ' || 'Unexpected error '||sqlerrm||

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

1680: END IF;
1681: ELSE
1682: IF PG_DEBUG in ('Y', 'C') THEN
1683: arp_standard.debug('claim_valid: ' || 'Unexpected error '||sqlerrm||
1684: ' at arp_deduction_cover.claim_valid()+');
1685: END IF;
1686: IF FND_MSG_PUB.Check_Msg_Level
1687: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1688: THEN

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

1723: RETURN BOOLEAN
1724: IS
1725: BEGIN
1726: IF PG_DEBUG in ('Y', 'C') THEN
1727: arp_standard.debug('ARP_DEDUCTION_COVER.negative_rct_writeoffs_allowed()+');
1728: END IF;
1729: RETURN TRUE;
1730: END ;
1731:

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

1767:
1768: BEGIN
1769:
1770: IF PG_DEBUG in ('Y', 'C') THEN
1771: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()+');
1772: END IF;
1773:
1774: x_return_status := FND_API.G_RET_STS_SUCCESS;
1775:

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

1797: x_return_status := FND_API.G_RET_STS_ERROR;
1798: END IF;
1799:
1800: IF PG_DEBUG in ('Y', 'C') THEN
1801: arp_standard.debug('ARP_DEDUCTION_COVER.validate_amount_applied()-');
1802: END IF;
1803:
1804: EXCEPTION WHEN OTHERS THEN
1805: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

Line 1811: END ARP_DEDUCTION_COVER;

1807: FND_MSG_PUB.Add;
1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1809: END validate_amount_applied;
1810:
1811: END ARP_DEDUCTION_COVER;