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.AR_PREPAYMENTS dependencies on FND_API

Line 174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

170:
171: PROCEDURE Process_Prepayments(
172: -- Standard API parameters.
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

Line 175: p_commit IN VARCHAR2 := FND_API.G_FALSE,

171: PROCEDURE Process_Prepayments(
172: -- Standard API parameters.
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.

Line 176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

172: -- Standard API parameters.
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
175: p_commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: p_receipt_number IN ar_cash_receipts.receipt_number%TYPE DEFAULT NULL,
178: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
179: p_receivable_application_id IN ar_receivable_applications.
180: receivable_application_id%TYPE DEFAULT NULL,

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: arp_util.debug(
242: 'ar_prepayments.process prepayment (+)');
243: END IF;
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: l_cash_receipt_id := p_cash_receipt_id;
247: l_receivable_application_id := p_receivable_application_id;
248: l_refund_amount := p_refund_amount;
249: l_receivables_trx_id := p_receivables_trx_id;

Line 333: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

329: END IF;
330:
331:
332:
333: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
334: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
335: l_def_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN
336:
337: IF PG_DEBUG in ('Y', 'C') THEN

Line 334: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR

330:
331:
332:
333: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
334: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
335: l_def_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN
336:
337: IF PG_DEBUG in ('Y', 'C') THEN
338: arp_util.debug(

Line 335: l_def_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN

331:
332:
333: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
334: l_def_return_status <> FND_API.G_RET_STS_SUCCESS OR
335: l_def_activity_return_status <> FND_API.G_RET_STS_SUCCESS THEN
336:
337: IF PG_DEBUG in ('Y', 'C') THEN
338: arp_util.debug(
339: 'Validation or Defaulting Failed' );

Line 341: x_return_status := FND_API.G_RET_STS_ERROR ;

337: IF PG_DEBUG in ('Y', 'C') THEN
338: arp_util.debug(
339: 'Validation or Defaulting Failed' );
340: END IF;
341: x_return_status := FND_API.G_RET_STS_ERROR ;
342:
343: END IF;
344:
345:

Line 353: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

349: /*----------------------------------------------------
350: If the validations passed then
351: Unapply prepayment
352: -----------------------------------------------------*/
353: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
354:
355: IF PG_DEBUG in ('Y', 'C') THEN
356: arp_util.debug(
357: ' Calling ar_receipt_api_pub.Unapply_other_account' );

Line 382: END IF; ---x_return_status = FND_API.G_RET_STS_SUCCESS

378: 'Unapply Other Account Return status :'||
379: x_return_status);
380: END IF;
381:
382: END IF; ---x_return_status = FND_API.G_RET_STS_SUCCESS
383:
384:
385: /*----------------------------------------------------
386: Make sure there are no errors in unapplication.

Line 390: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND

386: Make sure there are no errors in unapplication.
387: if there is any error,do not perform refund or
388: reapplication
389: -----------------------------------------------------*/
390: IF x_return_status = FND_API.G_RET_STS_SUCCESS AND
391: l_refund_type = 'CREDIT_CARD' THEN
392:
393: IF PG_DEBUG in ('Y', 'C') THEN
394: arp_util.debug(

Line 446: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

442: Bug 3628401
443: Fetch the amount_applied for credit card refund
444: application
445: -----------------------------------------------------*/
446: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
447: arp_app_pkg.fetch_p(l_receivable_application_id,
448: l_ra_refund_rec);
449: l_actual_refund_amount := NVL(l_ra_refund_rec.amount_applied,0);
450: END IF;

Line 455: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS AND

451:
452: /*----------------------------------------------------
453: On Account refund Application
454: -----------------------------------------------------*/
455: ELSIF x_return_status = FND_API.G_RET_STS_SUCCESS AND
456: l_refund_type = 'ON_ACCOUNT' THEN
457:
458: /*----------------------------------------------------
459: populate the message if the receipt was supposed

Line 500: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

496: /*----------------------------------------------------
497: Bug 3628401
498: Fetch the amount_applied on On Account refund record
499: -----------------------------------------------------*/
500: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
501:
502: l_on_acc_rec_app_id :=
503: ar_receipt_api_pub.g_apply_on_account_out_rec.receivable_application_id;
504: arp_app_pkg.fetch_p(l_on_acc_rec_app_id, l_ra_refund_rec );

Line 516: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

512: Bug 3628401
513: If the refund application was successful then evaluate
514: whether any amount needs to be applied back on Prepayment
515: -----------------------------------------------------*/
516: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
517:
518: l_reapply_amount := NVL(l_ra_rec.amount_applied,0)
519: - NVL(l_actual_refund_amount,0);
520:

Line 649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

645:
646: /*----------------------------------------------------
647: Error Handling Finally
648: -----------------------------------------------------*/
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
650:
651: ---Bug 3628401 removed unexpected_error;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648: -----------------------------------------------------*/
649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
650:
651: ---Bug 3628401 removed unexpected_error;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
654: p_count => x_msg_count,
655: p_data => x_msg_data
656: );

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

649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
650:
651: ---Bug 3628401 removed unexpected_error;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
654: p_count => x_msg_count,
655: p_data => x_msg_data
656: );
657: RETURN;

Line 667: x_return_status := FND_API.G_RET_STS_ERROR;

663:
664: EXCEPTION
665:
666: WHEN OTHERS THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data);
671:

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

664: EXCEPTION
665:
666: WHEN OTHERS THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data);
671:
672: IF PG_DEBUG in ('Y', 'C') THEN

Line 713: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

709: *=======================================================================*/
710: PROCEDURE Create_Prepayment(
711: -- Standard API parameters.
712: p_api_version IN NUMBER,
713: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,

Line 714: p_commit IN VARCHAR2 := FND_API.G_FALSE,

710: PROCEDURE Create_Prepayment(
711: -- Standard API parameters.
712: p_api_version IN NUMBER,
713: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2,

Line 715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

711: -- Standard API parameters.
712: p_api_version IN NUMBER,
713: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
716: x_return_status OUT NOCOPY VARCHAR2,
717: x_msg_count OUT NOCOPY NUMBER,
718: x_msg_data OUT NOCOPY VARCHAR2,
719: -- Receipt info. parameters

Line 792: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,

788: -- processor such as iPayments
789: p_payment_server_order_num IN OUT NOCOPY ar_cash_receipts.payment_server_order_num%TYPE,
790: p_approval_code IN OUT NOCOPY ar_cash_receipts.approval_code%TYPE,
791: --- Bug: 3220078 Change the p_call_payment_processor to TRUE ---
792: p_call_payment_processor IN VARCHAR2 DEFAULT FND_API.G_TRUE,
793:
794: p_payment_response_error_code OUT NOCOPY VARCHAR2,
795: -- OUT NOCOPY parameter for the Application
796: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 816: IF FND_API.to_Boolean( p_init_msg_list )

812:
813: /*--------------------------------------------------------------+
814: | Initialize message list if p_init_msg_list is set to TRUE |
815: +--------------------------------------------------------------*/
816: IF FND_API.to_Boolean( p_init_msg_list )
817: THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: /* SSA change */

Line 822: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

818: FND_MSG_PUB.initialize;
819: END IF;
820: /* SSA change */
821: l_org_id := p_org_id;
822: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
823: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
824: p_return_status =>l_org_return_status);
825: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;

Line 825: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

821: l_org_id := p_org_id;
822: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
823: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
824: p_return_status =>l_org_return_status);
825: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: ELSE
828:
829:

Line 826: x_return_status := FND_API.G_RET_STS_ERROR;

822: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
823: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
824: p_return_status =>l_org_return_status);
825: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
826: x_return_status := FND_API.G_RET_STS_ERROR;
827: ELSE
828:
829:
830: --Initialize the return status

Line 831: x_return_status := FND_API.G_RET_STS_SUCCESS;

827: ELSE
828:
829:
830: --Initialize the return status
831: x_return_status := FND_API.G_RET_STS_SUCCESS;
832:
833: --get the value of receipt_number into local variable
834: l_receipt_number := p_receipt_number;
835:

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

927: p_org_id,
928: p_payment_trxn_extension_id);
929:
930:
931: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
932: p_count => x_msg_count,
933: p_data => x_msg_data);
934:
935: IF PG_DEBUG in ('Y', 'C') THEN

Line 947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

943: WHEN others THEN
944: IF PG_DEBUG in ('Y', 'C') THEN
945: arp_util.debug('EXCEPTION : ar_prepayment.create_prepayment ||SQLERRM');
946: END IF;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data);

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

945: arp_util.debug('EXCEPTION : ar_prepayment.create_prepayment ||SQLERRM');
946: END IF;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data);
952:
953: END Create_Prepayment;

Line 958: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

954:
955: PROCEDURE Refund_Prepayments(
956: -- Standard API parameters.
957: p_api_version IN NUMBER,
958: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
959: p_commit IN VARCHAR2 := FND_API.G_FALSE,
960: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
961: x_return_status OUT NOCOPY VARCHAR2,
962: x_msg_count OUT NOCOPY NUMBER,

Line 959: p_commit IN VARCHAR2 := FND_API.G_FALSE,

955: PROCEDURE Refund_Prepayments(
956: -- Standard API parameters.
957: p_api_version IN NUMBER,
958: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
959: p_commit IN VARCHAR2 := FND_API.G_FALSE,
960: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
961: x_return_status OUT NOCOPY VARCHAR2,
962: x_msg_count OUT NOCOPY NUMBER,
963: x_msg_data OUT NOCOPY VARCHAR2,

Line 960: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

956: -- Standard API parameters.
957: p_api_version IN NUMBER,
958: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
959: p_commit IN VARCHAR2 := FND_API.G_FALSE,
960: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
961: x_return_status OUT NOCOPY VARCHAR2,
962: x_msg_count OUT NOCOPY NUMBER,
963: x_msg_data OUT NOCOPY VARCHAR2,
964: p_prepay_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE,

Line 1047: x_return_status := FND_API.G_RET_STS_SUCCESS;

1043: /*-----------------------------------------+
1044: | Initialize return status to SUCCESS |
1045: +-----------------------------------------*/
1046:
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;
1048:
1049: /*--------------------------------------------------+
1050: | Standard call to check for call compatibility |
1051: +--------------------------------------------------*/

Line 1053: IF NOT FND_API.Compatible_API_Call(

1049: /*--------------------------------------------------+
1050: | Standard call to check for call compatibility |
1051: +--------------------------------------------------*/
1052:
1053: IF NOT FND_API.Compatible_API_Call(
1054: l_api_version,
1055: p_api_version,
1056: l_api_name,
1057: G_PKG_NAME

Line 1060: x_return_status := FND_API.G_RET_STS_ERROR;

1056: l_api_name,
1057: G_PKG_NAME
1058: )
1059: THEN
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063:
1064: /*--------------------------------------------------------------+

Line 1061: RAISE FND_API.G_EXC_ERROR;

1057: G_PKG_NAME
1058: )
1059: THEN
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: RAISE FND_API.G_EXC_ERROR;
1062: END IF;
1063:
1064: /*--------------------------------------------------------------+
1065: | Initialize message list if p_init_msg_list is set to TRUE |

Line 1068: IF FND_API.to_Boolean( p_init_msg_list )

1064: /*--------------------------------------------------------------+
1065: | Initialize message list if p_init_msg_list is set to TRUE |
1066: +--------------------------------------------------------------*/
1067:
1068: IF FND_API.to_Boolean( p_init_msg_list )
1069: THEN
1070: FND_MSG_PUB.initialize;
1071: END IF;
1072:

Line 1093: l_receipt_id_def_status := FND_API.G_RET_STS_SUCCESS;

1089: l_receivable_application_id := p_receivable_application_id;
1090: l_refund_amount := p_refund_amount;
1091: l_payment_set_id := p_payment_set_id;
1092: l_receivables_trx_id := p_receivables_trx_id;
1093: l_receipt_id_def_status := FND_API.G_RET_STS_SUCCESS;
1094:
1095: IF (l_payment_set_id IS NULl AND p_receipt_number IS NULL
1096: AND l_cash_receipt_id IS NULL AND l_receivable_application_id IS NULL)
1097: THEN

Line 1100: x_return_status := FND_API.G_RET_STS_ERROR;

1096: AND l_cash_receipt_id IS NULL AND l_receivable_application_id IS NULL)
1097: THEN
1098: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
1099: FND_MSG_PUB.Add;
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: RETURN;
1102: END IF;
1103:
1104:

Line 1114: IF l_receipt_id_def_status <> FND_API.G_RET_STS_SUCCESS OR

1110: p_receipt_number ,
1111: l_receipt_id_def_status);
1112:
1113:
1114: IF l_receipt_id_def_status <> FND_API.G_RET_STS_SUCCESS OR
1115: l_cash_receipt_id is NULL THEN
1116:
1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('refund_prepayments: ' || 'Validation or Defaulting Failed' ) ;

Line 1121: x_return_status := FND_API.G_RET_STS_ERROR;

1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('refund_prepayments: ' || 'Validation or Defaulting Failed' ) ;
1119: END IF;
1120:
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: END IF;
1125:

Line 1122: RAISE FND_API.G_EXC_ERROR;

1118: arp_util.debug('refund_prepayments: ' || 'Validation or Defaulting Failed' ) ;
1119: END IF;
1120:
1121: x_return_status := FND_API.G_RET_STS_ERROR;
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: END IF;
1125:
1126:

Line 1159: x_return_status := FND_API.G_RET_STS_ERROR ;

1155: if nvl(l_refund_amount,0) > nvl(l_max_refund_amt,0) then
1156: --raise error X validation failed
1157: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');
1158: FND_MSG_PUB.Add;
1159: x_return_status := FND_API.G_RET_STS_ERROR ;
1160: RETURN;
1161: end if;
1162:
1163:

Line 1180: x_return_status := FND_API.G_RET_STS_ERROR;

1176: EXCEPTION
1177: when no_data_found then
1178: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');
1179: FND_MSG_PUB.Add;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: RETURN ;
1182:
1183: when others then
1184: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1184: x_return_status := FND_API.G_RET_STS_ERROR;

1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: RETURN ;
1182:
1183: when others then
1184: x_return_status := FND_API.G_RET_STS_ERROR;
1185: RAISE;
1186: END;
1187:
1188: IF PG_DEBUG in ('Y', 'C') THEN

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1245: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PAYMENT_SET_ID');
1246: FND_MESSAGE.SET_TOKEN('VALUE',l_payment_set_id);
1247: FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: RETURN;
1250: end if;
1251:
1252:

Line 1276: x_return_status := FND_API.G_RET_STS_ERROR;

1272: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1273: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BANK_ACCOUNT_ID');
1274: FND_MESSAGE.SET_TOKEN('VALUE',t_bank_account_id);
1275: FND_MSG_PUB.Add;
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: RETURN;
1278: end if;
1279:
1280: end if;

Line 1305: x_return_status := FND_API.G_RET_STS_ERROR;

1301: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1302: FND_MESSAGE.SET_TOKEN('PARAMETER','P_RECEIPT_METHOD_ID');
1303: FND_MESSAGE.SET_TOKEN('VALUE',t_receipt_method_id);
1304: FND_MSG_PUB.Add;
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: RETURN;
1307: end if;
1308:
1309:

Line 1331: x_return_status := FND_API.G_RET_STS_ERROR ;

1327: if nvl(l_refund_amount,0) > nvl(l_max_refund_amt,0) then
1328: --raise error X validation failed
1329: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');
1330: FND_MSG_PUB.Add;
1331: x_return_status := FND_API.G_RET_STS_ERROR ;
1332: RETURN;
1333: end if;
1334:
1335: if PG_DEBUG in ('Y', 'C') THEN

Line 1365: x_return_status := FND_API.G_RET_STS_ERROR;

1361:
1362: IF PG_DEBUG in ('Y', 'C') THEN
1363: arp_util.debug('Refund_Prepayments: ' || 'Could not find payment type()+ ');
1364: END IF;
1365: x_return_status := FND_API.G_RET_STS_ERROR;
1366: RETURN;
1367:
1368:
1369: -----if there is one payment type --------

Line 1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1441: arp_util.debug('Refund_Prepayments: ' || 'Receivable App ID : '||p_prepay_application_id);
1442: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);
1443: END IF;
1444:
1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: EXIT;
1448: END IF;
1449:

