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 STANDARD

Line 106: -- Standard Start of API savepoint

102: l_error VARCHAR2(2000) := '';
103:
104: BEGIN
105:
106: -- Standard Start of API savepoint
107: --SAVEPOINT Do_Recurring;
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 109: -- Standard call to check for call compatibility.

105:
106: -- Standard Start of API savepoint
107: --SAVEPOINT Do_Recurring;
108:
109: -- Standard call to check for call compatibility.
110: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
111: p_api_version_number,
112: l_api_name,
113: G_PKG_NAME) THEN

Line 472: -- Standard call to get message count and if count=1, get the message

468:
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

Line 490: -- Standard call to get message count and if count=1, get the message

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,
493: p_count => x_msg_count,
494: p_data => x_msg_data

Line 617: -- Standard Start of API savepoint

613:
614: l_status_id c_get_status_id%ROWTYPE;
615:
616: BEGIN
617: -- Standard Start of API savepoint
618: SAVEPOINT Duplicate_Import_List;
619:
620: -- Standard call to check for call compatibility.
621: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 620: -- Standard call to check for call compatibility.

616: BEGIN
617: -- Standard Start of API savepoint
618: SAVEPOINT Duplicate_Import_List;
619:
620: -- Standard call to check for call compatibility.
621: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
622: p_api_version_number,
623: l_api_name,
624: G_PKG_NAME) THEN

Line 700: -- Standard check for p_commit

696: CLOSE c_get_file_type;
697:
698: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List 4444444 after c_get_file_type ');
699:
700: -- Standard check for p_commit
701: IF FND_API.to_Boolean( p_commit) THEN
702: COMMIT WORK;
703: END IF;
704:

Line 705: -- Standard call to get message count and if count is 1, get message info.

701: IF FND_API.to_Boolean( p_commit) THEN
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:

Line 717: -- Standard call to get message count and if count=1, get the message

713: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
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

Line 727: -- Standard call to get message count and if count=1, get the message

723:
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

Line 741: -- Standard call to get message count and if count=1, get the message

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,
744: p_count => x_msg_count,
745: p_data => x_msg_data

Line 811: -- Standard Start of API savepoint

807: -- SOLIN
808: l_return_status VARCHAR2(30);
809: l_ams_import_rec ams_import_rec_type := g_miss_ams_import_rec;
810: BEGIN
811: -- Standard Start of API savepoint
812: SAVEPOINT CREATE_Import_List_PVT;
813:
814:
815: -- Standard call to check for call compatibility.

Line 815: -- Standard call to check for call compatibility.

811: -- Standard Start of API savepoint
812: SAVEPOINT CREATE_Import_List_PVT;
813:
814:
815: -- Standard call to check for call compatibility.
816:
817: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
818: p_api_version_number,
819: l_api_name,

Line 1131: -- Standard check for p_commit

1127:
1128: -- End of API body
1129: --
1130:
1131: -- Standard check for p_commit
1132: IF FND_API.to_Boolean( p_commit )
1133: THEN
1134: COMMIT WORK;
1135: END IF;

Line 1144: -- Standard call to get message count and if count is 1, get message info.

1140:
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: );

Line 1158: -- Standard call to get message count and if count=1, get the message

1154:
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

Line 1168: -- Standard call to get message count and if count=1, get the message

1164:
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

Line 1182: -- Standard call to get message count and if count=1, get the message

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,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data

Line 1223: -- Standard Start of API savepoint

1219: l_tar_ams_import_rec AMS_Import_List_PVT.ams_import_rec_type := P_ams_import_rec;
1220: l_rowid ROWID;
1221:
1222: BEGIN
1223: -- Standard Start of API savepoint
1224: SAVEPOINT UPDATE_Import_List_PVT;
1225:
1226: -- Standard call to check for call compatibility.
1227: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1226: -- Standard call to check for call compatibility.

1222: BEGIN
1223: -- Standard Start of API savepoint
1224: SAVEPOINT UPDATE_Import_List_PVT;
1225:
1226: -- Standard call to check for call compatibility.
1227: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1228: p_api_version_number,
1229: l_api_name,
1230: G_PKG_NAME)

Line 1394: -- Standard check for p_commit

1390: --
1391: -- End of API body.
1392: --
1393:
1394: -- Standard check for p_commit
1395: IF FND_API.to_Boolean( p_commit )
1396: THEN
1397: COMMIT WORK;
1398: END IF;

Line 1407: -- Standard call to get message count and if count is 1, get message info.

1403:
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: );

Line 1421: -- Standard call to get message count and if count=1, get the message

1417:
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

Line 1431: -- Standard call to get message count and if count=1, get the message

1427:
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

Line 1445: -- Standard call to get message count and if count=1, get the message

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,
1448: p_count => x_msg_count,
1449: p_data => x_msg_data

Line 1472: -- Standard Start of API savepoint

1468: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1469: l_object_version_number NUMBER;
1470:
1471: BEGIN
1472: -- Standard Start of API savepoint
1473: SAVEPOINT DELETE_Import_List_PVT;
1474:
1475: -- Standard call to check for call compatibility.
1476: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 1475: -- Standard call to check for call compatibility.

1471: BEGIN
1472: -- Standard Start of API savepoint
1473: SAVEPOINT DELETE_Import_List_PVT;
1474:
1475: -- Standard call to check for call compatibility.
1476: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1477: p_api_version_number,
1478: l_api_name,
1479: G_PKG_NAME)

Line 1516: -- Standard check for p_commit

1512: --
1513: -- End of API body
1514: --
1515:
1516: -- Standard check for p_commit
1517: IF FND_API.to_Boolean( p_commit )
1518: THEN
1519: COMMIT WORK;
1520: END IF;

Line 1529: -- Standard call to get message count and if count is 1, get message info.

1525:
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: );

Line 1543: -- Standard call to get message count and if count=1, get the message

1539:
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

Line 1553: -- Standard call to get message count and if count=1, get the message

1549:
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

Line 1567: -- Standard call to get message count and if count=1, get the message

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,
1570: p_count => x_msg_count,
1571: p_data => x_msg_data

Line 1617: -- Standard call to check for call compatibility.

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,
1619: p_api_version_number,
1620: l_api_name,
1621: G_PKG_NAME)

Line 1673: -- Standard call to get message count and if count=1, get the message

1669:
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

Line 1683: -- Standard call to get message count and if count=1, get the message

1679:
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

Line 1697: -- Standard call to get message count and if count=1, get the message

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,
1700: p_count => x_msg_count,
1701: p_data => x_msg_data

Line 2537: -- Standard Start of API savepoint

2533: l_object_version_number NUMBER;
2534: l_ams_import_rec AMS_Import_List_PVT.ams_import_rec_type;
2535:
2536: BEGIN
2537: -- Standard Start of API savepoint
2538: SAVEPOINT VALIDATE_Import_List_;
2539: IF (AMS_DEBUG_HIGH_ON) THEN
2540:
2541: AMS_UTILITY_PVT.debug_message('Private API: ' || 'inside validate_import_list');

Line 2544: -- Standard call to check for call compatibility.

2540:
2541: AMS_UTILITY_PVT.debug_message('Private API: ' || 'inside validate_import_list');
2542: END IF;
2543:
2544: -- Standard call to check for call compatibility.
2545: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2546: p_api_version_number,
2547: l_api_name,
2548: G_PKG_NAME)

Line 2616: -- Standard call to get message count and if count is 1, get message info.

2612:
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: );

Line 2635: -- Standard call to get message count and if count=1, get the message

2631:
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

Line 2645: -- Standard call to get message count and if count=1, get the message

2641:
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

Line 2659: -- Standard call to get message count and if count=1, get the message

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,
2662: p_count => x_msg_count,
2663: p_data => x_msg_data

Line 2697: -- Standard call to get message count and if count is 1, get message info.

2693: IF (AMS_DEBUG_HIGH_ON) THEN
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: );