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_RECEIPT_VAL_PVT dependencies on FND_API

Line 21: p_return_status := FND_API.G_RET_STS_SUCCESS;

17: IF PG_DEBUG in ('Y', 'C') THEN
18: arp_util.debug('Validate_Receipt_Date()+');
19: END IF;
20:
21: p_return_status := FND_API.G_RET_STS_SUCCESS;
22:
23: IF PG_DEBUG in ('Y', 'C') THEN
24: arp_util.debug('Validate_Receipt_Date()-');
25: END IF;

Line 34: p_return_status := FND_API.G_RET_STS_SUCCESS;

30: BEGIN
31: IF PG_DEBUG in ('Y', 'C') THEN
32: arp_util.debug('Validate_Gl_Date ()+');
33: END IF;
34: p_return_status := FND_API.G_RET_STS_SUCCESS;
35: IF ( NOT arp_util.is_gl_date_valid( p_gl_date )) THEN
36: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
37: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_gl_date ));
38: FND_MSG_PUB.Add;

Line 39: p_return_status := FND_API.G_RET_STS_ERROR;

35: IF ( NOT arp_util.is_gl_date_valid( p_gl_date )) THEN
36: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
37: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_gl_date ));
38: FND_MSG_PUB.Add;
39: p_return_status := FND_API.G_RET_STS_ERROR;
40: END IF;
41: IF PG_DEBUG in ('Y', 'C') THEN
42: arp_util.debug('Validate_Gl_Date ()+');
43: END IF;

Line 52: p_return_status := FND_API.G_RET_STS_SUCCESS;

48: BEGIN
49: IF PG_DEBUG in ('Y', 'C') THEN
50: arp_util.debug('Validate_Deposit_Date ()+');
51: END IF;
52: p_return_status := FND_API.G_RET_STS_SUCCESS;
53:
54: END Validate_Deposit_Date;
55:
56: PROCEDURE Validate_Maturity_Date(p_maturity_date IN DATE,

Line 64: p_return_status := FND_API.G_RET_STS_ERROR;

60: IF PG_DEBUG in ('Y', 'C') THEN
61: arp_util.debug('Validate_Maturity_Date ()+');
62: END IF;
63: IF (p_maturity_date < p_receipt_date) THEN
64: p_return_status := FND_API.G_RET_STS_ERROR;
65: FND_MESSAGE.set_name( 'AR','AR_RW_MAT_BEFORE_RCT_DATE');
66: -- arp_util.debug('m'||FND_MESSAGE.GET_ENCODED);
67: FND_MSG_PUB.ADD;
68: ELSE

Line 69: p_return_status := FND_API.G_RET_STS_SUCCESS;

65: FND_MESSAGE.set_name( 'AR','AR_RW_MAT_BEFORE_RCT_DATE');
66: -- arp_util.debug('m'||FND_MESSAGE.GET_ENCODED);
67: FND_MSG_PUB.ADD;
68: ELSE
69: p_return_status := FND_API.G_RET_STS_SUCCESS;
70: END IF;
71: IF PG_DEBUG in ('Y', 'C') THEN
72: arp_util.debug('Validate_Maturity_Date ()-');
73: END IF;

Line 85: p_return_status := FND_API.G_RET_STS_SUCCESS;

81: BEGIN
82: IF PG_DEBUG in ('Y', 'C') THEN
83: arp_util.debug('Validate_amount () +');
84: END IF;
85: p_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: --Raise error if the receipt amount is null or negative
88: IF p_amount IS NULL THEN
89: p_return_status := FND_API.G_RET_STS_ERROR;

Line 89: p_return_status := FND_API.G_RET_STS_ERROR;

85: p_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: --Raise error if the receipt amount is null or negative
88: IF p_amount IS NULL THEN
89: p_return_status := FND_API.G_RET_STS_ERROR;
90: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_AMOUNT_NULL');
91: FND_MSG_PUB.Add;
92:
93: ElSIF (p_amount < 0) AND (p_type = 'CASH')

Line 95: p_return_status := FND_API.G_RET_STS_ERROR;

91: FND_MSG_PUB.Add;
92:
93: ElSIF (p_amount < 0) AND (p_type = 'CASH')
94: THEN
95: p_return_status := FND_API.G_RET_STS_ERROR;
96: FND_MESSAGE.SET_NAME('AR','AR_RW_RCT_AMOUNT_NEGATIVE');
97: FND_MSG_PUB.Add;
98:
99: END IF;

Line 111: p_return_status := FND_API.G_RET_STS_ERROR;

107: THEN
108:
109: IF ( NVL(p_factor_discount_amount,0) <> 0 )
110: THEN
111: p_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.SET_NAME('AR', 'AR_BK_CH_NOT_ALLWD_IF_NOT_CLR');
113: FND_MSG_PUB.Add;
114: IF PG_DEBUG in ('Y', 'C') THEN
115: arp_util.debug('Validate_amount: ' || 'Bank charges are not allowed ');

Line 125: p_return_status := FND_API.G_RET_STS_ERROR;

121: IF (p_state <> 'CLEARED') AND (NVL(p_factor_discount_amount,0) <> 0 )
122: THEN
123: -- raise error about bank charges not allowed because the
124: -- state of the receipt is <> 'CLEARED'
125: p_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MESSAGE.SET_NAME('AR','AR_BK_CH_NOT_ALLWD_IF_NOT_CLR');
127: FND_MSG_PUB.Add;
128: IF PG_DEBUG in ('Y', 'C') THEN
129: arp_util.debug('Validate_amount: ' || 'The bank charges are not allowed if the state <> CLEARED');

Line 136: p_return_status := FND_API.G_RET_STS_ERROR;

132:
133: IF p_factor_discount_amount < 0 THEN
134:
135: -- Raise error if the bank charges amount less than 0
136: p_return_status := FND_API.G_RET_STS_ERROR;
137: FND_MESSAGE.SET_NAME('AR','AR_JG_BC_AMOUNT_NEGATIVE');
138: FND_MSG_PUB.Add;
139: END IF;
140:

Line 145: p_return_status := FND_API.G_RET_STS_ERROR;

141: p_amount := nvl(p_amount,0) + nvl(p_factor_discount_amount,0);
142:
143: IF (p_amount < 0) AND (p_type = 'CASH')
144: THEN
145: p_return_status := FND_API.G_RET_STS_ERROR;
146: FND_MESSAGE.SET_NAME('AR','AR_RW_RCT_AMOUNT_NEGATIVE');
147: FND_MSG_PUB.Add;
148: IF PG_DEBUG in ('Y', 'C') THEN
149: arp_util.debug('Validate_amount: ' || 'Receipt amount is negative ');

Line 175: p_return_status := FND_API.G_RET_STS_SUCCESS;

171: BEGIN
172: IF PG_DEBUG in ('Y', 'C') THEN
173: arp_util.debug('Validate_amount: ' || 'Validate_Customer_id()+');
174: END IF;
175: p_return_status := FND_API.G_RET_STS_SUCCESS;
176: /* l_temp := Customer_Cache_Tbl.LAST;
177: IF PG_DEBUG in ('Y', 'C') THEN
178: arp_util.debug('Validate_amount: ' || 'cache ');
179: END IF;

Line 233: p_return_status := FND_API.G_RET_STS_ERROR;

229: cust.cust_account_id = p_customer_id and
230: cust.party_id = party.party_id;
231: EXCEPTION
232: WHEN NO_DATA_FOUND THEN
233: p_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_ID_INVALID');
235: FND_MSG_PUB.Add;
236:
237: WHEN OTHERS THEN

Line 254: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

250: --There is no point in validating the customer_site_use_id
251: --and the customer bank account id if the validation of
252: --customer id has failed
253:
254: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
255: --no need to validate site_use_id if derived from the transaction
256: IF ar_receipt_lib_pvt.pg_cust_derived_from IS NULL THEN
257:
258: IF p_customer_site_use_id IS NOT NULL THEN

Line 278: p_return_status := FND_API.G_RET_STS_ERROR;

274: AND site_uses.site_use_id = p_customer_site_use_id;
275: ar_receipt_lib_pvt.pg_cust_derived_from := NULL;
276: EXCEPTION
277: WHEN NO_DATA_FOUND THEN
278: p_return_status := FND_API.G_RET_STS_ERROR;
279: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_INVALID');
280: FND_MSG_PUB.Add;
281:
282: WHEN OTHERS THEN

Line 299: p_return_status := FND_API.G_RET_STS_ERROR;

295: IF p_location IS NOT NULL THEN
296: -- for the specified location there is no data in
297: -- hz_cust_site_uses
298: -- the error message was not raised in the defaulting routine.
299: p_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_LOC_INVALID');
301: FND_MSG_PUB.Add;
302: ELSE
303:

Line 312: p_return_status := FND_API.G_RET_STS_ERROR;

308: IF nvl(arp_global.sysparam.site_required_flag,'N') = 'Y' THEN
309: --error
310: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_STE_USE_ID_NOT_DEF');
311: FND_MSG_PUB.Add;
312: p_return_status := FND_API.G_RET_STS_ERROR;
313: ELSE
314: --warning
315: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
316: THEN

Line 377: p_return_status := FND_API.G_RET_STS_ERROR;

373:
374: EXCEPTION
375: WHEN no_data_found THEN
376: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL THEN
377: p_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
379: FND_MSG_PUB.Add;
380: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL THEN
381: p_return_status := FND_API.G_RET_STS_ERROR;

Line 381: p_return_status := FND_API.G_RET_STS_ERROR;

377: p_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
379: FND_MSG_PUB.Add;
380: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL THEN
381: p_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
383: FND_MSG_PUB.Add;
384: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL THEN
385: p_return_status := FND_API.G_RET_STS_ERROR;

Line 385: p_return_status := FND_API.G_RET_STS_ERROR;

381: p_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
383: FND_MSG_PUB.Add;
384: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL THEN
385: p_return_status := FND_API.G_RET_STS_ERROR;
386: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NAME_INVALID');
387: FND_MSG_PUB.Add;
388: END IF;
389: WHEN too_many_rows THEN

Line 413: /* IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

409: END IF;
410:
411: END IF;
412:
413: /* IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
414:
415: l_temp := nvl(l_temp,0) + 1;
416: Customer_Cache_Tbl(l_temp) := l_dummy_cust;
417:

Line 429: p_return_status := FND_API.G_RET_STS_ERROR;

425: /* 6612301 */
426: IF p_customer_bank_account_id IS NOT NULL THEN
427: IF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_id IS NOT NULL
428: THEN
429: p_return_status := FND_API.G_RET_STS_ERROR;
430: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
431: FND_MSG_PUB.Add;
432: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL
433: THEN

Line 434: p_return_status := FND_API.G_RET_STS_ERROR;

430: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_ID_INVALID');
431: FND_MSG_PUB.Add;
432: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_num IS NOT NULL
433: THEN
434: p_return_status := FND_API.G_RET_STS_ERROR;
435: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
436: FND_MSG_PUB.Add;
437: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL
438: THEN

Line 439: p_return_status := FND_API.G_RET_STS_ERROR;

435: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NUM_INVALID');
436: FND_MSG_PUB.Add;
437: ELSIF ar_receipt_api_pub.Original_create_cash_info.customer_bank_account_name IS NOT NULL
438: THEN
439: p_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_BK_AC_NAME_INVALID');
441: FND_MSG_PUB.Add;
442: END IF;
443:

Line 449: p_return_status := FND_API.G_RET_STS_ERROR;

445:
446: IF p_customer_site_use_id IS NOT NULL THEN
447: IF ar_receipt_api_pub.Original_create_cash_info.cust_site_use_id IS NOT NULL
448: THEN
449: p_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_SITE_USE_ID_INVALID');
451: FND_MSG_PUB.Add;
452: ELSIF ar_receipt_api_pub.Original_create_cash_info.location IS NULL THEN
453: p_return_status := FND_API.G_RET_STS_ERROR;

Line 453: p_return_status := FND_API.G_RET_STS_ERROR;

449: p_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_SITE_USE_ID_INVALID');
451: FND_MSG_PUB.Add;
452: ELSIF ar_receipt_api_pub.Original_create_cash_info.location IS NULL THEN
453: p_return_status := FND_API.G_RET_STS_ERROR;
454: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUS_LOC_INVALID');
455: FND_MSG_PUB.Add;
456: END IF;
457: END IF;

Line 486: p_return_status := FND_API.G_RET_STS_SUCCESS;

482: IF PG_DEBUG in ('Y', 'C') THEN
483: arp_util.debug('Validate_amount: ' || 'Validate_Receipt_Method()+');
484: END IF;
485:
486: p_return_status := FND_API.G_RET_STS_SUCCESS;
487:
488: l_temp := Method_Info_Cache_Tbl.LAST;
489: IF l_temp IS NULL THEN
490: --The cache is empty : populate it directly.

Line 593: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

589: arp_util.debug('Validate_amount: ' || 'Remittance bank account id is valid ');
590: END IF;
591:
592: --Cache the valid record [Bug 6454022]
593: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
594: l_temp := nvl(l_temp,0) + 1;
595: Method_Info_Cache_Tbl(l_temp) := l_dummy_method;
596: END IF;
597:

Line 689: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN

685: raise remittance_bank_invalid;
686: END;
687: END IF;
688:
689: IF (p_return_status = FND_API.G_RET_STS_SUCCESS) THEN
690: l_temp := nvl(l_temp,0) + 1;
691: Method_Info_Cache_Tbl(l_temp) := l_dummy_method;
692: END IF;
693:

Line 701: p_return_status := FND_API.G_RET_STS_ERROR;

697: END IF;
698: EXCEPTION
699: WHEN receipt_method_invalid THEN
700: IF ar_receipt_api_pub.Original_create_cash_info.receipt_method_id IS NOT NULL THEN
701: p_return_status := FND_API.G_RET_STS_ERROR;
702: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_MD_ID_INVALID');
703: FND_MSG_PUB.Add;
704: IF PG_DEBUG in ('Y', 'C') THEN
705: arp_util.debug('Validate_amount: ' || 'Invalid receipt method id ');

Line 708: p_return_status := FND_API.G_RET_STS_ERROR;

704: IF PG_DEBUG in ('Y', 'C') THEN
705: arp_util.debug('Validate_amount: ' || 'Invalid receipt method id ');
706: END IF;
707: ELSIF ar_receipt_api_pub.Original_create_cash_info.receipt_method_name IS NOT NULL THEN
708: p_return_status := FND_API.G_RET_STS_ERROR;
709: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCT_MD_NAME_INVALID');
710: FND_MSG_PUB.Add;
711: IF PG_DEBUG in ('Y', 'C') THEN
712: arp_util.debug('Validate_amount: ' || 'Invalid receipt method name ');

Line 724: p_return_status := FND_API.G_RET_STS_ERROR;

720: END IF;
721:
722: WHEN remittance_bank_invalid THEN
723: IF ar_receipt_api_pub.Original_create_cash_info.remit_bank_acct_use_id IS NOT NULL THEN
724: p_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_ID_INVALID');
726: FND_MSG_PUB.Add;
727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account id');

Line 731: p_return_status := FND_API.G_RET_STS_ERROR;

727: IF PG_DEBUG in ('Y', 'C') THEN
728: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account id');
729: END IF;
730: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_num IS NOT NULL THEN
731: p_return_status := FND_API.G_RET_STS_ERROR;
732: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_NUM_INVALID');
733: FND_MSG_PUB.Add;
734: IF PG_DEBUG in ('Y', 'C') THEN
735: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account number');

Line 738: p_return_status := FND_API.G_RET_STS_ERROR;

734: IF PG_DEBUG in ('Y', 'C') THEN
735: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account number');
736: END IF;
737: ELSIF ar_receipt_api_pub.Original_create_cash_info.remittance_bank_account_name IS NOT NULL THEN
738: p_return_status := FND_API.G_RET_STS_ERROR;
739: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_NAME_INVALID');
740: FND_MSG_PUB.Add;
741: IF PG_DEBUG in ('Y', 'C') THEN
742: arp_util.debug('Validate_amount: ' || 'Invalid remittance bank account name');

Line 747: p_return_status := FND_API.G_RET_STS_ERROR;

743: END IF;
744: END IF;
745:
746: WHEN remittance_bank_null THEN
747: p_return_status := FND_API.G_RET_STS_ERROR;
748: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REM_BK_AC_ID_NULL');
749: FND_MSG_PUB.Add;
750: IF PG_DEBUG in ('Y', 'C') THEN
751: arp_util.debug('Validate_amount: ' || 'The remittance bank account could not be defaulted ');

Line 754: p_return_status := FND_API.G_RET_STS_ERROR;

750: IF PG_DEBUG in ('Y', 'C') THEN
751: arp_util.debug('Validate_amount: ' || 'The remittance bank account could not be defaulted ');
752: END IF;
753: WHEN receipt_md_null THEN
754: p_return_status := FND_API.G_RET_STS_ERROR;
755: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_MD_ID_NULL');
756: FND_MSG_PUB.Add;
757: IF PG_DEBUG in ('Y', 'C') THEN
758: arp_util.debug('Validate_amount: ' || 'The receipt method id is null ');

Line 783: p_return_status := FND_API.G_RET_STS_SUCCESS;

779: l_conversion_rate NUMBER;
780: l_exchange_rate_valid varchar2(2);
781: BEGIN
782:
783: p_return_status := FND_API.G_RET_STS_SUCCESS;
784:
785: IF p_currency_code <> arp_global.functional_currency THEN
786:
787: IF p_exchange_rate_type IS NULL THEN

Line 790: p_return_status := FND_API.G_RET_STS_ERROR;

786:
787: IF p_exchange_rate_type IS NULL THEN
788:
789: -- raise exception
790: p_return_status := FND_API.G_RET_STS_ERROR;
791: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_TYPE_NULL');
792: FND_MSG_PUB.Add;
793: Return;
794:

Line 805: p_return_status := FND_API.G_RET_STS_ERROR;

801: FROM gl_daily_conversion_types
802: WHERE conversion_type = p_exchange_rate_type;
803: EXCEPTION
804: WHEN no_data_found THEN
805: p_return_status := FND_API.G_RET_STS_ERROR;
806: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_TYPE_INVALID');
807: FND_MSG_PUB.Add;
808: Return;
809: END;

Line 815: p_return_status := FND_API.G_RET_STS_ERROR;

811: IF p_exchange_rate_type = 'User' THEN
812:
813: IF p_exchange_rate IS NULL THEN
814: --raise error message, because for rate_type 'User' the rate should be specified.
815: p_return_status := FND_API.G_RET_STS_ERROR;
816: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_NULL');
817: FND_MSG_PUB.Add;
818: ELSIF p_exchange_rate = 0 THEN
819: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 819: p_return_status := FND_API.G_RET_STS_ERROR ;

815: p_return_status := FND_API.G_RET_STS_ERROR;
816: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_NULL');
817: FND_MSG_PUB.Add;
818: ELSIF p_exchange_rate = 0 THEN
819: p_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MESSAGE.SET_NAME('AR','AR_EXCHANGE_RATE_ZERO');
821: FND_MSG_PUB.Add;
822: ELSIF p_exchange_rate < 0 THEN
823: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 823: p_return_status := FND_API.G_RET_STS_ERROR ;

819: p_return_status := FND_API.G_RET_STS_ERROR ;
820: FND_MESSAGE.SET_NAME('AR','AR_EXCHANGE_RATE_ZERO');
821: FND_MSG_PUB.Add;
822: ELSIF p_exchange_rate < 0 THEN
823: p_return_status := FND_API.G_RET_STS_ERROR ;
824: FND_MESSAGE.SET_NAME('AR','AR_EXCHANGE_RATE_NEGATIVE');
825: FND_MSG_PUB.Add;
826: END IF;
827:

Line 835: p_return_status := FND_API.G_RET_STS_ERROR;

831: --This could happen only in case if the defaulting routines
832: --could not get the exchange_rate
833: --raise an error message in that case
834:
835: p_return_status := FND_API.G_RET_STS_ERROR;
836: FND_MESSAGE.SET_NAME('AR','AR_NO_RATE_DATA_FOUND');
837: FND_MSG_PUB.Add;
838: END IF;
839:

Line 848: p_return_status := FND_API.G_RET_STS_ERROR ;

844: --the functional and the entered currency are same
845: --so there should be no exchange_rate information
846:
847: IF (p_exchange_rate IS NOT NULL) THEN
848: p_return_status := FND_API.G_RET_STS_ERROR ;
849: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_INVALID');
850: FND_MSG_PUB.Add;
851: END IF;
852: IF (p_exchange_rate_type IS NOT NULL) THEN

Line 853: p_return_status := FND_API.G_RET_STS_ERROR ;

849: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_INVALID');
850: FND_MSG_PUB.Add;
851: END IF;
852: IF (p_exchange_rate_type IS NOT NULL) THEN
853: p_return_status := FND_API.G_RET_STS_ERROR ;
854: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_TYPE_INVALID');
855: FND_MSG_PUB.Add;
856: END IF;
857: IF (p_exchange_rate_date IS NOT NULL) THEN

Line 858: p_return_status := FND_API.G_RET_STS_ERROR ;

854: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_TYPE_INVALID');
855: FND_MSG_PUB.Add;
856: END IF;
857: IF (p_exchange_rate_date IS NOT NULL) THEN
858: p_return_status := FND_API.G_RET_STS_ERROR ;
859: FND_MESSAGE.SET_NAME('AR','AR_RAPI_X_RATE_DATE_INVALID');
860: FND_MSG_PUB.Add;
861: END IF;
862: END IF;

Line 902: p_return_status := FND_API.G_RET_STS_SUCCESS;

898: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
899: p_exchange_rate_date IN ar_cash_receipts.exchange_date%TYPE,
900: p_return_status OUT NOCOPY VARCHAR2) IS
901: BEGIN
902: p_return_status := FND_API.G_RET_STS_SUCCESS;
903: IF (Is_currency_valid(p_currency_code) = 'Y') THEN
904:
905: IF ((arp_global.functional_currency <> p_currency_code) OR
906: (p_exchange_rate_type IS NOT NULL OR

Line 918: p_return_status := FND_API.G_RET_STS_ERROR;

914: p_return_status);
915: END IF;
916: ELSE
917: --the entered currency is invalid
918: p_return_status := FND_API.G_RET_STS_ERROR;
919: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
920: FND_MSG_PUB.Add;
921: END IF;
922: END Validate_Currency;

Line 966: p_return_status := FND_API.G_RET_STS_ERROR;

962: IF l_duplicate_receipt = 'Y' THEN
963: IF p_type = 'CASH' THEN
964: FND_MESSAGE.SET_NAME('AR','AR_RW_CASH_DUPLICATE_RECEIPT');
965: FND_MSG_PUB.ADD;
966: p_return_status := FND_API.G_RET_STS_ERROR;
967: ELSIF p_type = 'MISC' THEN
968: FND_MESSAGE.SET_NAME('AR','AR_RW_MISC_DUPLICATE_RECEIPT');
969: FND_MSG_PUB.ADD;
970: p_return_status := FND_API.G_RET_STS_ERROR;

Line 970: p_return_status := FND_API.G_RET_STS_ERROR;

966: p_return_status := FND_API.G_RET_STS_ERROR;
967: ELSIF p_type = 'MISC' THEN
968: FND_MESSAGE.SET_NAME('AR','AR_RW_MISC_DUPLICATE_RECEIPT');
969: FND_MSG_PUB.ADD;
970: p_return_status := FND_API.G_RET_STS_ERROR;
971: END IF;
972:
973: END IF;
974: IF PG_DEBUG in ('Y', 'C') THEN

Line 1021: p_return_status := FND_API.G_RET_STS_SUCCESS;

1017: IF PG_DEBUG in ('Y', 'C') THEN
1018: arp_util.debug('Validate_amount: ' || 'Validate_Receipt()+ ');
1019: END IF;
1020:
1021: p_return_status := FND_API.G_RET_STS_SUCCESS;
1022:
1023: --Validate receipt_date
1024:
1025: Validate_Receipt_Date(p_receipt_date,

Line 1073: l_doc_seq_return_status := FND_API.G_RET_STS_ERROR ;

1069:
1070: IF(NVL(ar_receipt_lib_pvt.pg_profile_doc_seq, 'N') = 'N' ) AND
1071: p_doc_sequence_value IS NOT NULL
1072: THEN
1073: l_doc_seq_return_status := FND_API.G_RET_STS_ERROR ;
1074: FND_MESSAGE.SET_NAME('AR','AR_RAPI_DOC_SEQ_VAL_INVALID');
1075: FND_MSG_PUB.Add;
1076: END IF;
1077: --Validate amount

Line 1105: l_override_remit_return_status := FND_API.G_RET_STS_ERROR;

1101: --Validate the override_remit_bank_account_flag
1102: IF (p_override_remit_account_flag NOT IN ('Y','N')) THEN
1103: FND_MESSAGE.SET_NAME('AR','AR_OVERR_REM_BK_FLAG_INVALID');
1104: FND_MSG_PUB.ADD;
1105: l_override_remit_return_status := FND_API.G_RET_STS_ERROR;
1106: ELSE
1107: l_override_remit_return_status := FND_API.G_RET_STS_SUCCESS;
1108: END IF;
1109: IF PG_DEBUG in ('Y', 'C') THEN

Line 1107: l_override_remit_return_status := FND_API.G_RET_STS_SUCCESS;

1103: FND_MESSAGE.SET_NAME('AR','AR_OVERR_REM_BK_FLAG_INVALID');
1104: FND_MSG_PUB.ADD;
1105: l_override_remit_return_status := FND_API.G_RET_STS_ERROR;
1106: ELSE
1107: l_override_remit_return_status := FND_API.G_RET_STS_SUCCESS;
1108: END IF;
1109: IF PG_DEBUG in ('Y', 'C') THEN
1110: arp_util.debug('Validate_amount: ' || 'l_override_remit_return_status : '||l_override_remit_return_status);
1111: END IF;

Line 1138: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR

1134: p_customer_id ,
1135: l_dup_return_status );
1136: END IF;
1137:
1138: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR

Line 1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR

1135: l_dup_return_status );
1136: END IF;
1137:
1138: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR

Line 1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR

1136: END IF;
1137:
1138: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR

Line 1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR

1137:
1138: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR

Line 1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR

1138: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR

Line 1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR

1139: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR

Line 1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR

1140: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)

Line 1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR

1141: (l_maturity_date_return_status = FND_API.G_RET_STS_ERROR) OR
1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)
1149: THEN

Line 1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR

1142: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)
1149: THEN
1150: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR

1143: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)
1149: THEN
1150: p_return_status := FND_API.G_RET_STS_ERROR;
1151: END IF;

Line 1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)

1144: (l_customer_return_status = FND_API.G_RET_STS_ERROR) OR
1145: (l_override_remit_return_status = FND_API.G_RET_STS_ERROR) OR
1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)
1149: THEN
1150: p_return_status := FND_API.G_RET_STS_ERROR;
1151: END IF;
1152: IF PG_DEBUG in ('Y', 'C') THEN

Line 1150: p_return_status := FND_API.G_RET_STS_ERROR;

1146: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
1147: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
1148: (l_dup_return_status = FND_API.G_RET_STS_ERROR)
1149: THEN
1150: p_return_status := FND_API.G_RET_STS_ERROR;
1151: END IF;
1152: IF PG_DEBUG in ('Y', 'C') THEN
1153: arp_util.debug('Validate_amount: ' || 'Validate_Cash_Receipt Return status :'||p_return_status);
1154: END IF;

Line 1181: p_return_status := FND_API.G_RET_STS_SUCCESS;

1177: BEGIN
1178: IF PG_DEBUG in ('Y', 'C') THEN
1179: arp_util.debug('Validate_amount_applied ()+');
1180: END IF;
1181: p_return_status := FND_API.G_RET_STS_SUCCESS;
1182:
1183:
1184: IF p_amount_applied IS NULL
1185: THEN

Line 1186: p_return_status := FND_API.G_RET_STS_ERROR;

1182:
1183:
1184: IF p_amount_applied IS NULL
1185: THEN
1186: p_return_status := FND_API.G_RET_STS_ERROR;
1187: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APPLIED_AMT_NULL');
1188: FND_MSG_PUB.Add;
1189: return;
1190: /* The amount Applied can be greater than the line amount. The line level application

Line 1199: p_return_status := FND_API.G_RET_STS_ERROR;

1195: --in case of line_number being not null and
1196: --inv_line_amount being null error message
1197: --would have been raised in the validate_line_number
1198: THEN
1199: p_return_status := FND_API.G_RET_STS_ERROR;
1200: FND_MESSAGE.SET_NAME('AR','AR_RW_APPLIED_GREATER_LINE');
1201: FND_MESSAGE.SET_TOKEN('AMOUNT',p_inv_line_amount);
1202: FND_MSG_PUB.Add;
1203: END IF; */

Line 1225: p_return_status := FND_API.G_RET_STS_ERROR;

1221: , p_message_name => l_message_name);
1222:
1223: IF ( l_message_name IS NOT NULL)
1224: THEN
1225: p_return_status := FND_API.G_RET_STS_ERROR;
1226: FND_MESSAGE.SET_NAME('AR',l_message_name);
1227: FND_MSG_PUB.Add;
1228: END IF;
1229:

Line 1257: p_return_status := FND_API.G_RET_STS_SUCCESS;

1253: BEGIN
1254: IF PG_DEBUG in ('Y', 'C') THEN
1255: arp_util.debug('Validate_line_applied ()+');
1256: END IF;
1257: p_return_status := FND_API.G_RET_STS_SUCCESS;
1258:
1259: IF p_line_amount IS NULL THEN
1260: return;
1261: END IF;

Line 1284: p_return_status := FND_API.G_RET_STS_ERROR;

1280: , p_message_name => l_line_message_name);
1281:
1282: IF ( l_line_message_name IS NOT NULL)
1283: THEN
1284: p_return_status := FND_API.G_RET_STS_ERROR;
1285: FND_MESSAGE.SET_NAME('AR',l_line_message_name);
1286: FND_MSG_PUB.Add;
1287: END IF;
1288:

Line 1313: p_return_status := FND_API.G_RET_STS_SUCCESS;

1309: BEGIN
1310: IF PG_DEBUG in ('Y', 'C') THEN
1311: arp_util.debug('Validate_tax_applied ()+');
1312: END IF;
1313: p_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: IF p_tax_amount IS NULL THEN
1316: return;
1317: END IF;

Line 1340: p_return_status := FND_API.G_RET_STS_ERROR;

1336: , p_message_name => l_tax_message_name);
1337:
1338: IF ( l_tax_message_name IS NOT NULL)
1339: THEN
1340: p_return_status := FND_API.G_RET_STS_ERROR;
1341: FND_MESSAGE.SET_NAME('AR',l_tax_message_name);
1342: FND_MSG_PUB.Add;
1343: END IF;
1344:

Line 1372: p_return_status := FND_API.G_RET_STS_SUCCESS;

1368: BEGIN
1369: IF PG_DEBUG in ('Y', 'C') THEN
1370: arp_util.debug('Validate_freight_applied ()+');
1371: END IF;
1372: p_return_status := FND_API.G_RET_STS_SUCCESS;
1373:
1374: IF p_freight_amount IS NULL THEN
1375: return;
1376: END IF;

Line 1399: p_return_status := FND_API.G_RET_STS_ERROR;

1395: , p_message_name => l_frt_message_name);
1396:
1397: IF ( l_frt_message_name IS NOT NULL)
1398: THEN
1399: p_return_status := FND_API.G_RET_STS_ERROR;
1400: FND_MESSAGE.SET_NAME('AR',l_frt_message_name);
1401: FND_MSG_PUB.Add;
1402: END IF;
1403:

Line 1432: p_return_status := FND_API.G_RET_STS_SUCCESS;

1428: BEGIN
1429: IF PG_DEBUG in ('Y', 'C') THEN
1430: arp_util.debug('Validate_charges_applied ()+');
1431: END IF;
1432: p_return_status := FND_API.G_RET_STS_SUCCESS;
1433:
1434: IF p_charges_amount IS NULL THEN
1435: return;
1436: END IF;

Line 1459: p_return_status := FND_API.G_RET_STS_ERROR;

1455: , p_message_name => l_message_name);
1456:
1457: IF ( l_message_name IS NOT NULL)
1458: THEN
1459: p_return_status := FND_API.G_RET_STS_ERROR;
1460: FND_MESSAGE.SET_NAME('AR',l_message_name);
1461: FND_MSG_PUB.Add;
1462: END IF;
1463:

Line 1485: p_return_status := FND_API.G_RET_STS_SUCCESS;

1481: BEGIN
1482: IF PG_DEBUG in ('Y', 'C') THEN
1483: arp_util.debug('Validate_amount_applied_from ()+');
1484: END IF;
1485: p_return_status := FND_API.G_RET_STS_SUCCESS;
1486: /* Bugfix 2634721. Modified the NVL clause */
1487: l_remaining_unapp_rct_amt := p_cr_unapp_amount - nvl(p_amount_applied_from, p_amount_applied);
1488:
1489: IF l_remaining_unapp_rct_amt < 0 THEN

Line 1493: p_return_status := FND_API.G_RET_STS_ERROR;

1489: IF l_remaining_unapp_rct_amt < 0 THEN
1490: IF PG_DEBUG in ('Y', 'C') THEN
1491: arp_util.debug('Validate_amount: ' || 'l_remaining_unapp_rct_amt :'||to_char(l_remaining_unapp_rct_amt));
1492: END IF;
1493: p_return_status := FND_API.G_RET_STS_ERROR;
1494: FND_MESSAGE.SET_NAME('AR','AR_RW_APP_NEG_UNAPP');
1495: FND_MSG_PUB.Add;
1496: END IF;
1497:

Line 1503: p_return_status := FND_API.G_RET_STS_ERROR;

1499: p_amount_applied_from IS NOT NULL
1500: THEN
1501: FND_MESSAGE.SET_NAME('AR','AR_RAPI_AMT_APP_FROM_INVALID');
1502: FND_MSG_PUB.Add;
1503: p_return_status := FND_API.G_RET_STS_ERROR;
1504: END IF;
1505: IF PG_DEBUG in ('Y', 'C') THEN
1506: arp_util.debug('Validate_amount_applied_from ()-');
1507: END IF;

Line 1523: p_return_status := FND_API.G_RET_STS_SUCCESS;

1519: BEGIN
1520: IF PG_DEBUG in ('Y', 'C') THEN
1521: arp_util.debug('Validate_amount_applied_from over loaded()+');
1522: END IF;
1523: p_return_status := FND_API.G_RET_STS_SUCCESS;
1524:
1525: SELECT amount_applied,
1526: amount_applied_from INTO l_amount_applied,l_amount_applied_from
1527: FROM ar_receivable_applications

Line 1536: p_return_status := FND_API.G_RET_STS_ERROR;

1532: IF l_remaining_unapp_rct_amt < 0 THEN
1533: IF PG_DEBUG in ('Y', 'C') THEN
1534: arp_util.debug('Validate_amount_applied_from: ' || 'l_remaining_unapp_rct_amt :'||to_char(l_remaining_unapp_rct_amt));
1535: END IF;
1536: p_return_status := FND_API.G_RET_STS_ERROR;
1537: FND_MESSAGE.SET_NAME('AR','AR_RW_AMOUNT_LESS_THAN_APP');
1538: FND_MSG_PUB.Add;
1539: END IF;
1540: IF PG_DEBUG in ('Y', 'C') THEN

Line 1560: p_return_status := FND_API.G_RET_STS_SUCCESS;

1556: BEGIN
1557: IF PG_DEBUG in ('Y', 'C') THEN
1558: arp_util.debug('Validate_trans_to_receipt_rate ()+');
1559: END IF;
1560: p_return_status := FND_API.G_RET_STS_SUCCESS;
1561: --Validate the trans_to_receipt_rate
1562: IF p_trx_currency_code = p_cr_currency_code AND
1563: p_trans_to_receipt_rate IS NOT NULL
1564: THEN

Line 1568: p_return_status := FND_API.G_RET_STS_ERROR;

1564: THEN
1565: --raise error because this is not a cross-currency application
1566: --and the user should not have specified a value for trans_to_receipt_rate
1567:
1568: p_return_status := FND_API.G_RET_STS_ERROR;
1569: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CC_RATE_INVALID');
1570: FND_MSG_PUB.Add;
1571: ELSIF p_trx_currency_code <> p_cr_currency_code THEN
1572: IF p_trans_to_receipt_rate IS NULL THEN

Line 1574: p_return_status := FND_API.G_RET_STS_ERROR;

1570: FND_MSG_PUB.Add;
1571: ELSIF p_trx_currency_code <> p_cr_currency_code THEN
1572: IF p_trans_to_receipt_rate IS NULL THEN
1573:
1574: p_return_status := FND_API.G_RET_STS_ERROR;
1575: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CC_RATE_NULL');
1576: FND_MSG_PUB.Add;
1577: ELSIF p_trans_to_receipt_rate < 0 THEN
1578:

Line 1579: p_return_status := FND_API.G_RET_STS_ERROR;

1575: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CC_RATE_NULL');
1576: FND_MSG_PUB.Add;
1577: ELSIF p_trans_to_receipt_rate < 0 THEN
1578:
1579: p_return_status := FND_API.G_RET_STS_ERROR;
1580: FND_MESSAGE.SET_NAME('AR','AR_RW_CC_RATE_POSITIVE');
1581: FND_MSG_PUB.Add;
1582:
1583: ELSE

Line 1611: p_return_status := FND_API.G_RET_STS_ERROR;

1607: p_cr_currency_code
1608: );
1609:
1610: IF l_amount_applied_cr <> l_amount_applied_from THEN
1611: p_return_status := FND_API.G_RET_STS_ERROR;
1612: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CC_RATE_AMTS_INVALID');
1613: FND_MSG_PUB.Add;
1614: END IF;
1615: END IF;

Line 1644: p_return_status := FND_API.G_RET_STS_SUCCESS;

1640: BEGIN
1641: IF PG_DEBUG in ('Y', 'C') THEN
1642: arp_util.debug('Validate_discount ()+');
1643: END IF;
1644: p_return_status := FND_API.G_RET_STS_SUCCESS;
1645: -- Do not allow discount for "On Account" applications
1646: IF (p_discount <> 0
1647: AND p_applied_payment_schedule_id = -1)
1648: THEN

Line 1649: p_return_status := FND_API.G_RET_STS_ERROR;

1645: -- Do not allow discount for "On Account" applications
1646: IF (p_discount <> 0
1647: AND p_applied_payment_schedule_id = -1)
1648: THEN
1649: p_return_status := FND_API.G_RET_STS_ERROR;
1650: fnd_message.set_name ('AR','AR_RW_VAL_ONACC_DISC');
1651: fnd_msg_pub.Add;
1652:
1653: -- Do not negative discounts unless the amount applied is also

Line 1657: p_return_status := FND_API.G_RET_STS_ERROR;

1653: -- Do not negative discounts unless the amount applied is also
1654: -- negative.
1655: ELSIF p_amount_applied >= 0 and
1656: p_discount < 0 THEN
1657: p_return_status := FND_API.G_RET_STS_ERROR;
1658: fnd_message.set_name ('AR','AR_RW_VAL_NEG_DISCNT');
1659: fnd_msg_pub.Add;
1660: -- Bug 3527600: Do not allow positive discounts unless the amount
1661: -- applied is also positive.

Line 1666: p_return_status := FND_API.G_RET_STS_ERROR;

1662: ELSIF p_amount_applied < 0 and
1663: p_discount > 0 THEN
1664: fnd_message.set_name ('AR','AR_RW_VAL_POS_DISCNT');
1665: fnd_msg_pub.Add;
1666: p_return_status := FND_API.G_RET_STS_ERROR;
1667:
1668: -- If partial payment discounts are not allowed.
1669:
1670: -- OSTEINME 3/9/01: Bug 1680623: partial discount

Line 1687: p_return_status := FND_API.G_RET_STS_ERROR;

1683: (p_amount_due_remaining - (p_amount_applied + p_discount)) > 0)
1684: OR (p_amount_applied < 0 AND
1685: (p_amount_due_remaining - (p_amount_applied + p_discount)) < 0))
1686: THEN
1687: p_return_status := FND_API.G_RET_STS_ERROR;
1688: fnd_message.set_name ('AR','AR_NO_PARTIAL_DISC');
1689: fnd_msg_pub.Add;
1690:
1691: ELSIF p_discount IS NOT NULL THEN

Line 1703: p_return_status := FND_API.G_RET_STS_ERROR;

1699: ,TO_CHAR(p_discount_max_allowed,
1700: fnd_currency.get_format_mask (p_trx_currency_code,30))
1701: ||' '||p_trx_currency_code);
1702: fnd_msg_pub.Add;
1703: p_return_status := FND_API.G_RET_STS_ERROR;
1704:
1705: -- Check for Unearned Discounts.
1706: -- Bug 3527600: Allow for negative discount
1707: ELSIF arp_global.sysparam.unearned_discount = 'N'

Line 1712: p_return_status := FND_API.G_RET_STS_ERROR;

1708: AND ABS(p_discount) > ABS(p_discount_earned_allowed)
1709: THEN
1710: fnd_message.set_name ('AR','AR_RW_VAL_UNEARNED_DISCOUNT');
1711: fnd_msg_pub.Add;
1712: p_return_status := FND_API.G_RET_STS_ERROR;
1713: END IF;
1714: END IF;
1715:
1716: IF PG_DEBUG in ('Y', 'C') THEN

Line 1732: p_return_status := FND_API.G_RET_STS_SUCCESS;

1728: BEGIN
1729: IF PG_DEBUG in ('Y', 'C') THEN
1730: arp_util.debug('Validate_apply_gl_date ()+');
1731: END IF;
1732: p_return_status := FND_API.G_RET_STS_SUCCESS;
1733:
1734: IF p_apply_gl_date IS NOT NULL THEN
1735:
1736: -- Check that the application GL Date is not before the invoice GL Date.

Line 1740: p_return_status := FND_API.G_RET_STS_ERROR;

1736: -- Check that the application GL Date is not before the invoice GL Date.
1737: IF p_apply_gl_date < p_trx_gl_date THEN
1738: FND_MESSAGE.SET_NAME('AR','AR_VAL_GL_INV_GL');
1739: FND_MSG_PUB.Add;
1740: p_return_status := FND_API.G_RET_STS_ERROR;
1741:
1742: -- Check that the application GL Date is not before the receipt GL Date.
1743: END IF;
1744:

Line 1748: p_return_status := FND_API.G_RET_STS_ERROR;

1744:
1745: IF p_apply_gl_date < p_cr_gl_date THEN
1746: FND_MESSAGE.SET_NAME('AR','AR_RW_GL_DATE_BEFORE_REC_GL');
1747: FND_MSG_PUB.Add;
1748: p_return_status := FND_API.G_RET_STS_ERROR;
1749: END IF;
1750:
1751:
1752: -- Check that the Application GL Date is in an open or future GL period.

Line 1757: p_return_status := FND_API.G_RET_STS_ERROR;

1753: IF ( NOT arp_util.is_gl_date_valid( p_apply_gl_date )) THEN
1754: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
1755: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_apply_gl_date ));
1756: FND_MSG_PUB.Add;
1757: p_return_status := FND_API.G_RET_STS_ERROR;
1758: END IF;
1759:
1760:
1761: END IF;

Line 1778: p_return_status := FND_API.G_RET_STS_SUCCESS;

1774: BEGIN
1775: IF PG_DEBUG in ('Y', 'C') THEN
1776: arp_util.debug('Validate_apply_date ()+');
1777: END IF;
1778: p_return_status := FND_API.G_RET_STS_SUCCESS;
1779:
1780: IF p_apply_date IS NOT NULL THEN
1781:
1782: -- check that the apply date is not before the invoice date.

Line 1786: p_return_status := FND_API.G_RET_STS_ERROR;

1782: -- check that the apply date is not before the invoice date.
1783: IF p_apply_date < p_trx_date THEN
1784: FND_MESSAGE.SET_NAME('AR','AR_APPLY_BEFORE_TRANSACTION');
1785: FND_MSG_PUB.Add;
1786: p_return_status := FND_API.G_RET_STS_ERROR;
1787:
1788: -- check that the application date is not before the receipt date.
1789: END IF;
1790:

Line 1794: p_return_status := FND_API.G_RET_STS_ERROR;

1790:
1791: IF p_apply_date < p_cr_date THEN
1792: FND_MESSAGE.SET_NAME('AR','AR_APPLY_BEFORE_RECEIPT');
1793: FND_MSG_PUB.Add;
1794: p_return_status := FND_API.G_RET_STS_ERROR;
1795: END IF;
1796:
1797: END IF;
1798:

Line 1867: p_return_status := FND_API.G_RET_STS_SUCCESS;

1863:
1864: IF PG_DEBUG in ('Y', 'C') THEN
1865: arp_util.debug('Validate_Application_info ()+');
1866: END IF;
1867: p_return_status := FND_API.G_RET_STS_SUCCESS;
1868: --validation of the trx_number/customer_trx_id and
1869: --receipt_number/cash_receipt_id entered by the user
1870: --is done in the process of defaulting the Trx info and
1871: --the Receipt Info by the respective defaulting routines

Line 2040: p_return_status := FND_API.G_RET_STS_ERROR ;

2036: )
2037: THEN
2038: FND_MESSAGE.SET_NAME( 'AR','AR_RAPI_LTFC_DISC_OAPP');
2039: FND_MSG_PUB.ADD;
2040: p_return_status := FND_API.G_RET_STS_ERROR ;
2041: END IF;
2042: END IF; */
2043:
2044: --validate p_move_deferred_tax

Line 2048: p_return_status := FND_API.G_RET_STS_ERROR;

2044: --validate p_move_deferred_tax
2045: IF p_move_deferred_tax NOT IN ('Y','N') THEN
2046: FND_MESSAGE.SET_NAME('AR','AR_RAPI_DEF_TAX_FLAG_INVALID');
2047: FND_MSG_PUB.Add;
2048: p_return_status := FND_API.G_RET_STS_ERROR;
2049: END IF;
2050: IF PG_DEBUG in ('Y', 'C') THEN
2051: arp_util.debug('Validate_Application_info: ' || 'Discount return status :'||l_disc_return_status);
2052: END IF;

Line 2054: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR

2050: IF PG_DEBUG in ('Y', 'C') THEN
2051: arp_util.debug('Validate_Application_info: ' || 'Discount return status :'||l_disc_return_status);
2052: END IF;
2053:
2054: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR
2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR

Line 2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR

2051: arp_util.debug('Validate_Application_info: ' || 'Discount return status :'||l_disc_return_status);
2052: END IF;
2053:
2054: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR
2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR

2052: END IF;
2053:
2054: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR
2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2060:

Line 2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR

2053:
2054: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR
2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2060:
2061: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR

2054: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR
2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2060:
2061: p_return_status := FND_API.G_RET_STS_ERROR;
2062: END IF;

Line 2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2055: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
2056: l_x_rate_return_status <> FND_API.G_RET_STS_SUCCESS OR
2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2060:
2061: p_return_status := FND_API.G_RET_STS_ERROR;
2062: END IF;
2063:

Line 2061: p_return_status := FND_API.G_RET_STS_ERROR;

2057: l_disc_return_status <> FND_API.G_RET_STS_SUCCESS OR
2058: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2059: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2060:
2061: p_return_status := FND_API.G_RET_STS_ERROR;
2062: END IF;
2063:
2064: IF PG_DEBUG in ('Y', 'C') THEN
2065: arp_util.debug('Validate_Application_info ()-');

Line 2086: p_return_status := FND_API.G_RET_STS_SUCCESS;

2082: BEGIN
2083: IF PG_DEBUG in ('Y', 'C') THEN
2084: arp_util.debug('Validate_Rev_gl_date ()+');
2085: END IF;
2086: p_return_status := FND_API.G_RET_STS_SUCCESS;
2087: IF p_reversal_gl_date IS NOT NULL THEN
2088:
2089: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
2090: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');

Line 2093: p_return_status := FND_API.G_RET_STS_ERROR;

2089: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
2090: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
2091: FND_MESSAGE.SET_TOKEN('GL_DATE', p_apply_gl_date);
2092: FND_MSG_PUB.Add;
2093: p_return_status := FND_API.G_RET_STS_ERROR;
2094: END IF;
2095: IF p_reversal_gl_date < nvl(p_receipt_gl_date,p_reversal_gl_date) THEN
2096: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_RECEIPT_GL_DATE');
2097: FND_MESSAGE.SET_TOKEN('GL_DATE', p_receipt_gl_date);

Line 2099: p_return_status := FND_API.G_RET_STS_ERROR;

2095: IF p_reversal_gl_date < nvl(p_receipt_gl_date,p_reversal_gl_date) THEN
2096: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_RECEIPT_GL_DATE');
2097: FND_MESSAGE.SET_TOKEN('GL_DATE', p_receipt_gl_date);
2098: FND_MSG_PUB.Add;
2099: p_return_status := FND_API.G_RET_STS_ERROR;
2100: END IF;
2101: /* Bug fix 2441105 */
2102: IF p_reversal_gl_date < nvl(p_recpt_last_state_gl_date,p_reversal_gl_date) THEN
2103: FND_MESSAGE.SET_NAME('AR','AR_RW_BEF_RCPT_STATE_GL_DATE');

Line 2106: p_return_status := FND_API.G_RET_STS_ERROR;

2102: IF p_reversal_gl_date < nvl(p_recpt_last_state_gl_date,p_reversal_gl_date) THEN
2103: FND_MESSAGE.SET_NAME('AR','AR_RW_BEF_RCPT_STATE_GL_DATE');
2104: FND_MESSAGE.SET_TOKEN('GL_DATE', p_recpt_last_state_gl_date);
2105: FND_MSG_PUB.Add;
2106: p_return_status := FND_API.G_RET_STS_ERROR;
2107: END IF;
2108: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
2109: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
2110: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_reversal_gl_date ));

Line 2112: p_return_status := FND_API.G_RET_STS_ERROR;

2108: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
2109: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
2110: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_reversal_gl_date ));
2111: FND_MSG_PUB.Add;
2112: p_return_status := FND_API.G_RET_STS_ERROR;
2113: END IF;
2114:
2115: ELSE
2116: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');

Line 2118: p_return_status := FND_API.G_RET_STS_ERROR;

2114:
2115: ELSE
2116: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');
2117: FND_MSG_PUB.Add;
2118: p_return_status := FND_API.G_RET_STS_ERROR;
2119: IF PG_DEBUG in ('Y', 'C') THEN
2120: arp_util.debug('Validate_Rev_gl_date: ' || 'The Reversal gl date is null ');
2121: END IF;
2122: END IF;

Line 2141: p_return_status := FND_API.G_RET_STS_SUCCESS;

2137: p_application_type IN VARCHAR2,
2138: p_return_status OUT NOCOPY VARCHAR2) IS
2139: l_valid NUMBER;
2140: BEGIN
2141: p_return_status := FND_API.G_RET_STS_SUCCESS;
2142: IF PG_DEBUG in ('Y', 'C') THEN
2143: arp_util.debug('Validate_receivable_appln_id ()+');
2144: END IF;
2145: --validate the receivable application id only if it was passed in

Line 2161: p_return_status := FND_API.G_RET_STS_ERROR;

2157:
2158: IF l_valid = 0 THEN
2159: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
2160: FND_MSG_PUB.Add;
2161: p_return_status := FND_API.G_RET_STS_ERROR;
2162: END IF;
2163:
2164: ELSIF p_receivable_application_id IS NULL THEN
2165: IF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND

Line 2174: p_return_status := FND_API.G_RET_STS_ERROR;

2170: THEN
2171: --receivable application id is null
2172: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
2173: FND_MSG_PUB.Add;
2174: p_return_status := FND_API.G_RET_STS_ERROR;
2175: ELSIF ar_receipt_api_pub.Original_unapp_info.trx_number IS NULL AND
2176: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NULL AND
2177: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NULL AND
2178: (ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NOT NULL OR

Line 2184: p_return_status := FND_API.G_RET_STS_ERROR;

2180: THEN
2181: --the transaction was not specified
2182: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
2183: FND_MSG_PUB.Add;
2184: p_return_status := FND_API.G_RET_STS_ERROR;
2185: ELSIF (ar_receipt_api_pub.Original_unapp_info.trx_number IS NOT NULL OR
2186: ar_receipt_api_pub.Original_unapp_info.customer_trx_id IS NOT NULL OR
2187: ar_receipt_api_pub.Original_unapp_info.applied_ps_id IS NOT NULL) AND
2188: ar_receipt_api_pub.Original_unapp_info.cash_receipt_id IS NULL AND

Line 2194: p_return_status := FND_API.G_RET_STS_ERROR;

2190: THEN
2191: --the receipt was not specified
2192: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
2193: FND_MSG_PUB.Add;
2194: p_return_status := FND_API.G_RET_STS_ERROR;
2195: END IF;
2196:
2197: END IF;
2198: IF PG_DEBUG in ('Y', 'C') THEN

Line 2218: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2214: p_apply_gl_date IN DATE,
2215: p_cr_unapp_amount IN NUMBER,
2216: p_return_status OUT NOCOPY VARCHAR2
2217: ) IS
2218: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2219: l_rev_gl_date_return_status VARCHAR2(1) ;
2220: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/*Added for 3119391 */
2221: BEGIN
2222: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2220: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/Added for 3119391 /

2216: p_return_status OUT NOCOPY VARCHAR2
2217: ) IS
2218: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2219: l_rev_gl_date_return_status VARCHAR2(1) ;
2220: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/*Added for 3119391 */
2221: BEGIN
2222: p_return_status := FND_API.G_RET_STS_SUCCESS;
2223: IF PG_DEBUG in ('Y', 'C') THEN
2224: arp_util.debug('Validate_unapp_info ()+');

Line 2222: p_return_status := FND_API.G_RET_STS_SUCCESS;

2218: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2219: l_rev_gl_date_return_status VARCHAR2(1) ;
2220: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/*Added for 3119391 */
2221: BEGIN
2222: p_return_status := FND_API.G_RET_STS_SUCCESS;
2223: IF PG_DEBUG in ('Y', 'C') THEN
2224: arp_util.debug('Validate_unapp_info ()+');
2225: END IF;
2226:

Line 2246: IF l_rev_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR

2242: Validate_amount_applied_from( p_receivable_application_id,
2243: p_cr_unapp_amount,
2244: l_amt_app_from_return_status);
2245: /*Added l_amt_app_from_return_status condition for bug 3119391 */
2246: IF l_rev_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2247: l_rec_app_return_status <> FND_API.G_RET_STS_SUCCESS OR
2248: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS
2249: THEN
2250: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2247: l_rec_app_return_status <> FND_API.G_RET_STS_SUCCESS OR

2243: p_cr_unapp_amount,
2244: l_amt_app_from_return_status);
2245: /*Added l_amt_app_from_return_status condition for bug 3119391 */
2246: IF l_rev_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2247: l_rec_app_return_status <> FND_API.G_RET_STS_SUCCESS OR
2248: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS
2249: THEN
2250: p_return_status := FND_API.G_RET_STS_ERROR;
2251: ELSE

Line 2248: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS

2244: l_amt_app_from_return_status);
2245: /*Added l_amt_app_from_return_status condition for bug 3119391 */
2246: IF l_rev_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2247: l_rec_app_return_status <> FND_API.G_RET_STS_SUCCESS OR
2248: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS
2249: THEN
2250: p_return_status := FND_API.G_RET_STS_ERROR;
2251: ELSE
2252: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2250: p_return_status := FND_API.G_RET_STS_ERROR;

2246: IF l_rev_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2247: l_rec_app_return_status <> FND_API.G_RET_STS_SUCCESS OR
2248: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS
2249: THEN
2250: p_return_status := FND_API.G_RET_STS_ERROR;
2251: ELSE
2252: p_return_status := FND_API.G_RET_STS_SUCCESS;
2253: END IF;
2254: IF PG_DEBUG in ('Y', 'C') THEN

Line 2252: p_return_status := FND_API.G_RET_STS_SUCCESS;

2248: l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS
2249: THEN
2250: p_return_status := FND_API.G_RET_STS_ERROR;
2251: ELSE
2252: p_return_status := FND_API.G_RET_STS_SUCCESS;
2253: END IF;
2254: IF PG_DEBUG in ('Y', 'C') THEN
2255: arp_util.debug('Validate_unapp_info: ' || 'Recevable appln id return status '||l_rec_app_return_status);
2256: arp_util.debug('Validate_unapp_info: ' || 'Rev_gl_date_return_status :'||l_rev_gl_date_return_status);

Line 2415: p_return_status := FND_API.G_RET_STS_ERROR;

2411:
2412: IF l_valid = 0 THEN
2413: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');
2414: FND_MSG_PUB.Add;
2415: p_return_status := FND_API.G_RET_STS_ERROR;
2416: END IF;
2417: ELSE
2418: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
2419: FND_MSG_PUB.Add;

Line 2420: p_return_status := FND_API.G_RET_STS_ERROR;

2416: END IF;
2417: ELSE
2418: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
2419: FND_MSG_PUB.Add;
2420: p_return_status := FND_API.G_RET_STS_ERROR;
2421: END IF;
2422: IF PG_DEBUG in ('Y', 'C') THEN
2423: arp_util.debug('Validate_cash_receipt_id ()-');
2424: END IF;

Line 2452: p_return_status := FND_API.G_RET_STS_ERROR;

2448: and lookup_code = p_reversal_category_code;
2449: IF l_valid =0 THEN
2450: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_CAT_CD_INVALID');
2451: FND_MSG_PUB.Add;
2452: p_return_status := FND_API.G_RET_STS_ERROR;
2453: END IF;
2454: ELSE
2455: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_CAT_CD_NULL');
2456: FND_MSG_PUB.Add;

Line 2457: p_return_status := FND_API.G_RET_STS_ERROR;

2453: END IF;
2454: ELSE
2455: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_CAT_CD_NULL');
2456: FND_MSG_PUB.Add;
2457: p_return_status := FND_API.G_RET_STS_ERROR;
2458: END IF;
2459: IF PG_DEBUG in ('Y', 'C') THEN
2460: arp_util.debug('Validate_reversal_catg_code ()-');
2461: END IF;

Line 2476: p_return_status := FND_API.G_RET_STS_SUCCESS;

2472: p_return_status OUT NOCOPY VARCHAR2
2473: ) IS
2474: l_valid NUMBER;
2475: BEGIN
2476: p_return_status := FND_API.G_RET_STS_SUCCESS;
2477: IF p_reversal_reason_code IS NOT NULL THEN
2478: SELECT count(*)
2479: INTO l_valid
2480: FROM ar_lookups

Line 2487: p_return_status := FND_API.G_RET_STS_ERROR;

2483: and lookup_code = p_reversal_reason_code;
2484: IF l_valid =0 THEN
2485: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_REAS_CD_INVALID');
2486: FND_MSG_PUB.Add;
2487: p_return_status := FND_API.G_RET_STS_ERROR;
2488: END IF;
2489: ELSE
2490: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_REAS_CD_NULL');
2491: FND_MSG_PUB.Add;

Line 2492: p_return_status := FND_API.G_RET_STS_ERROR;

2488: END IF;
2489: ELSE
2490: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_REAS_CD_NULL');
2491: FND_MSG_PUB.Add;
2492: p_return_status := FND_API.G_RET_STS_ERROR;
2493: END IF;
2494: EXCEPTION
2495: WHEN others THEN
2496: IF PG_DEBUG in ('Y', 'C') THEN

Line 2511: l_cr_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

2507: p_reversal_gl_date IN DATE,
2508: p_reversal_date IN DATE,
2509: p_return_status OUT NOCOPY VARCHAR2
2510: ) IS
2511: l_cr_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2512: l_rev_cat_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2513: l_rev_res_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2514: l_rev_gld_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2515: BEGIN

Line 2512: l_rev_cat_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

2508: p_reversal_date IN DATE,
2509: p_return_status OUT NOCOPY VARCHAR2
2510: ) IS
2511: l_cr_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2512: l_rev_cat_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2513: l_rev_res_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2514: l_rev_gld_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2515: BEGIN
2516: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2513: l_rev_res_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

2509: p_return_status OUT NOCOPY VARCHAR2
2510: ) IS
2511: l_cr_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2512: l_rev_cat_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2513: l_rev_res_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2514: l_rev_gld_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2515: BEGIN
2516: p_return_status := FND_API.G_RET_STS_SUCCESS;
2517: IF PG_DEBUG in ('Y', 'C') THEN

Line 2514: l_rev_gld_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

2510: ) IS
2511: l_cr_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2512: l_rev_cat_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2513: l_rev_res_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2514: l_rev_gld_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2515: BEGIN
2516: p_return_status := FND_API.G_RET_STS_SUCCESS;
2517: IF PG_DEBUG in ('Y', 'C') THEN
2518: arp_util.debug('Validate_reverse_info ()+');

Line 2516: p_return_status := FND_API.G_RET_STS_SUCCESS;

2512: l_rev_cat_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2513: l_rev_res_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2514: l_rev_gld_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
2515: BEGIN
2516: p_return_status := FND_API.G_RET_STS_SUCCESS;
2517: IF PG_DEBUG in ('Y', 'C') THEN
2518: arp_util.debug('Validate_reverse_info ()+');
2519: END IF;
2520: Validate_cash_receipt_id('ALL',

Line 2542: IF l_rev_gld_return_status <> FND_API.G_RET_STS_SUCCESS OR

2538: NULL,
2539: p_receipt_gl_date,
2540: l_rev_gld_return_status
2541: );
2542: IF l_rev_gld_return_status <> FND_API.G_RET_STS_SUCCESS OR
2543: l_rev_res_return_status <> FND_API.G_RET_STS_SUCCESS OR
2544: l_rev_cat_return_status <> FND_API.G_RET_STS_SUCCESS OR
2545: l_cr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2543: l_rev_res_return_status <> FND_API.G_RET_STS_SUCCESS OR

2539: p_receipt_gl_date,
2540: l_rev_gld_return_status
2541: );
2542: IF l_rev_gld_return_status <> FND_API.G_RET_STS_SUCCESS OR
2543: l_rev_res_return_status <> FND_API.G_RET_STS_SUCCESS OR
2544: l_rev_cat_return_status <> FND_API.G_RET_STS_SUCCESS OR
2545: l_cr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: p_return_status := FND_API.G_RET_STS_ERROR;
2547: END IF;

Line 2544: l_rev_cat_return_status <> FND_API.G_RET_STS_SUCCESS OR

2540: l_rev_gld_return_status
2541: );
2542: IF l_rev_gld_return_status <> FND_API.G_RET_STS_SUCCESS OR
2543: l_rev_res_return_status <> FND_API.G_RET_STS_SUCCESS OR
2544: l_rev_cat_return_status <> FND_API.G_RET_STS_SUCCESS OR
2545: l_cr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: p_return_status := FND_API.G_RET_STS_ERROR;
2547: END IF;
2548: IF PG_DEBUG in ('Y', 'C') THEN

Line 2545: l_cr_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2541: );
2542: IF l_rev_gld_return_status <> FND_API.G_RET_STS_SUCCESS OR
2543: l_rev_res_return_status <> FND_API.G_RET_STS_SUCCESS OR
2544: l_rev_cat_return_status <> FND_API.G_RET_STS_SUCCESS OR
2545: l_cr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: p_return_status := FND_API.G_RET_STS_ERROR;
2547: END IF;
2548: IF PG_DEBUG in ('Y', 'C') THEN
2549: arp_util.debug('Validate_reverse_info ()-');

Line 2546: p_return_status := FND_API.G_RET_STS_ERROR;

2542: IF l_rev_gld_return_status <> FND_API.G_RET_STS_SUCCESS OR
2543: l_rev_res_return_status <> FND_API.G_RET_STS_SUCCESS OR
2544: l_rev_cat_return_status <> FND_API.G_RET_STS_SUCCESS OR
2545: l_cr_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: p_return_status := FND_API.G_RET_STS_ERROR;
2547: END IF;
2548: IF PG_DEBUG in ('Y', 'C') THEN
2549: arp_util.debug('Validate_reverse_info ()-');
2550: END IF;

Line 2572: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2568: p_applied_ps_id IN NUMBER,
2569: p_called_from IN VARCHAR2
2570: ) IS
2571: l_cr_return_status VARCHAR2(1);
2572: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2573: l_gl_date_return_status VARCHAR2(1);
2574: l_apply_date_return_status VARCHAR2(1);
2575: BEGIN
2576: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2576: p_return_status := FND_API.G_RET_STS_SUCCESS;

2572: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2573: l_gl_date_return_status VARCHAR2(1);
2574: l_apply_date_return_status VARCHAR2(1);
2575: BEGIN
2576: p_return_status := FND_API.G_RET_STS_SUCCESS;
2577: IF PG_DEBUG in ('Y', 'C') THEN
2578: arp_util.debug('validate_on_ac_app ()+');
2579: END IF;
2580:

Line 2600: l_amt_return_status := FND_API.G_RET_STS_ERROR;

2596: -- validate amount applied
2597: IF p_applied_amount IS NULL THEN
2598: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APPLIED_AMT_NULL');
2599: FND_MSG_PUB.Add;
2600: l_amt_return_status := FND_API.G_RET_STS_ERROR;
2601:
2602: -- Bug 2751910 - allow -ve amount on application to receipt (ps>0)
2603: ELSIF (p_applied_amount < 0 AND NVL(p_applied_ps_id,-1) <> -4 AND
2604: NVL(p_applied_ps_id,-1) <> -3 AND

Line 2613: l_amt_return_status := FND_API.G_RET_STS_ERROR;

2609: ELSE
2610: FND_MESSAGE.SET_NAME('AR','AR_RW_APP_NEG_ON_ACCT');
2611: FND_MSG_PUB.Add;
2612: END IF;
2613: l_amt_return_status := FND_API.G_RET_STS_ERROR;
2614: -- Bug 2897244 - amount not checked if called from form/postbatch
2615: ELSIF ((nvl(p_cr_unapp_amount,0)- p_applied_amount) < 0 AND
2616: NVL(p_applied_ps_id,-1) <> -4 AND
2617: NVL(p_called_from,'RAPI') NOT IN ('ARXRWAPP','ARCAPB')) THEN

Line 2620: l_amt_return_status := FND_API.G_RET_STS_ERROR;

2616: NVL(p_applied_ps_id,-1) <> -4 AND
2617: NVL(p_called_from,'RAPI') NOT IN ('ARXRWAPP','ARCAPB')) THEN
2618: FND_MESSAGE.SET_NAME('AR','AR_RW_AMOUNT_LESS_THAN_APP');
2619: FND_MSG_PUB.Add;
2620: l_amt_return_status := FND_API.G_RET_STS_ERROR;
2621: END IF;
2622:
2623: validate_apply_gl_date(p_apply_gl_date,
2624: p_apply_gl_date,

Line 2629: IF l_cr_return_status <> FND_API.G_RET_STS_SUCCESS OR

2625: p_cr_gl_date,
2626: l_gl_date_return_status
2627: );
2628:
2629: IF l_cr_return_status <> FND_API.G_RET_STS_SUCCESS OR
2630: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
2631: l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2632: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS
2633: THEN

Line 2630: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR

2626: l_gl_date_return_status
2627: );
2628:
2629: IF l_cr_return_status <> FND_API.G_RET_STS_SUCCESS OR
2630: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
2631: l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2632: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS
2633: THEN
2634: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2631: l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR

2627: );
2628:
2629: IF l_cr_return_status <> FND_API.G_RET_STS_SUCCESS OR
2630: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
2631: l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2632: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS
2633: THEN
2634: p_return_status := FND_API.G_RET_STS_ERROR;
2635: END IF;

Line 2632: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS

2628:
2629: IF l_cr_return_status <> FND_API.G_RET_STS_SUCCESS OR
2630: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
2631: l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2632: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS
2633: THEN
2634: p_return_status := FND_API.G_RET_STS_ERROR;
2635: END IF;
2636:

Line 2634: p_return_status := FND_API.G_RET_STS_ERROR;

2630: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
2631: l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
2632: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS
2633: THEN
2634: p_return_status := FND_API.G_RET_STS_ERROR;
2635: END IF;
2636:
2637: IF PG_DEBUG in ('Y', 'C') THEN
2638: arp_util.debug('validate_on_ac_app ()-');

Line 2662: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/Added for 3569640 /

2658: p_apply_gl_date IN DATE,
2659: p_cr_unapp_amt IN NUMBER, /* Bug fix 3569640 */
2660: p_return_status OUT NOCOPY VARCHAR2
2661: ) IS
2662: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/*Added for 3569640 */
2663: BEGIN
2664: p_return_status := FND_API.G_RET_STS_SUCCESS;
2665: IF PG_DEBUG in ('Y', 'C') THEN
2666: arp_util.debug('validate_unapp_on_ac_act_info: ' || 'Validate_unapp_on_acc_act_info ()+');

Line 2664: p_return_status := FND_API.G_RET_STS_SUCCESS;

2660: p_return_status OUT NOCOPY VARCHAR2
2661: ) IS
2662: l_amt_app_from_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;/*Added for 3569640 */
2663: BEGIN
2664: p_return_status := FND_API.G_RET_STS_SUCCESS;
2665: IF PG_DEBUG in ('Y', 'C') THEN
2666: arp_util.debug('validate_unapp_on_ac_act_info: ' || 'Validate_unapp_on_acc_act_info ()+');
2667: END IF;
2668:

Line 2690: IF l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR

2686: Validate_amount_applied_from( p_receivable_application_id,
2687: p_cr_unapp_amt,
2688: l_amt_app_from_return_status);
2689: END IF;
2690: IF l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2691: p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: p_return_status := FND_API.G_RET_STS_ERROR;
2693: END IF;
2694:

Line 2691: p_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2687: p_cr_unapp_amt,
2688: l_amt_app_from_return_status);
2689: END IF;
2690: IF l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2691: p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: p_return_status := FND_API.G_RET_STS_ERROR;
2693: END IF;
2694:
2695: IF PG_DEBUG in ('Y', 'C') THEN

Line 2692: p_return_status := FND_API.G_RET_STS_ERROR;

2688: l_amt_app_from_return_status);
2689: END IF;
2690: IF l_amt_app_from_return_status <> FND_API.G_RET_STS_SUCCESS OR
2691: p_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2692: p_return_status := FND_API.G_RET_STS_ERROR;
2693: END IF;
2694:
2695: IF PG_DEBUG in ('Y', 'C') THEN
2696: arp_util.debug('validate_unapp_on_ac_act_info: ' || 'p_return_status :'||p_return_status);

Line 2727: p_return_status := FND_API.G_RET_STS_ERROR;

2723:
2724: IF l_payment_type <> 'CREDIT_CARD' THEN
2725: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_RECEIPT_ONLY');
2726: FND_MSG_PUB.Add;
2727: p_return_status := FND_API.G_RET_STS_ERROR;
2728: END IF;
2729:
2730: EXCEPTION
2731: WHEN others then

Line 2732: p_return_status := FND_API.G_RET_STS_ERROR;

2728: END IF;
2729:
2730: EXCEPTION
2731: WHEN others then
2732: p_return_status := FND_API.G_RET_STS_ERROR;
2733: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2734: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Validate ccrefund' ||SQLERRM);
2735: FND_MSG_PUB.Add;
2736: END;

Line 2788: p_return_status := FND_API.G_RET_STS_ERROR;

2784: FETCH activity_type INTO l_activity_type;
2785: IF activity_type%NOTFOUND THEN
2786: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_TRX_ID_INVALID');
2787: FND_MSG_PUB.Add;
2788: p_return_status := FND_API.G_RET_STS_ERROR;
2789: END IF;
2790: CLOSE activity_type;
2791:
2792: IF l_activity_type IS NOT NULL THEN

Line 2800: p_return_status := FND_API.G_RET_STS_ERROR;

2796: IF p_applied_ps_id = -2 THEN
2797: IF l_activity_type <> 'SHORT_TERM_DEBT' THEN
2798: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2799: FND_MSG_PUB.Add;
2800: p_return_status := FND_API.G_RET_STS_ERROR;
2801: END IF;
2802:
2803: --SNAMBIAR - Modified for Write-Off
2804: ELSIF p_applied_ps_id = -3 THEN

Line 2808: p_return_status := FND_API.G_RET_STS_ERROR;

2804: ELSIF p_applied_ps_id = -3 THEN
2805: IF l_activity_type <> 'WRITEOFF' THEN
2806: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2807: FND_MSG_PUB.Add;
2808: p_return_status := FND_API.G_RET_STS_ERROR;
2809: END IF;
2810:
2811: --some additional validation that we need to do for the Write-Off: Bug 1645041.
2812: -- Bug 2751910 - Validation against user limits excluded if flag set

Line 2855: p_return_status := FND_API.G_RET_STS_ERROR;

2851: EXCEPTION
2852: WHEN NO_DATA_FOUND THEN
2853: fnd_message.set_name ('AR','AR_WR_NO_LIMIT');
2854: FND_MSG_PUB.Add;
2855: p_return_status := FND_API.G_RET_STS_ERROR;
2856: END;
2857:
2858: IF (NVL(l_tot_write_off_amt,0) > l_amount_to) OR
2859: (NVL(l_tot_write_off_amt,l_amount_from) < l_amount_from)

Line 2865: p_return_status := FND_API.G_RET_STS_ERROR;

2861: fnd_message.set_name ('AR','AR_WR_USER_LIMIT');
2862: fnd_message.set_token('FROM_AMOUNT', to_char(l_amount_from), FALSE);
2863: fnd_message.set_token('TO_AMOUNT', to_char(l_amount_to), FALSE);
2864: FND_MSG_PUB.Add;
2865: p_return_status := FND_API.G_RET_STS_ERROR;
2866: END IF;
2867:
2868: END IF;
2869:

Line 2891: p_return_status := FND_API.G_RET_STS_ERROR;

2887: NVL(l_tot_write_off_amt,0) < 0 )
2888: ) THEN
2889: fnd_message.set_name ('AR','AR_SYSTEM_WR_NO_LIMIT_SET');
2890: FND_MSG_PUB.Add;
2891: p_return_status := FND_API.G_RET_STS_ERROR;
2892: END IF;
2893:
2894: IF PG_DEBUG in ('Y', 'C') THEN
2895: arp_util.debug('l_max_wrt_off_amount = '||l_max_wrt_off_amount);

Line 2920: p_return_status := FND_API.G_RET_STS_ERROR;

2916: (NVL(l_tot_write_off_amt,0) < l_min_wrt_off_amount) ) THEN
2917: arp_util.debug('ERROR l_tot_write_off_amt = '||l_tot_write_off_amt);
2918: fnd_message.set_name ('AR','AR_WR_TOTAL_EXCEED_MAX_AMOUNT');
2919: FND_MSG_PUB.Add;
2920: p_return_status := FND_API.G_RET_STS_ERROR;
2921: END IF;
2922:
2923: ELSIF p_applied_ps_id = -4 THEN
2924: IF l_activity_type <> 'CLAIM_INVESTIGATION' THEN

Line 2927: p_return_status := FND_API.G_RET_STS_ERROR;

2923: ELSIF p_applied_ps_id = -4 THEN
2924: IF l_activity_type <> 'CLAIM_INVESTIGATION' THEN
2925: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2926: FND_MSG_PUB.Add;
2927: p_return_status := FND_API.G_RET_STS_ERROR;
2928: END IF;
2929: ELSIF p_applied_ps_id = -5 THEN
2930: IF (l_activity_type <> 'ADJUST') OR (p_receivables_trx_id <> -11) THEN
2931: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');

Line 2933: p_return_status := FND_API.G_RET_STS_ERROR;

2929: ELSIF p_applied_ps_id = -5 THEN
2930: IF (l_activity_type <> 'ADJUST') OR (p_receivables_trx_id <> -11) THEN
2931: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2932: FND_MSG_PUB.Add;
2933: p_return_status := FND_API.G_RET_STS_ERROR;
2934: END IF;
2935: ELSIF p_applied_ps_id = -6 THEN
2936: IF l_activity_type <> 'CCREFUND' THEN
2937: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');

Line 2939: p_return_status := FND_API.G_RET_STS_ERROR;

2935: ELSIF p_applied_ps_id = -6 THEN
2936: IF l_activity_type <> 'CCREFUND' THEN
2937: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2938: FND_MSG_PUB.Add;
2939: p_return_status := FND_API.G_RET_STS_ERROR;
2940: END IF;
2941: ELSIF p_applied_ps_id = -7 THEN
2942: IF l_activity_type <> 'PREPAYMENT' THEN
2943: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');

Line 2945: p_return_status := FND_API.G_RET_STS_ERROR;

2941: ELSIF p_applied_ps_id = -7 THEN
2942: IF l_activity_type <> 'PREPAYMENT' THEN
2943: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2944: FND_MSG_PUB.Add;
2945: p_return_status := FND_API.G_RET_STS_ERROR;
2946: END IF;
2947: ELSIF p_applied_ps_id = -8 THEN
2948: IF l_activity_type <> 'CM_REFUND' THEN
2949: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');

Line 2951: p_return_status := FND_API.G_RET_STS_ERROR;

2947: ELSIF p_applied_ps_id = -8 THEN
2948: IF l_activity_type <> 'CM_REFUND' THEN
2949: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_X_INVALID');
2950: FND_MSG_PUB.Add;
2951: p_return_status := FND_API.G_RET_STS_ERROR;
2952: END IF;
2953: ELSE
2954: --the applied payment schedule id is invalid
2955: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');

Line 2957: p_return_status := FND_API.G_RET_STS_ERROR;

2953: ELSE
2954: --the applied payment schedule id is invalid
2955: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
2956: FND_MSG_PUB.Add;
2957: p_return_status := FND_API.G_RET_STS_ERROR;
2958: END IF; --additional control structures to be added for new activity types.
2959: END IF;
2960: IF PG_DEBUG in ('Y', 'C') THEN
2961: arp_util.debug('validate_activity (-)');

Line 2986: p_return_status := FND_API.G_RET_STS_SUCCESS;

2982: BEGIN
2983: IF PG_DEBUG in ('Y', 'C') THEN
2984: arp_util.debug('validate_activity_app ()+');
2985: END IF;
2986: p_return_status := FND_API.G_RET_STS_SUCCESS;
2987: validate_on_ac_app(
2988: p_cash_receipt_id,
2989: p_cr_gl_date,
2990: p_cr_unapp_amount,

Line 3036: p_return_status := FND_API.G_RET_STS_ERROR;

3032: EXCEPTION
3033: WHEN no_data_found THEN
3034: FND_MESSAGE.SET_NAME('AR','AR_RAPI_LK_CUS_TRX_ID_INVALID');
3035: FND_MSG_PUB.Add;
3036: p_return_status := FND_API.G_RET_STS_ERROR;
3037: WHEN others THEN
3038: raise;
3039: END;
3040: IF l_valid <> 'Y' THEN

Line 3043: p_return_status := FND_API.G_RET_STS_ERROR;

3039: END;
3040: IF l_valid <> 'Y' THEN
3041: FND_MESSAGE.SET_NAME('AR','AR_RAPI_LK_CUS_TRX_ID_INVALID');
3042: FND_MSG_PUB.Add;
3043: p_return_status := FND_API.G_RET_STS_ERROR;
3044: END IF;
3045: l_valid := Null;
3046: ELSE
3047: FND_MESSAGE.SET_NAME('AR','AR_RAPI_LK_CUS_TRX_ID_INVALID');

Line 3049: p_return_status := FND_API.G_RET_STS_ERROR;

3045: l_valid := Null;
3046: ELSE
3047: FND_MESSAGE.SET_NAME('AR','AR_RAPI_LK_CUS_TRX_ID_INVALID');
3048: FND_MSG_PUB.Add;
3049: p_return_status := FND_API.G_RET_STS_ERROR;
3050: END IF;
3051: END IF;
3052:
3053: --validate the p_link_to_customer_trx_id

Line 3069: p_return_status := FND_API.G_RET_STS_ERROR;

3065:
3066: IF l_valid <> 'Y' THEN
3067: FND_MESSAGE.SET_NAME('AR','AR_RAPI_LK_CUS_TRX_ID_INVALID');
3068: FND_MSG_PUB.Add;
3069: p_return_status := FND_API.G_RET_STS_ERROR;
3070: END IF;
3071:
3072: EXCEPTION
3073: WHEN no_data_found THEN

Line 3076: p_return_status := FND_API.G_RET_STS_ERROR;

3072: EXCEPTION
3073: WHEN no_data_found THEN
3074: FND_MESSAGE.SET_NAME('AR','AR_RAPI_LK_CUS_TRX_ID_INVALID');
3075: FND_MSG_PUB.Add;
3076: p_return_status := FND_API.G_RET_STS_ERROR;
3077: WHEN others THEN
3078: raise;
3079: END;
3080: END IF;

Line 3081: arp_util.debug('fnd_api.g_ret_sts_error = '||fnd_api.g_ret_sts_error);

3077: WHEN others THEN
3078: raise;
3079: END;
3080: END IF;
3081: arp_util.debug('fnd_api.g_ret_sts_error = '||fnd_api.g_ret_sts_error);
3082: IF PG_DEBUG in ('Y', 'C') THEN
3083: arp_util.debug('validate_activity_app ()-');
3084: END IF;
3085: END validate_activity_app;

Line 3132: p_return_status := FND_API.G_RET_STS_ERROR;

3128: EXCEPTION
3129: WHEN no_data_found THEN
3130: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INVALID_APP_REF');
3131: FND_MSG_PUB.Add;
3132: p_return_status := FND_API.G_RET_STS_ERROR;
3133: END;
3134: ELSE
3135: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
3136: FND_MSG_PUB.Add;

Line 3137: p_return_status := FND_API.G_RET_STS_ERROR;

3133: END;
3134: ELSE
3135: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
3136: FND_MSG_PUB.Add;
3137: p_return_status := FND_API.G_RET_STS_ERROR;
3138: END IF;
3139: END IF;
3140: /* Bug 2270825 - claim specific validation */
3141: /* Bug 2751910 - reason no longer compulsory */

Line 3160: p_return_status := FND_API.G_RET_STS_ERROR;

3156: EXCEPTION
3157: WHEN OTHERS THEN
3158: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INVALID_REF_REASON');
3159: FND_MSG_PUB.Add;
3160: p_return_status := FND_API.G_RET_STS_ERROR;
3161: END;
3162: END IF;
3163: ELSE
3164:

Line 3226: p_return_status := FND_API.G_RET_STS_ERROR;

3222: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INVALID_CLAIM_NUM');
3223: FND_MESSAGE.SET_TOKEN('CLAIM_NUM',p_application_ref_num);
3224: END IF;
3225: FND_MSG_PUB.Add;
3226: p_return_status := FND_API.G_RET_STS_ERROR;
3227: RAISE;
3228: WHEN others THEN
3229: p_return_status := FND_API.G_RET_STS_ERROR;
3230: arp_util.debug('EXCEPTION :validate_application_reference ()-'||SQLERRM);

Line 3229: p_return_status := FND_API.G_RET_STS_ERROR;

3225: FND_MSG_PUB.Add;
3226: p_return_status := FND_API.G_RET_STS_ERROR;
3227: RAISE;
3228: WHEN others THEN
3229: p_return_status := FND_API.G_RET_STS_ERROR;
3230: arp_util.debug('EXCEPTION :validate_application_reference ()-'||SQLERRM);
3231: raise;
3232: END;
3233:

Line 3272: l_activity_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

3268: l_amount_return_status VARCHAR2(1);
3269: l_currency_return_status VARCHAR2(1);
3270: l_doc_seq_return_status VARCHAR2(1);
3271: l_dup_return_status VARCHAR2(1);
3272: l_activity_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3273: l_tax_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3274: l_tax_rate_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3275: l_tax_rate NUMBER;
3276: l_tax_validate_flag VARCHAR2(1);

Line 3273: l_tax_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

3269: l_currency_return_status VARCHAR2(1);
3270: l_doc_seq_return_status VARCHAR2(1);
3271: l_dup_return_status VARCHAR2(1);
3272: l_activity_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3273: l_tax_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3274: l_tax_rate_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3275: l_tax_rate NUMBER;
3276: l_tax_validate_flag VARCHAR2(1);
3277: l_reference_valid VARCHAR2(1);

Line 3274: l_tax_rate_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

3270: l_doc_seq_return_status VARCHAR2(1);
3271: l_dup_return_status VARCHAR2(1);
3272: l_activity_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3273: l_tax_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3274: l_tax_rate_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3275: l_tax_rate NUMBER;
3276: l_tax_validate_flag VARCHAR2(1);
3277: l_reference_valid VARCHAR2(1);
3278: l_ref_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

Line 3278: l_ref_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

3274: l_tax_rate_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3275: l_tax_rate NUMBER;
3276: l_tax_validate_flag VARCHAR2(1);
3277: l_reference_valid VARCHAR2(1);
3278: l_ref_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3279: l_ref_type_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3280: BEGIN
3281: IF PG_DEBUG in ('Y', 'C') THEN
3282: arp_util.debug('Validate_misc_receipt()+ ');

Line 3279: l_ref_type_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;

3275: l_tax_rate NUMBER;
3276: l_tax_validate_flag VARCHAR2(1);
3277: l_reference_valid VARCHAR2(1);
3278: l_ref_id_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3279: l_ref_type_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
3280: BEGIN
3281: IF PG_DEBUG in ('Y', 'C') THEN
3282: arp_util.debug('Validate_misc_receipt()+ ');
3283: END IF;

Line 3285: p_return_status := FND_API.G_RET_STS_SUCCESS;

3281: IF PG_DEBUG in ('Y', 'C') THEN
3282: arp_util.debug('Validate_misc_receipt()+ ');
3283: END IF;
3284:
3285: p_return_status := FND_API.G_RET_STS_SUCCESS;
3286:
3287: --Validate receipt_date
3288:
3289: Validate_Receipt_Date(p_receipt_date,

Line 3329: l_doc_seq_return_status := FND_API.G_RET_STS_ERROR ;

3325:
3326: IF(NVL(ar_receipt_lib_pvt.pg_profile_doc_seq, 'N') = 'N' ) AND
3327: p_doc_sequence_value IS NOT NULL
3328: THEN
3329: l_doc_seq_return_status := FND_API.G_RET_STS_ERROR ;
3330: FND_MESSAGE.SET_NAME('AR','AR_RAPI_DOC_SEQ_VAL_INVALID');
3331: FND_MSG_PUB.Add;
3332: END IF;
3333:

Line 3382: l_activity_return_status := FND_API.G_RET_STS_ERROR ;

3378: AND p_receipt_date <= nvl(rt.end_date_active, p_receipt_date);
3379: EXCEPTION
3380: WHEN no_data_found THEN
3381: IF p_orig_receivables_trx_id IS NULL THEN
3382: l_activity_return_status := FND_API.G_RET_STS_ERROR ;
3383: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_INVALID');
3384: FND_MSG_PUB.Add;
3385: ELSE
3386: l_activity_return_status := FND_API.G_RET_STS_ERROR ;

Line 3386: l_activity_return_status := FND_API.G_RET_STS_ERROR ;

3382: l_activity_return_status := FND_API.G_RET_STS_ERROR ;
3383: FND_MESSAGE.SET_NAME('AR','AR_RAPI_ACTIVITY_INVALID');
3384: FND_MSG_PUB.Add;
3385: ELSE
3386: l_activity_return_status := FND_API.G_RET_STS_ERROR ;
3387: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_TRX_ID_INVALID');
3388: FND_MSG_PUB.Add;
3389: END IF;
3390: END;

Line 3392: l_activity_return_status := FND_API.G_RET_STS_ERROR ;

3388: FND_MSG_PUB.Add;
3389: END IF;
3390: END;
3391: ELSE
3392: l_activity_return_status := FND_API.G_RET_STS_ERROR ;
3393: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_TRX_ID_NULL');
3394: FND_MSG_PUB.Add;
3395: END IF;
3396:

Line 3435: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;

3431:
3432: EXCEPTION
3433: WHEN no_data_found THEN
3434: IF p_orig_vat_tax_id IS NOT NULL THEN
3435: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;
3436: FND_MESSAGE.SET_NAME('AR','AR_RAPI_VAT_TAX_ID_INVALID');
3437: FND_MSG_PUB.Add;
3438: ELSE
3439: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;

Line 3439: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;

3435: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;
3436: FND_MESSAGE.SET_NAME('AR','AR_RAPI_VAT_TAX_ID_INVALID');
3437: FND_MSG_PUB.Add;
3438: ELSE
3439: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;
3440: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TAX_CODE_INVALID');
3441: FND_MSG_PUB.Add;
3442: END IF;
3443: END;

Line 3456: l_tax_rate_return_status := FND_API.G_RET_STS_ERROR;

3452: IF p_tax_rate IS NOT NULL THEN
3453: /* Bug 5955921 l_tax_validate_flag = 'N' OR */
3454: IF fnd_profile.value('ZX_ALLOW_TAX_UPDATE') = 'N'
3455: THEN
3456: l_tax_rate_return_status := FND_API.G_RET_STS_ERROR;
3457: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TAX_RATE_INVALID');
3458: FND_MSG_PUB.Add;
3459: END IF;
3460: ELSE

Line 3473: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;

3469: ELSE
3470: --this is the case where we dont have any vat_tax_id, but the user has specified the
3471: --tax rate as a input parameter.
3472: IF p_tax_rate IS NOT NULL THEN
3473: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;
3474: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TAX_RATE_INVALID');
3475: FND_MSG_PUB.Add;
3476: END IF;
3477: END IF;

Line 3483: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;

3479: ELSE
3480: --if the accounting is cash basis.
3481: IF p_vat_tax_id IS NOT NULL THEN
3482: --raise error as no tax accounting is done for cash basis in misc receipt.
3483: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;
3484: FND_MESSAGE.SET_NAME('AR','AR_RAPI_VAT_TAX_ID_INVALID');
3485: FND_MSG_PUB.Add;
3486: END IF;
3487:

Line 3489: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;

3485: FND_MSG_PUB.Add;
3486: END IF;
3487:
3488: IF p_tax_rate IS NOT NULL THEN
3489: l_tax_id_return_status := FND_API.G_RET_STS_ERROR ;
3490: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TAX_RATE_INVALID');
3491: FND_MSG_PUB.Add;
3492: END IF;
3493:

Line 3543: l_ref_type_return_status := FND_API.G_RET_STS_ERROR;

3539: from ra_customer_trx
3540: where customer_trx_id = p_reference_id;
3541: ELSE
3542: --the reference_type is invalid, raise error.
3543: l_ref_type_return_status := FND_API.G_RET_STS_ERROR;
3544: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_TYPE_INVALID');
3545: FND_MSG_PUB.Add;
3546:
3547: END IF;

Line 3551: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;

3547: END IF;
3548: EXCEPTION
3549: WHEN no_data_found THEN
3550: IF p_orig_reference_id IS NULL THEN
3551: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;
3552: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_NUM_INVALID');
3553: FND_MSG_PUB.Add;
3554: ELSE
3555: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;

Line 3555: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;

3551: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;
3552: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_NUM_INVALID');
3553: FND_MSG_PUB.Add;
3554: ELSE
3555: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;
3556: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_ID_INVALID');
3557: FND_MSG_PUB.Add;
3558: END IF;
3559: END;

Line 3565: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;

3561: --the reference_id is null, raise error.
3562: IF p_reference_num IS NOT NULL THEN
3563: --this would happen if the reference_id could not be
3564: --derived from reference number
3565: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;
3566: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_NUM_INVALID');
3567: FND_MSG_PUB.Add;
3568: ELSE
3569: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;

Line 3569: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;

3565: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;
3566: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_NUM_INVALID');
3567: FND_MSG_PUB.Add;
3568: ELSE
3569: l_ref_id_return_status := FND_API.G_RET_STS_ERROR;
3570: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_ID_NULL');
3571: FND_MSG_PUB.Add;
3572: END IF;
3573:

Line 3587: l_ref_type_return_status := FND_API.G_RET_STS_ERROR;

3583: ELSE
3584: --this means any one of the orig_reference_id, reference_num or
3585: --reference_id is specified, so a null reference type should
3586: --raise an error.
3587: l_ref_type_return_status := FND_API.G_RET_STS_ERROR;
3588: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REF_TYPE_NULL');
3589: FND_MSG_PUB.Add;
3590: END IF;
3591: END IF;

Line 3594: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR

3590: END IF;
3591: END IF;
3592:
3593:
3594: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR

3591: END IF;
3592:
3593:
3594: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR

3592:
3593:
3594: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR

3593:
3594: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR

3594: IF (l_receipt_date_return_status = FND_API.G_RET_STS_ERROR) OR
3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR

3595: (l_gl_date_return_status = FND_API.G_RET_STS_ERROR) OR
3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR

3596: (l_deposit_date_return_status = FND_API.G_RET_STS_ERROR) OR
3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR

Line 3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR

3597: (l_rcpt_md_return_status = FND_API.G_RET_STS_ERROR) OR
3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR
3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)

Line 3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR

3598: (l_amount_return_status = FND_API.G_RET_STS_ERROR) OR
3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR
3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)
3606: THEN

Line 3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR

3599: (l_currency_return_status = FND_API.G_RET_STS_ERROR) OR
3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR
3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)
3606: THEN
3607: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR

3600: (l_doc_seq_return_status = FND_API.G_RET_STS_ERROR) OR
3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR
3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)
3606: THEN
3607: p_return_status := FND_API.G_RET_STS_ERROR;
3608: END IF;

Line 3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)

3601: (l_dup_return_status = FND_API.G_RET_STS_ERROR) OR
3602: (l_activity_return_status = FND_API.G_RET_STS_ERROR) OR
3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR
3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)
3606: THEN
3607: p_return_status := FND_API.G_RET_STS_ERROR;
3608: END IF;
3609: IF PG_DEBUG in ('Y', 'C') THEN

Line 3607: p_return_status := FND_API.G_RET_STS_ERROR;

3603: (l_tax_id_return_status = FND_API.G_RET_STS_ERROR) OR
3604: (l_ref_id_return_status = FND_API.G_RET_STS_ERROR) OR
3605: (l_ref_type_return_status = FND_API.G_RET_STS_ERROR)
3606: THEN
3607: p_return_status := FND_API.G_RET_STS_ERROR;
3608: END IF;
3609: IF PG_DEBUG in ('Y', 'C') THEN
3610: arp_util.debug('Validate_misc_receipt return status :'||p_return_status);
3611: END IF;

Line 3635: p_return_status := FND_API.G_RET_STS_SUCCESS;

3631: l_prepay_amount NUMBER;
3632: BEGIN
3633:
3634: arp_util.debug('Validate prepay amount (+)');
3635: p_return_status := FND_API.G_RET_STS_SUCCESS;
3636:
3637: l_cash_receipt_id := p_cash_receipt_id;
3638:
3639: IF p_receipt_number IS NOT NULL THEN

Line 3673: p_return_status := FND_API.G_RET_STS_ERROR ;

3669: IF nvl(p_refund_amount,0) > l_prepay_amount THEN
3670: --raise error X validation failed
3671: FND_MESSAGE.SET_NAME('AR','AR_RAPI_PREPAY_AMT_LESS');
3672: FND_MSG_PUB.Add;
3673: p_return_status := FND_API.G_RET_STS_ERROR ;
3674: END IF;
3675:
3676: arp_util.debug('Validate prepay amount (-)');
3677:

Line 3683: p_return_status := FND_API.G_RET_STS_ERROR ;

3679: WHEN others THEN
3680: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
3681: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
3682: FND_MSG_PUB.Add;
3683: p_return_status := FND_API.G_RET_STS_ERROR ;
3684: arp_util.debug('EXCEPTION :Validate prepay amount '||SQLERRM);
3685: END;
3686:
3687: PROCEDURE validate_payment_type(

Line 3700: p_return_status := FND_API.G_RET_STS_SUCCESS;

3696: l_cash_receipt_id NUMBER;
3697:
3698: BEGIN
3699: arp_util.debug('Validate payment Type (+)');
3700: p_return_status := FND_API.G_RET_STS_SUCCESS;
3701:
3702: l_cash_receipt_id := p_cash_receipt_id;
3703:
3704: IF p_receipt_number IS NOT NULL THEN

Line 3739: p_return_status := FND_API.G_RET_STS_ERROR ;

3735: IF p_payment_action = 'CREATE_RCPT' THEN
3736:
3737: FND_MESSAGE.set_name ('AR','AR_RAPI_PREPAY_ONLYFOR_CC');
3738: FND_MSG_PUB.Add;
3739: p_return_status := FND_API.G_RET_STS_ERROR ;
3740:
3741: ELSIF p_payment_action = 'REFUND_RCPT' THEN
3742:
3743: FND_MESSAGE.set_name ('AR','AR_RW_CCR_NOT_CC_RECEIPT');

Line 3745: p_return_status := FND_API.G_RET_STS_ERROR ;

3741: ELSIF p_payment_action = 'REFUND_RCPT' THEN
3742:
3743: FND_MESSAGE.set_name ('AR','AR_RW_CCR_NOT_CC_RECEIPT');
3744: FND_MSG_PUB.Add;
3745: p_return_status := FND_API.G_RET_STS_ERROR ;
3746:
3747: END IF;
3748: END IF;
3749:

Line 3757: p_return_status := FND_API.G_RET_STS_ERROR ;

3753: WHEN others THEN
3754: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
3755: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
3756: FND_MSG_PUB.Add;
3757: p_return_status := FND_API.G_RET_STS_ERROR ;
3758: arp_util.debug('EXCEPTION :Validate payment type '||SQLERRM);
3759: END;
3760:
3761: -- Bug 2270809

Line 3815: p_return_status := FND_API.G_RET_STS_ERROR ;

3811: WHEN others THEN
3812: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
3813: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
3814: FND_MSG_PUB.Add;
3815: p_return_status := FND_API.G_RET_STS_ERROR ;
3816: IF PG_DEBUG in ('Y', 'C') THEN
3817: arp_util.debug('EXCEPTION :ar_receipt_val_pvt.validate_claim_unapply '||SQLERRM);
3818: END IF;
3819: END validate_claim_unapply;

Line 3839: l_rct_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3835: , p_unapplied_cash IN NUMBER
3836: , p_called_from IN VARCHAR2
3837: , p_return_status OUT NOCOPY VARCHAR2
3838: ) IS
3839: l_rct_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3836: , p_called_from IN VARCHAR2
3837: , p_return_status OUT NOCOPY VARCHAR2
3838: ) IS
3839: l_rct_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3837: , p_return_status OUT NOCOPY VARCHAR2
3838: ) IS
3839: l_rct_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3838: ) IS
3839: l_rct_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3846: l_func_currency gl_sets_of_books.currency_code%TYPE;

Line 3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3839: l_rct_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3846: l_func_currency gl_sets_of_books.currency_code%TYPE;
3847: l_activity_name ar_receivables_trx.name%TYPE;

Line 3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3840: l_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3846: l_func_currency gl_sets_of_books.currency_code%TYPE;
3847: l_activity_name ar_receivables_trx.name%TYPE;
3848: l_ccid NUMBER;

Line 3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

3841: l_act_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3842: l_amt_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3843: l_cust_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3844: l_cur_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3845: l_apply_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3846: l_func_currency gl_sets_of_books.currency_code%TYPE;
3847: l_activity_name ar_receivables_trx.name%TYPE;
3848: l_ccid NUMBER;
3849:

Line 3866: l_act_return_status := FND_API.G_RET_STS_ERROR;

3862:
3863: IF l_ccid IS NULL THEN
3864: FND_MESSAGE.SET_NAME('AR','AR_RW_NO_NETTING_ACCOUNT');
3865: FND_MSG_PUB.Add;
3866: l_act_return_status := FND_API.G_RET_STS_ERROR;
3867: END IF;
3868: EXCEPTION
3869: WHEN NO_DATA_FOUND THEN
3870: FND_MESSAGE.SET_NAME('AR','AR_RW_MISSING_NETTING_ACTIVITY');

Line 3872: l_act_return_status := FND_API.G_RET_STS_ERROR;

3868: EXCEPTION
3869: WHEN NO_DATA_FOUND THEN
3870: FND_MESSAGE.SET_NAME('AR','AR_RW_MISSING_NETTING_ACTIVITY');
3871: FND_MSG_PUB.Add;
3872: l_act_return_status := FND_API.G_RET_STS_ERROR;
3873: END;
3874:
3875: IF p_cash_receipt_id = p_open_cash_receipt_id THEN
3876: FND_MESSAGE.SET_NAME('AR','AR_RW_NET_RCT_APPLY_SELF');

Line 3878: l_rct_return_status := FND_API.G_RET_STS_ERROR;

3874:
3875: IF p_cash_receipt_id = p_open_cash_receipt_id THEN
3876: FND_MESSAGE.SET_NAME('AR','AR_RW_NET_RCT_APPLY_SELF');
3877: FND_MSG_PUB.Add;
3878: l_rct_return_status := FND_API.G_RET_STS_ERROR;
3879: END IF;
3880:
3881: -- Check if valid paying customer
3882: IF NOT arp_trx_validate.validate_paying_customer(

Line 3892: l_cust_return_status := FND_API.G_RET_STS_ERROR;

3888: p_pay_unrelated_invoices_flag => arp_global.sysparam.pay_unrelated_invoices_flag,
3889: p_ct_prev_trx_date => p_cr_date) THEN
3890: FND_MESSAGE.SET_NAME('AR','ARTA_PYMNT_UNRELATED_CUST');
3891: FND_MSG_PUB.Add;
3892: l_cust_return_status := FND_API.G_RET_STS_ERROR;
3893: END IF;
3894:
3895:
3896: validate_apply_date(p_apply_date,

Line 3915: l_gl_date_return_status := FND_API.G_RET_STS_ERROR;

3911:
3912: IF p_apply_gl_date < p_open_cr_gl_date THEN
3913: FND_MESSAGE.SET_NAME('AR','AR_RW_GL_DATE_BEFORE_OPEN_REC');
3914: FND_MSG_PUB.Add;
3915: l_gl_date_return_status := FND_API.G_RET_STS_ERROR;
3916: END IF;
3917:
3918:
3919: IF PG_DEBUG in ('Y', 'C') THEN

Line 3929: l_amt_return_status := FND_API.G_RET_STS_ERROR;

3925: -- validate amount applied
3926: IF p_amount_applied IS NULL THEN
3927: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APPLIED_AMT_NULL');
3928: FND_MSG_PUB.Add;
3929: l_amt_return_status := FND_API.G_RET_STS_ERROR;
3930:
3931: ELSE
3932: -- Bug 2897244 - receipt overapplication not checked if called
3933: -- from ARXRWAPP or PostBatch

Line 3939: l_amt_return_status := FND_API.G_RET_STS_ERROR;

3935: THEN
3936: IF (nvl(p_unapplied_cash,0)- p_amount_applied) < 0 THEN
3937: FND_MESSAGE.SET_NAME('AR','AR_RW_AMOUNT_LESS_THAN_APP');
3938: FND_MSG_PUB.Add;
3939: l_amt_return_status := FND_API.G_RET_STS_ERROR;
3940: END IF;
3941: END IF;
3942: IF ((SIGN(p_other_amount_applied * -1) <> SIGN(p_amount_applied)) OR
3943: (ABS(p_amount_applied) > ABS(p_other_amount_applied)) ) THEN

Line 3946: l_amt_return_status := FND_API.G_RET_STS_ERROR;

3942: IF ((SIGN(p_other_amount_applied * -1) <> SIGN(p_amount_applied)) OR
3943: (ABS(p_amount_applied) > ABS(p_other_amount_applied)) ) THEN
3944: FND_MESSAGE.SET_NAME('AR','AR_RW_NET_OPEN_AMT_INC');
3945: FND_MSG_PUB.Add;
3946: l_amt_return_status := FND_API.G_RET_STS_ERROR;
3947: END IF;
3948:
3949: END IF;
3950:

Line 3964: l_cur_return_status := FND_API.G_RET_STS_ERROR;

3960:
3961: IF (p_receipt_currency <> p_open_receipt_currency) THEN
3962: FND_MESSAGE.SET_NAME('AR','AR_RW_NET_DIFF_RCT_CURR');
3963: FND_MSG_PUB.Add;
3964: l_cur_return_status := FND_API.G_RET_STS_ERROR;
3965: END IF;
3966:
3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR

Line 3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR

3963: FND_MSG_PUB.Add;
3964: l_cur_return_status := FND_API.G_RET_STS_ERROR;
3965: END IF;
3966:
3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR
3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR

Line 3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR

3964: l_cur_return_status := FND_API.G_RET_STS_ERROR;
3965: END IF;
3966:
3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR
3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR

Line 3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR

3965: END IF;
3966:
3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR
3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR
3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR

3966:
3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR
3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR
3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3974:

Line 3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR

3967: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR
3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR
3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3974:
3975: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR

3968: l_rct_return_status <> FND_API.G_RET_STS_SUCCESS OR
3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR
3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3974:
3975: p_return_status := FND_API.G_RET_STS_ERROR;
3976: END IF;

Line 3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3969: l_act_return_status <> FND_API.G_RET_STS_SUCCESS OR
3970: l_amt_return_status <> FND_API.G_RET_STS_SUCCESS OR
3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR
3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3974:
3975: p_return_status := FND_API.G_RET_STS_ERROR;
3976: END IF;
3977:

Line 3975: p_return_status := FND_API.G_RET_STS_ERROR;

3971: l_cur_return_status <> FND_API.G_RET_STS_SUCCESS OR
3972: l_cust_return_status <> FND_API.G_RET_STS_SUCCESS OR
3973: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3974:
3975: p_return_status := FND_API.G_RET_STS_ERROR;
3976: END IF;
3977:
3978: IF PG_DEBUG in ('Y', 'C') THEN
3979: arp_util.debug('ar_receipt_val_pvt.validate_open_receipt_info()-');

Line 3986: p_return_status := FND_API.G_RET_STS_ERROR ;

3982: WHEN others THEN
3983: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
3984: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
3985: FND_MSG_PUB.Add;
3986: p_return_status := FND_API.G_RET_STS_ERROR ;
3987: IF PG_DEBUG in ('Y', 'C') THEN
3988: arp_util.debug('EXCEPTION :ar_receipt_val_pvt.validate_open_receipt_info '||SQLERRM);
3989: END IF;
3990:

Line 4028: p_return_status := FND_API.G_RET_STS_ERROR;

4024:
4025: IF (l_cr_amount - l_amount_applied - p_amount_applied) < 0 THEN
4026: FND_MESSAGE.set_name('AR','AR_RW_NET_UNAPP_OVERAPP');
4027: FND_MSG_PUB.Add;
4028: p_return_status := FND_API.G_RET_STS_ERROR;
4029: END IF;
4030:
4031: IF PG_DEBUG in ('Y', 'C') THEN
4032: arp_util.debug('ar_receipt_val_pvt.validate_unapp_open_receipt()-');

Line 4040: p_return_status := FND_API.G_RET_STS_ERROR ;

4036: WHEN others THEN
4037: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
4038: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
4039: FND_MSG_PUB.Add;
4040: p_return_status := FND_API.G_RET_STS_ERROR ;
4041: IF PG_DEBUG in ('Y', 'C') THEN
4042: arp_util.debug('EXCEPTION :ar_receipt_val_pvt.validate_unapp_open_receipt '||SQLERRM);
4043: END IF;
4044:

Line 4174: p_return_status := FND_API.G_RET_STS_SUCCESS;

4170: IF PG_DEBUG in ('Y', 'C') THEN
4171: arp_util.debug('ar_receipt_val_pvt.validate_llac_insert_ad()+');
4172: END IF;
4173:
4174: p_return_status := FND_API.G_RET_STS_SUCCESS;
4175:
4176: IF PG_DEBUG in ('Y', 'C') THEN
4177: arp_util.debug('Initialization the GT tables ...');
4178: arp_util.debug('DONE In the default initialization the GT tables ...');

Line 4527: If l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS Then

4523: 'AR_ACTIVITY_DETAILS',
4524: l_dflex_val_return_status
4525: );
4526:
4527: If l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS Then
4528: p_return_status := 'X';
4529: ar_receipt_lib_pvt.populate_errors_gt(
4530: p_customer_trx_id => p_customer_trx_id,
4531: p_customer_trx_line_id => sp_lines_row.customer_trx_line_id,

Line 4572: p_return_status := FND_API.G_RET_STS_ERROR ;

4568: and line.line_type = 'LINE'
4569: and line.customer_trx_line_id = tax.link_to_cust_trx_line_id (+);
4570: EXCEPTION
4571: WHEN NO_DATA_FOUND THEN
4572: p_return_status := FND_API.G_RET_STS_ERROR ;
4573: FND_MESSAGE.SET_NAME( 'AR','AR_RAPI_TRX_LINE_ID_INVALID');
4574: FND_MSG_PUB.ADD;
4575: RAISE;
4576: WHEN others THEN

Line 4606: p_return_status := FND_API.G_RET_STS_ERROR;

4602: IF PG_DEBUG in ('Y', 'C') THEN
4603: arp_util.debug('l_calc_amount_app_from > l_cr_unapp_bal' );
4604: arp_util.debug('Raise an error... amount applied and buckets');
4605: END IF;
4606: p_return_status := FND_API.G_RET_STS_ERROR;
4607: fnd_message.set_name ('AR','AR_RW_APP_NEG_UNAPP');
4608: fnd_msg_pub.Add;
4609: End If; */
4610:

Line 4766: ll_return_status := FND_API.G_RET_STS_SUCCESS;

4762: Begin
4763: IF PG_DEBUG in ('Y', 'C') THEN
4764: arp_util.debug('ar_receipt_val_pvt.validate_llac_insert_app()+');
4765: END IF;
4766: ll_return_status := FND_API.G_RET_STS_SUCCESS;
4767: -- Execute the application and populate the Line wise details into RA GT
4768: For rcv_lines_row in rcv_lines_cur (p_customer_trx_id, p_cash_receipt_id)
4769: LOOP
4770:

Line 4829: IF ll_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4825: IF PG_DEBUG in ('Y', 'C') THEN
4826: arp_util.debug('ar_receipt_val_pvt.validate_llac_insert_app(Line)+');
4827: END IF;
4828:
4829: IF ll_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4830: ll_return_status := FND_API.G_RET_STS_ERROR;
4831: ELSE
4832: FOR rcv_frtchg_row in rcv_frtchg_cur (p_customer_trx_id, p_cash_receipt_id)
4833: LOOP

Line 4830: ll_return_status := FND_API.G_RET_STS_ERROR;

4826: arp_util.debug('ar_receipt_val_pvt.validate_llac_insert_app(Line)+');
4827: END IF;
4828:
4829: IF ll_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4830: ll_return_status := FND_API.G_RET_STS_ERROR;
4831: ELSE
4832: FOR rcv_frtchg_row in rcv_frtchg_cur (p_customer_trx_id, p_cash_receipt_id)
4833: LOOP
4834: l_demon := p_disc_earn_allowed + (p_disc_max_allowed - p_disc_earn_allowed);