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

Line 987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

983: EXCEPTION
984: WHEN FND_API.G_EXC_ERROR THEN
985: rollback;
986: x_return_status := FND_API.G_RET_STS_ERROR;
987: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: rollback;
991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

988: ,p_data => x_msg_data);
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: rollback;
991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
992: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
993: ,p_data => x_msg_data);
994: WHEN NO_DATA_FOUND THEN
995: rollback;
996: x_return_status := FND_API.G_RET_STS_ERROR;

Line 997: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

993: ,p_data => x_msg_data);
994: WHEN NO_DATA_FOUND THEN
995: rollback;
996: x_return_status := FND_API.G_RET_STS_ERROR;
997: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
998: ,p_data => x_msg_data);
999: WHEN OTHERS THEN
1000: rollback;
1001: FND_MSG_PUB.Initialize;

Line 1001: FND_MSG_PUB.Initialize;

997: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
998: ,p_data => x_msg_data);
999: WHEN OTHERS THEN
1000: rollback;
1001: FND_MSG_PUB.Initialize;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1004: ,p_data => x_msg_data);
1005:

Line 1003: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

999: WHEN OTHERS THEN
1000: rollback;
1001: FND_MSG_PUB.Initialize;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1004: ,p_data => x_msg_data);
1005:
1006: end get_system_timestamp;
1007:

Line 1020: FND_MSG_PUB.Initialize;

1016: l_count number;
1017:
1018: begin
1019:
1020: FND_MSG_PUB.Initialize;
1021:
1022: select userenv('SESSIONID')
1023: into l_session_id
1024: from dual;

Line 1051: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1047: EXCEPTION
1048: WHEN FND_API.G_EXC_ERROR THEN
1049: rollback;
1050: x_return_status := FND_API.G_RET_STS_ERROR;
1051: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1052: ,p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: rollback;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1052: ,p_data => x_msg_data);
1053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1054: rollback;
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1057: ,p_data => x_msg_data);
1058: WHEN NO_DATA_FOUND THEN
1059: rollback;
1060: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1061: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1057: ,p_data => x_msg_data);
1058: WHEN NO_DATA_FOUND THEN
1059: rollback;
1060: x_return_status := FND_API.G_RET_STS_ERROR;
1061: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1062: ,p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: rollback;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1066: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

1062: ,p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: rollback;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1067: ,p_data => x_msg_data);
1068:
1069: end get_session_error;
1070:

Line 1166: FND_MSG_PUB.Add;

1162: if (p_error_tbl(l_count).error_token3 is not null) then
1163: FND_MESSAGE.SET_TOKEN(p_error_tbl(l_count).error_token3, p_error_tbl(l_count).error_value3);
1164: end if;
1165:
1166: FND_MSG_PUB.Add;
1167: END LOOP;
1168: -- Fix for 2332823
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count,

Line 1169: FND_MSG_PUB.Count_And_Get

1165:
1166: FND_MSG_PUB.Add;
1167: END LOOP;
1168: -- Fix for 2332823
1169: FND_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count,
1171: p_data => x_msg_data
1172: );
1173: /*

Line 1797: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1793: RETURN l_ret_val;
1794:
1795: EXCEPTION
1796: WHEN FND_API.G_EXC_ERROR THEN
1797: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1798: ,p_data => l_msg_data);
1799: RAISE;
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1801: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1797: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1798: ,p_data => l_msg_data);
1799: RAISE;
1800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1801: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1802: ,p_data => l_msg_data);
1803: RAISE;
1804: WHEN NO_DATA_FOUND THEN
1805: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1805: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1801: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1802: ,p_data => l_msg_data);
1803: RAISE;
1804: WHEN NO_DATA_FOUND THEN
1805: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1806: ,p_data => l_msg_data);
1807: RAISE;
1808: WHEN OTHERS THEN
1809: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

Line 1809: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count

1805: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1806: ,p_data => l_msg_data);
1807: RAISE;
1808: WHEN OTHERS THEN
1809: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1810: ,p_data => l_msg_data);
1811: RAISE;
1812: END Get_Default_Internal_Name;
1813:

Line 2073: FND_MSG_PUB.Initialize;

2069: l_temp_snames VARCHAR2(2000);
2070: l_dim_sname VARCHAR2(30);
2071: l_dim_obj_sname VARCHAR2(30);
2072: BEGIN
2073: FND_MSG_PUB.Initialize;
2074: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2075:
2076: IF ((p_Entity_Short_Names IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN
2077: RETURN;

Line 2140: FND_MSG_PUB.Count_And_Get

2136:
2137: EXCEPTION
2138: WHEN OTHERS THEN
2139: IF (x_msg_data IS NULL) THEN
2140: FND_MSG_PUB.Count_And_Get
2141: ( p_encoded => FND_API.G_FALSE
2142: , p_count => x_msg_count
2143: , p_data => x_msg_data
2144: );

Line 2318: FND_MSG_PUB.Initialize;

2314: l_tmp_EntityName VARCHAR2(4000);
2315: l_Return_Msg VARCHAR2(30);
2316: BEGIN
2317: -- pick the name if it is null.
2318: FND_MSG_PUB.Initialize;
2319: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: IF ((p_Entity_Short_Name IS NULL) OR (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_FALSE)) THEN
2322: RETURN;

Line 2342: FND_MSG_PUB.ADD;

2338: l_tmp_EntityName := p_Entity_Name;
2339: END IF;
2340: FND_MESSAGE.SET_NAME('BIS','BIS_DIMOBJ_ASSIGN_PERIODS');
2341: FND_MESSAGE.SET_TOKEN('DIMOBJ', l_tmp_EntityName);
2342: FND_MSG_PUB.ADD;
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: END IF;
2345:
2346: ELSIF (p_Entity_Type = c_DIMENSION) THEN

Line 2360: FND_MSG_PUB.ADD;

2356: l_tmp_EntityName := p_Entity_Name;
2357: END IF;
2358: FND_MESSAGE.SET_NAME('BIS','BIS_DIM_ASSIGN_PERIODS');
2359: FND_MESSAGE.SET_TOKEN('DIM', l_tmp_EntityName);
2360: FND_MSG_PUB.ADD;
2361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2362: END IF;
2363:
2364: l_Return_Msg := Is_Internal_Dim(p_Entity_Short_Name);

Line 2374: FND_MSG_PUB.ADD;

2370: l_tmp_EntityName := p_Entity_Name;
2371: END IF;
2372: FND_MESSAGE.SET_NAME('BIS',l_Return_Msg);
2373: FND_MESSAGE.SET_TOKEN('DIM', l_tmp_EntityName);
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2376: END IF;
2377:
2378: END IF;

Line 2383: FND_MSG_PUB.Count_And_Get

2379:
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF (x_msg_data IS NULL) THEN
2383: FND_MSG_PUB.Count_And_Get
2384: ( p_encoded => FND_API.G_FALSE
2385: , p_count => x_msg_count
2386: , p_data => x_msg_data
2387: );

Line 2407: FND_MSG_PUB.Initialize;

2403: l_Short_Name VARCHAR2(100);
2404: l_temp_snames VARCHAR2(2000);
2405: l_Return_Msg VARCHAR2(100);
2406: BEGIN
2407: FND_MSG_PUB.Initialize;
2408:
2409: l_temp_snames := p_Dim_Short_Names;
2410: WHILE (Is_More(l_temp_snames, l_Short_Name)) LOOP
2411: l_Return_Msg := Is_Internal_WKPI_Dim(l_Short_Name);

Line 2416: FND_MSG_PUB.ADD;

2412: IF (l_Return_Msg IS NOT NULL) THEN
2413: l_Entity_Name := Get_Name(c_DIMENSION, l_Short_Name);
2414: FND_MESSAGE.SET_NAME('BIS',l_Return_Msg);
2415: FND_MESSAGE.SET_TOKEN('DIM', l_Entity_Name);
2416: FND_MSG_PUB.ADD;
2417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2418: END IF;
2419: END LOOP;
2420:

Line 2424: FND_MSG_PUB.Count_And_Get

2420:
2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: IF (x_msg_data IS NULL) THEN
2424: FND_MSG_PUB.Count_And_Get
2425: ( p_encoded => FND_API.G_FALSE
2426: , p_count => x_msg_count
2427: , p_data => x_msg_data
2428: );

Line 2538: FND_MSG_PUB.Initialize;

2534: l_count NUMBER := 0;
2535: TYPE ref_cur IS REF CURSOR;
2536: c_regions_dim_obj ref_cur;
2537: BEGIN
2538: FND_MSG_PUB.Initialize;
2539: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
2540: IF (p_Short_Names IS NOT NULL) THEN
2541: x_region_codes := FND_TABLE_OF_VARCHAR2_30();
2542: l_sql := 'SELECT DISTINCT REGION_CODE FROM ak_region_items WHERE node_query_flag = ''Y'' AND node_display_flag = ''N'' AND SUBSTR(attribute2,INSTR(attribute2,''+'') +1 ,LENGTH(attribute2)) IN (' ;

Line 2565: FND_MSG_PUB.Count_And_Get

2561: END IF;
2562: EXCEPTION
2563: WHEN OTHERS THEN
2564: IF (x_msg_data IS NULL) THEN
2565: FND_MSG_PUB.Count_And_Get
2566: ( p_encoded => FND_API.G_FALSE
2567: , p_count => x_msg_count
2568: , p_data => x_msg_data
2569: );

Line 2817: FND_MSG_PUB.ADD;

2813: IF (l_Function_Parameter IS NULL) THEN
2814: -- BIS_PLSQL_INVALID_PARAMETERS
2815: -- The PL/SQL Function provided has been defined with invalid parameters
2816: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_INVALID_PARAMETERS');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2819: END IF;
2820: */
2821:

Line 2839: FND_MSG_PUB.ADD;

2835: IF ((l_Parameter_1 IS NULL) AND
2836: (l_Parameter_2 IS NULL) AND
2837: (l_Parameter_3 IS NULL)) THEN
2838: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_INVALID_FUNC_NAME');
2839: FND_MSG_PUB.ADD;
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842:
2843: /*

Line 2870: FND_MSG_PUB.ADD;

2866: -- BIS_ERR_OBTAIN_RPT_QUERY - There was an error when extracting Report Query using the Default
2867: -- parameter values. Please verify if your PL/SQL API returns a SQL for the default parameters.
2868: IF ((x_Return_Status <> FND_API.G_RET_STS_SUCCESS) OR (l_Custom_Sql IS NULL)) THEN
2869: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_OBTAIN_RPT_QUERY');
2870: FND_MSG_PUB.ADD;
2871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2872: END IF;
2873:
2874: BSC_UTILITY.Validate_Sql_String (

Line 2887: FND_MSG_PUB.ADD;

2883: -- error(s) : ERROR
2884: IF (x_Return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
2885: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_WITH_REPORT_SQL');
2886: FND_MESSAGE.SET_TOKEN('ERROR', x_Msg_Data);
2887: FND_MSG_PUB.ADD;
2888: x_Msg_Data := NULL;
2889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2890: END IF;
2891:

Line 2901: FND_MSG_PUB.ADD;

2897: -- the number of columns required to run the report for default parameters. Please review the
2898: -- PL/SQL procedure.
2899: IF ((l_Custom_Cols IS NULL) OR (l_Custom_Cols <> l_View_Cols)) THEN
2900: FND_MESSAGE.SET_NAME('BIS','BIS_ERR_COLS_RPT_MISMATCH');
2901: FND_MSG_PUB.ADD;
2902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2903: END IF;
2904:
2905: -- Finally the PL/SQL is OK - return that the PL/SQL has passed the validation.

Line 2908: FND_MSG_PUB.ADD;

2904:
2905: -- Finally the PL/SQL is OK - return that the PL/SQL has passed the validation.
2906: IF ((x_Return_Status = FND_API.G_RET_STS_SUCCESS) OR (x_Msg_Data IS NULL)) THEN
2907: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PACKAGE_IS_VALID');
2908: FND_MSG_PUB.ADD;
2909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2910: END IF;
2911:
2912: EXCEPTION

Line 2915: FND_MSG_PUB.Count_And_Get

2911:
2912: EXCEPTION
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: IF (x_msg_data IS NULL) THEN
2915: FND_MSG_PUB.Count_And_Get
2916: ( p_encoded => FND_API.G_FALSE
2917: , p_count => x_msg_count
2918: , p_data => x_msg_data
2919: );

Line 2924: FND_MSG_PUB.Count_And_Get

2920: END IF;
2921: x_Return_Status := FND_API.G_RET_STS_ERROR;
2922: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2923: IF (x_msg_data IS NULL) THEN
2924: FND_MSG_PUB.Count_And_Get
2925: ( p_encoded => FND_API.G_FALSE
2926: , p_count => x_msg_count
2927: , p_data => x_msg_data
2928: );

Line 3136: FND_MSG_PUB.ADD;

3132: -- BIS_PLSQL_INVALID_FUNC_NAME
3133: -- The PL/SQL "Package_Name.Function_Name" specification is incorrect or does not exist.
3134: IF (INSTR(p_Plsql_Function, '.') = 0) THEN
3135: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_INVALID_FUNC_NAME');
3136: FND_MSG_PUB.ADD;
3137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3138: END IF;
3139:
3140: l_Package_Name := UPPER(SUBSTR(p_Plsql_Function, 1, INSTR(p_Plsql_Function, '.')-1));

Line 3153: FND_MSG_PUB.ADD;

3149: -- BIS_PLSQL_PKG_NOT_EXIST
3150: -- The PL/SQL procedure or function does not exist in the database
3151: IF (l_Count = 0) THEN
3152: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PKG_NOT_EXIST');
3153: FND_MSG_PUB.ADD;
3154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3155: END IF;
3156:
3157: SELECT COUNT(1) INTO l_Count

Line 3166: FND_MSG_PUB.ADD;

3162: -- BIS_PLSQL_PKG_NOT_EXIST
3163: -- The PL/SQL package has errors.
3164: IF (l_Count <> 0) THEN
3165: FND_MESSAGE.SET_NAME('BIS','BIS_PLSQL_PKG_HAS_ERRORS');
3166: FND_MSG_PUB.ADD;
3167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3168: END IF;
3169:
3170: EXCEPTION

Line 3173: FND_MSG_PUB.Count_And_Get

3169:
3170: EXCEPTION
3171: WHEN FND_API.G_EXC_ERROR THEN
3172: IF (x_msg_data IS NULL) THEN
3173: FND_MSG_PUB.Count_And_Get
3174: ( p_encoded => FND_API.G_FALSE
3175: , p_count => x_msg_count
3176: , p_data => x_msg_data
3177: );

Line 3182: FND_MSG_PUB.Count_And_Get

3178: END IF;
3179: x_Return_Status := FND_API.G_RET_STS_ERROR;
3180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3181: IF (x_msg_data IS NULL) THEN
3182: FND_MSG_PUB.Count_And_Get
3183: ( p_encoded => FND_API.G_FALSE
3184: , p_count => x_msg_count
3185: , p_data => x_msg_data
3186: );

Line 3250: FND_MSG_PUB.Initialize;

3246: l_Sql VARCHAR2(8192);
3247: l_Comparison_Type VARCHAR2(30);
3248: l_Measure_Columns VARCHAR2(4096);
3249: BEGIN
3250: FND_MSG_PUB.Initialize;
3251: l_Table_Count := 0;
3252: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3253:
3254: BSC_UTILITY.Parse_String

Line 3526: FND_MSG_PUB.Count_And_Get

3522:
3523: EXCEPTION
3524: WHEN FND_API.G_EXC_ERROR THEN
3525: IF (x_msg_data IS NULL) THEN
3526: FND_MSG_PUB.Count_And_Get
3527: ( p_encoded => FND_API.G_FALSE
3528: , p_count => x_msg_count
3529: , p_data => x_msg_data
3530: );

Line 3535: FND_MSG_PUB.Count_And_Get

3531: END IF;
3532: x_Return_Status := FND_API.G_RET_STS_ERROR;
3533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3534: IF (x_msg_data IS NULL) THEN
3535: FND_MSG_PUB.Count_And_Get
3536: ( p_encoded => FND_API.G_FALSE
3537: , p_count => x_msg_count
3538: , p_data => x_msg_data
3539: );

Line 3637: FND_MSG_PUB.Initialize;

3633: AND A.OWNER = BSC_APPS.get_user_schema(C_PACKAGE_OWNER)
3634: ORDER BY A.COLUMN_NAME;
3635:
3636: BEGIN
3637: FND_MSG_PUB.Initialize;
3638: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3639:
3640: -- Bug#5034549; Added ABS() to DBMS_UTILITY.GET_TIME, since it can return negative value
3641: l_Temp_View_Name := 'BIS_TMP_' || TO_CHAR(SYSDATE,'J')||ABS(DBMS_UTILITY.GET_TIME) || '_V';