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_BIS_MEASURE_PUB dependencies on FND_MSG_PUB

Line 251: FND_MSG_PUB.ADD;

247: AND Source = c_BSC;
248:
249: IF(l_Count>0) THEN
250: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
251: FND_MSG_PUB.ADD;
252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254: ELSE
255: FOR cd IN c_Create_Measure LOOP

Line 263: FND_MSG_PUB.ADD;

259: , p_Bsc_Old_Source => cd.Bsc_Source
260: );
261: IF (NOT l_Flag) THEN
262: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
263: FND_MSG_PUB.ADD;
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: END LOOP;
267: END IF;

Line 281: FND_MSG_PUB.ADD;

277: AND Dataset_id <> p_dataset_id;
278:
279: IF(l_Count>0) THEN
280: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
281: FND_MSG_PUB.ADD;
282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: ELSE
285: FOR cd IN c_Update_Measure LOOP

Line 293: FND_MSG_PUB.ADD;

289: , p_Bsc_Old_Source => cd.Bsc_Source
290: );
291: IF (NOT l_Flag) THEN
292: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_NAME_UNIQUE');
293: FND_MSG_PUB.ADD;
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: END LOOP;
297: END IF;

Line 371: fnd_msg_pub.initialize;

367: begin
368: SAVEPOINT SP_CREATE_MEASURE;
369:
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371: fnd_msg_pub.initialize;
372:
373: l_measure_short_name := p_measure_short_name;
374: IF (UPPER(p_is_default_short_name) = 'T') THEN
375: --check for unqiue short name, if not unique, provide a unique one

Line 452: FND_MSG_PUB.Count_And_Get

448: );
449: EXCEPTION
450: WHEN FND_API.G_EXC_ERROR THEN
451: IF (x_msg_data IS NULL) THEN
452: FND_MSG_PUB.Count_And_Get
453: ( p_encoded => FND_API.G_FALSE
454: , p_count => x_msg_count
455: , p_data => x_msg_data
456: );

Line 462: FND_MSG_PUB.Count_And_Get

458: ROLLBACK TO SP_CREATE_MEASURE;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: IF (x_msg_data IS NULL) THEN
462: FND_MSG_PUB.Count_And_Get
463: ( p_encoded => FND_API.G_FALSE
464: , p_count => x_msg_count
465: , p_data => x_msg_data
466: );

Line 549: fnd_msg_pub.initialize;

545: begin
546: SAVEPOINT SP_CREATE_MEASURE;
547:
548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549: fnd_msg_pub.initialize;
550:
551: --dispatch create_measure
552: BSC_BIS_MEASURE_PUB.Create_Measure(
553: p_commit => p_commit

Line 611: FND_MSG_PUB.Count_And_Get

607: );
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: IF (x_msg_data IS NULL) THEN
611: FND_MSG_PUB.Count_And_Get
612: ( p_encoded => FND_API.G_FALSE
613: , p_count => x_msg_count
614: , p_data => x_msg_data
615: );

Line 621: FND_MSG_PUB.Count_And_Get

617: ROLLBACK TO SP_CREATE_MEASURE;
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: IF (x_msg_data IS NULL) THEN
621: FND_MSG_PUB.Count_And_Get
622: ( p_encoded => FND_API.G_FALSE
623: , p_count => x_msg_count
624: , p_data => x_msg_data
625: );

Line 715: fnd_msg_pub.initialize;

711: begin
712: SAVEPOINT SP_CREATE_MEASURE;
713:
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715: fnd_msg_pub.initialize;
716:
717: l_Dataset_Rec.Bsc_Source := p_dataset_source;
718: l_Dataset_Rec.Bsc_Dataset_Help := p_dataset_help;
719: l_Dataset_Rec.Bsc_Measure_Id := p_dataset_measure_id1;

Line 764: FND_MSG_PUB.ADD;

