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 465: -- Standard call to get message count and if count=1, get the message

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

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

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,
486: p_count => x_msg_count,
487: p_data => x_msg_data

Line 610: -- Standard Start of API savepoint

606:
607: l_status_id c_get_status_id%ROWTYPE;
608:
609: BEGIN
610: -- Standard Start of API savepoint
611: SAVEPOINT Duplicate_Import_List;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

609: BEGIN
610: -- Standard Start of API savepoint
611: SAVEPOINT Duplicate_Import_List;
612:
613: -- Standard call to check for call compatibility.
614: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
615: p_api_version_number,
616: l_api_name,
617: G_PKG_NAME) THEN

Line 693: -- Standard check for p_commit

689: CLOSE c_get_file_type;
690:
691: AMS_Utility_PVT.Write_Conc_Log (' Start Duplicate_Import_List 4444444 after c_get_file_type ');
692:
693: -- Standard check for p_commit
694: IF FND_API.to_Boolean( p_commit) THEN
695: COMMIT WORK;
696: END IF;
697:

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

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

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

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

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

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

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

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,
737: p_count => x_msg_count,
738: p_data => x_msg_data

Line 804: -- Standard Start of API savepoint

800: -- SOLIN
801: l_return_status VARCHAR2(30);
802: l_ams_import_rec ams_import_rec_type := g_miss_ams_import_rec;
803: BEGIN
804: -- Standard Start of API savepoint
805: SAVEPOINT CREATE_Import_List_PVT;
806:
807:
808: -- Standard call to check for call compatibility.

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

804: -- Standard Start of API savepoint
805: SAVEPOINT CREATE_Import_List_PVT;
806:
807:
808: -- Standard call to check for call compatibility.
809:
810: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
811: p_api_version_number,
812: l_api_name,

Line 1124: -- Standard check for p_commit

1120:
1121: -- End of API body
1122: --
1123:
1124: -- Standard check for p_commit
1125: IF FND_API.to_Boolean( p_commit )
1126: THEN
1127: COMMIT WORK;
1128: END IF;

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

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

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

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

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

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

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

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,
1178: p_count => x_msg_count,
1179: p_data => x_msg_data

Line 1216: -- Standard Start of API savepoint

1212: l_tar_ams_import_rec AMS_Import_List_PVT.ams_import_rec_type := P_ams_import_rec;
1213: l_rowid ROWID;
1214:
1215: BEGIN
1216: -- Standard Start of API savepoint
1217: SAVEPOINT UPDATE_Import_List_PVT;
1218:
1219: -- Standard call to check for call compatibility.
1220: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1215: BEGIN
1216: -- Standard Start of API savepoint
1217: SAVEPOINT UPDATE_Import_List_PVT;
1218:
1219: -- Standard call to check for call compatibility.
1220: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1221: p_api_version_number,
1222: l_api_name,
1223: G_PKG_NAME)

Line 1387: -- Standard check for p_commit

1383: --
1384: -- End of API body.
1385: --
1386:
1387: -- Standard check for p_commit
1388: IF FND_API.to_Boolean( p_commit )
1389: THEN
1390: COMMIT WORK;
1391: END IF;

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

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

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

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

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

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

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

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,
1441: p_count => x_msg_count,
1442: p_data => x_msg_data

Line 1465: -- Standard Start of API savepoint

1461: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1462: l_object_version_number NUMBER;
1463:
1464: BEGIN
1465: -- Standard Start of API savepoint
1466: SAVEPOINT DELETE_Import_List_PVT;
1467:
1468: -- Standard call to check for call compatibility.
1469: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

1464: BEGIN
1465: -- Standard Start of API savepoint
1466: SAVEPOINT DELETE_Import_List_PVT;
1467:
1468: -- Standard call to check for call compatibility.
1469: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1470: p_api_version_number,
1471: l_api_name,
1472: G_PKG_NAME)

Line 1509: -- Standard check for p_commit

1505: --
1506: -- End of API body
1507: --
1508:
1509: -- Standard check for p_commit
1510: IF FND_API.to_Boolean( p_commit )
1511: THEN
1512: COMMIT WORK;
1513: END IF;

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

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

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

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

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

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

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

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,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data

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

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,
1612: p_api_version_number,
1613: l_api_name,
1614: G_PKG_NAME)

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

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

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

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

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

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,
1693: p_count => x_msg_count,
1694: p_data => x_msg_data

Line 2530: -- Standard Start of API savepoint

2526: l_object_version_number NUMBER;
2527: l_ams_import_rec AMS_Import_List_PVT.ams_import_rec_type;
2528:
2529: BEGIN
2530: -- Standard Start of API savepoint
2531: SAVEPOINT VALIDATE_Import_List_;
2532: IF (AMS_DEBUG_HIGH_ON) THEN
2533:
2534: AMS_UTILITY_PVT.debug_message('Private API: ' || 'inside validate_import_list');

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

2533:
2534: AMS_UTILITY_PVT.debug_message('Private API: ' || 'inside validate_import_list');
2535: END IF;
2536:
2537: -- Standard call to check for call compatibility.
2538: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2539: p_api_version_number,
2540: l_api_name,
2541: G_PKG_NAME)

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

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

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

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

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

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

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

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,
2655: p_count => x_msg_count,
2656: p_data => x_msg_data

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

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