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.8 2012/05/17 22:00:55 dgaurab 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.8 2012/05/17 22:00:55 dgaurab 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 40: FND_MSG_PUB.Add;

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

Line 67: FND_MSG_PUB.Add;

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

Line 105: FND_MSG_PUB.Add;

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

Line 130: FND_MSG_PUB.Add;

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

Line 137: FND_MSG_PUB.Add;

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

Line 145: FND_MSG_PUB.Add;

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

Line 151: FND_MSG_PUB.Add;

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

Line 191: FND_MSG_PUB.Add;

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

Line 197: FND_MSG_PUB.Add;

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

Line 242: FND_MSG_PUB.Add;

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

Line 253: FND_MSG_PUB.Add;

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

Line 299: FND_MSG_PUB.Add;

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

Line 308: FND_MSG_PUB.Add;

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

Line 373: FND_MSG_PUB.Add;

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

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

Line 384: FND_MSG_PUB.Add;

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

Line 499: FND_MSG_PUB.initialize;

495: +--------------------------------------------------------------*/
496:
497: IF FND_API.to_Boolean( p_init_msg_list )
498: THEN
499: FND_MSG_PUB.initialize;
500: END IF;
501: /*-----------------------------------------+
502: | Initialize return status to SUCCESS |
503: +-----------------------------------------*/

Line 517: FND_MSG_PUB.Add;

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

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

Line 532: FND_MSG_PUB.Add;

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

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

Line 547: FND_MSG_PUB.Add;

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