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.AMW_LOAD_AUDIT_PROCEDURE_DATA dependencies on FND_API

Line 487: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

483: l_attachment_rec.media_id := lx_media_id;
484:
485: x_msg_data := null;
486: x_msg_count := 0;
487: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
488: AMW_LOAD_AUDIT_PROCEDURE_DATA.CREATE_FND_ATTACHMENT(
489: p_api_version_number => 1,
490: p_init_msg_list => FND_API.G_TRUE,
491: x_return_status => X_RETURN_STATUS,

Line 490: p_init_msg_list => FND_API.G_TRUE,

486: x_msg_count := 0;
487: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
488: AMW_LOAD_AUDIT_PROCEDURE_DATA.CREATE_FND_ATTACHMENT(
489: p_api_version_number => 1,
490: p_init_msg_list => FND_API.G_TRUE,
491: x_return_status => X_RETURN_STATUS,
492: x_msg_count => X_MSG_COUNT,
493: x_msg_data => X_MSG_DATA,
494: p_Fnd_Attachment_rec => l_attachment_rec,

Line 790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

786: END update_interface_with_error;
787:
788: PROCEDURE Create_Fnd_Attachment(
789: p_api_version_number IN NUMBER,
790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791: p_commit IN VARCHAR2 := FND_API.G_FALSE,
792: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
793:
794: x_return_status OUT NOCOPY VARCHAR2,

Line 791: p_commit IN VARCHAR2 := FND_API.G_FALSE,

787:
788: PROCEDURE Create_Fnd_Attachment(
789: p_api_version_number IN NUMBER,
790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791: p_commit IN VARCHAR2 := FND_API.G_FALSE,
792: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
793:
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,

Line 792: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

788: PROCEDURE Create_Fnd_Attachment(
789: p_api_version_number IN NUMBER,
790: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
791: p_commit IN VARCHAR2 := FND_API.G_FALSE,
792: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
793:
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,

Line 830: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

826: -- Standard Start of API savepoint
827: SAVEPOINT CREATE_Fnd_Attachment_PVT;
828:
829: -- Standard call to check for call compatibility.
830: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
831: p_api_version_number,
832: l_api_name,
833: G_PKG_NAME)
834: THEN

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831: p_api_version_number,
832: l_api_name,
833: G_PKG_NAME)
834: THEN
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: -- Initialize message list if p_init_msg_list is set to TRUE.
839: IF FND_API.to_Boolean( p_init_msg_list )

Line 839: IF FND_API.to_Boolean( p_init_msg_list )

835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837:
838: -- Initialize message list if p_init_msg_list is set to TRUE.
839: IF FND_API.to_Boolean( p_init_msg_list )
840: THEN
841: FND_MSG_PUB.initialize;
842: END IF;
843:

Line 851: x_return_status := FND_API.G_RET_STS_SUCCESS;

847: END IF;
848:
849:
850: -- Initialize API return status to SUCCESS
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852:
853: -- Local variable initialization
854:
855: -- =========================================================================

Line 862: RAISE FND_API.G_EXC_ERROR;

858:
859: IF FND_GLOBAL.User_Id IS NULL
860: THEN
861: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864:
865: -- Debug Message
866: IF (AMW_DEBUG_HIGH_ON) THEN

Line 908: Update fnd_documents_tl because FND_API inserts newly generated

904: p_Fnd_Attachment_rec.short_text
905: );
906: else
907: /*
908: Update fnd_documents_tl because FND_API inserts newly generated
909: media_id into that table.
910: */
911: update fnd_documents_tl
912: set media_id = p_Fnd_Attachment_rec.media_id

Line 1009: IF FND_API.to_Boolean( p_commit )

1005: end if;
1006:
1007:
1008: -- Standard check for p_commit
1009: IF FND_API.to_Boolean( p_commit )
1010: THEN
1011: COMMIT WORK;
1012: END IF;
1013:

Line 1030: x_return_status := FND_API.g_ret_sts_error;

1026:
1027: EXCEPTION
1028:
1029: WHEN AMW_Utility_PVT.resource_locked THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO CREATE_Fnd_Attachment_PVT;

Line 1033: WHEN FND_API.G_EXC_ERROR THEN

1029: WHEN AMW_Utility_PVT.resource_locked THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: -- Standard call to get message count and if count=1, get the message
1037: FND_MSG_PUB.Count_And_Get (

Line 1035: x_return_status := FND_API.G_RET_STS_ERROR;

1031: AMW_Utility_PVT.Error_Message(p_message_name => 'AMW_API_RESOURCE_LOCKED');
1032:
1033: WHEN FND_API.G_EXC_ERROR THEN
1034: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: -- Standard call to get message count and if count=1, get the message
1037: FND_MSG_PUB.Count_And_Get (
1038: p_encoded => FND_API.G_FALSE,
1039: p_count => x_msg_count,

Line 1038: p_encoded => FND_API.G_FALSE,

1034: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036: -- Standard call to get message count and if count=1, get the message
1037: FND_MSG_PUB.Count_And_Get (
1038: p_encoded => FND_API.G_FALSE,
1039: p_count => x_msg_count,
1040: p_data => x_msg_data
1041: );
1042:

Line 1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1039: p_count => x_msg_count,
1040: p_data => x_msg_data
1041: );
1042:
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Standard call to get message count and if count=1, get the message
1047: FND_MSG_PUB.Count_And_Get (

Line 1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1041: );
1042:
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Standard call to get message count and if count=1, get the message
1047: FND_MSG_PUB.Count_And_Get (
1048: p_encoded => FND_API.G_FALSE,
1049: p_count => x_msg_count,

Line 1048: p_encoded => FND_API.G_FALSE,

1044: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: -- Standard call to get message count and if count=1, get the message
1047: FND_MSG_PUB.Count_And_Get (
1048: p_encoded => FND_API.G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => x_msg_data
1051: );
1052:

Line 1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1051: );
1052:
1053: WHEN OTHERS THEN
1054: ROLLBACK TO CREATE_Fnd_Attachment_PVT;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1057: THEN
1058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1059: END IF;

Line 1062: p_encoded => FND_API.G_FALSE,

1058: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1059: END IF;
1060: -- Standard call to get message count and if count=1, get the message
1061: FND_MSG_PUB.Count_And_Get (
1062: p_encoded => FND_API.G_FALSE,
1063: p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );
1066: End Create_Fnd_Attachment;