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_MSG_PUB

Line 141: FND_MSG_PUB.ADD;

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

Line 214: FND_MSG_PUB.ADD;

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

Line 222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

218:
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
223: ,p_data => x_msg_data);
224: raise;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

223: ,p_data => x_msg_data);
224: raise;
225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
228: ,p_data => x_msg_data);
229: raise;
230: WHEN NO_DATA_FOUND THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;

Line 232: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

228: ,p_data => x_msg_data);
229: raise;
230: WHEN NO_DATA_FOUND THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
233: ,p_data => x_msg_data);
234: raise;
235: WHEN OTHERS THEN
236: FND_MSG_PUB.Initialize;

Line 236: FND_MSG_PUB.Initialize;

232: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
233: ,p_data => x_msg_data);
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;

Line 240: FND_MSG_PUB.ADD;

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;
244: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 244: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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;
244: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
245: ,p_data => x_msg_data);
246:
247: raise;
248: end Create_Measures;

Line 316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

312:
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_ERROR;
316: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
317: ,p_data => x_msg_data);
318: raise;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

317: ,p_data => x_msg_data);
318: raise;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
322: ,p_data => x_msg_data);
323: raise;
324: WHEN NO_DATA_FOUND THEN
325: FND_MSG_PUB.Initialize;

Line 325: FND_MSG_PUB.Initialize;

321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
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;

Line 328: FND_MSG_PUB.ADD;

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;
332: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 332: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

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;
332: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
333: ,p_data => x_msg_data);
334: raise;
335:
336: end Retrieve_Measures;

Line 486: FND_MSG_PUB.ADD;

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
490: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');

Line 491: 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:
495: SELECT MEASURE_COL

Line 507: FND_MSG_PUB.ADD;

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

Line 682: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

678: IF indicators_cursor%ISOPEN THEN
679: CLOSE indicators_cursor;
680: END IF;
681: x_return_status := FND_API.G_RET_STS_ERROR;
682: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
683: ,p_data => x_msg_data);
684: RAISE;
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: IF(c_measures_col%ISOPEN) THEN

Line 693: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

689: IF indicators_cursor%ISOPEN THEN
690: CLOSE indicators_cursor;
691: END IF;
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
694: ,p_data => x_msg_data);
695: RAISE;
696: WHEN NO_DATA_FOUND THEN
697: IF(c_measures_col%ISOPEN) THEN

Line 704: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

700: IF indicators_cursor%ISOPEN THEN
701: CLOSE indicators_cursor;
702: END IF;
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
705: ,p_data => x_msg_data);
706: RAISE;
707: WHEN OTHERS THEN
708: IF(c_measures_col%ISOPEN) THEN

Line 715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

711: IF indicators_cursor%ISOPEN THEN
712: CLOSE indicators_cursor;
713: END IF;
714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
715: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
716: ,p_data => x_msg_data);
717: RAISE;
718:
719: end Update_Measures;

Line 747: FND_MSG_PUB.ADD;

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:
751: -- If the Meeasure_Id1 is not null (A+B Formula)

Line 760: FND_MSG_PUB.ADD;

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

Line 849: FND_MSG_PUB.ADD;

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:
853: EXCEPTION

Line 856: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

852:
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: x_return_status := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
857: ,p_data => x_msg_data);
858: RAISE;
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 861: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

857: ,p_data => x_msg_data);
858: RAISE;
859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
862: ,p_data => x_msg_data);
863: RAISE;
864: WHEN NO_DATA_FOUND THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;

Line 866: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

862: ,p_data => x_msg_data);
863: RAISE;
864: WHEN NO_DATA_FOUND THEN
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
867: ,p_data => x_msg_data);
868: RAISE;
869: WHEN OTHERS THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 871: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

867: ,p_data => x_msg_data);
868: RAISE;
869: WHEN OTHERS THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
872: ,p_data => x_msg_data);
873: RAISE;
874:
875: END Delete_Measures;

Line 899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

895:
896: EXCEPTION
897: WHEN FND_API.G_EXC_ERROR THEN
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
900: ,p_data => x_msg_data);
901: raise;
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 904: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

900: ,p_data => x_msg_data);
901: raise;
902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
905: ,p_data => x_msg_data);
906: raise;
907: WHEN NO_DATA_FOUND THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;

Line 909: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

905: ,p_data => x_msg_data);
906: raise;
907: WHEN NO_DATA_FOUND THEN
908: x_return_status := FND_API.G_RET_STS_ERROR;
909: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
910: ,p_data => x_msg_data);
911: raise;
912: WHEN OTHERS THEN
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 914: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

910: ,p_data => x_msg_data);
911: raise;
912: WHEN OTHERS THEN
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
915: ,p_data => x_msg_data);
916: raise;
917:
918: end Create_Formats;

Line 942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: x_return_status := FND_API.G_RET_STS_ERROR;
942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
943: ,p_data => x_msg_data);
944: raise;
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

943: ,p_data => x_msg_data);
944: raise;
945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
948: ,p_data => x_msg_data);
949: raise;
950: WHEN NO_DATA_FOUND THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;

Line 952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

948: ,p_data => x_msg_data);
949: raise;
950: WHEN NO_DATA_FOUND THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;
952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
953: ,p_data => x_msg_data);
954: raise;
955: WHEN OTHERS THEN
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 957: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

953: ,p_data => x_msg_data);
954: raise;
955: WHEN OTHERS THEN
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
958: ,p_data => x_msg_data);
959: raise;
960:
961: end Delete_Formats;

Line 1074: FND_MSG_PUB.ADD;

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

Line 1082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1078:
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: x_return_status := FND_API.G_RET_STS_ERROR;
1082: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1083: ,p_data => x_msg_data);
1084: raise;
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1087: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1083: ,p_data => x_msg_data);
1084: raise;
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1088: ,p_data => x_msg_data);
1089: raise;
1090: WHEN NO_DATA_FOUND THEN
1091: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1088: ,p_data => x_msg_data);
1089: raise;
1090: WHEN NO_DATA_FOUND THEN
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1093: ,p_data => x_msg_data);
1094: raise;
1095: WHEN OTHERS THEN
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1097: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1093: ,p_data => x_msg_data);
1094: raise;
1095: WHEN OTHERS THEN
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1098: ,p_data => x_msg_data);
1099: raise;
1100:
1101: end Create_Dataset;

Line 1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1158:
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR;
1162: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1163: ,p_data => x_msg_data);
1164: raise;
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1163: ,p_data => x_msg_data);
1164: raise;
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1167: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1168: ,p_data => x_msg_data);
1169: raise;
1170: WHEN NO_DATA_FOUND THEN
1171: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1172: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1168: ,p_data => x_msg_data);
1169: raise;
1170: WHEN NO_DATA_FOUND THEN
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN OTHERS THEN
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1177: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1173: ,p_data => x_msg_data);
1174: raise;
1175: WHEN OTHERS THEN
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1177: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1178: ,p_data => x_msg_data);
1179: raise;
1180:
1181: end Retrieve_Dataset;

Line 1231: FND_MSG_PUB.ADD;

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
1235: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

Line 1237: FND_MSG_PUB.ADD;

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

Line 1251: FND_MSG_PUB.ADD;

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
1255: FND_MESSAGE.SET_NAME('BSC','BSC_NO_MEAS_ID_ENTERED');

Line 1257: FND_MSG_PUB.ADD;

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:
1261: -- Check that valid 2nd measure id was entered.

Line 1270: FND_MSG_PUB.ADD;

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:
1274: end if;

Line 1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1465:
1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: raise;
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1470: ,p_data => x_msg_data);
1471: raise;
1472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1475: ,p_data => x_msg_data);
1476: raise;
1477: WHEN NO_DATA_FOUND THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1479: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1475: ,p_data => x_msg_data);
1476: raise;
1477: WHEN NO_DATA_FOUND THEN
1478: x_return_status := FND_API.G_RET_STS_ERROR;
1479: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1480: ,p_data => x_msg_data);
1481: raise;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1484: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1480: ,p_data => x_msg_data);
1481: raise;
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1484: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1485: ,p_data => x_msg_data);
1486: raise;
1487:
1488: end Update_Dataset;

Line 1530: FND_MSG_PUB.ADD;

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:
1534: -- mdamle 04/23/2003 - PMD - Measure Definer - Check if assigned to indicator

Line 1550: FND_MSG_PUB.ADD;

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
1554: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

Line 1556: FND_MSG_PUB.ADD;

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:
1560: OPEN c_short_name(p_Dataset_Rec.Bsc_Dataset_Id);

Line 1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1585:
1586: EXCEPTION
1587: WHEN FND_API.G_EXC_ERROR THEN
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1590: ,p_count => x_msg_count
1591: ,p_data => x_msg_data);
1592: raise;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1595: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1591: ,p_data => x_msg_data);
1592: raise;
1593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1595: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598: raise;
1599: WHEN NO_DATA_FOUND THEN

Line 1601: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1597: ,p_data => x_msg_data);
1598: raise;
1599: WHEN NO_DATA_FOUND THEN
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1602: ,p_count => x_msg_count
1603: ,p_data => x_msg_data);
1604: raise;
1605: WHEN OTHERS THEN

Line 1607: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE

1603: ,p_data => x_msg_data);
1604: raise;
1605: WHEN OTHERS THEN
1606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1607: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE
1608: ,p_count => x_msg_count
1609: ,p_data => x_msg_data);
1610: raise;
1611:

Line 1642: FND_MSG_PUB.ADD;

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)
1646: into l_count

Line 1653: FND_MSG_PUB.ADD;

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:
1657: end if;

Line 1662: FND_MSG_PUB.ADD;

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:
1666: -- Insert pertaining values into table bsc_sys_dataset_calc.

Line 1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1675:
1676: EXCEPTION
1677: WHEN FND_API.G_EXC_ERROR THEN
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1680: ,p_data => x_msg_data);
1681: raise;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1680: ,p_data => x_msg_data);
1681: raise;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1684: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1685: ,p_data => x_msg_data);
1686: raise;
1687: WHEN NO_DATA_FOUND THEN
1688: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1685: ,p_data => x_msg_data);
1686: raise;
1687: WHEN NO_DATA_FOUND THEN
1688: x_return_status := FND_API.G_RET_STS_ERROR;
1689: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1690: ,p_data => x_msg_data);
1691: raise;
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1690: ,p_data => x_msg_data);
1691: raise;
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1695: ,p_data => x_msg_data);
1696: raise;
1697:
1698: end Create_Dataset_Calc;

Line 1726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1722:
1723: EXCEPTION
1724: WHEN FND_API.G_EXC_ERROR THEN
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728: raise;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1727: ,p_data => x_msg_data);
1728: raise;
1729: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1732: ,p_data => x_msg_data);
1733: raise;
1734: WHEN NO_DATA_FOUND THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1736: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1732: ,p_data => x_msg_data);
1733: raise;
1734: WHEN NO_DATA_FOUND THEN
1735: x_return_status := FND_API.G_RET_STS_ERROR;
1736: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1737: ,p_data => x_msg_data);
1738: raise;
1739: WHEN OTHERS THEN
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1741: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1737: ,p_data => x_msg_data);
1738: raise;
1739: WHEN OTHERS THEN
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1742: ,p_data => x_msg_data);
1743: raise;
1744:
1745: end Retrieve_Dataset_Calc;

Line 1770: FND_MSG_PUB.ADD;

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
1774: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

Line 1776: FND_MSG_PUB.ADD;

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:
1780: update BSC_SYS_DATASET_CALC

Line 1791: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1787:
1788: EXCEPTION
1789: WHEN FND_API.G_EXC_ERROR THEN
1790: x_return_status := FND_API.G_RET_STS_ERROR;
1791: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1792: ,p_data => x_msg_data);
1793: raise;
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1796: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1792: ,p_data => x_msg_data);
1793: raise;
1794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1797: ,p_data => x_msg_data);
1798: raise;
1799: WHEN NO_DATA_FOUND THEN
1800: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1801: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1797: ,p_data => x_msg_data);
1798: raise;
1799: WHEN NO_DATA_FOUND THEN
1800: x_return_status := FND_API.G_RET_STS_ERROR;
1801: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1802: ,p_data => x_msg_data);
1803: raise;
1804: WHEN OTHERS THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1806: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1802: ,p_data => x_msg_data);
1803: raise;
1804: WHEN OTHERS THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1807: ,p_data => x_msg_data);
1808: raise;
1809:
1810: end Update_Dataset_Calc;

Line 1837: FND_MSG_PUB.ADD;

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
1841: FND_MESSAGE.SET_NAME('BSC','BSC_NO_DTSET_ID_ENTERED');

Line 1843: FND_MSG_PUB.ADD;

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:
1847: delete from BSC_SYS_DATASET_CALC

Line 1857: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1853:
1854: EXCEPTION
1855: WHEN FND_API.G_EXC_ERROR THEN
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859: raise;
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1862: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1858: ,p_data => x_msg_data);
1859: raise;
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1862: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1863: ,p_data => x_msg_data);
1864: raise;
1865: WHEN NO_DATA_FOUND THEN null;
1866: /*

Line 1868: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1864: raise;
1865: WHEN NO_DATA_FOUND THEN null;
1866: /*
1867: x_return_status := FND_API.G_RET_STS_ERROR;
1868: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1869: ,p_data => x_msg_data);
1870: raise;
1871: */
1872: WHEN OTHERS THEN

Line 1874: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1870: raise;
1871: */
1872: WHEN OTHERS THEN
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1875: ,p_data => x_msg_data);
1876: raise;
1877:
1878: end Delete_Dataset_Calc;

Line 1925: FND_MSG_PUB.Initialize;

1921:
1922: BEGIN
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924:
1925: FND_MSG_PUB.Initialize;
1926:
1927: UPDATE bsc_sys_datasets_tl
1928: SET name = p_Dataset_Rec.Bsc_Dataset_Name
1929: ,help = p_Dataset_Rec.Bsc_Dataset_Help

Line 1942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1938:
1939: EXCEPTION
1940: WHEN FND_API.G_EXC_ERROR THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1943: ,p_data => x_msg_data);
1944: RAISE;
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1943: ,p_data => x_msg_data);
1944: RAISE;
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1948: ,p_data => x_msg_data);
1949: RAISE;
1950: WHEN NO_DATA_FOUND THEN
1951: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1948: ,p_data => x_msg_data);
1949: RAISE;
1950: WHEN NO_DATA_FOUND THEN
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1953: ,p_data => x_msg_data);
1954: RAISE;
1955: WHEN OTHERS THEN
1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1957: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1953: ,p_data => x_msg_data);
1954: RAISE;
1955: WHEN OTHERS THEN
1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1957: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1958: ,p_data => x_msg_data);
1959: RAISE;
1960:
1961: END Translate_Measure;

Line 1981: FND_MSG_PUB.Initialize;

1977: SAVEPOINT TransMeasByLangBsc;
1978:
1979: x_return_status := FND_API.G_RET_STS_SUCCESS;
1980:
1981: FND_MSG_PUB.Initialize;
1982:
1983: UPDATE BSC_SYS_DATASETS_TL
1984: SET name = p_Dataset_Rec.Bsc_Dataset_Name
1985: ,help = p_Dataset_Rec.Bsc_Dataset_Help

Line 1999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1995: EXCEPTION
1996: WHEN FND_API.G_EXC_ERROR THEN
1997: ROLLBACK TO TransMeasByLangBsc;
1998: x_return_status := FND_API.G_RET_STS_ERROR;
1999: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2000: ,p_data => x_msg_data);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: ROLLBACK TO TransMeasByLangBsc;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2000: ,p_data => x_msg_data);
2001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2002: ROLLBACK TO TransMeasByLangBsc;
2003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2004: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2005: ,p_data => x_msg_data);
2006: WHEN NO_DATA_FOUND THEN
2007: ROLLBACK TO TransMeasByLangBsc;
2008: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2009: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2005: ,p_data => x_msg_data);
2006: WHEN NO_DATA_FOUND THEN
2007: ROLLBACK TO TransMeasByLangBsc;
2008: x_return_status := FND_API.G_RET_STS_ERROR;
2009: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2010: ,p_data => x_msg_data);
2011: WHEN OTHERS THEN
2012: ROLLBACK TO TransMeasByLangBsc;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2010: ,p_data => x_msg_data);
2011: WHEN OTHERS THEN
2012: ROLLBACK TO TransMeasByLangBsc;
2013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2014: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2015: ,p_data => x_msg_data);
2016:
2017: END Translate_Measure_By_Lang;
2018: --=============================================================================