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.LNS_COND_ASSIGNMENT_PUB dependencies on FND_MSG_PUB

Line 154: FND_MSG_PUB.ADD;

150: WHERE cond_assignment_id = l_COND_ASSIGNMENT_id;
151:
152: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_DUPLICATE_COLUMN');
153: FND_MESSAGE.SET_TOKEN('COLUMN', 'cond_assignment_id');
154: FND_MSG_PUB.ADD;
155: RAISE FND_API.G_EXC_ERROR;
156:
157: EXCEPTION
158: WHEN NO_DATA_FOUND THEN

Line 267: FND_MSG_PUB.ADD;

263: )
264: THEN
265: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
266: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_COND_ASSIGNMENTs');
267: FND_MSG_PUB.ADD;
268: RAISE FND_API.G_EXC_ERROR;
269: END IF;
270:
271: p_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 277: FND_MSG_PUB.ADD;

273: EXCEPTION WHEN NO_DATA_FOUND THEN
274: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
275: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');
276: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_rec.cond_assignment_id), 'null'));
277: FND_MSG_PUB.ADD;
278: RAISE FND_API.G_EXC_ERROR;
279: END;
280:
281: Set_Defaults(p_COND_ASSIGNMENT_rec);

Line 384: FND_MSG_PUB.ADD;

380: WHEN NO_DATA_FOUND THEN
381: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
382: FND_MESSAGE.SET_TOKEN('RECORD', 'cond_assignment_rec');
383: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_COND_ASSIGNMENT_id), 'null'));
384: FND_MSG_PUB.ADD;
385: RAISE FND_API.G_EXC_ERROR;
386: END;
387: END IF;
388:

Line 411: FND_MSG_PUB.ADD;

407: WHEN OTHERS THEN
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
410: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
411: FND_MSG_PUB.ADD;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END;
414:
415: /*

Line 503: FND_MSG_PUB.initialize;

499: SAVEPOINT create_COND_ASSIGNMENT;
500:
501: -- initialize message list if p_init_msg_list is set to TRUE.
502: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
503: FND_MSG_PUB.initialize;
504: END IF;
505:
506: -- initialize API return status to success.
507: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 528: FND_MSG_PUB.Count_And_Get(

524: EXCEPTION
525: WHEN FND_API.G_EXC_ERROR THEN
526: ROLLBACK TO create_COND_ASSIGNMENT;
527: x_return_status := FND_API.G_RET_STS_ERROR;
528: FND_MSG_PUB.Count_And_Get(
529: p_encoded => FND_API.G_FALSE,
530: p_count => x_msg_count,
531: p_data => x_msg_data);
532:

Line 536: FND_MSG_PUB.Count_And_Get(

532:
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: ROLLBACK TO create_COND_ASSIGNMENT;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MSG_PUB.Count_And_Get(
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data);
540:

Line 546: FND_MSG_PUB.ADD;

542: ROLLBACK TO create_COND_ASSIGNMENT;
543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547: FND_MSG_PUB.Count_And_Get(
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);

Line 547: FND_MSG_PUB.Count_And_Get(

543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
544: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
545: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
546: FND_MSG_PUB.ADD;
547: FND_MSG_PUB.Count_And_Get(
548: p_encoded => FND_API.G_FALSE,
549: p_count => x_msg_count,
550: p_data => x_msg_data);
551:

Line 612: FND_MSG_PUB.initialize;

608: SAVEPOINT update_COND_ASSIGNMENT;
609:
610: -- initialize message list if p_init_msg_list is set to TRUE.
611: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
612: FND_MSG_PUB.initialize;
613: END IF;
614:
615: -- initialize API return status to success.
616: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 651: FND_MSG_PUB.Count_And_Get(

647: EXCEPTION
648: WHEN FND_API.G_EXC_ERROR THEN
649: ROLLBACK TO update_COND_ASSIGNMENT;
650: x_return_status := FND_API.G_RET_STS_ERROR;
651: FND_MSG_PUB.Count_And_Get(
652: p_encoded => FND_API.G_FALSE,
653: p_count => x_msg_count,
654: p_data => x_msg_data);
655:

Line 659: FND_MSG_PUB.Count_And_Get(

655:
656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO update_COND_ASSIGNMENT;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: FND_MSG_PUB.Count_And_Get(
660: p_encoded => FND_API.G_FALSE,
661: p_count => x_msg_count,
662: p_data => x_msg_data);
663:

Line 669: FND_MSG_PUB.ADD;

665: ROLLBACK TO update_COND_ASSIGNMENT;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
668: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
669: FND_MSG_PUB.ADD;
670: FND_MSG_PUB.Count_And_Get(
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data);

Line 670: FND_MSG_PUB.Count_And_Get(

666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
668: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
669: FND_MSG_PUB.ADD;
670: FND_MSG_PUB.Count_And_Get(
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
674:

Line 732: FND_MSG_PUB.initialize;

728: SAVEPOINT delete_COND_ASSIGNMENT;
729:
730: -- initialize message list if p_init_msg_list is set to TRUE.
731: IF FND_API.to_Boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) THEN
732: FND_MSG_PUB.initialize;
733: END IF;
734:
735: -- initialize API return status to success.
736: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 756: FND_MSG_PUB.Count_And_Get(

752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO delete_COND_ASSIGNMENT;
755: x_return_status := FND_API.G_RET_STS_ERROR;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,
759: p_data => x_msg_data);
760:

Line 764: FND_MSG_PUB.Count_And_Get(

760:
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO delete_COND_ASSIGNMENT;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MSG_PUB.Count_And_Get(
765: p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => x_msg_data);
768:

Line 774: FND_MSG_PUB.ADD;

770: ROLLBACK TO delete_COND_ASSIGNMENT;
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
774: FND_MSG_PUB.ADD;
775: FND_MSG_PUB.Count_And_Get(
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data);

Line 775: FND_MSG_PUB.Count_And_Get(

771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
773: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
774: FND_MSG_PUB.ADD;
775: FND_MSG_PUB.Count_And_Get(
776: p_encoded => FND_API.G_FALSE,
777: p_count => x_msg_count,
778: p_data => x_msg_data);
779:

Line 1226: FND_MSG_PUB.initialize;

1222: END IF;
1223:
1224: -- Initialize message list if p_init_msg_list is set to TRUE
1225: IF FND_API.To_Boolean(p_init_msg_list) THEN
1226: FND_MSG_PUB.initialize;
1227: END IF;
1228:
1229: -- Initialize API return status to success
1230: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1340: FND_MSG_PUB.Count_And_Get(

1336: -- END OF BODY OF API
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;
1338:
1339: -- Standard call to get message count and if count is 1, get message info
1340: FND_MSG_PUB.Count_And_Get(
1341: p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data);
1344:

Line 1351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1347: EXCEPTION
1348: WHEN FND_API.G_EXC_ERROR THEN
1349: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1350: x_return_status := FND_API.G_RET_STS_ERROR;
1351: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1354: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1352: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1354: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1357: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1358: WHEN OTHERS THEN
1359: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1357: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1358: WHEN OTHERS THEN
1359: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1363: END IF;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1365: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1358: WHEN OTHERS THEN
1359: ROLLBACK TO VALIDATE_CUSTOM_CONDITIONS;
1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1363: END IF;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1365: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1366: END;

Line 1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1361: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1362: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1363: END IF;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1365: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1366: END;
1367:
1368:

Line 1431: FND_MSG_PUB.initialize;

1427: END IF;
1428:
1429: -- Initialize message list if p_init_msg_list is set to TRUE
1430: IF FND_API.To_Boolean(p_init_msg_list) THEN
1431: FND_MSG_PUB.initialize;
1432: END IF;
1433:
1434: -- Initialize API return status to success
1435: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1484: FND_MSG_PUB.ADD;

1480: WHEN OTHERS THEN
1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1482: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);
1483: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,SQLERRM);
1484: FND_MSG_PUB.ADD;
1485: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1486: RAISE FND_API.G_EXC_ERROR;
1487: END;
1488:

Line 1485: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1481: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1482: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);
1483: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,SQLERRM);
1484: FND_MSG_PUB.ADD;
1485: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1486: RAISE FND_API.G_EXC_ERROR;
1487: END;
1488:
1489: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_result = ' || l_result);

Line 1496: FND_MSG_PUB.ADD;

1492: if l_result = 'N' then
1493: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1494: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);
1495: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,l_error);
1496: FND_MSG_PUB.ADD;
1497: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1498: RAISE FND_API.G_EXC_ERROR;
1499: end if;
1500:

Line 1497: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1493: FND_MESSAGE.SET_NAME('LNS', 'LNS_CUSTOM_COND_FAILED');
1494: FND_MESSAGE.SET_TOKEN('COND_NAME' ,l_CONDITION_NAME);
1495: FND_MESSAGE.SET_TOKEN('ERROR_MESG' ,l_error);
1496: FND_MSG_PUB.ADD;
1497: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1498: RAISE FND_API.G_EXC_ERROR;
1499: end if;
1500:
1501: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated custom condition ' || l_CONDITION_NAME);

Line 1507: FND_MSG_PUB.Count_And_Get(

1503: -- END OF BODY OF API
1504: x_return_status := FND_API.G_RET_STS_SUCCESS;
1505:
1506: -- Standard call to get message count and if count is 1, get message info
1507: FND_MSG_PUB.Count_And_Get(
1508: p_encoded => FND_API.G_FALSE,
1509: p_count => x_msg_count,
1510: p_data => x_msg_data);
1511:

Line 1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1513:
1514: EXCEPTION
1515: WHEN FND_API.G_EXC_ERROR THEN
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521: WHEN OTHERS THEN

Line 1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521: WHEN OTHERS THEN
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1524: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521: WHEN OTHERS THEN
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1524: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1525: END IF;
1526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1527: END;

Line 1524: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1521: WHEN OTHERS THEN
1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1524: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1525: END IF;
1526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1527: END;
1528:

Line 1526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1523: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1524: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1525: END IF;
1526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1527: END;
1528:
1529:
1530:

Line 1593: FND_MSG_PUB.initialize;

1589: END IF;
1590:
1591: -- Initialize message list if p_init_msg_list is set to TRUE
1592: IF FND_API.To_Boolean(p_init_msg_list) THEN
1593: FND_MSG_PUB.initialize;
1594: END IF;
1595:
1596: -- Initialize API return status to success
1597: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1607: FND_MSG_PUB.ADD;

1603:
1604: if P_LOAN_ID is null then
1605: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1606: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
1607: FND_MSG_PUB.ADD;
1608: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1609: RAISE FND_API.G_EXC_ERROR;
1610: end if;
1611:

Line 1608: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1604: if P_LOAN_ID is null then
1605: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1606: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_LOAN_ID' );
1607: FND_MSG_PUB.ADD;
1608: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1609: RAISE FND_API.G_EXC_ERROR;
1610: end if;
1611:
1612: if P_OWNER_OBJECT_ID is null then

Line 1615: FND_MSG_PUB.ADD;

1611:
1612: if P_OWNER_OBJECT_ID is null then
1613: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1614: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_OWNER_OBJECT_ID' );
1615: FND_MSG_PUB.ADD;
1616: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1617: RAISE FND_API.G_EXC_ERROR;
1618: end if;
1619:

Line 1616: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1612: if P_OWNER_OBJECT_ID is null then
1613: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1614: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_OWNER_OBJECT_ID' );
1615: FND_MSG_PUB.ADD;
1616: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1617: RAISE FND_API.G_EXC_ERROR;
1618: end if;
1619:
1620: if P_CONDITION_TYPE is null then

Line 1623: FND_MSG_PUB.ADD;

1619:
1620: if P_CONDITION_TYPE is null then
1621: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1622: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_CONDITION_TYPE' );
1623: FND_MSG_PUB.ADD;
1624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1625: RAISE FND_API.G_EXC_ERROR;
1626: end if;
1627:

Line 1624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1620: if P_CONDITION_TYPE is null then
1621: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_API_MISSING_COLUMN' );
1622: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'P_CONDITION_TYPE' );
1623: FND_MSG_PUB.ADD;
1624: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1625: RAISE FND_API.G_EXC_ERROR;
1626: end if;
1627:
1628: if P_CONDITION_TYPE <> 'LOAN_AMOUNT_ADJUSTMENT' and

Line 1635: FND_MSG_PUB.ADD;

1631: then
1632: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_INVALID_VALUE' );
1633: FND_MESSAGE.SET_TOKEN( 'PARAMETER', 'P_CONDITION_TYPE' );
1634: FND_MESSAGE.SET_TOKEN( 'VALUE', P_CONDITION_TYPE );
1635: FND_MSG_PUB.ADD;
1636: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1637: RAISE FND_API.G_EXC_ERROR;
1638: end if;
1639:

Line 1636: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

1632: FND_MESSAGE.SET_NAME( 'LNS', 'LNS_INVALID_VALUE' );
1633: FND_MESSAGE.SET_TOKEN( 'PARAMETER', 'P_CONDITION_TYPE' );
1634: FND_MESSAGE.SET_TOKEN( 'VALUE', P_CONDITION_TYPE );
1635: FND_MSG_PUB.ADD;
1636: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1637: RAISE FND_API.G_EXC_ERROR;
1638: end if;
1639:
1640: i := 0;

Line 1709: FND_MSG_PUB.Count_And_Get(

1705: -- END OF BODY OF API
1706: x_return_status := FND_API.G_RET_STS_SUCCESS;
1707:
1708: -- Standard call to get message count and if count is 1, get message info
1709: FND_MSG_PUB.Count_And_Get(
1710: p_encoded => FND_API.G_FALSE,
1711: p_count => x_msg_count,
1712: p_data => x_msg_data);
1713:

Line 1720: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1716: EXCEPTION
1717: WHEN FND_API.G_EXC_ERROR THEN
1718: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;
1719: x_return_status := FND_API.G_RET_STS_ERROR;
1720: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1722: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1720: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1722: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;
1723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1725: WHEN OTHERS THEN
1726: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

Line 1728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1724: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1725: WHEN OTHERS THEN
1726: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1730: END IF;
1731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1732: END;

Line 1729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1725: WHEN OTHERS THEN
1726: ROLLBACK TO DEFAULT_COND_ASSIGNMENTS;
1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1730: END IF;
1731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1732: END;
1733:

Line 1731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1728: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1729: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1730: END IF;
1731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1732: END;
1733:
1734:
1735:

Line 1791: FND_MSG_PUB.initialize;

1787: END IF;
1788:
1789: -- Initialize message list if p_init_msg_list is set to TRUE
1790: IF FND_API.To_Boolean(p_init_msg_list) THEN
1791: FND_MSG_PUB.initialize;
1792: END IF;
1793:
1794: -- Initialize API return status to success
1795: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1809: FND_MSG_PUB.Add;

1805: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_cond_count = ' || l_cond_count);
1806:
1807: if l_cond_count > 0 then
1808: FND_MESSAGE.SET_NAME('LNS', 'LNS_NOT_ALL_COND_MET');
1809: FND_MSG_PUB.Add;
1810: RAISE FND_API.G_EXC_ERROR;
1811: end if;
1812:
1813: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Successfully validated all non-custom conditions for object ' || P_OWNER_OBJECT_ID || '; type ' || P_CONDITION_TYPE);

Line 1819: FND_MSG_PUB.Count_And_Get(

1815: -- END OF BODY OF API
1816: x_return_status := FND_API.G_RET_STS_SUCCESS;
1817:
1818: -- Standard call to get message count and if count is 1, get message info
1819: FND_MSG_PUB.Count_And_Get(
1820: p_encoded => FND_API.G_FALSE,
1821: p_count => x_msg_count,
1822: p_data => x_msg_data);
1823:

Line 1829: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN

Line 1832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1828: x_return_status := FND_API.G_RET_STS_ERROR;
1829: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1836: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN

1831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1836: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1837: END IF;
1838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1839: END;

Line 1836: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1832: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1833: WHEN OTHERS THEN
1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1836: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1837: END IF;
1838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1839: END;
1840:

Line 1838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

1834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1836: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1837: END IF;
1838: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1839: END;
1840:
1841:
1842: