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 1844: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);

1840:
1841: ELSIF l_msg_count > 1 Then
1842: FOR l_count IN 1..l_msg_count LOOP
1843:
1844: l_msg_data := FND_MSG_PUB.Get(FND_MSG_PUB.G_NEXT,FND_API.G_FALSE);
1845: IF PG_DEBUG in ('Y', 'C') THEN
1846: arp_util.debug('match_prepayment: ' || to_char(l_count)||' : '||l_msg_data);
1847: END IF;
1848: END LOOP;

Line 1945: FND_MSG_PUB.Add;

1941:
1942: /*-------Validate the p_term_id---------------*/
1943: IF p_term_id IS NULL THEN
1944: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1945: FND_MSG_PUB.Add;
1946: RAISE FND_API.G_EXC_ERROR;
1947: ELSE
1948: BEGIN
1949: SELECT 1 into l_dummy

Line 1955: FND_MSG_PUB.Add;

1951: WHERE term_id = p_term_id;
1952: EXCEPTION
1953: WHEN NO_DATA_FOUND THEN
1954: FND_MESSAGE.SET_NAME('AR','AR_PPAY_PAY_TERM_INVALID');
1955: FND_MSG_PUB.Add;
1956: RAISE FND_API.G_EXC_ERROR;
1957: END;
1958: END IF;
1959:

Line 1963: FND_MSG_PUB.Add;

1959:
1960: -----Input amount should not be null or 0 -------
1961: IF ( (p_amount is null) or (p_amount <= 0) ) THEN
1962: FND_MESSAGE.SET_NAME('AR','AR_PPAY_BASE_AMOUNT_INVALID');
1963: FND_MSG_PUB.Add;
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966:
1967: -----Input currency code should not be invalid -------

Line 1970: FND_MSG_PUB.Add;

1966:
1967: -----Input currency code should not be invalid -------
1968: IF p_currency_code IS NULL THEN
1969: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1970: FND_MSG_PUB.Add;
1971: RAISE FND_API.G_EXC_ERROR;
1972: ELSE
1973: BEGIN
1974: SELECT 1 into l_dummy

Line 1980: FND_MSG_PUB.Add;

1976: WHERE currency_code = p_currency_code;
1977: EXCEPTION
1978: WHEN NO_DATA_FOUND THEN
1979: FND_MESSAGE.SET_NAME('AR','AR_RAPI_CURR_CODE_INVALID');
1980: FND_MSG_PUB.Add;
1981: RAISE FND_API.G_EXC_ERROR;
1982: END;
1983: END IF;
1984:

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

2004: WHEN fnd_api.g_exc_error THEN
2005:
2006:
2007: x_return_status := FND_API.G_RET_STS_ERROR;
2008: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2009: p_count => x_msg_count,
2010: p_data => x_msg_data);
2011:
2012:

Line 2019: FND_MSG_PUB.Add;

2015:
2016: --Bug 3107679 removed to_char call
2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
2019: FND_MSG_PUB.Add;
2020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2021: p_count => x_msg_count,
2022: p_data => x_msg_data);
2023:

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

2016: --Bug 3107679 removed to_char call
2017: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
2018: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','GET_INSTALLMENT : '||SQLERRM);
2019: FND_MSG_PUB.Add;
2020: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
2021: p_count => x_msg_count,
2022: p_data => x_msg_data);
2023:
2024: ROLLBACK to get_installment_PVT;

Line 2092: FND_MSG_PUB.ADD;

2088: ROLLBACK TO Select_Prepay_Event;
2089:
2090: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2091: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2092: FND_MSG_PUB.ADD;
2093:
2094: RETURN 'ERROR';
2095: END;
2096:

Line 2121: FND_MSG_PUB.ADD;

2117: l_request_id );
2118:
2119: IF l_conc_request_id = 0 THEN
2120: FND_MESSAGE.SET_NAME('AR', 'AR_CUST_CONC_ERROR');
2121: FND_MSG_PUB.ADD;
2122: RAISE FND_API.G_EXC_ERROR;
2123: END IF;
2124: END IF;
2125:

Line 2135: FND_MSG_PUB.ADD;

2131: ROLLBACK TO Select_Prepay_Event;
2132:
2133: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2134: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2135: FND_MSG_PUB.ADD;
2136:
2137: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);
2138: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2139:

Line 2225: FND_MSG_PUB.initialize;

2221: */
2222: BEGIN
2223:
2224: -- Initialize message stack
2225: FND_MSG_PUB.initialize;
2226: FND_FILE.put_line(fnd_file.log,'Starting Concurrent Program ''Prepayment Matching ''');
2227: FND_FILE.put_line(fnd_file.log,'Start Time ' || TO_CHAR(SYSDATE, 'MM-DD-YY HH24:MI:SS' ));
2228:
2229: ---get the parameter request_id

Line 2237: FND_MSG_PUB.Add;

2233: if p_batch_source <> 'All Invoices' then
2234:
2235: IF( l_request_id IS NULL OR l_request_id = 0 )THEN
2236: FND_MESSAGE.SET_NAME('AR','AR_PPAY_INVALID_REQ_ID');
2237: FND_MSG_PUB.Add;
2238: l_retcode := 10;
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;
2241: end if;

Line 2364: FND_MSG_PUB.Add;

2360:
2361: EXCEPTION
2362: WHEN fnd_api.g_exc_error THEN
2363: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');
2364: FND_MSG_PUB.Add;
2365:
2366: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2367: l_msg_data :=
2368: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>

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

2362: WHEN fnd_api.g_exc_error THEN
2363: FND_MESSAGE.SET_NAME ('AR','AR_PREPAY_ERROR');
2364: FND_MSG_PUB.Add;
2365:
2366: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2367: l_msg_data :=
2368: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2369: FND_API.G_FALSE ), 1,255);
2370: END LOOP;

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

2364: FND_MSG_PUB.Add;
2365:
2366: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
2367: l_msg_data :=
2368: substr(l_msg_data || ' ' || FND_MSG_PUB.Get(p_encoded =>
2369: FND_API.G_FALSE ), 1,255);
2370: END LOOP;
2371:
2372: fnd_file.put_line(fnd_file.log, l_msg_data);

Line 2373: FND_MSG_PUB.Delete_Msg;

2369: FND_API.G_FALSE ), 1,255);
2370: END LOOP;
2371:
2372: fnd_file.put_line(fnd_file.log, l_msg_data);
2373: FND_MSG_PUB.Delete_Msg;
2374: retcode := l_retcode;
2375:
2376: END select_prepayments;
2377: