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

Line 139: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');

135: select count(1) into l_count_mescol
136: from BSC_DB_MEASURE_COLS_VL
137: where upper(measure_col) = upper(l_Dataset_Rec.Bsc_Measure_Col);
138: if (l_count_mescol > 0) then
139: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
140: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: end if;

Line 140: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);

136: from BSC_DB_MEASURE_COLS_VL
137: where upper(measure_col) = upper(l_Dataset_Rec.Bsc_Measure_Col);
138: if (l_count_mescol > 0) then
139: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
140: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: end if;
144:

Line 212: FND_MESSAGE.SET_NAME('BSC','BSC_MEAS_ID_EXISTS');

208: commit;
209: end if;
210:
211: else
212: FND_MESSAGE.SET_NAME('BSC','BSC_MEAS_ID_EXISTS');
213: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_Dataset_Rec.Bsc_Measure_Id);
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: end if;

Line 213: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_Dataset_Rec.Bsc_Measure_Id);

209: end if;
210:
211: else
212: FND_MESSAGE.SET_NAME('BSC','BSC_MEAS_ID_EXISTS');
213: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_Dataset_Rec.Bsc_Measure_Id);
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: end if;
217:

Line 238: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

234: raise;
235: WHEN OTHERS THEN
236: FND_MSG_PUB.Initialize;
237: if (SQLCODE = -01400) then
238: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
239: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
240: FND_MSG_PUB.ADD;
241: RAISE FND_API.G_EXC_ERROR;
242: end if;

Line 239: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);

235: WHEN OTHERS THEN
236: FND_MSG_PUB.Initialize;
237: if (SQLCODE = -01400) then
238: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
239: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
240: FND_MSG_PUB.ADD;
241: RAISE FND_API.G_EXC_ERROR;
242: end if;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 326: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');

322: ,p_data => x_msg_data);
323: raise;
324: WHEN NO_DATA_FOUND THEN
325: FND_MSG_PUB.Initialize;
326: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
327: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
328: FND_MSG_PUB.ADD;
329: RAISE FND_API.G_EXC_ERROR;
330: WHEN OTHERS THEN

Line 327: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);

323: raise;
324: WHEN NO_DATA_FOUND THEN
325: FND_MSG_PUB.Initialize;
326: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
327: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
328: FND_MSG_PUB.ADD;
329: RAISE FND_API.G_EXC_ERROR;
330: WHEN OTHERS THEN
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 484: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

480: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'
481: ,'measure_id'
482: ,p_Dataset_Rec.Bsc_Measure_Id);
483: if l_count = 0 then
484: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
485: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
486: FND_MSG_PUB.ADD;
487: RAISE FND_API.G_EXC_ERROR;
488: end if;

Line 485: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);

481: ,'measure_id'
482: ,p_Dataset_Rec.Bsc_Measure_Id);
483: if l_count = 0 then
484: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
485: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
486: FND_MSG_PUB.ADD;
487: RAISE FND_API.G_EXC_ERROR;
488: end if;
489: else

Line 490: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');

486: FND_MSG_PUB.ADD;
487: RAISE FND_API.G_EXC_ERROR;
488: end if;
489: else
490: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
491: FND_MSG_PUB.ADD;
492: RAISE FND_API.G_EXC_ERROR;
493: end if;
494:

Line 505: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');

501: select count(1) into l_count_mescol
502: from BSC_DB_MEASURE_COLS_VL
503: where upper(measure_col) = upper(p_Dataset_Rec.Bsc_Measure_Col);
504: if (l_count_mescol > 0) then
505: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
506: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: end if;

Line 506: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);

502: from BSC_DB_MEASURE_COLS_VL
503: where upper(measure_col) = upper(p_Dataset_Rec.Bsc_Measure_Col);
504: if (l_count_mescol > 0) then
505: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_SOURCE_NAME');
506: FND_MESSAGE.SET_TOKEN('MEASURE', p_Dataset_Rec.Bsc_Dataset_Name);
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: end if;
510: END IF;

Line 745: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

741: FROM BSC_SYS_MEASURES
742: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
743:
744: IF l_count = 0 THEN
745: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
746: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
747: FND_MSG_PUB.ADD;
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;

Line 746: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);

742: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id;
743:
744: IF l_count = 0 THEN
745: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
746: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
747: FND_MSG_PUB.ADD;
748: RAISE FND_API.G_EXC_ERROR;
749: END IF;
750:

Line 758: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

754: FROM BSC_SYS_MEASURES
755: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
756:
757: IF l_count = 0 THEN
758: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
759: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id2);
760: FND_MSG_PUB.ADD;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;

Line 759: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id2);

755: WHERE MEASURE_ID = p_Dataset_Rec.Bsc_Measure_Id2;
756:
757: IF l_count = 0 THEN
758: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
759: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id2);
760: FND_MSG_PUB.ADD;
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: END IF;

Line 848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');

844: END IF;
845: END IF;
846:
847: ELSE
848: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
849: FND_MSG_PUB.ADD;
850: RAISE FND_API.G_EXC_ERROR;
851: END IF;
852:

Line 1072: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_ID_EXISTS');

1068: commit;
1069: end if;
1070:
1071: else
1072: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_ID_EXISTS');
1073: FND_MESSAGE.SET_TOKEN('BSC_DATASET', l_Dataset_Rec.Bsc_Dataset_Id);
1074: FND_MSG_PUB.ADD;
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;

Line 1073: FND_MESSAGE.SET_TOKEN('BSC_DATASET', l_Dataset_Rec.Bsc_Dataset_Id);

1069: end if;
1070:
1071: else
1072: FND_MESSAGE.SET_NAME('BSC','BSC_DSET_ID_EXISTS');
1073: FND_MESSAGE.SET_TOKEN('BSC_DATASET', l_Dataset_Rec.Bsc_Dataset_Id);
1074: FND_MSG_PUB.ADD;
1075: RAISE FND_API.G_EXC_ERROR;
1076: end if;
1077:

Line 1229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

1225: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1226: ,'dataset_id'
1227: ,p_Dataset_Rec.Bsc_Dataset_Id);
1228: if l_count = 0 then
1229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1230: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_ERROR;
1233: end if;

Line 1230: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1226: ,'dataset_id'
1227: ,p_Dataset_Rec.Bsc_Dataset_Id);
1228: if l_count = 0 then
1229: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1230: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_ERROR;
1233: end if;
1234: else

Line 1235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_ERROR;
1233: end if;
1234: else
1235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1236: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_ERROR;
1239: end if;

Line 1236: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1232: RAISE FND_API.G_EXC_ERROR;
1233: end if;
1234: else
1235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1236: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1237: FND_MSG_PUB.ADD;
1238: RAISE FND_API.G_EXC_ERROR;
1239: end if;
1240:

Line 1249: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

1245: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'
1246: ,'measure_id'
1247: ,p_Dataset_Rec.Bsc_Measure_Id);
1248: if l_count = 0 then
1249: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
1250: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: end if;

Line 1250: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);

1246: ,'measure_id'
1247: ,p_Dataset_Rec.Bsc_Measure_Id);
1248: if l_count = 0 then
1249: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
1250: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: end if;
1254: else

Line 1255: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');

1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_ERROR;
1253: end if;
1254: else
1255: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
1256: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1257: FND_MSG_PUB.ADD;
1258: RAISE FND_API.G_EXC_ERROR;
1259: end if;

Line 1256: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);

1252: RAISE FND_API.G_EXC_ERROR;
1253: end if;
1254: else
1255: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');
1256: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1257: FND_MSG_PUB.ADD;
1258: RAISE FND_API.G_EXC_ERROR;
1259: end if;
1260:

Line 1268: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');

1264: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_MEASURES'
1265: ,'measure_id'
1266: ,p_Dataset_Rec.Bsc_Measure_Id2);
1267: if l_count = 0 then
1268: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
1269: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1270: FND_MSG_PUB.ADD;
1271: RAISE FND_API.G_EXC_ERROR;
1272: end if;

Line 1269: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);

1265: ,'measure_id'
1266: ,p_Dataset_Rec.Bsc_Measure_Id2);
1267: if l_count = 0 then
1268: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
1269: FND_MESSAGE.SET_TOKEN('BSC_MEAS', p_Dataset_Rec.Bsc_Measure_Id);
1270: FND_MSG_PUB.ADD;
1271: RAISE FND_API.G_EXC_ERROR;
1272: end if;
1273:

Line 1528: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

1524: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1525: ,'dataset_id'
1526: ,p_Dataset_Rec.Bsc_Dataset_Id);
1527: if l_count = 0 then
1528: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1529: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_ERROR;
1532: end if;

Line 1529: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1525: ,'dataset_id'
1526: ,p_Dataset_Rec.Bsc_Dataset_Id);
1527: if l_count = 0 then
1528: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1529: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_ERROR;
1532: end if;
1533:

Line 1548: FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_MEASURE_IND_ERR_TXT');

1544: CLOSE indicators_cursor;
1545: end if;
1546:
1547: if l_indicators is not null then
1548: FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_MEASURE_IND_ERR_TXT');
1549: FND_MESSAGE.SET_TOKEN('BSC_INDICATORS', l_indicators);
1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: end if;

Line 1549: FND_MESSAGE.SET_TOKEN('BSC_INDICATORS', l_indicators);

1545: end if;
1546:
1547: if l_indicators is not null then
1548: FND_MESSAGE.SET_NAME('BSC','BSC_DELETE_MEASURE_IND_ERR_TXT');
1549: FND_MESSAGE.SET_TOKEN('BSC_INDICATORS', l_indicators);
1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: end if;
1553: else

Line 1554: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

1550: FND_MSG_PUB.ADD;
1551: RAISE FND_API.G_EXC_ERROR;
1552: end if;
1553: else
1554: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1555: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1556: FND_MSG_PUB.ADD;
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;

Line 1555: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1551: RAISE FND_API.G_EXC_ERROR;
1552: end if;
1553: else
1554: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1555: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1556: FND_MSG_PUB.ADD;
1557: RAISE FND_API.G_EXC_ERROR;
1558: end if;
1559:

Line 1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

1636: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1637: ,'dataset_id'
1638: ,p_Dataset_Rec.Bsc_Dataset_Id);
1639: if l_count = 0 then
1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1641: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: else -- Check that combination dataset id and calc id does not exist.

Line 1641: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1637: ,'dataset_id'
1638: ,p_Dataset_Rec.Bsc_Dataset_Id);
1639: if l_count = 0 then
1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1641: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: else -- Check that combination dataset id and calc id does not exist.
1645: select count(1)

Line 1651: FND_MESSAGE.SET_NAME('BSC','BSC_DTSET_CALC_EXISTSD');

1647: from BSC_SYS_DATASET_CALC
1648: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id
1649: and disabled_calc_id = p_Dataset_Rec.Bsc_Disabled_Calc_Id;
1650: if l_count <> 0 then
1651: FND_MESSAGE.SET_NAME('BSC','BSC_DTSET_CALC_EXISTSD');
1652: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Disabled_Calc_Id);
1653: FND_MSG_PUB.ADD;
1654: RAISE FND_API.G_EXC_ERROR;
1655: end if;

Line 1652: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Disabled_Calc_Id);

1648: where dataset_id = p_Dataset_Rec.Bsc_Dataset_Id
1649: and disabled_calc_id = p_Dataset_Rec.Bsc_Disabled_Calc_Id;
1650: if l_count <> 0 then
1651: FND_MESSAGE.SET_NAME('BSC','BSC_DTSET_CALC_EXISTSD');
1652: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Disabled_Calc_Id);
1653: FND_MSG_PUB.ADD;
1654: RAISE FND_API.G_EXC_ERROR;
1655: end if;
1656:

Line 1660: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

1656:
1657: end if;
1658:
1659: else
1660: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1661: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664: end if;

Line 1661: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1657: end if;
1658:
1659: else
1660: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1661: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664: end if;
1665:

Line 1768: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

1764: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DATASETS_B'
1765: ,'dataset_id'
1766: ,p_Dataset_Rec.Bsc_Dataset_Id);
1767: if l_count = 0 then
1768: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1769: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_ERROR;
1772: end if;

Line 1769: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1765: ,'dataset_id'
1766: ,p_Dataset_Rec.Bsc_Dataset_Id);
1767: if l_count = 0 then
1768: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1769: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_ERROR;
1772: end if;
1773: else

Line 1774: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

1770: FND_MSG_PUB.ADD;
1771: RAISE FND_API.G_EXC_ERROR;
1772: end if;
1773: else
1774: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1775: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1776: FND_MSG_PUB.ADD;
1777: RAISE FND_API.G_EXC_ERROR;
1778: end if;

Line 1775: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1771: RAISE FND_API.G_EXC_ERROR;
1772: end if;
1773: else
1774: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1775: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1776: FND_MSG_PUB.ADD;
1777: RAISE FND_API.G_EXC_ERROR;
1778: end if;
1779:

Line 1835: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');

1831: ,'dataset_id'
1832: ,p_Dataset_Rec.Bsc_Dataset_Id);
1833:
1834: if l_count = 0 then
1835: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1836: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: end if;

Line 1836: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1832: ,p_Dataset_Rec.Bsc_Dataset_Id);
1833:
1834: if l_count = 0 then
1835: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DTSET_ID');
1836: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: end if;
1840: else

Line 1841: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

1837: FND_MSG_PUB.ADD;
1838: RAISE FND_API.G_EXC_ERROR;
1839: end if;
1840: else
1841: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1842: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: end if;

Line 1842: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);

1838: RAISE FND_API.G_EXC_ERROR;
1839: end if;
1840: else
1841: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');
1842: FND_MESSAGE.SET_TOKEN('BSC_DATASET', p_Dataset_Rec.Bsc_Dataset_Id);
1843: FND_MSG_PUB.ADD;
1844: RAISE FND_API.G_EXC_ERROR;
1845: end if;
1846: