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

Line 23: p_return_status := FND_API.G_RET_STS_SUCCESS;

19: IF PG_DEBUG in ('Y', 'C') THEN
20: arp_util.debug('Default_customer_trx_id ()+');
21: arp_util.debug(' Trx Number is '|| p_trx_number);
22: END IF;
23: p_return_status := FND_API.G_RET_STS_SUCCESS;
24: IF p_customer_trx_id IS NULL THEN
25: IF p_trx_number IS NOT NULL THEN
26: BEGIN
27: SELECT customer_trx_id

Line 35: p_return_status := FND_API.G_RET_STS_ERROR ;

31: EXCEPTION
32: WHEN no_data_found THEN
33: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INVALID');
34: FND_MSG_PUB.Add;
35: p_return_status := FND_API.G_RET_STS_ERROR ;
36: END;
37: END IF;
38:
39: ELSE -- p_customer_trx_id IS NOT NULL

Line 72: p_return_status := FND_API.G_RET_STS_SUCCESS;

68: BEGIN
69: IF PG_DEBUG in ('Y', 'C') THEN
70: arp_util.debug('Default_customer_trx_line_id ()+');
71: END IF;
72: p_return_status := FND_API.G_RET_STS_SUCCESS;
73:
74: IF p_inv_customer_trx_line_id IS NOT NULL AND
75: p_inv_line_number IS NOT NULL
76: THEN

Line 100: p_return_status := FND_API.G_RET_STS_ERROR ;

96: EXCEPTION
97: WHEN no_data_found THEN
98: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_LINE_NO_INVALID');
99: FND_MSG_PUB.Add;
100: p_return_status := FND_API.G_RET_STS_ERROR ;
101: END;
102: END IF;
103: END IF;
104: ELSE

Line 116: p_return_status := FND_API.G_RET_STS_ERROR ;

112: EXCEPTION
113: WHEN no_data_found THEN
114: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_LINE_ID_INVALID');
115: FND_MSG_PUB.Add;
116: p_return_status := FND_API.G_RET_STS_ERROR ;
117: END;
118: END IF;
119: END IF;
120: IF PG_DEBUG in ('Y', 'C') THEN

Line 144: p_return_status := FND_API.G_RET_STS_SUCCESS;

140: ) IS
141:
142: BEGIN
143:
144: p_return_status := FND_API.G_RET_STS_SUCCESS;
145:
146: IF PG_DEBUG in ('Y', 'C') THEN
147: arp_util.debug('Default_CM_Info ()+');
148: END IF;

Line 174: p_return_status := FND_API.G_RET_STS_ERROR;

170: EXCEPTION
171: WHEN NO_DATA_FOUND THEN
172: FND_MESSAGE.SET_NAME( 'AR','AR_CMAPI_CM_TRX_ID_INVALID');
173: FND_MSG_PUB.ADD;
174: p_return_status := FND_API.G_RET_STS_ERROR;
175: WHEN OTHERS THEN
176: IF PG_DEBUG in ('Y', 'C') THEN
177: arp_util.debug('EXCEPTION: Default_CM_Info()');
178: END IF;

Line 184: p_return_status := FND_API.G_RET_STS_ERROR ;

180:
181: ELSE
182: FND_MESSAGE.SET_NAME( 'AR','AR_CMAPI_CM_TRX_ID_NULL');
183: FND_MSG_PUB.ADD;
184: p_return_status := FND_API.G_RET_STS_ERROR ;
185: END IF;
186:
187:
188: IF PG_DEBUG in ('Y', 'C') THEN

Line 230: p_return_status := FND_API.G_RET_STS_SUCCESS;

226:
227: IF PG_DEBUG in ('Y', 'C') THEN
228: arp_util.debug('Default_Trx_Info ()+');
229: END IF;
230: p_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: IF p_inv_customer_trx_id IS NOT NULL AND
233: p_installment IS NOT NULL THEN
234: IF arp_global.sysparam.pay_unrelated_invoices_flag = 'Y' THEN

Line 340: p_return_status := FND_API.G_RET_STS_ERROR ;

336: IF l_applied_payment_schedule_id <>
337: p_applied_payment_schedule_id THEN
338: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_PS_ID_X_INVALID');
339: FND_MSG_PUB.Add;
340: p_return_status := FND_API.G_RET_STS_ERROR ;
341: END IF;
342: ELSE
343: p_applied_payment_schedule_id := l_applied_payment_schedule_id;
344: END IF;

Line 351: p_return_status := FND_API.G_RET_STS_ERROR ;

347: ELSE --case when p_customer_trx_id is null
348: --no further validation done in the validation routines for customer_trx_id
349: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
350: FND_MSG_PUB.Add;
351: p_return_status := FND_API.G_RET_STS_ERROR ;
352:
353: END IF;
354:
355: IF PG_DEBUG in ('Y', 'C') THEN

Line 392: p_return_status := FND_API.G_RET_STS_SUCCESS;

388: IF PG_DEBUG in ('Y', 'C') THEN
389: arp_util.debug('Default_amt_applied ()+');
390: END IF;
391:
392: p_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: IF p_amount_applied IS NULL THEN
395: IF PG_DEBUG in ('Y', 'C') THEN
396: arp_util.debug('Default_amt_applied: ' || 'p_amount_applied is NULL ');

Line 447: p_return_status := FND_API.G_RET_STS_SUCCESS;

443:
444: IF PG_DEBUG in ('Y', 'C') THEN
445: arp_util.debug('Validate_apply_date ()+');
446: END IF;
447: p_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: IF p_apply_date IS NOT NULL THEN
450:
451: -- check that the apply date is not before the invoice date.

Line 455: p_return_status := FND_API.G_RET_STS_ERROR;

451: -- check that the apply date is not before the invoice date.
452: IF p_apply_date < p_inv_trx_date THEN
453: FND_MESSAGE.SET_NAME('AR','AR_APPLY_BEFORE_TRANSACTION');
454: FND_MSG_PUB.Add;
455: p_return_status := FND_API.G_RET_STS_ERROR;
456:
457: -- check that the application date is not before the CM trx date.
458: END IF;
459:

Line 463: p_return_status := FND_API.G_RET_STS_ERROR;

459:
460: IF p_apply_date < p_cm_trx_date THEN
461: FND_MESSAGE.SET_NAME('AR','AR_APPLY_BEFORE_CM');
462: FND_MSG_PUB.Add;
463: p_return_status := FND_API.G_RET_STS_ERROR;
464: END IF;
465:
466: END IF;
467:

Line 489: p_return_status := FND_API.G_RET_STS_SUCCESS;

485: IF PG_DEBUG in ('Y', 'C') THEN
486: arp_util.debug('Validate_apply_gl_date ()+');
487: END IF;
488:
489: p_return_status := FND_API.G_RET_STS_SUCCESS;
490:
491: IF p_apply_gl_date IS NOT NULL THEN
492:
493: -- Check that the application GL Date is not before the invoice GL Date.

Line 497: p_return_status := FND_API.G_RET_STS_ERROR;

493: -- Check that the application GL Date is not before the invoice GL Date.
494: IF p_apply_gl_date < p_inv_gl_date THEN
495: FND_MESSAGE.SET_NAME('AR','AR_VAL_GL_INV_GL');
496: FND_MSG_PUB.Add;
497: p_return_status := FND_API.G_RET_STS_ERROR;
498:
499: -- Check that the application GL Date is not before the CM GL Date.
500: END IF;
501: IF p_apply_gl_date < p_cm_gl_date THEN

Line 504: p_return_status := FND_API.G_RET_STS_ERROR;

500: END IF;
501: IF p_apply_gl_date < p_cm_gl_date THEN
502: FND_MESSAGE.SET_NAME('AR','AR_RW_GL_DATE_BEFORE_CM_GL');
503: FND_MSG_PUB.Add;
504: p_return_status := FND_API.G_RET_STS_ERROR;
505: END IF;
506:
507:
508: -- Check that the Application GL Date is in an open or future GL period.

Line 513: p_return_status := FND_API.G_RET_STS_ERROR;

509: IF ( NOT arp_util.is_gl_date_valid( p_apply_gl_date )) THEN
510: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
511: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_apply_gl_date ));
512: FND_MSG_PUB.Add;
513: p_return_status := FND_API.G_RET_STS_ERROR;
514: END IF;
515:
516:
517: END IF;

Line 544: p_return_status := FND_API.G_RET_STS_SUCCESS;

540:
541: IF PG_DEBUG in ('Y', 'C') THEN
542: arp_util.debug('Validate_amount_applied ()+');
543: END IF;
544: p_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546:
547: IF p_amount_applied IS NULL THEN
548: p_return_status := FND_API.G_RET_STS_ERROR;

Line 548: p_return_status := FND_API.G_RET_STS_ERROR;

544: p_return_status := FND_API.G_RET_STS_SUCCESS;
545:
546:
547: IF p_amount_applied IS NULL THEN
548: p_return_status := FND_API.G_RET_STS_ERROR;
549: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APPLIED_AMT_NULL');
550: FND_MSG_PUB.Add;
551: return;
552: END IF;

Line 575: p_return_status := FND_API.G_RET_STS_SUCCESS;

571: BEGIN
572: IF PG_DEBUG in ('Y', 'C') THEN
573: arp_util.debug('Get_trx_ps_id ()+');
574: END IF;
575: p_return_status := FND_API.G_RET_STS_SUCCESS;
576:
577: IF p_installment IS NOT NULL THEN
578: BEGIN
579: SELECT ps.payment_schedule_id

Line 593: p_return_status := FND_API.G_RET_STS_ERROR;

589: WHEN no_data_found THEN
590: IF ar_cm_api_pub.Original_cm_unapp_info.inv_customer_trx_id IS NOT NULL THEN
591: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_ID_INST_INVALID');
592: FND_MSG_PUB.Add;
593: p_return_status := FND_API.G_RET_STS_ERROR;
594: ELSIF ar_cm_api_pub.Original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
595: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INST_INVALID');
596: FND_MSG_PUB.Add;
597: p_return_status := FND_API.G_RET_STS_ERROR;

Line 597: p_return_status := FND_API.G_RET_STS_ERROR;

593: p_return_status := FND_API.G_RET_STS_ERROR;
594: ELSIF ar_cm_api_pub.Original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
595: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INST_INVALID');
596: FND_MSG_PUB.Add;
597: p_return_status := FND_API.G_RET_STS_ERROR;
598: END IF;
599:
600: END;
601: ELSE

Line 617: p_return_status := FND_API.G_RET_STS_ERROR;

613: EXCEPTION
614: WHEN no_data_found THEN
615: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');
616: FND_MSG_PUB.Add;
617: p_return_status := FND_API.G_RET_STS_ERROR;
618: WHEN too_many_rows THEN
619: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INSTALL_NULL');
620: FND_MSG_PUB.Add;
621: p_return_status := FND_API.G_RET_STS_ERROR;

Line 621: p_return_status := FND_API.G_RET_STS_ERROR;

617: p_return_status := FND_API.G_RET_STS_ERROR;
618: WHEN too_many_rows THEN
619: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INSTALL_NULL');
620: FND_MSG_PUB.Add;
621: p_return_status := FND_API.G_RET_STS_ERROR;
622: END;
623:
624:
625: END IF;

Line 665: p_return_status := FND_API.G_RET_STS_SUCCESS;

661: IF PG_DEBUG in ('Y', 'C') THEN
662: arp_util.debug('get_ra_info ()+');
663: END IF;
664:
665: p_return_status := FND_API.G_RET_STS_SUCCESS;
666:
667: OPEN rec_apppln;
668: FETCH rec_apppln INTO p_inv_customer_trx_id, p_ra_app_ps_id,p_apply_gl_date;
669: IF rec_apppln%NOTFOUND THEN

Line 672: p_return_status := FND_API.G_RET_STS_ERROR;

668: FETCH rec_apppln INTO p_inv_customer_trx_id, p_ra_app_ps_id,p_apply_gl_date;
669: IF rec_apppln%NOTFOUND THEN
670: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
671: FND_MSG_PUB.Add;
672: p_return_status := FND_API.G_RET_STS_ERROR;
673: END IF;
674: CLOSE rec_apppln;
675:
676:

Line 700: p_return_status := FND_API.G_RET_STS_SUCCESS;

696: BEGIN
697: IF PG_DEBUG in ('Y', 'C') THEN
698: arp_util.debug('Default_ra_id ()+');
699: END IF;
700: p_return_status := FND_API.G_RET_STS_SUCCESS;
701: IF p_cm_customer_trx_id IS NOT NULL AND
702: p_applied_payment_schedule_id IS NOT NULL
703: THEN
704: SELECT receivable_application_id, gl_date

Line 721: p_return_status := FND_API.G_RET_STS_ERROR;

717: EXCEPTION
718: WHEN no_data_found THEN
719: FND_MESSAGE.SET_NAME('AR','AR_CMAPI_CM_NOT_APP_TO_INV');
720: FND_MSG_PUB.Add;
721: p_return_status := FND_API.G_RET_STS_ERROR;
722: raise;
723: WHEN others THEN
724: IF PG_DEBUG in ('Y', 'C') THEN
725: arp_util.debug('Default_ra_id: ' || 'EXCEPTION: Get_ra_id()');

Line 784: --to FND_API.G_RET_STS_ERROR in the validation phase.

780: p_reversal_gl_date := l_default_gl_date;
781: ELSE
782: --we were not able to default the gl_date put the message
783: --here on the stack, but the return status will be set
784: --to FND_API.G_RET_STS_ERROR in the validation phase.
785: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
786: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT', l_error_message);
787: FND_MSG_PUB.Add;
788: END IF;

Line 809: p_return_status := FND_API.G_RET_STS_SUCCESS;

805: p_application_type IN VARCHAR2,
806: p_return_status OUT NOCOPY VARCHAR2) IS
807: l_valid NUMBER;
808: BEGIN
809: p_return_status := FND_API.G_RET_STS_SUCCESS;
810: IF PG_DEBUG in ('Y', 'C') THEN
811: arp_util.debug('Validate_ra_id ()+');
812: END IF;
813: --validate the receivable application id only if it was passed in

Line 829: p_return_status := FND_API.G_RET_STS_ERROR;

825:
826: IF l_valid = 0 THEN
827: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');
828: FND_MSG_PUB.Add;
829: p_return_status := FND_API.G_RET_STS_ERROR;
830: END IF;
831:
832: ELSIF p_receivable_application_id IS NULL THEN
833: IF ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL AND

Line 842: p_return_status := FND_API.G_RET_STS_ERROR;

838: THEN
839: --receivable application id is null
840: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_NULL');
841: FND_MSG_PUB.Add;
842: p_return_status := FND_API.G_RET_STS_ERROR;
843: ELSIF ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL AND
844: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NULL AND
845: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NULL AND
846: (ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NOT NULL OR

Line 852: p_return_status := FND_API.G_RET_STS_ERROR;

848: THEN
849: --the transaction was not specified
850: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_NULL');
851: FND_MSG_PUB.Add;
852: p_return_status := FND_API.G_RET_STS_ERROR;
853: ELSIF (ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL OR
854: ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
855: ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL) AND
856: ar_cm_api_pub.original_cm_unapp_info.cm_customer_trx_id IS NULL AND

Line 862: p_return_status := FND_API.G_RET_STS_ERROR;

858: THEN
859: --the credit memo was not specified
860: FND_MESSAGE.SET_NAME('AR','AR_CMAPI_CM_TRX_ID_NULL');
861: FND_MSG_PUB.Add;
862: p_return_status := FND_API.G_RET_STS_ERROR;
863: END IF;
864:
865: END IF;
866: IF PG_DEBUG in ('Y', 'C') THEN

Line 889: p_return_status := FND_API.G_RET_STS_SUCCESS;

885: BEGIN
886: IF PG_DEBUG in ('Y', 'C') THEN
887: arp_util.debug('Validate_Rev_gl_date ()+');
888: END IF;
889: p_return_status := FND_API.G_RET_STS_SUCCESS;
890: IF p_reversal_gl_date IS NOT NULL THEN
891:
892: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
893: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');

Line 896: p_return_status := FND_API.G_RET_STS_ERROR;

892: IF p_reversal_gl_date < NVL(p_apply_gl_date,p_reversal_gl_date) THEN
893: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
894: FND_MESSAGE.SET_TOKEN('GL_DATE', p_apply_gl_date);
895: FND_MSG_PUB.Add;
896: p_return_status := FND_API.G_RET_STS_ERROR;
897: END IF;
898: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
899: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_CM_GL_DATE');
900: FND_MESSAGE.SET_TOKEN('GL_DATE', p_cm_gl_date);

Line 902: p_return_status := FND_API.G_RET_STS_ERROR;

898: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
899: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_CM_GL_DATE');
900: FND_MESSAGE.SET_TOKEN('GL_DATE', p_cm_gl_date);
901: FND_MSG_PUB.Add;
902: p_return_status := FND_API.G_RET_STS_ERROR;
903: END IF;
904:
905: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
906: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );

Line 909: p_return_status := FND_API.G_RET_STS_ERROR;

905: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
906: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
907: FND_MESSAGE.set_token( 'GL_DATE', TO_CHAR( p_reversal_gl_date ));
908: FND_MSG_PUB.Add;
909: p_return_status := FND_API.G_RET_STS_ERROR;
910: END IF;
911:
912: ELSE
913: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');

Line 915: p_return_status := FND_API.G_RET_STS_ERROR;

911:
912: ELSE
913: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');
914: FND_MSG_PUB.Add;
915: p_return_status := FND_API.G_RET_STS_ERROR;
916: IF PG_DEBUG in ('Y', 'C') THEN
917: arp_util.debug('Validate_Rev_gl_date: ' || 'The Reversal gl date is null ');
918: END IF;
919: END IF;

Line 965: p_return_status := FND_API.G_RET_STS_SUCCESS;

961: IF PG_DEBUG in ('Y', 'C') THEN
962: arp_util.debug('default_app_ids(+)');
963: END IF;
964:
965: p_return_status := FND_API.G_RET_STS_SUCCESS;
966:
967: -- Step 1: Get a valid value for CM customer_trx_id
968: IF p_cm_trx_number IS NOT NULL THEN
969: default_customer_trx_id(p_cm_customer_trx_id ,

Line 998: p_return_status := FND_API.G_RET_STS_ERROR ;

994: l_installment;
995: IF c_pay_sched%NOTFOUND THEN
996: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
997: FND_MSG_PUB.Add;
998: p_return_status := FND_API.G_RET_STS_ERROR ;
999: END IF;
1000: CLOSE c_pay_sched;
1001:
1002: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1002: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

998: p_return_status := FND_API.G_RET_STS_ERROR ;
999: END IF;
1000: CLOSE c_pay_sched;
1001:
1002: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
1003: IF nvl(p_inv_customer_trx_id,nvl(l_inv_customer_trx_id,-99)) = nvl(l_inv_customer_trx_id,-99) THEN
1004: p_inv_customer_trx_id := l_inv_customer_trx_id;
1005: END IF;
1006: IF nvl(p_installment,nvl(l_installment,-99)) = nvl(l_installment,-99) THEN

Line 1023: p_return_status := FND_API.G_RET_STS_ERROR;

1019: EXCEPTION
1020: WHEN no_data_found THEN
1021: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');
1022: FND_MSG_PUB.Add;
1023: p_return_status := FND_API.G_RET_STS_ERROR;
1024: WHEN too_many_rows THEN
1025: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INSTALL_NULL');
1026: FND_MSG_PUB.Add;
1027: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1027: p_return_status := FND_API.G_RET_STS_ERROR;

1023: p_return_status := FND_API.G_RET_STS_ERROR;
1024: WHEN too_many_rows THEN
1025: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INSTALL_NULL');
1026: FND_MSG_PUB.Add;
1027: p_return_status := FND_API.G_RET_STS_ERROR;
1028: END;
1029: END IF;
1030: END IF;
1031: END IF;

Line 1034: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR

1030: END IF;
1031: END IF;
1032:
1033:
1034: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR
1035: p_return_status = FND_API.G_RET_STS_ERROR) THEN
1036: p_return_status := FND_API.G_RET_STS_ERROR;
1037: END IF;
1038:

Line 1035: p_return_status = FND_API.G_RET_STS_ERROR) THEN

1031: END IF;
1032:
1033:
1034: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR
1035: p_return_status = FND_API.G_RET_STS_ERROR) THEN
1036: p_return_status := FND_API.G_RET_STS_ERROR;
1037: END IF;
1038:
1039: IF PG_DEBUG in ('Y', 'C') THEN

Line 1036: p_return_status := FND_API.G_RET_STS_ERROR;

1032:
1033:
1034: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR
1035: p_return_status = FND_API.G_RET_STS_ERROR) THEN
1036: p_return_status := FND_API.G_RET_STS_ERROR;
1037: END IF;
1038:
1039: IF PG_DEBUG in ('Y', 'C') THEN
1040: arp_util.debug('Default_app_ids: ' || 'Defaulted Value for the application ids');

Line 1121: p_return_status := FND_API.G_RET_STS_SUCCESS;

1117: IF PG_DEBUG in ('Y', 'C') THEN
1118: arp_util.debug('Default_app_info ()+');
1119: END IF;
1120:
1121: p_return_status := FND_API.G_RET_STS_SUCCESS;
1122:
1123: -- Step 1: Default CM Info:
1124: default_cm_info(
1125: p_cm_customer_trx_id,

Line 1140: IF l_cm_info_return_status = FND_API.G_RET_STS_SUCCESS THEN

1136: END IF;
1137:
1138: -- Step 2: Default DM info
1139:
1140: IF l_cm_info_return_status = FND_API.G_RET_STS_SUCCESS THEN
1141: Default_Trx_Info(
1142: p_inv_customer_trx_id ,
1143: p_inv_customer_trx_line_id ,
1144: p_show_closed_invoices ,

Line 1284: p_return_status := FND_API.G_RET_STS_SUCCESS;

1280: IF PG_DEBUG in ('Y', 'C') THEN
1281: arp_util.debug('Validate_App_info ()+');
1282: END IF;
1283:
1284: p_return_status := FND_API.G_RET_STS_SUCCESS;
1285:
1286: validate_apply_date(p_apply_date,
1287: p_inv_trx_date,
1288: p_cm_trx_date,

Line 1312: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR

1308: p_natural_appln_only_flag ,
1309: p_inv_amount_rem ,
1310: l_amt_applied_return_status
1311: );
1312: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1313: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1314: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1315: p_return_status := FND_API.G_RET_STS_ERROR;
1316: END IF;

Line 1313: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR

1309: p_inv_amount_rem ,
1310: l_amt_applied_return_status
1311: );
1312: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1313: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1314: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1315: p_return_status := FND_API.G_RET_STS_ERROR;
1316: END IF;
1317:

Line 1314: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1310: l_amt_applied_return_status
1311: );
1312: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1313: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1314: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1315: p_return_status := FND_API.G_RET_STS_ERROR;
1316: END IF;
1317:
1318: IF PG_DEBUG in ('Y', 'C') THEN

Line 1315: p_return_status := FND_API.G_RET_STS_ERROR;

1311: );
1312: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1313: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1314: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1315: p_return_status := FND_API.G_RET_STS_ERROR;
1316: END IF;
1317:
1318: IF PG_DEBUG in ('Y', 'C') THEN
1319: arp_util.debug('Validate_App_info ()-');

Line 1351: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1347: payment_schedule_id >0 and
1348: class in ('INV','DM'); -- Should we include BR, DEP, GUAR, CB?
1349:
1350:
1351: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1352: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1353: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1354: l_inv_customer_trx_id NUMBER;
1355: l_applied_payment_schedule_id NUMBER;

Line 1352: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1348: class in ('INV','DM'); -- Should we include BR, DEP, GUAR, CB?
1349:
1350:
1351: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1352: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1353: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1354: l_inv_customer_trx_id NUMBER;
1355: l_applied_payment_schedule_id NUMBER;
1356: l_ra_app_ps_id NUMBER;

Line 1353: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1349:
1350:
1351: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1352: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1353: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1354: l_inv_customer_trx_id NUMBER;
1355: l_applied_payment_schedule_id NUMBER;
1356: l_ra_app_ps_id NUMBER;
1357: l_receivable_application_id NUMBER;

Line 1359: l_ra_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1355: l_applied_payment_schedule_id NUMBER;
1356: l_ra_app_ps_id NUMBER;
1357: l_receivable_application_id NUMBER;
1358: l_installment NUMBER(15);
1359: l_ra_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1360:
1361: BEGIN
1362:
1363:

