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_KPI_MEAS_PUB dependencies on BSC_APPS

Line 1546: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

1542: SAVEPOINT CreateBSCDimSetPMD;
1543: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Create_Dim_Set procedure');
1544: IF (p_kpi_id IS NULL) THEN
1545: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1546: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1547: FND_MSG_PUB.ADD;
1548: RAISE FND_API.G_EXC_ERROR;
1549: END IF;
1550: SELECT COUNT(*) INTO l_count

Line 1555: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

1551: FROM BSC_KPIS_B
1552: WHERE indicator = p_kpi_id;
1553: IF (l_count = 0) THEN
1554: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
1555: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1556: FND_MSG_PUB.ADD;
1557: RAISE FND_API.G_EXC_ERROR;
1558: END IF;
1559: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --varchar2(10)

Line 1838: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

1834: x_return_status := FND_API.G_RET_STS_SUCCESS;
1835: --dbms_output.PUT_LINE('Entered inside BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set procedure');
1836: IF (p_kpi_id IS NULL) THEN
1837: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1838: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1839: FND_MSG_PUB.ADD;
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:

Line 1996: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

1992: FND_MSG_PUB.Initialize;
1993: x_return_status := FND_API.G_RET_STS_SUCCESS;
1994: IF (p_kpi_id IS NULL) THEN
1995: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
1996: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
1997: FND_MSG_PUB.ADD;
1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: IF (p_dim_set_id IS NULL) THEN

Line 2002: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

1998: RAISE FND_API.G_EXC_ERROR;
1999: END IF;
2000: IF (p_dim_set_id IS NULL) THEN
2001: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2002: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2003: FND_MSG_PUB.ADD;
2004: RAISE FND_API.G_EXC_ERROR;
2005: END IF;
2006: SELECT COUNT(DIM_SET_ID)

Line 2136: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

2132: FND_MSG_PUB.Initialize;
2133: x_return_status := FND_API.G_RET_STS_SUCCESS;
2134: IF (p_kpi_id IS NULL) THEN
2135: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2136: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2137: FND_MSG_PUB.ADD;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140: IF (p_dim_set_id IS NULL) THEN

Line 2142: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140: IF (p_dim_set_id IS NULL) THEN
2141: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2142: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2143: FND_MSG_PUB.ADD;
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --number

Line 2407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

2403: FND_MSG_PUB.Initialize;
2404: x_return_status := FND_API.G_RET_STS_SUCCESS;
2405: IF (p_kpi_id IS NULL) THEN
2406: FND_MESSAGE.SET_NAME('BSC', 'BSC_REQ_FIELD_MISSING');
2407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2408: FND_MSG_PUB.ADD;
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: IF (p_dim_set_id IS NULL) THEN

Line 2413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411: IF (p_dim_set_id IS NULL) THEN
2412: FND_MESSAGE.SET_NAME('BSC', 'BSC_REQ_FIELD_MISSING');
2413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2414: FND_MSG_PUB.ADD;
2415: RAISE FND_API.G_EXC_ERROR;
2416: END IF;
2417: IF (p_dim_set_id = 0) THEN

Line 2613: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

2609: FND_MSG_PUB.Initialize;
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;
2611: IF (p_kpi_id IS NULL) THEN
2612: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2613: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617: IF (p_dim_set_id IS NULL) THEN

Line 2619: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

2615: RAISE FND_API.G_EXC_ERROR;
2616: END IF;
2617: IF (p_dim_set_id IS NULL) THEN
2618: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2619: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: END IF;
2623: SELECT

Line 2947: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

2943: FND_MSG_PUB.Initialize;
2944: x_return_status := FND_API.G_RET_STS_SUCCESS;
2945: IF (p_kpi_id IS NULL) THEN
2946: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2947: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
2948: FND_MSG_PUB.ADD;
2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: IF (p_dim_set_id IS NULL) THEN

Line 2953: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

2949: RAISE FND_API.G_EXC_ERROR;
2950: END IF;
2951: IF (p_dim_set_id IS NULL) THEN
2952: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
2953: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
2954: FND_MSG_PUB.ADD;
2955: RAISE FND_API.G_EXC_ERROR;
2956: END IF;
2957:

Line 3155: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

3151: FND_MSG_PUB.Initialize;
3152: x_return_status := FND_API.G_RET_STS_SUCCESS;
3153: IF (p_kpi_id IS NULL) THEN
3154: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3155: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
3156: FND_MSG_PUB.ADD;
3157: RAISE FND_API.G_EXC_ERROR;
3158: END IF;
3159: IF (p_dim_set_id IS NULL) THEN

Line 3161: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

3157: RAISE FND_API.G_EXC_ERROR;
3158: END IF;
3159: IF (p_dim_set_id IS NULL) THEN
3160: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3161: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
3162: FND_MSG_PUB.ADD;
3163: RAISE FND_API.G_EXC_ERROR;
3164: END IF;
3165: l_bsc_dimset_rec.Bsc_Kpi_Id := p_kpi_id; --number

Line 3673: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

3669: FND_MSG_PUB.Initialize;
3670: x_return_status := FND_API.G_RET_STS_SUCCESS;
3671: IF (p_kpi_id IS NULL) THEN
3672: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3673: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
3674: FND_MSG_PUB.ADD;
3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: IF (p_dim_set_id IS NULL) THEN

Line 3679: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);

3675: RAISE FND_API.G_EXC_ERROR;
3676: END IF;
3677: IF (p_dim_set_id IS NULL) THEN
3678: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3679: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SET_ID'), TRUE);
3680: FND_MSG_PUB.ADD;
3681: RAISE FND_API.G_EXC_ERROR;
3682: END IF;
3683: IF (p_analysis_grp_id IS NULL) THEN

Line 4205: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

4201: CLOSE c_stack_series_id;
4202: END IF;
4203: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
4204: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4205: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
4206: FND_MSG_PUB.ADD;
4207: RAISE FND_API.G_EXC_ERROR;
4208: END IF;
4209: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL) THEN

Line 4219: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);

4215: CLOSE c_data_set_id;
4216: END IF;
4217: IF (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL) THEN
4218: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4219: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);
4220: FND_MSG_PUB.ADD;
4221: RAISE FND_API.G_EXC_ERROR;
4222: END IF;
4223: SELECT COUNT(*) INTO l_count

Line 4228: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

4224: FROM BSC_KPIS_B
4225: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
4226: IF (l_count = 0) THEN
4227: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
4228: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
4229: FND_MSG_PUB.ADD;
4230: RAISE FND_API.G_EXC_ERROR;
4231: END IF;
4232: -- Verify that this is not a Shared KPI.

Line 4692: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);

4688: ELSE
4689: --dbms_output.PUT_LINE('ELSE');
4690: IF (l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name IS NULL) THEN
4691: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
4692: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);
4693: FND_MSG_PUB.ADD;
4694: RAISE FND_API.G_EXC_ERROR;
4695: END IF;
4696: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN

Line 5061: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

5057: l_Bsc_Anal_Opt_Rec.Bsc_Option_Short_Name := p_Short_Name;
5058:
5059: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
5060: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5061: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5062: FND_MSG_PUB.ADD;
5063: RAISE FND_API.G_EXC_ERROR;
5064: END IF;
5065: IF ((l_datasource = 'BSC') AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL)) THEN

Line 5067: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);

5063: RAISE FND_API.G_EXC_ERROR;
5064: END IF;
5065: IF ((l_datasource = 'BSC') AND (l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id IS NULL)) THEN
5066: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5067: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'DATASET'), TRUE);
5068: FND_MSG_PUB.ADD;
5069: RAISE FND_API.G_EXC_ERROR;
5070: END IF;
5071: SELECT COUNT(*) INTO l_count

Line 5076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

5072: FROM BSC_KPIS_B
5073: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5074: IF (l_count = 0) THEN
5075: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5076: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5077: FND_MSG_PUB.ADD;
5078: RAISE FND_API.G_EXC_ERROR;
5079: END IF;
5080: -- Verify that this is not a Shared KPI.

Line 5092: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);

5088: END IF;
5089: --dbms_output.PUT_LINE('l_datasource '||l_datasource);
5090: IF (l_Bsc_Anal_Opt_Rec.Bsc_Measure_Long_Name IS NULL) THEN
5091: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5092: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_IVIEWER', 'ANALYSIS_MS'), TRUE);
5093: FND_MSG_PUB.ADD;
5094: RAISE FND_API.G_EXC_ERROR;
5095: END IF;
5096: IF (l_Bsc_Anal_Opt_Rec.Bsc_Option_Name IS NULL) THEN

Line 5357: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);

5353: x_return_status := FND_API.G_RET_STS_SUCCESS;
5354: SAVEPOINT DeleteBSCKPIAnaOpts;
5355: IF (p_data_source IS NULL) THEN
5356: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5357: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
5358: FND_MSG_PUB.ADD;
5359: RAISE FND_API.G_EXC_ERROR;
5360: END IF;
5361: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN

Line 5391: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

5387: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id);
5388: --dbms_output.PUT_LINE('l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id '||l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id);
5389: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
5390: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5391: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5392: FND_MSG_PUB.ADD;
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;
5395:

Line 5401: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

5397: FROM BSC_KPIS_B
5398: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
5399: IF (l_count = 0) THEN
5400: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5401: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5402: FND_MSG_PUB.ADD;
5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5405: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN

Line 5407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);

5403: RAISE FND_API.G_EXC_ERROR;
5404: END IF;
5405: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
5406: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5407: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);
5408: FND_MSG_PUB.ADD;
5409: RAISE FND_API.G_EXC_ERROR;
5410: END IF;
5411: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN

Line 5413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);

5409: RAISE FND_API.G_EXC_ERROR;
5410: END IF;
5411: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
5412: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5413: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);
5414: FND_MSG_PUB.ADD;
5415: RAISE FND_API.G_EXC_ERROR;
5416: END IF;
5417: -- Verify that this is not a Shared KPI.

Line 5804: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

5800: x_return_status := FND_API.G_RET_STS_SUCCESS;
5801: FND_MSG_PUB.Initialize;
5802: IF (p_kpi_id IS NULL) THEN
5803: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
5804: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5805: FND_MSG_PUB.ADD;
5806: RAISE FND_API.G_EXC_ERROR;
5807: END IF;
5808: SELECT COUNT(*) INTO l_count

Line 5813: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

5809: FROM BSC_KPIS_B
5810: WHERE indicator = p_kpi_id;
5811: IF (l_count = 0) THEN
5812: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
5813: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
5814: FND_MSG_PUB.ADD;
5815: RAISE FND_API.G_EXC_ERROR;
5816: END IF;
5817: -- Verify that this is not a Shared KPI.

Line 6056: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_NAME'), TRUE);

6052: FND_MSG_PUB.Initialize;
6053: SAVEPOINT CreatePMDBSCKPIs;
6054: IF (p_kpi_name IS NULL) THEN
6055: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
6056: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_NAME'), TRUE);
6057: FND_MSG_PUB.ADD;
6058: RAISE FND_API.G_EXC_ERROR;
6059: END IF;
6060: IF (p_responsibility_id IS NULL) THEN

Line 6062: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SRC_RESPONSIBILITY'), TRUE);

6058: RAISE FND_API.G_EXC_ERROR;
6059: END IF;
6060: IF (p_responsibility_id IS NULL) THEN
6061: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
6062: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SRC_RESPONSIBILITY'), TRUE);
6063: FND_MSG_PUB.ADD;
6064: RAISE FND_API.G_EXC_ERROR;
6065: END IF;
6066: -- set the passed values to the record.

Line 7212: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);

7208: --dbms_output.PUT_LINE('THE COUNT OF DIMOBJECTS :- '||l_count );
7209: IF(l_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIM) THEN
7210: --dbms_output.PUT_LINE('DIMESION OBJECTS MESSAEGE' );
7211: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
7212: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7213: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7214: FND_MSG_PUB.ADD;
7215: RAISE FND_API.G_EXC_ERROR;
7216: END IF;

Line 7213: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);

7209: IF(l_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIM) THEN
7210: --dbms_output.PUT_LINE('DIMESION OBJECTS MESSAEGE' );
7211: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
7212: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7213: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7214: FND_MSG_PUB.ADD;
7215: RAISE FND_API.G_EXC_ERROR;
7216: END IF;
7217:

Line 7224: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);

7220: WHERE INDICATOR = p_Kpi_ID;
7221: IF (l_dim_set_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET ) THEN
7222: --dbms_output.PUT_LINE('FIRST dimset IF LOOP' );
7223: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7224: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7225: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END IF;

Line 7225: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);

7221: IF (l_dim_set_count > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET ) THEN
7222: --dbms_output.PUT_LINE('FIRST dimset IF LOOP' );
7223: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7224: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7225: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7226: FND_MSG_PUB.ADD;
7227: RAISE FND_API.G_EXC_ERROR;
7228: END IF;
7229: --dbms_output.PUT_LINE('DIM SET COUNT :- '||l_dim_set_count );

Line 7233: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);

7229: --dbms_output.PUT_LINE('DIM SET COUNT :- '||l_dim_set_count );
7230: IF(l_dim_set_count = BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET AND p_Dim_Set_ID IS NULL ) THEN
7231: --dbms_output.PUT_LINE('dimset IF LOOP' );
7232: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7233: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7234: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7235: FND_MSG_PUB.ADD;
7236: RAISE FND_API.G_EXC_ERROR;
7237: END IF;

Line 7234: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);

7230: IF(l_dim_set_count = BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_DIMSET AND p_Dim_Set_ID IS NULL ) THEN
7231: --dbms_output.PUT_LINE('dimset IF LOOP' );
7232: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7233: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7234: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7235: FND_MSG_PUB.ADD;
7236: RAISE FND_API.G_EXC_ERROR;
7237: END IF;
7238:

Line 7265: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);

7261: --dbms_output.PUT_LINE('THE NO OF RELATIONS ARE :- '||l_no_rels );
7262: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
7263: --dbms_output.PUT_LINE('RELATIONS MESSAGE' );
7264: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7265: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7266: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7267: FND_MSG_PUB.ADD;
7268: RAISE FND_API.G_EXC_ERROR;
7269: END IF;

Line 7266: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);

7262: IF(l_no_rels > BSC_BIS_KPI_MEAS_PUB.CONFIG_LIMIT_RELS) THEN
7263: --dbms_output.PUT_LINE('RELATIONS MESSAGE' );
7264: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SUMMARY_LVL');
7265: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
7266: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
7267: FND_MSG_PUB.ADD;
7268: RAISE FND_API.G_EXC_ERROR;
7269: END IF;
7270: IF(cr_dim_objs_in_dimset %ISOPEN) THEN

Line 7477: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);

7473: FND_MSG_PUB.Initialize;
7474: x_return_status := FND_API.G_RET_STS_SUCCESS;
7475: IF (p_data_source IS NULL) THEN
7476: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7477: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DATA_SOURCE'), TRUE);
7478: FND_MSG_PUB.ADD;
7479: RAISE FND_API.G_EXC_ERROR;
7480: END IF;
7481: IF ((p_data_source <> 'BSC') AND (p_data_source <> 'PMF')) THEN

Line 7507: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

7503: END IF;
7504:
7505: IF (l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id IS NULL) THEN
7506: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7507: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
7508: FND_MSG_PUB.ADD;
7509: RAISE FND_API.G_EXC_ERROR;
7510: END IF;
7511:

Line 7517: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);

7513: FROM BSC_KPIS_B
7514: WHERE indicator = l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id;
7515: IF (l_count = 0) THEN
7516: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
7517: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_ID'), TRUE);
7518: FND_MSG_PUB.ADD;
7519: RAISE FND_API.G_EXC_ERROR;
7520: END IF;
7521: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN

Line 7523: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);

7519: RAISE FND_API.G_EXC_ERROR;
7520: END IF;
7521: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Option_Id IS NULL) THEN
7522: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7523: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_OPTIONS'), TRUE);
7524: FND_MSG_PUB.ADD;
7525: RAISE FND_API.G_EXC_ERROR;
7526: END IF;
7527: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN

Line 7529: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);

7525: RAISE FND_API.G_EXC_ERROR;
7526: END IF;
7527: IF (l_Bsc_Anal_Opt_Rec.Bsc_Analysis_Group_Id IS NULL) THEN
7528: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
7529: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'ANALYSIS_GROUP'), TRUE);
7530: FND_MSG_PUB.ADD;
7531: RAISE FND_API.G_EXC_ERROR;
7532: END IF;
7533: