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_XPRT_TMPL_RULE_ASSNS_PVT dependencies on FND_API

Line 15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

11: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
12: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
13: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

12: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
13: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17:
18: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
20: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

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

101: '100: p_target_template_id : '||p_target_template_id);
102: END IF;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

102: END IF;
103:
104: -- Standard call to check for call compatibility.
105: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: IF FND_API.to_Boolean( p_init_msg_list ) THEN
110: FND_MSG_PUB.initialize;

Line 109: IF FND_API.to_Boolean( p_init_msg_list ) THEN

105: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
107: END IF;
108:
109: IF FND_API.to_Boolean( p_init_msg_list ) THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112:
113: x_return_status := G_RET_STS_SUCCESS;

Line 230: IF FND_API.To_Boolean( p_commit ) THEN

226: END IF; -- l_source_template_org_id = l_target_template_org_id
227:
228:
229:
230: IF FND_API.To_Boolean( p_commit ) THEN
231: COMMIT WORK;
232: END IF;
233:
234: -- Standard call to get message count and if count is 1, get message info.

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
242: END IF;
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
249: G_MODULE||l_api_name,

Line 256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

252:
253: x_return_status := G_RET_STS_ERROR;
254: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
255:
256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
257:
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,

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

309: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
310: END IF;
311:
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: END IF;
311:
312: -- Standard call to check for call compatibility.
313: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;

Line 317: IF FND_API.to_Boolean( p_init_msg_list ) THEN

313: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: IF FND_API.to_Boolean( p_init_msg_list ) THEN
318: FND_MSG_PUB.initialize;
319: END IF;
320: x_return_status := G_RET_STS_SUCCESS;
321:

Line 332: IF FND_API.To_Boolean( p_commit ) THEN

328: WHERE template_id = p_template_id;
329:
330:
331:
332: IF FND_API.To_Boolean( p_commit ) THEN
333: COMMIT WORK;
334: END IF;
335:
336: -- Standard call to get message count and if count is 1, get message info.

Line 347: WHEN FND_API.G_EXC_ERROR THEN

343: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
344: END IF;
345:
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348:
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
351: G_MODULE||l_api_name,

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354:
355: x_return_status := G_RET_STS_ERROR;
356: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
357:
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359:
360: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
362: G_MODULE||l_api_name,

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

417: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
418: END IF;
419:
420: -- Standard call to check for call compatibility.
421: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424:
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

418: END IF;
419:
420: -- Standard call to check for call compatibility.
421: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424:
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
426: FND_MSG_PUB.initialize;

Line 425: IF FND_API.to_Boolean( p_init_msg_list ) THEN

421: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
423: END IF;
424:
425: IF FND_API.to_Boolean( p_init_msg_list ) THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: x_return_status := G_RET_STS_SUCCESS;

Line 476: IF FND_API.To_Boolean( p_commit ) THEN

472: WHERE template_id = p_template_id;
473:
474: END IF;
475:
476: IF FND_API.To_Boolean( p_commit ) THEN
477: COMMIT WORK;
478: END IF;
479:
480: -- Standard call to get message count and if count is 1, get message info.

Line 491: WHEN FND_API.G_EXC_ERROR THEN

487: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
488: END IF;
489:
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492:
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,

Line 502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

498:
499: x_return_status := G_RET_STS_ERROR;
500: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503:
504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
506: G_MODULE||l_api_name,