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

Line 152: RAISE FND_API.G_EXC_ERROR;

148: IF (p_x_pc_header_rec.PRODUCT_TYPE_DESC) IS NULL
149: THEN
150: FND_MESSAGE.SET_NAME('AHL','AHL_PC_PRODUCT_TYPE_REQD');
151: FND_MSG_PUB.ADD;
152: RAISE FND_API.G_EXC_ERROR;
153: ELSE
154: OPEN get_item_type_code (p_x_pc_header_rec.PRODUCT_TYPE_DESC);
155: FETCH get_item_type_code INTO l_item_type_code, l_item_type_desc;
156: -- No such Item Type found for passed Item Type Desc, then ERROR

Line 162: RAISE FND_API.G_EXC_ERROR;

158: THEN
159: FND_MESSAGE.SET_NAME('AHL','AHL_PC_PRODUCT_TYPE_NOT_FOUND');
160: FND_MSG_PUB.ADD;
161: CLOSE get_item_type_code;
162: RAISE FND_API.G_EXC_ERROR;
163: ELSE
164: FETCH get_item_type_code INTO l_dummy_code, l_dummy_desc;
165: -- Multiple matches for Item Type Desc
166: IF get_item_type_code%FOUND

Line 177: RAISE FND_API.G_EXC_ERROR;

173: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DUP_PROD_CODE_FOR_DESC');
174: FND_MSG_PUB.ADD;
175: CLOSE check_item_type_desc_and_code;
176: CLOSE get_item_type_code;
177: RAISE FND_API.G_EXC_ERROR;
178: ELSE
179: IF ( p_x_pc_header_rec.PRODUCT_TYPE_CODE) IS NULL
180: THEN
181: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DUP_PROD_CODE_FOR_DESC');

Line 185: RAISE FND_API.G_EXC_ERROR;

181: FND_MESSAGE.SET_NAME('AHL','AHL_PC_DUP_PROD_CODE_FOR_DESC');
182: FND_MSG_PUB.ADD;
183: CLOSE check_item_type_desc_and_code;
184: CLOSE get_item_type_code;
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: END IF;
188: ELSE
189: p_x_pc_header_rec.PRODUCT_TYPE_CODE := l_item_type_code;

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

198: -- PROCESS_PC_HEADER --
199: -------------------------
200: PROCEDURE PROCESS_PC_HEADER (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_module_type IN VARCHAR2 := NULL,
206: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,

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

199: -------------------------
200: PROCEDURE PROCESS_PC_HEADER (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_module_type IN VARCHAR2 := NULL,
206: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
207: x_return_status OUT NOCOPY VARCHAR2,

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

200: PROCEDURE PROCESS_PC_HEADER (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_module_type IN VARCHAR2 := NULL,
206: p_x_pc_header_rec IN OUT NOCOPY AHL_PC_HEADER_PUB.PC_HEADER_REC,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,

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

219: -- Standard start of API savepoint
220: SAVEPOINT PROCESS_PC_HEADER_PUB;
221:
222: -- Standard call to check for call compatibility
223: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
224: THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END IF;
227:

Line 225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

221:
222: -- Standard call to check for call compatibility
223: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
224: THEN
225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END IF;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE
229: IF FND_API.To_Boolean(p_init_msg_list)

Line 229: IF FND_API.To_Boolean(p_init_msg_list)

225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
226: END IF;
227:
228: -- Initialize message list if p_init_msg_list is set to TRUE
229: IF FND_API.To_Boolean(p_init_msg_list)
230: THEN
231: FND_MSG_PUB.Initialize;
232: END IF;
233:

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

230: THEN
231: FND_MSG_PUB.Initialize;
232: END IF;
233:
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235:
236: IF G_DEBUG='Y' THEN
237: AHL_DEBUG_PUB.ENABLE_DEBUG;
238: END IF;

Line 262: RAISE FND_API.G_EXC_ERROR;

258: -- Check Error Message stack.
259: x_msg_count := FND_MSG_PUB.count_msg;
260: IF x_msg_count > 0
261: THEN
262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265: -- Call PVT APIs
266: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265: -- Call PVT APIs
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: IF (p_x_pc_header_rec.operation_flag = AHL_PC_HEADER_PVT.G_DML_CREATE)
269: THEN
270: IF G_DEBUG='Y' THEN

Line 277: p_init_msg_list => FND_API.G_FALSE,

273:
274: AHL_PC_HEADER_PVT.CREATE_PC_HEADER
275: (
276: p_api_version => 1.0,
277: p_init_msg_list => FND_API.G_FALSE,
278: p_commit => FND_API.G_FALSE,
279: p_validation_level => p_validation_level,
280: p_x_pc_header_rec => p_x_pc_header_rec,
281: x_return_status => x_return_status,

Line 278: p_commit => FND_API.G_FALSE,

274: AHL_PC_HEADER_PVT.CREATE_PC_HEADER
275: (
276: p_api_version => 1.0,
277: p_init_msg_list => FND_API.G_FALSE,
278: p_commit => FND_API.G_FALSE,
279: p_validation_level => p_validation_level,
280: p_x_pc_header_rec => p_x_pc_header_rec,
281: x_return_status => x_return_status,
282: x_msg_count => x_msg_count,

Line 294: p_init_msg_list => FND_API.G_FALSE,

290:
291: AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
292: (
293: p_api_version => 1.0,
294: p_init_msg_list => FND_API.G_FALSE,
295: p_commit => FND_API.G_FALSE,
296: p_validation_level => p_validation_level,
297: p_x_pc_header_rec => p_x_pc_header_rec,
298: x_return_status => x_return_status,

Line 295: p_commit => FND_API.G_FALSE,

291: AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
292: (
293: p_api_version => 1.0,
294: p_init_msg_list => FND_API.G_FALSE,
295: p_commit => FND_API.G_FALSE,
296: p_validation_level => p_validation_level,
297: p_x_pc_header_rec => p_x_pc_header_rec,
298: x_return_status => x_return_status,
299: x_msg_count => x_msg_count,

Line 311: p_init_msg_list => FND_API.G_FALSE,

307:
308: AHL_PC_HEADER_PVT.COPY_PC_HEADER
309: (
310: p_api_version => 1.0,
311: p_init_msg_list => FND_API.G_FALSE,
312: p_commit => FND_API.G_FALSE,
313: p_validation_level => p_validation_level,
314: p_x_pc_header_rec => p_x_pc_header_rec,
315: x_return_status => x_return_status,

Line 312: p_commit => FND_API.G_FALSE,

308: AHL_PC_HEADER_PVT.COPY_PC_HEADER
309: (
310: p_api_version => 1.0,
311: p_init_msg_list => FND_API.G_FALSE,
312: p_commit => FND_API.G_FALSE,
313: p_validation_level => p_validation_level,
314: p_x_pc_header_rec => p_x_pc_header_rec,
315: x_return_status => x_return_status,
316: x_msg_count => x_msg_count,

Line 328: p_init_msg_list => FND_API.G_FALSE,

324:
325: AHL_PC_HEADER_PVT.DELETE_PC_HEADER
326: (
327: p_api_version => 1.0,
328: p_init_msg_list => FND_API.G_FALSE,
329: p_commit => FND_API.G_FALSE,
330: p_validation_level => p_validation_level,
331: p_x_pc_header_rec => p_x_pc_header_rec,
332: x_return_status => x_return_status,

Line 329: p_commit => FND_API.G_FALSE,

325: AHL_PC_HEADER_PVT.DELETE_PC_HEADER
326: (
327: p_api_version => 1.0,
328: p_init_msg_list => FND_API.G_FALSE,
329: p_commit => FND_API.G_FALSE,
330: p_validation_level => p_validation_level,
331: p_x_pc_header_rec => p_x_pc_header_rec,
332: x_return_status => x_return_status,
333: x_msg_count => x_msg_count,

Line 342: RAISE FND_API.G_EXC_ERROR;

338: -- Check Error Message stack.
339: x_msg_count := FND_MSG_PUB.count_msg;
340: IF x_msg_count > 0
341: THEN
342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: -- Standard check for p_commit
346: IF FND_API.To_Boolean (p_commit)

Line 346: IF FND_API.To_Boolean (p_commit)

342: RAISE FND_API.G_EXC_ERROR;
343: END IF;
344:
345: -- Standard check for p_commit
346: IF FND_API.To_Boolean (p_commit)
347: THEN
348: COMMIT WORK;
349: END IF;
350:

Line 354: p_encoded => fnd_api.g_false );

350:
351: -- Standard call to get message count and if count is 1, get message info
352: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
353: p_data => x_msg_data,
354: p_encoded => fnd_api.g_false );
355:
356: EXCEPTION
357: WHEN FND_API.G_EXC_ERROR THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;

Line 357: WHEN FND_API.G_EXC_ERROR THEN

353: p_data => x_msg_data,
354: p_encoded => fnd_api.g_false );
355:
356: EXCEPTION
357: WHEN FND_API.G_EXC_ERROR THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: Rollback to PROCESS_PC_HEADER_PUB;
360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
361: p_data => x_msg_data,

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: p_encoded => fnd_api.g_false );
355:
356: EXCEPTION
357: WHEN FND_API.G_EXC_ERROR THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: Rollback to PROCESS_PC_HEADER_PUB;
360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
361: p_data => x_msg_data,
362: p_encoded => fnd_api.g_false );

Line 362: p_encoded => fnd_api.g_false );

358: x_return_status := FND_API.G_RET_STS_ERROR;
359: Rollback to PROCESS_PC_HEADER_PUB;
360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
361: p_data => x_msg_data,
362: p_encoded => fnd_api.g_false );
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: Rollback to PROCESS_PC_HEADER_PUB;

Line 364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

360: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
361: p_data => x_msg_data,
362: p_encoded => fnd_api.g_false );
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: Rollback to PROCESS_PC_HEADER_PUB;
367: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
368: p_data => x_msg_data,

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: p_data => x_msg_data,
362: p_encoded => fnd_api.g_false );
363:
364: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: Rollback to PROCESS_PC_HEADER_PUB;
367: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => fnd_api.g_false );

Line 369: p_encoded => fnd_api.g_false );

365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: Rollback to PROCESS_PC_HEADER_PUB;
367: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => fnd_api.g_false );
370:
371: WHEN OTHERS THEN
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: Rollback to PROCESS_PC_HEADER_PUB;

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

368: p_data => x_msg_data,
369: p_encoded => fnd_api.g_false );
370:
371: WHEN OTHERS THEN
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: Rollback to PROCESS_PC_HEADER_PUB;
374: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
375: THEN
376: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

Line 382: p_encoded => fnd_api.g_false );

378: p_error_text => SUBSTR(SQLERRM,1,240) );
379: END IF;
380: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
381: p_data => x_msg_data,
382: p_encoded => fnd_api.g_false );
383:
384: END PROCESS_PC_HEADER ;
385:
386: END AHL_PC_HEADER_PUB;