DBA Data[Home] [Help]

APPS.AR_CM_APP_VAL_PVT dependencies on ARP_UTIL

Line 22: arp_util.debug('Validate_apply_gl_date ()+');

18: l_bool BOOLEAN;
19:
20: BEGIN
21: IF PG_DEBUG in ('Y', 'C') THEN
22: arp_util.debug('Validate_apply_gl_date ()+');
23: END IF;
24: p_return_status := FND_API.G_RET_STS_SUCCESS;
25:
26: IF p_apply_gl_date IS NOT NULL THEN

Line 36: IF ( NOT arp_util.is_gl_date_valid( p_apply_gl_date )) THEN

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.
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;

Line 46: arp_util.debug('Validate_apply_gl_date ()-');

42: END IF;
43:
44: END IF;
45: IF PG_DEBUG in ('Y', 'C') THEN
46: arp_util.debug('Validate_apply_gl_date ()-');
47: END IF;
48:
49: END Validate_apply_gl_date;
50:

Line 58: arp_util.debug('Validate_apply_date ()+');

54: ) IS
55:
56: BEGIN
57: IF PG_DEBUG in ('Y', 'C') THEN
58: arp_util.debug('Validate_apply_date ()+');
59: END IF;
60: p_return_status := FND_API.G_RET_STS_SUCCESS;
61:
62: IF p_apply_date IS NOT NULL THEN

Line 74: arp_util.debug('Validate_apply_date ()-');

70:
71: END IF;
72:
73: IF PG_DEBUG in ('Y', 'C') THEN
74: arp_util.debug('Validate_apply_date ()-');
75: END IF;
76: END Validate_apply_date;
77:
78: PROCEDURE Validate_amount_applied_from(

Line 88: arp_util.debug('Validate_amount_applied_from ()+');

84: l_amount_applied_from NUMBER;
85: l_remaining_unapp_cm_amt NUMBER;
86: BEGIN
87: IF PG_DEBUG in ('Y', 'C') THEN
88: arp_util.debug('Validate_amount_applied_from ()+');
89: END IF;
90: p_return_status := FND_API.G_RET_STS_SUCCESS;
91:
92: SELECT amount_applied,

Line 101: arp_util.debug('Validate_amount_applied_from: ' || 'l_remaining_unapp_cm_amt :'||to_char(l_remaining_unapp_cm_amt));

97: l_remaining_unapp_cm_amt := p_cm_unapp_amount + nvl(l_amount_applied_from, l_amount_applied);
98:
99: IF l_remaining_unapp_cm_amt < 0 THEN
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;

Line 108: arp_util.debug('Validate_amount_applied_from ()-');

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;
110: END Validate_amount_applied_from;
111:
112:

Line 121: arp_util.debug('Validate_Rev_gl_date ()+');

117: ) IS
118:
119: BEGIN
120: IF PG_DEBUG in ('Y', 'C') THEN
121: arp_util.debug('Validate_Rev_gl_date ()+');
122: END IF;
123: p_return_status := FND_API.G_RET_STS_SUCCESS;
124: IF p_reversal_gl_date IS NOT NULL THEN
125:

Line 141: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN

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

Line 154: arp_util.debug('Validate_Rev_gl_date: ' || 'The Reversal gl date is null ');

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

Line 159: arp_util.debug('Validate_Rev_gl_date ()-');

155: END IF;
156: END IF;
157:
158: IF PG_DEBUG in ('Y', 'C') THEN
159: arp_util.debug('Validate_Rev_gl_date ()-');
160: END IF;
161: EXCEPTION
162: WHEN others THEN
163: IF PG_DEBUG in ('Y', 'C') THEN

Line 164: arp_util.debug('EXCEPTION: Validate_rev_gl_date() ');

160: END IF;
161: EXCEPTION
162: WHEN others THEN
163: IF PG_DEBUG in ('Y', 'C') THEN
164: arp_util.debug('EXCEPTION: Validate_rev_gl_date() ');
165: END IF;
166: raise;
167: END Validate_Rev_gl_date;
168:

Line 177: arp_util.debug('Validate_receivable_appln_id ()+');

173: l_valid NUMBER;
174: BEGIN
175: p_return_status := FND_API.G_RET_STS_SUCCESS;
176: IF PG_DEBUG in ('Y', 'C') THEN
177: arp_util.debug('Validate_receivable_appln_id ()+');
178: END IF;
179: IF p_receivable_application_id IS NOT NULL
180: THEN
181: SELECT count(*)

Line 202: arp_util.debug('Validate_receivable_appln_id ()-');

198: p_return_status := FND_API.G_RET_STS_ERROR;
199:
200: END IF;
201: IF PG_DEBUG in ('Y', 'C') THEN
202: arp_util.debug('Validate_receivable_appln_id ()-');
203: END IF;
204: EXCEPTION
205: WHEN others THEN
206: IF PG_DEBUG in ('Y', 'C') THEN

Line 207: arp_util.debug('EXCEPTION: Validate_receivable_appln_id()');

203: END IF;
204: EXCEPTION
205: WHEN others THEN
206: IF PG_DEBUG in ('Y', 'C') THEN
207: arp_util.debug('EXCEPTION: Validate_receivable_appln_id()');
208: END IF;
209: raise;
210: END Validate_receivable_appln_id;
211:

Line 235: arp_util.debug('validate_activity (+)');

231:
232: BEGIN
233:
234: IF PG_DEBUG in ('Y', 'C') THEN
235: arp_util.debug('validate_activity (+)');
236: END IF;
237:
238: OPEN activity_type;
239: FETCH activity_type INTO l_activity_type;

Line 313: arp_util.debug('validate_activity (-)');

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
313: arp_util.debug('validate_activity (-)');
314: END IF;
315: END validate_activity;
316:
317: PROCEDURE validate_activity_app( p_receivables_trx_id IN NUMBER,

Line 339: arp_util.debug('validate_activity_app ()+');

335: l_gl_date_return_status VARCHAR2(1);
336: l_apply_date_return_status VARCHAR2(1);
337: BEGIN
338: IF PG_DEBUG in ('Y', 'C') THEN
339: arp_util.debug('validate_activity_app ()+');
340: END IF;
341: p_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: l_act_return_status := FND_API.G_RET_STS_SUCCESS;

Line 404: arp_util.debug('validate_activity_app ()-');

400: p_return_status := FND_API.G_RET_STS_ERROR;
401: END IF;
402:
403: IF PG_DEBUG in ('Y', 'C') THEN
404: arp_util.debug('validate_activity_app ()-');
405: END IF;
406: EXCEPTION
407: WHEN others THEN
408: IF PG_DEBUG in ('Y', 'C') THEN

Line 409: arp_util.debug('EXCEPTION: validate_activity_app()');

405: END IF;
406: EXCEPTION
407: WHEN others THEN
408: IF PG_DEBUG in ('Y', 'C') THEN
409: arp_util.debug('EXCEPTION: validate_activity_app()');
410: END IF;
411: raise;
412: END validate_activity_app;
413:

Line 427: arp_util.debug('validate_unapp_activity ()+');

423: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
424: BEGIN
425: p_return_status := FND_API.G_RET_STS_SUCCESS;
426: IF PG_DEBUG in ('Y', 'C') THEN
427: arp_util.debug('validate_unapp_activity ()+');
428: END IF;
429:
430: Validate_rev_gl_date( p_reversal_gl_date ,
431: p_apply_gl_date ,

Line 448: arp_util.debug('validate_unapp_activity: ' || 'p_return_status :'||p_return_status);

444: p_return_status := FND_API.G_RET_STS_ERROR;
445: END IF;
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_util.debug('validate_unapp_activity: ' || 'p_return_status :'||p_return_status);
449: arp_util.debug('validate_unapp_activity ()-');
450: END IF;
451: END validate_unapp_activity;
452:

Line 449: arp_util.debug('validate_unapp_activity ()-');

445: END IF;
446:
447: IF PG_DEBUG in ('Y', 'C') THEN
448: arp_util.debug('validate_unapp_activity: ' || 'p_return_status :'||p_return_status);
449: arp_util.debug('validate_unapp_activity ()-');
450: END IF;
451: END validate_unapp_activity;
452:
453:

Line 491: arp_util.debug('validate_credit_memo (+)');

487: l_amount_due_original NUMBER;
488: l_amount_due_remaining NUMBER;
489: BEGIN
490: IF PG_DEBUG in ('Y', 'C') THEN
491: arp_util.debug('validate_credit_memo (+)');
492: END IF;
493: /*--------------------------------------------------------------+
494: | Initialize message list if p_init_msg_list is set to TRUE |
495: +--------------------------------------------------------------*/

Line 542: arp_util.debug('validate_credit_memo (-)');

538: p_return_status := FND_API.G_RET_STS_ERROR;
539: END IF;
540: END IF;
541: IF PG_DEBUG in ('Y', 'C') THEN
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');