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 412: FND_MSG_PUB.initialize;

408: p_msg_type => 'DEBUG'
409: );
410: -- Initialize message list if p_init_msg_list is set to TRUE.
411: IF FND_API.to_Boolean( p_init_msg_list ) THEN
412: FND_MSG_PUB.initialize;
413: END IF;
414: AMS_UTILITY_PVT.debug_message('AMS_IMP_REC_SCH_ERROR');
415: RAISE FND_API.g_exc_unexpected_error;
416: END IF;

Line 456: FND_MSG_PUB.Count_And_Get (

452: EXCEPTION
453:
454: WHEN FND_API.G_EXC_ERROR THEN
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.Count_And_Get (
457: p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data
460: );

Line 466: FND_MSG_PUB.Count_And_Get (

462: WHEN FND_API.g_exc_unexpected_error THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464:
465: -- Standard call to get message count and if count=1, get the message
466: FND_MSG_PUB.Count_And_Get (
467: p_encoded => FND_API.G_FALSE,
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );

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

475:
476: AMS_UTILITY_PVT.debug_message('Do_Recurring::The error is:: ' || l_error);
477: END IF;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message

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

477: END IF;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,

Line 484: FND_MSG_PUB.Count_And_Get (

480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );

Line 699: FND_MSG_PUB.Count_And_Get

695: COMMIT WORK;
696: END IF;
697:
698: -- Standard call to get message count and if count is 1, get message info.
699: FND_MSG_PUB.Count_And_Get
700: (p_count => x_msg_count,
701: p_data => x_msg_data);
702:
703: EXCEPTION

Line 711: FND_MSG_PUB.Count_And_Get (

707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO Duplicate_Import_List;
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );

Line 721: FND_MSG_PUB.Count_And_Get (

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

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

726:
727: WHEN OTHERS THEN
728: ROLLBACK TO Duplicate_Import_List;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
733: END IF;
734: -- Standard call to get message count and if count=1, get the message

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

728: ROLLBACK TO Duplicate_Import_List;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
731: THEN
732: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
733: END IF;
734: -- Standard call to get message count and if count=1, get the message
735: FND_MSG_PUB.Count_And_Get (
736: p_encoded => FND_API.G_FALSE,

Line 735: FND_MSG_PUB.Count_And_Get (

731: THEN
732: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
733: END IF;
734: -- Standard call to get message count and if count=1, get the message
735: FND_MSG_PUB.Count_And_Get (
736: p_encoded => FND_API.G_FALSE,
737: p_count => x_msg_count,
738: p_data => x_msg_data
739: );

Line 822: FND_MSG_PUB.initialize;

818:
819: -- Initialize message list if p_init_msg_list is set to TRUE.
820: IF FND_API.to_Boolean( p_init_msg_list )
821: THEN
822: FND_MSG_PUB.initialize;
823: END IF;
824:
825: -- Debug Message
826: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1138: FND_MSG_PUB.Count_And_Get

1134: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1135: END IF;
1136:
1137: -- Standard call to get message count and if count is 1, get message info.
1138: FND_MSG_PUB.Count_And_Get
1139: (p_count => x_msg_count,
1140: p_data => x_msg_data
1141: );
1142: EXCEPTION

Line 1152: FND_MSG_PUB.Count_And_Get (

1148: WHEN FND_API.G_EXC_ERROR THEN
1149: ROLLBACK TO CREATE_Import_List_PVT;
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: -- Standard call to get message count and if count=1, get the message
1152: FND_MSG_PUB.Count_And_Get (
1153: p_encoded => FND_API.G_FALSE,
1154: p_count => x_msg_count,
1155: p_data => x_msg_data
1156: );

Line 1162: FND_MSG_PUB.Count_And_Get (

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

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

1167:
1168: WHEN OTHERS THEN
1169: ROLLBACK TO CREATE_Import_List_PVT;
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1174: END IF;
1175: -- Standard call to get message count and if count=1, get the message

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

1169: ROLLBACK TO CREATE_Import_List_PVT;
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1172: THEN
1173: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1174: END IF;
1175: -- Standard call to get message count and if count=1, get the message
1176: FND_MSG_PUB.Count_And_Get (
1177: p_encoded => FND_API.G_FALSE,

Line 1176: FND_MSG_PUB.Count_And_Get (

1172: THEN
1173: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1174: END IF;
1175: -- Standard call to get message count and if count=1, get the message
1176: FND_MSG_PUB.Count_And_Get (
1177: p_encoded => FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data
1180: );

Line 1231: FND_MSG_PUB.initialize;

1227:
1228: -- Initialize message list if p_init_msg_list is set to TRUE.
1229: IF FND_API.to_Boolean( p_init_msg_list )
1230: THEN
1231: FND_MSG_PUB.initialize;
1232: END IF;
1233:
1234: -- Debug Message
1235: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1401: FND_MSG_PUB.Count_And_Get

1397: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1398: END IF;
1399:
1400: -- Standard call to get message count and if count is 1, get message info.
1401: FND_MSG_PUB.Count_And_Get
1402: (p_count => x_msg_count,
1403: p_data => x_msg_data
1404: );
1405: EXCEPTION

Line 1415: FND_MSG_PUB.Count_And_Get (

1411: WHEN FND_API.G_EXC_ERROR THEN
1412: ROLLBACK TO UPDATE_Import_List_PVT;
1413: x_return_status := FND_API.G_RET_STS_ERROR;
1414: -- Standard call to get message count and if count=1, get the message
1415: FND_MSG_PUB.Count_And_Get (
1416: p_encoded => FND_API.G_FALSE,
1417: p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );

Line 1425: FND_MSG_PUB.Count_And_Get (

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

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

1430:
1431: WHEN OTHERS THEN
1432: ROLLBACK TO UPDATE_Import_List_PVT;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1435: THEN
1436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1437: END IF;
1438: -- Standard call to get message count and if count=1, get the message

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

1432: ROLLBACK TO UPDATE_Import_List_PVT;
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1435: THEN
1436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1437: END IF;
1438: -- Standard call to get message count and if count=1, get the message
1439: FND_MSG_PUB.Count_And_Get (
1440: p_encoded => FND_API.G_FALSE,

Line 1439: FND_MSG_PUB.Count_And_Get (

1435: THEN
1436: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1437: END IF;
1438: -- Standard call to get message count and if count=1, get the message
1439: FND_MSG_PUB.Count_And_Get (
1440: p_encoded => FND_API.G_FALSE,
1441: p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );

Line 1480: FND_MSG_PUB.initialize;

1476:
1477: -- Initialize message list if p_init_msg_list is set to TRUE.
1478: IF FND_API.to_Boolean( p_init_msg_list )
1479: THEN
1480: FND_MSG_PUB.initialize;
1481: END IF;
1482:
1483: -- Debug Message
1484: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1523: FND_MSG_PUB.Count_And_Get

1519: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1520: END IF;
1521:
1522: -- Standard call to get message count and if count is 1, get message info.
1523: FND_MSG_PUB.Count_And_Get
1524: (p_count => x_msg_count,
1525: p_data => x_msg_data
1526: );
1527: EXCEPTION

Line 1537: FND_MSG_PUB.Count_And_Get (

1533: WHEN FND_API.G_EXC_ERROR THEN
1534: ROLLBACK TO DELETE_Import_List_PVT;
1535: x_return_status := FND_API.G_RET_STS_ERROR;
1536: -- Standard call to get message count and if count=1, get the message
1537: FND_MSG_PUB.Count_And_Get (
1538: p_encoded => FND_API.G_FALSE,
1539: p_count => x_msg_count,
1540: p_data => x_msg_data
1541: );

Line 1547: FND_MSG_PUB.Count_And_Get (

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

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

1552:
1553: WHEN OTHERS THEN
1554: ROLLBACK TO DELETE_Import_List_PVT;
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1559: END IF;
1560: -- Standard call to get message count and if count=1, get the message

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

1554: ROLLBACK TO DELETE_Import_List_PVT;
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1559: END IF;
1560: -- Standard call to get message count and if count=1, get the message
1561: FND_MSG_PUB.Count_And_Get (
1562: p_encoded => FND_API.G_FALSE,

Line 1561: FND_MSG_PUB.Count_And_Get (

1557: THEN
1558: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1559: END IF;
1560: -- Standard call to get message count and if count=1, get the message
1561: FND_MSG_PUB.Count_And_Get (
1562: p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data
1565: );

Line 1607: FND_MSG_PUB.initialize;

1603:
1604: -- Initialize message list if p_init_msg_list is set to TRUE.
1605: IF FND_API.to_Boolean( p_init_msg_list )
1606: THEN
1607: FND_MSG_PUB.initialize;
1608: END IF;
1609:
1610: -- Standard call to check for call compatibility.
1611: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1635: FETCH c_Import_List INTO l_IMPORT_LIST_HEADER_ID;
1636:
1637: IF (c_Import_List%NOTFOUND) THEN
1638: CLOSE c_Import_List;
1639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1640: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1641: FND_MSG_PUB.add;
1642: END IF;
1643: RAISE FND_API.g_exc_error;

Line 1641: FND_MSG_PUB.add;

1637: IF (c_Import_List%NOTFOUND) THEN
1638: CLOSE c_Import_List;
1639: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1640: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1641: FND_MSG_PUB.add;
1642: END IF;
1643: RAISE FND_API.g_exc_error;
1644: END IF;
1645:

Line 1649: FND_MSG_PUB.count_and_get(

1645:
1646: CLOSE c_Import_List;
1647:
1648: -------------------- finish --------------------------
1649: FND_MSG_PUB.count_and_get(
1650: p_encoded => FND_API.g_false,
1651: p_count => x_msg_count,
1652: p_data => x_msg_data);
1653: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1667: FND_MSG_PUB.Count_And_Get (

1663: WHEN FND_API.G_EXC_ERROR THEN
1664: ROLLBACK TO LOCK_Import_List_PVT;
1665: x_return_status := FND_API.G_RET_STS_ERROR;
1666: -- Standard call to get message count and if count=1, get the message
1667: FND_MSG_PUB.Count_And_Get (
1668: p_encoded => FND_API.G_FALSE,
1669: p_count => x_msg_count,
1670: p_data => x_msg_data
1671: );

Line 1677: FND_MSG_PUB.Count_And_Get (

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

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

1682:
1683: WHEN OTHERS THEN
1684: ROLLBACK TO LOCK_Import_List_PVT;
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1687: THEN
1688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1689: END IF;
1690: -- Standard call to get message count and if count=1, get the message

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

1684: ROLLBACK TO LOCK_Import_List_PVT;
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1686: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1687: THEN
1688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1689: END IF;
1690: -- Standard call to get message count and if count=1, get the message
1691: FND_MSG_PUB.Count_And_Get (
1692: p_encoded => FND_API.G_FALSE,

Line 1691: FND_MSG_PUB.Count_And_Get (

1687: THEN
1688: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1689: END IF;
1690: -- Standard call to get message count and if count=1, get the message
1691: FND_MSG_PUB.Count_And_Get (
1692: p_encoded => FND_API.G_FALSE,
1693: p_count => x_msg_count,
1694: p_data => x_msg_data
1695: );

Line 1978: FND_MSG_PUB.Add;

1974: IF p_ams_import_rec.server_flag = 'Y'
1975: THEN
1976: if fnd_profile.value('AMS_IMP_CTL_PATH') is NULL then
1977: FND_MESSAGE.set_name('AMS', 'AMS_IMP_CTL_PATH');
1978: FND_MSG_PUB.Add;
1979: x_return_status := FND_API.g_ret_sts_error;
1980: RETURN;
1981: end if;
1982:

Line 1985: FND_MSG_PUB.Add;

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

Line 2000: FND_MSG_PUB.Add;

1996: (p_ams_import_rec.expiry_date < SYSDATE)
1997: THEN
1998: --AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ams_import_NO_name');
1999: FND_MESSAGE.set_name('AMS', 'AMS_IMP_EXP_DATE');
2000: FND_MSG_PUB.Add;
2001: x_return_status := FND_API.g_ret_sts_error;
2002: RETURN;
2003: END IF;
2004:

Line 2011: FND_MSG_PUB.Add;

2007: ((p_ams_import_rec.usage is NULL AND p_ams_import_rec.expiry_date is NULL) OR
2008: (p_ams_import_rec.usage = FND_API.g_miss_num AND p_ams_import_rec.expiry_date = FND_API.g_miss_date))
2009: THEN
2010: FND_MESSAGE.set_name('AMS', 'AMS_IMP_RENTED_LIST');
2011: FND_MSG_PUB.Add;
2012: x_return_status := FND_API.g_ret_sts_error;
2013: RETURN;
2014: END IF;
2015: END IF;

Line 2027: FND_MSG_PUB.Add;

2023: IF (p_ams_import_rec.data_filename = FND_API.g_miss_char) OR
2024: (p_ams_import_rec.data_filename is NULL)
2025: THEN
2026: FND_MESSAGE.set_name('AMS', 'API_MISS_DATA_FILENAME');
2027: FND_MSG_PUB.Add;
2028: x_return_status := FND_API.g_ret_sts_error;
2029: close c_get_Import_list;
2030: RETURN;
2031: END IF;

Line 2036: FND_MSG_PUB.Add;

2032:
2033: IF (p_ams_import_rec.terminated_by = p_ams_import_rec.enclosed_by)
2034: THEN
2035: FND_MESSAGE.set_name('AMS', 'API_SAME_TERMIN_ENCLOSED');
2036: FND_MSG_PUB.Add;
2037: x_return_status := FND_API.g_ret_sts_error;
2038: close c_get_Import_list;
2039: RETURN;
2040: END IF;

Line 2049: FND_MSG_PUB.Add;

2045: IF (c_get_Import_List_name%FOUND)
2046: THEN
2047: --AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_IMPORT_NAME_DUPLICATE');
2048: FND_MESSAGE.set_name('AMS', 'AMS_IMPORT_NAME_DUPLICATE');
2049: FND_MSG_PUB.Add;
2050: x_return_status := FND_API.g_ret_sts_error;
2051: close c_get_Import_list_name;
2052: RETURN;
2053: END IF;

Line 2553: FND_MSG_PUB.initialize;

2549:
2550: -- Initialize message list if p_init_msg_list is set to TRUE.
2551: IF FND_API.to_Boolean( p_init_msg_list )
2552: THEN
2553: FND_MSG_PUB.initialize;
2554: END IF;
2555: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2556: Check_ams_import_Items(
2557: p_ams_import_rec => p_ams_import_rec,

Line 2610: FND_MSG_PUB.Count_And_Get

2606: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2607: END IF;
2608:
2609: -- Standard call to get message count and if count is 1, get message info.
2610: FND_MSG_PUB.Count_And_Get
2611: (p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );
2614: IF (AMS_DEBUG_HIGH_ON) THEN

Line 2629: FND_MSG_PUB.Count_And_Get (

2625: WHEN FND_API.G_EXC_ERROR THEN
2626: ROLLBACK TO VALIDATE_Import_List_;
2627: x_return_status := FND_API.G_RET_STS_ERROR;
2628: -- Standard call to get message count and if count=1, get the message
2629: FND_MSG_PUB.Count_And_Get (
2630: p_encoded => FND_API.G_FALSE,
2631: p_count => x_msg_count,
2632: p_data => x_msg_data
2633: );

Line 2639: FND_MSG_PUB.Count_And_Get (

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

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

2644:
2645: WHEN OTHERS THEN
2646: ROLLBACK TO VALIDATE_Import_List_;
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2649: THEN
2650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2651: END IF;
2652: -- Standard call to get message count and if count=1, get the message

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

2646: ROLLBACK TO VALIDATE_Import_List_;
2647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2648: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2649: THEN
2650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2651: END IF;
2652: -- Standard call to get message count and if count=1, get the message
2653: FND_MSG_PUB.Count_And_Get (
2654: p_encoded => FND_API.G_FALSE,

Line 2653: FND_MSG_PUB.Count_And_Get (

2649: THEN
2650: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2651: END IF;
2652: -- Standard call to get message count and if count=1, get the message
2653: FND_MSG_PUB.Count_And_Get (
2654: p_encoded => FND_API.G_FALSE,
2655: p_count => x_msg_count,
2656: p_data => x_msg_data
2657: );

Line 2674: FND_MSG_PUB.initialize;

2670: BEGIN
2671: -- Initialize message list if p_init_msg_list is set to TRUE.
2672: IF FND_API.to_Boolean( p_init_msg_list )
2673: THEN
2674: FND_MSG_PUB.initialize;
2675: END IF;
2676:
2677: -- Initialize API return status to SUCCESS
2678: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2691: FND_MSG_PUB.Count_And_Get

2687:
2688: AMS_UTILITY_PVT.debug_message('Private API: Validate_ams_import_rec');
2689: END IF;
2690: -- Standard call to get message count and if count is 1, get message info.
2691: FND_MSG_PUB.Count_And_Get
2692: (p_count => x_msg_count,
2693: p_data => x_msg_data
2694: );
2695: END Validate_ams_import_Rec;