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 514: p_return_status := FND_API.G_RET_STS_ERROR;

510: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
511: --Int'l Calendar Project
512: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
513: FND_MSG_PUB.Add;
514: p_return_status := FND_API.G_RET_STS_ERROR;
515: END IF;
516:
517:
518: END IF;

Line 545: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 549: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 576: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 594: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 598: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 618: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 622: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 666: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 673: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 701: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 722: p_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 810: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 830: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 843: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 853: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 863: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 890: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 898: p_return_status := FND_API.G_RET_STS_ERROR;

894: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_APP_GL_DATE');
895: --Int'l Calendar Project
896: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_apply_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
897: FND_MSG_PUB.Add;
898: p_return_status := FND_API.G_RET_STS_ERROR;
899: END IF;
900: IF p_reversal_gl_date < nvl(p_cm_gl_date,p_reversal_gl_date) THEN
901: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_CM_GL_DATE');
902: --Int'l Calendar Project

Line 905: p_return_status := FND_API.G_RET_STS_ERROR;

901: FND_MESSAGE.SET_NAME('AR','AR_RW_BEFORE_CM_GL_DATE');
902: --Int'l Calendar Project
903: FND_MESSAGE.SET_TOKEN('GL_DATE', fnd_date.date_to_chardate(p_cm_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
904: FND_MSG_PUB.Add;
905: p_return_status := FND_API.G_RET_STS_ERROR;
906: END IF;
907:
908: IF ( NOT arp_util.is_gl_date_valid(p_reversal_gl_date)) THEN
909: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );

Line 913: p_return_status := FND_API.G_RET_STS_ERROR;

909: FND_MESSAGE.set_name( 'AR', 'AR_INVALID_APP_GL_DATE' );
910: --Int'l Calendar Project
911: FND_MESSAGE.set_token( 'GL_DATE', fnd_date.date_to_chardate(p_reversal_gl_date, calendar_aware=> FND_DATE.calendar_aware_alt));
912: FND_MSG_PUB.Add;
913: p_return_status := FND_API.G_RET_STS_ERROR;
914: END IF;
915:
916: ELSE
917: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REV_GL_DATE_NULL');

Line 919: p_return_status := FND_API.G_RET_STS_ERROR;

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

Line 977: p_return_status := FND_API.G_RET_STS_SUCCESS;

973: IF PG_DEBUG in ('Y', 'C') THEN
974: arp_util.debug('default_app_ids(+)');
975: END IF;
976:
977: p_return_status := FND_API.G_RET_STS_SUCCESS;
978:
979: -- Step 1: Get CM customer_trx_id and validate.
980: IF p_cm_trx_number IS NOT NULL THEN
981: default_customer_trx_id(p_cm_customer_trx_id ,

Line 993: p_return_status := FND_API.G_RET_STS_ERROR ;

989:
990: IF (l_class <> 'CM') then
991: FND_MESSAGE.SET_NAME('AR','AR_CMAPI_CM_TRX_ID_INVALID');
992: FND_MSG_PUB.Add;
993: p_return_status := FND_API.G_RET_STS_ERROR ;
994: END IF;
995:
996: -- Step 2: Get DM/INV customer_trx_id and validate
997: IF p_inv_trx_number IS NOT NULL THEN

Line 1010: p_return_status := FND_API.G_RET_STS_ERROR ;

1006:
1007: If (l_class not in ( 'INV','DM') ) then
1008: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');
1009: FND_MSG_PUB.Add;
1010: p_return_status := FND_API.G_RET_STS_ERROR ;
1011: end if;
1012:
1013: -- Step 3: Get a valid value for DM customer trx line id
1014: default_customer_trx_line_id(p_inv_customer_trx_id,

Line 1030: p_return_status := FND_API.G_RET_STS_ERROR ;

1026: l_installment;
1027: IF c_pay_sched%NOTFOUND THEN
1028: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
1029: FND_MSG_PUB.Add;
1030: p_return_status := FND_API.G_RET_STS_ERROR ;
1031: END IF;
1032: CLOSE c_pay_sched;
1033:
1034: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1034: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

1030: p_return_status := FND_API.G_RET_STS_ERROR ;
1031: END IF;
1032: CLOSE c_pay_sched;
1033:
1034: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
1035: IF nvl(p_inv_customer_trx_id,nvl(l_inv_customer_trx_id,-99)) = nvl(l_inv_customer_trx_id,-99) THEN
1036: p_inv_customer_trx_id := l_inv_customer_trx_id;
1037: END IF;
1038: IF nvl(p_installment,nvl(l_installment,-99)) = nvl(l_installment,-99) THEN

Line 1055: p_return_status := FND_API.G_RET_STS_ERROR;

1051: EXCEPTION
1052: WHEN no_data_found THEN
1053: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CUST_TRX_ID_INVALID');
1054: FND_MSG_PUB.Add;
1055: p_return_status := FND_API.G_RET_STS_ERROR;
1056: WHEN too_many_rows THEN
1057: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INSTALL_NULL');
1058: FND_MSG_PUB.Add;
1059: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1059: p_return_status := FND_API.G_RET_STS_ERROR;

1055: p_return_status := FND_API.G_RET_STS_ERROR;
1056: WHEN too_many_rows THEN
1057: FND_MESSAGE.SET_NAME('AR','AR_RAPI_INSTALL_NULL');
1058: FND_MSG_PUB.Add;
1059: p_return_status := FND_API.G_RET_STS_ERROR;
1060: END;
1061: END IF;
1062: END IF;
1063: END IF;

Line 1066: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR

1062: END IF;
1063: END IF;
1064:
1065:
1066: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR
1067: p_return_status = FND_API.G_RET_STS_ERROR) THEN
1068: p_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;
1070:

Line 1067: p_return_status = FND_API.G_RET_STS_ERROR) THEN

1063: END IF;
1064:
1065:
1066: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR
1067: p_return_status = FND_API.G_RET_STS_ERROR) THEN
1068: p_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;
1070:
1071: IF PG_DEBUG in ('Y', 'C') THEN

Line 1068: p_return_status := FND_API.G_RET_STS_ERROR;

1064:
1065:
1066: IF (p_inv_return_status_lines = FND_API.G_RET_STS_ERROR OR
1067: p_return_status = FND_API.G_RET_STS_ERROR) THEN
1068: p_return_status := FND_API.G_RET_STS_ERROR;
1069: END IF;
1070:
1071: IF PG_DEBUG in ('Y', 'C') THEN
1072: arp_util.debug('Default_app_ids: ' || 'Defaulted Value for the application ids');

Line 1153: p_return_status := FND_API.G_RET_STS_SUCCESS;

1149: IF PG_DEBUG in ('Y', 'C') THEN
1150: arp_util.debug('Default_app_info ()+');
1151: END IF;
1152:
1153: p_return_status := FND_API.G_RET_STS_SUCCESS;
1154:
1155: -- Step 1: Default CM Info:
1156: default_cm_info(
1157: p_cm_customer_trx_id,

Line 1172: IF l_cm_info_return_status = FND_API.G_RET_STS_SUCCESS THEN

1168: END IF;
1169:
1170: -- Step 2: Default DM info
1171:
1172: IF l_cm_info_return_status = FND_API.G_RET_STS_SUCCESS THEN
1173: Default_Trx_Info(
1174: p_inv_customer_trx_id ,
1175: p_inv_customer_trx_line_id ,
1176: p_show_closed_invoices ,

Line 1316: p_return_status := FND_API.G_RET_STS_SUCCESS;

1312: IF PG_DEBUG in ('Y', 'C') THEN
1313: arp_util.debug('Validate_App_info ()+');
1314: END IF;
1315:
1316: p_return_status := FND_API.G_RET_STS_SUCCESS;
1317:
1318: validate_apply_date(p_apply_date,
1319: p_inv_trx_date,
1320: p_cm_trx_date,

Line 1344: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR

1340: p_natural_appln_only_flag ,
1341: p_inv_amount_rem ,
1342: l_amt_applied_return_status
1343: );
1344: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1345: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1346: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1347: p_return_status := FND_API.G_RET_STS_ERROR;
1348: END IF;

Line 1345: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR

1341: p_inv_amount_rem ,
1342: l_amt_applied_return_status
1343: );
1344: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1345: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1346: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1347: p_return_status := FND_API.G_RET_STS_ERROR;
1348: END IF;
1349:

Line 1346: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1342: l_amt_applied_return_status
1343: );
1344: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1345: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1346: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1347: p_return_status := FND_API.G_RET_STS_ERROR;
1348: END IF;
1349:
1350: IF PG_DEBUG in ('Y', 'C') THEN

Line 1347: p_return_status := FND_API.G_RET_STS_ERROR;

1343: );
1344: IF l_gl_date_return_status <> FND_API.G_RET_STS_SUCCESS OR
1345: l_amt_applied_return_status <> FND_API.G_RET_STS_SUCCESS OR
1346: l_apply_date_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1347: p_return_status := FND_API.G_RET_STS_ERROR;
1348: END IF;
1349:
1350: IF PG_DEBUG in ('Y', 'C') THEN
1351: arp_util.debug('Validate_App_info ()-');

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

1379: payment_schedule_id >0 and
1380: class in ('INV','DM'); -- Should we include BR, DEP, GUAR, CB?
1381:
1382:
1383: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1384: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1385: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1386: l_inv_customer_trx_id NUMBER;
1387: l_applied_payment_schedule_id NUMBER;

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

1380: class in ('INV','DM'); -- Should we include BR, DEP, GUAR, CB?
1381:
1382:
1383: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1384: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1385: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1386: l_inv_customer_trx_id NUMBER;
1387: l_applied_payment_schedule_id NUMBER;
1388: l_ra_app_ps_id NUMBER;

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

1381:
1382:
1383: l_cm_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1384: l_inv_cust_trx_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1385: l_applied_ps_id_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1386: l_inv_customer_trx_id NUMBER;
1387: l_applied_payment_schedule_id NUMBER;
1388: l_ra_app_ps_id NUMBER;
1389: l_receivable_application_id NUMBER;

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

1387: l_applied_payment_schedule_id NUMBER;
1388: l_ra_app_ps_id NUMBER;
1389: l_receivable_application_id NUMBER;
1390: l_installment NUMBER(15);
1391: l_ra_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1392:
1393: BEGIN
1394:
1395:

Line 1399: p_return_status := FND_API.G_RET_STS_SUCCESS ;

1395:
1396: IF PG_DEBUG in ('Y', 'C') THEN
1397: arp_util.debug('Default_unapp_ids ()+');
1398: END IF;
1399: p_return_status := FND_API.G_RET_STS_SUCCESS ;
1400:
1401: --Step 1: Get a valid value for the CM customer_trx_id
1402: IF p_cm_trx_number IS NOT NULL THEN
1403: Default_customer_trx_id(p_cm_customer_trx_id ,

Line 1419: IF l_cm_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS AND

1415:
1416: -- Step 3: Get payment schedule info
1417: --if error is raised in deriving the customer_trx_id from the trx_number,
1418: --do not process the applied_payment_schedule_id any further.
1419: IF l_cm_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS AND
1420: l_inv_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS THEN
1421: IF p_applied_payment_schedule_id IS NOT NULL THEN
1422: OPEN c_pay_sched;
1423: FETCH c_pay_sched

Line 1420: l_inv_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS THEN

1416: -- Step 3: Get payment schedule info
1417: --if error is raised in deriving the customer_trx_id from the trx_number,
1418: --do not process the applied_payment_schedule_id any further.
1419: IF l_cm_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS AND
1420: l_inv_cust_trx_return_status= FND_API.G_RET_STS_SUCCESS THEN
1421: IF p_applied_payment_schedule_id IS NOT NULL THEN
1422: OPEN c_pay_sched;
1423: FETCH c_pay_sched
1424: INTO l_inv_customer_trx_id,

Line 1429: p_return_status := FND_API.G_RET_STS_ERROR ;

1425: l_installment;
1426: IF c_pay_sched%NOTFOUND THEN
1427: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_ID_INVALID');
1428: FND_MSG_PUB.Add;
1429: p_return_status := FND_API.G_RET_STS_ERROR ;
1430: END IF;
1431: CLOSE c_pay_sched;
1432:
1433: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 1433: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN

1429: p_return_status := FND_API.G_RET_STS_ERROR ;
1430: END IF;
1431: CLOSE c_pay_sched;
1432:
1433: IF p_return_status = FND_API.G_RET_STS_SUCCESS THEN
1434: IF (nvl(p_inv_customer_trx_id,l_inv_customer_trx_id) <> l_inv_customer_trx_id OR
1435: nvl(p_installment,l_installment) <> l_installment) THEN
1436: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_PS_ID_X_INVALID');
1437: FND_MSG_PUB.Add;

Line 1438: p_return_status := FND_API.G_RET_STS_ERROR;

1434: IF (nvl(p_inv_customer_trx_id,l_inv_customer_trx_id) <> l_inv_customer_trx_id OR
1435: nvl(p_installment,l_installment) <> l_installment) THEN
1436: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_PS_ID_X_INVALID');
1437: FND_MSG_PUB.Add;
1438: p_return_status := FND_API.G_RET_STS_ERROR;
1439: ELSE
1440: p_inv_customer_trx_id := l_inv_customer_trx_id;
1441: END IF;
1442:

Line 1473: p_return_status := FND_API.G_RET_STS_ERROR;

1469: IF ar_cm_api_pub.original_cm_unapp_info.inv_customer_trx_id IS NOT NULL OR
1470: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NOT NULL THEN
1471: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_RA_ID_X_INVALID');
1472: FND_MSG_PUB.Add;
1473: p_return_status := FND_API.G_RET_STS_ERROR;
1474: ELSIF ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL THEN
1475: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_RA_ID_X_INVALID');
1476: FND_MSG_PUB.Add;
1477: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1477: p_return_status := FND_API.G_RET_STS_ERROR;

1473: p_return_status := FND_API.G_RET_STS_ERROR;
1474: ELSIF ar_cm_api_pub.original_cm_unapp_info.applied_ps_id IS NOT NULL THEN
1475: FND_MESSAGE.SET_NAME('AR','AR_RAPI_APP_PS_RA_ID_X_INVALID');
1476: FND_MSG_PUB.Add;
1477: p_return_status := FND_API.G_RET_STS_ERROR;
1478: END IF;
1479: ELSE
1480: p_applied_payment_schedule_id := l_ra_app_ps_id;
1481: END IF;

Line 1488: p_return_status := FND_API.G_RET_STS_ERROR;

1484: --Invalid receivable application identifier for the entered
1485: -- invoice customer trx id
1486: FND_MESSAGE.SET_NAME('AR','AR_RAPI_RCPT_RA_ID_X_INVALID');
1487: FND_MSG_PUB.Add;
1488: p_return_status := FND_API.G_RET_STS_ERROR;
1489: ELSE
1490: p_inv_customer_trx_id := l_inv_customer_trx_id;
1491: END IF;
1492: ELSE --the user has not passed in the receivable application id

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

1569: p_reversal_gl_date IN DATE,
1570: p_apply_gl_date IN DATE,
1571: p_return_status OUT NOCOPY VARCHAR2
1572: ) IS
1573: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1574: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1575:
1576: BEGIN
1577:

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

1570: p_apply_gl_date IN DATE,
1571: p_return_status OUT NOCOPY VARCHAR2
1572: ) IS
1573: l_rec_app_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1574: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1575:
1576: BEGIN
1577:
1578: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1578: p_return_status := FND_API.G_RET_STS_SUCCESS;

1574: l_rev_gl_date_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1575:
1576: BEGIN
1577:
1578: p_return_status := FND_API.G_RET_STS_SUCCESS;
1579: IF PG_DEBUG in ('Y', 'C') THEN
1580: arp_util.debug('Validate_unapp_info ()+');
1581: END IF;
1582: