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.CN_DIM_HIERARCHIES_PVT dependencies on FND_MESSAGE

Line 56: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');

52:
53: -- validate name is unique
54: select count(1) into l_count from cn_dimensions where name = p_name and org_id = p_org_id; --R12 MOAC change
55: if l_count > 0 then
56: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
57: FND_MSG_PUB.ADD;
58: RAISE FND_API.G_EXC_ERROR;
59: end if;
60:

Line 69: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');

65: and T.language = L.language_code
66: and L.INSTALLED_FLAG in ('I', 'B');
67:
68: if l_count_tl > 0 then
69: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
70: FND_MSG_PUB.ADD;
71: RAISE FND_API.G_EXC_ERROR;
72: end if;
73:

Line 196: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

192: open c;
193: fetch c into tlinfo;
194: if (c%notfound) then
195: close c;
196: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
197: fnd_msg_pub.add;
198: raise fnd_api.g_exc_error;
199: end if;
200: close c;

Line 206: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');

202: -- validate name is unique
203: select count(1) into l_count from cn_dimensions
204: where name = p_name and dimension_id <> p_dimension_id and org_id = p_org_id; --R12 MOAC changes
205: if l_count > 0 then
206: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
207: FND_MSG_PUB.ADD;
208: RAISE FND_API.G_EXC_ERROR;
209: end if;
210:

Line 217: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');

213:
214:
215:
216: if (tlinfo.object_version_number <> p_object_version_number) then
217: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
218: fnd_msg_pub.add;
219: raise fnd_api.g_exc_error;
220: end if;
221: -- END LOCK ROW --

Line 416: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');

412: and org_id = p_org_id ;
413: --R12 MOAC Changes--End
414:
415: if l_count > 0 then
416: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
417: FND_MSG_PUB.ADD;
418: RAISE FND_API.G_EXC_ERROR;
419: end if;
420:

Line 537: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

533: open c;
534: fetch c into tlinfo;
535: if (c%notfound) then
536: close c;
537: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
538: fnd_msg_pub.add;
539: raise fnd_api.g_exc_error;
540: end if;
541: close c;

Line 544: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');

540: end if;
541: close c;
542:
543: if (tlinfo.object_version_number <> p_object_version_number) then
544: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
545: fnd_msg_pub.add;
546: raise fnd_api.g_exc_error;
547: end if;
548: -- END LOCK ROW --

Line 558: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');

554: and org_id = p_org_id
555: --R12 MOAC Changes--End
556: and head_hierarchy_id <> p_head_hierarchy_id;
557: if l_count > 0 then
558: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
559: FND_MSG_PUB.ADD;
560: RAISE FND_API.G_EXC_ERROR;
561: end if;
562:

Line 778: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');

774: nvl(end_date,p_start_date) >= p_start_date) OR
775: (start_date >= p_start_date and
776: start_date <= nvl(p_end_date, start_date)));
777: if l_count > 0 then
778: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');
779: FND_MSG_PUB.ADD;
780: RAISE FND_API.G_EXC_ERROR;
781: end if;
782:

Line 785: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');

781: end if;
782:
783: if p_end_date is not null and
784: p_end_date < p_start_date then
785: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
786: FND_MSG_PUB.ADD;
787: RAISE FND_API.G_EXC_ERROR;
788: end if;
789:

Line 917: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');

913: --R12 MOAC Changes--End
914:
915: if p_end_date is not null and
916: p_end_date < p_start_date then
917: FND_MESSAGE.SET_NAME('CN', 'ALL_INVALID_PERIOD_RANGE');
918: FND_MSG_PUB.ADD;
919: RAISE FND_API.G_EXC_ERROR;
920: end if;
921:

Line 934: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');

930: nvl(end_date,p_start_date) >= p_start_date) OR
931: (start_date >= p_start_date and
932: start_date <= nvl(p_end_date, start_date)));
933: if l_count > 0 then
934: FND_MESSAGE.SET_NAME('CN', 'CN_DATE_OVERLAP');
935: FND_MSG_PUB.ADD;
936: RAISE FND_API.G_EXC_ERROR;
937: end if;
938:

Line 1216: FND_MESSAGE.SET_NAME('CN', 'REV_CLASS_HIER_CHECK');

1212: FETCH dup_rev_classes INTO l_start_date, l_end_date, l_par_name;
1213:
1214: IF dup_rev_classes%found THEN
1215: CLOSE dup_rev_classes;
1216: FND_MESSAGE.SET_NAME('CN', 'REV_CLASS_HIER_CHECK');
1217: fnd_message.set_token('REV_CLASS_NAME_PARENT', l_par_name);
1218: fnd_message.set_token('REV_CLASS_NAME_CHILD', p_name);
1219: fnd_message.set_token('PERIODS', l_start_date || ' - ' || l_end_date);
1220: FND_MSG_PUB.ADD;

Line 1217: fnd_message.set_token('REV_CLASS_NAME_PARENT', l_par_name);

1213:
1214: IF dup_rev_classes%found THEN
1215: CLOSE dup_rev_classes;
1216: FND_MESSAGE.SET_NAME('CN', 'REV_CLASS_HIER_CHECK');
1217: fnd_message.set_token('REV_CLASS_NAME_PARENT', l_par_name);
1218: fnd_message.set_token('REV_CLASS_NAME_CHILD', p_name);
1219: fnd_message.set_token('PERIODS', l_start_date || ' - ' || l_end_date);
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;

Line 1218: fnd_message.set_token('REV_CLASS_NAME_CHILD', p_name);

1214: IF dup_rev_classes%found THEN
1215: CLOSE dup_rev_classes;
1216: FND_MESSAGE.SET_NAME('CN', 'REV_CLASS_HIER_CHECK');
1217: fnd_message.set_token('REV_CLASS_NAME_PARENT', l_par_name);
1218: fnd_message.set_token('REV_CLASS_NAME_CHILD', p_name);
1219: fnd_message.set_token('PERIODS', l_start_date || ' - ' || l_end_date);
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;

Line 1219: fnd_message.set_token('PERIODS', l_start_date || ' - ' || l_end_date);

1215: CLOSE dup_rev_classes;
1216: FND_MESSAGE.SET_NAME('CN', 'REV_CLASS_HIER_CHECK');
1217: fnd_message.set_token('REV_CLASS_NAME_PARENT', l_par_name);
1218: fnd_message.set_token('REV_CLASS_NAME_CHILD', p_name);
1219: fnd_message.set_token('PERIODS', l_start_date || ' - ' || l_end_date);
1220: FND_MSG_PUB.ADD;
1221: RAISE FND_API.G_EXC_ERROR;
1222: END IF;
1223: CLOSE dup_rev_classes;

Line 1238: FND_MESSAGE.SET_NAME('CN', 'HIER_NO_DIAMONDS');

1234: x_org_id => p_org_id);
1235: --R12 MOAC Changes--End
1236: EXCEPTION
1237: WHEN DUP_VAL_ON_INDEX THEN
1238: FND_MESSAGE.SET_NAME('CN', 'HIER_NO_DIAMONDS');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END;
1242:

Line 1338: FND_MESSAGE.SET_NAME('CN', 'HIER_NO_DELETE_ROOT');

1334: and org_id = p_org_id;
1335: --R12 MOAC Changes--End
1336:
1337: if l_ext_id is null then
1338: FND_MESSAGE.SET_NAME('CN', 'HIER_NO_DELETE_ROOT');
1339: FND_MSG_PUB.ADD;
1340: RAISE FND_API.G_EXC_ERROR;
1341: end if;
1342: end if;

Line 1355: fnd_message.set_name('CN', 'CN_RECORD_DELETED');

1351: and org_id = p_org_id;
1352: --R12 MOAC Changes--End
1353:
1354: if l_count = 0 then
1355: fnd_message.set_name('CN', 'CN_RECORD_DELETED');
1356: fnd_msg_pub.add;
1357: raise fnd_api.g_exc_error;
1358: end if;
1359: