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_MSG_PUB

Line 124: fnd_msg_pub.initialize;

120: RAISE fnd_api.g_exc_unexpected_error;
121: END IF;
122:
123: IF fnd_api.to_Boolean(p_init_msg_list) THEN
124: fnd_msg_pub.initialize;
125: END IF;
126:
127: /* Make the pre processing call to the user hooks */
128:

Line 158: fnd_msg_pub.add;

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;
162: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 200: fnd_msg_pub.add;

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;
204: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 243: fnd_msg_pub.add;

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;
247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 279: fnd_msg_pub.add;

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

Line 300: fnd_msg_pub.add;

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:
304: -- l_org_id := fnd_profile.value('ORG_ID');

Line 324: fnd_msg_pub.add;

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

Line 408: fnd_msg_pub.add;

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

Line 449: fnd_msg_pub.add;

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;
453: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 490: fnd_msg_pub.add;

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;
494: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 531: fnd_msg_pub.add;

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;
535: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 581: fnd_msg_pub.add;

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;
585: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 601: FND_MSG_PUB.Count_And_Get

597: COMMIT WORK;
598: END IF;
599:
600: /* Standard call to get message count and if count is 1, get message info. */
601: FND_MSG_PUB.Count_And_Get
602: (p_count => x_msg_count,
603: p_data => x_msg_data
604: );
605:

Line 611: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

607:
608: WHEN fnd_api.g_exc_error THEN
609: ROLLBACK TO create_salesrep_pvt;
610: x_return_status := fnd_api.g_ret_sts_error;
611: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
612: p_data => x_msg_data);
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO create_salesrep_pvt;
615: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 616: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

612: p_data => x_msg_data);
613: WHEN fnd_api.g_exc_unexpected_error THEN
614: ROLLBACK TO create_salesrep_pvt;
615: x_return_status := fnd_api.g_ret_sts_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');

Line 624: FND_MSG_PUB.add;

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);
628:

Line 626: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
628:
629: End Create_salesrep;
630:

Line 859: fnd_msg_pub.initialize;

855: RAISE fnd_api.g_exc_unexpected_error;
856: END IF;
857:
858: IF fnd_api.to_Boolean(p_init_msg_list) THEN
859: fnd_msg_pub.initialize;
860: END IF;
861:
862:
863: -- dbms_output.put_line('Org id before validation : '|| l_org_id);

Line 903: fnd_msg_pub.add;

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
907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 943: fnd_msg_pub.add;

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;
947: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 985: fnd_msg_pub.add;

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;
989: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1007: fnd_msg_pub.add;

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

Line 1039: fnd_msg_pub.add;

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;
1043: CLOSE c_salesrep_number;

Line 1046: fnd_msg_pub.add;

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

Line 1062: fnd_msg_pub.add;

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

Line 1124: fnd_msg_pub.add;

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:
1128: END;

Line 1163: fnd_msg_pub.add;

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;
1167: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1203: fnd_msg_pub.add;

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;
1207: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1243: fnd_msg_pub.add;

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;
1247: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1292: fnd_msg_pub.add;

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;
1296: ELSIF X_RETURN_STATUS = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1312: FND_MSG_PUB.Count_And_Get

1308: COMMIT WORK;
1309: END IF;
1310:
1311: /* Standard call to get message count and if count is 1, get message info. */
1312: FND_MSG_PUB.Count_And_Get
1313: (p_count => x_msg_count,
1314: p_data => x_msg_data
1315: );
1316:

Line 1321: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1317: EXCEPTION
1318: WHEN fnd_api.g_exc_error THEN
1319: ROLLBACK TO update_salesrep_pvt;
1320: x_return_status := fnd_api.g_ret_sts_error;
1321: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
1322: p_data => x_msg_data);
1323: WHEN fnd_api.g_exc_unexpected_error THEN
1324: ROLLBACK TO update_salesrep_pvt;
1325: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1326: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

1322: p_data => x_msg_data);
1323: WHEN fnd_api.g_exc_unexpected_error THEN
1324: ROLLBACK TO update_salesrep_pvt;
1325: x_return_status := fnd_api.g_ret_sts_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');

Line 1334: FND_MSG_PUB.add;

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);
1338:

Line 1336: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

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);
1338:
1339: End update_salesrep;
1340: