DBA Data[Home] [Help]

APPS.AR_CM_APP_VAL_PVT dependencies on FND_MESSAGE

Line 30: FND_MESSAGE.SET_NAME('AR','AR_VAL_GL_INV_GL');

26: IF p_apply_gl_date IS NOT NULL THEN
27:
28: -- Check that the application GL Date is not before the invoice GL Date.
29: IF p_apply_gl_date < p_trx_gl_date THEN
30: FND_MESSAGE.SET_NAME('AR','AR_VAL_GL_INV_GL');
31: FND_MSG_PUB.Add;
32: p_return_status := FND_API.G_RET_STS_ERROR;
33: END IF;
34:

Line 37: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );

33: END IF;
34:
35: -- Check that the Application GL Date is in an open or future GL period.
36: IF ( NOT arp_util.is_gl_date_valid( p_apply_gl_date )) THEN
37: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
38: --Int'l Calendar Project
39: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
40: FND_MSG_PUB.Add;
41: p_return_status := FND_API.G_RET_STS_ERROR;

Line 39: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));

35: -- Check that the Application GL Date is in an open or future GL period.
36: IF ( NOT arp_util.is_gl_date_valid( p_apply_gl_date )) THEN
37: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
38: --Int'l Calendar Project
39: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
40: FND_MSG_PUB.Add;
41: p_return_status := FND_API.G_RET_STS_ERROR;
42: END IF;
43:

Line 66: FND_MESSAGE.SET_NAME('AR','AR_APPLY_BEFORE_TRANSACTION');

62: IF p_apply_date IS NOT NULL THEN
63:
64: -- check that the apply date is not before the invoice date.
65: IF p_apply_date < p_trx_date THEN
66: FND_MESSAGE.SET_NAME('AR','AR_APPLY_BEFORE_TRANSACTION');
67: FND_MSG_PUB.Add;
68: p_return_status := FND_API.G_RET_STS_ERROR;
69: END IF;
70:

Line 104: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');

100: IF PG_DEBUG in ('Y', 'C') THEN
101: arp_util.debug('Validate_amount_applied_from: ' || 'l_remaining_unapp_cm_amt :'||to_char(l_remaining_unapp_cm_amt));
102: END IF;
103: p_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');
105: FND_MSG_PUB.Add;
106: END IF;
107: IF PG_DEBUG in ('Y', 'C') THEN
108: arp_util.debug('Validate_amount_applied_from ()-');

Line 127: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');

123: p_return_status := FND_API.G_RET_STS_SUCCESS;
124: IF p_reversal_gl_date IS NOT NULL THEN
125:
126: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
127: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
128: --Int'l Calendar Project
129: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
130: FND_MSG_PUB.Add;
131: p_return_status := FND_API.G_RET_STS_ERROR;

Line 129: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));

125:
126: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
127: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
128: --Int'l Calendar Project
129: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
130: FND_MSG_PUB.Add;
131: p_return_status := FND_API.G_RET_STS_ERROR;
132: END IF;
133: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN

Line 134: FND_MESSAGE.SET_NAME('AR','AR_REF_BEFORE_CM_GL_DATE');

130: FND_MSG_PUB.Add;
131: p_return_status := FND_API.G_RET_STS_ERROR;
132: END IF;
133: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
134: FND_MESSAGE.SET_NAME('AR','AR_REF_BEFORE_CM_GL_DATE');
135: --Int'l Calendar Project
136: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_cm_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
137: FND_MSG_PUB.Add;
138: p_return_status := FND_API.G_RET_STS_ERROR;

Line 136: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_cm_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));

132: END IF;
133: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
134: FND_MESSAGE.SET_NAME('AR','AR_REF_BEFORE_CM_GL_DATE');
135: --Int'l Calendar Project
136: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_cm_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
137: FND_MSG_PUB.Add;
138: p_return_status := FND_API.G_RET_STS_ERROR;
139: END IF;
140:

Line 142: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );

138: p_return_status := FND_API.G_RET_STS_ERROR;
139: END IF;
140:
141: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
142: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
143: --Int'l Calendar Project
144: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_reversal_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
145: FND_MSG_PUB.Add;
146: p_return_status := FND_API.G_RET_STS_ERROR;

Line 144: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_reversal_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));

140:
141: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
142: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
143: --Int'l Calendar Project
144: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_reversal_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
145: FND_MSG_PUB.Add;
146: p_return_status := FND_API.G_RET_STS_ERROR;
147: END IF;
148:

Line 150: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');

146: p_return_status := FND_API.G_RET_STS_ERROR;
147: END IF;
148:
149: ELSE
150: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');
151: FND_MSG_PUB.Add;
152: p_return_status := FND_API.G_RET_STS_ERROR;
153: IF PG_DEBUG in ('Y', 'C') THEN
154: arp_util.debug('Validate_Rev_gl_date: ' || 'The Reversal gl date is null ');

Line 190: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');

186: and ra.status = p_application_type
187: and ra.application_type = 'CM';
188:
189: IF l_valid = 0 THEN
190: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
191: FND_MSG_PUB.Add;
192: p_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194:

Line 196: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');

192: p_return_status := FND_API.G_RET_STS_ERROR;
193: END IF;
194:
195: ELSIF p_receivable_application_id IS NULL THEN
196: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
197: FND_MSG_PUB.Add;
198: p_return_status := FND_API.G_RET_STS_ERROR;
199:
200: END IF;

Line 241: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_TRX_ID_INVALID');

237:
238: OPEN activity_type;
239: FETCH activity_type INTO l_activity_type;
240: IF activity_type%NOTFOUND THEN
241: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_TRX_ID_INVALID');
242: FND_MSG_PUB.Add;
243: p_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245: CLOSE activity_type;

Line 252: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');

248: --Validate applied ps_id
249: IF p_applied_ps_id = -8 THEN
250: --6865230
251: IF l_activity_type <> 'CM_REFUND' THEN
252: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
253: FND_MSG_PUB.Add;
254: p_return_status := FND_API.G_RET_STS_ERROR;
255: END IF;
256:

Line 296: fnd_message.set_name ('AR','AR_REF_USR_LMT_OUT_OF_RANGE');

292:
293: IF (NVL(l_tot_cmref_amt,0) > l_amount_to) OR
294: (NVL(l_tot_cmref_amt,l_amount_from) < l_amount_from)
295: THEN
296: fnd_message.set_name ('AR','AR_REF_USR_LMT_OUT_OF_RANGE');
297: fnd_message.set_token('FROM_AMOUNT', to_char(l_amount_from), FALSE);
298: fnd_message.set_token('TO_AMOUNT', to_char(l_amount_to), FALSE);
299: FND_MSG_PUB.Add;
300: p_return_status := FND_API.G_RET_STS_ERROR;

Line 297: fnd_message.set_token('FROM_AMOUNT', to_char(l_amount_from), FALSE);

293: IF (NVL(l_tot_cmref_amt,0) > l_amount_to) OR
294: (NVL(l_tot_cmref_amt,l_amount_from) < l_amount_from)
295: THEN
296: fnd_message.set_name ('AR','AR_REF_USR_LMT_OUT_OF_RANGE');
297: fnd_message.set_token('FROM_AMOUNT', to_char(l_amount_from), FALSE);
298: fnd_message.set_token('TO_AMOUNT', to_char(l_amount_to), FALSE);
299: FND_MSG_PUB.Add;
300: p_return_status := FND_API.G_RET_STS_ERROR;
301: END IF;

Line 298: fnd_message.set_token('TO_AMOUNT', to_char(l_amount_to), FALSE);

294: (NVL(l_tot_cmref_amt,l_amount_from) < l_amount_from)
295: THEN
296: fnd_message.set_name ('AR','AR_REF_USR_LMT_OUT_OF_RANGE');
297: fnd_message.set_token('FROM_AMOUNT', to_char(l_amount_from), FALSE);
298: fnd_message.set_token('TO_AMOUNT', to_char(l_amount_to), FALSE);
299: FND_MSG_PUB.Add;
300: p_return_status := FND_API.G_RET_STS_ERROR;
301: END IF;
302:

Line 307: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');

303: END IF;
304:
305: ELSE
306: --the applied payment schedule id is invalid
307: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
308: FND_MSG_PUB.Add;
309: p_return_status := FND_API.G_RET_STS_ERROR;
310: END IF; --additional control structures to be added for new activity types.
311: END IF;

Line 372: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APPLIED_AMT_NULL');

368: );
369:
370: -- validate amount applied
371: IF p_amount_applied IS NULL THEN
372: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APPLIED_AMT_NULL');
373: FND_MSG_PUB.Add;
374: l_amt_return_status := FND_API.G_RET_STS_ERROR;
375:
376: ELSIF (p_amount_applied < 0 AND NVL(p_applied_ps_id,-8) = -8) THEN

Line 377: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_APP_NEG');

373: FND_MSG_PUB.Add;
374: l_amt_return_status := FND_API.G_RET_STS_ERROR;
375:
376: ELSIF (p_amount_applied < 0 AND NVL(p_applied_ps_id,-8) = -8) THEN
377: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_APP_NEG');
378: FND_MSG_PUB.Add;
379: l_amt_return_status := FND_API.G_RET_STS_ERROR;
380: -- Bug 2897244 - amount not checked if called from form
381: ELSIF ((nvl(p_cm_unapp_amount,0)- p_amount_applied) < 0 AND

Line 383: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');

379: l_amt_return_status := FND_API.G_RET_STS_ERROR;
380: -- Bug 2897244 - amount not checked if called from form
381: ELSIF ((nvl(p_cm_unapp_amount,0)- p_amount_applied) < 0 AND
382: NVL(p_called_from,'RAPI') <> 'ARXRWAPP') THEN
383: FND_MESSAGE.SET_NAME('AR','AR_CKAP_OVERAPP');
384: FND_MSG_PUB.Add;
385: l_amt_return_status := FND_API.G_RET_STS_ERROR;
386: END IF;
387:

Line 516: FND_MESSAGE.SET_NAME('AR','AR_REF_NOT_OACM');

512: l_remit_flag,
513: l_remittance_ccid;
514: CLOSE c_cm;
515: IF l_previous_customer_trx_id IS NOT NULL THEN
516: FND_MESSAGE.SET_NAME('AR','AR_REF_NOT_OACM');
517: FND_MSG_PUB.Add;
518: p_return_status := FND_API.G_RET_STS_ERROR;
519: END IF;
520: IF NVL(l_complete_flag,'N') <> 'Y' THEN

Line 521: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_INCOMPLETE');

517: FND_MSG_PUB.Add;
518: p_return_status := FND_API.G_RET_STS_ERROR;
519: END IF;
520: IF NVL(l_complete_flag,'N') <> 'Y' THEN
521: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_INCOMPLETE');
522: FND_MSG_PUB.Add;
523: p_return_status := FND_API.G_RET_STS_ERROR;
524: ELSE
525: OPEN c_ps;

Line 531: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_POSITIVE');

527: CLOSE c_ps;
528: /* Bug 4203308 - checks the original amount for positive CM condition
529: instead of amount due which may be positive due to overapplication */
530: IF l_amount_due_original > 0 THEN
531: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_POSITIVE');
532: FND_MSG_PUB.Add;
533: p_return_status := FND_API.G_RET_STS_ERROR;
534: END IF;
535: IF l_amount_due_remaining >= 0 THEN

Line 536: FND_MESSAGE.SET_NAME('AR','AR_REF_MORE_THAN_CM_AMT');

532: FND_MSG_PUB.Add;
533: p_return_status := FND_API.G_RET_STS_ERROR;
534: END IF;
535: IF l_amount_due_remaining >= 0 THEN
536: FND_MESSAGE.SET_NAME('AR','AR_REF_MORE_THAN_CM_AMT');
537: FND_MSG_PUB.Add;
538: p_return_status := FND_API.G_RET_STS_ERROR;
539: END IF;
540: END IF;

Line 546: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');

542: arp_util.debug('validate_credit_memo (-)');
543: END IF;
544: EXCEPTION
545: WHEN OTHERS THEN
546: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');
547: FND_MSG_PUB.Add;
548: p_return_status := FND_API.G_RET_STS_ERROR;
549:
550: END validate_credit_memo;