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

Line 7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_UPDATE_LOCATION_PUB';
4:
5: PROCEDURE update_resource
6: (P_API_VERSION IN NUMBER,
7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
10: P_LOCATION IN MDSYS.SDO_GEOMETRY ,
11: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,

Line 8: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

4:
5: PROCEDURE update_resource
6: (P_API_VERSION IN NUMBER,
7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
9: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
10: P_LOCATION IN MDSYS.SDO_GEOMETRY ,
11: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE,
12: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 34: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)

30: res_rec res_cur%rowtype;
31:
32: BEGIN
33: SAVEPOINT update_sp;
34: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
35: THEN
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:

Line 36: RAISE FND_API.G_EXC_ERROR;

32: BEGIN
33: SAVEPOINT update_sp;
34: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
35: THEN
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
40: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 40: IF FND_API.To_boolean(P_INIT_MSG_LIST)

36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
40: IF FND_API.To_boolean(P_INIT_MSG_LIST)
41: THEN
42: FND_MSG_PUB.Initialize;
43: END IF;
44:

Line 54: x_return_status := fnd_api.g_ret_sts_error;

50: if(p_resource_id is null)
51: then
52: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
53: fnd_msg_pub.add;
54: x_return_status := fnd_api.g_ret_sts_error;
55: RAISE fnd_api.g_exc_error;
56:
57: end if;
58:

Line 55: RAISE fnd_api.g_exc_error;

51: then
52: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
53: fnd_msg_pub.add;
54: x_return_status := fnd_api.g_ret_sts_error;
55: RAISE fnd_api.g_exc_error;
56:
57: end if;
58:
59: open res_cur;

Line 65: x_return_status := fnd_api.g_ret_sts_error;

61: if(res_cur%notfound)
62: then
63: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
64: fnd_msg_pub.add;
65: x_return_status := fnd_api.g_ret_sts_error;
66: close res_cur;
67: RAISE fnd_api.g_exc_error;
68: else
69:

Line 67: RAISE fnd_api.g_exc_error;

63: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
64: fnd_msg_pub.add;
65: x_return_status := fnd_api.g_ret_sts_error;
66: close res_cur;
67: RAISE fnd_api.g_exc_error;
68: else
69:
70: BEGIN
71: jtf_rs_resource_extns_pkg.lock_row(

Line 78: x_return_status := fnd_api.g_ret_sts_unexp_error;

74: );
75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
80: fnd_msg_pub.add;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END;

Line 81: RAISE fnd_api.g_exc_unexpected_error;

77: WHEN OTHERS THEN
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
80: fnd_msg_pub.add;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END;
83: update jtf_rs_resource_extns
84: set location = p_location,
85: object_version_number = object_version_number + 1

Line 95: WHEN fnd_api.g_exc_unexpected_error

91:
92: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
93:
94: EXCEPTION
95: WHEN fnd_api.g_exc_unexpected_error
96: THEN
97: ROLLBACK TO update_sp;
98: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: WHEN fnd_api.g_exc_error

Line 99: WHEN fnd_api.g_exc_error

95: WHEN fnd_api.g_exc_unexpected_error
96: THEN
97: ROLLBACK TO update_sp;
98: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
99: WHEN fnd_api.g_exc_error
100: THEN
101: ROLLBACK TO update_sp;
102: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
103:

Line 112: x_return_status := fnd_api.g_ret_sts_unexp_error;

108: fnd_message.set_token('P_SQLCODE',SQLCODE);
109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;
112: x_return_status := fnd_api.g_ret_sts_unexp_error;
113: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114: END;
115:
116: