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_CM_APP_VAL_PVT dependencies on FND_MSG_PUB

Line 5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

1: Package Body AR_CM_APP_VAL_PVT AS
2: /* $Header: ARXCMAVB.pls 120.5.12010000.2 2008/11/11 13:28:35 npanchak ship $ */
3: --Validation procedures are contained in this package
4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

Line 6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

2: /* $Header: ARXCMAVB.pls 120.5.12010000.2 2008/11/11 13:28:35 npanchak ship $ */
3: --Validation procedures are contained in this package
4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

Line 7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

3: --Validation procedures are contained in this package
4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11:

Line 8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

4:
5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11:
12: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

5: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11:
12: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
13:

Line 10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

6: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
7: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
8: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
9: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
10: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
11:
12: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
13:
14: PROCEDURE Validate_apply_gl_date(p_apply_gl_date IN DATE,

Line 31: FND_MSG_PUB.Add;

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:
35: -- Check that the Application GL Date is in an open or future GL period.

Line 39: FND_MSG_PUB.Add;

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:
43: END IF;

Line 66: FND_MSG_PUB.Add;

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:
70: END IF;

Line 104: FND_MSG_PUB.Add;

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 ()-');
108: END IF;

Line 128: FND_MSG_PUB.Add;

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
132: FND_MESSAGE.SET_NAME('AR','AR_REF_BEFORE_CM_GL_DATE');

Line 134: FND_MSG_PUB.Add;

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:
138: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN

Line 141: FND_MSG_PUB.Add;

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:
145: ELSE

Line 147: FND_MSG_PUB.Add;

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 ');
151: END IF;

Line 187: FND_MSG_PUB.Add;

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:
191: ELSIF p_receivable_application_id IS NULL THEN

Line 193: FND_MSG_PUB.Add;

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;
197: IF PG_DEBUG in ('Y', 'C') THEN

Line 238: FND_MSG_PUB.Add;

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;
242:

Line 249: FND_MSG_PUB.Add;

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:
253: l_user_id := to_number(fnd_profile.value('USER_ID'));

Line 295: FND_MSG_PUB.Add;

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:
299: END IF;

Line 304: FND_MSG_PUB.Add;

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;
308: IF PG_DEBUG in ('Y', 'C') THEN

Line 369: FND_MSG_PUB.Add;

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
373: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_APP_NEG');

Line 374: 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
378: NVL(p_called_from,'RAPI') <> 'ARXRWAPP') THEN

Line 380: FND_MSG_PUB.Add;

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:
384: validate_apply_gl_date(

Line 495: FND_MSG_PUB.initialize;

491: +--------------------------------------------------------------*/
492:
493: IF FND_API.to_Boolean( p_init_msg_list )
494: THEN
495: FND_MSG_PUB.initialize;
496: END IF;
497: /*-----------------------------------------+
498: | Initialize return status to SUCCESS |
499: +-----------------------------------------*/

Line 513: FND_MSG_PUB.Add;

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
517: FND_MESSAGE.SET_NAME('AR','AR_REF_CM_INCOMPLETE');

Line 518: 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;
522: FETCH c_ps INTO l_amount_due_original, l_amount_due_remaining;

Line 528: FND_MSG_PUB.Add;

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
532: FND_MESSAGE.SET_NAME('AR','AR_REF_MORE_THAN_CM_AMT');

Line 533: 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;
537: IF PG_DEBUG in ('Y', 'C') THEN

Line 543: FND_MSG_PUB.Add;

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;
547: