APPS.JTF_RS_DYNAMIC_GROUPS_PVT dependencies on FND_API

Line 97: x_return_status := fnd_api.g_ret_sts_success;

93:
94: --Standard Start of API SAVEPOINT
95: SAVEPOINT GROUP_DYNAMIC_SP;
96:
97: x_return_status := fnd_api.g_ret_sts_success;
98:
99: --Standard Call to check API compatibility
100: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
101: THEN

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

96:
97: x_return_status := fnd_api.g_ret_sts_success;
98:
99: --Standard Call to check API compatibility
100: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:

Line 102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

98:
99: --Standard Call to check API compatibility
100: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
101: THEN
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
106: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 106: IF FND_API.To_boolean(P_INIT_MSG_LIST)

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
106: IF FND_API.To_boolean(P_INIT_MSG_LIST)
107: THEN
108: FND_MSG_PUB.Initialize;
109: END IF;
110:

Line 131: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

127: P_SQL_TEXT => p_sql_text,
128: p_data => L_data,
129: p_count => L_count,
130: P_return_code => l_return_code);
131: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
132: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
133: fnd_msg_pub.add;
134:
135: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 135: IF l_return_code = fnd_api.g_ret_sts_error THEN

131: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
132: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
133: fnd_msg_pub.add;
134:
135: IF l_return_code = fnd_api.g_ret_sts_error THEN
136: raise fnd_api.g_exc_error;
137: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
138: raise fnd_api.g_exc_unexpected_error;
139: END IF;

Line 136: raise fnd_api.g_exc_error;

132: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
133: fnd_msg_pub.add;
134:
135: IF l_return_code = fnd_api.g_ret_sts_error THEN
136: raise fnd_api.g_exc_error;
137: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
138: raise fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;

Line 137: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

133: fnd_msg_pub.add;
134:
135: IF l_return_code = fnd_api.g_ret_sts_error THEN
136: raise fnd_api.g_exc_error;
137: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
138: raise fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;
141: /*

Line 138: raise fnd_api.g_exc_unexpected_error;

134:
135: IF l_return_code = fnd_api.g_ret_sts_error THEN
136: raise fnd_api.g_exc_error;
137: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
138: raise fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;
141: /*
142: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 142: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

138: raise fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;
141: /*
142: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
143: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
146: FND_MSG_PUB.add;

Line 143: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

139: END IF;
140: END IF;
141: /*
142: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
143: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
146: FND_MSG_PUB.add;
147: RAISE fnd_api.g_exc_unexpected_error;

Line 144: x_return_status := fnd_api.g_ret_sts_unexp_error;

140: END IF;
141: /*
142: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
143: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
146: FND_MSG_PUB.add;
147: RAISE fnd_api.g_exc_unexpected_error;
148: end if;

Line 147: RAISE fnd_api.g_exc_unexpected_error;

143: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
146: FND_MSG_PUB.add;
147: RAISE fnd_api.g_exc_unexpected_error;
148: end if;
149: */
150: end if;
151: end if;

Line 170: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

166: P_SQL_TEXT => p_sql_text,
167: p_data => L_data,
168: p_count => L_count,
169: P_return_code => l_return_code);
170: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
171: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
172: fnd_msg_pub.add;
173:
174: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 174: IF l_return_code = fnd_api.g_ret_sts_error THEN

170: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
171: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
172: fnd_msg_pub.add;
173:
174: IF l_return_code = fnd_api.g_ret_sts_error THEN
175: raise fnd_api.g_exc_error;
176: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
177: raise fnd_api.g_exc_unexpected_error;
178: END IF;

Line 175: raise fnd_api.g_exc_error;

171: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
172: fnd_msg_pub.add;
173:
174: IF l_return_code = fnd_api.g_ret_sts_error THEN
175: raise fnd_api.g_exc_error;
176: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
177: raise fnd_api.g_exc_unexpected_error;
178: END IF;
179: END IF;

Line 176: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

172: fnd_msg_pub.add;
173:
174: IF l_return_code = fnd_api.g_ret_sts_error THEN
175: raise fnd_api.g_exc_error;
176: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
177: raise fnd_api.g_exc_unexpected_error;
178: END IF;
179: END IF;
180: /*

Line 177: raise fnd_api.g_exc_unexpected_error;

173:
174: IF l_return_code = fnd_api.g_ret_sts_error THEN
175: raise fnd_api.g_exc_error;
176: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
177: raise fnd_api.g_exc_unexpected_error;
178: END IF;
179: END IF;
180: /*
181: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 181: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

177: raise fnd_api.g_exc_unexpected_error;
178: END IF;
179: END IF;
180: /*
181: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
182: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
185: FND_MSG_PUB.add;

Line 182: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

178: END IF;
179: END IF;
180: /*
181: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
182: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
185: FND_MSG_PUB.add;
186: RAISE fnd_api.g_exc_unexpected_error;

Line 183: x_return_status := fnd_api.g_ret_sts_unexp_error;

179: END IF;
180: /*
181: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
182: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
185: FND_MSG_PUB.add;
186: RAISE fnd_api.g_exc_unexpected_error;
187: end if;

Line 186: RAISE fnd_api.g_exc_unexpected_error;

182: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
185: FND_MSG_PUB.add;
186: RAISE fnd_api.g_exc_unexpected_error;
187: end if;
188: */
189: end if;
190: end if;

Line 209: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

205: P_SQL_TEXT => p_sql_text,
206: p_data => L_data,
207: p_count => L_count,
208: P_return_code => l_return_code);
209: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
210: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
211: fnd_msg_pub.add;
212:
213: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 213: IF l_return_code = fnd_api.g_ret_sts_error THEN

209: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
210: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
211: fnd_msg_pub.add;
212:
213: IF l_return_code = fnd_api.g_ret_sts_error THEN
214: raise fnd_api.g_exc_error;
215: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
216: raise fnd_api.g_exc_unexpected_error;
217: END IF;

Line 214: raise fnd_api.g_exc_error;

210: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
211: fnd_msg_pub.add;
212:
213: IF l_return_code = fnd_api.g_ret_sts_error THEN
214: raise fnd_api.g_exc_error;
215: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
216: raise fnd_api.g_exc_unexpected_error;
217: END IF;
218: END IF;

Line 215: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

211: fnd_msg_pub.add;
212:
213: IF l_return_code = fnd_api.g_ret_sts_error THEN
214: raise fnd_api.g_exc_error;
215: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
216: raise fnd_api.g_exc_unexpected_error;
217: END IF;
218: END IF;
219: /*

Line 216: raise fnd_api.g_exc_unexpected_error;

212:
213: IF l_return_code = fnd_api.g_ret_sts_error THEN
214: raise fnd_api.g_exc_error;
215: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
216: raise fnd_api.g_exc_unexpected_error;
217: END IF;
218: END IF;
219: /*
220: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 220: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

216: raise fnd_api.g_exc_unexpected_error;
217: END IF;
218: END IF;
219: /*
220: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
221: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
224: FND_MSG_PUB.add;

Line 221: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

217: END IF;
218: END IF;
219: /*
220: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
221: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
224: FND_MSG_PUB.add;
225: RAISE fnd_api.g_exc_unexpected_error;

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error;

218: END IF;
219: /*
220: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
221: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
224: FND_MSG_PUB.add;
225: RAISE fnd_api.g_exc_unexpected_error;
226: end if;

Line 225: RAISE fnd_api.g_exc_unexpected_error;

221: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
224: FND_MSG_PUB.add;
225: RAISE fnd_api.g_exc_unexpected_error;
226: end if;
227: */
228: end if;
229: end if;

Line 243: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

239: --call default date validation utl
240: JTF_RESOURCE_UTL.VALIDATE_INPUT_DATES(l_start_date_active,
241: l_end_date_active,
242: l_return_status);
243: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
244: IF l_return_status = fnd_api.g_ret_sts_error THEN
245: RAISE fnd_api.g_exc_error;
246: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;

Line 244: IF l_return_status = fnd_api.g_ret_sts_error THEN

240: JTF_RESOURCE_UTL.VALIDATE_INPUT_DATES(l_start_date_active,
241: l_end_date_active,
242: l_return_status);
243: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
244: IF l_return_status = fnd_api.g_ret_sts_error THEN
245: RAISE fnd_api.g_exc_error;
246: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: END IF;

Line 245: RAISE fnd_api.g_exc_error;

241: l_end_date_active,
242: l_return_status);
243: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
244: IF l_return_status = fnd_api.g_ret_sts_error THEN
245: RAISE fnd_api.g_exc_error;
246: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: END IF;
249: END IF;

Line 246: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

242: l_return_status);
243: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
244: IF l_return_status = fnd_api.g_ret_sts_error THEN
245: RAISE fnd_api.g_exc_error;
246: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: END IF;
249: END IF;
250: /*

Line 247: RAISE fnd_api.g_exc_unexpected_error;

243: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
244: IF l_return_status = fnd_api.g_ret_sts_error THEN
245: RAISE fnd_api.g_exc_error;
246: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: END IF;
249: END IF;
250: /*
251: IF(l_return_status <> fnd_api.g_ret_sts_success)

Line 251: IF(l_return_status <> fnd_api.g_ret_sts_success)

247: RAISE fnd_api.g_exc_unexpected_error;
248: END IF;
249: END IF;
250: /*
251: IF(l_return_status <> fnd_api.g_ret_sts_success)
252: THEN
253: x_return_status := fnd_api.g_ret_sts_unexp_error;
254: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
255: FND_MSG_PUB.add;

Line 253: x_return_status := fnd_api.g_ret_sts_unexp_error;

249: END IF;
250: /*
251: IF(l_return_status <> fnd_api.g_ret_sts_success)
252: THEN
253: x_return_status := fnd_api.g_ret_sts_unexp_error;
254: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
255: FND_MSG_PUB.add;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;

Line 256: RAISE fnd_api.g_exc_unexpected_error;

252: THEN
253: x_return_status := fnd_api.g_ret_sts_unexp_error;
254: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
255: FND_MSG_PUB.add;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;
258: */
259: --call usage validation
260:

Line 264: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

260:
261: JTF_RESOURCE_UTL.VALIDATE_USAGE(l_usage,
262: l_return_status);
263:
264: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
265: IF l_return_status = fnd_api.g_ret_sts_error THEN
266: RAISE fnd_api.g_exc_error;
267: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
268: RAISE fnd_api.g_exc_unexpected_error;

Line 265: IF l_return_status = fnd_api.g_ret_sts_error THEN

261: JTF_RESOURCE_UTL.VALIDATE_USAGE(l_usage,
262: l_return_status);
263:
264: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
265: IF l_return_status = fnd_api.g_ret_sts_error THEN
266: RAISE fnd_api.g_exc_error;
267: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;

Line 266: RAISE fnd_api.g_exc_error;

262: l_return_status);
263:
264: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
265: IF l_return_status = fnd_api.g_ret_sts_error THEN
266: RAISE fnd_api.g_exc_error;
267: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270: END IF;

Line 267: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

263:
264: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
265: IF l_return_status = fnd_api.g_ret_sts_error THEN
266: RAISE fnd_api.g_exc_error;
267: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270: END IF;
271: /*

Line 268: RAISE fnd_api.g_exc_unexpected_error;

264: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
265: IF l_return_status = fnd_api.g_ret_sts_error THEN
266: RAISE fnd_api.g_exc_error;
267: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270: END IF;
271: /*
272: IF(l_return_status <> fnd_api.g_ret_sts_success)

Line 272: IF(l_return_status <> fnd_api.g_ret_sts_success)

268: RAISE fnd_api.g_exc_unexpected_error;
269: END IF;
270: END IF;
271: /*
272: IF(l_return_status <> fnd_api.g_ret_sts_success)
273: THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
276: FND_MSG_PUB.add;

Line 274: x_return_status := fnd_api.g_ret_sts_unexp_error;

270: END IF;
271: /*
272: IF(l_return_status <> fnd_api.g_ret_sts_success)
273: THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
276: FND_MSG_PUB.add;
277: RAISE fnd_api.g_exc_unexpected_error;
278: END IF;

Line 277: RAISE fnd_api.g_exc_unexpected_error;

273: THEN
274: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
276: FND_MSG_PUB.add;
277: RAISE fnd_api.g_exc_unexpected_error;
278: END IF;
279: */
280: IF l_sql_text is NOT NULL
281: THEN

Line 289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

285: l_cursorid := DBMS_SQL.OPEN_CURSOR;
286: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
287: EXCEPTION
288: WHEN OTHERS THEN
289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
291: FND_MSG_PUB.add;
292: -- RAISE fnd_api.g_exc_unexpected_error;
293: RAISE fnd_api.g_exc_error;

Line 292: -- RAISE fnd_api.g_exc_unexpected_error;

288: WHEN OTHERS THEN
289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
291: FND_MSG_PUB.add;
292: -- RAISE fnd_api.g_exc_unexpected_error;
293: RAISE fnd_api.g_exc_error;
294: END;
295: else
296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 293: RAISE fnd_api.g_exc_error;

289: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
290: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
291: FND_MSG_PUB.add;
292: -- RAISE fnd_api.g_exc_unexpected_error;
293: RAISE fnd_api.g_exc_error;
294: END;
295: else
296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');

Line 296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

292: -- RAISE fnd_api.g_exc_unexpected_error;
293: RAISE fnd_api.g_exc_error;
294: END;
295: else
296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
298: FND_MSG_PUB.add;
299: -- RAISE fnd_api.g_exc_unexpected_error;
300: RAISE fnd_api.g_exc_error;

Line 299: -- RAISE fnd_api.g_exc_unexpected_error;

295: else
296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
298: FND_MSG_PUB.add;
299: -- RAISE fnd_api.g_exc_unexpected_error;
300: RAISE fnd_api.g_exc_error;
301: end if;
302: END IF;
303:

Line 300: RAISE fnd_api.g_exc_error;

296: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
297: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
298: FND_MSG_PUB.add;
299: -- RAISE fnd_api.g_exc_unexpected_error;
300: RAISE fnd_api.g_exc_error;
301: end if;
302: END IF;
303:
304: --call table handler for insert

Line 362: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

358: P_SQL_TEXT => p_sql_text,
359: p_data => L_data,
360: p_count => L_count,
361: P_return_code => l_return_code);
362: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
363: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
364: fnd_msg_pub.add;
365:
366: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 366: IF l_return_code = fnd_api.g_ret_sts_error THEN

362: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
363: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
364: fnd_msg_pub.add;
365:
366: IF l_return_code = fnd_api.g_ret_sts_error THEN
367: raise fnd_api.g_exc_error;
368: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
369: raise fnd_api.g_exc_unexpected_error;
370: END IF;

Line 367: raise fnd_api.g_exc_error;

363: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
364: fnd_msg_pub.add;
365:
366: IF l_return_code = fnd_api.g_ret_sts_error THEN
367: raise fnd_api.g_exc_error;
368: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
369: raise fnd_api.g_exc_unexpected_error;
370: END IF;
371: END IF;

Line 368: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

364: fnd_msg_pub.add;
365:
366: IF l_return_code = fnd_api.g_ret_sts_error THEN
367: raise fnd_api.g_exc_error;
368: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
369: raise fnd_api.g_exc_unexpected_error;
370: END IF;
371: END IF;
372: /*

Line 369: raise fnd_api.g_exc_unexpected_error;

365:
366: IF l_return_code = fnd_api.g_ret_sts_error THEN
367: raise fnd_api.g_exc_error;
368: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
369: raise fnd_api.g_exc_unexpected_error;
370: END IF;
371: END IF;
372: /*
373: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 373: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

369: raise fnd_api.g_exc_unexpected_error;
370: END IF;
371: END IF;
372: /*
373: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
374: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
377: FND_MSG_PUB.add;

Line 374: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

370: END IF;
371: END IF;
372: /*
373: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
374: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
377: FND_MSG_PUB.add;
378: RAISE fnd_api.g_exc_unexpected_error;

Line 375: x_return_status := fnd_api.g_ret_sts_unexp_error;

371: END IF;
372: /*
373: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
374: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
377: FND_MSG_PUB.add;
378: RAISE fnd_api.g_exc_unexpected_error;
379: end if;

Line 378: RAISE fnd_api.g_exc_unexpected_error;

374: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
375: x_return_status := fnd_api.g_ret_sts_unexp_error;
376: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
377: FND_MSG_PUB.add;
378: RAISE fnd_api.g_exc_unexpected_error;
379: end if;
380: */
381: end if;
382: end if;

Line 402: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

398: P_SQL_TEXT => p_sql_text,
399: p_data => L_data,
400: p_count => L_count,
401: P_return_code => l_return_code);
402: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
403: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
404: fnd_msg_pub.add;
405:
406: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 406: IF l_return_code = fnd_api.g_ret_sts_error THEN

402: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
403: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
404: fnd_msg_pub.add;
405:
406: IF l_return_code = fnd_api.g_ret_sts_error THEN
407: raise fnd_api.g_exc_error;
408: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
409: raise fnd_api.g_exc_unexpected_error;
410: END IF;

Line 407: raise fnd_api.g_exc_error;

403: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
404: fnd_msg_pub.add;
405:
406: IF l_return_code = fnd_api.g_ret_sts_error THEN
407: raise fnd_api.g_exc_error;
408: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
409: raise fnd_api.g_exc_unexpected_error;
410: END IF;
411: END IF;

Line 408: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

404: fnd_msg_pub.add;
405:
406: IF l_return_code = fnd_api.g_ret_sts_error THEN
407: raise fnd_api.g_exc_error;
408: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
409: raise fnd_api.g_exc_unexpected_error;
410: END IF;
411: END IF;
412: /*

Line 409: raise fnd_api.g_exc_unexpected_error;

405:
406: IF l_return_code = fnd_api.g_ret_sts_error THEN
407: raise fnd_api.g_exc_error;
408: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
409: raise fnd_api.g_exc_unexpected_error;
410: END IF;
411: END IF;
412: /*
413: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 413: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

409: raise fnd_api.g_exc_unexpected_error;
410: END IF;
411: END IF;
412: /*
413: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
414: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
417: FND_MSG_PUB.add;

Line 414: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

410: END IF;
411: END IF;
412: /*
413: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
414: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
417: FND_MSG_PUB.add;
418: RAISE fnd_api.g_exc_unexpected_error;

Line 415: x_return_status := fnd_api.g_ret_sts_unexp_error;

411: END IF;
412: /*
413: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
414: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
417: FND_MSG_PUB.add;
418: RAISE fnd_api.g_exc_unexpected_error;
419: end if;

Line 418: RAISE fnd_api.g_exc_unexpected_error;

414: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
415: x_return_status := fnd_api.g_ret_sts_unexp_error;
416: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
417: FND_MSG_PUB.add;
418: RAISE fnd_api.g_exc_unexpected_error;
419: end if;
420: */
421: end if;
422: end if;

Line 442: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

438: P_SQL_TEXT => p_sql_text,
439: p_data => L_data,
440: p_count => L_count,
441: P_return_code => l_return_code);
442: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
443: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
444: fnd_msg_pub.add;
445:
446: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 446: IF l_return_code = fnd_api.g_ret_sts_error THEN

442: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
443: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
444: fnd_msg_pub.add;
445:
446: IF l_return_code = fnd_api.g_ret_sts_error THEN
447: raise fnd_api.g_exc_error;
448: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
449: raise fnd_api.g_exc_unexpected_error;
450: END IF;

Line 447: raise fnd_api.g_exc_error;

443: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
444: fnd_msg_pub.add;
445:
446: IF l_return_code = fnd_api.g_ret_sts_error THEN
447: raise fnd_api.g_exc_error;
448: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
449: raise fnd_api.g_exc_unexpected_error;
450: END IF;
451: END IF;

Line 448: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

444: fnd_msg_pub.add;
445:
446: IF l_return_code = fnd_api.g_ret_sts_error THEN
447: raise fnd_api.g_exc_error;
448: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
449: raise fnd_api.g_exc_unexpected_error;
450: END IF;
451: END IF;
452: /*

Line 449: raise fnd_api.g_exc_unexpected_error;

445:
446: IF l_return_code = fnd_api.g_ret_sts_error THEN
447: raise fnd_api.g_exc_error;
448: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
449: raise fnd_api.g_exc_unexpected_error;
450: END IF;
451: END IF;
452: /*
453: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 453: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

449: raise fnd_api.g_exc_unexpected_error;
450: END IF;
451: END IF;
452: /*
453: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
454: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
457: FND_MSG_PUB.add;

Line 454: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

450: END IF;
451: END IF;
452: /*
453: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
454: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
457: FND_MSG_PUB.add;
458: RAISE fnd_api.g_exc_unexpected_error;

Line 455: x_return_status := fnd_api.g_ret_sts_unexp_error;

451: END IF;
452: /*
453: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
454: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
457: FND_MSG_PUB.add;
458: RAISE fnd_api.g_exc_unexpected_error;
459: end if;

Line 458: RAISE fnd_api.g_exc_unexpected_error;

454: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
455: x_return_status := fnd_api.g_ret_sts_unexp_error;
456: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
457: FND_MSG_PUB.add;
458: RAISE fnd_api.g_exc_unexpected_error;
459: end if;
460: */
461: end if;
462: end if;

Line 504: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

500: p_action_code => 'I', /* I/U/D */
501: p_bind_data_id => l_bind_data_id,
502: x_return_code => x_return_status);
503:
504: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
505: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
506: fnd_msg_pub.add;
507:
508: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 508: IF x_return_status = fnd_api.g_ret_sts_error THEN

504: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
505: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
506: fnd_msg_pub.add;
507:
508: IF x_return_status = fnd_api.g_ret_sts_error THEN
509: raise fnd_api.g_exc_error;
510: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
511: raise fnd_api.g_exc_unexpected_error;
512: END IF;

Line 509: raise fnd_api.g_exc_error;

505: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
506: fnd_msg_pub.add;
507:
508: IF x_return_status = fnd_api.g_ret_sts_error THEN
509: raise fnd_api.g_exc_error;
510: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
511: raise fnd_api.g_exc_unexpected_error;
512: END IF;
513: END IF;

Line 510: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

506: fnd_msg_pub.add;
507:
508: IF x_return_status = fnd_api.g_ret_sts_error THEN
509: raise fnd_api.g_exc_error;
510: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
511: raise fnd_api.g_exc_unexpected_error;
512: END IF;
513: END IF;
514: /*

Line 511: raise fnd_api.g_exc_unexpected_error;

507:
508: IF x_return_status = fnd_api.g_ret_sts_error THEN
509: raise fnd_api.g_exc_error;
510: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
511: raise fnd_api.g_exc_unexpected_error;
512: END IF;
513: END IF;
514: /*
515: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 515: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

511: raise fnd_api.g_exc_unexpected_error;
512: END IF;
513: END IF;
514: /*
515: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517:
518: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
519: fnd_msg_pub.add;

Line 516: x_return_status := fnd_api.g_ret_sts_unexp_error;

512: END IF;
513: END IF;
514: /*
515: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
516: x_return_status := fnd_api.g_ret_sts_unexp_error;
517:
518: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
519: fnd_msg_pub.add;
520:

Line 521: RAISE fnd_api.g_exc_unexpected_error;

517:
518: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
519: fnd_msg_pub.add;
520:
521: RAISE fnd_api.g_exc_unexpected_error;
522:
523: END IF;
524: */
525: END IF;

Line 533: IF fnd_api.to_boolean (p_commit)

529:
530:
531:
532: --standard commit
533: IF fnd_api.to_boolean (p_commit)
534: THEN
535: COMMIT WORK;
536: END IF;
537:

Line 543: WHEN fnd_api.g_exc_error THEN

539: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
540:
541: EXCEPTION
542:
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO group_dynamic_sp;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);

Line 545: x_return_status := fnd_api.g_ret_sts_error;

541: EXCEPTION
542:
543: WHEN fnd_api.g_exc_error THEN
544: ROLLBACK TO group_dynamic_sp;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO group_dynamic_sp;

Line 548: WHEN fnd_api.g_exc_unexpected_error THEN

544: ROLLBACK TO group_dynamic_sp;
545: x_return_status := fnd_api.g_ret_sts_error;
546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO group_dynamic_sp;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);

Line 550: x_return_status := fnd_api.g_ret_sts_unexp_error;

546: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
547: p_data => x_msg_data);
548: WHEN fnd_api.g_exc_unexpected_error THEN
549: ROLLBACK TO group_dynamic_sp;
550: x_return_status := fnd_api.g_ret_sts_unexp_error;
551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO group_dynamic_sp;

Line 560: x_return_status := fnd_api.g_ret_sts_unexp_error;

556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563: /*
564: WHEN fnd_api.g_exc_unexpected_error

Line 564: WHEN fnd_api.g_exc_unexpected_error

560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);
563: /*
564: WHEN fnd_api.g_exc_unexpected_error
565: THEN
566: ROLLBACK TO GROUP_DYNAMIC_SP;
567: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
568: FND_MSG_PUB.add;

Line 569: x_return_status := fnd_api.g_ret_sts_unexp_error;

565: THEN
566: ROLLBACK TO GROUP_DYNAMIC_SP;
567: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
568: FND_MSG_PUB.add;
569: x_return_status := fnd_api.g_ret_sts_unexp_error;
570: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571: WHEN OTHERS
572: THEN
573: ROLLBACK TO GROUP_DYNAMIC_SP;

Line 576: x_return_status := fnd_api.g_ret_sts_unexp_error;

572: THEN
573: ROLLBACK TO GROUP_DYNAMIC_SP;
574: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
575: FND_MSG_PUB.add;
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578: */
579:
580: END create_dynamic_groups;

Line 711: x_return_status := fnd_api.g_ret_sts_success;

707:
708: --Standard Start of API SAVEPOINT
709: SAVEPOINT GROUP_DYNAMIC_SP;
710:
711: x_return_status := fnd_api.g_ret_sts_success;
712:
713: --Standard Call to check API compatibility
714: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
715: THEN

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

710:
711: x_return_status := fnd_api.g_ret_sts_success;
712:
713: --Standard Call to check API compatibility
714: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
715: THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:

Line 716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

712:
713: --Standard Call to check API compatibility
714: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
715: THEN
716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
720: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 720: IF FND_API.To_boolean(P_INIT_MSG_LIST)

716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
717: END IF;
718:
719: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
720: IF FND_API.To_boolean(P_INIT_MSG_LIST)
721: THEN
722: FND_MSG_PUB.Initialize;
723: END IF;
724:

Line 748: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

744: P_OBJECT_VERSION_NUMBER => p_object_version_number,
745: p_data => L_data,
746: p_count => L_count,
747: P_return_code => l_return_code);
748: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
749: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
750: fnd_msg_pub.add;
751:
752: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 752: IF l_return_code = fnd_api.g_ret_sts_error THEN

748: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
749: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
750: fnd_msg_pub.add;
751:
752: IF l_return_code = fnd_api.g_ret_sts_error THEN
753: raise fnd_api.g_exc_error;
754: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
755: raise fnd_api.g_exc_unexpected_error;
756: END IF;

Line 753: raise fnd_api.g_exc_error;

749: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
750: fnd_msg_pub.add;
751:
752: IF l_return_code = fnd_api.g_ret_sts_error THEN
753: raise fnd_api.g_exc_error;
754: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
755: raise fnd_api.g_exc_unexpected_error;
756: END IF;
757: END IF;

Line 754: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

750: fnd_msg_pub.add;
751:
752: IF l_return_code = fnd_api.g_ret_sts_error THEN
753: raise fnd_api.g_exc_error;
754: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
755: raise fnd_api.g_exc_unexpected_error;
756: END IF;
757: END IF;
758: /*

Line 755: raise fnd_api.g_exc_unexpected_error;

751:
752: IF l_return_code = fnd_api.g_ret_sts_error THEN
753: raise fnd_api.g_exc_error;
754: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
755: raise fnd_api.g_exc_unexpected_error;
756: END IF;
757: END IF;
758: /*
759: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 759: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

755: raise fnd_api.g_exc_unexpected_error;
756: END IF;
757: END IF;
758: /*
759: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
760: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
763: FND_MSG_PUB.add;

Line 760: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

756: END IF;
757: END IF;
758: /*
759: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
760: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
763: FND_MSG_PUB.add;
764: RAISE fnd_api.g_exc_unexpected_error;

Line 761: x_return_status := fnd_api.g_ret_sts_unexp_error;

757: END IF;
758: /*
759: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
760: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
763: FND_MSG_PUB.add;
764: RAISE fnd_api.g_exc_unexpected_error;
765: end if;

Line 764: RAISE fnd_api.g_exc_unexpected_error;

760: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
761: x_return_status := fnd_api.g_ret_sts_unexp_error;
762: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
763: FND_MSG_PUB.add;
764: RAISE fnd_api.g_exc_unexpected_error;
765: end if;
766: */
767: end if;
768: end if;

Line 790: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

786: P_OBJECT_VERSION_NUMBER => p_object_version_number,
787: p_data => L_data,
788: p_count => L_count,
789: P_return_code => l_return_code);
790: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
791: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
792: fnd_msg_pub.add;
793:
794: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 794: IF l_return_code = fnd_api.g_ret_sts_error THEN

790: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
791: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
792: fnd_msg_pub.add;
793:
794: IF l_return_code = fnd_api.g_ret_sts_error THEN
795: raise fnd_api.g_exc_error;
796: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
797: raise fnd_api.g_exc_unexpected_error;
798: END IF;

Line 795: raise fnd_api.g_exc_error;

791: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
792: fnd_msg_pub.add;
793:
794: IF l_return_code = fnd_api.g_ret_sts_error THEN
795: raise fnd_api.g_exc_error;
796: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
797: raise fnd_api.g_exc_unexpected_error;
798: END IF;
799: END IF;

Line 796: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

792: fnd_msg_pub.add;
793:
794: IF l_return_code = fnd_api.g_ret_sts_error THEN
795: raise fnd_api.g_exc_error;
796: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
797: raise fnd_api.g_exc_unexpected_error;
798: END IF;
799: END IF;
800: /*

Line 797: raise fnd_api.g_exc_unexpected_error;

793:
794: IF l_return_code = fnd_api.g_ret_sts_error THEN
795: raise fnd_api.g_exc_error;
796: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
797: raise fnd_api.g_exc_unexpected_error;
798: END IF;
799: END IF;
800: /*
801: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 801: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

797: raise fnd_api.g_exc_unexpected_error;
798: END IF;
799: END IF;
800: /*
801: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
802: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
805: FND_MSG_PUB.add;

Line 802: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

798: END IF;
799: END IF;
800: /*
801: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
802: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
805: FND_MSG_PUB.add;
806: RAISE fnd_api.g_exc_unexpected_error;

Line 803: x_return_status := fnd_api.g_ret_sts_unexp_error;

799: END IF;
800: /*
801: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
802: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
805: FND_MSG_PUB.add;
806: RAISE fnd_api.g_exc_unexpected_error;
807: end if;

Line 806: RAISE fnd_api.g_exc_unexpected_error;

802: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
803: x_return_status := fnd_api.g_ret_sts_unexp_error;
804: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
805: FND_MSG_PUB.add;
806: RAISE fnd_api.g_exc_unexpected_error;
807: end if;
808: */
809: end if;
810: end if;

Line 832: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

828: P_OBJECT_VERSION_NUMBER => p_object_version_number,
829: p_data => L_data,
830: p_count => L_count,
831: P_return_code => l_return_code);
832: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
833: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
834: fnd_msg_pub.add;
835:
836: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 836: IF l_return_code = fnd_api.g_ret_sts_error THEN

832: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
833: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
834: fnd_msg_pub.add;
835:
836: IF l_return_code = fnd_api.g_ret_sts_error THEN
837: raise fnd_api.g_exc_error;
838: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
839: raise fnd_api.g_exc_unexpected_error;
840: END IF;

Line 837: raise fnd_api.g_exc_error;

833: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
834: fnd_msg_pub.add;
835:
836: IF l_return_code = fnd_api.g_ret_sts_error THEN
837: raise fnd_api.g_exc_error;
838: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
839: raise fnd_api.g_exc_unexpected_error;
840: END IF;
841: END IF;

Line 838: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

834: fnd_msg_pub.add;
835:
836: IF l_return_code = fnd_api.g_ret_sts_error THEN
837: raise fnd_api.g_exc_error;
838: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
839: raise fnd_api.g_exc_unexpected_error;
840: END IF;
841: END IF;
842: /*

Line 839: raise fnd_api.g_exc_unexpected_error;

835:
836: IF l_return_code = fnd_api.g_ret_sts_error THEN
837: raise fnd_api.g_exc_error;
838: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
839: raise fnd_api.g_exc_unexpected_error;
840: END IF;
841: END IF;
842: /*
843: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 843: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

839: raise fnd_api.g_exc_unexpected_error;
840: END IF;
841: END IF;
842: /*
843: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
844: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
847: FND_MSG_PUB.add;

Line 844: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

840: END IF;
841: END IF;
842: /*
843: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
844: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
847: FND_MSG_PUB.add;
848: RAISE fnd_api.g_exc_unexpected_error;

Line 845: x_return_status := fnd_api.g_ret_sts_unexp_error;

841: END IF;
842: /*
843: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
844: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
847: FND_MSG_PUB.add;
848: RAISE fnd_api.g_exc_unexpected_error;
849: end if;

Line 848: RAISE fnd_api.g_exc_unexpected_error;

844: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
845: x_return_status := fnd_api.g_ret_sts_unexp_error;
846: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
847: FND_MSG_PUB.add;
848: RAISE fnd_api.g_exc_unexpected_error;
849: end if;
850: */
851: end if;
852: end if;

Line 867: IF(p_group_number = FND_API.G_MISS_CHAR)

863:
864:
865:
866: --assign values to the local variables
867: IF(p_group_number = FND_API.G_MISS_CHAR)
868: THEN
869: l_group_number := dyn_grp_rec.group_number;
870: ELSE
871: l_group_number:= p_group_number;

Line 875: IF(p_group_name = FND_API.G_MISS_CHAR)

871: l_group_number:= p_group_number;
872: END IF;
873:
874:
875: IF(p_group_name = FND_API.G_MISS_CHAR)
876: THEN
877: l_group_name := dyn_grp_rec.group_name;
878: ELSE
879: l_group_name := p_group_name;

Line 882: IF(p_group_desc = FND_API.G_MISS_CHAR)

878: ELSE
879: l_group_name := p_group_name;
880: END IF;
881:
882: IF(p_group_desc = FND_API.G_MISS_CHAR)
883: THEN
884: l_group_desc := dyn_grp_rec.group_desc;
885: ELSE
886: l_group_desc := p_group_desc;

Line 889: IF(p_usage = FND_API.G_MISS_CHAR)

885: ELSE
886: l_group_desc := p_group_desc;
887: END IF;
888:
889: IF(p_usage = FND_API.G_MISS_CHAR)
890: THEN
891: l_usage := dyn_grp_rec.usage ;
892: ELSE
893: l_usage := p_usage ;

Line 895: IF(p_sql_text = FND_API.G_MISS_CHAR)

891: l_usage := dyn_grp_rec.usage ;
892: ELSE
893: l_usage := p_usage ;
894: END IF;
895: IF(p_sql_text = FND_API.G_MISS_CHAR)
896: THEN
897: l_sql_text := dyn_grp_rec.sql_text ;
898: ELSE
899: l_sql_text := p_sql_text;

Line 904: IF(p_start_date_active = FND_API.G_MISS_DATE)

900: END IF;
901:
902:
903:
904: IF(p_start_date_active = FND_API.G_MISS_DATE)
905: THEN
906:
907: l_start_date_active := dyn_grp_rec.start_date_active;
908: ELSE

Line 911: IF(p_end_date_active = FND_API.G_MISS_DATE)

907: l_start_date_active := dyn_grp_rec.start_date_active;
908: ELSE
909: l_start_date_active := p_start_date_active;
910: END IF;
911: IF(p_end_date_active = FND_API.G_MISS_DATE)
912: THEN
913: l_end_date_active := dyn_grp_rec.end_date_active;
914: ELSE
915: l_end_date_active := p_end_date_active;

Line 917: IF(p_attribute1 = FND_API.G_MISS_CHAR)

913: l_end_date_active := dyn_grp_rec.end_date_active;
914: ELSE
915: l_end_date_active := p_end_date_active;
916: END IF;
917: IF(p_attribute1 = FND_API.G_MISS_CHAR)
918: THEN
919: l_attribute1 := dyn_grp_rec.attribute1;
920: ELSE
921: l_attribute1 := p_attribute1;

Line 923: IF(p_attribute2= FND_API.G_MISS_CHAR)

919: l_attribute1 := dyn_grp_rec.attribute1;
920: ELSE
921: l_attribute1 := p_attribute1;
922: END IF;
923: IF(p_attribute2= FND_API.G_MISS_CHAR)
924: THEN
925: l_attribute2 := dyn_grp_rec.attribute2;
926: ELSE
927: l_attribute2 := p_attribute2;

Line 929: IF(p_attribute3 = FND_API.G_MISS_CHAR)

925: l_attribute2 := dyn_grp_rec.attribute2;
926: ELSE
927: l_attribute2 := p_attribute2;
928: END IF;
929: IF(p_attribute3 = FND_API.G_MISS_CHAR)
930: THEN
931: l_attribute3 := dyn_grp_rec.attribute3;
932: ELSE
933: l_attribute3 := p_attribute3;

Line 935: IF(p_attribute4 = FND_API.G_MISS_CHAR)

931: l_attribute3 := dyn_grp_rec.attribute3;
932: ELSE
933: l_attribute3 := p_attribute3;
934: END IF;
935: IF(p_attribute4 = FND_API.G_MISS_CHAR)
936: THEN
937: l_attribute4 := dyn_grp_rec.attribute1;
938: ELSE
939: l_attribute4 := p_attribute4;

Line 941: IF(p_attribute5 = FND_API.G_MISS_CHAR)

937: l_attribute4 := dyn_grp_rec.attribute1;
938: ELSE
939: l_attribute4 := p_attribute4;
940: END IF;
941: IF(p_attribute5 = FND_API.G_MISS_CHAR)
942: THEN
943: l_attribute5 := dyn_grp_rec.attribute5;
944: ELSE
945: l_attribute5 := p_attribute5;

Line 947: IF(p_attribute6 = FND_API.G_MISS_CHAR)

943: l_attribute5 := dyn_grp_rec.attribute5;
944: ELSE
945: l_attribute5 := p_attribute5;
946: END IF;
947: IF(p_attribute6 = FND_API.G_MISS_CHAR)
948: THEN
949: l_attribute6 := dyn_grp_rec.attribute1;
950: ELSE
951: l_attribute6 := p_attribute6;

Line 953: IF(p_attribute7 = FND_API.G_MISS_CHAR)

949: l_attribute6 := dyn_grp_rec.attribute1;
950: ELSE
951: l_attribute6 := p_attribute6;
952: END IF;
953: IF(p_attribute7 = FND_API.G_MISS_CHAR)
954: THEN
955: l_attribute7 := dyn_grp_rec.attribute7;
956: ELSE
957: l_attribute7 := p_attribute7;

Line 959: IF(p_attribute8 = FND_API.G_MISS_CHAR)

955: l_attribute7 := dyn_grp_rec.attribute7;
956: ELSE
957: l_attribute7 := p_attribute7;
958: END IF;
959: IF(p_attribute8 = FND_API.G_MISS_CHAR)
960: THEN
961: l_attribute8 := dyn_grp_rec.attribute8;
962: ELSE
963: l_attribute8 := p_attribute8;

Line 965: IF(p_attribute9 = FND_API.G_MISS_CHAR)

961: l_attribute8 := dyn_grp_rec.attribute8;
962: ELSE
963: l_attribute8 := p_attribute8;
964: END IF;
965: IF(p_attribute9 = FND_API.G_MISS_CHAR)
966: THEN
967: l_attribute9 := dyn_grp_rec.attribute9;
968: ELSE
969: l_attribute9 := p_attribute9;

Line 971: IF(p_attribute10 = FND_API.G_MISS_CHAR)

967: l_attribute9 := dyn_grp_rec.attribute9;
968: ELSE
969: l_attribute9 := p_attribute9;
970: END IF;
971: IF(p_attribute10 = FND_API.G_MISS_CHAR)
972: THEN
973: l_attribute10 := dyn_grp_rec.attribute10;
974: ELSE
975: l_attribute10 := p_attribute10;

Line 977: IF(p_attribute11 = FND_API.G_MISS_CHAR)

973: l_attribute10 := dyn_grp_rec.attribute10;
974: ELSE
975: l_attribute10 := p_attribute10;
976: END IF;
977: IF(p_attribute11 = FND_API.G_MISS_CHAR)
978: THEN
979: l_attribute11 := dyn_grp_rec.attribute11;
980: ELSE
981: l_attribute11 := p_attribute11;

Line 983: IF(p_attribute12 = FND_API.G_MISS_CHAR)

979: l_attribute11 := dyn_grp_rec.attribute11;
980: ELSE
981: l_attribute11 := p_attribute11;
982: END IF;
983: IF(p_attribute12 = FND_API.G_MISS_CHAR)
984: THEN
985: l_attribute12 := dyn_grp_rec.attribute12;
986: ELSE
987: l_attribute12 := p_attribute12;

Line 989: IF(p_attribute13 = FND_API.G_MISS_CHAR)

985: l_attribute12 := dyn_grp_rec.attribute12;
986: ELSE
987: l_attribute12 := p_attribute12;
988: END IF;
989: IF(p_attribute13 = FND_API.G_MISS_CHAR)
990: THEN
991: l_attribute13 := dyn_grp_rec.attribute13;
992: ELSE
993: l_attribute13 := p_attribute13;

Line 995: IF(p_attribute14 = FND_API.G_MISS_CHAR)

991: l_attribute13 := dyn_grp_rec.attribute13;
992: ELSE
993: l_attribute13 := p_attribute13;
994: END IF;
995: IF(p_attribute14 = FND_API.G_MISS_CHAR)
996: THEN
997: l_attribute14 := dyn_grp_rec.attribute14;
998: ELSE
999: l_attribute14 := p_attribute14;

Line 1001: IF(p_attribute15 = FND_API.G_MISS_CHAR)

997: l_attribute14 := dyn_grp_rec.attribute14;
998: ELSE
999: l_attribute14 := p_attribute14;
1000: END IF;
1001: IF(p_attribute15 = FND_API.G_MISS_CHAR)
1002: THEN
1003: l_attribute15 := dyn_grp_rec.attribute15;
1004: ELSE
1005: l_attribute15 := p_attribute15;

Line 1008: IF(p_attribute_category = FND_API.G_MISS_CHAR)

1004: ELSE
1005: l_attribute15 := p_attribute15;
1006: END IF;
1007:
1008: IF(p_attribute_category = FND_API.G_MISS_CHAR)
1009: THEN
1010: l_attribute_category := dyn_grp_rec.attribute_category;
1011: ELSE
1012: l_attribute_category := p_attribute_category;

Line 1020: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

1016: JTF_RESOURCE_UTL.VALIDATE_INPUT_DATES(l_start_date_active,
1017: l_end_date_active,
1018: l_return_status);
1019:
1020: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF l_return_status = fnd_api.g_ret_sts_error THEN
1022: RAISE fnd_api.g_exc_error;
1023: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1024: RAISE fnd_api.g_exc_unexpected_error;

Line 1021: IF l_return_status = fnd_api.g_ret_sts_error THEN

1017: l_end_date_active,
1018: l_return_status);
1019:
1020: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF l_return_status = fnd_api.g_ret_sts_error THEN
1022: RAISE fnd_api.g_exc_error;
1023: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;

Line 1022: RAISE fnd_api.g_exc_error;

1018: l_return_status);
1019:
1020: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF l_return_status = fnd_api.g_ret_sts_error THEN
1022: RAISE fnd_api.g_exc_error;
1023: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;
1026: END IF;

Line 1023: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1019:
1020: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF l_return_status = fnd_api.g_ret_sts_error THEN
1022: RAISE fnd_api.g_exc_error;
1023: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;
1026: END IF;
1027: /*

Line 1024: RAISE fnd_api.g_exc_unexpected_error;

1020: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF l_return_status = fnd_api.g_ret_sts_error THEN
1022: RAISE fnd_api.g_exc_error;
1023: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;
1026: END IF;
1027: /*
1028: IF(l_return_status <> fnd_api.g_ret_sts_success)

Line 1028: IF(l_return_status <> fnd_api.g_ret_sts_success)

1024: RAISE fnd_api.g_exc_unexpected_error;
1025: END IF;
1026: END IF;
1027: /*
1028: IF(l_return_status <> fnd_api.g_ret_sts_success)
1029: THEN
1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1032: FND_MSG_PUB.add;

Line 1030: x_return_status := fnd_api.g_ret_sts_unexp_error;

1026: END IF;
1027: /*
1028: IF(l_return_status <> fnd_api.g_ret_sts_success)
1029: THEN
1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1032: FND_MSG_PUB.add;
1033: RAISE fnd_api.g_exc_unexpected_error;
1034: END IF;

Line 1033: RAISE fnd_api.g_exc_unexpected_error;

1029: THEN
1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031: fnd_message.set_name ('JTF', 'JTF_RS_DATE_RANGE_ERR');
1032: FND_MSG_PUB.add;
1033: RAISE fnd_api.g_exc_unexpected_error;
1034: END IF;
1035: */
1036: --call usage validation
1037: JTF_RESOURCE_UTL.VALIDATE_USAGE(l_usage,

Line 1040: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN

1036: --call usage validation
1037: JTF_RESOURCE_UTL.VALIDATE_USAGE(l_usage,
1038: l_return_status);
1039:
1040: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1041: IF l_return_status = fnd_api.g_ret_sts_error THEN
1042: RAISE fnd_api.g_exc_error;
1043: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1044: RAISE fnd_api.g_exc_unexpected_error;

Line 1041: IF l_return_status = fnd_api.g_ret_sts_error THEN

1037: JTF_RESOURCE_UTL.VALIDATE_USAGE(l_usage,
1038: l_return_status);
1039:
1040: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1041: IF l_return_status = fnd_api.g_ret_sts_error THEN
1042: RAISE fnd_api.g_exc_error;
1043: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1044: RAISE fnd_api.g_exc_unexpected_error;
1045: END IF;

Line 1042: RAISE fnd_api.g_exc_error;

1038: l_return_status);
1039:
1040: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1041: IF l_return_status = fnd_api.g_ret_sts_error THEN
1042: RAISE fnd_api.g_exc_error;
1043: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1044: RAISE fnd_api.g_exc_unexpected_error;
1045: END IF;
1046: END IF;

Line 1043: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1039:
1040: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1041: IF l_return_status = fnd_api.g_ret_sts_error THEN
1042: RAISE fnd_api.g_exc_error;
1043: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1044: RAISE fnd_api.g_exc_unexpected_error;
1045: END IF;
1046: END IF;
1047: /*

Line 1044: RAISE fnd_api.g_exc_unexpected_error;

1040: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
1041: IF l_return_status = fnd_api.g_ret_sts_error THEN
1042: RAISE fnd_api.g_exc_error;
1043: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1044: RAISE fnd_api.g_exc_unexpected_error;
1045: END IF;
1046: END IF;
1047: /*
1048: IF(l_return_status <> fnd_api.g_ret_sts_success)

Line 1048: IF(l_return_status <> fnd_api.g_ret_sts_success)

1044: RAISE fnd_api.g_exc_unexpected_error;
1045: END IF;
1046: END IF;
1047: /*
1048: IF(l_return_status <> fnd_api.g_ret_sts_success)
1049: THEN
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
1052: FND_MSG_PUB.add;

Line 1050: x_return_status := fnd_api.g_ret_sts_unexp_error;

1046: END IF;
1047: /*
1048: IF(l_return_status <> fnd_api.g_ret_sts_success)
1049: THEN
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
1052: FND_MSG_PUB.add;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;

Line 1053: RAISE fnd_api.g_exc_unexpected_error;

1049: THEN
1050: x_return_status := fnd_api.g_ret_sts_unexp_error;
1051: fnd_message.set_name ('JTF', 'JTF_RS_USAGE_ERR');
1052: FND_MSG_PUB.add;
1053: RAISE fnd_api.g_exc_unexpected_error;
1054: END IF;
1055: */
1056:
1057: IF l_sql_text is NOT NULL

Line 1067: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

1063: DBMS_SQL.PARSE(l_cursorid, l_sql_text, DBMS_SQL.V7);
1064:
1065: EXCEPTION
1066: WHEN OTHERS THEN
1067: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
1069: FND_MSG_PUB.add;
1070: -- RAISE fnd_api.g_exc_unexpected_error;
1071: RAISE fnd_api.g_exc_error;

Line 1070: -- RAISE fnd_api.g_exc_unexpected_error;

1066: WHEN OTHERS THEN
1067: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
1069: FND_MSG_PUB.add;
1070: -- RAISE fnd_api.g_exc_unexpected_error;
1071: RAISE fnd_api.g_exc_error;
1072: END;
1073: else
1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1071: RAISE fnd_api.g_exc_error;

1067: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_message.set_name ('JTF', 'JTF_RS_SQL_TEXT_ERR');
1069: FND_MSG_PUB.add;
1070: -- RAISE fnd_api.g_exc_unexpected_error;
1071: RAISE fnd_api.g_exc_error;
1072: END;
1073: else
1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');

Line 1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

1070: -- RAISE fnd_api.g_exc_unexpected_error;
1071: RAISE fnd_api.g_exc_error;
1072: END;
1073: else
1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
1076: FND_MSG_PUB.add;
1077: -- RAISE fnd_api.g_exc_unexpected_error;
1078: RAISE fnd_api.g_exc_error;

Line 1077: -- RAISE fnd_api.g_exc_unexpected_error;

1073: else
1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
1076: FND_MSG_PUB.add;
1077: -- RAISE fnd_api.g_exc_unexpected_error;
1078: RAISE fnd_api.g_exc_error;
1079: end if;
1080: END IF;
1081:

Line 1078: RAISE fnd_api.g_exc_error;

1074: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1075: fnd_message.set_name ('JTF', 'JTF_RS_SQL_NOT_A_SELECT');
1076: FND_MSG_PUB.add;
1077: -- RAISE fnd_api.g_exc_unexpected_error;
1078: RAISE fnd_api.g_exc_error;
1079: end if;
1080: END IF;
1081:
1082:

Line 1094: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

1090:
1091: EXCEPTION
1092:
1093: WHEN OTHERS THEN
1094: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1095: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1096: fnd_msg_pub.add;
1097: -- RAISE fnd_api.g_exc_unexpected_error;
1098: RAISE fnd_api.g_exc_error;

Line 1097: -- RAISE fnd_api.g_exc_unexpected_error;

1093: WHEN OTHERS THEN
1094: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1095: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1096: fnd_msg_pub.add;
1097: -- RAISE fnd_api.g_exc_unexpected_error;
1098: RAISE fnd_api.g_exc_error;
1099:
1100: END;
1101: l_object_version_number := l_object_version_number + 1;

Line 1098: RAISE fnd_api.g_exc_error;

1094: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1095: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1096: fnd_msg_pub.add;
1097: -- RAISE fnd_api.g_exc_unexpected_error;
1098: RAISE fnd_api.g_exc_error;
1099:
1100: END;
1101: l_object_version_number := l_object_version_number + 1;
1102:

Line 1156: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1152: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1153: p_data => L_data,
1154: p_count => L_count,
1155: P_return_code => l_return_code);
1156: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1157: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1158: fnd_msg_pub.add;
1159:
1160: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1160: IF l_return_code = fnd_api.g_ret_sts_error THEN

1156: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1157: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1158: fnd_msg_pub.add;
1159:
1160: IF l_return_code = fnd_api.g_ret_sts_error THEN
1161: raise fnd_api.g_exc_error;
1162: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1163: raise fnd_api.g_exc_unexpected_error;
1164: END IF;

Line 1161: raise fnd_api.g_exc_error;

1157: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1158: fnd_msg_pub.add;
1159:
1160: IF l_return_code = fnd_api.g_ret_sts_error THEN
1161: raise fnd_api.g_exc_error;
1162: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1163: raise fnd_api.g_exc_unexpected_error;
1164: END IF;
1165: END IF;

Line 1162: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1158: fnd_msg_pub.add;
1159:
1160: IF l_return_code = fnd_api.g_ret_sts_error THEN
1161: raise fnd_api.g_exc_error;
1162: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1163: raise fnd_api.g_exc_unexpected_error;
1164: END IF;
1165: END IF;
1166: /*

Line 1163: raise fnd_api.g_exc_unexpected_error;

1159:
1160: IF l_return_code = fnd_api.g_ret_sts_error THEN
1161: raise fnd_api.g_exc_error;
1162: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1163: raise fnd_api.g_exc_unexpected_error;
1164: END IF;
1165: END IF;
1166: /*
1167: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1167: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1163: raise fnd_api.g_exc_unexpected_error;
1164: END IF;
1165: END IF;
1166: /*
1167: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1168: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1171: FND_MSG_PUB.add;

Line 1168: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1164: END IF;
1165: END IF;
1166: /*
1167: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1168: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1171: FND_MSG_PUB.add;
1172: RAISE fnd_api.g_exc_unexpected_error;

Line 1169: x_return_status := fnd_api.g_ret_sts_unexp_error;

1165: END IF;
1166: /*
1167: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1168: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1171: FND_MSG_PUB.add;
1172: RAISE fnd_api.g_exc_unexpected_error;
1173: end if;

Line 1172: RAISE fnd_api.g_exc_unexpected_error;

1168: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1169: x_return_status := fnd_api.g_ret_sts_unexp_error;
1170: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1171: FND_MSG_PUB.add;
1172: RAISE fnd_api.g_exc_unexpected_error;
1173: end if;
1174: */
1175: end if;
1176: end if;

Line 1198: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1194: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1195: p_data => L_data,
1196: p_count => L_count,
1197: P_return_code => l_return_code);
1198: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:
1202: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1202: IF l_return_code = fnd_api.g_ret_sts_error THEN

1198: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:
1202: IF l_return_code = fnd_api.g_ret_sts_error THEN
1203: raise fnd_api.g_exc_error;
1204: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;

Line 1203: raise fnd_api.g_exc_error;

1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:
1202: IF l_return_code = fnd_api.g_ret_sts_error THEN
1203: raise fnd_api.g_exc_error;
1204: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;
1207: END IF;

Line 1204: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1200: fnd_msg_pub.add;
1201:
1202: IF l_return_code = fnd_api.g_ret_sts_error THEN
1203: raise fnd_api.g_exc_error;
1204: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;
1207: END IF;
1208: /*

Line 1205: raise fnd_api.g_exc_unexpected_error;

1201:
1202: IF l_return_code = fnd_api.g_ret_sts_error THEN
1203: raise fnd_api.g_exc_error;
1204: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;
1207: END IF;
1208: /*
1209: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1209: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1205: raise fnd_api.g_exc_unexpected_error;
1206: END IF;
1207: END IF;
1208: /*
1209: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1210: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1211: x_return_status := fnd_api.g_ret_sts_unexp_error;
1212: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1213: FND_MSG_PUB.add;

Line 1210: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1206: END IF;
1207: END IF;
1208: /*
1209: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1210: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1211: x_return_status := fnd_api.g_ret_sts_unexp_error;
1212: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1213: FND_MSG_PUB.add;
1214: RAISE fnd_api.g_exc_unexpected_error;

Line 1211: x_return_status := fnd_api.g_ret_sts_unexp_error;

1207: END IF;
1208: /*
1209: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1210: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1211: x_return_status := fnd_api.g_ret_sts_unexp_error;
1212: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1213: FND_MSG_PUB.add;
1214: RAISE fnd_api.g_exc_unexpected_error;
1215: end if;

Line 1214: RAISE fnd_api.g_exc_unexpected_error;

1210: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1211: x_return_status := fnd_api.g_ret_sts_unexp_error;
1212: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1213: FND_MSG_PUB.add;
1214: RAISE fnd_api.g_exc_unexpected_error;
1215: end if;
1216: */
1217: end if;
1218: end if;

Line 1240: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1236: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1237: p_data => L_data,
1238: p_count => L_count,
1239: P_return_code => l_return_code);
1240: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1241: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1242: fnd_msg_pub.add;
1243:
1244: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1244: IF l_return_code = fnd_api.g_ret_sts_error THEN

1240: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1241: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1242: fnd_msg_pub.add;
1243:
1244: IF l_return_code = fnd_api.g_ret_sts_error THEN
1245: raise fnd_api.g_exc_error;
1246: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1247: raise fnd_api.g_exc_unexpected_error;
1248: END IF;

Line 1245: raise fnd_api.g_exc_error;

1241: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1242: fnd_msg_pub.add;
1243:
1244: IF l_return_code = fnd_api.g_ret_sts_error THEN
1245: raise fnd_api.g_exc_error;
1246: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1247: raise fnd_api.g_exc_unexpected_error;
1248: END IF;
1249: END IF;

Line 1246: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1242: fnd_msg_pub.add;
1243:
1244: IF l_return_code = fnd_api.g_ret_sts_error THEN
1245: raise fnd_api.g_exc_error;
1246: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1247: raise fnd_api.g_exc_unexpected_error;
1248: END IF;
1249: END IF;
1250: /*

Line 1247: raise fnd_api.g_exc_unexpected_error;

1243:
1244: IF l_return_code = fnd_api.g_ret_sts_error THEN
1245: raise fnd_api.g_exc_error;
1246: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1247: raise fnd_api.g_exc_unexpected_error;
1248: END IF;
1249: END IF;
1250: /*
1251: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1251: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1247: raise fnd_api.g_exc_unexpected_error;
1248: END IF;
1249: END IF;
1250: /*
1251: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1252: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1255: FND_MSG_PUB.add;

Line 1252: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1248: END IF;
1249: END IF;
1250: /*
1251: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1252: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1255: FND_MSG_PUB.add;
1256: RAISE fnd_api.g_exc_unexpected_error;

Line 1253: x_return_status := fnd_api.g_ret_sts_unexp_error;

1249: END IF;
1250: /*
1251: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1252: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1255: FND_MSG_PUB.add;
1256: RAISE fnd_api.g_exc_unexpected_error;
1257: end if;

Line 1256: RAISE fnd_api.g_exc_unexpected_error;

1252: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1253: x_return_status := fnd_api.g_ret_sts_unexp_error;
1254: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1255: FND_MSG_PUB.add;
1256: RAISE fnd_api.g_exc_unexpected_error;
1257: end if;
1258: */
1259: end if;
1260: end if;

Line 1303: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1299: p_action_code => 'U', /* I/U/D */
1300: p_bind_data_id => l_bind_data_id,
1301: x_return_code => x_return_status);
1302:
1303: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1304: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1305: fnd_msg_pub.add;
1306:
1307: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 1307: IF x_return_status = fnd_api.g_ret_sts_error THEN

1303: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1304: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1305: fnd_msg_pub.add;
1306:
1307: IF x_return_status = fnd_api.g_ret_sts_error THEN
1308: raise fnd_api.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1310: raise fnd_api.g_exc_unexpected_error;
1311: END IF;

Line 1308: raise fnd_api.g_exc_error;

1304: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1305: fnd_msg_pub.add;
1306:
1307: IF x_return_status = fnd_api.g_ret_sts_error THEN
1308: raise fnd_api.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1310: raise fnd_api.g_exc_unexpected_error;
1311: END IF;
1312: END IF;

Line 1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1305: fnd_msg_pub.add;
1306:
1307: IF x_return_status = fnd_api.g_ret_sts_error THEN
1308: raise fnd_api.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1310: raise fnd_api.g_exc_unexpected_error;
1311: END IF;
1312: END IF;
1313: /*

Line 1310: raise fnd_api.g_exc_unexpected_error;

1306:
1307: IF x_return_status = fnd_api.g_ret_sts_error THEN
1308: raise fnd_api.g_exc_error;
1309: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1310: raise fnd_api.g_exc_unexpected_error;
1311: END IF;
1312: END IF;
1313: /*
1314: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1314: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1310: raise fnd_api.g_exc_unexpected_error;
1311: END IF;
1312: END IF;
1313: /*
1314: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316:
1317: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1318: fnd_msg_pub.add;

Line 1315: x_return_status := fnd_api.g_ret_sts_unexp_error;

1311: END IF;
1312: END IF;
1313: /*
1314: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1315: x_return_status := fnd_api.g_ret_sts_unexp_error;
1316:
1317: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1318: fnd_msg_pub.add;
1319:

Line 1320: RAISE fnd_api.g_exc_unexpected_error;

1316:
1317: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1318: fnd_msg_pub.add;
1319:
1320: RAISE fnd_api.g_exc_unexpected_error;
1321:
1322: END IF;
1323: */
1324: END IF;

Line 1332: IF fnd_api.to_boolean (p_commit)

1328:
1329:
1330:
1331: --standard commit
1332: IF fnd_api.to_boolean (p_commit)
1333: THEN
1334: COMMIT WORK;
1335: END IF;
1336:

Line 1342: WHEN fnd_api.g_exc_error THEN

1338: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1339:
1340: EXCEPTION
1341:
1342: WHEN fnd_api.g_exc_error THEN
1343: ROLLBACK TO group_dynamic_sp;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1346: p_data => x_msg_data);

Line 1344: x_return_status := fnd_api.g_ret_sts_error;

1340: EXCEPTION
1341:
1342: WHEN fnd_api.g_exc_error THEN
1343: ROLLBACK TO group_dynamic_sp;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1346: p_data => x_msg_data);
1347: WHEN fnd_api.g_exc_unexpected_error THEN
1348: ROLLBACK TO group_dynamic_sp;

Line 1347: WHEN fnd_api.g_exc_unexpected_error THEN

1343: ROLLBACK TO group_dynamic_sp;
1344: x_return_status := fnd_api.g_ret_sts_error;
1345: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1346: p_data => x_msg_data);
1347: WHEN fnd_api.g_exc_unexpected_error THEN
1348: ROLLBACK TO group_dynamic_sp;
1349: x_return_status := fnd_api.g_ret_sts_unexp_error;
1350: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1351: p_data => x_msg_data);

Line 1349: x_return_status := fnd_api.g_ret_sts_unexp_error;

1345: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1346: p_data => x_msg_data);
1347: WHEN fnd_api.g_exc_unexpected_error THEN
1348: ROLLBACK TO group_dynamic_sp;
1349: x_return_status := fnd_api.g_ret_sts_unexp_error;
1350: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1351: p_data => x_msg_data);
1352: WHEN OTHERS THEN
1353: ROLLBACK TO group_dynamic_sp;

Line 1359: x_return_status := fnd_api.g_ret_sts_unexp_error;

1355: fnd_message.set_token('P_SQLCODE',SQLCODE);
1356: fnd_message.set_token('P_SQLERRM',SQLERRM);
1357: fnd_message.set_token('P_API_NAME', l_api_name);
1358: FND_MSG_PUB.add;
1359: x_return_status := fnd_api.g_ret_sts_unexp_error;
1360: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1361: p_data => x_msg_data);
1362: /*
1363: WHEN fnd_api.g_exc_unexpected_error

Line 1363: WHEN fnd_api.g_exc_unexpected_error

1359: x_return_status := fnd_api.g_ret_sts_unexp_error;
1360: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1361: p_data => x_msg_data);
1362: /*
1363: WHEN fnd_api.g_exc_unexpected_error
1364: THEN
1365: ROLLBACK TO GROUP_DYNAMIC_SP;
1366: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1367: FND_MSG_PUB.add;

Line 1368: x_return_status := fnd_api.g_ret_sts_unexp_error;

1364: THEN
1365: ROLLBACK TO GROUP_DYNAMIC_SP;
1366: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1367: FND_MSG_PUB.add;
1368: x_return_status := fnd_api.g_ret_sts_unexp_error;
1369: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1370: WHEN OTHERS
1371: THEN
1372: ROLLBACK TO GROUP_DYNAMIC_SP;

Line 1375: x_return_status := fnd_api.g_ret_sts_unexp_error;

1371: THEN
1372: ROLLBACK TO GROUP_DYNAMIC_SP;
1373: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1374: FND_MSG_PUB.add;
1375: x_return_status := fnd_api.g_ret_sts_unexp_error;
1376: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1377: */
1378:
1379: END;

Line 1416: x_return_status := fnd_api.g_ret_sts_success;

1412: BEGIN
1413: --Standard Start of API SAVEPOINT
1414: SAVEPOINT GROUP_DYNAMIC_SP;
1415:
1416: x_return_status := fnd_api.g_ret_sts_success;
1417:
1418: --Standard Call to check API compatibility
1419: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1420: THEN

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

1415:
1416: x_return_status := fnd_api.g_ret_sts_success;
1417:
1418: --Standard Call to check API compatibility
1419: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1420: THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:

Line 1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1417:
1418: --Standard Call to check API compatibility
1419: IF NOT FND_API.Compatible_API_CALL(L_API_VERSION,P_API_VERSION,L_API_NAME,G_PKG_NAME)
1420: THEN
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:
1424: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1425: IF FND_API.To_boolean(P_INIT_MSG_LIST)

Line 1425: IF FND_API.To_boolean(P_INIT_MSG_LIST)

1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:
1424: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
1425: IF FND_API.To_boolean(P_INIT_MSG_LIST)
1426: THEN
1427: FND_MSG_PUB.Initialize;
1428: END IF;
1429:

Line 1446: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1442: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1443: p_data => L_data,
1444: p_count => L_count,
1445: P_return_code => l_return_code);
1446: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1447: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1448: fnd_msg_pub.add;
1449:
1450: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1450: IF l_return_code = fnd_api.g_ret_sts_error THEN

1446: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1447: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1448: fnd_msg_pub.add;
1449:
1450: IF l_return_code = fnd_api.g_ret_sts_error THEN
1451: raise fnd_api.g_exc_error;
1452: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1453: raise fnd_api.g_exc_unexpected_error;
1454: END IF;

Line 1451: raise fnd_api.g_exc_error;

1447: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1448: fnd_msg_pub.add;
1449:
1450: IF l_return_code = fnd_api.g_ret_sts_error THEN
1451: raise fnd_api.g_exc_error;
1452: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1453: raise fnd_api.g_exc_unexpected_error;
1454: END IF;
1455: END IF;

Line 1452: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1448: fnd_msg_pub.add;
1449:
1450: IF l_return_code = fnd_api.g_ret_sts_error THEN
1451: raise fnd_api.g_exc_error;
1452: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1453: raise fnd_api.g_exc_unexpected_error;
1454: END IF;
1455: END IF;
1456: /*

Line 1453: raise fnd_api.g_exc_unexpected_error;

1449:
1450: IF l_return_code = fnd_api.g_ret_sts_error THEN
1451: raise fnd_api.g_exc_error;
1452: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1453: raise fnd_api.g_exc_unexpected_error;
1454: END IF;
1455: END IF;
1456: /*
1457: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1457: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1453: raise fnd_api.g_exc_unexpected_error;
1454: END IF;
1455: END IF;
1456: /*
1457: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1458: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1459: x_return_status := fnd_api.g_ret_sts_unexp_error;
1460: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1461: FND_MSG_PUB.add;

Line 1458: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1454: END IF;
1455: END IF;
1456: /*
1457: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1458: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1459: x_return_status := fnd_api.g_ret_sts_unexp_error;
1460: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1461: FND_MSG_PUB.add;
1462: RAISE fnd_api.g_exc_unexpected_error;

Line 1459: x_return_status := fnd_api.g_ret_sts_unexp_error;

1455: END IF;
1456: /*
1457: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1458: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1459: x_return_status := fnd_api.g_ret_sts_unexp_error;
1460: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1461: FND_MSG_PUB.add;
1462: RAISE fnd_api.g_exc_unexpected_error;
1463: end if;

Line 1462: RAISE fnd_api.g_exc_unexpected_error;

1458: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1459: x_return_status := fnd_api.g_ret_sts_unexp_error;
1460: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
1461: FND_MSG_PUB.add;
1462: RAISE fnd_api.g_exc_unexpected_error;
1463: end if;
1464: */
1465: end if;
1466: end if;

Line 1481: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1477: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1478: p_data => L_data,
1479: p_count => L_count,
1480: P_return_code => l_return_code);
1481: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1482: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1483: fnd_msg_pub.add;
1484:
1485: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1485: IF l_return_code = fnd_api.g_ret_sts_error THEN

1481: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1482: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1483: fnd_msg_pub.add;
1484:
1485: IF l_return_code = fnd_api.g_ret_sts_error THEN
1486: raise fnd_api.g_exc_error;
1487: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1488: raise fnd_api.g_exc_unexpected_error;
1489: END IF;

Line 1486: raise fnd_api.g_exc_error;

1482: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1483: fnd_msg_pub.add;
1484:
1485: IF l_return_code = fnd_api.g_ret_sts_error THEN
1486: raise fnd_api.g_exc_error;
1487: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1488: raise fnd_api.g_exc_unexpected_error;
1489: END IF;
1490: END IF;

Line 1487: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1483: fnd_msg_pub.add;
1484:
1485: IF l_return_code = fnd_api.g_ret_sts_error THEN
1486: raise fnd_api.g_exc_error;
1487: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1488: raise fnd_api.g_exc_unexpected_error;
1489: END IF;
1490: END IF;
1491: /*

Line 1488: raise fnd_api.g_exc_unexpected_error;

1484:
1485: IF l_return_code = fnd_api.g_ret_sts_error THEN
1486: raise fnd_api.g_exc_error;
1487: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1488: raise fnd_api.g_exc_unexpected_error;
1489: END IF;
1490: END IF;
1491: /*
1492: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1492: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1488: raise fnd_api.g_exc_unexpected_error;
1489: END IF;
1490: END IF;
1491: /*
1492: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1493: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1494: x_return_status := fnd_api.g_ret_sts_unexp_error;
1495: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1496: FND_MSG_PUB.add;

Line 1493: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1489: END IF;
1490: END IF;
1491: /*
1492: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1493: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1494: x_return_status := fnd_api.g_ret_sts_unexp_error;
1495: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1496: FND_MSG_PUB.add;
1497: RAISE fnd_api.g_exc_unexpected_error;

Line 1494: x_return_status := fnd_api.g_ret_sts_unexp_error;

1490: END IF;
1491: /*
1492: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1493: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1494: x_return_status := fnd_api.g_ret_sts_unexp_error;
1495: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1496: FND_MSG_PUB.add;
1497: RAISE fnd_api.g_exc_unexpected_error;
1498: end if;

Line 1497: RAISE fnd_api.g_exc_unexpected_error;

1493: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1494: x_return_status := fnd_api.g_ret_sts_unexp_error;
1495: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
1496: FND_MSG_PUB.add;
1497: RAISE fnd_api.g_exc_unexpected_error;
1498: end if;
1499: */
1500: end if;
1501: end if;

Line 1516: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1512: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1513: p_data => L_data,
1514: p_count => L_count,
1515: P_return_code => l_return_code);
1516: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1517: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1518: fnd_msg_pub.add;
1519:
1520: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1520: IF l_return_code = fnd_api.g_ret_sts_error THEN

1516: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1517: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1518: fnd_msg_pub.add;
1519:
1520: IF l_return_code = fnd_api.g_ret_sts_error THEN
1521: raise fnd_api.g_exc_error;
1522: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1523: raise fnd_api.g_exc_unexpected_error;
1524: END IF;

Line 1521: raise fnd_api.g_exc_error;

1517: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1518: fnd_msg_pub.add;
1519:
1520: IF l_return_code = fnd_api.g_ret_sts_error THEN
1521: raise fnd_api.g_exc_error;
1522: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1523: raise fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: END IF;

Line 1522: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1518: fnd_msg_pub.add;
1519:
1520: IF l_return_code = fnd_api.g_ret_sts_error THEN
1521: raise fnd_api.g_exc_error;
1522: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1523: raise fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: END IF;
1526: /*

Line 1523: raise fnd_api.g_exc_unexpected_error;

1519:
1520: IF l_return_code = fnd_api.g_ret_sts_error THEN
1521: raise fnd_api.g_exc_error;
1522: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1523: raise fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: END IF;
1526: /*
1527: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1527: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1523: raise fnd_api.g_exc_unexpected_error;
1524: END IF;
1525: END IF;
1526: /*
1527: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1528: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1529: x_return_status := fnd_api.g_ret_sts_unexp_error;
1530: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1531: FND_MSG_PUB.add;

Line 1528: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1524: END IF;
1525: END IF;
1526: /*
1527: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1528: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1529: x_return_status := fnd_api.g_ret_sts_unexp_error;
1530: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1531: FND_MSG_PUB.add;
1532: RAISE fnd_api.g_exc_unexpected_error;

Line 1529: x_return_status := fnd_api.g_ret_sts_unexp_error;

1525: END IF;
1526: /*
1527: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1528: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1529: x_return_status := fnd_api.g_ret_sts_unexp_error;
1530: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1531: FND_MSG_PUB.add;
1532: RAISE fnd_api.g_exc_unexpected_error;
1533: end if;

Line 1532: RAISE fnd_api.g_exc_unexpected_error;

1528: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1529: x_return_status := fnd_api.g_ret_sts_unexp_error;
1530: fnd_message.set_name ('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
1531: FND_MSG_PUB.add;
1532: RAISE fnd_api.g_exc_unexpected_error;
1533: end if;
1534: */
1535: end if;
1536: end if;

Line 1553: -- x_return_status := fnd_api.g_ret_sts_unexp_error;

1549:
1550: EXCEPTION
1551:
1552: WHEN OTHERS THEN
1553: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1555: fnd_msg_pub.add;
1556: -- RAISE fnd_api.g_exc_unexpected_error;
1557: RAISE fnd_api.g_exc_error;

Line 1556: -- RAISE fnd_api.g_exc_unexpected_error;

1552: WHEN OTHERS THEN
1553: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1555: fnd_msg_pub.add;
1556: -- RAISE fnd_api.g_exc_unexpected_error;
1557: RAISE fnd_api.g_exc_error;
1558:
1559: END;
1560:

Line 1557: RAISE fnd_api.g_exc_error;

1553: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
1554: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1555: fnd_msg_pub.add;
1556: -- RAISE fnd_api.g_exc_unexpected_error;
1557: RAISE fnd_api.g_exc_error;
1558:
1559: END;
1560:
1561: --call table handler to delete the group

Line 1577: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1573: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1574: p_data => L_data,
1575: p_count => L_count,
1576: P_return_code => l_return_code);
1577: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1578: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1579: fnd_msg_pub.add;
1580:
1581: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1581: IF l_return_code = fnd_api.g_ret_sts_error THEN

1577: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1578: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1579: fnd_msg_pub.add;
1580:
1581: IF l_return_code = fnd_api.g_ret_sts_error THEN
1582: raise fnd_api.g_exc_error;
1583: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1584: raise fnd_api.g_exc_unexpected_error;
1585: END IF;

Line 1582: raise fnd_api.g_exc_error;

1578: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1579: fnd_msg_pub.add;
1580:
1581: IF l_return_code = fnd_api.g_ret_sts_error THEN
1582: raise fnd_api.g_exc_error;
1583: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1584: raise fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: END IF;

Line 1583: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1579: fnd_msg_pub.add;
1580:
1581: IF l_return_code = fnd_api.g_ret_sts_error THEN
1582: raise fnd_api.g_exc_error;
1583: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1584: raise fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: END IF;
1587: /*

Line 1584: raise fnd_api.g_exc_unexpected_error;

1580:
1581: IF l_return_code = fnd_api.g_ret_sts_error THEN
1582: raise fnd_api.g_exc_error;
1583: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1584: raise fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: END IF;
1587: /*
1588: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1588: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1584: raise fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: END IF;
1587: /*
1588: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1589: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1592: FND_MSG_PUB.add;

Line 1589: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1585: END IF;
1586: END IF;
1587: /*
1588: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1589: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1592: FND_MSG_PUB.add;
1593: RAISE fnd_api.g_exc_unexpected_error;

Line 1590: x_return_status := fnd_api.g_ret_sts_unexp_error;

1586: END IF;
1587: /*
1588: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1589: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1592: FND_MSG_PUB.add;
1593: RAISE fnd_api.g_exc_unexpected_error;
1594: end if;

Line 1593: RAISE fnd_api.g_exc_unexpected_error;

1589: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1590: x_return_status := fnd_api.g_ret_sts_unexp_error;
1591: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1592: FND_MSG_PUB.add;
1593: RAISE fnd_api.g_exc_unexpected_error;
1594: end if;
1595: */
1596: end if;
1597: end if;

Line 1612: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1608: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1609: p_data => L_data,
1610: p_count => L_count,
1611: P_return_code => l_return_code);
1612: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1613: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1614: fnd_msg_pub.add;
1615:
1616: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1616: IF l_return_code = fnd_api.g_ret_sts_error THEN

1612: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1613: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1614: fnd_msg_pub.add;
1615:
1616: IF l_return_code = fnd_api.g_ret_sts_error THEN
1617: raise fnd_api.g_exc_error;
1618: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1619: raise fnd_api.g_exc_unexpected_error;
1620: END IF;

Line 1617: raise fnd_api.g_exc_error;

1613: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1614: fnd_msg_pub.add;
1615:
1616: IF l_return_code = fnd_api.g_ret_sts_error THEN
1617: raise fnd_api.g_exc_error;
1618: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1619: raise fnd_api.g_exc_unexpected_error;
1620: END IF;
1621: END IF;

Line 1618: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1614: fnd_msg_pub.add;
1615:
1616: IF l_return_code = fnd_api.g_ret_sts_error THEN
1617: raise fnd_api.g_exc_error;
1618: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1619: raise fnd_api.g_exc_unexpected_error;
1620: END IF;
1621: END IF;
1622: /*

Line 1619: raise fnd_api.g_exc_unexpected_error;

1615:
1616: IF l_return_code = fnd_api.g_ret_sts_error THEN
1617: raise fnd_api.g_exc_error;
1618: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1619: raise fnd_api.g_exc_unexpected_error;
1620: END IF;
1621: END IF;
1622: /*
1623: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1623: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1619: raise fnd_api.g_exc_unexpected_error;
1620: END IF;
1621: END IF;
1622: /*
1623: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1624: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1627: FND_MSG_PUB.add;

Line 1624: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1620: END IF;
1621: END IF;
1622: /*
1623: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1624: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1627: FND_MSG_PUB.add;
1628: RAISE fnd_api.g_exc_unexpected_error;

Line 1625: x_return_status := fnd_api.g_ret_sts_unexp_error;

1621: END IF;
1622: /*
1623: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1624: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1627: FND_MSG_PUB.add;
1628: RAISE fnd_api.g_exc_unexpected_error;
1629: end if;

Line 1628: RAISE fnd_api.g_exc_unexpected_error;

1624: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1625: x_return_status := fnd_api.g_ret_sts_unexp_error;
1626: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1627: FND_MSG_PUB.add;
1628: RAISE fnd_api.g_exc_unexpected_error;
1629: end if;
1630: */
1631: end if;
1632: end if;

Line 1647: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN

1643: P_OBJECT_VERSION_NUMBER => p_object_version_number,
1644: p_data => L_data,
1645: p_count => L_count,
1646: P_return_code => l_return_code);
1647: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1648: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1649: fnd_msg_pub.add;
1650:
1651: IF l_return_code = fnd_api.g_ret_sts_error THEN

Line 1651: IF l_return_code = fnd_api.g_ret_sts_error THEN

1647: IF NOT (l_return_code = fnd_api.g_ret_sts_success) THEN
1648: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1649: fnd_msg_pub.add;
1650:
1651: IF l_return_code = fnd_api.g_ret_sts_error THEN
1652: raise fnd_api.g_exc_error;
1653: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1654: raise fnd_api.g_exc_unexpected_error;
1655: END IF;

Line 1652: raise fnd_api.g_exc_error;

1648: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1649: fnd_msg_pub.add;
1650:
1651: IF l_return_code = fnd_api.g_ret_sts_error THEN
1652: raise fnd_api.g_exc_error;
1653: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1654: raise fnd_api.g_exc_unexpected_error;
1655: END IF;
1656: END IF;

Line 1653: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN

1649: fnd_msg_pub.add;
1650:
1651: IF l_return_code = fnd_api.g_ret_sts_error THEN
1652: raise fnd_api.g_exc_error;
1653: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1654: raise fnd_api.g_exc_unexpected_error;
1655: END IF;
1656: END IF;
1657: /*

Line 1654: raise fnd_api.g_exc_unexpected_error;

1650:
1651: IF l_return_code = fnd_api.g_ret_sts_error THEN
1652: raise fnd_api.g_exc_error;
1653: ELSIF l_return_code = fnd_api.g_ret_sts_unexp_error THEN
1654: raise fnd_api.g_exc_unexpected_error;
1655: END IF;
1656: END IF;
1657: /*
1658: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

Line 1658: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR

1654: raise fnd_api.g_exc_unexpected_error;
1655: END IF;
1656: END IF;
1657: /*
1658: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1659: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1662: FND_MSG_PUB.add;

Line 1659: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then

1655: END IF;
1656: END IF;
1657: /*
1658: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1659: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1662: FND_MSG_PUB.add;
1663: RAISE fnd_api.g_exc_unexpected_error;

Line 1660: x_return_status := fnd_api.g_ret_sts_unexp_error;

1656: END IF;
1657: /*
1658: if ( l_return_code = FND_API.G_RET_STS_ERROR) OR
1659: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1662: FND_MSG_PUB.add;
1663: RAISE fnd_api.g_exc_unexpected_error;
1664: end if;

Line 1663: RAISE fnd_api.g_exc_unexpected_error;

1659: (l_return_code = FND_API.G_RET_STS_UNEXP_ERROR ) then
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name ('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1662: FND_MSG_PUB.add;
1663: RAISE fnd_api.g_exc_unexpected_error;
1664: end if;
1665: */
1666: end if;
1667: end if;

Line 1712: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1708: p_bind_data_id => l_bind_data_id,
1709: x_return_code => x_return_status);
1710:
1711:
1712: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1713: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1714: fnd_msg_pub.add;
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 1716: IF x_return_status = fnd_api.g_ret_sts_error THEN

1712: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1713: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1714: fnd_msg_pub.add;
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_error THEN
1717: raise fnd_api.g_exc_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1719: raise fnd_api.g_exc_unexpected_error;
1720: END IF;

Line 1717: raise fnd_api.g_exc_error;

1713: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1714: fnd_msg_pub.add;
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_error THEN
1717: raise fnd_api.g_exc_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1719: raise fnd_api.g_exc_unexpected_error;
1720: END IF;
1721: END IF;

Line 1718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1714: fnd_msg_pub.add;
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_error THEN
1717: raise fnd_api.g_exc_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1719: raise fnd_api.g_exc_unexpected_error;
1720: END IF;
1721: END IF;
1722: /*

Line 1719: raise fnd_api.g_exc_unexpected_error;

1715:
1716: IF x_return_status = fnd_api.g_ret_sts_error THEN
1717: raise fnd_api.g_exc_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1719: raise fnd_api.g_exc_unexpected_error;
1720: END IF;
1721: END IF;
1722: /*
1723: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

Line 1723: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN

1719: raise fnd_api.g_exc_unexpected_error;
1720: END IF;
1721: END IF;
1722: /*
1723: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1724: x_return_status := fnd_api.g_ret_sts_unexp_error;
1725:
1726: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1727: fnd_msg_pub.add;

Line 1724: x_return_status := fnd_api.g_ret_sts_unexp_error;

1720: END IF;
1721: END IF;
1722: /*
1723: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1724: x_return_status := fnd_api.g_ret_sts_unexp_error;
1725:
1726: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1727: fnd_msg_pub.add;
1728:

Line 1729: RAISE fnd_api.g_exc_unexpected_error;

1725:
1726: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1727: fnd_msg_pub.add;
1728:
1729: RAISE fnd_api.g_exc_unexpected_error;
1730:
1731: END IF;
1732: */
1733: END IF;

Line 1740: IF fnd_api.to_boolean (p_commit)

1736: END IF;
1737:
1738:
1739: --standard commit
1740: IF fnd_api.to_boolean (p_commit)
1741: THEN
1742: COMMIT WORK;
1743: END IF;
1744:

Line 1750: WHEN fnd_api.g_exc_error THEN

1746: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1747:
1748: EXCEPTION
1749:
1750: WHEN fnd_api.g_exc_error THEN
1751: ROLLBACK TO group_dynamic_sp;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1754: p_data => x_msg_data);

Line 1752: x_return_status := fnd_api.g_ret_sts_error;

1748: EXCEPTION
1749:
1750: WHEN fnd_api.g_exc_error THEN
1751: ROLLBACK TO group_dynamic_sp;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1754: p_data => x_msg_data);
1755: WHEN fnd_api.g_exc_unexpected_error THEN
1756: ROLLBACK TO group_dynamic_sp;

Line 1755: WHEN fnd_api.g_exc_unexpected_error THEN

1751: ROLLBACK TO group_dynamic_sp;
1752: x_return_status := fnd_api.g_ret_sts_error;
1753: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1754: p_data => x_msg_data);
1755: WHEN fnd_api.g_exc_unexpected_error THEN
1756: ROLLBACK TO group_dynamic_sp;
1757: x_return_status := fnd_api.g_ret_sts_unexp_error;
1758: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1759: p_data => x_msg_data);

Line 1757: x_return_status := fnd_api.g_ret_sts_unexp_error;

1753: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1754: p_data => x_msg_data);
1755: WHEN fnd_api.g_exc_unexpected_error THEN
1756: ROLLBACK TO group_dynamic_sp;
1757: x_return_status := fnd_api.g_ret_sts_unexp_error;
1758: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1759: p_data => x_msg_data);
1760: WHEN OTHERS THEN
1761: ROLLBACK TO group_dynamic_sp;

Line 1767: x_return_status := fnd_api.g_ret_sts_unexp_error;

1763: fnd_message.set_token('P_SQLCODE',SQLCODE);
1764: fnd_message.set_token('P_SQLERRM',SQLERRM);
1765: fnd_message.set_token('P_API_NAME', l_api_name);
1766: FND_MSG_PUB.add;
1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1769: p_data => x_msg_data);
1770: /*
1771: WHEN fnd_api.g_exc_unexpected_error

Line 1771: WHEN fnd_api.g_exc_unexpected_error

1767: x_return_status := fnd_api.g_ret_sts_unexp_error;
1768: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1769: p_data => x_msg_data);
1770: /*
1771: WHEN fnd_api.g_exc_unexpected_error
1772: THEN
1773: ROLLBACK TO GROUP_DYNAMIC_SP;
1774: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1775: FND_MSG_PUB.add;

Line 1776: x_return_status := fnd_api.g_ret_sts_unexp_error;

1772: THEN
1773: ROLLBACK TO GROUP_DYNAMIC_SP;
1774: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1775: FND_MSG_PUB.add;
1776: x_return_status := fnd_api.g_ret_sts_unexp_error;
1777: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1778: WHEN OTHERS
1779: THEN
1780: ROLLBACK TO GROUP_DYNAMIC_SP;

Line 1783: x_return_status := fnd_api.g_ret_sts_unexp_error;

1779: THEN
1780: ROLLBACK TO GROUP_DYNAMIC_SP;
1781: fnd_message.set_name ('JTF', 'JTF_RS_DYN_GRP_PVT_ERR');
1782: FND_MSG_PUB.add;
1783: x_return_status := fnd_api.g_ret_sts_unexp_error;
1784: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1785: */
1786: END;
1787: END jtf_rs_dynamic_groups_pvt;