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

Line 25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

21: /* Procedure to create table attributes
22: based on input values passed by calling routines. */
23: PROCEDURE create_res_availability
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
28: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
29: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,

Line 26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

22: based on input values passed by calling routines. */
23: PROCEDURE create_res_availability
24: (P_API_VERSION IN NUMBER,
25: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
26: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
27: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
28: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
29: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
30: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,

Line 75: x_return_status := fnd_api.g_ret_sts_success;

71: BEGIN
72: --Standard Start of API SAVEPOINT
73: SAVEPOINT CREATE_RES_AVAILABILITY_SP;
74:
75: x_return_status := fnd_api.g_ret_sts_success;
76:
77: --Standard Call to check API compatibility
78: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
79: THEN

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

74:
75: x_return_status := fnd_api.g_ret_sts_success;
76:
77: --Standard Call to check API compatibility
78: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
79: THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:

Line 80: RAISE FND_API.G_EXC_ERROR;

76:
77: --Standard Call to check API compatibility
78: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
79: THEN
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
84: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 84: IF FND_API.To_boolean(P_INIT_MSG_LIST)

80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82:
83: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
84: IF FND_API.To_boolean(P_INIT_MSG_LIST)
85: THEN
86: FND_MSG_PUB.Initialize;
87: END IF;
88:

Line 98: raise fnd_api.g_exc_error;

94: CLOSE c_resource_id_valid;
95: END IF;
96: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');
97: FND_MSG_PUB.add;
98: raise fnd_api.g_exc_error;
99: END IF;
100: IF c_resource_id_valid%ISOPEN THEN
101: CLOSE c_resource_id_valid;
102: END IF;

Line 143: IF fnd_api.to_boolean (p_commit)

139: X_MSG_DATA := l_msg_data;
140:
141:
142: --standard commit
143: IF fnd_api.to_boolean (p_commit)
144: THEN
145: COMMIT WORK;
146: END IF;
147:

Line 151: WHEN fnd_api.g_exc_unexpected_error

147:
148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
149:
150: EXCEPTION
151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 154: x_return_status := fnd_api.g_ret_sts_unexp_error;

150: EXCEPTION
151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
156: WHEN fnd_api.g_exc_error
157: THEN
158: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;

Line 156: WHEN fnd_api.g_exc_error

152: THEN
153: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
156: WHEN fnd_api.g_exc_error
157: THEN
158: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
159: x_return_status := fnd_api.g_ret_sts_error;
160: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 159: x_return_status := fnd_api.g_ret_sts_error;

155: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
156: WHEN fnd_api.g_exc_error
157: THEN
158: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
159: x_return_status := fnd_api.g_ret_sts_error;
160: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
161: WHEN OTHERS
162: THEN
163: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;

Line 169: x_return_status := fnd_api.g_ret_sts_unexp_error;

165: fnd_message.set_token('P_SQLCODE',SQLCODE);
166: fnd_message.set_token('P_SQLERRM',SQLERRM);
167: fnd_message.set_token('P_API_NAME', l_api_name);
168: FND_MSG_PUB.add;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
171:
172: END CREATE_RES_AVAILABILITY;
173:

Line 180: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

176: based on input values passed by calling routines. */
177:
178: PROCEDURE update_res_availability
179: (P_API_VERSION IN NUMBER,
180: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 181: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

177:
178: PROCEDURE update_res_availability
179: (P_API_VERSION IN NUMBER,
180: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

179: (P_API_VERSION IN NUMBER,
180: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

180: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

181: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
182: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

Line 186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

182: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

183: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,

184: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
185: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

186: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

187: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

188: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

189: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

190: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

191: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

192: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

193: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

194: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

195: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

196: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

197: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

198: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
206: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

199: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
206: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
207: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

200: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
206: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
207: X_MSG_COUNT OUT NOCOPY NUMBER,
208: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 205: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

201: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
206: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
207: X_MSG_COUNT OUT NOCOPY NUMBER,
208: X_MSG_DATA OUT NOCOPY VARCHAR2
209: )IS

Line 237: x_return_status := fnd_api.g_ret_sts_success;

233: BEGIN
234: --Standard Start of API SAVEPOINT
235: SAVEPOINT UPDATE_RES_AVAILABILITY_SP;
236:
237: x_return_status := fnd_api.g_ret_sts_success;
238:
239: --Standard Call to check API compatibility
240: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
241: THEN

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

236:
237: x_return_status := fnd_api.g_ret_sts_success;
238:
239: --Standard Call to check API compatibility
240: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
241: THEN
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:

Line 242: RAISE FND_API.G_EXC_ERROR;

238:
239: --Standard Call to check API compatibility
240: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
241: THEN
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
246: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 246: IF FND_API.To_boolean(P_INIT_MSG_LIST)

242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
246: IF FND_API.To_boolean(P_INIT_MSG_LIST)
247: THEN
248: FND_MSG_PUB.Initialize;
249: END IF;
250:

Line 260: raise fnd_api.g_exc_error;

256: CLOSE c_availability_id_valid;
257: END IF;
258: fnd_message.set_name ('JTF', 'JTF_RS_AVAIL_ID_INVALID');
259: FND_MSG_PUB.add;
260: raise fnd_api.g_exc_error;
261: END IF;
262: IF c_availability_id_valid%ISOPEN THEN
263: CLOSE c_availability_id_valid;
264: END IF;

Line 275: raise fnd_api.g_exc_error;

271: CLOSE c_resource_id_valid;
272: END IF;
273: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');
274: FND_MSG_PUB.add;
275: raise fnd_api.g_exc_error;
276: END IF;
277: IF c_resource_id_valid%ISOPEN THEN
278: CLOSE c_resource_id_valid;
279: END IF;

Line 321: IF fnd_api.to_boolean (p_commit)

317: X_MSG_DATA := l_msg_data;
318: P_OBJECT_VERSION_NUM := l_object_version_number;
319:
320:
321: IF fnd_api.to_boolean (p_commit)
322: THEN
323: COMMIT WORK;
324: END IF;
325:

Line 329: WHEN fnd_api.g_exc_error

325:
326: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
327:
328: EXCEPTION
329: WHEN fnd_api.g_exc_error
330: THEN
331: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
332: x_return_status := fnd_api.g_ret_sts_error;
333: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 332: x_return_status := fnd_api.g_ret_sts_error;

328: EXCEPTION
329: WHEN fnd_api.g_exc_error
330: THEN
331: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
332: x_return_status := fnd_api.g_ret_sts_error;
333: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error
335: THEN
336: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;

Line 334: WHEN fnd_api.g_exc_unexpected_error

330: THEN
331: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
332: x_return_status := fnd_api.g_ret_sts_error;
333: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error
335: THEN
336: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 337: x_return_status := fnd_api.g_ret_sts_unexp_error;

333: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error
335: THEN
336: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;
338: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
339: WHEN OTHERS
340: THEN
341: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;

Line 347: x_return_status := fnd_api.g_ret_sts_unexp_error;

343: fnd_message.set_token('P_SQLCODE',SQLCODE);
344: fnd_message.set_token('P_SQLERRM',SQLERRM);
345: fnd_message.set_token('P_API_NAME',l_api_name);
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349: END update_res_availability;
350:
351:

Line 356: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

352: /* Procedure to delete the resource availability */
353:
354: PROCEDURE delete_res_availability
355: (P_API_VERSION IN NUMBER,
356: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
359: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 357: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

353:
354: PROCEDURE delete_res_availability
355: (P_API_VERSION IN NUMBER,
356: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
357: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
359: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
360: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
361: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 383: x_return_status := fnd_api.g_ret_sts_success;

379: BEGIN
380: --Standard Start of API SAVEPOINT
381: SAVEPOINT DELETE_RES_AVAILABILITY_SP;
382:
383: x_return_status := fnd_api.g_ret_sts_success;
384:
385: --Standard Call to check API compatibility
386: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
387: THEN

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

382:
383: x_return_status := fnd_api.g_ret_sts_success;
384:
385: --Standard Call to check API compatibility
386: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
387: THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:

Line 388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

384:
385: --Standard Call to check API compatibility
386: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
387: THEN
388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
392: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 392: IF FND_API.To_boolean(P_INIT_MSG_LIST)

388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
389: END IF;
390:
391: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
392: IF FND_API.To_boolean(P_INIT_MSG_LIST)
393: THEN
394: FND_MSG_PUB.Initialize;
395: END IF;
396:

Line 406: raise fnd_api.g_exc_error;

402: CLOSE c_availability_id_valid;
403: END IF;
404: fnd_message.set_name ('JTF', 'JTF_RS_AVAIL_ID_INVALID');
405: FND_MSG_PUB.add;
406: raise fnd_api.g_exc_error;
407: END IF;
408: IF c_availability_id_valid%ISOPEN THEN
409: CLOSE c_availability_id_valid;
410: END IF;

Line 428: IF fnd_api.to_boolean (p_commit)

424: X_RETURN_STATUS := l_return_status;
425: X_MSG_COUNT := l_msg_count;
426: X_MSG_DATA := l_msg_data;
427:
428: IF fnd_api.to_boolean (p_commit)
429: THEN
430: COMMIT WORK;
431: END IF;
432:

Line 436: WHEN fnd_api.g_exc_unexpected_error

432:
433: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
434:
435: EXCEPTION
436: WHEN fnd_api.g_exc_unexpected_error
437: THEN
438: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: EXCEPTION
436: WHEN fnd_api.g_exc_unexpected_error
437: THEN
438: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
441: WHEN fnd_api.g_exc_error
442: THEN
443: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;

Line 441: WHEN fnd_api.g_exc_error

437: THEN
438: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
441: WHEN fnd_api.g_exc_error
442: THEN
443: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
444: x_return_status := fnd_api.g_ret_sts_error;
445: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 444: x_return_status := fnd_api.g_ret_sts_error;

440: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
441: WHEN fnd_api.g_exc_error
442: THEN
443: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
444: x_return_status := fnd_api.g_ret_sts_error;
445: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
446: WHEN OTHERS
447: THEN
448: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;

Line 454: x_return_status := fnd_api.g_ret_sts_unexp_error;

450: fnd_message.set_token('P_SQLCODE',SQLCODE);
451: fnd_message.set_token('P_SQLERRM',SQLERRM);
452: fnd_message.set_token('P_API_NAME',l_api_name);
453: FND_MSG_PUB.add;
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
456:
457: END delete_res_availability;
458: