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

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

12:
13: -- The following lines define true, false and product constants
14:
15:
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_OKC CONSTANT VARCHAR2(3) := 'OKC';
19:
20: --

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

13: -- The following lines define true, false and product constants
14:
15:
16: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
17: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
18: G_OKC CONSTANT VARCHAR2(3) := 'OKC';
19:
20: --
21: -- The following lines define The return status from the procedure

Line 25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

21: -- The following lines define The return status from the procedure
22: -- The procedure must return on of these statuses in X_RETURN_STATUS
23: --
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

22: -- The procedure must return on of these statuses in X_RETURN_STATUS
23: --
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

23: --
24:
25: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
26: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
27: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
28:
29: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
30: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
31: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 130: WHEN FND_API.G_EXC_ERROR THEN

126: -- DO NOT delete debug statements.
127: -- Add more debug statements if required. Follow the same structure for debug statements
128:
129:
130: WHEN FND_API.G_EXC_ERROR THEN
131: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
133: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
134: END IF;

Line 149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

145: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
146: p_count => x_msg_count,
147: p_data => x_msg_data );
148:
149: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
150: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
151: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
152: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
153: END IF;

Line 244: WHEN FND_API.G_EXC_ERROR THEN

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

Line 260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

256: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
257: p_count => x_msg_count,
258: p_data => x_msg_data );
259:
260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
261: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
263: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
264: END IF;

Line 399: WHEN FND_API.G_EXC_ERROR THEN

395: END IF;
396:
397: EXCEPTION
398:
399: WHEN FND_API.G_EXC_ERROR THEN
400: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
401: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
402: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
403: END IF;

Line 411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

407: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
408: p_count => x_msg_count,
409: p_data => x_msg_data );
410:
411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
412: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
413: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
414: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
415: END IF;

Line 488: WHEN FND_API.G_EXC_ERROR THEN

484: END IF;
485:
486: EXCEPTION
487:
488: WHEN FND_API.G_EXC_ERROR THEN
489: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
491: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
492: END IF;

Line 504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

500: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
501: p_count => x_msg_count,
502: p_data => x_msg_data );
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
507: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
508: END IF;

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: END IF;
597:
598: EXCEPTION
599:
600: WHEN FND_API.G_EXC_ERROR THEN
601: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
603: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
604: END IF;

Line 620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

616: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
617: p_count => x_msg_count,
618: p_data => x_msg_data );
619:
620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
621: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
622: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
623: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
624: END IF;

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: END IF;
716:
717: EXCEPTION
718:
719: WHEN FND_API.G_EXC_ERROR THEN
720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
722: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
723: END IF;

Line 735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

731: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
732: p_count => x_msg_count,
733: p_data => x_msg_data );
734:
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
738: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
739: END IF;

Line 818: WHEN FND_API.G_EXC_ERROR THEN

814: END IF;
815:
816: EXCEPTION
817:
818: WHEN FND_API.G_EXC_ERROR THEN
819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
820: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
821: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
822: END IF;

Line 834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

830: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
831: p_count => x_msg_count,
832: p_data => x_msg_data );
833:
834: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
835: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
836: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
837: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
838: END IF;

Line 919: WHEN FND_API.G_EXC_ERROR THEN

915: END IF;
916:
917: EXCEPTION
918:
919: WHEN FND_API.G_EXC_ERROR THEN
920: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
921: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
922: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
923: END IF;

Line 935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

931: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
932: p_count => x_msg_count,
933: p_data => x_msg_data );
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
937: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
938: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
939: END IF;

Line 1018: WHEN FND_API.G_EXC_ERROR THEN

1014: END IF;
1015:
1016: EXCEPTION
1017:
1018: WHEN FND_API.G_EXC_ERROR THEN
1019: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1020: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1021: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1022: END IF;

Line 1034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1030: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
1031: p_count => x_msg_count,
1032: p_data => x_msg_data );
1033:
1034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1035: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1036: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1037: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1038: END IF;

Line 1129: WHEN FND_API.G_EXC_ERROR THEN

1125: END IF;
1126:
1127: EXCEPTION
1128:
1129: WHEN FND_API.G_EXC_ERROR THEN
1130: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1132: '1001: Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1133: END IF;

Line 1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1141: FND_MSG_PUB.Count_And_Get(p_encoded =>'F',
1142: p_count => x_msg_count,
1143: p_data => x_msg_data );
1144:
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1148: '1002: Unexpected Error: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1149: END IF;