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: --Int'l Calendar Project
75: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
76: FND_MSG_PUB.Add;

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

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

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

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

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

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

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

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

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

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

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

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

Line 203: arp_util.debug('p_exchange_rate_type = '

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 285: | arp_util.debug(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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