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_MESSAGE

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

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:
160: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
161: RAISE FND_API.G_EXC_ERROR;

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

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:
202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
203: RAISE FND_API.G_EXC_ERROR;

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

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:
245: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
246: RAISE FND_API.G_EXC_ERROR;

Line 277: fnd_message.set_name('JTF','JTF_RS_INVALID_RESOURCE');

273: OPEN c_category(l_resource_id);
274: FETCH c_category INTO l_category,l_person_id;
275: IF c_category%NOTFOUND THEN
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;

Line 278: fnd_message.set_token('P_RESOURCE_ID',l_resource_id);

274: FETCH c_category INTO l_category,l_person_id;
275: IF c_category%NOTFOUND THEN
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;

Line 299: fnd_message.set_name('JTF','JTF_RS_ORG_CONTEXT_NOT_SET');

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

Line 323: fnd_message.set_name('JTF','JTF_RS_DUP_RES_SALESPERSON');

319: OPEN c_dup_resource(l_resource_id, l_org_id);
320: FETCH c_dup_resource into resource_exists;
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;

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

403: IF c_jtf_rs_salesreps%NOTFOUND THEN
404:
405: CLOSE c_jtf_rs_salesreps;
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:

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

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:
451: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
452: RAISE FND_API.G_EXC_ERROR;

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

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:
492: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;

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

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:
533: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
534: RAISE FND_API.G_EXC_ERROR;

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

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;
582:
583: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;

Line 620: fnd_message.set_name ('JTF', 'JTF_RS_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;
620: fnd_message.set_name ('JTF', 'JTF_RS_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;

Line 621: fnd_message.set_token('P_SQLCODE',SQLCODE);

617: p_data => x_msg_data);
618: WHEN OTHERS THEN
619: ROLLBACK TO create_salesrep_pvt;
620: fnd_message.set_name ('JTF', 'JTF_RS_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;

Line 622: fnd_message.set_token('P_SQLERRM',SQLERRM);

618: WHEN OTHERS THEN
619: ROLLBACK TO create_salesrep_pvt;
620: fnd_message.set_name ('JTF', 'JTF_RS_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,

Line 623: fnd_message.set_token('P_API_NAME', l_api_name);

619: ROLLBACK TO create_salesrep_pvt;
620: fnd_message.set_name ('JTF', 'JTF_RS_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);

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

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
905: RAISE FND_API.G_EXC_ERROR;
906: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

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:
945: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
946: RAISE FND_API.G_EXC_ERROR;

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

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:
987: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
988: RAISE FND_API.G_EXC_ERROR;

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

1001: FETCH c_salesrep_update INTO salesrep_rec;
1002:
1003: IF c_salesrep_update%NOTFOUND THEN
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:

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

1002:
1003: IF c_salesrep_update%NOTFOUND THEN
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;

Line 1034: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');

1030: IF (l_salesrep_number IS NOT NULL) THEN
1031: OPEN c_salesrep_number;
1032: FETCH c_salesrep_number INTO c_val;
1033: IF (c_salesrep_number%FOUND) THEN
1034: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');
1035: fnd_message.set_token('P_SALESREP_NUMBER', l_salesrep_number);
1036: fnd_msg_pub.add;
1037: CLOSE c_salesrep_number;
1038: RAISE fnd_api.g_exc_error;

Line 1035: fnd_message.set_token('P_SALESREP_NUMBER', l_salesrep_number);

1031: OPEN c_salesrep_number;
1032: FETCH c_salesrep_number INTO c_val;
1033: IF (c_salesrep_number%FOUND) THEN
1034: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');
1035: fnd_message.set_token('P_SALESREP_NUMBER', l_salesrep_number);
1036: fnd_msg_pub.add;
1037: CLOSE c_salesrep_number;
1038: RAISE fnd_api.g_exc_error;
1039: END IF;

Line 1042: fnd_message.set_name('JTF', 'JTF_RS_SALESREP_NUMBER_NULL');

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

Line 1058: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

1054: x_object_version_number => l_object_version_number
1055: );
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
1059: fnd_msg_pub.add;
1060: RAISE fnd_api.g_exc_error;
1061: END;
1062:

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

1116: WHEN NO_DATA_FOUND THEN
1117: /* dbms_output.put_line('Error in Table Haandler'); */
1118: CLOSE c_salesrep_update;
1119:
1120: fnd_message.set_name('JTF', 'JTF_RS_TABLE_HANDLER_ERROR');
1121: fnd_msg_pub.add;
1122:
1123: RAISE fnd_api.g_exc_error;
1124:

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

1155: x_return_status => x_return_status);
1156:
1157: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1158:
1159: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_CUST_USR_HOOK');
1160: fnd_msg_pub.add;
1161:
1162: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1163: RAISE FND_API.G_EXC_ERROR;

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

1195: x_return_status => x_return_status);
1196:
1197: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1198:
1199: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_VERT_USR_HOOK');
1200: fnd_msg_pub.add;
1201:
1202: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1203: RAISE FND_API.G_EXC_ERROR;

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

1235: x_return_status => x_return_status);
1236:
1237: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1238:
1239: fnd_message.set_name('JTF', 'JTF_RS_ERR_POST_INT_USR_HOOK');
1240: fnd_msg_pub.add;
1241:
1242: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1243: RAISE FND_API.G_EXC_ERROR;

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

1284:
1285: IF NOT (x_return_status = fnd_api.g_ret_sts_success) THEN
1286:
1287:
1288: fnd_message.set_name('JTF', 'JTF_RS_ERR_MESG_GENERATE_API');
1289: fnd_msg_pub.add;
1290:
1291: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
1292: RAISE FND_API.G_EXC_ERROR;

Line 1327: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

1323: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1324: p_data => x_msg_data);
1325: WHEN OTHERS THEN
1326: ROLLBACK TO update_salesrep_pvt;
1327: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1328: fnd_message.set_token('P_SQLCODE',SQLCODE);
1329: fnd_message.set_token('P_SQLERRM',SQLERRM);
1330: fnd_message.set_token('P_API_NAME', l_api_name);
1331: FND_MSG_PUB.add;

Line 1328: fnd_message.set_token('P_SQLCODE',SQLCODE);

1324: p_data => x_msg_data);
1325: WHEN OTHERS THEN
1326: ROLLBACK TO update_salesrep_pvt;
1327: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1328: fnd_message.set_token('P_SQLCODE',SQLCODE);
1329: fnd_message.set_token('P_SQLERRM',SQLERRM);
1330: fnd_message.set_token('P_API_NAME', l_api_name);
1331: FND_MSG_PUB.add;
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1329: fnd_message.set_token('P_SQLERRM',SQLERRM);

1325: WHEN OTHERS THEN
1326: ROLLBACK TO update_salesrep_pvt;
1327: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1328: fnd_message.set_token('P_SQLCODE',SQLCODE);
1329: fnd_message.set_token('P_SQLERRM',SQLERRM);
1330: fnd_message.set_token('P_API_NAME', l_api_name);
1331: FND_MSG_PUB.add;
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 1330: fnd_message.set_token('P_API_NAME', l_api_name);

1326: ROLLBACK TO update_salesrep_pvt;
1327: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
1328: fnd_message.set_token('P_SQLCODE',SQLCODE);
1329: fnd_message.set_token('P_SQLERRM',SQLERRM);
1330: fnd_message.set_token('P_API_NAME', l_api_name);
1331: FND_MSG_PUB.add;
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1334: p_data => x_msg_data);