DBA Data[Home] [Help]

APPS.AR_DEPOSIT_VAL_PVT dependencies on ARP_UTIL

Line 16: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_deposit_Date()+');

12:
13: PROCEDURE Validate_deposit_Date(p_deposit_date IN DATE,
14: p_return_status OUT NOCOPY VARCHAR2) IS
15: BEGIN
16: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_deposit_Date()+');
17:
18: p_return_status := FND_API.G_RET_STS_SUCCESS;
19:
20: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_deposit_Date()-');

Line 20: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_deposit_Date()-');

16: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_deposit_Date()+');
17:
18: p_return_status := FND_API.G_RET_STS_SUCCESS;
19:
20: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_deposit_Date()-');
21: END Validate_deposit_Date;
22:
23: PROCEDURE Validate_batch_source(p_batch_source_id IN NUMBER ,
24: p_return_status OUT NOCOPY VARCHAR2) IS

Line 27: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_batch_source()+');

23: PROCEDURE Validate_batch_source(p_batch_source_id IN NUMBER ,
24: p_return_status OUT NOCOPY VARCHAR2) IS
25: l_dummy NUMBER :=NULL;
26: BEGIN
27: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_batch_source()+');
28:
29: p_return_status := FND_API.G_RET_STS_SUCCESS;
30: if ar_deposit_lib_pvt.pg_profile_batch_source is null and
31: p_batch_source_id is null

Line 48: arp_util.debug('EXCEPTION: no_data_found

44: WHERE batch_source_id = p_batch_source_id;
45: END IF;
46: EXCEPTION
47: WHEN no_data_found THEN
48: arp_util.debug('EXCEPTION: no_data_found
49: Validate_batch_source() ');
50: FND_MESSAGE.set_name( 'AR', 'AR_DAPI_COMM_BATCH_INVALID' );
51: FND_MSG_PUB.Add;
52: p_return_status := FND_API.G_RET_STS_ERROR;

Line 56: arp_util.debug('EXCEPTION:others Validate_batch_source() ');

52: p_return_status := FND_API.G_RET_STS_ERROR;
53:
54:
55: WHEN others THEN
56: arp_util.debug('EXCEPTION:others Validate_batch_source() ');
57: p_return_status := FND_API.G_RET_STS_ERROR;
58: RAISE;
59:
60: END;

Line 62: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_batch_source()-');

58: RAISE;
59:
60: END;
61:
62: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_batch_source()-');
63: END Validate_batch_source;
64:
65:
66: PROCEDURE Validate_Gl_Date(p_gl_date IN DATE,

Line 69: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Gl_Date ()+');

65:
66: PROCEDURE Validate_Gl_Date(p_gl_date IN DATE,
67: p_return_status OUT NOCOPY VARCHAR2) IS
68: BEGIN
69: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Gl_Date ()+');
70: p_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: IF ( NOT arp_util.is_gl_date_valid( p_gl_date )) THEN
73: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );

Line 72: IF ( NOT arp_util.is_gl_date_valid( p_gl_date )) THEN

68: BEGIN
69: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Gl_Date ()+');
70: p_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: IF ( NOT arp_util.is_gl_date_valid( p_gl_date )) THEN
73: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
74: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_gl_date ));
75: FND_MSG_PUB.Add;
76: p_return_status := FND_API.G_RET_STS_ERROR;

Line 78: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Gl_Date ()+');

74: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_gl_date ));
75: FND_MSG_PUB.Add;
76: p_return_status := FND_API.G_RET_STS_ERROR;
77: END IF;
78: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Gl_Date ()+');
79: END Validate_Gl_Date;
80:
81:
82: PROCEDURE Validate_amount(p_amount IN NUMBER,

Line 85: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_amount () +');

81:
82: PROCEDURE Validate_amount(p_amount IN NUMBER,
83: p_return_status OUT NOCOPY VARCHAR2) IS
84: BEGIN
85: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_amount () +');
86: p_return_status := FND_API.G_RET_STS_SUCCESS;
87:
88: --Raise error if the deposit amount is null or negative
89: IF p_amount IS NULL THEN

Line 102: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_amount () -');

98: FND_MSG_PUB.Add;
99:
100: END IF;
101:
102: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_amount () -');
103: END Validate_amount;
104:
105: PROCEDURE Validate_Exchange_Rate(
106: p_currency_code IN VARCHAR2,

Line 116: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Exchange_Rate () +');

112: l_cross_rate NUMBER;
113: l_conversion_rate NUMBER;
114: l_exchange_rate_valid varchar2(2);
115: BEGIN
116: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Exchange_Rate () +');
117: p_return_status := FND_API.G_RET_STS_SUCCESS;
118:
119: IF p_currency_code <> arp_global.functional_currency THEN
120:

Line 198: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Exchange_Rate () -');

194: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_DATE_INVALID');
195: FND_MSG_PUB.Add;
196: END IF;
197: END IF;
198: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Exchange_Rate () -');
199: EXCEPTION
200: WHEN others THEN
201: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');
202: arp_util.debug('p_exchange_rate_type = '

Line 201: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');

197: END IF;
198: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Exchange_Rate () -');
199: EXCEPTION
200: WHEN others THEN
201: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');
202: arp_util.debug('p_exchange_rate_type = '
203: ||p_exchange_rate_type);
204: RAISE;
205: END Validate_Exchange_Rate;

Line 202: arp_util.debug('p_exchange_rate_type = '

198: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Exchange_Rate () -');
199: EXCEPTION
200: WHEN others THEN
201: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');
202: arp_util.debug('p_exchange_rate_type = '
203: ||p_exchange_rate_type);
204: RAISE;
205: END Validate_Exchange_Rate;
206:

Line 212: arp_util.debug('AR_DEPOSIT_VAL_PVT.Is_currency_valid () +');

208: ra_customer_trx.invoice_currency_code%TYPE)
209: RETURN VARCHAR2 IS
210: l_currency_valid VARCHAR2(1);
211: BEGIN
212: arp_util.debug('AR_DEPOSIT_VAL_PVT.Is_currency_valid () +');
213: SELECT 'Y'
214: INTO l_currency_valid
215: FROM fnd_currencies
216: WHERE p_currency_code = currency_code;

Line 217: arp_util.debug('AR_DEPOSIT_VAL_PVT.Is_currency_valid () -');

213: SELECT 'Y'
214: INTO l_currency_valid
215: FROM fnd_currencies
216: WHERE p_currency_code = currency_code;
217: arp_util.debug('AR_DEPOSIT_VAL_PVT.Is_currency_valid () -');
218:
219: RETURN(l_currency_valid);
220:
221: EXCEPTION

Line 226: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');

222: WHEN no_data_found THEN
223: l_currency_valid := 'N';
224: RETURN(l_currency_valid);
225: WHEN others THEN
226: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');
227: arp_util.debug('p_currency_code = '||p_currency_code);
228: raise;
229: END Is_currency_valid;
230:

Line 227: arp_util.debug('p_currency_code = '||p_currency_code);

223: l_currency_valid := 'N';
224: RETURN(l_currency_valid);
225: WHEN others THEN
226: arp_util.debug('EXCEPTION: Validate_Exchange_Rate() ');
227: arp_util.debug('p_currency_code = '||p_currency_code);
228: raise;
229: END Is_currency_valid;
230:
231: PROCEDURE Validate_Currency(

Line 239: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Currency () +');

235: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
236: p_return_status OUT NOCOPY VARCHAR2) IS
237: BEGIN
238: p_return_status := FND_API.G_RET_STS_SUCCESS;
239: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Currency () +');
240: IF (Is_currency_valid(p_currency_code) = 'Y') THEN
241:
242: IF ((arp_global.functional_currency <> p_currency_code) OR
243: (p_exchange_rate_type IS NOT NULL OR

Line 259: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Currency () -');

255: p_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
257: FND_MSG_PUB.Add;
258: END IF;
259: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Currency () -');
260: END Validate_Currency;
261:
262: /*========================================================================
263: | PUBLIC PROCEDURE Validate_Deposit

Line 284: | arp_util.debug(

280: | Validate_amount
281: | Validate_Exchange_Rate
282: | Is_currency_valid
283: | Validate_Currency
284: | arp_util.debug(
285: | FND_MESSAGE.SET_NAME
286: | FND_MSG_PUB.Add;
287: |
288: | PARAMETERS

Line 361: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Deposit () +');

357: l_tax_flag_return_status VARCHAR2(1);
358: c_tax_flag_result VARCHAR2(1) := 'N';
359:
360: BEGIN
361: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Deposit () +');
362:
363: p_return_status := FND_API.G_RET_STS_SUCCESS;
364: l_deposit_date_return_status := FND_API.G_RET_STS_SUCCESS;
365: l_gl_date_return_status := FND_API.G_RET_STS_SUCCESS;

Line 378: arp_util.debug('l_batch_return_status : '||l_batch_return_status);

374:
375:
376: --validate batch source
377: Validate_batch_source(p_batch_source_id,l_batch_return_status);
378: arp_util.debug('l_batch_return_status : '||l_batch_return_status);
379: --Validate deposit_Date
380:
381: Validate_deposit_Date(p_deposit_date,
382: l_deposit_date_return_status);

Line 389: arp_util.debug('l_gl_date_return_status : '||l_gl_date_return_status);

385: --Validate gl_date
386:
387: Validate_Gl_Date(p_gl_date,
388: l_gl_date_return_status);
389: arp_util.debug('l_gl_date_return_status : '||l_gl_date_return_status);
390:
391:
392: --Validate document sequence value
393:

Line 405: arp_util.debug('l_amount_return_status : '||l_amount_return_status);

401:
402: --Validate amount
403: Validate_amount(p_amount ,
404: l_amount_return_status);
405: arp_util.debug('l_amount_return_status : '||l_amount_return_status);
406:
407: --Validate Customer info
408:
409:

Line 421: arp_util.debug('l_currency_return_status : '||l_currency_return_status);

417: p_exchange_rate,
418: p_exchange_rate_date,
419: l_currency_return_status);
420: END IF;
421: arp_util.debug('l_currency_return_status : '||l_currency_return_status);
422:
423: IF p_printing_option not in ('PRI','NOT') and
424: p_printing_option is not null
425: THEN

Line 489: arp_util.debug('Validate_Cash_Receipt Return status :'||p_return_status);

485: (l_fc_return_status = FND_API.G_RET_STS_ERROR)
486: THEN
487: p_return_status := FND_API.G_RET_STS_ERROR;
488: END IF;
489: arp_util.debug('Validate_Cash_Receipt Return status :'||p_return_status);
490: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Deposit () -');
491: EXCEPTION
492: WHEN others THEN
493: raise;

Line 490: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Deposit () -');

486: THEN
487: p_return_status := FND_API.G_RET_STS_ERROR;
488: END IF;
489: arp_util.debug('Validate_Cash_Receipt Return status :'||p_return_status);
490: arp_util.debug('AR_DEPOSIT_VAL_PVT.Validate_Deposit () -');
491: EXCEPTION
492: WHEN others THEN
493: raise;
494: