DBA Data[Home] [Help]

APPS.AR_CM_VAL_PVT dependencies on FND_MSG_PUB

Line 4: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;

1: PACKAGE BODY AR_CM_VAL_PVT AS
2: /* $Header: ARXVCMEB.pls 120.2.12020000.4 2013/03/06 06:03:02 kgnanase ship $ */
3:
4: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
5: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
6: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
7:
8: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 5: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;

1: PACKAGE BODY AR_CM_VAL_PVT AS
2: /* $Header: ARXVCMEB.pls 120.2.12020000.4 2013/03/06 06:03:02 kgnanase ship $ */
3:
4: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
5: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
6: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
7:
8: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
9: PG_PROFILE_APPLN_GL_DATE_DEF varchar2(30) := FND_PROFILE.value('AR_APPLICATION_GL_DATE_DEFAULT');

Line 6: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

2: /* $Header: ARXVCMEB.pls 120.2.12020000.4 2013/03/06 06:03:02 kgnanase ship $ */
3:
4: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
5: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
6: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
7:
8: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
9: PG_PROFILE_APPLN_GL_DATE_DEF varchar2(30) := FND_PROFILE.value('AR_APPLICATION_GL_DATE_DEFAULT');
10:

Line 34: FND_MSG_PUB.Add;

30: WHERE trx_number = p_trx_number;
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:

Line 45: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)

41: IF p_trx_number IS NOT NULL
42: THEN
43: --give a warning message to indicate that the trx number
44: --entered by the user has been ignored.
45: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
46: THEN
47: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_IGN');
48: FND_MSG_PUB.Add;
49: END IF;

Line 48: FND_MSG_PUB.Add;

44: --entered by the user has been ignored.
45: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
46: THEN
47: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_IGN');
48: FND_MSG_PUB.Add;
49: END IF;
50: END IF;
51: END IF;
52: IF PG_DEBUG in ('Y', 'C') THEN

Line 79: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)

75: p_inv_line_number IS NOT NULL
76: THEN
77: --give a warning message to indicate that the line number
78: --entered by the user has been ignored.
79: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
80: THEN
81: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_LINE_NUM_IGN');
82: FND_MSG_PUB.Add;
83: END IF;

Line 82: FND_MSG_PUB.Add;

78: --entered by the user has been ignored.
79: IF FND_MSG_PUB.Check_Msg_Level(G_MSG_SUCCESS)
80: THEN
81: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_LINE_NUM_IGN');
82: FND_MSG_PUB.Add;
83: END IF;
84: END IF;
85:
86: IF p_inv_customer_trx_id IS NOT NULL THEN

Line 99: FND_MSG_PUB.Add;

95: AND line_type = 'LINE';
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;

Line 115: FND_MSG_PUB.Add;

111: AND line_type = 'LINE';
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;

Line 173: FND_MSG_PUB.ADD;

169:
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()');

Line 183: FND_MSG_PUB.ADD;

179: END;
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:

Line 339: FND_MSG_PUB.Add;

335: IF p_applied_payment_schedule_id IS NOT NULL THEN
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;

Line 350: FND_MSG_PUB.Add;

346:
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:

Line 454: FND_MSG_PUB.Add;

450:
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;

Line 462: FND_MSG_PUB.Add;

458: END IF;
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;

Line 496: FND_MSG_PUB.Add;

492:
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;

Line 503: FND_MSG_PUB.Add;

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
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:

Line 513: FND_MSG_PUB.Add;

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: --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:

Line 551: FND_MSG_PUB.Add;

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;
554:
555:

Line 593: FND_MSG_PUB.Add;

589: EXCEPTION
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;

Line 597: FND_MSG_PUB.Add;

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;
599: END IF;
600:
601: END;

Line 617: FND_MSG_PUB.Add;

613: ;
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;

Line 621: FND_MSG_PUB.Add;

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;
623: END;
624:
625:

Line 672: FND_MSG_PUB.Add;

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
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:

Line 721: FND_MSG_PUB.Add;

717: END IF;
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

Line 788: FND_MSG_PUB.Add;

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;
790: END IF;
791: END IF;
792: IF PG_DEBUG in ('Y', 'C') THEN

Line 829: FND_MSG_PUB.Add;

825: and ra.application_type = 'CM';
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

Line 842: FND_MSG_PUB.Add;

838: ar_cm_api_pub.original_cm_unapp_info.inv_trx_number IS NULL
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

Line 852: FND_MSG_PUB.Add;

848: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NOT NULL)
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

Line 862: FND_MSG_PUB.Add;

858: ar_cm_api_pub.original_cm_unapp_info.cm_trx_number IS NULL
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;

Line 897: FND_MSG_PUB.Add;

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');
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');

Line 904: FND_MSG_PUB.Add;

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
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

Line 912: FND_MSG_PUB.Add;

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' );
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

Line 918: FND_MSG_PUB.Add;

914: END IF;
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;

Line 992: FND_MSG_PUB.Add;

988: CLOSE c_trx_type;
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

Line 1009: FND_MSG_PUB.Add;

1005: CLOSE c_trx_type;
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

Line 1029: FND_MSG_PUB.Add;

1025: INTO l_inv_customer_trx_id,
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:

Line 1054: FND_MSG_PUB.Add;

1050: WHERE customer_trx_id = p_inv_customer_trx_id;
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;

Line 1058: FND_MSG_PUB.Add;

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;
1060: END;
1061: END IF;
1062: END IF;

Line 1428: FND_MSG_PUB.Add;

1424: INTO l_inv_customer_trx_id,
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:

Line 1437: FND_MSG_PUB.Add;

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;
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;

Line 1472: FND_MSG_PUB.Add;

1468: THEN
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;

Line 1476: FND_MSG_PUB.Add;

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;
1478: END IF;
1479: ELSE
1480: p_applied_payment_schedule_id := l_ra_app_ps_id;

Line 1487: FND_MSG_PUB.Add;

1483: IF nvl(l_inv_customer_trx_id,-99) <> nvl(p_inv_customer_trx_id,nvl(l_inv_customer_trx_id,-99)) THEN
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;