eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_SALESREPS_PVT dependencies on FND_API

Line 112: x_return_status := fnd_api.g_ret_sts_success;

108: -- dbms_output.put_line ('Inside the Create Salesrep PVT API');
109:
110: SAVEPOINT create_salesrep_pvt;
111:
112: x_return_status := fnd_api.g_ret_sts_success;
113:
114: /* Standard call to check for call compatibility. */
115: IF NOT fnd_api.Compatible_api_call( l_api_version,
116: p_api_version,

Line 115: IF NOT fnd_api.Compatible_api_call( l_api_version,

111:
112: x_return_status := fnd_api.g_ret_sts_success;
113:
114: /* Standard call to check for call compatibility. */
115: IF NOT fnd_api.Compatible_api_call( l_api_version,
116: p_api_version,
117: l_api_name,
118: G_PKG_NAME)
119: THEN

Line 120: RAISE fnd_api.g_exc_unexpected_error;

116: p_api_version,
117: l_api_name,
118: G_PKG_NAME)
119: THEN
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:
123: IF fnd_api.to_Boolean(p_init_msg_list) THEN
124: fnd_msg_pub.initialize;

Line 123: IF fnd_api.to_Boolean(p_init_msg_list) THEN

119: THEN
120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:
123: IF fnd_api.to_Boolean(p_init_msg_list) THEN
124: fnd_msg_pub.initialize;
125: END IF;
126:
127: /* Make the pre processing call to the user hooks */

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

151: p_sales_tax_geocode => l_sales_tax_geocode,
152: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
153: x_return_status => x_return_status);
154:
155: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
156:
157: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
158: fnd_msg_pub.add;
159:

Line 160: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

156:
157: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
158: fnd_msg_pub.add;
159:
160: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;

Line 161: RAISE FND_API.G_EXC_ERROR;

157: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
158: fnd_msg_pub.add;
159:
160: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:

Line 162: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

158: fnd_msg_pub.add;
159:
160: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166:

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159:
160: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;
162: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: END IF;
165:
166:
167: END IF;

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

193: p_sales_tax_geocode => l_sales_tax_geocode,
194: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
195: x_return_status => x_return_status);
196:
197: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
198:
199: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
200: fnd_msg_pub.add;
201:

Line 202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

198:
199: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
200: fnd_msg_pub.add;
201:
202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 203: RAISE FND_API.G_EXC_ERROR;

199: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
200: fnd_msg_pub.add;
201:
202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

Line 204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

200: fnd_msg_pub.add;
201:
202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201:
202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;
204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208:
209: END IF;

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

236: p_sales_tax_geocode => l_sales_tax_geocode,
237: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
238: x_return_status => x_return_status);
239:
240: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
241:
242: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
243: fnd_msg_pub.add;
244:

Line 245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

241:
242: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
243: fnd_msg_pub.add;
244:
245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
246: RAISE FND_API.G_EXC_ERROR;
247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;

Line 246: RAISE FND_API.G_EXC_ERROR;

242: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
243: fnd_msg_pub.add;
244:
245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
246: RAISE FND_API.G_EXC_ERROR;
247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:

Line 247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

243: fnd_msg_pub.add;
244:
245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
246: RAISE FND_API.G_EXC_ERROR;
247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251:

Line 248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

244:
245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
246: RAISE FND_API.G_EXC_ERROR;
247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251:
252: END IF;

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

259: l_start_date_active
260: ,l_end_date_active
261: ,x_return_status);
262:
263: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
264:
265: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 265: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

261: ,x_return_status);
262:
263: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
264:
265: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF X_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:
263: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
264:
265: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:

Line 267: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

263: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
264:
265: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:
271: END IF;

Line 268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

264:
265: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
266: RAISE FND_API.G_EXC_ERROR;
267: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
269: END IF;
270:
271: END IF;
272:

Line 280: RAISE fnd_api.g_exc_error;

276: CLOSE c_category;
277: fnd_message.set_name('JTF','JTF_RS_INVALID_RESOURCE');
278: fnd_message.set_token('P_RESOURCE_ID',l_resource_id);
279: fnd_msg_pub.add;
280: RAISE fnd_api.g_exc_error;
281: END IF;
282: CLOSE c_category;
283:
284: -- select to_number(decode(substrb(userenv('CLIENT_INFO'),1,1),' '

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289: -- dbms_output.put_line('Org id before validation : '|| l_org_id);
290: l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
291: IF l_org_id is NULL THEN
292: -- dbms_output.put_line('Org id is Null');
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: -- dbms_output.put_line('Org id is : '||l_org_id);
297:

Line 294: RAISE FND_API.G_EXC_ERROR;

290: l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
291: IF l_org_id is NULL THEN
292: -- dbms_output.put_line('Org id is Null');
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: -- dbms_output.put_line('Org id is : '||l_org_id);
297:
298: IF MO_UTILS.Get_Multi_Org_Flag = 'Y' and l_org_id is NULL THEN

Line 301: RAISE fnd_api.g_exc_error;

297:
298: IF MO_UTILS.Get_Multi_Org_Flag = 'Y' and l_org_id is NULL THEN
299: fnd_message.set_name('JTF','JTF_RS_ORG_CONTEXT_NOT_SET');
300: fnd_msg_pub.add;
301: RAISE fnd_api.g_exc_error;
302: END IF;
303:
304: -- l_org_id := fnd_profile.value('ORG_ID');
305:

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

306: /** IF (l_category = 'OTHER') OR (l_category = 'TBH') OR (l_category = 'EMPLOYEE') OR (l_category = 'PARTY') OR (l_category = 'PARTNER') OR (l_category = 'SUPPLIER_CONTACT') THEN **/
307: jtf_resource_utl.validate_salesrep_number(l_salesrep_number,
308: l_org_id,
309: x_return_status);
310: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

307: jtf_resource_utl.validate_salesrep_number(l_salesrep_number,
308: l_org_id,
309: x_return_status);
310: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;

Line 312: RAISE FND_API.G_EXC_ERROR;

308: l_org_id,
309: x_return_status);
310: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: END IF;

Line 313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

309: x_return_status);
310: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: END IF;
317: -- END IF;

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
311: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: END IF;
317: -- END IF;
318:

Line 325: RAISE fnd_api.g_exc_error;

321: IF c_dup_resource%FOUND THEN
322: CLOSE c_dup_resource;
323: fnd_message.set_name('JTF','JTF_RS_DUP_RES_SALESPERSON');
324: fnd_msg_pub.add;
325: RAISE fnd_api.g_exc_error;
326: END IF;
327: CLOSE c_dup_resource;
328:
329: /* This portion of the code was modified to accomodate the calls to Migration API */

Line 410: RAISE fnd_api.g_exc_error;

406:
407: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
408: fnd_msg_pub.add;
409:
410: RAISE fnd_api.g_exc_error;
411:
412: ELSE
413: x_salesrep_id := l_salesrep_id;
414: CLOSE c_jtf_rs_salesreps;

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

442: p_sales_tax_geocode => l_sales_tax_geocode,
443: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
444: x_return_status => x_return_status);
445:
446: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
447:
448: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
449: fnd_msg_pub.add;
450:

Line 451: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

447:
448: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
449: fnd_msg_pub.add;
450:
451: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;

Line 452: RAISE FND_API.G_EXC_ERROR;

448: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
449: fnd_msg_pub.add;
450:
451: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:

Line 453: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

449: fnd_msg_pub.add;
450:
451: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: END IF;

Line 454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

450:
451: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;
453: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
455: END IF;
456:
457: END IF;
458: END IF;

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

483: p_sales_tax_geocode => l_sales_tax_geocode,
484: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
485: x_return_status => x_return_status);
486:
487: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
488:
489: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
490: fnd_msg_pub.add;
491:

Line 492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

488:
489: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
490: fnd_msg_pub.add;
491:
492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;

Line 493: RAISE FND_API.G_EXC_ERROR;

489: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
490: fnd_msg_pub.add;
491:
492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:

Line 494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

490: fnd_msg_pub.add;
491:
492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498: END IF;

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491:
492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498: END IF;
499: END IF;

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

524: p_sales_tax_geocode => l_sales_tax_geocode,
525: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
526: x_return_status => x_return_status);
527:
528: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
529:
530: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
531: fnd_msg_pub.add;
532:

