APPS.JTF_RS_SRP_TERRITORIES_PUB dependencies on FND_MESSAGE

Line 77: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');

73: --Validate the Salesrep Id
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

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

82: OPEN c_salesrep_id;
83: FETCH c_salesrep_id INTO l_salesrep;
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;

Line 87: fnd_message.set_token('P_SALESREP_ID', p_salesrep_id);

83: FETCH c_salesrep_id INTO l_salesrep;
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;

Line 233: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_ID_NULL');

229: --Validate the Salesrep Id
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

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

238: OPEN c_salesrep_id;
239: FETCH c_salesrep_id INTO l_salesrep;
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;

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

239: FETCH c_salesrep_id INTO l_salesrep;
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;