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.

[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on FND_API

Line 2573: l_commit := FND_API.G_FALSE;

2569: --DBMS_OUTPUT.PUT_LINE('4. Refreshed the KPI Defaults');
2570:
2571: -- Update the kpi timestamp
2572: my_kpi_Record.Bsc_Kpi_Id := p_indicator;
2573: l_commit := FND_API.G_FALSE;
2574: BSC_KPI_PUB.Update_Kpi_Time_Stamp( l_commit,my_kpi_Record,l_return_status,l_msg_count,l_msg_data);
2575:
2576: -- Not change in the status
2577: IF p_newflag = h_currentFlag THEN

Line 2934: p_commit IN VARCHAR2 := FND_API.G_FALSE

2930: -- will be inserted.
2931: ************************************************************************************/
2932:
2933: PROCEDURE Copy_Objective_Record (
2934: p_commit IN VARCHAR2 := FND_API.G_FALSE
2935: , p_DbLink_Name IN VARCHAR2
2936: , p_Table_Name IN VARCHAR2
2937: , p_Table_column IN VARCHAR2
2938: , p_Source_Value IN NUMBER

Line 3015: IF (p_commit = FND_API.G_TRUE) THEN

3011:
3012: EXECUTE IMMEDIATE l_sql;
3013: END IF;
3014:
3015: IF (p_commit = FND_API.G_TRUE) THEN
3016: COMMIT;
3017: END IF;
3018:
3019: EXCEPTION

Line 3020: WHEN FND_API.G_EXC_ERROR THEN

3016: COMMIT;
3017: END IF;
3018:
3019: EXCEPTION
3020: WHEN FND_API.G_EXC_ERROR THEN
3021: ROLLBACK TO BscCopyObjRecordPub;
3022: IF (x_msg_data IS NULL) THEN
3023: FND_MSG_PUB.Count_And_Get
3024: ( p_encoded => FND_API.G_FALSE

Line 3024: ( p_encoded => FND_API.G_FALSE

3020: WHEN FND_API.G_EXC_ERROR THEN
3021: ROLLBACK TO BscCopyObjRecordPub;
3022: IF (x_msg_data IS NULL) THEN
3023: FND_MSG_PUB.Count_And_Get
3024: ( p_encoded => FND_API.G_FALSE
3025: , p_count => x_msg_count
3026: , p_data => x_msg_data
3027: );
3028: END IF;

Line 3029: x_return_status := FND_API.G_RET_STS_ERROR;

3025: , p_count => x_msg_count
3026: , p_data => x_msg_data
3027: );
3028: END IF;
3029: x_return_status := FND_API.G_RET_STS_ERROR;
3030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3031: ROLLBACK TO BscCopyObjRecordPub;
3032: IF (x_msg_data IS NULL) THEN
3033: FND_MSG_PUB.Count_And_Get

Line 3030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3026: , p_data => x_msg_data
3027: );
3028: END IF;
3029: x_return_status := FND_API.G_RET_STS_ERROR;
3030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3031: ROLLBACK TO BscCopyObjRecordPub;
3032: IF (x_msg_data IS NULL) THEN
3033: FND_MSG_PUB.Count_And_Get
3034: ( p_encoded => FND_API.G_FALSE

Line 3034: ( p_encoded => FND_API.G_FALSE

3030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3031: ROLLBACK TO BscCopyObjRecordPub;
3032: IF (x_msg_data IS NULL) THEN
3033: FND_MSG_PUB.Count_And_Get
3034: ( p_encoded => FND_API.G_FALSE
3035: , p_count => x_msg_count
3036: , p_data => x_msg_data
3037: );
3038: END IF;

Line 3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3035: , p_count => x_msg_count
3036: , p_data => x_msg_data
3037: );
3038: END IF;
3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3040: WHEN NO_DATA_FOUND THEN
3041: ROLLBACK TO BscCopyObjRecordPub;
3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043: IF (x_msg_data IS NOT NULL) THEN

Line 3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3038: END IF;
3039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3040: WHEN NO_DATA_FOUND THEN
3041: ROLLBACK TO BscCopyObjRecordPub;
3042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3043: IF (x_msg_data IS NOT NULL) THEN
3044: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Copy_Objective_Record ';
3045: ELSE
3046: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';

Line 3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3046: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';
3047: END IF;
3048: WHEN OTHERS THEN
3049: ROLLBACK TO BscCopyObjRecordPub;
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051: IF (x_msg_data IS NOT NULL) THEN
3052: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Copy_Objective_Record ';
3053: ELSE
3054: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Copy_Objective_Record ';

Line 3094: p_commit IN VARCHAR2 := FND_API.G_FALSE

3090: -- copying from the base language entry
3091: ************************************************************************************/
3092:
3093: PROCEDURE Process_TL_Table (
3094: p_commit IN VARCHAR2 := FND_API.G_FALSE
3095: , p_DbLink_Name IN VARCHAR2
3096: , p_Table_Name IN VARCHAR2
3097: , p_Table_column IN VARCHAR2
3098: , p_Target_Value IN NUMBER

Line 3259: IF (p_commit = FND_API.G_TRUE) THEN

3255: END IF;
3256: END LOOP;
3257:
3258:
3259: IF (p_commit = FND_API.G_TRUE) THEN
3260: COMMIT;
3261: END IF;
3262:
3263: EXCEPTION

Line 3264: WHEN FND_API.G_EXC_ERROR THEN

3260: COMMIT;
3261: END IF;
3262:
3263: EXCEPTION
3264: WHEN FND_API.G_EXC_ERROR THEN
3265: ROLLBACK TO BscProcessTLTableInfo;
3266: IF (x_msg_data IS NULL) THEN
3267: FND_MSG_PUB.Count_And_Get
3268: ( p_encoded => FND_API.G_FALSE

Line 3268: ( p_encoded => FND_API.G_FALSE

3264: WHEN FND_API.G_EXC_ERROR THEN
3265: ROLLBACK TO BscProcessTLTableInfo;
3266: IF (x_msg_data IS NULL) THEN
3267: FND_MSG_PUB.Count_And_Get
3268: ( p_encoded => FND_API.G_FALSE
3269: , p_count => x_msg_count
3270: , p_data => x_msg_data
3271: );
3272: END IF;

Line 3273: x_return_status := FND_API.G_RET_STS_ERROR;

3269: , p_count => x_msg_count
3270: , p_data => x_msg_data
3271: );
3272: END IF;
3273: x_return_status := FND_API.G_RET_STS_ERROR;
3274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3275: ROLLBACK TO BscProcessTLTableInfo;
3276: IF (x_msg_data IS NULL) THEN
3277: FND_MSG_PUB.Count_And_Get

Line 3274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3270: , p_data => x_msg_data
3271: );
3272: END IF;
3273: x_return_status := FND_API.G_RET_STS_ERROR;
3274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3275: ROLLBACK TO BscProcessTLTableInfo;
3276: IF (x_msg_data IS NULL) THEN
3277: FND_MSG_PUB.Count_And_Get
3278: ( p_encoded => FND_API.G_FALSE

Line 3278: ( p_encoded => FND_API.G_FALSE

3274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3275: ROLLBACK TO BscProcessTLTableInfo;
3276: IF (x_msg_data IS NULL) THEN
3277: FND_MSG_PUB.Count_And_Get
3278: ( p_encoded => FND_API.G_FALSE
3279: , p_count => x_msg_count
3280: , p_data => x_msg_data
3281: );
3282: END IF;

Line 3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3279: , p_count => x_msg_count
3280: , p_data => x_msg_data
3281: );
3282: END IF;
3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3284: WHEN NO_DATA_FOUND THEN
3285: ROLLBACK TO BscProcessTLTableInfo;
3286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3287: IF (x_msg_data IS NOT NULL) THEN

Line 3286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3282: END IF;
3283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3284: WHEN NO_DATA_FOUND THEN
3285: ROLLBACK TO BscProcessTLTableInfo;
3286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3287: IF (x_msg_data IS NOT NULL) THEN
3288: x_msg_data := x_msg_data || p_table_name || ' ->BSC_DESIGNER_PVT.Process_TL_Table ';
3289: ELSE
3290: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';

Line 3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3290: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';
3291: END IF;
3292: WHEN OTHERS THEN
3293: ROLLBACK TO BscProcessTLTableInfo;
3294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3295: IF (x_msg_data IS NOT NULL) THEN
3296: x_msg_data := x_msg_data ||p_table_name || ' -> BSC_DESIGNER_PVT.Process_TL_Table ';
3297: ELSE
3298: x_msg_data := SQLERRM || p_table_name || ' at BSC_DESIGNER_PVT.Process_TL_Table ';

Line 3311: p_commit IN VARCHAR2 := FND_API.G_FALSE

3307: -- This API is used to copy entire bsc side metadata of an indicator via dblink
3308: -- or within the system
3309: ************************************************************************************/
3310: PROCEDURE Copy_Kpi_Metadata (
3311: p_commit IN VARCHAR2 := FND_API.G_FALSE
3312: , p_DbLink_Name IN VARCHAR2
3313: , p_Source_Indicator IN NUMBER
3314: , x_Target_Indicator OUT NOCOPY NUMBER
3315: , x_return_status OUT NOCOPY VARCHAR2

Line 3329: x_return_status := FND_API.G_RET_STS_SUCCESS;

3325: l_cursor t_cursor;
3326: BEGIN
3327:
3328: FND_MSG_PUB.Initialize;
3329: x_return_status := FND_API.G_RET_STS_SUCCESS;
3330:
3331: SAVEPOINT BscCopyKpiMetadataPub;
3332:
3333: BSC_APPS.Init_Bsc_Apps;

Line 3352: p_commit => FND_API.G_FALSE

3348: IF l_Target_Value IS NOT NULL THEN
3349: FOR i IN 1..g_num_kpi_metadata_tables LOOP
3350: IF g_kpi_metadata_tables(i).copy_type >= l_Copy_Type THEN
3351: Copy_Objective_Record (
3352: p_commit => FND_API.G_FALSE
3353: ,p_DbLink_Name => p_DbLink_Name
3354: ,p_Table_Name => g_kpi_metadata_tables(i).table_name
3355: ,p_Table_column => g_kpi_metadata_tables(i).table_column
3356: ,p_Source_Value => p_Source_Indicator

Line 3362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3358: ,x_return_status => x_return_status
3359: ,x_msg_count => x_msg_count
3360: ,x_msg_data => x_msg_data
3361: );
3362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3364: END IF;
3365:
3366: IF g_kpi_metadata_tables(i).mls_table IS NOT NULL AND

Line 3363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3359: ,x_msg_count => x_msg_count
3360: ,x_msg_data => x_msg_data
3361: );
3362: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3364: END IF;
3365:
3366: IF g_kpi_metadata_tables(i).mls_table IS NOT NULL AND
3367: g_kpi_metadata_tables(i).mls_table = bsc_utility.YES THEN

Line 3369: p_commit => FND_API.G_FALSE

3365:
3366: IF g_kpi_metadata_tables(i).mls_table IS NOT NULL AND
3367: g_kpi_metadata_tables(i).mls_table = bsc_utility.YES THEN
3368: Process_TL_Table(
3369: p_commit => FND_API.G_FALSE
3370: ,p_DbLink_Name => p_DbLink_Name
3371: ,p_Table_Name => g_kpi_metadata_tables(i).table_name
3372: ,p_Table_column => g_kpi_metadata_tables(i).table_column
3373: ,p_Target_Value => l_Target_Value

Line 3379: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

3375: ,x_return_status => x_return_status
3376: ,x_msg_count => x_msg_count
3377: ,x_msg_data => x_msg_data
3378: );
3379: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: END IF;
3382: END IF;
3383: END IF;

Line 3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3376: ,x_msg_count => x_msg_count
3377: ,x_msg_data => x_msg_data
3378: );
3379: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3381: END IF;
3382: END IF;
3383: END IF;
3384: END LOOP;

Line 3394: IF (p_commit = FND_API.G_TRUE) THEN

3390: x_Target_Indicator := l_Target_Value;
3391: END IF;
3392:
3393:
3394: IF (p_commit = FND_API.G_TRUE) THEN
3395: COMMIT;
3396: END IF;
3397:
3398: EXCEPTION

Line 3399: WHEN FND_API.G_EXC_ERROR THEN

3395: COMMIT;
3396: END IF;
3397:
3398: EXCEPTION
3399: WHEN FND_API.G_EXC_ERROR THEN
3400: ROLLBACK TO BscCopyKpiMetadataPub;
3401: IF (x_msg_data IS NULL) THEN
3402: FND_MSG_PUB.Count_And_Get
3403: ( p_encoded => FND_API.G_FALSE

Line 3403: ( p_encoded => FND_API.G_FALSE

3399: WHEN FND_API.G_EXC_ERROR THEN
3400: ROLLBACK TO BscCopyKpiMetadataPub;
3401: IF (x_msg_data IS NULL) THEN
3402: FND_MSG_PUB.Count_And_Get
3403: ( p_encoded => FND_API.G_FALSE
3404: , p_count => x_msg_count
3405: , p_data => x_msg_data
3406: );
3407: END IF;

Line 3408: x_return_status := FND_API.G_RET_STS_ERROR;

3404: , p_count => x_msg_count
3405: , p_data => x_msg_data
3406: );
3407: END IF;
3408: x_return_status := FND_API.G_RET_STS_ERROR;
3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3410: ROLLBACK TO BscCopyKpiMetadataPub;
3411: IF (x_msg_data IS NULL) THEN
3412: FND_MSG_PUB.Count_And_Get

Line 3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3405: , p_data => x_msg_data
3406: );
3407: END IF;
3408: x_return_status := FND_API.G_RET_STS_ERROR;
3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3410: ROLLBACK TO BscCopyKpiMetadataPub;
3411: IF (x_msg_data IS NULL) THEN
3412: FND_MSG_PUB.Count_And_Get
3413: ( p_encoded => FND_API.G_FALSE

Line 3413: ( p_encoded => FND_API.G_FALSE

3409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3410: ROLLBACK TO BscCopyKpiMetadataPub;
3411: IF (x_msg_data IS NULL) THEN
3412: FND_MSG_PUB.Count_And_Get
3413: ( p_encoded => FND_API.G_FALSE
3414: , p_count => x_msg_count
3415: , p_data => x_msg_data
3416: );
3417: END IF;

Line 3418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3414: , p_count => x_msg_count
3415: , p_data => x_msg_data
3416: );
3417: END IF;
3418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3419: WHEN NO_DATA_FOUND THEN
3420: ROLLBACK TO BscCopyKpiMetadataPub;
3421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3422: IF (x_msg_data IS NOT NULL) THEN

Line 3421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3417: END IF;
3418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3419: WHEN NO_DATA_FOUND THEN
3420: ROLLBACK TO BscCopyKpiMetadataPub;
3421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3422: IF (x_msg_data IS NOT NULL) THEN
3423: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3424: ELSE
3425: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';

Line 3429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3425: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3426: END IF;
3427: WHEN OTHERS THEN
3428: ROLLBACK TO BscCopyKpiMetadataPub;
3429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3430: IF (x_msg_data IS NOT NULL) THEN
3431: x_msg_data := x_msg_data || ' ->BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';
3432: ELSE
3433: x_msg_data := SQLERRM || 'BSC_DESIGNER_PVT.Copy_Kpi_Metadata ';