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:

Line 1036: fnd_msg_pub.add;

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

Line 1043: fnd_msg_pub.add;

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

Line 1059: fnd_msg_pub.add;

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

Line 1121: fnd_msg_pub.add;

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

Line 1160: fnd_msg_pub.add;

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

Line 1200: fnd_msg_pub.add;

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

Line 1240: fnd_msg_pub.add;

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

Line 1289: fnd_msg_pub.add;

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

Line 1309: FND_MSG_PUB.Count_And_Get

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

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

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

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

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

Line 1331: FND_MSG_PUB.add;

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

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

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);
1335:
1336: End update_salesrep;
1337: