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_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 345: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 495: RAISE FND_API.G_EXC_ERROR;

491: | 6) Raise error if validation errors found |
492: +---------------------------------------------------------------------*/
493: IF (l_error_count > 0)
494: THEN
495: RAISE FND_API.G_EXC_ERROR;
496: END IF;
497:
498: /*---------------------------------------------------------------------+
499: | 7) Unapply the claim investigation application |

Line 507: p_init_msg_list => FND_API.G_FALSE,

503:
504: IF l_claim_applied = 'Y' THEN
505: AR_Receipt_API_PUB.unapply_other_account (
506: p_api_version => 1.0,
507: p_init_msg_list => FND_API.G_FALSE,
508: x_return_status => l_return_status,
509: x_msg_count => l_msg_count,
510: x_msg_data => l_msg_data,
511: p_receivable_application_id => l_application_id,

Line 531: p_init_msg_list => FND_API.G_FALSE,

527: they are settled from TM */
528:
529: ar_receipt_api_pub.apply_other_account (
530: p_api_version => 1.0,
531: p_init_msg_list => FND_API.G_FALSE,
532: x_return_status => l_return_status,
533: x_msg_count => l_msg_count,
534: x_msg_data => l_msg_data,
535: p_receivable_application_id => l_receivable_application_id,

Line 556: RAISE FND_API.G_EXC_ERROR;

552: p_called_from => 'TRADE_MANAGEMENT');
553:
554: IF l_return_status = 'E'
555: THEN
556: RAISE FND_API.G_EXC_ERROR;
557: ELSIF l_return_status = 'U'
558: THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: THEN
556: RAISE FND_API.G_EXC_ERROR;
557: ELSIF l_return_status = 'U'
558: THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END IF;
561: IF PG_DEBUG in ('Y', 'C') THEN
562: arp_standard.debug('create_receipt_writeoff: ' || 'After Inserting Claim Application (-)');
563: END IF;

Line 598: RAISE FND_API.G_EXC_ERROR;

594: );
595:
596: IF l_return_status = 'E'
597: THEN
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF l_return_status = 'U'
600: THEN
601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
602: END IF;

Line 601: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

597: THEN
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF l_return_status = 'U'
600: THEN
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()-');

Line 609: WHEN FND_API.G_EXC_ERROR 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
610: ROLLBACK TO Create_Receipt_Writeoff;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get
613: (p_encoded => FND_API.G_FALSE,

Line 611: x_return_status := FND_API.G_RET_STS_ERROR ;

607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: ROLLBACK TO Create_Receipt_Writeoff;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get
613: (p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
615: p_data => x_msg_data);

Line 613: (p_encoded => FND_API.G_FALSE,

609: WHEN FND_API.G_EXC_ERROR THEN
610: ROLLBACK TO Create_Receipt_Writeoff;
611: x_return_status := FND_API.G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get
613: (p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: IF PG_DEBUG in ('Y', 'C') THEN

Line 616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

612: FND_MSG_PUB.Count_And_Get
613: (p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
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;

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
624: (p_encoded => FND_API.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data);

Line 624: (p_encoded => FND_API.G_FALSE,

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
624: (p_encoded => FND_API.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data);
627: WHEN OTHERS THEN
628: IF (SQLCODE = -20001)

Line 634: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg

Line 652: (p_encoded => FND_API.G_FALSE,

648: END IF;
649: END IF;
650: ROLLBACK TO Create_Receipt_Writeoff;
651: FND_MSG_PUB.Count_And_Get
652: (p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data);
655: END create_receipt_writeoff;
656:

Line 708: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

704: PROCEDURE split_claim_reapplication
705: (p_claim_id IN NUMBER,
706: p_customer_trx_id IN NUMBER,
707: p_amount IN NUMBER,
708: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
709: p_cash_receipt_id IN NUMBER,
710: p_ussgl_transaction_code IN NUMBER DEFAULT NULL,
711: x_return_status OUT NOCOPY VARCHAR2,
712: x_msg_count OUT NOCOPY NUMBER,

Line 801: IF FND_API.to_Boolean( p_init_msg_list )

797:
798: -- Standard Start of API savepoint
799: SAVEPOINT split_claim_reapplication;
800: -- Initialize message list if p_init_msg_list is set to TRUE.
801: IF FND_API.to_Boolean( p_init_msg_list )
802: THEN
803: FND_MSG_PUB.initialize;
804: END IF;
805: -- Initialize API return status to success

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: THEN
803: FND_MSG_PUB.initialize;
804: END IF;
805: -- Initialize API return status to success
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: /* Bug 3022077 - initialize global variables */
809: arp_global.init_global;
810: arp_standard.init_standard;

Line 856: RAISE FND_API.G_EXC_ERROR;

852: EXCEPTION
853: WHEN OTHERS THEN
854: FND_MESSAGE.SET_NAME('AR','ARTA_PAYMENT_SCHEDULE_NO_FOUND');
855: FND_MSG_PUB.Add;
856: RAISE FND_API.G_EXC_ERROR;
857: END;
858: IF NOT claim_on_receipt (
859: p_claim_id => p_claim_id
860: , p_cash_receipt_id => p_cash_receipt_id

Line 910: IF l_amount_status <> FND_API.G_RET_STS_SUCCESS THEN

906: validate_amount_applied( p_amount_applied => l_applied_amt_from_old,
907: p_new_amount_applied => nvl(arpcurr.currround(l_applied_amount_from,l_currency_code),p_amount),
908: p_cash_receipt_id => p_cash_receipt_id,
909: x_return_status => l_amount_status);
910: IF l_amount_status <> FND_API.G_RET_STS_SUCCESS THEN
911: l_error_count := l_error_count + 1;
912: END IF;
913:
914: /*---------------------------------------------------------------------+

Line 919: RAISE FND_API.G_EXC_ERROR;

915: | 3) Raise error if validation errors found |
916: +---------------------------------------------------------------------*/
917: IF (l_error_count > 0)
918: THEN
919: RAISE FND_API.G_EXC_ERROR;
920: END IF;
921:
922: /*---------------------------------------------------------------------+
923: | 4) Unapply the application |

Line 965: p_init_msg_list => FND_API.G_FALSE,

961: THEN
962: FOR rec_app_id IN get_app_ids(p_cash_receipt_id, p_customer_trx_id) LOOP
963: AR_Receipt_API_PUB.Unapply(
964: p_api_version => 1.0,
965: p_init_msg_list => FND_API.G_FALSE,
966: x_return_status => l_return_status,
967: x_msg_count => l_msg_count,
968: x_msg_data => l_msg_data,
969: p_called_from => 'TRADE_MANAGEMENT',

Line 976: p_init_msg_list => FND_API.G_FALSE,

972: END LOOP;
973: ELSE
974: AR_Receipt_API_PUB.unapply_other_account (
975: p_api_version => 1.0,
976: p_init_msg_list => FND_API.G_FALSE,
977: x_return_status => l_return_status,
978: x_msg_count => l_msg_count,
979: x_msg_data => l_msg_data,
980: p_receivable_application_id => l_application_id,

Line 989: RAISE FND_API.G_EXC_ERROR;

985: END IF;
986:
987: IF l_return_status = 'E'
988: THEN
989: RAISE FND_API.G_EXC_ERROR;
990: ELSIF l_return_status = 'U'
991: THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF;

Line 992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

988: THEN
989: RAISE FND_API.G_EXC_ERROR;
990: ELSIF l_return_status = 'U'
991: THEN
992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
993: END IF;
994:
995: /* Bug 2384340 - reinstating adjustments and chargebacks associated with
996: this receipt/payment schedule */

Line 1020: p_init_msg_list => FND_API.G_FALSE,

1016: IF p_customer_trx_id IS NOT NULL
1017: THEN
1018: ar_receipt_api_pub.apply (
1019: p_api_version => 1.0,
1020: p_init_msg_list => FND_API.G_FALSE,
1021: x_return_status => l_return_status,
1022: x_msg_count => l_msg_count,
1023: x_msg_data => l_msg_data,
1024: p_cash_receipt_id => p_cash_receipt_id,

Line 1045: p_init_msg_list => FND_API.G_FALSE,

1041: p_customer_reference => l_customer_reference);
1042: ELSE
1043: ar_receipt_api_pub.apply_other_account (
1044: p_api_version => 1.0,
1045: p_init_msg_list => FND_API.G_FALSE,
1046: x_return_status => l_return_status,
1047: x_msg_count => l_msg_count,
1048: x_msg_data => l_msg_data,
1049: p_receivable_application_id => l_receivable_application_id,

Line 1087: RAISE FND_API.G_EXC_ERROR;

1083: END IF;
1084:
1085: IF l_return_status = 'E'
1086: THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSIF l_return_status = 'U'
1089: THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: END IF;

Line 1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1086: THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: ELSIF l_return_status = 'U'
1089: THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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 (-)');

Line 1099: WHEN FND_API.G_EXC_ERROR THEN

1095: arp_standard.debug('ARP_DEDUCTION_COVER.split_claim_reapplication()-');
1096: END IF;
1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN
1100: ROLLBACK TO split_claim_reapplication;
1101: x_return_status := FND_API.G_RET_STS_ERROR ;
1102: FND_MSG_PUB.Count_And_Get
1103: (p_encoded => FND_API.G_FALSE,

Line 1101: x_return_status := FND_API.G_RET_STS_ERROR ;

1097:
1098: EXCEPTION
1099: WHEN FND_API.G_EXC_ERROR THEN
1100: ROLLBACK TO split_claim_reapplication;
1101: x_return_status := FND_API.G_RET_STS_ERROR ;
1102: FND_MSG_PUB.Count_And_Get
1103: (p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data);

Line 1103: (p_encoded => FND_API.G_FALSE,

1099: WHEN FND_API.G_EXC_ERROR THEN
1100: ROLLBACK TO split_claim_reapplication;
1101: x_return_status := FND_API.G_RET_STS_ERROR ;
1102: FND_MSG_PUB.Count_And_Get
1103: (p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => x_msg_data);
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: IF PG_DEBUG in ('Y', 'C') THEN

Line 1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1102: FND_MSG_PUB.Count_And_Get
1103: (p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
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;

Line 1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
1114: (p_encoded => FND_API.G_FALSE,
1115: p_count => x_msg_count,
1116: p_data => x_msg_data);

Line 1114: (p_encoded => FND_API.G_FALSE,

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
1114: (p_encoded => FND_API.G_FALSE,
1115: p_count => x_msg_count,
1116: p_data => x_msg_data);
1117: WHEN OTHERS THEN
1118: IF (SQLCODE = -20001)

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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)
1133: THEN
1134: FND_MSG_PUB.Add_Exc_Msg

Line 1142: (p_encoded => FND_API.G_FALSE,

1138: END IF;
1139: END IF;
1140: ROLLBACK TO split_claim_reapplication;
1141: FND_MSG_PUB.Count_And_Get
1142: (p_encoded => FND_API.G_FALSE,
1143: p_count => x_msg_count,
1144: p_data => x_msg_data);
1145: END split_claim_reapplication;
1146:

Line 1740: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
1742: SELECT SUM(NVL(ra.amount_applied,0))
1743: INTO l_unapplied_total
1744: FROM ar_receivable_applications ra

Line 1763: x_return_status := FND_API.G_RET_STS_ERROR;

1759:
1760: IF l_new_unapplied_total < 0 THEN
1761: FND_MESSAGE.set_name('AR','AR_RW_CLAIM_SETTLMT_NEG_RCT');
1762: FND_MSG_PUB.Add;
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()-');

Line 1774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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