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: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_apply_gl_date ));
39: FND_MSG_PUB.Add;
40: p_return_status := FND_API.G_RET_STS_ERROR;
41: END IF;

Line 38: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_apply_gl_date ));

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: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_apply_gl_date ));
39: FND_MSG_PUB.Add;
40: p_return_status := FND_API.G_RET_STS_ERROR;
41: END IF;
42:

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

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

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

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

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

122: p_return_status := FND_API.G_RET_STS_SUCCESS;
123: IF p_reversal_gl_date IS NOT NULL THEN
124:
125: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
126: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
127: FND_MESSAGE.SET_TOKEN('GL_DATE', p_apply_gl_date);
128: FND_MSG_PUB.Add;
129: p_return_status := FND_API.G_RET_STS_ERROR;
130: END IF;

Line 127: FND_MESSAGE.SET_TOKEN('GL_DATE', p_apply_gl_date);

123: IF p_reversal_gl_date IS NOT NULL THEN
124:
125: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
126: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
127: FND_MESSAGE.SET_TOKEN('GL_DATE', p_apply_gl_date);
128: FND_MSG_PUB.Add;
129: p_return_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN

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

128: FND_MSG_PUB.Add;
129: p_return_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
132: FND_MESSAGE.SET_NAME('AR','AR_REF_BEFORE_CM_GL_DATE');
133: FND_MESSAGE.SET_TOKEN('GL_DATE', p_cm_gl_date);
134: FND_MSG_PUB.Add;
135: p_return_status := FND_API.G_RET_STS_ERROR;
136: END IF;

Line 133: FND_MESSAGE.SET_TOKEN('GL_DATE', p_cm_gl_date);

129: p_return_status := FND_API.G_RET_STS_ERROR;
130: END IF;
131: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
132: FND_MESSAGE.SET_NAME('AR','AR_REF_BEFORE_CM_GL_DATE');
133: FND_MESSAGE.SET_TOKEN('GL_DATE', p_cm_gl_date);
134: FND_MSG_PUB.Add;
135: p_return_status := FND_API.G_RET_STS_ERROR;
136: END IF;
137:

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

135: p_return_status := FND_API.G_RET_STS_ERROR;
136: END IF;
137:
138: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
139: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
140: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_reversal_gl_date ));
141: FND_MSG_PUB.Add;
142: p_return_status := FND_API.G_RET_STS_ERROR;
143: END IF;

Line 140: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_reversal_gl_date ));

136: END IF;
137:
138: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
139: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
140: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_reversal_gl_date ));
141: FND_MSG_PUB.Add;
142: p_return_status := FND_API.G_RET_STS_ERROR;
143: END IF;
144:

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

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

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

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

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

188: p_return_status := FND_API.G_RET_STS_ERROR;
189: END IF;
190:
191: ELSIF p_receivable_application_id IS NULL THEN
192: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
193: FND_MSG_PUB.Add;
194: p_return_status := FND_API.G_RET_STS_ERROR;
195:
196: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

528: FND_MSG_PUB.Add;
529: p_return_status := FND_API.G_RET_STS_ERROR;
530: END IF;
531: IF l_amount_due_remaining >= 0 THEN
532: FND_MESSAGE.SET_NAME('AR','AR_REF_MORE_THAN_CM_AMT');
533: FND_MSG_PUB.Add;
534: p_return_status := FND_API.G_RET_STS_ERROR;
535: END IF;
536: END IF;

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

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