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_DEDUCTION_COVER dependencies on FND_API

Line 56: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

52: PROCEDURE update_amount_in_dispute(
53: p_customer_trx_id IN NUMBER,
54: p_claim_number IN VARCHAR2,
55: p_amount IN NUMBER,
56: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2)
60: IS

Line 82: IF FND_API.to_Boolean( p_init_msg_list )

78:
79: -- Standard Start of API savepoint
80: SAVEPOINT Update_amount_In_Dispute;
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list )
83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to success

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to success
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: IF PG_DEBUG in ('Y', 'C') THEN
90: arp_standard.debug('update_amount_in_dispute: ' || ' p_customer_trx_id :' || p_customer_trx_id);
91: arp_standard.debug('update_amount_in_dispute: ' || ' p_claim_number :' || p_claim_number);

Line 130: RAISE FND_API.G_EXC_ERROR;

126: END IF;
127:
128: IF l_error_count > 0
129: THEN
130: RAISE FND_API.G_EXC_ERROR;
131: ELSE
132: arp_ps_pkg.set_to_dummy(p_ps_rec => l_ps_rec);
133: SELECT amount_in_dispute
134: INTO l_amount_in_dispute

Line 176: WHEN FND_API.G_EXC_ERROR 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
177: ROLLBACK TO Update_Amount_In_Dispute;
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179: FND_MSG_PUB.Count_And_Get
180: (p_encoded => FND_API.G_FALSE,

Line 178: x_return_status := FND_API.G_RET_STS_ERROR ;

174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO Update_Amount_In_Dispute;
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179: FND_MSG_PUB.Count_And_Get
180: (p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count,
182: p_data => x_msg_data);

Line 180: (p_encoded => FND_API.G_FALSE,

176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO Update_Amount_In_Dispute;
178: x_return_status := FND_API.G_RET_STS_ERROR ;
179: FND_MSG_PUB.Count_And_Get
180: (p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count,
182: p_data => x_msg_data);
183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: IF PG_DEBUG in ('Y', 'C') THEN

Line 183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

179: FND_MSG_PUB.Count_And_Get
180: (p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count,
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;

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
191: (p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data);

Line 191: (p_encoded => FND_API.G_FALSE,

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
191: (p_encoded => FND_API.G_FALSE,
192: p_count => x_msg_count,
193: p_data => x_msg_data);
194: WHEN OTHERS THEN
195: IF (SQLCODE = -20001)

Line 201: x_return_status := FND_API.G_RET_STS_ERROR ;

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
204: arp_util.debug('update_amount_in_dispute: ' || 'Unexpected error '||sqlerrm||
205: ' at arp_deduction_cover.update_amount_in_dispute()+');

Line 207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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)
210: THEN
211: FND_MSG_PUB.Add_Exc_Msg

Line 219: (p_encoded => FND_API.G_FALSE,

215: END IF;
216: END IF;
217: ROLLBACK TO Update_Amount_In_Dispute;
218: FND_MSG_PUB.Count_And_Get
219: (p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223: END update_amount_in_dispute;

Line 346: IF FND_API.to_Boolean( p_init_msg_list )

342:
343: -- Standard Start of API savepoint
344: SAVEPOINT Create_Receipt_Writeoff;
345: -- Initialize message list if p_init_msg_list is set to TRUE.
346: IF FND_API.to_Boolean( p_init_msg_list )
347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: -- Initialize API return status to success

Line 351: x_return_status := FND_API.G_RET_STS_SUCCESS;

347: THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350: -- Initialize API return status to success
351: x_return_status := FND_API.G_RET_STS_SUCCESS;
352:
353: /* Bug 3022077 - initialize global variables */
354: arp_global.init_global;
355: arp_standard.init_standard;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: | 6) Raise error if validation errors found |
509: +---------------------------------------------------------------------*/
510: IF (l_error_count > 0)
511: THEN
512: RAISE FND_API.G_EXC_ERROR;
513: END IF;
514:
515: /*---------------------------------------------------------------------+
516: | 7) Unapply the claim investigation application |

Line 524: p_init_msg_list => FND_API.G_FALSE,

520:
521: IF l_claim_applied = 'Y' THEN
522: AR_Receipt_API_PUB.unapply_other_account (
523: p_api_version => 1.0,
524: p_init_msg_list => FND_API.G_FALSE,
525: x_return_status => l_return_status,
526: x_msg_count => l_msg_count,
527: x_msg_data => l_msg_data,
528: p_receivable_application_id => l_application_id,

Line 548: p_init_msg_list => FND_API.G_FALSE,

544: they are settled from TM */
545:
546: ar_receipt_api_pub.apply_other_account (
547: p_api_version => 1.0,
548: p_init_msg_list => FND_API.G_FALSE,
549: x_return_status => l_return_status,
550: x_msg_count => l_msg_count,
551: x_msg_data => l_msg_data,
552: p_receivable_application_id => l_receivable_application_id,

Line 573: RAISE FND_API.G_EXC_ERROR;

569: p_called_from => 'TRADE_MANAGEMENT');
570:
571: IF l_return_status = 'E'
572: THEN
573: RAISE FND_API.G_EXC_ERROR;
574: ELSIF l_return_status = 'U'
575: THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

572: THEN
573: RAISE FND_API.G_EXC_ERROR;
574: ELSIF l_return_status = 'U'
575: THEN
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577: END IF;
578: IF PG_DEBUG in ('Y', 'C') THEN
579: arp_standard.debug('create_receipt_writeoff: ' || 'After Inserting Claim Application (-)');
580: END IF;

Line 615: RAISE FND_API.G_EXC_ERROR;

611: );
612:
613: IF l_return_status = 'E'
614: THEN
615: RAISE FND_API.G_EXC_ERROR;
616: ELSIF l_return_status = 'U'
617: THEN
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619: END IF;

Line 618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

614: THEN
615: RAISE FND_API.G_EXC_ERROR;
616: ELSIF l_return_status = 'U'
617: THEN
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()-');

Line 626: WHEN FND_API.G_EXC_ERROR 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
627: ROLLBACK TO Create_Receipt_Writeoff;
628: x_return_status := FND_API.G_RET_STS_ERROR ;
629: FND_MSG_PUB.Count_And_Get
630: (p_encoded => FND_API.G_FALSE,

Line 628: x_return_status := FND_API.G_RET_STS_ERROR ;

624:
625: EXCEPTION
626: WHEN FND_API.G_EXC_ERROR THEN
627: ROLLBACK TO Create_Receipt_Writeoff;
628: x_return_status := FND_API.G_RET_STS_ERROR ;
629: FND_MSG_PUB.Count_And_Get
630: (p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data);

Line 630: (p_encoded => FND_API.G_FALSE,

626: WHEN FND_API.G_EXC_ERROR THEN
627: ROLLBACK TO Create_Receipt_Writeoff;
628: x_return_status := FND_API.G_RET_STS_ERROR ;
629: FND_MSG_PUB.Count_And_Get
630: (p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
632: p_data => x_msg_data);
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: IF PG_DEBUG in ('Y', 'C') THEN

Line 633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

629: FND_MSG_PUB.Count_And_Get
630: (p_encoded => FND_API.G_FALSE,
631: p_count => x_msg_count,
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;

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
641: (p_encoded => FND_API.G_FALSE,
642: p_count => x_msg_count,
643: p_data => x_msg_data);

Line 641: (p_encoded => FND_API.G_FALSE,

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
641: (p_encoded => FND_API.G_FALSE,
642: p_count => x_msg_count,
643: p_data => x_msg_data);
644: WHEN OTHERS THEN
645: IF (SQLCODE = -20001)

Line 651: x_return_status := FND_API.G_RET_STS_ERROR ;

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
654: arp_util.debug('create_receipt_writeoff: ' || 'Unexpected error '||sqlerrm||
655: ' at arp_deduction_cover.create_receipt_writeoff()+');

Line 657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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)
660: THEN
661: FND_MSG_PUB.Add_Exc_Msg

Line 669: (p_encoded => FND_API.G_FALSE,

665: END IF;
666: END IF;
667: ROLLBACK TO Create_Receipt_Writeoff;
668: FND_MSG_PUB.Count_And_Get
669: (p_encoded => FND_API.G_FALSE,
670: p_count => x_msg_count,
671: p_data => x_msg_data);
672: END create_receipt_writeoff;
673:

Line 725: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

721: PROCEDURE split_claim_reapplication
722: (p_claim_id IN NUMBER,
723: p_customer_trx_id IN NUMBER,
724: p_amount IN NUMBER,
725: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
726: p_cash_receipt_id IN NUMBER,
727: p_ussgl_transaction_code IN NUMBER DEFAULT NULL,
728: x_return_status OUT NOCOPY VARCHAR2,
729: x_msg_count OUT NOCOPY NUMBER,

Line 819: IF FND_API.to_Boolean( p_init_msg_list )

815:
816: -- Standard Start of API savepoint
817: SAVEPOINT split_claim_reapplication;
818: -- Initialize message list if p_init_msg_list is set to TRUE.
819: IF FND_API.to_Boolean( p_init_msg_list )
820: THEN
821: FND_MSG_PUB.initialize;
822: END IF;
823: -- Initialize API return status to success

Line 824: x_return_status := FND_API.G_RET_STS_SUCCESS;

820: THEN
821: FND_MSG_PUB.initialize;
822: END IF;
823: -- Initialize API return status to success
824: x_return_status := FND_API.G_RET_STS_SUCCESS;
825:
826: /* Bug 3022077 - initialize global variables */
827: arp_global.init_global;
828: arp_standard.init_standard;

Line 890: RAISE FND_API.G_EXC_ERROR;

886: EXCEPTION
887: WHEN OTHERS THEN
888: FND_MESSAGE.SET_NAME('AR','ARTA_PAYMENT_SCHEDULE_NO_FOUND');
889: FND_MSG_PUB.Add;
890: RAISE FND_API.G_EXC_ERROR;
891: END;
892: IF NOT claim_on_receipt (
893: p_claim_id => p_claim_id
894: , p_cash_receipt_id => p_cash_receipt_id

Line 944: IF l_amount_status <> FND_API.G_RET_STS_SUCCESS THEN

940: validate_amount_applied( p_amount_applied => l_applied_amt_from_old,
941: p_new_amount_applied => nvl(arpcurr.currround(l_applied_amount_from,l_currency_code),p_amount),
942: p_cash_receipt_id => p_cash_receipt_id,
943: x_return_status => l_amount_status);
944: IF l_amount_status <> FND_API.G_RET_STS_SUCCESS THEN
945: l_error_count := l_error_count + 1;
946: END IF;
947:
948: /*---------------------------------------------------------------------+

Line 953: RAISE FND_API.G_EXC_ERROR;

949: | 3) Raise error if validation errors found |
950: +---------------------------------------------------------------------*/
951: IF (l_error_count > 0)
952: THEN
953: RAISE FND_API.G_EXC_ERROR;
954: END IF;
955:
956: /*---------------------------------------------------------------------+
957: | 4) Unapply the application |

Line 999: p_init_msg_list => FND_API.G_FALSE,

995: THEN
996: FOR rec_app_id IN get_app_ids(p_cash_receipt_id, p_customer_trx_id) LOOP
997: AR_Receipt_API_PUB.Unapply(
998: p_api_version => 1.0,
999: p_init_msg_list => FND_API.G_FALSE,
1000: x_return_status => l_return_status,
1001: x_msg_count => l_msg_count,
1002: x_msg_data => l_msg_data,
1003: p_called_from => 'TRADE_MANAGEMENT',

Line 1010: p_init_msg_list => FND_API.G_FALSE,

1006: END LOOP;
1007: ELSE
1008: AR_Receipt_API_PUB.unapply_other_account (
1009: p_api_version => 1.0,
1010: p_init_msg_list => FND_API.G_FALSE,
1011: x_return_status => l_return_status,
1012: x_msg_count => l_msg_count,
1013: x_msg_data => l_msg_data,
1014: p_receivable_application_id => l_application_id,

Line 1023: RAISE FND_API.G_EXC_ERROR;

1019: END IF;
1020:
1021: IF l_return_status = 'E'
1022: THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF l_return_status = 'U'
1025: THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: END IF;

Line 1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1022: THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF l_return_status = 'U'
1025: THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: END IF;
1028:
1029: /* Bug 2384340 - reinstating adjustments and chargebacks associated with
1030: this receipt/payment schedule */

Line 1054: p_init_msg_list => FND_API.G_FALSE,

1050: IF p_customer_trx_id IS NOT NULL
1051: THEN
1052: ar_receipt_api_pub.apply (
1053: p_api_version => 1.0,
1054: p_init_msg_list => FND_API.G_FALSE,
1055: x_return_status => l_return_status,
1056: x_msg_count => l_msg_count,
1057: x_msg_data => l_msg_data,
1058: p_cash_receipt_id => p_cash_receipt_id,

Line 1079: p_init_msg_list => FND_API.G_FALSE,

1075: p_customer_reference => l_customer_reference);
1076: ELSE
1077: ar_receipt_api_pub.apply_other_account (
1078: p_api_version => 1.0,
1079: p_init_msg_list => FND_API.G_FALSE,
1080: x_return_status => l_return_status,
1081: x_msg_count => l_msg_count,
1082: x_msg_data => l_msg_data,
1083: p_receivable_application_id => l_receivable_application_id,

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117: END IF;
1118:
1119: IF l_return_status = 'E'
1120: THEN
1121: RAISE FND_API.G_EXC_ERROR;
1122: ELSIF l_return_status = 'U'
1123: THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: END IF;

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: THEN
1121: RAISE FND_API.G_EXC_ERROR;
1122: ELSIF l_return_status = 'U'
1123: THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 (-)');

Line 1133: WHEN FND_API.G_EXC_ERROR THEN

1129: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');
1130: END IF;
1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO split_claim_reapplication;
1135: x_return_status := FND_API.G_RET_STS_ERROR ;
1136: FND_MSG_PUB.Count_And_Get
1137: (p_encoded => FND_API.G_FALSE,

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR ;

1131:
1132: EXCEPTION
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO split_claim_reapplication;
1135: x_return_status := FND_API.G_RET_STS_ERROR ;
1136: FND_MSG_PUB.Count_And_Get
1137: (p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data);

Line 1137: (p_encoded => FND_API.G_FALSE,

1133: WHEN FND_API.G_EXC_ERROR THEN
1134: ROLLBACK TO split_claim_reapplication;
1135: x_return_status := FND_API.G_RET_STS_ERROR ;
1136: FND_MSG_PUB.Count_And_Get
1137: (p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data);
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: IF PG_DEBUG in ('Y', 'C') THEN

Line 1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1136: FND_MSG_PUB.Count_And_Get
1137: (p_encoded => FND_API.G_FALSE,
1138: p_count => x_msg_count,
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;

Line 1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1148: (p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data);

Line 1148: (p_encoded => FND_API.G_FALSE,

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
1148: (p_encoded => FND_API.G_FALSE,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data);
1151: WHEN OTHERS THEN
1152: IF (SQLCODE = -20001)

Line 1158: x_return_status := FND_API.G_RET_STS_ERROR ;

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
1161: arp_util.debug('split_claim_reapplication: ' || 'Unexpected error '||sqlerrm||
1162: ' at arp_deduction_cover.split_claim_reapplication()+');

Line 1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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)
1167: THEN
1168: FND_MSG_PUB.Add_Exc_Msg

Line 1176: (p_encoded => FND_API.G_FALSE,

1172: END IF;
1173: END IF;
1174: ROLLBACK TO split_claim_reapplication;
1175: FND_MSG_PUB.Count_And_Get
1176: (p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data);
1179: END split_claim_reapplication;
1180:

Line 1774: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1776: SELECT SUM(NVL(ra.amount_applied,0))
1777: INTO l_unapplied_total
1778: FROM ar_receivable_applications ra

Line 1797: x_return_status := FND_API.G_RET_STS_ERROR;

1793:
1794: IF l_new_unapplied_total < 0 THEN
1795: FND_MESSAGE.set_name('AR','AR_RW_CLAIM_SETTLMT_NEG_RCT');
1796: FND_MSG_PUB.Add;
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()-');

Line 1808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1804: EXCEPTION WHEN OTHERS THEN
1805: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1806: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ARXDECVB.pls:Validate_amount_applied' ||SQLERRM);
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;