760: IF (NOT is_Valid_AlphaNum(l_Dataset_Rec.Bsc_Measure_Short_Name)) THEN
761: FND_MESSAGE.SET_NAME('BSC','BSC_ALPHA_NUM_REQUIRED');
762: FND_MESSAGE.SET_TOKEN('VALUE', l_Dataset_Rec.Bsc_Measure_Short_Name);
763: FND_MESSAGE.SET_TOKEN('NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'), TRUE);
764: FND_MSG_PUB.ADD;
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767:
768: SELECT COUNT(Short_Name) INTO l_count

Line 773: FND_MSG_PUB.ADD;

769: FROM BIS_INDICATORS
770: WHERE UPPER(TRIM(Short_Name)) = l_Dataset_Rec.Bsc_Measure_Short_Name;
771: IF (l_count > 0) THEN
772: FND_MESSAGE.SET_NAME('BIS','BIS_MEASURE_SHORT_NAME_UNIQUE');
773: FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: END IF;
777:

Line 1033: FND_MSG_PUB.ADD;

1029: IF (l_error_tbl.COUNT > 0) THEN
1030: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
1031: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
1032: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
1033: FND_MSG_PUB.ADD;
1034: x_msg_data := NULL;
1035: END IF;
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: END IF;

Line 1065: FND_MSG_PUB.Count_And_Get

1061:
1062: EXCEPTION
1063: WHEN FND_API.G_EXC_ERROR THEN
1064: IF (x_msg_data IS NULL) THEN
1065: FND_MSG_PUB.Count_And_Get
1066: ( p_encoded => FND_API.G_FALSE
1067: , p_count => x_msg_count
1068: , p_data => x_msg_data
1069: );

Line 1075: FND_MSG_PUB.Count_And_Get

1071: ROLLBACK TO SP_CREATE_MEASURE;
1072: x_return_status := FND_API.G_RET_STS_ERROR;
1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1074: IF (x_msg_data IS NULL) THEN
1075: FND_MSG_PUB.Count_And_Get
1076: ( p_encoded => FND_API.G_FALSE
1077: , p_count => x_msg_count
1078: , p_data => x_msg_data
1079: );

Line 1161: fnd_msg_pub.initialize;

1157: ) is
1158: begin
1159: SAVEPOINT SP_UPDATE_MEASURE;
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161: fnd_msg_pub.initialize;
1162:
1163: Update_Measure(
1164: p_commit => p_commit
1165: ,p_dataset_id => p_dataset_id

Line 1223: FND_MSG_PUB.Count_And_Get

1219: );
1220: EXCEPTION
1221: WHEN FND_API.G_EXC_ERROR THEN
1222: IF (x_msg_data IS NULL) THEN
1223: FND_MSG_PUB.Count_And_Get
1224: ( p_encoded => FND_API.G_FALSE
1225: , p_count => x_msg_count
1226: , p_data => x_msg_data
1227: );

Line 1233: FND_MSG_PUB.Count_And_Get

1229: ROLLBACK TO SP_UPDATE_MEASURE;
1230: x_return_status := FND_API.G_RET_STS_ERROR;
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: IF (x_msg_data IS NULL) THEN
1233: FND_MSG_PUB.Count_And_Get
1234: ( p_encoded => FND_API.G_FALSE
1235: , p_count => x_msg_count
1236: , p_data => x_msg_data
1237: );

Line 1444: FND_MSG_PUB.Count_And_Get

1440: CLOSE indicators_cursor;
1441: END IF;
1442:
1443: IF (x_msg_data IS NULL) THEN
1444: FND_MSG_PUB.Count_And_Get
1445: ( p_encoded => FND_API.G_FALSE
1446: , p_count => x_msg_count
1447: , p_data => x_msg_data
1448: );

Line 1594: fnd_msg_pub.initialize;

1590:
1591: begin
1592: SAVEPOINT SP_UPDATE_MEASURE;
1593: x_return_status := FND_API.G_RET_STS_SUCCESS;
1594: fnd_msg_pub.initialize;
1595:
1596: l_Dataset_Rec.Bsc_dataset_id := p_dataset_id;
1597: l_Dataset_Rec.Bsc_Source := p_dataset_source;
1598: l_Dataset_Rec.Bsc_Dataset_Help := p_dataset_help;

Line 1728: FND_MSG_PUB.ADD;

1724: l_Report_Objectives := Get_Report_Objectives(p_Dataset_Id);
1725: IF (l_Report_Objectives IS NOT NULL) THEN
1726: FND_MESSAGE.SET_NAME('BIS','BIS_KPI_NON_FORMULA_FOR_AGRPT');
1727: FND_MESSAGE.SET_TOKEN('OBJECTIVES', l_Report_Objectives);
1728: FND_MSG_PUB.ADD;
1729: RAISE FND_API.G_EXC_ERROR;
1730: END IF;
1731: END IF ;
1732:

Line 1989: FND_MSG_PUB.ADD;

1985: IF (l_error_tbl.COUNT > 0) THEN
1986: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
1987: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
1988: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
1989: FND_MSG_PUB.ADD;
1990: x_msg_data := NULL;
1991: END IF;
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: END IF;

Line 2013: FND_MSG_PUB.ADD;

2009: IF (l_error_tbl.COUNT > 0) THEN
2010: x_msg_data := l_error_tbl(l_error_tbl.COUNT).Error_Description;
2011: IF(INSTR(x_msg_data, ' ') = 0 ) THEN
2012: FND_MESSAGE.SET_NAME('BIS',x_msg_data);
2013: FND_MSG_PUB.ADD;
2014: x_msg_data := NULL;
2015: END IF;
2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2017: END IF;

Line 2097: FND_MSG_PUB.Count_And_Get

2093: IF ( c_Bsc_Measure_Color_Formula%ISOPEN) THEN
2094: CLOSE c_Bsc_Measure_Color_Formula;
2095: END IF;
2096: IF (x_msg_data IS NULL) THEN
2097: FND_MSG_PUB.Count_And_Get
2098: ( p_encoded => FND_API.G_FALSE
2099: , p_count => x_msg_count
2100: , p_data => x_msg_data
2101: );

Line 2113: FND_MSG_PUB.Count_And_Get

2109: IF ( c_Bsc_Measure_Color_Formula%ISOPEN) THEN
2110: CLOSE c_Bsc_Measure_Color_Formula;
2111: END IF;
2112: IF (x_msg_data IS NULL) THEN
2113: FND_MSG_PUB.Count_And_Get
2114: ( p_encoded => FND_API.G_FALSE
2115: , p_count => x_msg_count
2116: , p_data => x_msg_data
2117: );

Line 2168: fnd_msg_pub.initialize;

2164: l_count number;
2165: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
2166:
2167: begin
2168: fnd_msg_pub.initialize;
2169:
2170: l_Dataset_Rec.Bsc_dataset_id := p_dataset_id;
2171:
2172: -- START : Granular Locking Needs do come on the top.- Fixed by ADRAO

Line 2246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2242: END IF;
2243: EXCEPTION
2244: WHEN FND_API.G_EXC_ERROR THEN
2245: x_return_status := FND_API.G_RET_STS_ERROR;
2246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2247: ,p_data => x_msg_data);
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2250: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2247: ,p_data => x_msg_data);
2248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2250: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2251: ,p_data => x_msg_data);
2252: WHEN NO_DATA_FOUND THEN
2253: x_return_status := FND_API.G_RET_STS_ERROR;
2254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2250: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2251: ,p_data => x_msg_data);
2252: WHEN NO_DATA_FOUND THEN
2253: x_return_status := FND_API.G_RET_STS_ERROR;
2254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2255: ,p_data => x_msg_data);
2256: WHEN OTHERS THEN
2257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2258: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2258: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2254: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2255: ,p_data => x_msg_data);
2256: WHEN OTHERS THEN
2257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2258: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2259: ,p_data => x_msg_data);
2260: if (x_msg_data is null) then
2261: x_msg_data := SQLERRM;
2262: end if;

Line 2303: FND_MSG_PUB.Initialize;

2299: BEGIN
2300:
2301: SAVEPOINT Cascade_Disable_Calc_PUB;
2302: x_return_status := FND_API.G_RET_STS_SUCCESS;
2303: FND_MSG_PUB.Initialize;
2304:
2305: FOR cd IN c_kpis LOOP
2306: BSC_KPI_SERIES_PUB.Save_Default_Calculation(
2307: p_commit => FND_API.G_FALSE

Line 2330: FND_MSG_PUB.Count_And_Get

2326: EXCEPTION
2327: WHEN FND_API.G_EXC_ERROR THEN
2328: ROLLBACK TO Cascade_Disable_Calc_PUB;
2329: IF (x_msg_data IS NULL) THEN
2330: FND_MSG_PUB.Count_And_Get
2331: ( p_encoded => FND_API.G_FALSE
2332: , p_count => x_msg_count
2333: , p_data => x_msg_data
2334: );

Line 2340: FND_MSG_PUB.Count_And_Get

2336: x_return_status := FND_API.G_RET_STS_ERROR;
2337: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2338: ROLLBACK TO Cascade_Disable_Calc_PUB;
2339: IF (x_msg_data IS NULL) THEN
2340: FND_MSG_PUB.Count_And_Get
2341: ( p_encoded => FND_API.G_FALSE
2342: , p_count => x_msg_count
2343: , p_data => x_msg_data
2344: );

Line 2377: fnd_msg_pub.initialize;

2373:
2374: l_Dataset_Rec BSC_DATASETS_PUB.Bsc_Dataset_Rec_Type;
2375: begin
2376:
2377: fnd_msg_pub.initialize;
2378:
2379: l_Dataset_Rec.Bsc_Dataset_Id:= p_dataset_id;
2380:
2381: -- Disabled Calculations

Line 2432: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2428:
2429: EXCEPTION
2430: WHEN FND_API.G_EXC_ERROR THEN
2431: x_return_status := FND_API.G_RET_STS_ERROR;
2432: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2433: ,p_data => x_msg_data);
2434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2432: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2433: ,p_data => x_msg_data);
2434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2437: ,p_data => x_msg_data);
2438: WHEN NO_DATA_FOUND THEN
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2440: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2437: ,p_data => x_msg_data);
2438: WHEN NO_DATA_FOUND THEN
2439: x_return_status := FND_API.G_RET_STS_ERROR;
2440: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2441: ,p_data => x_msg_data);
2442: WHEN OTHERS THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2444: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2440: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2441: ,p_data => x_msg_data);
2442: WHEN OTHERS THEN
2443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2444: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2445: ,p_data => x_msg_data);
2446: if (x_msg_data is null) then
2447: x_msg_data := SQLERRM;
2448: end if;

Line 2490: fnd_msg_pub.initialize;

2486: AND cause_indicator = p_dataset_id;
2487:
2488: begin
2489:
2490: fnd_msg_pub.initialize;
2491:
2492: -- mdamle 08/18/2003 - Check for same cause and effect measure
2493: if p_causes_table is not null and p_effects_table is not null then
2494: for i in 1..p_causes_table.count loop

Line 2515: FND_MSG_PUB.ADD;

2511:
2512: if l_measure_names is not null then
2513: FND_MESSAGE.SET_NAME('BSC','BSC_CAE_USED_AT_SAME_TIME');
2514: FND_MESSAGE.SET_TOKEN('LIST', l_measure_names);
2515: FND_MSG_PUB.ADD;
2516: RAISE FND_API.G_EXC_ERROR;
2517: end if;
2518: end if;
2519:

Line 2634: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2630:
2631: EXCEPTION
2632: WHEN FND_API.G_EXC_ERROR THEN
2633: x_return_status := FND_API.G_RET_STS_ERROR;
2634: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2635: ,p_data => x_msg_data);
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2638: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2638: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2634: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2635: ,p_data => x_msg_data);
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2638: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2639: ,p_data => x_msg_data);
2640: WHEN NO_DATA_FOUND THEN
2641: x_return_status := FND_API.G_RET_STS_ERROR;
2642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2638: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2639: ,p_data => x_msg_data);
2640: WHEN NO_DATA_FOUND THEN
2641: x_return_status := FND_API.G_RET_STS_ERROR;
2642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644: WHEN OTHERS THEN
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

2642: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644: WHEN OTHERS THEN
2645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2646: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2647: ,p_data => x_msg_data);
2648: if (x_msg_data is null) then
2649: x_msg_data := SQLERRM;
2650: end if;

Line 2675: FND_MSG_PUB.ADD;

2671: else
2672: if (p_Dataset_Rec.Bsc_Measure_operation = c_AVGL_CODE) and isFormula(p_Dataset_Rec.Bsc_Measure_Col) then
2673: -- Do not allow this condition
2674: FND_MESSAGE.SET_NAME('BSC','BSC_AVGLOWESTLEVEL_ERR_TXT');
2675: FND_MSG_PUB.ADD;
2676: RAISE FND_API.G_EXC_ERROR;
2677: end if;
2678: end if;
2679:

Line 2890: fnd_msg_pub.initialize;

2886:
2887: l_upload_test BOOLEAN := FALSE;
2888: l_is_create BOOLEAN := TRUE;
2889: BEGIN
2890: fnd_msg_pub.initialize;
2891: /*
2892: l_msg := 'The Performance Measure ' || p_measure_rec.measure_name ;
2893: l_msg := l_msg || ' could not be created/updated.';
2894: */

Line 2995: FND_MSG_PUB.ADD;

2991: --if upload_test result is false, does not allow update of this record, throw exception
2992: IF (l_upload_test = FALSE) THEN
2993: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');
2994: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);
2995: FND_MSG_PUB.ADD;
2996: RAISE FND_API.G_EXC_ERROR;
2997: END IF;
2998: END IF;
2999:

Line 3169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3165: WHEN NO_DATA_FOUND THEN
3166: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3167: x_return_status := FND_API.G_RET_STS_ERROR ;
3168: IF(x_msg_data IS NULL) THEN
3169: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3170: ,p_count => x_msg_count
3171: ,p_data => x_msg_data);
3172: END IF;
3173: RAISE;

Line 3178: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3174: WHEN FND_API.G_EXC_ERROR THEN
3175: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3176: x_return_status := FND_API.G_RET_STS_ERROR ;
3177: IF(x_msg_data IS NULL) THEN
3178: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3179: ,p_count => x_msg_count
3180: ,p_data => x_msg_data);
3181: END IF;
3182: RAISE;

Line 3187: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3184: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3186: IF(x_msg_data IS NULL) THEN
3187: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3188: ,p_count => x_msg_count
3189: ,p_data => x_msg_data);
3190: END IF;
3191: RAISE;

Line 3196: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3192: WHEN others THEN
3193: -- BIS_UTILITIES_PUB.put_line(p_text =>l_msg);
3194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3195: IF(x_msg_data IS NULL) THEN
3196: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3197: ,p_count => x_msg_count
3198: ,p_data => x_msg_data);
3199: END IF;
3200: RAISE;

Line 3224: FND_MSG_PUB.Initialize;

3220: BEGIN
3221:
3222: x_return_status := FND_API.G_RET_STS_SUCCESS;
3223:
3224: FND_MSG_PUB.Initialize;
3225:
3226: --bug#4045278: data versioning
3227: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(
3228: p_measure_short_name => p_Measure_Rec.Measure_Short_Name

Line 3239: FND_MSG_PUB.ADD;

3235: --if upload_test result is false, does not allow update of this record, throw exception
3236: IF (l_upload_test = FALSE) THEN
3237: FND_MESSAGE.SET_NAME('BIS','BIS_MEA_UPLOAD_TEST_FAILED');
3238: FND_MESSAGE.SET_TOKEN('SHORT_NAME', p_Measure_Rec.Measure_Short_Name);
3239: FND_MSG_PUB.ADD;
3240: RAISE FND_API.G_EXC_ERROR;
3241: END IF;
3242:
3243: l_dataset_rec := p_Dataset_Rec;

Line 3287: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3283:
3284: EXCEPTION
3285: WHEN FND_API.G_EXC_ERROR THEN
3286: x_return_status := FND_API.G_RET_STS_ERROR;
3287: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3288: ,p_count => x_msg_count
3289: ,p_data => x_msg_data);
3290: RAISE;
3291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3293: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3289: ,p_data => x_msg_data);
3290: RAISE;
3291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3293: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3294: ,p_count => x_msg_count
3295: ,p_data => x_msg_data);
3296: RAISE;
3297: WHEN NO_DATA_FOUND THEN

Line 3299: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3295: ,p_data => x_msg_data);
3296: RAISE;
3297: WHEN NO_DATA_FOUND THEN
3298: x_return_status := FND_API.G_RET_STS_ERROR;
3299: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3300: ,p_count => x_msg_count
3301: ,p_data => x_msg_data);
3302: RAISE;
3303: WHEN OTHERS THEN

Line 3305: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'

3301: ,p_data => x_msg_data);
3302: RAISE;
3303: WHEN OTHERS THEN
3304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3305: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
3306: ,p_count => x_msg_count
3307: ,p_data => x_msg_data);
3308: RAISE;
3309:

Line 3454: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

3450:
3451: EXCEPTION
3452: WHEN FND_API.G_EXC_ERROR THEN
3453: x_return_status := FND_API.G_RET_STS_ERROR;
3454: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3455: ,p_data => x_msg_data);
3456: RAISE;
3457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3459: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

3455: ,p_data => x_msg_data);
3456: RAISE;
3457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3459: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3460: ,p_data => x_msg_data);
3461: RAISE;
3462: WHEN OTHERS THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3464: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

3460: ,p_data => x_msg_data);
3461: RAISE;
3462: WHEN OTHERS THEN
3463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3465: ,p_data => x_msg_data);
3466: RAISE;
3467: END Order_Dimensions_For_Ldt;
3468: --=============================================================================

Line 3651: fnd_msg_pub.Initialize;

3647: AND m.measure_col =db.measure_col;
3648:
3649: begin
3650:
3651: fnd_msg_pub.Initialize;
3652:
3653: if bsc_utility.isBscInProductionMode then
3654: select count(c.projection_id)
3655: into l_count

Line 3733: fnd_msg_pub.ADD;

3729: -- Provide a structural changes warning first
3730: if((upper(p_is_xtd_enabled) <> l_is_xtd_enabled) and (p_is_xtd_enabled is not null)) then -- l_is_xtd_enabled is always caps.
3731: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3732: fnd_message.set_token('INDICATORS', l_kpis);
3733: fnd_msg_pub.ADD;
3734: -- raise fnd_api.g_exc_error;
3735: end if;
3736:
3737: if((upper(p_formula) <> upper(l_formula)) and (p_formula is not null)) then

Line 3741: fnd_msg_pub.ADD;

3737: if((upper(p_formula) <> upper(l_formula)) and (p_formula is not null)) then
3738: IF (BSC_DATASETS_PVT.Is_Structure_change(upper(p_formula), upper(l_formula))) THEN
3739: fnd_message.set_name('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3740: fnd_message.set_token('INDICATORS', l_kpis);
3741: fnd_msg_pub.ADD;
3742: raise fnd_api.g_exc_error;
3743: ELSE
3744: fnd_message.set_name('BIS','BIS_PMD_KPI_NONSTRUCT_INVALID');
3745: fnd_message.set_token('OBJECTIVES', l_kpis);

Line 3746: fnd_msg_pub.ADD;

3742: raise fnd_api.g_exc_error;
3743: ELSE
3744: fnd_message.set_name('BIS','BIS_PMD_KPI_NONSTRUCT_INVALID');
3745: fnd_message.set_token('OBJECTIVES', l_kpis);
3746: fnd_msg_pub.ADD;
3747: raise fnd_api.g_exc_error;
3748: END IF;
3749: end if;
3750:

Line 3755: FND_MSG_PUB.ADD;

3751: IF((p_Measure_Group_Id IS NOT NULL ) AND (l_measure_group_id IS NOT NULL)) THEN
3752: IF(p_Measure_Group_Id <> l_measure_group_id) THEN
3753: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
3754: FND_MESSAGE.SET_TOKEN('INDICATORS', l_kpis);
3755: FND_MSG_PUB.ADD;
3756: RAISE FND_API.G_EXC_ERROR;
3757: END IF;
3758: END IF;
3759:

Line 3763: fnd_msg_pub.ADD;

3759:
3760: if ((l_measure_type <> p_measure_type) and (p_measure_type <> -1)) then
3761: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3762: fnd_message.set_token('INDICATORS', l_kpis);
3763: fnd_msg_pub.ADD;
3764: raise fnd_api.g_exc_error;
3765: end if;
3766:
3767: -- color changes is a sub-set change for structural changes, hence comes next

Line 3773: fnd_msg_pub.ADD;

3769: -- Fixed for bug#3798834
3770: if((upper(p_rollup_calc) <> upper(l_rollup_calc)) and (p_rollup_calc is not null)) then
3771: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3772: fnd_message.set_token('INDICATORS', l_kpis);
3773: fnd_msg_pub.ADD;
3774: raise fnd_api.g_exc_error;
3775: end if;
3776:
3777:

Line 3781: fnd_msg_pub.ADD;

3777:
3778: if ((l_proj_id <> p_measure_projection_id) and (p_measure_projection_id <> -1)) then
3779: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3780: fnd_message.set_token('INDICATORS', l_kpis);
3781: fnd_msg_pub.ADD;
3782: raise fnd_api.g_exc_error;
3783: end if;
3784:
3785: -- l_is_ytd_enabled is always caps.

Line 3789: fnd_msg_pub.ADD;

3785: -- l_is_ytd_enabled is always caps.
3786: if((upper(p_is_ytd_enabled) <> l_is_ytd_enabled) and (p_is_ytd_enabled is not null)) then
3787: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3788: fnd_message.set_token('INDICATORS', l_kpis);
3789: fnd_msg_pub.ADD;
3790: raise fnd_api.g_exc_error;
3791: end if;
3792:
3793: -- l_is_qtd_enabled is always caps.

Line 3797: fnd_msg_pub.ADD;

3793: -- l_is_qtd_enabled is always caps.
3794: if((upper(p_is_qtd_enabled) <> l_is_qtd_enabled) and (p_is_qtd_enabled is not null)) then
3795: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
3796: fnd_message.set_token('INDICATORS', l_kpis);
3797: fnd_msg_pub.ADD;
3798: raise fnd_api.g_exc_error;
3799: end if;
3800: END IF;-- END L_KPIS IS NOT NULL
3801: END IF;

Line 3806: fnd_msg_pub.count_and_get

3802: EXCEPTION
3803: WHEN FND_API.G_EXC_ERROR THEN
3804:
3805: if (x_msg_data is null) then
3806: fnd_msg_pub.count_and_get
3807: ( p_encoded => fnd_api.g_false
3808: , p_count => x_msg_count
3809: , p_data => x_msg_data
3810: );

Line 3815: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

3811: end if;
3812:
3813: when others then
3814: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3815: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
3816: ,p_data => x_msg_data);
3817:
3818: -- fixed for Bug#3296451
3819: x_msg_data := null;

Line 4055: fnd_msg_pub.Initialize;

4051: begin
4052:
4053:
4054: -- set the proper values for the color tolerance levels.
4055: fnd_msg_pub.Initialize;
4056:
4057:
4058: if bsc_utility.isBscInProductionMode then
4059: l_m1_accept := remove_percent(p_m1_accept);

Line 4181: fnd_msg_pub.ADD;

4177:
4178: if (l_indicators is not null) then
4179: fnd_message.set_name('BSC','BSC_PMD_KPI_COLOR_INVALID');
4180: fnd_message.set_token('INDICATORS', l_indicators);
4181: fnd_msg_pub.ADD;
4182: raise fnd_api.g_exc_error;
4183: end if;
4184:
4185: end if; -- end isBscInProductionMode

Line 4190: fnd_msg_pub.count_and_get

4186:
4187: exception
4188: when fnd_api.g_exc_error then
4189: if (x_msg_data is null) then
4190: fnd_msg_pub.count_and_get
4191: ( p_encoded => fnd_api.g_false
4192: , p_count => x_msg_count
4193: , p_data => x_msg_data
4194: );

Line 4200: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

4196:
4197:
4198: when others then
4199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4200: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
4201: ,p_data => x_msg_data);
4202:
4203: x_msg_data := x_msg_data || sqlerrm;
4204: