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

Line 47: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

43: G_REPEAT_ASAP CONSTANT VARCHAR2(30) := 'ASAP';
44: G_REPEAT_ONCE CONSTANT VARCHAR2(30) := 'ONCE';
45: G_REPEAT_PERIODICALLY CONSTANT VARCHAR2(30) := 'PERIODICALLY';
46: G_MSG_COUNT NUMBER := 10000;
47: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
48: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
49: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
50:
51: PROCEDURE write_msg(p_message IN VARCHAR2)

Line 48: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

44: G_REPEAT_ONCE CONSTANT VARCHAR2(30) := 'ONCE';
45: G_REPEAT_PERIODICALLY CONSTANT VARCHAR2(30) := 'PERIODICALLY';
46: G_MSG_COUNT NUMBER := 10000;
47: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
48: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
49: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
50:
51: PROCEDURE write_msg(p_message IN VARCHAR2)
52: IS

Line 49: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

45: G_REPEAT_PERIODICALLY CONSTANT VARCHAR2(30) := 'PERIODICALLY';
46: G_MSG_COUNT NUMBER := 10000;
47: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
48: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
49: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
50:
51: PROCEDURE write_msg(p_message IN VARCHAR2)
52: IS
53:

Line 419: FND_MSG_PUB.initialize;

415: p_msg_type => 'DEBUG'
416: );
417: -- Initialize message list if p_init_msg_list is set to TRUE.
418: IF FND_API.to_Boolean( p_init_msg_list ) THEN
419: FND_MSG_PUB.initialize;
420: END IF;
421: AMS_UTILITY_PVT.debug_message('AMS_IMP_REC_SCH_ERROR');
422: RAISE FND_API.g_exc_unexpected_error;
423: END IF;

Line 463: FND_MSG_PUB.Count_And_Get (

459: EXCEPTION
460:
461: WHEN FND_API.G_EXC_ERROR THEN
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data
467: );

Line 473: FND_MSG_PUB.Count_And_Get (

469: WHEN FND_API.g_exc_unexpected_error THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471:
472: -- Standard call to get message count and if count=1, get the message
473: FND_MSG_PUB.Count_And_Get (
474: p_encoded => FND_API.G_FALSE,
475: p_count => x_msg_count,
476: p_data => x_msg_data
477: );

Line 486: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

482:
483: AMS_UTILITY_PVT.debug_message('Do_Recurring::The error is:: ' || l_error);
484: END IF;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message

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

484: END IF;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,

Line 491: FND_MSG_PUB.Count_And_Get (

487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );

Line 706: FND_MSG_PUB.Count_And_Get

702: COMMIT WORK;
703: END IF;
704:
705: -- Standard call to get message count and if count is 1, get message info.
706: FND_MSG_PUB.Count_And_Get
707: (p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: EXCEPTION

Line 718: FND_MSG_PUB.Count_And_Get (

714: WHEN FND_API.G_EXC_ERROR THEN
715: ROLLBACK TO Duplicate_Import_List;
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: -- Standard call to get message count and if count=1, get the message
718: FND_MSG_PUB.Count_And_Get (
719: p_encoded => FND_API.G_FALSE,
720: p_count => x_msg_count,
721: p_data => x_msg_data
722: );

Line 728: FND_MSG_PUB.Count_And_Get (

724: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
725: ROLLBACK TO Duplicate_Import_List;
726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
727: -- Standard call to get message count and if count=1, get the message
728: FND_MSG_PUB.Count_And_Get (
729: p_encoded => FND_API.G_FALSE,
730: p_count => x_msg_count,
731: p_data => x_msg_data
732: );

Line 737: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

733:
734: WHEN OTHERS THEN
735: ROLLBACK TO Duplicate_Import_List;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
738: THEN
739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
740: END IF;
741: -- Standard call to get message count and if count=1, get the message

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

735: ROLLBACK TO Duplicate_Import_List;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
738: THEN
739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
740: END IF;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => FND_API.G_FALSE,

Line 742: FND_MSG_PUB.Count_And_Get (

738: THEN
739: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
740: END IF;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_msg_count,
745: p_data => x_msg_data
746: );

Line 829: FND_MSG_PUB.initialize;

825:
826: -- Initialize message list if p_init_msg_list is set to TRUE.
827: IF FND_API.to_Boolean( p_init_msg_list )
828: THEN
829: FND_MSG_PUB.initialize;
830: END IF;
831:
832: -- Debug Message
833: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1145: FND_MSG_PUB.Count_And_Get

1141: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1142: END IF;
1143:
1144: -- Standard call to get message count and if count is 1, get message info.
1145: FND_MSG_PUB.Count_And_Get
1146: (p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149: EXCEPTION

Line 1159: FND_MSG_PUB.Count_And_Get (

1155: WHEN FND_API.G_EXC_ERROR THEN
1156: ROLLBACK TO CREATE_Import_List_PVT;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: -- Standard call to get message count and if count=1, get the message
1159: FND_MSG_PUB.Count_And_Get (
1160: p_encoded => FND_API.G_FALSE,
1161: p_count => x_msg_count,
1162: p_data => x_msg_data
1163: );

Line 1169: FND_MSG_PUB.Count_And_Get (

1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: ROLLBACK TO CREATE_Import_List_PVT;
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1168: -- Standard call to get message count and if count=1, get the message
1169: FND_MSG_PUB.Count_And_Get (
1170: p_encoded => FND_API.G_FALSE,
1171: p_count => x_msg_count,
1172: p_data => x_msg_data
1173: );

Line 1178: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1174:
1175: WHEN OTHERS THEN
1176: ROLLBACK TO CREATE_Import_List_PVT;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1179: THEN
1180: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1181: END IF;
1182: -- Standard call to get message count and if count=1, get the message

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

1176: ROLLBACK TO CREATE_Import_List_PVT;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1179: THEN
1180: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1181: END IF;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,

Line 1183: FND_MSG_PUB.Count_And_Get (

1179: THEN
1180: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1181: END IF;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );

Line 1238: FND_MSG_PUB.initialize;

1234:
1235: -- Initialize message list if p_init_msg_list is set to TRUE.
1236: IF FND_API.to_Boolean( p_init_msg_list )
1237: THEN
1238: FND_MSG_PUB.initialize;
1239: END IF;
1240:
1241: -- Debug Message
1242: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1408: FND_MSG_PUB.Count_And_Get

1404: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1405: END IF;
1406:
1407: -- Standard call to get message count and if count is 1, get message info.
1408: FND_MSG_PUB.Count_And_Get
1409: (p_count => x_msg_count,
1410: p_data => x_msg_data
1411: );
1412: EXCEPTION

Line 1422: FND_MSG_PUB.Count_And_Get (

1418: WHEN FND_API.G_EXC_ERROR THEN
1419: ROLLBACK TO UPDATE_Import_List_PVT;
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: -- Standard call to get message count and if count=1, get the message
1422: FND_MSG_PUB.Count_And_Get (
1423: p_encoded => FND_API.G_FALSE,
1424: p_count => x_msg_count,
1425: p_data => x_msg_data
1426: );

Line 1432: FND_MSG_PUB.Count_And_Get (

1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: ROLLBACK TO UPDATE_Import_List_PVT;
1430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1431: -- Standard call to get message count and if count=1, get the message
1432: FND_MSG_PUB.Count_And_Get (
1433: p_encoded => FND_API.G_FALSE,
1434: p_count => x_msg_count,
1435: p_data => x_msg_data
1436: );

Line 1441: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1437:
1438: WHEN OTHERS THEN
1439: ROLLBACK TO UPDATE_Import_List_PVT;
1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1444: END IF;
1445: -- Standard call to get message count and if count=1, get the message

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

1439: ROLLBACK TO UPDATE_Import_List_PVT;
1440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1441: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1442: THEN
1443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1444: END IF;
1445: -- Standard call to get message count and if count=1, get the message
1446: FND_MSG_PUB.Count_And_Get (
1447: p_encoded => FND_API.G_FALSE,

Line 1446: FND_MSG_PUB.Count_And_Get (

1442: THEN
1443: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1444: END IF;
1445: -- Standard call to get message count and if count=1, get the message
1446: FND_MSG_PUB.Count_And_Get (
1447: p_encoded => FND_API.G_FALSE,
1448: p_count => x_msg_count,
1449: p_data => x_msg_data
1450: );

Line 1487: FND_MSG_PUB.initialize;

1483:
1484: -- Initialize message list if p_init_msg_list is set to TRUE.
1485: IF FND_API.to_Boolean( p_init_msg_list )
1486: THEN
1487: FND_MSG_PUB.initialize;
1488: END IF;
1489:
1490: -- Debug Message
1491: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1530: FND_MSG_PUB.Count_And_Get

1526: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1527: END IF;
1528:
1529: -- Standard call to get message count and if count is 1, get message info.
1530: FND_MSG_PUB.Count_And_Get
1531: (p_count => x_msg_count,
1532: p_data => x_msg_data
1533: );
1534: EXCEPTION

Line 1544: FND_MSG_PUB.Count_And_Get (

1540: WHEN FND_API.G_EXC_ERROR THEN
1541: ROLLBACK TO DELETE_Import_List_PVT;
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: -- Standard call to get message count and if count=1, get the message
1544: FND_MSG_PUB.Count_And_Get (
1545: p_encoded => FND_API.G_FALSE,
1546: p_count => x_msg_count,
1547: p_data => x_msg_data
1548: );

Line 1554: FND_MSG_PUB.Count_And_Get (

1550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1551: ROLLBACK TO DELETE_Import_List_PVT;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: -- Standard call to get message count and if count=1, get the message
1554: FND_MSG_PUB.Count_And_Get (
1555: p_encoded => FND_API.G_FALSE,
1556: p_count => x_msg_count,
1557: p_data => x_msg_data
1558: );

Line 1563: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1559:
1560: WHEN OTHERS THEN
1561: ROLLBACK TO DELETE_Import_List_PVT;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1564: THEN
1565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1566: END IF;
1567: -- Standard call to get message count and if count=1, get the message

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

1561: ROLLBACK TO DELETE_Import_List_PVT;
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1564: THEN
1565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1566: END IF;
1567: -- Standard call to get message count and if count=1, get the message
1568: FND_MSG_PUB.Count_And_Get (
1569: p_encoded => FND_API.G_FALSE,

Line 1568: FND_MSG_PUB.Count_And_Get (

1564: THEN
1565: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1566: END IF;
1567: -- Standard call to get message count and if count=1, get the message
1568: FND_MSG_PUB.Count_And_Get (
1569: p_encoded => FND_API.G_FALSE,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data
1572: );

Line 1614: FND_MSG_PUB.initialize;

1610:
1611: -- Initialize message list if p_init_msg_list is set to TRUE.
1612: IF FND_API.to_Boolean( p_init_msg_list )
1613: THEN
1614: FND_MSG_PUB.initialize;
1615: END IF;
1616:
1617: -- Standard call to check for call compatibility.
1618: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1642: FETCH c_Import_List INTO l_IMPORT_LIST_HEADER_ID;
1643:
1644: IF (c_Import_List%NOTFOUND) THEN
1645: CLOSE c_Import_List;
1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1647: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1648: FND_MSG_PUB.add;
1649: END IF;
1650: RAISE FND_API.g_exc_error;

Line 1648: FND_MSG_PUB.add;

1644: IF (c_Import_List%NOTFOUND) THEN
1645: CLOSE c_Import_List;
1646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1647: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1648: FND_MSG_PUB.add;
1649: END IF;
1650: RAISE FND_API.g_exc_error;
1651: END IF;
1652:

Line 1656: FND_MSG_PUB.count_and_get(

1652:
1653: CLOSE c_Import_List;
1654:
1655: -------------------- finish --------------------------
1656: FND_MSG_PUB.count_and_get(
1657: p_encoded => FND_API.g_false,
1658: p_count => x_msg_count,
1659: p_data => x_msg_data);
1660: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1674: FND_MSG_PUB.Count_And_Get (

1670: WHEN FND_API.G_EXC_ERROR THEN
1671: ROLLBACK TO LOCK_Import_List_PVT;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: -- Standard call to get message count and if count=1, get the message
1674: FND_MSG_PUB.Count_And_Get (
1675: p_encoded => FND_API.G_FALSE,
1676: p_count => x_msg_count,
1677: p_data => x_msg_data
1678: );

Line 1684: FND_MSG_PUB.Count_And_Get (

1680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1681: ROLLBACK TO LOCK_Import_List_PVT;
1682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683: -- Standard call to get message count and if count=1, get the message
1684: FND_MSG_PUB.Count_And_Get (
1685: p_encoded => FND_API.G_FALSE,
1686: p_count => x_msg_count,
1687: p_data => x_msg_data
1688: );

Line 1693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1689:
1690: WHEN OTHERS THEN
1691: ROLLBACK TO LOCK_Import_List_PVT;
1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1694: THEN
1695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1696: END IF;
1697: -- Standard call to get message count and if count=1, get the message

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

1691: ROLLBACK TO LOCK_Import_List_PVT;
1692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1693: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1694: THEN
1695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1696: END IF;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (
1699: p_encoded => FND_API.G_FALSE,

Line 1698: FND_MSG_PUB.Count_And_Get (

1694: THEN
1695: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1696: END IF;
1697: -- Standard call to get message count and if count=1, get the message
1698: FND_MSG_PUB.Count_And_Get (
1699: p_encoded => FND_API.G_FALSE,
1700: p_count => x_msg_count,
1701: p_data => x_msg_data
1702: );

Line 1985: FND_MSG_PUB.Add;

1981: IF p_ams_import_rec.server_flag = 'Y'
1982: THEN
1983: if fnd_profile.value('AMS_IMP_CTL_PATH') is NULL then
1984: FND_MESSAGE.set_name('AMS', 'AMS_IMP_CTL_PATH');
1985: FND_MSG_PUB.Add;
1986: x_return_status := FND_API.g_ret_sts_error;
1987: RETURN;
1988: end if;
1989:

Line 1992: FND_MSG_PUB.Add;

1988: end if;
1989:
1990: if fnd_profile.value('AMS_IMP_DATA_PATH') is NULL then
1991: FND_MESSAGE.set_name('AMS', 'AMS_IMP_DATA_PATH');
1992: FND_MSG_PUB.Add;
1993: x_return_status := FND_API.g_ret_sts_error;
1994: RETURN;
1995: end if;
1996: END IF;

Line 2007: FND_MSG_PUB.Add;

2003: (p_ams_import_rec.expiry_date < SYSDATE)
2004: THEN
2005: --AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ams_import_NO_name');
2006: FND_MESSAGE.set_name('AMS', 'AMS_IMP_EXP_DATE');
2007: FND_MSG_PUB.Add;
2008: x_return_status := FND_API.g_ret_sts_error;
2009: RETURN;
2010: END IF;
2011:

Line 2018: FND_MSG_PUB.Add;

2014: ((p_ams_import_rec.usage is NULL AND p_ams_import_rec.expiry_date is NULL) OR
2015: (p_ams_import_rec.usage = FND_API.g_miss_num AND p_ams_import_rec.expiry_date = FND_API.g_miss_date))
2016: THEN
2017: FND_MESSAGE.set_name('AMS', 'AMS_IMP_RENTED_LIST');
2018: FND_MSG_PUB.Add;
2019: x_return_status := FND_API.g_ret_sts_error;
2020: RETURN;
2021: END IF;
2022: END IF;

Line 2034: FND_MSG_PUB.Add;

2030: IF (p_ams_import_rec.data_filename = FND_API.g_miss_char) OR
2031: (p_ams_import_rec.data_filename is NULL)
2032: THEN
2033: FND_MESSAGE.set_name('AMS', 'API_MISS_DATA_FILENAME');
2034: FND_MSG_PUB.Add;
2035: x_return_status := FND_API.g_ret_sts_error;
2036: close c_get_Import_list;
2037: RETURN;
2038: END IF;

Line 2043: FND_MSG_PUB.Add;

2039:
2040: IF (p_ams_import_rec.terminated_by = p_ams_import_rec.enclosed_by)
2041: THEN
2042: FND_MESSAGE.set_name('AMS', 'API_SAME_TERMIN_ENCLOSED');
2043: FND_MSG_PUB.Add;
2044: x_return_status := FND_API.g_ret_sts_error;
2045: close c_get_Import_list;
2046: RETURN;
2047: END IF;

Line 2056: FND_MSG_PUB.Add;

2052: IF (c_get_Import_List_name%FOUND)
2053: THEN
2054: --AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_IMPORT_NAME_DUPLICATE');
2055: FND_MESSAGE.set_name('AMS', 'AMS_IMPORT_NAME_DUPLICATE');
2056: FND_MSG_PUB.Add;
2057: x_return_status := FND_API.g_ret_sts_error;
2058: close c_get_Import_list_name;
2059: RETURN;
2060: END IF;

Line 2560: FND_MSG_PUB.initialize;

2556:
2557: -- Initialize message list if p_init_msg_list is set to TRUE.
2558: IF FND_API.to_Boolean( p_init_msg_list )
2559: THEN
2560: FND_MSG_PUB.initialize;
2561: END IF;
2562: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2563: Check_ams_import_Items(
2564: p_ams_import_rec => p_ams_import_rec,

Line 2617: FND_MSG_PUB.Count_And_Get

2613: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2614: END IF;
2615:
2616: -- Standard call to get message count and if count is 1, get message info.
2617: FND_MSG_PUB.Count_And_Get
2618: (p_count => x_msg_count,
2619: p_data => x_msg_data
2620: );
2621: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2636: FND_MSG_PUB.Count_And_Get (

2632: WHEN FND_API.G_EXC_ERROR THEN
2633: ROLLBACK TO VALIDATE_Import_List_;
2634: x_return_status := FND_API.G_RET_STS_ERROR;
2635: -- Standard call to get message count and if count=1, get the message
2636: FND_MSG_PUB.Count_And_Get (
2637: p_encoded => FND_API.G_FALSE,
2638: p_count => x_msg_count,
2639: p_data => x_msg_data
2640: );

Line 2646: FND_MSG_PUB.Count_And_Get (

2642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2643: ROLLBACK TO VALIDATE_Import_List_;
2644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2645: -- Standard call to get message count and if count=1, get the message
2646: FND_MSG_PUB.Count_And_Get (
2647: p_encoded => FND_API.G_FALSE,
2648: p_count => x_msg_count,
2649: p_data => x_msg_data
2650: );

Line 2655: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2651:
2652: WHEN OTHERS THEN
2653: ROLLBACK TO VALIDATE_Import_List_;
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2656: THEN
2657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2658: END IF;
2659: -- Standard call to get message count and if count=1, get the message

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

2653: ROLLBACK TO VALIDATE_Import_List_;
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2656: THEN
2657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2658: END IF;
2659: -- Standard call to get message count and if count=1, get the message
2660: FND_MSG_PUB.Count_And_Get (
2661: p_encoded => FND_API.G_FALSE,

Line 2660: FND_MSG_PUB.Count_And_Get (

2656: THEN
2657: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2658: END IF;
2659: -- Standard call to get message count and if count=1, get the message
2660: FND_MSG_PUB.Count_And_Get (
2661: p_encoded => FND_API.G_FALSE,
2662: p_count => x_msg_count,
2663: p_data => x_msg_data
2664: );

Line 2681: FND_MSG_PUB.initialize;

2677: BEGIN
2678: -- Initialize message list if p_init_msg_list is set to TRUE.
2679: IF FND_API.to_Boolean( p_init_msg_list )
2680: THEN
2681: FND_MSG_PUB.initialize;
2682: END IF;
2683:
2684: -- Initialize API return status to SUCCESS
2685: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2698: FND_MSG_PUB.Count_And_Get

2694:
2695: AMS_UTILITY_PVT.debug_message('Private API: Validate_ams_import_rec');
2696: END IF;
2697: -- Standard call to get message count and if count is 1, get message info.
2698: FND_MSG_PUB.Count_And_Get
2699: (p_count => x_msg_count,
2700: p_data => x_msg_data
2701: );
2702: END Validate_ams_import_Rec;