Line 533: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

529:
530: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
531: fnd_msg_pub.add;
532:
533: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;

Line 534: RAISE FND_API.G_EXC_ERROR;

530: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
531: fnd_msg_pub.add;
532:
533: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:

Line 535: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

531: fnd_msg_pub.add;
532:
533: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: END IF;

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532:
533: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;
535: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538:
539: END IF;
540: END IF;

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

573: p_bind_data_id => l_bind_data_id,
574: x_return_code => x_return_status);
575:
576:
577: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
578:
579:
580: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
581: fnd_msg_pub.add;

Line 583: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

579:
580: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
581: fnd_msg_pub.add;
582:
583: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;

Line 584: RAISE FND_API.G_EXC_ERROR;

580: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
581: fnd_msg_pub.add;
582:
583: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:

Line 585: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

581: fnd_msg_pub.add;
582:
583: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589:

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

582:
583: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589:
590: END IF;

Line 596: IF fnd_api.to_Boolean(p_commit) THEN

592: END IF;
593:
594: END IF;
595:
596: IF fnd_api.to_Boolean(p_commit) THEN
597: COMMIT WORK;
598: END IF;
599:
600: /* Standard call to get message count and if count is 1, get message info. */

Line 608: WHEN fnd_api.g_exc_error THEN

604: );
605:
606: EXCEPTION
607:
608: WHEN fnd_api.g_exc_error THEN
609: ROLLBACK TO create_salesrep_pvt;
610: x_return_status := fnd_api.g_ret_sts_error;
611: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
612: p_data => x_msg_data);

Line 610: x_return_status := fnd_api.g_ret_sts_error;

606: EXCEPTION
607:
608: WHEN fnd_api.g_exc_error THEN
609: ROLLBACK TO create_salesrep_pvt;
610: x_return_status := fnd_api.g_ret_sts_error;
611: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO create_salesrep_pvt;

Line 613: WHEN fnd_api.g_exc_unexpected_error THEN

609: ROLLBACK TO create_salesrep_pvt;
610: x_return_status := fnd_api.g_ret_sts_error;
611: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO create_salesrep_pvt;
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
617: p_data => x_msg_data);

Line 615: x_return_status := fnd_api.g_ret_sts_unexp_error;

611: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO create_salesrep_pvt;
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
617: p_data => x_msg_data);
618: WHEN OTHERS THEN
619: ROLLBACK TO create_salesrep_pvt;

Line 625: x_return_status := fnd_api.g_ret_sts_unexp_error;

621: fnd_message.set_token('P_SQLCODE',SQLCODE);
622: fnd_message.set_token('P_SQLERRM',SQLERRM);
623: fnd_message.set_token('P_API_NAME', l_api_name);
624: FND_MSG_PUB.add;
625: x_return_status := fnd_api.g_ret_sts_unexp_error;
626: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
627: p_data => x_msg_data);
628:
629: End Create_salesrep;

Line 796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,

792:
793: CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is
794: SELECT salesrep_id,
795: resource_id,
796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,

Line 797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,

793: CURSOR c_salesrep_update(l_salesrep_id jtf_rs_salesreps.salesrep_id%type, l_org_id jtf_rs_salesreps.org_id%type) is
794: SELECT salesrep_id,
795: resource_id,
796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,

Line 798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,

794: SELECT salesrep_id,
795: resource_id,
796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,

Line 799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,

795: resource_id,
796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,

Line 800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,

796: DECODE(p_sales_credit_type_id,fnd_api.g_miss_num,sales_credit_type_id,p_sales_credit_type_id) sales_credit_type_id,
797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,

Line 801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,

797: DECODE(p_name,fnd_api.g_miss_char,name,p_name) name,
798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,

Line 802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,

798: DECODE(p_status,fnd_api.g_miss_char,status,p_status) status,
799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,

Line 803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,

799: DECODE(p_start_date_active,fnd_api.g_miss_date,start_date_active,p_start_date_active) start_date_active,
800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,

Line 804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,

800: DECODE(p_end_date_active,fnd_api.g_miss_date,end_date_active,p_end_date_active) end_date_active,
801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
808: person_id,

Line 805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,

801: DECODE(p_gl_id_rev,fnd_api.g_miss_num,gl_id_rev,p_gl_id_rev) gl_id_rev,
802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
808: person_id,
809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,

Line 806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,

802: DECODE(p_gl_id_freight,fnd_api.g_miss_num,gl_id_freight,p_gl_id_freight) gl_id_freight,
803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
808: person_id,
809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,

Line 807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,

803: DECODE(p_gl_id_rec,fnd_api.g_miss_num,gl_id_rec,p_gl_id_rec) gl_id_rec,
804: DECODE(p_set_of_books_id,fnd_api.g_miss_num,set_of_books_id,p_set_of_books_id) set_of_books_id,
805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
808: person_id,
809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
811: org_id,

Line 809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,

805: DECODE(p_salesrep_number,fnd_api.g_miss_char,salesrep_number,p_salesrep_number) salesrep_number,
806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
808: person_id,
809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
811: org_id,
812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,

Line 810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,

806: DECODE(p_email_address,fnd_api.g_miss_char,email_address,p_email_address) email_address,
807: DECODE(p_wh_update_date,fnd_api.g_miss_date,wh_update_date,p_wh_update_date) wh_update_date,
808: person_id,
809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
811: org_id,
812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,

Line 812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,

808: person_id,
809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
811: org_id,
812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,

Line 813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,

809: DECODE(p_sales_tax_geocode,fnd_api.g_miss_char,sales_tax_geocode,p_sales_tax_geocode) sales_tax_geocode,
810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
811: org_id,
812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,

Line 814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,

810: DECODE(p_sales_tax_inside_city_limits,fnd_api.g_miss_char,sales_tax_inside_city_limits,p_sales_tax_inside_city_limits) sales_tax_inside_city_limits,
811: org_id,
812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,

Line 815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,

811: org_id,
812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,

Line 816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,

812: DECODE(p_object_version_number,fnd_api.g_miss_char,object_version_number,p_object_version_number) object_version_number,
813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,

Line 817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,

813: DECODE(p_attribute_category,fnd_api.g_miss_char,attribute_category,p_attribute_category) attribute_category,
814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,

Line 818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,

814: DECODE(p_attribute1,fnd_api.g_miss_char,attribute1,p_attribute1) attribute1,
815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,

Line 819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,

815: DECODE(p_attribute2,fnd_api.g_miss_char,attribute2,p_attribute2) attribute2,
816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,

Line 820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,

816: DECODE(p_attribute3,fnd_api.g_miss_char,attribute3,p_attribute3) attribute3,
817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,

Line 821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,

817: DECODE(p_attribute4,fnd_api.g_miss_char,attribute4,p_attribute4) attribute4,
818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,

Line 822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,

818: DECODE(p_attribute5,fnd_api.g_miss_char,attribute5,p_attribute5) attribute5,
819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,

Line 823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,

819: DECODE(p_attribute6,fnd_api.g_miss_char,attribute6,p_attribute6) attribute6,
820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,

Line 824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,

820: DECODE(p_attribute7,fnd_api.g_miss_char,attribute7,p_attribute7) attribute7,
821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15

Line 825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,

821: DECODE(p_attribute8,fnd_api.g_miss_char,attribute8,p_attribute8) attribute8,
822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15
829: FROM jtf_rs_salesreps

Line 826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,

822: DECODE(p_attribute9,fnd_api.g_miss_char,attribute9,p_attribute9) attribute9,
823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15
829: FROM jtf_rs_salesreps
830: WHERE salesrep_id = l_salesrep_id

Line 827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,

823: DECODE(p_attribute10,fnd_api.g_miss_char,attribute10,p_attribute10) attribute10,
824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15
829: FROM jtf_rs_salesreps
830: WHERE salesrep_id = l_salesrep_id
831: AND nvl(org_id,-99) = nvl(l_org_id,-99);

Line 828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15

824: DECODE(p_attribute11,fnd_api.g_miss_char,attribute11,p_attribute11) attribute11,
825: DECODE(p_attribute12,fnd_api.g_miss_char,attribute12,p_attribute12) attribute12,
826: DECODE(p_attribute13,fnd_api.g_miss_char,attribute13,p_attribute13) attribute13,
827: DECODE(p_attribute14,fnd_api.g_miss_char,attribute14,p_attribute14) attribute14,
828: DECODE(p_attribute15,fnd_api.g_miss_char,attribute15,p_attribute15) attribute15
829: FROM jtf_rs_salesreps
830: WHERE salesrep_id = l_salesrep_id
831: AND nvl(org_id,-99) = nvl(l_org_id,-99);
832: salesrep_rec c_salesrep_update%ROWTYPE;

Line 847: x_return_status := fnd_api.g_ret_sts_success;

843:
844:
845: SAVEPOINT update_salesrep_pvt;
846:
847: x_return_status := fnd_api.g_ret_sts_success;
848:
849: /* Standard call to check for call compatibility. */
850: IF NOT fnd_api.Compatible_api_call( l_api_version,
851: p_api_version,

Line 850: IF NOT fnd_api.Compatible_api_call( l_api_version,

846:
847: x_return_status := fnd_api.g_ret_sts_success;
848:
849: /* Standard call to check for call compatibility. */
850: IF NOT fnd_api.Compatible_api_call( l_api_version,
851: p_api_version,
852: l_api_name,
853: G_PKG_NAME)
854: THEN

Line 855: RAISE fnd_api.g_exc_unexpected_error;

851: p_api_version,
852: l_api_name,
853: G_PKG_NAME)
854: THEN
855: RAISE fnd_api.g_exc_unexpected_error;
856: END IF;
857:
858: IF fnd_api.to_Boolean(p_init_msg_list) THEN
859: fnd_msg_pub.initialize;

Line 858: IF fnd_api.to_Boolean(p_init_msg_list) THEN

854: THEN
855: RAISE fnd_api.g_exc_unexpected_error;
856: END IF;
857:
858: IF fnd_api.to_Boolean(p_init_msg_list) THEN
859: fnd_msg_pub.initialize;
860: END IF;
861:
862:

Line 867: x_return_status := FND_API.G_RET_STS_ERROR;

863: -- dbms_output.put_line('Org id before validation : '|| l_org_id);
864: l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
865: IF l_org_id is NULL THEN
866: -- dbms_output.put_line('Org id is Null');
867: x_return_status := FND_API.G_RET_STS_ERROR;
868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870: -- dbms_output.put_line('Org id is : '||l_org_id);
871:

Line 868: RAISE FND_API.G_EXC_ERROR;

864: l_org_id := MO_GLOBAL.get_valid_org(p_org_id);
865: IF l_org_id is NULL THEN
866: -- dbms_output.put_line('Org id is Null');
867: x_return_status := FND_API.G_RET_STS_ERROR;
868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870: -- dbms_output.put_line('Org id is : '||l_org_id);
871:
872: /* Make the pre processing call to the user hooks */

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

896: p_sales_tax_geocode => l_sales_tax_geocode,
897: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
898: x_return_status => x_return_status);
899:
900: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
901:
902: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
903: fnd_msg_pub.add;
904: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

Line 904: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

900: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
901:
902: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
903: fnd_msg_pub.add;
904: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;

Line 905: RAISE FND_API.G_EXC_ERROR;

901:
902: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
903: fnd_msg_pub.add;
904: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909:

Line 906: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

902: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
903: fnd_msg_pub.add;
904: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909:
910: END IF;

Line 907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

903: fnd_msg_pub.add;
904: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
908: END IF;
909:
910: END IF;
911: END IF;

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

936: p_sales_tax_geocode => l_sales_tax_geocode,
937: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
938: x_return_status => x_return_status);
939:
940: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
941:
942: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
943: fnd_msg_pub.add;
944:

Line 945: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

941:
942: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
943: fnd_msg_pub.add;
944:
945: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;

Line 946: RAISE FND_API.G_EXC_ERROR;

942: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
943: fnd_msg_pub.add;
944:
945: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;
950:

Line 947: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

943: fnd_msg_pub.add;
944:
945: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;
950:
951: END IF;

Line 948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

944:
945: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
946: RAISE FND_API.G_EXC_ERROR;
947: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
949: END IF;
950:
951: END IF;
952: END IF;

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

978: p_sales_tax_geocode => l_sales_tax_geocode,
979: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
980: x_return_status => x_return_status);
981:
982: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
983:
984: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
985: fnd_msg_pub.add;
986:

Line 987: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

983:
984: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
985: fnd_msg_pub.add;
986:
987: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END IF;

Line 988: RAISE FND_API.G_EXC_ERROR;

984: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
985: fnd_msg_pub.add;
986:
987: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END IF;
992:

Line 989: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

985: fnd_msg_pub.add;
986:
987: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END IF;
992:
993: END IF;

Line 990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

986:
987: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
988: RAISE FND_API.G_EXC_ERROR;
989: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
991: END IF;
992:
993: END IF;
994: END IF;

Line 1008: RAISE fnd_api.g_exc_error;

1004: CLOSE c_salesrep_update;
1005: fnd_message.set_name('JTF','JTF_RS_INVALID_SALESREP_ID');
1006: fnd_message.set_token('P_SALESREP_ID',l_salesrep_id);
1007: fnd_msg_pub.add;
1008: RAISE fnd_api.g_exc_error;
1009:
1010: END IF;
1011:
1012:

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

1016: jtf_resource_utl.validate_input_dates(
1017: l_start_date_active
1018: ,l_end_date_active
1019: ,x_return_status);
1020: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1021: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1017: l_start_date_active
1018: ,l_end_date_active
1019: ,x_return_status);
1020: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: ELSIF X_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_end_date_active
1019: ,x_return_status);
1020: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: END IF;
1026:

Line 1023: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1019: ,x_return_status);
1020: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: END IF;
1026:
1027: END IF;

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1020: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1021: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1022: RAISE FND_API.G_EXC_ERROR;
1023: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: END IF;
1026:
1027: END IF;
1028:

Line 1038: RAISE fnd_api.g_exc_error;

1034: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');
1035: fnd_message.set_token('P_SALESREP_NUMBER', l_salesrep_number);
1036: fnd_msg_pub.add;
1037: CLOSE c_salesrep_number;
1038: RAISE fnd_api.g_exc_error;
1039: END IF;
1040: CLOSE c_salesrep_number;
1041: ELSE
1042: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_NUMBER_NULL');

Line 1045: RAISE fnd_api.g_exc_error;

1041: ELSE
1042: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_NUMBER_NULL');
1043: fnd_msg_pub.add;
1044: CLOSE c_salesrep_number;
1045: RAISE fnd_api.g_exc_error;
1046:
1047: END IF;
1048:
1049: /* Locking the row before updating */

Line 1060: RAISE fnd_api.g_exc_error;

1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1059: fnd_msg_pub.add;
1060: RAISE fnd_api.g_exc_error;
1061: END;
1062:
1063:
1064: BEGIN

Line 1123: RAISE fnd_api.g_exc_error;

1119:
1120: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1121: fnd_msg_pub.add;
1122:
1123: RAISE fnd_api.g_exc_error;
1124:
1125: END;
1126:
1127: CLOSE c_salesrep_update;

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

1153: p_sales_tax_geocode => l_sales_tax_geocode,
1154: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
1155: x_return_status => x_return_status);
1156:
1157: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1158:
1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:

Line 1162: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1158:
1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:
1162: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;

Line 1163: RAISE FND_API.G_EXC_ERROR;

1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:
1162: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:

Line 1164: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1160: fnd_msg_pub.add;
1161:
1162: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:
1168: END IF;

Line 1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161:
1162: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1163: RAISE FND_API.G_EXC_ERROR;
1164: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167:
1168: END IF;
1169: END IF;

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

1193: p_sales_tax_geocode => l_sales_tax_geocode,
1194: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
1195: x_return_status => x_return_status);
1196:
1197: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1198:
1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:

Line 1202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1198:
1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:
1202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: ELSIF X_RETURN_STATUS = 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 X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207:

Line 1204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1200: fnd_msg_pub.add;
1201:
1202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207:
1208: END IF;

Line 1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1201:
1202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;
1204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206: END IF;
1207:
1208: END IF;
1209: END IF;

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

1233: p_sales_tax_geocode => l_sales_tax_geocode,
1234: p_sales_tax_inside_city_limits => l_sales_tax_inside_city_limits,
1235: x_return_status => x_return_status);
1236:
1237: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1238:
1239: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1240: fnd_msg_pub.add;
1241:

Line 1242: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1238:
1239: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1240: fnd_msg_pub.add;
1241:
1242: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1243: RAISE FND_API.G_EXC_ERROR;
1244: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;

Line 1243: RAISE FND_API.G_EXC_ERROR;

1239: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1240: fnd_msg_pub.add;
1241:
1242: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1243: RAISE FND_API.G_EXC_ERROR;
1244: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247:

Line 1244: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1240: fnd_msg_pub.add;
1241:
1242: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1243: RAISE FND_API.G_EXC_ERROR;
1244: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247:
1248: END IF;

Line 1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1241:
1242: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1243: RAISE FND_API.G_EXC_ERROR;
1244: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1246: END IF;
1247:
1248: END IF;
1249: END IF;

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

1281: p_bind_data_id => l_bind_data_id,
1282: x_return_code => x_return_status);
1283:
1284:
1285: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1286:
1287:
1288: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1289: fnd_msg_pub.add;

Line 1291: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1287:
1288: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1289: fnd_msg_pub.add;
1290:
1291: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;

Line 1292: RAISE FND_API.G_EXC_ERROR;

1288: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1289: fnd_msg_pub.add;
1290:
1291: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296:

Line 1293: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1289: fnd_msg_pub.add;
1290:
1291: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296:
1297:

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1290:
1291: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1292: RAISE FND_API.G_EXC_ERROR;
1293: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296:
1297:
1298: END IF;

Line 1304: IF fnd_api.to_Boolean(p_commit) THEN

1300: END IF;
1301:
1302: END IF;
1303:
1304: IF fnd_api.to_Boolean(p_commit) THEN
1305: COMMIT WORK;
1306: END IF;
1307:
1308: /* Standard call to get message count and if count is 1, get message info. */

Line 1315: WHEN fnd_api.g_exc_error THEN

1311: p_data => x_msg_data
1312: );
1313:
1314: EXCEPTION
1315: WHEN fnd_api.g_exc_error THEN
1316: ROLLBACK TO update_salesrep_pvt;
1317: x_return_status := fnd_api.g_ret_sts_error;
1318: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1319: p_data => x_msg_data);

Line 1317: x_return_status := fnd_api.g_ret_sts_error;

1313:
1314: EXCEPTION
1315: WHEN fnd_api.g_exc_error THEN
1316: ROLLBACK TO update_salesrep_pvt;
1317: x_return_status := fnd_api.g_ret_sts_error;
1318: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1319: p_data => x_msg_data);
1320: WHEN fnd_api.g_exc_unexpected_error THEN
1321: ROLLBACK TO update_salesrep_pvt;

Line 1320: WHEN fnd_api.g_exc_unexpected_error THEN

1316: ROLLBACK TO update_salesrep_pvt;
1317: x_return_status := fnd_api.g_ret_sts_error;
1318: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1319: p_data => x_msg_data);
1320: WHEN fnd_api.g_exc_unexpected_error THEN
1321: ROLLBACK TO update_salesrep_pvt;
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1324: p_data => x_msg_data);

Line 1322: x_return_status := fnd_api.g_ret_sts_unexp_error;

1318: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1319: p_data => x_msg_data);
1320: WHEN fnd_api.g_exc_unexpected_error THEN
1321: ROLLBACK TO update_salesrep_pvt;
1322: x_return_status := fnd_api.g_ret_sts_unexp_error;
1323: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1324: p_data => x_msg_data);
1325: WHEN OTHERS THEN
1326: ROLLBACK TO update_salesrep_pvt;

Line 1332: x_return_status := fnd_api.g_ret_sts_unexp_error;

1328: fnd_message.set_token('P_SQLCODE',SQLCODE);
1329: fnd_message.set_token('P_SQLERRM',SQLERRM);
1330: fnd_message.set_token('P_API_NAME', l_api_name);
1331: FND_MSG_PUB.add;
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1334: p_data => x_msg_data);
1335:
1336: End update_salesrep;