Line 1367: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1363:
1364: IF PG_DEBUG in ('Y', 'C') THEN
1365: arp_util.debug('Default_unapp_ids ()+');
1366: END IF;
1367: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1368:
1369: --Step 1: Get a valid value for the CM customer_trx_id
1370: IF p_cm_trx_number IS NOT NULL THEN
1371: Default_customer_trx_id(p_cm_customer_trx_id ,

Line 1387: IF l_cm_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS AND

1383:
1384: -- Step 3: Get payment schedule info
1385: --if error is raised in deriving the customer_trx_id from the trx_number,
1386: --do not process the applied_payment_schedule_id any further.
1387: IF l_cm_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS AND
1388: l_inv_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS THEN
1389: IF p_applied_payment_schedule_id IS NOT NULL THEN
1390: OPEN c_pay_sched;
1391: FETCH c_pay_sched

Line 1388: l_inv_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS THEN

1384: -- Step 3: Get payment schedule info
1385: --if error is raised in deriving the customer_trx_id from the trx_number,
1386: --do not process the applied_payment_schedule_id any further.
1387: IF l_cm_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS AND
1388: l_inv_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS THEN
1389: IF p_applied_payment_schedule_id IS NOT NULL THEN
1390: OPEN c_pay_sched;
1391: FETCH c_pay_sched
1392: INTO l_inv_customer_trx_id,

Line 1397: p_return_status := FND_API.G_RET_STS_ERROR ;

1393: l_installment;
1394: IF c_pay_sched%NOTFOUND THEN
1395: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
1396: FND_MSG_PUB.Add;
1397: p_return_status := FND_API.G_RET_STS_ERROR ;
1398: END IF;
1399: CLOSE c_pay_sched;
1400:
1401: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1401: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

1397: p_return_status := FND_API.G_RET_STS_ERROR ;
1398: END IF;
1399: CLOSE c_pay_sched;
1400:
1401: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
1402: IF (nvl(p_inv_customer_trx_id,l_inv_customer_trx_id) <> l_inv_customer_trx_id OR
1403: nvl(p_installment,l_installment) <> l_installment) THEN
1404: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_PS_ID_X_INVALID');
1405: FND_MSG_PUB.Add;

Line 1406: p_return_status := FND_API.G_RET_STS_ERROR;

1402: IF (nvl(p_inv_customer_trx_id,l_inv_customer_trx_id) <> l_inv_customer_trx_id OR
1403: nvl(p_installment,l_installment) <> l_installment) THEN
1404: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_PS_ID_X_INVALID');
1405: FND_MSG_PUB.Add;
1406: p_return_status := FND_API.G_RET_STS_ERROR;
1407: ELSE
1408: p_inv_customer_trx_id := l_inv_customer_trx_id;
1409: END IF;
1410:

Line 1441: p_return_status := FND_API.G_RET_STS_ERROR;

1437: IF ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
1438: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
1439: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_RA_ID_X_INVALID');
1440: FND_MSG_PUB.Add;
1441: p_return_status := FND_API.G_RET_STS_ERROR;
1442: ELSIF ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL THEN
1443: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_RA_ID_X_INVALID');
1444: FND_MSG_PUB.Add;
1445: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1445: p_return_status := FND_API.G_RET_STS_ERROR;

1441: p_return_status := FND_API.G_RET_STS_ERROR;
1442: ELSIF ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL THEN
1443: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_RA_ID_X_INVALID');
1444: FND_MSG_PUB.Add;
1445: p_return_status := FND_API.G_RET_STS_ERROR;
1446: END IF;
1447: ELSE
1448: p_applied_payment_schedule_id := l_ra_app_ps_id;
1449: END IF;

Line 1456: p_return_status := FND_API.G_RET_STS_ERROR;

1452: --Invalid receivable application identifier for the entered
1453: -- invoice customer trx id
1454: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_RA_ID_X_INVALID');
1455: FND_MSG_PUB.Add;
1456: p_return_status := FND_API.G_RET_STS_ERROR;
1457: ELSE
1458: p_inv_customer_trx_id := l_inv_customer_trx_id;
1459: END IF;
1460: ELSE --the user has not passed in the receivable application id

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

1537: p_reversal_gl_date IN DATE,
1538: p_apply_gl_date IN DATE,
1539: p_return_status OUT NOCOPY VARCHAR2
1540: ) IS
1541: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1542: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1543:
1544: BEGIN
1545:

Line 1542: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1538: p_apply_gl_date IN DATE,
1539: p_return_status OUT NOCOPY VARCHAR2
1540: ) IS
1541: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1542: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1543:
1544: BEGIN
1545:
1546: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1546: p_return_status := FND_API.G_RET_STS_SUCCESS;

1542: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1543:
1544: BEGIN
1545:
1546: p_return_status := FND_API.G_RET_STS_SUCCESS;
1547: IF PG_DEBUG in ('Y', 'C') THEN
1548: arp_util.debug('Validate_unapp_info ()+');
1549: END IF;
1550: