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_SRP_TERRITORIES_PVT dependencies on FND_MESSAGE

Line 145: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

141: );
142:
143: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error;
145: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
146: fnd_msg_pub.add;
147: RAISE fnd_api.g_exc_unexpected_error;
148: END IF;
149: END IF;

Line 173: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

169: );
170:
171: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
172: x_return_status := fnd_api.g_ret_sts_unexp_error;
173: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_unexpected_error;
176: END IF;
177: END IF;

Line 200: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

196: X_MSG_DATA => x_msg_data
197: );
198: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
199: x_return_status := fnd_api.g_ret_sts_unexp_error;
200: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
201: fnd_msg_pub.add;
202: RAISE fnd_api.g_exc_unexpected_error;
203: END IF;
204: END IF;

Line 219: fnd_message.set_name('JTF', 'JTF_RS_SRP_TERR_ID_EXISTS');

215:
216: IF l_check_count > 0 THEN
217: --dbms_output.put_line('Salesrep Territory Id already exists for the given Salesrep Id and Territory Id');
218: x_return_status := fnd_api.g_ret_sts_error;
219: fnd_message.set_name('JTF', 'JTF_RS_SRP_TERR_ID_EXISTS');
220: fnd_msg_pub.add;
221: RAISE fnd_api.g_exc_unexpected_error;
222: END IF;
223:

Line 242: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');

238: FETCH c_salesrep_details INTO l_salesrep_start_date, l_salesrep_end_date;
239: IF c_salesrep_details%NOTFOUND THEN
240: --dbms_output.put_line('Salesrep information not found');
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
243: fnd_message.set_token('P_SALESREP_ID', l_salesrep_id);
244: fnd_msg_pub.add;
245: CLOSE c_salesrep_details;
246: RAISE fnd_api.g_exc_unexpected_error;

Line 243: fnd_message.set_token('P_SALESREP_ID', l_salesrep_id);

239: IF c_salesrep_details%NOTFOUND THEN
240: --dbms_output.put_line('Salesrep information not found');
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
243: fnd_message.set_token('P_SALESREP_ID', l_salesrep_id);
244: fnd_msg_pub.add;
245: CLOSE c_salesrep_details;
246: RAISE fnd_api.g_exc_unexpected_error;
247: END IF;

Line 253: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');

249: --Validate that the Salesrep start date is less than the passed start date active
250: IF l_start_date_active < l_salesrep_start_date THEN
251: --dbms_output.put_line('Start date active cannot be less than Salesrep Start Date');
252: x_return_status := fnd_api.g_ret_sts_error;
253: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');
254: fnd_message.set_token('P_SALESREP_START_DATE', l_salesrep_start_date);
255: fnd_msg_pub.add;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;

Line 254: fnd_message.set_token('P_SALESREP_START_DATE', l_salesrep_start_date);

250: IF l_start_date_active < l_salesrep_start_date THEN
251: --dbms_output.put_line('Start date active cannot be less than Salesrep Start Date');
252: x_return_status := fnd_api.g_ret_sts_error;
253: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');
254: fnd_message.set_token('P_SALESREP_START_DATE', l_salesrep_start_date);
255: fnd_msg_pub.add;
256: RAISE fnd_api.g_exc_unexpected_error;
257: END IF;
258:

Line 264: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');

260: IF l_salesrep_end_date is NOT NULL THEN
261: IF l_end_date_active is NULL THEN
262: --dbms_output.put_line ('End date active cannot be Null as Salesrep has an End date');
263: x_return_status := fnd_api.g_ret_sts_error;
264: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');
265: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
266: fnd_msg_pub.add;
267: RAISE fnd_api.g_exc_unexpected_error;
268: ELSIF p_end_date_active > l_salesrep_end_date THEN

Line 265: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);

261: IF l_end_date_active is NULL THEN
262: --dbms_output.put_line ('End date active cannot be Null as Salesrep has an End date');
263: x_return_status := fnd_api.g_ret_sts_error;
264: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');
265: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
266: fnd_msg_pub.add;
267: RAISE fnd_api.g_exc_unexpected_error;
268: ELSIF p_end_date_active > l_salesrep_end_date THEN
269: --dbms_output.put_line('End date active cannot be greater than Salesrep End Date');

Line 271: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');

267: RAISE fnd_api.g_exc_unexpected_error;
268: ELSIF p_end_date_active > l_salesrep_end_date THEN
269: --dbms_output.put_line('End date active cannot be greater than Salesrep End Date');
270: x_return_status := fnd_api.g_ret_sts_error;
271: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');
272: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
273: fnd_msg_pub.add;
274: RAISE fnd_api.g_exc_unexpected_error;
275: END IF;

Line 272: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);

268: ELSIF p_end_date_active > l_salesrep_end_date THEN
269: --dbms_output.put_line('End date active cannot be greater than Salesrep End Date');
270: x_return_status := fnd_api.g_ret_sts_error;
271: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');
272: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
273: fnd_msg_pub.add;
274: RAISE fnd_api.g_exc_unexpected_error;
275: END IF;
276: END IF;

Line 284: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TERRITORY_ID');

280: FETCH c_territory_details INTO l_territory_start_date, l_territory_end_date;
281: IF c_territory_details%NOTFOUND THEN
282: --dbms_output.put_line('Territory information not found');
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TERRITORY_ID');
285: fnd_message.set_token('P_TERRITORY_ID', p_territory_id);
286: fnd_msg_pub.add;
287: CLOSE c_territory_details;
288: RAISE fnd_api.g_exc_unexpected_error;

Line 285: fnd_message.set_token('P_TERRITORY_ID', p_territory_id);

281: IF c_territory_details%NOTFOUND THEN
282: --dbms_output.put_line('Territory information not found');
283: x_return_status := fnd_api.g_ret_sts_unexp_error;
284: fnd_message.set_name('JTF', 'JTF_RS_INVALID_TERRITORY_ID');
285: fnd_message.set_token('P_TERRITORY_ID', p_territory_id);
286: fnd_msg_pub.add;
287: CLOSE c_territory_details;
288: RAISE fnd_api.g_exc_unexpected_error;
289: END IF;

Line 295: fnd_message.set_name('JTF', 'JTF_RS_TER_INVALID_START_DATE');

291: --Validate that the Territory start date is less than the passed start date active
292: IF p_start_date_active < l_territory_start_date THEN
293: --dbms_output.put_line('Start date active cannot be less than Territory Start Date');
294: x_return_status := fnd_api.g_ret_sts_error;
295: fnd_message.set_name('JTF', 'JTF_RS_TER_INVALID_START_DATE');
296: fnd_message.set_token('P_TERRITORY_START_DATE', l_territory_start_date);
297: fnd_msg_pub.add;
298: RAISE fnd_api.g_exc_unexpected_error;
299: END IF;

Line 296: fnd_message.set_token('P_TERRITORY_START_DATE', l_territory_start_date);

292: IF p_start_date_active < l_territory_start_date THEN
293: --dbms_output.put_line('Start date active cannot be less than Territory Start Date');
294: x_return_status := fnd_api.g_ret_sts_error;
295: fnd_message.set_name('JTF', 'JTF_RS_TER_INVALID_START_DATE');
296: fnd_message.set_token('P_TERRITORY_START_DATE', l_territory_start_date);
297: fnd_msg_pub.add;
298: RAISE fnd_api.g_exc_unexpected_error;
299: END IF;
300:

Line 306: fnd_message.set_name('JTF', 'JTF_RS_TER_END_DATE_NULL');

302: IF l_territory_end_date is NOT NULL THEN
303: IF l_end_date_active is NULL THEN
304: --dbms_output.put_line ('End date active cannot be Null as Territory has an End date');
305: x_return_status := fnd_api.g_ret_sts_error;
306: fnd_message.set_name('JTF', 'JTF_RS_TER_END_DATE_NULL');
307: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
308: fnd_msg_pub.add;
309: RAISE fnd_api.g_exc_unexpected_error;
310: ELSIF l_end_date_active > l_territory_end_date THEN

Line 307: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);

303: IF l_end_date_active is NULL THEN
304: --dbms_output.put_line ('End date active cannot be Null as Territory has an End date');
305: x_return_status := fnd_api.g_ret_sts_error;
306: fnd_message.set_name('JTF', 'JTF_RS_TER_END_DATE_NULL');
307: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
308: fnd_msg_pub.add;
309: RAISE fnd_api.g_exc_unexpected_error;
310: ELSIF l_end_date_active > l_territory_end_date THEN
311: --dbms_output.put_line('End date active cannot be greater than Territory End Date');

Line 313: fnd_message.set_name('JTF', 'JTF_RS_TER_INVALID_END_DATE');

309: RAISE fnd_api.g_exc_unexpected_error;
310: ELSIF l_end_date_active > l_territory_end_date THEN
311: --dbms_output.put_line('End date active cannot be greater than Territory End Date');
312: x_return_status := fnd_api.g_ret_sts_error;
313: fnd_message.set_name('JTF', 'JTF_RS_TER_INVALID_END_DATE');
314: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
315: fnd_msg_pub.add;
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;

Line 314: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);

310: ELSIF l_end_date_active > l_territory_end_date THEN
311: --dbms_output.put_line('End date active cannot be greater than Territory End Date');
312: x_return_status := fnd_api.g_ret_sts_error;
313: fnd_message.set_name('JTF', 'JTF_RS_TER_INVALID_END_DATE');
314: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
315: fnd_msg_pub.add;
316: RAISE fnd_api.g_exc_unexpected_error;
317: END IF;
318: END IF;

Line 364: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

360: FETCH c_jtf_rs_srp_territories INTO l_check_char;
361: IF c_jtf_rs_srp_territories%NOTFOUND THEN
362: --dbms_output.put_line('Error in Table Handler');
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
365: fnd_msg_pub.add;
366: CLOSE c_jtf_rs_srp_territories;
367: RAISE fnd_api.g_exc_unexpected_error;
368: ELSE

Line 403: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

399: );
400:
401: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
404: fnd_msg_pub.add;
405: RAISE fnd_api.g_exc_unexpected_error;
406: END IF;
407: END IF;

Line 432: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

428: );
429:
430: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
433: fnd_msg_pub.add;
434: RAISE fnd_api.g_exc_unexpected_error;
435: END IF;
436: END IF;

Line 460: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

456: X_MSG_DATA => x_msg_data
457: );
458: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
459: x_return_status := fnd_api.g_ret_sts_unexp_error;
460: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
461: fnd_msg_pub.add;
462: RAISE fnd_api.g_exc_unexpected_error;
463: END IF;
464: END IF;

Line 496: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

492:
493: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
494: --dbms_output.put_line('Returned Error status from the Message Generation API');
495: x_return_status := fnd_api.g_ret_sts_unexp_error;
496: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
497: fnd_msg_pub.add;
498: RAISE fnd_api.g_exc_unexpected_error;
499: END IF;
500: END IF;

Line 676: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');

672: );
673:
674: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
675: x_return_status := fnd_api.g_ret_sts_unexp_error;
676: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_CUST_USR_HOOK');
677: fnd_msg_pub.add;
678: RAISE fnd_api.g_exc_unexpected_error;
679: END IF;
680: END IF;

Line 703: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');

699: );
700:
701: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_VERT_USR_HOOK');
704: fnd_msg_pub.add;
705: RAISE fnd_api.g_exc_unexpected_error;
706: END IF;
707: END IF;

Line 730: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');

726: );
727:
728: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
729: x_return_status := fnd_api.g_ret_sts_unexp_error;
730: fnd_message.set_name('JTF', 'JTF_RS_ERR_PRE_INT_USR_HOOK');
731: fnd_msg_pub.add;
732: RAISE fnd_api.g_exc_unexpected_error;
733: END IF;
734: END IF;

Line 743: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');

739: FETCH c_salesrep_territory_id INTO l_salesrep_id, l_territory_id;
740: IF c_salesrep_territory_id%NOTFOUND THEN
741: --dbms_output.put_line('Salesrep Id, Territory Id do not exist for the given Salesrep Territory Id');
742: CLOSE c_salesrep_territory_id;
743: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
744: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
745: fnd_msg_pub.add;
746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: RAISE fnd_api.g_exc_unexpected_error;

Line 744: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);

740: IF c_salesrep_territory_id%NOTFOUND THEN
741: --dbms_output.put_line('Salesrep Id, Territory Id do not exist for the given Salesrep Territory Id');
742: CLOSE c_salesrep_territory_id;
743: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
744: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
745: fnd_msg_pub.add;
746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: RAISE fnd_api.g_exc_unexpected_error;
748: END IF;

Line 755: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');

751: OPEN c_salesrep_territory_update(l_salesrep_territory_id);
752: FETCH c_salesrep_territory_update INTO salesrep_territory_rec;
753: IF c_salesrep_territory_update%NOTFOUND THEN
754: CLOSE c_salesrep_territory_update;
755: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
756: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
757: fnd_msg_pub.add;
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759: RAISE fnd_api.g_exc_unexpected_error;

Line 756: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);

752: FETCH c_salesrep_territory_update INTO salesrep_territory_rec;
753: IF c_salesrep_territory_update%NOTFOUND THEN
754: CLOSE c_salesrep_territory_update;
755: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
756: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
757: fnd_msg_pub.add;
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759: RAISE fnd_api.g_exc_unexpected_error;
760: END IF;

Line 782: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');

778: FETCH c_salesrep_details INTO l_salesrep_start_date, l_salesrep_end_date;
779: IF c_salesrep_details%NOTFOUND THEN
780: --dbms_output.put_line('Salesrep information not found for the given Salesrep Territory Id');
781: x_return_status := fnd_api.g_ret_sts_unexp_error;
782: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
783: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
784: fnd_msg_pub.add;
785: CLOSE c_salesrep_details;
786: RAISE fnd_api.g_exc_unexpected_error;

Line 783: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);

779: IF c_salesrep_details%NOTFOUND THEN
780: --dbms_output.put_line('Salesrep information not found for the given Salesrep Territory Id');
781: x_return_status := fnd_api.g_ret_sts_unexp_error;
782: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
783: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
784: fnd_msg_pub.add;
785: CLOSE c_salesrep_details;
786: RAISE fnd_api.g_exc_unexpected_error;
787: END IF;

Line 794: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');

790: IF p_start_date_active <>FND_API.G_MISS_DATE THEN
791: IF l_start_date_active < l_salesrep_start_date THEN
792: --dbms_output.put_line('Start date active cannot be less than Salesrep Start Date');
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');
795: fnd_message.set_token('P_SALESREP_START_DATE', l_salesrep_start_date);
796: fnd_msg_pub.add;
797: RAISE fnd_api.g_exc_unexpected_error;
798: END IF;

Line 795: fnd_message.set_token('P_SALESREP_START_DATE', l_salesrep_start_date);

791: IF l_start_date_active < l_salesrep_start_date THEN
792: --dbms_output.put_line('Start date active cannot be less than Salesrep Start Date');
793: x_return_status := fnd_api.g_ret_sts_error;
794: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');
795: fnd_message.set_token('P_SALESREP_START_DATE', l_salesrep_start_date);
796: fnd_msg_pub.add;
797: RAISE fnd_api.g_exc_unexpected_error;
798: END IF;
799: END IF;

Line 807: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');

803: IF l_salesrep_end_date is NOT NULL THEN
804: IF l_end_date_active is NULL THEN
805: --dbms_output.put_line ('End date active cannot be Null as Salesrep has an End date');
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');
808: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
809: fnd_msg_pub.add;
810: RAISE fnd_api.g_exc_unexpected_error;
811: ELSIF l_end_date_active > l_salesrep_end_date THEN

Line 808: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);

804: IF l_end_date_active is NULL THEN
805: --dbms_output.put_line ('End date active cannot be Null as Salesrep has an End date');
806: x_return_status := fnd_api.g_ret_sts_error;
807: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');
808: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
809: fnd_msg_pub.add;
810: RAISE fnd_api.g_exc_unexpected_error;
811: ELSIF l_end_date_active > l_salesrep_end_date THEN
812: --dbms_output.put_line('End date active cannot be greater than Salesrep End Date');

Line 814: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');

810: RAISE fnd_api.g_exc_unexpected_error;
811: ELSIF l_end_date_active > l_salesrep_end_date THEN
812: --dbms_output.put_line('End date active cannot be greater than Salesrep End Date');
813: x_return_status := fnd_api.g_ret_sts_error;
814: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');
815: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
816: fnd_msg_pub.add;
817: RAISE fnd_api.g_exc_unexpected_error;
818: END IF;

Line 815: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);

811: ELSIF l_end_date_active > l_salesrep_end_date THEN
812: --dbms_output.put_line('End date active cannot be greater than Salesrep End Date');
813: x_return_status := fnd_api.g_ret_sts_error;
814: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');
815: fnd_message.set_token('P_SALESREP_END_DATE', l_salesrep_end_date);
816: fnd_msg_pub.add;
817: RAISE fnd_api.g_exc_unexpected_error;
818: END IF;
819: END IF;

Line 828: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');

824: FETCH c_territory_details INTO l_territory_start_date, l_territory_end_date;
825: IF c_territory_details%NOTFOUND THEN
826: --dbms_output.put_line('Territory information not found');
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
829: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
830: fnd_msg_pub.add;
831: CLOSE c_territory_details;
832: RAISE fnd_api.g_exc_unexpected_error;

Line 829: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);

825: IF c_territory_details%NOTFOUND THEN
826: --dbms_output.put_line('Territory information not found');
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SRP_TERR_ID');
829: fnd_message.set_token('P_SALESREP_TERRITORY_ID', l_salesrep_territory_id);
830: fnd_msg_pub.add;
831: CLOSE c_territory_details;
832: RAISE fnd_api.g_exc_unexpected_error;
833: END IF;

Line 840: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');

836: IF p_start_date_active <>FND_API.G_MISS_DATE THEN
837: IF l_start_date_active < l_territory_start_date THEN
838: --dbms_output.put_line('Start date active cannot be less than Territory Start Date');
839: x_return_status := fnd_api.g_ret_sts_error;
840: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');
841: fnd_message.set_token('P_TERRITORY_START_DATE', l_territory_start_date);
842: fnd_msg_pub.add;
843: RAISE fnd_api.g_exc_unexpected_error;
844: END IF;

Line 841: fnd_message.set_token('P_TERRITORY_START_DATE', l_territory_start_date);

837: IF l_start_date_active < l_territory_start_date THEN
838: --dbms_output.put_line('Start date active cannot be less than Territory Start Date');
839: x_return_status := fnd_api.g_ret_sts_error;
840: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_START_DATE');
841: fnd_message.set_token('P_TERRITORY_START_DATE', l_territory_start_date);
842: fnd_msg_pub.add;
843: RAISE fnd_api.g_exc_unexpected_error;
844: END IF;
845: END IF;

Line 853: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');

849: IF l_territory_end_date is NOT NULL THEN
850: IF l_end_date_active is NULL THEN
851: --dbms_output.put_line ('End date active cannot be Null as Territory has an End date');
852: x_return_status := fnd_api.g_ret_sts_error;
853: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');
854: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
855: fnd_msg_pub.add;
856: RAISE fnd_api.g_exc_unexpected_error;
857: ELSIF p_end_date_active > l_territory_end_date THEN

Line 854: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);

850: IF l_end_date_active is NULL THEN
851: --dbms_output.put_line ('End date active cannot be Null as Territory has an End date');
852: x_return_status := fnd_api.g_ret_sts_error;
853: fnd_message.set_name('JTF', 'JTF_RS_SRP_END_DATE_NULL');
854: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
855: fnd_msg_pub.add;
856: RAISE fnd_api.g_exc_unexpected_error;
857: ELSIF p_end_date_active > l_territory_end_date THEN
858: --dbms_output.put_line('End date active cannot be greater than Territory End Date');

Line 860: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');

856: RAISE fnd_api.g_exc_unexpected_error;
857: ELSIF p_end_date_active > l_territory_end_date THEN
858: --dbms_output.put_line('End date active cannot be greater than Territory End Date');
859: x_return_status := fnd_api.g_ret_sts_error;
860: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');
861: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
862: fnd_msg_pub.add;
863: RAISE fnd_api.g_exc_unexpected_error;
864: END IF;

Line 861: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);

857: ELSIF p_end_date_active > l_territory_end_date THEN
858: --dbms_output.put_line('End date active cannot be greater than Territory End Date');
859: x_return_status := fnd_api.g_ret_sts_error;
860: fnd_message.set_name('JTF', 'JTF_RS_SRP_INVALID_END_DATE');
861: fnd_message.set_token('P_TERRITORY_END_DATE', l_territory_end_date);
862: fnd_msg_pub.add;
863: RAISE fnd_api.g_exc_unexpected_error;
864: END IF;
865: END IF;

Line 917: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');

913: WHEN NO_DATA_FOUND THEN
914: --dbms_output.put_line('Error in Table Handler');
915: CLOSE c_salesrep_territory_update;
916: x_return_status := fnd_api.g_ret_sts_unexp_error;
917: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
918: fnd_msg_pub.add;
919: RAISE fnd_api.g_exc_unexpected_error;
920: END;
921: --dbms_output.put_line('Salesrep Territory Successfully Updated');

Line 952: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');

948: );
949:
950: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
951: x_return_status := fnd_api.g_ret_sts_unexp_error;
952: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
953: fnd_msg_pub.add;
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956: END IF;

Line 979: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');

975: );
976:
977: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
980: fnd_msg_pub.add;
981: RAISE fnd_api.g_exc_unexpected_error;
982: END IF;
983: END IF;

Line 1006: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');

1002: );
1003:
1004: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1005: x_return_status := fnd_api.g_ret_sts_unexp_error;
1006: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1007: fnd_msg_pub.add;
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF;
1010: END IF;

Line 1041: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');

1037:
1038: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1039: --dbms_output.put_line('Returned Error status from the Message Generation API');
1040: x_return_status := fnd_api.g_ret_sts_unexp_error;
1041: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1042: fnd_msg_pub.add;
1043: RAISE fnd_api.g_exc_unexpected_error;
1044: END IF;
1045: END IF;