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_PROCESS_DET_PKG dependencies on FND_MESSAGE

Line 616: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

612: -- dump_payschedule(g_payschedule_trx);
613: arp_standard.debug('get_inv_ps -');
614: EXCEPTION
615: WHEN no_customer_trx_cache THEN
616: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
617: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_customer_trx_cache
618: Please verify if initialization has been successfully' );
619: FND_MSG_PUB.ADD;
620: x_return_status := FND_API.G_RET_STS_ERROR;

Line 617: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_customer_trx_cache

613: arp_standard.debug('get_inv_ps -');
614: EXCEPTION
615: WHEN no_customer_trx_cache THEN
616: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
617: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_customer_trx_cache
618: Please verify if initialization has been successfully' );
619: FND_MSG_PUB.ADD;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: arp_standard.debug

Line 624: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

620: x_return_status := FND_API.G_RET_STS_ERROR;
621: arp_standard.debug
622: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
623: WHEN no_installed_inv_allowed THEN
624: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
625: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_installed_inv_allowed customer_trx_id:'
626: ||g_customer_trx.customer_trx_id);
627: FND_MSG_PUB.ADD;
628: x_return_status := FND_API.G_RET_STS_ERROR;

Line 625: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_installed_inv_allowed customer_trx_id:'

621: arp_standard.debug
622: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
623: WHEN no_installed_inv_allowed THEN
624: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
625: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_installed_inv_allowed customer_trx_id:'
626: ||g_customer_trx.customer_trx_id);
627: FND_MSG_PUB.ADD;
628: x_return_status := FND_API.G_RET_STS_ERROR;
629: arp_standard.debug

Line 632: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

628: x_return_status := FND_API.G_RET_STS_ERROR;
629: arp_standard.debug
630: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
631: WHEN no_op_trx_pay_schedule THEN
632: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
633: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_open_trx_pay_schedule customer_trx_id:'
634: ||g_customer_trx.customer_trx_id);
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_ERROR;

Line 633: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_open_trx_pay_schedule customer_trx_id:'

629: arp_standard.debug
630: ('EXCEPTION get_inv_ps no_installed_inv_allowed customer_trx_id '||g_customer_trx.customer_trx_id);
631: WHEN no_op_trx_pay_schedule THEN
632: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
633: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-no_open_trx_pay_schedule customer_trx_id:'
634: ||g_customer_trx.customer_trx_id);
635: FND_MSG_PUB.ADD;
636: x_return_status := FND_API.G_RET_STS_ERROR;
637: arp_standard.debug

Line 640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

636: x_return_status := FND_API.G_RET_STS_ERROR;
637: arp_standard.debug
638: ('EXCEPTION get_inv_ps no_op_trx_pay_schedule customer_trx_id '||g_customer_trx.customer_trx_id);
639: WHEN OTHERS THEN
640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
641: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-'||SQLERRM);
642: FND_MSG_PUB.ADD;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: arp_standard.debug('EXCEPTION get_inv_ps OTHERS '||SQLERRM);

Line 641: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-'||SQLERRM);

637: arp_standard.debug
638: ('EXCEPTION get_inv_ps no_op_trx_pay_schedule customer_trx_id '||g_customer_trx.customer_trx_id);
639: WHEN OTHERS THEN
640: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
641: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_inv_ps-'||SQLERRM);
642: FND_MSG_PUB.ADD;
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: arp_standard.debug('EXCEPTION get_inv_ps OTHERS '||SQLERRM);
645: END get_inv_ps;

Line 681: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

677: CLOSE c_ps;
678: arp_standard.debug('get_rec_ps -');
679: EXCEPTION
680: WHEN no_op_rec_pay_schedule THEN
681: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
682: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps no_open_rec_pay_schedule' );
683: FND_MSG_PUB.ADD;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: arp_standard.debug

Line 682: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps no_open_rec_pay_schedule' );

678: arp_standard.debug('get_rec_ps -');
679: EXCEPTION
680: WHEN no_op_rec_pay_schedule THEN
681: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
682: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps no_open_rec_pay_schedule' );
683: FND_MSG_PUB.ADD;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: arp_standard.debug
686: ('EXCEPTION get_rec_ps no_op_rec_pay_schedule p_cr_id '||p_cr_id);

Line 688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

684: x_return_status := FND_API.G_RET_STS_ERROR;
685: arp_standard.debug
686: ('EXCEPTION get_rec_ps no_op_rec_pay_schedule p_cr_id '||p_cr_id);
687: WHEN OTHERS THEN
688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
689: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps:'||SQLERRM );
690: FND_MSG_PUB.ADD;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: arp_standard.debug

Line 689: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps:'||SQLERRM );

685: arp_standard.debug
686: ('EXCEPTION get_rec_ps no_op_rec_pay_schedule p_cr_id '||p_cr_id);
687: WHEN OTHERS THEN
688: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
689: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_rec_ps:'||SQLERRM );
690: FND_MSG_PUB.ADD;
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: arp_standard.debug
693: ('EXCEPTION get_rec_ps OTHERS '||SQLERRM);

Line 1059: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1055: x_app_rec := l_apps_rec;
1056: arp_standard.debug( 'arp_process_det_pkg.upd_inv_ps-' );
1057: EXCEPTION
1058: WHEN neg_app_amt THEN
1059: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1060: IF l_earned_concern = 'PBLINENEG' THEN
1061: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line applied amt is negative');
1062: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1063: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax applied amt is negative');

Line 1061: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line applied amt is negative');

1057: EXCEPTION
1058: WHEN neg_app_amt THEN
1059: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1060: IF l_earned_concern = 'PBLINENEG' THEN
1061: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line applied amt is negative');
1062: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1063: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax applied amt is negative');
1064: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1065: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight applied amt is negative');

Line 1063: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax applied amt is negative');

1059: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1060: IF l_earned_concern = 'PBLINENEG' THEN
1061: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line applied amt is negative');
1062: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1063: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax applied amt is negative');
1064: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1065: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight applied amt is negative');
1066: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1067: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge applied amt is negative');

Line 1065: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight applied amt is negative');

1061: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line applied amt is negative');
1062: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1063: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax applied amt is negative');
1064: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1065: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight applied amt is negative');
1066: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1067: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge applied amt is negative');
1068: END IF;
1069: FND_MSG_PUB.ADD;

Line 1067: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge applied amt is negative');

1063: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax applied amt is negative');
1064: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1065: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight applied amt is negative');
1066: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1067: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge applied amt is negative');
1068: END IF;
1069: FND_MSG_PUB.ADD;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: WHEN neg_earned_amt THEN

Line 1072: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1068: END IF;
1069: FND_MSG_PUB.ADD;
1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: WHEN neg_earned_amt THEN
1072: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1073: IF l_earned_concern = 'PBLINENEG' THEN
1074: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line earned amt is negative');
1075: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1076: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax earned amt is negative');

Line 1074: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line earned amt is negative');

1070: x_return_status := FND_API.G_RET_STS_ERROR;
1071: WHEN neg_earned_amt THEN
1072: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1073: IF l_earned_concern = 'PBLINENEG' THEN
1074: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line earned amt is negative');
1075: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1076: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax earned amt is negative');
1077: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1078: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight earned amt is negative');

Line 1076: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax earned amt is negative');

1072: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1073: IF l_earned_concern = 'PBLINENEG' THEN
1074: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line earned amt is negative');
1075: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1076: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax earned amt is negative');
1077: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1078: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight earned amt is negative');
1079: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1080: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge earned amt is negative');

Line 1078: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight earned amt is negative');

1074: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line earned amt is negative');
1075: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1076: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax earned amt is negative');
1077: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1078: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight earned amt is negative');
1079: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1080: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge earned amt is negative');
1081: END IF;
1082: FND_MSG_PUB.ADD;

Line 1080: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge earned amt is negative');

1076: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax earned amt is negative');
1077: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1078: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight earned amt is negative');
1079: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1080: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge earned amt is negative');
1081: END IF;
1082: FND_MSG_PUB.ADD;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: WHEN neg_unearned_amt THEN

Line 1085: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1081: END IF;
1082: FND_MSG_PUB.ADD;
1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: WHEN neg_unearned_amt THEN
1085: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1086: IF l_earned_concern = 'PBLINENEG' THEN
1087: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line unearned amt is negative');
1088: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1089: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax unearned amt is negative');

Line 1087: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line unearned amt is negative');

1083: x_return_status := FND_API.G_RET_STS_ERROR;
1084: WHEN neg_unearned_amt THEN
1085: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1086: IF l_earned_concern = 'PBLINENEG' THEN
1087: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line unearned amt is negative');
1088: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1089: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax unearned amt is negative');
1090: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1091: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight unearned amt is negative');

Line 1089: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax unearned amt is negative');

1085: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1086: IF l_earned_concern = 'PBLINENEG' THEN
1087: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line unearned amt is negative');
1088: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1089: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax unearned amt is negative');
1090: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1091: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight unearned amt is negative');
1092: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1093: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge unearned amt is negative');

Line 1091: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight unearned amt is negative');

1087: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-line unearned amt is negative');
1088: ELSIF l_earned_concern = 'PBTAXNEG' THEN
1089: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax unearned amt is negative');
1090: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1091: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight unearned amt is negative');
1092: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1093: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge unearned amt is negative');
1094: END IF;
1095: FND_MSG_PUB.ADD;

Line 1093: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge unearned amt is negative');

1089: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-tax unearned amt is negative');
1090: ELSIF l_earned_concern = 'PBFRTNEG' THEN
1091: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-freight unearned amt is negative');
1092: ELSIF l_earned_concern = 'PBCHRGNEG' THEN
1093: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-charge unearned amt is negative');
1094: END IF;
1095: FND_MSG_PUB.ADD;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: WHEN OTHERS THEN

Line 1098: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1094: END IF;
1095: FND_MSG_PUB.ADD;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1099: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-'||SQLERRM );
1100: FND_MSG_PUB.ADD;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: arp_util.debug('EXCEPTION OTHERS arp_process_det_pkg.upd_inv_ps:'||SQLERRM );

Line 1099: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-'||SQLERRM );

1095: FND_MSG_PUB.ADD;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: WHEN OTHERS THEN
1098: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1099: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.upd_inv_ps-'||SQLERRM );
1100: FND_MSG_PUB.ADD;
1101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1102: arp_util.debug('EXCEPTION OTHERS arp_process_det_pkg.upd_inv_ps:'||SQLERRM );
1103: END upd_inv_ps;

Line 1259: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1255: arp_standard.debug('insert_rapps_p -');
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1259: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1260: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS insert_rapps_p:'||SQLERRM );
1261: FND_MSG_PUB.ADD;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: END insert_rapps_p;

Line 1260: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS insert_rapps_p:'||SQLERRM );

1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: arp_standard.debug('EXCEPTION insert_rapps_p OTHERS:'||SQLERRM);
1259: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1260: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS insert_rapps_p:'||SQLERRM );
1261: FND_MSG_PUB.ADD;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: END insert_rapps_p;
1264:

Line 1412: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1408: arp_standard.debug('res_ctl_rem_amt_for_app -');
1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1412: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1413: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_ctl_rem_amt_for_app:'||SQLERRM );
1414: FND_MSG_PUB.ADD;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: END res_ctl_rem_amt_for_app;

Line 1413: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_ctl_rem_amt_for_app:'||SQLERRM );

1409: EXCEPTION
1410: WHEN OTHERS THEN
1411: arp_standard.debug('EXCEPTION res_ctl_rem_amt_for_app OTHERS:'||SQLERRM);
1412: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1413: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_ctl_rem_amt_for_app:'||SQLERRM );
1414: FND_MSG_PUB.ADD;
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: END res_ctl_rem_amt_for_app;
1417:

Line 1479: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1475: arp_standard.debug('res_inv_ps -');
1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1479: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1480: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_inv_ps:'||SQLERRM );
1481: FND_MSG_PUB.ADD;
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: END res_inv_ps;

Line 1480: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_inv_ps:'||SQLERRM );

1476: EXCEPTION
1477: WHEN OTHERS THEN
1478: arp_standard.debug('EXCEPTION res_inv_ps OTHERS:'||SQLERRM);
1479: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1480: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS res_inv_ps:'||SQLERRM );
1481: FND_MSG_PUB.ADD;
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: END res_inv_ps;
1484:

Line 1526: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1522: arp_standard.debug('delete_application -');
1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1526: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1527: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS delete_application:'||SQLERRM );
1528: FND_MSG_PUB.ADD;
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: END delete_application;

Line 1527: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS delete_application:'||SQLERRM );

1523: EXCEPTION
1524: WHEN OTHERS THEN
1525: arp_standard.debug('EXCEPTION delete_application OTHERS:'||SQLERRM);
1526: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1527: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS delete_application:'||SQLERRM );
1528: FND_MSG_PUB.ADD;
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1530: END delete_application;
1531:

Line 1585: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1581: arp_standard.debug('copy_app_rec -');
1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1585: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1586: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS copy_app_rec:'||SQLERRM );
1587: FND_MSG_PUB.ADD;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: END copy_app_rec;

Line 1586: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS copy_app_rec:'||SQLERRM );

1582: EXCEPTION
1583: WHEN OTHERS THEN
1584: arp_standard.debug('EXCEPTION copy_app_rec OTHERS:'||SQLERRM);
1585: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1586: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS copy_app_rec:'||SQLERRM );
1587: FND_MSG_PUB.ADD;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: END copy_app_rec;
1590:

Line 1658: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1654: arp_standard.debug('do_apply -');
1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1658: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1659: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS do_apply:'||SQLERRM );
1660: FND_MSG_PUB.ADD;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: END do_apply;

Line 1659: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS do_apply:'||SQLERRM );

1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: arp_standard.debug('EXCEPTION do_apply OTHERS:'||SQLERRM);
1658: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1659: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS do_apply:'||SQLERRM );
1660: FND_MSG_PUB.ADD;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: END do_apply;
1663:

Line 1770: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1766: arp_standard.debug('apply -');
1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1770: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1771: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS apply:'||SQLERRM );
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: END apply;

Line 1771: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS apply:'||SQLERRM );

1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: arp_standard.debug('EXCEPTION apply OTHERS:'||SQLERRM);
1770: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1771: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS apply:'||SQLERRM );
1772: FND_MSG_PUB.ADD;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: END apply;
1775:

Line 1988: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' );

1984: EXCEPTION
1985: WHEN no_sys_param THEN
1986: ROLLBACK TO initialization;
1987: arp_standard.debug('EXCEPTION initialization no_sys_param');
1988: FND_MESSAGE.SET_NAME( 'AR', 'AR_NO_ROW_IN_SYSTEM_PARAMETERS' );
1989: FND_MSG_PUB.ADD;
1990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1992: p_count => x_msg_count,

Line 1997: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

1993: p_data => x_msg_data);
1994: WHEN not_valid_trx THEN
1995: ROLLBACK TO initialization;
1996: arp_standard.debug('EXCEPTION initialization not_valid_trx');
1997: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1998: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||
1999: p_customer_trx_id );
2000: FND_MSG_PUB.ADD;
2001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1998: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||

1994: WHEN not_valid_trx THEN
1995: ROLLBACK TO initialization;
1996: arp_standard.debug('EXCEPTION initialization not_valid_trx');
1997: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
1998: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_trx initialization p_customer_trx_id:'||
1999: p_customer_trx_id );
2000: FND_MSG_PUB.ADD;
2001: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2002: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2008: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2004: p_data => x_msg_data);
2005: WHEN not_valid_cr THEN
2006: ROLLBACK TO initialization;
2007: arp_standard.debug('EXCEPTION initialization not_valid_cr');
2008: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2009: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||
2010: p_cash_receipt_id );
2011: FND_MSG_PUB.ADD;
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2009: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||

2005: WHEN not_valid_cr THEN
2006: ROLLBACK TO initialization;
2007: arp_standard.debug('EXCEPTION initialization not_valid_cr');
2008: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2009: FND_MESSAGE.SET_TOKEN( 'TEXT', 'not_valid_cr initialization p_cash_receipt_id:'||
2010: p_cash_receipt_id );
2011: FND_MSG_PUB.ADD;
2012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2028: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTORULE_ERROR' );

2024: OPEN c_trx_number(p_customer_trx_id);
2025: FETCH c_trx_number INTO l_trx_number;
2026: CLOSE c_trx_number;
2027: arp_standard.debug('Error in Rev Rec - ARP_AUTO_RULE.create_distributions for trx_id :'||p_customer_trx_id);
2028: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTORULE_ERROR' );
2029: FND_MESSAGE.SET_TOKEN( 'TRX_NUMBER', l_trx_number );
2030: FND_MSG_PUB.ADD;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2029: FND_MESSAGE.SET_TOKEN( 'TRX_NUMBER', l_trx_number );

2025: FETCH c_trx_number INTO l_trx_number;
2026: CLOSE c_trx_number;
2027: arp_standard.debug('Error in Rev Rec - ARP_AUTO_RULE.create_distributions for trx_id :'||p_customer_trx_id);
2028: FND_MESSAGE.SET_NAME( 'AR', 'AR_AUTORULE_ERROR' );
2029: FND_MESSAGE.SET_TOKEN( 'TRX_NUMBER', l_trx_number );
2030: FND_MSG_PUB.ADD;
2031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2032: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2033: p_count => x_msg_count,

Line 2039: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2035:
2036: WHEN OTHERS THEN
2037: ROLLBACK TO initialization;
2038: arp_standard.debug('EXCEPTION initialization OTHERS:'||SQLERRM);
2039: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2040: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );
2041: FND_MSG_PUB.ADD;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2040: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );

2036: WHEN OTHERS THEN
2037: ROLLBACK TO initialization;
2038: arp_standard.debug('EXCEPTION initialization OTHERS:'||SQLERRM);
2039: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2040: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS initialization:'||SQLERRM );
2041: FND_MSG_PUB.ADD;
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2044: p_count => x_msg_count,

