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

Line 50: -- Default = FND_API.G_FALSE

46: --Pre-reqs : None.
47: --Parameters :
48: --IN : p_api_version IN NUMBER Required
49: -- : p_init_msg_list IN VARCHAR2 Optional
50: -- Default = FND_API.G_FALSE
51: --OUT : x_return_status OUT VARCHAR2(1)
52: -- : x_msg_count OUT NUMBER
53: -- : x_msg_data OUT VARCHAR2(2000)
54: --Note :

Line 67: x_return_status := FND_API.G_RET_STS_ERROR;

63: IS
64: l_api_version NUMBER;
65: l_api_name VARCHAR2(32);
66: BEGIN
67: x_return_status := FND_API.G_RET_STS_ERROR;
68:
69: l_api_name := 'update_text_index';
70: l_api_version := 1.0;
71:

Line 80: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

76: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.update_text_index');
77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: END IF;
78:
79: -- Standard call to check for call compatibility.
80: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;

Line 84: IF FND_API.to_Boolean( p_init_msg_list ) THEN

80: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87:
88: ad_ctx_ddl.set_effective_schema(G_APP_NAME);

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89:
90: ad_ctx_ddl.sync_index(G_CONTRACTS_ALL_INDEX);
91: ad_ctx_ddl.sync_index(G_CONTRACT_VERS_INDEX);
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(
97: FND_LOG.LEVEL_PROCEDURE,

Line 116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

112: p_token1 => G_SQLCODE_TOKEN,
113: p_token1_value => SQLCODE,
114: p_token2 => G_SQLERRM_TOKEN,
115: p_token2_value => SQLERRM);
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: FND_MSG_PUB.Count_And_Get(
118: p_count => x_msg_count,
119: p_data => x_msg_data
120: );

Line 131: -- Default = FND_API.G_FALSE

127: --Pre-reqs : None.
128: --Parameters :
129: --IN : p_api_version IN NUMBER Required
130: -- : p_init_msg_list IN VARCHAR2 Optional
131: -- Default = FND_API.G_FALSE
132: --OUT : x_return_status OUT VARCHAR2(1)
133: -- : x_msg_count OUT NUMBER
134: -- : x_msg_data OUT VARCHAR2(2000)
135: --Note :

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146: l_api_name VARCHAR2(32);
147: BEGIN
148: l_api_name := 'optimize_text_index';
149: l_api_version := 1.0;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
153: FND_LOG.STRING(
154: FND_LOG.LEVEL_PROCEDURE,

Line 160: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

156: 'Entering OKC_REP_CONTRACT_SEARCH_PVT.optimize_text_index');
157: END IF;
158:
159: -- Standard call to check for call compatibility.
160: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

157: END IF;
158:
159: -- Standard call to check for call compatibility.
160: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;

Line 164: IF FND_API.to_Boolean( p_init_msg_list ) THEN

160: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
162: END IF;
163: -- Initialize message list if p_init_msg_list is set to TRUE.
164: IF FND_API.to_Boolean( p_init_msg_list ) THEN
165: FND_MSG_PUB.initialize;
166: END IF;
167:
168: ad_ctx_ddl.set_effective_schema(G_APP_NAME);

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: optlevel => ad_ctx_ddl.OPTLEVEL_FULL,
178: maxtime => ad_ctx_ddl.MAXTIME_UNLIMITED
179: );
180:
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182:
183: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(
185: FND_LOG.LEVEL_PROCEDURE,

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: p_token1 => G_SQLCODE_TOKEN,
201: p_token1_value => SQLCODE,
202: p_token2 => G_SQLERRM_TOKEN,
203: p_token2_value => SQLERRM);
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.Count_And_Get(
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );

Line 246: l_init_msg_list := FND_API.G_FALSE;

242: END IF;
243:
244: l_api_name := 'update_text_index_ctx';
245: l_api_version := 1.0;
246: l_init_msg_list := FND_API.G_FALSE;
247:
248: update_text_index(
249: p_api_version => l_api_version,
250: p_init_msg_list => l_init_msg_list,

Line 256: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

252: x_msg_count => l_msg_count,
253: x_return_status => l_return_status
254: );
255:
256: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
257: retcode := G_RETURN_CODE_SUCCESS;
258: END IF;
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 313: l_init_msg_list := FND_API.G_FALSE;

309: retcode := G_RETURN_CODE_ERROR;
310:
311: l_api_name := 'optimize_text_index_ctx';
312: l_api_version := 1.0;
313: l_init_msg_list := FND_API.G_FALSE;
314:
315: optimize_text_index(
316: p_api_version => l_api_version,
317: p_init_msg_list => l_init_msg_list,

Line 323: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

319: x_msg_count => l_msg_count,
320: x_return_status => l_return_status
321: );
322:
323: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
324: retcode := G_RETURN_CODE_SUCCESS;
325: END IF;
326:
327: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN