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

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

41: -- Version Initial version number = 1.0
42: -- History Current version number = 1.0
43: --=======================================================
44: procedure DOWNLOAD_AMPARAM_REGISTRY (
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_api_version_number IN NUMBER,
47: p_init_msg_tbl IN BOOLEAN := FALSE,
48: p_msg_count OUT NOCOPY NUMBER,
49: p_msg_data OUT NOCOPY VARCHAR2,

Line 51: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,

47: p_init_msg_tbl IN BOOLEAN := FALSE,
48: p_msg_count OUT NOCOPY NUMBER,
49: p_msg_data OUT NOCOPY VARCHAR2,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_amparamreg_pk_tbl IN AK_AMPARAM_REGISTRY_PUB.AmParamReg_Pk_Tbl_Type :=
55: AK_AMPARAM_REGISTRY_PUB.G_MISS_AMPARAMREG_PK_TBL

Line 52: p_application_id IN NUMBER := FND_API.G_MISS_NUM,

48: p_msg_count OUT NOCOPY NUMBER,
49: p_msg_data OUT NOCOPY VARCHAR2,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_amparamreg_pk_tbl IN AK_AMPARAM_REGISTRY_PUB.AmParamReg_Pk_Tbl_Type :=
55: AK_AMPARAM_REGISTRY_PUB.G_MISS_AMPARAMREG_PK_TBL
56: ) is

Line 53: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

49: p_msg_data OUT NOCOPY VARCHAR2,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
54: p_amparamreg_pk_tbl IN AK_AMPARAM_REGISTRY_PUB.AmParamReg_Pk_Tbl_Type :=
55: AK_AMPARAM_REGISTRY_PUB.G_MISS_AMPARAMREG_PK_TBL
56: ) is
57: l_api_version_number CONSTANT number := 1.0;

Line 68: IF NOT FND_API.Compatible_API_Call (

64: begin
65: --
66: -- Check verion number
67: --
68: IF NOT FND_API.Compatible_API_Call (
69: l_api_version_number, p_api_version_number, l_api_name,
70: G_PKG_NAME) then
71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: return;

Line 71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

67: --
68: IF NOT FND_API.Compatible_API_Call (
69: l_api_version_number, p_api_version_number, l_api_name,
70: G_PKG_NAME) then
71: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: return;
73: END IF;
74:
75: -- Initialize the message table if requested.

Line 108: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

104:
105: --
106: -- If API call returns with an error status...
107: --
108: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
109: (l_return_status = FND_API.G_RET_STS_ERROR) then
110: RAISE FND_API.G_EXC_ERROR;
111: end if;
112:

Line 109: (l_return_status = FND_API.G_RET_STS_ERROR) then

105: --
106: -- If API call returns with an error status...
107: --
108: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
109: (l_return_status = FND_API.G_RET_STS_ERROR) then
110: RAISE FND_API.G_EXC_ERROR;
111: end if;
112:
113: --

Line 110: RAISE FND_API.G_EXC_ERROR;

106: -- If API call returns with an error status...
107: --
108: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
109: (l_return_status = FND_API.G_RET_STS_ERROR) then
110: RAISE FND_API.G_EXC_ERROR;
111: end if;
112:
113: --
114: -- - call the download procedure for attributes to retrieve the

Line 133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

129: --
130: -- If download call returns with an error status or
131: -- download failed to retrieve any information from the database..
132: --
133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:

Line 134: (l_return_status = FND_API.G_RET_STS_ERROR) then

130: -- If download call returns with an error status or
131: -- download failed to retrieve any information from the database..
132: --
133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:
138: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 135: RAISE FND_API.G_EXC_ERROR;

131: -- download failed to retrieve any information from the database..
132: --
133: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:
138: p_return_status := FND_API.G_RET_STS_SUCCESS;
139:

Line 138: p_return_status := FND_API.G_RET_STS_SUCCESS;

134: (l_return_status = FND_API.G_RET_STS_ERROR) then
135: RAISE FND_API.G_EXC_ERROR;
136: end if;
137:
138: p_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: FND_MSG_PUB.Count_And_Get (
141: p_count => p_msg_count,
142: p_data => p_msg_data);

Line 145: WHEN FND_API.G_EXC_ERROR THEN

141: p_count => p_msg_count,
142: p_data => p_msg_data);
143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_ERROR THEN
146: p_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get (
148: p_count => p_msg_count,
149: p_data => p_msg_data);

Line 146: p_return_status := FND_API.G_RET_STS_ERROR;

142: p_data => p_msg_data);
143:
144: EXCEPTION
145: WHEN FND_API.G_EXC_ERROR THEN
146: p_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get (
148: p_count => p_msg_count,
149: p_data => p_msg_data);
150: WHEN OTHERS THEN

Line 151: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: FND_MSG_PUB.Count_And_Get (
148: p_count => p_msg_count,
149: p_data => p_msg_data);
150: WHEN OTHERS THEN
151: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
153: SUBSTR (SQLERRM, 1, 240) );
154: FND_MSG_PUB.Add;
155: FND_MSG_PUB.Count_And_Get (

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

176: -- Version Initial version number = 1.0
177: -- History Current version number = 1.0
178: --=======================================================
179: procedure CREATE_AMPARAM_REGISTRY (
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_api_version_number IN NUMBER,
182: p_init_msg_tbl IN BOOLEAN := FALSE,
183: p_msg_count OUT NOCOPY NUMBER,
184: p_msg_data OUT NOCOPY VARCHAR2,

Line 196: IF NOT FND_API.Compatible_API_Call (

192: l_api_name CONSTANT varchar2(30) := 'Create_amparam_registry';
193: l_return_status VARCHAR2(1);
194: begin
195: /* Check API version number */
196: IF NOT FND_API.Compatible_API_Call (
197: l_api_version_number, p_api_version_number, l_api_name,
198: G_PKG_NAME) then
199: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: return;

Line 199: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: /* Check API version number */
196: IF NOT FND_API.Compatible_API_Call (
197: l_api_version_number, p_api_version_number, l_api_name,
198: G_PKG_NAME) then
199: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: return;
201: END IF;
202:
203: -- Initialize the message table if requested.

Line 229: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or

225:
226: --
227: -- If API call returns with an error status...
228: --
229: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
230: (l_return_status = FND_API.G_RET_STS_ERROR) then
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:

Line 230: (l_return_status = FND_API.G_RET_STS_ERROR) then

226: --
227: -- If API call returns with an error status...
228: --
229: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
230: (l_return_status = FND_API.G_RET_STS_ERROR) then
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 231: RAISE FND_API.G_EXC_ERROR;

227: -- If API call returns with an error status...
228: --
229: if (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) or
230: (l_return_status = FND_API.G_RET_STS_ERROR) then
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:

Line 234: p_return_status := FND_API.G_RET_STS_SUCCESS;

230: (l_return_status = FND_API.G_RET_STS_ERROR) then
231: RAISE FND_API.G_EXC_ERROR;
232: end if;
233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233:
234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;
239: rollback to start_create_amparam_registry;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 238: p_return_status := FND_API.G_RET_STS_ERROR;

234: p_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;
239: rollback to start_create_amparam_registry;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: WHEN FND_API.G_EXC_ERROR THEN
238: p_return_status := FND_API.G_RET_STS_ERROR;
239: rollback to start_create_amparam_registry;
240: WHEN OTHERS THEN
241: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
243: SUBSTR (SQLERRM, 1, 240) );
244: FND_MSG_PUB.Add;
245: rollback to start_create_amparam_registry;