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

Line 37: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

33: -- Standard Start of API savepoint
34: SAVEPOINT IEM_EncryptPassword_PVT;
35:
36: -- Standard call to check for call compatibility.
37: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
38: p_api_version_number,
39: l_api_name,
40: G_PKG_NAME)
41: THEN

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38: p_api_version_number,
39: l_api_name,
40: G_PKG_NAME)
41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 46: IF FND_API.to_Boolean( p_init_msg_list ) THEN

42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list ) THEN
47: FND_MSG_PUB.initialize;
48: END IF;
49:
50: -- Initialize API return status to SUCCESS

Line 51: x_return_status := FND_API.G_RET_STS_SUCCESS;

47: FND_MSG_PUB.initialize;
48: END IF;
49:
50: -- Initialize API return status to SUCCESS
51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: -- API begins
54:
55: l_raw_data := RTRIM(LTRIM(p_raw_data));

Line 83: IF FND_API.To_Boolean(p_commit) THEN

79: key_string => l_random_key,
80: encrypted_string => x_encrypted_data );
81:
82: -- Standard Check Of p_commit.
83: IF FND_API.To_Boolean(p_commit) THEN
84: COMMIT WORK;
85: END IF;
86:
87: -- Standard callto get message count and if count is 1, get message info.

Line 96: x_return_status := FND_API.G_RET_STS_ERROR ;

92:
93: EXCEPTION
94: WHEN IEM_PASSWORD_NULL THEN
95: ROLLBACK TO IEM_EncryptPassword_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: FND_MESSAGE.SET_NAME('IEM', 'IEM_PASSWORD_NULL');
98:
99: FND_MSG_PUB.ADD;
100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 105: x_return_status := FND_API.G_RET_STS_ERROR;

101: p_data => x_msg_data );
102:
103: WHEN IEM_DOUBLE_ENCRIPTED THEN
104: ROLLBACK TO IEM_EncryptPassword_PVT;
105: x_return_status := FND_API.G_RET_STS_ERROR;
106: FND_MESSAGE.SET_NAME('IEM', 'IEM_DOUBLE_ENCRIPTED');
107:
108: FND_MSG_PUB.Add;
109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 111: WHEN FND_API.G_EXC_ERROR THEN

107:
108: FND_MSG_PUB.Add;
109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
110:
111: WHEN FND_API.G_EXC_ERROR THEN
112: ROLLBACK TO IEM_EncryptPassword_PVT;
113: x_return_status := FND_API.G_RET_STS_ERROR ;
114: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
115: p_data => x_msg_data );

Line 113: x_return_status := FND_API.G_RET_STS_ERROR ;

109: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
110:
111: WHEN FND_API.G_EXC_ERROR THEN
112: ROLLBACK TO IEM_EncryptPassword_PVT;
113: x_return_status := FND_API.G_RET_STS_ERROR ;
114: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
115: p_data => x_msg_data );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: ROLLBACK TO IEM_EncryptPassword_PVT;

Line 116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

112: ROLLBACK TO IEM_EncryptPassword_PVT;
113: x_return_status := FND_API.G_RET_STS_ERROR ;
114: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
115: p_data => x_msg_data );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: ROLLBACK TO IEM_EncryptPassword_PVT;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
120: p_data => x_msg_data );

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

114: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
115: p_data => x_msg_data );
116: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
117: ROLLBACK TO IEM_EncryptPassword_PVT;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
119: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
120: p_data => x_msg_data );
121:
122: WHEN OTHERS THEN

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

120: p_data => x_msg_data );
121:
122: WHEN OTHERS THEN
123: ROLLBACK TO IEM_EncryptPassword_PVT;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125:
126: IF FND_MSG_PUB.Check_Msg_Level
127: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
128: THEN

Line 170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

166: -- Standard Start of API savepoint
167: SAVEPOINT IEM_DecryptPassword_PVT;
168:
169: -- Standard call to check for call compatibility.
170: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171: p_api_version_number,
172: l_api_name,
173: G_PKG_NAME)
174: THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 179: IF FND_API.to_Boolean( p_init_msg_list ) THEN

175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: -- Initialize message list if p_init_msg_list is set to TRUE.
179: IF FND_API.to_Boolean( p_init_msg_list ) THEN
180: FND_MSG_PUB.initialize;
181: END IF;
182:
183: -- Initialize API return status to SUCCESS

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: FND_MSG_PUB.initialize;
181: END IF;
182:
183: -- Initialize API return status to SUCCESS
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: -- Decrypt the data
187: dbms_obfuscation_toolkit.DESDecrypt(
188: input_string => p_input_data,

Line 197: IF FND_API.To_Boolean(p_commit) THEN

193: -- Normalize output
194: x_decrypted_data := RTRIM(LTRIM(l_decrypted_data));
195:
196: -- Standard Check Of p_commit.
197: IF FND_API.To_Boolean(p_commit) THEN
198: COMMIT WORK;
199: END IF;
200:
201: -- Standard callto get message count and if count is 1, get message info.

Line 210: x_return_status := FND_API.G_RET_STS_ERROR ;

206:
207: EXCEPTION
208: WHEN IEM_PASSWORD_NULL THEN
209: ROLLBACK TO IEM_DecryptPassword_PVT;
210: x_return_status := FND_API.G_RET_STS_ERROR ;
211: FND_MESSAGE.SET_NAME('IEM', 'IEM_PASSWORD_NULL');
212:
213: FND_MSG_PUB.ADD;
214: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: p_data => x_msg_data );
216:
217: WHEN IEM_INVALID_INPUT THEN
218: ROLLBACK TO IEM_DecryptPassword_PVT;
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: FND_MESSAGE.SET_NAME('IEM', 'IEM_INVALID_INPUT');
221:
222: FND_MSG_PUB.Add;
223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 225: WHEN FND_API.G_EXC_ERROR THEN

221:
222: FND_MSG_PUB.Add;
223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
224:
225: WHEN FND_API.G_EXC_ERROR THEN
226: ROLLBACK TO IEM_DecryptPassword_PVT;
227: x_return_status := FND_API.G_RET_STS_ERROR ;
228: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
229: p_data => x_msg_data );

Line 227: x_return_status := FND_API.G_RET_STS_ERROR ;

223: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
224:
225: WHEN FND_API.G_EXC_ERROR THEN
226: ROLLBACK TO IEM_DecryptPassword_PVT;
227: x_return_status := FND_API.G_RET_STS_ERROR ;
228: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
229: p_data => x_msg_data );
230:
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

227: x_return_status := FND_API.G_RET_STS_ERROR ;
228: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
229: p_data => x_msg_data );
230:
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO IEM_DecryptPassword_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
235: p_data => x_msg_data );

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

229: p_data => x_msg_data );
230:
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO IEM_DecryptPassword_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
235: p_data => x_msg_data );
236:
237: WHEN OTHERS THEN

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236:
237: WHEN OTHERS THEN
238:
239: ROLLBACK TO IEM_DecryptPassword_PVT;
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.Check_Msg_Level
242: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
243: THEN
244: FND_MSG_PUB.Add_Exc_Msg