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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

151: END IF;
152: END IF;
153:
154: IF PG_DEBUG in ('Y', 'C') THEN
155: arp_util.debug('Validate_Rev_gl_date ()-');
156: END IF;
157: EXCEPTION
158: WHEN others THEN
159: IF PG_DEBUG in ('Y', 'C') THEN

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

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

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

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

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

194: p_return_status := FND_API.G_RET_STS_ERROR;
195:
196: END IF;
197: IF PG_DEBUG in ('Y', 'C') THEN
198: arp_util.debug('Validate_receivable_appln_id ()-');
199: END IF;
200: EXCEPTION
201: WHEN others THEN
202: IF PG_DEBUG in ('Y', 'C') THEN

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

199: END IF;
200: EXCEPTION
201: WHEN others THEN
202: IF PG_DEBUG in ('Y', 'C') THEN
203: arp_util.debug('EXCEPTION: Validate_receivable_appln_id()');
204: END IF;
205: raise;
206: END Validate_receivable_appln_id;
207:

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

227:
228: BEGIN
229:
230: IF PG_DEBUG in ('Y', 'C') THEN
231: arp_util.debug('validate_activity (+)');
232: END IF;
233:
234: OPEN activity_type;
235: FETCH activity_type INTO l_activity_type;

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

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
309: arp_util.debug('validate_activity (-)');
310: END IF;
311: END validate_activity;
312:
313: PROCEDURE validate_activity_app( p_receivables_trx_id IN NUMBER,

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

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

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

396: p_return_status := FND_API.G_RET_STS_ERROR;
397: END IF;
398:
399: IF PG_DEBUG in ('Y', 'C') THEN
400: arp_util.debug('validate_activity_app ()-');
401: END IF;
402: EXCEPTION
403: WHEN others THEN
404: IF PG_DEBUG in ('Y', 'C') THEN

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

401: END IF;
402: EXCEPTION
403: WHEN others THEN
404: IF PG_DEBUG in ('Y', 'C') THEN
405: arp_util.debug('EXCEPTION: validate_activity_app()');
406: END IF;
407: raise;
408: END validate_activity_app;
409:

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

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

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

440: p_return_status := FND_API.G_RET_STS_ERROR;
441: END IF;
442:
443: IF PG_DEBUG in ('Y', 'C') THEN
444: arp_util.debug('validate_unapp_activity: ' || 'p_return_status :'||p_return_status);
445: arp_util.debug('validate_unapp_activity ()-');
446: END IF;
447: END validate_unapp_activity;
448:

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

441: END IF;
442:
443: IF PG_DEBUG in ('Y', 'C') THEN
444: arp_util.debug('validate_unapp_activity: ' || 'p_return_status :'||p_return_status);
445: arp_util.debug('validate_unapp_activity ()-');
446: END IF;
447: END validate_unapp_activity;
448:
449:

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

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

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

534: p_return_status := FND_API.G_RET_STS_ERROR;
535: END IF;
536: END IF;
537: IF PG_DEBUG in ('Y', 'C') THEN
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');