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_PUB dependencies on FND_MSG_PUB

Line 68: fnd_msg_pub.initialize;

64: RAISE fnd_api.g_exc_unexpected_error;
65: END IF;
66:
67: IF fnd_api.to_boolean(p_init_msg_list) THEN
68: fnd_msg_pub.initialize;
69: END IF;
70:
71: --Put in all the Validations here
72:

Line 78: fnd_msg_pub.add;

74:
75: IF p_salesrep_id IS NULL THEN
76: -- dbms_output.put_line('Salesrep Id is null');
77: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');
78: fnd_msg_pub.add;
79: x_return_status := fnd_api.g_ret_sts_unexp_error;
80: END IF;
81: IF p_salesrep_id IS NOT NULL THEN
82: OPEN c_salesrep_id;

Line 88: fnd_msg_pub.add;

84: IF c_salesrep_id%NOTFOUND THEN
85: -- dbms_output.put_line('Invalid Salesrep Id');
86: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
87: fnd_message.set_token('P_SALESREP_ID', p_salesrep_id);
88: fnd_msg_pub.add;
89: x_return_status := fnd_api.g_ret_sts_unexp_error;
90: END IF;
91: CLOSE c_salesrep_id;
92: END IF;

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

139:
140: IF fnd_api.to_boolean(p_commit) THEN
141: COMMIT WORK;
142: END IF;
143: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
144:
145: EXCEPTION
146: WHEN fnd_api.g_exc_unexpected_error THEN
147: --DBMS_OUTPUT.put_line (' ========================================== ');

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

147: --DBMS_OUTPUT.put_line (' ========================================== ');
148: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
149: ROLLBACK TO create_rs_srp_territories_pub;
150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
152: WHEN OTHERS THEN
153: --DBMS_OUTPUT.put_line (' ========================================== ');
154: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Salesrep Territories Pub ============= ');
155: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

154: --DBMS_OUTPUT.put_line (' =========== Raised Others in Create Salesrep Territories Pub ============= ');
155: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
156: ROLLBACK TO create_rs_srp_territories_pub;
157: x_return_status := fnd_api.g_ret_sts_unexp_error;
158: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
159:
160: END create_rs_srp_territories;
161:
162: --Procedure to update the resource salesrep territories based on input values passed by calling routines

Line 224: fnd_msg_pub.initialize;

220: RAISE fnd_api.g_exc_unexpected_error;
221: END IF;
222:
223: IF fnd_api.to_boolean(p_init_msg_list) THEN
224: fnd_msg_pub.initialize;
225: END IF;
226:
227: --Put all Validations here
228:

Line 234: fnd_msg_pub.add;

230:
231: IF p_salesrep_id IS NULL THEN
232: -- dbms_output.put_line('Salesrep Id is null');
233: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');
234: fnd_msg_pub.add;
235: x_return_status := fnd_api.g_ret_sts_unexp_error;
236: END IF;
237: IF p_salesrep_id IS NOT NULL THEN
238: OPEN c_salesrep_id;

Line 244: fnd_msg_pub.add;

240: IF c_salesrep_id%NOTFOUND THEN
241: -- dbms_output.put_line('Invalid Salesrep Id');
242: fnd_message.set_name('JTF', 'JTF_RS_INVALID_SALESREP_ID');
243: fnd_message.set_token('P_SALESREP_ID', p_salesrep_id);
244: fnd_msg_pub.add;
245: x_return_status := fnd_api.g_ret_sts_unexp_error;
246: END IF;
247: CLOSE c_salesrep_id;
248: END IF;

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

300: END IF;
301:
302: p_object_version_number := l_object_version_number;
303:
304: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
305: EXCEPTION
306: WHEN fnd_api.g_exc_unexpected_error THEN
307: --DBMS_OUTPUT.put_line (' ========================================== ');
308: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');

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

307: --DBMS_OUTPUT.put_line (' ========================================== ');
308: --DBMS_OUTPUT.put_line ('=========== Raised Unexpected Error =============== ');
309: ROLLBACK TO update_rs_srp_territories_pub;
310: x_return_status := fnd_api.g_ret_sts_unexp_error;
311: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
312: WHEN OTHERS THEN
313: --DBMS_OUTPUT.put_line (' ========================================== ');
314: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Salesrep Territories Pub ============= ');
315: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);

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

314: --DBMS_OUTPUT.put_line (' =========== Raised Others in Update Salesrep Territories Pub ============= ');
315: --DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
316: ROLLBACK TO update_rs_srp_territories_pub;
317: x_return_status := fnd_api.g_ret_sts_unexp_error;
318: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
319:
320: END update_rs_srp_territories;
321:
322: END jtf_rs_srp_territories_pub;