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

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

9: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PROCEDURE Query_SearchURL (p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: x_return_status OUT VARCHAR2,
17: x_msg_count OUT NUMBER,

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

10: G_REQUEST_ID NUMBER := FND_GLOBAL.Conc_Request_Id;
11:
12: PROCEDURE Query_SearchURL (p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: x_return_status OUT VARCHAR2,
17: x_msg_count OUT NUMBER,
18: x_msg_data OUT VARCHAR2,

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

11:
12: PROCEDURE Query_SearchURL (p_api_version IN NUMBER := 1.0,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
16: x_return_status OUT VARCHAR2,
17: x_msg_count OUT NUMBER,
18: x_msg_data OUT VARCHAR2,
19: p_search_id IN NUMBER, -- add by jypark 12/27/2000 for new requirement

Line 84: IF NOT FND_API.Compatible_API_Call (l_api_version,

80: -- Standard begin of API savepoint
81: SAVEPOINT Query_SearchURL_PVT;
82:
83: -- Standard call to check for call compatibility.
84: IF NOT FND_API.Compatible_API_Call (l_api_version,
85: p_api_version,
86: l_api_name,
87: G_PKG_NAME) THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

84: IF NOT FND_API.Compatible_API_Call (l_api_version,
85: p_api_version,
86: l_api_name,
87: G_PKG_NAME) THEN
88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- Check p_init_msg_list
92: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 92: IF FND_API.to_Boolean( p_init_msg_list ) THEN

88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- Check p_init_msg_list
92: IF FND_API.to_Boolean( p_init_msg_list ) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Implementation of User Hooks

Line 122: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

118: p_city => l_city,
119: p_state => l_state,
120: p_zip => l_zip,
121: p_country => l_country);
122: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
123: RAISE FND_API.G_EXC_ERROR;
124: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;

Line 123: RAISE FND_API.G_EXC_ERROR;

119: p_state => l_state,
120: p_zip => l_zip,
121: p_country => l_country);
122: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
123: RAISE FND_API.G_EXC_ERROR;
124: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: END IF;

Line 124: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

120: p_zip => l_zip,
121: p_country => l_country);
122: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
123: RAISE FND_API.G_EXC_ERROR;
124: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: END IF;
128:

Line 125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

121: p_country => l_country);
122: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
123: RAISE FND_API.G_EXC_ERROR;
124: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127: END IF;
128:
129:

Line 143: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

139: p_city => l_city,
140: p_state => l_state,
141: p_zip => l_zip,
142: p_country => l_country);
143: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
144: RAISE FND_API.G_EXC_ERROR;
145: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;

Line 144: RAISE FND_API.G_EXC_ERROR;

140: p_state => l_state,
141: p_zip => l_zip,
142: p_country => l_country);
143: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
144: RAISE FND_API.G_EXC_ERROR;
145: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: END IF;

Line 145: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

141: p_zip => l_zip,
142: p_country => l_country);
143: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
144: RAISE FND_API.G_EXC_ERROR;
145: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: END IF;
149:

Line 146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

142: p_country => l_country);
143: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
144: RAISE FND_API.G_EXC_ERROR;
145: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
146: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
147: END IF;
148: END IF;
149:
150:

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: END IF;
149:
150:
151: -- Initialize API return status to success
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: -- beginning of API body
155:
156: --dbms_output.put_line('before first cursor');

Line 228: if (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

224: p_city => l_city,
225: p_state => l_state,
226: p_zip => l_zip,
227: p_country => l_country);
228: if (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;

Line 229: RAISE FND_API.G_EXC_ERROR;

225: p_state => l_state,
226: p_zip => l_zip,
227: p_country => l_country);
228: if (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:

Line 230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

226: p_zip => l_zip,
227: p_country => l_country);
228: if (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: END IF;

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: p_country => l_country);
228: if (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234: END IF;
235:

Line 249: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN

245: p_city => l_city,
246: p_state => l_state,
247: p_zip => l_zip,
248: p_country => l_country);
249: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;

Line 250: RAISE FND_API.G_EXC_ERROR;

246: p_state => l_state,
247: p_zip => l_zip,
248: p_country => l_country);
249: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254: END IF;

Line 251: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

247: p_zip => l_zip,
248: p_country => l_country);
249: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254: END IF;
255:

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

248: p_country => l_country);
249: IF (l_return_status = FND_API.G_RET_STS_ERROR ) THEN
250: RAISE FND_API.G_EXC_ERROR;
251: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
253: END IF;
254: END IF;
255:
256: -- Standard check of p_commit

Line 257: IF FND_API.To_Boolean(p_commit) THEN

253: END IF;
254: END IF;
255:
256: -- Standard check of p_commit
257: IF FND_API.To_Boolean(p_commit) THEN
258: COMMIT WORK;
259: END IF;
260:
261: -- Standard call to get message count and if count is 1, get message info

Line 266: WHEN FND_API.G_EXC_ERROR THEN

262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
263:
264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO Query_SearchURL_PVT;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:

Line 268: x_return_status := FND_API.G_RET_STS_ERROR;

264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO Query_SearchURL_PVT;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO Query_SearchURL_PVT;

Line 271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

267: ROLLBACK TO Query_SearchURL_PVT;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO Query_SearchURL_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:

Line 273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO Query_SearchURL_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:
276: WHEN OTHERS THEN
277: ROLLBACK TO Query_SearchURL_PVT;

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:
276: WHEN OTHERS THEN
277: ROLLBACK TO Query_SearchURL_PVT;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
281: END IF;
282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);