Line 2144: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2140: RETURN l_res;
2141: EXCEPTION
2142: WHEN OTHERS THEN
2143: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2144: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2145: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS cur_app_gt_id:'||SQLERRM );
2146: FND_MSG_PUB.ADD;
2147: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2148: END cur_app_gt_id;

Line 2145: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS cur_app_gt_id:'||SQLERRM );

2141: EXCEPTION
2142: WHEN OTHERS THEN
2143: arp_standard.debug('EXCEPTION cur_app_gt_id OTHERS:'||SQLERRM);
2144: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2145: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS cur_app_gt_id:'||SQLERRM );
2146: FND_MSG_PUB.ADD;
2147: RETURN FND_API.G_RET_STS_UNEXP_ERROR;
2148: END cur_app_gt_id;
2149:

Line 2283: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2279: WHEN unexpected_error THEN
2280: ROLLBACK TO first_delete_then_apply;
2281: arp_standard.debug('EXCEPTION first_delete_then_apply unexpected_error - p_app_level:'
2282: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2283: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2284: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'
2285: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2286: FND_MSG_PUB.ADD;
2287: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2284: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'

2280: ROLLBACK TO first_delete_then_apply;
2281: arp_standard.debug('EXCEPTION first_delete_then_apply unexpected_error - p_app_level:'
2282: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2283: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2284: FND_MESSAGE.SET_TOKEN( 'TEXT', 'Unexpected first_delete_then_apply - p_app_level:'
2285: ||p_app_level||' - p_source_data_key1 :'||p_source_data_key1 ||' - p_ctl_id :'||p_ctl_id);
2286: FND_MSG_PUB.ADD;
2287: x_return_status := FND_API.G_RET_STS_ERROR;
2288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2294: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2290: p_data => x_msg_data);
2291: WHEN OTHERS THEN
2292: ROLLBACK TO first_delete_then_apply;
2293: arp_standard.debug('EXCEPTION first_delete_then_apply OTHERS:'||SQLERRM);
2294: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2295: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );
2296: FND_MSG_PUB.ADD;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

Line 2295: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );

2291: WHEN OTHERS THEN
2292: ROLLBACK TO first_delete_then_apply;
2293: arp_standard.debug('EXCEPTION first_delete_then_apply OTHERS:'||SQLERRM);
2294: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2295: FND_MESSAGE.SET_TOKEN( 'TEXT', 'OTHERS first_delete_then_apply:'||SQLERRM );
2296: FND_MSG_PUB.ADD;
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2299: p_count => x_msg_count,

Line 2662: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: ROLLBACK TO final_commit;
2661: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2662: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2663: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.final_commit-'||SQLERRM );
2664: FND_MSG_PUB.ADD;
2665: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2666: p_count => x_msg_count,

Line 2663: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.final_commit-'||SQLERRM );

2659: WHEN OTHERS THEN
2660: ROLLBACK TO final_commit;
2661: arp_standard.debug('EXCEPTION OTHERS final_commit:'||SQLERRM);
2662: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2663: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.final_commit-'||SQLERRM );
2664: FND_MSG_PUB.ADD;
2665: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2666: p_count => x_msg_count,
2667: p_data => x_msg_data);

Line 2765: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2761: arp_standard.debug('get_latest_amount_remaining -');
2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2765: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2766: FND_MESSAGE.SET_TOKEN( 'TEXT', 'get_latest_amount_remaining NO_DATA_FOUND
2767: customer_trx_id :'||g_customer_trx.customer_trx_id||'
2768: p_app_level :'||p_app_level||'
2769: p_ctl_id :'||p_ctl_id);

Line 2766: FND_MESSAGE.SET_TOKEN( 'TEXT', 'get_latest_amount_remaining NO_DATA_FOUND

2762: EXCEPTION
2763: WHEN NO_DATA_FOUND THEN
2764: arp_standard.debug('EXCEPTION NO_DATA_FOUND get_latest_amount_remaining:'||SQLERRM);
2765: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2766: FND_MESSAGE.SET_TOKEN( 'TEXT', 'get_latest_amount_remaining NO_DATA_FOUND
2767: customer_trx_id :'||g_customer_trx.customer_trx_id||'
2768: p_app_level :'||p_app_level||'
2769: p_ctl_id :'||p_ctl_id);
2770: FND_MSG_PUB.ADD;

Line 2777: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

2773: p_data => x_msg_data);
2774: x_return_status := FND_API.G_RET_STS_SUCCESS;
2775: WHEN OTHERS THEN
2776: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_remaining:'||SQLERRM);
2777: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2778: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );
2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2781: p_count => x_msg_count,

Line 2778: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );

2774: x_return_status := FND_API.G_RET_STS_SUCCESS;
2775: WHEN OTHERS THEN
2776: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_remaining:'||SQLERRM);
2777: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
2778: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_remaining-'||SQLERRM );
2779: FND_MSG_PUB.ADD;
2780: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2781: p_count => x_msg_count,
2782: p_data => x_msg_data);

Line 3115: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );

3111: arp_standard.debug('get_latest_amount_applied -');
3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3115: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3116: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_applied-'||SQLERRM );
3117: FND_MSG_PUB.ADD;
3118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3119: p_count => x_msg_count,

Line 3116: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_applied-'||SQLERRM );

3112: EXCEPTION
3113: WHEN OTHERS THEN
3114: arp_standard.debug('EXCEPTION OTHERS get_latest_amount_applied:'||SQLERRM);
3115: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR' );
3116: FND_MESSAGE.SET_TOKEN( 'TEXT', 'arp_process_det_pkg.get_latest_amount_applied-'||SQLERRM );
3117: FND_MSG_PUB.ADD;
3118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
3119: p_count => x_msg_count,
3120: p_data => x_msg_data);

Line 3220: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3216:
3217: IF p_gt_id IS NULL THEN
3218: x_return_status := fnd_api.g_ret_sts_error;
3219: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3220: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3221: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3222: FND_MSG_PUB.ADD;
3223: ELSE
3224:

Line 3221: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');

3217: IF p_gt_id IS NULL THEN
3218: x_return_status := fnd_api.g_ret_sts_error;
3219: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3220: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3221: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3222: FND_MSG_PUB.ADD;
3223: ELSE
3224:
3225: IF ((p_adj_rec.amount IS NULL) AND (p_adj_rec.acctd_amount IS NULL))

Line 3231: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3227: ((p_adj_rec.amount = 0 ) AND (p_adj_rec.acctd_amount = 0 ))
3228: THEN
3229: x_return_status := fnd_api.g_ret_sts_error;
3230: arp_standard.debug(' Adjustment record amount and accounted amount causes no need to execute');
3231: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3232: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record amount and accounted amount causes no need to execute');
3233: FND_MSG_PUB.ADD;
3234: ELSIF ((p_adj_rec.amount IS NULL) AND (p_adj_rec.acctd_amount IS NOT NULL))
3235: OR

Line 3232: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record amount and accounted amount causes no need to execute');

3228: THEN
3229: x_return_status := fnd_api.g_ret_sts_error;
3230: arp_standard.debug(' Adjustment record amount and accounted amount causes no need to execute');
3231: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3232: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record amount and accounted amount causes no need to execute');
3233: FND_MSG_PUB.ADD;
3234: ELSIF ((p_adj_rec.amount IS NULL) AND (p_adj_rec.acctd_amount IS NOT NULL))
3235: OR
3236: ((p_adj_rec.amount = 0 ) AND (p_adj_rec.acctd_amount <> 0 ))

Line 3243: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3239: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: arp_standard.debug(' Adjustment record combination causes an invalid combination');
3243: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3244: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record combination causes an invalid combination');
3245: FND_MSG_PUB.ADD;
3246: END IF;
3247:

Line 3244: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record combination causes an invalid combination');

3240: THEN
3241: x_return_status := fnd_api.g_ret_sts_error;
3242: arp_standard.debug(' Adjustment record combination causes an invalid combination');
3243: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3244: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment record combination causes an invalid combination');
3245: FND_MSG_PUB.ADD;
3246: END IF;
3247:
3248: OPEN verif_amt;

Line 3260: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3256: IF (l_sum_line = NULL) AND (l_sum_tax = NULL )
3257: THEN
3258: x_return_status := fnd_api.g_ret_sts_error;
3259: arp_standard.debug(' There is no line amount and tax amount in the interface table for this adjustment');
3260: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3261: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount and tax amount in the interface table for adjustment -'||
3262: ' adjustment_id : ' || p_adj_rec.adjustment_id);
3263: END IF;
3264:

Line 3261: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount and tax amount in the interface table for adjustment -'||

3257: THEN
3258: x_return_status := fnd_api.g_ret_sts_error;
3259: arp_standard.debug(' There is no line amount and tax amount in the interface table for this adjustment');
3260: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3261: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount and tax amount in the interface table for adjustment -'||
3262: ' adjustment_id : ' || p_adj_rec.adjustment_id);
3263: END IF;
3264:
3265:

Line 3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3265:
3266: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3267: x_return_status := fnd_api.g_ret_sts_error;
3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3271: FND_MSG_PUB.ADD;
3272: END IF;
3273:

Line 3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');

3266: IF (p_line_flag = 'Y') AND (l_sum_line <> p_adj_rec.line_adjusted) THEN
3267: x_return_status := fnd_api.g_ret_sts_error;
3268: arp_standard.debug(' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3269: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3270: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment line_adjusted <> l_sum_line from ar_line_dist_interface_gt');
3271: FND_MSG_PUB.ADD;
3272: END IF;
3273:
3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN

Line 3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3273:
3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3279: FND_MSG_PUB.ADD;
3280: END IF;
3281:

Line 3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');

3274: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_adj_rec.tax_adjusted) THEN
3275: x_return_status := fnd_api.g_ret_sts_error;
3276: arp_standard.debug(' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3277: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3278: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted <> l_sum_tax from ar_line_dist_interface_gt');
3279: FND_MSG_PUB.ADD;
3280: END IF;
3281:
3282: END IF;

Line 3337: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3333:
3334: IF p_gt_id IS NULL THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3336: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3337: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3338: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3339: FND_MSG_PUB.ADD;
3340: ELSE
3341:

Line 3338: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');

3334: IF p_gt_id IS NULL THEN
3335: x_return_status := fnd_api.g_ret_sts_error;
3336: arp_standard.debug(' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3337: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3338: FND_MESSAGE.SET_TOKEN('TEXT',' p_gt_id IS NULL, please excecute arp_det_dist_pkg.get_gt_sequence');
3339: FND_MSG_PUB.ADD;
3340: ELSE
3341:
3342: IF ((p_app_rec.amount_applied IS NULL) AND (p_app_rec.acctd_amount_applied_to IS NULL))

Line 3349: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3345: THEN
3346: x_return_status := fnd_api.g_ret_sts_error;
3347: arp_standard.debug(' Application record amount and accounted amount to causes no need to execute'||
3348: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3349: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3350: FND_MESSAGE.SET_TOKEN('TEXT',' Application record amount and accounted amount to causes no need to execute'||
3351: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3352: FND_MSG_PUB.ADD;
3353: ELSIF ((p_app_rec.amount_applied IS NULL) AND (p_app_rec.acctd_amount_applied_to IS NOT NULL))

Line 3350: FND_MESSAGE.SET_TOKEN('TEXT',' Application record amount and accounted amount to causes no need to execute'||

3346: x_return_status := fnd_api.g_ret_sts_error;
3347: arp_standard.debug(' Application record amount and accounted amount to causes no need to execute'||
3348: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3349: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3350: FND_MESSAGE.SET_TOKEN('TEXT',' Application record amount and accounted amount to causes no need to execute'||
3351: ' as no amount in amount_applied and acctd_amount_applied_to bucket');
3352: FND_MSG_PUB.ADD;
3353: ELSIF ((p_app_rec.amount_applied IS NULL) AND (p_app_rec.acctd_amount_applied_to IS NOT NULL))
3354: OR

Line 3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3358: (p_customer_trx.invoice_currency_code = p_ae_sys_rec.base_currency))
3359: THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: arp_standard.debug(' Application record combination causes an invalid combination on amount bucket');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: FND_MESSAGE.SET_TOKEN('TEXT',' Application record combination causes an invalid combination');
3364: FND_MSG_PUB.ADD;
3365: END IF;
3366:

Line 3363: FND_MESSAGE.SET_TOKEN('TEXT',' Application record combination causes an invalid combination');

3359: THEN
3360: x_return_status := fnd_api.g_ret_sts_error;
3361: arp_standard.debug(' Application record combination causes an invalid combination on amount bucket');
3362: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3363: FND_MESSAGE.SET_TOKEN('TEXT',' Application record combination causes an invalid combination');
3364: FND_MSG_PUB.ADD;
3365: END IF;
3366:
3367: OPEN verif_amt;

Line 3399: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3395: (l_sum_uned_line = NULL) AND (l_sum_uned_tax = NULL )
3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_error;
3398: arp_standard.debug(' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application');
3399: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3400: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application'||
3401: ' receivable_application_id : ' || p_app_rec.receivable_application_id);
3402: END IF;
3403:

Line 3400: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application'||

3396: THEN
3397: x_return_status := fnd_api.g_ret_sts_error;
3398: arp_standard.debug(' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application');
3399: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3400: FND_MESSAGE.SET_TOKEN('TEXT',' There is no line amount, tax amount for app, edisc and unedisc in the interface table for this application'||
3401: ' receivable_application_id : ' || p_app_rec.receivable_application_id);
3402: END IF;
3403:
3404:

Line 3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3404:
3405: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3406: x_return_status := fnd_api.g_ret_sts_error;
3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3410: FND_MSG_PUB.ADD;
3411: END IF;
3412:

Line 3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');

3405: IF (p_line_flag = 'Y') AND (l_sum_line <> p_app_rec.line_applied) THEN
3406: x_return_status := fnd_api.g_ret_sts_error;
3407: arp_standard.debug(' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3408: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3409: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_applied ('||p_app_rec.line_applied||')<> l_sum_line('||l_sum_line||') from ar_line_dist_interface_gt');
3410: FND_MSG_PUB.ADD;
3411: END IF;
3412:
3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN

Line 3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3412:
3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3414: x_return_status := fnd_api.g_ret_sts_error;
3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3418: FND_MSG_PUB.ADD;
3419: END IF;
3420:

Line 3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');

3413: IF (p_tax_flag = 'Y') AND (l_sum_tax <> p_app_rec.tax_applied) THEN
3414: x_return_status := fnd_api.g_ret_sts_error;
3415: arp_standard.debug(' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3416: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3417: FND_MESSAGE.SET_TOKEN('TEXT',' Adjustment tax_adjusted ('||p_app_rec.tax_applied||')<> l_sum_tax('||l_sum_tax||') from ar_line_dist_interface_gt');
3418: FND_MSG_PUB.ADD;
3419: END IF;
3420:
3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN

Line 3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3420:
3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3426: FND_MSG_PUB.ADD;
3427: END IF;
3428:

Line 3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');

3421: IF (p_ed_line_flag = 'Y') AND (l_sum_ed_line <> p_app_rec.LINE_EDISCOUNTED) THEN
3422: x_return_status := fnd_api.g_ret_sts_error;
3423: arp_standard.debug(' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3424: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3425: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_ediscounted ('||p_app_rec.LINE_EDISCOUNTED||')<> l_sum_ed_line('||l_sum_ed_line||') from ar_line_dist_interface_gt');
3426: FND_MSG_PUB.ADD;
3427: END IF;
3428:
3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN

Line 3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3428:
3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3430: x_return_status := fnd_api.g_ret_sts_error;
3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3434: FND_MSG_PUB.ADD;
3435: END IF;
3436:

Line 3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');

3429: IF (p_ed_tax_flag = 'Y') AND (l_sum_ed_tax <> p_app_rec.TAX_EDISCOUNTED) THEN
3430: x_return_status := fnd_api.g_ret_sts_error;
3431: arp_standard.debug(' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3432: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3433: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_ediscounted ('||p_app_rec.tax_EDISCOUNTED||')<> l_sum_ed_tax('||l_sum_ed_tax||') from ar_line_dist_interface_gt');
3434: FND_MSG_PUB.ADD;
3435: END IF;
3436:
3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN

Line 3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3436:
3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3438: x_return_status := fnd_api.g_ret_sts_error;
3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3442: FND_MSG_PUB.ADD;
3443: END IF;
3444:

Line 3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');

3437: IF (p_uned_line_flag = 'Y') AND (l_sum_uned_line <> p_app_rec.LINE_uEDISCOUNTED) THEN
3438: x_return_status := fnd_api.g_ret_sts_error;
3439: arp_standard.debug(' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3440: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3441: FND_MESSAGE.SET_TOKEN('TEXT',' Application line_uediscounted ('||p_app_rec.LINE_uEDISCOUNTED||')<> l_sum_uned_line('||l_sum_uned_line||') from ar_line_dist_interface_gt');
3442: FND_MSG_PUB.ADD;
3443: END IF;
3444:
3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN

Line 3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');

3444:
3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3446: x_return_status := fnd_api.g_ret_sts_error;
3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3450: FND_MSG_PUB.ADD;
3451: END IF;
3452:

Line 3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');

3445: IF (p_uned_tax_flag = 'Y') AND (l_sum_uned_tax <> p_app_rec.TAX_uEDISCOUNTED) THEN
3446: x_return_status := fnd_api.g_ret_sts_error;
3447: arp_standard.debug(' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3448: FND_MESSAGE.SET_NAME( 'AR', 'AR_CUST_API_ERROR');
3449: FND_MESSAGE.SET_TOKEN('TEXT',' Application tax_uediscounted ('||p_app_rec.tax_uEDISCOUNTED||')<> l_sum_uned_tax('||l_sum_uned_tax||') from ar_line_dist_interface_gt');
3450: FND_MSG_PUB.ADD;
3451: END IF;
3452:
3453: END IF;