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: --Bug11719792
1012: --In Salesrep Update mode when there is no value in p_start_date_active parameter

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

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

Line 1024: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 1025: RAISE FND_API.G_EXC_ERROR;

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

Line 1026: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1041: RAISE fnd_api.g_exc_error;

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

Line 1048: RAISE fnd_api.g_exc_error;

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

Line 1063: RAISE fnd_api.g_exc_error;

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

Line 1126: RAISE fnd_api.g_exc_error;

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

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

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

Line 1165: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 1166: RAISE FND_API.G_EXC_ERROR;

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

Line 1167: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1163: fnd_msg_pub.add;
1164:
1165: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1166: RAISE FND_API.G_EXC_ERROR;
1167: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: END IF;
1170:
1171: END IF;

Line 1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1164:
1165: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1166: RAISE FND_API.G_EXC_ERROR;
1167: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: END IF;
1170:
1171: END IF;
1172: END IF;

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

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

Line 1205: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

1201:
1202: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1203: fnd_msg_pub.add;
1204:
1205: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1203: fnd_msg_pub.add;
1204:
1205: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;
1210:

Line 1207: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1203: fnd_msg_pub.add;
1204:
1205: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;
1210:
1211: END IF;

Line 1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1204:
1205: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: END IF;
1210:
1211: END IF;
1212: END IF;

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

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

Line 1245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 1246: RAISE FND_API.G_EXC_ERROR;

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

Line 1247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1243: fnd_msg_pub.add;
1244:
1245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250:
1251: END IF;

Line 1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1244:
1245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1246: RAISE FND_API.G_EXC_ERROR;
1247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250:
1251: END IF;
1252: END IF;

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

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

Line 1294: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

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

Line 1295: RAISE FND_API.G_EXC_ERROR;

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

Line 1296: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

1292: fnd_msg_pub.add;
1293:
1294: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1295: RAISE FND_API.G_EXC_ERROR;
1296: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1298: END IF;
1299:
1300:

Line 1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1293:
1294: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1295: RAISE FND_API.G_EXC_ERROR;
1296: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN
1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1298: END IF;
1299:
1300:
1301: END IF;

Line 1307: IF fnd_api.to_Boolean(p_commit) THEN

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

Line 1318: WHEN fnd_api.g_exc_error THEN

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

Line 1320: x_return_status := fnd_api.g_ret_sts_error;

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

Line 1323: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1325: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1335: x_return_status := fnd_api.g_ret_sts_unexp_error;

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