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_MSG_PUB

Line 118: fnd_msg_pub.initialize;

114: RAISE fnd_api.g_exc_unexpected_error;
115: END IF;
116:
117: IF fnd_api.to_boolean(p_init_msg_list) THEN
118: fnd_msg_pub.initialize;
119: END IF;
120:
121: --Make the pre processing call to the user hooks
122:

Line 146: fnd_msg_pub.add;

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;
150:

Line 174: fnd_msg_pub.add;

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;
178:

Line 201: fnd_msg_pub.add;

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;
205:

Line 220: fnd_msg_pub.add;

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:
224: --Date Validations

Line 244: fnd_msg_pub.add;

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;
248:

Line 255: fnd_msg_pub.add;

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:
259: --Validate that the passed end date is not Null and less than Salesrep End Date

Line 266: fnd_msg_pub.add;

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');
270: x_return_status := fnd_api.g_ret_sts_error;

Line 273: fnd_msg_pub.add;

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;
277:

Line 286: fnd_msg_pub.add;

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;
290:

Line 297: fnd_msg_pub.add;

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:
301: --Validate that the passed end date is not Null and less than Territory End Date

Line 308: fnd_msg_pub.add;

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');
312: x_return_status := fnd_api.g_ret_sts_error;

Line 315: fnd_msg_pub.add;

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;
319:

Line 365: fnd_msg_pub.add;

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
369: --dbms_output.put_line('Salesrep Territory Successfully Created');

Line 404: fnd_msg_pub.add;

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;
408:

Line 433: fnd_msg_pub.add;

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;
437:

Line 461: fnd_msg_pub.add;

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;
465:

Line 497: fnd_msg_pub.add;

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;
501: END IF;

Line 506: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

502:
503: IF fnd_api.to_boolean(p_commit) THEN
504: COMMIT WORK;
505: END IF;
506: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
507:
508: EXCEPTION
509: WHEN fnd_api.g_exc_unexpected_error THEN
510: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 514: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

510: --DBMS_OUTPUT.put_line (' ========================================== ');
511: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
512: ROLLBACK TO create_rs_srp_territories_pvt;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
515: WHEN OTHERS THEN
516: --DBMS_OUTPUT.put_line (' ========================================== ');
517: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Group_member Pvt ============= ');
518: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

517: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Group_member Pvt ============= ');
518: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
519: ROLLBACK TO create_rs_srp_territories_pvt;
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
522:
523: END create_rs_srp_territories;
524:
525: --Procedure to update the resource salesrep territories based on input values passed by calling routines

Line 650: fnd_msg_pub.initialize;

646: RAISE fnd_api.g_exc_unexpected_error;
647: END IF;
648:
649: IF fnd_api.to_boolean(p_init_msg_list) THEN
650: fnd_msg_pub.initialize;
651: END IF;
652:
653: --Make the pre processing call to the user hooks
654:

Line 677: fnd_msg_pub.add;

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;
681:

Line 704: fnd_msg_pub.add;

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;
708:

Line 731: fnd_msg_pub.add;

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;
735:

Line 745: fnd_msg_pub.add;

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;
749:

Line 757: fnd_msg_pub.add;

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;
761:

Line 784: fnd_msg_pub.add;

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;
788:

Line 796: fnd_msg_pub.add;

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;
800:

Line 809: fnd_msg_pub.add;

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');
813: x_return_status := fnd_api.g_ret_sts_error;

Line 816: fnd_msg_pub.add;

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;
820: END IF;

Line 830: fnd_msg_pub.add;

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;
834:

Line 842: fnd_msg_pub.add;

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;
846:

Line 855: fnd_msg_pub.add;

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');
859: x_return_status := fnd_api.g_ret_sts_error;

Line 862: fnd_msg_pub.add;

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;
866: END IF;

Line 918: fnd_msg_pub.add;

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');
922:

Line 953: fnd_msg_pub.add;

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;
957:

Line 980: fnd_msg_pub.add;

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;
984:

Line 1007: fnd_msg_pub.add;

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;
1011:

Line 1042: fnd_msg_pub.add;

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;
1046: END IF;

Line 1052: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1048:
1049: IF fnd_api.to_boolean(p_commit) THEN
1050: COMMIT WORK;
1051: END IF;
1052: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1053:
1054: EXCEPTION
1055: WHEN fnd_api.g_exc_unexpected_error THEN
1056: --DBMS_OUTPUT.put_line (' ========================================== ');

Line 1060: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1056: --DBMS_OUTPUT.put_line (' ========================================== ');
1057: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
1058: ROLLBACK TO update_rs_srp_territories_pvt;
1059: x_return_status := fnd_api.g_ret_sts_unexp_error;
1060: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1061: WHEN OTHERS THEN
1062: --DBMS_OUTPUT.put_line (' ========================================== ');
1063: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Salesrep Territories Pvt ============= ');
1064: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

Line 1067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1063: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Salesrep Territories Pvt ============= ');
1064: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
1065: ROLLBACK TO update_rs_srp_territories_pvt;
1066: x_return_status := fnd_api.g_ret_sts_unexp_error;
1067: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1068:
1069: END update_rs_srp_territories;
1070:
1071: END jtf_rs_srp_territories_pvt;