DBA Data[Home] [Help]

APPS.AR_PREPAYMENTS dependencies on FND_MSG_PUB

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

4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_PREPAYMENTS';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

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

5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_PREPAYMENTS';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

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

6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_PREPAYMENTS';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14:

Line 11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_PREPAYMENTS';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14:
15:

Line 12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;

8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14:
15:
16:

Line 13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;

9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;
12: G_MSG_MEDIUM CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM;
13: G_MSG_LOW CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW;
14:
15:
16:
17: /*========================================================================

Line 653: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

649: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
650:
651: ---Bug 3628401 removed unexpected_error;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
654: p_count => x_msg_count,
655: p_data => x_msg_data
656: );
657: RETURN;

Line 668: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

664: EXCEPTION
665:
666: WHEN OTHERS THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data);
671:
672: IF PG_DEBUG in ('Y', 'C') THEN

Line 818: FND_MSG_PUB.initialize;

814: | Initialize message list if p_init_msg_list is set to TRUE |
815: +--------------------------------------------------------------*/
816: IF FND_API.to_Boolean( p_init_msg_list )
817: THEN
818: FND_MSG_PUB.initialize;
819: END IF;
820: /* SSA change */
821: l_org_id := p_org_id;
822: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

Line 931: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

927: p_org_id,
928: p_payment_trxn_extension_id);
929:
930:
931: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
932: p_count => x_msg_count,
933: p_data => x_msg_data);
934:
935: IF PG_DEBUG in ('Y', 'C') THEN

Line 949: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

945: arp_util.debug('EXCEPTION : ar_prepayment.create_prepayment ||SQLERRM');
946: END IF;
947: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
948:
949: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
950: p_count => x_msg_count,
951: p_data => x_msg_data);
952:
953: END Create_Prepayment;

Line 1070: FND_MSG_PUB.initialize;

1066: +--------------------------------------------------------------*/
1067:
1068: IF FND_API.to_Boolean( p_init_msg_list )
1069: THEN
1070: FND_MSG_PUB.initialize;
1071: END IF;
1072:
1073: IF PG_DEBUG in ('Y', 'C') THEN
1074: arp_util.debug('Refund_Prepayments: ' || 'Activity_application()+ ');

Line 1099: FND_MSG_PUB.Add;

1095: IF (l_payment_set_id IS NULl AND p_receipt_number IS NULL
1096: AND l_cash_receipt_id IS NULL AND l_receivable_application_id IS NULL)
1097: THEN
1098: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_NULL');
1099: FND_MSG_PUB.Add;
1100: x_return_status := FND_API.G_RET_STS_ERROR;
1101: RETURN;
1102: END IF;
1103:

Line 1158: FND_MSG_PUB.Add;

1154: ---Bug: 3504678
1155: if nvl(l_refund_amount,0) > nvl(l_max_refund_amt,0) then
1156: --raise error X validation failed
1157: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');
1158: FND_MSG_PUB.Add;
1159: x_return_status := FND_API.G_RET_STS_ERROR ;
1160: RETURN;
1161: end if;
1162:

Line 1179: FND_MSG_PUB.Add;

1175:
1176: EXCEPTION
1177: when no_data_found then
1178: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CASH_RCPT_ID_INVALID');
1179: FND_MSG_PUB.Add;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: RETURN ;
1182:
1183: when others then

Line 1247: FND_MSG_PUB.Add;

1243: if l_dummy = 0 then
1244: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1245: FND_MESSAGE.SET_TOKEN('PARAMETER','P_PAYMENT_SET_ID');
1246: FND_MESSAGE.SET_TOKEN('VALUE',l_payment_set_id);
1247: FND_MSG_PUB.Add;
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: RETURN;
1250: end if;
1251:

Line 1275: FND_MSG_PUB.Add;

1271: if l_dummy = 0 then
1272: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1273: FND_MESSAGE.SET_TOKEN('PARAMETER','P_BANK_ACCOUNT_ID');
1274: FND_MESSAGE.SET_TOKEN('VALUE',t_bank_account_id);
1275: FND_MSG_PUB.Add;
1276: x_return_status := FND_API.G_RET_STS_ERROR;
1277: RETURN;
1278: end if;
1279:

Line 1304: FND_MSG_PUB.Add;

1300: if l_dummy = 0 then
1301: FND_MESSAGE.SET_NAME('AR','AR_CUST_INVALID_PARAMETER');
1302: FND_MESSAGE.SET_TOKEN('PARAMETER','P_RECEIPT_METHOD_ID');
1303: FND_MESSAGE.SET_TOKEN('VALUE',t_receipt_method_id);
1304: FND_MSG_PUB.Add;
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: RETURN;
1307: end if;
1308:

Line 1330: FND_MSG_PUB.Add;

1326: ---Bug 3504678
1327: if nvl(l_refund_amount,0) > nvl(l_max_refund_amt,0) then
1328: --raise error X validation failed
1329: FND_MESSAGE.SET_NAME('AR','AR_RW_CCR_REFUND_AMOUNT');
1330: FND_MSG_PUB.Add;
1331: x_return_status := FND_API.G_RET_STS_ERROR ;
1332: RETURN;
1333: end if;
1334:

Line 1496: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1492: END IF;
1493: Commit;
1494: END IF;
1495:
1496: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1497: p_count => x_msg_count,
1498: p_data => x_msg_data);
1499:
1500: IF PG_DEBUG in ('Y', 'C') THEN

Line 1518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1514: ROLLBACK TO refund_prepay_PVT;
1515: x_return_status := FND_API.G_RET_STS_ERROR ;
1516:
1517: -- Display_Parameters;
1518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1519: p_count => x_msg_count,
1520: p_data => x_msg_data
1521: );
1522:

Line 1538: FND_MSG_PUB.Add;

1534: -- Display_Parameters;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data);
1542: RETURN;

Line 1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data);
1542: RETURN;
1543: ELSE

Line 1547: FND_MSG_PUB.Add;

1543: ELSE
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1546: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','REFUND_PREPAYMENT : '||SQLERRM);
1547: FND_MSG_PUB.Add;
1548: END IF;
1549:
1550: IF PG_DEBUG in ('Y', 'C') THEN
1551: arp_util.debug('Refund_Prepayment: ' || SQLCODE, G_MSG_ERROR);

Line 1557: IF FND_MSG_PUB.Check_Msg_Level THEN

1553: END IF;
1554:
1555: ROLLBACK TO refund_prepay_PVT;
1556:
1557: IF FND_MSG_PUB.Check_Msg_Level THEN
1558: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1559: l_api_name
1560: );
1561: END IF;

Line 1558: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

1554:
1555: ROLLBACK TO refund_prepay_PVT;
1556:
1557: IF FND_MSG_PUB.Check_Msg_Level THEN
1558: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1559: l_api_name
1560: );
1561: END IF;
1562:

Line 1564: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1560: );
1561: END IF;
1562:
1563: -- Display_Parameters;
1564: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data);
1567:
1568:

Line 1821: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

1817:
1818: ELSIF l_msg_count > 1 Then
1819: FOR l_count IN 1..l_msg_count LOOP
1820:
1821: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1822: IF PG_DEBUG in ('Y', 'C') THEN
1823: arp_util.debug('match_prepayment: ' || to_char(l_count)||' : '||l_msg_data);
1824: END IF;
1825: END LOOP;

Line 1922: FND_MSG_PUB.Add;

1918:
1919: /*-------Validate the p_term_id---------------*/
1920: IF p_term_id IS NULL THEN
1921: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1922: FND_MSG_PUB.Add;
1923: RAISE FND_API.G_EXC_ERROR;
1924: ELSE
1925: BEGIN
1926: SELECT 1 into l_dummy

Line 1932: FND_MSG_PUB.Add;

1928: WHERE term_id = p_term_id;
1929: EXCEPTION
1930: WHEN NO_DATA_FOUND THEN
1931: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1932: FND_MSG_PUB.Add;
1933: RAISE FND_API.G_EXC_ERROR;
1934: END;
1935: END IF;
1936:

Line 1940: FND_MSG_PUB.Add;

1936:
1937: -----Input amount should not be null or 0 -------
1938: IF ( (p_amount is null) or (p_amount <= 0) ) THEN
1939: FND_MESSAGE.SET_NAME('AR','AR_PPAY_BASE_AMOUNT_INVALID');
1940: FND_MSG_PUB.Add;
1941: RAISE FND_API.G_EXC_ERROR;
1942: END IF;
1943:
1944: -----Input currency code should not be invalid -------

Line 1947: FND_MSG_PUB.Add;

1943:
1944: -----Input currency code should not be invalid -------
1945: IF p_currency_code IS NULL THEN
1946: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1947: FND_MSG_PUB.Add;
1948: RAISE FND_API.G_EXC_ERROR;
1949: ELSE
1950: BEGIN
1951: SELECT 1 into l_dummy

Line 1957: FND_MSG_PUB.Add;

1953: WHERE currency_code = p_currency_code;
1954: EXCEPTION
1955: WHEN NO_DATA_FOUND THEN
1956: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1957: FND_MSG_PUB.Add;
1958: RAISE FND_API.G_EXC_ERROR;
1959: END;
1960: END IF;
1961:

Line 1985: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1981: WHEN fnd_api.g_exc_error THEN
1982:
1983:
1984: x_return_status := FND_API.G_RET_STS_ERROR;
1985: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1986: p_count => x_msg_count,
1987: p_data => x_msg_data);
1988:
1989:

Line 1996: FND_MSG_PUB.Add;

1992:
1993: --Bug 3107679 removed to_char call
1994: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1995: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
1996: FND_MSG_PUB.Add;
1997: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1998: p_count => x_msg_count,
1999: p_data => x_msg_data);
2000:

Line 1997: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1993: --Bug 3107679 removed to_char call
1994: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1995: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
1996: FND_MSG_PUB.Add;
1997: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1998: p_count => x_msg_count,
1999: p_data => x_msg_data);
2000:
2001: ROLLBACK to get_installment_PVT;

Line 2069: FND_MSG_PUB.ADD;

2065: l_request_id );
2066:
2067: IF l_conc_request_id = 0 THEN
2068: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
2069: FND_MSG_PUB.ADD;
2070: RAISE FND_API.G_EXC_ERROR;
2071: END IF;
2072: END IF;
2073:

Line 2083: FND_MSG_PUB.ADD;

2079: ROLLBACK TO Select_Prepay_Event;
2080:
2081: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2082: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2083: FND_MSG_PUB.ADD;
2084:
2085: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);
2086: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2087:

Line 2168: FND_MSG_PUB.initialize;

2164:
2165: BEGIN
2166:
2167: -- Initialize message stack
2168: FND_MSG_PUB.initialize;
2169: FND_FILE.put_line(fnd_file.log,'Starting Concurrent Program ''Prepayment Matching ''');
2170: FND_FILE.put_line(fnd_file.log,'Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS' ));
2171:
2172: ---get the parameter request_id

Line 2180: FND_MSG_PUB.Add;

2176: if p_batch_source <> 'All Invoices' then
2177:
2178: IF( l_request_id IS NULL OR l_request_id = 0 )THEN
2179: FND_MESSAGE.SET_NAME('AR','AR_PPAY_INVALID_REQ_ID');
2180: FND_MSG_PUB.Add;
2181: l_retcode := 10;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;
2184: end if;

Line 2266: FND_MSG_PUB.Add;

2262:
2263: EXCEPTION
2264: WHEN fnd_api.g_exc_error THEN
2265: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');
2266: FND_MSG_PUB.Add;
2267:
2268: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2269: l_msg_data :=
2270: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>

Line 2268: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

2264: WHEN fnd_api.g_exc_error THEN
2265: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');
2266: FND_MSG_PUB.Add;
2267:
2268: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2269: l_msg_data :=
2270: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2271: FND_API.G_FALSE ), 1,255);
2272: END LOOP;

Line 2270: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>

2266: FND_MSG_PUB.Add;
2267:
2268: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2269: l_msg_data :=
2270: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2271: FND_API.G_FALSE ), 1,255);
2272: END LOOP;
2273: fnd_file.put_line(fnd_file.log, l_msg_data);
2274: FND_MSG_PUB.Delete_Msg;

Line 2274: FND_MSG_PUB.Delete_Msg;

2270: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2271: FND_API.G_FALSE ), 1,255);
2272: END LOOP;
2273: fnd_file.put_line(fnd_file.log, l_msg_data);
2274: FND_MSG_PUB.Delete_Msg;
2275: retcode := l_retcode;
2276:
2277: END select_prepayments;
2278: