DBA Data[Home] [Help]

APPS.BSC_OBJ_ANALYSIS_OPTIONS_PUB dependencies on FND_MSG_PUB

Line 49: FND_MSG_PUB.Initialize;

45:
46: BEGIN
47: SAVEPOINT Check_UserLevel_Values_PVT;
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
49: FND_MSG_PUB.Initialize;
50:
51: SELECT
52: a0_default,a1_default,a2_default
53: INTO

Line 175: FND_MSG_PUB.Initialize;

171:
172: BEGIN
173: SAVEPOINT Update_Change_DimSet_PVT;
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175: FND_MSG_PUB.Initialize;
176:
177: UPDATE
178: bsc_kpi_analysis_groups
179: SET

Line 250: FND_MSG_PUB.Initialize;

246: BEGIN
247:
248: SAVEPOINT Update_Default_Flag_Val_PVT;
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250: FND_MSG_PUB.Initialize;
251:
252: --Only if the default value is modified
253: UPDATE
254: bsc_kpi_analysis_groups

Line 376: FND_MSG_PUB.Initialize;

372:
373: BEGIN
374: SAVEPOINT Check_YTD_Apply_PVT;
375: x_return_status := FND_API.G_RET_STS_SUCCESS;
376: FND_MSG_PUB.Initialize;
377:
378:
379: OPEN c_YTD_Value;
380: FETCH c_YTD_Value INTO l_YTD_Value;

Line 642: FND_MSG_PUB.Count_And_Get

638: EXCEPTION
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO Check_Default_Props_PVT;
641: IF (x_msg_data IS NULL) THEN
642: FND_MSG_PUB.Count_And_Get
643: ( p_encoded => FND_API.G_FALSE
644: , p_count => x_msg_count
645: , p_data => x_msg_data
646: );

Line 910: FND_MSG_PUB.Count_And_Get

906: EXCEPTION
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908: ROLLBACK TO Update_Analayis_Option_PUB;
909: IF (x_msg_data IS NULL) THEN
910: FND_MSG_PUB.Count_And_Get
911: ( p_encoded => FND_API.G_FALSE
912: , p_count => x_msg_count
913: , p_data => x_msg_data
914: );

Line 1034: FND_MSG_PUB.ADD;

1030: , p_Indicator);
1031: IF l_Count = 0 THEN
1032: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1033: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
1034: FND_MSG_PUB.ADD;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037: ELSE
1038: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1040: FND_MSG_PUB.ADD;

1036: END IF;
1037: ELSE
1038: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1039: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
1040: FND_MSG_PUB.ADD;
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF;
1043: BSC_BIS_LOCKS_PUB.LOCK_KPI
1044: ( p_Kpi_Id => p_Indicator

Line 1363: FND_MSG_PUB.Count_And_Get

1359: EXCEPTION
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO Update_Analayis_Option_PUB;
1362: IF (x_msg_data IS NULL) THEN
1363: FND_MSG_PUB.Count_And_Get
1364: ( p_encoded => FND_API.G_FALSE
1365: , p_count => x_msg_count
1366: , p_data => x_msg_data
1367: );

Line 1429: FND_MSG_PUB.Initialize;

1425:
1426: BEGIN
1427: SAVEPOINT Delete_Mind_Options_PVT;
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;
1429: FND_MSG_PUB.Initialize;
1430:
1431: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
1432: l_Par_Opt_Rec := p_Anal_Opt_Rec;
1433: l_criteria := ' WHERE indicator = '||l_Anal_Opt_Rec.Bsc_Kpi_Id;

Line 1563: FND_MSG_PUB.Initialize;

1559: BEGIN
1560:
1561: SAVEPOINT Delete_Mind_Data_PVT;
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563: FND_MSG_PUB.Initialize;
1564:
1565: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
1566:
1567:

Line 1812: FND_MSG_PUB.Initialize;

1808: BEGIN
1809:
1810: SAVEPOINT Update_Ana_Opt_Count_PVT;
1811: x_return_status := FND_API.G_RET_STS_SUCCESS;
1812: FND_MSG_PUB.Initialize;
1813:
1814: OPEN c_max_grp_id;
1815: FETCH c_max_grp_id INTO l_Max_Grp_Id;
1816: CLOSE c_max_grp_id;

Line 1924: FND_MSG_PUB.Initialize;

1920:
1921: BEGIN
1922: SAVEPOINT BscObjDeleteAnaOptWrap;
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: FND_MSG_PUB.Initialize;
1925:
1926: l_Bsc_Anal_Opt_Rec := p_Anal_Opt_Rec;
1927: l_Dependency01 := Get_Dependency(p_Anal_Opt_Rec.Bsc_Kpi_Id, 1);
1928: l_Dependency12 := Get_Dependency(p_Anal_Opt_Rec.Bsc_Kpi_Id, 2);

Line 2060: FND_MSG_PUB.Count_And_Get

2056: EXCEPTION
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2058: ROLLBACK TO BscObjDeleteAnaOptWrap;
2059: IF (x_msg_data IS NULL) THEN
2060: FND_MSG_PUB.Count_And_Get
2061: ( p_encoded => FND_API.G_FALSE
2062: , p_count => x_msg_count
2063: , p_data => x_msg_data
2064: );

Line 2099: FND_MSG_PUB.Initialize;

2095:
2096: BEGIN
2097: SAVEPOINT Reset_Group_Defaults_PVT;
2098: x_return_status := FND_API.G_RET_STS_SUCCESS;
2099: FND_MSG_PUB.Initialize;
2100:
2101: l_Dependency01 := Get_Dependency(p_Indicator,1);
2102: l_Dependency12 := Get_Dependency(p_Indicator,2);
2103:

Line 2221: FND_MSG_PUB.Initialize;

2217:
2218: BEGIN
2219: SAVEPOINT Remove_Empty_Groups_PVT;
2220: x_return_status := FND_API.G_RET_STS_SUCCESS;
2221: FND_MSG_PUB.Initialize;
2222:
2223: l_Dependency01 := Get_Dependency(p_Indicator,1);
2224: l_Dependency12 := Get_Dependency(p_Indicator,2);
2225:

Line 2276: FND_MSG_PUB.Count_And_Get

2272: EXCEPTION
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: ROLLBACK TO Remove_Empty_Groups_PVT;
2275: IF (x_msg_data IS NULL) THEN
2276: FND_MSG_PUB.Count_And_Get
2277: ( p_encoded => FND_API.G_FALSE
2278: , p_count => x_msg_count
2279: , p_data => x_msg_data
2280: );

Line 2368: FND_MSG_PUB.ADD;

2364: , p_Indicator);
2365: IF l_Count = 0 THEN
2366: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2367: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
2368: FND_MSG_PUB.ADD;
2369: RAISE FND_API.G_EXC_ERROR;
2370: END IF;
2371: ELSE
2372: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 2374: FND_MSG_PUB.ADD;

2370: END IF;
2371: ELSE
2372: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2373: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;
2377: BSC_BIS_LOCKS_PUB.LOCK_KPI
2378: ( p_Kpi_Id => p_Indicator

Line 2657: FND_MSG_PUB.Count_And_Get

2653: EXCEPTION
2654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2655: ROLLBACK TO Delete_Analysis_Opt_UI_PVT;
2656: IF (x_msg_data IS NULL) THEN
2657: FND_MSG_PUB.Count_And_Get
2658: ( p_encoded => FND_API.G_FALSE
2659: , p_count => x_msg_count
2660: , p_data => x_msg_data
2661: );

Line 2698: FND_MSG_PUB.Initialize;

2694: BEGIN
2695:
2696: SAVEPOINT Create_Analysis_Group_PVT;
2697: x_return_status := FND_API.G_RET_STS_SUCCESS;
2698: FND_MSG_PUB.Initialize;
2699:
2700: INSERT INTO bsc_kpi_analysis_groups (
2701: indicator,
2702: analysis_group_id,

Line 2960: FND_MSG_PUB.Count_And_Get

2956: EXCEPTION
2957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2958: ROLLBACK TO Generate_Ana_Meas_Combs_PVT;
2959: IF (x_msg_data IS NULL) THEN
2960: FND_MSG_PUB.Count_And_Get
2961: ( p_encoded => FND_API.G_FALSE
2962: , p_count => x_msg_count
2963: , p_data => x_msg_data
2964: );

Line 3091: FND_MSG_PUB.Count_And_Get

3087: EXCEPTION
3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3089: ROLLBACK TO Populate_Ana_Meas_Combs_PVT;
3090: IF (x_msg_data IS NULL) THEN
3091: FND_MSG_PUB.Count_And_Get
3092: ( p_encoded => FND_API.G_FALSE
3093: , p_count => x_msg_count
3094: , p_data => x_msg_data
3095: );

Line 3175: FND_MSG_PUB.ADD;

3171: , p_Indicator);
3172: IF l_Count = 0 THEN
3173: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3174: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
3175: FND_MSG_PUB.ADD;
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;
3178: ELSE
3179: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 3181: FND_MSG_PUB.ADD;

3177: END IF;
3178: ELSE
3179: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3180: FND_MESSAGE.SET_TOKEN('BSC_KPI',p_Indicator);
3181: FND_MSG_PUB.ADD;
3182: RAISE FND_API.G_EXC_ERROR;
3183: END IF;
3184:
3185: l_Anal_Opt_Rec.Bsc_Kpi_Id := p_Indicator;

Line 3398: FND_MSG_PUB.Count_And_Get

3394: EXCEPTION
3395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3396: ROLLBACK TO Create_Analayis_OptionObjPUB;
3397: IF (x_msg_data IS NULL) THEN
3398: FND_MSG_PUB.Count_And_Get
3399: ( p_encoded => FND_API.G_FALSE
3400: , p_count => x_msg_count
3401: , p_data => x_msg_data
3402: );

Line 3476: FND_MSG_PUB.Initialize;

3472: WHERE
3473: indicator = p_Indicator;
3474: BEGIN
3475:
3476: FND_MSG_PUB.Initialize;
3477:
3478: OPEN c_Grp_Cnt(p_Analysis_Group_Id);
3479: FETCH c_Grp_Cnt INTO l_Grp_Count;
3480: CLOSE c_Grp_Cnt;

Line 3484: FND_MSG_PUB.ADD;

3480: CLOSE c_Grp_Cnt;
3481:
3482: IF p_Analysis_Group_Id = 0 AND p_Option_Id = 0 AND l_Grp_Count = 1 THEN
3483: FND_MESSAGE.SET_NAME('BSC','BSC_D_AG_AT_LEAST_ONE_AO');
3484: FND_MSG_PUB.ADD;
3485: RAISE FND_API.G_EXC_ERROR;
3486: END IF;
3487:
3488: l_Dependency01 := Get_Dependency(p_Indicator,1);

Line 3508: FND_MSG_PUB.ADD;

3504: CLOSE c_Grp_Cnt;
3505:
3506: IF (l_Next_Grp_Count > 1 AND p_Option_Id = 0) THEN
3507: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AG_DEPEN');
3508: FND_MSG_PUB.ADD;
3509: RAISE FND_API.G_EXC_ERROR;
3510: END IF;
3511: END IF;
3512:

Line 3568: FND_MSG_PUB.ADD;

3564:
3565: IF l_kpi_full_name IS NOT NULL THEN
3566: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_WEIGHT_ZERO ');
3567: FND_MESSAGE.SET_TOKEN('KPI_NAME', l_kpi_full_name);
3568: FND_MSG_PUB.ADD;
3569: RAISE FND_API.G_EXC_ERROR;
3570: END IF;
3571: END IF;
3572: END IF;

Line 3577: FND_MSG_PUB.Count_And_Get

3573:
3574: EXCEPTION
3575: WHEN FND_API.G_EXC_ERROR THEN
3576: IF (x_msg_data IS NULL) THEN
3577: FND_MSG_PUB.Count_And_Get
3578: ( p_encoded => FND_API.G_FALSE
3579: , p_count => x_msg_count
3580: , p_data => x_msg_data
3581: );

Line 3858: FND_MSG_PUB.Initialize;

3854: l_apply_color bsc_kpis_b.apply_color_flag%TYPE;
3855: BEGIN
3856: SAVEPOINT Set_Apply_Color_PVT;
3857: x_return_status := FND_API.G_RET_STS_SUCCESS;
3858: FND_MSG_PUB.Initialize;
3859:
3860: -- As of now there is place where plan benchmark can be disabled
3861: -- So this may always return true
3862: IF FND_API.To_Boolean(Check_Indicator_Plan(p_Indicator)) THEN