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 1037: fnd_message.set_name('JTF', 'JTF_RS_ERR_SALESREP_NUMBER');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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