Line 1446: x_return_status := FND_API.G_RET_STS_ERROR;

1442: arp_util.debug('Refund_Prepayments: ' || 'Process Payments status : '||x_return_status);
1443: END IF;
1444:
1445: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1446: x_return_status := FND_API.G_RET_STS_ERROR;
1447: EXIT;
1448: END IF;
1449:
1450: l_refund_amount := l_refund_amount - l_rcpt_refund_amount;

Line 1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1469: /*-------------------------------------------------
1470: Finally error Handling
1471: Moved it down fron before the end if
1472: --------------------------------------------------*/
1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1474:
1475: ---Bug 3628401 raising expected error
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: RAISE FND_API.G_EXC_ERROR;

Line 1476: x_return_status := FND_API.G_RET_STS_ERROR;

1472: --------------------------------------------------*/
1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1474:
1475: ---Bug 3628401 raising expected error
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: RAISE FND_API.G_EXC_ERROR;
1478:
1479: END IF;
1480:

Line 1477: RAISE FND_API.G_EXC_ERROR;

1473: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1474:
1475: ---Bug 3628401 raising expected error
1476: x_return_status := FND_API.G_RET_STS_ERROR;
1477: RAISE FND_API.G_EXC_ERROR;
1478:
1479: END IF;
1480:
1481:

Line 1488: IF FND_API.To_Boolean( p_commit )

1484: /*--------------------------------+
1485: | Standard check of p_commit |
1486: +--------------------------------*/
1487:
1488: IF FND_API.To_Boolean( p_commit )
1489: THEN
1490: IF PG_DEBUG in ('Y', 'C') THEN
1491: arp_util.debug('Refund_Prepayments: ' || 'committing');
1492: END IF;

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

1492: END IF;
1493: Commit;
1494: END IF;
1495:
1496: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1497: p_count => x_msg_count,
1498: p_data => x_msg_data);
1499:
1500: IF PG_DEBUG in ('Y', 'C') THEN

Line 1507: WHEN FND_API.G_EXC_ERROR THEN

1503:
1504:
1505: EXCEPTION
1506:
1507: WHEN FND_API.G_EXC_ERROR THEN
1508:
1509: IF PG_DEBUG in ('Y', 'C') THEN
1510: arp_util.debug( SQLCODE, G_MSG_ERROR);
1511: arp_util.debug( SQLERRM, G_MSG_ERROR);

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR ;

1511: arp_util.debug( SQLERRM, G_MSG_ERROR);
1512: END IF;
1513:
1514: ROLLBACK TO refund_prepay_PVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR ;
1516:
1517: -- Display_Parameters;
1518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1519: p_count => x_msg_count,

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

1514: ROLLBACK TO refund_prepay_PVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR ;
1516:
1517: -- Display_Parameters;
1518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1519: p_count => x_msg_count,
1520: p_data => x_msg_data
1521: );
1522:

Line 1535: x_return_status := FND_API.G_RET_STS_ERROR ;

1531: IF (SQLCODE = -20001) THEN
1532: ROLLBACK TO refund_prepay_PVT;
1533:
1534: -- Display_Parameters;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data);
1542: RETURN;
1543: ELSE

Line 1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1540: p_count => x_msg_count,
1541: p_data => x_msg_data);
1542: RETURN;
1543: ELSE
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1546: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REFUND_PREPAYMENT : '||SQLERRM);
1547: FND_MSG_PUB.Add;
1548: END IF;

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

1560: );
1561: END IF;
1562:
1563: -- Display_Parameters;
1564: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data);
1567:
1568:

Line 1618: x_return_status := FND_API.G_RET_STS_SUCCESS;

1614:
1615: IF PG_DEBUG in ('Y', 'C') THEN
1616: arp_util.debug('ar_prepayments.match_prepayment (+)');
1617: END IF;
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619: l_payment_schedule_id := p_payment_schedule_id;
1620:
1621: BEGIN
1622: SELECT 'Y'

Line 1635: x_return_status := FND_API.G_RET_STS_SUCCESS;

1631: WHEN no_data_found THEN
1632: IF PG_DEBUG in ('Y', 'C') THEN
1633: arp_util.debug('ar_prepayments.match_prepayment No prepayment exists');
1634: END IF;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: RETURN;
1637: WHEN others THEN
1638: IF PG_DEBUG in ('Y', 'C') THEN
1639: arp_util.debug('EXCEPTION :ar_prepayments.match_prepayment Check ');

Line 1641: x_return_status := FND_API.G_RET_STS_ERROR;

1637: WHEN others THEN
1638: IF PG_DEBUG in ('Y', 'C') THEN
1639: arp_util.debug('EXCEPTION :ar_prepayments.match_prepayment Check ');
1640: END IF;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: RETURN;
1643: END;
1644:
1645: --fetch invoice payment schedule

Line 1671: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1667:
1668: IF PG_DEBUG in ('Y', 'C') THEN
1669: arp_util.debug('match_prepayment: ' || 'unapply_other_account retun status : '||l_return_status);
1670: END IF;
1671: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting unapplied Cash Receipt ID : ' || prepayapp_rec.cash_receipt_id);
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: EXIT;
1675: END IF;

Line 1673: x_return_status := FND_API.G_RET_STS_ERROR;

1669: arp_util.debug('match_prepayment: ' || 'unapply_other_account retun status : '||l_return_status);
1670: END IF;
1671: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1672: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting unapplied Cash Receipt ID : ' || prepayapp_rec.cash_receipt_id);
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: EXIT;
1675: END IF;
1676:
1677: /*

Line 1719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1715: IF PG_DEBUG in ('Y', 'C') THEN
1716: arp_util.debug('match_prepayment: ' || 'Apply retun status : '||l_return_status);
1717: END IF;
1718:
1719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);

Line 1720: x_return_status := FND_API.G_RET_STS_ERROR;

1716: arp_util.debug('match_prepayment: ' || 'Apply retun status : '||l_return_status);
1717: END IF;
1718:
1719: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: FND_FILE.put_line(fnd_file.log,'Prepayment is not getting applied to Invoice ');
1722: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1723: FND_FILE.put_line(fnd_file.log,'Customer Trx ID : ' || l_ps_rec.customer_trx_id);
1724: FND_FILE.put_line(fnd_file.log,'Payment Schedule ID: ' || l_ps_rec.payment_schedule_id);

Line 1730: IF (l_prepay_amount_reapplied > 0) AND (x_return_status <> FND_API.G_RET_STS_ERROR) THEN

1726: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1727: END IF;
1728:
1729: --Apply rest of the amount back to prepayment
1730: IF (l_prepay_amount_reapplied > 0) AND (x_return_status <> FND_API.G_RET_STS_ERROR) THEN
1731: --Assign atributes
1732: l_attribute_rec.attribute_category := prepayapp_rec.attribute_category;
1733: l_attribute_rec.attribute1 := prepayapp_rec.attribute1;
1734: l_attribute_rec.attribute2 := prepayapp_rec.attribute2;

Line 1800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1796: IF PG_DEBUG in ('Y', 'C') THEN
1797: arp_util.debug('match_prepayment: ' || 'apply_other_account retun status : '||l_return_status);
1798: END IF;
1799:
1800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_FILE.put_line(fnd_file.log,'Leftover amount is not getting applied back to Prepayment ');
1803: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1804: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);

Line 1801: x_return_status := FND_API.G_RET_STS_ERROR;

1797: arp_util.debug('match_prepayment: ' || 'apply_other_account retun status : '||l_return_status);
1798: END IF;
1799:
1800: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1801: x_return_status := FND_API.G_RET_STS_ERROR;
1802: FND_FILE.put_line(fnd_file.log,'Leftover amount is not getting applied back to Prepayment ');
1803: FND_FILE.put_line(fnd_file.log,'Cash receipt ID : ' || prepayapp_rec.cash_receipt_id);
1804: FND_FILE.put_line(fnd_file.log,'Payment Set ID: ' || prepayapp_rec.payment_set_id);
1805: END IF;

Line 1816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1812: l_complete_applied_flag := TRUE;
1813: EXIT;
1814: END IF;
1815:
1816: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1817: EXIT;
1818: END IF;
1819:
1820:

Line 1827: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1823: IF (l_complete_applied_flag) THEN
1824: EXIT;
1825: END IF;
1826:
1827: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1828: EXIT;
1829: END IF;
1830:
1831: END LOOP;

Line 1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1829: END IF;
1830:
1831: END LOOP;
1832:
1833: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1834: ROLLBACK to match_prepayment_PVT;
1835: IF NVL(l_msg_count,0) > 0 Then
1836: IF l_msg_count = 1 Then
1837: IF PG_DEBUG in ('Y', 'C') THEN

Line 1844: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

1840:
1841: ELSIF l_msg_count > 1 Then
1842: FOR l_count IN 1..l_msg_count LOOP
1843:
1844: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1845: IF PG_DEBUG in ('Y', 'C') THEN
1846: arp_util.debug('match_prepayment: ' || to_char(l_count)||' : '||l_msg_data);
1847: END IF;
1848: END LOOP;

Line 1853: x_return_status := FND_API.G_RET_STS_SUCCESS;

1849:
1850: END IF; -- l_msg_count
1851: END IF; -- NVL(l_msg_count,0)
1852: ELSE
1853: x_return_status := FND_API.G_RET_STS_SUCCESS;
1854: END IF;
1855:
1856: IF PG_DEBUG in ('Y', 'C') THEN
1857: arp_util.debug('ar_prepayments.match_prepayment (-)');

Line 1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1861: WHEN others THEN
1862: IF PG_DEBUG in ('Y', 'C') THEN
1863: arp_util.debug('EXCEPTION : ar_prepayments.match_prepayment ||SQLERRM');
1864: END IF;
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: END match_prepayment;
1867:
1868: /*=======================================================================
1869: | PUBLIC Procedure get_installment

Line 1940: x_return_status := FND_API.G_RET_STS_SUCCESS;

1936:
1937: /*----------------------------------------+
1938: | Initialize return status to SUCCESS |
1939: +-----------------------------------------*/
1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: /*-------Validate the p_term_id---------------*/
1943: IF p_term_id IS NULL THEN
1944: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');

Line 1946: RAISE FND_API.G_EXC_ERROR;

1942: /*-------Validate the p_term_id---------------*/
1943: IF p_term_id IS NULL THEN
1944: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1945: FND_MSG_PUB.Add;
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSE
1948: BEGIN
1949: SELECT 1 into l_dummy
1950: FROM RA_TERMS_B

Line 1956: RAISE FND_API.G_EXC_ERROR;

1952: EXCEPTION
1953: WHEN NO_DATA_FOUND THEN
1954: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1955: FND_MSG_PUB.Add;
1956: RAISE FND_API.G_EXC_ERROR;
1957: END;
1958: END IF;
1959:
1960: -----Input amount should not be null or 0 -------

Line 1964: RAISE FND_API.G_EXC_ERROR;

1960: -----Input amount should not be null or 0 -------
1961: IF ( (p_amount is null) or (p_amount <= 0) ) THEN
1962: FND_MESSAGE.SET_NAME('AR','AR_PPAY_BASE_AMOUNT_INVALID');
1963: FND_MSG_PUB.Add;
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966:
1967: -----Input currency code should not be invalid -------
1968: IF p_currency_code IS NULL THEN

Line 1971: RAISE FND_API.G_EXC_ERROR;

1967: -----Input currency code should not be invalid -------
1968: IF p_currency_code IS NULL THEN
1969: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1970: FND_MSG_PUB.Add;
1971: RAISE FND_API.G_EXC_ERROR;
1972: ELSE
1973: BEGIN
1974: SELECT 1 into l_dummy
1975: FROM fnd_currencies

Line 1981: RAISE FND_API.G_EXC_ERROR;

1977: EXCEPTION
1978: WHEN NO_DATA_FOUND THEN
1979: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1980: FND_MSG_PUB.Add;
1981: RAISE FND_API.G_EXC_ERROR;
1982: END;
1983: END IF;
1984:
1985:

Line 2004: WHEN fnd_api.g_exc_error THEN

2000: arp_util.debug('ar_prepayment.get_installment (-)');
2001: END IF;
2002:
2003: EXCEPTION
2004: WHEN fnd_api.g_exc_error THEN
2005:
2006:
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2007: x_return_status := FND_API.G_RET_STS_ERROR;

2003: EXCEPTION
2004: WHEN fnd_api.g_exc_error THEN
2005:
2006:
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2009: p_count => x_msg_count,
2010: p_data => x_msg_data);
2011:

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

2004: WHEN fnd_api.g_exc_error THEN
2005:
2006:
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2009: p_count => x_msg_count,
2010: p_data => x_msg_data);
2011:
2012:

Line 2014: x_return_status := FND_API.G_RET_STS_ERROR;

2010: p_data => x_msg_data);
2011:
2012:
2013: WHEN others THEN
2014: x_return_status := FND_API.G_RET_STS_ERROR;
2015:
2016: --Bug 3107679 removed to_char call
2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);

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

2016: --Bug 3107679 removed to_char call
2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
2019: FND_MSG_PUB.Add;
2020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2021: p_count => x_msg_count,
2022: p_data => x_msg_data);
2023:
2024: ROLLBACK to get_installment_PVT;

Line 2122: RAISE FND_API.G_EXC_ERROR;

2118:
2119: IF l_conc_request_id = 0 THEN
2120: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: END IF;
2125:
2126: RETURN 'SUCCESS';

Line 2239: RAISE FND_API.G_EXC_ERROR;

2235: IF( l_request_id IS NULL OR l_request_id = 0 )THEN
2236: FND_MESSAGE.SET_NAME('AR','AR_PPAY_INVALID_REQ_ID');
2237: FND_MSG_PUB.Add;
2238: l_retcode := 10;
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;
2241: end if;
2242:
2243: SAVEPOINT prepay_start;

Line 2317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2313: p_cash_receipt_id => l_cash_receipt_id,
2314: ps_amt_due_remain => l_ps_amt_due_remain,
2315: x_return_status => l_return_status);
2316:
2317: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2318: l_retcode := 10;
2319: ELSE
2320: /* 9021126 - Commit the receipt application for this transaction to
2321: release locks on the various application rows */

Line 2357: -- RAISE FND_API.G_EXC_ERROR;

2353:
2354: if (l_retcode <> 0) then
2355: FND_FILE.put_line(fnd_file.log,'There are few prepayments which could not match. Pl check log file for details');
2356: lb_request_status := FND_CONCURRENT.set_completion_status('WARNING', '');
2357: -- RAISE FND_API.G_EXC_ERROR;
2358: end if;
2359:
2360:
2361: EXCEPTION

Line 2362: WHEN fnd_api.g_exc_error THEN

2358: end if;
2359:
2360:
2361: EXCEPTION
2362: WHEN fnd_api.g_exc_error THEN
2363: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');
2364: FND_MSG_PUB.Add;
2365:
2366: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

Line 2369: FND_API.G_FALSE ), 1,255);

2365:
2366: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2367: l_msg_data :=
2368: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2369: FND_API.G_FALSE ), 1,255);
2370: END LOOP;
2371:
2372: fnd_file.put_line(fnd_file.log, l_msg_data);
2373: FND_MSG_PUB.Delete_Msg;