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_GROUP_ORGS_PVT dependencies on FND_MESSAGE

Line 116: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');

112: CLOSE c_validate_group;
113:
114:
115: IF (l_group_start_date IS NULL) THEN
116: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
117: fnd_message.set_token('P_GROUP_ID',l_group_id);
118: fnd_msg_pub.add;
119: RAISE fnd_api.g_exc_error;
120: ELSIF

Line 117: fnd_message.set_token('P_GROUP_ID',l_group_id);

113:
114:
115: IF (l_group_start_date IS NULL) THEN
116: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GROUP');
117: fnd_message.set_token('P_GROUP_ID',l_group_id);
118: fnd_msg_pub.add;
119: RAISE fnd_api.g_exc_error;
120: ELSIF
121: ((l_group_start_date IS NOT NULL) AND

Line 124: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_GROUP');

120: ELSIF
121: ((l_group_start_date IS NOT NULL) AND
122: (l_group_end_date < TRUNC(SYSDATE))
123: ) THEN
124: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_GROUP');
125: fnd_message.set_token('P_GROUP_NAME',l_group_name);
126: fnd_msg_pub.add;
127: RAISE fnd_api.g_exc_error;
128: END IF;

Line 125: fnd_message.set_token('P_GROUP_NAME',l_group_name);

121: ((l_group_start_date IS NOT NULL) AND
122: (l_group_end_date < TRUNC(SYSDATE))
123: ) THEN
124: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_GROUP');
125: fnd_message.set_token('P_GROUP_NAME',l_group_name);
126: fnd_msg_pub.add;
127: RAISE fnd_api.g_exc_error;
128: END IF;
129:

Line 139: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HR_ORG');

135: CLOSE c_validate_hr_org;
136:
137:
138: IF (l_org_start_date IS NULL) THEN
139: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HR_ORG');
140: fnd_message.set_token('P_ORG_ID',l_organization_id);
141: fnd_msg_pub.add;
142: RAISE fnd_api.g_exc_error;
143: ELSIF

Line 140: fnd_message.set_token('P_ORG_ID',l_organization_id);

136:
137:
138: IF (l_org_start_date IS NULL) THEN
139: fnd_message.set_name('JTF', 'JTF_RS_INVALID_HR_ORG');
140: fnd_message.set_token('P_ORG_ID',l_organization_id);
141: fnd_msg_pub.add;
142: RAISE fnd_api.g_exc_error;
143: ELSIF
144: ((l_org_start_date IS NOT NULL) AND

Line 147: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_HR_ORG');

143: ELSIF
144: ((l_org_start_date IS NOT NULL) AND
145: (l_org_end_date < TRUNC(SYSDATE))
146: ) THEN
147: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_HR_ORG');
148: fnd_message.set_token('P_ORG_NAME',l_org_name);
149: fnd_msg_pub.add;
150: RAISE fnd_api.g_exc_error;
151: END IF;

Line 148: fnd_message.set_token('P_ORG_NAME',l_org_name);

144: ((l_org_start_date IS NOT NULL) AND
145: (l_org_end_date < TRUNC(SYSDATE))
146: ) THEN
147: fnd_message.set_name('JTF', 'JTF_RS_INACTIVE_HR_ORG');
148: fnd_message.set_token('P_ORG_NAME',l_org_name);
149: fnd_msg_pub.add;
150: RAISE fnd_api.g_exc_error;
151: END IF;
152:

Line 160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_ORG_MAP_EXIST');

156: FETCH c_check_dup_group_org_map INTO l_mapping_exist;
157: CLOSE c_check_dup_group_org_map;
158:
159: IF (l_mapping_exist = 'Y') THEN
160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_ORG_MAP_EXIST');
161: fnd_message.set_token('P_GROUP_NAME',l_group_name);
162: fnd_message.set_token('P_ORG_NAME',l_org_name);
163: fnd_msg_pub.add;
164: RAISE fnd_api.g_exc_error;

Line 161: fnd_message.set_token('P_GROUP_NAME',l_group_name);

157: CLOSE c_check_dup_group_org_map;
158:
159: IF (l_mapping_exist = 'Y') THEN
160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_ORG_MAP_EXIST');
161: fnd_message.set_token('P_GROUP_NAME',l_group_name);
162: fnd_message.set_token('P_ORG_NAME',l_org_name);
163: fnd_msg_pub.add;
164: RAISE fnd_api.g_exc_error;
165: END IF;

Line 162: fnd_message.set_token('P_ORG_NAME',l_org_name);

158:
159: IF (l_mapping_exist = 'Y') THEN
160: fnd_message.set_name('JTF', 'JTF_RS_GROUP_ORG_MAP_EXIST');
161: fnd_message.set_token('P_GROUP_NAME',l_group_name);
162: fnd_message.set_token('P_ORG_NAME',l_org_name);
163: fnd_msg_pub.add;
164: RAISE fnd_api.g_exc_error;
165: END IF;
166:

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

239: p_data => x_msg_data);
240:
241: WHEN OTHERS THEN
242: ROLLBACK TO create_group_org;
243: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
244: fnd_message.set_token('P_SQLCODE',SQLCODE);
245: fnd_message.set_token('P_SQLERRM',SQLERRM);
246: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
247: FND_MSG_PUB.add;

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

240:
241: WHEN OTHERS THEN
242: ROLLBACK TO create_group_org;
243: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
244: fnd_message.set_token('P_SQLCODE',SQLCODE);
245: fnd_message.set_token('P_SQLERRM',SQLERRM);
246: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
247: FND_MSG_PUB.add;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

241: WHEN OTHERS THEN
242: ROLLBACK TO create_group_org;
243: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
244: fnd_message.set_token('P_SQLCODE',SQLCODE);
245: fnd_message.set_token('P_SQLERRM',SQLERRM);
246: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
247: FND_MSG_PUB.add;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 246: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);

242: ROLLBACK TO create_group_org;
243: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
244: fnd_message.set_token('P_SQLCODE',SQLCODE);
245: fnd_message.set_token('P_SQLERRM',SQLERRM);
246: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
247: FND_MSG_PUB.add;
248: x_return_status := fnd_api.g_ret_sts_unexp_error;
249: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
250: p_data => x_msg_data);

Line 342: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');

338: OPEN c_group_org_update(l_group_id, l_organization_id);
339: FETCH c_group_org_update INTO group_org_rec;
340: IF c_group_org_update%NOTFOUND THEN
341: CLOSE c_group_org_update;
342: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
343: fnd_message.set_token('P_GRP_ID', l_group_id);
344: fnd_message.set_token('P_ORG_ID', l_organization_id);
345: fnd_msg_pub.add;
346: RAISE fnd_api.g_exc_unexpected_error;

Line 343: fnd_message.set_token('P_GRP_ID', l_group_id);

339: FETCH c_group_org_update INTO group_org_rec;
340: IF c_group_org_update%NOTFOUND THEN
341: CLOSE c_group_org_update;
342: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
343: fnd_message.set_token('P_GRP_ID', l_group_id);
344: fnd_message.set_token('P_ORG_ID', l_organization_id);
345: fnd_msg_pub.add;
346: RAISE fnd_api.g_exc_unexpected_error;
347: ELSE

Line 344: fnd_message.set_token('P_ORG_ID', l_organization_id);

340: IF c_group_org_update%NOTFOUND THEN
341: CLOSE c_group_org_update;
342: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
343: fnd_message.set_token('P_GRP_ID', l_group_id);
344: fnd_message.set_token('P_ORG_ID', l_organization_id);
345: fnd_msg_pub.add;
346: RAISE fnd_api.g_exc_unexpected_error;
347: ELSE
348: CLOSE c_group_org_update;

Line 356: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

352: IF (group_org_rec.l_object_version_number = l_object_version_number)
353: THEN
354: NULL;
355: ELSE
356: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
357: fnd_msg_pub.add;
358: RAISE fnd_api.g_exc_error;
359: END IF;
360:

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

407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
409: WHEN OTHERS THEN
410: ROLLBACK TO sp_update_group_org;
411: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
412: fnd_message.set_token('P_SQLCODE',SQLCODE);
413: fnd_message.set_token('P_SQLERRM',SQLERRM);
414: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
415: FND_MSG_PUB.add;

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

408: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
409: WHEN OTHERS THEN
410: ROLLBACK TO sp_update_group_org;
411: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
412: fnd_message.set_token('P_SQLCODE',SQLCODE);
413: fnd_message.set_token('P_SQLERRM',SQLERRM);
414: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
415: FND_MSG_PUB.add;
416: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

409: WHEN OTHERS THEN
410: ROLLBACK TO sp_update_group_org;
411: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
412: fnd_message.set_token('P_SQLCODE',SQLCODE);
413: fnd_message.set_token('P_SQLERRM',SQLERRM);
414: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
415: FND_MSG_PUB.add;
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 414: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);

410: ROLLBACK TO sp_update_group_org;
411: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
412: fnd_message.set_token('P_SQLCODE',SQLCODE);
413: fnd_message.set_token('P_SQLERRM',SQLERRM);
414: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
415: FND_MSG_PUB.add;
416: x_return_status := fnd_api.g_ret_sts_unexp_error;
417: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
418:

Line 474: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');

470: FETCH c_group_org_id INTO l_object_version_number;
471: CLOSE c_group_org_id;
472:
473: IF (l_object_version_number IS NULL) THEN
474: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
475: fnd_message.set_token('P_GRP_ID', p_group_id);
476: fnd_message.set_token('P_ORG_ID', p_organization_id);
477: fnd_msg_pub.add;
478: RAISE fnd_api.g_exc_error;

Line 475: fnd_message.set_token('P_GRP_ID', p_group_id);

471: CLOSE c_group_org_id;
472:
473: IF (l_object_version_number IS NULL) THEN
474: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
475: fnd_message.set_token('P_GRP_ID', p_group_id);
476: fnd_message.set_token('P_ORG_ID', p_organization_id);
477: fnd_msg_pub.add;
478: RAISE fnd_api.g_exc_error;
479: END IF;

Line 476: fnd_message.set_token('P_ORG_ID', p_organization_id);

472:
473: IF (l_object_version_number IS NULL) THEN
474: fnd_message.set_name('JTF', 'JTF_RS_INVALID_GRP_ORG_ID');
475: fnd_message.set_token('P_GRP_ID', p_group_id);
476: fnd_message.set_token('P_ORG_ID', p_organization_id);
477: fnd_msg_pub.add;
478: RAISE fnd_api.g_exc_error;
479: END IF;
480:

Line 486: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

482: IF (l_object_version_number = p_object_version_number)
483: THEN
484: NULL;
485: ELSE
486: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
487: fnd_msg_pub.add;
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:

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

513: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
514: p_data => x_msg_data);
515: WHEN OTHERS THEN
516: ROLLBACK TO sp_delete_group_org;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
521: FND_MSG_PUB.add;

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

514: p_data => x_msg_data);
515: WHEN OTHERS THEN
516: ROLLBACK TO sp_delete_group_org;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

515: WHEN OTHERS THEN
516: ROLLBACK TO sp_delete_group_org;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,

Line 520: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);

516: ROLLBACK TO sp_delete_group_org;
517: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
518: fnd_message.set_token('P_SQLCODE',SQLCODE);
519: fnd_message.set_token('P_SQLERRM',SQLERRM);
520: fnd_message.set_token('P_API_NAME', g_pkg_name||'.'||l_api_name);
521: FND_MSG_PUB.add;
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
524: p_data => x_msg_data);