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

Line 24: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,

20: G_PKG_NAME CONSTANT VARCHAR2(30) :='WIP_EAM_WORKREQUEST_PUB';
21: procedure work_request_import
22: (
23: p_api_version in NUMBER := 1.0,
24: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
25: p_commit in VARCHAR2 := FND_API.G_TRUE,
26: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_mode in VARCHAR2,
28: p_work_request_rec in WIP_EAM_WORK_REQUESTS%ROWTYPE,

Line 25: p_commit in VARCHAR2 := FND_API.G_TRUE,

21: procedure work_request_import
22: (
23: p_api_version in NUMBER := 1.0,
24: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
25: p_commit in VARCHAR2 := FND_API.G_TRUE,
26: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_mode in VARCHAR2,
28: p_work_request_rec in WIP_EAM_WORK_REQUESTS%ROWTYPE,
29: p_request_log in VARCHAR2,

Line 26: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,

22: (
23: p_api_version in NUMBER := 1.0,
24: p_init_msg_list in VARCHAR2 := FND_API.G_FALSE,
25: p_commit in VARCHAR2 := FND_API.G_TRUE,
26: p_validation_level in NUMBER := FND_API.G_VALID_LEVEL_FULL,
27: p_mode in VARCHAR2,
28: p_work_request_rec in WIP_EAM_WORK_REQUESTS%ROWTYPE,
29: p_request_log in VARCHAR2,
30: p_user_id in NUMBER,

Line 60: IF NOT fnd_api.compatible_api_call(

56:
57: l_stmt_num := 10;
58:
59: -- Standard call to check for call compatibility.
60: IF NOT fnd_api.compatible_api_call(
61: l_api_version
62: ,p_api_version
63: ,l_api_name
64: ,g_pkg_name) THEN

Line 65: RAISE fnd_api.g_exc_unexpected_error;

61: l_api_version
62: ,p_api_version
63: ,l_api_name
64: ,g_pkg_name) THEN
65: RAISE fnd_api.g_exc_unexpected_error;
66: END IF;
67:
68: l_stmt_num := 20;
69:

Line 71: IF fnd_api.to_boolean(p_init_msg_list) THEN

67:
68: l_stmt_num := 20;
69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF fnd_api.to_boolean(p_init_msg_list) THEN
72: fnd_msg_pub.initialize;
73: END IF;
74:
75: l_stmt_num := 30;

Line 78: x_return_status := fnd_api.g_ret_sts_success;

74:
75: l_stmt_num := 30;
76:
77: -- Initialize API return status to success
78: x_return_status := fnd_api.g_ret_sts_success;
79:
80: -- call validate api
81: WIP_EAM_WORKREQUEST_PVT.validate_work_request (
82: p_api_version => p_api_version,

Line 277: RAISE FND_API.g_exc_error;

273: END IF;
274:
275: -- raise an error flag if any of the called procedures fails
276: IF l_return_status = 'E' THEN
277: RAISE FND_API.g_exc_error;
278: ELSIF l_return_status = 'U' THEN
279: RAISE FND_API.g_exc_unexpected_error;
280: END IF;
281:

Line 279: RAISE FND_API.g_exc_unexpected_error;

275: -- raise an error flag if any of the called procedures fails
276: IF l_return_status = 'E' THEN
277: RAISE FND_API.g_exc_error;
278: ELSIF l_return_status = 'U' THEN
279: RAISE FND_API.g_exc_unexpected_error;
280: END IF;
281:
282: IF fnd_api.to_boolean(p_commit) THEN
283: COMMIT WORK;

Line 282: IF fnd_api.to_boolean(p_commit) THEN

278: ELSIF l_return_status = 'U' THEN
279: RAISE FND_API.g_exc_unexpected_error;
280: END IF;
281:
282: IF fnd_api.to_boolean(p_commit) THEN
283: COMMIT WORK;
284: END IF;
285:
286: EXCEPTION

Line 287: WHEN fnd_api.g_exc_error THEN

283: COMMIT WORK;
284: END IF;
285:
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO work_request_import_pvt;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(
291: p_encoded => fnd_api.g_false

Line 289: x_return_status := fnd_api.g_ret_sts_error;

285:
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO work_request_import_pvt;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(
291: p_encoded => fnd_api.g_false
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);

Line 291: p_encoded => fnd_api.g_false

287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO work_request_import_pvt;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(
291: p_encoded => fnd_api.g_false
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: ROLLBACK TO work_request_import_pvt;

Line 294: WHEN fnd_api.g_exc_unexpected_error THEN

290: fnd_msg_pub.count_and_get(
291: p_encoded => fnd_api.g_false
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: ROLLBACK TO work_request_import_pvt;
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_msg_pub.count_and_get(
298: p_encoded => fnd_api.g_false

Line 296: x_return_status := fnd_api.g_ret_sts_unexp_error;

292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN fnd_api.g_exc_unexpected_error THEN
295: ROLLBACK TO work_request_import_pvt;
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_msg_pub.count_and_get(
298: p_encoded => fnd_api.g_false
299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);

Line 298: p_encoded => fnd_api.g_false

294: WHEN fnd_api.g_exc_unexpected_error THEN
295: ROLLBACK TO work_request_import_pvt;
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_msg_pub.count_and_get(
298: p_encoded => fnd_api.g_false
299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301: WHEN OTHERS THEN
302: ROLLBACK TO work_request_import_pvt;

Line 303: x_return_status := fnd_api.g_ret_sts_unexp_error;

299: ,p_count => x_msg_count
300: ,p_data => x_msg_data);
301: WHEN OTHERS THEN
302: ROLLBACK TO work_request_import_pvt;
303: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: IF fnd_msg_pub.check_msg_level(
305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
307: END IF;

Line 309: p_encoded => fnd_api.g_false

305: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
307: END IF;
308: fnd_msg_pub.count_and_get(
309: p_encoded => fnd_api.g_false
310: ,p_count => x_msg_count
311: ,p_data => x_msg_data);
312:
313: end work_request_import;